PHPJasper
A PHP Report Generator
Docs
About
PHPJasper is the best solution to compile and process JasperReports (.jrxml & .jasper files) just using PHP, in short: to generate reports using PHP.
Our channel on discord
Notes:
- PHPJasper Can be used regardless of your PHP Framework
- For PHP versions less than 7.0 see: v1.16
- Here are several examples of how to use PHPJasper
Why PHPJasper?
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? That doesn't make any sense! :)
Then I found JasperReports the best open source solution for reporting.
What can I do with this?
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.
It is recommended using Jaspersoft Studio to build your reports, connect it to your datasource (ex: MySQL, POSTGRES), loop thru the results and output it to PDF, XLS, DOC, RTF, ODF, etc.
Some examples of what you can do:
- Invoices
- Reports
- Listings
Requirements
- PHP 7.2 or above
- Java JDK 1.8
Optional
- Any
jdbcdrivers to generate reports from a database (MySQL, PostgreSQL, MSSQL...), must be copied to a folderbin/jasperstarter/jdbc - We ship the PostgreSQL (42.2.9) in the
bin/jasperstarter/jdbcdirectory. - We ship the MySQL connector (v5.1.48) in the
bin/jasperstarter/jdbcdirectory. - Microsoft JDBC Drivers SQL Server .
- Jaspersoft Studio (to draw your reports).
Installation
Install Composer if you don't have it.
composer require geekcom/phpjasper
Or in your file'composer.json' add:
{
"require": {
"geekcom/phpjasper": "^3.2.0"
}
}
And the just run:
composer install
and thats it.
PHPJasper with Docker
With Docker CE and docker-compose installed just run:
docker-compose up -ddocker exec -it phpjasper composer install
To execute tests:
docker exec -it phpjasper sudo composer testordocker exec -it phpjasper sudo composer testdox
To see coverage manually of tests, execute the file: tests/log/report/index.html
Help us writing new tests, make a fork :)
Examples
The Hello World example.
Go to the examples directory in the root of the repository (vendor/geekcom/phpjasper/examples). Open the hello_world.jrxml file with Jaspersoft Studio or with your favorite text editor and take a look at the source code.
Compiling
First we need to compile our JRXML file into a JASPER binary file. We just have to do this one time.
Note 1: You don't need to do this step if you are using Jaspersoft Studio. You can compile directly within the program.
require __DIR__ . '/vendor/autoload.php';
use PHPJasper\PHPJasper;
$input = __DIR__ . '/vendor/geekcom/phpjasper/examples/hello_world.jrxml';
$jasper = new PHPJasper;
$jasper->compile($input)->execute();
This commando will compile the hello_world.jrxml source file to a hello_world.jasper file.
Processing
Now lets process the report that we compile before:
require __DIR__ . '/vendor/autoload.php';
use PHPJasper\PHPJasper;
$input = __DIR__ . '/vendor/geekcom/phpjasper/examples/hello_world.jasper';
$output = __DIR__ . '/vendor/geekcom/phpjasper/examples';
$options = [
'format' => ['pdf', 'rtf']
];
$jasper = new PHPJasper;
$jasper->process(
$input,
$output,
$options
)->execute();
Now check the examples folder! :) Great right? You now have 2 files, hello_world.pdf and hello_world.rtf.
Check the methods compile and process in src/JasperPHP.php for more details
Listing Parameters
Querying the jasper file to examine parameters available in the given jasper report file:
require __DIR__ . '/vendor/autoload.php';
use PHPJasper\PHPJasper;
$input = __DIR__ . '/vendor/geekcom/phpjasper/examples/hello_world_params.jrxml';
$jasper = new PHPJasper;
$output = $jasper->listParameters($input)->execute();
foreach($output as $parameter_description)
print $parameter_description . '<pre>';
Using database to generate reports
We can also specify parameters for connecting to database:
require __DIR__ . '/vendor/autoload.php';
use PHPJasper\PHPJasper;
$input = '/your_input_path/your_report.jasper';
$output = '/your_output_path';
$options = [
'format' => ['pdf'],
'locale' => 'en',
'params' => [],
'db_connection' => [
'driver' => 'postgres', //mysql, ....
'username' => 'DB_USERNAME',
'password' => 'DB_PASSWORD',
'host' => 'DB_HOST',
'database' => 'DB_DATABASE',
'port' => '5432'
]
];
$jasper = new PHPJasper;
$jasper->process(
$input,
$output,
$options
)->execute();
Note 2:
For a complete list of locales see Supported Locales
Using MSSQL DataBase
require __DIR__ . '/vendor/autoload.php';
use PHPJasper\PHPJasper;
$input = '/your_input_path/your_report.jasper or .jrxml';
$output = '/your_output_path';
$jdbc_dir = __DIR__ . '/vendor/geekcom/phpjasper/bin/jaspertarter/jdbc';
$options = [
'format' => ['pdf'],
'locale' => 'en',
'params' => [],
'db_connection' => [
'driver' => 'generic',
'host' => '127.0.0.1',
'port' => '1433',
'database' => 'DataBaseName',
'username' => 'UserName',
'password' => 'password',
'jdbc_driver' => 'com.microsoft.sqlserver.jdbc.SQLServerDriver',
'jdbc_url' => 'jdbc:sqlserver://127.0.0.1:1433;databaseName=Teste',
'jdbc_dir' => $jdbc_dir
]
];
$jasper = new PHPJasper;
$jasper->process(
$input,
$output,
$options
)->execute();
Reports from a XML
require __DIR__ . '/vendor/autoload.php';
use PHPJasper\PHPJasper;
$input = '/your_input_path/your_report.jasper';
$output = '/your_output_path';
$data_file = __DIR__ . '/your_data_files_path/your_xml_file.xml';
$options = [
'format' => ['pdf'],
'params' => [],
'locale' => 'en',
'db_connection' => [
'driver' => 'xml',
'data_file' => $data_file,
'xml_xpath' => '/your_xml_xpath'
]
];
$jasper = new PHPJasper;
$jasper->process(
$input,
$output,
$options
)->execute();
Reports from a JSON
require __DIR__ . '/vendor/autoload.php';
use PHPJasper\PHPJasper;
$input = '/your_input_path/your_report.jasper';
$output = '/your_output_path';
$data_file = __DIR__ . '/your_data_files_path/your_json_file.json';
$options = [
'format' => ['pdf'],
'params' => [],
'locale' => 'en',
'db_connection' => [
'driver' => 'json',
'data_file' => $data_file,
'json_query' => 'your_json_query'
]
];
$jasper = new PHPJasper;
$jasper->process(
$input,
$output,
$options
)->execute();
Performance
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
Cenote GmbH for the JasperStarter tool.
JetBrains for the PhpStorm and all great tools.
Questions?
Open a new Issue or look for a closed issue
License
MIT
Contribute
Contributors
β¨
Thanks goes to these wonderful people (emoji key):
This project follows the all-contributors specification. Contributions of any kind welcome!
It generates an error informing me that the PHPJasper class does not exist.
"message": "Class "PHPJasper\PHPJasper" not found"
335 Nov 26, 2022
64 Oct 18, 2021
9.3k Jan 1, 2023
3.8k Jan 2, 2023
4.1k Dec 30, 2022
3.6k Jan 6, 2023
1.9k Jan 2, 2023
1.6k Jan 2, 2023
16 Aug 24, 2022
23 Oct 28, 2022
92 Dec 11, 2022
821 Jan 4, 2023
1.5k Dec 25, 2022
0 Feb 5, 2022
816 Dec 15, 2022
790 Dec 8, 2022