eloquent($query)
->editColumn('trans_status', function($query){
$status = ucfirst($query->trans_status) ?? 'N/A';
if (strtolower($status) == 'successful') {
return "$status";
} else {
return "$status";
}
})
->editColumn('created_at', function($query){
return $query->created_at->format('Y:m:d H:i:s') ?? 'N/A';
})
->addColumn('action', 'transactiondatatable.action')
->rawColumns(['action', 'trans_status']);
}
/**
* Get query source of dataTable.
*
* @param \Models/Transaction $model
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query(Transaction $model)
{
return $model->newQuery();
}
/**
* Optional method if you want to use html builder.
*
* @return \Yajra\DataTables\Html\Builder
*/
public function html()
{
return $this->builder()
->setTableId('transactiondatatable-table')
->columns($this->getColumns())
->minifiedAjax()
->dom('lBfrtip')
->orderBy(1)
->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('id')->visible(false),
Column::make('phone')->addClass('text-center')->title("Subscriber's Contact"),
Column::make('trans_id')->addClass('text-center')->title('Transaction ID'),
Column::make('trans_status')->addClass('text-center')->title('Transaction Status'),
Column::make('created_at')->addClass('text-center'),
// Column::make('updated_at'),
// Column::computed('action')
// ->exportable(false)
// ->printable(false)
// ->width(60)
// ->addClass('text-center'),
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename(): string
{
return 'Transaction_' . date('YmdHis');
}
}