Guriddo » Topic: safe mysql-data in data attribute

safe mysql-data in data attribute

Guriddo
safe mysql-data in data attribute

This topic has 11 replies, 3 voices, and was last updated 11 years, 3 months ago by selfmade01.

Creator

Topic

February 11, 2015 at 1:27 am #119018

selfmade01

Participant

Hello,

sorry for my question but i can’t find it in the docs

i get datas from mysql-db

while($row = mysqli_fetch_array($result,MYSQLI_ASSOC)) {
			$responce-&gt;rows[$i][&#039;id&#039;]=$row[&#039;hardwareInfoId&#039;];
			$responce-&gt;rows[$i][&#039;data-group&#039;]=$row[&#039;hardwareGroup&#039;];
			$responce-&gt;rows[$i][&#039;cell&#039;]=array($row[&#039;hardwareInfoId&#039;],$row[&#039;roomNr&#039;],$row[&#039;roomType&#039;],$row[&#039;nlContainerTypeName&#039;],$row[&#039;Type&#039;],$row[&#039;hardwareTypeName&#039;],$row[&#039;description&#039;],$row[&#039;hardwareGroup&#039;] );
			$i++;
			}
			echo json_encode($responce);

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

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

$responce->rows[$i]['data-group']=$row['hardwareGroup'];

$responce->rows[$i]['cell']=array($row['hardwareInfoId'],$row['roomNr'],$row['roomType'],$row['nlContainerTypeName'],$row['Type'],$row['hardwareTypeName'],$row['description'],$row['hardwareGroup'] );

$i++;

}

echo json_encode($responce);

how i can get the data-group in my ajax-section?

i get my datas in datatype: json,

and

colNames:[ &#039; &#039;, &#039;&lt;?=_(&quot;Room Nr.&quot;);?&gt;&#039;,&#039;&lt;?=_(&quot;Room Type&quot;);?&gt;&#039;, &#039;&lt;?=_(&quot;Container type&quot;);?&gt;&#039;, 
								&#039;&lt;?=_(&quot;type&quot;);?&gt;&#039;,
								&#039;&lt;?=_(&quot;Hardware type&quot;);?&gt;&#039;,
								&#039;&lt;?=_(&quot;Description&quot;);?&gt;&#039;
								//&#039;&lt;?=_(&quot;group&quot;);?&gt;&#039;
								],
					colModel:[
					// {  name: &#039;group&#039;, key: true, width: 75, hidden: true },
						{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},
							}
						},
						
						{name:&#039;roomNr&#039;,index:&#039;roomNr&#039;, width:30, sorttype:&quot;int&quot;, edittype:&quot;select&quot;,  editable: true, 
.
.
.

colNames:[ ' ', '<?=_("Room Nr.");?>','<?=_("Room Type");?>', '<?=_("Container type");?>',

'<?=_("type");?>',

'<?=_("Hardware type");?>',

'<?=_("Description");?>'

//'<?=_("group");?>'

colModel:[

// { name: 'group', key: true, width: 75, hidden: true },

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

formatter:'actions',

formatoptions:{

keys:true,

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

}

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

i would like add the data-group to my gridtabel-tows

if i add in ColModel,as hidden thats not possible, then is different from ColNames

sorry, i searching a lot in your docs and google but i can not find, how i can catch some datas they are get from my mysql-db

i find only ways to safe as hidden, but then i have also put a name to ColModels.

thats the reason why i would like put a data-attribute with my groupid to the gridtable

Please help

Thanks

Best regards
Achim

Creator

Topic

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

Author

Replies

February 11, 2015 at 10:42 pm #119078

selfmade01

Participant

now i tested with this sample

$(grid_selector).on(&#039;jqGridLoadComplete&#039;, function ( data ) {
					var $this = $(this);
						data.rows.forEach( function ( row, i ) {
						$this.find(&#039;tr&#039;).eq(i).data(&#039;group&#039;, row[&#039;data-group&#039;]);
						});
					});

$(grid_selector).on('jqGridLoadComplete', function ( data ) {

var $this = $(this);

data.rows.forEach( function ( row, i ) {

$this.find('tr').eq(i).data('group', row['data-group']);

});

i will describe new my problem.

1) i would like add a data-attribute in each row “data-group”
2) i would like add to this data-group attribute a groupid, this i groupid i get it from json-string, the key-name there is also data-group,
3) if i klick to the expand butto to show my subgrid i would like get the groupid from my data-group-attribute

sorry, mysqlf and others ( i ask other programmers too) dont’t find any way in the jqgrid-docu to add any user data-attributes with values of any key as the josn-string to the row in the tables…

we read a lot but we don’t find it… sorry

please give any help

Thanks

best regards

achim

February 12, 2015 at 10:58 am #119114

selfmade01

Participant

Hello
i added now this jquery code, this works.
But i don’t know if this the right way to do this.

please ´look.
//add in each row the data-tag “data-group” and add to data-group the groupid “row[‘data-group’]”

loadComplete : function(data) {
	data.rows.forEach( function ( row, i ) {
	var z = i + 1;
							jQuery(grid_selector).find(&#039;tr&#039;).eq(z).attr(&#039;data-group&#039;, row[&#039;data-group&#039;]);
						});
},

loadComplete : function(data) {

data.rows.forEach( function ( row, i ) {

var z = i + 1;

jQuery(grid_selector).find('tr').eq(z).attr('data-group', row['data-group']);

});

if i expand the subgrgrid then i need the groupid with this way

subGridRowExpanded: function (subgridDivId, rowId) {
	var dataGroup = $(&quot;#&quot;+rowId).data(&#039;group&#039;);
       // now i get in dataGroup the groupid
.
.
.
.

subGridRowExpanded: function (subgridDivId, rowId) {

var dataGroup = $("#"+rowId).data('group');

// now i get in dataGroup the groupid

best regards
Achim

February 16, 2015 at 10:47 am #119668

guriddo.support

Participant

Hello,

You may need to look at rowattr event to add a row attributes. The docs are here

Kind Regards,

Bojan

Guriddo Support Team

February 16, 2015 at 6:07 pm #119671

selfmade01

Participant

hello,

thanks a lot. I found it already.
Now i can work with jqgrid better and better…
sorry all, for my lot questions

One little question more please.

If is possible to put a function in a colModel with that features ===>
– if i show a grid-table, and i don’t reloaded then i would like see maybe all 5 minutes a update for this one ColModel Cell.

i have a database, they get all few minutes new data from temp-sensors, and i would like ask this table about new values, but only for this one cell in my colModel

best regards

Achim

February 16, 2015 at 7:01 pm #119672

selfmade01

Participant

sorry,

i found the solution
thanks

best regards
Achim

February 18, 2015 at 10:05 am #119783

guriddo.support

Participant

Hello,

It is a good if you tell us how you resolved the problem.

This will help maybe other users.

Thank you.

Kind Regards,

Bojan

Guriddo Support Team

February 19, 2015 at 12:26 am #119802

selfmade01

Participant

Hello,

i found setInterval. Thats enough for me.
i can reload with interval the hole grid.
Bevor i looking for interval reload only for a cell, but this way with setInterval is also ok.

One Question:

i get my data in json-format.
i was looking for set custom-tooltip.
normal i see in the docs i can use rowObject. but if i use json-data then i don’t get the key-names of the array.
i get only
rowObject[12] and not rowObject[‘mykeyname’].

if there any way to get the rowobjekt with key-names if i use json-data ?

best regards
Achim

February 20, 2015 at 12:21 pm #120002

guriddo.support

Participant

Hello,

You may need to look for cellattr event for this purpose.

Kind Regards,

Bojan

Guriddo Support Team

February 22, 2015 at 11:06 am #120551

selfmade01

Participant

Hello,

yes, i know the cellattr event and i use this. But with my json-data don’t work keynames in tooltips. I get only “undefined”

look please my code

{name:&#039;containerNr&#039;,index:&#039;containerNr&#039;,align: &quot;center&quot;, width:60, sorttype:&quot;text&quot;, edittype:&quot;select&quot;,  editable: true, 
editoptions:{dataUrl:&#039;incl/getNlContainerTypeName.php?func=Nr&#039;}, 
cellattr: function (rowId, val, rawObject, cm, rdata) {
										return &#039;title=&quot;&lt;?=_(&quot;Container Nr. &quot;);?&gt;&#039; + rawObject.containerNr + &#039; &lt;?=_(&quot;in room&quot;);?&gt; &#039; + rawObject.roomNr + &#039;&quot; class=&quot;my-tooltip-test tooltip-info&quot; data-rel=&quot;tooltip&quot;&#039;;

{name:'containerNr',index:'containerNr',align: "center", width:60, sorttype:"text", edittype:"select", editable: true,

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

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

return 'title="<?=_("Container Nr. ");?>' + rawObject.containerNr + ' <?=_("in room");?> ' + rawObject.roomNr + '" class="my-tooltip-test tooltip-info" data-rel="tooltip"';

i get this output

“Container Nr. undefined in Room undefined”
if i use
rawObject[12] or other key-numbers from my rawobject-data-array then works, but this is not clear to read in my code if i have to use this way.

best regards and many thanks for help

Achim
}},

February 23, 2015 at 12:22 pm #120635