User.php 7.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292
  1. <?php
  2. namespace app\common\model\user;
  3. use app\common\model\BaseModel;
  4. use app\common\model\store\service\StoreService;
  5. use app\common\model\wechat\WechatUser;
  6. use app\common\repositories\store\coupon\StoreCouponUserRepository;
  7. use app\common\repositories\store\order\StoreGroupOrderRepository;
  8. use app\common\repositories\store\service\StoreServiceLogRepository;
  9. use app\common\repositories\user\UserBillRepository;
  10. use app\common\repositories\user\UserExtractRepository;
  11. use app\common\repositories\user\UserHistoryRepository;
  12. use app\common\repositories\user\UserRechargeRepository;
  13. use app\common\repositories\user\UserRelationRepository;
  14. use app\common\repositories\user\UserRepository;
  15. use app\common\repositories\user\UserVisitRepository;
  16. /**
  17. * Class User
  18. * @package app\common\model\user
  19. * @author zfy
  20. * @day 2020-04-28
  21. */
  22. class User extends BaseModel
  23. {
  24. public $isNew = false;
  25. /**
  26. * @return string
  27. * @author zfy
  28. * @day 2020-03-30
  29. */
  30. public static function tablePk(): string
  31. {
  32. return 'uid';
  33. }
  34. /**
  35. * @return string
  36. * @author zfy
  37. * @day 2020-03-30
  38. */
  39. public static function tableName(): string
  40. {
  41. return 'user';
  42. }
  43. /**
  44. * @param $value
  45. * @return string
  46. * @author zfy
  47. * @day 2020-05-09
  48. */
  49. public function getBirthdayAttr($value)
  50. {
  51. return $value == '0000-00-00' ? '' : $value;
  52. }
  53. /**
  54. * @param $value
  55. * @return array
  56. * @author zfy
  57. * @day 2020-05-09
  58. */
  59. public function getLabelIdAttr($value)
  60. {
  61. return $value ? explode(',', $value) : [];
  62. }
  63. /**
  64. * @param $value
  65. * @return string
  66. * @author zfy
  67. * @day 2020-05-09
  68. */
  69. public function setLabelIdAttr($value)
  70. {
  71. return implode(',', $value);
  72. }
  73. public function getValidSpreadUidAttr()
  74. {
  75. if (!$this->spread_uid) return 0;
  76. else {
  77. $data = self::getDB()->where('uid', $this->spread_uid)->field('is_promoter,spread_uid')->find();
  78. if ($data && $data['is_promoter'])
  79. return $this->spread_uid;
  80. else
  81. return 0;
  82. }
  83. }
  84. public function getValidSpreadAttr()
  85. {
  86. if (!$this->spread_uid) return null;
  87. else {
  88. $data = self::getDB()->where('uid', $this->spread_uid)->field('is_promoter,spread_uid,brokerage_level,uid')->find();
  89. if ($data && $data['is_promoter'])
  90. return $data;
  91. else
  92. return null;
  93. }
  94. }
  95. public function getValidTopUidAttr()
  96. {
  97. if (!$this->top_uid) return 0;
  98. else {
  99. $data = self::getDB()->where('uid', $this->top_uid)->field('is_promoter,spread_uid')->find();
  100. if ($data && $data['is_promoter'])
  101. return $this->top_uid;
  102. else
  103. return 0;
  104. }
  105. }
  106. public function getValidTopAttr()
  107. {
  108. if (!$this->top_uid) return null;
  109. else {
  110. $data = self::getDB()->where('uid', $this->top_uid)->field('is_promoter,spread_uid,brokerage_level,uid')->find();
  111. if ($data && $data['is_promoter'])
  112. return $data;
  113. else
  114. return null;
  115. }
  116. }
  117. public function getTopUidAttr()
  118. {
  119. return self::getDB()->where('uid', $this->spread_uid)->value('spread_uid') ?: 0;
  120. }
  121. /**
  122. * @return \think\model\relation\HasOne
  123. * @author zfy
  124. * @day 2020-05-09
  125. */
  126. public function group()
  127. {
  128. return $this->hasOne(UserGroup::class, 'group_id', 'group_id');
  129. }
  130. public function spread()
  131. {
  132. return $this->hasOne(User::class, 'uid', 'spread_uid');
  133. }
  134. public function brokerage()
  135. {
  136. return $this->hasOne(UserBrokerage::class, 'brokerage_level', 'brokerage_level');
  137. }
  138. /**
  139. * @param $spreadUid
  140. * @author zfy
  141. * @day 2020-04-28
  142. */
  143. public function setSpread($spreadUid)
  144. {
  145. if (self::getDB()->where('uid', $spreadUid)->value('is_promoter'))
  146. $this->save([
  147. 'spread_uid' => $spreadUid,
  148. 'spread_time' => date('Y-m-d H:i:s')
  149. ]);
  150. }
  151. public function service()
  152. {
  153. return $this->hasOne(StoreService::class, 'uid', 'uid')->field('service_id,uid,nickname,avatar,customer,mer_id,is_verify')->where('is_del', 0)->where('status', 1)
  154. ->order('is_verify DESC,customer DESC');
  155. }
  156. public function getLockBrokerageAttr()
  157. {
  158. return app()->make(UserBillRepository::class)->lockBrokerage($this->uid) ?: 0;
  159. }
  160. public function getLockIntegralAttr()
  161. {
  162. return app()->make(UserBillRepository::class)->lockIntegral($this->uid) ?: 0;
  163. }
  164. public function getYesterdayBrokerageAttr()
  165. {
  166. return app()->make(UserBillRepository::class)->yesterdayBrokerage($this->uid) ?: 0;
  167. }
  168. public function getTotalExtractAttr()
  169. {
  170. return app()->make(UserExtractRepository::class)->userTotalExtract($this->uid) ?: 0;
  171. }
  172. public function getTotalBrokerageAttr()
  173. {
  174. return app()->make(UserBillRepository::class)->totalBrokerage($this->uid) ?: 0;
  175. }
  176. public function getTotalBrokeragePriceAttr()
  177. {
  178. return bcadd($this->lock_brokerage, $this->brokerage_price, 2);
  179. }
  180. public function getTotalIntegralAttr()
  181. {
  182. return bcadd($this->lock_integral, $this->integral, 0);
  183. }
  184. public function getTotalRechargeAttr()
  185. {
  186. return app()->make(UserBillRepository::class)->userNowMoneyIncTotal($this->uid);
  187. }
  188. public function getTotalConsumeAttr()
  189. {
  190. return app()->make(StoreGroupOrderRepository::class)->totalNowMoney($this->uid);
  191. }
  192. public function getTotalCollectProductAttr()
  193. {
  194. return app()->make(UserRelationRepository::class)->getWhereCount(['uid' => $this->uid, 'type' => 1]);
  195. }
  196. public function getTotalCollectStoreAttr()
  197. {
  198. return app()->make(UserRelationRepository::class)->getWhereCount(['uid' => $this->uid, 'type' => 10]);
  199. }
  200. public function getTotalVisitProductAttr()
  201. {
  202. return app()->make(UserHistoryRepository::class)->userTotalHistory($this->uid);
  203. }
  204. public function getTotalCouponAttr()
  205. {
  206. return app()->make(StoreCouponUserRepository::class)->userTotal($this->uid);
  207. }
  208. public function getTotalUnreadAttr()
  209. {
  210. return app()->make(StoreServiceLogRepository::class)->totalUnReadNum($this->uid);
  211. }
  212. public function getOneLevelCountAttr()
  213. {
  214. return app()->make(UserRepository::class)->getOneLevelCount($this->uid);
  215. }
  216. public function getTwoLevelCountAttr()
  217. {
  218. return app()->make(UserRepository::class)->getTwoLevelCount($this->uid);
  219. }
  220. public function getSpreadTotalAttr()
  221. {
  222. return $this->one_level_count + $this->two_level_count;
  223. }
  224. public function wechat()
  225. {
  226. return $this->hasOne(WechatUser::class,'wechat_user_id','wechat_user_id');
  227. }
  228. // public function getUserTypeAttr()
  229. // {
  230. // if($this->wechat['openid']){
  231. // return 'wechat';
  232. // }elseif($this->wechat['routine_openid']){
  233. // return 'routine';
  234. // }else{
  235. // return 'H5';
  236. // }
  237. // }
  238. public function getSubscribeAttr()
  239. {
  240. if($this->wechat['openid'] && $this->wechat['subscribe']){
  241. return true;
  242. }else{
  243. return false;
  244. }
  245. }
  246. }