Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory :  /home/corals/ts.corals.io/corals-api/Corals/core/User/DataTables/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

namespace Corals\User\DataTables;

use Corals\Foundation\DataTables\BaseDataTable;
use Corals\Modules\Utility\Facades\ListOfValue\ListOfValues;
use Corals\User\Facades\Roles;
use Corals\User\Models\User;
use Corals\User\Transformers\UserTransformer;
use Yajra\DataTables\EloquentDataTable;

class UsersDataTable extends BaseDataTable
{
    protected $usesQueryBuilderFilters = true;

    /**
     * Build DataTable class.
     *
     * @param mixed $query Results from query() method.
     * @return \Yajra\DataTables\DataTableAbstract
     */
    public function dataTable($query)
    {
        $this->setResourceUrl(config('user.models.user.resource_url'));

        $dataTable = new EloquentDataTable($query);

        return $dataTable->setTransformer(new UserTransformer());
    }

    /**
     * Get query source of dataTable.
     * @param User $model
     * @return \Illuminate\Database\Eloquent\Builder|static
     */
    public function query(User $model)
    {
        $model = $model->with('roles')->select('users.*');

        return $model;
    }

    /**
     * Get columns.
     *
     * @return array
     */
    protected function getColumns()
    {
        $columns = [
            'id' => ['visible' => false],
            'picture_thumb' => [
                'width' => '35px',
                'exportable' => false,
                'title' => trans('User::attributes.user.picture_thumb'),
                'orderable' => false,
                'searchable' => false
            ],
            'name' => ['title' => trans('User::attributes.user.name')],
            'last_name' => ['title' => trans('User::attributes.user.last_name')],
            'email' => ['title' => trans('User::attributes.user.email')],
            'status' => ['title' => trans('Corals::attributes.status')],
            'roles' => ['name' => 'roles.name', 'title' => trans('User::attributes.user.roles'), 'orderable' => false],
            'position' => ['title' => trans('User::attributes.user.position')],
            'employee_type' => ['title' => trans('User::attributes.user.employee_type')],
        ];

        if ((\Settings::get('confirm_user_registration_email', false))) {
            $columns = array_merge($columns, [
                'confirmed' => ['title' => trans('User::attributes.user.confirmed'), 'name' => 'confirmed_at'],
            ]);
        }

        $columns = array_merge($columns, [
            'created_at' => ['title' => trans('Corals::attributes.created_at')],
            'updated_at' => ['title' => trans('Corals::attributes.updated_at')],
        ]);

        return $columns;
    }

    public function getFilters()
    {
        $positions = ListOfValues::get('positions');
        $employee_type_options = ListOfValues::get('employee_type');

        return [
            'name' => ['title' => trans('User::attributes.user.name'), 'class' => 'col-md-2', 'type' => 'text', 'condition' => 'like', 'active' => true],
            'last_name' => ['title' => trans('User::attributes.user.last_name'), 'class' => 'col-md-2', 'type' => 'text', 'condition' => 'like', 'active' => true],
            'email' => ['title' => trans('User::attributes.user.email'), 'class' => 'col-md-2', 'type' => 'text', 'condition' => 'like', 'active' => true],
            'status' => ['title' => trans('Corals::attributes.status'), 'class' => 'col-md-2', 'type' => 'select2', trans('Corals::attributes.status_options'), 'active' => true],
            'roles.id' => ['title' => trans('User::attributes.user.roles'), 'class' => 'col-md-2', 'type' => 'select', 'options' => Roles::getRolesList(), 'active' => true],
            'created_at' => ['title' => trans('Corals::attributes.created_at'), 'class' => 'col-md-4', 'type' => 'date_range', 'active' => true],
            'position' => ['title' => trans('User::attributes.user.position'),'type' => 'select','options' =>$positions, 'active' => true],
            'employee_type' => ['title' => trans('User::attributes.user.employee_type'),'type' => 'select','options' =>$employee_type_options, 'active' => true],
        ];
    }


    protected function getBulkActions()
    {
        return [
            'delete' => ['title' => trans('Corals::labels.delete'), 'permission' => 'User::user.delete', 'confirmation' => trans('Corals::labels.confirmation.title')]
        ];
    }

    protected function getOptions()
    {
        $url = url(config('user.models.user.resource_url'));
        return ['resource_url' => $url];
    }


}