$(window).resize(function()
{
$('#eidgrid').fluidGrid({base:'#ui-dialog-title-eid_dialog', offset:-25});
});
CUSTOM;
$grid->setJSCode($custom);
$oper = jqGridUtils::GetParam("oper");
if($oper == "pdf") {
$grid->setPdfOptions(array(
"header"=>true,
"margin_top"=>25,
"page_orientation"=>"P",
"header_logo"=>"../../../../../images/Logo_450x123_24bit_color.jpg",
// set logo image width
"header_logo_width"=>45,
//header title
"header_title"=>" Snare/Windows Event ID Report"
));
}
// Enjoy
$summaryrows=array("Seen"=>array("Seen"=>"SUM"));
$grid->renderGrid('#eidgrid','#eidpager',true, $summaryrows, null, true,true);
$conn = null;
?>
\$("#mne_dialog").ready(function(){
// Some magic to set the proper width of the grid inside a Modal window
var modalWidth = \$("#mne_dialog").width();
var modalHeight = \$("#mne_dialog").height() - 52;
\$('#mnegrid').jqGrid('setGridWidth',modalWidth);
\$('#mnegrid').jqGrid('setGridHeight',modalHeight);
\$('#mnegrid').fluidGrid({base:'#mne_dialog', offset:-25});
});
//---------------------------------------------------------------
// END: Mnemonic Select Dialog
//---------------------------------------------------------------
});
\$(window).resize(function()
{
\$('#mnegrid').fluidGrid({base:'#ui-dialog-title-mne_dialog', offset:-25});
});
CUSTOM;
$grid->setJSCode($custom);
$oper = jqGridUtils::GetParam("oper");
if ($oper == "pdf") {
$grid->setPdfOptions(array("header" => true, "margin_top" => 25, "page_orientation" => "P", "header_logo" => "../../../../../images/Logo_450x123_24bit_color.jpg", "header_logo_width" => 45, "header_title" => " Mnemonics Report"));
}
// Enjoy
$summaryrows = array("Seen" => array("Seen" => "SUM"));
$grid->renderGrid('#mnegrid', '#mnepager', true, $summaryrows, null, true, true);
$conn = null;
$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;
// 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 summary rows"));
// 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
$grid->setNavOptions('navigator', array("pdf" => true, "add" => false, "edit" => false, "del" => false, "view" => false, "excel" => false));
// Set summary field
$summaryrows = array("Freight" => array("Freight" => "SUM"));
$oper = jqGridUtils::GetParam("oper");
if ($oper == "pdf") {
$grid->setPdfOptions(array("header" => true, "margin_top" => 27, "page_orientation" => "P", "header_logo" => "logo.gif", "header_logo_width" => 30, "header_title" => "jqGrid pdf table"));
}
// Enjoy
$grid->renderGrid('#grid', '#pager', true, $summaryrows, null, true, true);
$conn = null;
