eloquent($query) ->addColumn('price', function ($row){ return $row->credit ? $row->credit->price : ''; }) ->addColumn('balance', function ($row){ return $row->credit ? $row->credit->new_bal : ''; }) // ->addColumn('credit_alloted', function ($row){ // return $row->credit ? $row->credit->credit_alloted : ''; // }) ->addColumn('credit_used', function ($row){ return $row->credit ? $row->credit->credit_used : ''; }) ->addColumn('is_locked', function ($row){ return $row->is_locked ? 'Yes' : 'No'; }) ->addColumn('updated_at', function ($row){ if ($row->credit && $row->credit->updated_at != null) return $row->credit->updated_at->format('d M y, H:i'); return null; }) ->addColumn('role', function ($row){ $role = ucfirst($row->role->name); if($role == 'User') { $role = 'Client'; } return $role; }) // ->addColumn('action', function ($row){ 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() { $query = User::with(['credit','role','userCurrency'])->whereHas('role', function ($query){ $query->whereIn('name', ['user','reseller']); })->latest(); 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()) ->setTableAttributes(['style'=>'font-size:13px;', 'cellspacing'=> '0']) ->ajax('') ->addAction(['width' => '180px']) ->parameters($this->getBuilderParameters()); } /** * Get columns. * * @return array */ protected function getColumns() { return [ 'username', 'full_name'=> ['title'=>'Contact Person'], 'organisation', 'role'=> ['title'=>'Role', 'searchable'=>false, 'orderable'=>false], 'price' => ['title'=>'SMS Price', 'searchable'=>false, 'orderable'=>false], // 'credit_alloted'=> ['title'=>'Credits Alloted', 'searchable'=>false, 'orderable'=>false], 'credit_used'=> ['title'=>'Credits Used', 'searchable'=>false, 'orderable'=>false], 'balance'=> ['title'=>'Balance', 'searchable'=>false, 'orderable'=>false], 'currency'=> ['title'=>'Currency', 'searchable'=>false, 'orderable'=>false], 'is_locked'=> ['title'=>'Locked?'], 'created_at'=> ['title'=>'Created'], ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'adminuser_' . time(); } }