KoolGrid support data grouping feature. To enable this feature, you simply set AllowGrouping property to true. You can set this property in KoolGrid's instance, GridTableView's instance or in Column's instance.
- If you set the property in KoolGrid's instance, all columns in grid will enable grouping feature.
- If you set the property in GridTableView's instance, only columns in that table will enable grouping feature.
- If you set the property in Column's instance, only that column will enable grouping feature.
KoolGrid also has the GroupPanel which user can drag and drop the column header into in order to group. To show the group panel, you set ShowGroupPanel property of GridTableView to true
<?php
require $KoolControlsFolder."/KoolAjax/koolajax.php";
$koolajax->scriptFolder = $KoolControlsFolder."/KoolAjax";
require $KoolControlsFolder."/KoolGrid/koolgrid.php";
require $KoolControlsFolder."/KoolGrid/ext/datasources/MySQLiDataSource.php";
$ds = new MySQLiDataSource($db_con);//This $db_con link has been created inside KoolPHPSuite/Resources/runexample.php
$ds->SelectCommand = "select CONCAT(employees.firstName,' ',employees.lastName) as employee_name,addressLine1,CONCAT(reportsTo_employees.firstName,' ',reportsTo_employees.lastName) as supervisor_name,employees.jobTitle from employees,offices,employees as reportsTo_employees where reportsTo_employees.employeeNumber=employees.reportsTo and employees.officeCode=offices.officeCode";
$grid = new KoolGrid("grid");
$grid->scriptFolder = $KoolControlsFolder."/KoolGrid";
$grid->styleFolder="outlook";
$grid->DataSource = $ds;
$grid->Width = "655px";
$grid->DataSource = $ds;
$grid->AjaxEnabled = true;
$grid->AjaxLoadingImage = $KoolControlsFolder."/KoolAjax/loading/2.gif";
$column = new GridBoundColumn();
$column->DataField = "employee_name";
$column->HeaderText = "Name";
$grid->MasterTable->AddColumn($column);
$column = new GridBoundColumn();
$column->DataField = "jobTitle";
$column->HeaderText = "Title";
$grid->MasterTable->AddColumn($column);
$column = new GridBoundColumn();
$column->DataField = "supervisor_name";
$column->HeaderText = "Supervisor";
$grid->MasterTable->AddColumn($column);
$column = new GridBoundColumn();
$column->DataField = "addressLine1";
$column->HeaderText = "Office Address";
$grid->MasterTable->AddColumn($column);
$grid->MasterTable->Pager = new GridPrevNextAndNumericPager();
$grid->AllowGrouping = true; //Allow Grouping
$grid->MasterTable->ShowGroupPanel = true; //Show Group Panel
$grid->Process();
?>
<form id="form1" method="post">
<?php echo $koolajax->Render();?>
<?php echo $grid->Render();?>
</form>
KoolGrid - Powerful PHP GridFullVersion 5.7.0.0 released on 25/11/2016