Guriddo » selfmade01's Replies

selfmade01

Guriddo

Forum Replies Created

Viewing 15 replies - 1 through 15 (of 32 total)

1 2 3 →

Author

Replies

March 30, 2015 at 12:35 pm in reply to: add to colum3 if edit colum1 #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 29, 2015 at 3:24 pm in reply to: add to colum3 if edit colum1 #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 28, 2015 at 10:59 am in reply to: add to colum3 if edit colum1 #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 27, 2015 at 10:44 pm in reply to: add to colum3 if edit colum1 #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 25, 2015 at 8:55 am in reply to: edit images cache problem in custom detail subgrid #123629

selfmade01

Participant

Hello,
i would like add a button in the detail content.

I add now a custom-button in this detail content.
With this reload-custom-buttom i call now the ajax-function to reload this detail-content.
This works now… i am not sure if is the right way to do this. But this works

best regards
Achim

March 24, 2015 at 7:51 pm in reply to: edit images cache problem in custom detail subgrid #123619

selfmade01

Participant

i solved the problem with

image-1-2.jpg?time=unixtimestamp

I have one question more please:

i use custum Detail subgid
like this function
subGridRowExpanded: showChildGrid,

 function showChildGrid(parentRowID, parentRowKey) {
	$.ajax({
	url: &quot;incl/getData/getInfoData.php?id=&quot;+parentRowKey+&quot;&amp;func=details&amp;table=info&quot;,
	type: &quot;POST&quot;,
	width: &quot;600&quot;,
	success: function (html) {
	$(&quot;#&quot; + parentRowID).append(html);
	}
});

}

function showChildGrid(parentRowID, parentRowKey) {

$.ajax({

url: "incl/getData/getInfoData.php?id="+parentRowKey+"&func=details&table=info",

type: "POST",

width: "600",

success: function (html) {

$("#" + parentRowID).append(html);

}

});

}

1) How i can add there a reload-button

Best regards
Achim

February 23, 2015 at 2:17 pm in reply to: safe mysql-data in data attribute #120638

selfmade01

Participant

Hello

wow, thanks a lot.
so easy it can be.
Thanks

Best regards

Achim

February 22, 2015 at 11:06 am in reply to: safe mysql-data in data attribute #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 19, 2015 at 12:26 am in reply to: safe mysql-data in data attribute #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 16, 2015 at 7:01 pm in reply to: safe mysql-data in data attribute #119672

selfmade01

Participant

sorry,

i found the solution
thanks

best regards
Achim

February 16, 2015 at 6:07 pm in reply to: safe mysql-data in data attribute #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 12, 2015 at 10:58 am in reply to: safe mysql-data in data attribute #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 11, 2015 at 10:42 pm in reply to: safe mysql-data in data attribute #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 9, 2015 at 4:22 pm in reply to: call function with jqgrid php #118924

selfmade01

Participant

sorry
i describe wrong the problem

i mean this way

$grid->setGridEvent(‘loadComplete’, $load);
i think that is the way to call a javascript function written in php-Herodec or?

my problem is to understand some ways to put the Events in some php-statements
like $grid->setGridEvent or $grid->setNavEvent

best regards
Achim

February 4, 2015 at 12:25 am in reply to: grid as subgrid with option fields #117899

selfmade01

Participant

ok now i found the way to set hidden

i set now in my colmodel.

i thought it’s enough to set in the $param-array of setColModel, but i have to set in the $models-array

$grid->setColModel($model, $params,$labels );

Author

Replies

Viewing 15 replies - 1 through 15 (of 32 total)

1 2 3 →