datatables ->queryBuilder($this->query()) ->addColumn('action', function ($row){ return '

' . ' Networks' . '

'; }) ->make(true); } /** * 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 = DB::connection('kannel')->table('unit_prices'); 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()) ->setTableAttributes(['style'=>'font-size:13px;', 'cellspacing'=> '0']) ->ajax('') ->addAction(['width' => '100px']) ->parameters($this->getBuilderParameters()); } /** * Get columns. * * @return array */ protected function getColumns() { return [ 'username', 'currency', 'company', 'city', ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'adminuser_' . time(); } }