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