Phpjasper does not return database data

Question

I’m doing a monthly report of an application with Laravel 5.7, but it’s only returning NULL from the database. I’m using Mysql. Can someone help us? This is my Controller.

use Illuminate\Http\Request;
use PHPJasper\PHPJasper;
use App\Model\User;
class ReportController extends Controller
{

public function index()
{


$output = public_path() . '/reports/' . time() . '_MidiaSocial';
$input =  public_path().'/reports/Sistema.jrxml';
$report = new PHPJasper;        
$report->process(
    $input,
    $output,
    array("pdf"),
    array(),
    [
        'driver' => 'generic',
        'host' => env('DB_HOST', 'localhost'),
        'port' => env('DB_PORT', '3306'),
        'database' => env('DB_DATABASE', 'calculosorte'),
        'username' => env('DB_USERNAME', 'root'),
        'password' => env('DB_PASSWORD', ''),
        'jdbc_driver' => 'com.mysql.jdbc.Driver',
        'jdbc_url' => 'jdbc:mysql://'.env('DB_HOST', 'localhost').':'.env('DB_PORT', '3306').';databaseName='.env('DB_DATABASE', 'calculosorte'),
        'jdbc_dir' => base_path().env('JDBC_DIR', 'vendor/geekcom/phpjasper/bin/jasperstarter/jdbc/')

    ]
)->execute();
$file = $output.'.pdf';
$path = $file;

if (!file_exists($file)) {
    abort(404);
}
//caso tenha sido gerado pego o conteudo
    $file = file_get_contents($file);
//deleto o arquivo gerado, pois iremos mandar o conteudo para o navegador
    unlink($path);
// retornamos o conteudo para o navegador que íra abrir o PDF
    return response($file, 200)
    ->header('Content-Type', 'application/pdf')
    ->header('Content-Disposition', 'inline; filename="midia_social.pdf"');

}
}

Answer 1

Tries to do the implementation as the documentation says to return it keyed in the correct way.

$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();