UserLabelCate.php 2.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110
  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 think\Model;
  14. /**
  15. * 标签分类
  16. * Class UserLabelCate
  17. * @package app\model\user\label
  18. */
  19. class UserLabelCate extends BaseModel
  20. {
  21. /**
  22. * 表名
  23. * @var string
  24. */
  25. protected $name = 'user_label_cate';
  26. /**
  27. * 主键
  28. * @var string
  29. */
  30. protected $pk = 'id';
  31. /**
  32. * @param Model $query
  33. * @param $value
  34. */
  35. public function searchNameAttr($query, $value)
  36. {
  37. $query->whereLike('name', '%' . $value . '%');
  38. }
  39. /**
  40. * 一对多关联
  41. * @return \think\model\relation\HasMany
  42. */
  43. public function label()
  44. {
  45. return $this->hasMany(UserLabel::class, 'label_cate', 'id');
  46. }
  47. /**
  48. * 商户搜索器
  49. * @param Model $query
  50. * @param $value
  51. */
  52. public function searchTypeAttr($query, $value)
  53. {
  54. if (is_array($value)) {
  55. if ($value) $query->whereIn('type', $value);
  56. } else {
  57. if ($value !== '') $query->where('type', $value);
  58. }
  59. }
  60. /**
  61. * 关联门店ID、供应商ID搜索器
  62. * @param Model $query
  63. * @param $value
  64. */
  65. public function searchRelationIdAttr($query, $value)
  66. {
  67. if (is_array($value)) {
  68. if ($value) $query->whereIn('relation_id', $value);
  69. } else {
  70. if ($value !== '') $query->where('relation_id', $value);
  71. }
  72. }
  73. /**
  74. * 供应商
  75. * @param Model $query
  76. * @param $value
  77. */
  78. public function searchSupplierIdAttr($query, $value)
  79. {
  80. if (is_array($value)) {
  81. if ($value) $query->whereIn('relation_id', $value)->where('type', 2);
  82. } else {
  83. if ($value !== '') $query->where('relation_id', $value)->where('type', 2);
  84. }
  85. }
  86. /**
  87. * 门店
  88. * @param Model $query
  89. * @param $value
  90. */
  91. public function searchStoreIdAttr($query, $value)
  92. {
  93. if (is_array($value)) {
  94. if ($value) $query->whereIn('relation_id', $value)->where('type', 1);
  95. } else {
  96. if ($value !== '') $query->where('relation_id', $value)->where('type', 1);
  97. }
  98. }
  99. }