$grid->setUserDate("Y-m-d");
// Let the grid create the model from SQL query
$grid->setColModel();
// Set the url from where we obtain the data
$grid->setUrl('../grids/recruiting.php');
// Change some property of the field(s)
$grid->setColProperty("id", array("editable" => false, "width" => 25, "fixed" => true, "label" => "ID"));
$grid->setColProperty("name", array("editable" => 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('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("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("email", array("editable" => true, "width" => 200, "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("priority", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Priority", "edittype" => "select"));
$grid->setSelect("priority", array("P3" => "P3", "P1" => "P1", "P2" => "P2"), false, true, true, array("" => "All"));
$grid->setColProperty("status", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Status", "edittype" => "select"));
$grid->setSelect("status", array("Open" => "Open", "In-Progress" => "In-Progress", "Future" => "Future", "Rejected" => "Rejected", "Closed" => "Closed"), false, true, true, array("" => "All"));
$grid->setColProperty("source", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Source", "edittype" => "select"));
$grid->setSelect("source", array("Dice" => "Dice", "DesiOPT" => "DesiOPT"), false, true, true, array("" => "All"));
$grid->setColProperty("relocation", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Relocation", "edittype" => "select"));
$grid->setSelect("relocation", $yesno, false, true, true, array("" => "All"));
$grid->setColProperty("preferredlocation", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Pref. Location"));
$grid->setColProperty("experience", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Experience"));
$grid->setColProperty("expectedsalary", array("editable" => true, "width" => 90, "fixed" => true, "label" => "Expected Salary"));
$grid->setColProperty("resumeurl", array("editable" => true, "frozen" => true, "width" => 200, "editoptions" => array("size" => 75, "maxlength" => 200), "formatter" => "link", "fixed" => true, "editrules" => array("url" => true, "required" => false), "label" => "Resume Url"));
$grid->setColProperty("address", array("editable" => true, "width" => 150, "fixed" => true, "label" => "Address"));
$grid->setColProperty("secondaryemail", array("editable" => true, "width" => 150, "fixed" => true, "formatter" => "email", "editrules" => array("email" => true, "required" => false), "label" => "Sec Email"));
$grid->setColProperty("calls", array("editable" => true, "width" => 70, "fixed" => true, "editrules" => array("minValue" => 0, "maxValue" => 10), "label" => "Calls"));
$grid->setColProperty("companyname", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Company Name"));
$grid->setColProperty("companyemail", array("editable" => true, "width" => 150, "fixed" => true, "formatter" => "email", "editrules" => array("email" => true, "required" => false), "label" => "Company Email"));
$conn = new PDO(DB_DSN, DB_USER, DB_PASSWORD);
// Tell the db that we use utf-8
$conn->query("SET NAMES utf8");
$grid = new jqGridRender($conn);
$grid->SelectCommand = 'SELECT id, employeeid, recruiterid, saledate, status, DATE_FORMAT(lastmoddatetime, "%D %M %Y %h:%i %p %a") as last, notes FROM vendorsales';
$grid->table = 'vendorsales';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
$grid->dataType = 'json';
$grid->datearray = array('saledate');
$grid->setUserDate("Y-m-d");
$grid->setColModel();
$grid->setUrl('sale.php');
$grid->setColProperty("id", array("editable" => false, "width" => 25, "hidden" => true, "fixed" => true, "label" => "ID"));
$grid->setColProperty("recruiterid", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Recruiter", "edittype" => "select"));
$grid->setSelect("recruiterid", "select '' as id, '' as name from dual union SELECT id, email as name FROM recruiter order by name");
$grid->setColProperty("employeeid", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Employee", "edittype" => "select"));
$grid->setSelect("employeeid", "select '' as id, '' as name from dual union SELECT distinct id, name FROM employee where status = '0Active' order by name");
$grid->setColProperty("saledate", array("formatter" => "date", "width" => 70, "fixed" => true, "formatoptions" => array("srcformat" => "Y-m-d", "newformat" => "Y-m-d"), "editable" => true, "label" => "Sale 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("status", array("editable" => true, "width" => 50, "fixed" => true, "label" => "Status", "edittype" => "select"));
$grid->setSelect("status", array("I" => "Initiated", "S" => "Success", "F" => "FollowUp", "R" => "Rejected"), false, true, true, array("" => "All"));
$grid->setColProperty("last", array("editable" => false, "width" => 200, "fixed" => true, "label" => "Last Updated"));
$grid->setColProperty("notes", array("editable" => true, "width" => 400, "fixed" => true, "hidden" => true, "edittype" => "textarea", "editrules" => array("edithidden" => true, "required" => false), "editoptions" => array("rows" => 6, "cols" => 60), "label" => "Notes"));
$grid->setGridOptions(array("sortable" => true, "width" => 1024, "height" => 250, "caption" => "Sales Management", "rownumbers" => true, "rowNum" => 100, "sortname" => "lastmoddatetime", "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" => 300, "viewCaption" => "Sales Management"));
$grid->setNavOptions('add', array("width" => 750, "dataheight" => 300, "closeOnEscape" => true, "closeAfterAdd" => true, "addCaption" => "Add Sale", "reloadAfterSubmit" => false));
$grid->setNavOptions('edit', array("width" => 750, "dataheight" => 300, "closeOnEscape" => true, "closeAfterEdit" => true, "editCaption" => "Update Sale", "reloadAfterSubmit" => false));
$grid->callGridMethod('#grid', 'setFrozenColumns');
<?php
require_once $_SERVER["DOCUMENT_ROOT"] . "/ip-includes/gridincludes.php";
$grid = new jqGridRender($DB);
$grid->SelectCommand = 'select id, site, status, crawl, crawldate from rec_crawler_site';
$grid->table = 'rec_crawler_site';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
$grid->dataType = 'json';
$grid->setUserDate("Y-m-d");
$grid->setColModel();
$grid->setUrl('../grids/rec_crawler.php');
$grid->setColProperty("id", array("editable" => false, "frozen" => true, "hidden" => true, "width" => 40, "fixed" => true, "label" => "ID"));
$grid->setColProperty("site", array("editable" => true, "frozen" => true, "width" => 600, "editoptions" => array("size" => 75, "maxlength" => 400), "formatter" => "link", "formatoptions" => array("target" => "_blank"), "fixed" => true, "editrules" => array("url" => true, "required" => false), "label" => "Site"));
$grid->setColProperty("status", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Status", "edittype" => "select"));
$grid->setSelect("status", array("A" => "A", "N" => "N"), false, true, true, array("" => "All"));
$grid->setColProperty("crawl", array("editable" => true, "width" => 120, "fixed" => true, "label" => "Crawl Domain", "edittype" => "select"));
$grid->setSelect("crawl", $yesno, false, true, true, array("" => "All"));
$grid->setColProperty("crawldate", array("formatter" => "date", "width" => 70, "fixed" => true, "formatoptions" => array("srcformat" => "Y-m-d", "newformat" => "Y-m-d"), "editable" => true, "label" => "Crawl 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->setGridOptions(array("sortable" => true, "width" => 1024, "height" => 250, "caption" => "Crawler Site Management", "rownumbers" => true, "rowNum" => 100, "sortname" => "id", "sortorder" => "desc", "toppager" => true, "rowList" => array(10, 20, 30, 50, 100, 500)));
$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" => 250, "viewCaption" => "Crawler Site Management"));
$grid->setNavOptions('add', array("width" => 750, "dataheight" => 250, "closeOnEscape" => true, "closeAfterAdd" => true, "addCaption" => "Add Crawler", "bSubmit" => "Add Crawler Site", "reloadAfterSubmit" => false));
$grid->setNavOptions('edit', array("width" => 750, "dataheight" => 250, "closeOnEscape" => true, "closeAfterEdit" => true, "editCaption" => "Update Crawler", "bSubmit" => "Update Crawler Site", "reloadAfterSubmit" => false));
//$grid->toolbarfilter = 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)} } );
$grid = new jqGridRender($DB);
$grid->SelectCommand = 'SELECT id, name, email, phone, personalemail, personalphone, mgrid, dob, address, city, state, country, zip, skypeid FROM employee where status = "0Active"';
$grid->table = 'employee';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
$grid->dataType = 'json';
$grid->setColModel();
$grid->setUrl('../grids/remployee.php');
$grid->setColProperty("id", array("editable" => false, "width" => 25, "fixed" => true, "label" => "ID"));
$grid->setColProperty("name", array("editable" => false, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Name"));
$grid->setColProperty("email", array("editable" => false, "width" => 150, "fixed" => true, "formatter" => "email", "editrules" => array("email" => true, "required" => true), "label" => "Email"));
$grid->setColProperty("phone", array("editable" => false, "width" => 90, "fixed" => true, "label" => "Phone"));
$grid->setColProperty("personalemail", array("editable" => false, "width" => 150, "fixed" => true, "formatter" => "email", "editrules" => array("email" => true, "required" => false), "label" => "Personal Email"));
$grid->setColProperty("personalphone", array("editable" => false, "width" => 90, "fixed" => true, "label" => "Personal Phone"));
$grid->setColProperty("mgrid", array("editable" => false, "frozen" => true, "width" => 100, "fixed" => true, "label" => "Manager", "edittype" => "select"));
$grid->setSelect("mgrid", "select '' as id, '' as name from dual union SELECT distinct id, name FROM employee where status = '0Active' order by name");
$grid->setColProperty("dob", array("formatter" => "date", "width" => 70, "fixed" => true, "formatoptions" => array("srcformat" => "Y-m-d", "newformat" => "Y-m-d"), "editable" => false, "label" => "Birth 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("address", array("editable" => false, "width" => 150, "fixed" => true, "label" => "Address"));
$grid->setColProperty("city", array("editable" => false, "width" => 90, "fixed" => true, "label" => "City"));
$grid->setColProperty("state", array("editable" => false, "width" => 90, "fixed" => true, "label" => "State"));
$grid->setColProperty("country", array("editable" => false, "width" => 90, "fixed" => true, "label" => "Country"));
$grid->setColProperty("zip", array("editable" => false, "width" => 90, "fixed" => true, "label" => "Zip"));
$grid->setColProperty("skypeid", array("editable" => false, "width" => 90, "fixed" => true, "label" => "Skype"));
$grid->setGridOptions(array("sortable" => true, "width" => 1024, "height" => 400, "caption" => "Employee List", "rownumbers" => true, "rowNum" => 100, "sortname" => "type asc, name", "sortorder" => "asc", "toppager" => true, "rowList" => array(10, 20, 30, 50, 100)));
$grid->showError = true;
$grid->navigator = true;
$grid->setNavOptions('navigator', array("pdf" => false, "excel" => true, "add" => false, "edit" => false, "del" => false, "view" => true, "search" => true));
$grid->setNavOptions('view', array("width" => 750, "dataheight" => 500, "viewCaption" => "Employee List"));
$grid->callGridMethod('#grid', 'setFrozenColumns');
$grid->callGridMethod('#grid', 'gridResize');
$bindkeys = <<<KEYS
$grid->table = 'candidate';
//$grid->setPrimaryKeyId('candidateid');
$grid->serialKey = false;
// set the ouput format to json
$grid->dataType = 'json';
//$grid->datearray = array('enrolleddate','wpexpirationdate');
$grid->setUserDate("Y-m-d");
// Let the grid create the model from SQL query
$grid->setColModel();
$grid->setUrl('../grids/rmcandidate.php');
$grid->setColProperty("candidateid", array("editable" => false, "frozen" => true, "width" => 25, "fixed" => true, "label" => "ID"));
$grid->setColProperty("name", array("editable" => false, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Name"));
$grid->setColProperty("email", array("editable" => false, "width" => 150, "fixed" => true, "formatter" => "email", "editrules" => array("email" => true, "required" => true), "label" => "Email"));
$grid->setColProperty("phone", array("editable" => false, "width" => 90, "fixed" => true, "label" => "Phone"));
$grid->setColProperty("status", array("editable" => false, "width" => 70, "fixed" => true, "label" => "Status"));
$grid->setSelect("status", $candidatestatus, false, true, true, array("" => "All"));
$grid->setColProperty("workstatus", array("editable" => false, "width" => 70, "fixed" => true, "label" => "US Status"));
$grid->setSelect("workstatus", $workauthtype, false, true, true, array("" => "All"));
$grid->setColProperty("education", array("editable" => false, "width" => 90, "fixed" => true, "label" => "Education"));
$grid->setColProperty("workexperience", array("editable" => false, "width" => 90, "fixed" => true, "label" => "Work Experience"));
$grid->setColProperty("ssn", array("editable" => false, "width" => 90, "fixed" => true, "label" => "SSN"));
$grid->setColProperty("secondaryemail", array("editable" => false, "width" => 150, "fixed" => true, "formatter" => "email", "editrules" => array("email" => true, "required" => false), "label" => "Secondary Email"));
$grid->setColProperty("secondaryphone", array("editable" => false, "width" => 90, "fixed" => true, "label" => "Secondary Phone"));
$grid->setColProperty("portalid", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Portal ID", "edittype" => "select"));
$grid->setSelect("portalid", "select '' as id, '' as name from dual union SELECT distinct id, concat(fullname, '-', uname) as name FROM authuser order by name");
$grid->setColProperty("workpermiturl", array("editable" => false, "frozen" => true, "width" => 200, "editoptions" => array("size" => 75, "maxlength" => 400), "formatter" => "link", "fixed" => true, "editrules" => array("url" => true, "required" => false), "label" => "Work Permit Url"));
$grid->setColProperty("batchname", array("editable" => false, "width" => 90, "fixed" => true, "label" => "Batch Name"));
$grid->setSelect("batchname", "select distinct batchname as id, batchname as name from batch", false, true, true);
// Set alternate background using altRows property
$grid->setGridOptions(array("sortable" => true, "width" => 1024, "height" => 250, "caption" => "Candidates List", "rownumbers" => true, "rowNum" => 500, "sortname" => "name", "sortorder" => "asc", "toppager" => true, "rowList" => array(500, 1000, 5000), "grouping" => true, "groupingView" => array("groupField" => array('batchname'), "groupColumnShow" => array(true), "groupOrder" => array('desc'), "groupText" => array('<b>{0}</b>'), "groupDataSorted" => true)));
$grid->showError = true;
require_once $_SERVER["DOCUMENT_ROOT"] . "/ip-includes/gridincludes.php";
$employeeid = $_GET['employeeid'];
$grid = new jqGridRender($DB);
$grid->SelectCommand = 'SELECT id, candidateid, candidateid as cid, mmid, type, status, interviewdate, interviewhour, interviewminute, interviewdivision, clientname, clientlocation, vendor1, vendor1email, vendor2, vendor2email, client1email, client2email, client3email, vendor3email, reference, interviewers, interviewersphone, result, performance, portal, reclink, questions, questionslink, notes FROM interview where mmid = "' . $employeeid . '" or mmid in (select id from employee where mgrid = "' . $employeeid . '")';
$grid->table = 'interview';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
$grid->dataType = 'json';
$grid->datearray = array('interviewdate');
$grid->setUserDate("Y-m-d");
$grid->setColModel();
$grid->setUrl('../grids/rinterview.php?employeeid=' . $employeeid);
$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("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->SelectCommand = 'SELECT id, name, email, phone, trainingmessage, companymessage, improvemessage, refer, usefeedback FROM feedback';
$grid->table = 'feedback';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
$grid->dataType = 'json';
$grid->setColModel();
$grid->setUrl('../grids/feedback.php');
$grid->setColProperty("id", array("editable" => false, "width" => 25, "fixed" => true, "label" => "ID"));
$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", "editrules" => array("email" => true, "required" => true), "label" => "Email"));
$grid->setColProperty("phone", array("editable" => true, "width" => 90, "fixed" => true, "label" => "Phone"));
$grid->setColProperty("trainingmessage", array("editable" => true, "hidden" => true, "edittype" => "textarea", "editrules" => array("edithidden" => true, "required" => false), "editoptions" => array("rows" => 6, "cols" => 80), "label" => "Training Message"));
$grid->setColProperty("companymessage", array("editable" => true, "hidden" => true, "edittype" => "textarea", "editrules" => array("edithidden" => true, "required" => false), "editoptions" => array("rows" => 6, "cols" => 80), "label" => "Company Message"));
$grid->setColProperty("improvemessage", array("editable" => true, "hidden" => true, "edittype" => "textarea", "editrules" => array("edithidden" => true, "required" => false), "editoptions" => array("rows" => 6, "cols" => 80), "label" => "Improve Message"));
$grid->setColProperty("refer", array("editable" => true, "label" => "Refer", "width" => 50, "fixed" => true, "edittype" => "select"));
$grid->setSelect("refer", $yesno, false, true, true, array("" => "All"));
$grid->setColProperty("usefeedback", array("editable" => true, "label" => "Use Feedback", "width" => 50, "fixed" => true, "edittype" => "select"));
$grid->setSelect("usefeedback", $yesno, false, true, true, array("" => "All"));
$grid->setGridOptions(array("sortable" => true, "width" => 1024, "height" => 250, "caption" => "Feedback Management", "rownumbers" => true, "rowNum" => 100, "footerrow" => true, "userDataOnFooter" => true, "shrinkToFit" => false, "sortname" => "id", "sortorder" => "desc", "toppager" => true, "rowList" => array(10, 50, 100, 500, 1000)));
$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" => "Feedback Management"));
$grid->setNavOptions('add', array("width" => 750, "dataheight" => 500, "closeOnEscape" => true, "closeAfterAdd" => true, "addCaption" => "Add Feedback", "reloadAfterSubmit" => false));
$grid->setNavOptions('edit', array("width" => 750, "dataheight" => 500, "closeOnEscape" => true, "closeAfterEdit" => true, "editCaption" => "Update Feedback", "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);
<?php
require_once $_SERVER["DOCUMENT_ROOT"] . "/ip-includes/gridincludes.php";
$grid = new jqGridRender($DB);
$grid->SelectCommand = 'SELECT id, candidateid, loandate, amount, type, status, description, notes FROM loan';
$grid->table = 'loan';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
$grid->dataType = 'json';
$grid->datearray = array('loandate');
$grid->setUserDate("Y-m-d");
$grid->setColModel();
$grid->setUrl('../grids/loan.php');
$grid->setColProperty("id", array("editable" => false, "width" => 25, "fixed" => true, "label" => "ID"));
$grid->setColProperty("candidateid", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Candidate", "edittype" => "select"));
$grid->setSelect("candidateid", "select '' as id, '' as name from dual union SELECT distinct candidateid as id, name as name FROM candidate order by name");
$grid->setColProperty("loandate", array("formatter" => "date", "width" => 80, "fixed" => true, "formatoptions" => array("srcformat" => "Y-m-d", "newformat" => "Y-m-d"), "editable" => true, "label" => "Loan 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("amount", array("editable" => true, "width" => 90, "formatter" => "currency", "formatoptions" => array("decimalPlaces" => 2, "thousandsSeparator" => ",", "prefix" => "\$"), "sorttype" => "currency", "fixed" => true, "label" => "Amount"));
$grid->setColProperty("status", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Status", "edittype" => "select"));
$grid->setSelect("status", $loanstatus, false, true, true, array("" => "All"));
$grid->setColProperty("type", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Type", "edittype" => "select"));
$grid->setSelect("type", $loantype, false, true, true, array("" => "All"));
$grid->setColProperty("description", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Description"));
$grid->setColProperty("notes", array("editable" => true, "width" => 400, "fixed" => true, "edittype" => "textarea", "editoptions" => array("rows" => 6, "cols" => 60), "label" => "Notes"));
$summaryrows = array("amount" => array("amount" => "SUM"));
$grid->setGridOptions(array("sortable" => true, "width" => 1024, "height" => 250, "caption" => "Loan Management", "rownumbers" => true, "rowNum" => 100, "footerrow" => true, "userDataOnFooter" => true, "shrinkToFit" => false, "sortname" => "status asc, type", "sortorder" => "desc", "toppager" => true, "rowList" => array(10, 20, 30, 50, 100, 500), "grouping" => true, "groupingView" => array("groupCollapse" => true, "groupField" => array('candidateid'), "groupColumnShow" => array(true), "groupOrder" => array('desc'), "groupText" => array('<b>{0}</b>'), "groupDataSorted" => true)));
$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" => 300, "viewCaption" => "Loan Management"));
$grid->setNavOptions('add', array("width" => 750, "dataheight" => 300, "closeOnEscape" => true, "closeAfterAdd" => true, "addCaption" => "Add Loan", "reloadAfterSubmit" => false));
$grid->SelectCommand = 'SELECT id, candidateid, mmid,recruiterid,vendorid,masteragreementid,otheragreementsids,vendor2id,vendor3id,clientid,startdate,enddate,status,paperwork,insurance,wrklocation, wrkdesignation,wrkemail,wrkphone,mgrname,mgremail,mgrphone,hiringmgrname,hiringmgremail,hiringmgrphone,reference,ipemailclear,feedbackid,projectdocs,notes FROM placement p';
$grid->table = 'placement';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
// set the ouput format to json
$grid->dataType = 'json';
$grid->datearray = array('startdate', 'enddate');
$grid->setUserDate("Y-m-d");
// Let the grid create the model from SQL query
$grid->setColModel();
// Set the url from where we obtain the data
$grid->setUrl('../grids/placement.php');
// Change some property of the field(s)
$grid->setColProperty("id", array("editable" => false, "width" => 25, "fixed" => true, "label" => "ID"));
$grid->setColProperty("candidateid", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Candidate Name", "edittype" => "select"));
$grid->setSelect("candidateid", "SELECT distinct candidateid as id, name as name FROM candidate 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 order by name");
$grid->setColProperty("recruiterid", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Recruiter", "edittype" => "select"));
$grid->setSelect("recruiterid", "select '' as id, '' as name from dual union SELECT distinct r.id as id, concat(r.name, '-', v.companyname) as name FROM recruiter r, vendor v where r.vendorid = v.id order by name");
$grid->setColProperty("vendorid", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Vendor1", "edittype" => "select"));
$grid->setSelect("vendorid", "select '' as id, '' as name from dual union SELECT distinct id as id, companyname as name FROM vendor order by name");
$grid->setColProperty("masteragreementid", array("editable" => true, "width" => 25, "fixed" => true, "label" => "MSA ID"));
$grid->setColProperty("otheragreementsids", array("editable" => true, "width" => 50, "fixed" => true, "label" => "Other AgrID"));
$grid->setColProperty("vendor2id", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Vendor2", "edittype" => "select"));
$grid->setSelect("vendor2id", "select '' as id, '' as name from dual union SELECT distinct id as id, companyname as name FROM vendor order by name");
$grid->setColProperty("vendor3id", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Vendor3", "edittype" => "select"));
$grid->setSelect("vendor3id", "select '' as id, '' as name from dual union SELECT distinct id as id, companyname as name FROM vendor order by name");
$grid->setColProperty("clientid", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Client", "edittype" => "select"));
$grid->setSelect("clientid", "select '' as id, '' as name from dual union SELECT distinct id as id, companyname as name FROM client order by name");
$grid->setColProperty("startdate", array("formatter" => "date", "width" => 80, "fixed" => true, "formatoptions" => array("srcformat" => "Y-m-d", "newformat" => "Y-m-d"), "editable" => true, "label" => "Start 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);}")));
// set the ouput format to json
$grid->dataType = 'json';
$grid->setUserDate("Y-m-d");
// Let the grid create the model from SQL query
$grid->setColModel();
// Set the url from where we obtain the data
$grid->setUrl('../grids/clr_email.php');
// Change some property of the field(s)
$grid->setColProperty("id", array("editable" => false, "frozen" => true, "width" => 40, "fixed" => true, "label" => "ID"));
$grid->setColProperty("email", array("editable" => true, "width" => 200, "editoptions" => array("size" => 75, "maxlength" => 200), "fixed" => true, "formatter" => "email", "editrules" => array("email" => true, "required" => true), "label" => "Email"));
$grid->setColProperty("password", array("editable" => true, "width" => 90, "editoptions" => array("size" => 75, "maxlength" => 200), "fixed" => true, "label" => "Password"));
$grid->setColProperty("type", array("editable" => true, "width" => 40, "fixed" => true, "label" => "Type"));
$grid->setColProperty("masteremail", array("editable" => true, "width" => 200, "editoptions" => array("size" => 75, "maxlength" => 200), "fixed" => true, "formatter" => "email", "editrules" => array("email" => true, "required" => true), "label" => "Master Email"));
$grid->setColProperty("forwardingemail", array("editable" => true, "width" => 200, "editoptions" => array("size" => 75, "maxlength" => 200), "fixed" => true, "formatter" => "email", "editrules" => array("email" => true, "required" => true), "label" => "Fwd Email"));
$grid->setColProperty("status", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Status", "edittype" => "select"));
$grid->setSelect("status", $yesno, false, true, true, array("" => "All"));
$grid->setColProperty("lastuseddate", array("formatter" => "date", "width" => 70, "fixed" => true, "formatoptions" => array("srcformat" => "Y-m-d", "newformat" => "Y-m-d"), "editable" => false, "label" => "Last Used Date", "editoptions" => array("dataInit" => "js:function(elm){setTimeout(function(){\n jQuery(elm).datepicker({dateFormat:'yy-mm-dd'});\n jQuery('.ui-datepicker').css({'font-size':'75%'});\n },200);}"), "searchoptions" => array("dataInit" => "js:function(elm){setTimeout(function(){\n jQuery(elm).datepicker({dateFormat:'yy-mm-dd'});\n jQuery('.ui-datepicker').css({'font-size':'75%'});\n },200);}")));
$grid->setGridOptions(array("sortable" => true, "width" => 1024, "height" => 500, "caption" => "Crawler Email Management", "rownumbers" => true, "rowNum" => 100, "sortname" => "lastuseddate", "sortorder" => "desc", "toppager" => true, "rowList" => array(10, 20, 30, 50, 100, 500)));
$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" => 300, "viewCaption" => "Crawler Email Management"));
$grid->setNavOptions('add', array("width" => 750, "dataheight" => 300, "closeOnEscape" => true, "closeAfterAdd" => true, "addCaption" => "Add Crawler", "bSubmit" => "Add Crawler Email", "reloadAfterSubmit" => false));
$grid->setNavOptions('edit', array("width" => 750, "dataheight" => 300, "closeOnEscape" => true, "closeAfterEdit" => true, "editCaption" => "Update Crawler", "bSubmit" => "Update Crawler Email", "reloadAfterSubmit" => false));
//$grid->toolbarfilter = 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)} } );
KEYS;
$grid->setJSCode($bindkeys);
<?php
require_once $_SERVER["DOCUMENT_ROOT"] . "/ip-includes/gridincludes.php";
$grid = new jqGridRender($DB);
$grid->SelectCommand = 'select employeeid, machinename, tvid, tvpassword, notes from empmachine';
$grid->table = 'empmachine';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
$grid->dataType = 'json';
$grid->setUserDate("Y-m-d");
$grid->setColModel();
$grid->setUrl('../grids/empmachine.php');
$grid->setColProperty("employeeid", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Employee", "edittype" => "select"));
$grid->setSelect("employeeid", "select 0 as id, 'None' as name from dual union select id, name from employee where status = '0Active'");
$grid->setColProperty("machinename", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Machine Name"));
$grid->setColProperty("tvid", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "TV ID"));
$grid->setColProperty("tvpassword", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "TV Password"));
$grid->setColProperty("notes", array("editable" => true, "width" => 400, "fixed" => true, "edittype" => "textarea", "editoptions" => array("rows" => 6, "cols" => 80), "label" => "Notes"));
$grid->setGridOptions(array("sortable" => true, "width" => 1024, "height" => 250, "caption" => "Employee Machine Management", "rownumbers" => true, "rowNum" => 30, "sortname" => "machinename", "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" => true, "view" => true, "search" => true));
$grid->setNavOptions('view', array("width" => 750, "dataheight" => 500, "viewCaption" => "Employee Machine Management"));
$grid->setNavOptions('add', array("width" => 750, "dataheight" => 500, "closeOnEscape" => true, "closeAfterAdd" => true, "addCaption" => "Add Employee Machine", "bSubmit" => "Add Machine", "reloadAfterSubmit" => false));
$grid->setNavOptions('edit', array("width" => 750, "dataheight" => 500, "closeOnEscape" => true, "closeAfterEdit" => true, "editCaption" => "Update Employee Machine", "bSubmit" => "Update Machine", "reloadAfterSubmit" => false));
//$grid->toolbarfilter = 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)} } );
KEYS;
<?php
require_once $_SERVER["DOCUMENT_ROOT"] . "/ip-includes/gridincludes.php";
$grid = new jqGridRender($DB);
$grid->SelectCommand = 'SELECT id,employeeid,description,sessiondate,link,videoid,status,category FROM emp_recording';
$grid->table = 'emp_recording';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
$grid->dataType = 'json';
$grid->datearray = array('sessiondate');
$grid->setUserDate("Y-m-d");
$grid->setColModel();
$grid->setUrl('../grids/emp_recording.php');
$grid->setColProperty("id", array("editable" => false, "width" => 25, "hidden" => true, "fixed" => true, "label" => "ID"));
$grid->setColProperty("employeeid", array("editable" => true, "frozen" => true, "width" => 100, "fixed" => true, "label" => "Employee", "edittype" => "select"));
$grid->setSelect("employeeid", "SELECT distinct id, name FROM employee order by name");
$grid->setColProperty("description", array("editable" => true, "frozen" => true, "width" => 250, "editoptions" => array("size" => 75, "maxlength" => 250), "fixed" => true, "label" => "Description"));
$grid->setColProperty("sessiondate", array("formatter" => "date", "width" => 80, "fixed" => true, "formatoptions" => array("srcformat" => "Y-m-d", "newformat" => "Y-m-d"), "editable" => true, "label" => "Session 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("link", array("editable" => true, "frozen" => true, "width" => 300, "editoptions" => array("size" => 75, "maxlength" => 300), "formatter" => "link", "fixed" => true, "editrules" => array("url" => true, "required" => false), "label" => "Url"));
$grid->setColProperty("videoid", array("editable" => true, "width" => 90, "fixed" => true, "label" => "Video ID"));
$grid->setColProperty("status", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Status", "edittype" => "select"));
$grid->setSelect("status", array("active" => "active", "inactive" => "inactive"), false, true, true, array("" => "All"));
$grid->setColProperty("category", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Subject", "edittype" => "select"));
$grid->setSelect("category", $teams, false, true, true, array("" => "All"));
$grid->setGridOptions(array("sortable" => true, "width" => 1024, "height" => 500, "caption" => "Employee Recording Management", "rownumbers" => true, "rowNum" => 100, "sortname" => "sessiondate desc, description", "sortorder" => "desc", "toppager" => true, "rowList" => array(10, 20, 30, 50, 100, 500)));
$grid->showError = true;
$grid->navigator = true;
$grid->setNavOptions('navigator', array("pdf" => false, "excel" => false, "add" => true, "edit" => true, "del" => false, "view" => true, "search" => true));
$grid->setNavOptions('add', array("width" => 750, "dataheight" => 250, "closeOnEscape" => true, "closeAfterAdd" => true, "addCaption" => "Add Recording", "reloadAfterSubmit" => false));
$grid->setNavOptions('view', array("width" => 750, "dataheight" => 250, "viewCaption" => "Recording Management"));
$grid->setNavOptions('edit', array("width" => 750, "dataheight" => 250, "closeOnEscape" => true, "closeAfterEdit" => true, "editCaption" => "Update Recording", "reloadAfterSubmit" => false));
// set the ouput format to json
$grid->dataType = 'json';
$grid->datearray = array('leaddate');
$grid->setUserDate("Y-m-d");
// Let the grid create the model from SQL query
$grid->setColModel();
// Set the url from where we obtain the data
$grid->setUrl('../grids/emp_lead.php');
// Change some property of the field(s)
$grid->setColProperty("id", array("editable" => false, "hidden" => true, "label" => "ID"));
$grid->setColProperty("name", array("editable" => true, "frozen" => true, "width" => 150, "editoptions" => array("size" => 75, "maxlength" => 200), "fixed" => true, "label" => "Name"));
$grid->setColProperty("leaddate", array("formatter" => "date", "width" => 100, "fixed" => true, "formatoptions" => array("srcformat" => "Y-m-d", "newformat" => "Y-m-d"), "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("phone", array("editable" => true, "width" => 150, "editoptions" => array("size" => 75, "maxlength" => 200), "fixed" => true, "label" => "Phone"));
$grid->setColProperty("email", array("editable" => true, "width" => 150, "editoptions" => array("size" => 75, "maxlength" => 200), "fixed" => true, "formatter" => "email", "editrules" => array("email" => true, "required" => true), "label" => "Email"));
$grid->setColProperty("reference", array("editable" => true, "frozen" => true, "width" => 100, "fixed" => true, "label" => "Reference", "edittype" => "select"));
$grid->setSelect("reference", "select 0 as id, ' None' as name from dual union SELECT distinct id, name FROM employee order by name");
$grid->setColProperty("notes", array("editable" => true, "width" => 400, "fixed" => true, "edittype" => "textarea", "editoptions" => array("rows" => 6, "cols" => 80), "label" => "Notes"));
// Set alternate background using altRows property
$grid->setGridOptions(array("sortable" => true, "width" => 1024, "height" => 250, "caption" => "Employee Leads Management", "rownumbers" => true, "rowNum" => 100, "shrinkToFit" => false, "sortname" => "leaddate", "sortorder" => "desc", "toppager" => true, "rowList" => array(10, 20, 30, 50, 100, 500)));
$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" => 250, "viewCaption" => "Employee Leads Management"));
$grid->setNavOptions('add', array("width" => 750, "dataheight" => 250, "closeOnEscape" => true, "closeAfterAdd" => true, "addCaption" => "Add Lead", "reloadAfterSubmit" => false));
$grid->setNavOptions('edit', array("width" => 750, "dataheight" => 250, "closeOnEscape" => true, "closeAfterEdit" => true, "editCaption" => "Update Lead", "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->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->setSelect("workstatus", $workauthtype, false, true, true, array("" => "All"));
$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("ssn", array("editable" => true, "width" => 90, "fixed" => true, "label" => "SSN"));
$grid->setColProperty("dob", array("formatter" => "date", "width" => 70, "fixed" => true, "formatoptions" => array("srcformat" => "Y-m-d", "newformat" => "Y-m-d"), "editable" => true, "label" => "Birth 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("portalid", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Portal ID", "edittype" => "select"));
$grid->setSelect("portalid", "select '' as id, '' as name from dual union SELECT distinct id, concat(fullname, '-', uname) as name FROM authuser order by name");
require_once ABSPATH . "php/jqGrid.php";
require_once ABSPATH . "php/jqGridPdo.php";
$conn = new PDO(DB_DSN, DB_USER, DB_PASSWORD);
$conn->query("SET NAMES utf8");
$grid = new jqGridRender($conn);
$grid->SelectCommand = 'select id, pageid, headerid, label, sortorder from uc_header_pages t';
$grid->table = 'uc_header_pages';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
$grid->dataType = 'json';
$grid->setColModel();
$grid->setUrl('admin_headerpages.php');
$grid->setColProperty("id", array("editable" => false, "width" => 25, "fixed" => true, "label" => "ID"));
$grid->setColProperty("label", array("editable" => true, "frozen" => true, "width" => 100, "editoptions" => array("size" => 75, "maxlength" => 200), "fixed" => true, "label" => "Label"));
$grid->setColProperty("headerid", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Header", "edittype" => "select"));
$grid->setSelect("headerid", "select id, TRIM(LEADING '->' FROM label) from (SELECT distinct id, concat(ifnull((select concat(ifnull((select concat(ifnull((select label from uc_header uh3 where id = uh2.parentid), ''), '->', label) as label from uc_header uh2 where id = uh1.parentid), ''), '->', label)as label from uc_header uh1 where id = uh.parentid), ''), '->', label) as label FROM uc_header uh order by label) t");
$grid->setColProperty("pageid", array("editable" => true, "frozen" => true, "width" => 250, "fixed" => true, "label" => "Page", "edittype" => "select"));
$grid->setSelect("pageid", "select id, concat(page, ' - ', IFNULL(label, '')) as label1 from uc_pages up order by label1");
$grid->setColProperty("sortorder", array("editable" => true, "width" => 90, "fixed" => true, "label" => "SortOrder"));
$grid->setGridOptions(array("sortable" => true, "width" => 1024, "height" => 250, "caption" => "Header Pages Management", "rownumbers" => true, "rowNum" => 100, "sortname" => "headerid asc, sortorder", "sortorder" => "asc", "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" => true, "view" => true, "search" => true));
$grid->setNavOptions('view', array("width" => 750, "dataheight" => 250, "viewCaption" => "Header Pages Management"));
$grid->setNavOptions('add', array("width" => 750, "dataheight" => 250, "closeOnEscape" => true, "closeAfterAdd" => true, "addCaption" => "Add Header Page", "reloadAfterSubmit" => false));
$grid->setNavOptions('edit', array("width" => 750, "dataheight" => 250, "closeOnEscape" => true, "closeAfterEdit" => true, "editCaption" => "Update Header Page", "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;
// Create the jqGrid instance
$grid = new jqGridRender($DB);
// Write the SQL Query
$grid->SelectCommand = 'SELECT id, question, categoryid, subcategoryid FROM ip_assignment where priority = "Test"';
// Set the table to where we add the data
$grid->table = 'ip_assignment';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
$grid->dataType = 'json';
$grid->setColModel();
$grid->setUserDate("Y-m-d");
$grid->setUrl('../grids/candidate_assignment.php');
$grid->setColProperty("id", array("editable" => false, "hidden" => true, "label" => "ID"));
$grid->setColProperty("question", array("editable" => true, "width" => 700, "fixed" => true, "edittype" => "textarea", "editoptions" => array("rows" => 6, "cols" => 60), "label" => "Question"));
$grid->setColProperty("categoryid", array("editable" => true, "frozen" => true, "width" => 100, "fixed" => true, "label" => "Subject", "edittype" => "select"));
$grid->setSelect("categoryid", "SELECT distinct id, concat(id,category) FROM ip_subjectcategory order by id");
$grid->setColProperty("subcategoryid", array("editable" => true, "frozen" => true, "width" => 60, "fixed" => true, "label" => "Category", "edittype" => "select"));
$grid->setSelect("subcategoryid", "SELECT distinct id, concat(categoryid,subcategory) FROM ip_subjectsubcategory order by id");
$grid->setGridOptions(array("sortable" => true, "width" => 1024, "height" => 400, "caption" => "Test Management", "rownumbers" => true, "rowNum" => 1000, "shrinkToFit" => false, "sortname" => "categoryid", "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" => false, "edit" => false, "del" => false, "view" => true, "search" => true));
$grid->setNavOptions('view', array("width" => 750, "dataheight" => 300, "viewCaption" => "Test Management"));
$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);
$DB = null;
$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->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" => "Proxy Management"));
$grid->setNavOptions('add', array("width" => 750, "dataheight" => 500, "closeOnEscape" => true, "closeAfterAdd" => true, "addCaption" => "Add Proxy", "reloadAfterSubmit" => false));
$grid->setNavOptions('edit', array("width" => 750, "dataheight" => 500, "closeOnEscape" => true, "closeAfterEdit" => true, "editCaption" => "Update Proxy", "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;
$userid = $_GET['userid'];
$grid = new jqGridRender($DB);
$grid->SelectCommand = 'SELECT l.id,name,username,password,site,status,type, permissionid8,notes FROM login l, uc_user_permission_matches up where (l.permissionid1 = up.permission_id or l.permissionid2 = up.permission_id or l.permissionid3 = up.permission_id or l.permissionid4 = up.permission_id or l.permissionid5 = up.permission_id or l.permissionid6 = up.permission_id or l.permissionid7 = up.permission_id or l.permissionid8 = up.permission_id) and up.user_id = "' . $userid . '"';
$grid->table = 'login';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
$grid->dataType = 'json';
$grid->setColModel();
$grid->setUrl('../grids/rlogins.php?userid=' . $userid);
$grid->setColProperty("id", array("editable" => false, "width" => 25, "hidden" => true, "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->setColProperty("username", array("editable" => true, "frozen" => true, "width" => 200, "editoptions" => array("size" => 75, "maxlength" => 200), "fixed" => true, "label" => "Username"));
$grid->setColProperty("password", array("editable" => true, "frozen" => true, "width" => 200, "editoptions" => array("size" => 75, "maxlength" => 200), "fixed" => true, "label" => "Password"));
$grid->setColProperty("site", array("editable" => true, "frozen" => true, "width" => 400, "editoptions" => array("size" => 75, "maxlength" => 200), "formatter" => "link", "fixed" => true, "editrules" => array("url" => true, "required" => false), "label" => "Site"));
$grid->setColProperty("status", array("editable" => true, "width" => 100, "fixed" => true, "label" => "Status", "edittype" => "select"));
$grid->setSelect("status", $loginstatus, false, true, true, array("" => "All"));
$grid->setColProperty("type", array("editable" => true, "width" => 100, "fixed" => true, "label" => "Type", "edittype" => "select"));
$grid->setSelect("type", $logintype, false, true, true, array("" => "All"));
$grid->setColProperty("permissionid8", array("editable" => true, "width" => 200, "fixed" => true, "label" => "Permission", "edittype" => "select"));
$grid->setSelect("permissionid8", "SELECT distinct up.id, up.name FROM uc_permissions up, uc_user_permission_matches upm where upm.permission_id = up.id and upm.user_id = {$userid} order by name");
$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" => "Login List", "rownumbers" => true, "rowNum" => 100, "sortname" => "id", "sortorder" => "desc", "toppager" => true, "rowList" => array(10, 20, 30, 50, 100)));
$grid->showError = true;
$grid->navigator = true;
$grid->setNavOptions('navigator', array("pdf" => false, "excel" => true, "add" => true, "edit" => true, "del" => false, "view" => true, "search" => true));
$grid->setNavOptions('add', array("width" => 750, "dataheight" => 250, "closeOnEscape" => true, "closeAfterAdd" => true, "addCaption" => "Add Login", "reloadAfterSubmit" => false));
$grid->setNavOptions('edit', array("width" => 750, "dataheight" => 250, "closeOnEscape" => true, "closeAfterEdit" => true, "editCaption" => "Update Login", "reloadAfterSubmit" => false));
$grid->setNavOptions('view', array("width" => 750, "dataheight" => 250, "viewCaption" => "Login Management"));
$grid->callGridMethod('#grid', 'setFrozenColumns');
$grid->callGridMethod('#grid', 'gridResize');
$bindkeys = <<<KEYS
<?php
require_once $_SERVER["DOCUMENT_ROOT"] . "/ip-includes/gridincludes.php";
$grid = new jqGridRender($DB);
$grid->SelectCommand = 'SELECT id, name, version, softkey, type, status, link, notes FROM software';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
$grid->dataType = 'json';
$grid->setColModel();
$grid->setUrl('../grids/software.php');
$grid->setColProperty("id", array("editable" => false, "width" => 25, "hidden" => true, "fixed" => true, "label" => "ID"));
$grid->setColProperty("name", array("editable" => true, "editoptions" => array("size" => 75, "maxlength" => 200), "frozen" => true, "width" => 300, "fixed" => true, "label" => "Name"));
$grid->setColProperty("version", array("editable" => true, "editoptions" => array("size" => 75, "maxlength" => 50), "frozen" => true, "width" => 50, "fixed" => true, "label" => "Version"));
$grid->setColProperty("softkey", array("editable" => true, "editoptions" => array("size" => 75, "maxlength" => 200), "frozen" => true, "width" => 200, "fixed" => true, "label" => "Key"));
$grid->setColProperty("type", array("editable" => true, "width" => 90, "fixed" => true, "label" => "Type", "edittype" => "select"));
$grid->setSelect("type", $softwaretype, false, true, true, array("" => "All"));
$grid->setColProperty("status", array("editable" => true, "width" => 90, "fixed" => true, "label" => "Status", "edittype" => "select"));
$grid->setSelect("status", array("Active" => "Active", "Inactive" => "Inactive"), false, true, true, array("" => "All"));
$grid->setColProperty("link", array("editable" => true, "frozen" => true, "width" => 400, "editoptions" => array("size" => 75, "maxlength" => 200), "formatter" => "link", "fixed" => true, "editrules" => array("url" => true, "required" => false), "label" => "Link"));
$grid->setColProperty("notes", array("editable" => true, "width" => 70, "fixed" => true, "edittype" => "textarea", "editoptions" => array("rows" => 6, "cols" => 80), "label" => "Notes"));
$grid->setGridOptions(array("sortable" => true, "width" => 1024, "height" => 250, "caption" => "Software Management", "rownumbers" => true, "rowNum" => 100, "sortname" => "name", "toppager" => true, "rowList" => array(10, 100, 500)));
$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" => 400, "viewCaption" => "Software Management"));
$grid->setNavOptions('add', array("width" => 750, "dataheight" => 400, "closeOnEscape" => true, "closeAfterAdd" => true, "addCaption" => "Add Software", "bSubmit" => "Add Software", "reloadAfterSubmit" => false));
$grid->setNavOptions('edit', array("width" => 750, "dataheight" => 400, "closeOnEscape" => true, "closeAfterEdit" => true, "editCaption" => "Update Software", "bSubmit" => "Update Software", "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)} } );
$grid = new jqGridRender($DB);
// Write the SQL Query
$grid->SelectCommand = 'SELECT id,name,username,password,site,status,type,recoveryemail, altemail, phone, permissionid1,permissionid2,permissionid3,permissionid4,permissionid5,permissionid6,permissionid7,permissionid8,notes FROM login';
$grid->table = 'login';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
$grid->dataType = 'json';
$grid->setColModel();
$grid->setUrl('../grids/logins.php');
$grid->setColProperty("id", array("editable" => false, "width" => 25, "hidden" => true, "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->setColProperty("username", array("editable" => true, "frozen" => true, "width" => 200, "editoptions" => array("size" => 75, "maxlength" => 200), "fixed" => true, "label" => "Username"));
$grid->setColProperty("password", array("editable" => true, "frozen" => true, "width" => 200, "editoptions" => array("size" => 75, "maxlength" => 200), "fixed" => true, "label" => "Password"));
$grid->setColProperty("site", array("editable" => true, "frozen" => true, "width" => 400, "editoptions" => array("size" => 75, "maxlength" => 200), "formatter" => "link", "formatoptions" => array("target" => "_blank"), "editoptions" => array("size" => 75, "maxlength" => 200), "fixed" => true, "editrules" => array("url" => true, "required" => false), "label" => "Site"));
$grid->setColProperty("status", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Status", "edittype" => "select"));
$grid->setSelect("status", $loginstatus, false, true, true, array("" => "All"));
$grid->setColProperty("type", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Type", "edittype" => "select"));
$grid->setSelect("type", $logintype, false, true, true, array("" => "All"));
$grid->setColProperty("recoveryemail", array("editable" => true, "width" => 150, "fixed" => true, "formatter" => "email", "editrules" => array("email" => true, "required" => false), "label" => "Recovery Email"));
$grid->setColProperty("altemail", array("editable" => true, "width" => 150, "fixed" => true, "formatter" => "email", "editrules" => array("email" => true, "required" => false), "label" => "Alt Email"));
$grid->setColProperty("phone", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Phone"));
$grid->setColProperty("permissionid1", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Permissionid1", "edittype" => "select"));
$grid->setSelect("permissionid1", "select '' as id, '' as name from dual union SELECT distinct id, name FROM uc_permissions order by name");
$grid->setColProperty("permissionid2", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Permissionid2", "edittype" => "select"));
$grid->setSelect("permissionid2", "select '' as id, '' as name from dual union SELECT distinct id, name FROM uc_permissions order by name");
$grid->setColProperty("permissionid3", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Permissionid3", "edittype" => "select"));
$grid->setSelect("permissionid3", "select '' as id, '' as name from dual union SELECT distinct id, name FROM uc_permissions order by name");
$grid->setColProperty("permissionid4", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Permissionid4", "edittype" => "select"));
$grid->setSelect("permissionid4", "select '' as id, '' as name from dual union SELECT distinct id, name FROM uc_permissions order by name");
$grid->setColProperty("permissionid5", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Permissionid5", "edittype" => "select"));
$grid->setSelect("permissionid5", "select '' as id, '' as name from dual union SELECT distinct id, name FROM uc_permissions order by name");
$grid->SelectCommand = 'SELECT CustomerID, CompanyName, Phone, PostalCode, Country, City FROM customers';
// Set the table to where you update the data
$grid->table = 'customers';
$grid->setPrimaryKeyId("CustomerID");
$grid->serialKey = false;
// 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('grid.php');
// Set some grid options
$grid->setGridOptions(array("rowNum" => 10, "rowList" => array(10, 20, 30), "sortname" => "CustomerID"));
$grid->setColProperty('CustomerID', array("editoptions" => array("readonly" => true)));
$grid->setColProperty('City', array("edittype" => "select", "editoptions" => array("value" => " :Select")));
$grid->setSelect("Country", "SELECT DISTINCT Country, Country FROM customers ORDER BY Country", true, true, false);
//$grid->setSelect("City","SELECT DISTINCT City, City FROM customers ORDER BY City", true, true, false);
// This event check if we are in add or edit mode and is lunched
// every time the form opens.
// The purpose of thris event is to get the value of the selected
// country and to get the values of the cityes for that country when the form is open.
// Another action here is to select the city from the grid
$beforeshow = <<<BEFORESHOW
function(formid)
{
// get the value of the country
\tvar cntryval = \$("#Country",formid).val();
\tjQuery("#City",formid).html("<option>Select</option>");
\tif(cntryval) {
\t // if the value is found try to use ajax call to obtain the citys
\t\t// please look at file file city.php
// Set the table to where we add the data
$grid->table = 'session';
$grid->setPrimaryKeyId('sessionid');
$grid->serialKey = false;
// set the ouput format to json
$grid->dataType = 'json';
$grid->datearray = array('sessiondate');
$grid->setUserDate("Y-m-d");
// Let the grid create the model from SQL query
$grid->setColModel();
// Set the url from where we obtain the data
$grid->setUrl('../grids/session.php');
// Change some property of the field(s)
$grid->setColProperty("sessionid", array("editable" => false, "hidden" => true, "label" => "ID"));
$grid->setColProperty("candidateid", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Candidate Name", "edittype" => "select"));
$grid->setSelect("candidateid", "select '' as id, ' Group Mock' as name from dual union SELECT distinct candidateid as id, name as name FROM candidate where status not in ('Discontinued' , 'Completed' , 'Defaulted') order by name");
$grid->setColProperty("candidate2id", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Candidate2 Name", "edittype" => "select"));
$grid->setSelect("candidate2id", "select null as id, '' as name from dual union SELECT distinct candidateid as id, name as name FROM candidate where status not in ('Discontinued' , 'Completed' , 'Defaulted') order by name");
$grid->setColProperty("candidate3id", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Candidate3 Name", "edittype" => "select"));
$grid->setSelect("candidate3id", "select null as id, '' as name from dual union SELECT distinct candidateid as id, name as name FROM candidate where status not in ('Discontinued' , 'Completed' , 'Defaulted') order by name");
$grid->setColProperty("candidate4id", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Candidate4 Name", "edittype" => "select"));
$grid->setSelect("candidate4id", "select null as id, '' as name from dual union SELECT distinct candidateid as id, name as name FROM candidate where status not in ('Discontinued' , 'Completed' , 'Defaulted') order by name");
$grid->setColProperty("candidate5id", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Candidate5 Name", "edittype" => "select"));
$grid->setSelect("candidate5id", "select null as id, '' as name from dual union SELECT distinct candidateid as id, name as name FROM candidate where status not in ('Discontinued' , 'Completed' , 'Defaulted') order by name");
$grid->setColProperty("instructorid", array("editable" => true, "frozen" => true, "width" => 100, "fixed" => true, "label" => "Instructor Name", "edittype" => "select"));
$grid->setSelect("instructorid", "select id, name from employee where designationid in (1,2,9,12) order by name");
$grid->setColProperty("title", array("editable" => true, "frozen" => true, "width" => 400, "editoptions" => array("size" => 75, "maxlength" => 300), "fixed" => true, "editrules" => array("required" => false), "label" => "Title"));
$grid->setColProperty("status", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Status", "edittype" => "select"));
$grid->setSelect("status", $sessionstatus, false, true, true, array("" => "All"));
$grid->setColProperty("sessiondate", array("formatter" => "date", "width" => 70, "fixed" => true, "formatoptions" => array("srcformat" => "Y-m-d", "newformat" => "Y-m-d"), "editable" => true, "label" => "Session 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" => "Session Type", "edittype" => "select"));
<?php
require_once $_SERVER["DOCUMENT_ROOT"] . "/ip-includes/gridincludes.php";
$grid = new jqGridRender($DB);
$grid->SelectCommand = 'SELECT i.id, i.invoicenumber, i.startdate, i.enddate, i.invoicedate, i.quantity, i.otquantity, p.rate, p.overtimerate, i.`status`, i.emppaiddate, i.candpaymentstatus, i.reminders, ((i.quantity * p.rate) + (i.otquantity * p.overtimerate)) as amountexpected, DATE_ADD(i.invoicedate, INTERVAL p.invoicenet DAY)as expecteddate, i.amountreceived, i.receiveddate, i.releaseddate, i.checknumber, i.invoiceurl, i.checkurl, p.freqtype, p.invoicenet, v.companyname, v.fax vendorfax, v.phone vendorphone, v.email vendoremail, v.timsheetemail, v.hrname, v.hremail, v.hrphone, v.managername, v.manageremail, v.managerphone, v.secondaryname, v.secondaryemail, v.secondaryphone, c.name candidatename, c.phone candidatephone, c.email candidateemail, pl.wrkemail, pl.wrkphone, r.name recruitername, r.phone recruiterphone, r.email recruiteremail, i.poid, i.notes from invoice i, po p, placement pl, candidate c, vendor v, recruiter r where i.poid = p.id and p.placementid = pl.id and pl.candidateid = c.candidateid and pl.vendorid = v.id and pl.recruiterid = r.id and i.status <> "Delete"';
$grid->table = 'invoice';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
$grid->dataType = 'json';
$grid->datearray = array('startdate', 'enddate', 'invoicedate', 'expecteddate', 'receiveddate', 'releaseddate');
$grid->setUserDate("Y-m-d");
$grid->setColModel();
$grid->setUrl('../grids/invoice.php');
$grid->setColProperty("id", array("editable" => false, "width" => 50, "fixed" => true, "hidden" => false, "label" => "PKID"));
$grid->setColProperty("poid", array("editable" => true, "frozen" => true, "hidden" => false, "width" => 45, "fixed" => true, "label" => "POID", "edittype" => "select"));
$grid->setSelect("poid", "select null as id, '' as pname from dual union select o.id, concat(c.name, '-', v.companyname, '-', cl.companyname, '-', o.id) as pname from candidate c, placement p, po o, vendor v, client cl where c.candidateid = p.candidateid and o.placementid = p.id and p.vendorid = v.id and p.clientid = cl.id order by pname");
$grid->setColProperty("invoicenumber", array("editable" => true, "frozen" => true, "width" => 100, "fixed" => true, "label" => "Invoice No."));
$grid->setColProperty("startdate", array("formatter" => "date", "width" => 120, "fixed" => true, "formatoptions" => array("srcformat" => "Y-m-d", "newformat" => "Y-m-d"), "editable" => true, "label" => "Start 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("enddate", array("formatter" => "date", "width" => 120, "fixed" => true, "formatoptions" => array("srcformat" => "Y-m-d", "newformat" => "Y-m-d"), "editable" => true, "label" => "End 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("invoicedate", array("formatter" => "date", "width" => 120, "fixed" => true, "formatoptions" => array("srcformat" => "Y-m-d", "newformat" => "Y-m-d"), "editable" => true, "label" => "Invoice 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("quantity", array("editable" => true, "summaryType" => "sum", summaryTpl => "Q: {0}", "width" => 60, "fixed" => true, "formatter" => "integer", "editrules" => array("minValue" => 0, "maxValue" => 1000), "label" => "Quantity"));
$grid->setColProperty("otquantity", array("editable" => true, "summaryType" => "sum", summaryTpl => "Q: {0}", "width" => 80, "fixed" => true, "formatter" => "integer", "editrules" => array("minValue" => 0, "maxValue" => 1000), "label" => "OT Quantity"));
$grid->setColProperty("status", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Status", "edittype" => "select"));
$grid->setSelect("status", $invoicestatus, false, true, true, array("" => "All"));
$grid->setColProperty("reminders", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Reminders", "edittype" => "select"));
$grid->setSelect("reminders", array("Y" => "Y", "N" => "N"), false, true, true, array("" => "All"));
$grid->setColProperty("amountexpected", array("editable" => false, "summaryType" => "sum", summaryTpl => "E: {0}", "width" => 150, "fixed" => true, "formatter" => "currency", "formatoptions" => array("decimalPlaces" => 2, "thousandsSeparator" => ",", "prefix" => "\$"), "label" => "Expected"));
$grid->setColProperty("expecteddate", array("editable" => false, "width" => 120, "fixed" => true, "hidden" => false, "label" => "Expected 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("amountreceived", array("editable" => true, "summaryType" => "sum", summaryTpl => "R: {0}", "width" => 150, "fixed" => true, "formatter" => "currency", "formatoptions" => array("decimalPlaces" => 2, "thousandsSeparator" => ",", "prefix" => "\$"), "label" => "Received"));
$summaryrows = array("quantity" => array("quantity" => "SUM"), "amountreceived" => array("amountreceived" => "SUM"), "amountexpected" => array("quantity * rate" => "SUM"));
$grid->setColProperty("releaseddate", array("formatter" => "date", "width" => 120, "fixed" => true, "formatoptions" => array("srcformat" => "Y-m-d", "newformat" => "Y-m-d"), "editable" => true, "label" => "Released 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);}")));
<?php
require_once $_SERVER["DOCUMENT_ROOT"] . "/ip-includes/gridincludes.php";
// Create the jqGrid instance
$grid = new jqGridRender($DB);
// Write the SQL Query
$grid->SelectCommand = 'SELECT id, vendorid, candidateid , name, url, type FROM agreement';
$grid->table = 'agreement';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
$grid->dataType = 'json';
$grid->setColModel();
$grid->setUrl('../grids/agreement.php');
$grid->setColProperty("id", array("editable" => false, "width" => 25, "fixed" => true, "label" => "ID"));
$grid->setColProperty("vendorid", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Vendor", "edittype" => "select"));
$grid->setSelect("vendorid", "select '' as id, '' as name from dual union SELECT distinct id as id, companyname as name FROM vendor order by name");
$grid->setColProperty("candidateid", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Candidate Name", "edittype" => "select"));
$grid->setSelect("candidateid", "select '' as id , ' None' as name from dual union SELECT distinct candidateid as id, name as name FROM candidate where status = 'Placed' order by name ");
$grid->setColProperty("name", array("editable" => true, "width" => 100, "fixed" => true, "label" => "Name"));
$grid->setColProperty("url", array("editable" => true, "width" => 120, "fixed" => true, "formatter" => "link", "label" => "Url"));
$grid->setColProperty("type", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Type", "edittype" => "select"));
$grid->setSelect("type", $agreementtype, false, true, true, array("" => "All"));
$grid->setGridOptions(array("sortable" => true, "width" => 1024, "height" => 250, "caption" => "Agreement Management", "rownumbers" => true, "rowNum" => 1000, "footerrow" => true, "userDataOnFooter" => true, "shrinkToFit" => false, "sortname" => "id", "sortorder" => "desc", "toppager" => true, "rowList" => array(10, 50, 100, 500, 1000)));
$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" => "Agreement Management"));
$grid->setNavOptions('add', array("width" => 750, "dataheight" => 500, "closeOnEscape" => true, "closeAfterAdd" => true, "addCaption" => "Add Agreement", "reloadAfterSubmit" => false));
$grid->setNavOptions('edit', array("width" => 750, "dataheight" => 500, "closeOnEscape" => true, "closeAfterEdit" => true, "editCaption" => "Update Agreement", "reloadAfterSubmit" => false));
$grid->callGridMethod('#grid', 'setFrozenColumns');
$grid->callGridMethod('#grid', 'gridResize');
$grid = new jqGridRender($DB);
$grid->SelectCommand = 'SELECT id,companyname,email,phone,status,url,fax,address,city,state,country,twitter,linkedin,facebook,zip,manager1name,manager1email,manager1phone,hmname,hmemail,hmphone,hrname,hremail,hrphone,notes FROM client';
$grid->table = 'client';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
$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"));
require_once $_SERVER["DOCUMENT_ROOT"] . "/ip-includes/gridincludes.php";
$employeeid = $_GET['employeeid'];
$grid = new jqGridRender($DB);
$grid->SelectCommand = 'SELECT id, candidateid, candidateid as cid, mmid, positiondate, type, status, vendorcall, rate, vendor1email, vendor1, clientemail, client, vendor2email, vendor2,vendor3email, vendor3, reference, notes FROM position where mmid = "' . $employeeid . '" or mmid in (select id from employee where mgrid = "' . $employeeid . '")';
$grid->table = 'position';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
$grid->dataType = 'json';
$grid->datearray = array('positiondate');
$grid->setUserDate("Y-m-d");
$grid->setColModel();
$grid->setUrl('../grids/rposition.php?employeeid=' . $employeeid);
$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);
// Create the jqGrid instance
$grid = new jqGridRender($DB);
// Write the SQL Query
$grid->SelectCommand = 'SELECT id, weeknumber, instructorid, question, categoryid, subcategoryid, priority FROM ip_assignment';
// Set the table to where we add the data
$grid->table = 'ip_assignment';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
$grid->dataType = 'json';
$grid->setColModel();
$grid->setUserDate("Y-m-d");
$grid->setUrl('../grids/assignment.php');
$grid->setColProperty("id", array("editable" => false, "hidden" => true, "label" => "ID"));
$grid->setColProperty("weeknumber", array("editable" => true, "width" => 30, "fixed" => true, "label" => "Week"));
$grid->setColProperty("instructorid", array("editable" => true, "frozen" => true, "width" => 100, "fixed" => true, "label" => "Instructor", "edittype" => "select"));
$grid->setSelect("instructorid", "SELECT distinct id, name FROM employee order by id");
$grid->setColProperty("question", array("editable" => true, "width" => 450, "fixed" => true, "edittype" => "textarea", "editoptions" => array("rows" => 6, "cols" => 60), "label" => "Question"));
$grid->setColProperty("categoryid", array("editable" => true, "frozen" => true, "width" => 60, "fixed" => true, "label" => "Subject", "edittype" => "select"));
$grid->setSelect("categoryid", "SELECT distinct id, concat(id,category) FROM ip_subjectcategory order by id");
$grid->setColProperty("subcategoryid", array("editable" => true, "frozen" => true, "width" => 60, "fixed" => true, "label" => "Category", "edittype" => "select"));
$grid->setSelect("subcategoryid", "SELECT distinct id, concat(categoryid,subcategory) FROM ip_subjectsubcategory order by id");
$grid->setColProperty("priority", array("editable" => true, "width" => 30, "fixed" => true, "label" => "Priority"));
$grid->setGridOptions(array("sortable" => true, "width" => 1024, "height" => 400, "caption" => "Assignment Management", "rownumbers" => true, "rowNum" => 1000, "shrinkToFit" => false, "sortname" => "weeknumber", "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" => "Assignment Management"));
$grid->setNavOptions('add', array("width" => 750, "dataheight" => 300, "closeOnEscape" => true, "closeAfterAdd" => true, "addCaption" => "Add Assignment", "reloadAfterSubmit" => false));
$grid->setNavOptions('edit', array("width" => 750, "dataheight" => 300, "closeOnEscape" => true, "closeAfterEdit" => true, "editCaption" => "Update Assignment", "reloadAfterSubmit" => false));
$grid->callGridMethod('#grid', 'setFrozenColumns');
$grid->callGridMethod('#grid', 'gridResize');
$grid->setUserDate("Y-m-d");
// Let the grid create the model from SQL query
$grid->setColModel();
// Set the url from where we obtain the data
$grid->setUrl('../grids/insidesales.php');
// Change some property of the field(s)
$grid->setColProperty("id", array("editable" => false, "hidden" => true, "label" => "ID"));
$grid->setColProperty("startdate", array("formatter" => "date", "width" => 80, "fixed" => true, "formatoptions" => array("srcformat" => "Y-m-d", "newformat" => "Y-m-d"), "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("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("type", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Type", "edittype" => "select"));
$grid->setSelect("type", $insidesaletype, false, true, true, array("" => "All"));
$grid->setColProperty("status", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Status", "edittype" => "select"));
$grid->setSelect("status", $insidesalestatus, false, true, true, array("" => "All"));
$grid->setColProperty("notes", array("editable" => true, "width" => 70, "fixed" => true, "edittype" => "textarea", "editoptions" => array("rows" => 6, "cols" => 80), "label" => "Notes"));
// Set alternate background using altRows property
$grid->setGridOptions(array("sortable" => true, "width" => 1024, "height" => 250, "caption" => "Inside Sales Management", "rownumbers" => true, "rowNum" => 100, "shrinkToFit" => false, "sortname" => "startdate", "sortorder" => "desc", "toppager" => true, "rowList" => array(10, 20, 30, 50, 100, 500)));
$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" => "Inside Sales Management"));
$grid->setNavOptions('add', array("width" => 750, "dataheight" => 500, "closeOnEscape" => true, "closeAfterAdd" => true, "addCaption" => "Add Inside Sale", "reloadAfterSubmit" => false));
$grid->setNavOptions('edit', array("width" => 750, "dataheight" => 500, "closeOnEscape" => true, "closeAfterEdit" => true, "editCaption" => "Update Inside Sale", "reloadAfterSubmit" => false));
//$grid->toolbarfilter = true;
$grid->callGridMethod('#grid', 'setFrozenColumns');
$grid->callGridMethod('#grid', 'gridResize');
$bindkeys = <<<KEYS
require_once $_SERVER["DOCUMENT_ROOT"] . "/ip-includes/gridincludes.php";
$grid = new jqGridRender($DB);
$grid->SelectCommand = 'SELECT id, (select url from clr_position cp where cp.id = positionid) url, email, applicationdate, autoapply, candidate from clr_applications';
$grid->table = 'clr_applications';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
$grid->dataType = 'json';
$grid->setColModel();
$grid->setUrl('../grids/clr_application.php');
$grid->addCol(array("name" => "Actions", "formatter" => "actions", "editable" => false, "sortable" => false, "resizable" => false, "fixed" => true, "width" => 60, "formatoptions" => array("keys" => true)), "first");
$grid->setColProperty("id", array("editable" => false, "width" => 40, "fixed" => true, "label" => "ID"));
$grid->setColProperty("url", array("editable" => false, "frozen" => true, "width" => 500, "editoptions" => array("size" => 75, "maxlength" => 200), "formatter" => "link", "formatoptions" => array("target" => "_blank"), "fixed" => true, "editrules" => array("url" => true, "required" => false), "label" => "Url"));
$grid->setColProperty("email", array("editable" => false, "frozen" => true, "width" => 140, "editoptions" => array("size" => 75, "maxlength" => 200), "fixed" => true, "label" => "Email"));
$grid->setColProperty("applicationdate", array("formatter" => "date", "width" => 70, "fixed" => true, "formatoptions" => array("srcformat" => "Y-m-d", "newformat" => "Y-m-d"), "editable" => false, "label" => "Appl Date", "editoptions" => array("dataInit" => "js:function(elm){setTimeout(function(){\r\r\n jQuery(elm).datepicker({dateFormat:'yy-mm-dd'});\r\r\n jQuery('.ui-datepicker').css({'font-size':'75%'});\r\r\n },200);}"), "searchoptions" => array("dataInit" => "js:function(elm){setTimeout(function(){\r\r\n jQuery(elm).datepicker({dateFormat:'yy-mm-dd'});\r\r\n jQuery('.ui-datepicker').css({'font-size':'75%'});\r\r\n },200);}")));
$grid->setColProperty("autoapply", array("editable" => true, "label" => "Auto Apply", "width" => 50, "fixed" => true, "edittype" => "select"));
$grid->setSelect("autoapply", array("M" => "M"), false, true, true, array("" => "All"));
$grid->setColProperty("candidate", array("editable" => true, "label" => "Candidate", "width" => 50, "fixed" => true, "edittype" => "select"));
$grid->setSelect("candidate", array("Y" => "Y", "N" => "N"), false, true, true, array("" => "All"));
$grid->setGridOptions(array("sortable" => true, "width" => 1024, "height" => 400, "caption" => "Crawler Applications", "rownumbers" => true, "rowNum" => 1000, "sortname" => "applicationdate desc, id", "sortorder" => "desc", "toppager" => true, "rowList" => array(1000, 5000, 10000, 25000, 50000)));
$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" => 300, "viewCaption" => "Crawler Applications Management"));
$grid->setNavOptions('add', array("width" => 750, "dataheight" => 300, "closeOnEscape" => true, "closeAfterAdd" => true, "addCaption" => "Add Crawler Applications", "reloadAfterSubmit" => false));
$grid->setNavOptions('edit', array("width" => 750, "dataheight" => 300, "closeOnEscape" => true, "closeAfterEdit" => true, "editCaption" => "Update Crawler Applications", "reloadAfterSubmit" => false));
$grid->callGridMethod('#grid', 'setFrozenColumns');
$grid->callGridMethod('#grid', 'gridResize');
global $htmlcode;
$bindkeys = <<<KEYS
\$("#grid").jqGrid('bindKeys', {"onEnter":function( rowid ) {
// Set the table to where we add the data
$grid->table = 'interview';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
// set the ouput format to json
$grid->dataType = 'json';
$grid->datearray = array('interviewdate');
$grid->setUserDate("Y-m-d");
// Let the grid create the model from SQL query
$grid->setColModel();
// Set the url from where we obtain the data
$grid->setUrl('../grids/interview.php');
// Change some property of the field(s)
$grid->setColProperty("id", array("editable" => false, "hidden" => true, "label" => "ID"));
$grid->setColProperty("candidateid", array("editable" => 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 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 order by name");
$grid->setColProperty("interviewdate", array("formatter" => "date", "width" => 80, "fixed" => true, "formatoptions" => array("srcformat" => "Y-m-d", "newformat" => "Y-m-d"), "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("type", array("editable" => false, "width" => 70, "fixed" => true, "label" => "Type", "edittype" => "select"));
$grid->setSelect("type", $interviewtype, false, true, true, array("" => "All"));
$grid->setColProperty("clientname", array("editable" => true, "width" => 90, "fixed" => true, "label" => "Client Name"));
$grid->setColProperty("clientlocation", array("editable" => true, "width" => 90, "fixed" => true, "label" => "Client Location"));
$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("reclink", array("editable" => true, "frozen" => true, "width" => 400, "formatter" => "link", "formatoptions" => array("target" => "_blank"), "fixed" => true, "editrules" => array("url" => true, "required" => false), "label" => "Recording Link"));
$grid->setColProperty("questionslink", array("editable" => true, "frozen" => true, "width" => 400, "formatter" => "link", "formatoptions" => array("target" => "_blank"), "fixed" => true, "editrules" => array("url" => true, "required" => false), "label" => "Ques Link"));
$grid->setColProperty("questions", array("editable" => true, "hidden" => true, "edittype" => "textarea", "editrules" => array("edithidden" => true, "required" => false), "editoptions" => array("rows" => 6, "cols" => 80), "label" => "Questions"));
$grid->setColProperty("notes", array("editable" => true, "width" => 70, "fixed" => true, "edittype" => "textarea", "editrules" => array("edithidden" => true, "required" => false), "editoptions" => array("rows" => 6, "cols" => 80), "label" => "Notes"));
