addColumn('action', function($query){
return
'
View
';
});
}
/**
* Get query source of dataTable.
*
* @param \App\User $model
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query()
{
$model = DB::table('adverts')->join('users','adverts.belong','users.id')
->where('adverts.status','pending')
->select('adverts.*','users.name','users.id as user')->latest();
return $model;
}
/**
* 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($this->getBuilderParameters());
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
'name',
'size',
'cat_id',
'pay_code',
'amt_tbp',
'format'=>['title'=>'Format'],
'date1',
'created_at',
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'Advert_' . date('YmdHis');
}
}