ReclamationController.php 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432
  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\GenerateFilesPack;
  8. use App\Jobs\GenerateReclamationPack;
  9. use App\Models\File;
  10. use App\Models\Order;
  11. use App\Models\Reclamation;
  12. use App\Models\ReclamationDetail;
  13. use App\Models\ReclamationStatus;
  14. use App\Models\ReclamationView;
  15. use App\Models\Role;
  16. use App\Models\User;
  17. use App\Services\FileService;
  18. use App\Services\SparePartReservationService;
  19. use Illuminate\Http\Request;
  20. use Illuminate\Support\Carbon;
  21. use Illuminate\Support\Facades\Storage;
  22. class ReclamationController extends Controller
  23. {
  24. protected array $data = [
  25. 'active' => 'reclamations',
  26. 'title' => 'Рекламации',
  27. 'id' => 'reclamations',
  28. 'header' => [
  29. 'id' => 'ID',
  30. 'user_name' => 'Менеджер',
  31. 'status_name' => 'Статус',
  32. 'district_name' => 'Округ',
  33. 'area_name' => 'Район',
  34. 'object_address' => 'Адрес объекта',
  35. 'maf_installation_year' => 'Год установки МАФ',
  36. 'create_date' => 'Дата создания',
  37. 'finish_date' => 'Дата завершения',
  38. 'start_work_date' => 'Дата начала работ',
  39. 'work_days' => 'Срок работ, дней',
  40. 'brigadier_name' => 'Бригадир',
  41. 'reason' => 'Причина',
  42. 'guarantee' => 'Гарантии',
  43. 'whats_done' => 'Что сделано',
  44. 'comment' => 'Комментарий',
  45. ],
  46. 'searchFields' => [
  47. 'reason',
  48. 'guarantee',
  49. 'whats_done',
  50. 'comment',
  51. ],
  52. 'ranges' => [],
  53. ];
  54. public function __construct()
  55. {
  56. $this->data['users'] = User::query()->whereIn('role', [Role::MANAGER, Role::ADMIN])->get()->pluck('name', 'id');
  57. $this->data['statuses'] = ReclamationStatus::query()->get()->pluck('name', 'id');
  58. }
  59. public function index(Request $request)
  60. {
  61. session(['gp_reclamations' => $request->all()]);
  62. $model = new ReclamationView();
  63. // fill filters
  64. $this->createFilters($model, 'user_name', 'status_name');
  65. $this->createDateFilters($model, 'create_date', 'finish_date');
  66. $q = $model::query();
  67. $this->acceptFilters($q, $request);
  68. $this->acceptSearch($q, $request);
  69. $this->setSortAndOrderBy($model, $request);
  70. $q->orderBy($this->data['sortBy'], $this->data['orderBy']);
  71. $this->data['reclamations'] = $q->paginate(session('per_page', config('pagination.per_page')))->withQueryString();
  72. return view('reclamations.index', $this->data);
  73. }
  74. public function create(CreateReclamationRequest $request, Order $order)
  75. {
  76. $reclamation = Reclamation::query()->create([
  77. 'order_id' => $order->id,
  78. 'user_id' => $request->user()->id,
  79. 'status_id' => Reclamation::STATUS_NEW,
  80. 'create_date' => Carbon::now(),
  81. 'finish_date' => Carbon::now()->addDays(30),
  82. ]);
  83. $skus = $request->validated('skus');
  84. $reclamation->skus()->attach($skus);
  85. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => url()->previous()]);
  86. }
  87. public function show(Request $request, Reclamation $reclamation)
  88. {
  89. $this->data['brigadiers'] = User::query()->where('role', Role::BRIGADIER)->get()->pluck('name', 'id');
  90. $this->data['reclamation'] = $reclamation;
  91. $this->data['previous_url'] = $request->get('previous_url');
  92. return view('reclamations.edit', $this->data);
  93. }
  94. public function update(StoreReclamationRequest $request, Reclamation $reclamation)
  95. {
  96. $data = $request->validated();
  97. $reclamation->update($data);
  98. return redirect()->route('reclamations.show', $reclamation->id);
  99. }
  100. public function updateStatus(Request $request, Reclamation $reclamation)
  101. {
  102. if (!hasRole('admin,manager')) {
  103. abort(403);
  104. }
  105. $validated = $request->validate([
  106. 'status_id' => 'required|exists:reclamation_statuses,id',
  107. ]);
  108. $reclamation->update(['status_id' => $validated['status_id']]);
  109. return response()->noContent();
  110. }
  111. public function delete(Reclamation $reclamation)
  112. {
  113. $reclamation->delete();
  114. return redirect()->route('reclamations.index');
  115. }
  116. public function uploadPhotoBefore(Request $request, Reclamation $reclamation, FileService $fileService)
  117. {
  118. $data = $request->validate([
  119. 'photo.*' => 'mimes:jpeg,jpg,png|max:8192',
  120. ]);
  121. $f = [];
  122. foreach ($data['photo'] as $photo) {
  123. $f[] = $fileService->saveUploadedFile('reclamations/' . $reclamation->id . '/photo_before', $photo);
  124. }
  125. $reclamation->photos_before()->syncWithoutDetaching($f);
  126. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')]);
  127. }
  128. public function uploadPhotoAfter(Request $request, Reclamation $reclamation, FileService $fileService)
  129. {
  130. $data = $request->validate([
  131. 'photo.*' => 'mimes:jpeg,jpg,png|max:8192',
  132. ]);
  133. $f = [];
  134. foreach ($data['photo'] as $photo) {
  135. $f[] = $fileService->saveUploadedFile('reclamations/' . $reclamation->id . '/photo_after', $photo);
  136. }
  137. $reclamation->photos_after()->syncWithoutDetaching($f);
  138. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')]);
  139. }
  140. public function deletePhotoBefore(Request $request, Reclamation $reclamation, File $file, FileService $fileService)
  141. {
  142. $reclamation->photos_before()->detach($file);
  143. Storage::disk('public')->delete($file->path);
  144. $file->delete();
  145. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')]);
  146. }
  147. public function deletePhotoAfter(Request $request, Reclamation $reclamation, File $file, FileService $fileService)
  148. {
  149. $reclamation->photos_after()->detach($file);
  150. Storage::disk('public')->delete($file->path);
  151. $file->delete();
  152. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')]);
  153. }
  154. public function uploadDocument(Request $request, Reclamation $reclamation, FileService $fileService)
  155. {
  156. $data = $request->validate([
  157. 'document.*' => 'file',
  158. ]);
  159. $f = [];
  160. $i = 0;
  161. foreach ($data['document'] as $document) {
  162. if($i++ >= 5) break;
  163. $f[] = $fileService->saveUploadedFile('reclamations/' . $reclamation->id . '/document', $document);
  164. }
  165. $reclamation->documents()->syncWithoutDetaching($f);
  166. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')]);
  167. }
  168. public function deleteDocument(Request $request, Reclamation $reclamation, File $file)
  169. {
  170. $reclamation->documents()->detach($file);
  171. Storage::disk('public')->delete($file->path);
  172. $file->delete();
  173. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')]);
  174. }
  175. public function uploadAct(Request $request, Reclamation $reclamation, FileService $fileService)
  176. {
  177. $data = $request->validate([
  178. 'acts.*' => 'file',
  179. ]);
  180. $f = [];
  181. $i = 0;
  182. foreach ($data['acts'] as $document) {
  183. if($i++ >= 5) break;
  184. $f[] = $fileService->saveUploadedFile('reclamations/' . $reclamation->id . '/act', $document);
  185. }
  186. $reclamation->acts()->syncWithoutDetaching($f);
  187. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')]);
  188. }
  189. public function deleteAct(Request $request, Reclamation $reclamation, File $file)
  190. {
  191. $reclamation->acts()->detach($file);
  192. Storage::disk('public')->delete($file->path);
  193. $file->delete();
  194. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')]);
  195. }
  196. public function updateDetails(StoreReclamationDetailsRequest $request, Reclamation $reclamation)
  197. {
  198. $names = $request->validated('name');
  199. $quantity = $request->validated('quantity');
  200. $withDocuments = $request->validated('with_documents');
  201. $reservationService = app(SparePartReservationService::class);
  202. foreach ($names as $key => $name) {
  203. if (!$name) continue;
  204. if ((int)$quantity[$key] >= 1) {
  205. // Проверяем, является ли это запчастью
  206. $sparePart = \App\Models\SparePart::where('article', $name)->first();
  207. if ($sparePart) {
  208. // Резервирование вместо прямого списания
  209. $withDocs = isset($withDocuments[$key]) && $withDocuments[$key];
  210. $qty = (int)$quantity[$key];
  211. // Получаем текущее количество в pivot
  212. $currentPivot = $reclamation->spareParts()->find($sparePart->id);
  213. $currentQty = $currentPivot?->pivot->quantity ?? 0;
  214. $diff = $qty - $currentQty;
  215. if ($diff > 0) {
  216. // Нужно зарезервировать дополнительное количество
  217. $result = $reservationService->reserve(
  218. $sparePart->id,
  219. $diff,
  220. $withDocs,
  221. $reclamation->id
  222. );
  223. // Обновляем pivot с учётом результата
  224. $reclamation->spareParts()->syncWithoutDetaching([
  225. $sparePart->id => [
  226. 'quantity' => $qty,
  227. 'with_documents' => $withDocs,
  228. 'status' => $result->isFullyReserved() ? 'reserved' : 'pending',
  229. 'reserved_qty' => $currentQty + $result->reserved,
  230. ]
  231. ]);
  232. } elseif ($diff < 0) {
  233. // Уменьшение — отменяем часть резерва
  234. $reservationService->adjustReservation(
  235. $reclamation->id,
  236. $sparePart->id,
  237. $withDocs,
  238. $qty
  239. );
  240. $reclamation->spareParts()->syncWithoutDetaching([
  241. $sparePart->id => [
  242. 'quantity' => $qty,
  243. 'with_documents' => $withDocs,
  244. 'reserved_qty' => $qty,
  245. ]
  246. ]);
  247. } else {
  248. // Количество не изменилось, возможно изменился with_documents
  249. $reclamation->spareParts()->syncWithoutDetaching([
  250. $sparePart->id => [
  251. 'quantity' => $qty,
  252. 'with_documents' => $withDocs,
  253. ]
  254. ]);
  255. }
  256. } else {
  257. // Обычная деталь
  258. ReclamationDetail::query()->updateOrCreate(
  259. ['reclamation_id' => $reclamation->id, 'name' => $name],
  260. ['quantity' => $quantity[$key]]
  261. );
  262. }
  263. } else {
  264. // Удаление
  265. // Проверяем, является ли это запчастью — отменяем резервы
  266. $sparePartToRemove = \App\Models\SparePart::where('article', $name)->first();
  267. if ($sparePartToRemove) {
  268. // Отменяем все резервы для этой запчасти в рекламации
  269. $reservationService->cancelForReclamation(
  270. $reclamation->id,
  271. $sparePartToRemove->id
  272. );
  273. // Удаляем связь
  274. $reclamation->spareParts()->detach($sparePartToRemove->id);
  275. } else {
  276. // Обычная деталь
  277. ReclamationDetail::query()
  278. ->where('reclamation_id', $reclamation->id)
  279. ->where('name', $name)
  280. ->delete();
  281. }
  282. }
  283. }
  284. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')]);
  285. }
  286. public function updateSpareParts(StoreReclamationSparePartsRequest $request, Reclamation $reclamation)
  287. {
  288. $rows = $request->validated('rows') ?? [];
  289. $reservationService = app(SparePartReservationService::class);
  290. // Получаем текущие привязки для сравнения
  291. $currentSpareParts = $reclamation->spareParts->keyBy('id');
  292. // Определяем какие запчасти были удалены
  293. $newSparePartIds = collect($rows)->pluck('spare_part_id')->filter()->toArray();
  294. $removedIds = $currentSpareParts->keys()->diff($newSparePartIds);
  295. // Отменяем резервы для удалённых запчастей
  296. foreach ($removedIds as $removedId) {
  297. $current = $currentSpareParts->get($removedId);
  298. if ($current) {
  299. $reservationService->cancelForReclamation(
  300. $reclamation->id,
  301. $removedId,
  302. $current->pivot->with_documents
  303. );
  304. }
  305. }
  306. // Собираем новые привязки
  307. $newSpareParts = [];
  308. foreach ($rows as $row) {
  309. $sparePartId = $row['spare_part_id'] ?? null;
  310. if (empty($sparePartId)) continue;
  311. $quantity = (int)($row['quantity'] ?? 0);
  312. if ($quantity < 1) continue;
  313. $withDocs = !empty($row['with_documents']) && $row['with_documents'] != '0';
  314. // Проверяем, изменилось ли количество
  315. $currentQty = $currentSpareParts->get($sparePartId)?->pivot->quantity ?? 0;
  316. $currentReserved = $currentSpareParts->get($sparePartId)?->pivot->reserved_qty ?? 0;
  317. $diff = $quantity - $currentQty;
  318. $status = 'pending';
  319. $reservedQty = $currentReserved;
  320. if ($diff > 0) {
  321. // Нужно зарезервировать дополнительное количество
  322. $result = $reservationService->reserve(
  323. $sparePartId,
  324. $diff,
  325. $withDocs,
  326. $reclamation->id
  327. );
  328. $reservedQty = $currentReserved + $result->reserved;
  329. $status = $reservedQty >= $quantity ? 'reserved' : 'pending';
  330. } elseif ($diff < 0) {
  331. // Уменьшение — отменяем часть резерва
  332. $reservationService->adjustReservation(
  333. $reclamation->id,
  334. $sparePartId,
  335. $withDocs,
  336. $quantity
  337. );
  338. $reservedQty = $quantity;
  339. $status = 'reserved';
  340. } else {
  341. // Количество не изменилось
  342. $status = $currentReserved >= $quantity ? 'reserved' : 'pending';
  343. }
  344. $newSpareParts[$sparePartId] = [
  345. 'quantity' => $quantity,
  346. 'with_documents' => $withDocs,
  347. 'status' => $status,
  348. 'reserved_qty' => $reservedQty,
  349. ];
  350. }
  351. // Синхронизируем (заменяем все старые привязки новыми)
  352. $reclamation->spareParts()->sync($newSpareParts);
  353. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')]);
  354. }
  355. public function generateReclamationPack(Request $request, Reclamation $reclamation)
  356. {
  357. GenerateReclamationPack::dispatch($reclamation, auth()->user()->id);
  358. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')])
  359. ->with(['success' => 'Задача генерации документов создана!']);
  360. }
  361. public function generatePhotosBeforePack(Request $request, Reclamation $reclamation)
  362. {
  363. GenerateFilesPack::dispatch($reclamation, $reclamation->photos_before, auth()->user()->id, 'Фото проблемы');
  364. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')])
  365. ->with(['success' => 'Задача архивации создана!']);
  366. }
  367. public function generatePhotosAfterPack(Request $request, Reclamation $reclamation)
  368. {
  369. GenerateFilesPack::dispatch($reclamation, $reclamation->photos_after, auth()->user()->id, 'Фото после');
  370. return redirect()->route('reclamations.show', ['reclamation' => $reclamation, 'previous_url' => $request->get('previous_url')])
  371. ->with(['success' => 'Задача архивации создана!']); }
  372. }