[ 'name' => '首购单', ], // self::TYPE_YH => [ // 'class' => DeclarationYH::class, // 'table' => '{{%DECLARATION_YH}}', // 'name' => '优惠单', // ], self::TYPE_ZG => [ 'name' => '升级增购单', ], self::TYPE_LS => [ 'name' => '零售单', ], self::TYPE_FX => [ 'name' => '复销单', ], ]; /** * @inheritdoc */ public function rules() { return [ [['type','decLv','decWay','packageId', 'insertUserName', 'realName',/* 'insertUserIdCard',*/ 'mobile', 'address', 'openBank', 'bankAddress', 'bankNo','bankProvince','bankCity','bankCounty','consignee','acceptMobile','province','city','county','cityName','lgaName','decUserName', 'conUserName', 'recUserName', 'location'], 'trim'], [['type','decWay','insertUserName',/* 'insertUserIdCard',*/'password','payPassword','decUserName'], 'required'], // [['type'], 'isType', 'on'=>['userDec', 'canDec']], // [['insertUserName'], 'isCanAddUser'], // [['decUserName'], 'issetDec'], // [['conUserName'], 'isConUserName'], // [['recUserName'], 'isRecUserName'], // [['location'], 'isLocation'], // [['insertUserIdCard'], 'isSameSystem'], ]; } public function attributeLabels() { return [ 'type' => 'Entry type', // 报单类型 'goodsId' => 'product ID', // 商品ID 'goodsNum' => 'Product quantity', // 商品数量 'insertUserName' => 'Member user name', // 会员用户名 'password' => 'Login password', // 登陆密码 'payPassword' => 'Payment password', // 支付密码 'realName' => 'Member name', // 会员姓名 'mobile' => 'Phone Number', // 手机号 'recUserName' => 'Developer user name', // 开拓人用户名 'decUserName' => 'Stockist user name', // 报单中心用户名 'conUid' => 'Instructor Member ID', // 指导老师会员ID 'recUid' => 'Sponsor Member ID', // 开拓人会员ID 'location' => 'market', // 市场 'consignee' => 'Recipient', // 收货人 'acceptMobile' => 'Recipient Phone Number', // 收货人手机 'province' => 'Receiving Province',//收货省 'address' => 'Receiving detailed address',//收货详细地址 ]; } /** * 指定场景 * @return array */ public function scenarios() { $parentScenarios = parent::scenarios(); $customScenarios = [ 'userDec' => ['type','allData', 'decLv','decWay','insertUserName','password','payPassword', 'realName', 'mobile', 'address', 'consignee','acceptMobile','province','decUserName', 'location', 'email'], ]; return array_merge($parentScenarios, $customScenarios); } /** * 判断报单中心是否存在 * @param $attribute */ public function issetDec($attribute){ if (!$decUser = BaUser::find()->select('ID')->where('IS_DEC=1 AND USER_NAME=:USER_NAME', [':USER_NAME' => $this->decUserName])->asArray()->one()) { $this->addError($attribute, 'Stockist does not exist'); // 报单中心不存在 return false; } else { $this->_decId = $decUser['ID']; } } /** * 判断开拓人 * @param $attribute */ public function isRecUserName($attribute){ if($this->type == self::TYPE_ZC){ // 开拓人 // if(!isset($this->_tempParentUser[$this->recUserName])){ // $recUserTemp = UserInfo::findOneAsArray('USER_NAME=:USER_NAME', [':USER_NAME' => $this->recUserName]); // if(!$recUserTemp){ // if($this->insertUserName){ // //$this->addError($attribute, '为'.$this->insertUserName.'报单,开拓人'.$this->recUserName.'不存在'); // $this->addError($attribute, 'To'.$this->insertUserName.'Entry, Sponsor'.$this->recUserName.'not in exist'); // } else { // // $this->addError($attribute, '开拓人'.$this->recUserName.'不存在'); // $this->addError($attribute, 'Sponsor'.$this->recUserName.'not in exist'); // } // // return ; // } // $recUserTemp['CON_NUM'] = UserNetwork::firstFloorChildNum($recUserTemp['USER_ID']); // $recUserTemp['REC_NUM'] = UserRelation::firstFloorChildNum($recUserTemp['USER_ID']); // $this->_tempParentUser[$this->recUserName] = [ // 'USER_NAME' => $this->recUserName, // 'ZC_PV' => $recUserTemp['ZC_PV'], // 'CON_USER_NAME' => Info::getUserNameByUserId($recUserTemp['CON_UID']), // 'REC_USER_NAME' => Info::getUserNameByUserId($recUserTemp['REC_UID']), // 'CON_NUM' => $recUserTemp['CON_NUM'], // 'REC_NUM' => $recUserTemp['REC_NUM'], // 'SYSTEM_ID' => $recUserTemp['SYSTEM_ID'], // 'LOCATION' => UserNetwork::getLocation($recUserTemp['USER_ID'], $recUserTemp['CON_UID']), // ]; // // 把该会员下面的5个区是否存在会员都付上 // for($i=1;$i<=5;$i++){ // $this->_tempParentUser[$this->recUserName]["LOCATION$i"] = UserNetwork::issetUserInLocation($recUserTemp['USER_ID'], $i); // } // } $recUser = $this->_tempParentUser[$this->recUserName]; $this->_tempParentUser[$this->recUserName]['REC_NUM'] += 1; // 存在新加入会员时查看开拓人是否在新加入会员的安置网上级中 // if($this->insertUserName) { // $this->loopFindParentToNetwork($this->insertUserName); // if (!$this->recUserIsInNetworkParent()) { // // $this->addError($attribute, '为' . $this->insertUserName . '报单,开拓人' . $this->recUserName . '不在' . $this->insertUserName . '的安置网上级中'); // $this->addError($attribute, 'To' . $this->insertUserName . 'Entry, Sponsor' . $this->recUserName . 'not in exist' . $this->insertUserName . 'in the placement superiors'); // return ; // } // } // // // 把自己加入到临时上级会员数组中 // $this->_tempParentUser[$this->insertUserName] = [ // 'USER_NAME' => $this->insertUserName, // //'ZC_PV' => $this->decPv, // 'CON_USER_NAME' => $this->conUserName, // 'REC_USER_NAME' => $this->recUserName, // 'CON_NUM' => 0, // 'REC_NUM' => 0, // 'SYSTEM_ID' => $recUser['SYSTEM_ID'], // 'LOCATION' => $this->location, // 'LOCATION1' => 0, // 'LOCATION2' => 0, // 'LOCATION3' => 0, // 'LOCATION4' => 0, // 'LOCATION5' => 0, // ]; } } /** * 添加报单 * @param $allData * @return bool|null * @throws Exception * @throws \yii\db\Exception */ public function add($allData){ if(!$this->validate()){ return null; } // 首购单,需要添加会员操作 if($this->type == self::TYPE_ZC){ if (preg_match("/[\x7f-\xff]/", $this->insertUserName)) { // 判断字符串中是否有中文 throw new Exception('Member number cannot contain Chinese characters'); // 会员编号中不能含有汉字 } // //报单商品及PV判断 // $decLevelConfig = Cache::getDecLevelConfig(); // $decLevel = $decLevelConfig[$this->decLv]; // $toDecLevel = $this->decLv; // if(!$this->decLv){ // throw new Exception('Please select the entry level'); // 请选择报单级别 // } $ids = $this->goodsId; $totalAmount = 0; $totalPv = 0; foreach ($this->goodsNum as $k => $v) { if ($v) { $goods = ShopGoods::findOneAsArray('ID=:ID AND STATUS=1',[':ID'=> $ids[$k]]); if($goods['STORE_NUMS']>0){ $totalAmount += $goods['SELL_PRICE'] * intval($v); $totalPv += $goods['PRICE_PV'] * intval($v); $this->_orderGoods[] = [ 'GOODS_ID' => $goods['ID'], 'PRICE' => $goods['SELL_PRICE'], 'REAL_PRICE' => $goods['SELL_PRICE'], 'PV' => $goods['PRICE_PV'], 'REAL_PV' => $goods['PRICE_PV'], 'POINT' => $goods['POINT'], 'BUY_NUMS' => intval($v), 'SKU_CODE' => $goods['GOODS_NO'], 'GOODS_TITLE' => $goods['GOODS_NAME'], 'EMAIL' => $this->email, 'TAX_RATE' => $goods['TAX_RATE'], ]; } } } // if($totalPv<$decLevel['PERF']){ // throw new Exception('The total BV of self selected goods cannot be less than the BV of the selected entry level');//自选商品总BV不能小于所选报单级别BV // } // foreach ($decLevelConfig as $key=>$val){ // if($totalPv>=$val['PERF']){ // $toDecLevel = $key; // } // } // if($this->decLv!=$toDecLevel){ // throw new Exception('The total BV of self selected goods cannot exceed the BV value of the next level under the selected level');//自选商品总BV不能超过已选级别下一个级别的BV值 // } $this->_decAmount = $totalAmount; // $this->_decPv = $totalPv; //看现金余额是否充足 $loginUserId = \Yii::$app->user->id; if (Cash::getAvailableBalance($loginUserId) < $this->_decAmount){ throw new Exception('The applicant is short of cash and cannot complete the declaration');//报单人现金不足,无法完成报单 } // print_r($allData);exit; if(!($zcResult = $this->addBaUser($allData))) { throw new Exception(Form::formatErrorsForApi($this->_userForm->getErrors())); } // print_r($allData);exit; if(!($decResult = $this->addBaDecOrder())) { throw new Exception(Form::formatErrorsForApi($decResult->getErrors())); } } return true; } /** * 添加会员 * @param $allData * @return bool|UserInfo|null * @throws \yii\db\Exception * @throws \Exception */ public function addBaUser($allData){ $period = Period::instance(); try { // 增加会员 $user = new BaUser(); $user->USER_NAME = $this->insertUserName; $user->PASSWORD_HASH = \Yii::$app->security->generatePasswordHash($this->password); $user->PAY_PASSWORD = \Yii::$app->security->generatePasswordHash($this->payPassword); $user->NATION = 0; $user->REAL_NAME = $this->realName; $user->ID_CARD = $this->mobile; $user->MOBILE = $this->mobile; $user->EMAIL = $this->email; $user->ADDRESS = $this->address ? $this->address : 'nothing';//无 // $user->OPEN_BANK = $this->openBank; // $user->BANK_ADDRESS = $this->bankAddress; // $user->BANK_NO = $this->bankNo; // $user->BANK_PROVINCE = $this->bankProvince ?? 0; // $user->BANK_CITY = $this->bankCity ?? 0; // $user->BANK_COUNTY = $this->bankCounty ?? 0; $user->CREATED_AT = Date::nowTime(); $user->STATUS = 1; // $user->DEC_LV = $this->decLv; // $user->LAST_DEC_LV = $this->decLv; // $user->EMP_LV = EmployLevel::getDefaultLevelId(); $user->PROVINCE = $this->province ?? 0; $user->LGA_NAME = $this->lgaName; $user->CITY_NAME = $this->cityName; $user->AVATAR = 'avatar/1.png'; $user->IS_DEC = 0; $user->DEC_ID = $this->_decId ?? ''; $user->DEC_ROLE_ID = $this->decRoleId ?? ''; $user->PERIOD_AT = $period->getNowPeriodNum(); $user->IS_DIRECT_SELLER = 0; $user->VERIFIED = 1; $user->VERIFIED_AT = Date::nowTime(); if (!$user->save()) { throw new Exception(Form::formatErrorsForApi($user->getErrors())); } $this->_insertUserId = $user->ID; $userForm = new BaUserForm(); $this->_userForm = $userForm; $userForm->scenario = 'addWithUserName'; $userForm->userId = $this->_insertUserId; $userForm->userName = $this->insertUserName; // $userForm->zcPv = $this->_decPv; $userForm->zcAmount = $this->_decAmount; // $userForm->conUserName = $this->conUserName; $userForm->recUserName = $this->recUserName; // $userForm->location = $this->location; $userForm->idCard = $this->mobile; $userForm->allData = $allData; // print_r($userForm);exit; if (!$userForm->validate()) { $this->addErrors($userForm->getErrors()); return false; } if ($result = $userForm->add()) { return $result; } else { return false; } } catch (\Exception $e) { LoggerTool::info($e->getMessage()); throw new \Exception($e->getMessage()); } } /** * 添加报单订单 * @return bool|UserInfo|null * @throws \yii\db\Exception */ public function addBaDecOrder(){ $periodObj = Period::instance(); $nowPeriodNum = $periodObj->getNowPeriodNum(); $nowCalcMonth = $periodObj->getYearMonth($nowPeriodNum); $ord = date('Ymd').substr(implode(NULL, array_map('ord', str_split(substr(uniqid(), 7, 13), 1))), 0, 10); // 加入报单信息 $decOrderModel = new BaDecOrder(); $decOrderModel->DEC_SN = 'DS'.$ord; $decOrderModel->ORDER_SN = 'OS'.$ord; $decOrderModel->TYPE = $this->type; $decOrderModel->USER_ID = \Yii::$app->user->id; $decOrderModel->TO_USER_ID = $this->_insertUserId; $decOrderModel->DEC_AMOUNT = $this->_decAmount; // $decOrderModel->DEC_PV = $this->_decPv; $decOrderModel->PERIOD_NUM = $nowPeriodNum; $decOrderModel->CALC_MONTH = $nowCalcMonth; $decOrderModel->P_CALC_MONTH = Date::ociToDate($nowCalcMonth, Date::OCI_TIME_FORMAT_SHORT_MONTH); $decOrderModel->PAID_WALLET = 'cash'; // $decOrderModel->CON_USER_ID = Info::getUserIdByUserName($this->conUserName); $decOrderModel->REC_USER_ID = Info::getUserIdByUserName($this->recUserName); // $decOrderModel->DEC_ID = $this->_decId; $decOrderModel->IS_DEL = 0; $decOrderModel->CREATED_AT = Date::nowTime(); if(!$decOrderModel->save()){ throw new Exception(Form::formatErrorsForApi($decOrderModel->getErrors())); } // 加入订单信息 if($this->province!=1){ $warehouse = Region::getWarehouseByCode($this->province);//仓库 if(!$warehouse){ throw new Exception('Delivery is temporarily not supported in the region. Contact customer service for details');//地区暂时不支持配送,具体联系客服 } }else{ $warehouse = '01'; } $orderModel = new BaOrder(); $orderModel->SN = 'OS'.$ord; $orderModel->DEC_SN = 'DS'.$ord; $orderModel->ORDER_TYPE = $this->type; $orderModel->USER_ID = $this->_insertUserId; $orderModel->USER_NAME = $this->insertUserName; $orderModel->ORDER_AMOUNT = $this->_decAmount; // $orderModel->PV = $this->_decPv; $orderModel->PAY_AMOUNT = $this->_decAmount; // $orderModel->PAY_PV = $this->_decPv; $orderModel->PAY_AT = Date::nowTime(); $orderModel->PAY_TYPE = 'cash'; $orderModel->PERIOD_NUM = $nowPeriodNum; $orderModel->P_CALC_MONTH = Date::ociToDate($nowCalcMonth, Date::OCI_TIME_FORMAT_SHORT_MONTH); $orderModel->FREIGHT = 0; $orderModel->PAY_FREIGHT = 0; $orderModel->CONSIGNEE = $this->consignee; $orderModel->MOBILE = $this->acceptMobile; $orderModel->EMAIL = $this->email; $orderModel->PROVINCE = $this->province; $orderModel->LGA_NAME = $this->lgaName; $orderModel->CITY_NAME = $this->cityName; $orderModel->ADDRESS = $this->address; $orderModel->WAREHOUSE = $warehouse; $orderModel->STATUS = 1; $orderModel->CREATED_AT = Date::nowTime(); $orderModel->CREATE_USER = Info::getUserNameByUserId(\Yii::$app->user->id); if($this->province==1){ $orderModel->EXPRESS_TYPE = 1; } if(!$orderModel->save()){ throw new Exception(Form::formatErrorsForApi($orderModel->getErrors())); } // 加入商品到订单商品表 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); } BaOrderGoods::batchInsert($this->_orderGoods); //写入收货地址信息,判断province字段,当不为1时,插入收货地址信息 if($this->province!=1){ $addressModel = new ReceiveAddress(); $addressModel->USER_ID = $this->_insertUserId; $addressModel->USER_NAME = $this->insertUserName; $addressModel->CONSIGNEE = $this->consignee; $addressModel->MOBILE = $this->acceptMobile; $addressModel->PROVINCE = $this->province; $addressModel->CITY_NAME = $this->cityName; $addressModel->LGA_NAME = $this->lgaName; $addressModel->ADDRESS = $this->address; $addressModel->IS_DEFAULT = 1; if(!$addressModel->save()){ throw new Exception(Form::formatErrorsForApi($addressModel->getErrors())); } }else{ $addressModel = new ReceiveAddress(); } //扣报单人现金钱包 Cash::changeUserCash(\Yii::$app->user->id, 'CASH', -abs($this->_decAmount), ['REMARK' =>'To'.$this->insertUserName.'Entry']); // 报单 return $addressModel; } /** * 删单 * @return bool * @throws \yii\db\Exception */ public function delete(){ if(!$this->validate()){ return false; } $transaction = \Yii::$app->db->beginTransaction(); try { $oneOrder = $this->_oneOrder; // 首购单要删除会员 if($this->type == self::TYPE_ZC){ BaUserInfo::deleteUser($oneOrder['TO_USER_ID']); } // 如果是复销单的话,还需要考虑给会员的复销池减去金额 elseif($this->type == self::TYPE_FX){ // Reconsume::changePoolPV($oneOrder['TO_USER_ID'], -abs($oneOrder['DEC_PV']), ['REMARK'=>'删单扣除', 'DEAL_TYPE'=>Reconsume::TYPE_AUDIT_PV]); Reconsume::changePoolPV($oneOrder['TO_USER_ID'], -abs($oneOrder['DEC_PV']), ['REMARK'=>'Deletion deduction', 'DEAL_TYPE'=>Reconsume::TYPE_AUDIT_PV]); } $transaction->commit(); } catch (Exception $e) { $transaction->rollBack(); $this->addError('delete', $e->getMessage()); return false; } return true; } }