I'm using multiple datepicker on same grid and I face the problem to get a proper result.
I used 3 datepicker in 1 grid.
Only the first datepicker (Order Date)is able to output proper result while the other 2 datepicker (Start Date & End Date) are not able to generate proper result.
There is no problem with the query, so could you find out what's going on here?
Thanks in advance!
php wrapper
<?php
ob_start();
require_once 'config.php';
// include the jqGrid Class
require_once "php/jqGrid.php";
// include the PDO driver class
require_once "php/jqGridPdo.php";
// include the datepicker
require_once "php/jqCalendar.php";
// Connection to the server
$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);
// Tell the db that we use utf-8
$conn->query("SET NAMES utf8");
// Create the jqGrid instance
$grid = new jqGridRender($conn);
// Write the SQL Query
$grid->SelectCommand = "SELECT c.CompanyID, c.CompanyCode, c.CompanyName, c.Area, o.OrderCode, o.Date, m.maID ,m.System, m.Status, m.StartDate, m.EndDate, m.
Type FROM company c, orders o, maintenance_agreement m WHERE c.CompanyID = o.CompanyID AND o.OrderID = m.OrderID ";
// Set the table to where you update the data
$grid->table = 'maintenance_agreement';
// set the ouput format to json
$grid->dataType = 'json';
// Let the grid create the model
$grid->setPrimaryKeyId('maID');
// Let the grid create the model
$grid->setColModel();
// Set the url from where we obtain the data
$grid->setUrl('grouping_ma_details.php');
// Set grid caption using the option caption
$grid->setGridOptions(array(
"sortable"=>true,
"rownumbers"=>true,
"caption"=>"Group by Maintenance Agreement",
"rowNum"=>20,
"height"=>'auto',
"width"=>1300,
"sortname"=>"maID",
"hoverrows"=>true,
"rowList"=>array(10,20,50),
"footerrow"=>false,
"userDataOnFooter"=>false,
"grouping"=>true,
"groupingView"=>array(
"groupField" => array('CompanyName'),
"groupColumnShow" => array(true), //show or hide area column
"groupText" =>array('<b> Company Name: {0}</b>',),
"groupDataSorted" =>
true,
"groupSummary" => array(true)
)
));
if(isset($_SESSION['login_admin']))
{
$grid->addCol(array(
"name"=>"Action",
"formatter"=>"actions",
"editable"=>false,
"sortable"=>false,
"resizable"=>false,
"fixed"=>true,
"width"=>60,
"formatoptions"=>array("keys"=>true),
"search"=>false
), "first");
}
// Change some property of the field(s)
$grid->setColProperty("CompanyID", array("label"=>"ID","hidden"=>true,"width"=>30,"editable"=>false,"editoptions"=>array("readonly"=>"readonly")));
$grid->setColProperty("CompanyName", array("label"=>"Company Name","hidden"=>true,"editable"=>false,"width"=>150,"align"=>"center","fixed"=>true));
$grid->setColProperty("CompanyCode", array("label"=>"Company Code","hidden"=>true,"width"=>50,"align"=>"center"));
$grid->setColProperty("OrderCode", array("label"=>"Order Code","width"=>110,"editable"=>false,"align"=>"center","fixed"=>true));
$grid->setColProperty("maID", array("hidden"=>true));
$grid->setColProperty("System", array("width"=>150,"fixed"=>true,"align"=>"center"));
$grid->setColProperty("
Type", array("width"=>280,"fixed"=>true));
$grid->setColProperty("Status", array("width"=>70,"align"=>"center","edittype"=>"select","editoptions"=>array("value"=>"Yes:Yes;No:No"),"fixed"=>true));
$grid->setSelect('System', "SELECT DISTINCT System, System AS System FROM master_ma_system ORDER BY System", false,
true,
true, array(""=>"All"));
$grid->setSelect('
Type', "SELECT DISTINCT
Type,
Type AS
Type FROM master_ma_type ORDER BY
Type", false,
true,
true, array(""=>"All"));
$grid->setColProperty("StartDate", array("label"=>"Start Date","width"=>120,"align"=>"center","fixed"=>true,
"formatter"=>"date",
"formatoptions"=>array("srcformat"=>"Y-m-d H:i:s","newformat"=>"d M Y")
));
// this is only in this case since the orderdate is set as date time
$grid->setUserTime("d M Y");
$grid->setUserDate("d M Y");
$grid->setDatepicker("StartDate",array("buttonOnly"=>false));
$grid->datearray = array('StartDate');
$grid->setColProperty("EndDate", array("label"=>"End Date","width"=>120,"align"=>"center","fixed"=>true,
"formatter"=>"date",
"formatoptions"=>array("srcformat"=>"Y-m-d H:i:s","newformat"=>"d M Y")
));
// this is only in this case since the orderdate is set as date time
$grid->setUserTime("d M Y");
$grid->setUserDate("d M Y");
$grid->setDatepicker("EndDate",array("buttonOnly"=>false));
$grid->datearray = array('EndDate');
$grid->setColProperty("Date", array("label"=>"Order Date","width"=>100,"editable"=>false,"align"=>"center","fixed"=>true,
"formatter"=>"date",
"formatoptions"=>array("srcformat"=>"Y-m-d H:i:s","newformat"=>"d M Y")
));
// this is only in this case since the orderdate is set as date time
$grid->setUserTime("d M Y");
$grid->setUserDate("d M Y");
$grid->setDatepicker("Date",array("buttonOnly"=>false));
$grid->datearray = array('Date');
// This command is executed after edit
$maID = jqGridUtils::GetParam('maID');
$Status = jqGridUtils::GetParam('Status');
$StartDate = jqGridUtils::GetParam('StartDate');
$EndDate = jqGridUtils::GetParam('EndDate');
$Type = jqGridUtils::GetParam('
Type');
// This command is executed immediatley after edit occur.
$grid->setAfterCrudAction('edit', "UPDATE maintenance_agreement SET m.Status=?,
m.StartDate=?,
m.EndDate=?,
m.Type=?
WHERE m.maID=?",
array($Status,$StartDate,$EndDate,$Type,$maID));
$selectorder = <<<ORDER
function(rowid, selected)
{
if(rowid != null) {
jQuery("#detail").jqGrid('setGridParam',{postData:{CompanyID:rowid}});
jQuery("#detail").trigger("reloadGrid");
// Enable CRUD buttons in navigator when a row is selected
jQuery("#add_detail").removeClass("ui-state-disabled");
jQuery("#edit_detail").removeClass("ui-state-disabled");
jQuery("#del_detail").removeClass("ui-state-disabled");
}
}
ORDER;
// We should clear the grid data on second grid on sorting, paging, etc.
$cleargrid = <<<CLEAR
function(rowid, selected)
{
// clear the grid data and footer data
jQuery("#detail").jqGrid('clearGridData',true);
// Disable CRUD buttons in navigator when a row is not selected
jQuery("#add_detail").addClass("ui-state-disabled");
jQuery("#edit_detail").addClass("ui-state-disabled");
jQuery("#del_detail").addClass("ui-state-disabled");
}
CLEAR;
$grid->setGridEvent('onSelectRow', $selectorder);
$grid->setGridEvent('onSortCol', $cleargrid);
$grid->setGridEvent('onPaging', $cleargrid);
$grid->setColProperty("Area", array("width"=>100,"hidden"=>false,"editable"=>false,"fixed"=>true));
$grid->setColProperty("HeadCount", array("label"=>"Head Count","align"=>"center", "width"=>100,"hidden"=>false,"fixed"=>true));
$grid->setSelect('Area', "SELECT DISTINCT AreaName, AreaName AS Area FROM master_area ORDER BY AreaName", false,
true,
true, array(""=>"All"));
$grid->setSelect('CompanyName', "SELECT DISTINCT CompanyName, CompanyName AS CompanyName FROM company ORDER BY CompanyName", false,
true,
true, array(""=>"All"));
$custom = <<<CUSTOM
jQuery("#getselected").click(function(){
var selr = jQuery('#grid').jqGrid('getGridParam','selrow');
if(selr)
{
window.open('http://www.smartouch-cdms.com/order.php?CompanyID='+selr);
}
else alert("No selected row");
return false;
});
CUSTOM;
$grid->setJSCode($custom);
// Enable toolbar searching
$grid->toolbarfilter = true;
$grid->setFilterOptions(array("stringResult"=>true,"searchOnEnter"=>false,"defaultSearch"=>"cn"));
// Enable navigator
$grid->navigator = true;
// disable the delete operation programatically for that table
$grid->del = false;
// we need to write some custom code when we are in delete mode.
// get the grid operation parameter to see if we are in delete mode
// jqGrid sends the "oper" parameter to identify the needed action
$deloper = $_POST['oper'];
// det the company id
$cid = $_POST['CompanyID'];
// if the operation is del and the companyid is set
if($deloper == 'del' && isset($cid) )
{
// the two tables are linked via CompanyID, so let try to delete the records in both tables
try {
jqGridDB::beginTransaction($conn);
$comp = jqGridDB::prepare($conn, "DELETE FROM company WHERE CompanyID= ?", array($cid));
$cont = jqGridDB::prepare($conn,"DELETE FROM contact WHERE CompanyID = ?", array($cid));
jqGridDB::execute($comp);
jqGridDB::execute($cont);
jqGridDB::commit($conn);
} catch(Exception $e) {
jqGridDB::rollBack($conn);
echo $e->getMessage();
}
}
// Enable only deleting
if(isset($_SESSION['login_admin']))
{
$grid->setNavOptions('navigator', array("pdf"=>true, "excel"=>true,"add"=>false,"edit"=>true,"del"=>false,"view"=>true, "search"=>true));
}
else
$grid->setNavOptions('navigator', array("pdf"=>true, "excel"=>true,"add"=>false,"edit"=>false,"del"=>false,"view"=>true, "search"=>true));
// In order to enable the more complex search we should set multipleGroup option
// Also we need show query roo
$grid->setNavOptions('search', array(
"multipleGroup"=>false,
"showQuery"=>true
));
// Set different filename
$grid->exportfile = 'Company.xls';
// Close the dialog after editing
$grid->setNavOptions('edit',array("closeAfterEdit"=>true,"editCaption"=>"Update Company","bSubmit"=>"Update","dataheight"=>"auto"));
$grid->setNavOptions('add',array("closeAfterAdd"=>true,"addCaption"=>"Add New Company","bSubmit"=>"Update","dataheight"=>"auto"));
$grid->setNavOptions('view',array("Caption"=>"View Company","dataheight"=>"auto","width"=>"1100"));
ob_end_clean(); //solve TCPDF error
// Enjoy
$grid->renderGrid('#grid','#pager',
true, null, null,
true,true);
$conn = null;
?>
javascript code
jQuery(document).ready(function ($) {
jQuery('#grid').jqGrid({
"width": 1300,
"hoverrows":
true,
"viewrecords":
true,
"jsonReader": {
"repeatitems": false,
"subgrid": { "repeatitems": false }
},
"xmlReader": {
"repeatitems": false,
"subgrid": { "repeatitems": false }
},
"gridview":
true,
"url": "session_ma_details.php",
"editurl": "session_ma_details.php",
"cellurl": "session_ma_details.php",
"sortable":
true,
"rownumbers":
true,
"caption": "Group by Maintenance Agreement",
"rowNum": 20,
"height": "auto",
"sortname": "maID",
"rowList": [10, 20, 50],
"footerrow": false,
"userDataOnFooter": false,
"grouping":
true,
"groupingView": {
"groupField": ["CompanyName"],
"groupColumnShow": [false],
"groupText": ["<b> Company Name: {0}</b>"],
"groupDataSorted":
true,
"groupSummary": [true]
}, "onSelectRow": function (rowid, selected) {
if (rowid != null) {
jQuery("#detail").jqGrid('setGridParam', { postData: { CompanyID: rowid } });
jQuery("#detail").trigger("reloadGrid");
// Enable CRUD buttons in navigator when a row is selected
jQuery("#add_detail").removeClass("ui-state-disabled");
jQuery("#edit_detail").removeClass("ui-state-disabled");
jQuery("#del_detail").removeClass("ui-state-disabled");
}
}, "onSortCol": function (rowid, selected) {
// clear the grid data and footer data
jQuery("#detail").jqGrid('clearGridData', true);
// Disable CRUD buttons in navigator when a row is not selected
jQuery("#add_detail").addClass("ui-state-disabled");
jQuery("#edit_detail").addClass("ui-state-disabled");
jQuery("#del_detail").addClass("ui-state-disabled");
}, "onPaging": function (rowid, selected) {
// clear the grid data and footer data
jQuery("#detail").jqGrid('clearGridData', true);
// Disable CRUD buttons in navigator when a row is not selected
jQuery("#add_detail").addClass("ui-state-disabled");
jQuery("#edit_detail").addClass("ui-state-disabled");
jQuery("#del_detail").addClass("ui-state-disabled");
},
"datatype": "json",
"colModel": [
{
"name": "Action", "formatter": "actions", "editable": false, "sortable": false, "resizable": false,
"fixed":
true, "width": 60, "formatoptions": { "keys":
true }, "search": false
},
{
"name": "CompanyID", "index": "CompanyID", "sorttype": "int", "label": "ID", "hidden":
true, "width": 30,
"editable": false, "editoptions": { "readonly": "readonly" }
},
{
"name": "CompanyCode", "index": "CompanyCode", "sorttype": "string", "label": "Company Code",
"hidden":
true, "width": 50, "align": "center", "editable":
true
},
{
"name": "CompanyName", "index": "CompanyName", "sorttype": "string", "label": "Company Name", "hidden":
true,
"editable": false, "width": 150, "align": "center", "fixed":
true, "edittype": "select",
"editoptions": {
"value": "Aquatex Industries:Aquatex Industries;Benithem Sdn Bhd:Benithem Sdn Bhd;Daily Bakery Sdn Bhd:Daily Bakery Sdn Bhd;Eurocor Asia Sdn Bhd:Eurocor Asia Sdn Bhd;Evergrown Technology:Evergrown Technology;Goldpar Precision:Goldpar Precision;MicroSun Technologies Asia:MicroSun Technologies Asia;NCI Industries Sdn Bhd:NCI Industries Sdn Bhd;PHHP Marketing:PHHP Marketing;Smart Touch Technology:Smart Touch Technology;THOSCO Treatech:THOSCO Treatech;YHL Trading (Johor) Sdn Bhd:YHL Trading (Johor) Sdn Bhd;Zenxin Agri-Organic Food:Zenxin Agri-Organic Food",
"separator": ":",
"delimiter": ";"
}, "stype": "select",
"searchoptions": {
"value": ":All;Aquatex Industries:Aquatex Industries;Benithem Sdn Bhd:Benithem Sdn Bhd;Daily Bakery Sdn Bhd:Daily Bakery Sdn Bhd;Eurocor Asia Sdn Bhd:Eurocor Asia Sdn Bhd;Evergrown Technology:Evergrown Technology;Goldpar Precision:Goldpar Precision;MicroSun Technologies Asia:MicroSun Technologies Asia;NCI Industries Sdn Bhd:NCI Industries Sdn Bhd;PHHP Marketing:PHHP Marketing;Smart Touch Technology:Smart Touch Technology;THOSCO Treatech:THOSCO Treatech;YHL Trading (Johor) Sdn Bhd:YHL Trading (Johor) Sdn Bhd;Zenxin Agri-Organic Food:Zenxin Agri-Organic Food",
"separator": ":",
"delimiter": ";"
}
},
{
"name": "Area", "index": "Area", "sorttype": "string", "width": 100, "hidden":
true, "editable": false,
"fixed":
true, "edittype": "select",
"editoptions": {
"value": "Cemerlang:Cemerlang;Danga Bay:Danga Bay;Kulai:Kulai;Larkin:Larkin;Masai:Masai;Nusa Cemerlang:Nusa Cemerlang;Nusajaya:Nusajaya;Pasir Gudang:Pasir Gudang;Pekan Nenas:Pekan Nenas;Permas Jaya:Permas Jaya;Pontian:Pontian;Pulai:Pulai;Senai:Senai;Skudai:Skudai;Taman Gaya:Taman Gaya;Taman Johor Jaya:Taman Johor Jaya;Taman Molek:Taman Molek;Taman Pelangi:Taman Pelangi;Taman Sentosa:Taman Sentosa;Tebrau 4:Tebrau 4;Ulu Tiram:Ulu Tiram",
"separator": ":",
"delimiter": ";"
},
"stype": "select",
"searchoptions": {
"value": ":All;Cemerlang:Cemerlang;Danga Bay:Danga Bay;Kulai:Kulai;Larkin:Larkin;Masai:Masai;Nusa Cemerlang:Nusa Cemerlang;Nusajaya:Nusajaya;Pasir Gudang:Pasir Gudang;Pekan Nenas:Pekan Nenas;Permas Jaya:Permas Jaya;Pontian:Pontian;Pulai:Pulai;Senai:Senai;Skudai:Skudai;Taman Gaya:Taman Gaya;Taman Johor Jaya:Taman Johor Jaya;Taman Molek:Taman Molek;Taman Pelangi:Taman Pelangi;Taman Sentosa:Taman Sentosa;Tebrau 4:Tebrau 4;Ulu Tiram:Ulu Tiram",
"separator": ":",
"delimiter": ";"
}
},
{
"name": "OrderCode", "index": "OrderCode", "sorttype": "string", "label": "Order No.", "width": 110,
"editable": false, "align": "center", "fixed":
true
},
{
"name": "Date", "index": "Date", "sorttype": "date", "label": "Order Date", "width": 100,
"editable": false, "align": "center", "fixed":
true,
"formatter": "date", "formatoptions": { "srcformat": "Y-m-d H:i:s", "newformat": "d M Y" },
"editoptions": {
"dataInit": function(el) {
setTimeout(function() {
if (jQuery.ui) {
if (jQuery.ui.datepicker) {
jQuery(el).datepicker({ "disabled": false, "dateFormat": "dd M yy" });
jQuery('.ui-datepicker').css({ 'font-size': '75%' });
}
}
}, 100);
}
}, "searchoptions": {
"dataInit": function(el) {
setTimeout(function() {
if (jQuery.ui) {
if (jQuery.ui.datepicker) {
jQuery(el).datepicker({ "disabled": false, "dateFormat": "dd M yy" });
jQuery('.ui-datepicker').css({ 'font-size': '75%' });
}
}
}, 100);
}
}
},
{ "name": "maID", "index": "maID", "sorttype": "int", "key":
true, "hidden":
true, "editable":
true },
{
"name": "System", "index": "System", "sorttype": "string", "width": 150, "fixed":
true, "align": "center",
"edittype": "select",
"editoptions": {
"value": "Payroll:Payroll;TMS:TMS;TMS & Payroll:TMS & Payroll",
"separator": ":",
"delimiter": ";"
},
"stype": "select",
"searchoptions": {
"value": ":All;Payroll:Payroll;TMS:TMS;TMS & Payroll:TMS & Payroll",
"separator": ":",
"delimiter": ";"
}, "editable":
true
},
{
"name": "Status", "index": "Status", "sorttype": "string", "width": 70, "align": "center",
"edittype": "select", "editoptions": { "value": "Yes:Yes;No:No" }, "fixed":
true, "editable":
true
},
{
"name": "StartDate", "index": "StartDate", "sorttype": "date", "label": "Start Date",
"width": 120, "align": "center", "fixed":
true,
"formatter": "date", "formatoptions": { "srcformat": "Y-m-d H:i:s", "newformat": "d M Y" },
"editoptions": {
"dataInit": function(el) {
setTimeout(function() {
if (jQuery.ui) {
if (jQuery.ui.datepicker) {
jQuery(el).datepicker({ "disabled": false, "dateFormat": "dd M yy" });
jQuery('.ui-datepicker').css({ 'font-size': '75%' });
}
}
}, 100);
}
},
"searchoptions": {
"dataInit": function(el) {
setTimeout(function() {
if (jQuery.ui) {
if (jQuery.ui.datepicker) {
jQuery(el).datepicker({ "disabled": false, "dateFormat": "dd M yy" });
jQuery('.ui-datepicker').css({ 'font-size': '75%' });
}
}
}, 100);
}
}, "editable":
true
},
{
"name": "EndDate", "index": "EndDate", "sorttype": "date", "label": "End Date", "width": 120,
"align": "center", "fixed":
true,
"formatter": "date", "formatoptions": { "srcformat": "Y-m-d H:i:s", "newformat": "d M Y" },
"editoptions": {
"dataInit": function(el) {
setTimeout(function() {
if (jQuery.ui) {
if (jQuery.ui.datepicker) {
jQuery(el).datepicker({ "disabled": false, "dateFormat": "dd M yy" });
jQuery('.ui-datepicker').css({ 'font-size': '75%' });
}
}
}, 100);
}
}, "searchoptions": {
"dataInit": function(el) {
setTimeout(function() {
if (jQuery.ui) {
if (jQuery.ui.datepicker) {
jQuery(el).datepicker({ "disabled": false, "dateFormat": "dd M yy" });
jQuery('.ui-datepicker').css({ 'font-size': '75%' });
}
}
}, 100);
}
}, "editable":
true
},
{
"name": "
Type", "index": "
Type", "sorttype": "string", "width": 530, "fixed":
true, "edittype": "select",
"editoptions": {
"value": "Comprehensive MA:Comprehensive MA;FOC service, 20% spare part discount:FOC service, 20% spare part discount;Standard Package, FOC 1 time service, 20% spare part discount:Standard Package, FOC 1 time service, 20% spare part discount;Standard Package, FOC 2 time service, 20% spare part discount:Standard Package, FOC 2 time service, 20% spare part discount;Standard Package, FOC 3 time service, 20% spare part discount:Standard Package, FOC 3 time service, 20% spare part discount;Standard Package, FOC 4 time service, 20% spare part discount:Standard Package, FOC 4 time service, 20% spare part discount;Standard Package, FOC 6 time service, 20% spare part discount:Standard Package, FOC 6 time service, 20% spare part discount;Standard Package, no free:Standard Package, no free",
"separator": ":",
"delimiter": ";"
},
"stype": "select",
"searchoptions": {
"value": ":All;Comprehensive MA:Comprehensive MA;FOC service, 20% spare part discount:FOC service, 20% spare part discount;Standard Package, FOC 1 time service, 20% spare part discount:Standard Package, FOC 1 time service, 20% spare part discount;Standard Package, FOC 2 time service, 20% spare part discount:Standard Package, FOC 2 time service, 20% spare part discount;Standard Package, FOC 3 time service, 20% spare part discount:Standard Package, FOC 3 time service, 20% spare part discount;Standard Package, FOC 4 time service, 20% spare part discount:Standard Package, FOC 4 time service, 20% spare part discount;Standard Package, FOC 6 time service, 20% spare part discount:Standard Package, FOC 6 time service, 20% spare part discount;Standard Package, no free:Standard Package, no free",
"separator": ":",
"delimiter": ";"
},
"editable":
true
}
],
"postData": { "oper": "grid" },
"prmNames": { "page": "page", "rows": "rows", "sort": "sidx", "order": "sord", "search": "_search", "nd": "nd", "id": "maID", "filter": "filters", "searchField": "searchField", "searchOper": "searchOper", "searchString": "searchString", "oper": "oper", "query": "grid", "addoper": "add", "editoper": "edit", "deloper": "del", "excel": "excel", "subgrid": "subgrid", "totalrows": "totalrows", "autocomplete": "autocmpl" },
"loadError": function(xhr, status, err) {
try {
jQuery.jgrid.info_dialog(jQuery.jgrid.errors.errcap,
'<div class="ui-state-error">' + xhr.responseText + '</div>',
jQuery.jgrid.edit.bClose,
{ buttonalign: 'right' }
);
} catch(e) {
alert(xhr.responseText);
}
},
"pager": "#pager"
});
jQuery('#grid').jqGrid('navGrid', '#pager',
{ "edit":
true, "add": false, "del": false, "search":
true, "refresh":
true, "view":
true, "excel":
true, "pdf":
true, "csv": false, "columns": false },
{ "drag":
true, "resize":
true, "closeOnEscape":
true, "dataheight": "auto", "errorTextFormat": function (r) { return r.responseText; }, "closeAfterEdit":
true, "editCaption": "Update Company", "bSubmit": "Update" },
{ "drag":
true, "resize":
true, "closeOnEscape":
true, "dataheight": "auto", "errorTextFormat": function (r) { return r.responseText; }, "closeAfterAdd":
true, "addCaption": "Add New Company", "bSubmit": "Update" },
{ "errorTextFormat": function (r) { return r.responseText; } }, { "drag":
true, "closeAfterSearch":
true, "multipleSearch":
true },
{ "drag":
true, "resize":
true, "closeOnEscape":
true, "dataheight": "auto", "Caption": "View Company", "width": "1100" }
);
jQuery('#grid').jqGrid('navButtonAdd', '#pager', {
id: 'pager_excel', caption: '', title: 'Export To Excel', onClickButton: function (e) {
try {
jQuery("#grid").jqGrid('excelExport', { tag: 'excel', url: 'session_ma_details.php' });
} catch (e) {
window.location = 'session_ma_details.php?oper=excel';
}
}, buttonicon: 'ui-icon-newwin'
});
jQuery('#grid').jqGrid('navButtonAdd', '#pager', {
id: 'pager_pdf',
caption: '',
title: 'Export To Pdf',
onClickButton: function (e) {
try {
jQuery("#grid").jqGrid('excelExport', { tag: 'pdf', url: 'session_ma_details.php' });
} catch (e) {
window.location = 'session_ma_details.php?oper=pdf';
}
},
buttonicon: 'ui-icon-print'
});
jQuery('#grid').jqGrid('filterToolbar', { "stringResult":
true, "searchOnEnter": false, "defaultSearch": "cn" });
jQuery("#getselected").click(function () {
var selr = jQuery('#grid').jqGrid('getGridParam', 'selrow');
if (selr) {
window.open('http://www.smartouch-cdms.com/order.php?CompanyID=' + selr);
}
else alert("No selected row");
return false;
});
});
