PHP jqGridRender::setAutocomplete方法代码示例

// include the datepicker class
require_once ABSPATH . "php/jqCalendar.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 OrderID, OrderDate, CustomerID, Freight, ShipName FROM orders';
// set the ouput format to json
$grid->dataType = 'json';
$grid->table = "orders";
$grid->setPrimaryKeyId("OrderID");
// 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" => "This is custom Caption", "rowNum" => 10, "sortname" => "OrderID", "hoverrows" => true, "rowList" => array(10, 20, 50)));
// Change some property of the field(s)
$grid->setColProperty("OrderID", array("label" => "ID", "width" => 60));
$grid->setColProperty("OrderDate", array("formatter" => "date", "formatoptions" => array("srcformat" => "Y-m-d H:i:s", "newformat" => "m/d/Y")));
$grid->setAutocomplete("ShipName", false, "SELECT DISTINCT ShipName FROM orders WHERE ShipName LIKE ? ORDER BY ShipName", null, true, true);
$grid->setDatepicker('OrderDate', null, true, true);
$grid->datearray = array('OrderDate');
// Enjoy
$grid->navigator = true;
$grid->setNavOptions('navigator', array("excel" => false));
$grid->renderGrid('#grid', '#pager', true, null, null, true, true);
$conn = null;

$grid->dataType = 'json';
$grid->datearray = array('startdate');
$grid->setUserDate("Y-m-d");
$grid->setColModel();
$grid->setUrl('../grids/client.php');
$grid->setColProperty("id", array("editable" => false, "width" => 40, "fixed" => true, "label" => "ID"));
$grid->setColProperty("companyname", array("editable" => true, "frozen" => true, "width" => 250, "editoptions" => array("size" => 75, "maxlength" => 250, "style" => "text-transform: uppercase"), "fixed" => true, "label" => "Company Name"));
$grid->setColProperty("email", array("editable" => true, "width" => 200, "editoptions" => array("size" => 75, "maxlength" => 250, "style" => "text-transform: lowercase"), "fixed" => true, "formatter" => "email", "editrules" => array("email" => true, "required" => true), "label" => "Email"));
$grid->setColProperty("phone", array("editable" => true, "width" => 150, "editoptions" => array("size" => 75, "maxlength" => 250), "fixed" => true, "label" => "Phone"));
$grid->setColProperty("status", array("editable" => true, "width" => 90, "fixed" => true, "label" => "Status", "edittype" => "select"));
$grid->setSelect("status", $vendorstatus, false, true, true, array("" => "All"));
$grid->setColProperty("url", array("editable" => true, "frozen" => true, "width" => 200, "editoptions" => array("size" => 75, "maxlength" => 200, "style" => "text-transform: lowercase"), "formatter" => "link", "formatoptions" => array("target" => "_blank"), "fixed" => true, "editrules" => array("url" => true, "required" => false), "label" => "Url"));
$grid->setColProperty("fax", array("editable" => true, "width" => 150, "editoptions" => array("size" => 75, "maxlength" => 250), "fixed" => true, "label" => "Fax"));
$grid->setColProperty("address", array("editable" => true, "width" => 150, "editoptions" => array("size" => 75, "maxlength" => 250), "fixed" => true, "label" => "Address"));
$grid->setColProperty("city", array("editable" => true, "width" => 120, "editoptions" => array("size" => 75, "maxlength" => 250), "fixed" => true, "label" => "City"));
$grid->setAutocomplete("city", null, "select name, name from (select distinct city as name from city) p where name like ? ORDER BY name", null, true, true);
$grid->setColProperty("state", array("editable" => true, "width" => 120, "editoptions" => array("size" => 75, "maxlength" => 250), "fixed" => true, "label" => "State"));
$grid->setAutocomplete("state", null, "select name, name from (SELECT distinct name FROM state)p where name like ? ORDER BY name", null, true, true);
$grid->setColProperty("country", array("editable" => true, "width" => 120, "editoptions" => array("size" => 75, "maxlength" => 250), "fixed" => true, "label" => "Country"));
$grid->setAutocomplete("country", null, "select name, name from (SELECT distinct short_name as name FROM country) p where name like ? ORDER BY name", null, true, true);
$grid->setColProperty("zip", array("editable" => true, "width" => 120, "editoptions" => array("size" => 75, "maxlength" => 250), "fixed" => true, "label" => "Zip"));
$grid->setAutocomplete("zip", null, "select name, name from (select zip as name from city) p where name like ? ORDER BY name", null, true, true);
$grid->setColProperty("twitter", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Twitter"));
$grid->setColProperty("facebook", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Facebook"));
$grid->setColProperty("linkedin", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Linkedin"));
$grid->setColProperty("manager1name", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Mgr Name"));
$grid->setColProperty("manager1email", array("editable" => true, "width" => 150, "fixed" => true, "formatter" => "email", "editrules" => array("email" => true, "required" => false), "label" => "Mgr Email"));
$grid->setColProperty("manager1phone", array("editable" => true, "width" => 90, "fixed" => true, "label" => "Mgr Phone"));
$grid->setColProperty("hmname", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Hiring Mgr Name"));
$grid->setColProperty("hmemail", array("editable" => true, "width" => 150, "fixed" => true, "formatter" => "email", "editrules" => array("email" => true, "required" => false), "label" => "Hiring Mgr Email"));
$grid->setColProperty("hmphone", array("editable" => true, "width" => 90, "fixed" => true, "label" => "Hiring Mgr Phone"));

$conn = new PDO(DB_DSN, DB_USER, DB_PASSWORD);
$conn->query("SET NAMES utf8");
$grid = new jqGridRender($conn);
$grid->SelectCommand = 'SELECT id, startdate, name, email, phone, wrkemail, wrkphone, status, communication, notes FROM proxy';
$grid->table = 'proxy';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
$grid->dataType = 'json';
$grid->datearray = array('startdate');
$grid->setUserDate("Y-m-d");
$grid->setColModel();
$grid->setUrl('proxy.php');
$grid->setColProperty("id", array("editable" => false, "width" => 25, "fixed" => true, "label" => "ID"));
$grid->setColProperty('startdate', array("editable" => false, "width" => 70, "fixed" => true, "formatter" => "date", "label" => "Start Date", "formatoptions" => array("srcformat" => "Y-m-d HH:MM:SS", "newformat" => "m/d/Y"), "searchoptions" => array("dataInit" => "js:function(elm){setTimeout(function(){\n\t\t\t\t\t jQuery(elm).datepicker({dateFormat:'yy-mm-dd'});\n\t\t\t\t\t jQuery('.ui-datepicker').css({'font-size':'75%'});\n\t\t\t },200);}")));
$grid->setColProperty("name", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Name"));
$grid->setAutocomplete("name", null, "select name, name from (SELECT distinct name FROM leads union select distinct name from candidate union select distinct name from recruit) p where name like ? ORDER BY name", null, true, true);
$grid->setColProperty("email", array("editable" => true, "width" => 150, "fixed" => true, "formatter" => "email", "editrules" => array("email" => true, "required" => true), "label" => "Email"));
$grid->setAutocomplete("email", null, "select email, email from (SELECT distinct email FROM leads union select distinct email from candidate union select distinct email from recruit) p where email like ? ORDER BY email", null, true, true);
$grid->setColProperty("phone", array("editable" => true, "width" => 90, "fixed" => true, "label" => "Phone"));
$grid->setAutocomplete("phone", null, "select phone, phone from (SELECT distinct phone FROM leads union select distinct phone from candidate union select distinct phone from recruit) p where phone like ? ORDER BY phone", null, true, true);
$grid->setColProperty("wrkemail", array("editable" => true, "width" => 150, "fixed" => true, "formatter" => "email", "editrules" => array("email" => true, "required" => false), "label" => "Wrk Email"));
$grid->setAutocomplete("wrkemail", null, "select wrkemail, wrkemail from (SELECT distinct wrkemail FROM placement) p where wrkemail like ? ORDER BY wrkemail", null, true, true);
$grid->setColProperty("wrkphone", array("editable" => true, "width" => 90, "fixed" => true, "label" => "Wrk Phone"));
$grid->setAutocomplete("wrkphone", null, "select wrkphone, wrkphone from (SELECT distinct wrkphone FROM placement) p where wrkphone like ? ORDER BY wrkphone", null, true, true);
$grid->setColProperty("status", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Status", "edittype" => "select"));
$grid->setSelect("status", $referencestatus, false, true, true, array("" => "All"));
$grid->setColProperty("communication", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Communication", "edittype" => "select"));
$grid->setSelect("communication", $communication, false, true, true, array("" => "All"));
$grid->setColProperty("notes", array("editable" => true, "width" => 400, "fixed" => true, "edittype" => "textarea", "editoptions" => array("rows" => 6, "cols" => 60), "label" => "Notes"));
$grid->setGridOptions(array("sortable" => true, "width" => 1024, "height" => 250, "caption" => "Proxy Management", "rownumbers" => true, "rowNum" => 100, "sortname" => "status asc, startdate", "sortorder" => "desc", "toppager" => true, "rowList" => array(10, 20, 30, 50, 100)));
$grid->showError = true;

$grid->setColProperty("mmid", array("editable" => true, "frozen" => true, "width" => 100, "fixed" => true, "label" => "Manager", "edittype" => "select"));
$grid->setSelect("mmid", "SELECT distinct id, name FROM employee where id = {$employeeid} or mgrid = {$employeeid}  order by name");
$grid->setColProperty("interviewdate", array("formatter" => "date", "width" => 80, "fixed" => true, "formatoptions" => array("srcformat" => "Y-m-d", "newformat" => "Y-m-d", "elmprefix" => " ", "rowpos" => 5, "colpos" => 1), "editable" => true, "label" => "Date", "editoptions" => array("dataInit" => "js:function(elm){setTimeout(function(){\n                    \t\t\t\t\t\t\t jQuery(elm).datepicker({dateFormat:'yy-mm-dd'});\n                    \t\t\t\t\t\t\t jQuery('.ui-datepicker').css({'font-size':'75%'});\n                \t\t\t\t\t\t\t\t\t },200);}"), "searchoptions" => array("dataInit" => "js:function(elm){setTimeout(function(){\n                    \t\t\t\t\t\t\t jQuery(elm).datepicker({dateFormat:'yy-mm-dd'});\n                    \t\t\t\t\t\t\t jQuery('.ui-datepicker').css({'font-size':'75%'});\n                \t\t\t\t\t\t\t\t\t },200);}")));
$grid->setColProperty("interviewhour", array("editable" => true, "width" => 50, "fixed" => true, "label" => "Time", "formoptions" => array("elmprefix" => " ", "rowpos" => 5, "colpos" => 1), "edittype" => "select"));
$grid->setSelect("interviewhour", $interviewhour, false, true, true, array("" => "All"));
$grid->setColProperty("interviewminute", array("editable" => true, "width" => 50, "fixed" => true, "label" => "Time", "formoptions" => array("elmprefix" => " ", "rowpos" => 5, "colpos" => 1), "edittype" => "select"));
$grid->setSelect("interviewminute", $interviewtime, false, true, true, array("" => "All"));
$grid->setColProperty("interviewdivision", array("editable" => true, "width" => 50, "fixed" => true, "label" => "Time", "formoptions" => array("elmprefix" => " ", "rowpos" => 5, "colpos" => 1), "edittype" => "select"));
$grid->setSelect("interviewdivision", $interviewdivision, false, true, true, array("" => "All"));
$grid->setColProperty("interviewtime", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Time"));
$grid->setColProperty("type", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Type", "edittype" => "select"));
$grid->setSelect("type", $interviewtype, false, true, true, array("" => "All"));
$grid->setColProperty("status", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Status", "edittype" => "select"));
$grid->setSelect("status", $interviewstatus, false, true, true, array("" => "All"));
$grid->setColProperty("clientname", array("editable" => true, "editoptions" => array("size" => 75, "maxlength" => 200), "width" => 90, "fixed" => true, "label" => "Client Name"));
$grid->setAutocomplete("clientname", null, "select companyname from (select v.companyname from vendor v union select c.companyname from client c union select distinct client from position union select distinct vendor1 from position union select distinct vendor2 from position union select distinct vendor3 from position) p  where companyname like ? ORDER BY companyname", null, true, true);
$grid->setColProperty("clientlocation", array("editable" => true, "width" => 90, "fixed" => true, "label" => "Client Location"));
$grid->setColProperty("interviewers", array("editable" => true, "width" => 90, "editoptions" => array("size" => 75, "maxlength" => 200), "fixed" => true, "label" => "Interviewers"));
$grid->setColProperty("interviewersphone", array("editable" => true, "width" => 90, "editoptions" => array("size" => 75, "maxlength" => 200), "fixed" => true, "label" => "Int. Phone"));
$grid->setColProperty("result", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Result", "edittype" => "select"));
$grid->setSelect("result", $interviewresult, false, true, true, array("" => "All"));
$grid->setColProperty("performance", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Performance", "edittype" => "select"));
$grid->setSelect("performance", $interviewperf, false, true, true, array("" => "All"));
$grid->setColProperty("client1email", array("editable" => true, "width" => 150, "fixed" => true, "editoptions" => array("size" => 75, "maxlength" => 200), "formatter" => "email", "editrules" => array("email" => true, "required" => false), "label" => "Client1 Email"));
$grid->setAutocomplete("client1email", null, "select email, email from (SELECT email FROM massemail union select distinct vendor1email from position union select distinct vendor2email from position union select distinct vendor3email from position union select v.email from vendor v union select r.email from recruiter r) p where email like ? ORDER BY email", null, true, true);
$grid->setColProperty("client2email", array("editable" => true, "width" => 150, "fixed" => true, "editoptions" => array("size" => 75, "maxlength" => 200), "formatter" => "email", "editrules" => array("email" => true, "required" => false), "label" => "Client2 Email"));
$grid->setAutocomplete("client2email", null, "select email, email from (SELECT email FROM massemail union select distinct vendor1email from position union select distinct vendor2email from position union select distinct vendor3email from position union select v.email from vendor v union select r.email from recruiter r) p where email like ? ORDER BY email", null, true, true);
$grid->setColProperty("client3email", array("editable" => true, "width" => 150, "fixed" => true, "editoptions" => array("size" => 75, "maxlength" => 200), "formatter" => "email", "editrules" => array("email" => true, "required" => false), "label" => "Client3 Email"));
$grid->setAutocomplete("client3email", null, "select email, email from (SELECT email FROM massemail union select distinct vendor1email from position union select distinct vendor2email from position union select distinct vendor3email from position union select v.email from vendor v union select r.email from recruiter r) p where email like ? ORDER BY email", null, true, true);
$grid->setColProperty("vendor1", array("editable" => true, "width" => 90, "editoptions" => array("size" => 75, "maxlength" => 200), "fixed" => true, "label" => "Vendor1"));
$grid->setAutocomplete("vendor1", null, "select companyname from (select v.companyname from vendor v union select c.companyname from client c union select distinct vendor1 from position union select distinct vendor2 from position union select distinct vendor3 from position) p  where companyname like ? ORDER BY companyname", null, true, true);

<?php

require_once $_SERVER["DOCUMENT_ROOT"] . "/ip-includes/gridincludes.php";
$grid = new jqGridRender($DB);
$grid->SelectCommand = 'SELECT candidateid, name, email, phone, course, batchname, enrolleddate, status, statuschangedate, processflag,diceflag, workstatus, education, workexperience, ssn, dob, portalid, wpexpirationdate,  ssnvalidated, secondaryemail, secondaryphone, address, city, state, country, zip, guarantorname, guarantordesignation, guarantorcompany, emergcontactname, emergcontactemail,  emergcontactphone, emergcontactaddrs, term, feepaid, feedue, referralid, salary0, salary6, salary12,originalresume, contracturl, empagreementurl, offerletterurl, dlurl, workpermiturl, ssnurl, notes FROM candidate';
$grid->table = 'candidate';
$grid->setPrimaryKeyId('candidateid');
$grid->serialKey = false;
$grid->dataType = 'json';
$grid->datearray = array('enrolleddate', 'wpexpirationdate', 'dob');
$grid->setUserDate("Y-m-d");
$grid->setColModel();
$grid->setUrl('../grids/candidate.php');
$grid->setColProperty("candidateid", array("editable" => false, "width" => 25, "fixed" => true, "label" => "ID"));
$grid->setColProperty("name", array("editable" => true, "frozen" => true, "width" => 200, "editoptions" => array("size" => 75, "maxlength" => 200), "fixed" => true, "label" => "Name"));
$grid->setAutocomplete("name", null, "select name, name from (SELECT distinct name FROM leads union select distinct name from candidate union select distinct name from recruit) p where name like ? ORDER BY name", null, true, true);
$grid->setColProperty("enrolleddate", array("formatter" => "date", "width" => 70, "fixed" => true, "formatoptions" => array("srcformat" => "Y-m-d", "newformat" => "Y-m-d"), "editable" => true, "label" => "Enrolled Date", "editoptions" => array("dataInit" => "js:function(elm){setTimeout(function(){\n                    \t\t\t\t\t\t\t jQuery(elm).datepicker({dateFormat:'yy-mm-dd'});\n                    \t\t\t\t\t\t\t jQuery('.ui-datepicker').css({'font-size':'75%'});\n                \t\t\t\t\t\t\t\t\t },200);}"), "searchoptions" => array("dataInit" => "js:function(elm){setTimeout(function(){\n                    \t\t\t\t\t\t\t jQuery(elm).datepicker({dateFormat:'yy-mm-dd'});\n                    \t\t\t\t\t\t\t jQuery('.ui-datepicker').css({'font-size':'75%'});\n                \t\t\t\t\t\t\t\t\t },200);}")));
$grid->setColProperty("email", array("editable" => true, "width" => 150, "fixed" => true, "editoptions" => array("size" => 75, "maxlength" => 150), "formatter" => "email", "editrules" => array("email" => true, "required" => true), "label" => "Email"));
$grid->setAutocomplete("email", null, "select email, email from (SELECT distinct email FROM leads union select distinct email from candidate union select distinct email from recruit) p where email like ? ORDER BY email", null, true, true);
$grid->setColProperty("phone", array("editable" => true, "width" => 90, "fixed" => true, "label" => "Phone"));
$grid->setAutocomplete("phone", null, "select phone, phone from (SELECT distinct phone FROM leads union select distinct phone from candidate union select distinct phone from recruit) p where phone like ? ORDER BY phone", null, true, true);
$grid->setColProperty("course", array("editable" => true, "label" => "Course", "width" => 40, "fixed" => true, "edittype" => "select"));
$grid->setSelect("course", $courses, false, true, true, array("" => "All"));
$grid->setColProperty("status", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Status", "edittype" => "select"));
$grid->setSelect("status", $candidatestatus, false, true, true, array("" => "All"));
$grid->setColProperty("statuschangedate", array("formatter" => "date", "hidden" => true, "editrules" => array("edithidden" => true, "required" => false), "width" => 70, "fixed" => true, "formatoptions" => array("srcformat" => "Y-m-d", "newformat" => "Y-m-d"), "editable" => true, "label" => "Status Change Date", "editoptions" => array("dataInit" => "js:function(elm){setTimeout(function(){\n                    \t\t\t\t\t\t\t jQuery(elm).datepicker({dateFormat:'yy-mm-dd'});\n                    \t\t\t\t\t\t\t jQuery('.ui-datepicker').css({'font-size':'75%'});\n                \t\t\t\t\t\t\t\t\t },200);}"), "searchoptions" => array("dataInit" => "js:function(elm){setTimeout(function(){\n                    \t\t\t\t\t\t\t jQuery(elm).datepicker({dateFormat:'yy-mm-dd'});\n                    \t\t\t\t\t\t\t jQuery('.ui-datepicker').css({'font-size':'75%'});\n                \t\t\t\t\t\t\t\t\t },200);}")));
$grid->setColProperty("processflag", array("editable" => true, "hidden" => true, "editrules" => array("edithidden" => true, "required" => false), "label" => "Process", "width" => 50, "fixed" => true, "edittype" => "select"));
$grid->setSelect("processflag", $yesno, false, true, true, array("" => "All"));
$grid->setColProperty("diceflag", array("editable" => true, "editrules" => array("edithidden" => true, "required" => false), "label" => "Dice Candidate", "width" => 50, "fixed" => true, "edittype" => "select"));
$grid->setSelect("diceflag", $yesno, false, true, true, array("" => "All"));
$grid->setColProperty("workstatus", array("editable" => true, "width" => 70, "fixed" => true, "label" => "US Status", "edittype" => "select"));

$grid->setColProperty("id", array("editable" => false, "hidden" => true, "label" => "ID"));
$grid->setColProperty("cid", array("editable" => false, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Candidate Name", "edittype" => "select"));
$grid->setSelect("cid", "SELECT distinct candidateid as id, name as name FROM candidate order by name");
$grid->setColProperty("candidateid", array("editable" => true, "hidden" => true, "editrules" => array("edithidden" => true, "required" => false), "frozen" => true, "width" => 200, "fixed" => true, "label" => "Candidate Name", "edittype" => "select"));
$grid->setSelect("candidateid", "SELECT distinct candidateid as id, name as name FROM candidate where status in ('Marketing', 'Placed', 'OnProject-Mkt') order by name");
$grid->setColProperty("mmid", array("editable" => true, "frozen" => true, "width" => 100, "fixed" => true, "label" => "Manager", "edittype" => "select"));
$grid->setSelect("mmid", "SELECT distinct id, name FROM employee where id = {$employeeid} or mgrid = {$employeeid}  order by name");
$grid->setColProperty("positiondate", array("formatter" => "date", "width" => 80, "fixed" => true, "formatoptions" => array("srcformat" => "Y-m-d", "newformat" => "Y-m-d"), "editable" => true, "label" => "Position Date", "editoptions" => array("dataInit" => "js:function(elm){setTimeout(function(){\n                    \t\t\t\t\t\t\t jQuery(elm).datepicker({dateFormat:'yy-mm-dd'});\n                    \t\t\t\t\t\t\t jQuery('.ui-datepicker').css({'font-size':'75%'});\n                \t\t\t\t\t\t\t\t\t },200);}"), "searchoptions" => array("dataInit" => "js:function(elm){setTimeout(function(){\n                    \t\t\t\t\t\t\t jQuery(elm).datepicker({dateFormat:'yy-mm-dd'});\n                    \t\t\t\t\t\t\t jQuery('.ui-datepicker').css({'font-size':'75%'});\n                \t\t\t\t\t\t\t\t\t },200);}")));
$grid->setColProperty("type", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Type", "edittype" => "select"));
$grid->setSelect("type", $technology, false, true, true, array("" => "All"));
$grid->setColProperty("status", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Status", "edittype" => "select"));
$grid->setSelect("status", array("Scheduled" => "Scheduled", "Candidate Cancelled" => "Candidate Cancelled", "Cancelled" => "Cancelled"), false, true, true, array("" => "All"));
$grid->setColProperty("vendorcall", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Call", "edittype" => "select"));
$grid->setSelect("vendorcall", $yesno, false, true, true, array("" => "All"));
$grid->setColProperty("vendor1email", array("editable" => true, "width" => 200, "fixed" => true, "editoptions" => array("size" => 75, "maxlength" => 200), "formatter" => "email", "editrules" => array("email" => true, "required" => false), "label" => "Vendor1 Email"));
$grid->setAutocomplete("vendor1email", "#vendor1", "select email, email, vendor1 from (select r.email, (select companyname from vendor where id = r.vendorid) vendor1 from recruiter r union select distinct vendor1email as email, vendor1 from position) p where email like ? ORDER BY email", null, true, true);
$grid->setColProperty("vendor1", array("editable" => true, "width" => 90, "fixed" => true, "editoptions" => array("size" => 75, "maxlength" => 200), "label" => "Vendor1"));
$grid->setAutocomplete("vendor1", null, "select companyname from (select v.companyname from vendor v union select c.companyname from client c union select distinct vendor1 from position) p  where companyname like ? ORDER BY companyname", null, true, true);
$grid->setColProperty("clientemail", array("editable" => true, "width" => 150, "fixed" => true, "editoptions" => array("size" => 75, "maxlength" => 200), "formatter" => "email", "editrules" => array("email" => true, "required" => false), "label" => "Client Email"));
$grid->setAutocomplete("clientemail", "#client", "select email, email, client from (select r.email, (select companyname from vendor where id = r.clientid) client from recruiter r union select distinct clientemail as email, client from position) p where email like ? ORDER BY email", null, true, true);
$grid->setColProperty("client", array("editable" => true, "width" => 200, "fixed" => true, "editoptions" => array("size" => 75, "maxlength" => 200), "label" => "Client"));
$grid->setColProperty("client", array("editable" => true, "width" => 90, "fixed" => true, "editoptions" => array("size" => 75, "maxlength" => 200), "label" => "Client"));
$grid->setAutocomplete("client", null, "select companyname from (select c.companyname from client c union select distinct client from position) p  where companyname like ? ORDER BY companyname", null, true, true);
$grid->setColProperty("vendor2email", array("editable" => true, "width" => 200, "fixed" => true, "formatter" => "email", "editoptions" => array("size" => 75, "maxlength" => 200), "editrules" => array("email" => true, "required" => false), "label" => "Vendor2 Email"));
$grid->setAutocomplete("vendor2email", "#vendor2", "select email, email, vendor2 from (select r.email, (select companyname from vendor where id = r.vendorid) vendor2 from recruiter r union select distinct vendor1email as email, vendor1 from position) p where email like ? ORDER BY email", null, true, true);
$grid->setColProperty("vendor2", array("editable" => true, "width" => 90, "fixed" => true, "editoptions" => array("size" => 75, "maxlength" => 200), "label" => "Vendor2"));
$grid->setColProperty("vendor2", array("editable" => true, "width" => 90, "fixed" => true, "editoptions" => array("size" => 75, "maxlength" => 200), "label" => "Vendor2"));
$grid->setAutocomplete("vendor2", null, "select companyname from (select v.companyname from vendor v union select c.companyname from client c union select distinct vendor1 from position) p  where companyname like ? ORDER BY companyname", null, true, true);
$grid->setColProperty("vendor3email", array("editable" => true, "width" => 200, "fixed" => true, "formatter" => "email", "editoptions" => array("size" => 75, "maxlength" => 200), "editrules" => array("email" => true, "required" => false), "label" => "Vendor3 Email"));
$grid->setAutocomplete("vendor3email", "#vendor3", "select email, email, vendor3 from (select r.email, (select companyname from vendor where id = r.vendorid) vendor3 from recruiter r union select distinct vendor1email as email, vendor1 from position) p where email like ? ORDER BY email", null, true, true);
$grid->setColProperty("vendor2", array("editable" => true, "width" => 90, "fixed" => true, "editoptions" => array("size" => 75, "maxlength" => 200), "label" => "Vendor2"));

$grid->SelectCommand = 'SELECT OrderID, OrderDate, CustomerID, Freight, ShipName FROM orders';
// set the ouput format to json
$grid->dataType = 'json';
$grid->table = "orders";
$grid->setPrimaryKeyId("OrderID");
// Let the grid create the model
$grid->setColModel();
// Set the url from where we obtain the data
$grid->setUrl('grid.php');
$grid->cacheCount = true;
// Set grid caption using the option caption
$grid->setGridOptions(array("caption" => "This is custom Caption", "rowNum" => 10, "sortname" => "OrderID", "hoverrows" => true, "rowList" => array(10, 20, 50), "postData" => array("grid_recs" => 776)));
// Change some property of the field(s)
$grid->setColProperty("OrderID", array("label" => "ID", "width" => 60, "editable" => false));
$grid->setColProperty("OrderDate", array("formatter" => "date", "formatoptions" => array("srcformat" => "Y-m-d H:i:s", "newformat" => "m/d/Y")));
$grid->setAutocomplete("CustomerID", false, "SELECT CustomerID, CompanyName FROM customers WHERE CompanyName LIKE ? ORDER BY CompanyName", null, true, true);
$grid->setDatepicker("OrderDate", array("buttonOnly" => false));
$grid->datearray = array('OrderDate');
// Enjoy
$grid->navigator = false;
$onselrow = <<<ONSELROW
function(rowid, selected)
{
\tif(rowid && rowid !== lastSelection) {
\t\t\$("#grid").jqGrid('restoreRow', lastSelection);
\t\t\$("#grid").jqGrid('editRow', rowid, true);
\t\tlastSelection = rowid;
\t}
}
ONSELROW;
$grid->setGridEvent('onSelectRow', $onselrow);

$grid->SelectCommand = 'SELECT id, category, question, answer FROM candidate_faq';
// Set the table to where we add the data
$grid->table = 'candidate_faq';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
// set the ouput format to json
$grid->dataType = 'json';
$grid->setColModel();
// Set the url from where we obtain the data
$grid->setUrl('../grids/candidate_faq.php');
// Change some property of the field(s)
$grid->setColProperty("id", array("editable" => false, "hidden" => true, "label" => "ID"));
$grid->setColProperty("category", array("editable" => true, "width" => 100, "fixed" => true, "label" => "Category", "edittype" => "select"));
$grid->setSelect("category", array("FAQ" => "FAQ", "Training" => "Training", "HR" => "HR"), false, true, true, array("" => "All"));
$grid->setColProperty("question", array("editable" => true, "width" => 800, "fixed" => true, "edittype" => "textarea", "editoptions" => array("rows" => 6, "cols" => 80), "label" => "Question"));
$grid->setAutocomplete("question", null, "select name, name from (select distinct question as name from questions) p where name like ? ORDER BY name", null, true, true);
$grid->setColProperty("answer", array("editable" => true, "hidden" => true, "edittype" => "textarea", "editrules" => array("edithidden" => true, "required" => false), "editoptions" => array("rows" => 6, "cols" => 80), "label" => "Answer"));
$grid->setGridOptions(array("sortable" => true, "width" => 1024, "height" => 250, "caption" => "Candidate FAQ Management", "rownumbers" => true, "rowNum" => 1000, "shrinkToFit" => false, "sortname" => "category", "sortorder" => "asc", "toppager" => true, "rowList" => array(10, 100, 500, 1000, 10000, 20000)));
$grid->showError = true;
$grid->navigator = true;
$grid->setNavOptions('navigator', array("pdf" => true, "excel" => true, "add" => true, "edit" => true, "del" => true, "view" => true, "search" => true));
$grid->setNavOptions('view', array("width" => 750, "dataheight" => 300, "viewCaption" => "Candidate FAQ Management"));
$grid->setNavOptions('add', array("width" => 750, "dataheight" => 300, "closeOnEscape" => true, "closeAfterAdd" => true, "addCaption" => "Add FAQ", "reloadAfterSubmit" => false));
$grid->setNavOptions('edit', array("width" => 750, "dataheight" => 300, "closeOnEscape" => true, "closeAfterEdit" => true, "editCaption" => "Update FAQ", "reloadAfterSubmit" => false));
$grid->callGridMethod('#grid', 'setFrozenColumns');
$grid->callGridMethod('#grid', 'gridResize');
$bindkeys = <<<KEYS
\$("#grid").jqGrid('bindKeys', {"onEnter":function( rowid ) { alert("You enter a row with id:"+rowid)} } );
KEYS;
$grid->setJSCode($bindkeys);
$grid->renderGrid('#grid', '#pager', true, null, null, true, true);

$grid->serialKey = false;
$grid->dataType = 'json';
$grid->setColModel();
$grid->setUrl('../grids/candidate_updated_personal_info.php');
$grid->setColProperty("id", array("editable" => false, "width" => 25, "fixed" => true, "label" => "CandidateId"));
$grid->setColProperty("candidateid", array("editable" => false, "width" => 25, "fixed" => true, "label" => "CandidateId"));
$grid->setColProperty("name", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Name"));
$grid->setColProperty("email", array("editable" => true, "width" => 150, "fixed" => true, "formatter" => "email", "label" => "Email"));
$grid->setColProperty("phone", array("editable" => true, "width" => 90, "fixed" => true, "label" => "Phone"));
$grid->setColProperty("education", array("editable" => true, "width" => 90, "fixed" => true, "label" => "Education"));
$grid->setColProperty("workexperience", array("editable" => true, "width" => 90, "fixed" => true, "label" => "Work Experience"));
$grid->setColProperty("address", array("editable" => true, "width" => 150, "fixed" => true, "label" => "Address"));
$grid->setColProperty("city", array("editable" => true, "width" => 90, "fixed" => true, "label" => "City"));
$grid->setColProperty("state", array("editable" => true, "width" => 90, "fixed" => true, "label" => "State"));
$grid->setColProperty("country", array("editable" => true, "width" => 90, "fixed" => true, "label" => "Country"));
$grid->setAutocomplete("country", null, "select name, name from (SELECT distinct short_name as name FROM country) p where name like ? ORDER BY name", null, true, true);
$grid->setColProperty("zip", array("editable" => true, "width" => 90, "fixed" => true, "label" => "Zip"));
$grid->setColProperty("approved", array("editable" => true, "width" => 90, "fixed" => true, "label" => "Approved"));
$grid->setSelect("approved", $yesno, false, true, true, array("" => "All"));
$grid->setGridOptions(array("sortable" => true, "width" => 1024, "height" => 250, "caption" => "Candidate Updated Personal Info ", "rownumbers" => true, "rowNum" => 30, "sortname" => "id", "sortorder" => "desc", "toppager" => true, "rowList" => array(10, 20, 30, 50, 100)));
$grid->showError = true;
$grid->navigator = true;
$grid->setNavOptions('navigator', array("pdf" => true, "excel" => true, "add" => true, "edit" => true, "del" => false, "view" => true, "search" => true));
$grid->setNavOptions('view', array("width" => 750, "dataheight" => 500, "viewCaption" => "Candidate Management"));
$grid->setNavOptions('add', array("width" => 750, "dataheight" => 500, "closeOnEscape" => true, "closeAfterAdd" => true, "addCaption" => "Add Candidate", "reloadAfterSubmit" => true));
$grid->setNavOptions('edit', array("width" => 750, "dataheight" => 500, "closeOnEscape" => true, "closeAfterEdit" => true, "editCaption" => "Update Candidate", "reloadAfterSubmit" => true));
$grid->callGridMethod('#grid', 'setFrozenColumns');
$grid->callGridMethod('#grid', 'gridResize');
$bindkeys = <<<KEYS

\$("#grid").jqGrid('bindKeys', {"onEnter":function( rowid ) { alert("You enter a row with id:"+rowid)} } );