Am trying to design Charts using tool. Getting below error message:

Warning: array_keys() expects parameter 1 to be array, null given in C:\xampp\htdocs\KoolReport\get__start\vendor\koolreport\core\src\widgets\google\Chart.php on line 167

Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\KoolReport\get__start\vendor\koolreport\core\src\widgets\google\Chart.php on line 168

Warning: array_keys() expects parameter 1 to be array, null given in C:\xampp\htdocs\KoolReport\get__start\vendor\koolreport\core\src\widgets\google\Chart.php on line 167

Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\KoolReport\get__start\vendor\koolreport\core\src\widgets\google\Chart.php on line 168 Table has no columns.×

Please can you guide me.

Hello Morales,

Please check the below code.

index.php

<?php
require_once "../vendor/autoload.php";
require_once "SaleReport.php";

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



SaleReport.php

<?php
require_once "../vendor/autoload.php";
use \koolreport\processes\Group;
use \koolreport\processes\Sort;
use \koolreport\processes\Limit;

class SaleReport extends \koolreport\KoolReport
{
    public function settings()
    {
        return array(
            "dataSources"=>array(
                "automaker"=>array(
                    "connectionString"=>"mysql:host=localhost;dbname=automaker",
                    "username"=>"root",
                    "password"=>"",
                    "charset"=>"utf8"
                )
            )
        );
    }

    public function setup()
    {
        $this->src('automaker')
        ->query("SELECT customers.customerName,sum(payments.amount) as SaleAmount
         FROM payments
         JOIN customers ON customers.customerNumber = payments.customerNumber
         GROUP BY customers.customerName 
         LIMIT 10
         ")
        // ->pipe(new Group(array(
        //     "by"=>"customerName",
        //     "sum"=>"dollar_sales"
        // )))
        // ->pipe(new Sort(array(
        //     "dollar_sales"=>"desc"
        // )))
        // ->pipe(new Limit(array(10)))
        ->pipe($this->dataStore('result'));
    }
}

SaleReport.view.php

<?php 
    use \koolreport\clients\Bootstrap;
    use \koolreport\widgets\koolphp\Table;
    use \koolreport\widgets\google\BarChart;
?>

<div class="text-center">
    <h1>Sales Report</h1>
    <h4>This report shows top 10 sales by customer</h4>
</div>
<hr/>

<?php
 BarChart::create(array(
    "dataStore"=>$this->dataStore('result')));

?>
<?php
Table::create(array(
    "dataStore"=>$this->dataStore('result')
));
?>

Thank you Morales. Array error message is fixed now. But am not able to see the graph data.

<?php 
    use \koolreport\clients\Bootstrap;
    use \koolreport\widgets\koolphp\Table;
    use \koolreport\widgets\google\BarChart;
?>

<div class="text-center">
    <h1>Sales Report</h1>
    <h4>This report shows top 10 sales by customer</h4>
</div>
<!-- <hr/> -->

<?php
Table::create(array(
    "dataStore"=>$this->dataStore('result'),
        "columns"=>array(
            "customerName"=>array(
                "label"=>"Customer"
            ),
            "SaleAmount"=>array(
                "type"=>"number",
                "label"=>"Amount",
                "prefix"=>"$",
            )
        ),
    "cssClass"=>array(
        "table"=>"table table-hover table-bordered"
    )
));
?>

<?php
 BarChart::create(array(
    "dataStore"=>$this->dataStore('result'),
    "columns" => array(
        "customerName" => [],
        "SaleAmount" => []
    )
    // "columns"=>array(
    //             "customerName"=>array(
    //                 "label"=>"Customer"
    //             ),
    //             "SaleAmount"=>array(
    //                 "type"=>"number",
    //                 "label"=>"Amount",
    //                 "prefix"=>"$",
    //             )
    //         ),
));
?>

Anything i missed here, please suggest me on this.

I tried with above code also. Still showing same.

Showing exception in Inspect Page:

Uncaught ReferenceError: KoolReport is not defined

at (index):79:1

(anonymous) @ (index):79 (index):85 Uncaught ReferenceError: KoolReport is not defined

at (index):85:5

Reference line index file:

<script type="text/javascript"> KoolReport.widget.init({"js":["\/KoolReport\/get__start\/vendor\/koolreport\/core\/src\/clients\/jquery\/jquery.min.js",["\/KoolReport\/get__start\/vendor\/koolreport\/core\/src\/widgets\/koolphp\/table\/table.js"]],"css":["\/KoolReport\/get__start\/vendor\/koolreport\/core\/src\/widgets\/koolphp\/table\/table.css"]},function(){

ktable627b92b8ba22c1 = new KoolReport.koolphp.table('ktable627b92b8ba22c1',{"cKeys":["customerName","SaleAmount"],"removeDuplicate":[],"paging":null});
    });

</script>

thank you. No js files are loaded in network area. Only path access info is showing. Respective Js files are there in Vendor folder.

Core package is support for this issue right?

No JS files is loading in a page loading.

Yeah. issue is Fixed Now. Issue with the folder structure. Now Js files are loaded. Thanks for valuable time with me.