model = new \app\admin\model\egg\Gift; $this->view->assign("isUseList", $this->model->getIsUseList()); } 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(['eggjackpot']) ->where($where) ->order($sort, $order) ->paginate($limit); $totalMoney = $this->model->with(['eggjackpot'])->where($where)->sum('price'); foreach ($list as $row) { $row->getRelation('eggjackpot')->visible(['name','type']); } $result = array("total" => $list->total(), "rows" => $list->items(), "extend" => ['total_price' => $totalMoney]); return json($result); } return $this->view->fetch(); } /** * 添加 */ public function add() { if ($this->request->isPost()) { $gift_id = $this->request->post('gift_id'); $jackpot_id = $this->request->post('jackpot_id'); $number = $this->request->post('number'); $gift_info = Db::name('gift')->where('id',$gift_id)->find(); if(empty($gift_info)){ $this->error('不存在的礼物'); } $jackpot_info = Db::name('egg_jackpot')->where('id',$jackpot_id)->find(); $data_all = []; for($i=1;$i<=$number;$i++){ $one = [ 'gift_id' => $gift_id, 'image' => $gift_info['image'], 'special' => $gift_info['special'], 'gift_name' => $gift_info['name'], 'Jackpot_id' => $jackpot_id, 'prize_no' => 0, 'price' => $gift_info['price'], 'is_use' => 0, 'starttime' => $jackpot_info['starttime'], ]; $data_all[] = $one; } Db::startTrans(); $rs = Db::name('egg_gift')->insertAll($data_all); Db::commit(); $this->success('添加完成'); } return $this->view->fetch(); } }