addColumn('action', 'pastforecast.action')
->editColumn('status', function($query){
$status = ucfirst($query->status) ?? 'N/A';
if (strtolower($status) == 'success') {
return "$status";
}
elseif (strtolower($status) == 'failed') {
return "$status";
}
elseif (strtolower($status) == 'picked'){
return "Pending";
}
else {
return "Unknown";
}
})
->editColumn('created_at', function($query){
return $query->created_at ? $query->created_at->format('Y:m:d H:i:s') : 'N/A';
})
->editColumn('updated_at', function($query){
return $query->updated_at ? $query->updated_at->format('Y:m:d H:i:s') : 'N/A';
})
->rawColumns(['action', 'status'])
->setRowId('id');
}
/**
* Get the query source of dataTable.
*/
public function query(Payment $model): QueryBuilder
{
$data = $this->my_data;
$phone = $data['phone'];
$start_date = $data['start_date'];
$end_date = $data['end_date'];
$status = $data['status'];
if ($phone !== null && $phone !== '' && ($status == null || $status == 'null') && $start_date == null && $end_date == null) {
// return Payment::query()->where('phone', 'like', $phone);
$query = Payment::query()->where('phone', $phone);
// ->where('status', $status)
// ->where(function ($query) use ($start_date, $end_date) {
// $query->whereRaw("DATE(created_at) BETWEEN ? AND ?", [$start_date, $end_date])
// ->orWhereRaw("DATE(created_at) = ?", [$start_date]);
// });
return $query;
}
if ($phone !== null && $phone !== '' && $status !== null && $status !== 'null' && $start_date !== null && $end_date !== null) {
// return Payment::query()->where('phone', 'like', $phone);
$query = Payment::query()->where('phone', $phone)
->where('status', $status)
->where(function ($query) use ($start_date, $end_date) {
$query->whereRaw("DATE(created_at) BETWEEN ? AND ?", [$start_date, $end_date])
->orWhereRaw("DATE(created_at) = ?", [$start_date]);
});
return $query;
}
if ($phone !== null && $phone !== '' && ($start_date !== null) && ($end_date !== null)) {
$query = Payment::query()
->where('phone', $phone)
->where(function ($query) use ($start_date, $end_date) {
$query->whereRaw("DATE(created_at) BETWEEN ? AND ?", [$start_date, $end_date])
->orWhereRaw("DATE(created_at) = ?", [$start_date]);
});
return $query;
}
if ($status !== null && $phone !== null && $phone !== '') {
return Payment::query()->where('phone',$phone)->where('status', $status);
}
if ($status !== null && $status !== 'null') {
return Payment::query()->where('status', $status);
}
if ($start_date !== null && $end_date !== null && $phone == null && $status !== null) {
return Payment::query()->whereBetween('created_at', [$start_date, $end_date]);
}
if ($start_date !== null) {
return Payment::query()->where(function ($query) use ($start_date) {
$query->whereRaw("DATE(created_at) = ?", [$start_date]);
});
}
// elseif ($phone !== null && $status == null && $start_date == null && $end_date == null) {
// return Payment::query()->where('phone', 'like', $phone);
// }
else {
return $model->newQuery();
}
}
/**
* Optional method if you want to use the html builder.
*/
public function html(): HtmlBuilder
{
return $this->builder()
->setTableId('pastforecast-table')
->columns($this->getColumns())
->minifiedAjax()
->dom('lBfrtip')
->orderBy(1)
->selectStyleSingle()
->buttons([
Button::make('excel'),
Button::make('csv'),
Button::make('pdf'),
Button::make('print'),
// Button::make('reset'),
// Button::make('reload')
]);
}
/**
* Get the dataTable columns definition.
*/
public function getColumns(): array
{
return [
Column::make('id')->visible(false),
Column::make('phone'),
Column::make('amount'),
Column::make('status'),
Column::make('due_date'),
Column::make('network'),
Column::make('created_at'),
Column::make('updated_at'),
// Column::computed('action')
// ->exportable(false)
// ->printable(false)
// ->width(60)
// ->addClass('text-center'),
];
}
/**
* Get the filename for export.
*/
protected function filename(): string
{
return 'PastForecast_' . date('YmdHis');
}
}