Hello,

I have two tables:

1. Parent table - Having parentId, parentName, parentGender
2. Child table - Having childid, parentid, childname, child gender, childbirthdate

I want to generate report something like

Parent Name, Parent Gender Child Name, Child Date of Birth, Child Gender

Now e.g. Parent table has 2 records:

1. Tom, Male
2. Jerry, Female

Child table has 3 records.

1. Parent Id - 1, Child Name - Bob, Child Gender - Male, DOB - 20thFeb2016
2. Parent Id - 1, Child Name - Tos, Child Gender - Female, DOB - 14Jan2014
3. Parent Id - 2, Child Name - Mary, Child Gender - Female, DOB - 17Sept2017

How to generate such report where single parent can have 2 child rows after that another parent has 1 child row etc.

Please advise.

I got the following error trying to install: "Your requirements could not be resolved to an installable set of packages" "Problem 1

• Conclusion: remove Laravel/Framewokr v5.8.17
• Conclusion: don't install Laravel/framework v5.8.17" Isnt framework the base of laravel?

Hi, I would like to use Maatwebsite Excel 3.0 and report generator but report generator requires 2.1.* and I am not able to use thge package. Will this be compatible with Excel 3.0?

public function report(){
    $title = 'Registered User Report';

    $meta = [
        'Registered on To ',
        'Sort By'
    ];

    $queryBuilder = User::select(['emp_code', 'first_name', 'middle_name', 'last_name']);

    $columns = [
        'EMP Code' => 'emp_code',
        'First Name' => 'first_name',
        'Middle Name' => 'middle_name',
        'Last Name' => 'last_name'
    ];

    return PdfReport::of($title, $meta, $queryBuilder, $columns)
        ->limit(20)
        ->stream();
}

Method Illuminate\Database\Eloquent\Collection::cursor does not exist. (View: ~demo_project\vendor\jimmyjs\laravel-report-generator\src\views\general-pdf-template.blade.php)

how do resolve this??

In CSV Report generation, no. column header is not being added but number is added in value, this causes wrong header order. Ex.

my_column_1 my_column_2 my_column_3 my_column_4 auto_added_no my_val_1 my_val_2 my_val_3 my_val_4

Is this expected behavior?

Also we can't use showNumColumn in CSV to prevent this

Is there any work around to avoid the n + 1 query issues? Model::with('relation') isn't respected for cursors so do we just have no choice at this point?

I am looking a easier way to store files locally on the server, not downloading or streaming. What I am trying to do is setting a scheduling service, auto creating reports and leaving them on server for user to download, or email them the report.

I know for ExcelReport you can make() then store() the LaravelExcelWriter object, and for CSV you can set path in Writer::createFromPath then store all data by using insertAll().

Do you think you can create something like store() that can store file on server for all 3 reports PdfReport, ExcelReport and CSVReport?

test.blade.php

 <form method="GET" action="/generateItemsReport">
                        @csrf
                        <button class="py-2 px-4 bg-blue-400 hover:bg-blue-600 rounded-lg">Generate Report</button>
                    </form>

and this is web.php

Route::get("/generateItemsReport", [ReportController::class, 'GenerateItemsReport']);

and this is GenerateItemsReport method on ReportController

$items = DB::table("items")
            ->leftJoin("category", function ($join) {
                $join->on("items.category_id", "=", "category.id");
            })
            ->select("items.id as item_id", "items.name as name", "items.purchase_price", "items.selling_price", "category.name as category_name")
            ->groupBy("items.id", "items.name", "items.purchase_price", "items.selling_price", "items.category_id", "category.name", "category.id");


        $title = 'Items by Category';
        $meta = [
            'Date' => now()
        ];

        $columns = [
            "ID", "Name", "Purchase Price", "Selling Price", "Category Name"
        ];

        $pdf = new PdfReport();

        return $pdf->of($title, $meta, $items, $columns)->stream();

its produce

Hola all,

I have installed lib using composer and using laravel-dompdf.

First issue that i am facing is that when i use this package i get

Illuminate\Contracts\Container\BindingResolutionException Target class [snappy.pdf.wrapper] does not exist.

but default it's taking snappy for report generation but when i install snappy using

composer require barryvdh/laravel-snappy i get error as below :

Call to undefined method Symfony\Component\HttpFoundation\StreamedResponse::header()?

Any help is appreciated for this .

Sample code :

public function displayReport()
{

  $title = 'Registered User Report'; 

  $meta = [
  ];

  $queryBuilder = User::select(['name']);

  $columns = [ 
	'Name' => 'name',
       'Registered On' => function($queryBuilder){
                return $queryBuilder->created_at;
            }
  ];

  return PdfReport::of($title, $meta, $queryBuilder, $columns)
	->limit(20) 
	->stream(); 
}

I am already using laravel-dompdf for invoice generation. But, when I use this package to generate a report. this is all I get.

Illuminate\Contracts\Container\BindingResolutionException
Target class [snappy.pdf.wrapper] does not exist.

The code I use for a dummy report generation is,

public function displayReport()
{

  $title = 'Registered User Report'; 

  $meta = [
  ];

  $queryBuilder = User::select(['name']);

  $columns = [ 
	'Name' => 'name',
  ];

  return PdfReport::of($title, $meta, $queryBuilder, $columns)
	->limit(20) 
	->stream(); 
}

In the package source code file, PdfReport.php

try {
  $pdf = \App::make('snappy.pdf.wrapper');
  $pdf->setOption('footer-font-size', 10);
  $pdf->setOption('footer-left', 'Page [page] of [topage]');
  $pdf->setOption('footer-right', 'Date Printed: ' . date('d M Y H:i:s'));
} catch (\ReflectionException $e) {
  try {
    $pdf = \App::make('dompdf.wrapper');
  } catch (\ReflectionException $e) {
    throw new \Exception('Please install either barryvdh/laravel-snappy or laravel-dompdf to generate PDF Report!');
  }
}

If I change interchange the detection of snappy and dompdf wrappers like this,

try {
   $pdf = \App::make('dompdf.wrapper');
} catch (\ReflectionException $e) {
  try {
    $pdf = \App::make('snappy.pdf.wrapper');
    $pdf->setOption('footer-font-size', 10);
    $pdf->setOption('footer-left', 'Page [page] of [topage]');
    $pdf->setOption('footer-right', 'Date Printed: ' . date('d M Y H:i:s'));
  } catch (\ReflectionException $e) {
    throw new \Exception('Please install either barryvdh/laravel-snappy or laravel-dompdf to generate PDF Report!');
  }
}

it works perfectly.

Any help on this is much appreciated. Thanks.

i am trying get number of pages in my pdf currently in using dompdf , i was working with snappy it had the number of pages values but with the dompdf in not showing up .

• Add setTotalLabel Method

return PdfReport::of($title, $meta, $queryBuilder, $columns)
       ->setTotalLabel('Total');

Modify showTotal method for change object options and add option function for values "sum", "avg" or function($total).

return PdfReport::of($title, $meta, $queryBuilder, $columns)
->setTotalLabel('Total')
->showTotal([
'Percentage' => [
'format' => 'point',
'function' => function($total) {
return round(($total['COLUMN_NAME1'] / $total['COLUMN_NAME2']) *100);
}
]
]);

Can I generate a report with an Ajax request? I'm using JQuery's ajax method to pass the data to my controller, it gets to the server but the response is odd, is there a way to generate the report in a pop-up window o a blank window?