UserForm.php 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637
  1. <?php
  2. namespace common\models\forms;
  3. use common\components\Model;
  4. use common\helpers\Date;
  5. use common\helpers\Form;
  6. use common\helpers\snowflake\SnowFake;
  7. use common\helpers\user\Balance;
  8. use common\helpers\user\Info;
  9. use common\libs\logging\operate\UserOperate;
  10. use common\models\Period;
  11. use common\models\DeclarationLevel;
  12. use common\models\EmployLevel;
  13. use common\models\User;
  14. use common\models\UserInfo;
  15. use common\models\UserNetwork;
  16. use common\models\UserRelation;
  17. use Yii;
  18. use yii\db\Exception;
  19. /**
  20. * Login form
  21. */
  22. class UserForm extends Model
  23. {
  24. public $userId;
  25. public $userName;
  26. public $zcPv;
  27. public $zcAmount;
  28. public $conUserName;
  29. public $recUserName;
  30. public $conUid;
  31. public $recUid;
  32. public $location;
  33. public $idCard;
  34. public $allData; // 批量报单的全部报单数据
  35. //个人资料
  36. public $nation;
  37. public $realName;
  38. public $mobile;
  39. public $openBank;
  40. public $bankAddress;
  41. public $bankNo;
  42. public $email;
  43. //修改密码
  44. public $password;
  45. public $oldPassword;
  46. public $verifyPassword;
  47. public $payPassword;
  48. private $_conUid;
  49. private $_recUid;
  50. private $_limit = 1000;
  51. private $_conTopUid;
  52. private $_conTopDeep;
  53. private $_recTopUid;
  54. private $_recTopDeep;
  55. public function init() {
  56. parent::init();
  57. $this->userOperateLogger = new UserOperate([
  58. 'fetchClass' => User::class,
  59. ]);
  60. }
  61. /**
  62. * @inheritdoc
  63. */
  64. public function rules()
  65. {
  66. return [
  67. [['userId', 'userName', 'zcPv', 'zcAmount', 'conUserName', 'recUserName','conUid', 'recUid', 'location','nation','realName', 'mobile','openBank','bankAddress','bankNo', 'email'], 'trim'],
  68. [['userId', 'userName', 'zcPv', 'zcAmount', 'conUid', 'recUid', 'location'], 'required', 'on'=>'addWithUid'],
  69. [['userId', 'userName', 'zcPv', 'zcAmount', 'conUserName', 'recUserName', 'location'], 'required', 'on'=>['addWithUserName', 'addByAdmin']],
  70. [['idCard', 'allData'], 'required', 'on'=>['addWithUserName']],
  71. [['userName'], 'required', 'on'=>['validateUser', 'noLoginModifyPassword']],
  72. [['conUid'], 'required', 'on'=>['validateCon', 'validateAddWithUid']],
  73. [['conUserName'], 'required', 'on'=>['validateConName', 'validateAddWithName']],
  74. [['recUid'], 'required', 'on'=>['validateRec', 'validateAddWithUid']],
  75. [['recUserName'], 'required', 'on'=>['validateRecName', 'validateAddWithName']],
  76. [['conUid', 'location'], 'required', 'on'=>['validateLocation', 'validateAddWithUid']],
  77. [['conUserName', 'location'], 'required', 'on'=>['validateLocationConName', 'validateAddWithName']],
  78. [[/*'nation',*/'realName', 'mobile', /*'idCard',*/ /*'openBank', 'bankAddress', 'bankNo'*//*, 'email'*/], 'required', 'on'=>'modifyProfile'],
  79. [['oldPassword','verifyPassword'], 'required','on' => ['modifyPassword', 'modifyPasswordPay', 'noLoginModifyPassword']],
  80. [['password'], 'required','on' => ['modifyPassword', 'noLoginModifyPassword']],
  81. [['payPassword'], 'required','on' => ['modifyPasswordPay']],
  82. ['verifyPassword', 'compare', 'compareAttribute' => 'password' ,'message'=>'The two login passwords are inconsistent' ,'on' => ['modifyPassword', 'noLoginModifyPassword']],//两次登录密码输入不一致
  83. ['verifyPassword', 'compare', 'compareAttribute' => 'payPassword' ,'message'=>'The two payment passwords are inconsistent' ,'on' => ['modifyPasswordPay']],//两次支付密码输入不一致
  84. [['userId'], 'unique', 'targetClass'=>UserInfo::class, 'targetAttribute'=>'USER_ID', 'on' => ['addWithUserName', 'addWithUid', 'addByAdmin']],
  85. [['userName'], 'unique', 'targetClass'=>UserInfo::class, 'targetAttribute'=>'USER_NAME' , 'on' => ['addWithUserName', 'addWithUid', 'addByAdmin']],
  86. [['conUid'], 'exist', 'targetClass'=>UserInfo::class, 'targetAttribute'=>'USER_ID', 'on' => ['addWithUserName', 'addWithUid', 'addByAdmin']],
  87. [['recUid'], 'exist', 'targetClass'=>UserInfo::class, 'targetAttribute'=>'USER_ID', 'on' => ['addWithUserName', 'addWithUid', 'addByAdmin']],
  88. [['conUid'], 'isConUid', 'on' => ['addWithUserName', 'addWithUid', 'addByAdmin']],
  89. [['recUid'], 'isRecUid', 'on' => ['addWithUserName', 'addWithUid', 'addByAdmin']],
  90. [['conUserName'], 'exist', 'targetClass'=>UserInfo::class, 'targetAttribute'=>'USER_NAME', 'on' => ['addWithUserName', 'addWithUid', 'addByAdmin']],
  91. [['recUserName'], 'exist', 'targetClass'=>UserInfo::class, 'targetAttribute'=>'USER_NAME', 'on' => ['addWithUserName', 'addWithUid', 'addByAdmin']],
  92. [['conUserName'], 'isCon', 'on' => ['addWithUserName', 'addWithUid', 'addByAdmin']],
  93. [['recUserName'], 'isRec', 'on' => ['addWithUserName', 'addWithUid', 'addByAdmin']],
  94. [['location'], 'isLocation', 'on' => ['addWithUserName', 'addWithUid', 'addByAdmin']],
  95. //[['idCard'], 'isSameNetwork'],
  96. [['zcPv', 'zcAmount'], 'price', 'on' => ['addWithUserName', 'addWithUid', 'addByAdmin']],
  97. [['zcPv'], 'isMinDecLevel', 'on' => ['addWithUserName', 'addWithUid', 'addByAdmin']],
  98. ];
  99. }
  100. public function attributeLabels()
  101. {
  102. return [
  103. 'userId' => '会员ID',
  104. 'conUserName' => '接点人账号',
  105. 'recUserName' => '开拓人帐号',
  106. 'location' => '区位',
  107. // 'nation' => '民族',
  108. //'realName' => '真实姓名',
  109. // 'idCard' => '身份证号',
  110. //'mobile' => '手机号',
  111. // 'openBank' => '银行名称',
  112. // 'bankAddress' => '开户支行',
  113. // 'bankNo' => '银行账号',
  114. 'verifyPassword' => 'Confirm password',//确认密码
  115. 'oldPassword' => 'Original password',//原密码
  116. 'password' => 'Login password',//登录密码
  117. 'payPassword' => 'Payment password',//支付密码
  118. 'email' => 'Email',
  119. ];
  120. }
  121. /**
  122. * 接点人是否可以放置
  123. * @param $attribute
  124. * @param $params
  125. */
  126. public function isConUid($attribute, $params){
  127. $this->_conUid = $this->conUid;
  128. // 查看该接点人在安置网络中的推荐人数量是否达到上限
  129. $childNum = UserNetwork::firstFloorChildNum($this->_conUid);
  130. if($childNum >= 3){
  131. $this->addError($attribute, '注册'.$this->userName.'时,接点人'.$this->conUserName.'点位已满无法继续添加');
  132. }
  133. }
  134. /**
  135. * 推荐人是否可用
  136. * @param $attribute
  137. * @param $params
  138. */
  139. public function isRecUid($attribute, $params){
  140. $this->_recUid = $this->recUid;
  141. // 查看该开拓者推荐的第一层人的数量
  142. // $childNum = UserRelation::firstFloorChildNum($this->_recUid);
  143. // if($childNum === 0){
  144. // // 必须放在自己的左区
  145. // if($this->location != 1){
  146. // $this->addError($attribute, '开拓的第一人必须放在自己的一市场');
  147. // }
  148. // }
  149. }
  150. /**
  151. * 接点人是否可以放置
  152. * @param $attribute
  153. * @param $params
  154. */
  155. public function isCon($attribute, $params){
  156. // 根据账号找到接点人
  157. $oneConUserInfo = UserInfo::findOneAsArray('USER_NAME=:USER_NAME', [':USER_NAME'=>$this->conUserName]);
  158. if($oneConUserInfo){
  159. $this->_conUid = $oneConUserInfo['USER_ID'];
  160. // 查看该接点人在安置网络中的推荐人数量是否达到上限
  161. $childNum = UserNetwork::firstFloorChildNum($this->_conUid);
  162. if($childNum >= 3){
  163. $this->addError($attribute, $this->userName.'的接点人'.$this->conUserName.'点位已满无法继续添加');
  164. }
  165. } else {
  166. $this->addError($attribute, '注册'.$this->userName.'时,接点人'.$this->conUserName.'帐号无效');
  167. }
  168. }
  169. /**
  170. * 推荐人是否可用
  171. * @param $attribute
  172. * @param $params
  173. */
  174. public function isRec($attribute, $params){
  175. // 根据账号找到开拓人
  176. $oneRecUserInfo = User::findOneAsArray('USER_NAME=:USER_NAME', [':USER_NAME'=>$this->recUserName]);
  177. if($oneRecUserInfo && $oneRecUserInfo['STATUS']){
  178. $this->_recUid = $oneRecUserInfo['ID'];
  179. // 取消开拓的第一人必须放在自己的安置网下左区的需求
  180. // if($this->scenario != 'addByAdmin'){
  181. // // 查看该开拓者推荐的第一层人的数量
  182. // $childNum = UserRelation::firstFloorChildNum($this->_recUid);
  183. // if($childNum === 0){
  184. // // 必须放在自己的左区
  185. // if($this->location != 1 && $this->scenario != 'validateRecName'){
  186. // $this->addError($attribute, '注册'.$this->userName.'时,开拓人'.$this->recUserName.'开拓的第一人必须放在自己的安置网络下的左区');
  187. // }
  188. // }
  189. // }
  190. } else {
  191. $this->addError($attribute, '注册'.$this->userName.'时,开拓人'.$this->recUserName.'帐号无效或未激活');
  192. }
  193. }
  194. /**
  195. * 区位是否可用
  196. * @param $attribute
  197. * @param $params
  198. */
  199. public function isLocation($attribute, $params){
  200. // 查看该接点人下面所有的子会员
  201. $allChildUser = UserNetwork::getFirstFloorChildren($this->_conUid);
  202. if($allChildUser){
  203. $isLocation = [1=>false, 2=>false, 3=>false];
  204. foreach($allChildUser as $child){
  205. $isLocation[$child['RELATIVE_LOCATION']] = true;
  206. if($child['RELATIVE_LOCATION'] == $this->location){
  207. $this->addError($attribute, '注册'.$this->userName.'时,'.$this->conUserName.'的区位【'.$this->location.'】已经存在会员');
  208. }
  209. }
  210. // 第二区不能空点,必须要有会员才能注册到第三区
  211. // if($this->location == 3 && $isLocation[2] === false){
  212. // $this->addError($attribute, '注册'.$this->userName.'到'.$this->conUserName.'的第三区时,'.$this->conUserName.'的第二区不能空点');
  213. // }
  214. } else {
  215. // if($this->location != 1 && $this->scenario != 'addByAdmin'){
  216. // $this->addError($attribute, '注册'.$this->userName.'时,接点人'.$this->conUserName.'下的第一个区位必须选择左区');
  217. // }
  218. }
  219. }
  220. /**
  221. * 校验注册PV必须要大于最低级别要求
  222. * @param $attribute
  223. * @param $params
  224. */
  225. public function isMinDecLevel($attribute, $params){
  226. // 获取排序为2的报单级别
  227. $decLevel = DeclarationLevel::getLevelFromSort(1);
  228. if($this->zcPv < $decLevel['PERF']){
  229. $this->addError($attribute, '注册'.$this->userName.'时,注册PV低于最低级别要求,不能报首购单');
  230. }
  231. }
  232. /**
  233. * 同一身份证号是否在相同网络
  234. * @param $attribute
  235. */
  236. public function isSameNetwork($attribute){
  237. // 新加入会员的身份证号对应网内的其他会员
  238. $otherUser = User::find()->where("ID_CARD=:ID_CARD AND ID<>:ID AND IS_UNION=0 AND DELETED=0 AND (ID_CARD_PREFIX IS NULL OR ID_CARD_PREFIX='')", [':ID_CARD'=>$this->idCard, ':ID'=>$this->userId])->select('ID')->asArray()->all();
  239. // 拿到所有的批量报单数据
  240. foreach($this->allData as $decData){
  241. if($decData['insertUserIdCard'] == $this->idCard){
  242. $otherUser[] = ['ID'=>$decData['toUserId']];
  243. }
  244. }
  245. // 从多轨网络里面找到这些会员的最顶层会员
  246. if($otherUser){
  247. $otherUserIds = [];
  248. foreach($otherUser as $userId){
  249. $otherUserIds[] = $userId['ID'];
  250. }
  251. $otherUserIdsStr = implode("','", $otherUserIds);
  252. $otherUserIdsStr = "'".$otherUserIdsStr."'";
  253. $sameIdCardOtherTopUser = UserInfo::find()->where('USER_ID IN ('.$otherUserIdsStr.')')->orderBy('NETWORK_DEEP ASC')->asArray()->one();
  254. if($sameIdCardOtherTopUser){
  255. // 通过这个顶层会员查看新报单会员的接点人是不是他的下级
  256. if(!UserNetwork::find()->where('PARENT_UID=:PARENT_UID AND USER_ID=:USER_ID', [':PARENT_UID'=>$sameIdCardOtherTopUser['USER_ID'], ':USER_ID'=>$this->_conUid])->exists()){
  257. // 如果不存在的话,就看这个接点人是不是这个顶层的会员
  258. if($this->_conUid != $sameIdCardOtherTopUser['USER_ID']){
  259. $this->addError($attribute, '注册'.$this->userName.'时,同一身份证号会员必须在同一网体内');
  260. }
  261. }
  262. }
  263. }
  264. }
  265. /**
  266. * 添加会员
  267. * @return UserInfo|null
  268. * @throws Exception
  269. */
  270. public function add(){
  271. if(!$this->validate()){
  272. return null;
  273. }
  274. $insertUid = $this->userId;
  275. $insertUserName = $this->userName;
  276. $zcPv = $this->zcPv;
  277. $conUid = $this->_conUid;
  278. $recUid = $this->_recUid;
  279. $location = $this->location;
  280. // $db = \Yii::$app->db;
  281. // $transaction = $db->beginTransaction();
  282. try{
  283. $periodObj = Period::instance();
  284. $nowPeriodNum = $periodObj->getNowPeriodNum();
  285. // 查找接点人的体系信息
  286. $conUserInfo = UserInfo::find()->where('USER_ID=:USER_ID', [':USER_ID'=>$conUid])->asArray()->one();
  287. // 加入会员信息
  288. $userInfoModel = new UserInfo();
  289. $userInfoModel->USER_ID = $insertUid;
  290. $userInfoModel->USER_NAME = $insertUserName;
  291. $userInfoModel->ZC_PV = $zcPv;
  292. $userInfoModel->ZC_AMOUNT = $this->zcAmount;
  293. $userInfoModel->CON_UID = $conUid;
  294. $userInfoModel->REC_UID = $recUid;
  295. $userInfoModel->SYSTEM_ID = $conUserInfo['SYSTEM_ID'];
  296. //$userInfoModel->PERIOD_NUM = $nowPeriodNum;
  297. $userInfoModel->CREATED_AT = Date::nowTime();
  298. $userInfoModel->HIGHEST_EMP_LV = EmployLevel::getDefaultLevelId();
  299. $userInfoModel->ALLOW_TRANSFER = 1;
  300. $userInfoModel->HIGHEST_EMP_LV_PERIOD = $nowPeriodNum;
  301. $userInfoModel->TRANSFER_PROP = 100.00;
  302. $userInfoModel->IS_GROUP_LEADER = 0;
  303. $userInfoModel->GROUP_LEADER_AT = 0;
  304. if(!$userInfoModel->save()){
  305. throw new Exception('会员信息更新失败');
  306. }
  307. // 安置关系
  308. $this->_addToNetwork();
  309. // 开拓关系
  310. $this->_addToRelation();
  311. // 把会员的网络深度也追加上
  312. $userInfoModel->NETWORK_DEEP = $this->_conTopDeep;
  313. $userInfoModel->RELATION_DEEP = $this->_recTopDeep;
  314. if(!$userInfoModel->save()){
  315. throw new Exception('会员网络深度更新失败');
  316. }
  317. // 清空安置网络和开拓网络的顶点和顶点深度的数值
  318. $this->_conTopUid = null;
  319. $this->_conTopDeep = null;
  320. $this->_recTopUid = null;
  321. $this->_recTopDeep = null;
  322. // $transaction->commit();
  323. return $userInfoModel;
  324. } catch (Exception $e){
  325. // $transaction->rollBack();
  326. $this->addError('userId', $e->getMessage());
  327. //echo $e->getMessage().PHP_EOL;
  328. return null;
  329. }
  330. }
  331. /**
  332. * 添加会员
  333. * @param $nowPeriodNum
  334. * @return boolean
  335. */
  336. public function addForImport($nowPeriodNum){
  337. $insertUid = $this->userId;
  338. $insertUserName = $this->userName;
  339. $zcPv = $this->zcPv;
  340. $conUid = $this->conUid;
  341. $recUid = $this->recUid;
  342. try{
  343. // 查找接点人的体系信息
  344. // 加入会员信息
  345. $insertData = [
  346. 'USER_ID' => $insertUid,
  347. 'USER_NAME' => $insertUserName,
  348. 'ZC_PV' => $zcPv,
  349. 'ZC_AMOUNT' => $this->zcAmount,
  350. 'CON_UID' => $conUid,
  351. 'REC_UID' => $recUid,
  352. 'SYSTEM_ID' => "",
  353. 'CREATED_AT' => time(),
  354. 'HIGHEST_EMP_LV' => "",
  355. 'HIGHEST_EMP_LV_PERIOD' => $nowPeriodNum,
  356. 'TRANSFER_PROP' => 100.00,
  357. 'IS_GROUP_LEADER' => 0,
  358. 'GROUP_LEADER_AT' => 0,
  359. ];
  360. UserInfo::insertOne($insertData);
  361. unset($insertData);
  362. // 安置关系
  363. $this->_addToNetworkForImport();
  364. // 开拓关系
  365. //$this->_addToRelationForImport();
  366. // 把会员的网络深度也追加上
  367. UserInfo::updateAll([
  368. "NETWORK_DEEP" => $this->_conTopDeep,
  369. //"RELATION_DEEP" => $this->_recTopDeep,
  370. ], "USER_ID='{$insertUid}'");
  371. // 清空安置网络和开拓网络的顶点和顶点深度的数值
  372. $this->_conTopUid = null;
  373. $this->_conTopDeep = null;
  374. $this->_recTopUid = null;
  375. $this->_recTopDeep = null;
  376. unset($insertUid, $insertUserName, $conUid, $recUid);
  377. return true;
  378. } catch (Exception $e){
  379. $this->addError('userId', $e->getMessage());
  380. return false;
  381. }
  382. }
  383. /**
  384. * 加入安置网络
  385. * @throws Exception
  386. */
  387. private function _addToNetworkForImport(){
  388. //获取上级的点位信息
  389. $conNetInfo = UserNetwork::findOneAsArray(['USER_ID'=>$this->conUid]);
  390. if( !$conNetInfo ) {
  391. throw new Exception('接点人信息不存在');
  392. }
  393. $this->_conTopUid = $conNetInfo['TOP_UID'];
  394. $this->_conTopDeep = $conNetInfo['TOP_DEEP'] + 1;
  395. // 加入安置网络关系
  396. $insertData = [
  397. 'ID' => SnowFake::instance()->generateId(),
  398. "USER_ID" => $this->userId,
  399. "PARENT_UID" => $this->conUid,
  400. "LOCATION_TAG" => $conNetInfo['LOCATION_TAG'] . $this->location,
  401. "RELATIVE_LOCATION" => $this->location,
  402. "TOP_UID" => $conNetInfo['TOP_UID'],
  403. "TOP_DEEP" => $conNetInfo['TOP_DEEP'] + 1,
  404. "PARENT_UIDS" => $conNetInfo['PARENT_UIDS'] . ',' . $this->conUid,
  405. "CREATED_AT" => time(),
  406. ];
  407. UserNetwork::insertOne($insertData);
  408. if(!UserInfo::updateAllCounters(['CON_NUM'=>1], "USER_ID=:USER_ID", [':USER_ID'=>$this->conUid])){
  409. throw new Exception('会员安置关系下级节点数量更新失败');
  410. }
  411. }
  412. /**
  413. * 加入安置网络
  414. * @throws Exception
  415. */
  416. private function _addToNetwork(){
  417. //获取上级的点位信息
  418. $conNetInfo = UserNetwork::findOneAsArray(['USER_ID'=>$this->_conUid]);
  419. if( !$conNetInfo ) {
  420. throw new Exception('接点人信息不存在');
  421. }
  422. $this->_conTopUid = $conNetInfo['TOP_UID'];
  423. $this->_conTopDeep = $conNetInfo['TOP_DEEP'] + 1;
  424. // 加入安置网络关系
  425. if( $conNetInfo['PARENT_UIDS'] ) {
  426. $parentUids = $conNetInfo['PARENT_UIDS'] . ',' . $this->_conUid;
  427. }else {
  428. $parentUids = $this->_conUid;
  429. }
  430. $insertData = [
  431. 'ID' => SnowFake::instance()->generateId(),
  432. "USER_ID" => $this->userId,
  433. "PARENT_UID" => $this->_conUid,
  434. "LOCATION_TAG" => $conNetInfo['LOCATION_TAG'] . $this->location,
  435. "RELATIVE_LOCATION" => $this->location,
  436. "TOP_UID" => $conNetInfo['TOP_UID'],
  437. "TOP_DEEP" => $conNetInfo['TOP_DEEP'] + 1,
  438. "PARENT_UIDS" => $parentUids,
  439. "CREATED_AT" => time(),
  440. ];
  441. UserNetwork::insertOne($insertData);
  442. if(!UserInfo::updateAllCounters(['CON_NUM'=>1], "USER_ID=:USER_ID", [':USER_ID'=>$this->_conUid])){
  443. throw new Exception('会员安置关系下级节点数量更新失败');
  444. }
  445. }
  446. /**
  447. * 加入开拓网络
  448. * @throws Exception
  449. */
  450. private function _addToRelationForImport(){
  451. //获取上级的推荐信息
  452. $conRelationInfo = UserRelation::findOneAsArray(['USER_ID'=>$this->recUid]);
  453. if( !$conRelationInfo ) {
  454. throw new Exception('推荐人信息不存在');
  455. }
  456. $this->_recTopUid = $conRelationInfo['TOP_UID'];
  457. $this->_recTopDeep = $conRelationInfo['TOP_DEEP'] + 1;
  458. // 加入推荐网络关系
  459. $insertData = [
  460. 'ID' => SnowFake::instance()->generateId(),
  461. "USER_ID" => $this->userId,
  462. "PARENT_UID" => $this->recUid,
  463. "TOP_UID" => $conRelationInfo['TOP_UID'],
  464. "TOP_DEEP" => $conRelationInfo['TOP_DEEP'] + 1,
  465. "PARENT_UIDS" => $conRelationInfo['PARENT_UIDS'] . ',' . $this->recUid,
  466. "CREATED_AT" => time(),
  467. ];
  468. UserRelation::insertOne($insertData);
  469. if(!UserInfo::updateAllCounters(['REC_NUM'=>1], "USER_ID=:USER_ID", [':USER_ID'=>$this->recUid])){
  470. throw new Exception('会员开拓关系下级节点数量更新失败');
  471. }
  472. }
  473. /**
  474. * 加入开拓网络
  475. * @throws Exception
  476. */
  477. private function _addToRelation(){
  478. //获取上级的推荐信息
  479. $conRelationInfo = UserRelation::findOneAsArray(['USER_ID'=>$this->_recUid]);
  480. if( !$conRelationInfo ) {
  481. throw new Exception('推荐人信息不存在');
  482. }
  483. $this->_recTopUid = $conRelationInfo['TOP_UID'];
  484. $this->_recTopDeep = $conRelationInfo['TOP_DEEP'] + 1;
  485. if( $conRelationInfo['PARENT_UIDS'] ) {
  486. $parentUids = $conRelationInfo['PARENT_UIDS'] . ',' . $this->_recUid;
  487. }else {
  488. $parentUids = $this->_recUid;
  489. }
  490. // 加入推荐网络关系
  491. $insertData = [
  492. 'ID' => SnowFake::instance()->generateId(),
  493. "USER_ID" => $this->userId,
  494. "PARENT_UID" => $this->_recUid,
  495. "TOP_UID" => $conRelationInfo['TOP_UID'],
  496. "TOP_DEEP" => $conRelationInfo['TOP_DEEP'] + 1,
  497. "PARENT_UIDS" => $parentUids,
  498. "CREATED_AT" => time(),
  499. ];
  500. UserRelation::insertOne($insertData);
  501. if(!UserInfo::updateAllCounters(['REC_NUM'=>1], "USER_ID=:USER_ID", [':USER_ID'=>$this->_recUid])){
  502. throw new Exception('会员开拓关系下级节点数量更新失败');
  503. }
  504. }
  505. /**
  506. * 修改个人资料
  507. * @return User|null
  508. */
  509. public function modifyProfile(){
  510. if(!$this->validate()){
  511. return null;
  512. }
  513. $this->userOperateLogger->beforeUpdate(\Yii::$app->user->id,'ID',['select'=>'NATION,OPEN_BANK,BANK_NO,BANK_ADDRESS,EMAIL']);
  514. $uid = \Yii::$app->user->id;
  515. $model = User::findOne(['ID'=>$uid]);
  516. // $model->NATION = $this->nation;
  517. //$model->REAL_NAME = $this->realName;
  518. //$model->MOBILE = $this->mobile;
  519. //$model->ID_CARD = $this->idCard;
  520. // $model->OPEN_BANK = $this->openBank;
  521. // $model->BANK_NO = $this->bankNo;
  522. // $model->BANK_ADDRESS = $this->bankAddress;
  523. $model->EMAIL = $this->email;
  524. if(!$model->save()){
  525. $this->addErrors($model->getErrors());
  526. return null;
  527. }
  528. User::updateBaseInfoToRedis($uid);
  529. $this->userOperateLogger->afterUpdate(\Yii::$app->user->id,'ID',['select'=>'NATION,OPEN_BANK,BANK_NO,BANK_ADDRESS']);
  530. $this->userOperateLogger->clean()->save([
  531. 'optType' => '会员修改资料',
  532. 'userId' => \Yii::$app->user->id,
  533. 'userName' => Info::getUserNameByUserId(\Yii::$app->user->id),
  534. ]);
  535. return $model;
  536. }
  537. /**
  538. * 修改密码
  539. */
  540. public function modifyPassword(){
  541. if(!$this->validate()){
  542. return null;
  543. }
  544. $uid = \Yii::$app->user->id;
  545. $model = User::findOne(['ID'=>$uid]);
  546. if ( !$model->validatePassword($this->oldPassword) ) {
  547. $this->addError('modifyPassword', Yii::t('app', 'originalLoginPasswordError'));
  548. return false;
  549. }
  550. $model->PASSWORD_HASH = \Yii::$app->security->generatePasswordHash($this->password);
  551. if(!$model->save()){
  552. $this->addErrors($model->getErrors());
  553. return false;
  554. }
  555. return true;
  556. }
  557. /**
  558. * 修改支付密码
  559. */
  560. public function modifyPasswordPay(){
  561. if(!$this->validate()){
  562. return null;
  563. }
  564. $uid = \Yii::$app->user->id;
  565. $model = User::findOne(['ID'=>$uid]);
  566. if ( !$model->validatePasswordPay($this->oldPassword) ) {
  567. $this->addError('modifyPasswordPay', Yii::t('app', 'originalPaymentPasswordError'));
  568. return false;
  569. }
  570. $model->PAY_PASSWORD = \Yii::$app->security->generatePasswordHash($this->payPassword);
  571. if(!$model->save()){
  572. $this->addErrors($model->getErrors());
  573. return false;
  574. }
  575. return true;
  576. }
  577. /**
  578. * 不登录修改密码
  579. */
  580. public function noLoginModifyPassword(){
  581. if(!$this->validate()){
  582. return null;
  583. }
  584. $model = User::findOne(["USER_NAME"=>$this->userName]);
  585. if( !$model ) {
  586. $this->addError('noLoginModifyPassword', Yii::t('app', 'userNameNotExists'));
  587. return false;
  588. }
  589. if ( !$model->validatePassword($this->oldPassword) ) {
  590. $this->addError('noLoginModifyPassword', Yii::t('app', 'originalLoginPasswordError'));
  591. return false;
  592. }
  593. $model->PASSWORD_HASH = \Yii::$app->security->generatePasswordHash($this->password);
  594. $model->IS_MODIFY_PASSWORD = 0;
  595. if(!$model->save()){
  596. $this->addErrors($model->getErrors());
  597. return false;
  598. }
  599. return true;
  600. }
  601. }