CSV Footer

<?php
require_once "MyReport.php";

$report = new MyReport;
$report->run()->render();

<?php
require_once "../../../load.koolreport.php";

use \koolreport\processes\Map;
use \koolreport\processes\Limit;
use \koolreport\processes\ColumnMeta;
use \koolreport\cube\processes\Cube;
use \koolreport\pivot\processes\Pivot;

class MyReport extends koolreport\KoolReport
{
    use \koolreport\excel\CSVExportable;

    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')
        ->pipe(new ColumnMeta(array(
            "dollar_sales" => [
                "type" => "number"
            ],
            "orderDate" => [
                "type" => "datetime"
            ]
        )));
        
        $node->pipe(new Limit(array(
            50, 0
        )))
        ->pipe($this->dataStore('orders'));
    }
}

<?php
use \koolreport\pivot\widgets\PivotTable;
use \koolreport\widgets\koolphp\Table;
?>
<div class="report-content">
	<div style='text-align: center;margin-bottom:30px;'>
        <h1>CSV Footer</h1>
        <p class="lead">How to use footers and aggregates when exporting to CSV</p>
		<form method="post">
			<button type="submit" class="btn btn-primary" formaction="export.php">Export to CSV</button>
		</form>
	</div>
	<div class='box-container'>
		<div>
			<?php
			Table::create(array(
				"dataSource" => $this->dataStore('orders'),
				"columns"=>array(
					"customerName",
					"productName",
					"productLine",
					// "orderDate",
					// "orderMonth",
					// "orderYear",
					// "orderQuarter",
					"dollar_sales" => [
						"footer" => "sum",
						"footerText" => "Total: @value"
					]
				),
				"showFooter" => true,
				"paging"=>array(
					"pageSize"=>5
				)
			));
			?>
		</div>
	</div>
</div>

<?php
include "MyReport.php";
$report = new MyReport();
$report->run()->exportToCSV(
    array(
        "dataStores" => array(
            "orders" => [
                "separator" => ";",
                "columns" => array(
                    "customerName",
                    "productName",
                    "productLine",
                    "dollar_sales" => [
                        "footer" => "sum",
                        "footerFormat" => function($value, $colMeta) {
                            return number_format($value, 2);
                        },
                        "footerFormat" => [
                            "decimals" => 2,
                            "thousandSeparator" => ",",
                            "decimalPoint" => "."
                        ],
                        "footerText" => "Total: @value || Count: @countSales || Avg: @avgSales",
                    ]
                ),
                "aggregates" => [
                    "countSales" => [
                        "count", 
                        "dollar_sales",
                        "format" => function($value, $colMeta) {
                            return number_format($value, 0, ".", ",");
                        }
                    ],
                    "avgSales" => [
                        "operator" => "avg", 
                        "field" => "dollar_sales",
                        "format" => [
                            "decimals" => 2,
                            "thousandSeparator" => ",",
                            "decimalPoint" => "."
                        ]
                    ],
                ],
            ],
        ),
    ),
)
    ->toBrowser("orders.csv");