ReclamationController.php 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\Http\Requests\CreateReclamationRequest;
  4. use App\Http\Requests\StoreReclamationDetailsRequest;
  5. use App\Http\Requests\StoreReclamationRequest;
  6. use App\Http\Requests\StoreReclamationSparePartsRequest;
  7. use App\Jobs\ExportReclamationsJob;
  8. use App\Jobs\GenerateFilesPack;
  9. use App\Jobs\GenerateReclamationPaymentPack;
  10. use App\Jobs\GenerateReclamationPack;
  11. use App\Models\File;
  12. use App\Models\Order;
  13. use App\Models\Reclamation;
  14. use App\Models\ReclamationDetail;
  15. use App\Models\ReclamationStatus;
  16. use App\Models\ReclamationView;
  17. use App\Models\Role;
  18. use App\Models\User;
  19. use App\Services\FileService;
  20. use App\Services\NotificationService;
  21. use App\Services\SparePartReservationService;
  22. use Illuminate\Http\Request;
  23. use Illuminate\Support\Carbon;
  24. use Illuminate\Support\Facades\Storage;
  25. use Throwable;
  26. class ReclamationController extends Controller
  27. {
  28. protected array $data = [
  29. 'active' => 'reclamations',
  30. 'title' => 'Рекламации',
  31. 'id' => 'reclamations',
  32. 'header' => [
  33. 'id' => 'ID',
  34. 'user_name' => 'Менеджер',
  35. 'status_name' => 'Статус',
  36. 'district_name' => 'Округ',
  37. 'area_name' => 'Район',
  38. 'object_address' => 'Адрес объекта',
  39. 'maf_installation_year' => 'Год установки МАФ',
  40. 'create_date' => 'Дата создания',
  41. 'finish_date' => 'Дата завершения',
  42. 'start_work_date' => 'Дата начала работ',
  43. 'work_days' => 'Срок работ, дней',
  44. 'brigadier_name' => 'Бригадир',
  45. 'reason' => 'Причина',
  46. 'guarantee' => 'Гарантии',
  47. 'whats_done' => 'Что сделано',
  48. 'comment' => 'Комментарий',
  49. ],
  50. 'searchFields' => [
  51. 'reason',
  52. 'guarantee',
  53. 'whats_done',
  54. 'comment',
  55. ],
  56. 'ranges' => [],
  57. ];
  58. public function __construct()
  59. {
  60. $this->data['users'] = User::query()->whereIn('role', [Role::MANAGER, Role::ADMIN])->get()->pluck('name', 'id');
  61. $this->data['statuses'] = ReclamationStatus::query()->get()->pluck('name', 'id');
  62. }
  63. public function index(Request $request)
  64. {
  65. session(['gp_reclamations' => $request->all()]);
  66. $model = new ReclamationView();
  67. // fill filters
  68. $this->createFilters($model, 'user_name', 'status_name');
  69. $this->createDateFilters($model, 'create_date', 'finish_date');
  70. $q = $model::query();
  71. $this->acceptFilters($q, $request);
  72. $this->acceptSearch($q, $request);
  73. $this->setSortAndOrderBy($model, $request);
  74. if (hasRole(Role::BRIGADIER)) {
  75. $q->where('brigadier_id', auth()->id())
  76. ->whereIn('status_id', Reclamation::visibleStatusIdsForBrigadier());
  77. }
  78. $this->applyStableSorting($q);
  79. $this->data['reclamations'] = $q->paginate($this->data['per_page'])->withQueryString();
  80. return view('reclamations.index', $this->data);
  81. }
  82. public function export(Request $request)
  83. {
  84. $request->validate([
  85. 'withFilter' => 'nullable',
  86. 'filters' => 'nullable|array',
  87. 's' => 'nullable|string',
  88. ]);
  89. $filterRequest = $request->boolean('withFilter')
  90. ? new Request(array_filter([
  91. 'filters' => $request->input('filters', []),
  92. 's' => $request->input('s'),
  93. ], static fn ($value) => $value !== null))
  94. : new Request();
  95. $model = new ReclamationView();
  96. $this->createFilters($model, 'user_name', 'status_name');
  97. $this->createDateFilters($model, 'create_date', 'finish_date');
  98. $q = $model::query();
  99. $this->acceptFilters($q, $filterRequest);
  100. $this->acceptSearch($q, $filterRequest);
  101. $this->setSortAndOrderBy($model, $filterRequest);
  102. $this->applyStableSorting($q);
  103. $reclamationIds = $q->pluck('id')->toArray();
  104. ExportReclamationsJob::dispatch($reclamationIds, $request->user()->id);
  105. return redirect()->route('reclamations.index', session('gp_reclamations'))
  106. ->with(['success' => 'Задача экспорта рекламаций создана!']);
  107. }
  108. public function create(CreateReclamationRequest $request, Order $order, NotificationService $notificationService)
  109. {
  110. $reclamation = Reclamation::query()->create([
  111. 'order_id' => $order->id,
  112. 'user_id' => $request->user()->id,
  113. 'status_id' => Reclamation::STATUS_NEW,
  114. 'create_date' => Carbon::now(),
  115. 'finish_date' => Carbon::now()->addDays(30),
  116. ]);
  117. $skus = $request->validated('skus');
  118. $reclamation->skus()->attach($skus);
  119. $notificationService->notifyReclamationCreated($reclamation->fresh(['order', 'status']));
  120. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => url()->previous()]);
  121. }
  122. public function show(Request $request, Reclamation $reclamation)
  123. {
  124. $this->ensureCanViewReclamation($reclamation);
  125. $this->data['brigadiers'] = User::query()->where('role', Role::BRIGADIER)->get()->pluck('name', 'id');
  126. $this->data['reclamation'] = $reclamation;
  127. $this->data['previous_url'] = $this->resolvePreviousUrl(
  128. $request,
  129. 'previous_url_reclamations',
  130. route('reclamations.index', session('gp_reclamations'))
  131. );
  132. return view('reclamations.edit', $this->data);
  133. }
  134. public function update(StoreReclamationRequest $request, Reclamation $reclamation, NotificationService $notificationService)
  135. {
  136. $data = $request->validated();
  137. $oldStatusId = $reclamation->status_id;
  138. $reclamation->update($data);
  139. if ((int) $oldStatusId !== (int) $reclamation->status_id) {
  140. $notificationService->notifyReclamationStatusChanged($reclamation->fresh(['order', 'status']));
  141. }
  142. $previousUrl = $this->previousUrlForRedirect($request, 'previous_url_reclamations');
  143. if (!empty($previousUrl)) {
  144. return redirect()->route('reclamations.show', [
  145. 'reclamation' => $reclamation,
  146. 'previous_url' => $previousUrl,
  147. ]);
  148. }
  149. return redirect()->route('reclamations.show', $reclamation->id);
  150. }
  151. public function updateStatus(Request $request, Reclamation $reclamation, NotificationService $notificationService)
  152. {
  153. if (!hasRole('admin,manager')) {
  154. abort(403);
  155. }
  156. $validated = $request->validate([
  157. 'status_id' => 'required|exists:reclamation_statuses,id',
  158. ]);
  159. $reclamation->update(['status_id' => $validated['status_id']]);
  160. $notificationService->notifyReclamationStatusChanged($reclamation->fresh(['order', 'status']));
  161. return response()->noContent();
  162. }
  163. public function delete(Reclamation $reclamation)
  164. {
  165. $reclamation->delete();
  166. return redirect()->route('reclamations.index');
  167. }
  168. public function uploadPhotoBefore(Request $request, Reclamation $reclamation, FileService $fileService)
  169. {
  170. $this->ensureHasRole([Role::ADMIN, Role::MANAGER]);
  171. $this->ensureCanViewReclamation($reclamation);
  172. $data = $request->validate([
  173. 'photo.*' => 'mimes:jpeg,jpg,png|max:8192',
  174. ]);
  175. try {
  176. $f = [];
  177. foreach ($data['photo'] as $photo) {
  178. $f[] = $fileService->saveUploadedFile('reclamations/' . $reclamation->id . '/photo_before', $photo);
  179. }
  180. $reclamation->photos_before()->syncWithoutDetaching($f);
  181. } catch (Throwable $e) {
  182. report($e);
  183. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')])
  184. ->with(['error' => 'Ошибка загрузки фотографий проблемы. Проверьте имя файла и повторите попытку.']);
  185. }
  186. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')])
  187. ->with(['success' => 'Фотографии проблемы успешно загружены!']);
  188. }
  189. public function uploadPhotoAfter(Request $request, Reclamation $reclamation, FileService $fileService)
  190. {
  191. $this->ensureCanViewReclamation($reclamation);
  192. $data = $request->validate([
  193. 'photo.*' => 'mimes:jpeg,jpg,png|max:8192',
  194. ]);
  195. try {
  196. $f = [];
  197. foreach ($data['photo'] as $photo) {
  198. $f[] = $fileService->saveUploadedFile('reclamations/' . $reclamation->id . '/photo_after', $photo);
  199. }
  200. $reclamation->photos_after()->syncWithoutDetaching($f);
  201. } catch (Throwable $e) {
  202. report($e);
  203. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')])
  204. ->with(['error' => 'Ошибка загрузки фотографий после устранения. Проверьте имя файла и повторите попытку.']);
  205. }
  206. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')])
  207. ->with(['success' => 'Фотографии после устранения успешно загружены!']);
  208. }
  209. public function deletePhotoBefore(Request $request, Reclamation $reclamation, File $file, FileService $fileService)
  210. {
  211. $this->ensureHasRole([Role::ADMIN, Role::MANAGER]);
  212. $this->ensureCanViewReclamation($reclamation);
  213. $reclamation->photos_before()->detach($file);
  214. Storage::disk('public')->delete($file->path);
  215. $file->delete();
  216. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')]);
  217. }
  218. public function deletePhotoAfter(Request $request, Reclamation $reclamation, File $file, FileService $fileService)
  219. {
  220. $this->ensureHasRole([Role::ADMIN, Role::MANAGER]);
  221. $this->ensureCanViewReclamation($reclamation);
  222. $reclamation->photos_after()->detach($file);
  223. Storage::disk('public')->delete($file->path);
  224. $file->delete();
  225. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')]);
  226. }
  227. public function uploadDocument(Request $request, Reclamation $reclamation, FileService $fileService)
  228. {
  229. $this->ensureHasRole([Role::ADMIN, Role::MANAGER]);
  230. $this->ensureCanViewReclamation($reclamation);
  231. $data = $request->validate([
  232. 'document.*' => 'file',
  233. ]);
  234. try {
  235. $f = [];
  236. $i = 0;
  237. foreach ($data['document'] as $document) {
  238. if ($i++ >= 5) break;
  239. $f[] = $fileService->saveUploadedFile('reclamations/' . $reclamation->id . '/document', $document);
  240. }
  241. $reclamation->documents()->syncWithoutDetaching($f);
  242. } catch (Throwable $e) {
  243. report($e);
  244. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')])
  245. ->with(['error' => 'Ошибка загрузки документов рекламации. Проверьте имя файла и повторите попытку.']);
  246. }
  247. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')])
  248. ->with(['success' => 'Документы рекламации успешно загружены!']);
  249. }
  250. public function deleteDocument(Request $request, Reclamation $reclamation, File $file)
  251. {
  252. $this->ensureHasRole([Role::ADMIN, Role::MANAGER]);
  253. $this->ensureCanViewReclamation($reclamation);
  254. $reclamation->documents()->detach($file);
  255. Storage::disk('public')->delete($file->path);
  256. $file->delete();
  257. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')]);
  258. }
  259. public function uploadAct(Request $request, Reclamation $reclamation, FileService $fileService)
  260. {
  261. $this->ensureHasRole([Role::ADMIN, Role::MANAGER, Role::BRIGADIER, Role::WAREHOUSE_HEAD]);
  262. $this->ensureCanViewReclamation($reclamation);
  263. $data = $request->validate([
  264. 'acts.*' => 'file',
  265. ]);
  266. try {
  267. $f = [];
  268. $i = 0;
  269. foreach ($data['acts'] as $document) {
  270. if ($i++ >= 5) break;
  271. $f[] = $fileService->saveUploadedFile('reclamations/' . $reclamation->id . '/act', $document);
  272. }
  273. $reclamation->acts()->syncWithoutDetaching($f);
  274. } catch (Throwable $e) {
  275. report($e);
  276. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')])
  277. ->with(['error' => 'Ошибка загрузки актов. Проверьте имя файла и повторите попытку.']);
  278. }
  279. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')])
  280. ->with(['success' => 'Акты успешно загружены!']);
  281. }
  282. public function deleteAct(Request $request, Reclamation $reclamation, File $file)
  283. {
  284. $this->ensureHasRole([Role::ADMIN, Role::MANAGER]);
  285. $this->ensureCanViewReclamation($reclamation);
  286. $reclamation->acts()->detach($file);
  287. Storage::disk('public')->delete($file->path);
  288. $file->delete();
  289. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')]);
  290. }
  291. public function updateDetails(StoreReclamationDetailsRequest $request, Reclamation $reclamation)
  292. {
  293. $names = $request->validated('name');
  294. $quantity = $request->validated('quantity');
  295. $withDocuments = $request->validated('with_documents');
  296. $reservationService = app(SparePartReservationService::class);
  297. foreach ($names as $key => $name) {
  298. if (!$name) continue;
  299. if ((int)$quantity[$key] >= 1) {
  300. // Проверяем, является ли это запчастью
  301. $sparePart = \App\Models\SparePart::where('article', $name)->first();
  302. if ($sparePart) {
  303. // Резервирование вместо прямого списания
  304. $withDocs = isset($withDocuments[$key]) && $withDocuments[$key];
  305. $qty = (int)$quantity[$key];
  306. // Получаем текущее количество в pivot
  307. $currentPivot = $reclamation->spareParts()->find($sparePart->id);
  308. $currentQty = $currentPivot?->pivot->quantity ?? 0;
  309. $diff = $qty - $currentQty;
  310. if ($diff > 0) {
  311. // Нужно зарезервировать дополнительное количество
  312. $result = $reservationService->reserve(
  313. $sparePart->id,
  314. $diff,
  315. $withDocs,
  316. $reclamation->id
  317. );
  318. // Обновляем pivot с учётом результата
  319. $reclamation->spareParts()->syncWithoutDetaching([
  320. $sparePart->id => [
  321. 'quantity' => $qty,
  322. 'with_documents' => $withDocs,
  323. 'status' => $result->isFullyReserved() ? 'reserved' : 'pending',
  324. 'reserved_qty' => $currentQty + $result->reserved,
  325. ]
  326. ]);
  327. } elseif ($diff < 0) {
  328. // Уменьшение — отменяем часть резерва
  329. $reservationService->adjustReservation(
  330. $reclamation->id,
  331. $sparePart->id,
  332. $withDocs,
  333. $qty
  334. );
  335. $reclamation->spareParts()->syncWithoutDetaching([
  336. $sparePart->id => [
  337. 'quantity' => $qty,
  338. 'with_documents' => $withDocs,
  339. 'reserved_qty' => $qty,
  340. ]
  341. ]);
  342. } else {
  343. // Количество не изменилось, возможно изменился with_documents
  344. $reclamation->spareParts()->syncWithoutDetaching([
  345. $sparePart->id => [
  346. 'quantity' => $qty,
  347. 'with_documents' => $withDocs,
  348. ]
  349. ]);
  350. }
  351. } else {
  352. // Обычная деталь
  353. ReclamationDetail::query()->updateOrCreate(
  354. ['reclamation_id' => $reclamation->id, 'name' => $name],
  355. ['quantity' => $quantity[$key]]
  356. );
  357. }
  358. } else {
  359. // Удаление
  360. // Проверяем, является ли это запчастью — отменяем резервы
  361. $sparePartToRemove = \App\Models\SparePart::where('article', $name)->first();
  362. if ($sparePartToRemove) {
  363. // Отменяем все резервы для этой запчасти в рекламации
  364. $reservationService->cancelForReclamation(
  365. $reclamation->id,
  366. $sparePartToRemove->id
  367. );
  368. // Удаляем связь
  369. $reclamation->spareParts()->detach($sparePartToRemove->id);
  370. } else {
  371. // Обычная деталь
  372. ReclamationDetail::query()
  373. ->where('reclamation_id', $reclamation->id)
  374. ->where('name', $name)
  375. ->delete();
  376. }
  377. }
  378. }
  379. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')]);
  380. }
  381. public function updateSpareParts(StoreReclamationSparePartsRequest $request, Reclamation $reclamation)
  382. {
  383. $rows = $request->validated('rows') ?? [];
  384. $reservationService = app(SparePartReservationService::class);
  385. // Получаем текущие привязки для сравнения
  386. $currentSpareParts = $reclamation->spareParts->keyBy('id');
  387. // Определяем какие запчасти были удалены
  388. $newSparePartIds = collect($rows)->pluck('spare_part_id')->filter()->toArray();
  389. $removedIds = $currentSpareParts->keys()->diff($newSparePartIds);
  390. // Отменяем резервы для удалённых запчастей
  391. foreach ($removedIds as $removedId) {
  392. $current = $currentSpareParts->get($removedId);
  393. if ($current) {
  394. $reservationService->cancelForReclamation(
  395. $reclamation->id,
  396. $removedId,
  397. $current->pivot->with_documents
  398. );
  399. }
  400. }
  401. // Собираем новые привязки
  402. $newSpareParts = [];
  403. foreach ($rows as $row) {
  404. $sparePartId = $row['spare_part_id'] ?? null;
  405. if (empty($sparePartId)) continue;
  406. $quantity = (int)($row['quantity'] ?? 0);
  407. if ($quantity < 1) continue;
  408. $withDocs = !empty($row['with_documents']) && $row['with_documents'] != '0';
  409. // Проверяем, изменилось ли количество
  410. $currentQty = $currentSpareParts->get($sparePartId)?->pivot->quantity ?? 0;
  411. $currentReserved = $currentSpareParts->get($sparePartId)?->pivot->reserved_qty ?? 0;
  412. $diff = $quantity - $currentQty;
  413. $status = 'pending';
  414. $reservedQty = $currentReserved;
  415. if ($diff > 0) {
  416. // Нужно зарезервировать дополнительное количество
  417. $result = $reservationService->reserve(
  418. $sparePartId,
  419. $diff,
  420. $withDocs,
  421. $reclamation->id
  422. );
  423. $reservedQty = $currentReserved + $result->reserved;
  424. $status = $reservedQty >= $quantity ? 'reserved' : 'pending';
  425. } elseif ($diff < 0) {
  426. // Уменьшение — отменяем часть резерва
  427. $reservationService->adjustReservation(
  428. $reclamation->id,
  429. $sparePartId,
  430. $withDocs,
  431. $quantity
  432. );
  433. $reservedQty = $quantity;
  434. $status = 'reserved';
  435. } else {
  436. // Количество не изменилось
  437. $status = $currentReserved >= $quantity ? 'reserved' : 'pending';
  438. }
  439. $newSpareParts[$sparePartId] = [
  440. 'quantity' => $quantity,
  441. 'with_documents' => $withDocs,
  442. 'status' => $status,
  443. 'reserved_qty' => $reservedQty,
  444. ];
  445. }
  446. // Синхронизируем (заменяем все старые привязки новыми)
  447. $reclamation->spareParts()->sync($newSpareParts);
  448. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')]);
  449. }
  450. public function generateReclamationPack(Request $request, Reclamation $reclamation)
  451. {
  452. GenerateReclamationPack::dispatch($reclamation, auth()->user()->id);
  453. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')])
  454. ->with(['success' => 'Задача генерации документов создана!']);
  455. }
  456. public function generateReclamationPaymentPack(Request $request, Reclamation $reclamation)
  457. {
  458. GenerateReclamationPaymentPack::dispatch($reclamation, auth()->user()->id);
  459. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')])
  460. ->with(['success' => 'Задача генерации пакета документов на оплату создана!']);
  461. }
  462. public function generatePhotosBeforePack(Request $request, Reclamation $reclamation)
  463. {
  464. GenerateFilesPack::dispatch($reclamation, $reclamation->photos_before, auth()->user()->id, 'Фото проблемы');
  465. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')])
  466. ->with(['success' => 'Задача архивации создана!']);
  467. }
  468. public function generatePhotosAfterPack(Request $request, Reclamation $reclamation)
  469. {
  470. GenerateFilesPack::dispatch($reclamation, $reclamation->photos_after, auth()->user()->id, 'Фото после');
  471. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')])
  472. ->with(['success' => 'Задача архивации создана!']);
  473. }
  474. private function ensureCanViewReclamation(Reclamation $reclamation): void
  475. {
  476. if (hasRole(Role::BRIGADIER)) {
  477. $canView = (int)$reclamation->brigadier_id === (int)auth()->id()
  478. && in_array((int)$reclamation->status_id, Reclamation::visibleStatusIdsForBrigadier(), true);
  479. if (!$canView) {
  480. abort(403);
  481. }
  482. }
  483. }
  484. private function ensureHasRole(array $roles): void
  485. {
  486. if (!count(array_intersect($roles, Role::effectiveRoles((string)auth()->user()?->role)))) {
  487. abort(403);
  488. }
  489. }
  490. }