• Introduction
• Sample Code
  • Group by single column
  • Group by multiple columns
• Properties

Group

Introduction #

Group process acts like the GROUP BY statement in SQL Query.

Sample Code #

Group by single column #

<?php
<?php
use \koolreport\processes\Group;
class MyReport extends \koolreport\KoolReport
{
    public function setup()
    {
        ...
        ->pipe(new Group(array(
            "by"=>"country",
            "sum"=>"polulation"
        )))
        ...
    }
}

Group by multiple columns #

<?php
<?php
use \koolreport\processes\Group;
class MyReport extends \koolreport\KoolReport
{
    public function setup()
    {
        ...
        ->pipe(new Group(array(
            "by"=>array("country","state"),
            "sum"=>array("polulation","income")
        )))
        ...
    }
}

Properties #