eloquent($query)
->addColumn('action',function ($query){
return '';
})
->addColumn('is_active',function ($query){
return $query->is_active ? 'active' : 'disabled';
})
->editColumn('cost', function ($query){
return "GHC $query->cost ";
})
->rawColumns(['cost','action']);
}
public function query()
{
$query = MediaPrice::query();
return $this->applyScopes($query);
}
/**
* Optional method if you want to use html builder.
*
* @return Builder
*/
public function html()
{
return $this->builder()
->columns($this->getColumns())
->ajax('')
->addAction(['width' => '100px'])
->parameters($this->getBuilderParameters());
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
'name',
'cost',
'is_active'=>['title'=>'Status'],
'apply_to',
'package_type',
'no_of_post'=>['title'=>'Available Posts'],
'created_at',
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'socialpricingdatatables_' . time();
}
}