WorkOrder.php 7.6 KB

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