datatables
->eloquent($this->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(['username','action','count'])
->make(true);
}
/**
* Get the query object to be processed by dataTables.
*
* @return
*/
public function query()
{
$ids = UserSenderId::query()->where('status',0)->pluck('user_id')->toArray();
$query = User::query()->whereIn('id',$ids);
return $this->applyScopes($query);
}
public function html()
{
return $this->builder()
->columns($this->getColumns())
->ajax('')
// ->addAction(['width' => '80px'])
->parameters($this->getBuilderParameters());
}
/**
* 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();
}
}