SparePartOrderController.php 10 KB

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