eloquent($query) ->addColumn('price', function ($row){ return $row->users->credit->price ?? null; }) ->addColumn('balance', function ($row){ return !empty($row->users->credit) ? $row->users->credit->new_bal: ''; }) ->addColumn('credit_used', function ($row){ return !empty($row->users->credit) ? $row->users->credit->credit_used:''; }) ->addColumn('is_locked', function ($row){ return $row->users->is_locked ?? null ? 'Yes' : 'No'; }) ->addColumn('currency', function ($row){ return $row->users->credit->currency ?? ''; }) ->addColumn('updated_at', function ($row){ return !empty($row->users->credit) ? $row->users->credit->updated_at->format('d M y, H:i'):''; }) // ->addColumn('action', function ($row){ return '

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

'; }); } public function query() { $query = Company::query()->whereHas('users',function ($user){ $user->where('created_by',Auth::user()->username); })->with('users'); return $this->applyScopes($query); } /** * Optional method if you want to use html builder. * */ public function html() { return $this->builder() ->columns($this->getColumns()) ->setTableAttributes(['style'=>'font-size:13px;', 'cellspacing'=> '0']) ->ajax('') ->addAction(['width' => '260px']) ->dom('Bfrtip') ->buttons( Button::make('excel'), Button::make('csv'), Button::make('print') ); } /** * Get columns. * * @return array */ protected function getColumns() { return [ 'users.username'=>['title'=>'username'], // 'full_name'=> ['title'=>'Contact Person'], 'users.organisation'=>['title'=>'Organisation'], 'price' => ['title'=>'SMS Price', '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?'], // 'updated_at' => ['title'=>'Last Update', 'searchable'=>false, 'orderable'=>false], ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'reselleruser_' . time(); } }