Guriddo » Topic: Subgrid empty

Subgrid empty

Guriddo
simple subgrid, Subgrid
Subgrid empty

Tagged: simple subgrid, Subgrid

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

Creator

Topic

January 3, 2015 at 10:37 am #115110

sagana

Participant

My subgrid returns the correct records in json (as seen in firebug). The main grid then has the headings for the subgrid and the correct number of rows but there is no data displayed in the rows.

Main Grid

include 'jq-config.php';

// include the jqGrid Class
require_once "../includes/jquery/php/jqGrid.php";
// include the PDO driver class
require_once "../includes/jquery/php/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

if(isset ($_REQUEST["cid"])) {
    $id = jqGridUtils::Strip($_REQUEST["cid"]);
	$i = explode('~',$id);
	$draccno = $i[0];
	$drsubno = $i[1];
} else {
    $draccno = 0;
	$drsubno = 0;
}

// Create the jqGrid instance
$grid = new jqGridRender($conn);

// the actual query for the grid data
$grid->SelectCommand = "select ref_no,uid,ddate,totvalue,tax from ".$moduledb.".invhead where accountno = ".$draccno." and sub = ".$drsubno;

// set the ouput format to json
$grid->dataType = 'json';

// Let the grid create the model
$grid->setColModel(null);

// Set the url from where we obtain the data
$grid->setUrl('getdrtrans.php');

// Set some grid options
$grid->setGridOptions(array(
    "rowNum"=>7,
    "sortname"=>"ddate",
	"sortorder"=>"desc",
    "rowList"=>array(7,50,100),
	"height"=>150,
	"width"=>750
    ));

$grid->addCol(array("name"=>"act"),"last");

// Change some property of the field(s)
$grid->setColProperty("ref_no", array("label"=>"Reference", "width"=>50));
$grid->setColProperty("uid", array("label"=>"ID", "width"=>25, "hidden"=>true));
$grid->setColProperty("ddate", array("label"=>"Date", "width"=>100, "formatter"=>"date", "formatoptions"=>array("srcformat"=> "Y-m-d", "newformat"=>"d/m/Y")));
$grid->setColProperty("totvalue", array("label"=>"Value", "width"=>100, "align"=>"right","formatter"=>"number"));
$grid->setColProperty("tax", array("label"=>"Tax", "width"=>100, "align"=>"right","formatter"=>"number"));
$grid->setColProperty("act", array("label"=>"Actions", "width"=>50));

$grid->setSubGrid("getAllocations.php",
        array('Date', 'Amount', 'From', 'To'),
        array(80,80,70,70),
        array('left','right','left','left'));

$loadevent = <<<LOADCOMPLETE
function(rowid){
	var ids = jQuery("#drtranslist").getDataIDs();
	for(var i=0;i<ids.length;i++){
			var rowd = $("#drtranslist").getRowData(ids<em class="d4pbbc-italic"></em>);
			var cl = ids<em class="d4pbbc-italic"></em>;
			var rf = "'"+rowd.ref_no+"'";
			be = '<img src="../images/into.png" title="View Transaction Details" onclick="javascript:viewtrans('+rf+')" ></ids>';
			se = '<img src="../images/printer.gif" title="Print Document" onclick="javascript:printdoc('+rf+')" ></ids>';
			jQuery("#drtranslist").setRowData(ids<em class="d4pbbc-italic"></em>,{act:be+'&nbsp;&nbsp;&nbsp;'+se}); 
	}
}
LOADCOMPLETE;

$grid->setGridEvent("loadComplete",$loadevent);
// Enable navigator
$grid->navigator = true;
// Disable some actions
$grid->setNavOptions('navigator', array("excel"=>true,"add"=>false,"edit"=>false,"del"=>false,"view"=>false));

// Run the script
$grid->renderGrid('#drtranslist','#drtranspager',true, null, null,true,true,true);

include 'jq-config.php';

// include the jqGrid Class

require_once "../includes/jquery/php/jqGrid.php";

// include the PDO driver class

require_once "../includes/jquery/php/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

if(isset ($_REQUEST["cid"])) {

$id = jqGridUtils::Strip($_REQUEST["cid"]);

$i = explode('~',$id);

$draccno = $i[0];

$drsubno = $i[1];

} else {

$draccno = 0;

$drsubno = 0;

}

// Create the jqGrid instance

$grid = new jqGridRender($conn);

// the actual query for the grid data

$grid->SelectCommand = "select ref_no,uid,ddate,totvalue,tax from ".$moduledb.".invhead where accountno = ".$draccno." and sub = ".$drsubno;

// set the ouput format to json

$grid->dataType = 'json';

// Let the grid create the model

$grid->setColModel(null);

// Set the url from where we obtain the data

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

// Set some grid options

$grid->setGridOptions(array(

"rowNum"=>7,

"sortname"=>"ddate",

"sortorder"=>"desc",

"rowList"=>array(7,50,100),

"height"=>150,

"width"=>750

));

$grid->addCol(array("name"=>"act"),"last");

// Change some property of the field(s)

$grid->setColProperty("ref_no", array("label"=>"Reference", "width"=>50));

$grid->setColProperty("uid", array("label"=>"ID", "width"=>25, "hidden"=>true));

$grid->setColProperty("ddate", array("label"=>"Date", "width"=>100, "formatter"=>"date", "formatoptions"=>array("srcformat"=> "Y-m-d", "newformat"=>"d/m/Y")));

$grid->setColProperty("totvalue", array("label"=>"Value", "width"=>100, "align"=>"right","formatter"=>"number"));

$grid->setColProperty("tax", array("label"=>"Tax", "width"=>100, "align"=>"right","formatter"=>"number"));

$grid->setColProperty("act", array("label"=>"Actions", "width"=>50));

$grid->setSubGrid("getAllocations.php",

array('Date', 'Amount', 'From', 'To'),

array(80,80,70,70),

array('left','right','left','left'));

$loadevent = <<<LOADCOMPLETE

function(rowid){

var ids = jQuery("#drtranslist").getDataIDs();

for(var i=0;i<ids.length;i++){

var rowd = $("#drtranslist").getRowData(ids);

var cl = ids;

var rf = "'"+rowd.ref_no+"'";

be = '<img src="../images/into.png" title="View Transaction Details" onclick="javascript:viewtrans('+rf+')" ></ids>';

se = '<img src="../images/printer.gif" title="Print Document" onclick="javascript:printdoc('+rf+')" ></ids>';

jQuery("#drtranslist").setRowData(ids,{act:be+'   '+se});

}

LOADCOMPLETE;

$grid->setGridEvent("loadComplete",$loadevent);

// Enable navigator

$grid->navigator = true;

// Disable some actions

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

// Run the script

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

Sub Grid code

include 'jq-config.php';
// include the jqGrid Class
require_once "../includes/jquery/php/jqGrid.php";
// include the PDO driver class
require_once "../includes/jquery/php/jqGridPdo.php";
// Connection to the server
$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);

// Get the needed parameters passed from the main grid
$rowid = jqGridUtils::Strip($_REQUEST["id"]);
if(!$rowid) die("Missed parameters"); 

// Create the jqGrid instance
$grid = new jqGrid($conn);
// Write the SQL Query
$grid->SubgridCommand = "select ddate,amount,fromref,toref from allocations where (fromref = '".$rowid."' or toref = '".$rowid."')";
 

// set the ouput format to json
$grid->dataType = 'json';
// Use the build in function for the simple subgrid
$grid->querySubGrid(array(&$rowid));
$conn = null;

include 'jq-config.php';

// include the jqGrid Class

require_once "../includes/jquery/php/jqGrid.php";

// include the PDO driver class

require_once "../includes/jquery/php/jqGridPdo.php";

// Connection to the server

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

// Get the needed parameters passed from the main grid

$rowid = jqGridUtils::Strip($_REQUEST["id"]);

if(!$rowid) die("Missed parameters");

// Create the jqGrid instance

$grid = new jqGrid($conn);

// Write the SQL Query

$grid->SubgridCommand = "select ddate,amount,fromref,toref from allocations where (fromref = '".$rowid."' or toref = '".$rowid."')";

// set the ouput format to json

$grid->dataType = 'json';

// Use the build in function for the simple subgrid

$grid->querySubGrid(array(&$rowid));

$conn = null;

This same methodology works elsewhere. Please let me know what I am doing wrong here.

Regards
Murray

This topic was modified 8 years, 8 months ago by tony. Reason: formatting code
This topic was modified 8 years, 8 months ago by tony.

Creator

Topic

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

Author

Replies

January 3, 2015 at 11:29 am #115115

tony

Keymaster

Hello,

First of all When you post a code in the futore use the crayon button to format a code. it is much better.

I think that the problem is a typo when you set the grid – you set it with capital Letter while they are not in the database select try with this code:

$grid->setSubGrid("getAllocations.php",
        array('ddate', 'amount', 'fromref', 'toref'),
        array(80,80,70,70),
        array('left','right','left','left'));

$grid->setSubGrid("getAllocations.php",

array('ddate', 'amount', 'fromref', 'toref'),

array(80,80,70,70),

array('left','right','left','left'));

or change the Select command in subgrid like:

$grid->SubgridCommand = "select ddate AS Date,amount AS Amount, fromref AS From, toref AS TO from allocations where (fromref = '".$rowid."' or toref = '".$rowid."')";

1	$grid->SubgridCommand = "select ddate AS Date,amount AS Amount, fromref AS From, toref AS TO from allocations where (fromref = '".$rowid."' or toref = '".$rowid."')";

The second method maybe will not work, because of reserved words in the SQL

Regards

This reply was modified 8 years, 8 months ago by tony. Reason: Adding a comment

January 3, 2015 at 11:48 pm #115125

sagana

Participant

Thank you Tony, capitilsation changed and reserved from and to changed and it all works.

Regards
Murray

January 5, 2015 at 12:53 pm #115143

Subgrid empty

Search Forum

Recent Replies

Forum Statistics

UserOnline