WorkOrder.php 8.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281
  1. <?php
  2. namespace App;
  3. use App\Services\NotificationService;
  4. use App\Traits\ModelTimeFormat;
  5. use Illuminate\Database\Eloquent\Builder;
  6. use Illuminate\Database\Eloquent\Model;
  7. use App\Traits\ModelLogChanging;
  8. use Illuminate\Database\Eloquent\Relations\BelongsTo;
  9. use Illuminate\Database\Eloquent\Relations\HasMany;
  10. use Illuminate\Database\Eloquent\Relations\HasOne;
  11. use Illuminate\Database\Eloquent\SoftDeletes;
  12. use Illuminate\Http\UploadedFile;
  13. use Illuminate\Support\Facades\Auth;
  14. use Illuminate\Support\Facades\Gate;
  15. class WorkOrder extends Model
  16. {
  17. use ModelLogChanging;
  18. use ModelTimeFormat;
  19. use SoftDeletes;
  20. // 工单 信息
  21. protected $fillable = [
  22. 'status', // 状态
  23. 'creator_id', // 创建人
  24. 'reviewer_id', // 审核人
  25. 'owner_id', // 货主
  26. 'order_issue_type_id', // 问题件类型
  27. 'work_order_type_id', // 工单类型
  28. 'grad', // 紧急等级
  29. 'remark', // 工单信息描述
  30. 'outer_table_name', // 链接表名
  31. 'review_at', // 审核时间
  32. 'order_id', // 订单id
  33. 'uniquely_tag', // 唯一标识
  34. ];
  35. static public $enums = [
  36. 'status' => [
  37. '' => 0,
  38. '待审核' => 1,
  39. '已处理' => 2,
  40. ],
  41. 'grad' => [
  42. '' => 0,
  43. '一般' => 1,
  44. '重要' => 2,
  45. '紧急' => 3,
  46. '重要且紧急' => 4,
  47. ],
  48. ];
  49. function __construct(array $attributes = [])
  50. {
  51. foreach (self::$enums as &$enum) {
  52. $enum = $enum + array_flip($enum);
  53. }
  54. parent::__construct($attributes);
  55. }
  56. public function getStatusAttribute($value)
  57. {
  58. if (!$value) return '';
  59. return self::$enums['status'][$value];
  60. }
  61. public function setStatusAttribute($value)
  62. {
  63. if (!$value) return 0;
  64. if (is_numeric($value)) {
  65. $this->attributes['status'] = $value;
  66. } else {
  67. $this->attributes['status'] = self::$enums['status'][$value];
  68. }
  69. }
  70. public function getGradAttribute($value)
  71. {
  72. if (!$value) return '';
  73. return self::$enums['grad'][$value];
  74. }
  75. public function setGradAttribute($value)
  76. {
  77. if (!$value) return 0;
  78. if (is_numeric($value)) {
  79. $this->attributes['grad'] = $value;
  80. } else {
  81. $this->attributes['grad'] = self::$enums['grad'][$value];
  82. }
  83. }
  84. // 创建人
  85. public function creator(): BelongsTo
  86. {
  87. return $this->belongsTo(User::class, 'creator_id');
  88. }
  89. // 审核人
  90. public function reviewer(): BelongsTo
  91. {
  92. return $this->belongsTo(User::class, 'reviewer_id');
  93. }
  94. // 关联订单
  95. public function order(): BelongsTo
  96. {
  97. return $this->belongsTo(Order::class);
  98. }
  99. // 关联货主
  100. public function owner(): BelongsTo
  101. {
  102. return $this->belongsTo(Owner::class, 'owner_id');
  103. }
  104. // 工单类型
  105. public function type(): BelongsTo
  106. {
  107. return $this->BelongsTo(WorkOrderType::class, 'work_order_type_id');
  108. }
  109. // 生成问题件类型
  110. public function issueType(): BelongsTo
  111. {
  112. return $this->belongsTo(OrderIssueType::class, 'order_issue_type_id');
  113. }
  114. /** 对应问题件 */
  115. public function orderIssue(): BelongsTo
  116. {
  117. return $this->belongsTo(OrderIssue::class, 'order_id', 'order_id');
  118. }
  119. // 图片
  120. public function image(): HasMany
  121. {
  122. return $this->hasMany(WorkOrderImage::class);
  123. }
  124. // 外包装图片
  125. public function packageImages(): HasMany
  126. {
  127. return $this->hasMany(WorkOrderImage::class)->where('type', 0);
  128. }
  129. // 内物破损图片
  130. public function commodityImages(): HasMany
  131. {
  132. return $this->hasMany(WorkOrderImage::class)->where('type', 1);
  133. }
  134. // 交易图片
  135. public function dealImages(): HasMany
  136. {
  137. return $this->hasMany(WorkOrderImage::class)->where('type', 2);
  138. }
  139. // 退款图片
  140. public function refundImages(): HasMany
  141. {
  142. return $this->hasMany(WorkOrderImage::class)->where('type', 3);
  143. }
  144. // 工单详情
  145. public function details(): HasMany
  146. {
  147. return $this->hasMany(WorkOrderDetail::class);
  148. }
  149. // 宝时处理日志
  150. public function processLog(): HasOne
  151. {
  152. return $this->hasOne(WorkOrderProcessLog::class)->where('type','1');
  153. }
  154. // 承运商处理日志
  155. public function logisticLog(): HasOne
  156. {
  157. return $this->hasOne(WorkOrderProcessLog::class)->where('type','2');
  158. }
  159. public function scopeFilter($query, $filters)
  160. {
  161. return $filters->apply($query);
  162. }
  163. /** 默认 with 参数 */
  164. public function scopeDefaultWith($query)
  165. {
  166. $query->with(['type', 'owner', 'issueType', 'creator','details',
  167. 'processLog.creator',
  168. 'logisticLog.creator',
  169. 'packageImages.uploadFile',
  170. 'commodityImages.uploadFile',
  171. 'dealImages.uploadFile',
  172. 'refundImages.uploadFile',
  173. 'reviewer',
  174. 'order' => function ($query) {
  175. /** @var Builder $query */
  176. $query->with('packages', 'logistic', 'owner');
  177. }, 'orderIssue' => function ($query) {
  178. /** @var Builder $query */
  179. $query->with(['issueType', 'logs' => function ($query) {
  180. if (Gate::denies('订单管理-问题件-客户不可见')) {
  181. $query->with('user')->orderByDesc('created_at');
  182. } else {
  183. $query->with('user')->where('tag', '=', 0)->orderByDesc('created_at');
  184. }
  185. }]);
  186. }]);
  187. }
  188. public function notification()
  189. {
  190. $user = Auth::user();
  191. $this->loadMissing('owner', 'order');
  192. $remark = $this->remark;
  193. $ownerName = $this->owner->name ?? '';
  194. $clientCode = $this->order->client_code ?? '';
  195. $msg = $user["name"] . "建立了新工单<br/>" . $ownerName . ":" . $clientCode . "<br/>" . $remark;
  196. NotificationService::SingleRegister($msg, $clientCode, "订单管理-问题件");
  197. }
  198. public function addPackageImage($images)
  199. { // 外包装图
  200. foreach ($images as $image) {
  201. /** @var UploadedFile $image */
  202. $count = $this->packageImages()->count();
  203. /** @var WorkOrderImage $workOrderImage */
  204. $workOrderImage = $this->packageImages()->create(['type' => 0, 'amount' => ++$count]);
  205. $workOrderImage->saveFile($image);
  206. }
  207. $this->loadMissing('packageImages');
  208. }
  209. public function addCommodityImage($images)
  210. { // 内物破损图
  211. foreach ($images as $image) {
  212. $count = $this->commodityImages()->count();
  213. /** @var WorkOrderImage $workOrderImage */
  214. $workOrderImage = $this->commodityImages()->create(['type' => 1, 'amount' => ++$count]);
  215. $workOrderImage->saveFile($image);
  216. }
  217. $this->loadMissing('commodityImages');
  218. }
  219. public function addDealImage($images)
  220. { // 交易截图
  221. foreach ($images as $image) {
  222. $count = $this->dealImages()->count();
  223. /** @var WorkOrderImage $workOrderImage */
  224. $workOrderImage = $this->dealImages()->create(['type' => 2, 'amount' => ++$count]);
  225. $workOrderImage->saveFile($image);
  226. }
  227. $this->loadMissing('dealImages');
  228. }
  229. public function addRefundImage($images)
  230. { // 退款截图
  231. foreach ($images as $image) {
  232. $count = $this->refundImages()->count();
  233. /** @var WorkOrderImage $workOrderImage */
  234. $workOrderImage = $this->refundImages()->create(['type' => 3, 'amount' => ++$count]);
  235. $workOrderImage->saveFile($image);
  236. }
  237. $this->loadMissing('dealImages');
  238. }
  239. public function saveWorkOrderDetail($params)
  240. {
  241. $param = (new WorkOrderDetail($params))->getAttributes();
  242. $this->details()->create($param);
  243. $this->loadMissing('details');
  244. }
  245. }