//$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>