PHP jqGridRender::setColProperty方法代码示例

function get_main_grid()
{
    global $myconn, $customers;
    $myconn->query("SET NAMES utf8");
    //execute the query specifical to your database
    $sth = $myconn->prepare('SELECT CustomerID, CompanyName, ContactName, Phone, City FROM customers');
    $sth->execute();
    // get the data as array. Nothe the the customer array
    // is passed in the select command
    $customers = $sth->fetchAll(PDO::FETCH_ASSOC);
    // end of custom code
    //var_dump($customers);
    // create the array connection
    $conn = new jqGridArray();
    // Create the jqGrid instance
    $grid = new jqGridRender($conn);
    // Write the SQL Query
    $grid->SelectCommand = 'SELECT * FROM customers';
    // Set the table to where you update the data
    $grid->table = 'customers';
    // Set output format to json
    $grid->dataType = 'json';
    $grid->setPrimaryKeyId("CustomerID");
    // 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, "height" => 250, "rowList" => array(10, 20, 30), "sortname" => "CustomerID"));
    $grid->setColProperty('CustomerID', array("label" => "ID", "width" => 50));
    $grid->setSubGridGrid("subgrid.php");
    // Enable navigator
    $grid->navigator = true;
    // Enable only editing
    $grid->setNavOptions('navigator', array("excel" => false, "add" => false, "edit" => false, "del" => false, "view" => false));
    // Enjoy
    $grid->renderGrid('#grid', '#pager', true, null, null, true, true);
}

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

$conn = new PDO(DB_DSN, DB_USER, DB_PASSWORD);
// Tell the db that we use utf-8
$conn->query("SET NAMES utf8");
// Create the jqGrid instance
$grid = new jqGridRender($conn);
// Write the SQL Query
$grid->SelectCommand = "SELECT name as Mnemonic, seen as Seen, lastseen as LastSeen FROM mne where hidden='false'";
// set the ouput format to json
$grid->dataType = 'json';
// Let the grid create the model
$grid->setColModel();
// Set the url from where we obtain the data
$grid->setUrl('includes/grid/mne.php');
// Set some grid options
$grid->setGridOptions(array("rowNum" => 19, "sortname" => "LastSeen", "sortorder" => "desc", "altRows" => true, "multiselect" => true, "scrollOffset" => 25, "shrinkToFit" => true, "setGridHeight" => "100%", "rowList" => array(20, 40, 60, 75, 100, 500, 750, 1000), "loadComplete" => "js:"));
$grid->setColProperty('Seen', array('width' => '20', 'formatter' => 'js:grid_formatSeen'));
$grid->setColProperty('LastSeen', array('width' => '35', 'formatter' => 'js:easyDate'));
$grid->navigator = true;
$grid->setNavOptions('navigator', array("pdf" => true, "excel" => true, "add" => false, "edit" => false, "del" => false, "view" => false, "search" => true));
$gridComplete = <<<ONCOMPLETE
\tfunction ()
\t{\t
\t setRememberedCheckboxesForDialog('mnemonics','gbox_mnegrid',12,'portlet_Mnemonics');

\t}
ONCOMPLETE;
$grid->setGridEvent('loadComplete', $gridComplete);
$custom = <<<CUSTOM

//---------------------------------------------------------------
// BEGIN: Mnemonic Select Dialog

$conn = new PDO(DB_DSN, DB_USER, DB_PASSWORD);
// Tell the db that we use utf-8
$conn->query("SET NAMES utf8");
// Create the jqGrid instance
$grid = new jqGridRender($conn);
// Write the SQL Query
$grid->SelectCommand = 'SELECT OrderID, OrderDate, CustomerID, ShipName, Freight FROM orders';
// 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" => "OrderID", "caption" => "PDF export with custom header"));
// Change some property of the field(s)
$grid->setColProperty("OrderDate", array("formatter" => "date", "formatoptions" => array("srcformat" => "Y-m-d H:i:s", "newformat" => "m/d/Y"), "search" => false));
$grid->setColProperty("ShipName", array("width" => "250"));
$grid->setColProperty("Freight", array("label" => "Test", "align" => "right"));
// Enable navigator
$grid->navigator = true;
// Enable pdf export on navigator
$grid->setNavOptions('navigator', array("pdf" => true, "add" => false, "edit" => false, "del" => false, "view" => false, "excel" => false));
$oper = jqGridUtils::GetParam("oper");
// prevent some executions when not excel export
if ($oper == "pdf") {
    $grid->setPdfOptions(array("header" => true, "margin_top" => 27, "header_logo" => "logo.gif", "header_logo_width" => 30, "header_title" => "jqGrid pdf table", "header_string" => "by Trirand Inc - www.trirand.net"));
}
// Enjoy
$grid->renderGrid('#grid', '#pager', true, null, null, true, true);
$conn = null;

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

require_once ABSPATH . "php/jqGridPdo.php";
// Connection to the server
$conn = new PDO(DB_DSN, DB_USER, DB_PASSWORD);
// Tell the db that we use utf-8
$conn->query("SET NAMES utf8");
$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));

<?php

require_once $_SERVER["DOCUMENT_ROOT"] . "/ip-includes/gridincludes.php";
$grid = new jqGridRender($DB);
$grid->SelectCommand = 'select distinct CONCAT("www.", SUBSTRING(email FROM instr(email, "@")+1)) url, email, positiondate from (select vendor1email as email, positiondate from position where vendor1email is not null union select vendor2email, positiondate from position where vendor2email is not null union select vendor3email, positiondate from position where vendor3email is not null union select client1email, null from interview where client1email is not null union select client2email, null from interview where client2email is not null union select client3email, null from interview where client3email is not null union select vendor1email, interviewdate from interview where vendor1email is not null union select vendor2email, interviewdate from interview where vendor2email is not null union select vendor3email, interviewdate from interview where vendor3email is not null) e ';
$grid->dataType = 'json';
$grid->setColModel();
$grid->setUrl('../grids/newvendoremail.php');
$grid->setColProperty("url", array("editable" => false, "width" => 300, "fixed" => true, "formatter" => "link", "editrules" => array("url" => true, "required" => false), "label" => "URL"));
$grid->setColProperty("email", array("editable" => true, "width" => 500, "fixed" => true, "formatter" => "email", "editrules" => array("email" => true, "required" => true), "label" => "Email"));
$grid->setColProperty("positiondate", array("editable" => false, "hidden" => true, "label" => "ID"));
// Set alternate background using altRows property
$grid->setGridOptions(array("sortable" => true, "width" => 1024, "height" => 250, "caption" => "New Vendor Emails Management", "rownumbers" => true, "rowNum" => 100, "shrinkToFit" => false, "sortname" => "positiondate", "sortorder" => "desc", "toppager" => true, "rowList" => array(10, 100, 500, 1000)));
$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" => 500, "viewCaption" => "New Vendor Email 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;

<?php

require_once $_SERVER["DOCUMENT_ROOT"] . "/ip-includes/gridincludes.php";
$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"));

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

<?php

require_once $_SERVER["DOCUMENT_ROOT"] . "/ip-includes/gridincludes.php";
$candidateID = $loggedInUser->candidateid;
$grid = new jqGridRender($DB);
// Write the SQL Query
$q = 'select s.clientname, s.type, s.interviewdate, s.status, u.name manager from interview s, employee u where s.mmid = u.id and s.candidateid = ' . $candidateID;
$grid->SelectCommand = $q;
$grid->serialKey = false;
$grid->dataType = 'json';
$grid->setColModel();
$grid->setUrl('../grids/candidateinterviews.php');
$grid->setColProperty("clientname", array("editable" => false, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Client"));
$grid->setColProperty("type", array("editable" => false, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Type"));
$grid->setColProperty("interviewdate", array("editable" => false, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Interview Date"));
$grid->setColProperty("status", array("editable" => false, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Status"));
$grid->setColProperty("manager", array("editable" => false, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Manager"));
// Set alternate background using altRows property
$grid->setGridOptions(array("sortable" => true, "width" => 1024, "height" => 250, "caption" => "Interviews", "rownumbers" => true, "rowNum" => 50, "shrinkToFit" => false, "sortname" => "interviewdate", "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" => false, "edit" => false, "del" => false, "view" => true, "search" => true));
$grid->setNavOptions('view', array("width" => 750, "dataheight" => 500, "viewCaption" => "Interviews"));
$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;

<?php

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

$conn = new PDO(DB_DSN, DB_USER, DB_PASSWORD);
// MySQL specific command for the charset
$conn->query("SET NAMES utf8");
// Create the jqGrid instance
$grid = new jqGridRender($conn);
// Data from this SQL is 1252 encoded, so we need to tell the grid
// Set the data source to be read from file
$grid->readFromXML = true;
// The first item is the xml file, the second is the query id
$grid->SelectCommand = 'sqlxml.getProducts';
// set the ouput format to XML
$grid->dataType = 'xml';
// Let the grid create the model
$grid->setColModel();
// set labels in the header
$grid->setColProperty("ProductID", array("label" => "ID"));
$grid->setColProperty("ProductName", array("label" => "Name"));
$grid->setColProperty("QuantityPerUnit", array("label" => "Unit"));
$grid->setColProperty("UnitPrice", array("label" => "Unit Price"));
// We can hide some columns
$grid->setColProperty("SupplierID", array("hidden" => true));
$grid->setColProperty("CategoryID", array("hidden" => true));
$grid->setColProperty("UnitsOnOrder", array("hidden" => true));
$grid->setColProperty("ReorderLevel", array("hidden" => true));
$grid->setColProperty("Discontinued", array("hidden" => true));
// 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" => "CategoryID"));
// Enable toolbar searching
$grid->toolbarfilter = true;

require_once ABSPATH . "php/jqGrid.php";
require_once ABSPATH . "php/jqAutocomplete.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, startdate, name, email, phone, wrkemail, wrkphone, status, communication, notes FROM proxy';
$grid->table = 'proxy';
$grid->setPrimaryKeyId('id');
$grid->serialKey = false;
$grid->dataType = 'json';
$grid->datearray = array('startdate');
$grid->setUserDate("Y-m-d");
$grid->setColModel();
$grid->setUrl('proxy.php');
$grid->setColProperty("id", array("editable" => false, "width" => 25, "fixed" => true, "label" => "ID"));
$grid->setColProperty('startdate', array("editable" => false, "width" => 70, "fixed" => true, "formatter" => "date", "label" => "Start Date", "formatoptions" => array("srcformat" => "Y-m-d HH:MM:SS", "newformat" => "m/d/Y"), "searchoptions" => array("dataInit" => "js:function(elm){setTimeout(function(){\n\t\t\t\t\t jQuery(elm).datepicker({dateFormat:'yy-mm-dd'});\n\t\t\t\t\t jQuery('.ui-datepicker').css({'font-size':'75%'});\n\t\t\t },200);}")));
$grid->setColProperty("name", array("editable" => true, "frozen" => true, "width" => 200, "fixed" => true, "label" => "Name"));
$grid->setAutocomplete("name", null, "select name, name from (SELECT distinct name FROM leads union select distinct name from candidate union select distinct name from recruit) p where name like ? ORDER BY name", null, true, true);
$grid->setColProperty("email", array("editable" => true, "width" => 150, "fixed" => true, "formatter" => "email", "editrules" => array("email" => true, "required" => true), "label" => "Email"));
$grid->setAutocomplete("email", null, "select email, email from (SELECT distinct email FROM leads union select distinct email from candidate union select distinct email from recruit) p where email like ? ORDER BY email", null, true, true);
$grid->setColProperty("phone", array("editable" => true, "width" => 90, "fixed" => true, "label" => "Phone"));
$grid->setAutocomplete("phone", null, "select phone, phone from (SELECT distinct phone FROM leads union select distinct phone from candidate union select distinct phone from recruit) p where phone like ? ORDER BY phone", null, true, true);
$grid->setColProperty("wrkemail", array("editable" => true, "width" => 150, "fixed" => true, "formatter" => "email", "editrules" => array("email" => true, "required" => false), "label" => "Wrk Email"));
$grid->setAutocomplete("wrkemail", null, "select wrkemail, wrkemail from (SELECT distinct wrkemail FROM placement) p where wrkemail like ? ORDER BY wrkemail", null, true, true);
$grid->setColProperty("wrkphone", array("editable" => true, "width" => 90, "fixed" => true, "label" => "Wrk Phone"));
$grid->setAutocomplete("wrkphone", null, "select wrkphone, wrkphone from (SELECT distinct wrkphone FROM placement) p where wrkphone like ? ORDER BY wrkphone", null, true, true);
$grid->setColProperty("status", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Status", "edittype" => "select"));
$grid->setSelect("status", $referencestatus, false, true, true, array("" => "All"));
$grid->setColProperty("communication", array("editable" => true, "width" => 70, "fixed" => true, "label" => "Communication", "edittype" => "select"));
$grid->setSelect("communication", $communication, false, true, true, array("" => "All"));

include_once "../ip-config.php";
require_once '../jq-config.php';
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');

<?php

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