ReclamationController.php 24 KB

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