eloquent($query) ->addColumn('mode', function($row) {return str_replace('_', ' ', $row->mode);}) ->addColumn('reach', function($row) {return number_format($row->stat()->reach);}) ->addColumn('share', function($row) {return number_format($row->stat()->share, 2) . '%';}) ->addColumn('action', function ($row){ $tool = new TMNTools(); return '

' . '' . '' . '' . '' . '' . '

'; }); // } /** * Get the query object to be processed by dataTables. * * @return \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder|\Illuminate\Support\Collection */ public function query() { $_user = auth()->user(); $query = $_user->audiences()->with(['user']); return $this->applyScopes($query); } /** * Optional method if you want to use html builder. * * @return \Yajra\Datatables\Html\Builder */ public function html() { return $this->builder() ->columns($this->getColumns()) ->minifiedAjax() ->addAction(['width' => '200px']) ->parameters([ 'dom' => 'Bfrtip', 'buttons' => ['csv', 'excel', /*'pdf',*/ 'print', 'reload'], 'order' => [[3, 'desc']] ]); } /** * Get columns. * * @return array */ protected function getColumns() { return [ 'name', 'mode' => ['width' => 150, 'title' => 'Filter Mode'], 'reach' => ['width' => 150, 'class' => 'text-right', 'searchable' => false, 'orderable' => false], 'share' => ['width' => 100, 'class' => 'text-center', 'searchable' => false, 'orderable' => false], ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'audiencedatatables_' . time(); } }