//$dg -> enable_search(true);
//
//$dg->ud_params = 'recreateFilter:true,';
//$dg->enable_advanced_search(true);
//
//$dg->cust_prop_jsonstr = 'postData: {filters:
// \'{"groupOp":"AND","rules":[{"field":"status","op":"eq","data":"Open"}]}\'},';
//$dg->set_grid_property(array('search'=>true));
//$dg -> display();
?>
<?php
$dg = new C_DataGrid("select * from employees", array("employeeNumber", "lastName"), "employees");
$dg->enable_edit("FORM", "CRU");
//$dg -> set_col_hidden('employeeNumber',true);
$dg->enable_kb_nav(true);
/*
* $dg -> set_col_edittype("isActive", "checkbox","1:0");
//$dg -> set_col_edittype("officeCode", "select", "1:San Francisco;2:Boston;3:NYC;4:Paris;5:Tokyo;6:Sydney;7:London");
$dg -> set_col_edittype("officeCode", "select", "Select officeCode,city from offices",false);
$dg -> set_col_edittype("reportsTo", "select", "Select employeeNumber, lastName from employees",false);
$dg -> set_row_color('lightyellow', 'yellow', '#F1F7F9');
$dg->enable_search(true);
$dg->enable_advanced_search(true);
//$dg->set_selectnetsted('officeCode', 'reportsTo');
$dg->enable_columnchooser();
*/
$dg->enable_debug(true);
<?php
require_once "../conf.php";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>PHP Datagrid - Locale Setting</title>
</head>
<body>
<?php
$dg = new C_DataGrid("SELECT * FROM orders", "orderNumber", "orders");
$dg->set_locale('fr');
$dg->enable_edit('FORM');
//$dg->set_col_format('orderDate', 'date', array('srcformat'=>'Y-m-d','newformat'=>'d/m/Y'));
$dg->display();
?>
</body>
</html>
<script type="text/javascript">
function ShowSelectedRows(){
var rows = getSelRows();
alert(rows);
}
</script>
</head>
<body>
<?php
$dg = new C_DataGrid("SELECT * FROM orders", "orderNumber", "orders");
// change column titles
$dg->set_col_title("orderNumber", "Order No.");
$dg->set_col_title("orderDate", "Order Date");
$dg->set_col_title("shippedDate", "Shipped Date");
$dg->set_col_title("customerNumber", "Customer No.");
// hide a column
$dg->set_col_hidden("requiredDate");
// enable edit
$dg->enable_edit("INLINE", "CRUD");
// read only columns, one or more columns delimited by comma
$dg->set_col_readonly("orderDate, customerNumber");
// required fields
$dg->set_col_required("orderNumber, customerNumber");
// multiple select
$dg->set_multiselect(true);
$dg->display();
?>
<input type="button" id="bSelRow" value="Get Selected Rows" onclick="ShowSelectedRows()">
</body>
</html>
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>A Basic PHP Datagrid</title>
</head>
<body>
<table>
<tr><td>
<?php
$dg = new C_DataGrid("SELECT * FROM orders", "orderNumber", "orders");
$dg->enable_edit();
$dg->display();
?>
</td>
<td>
<?php
$dg2 = new C_DataGrid("SELECT * FROM orders", "orderNumber", "orders");
$dg2->set_jq_gridName('order2');
$dg2->set_caption("order 2");
$dg2->enable_edit();
$dg2->display();
?>
</td></tr>
</table>
</body>
</html>
console.log(status);
console.log(rowid);
var ids = jQuery("#orders").jqGrid('getDataIDs');
for (var i = 0; i < ids.length; i++)
{
var rowId = ids[i];
var rowData = jQuery('#orders').jqGrid ('getRowData', rowId);
console.log(rowData);
console.log(rowId);
if(\$("#orders").jqGrid("getCell", rowId, "status") == "Shipped"){
\$("#orders").jqGrid("setCell", rowId, "actions", " zzz ", {"display":"none"}); // not possible to set value for virtual column
}
}
}
ONGRIDLOADCOMPLETE;
$dg = new C_DataGrid("SELECT * FROM orders", "orderNumber", "orders");
$dg->set_col_hidden('comments');
$dg->add_column("actions", array('name' => 'actions', 'index' => 'actions', 'width' => '80', 'formatter' => 'actions', 'formatoptions' => array('keys' => true)), 'Actions');
$dg->set_grid_property(array('onSelectRow' => ''));
$dg->add_event("jqGridLoadComplete", $onGridLoadComplete);
$dg->enable_edit('INLINE', 'CRUD');
$dg->display();
?>
</body>
</html>
<?php
require_once "../conf.php";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>phpGrid Virtual Column (Calculated Column)</title>
</head>
<body>
<?php
$dg = new C_DataGrid("SELECT * FROM orders", "orderNumber", "orders");
$dg->enable_edit('INLINE');
// creating a virtual column
$col_formatter = <<<COLFORMATTER
function(cellvalue, options, rowObject){
\tvar n1 = parseInt(rowObject[0],10),
\t\tn2 = parseInt(rowObject[6],10);
\treturn n1+n2;
}
COLFORMATTER;
$dg->add_column('total', array('name' => 'total', 'index' => 'total', 'width' => '360', 'align' => 'right', 'formatter' => $col_formatter), 'Total (Virtual)');
$dg->display();
?>
Virtual Column
<ul>
<li>The col_name cannot contain space and must begin with a letter
<li>Use "formatter" column property to hook up javascript function
require_once "../conf.php";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Multiple Datagrids</title>
</head>
<body>
<?php
$dg = new C_DataGrid("SELECT * FROM orders", "orderNumber", 'orders');
$dg->enable_edit("FORM", "CRUD");
$dg->display();
$dg2 = new C_DataGrid("select * from employees", "employeeNumber", "employees");
$dg2->enable_edit("FORM", "CRUD");
$dg2->display();
$dg3 = new C_DataGrid("select * from offices", "officeCode", "offices");
$dg3->enable_edit("FORM", "CRUD");
$dg3->display();
$dg4 = new C_DataGrid("select * from productlines", "productLine", "productlines");
$dg4->enable_edit("FORM", "CRUD");
$dg4->display();
$dg5 = new C_DataGrid("select * from customers", "customerNumber", "customers");
$dg5->enable_edit("FORM", "CRUD");
$dg5->display();
?>
</body>
</html>
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Integrated Search</title>
</head>
<body>
<?php
$dg = new C_DataGrid("SELECT * FROM orders", "orderNumber", "orders");
// change column titles
$dg->set_col_title("orderNumber", "Order No.");
$dg->set_col_title("orderDate", "Order Date");
$dg->set_col_title("shippedDate", "Shipped Date");
$dg->set_col_title("customerNumber", "Customer No.");
// hide a column
$dg->set_col_hidden("requiredDate");
// change default caption
$dg->set_caption("Orders List");
// set export type
$dg->enable_export('EXCEL');
// enable integrated search
$dg->enable_search(true);
$dg->enable_edit('FORM', 'CRUD');
$dg->set_col_edittype('status', 'select', 'Open:Open;Shipped:Shipped;Cancelled:Cancelled;Disputed:Disputed;On Hold:On Hold');
$dg->set_col_readonly("orderNumber");
$dg->enable_kb_nav(true);
$dg->display();
?>
</body>
</html>
