src/Controller/ApiService/ApiWebsiteServicesController.php line 89

  1. <?php
  3. namespace App\Controller\ApiService;
  5. use App\Entity\Payments;
  6. use App\Entity\Students;
  7. use App\Repository\AcademicYearRepository;
  8. use App\Repository\AdmissionTblRepository;
  9. use App\Repository\CategoriesRepository;
  10. use App\Repository\CertificatesRepository;
  11. use App\Repository\CountriesRepository;
  12. use App\Repository\CourseRepository;
  13. use App\Repository\DepartmentRepository;
  14. use App\Repository\EventsRepository;
  15. use App\Repository\FAQRepository;
  16. use App\Repository\FilesRepository;
  17. use App\Repository\GradutedStudentRepository;
  18. use App\Repository\PaymentsRepository;
  19. use App\Repository\SchoolRepository;
  20. use App\Repository\StaffsRepository;
  21. use App\Repository\StudentCourseRepository;
  22. use App\Repository\StudentsRepository;
  23. use App\Repository\UserRepository;
  24. use App\Services\GeneraleServices;
  25. use App\Utils\Constants\AppConstants;
  26. use Knp\Snappy\Pdf;
  27. use Lexik\Bundle\JWTAuthenticationBundle\Encoder\JWTEncoderInterface;
  28. use NumberToWords\NumberToWords;
  29. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  30. use Symfony\Component\HttpFoundation\JsonResponse;
  31. use Symfony\Component\HttpFoundation\Request;
  32. use Symfony\Component\HttpFoundation\Response;
  33. use Symfony\Component\Routing\Annotation\Route;
  34. use Symfony\Contracts\HttpClient\HttpClientInterface;
  36. #[Route('/website_api')]
  37. class ApiWebsiteServicesController extends AbstractController
  38. {
  40.     public function __construct(private StudentCourseRepository $studentCourseRepository, private EventsRepository $eventsRepository, private CountriesRepository $countriesRepository, private DepartmentRepository $departmentRepository, private CategoriesRepository $categoriesRepository, private FAQRepository $FAQRepository, private StaffsRepository $staffsRepository, private AdmissionTblRepository $admissionTblRepository, private CertificatesRepository $certificatesRepository, private StudentsRepository $studentsRepository, private GradutedStudentRepository $gradutedStudentRepository, private FilesRepository $filesRepository, private CourseRepository $courseRepository, private GeneraleServices $generaleServices)
  41.     {
  42.     }
  44.     #[Route('/get_countries_department', name: 'get_countries_department', methods: ['GET'])]
  45.     public function get_countries_department(): Response
  46.     {
  47.         $this->countriesRepository->updateUUID();
  48.         $countries = $this->countriesRepository->findBy(['deleted' => false]);
  49.         $departments = $this->departmentRepository->findBy(['deleted' => false]);
  50.         return $this->json([
  51.             'countries' => $countries,
  52.             'departments' => $departments,
  53.         ]);
  55.     }
  57.     #[Route('/get_faq', name: 'get_faq', methods: ['GET'])]
  58.     public function get_faq(): Response
  59.     {
  60.         $general = $this->FAQRepository->findBy([
  61.             'type' => 1,
  62.         ], ['id' => 'DESC'], 20);
  63.         $studentPortal = $this->FAQRepository->findBy([
  64.             'type' => 2,
  65.         ], ['id' => 'DESC'], 20);
  66.         $admission = $this->FAQRepository->findBy([
  67.             'type' => 3,
  68.         ], ['id' => 'DESC'], 20);
  69.         return $this->json([
  70.             'general' => $general,
  71.             'studentPortal' => $studentPortal,
  72.             'admission' => $admission,
  73.         ]);
  75.     }
  77.     #[Route('/single_events', name: 'single_event', methods: ['POST'])]
  78.     public function single_event(Request $request): Response
  79.     {
  80.         $id = $request->get('id');
  81.         return $this->json($this->eventsRepository->findOneBy([
  82.             'id' => $id,
  83.             'statut' => true,
  84.             'deleted' => false
  85.         ]));
  86.     }
  88.     #[Route('/categorylist', name: 'categorylist', methods: ['GET'])]
  89.     public function categorylist(Request $request): Response
  90.     {
  91.         return $this->json($this->categoriesRepository->findBy(['deleted' => false]));
  92.     }
  94.     #[Route('/event_by_category', name: 'event_by_category', methods: ['POST'])]
  95.     public function event_by_category(Request $request): Response
  96.     {
  97.         $id = $request->get('id');
  98.         $category = $this->categoriesRepository->find($id);
  99.         $events = $this->eventsRepository->getOtherCat(1, 50, $category);
  100.         return $this->json($events);
  101.     }
  103.     #[Route('/send_latest_events', name: 'send_latest_events', methods: ['GET'])]
  104.     public function send_latest_events(): Response
  105.     {
  106.         $events = $this->eventsRepository->latestEvent(1, 5);
  107.         $admissionCat = $this->categoriesRepository->findOneBy([
  108.             'title' => 'Admission'
  109.         ]);
  110.         $admissionevents = $this->eventsRepository->findBy([
  111.             'category' => $admissionCat,
  112.             'statut' => true,
  113.         ], ['id' => 'DESC']);
  115.         $result = [
  116.             'admissions' => $admissionevents,
  117.             'others' => $events,
  118.         ];
  119.         return $this->json($result);
  120.     }
  122.     #[Route('/agentsList', name: 'agentsList', methods: ['GET'])]
  123.     public function agentsList(): Response
  124.     {
  125.         return $this->json($this->staffsRepository->getlisteAgents());
  126.     }
  128.     #[Route('/getdeptdata', name: 'getdeptdata', methods: ['GET'])]
  129.     public function getdeptdata(): Response
  130.     {
  131.         return $this->json($this->departmentRepository->findnotnuldept());
  132.     }
  134.     #[Route('/get_popular_dept', name: 'get_popular_dept', methods: ['GET'])]
  135.     public function get_popular_dept(): Response
  136.     {
  137.         return $this->json($this->departmentRepository->findnotnuldeptispopular());
  138.     }
  140.     #[Route('/getschooldata', name: 'getschooldata', methods: ['GET'])]
  141.     public function getschooldata()
  142.     {
  143.         $totalStudents = $this->studentsRepository->count(['deleted' => false]);
  144.         $totalCourses = $this->courseRepository->count(['deleted' => false]);
  145.         $totalDeparment = $this->departmentRepository->findBy(['deleted' => false]);
  146.         return $this->json(['students' => $totalStudents, 'courses' => $totalCourses, 'deparment' => count($totalDeparment)]);
  147.     }
  149.     #[Route('/get_student_basic_info', name: 'get_student_basic_info', methods: ['POST'])]
  150.     public function get_student_basic_info(Request $request)
  151.     {
  152.         $student = $this->studentsRepository->findOneBy([
  153.             'matricNo' => $request->get('matricNo')
  154.         ]);
  155.         if ($student == null) {
  156.             $student = $this->studentsRepository->findOneBy([
  157.                 'newMatricNo' => $request->get('matricNo')
  158.             ]);
  159.         }
  160.         $graduate = $this->gradutedStudentRepository->findOneBy([
  161.             'student' => $student
  162.         ]);
  163.         $studentMedia = $this->filesRepository->findOneBy(['type' => AppConstants::PASSPORT_PHOTO, 'referenceCode' => $student->getProfileImgCode(), 'deleted' => false, 'temp' => false]);
  164.         $picture = '';
  165.         if ($studentMedia) {
  166.             $picture = $studentMedia->getLocation() . $studentMedia->getFilename();
  167.         }
  168.         $data = [];
  169.         if ($graduate) {
  170.             $data = [
  171.                 'matricNo' => $student->getMatricNo(),
  172.                 'matricNoNew' => $student->getNewMatricNo(),
  173.                 'firstName' => $student->getFirstname(),
  174.                 'lastName' => $student->getLastname(),
  175.                 'admissionType' => $student->getAdmission(),
  176.                 'sectionType' => $student->getSectionType(),
  177.                 'departmentTitle' => $student->getDepartment()->getTitle(),
  178.                 'departmentCode' => $student->getDepartment()->getDepartmentCode(),
  179.                 'picture' => $picture,
  180.                 'level' => $student->getLevel(),
  181.                 'grade' => $graduate->getGrade()->getEnTitle(),
  182.                 'gradeYear' => $graduate->getGraduationYear(),
  183.             ];
  184.         }
  186.         return $this->json($data);
  187.     }
  189.     #[Route('/getadmissionlist', name: 'getadmissionlist', methods: ['GET'])]
  190.     public function getadmissionlist(): Response
  191.     {
  192.         return $this->json($this->admissionTblRepository->getadmissionlist());
  193.     }
  195.     #[Route('/get_certificate_detail', name: 'get_certificate_detail', methods: ['POST'])]
  196.     public function get_certificate_detail(Request $request): Response
  197.     {
  198.         $certificate = $this->certificatesRepository->findOneBy(['refNumber' => $request->get('refNumber')]);
  199.         $dataResult = [
  200.             'student' => $certificate->getStudent()->getLastname() . ' ' . $certificate->getStudent()->getFirstname(),
  201.             'admissiontype' => $certificate->getStudent()->getAdmission(),
  202.             'academicsession' => $certificate->getAcademicSession(),
  203.             'grade' => $certificate->getGrade(),
  204.             'department' => $certificate->getDepartment(),
  205.             'date' => $certificate->getDate(),
  206.         ];
  207.         return $this->json($dataResult);
  208.     }
  211.     /**
  212.      * [NEW] Download admission to student
  213.      */
  214.     #[Route('/download-admission-form/{reference}', name: 'downloadAdmissionForm')]
  215.     public
  216.     function downloadAdmissionFormAction(Request $request, Pdf $snappy, AdmissionTblRepository $admissionTblRepository)
  217.     {
  219.         $reference = $request->get('reference');
  220.         $admissionForm = $admissionTblRepository->findOneBy(['reference' => $reference]);
  221.         if ($admissionForm !== null) {
  223.             $selStudent = $admissionForm->getStudent();
  224.             $admissionYear = $admissionForm->getYear();
  226.             $selDept = $selStudent->getDepartment();
  227.             $date = $admissionForm->getAdmissionDate();
  228.             $levelCode = $selStudent->getLevel()->getLevelcode();
  229.             $departmentDuration = $selStudent->getAdmission()->getCodereference() === 'MSC' ? $selDept->getMasterDuration() : $selDept->getDuration();
  231.             $duration = $this->generaleServices->getDurationValue($departmentDuration, $levelCode);
  232. //            dd($duration);
  233.             $numberToWords = new NumberToWords();
  234.             $numberTransformer = $numberToWords->getNumberTransformer($selStudent->getSectionType());
  235.             $deptDuration = $numberTransformer->toWords($duration);
  236.             $semester = $duration * 2;
  237.             $semesterWords = $numberTransformer->toWords($semester);
  239.             if ($selStudent->getSectionType() == 'en') {
  240.                 $template = 'admission_form/admission_form_template.html.twig';
  241.                 if ($selStudent->getAdmission()->getCodereference() === 'MAP') {
  242.                     $template = 'admission_form/admission_masters_form_template.html.twig';
  243.                 }
  244.             } elseif ($selStudent->getSectionType() == 'fr') {
  245.                 $template = 'admission_form/frenchAdmissionForm.html.twig';
  246.                 if ($selStudent->getAdmission()->getCodereference() === 'MAP') {
  247.                     $template = 'admission_form/frenchAdmissionMastersForm.html.twig';
  248.                 }
  249.             }
  250.             $render = $this->renderView($template, array(
  251.                 'selStudent' => $selStudent,
  252.                 'admissionYear' => $admissionYear,
  253.                 'selDept' => $selDept,
  254.                 'duration' => $duration,
  255.                 'deptDuration' => $deptDuration,
  256.                 'semesterWords' => $semesterWords,
  257.                 'semester' => $semester,
  258.                 'date' => $date,
  259.                 'resumedate' => $date,
  260.             ));
  262.             $filename = $selStudent->getLastname() . '_' . $selStudent->getFirstname() . '_(' . $selStudent->getMatricNo() . ')' . '_Admission_letter.pdf';
  263.             return new Response(
  264.                 $snappy->getOutputFromHtml($render, [
  265.                     'encoding' => 'utf-8',
  266.                     'images' => true,
  267.                     'dpi' => 300,
  268.                 ]),
  269.                 200,
  270.                 array(
  271.                     'Content-Type' => 'application/pdf',
  272.                     'Content-Disposition' => 'attachment; filename=' . $filename . '.pdf'
  273.                 )
  274.             );
  275.         }
  276.         exit();
  277.     }
  280.     #[Route('/payments/download-payment-reciept/{reference}', name: 'api_printRecipte', methods: ['GET', 'POST'])]
  281.     public function printRecipteAction(SchoolRepository $schoolRepository, Payments $payment, PaymentsRepository $paymentsRepository, \Knp\Snappy\Pdf $snappy)
  282.     {
  283.         $numberToWords = new NumberToWords();
  284.         $selStudent = $payment->getTheFee()->getStudent();
  285.         $numberTransformer = $numberToWords->getNumberTransformer($selStudent->getSectionType());
  286.         $wordNumber = $numberTransformer->toWords($payment->getAmount());
  287.         $school = $schoolRepository->findBy(['deleted' => false], [], 1)[0];
  288.         $allPayments = $paymentsRepository->getTotalPaid($payment->getTheFee());
  289. //        dd($allPayments);
  290.         if ($selStudent->getSectionType() === 'en') {
  291.             $template = "fees/recipt.html.twig";
  292.         } elseif ($selStudent->getSectionType() === 'fr') {
  293.             $template = "fees/reciptFR.html.twig";
  294.         }
  296.         $render = $this->renderView($template, [
  297.             'wordNumber' => $wordNumber,
  298.             'paymentinfo' => $payment,
  299.             'totalPaid' => $allPayments,
  300.             'school' => $school,
  301.         ]);
  303.         return new Response(
  304.             $snappy->getOutputFromHtml($render, [
  305.                 'orientation' => 'portrait',
  306.                 'page-height' => 120.4,
  307.                 'page-width' => 214.6,
  308.                 'encoding' => 'utf-8',
  309.                 'images' => true,
  310.                 'dpi' => 300,
  312.             ]),
  313.             200,
  314.             [
  315.                 'Content-Type' => 'application/pdf',
  316.                 'Content-Disposition' => 'attachment; filename=Payment_Reciept.pdf',
  317.             ]
  318.         );
  319.     }
  321.     #[Route('/download_course_sheet/{uuid}', name: 'api_download_course_sheet', methods: ['GET'])]
  322.     function downloadCourseSheetAction(Students $student, AcademicYearRepository $academicYearRepository, Pdf $snappy): Response
  323.     {
  324.         $academicYear = $academicYearRepository->findOneBy(['status' => true]);
  325.         $result = $this->studentCourseRepository->getRegisteredCourseForStudent($student, $academicYear);
  326. //        dd($result);
  327.         if ($student->getSectionType() == 'en') {
  328.             $template = 'course/printCourse.html.twig';
  329.         } elseif ($student->getSectionType() == 'fr') {
  330.             $template = 'course/printCourseFr.html.twig';
  331.         }
  332.         $render = $this->renderView($template, array(
  333.             'courses' => $result,
  334.             'student' => $student,
  335.             'academicYear' => $academicYear,
  337.         ));
  339.         return new Response(
  340.             $snappy->getOutputFromHtml($render),
  341.             200,
  342.             array(
  343.                 'Content-Type' => 'application/pdf',
  344.                 'Content-Disposition' => 'attachment; filename=Course-sheet.pdf',
  345.             )
  346.         );
  348.     }
  350.     public function getDurationValue(int $departmentDuration, string $studentLevel)
  351.     {
  352.         $levels = ['100', '200', '300', '400'];
  353.         $duration = 0;
  354.         foreach ($levels as $key => $lv) {
  355.             if ($lv === $studentLevel) {
  356.                 $duration = $departmentDuration - $key;
  357.             }
  358.         }
  360.         return $duration == 0 ? 1 : $duration;
  361.     }
  362. }