query($query)
->addColumn('checkbox', function ($row) {
return '';
})
->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()
{
$group_id = $this->request()->get('group_id',0);
if(!empty($group_id)) {
$query = Auth::user()->groups()->findOrFail($group_id)->contacts();
} else {
$query = ContactGroup::where('id',0);
}
return $this->applyScopes($query);
}
/**
* Optional method if you want to use html builder.
*
* @return \Yajra\Datatables\Html\Builder
*/
public function html()
{
$params = $this->getBuilderParameters();
$params['order'] = [[1, 'desc']];
$params['lengthMenu'] = [[10, 30, 75, -1], [10, 30, 75, "All"]];
return $this->builder()
->addCheckbox(['title'=>''])
->columns($this->getColumns())
->ajax('')
->addAction(['width' => '150px'])
->parameters($params);
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
'phone_number',
'name'
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'contactdatatables_' . time();
}
}