db->beginTransaction(); try { $mall_id = $order['mall_id']; $user_id = $order['user_id']; $upgrade_uid = 0; // 获取身份 $model = $identity_obj::findOne(['mall_id' => $mall_id, 'user_id' => $user_id, 'status' => StatusEnum::ENABLED]); if (empty($model)) { $model = new $identity_obj; $model->mall_id = $mall_id; $model->user_id = $user_id; $model->level = 0; $model->upgrade_level_at = 0; $model->loadDefaultValues(); } $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 = UpgradeCondition::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['pay_status'] == OrderStatusEnum::PAY) { $flag = true; break; } } } } if ($flag) { //插入分红金额数据记录,重新购买升级商品,则刷新分红上限金额 // $log = AddonsBossPrice::findOne([ 'user_id' => $user_id, 'level' => $can_upgrade_level]); // if(!$log){ // $log = new AddonsBossPrice; // $log->user_id = $model->user_id; // $log->level = $can_upgrade_level; // } // $log->price = 0; // if (!$log->save()){ // throw new Exception(json_encode($log->errors,JSON_UNESCAPED_UNICODE)); // } $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; } } }