eloquent($query) ->addColumn('action', function ($row) { return '

' . 'Edit' . 'Delete' . '

'; }); } public function with_country($country_id) { $this->country_id = $country_id; return $this; } /** * Get the query object to be processed by dataTables. * * @return \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder|\Illuminate\Support\Collection */ public function query() { $query = Country::findOrFail($this->country_id)->networks()->orderBy('nice_name'); return $this->applyScopes($query); } /** * Optional method if you want to use html builder. * * @return \Yajra\Datatables\Html\Builder */ public function html() { return $this->builder() ->columns($this->getColumns()) ->ajax('') ->addAction(['width' => '150px']) ->parameters($this->getBuilderParameters()); } /** * Get columns. * * @return array */ protected function getColumns() { return [ 'nice_name' => ['title'=> 'Network Name'], 'full_name' => ['title'=> 'Registered Name'], 'code', 'sms_price', 'prefix' => ['title'=> 'Prefixes'] ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'countrynetworkdatatables_' . time(); } }