datatables ->queryBuilder($this->query()) ->addColumn('action', function ($row) { return '

' . '' . '' . '

'; }) ->make(true); } /** * Get the query object to be processed by dataTables. * * @return \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder|\Illuminate\Support\Collection */ public function query() { if($this->request()->get('type')) { $type = $this->request()->get('type'); $roleId = strtolower($type) == 'reseller' ? Role::where('name', 'reseller')->firstOrFail()->id : Role::where('name', 'user')->firstOrFail()->id; $query = DB::table('users') ->join('credits', 'credits.user_id', '=', 'users.id') ->where('users.role_id', '=', $roleId) ->select(DB::raw('users.id, users.username as username, users.organisation as org, credits.price as price, credits.new_bal as balance, full_name as name')) ->orderBy('users.full_name', 'desc'); } else { $query = DB::table('users')->where('id',0); } 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()) ->ajax('') ->addAction(['width' => '80px']) ->parameters([ 'dom' => 'Bfrtip', 'buttons' => ['csv', 'excel', 'pdf', 'print', 'reload'], 'order' => [[1, 'desc']] ]); } /** * Get columns. * * @return array */ protected function getColumns() { return [ 'username', 'name', 'org', 'price' => ['title' => 'Default Price', 'searchable'=>false, 'orderable'=>false], 'balance' => ['searchable'=>false, 'orderable'=>false], ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'network_cost_price_' . time(); } }