<?php

namespace Modules\Platform\User\Datatables;

use Modules\Platform\Core\Datatable\PlatformDataTable;
use Modules\Platform\Core\Helper\CompanySettings;
use Modules\Platform\Core\Helper\DataTableHelper;
use Modules\Platform\Core\Helper\SettingsHelper;
use Modules\Platform\User\Entities\User;
use Yajra\DataTables\EloquentDataTable;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\SoftDeletes;

/**
 * Class UsersDataTable
 * @package Modules\Platform\User\Datatables
 */
class UsersDataTable extends PlatformDataTable
{
    use HasFactory, SoftDeletes;
    const SHOW_URL_ROUTE = 'settings.users.show';


    /**
     * Build DataTable class.
     *
     * @param mixed $query Results from query() method.
     * @return \Yajra\DataTables\DataTableAbstract
     */
    public function dataTable($query)
    {
        $dataTable = new EloquentDataTable($query);

        $this->applyLinks($dataTable, self::SHOW_URL_ROUTE);

        $dataTable->filterColumn('created_at', function ($query, $keyword) {
            $dates = DataTableHelper::getDatesForFilter($keyword);

            if ($dates != null) {
                $query->whereBetween('created_at', array($dates[0], $dates[1]));
            }
        });
        $dataTable->filterColumn('updated_at', function ($query, $keyword) {
            $dates = DataTableHelper::getDatesForFilter($keyword);

            if ($dates != null) {
                $query->whereBetween('updated_at', array($dates[0], $dates[1]));
            }
        });

        $dataTable->addColumn('roles_text', function ($quote) {
            return $quote->roles_text;
        });

        return $dataTable;
    }

    /**
     * Get query source of dataTable.
     *
     *
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function query(User $model)
    {
        $query = $model->newQuery()
            ->with('roles') // تحميل العلاقة
            ->select('users.*')
            ->addSelect(\DB::raw('(
                SELECT GROUP_CONCAT(roles.display_name SEPARATOR ", ") 
                FROM model_has_roles 
                JOIN roles ON model_has_roles.role_id = roles.id 
                WHERE model_has_roles.model_id = users.id 
                AND model_has_roles.model_type = "Modules\\\Platform\\\User\\\Entities\\\User"
            ) as roles_text'));


        if(\Auth::user()->hasPermissionTo('settings.access') && \Auth::user()->hasRole('admin')){
            // $query->where(function ($q){
                // $q->where('company_id',\Landlord::getTenantId('company_id'));
                // $q->orWhereIn('id',User::role(User::ADMIN_ROLE_NAME)->get()->pluck('id'));
            // });

        }else{
            $query->where('company_id',\Landlord::getTenantId('company_id'));
        }

        // Only super admins and company admins (Admin Setting permission or
        // Company Admin role) may see users holding a protected role.
        if(!\Auth::user()->canManageCompanyAccess()){
            $query->excludingProtectedRoles();
        }

        return $query;


    }

    /**
     * Optional method if you want to use html builder.
     *
     * @return \Yajra\DataTables\Html\Builder
     */
    public function html()
    {
        return $this->builder()
            ->columns($this->getColumns())

            ->setTableAttribute('class', 'table table-hover')
            ->parameters([
                'dom' => 'lBfrtip',
                'responsive' => false,
                'stateSave' => true,
                'columnFilters' => [
                    [
                        'column_number' => 0,
                        'filter_type' => 'text'
                    ],
                    [
                        'column_number' => 1,
                        'filter_type' => 'text'
                    ],
                    [
                        'column_number' => 2,
                        'filter_type' => 'bap_date_range_picker',
                    ],
                    [
                        'column_number' => 3,
                        'filter_type' => 'bap_date_range_picker',
                    ]
                ],
                'buttons' => DataTableHelper::buttons(),
                'regexp' => true

            ]);
    }

    /**
     * @return array
     */
    protected function getColumns()
    {
        $columns =
            [
                'id' => ['data' => 'id', 'title' => 'Ext.', 'data_type' => 'text'],
                'name' => ['data' => 'name', 'title' => trans('user::users.table.first_name'), 'data_type' => 'text'],
                'email' => ['data' => 'email', 'title' => trans('user::users.table.email'), 'data_type' => 'email'],
                'roles_text' => ['data' => 'roles_text', 'title' => trans('user::users.table.roles'), 'data_type' => 'text'],
                'created_at' => ['data' => 'created_at', 'title' => trans('user::users.table.created_at'), 'data_type' => 'datetime'],
                'updated_at' => ['data' => 'updated_at', 'title' => trans('user::users.table.updated_at'), 'data_type' => 'datetime'],
            ];

        // The "Code" column is only displayed when the company setting
        // "Enable User Code field" is turned on.
        if ((bool) CompanySettings::get(SettingsHelper::S_COMPANY_USER_CODE_ENABLED)) {
            $columns = array_merge(
                array_slice($columns, 0, 1, true), // keep 'id' (Ext.) first
                ['code' => ['data' => 'code', 'title' => trans('user::users.table.code'), 'data_type' => 'text']],
                array_slice($columns, 1, null, true)
            );
        }

        return $columns;
    }
}