WechatUser.php 2.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | CRMEB [ CRMEB赋能开发者,助力企业发展 ]
  4. // +----------------------------------------------------------------------
  5. // | Copyright (c) 2016~2020 https://www.crmeb.com All rights reserved.
  6. // +----------------------------------------------------------------------
  7. // | Licensed CRMEB并不是自由软件,未经许可不能去掉CRMEB相关版权
  8. // +----------------------------------------------------------------------
  9. // | Author: CRMEB Team <admin@crmeb.com>
  10. // +----------------------------------------------------------------------
  11. namespace app\model\wechat;
  12. use qiniu\basic\BaseModel;
  13. use qiniu\traits\ModelTrait;
  14. use think\model\concern\SoftDelete;
  15. use think\model\relation\HasOne;
  16. /**
  17. * Class WechatUser
  18. * @package app\model\wechat
  19. */
  20. class WechatUser extends BaseModel
  21. {
  22. use ModelTrait;
  23. use SoftDelete;
  24. /**
  25. * 数据表主键
  26. * @var string
  27. */
  28. protected $pk = 'uid';
  29. /**
  30. * 模型名称
  31. * @var string
  32. */
  33. protected $name = 'wechat_user';
  34. public static function setAddTimeAttr()
  35. {
  36. return time();
  37. }
  38. protected function getAddTimeAttr($value)
  39. {
  40. return $value ? date('Y-m-d H:i:s', (int)$value) : '--';
  41. }
  42. /**
  43. * 关联user
  44. * @return HasOne
  45. */
  46. public function user()
  47. {
  48. return $this->hasOne(User::class, 'uid', 'uid');
  49. }
  50. /**
  51. * 绑定公众号
  52. * @param $query
  53. * @param $value
  54. * @return mixed
  55. */
  56. public function searchUnionidAttr($query, $value)
  57. {
  58. return $query->where('unionid', $value);
  59. }
  60. /**
  61. * 公众号唯一id
  62. * @param $query
  63. * @param $value
  64. * @return mixed
  65. */
  66. public function searchOpenidAttr($query, $value)
  67. {
  68. return $query->where('openid', $value);
  69. }
  70. /**
  71. * 分组
  72. * @param $query
  73. * @param $value
  74. * @return mixed
  75. */
  76. public function searchGroupIdAttr($query, $value)
  77. {
  78. return $query->where('group_id', $value);
  79. }
  80. /**
  81. * 性别
  82. * @param $query
  83. * @param $value
  84. * @return mixed
  85. */
  86. public function searchSexAttr($query, $value)
  87. {
  88. return $query->where('sex', $value);
  89. }
  90. /**
  91. * 是否关注
  92. * @param $query
  93. * @param $value
  94. * @return mixed
  95. */
  96. public function searchSubscribeAttr($query, $value)
  97. {
  98. return $query->where('subscribe', $value);
  99. }
  100. /**
  101. * 用户类型
  102. * @param $query
  103. * @param $value
  104. * @return mixed
  105. */
  106. public function searchUserTypeAttr($query, $value)
  107. {
  108. return $query->where('user_type', $value);
  109. }
  110. }