UserLabelRelation.php 2.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108
  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\user\label;
  12. use crmeb\basic\BaseModel;
  13. use crmeb\traits\ModelTrait;
  14. use think\Model;
  15. /**
  16. * 用户关联标签
  17. * Class UserLabelRelation
  18. * @package app\model\user\label
  19. */
  20. class UserLabelRelation extends BaseModel
  21. {
  22. use ModelTrait;
  23. /**
  24. * 模型名称
  25. * @var string
  26. */
  27. protected $name = 'user_label_relation';
  28. /**
  29. * @return \think\model\relation\HasOne
  30. */
  31. public function label()
  32. {
  33. return $this->hasOne(UserLabel::class, 'id', 'label_id')->bind([
  34. 'label_name' => 'label_name'
  35. ]);
  36. }
  37. /**
  38. * uid搜索器
  39. * @param Model $query
  40. * @param $value
  41. */
  42. public function searchUidAttr($query, $value)
  43. {
  44. $query->whereIn('uid', $value);
  45. }
  46. /**
  47. * 商户搜索器
  48. * @param Model $query
  49. * @param $value
  50. */
  51. public function searchTypeAttr($query, $value)
  52. {
  53. if (is_array($value)) {
  54. if ($value) $query->whereIn('type', $value);
  55. } else {
  56. if ($value !== '') $query->where('type', $value);
  57. }
  58. }
  59. /**
  60. * 关联门店ID、供应商ID搜索器
  61. * @param Model $query
  62. * @param $value
  63. */
  64. public function searchRelationIdAttr($query, $value)
  65. {
  66. if (is_array($value)) {
  67. if ($value) $query->whereIn('relation_id', $value);
  68. } else {
  69. if ($value !== '') $query->where('relation_id', $value);
  70. }
  71. }
  72. /**
  73. * 供应商
  74. * @param Model $query
  75. * @param $value
  76. */
  77. public function searchSupplierIdAttr($query, $value)
  78. {
  79. if (is_array($value)) {
  80. if ($value) $query->whereIn('relation_id', $value)->where('type', 2);
  81. } else {
  82. if ($value !== '') $query->where('relation_id', $value)->where('type', 2);
  83. }
  84. }
  85. /**
  86. * 门店
  87. * @param Model $query
  88. * @param $value
  89. */
  90. public function searchStoreIdAttr($query, $value)
  91. {
  92. if (is_array($value)) {
  93. if ($value) $query->whereIn('relation_id', $value)->where('type', 1);
  94. } else {
  95. if ($value !== '') $query->where('relation_id', $value)->where('type', 1);
  96. }
  97. }
  98. }