ProductionOrderController.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287
  1. <?php
  2. declare(strict_types=1);
  3. namespace App\Http\Controllers;
  4. use App\Enums\ProductionOrderExecutionType;
  5. use App\Enums\ProductionOrderStatus;
  6. use App\Http\Requests\SaveProductionOrderRequest;
  7. use App\Models\CommonCatalogItem;
  8. use App\Models\ProductionOrder;
  9. use App\Models\Role;
  10. use App\Models\User;
  11. use App\Services\Access\FieldAccessService;
  12. use App\Services\ProductionOrderService;
  13. use Illuminate\Contracts\View\View;
  14. use Illuminate\Http\JsonResponse;
  15. use Illuminate\Http\RedirectResponse;
  16. use Illuminate\Http\Request;
  17. use Illuminate\Support\Arr;
  18. class ProductionOrderController extends Controller
  19. {
  20. private const FIELD_MAP = [
  21. 'status_name' => 'status',
  22. 'execution_type_name' => 'execution_type',
  23. 'items_count' => 'id',
  24. ];
  25. protected array $data = [
  26. 'active' => 'schedule_orders',
  27. 'title' => 'График заказов',
  28. 'id' => 'schedule_orders',
  29. 'header' => [
  30. 'id' => 'ID',
  31. 'order_number' => 'Номер заказа',
  32. 'customer_name' => 'Заказчик',
  33. 'object_address' => 'Адрес объекта',
  34. 'invoice_number' => '№ счёта',
  35. 'payment_date' => 'Дата оплаты',
  36. 'supply_working_days' => 'Срок поставки',
  37. 'contract_shipment_date' => 'Дата отгрузки по договору',
  38. 'application_shipment_date' => 'Дата отгрузки по заявке',
  39. 'status_name' => 'Статус',
  40. 'execution_type_name' => 'Тип',
  41. 'manager_id' => 'Менеджер',
  42. 'items_count' => 'МАФ',
  43. 'note' => 'Примечание',
  44. ],
  45. 'searchFields' => [
  46. 'order_number',
  47. 'customer_name',
  48. 'object_address',
  49. 'invoice_number',
  50. 'contract_number',
  51. 'note',
  52. ],
  53. ];
  54. public function index(Request $request): View
  55. {
  56. session(['gp_schedule_orders' => $request->query()]);
  57. $nav = $this->startNavigationContext($request);
  58. $model = new ProductionOrder;
  59. $this->data['header'] = array_filter(
  60. $this->data['header'],
  61. fn (string $field): bool => $request->user()->canViewField(
  62. 'schedule-orders',
  63. self::FIELD_MAP[$field] ?? $field,
  64. ),
  65. ARRAY_FILTER_USE_KEY,
  66. );
  67. $this->data['searchFields'] = array_values(array_filter(
  68. $this->data['searchFields'],
  69. fn (string $field): bool => $request->user()->canViewField('schedule-orders', $field),
  70. ));
  71. $this->createDateFilters(
  72. $model,
  73. ...array_values(array_intersect([
  74. 'payment_date',
  75. 'contract_shipment_date',
  76. 'application_shipment_date',
  77. ], array_keys($this->data['header']))),
  78. );
  79. if (isset($this->data['header']['supply_working_days'])) {
  80. $this->createRangeFilters($model, 'supply_working_days');
  81. }
  82. foreach (['status_name', 'execution_type_name'] as $field) {
  83. if (isset($this->data['header'][$field])) {
  84. $this->data['filters'][$field] = [
  85. 'title' => $this->data['header'][$field],
  86. 'values' => [],
  87. ];
  88. }
  89. }
  90. $query = ProductionOrder::query()->with('manager')->withCount('items');
  91. $this->acceptFilters($query, $request);
  92. $this->acceptSearch($query, $request);
  93. $requestedSort = $request->string('sortBy')->toString();
  94. $sortMap = [
  95. 'status_name' => 'status',
  96. 'execution_type_name' => 'execution_type',
  97. 'items_count' => 'items_count',
  98. ];
  99. if (isset($sortMap[$requestedSort])) {
  100. $request->merge(['sortBy' => $sortMap[$requestedSort]]);
  101. }
  102. $this->setSortAndOrderBy($model, $request);
  103. if ($requestedSort !== '' && isset($sortMap[$requestedSort])) {
  104. $this->data['sortBy'] = $requestedSort;
  105. $query->orderBy($sortMap[$requestedSort], $this->data['orderBy']);
  106. $query->orderBy('id', $this->data['orderBy']);
  107. } else {
  108. $this->applyStableSorting($query);
  109. }
  110. $this->data['orders'] = $query->paginate($this->data['per_page'])->withQueryString();
  111. $this->data['nav'] = $nav;
  112. return view('production_orders.index', $this->data);
  113. }
  114. public function create(Request $request, FieldAccessService $fieldAccess): View
  115. {
  116. return $this->orderView($request, $fieldAccess);
  117. }
  118. public function show(
  119. Request $request,
  120. ProductionOrder $productionOrder,
  121. FieldAccessService $fieldAccess,
  122. ): View {
  123. return $this->orderView(
  124. $request,
  125. $fieldAccess,
  126. $productionOrder->load(['manager', 'items.catalogItem.imageFile']),
  127. );
  128. }
  129. public function store(
  130. SaveProductionOrderRequest $request,
  131. FieldAccessService $fieldAccess,
  132. ProductionOrderService $service,
  133. ): RedirectResponse {
  134. $validated = $request->validated();
  135. $items = $validated['items'];
  136. $fields = array_keys(config('access.schedule-orders.fields', []));
  137. $payload = $fieldAccess->filterValidatedPayload(
  138. $request->user(),
  139. 'schedule-orders',
  140. Arr::only($validated, $fields),
  141. );
  142. $payload['items'] = $items;
  143. $order = $service->create($payload, $request->user());
  144. return redirect()->route('schedule.orders.show', $this->withNav(
  145. ['productionOrder' => $order],
  146. $this->resolveNavToken($request),
  147. ))->with('success', 'Заказ создан.');
  148. }
  149. public function update(
  150. SaveProductionOrderRequest $request,
  151. ProductionOrder $productionOrder,
  152. FieldAccessService $fieldAccess,
  153. ProductionOrderService $service,
  154. ): RedirectResponse {
  155. $validated = $request->validated();
  156. $fields = array_keys(config('access.schedule-orders.fields', []));
  157. $payload = $fieldAccess->filterValidatedPayload(
  158. $request->user(),
  159. 'schedule-orders',
  160. Arr::only($validated, $fields),
  161. );
  162. $canManageItems = $request->user()->hasPermission('schedule-orders.items.manage');
  163. $editableItemFields = array_values(array_filter(
  164. ['factory_number', 'manufacture_date'],
  165. fn (string $field): bool => $request->user()->canUpdateField('schedule-orders', $field),
  166. ));
  167. if (($canManageItems || $editableItemFields !== []) && isset($validated['items'])) {
  168. $payload['items'] = $validated['items'];
  169. }
  170. $service->update(
  171. $productionOrder,
  172. $payload,
  173. $request->user(),
  174. $canManageItems,
  175. $editableItemFields,
  176. );
  177. return redirect()->route('schedule.orders.show', $this->withNav(
  178. ['productionOrder' => $productionOrder],
  179. $this->resolveNavToken($request),
  180. ))->with('success', 'Заказ обновлён.');
  181. }
  182. public function destroy(Request $request, ProductionOrder $productionOrder): RedirectResponse
  183. {
  184. $productionOrder->delete();
  185. return redirect()
  186. ->route('schedule.orders', session('gp_schedule_orders'))
  187. ->with('success', 'Заказ удалён.');
  188. }
  189. public function searchCatalogItems(Request $request): JsonResponse
  190. {
  191. $validated = $request->validate([
  192. 'q' => ['nullable', 'string', 'max:200'],
  193. ]);
  194. $search = trim((string) ($validated['q'] ?? ''));
  195. if (mb_strlen($search) < 2) {
  196. return response()->json([]);
  197. }
  198. $items = CommonCatalogItem::query()
  199. ->where(function ($query) use ($search): void {
  200. $query
  201. ->where('article', 'like', "%{$search}%")
  202. ->orWhere('calculator_name', 'like', "%{$search}%")
  203. ->orWhere('print_name', 'like', "%{$search}%");
  204. })
  205. ->orderBy('article')
  206. ->limit(50)
  207. ->get(['id', 'article', 'calculator_name', 'print_name'])
  208. ->map(static fn (CommonCatalogItem $item): array => [
  209. 'id' => $item->id,
  210. 'label' => $item->article.' — '.($item->calculator_name ?: $item->print_name ?: 'Без наименования'),
  211. ])
  212. ->values();
  213. return response()->json($items);
  214. }
  215. private function orderView(
  216. Request $request,
  217. FieldAccessService $fieldAccess,
  218. ?ProductionOrder $order = null,
  219. ): View {
  220. $nav = $this->resolveNavToken($request);
  221. $this->rememberNavigation($request, $nav);
  222. $fields = array_keys(config('access.schedule-orders.fields', []));
  223. $catalogItemIds = collect($order?->items ?? [])
  224. ->pluck('common_catalog_item_id')
  225. ->merge(collect($request->old('items', []))->pluck('common_catalog_item_id'))
  226. ->filter()
  227. ->unique()
  228. ->values();
  229. return view('production_orders.edit', [
  230. 'active' => 'schedule_orders',
  231. 'title' => $order ? 'Заказ '.$order->order_number : 'Новый заказ',
  232. 'order' => $order,
  233. 'nav' => $nav,
  234. 'back_url' => $this->navigationBackUrl(
  235. $request,
  236. $nav,
  237. route('schedule.orders', session('gp_schedule_orders')),
  238. ),
  239. 'readableFields' => array_fill_keys(
  240. $fieldAccess->filterReadableFields($request->user(), 'schedule-orders', $fields),
  241. true,
  242. ),
  243. 'writableFields' => collect($fields)->mapWithKeys(fn (string $field): array => [
  244. $field => $request->user()->canUpdateField('schedule-orders', $field),
  245. ])->all(),
  246. 'canManageItems' => $request->user()->hasPermission('schedule-orders.items.manage'),
  247. 'canUpdateFactoryNumber' => $request->user()->canUpdateField('schedule-orders', 'factory_number'),
  248. 'canUpdateManufactureDate' => $request->user()->canUpdateField('schedule-orders', 'manufacture_date'),
  249. 'managers' => User::query()
  250. ->where('role', Role::MANAGER)
  251. ->orderBy('name')
  252. ->pluck('name', 'id'),
  253. 'catalogItems' => CommonCatalogItem::query()
  254. ->whereKey($catalogItemIds)
  255. ->get(['id', 'article', 'calculator_name', 'print_name'])
  256. ->keyBy('id'),
  257. 'statuses' => ProductionOrderStatus::options(),
  258. 'executionTypes' => ProductionOrderExecutionType::options(),
  259. ]);
  260. }
  261. }