eloquent() ->skipPaging() ->addColumn('gen', function ($query){ $gen = Assess::where('division',$query->division)->where('gen_momo','1')->count(); return $gen ??'N/A'; }) ->addColumn('gvhigh', function ($query){ $gvhigh = Assess::where('division',$query->division)->where('risk_cat','Very High')->where('gen_momo','1')->count(); return '

'.$gvhigh.'

'; }) ->addColumn('ghigh', function ($query){ $ghigh = Assess::where('division',$query->division)->where('risk_cat','High')->where('gen_momo','1')->count(); return '

'.$ghigh.'

'; }) ->addColumn('gmedium', function ($query){ $gmedium = Assess::where('division',$query->division)->where('risk_cat','Medium')->where('gen_momo','1')->count(); return '

'.$gmedium.'

'; }) ->addColumn('glow', function ($query){ $glow = Assess::where('division',$query->division)->where('risk_cat','Low')->where('gen_momo','1')->count(); return '

'.$glow.'

'; }) ->addColumn('momo', function ($query){ $momo = Assess::where('division',$query->division)->where('gen_momo','0')->count(); return $momo ??'N/A'; }) ->addColumn('mvhigh', function ($query){ $mvhigh = Assess::where('division',$query->division)->where('risk_cat','Very High')->where('gen_momo','0')->count(); return '

'.$mvhigh.'

'; }) ->addColumn('mhigh', function ($query){ $mhigh = Assess::where('division',$query->division)->where('risk_cat','High')->where('gen_momo','0')->count(); return '

'.$mhigh.'

'; }) ->addColumn('mmedium', function ($query){ $mmedium = Assess::where('division',$query->division)->where('risk_cat','Medium')->where('gen_momo','0')->count(); return '

'.$mmedium.'

'; }) ->addColumn('mlow', function ($query){ $mlow = Assess::where('division',$query->division)->where('risk_cat','Low')->where('gen_momo','0')->count(); return '

'.$mlow.'

'; }) ->rawColumns(['gvhigh','ghigh','gmedium','glow','mvhigh','mhigh','mmedium','mlow', 'action','status']);} // /** * Get query source of dataTable. * * @param \App\App\UsersDataTable $model * @return \Illuminate\Database\Eloquent\Builder */ public function query() { $query = DB::select("select distinct(division) from assess"); 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('division')->visible(false)->exportable(false) ->printable(false), Column::make('division'), Column::make('gen')->title('General Declaration'), Column::make('gvhigh')->title('Very High'), Column::make('ghigh')->title('High'), Column::make('gmedium')->title('Medium'), Column::make('glow')->title('Low'), Column::make('momo')->title('Momo Declaration'), Column::make('mvhigh')->title('Very High'), Column::make('mhigh')->title('High'), Column::make('mmedium')->title('Medium'), Column::make('mlow')->title('Low'), // 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'); } }