Make file PDF export example with headers and footers on all pages.
<?php
require_once "SakilaRental.php";
$report = new SakilaRental;
$report->run()->render();
<?php
require_once "SakilaRental.php";
$report = new SakilaRental;
$report->run()
->export('SakilaRentalPdf')
->pdf(array(
"format"=>"A4",
"orientation"=>"portrait",
//"zoom"=>2
))
->toBrowser("sakila_rental.pdf");
<?php
require_once "../../../load.koolreport.php";
use \koolreport\KoolReport;
use \koolreport\processes\Filter;
use \koolreport\processes\TimeBucket;
use \koolreport\processes\Group;
use \koolreport\processes\Limit;
class SakilaRental extends KoolReport
{
use \koolreport\export\Exportable;
public function settings()
{
return array(
"dataSources"=>array(
"sakila_rental"=>array(
"class"=>'\koolreport\datasources\CSVDataSource',
'filePath'=>dirname(__FILE__)."/sakila_rental.csv",
)
)
);
}
protected function setup()
{
$this->src('sakila_rental')
->pipe(new TimeBucket(array(
"payment_date"=>"month"
)))
->pipe(new Group(array(
"by"=>"payment_date",
"sum"=>"amount"
)))
->pipe($this->dataStore('sale_by_month'));
}
}
<?php
use \koolreport\widgets\koolphp\Table;
use \koolreport\widgets\google\ColumnChart;
?>
<div class="report-content">
<div class="text-center">
<h1>Cash In Report</h1>
<p class="lead">This example shows how to set PDF's header and footer</p>
<a href="export.php" class="btn btn-primary">Download PDF</a>
</div>
<hr />
<?php
ColumnChart::create(array(
"dataStore" => $this->dataStore('sale_by_month'),
"columns" => array(
"payment_date" => array(
"label" => "Month",
"type" => "datetime",
"format" => "Y-n",
"displayFormat" => "F, Y",
),
"amount" => array(
"label" => "Amount",
"type" => "number",
"prefix" => "$",
)
),
"width" => "100%",
));
?>
<?php
Table::create(array(
"dataStore" => $this->dataStore('sale_by_month'),
"columns" => array(
"payment_date" => array(
"label" => "Month",
"type" => "datetime",
"format" => "Y-n",
"displayFormat" => "F, Y",
),
"amount" => array(
"label" => "Amount",
"type" => "number",
"prefix" => "$",
)
),
"cssClass" => array(
"table" => "table table-hover table-bordered"
)
));
?>
</div>
<?php
use \koolreport\widgets\koolphp\Table;
use \koolreport\widgets\google\ColumnChart;
?>
<html>
<body style="margin:0.5in 1in 0.5in 1in">
<link rel="stylesheet" href="../../../assets/bs3/bootstrap.min.css" />
<link rel="stylesheet" href="../../../assets/bs3/bootstrap-theme.min.css" />
<div class="page-header" style="text-align:right"><i>Sakila Rental Report</i></div>
<div class="page-footer" style="text-align:right">{pageNum}</div>
<div class="text-center">
<h1>Cash In Report</h1>
<h4>This report show the cash-in report per month</h4>
</div>
<hr/>
<?php
ColumnChart::create(array(
"dataStore"=>$this->dataStore('sale_by_month'),
"columns"=>array(
"payment_date"=>array(
"label"=>"Month",
"type"=>"datetime",
"format"=>"Y-n",
"displayFormat"=>"F, Y",
),
"amount"=>array(
"label"=>"Amount",
"type"=>"number",
"prefix"=>"$",
)
),
"width"=>"100%",
));
?>
<div class="page-break"></div>
<?php
Table::create(array(
"dataStore"=>$this->dataStore('sale_by_month'),
"columns"=>array(
"payment_date"=>array(
"label"=>"Month",
"type"=>"datetime",
"format"=>"Y-n",
"displayFormat"=>"F, Y",
),
"amount"=>array(
"label"=>"Amount",
"type"=>"number",
"prefix"=>"$",
)
),
"cssClass"=>array(
"table"=>"table table-hover table-bordered"
)
));
?>
</body>
</html>
