User.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398
  1. <?php
  2. namespace app\common\model;
  3. use think\Db;
  4. use think\db\Query;
  5. use think\Model;
  6. use traits\model\SoftDelete;
  7. /**
  8. * 会员模型
  9. * @property int coupon_num
  10. * @method static Query|self expired()
  11. * @property float level_discount 折扣点
  12. * @property boolean wx_authed 是否已微信授权
  13. */
  14. class User extends Model
  15. {
  16. use SoftDelete;
  17. protected $hidden=[
  18. 'password',
  19. 'salt',
  20. 'status',
  21. 'token',
  22. 'updatetime',
  23. 'loginfailure',
  24. 'url',
  25. 'type',
  26. 'openid',
  27. 'unionid',
  28. 'email',
  29. ];
  30. // 开启自动写入时间戳字段
  31. protected $autoWriteTimestamp = 'int';
  32. // 定义时间戳字段名
  33. protected $createTime = 'createtime';
  34. protected $updateTime = 'updatetime';
  35. // 追加属性
  36. protected $append = [
  37. 'level_text',
  38. 'has_follow',
  39. 'wx_authed',
  40. ];
  41. const LEVEL_0=0;
  42. const LEVEL_1=1;
  43. const LEVEL_10=10;
  44. const LEVEL_20=20;
  45. const USER=1;
  46. const SENDER=2;
  47. public static $levels=[
  48. self::LEVEL_0=>'普通会员',
  49. self::LEVEL_1=>'黄金会员',
  50. self::LEVEL_10=>'白金会员',
  51. self::LEVEL_20=>'钻石会员',
  52. ];
  53. /**
  54. * 获取个人URL
  55. * @param string $value
  56. * @param array $data
  57. * @return string
  58. */
  59. public function getUrlAttr($value, $data)
  60. {
  61. return fullUrl("/u/" . $data['id']);
  62. }
  63. public function getLevelTextAttr($value, $data)
  64. {
  65. return self::$levels[$data['level']]??'普通会员';
  66. }
  67. /**
  68. * 获取头像
  69. * @param string $value
  70. * @param array $data
  71. * @return string
  72. */
  73. /* public function getAvatarAttr($value, $data)
  74. {
  75. if (!$value) {
  76. //如果不需要启用首字母头像,请使用
  77. //$value = '/assets/img/avatar.png';
  78. $value = letter_avatar($data['nickname']);
  79. }
  80. return $value;
  81. }*/
  82. /**
  83. * 获取会员的组别
  84. */
  85. public function getGroupAttr($value, $data)
  86. {
  87. return UserGroup::get($data['group_id']);
  88. }
  89. /**
  90. * 获取验证字段数组值
  91. * @param string $value
  92. * @param array $data
  93. * @return object
  94. */
  95. /*public function getVerificationAttr($value, $data)
  96. {
  97. $value = array_filter((array)json_decode($value, true));
  98. $value = array_merge(['email' => 0, 'mobile' => 0], $value);
  99. return (object)$value;
  100. }*/
  101. /**
  102. * 设置验证字段
  103. * @param mixed $value
  104. * @return string
  105. */
  106. /*public function setVerificationAttr($value)
  107. {
  108. $value = is_object($value) || is_array($value) ? json_encode($value) : $value;
  109. return $value;
  110. }*/
  111. /**
  112. * 变更会员余额
  113. * @param float $money 余额
  114. * @param int $user_id 会员ID
  115. * @param string $memo 备注
  116. */
  117. public static function money($money, $user_id, $type,$memo='',$extra=[],$changeMoney=true)
  118. {
  119. $user = self::lock(true)->find($user_id);
  120. if($changeMoney && !$user){
  121. throw_user('用户不存在:'.$user_id);
  122. }
  123. if ($money != 0) {
  124. if($changeMoney){
  125. $before = $user->money;
  126. //$after = $user->money + $money;
  127. $after = function_exists('bcadd') ? bcadd($user->money, $money, 2) : $user->money + $money;
  128. if($after<0){
  129. throw_user("余额不足");
  130. }
  131. //更新会员信息
  132. $user->save(['money' => $after]);
  133. }
  134. }
  135. //写入日志
  136. MoneyLog::create(array_merge([
  137. 'user_id' => $user_id,
  138. 'type'=>$type,
  139. 'money' => $money,
  140. 'before' => $before??$user->money??0,
  141. 'after' => $after??$user->money??0,
  142. 'memo' => $memo,
  143. ],$extra));
  144. }
  145. /**
  146. * 变更会员积分
  147. * @param int $score 积分
  148. * @param int $user_id 会员ID
  149. * @param string $memo 备注
  150. */
  151. public static function score($score, $user_id, $memo)
  152. {
  153. Db::startTrans();
  154. try {
  155. $user = self::lock(true)->find($user_id);
  156. if ($user && $score != 0) {
  157. $before = $user->score;
  158. $after = $user->score + $score;
  159. //更新会员信息
  160. $user->save(['score' => $after]);
  161. //写入日志
  162. ScoreLog::create(['user_id' => $user_id, 'score' => $score, 'before' => $before, 'after' => $after, 'memo' => $memo]);
  163. }
  164. Db::commit();
  165. } catch (\Exception $e) {
  166. Db::rollback();
  167. }
  168. }
  169. public function address(){
  170. return $this->hasMany(UserAddress::class);
  171. }
  172. public function coupon(){
  173. return $this->hasMany(UserCoupon::class);
  174. }
  175. public function orders(){
  176. return $this->hasMany(UserOrder::class);
  177. }
  178. public function payment(){
  179. return $this->hasMany(Payment::class);
  180. }
  181. public function info(){
  182. return $this->hasMany(Info::class);
  183. }
  184. public function theme(){
  185. return $this->hasMany(Theme::class);
  186. }
  187. public function follow(){
  188. return $this->hasMany(UserFollow::class);
  189. }
  190. public function comments(){
  191. return $this->hasMany(Comment::class);
  192. }
  193. public function like(){
  194. return $this->hasMany(Like::class);
  195. }
  196. public function feedback(){
  197. return $this->hasMany(Feedback::class);
  198. }
  199. public function getHasFollowAttr(){
  200. $user=request()->_user;
  201. if(!$user){
  202. return false;
  203. }
  204. return (bool)UserFollow::where('user_id',$user['id'])->where('follow_id',$this['id'])->value('id');
  205. }
  206. public function moneylog(){
  207. return $this->hasMany(MoneyLog::class);
  208. }
  209. public function notification(){
  210. return $this->hasMany(Notification::class);
  211. }
  212. public function notificationFrom(){
  213. return $this->hasMany(Notification::class,'from_user_id');
  214. }
  215. public static function recharge($params,Payment $payment){
  216. self::money($payment['amount'],$payment['uer_id'],MoneyLog::TYPE_CHARGE,'充值');
  217. }
  218. /**
  219. * @return \think\model\relation\HasMany|SenderOrder
  220. */
  221. public function senderOrder(){
  222. return $this->hasMany(SenderOrder::class);
  223. }
  224. public function takeCash(){
  225. return $this->hasMany(TakeCash::class);
  226. }
  227. public function verification(){
  228. return $this->hasOne(UserVerification::class);
  229. }
  230. /** 配送方式 */
  231. public function send(){
  232. return $this->hasMany(UserSend::class);
  233. }
  234. public function getAuthsAttr($v,$data){
  235. return $this->auth()->column('route');
  236. }
  237. public function scopeUser(Query $query){
  238. $query->where('type',self::USER)->order('id','desc');
  239. }
  240. public function scopeSender(Query $query){
  241. $query->where('type',self::SENDER)->order('id','desc');
  242. }
  243. /** 模糊搜索 */
  244. public function scopeDim(Query $query,$keyword){
  245. $keyword="%{$keyword}%";
  246. $query
  247. ->whereLike('nickname',$keyword)
  248. ->whereOr('mobile','like',$keyword)
  249. ->whereOr('username','like',$keyword);
  250. }
  251. /** 代理区域 */
  252. public function area(){
  253. return $this->belongsToMany(Area::class,'user_area');
  254. }
  255. public function getCouponNumAttr(){
  256. return $this->coupon()->use()->count();
  257. }
  258. /**
  259. * 获取配送类型
  260. * @return 1取2送
  261. */
  262. const SEND_GET=1;
  263. const SEND_SEND=2;
  264. public static $sendType=[
  265. self::SEND_GET,
  266. self::SEND_SEND,
  267. ];
  268. public function getSendType(UserOrder $order){
  269. $addr=$this->area()->column('name');
  270. $order_type=$order->currentSenderOrder($this['id'])->value('type');
  271. if($order_type){
  272. return $order_type;
  273. }
  274. if(in_array($order['from_city'],$addr)){
  275. return self::SEND_GET;
  276. }elseif (in_array($order['to_city'],$addr)){
  277. return self::SEND_SEND;
  278. }
  279. throw_user('操作失败:您非取送地配送员');
  280. }
  281. public function isSendGet($type){
  282. return self::SEND_GET==$type;
  283. }
  284. public function isSendSend($type){
  285. return self::SEND_SEND==$type;
  286. }
  287. /** 保存配送方式 */
  288. public function saveSend(array $freight){
  289. $this->send()->delete();
  290. $freight=array_unique(array_filter($freight));
  291. $this->send()->saveAll(collection($freight)->each(function ($res){
  292. return [
  293. 'type'=>$res,
  294. ];
  295. })->toArray());
  296. }
  297. /** 保存配送地区 */
  298. public function saveSendArea(array $area){
  299. $area=array_unique(array_filter($area));
  300. $this->area()->sync(collection($area)->each(function ($res){
  301. if(is_numeric($res)) {
  302. $area=Area::city()->find($res);
  303. if (!$area) {
  304. throw_user('地区ID[' . $res . ']不存在');
  305. }
  306. if(UserArea::hasArea($res)){
  307. throw_user("地区[{$area['name']}]已被分配,无法再次分配");
  308. }
  309. return $res;
  310. }else{
  311. $area=Area::city()->where('name',$res)->find();
  312. if (!$area) {
  313. throw_user('地区[' . $res . ']不存在');
  314. }
  315. if(UserArea::hasArea($area['id'])){
  316. throw_user("地区[{$area['name']}]已被分配,无法再次分配");
  317. }
  318. return $area['id'];
  319. }
  320. })->toArray());
  321. }
  322. /** scope and expired */
  323. protected static function init()
  324. {
  325. self::beforeWrite(function (self $user){
  326. $data=$user->getChangedData();
  327. if(!empty($data['level_close_at']) && isset($data['level'])){
  328. $user['level_open_at']=time();
  329. }
  330. });
  331. }
  332. public function scopeExpired(Query $query){
  333. $query
  334. ->where('level_close_at','>',0)
  335. ->where('level_close_at','<',time())
  336. ->where('level','>',0);
  337. }
  338. public function scopeType(Query $query,$type){
  339. $query->where('type',$type);
  340. }
  341. /** attr */
  342. /**
  343. *获取等级优惠点
  344. */
  345. public function getLevelDiscountAttr($v,$data){
  346. static $config;
  347. if(!$config){
  348. $config=SysConfig::look(SysConfig::level_config,[]);
  349. }
  350. $userLevel=$data['level']??self::LEVEL_0;
  351. $levelDiscount=$config[$userLevel]['value']??100;
  352. if($userLevel==0 || $levelDiscount<=0){
  353. return 0;
  354. }
  355. #如果是一位数则加个0
  356. if($levelDiscount<10){
  357. $levelDiscount*=10;
  358. }
  359. return bcdiv(100-$levelDiscount,100);
  360. }
  361. protected function getWxAuthedAttr($v,$data){
  362. return (bool)$this['openid'];
  363. }
  364. }