phpGrid 4.2 Archives | phpGrid - PHP Datagrid

Nested Master Detail Datagrid *

Mon, 21 Feb 2011 00:02:13 +0000

* Please note this feature is only available in Premium and higher editions.

The master detail datagrid can be nested to show relationships for multilevel hierarchal data. The example shows only three levels, though the number of nested levels can be unlimited.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

// Always include namespace and conf.php on TOP of the script.
use phpCtrl\C_DataGrid;
require_once("/file/path/to/conf.php");

//suppliers master-detail
$sg = new C_DataGrid("SELECT * FROM suppliers","supplierCode","suppliers");
$sg -> set_sql_key("supplierName");

//supplier detail2: products
$sg_d1 = new C_DataGrid("SELECT productCode,productName,productDescription,quantityInStock,MSRP,productVendor FROM products","productCode","products");

//nested grid-level 3 for products
$sg_d1_n1 = new C_DataGrid("SELECT * FROM productparts","productCode","productparts");

//set detail for products
$sg_d1 -> set_masterdetail($sg_d1_n1, 'productCode');

//set detail 2 for suppliers
$sg -> set_masterdetail($sg_d1, 'productVendor');

$sg -> display();

Note:
In the demo, click on #3 in suppliers grid first.

See Live Example! (In the demo, click on #3 in suppliers grid)

The post Nested Master Detail Datagrid * appeared first on phpGrid - PHP Datagrid.

Master with Multiple Detail Grids *

Fri, 11 Feb 2011 01:54:06 +0000

* Please note this feature is only available in paid versions.

phpGrid supports a master grid with multiple detail grids. There is no limit on how many detail grids a master datagrid can have. Detail grids are defined the way as the master datagrid does. Click on example link to see it in action!

Note that you can have master and detail grids from the same database table as long as different SQL alias are used.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

// Always include namespace and conf.php on TOP of the script.
use phpCtrl\C_DataGrid;
require_once("/file/path/to/conf.php");

//suppliers master-detail
$sg = new C_DataGrid("SELECT * FROM suppliers","supplierCode","suppliers");
$sg->set_sql_key("supplierName");

//supplier detail 1: product lines
$sg_d1 = new C_DataGrid("SELECT * FROM supplierproductlines","supplierCode","supplierproductlines");

$sg->set_masterdetail($sg_d1, 'supplierName');

//supplier detail2: products
$sg_d2 = new C_DataGrid("SELECT productCode,productName,productDescription,quantityInStock,MSRP,productVendor FROM products","productCode","products");

//set detail 2 for suppliers
$sg->set_masterdetail($sg_d2, 'productVendor');
$sg->display();

See Live Example!

The post Master with Multiple Detail Grids * appeared first on phpGrid - PHP Datagrid.

Column Grouping with Summary *

Thu, 10 Feb 2011 02:11:02 +0000

* Please note this feature is only available in paid versions.

phpGrid can group data by columns. Simply define a column name on which grouping occur using method set_group_properties().

In addition to define grouping column, set summary field using method set_group_summary() by passing the column name and summary type, which can be sum, count, avg, min, or max.

1
2
3
4
5
6
7
8
9
10

use phpCtrl\C_DataGrid;
require_once("/file/path/to/conf.php");

$dg = new C_DataGrid("SELECT * FROM payments", "customerNumber", "payments");

$dg->set_group_properties('customerNumber');
$dg->set_group_summary('amount','sum');
$dg->set_group_summary('checkNumber','count');

$dg -> display();

See Live Example!

The post Column Grouping with Summary * appeared first on phpGrid - PHP Datagrid.

enable_rownumbers()

Sun, 06 Feb 2011 03:20:27 +0000

Parameters:
- $has_rownumbers: boolean value indicating whether row number is displayed.
Description:
- Display row number before each row.
Example:

1	$dg -> enable_rownumbers(true);

The post enable_rownumbers() appeared first on phpGrid - PHP Datagrid.

set_group_summary() *

Sun, 06 Feb 2011 03:18:32 +0000

* Please note this feature is only available in paid versions.

Parameters:
- $column_name: column name for grouping
- $summaryType: summary type. It can be one of the types below
  - sum
  - count
  - avg
  - min
  - max
Description:
- Display group summary of a specific summary type, such as sum or max, in the group summary footer.
Remark:
- This method must be used together with set_group_properties() method.
Example:

1
2
3

$dg -> set_group_properties('customerNumber');
$dg -> set_group_summary('amount','sum');
$dg -> set_group_summary('checkNumber','count');

The post set_group_summary() * appeared first on phpGrid - PHP Datagrid.

set_group_properties() *

Sun, 06 Feb 2011 03:13:48 +0000

* Please note this feature is only available in paid versions.

Parameters:
- $column_name: column name for grouping
- $groupCollapsed: boolean value indicating whether to expand or collapse grouping when displayed. The default is false.
- $showSummaryOnHide: boolean value to whether display group summary when grouping is collapsed. The default is true.
- $groupColumnShow: boolean value to display group column. Default is false.
- $hideGroup: boolean. Hide grouped rows. Default is false. (v7.1+)
Description:
- Group grid values simply by specifying a column name.
Remark:
- Single level grouping is currently supported.
- When grouping is enabled, the followings methods are disabled:
  - enable_rownumbers();
  - set_subgrid();
Example:

1	$dg -> set_group_properties('customerNumber');

The post set_group_properties() * appeared first on phpGrid - PHP Datagrid.

set_col_width()

Sun, 06 Feb 2011 03:07:00 +0000

Starting version 6.6, phpGrid will automatically resize column width based on its content during page load. Users can also double-click a column divider to resize a column.

Parameters:
- $col_name: column name
- $width: width
Description:
- Specify column width in pixel. The width should be an integer value.
Example:

1	$dg -> set_col_width("comments", 500);

The post set_col_width() appeared first on phpGrid - PHP Datagrid.

set_query_filter($WHERE)

Tue, 14 Sep 2010 07:48:22 +0000

Parameters:
- $WHERE: Sql WHERE statement to select data conditionally (DO NOT include WHERE keyword).
Description:
- The query filter is essentially the WHERE clause without the WHERE. The method adds WHERE condition an existing Sql SELECT statement. Use this method if you have WHERE clause in your SQL statement. You should use the same SQL syntax, such as single quotes around non-numeric values, and even SQL functions.
Remark:
- NEVER include keyword “WHERE” the filter. phpGrid automatically adds WHERE to the query.
- Use only SINGLE QUOTE around the filtered value.
- When using table alias, also include the new table alias
Example:

1	$dg -> set_query_filter("status='Shipped' AND YEAR(shippedDate) = 2003");

Using Table Alias

When using table alias, please also include the table alias as part of the filter. Otherwise, the full table name is automatically inserted as part of the query which would throw “Unknown column in ‘where clause” error.

Example

1	$dg -> set_query_filter("T.mycolumn = 'foo' ");

The post set_query_filter($WHERE) appeared first on phpGrid - PHP Datagrid.