addColumn('action', 'pastforecast.action')
->editColumn('created_at', function($query){
return $query->created_at->format('Y:m:d H:i:s');
})
->editColumn('updated_at', function($query){
return $query->updated_at->format('Y:m:d H:i:s');
})
->editColumn('status', function($query){
$status = ucfirst($query->status) ?? 'N/A';
if (strtolower($status) == 'active') {
return "$status";
} else {
return "$status";
}
})
->editColumn('payment_status', function($query){
$payment_status = ucfirst($query->payment_status) ?? 'N/A';
if (strtolower($payment_status) == 'active') {
return "$payment_status";
} else {
return "$payment_status";
}
})
->addColumn('action', function($query){
return '
';
})
->rawColumns(['action', 'status', 'payment_status'])
->setRowId('id');
}
/**
* Get the query source of dataTable.
*/
public function query(Subscriber $model): QueryBuilder
{
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('status')->addClass('text-center'),
Column::make('payment_status')->addClass('text-center'),
Column::make('subscription_date'),
Column::make('subscription_expiry'),
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');
}
}