Download the PHP package dericktan/phpjasper without Composer
On this page you can find all versions of the php package dericktan/phpjasper. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download dericktan/phpjasper
More information about dericktan/phpjasper
Files in dericktan/phpjasper
Package phpjasper
Short Description Create Reports in PHP with JasperReports
License MIT
Homepage https://github.com/Dericktan/phpjasper
Informations about the package phpjasper
JasperReports for PHP and Laravel Framework
Is using Linux servers?
Do not forget to grant permission 777 for the directory /vendor/dericktan/phpjasper/src/JasperStarter/bin and the file binary jasperstarter
Introduction
This package aims to be a solution to compile and process JasperReports (.jrxml & .jasper files).
Why?
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.
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.
I recommend 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
Package to generate reports with JasperReports 6 library through JasperStarter v3 command-line tool.
Requirements
- Java JDK 1.8
- PHP exec() function
- [optional] Mysql Connector (if you want to use database)
- [optional] PostgreSQL Connector (if you want to use database)
- [optional] Jaspersoft Studio (to draw and compile your reports)
Installation
Java
Check if you already have Java installed:
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
Install Composer if you don't have it.
Or in your 'composer.json' file add:
And the just run:
composer install
and thats it.
Examples
The Hello World example.
Go to the examples directory in the root of the repository (vendor/dericktan/phpjasper/examples
).
Open the hello_world.jrxml
file with iReport 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: You don't need to do this step if you are using Jaspersoft Studio. You can compile directly within the program.
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:
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.
Listing Parameters
Querying the jasper file to examine parameters available in the given jasper report file:
Advanced example - using a database
We can also specify parameters for connecting to database:
Using JasperPHP with Laravel 5.*
- Install Composer if you don't have it.
Or in your 'composer.json' file add:
-
And the just run:
composer update
-
Add to your config/app.php providers array:
JasperPHP\JasperPHPServiceProvider::class,
-
Create a folder /report on /public directory
-
Copy the file hello_world.jrxml in /vendor/dericktan/phpjasper/examples from directory: /public/report
-
Run php artisan serve
-
Access localhost:8000/reports
- Check the directory /public/report. You now have 3 files,
hello_world.pdf
,hello_world.rtf
andhello_world.xml
.
Below the code you will use in your route.php
In this example we generate reports pdf, rtf and xml.
Reports from a xml in PHP/Laravel 5.*
See how easy it is to generate a report with a source an XML file:
Note:
To use the example above you must copy the sample files located at:
\vendor\dericktan\phpjasper\src\JasperStarter\examples\CancelAck.jrxml and \vendor\dericktan\phpjasper\src\JasperStarter\examples\CancelAck.xml to folder: \public\report
Reports from a JSON File in PHP/Laravel 5.*
See how easy it is to generate a report with a source an JSON file:
Set Password to exported PDF
You can now set a password to PDF document easily
Note:
To use the example above you must copy the sample files located at:
\vendor\dericktan\phpjasper\src\JasperStarter\examples\CancelAck.jrxml and \vendor\dericktan\phpjasper\src\JasperStarter\examples\CancelAck.xml to folder: \public\report
MySQL
We ship the MySQL connector (v5.1.34) in the /src/JasperStarter/jdbc/
directory.
PostgreSQL
We ship the PostgreSQL (v9.4-1203) in the /src/JasperStarter/jdbc/
directory.
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
Thanks to Cenote GmbH for the JasperStarter tool.
Questions?
Drop me a line on Skype [leandro.bittencourt16] or E-Mail [[email protected]]
Drop me a line on Skype [danielrodrigueslima] or E-Mail [[email protected]]
Drop me a line on E-Mail [[email protected]]
License
MIT