eloquent($query)
->orderColumn('created_at', function ($query, $order) {
$query->orderBy('id', $order);
})
->editColumn('is_disqualified', function ($query) {
if ($query->is_disqualified === null) {
return '';
}elseif ($query->is_disqualified === '0') {
return '';
}elseif ($query->is_disqualified === '1'||$query->is_disqualified === '3') {
return '';
}
elseif ($query->is_disqualified === '2') {
return '';
}elseif ($query->is_disqualified === '4') {
return '';
}
})
->editColumn('created_at', function ($query) {
return $query->created_at->format('d M, Y');// human readable format
})
->addColumn('action', function($query){
return '
';
})
->rawColumns(['action','is_disqualified']);
}
/**
* Get query source of dataTable.
*
* @param \App\App\UnderReviewApplication $model
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query()
{
$query = RejectedAppMove::where('is_disqualified','3')->where('reason','!=','Failed to meet requirement to go to financials page.');
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('underreviewapplication-table')
->columns($this->getColumns())
->minifiedAjax()
->dom('Bfrtip')
->orderBy(0)
->buttons(
// Button::make('create'),
Button::make('export'),
Button::make('print')
// Button::make('reset'),
// Button::make('reload')
);
}
/**
* 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('reason'),
// Column::make('is_stage_complete'),
Column::make('is_disqualified')->title('Application Status'),
Column::make('created_at')->title('Date Applied'),
Column::computed('action')
->exportable(false)
->printable(false)
->width(60)
->addClass('text-center'),
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'UnderReviewApplication_' . date('YmdHis');
}
}