addColumn('action', function($query){
if($query->status == 'pending'){
return
'
';
}
else if($query->status == 0){
return
'
Rejected
';
}
else if($query->status == 1 && $query->clear == 1){
return
'
published
';
}
else if($query->status == 1 && $query->clear == 0)
{
return
'';
}
})->editColumn('status',function ($query){
if($query->status == 'pending'){
$action = '';
}
elseif ($query->status == 0)
{
$action = '';
}elseif ($query->status == 1 && $query->clear == 1){
$action = '';
}
elseif ($query->status == 1 && $query->clear == 0){
$action = '';
}
else{
$action = '';
}
return $action;
})->rawColumns(['action','status']);
}
/**
* Get query source of dataTable.
*
* @param \App\User $model
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query(advert $model)
{
// $model = advert::query()->select('*');
// return $model;
return $model->newQuery()->where('belong',Auth::user()->id)->select('*');
}
/**
* Optional method if you want to use html builder.
*
* @return \Yajra\DataTables\Html\Builder
*/
public function html()
{
return $this->builder()
->columns($this->getColumns())
->minifiedAjax()
->addAction(['width' => '80px'])
->parameters([
'dom' => 'Bfrtip',
'buttons' => ['csv', 'excel', 'reload'],
'order' => [[4, 'asc']],
]);
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
'cat_id'=>['title'=>'Category','width'=>'100'],
'size'=>['title'=>'Size','width'=>'100'],
'amt_tbp'=>['title'=>'Cost','width'=>'70'],
'pay_code'=>['title'=>'Code'],
'date1'=>['title'=>'Date','width'=>'100'],
'status',
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'My_' . date('YmdHis');
}
}