UserLabel.php 3.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131
  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 UserLabel
  18. * @package app\model\user\label
  19. */
  20. class UserLabel extends BaseModel
  21. {
  22. use ModelTrait;
  23. /**
  24. * 数据表主键
  25. * @var string
  26. */
  27. protected $pk = 'id';
  28. /**
  29. * 模型名称
  30. * @var string
  31. */
  32. protected $name = 'user_label';
  33. /**
  34. * 标签分类
  35. * @param \think\Model $query
  36. * @param $value
  37. */
  38. public function searchLabelCateAttr($query, $value)
  39. {
  40. if (is_array($value)) {
  41. $query->whereIn('label_cate', $value);
  42. } else {
  43. if ($value) {
  44. $query->where('label_cate', $value);
  45. }
  46. }
  47. }
  48. /**
  49. * 商户搜索器
  50. * @param Model $query
  51. * @param $value
  52. */
  53. public function searchTypeAttr($query, $value)
  54. {
  55. if (is_array($value)) {
  56. if ($value) $query->whereIn('type', $value);
  57. } else {
  58. if ($value !== '') $query->where('type', $value);
  59. }
  60. }
  61. /**
  62. * 关联门店ID、供应商ID搜索器
  63. * @param Model $query
  64. * @param $value
  65. */
  66. public function searchRelationIdAttr($query, $value)
  67. {
  68. if (is_array($value)) {
  69. if ($value) $query->whereIn('relation_id', $value);
  70. } else {
  71. if ($value !== '') $query->where('relation_id', $value);
  72. }
  73. }
  74. /**
  75. * 供应商
  76. * @param Model $query
  77. * @param $value
  78. */
  79. public function searchSupplierIdAttr($query, $value)
  80. {
  81. if (is_array($value)) {
  82. if ($value) $query->whereIn('relation_id', $value)->where('type', 2);
  83. } else {
  84. if ($value !== '') $query->where('relation_id', $value)->where('type', 2);
  85. }
  86. }
  87. /**
  88. * 门店
  89. * @param Model $query
  90. * @param $value
  91. */
  92. public function searchStoreIdAttr($query, $value)
  93. {
  94. if (is_array($value)) {
  95. if ($value) $query->whereIn('relation_id', $value)->where('type', 1);
  96. } else {
  97. if ($value !== '') $query->where('relation_id', $value)->where('type', 1);
  98. }
  99. }
  100. /**
  101. * ids搜索器
  102. * @param Model $query
  103. * @param $value
  104. */
  105. public function searchIdsAttr($query, $value)
  106. {
  107. if ($value) $query->whereIn('id', $value);
  108. }
  109. /**
  110. * @param $query
  111. * @param $value
  112. */
  113. public function searchNotTagIdAttr($query, $value)
  114. {
  115. $query->where(function ($query) {
  116. $query->whereNull('tag_id')->whereOr('tag_id', '');
  117. });
  118. }
  119. }