model = new \app\admin\model\Giftbaobilog; } public function import() { parent::import(); } /** * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法 * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑 * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改 */ /** * 查看 */ public function index() { //当前是否为关联查询 $this->relationSearch = true; //设置过滤方法 $this->request->filter(['strip_tags', 'trim']); if ($this->request->isAjax()) { //如果发送的来源是Selectpage,则转发到Selectpage if ($this->request->request('keyField')) { return $this->selectpage(); } list($where, $sort, $order, $offset, $limit) = $this->buildparams(); $list = $this->model ->with(['user','gift']) ->where($where) ->order($sort, $order) ->paginate($limit); foreach ($list as $row) { $row->getRelation('user')->visible(['username']); $row->getRelation('gift')->visible(['name']); } $pay_total_sum = $this->model->where($where)->order($sort, $order)->sum('pay_total'); $baobi_total_sum = $this->model->where($where)->order($sort, $order)->sum('baobi_total'); $result = array("total" => $list->total(), "rows" => $list->items(),"extend" => ['pay_total_sum'=>$pay_total_sum,'baobi_total_sum'=>$baobi_total_sum]); return json($result); } return $this->view->fetch(); } /** * 批量删除 */ public function batchdelete(){ if ($this->request->isPost()) { $gift_id = input('gift_id',0,'intval'); if(empty($gift_id)){ $this->error('请选择礼物'); } $rs = Db::name('gift_baobi_log')->where('gift_id',$gift_id)->delete(); $this->success('删除成功'); } return $this->fetch(); } }