PHP code example of dhenyson / jasper-report-php

    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

    

dhenyson / jasper-report-php example snippets

use Dhenyson\JasperReportPHP\JasperReport;
...
$fileOutputDir = __DIR__ . '/../../../storage/app/public';
$fileName = "example" // or "example.jrxml"

$jasperReport = new JasperReport($fileOutputDir, $fileName);
$jasperReport->setParameter('MyParameter', 'Hello world!');
$filePath = $jasperReport->process("xls"); // default = "pdf"

echo($filePath); // example output -> /app/storage/app/public/example.xls
...

...
$config = [
    'enableLog' => false,
    'dbConnection' => [
        'driver' => 'mysql',
        'host' => '127.0.0.1',
        'port' => '3306',
        'database' => 'test',
        'username' => 'root',
        'password' => '123456',
    ]
];
$jasperReport = new JasperReport($fileOutputDir, $fileName, $config);
$filePath = $jasperReport->process();
...

...
$jasperReport = new JasperReport($fileOutputDir, $fileName);
$jasperReport->setDbDriver('mysql');
$jasperReport->setDbHost('127.0.0.1');
$jasperReport->setDbPort('3306');
$jasperReport->setDbDatabase('test');
$jasperReport->setDbUsername('root');
$jasperReport->setDbPassword('123456');

$jasperReport->setParameter('UserId', '123');

$filePath = $jasperReport->process();
...

$defaultConfig = [
    'jasperStarterPath' => __DIR__ . '/../bin/jasperstarter/bin/jasperstarter',
    'enableLog' => true,
    'dbConnection' => [
        'driver' => 'mysql',
        'host' => null,
        'port' => null,
        'database' => null,
        'username' => null,
        'password' => null,
    ],
    'jdbcDir' => __DIR__ . '/../jdbc',
];

use Dhenyson\JasperReportPHP\JasperReport;
use Illuminate\Http\Request;

class JasperReportsController extends Controller
{
    public function generateReport(Request $request)
    {
        // get file from api request
        $jrxmlFile = $request->file('jrxmlFile');

        // set default path and names
        $fileOutputDir = __DIR__ . '/../../../../storage/app/public';
        $newFileName = 'my_report';
        $jrxmlFilePath = "$fileOutputDir/$newFileName.jrxml";
        $jasperFilePath = "$fileOutputDir/$newFileName.jasper";

        // save the file somewhere
        $jrxmlFile->storeAs('public', "$newFileName.jrxml");

        // Create jasper object and process
        $jasperReport = new JasperReport($fileOutputDir, $newFileName);
        $parameters = $jasperReport->getParameters(); // do something with the parameters
        $jasperReport->setParameter('MyParameter', 'Parameter value');
        $jasperReport->setParameter('MySecondParameter', 'Hello World');

        $outputFilePath = $jasperReport->process();

        // If necessary, remove the files created in the process to free up space
        if (file_exists($jrxmlFilePath)) {
            unlink($jrxmlFilePath);
        }
        if (file_exists($jasperReport->getJasperFilePath())) {
            unlink($jasperReport->getJasperFilePath());
        }

        // Return file to API and delete file
        return response()->download($outputFilePath)->deleteFileAfterSend(true);
    }

bash
composer