eloquent($query)
->editColumn('username',function ($query){
return ''.$query->username.'';
})
->addColumn('action', function ($query){
return '';
})
->addColumn('count',function ($query){
$count = UserSenderId::query()->where([['user_id',$query->id],['status',0]])->get();
return $count->count();
})->rawColumns(['action','username']);
}
/**
* Get the query object to be processed by dataTables.
*
* @return
*/
public function query()
{
$query = User::query()->whereHas('sender_ids',function ($sender){
$sender->where('status',0);
});
return $this->applyScopes($query);
}
public function html()
{
return $this->builder()
->columns($this->getColumns())
->ajax('')
->dom('Bfrtip')
->buttons(
Button::make('export'),
Button::make('print'),
Button::make('reset'),
Button::make('reload')
);
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
'username',
'count',
'created_at',
'updated_at',
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'allsenderiddatatables_' . time();
}
}