bundles/Bgt/ApiBundle/Controller/DegreeOpenController.php line 62

Open in your IDE?
  1. <?php
  3. namespace Bgt\ApiBundle\Controller;
  5. use App\Entity\Admission;
  6. use App\Entity\Degree;
  7. use App\Entity\DegreeGroup;
  8. use App\Entity\User;
  9. use App\Entity\UserSession;
  10. use Bgt\ApiBundle\Services\TokenService;
  11. use Doctrine\ORM\EntityManagerInterface;
  12. use Symfony\Component\HttpFoundation\Request;
  13. use Symfony\Component\HttpFoundation\Response;
  14. use Symfony\Component\PasswordHasher\Hasher\UserPasswordHasherInterface;
  15. use Symfony\Component\Routing\Annotation\Route;
  16. use Symfony\Component\Security\Core\User\UserInterface;
  18. #[Route('/_open/degree')]
  19. class DegreeOpenController extends ApiController
  20. {
  21.     #[Route('/', name: 'api_degree_index', methods: ['GET', 'POST'])]
  22.     public function login(
  23.         Request $request,
  24.         EntityManagerInterface $em
  25.     ): Response
  26.     {
  27.         $degreeGroupId = 0;
  28.         if($request->isMethod(Request::METHOD_POST)) {
  29.             $request = $this->transformJsonBody($request);
  30.             $degreeGroupId = $request->request->getInt('degreeGroupId',0);
  31.         }
  33.         /** @var DegreeGroup $degreeGroup */
  34.         $degreeGroup = $em->getRepository(DegreeGroup::class)->find($degreeGroupId);
  36.         $qb = $em->getRepository(Degree::class)
  37.             ->createQueryBuilder('degree')
  38.             ->leftJoin('degree.degreeGroup', 'degreeGroup');
  40.         $qb->addSelect('degreeGroup');
  42.         if ($degreeGroup) {
  43.             $qb
  44.                 ->Where($qb->expr()->eq('degreeGroup.id', ':degreeGroupId'))
  45.                 ->setParameter('degreeGroupId', $degreeGroup->getId())
  46.                 ->andWhere($qb->expr()->neq('degree.isDeleted', ':boolTrue'))
  47.                 ->andWhere($qb->expr()->neq('degree.isTraining', ':boolTrue'))
  48.                 ->setParameter('boolTrue', true);
  49.         }
  51.         $degrees = $qb
  52.             ->orderBy('degree.id', "DESC")
  53.             ->getQuery()
  54.             ->getArrayResult();
  56.         return $this->respond([
  57.             'degrees' => $degrees,
  58.         ]);
  59.     }
  61.     #[Route('/training', name: 'api_degree_training', methods: ['GET'])]
  62.     public function training(
  63.         Request $request,
  64.         EntityManagerInterface $em
  65.     ): Response
  66.     {
  67.         $user = $this->getUser();
  69.         $qb = $em->getRepository(Degree::class)
  70.             ->createQueryBuilder('degree')
  71.         ;
  74.         $qb
  75.             ->select('degree.id')
  76.             ->andWhere($qb->expr()->eq('degree.isTraining', ':checkTrue'))
  77.             ->andWhere($qb->expr()->eq('degree.isDeleted', ':checkFalse'))
  78.             ->setParameter('checkTrue', true)
  79.             ->setParameter('checkFalse', false)
  80.         ;
  82.         $degrees = $qb
  83.             ->getQuery()
  84.             ->getSingleColumnResult();
  86.         $admission = $em->getRepository(Admission::class)
  87.             ->createQueryBuilder('admission')
  88.             ->leftJoin('admission.degree', 'degree');
  90.         $admission->addSelect('degree');
  92.         if ($degrees[0]) {
  93.             $admission
  94.                 ->andWhere($admission->expr()->in('degree.id', ':degreeIds'))
  95.                 ->andWhere($qb->expr()->neq('admission.isDeleted', ':boolTrue'))
  96.                 ->setParameter('degreeIds', $degrees)
  97.                 ->setParameter('boolTrue', true)
  98.             ;
  99.         }
  101.         $admissions = $admission
  102.             ->addOrderBy('admission.id', 'DESC')
  103.             ->getQuery()
  104.             ->getArrayResult();
  106.         return $this->respond([
  107.             'admissions' => $admissions,
  108.             'degree' => $degrees[0]
  109.         ]);
  110.     }
  111. }