addColumn('action', function($query){
if($query->status == 'pending'){
return
'
Pending
';
}
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
'
Waiting
';
}
});
}
/**
* Get query source of dataTable.
*
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query()
{
$model = advert::query()->select('*');
// ->join('pub_sizes','adverts.size','pub_sizes.id')
// ->join('categories','adverts.cat_id','categories.cat_id')
// ->where('adverts.belong',auth::user()->id)
// ->select('adverts.*','pub_sizes.p_size','pub_sizes.location','pub_sizes.cost','categories.cat_name');
return $model;
}
/**
* Optional method if you want to use html builder.
*
// * @return \DataTables\Html\Builder
*/
public function html()
{
return $this->builder()
->columns($this->getColumns())
->minifiedAjax()
->addAction(['width' => '80px'])
->parameters($this->getBuilderParameters());
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
'id',
'cat_name',
'p_size',
'location',
'cost',
'pay_code',
'date1',
'status',
'created_at',
'updated_at'
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'My_data' . date('YmdHis');
}
}