trezix1 / query-builder
Self-contained report / query-builder module: build ad-hoc reports over registered tables, save them, and view results with per-user filters and column preferences.
Maintainers
Requires
- php: ^8.1
- illuminate/database: ^8.0
- illuminate/support: ^8.0
- spatie/laravel-activitylog: ^3.17
- stancl/tenancy: ^3.5
- yajra/laravel-datatables: ^1.5
This package is not auto-updated.
Last update: 2026-07-30 09:48:17 UTC
README
app
Trezix1\QueryBuilder\QueryBuilderServiceProvider::class,
[
'group_name' => 'report',
'sub_group_name' => 'report-configuration',
'permissions' => [
'report-configuration.create',
'report-configuration.view',
'report-configuration.edit',
'report-configuration.show',
'report-configuration.delete',
],
],
php artisan db:seed --class="Trezix1\QueryBuilder\Database\Seeders\DbTablesSeeder"
side bar
|| Route::is('tenant.admin.query_builder.list') || Route::is('tenant.admin.query_builder.index') || Route::is('tenant.admin.query_builder.maualreport')
@if( $usr->can('report-configuration.create') || $usr->can('report-configuration.view') || $usr->can('report-configuration.edit') || $usr->can('report-configuration.delete') )
@if($usr->can('report-configuration.view'))
@if(!empty($report_list))
@foreach($report_list as $report)
<li class="nav-item">
<a href="{{ route('tenant.admin.query_builder.maualreport', encrypt($report->id)) }}"
class="nav-link @if(Route::currentRouteName() === 'tenant.admin.query_builder.maualreport'
&& decrypt(request()->route('id')) == $report->id) active @endif">
<span data-bs-toggle="tooltip"
data-bs-placement="right"
title="{{ $report->report_name }}"
class="text-truncate"
style="max-width: 140px;">
{{ $report->report_name }}
</span>
</a>
</li>
@endforeach
@endif
@endif
</ul>
</div>
</li>
@endif