get('access');
return $this->datatables
->queryBuilder($this->query())
->addColumn('action', function ($query) use ($access){
// $access = session()->get('access');
$action1 = '';
$action2 = '';
$action3 = '';
return $access == 2 ? $action2 : ($access ==3 ? $action3 : $action1);
})
->addColumn('username', function ($query) use ($access){
$username1 = ''.@$query->username.'';
$username2 = ''.@$query->username.'';
return $access == 2 ? $username1 : ($access == 3 ? $username2 : $username1);
})->addColumn('status',function ($query){
$string = in_array(@$query->status,['3',4]) ? 'PENDING' : (@$query->status == 2 ? 'REJECTED' : (@$query->status == 1 ? 'APPROVED': 'N/A'));
return ''.$string.'';
})
->editColumn('created_by',function ($query){
// return $query->users->created_by ?? 'N/A';
})->rawColumns(['username','action','status'])
->make(true);
}
/**
* Get the query object to be processed by dataTables.
*
* @return \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder|Collection
*/
public function query()
{
$from = $this->request()->get('from_date');
$to = $this->request()->get('to_date');
$type = $this->request()->get('type');
$status = $this->request()->get('status');
$from_date = Carbon::parse(Carbon::parse($from))->subDay(1);
$to_date = Carbon::parse(Carbon::parse($to))->addDay(1);
$access = session()->get('access');
$roleId = strtolower($type) == 'reseller' ?
Role::where('name', 'reseller')->firstOrFail()->id :
Role::where('name', 'user')->firstOrFail()->id;
if (!empty($from_date) && !empty($to_date) && !empty($status))
{
$query = Company::query()->whereHas('users',function ($res) use ($roleId){
$res->where('role_id',$roleId);
$res->where('created_by','messenger');
})->join('company_statuses','company_statuses.company_id','companies.id')
->where('company_statuses.status',$status)
->whereBetween('companies.created_at', [$from_date, $to_date])
->select('companies.*');
}
else if(!empty($from_date) && !empty($to_date) && !empty($type)) {
$query = Company::query()->whereHas('users',function ($res) use ($roleId){
$res->where('role_id',$roleId);
$res->where('created_by','messenger');
})->whereBetween('created_at', [$from_date, $to_date])
->select('companies.*');
}
else {
if ($access == 1) {
//
$query = DB::table('companies')
->join('users','companies.user_id','users.id')
->join('company_statuses','company_statuses.company_id','companies.id')
->where('users.created_by','messenger')
->where('companies.deleted_at',null)
->orderByDesc('company_status_id')->select('companies.*','users.username','users.id as uid','company_statuses.status');
}
elseif ($access == 2) {
$query = Company::query()->withTrashed()->join('company_statuses', 'companies.id', 'company_statuses.company_id')
->whereHas('users',function ($user){
$user->where('created_by','messenger');
})
->where('status', 3)
->orderBy('status', 'desc')
->select('companies.*')->latest();
}
elseif ($access == 3) {
$query = Company::query()->join('company_statuses', 'companies.id', 'company_statuses.company_id')
->whereHas('users',function ($user){
$user->where('created_by','messenger');
})
->orderBy('status', 'desc')
->select('companies.*')->latest();
}
else {
$query = Company::query()->whereHas('users',function ($user){
$user->where('created_by','messenger');
});
}
}
return $this->applyScopes($query);
}
/**
* Optional method if you want to use html builder.
*
* @return Builder
*/
public function html()
{
return $this->builder()
->columns($this->getColumns())
->ajax('')
->addAction(['width' => '140px'])
->parameters($this->getBuilderParameters());
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
'name',
'username'=>['searchable'=>'false'],
'legal_status'=>['width'=>'120px'],
'nature_of_business' =>['title'=>'N.O.B'] ,
'date_of_incorporation'=>['title'=>'Date of Inc.','width'=>'120px'],
'status'=>['searchable'=>'false'],
'created_at'=>['width'=>'120px'],
//
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'admin/companydatatables_' . time();
}
}