SparePartOrderController.php 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275
  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. $nav = $this->startNavigationContext($request);
  47. $model = new SparePartOrdersView();
  48. // Фильтры
  49. $this->createFilters($model, 'article', 'order_number');
  50. $this->createRangeFilters($model, 'ordered_quantity', 'available_qty');
  51. $this->createDateFilters($model, 'created_at');
  52. // Фильтр статуса с русскими названиями
  53. $this->data['filters']['status'] = [
  54. 'title' => 'Статус',
  55. 'values' => SparePartOrdersView::STATUS_NAMES
  56. ];
  57. // Фильтр "С документами"
  58. $this->data['filters']['with_documents'] = [
  59. 'title' => 'С документами',
  60. 'values' => [
  61. 1 => 'Да',
  62. 0 => 'Нет',
  63. ]
  64. ];
  65. // Запрос
  66. $q = $model::query();
  67. // Специальная обработка фильтров из клика по каталогу
  68. if ($request->has('spare_part_id')) {
  69. $sparePart = SparePart::find($request->get('spare_part_id'));
  70. if ($sparePart) {
  71. $q->where('spare_part_id', $sparePart->id);
  72. $this->data['filter_spare_part'] = $sparePart;
  73. }
  74. }
  75. $this->acceptFilters($q, $request);
  76. $this->acceptSearch($q, $request);
  77. $this->setSortAndOrderBy($model, $request);
  78. $this->applyStableSorting($q);
  79. $this->data['spare_part_orders'] = $q->paginate($this->data['per_page'])->withQueryString();
  80. $this->data['order_numbers'] = SparePartOrder::query()
  81. ->where('status', SparePartOrder::STATUS_ORDERED)
  82. ->whereNotNull('order_number')
  83. ->where('order_number', '!=', '')
  84. ->orderBy('order_number')
  85. ->distinct()
  86. ->pluck('order_number');
  87. $this->data['strings'] = $this->data['spare_part_orders'];
  88. $this->data['tab'] = 'orders';
  89. $this->data['nav'] = $nav;
  90. return view('spare_parts.index', $this->data);
  91. }
  92. public function show(Request $request, SparePartOrder $sparePartOrder)
  93. {
  94. $nav = $this->resolveNavToken($request);
  95. $this->rememberNavigation($request, $nav);
  96. $this->data['nav'] = $nav;
  97. $this->data['back_url'] = $this->navigationBackUrl(
  98. $request,
  99. $nav,
  100. route('spare_part_orders.index', session('gp_spare_part_orders'))
  101. );
  102. $this->data['spare_part_order'] = $sparePartOrder->load([
  103. 'sparePart',
  104. 'movements.user',
  105. 'reservations.reclamation',
  106. ]);
  107. return view('spare_part_orders.edit', $this->data);
  108. }
  109. public function create(Request $request)
  110. {
  111. $nav = $this->resolveNavToken($request);
  112. $this->rememberNavigation($request, $nav);
  113. $this->data['nav'] = $nav;
  114. $this->data['back_url'] = $this->navigationBackUrl(
  115. $request,
  116. $nav,
  117. route('spare_part_orders.index', session('gp_spare_part_orders'))
  118. );
  119. $this->data['spare_part_order'] = null;
  120. return view('spare_part_orders.edit', $this->data);
  121. }
  122. public function store(StoreSparePartOrderRequest $request): RedirectResponse
  123. {
  124. $data = $request->validated();
  125. $data['user_id'] = auth()->id();
  126. // Observer автоматически обработает дефициты при создании партии со статусом in_stock
  127. SparePartOrder::create($data);
  128. $nav = $this->resolveNavToken($request);
  129. $backUrl = $this->navigationParentUrl(
  130. $nav,
  131. route('spare_part_orders.index', session('gp_spare_part_orders'))
  132. );
  133. return redirect()->to($backUrl)->with(['success' => 'Заказ детали успешно создан!']);
  134. }
  135. public function update(StoreSparePartOrderRequest $request, SparePartOrder $sparePartOrder): RedirectResponse
  136. {
  137. // Observer автоматически обработает дефициты при смене статуса на in_stock
  138. $sparePartOrder->update($request->validated());
  139. $nav = $this->resolveNavToken($request);
  140. $backUrl = $this->navigationParentUrl(
  141. $nav,
  142. route('spare_part_orders.index', session('gp_spare_part_orders'))
  143. );
  144. return redirect()->to($backUrl)->with(['success' => 'Заказ детали успешно обновлён!']);
  145. }
  146. public function destroy(Request $request, SparePartOrder $sparePartOrder): RedirectResponse
  147. {
  148. // Проверяем, есть ли активные резервы
  149. if ($sparePartOrder->reservations()->where('status', 'active')->exists()) {
  150. return $this->redirectToSparePartOrderShow($request, $sparePartOrder)
  151. ->with(['error' => 'Невозможно удалить заказ с активными резервами!']);
  152. }
  153. $sparePartOrder->delete();
  154. return redirect()->route('spare_part_orders.index', session('gp_spare_part_orders'))
  155. ->with(['success' => 'Заказ детали успешно удалён!']);
  156. }
  157. /**
  158. * Прямое списание (отгрузка) без резерва
  159. */
  160. public function ship(ShipSparePartOrderRequest $request, SparePartOrder $sparePartOrder): RedirectResponse
  161. {
  162. $validated = $request->validated();
  163. try {
  164. $this->issueService->directIssue(
  165. $sparePartOrder,
  166. $validated['quantity'],
  167. $validated['note']
  168. );
  169. return $this->redirectToSparePartOrderShow($request, $sparePartOrder)
  170. ->with(['success' => 'Отгрузка успешно выполнена!']);
  171. } catch (\InvalidArgumentException $e) {
  172. return $this->redirectToSparePartOrderShow($request, $sparePartOrder)
  173. ->with(['error' => $e->getMessage()]);
  174. }
  175. }
  176. /**
  177. * Изменить статус на "На складе"
  178. */
  179. public function setInStock(SparePartOrder $sparePartOrder): RedirectResponse
  180. {
  181. // Observer автоматически обработает дефициты при смене статуса
  182. $sparePartOrder->update(['status' => SparePartOrder::STATUS_IN_STOCK]);
  183. return $this->redirectToSparePartOrderShow(request(), $sparePartOrder)
  184. ->with(['success' => 'Статус изменён на "На складе"!']);
  185. }
  186. /**
  187. * Изменить статус всех заказов с одинаковым номером на "На складе"
  188. */
  189. public function setOrderInStock(Request $request): RedirectResponse
  190. {
  191. $validated = $request->validate([
  192. 'bulk_order_number' => 'required|string',
  193. ]);
  194. $orderNumber = trim((string) $validated['bulk_order_number']);
  195. $query = SparePartOrder::query()
  196. ->where('status', SparePartOrder::STATUS_ORDERED)
  197. ->where('order_number', $orderNumber);
  198. if (!$query->exists()) {
  199. throw ValidationException::withMessages([
  200. 'bulk_order_number' => 'Заказ со статусом "Заказано" не найден в выбранном году.',
  201. ]);
  202. }
  203. $query->update([
  204. 'status' => SparePartOrder::STATUS_IN_STOCK,
  205. ]);
  206. return redirect()->route('spare_part_orders.index', session('gp_spare_part_orders'))
  207. ->with(['success' => 'Все позиции заказа переведены в статус "На складе"!']);
  208. }
  209. /**
  210. * Коррекция остатка (инвентаризация)
  211. */
  212. public function correct(Request $request, SparePartOrder $sparePartOrder): RedirectResponse
  213. {
  214. $validated = $request->validate([
  215. 'new_quantity' => 'required|integer|min:0',
  216. 'reason' => 'required|string|max:500',
  217. ]);
  218. try {
  219. $this->issueService->correctInventory(
  220. $sparePartOrder,
  221. $validated['new_quantity'],
  222. $validated['reason']
  223. );
  224. return $this->redirectToSparePartOrderShow($request, $sparePartOrder)
  225. ->with(['success' => 'Коррекция выполнена!']);
  226. } catch (\InvalidArgumentException $e) {
  227. return $this->redirectToSparePartOrderShow($request, $sparePartOrder)
  228. ->with(['error' => $e->getMessage()]);
  229. }
  230. }
  231. private function redirectToSparePartOrderShow(Request $request, SparePartOrder $sparePartOrder): RedirectResponse
  232. {
  233. $nav = $this->resolveNavToken($request);
  234. return redirect()->route('spare_part_orders.show', $this->withNav(['sparePartOrder' => $sparePartOrder], $nav));
  235. }
  236. }