addEstimatePermission = user()->permission('add_estimates'); $this->editEstimateRequestPermission = user()->permission('edit_estimate_request'); $this->deleteEstimateRequestPermission = user()->permission('delete_estimate_request'); $this->rejectEstimateRequestPermission = user()->permission('reject_estimate_request'); $this->viewEstimateRequestPermission = user()->permission('view_estimate_request'); } /** * Build DataTable class. * * @param mixed $query Results from query() method. * @return \Yajra\DataTables\DataTableAbstract */ public function dataTable($query) { $userId = UserService::getUserId(); $clientIds = ClientContact::where('user_id', $userId)->pluck('client_id')->toArray(); return datatables() ->eloquent($query) ->addIndexColumn() ->editColumn('estimate_request_number', function ($row) { return '' . $row->estimate_request_number . ''; }) ->editColumn('client', function ($row) { return '

' . $row->client->name_salutation . '

' . $row->client->clientDetails?->company_name . '

'; }) ->editColumn('estimated_budget', function ($row) { return currency_format($row->estimated_budget, $row->currency_id); }) ->editColumn('project', function ($row) { if ($row->project_id) { return '

' . $row->project->project_name . '

'; } return '--'; }) ->editColumn('estimate_id', function ($row) { if ($row->estimate) { return '' . $row->estimate->estimate_number . ''; } else { return '--'; } }) ->addColumn('action', function ($row) use ($userId, $clientIds) { $action = '

'; return $action; }) ->addColumn('status1', function ($row) { $select = ''; if ($row->status == 'pending' || $row->status == 'in process') { $select .= '' . __('app.pending') . ''; } elseif ($row->status == 'rejected') { $select .= '' . __('app.' . $row->status) . ''; } else { $select .= '' . __('app.' . $row->status) . ''; } return $select; }) ->addColumn('status_name', function ($row) { return $row->status; }) ->addColumn('early_requirement', function ($row) { return $row->early_requirement ?? '--'; }) ->rawColumns(['action', 'status1', 'client', 'project', 'estimate_id', 'estimate_request_number']); } /** * Get query source of dataTable. * * @return \Illuminate\Database\Eloquent\Builder */ public function query(EstimateRequest $model) { $userId = UserService::getUserId(); $searchText = request('searchText'); $model = $model->select('estimate_requests.*') ->leftJoin('estimates', 'estimates.id', '=', 'estimate_requests.estimate_id') ->leftJoin('users', 'users.id', '=', 'estimate_requests.client_id') ->leftJoin('currencies', 'currencies.id', '=', 'estimate_requests.currency_id') ->leftJoin('projects', 'projects.id', '=', 'estimate_requests.project_id') ->leftJoin('client_details', 'client_details.user_id', '=', 'users.id') ->withoutGlobalScopes([ActiveScope::class, CompanyScope::class]) ->where(function ($query) use ($searchText) { $safeTerm = Common::safeString(request('searchText')); $query->where('users.name', 'like', '%' . $safeTerm . '%') ->orWhere('users.email', 'like', '%' . $safeTerm . '%'); }); if (request()->has('client') && request()->client != 'all') { $model = $model->whereHas('client', function ($query) { $query->where('id', request()->client); }); } if (in_array('client', user_roles())) { $model = $model->where('estimate_requests.client_id', $userId); } if (request()->has('status') && request()->status != 'all') { if (request()->status == 'pending') { $model = $model->whereIn('estimate_requests.status', ['pending', 'in process']); } else { $model = $model->where('estimate_requests.status', request()->status); } } if ($this->viewEstimateRequestPermission == 'added') { $model->where('estimate_requests.added_by', $userId); } if ($this->viewEstimateRequestPermission == 'both') { $model->where(function ($query) use ($userId) { $query->where('estimate_requests.added_by', $userId) ->orWhere('estimate_requests.client_id', $userId); }); } if ($this->viewEstimateRequestPermission == 'owned') { $model->where('estimate_requests.client_id', $userId); } return $model; } /** * Optional method if you want to use html builder. * * @return \Yajra\DataTables\Html\Builder */ public function html() { $dataTable = $this->setBuilder('estimate-request-table', 0) ->parameters([ 'initComplete' => 'function () { window.LaravelDataTables["estimate-request-table"].buttons().container() .appendTo("#table-actions") }', 'fnDrawCallback' => 'function( oSettings ) { $("body").tooltip({ selector: \'[data-toggle="tooltip"]\' }); $(".select-picker").selectpicker(); }', ]); if (canDataTableExport()) { $dataTable->buttons(Button::make(['extend' => 'excel', 'text' => ' ' . trans('app.exportExcel')])); } return $dataTable; } /** * Get columns. * * @return array */ protected function getColumns() { return [ '#' => ['data' => 'id', 'name' => 'id', 'visible' => false], __('modules.estimateRequest.estimateRequest') . ' ' . __('app.number') => ['data' => 'estimate_request_number', 'name' => 'estimate_request_number', 'title' => __('modules.estimateRequest.estimateRequest') . ' ' . __('app.number')], __('app.clientName') => ['data' => 'client', 'name' => 'users.name', 'title' => __('app.clientName')], __('app.project') => ['data' => 'project', 'name' => 'projects.project_name', 'title' => __('app.project')], __('modules.estimateRequest.estimatedBudget') => ['data' => 'estimated_budget', 'name' => 'estimated_budget', 'title' => __('modules.estimateRequest.estimatedBudget')], __('app.estimate') => ['data' => 'estimate_id', 'name' => 'estimate_id', 'title' => __('app.estimate')], __('app.status') => ['data' => 'status1', 'name' => 'status', 'width' => '10%', 'exportable' => false, 'visible' => true, 'title' => __('app.status')], __('modules.estimateRequest.earlyRequirement') => ['data' => 'early_requirement', 'name' => 'early_requirement', 'visible' => false], __('modules.estimateRequest.estimateRequest') . ' ' . __('app.status') => ['data' => 'status_name', 'name' => 'status', 'visible' => false, 'exportable' => true, 'title' => __('modules.estimateRequest.estimateRequest') . ' ' . __('app.status')], Column::computed('action', __('app.action')) ->exportable(false) ->printable(false) ->orderable(false) ->searchable(false) ->width(100) ->addClass('text-right pr-20') ]; } }