addColumn('created_at', function ($query) { return date('l M d, Y', strtotime($query->created_at)); }) ->addColumn('projectanalyst_id', function ($query) { $admin = AdminModel::where('id',$query->projectanalyst_id)->first(); if ($admin !==null) { return $admin->name??'N/A'; }else { return 'N/A'; } }) ->addColumn('creditanalyst_id', function ($query) { $admin = AdminModel::where('id',$query->creditanalyst_id)->first(); if ($admin !==null) { return $admin->name??'N/A'; }else { return 'N/A'; } }) ->editColumn('is_disqualified', function ($query) { if ($query->is_disqualified === null) { return ''; }elseif ($query->is_disqualified === 0) { return ''; }elseif ($query->is_disqualified === 1||$query->is_disqualified === 3) { return ''; } elseif ($query->is_disqualified === 2) { return ''; }elseif ($query->is_disqualified === 4) { return ''; } }) ->addColumn('action', function ($query) { $proj = AdminModel::where('role','2')->get(); $projlist = ''; foreach ($proj as $projs) { if ($query->projectanalyst_id==$projs->id) { $projlist .= ''; }else { $projlist .= ''; } } $credit = AdminModel::where('role','3')->get(); $creditlist = ''; foreach ($credit as $credits) { if ($query->creditanalyst_id==$credits->id) { $creditlist .= ''; }else { $creditlist .= ''; } } if ($query->is_application_complete ==1) { return 'Reassign Resource '; }else { return 'Reassign Resource'; } }) ->rawColumns(['application_status','action','is_disqualified']); } /** * Get query source of dataTable. * * @param \App\App\DashboardTable $model * @return \Illuminate\Database\Eloquent\Builder */ public function query() { $query = DB::select("select users.is_application_complete as is_application_complete,users.application_funds as application_funds,users.id as id,userdetails.name as applicant_name,users.updated_at as updated_at,users.company_name as company_name,userdetails.email as email,userdetails.phone as business_phone,users.is_disqualified as is_disqualified,users.projectanalyst_id as projectanalyst_id,users.creditanalyst_id as creditanalyst_id,users.created_at as created_at from users,userdetails where users.user_id = userdetails.id and users.`is_application_complete`=1 and users.`is_disqualified` in (0,2)"); return $this->applyScopes($query); } // public function query() // { // if (Session::get('adminrole') == 1) { // $query = DB::select("select * from users"); // return $this->applyScopes($query); // }elseif (Session::get('adminrole') == 2) { // $query = DB::select("select * from users where is_disqualified = 0 or is_disqualified =2"); // return $this->applyScopes($query); // }elseif (Session::get('adminrole') == 3) { // $query = DB::select("select * from users where is_qualified"); // return $this->applyScopes($query); // } // // // } /** * Optional method if you want to use html builder. * * @return \Yajra\DataTables\Html\Builder */ public function html() { return $this->builder() ->setTableId('dashboardtable-table') ->columns($this->getColumns()) ->minifiedAjax() ->dom('Bfrtip') ->orderBy(0) ->buttons( Button::make('export'), Button::make('print') // Button::make('reset'), ); } /** * Get columns. * * @return array */ protected function getColumns() { return [ Column::make('updated_at')->visible(false)->exportable(false) ->printable(false), Column::make('applicant_name'), // Column::make('company_name'), Column::make('company_name'), Column::make('email'), Column::make('business_phone'), Column::make('application_funds')->title('Application Type'), // Column::make('is_stage_complete'), Column::make('is_disqualified')->title('Application Status'), Column::make('projectanalyst_id')->title('Project Asst. Assigned'), Column::make('creditanalyst_id')->title('Credit Analyst Assigned'), Column::make('created_at')->title('Date Applied'), // Column::make('application_status'), Column::computed('action') ->exportable(false) ->printable(false) ->width(60) ->addClass('text-center'), ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'DashboardTable_' . date('YmdHis'); } }