Package to generate reports with JasperReports 6 library through JasperStarter v3 command-line tool.
composer require cossou/jasperphp
This package aims to be a solution to compile and process JasperReports (.jrxml & .jasper files).
Did you ever had to create a good looking Invoice with a lot of fields for your great web app?
I had to, and the solutions out there were not perfect. Generating HTML + CSS to make a PDF? WTF? That doesn't make any sense! :)
Then I found JasperReports the best open source solution for reporting.
Well, everything. JasperReports is a powerful tool for reporting and BI.
From their website:
The JasperReports Library is the world's most popular open source reporting engine. It is entirely written in Java and it is able to use data coming from any kind of data source and produce pixel-perfect documents that can be viewed, printed or exported in a variety of document formats including HTML, PDF, Excel, OpenOffice and Word.
I recommend using Jaspersoft Studio to build your reports, connect it to your datasource (ex: MySQL), loop thru the results and output it to PDF, XLS, DOC, RTF, ODF, etc.
Some examples of what you can do:
- Invoices
- Reports
- Listings
Go to the examples directory in the root of the repository (vendor/cossou/jasperphp/examples).
Open the hello_world.jrxml file with iReport or with your favorite text editor and take a look at the source code.
First we need to compile our JRXML file into a JASPER binary file. We just have to do this one time.
Note: You don't need to do this step if you are using Jaspersoft Studio. You can compile directly within the program.
JasperPHP::compile(base_path() . '/vendor/cossou/jasperphp/examples/hello_world.jrxml')->execute();This commando will compile the hello_world.jrxml source file to a hello_world.jasper file.
Note: If you are using Laravel 4 run php artisan tinker and copy & paste the command above.
Now lets process the report that we compile before:
JasperPHP::process(
base_path() . '/vendor/cossou/jasperphp/examples/hello_world.jasper',
false,
array("pdf", "rtf"),
array("php_version" => phpversion())
)->execute();Now check the examples folder! :) Great right? You now have 2 files, hello_world.pdf and hello_world.rtf.
Check the API of the compile and process functions in the file src/JasperPHP/JasperPHP.php file.
Querying the jasper file to examine parameters available in the given jasper report file:
$output = JasperPHP::list_parameters(
base_path() . '/vendor/cossou/jasperphp/examples/hello_world.jasper'
)->execute();
foreach($output as $parameter_description)
echo $parameter_description;We can also specify parameters for connecting to database:
JasperPHP::process(
base_path() . '/vendor/cossou/jasperphp/examples/hello_world.jasper',
false,
array("pdf", "rtf"),
array("php_version" => phpversion()),
array(
'driver' => 'postgres',
'username' => 'vagrant',
'host' => 'localhost',
'database' => 'samples',
'port' => '5433',
)
)->execute();- Java JDK 1.6
- PHP exec() function
- [optional] Mysql Connector (if you want to use database)
- [optional] Jaspersoft Studio (to draw and compile your reports)
Check if you already have Java installed:
$ java -version
java version "1.6.0_51"
Java(TM) SE Runtime Environment (build 1.6.0_51-b11-457-11M4509)
Java HotSpot(TM) 64-Bit Server VM (build 20.51-b01-457, mixed mode)
If you get:
command not found: java
Then install it with: (Ubuntu/Debian)
$ sudo apt-get install default-jdk
Now run the java -version again and check if the output is ok.
Install Composer if you don't have it.
composer require cossou/jasperphp
Or in your composer.json file add:
{
"require": {
"cossou/jasperphp": "~2",
}
}And the just run:
composer update
and thats it.
Add JasperPHP\JasperPHPServiceProvider::class to config config/app.php in service provider
File config/app.php
<?php
.......
.......
'providers' => [
.......
Illuminate\Translation\TranslationServiceProvider::class,
Illuminate\Validation\ValidationServiceProvider::class,
Illuminate\View\ViewServiceProvider::class,
//insert jasper service provider here
JasperPHP\JasperPHPServiceProvider::class
],
......
......Uses in Controller by add use JasperPHP after namespace
<?php
namespace App\Http\Controllers;
use JasperPHP; // put here
......
......
public function generateReport()
{
//jasper ready to call
JasperPHP::compile(base_path() . '/vendor/cossou/jasperphp/examples/hello_world.jrxml')->execute();
}
...... Uses in Route
use JasperPHP\JasperPHP as JasperPHP;
Route::get('/', function () {
$jasper = new JasperPHP;
// Compile a JRXML to Jasper
$jasper->compile(__DIR__ . '/../../vendor/cossou/jasperphp/examples/hello_world.jrxml')->execute();
// Process a Jasper file to PDF and RTF (you can use directly the .jrxml)
$jasper->process(
__DIR__ . '/../../vendor/cossou/jasperphp/examples/hello_world.jasper',
false,
array("pdf", "rtf"),
array("php_version" => "xxx")
)->execute();
// List the parameters from a Jasper file.
$array = $jasper->list_parameters(
__DIR__ . '/../../vendor/cossou/jasperphp/examples/hello_world.jasper'
)->execute();
return view('welcome');
});Add to your app/config/app.php providers array:
'JasperPHP\JasperPHPServiceProvider',Now you will have the JasperPHP alias available.
We ship the MySQL connector (v5.1.34) in the /src/JasperStarter/jdbc/ directory.
We ship the PostgreSQL (v9.4-1203) in the /src/JasperStarter/jdbc/ directory.
Note: Laravel uses pgsql driver name instead of postgres.
Source file example:
{
"result":{
"id":26,
"reference":"0051711080021460005",
"account_id":1,
"user_id":2,
"date":"2017-11-08 00:21:46",
"type":"",
"gross":138,
"discount":0,
"tax":4.08,
"nett":142.08,
"details":[
{"id":26, "line": 1, "product_id": 26 },
]
},
"options":{
"category":[
{"id":3,"name":"Hair care","service":0,"user_id":1, },
],
"default":{
"id":1,"name":"I Like Hairdressing",
"description":null,
"address":null,
"website":"https:\/\/www.ilikehairdressing.com",
"contact_number":"+606 601 5889",
"country":"MY",
"timezone":"Asia\/Kuala_Lumpur",
"currency":"MYR",
"time_format":"24-hours",
"user_id":1
}
}Using with Laravel:
public function generateReceipt($id) {
$datafile = base_path() . "/storage/jasper/data.json";
$output = base_path() . "/storage/jasper/data"; //indicate the name of the output PDF
JasperPHP::process(
base_path() . '/resources/reports/taxinvoice80.jrxml',
$output,
array("pdf"),
array("msg"=>"Tax Invoice"),
array("driver"=>"json", "username"=>"admin", "password"=>"", "json_query" => "data", "data_file" => $datafile)
)->execute();
}Some hack to JasperReport datasource is required. You need to indicate datasource expression for each table, list, and subreport.
<datasetRun subDataset="invoice_details" uuid="a91cc22b-9a3f-45eb-9b35-244890d35fc7">
<dataSourceExpression>
<![CDATA[((net.sf.jasperreports.engine.data.JsonDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("result.details")]]>
</dataSourceExpression>
</datasetRun>Depends on the complexity, amount of data and the resources of your machine (let me know your use case).
I have a report that generates a Invoice with a DB connection, images and multiple pages and it takes about 3/4 seconds to process. I suggest that you use a worker to generate the reports in the background.
Thanks to Cenote GmbH for the JasperStarter tool.
Drop me a line on Twitter @cossou.
MIT