src/Controller/Api/ApiController.php line 245

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Api;
  5. use App\Entity\User;
  6. use App\Entity\SchoolYear;
  7. use App\Service\SMSSender;
  8. use Informagenie\OrangeSDK;
  9. use App\Entity\TreasuryCashRegister;
  10. use App\Repository\AccountingExpenseRepository;
  11. use App\Repository\AccountingStudentRegistrationFeeRepository;
  12. use App\Repository\AccountingStudentRegistrationPaymentRepository;
  13. use App\Repository\SchoolYearRepository;
  14. use App\Repository\EstablishmentRepository;
  15. use Symfony\Component\HttpFoundation\Response;
  16. use Symfony\Component\Routing\Annotation\Route;
  17. use App\Repository\EstablishmentGroupRepository;
  18. use App\Repository\RegistrationStudentRegistrationRepository;
  19. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  21. class ApiController extends AbstractController
  22. {
  23.     /**
  24.      * @Route("/api/_student_registrations", name="api_registration_student_registrations", methods={"GET","POST"})
  25.      */
  26.     public function _student_registrations(RegistrationStudentRegistrationRepository $registrationStudentRegistrationRepository, AccountingStudentRegistrationFeeRepository $accountingStudentRegistrationFeeRepository, AccountingStudentRegistrationPaymentRepository $accountingStudentRegistrationPaymentRepository, AccountingExpenseRepository $accountingExpenseRepository): Response
  27.     {
  28.         /**@var User $user */
  29.         $user = $this->getUser();
  30.         $establishment = $user->getEstablishment();
  31.         $schoolYear = $user->getSchoolYear();
  33.         $accountingExpense = $accountingExpenseRepository->createQueryBuilder('entity')
  35.         ->innerJoin('entity.establishment', 'establishment')
  36.         ->addSelect('establishment')
  38.         ->andWhere('establishment.establishmentGroup = :establishmentGroup')
  39.         ->setParameter('establishmentGroup', $establishment->getEstablishmentGroup())
  41.         ->andWhere('entity.create_date BETWEEN :startDate AND :endDate')
  42.         ->setParameter('startDate', date('Y').'-01-01')
  43.         ->setParameter('endDate', date('Y').'-12-31')
  44.         
  45.         /* ->andWhere('entity.schoolYear = :schoolYear')
  46.         ->setParameter('schoolYear', $schoolYear) */
  48.         ->andWhere('entity.is_canceled = :is_canceled')
  49.         ->setParameter('is_canceled', 0)
  51.         ->andWhere('entity.is_paid = :is_paid')
  52.         ->setParameter('is_paid', 1)
  54.         ->select('SUM(entity.amount) as amount')
  56.         ->getQuery()
  57.         ->getSingleScalarResult();
  59.         $accountingStudentRegistrationFee = $accountingStudentRegistrationFeeRepository->createQueryBuilder('entity')
  60.         ->innerJoin('entity.studentRegistration', 'studentRegistration')
  61.         ->addSelect('studentRegistration')
  63.         ->andWhere('studentRegistration.establishment = :establishment')
  64.         ->setParameter('establishment', $establishment)
  65.         
  66.         ->andWhere('studentRegistration.schoolYear = :schoolYear')
  67.         ->setParameter('schoolYear', $schoolYear)
  69.         ->andWhere('entity.is_cancel = :is_cancel')
  70.         ->setParameter('is_cancel', 0)
  72.         ->andWhere('entity.is_archived = :is_archived')
  73.         ->setParameter('is_archived', 0)
  75.         ->select('SUM(entity.amount) as amount')
  77.         ->getQuery()
  78.         ->getSingleScalarResult();
  80.         $accountingStudentRegistrationPayment = $accountingStudentRegistrationPaymentRepository->createQueryBuilder('entity')
  81.         ->innerJoin('entity.studentRegistration', 'studentRegistration')
  82.         ->addSelect('studentRegistration')
  84.         ->andWhere('studentRegistration.establishment = :establishment')
  85.         ->setParameter('establishment', $establishment)
  86.         
  87.         ->andWhere('studentRegistration.schoolYear = :schoolYear')
  88.         ->setParameter('schoolYear', $schoolYear)
  90.         ->select('SUM(entity.amount) as amount')
  92.         ->getQuery()
  93.         ->getSingleScalarResult();
  95.         $registration_student_registrations = $registrationStudentRegistrationRepository->createQueryBuilder('entity')
  97.         ->innerJoin('entity.student', 'student')
  98.         ->addSelect('student')
  100.         ->andWhere('entity.establishment = :establishment')
  101.         ->setParameter('establishment', $establishment)
  102.         
  103.         ->andWhere('entity.schoolYear = :schoolYear')
  104.         ->setParameter('schoolYear', $schoolYear)
  106.         ->getQuery()
  107.         ->getResult();
  109.         $registration_student_registration_women = $registrationStudentRegistrationRepository->createQueryBuilder('entity')
  111.         ->innerJoin('entity.student', 'student')
  112.         ->addSelect('student')
  114.         ->andWhere('entity.establishment = :establishment')
  115.         ->setParameter('establishment', $establishment)
  116.         
  117.         ->andWhere('entity.schoolYear = :schoolYear')
  118.         ->setParameter('schoolYear', $schoolYear)
  120.         ->andWhere('student.gender = :gender')
  121.         ->setParameter('gender', 'FEMININ')
  123.         ->getQuery()
  124.         ->getResult();
  126.         $registration_student_registration_men = $registrationStudentRegistrationRepository->createQueryBuilder('entity')
  128.         ->innerJoin('entity.student', 'student')
  129.         ->addSelect('student')
  131.         ->andWhere('entity.establishment = :establishment')
  132.         ->setParameter('establishment', $establishment)
  133.         
  134.         ->andWhere('entity.schoolYear = :schoolYear')
  135.         ->setParameter('schoolYear', $schoolYear)
  137.         ->andWhere('student.gender = :gender')
  138.         ->setParameter('gender', 'MASCULIN')
  140.         ->getQuery()
  141.         ->getResult();
  143.         $registration_student_registration_affecteds = $registrationStudentRegistrationRepository->createQueryBuilder('entity')
  145.         ->innerJoin('entity.student', 'student')
  146.         ->addSelect('student')
  148.         ->andWhere('entity.establishment = :establishment')
  149.         ->setParameter('establishment', $establishment)
  150.         
  151.         ->andWhere('entity.schoolYear = :schoolYear')
  152.         ->setParameter('schoolYear', $schoolYear)
  154.         ->andWhere('student.is_affected = :is_affected')
  155.         ->setParameter('is_affected', 1)
  157.         ->getQuery()
  158.         ->getResult();
  160.         return $this->renderForm('api/render/student_registrations.html.twig', [
  161.             'registration_student_registrations' => count($registration_student_registrations),
  162.             'registration_student_registration_women' => count($registration_student_registration_women),
  163.             'registration_student_registration_men' => count($registration_student_registration_men),
  164.             'registration_student_registration_affecteds' => count($registration_student_registration_affecteds),
  166.             'accountingStudentRegistrationFee' => $accountingStudentRegistrationFee,
  167.             'accountingStudentRegistrationPayment' => $accountingStudentRegistrationPayment,
  168.             'accountingExpense' => $accountingExpense
  169.         ]);
  170.     }
  172.     /**
  173.      * @Route("/api/_gender_echart", name="api_gender_echart", methods={"GET","POST"})
  174.      */
  175.     public function _gender_echart(RegistrationStudentRegistrationRepository $registrationStudentRegistrationRepository): Response
  176.     {
  177.         /**@var User $user */
  178.         $user = $this->getUser();
  179.         $establishment = $user->getEstablishment();
  180.         $schoolYear = $user->getSchoolYear();
  182.         $registration_student_registrations = $registrationStudentRegistrationRepository->createQueryBuilder('entity')
  184.         ->innerJoin('entity.student', 'student')
  185.         ->addSelect('student')
  187.         ->andWhere('entity.establishment = :establishment')
  188.         ->setParameter('establishment', $establishment)
  189.         
  190.         ->andWhere('entity.schoolYear = :schoolYear')
  191.         ->setParameter('schoolYear', $schoolYear)
  193.         ->getQuery()
  194.         ->getResult();
  196.         $registration_student_registration_women = $registrationStudentRegistrationRepository->createQueryBuilder('entity')
  198.         ->innerJoin('entity.student', 'student')
  199.         ->addSelect('student')
  201.         ->andWhere('entity.establishment = :establishment')
  202.         ->setParameter('establishment', $establishment)
  203.         
  204.         ->andWhere('entity.schoolYear = :schoolYear')
  205.         ->setParameter('schoolYear', $schoolYear)
  207.         ->andWhere('student.gender = :gender')
  208.         ->setParameter('gender', 'FEMININ')
  210.         ->getQuery()
  211.         ->getResult();
  213.         $registration_student_registration_men = $registrationStudentRegistrationRepository->createQueryBuilder('entity')
  215.         ->innerJoin('entity.student', 'student')
  216.         ->addSelect('student')
  218.         ->andWhere('entity.establishment = :establishment')
  219.         ->setParameter('establishment', $establishment)
  220.         
  221.         ->andWhere('entity.schoolYear = :schoolYear')
  222.         ->setParameter('schoolYear', $schoolYear)
  224.         ->andWhere('student.gender = :gender')
  225.         ->setParameter('gender', 'MASCULIN')
  227.         ->getQuery()
  228.         ->getResult();
  230.         return $this->json([
  231.             'code' => 200, 
  232.             'registration_student_registrations' => count($registration_student_registrations), 
  233.             'women' => count($registration_student_registrations) > 0 ? floatval(number_format(((count($registration_student_registration_women) * 100) / count($registration_student_registrations)), 2, '.', '')) : 0, 
  234.             'men' => count($registration_student_registrations) > 0 ? floatval(number_format(((count($registration_student_registration_men) * 100) / count($registration_student_registrations)), 2, '.', '')) : 0, 
  235.             
  236.             'count_women' => count($registration_student_registration_women), 
  237.             'count_men' => count($registration_student_registration_men), 
  238.             'message' => "Validation effectuée :)"
  239.         ], 200);
  240.     }
  242.     /**
  243.      * @Route("/api/_status_echart", name="api_status_echart", methods={"GET","POST"})
  244.      */
  245.     public function _status_echart(RegistrationStudentRegistrationRepository $registrationStudentRegistrationRepository): Response
  246.     {
  247.         /**@var User $user */
  248.         $user = $this->getUser();
  249.         $establishment = $user->getEstablishment();
  250.         $schoolYear = $user->getSchoolYear();
  252.         $registration_student_registrations = $registrationStudentRegistrationRepository->createQueryBuilder('entity')
  254.         ->innerJoin('entity.student', 'student')
  255.         ->addSelect('student')
  257.         ->andWhere('entity.establishment = :establishment')
  258.         ->setParameter('establishment', $establishment)
  259.         
  260.         ->andWhere('entity.schoolYear = :schoolYear')
  261.         ->setParameter('schoolYear', $schoolYear)
  263.         ->getQuery()
  264.         ->getResult();
  266.         $registration_student_registration_affecteds = $registrationStudentRegistrationRepository->createQueryBuilder('entity')
  268.         ->innerJoin('entity.student', 'student')
  269.         ->addSelect('student')
  271.         ->andWhere('entity.establishment = :establishment')
  272.         ->setParameter('establishment', $establishment)
  273.         
  274.         ->andWhere('entity.schoolYear = :schoolYear')
  275.         ->setParameter('schoolYear', $schoolYear)
  277.         ->andWhere('student.is_affected = :is_affected')
  278.         ->setParameter('is_affected', 1)
  280.         ->getQuery()
  281.         ->getResult();
  283.         $registration_student_registration_not_affecteds = $registrationStudentRegistrationRepository->createQueryBuilder('entity')
  285.         ->innerJoin('entity.student', 'student')
  286.         ->addSelect('student')
  288.         ->andWhere('entity.establishment = :establishment')
  289.         ->setParameter('establishment', $establishment)
  290.         
  291.         ->andWhere('entity.schoolYear = :schoolYear')
  292.         ->setParameter('schoolYear', $schoolYear)
  294.         ->andWhere('student.is_affected = :is_affected')
  295.         ->setParameter('is_affected', 0)
  297.         ->getQuery()
  298.         ->getResult();
  300.         return $this->json([
  301.             'code' => 200, 
  302.             'registration_student_registrations' => count($registration_student_registrations), 
  304.             'affecteds' => count($registration_student_registrations) > 0 ? floatval(number_format(((count($registration_student_registration_affecteds) * 100) / count($registration_student_registrations)), 2, '.', '')) : 0, 
  305.             'count_affecteds' => count($registration_student_registration_affecteds), 
  307.             'not_affecteds' => count($registration_student_registrations) > 0 ? floatval(number_format(((count($registration_student_registration_not_affecteds) * 100) / count($registration_student_registrations)), 2, '.', '')) : 0, 
  308.             'count_not_affecteds' => count($registration_student_registration_not_affecteds), 
  309.             'message' => "Validation effectuée :)"
  310.         ], 200);
  311.     }
  312. }