Guriddo » Topic: test

test

Guriddo
test

This topic has 5 replies, 2 voices, and was last updated 9 years, 10 months ago by kgrogers.

Creator

Topic

June 16, 2016 at 6:19 pm #125296

kgrogers

Participant

Hi All

I’ve been searching the forums and the web and found examples of dependent dropdowns for the filterToolBar, but all of them seem to related to editing the grid.

I have a simple grid that has 4 columns to filter by. What I am trying to achieve is that when I choose an item from the first column’s filter dropdown, it will change the option list of the 2nd, 3rd and 4th columns option list based on the selected value from column 1. Then when a value is selected from column 2’s list, columns 3 and 4 options are updated with the selected options from columns 1 and 2, and so on.

Here’s my php code:

require_once &#039;/var/www/html/jqSuite460/jq-config.php&#039;;
require_once ABSPATH.&quot;php/jqGrid.php&quot;;
require_once ABSPATH.&quot;php/jqGridPdo.php&quot;;

$db = new PDO(DB_DSN.&#039;cds&#039;,DB_USER,DB_PASSWORD);

$where = &quot;where (ipv4 != &#039;n/a&#039; and
        ipv4 != &#039;N/A&#039; and
     ipv4 != &#039;&#039;)&quot;;

if (isset($_REQUEST[&#039;filters&#039;])) {
 $filters = json_decode($_REQUEST[&#039;filters&#039;],true);
 foreach ($filters[&#039;rules&#039;] as $key =&gt; $val) {
  switch ($val[&#039;field&#039;]) {
   case &quot;platform&quot;:
    $where = $where .&quot; and platform = &#039;{$val[&#039;data&#039;]}&#039;&quot;;
    break;
   case &quot;location&quot;:
    $where = $where .&quot; and location = &#039;{$val[&#039;data&#039;]}&#039;&quot;;
    break;
   case &quot;nec&quot;:
    $where = $where .&quot; and nec = &#039;{$val[&#039;data&#039;]}&#039;&quot;;
    break;
   case &quot;voltepodp&quot;:
    $where = $where .&quot; and pod = &#039;{$val[&#039;data&#039;]}&#039;&quot;;
    break;
  }
 }
}
//print_r(json_decode($_REQUEST[&#039;filters&#039;],true));
//print $where;

$grid = new jqGridRender($db);
$Model = array(
 array(&quot;name&quot;=&gt;&quot;platform&quot;,&quot;label&quot;=&gt;&quot;Platform&quot;,&quot;width&quot;=&gt;110),
 array(&quot;name&quot;=&gt;&quot;location&quot;,&quot;label&quot;=&gt;&quot;Location&quot;,&quot;width&quot;=&gt;140),
 array(&quot;name&quot;=&gt;&quot;nec&quot;,&quot;label&quot;=&gt;&quot;NEC&quot;,&quot;width&quot;=&gt;72),
 array(&quot;name&quot;=&gt;&quot;pod&quot;,&quot;label&quot;=&gt;&quot;Pod&quot;,&quot;width&quot;=&gt;80),
 array(&quot;name&quot;=&gt;&quot;hostname&quot;,&quot;label&quot;=&gt;&quot;Hostname&quot;,&quot;width&quot;=&gt;162),
 array(&quot;name&quot;=&gt;&quot;testtime&quot;,&quot;label&quot;=&gt;&quot;Last Tested&quot;,&quot;width&quot;=&gt;125),
 array(&quot;name&quot;=&gt;&quot;ftp&quot;,&quot;width&quot;=&gt;63,&quot;align&quot;=&gt;&quot;center&quot;),
 array(&quot;name&quot;=&gt;&quot;ssh&quot;,&quot;width&quot;=&gt;63,&quot;align&quot;=&gt;&quot;center&quot;),
 array(&quot;name&quot;=&gt;&quot;telnet&quot;,&quot;width&quot;=&gt;65,&quot;align&quot;=&gt;&quot;center&quot;),
 array(&quot;name&quot;=&gt;&quot;rsh&quot;,&quot;width&quot;=&gt;63,&quot;align&quot;=&gt;&quot;center&quot;),
 array(&quot;name&quot;=&gt;&quot;rlogin&quot;,&quot;width&quot;=&gt;65,&quot;align&quot;=&gt;&quot;center&quot;)
);

$sql = &quot;
 select  platform,
   location,
   nec,
   pod,
   hostname,
   testtime,
   ftp,
   ssh,
   telnet,
   rsh,
   rlogin
 from inventory1 i
  left join portaudit p
   on i.id = p.id
 {$where}&quot;;

$grid-&gt;SelectCommand = $sql;
$grid-&gt;dataType = &#039;json&#039;;
$grid-&gt;setColModel($Model);
$grid-&gt;setURL(&#039;auditdata.php&#039;);
$grid-&gt;setGridOptions(array(
 &quot;hidegrid&quot;=&gt;false,
 &quot;sortname&quot;=&gt;&quot;testtime&quot;,
 &quot;sortorder&quot;=&gt;&quot;desc&quot;,
 &quot;emptyrecords&quot;=&gt;&quot;No Errors Found&quot;,
 &quot;rowNum&quot;=&gt;16,
 &quot;hoverrows&quot;=&gt;true,
 &quot;rowList&quot;=&gt;array(15,30,60),
 &quot;shrinkToFit&quot;=&gt;true,
 &quot;height&quot;=&gt;&quot;auto&quot;,
 &quot;width&quot;=&gt;&quot;auto&quot;,
));
$grid-&gt;toolbarfilter = true;
$grid-&gt;setSelect(&quot;platform&quot;,&quot;select distinct platform, platform platformList from inventory1 {$where} order by platform&quot;,false,false,true,array(&quot;&quot;=&gt;&quot;All&quot;));
$grid-&gt;setSelect(&quot;location&quot;,&quot;select distinct location, location locationList from inventory1 {$where} order by location&quot;,false,false,true,array(&quot;&quot;=&gt;&quot;All&quot;));
$grid-&gt;setSelect(&quot;nec&quot;,&quot;select distinct nec, nec necList from inventory1 {$where} order by nec&quot;,false,false,true,array(&quot;&quot;=&gt;&quot;All&quot;));
$grid-&gt;setSelect(&quot;pod&quot;,&quot;select distinct pod, pod podList from inventory1 {$where} order by pod&quot;,false,false,true,array(&quot;&quot;=&gt;&quot;All&quot;));
$grid-&gt;setSelect(&quot;ftp&quot;,&quot;select distinct ftp, ftp ftpList from portaudit order by ftp&quot;,false,false,true,array(&quot;&quot;=&gt;&quot;All&quot;));
$grid-&gt;setSelect(&quot;ssh&quot;,&quot;select distinct ssh, ssh sshList from portaudit order by ssh&quot;,false,false,true,array(&quot;&quot;=&gt;&quot;All&quot;));
$grid-&gt;setSelect(&quot;telnet&quot;,&quot;select distinct telnet, telnet telnetList from portaudit order by telnet&quot;,false,false,true,array(&quot;&quot;=&gt;&quot;All&quot;));
$grid-&gt;setSelect(&quot;rsh&quot;,&quot;select distinct rsh, rsh rshList from portaudit order by rsh&quot;,false,false,true,array(&quot;&quot;=&gt;&quot;All&quot;));
$grid-&gt;setSelect(&quot;rlogin&quot;,&quot;select distinct rlogin, rlogin rloginList from portaudit order by rlogin&quot;,false,false,true,array(&quot;&quot;=&gt;&quot;All&quot;));
$grid-&gt;navigator = true;
$grid-&gt;setNavOptions(&#039;navigator&#039;,array(&quot;excel&quot;=&gt;true,&quot;csv&quot;=&gt;true,&quot;add&quot;=&gt;false,&quot;edit&quot;=&gt;false,&quot;del&quot;=&gt;false,&quot;search&quot;=&gt;true,&quot;view&quot;=&gt;true));
$grid-&gt;setNavOptions(&#039;search&#039;, array(&quot;multipleGroup&quot;=&gt;true,&quot;showQuery&quot;=&gt;true));
$grid-&gt;setNavOptions(&#039;view&#039;,array(&quot;width&quot;=&gt;350,&quot;height&quot;=&gt;400,&quot;dataheight&quot;=&gt;300,&quot;top&quot;=&gt;150,&quot;left&quot;=&gt;250));
$grid-&gt;renderGrid(&#039;#grid&#039;,&#039;#pager&#039;,true,null,null,true,true);

require_once '/var/www/html/jqSuite460/jq-config.php';

require_once ABSPATH."php/jqGrid.php";

require_once ABSPATH."php/jqGridPdo.php";

$db = new PDO(DB_DSN.'cds',DB_USER,DB_PASSWORD);

$where = "where (ipv4 != 'n/a' and

ipv4 != 'N/A' and

ipv4 != '')";

if (isset($_REQUEST['filters'])) {

$filters = json_decode($_REQUEST['filters'],true);

foreach ($filters['rules'] as $key => $val) {

switch ($val['field']) {

case "platform":

$where = $where ." and platform = '{$val['data']}'";

break;

case "location":

$where = $where ." and location = '{$val['data']}'";

break;

case "nec":

$where = $where ." and nec = '{$val['data']}'";

break;

case "voltepodp":

$where = $where ." and pod = '{$val['data']}'";

break;

}

//print_r(json_decode($_REQUEST['filters'],true));

//print $where;

$grid = new jqGridRender($db);

$Model = array(

array("name"=>"platform","label"=>"Platform","width"=>110),

array("name"=>"location","label"=>"Location","width"=>140),

array("name"=>"nec","label"=>"NEC","width"=>72),

array("name"=>"pod","label"=>"Pod","width"=>80),

array("name"=>"hostname","label"=>"Hostname","width"=>162),

array("name"=>"testtime","label"=>"Last Tested","width"=>125),

array("name"=>"ftp","width"=>63,"align"=>"center"),

array("name"=>"ssh","width"=>63,"align"=>"center"),

array("name"=>"telnet","width"=>65,"align"=>"center"),

array("name"=>"rsh","width"=>63,"align"=>"center"),

array("name"=>"rlogin","width"=>65,"align"=>"center")

);

$sql = "

select platform,

location,

nec,

pod,

hostname,

testtime,

ftp,

ssh,

telnet,

rsh,

rlogin

from inventory1 i

left join portaudit p

on i.id = p.id

{$where}";

$grid->SelectCommand = $sql;

$grid->dataType = 'json';

$grid->setColModel($Model);

$grid->setURL('auditdata.php');

$grid->setGridOptions(array(

"hidegrid"=>false,

"sortname"=>"testtime",

"sortorder"=>"desc",

"emptyrecords"=>"No Errors Found",

"rowNum"=>16,

"hoverrows"=>true,

"rowList"=>array(15,30,60),

"shrinkToFit"=>true,

"height"=>"auto",

"width"=>"auto",

));

$grid->toolbarfilter = true;

$grid->setSelect("platform","select distinct platform, platform platformList from inventory1 {$where} order by platform",false,false,true,array(""=>"All"));

$grid->setSelect("location","select distinct location, location locationList from inventory1 {$where} order by location",false,false,true,array(""=>"All"));

$grid->setSelect("nec","select distinct nec, nec necList from inventory1 {$where} order by nec",false,false,true,array(""=>"All"));

$grid->setSelect("pod","select distinct pod, pod podList from inventory1 {$where} order by pod",false,false,true,array(""=>"All"));

$grid->setSelect("ftp","select distinct ftp, ftp ftpList from portaudit order by ftp",false,false,true,array(""=>"All"));

$grid->setSelect("ssh","select distinct ssh, ssh sshList from portaudit order by ssh",false,false,true,array(""=>"All"));

$grid->setSelect("telnet","select distinct telnet, telnet telnetList from portaudit order by telnet",false,false,true,array(""=>"All"));

$grid->setSelect("rsh","select distinct rsh, rsh rshList from portaudit order by rsh",false,false,true,array(""=>"All"));

$grid->setSelect("rlogin","select distinct rlogin, rlogin rloginList from portaudit order by rlogin",false,false,true,array(""=>"All"));

$grid->navigator = true;

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

$grid->setNavOptions('search', array("multipleGroup"=>true,"showQuery"=>true));

$grid->setNavOptions('view',array("width"=>350,"height"=>400,"dataheight"=>300,"top"=>150,"left"=>250));

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

This is working in that it sets the $where variable correctly, however since the toolbar filters don’t reload when the grid reloads the option lists for the subsequent columns don’t get repopulated.

Is the a way to cause the selSelects to all refresh along with the grid?

Ken

This topic was modified 9 years, 10 months ago by kgrogers.

Creator

Topic

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

Author

Replies
June 17, 2016 at 10:57 am #125298

guriddo.support
Participant

Hello,

I’m not sure that I understand the question.

The PHP setSelect command is executed only once when the grid initializes. All other reloads, search and etc do not executes setSelect, so that that it refresh its values (If I understand the problem right).

Maybe solution with JavaScript code will solve the problem.

Kind Regards,

Will

Guriddo Support Team

June 17, 2016 at 2:03 pm #125301
kgrogers
Participant
Will:

The fact that the setSelect commands only is excuted once is the problem. In essence that means you can only filter the entire table on only one column at a time. In other words, in my code above, the initial table yeilds around 5,000 rows (no filters appliaed). The user selects an option from the Platform column, the table refreshes with only those platforms that match the selected option. However, the Location drop-down still contains all of the locations, whereas it should only contain those locations that match the selected Platform. And so on…
What I am looking for is a way to filter the table based on all of the setSelects combined, in sequence of them being selected. I am sure it can be accomplished with javascript, I just can’t quite figure out how to do it. All of the examples in the forum for dependent drop-downs are for the editing forms – I want to make the setSelects (or some other javascript based method) dependent on each other simply to filter the table.
- This reply was modified 9 years, 10 months ago by kgrogers.
- This reply was modified 9 years, 10 months ago by kgrogers.
June 22, 2016 at 3:27 am #125323

kgrogers
Participant

Hello Guriddo? Anyone care to help me out here?

June 22, 2016 at 10:36 am #125329

guriddo.support
Participant

Hello,

If I understand right the problem you may use dataInit change event again for the selects and afterClear event in toolbar filter when a reload is in action.

1.In every select except for the last one use dataInit change event so that if one select is selected make a ajax call with this parameter and fill the next select with the desired data. For this purpose you will need to have a separate php file to get that data for every select. Every select has a id = gs_+ the name from colModel

2. Use afterClear event to release all the data in the seklect except the first

If you have difficulties with this we will try to prepare a example.

Kind Regards,

Will

Guriddo Support Team

June 22, 2016 at 4:47 pm #125333

kgrogers
Participant

Thanks, Will – I’ll give it a try and let you know…
Author

Replies