KoolGrid - Powerful PHP GridFullVersion 5.7.0.0 released on 25/11/2016

With KoolGrid, you can define your own grouping in coding. Basically, you need to create GridGroup's object and add it to the GridTableView that you want to show the group.

You can:

• - Group by any available fields from SelectCommand.
• - Customize the header text of the group.
• - Customize the summary information of each groups.
• - Show group aggregate information.

You may have a look at our example for more details.

<?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="sunset";
	$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";
 
	//Set group to true so that koolgrid will group by this column initially.	
	$column->Group = true;
	$column->GroupSettings->InfoTemplate = "Reports To: {supervisor_name}";
	$column->GroupSettings->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>

• • GridGroup::AddInfoField()
• • GridGroup::GroupField
• • GridGroup::InfoTemplate
• • GridGroup::Expand
• • GridGroup::Sort
• • GridTableView::AddGroup()