User.php 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571
  1. <?php
  2. namespace common\models;
  3. use common\helpers\Cache;
  4. use common\helpers\Tool;
  5. use common\helpers\user\Info;
  6. use Yii;
  7. use yii\helpers\Json;
  8. use common\libs\logging\operate\valueType\Config as ValueTypeConfig;
  9. /**
  10. * This is the model class for table "{{%USER}}".
  11. *
  12. * @property string $ID
  13. * @property string $USER_NAME 帐号
  14. * @property string $PASSWORD_HASH 登录密码
  15. * @property string $PAY_PASSWORD 支付密码
  16. * @property int $NATION 民族
  17. * @property string $REAL_NAME 姓名
  18. * @property string $ID_CARD 身份证号
  19. * @property int $ID_TYPE 证件类型
  20. * @property string $MOBILE 手机号
  21. * @property string $ADDRESS 身份证地址
  22. * @property string $ID_IMAGE 证件图片
  23. * @property string $OPEN_BANK 开户行
  24. * @property string $BANK_ADDRESS 银行地址
  25. * @property string $BANK_NO 银行卡号
  26. * @property int $BANK_PROVINCE 银行省份
  27. * @property int $BANK_CITY 银行城市
  28. * @property int $BANK_COUNTY 银行县区
  29. * @property string $SPOUSE_NAME 配偶姓名
  30. * @property string $SPOUSE_IDCARD 配偶证件号
  31. * @property int $CREATED_AT 创建时间
  32. * @property int $UPDATED_AT 更新时间
  33. * @property int $STATUS 状态
  34. * @property int $DEC_CLOSED 是否关闭报单功能
  35. * @property int $DEC_CLOSED_AT 关闭时间
  36. * @property string $DEC_LV 报单级别
  37. * @property string $EMP_LV 聘级
  38. * @property int $PROVINCE 省份
  39. * @property int $CITY 城市
  40. * @property int $COUNTY 县区
  41. * @property string $TEL 座机
  42. * @property string $SUB_COM_ID 子公司ID
  43. * @property string $AVATAR 头像
  44. * @property int $DELETED 是否删除
  45. * @property int $DELETED_AT 删除时间
  46. * @property int $IS_DEC 是否为报单中心
  47. * @property int $IS_ATLAS 是否显示图谱
  48. * @property int $IS_RECHARGE 是否显示充值
  49. * @property string $DEC_ID 报单中心ID
  50. * @property string $BIRTHDAY 生日
  51. * @property string $DEC_ROLE_ID 报单中心级别
  52. * @property int $PERIOD_AT 期数
  53. * @property int $DEC_PROVINCE 报单中心所属的省份
  54. * @property int $DEC_CITY 报单中心所属的城市
  55. * @property int $DEC_COUNTY 报单中心所属的县区
  56. * @property int $IS_UNION 是否为点位合作
  57. * @property int $STATUS_AT 状态更改时间
  58. * @property int $VERIFIED 是否认证
  59. * @property int $VERIFIED_AT 认证时间
  60. * @property int $ALLOW_LOGIN 允许登录
  61. * @property int $NOT_OPERATING 不运作
  62. * @property int $REG_FROM 注册类型
  63. * @property string $ID_CARD_PREFIX 身份证前缀
  64. * @property string $SEX 性别
  65. * @property string $DEC_ACCOUNT_OLD 老系统中的报单中心编号
  66. * @property int $BANK_UPDATED_AT 银行信息更新时间
  67. * @property int $IS_DIRECT_SELLER 是否为直销员
  68. * @property int $DEC_LV_UPDATED_AT 报单级别更新时间
  69. * @property int $DEC_LV_UPDATED_PERIOD 报单级别更新期数
  70. * @property string $DEC_ADDRESS 报单中心详细地址
  71. * @property string $DEC_PHONE 报单中心电话
  72. * @property string $GUARANTOR 担保人编号
  73. * @property string $GUARANTOR_NAME 担保人姓名
  74. * @property int $PART_FUNC_CLOSED 部分功能开启
  75. * @property int $LAST_DEC_LV_UPDATED_PERIOD 上次报单级别更新期数
  76. * @property string $USER_CREATOR 创建人
  77. * @property string $USER_UPDATER 修改人
  78. * @property int $LAST_DEC_LV_UPDATED_AT 上次报单级别更新时间
  79. * @property int $DEC_CREATED_AT 成为报单中心时间
  80. * @property string $PART_FUNC_CLOSED_REMARK 部分功能关闭原因
  81. * @property int $DEC_CREATED_PERIOD 成为报单中心期数
  82. * @property int $PASSWORD_CHANGED 是否修改过密码
  83. * @property int $SUB_COM_LEADER 是否为分公司领导
  84. * @property string $ZG_UPGRADE_PV 增购升级PV
  85. * @property string $APP_CLIENT_ID APP设备ID
  86. * @property int $READ_AGREEMENT 已读协议
  87. * @property string $LAST_DEC_LV 上次的报单级别
  88. * @property string $BONUS_APP_CLIENT_ID 结算APP设备ID
  89. * @property int $IS_FIRST_OPEN 首次开通
  90. * @property int $IS_MODIFY_PASSWORD 是否修改密码
  91. * @property int $IS_STUDIO 是否是工作室
  92. * @property int $IS_STUDIO_CODE 工作室编号
  93. * @property int $IS_STUDIO_DATE 工作室时间
  94. */
  95. class User extends \common\components\ActiveRecord
  96. {
  97. /**
  98. * @inheritdoc
  99. */
  100. public static function tableName()
  101. {
  102. return '{{%USER}}';
  103. }
  104. /**
  105. * @inheritdoc
  106. */
  107. public function rules()
  108. {
  109. return [
  110. [['USER_NAME', 'PASSWORD_HASH', 'PAY_PASSWORD', 'REAL_NAME', 'ID_CARD', 'AVATAR'], 'required'],
  111. [['NATION', 'ID_TYPE', 'BANK_PROVINCE', 'BANK_CITY', 'BANK_COUNTY', 'CREATED_AT', 'UPDATED_AT', 'STATUS', 'DEC_CLOSED', 'DEC_CLOSED_AT', 'PROVINCE', 'CITY', 'COUNTY', 'DELETED', 'DELETED_AT', 'IS_DEC', 'IS_ATLAS', 'IS_RECHARGE','IS_STUDIO', 'PERIOD_AT', 'DEC_PROVINCE', 'DEC_CITY', 'DEC_COUNTY', 'IS_UNION', 'STATUS_AT', 'VERIFIED', 'VERIFIED_AT', 'ALLOW_LOGIN', 'NOT_OPERATING', 'REG_FROM', 'BANK_UPDATED_AT', 'IS_DIRECT_SELLER', 'DEC_LV_UPDATED_AT', 'DEC_LV_UPDATED_PERIOD', 'PART_FUNC_CLOSED', 'LAST_DEC_LV_UPDATED_PERIOD', 'LAST_DEC_LV_UPDATED_AT', 'DEC_CREATED_AT', 'DEC_CREATED_PERIOD', 'PASSWORD_CHANGED', 'SUB_COM_LEADER', 'READ_AGREEMENT', 'IS_FIRST_OPEN', 'IS_MODIFY_PASSWORD'], 'integer'],
  112. [['ZG_UPGRADE_PV'], 'number'],
  113. [['ID', 'OPEN_BANK', 'BANK_NO', 'DEC_LV', 'EMP_LV', 'SUB_COM_ID', 'DEC_ID', 'DEC_ROLE_ID', 'ID_CARD_PREFIX', 'SEX', 'DEC_PHONE', 'GUARANTOR', 'USER_CREATOR', 'USER_UPDATER', 'LAST_DEC_LV'], 'string', 'max' => 32],
  114. [['USER_NAME', 'SPOUSE_NAME', 'TEL'], 'string', 'max' => 16],
  115. [['PASSWORD_HASH', 'PAY_PASSWORD', 'ID_IMAGE', 'BANK_ADDRESS', 'AVATAR'], 'string', 'max' => 255],
  116. [['REAL_NAME', 'APP_CLIENT_ID', 'BONUS_APP_CLIENT_ID'], 'string', 'max' => 128],
  117. [['ID_CARD', 'SPOUSE_IDCARD'], 'string','min' => 18, 'max' => 18],
  118. [['MOBILE'], 'string','min' => 11, 'max' => 11],
  119. [['ADDRESS', 'DEC_ADDRESS'], 'string', 'max' => 2000],
  120. [['DEC_ACCOUNT_OLD', 'GUARANTOR_NAME'], 'string', 'max' => 64],
  121. [['PART_FUNC_CLOSED_REMARK'], 'string', 'max' => 4000],
  122. [['USER_NAME'], 'unique'],
  123. [['ID'], 'unique'],
  124. ];
  125. }
  126. /**
  127. * @inheritdoc
  128. */
  129. public function attributeLabels()
  130. {
  131. return [
  132. 'ID' => 'ID',
  133. 'USER_NAME' => '帐号',
  134. 'PASSWORD_HASH' => '登录密码',
  135. 'PAY_PASSWORD' => '支付密码',
  136. 'NATION' => '民族',
  137. 'REAL_NAME' => '姓名',
  138. 'ID_CARD' => '身份证号',
  139. 'ID_TYPE' => '证件类型',
  140. 'MOBILE' => '手机号',
  141. 'ADDRESS' => '身份证地址',
  142. 'ID_IMAGE' => '证件图片',
  143. 'OPEN_BANK' => '开户行',
  144. 'BANK_ADDRESS' => '银行地址',
  145. 'BANK_NO' => '银行卡号',
  146. 'BANK_PROVINCE' => '银行省份',
  147. 'BANK_CITY' => '银行城市',
  148. 'BANK_COUNTY' => '银行县区',
  149. 'SPOUSE_NAME' => '配偶姓名',
  150. 'SPOUSE_IDCARD' => '配偶证件号',
  151. 'CREATED_AT' => '创建时间',
  152. 'UPDATED_AT' => '更新时间',
  153. 'STATUS' => '状态',
  154. 'DEC_CLOSED' => '是否关闭报单功能',
  155. 'DEC_CLOSED_AT' => '关闭时间',
  156. 'DEC_LV' => '报单级别',
  157. 'EMP_LV' => '聘级',
  158. 'PROVINCE' => '省份',
  159. 'CITY' => '城市',
  160. 'COUNTY' => '县区',
  161. 'TEL' => '座机',
  162. 'SUB_COM_ID' => '子公司ID',
  163. 'AVATAR' => '头像',
  164. 'DELETED' => '是否删除',
  165. 'DELETED_AT' => '删除时间',
  166. 'IS_DEC' => '是否为报单中心',
  167. 'IS_ATLAS' => '是否显示图谱',
  168. 'IS_RECHARGE' => '是否显示充值',
  169. 'DEC_ID' => '报单中心ID',
  170. 'BIRTHDAY' => '生日',
  171. 'DEC_ROLE_ID' => '报单中心级别',
  172. 'PERIOD_AT' => '期数',
  173. 'DEC_PROVINCE' => '报单中心所属的省份',
  174. 'DEC_CITY' => '报单中心所属的城市',
  175. 'DEC_COUNTY' => '报单中心所属的县区',
  176. 'IS_UNION' => '是否为点位合作',
  177. 'STATUS_AT' => '状态更改时间',
  178. 'VERIFIED' => '是否认证',
  179. 'VERIFIED_AT' => '认证时间',
  180. 'ALLOW_LOGIN' => '允许登录',
  181. 'NOT_OPERATING' => '不运作',
  182. 'REG_FROM' => '注册类型',
  183. 'ID_CARD_PREFIX' => '身份证前缀',
  184. 'SEX' => '性别',
  185. 'DEC_ACCOUNT_OLD' => '老系统中的报单中心编号',
  186. 'BANK_UPDATED_AT' => '银行信息更新时间',
  187. 'IS_DIRECT_SELLER' => '是否为直销员',
  188. 'DEC_LV_UPDATED_AT' => '报单级别更新时间',
  189. 'DEC_LV_UPDATED_PERIOD' => '报单级别更新期数',
  190. 'DEC_ADDRESS' => '报单中心详细地址',
  191. 'DEC_PHONE' => '报单中心电话',
  192. 'GUARANTOR' => '担保人编号',
  193. 'GUARANTOR_NAME' => '担保人姓名',
  194. 'PART_FUNC_CLOSED' => '部分功能开启',
  195. 'LAST_DEC_LV_UPDATED_PERIOD' => '上次报单级别更新期数',
  196. 'USER_CREATOR' => '创建人',
  197. 'USER_UPDATER' => '修改人',
  198. 'LAST_DEC_LV_UPDATED_AT' => '上次报单级别更新时间',
  199. 'DEC_CREATED_AT' => '成为报单中心时间',
  200. 'PART_FUNC_CLOSED_REMARK' => '部分功能关闭原因',
  201. 'DEC_CREATED_PERIOD' => '成为报单中心期数',
  202. 'PASSWORD_CHANGED' => '是否修改过密码',
  203. 'SUB_COM_LEADER' => '是否为分公司领导',
  204. 'ZG_UPGRADE_PV' => '增购升级PV',
  205. 'APP_CLIENT_ID' => 'APP设备ID',
  206. 'READ_AGREEMENT' => '已读协议',
  207. 'LAST_DEC_LV' => '上次的报单级别',
  208. 'BONUS_APP_CLIENT_ID' => '结算APP设备ID',
  209. 'IS_FIRST_OPEN' => '首次开通',
  210. 'IS_MODIFY_PASSWORD' => '是否修改密码',
  211. 'IS_STUDIO' => '是否是工作室',
  212. 'IS_STUDIO_CODE' => '工作室编号',
  213. 'IS_STUDIO_DATE' => '工作室日期',
  214. ];
  215. }
  216. public function getUserInfo()
  217. {
  218. return $this->hasOne(UserInfo::class, ['USER_ID' => 'ID']);
  219. }
  220. /**
  221. * 获取会员基本信息
  222. * @param $userId
  223. * @return array|null|\yii\db\ActiveRecord
  224. */
  225. public static function getBaseInfo($userId){
  226. return static::findUseSlaves()->where('ID=:ID', [':ID'=>$userId])->asArray()->one();
  227. }
  228. /**
  229. * 获取用户基本信息从redis里面
  230. * @param $userId
  231. * @return array|null|\yii\db\ActiveRecord
  232. */
  233. public static function getBaseInfoFromRedis($userId){
  234. $userInfo = Yii::$app->redis->hget(Cache::USER_INFO_KEY, $userId);
  235. if(!$userInfo){
  236. $userInfo = static::find()->select('ID,USER_NAME,NATION,REAL_NAME,ID_CARD,ID_TYPE,MOBILE,ADDRESS,STATUS,DEC_LV,LAST_DEC_LV,EMP_LV,DEC_CLOSED,AVATAR,OPEN_BANK,BANK_ADDRESS,BANK_NO,VERIFIED,IS_UNION,IS_DEC,IS_ATLAS,IS_RECHARGE,IS_STUDIO,DEC_ROLE_ID,PROVINCE,CITY,COUNTY')->where('ID=:ID', [':ID'=>$userId])->asArray()->one();
  237. Yii::$app->redis->hset(Cache::USER_INFO_KEY, $userId, Json::encode($userInfo));
  238. } else {
  239. $userInfo = Json::decode($userInfo);
  240. }
  241. return $userInfo;
  242. }
  243. /**
  244. * 更新缓存
  245. * @param $userId
  246. * @return mixed
  247. */
  248. public static function updateBaseInfoToRedis($userId){
  249. $userInfo = static::find()->select('ID,USER_NAME,NATION,REAL_NAME,ID_CARD,ID_TYPE,MOBILE,ADDRESS,STATUS,DEC_LV,LAST_DEC_LV,EMP_LV,DEC_CLOSED,AVATAR,OPEN_BANK,BANK_ADDRESS,BANK_NO,VERIFIED,IS_UNION,IS_DEC,IS_ATLAS,IS_RECHARGE,IS_STUDIO,DEC_ROLE_ID,PROVINCE,CITY,COUNTY')->where('ID=:ID', [':ID'=>$userId])->asArray()->one();
  250. return Yii::$app->redis->hset(Cache::USER_INFO_KEY, $userId, Json::encode($userInfo));
  251. }
  252. /**
  253. * @param $userId
  254. * 删除用户信息缓存
  255. */
  256. public static function deleteBaseInfoFromRedis($userId) {
  257. Yii::$app->redis->hdel(Cache::USER_INFO_KEY, $userId);
  258. }
  259. /**
  260. * 批量删除用户
  261. * @return void
  262. */
  263. public static function deleteAllBaseInfoFromRedis() {
  264. Yii::$app->redis->del(Cache::USER_INFO_KEY);
  265. }
  266. /**
  267. * 获取会员的部分信息并对敏感信息加密
  268. * @param $userId
  269. * @return array
  270. */
  271. public static function getEnCodeInfo($userId){
  272. $userInfo = self::getBaseInfoFromRedis($userId);
  273. return [
  274. 'ID' => $userId,
  275. 'USER_NAME' => $userInfo['USER_NAME'],
  276. 'NATION' => \Yii::$app->params['nation'][$userInfo['NATION']]['name']??'',
  277. 'NATION_ID' => \Yii::$app->params['nation'][$userInfo['NATION']]['id']??'',
  278. 'REAL_NAME' => $userInfo['REAL_NAME'],
  279. 'ID_CARD' => $userInfo['ID_CARD'],
  280. // 'ID_CARD' => Tool::hideIdCard($userInfo['ID_CARD']),
  281. 'MOBILE' => $userInfo['MOBILE'],
  282. // 'MOBILE' => Tool::hideMobile($userInfo['MOBILE']),
  283. 'AVATAR' => $userInfo['AVATAR'],
  284. 'VERIFIED' => $userInfo['VERIFIED'],
  285. 'IS_UNION' => $userInfo['IS_UNION'],
  286. 'IS_DEC' => $userInfo['IS_DEC'],
  287. 'IS_ATLAS' => $userInfo['IS_ATLAS'],
  288. 'IS_RECHARGE' => $userInfo['IS_RECHARGE'],
  289. 'IS_STUDIO' => $userInfo['IS_STUDIO'],
  290. 'DEC_ROLE_ID' => $userInfo['DEC_ROLE_ID'],
  291. 'OPEN_BANK' => $userInfo['OPEN_BANK'],
  292. 'BANK_ADDRESS' => $userInfo['BANK_ADDRESS'],
  293. 'DEC_LV' => $userInfo['DEC_LV'],
  294. 'EMP_LV' => $userInfo['EMP_LV'],
  295. 'PROVINCE' => $userInfo['PROVINCE'],
  296. 'CITY' => $userInfo['CITY'],
  297. 'COUNTY' => $userInfo['COUNTY'],
  298. 'BANK_NO' => $userInfo['BANK_NO'],
  299. // 'BANK_NO' => Tool::hideBankNo($userInfo['BANK_NO']) ,
  300. ];
  301. }
  302. /**
  303. * 验证密码
  304. * @param $password
  305. * @return bool
  306. */
  307. public function validatePassword($password) {
  308. if( !$this->PASSWORD_HASH ) return false;
  309. return password_verify($password, $this->PASSWORD_HASH);
  310. }
  311. /**
  312. * verificationPassword
  313. *
  314. * @param string $password password to validate
  315. * @return bool if password provided is valid for current user
  316. */
  317. public function verificationPassword($password,$scenario,$model)
  318. {
  319. // 判断密码长度不能少于8位
  320. if (strlen($password) < 8){
  321. return [ 'code' => 1000, 'type' => $scenario , 'message' => '登录密码不能小于8位' ];
  322. }
  323. // 判断密码中数字、大写字母、小写字母、特殊字符至少三种
  324. $symbol = '`~!@#$^&*()=|{}\'\":;\',\\[\\].<>\/?~!@#¥……&*()——|{}【】‘;:”。,、?';
  325. // $requiredRules = '/^(?![\d]+$)(?![a-z]+$)(?![A-Z]+$)(?!['.$symbol.']+$)[\da-zA-z'.$symbol.']{8,}$/'; // 这是两种的正则
  326. $requiredRules = '/^(?![\da-z]+$)(?![\dA-Z]+$)(?![\d'.$symbol.']+$)(?![a-zA-Z]+$)(?![a-z'.$symbol.']+$)(?![A-Z'.$symbol.']+$)[\da-zA-z'.$symbol.']{8,}$/';
  327. $requiredHandleResults = preg_match($requiredRules,$password);
  328. if (!$requiredHandleResults){
  329. return [ 'code' => 1000, 'type' => $scenario , 'message' => '登录密码中需要包含数字、大写字母、小写字母、特殊字符至少三种' ];
  330. }
  331. // 判断有三位以上重复性
  332. if(preg_match('/(\w)*(\w)\1{2}(\w)*/',$password)) {
  333. return [ 'code' => 1000, 'type' => $scenario , 'message' => '登录密码中数字、大写字母、小写字母不能连续重复三个以上' ];
  334. }
  335. // 判断密码中不能出现登录账号
  336. if (strpos($password, $model->USER_NAME) !== false){
  337. return [ 'code' => 1000, 'type' => $scenario , 'message' => '登录密码中不允许出现会员登录账号的信息' ];
  338. }
  339. // 判断密码中不能出现会员的手机号
  340. if ($model->MOBILE){
  341. if (strpos($password, $model->MOBILE) !== false){
  342. return [ 'code' => 1000, 'type' => $scenario , 'message' => '登录密码中不允许出现会员的联系方式' ];
  343. }
  344. }
  345. // 判断密码中不能出现会员的生日
  346. if ($model->ID_CARD && strlen($model->ID_CARD) == 18){
  347. $idCard = substr($model->ID_CARD,6,8);
  348. if (strpos($password, $idCard) !== false){
  349. return [ 'code' => 1000, 'type' => $scenario , 'message' => '登录密码中不允许出现会员的生日' ];
  350. }
  351. }
  352. return [ 'code' => 200, 'type' => $scenario , 'message' => '验证通过了' ];
  353. }
  354. /**
  355. * 验证支付密码
  356. * @param $payPassword
  357. * @return bool
  358. */
  359. public function validatePasswordPay($payPassword) {
  360. if( !$this->PAY_PASSWORD ) return false;
  361. return password_verify($payPassword, $this->PAY_PASSWORD);
  362. }
  363. /**
  364. * 检验支付密码
  365. * @param $userId
  366. * @param $password
  367. * @return bool
  368. */
  369. public static function validatePayPassword($userId, $password){
  370. $oneUser = static::find()->select('PAY_PASSWORD')->where('ID=:ID', [':ID'=>$userId])->asArray()->one();
  371. if($oneUser){
  372. return password_verify($password, $oneUser['PAY_PASSWORD']);
  373. } else {
  374. return false;
  375. }
  376. }
  377. /**
  378. * 判断用户是否是观察期
  379. * 观望期:自加入算起2个月
  380. * 例子:2022年5月14日加入, 观望期至2022年7月31日。
  381. * true为是观察期用户 false为不是观察期用户
  382. * @param $addAt 用户的加入时间
  383. * @param $month 观察期月份限制 系统初始化为2个月
  384. */
  385. public static function checkIsObserve($addAt, $month) {
  386. if (empty($month)) {
  387. // 如果0 代表全站全额升级
  388. return false;
  389. }
  390. $appendMonth = date("Y-m", strtotime("first day of +$month month", $addAt)); // 指定月份
  391. $lastDay = date("t", strtotime($appendMonth)); // 获取指定月的最后一天
  392. $eTime = strtotime($appendMonth.'-'.$lastDay);
  393. return time() < $eTime ? true : false;
  394. }
  395. // 获取用户报单PV总和
  396. public static function sumDevPvByUserId($userId) {
  397. $decOrderPv = DecOrder::find()
  398. ->select('SUM(DEC_PV) AS PV_SUM')
  399. ->where('TO_USER_ID=:TO_USER_ID AND IS_DEL=0',
  400. [
  401. 'TO_USER_ID'=>$userId,
  402. ]
  403. )
  404. ->asArray()
  405. ->one();
  406. $decOrderPv = isset($decOrderPv['PV_SUM']) ? $decOrderPv['PV_SUM'] : 0;
  407. $orderDecPv = OrderDec::find()
  408. ->select('SUM(PAY_PV) AS PV_SUM')
  409. ->where('USER_ID=:USER_ID AND IS_DELETE=0',
  410. [
  411. 'USER_ID'=>$userId,
  412. ]
  413. )
  414. ->asArray()
  415. ->one();
  416. $orderDecPv = isset($orderDecPv['PV_SUM']) ? $orderDecPv['PV_SUM'] : 0;
  417. // 还得加上用户在老系统中的所有报单PV之和
  418. $originPv = OriginDecPv::find()
  419. ->select('SUM(DEC_PV) AS PV_SUM')
  420. ->where('USER_ID=:USER_ID',
  421. [
  422. 'USER_ID'=>$userId,
  423. ]
  424. )
  425. ->asArray()
  426. ->one();
  427. $originPv = isset($originPv['PV_SUM']) ? $originPv['PV_SUM'] : 0;
  428. $total = $orderDecPv + $decOrderPv + $originPv;
  429. return $total;
  430. }
  431. /**
  432. * 操作日志记录条件
  433. * @return array
  434. */
  435. public function attrLabelsWithLogType(){
  436. return [
  437. 'ID' => 'ID',
  438. 'USER_NAME' => '帐号',
  439. 'NATION' => [
  440. 'label' => '民族',
  441. 'type' => function($data){
  442. $value = $data['value'];
  443. return \Yii::$app->params['nation'][$value]['name']??'';
  444. },
  445. ],
  446. 'REAL_NAME' => '姓名',
  447. 'ID_CARD' => '身份证号',
  448. 'ID_TYPE' => [
  449. 'label' => '证件类型',
  450. 'type' => function($data){
  451. return '身份证';
  452. },
  453. ],
  454. 'MOBILE' => '手机号',
  455. 'ADDRESS' => '身份证地址',
  456. 'ID_IMAGE' => '证件图片',
  457. 'OPEN_BANK' => '开户行',
  458. 'BANK_ADDRESS' => '银行地址',
  459. 'BANK_NO' => '银行卡号',
  460. 'BANK_PROVINCE' => [
  461. 'label' => '银行省份',
  462. 'type' => ValueTypeConfig::REGION_TYPE
  463. ],
  464. 'BANK_CITY' => [
  465. 'label' => '银行城市',
  466. 'type' => ValueTypeConfig::REGION_TYPE
  467. ],
  468. 'BANK_COUNTY' => [
  469. 'label' => '银行县区',
  470. 'type' => ValueTypeConfig::REGION_TYPE
  471. ],
  472. 'SPOUSE_NAME' => '配偶姓名',
  473. 'SPOUSE_IDCARD' => '配偶证件号',
  474. 'STATUS' => [
  475. 'label' => '状态',
  476. 'type' => ValueTypeConfig::USER_STATUS_TYPE
  477. ],
  478. 'DEC_CLOSED' => [
  479. 'label' => '是否关闭报单功能',
  480. 'type' => ValueTypeConfig::YES_NO_TYPE,
  481. ],
  482. 'DEC_CLOSED_AT' => [
  483. 'label' => '关闭报单时间',
  484. 'type' => ValueTypeConfig::DATE_TIME_TYPE,
  485. ],
  486. 'DEC_LV' => [
  487. 'label' => '报单级别',
  488. 'type' => ValueTypeConfig::DEC_LV_TYPE,
  489. ],
  490. 'EMP_LV' => [
  491. 'label' => '聘级',
  492. 'type' => ValueTypeConfig::EMP_LV_TYPE,
  493. ],
  494. 'LAST_DEC_LV' => [
  495. 'label' => '上次的报单级别',
  496. 'type' => ValueTypeConfig::DEC_LV_TYPE,
  497. ],
  498. 'PROVINCE' => [
  499. 'label' => '省份',
  500. 'type' => ValueTypeConfig::REGION_TYPE
  501. ],
  502. 'CITY' => [
  503. 'label' => '城市',
  504. 'type' => ValueTypeConfig::REGION_TYPE
  505. ],
  506. 'COUNTY' => [
  507. 'label' => '县区',
  508. 'type' => ValueTypeConfig::REGION_TYPE
  509. ],
  510. 'TEL' => '备用手机号码',
  511. 'SUB_COM_ID' => '分公司ID',
  512. 'TRANSFER_PROP' => '转帐比例',
  513. 'IS_DEC' => [
  514. 'label' => '是否为报单中心',
  515. 'type' => ValueTypeConfig::YES_NO_TYPE,
  516. ],
  517. 'DEC_ROLE_ID' => [
  518. 'label' => '报单中心级别',
  519. 'type' => ValueTypeConfig::DEC_ROLE_ID_TYPE,
  520. ],
  521. 'IS_UNION' => [
  522. 'label' => '是否为点位合作',
  523. 'type' => ValueTypeConfig::YES_NO_TYPE,
  524. ],
  525. 'STATUS_AT' => '状态修改时间',
  526. 'ALLOW_LOGIN' => [
  527. 'label' => '是否允许商城登录',
  528. 'type' => ValueTypeConfig::YES_NO_TYPE,
  529. ],
  530. 'NOT_OPERATING' => [
  531. 'label' => '不运作',
  532. 'type' => ValueTypeConfig::YES_NO_TYPE,
  533. ],
  534. 'BIRTHDAY' => '生日',
  535. 'SEX' => '性别',
  536. ];
  537. }
  538. }