Sale Report

<?php
require_once "YearsMonths.php";
$YearsMonths = new YearsMonths;
$YearsMonths->run()->render();
?>    

<?php
require_once "../../../load.koolreport.php";
use \koolreport\processes\Filter;
use \koolreport\processes\ColumnMeta;
use \koolreport\pivot\processes\Pivot;

class YearsMonths extends koolreport\KoolReport
{
    function settings()
    {
        return array(
            "dataSources" => array(
                "dollarsales"=>array(
                    'filePath' => '../../../databases/customer_product_dollarsales2.csv',
                    'fieldSeparator' => ';',
                    'class' => "\koolreport\datasources\CSVDataSource"      
                ), 
            )
        );
    }
    function setup()
    {
        $node = $this->src('dollarsales');
        
        $node->pipe(new Filter(array(
            array('customerName', '<', 'Am'),
            array('orderYear', '>', 2003)
        )))
        ->pipe(new ColumnMeta(array(
            "dollar_sales"=>array(
                'type' => 'number',
                "prefix" => "$",
            ),
        )))
        ->pipe(new Pivot(array(
            "dimensions"=>array(
                "column"=>"orderYear, orderMonth",
            ),
            "aggregates"=>array(
                "sum"=>"dollar_sales",
                "count"=>"dollar_sales"
            )
        )))
        ->pipe($this->dataStore('sales'));  
    }
}

<?php
use \koolreport\pivot\widgets\PivotTable;
?>
<div class="report-content">
  <div class="text-center">
    <h1>Sale Report</h1>
    <p class="lead">
      Aggregate sale amount and sale count by years and months.
    </p>
  </div>
  <?php
    $dataStore = $this->dataStore('sales');
    PivotTable::create(array(
      "dataStore"=>$dataStore,
      "columnDimension"=>"column",
      "measures"=>array(
        "dollar_sales - sum", 
      ),
      'rowSort' => array(
        'dollar_sales - count' => 'desc',
      ),
      'columnSort' => array(
        'orderMonth' => function($a, $b) {
          return (int)$a < (int)$b;
        },
      ),
      'columnCollapseLevels' => array(1),
      'width' => '100%',
      'nameMap' => array(
        'dollar_sales - sum' => 'Sales (in USD)',
        'dollar_sales - count' => 'Number of Sales',
        '1' => 'January',
        '2' => 'February',
        '3' => 'March',
        '4' => 'April',
        '5' => 'May',
        '6' => 'June',
        '7' => 'July',
        '8' => 'August',
        '9' => 'September',
        '10' => 'October',
        '11' => 'November',
        '12' => 'December',
      ),
    ));
  ?>
  
</div>