applyModel = new ChannelApplyModel; } /** * 发币申请列表 */ public function index() { $where = $this->getListCondition(); $param = input('request.'); //分页带条件 $list = $this->applyModel ->field('*') ->where($where) ->order('status asc,create_time desc') ->paginate(10,false,array('query' => $param)); // 获取分页显示的HTML $page = $list->render(); //后台管理员列表 $adminList = model('Admin')->field('id,username as name')->where(['status'=>1,'type'=>1])->order('username asc')->select(); $this->assign('page', $page); $this->assign('list',$list); $this->assign('admin_list',$adminList); return $this->fetch('list'); } /** * 发币申请列表的查询条件 * * @return array $where 查询条件 */ private function getListCondition() { $start_time = input('request.start_time',date('Y-m-d')); //渠道名 if(input('request.username')!='') { $where['username'] = input('request.username','','trim'); } //手机号 if(input('request.linkman_mobile')!='') { $where['linkman_mobile'] = input('request.linkman_mobile','','trim'); } //审核状态 if(input('request.status')!='') { $where['status'] = input('request.status',0,'intval'); } //开始时间和结束时间不为空时 if ($start_time != '' && input('request.end_time') != '') { $where['create_time'] = [ ['>=', strtotime($start_time)], ['<=', strtotime(input('request.end_time').' 23:59:59')], ]; } //开始时间不为空时 elseif ($start_time!= '') { $where['create_time'] = ['>=', strtotime($start_time)]; } //结束时间不为空时 elseif (input('request.end_time') != '') { $where['create_time'] = ['<=', strtotime(input('request.end_time').' 23:59:59')]; } return $where; } /** * 审核 * */ public function audit() { if (request()->isAjax()) { $id = input('id',0,'intval'); $contact_admin_id = input('contact_admin_id',0,'intval'); $beizhu = input('beizhu','','trim'); $status = input('status','0','intval'); if(empty($id)){ $this->error('ID不能为空'); } if($status<>1 && $status<>2){ $this->error('非法审核状态'); } if($status==1 && !$contact_admin_id){ $this->error('请选择对接人'); } $applyInfo = model('ChannelApply')->where(['id' => $id])->find(); if(empty($applyInfo)){ $this->error('渠道注册申请不存在'); } if($applyInfo['status'] <> 0){ $this->error('该渠道注册申请已审核过'); } if($status==1){ $channelInfo = model('Channel')->where(['name' => $applyInfo['username']])->find(); if ( $channelInfo ) { $this->error('该渠道信息已存在'); } $userInfo = model('Admin')->field('id')->where(['username' => $applyInfo['username']])->find(); if ($userInfo) { $this->error("该用户名已存在! "); } } $auditData = array(); $auditData['id'] = $id; $auditData['status'] = $status; $auditData['audit_time'] = NOW_TIMESTAMP; $auditData['beizhu'] = $beizhu; $auditData['contact_admin_id'] = $contact_admin_id; $auditData['audit_admin_id'] = session('ADMIN_ID'); Db::startTrans(); try { if($status==1){ $channelInfo = model("Channel")->where(['name' => $applyInfo['username']])->find(); if ( $channelInfo ) { throw new Exception("该渠道信息已存在"); } $userInfo = model("Admin")->field('id')->where(['username' => $applyInfo['username']])->find(); if ($userInfo) { throw new Exception("用户名已存在! "); } //添加渠道信息 $channelModel = model('channel'); $channelModel->save([ 'name' => $applyInfo['username'], 'parent_id' => config('TOP_CHANNEL_ID'), 'id_path' => ','.config('TOP_CHANNEL_ID').',', 'create_time' => $applyInfo['create_time'], 'flag' => 3, 'show_full_account' => 0, 'remark' => $beizhu, 'status' => 1]); // echo $channelModel->id."----channelModel->id-----
"; if ( !$channelModel->id) { throw new Exception("添加渠道信息失败"); } $channelData = array(); $channelData['channel_id'] = $channelModel->id; $channelData['real_name'] = $applyInfo['real_name']; $channelData['account_wechat'] = $applyInfo['account_wechat']; $channelData['account_qq'] = $applyInfo['account_qq']; $channelData['account_type'] = $applyInfo['account_type']; $channelData['alipay_realname'] = $applyInfo['alipay_realname']; $channelData['alipay_account'] = $applyInfo['alipay_account']; $channelData['bank_account'] = $applyInfo['bank_account']; $channelData['company_name'] = $applyInfo['company_name']; $channelData['bank_name'] = $applyInfo['bank_name']; $channelData['linkman_email'] = $applyInfo['linkman_email']; $channelData['business_mode_public'] = $applyInfo['business_mode_public']; $channelData['business_mode_private'] = $applyInfo['business_mode_private']; $channelData['company_scale'] = $applyInfo['company_scale']; $channelData['promote_games'] = $applyInfo['promote_games']; $channelData['promote_platforms'] = $applyInfo['promote_platforms']; $channelData['company_has_shop'] = $applyInfo['company_has_shop']; $channelData['shop_platform'] = $applyInfo['shop_platform']; $channelData['shop_address'] = $applyInfo['shop_address']; $channelData['shop_name'] = $applyInfo['shop_name']; $channelData['linkman_address'] = $applyInfo['linkman_address']; $channelData['linkman_mobile'] = $applyInfo['linkman_mobile']; $channelData['create_time'] = $applyInfo['create_time']; $channelData['audit_time'] = NOW_TIMESTAMP; $channelData['contact_admin_id'] = $contact_admin_id; $channelData['audit_admin_id'] = session('ADMIN_ID'); $channelData['update_time'] = NOW_TIMESTAMP; $channelData['admin_id'] = session('ADMIN_ID'); $insertChannelResult = model("ChannelInfo")->insertGetId($channelData); // echo $insertChannelResult."----insertChannelResult-----
"; if ($insertChannelResult === false) { throw new Exception("添加渠道更多信息失败"); } $adminData = array(); $adminData['username'] = $applyInfo['username']; $adminData['password'] = $applyInfo['password']; $adminData['pay_password'] = $applyInfo['pay_password']; $adminData['type'] = 2; $adminData['channel_id'] = $channelModel->id; $adminData['beizhu'] = $beizhu; $adminData['status'] = 1; $adminData['mobile'] = $applyInfo['linkman_mobile']; $adminData['create_time'] = $applyInfo['create_time']; $adminData['password_update_time'] = NOW_TIMESTAMP; $insertAdminResult = model("Admin")->insertGetId($adminData); // echo $insertAdminResult."----insertAdminResult-----
"; if ($insertAdminResult === false) { throw new Exception("添加管理员账号失败"); } $auditData['channel_id'] = $channelModel->id; $result = $this->applyModel->where(['id'=>$id])->update($auditData); // echo $result."---result-----
"; if ($result === false) { throw new Exception("审核修改状态失败"); } $this->insertLog($this->current_node, "渠道审核表审核通过新增子渠道:".$applyInfo['username'].",状态:正常",41); } else if($status==2){ $result = $this->applyModel->where(['id'=>$id])->update($auditData); if ($result === false) { throw new Exception("审核修改状态失败"); } } Db::commit(); // $this->success('审核成功'); } catch (\Exception $e) { Db::rollback(); $this->error("添加失败: " . $e->getMessage()); } $this->success('审核成功'); } else{ $this->error('非法请求'); } } }