PDF Extract

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

<?php
require_once "SalesPivotExtract.php";
$report = new SalesPivotExtract();

$report->run()
->export("SalesPivotExtractPdf")
->pdf(
  array(
    // "format"=>"A4",
    // "orientation"=>"landscape",
    "width" => '29cm',
    "height" => '21cm',
    "margin" => '2cm'
  )
)
->toBrowser("SalesPivotExtract.pdf");

<?php
require_once "SalesPivotExtract.php";
$report = new SalesPivotExtract();

$report->run()
->exportToExcel(array(
  "dataStores" => array(
    'sales' => array(
      'rowSort' => array(
        'dollar_sales - count' => 'desc',
      ),
      'headerMap' => function($v, $f) {
        if ($v === 'dollar_sales - sum')
          $v = 'Sales (in USD)';
        if ($v === 'dollar_sales - count')
          $v = 'Number of Sales';
        if ($f === 'orderYear')
          $v = 'Year ' . $v;
        return $v;
      },
    )
  ),
))
->toBrowser("SalesPivotExtract.xlsx");

<?php
// error_reporting(E_ALL);
require_once "../../../load.koolreport.php";
use \koolreport\processes\Filter;
use \koolreport\processes\ColumnMeta;
use \koolreport\processes\ValueMap;
use \koolreport\pivot\processes\Pivot;
use \koolreport\pivot\PivotExcelExport;
use \koolreport\pivot\processes\PivotExtract;

class SalesPivotExtract extends koolreport\KoolReport
{
    use \koolreport\excel\ExcelExportable;
    use \koolreport\export\Exportable;
  
    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",
                "row"=>"customerName, productLine, productName"
            ),
            "aggregates"=>array(
                "sum"=>"dollar_sales",
                "count"=>"dollar_sales"
            )
        )))->saveTo($node2);
        $node2->pipe($this->dataStore('sales')); 

        $node2->pipe(new PivotExtract(array(
            "row" => array(
                "parent" => array(),
            ),
            "column" => array(
                "parent" => array(
                ),
            ),
            "measures"=>array(
                "dollar_sales - sum", 
            ),
        )))
        ->pipe($this->dataStore('salesTable1'));

        $node2->pipe(new PivotExtract(array(
            "row" => array(
                "parent" => array(
                    "customerName" => "AV Stores, Co."
                ),
                "sort" => array(
                    'dollar_sales - sum' => 'desc',
                ),
            ),
            "column" => array(
                "parent" => array(
                    "orderYear" => "2004"
                ),
                "sort" => array(
                    'orderMonth' => function($a, $b) {
                        return (int)$a < (int)$b;
                    },
                ),
            ),
            "measures"=>array(
                "dollar_sales - sum", 
                "dollar_sales - count", 
            ),
        )))
        ->pipe($this->dataStore('salesTable2'));
    }
}

<?php
    use \koolreport\widgets\koolphp\Table;
    use \koolreport\pivot\widgets\PivotTable;
?>
<div class="report-content">
  
  <div class="text-center">
    <h1>PDF Extract</h1>
    <p class="lead">
      The example shows how we can extract a table from multi-level tables of pivot.
      <br/>
      The extracted table can be used to draw chart or any other purposes.
    </p>
    <div class="form-group">
      <a href="export.php" class="btn btn-primary">Download PDF</a>
      <a href="exportExcel.php" class="btn btn-primary">Download Excel</a>
    </div>
  </div>

    <h3>Original Pivot Table</h3>  
    <?php 
        PivotTable::create(array(
            "dataStore"=>$this->dataStore('sales'),
            'rowCollapseLevels' => array(0),
            'columnCollapseLevels' => array(0),
        ));
    ?>

    <h3>Extracted Table 1</h3>
    <?php
        Table::create(array(
            "dataStore"=>$this->dataStore('salesTable1'),
        ));
    ?>

    <h3>Extracted Table 2</h3>
    <?php
        Table::create(array(
            "dataStore"=>$this->dataStore('salesTable2'),
        ));
    ?>
  
</div>