db->beginTransaction(); try { $mall_id = $order['mall_id']; $user_id = $order['user_id']; $parent_id = $order['wechat_video_shop_parent_id'] ?? 0; // 获取基础配置 $configs = \Yii::$app->services->setting->addons->get($mall_id, $identity_desc, 'basic'); $is_open_level_limit = !empty($configs['is_open_level_limit']); // 是否为一级一级升 $upgrade_uid = 0; // 获取身份 $model = $identity_obj::findOne(['mall_id' => $mall_id, 'user_id' => $user_id, 'status' => StatusEnum::ENABLED]); if (empty($model)) { // 如果没有身份,那么就不能进行升级 $trans->commit(); return $upgrade_uid; } $where = []; $where[] = ['mall_id' => $mall_id]; $where[] = ['status' => StatusEnum::ENABLED]; $where[] = ['>', 'level' , $model->level]; $params = []; $params['where'] = $where; $params['order'] = $order_by; // 获取等级 $level_list = $level_obj::lists($params); $where = []; $where[] = ['mall_id' => $mall_id]; $where[] = ['order_id' => $order['id']]; $where[] = ['user_id' => $user_id]; $params =[]; $params['where'] = $where; $order_detail_list = OrderDetail::lists($params); $buy_goods_id_arr = array_column($order_detail_list, 'goods_id'); $can_upgrade_level = 0; $upgrade_status = 0; $flag = false; //开启购买升级商品 if (!empty($level_list)) { foreach ($level_list as $level_arr) { $can_upgrade_level = $level_arr['level']; //开启购买升级商品 if ($level_arr['upgrade_type_goods']&&$level_arr['is_auto_upgrade']) { $upgrade_status = UpgradeEnum::UPGRADE_STATUS_GOODS; $goods_id_arr = Json::decode($level_arr['goods_ids'], true); $res = WechatVideoShopUpgradeCondition::buyGoods($level_arr['goods_type'], $buy_goods_id_arr, $goods_id_arr); if ($res) { //购买升级商品触发升级:0订单完成 1支付完成 if ($level_arr['buy_goods_type'] == 0 && $order['order_status'] == OrderStatusEnum::ACCOMPLISH) { $flag = true; break; } if ($level_arr['buy_goods_type'] == 1 && $order['order_status'] == OrderStatusEnum::PAY) { $flag = true; break; } } } //插件等级是否只能一级一级往上升级($order_by = 'level asc') if($is_open_level_limit){ break; } } if ($flag) { $model->level = $can_upgrade_level; $model->upgrade_status = $upgrade_status; $model->upgrade_level_at = time(); if (!$model->save()) throw new Exception("{用户ID:$user_id},订单ID:{$order['id']},". AddonsEnum::getAddonsNameMap($identity_desc) ."购物升级失败"); $upgrade_uid = $user_id; } } $trans->commit(); return $upgrade_uid; } catch (Exception $e) { $trans->rollBack(); $exception = FormatHelper::exception($e, AddonsEnum::getAddonsNameMap($identity_desc) . "购物升级失败"); $this->setError($exception); return false; } } }