eloquent() ->addColumn('status', function ($query){ if ($query->adminname == null) { return ''; }else { return ''; } }) ->addColumn('action', function($query){ if ($query->response == null) { return '
'; }else { return '
'; } ; }) ->rawColumns(['issues', 'action','status']);} // /** * Get query source of dataTable. * * @param \App\App\UsersDataTable $model * @return \Illuminate\Database\Eloquent\Builder */ public function query() { $query = DB::select("select * from prelogin_helpdesk order by id desc "); 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('usersdatatable-table') ->columns($this->getColumns()) ->minifiedAjax() // ->dom('Bfrtip') ->orderBy(0) // ->buttons( // Button::make('export'), // Button::make('print'), // Button::make('reset'), // Button::make('reload') // ) ; } /** * Get columns. * * @return array */ protected function getColumns() { return [ Column::make('updated_at')->visible(false)->exportable(false) ->printable(false), Column::make('helpid')->title('Help ID'), Column::make('name'), Column::make('dept')->title('Department'), Column::make('division')->title('Division'), Column::make('phone'), Column::make('email'), Column::make('status'), Column::make('created_at'), Column::computed('action') ->exportable(false) ->printable(false) ->width(60) ->addClass('text-center'), ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'Users_' . date('YmdHis'); } }