Guriddo » Topic: add to colum3 if edit colum1

add to colum3 if edit colum1

Guriddo
add to colum3 if edit colum1

This topic has 5 replies, 2 voices, and was last updated 11 years ago by tony.

Creator

Topic

March 27, 2015 at 7:51 pm #123674

selfmade01

Participant

Hello,
sorry, i start now a new thread, mybe is interested for other users too.

i would like add a <option> list (loaded by ajax) to a colum3 if i edit colum1
this works fine if i use only <input> field, but now i would like add a complete new <option> list

Please look my code

{name:&#039;roomNr&#039;,index:&#039;roomNr&#039;, width:30, sorttype:&quot;int&quot;, edittype:&quot;select&quot;,  editable: true, 
editoptions:{dataUrl:&#039;incl/getData/getRoomData.php?data=tableSectionRoomNr&#039;, 
	dataEvents: [{ type: &#039;change&#039;, fn: function(e) {
	var selected = $(this).find(&#039;option:selected&#039;);
	var selectedRowId = $(grid_selector).jqGrid (&#039;getGridParam&#039;, &#039;selrow&#039;);
	var extra = selected.data(&#039;type&#039;); 							               $(&#039;input#roomType&#039;).val(extra);
	   } }]}},						
// this works fine if i change the roomNr, then add a new roomType to colum-roomType						 
{name:&#039;roomType&#039;,index:&#039;roomType&#039;, width:65,editable: true},

// now i work with this option.... i get there a &lt;option&gt;field from a ajax-call...
but i would like change this... the nlContainerTypeName is depend on the roomNr...
if i change the roomNr,,, then i need a special option-field depend on roomnr

{name:&#039;nlContainerTypeName&#039;,index:&#039;nlContainerTypeName&#039;, width:150, sorttype:&quot;text&quot;,edittype:&quot;select&quot;, editable: true, 
	editoptions:{dataUrl:&#039;incl/getData/getNlContainerTypeName.php?func=Name&#039;},
	cellattr: function (rowId, val, rawObject, cm, rdata) {
										//alert(showProps(rawObject,&#039;test&#039;));
										return &#039;class=&quot;my-tooltip-test tooltip-warning&quot; data-rel=&quot;tooltip&quot; data-toggle=&quot;tooltip-warning&quot; data-placement=&quot;bottom&quot;&#039;;
	}
	},

{name:'roomNr',index:'roomNr', width:30, sorttype:"int", edittype:"select", editable: true,

editoptions:{dataUrl:'incl/getData/getRoomData.php?data=tableSectionRoomNr',

dataEvents: [{ type: 'change', fn: function(e) {

var selected = $(this).find('option:selected');

var selectedRowId = $(grid_selector).jqGrid ('getGridParam', 'selrow');

var extra = selected.data('type'); $('input#roomType').val(extra);

} }]}},

// this works fine if i change the roomNr, then add a new roomType to colum-roomType

{name:'roomType',index:'roomType', width:65,editable: true},

// now i work with this option.... i get there a <option>field from a ajax-call...

but i would like change this... the nlContainerTypeName is depend on the roomNr...

if i change the roomNr,,, then i need a special option-field depend on roomnr

{name:'nlContainerTypeName',index:'nlContainerTypeName', width:150, sorttype:"text",edittype:"select", editable: true,

editoptions:{dataUrl:'incl/getData/getNlContainerTypeName.php?func=Name'},

cellattr: function (rowId, val, rawObject, cm, rdata) {

//alert(showProps(rawObject,'test'));

return 'class="my-tooltip-test tooltip-warning" data-rel="tooltip" data-toggle="tooltip-warning" data-placement="bottom"';

}

i am not sure, if is possible to add this in the dataEvent

{name:&#039;roomNr&#039;,index:&#039;roomNr&#039;, width:30, sorttype:&quot;int&quot;, edittype:&quot;select&quot;,  editable: true, 
editoptions:{dataUrl:&#039;incl/getData/getRoomData.php?data=tableSectionRoomNr&#039;, 
dataEvents: [{ type: &#039;change&#039;, fn: function(e) {
	var selected = $(this).find(&#039;option:selected&#039;);
	var selectedRowId = $(grid_selector).jqGrid (&#039;getGridParam&#039;, &#039;selrow&#039;);
	var extra = selected.data(&#039;type&#039;); 
        var roomId = selected.data(&#039;roomId&#039;);
	$(&#039;input#roomType&#039;).val(extra);
        $.ajax({
            type: &#039;POST&#039;,
            url: &#039;get_option_select_depend_on_selected_room_nr.php?roomId=&#039;+roomId,
            async: false,
            success: (function(result) {
                var myObject = myResult[0];
                ????
                //now add the complete html-code to nlContainerTypeName :)
            })
        });        

   } }]}},						
						 
						{name:&#039;roomType&#039;,index:&#039;roomType&#039;, width:65,editable: true},
						{name:&#039;nlContainerTypeName&#039;,index:&#039;nlContainerTypeName&#039;, width:150, sorttype:&quot;text&quot;,edittype:&quot;select&quot;, editable: true, 

cellattr: function (rowId, val, rawObject, cm, rdata) {
										//alert(showProps(rawObject,&#039;test&#039;));
										return &#039;class=&quot;my-tooltip-test tooltip-warning&quot; data-rel=&quot;tooltip&quot; data-toggle=&quot;tooltip-warning&quot; data-placement=&quot;bottom&quot;&#039;;
							}
						},

{name:'roomNr',index:'roomNr', width:30, sorttype:"int", edittype:"select", editable: true,

editoptions:{dataUrl:'incl/getData/getRoomData.php?data=tableSectionRoomNr',

dataEvents: [{ type: 'change', fn: function(e) {

var selected = $(this).find('option:selected');

var selectedRowId = $(grid_selector).jqGrid ('getGridParam', 'selrow');

var extra = selected.data('type');

var roomId = selected.data('roomId');

$('input#roomType').val(extra);

$.ajax({

type: 'POST',

url: 'get_option_select_depend_on_selected_room_nr.php?roomId='+roomId,

async: false,

success: (function(result) {

var myObject = myResult[0];

????

//now add the complete html-code to nlContainerTypeName :)

})

});

} }]}},

{name:'roomType',index:'roomType', width:65,editable: true},

{name:'nlContainerTypeName',index:'nlContainerTypeName', width:150, sorttype:"text",edittype:"select", editable: true,

cellattr: function (rowId, val, rawObject, cm, rdata) {

//alert(showProps(rawObject,'test'));

return 'class="my-tooltip-test tooltip-warning" data-rel="tooltip" data-toggle="tooltip-warning" data-placement="bottom"';

}

Thanks for any help

best regards
Achim

Creator

Topic

Viewing 5 replies - 1 through 5 (of 5 total)

Author

Replies

March 27, 2015 at 10:44 pm #123675

selfmade01

Participant

Hello,
this works now for me

dataEvents: [{ type: &#039;change&#039;, fn: function(e) {
								var selected = $(this).find(&#039;option:selected&#039;);
								var selectedRowId = $(grid_selector).jqGrid (&#039;getGridParam&#039;, &#039;selrow&#039;);
								var extra = selected.data(&#039;type&#039;); 
								$(&#039;input#roomType&#039;).val(extra);
								var roomId  = selected.val(); 
								$.ajax({ 
											url: &quot;incl/getData/getNlContainerTypeName.php?func=getContainerByRoom&amp;Id=&quot;+roomId,
											async: false,
											type: &quot;GET&quot;,
											dataType: &quot;html&quot;,
											success: function(ergebnis){										
											}
										}).done(function (data) {
											$(&quot;select[name=&#039;nlContainerTypeName&#039;]&quot;).empty();
											$(&quot;select[name=&#039;nlContainerTypeName&#039;]&quot;).append(data);
										});
							   } }]}},

dataEvents: [{ type: 'change', fn: function(e) {

var selected = $(this).find('option:selected');

var selectedRowId = $(grid_selector).jqGrid ('getGridParam', 'selrow');

var extra = selected.data('type');

$('input#roomType').val(extra);

var roomId = selected.val();

$.ajax({

url: "incl/getData/getNlContainerTypeName.php?func=getContainerByRoom&Id="+roomId,

async: false,

type: "GET",

dataType: "html",

success: function(ergebnis){

}

}).done(function (data) {

$("select[name='nlContainerTypeName']").empty();

$("select[name='nlContainerTypeName']").append(data);

});

} }]}},

March 28, 2015 at 10:59 am #123677

selfmade01

Participant

sorry
i have one important question more.

I can not call the rowObject with the key-names… i have to call the rowObject only with the numbers of the array

i get my grid-data in json-array from a mysql-call.
the getdata.php create the json-object like this

while($row = mysqli_fetch_array($result,MYSQLI_ASSOC)) {
			$responce-&gt;rows[$i][&#039;id&#039;]=$row[&#039;tableSectionId&#039;];
			$responce-&gt;rows[$i][&#039;cell&#039;]=array(
						$row[&#039;tableSectionId&#039;],
						$row[&#039;tableSectionName&#039;],
						$row[&#039;roomNr&#039;],
						$row[&#039;roomType&#039;],
						$row[&#039;nlContainerTypeName&#039;],
						$row[&#039;gType&#039;],
						$row[&#039;tableLength&#039;],
						$row[&#039;tableWidth&#039;],
						$row[&#039;containerNr&#039;]);
			$i++;
			}
			echo json_encode($responce);

while($row = mysqli_fetch_array($result,MYSQLI_ASSOC)) {

$responce->rows[$i]['id']=$row['tableSectionId'];

$responce->rows[$i]['cell']=array(

$row['tableSectionId'],

$row['tableSectionName'],

$row['roomNr'],

$row['roomType'],

$row['nlContainerTypeName'],

$row['gType'],

$row['tableLength'],

$row['tableWidth'],

$row['containerNr']);

$i++;

}

echo json_encode($responce);

my json-array what i get in my grid looks like this

{"page":"1","total":1,"records":"2","rows":[{"id":"1","cell":["1","Test1","1","via","Vorhalte-Container","LFS","0.00","0.00","2"]},{"id":"3","cell":["3","Test2","1","via","Vorhalte- Container","LFA","120.00","50.00","2"]}]}

if i ask now the rowObject in my js-jqgrid-section like that

var mytest= rowObject['roomNr'];
then i get undefined
if i ask
var mytest= rowObject['2'];
then i get the data…

i think, i do it wrong to create the json-object.

how i have to create this json-object to get there the key-names?

best regards
Achim

This reply was modified 11 years ago by selfmade01.

March 29, 2015 at 3:24 pm #123680

selfmade01

Participant

hello
i change my json-array from
array( $row[‘tableSectionId’], …..

to
array( “tableSectionId” => $row[‘tableSectionId’], …..

now work my rowObject with key-names

best regards

Achim

March 30, 2015 at 12:35 pm #123684

selfmade01

Participant

Hello,
sorry, i have now a new question.

How i can add some datas to the postdate, if i use inline-edit?

I test now with a lot of features, but nothing work… i think i put it in the wrong section.

Here is my code. Start in the Colmodel… i have there 3 Buttons in each row… subgrid-button, edit-button and delete-button. I use navigator-bar on the bottom too!

colModel:[

	{name:&#039;myac&#039;,index:&#039;&#039;, width:80, fixed:true, sortable:false, resize:false,
	formatter:&#039;actions&#039;, 
	 formatoptions: {
	    	keys: true,
		delOptions:{recreateForm: true, beforeShowForm:beforeDeleteCallback},
		editoptions:{beforeShowForm:beforeEditCallback, 
	 		dataEvents: [{ type: &#039;click&#039;, 
					fn: function(e) {
					alert(&quot;in click submit&quot;);
					}
                                     }]
			}
	}, 
							
	},

colModel:[

{name:'myac',index:'', width:80, fixed:true, sortable:false, resize:false,

formatter:'actions',

formatoptions: {

keys: true,

delOptions:{recreateForm: true, beforeShowForm:beforeDeleteCallback},

editoptions:{beforeShowForm:beforeEditCallback,

dataEvents: [{ type: 'click',

fn: function(e) {

alert("in click submit");

}

}]

}

the reason is why i need add some datas to postdate,
i add in some custom-select-option-tags any id’s in the data-attribut

like this

select id=&quot;1_containerTypeName&quot; class=&quot;editable&quot; role=&quot;select&quot; name=&quot;containerTypeName&quot;&gt;
&lt;option value=&quot;20&quot; data-containertypeid=&quot;4&quot; data-typeid=&quot;2&quot; data-gtype=&quot;L.F.N&quot;&gt;V-Container  Nr. 5&lt;/option&gt;
&lt;option value=&quot;21&quot; data-containertypeid=&quot;3&quot; data-typeid=&quot;4&quot; data-gtype=&quot;M.A.F&quot;&gt;Active Container  Nr. 6&lt;/option&gt;
&lt;/select&gt;

select id="1_containerTypeName" class="editable" role="select" name="containerTypeName">

<option value="20" data-containertypeid="4" data-typeid="2" data-gtype="L.F.N">V-Container Nr. 5</option>

<option value="21" data-containertypeid="3" data-typeid="4" data-gtype="M.A.F">Active Container Nr. 6</option>

</select>

if i edit the row or i do other actions, then i get only the values…

can anybody help me?

best regards
achim

March 31, 2015 at 8:06 am #123698

add to colum3 if edit colum1

Search Forum

Recent Replies

Forum Statistics

UserOnline