Guriddo » Topic: Problem with Search

Problem with Search

Guriddo
search
Problem with Search

Tagged: search

This topic has 9 replies, 2 voices, and was last updated 10 years, 1 month ago by guriddo.support.

Creator

Topic
March 21, 2016 at 9:41 pm #124998
vthokie11
Participant
I am having some issues with the search functionality. Below is what the GET request looks like. As you can see, none of the search parameters are set and there are a lot of escape characters included. Any ideas?

http://parrinc2.com/p/p_admin/allReportGrid.php?oper=grid&_search=true&nd=1458588658643&rows=50&page=1&sidx=company_id&sord=asc&from=2016-03-01&to=2016-03-21&filters=%7B%22groupOp%22%3A%22AND%22%2C%22rules%22%3A%5B%7B%22field%22%3A%22company_id%22%2C%22op%22%3A%22eq%22%2C%22data%22%3A%22CarMax%22%7D%5D%7D&searchField=&searchString=&searchOper=
- This topic was modified 10 years, 1 month ago by vthokie11.
- This topic was modified 10 years, 1 month ago by vthokie11.
Creator

Topic

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

Author

Replies

March 22, 2016 at 11:03 am #125006

guriddo.support

Participant

Hello,

Please in order to get correct support, please specify more details and code.

Escape characters does nothing to do with searching. You see them this way, but actually in php server side we get the the correct values.

What is your problem? What you set? What you do and how yo do this?

What you expect when you perform search?

A code demonstrating the problem is highly recommended.

Also which PHP version is used, Which browser, which browser version, which jqGrid version is used and etc.

I think you have a idea what you should do when you post a problem.

Kind Regards,

Will

This reply was modified 10 years, 1 month ago by guriddo.support.

Guriddo Support Team

March 22, 2016 at 5:23 pm #125010

vthokie11

Participant

Below is my entire grid. Its pretty simple. I’m just trying to get the default search working. I’ve been reference the Search Dialog demo from here, http://www.guriddo.net/demo/demos/jqgrid/ . I am using PHP version 5.5.22 and jqGrid version 4.8. I am using Google Chrome Version 48.0.2564.116 m. If I manually fill in the search parameters for the GET request then it works as expected.



&lt;?php

session_start ();
$_SESSION[&#039;path&#039;] = &quot;../../&quot;;

$groupswithaccess=&quot;OFFICE&quot;;
require_once(&quot;../../slpw/sitelokpw.php&quot;);
require_once (&#039;../php/common_functions.php&#039;);

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;);

$noRouteSelected = false;
$info = setRouteIDAndTabletID ();
$routeID = $info[&#039;route&#039;];
$tabletID = $info[&#039;tablet&#039;];
if(isset($info[&#039;name&#039;])) $nameID = $info[&#039;name&#039;];
else $nameID = &quot;&quot;;

$truckID = -1;
$trailerID = &quot;&quot;;
$employeeCount = 0;
$q = jqGridDB::query($conn, &quot;SELECT truck_id, trailer_id, employee_count
FROM route_expense WHERE date_purchased IS NOT NULL and route_id = &#039;$routeID&#039; and name_id = &#039;$nameID&#039;&quot;);
while($row = jqGridDB::fetch_num($q)) {
$truckID = $row[0];
$trailerID = $row[1];
$employeeCount = $row[2];
}

// Create the jqGrid instance
$grid = new jqGridRender($conn);
// Write the SQL Query
$grid-&gt;SelectCommand = &quot;SELECT * from maint_ows where route_id = &#039;$routeID&#039; and name_id = &#039;$nameID&#039;&quot;;

$grid-&gt;setUserDate (&#039;Y-m-d&#039;);

// Set the table to where we add the data
$grid-&gt;table = &#039;maint_ows&#039;;
// We tell that the primary key is not serial, which should be inserted by the user
$grid-&gt;serialKey = true;
// Set output 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;editStopsGrid.php&#039;);
// Set some grid options
$grid-&gt;setGridOptions(array(
&quot;rowNum&quot;=&gt;50,
&quot;rowList&quot;=&gt;array(50,100,500),
&quot;sortname&quot;=&gt;&quot;date_finished&quot;,
&quot;autowidth&quot;=&gt;true,
&quot;height&quot;=&gt;475,
));
// The primary key should be entered
$grid-&gt;setColProperty(&#039;maint_task_id&#039;, array(&quot;label&quot;=&gt;&quot;Task ID&quot;, &quot;editoptions&quot;=&gt;array(&quot;readonly&quot;=&gt;true)));
$grid-&gt;setColProperty(&#039;maint_id&#039;, array(&quot;label&quot;=&gt;&quot;Maint. ID&quot;));
$grid-&gt;setColProperty(&#039;company_id&#039;, array(&quot;label&quot;=&gt;&quot;Company&quot;));
$grid-&gt;setColProperty(&#039;cat_4&#039;, array(&quot;label&quot;=&gt;&quot;Cat 4&quot;));
$grid-&gt;setColProperty(&#039;site_id&#039;, array(&quot;label&quot;=&gt;&quot;Site ID&quot;));
$grid-&gt;setColProperty(&#039;maint_type&#039;, array(&quot;label&quot;=&gt;&quot;Maint. Type&quot;));
$grid-&gt;setColProperty(&#039;route_id&#039;, array(&quot;label&quot;=&gt;&quot;Route ID&quot;));
$grid-&gt;setColProperty(&#039;tablet_id&#039;, array(&quot;label&quot;=&gt;&quot;Tablet ID&quot;));
$grid-&gt;setColProperty(&#039;name_id&#039;, array(&quot;label&quot;=&gt;&quot;Name ID&quot;));
$grid-&gt;setColProperty(&#039;arrival_time&#039;, array(&quot;label&quot;=&gt;&quot;Arrival Time&quot;));
$grid-&gt;setColProperty(&#039;date_created&#039;, array(&quot;label&quot;=&gt;&quot;Date Created&quot;));
$grid-&gt;setColProperty(&#039;lat&#039;, array(&quot;label&quot;=&gt;&quot;Lat.&quot;));
$grid-&gt;setColProperty(&#039;lon&#039;, array(&quot;label&quot;=&gt;&quot;Lon.&quot;));
$grid-&gt;setColProperty(&#039;odometer_reading&#039;, array(&quot;label&quot;=&gt;&quot;Odometer Reading&quot;));
$grid-&gt;setColProperty(&#039;water_treated_gal&#039;, array(&quot;label&quot;=&gt;&quot;Water Treated&quot;));
$grid-&gt;setColProperty(&#039;sludge_removed_gal&#039;, array(&quot;label&quot;=&gt;&quot;Sludge Removed&quot;));
$grid-&gt;setColProperty(&#039;trenches_cleaned&#039;, array(&quot;label&quot;=&gt;&quot;Trenches Cleaned&quot;));
$grid-&gt;setColProperty(&#039;trench_length_feet&#039;, array(&quot;label&quot;=&gt;&quot;Trench Length&quot;));
$grid-&gt;setColProperty(&#039;rodder_used&#039;, array(&quot;label&quot;=&gt;&quot;Rodder Used&quot;));
$grid-&gt;setColProperty(&#039;clean_comment&#039;, array(&quot;label&quot;=&gt;&quot;Clean Comment&quot;));
$grid-&gt;setColProperty(&#039;job_comment&#039;, array(&quot;label&quot;=&gt;&quot;Job Comment&quot;));
$grid-&gt;setColProperty(&#039;end_time&#039;, array(&quot;label&quot;=&gt;&quot;End Time&quot;));
$grid-&gt;setColProperty(&#039;date_finished&#039;, array(&quot;label&quot;=&gt;&quot;Date Finished&quot;));
$grid-&gt;setColProperty(&#039;truck_id&#039;, array(&quot;label&quot;=&gt;&quot;Truck ID&quot;));
$grid-&gt;setColProperty(&#039;trailer_id&#039;, array(&quot;label&quot;=&gt;&quot;Trailer ID&quot;));
$grid-&gt;setColProperty(&#039;employee_count&#039;, array(&quot;label&quot;=&gt;&quot;Employee Count&quot;));
// Enable navigator
$grid-&gt;navigator = true;
// Enable only adding
$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;search&quot;=&gt;true));

$onselrow = &lt;&lt;&lt; ONSELROW
function(rowid, selected)
{
if(rowid &amp;&amp; rowid !== lastSelection) {
$(&quot;#grid&quot;).jqGrid(&#039;restoreRow&#039;, lastSelection);
$(&quot;#grid&quot;).jqGrid(&#039;editRow&#039;, rowid, true);
lastSelection = rowid;
}
}
ONSELROW;

$grid-&gt;setNavEvent(&quot;edit&quot;,&quot;beforeSubmit&quot;,$submit);
$grid-&gt;setGridEvent(&#039;onSelectRow&#039;, $onselrow);
$grid-&gt;renderGrid(&#039;#grid&#039;,&#039;#pager&#039;,true, null, null, true,true);
$conn = null;
?&gt;

100

101

102

103

104

105

106

107

108

109

110

111

112

<?php

session_start ();

$_SESSION['path'] = "../../";

$groupswithaccess="OFFICE";

require_once("../../slpw/sitelokpw.php");

require_once ('../php/common_functions.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");

$noRouteSelected = false;

$info = setRouteIDAndTabletID ();

$routeID = $info['route'];

$tabletID = $info['tablet'];

if(isset($info['name'])) $nameID = $info['name'];

else $nameID = "";

$truckID = -1;

$trailerID = "";

$employeeCount = 0;

$q = jqGridDB::query($conn, "SELECT truck_id, trailer_id, employee_count

FROM route_expense WHERE date_purchased IS NOT NULL and route_id = '$routeID' and name_id = '$nameID'");

while($row = jqGridDB::fetch_num($q)) {

$truckID = $row[0];

$trailerID = $row[1];

$employeeCount = $row[2];

}

// Create the jqGrid instance

$grid = new jqGridRender($conn);

// Write the SQL Query

$grid->SelectCommand = "SELECT * from maint_ows where route_id = '$routeID' and name_id = '$nameID'";

$grid->setUserDate ('Y-m-d');

// Set the table to where we add the data

$grid->table = 'maint_ows';

// We tell that the primary key is not serial, which should be inserted by the user

$grid->serialKey = true;

// Set output 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('editStopsGrid.php');

// Set some grid options

$grid->setGridOptions(array(

"rowNum"=>50,

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

"sortname"=>"date_finished",

"autowidth"=>true,

"height"=>475,

));

// The primary key should be entered

$grid->setColProperty('maint_task_id', array("label"=>"Task ID", "editoptions"=>array("readonly"=>true)));

$grid->setColProperty('maint_id', array("label"=>"Maint. ID"));

$grid->setColProperty('company_id', array("label"=>"Company"));

$grid->setColProperty('cat_4', array("label"=>"Cat 4"));

$grid->setColProperty('site_id', array("label"=>"Site ID"));

$grid->setColProperty('maint_type', array("label"=>"Maint. Type"));

$grid->setColProperty('route_id', array("label"=>"Route ID"));

$grid->setColProperty('tablet_id', array("label"=>"Tablet ID"));

$grid->setColProperty('name_id', array("label"=>"Name ID"));

$grid->setColProperty('arrival_time', array("label"=>"Arrival Time"));

$grid->setColProperty('date_created', array("label"=>"Date Created"));

$grid->setColProperty('lat', array("label"=>"Lat."));

$grid->setColProperty('lon', array("label"=>"Lon."));

$grid->setColProperty('odometer_reading', array("label"=>"Odometer Reading"));

$grid->setColProperty('water_treated_gal', array("label"=>"Water Treated"));

$grid->setColProperty('sludge_removed_gal', array("label"=>"Sludge Removed"));

$grid->setColProperty('trenches_cleaned', array("label"=>"Trenches Cleaned"));

$grid->setColProperty('trench_length_feet', array("label"=>"Trench Length"));

$grid->setColProperty('rodder_used', array("label"=>"Rodder Used"));

$grid->setColProperty('clean_comment', array("label"=>"Clean Comment"));

$grid->setColProperty('job_comment', array("label"=>"Job Comment"));

$grid->setColProperty('end_time', array("label"=>"End Time"));

$grid->setColProperty('date_finished', array("label"=>"Date Finished"));

$grid->setColProperty('truck_id', array("label"=>"Truck ID"));

$grid->setColProperty('trailer_id', array("label"=>"Trailer ID"));

$grid->setColProperty('employee_count', array("label"=>"Employee Count"));

// Enable navigator

$grid->navigator = true;

// Enable only adding

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

$onselrow = <<< ONSELROW

function(rowid, selected)

{

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

$("#grid").jqGrid('restoreRow', lastSelection);

$("#grid").jqGrid('editRow', rowid, true);

lastSelection = rowid;

}

ONSELROW;

$grid->setNavEvent("edit","beforeSubmit",$submit);

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

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

$conn = null;

March 23, 2016 at 10:38 am #125014

guriddo.support

Participant

Hello,

Thank you for the information and code provided.
What you mean with default search?

I do not see any code for default search.

We have a demo called search upon loading – did you refer to this demo or something else.

What you mean with : If I manually fill in the search parameters for the GET request then it works as expected.

Kind Regards

Will

Guriddo Support Team

March 23, 2016 at 4:43 pm #125016

vthokie11

Participant

What I mean by default search is that I just set search = true in the navOptions

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

I was using the Search Dialog demo from here as a reference.

If I take the GET request and fill in the searchField, searchOper, and searchString the search works properly. As you can see from the original post those fields are not populated.

March 23, 2016 at 5:11 pm #125017

guriddo.support

Participant

Hello,

I think that the filters parameters should be get.

So lets go from the beginning.

Try to install our demo on your server.

Actually you will need just to set the config file.

My question is : Is the searching in demo working?

Kind Regards,

Will

Guriddo Support Team

March 23, 2016 at 5:25 pm #125018

vthokie11

Participant

The demo does work. I’ve included the GET request.

http://parrinc2.com/jqgrid/grid.php?oper=grid&_search=true&nd=1458746712544&rows=10&page=1&sidx=OrderID&sord=asc&searchField=OrderID&searchString=10248&searchOper=eq&filters=

Note that the searchOper, searchString, and searchField are properly populated.

This reply was modified 10 years, 1 month ago by vthokie11.

March 23, 2016 at 5:45 pm #125020

guriddo.support

Participant

From your initial post the searchField, SearchOper and etc are empty, but filters parameter is used.

With simple words the code check first for filters parameter and then searchOper and etc values.

Check to see if your filters string is correctly build.

Kind Regards,

Will

Guriddo Support Team

March 23, 2016 at 5:56 pm #125021

vthokie11

Participant

Ok so this is what the filters string unescapes to

{"groupOp":"AND","rules":[{"field":"company_id","op":"eq","data":"CarMax"}]}

the rules look correct, I’m not sure what the groupOp does ??

March 23, 2016 at 6:08 pm #125022

guriddo.support

Participant

The above means

...
SELECT .... FROM .... WHERE company_id = &#039;CarMax&#039;;
...

...

SELECT .... FROM .... WHERE company_id = 'CarMax';

...

Please, prepare a demo dump tables in the query and send your script code too. I’m sure that this way we will resolve the problem

Problem with Search

Search Forum

Recent Replies

Forum Statistics

UserOnline