Guriddo » Topic: Subgrid data does not display

Subgrid data does not display

Guriddo
Subgrid data does not display

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

Creator

Topic

January 6, 2018 at 5:19 am #126548

Participant

Hi, I am attempting to create subgrid setup between my tables plant (parent) and research (sub grid) in Guriddo Suito. I am able to see the plant table with a plus icon for the subgrid — just no information in the grid appears only a ^ next to the subgrid area and the plus changes to a minus.

My three files are myjqgridphp.php which contains the html from the example on your website for “Sub Grid (2 nested levels)” and my files grid.php and subgrid.php which I have modified as below. I have installed and am connected to the northwind database and ran it as the demo and get the same problem – only the customer data shows up. I am assuming it is something in the subgrid file or elsewhere that I do not have configured properly but I am enclosing both subgrid.php and grid.php below and would be happy to post any other files if you could please help. Thank you.

GRID.PHP


&lt;?php
require_once &#039;jq-config.php&#039;;
// include the jqGrid Class
require_once &quot;php/PHPSuito/jqGrid.php&quot;;
// include the driver class
require_once &quot;php/PHPSuito/DBdrivers/jqGridPdo.php&quot;;
// Connection to the server
$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);
// Tell the db that we use utf-8
$conn-&gt;query(&quot;SET NAMES utf8&quot;);

// Create the jqGrid instance
$grid = new jqGridRender($conn);
// Write the SQL Query
$grid-&gt;SelectCommand = &#039;SELECT idplant, name, latin_name, other_name FROM plant&#039;;
// Set the table to where you update the data
$grid-&gt;table = &#039;plant&#039;;
// set the ouput format to json
$grid-&gt;dataType = &#039;json&#039;;
// Let the grid create the model
$grid-&gt;setColModel();
// Set the url from where we obtain the data
$grid-&gt;setUrl(&#039;grid.php&#039;);
// Set grid caption using the option caption
$grid-&gt;setGridOptions(array(
&quot;caption&quot;=&gt;&quot;testing&quot;,
&quot;rowNum&quot;=&gt;10,
&quot;sortname&quot;=&gt;&quot;idplant&quot;,
&quot;hoverrows&quot;=&gt;true,
&quot;rowList&quot;=&gt;array(10,20,50),
));
$grid-&gt;setColProperty(&#039;idplant&#039;, array(&quot;label&quot;=&gt;&quot;ID&quot;, &quot;width&quot;=&gt;50));
$grid-&gt;setSubGridGrid(&quot;subgrid.php&quot;);
// Enable navigator
$grid-&gt;navigator = true;
// Enable only editing
$grid-&gt;setNavOptions(&#039;navigator&#039;, array(&quot;excel&quot;=&gt;false,&quot;add&quot;=&gt;true,&quot;edit&quot;=&gt;true,&quot;del&quot;=&gt;true,&quot;view&quot;=&gt;false));
// Enjoy
$grid-&gt;renderGrid(&#039;#grid&#039;,&#039;#pager&#039;,true, null, null, true,true);

<?php

require_once 'jq-config.php';

// include the jqGrid Class

require_once "php/PHPSuito/jqGrid.php";

// include the driver class

require_once "php/PHPSuito/DBdrivers/jqGridPdo.php";

// Connection to the server

$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);

// Tell the db that we use utf-8

$conn->query("SET NAMES utf8");

// Create the jqGrid instance

$grid = new jqGridRender($conn);

// Write the SQL Query

$grid->SelectCommand = 'SELECT idplant, name, latin_name, other_name FROM plant';

// Set the table to where you update the data

$grid->table = 'plant';

// set the ouput format to json

$grid->dataType = 'json';

// Let the grid create the model

$grid->setColModel();

// Set the url from where we obtain the data

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

// Set grid caption using the option caption

$grid->setGridOptions(array(

"caption"=>"testing",

"rowNum"=>10,

"sortname"=>"idplant",

"hoverrows"=>true,

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

));

$grid->setColProperty('idplant', array("label"=>"ID", "width"=>50));

$grid->setSubGridGrid("subgrid.php");

// Enable navigator

$grid->navigator = true;

// Enable only editing

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

// Enjoy

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

SUBGRID.PHP

&lt;?php
require_once &#039;C/mamp/htdocs/jq-config.php&#039;;
// include the jqGrid Class
require_once ABSPATH.&quot;php/PHPSuito/jqGrid.php&quot;;
// include the driver class
require_once ABSPATH.&quot;php/PHPSuito/DBdrivers/jqGridPdo.php&quot;;
// Connection to the server
$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);
// Tell the db that we use utf-8
$conn-&gt;query(&quot;SET NAMES utf8&quot;);
// Get the needed parameters passed from the main grid
// By default we add to postData subgrid and rowid parameters in the main grid
$oper = jqGridUtils::GetParam(&quot;oper&quot;);
$subtable = jqGridUtils::GetParam(&quot;subgrid&quot;);
$rowid = jqGridUtils::GetParam(&quot;rowid&quot;);
//if(!$subtable &amp;&amp; !$rowid) die(&quot;Missed parameters&quot;);
// Create the jqGrid instance
$grid = new jqGridRender($conn);
// Write the SQL Query
$grid-&gt;SelectCommand = &quot;SELECT idresearch, Article, Citation, dateadded, plant_idplant FROM research WHERE plant_idplant = ?&quot;;
// set the ouput format to json
$grid-&gt;dataType = &#039;json&#039;;
$grid-&gt;setPrimaryKeyId(&#039;idresearch&#039;);
// Let the grid create the model
$grid-&gt;setColModel(null,array($rowid));
// Set the url from where we obtain the data
$grid-&gt;setUrl(&#039;subgrid.php&#039;);
$onselrow = &lt;&lt;&lt; ONSELROW
function(rowid, selected)
{
if(rowid &amp;&amp; rowid !== lastSelection) {
$(this).jqGrid(&#039;restoreRow&#039;, lastSelection);
$(this).jqGrid(&#039;editRow&#039;, rowid, true);
lastSelection = rowid;
}
}
ONSELROW;
$grid-&gt;setGridEvent(&#039;onSelectRow&#039;, $onselrow);
$grid-&gt;table = &#039;research&#039;;
$grid-&gt;setColProperty(&#039;idresearch&#039;, array(
&quot;editable&quot;=&gt;false
));
$grid-&gt;setColProperty(&#039;plant_idplant&#039;, array(
&quot;hidden&quot;=&gt;true
));
// Set some grid options
$grid-&gt;setGridOptions(array(
&quot;width&quot;=&gt;540,
&quot;rowNum&quot;=&gt;10,
&quot;sortname&quot;=&gt;&quot;idresearch&quot;,
&quot;height&quot;=&gt;110,
&quot;postData&quot;=&gt;array(&quot;subgrid&quot;=&gt;$subtable,&quot;rowid&quot;=&gt;$rowid)));
// Change some property of the field(s)
$grid-&gt;setDbTime(&#039;Y-m-d H:i:s&#039;);
$grid-&gt;setUserTime(&#039;m/d/Y&#039;);
$grid-&gt;setDatepicker(&quot;dateadded&quot;);
$grid-&gt;setColProperty(&quot;dateadded&quot;, array(
&quot;formatter&quot;=&gt;&quot;date&quot;,
&quot;formatoptions&quot;=&gt;array(&quot;reformatAfterEdit&quot;=&gt;true, &quot;srcformat&quot;=&gt;&quot;Y-m-d H:i:s&quot;,&quot;newformat&quot;=&gt;&quot;m/d/Y&quot;),
&quot;search&quot;=&gt;false
)
);
// Enjoy
$subtable = $subtable.&quot;_t&quot;;
$pager = $subtable.&quot;_p&quot;;
$grid-&gt;renderGrid($subtable,$pager, true, null, array(&amp;$rowid), true,true);

<?php

require_once 'C/mamp/htdocs/jq-config.php';

// include the jqGrid Class

require_once ABSPATH."php/PHPSuito/jqGrid.php";

// include the driver class

require_once ABSPATH."php/PHPSuito/DBdrivers/jqGridPdo.php";

// Connection to the server

$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);

// Tell the db that we use utf-8

$conn->query("SET NAMES utf8");

// Get the needed parameters passed from the main grid

// By default we add to postData subgrid and rowid parameters in the main grid

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

$subtable = jqGridUtils::GetParam("subgrid");

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

//if(!$subtable && !$rowid) die("Missed parameters");

// Create the jqGrid instance

$grid = new jqGridRender($conn);

// Write the SQL Query

$grid->SelectCommand = "SELECT idresearch, Article, Citation, dateadded, plant_idplant FROM research WHERE plant_idplant = ?";

// set the ouput format to json

$grid->dataType = 'json';

$grid->setPrimaryKeyId('idresearch');

// Let the grid create the model

$grid->setColModel(null,array($rowid));

// Set the url from where we obtain the data

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

$onselrow = <<< ONSELROW

function(rowid, selected)

{

if(rowid && rowid !== lastSelection) {

$(this).jqGrid('restoreRow', lastSelection);

$(this).jqGrid('editRow', rowid, true);

lastSelection = rowid;

}

ONSELROW;

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

$grid->table = 'research';

$grid->setColProperty('idresearch', array(

"editable"=>false

));

$grid->setColProperty('plant_idplant', array(

"hidden"=>true

));

// Set some grid options

$grid->setGridOptions(array(

"width"=>540,

"rowNum"=>10,

"sortname"=>"idresearch",

"height"=>110,

"postData"=>array("subgrid"=>$subtable,"rowid"=>$rowid)));

// Change some property of the field(s)

$grid->setDbTime('Y-m-d H:i:s');

$grid->setUserTime('m/d/Y');

$grid->setDatepicker("dateadded");

$grid->setColProperty("dateadded", array(

"formatter"=>"date",

"formatoptions"=>array("reformatAfterEdit"=>true, "srcformat"=>"Y-m-d H:i:s","newformat"=>"m/d/Y"),

"search"=>false

)

);

// Enjoy

$subtable = $subtable."_t";

$pager = $subtable."_p";

$grid->renderGrid($subtable,$pager, true, null, array(&$rowid), true,true);

This topic was modified 5 years, 8 months ago by admin.
This topic was modified 5 years, 8 months ago by tony. Reason: Formatting the code

Creator

Topic

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

Author

Replies
January 8, 2018 at 1:55 pm #126558

tony
Keymaster

Hello,

This is strange. I will try to reproduce the code you post and see the problem.

One note until I prepare a demo – I do not see a setting of the primary Key of the parent grid, which maybe causes the problem.

Kind Regards,

January 9, 2018 at 1:02 pm #126564

tony
Keymaster

Hello,

The subgrid will never execute since you have a error in the subgrid.

You put a wrong direction to config file in sbgrid.php. Make it the same as in grid.php – i.e

replace

... require_once 'C/mamp/htdocs/jq-config.php';

1
2

...
require_once 'C/mamp/htdocs/jq-config.php';

with

... require_once 'jq-config.php';

1
2

...
require_once 'jq-config.php';

Kind Regards,
Author

Replies