addColumn('action', function($query){
if($query->status == '0'){
return
'
Disabled
';
}
elseif($query->status == '1'){
return
'
Enabled
';
}
});
}
/**
* Get query source of dataTable.
*
* @param \App\User $model
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query()
{
$model = DB::table('pub_sizes')->select('*');
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 [
// 'id',
'p_type',
'cost',
'category',
'status',
'created_at',
'updated_at'
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'Advert_' . date('YmdHis');
}
}