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') // ->join('categories','adverts.cat_id','categories.cat_id') // ->join('pub_sizes','adverts.size','pub_sizes.id')->where([['adverts.status','1'],['adverts.clear','1']]) // ->select('adverts.*','categories.cat_name','pub_sizes.p_size','pub_sizes.location','pub_sizes.cost','users.name','users.id as user')->latest(); // return $model; $model = DB::table('adverts')->join('users','adverts.belong','users.id') ->where([['adverts.status',1],['adverts.clear',1]]) ->select('adverts.*','users.name','users.id as user'); 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'); } }