binarycabin / laravel-reporting
Basic tools for building reports
This package is auto-updated.
Last update: 2024-11-06 10:00:48 UTC
README
Basic tools for building reports
composer require binarycabin/laravel-reporting
Available Traits
\BinaryCabin\LaravelReporting\Traits\Sortable
Provides a scope to pass sortable values to a query:
// (/users?sort=last_name&sort_order=ASC)
$users = \App\User::sort($request->all())->get();
On your model, add the properties below to set the default sorting when none is passed:
protected $sortFieldDefault = 'id'; protected $sortOrderDefault = 'ASC';
\BinaryCabin\LaravelReporting\Traits\Filterable
Provides scopes to add filtering to your query:
\App\User::filter($request->all())->get();
On your model, add a filterable property to determine all columns allowed to be filtered:
protected $filterable = [
'first_name',
'last_name',
'global',
];
If a scope with the filterable name exists, it will be used in the filter. A scope "global" is provided in the trait. This will look through all fields in your "filterableGlobal" array for the passed query
protected $filterableGlobal = [
'first_name',
'company',
];
\App\User::filter(['global'=>'ABC Company'])->get();
Available Views
A sortable button is included to pass the "sort" and "sort_order" request values when viewing a table:
<th>@include('reporting::components.sort-button',['sortField'=>'created_at']) Date Created</th>
Available Controllers
An extendable controller is also available, which provides basic CRUD operation, along with default Sort/Filter functionality. To use this controller, simply create a controller extending it and passing available properties shown below:
<?php
namespace App\Http\Controllers\Manage\Users;
use BinaryCabin\LaravelReporting\Http\Controllers\BaseManageController;
class UserController extends BaseManageController
{
protected $modelClass = \App\User::class;
protected $baseTitlePlural = 'Users';
protected $baseTitleSingular = 'User';
protected $variableNamePlural = 'users';
protected $variableNameSingular = 'user';
protected $baseRoute = 'manage/user';
protected $viewIndex = 'manage.user.index';
protected $viewCreate='manage.user.create';
protected $viewEdit='manage.user.edit';
}