src/Controller/ComponentInventoryController.php line 136

  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\ComponentInventoryItem;
  6. use App\Form\Type\ComponentInventory\BatchSetQuantityType;
  7. use App\Form\Type\ComponentInventory\BatchDecreaseQuantityType;
  8. use App\Form\Type\ComponentInventory\BatchIncreaseQuantityType;
  9. use App\Form\Type\ComponentInventory\DecreaseQuantityType;
  10. use App\Form\Type\ComponentInventory\IncreaseQuantityType;
  11. use App\Form\Type\ComponentInventory\ItemCreateType;
  12. use App\Form\Type\ComponentInventory\ItemUpdateType;
  13. use App\Form\Type\ComponentInventory\LogFilterType;
  14. use App\Model\ComponentInventory\BatchSetQuantity;
  15. use App\Model\ComponentInventory\BatchDecreaseQuantity;
  16. use App\Model\ComponentInventory\BatchIncreaseQuantity;
  17. use App\Model\ComponentInventory\DecreaseQuantity;
  18. use App\Model\ComponentInventory\IncreaseQuantity;
  19. use App\Model\ComponentInventory\ItemCreate;
  20. use App\Model\ComponentInventory\ItemUpdate;
  21. use App\Model\DateRange;
  22. use App\Model\ModalResponse;
  23. use App\Repository\ComponentInventoryItemRepository;
  24. use App\Repository\ComponentInventoryLogEntryRepository;
  25. use App\Service\ComponentInventoryService;
  26. use Exception;
  27. use Symfony\Component\HttpFoundation\File\UploadedFile;
  28. use Symfony\Component\HttpFoundation\Request;
  29. use Symfony\Component\HttpFoundation\Response;
  30. use Symfony\Component\Routing\Annotation\Route;
  32. #[Route('/component-inventory')]
  33. class ComponentInventoryController extends AbstractController
  34. {
  35. const BATCH_DECREASE_DATA_KEY = 'batchDecreaseData';
  36. const BATCH_INCREASE_DATA_KEY = 'batchIncreaseData';
  37. const BATCH_SET_DATA_KEY = 'batchSetData';
  38. const HIDE_ZERO_QUANTITY_KEY = 'hideZeroQuantity';
  40. protected ComponentInventoryItemRepository $componentInventoryItemRepository;
  42. protected ComponentInventoryLogEntryRepository $componentInventoryLogEntryRepository;
  44. protected ComponentInventoryService $componentInventoryService;
  46. public function __construct(
  47. ComponentInventoryItemRepository $componentInventoryItemRepository,
  48. ComponentInventoryLogEntryRepository $componentInventoryLogEntryRepository,
  49. ComponentInventoryService $componentInventoryService
  50. ) {
  51. $this->componentInventoryItemRepository = $componentInventoryItemRepository;
  52. $this->componentInventoryLogEntryRepository = $componentInventoryLogEntryRepository;
  53. $this->componentInventoryService = $componentInventoryService;
  54. }
  56. #[Route(
  57. '/{item}/delete',
  58. name: 'app.component_inventory.delete',
  59. requirements: ['item' => '\d+'],
  60. methods: ['GET']
  61. )]
  62. public function deleteAction(ComponentInventoryItem $item): Response
  63. {
  64. $this->assertAdmin();
  66. try {
  67. $this->componentInventoryItemRepository->delete($item);
  68. $this->flashSuccess('ui.success.delete', [], 'ComponentInventoryItem');
  69. } catch (Exception $e) {
  70. $this->flashError('ui.error.delete', [], 'ComponentInventoryItem');
  71. if ($this->getCurrentUser()->isSuperAdmin()) {
  72. $this->flashError($e->getMessage());
  73. }
  74. }
  76. return $this->redirectResponse('app.component_inventory.index');
  77. }
  79. #[Route(
  80. '/excel',
  81. name: 'app.component_inventory.excel'
  82. )]
  83. public function excelAction(): Response
  84. {
  85. try {
  86. return $this->componentInventoryService->getInventoryExcelFile()->getResponse();
  87. } catch (Exception $e) {
  88. $this->flashError($e->getMessage());
  89. $this->flashError($e->getPrevious()->getMessage());
  91. return $this->redirectResponse('app.component_inventory.index');
  92. }
  93. }
  95. #[Route(
  96. '/',
  97. name: 'app.component_inventory.index'
  98. )]
  99. public function indexAction(Request $request): Response
  100. {
  101. return $this->render(
  102. 'ComponentInventory/index.html.twig',
  103. [
  104. 'items' => $this->componentInventoryItemRepository->findAll(),
  105. 'hideZeroQuantity' => $request->getSession()->get(self::HIDE_ZERO_QUANTITY_KEY, true),
  106. ]
  107. );
  108. }
  110. #[Route(
  111. '/toggle-hide-zero-quantity',
  112. name: 'app.component_inventory.index.toggle_hide_zero_quantity'
  113. )]
  114. public function indexToggleHideZeroQuantityAction(Request $request): Response
  115. {
  116. $request->getSession()->set(
  117. self::HIDE_ZERO_QUANTITY_KEY,
  118. !$request->getSession()->get(self::HIDE_ZERO_QUANTITY_KEY, true)
  119. );
  120. return $this->redirectResponse('app.component_inventory.index');
  121. }
  123. #[Route(
  124. '/{item}/log',
  125. name: 'app.component_inventory.item_log',
  126. requirements: ['item' => '\d+']
  127. )]
  128. public function itemLogAction(ComponentInventoryItem $item): Response
  129. {
  130. return $this->render(
  131. 'ComponentInventory/itemLog.html.twig',
  132. [
  133. 'item' => $item,
  134. ]
  135. );
  136. }
  138. #[Route(
  139. '/log',
  140. name: 'app.component_inventory.log'
  141. )]
  142. public function logAction(Request $request): Response
  143. {
  144. $form = $this->createForm(
  145. LogFilterType::class,
  146. null,
  147. [
  148. 'action' => $this->generateUrl('app.component_inventory.log'),
  149. ]
  150. );
  152. $period = null;
  153. $showZeroQuantity = false;
  154. $form->handleRequest($request);
  155. if ($form->isSubmitted()) {
  156. if ($form->isValid()) {
  157. /* @var DateRange $period */
  158. $period = $form->get('period')->getData();
  159. $showZeroQuantity = $form->get('showZeroQuantity')->getData();
  160. try {
  161. if ($form->get('excel')->isClicked()) {
  162. return $this->componentInventoryService->getEventLogExcelFile(
  163. $period, $showZeroQuantity
  164. )->getResponse();
  165. }
  166. } catch (Exception $e) {
  167. $this->flashError($e->getMessage());
  168. if (null !== $previous = $e->getPrevious()) {
  169. $this->flashError($previous->getMessage());
  170. }
  171. }
  172. }
  173. }
  175. return $this->render(
  176. 'ComponentInventory/log.html.twig',
  177. [
  178. 'logEntries' => $this->componentInventoryLogEntryRepository->findByCreated($period, $showZeroQuantity),
  179. 'form' => $form->createView(),
  180. ]
  181. );
  182. }
  184. #[Route(
  185. '/log/excel',
  186. name: 'app.component_inventory.log.excel'
  187. )]
  188. public function logExcelAction(): Response
  189. {
  190. try {
  191. return $this->componentInventoryService->getEventLogExcelFile()->getResponse();
  192. } catch (Exception $e) {
  193. $this->flashError($e->getMessage());
  194. $this->flashError($e->getPrevious()->getMessage());
  196. return $this->redirectResponse('app.component_inventory.index');
  197. }
  198. }
  200. #[Route(
  201. '/batch-decrease-quantity',
  202. name: 'app.component_inventory.batch_decrease_quantity.modal'
  203. )]
  204. public function modalBatchDecreaseQuantityAction(Request $request): ModalResponse
  205. {
  206. $response = new ModalResponse();
  207. $response->setSubmit(true);
  208. $response->setTitle(
  209. $this->trans('ui.batchDecreaseQuantity', [], 'ComponentInventoryItem')
  210. );
  211. $form = $this->createForm(
  212. BatchDecreaseQuantityType::class,
  213. null,
  214. [
  215. 'action' => $this->generateUrl(
  216. 'app.component_inventory.batch_decrease_quantity.modal'
  217. )
  218. ]
  219. );
  220. $form->handleRequest($request);
  221. if ($form->isSubmitted()) {
  222. if ($form->isValid()) {
  223. try {
  224. /* @var BatchDecreaseQuantity $data */
  225. $data = $form->getData();
  226. $import = $request->getSession()->get(self::BATCH_DECREASE_DATA_KEY);
  227. foreach ($import['items'] as $item) {
  228. if (null !== $obj = $this->componentInventoryItemRepository->findByCode($item['code'])) {
  229. $data->updateItem($obj, $item['quantity'], $import['file']);
  230. $this->componentInventoryItemRepository->save($obj);
  231. }
  232. }
  233. $response->setRedirect(
  234. $this->generateUrl('app.component_inventory.index')
  235. );
  236. } catch (Exception $e) {
  237. $response->setError($e->getMessage());
  238. }
  239. }
  240. }
  241. $response->setBody(
  242. $this->renderView(
  243. 'ComponentInventory/batchDecreaseQuantityForm.html.twig',
  244. [
  245. 'form' => $form->createView(),
  246. ]
  247. )
  248. );
  250. return $response;
  251. }
  253. #[Route(
  254. '/batch-decrease-quantity/preview',
  255. name: 'app.component_inventory.batch_decrease_quantity.preview'
  256. )]
  257. public function modalBatchDecreaseQuantityPreviewAction(Request $request): Response
  258. {
  259. /* @var UploadedFile $file */
  260. $file = $request->files->get('excel');
  262. try {
  263. $fileName = $file->getClientOriginalName();
  264. $items = $this->componentInventoryService->parseBatchDecreaseExcel($file);
  265. $hasErrors = false;
  266. foreach ($items as $item) {
  267. if (null !== $item['error']) {
  268. $hasErrors = true;
  269. break;
  270. }
  271. }
  272. $request->getSession()->remove(self::BATCH_DECREASE_DATA_KEY);
  273. if (!$hasErrors) {
  274. $data = [
  275. 'items' => $items,
  276. 'file' => $fileName,
  277. ];
  278. $request->getSession()->set(self::BATCH_DECREASE_DATA_KEY, $data);
  279. }
  281. return $this->render(
  282. 'ComponentInventory/batchDecreaseQuantityPreview.html.twig',
  283. [
  284. 'items' => $items,
  285. 'hasErrors' => $hasErrors,
  286. ]
  287. );
  288. } catch (Exception $e) {
  289. return $this->render(
  290. 'ComponentInventory/excelError.html.twig',
  291. [
  292. 'error' => $e->getMessage(),
  293. ],
  294. new Response('', 400)
  295. );
  296. }
  297. }
  299. #[Route(
  300. '/batch-increase-quantity',
  301. name: 'app.component_inventory.batch_increase_quantity.modal'
  302. )]
  303. public function modalBatchIncreaseQuantityAction(Request $request): ModalResponse
  304. {
  305. $response = new ModalResponse();
  306. $response->setSubmit(true);
  307. $response->setTitle(
  308. $this->trans('ui.batchIncreaseQuantity', [], 'ComponentInventoryItem')
  309. );
  310. $form = $this->createForm(
  311. BatchIncreaseQuantityType::class,
  312. null,
  313. [
  314. 'action' => $this->generateUrl(
  315. 'app.component_inventory.batch_increase_quantity.modal'
  316. )
  317. ]
  318. );
  319. $form->handleRequest($request);
  320. if ($form->isSubmitted()) {
  321. if ($form->isValid()) {
  322. try {
  323. /* @var BatchIncreaseQuantity $data */
  324. $data = $form->getData();
  325. $import = $request->getSession()->get(self::BATCH_INCREASE_DATA_KEY);
  326. foreach ($import['items'] as $item) {
  327. if (null !== $obj = $this->componentInventoryItemRepository->findByCode($item['code'])) {
  328. $data->updateItem($obj, $item['description'], $item['quantity'], $item['unitPrice'], $import['file']);
  329. } else {
  330. $obj = new ItemCreate(
  331. $item['code'],
  332. $item['type'],
  333. $item['quantity'],
  334. $item['unitPrice'],
  335. $item['description'],
  336. $data->getLogEntryNote(),
  337. $data->getPurchaseOrderNumber(),
  338. $import['file']
  339. )->toItem();
  340. }
  341. $this->componentInventoryItemRepository->save($obj);
  342. }
  343. $response->setRedirect(
  344. $this->generateUrl('app.component_inventory.index')
  345. );
  346. } catch (Exception $e) {
  347. $response->setError($e->getMessage());
  348. }
  349. }
  350. }
  351. $response->setBody(
  352. $this->renderView(
  353. 'ComponentInventory/batchIncreaseQuantityForm.html.twig',
  354. [
  355. 'form' => $form->createView(),
  356. ]
  357. )
  358. );
  360. return $response;
  361. }
  363. #[Route(
  364. '/batch-increase-quantity/preview',
  365. name: 'app.component_inventory.batch_increase_quantity.preview'
  366. )]
  367. public function modalBatchIncreaseQuantityPreviewAction(Request $request): Response
  368. {
  369. /* @var UploadedFile $file */
  370. $file = $request->files->get('excel');
  372. try {
  373. $fileName = $file->getClientOriginalName();
  374. $items = $this->componentInventoryService->parseBatchIncreaseExcel($file);
  375. $hasErrors = false;
  376. foreach ($items as $item) {
  377. if (null !== $item['error']) {
  378. $hasErrors = true;
  379. break;
  380. }
  381. }
  382. $request->getSession()->remove(self::BATCH_INCREASE_DATA_KEY);
  383. if (!$hasErrors) {
  384. $data = [
  385. 'items' => $items,
  386. 'file' => $fileName,
  387. ];
  388. $request->getSession()->set(self::BATCH_INCREASE_DATA_KEY, $data);
  389. }
  391. return $this->render(
  392. 'ComponentInventory/batchIncreaseQuantityPreview.html.twig',
  393. [
  394. 'items' => $items,
  395. 'hasErrors' => $hasErrors,
  396. ]
  397. );
  398. } catch (Exception $e) {
  399. return $this->render(
  400. 'ComponentInventory/excelError.html.twig',
  401. [
  402. 'error' => $e->getMessage(),
  403. ],
  404. new Response('', 400)
  405. );
  406. }
  407. }
  409. #[Route(
  410. '/batch-set-quantity',
  411. name: 'app.component_inventory.batch_set_quantity.modal'
  412. )]
  413. public function modalBatchSetQuantityAction(Request $request): ModalResponse
  414. {
  415. $response = new ModalResponse();
  416. $response->setSubmit(true);
  417. $response->setTitle(
  418. $this->trans('ui.batchSetQuantity', [], 'ComponentInventoryItem')
  419. );
  420. $form = $this->createForm(
  421. BatchSetQuantityType::class,
  422. null,
  423. [
  424. 'action' => $this->generateUrl(
  425. 'app.component_inventory.batch_set_quantity.modal'
  426. )
  427. ]
  428. );
  429. $form->handleRequest($request);
  430. if ($form->isSubmitted()) {
  431. if ($form->isValid()) {
  432. try {
  433. /* @var BatchSetQuantity $data */
  434. $data = $form->getData();
  435. $import = $request->getSession()->get(self::BATCH_SET_DATA_KEY);
  436. $codes = [];
  437. foreach ($import['items'] as $item) {
  438. $codes[] = $item['code'];
  439. if (null !== $obj = $this->componentInventoryItemRepository->findByCode($item['code'])) {
  440. if (null !== $item['description']) {
  441. $obj->setDescription($item['description']);
  442. }
  443. $data->updateItem($obj, $item['quantity'], $import['file']);
  444. $this->componentInventoryItemRepository->save($obj);
  445. }
  446. }
  447. // Set quantity zero to all codes that are not listed in the batch
  448. foreach ($this->componentInventoryItemRepository->findByMissingCodes($codes) as $obj) {
  449. $data->updateItem($obj, 0, $import['file']);
  450. $this->componentInventoryItemRepository->save($obj);
  451. }
  452. $response->setRedirect(
  453. $this->generateUrl('app.component_inventory.index')
  454. );
  455. } catch (Exception $e) {
  456. $response->setError($e->getMessage());
  457. }
  458. }
  459. }
  460. $response->setBody(
  461. $this->renderView(
  462. 'ComponentInventory/batchSetQuantityForm.html.twig',
  463. [
  464. 'form' => $form->createView(),
  465. ]
  466. )
  467. );
  469. return $response;
  470. }
  472. #[Route(
  473. '/batch-set-quantity/preview',
  474. name: 'app.component_inventory.batch_set_quantity.preview'
  475. )]
  476. public function modalBatchSetQuantityPreviewAction(Request $request): Response
  477. {
  478. /* @var UploadedFile $file */
  479. $file = $request->files->get('excel');
  481. try {
  482. $fileName = $file->getClientOriginalName();
  483. $items = $this->componentInventoryService->parseBatchSetExcel($file);
  484. $hasErrors = false;
  485. foreach ($items as $item) {
  486. if (null !== $item['error']) {
  487. $hasErrors = true;
  488. break;
  489. }
  490. }
  491. $request->getSession()->remove(self::BATCH_SET_DATA_KEY);
  492. if (!$hasErrors) {
  493. $data = [
  494. 'items' => $items,
  495. 'file' => $fileName,
  496. ];
  497. $request->getSession()->set(self::BATCH_SET_DATA_KEY, $data);
  498. }
  500. return $this->render(
  501. 'ComponentInventory/batchSetQuantityPreview.html.twig',
  502. [
  503. 'items' => $items,
  504. 'hasErrors' => $hasErrors,
  505. ]
  506. );
  507. } catch (Exception $e) {
  508. return $this->render(
  509. 'ComponentInventory/excelError.html.twig',
  510. [
  511. 'error' => $e->getMessage(),
  512. ],
  513. new Response('', 400)
  514. );
  515. }
  516. }
  518. #[Route(
  519. '/{item}/decrease-quantity',
  520. name: 'app.component_inventory.decrease_quantity.modal',
  521. requirements: ['item' => '\d+']
  522. )]
  523. public function modalDecreaseQuantityAction(Request $request, ComponentInventoryItem $item): ModalResponse
  524. {
  525. $response = new ModalResponse();
  526. $response->setSubmit(true);
  527. $response->setTitle(
  528. $this->trans('ui.decreaseQuantity', [], 'ComponentInventoryItem')
  529. );
  530. $response->setLabel($item->getCode());
  531. $form = $this->createForm(
  532. DecreaseQuantityType::class,
  533. null,
  534. [
  535. 'action' => $this->generateUrl(
  536. 'app.component_inventory.decrease_quantity.modal',
  537. [
  538. 'item' => $item->getId(),
  539. ]
  540. )
  541. ]
  542. );
  543. $form->handleRequest($request);
  544. if ($form->isSubmitted()) {
  545. if ($form->isValid()) {
  546. try {
  547. /* @var DecreaseQuantity $data */
  548. $data = $form->getData();
  549. $data->updateItem($item);
  550. $this->componentInventoryItemRepository->save($item);
  551. $response->setRedirect(
  552. $this->generateUrl('app.component_inventory.index')
  553. );
  554. } catch (Exception $e) {
  555. $response->setError($e->getMessage());
  556. }
  557. }
  558. }
  559. $response->setBody(
  560. $this->renderView(
  561. 'ComponentInventory/decreaseQuantityForm.html.twig',
  562. [
  563. 'form' => $form->createView(),
  564. ]
  565. )
  566. );
  568. return $response;
  569. }
  571. #[Route(
  572. '/{item}/increase-quantity',
  573. name: 'app.component_inventory.increase_quantity.modal',
  574. requirements: ['item' => '\d+']
  575. )]
  576. public function modalIncreaseQuantityAction(Request $request, ComponentInventoryItem $item): ModalResponse
  577. {
  578. $response = new ModalResponse();
  579. $response->setSubmit(true);
  580. $response->setTitle(
  581. $this->trans('ui.increaseQuantity', [], 'ComponentInventoryItem')
  582. );
  583. $response->setLabel($item->getCode());
  584. $form = $this->createForm(
  585. IncreaseQuantityType::class,
  586. null,
  587. [
  588. 'action' => $this->generateUrl(
  589. 'app.component_inventory.increase_quantity.modal',
  590. [
  591. 'item' => $item->getId(),
  592. ]
  593. )
  594. ]
  595. );
  596. $form->handleRequest($request);
  597. if ($form->isSubmitted()) {
  598. if ($form->isValid()) {
  599. try {
  600. /* @var IncreaseQuantity $data */
  601. $data = $form->getData();
  602. $data->updateItem($item);
  603. $this->componentInventoryItemRepository->save($item);
  604. $response->setRedirect(
  605. $this->generateUrl('app.component_inventory.index')
  606. );
  607. } catch (Exception $e) {
  608. $response->setError($e->getMessage());
  609. }
  610. }
  611. }
  612. $response->setBody(
  613. $this->renderView(
  614. 'ComponentInventory/increaseQuantityForm.html.twig',
  615. [
  616. 'form' => $form->createView(),
  617. ]
  618. )
  619. );
  621. return $response;
  622. }
  624. #[Route(
  625. '/create',
  626. name: 'app.component_inventory.create.modal'
  627. )]
  628. public function modalCreateAction(Request $request): ModalResponse
  629. {
  630. $response = new ModalResponse();
  631. $response->setSubmit(true);
  632. $response->setTitle(
  633. $this->trans('ui.create', [], 'ComponentInventoryItem')
  634. );
  635. $form = $this->createForm(
  636. ItemCreateType::class,
  637. null,
  638. [
  639. 'action' => $this->generateUrl(
  640. 'app.component_inventory.create.modal'
  641. )
  642. ]
  643. );
  644. $form->handleRequest($request);
  645. if ($form->isSubmitted()) {
  646. if ($form->isValid()) {
  647. try {
  648. /* @var ItemCreate $data */
  649. $data = $form->getData();
  650. $this->componentInventoryItemRepository->save($data->toItem());
  651. $response->setRedirect(
  652. $this->generateUrl('app.component_inventory.index')
  653. );
  654. } catch (Exception $e) {
  655. $response->setError($e->getMessage());
  656. }
  657. }
  658. }
  659. $response->setBody(
  660. $this->renderView(
  661. 'ComponentInventory/form.html.twig',
  662. [
  663. 'form' => $form->createView(),
  664. ]
  665. )
  666. );
  668. return $response;
  669. }
  671. #[Route(
  672. '/{item}/update',
  673. name: 'app.component_inventory.update.modal',
  674. requirements: ['item' => '\d+']
  675. )]
  676. public function modalUpdateAction(Request $request, ComponentInventoryItem $item): ModalResponse
  677. {
  678. $response = new ModalResponse();
  679. $response->setSubmit(true);
  680. $response->setTitle(
  681. $this->trans('ui.update', [], 'ComponentInventoryItem')
  682. );
  683. $response->setLabel($item->getCode());
  684. $form = $this->createForm(
  685. ItemUpdateType::class,
  686. ItemUpdate::fromItem($item),
  687. [
  688. 'action' => $this->generateUrl(
  689. 'app.component_inventory.update.modal',
  690. [
  691. 'item' => $item->getId(),
  692. ]
  693. )
  694. ]
  695. );
  696. $form->handleRequest($request);
  697. if ($form->isSubmitted()) {
  698. if ($form->isValid()) {
  699. try {
  700. /* @var ItemUpdate $data */
  701. $data = $form->getData();
  702. $data->updateItem($item);
  703. $this->componentInventoryItemRepository->save($item);
  704. $response->setRedirect(
  705. $this->generateUrl('app.component_inventory.index')
  706. );
  707. } catch (Exception $e) {
  708. $response->setError($e->getMessage());
  709. }
  710. }
  711. }
  712. $response->setBody(
  713. $this->renderView(
  714. 'ComponentInventory/updateForm.html.twig',
  715. [
  716. 'form' => $form->createView(),
  717. ]
  718. )
  719. );
  721. return $response;
  722. }
  723. }