get('access');
return datatables()
->eloquent($query)
->editColumn('email', function ($query){
return $query->email ?? 'N/A';
})
->editColumn('phone_number', function ($query){
return $query->phone_number ?? 'N/A';
})
->addColumn('group', function ($query){
return $query->group->name ?? 'N/A';
})
->addColumn('is_locked', function ($query){
if ((boolean) $query->is_locked){
return 'Yes';
}else{
return 'No';
}
})
->addColumn('action', function ($query) use ($access){
$action1 = '';
// $action1 = '';
$action2 = '';
$action3 = '';
return $access == 2 ? $action2 : ($access ==3 ? $action3 : $action1);
})->addColumn('status',function ($query){
$string = in_array(@$query->company_status->status,['3',4]) ? 'PENDING' : (@$query->company_status->status == 2 ? 'REJECTED' : (@$query->company_status->status == 1 ? 'APPROVED': 'N/A'));
return ''.$string.'';
})->rawColumns(['action','username','status']);
}
/**
* Get the query object to be processed by dataTables.
*
* @return \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder|Collection
*/
public function query()
{
$creator = auth()->user()->id;
$query = DynamicUser::query()->whereHas('user',function($query) use($creator){
$query->where('user_id',$creator);
})->with('user');
return $this->applyScopes($query);
}
/**
* Optional method if you want to use html builder.
*
* @return Builder
*/
public function html()
{
return $this->builder()
->setTableId('dynamicusers-table')
->addCheckbox([
'defaultContent' => '',
'title' => ''
])
->columns($this->getColumns())
->ajax('')
// ->addAction(['width' => '140px'])
->addAction()
->dom('Bfrtip')
->buttons(
// Button::make('create'),
Button::make('reset'),
Button::make('reload')
);
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
'username'=>['searchable'=>'false'],
'email'=>['searchable'=>'false'],
'phone_number'=>['searchable'=>'false'],
'is_locked'=>['searchable'=>'false'],
'group'=>['searchable'=>'false'],
'created_at'
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'admin/companydatatables_' . time();
}
}