eloquent() // ->orderColumn('name', function ($query, $order) { // $query->orderBy('id', $order); // }) // // ->orderColumn('company_name', function ($query, $order) { // $query->orderBy('id', $order); // }) // ->orderColumn('position', function ($query, $order) { // $query->orderBy('id', $order); // }) // ->orderColumn('phone', function ($query, $order) { // $query->orderBy('id', $order); // }) // ->orderColumn('email', function ($query, $order) { // $query->orderBy('id', $order); // }) // ->orderColumn('created_at', function ($query, $order) { // $query->orderBy('id', $order); // }) // ->orderColumn('business_association', function ($query, $order) { // $query->orderBy('id', $order); // }) // ->addColumn('business_association', function ($query) { // $rr = OperationsModel::where('user_id',$query->id)->first(); // if ($rr!==null) { // return $rr->business_assoc??'N/A'; // } // }) ->editColumn('eco_sector', function ($query) { return $query->eco_sector??'N/A';// human readable format }) // ->addColumn('business_association', function ($query) { // $rr = OperationsModel::where('user_id',$query->id)->first(); // if ($rr!==null) { // return $rr->business_assoc??'N/A'; // }else { // return 'N/A'; // } // }) ->editColumn('created_at', function ($query) { return date('l d M,Y',strtotime($query->created_at));// human readable format }) ->addColumn('action', function($query){ return '
View Application Start Review
'; }) ->rawColumns(['action']); } /** * Get query source of dataTable. * * @param \App\App\UnderReviewApplication $model * @return \Illuminate\Database\Eloquent\Builder */ public function query() { $query = DB::select('select userdetails.id as id,userdetails.position as position,userdetails.name as name,userdetails.company_name as company_name,userdetails.email as email,userdetails.phone as phone,userdetails.city as city,userdetails.eco_sector as eco_sector,userdetails.created_at as created_at,users.applicant_name as nname, business_types.name as sector from users,userdetails,business_types where userdetails.id = users.user_id and users.is_disqualified=0 and users.is_application_complete=1 and business_types.id=users.business_type'); 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('underreviewapplication-table') ->columns($this->getColumns()) ->minifiedAjax() ->dom('Bfrtip') ->orderBy(1) ->buttons( // Button::make('create'), Button::make('export'), Button::make('print') // Button::make('reset'), // Button::make('reload') ); } /** * Get columns. * * @return array */ protected function getColumns() { return [ Column::make('name'), Column::make('company_name'), Column::make('position'), Column::make('phone'), Column::make('email'), // Column::make('region'), // Column::make('city'), Column::make('sector')->title('Sector'), // Column::make('business_association')->title('business_association'), // '', Column::make('created_at')->title('Date Applied'), Column::computed('action') ->exportable(false) ->printable(false) ->width(60) ->addClass('text-center'), ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'UnderReviewApplication_' . date('YmdHis'); } }