adminOperateLogger = new AdminOperate([ 'fetchClass' => ApproachOrder::class, ]); } /** * @inheritdoc */ public function rules() { return [ [['sn', 'expressCompany', 'orderTrackNo', 'status', 'remark','type','addressId','payType','goodsId','goodsNum', 'payPassword','userName','consignee','acceptMobile','province',/*'city','county',*/'lgaName','cityName','detailaddress','email'], 'trim'], [['sn', 'expressCompany', 'orderTrackNo', 'status', 'remark','type','addressId','payType','goodsId','goodsNum', 'payPassword','userName','consignee','acceptMobile','province',/*'city','county',*/'detailaddress'/*,'email'*/], 'required'], [['status'], 'isStatus'], [['addressId'], 'isAddress'], [['payType'], 'isPayType'], [['payPassword'], 'validatePassword'], ]; } public function attributeLabels() { return [ 'sn' => Yii::t('app', 'orderSn'), 'expressCompany' => Yii::t('app', 'expressCompany'), 'orderTrackNo' => Yii::t('app', 'orderTrackNo'), 'status' => Yii::t('app', 'state'), 'remark' => Yii::t('app', 'remark'), 'type' => Yii::t('app', 'orderType'), 'addressId' => Yii::t('app', 'shippingAddress'), 'payType' => Yii::t('app', 'payType'), 'goodsId' => Yii::t('app', 'productID'), 'goodsNum' => Yii::t('app', 'quantity'), 'userName' => Yii::t('app', 'repeatSalesMemberNo'), 'consignee' => Yii::t('app', 'consignee'), 'acceptMobile' => Yii::t('app', 'acceptMobile'), 'province' => Yii::t('app', 'province'), 'city' => Yii::t('app', 'city'), 'county' => Yii::t('app', 'county'), 'lgaName' =>Yii::t('app', 'lgaName'), 'cityName' => Yii::t('app', 'cityName'), 'detailaddress' => Yii::t('app', 'detailAddress'), 'email' => Yii::t('app', 'email'), 'autoMaintenance' => Yii::t('app', 'amp'), ]; } /** * 指定校验场景 * @return array */ public function scenarios() { $parentScenarios = parent::scenarios(); $customScenarios = [ // 管理员修改订单状态 'adminStatus' => ['sn', 'status'], // 校验订单支付 'verifyPayStack' => ['sn', 'note', 'status'], // 会员下单 'userOrder' => ['type','addressId', 'payType','goodsId','goodsNum', 'note', 'payPassword'], ]; return array_merge($parentScenarios, $customScenarios); } /** * 校验之前 * @return bool */ public function beforeValidate() { $parentValidate = parent::beforeValidate(); if ($this->sn) { $this->_model = ApproachOrder::findOne(['SN' => $this->sn]); if (!$this->_model){ $this->addError('sn', Yii::t('app', 'orderDoesNotExist')); return false; } } if ($this->scenario == 'verifyPayStack'){ if ($this->_model->STATUS != \Yii::$app->params['orderStatus']['notPaid']['value']) { $this->addError('sn', Yii::t('app', 'payTypeError')); return false; } } return $parentValidate; } /** * 判断收货地址是否存在 * @param $attribute */ public function isAddress($attribute){ if (!$receiveAddress = ReceiveAddress::find()->where(' ID=:ID', [':ID' => $this->addressId])->asArray()->one()) { $this->addError($attribute, Yii::t('app', 'shippingDoesNotExist')); } else { $this->_address = $receiveAddress; } } /** * 校验支付密码 * @param $attribute * @param $params */ public function validatePassword($attribute, $params) { if (!User::validatePayPassword(\Yii::$app->user->id, $this->payPassword)) { $this->addError($attribute, Yii::t('app', 'paymentPasswordError')); } } /** * 判断支付方式 * @param $attribute */ public function isPayType($attribute) { if ($this->payType != 'pay_stack'){ $this->addError($attribute, Yii::t('app', 'payTypeError')); return; } // 一个订单只能包含一类商品 $goods = ShopGoods::find()->select('ID,CATEGORY_TYPE')->where(['in', 'ID', $this->goodsId])->andWhere(['STATUS' => 1])->asArray()->all(); if (!$goods) { throw new Exception(Yii::t('app', 'orderCanNotContainMultipleProductCategories')); return; } $goodsCategoryType = array_unique(array_column($goods, 'CATEGORY_TYPE')); if (count($goodsCategoryType) > 1) { $this->addError($attribute, Yii::t('app', 'orderCanNotHasMoreClassification')); return; } // 购买方式 $sellTypeLabelMap = array_column(ShopGoods::getSaleType(), NULL, 'label'); if (!array_key_exists($this->payType, $sellTypeLabelMap)) { $this->addError($attribute, Yii::t('app', 'payTypeError')); return; } // 所选支付方式必须是商品分类支持的类型 $categoryType = array_column(ShopGoods::CATEGORY_TYPE, NULL, 'id'); // 商品类型 $currCategoryType = $goodsCategoryType[0]; if (!array_key_exists($currCategoryType, $categoryType)) { $this->addError($attribute, Yii::t('app', 'shopGoodClassificationError')); return; } $sellType = $categoryType[$currCategoryType]['sell_type'] ?? []; if (!$sellType || !in_array($this->payType, array_column($sellType, 'label'))) { $this->addError($attribute, Yii::t('app', 'payTypeError')); } } /** * 校验类型 * @param $attribute */ public function isStatus($attribute){ if($this->type && !in_array($this->type, \Yii::$app->params['orderStatus'])){ $this->addError($attribute, Yii::t('app', 'orderStatusTypeError')); return ; } if ($this->scenario == 'adminStatus'){ if ($this->status == $this->_model['STATUS']) { $this->addError($attribute, Yii::t('app', 'orderStatusDoesNotChange')); return ; } if($this->status == \Yii::$app->params['orderStatus']['notPaid'] && $this->_model['STATUS'] >= \Yii::$app->params['orderStatus']['delivery']) { $this->addError($attribute, Yii::t('app', 'orderHasBeenLogisticsStatusDoesNotChangedUnpaid')); return ; } elseif($this->status == \Yii::$app->params['orderStatus']['paid'] && $this->_model['STATUS'] >= \Yii::$app->params['orderStatus']['cancel']) { $this->addError($attribute, Yii::t('app', 'orderHasBeenInvalidCanNotProcess')); return ; } elseif($this->status == \Yii::$app->params['orderStatus']['delivery']) { $this->addError($attribute, Yii::t('app', 'orderCanNotBeenChangedLogistics')); return ; } elseif($this->status == \Yii::$app->params['orderStatus']['complete'] && $this->_model['STATUS'] > \Yii::$app->params['orderStatus']['cancel']) { $this->addError($attribute, Yii::t('app', 'orderHasBeenInvalidCanNotProcess')); return ; } elseif($this->status == \Yii::$app->params['orderStatus']['cancel']) { if($this->_model['STATUS'] == \Yii::$app->params['orderStatus']['complete']) { $this->addError($attribute, Yii::t('app', 'orderHasBeenFinishedCanNotCancel')); return ; } if($this->_model['STATUS'] == \Yii::$app->params['orderStatus']['del']) { $this->addError($attribute, Yii::t('app', 'orderHasBeenDeletedCanNotCancel')); return ; } } elseif($this->status == \Yii::$app->params['orderStatus']['del']) { if($this->_model['STATUS'] == \Yii::$app->params['orderStatus']['complete']) { $this->addError($attribute, Yii::t('app', 'orderHasBeenFinishedCanNotDelete')); return ; } } } } /** * 校验PayStack支付,更新订单状态.同步到正式订单. * @throws Exception */ public function verifyPayStack(): ?ApproachOrder { if (!$this->validate()) { return null; } // 调用PayStack支付校验 LoggerTool::info([$this->note['reference'], $this->note]); // $payload = PayStack::transactionVerify($this->note['reference']); // LoggerTool::info($payload); // if ($payload['status'] !== true) { // throw new Exception(Form::formatErrorsForApi($payload['message'])); // } // if ($payload['data']['amount'] != $this->_model->PAY_AMOUNT * 100) { // throw new Exception(Form::formatErrorsForApi(Yii::t('app', 'payAmountNotEqualOrderAmount'))); // } // 订单类型:userOrder(会员订单)、userUpgrade(会员升级)、userDec(会员报单) $orderType = $this->note['metadata']['custom_fields'][1]['value'] ?? false; $db = \Yii::$app->db; $transaction = $db->beginTransaction(); try { // 更新准订单状态为已支付 $this->_model->STATUS = $this->status; $this->_model->NOTE = json_encode($this->note); $this->_model->PAY_AT = Date::utcToTime($this->note['paid_at']); $this->_model->EMAIL = $this->note['email']; if (!$this->_model->save()) { throw new Exception(Form::formatErrorsForApi($this->_model->getErrors())); } // 更新订单商品的支付Email ApproachOrderGoods::updateAll(['EMAIL' => $this->note['email']], 'ORDER_SN = :ORDER_SN', [':ORDER_SN' => $this->sn]); // 同步准订单到正式订单 Order::insertOne($this->_model->toArray()); // 同步准订单商品到正式订单商品 $approachOrderGoods = ApproachOrderGoods::findAllAsArray('ORDER_SN = :ORDER_SN', [':ORDER_SN' => $this->sn]); foreach ($approachOrderGoods as &$approachOrderGood) { $approachOrderGood['EMAIL'] = $this->email; } OrderGoods::batchInsert($approachOrderGoods); // AMP订单 $order = Order::findOne($this->_model->ID); if ($order['AUTO_MAINTENANCE'] == 1) { $this->orderAutoMaintenance($order); } // 会员报单、BA升级 if (in_array($orderType, ['userDec', 'baUpgrade', 'userUpgrade'])) { // 同步报单 $approachDecOrder = ApproachDecOrder::findOneAsArray('ORDER_SN = :ORDER_SN', [':ORDER_SN' => $this->sn]); if ($approachDecOrder) { unset($approachDecOrder['STATUS']); // 同步报单 DecOrder::insertOne($approachDecOrder); // 修改会员锁定状态 if (in_array($orderType, ['userDec', 'baUpgrade'])) { if (!User::updateAll(['STATUS' => 1], 'ID=:USER_ID', [':USER_ID' => $approachDecOrder['TO_USER_ID']])) { throw new Exception(Form::formatErrorsForApi(Yii::t('app', 'changeUserStatusError'))); } } // 正式会员-升级单 if ($orderType === 'userUpgrade') { // 会员升级 报单类型:2会员升级单 if ($approachDecOrder['DETAIL_TYPE'] == 2) { // 为被升级人进行升级操作 $decLevelLog = new DecLevelLog(); $decLog = [ 'userId' => $approachDecOrder['TO_USER_ID'],//会员ID 'fromId' => $approachDecOrder['ORI_LV'], // 变动前的级别 'levelId' => $approachDecOrder['UPGRADE_LV'],// 变动后的级别 'actionId' => $approachDecOrder['USER_ID'], 'remark' => $approachDecOrder['REMARK'], 'lvPv' => $this->_model->PV, ]; $modifyDecLv = $decLevelLog->frontendChange($decLog); if (empty($modifyDecLv)) { $transaction->rollBack(); throw new Exception(Yii::t('app', 'failedToUpgrade')); } } } // 删除中间表 ApproachDecOrder::deleteAll('ORDER_SN = :ORDER_SN', [':ORDER_SN' => $this->sn]); } } // 删除中间表 ApproachOrder::deleteAll('SN = :SN', [':SN' => $this->sn]); ApproachOrderGoods::deleteAll('ORDER_SN = :ORDER_SN', [':ORDER_SN' => $this->sn]); $transaction->commit(); } catch (Exception $e) { $transaction->rollBack(); $this->addError('edit', $e->getFile() . ' ' . $e->getMessage()); return null; } return $this->_model; } /** * 复销 * @throws Exception * @throws \yii\db\Exception */ public function add(){ if(!$this->validate()){ return null; } $ids = $this->goodsId; $totalAmount = 0; $totalPv = 0; $totalAmountStandard = 0; $goodsType = ShopGoods::getGoodType(); $hasInstalment = 0; $loginUserId = \Yii::$app->user->id; $user = User::getEnCodeInfo(\Yii::$app->user->id); foreach ($this->goodsNum as $k => $v) { if ($v) { $goods = ShopGoods::findOneAsArray('ID=:ID AND STATUS=1',[':ID'=> $ids[$k]]); if (!$goods) { throw new Exception(Yii::t('app', 'productsDoesSoldOut')); } $goodsNature = ShopGoodsNature::findOneAsArray('GOODS_ID=:GOODS_ID AND COUNTRY_ID=:COUNTRY_ID', [':GOODS_ID' => $ids[$k], ':COUNTRY_ID' => $user['COUNTRY_ID']]); if (!$goodsNature) { throw new Exception(Yii::t('app', 'productsDoesSoldOut')); } // 汇率 $this->exchangeRate = CurrencyConversions::getToUSDRate($goodsNature['LOCAL_CURRENCY_ID']); if($goods['STORE_NUMS']>0){ if ($goods['TYPE'] == 1 || $goods['TYPE'] == 2) { $discount = $goodsType[$goods['TYPE']]['discount']; $realPrice = $goodsNature['SELL_PRICE'] * $discount/100; $realPv = $goods['PRICE_PV'] * $discount/100; $realPriceStandard = $goods['SELL_PRICE_STANDARD'] * $discount/100; } else { $discount = $goods['SELL_DISCOUNT']; $realPrice = $goodsNature['SELL_PRICE'] * $discount; $realPv = $goods['PRICE_PV'] * $discount; $realPriceStandard = $goods['SELL_PRICE_STANDARD'] * $discount; } $totalAmount += $realPrice * intval($v); $totalPv += $realPv * intval($v); $totalAmountStandard += $realPriceStandard * intval($v); $this->_orderGoods[] = [ 'GOODS_ID' => $goods['ID'], 'PRICE' => $goodsNature['SELL_PRICE'], 'PV' => $goods['PRICE_PV'], 'REAL_PRICE' => $realPrice, 'REAL_PV' => $realPv, 'POINT' => $goods['POINT'], 'BUY_NUMS' => intval($v), 'TAX_RATE' => $goodsNature['TAX_RATE'], 'SKU_CODE' => $goods['GOODS_NO'], 'GOODS_TITLE' => $goods['GOODS_NAME'], 'CATEGORY_TYPE' => $goods['CATEGORY_TYPE'], 'PAY_TYPE' => $this->payType, 'EMAIL' => $this->email, 'STANDARD_PRICE' => $goods['SELL_PRICE_STANDARD'], 'REAL_STANDARD_PRICE' => $realPriceStandard, 'EXCHANGE_RATE' => $goodsNature['TAX_RATE'], ]; } if($goods['INSTALMENT']>0){ // 如果有分期付款商品,检查用户的分期付款状态 if($v>1){ // 不可以购买多个 throw new Exception(Yii::t('app', 'allowOnlyOne')); } $userStage = Instalment::getStage($loginUserId); // 分期的总期数 $instalment = intval(Cache::getSystemConfig()['instalment']['VALUE'] ?? 3); // 分期商品的期数不能大于总分期数限制 if (intval($goods['INSTALMENT']) > $instalment) { throw new Exception(Yii::t('app', 'instalmentGoodsNoError')); } if ($userStage==0){ } else if ($userStage == $instalment) { if ($goods['INSTALMENT'] != 1) { throw new Exception(Yii::t('app', 'canNotBuy')); } }else{ if($userStage + 1 != $goods['INSTALMENT']){ // 若用户分期阶段+1不等于商品的分期阶段,则报异常 throw new Exception(Yii::t('app', 'canNotBuy')); } if ($userStage + 1 > $instalment){ // 若用户分期阶段+1大于总分期阶段,则报异常 throw new Exception(Yii::t('app', 'canNotBuy')); } } $hasInstalment = $goods['INSTALMENT']; } } } // 运费模板 $freeTemplate = FreeTemplate::getByCountryId($user['COUNTRY_ID']); // 运费 $freight = $freeTemplate['freight'] ?? 0; // 普通商品免运费阈值 $freeShipping = $freeTemplate['free_shipping'] ?? 0; $this->_decAmount = $totalAmount; $this->_decPv = $totalPv; $this->_freight = ($totalAmount >= $freeShipping) ? 0 : $freight; if($this->_address['PROVINCE']==1){ $this->_freight = 0; } $this->_payAmount = $this->_decAmount + $this->_freight; $this->_decAmountStandard = $totalAmountStandard; $this->_standardAmount = $this->_decAmountStandard + $this->_freight; $db = \Yii::$app->db; $transaction = $db->beginTransaction(); try { //写入订单 if (!$orderResult = $this->addOrder()) { throw new Exception(Form::formatErrorsForApi($orderResult->getErrors())); } if ($hasInstalment){ // 如果有分期付款的商品,写入信息至分期付款表 $instalmentModel = Instalment::findOne(['USER_ID'=>$loginUserId]); if(!$instalmentModel) { $instalmentModel = new Instalment(); } $instalmentModel->USER_ID = $loginUserId; $instalmentModel->STAGE = $hasInstalment; $instalmentModel->UPDATE_TIME = time(); $instalmentModel->save(); } $transaction->commit(); return $orderResult; }catch (\Exception $e){ $transaction->rollBack(); $this->addError('add', $e->getMessage()); return null; } } /** * 复销订单 * @throws Exception */ public function addOrder() { $periodObj = Period::instance(); $nowPeriodNum = $this->period ?: $periodObj->getNowPeriodNum(); $nowCalcMonth = $periodObj->getYearMonth($nowPeriodNum); $userId = \Yii::$app->user->id; $user = User::getEnCodeInfo(\Yii::$app->user->id); $userName = Info::getUserNameByUserId($userId); $userRealName = Info::getUserRealNameByUserId($userId); $userMobile = Info::getUserMobileByUserId($userId); $userEmail = Info::getUserEmailByUserId($userId); $country = Countries::getById($user['COUNTRY_ID']); // 加入订单信息 if ($this->_address['PROVINCE'] != 1) { $warehouse = Region::getWarehouseByCode($this->_address['PROVINCE']);//仓库 if (!$warehouse) { // throw new Exception(Yii::t('app', 'deliveryTemporarilyNotSupported')); } }else{ $warehouse = '01'; } $_hasPV = $this->_decPv; $ordNo = $this->_generateSn(); $orderModel = new ApproachOrder(); $orderModel->SN = 'OS' . $ordNo; $orderModel->DEC_SN = 'DS' . $ordNo; $orderModel->ORDER_TYPE = $this->type; $orderModel->USER_ID = $userId; $orderModel->USER_NAME = $userName; $orderModel->DEC_USER_ID = $this->decUserName; $orderModel->ORDER_AMOUNT = $this->_decAmount; $orderModel->PV = $_hasPV; $orderModel->PAY_AMOUNT = $this->_payAmount; $orderModel->PAY_PV = $_hasPV; // 兑换积分不能算业绩 $orderModel->PAY_AT = 0; $orderModel->PAY_TYPE = $this->payType; $orderModel->PERIOD_NUM = $nowPeriodNum; $orderModel->P_CALC_MONTH = Date::ociToDate($nowCalcMonth, Date::OCI_TIME_FORMAT_SHORT_MONTH); $orderModel->FREIGHT = $this->_freight; $orderModel->PAY_FREIGHT = $this->_freight; $orderModel->CONSIGNEE = $this->_address['CONSIGNEE']; $orderModel->MOBILE = $this->_address['MOBILE']; $orderModel->PROVINCE = $this->_address['PROVINCE']; // $orderModel->CITY = $this->_address['CITY']; // $orderModel->COUNTY = $this->_address['COUNTY']; $orderModel->LGA_NAME = $this->_address['LGA_NAME']; $orderModel->CITY_NAME = $this->_address['CITY_NAME']; $orderModel->ADDRESS = $this->_address['ADDRESS']; $orderModel->FRONT_REMARK = $this->remark; $orderModel->WAREHOUSE = $warehouse; $orderModel->STATUS = \Yii::$app->params['orderStatus']['notPaid']['value']; $orderModel->CREATED_AT = Date::nowTime(); $orderModel->CREATE_USER = $userName; $orderModel->EMAIL = $userEmail?$userEmail:$userName.'@elken.net'; $orderModel->ORDER_AMOUNT_STANDARD = $this->_decAmountStandard; $orderModel->PAY_AMOUNT_STANDARD = $this->_standardAmount; $orderModel->EXCHANGE_RATE = $this->exchangeRate; $orderModel->COUNTRY_ID = $user['COUNTRY_ID']; $orderModel->CURRENCY_ID = $country['LOCAL_CURRENCY_ID'] ?? 0; if($this->_address['PROVINCE']==1){ $orderModel->EXPRESS_TYPE = 1; $orderModel->CONSIGNEE = $userRealName; $orderModel->MOBILE = $userMobile; $orderModel->PROVINCE = 1; $orderModel->CITY = 1; $orderModel->COUNTY = 1; $orderModel->ADDRESS = ''; } if(!$orderModel->save()){ $this->addErrors($orderModel->getErrors()); return false; } // 加入商品到订单商品表 foreach($this->_orderGoods as $key=>$value) { $this->_orderGoods[$key]['ORDER_SN'] = $orderModel->SN; $this->_orderGoods[$key]['P_CALC_MONTH'] = Date::ociToDate($nowCalcMonth, Date::OCI_TIME_FORMAT_SHORT_MONTH); } ApproachOrderGoods::batchInsert($this->_orderGoods); return $orderModel; } /** * 生成流水号 * @return string */ private function _generateSn() { return Date::today('Ymd') . $this->_random(10, 1); } /** * 生成随机数 * @param $length * @param int $numeric * @return string */ private function _random($length, $numeric = 0) { $seed = base_convert(md5(microtime() . $_SERVER['DOCUMENT_ROOT']), 16, $numeric ? 10 : 35); $seed = $numeric ? (str_replace('0', '', $seed) . '012340567890') : ($seed . 'zZ' . strtoupper($seed)); $hash = ''; $max = strlen($seed) - 1; for ($i = 0; $i < $length; $i++) { $hash .= $seed[mt_rand(0, $max)]; } return $hash; } private function orderAutoMaintenance($order) { $nowPeriodNum = Period::instance()->getNowPeriodNum(); try { $sysConfig = Cache::getSystemConfig(); $divideLine = (int)$sysConfig['monthPcsPvFxCondition']['VALUE']; $orderTotalBv = $order->PV; if ($orderTotalBv <= $divideLine) { return; } $lastAmpPeriod = AmpPeriod::find() ->where(['USER_ID' => $order->USER_ID]) ->orderBy(['PERIOD_NUM' => SORT_DESC]) ->one(); $startPeriodNum = $lastAmpPeriod ? $lastAmpPeriod->PERIOD_NUM + 1 : $nowPeriodNum; if (!$lastAmpPeriod) { $memberOrderBv = Order::find() ->select('SUM(PV) AS total_pv') ->where([ 'USER_ID' => $order->USER_ID, 'IS_DELETE' => 0, 'PERIOD_NUM' => $nowPeriodNum ]) ->scalar(); if ($memberOrderBv >= $divideLine) { $startPeriodNum = $nowPeriodNum + 1; } } $periodCount = floor($orderTotalBv / $divideLine); $remainderBv = $orderTotalBv % $divideLine; $ampPeriods = []; for ($i = 1; $i <= $periodCount; $i++) { $currentBv = $i < $periodCount ? $divideLine : ($divideLine + $remainderBv); $ampPeriods[] = [ 'USER_ID' => $order->USER_ID, 'ORDER_SN' => $order->SN, 'PERIOD_NUM' => $startPeriodNum + $i - 1, 'BV' => $currentBv, ]; } if (!empty($ampPeriods)) { AmpPeriod::batchInsert($ampPeriods); } } catch (\Exception $e) { // 记录日志或进行错误处理 \Yii::error('Order auto maintenance failed: ' . $e->getMessage()); } } }