Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines
Hi all,
Anyone knows how to integrate KoolReport into Codeigniter? I had followed the guideline by unzipped the folder and pasted into my project folder and created that three files (SalesByCustomer.php, SalesByCustomer.view.php and index.php). But it didn't work. Kindly tell me the steps clearly. Appreciated.
Hi Tee,
Thanks for using KoolReport. KoolReport can be integrated into any MVC framework and CodeIgniter is one of them.
Below are basic steps to integrate KoolReport into CodeIgniter:
assets folder that I suggested to create.MyReport.php and MyReport.view.php. You may view the file below.<?php
defined('BASEPATH') OR exit('No direct script access allowed');
require APPPATH."/reports/MyReport.php";
class Welcome extends CI_Controller {
public function index()
{
$report = new MyReport;
$report->run()->render();
}
}
<?php
//MyReport.php
require APPPATH."/libraries/koolreport/autoload.php";
class MyReport extends \koolreport\KoolReport
{
use \koolreport\clients\Bootstrap;
function settings()
{
return array(
"assets"=>array(
"path"=>"../../assets",
"url"=>"assets",
),
"dataSources"=>array(
"automaker"=>array(
"connectionString"=>"mysql:host=localhost;dbname=automaker",
"username"=>"root",
"password"=>"",
"charset"=>"utf8"
)
)
);
}
function setup()
{
$this->src('automaker')
->query("Select * from offices")
->pipe($this->dataStore("offices"));
}
}
<?php
//MyReport.view.php
use \koolreport\widgets\koolphp\Table;
?>
<html>
<head>
<title>MyReport</title></title>
</head>
<body>
<h1>MyReport</h1>
<h3>List all offices</h3>
<?php
Table::create(array(
"dataStore"=>$this->dataStore("offices"),
"class"=>array(
"table"=>"table table-hover"
)
));
?>
</body>
</html>
All done! The KoolReport has been successfully in CodeIgniter project. Couple of explanation regarding to assets folders:
Since the KoolReport contains css/js needed to be accessed. If the koolreport folder is inside application folder of codeigniter, there is no way that those css/js can be accessed due to the rule of CI. That's why we have the assets settings in the settings() function of MyReport:
"assets"=>array(
"path"=>"../../assets",
"url"=>"assets",
),
This will direct KoolReport to copy all css/js to the assets folder so that they can access to. The path is the relative path from MyReport.php to the public assets folder. And the url is the link to the assets folder in browser. In this case, assets folder is in the same folder with index.php so we can simplly set "assets"
Some images;
Let us know if you need any further assistance.
It is because you have not had the automaker database. If you have downloaded the KoolReport's examples, you can find the automaker.sql.zip file in database folder. Import it into MySQL. Another solution, you can use your own database, put the connection into connectionString in settings() function.
You do this:
...
$report = new MyReport(array(
"supplier"=>$supplier
));
$report->run()->render();
//MyReport.php
...
function setup()
{
$this->src('automaker')
->query("select * from attendance where suppliers = @supplier")
->params(array(
"@supplier"=>$this->params["supplier"]
))
->pipe($this->dataStore("att"));
}
Then in your MyReport settings() function you do:
function settings()
{
return array(
"assets"=>array(
"path"=>"../../assets", //Relative path the assets folder
"url"=>"http://localhost/testing/assets", //Full url to assets folder from browser
),
);
}
Make sure you have the use \koolreport\clients\Bootstrap; in the MyReport.php
Let me know if it works.
This could be issue with browser and nothing to do with the charts. The chart comes from Google as well so it should be able to print. Anything on the screen should be able to print out. One thing you can do is to play with the layouts of webpage. You can use our example layouts to see how since our examples do not have problem with printing.
That's bad. I've checked PHP documentation, it seems we have used a feature of later PHP 5.6. Please help us to do this. You open the koolreport/core/Widget.php, search for following and replace:
DataStore::class and replace it with 'koolreport\core\DataStore'. Process::class to 'koolreport\core\Process'DataSource::class to 'koolreport\core\DataSource'You may just follow our instruction in the first post to integrate KoolReport into CodeIgniter. Please download the CodeIgniter package as well.
In KoolReport, for the purpose of clarity, one class report going with one view: BranchReport.php is going with BranchReport.view.php. If you want to create another report, just create OtherReport.php with OtherReport.view.php.
For the controller of CodeIgniter, you can have only 1 controller that holds many actions, each action return a specific report.
please...class Reports extends CI_Controller()
{
function branch_report()
{
$report = new BranhReport;
$report->run()->render();
}
function other_report()
{
$report = new OtherReport;
$report->run()->render();
}
}
Hope that helps.
if you are using CodeIgniter, check out our CodeIgniter package. the flow is simple that you create your report class and view. Then in the controller of CodeIgniter, you create report object and render report in the view file of codeigniter. If you have not known how to access the page created by CodeIgniter, please take time and learn abit more of codeigniter, it is pretty easy.
P.S: Please check out repo koolreport/codeigniter4-example to see how koolreport is integrated inside CodeIgniter.
Let KoolReport help you to make great reports. It's free & open-source released under MIT license.
Download KoolReport View demo