Im having a problem with google reports, im trying to make a linechart report but its only appears a white page!!!
cam you help me?? thanks in advance!
<<index.php>>
<?php
require_once "EmployeeList.php";
$report = new EmployeeList;
$report->run()->render();
?>
<<EmployeeList.view.php>>
<?php
use \koolreport\widgets\google\LineChart;
?>
<?php
LineChart::create(array(
"dataStore"=>$this->dataStore("Claro"),
"columns"=>array(
"REF"=>array(
"label"=>"REF",
"type"=>"text"
),
"P3G"=>array(
"label"=>"P3G",
"type"=>"number",
"prefix"=>"$"
)
),
"options"=>array(
"title"=>"Sale Performance"
)
));
?>
<<EmployeeList.php>>
<?php
require_once "C:/wamp/www/Garajes/koolreport/autoload.php";
class EmployeeList extends \koolreport\KoolReport
{
function settings()
{
return array(
"dataSources"=>array(
"mydata"=>array(
'connectionString' => 'mysql:host=localhost;dbname=csv_db',
'username' => 'root',
'password' => '',
'charset' => 'utf8',
)
)
);
}
function setup()
{
$this->src("mydata")
->query("SELECT * FROM `garajes_amba_final` WHERE P3G = 'CLARO' " )
->pipe($this->dataStore("Claro"));
}
}