get('access');
return datatables()
->eloquent($query)
->addColumn('action', function ($query) use ($access){
$action1 = '';
$action2 = '';
$action3 = '';
return $access == 2 ? $action2 : ($access ==3 ? $action3 : $action1);
})
->addColumn('username', function ($query) use ($access){
$username1 = ''.@$query->users->username.'';
$username2 = ''.@$query->users->username.'';
return $access == 2 ? $username1 : ($access == 3 ? $username2 : $username1);
})->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'])
->addColumn('unit_price', function($query){
return @$query->users->credit->price;
})
->addColumn('client_type', function($query) {
return $query->users->company->client_type ?? 'not applicable';
})
->addColumn('contract_status', function($query) {
return 'signed';
});
// ->addColumn('old_balance', function($query) {
// return @$query->users->credit->old_bal;
// })
// ->addColumn('new_balance', function($query) {
// return @$query->users->credit->new_bal;
// })
// ->addColumn('last_date_of_crediting', function($query) {
// return @$query->users->creditHistory->reverse()->first()->date_credited;
// });
}
/**
* 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);
$roleId = strtolower($type) == 'reseller' ?
Role::where('name', 'reseller')->firstOrFail()->id :
Role::where('name', 'user')->firstOrFail()->id;
$query = Company::query()
->join('company_statuses','company_statuses.company_id','companies.id')
->whereHas('users')
->orderByDesc('company_statuses.status')
->select('companies.*');
if (!empty($from_date) && !empty($to_date) && !empty($status))
{
$query = Company::query()
->join('company_statuses','company_statuses.company_id','companies.id')
->whereHas('users',function ($user){
$user->where('created_by','npontu');
})->orderByDesc('company_statuses.status')
->select('companies.*');
}
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'])
->dom('Bfrtip')
->buttons(
Button::make('export'),
Button::make('print'),
Button::make('reset'),
Button::make('reload')
);
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
'name',
'username'=>['searchable'=>'false'],
'contact_person'=>['width'=>'120px'],
'contact_person_phone'=>['title'=>'Phone','width'=>'120px'],
'nature_of_business' =>['title'=>'N.O.B'] ,
'status'=>['searchable'=>'false'],
'created_at'=>['width'=>'120px'],
'unit_price',
'client_type',
'contract_status',
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'admin/companydatatables_' . time();
}
}