ReclamationController.php 24 KB

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