Guriddo » Topic: No data in grid

No data in grid

Guriddo
No data in grid

This topic has 1 reply, 1 voice, and was last updated 7 years, 9 months ago by sagana.

Creator

Topic

July 21, 2018 at 6:46 pm #126927

sagana

Participant

This is old code that used to work. jqGrid ver 3.8. jqGrid.log returns

[time] => 2018-07-21 16:29:10
[query] => SELECT policies.policy_id,policies.policy_no,policies.provider,policies.renewal_date,policies.pay_period,providers.logon_url from policies,polowners,providers where policies.policy_id = polowners.policy_id and polowners.member_id = 20828 and policies.provider = providers.provider ORDER BY policy_no asc LIMIT 0, 12
[data] =>
[types] =>
[fields] =>
[primary] =>
[input] =>

which select statement correctly returns the records. The grid is being created but has no rows in it. Are you able to tell me why please. Code for grid as follows:-

&lt;?php
session_start();
$id = $_SESSION[&#039;s_memberid&#039;];

// where clause
$where = &quot; where policies.policy_id = polowners.policy_id and polowners.member_id = &quot;.$id.&quot; and policies.provider = providers.provider&quot;;

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

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

// enable debugging
$grid-&gt;debug = true;

// the actual query for the grid data
$grid-&gt;SelectCommand = &quot;SELECT policies.policy_id,policies.policy_no,policies.provider,policies.renewal_date,policies.pay_period,providers.logon_url from policies,polowners,providers &quot;.$where;

// 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;getpoliciesom.php&#039;);
// Set grid caption using the option caption
$grid-&gt;setGridOptions(array(
&quot;rowNum&quot;=&gt;12,
&quot;sortname&quot;=&gt;&quot;policy_no&quot;,
&quot;rowList&quot;=&gt;array(12,30,50),
&quot;height&quot;=&gt;115,
&quot;width&quot;=&gt;500
));

$grid-&gt;addCol(array(&quot;name&quot;=&gt;&quot;act&quot;),&quot;first&quot;);

// Change some property of the field(s)
$grid-&gt;setColProperty(&quot;policy_id&quot;, array(&quot;label&quot;=&gt;&quot;ID&quot;, &quot;width&quot;=&gt;20, &quot;hidden&quot;=&gt;true));
$grid-&gt;setColProperty(&quot;policy_no&quot;, array(&quot;label&quot;=&gt;&quot;Policy No.&quot;, &quot;width&quot;=&gt;70));
$grid-&gt;setColProperty(&quot;provider&quot;, array(&quot;label&quot;=&gt;&quot;Provider&quot;, &quot;width&quot;=&gt;90));
$grid-&gt;setColProperty(&quot;logon_url&quot;, array(&quot;label&quot;=&gt;&quot;Login&quot;, &quot;width&quot;=&gt;90, &quot;hidden&quot;=&gt;true));
//$grid-&gt;setColProperty(&quot;commenced&quot;, array(&quot;label&quot;=&gt;&quot;Commenced&quot;, &quot;width&quot;=&gt;70, &quot;formatter&quot;=&gt;&quot;date&quot;));
$grid-&gt;setColProperty(&quot;renewal_date&quot;, array(&quot;label&quot;=&gt;&quot;Renewal&quot;, &quot;width&quot;=&gt;70, &quot;formatter&quot;=&gt;&quot;date&quot;));
$grid-&gt;setColProperty(&quot;pay_period&quot;, array(&quot;label&quot;=&gt;&quot;Pay Period&quot;, &quot;width&quot;=&gt;70));
$grid-&gt;setColProperty(&quot;act&quot;, array(&quot;label&quot;=&gt;&quot;Actions&quot;, &quot;width&quot;=&gt;70));

// on select row we should post the policy id to second table and trigger it to reload the data
$selectcover = &lt;&lt;&lt;COVER
function(rowid, selected)
{
if(rowid != null) {
jQuery(&quot;#mcoverlisto&quot;).jqGrid(&#039;setGridParam&#039;,{postData:{polid:rowid}});
jQuery(&quot;#mcoverlisto&quot;).trigger(&quot;reloadGrid&quot;);
}
}
COVER;
$grid-&gt;setGridEvent(&#039;onSelectRow&#039;, $selectcover);

// We should clear the grid data on second grid on sorting, paging, etc.
$cleargrid = &lt;&lt;&lt;CLEAR
function(rowid, selected)
{
// clear the grid data and footer data
jQuery(&quot;#mcoverlisto&quot;).jqGrid(&#039;clearGridData&#039;,true);
}
CLEAR;

$grid-&gt;setGridEvent(&#039;onPaging&#039;, $cleargrid);
$grid-&gt;setGridEvent(&#039;onSortCol&#039;, $cleargrid);

$loadevent = &lt;&lt;&lt;LOADCOMPLETE
function(rowid){
var ids = jQuery(&quot;#mpolicylisto&quot;).getDataIDs();
for(var i=0;i&lt;ids.length;i++){
var rowd = $(&quot;#mpolicylisto&quot;).getRowData(ids<em class="d4pbbc-italic"></em>);
var prov = rowd.logon_url;
var provd = &quot;&#039;&quot;+prov+&quot;&#039;&quot;;
var from = &quot;&#039;m&#039;&quot;;
var mmember = $id;
var cl = ids<em class="d4pbbc-italic"></em>;
be = &#039;&lt;img src=&quot;../images/edit.png&quot; title=&quot;Edit&quot; onclick=&quot;javascript:editpolicy(&#039;+cl+&#039;,&#039;+from+&#039;,&#039;+mmember+&#039;)&quot; &gt;&#039;;
le = &#039;&lt;img src=&quot;../images/logonurl.gif&quot; title=&quot;Logon to Provider&quot; onclick=&quot;javascript:logonurl(&#039;+provd+&#039;)&quot; &gt;&#039;;
se = &#039;&lt;img src=&quot;../images/delete.png&quot; title=&quot;Delete&quot; onclick=&quot;javascript:delpolicy(&#039;+cl+&#039;,&#039;+from+&#039;,&#039;+mmember+&#039;)&quot; &gt;&#039;;
jQuery(&quot;#mpolicylisto&quot;).setRowData(ids<em class="d4pbbc-italic"></em>,{act:be+&#039;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&#039;+le+&#039;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&#039;+se}) ;
}
}
LOADCOMPLETE;

$grid-&gt;setGridEvent(&quot;loadComplete&quot;,$loadevent);

// Enable navigator
$grid-&gt;navigator = true;
// Disable some actions
$grid-&gt;setNavOptions(&#039;navigator&#039;, array(&quot;excel&quot;=&gt;true,&quot;add&quot;=&gt;false,&quot;edit&quot;=&gt;false,&quot;del&quot;=&gt;false,&quot;view&quot;=&gt;false));
// add a custom button via the build in callGridMethod
// note the js: before the function
$buttonoptions = array(&quot;#mpolicypagero&quot;,
array(&quot;buttonicon&quot;=&gt;&quot;ui-icon-plus&quot;,&quot;caption&quot;=&gt;&quot;&quot;,&quot;position&quot;=&gt;&quot;first&quot;,&quot;title&quot;=&gt;&quot;Add a policy&quot;, &quot;onClickButton&quot;=&gt;&quot;js: function(){addpolicy(&#039;m&#039;,&#039;O&#039;);}&quot;)
);
$grid-&gt;callGridMethod(&quot;#mpolicylisto&quot;, &quot;navButtonAdd&quot;, $buttonoptions);

// Run the script
$grid-&gt;renderGrid(&#039;#mpolicylisto&#039;,&#039;#mpolicypagero&#039;,true, null, null, true,true);

?&gt;

100

101

102

103

104

105

106

107

108

109

110

<?php

session_start();

$id = $_SESSION['s_memberid'];

// where clause

$where = " where policies.policy_id = polowners.policy_id and polowners.member_id = ".$id." and policies.provider = providers.provider";

require_once '../includes/jquery/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);

// Create the jqGrid instance

$grid = new jqGridRender($conn);

// enable debugging

$grid->debug = true;

// the actual query for the grid data

$grid->SelectCommand = "SELECT policies.policy_id,policies.policy_no,policies.provider,policies.renewal_date,policies.pay_period,providers.logon_url from policies,polowners,providers ".$where;

// 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('getpoliciesom.php');

// Set grid caption using the option caption

$grid->setGridOptions(array(

"rowNum"=>12,

"sortname"=>"policy_no",

"rowList"=>array(12,30,50),

"height"=>115,

"width"=>500

));

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

// Change some property of the field(s)

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

$grid->setColProperty("policy_no", array("label"=>"Policy No.", "width"=>70));

$grid->setColProperty("provider", array("label"=>"Provider", "width"=>90));

$grid->setColProperty("logon_url", array("label"=>"Login", "width"=>90, "hidden"=>true));

//$grid->setColProperty("commenced", array("label"=>"Commenced", "width"=>70, "formatter"=>"date"));

$grid->setColProperty("renewal_date", array("label"=>"Renewal", "width"=>70, "formatter"=>"date"));

$grid->setColProperty("pay_period", array("label"=>"Pay Period", "width"=>70));

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

// on select row we should post the policy id to second table and trigger it to reload the data

$selectcover = <<<COVER

function(rowid, selected)

{

if(rowid != null) {

jQuery("#mcoverlisto").jqGrid('setGridParam',{postData:{polid:rowid}});

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

}

COVER;

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

// We should clear the grid data on second grid on sorting, paging, etc.

$cleargrid = <<<CLEAR

function(rowid, selected)

{

// clear the grid data and footer data

jQuery("#mcoverlisto").jqGrid('clearGridData',true);

}

CLEAR;

$grid->setGridEvent('onPaging', $cleargrid);

$grid->setGridEvent('onSortCol', $cleargrid);

$loadevent = <<<LOADCOMPLETE

function(rowid){

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

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

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

var prov = rowd.logon_url;

var provd = "'"+prov+"'";

var from = "'m'";

var mmember = $id;

var cl = ids;

be = '<img src="../images/edit.png" title="Edit" onclick="javascript:editpolicy('+cl+','+from+','+mmember+')" >';

le = '<img src="../images/logonurl.gif" title="Logon to Provider" onclick="javascript:logonurl('+provd+')" >';

se = '<img src="../images/delete.png" title="Delete" onclick="javascript:delpolicy('+cl+','+from+','+mmember+')" >';

jQuery("#mpolicylisto").setRowData(ids,{act:be+'&nbsp;&nbsp;&nbsp;&nbsp;'+le+'&nbsp;&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));

// add a custom button via the build in callGridMethod

// note the js: before the function

$buttonoptions = array("#mpolicypagero",

array("buttonicon"=>"ui-icon-plus","caption"=>"","position"=>"first","title"=>"Add a policy", "onClickButton"=>"js: function(){addpolicy('m','O');}")

);

$grid->callGridMethod("#mpolicylisto", "navButtonAdd", $buttonoptions);

// Run the script

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

Creator

Topic

Viewing 1 replies (of 1 total)

Author

Replies
July 21, 2018 at 7:03 pm #126928

sagana
Participant

Sorry to bother you with this. Solved by using a later version (4. )
Author

Replies

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.

Stay connected with us in your favorite flavor!

No data in grid

Search Forum

Recent Replies

Forum Statistics

UserOnline