Guriddo » Topic: Master Detail

Master Detail – jqGridArray?

Guriddo
Master Detail – jqGridArray?

This topic has 10 replies, 3 voices, and was last updated 10 years, 7 months ago by cliv.

Creator

Topic
August 13, 2015 at 1:56 pm #124181

cliv
Participant

Can jqGrid support to have two array grids at one page like in demo Master Detail On Select?
Creator

Topic

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

Author

Replies

August 13, 2015 at 2:23 pm #124182

cliv

Participant

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

August 14, 2015 at 8:28 am #124184

tony

Keymaster

Hello,

Can you please post your code?

The most common error in this case is that both grid have equal id and this make a conflict.

Please check tha master and detail have different ids.

Publishing code is highly recommended.

Kind Regards,

September 7, 2015 at 12:26 pm #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, 7 months ago by cliv.

September 7, 2015 at 12:37 pm #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 8, 2015 at 2:35 am #124330

guriddo.support

Participant

Hello,

The problem is in the response.

The key values in the response should not contain spaces. Your response contain such one.

By example you have:
“Pres ACM”:”2.83″,”Pres INC”:”0″

This should be converted to:

“PresACM”:”2.83″,”PresINC”:”0″
or
“Pres_ACM”:”2.83″,”Pres_INC”:”0″

Kind Regards,

Will

This reply was modified 10 years, 7 months ago by guriddo.support.

Guriddo Support Team

September 8, 2015 at 8:18 am #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, 7 months ago by cliv.
This reply was modified 10 years, 7 months ago by cliv.

September 10, 2015 at 11:08 am #124342

guriddo.support

Participant

Hello,

You set readouttime to be a primary key which will be used as id of the rows, but the id can not contain spaces. Yours id contain spaces.

I recommend you to use another filed as primary key without spaces or you can build uniquie keys when you set the array.

Kind Regards,

Will

Guriddo Support Team

September 10, 2015 at 2:01 pm #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, 7 months ago by cliv.

September 14, 2015 at 10:12 am #124345

guriddo.support

Participant

Hello,

Not sure what you do, but here is your example.

The only difference is that we do not perform where clause in detail grid, so onSelect row will return every time the same record set.

Kind Regards,

Will

Guriddo Support Team

September 15, 2015 at 9:15 am #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 ….

Master Detail – jqGridArray?

Search Forum

Recent Replies

Forum Statistics

UserOnline