SparePartOrderController.php 9.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\Http\Requests\ShipSparePartOrderRequest;
  4. use App\Http\Requests\StoreSparePartOrderRequest;
  5. use App\Models\SparePart;
  6. use App\Models\SparePartOrder;
  7. use App\Models\SparePartOrdersView;
  8. use App\Services\SparePartIssueService;
  9. use Illuminate\Http\RedirectResponse;
  10. use Illuminate\Http\Request;
  11. use Illuminate\Validation\ValidationException;
  12. class SparePartOrderController extends Controller
  13. {
  14. protected array $data = [
  15. 'active' => 'spare_parts',
  16. 'title' => 'Заказы деталей',
  17. 'id' => 'spare_part_orders',
  18. 'header' => [
  19. 'id' => 'ID',
  20. 'order_number' => 'Номер заказа',
  21. 'article' => 'Артикул',
  22. 'source_text' => 'Источник заказа',
  23. 'status_name' => 'Статус',
  24. 'ordered_quantity' => 'Заказано',
  25. 'available_qty' => 'Остаток',
  26. 'with_documents_text' => 'С документами',
  27. 'note' => 'Примечание',
  28. 'user_name' => 'Менеджер',
  29. 'created_at' => 'Дата создания',
  30. ],
  31. 'searchFields' => [
  32. 'order_number',
  33. 'article',
  34. 'source_text',
  35. 'note',
  36. 'user_name',
  37. ],
  38. 'routeName' => 'spare_part_orders.show',
  39. ];
  40. public function __construct(
  41. protected SparePartIssueService $issueService
  42. ) {}
  43. public function index(Request $request)
  44. {
  45. session(['gp_spare_part_orders' => $request->query()]);
  46. $model = new SparePartOrdersView();
  47. // Фильтры
  48. $this->createFilters($model, 'article', 'order_number');
  49. $this->createRangeFilters($model, 'ordered_quantity', 'available_qty');
  50. $this->createDateFilters($model, 'created_at');
  51. // Фильтр статуса с русскими названиями
  52. $this->data['filters']['status'] = [
  53. 'title' => 'Статус',
  54. 'values' => SparePartOrdersView::STATUS_NAMES
  55. ];
  56. // Фильтр "С документами"
  57. $this->data['filters']['with_documents'] = [
  58. 'title' => 'С документами',
  59. 'values' => [
  60. 1 => 'Да',
  61. 0 => 'Нет',
  62. ]
  63. ];
  64. // Запрос
  65. $q = $model::query();
  66. // Специальная обработка фильтров из клика по каталогу
  67. if ($request->has('spare_part_id')) {
  68. $sparePart = SparePart::find($request->get('spare_part_id'));
  69. if ($sparePart) {
  70. $q->where('spare_part_id', $sparePart->id);
  71. $this->data['filter_spare_part'] = $sparePart;
  72. }
  73. }
  74. $this->acceptFilters($q, $request);
  75. $this->acceptSearch($q, $request);
  76. $this->setSortAndOrderBy($model, $request);
  77. $this->applyStableSorting($q);
  78. $this->data['spare_part_orders'] = $q->paginate($this->data['per_page'])->withQueryString();
  79. $this->data['order_numbers'] = SparePartOrder::query()
  80. ->where('status', SparePartOrder::STATUS_ORDERED)
  81. ->whereNotNull('order_number')
  82. ->where('order_number', '!=', '')
  83. ->orderBy('order_number')
  84. ->distinct()
  85. ->pluck('order_number');
  86. $this->data['strings'] = $this->data['spare_part_orders'];
  87. $this->data['tab'] = 'orders';
  88. return view('spare_parts.index', $this->data);
  89. }
  90. public function show(Request $request, SparePartOrder $sparePartOrder)
  91. {
  92. $this->data['previous_url'] = $this->resolvePreviousUrl(
  93. $request,
  94. 'previous_url_spare_part_orders',
  95. route('spare_part_orders.index', session('gp_spare_part_orders'))
  96. );
  97. $this->data['spare_part_order'] = $sparePartOrder->load([
  98. 'sparePart',
  99. 'movements.user',
  100. 'reservations.reclamation',
  101. ]);
  102. return view('spare_part_orders.edit', $this->data);
  103. }
  104. public function create(Request $request)
  105. {
  106. $this->data['previous_url'] = $this->resolvePreviousUrl(
  107. $request,
  108. 'previous_url_spare_part_orders',
  109. route('spare_part_orders.index', session('gp_spare_part_orders'))
  110. );
  111. $this->data['spare_part_order'] = null;
  112. return view('spare_part_orders.edit', $this->data);
  113. }
  114. public function store(StoreSparePartOrderRequest $request): RedirectResponse
  115. {
  116. $data = $request->validated();
  117. $data['user_id'] = auth()->id();
  118. // Observer автоматически обработает дефициты при создании партии со статусом in_stock
  119. SparePartOrder::create($data);
  120. $previous_url = $this->previousUrlForRedirect(
  121. $request,
  122. 'previous_url_spare_part_orders',
  123. route('spare_part_orders.index', session('gp_spare_part_orders'))
  124. );
  125. return redirect()->to($previous_url)->with(['success' => 'Заказ детали успешно создан!']);
  126. }
  127. public function update(StoreSparePartOrderRequest $request, SparePartOrder $sparePartOrder): RedirectResponse
  128. {
  129. // Observer автоматически обработает дефициты при смене статуса на in_stock
  130. $sparePartOrder->update($request->validated());
  131. $previous_url = $this->previousUrlForRedirect(
  132. $request,
  133. 'previous_url_spare_part_orders',
  134. route('spare_part_orders.index', session('gp_spare_part_orders'))
  135. );
  136. return redirect()->to($previous_url)->with(['success' => 'Заказ детали успешно обновлён!']);
  137. }
  138. public function destroy(SparePartOrder $sparePartOrder): RedirectResponse
  139. {
  140. // Проверяем, есть ли активные резервы
  141. if ($sparePartOrder->reservations()->where('status', 'active')->exists()) {
  142. return redirect()->route('spare_part_orders.show', $sparePartOrder)
  143. ->with(['error' => 'Невозможно удалить заказ с активными резервами!']);
  144. }
  145. $sparePartOrder->delete();
  146. return redirect()->route('spare_part_orders.index', session('gp_spare_part_orders'))
  147. ->with(['success' => 'Заказ детали успешно удалён!']);
  148. }
  149. /**
  150. * Прямое списание (отгрузка) без резерва
  151. */
  152. public function ship(ShipSparePartOrderRequest $request, SparePartOrder $sparePartOrder): RedirectResponse
  153. {
  154. $validated = $request->validated();
  155. try {
  156. $this->issueService->directIssue(
  157. $sparePartOrder,
  158. $validated['quantity'],
  159. $validated['note']
  160. );
  161. return redirect()->route('spare_part_orders.show', $sparePartOrder)
  162. ->with(['success' => 'Отгрузка успешно выполнена!']);
  163. } catch (\InvalidArgumentException $e) {
  164. return redirect()->route('spare_part_orders.show', $sparePartOrder)
  165. ->with(['error' => $e->getMessage()]);
  166. }
  167. }
  168. /**
  169. * Изменить статус на "На складе"
  170. */
  171. public function setInStock(SparePartOrder $sparePartOrder): RedirectResponse
  172. {
  173. // Observer автоматически обработает дефициты при смене статуса
  174. $sparePartOrder->update(['status' => SparePartOrder::STATUS_IN_STOCK]);
  175. return redirect()->route('spare_part_orders.show', $sparePartOrder)
  176. ->with(['success' => 'Статус изменён на "На складе"!']);
  177. }
  178. /**
  179. * Изменить статус всех заказов с одинаковым номером на "На складе"
  180. */
  181. public function setOrderInStock(Request $request): RedirectResponse
  182. {
  183. $validated = $request->validate([
  184. 'bulk_order_number' => 'required|string',
  185. ]);
  186. $orderNumber = trim((string) $validated['bulk_order_number']);
  187. $query = SparePartOrder::query()
  188. ->where('status', SparePartOrder::STATUS_ORDERED)
  189. ->where('order_number', $orderNumber);
  190. if (!$query->exists()) {
  191. throw ValidationException::withMessages([
  192. 'bulk_order_number' => 'Заказ со статусом "Заказано" не найден в выбранном году.',
  193. ]);
  194. }
  195. $query->update([
  196. 'status' => SparePartOrder::STATUS_IN_STOCK,
  197. ]);
  198. return redirect()->route('spare_part_orders.index', session('gp_spare_part_orders'))
  199. ->with(['success' => 'Все позиции заказа переведены в статус "На складе"!']);
  200. }
  201. /**
  202. * Коррекция остатка (инвентаризация)
  203. */
  204. public function correct(Request $request, SparePartOrder $sparePartOrder): RedirectResponse
  205. {
  206. $validated = $request->validate([
  207. 'new_quantity' => 'required|integer|min:0',
  208. 'reason' => 'required|string|max:500',
  209. ]);
  210. try {
  211. $this->issueService->correctInventory(
  212. $sparePartOrder,
  213. $validated['new_quantity'],
  214. $validated['reason']
  215. );
  216. return redirect()->route('spare_part_orders.show', $sparePartOrder)
  217. ->with(['success' => 'Коррекция выполнена!']);
  218. } catch (\InvalidArgumentException $e) {
  219. return redirect()->route('spare_part_orders.show', $sparePartOrder)
  220. ->with(['error' => $e->getMessage()]);
  221. }
  222. }
  223. }