model = model('InviteRecord'); $this->view->assign("payTypeList", $this->model->getPayTypeList()); $this->view->assign("statusList", $this->model->getStatusList()); $this->view->assign("platname",Config("site.name")); } /** * 查看 */ public function index() { //设置过滤方法 $this->request->filter(['strip_tags']); if ($this->request->isAjax()) { //如果发送的来源是Selectpage,则转发到Selectpage if ($this->request->request('pkey_name')) { return $this->selectpage(); } list($where, $sort, $order, $offset, $limit) = $this->buildparams(); $today = date("Ymd"); $total = $this->model ->alias("a") ->where($where) ->order($sort, $order) ->count(); //今日赏金金额 $todayreward = $this->model ->alias("a") ->join('reward_collect b',"a.admin_id=b.admin_id AND b.createdate='{$today}' AND b.type=1 AND b.flag=1") ->where($where) ->where("a.invite_id={$this->auth->id}") ->sum("reward"); //累计赏金金额 $totalreward = $this->model ->alias("a") ->join('reward_collect b','a.admin_id=b.admin_id AND b.flag=1 AND b.type=2') ->where($where) ->where("a.invite_id={$this->auth->id}") ->sum("reward"); $join = [ ['admin b','a.admin_id=b.id','LEFT'], ['reward_collect c',"a.admin_id=c.admin_id AND c.createdate='{$today}' AND c.type='1' AND c.flag='1'",'LEFT'], ['reward_collect d',"a.admin_id=d.admin_id AND d.flag='1' AND d.type='2'",'LEFT'] ]; $list = $this->model ->alias("a") ->join($join) ->where($where) ->where("a.invite_id={$this->auth->id}") ->field("a.id,a.admin_id,a.username,a.pay_type,a.nickname,a.status,a.invite_time,b.nickname realnickname,c.reward dayreward,d.reward totalreward") ->order('a.id','desc') ->limit($offset, $limit) ->select(); $data['todayreward'] = $todayreward; $data['totalreward'] = $totalreward; $result = array("total" => $total, "rows" => $list, "countdata" => $data); return json($result); } return $this->view->fetch(); } /** * 申请 */ public function agentapply() { if ($this->request->isPost()) { $params = $this->request->post("row/a"); if ($params) { $res = []; $info = $this->model->where(['username' => $params['username']])->find(); $admininfo = model("admin")->where(['username' => $params['username']])->find(); if($info || $admininfo){ $res['err'] = -1; $this->error('用户名重复'); }else{ $params['invite_time'] = time(); try { $result = $this->model->allowField(true)->save($params); if ($result !== false) { $res['err'] = 0; $res['username']=$params['username']; $res['invite_id']=$params['invite_id']; $this->success('申请成功','/admin/reward/inviterecord/invsuccess?invid='.$params['invite_id'].'&username='.$params['username']); } else { $this->error($this->model->getError()); } } catch (\think\exception\PDOException $e) { $this->error($e->getMessage()); } } return json($res); } $this->error(__('Parameter %s can not be empty', '')); }else{ $this->assign('title',Config("site.name").'账号申请表'); $getparams = $this->request->get(); $invite_id = $getparams['referid']; $rewardurl = model("Rewardurl"); $contact_typelist = $rewardurl->contacttypearr; $urlinfo = $rewardurl->where("admin_id={$invite_id}")->find(); $invite_msg = $contact_typelist[$urlinfo['contact_type']].":".$urlinfo['account']; $this->assign("invite_id",$invite_id); $this->assign("invite_msg",$invite_msg); } return $this->view->fetch(); } public function invsuccess(){ $this->assign('title','申请成功'); $params = $this->request->get(); $admin_id = $params['invid']; $rewardurl = model("Rewardurl"); $contact_typelist = $rewardurl->contacttypearr; $urlinfo = $rewardurl->where("admin_id={$admin_id}")->find(); $invite_msg = $contact_typelist[$urlinfo['contact_type']].":".$urlinfo['account']; $this->assign("invite_msg",$invite_msg); $this->view->assign("username",$params['username']); return $this->view->fetch(); } /** * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个方法 * 因此在当前控制器中可不用编写增删改查的代码,如果需要自己控制这部分逻辑 * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改 */ }