request; if ($retuest->isAjax) { if ($retuest->isGet) { $get = Yii::$app->request->get(); // 检查提交的参数 $res = Yii::$app->services->validate->validate($get,[ [['id','level'], 'integer'], [['id','keyword','user_id','datetime'], 'safe'], ]); if($res === false) return $this->error(Yii::$app->services->validate->getErrorMessage()); $configs = Yii::$app->services->setting->addons->get($this->mall_id, ServeBonusEnum::ADDONS_NAME, 'basic'); // 获取服务商等级 $level_list = ServeBonusLevel::getServeBonusLevel([['mall_id' => $this->mall_id]],[],true,'level,name'); // 升级类型 $upgrade_type = LevelEnum::getUpgradeType(); $where = $parents = $list = []; $where[] = ['=', 'status', StatusEnum::ENABLED]; $where[] = ['=', 'mall_id', $this->mall_id]; !empty($get['level']) && $where[] = ['=', 'level', $get['level']]; !empty($get['user_id']) && $where[] = ['=', 'user_id', $get['user_id']]; if($get['datetime']) $where[] = ['between', 'created_at', strtotime($get['datetime'][0]),strtotime($get['datetime'][1])]; // 根据搜索手机号查询用户id if (!empty($get['keyword'])) { $user_ids = User::find()->select("id")->where(['mall_id' => $this->mall_id])->andWhere(['like', 'mobile', $get['keyword'] . '%', false])->asArray()->column(); if (empty($user_ids)) $this->success('获取成功', compact('list','level_list', 'upgrade_type', 'parents')); $where[] = ['in', 'user_id', $user_ids]; } $with = ['user']; $order = 'created_at desc'; $params = array('where' => $where, 'order'=>$order, 'with' => $with, 'limit' => $get['limit']); $list = ServeBonus::listPage($params, false, true); if (isset($list['list'])) { // 获取用户上级推荐人id $parent_ids = []; $team_statistics = UserTeamStatistics::find()->where(['mall_id' => $this->mall_id, 'user_id' => array_column($list['list'], 'user_id')])->indexBy('user_id')->asArray()->all(); $user_statistics = UserStatisticsTotal::find()->where(['mall_id' => $this->mall_id, 'user_id' => array_column($list['list'], 'user_id')])->indexBy('user_id')->asArray()->all(); foreach ($list['list'] as &$ServeBonus) { $parent_ids[] = $ServeBonus['user']['parent_id']; if ($configs['achievement_count_method'] == 0) { // 支付完成 $ServeBonus['total_price'] = bcadd(($team_statistics[$ServeBonus['user_id']]['user_team_order_price_total'] ?? 0), ($user_statistics[$ServeBonus['user_id']]['pay_money'] ?? 0), 2); } else { // 订单完成 $ServeBonus['total_price'] = bcadd(($team_statistics[$ServeBonus['user_id']]['team_finish_order_price_total'] ?? 0), ($user_statistics[$ServeBonus['user_id']]['finish_order_money'] ?? 0), 2); } } if ($parent_ids) { // 获取上级用户信息 $parents = User::getUserList([['in','id',array_unique($parent_ids)]], 'id,nickname', [], 1); $parents = array_column($parents, 'nickname', 'id'); } } $this->success('获取成功', compact('list','level_list', 'upgrade_type', 'parents')); } } else { return $this->render($this->action->id); } } /** * 添加服务商 * @Author: ltm * @DateTime: 2021/10/21 0021 17:56 * @Copyright: copyright (c) 2021 广东七件事集团 */ public function actionAddServeBonus() { $retuest = Yii::$app->request; if ($retuest->isAjax) { if ($retuest->isPost) { $params = Yii::$app->request->post(); $res = Yii::$app->services->validate->validate($params,[[['mobile','level'], 'integer'], [['mobile','level'], 'required']]); if($res === false) return $this->error(Yii::$app->services->validate->getErrorMessage()); // 根据手机号码获取用户id $user = User::getOne([['mall_id' => $this->mall_id], ['mobile' => $params['mobile']]],true,[],false,'id'); if (empty($user)) return $this->error('暂无此用户'); $params['mall_id'] = $this->mall_id; $params['user_id'] = $user['id']; // 保存数据 $res = ServeBonus::setData($params); if (!$res) return $this->error(ServeBonus::getStaticError()); // 同步服务商业绩 Yii::$app->services->rabbitMq->push(RabbitMqEnum::EXCHANGE_LONG_DURATION, RabbitMqEnum::LONG_DURATION_QUEUE, ['mall_id' => $this->mall_id, 'user_id' => $user['id']], UserTeamMonthStatistics::class, 'calculatePerformance'); $this->success('服务商添加成功'); } } } /** * 根据用户名搜索用户 * @Author: ltm * @DateTime: 2021/10/21 0021 18:36 * @Copyright: copyright (c) 2021 广东七件事集团 * @return mixed|void */ public function actionSelectUser() { $retuest = Yii::$app->request; if ($retuest->isAjax && $retuest->isPost) { $params = Yii::$app->request->post(); $res = Yii::$app->services->validate->validate($params,[[['keyword'], 'string'], [['keyword'], 'required']]); if($res === false) return $this->error(Yii::$app->services->validate->getErrorMessage()); // 搜索用户列表 $list = User::getUserList([['mall_id' => $this->mall_id],['like','mobile',$params['keyword']]], 'id,mobile', [], 1); $this->success('获取成功', $list); } } /** * 服务商数据编辑 * @Author: ltm * @DateTime: 2021/10/23 0023 9:20 * @Copyright: copyright (c) 2021 广东七件事集团 * @return mixed|void */ public function actionEdit() { $retuest = Yii::$app->request; if ($retuest->isAjax) { if ($retuest->isPost) { $params = Yii::$app->request->post(); $res = Yii::$app->services->validate->validate($params,[ [['user_id'], 'required'], [['remark'], 'string'], [['user_id','status','level'], 'integer'] ]); if($res === false) return $this->error(Yii::$app->services->validate->getErrorMessage()); $params = ServeBonus::exceptNullVal($params); $params['mall_id'] = $this->mall_id; // 修改等级操作 if (!empty($params['level'])) { $params['upgrade_status'] = LevelEnum::UPGRADE_MANUAL; $params['upgrade_level_at'] = time(); } // 保存数据 $res = ServeBonus::setData($params); if (!$res) return $this->error(ServeBonus::getStaticError()); // 同步服务商业绩 Yii::$app->services->rabbitMq->push(RabbitMqEnum::EXCHANGE_LONG_DURATION, RabbitMqEnum::LONG_DURATION_QUEUE, ['mall_id' => $this->mall_id, 'user_id' => $res['user_id']], UserTeamMonthStatistics::class, 'calculatePerformance'); $this->success('修改成功'); } } } // 团队业绩 public function actionTeamPrice() { $request = \Yii::$app->request; if ($request->isAjax) { if ($request->isGet) { $user_id = $request->get('user_id'); if (!is_numeric($user_id)) { return $this->error('参数错误'); } $data = AchievementLogic::getUserAchievement($user_id, $this->mall_id); $this->success('获取成功', $data); } } return $this->error('错误请求'); } }