OrderController.php 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\Http\Requests\CreteTtnRequest;
  4. use App\Http\Requests\ExportScheduleRequest;
  5. use App\Http\Requests\Order\StoreOrderRequest;
  6. use App\Jobs\ExportOneOrderJob;
  7. use App\Jobs\ExportOrdersJob;
  8. use App\Jobs\ExportScheduleJob;
  9. use App\Jobs\GenerateFilesPack;
  10. use App\Jobs\GenerateHandoverPack;
  11. use App\Jobs\GenerateInstallationPack;
  12. use App\Jobs\GenerateTtnPack;
  13. use App\Models\Dictionary\Area;
  14. use App\Models\Dictionary\District;
  15. use App\Models\File;
  16. use App\Models\MafOrder;
  17. use App\Models\ObjectType;
  18. use App\Models\Order;
  19. use App\Models\OrderStatus;
  20. use App\Models\OrderView;
  21. use App\Models\ProductSKU;
  22. use App\Models\Role;
  23. use App\Models\Schedule;
  24. use App\Models\Ttn;
  25. use App\Models\User;
  26. use App\Services\FileService;
  27. use App\Services\NotificationService;
  28. use Illuminate\Http\RedirectResponse;
  29. use Illuminate\Http\Request;
  30. use Illuminate\Support\Facades\DB;
  31. use Illuminate\Support\Str;
  32. use Illuminate\Support\Facades\Storage;
  33. use Symfony\Component\HttpFoundation\BinaryFileResponse;
  34. use Throwable;
  35. use ZipArchive;
  36. class OrderController extends Controller
  37. {
  38. protected array $data = [
  39. 'active' => 'orders',
  40. 'title' => 'Заказы',
  41. 'id' => 'orders',
  42. 'header' => [
  43. 'id' => 'ID',
  44. 'name' => 'Название',
  45. 'user_name' => 'Менеджер',
  46. 'district_name' => 'Округ',
  47. 'area_name' => 'Район',
  48. 'object_address' => 'Адрес объекта',
  49. 'object_type_name' => 'Тип объекта',
  50. 'comment' => 'Комментарий',
  51. 'products_total' => 'Всего МАФ',
  52. 'installation_date' => 'Дата выхода на монтаж',
  53. 'ready_date' => 'Дата готовности площадки',
  54. 'brigadier_name' => 'Бригадир',
  55. 'order_status_name' => 'Статус',
  56. 'tg_group_name' => 'Имя группы в ТГ',
  57. 'tg_group_link' => 'Ссылка на группу в ТГ',
  58. 'products_with_count' => 'МАФы',
  59. 'ready_to_mount' => 'Все МАФы на складе',
  60. ],
  61. 'searchFields' => [
  62. 'name',
  63. 'user_name',
  64. 'district_name',
  65. 'area_name',
  66. 'object_type_name',
  67. 'comment',
  68. 'object_address',
  69. 'installation_date',
  70. 'tg_group_name',
  71. 'tg_group_link',
  72. ],
  73. ];
  74. public function __construct()
  75. {
  76. $this->data['districts'] = District::query()->get()->pluck('name', 'id');
  77. $this->data['areas'] = Area::query()->get()->pluck('name', 'id');
  78. $this->data['objectTypes'] = ObjectType::query()->get()->pluck('name', 'id');
  79. $this->data['orderStatuses'] =OrderStatus::query()->get()->pluck('name', 'id');
  80. $this->data['brigadiers'] = User::query()->where('role', Role::BRIGADIER)->get()->pluck('name', 'id');
  81. $this->data['users'] = User::query()->whereIn('role', [Role::MANAGER, Role::ADMIN])->get()->pluck('name', 'id');
  82. }
  83. /**
  84. * Display a listing of the resource.
  85. */
  86. public function index(Request $request)
  87. {
  88. session(['gp_orders' => $request->all()]);
  89. $nav = $this->resolveNavToken($request);
  90. $this->rememberNavigation($request, $nav);
  91. $model = new OrderView;
  92. // fill filters
  93. $this->createFilters($model, 'user_name', 'district_name', 'area_name', 'object_type_name', 'brigadier_name', 'order_status_name', 'ready_to_mount');
  94. $this->createDateFilters($model, 'installation_date', 'ready_date');
  95. $this->data['ranges'] = [];
  96. $q = $model::query();
  97. $this->acceptFilters($q, $request);
  98. $this->acceptSearch($q, $request);
  99. $this->setSortAndOrderBy($model, $request);
  100. if(hasRole('brigadier')) {
  101. $q->where('brigadier_id', auth()->id())
  102. ->whereIn('order_status_id', Order::visibleStatusIdsForBrigadier());
  103. }
  104. if(hasRole(Role::WAREHOUSE_HEAD)) {
  105. $q->whereNotNull('brigadier_id');
  106. $q->whereNotNull('installation_date');
  107. }
  108. $this->data['filtered_orders_count'] = (clone $q)->count();
  109. $this->data['filtered_products_total'] = (clone $q)->sum('products_total');
  110. $this->applyStableSorting($q);
  111. $this->data['orders'] = $q->paginate($this->data['per_page'])->withQueryString();
  112. foreach ($this->data['orders'] as $order) {
  113. Order::where('id', $order->id)->first()?->recalculateReadyToMount();
  114. }
  115. $this->data['statuses'] = OrderStatus::query()->get()->pluck('name', 'id');
  116. $this->data['nav'] = $nav;
  117. return view('orders.index', $this->data);
  118. }
  119. /**
  120. * Show the form for creating a new resource.
  121. */
  122. public function create(Request $request)
  123. {
  124. $nav = $this->resolveNavToken($request);
  125. $this->rememberNavigation($request, $nav);
  126. $this->data['nav'] = $nav;
  127. $this->data['back_url'] = $this->navigationBackUrl(
  128. $request,
  129. $nav,
  130. route('order.index', session('gp_orders'))
  131. );
  132. return view('orders.edit', $this->data);
  133. }
  134. /**
  135. * Store a newly created resource in storage.
  136. */
  137. public function store(StoreOrderRequest $request, NotificationService $notificationService)
  138. {
  139. $data = $request->validated();
  140. $products = $request->validated('products');
  141. $quantities = $request->validated('quantity');
  142. unset($data['products']);
  143. if(isset($data['id'])) {
  144. $order = Order::query()->where('id', $data['id'])->first();
  145. $status = $order->order_status_id;
  146. $statusErrors = $this->validateMountStatusChange($order, $data['order_status_id'] ?? null);
  147. if ($statusErrors !== []) {
  148. return $this->mountStatusValidationFailed($request, $statusErrors);
  149. }
  150. $order->update($data);
  151. $order->refresh();
  152. if($order->order_status_id != $status) {
  153. $notificationService->notifyOrderStatusChanged($order, auth()->user());
  154. }
  155. } else {
  156. $data['order_status_id'] = Order::STATUS_NEW;
  157. $order = Order::query()->create($data);
  158. $tg_group_name = '/' . $order->district->shortname
  159. . ' ' . $order->object_address
  160. . ' (' . $order->area->name . ')'
  161. . ' - ' . $order->user->name;
  162. $order->update(['tg_group_name' => $tg_group_name]);
  163. $notificationService->notifyOrderCreated($order, auth()->user());
  164. }
  165. // меняем список товаров заказа только если статус новый
  166. if($products && $quantities && ($order->order_status_id == 1)) {
  167. $desiredCounts = [];
  168. foreach ($products as $key => $productId) {
  169. $quantity = (int)($quantities[$key] ?? 0);
  170. if ($quantity < 1) {
  171. continue;
  172. }
  173. if (!isset($desiredCounts[$productId])) {
  174. $desiredCounts[$productId] = 0;
  175. }
  176. $desiredCounts[$productId] += $quantity;
  177. }
  178. $attachedSkus = ProductSKU::query()
  179. ->where('order_id', $order->id)
  180. ->whereNotNull('maf_order_id')
  181. ->with('product:id,article')
  182. ->get();
  183. $attachedByProduct = [];
  184. foreach ($attachedSkus as $sku) {
  185. if (!isset($attachedByProduct[$sku->product_id])) {
  186. $attachedByProduct[$sku->product_id] = 0;
  187. }
  188. $attachedByProduct[$sku->product_id]++;
  189. }
  190. $currentCounts = ProductSKU::query()
  191. ->where('order_id', $order->id)
  192. ->selectRaw('product_id, COUNT(*) as cnt')
  193. ->groupBy('product_id')
  194. ->pluck('cnt', 'product_id')
  195. ->map(fn ($count) => (int)$count)
  196. ->toArray();
  197. $errors = [];
  198. foreach ($attachedByProduct as $productId => $attachedCount) {
  199. $desiredCount = $desiredCounts[$productId] ?? 0;
  200. if ($desiredCount < $attachedCount) {
  201. $article = $attachedSkus->firstWhere('product_id', $productId)?->product?->article ?? ('ID ' . $productId);
  202. $errors[] = "Нельзя удалить привязанные МАФ {$article}: привязано {$attachedCount} шт.";
  203. }
  204. }
  205. // Если есть хотя бы один привязанный МАФ, запрещаем добавлять новые позиции/количество.
  206. if (!empty($attachedByProduct)) {
  207. foreach ($desiredCounts as $productId => $desiredCount) {
  208. $currentCount = $currentCounts[$productId] ?? 0;
  209. if ($desiredCount > $currentCount) {
  210. $errors[] = 'Нельзя добавлять новые позиции МАФ, пока на площадке есть привязанные МАФ.';
  211. break;
  212. }
  213. }
  214. }
  215. if (!empty($errors)) {
  216. return redirect()->back()->withInput()->with(['danger' => $errors]);
  217. }
  218. // Удаляем только непривязанные SKU и пересоздаём их по новому списку.
  219. ProductSKU::query()
  220. ->where('order_id', $order->id)
  221. ->whereNull('maf_order_id')
  222. ->delete();
  223. foreach ($desiredCounts as $productId => $desiredCount) {
  224. $attachedCount = $attachedByProduct[$productId] ?? 0;
  225. $toCreate = $desiredCount - $attachedCount;
  226. for ($i = 0; $i < $toCreate; $i++) {
  227. ProductSKU::query()->create([
  228. 'order_id' => $order->id,
  229. 'product_id' => $productId,
  230. 'status' => 'требуется'
  231. ]);
  232. }
  233. }
  234. }
  235. $order->refresh();
  236. $order->autoChangeStatus();
  237. $nav = $this->resolveNavToken($request);
  238. return redirect()->route('order.show', $this->withNav(['order' => $order], $nav));
  239. }
  240. private function validateMountStatusChange(Order $order, mixed $newStatusId): array
  241. {
  242. if ((int) $newStatusId !== Order::STATUS_IN_MOUNT) {
  243. return [];
  244. }
  245. return $order->getMountStatusErrors();
  246. }
  247. private function mountStatusValidationFailed(Request $request, array $errors)
  248. {
  249. if ($request->expectsJson() || $request->ajax()) {
  250. return response()->json([
  251. 'message' => $errors[0],
  252. 'errors' => $errors,
  253. ], 422);
  254. }
  255. return redirect()->back()->withInput()->with(['danger' => $errors]);
  256. }
  257. /**
  258. * Display the specified resource.
  259. */
  260. public function show(Request $request, int $order)
  261. {
  262. $this->data['order'] = Order::query()
  263. ->withoutGlobalScope(\App\Models\Scopes\YearScope::class)
  264. ->with([
  265. 'chatMessages.user',
  266. 'chatMessages.targetUser',
  267. 'chatMessages.notifiedUsers',
  268. 'chatMessages.files',
  269. ])
  270. ->find($order);
  271. if ($request->boolean('sync_year') && $this->data['order']) {
  272. $previousYear = year();
  273. $targetYear = (int)$this->data['order']->year;
  274. if ($previousYear !== $targetYear) {
  275. session(['year' => $targetYear]);
  276. session()->flash('warning', "Год переключен: {$previousYear} → {$targetYear} (по году площадки).");
  277. }
  278. }
  279. if (hasRole('brigadier') && $this->data['order']) {
  280. $canView = (int)$this->data['order']->brigadier_id === (int)auth()->id()
  281. && in_array((int)$this->data['order']->order_status_id, Order::visibleStatusIdsForBrigadier(), true);
  282. if (!$canView) {
  283. abort(403);
  284. }
  285. }
  286. $nav = $this->resolveNavToken($request);
  287. $this->rememberNavigation($request, $nav);
  288. $this->data['nav'] = $nav;
  289. $this->data['back_url'] = $this->navigationBackUrl(
  290. $request,
  291. $nav,
  292. route('order.index', session('gp_orders'))
  293. );
  294. $orderModel = $this->data['order'];
  295. $chatUsers = User::query()->orderBy('name')->get(['id', 'name', 'role']);
  296. $responsibleUserIds = User::query()
  297. ->where('role', Role::ADMIN)
  298. ->pluck('id')
  299. ->map(static fn ($id) => (int) $id)
  300. ->all();
  301. $responsibleUserIds = array_values(array_unique(array_filter(array_merge($responsibleUserIds, [
  302. $orderModel?->user_id ? (int) $orderModel->user_id : null,
  303. $orderModel?->brigadier_id ? (int) $orderModel->brigadier_id : null,
  304. ]))));
  305. $this->data['chatUsers'] = $chatUsers->map(fn ($u) => [
  306. 'id' => $u->id,
  307. 'name' => $u->name,
  308. 'role' => $u->role,
  309. ])->keyBy('id');
  310. $this->data['chatResponsibleUserIds'] = $responsibleUserIds;
  311. $this->data['chatManagerUserId'] = $orderModel?->user_id ? (int) $orderModel->user_id : null;
  312. $this->data['chatBrigadierUserId'] = $orderModel?->brigadier_id ? (int) $orderModel->brigadier_id : null;
  313. return view('orders.show', $this->data);
  314. }
  315. /**
  316. * Show the form for editing the specified resource.
  317. */
  318. public function edit(Request $request, Order $order)
  319. {
  320. $this->data['order'] = $order;
  321. $nav = $this->resolveNavToken($request);
  322. $this->rememberNavigation($request, $nav);
  323. $this->data['nav'] = $nav;
  324. $this->data['back_url'] = $this->navigationBackUrl(
  325. $request,
  326. $nav,
  327. route('order.index', session('gp_orders'))
  328. );
  329. return view('orders.edit', $this->data);
  330. }
  331. /**
  332. * Привязка товаров к заказу
  333. * @param Order $order
  334. * @return RedirectResponse
  335. * @throws Throwable
  336. */
  337. public function getMafToOrder(Order $order)
  338. {
  339. $attached = 0;
  340. $missingByProduct = [];
  341. DB::transaction(function () use ($order, &$attached, &$missingByProduct) {
  342. foreach ($order->products_sku as $productSku) {
  343. // Уже привязан, пропускаем
  344. if ($productSku->maf_order_id) {
  345. continue;
  346. }
  347. $mafOrder = MafOrder::query()
  348. ->where('product_id', $productSku->product_id)
  349. ->where('in_stock', '>', 0)
  350. ->orderBy('created_at')
  351. ->lockForUpdate()
  352. ->first();
  353. if (!$mafOrder) {
  354. $article = $productSku->product?->article ?? ('ID ' . $productSku->product_id);
  355. if (!isset($missingByProduct[$productSku->product_id])) {
  356. $missingByProduct[$productSku->product_id] = ['article' => $article, 'count' => 0];
  357. }
  358. $missingByProduct[$productSku->product_id]['count']++;
  359. continue;
  360. }
  361. $productSku->update(['maf_order_id' => $mafOrder->id, 'status' => 'отгружен']);
  362. $mafOrder->decrement('in_stock');
  363. $attached++;
  364. }
  365. });
  366. $order->autoChangeStatus();
  367. $success = [];
  368. $danger = [];
  369. if ($attached > 0) {
  370. $success[] = "Привязано МАФ: {$attached}.";
  371. }
  372. foreach ($missingByProduct as $missing) {
  373. $danger[] = "Не удалось привязать {$missing['count']} шт. МАФ {$missing['article']}: нет остатка на складе.";
  374. }
  375. if ($attached === 0 && empty($danger)) {
  376. $danger[] = 'Нет МАФ для привязки: все МАФы на площадке уже привязаны.';
  377. }
  378. $flash = [];
  379. if (!empty($success)) {
  380. $flash['success'] = $success;
  381. }
  382. if (!empty($danger)) {
  383. $flash['danger'] = $danger;
  384. }
  385. return redirect()->route('order.show', $order)->with($flash);
  386. }
  387. /**
  388. * @param Order $order
  389. * @return RedirectResponse
  390. */
  391. public function destroy(Order $order)
  392. {
  393. Order::query()->where('id', $order->id)->delete();
  394. ProductSKU::query()->where('order_id', $order->id)->delete();
  395. return redirect()->route('order.index', session('gp_orders'));
  396. }
  397. public function revertMaf(Order $order)
  398. {
  399. $detached = 0;
  400. $notFoundMafOrders = 0;
  401. DB::transaction(function () use ($order, &$detached, &$notFoundMafOrders) {
  402. foreach ($order->products_sku as $maf) {
  403. if (!$maf->maf_order_id) {
  404. continue;
  405. }
  406. $affectedRows = MafOrder::query()
  407. ->where('id', $maf->maf_order_id)
  408. ->lockForUpdate()
  409. ->increment('in_stock');
  410. if (!$affectedRows) {
  411. $notFoundMafOrders++;
  412. continue;
  413. }
  414. $maf->update(['maf_order_id' => null, 'status' => 'требуется']);
  415. $detached++;
  416. }
  417. });
  418. $order->autoChangeStatus();
  419. $success = [];
  420. $danger = [];
  421. if ($detached > 0) {
  422. $success[] = "Отвязано МАФ: {$detached}.";
  423. }
  424. if ($notFoundMafOrders > 0) {
  425. $danger[] = "Не удалось отвязать {$notFoundMafOrders} шт. МАФ: связанный заказ МАФ не найден.";
  426. }
  427. if ($detached === 0 && empty($danger)) {
  428. $danger[] = 'Нет МАФ для отвязки: на площадке нет привязанных МАФ.';
  429. }
  430. $flash = [];
  431. if (!empty($success)) {
  432. $flash['success'] = $success;
  433. }
  434. if (!empty($danger)) {
  435. $flash['danger'] = $danger;
  436. }
  437. return redirect()->route('order.show', $order)->with($flash);
  438. }
  439. public function moveMaf(Request $request)
  440. {
  441. $data = $request->validate([
  442. 'new_order_id' => 'required',
  443. 'ids' => 'required|json',
  444. ]);
  445. $ids = json_decode($data['ids'], true);
  446. $updated = [];
  447. foreach ($ids as $mafId) {
  448. $maf = ProductSKU::query()
  449. ->where('id', $mafId)
  450. ->first();
  451. if($maf) {
  452. $comment = $maf->comment . "\n" . date('Y-m-d H:i') . ' Перенесено с площадки: ' . $maf->order->common_name;
  453. $maf->update(['order_id' => $data['new_order_id'], 'comment' => $comment]);
  454. $updated[] = $maf;
  455. }
  456. }
  457. return response()->json(['success' => true]);
  458. }
  459. public function search(Request $request): array
  460. {
  461. $ret = [];
  462. $s = $request->get('s');
  463. $currentOrderId = $request->integer('current_order_id');
  464. $searchFields = $this->data['searchFields'];
  465. $result = OrderView::query();
  466. if($s) {
  467. $result->where(function ($query) use ($searchFields, $s) {
  468. foreach ($searchFields as $searchField) {
  469. $query->orWhere($searchField, 'LIKE', '%' . $s . '%');
  470. }
  471. });
  472. }
  473. if ($currentOrderId > 0) {
  474. $result->where('id', '!=', $currentOrderId);
  475. }
  476. $result->orderBy('object_address');
  477. foreach ($result->get() as $p) {
  478. $ret[$p->id] = $p->move_maf_name;
  479. }
  480. return $ret;
  481. }
  482. public function uploadPhoto(Request $request, Order $order, FileService $fileService)
  483. {
  484. $data = $request->validate([
  485. 'photo.*' => 'mimes:jpeg,jpg,png,webp',
  486. ]);
  487. try {
  488. $f = [];
  489. foreach ($data['photo'] as $photo) {
  490. $f[] = $fileService->saveUploadedFile('orders/' . $order->id . '/photo', $photo);
  491. }
  492. $order->photos()->syncWithoutDetaching($f);
  493. } catch (Throwable $e) {
  494. report($e);
  495. return redirect()->route('order.show', $order)
  496. ->with(['error' => 'Ошибка загрузки фотографий. Проверьте имя файла и повторите попытку.']);
  497. }
  498. return redirect()->route('order.show', $order)->with(['success' => 'Фотографии успешно загружены!']);
  499. }
  500. public function deletePhoto(Order $order, File $file, FileService $fileService)
  501. {
  502. $order->photos()->detach($file);
  503. Storage::disk('public')->delete($file->path);
  504. $file->delete();
  505. return redirect()->route('order.show', $order);
  506. }
  507. public function deleteAllPhotos(Order $order)
  508. {
  509. $files = $order->photos;
  510. $order->photos()->detach();
  511. foreach ($files as $file) {
  512. Storage::disk('public')->delete($file->path);
  513. $file->delete();
  514. }
  515. return redirect()->route('order.show', $order);
  516. }
  517. public function uploadDocument(Request $request, Order $order, FileService $fileService)
  518. {
  519. $data = $request->validate([
  520. 'document.*' => 'file',
  521. ]);
  522. try {
  523. $f = [];
  524. $i = 0;
  525. foreach ($data['document'] as $document) {
  526. if ($i++ >= 5) break;
  527. $f[] = $fileService->saveUploadedFile('orders/' . $order->id . '/document', $document);
  528. }
  529. $order->documents()->syncWithoutDetaching($f);
  530. } catch (Throwable $e) {
  531. report($e);
  532. return redirect()->route('order.show', $order)
  533. ->with(['error' => 'Ошибка загрузки документов. Проверьте имя файла и повторите попытку.']);
  534. }
  535. return redirect()->route('order.show', $order)->with(['success' => 'Документы успешно загружены!']);
  536. }
  537. public function deleteDocument(Order $order, File $file)
  538. {
  539. $order->documents()->detach($file);
  540. Storage::disk('public')->delete($file->path);
  541. $file->delete();
  542. return redirect()->route('order.show', $order);
  543. }
  544. public function deleteAllDocuments(Order $order)
  545. {
  546. $files = $order->documents;
  547. $order->documents()->detach();
  548. foreach ($files as $file) {
  549. Storage::disk('public')->delete($file->path);
  550. $file->delete();
  551. }
  552. return redirect()->route('order.show', $order);
  553. }
  554. public function uploadStatement(Request $request, Order $order, FileService $fileService)
  555. {
  556. $data = $request->validate([
  557. 'statement.*' => 'file',
  558. ]);
  559. try {
  560. $f = [];
  561. $i = 0;
  562. foreach ($data['statement'] as $statement) {
  563. if ($i++ >= 5) break;
  564. $f[] = $fileService->saveUploadedFile('orders/' . $order->id . '/statement', $statement);
  565. }
  566. $order->statements()->syncWithoutDetaching($f);
  567. } catch (Throwable $e) {
  568. report($e);
  569. return redirect()->route('order.show', $order)
  570. ->with(['error' => 'Ошибка загрузки ведомостей. Проверьте имя файла и повторите попытку.']);
  571. }
  572. return redirect()->route('order.show', $order)->with(['success' => 'Ведомости успешно загружены!']);
  573. }
  574. public function deleteStatement(Order $order, File $file)
  575. {
  576. $order->statements()->detach($file);
  577. Storage::disk('public')->delete($file->path);
  578. $file->delete();
  579. return redirect()->route('order.show', $order);
  580. }
  581. public function deleteAllStatements(Order $order)
  582. {
  583. $files = $order->statements;
  584. $order->statements()->detach();
  585. foreach ($files as $file) {
  586. Storage::disk('public')->delete($file->path);
  587. $file->delete();
  588. }
  589. return redirect()->route('order.show', $order);
  590. }
  591. public function generateInstallationPack(Order $order)
  592. {
  593. $errors = $order->isAllMafConnected();
  594. if($errors) {
  595. return redirect()->route('order.show', $order)->with(['danger' => $errors]);
  596. }
  597. GenerateInstallationPack::dispatch($order, auth()->user()->id);
  598. return redirect()->route('order.show', $order)->with(['success' => 'Задача генерации документов создана!']);
  599. }
  600. public function generateHandoverPack(Order $order)
  601. {
  602. if($errors = $order->canCreateHandover()) {
  603. return redirect()->route('order.show', $order)->with(['danger' => $errors]);
  604. }
  605. GenerateHandoverPack::dispatch($order, auth()->user()->id);
  606. return redirect()->route('order.show', $order)->with(['success' => 'Задача генерации документов создана!']);
  607. }
  608. public function generatePhotosPack(Order $order)
  609. {
  610. GenerateFilesPack::dispatch($order, $order->photos, auth()->user()->id, 'Фото');
  611. return redirect()->back()->with(['success' => 'Задача архивации создана!']);
  612. }
  613. public function createTtn(CreteTtnRequest $request)
  614. {
  615. $ttn = Ttn::query()->create([
  616. 'year' => date('Y'),
  617. 'ttn_number' => Ttn::reserveNextTtnNumber(),
  618. 'ttn_number_suffix' => 'И',
  619. 'order_number' => $request->order_number,
  620. 'order_date' => $request->order_date,
  621. 'departure_date' => $request->departure_date,
  622. 'order_sum' => $request->order_sum,
  623. 'skus' => json_encode($request->skus),
  624. ]);
  625. GenerateTtnPack::dispatch($ttn, auth()->user()->id);
  626. return redirect()->back()->with(['success' => 'Задача формирования ТН создана!']);
  627. }
  628. public function export(Request $request)
  629. {
  630. $request->validate([
  631. 'withFilter' => 'nullable',
  632. 'filters' => 'nullable|array',
  633. 's' => 'nullable|string',
  634. ]);
  635. $orders = Order::query();
  636. if ($request->boolean('withFilter')) {
  637. $filterRequest = new Request(array_filter([
  638. 'filters' => $request->input('filters', []),
  639. 's' => $request->input('s'),
  640. 'sortBy' => $request->input('sortBy'),
  641. 'order' => $request->input('order'),
  642. ], static fn ($value) => $value !== null));
  643. $model = new OrderView;
  644. $this->createFilters($model, 'user_name', 'district_name', 'area_name', 'object_type_name', 'brigadier_name', 'order_status_name', 'ready_to_mount');
  645. $this->createDateFilters($model, 'installation_date', 'ready_date');
  646. $this->data['ranges'] = [];
  647. $q = $model::query();
  648. $this->acceptFilters($q, $filterRequest);
  649. $this->acceptSearch($q, $filterRequest);
  650. $this->setSortAndOrderBy($model, $filterRequest);
  651. if (hasRole('brigadier')) {
  652. $q->where('brigadier_id', auth()->id())
  653. ->whereIn('order_status_id', Order::visibleStatusIdsForBrigadier());
  654. }
  655. if (hasRole(Role::WAREHOUSE_HEAD)) {
  656. $q->whereNotNull('brigadier_id');
  657. $q->whereNotNull('installation_date');
  658. }
  659. $this->applyStableSorting($q);
  660. $orderIds = $q->pluck('id');
  661. $orders = Order::query()
  662. ->whereIn('id', $orderIds)
  663. ->get()
  664. ->sortBy(static fn (Order $order) => $orderIds->search($order->id))
  665. ->values();
  666. } else {
  667. $orders = $orders->get();
  668. }
  669. ExportOrdersJob::dispatch($orders, $request->user()->id);
  670. return redirect()->route('order.index', session('gp_orders'))
  671. ->with(['success' => 'Задача выгрузки создана!']);
  672. }
  673. public function exportOne(Order $order, Request $request)
  674. {
  675. ExportOneOrderJob::dispatch($order, $request->user()->id);
  676. return redirect()->route('order.show', $order->id)
  677. ->with(['success' => 'Задача выгрузки создана!']);
  678. }
  679. public function downloadTechDocs(Order $order): BinaryFileResponse
  680. {
  681. $techDocsPath = public_path('images/tech-docs');
  682. $articles = $order->products_sku
  683. ->pluck('product.article')
  684. ->unique()
  685. ->filter()
  686. ->values();
  687. if ($articles->isEmpty()) {
  688. abort(404, 'Нет МАФов на площадке');
  689. }
  690. $tempFile = tempnam(sys_get_temp_dir(), 'tech_docs_');
  691. if ($tempFile === false) {
  692. abort(500, 'Не удалось создать временный файл архива');
  693. }
  694. $zip = new ZipArchive();
  695. $result = $zip->open($tempFile, ZipArchive::CREATE | ZipArchive::OVERWRITE);
  696. if ($result !== true) {
  697. @unlink($tempFile);
  698. abort(500, 'Не удалось создать архив документации');
  699. }
  700. $filesAdded = 0;
  701. foreach ($articles as $article) {
  702. $articlePath = $techDocsPath . '/' . $article;
  703. if (!is_dir($articlePath)) {
  704. continue;
  705. }
  706. $files = new \RecursiveIteratorIterator(
  707. new \RecursiveDirectoryIterator($articlePath, \RecursiveDirectoryIterator::SKIP_DOTS),
  708. \RecursiveIteratorIterator::LEAVES_ONLY
  709. );
  710. foreach ($files as $file) {
  711. if ($file->isFile()) {
  712. $relativePath = $article . '/' . $file->getFilename();
  713. $zip->addFile($file->getRealPath(), $relativePath);
  714. $filesAdded++;
  715. }
  716. }
  717. }
  718. if (!$filesAdded) {
  719. $zip->addFromString('readme.txt', 'Нет документации для этих МАФ!');
  720. }
  721. $zip->close();
  722. // WebView clients are more reliable with ASCII attachment names.
  723. $archiveName = 'tech_docs_order_' . $order->id . '_' . Str::slug((string)$order->object_address) . '.zip';
  724. $archiveName = trim($archiveName, '._');
  725. if ($archiveName === '.zip' || $archiveName === 'zip' || $archiveName === '') {
  726. $archiveName = 'tech_docs_order_' . $order->id . '.zip';
  727. }
  728. return response()->download($tempFile, $archiveName, [
  729. 'Content-Type' => 'application/zip',
  730. ])->deleteFileAfterSend(true);
  731. }
  732. }