ProductionOrder.php 4.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169
  1. <?php
  2. declare(strict_types=1);
  3. namespace App\Models;
  4. use App\Enums\ProductionOrderExecutionType;
  5. use App\Enums\ProductionOrderSource;
  6. use App\Enums\ProductionOrderStatus;
  7. use Database\Factories\ProductionOrderFactory;
  8. use Illuminate\Database\Eloquent\Factories\HasFactory;
  9. use Illuminate\Database\Eloquent\Model;
  10. use Illuminate\Database\Eloquent\Relations\BelongsTo;
  11. use Illuminate\Database\Eloquent\Relations\BelongsToMany;
  12. use Illuminate\Database\Eloquent\Relations\HasMany;
  13. use Illuminate\Database\Eloquent\SoftDeletes;
  14. class ProductionOrder extends Model
  15. {
  16. /** @use HasFactory<ProductionOrderFactory> */
  17. use HasFactory;
  18. use SoftDeletes;
  19. public const DEFAULT_SORT_BY = 'created_at';
  20. public const DEFAULT_ORDER_BY = 'desc';
  21. protected $fillable = [
  22. 'external_id',
  23. 'source',
  24. 'order_number',
  25. 'order_year',
  26. 'customer_name',
  27. 'object_address',
  28. 'invoice_number',
  29. 'invoice_date',
  30. 'contract_number',
  31. 'contract_date',
  32. 'payment_date',
  33. 'supply_working_days',
  34. 'contract_shipment_date',
  35. 'application_shipment_date',
  36. 'status',
  37. 'execution_type',
  38. 'manager_id',
  39. 'note',
  40. 'created_by',
  41. 'updated_by',
  42. ];
  43. protected function casts(): array
  44. {
  45. return [
  46. 'source' => ProductionOrderSource::class,
  47. 'order_year' => 'integer',
  48. 'invoice_date' => 'immutable_date',
  49. 'contract_date' => 'immutable_date',
  50. 'payment_date' => 'immutable_date',
  51. 'supply_working_days' => 'integer',
  52. 'contract_shipment_date' => 'immutable_date',
  53. 'application_shipment_date' => 'immutable_date',
  54. 'status' => ProductionOrderStatus::class,
  55. 'execution_type' => ProductionOrderExecutionType::class,
  56. 'manager_id' => 'integer',
  57. 'created_by' => 'integer',
  58. 'updated_by' => 'integer',
  59. ];
  60. }
  61. public function manager(): BelongsTo
  62. {
  63. return $this->belongsTo(User::class, 'manager_id');
  64. }
  65. public function creator(): BelongsTo
  66. {
  67. return $this->belongsTo(User::class, 'created_by');
  68. }
  69. public function updater(): BelongsTo
  70. {
  71. return $this->belongsTo(User::class, 'updated_by');
  72. }
  73. public function items(): HasMany
  74. {
  75. return $this->hasMany(ProductionOrderItem::class)->orderBy('sort')->orderBy('id');
  76. }
  77. public function deliveries(): HasMany
  78. {
  79. return $this->hasMany(ProductionOrderDelivery::class)->orderBy('delivery_date')->orderBy('id');
  80. }
  81. public function installations(): HasMany
  82. {
  83. return $this->hasMany(ProductionOrderInstallation::class)->orderBy('installation_date')->orderBy('id');
  84. }
  85. public function activities(): HasMany
  86. {
  87. return $this->hasMany(ProductionOrderActivity::class)->latest('created_at')->latest('id');
  88. }
  89. public function reclamations(): HasMany
  90. {
  91. return $this->hasMany(Reclamation::class);
  92. }
  93. public function documents(): BelongsToMany
  94. {
  95. return $this->belongsToMany(File::class, 'production_order_document')->withTimestamps();
  96. }
  97. public function photos(): BelongsToMany
  98. {
  99. return $this->belongsToMany(File::class, 'production_order_photo')->withTimestamps();
  100. }
  101. public function chatMessages(): HasMany
  102. {
  103. return $this->hasMany(ChatMessage::class)->oldest('created_at')->oldest('id');
  104. }
  105. public function statusLabel(): string
  106. {
  107. return $this->status->label();
  108. }
  109. public function executionTypeLabel(): string
  110. {
  111. return $this->execution_type->label();
  112. }
  113. public function getStatusNameAttribute(): string
  114. {
  115. return $this->statusLabel();
  116. }
  117. public function getExecutionTypeNameAttribute(): string
  118. {
  119. return $this->executionTypeLabel();
  120. }
  121. public function getDeliveryDatesAttribute(): string
  122. {
  123. return $this->deliveries
  124. ->pluck('delivery_date')
  125. ->filter()
  126. ->map(static fn ($date): string => $date->format('d.m.Y'))
  127. ->implode('<br>');
  128. }
  129. public function getInstallationDatesAttribute(): string
  130. {
  131. return $this->installations
  132. ->pluck('installation_date')
  133. ->filter()
  134. ->map(static fn ($date): string => $date->format('d.m.Y'))
  135. ->implode('<br>');
  136. }
  137. public function isShipmentOverdue(): bool
  138. {
  139. return $this->contract_shipment_date?->isPast()
  140. && ! in_array($this->status, [ProductionOrderStatus::InStock, ProductionOrderStatus::Closed], true);
  141. }
  142. }