CSV Exportable

<?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'));

        if (isset($this->params['export'])) {
            $multiply = isset($_GET["multiply"]) ? $_GET['multiply'] : 1;
            for ($i = 0; $i < $multiply; $i++) {
                $node->pipe($this->dataStore('ordersExport'));
            }
        }
    }
}

<?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 Exportable</h1>
        <p class="lead">How to export datastores to CSV files</p>
		<form method="post">
			<button type="submit" class="btn btn-primary" formaction="export.php">Export to CSV</button>
			<button type="submit" class="btn btn-primary" formaction="export.php?multiply=10">Large CSV (30 thousand rows)</button>
			<button type="submit" class="btn btn-primary" formaction="export.php?multiply=100">Huge CSV (300 thousand rows)</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"
				),
				"paging"=>array(
					"pageSize"=>5
				)
			));
			?>
		</div>
	</div>
</div>

<?php
include "MyReport.php";
$report = new MyReport([
    "export" => true,
]);
$report->run();
$report->exportToCSV(
    array(
        "dataStores" => array(
            "ordersExport" => [
                "separator" => ",", // default separator = "," i.e. comma
                "enclosure" => "\"", // default general enclosure = "" i.e. empty string
                "enclosure" => ["(", ")"], // all enclosure property could be a 2 element array
                "typeEnclosures" => [
                    "string" => "\"", // default string enclosure is general enclosure
                    "date" => "\"", // default date enclosure is general enclosure
                    "datetime" => "\"", // default datetime enclosure is general enclosure
                    "number" => "", // default number enclosure = "" i.e. empty string
                    "boolean" => "", // default boolean enclosure = "" i.e. empty string
                ],
                'nullEnclosure' => "", // default = "" i.e empty string
                'nullString' => "NULL", // default = false i.e empty string for null value
                'useColumnFormat' => 1, // default = 1, set = 0 to increase export speed
                'useEnclosureEscape' => 1, // default = 1, set = 0 to increase export speed
                'useTypeEnclosure' => 1, // default = 1, set = 0 to increase export speed     
                "escape" => "\\", // if escape is empty/undefined, double enclosures will be used
                "eol" => "\n", // define End of line character, default eol is "\n"
                "columns" => array(
                    "customerName",
                    "productName",
                    "productLine",
                    "orderDate",
                    "orderMonth",
                    "orderYear",
                    "orderQuarter",
                    "dollar_sales" => [
                        "type" => "number",
                        "enclosure" => ["<", ">"], // to apply custom column enclosure "useCustomColumnEnclosure" must be true
                        "headerEnclosure" => "\"",
                        "nullEnclosure" => "",
                        "nullString" => "nULL",
                        "enclosureEscape" => "\"",
                    ]
                ),
                'useCustomColumnEnclosure' => 0, // default = 0
                'useCustomColumnNullString' => 0, // default = 0
                'useCustomColumnEnclosureEscape' => 0, // default = 0             
            ],
        ),

        // General options for all datastores
        "useLocalTempFolder" => true,
        "autoDeleteTempFile" => true,
        "BOM" => true, // default bom = false
        "buffer" => 1000, // unit: KB ~ 1000 bytes. Default buffer = 1000 KB
        // "buffer" => PHP_INT_MAX,        
    ),
)
    ->toBrowser("orders.csv");