PHP code example of rishadblack / i-reports

1. Go to this page and download the library: Download rishadblack/i-reports library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php.
    
        
<?php
require_once('vendor/autoload.php');

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

    

rishadblack / i-reports example snippets


// config/i-reports.php
'report_namespace' => 'Reports',          // App\Livewire\Reports\...
'report_suffix' => 'Report',              // "users" resolves to UsersReport
'route_middleware' => ['web', 'auth'],

namespace App\Livewire\Reports;

use App\Models\User;
use Illuminate\Database\Eloquent\Builder;
use Rishadblack\IReports\BaseReportController;
use Rishadblack\IReports\Views\Column;
use Rishadblack\IReports\Views\Filter;

class UsersReport extends BaseReportController
{
    public function builder(): Builder
    {
        return User::query()->where('tenant_id', auth()->user()->tenant_id);
    }

    public function configure(): void
    {
        $this->setReportTitle('User List');
        $this->setDefaultSort('users.name');
        $this->setOrientation('landscape');
    }

    public function columns(): array
    {
        return [
            Column::make('Name', 'name')->searchable()->sortable(),
            Column::make('Email', 'email')->searchable()->sortable(),
            Column::make('District', 'district.name')->sortable(),
            Column::make('Balance', 'balance')->money('BDT')->sum()->sortable(),
            Column::make('Active', 'active')->boolean(),
            Column::make('Joined', 'created_at')->date('d M Y')->hideIn('csv'),
            Column::make('Status', 'status')->badge(['active' => ['Active', 'badge bg-success'], 'blocked' => ['Blocked', 'badge bg-danger']]),
        ];
    }

    public function filters(): array
    {
        return [
            Filter::make('Status', 'status')->select(['active' => 'Active', 'blocked' => 'Blocked'])->column('users.status'),
            Filter::make('Joined', 'joined')->dateRange()->column('users.created_at'),
            Filter::make('Balance', 'balance')->numberRange()->column('users.balance'),
            Filter::make('Country', 'country_id')->component('selects.country-select')->column('users.country_id'),
            Filter::make('District', 'district_id')->component('selects.district-select')->dependsOn('country_id')->column('users.district_id'),
        ];
    }

    public function authorize(): bool
    {
        return auth()->user()?->can('view-users-report') ?? false;
    }
}

use Rishadblack\IReports\Helpers\RequestHelper;

$url = route('i-reports.view', [
    'token' => (new RequestHelper(['report' => 'users', 'export' => 'pdf', 'filters' => ['status' => 'active']]))->generateToken(),
]);

// config/i-reports.php
'branding' => [
    'name' => 'Acme Ltd',                 // null = setHeaderTitle() or app.name
    'tagline' => 'House 12, Road 5, Dhaka',
    'logo' => public_path('images/logo.png'),
    'accent_color' => '#1f2937',
    'show_filters' => true,
    'show_generated_by' => true,
],

Column::make('Email', 'email')->hiddenByDefault(), // off until the user switches it on
Column::make('Name', 'name')->hideable(false),     // always shown

'queue' => [
    'enabled' => true,
    'thresholds' => ['pdf' => 1000, 'xlsx' => 50000, 'csv' => 200000],
    'disk' => 'local',
    'keep_days' => 7,
],

use Rishadblack\IReports\Facades\IReports;

IReports::register('people', App\Livewire\Reports\UsersReport::class);
IReports::all();
bash
php artisan i-reports:view users          # resources/views/livewire/reports/users-report.blade.php
# or scaffold class + view together:
php artisan make:report users --view
bash
php artisan install:broadcasting   # installs Reverb, laravel-echo and the broadcasting routes
php artisan reverb:start