src/Controller/TestController.php line 31

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Project;
  6. use App\Entity\Record;
  7. use App\Entity\UserProject;
  8. use Doctrine\ORM\EntityManager;
  9. use Doctrine\ORM\EntityManagerInterface;
  10. use Doctrine\ORM\Exception\ORMException;
  11. use Doctrine\Persistence\ManagerRegistry;
  12. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  13. use Symfony\Component\HttpFoundation\JsonResponse;
  14. use Symfony\Component\HttpFoundation\Response;
  15. use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;
  16. use Symfony\Component\Routing\Annotation\Route;
  17. use Twig\Environment;
  18. use Twig\Error\LoaderError;
  19. use Twig\Error\RuntimeError;
  20. use Twig\Error\SyntaxError;
  22. class TestController extends AbstractController
  23. {
  24.     /**
  25.      * @Route("/",name="home")
  26.      *
  27.      * @throws RuntimeError
  28.      * @throws LoaderError
  29.      * @throws SyntaxError
  30.      */
  31.     public function indexAction(Environment $twig): Response
  32.     {
  33.         return new Response($twig->render('index.html.twig'));
  34.     }
  36.     /**
  37.      * @Route("/api", name="test")
  38.      */
  39.     public function api(): JsonResponse
  40.     {
  41.         $response = new JsonResponse();
  42.         $response->setContent(json_encode([
  43.             'userIdentifier' => $this->getUser()->getUserIdentifier(),
  44.             'roles' => $this->getUser()->getRoles(),
  45.         ]));
  47.         return $response;
  48.     }
  50.     /**
  51.      * @throws NotFoundHttpException
  52.      *
  53.      * @Route("/api/projectRoles/{id_project}", name="projectRoles")
  54.      */
  55.     public function projectRoles(int $id_project, ManagerRegistry $doctrine): JsonResponse
  56.     {
  57.         $project = $doctrine->getRepository(Project::class)->find($id_project);
  59.         if (!$project) {
  60.             throw $this->createNotFoundException('Project not found');
  61.         }
  63.         $userProject = $doctrine
  64.             ->getRepository(UserProject::class)
  65.             ->findOneBy(['user' => $this->getUser(), 'project' => $project]);
  67.         return new JsonResponse($userProject->getRole());
  68.     }
  70.     /**
  71.      * @param EntityManager $manager
  72.      *
  73.      * @throws ORMException
  74.      *
  75.      * @Route("/purge")
  76.      */
  77.     public function purgeAction(EntityManagerInterface $manager): JsonResponse
  78.     {
  79.         $dateExpiration = new \DateTime('now');
  80.         $records = $manager->getRepository(Record::class)
  81.             ->createQueryBuilder('r')
  82.             ->where('r.recordTime <= :dateExpiration')
  83.             ->setParameter('dateExpiration', $dateExpiration)
  84.             ->getQuery()
  85.             ->getResult();
  87.         $recordCount = count($records);
  89.         $out = '';
  91.         while ($record = array_shift($records)) {
  92.             $manager->remove($record);
  93.             $product = $record->getProduct();
  94.             $manager->flush();
  96.             $leftRecords = $manager->getRepository(Record::class)->findBy(['product' => $product]);
  97.             if (0 == count($leftRecords)) {
  98.                 $manager->remove($product);
  99.                 $manager->flush();
  100.             }
  101.         }
  103.         return new JsonResponse(['record_count' => $recordCount]);
  104.     }
  105. }