Hi team, I have created one CodeIgniter project. I had followed the guideline by unzipped the folder and pasted into my project (codeigniter/application/libraries ).And i have added the below line in my BussinessId.php
require_once "../koolreport/autoload.php"; class BussinessId extends \koolreport\KoolReport {
use \koolreport\codeigniter\Friendship;
protected function setup()
{
$this->src('alljobs')
->query("SELECT h.doc_code,h.quoted_sale,h.doc_issued_date,s.doc_status_name,u.business_name FROM `nrm_doc_header` as h join nrm_doc_status as s on h.doc_status_id = s.doc_status_id join nrm_business as u on h.business_id = u.business_id")
->pipe(new Group(array(
"by"=>"business_name",
//"by"=>"doc_status_name",
"sum"=>"quoted_sale"
)))
->pipe(new Sort(array(
"quoted_sale"=>"desc"
)))
->pipe($this->dataStore('jobs_list'));
}
}
But,i'm not able to connect with database. I have used koolreport pro version for this project.Can you please help me to find out the issue. Appreciated.