StoreOrderRefund.php 4.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | CRMEB [ CRMEB赋能开发者,助力企业发展 ]
  4. // +----------------------------------------------------------------------
  5. // | Copyright (c) 2016~2026 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\order;
  12. use app\model\user\User;
  13. use crmeb\basic\BaseModel;
  14. use crmeb\traits\ModelTrait;
  15. use think\Model;
  16. class StoreOrderRefund extends BaseModel
  17. {
  18. use ModelTrait;
  19. /**
  20. * 数据表主键
  21. * @var string
  22. */
  23. protected $pk = 'id';
  24. /**
  25. * 模型名称
  26. * @var string
  27. */
  28. protected $name = 'store_order_refund';
  29. /**
  30. * 购物车信息获取器
  31. * @param $value
  32. * @return array|mixed
  33. */
  34. public function getCartInfoAttr($value)
  35. {
  36. return is_string($value) ? json_decode($value, true) ?? [] : [];
  37. }
  38. /**
  39. * 图片获取器
  40. * @param $value
  41. * @return array|mixed
  42. */
  43. public function getRefundImgAttr($value)
  44. {
  45. return is_string($value) ? json_decode($value, true) ?? [] : [];
  46. }
  47. /**
  48. * 一对一关联订单表
  49. * @return StoreOrderRefund|\think\model\relation\HasOne
  50. */
  51. public function order()
  52. {
  53. return $this->hasOne(StoreOrder::class, 'id', 'store_order_id');
  54. }
  55. /**
  56. * 一对一关联用户表
  57. * @return \think\model\relation\HasOne
  58. */
  59. public function user()
  60. {
  61. return $this->hasOne(User::class, 'uid', 'uid')->field(['uid', 'avatar', 'nickname', 'phone'])->bind([
  62. 'avatar' => 'avatar',
  63. 'nickname' => 'nickname',
  64. 'phone' => 'phone'
  65. ]);
  66. }
  67. /**
  68. * 订单ID搜索器
  69. * @param $query
  70. * @param $value
  71. */
  72. public function searchStoreOrderIdAttr($query, $value)
  73. {
  74. if ($value !== '') {
  75. if (is_array($value)) {
  76. $query->whereIn('store_order_id', $value);
  77. } else {
  78. $query->where('store_order_id', $value);
  79. }
  80. }
  81. }
  82. /**
  83. * @param Model $query
  84. * @param $value
  85. */
  86. public function searchUidAttr($query, $value)
  87. {
  88. if ($value !== '' && !is_null($value)) {
  89. if (is_array($value)) {
  90. $query->whereIn('uid', $value);
  91. } else {
  92. $query->where('uid', $value);
  93. }
  94. }
  95. }
  96. /**
  97. * is_cancel
  98. * @param Model $query
  99. * @param $value
  100. */
  101. public function searchIsCancelAttr($query, $value)
  102. {
  103. if ($value !== '' && !is_null($value)) $query->where('is_cancel', $value);
  104. }
  105. /**
  106. * is_del搜索器
  107. * @param Model $query
  108. * @param $value
  109. */
  110. public function searchIsDelAttr($query, $value)
  111. {
  112. if ($value !== '' && !is_null($value)) $query->where('is_del', $value);
  113. }
  114. /**
  115. * is_system_del搜索器
  116. * @param Model $query
  117. * @param $value
  118. */
  119. public function searchIsSystemDelAttr($query, $value)
  120. {
  121. if ($value !== '' && !is_null($value)) $query->where('is_system_del', $value);
  122. }
  123. /**
  124. * refund_type
  125. * @param $query
  126. * @param $value
  127. */
  128. public function searchRefundTypeAttr($query, $value)
  129. {
  130. if (is_array($value)) {
  131. $query->whereIn('refund_type', $value);
  132. } else {
  133. if ($value > 0) $query->where('refund_type', $value);
  134. }
  135. }
  136. /**
  137. * @param $query
  138. * @param $value
  139. */
  140. public function searchRefundStatusAttr($query, $value)
  141. {
  142. if ($value == 1) {
  143. $query->whereIn('refund_type', [1, 2, 4, 5]);
  144. } elseif ($value == 2) {
  145. $query->where('refund_type', 6);
  146. }
  147. }
  148. /**
  149. * 一对一关联订单表
  150. * @return StoreOrderRefund|\think\model\relation\HasOne
  151. */
  152. public function orderData()
  153. {
  154. return $this->hasOne(StoreOrder::class, 'id', 'store_order_id')->field('id, order_id, pay_type, paid, real_name,user_phone, user_address,pay_uid, pay_time')
  155. ->bind([
  156. 'store_order_sn' => 'order_id',
  157. 'pay_type',
  158. 'paid',
  159. 'real_name',
  160. 'user_phone',
  161. 'user_address',
  162. 'pay_uid',
  163. 'pay_time'
  164. ]);
  165. }
  166. /**
  167. * @param $query
  168. * @param $value
  169. */
  170. public function searchKeywordsAttr($query, $value)
  171. {
  172. if ($value !== '') {
  173. $query->where('order_id|refund_phone', 'like', '%' . $value . '%');
  174. }
  175. }
  176. }