Yajra\CMS\DataTables\UsersDataTable

Complexity

Total Complexity

6

Size/Duplication

Total Lines	98
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	4

Importance

Changes	4
Bugs	0	Features	1

3 Methods

Rating	Name	Duplication	Size	Complexity
B	ajax()	0	26	1
A	query()	0	18	4
B	html()	0	40	1

<?php

namespace Yajra\CMS\DataTables;

use App\User;
use Yajra\Datatables\Services\DataTable;

class UsersDataTable extends DataTable
{
    /**
     * @return \Illuminate\Http\JsonResponse
     */
    public function ajax()
    {
        return $this->datatables
            ->eloquent($this->query())
            ->editColumn('created_at', function (User $user) {
                return $user->created_at->diffForHumans();
            })
            ->editColumn('email', function (User $user) {
                return $this->datatables->getHtmlBuilder()->html->mailto($user->email)->toHtml();
            })
            ->editColumn('blocked', function (User $user) {
                return dt_check($user->blocked);
            })
            ->editColumn('confirmed', function (User $user) {
                return dt_check($user->confirmed);
            })
            ->editColumn('administrator', function (User $user) {
                return dt_check($user->administrator);
            })
            ->editColumn('roles', function (User $user) {
                return dt_render('administrator.users.datatables.roles', compact('user'));
            })
            ->addColumn('action', 'administrator.users.datatables.action')
            ->rawColumns(['email', 'blocked', 'confirmed', 'administrator', 'roles', 'action'])
            ->make(true);
    }

    /**
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function query()
    {
        $users = User::with('roles');

        if ($this->datatables->getRequest()->get('deleted') == 'true') {
            $users->onlyTrashed();
        }

        if ($status = $this->datatables->getRequest()->get('status')) {
            $users->whereIn('confirmed', $status);
        }

        if ($roles = $this->datatables->getRequest()->get('roles')) {
            $users->havingRoles($roles);
        }

        return $this->applyScopes($users);
    }

    /**
     * @return \Yajra\Datatables\Html\Builder
     */
    public function html()
    {
        return $this
            ->builder()
            ->columns([
                'id'            => ['width' => '20px'],
                'first_name',
                'last_name',
                'email',
                'roles'         => ['name' => 'roles.name', 'orderable' => false],
                'administrator' => [
                    'width' => '20px',
                    'title' => '<i class="fa fa-shield" data-toggle="tooltip" data-title="' . trans('cms::user.datatable.columns.administrator') . '"></i>',
                ],
                'confirmed'     => [
                    'width' => '20px',
                    'title' => '<i class="fa fa-check" data-toggle="tooltip" data-title="' . trans('cms::user.datatable.columns.confirmed') . '"></i>',
                ],
                'blocked'       => [
                    'width' => '20px',
                    'title' => '<i class="fa fa-ban" data-toggle="tooltip" data-title="' . trans('cms::user.datatable.columns.blocked') . '"></i>',
                ],
                'created_at',
            ])
            ->addAction(['width' => '80px'])
            ->parameters([
                'stateSave' => true,
                'order'     => [[0, 'desc']],
                'buttons'   => [
                    [
                        'extend' => 'create',
                        'text'   => '<i class="fa fa-plus"></i>&nbsp;&nbsp;' . trans('cms::user.datatable.buttons.create'),
                    ],
                    'export',
                    'print',
                    'reset',
                    'reload',
                ],
            ]);
    }
}