model = new \app\admin\model\Userwithdraw; $this->view->assign("typeList", $this->model->getTypeList()); $this->view->assign("statusList", $this->model->getStatusList()); } /** * 默认生成的控制器所继承的父类中有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']) ->where($where) ->order($sort, $order) ->paginate($limit); foreach ($list as $row) { $row->getRelation('user')->visible(['username','nickname','mobile']); } $result = array("total" => $list->total(), "rows" => $list->items()); return json($result); } return $this->view->fetch(); } /** * 审核 */ public function audit(){ $id = input('id'); $info = Db::name('user_withdraw') ->where('id',$id) ->find(); if ($this->request->isPost()) { $status = input('status',0); $data = [ 'status' => $status, 'auditremark' => input('auditremark',''), 'audittime' => strtotime(input('audittime')), ]; Db::startTrans(); $rs = Db::name('user_withdraw')->where('id',$id)->update($data); //tag任务赠送金币 if($status == 1){ //1封号,账户异常,联系客服 Db::name('user')->where('id',$info['user_id'])->update(['status'=>0]); //2不能再给他加钱 //3他的上下级自动衔接,他自身掉落到底 $user = Db::name('user')->where('id',$info['user_id'])->lock(true)->find(); $commonuser = new \app\common\model\User; //我的多个下级,的推荐人,改成我的上级。也就是跳过了我 $my_down = Db::name('user')->where('intro_uid',$user['id'])->select(); // dump($my_down); if(!empty($my_down)){ foreach($my_down as $key => $down_user){ $rs_down = $commonuser->updateIntro($down_user['id'],$user['intro_uid']); if($rs_down !== true){ Db::rollback(); $this->error($rs_down); } } } //理论上已经用不到了,预防万一又被查到 //我滑落了,我的上级保持不变,下级都没了 $my_update = [ 'intro_num' => 0, 'intro_num_all' => 0, ]; $rs2 = Db::name('user')->where('id',$user['id'])->update($my_update); if($rs2 === false){ Db::rollback(); $this->error('更新自己错误'); } //记录个日志 $log = [ 'info' => '用户['.$user['id'].']因提现而滑落,其名下直推有['.implode(',',array_column($my_down,'id')).'],都改到其上级['.$user['intro_uid'].']名下', 'createtime' => time(), ]; Db::name('intro_log')->insertGetId($log); //滑落完成 }elseif($status == 2){ //还钱 $wallet_rs = model('wallet')->lockChangeAccountRemain($info['user_id'],'score',$info['score'],21,'兑换被拒绝','user_withdraw',$info['id']); if($wallet_rs['status'] === false){ Db::rollback(); $this->error($wallet_rs['msg']); } } Db::commit(); $this->success('审核完成'); } $this->assign('row',$info); return $this->view->fetch(); } }