addColumn('created_at', function ($query) {
return date('l M d, Y', strtotime($query->created_at));
})
->editColumn('is_disqualified', function ($query) {
$getissue = IssuesResponse::where('user_id',$query->user_id)->where('proj_id',auth()->guard('adminguard')->user()->id)->where('status','Open')->count();
if ($query->application_status == 'Moved To Interview Stage') {
return '';
}
if ($query->project_stat === "Moved to Credit Analyst" && $query->is_disqualified !== 0&& $getissue==0) {
if ($query->is_disqualified==4) {
return '';
}elseif ($query->is_disqualified==3) {
return '';
}else{return '';}
}
if (empty($query->project_stat) && $query->is_disqualified === 0){
return '';
}
if (empty($query->project_stat) && $query->is_disqualified === 2){
return '';
}
if ($query->is_disqualified === 2&&$query->application_status=='Issues Detected'&& $getissue>0){
return '';
}
if ($query->project_stat === "Project Rejected" && $query->is_disqualified !== 0) {
return '';
}
})
->addColumn('action', function ($query) {
$a='';
$checkeva = DB::table('evaluation_sheet')->where('user_id',$query->user_id)->first();
$user=DB::table('users')->where('user_id',$query->user_id)->first();
$getissue = DB::table('issues_report')->where('user_id',$query->user_id)->where('proj_id',auth()->guard('adminguard')->user()->id)->where('status','Open')->count();
// return 'lop';
if ($checkeva ==null || $checkeva !==null && $checkeva->total==null) {
return '
';
}elseif($checkeva !==null&&$getissue==0&& $user->application_status == 'Under Review') {
return '
';
}elseif ($checkeva !==null&&$getissue>0) {
return '
';
}else {
return '
';
}
})
->rawColumns(['application_status','action','is_disqualified']);
}
/**
* Get query source of dataTable.
*
* @param \App\App\DashboardTable $model
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query()
{
$id = auth()->guard('adminguard')->user()->id;
$query = DB::select("select * from users where projectanalyst_id='$id' ");
return $this->applyScopes($query);
}
// public function query()
// {
// if (Session::get('adminrole') == 1) {
// $query = DB::select("select * from users");
// return $this->applyScopes($query);
// }elseif (Session::get('adminrole') == 2) {
// $query = DB::select("select * from users where is_disqualified = 0 or is_disqualified =2");
// return $this->applyScopes($query);
// }elseif (Session::get('adminrole') == 3) {
// $query = DB::select("select * from users where is_qualified");
// return $this->applyScopes($query);
// }
//
//
// }
/**
* Optional method if you want to use html builder.
*
* @return \Yajra\DataTables\Html\Builder
*/
public function html()
{
return $this->builder()
->setTableId('dashboardtable-table')
->columns($this->getColumns())
->minifiedAjax()
->dom('Bfrtip')
->orderBy(0)
->buttons(
Button::make('export'),
Button::make('print')
// Button::make('reset'),
);
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
Column::make('updated_at')->visible(false)->exportable(false)
->printable(false),
Column::make('applicant_name'),
// Column::make('company_name'),
Column::make('company_name'),
Column::make('email'),
Column::make('business_phone'),
// Column::make('application_stage'),
// Column::make('is_stage_complete'),
Column::make('is_disqualified')->title('Application Status'),
Column::make('created_at')->title('Date Applied'),
// Column::make('application_status'),
Column::computed('action')
->exportable(false)
->printable(false)
->width(60)
->addClass('text-center'),
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'DashboardTable_' . date('YmdHis');
}
}