Guriddo » cliv's Replies

cliv

Guriddo

Forum Replies Created

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

Author

Replies

September 15, 2015 at 9:15 am in reply to: Master Detail – jqGridArray? #124346

cliv

Participant

yes…your example with array in code work me too …. but when i try to load array data from server only in detail.php – grid detail not showing rows ….

very strange!

September 10, 2015 at 2:01 pm in reply to: Master Detail – jqGridArray? #124343

cliv

Participant

i try what you say but … NOT WORK …

1. I set Ziua to be primary key:

...
$grid-&gt;setPrimaryKeyId(&#039;Ziua&#039;);
...

...

$grid->setPrimaryKeyId('Ziua');

...

2. and eliminated space from Ziua value from json.
Now json is:
[{"Ziua":"10.09.2015_14:00:00","readouttime":"2015-09-10 14:00:00.000","Pres_ACM":"2.826","Pres_INC":"0","Temp_ACM_P4":"64","Temp_EXT":"18.56","Temp_INC":"30.62","Temp_Tur_TF":"66.93"},{"Ziua":"10.09.2015_13:00:00","readouttime":"2015-09-10 13:00:00.000","Pres_ACM":"2.818","Pres_INC":"0","Temp_ACM_P4":"64.43","Temp_EXT":"18.06","Temp_INC":"30.68","Temp_Tur_TF":"66.87"},{"Ziua":"10.09.2015_12:00:00","readouttime":"2015-09-10 12:00:00.000","Pres_ACM":"0","Pres_INC":"0","Temp_ACM_P4":"42.62","Temp_EXT":"17.81","Temp_INC":"30.5","Temp_Tur_TF":"54.06"},{"Ziua":"10.09.2015_11:00:00","readouttime":"2015-09-10 11:00:00.000","Pres_ACM":"0","Pres_INC":"0","Temp_ACM_P4":"47.06","Temp_EXT":"17.06","Temp_INC":"30.81","Temp_Tur_TF":"57.87"},{"Ziua":"10.09.2015_10:00:00","readouttime":"2015-09-10 10:00:00.000","Pres_ACM":"2.808","Pres_INC":"0","Temp_ACM_P4":"59.62","Temp_EXT":"16.87","Temp_INC":"31","Temp_Tur_TF":"63.87"},{"Ziua":"10.09.2015_09:00:00","readouttime":"2015-09-10 09:00:00.000","Pres_ACM":"2.801","Pres_INC":"0","Temp_ACM_P4":"55.37","Temp_EXT":"16.62","Temp_INC":"31","Temp_Tur_TF":"65.06"},{"Ziua":"10.09.2015_08:00:00","readouttime":"2015-09-10 08:00:00.000","Pres_ACM":"2.781","Pres_INC":"0","Temp_ACM_P4":"54.43","Temp_EXT":"17.56","Temp_INC":"31.18","Temp_Tur_TF":"65.93"},{"Ziua":"10.09.2015_07:00:00","readouttime":"2015-09-10 07:00:00.000","Pres_ACM":"2.774","Pres_INC":"0","Temp_ACM_P4":"55.37","Temp_EXT":"17.93","Temp_INC":"31.31","Temp_Tur_TF":"66.43"},{"Ziua":"10.09.2015_06:00:00","readouttime":"2015-09-10 06:00:00.000","Pres_ACM":"2.849","Pres_INC":"0","Temp_ACM_P4":"60.18","Temp_EXT":"18.56","Temp_INC":"31.37","Temp_Tur_TF":"64.31"},{"Ziua":"10.09.2015_05:00:00","readouttime":"2015-09-10 05:00:00.000","Pres_ACM":"2.868","Pres_INC":"0","Temp_ACM_P4":"64.68","Temp_EXT":"19.31","Temp_INC":"31.5","Temp_Tur_TF":"66.87"},{"Ziua":"10.09.2015_04:00:00","readouttime":"2015-09-10 04:00:00.000","Pres_ACM":"2.866","Pres_INC":"0","Temp_ACM_P4":"64.87","Temp_EXT":"20.12","Temp_INC":"31.5","Temp_Tur_TF":"66.87"},{"Ziua":"10.09.2015_03:00:00","readouttime":"2015-09-10 03:00:00.000","Pres_ACM":"2.862","Pres_INC":"0","Temp_ACM_P4":"65.06","Temp_EXT":"20.25","Temp_INC":"31.56","Temp_Tur_TF":"67.43"},{"Ziua":"10.09.2015_02:00:00","readouttime":"2015-09-10 02:00:00.000","Pres_ACM":"2.861","Pres_INC":"0","Temp_ACM_P4":"64.62","Temp_EXT":"20.25","Temp_INC":"31.56","Temp_Tur_TF":"66.93"},{"Ziua":"10.09.2015_01:00:00","readouttime":"2015-09-10 01:00:00.000","Pres_ACM":"2.857","Pres_INC":"0","Temp_ACM_P4":"65.06","Temp_EXT":"20.81","Temp_INC":"31.62","Temp_Tur_TF":"66.75"},{"Ziua":"10.09.2015_00:00:00","readouttime":"2015-09-10 00:00:00.000","Pres_ACM":"2.844","Pres_INC":"0","Temp_ACM_P4":"65.87","Temp_EXT":"21.31","Temp_INC":"31.62","Temp_Tur_TF":"67"}]

This reply was modified 10 years, 8 months ago by cliv.

September 8, 2015 at 8:18 am in reply to: Master Detail – jqGridArray? #124334

cliv

Participant

guriddo.support wrote:

The problem is in the response.

Thank you…but still not work…
Here is new json.
[{"readouttime":"2015-09-08 09:00:00.000","Ziua":"08.09.2015 09:00:00","Pres_ACM":"2.838","Pres_INC":"0","Temp_ACM_P4":"63.75","Temp_EXT":"17.06","Temp_INC":"32.37","Temp_Tur_TF":"65.31"},{"readouttime":"2015-09-08 08:00:00.000","Ziua":"08.09.2015 08:00:00","Pres_ACM":"2.785","Pres_INC":"0","Temp_ACM_P4":"61.56","Temp_EXT":"15.5","Temp_INC":"32.5","Temp_Tur_TF":"65.87"},{"readouttime":"2015-09-08 07:00:00.000","Ziua":"08.09.2015 07:00:00","Pres_ACM":"2.793","Pres_INC":"0","Temp_ACM_P4":"62","Temp_EXT":"16.43","Temp_INC":"32.5","Temp_Tur_TF":"64.31"},{"readouttime":"2015-09-08 06:00:00.000","Ziua":"08.09.2015 06:00:00","Pres_ACM":"2.848","Pres_INC":"0","Temp_ACM_P4":"57.81","Temp_EXT":"16.12","Temp_INC":"32.75","Temp_Tur_TF":"62.93"},{"readouttime":"2015-09-08 05:00:00.000","Ziua":"08.09.2015 05:00:00","Pres_ACM":"2.853","Pres_INC":"0","Temp_ACM_P4":"61.06","Temp_EXT":"16.81","Temp_INC":"32.87","Temp_Tur_TF":"63.68"},{"readouttime":"2015-09-08 04:00:00.000","Ziua":"08.09.2015 04:00:00","Pres_ACM":"2.856","Pres_INC":"0","Temp_ACM_P4":"60.56","Temp_EXT":"17.12","Temp_INC":"33","Temp_Tur_TF":"63.5"},{"readouttime":"2015-09-08 03:00:00.000","Ziua":"08.09.2015 03:00:00","Pres_ACM":"2.86","Pres_INC":"0","Temp_ACM_P4":"60.56","Temp_EXT":"18.18","Temp_INC":"33.06","Temp_Tur_TF":"63.06"},{"readouttime":"2015-09-08 02:00:00.000","Ziua":"08.09.2015 02:00:00","Pres_ACM":"2.869","Pres_INC":"0","Temp_ACM_P4":"61.06","Temp_EXT":"18.43","Temp_INC":"33.12","Temp_Tur_TF":"63"},{"readouttime":"2015-09-08 01:00:00.000","Ziua":"08.09.2015 01:00:00","Pres_ACM":"2.864","Pres_INC":"0","Temp_ACM_P4":"60.68","Temp_EXT":"19.18","Temp_INC":"33.18","Temp_Tur_TF":"64"},{"readouttime":"2015-09-08 00:00:00.000","Ziua":"08.09.2015 00:00:00","Pres_ACM":"2.826","Pres_INC":"0","Temp_ACM_P4":"55.18","Temp_EXT":"19.43","Temp_INC":"33.31","Temp_Tur_TF":"64.68"}]

This reply was modified 10 years, 9 months ago by cliv.
This reply was modified 10 years, 9 months ago by cliv.

September 7, 2015 at 12:37 pm in reply to: Master Detail – jqGridArray? #124322

cliv

Participant

When i check arhivaDate.json file write on disk by “arhivaScadaDate.php” , everything is OK…but second grid not display rows … only number of record in footer (“View 1 – 10 of 13”).

arhivaDate.json

[{&quot;readouttime&quot;:&quot;2015-09-07 12:00:00.000&quot;,&quot;Ziua&quot;:&quot;07.09.2015 12:00:00&quot;,&quot;Pres ACM&quot;:&quot;2.83&quot;,&quot;Pres INC&quot;:&quot;0&quot;,&quot;Temp ACM P4&quot;:&quot;59.56&quot;,&quot;Temp EXT&quot;:&quot;22.87&quot;,&quot;Temp INC&quot;:&quot;33.37&quot;,&quot;Temp Tur TF&quot;:&quot;65.43&quot;},{&quot;readouttime&quot;:&quot;2015-09-07 11:00:00.000&quot;,&quot;Ziua&quot;:&quot;07.09.2015 11:00:00&quot;,&quot;Pres ACM&quot;:&quot;2.789&quot;,&quot;Pres INC&quot;:&quot;0&quot;,&quot;Temp ACM P4&quot;:&quot;57.43&quot;,&quot;Temp EXT&quot;:&quot;21.37&quot;,&quot;Temp INC&quot;:&quot;33.37&quot;,&quot;Temp Tur TF&quot;:&quot;64.18&quot;},{&quot;readouttime&quot;:&quot;2015-09-07 10:00:00.000&quot;,&quot;Ziua&quot;:&quot;07.09.2015 10:00:00&quot;,&quot;Pres ACM&quot;:&quot;2.824&quot;,&quot;Pres INC&quot;:&quot;0&quot;,&quot;Temp ACM P4&quot;:&quot;59.37&quot;,&quot;Temp EXT&quot;:&quot;19.5&quot;,&quot;Temp INC&quot;:&quot;33.43&quot;,&quot;Temp Tur TF&quot;:&quot;64.37&quot;},{&quot;readouttime&quot;:&quot;2015-09-07 09:00:00.000&quot;,&quot;Ziua&quot;:&quot;07.09.2015 09:00:00&quot;,&quot;Pres ACM&quot;:&quot;2.767&quot;,&quot;Pres INC&quot;:&quot;0&quot;,&quot;Temp ACM P4&quot;:&quot;58.68&quot;,&quot;Temp EXT&quot;:&quot;18.25&quot;,&quot;Temp INC&quot;:&quot;33.5&quot;,&quot;Temp Tur TF&quot;:&quot;65.93&quot;},{&quot;readouttime&quot;:&quot;2015-09-07 08:00:00.000&quot;,&quot;Ziua&quot;:&quot;07.09.2015 08:00:00&quot;,&quot;Pres ACM&quot;:&quot;2.821&quot;,&quot;Pres INC&quot;:&quot;0&quot;,&quot;Temp ACM P4&quot;:&quot;61.5&quot;,&quot;Temp EXT&quot;:&quot;17.93&quot;,&quot;Temp INC&quot;:&quot;33.68&quot;,&quot;Temp Tur TF&quot;:&quot;66.37&quot;},{&quot;readouttime&quot;:&quot;2015-09-07 07:00:00.000&quot;,&quot;Ziua&quot;:&quot;07.09.2015 07:00:00&quot;,&quot;Pres ACM&quot;:&quot;2.784&quot;,&quot;Pres INC&quot;:&quot;0&quot;,&quot;Temp ACM P4&quot;:&quot;45.12&quot;,&quot;Temp EXT&quot;:&quot;17.31&quot;,&quot;Temp INC&quot;:&quot;33.87&quot;,&quot;Temp Tur TF&quot;:&quot;63.06&quot;},{&quot;readouttime&quot;:&quot;2015-09-07 06:00:00.000&quot;,&quot;Ziua&quot;:&quot;07.09.2015 06:00:00&quot;,&quot;Pres ACM&quot;:&quot;2.857&quot;,&quot;Pres INC&quot;:&quot;0&quot;,&quot;Temp ACM P4&quot;:&quot;61.31&quot;,&quot;Temp EXT&quot;:&quot;17.43&quot;,&quot;Temp INC&quot;:&quot;34.06&quot;,&quot;Temp Tur TF&quot;:&quot;63.31&quot;},{&quot;readouttime&quot;:&quot;2015-09-07 05:00:00.000&quot;,&quot;Ziua&quot;:&quot;07.09.2015 05:00:00&quot;,&quot;Pres ACM&quot;:&quot;2.853&quot;,&quot;Pres INC&quot;:&quot;0&quot;,&quot;Temp ACM P4&quot;:&quot;63.31&quot;,&quot;Temp EXT&quot;:&quot;17.93&quot;,&quot;Temp INC&quot;:&quot;34.18&quot;,&quot;Temp Tur TF&quot;:&quot;64.81&quot;},{&quot;readouttime&quot;:&quot;2015-09-07 04:00:00.000&quot;,&quot;Ziua&quot;:&quot;07.09.2015 04:00:00&quot;,&quot;Pres ACM&quot;:&quot;2.864&quot;,&quot;Pres INC&quot;:&quot;0&quot;,&quot;Temp ACM P4&quot;:&quot;63.18&quot;,&quot;Temp EXT&quot;:&quot;18.18&quot;,&quot;Temp INC&quot;:&quot;34.31&quot;,&quot;Temp Tur TF&quot;:&quot;65.25&quot;},{&quot;readouttime&quot;:&quot;2015-09-07 03:00:00.000&quot;,&quot;Ziua&quot;:&quot;07.09.2015 03:00:00&quot;,&quot;Pres ACM&quot;:&quot;3.211&quot;,&quot;Pres INC&quot;:&quot;0&quot;,&quot;Temp ACM P4&quot;:&quot;63.31&quot;,&quot;Temp EXT&quot;:&quot;19.06&quot;,&quot;Temp INC&quot;:&quot;34.37&quot;,&quot;Temp Tur TF&quot;:&quot;65.18&quot;},{&quot;readouttime&quot;:&quot;2015-09-07 02:00:00.000&quot;,&quot;Ziua&quot;:&quot;07.09.2015 02:00:00&quot;,&quot;Pres ACM&quot;:&quot;3.142&quot;,&quot;Pres INC&quot;:&quot;0&quot;,&quot;Temp ACM P4&quot;:&quot;63.75&quot;,&quot;Temp EXT&quot;:&quot;19.81&quot;,&quot;Temp INC&quot;:&quot;34.43&quot;,&quot;Temp Tur TF&quot;:&quot;65.81&quot;},{&quot;readouttime&quot;:&quot;2015-09-07 01:00:00.000&quot;,&quot;Ziua&quot;:&quot;07.09.2015 01:00:00&quot;,&quot;Pres ACM&quot;:&quot;2.855&quot;,&quot;Pres INC&quot;:&quot;0&quot;,&quot;Temp ACM P4&quot;:&quot;63.93&quot;,&quot;Temp EXT&quot;:&quot;20.37&quot;,&quot;Temp INC&quot;:&quot;34.5&quot;,&quot;Temp Tur TF&quot;:&quot;65.62&quot;},{&quot;readouttime&quot;:&quot;2015-09-07 00:00:00.000&quot;,&quot;Ziua&quot;:&quot;07.09.2015 00:00:00&quot;,&quot;Pres ACM&quot;:&quot;3.023&quot;,&quot;Pres INC&quot;:&quot;0&quot;,&quot;Temp ACM P4&quot;:&quot;63.31&quot;,&quot;Temp EXT&quot;:&quot;21&quot;,&quot;Temp INC&quot;:&quot;34.56&quot;,&quot;Temp Tur TF&quot;:&quot;65.06&quot;}]

[{"readouttime":"2015-09-07 12:00:00.000","Ziua":"07.09.2015 12:00:00","Pres ACM":"2.83","Pres INC":"0","Temp ACM P4":"59.56","Temp EXT":"22.87","Temp INC":"33.37","Temp Tur TF":"65.43"},{"readouttime":"2015-09-07 11:00:00.000","Ziua":"07.09.2015 11:00:00","Pres ACM":"2.789","Pres INC":"0","Temp ACM P4":"57.43","Temp EXT":"21.37","Temp INC":"33.37","Temp Tur TF":"64.18"},{"readouttime":"2015-09-07 10:00:00.000","Ziua":"07.09.2015 10:00:00","Pres ACM":"2.824","Pres INC":"0","Temp ACM P4":"59.37","Temp EXT":"19.5","Temp INC":"33.43","Temp Tur TF":"64.37"},{"readouttime":"2015-09-07 09:00:00.000","Ziua":"07.09.2015 09:00:00","Pres ACM":"2.767","Pres INC":"0","Temp ACM P4":"58.68","Temp EXT":"18.25","Temp INC":"33.5","Temp Tur TF":"65.93"},{"readouttime":"2015-09-07 08:00:00.000","Ziua":"07.09.2015 08:00:00","Pres ACM":"2.821","Pres INC":"0","Temp ACM P4":"61.5","Temp EXT":"17.93","Temp INC":"33.68","Temp Tur TF":"66.37"},{"readouttime":"2015-09-07 07:00:00.000","Ziua":"07.09.2015 07:00:00","Pres ACM":"2.784","Pres INC":"0","Temp ACM P4":"45.12","Temp EXT":"17.31","Temp INC":"33.87","Temp Tur TF":"63.06"},{"readouttime":"2015-09-07 06:00:00.000","Ziua":"07.09.2015 06:00:00","Pres ACM":"2.857","Pres INC":"0","Temp ACM P4":"61.31","Temp EXT":"17.43","Temp INC":"34.06","Temp Tur TF":"63.31"},{"readouttime":"2015-09-07 05:00:00.000","Ziua":"07.09.2015 05:00:00","Pres ACM":"2.853","Pres INC":"0","Temp ACM P4":"63.31","Temp EXT":"17.93","Temp INC":"34.18","Temp Tur TF":"64.81"},{"readouttime":"2015-09-07 04:00:00.000","Ziua":"07.09.2015 04:00:00","Pres ACM":"2.864","Pres INC":"0","Temp ACM P4":"63.18","Temp EXT":"18.18","Temp INC":"34.31","Temp Tur TF":"65.25"},{"readouttime":"2015-09-07 03:00:00.000","Ziua":"07.09.2015 03:00:00","Pres ACM":"3.211","Pres INC":"0","Temp ACM P4":"63.31","Temp EXT":"19.06","Temp INC":"34.37","Temp Tur TF":"65.18"},{"readouttime":"2015-09-07 02:00:00.000","Ziua":"07.09.2015 02:00:00","Pres ACM":"3.142","Pres INC":"0","Temp ACM P4":"63.75","Temp EXT":"19.81","Temp INC":"34.43","Temp Tur TF":"65.81"},{"readouttime":"2015-09-07 01:00:00.000","Ziua":"07.09.2015 01:00:00","Pres ACM":"2.855","Pres INC":"0","Temp ACM P4":"63.93","Temp EXT":"20.37","Temp INC":"34.5","Temp Tur TF":"65.62"},{"readouttime":"2015-09-07 00:00:00.000","Ziua":"07.09.2015 00:00:00","Pres ACM":"3.023","Pres INC":"0","Temp ACM P4":"63.31","Temp EXT":"21","Temp INC":"34.56","Temp Tur TF":"65.06"}]

September 7, 2015 at 12:26 pm in reply to: Master Detail – jqGridArray? #124320

cliv

Participant

HTML


&lt;div&gt;
&lt;table id=&quot;grid&quot;&gt;&lt;/table&gt;
&lt;?php include (&quot;arhivaScadaGrid.php&quot;);?&gt;
&lt;/div&gt;

&lt;div&gt;
&lt;table id=&quot;detail&quot;&gt;&lt;/table&gt;
&lt;?php include (&quot;arhivaScadaDate.php&quot;);?&gt;
&lt;/div&gt;

<div>

<?php include ("arhivaScadaGrid.php");?>

</div>

<div>

<?php include ("arhivaScadaDate.php");?>

</div>

arhivaScadaGrid.php

require_once &#039;dbconfig.php&#039;;
require_once &#039;jqSuite/php/jqGrid.php&#039;;
require_once &#039;jqSuite/php/jqGridArray.php&#039;;
//--------------------------------------------------------------------------//
$connectionInfo = array(&quot;UID&quot; =&gt; DB_USER, &quot;PWD&quot; =&gt; DB_PASSWORD,&quot;Database&quot;=&gt;DB_NAME,&quot;ReturnDatesAsStrings&quot; =&gt; true);
$conn = sqlsrv_connect(DB_HOST, $connectionInfo);

if( $conn ){
//echo &quot;Conexiune stabilita.&quot;;
}else{
echo &quot;Conexiunea nu a putut fi stabilita.&quot;;
die( print_r( sqlsrv_errors(), true));
}

$query = &quot;SELECT CodPT,CodParam,Denumire,Parametri FROM ScadaArhiva&quot;;
$resultPT = sqlsrv_query($conn,$query);
if( $resultPT === false) {
echo &quot; Eroare la executie interogare.&quot;;
die( print_r( sqlsrv_errors(), true) );
}else{
//echo &quot; Executat interogare...&quot;;
}

$arhivaPT = array();
while($row = sqlsrv_fetch_array($resultPT,SQLSRV_FETCH_ASSOC)) {
$arhivaPT[] = $row;
}
$gridPT = new jqGridArray();
$grid = new jqGridRender($gridPT);
$grid-&gt;SelectCommand = &quot;SELECT * FROM arhivaPT&quot;;
$grid-&gt;dataType = &#039;json&#039;;
$grid-&gt;setPrimaryKeyId(&#039;CodParam&#039;);
$grid-&gt;setColModel();
$grid-&gt;setUrl(&#039;arhivaScadaGrid.php&#039;);

$grid-&gt;setGridOptions(array(
&quot;width&quot;=&gt;500,
&quot;rowNum&quot;=&gt;10,
&quot;rowList&quot;=&gt;array(10,20,30),
&quot;sortname&quot;=&gt;&quot;Denumire&quot;
));

$grid-&gt;setColProperty(&quot;CodPT&quot;, array(&quot;hidden&quot;=&gt;true));
$grid-&gt;setColProperty(&quot;CodParam&quot;, array(&quot;hidden&quot;=&gt;true));
$grid-&gt;setColProperty(&quot;Denumire&quot;, array(&quot;label&quot;=&gt;&quot;Denumire&quot;, &quot;width&quot;=&gt;250,&quot;align&quot;=&gt;&quot;left&quot;,&quot;hidden&quot;=&gt;false));
$grid-&gt;setColProperty(&quot;Parametri&quot;, array(&quot;label&quot;=&gt;&quot;Parametri&quot;, &quot;width&quot;=&gt;250,&quot;align&quot;=&gt;&quot;left&quot;,&quot;hidden&quot;=&gt;false));

$onselect = &lt;&lt;setGridEvent(&#039;onSelectRow&#039;, $onselect);
	function(rowid, selected){
		if(rowid != null) {	
			rowdata = jQuery(this).jqGrid(&#039;getRowData&#039;, rowid);
			jQuery(&quot;#detail&quot;).jqGrid(&#039;setGridParam&#039;,{postData:{COL1: rowdata.CodPT, COL2 : rowdata.CodParam}});
			jQuery(&quot;#detail&quot;).trigger(&quot;reloadGrid&quot;);	
		}
	}
ONSELECT;
	$grid-&gt;setGridEvent(&#039;onSelectRow&#039;, $onselect);

$grid-&gt;navigator = true;
$grid-&gt;toolbarfilter = true;
$grid-&gt;setFilterOptions(array(&quot;searchOnEnter&quot;=&gt;false));
$grid-&gt;setNavOptions(&#039;navigator&#039;, array(&quot;excel&quot;=&gt;false,&quot;add&quot;=&gt;false,&quot;edit&quot;=&gt;false,&quot;del&quot;=&gt;false,&quot;view&quot;=&gt;false,&quot;csv&quot;=&gt;false, &quot;pdf&quot;=&gt;false));
$grid-&gt;setNavOptions(&#039;search&#039;,array(&quot;multipleSearch&quot;=&gt;false));

$grid-&gt;renderGrid(&#039;#grid&#039;,&#039;#pager&#039;,true, null, null, true,true);
$gridPT = null;

require_once 'dbconfig.php';

require_once 'jqSuite/php/jqGrid.php';

require_once 'jqSuite/php/jqGridArray.php';

//--------------------------------------------------------------------------//

$connectionInfo = array("UID" => DB_USER, "PWD" => DB_PASSWORD,"Database"=>DB_NAME,"ReturnDatesAsStrings" => true);

$conn = sqlsrv_connect(DB_HOST, $connectionInfo);

if( $conn ){

//echo "Conexiune stabilita.";

}else{

echo "Conexiunea nu a putut fi stabilita.";

die( print_r( sqlsrv_errors(), true));

}

$query = "SELECT CodPT,CodParam,Denumire,Parametri FROM ScadaArhiva";

$resultPT = sqlsrv_query($conn,$query);

if( $resultPT === false) {

echo " Eroare la executie interogare.";

die( print_r( sqlsrv_errors(), true) );

}else{

//echo " Executat interogare...";

}

$arhivaPT = array();

while($row = sqlsrv_fetch_array($resultPT,SQLSRV_FETCH_ASSOC)) {

$arhivaPT[] = $row;

}

$gridPT = new jqGridArray();

$grid = new jqGridRender($gridPT);

$grid->SelectCommand = "SELECT * FROM arhivaPT";

$grid->dataType = 'json';

$grid->setPrimaryKeyId('CodParam');

$grid->setColModel();

$grid->setUrl('arhivaScadaGrid.php');

$grid->setGridOptions(array(

"width"=>500,

"rowNum"=>10,

"rowList"=>array(10,20,30),

"sortname"=>"Denumire"

));

$grid->setColProperty("CodPT", array("hidden"=>true));

$grid->setColProperty("CodParam", array("hidden"=>true));

$grid->setColProperty("Denumire", array("label"=>"Denumire", "width"=>250,"align"=>"left","hidden"=>false));

$grid->setColProperty("Parametri", array("label"=>"Parametri", "width"=>250,"align"=>"left","hidden"=>false));

$onselect = <<setGridEvent('onSelectRow', $onselect);

function(rowid, selected){

if(rowid != null) {

rowdata = jQuery(this).jqGrid('getRowData', rowid);

jQuery("#detail").jqGrid('setGridParam',{postData:{COL1: rowdata.CodPT, COL2 : rowdata.CodParam}});

jQuery("#detail").trigger("reloadGrid");

}

ONSELECT;

$grid->setGridEvent('onSelectRow', $onselect);

$grid->navigator = true;

$grid->toolbarfilter = true;

$grid->setFilterOptions(array("searchOnEnter"=>false));

$grid->setNavOptions('navigator', array("excel"=>false,"add"=>false,"edit"=>false,"del"=>false,"view"=>false,"csv"=>false, "pdf"=>false));

$grid->setNavOptions('search',array("multipleSearch"=>false));

$grid->renderGrid('#grid','#pager',true, null, null, true,true);

$gridPT = null;

arhivaScadaDate

require_once &#039;dbconfig.php&#039;;
	require_once &#039;jqSuite/php/jqGrid.php&#039;;
	require_once &#039;jqSuite/php/jqGridArray.php&#039;;
		
	
	
	$CodPT = jqGridUtils::GetParam(&quot;COL1&quot;);
	$CodParam = jqGridUtils::GetParam(&quot;COL2&quot;);

	$info = getdate();
	$DataStart=$info[&#039;year&#039;].&#039;-&#039;.$info[&#039;mon&#039;].&#039;-&#039;.($info[&#039;mday&#039;]);
    $DataStop=$info[&#039;year&#039;].&#039;-&#039;.$info[&#039;mon&#039;].&#039;-&#039;.($info[&#039;mday&#039;]+1);
	$connectionInfo = array(&quot;UID&quot; =&gt; DB_USER, &quot;PWD&quot; =&gt; DB_PASSWORD,&quot;Database&quot;=&gt;DB_NAME,&quot;ReturnDatesAsStrings&quot; =&gt; true);
	$conn = sqlsrv_connect(DB_HOST, $connectionInfo);
	if( $conn ){
		 //echo &quot;Conexiune stabilita.&lt;/br&gt;&quot;;
	}else{
		 echo &quot;Conexiunea nu a putut fi stabilita.&lt;/br&gt;&quot;;
		 die( print_r( sqlsrv_errors(), true));
	}	
	
	$params = array( 
				array($CodPT,SQLSRV_PARAM_IN), 
				array($CodParam,SQLSRV_PARAM_IN), 
				array($DataStart,SQLSRV_PARAM_IN), 
				array($DataStop,SQLSRV_PARAM_IN)				
				);
	$query = &quot;{Call procArhivaScada (?,?,?,?)}&quot;;	
	$result = sqlsrv_query($conn,$query,$params);
	if( $result === false) {
		echo &quot; Eroare la executie interogare.&lt;/br&gt;&quot;;
		die( print_r( sqlsrv_errors(), true) );
	}else{
		//echo &quot; Executat interogare...&lt;/br&gt;&quot;;
	}	
	$arhivaDate = array();
	 while($row = sqlsrv_fetch_array($result,SQLSRV_FETCH_ASSOC)) {
		$arhivaDate[] = $row;		
	 }

	$fp = fopen(&#039;arhivaDate.json&#039;, &#039;w&#039;);
	fwrite($fp, json_encode($arhivaDate));
	fclose($fp);

	$connGrd = new jqGridArray();
	$grid = new jqGridRender($connGrd);
	$grid-&gt;SelectCommand = &quot;SELECT * FROM arhivaDate&quot;;
	$grid-&gt;dataType = &#039;json&#039;;
	$grid-&gt;setPrimaryKeyId(&#039;readouttime&#039;);
	$grid-&gt;setColModel();
	$grid-&gt;setUrl(&#039;arhivaScadaDate.php&#039;);
	$grid-&gt;debug = true;
	$grid-&gt;showError = true; 

	$grid-&gt;setGridOptions(array(
		&quot;width&quot;=&gt;700,
		&quot;rowNum&quot;=&gt;10,
		&quot;rowList&quot;=&gt;array(10,20,30)
	));
	$grid-&gt;navigator = true;
	$grid-&gt;setNavOptions(&#039;navigator&#039;, array(&quot;excel&quot;=&gt;false,&quot;add&quot;=&gt;false,&quot;edit&quot;=&gt;false,&quot;del&quot;=&gt;false,&quot;view&quot;=&gt;false,&quot;csv&quot;=&gt;false, &quot;pdf&quot;=&gt;false));
	$grid-&gt;setNavOptions(&#039;search&#039;,array(&quot;multipleSearch&quot;=&gt;false));

	$grid-&gt;renderGrid(&quot;#detail&quot;,&quot;#pgdetail&quot;,true, null, null, true,true);
	$connGrd = null;

require_once 'dbconfig.php';

require_once 'jqSuite/php/jqGrid.php';

require_once 'jqSuite/php/jqGridArray.php';

$CodPT = jqGridUtils::GetParam("COL1");

$CodParam = jqGridUtils::GetParam("COL2");

$info = getdate();

$DataStart=$info['year'].'-'.$info['mon'].'-'.($info['mday']);

$DataStop=$info['year'].'-'.$info['mon'].'-'.($info['mday']+1);

$connectionInfo = array("UID" => DB_USER, "PWD" => DB_PASSWORD,"Database"=>DB_NAME,"ReturnDatesAsStrings" => true);

$conn = sqlsrv_connect(DB_HOST, $connectionInfo);

if( $conn ){

//echo "Conexiune stabilita.</br>";

}else{

echo "Conexiunea nu a putut fi stabilita.</br>";

die( print_r( sqlsrv_errors(), true));

}

$params = array(

array($CodPT,SQLSRV_PARAM_IN),

array($CodParam,SQLSRV_PARAM_IN),

array($DataStart,SQLSRV_PARAM_IN),

array($DataStop,SQLSRV_PARAM_IN)

);

$query = "{Call procArhivaScada (?,?,?,?)}";

$result = sqlsrv_query($conn,$query,$params);

if( $result === false) {

echo " Eroare la executie interogare.</br>";

die( print_r( sqlsrv_errors(), true) );

}else{

//echo " Executat interogare...</br>";

}

$arhivaDate = array();

while($row = sqlsrv_fetch_array($result,SQLSRV_FETCH_ASSOC)) {

$arhivaDate[] = $row;

}

$fp = fopen('arhivaDate.json', 'w');

fwrite($fp, json_encode($arhivaDate));

fclose($fp);

$connGrd = new jqGridArray();

$grid = new jqGridRender($connGrd);

$grid->SelectCommand = "SELECT * FROM arhivaDate";

$grid->dataType = 'json';

$grid->setPrimaryKeyId('readouttime');

$grid->setColModel();

$grid->setUrl('arhivaScadaDate.php');

$grid->debug = true;

$grid->showError = true;

$grid->setGridOptions(array(

"width"=>700,

"rowNum"=>10,

"rowList"=>array(10,20,30)

));

$grid->navigator = true;

$grid->setNavOptions('navigator', array("excel"=>false,"add"=>false,"edit"=>false,"del"=>false,"view"=>false,"csv"=>false, "pdf"=>false));

$grid->setNavOptions('search',array("multipleSearch"=>false));

$grid->renderGrid("#detail","#pgdetail",true, null, null, true,true);

$connGrd = null;

This reply was modified 10 years, 9 months ago by cliv.

August 13, 2015 at 2:23 pm in reply to: Master Detail – jqGridArray? #124182

cliv

Participant

I tested and second grid (detail) not showing rows, only shows total number of rows…?

July 7, 2015 at 8:37 am in reply to: Stored procedure + SQL Server 2008 + jqGrid #124017

cliv

Participant

guriddo.support wrote:

Look at this example.

Thank you

This reply was modified 10 years, 11 months ago by cliv.

July 6, 2015 at 10:12 am in reply to: Stored procedure + SQL Server 2008 + jqGrid #124005

cliv

Participant

guriddo.support wrote:

One possible solution is to get the dataset from stored procedure and use the array driver to pass it to the grid

Thank you! … can you post a sample?

This reply was modified 10 years, 11 months ago by cliv.
This reply was modified 10 years, 11 months ago by cliv.

June 19, 2015 at 8:26 am in reply to: Master detail with two parameters #123935

cliv

Participant

…but what about jqGrid and stored procedure on SQLServer…
POST HERE

June 19, 2015 at 8:05 am in reply to: Master detail with two parameters #123933

cliv

Participant

Thank you

June 10, 2015 at 8:11 am in reply to: Master detail with two parameters #123905

cliv

Participant

OK! Thank you I understand how to send….but what is the code in detail.php to pass parametrs to sql query. This is correct?


...
$COL1 = jqGridUtils::GetParam(&quot;COL1&quot;);
$COL2 = jqGridUtils::GetParam(&quot;COL2&quot;);

$grid = new jqGridRender($conn);
$grid-&gt;SelectCommand = &quot;SELECT * FROM table WHERE COD1= ? AND COD2= ?&quot;;
$grid-&gt;dataType = &#039;json&#039;;

$grid-&gt;setColModel(null, array(&amp;$COL1,&amp;$COL2));
...

...

$COL1 = jqGridUtils::GetParam("COL1");

$COL2 = jqGridUtils::GetParam("COL2");

$grid = new jqGridRender($conn);

$grid->SelectCommand = "SELECT * FROM table WHERE COD1= ? AND COD2= ?";

$grid->dataType = 'json';

$grid->setColModel(null, array(&$COL1,&$COL2));

...

May 21, 2015 at 2:47 pm in reply to: Master detail with two parameters #123853

cliv

Participant

I want to select row on master and read COL1 and COl2 on selected row and then pass this parameters to SQL query on detail (Select from TABLE where id=COL1 and cod=COL2).

Can be done….?

Author

Replies

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