src/Controller/School/SchoolTeacherCallSheetLineController.php line 27

Open in your IDE?
  1. <?php
  3. namespace App\Controller\School;
  5. use Knp\Snappy\Pdf;
  6. use App\Entity\User;
  7. use DateTimeImmutable;
  8. use App\Service\SMSSender;
  9. use Informagenie\OrangeSDK;
  10. use App\Entity\CommunicationMessage;
  11. use App\Entity\SchoolTeacherCallSheetLine;
  12. use Symfony\Component\HttpFoundation\Request;
  13. use App\Repository\SettingClassroomRepository;
  14. use Symfony\Component\HttpFoundation\Response;
  15. use Symfony\Component\Routing\Annotation\Route;
  16. use App\Repository\SchoolTeacherCallSheetLineRepository;
  17. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  19. /**
  20.  * @Route("/school/teacher-call-sheet-line")
  21.  */
  22. class SchoolTeacherCallSheetLineController extends AbstractController
  23. {
  24.     /**
  25.      * @Route("/{id}/set-to-present", name="school_teacher_call_sheet_line_set_to_present", methods={"GET"})
  26.     */
  27.     public function setToPresent(SchoolTeacherCallSheetLine $schoolTeacherCallSheetLine): Response
  28.     {
  29.         $entityManager = $this->getDoctrine()->getManager();
  30.         $schoolTeacherCallSheetLine->setIsPresente(true);
  31.         $schoolTeacherCallSheetLine->setIsAbsent(false);
  32.         try {
  33.             $entityManager->flush();
  34.             //$this->addFlash('success', "Traitement effectué");
  35.             return $this->json([
  36.                 'code' => 200, 
  37.                 'message' => "Présent(e)",
  38.                 'tr' => "#tr-".$schoolTeacherCallSheetLine->getId(),
  39.                 'td' => "#td-".$schoolTeacherCallSheetLine->getId(),
  40.                 'btnPresent' => "#btn-present-".$schoolTeacherCallSheetLine->getId(),
  41.                 'isCanBeSaved' => $schoolTeacherCallSheetLine->getSchoolTeacherCallSheet()->isCanBeSaved()
  42.             ], 200);
  43.         } catch (\Throwable $th) {
  44.             //$th->getMessage()
  45.             $this->addFlash('warning', $th->getMessage());
  46.         }
  47.         
  48.         $this->addFlash('warning', "Traitement non effectué");
  49.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  50.     }
  52.     /**
  53.      * @Route("/{id}/set-to-absent", name="school_teacher_call_sheet_line_set_to_absent", methods={"GET"})
  54.     */
  55.     public function setToAbsent(SchoolTeacherCallSheetLine $schoolTeacherCallSheetLine): Response
  56.     {
  57.         $entityManager = $this->getDoctrine()->getManager();
  58.         $schoolTeacherCallSheetLine->setIsPresente(false);
  59.         $schoolTeacherCallSheetLine->setIsAbsent(true);
  60.         try {
  61.             $entityManager->flush();
  62.             //$this->addFlash('success', "Traitement effectué");
  63.             return $this->json([
  64.                 'code' => 200, 
  65.                 'message' => "Absent(e)",
  66.                 'tr' => "#tr-".$schoolTeacherCallSheetLine->getId(),
  67.                 'td' => "#td-".$schoolTeacherCallSheetLine->getId(),
  68.                 'btnAbsent' => "#btn-absent-".$schoolTeacherCallSheetLine->getId(),
  69.                 'isCanBeSaved' => $schoolTeacherCallSheetLine->getSchoolTeacherCallSheet()->isCanBeSaved()
  70.             ], 200);
  71.         } catch (\Throwable $th) {
  72.             //$th->getMessage()
  73.             $this->addFlash('warning', $th->getMessage());
  74.         }
  75.         
  76.         $this->addFlash('warning', "Traitement non effectué");
  77.         return $this->json(['code' => 500, 'message' => "Traitement non effectué"], 200);
  78.     }
  80.     /**
  81.      * @Route("/student-present-ns", name="school_call_sheet_line_student_present_ns", methods={"GET"})
  82.      */
  83.     public function student_present_ns(Request $request, Pdf $knpSnappyPdf, SchoolTeacherCallSheetLineRepository $schoolTeacherCallSheetLineRepository, SettingClassroomRepository $settingClassroomRepository): Response
  84.     {
  85.         /**@var User $user */
  86.         $user = $this->getUser();
  87.         $schoolYear = $user->getSchoolYear();
  88.         $establishment = $this->getUser()->getEstablishment();
  89.         
  90.         $create_date = new DateTimeImmutable($request->get('create_date'));
  91.         $settingClassroom = $settingClassroomRepository->findOneBy(['id' => $request->get('setting_classroom')], []);
  93.         $school_teacher_call_sheet_lines = $schoolTeacherCallSheetLineRepository->createQueryBuilder('entity')
  94.             ->innerJoin('entity.schoolTeacherCallSheet', 'schoolTeacherCallSheet')
  95.             ->addSelect('schoolTeacherCallSheet')
  97.             ->andWhere('schoolTeacherCallSheet.create_date = :create_date')
  98.             ->setParameter('create_date', $create_date);
  100.             if (null != $settingClassroom) {
  101.                 $school_teacher_call_sheet_lines = $school_teacher_call_sheet_lines
  102.                 ->andWhere('schoolTeacherCallSheet.settingClassroom = :settingClassroom')
  103.                 ->setParameter('settingClassroom', $settingClassroom);
  104.             }
  106.             $school_teacher_call_sheet_lines = $school_teacher_call_sheet_lines
  107.             ->andWhere('entity.establishment = :establishment')
  108.             ->setParameter('establishment', $establishment)
  110.             ->andWhere('entity.schoolYear = :schoolYear')
  111.             ->setParameter('schoolYear', $schoolYear)
  113.             ->andWhere('entity.is_presente = :is_presente')
  114.             ->setParameter('is_presente', 1)
  116.             ->orderBy('entity.id', 'DESC')
  117.             ->getQuery()
  118.             ->getResult();
  120.         if ($request->get('resulst') == '1') {
  121.             $html = $this->renderView('school/print/student_present_ns.html.twig', [
  122.                 'school_teacher_call_sheet_lines' => $school_teacher_call_sheet_lines,
  123.                 'setting_classroom' => $settingClassroom,
  124.                 'create_date' => $create_date,
  125.                 'school_year' => $schoolYear,
  126.                 'setting' => $establishment,
  127.             ]);
  128.     
  129.             $footer = $this->renderView('print/footer.html.twig', ['setting' => $establishment]);
  130.             $header = $this->renderView('print/header.html.twig', ['setting' => $establishment]);
  131.             $options = [
  132.                 'orientation' => 'Portrait',
  133.                 'header-html' => $header,
  134.                 'footer-html' => $footer
  135.             ];
  136.     
  137.             $file_name = "ELEVES_PRES_NON_AJOUR_.pdf";
  138.     
  139.             try {
  140.                 $knpSnappyPdf->generateFromHtml($html, $this->getParameter('app.app_directory').'/downloads/report-cards/' . $file_name, $options, true);
  141.             } catch (\Throwable $th) {
  142.                 $this->addFlash('info', "Effectué");
  143.             }
  144.     
  145.             return $this->redirectToRoute('preview', [
  146.                 'file' => $file_name,
  147.                 'dir' => 'report-cards',
  148.             ]);
  149.         }
  151.         return $this->render('school/school_teacher_call_sheet_line/student_present_ns.html.twig', [
  152.             'school_teacher_call_sheet_lines' => $school_teacher_call_sheet_lines,
  153.             'setting_classroom' => $settingClassroom,
  154.             'create_date' => $create_date,
  155.             'setting_classrooms' => $settingClassroomRepository->findBy(['establishment' => $establishment, 'schoolYear' => $schoolYear], ['label' => 'ASC']),
  156.         ]);
  157.     }
  159.     /**
  160.      * @Route("/set-presents", name="school_teacher_call_sheet_line_set_to_presents", methods={"GET"})
  161.     */
  162.     public function set_to_presents(Request $request, SchoolTeacherCallSheetLineRepository $schoolTeacherCallSheetLineRepository): Response
  163.     {
  164.         $list = $request->get('entities');
  165.         $entityManager = $this->getDoctrine()->getManager();
  166.         $errors = 0;
  167.         $success = 0;
  168.         foreach ($list as $key => $id) {
  169.             $schoolTeacherCallSheetLine = $schoolTeacherCallSheetLineRepository->findOneBy(['id' => intval($id)], []);
  170.             if ($schoolTeacherCallSheetLine != null) {
  171.                 if (!$schoolTeacherCallSheetLine->getSchoolTeacherCallSheet()->getIsAproved()) { 
  173.                     $schoolTeacherCallSheetLine->setIsAbsent(false);
  174.                     $schoolTeacherCallSheetLine->setIsPresente(true);
  175.                     $success++;
  176.                 }
  177.             }
  178.         }
  179.         
  181.         try {
  182.             $entityManager->flush();
  183.             $this->addFlash('success', $success. " élève(s) marqué(s) présent(s)");
  184.             return $this->json(['code' => 200, 'message' => $success. " élève(s) marqué(s) présent(s)"], 200);
  185.         } catch (\Throwable $th) {
  186.             $this->addFlash('warning', $th->getMessage());
  187.         }
  188.         
  189.         $this->addFlash('warning', "Traitement non effectuée");
  190.         return $this->json(['code' => 500, 'message' => "Traitement non effectuée"], 200);
  191.     }
  193.     /**
  194.      * @Route("/set-absents", name="school_teacher_call_sheet_line_set_to_absents", methods={"GET"})
  195.     */
  196.     public function set_to_absents(Request $request, SchoolTeacherCallSheetLineRepository $schoolTeacherCallSheetLineRepository): Response
  197.     {
  198.         $list = $request->get('entities');
  199.         $entityManager = $this->getDoctrine()->getManager();
  200.         $errors = 0;
  201.         $success = 0;
  202.         
  203.         foreach ($list as $key => $id) {
  204.             $schoolTeacherCallSheetLine = $schoolTeacherCallSheetLineRepository->findOneBy(['id' => intval($id)], []);
  205.             if ($schoolTeacherCallSheetLine != null) {
  206.                 if (!$schoolTeacherCallSheetLine->getSchoolTeacherCallSheet()->getIsAproved()) { 
  208.                     $schoolTeacherCallSheetLine->setIsAbsent(true);
  209.                     $schoolTeacherCallSheetLine->setIsPresente(false);
  210.                     $success++;
  211.                 }
  212.             }
  213.         }
  215.         try {
  216.             $entityManager->flush();
  217.             $this->addFlash('success', $success. " élève(s) marqué(es) absent(es)");
  218.             return $this->json(['code' => 200, 'message' => $success. " élève(s) marqué(es) absent(es)"], 200);
  219.         } catch (\Throwable $th) {
  220.             $this->addFlash('warning', $th->getMessage());
  221.         }
  222.         
  223.         $this->addFlash('warning', "Traitement non effectuée");
  224.         return $this->json(['code' => 500, 'message' => "Traitement non effectuée"], 200);
  225.     }
  227.     /**
  228.      * @Route("/send-adsense-sms", name="school_teacher_call_sheet_line_send_adsense_sms", methods={"GET"})
  229.     */
  230.     public function send_adsense_sms(Request $request, SchoolTeacherCallSheetLineRepository $schoolTeacherCallSheetLineRepository, SMSSender $smsSender): Response
  231.     {
  232.         /**@var User $user */
  233.         $user = $this->getUser();
  234.         $schoolYear = $user->getSchoolYear();
  235.         $establishment = $user->getEstablishment();
  236.         
  237.         $list = $request->get('entities');
  238.         $entityManager = $this->getDoctrine()->getManager();
  239.         $errors = 0;
  240.         $success = 0;
  241.         
  242.         foreach ($list as $key => $id) {
  243.             $schoolTeacherCallSheetLine = $schoolTeacherCallSheetLineRepository->findOneBy(['id' => intval($id)], []);
  244.             if ($schoolTeacherCallSheetLine != null) {
  245.                 $schoolTeacherCallSheet = $schoolTeacherCallSheetLine->getSchoolTeacherCallSheet();
  246.                 if (!$schoolTeacherCallSheetLine->getSchoolTeacherCallSheet()->getIsAproved()) { 
  248.                     if ($establishment->getIsSendAbsenceSms()){
  249.                         $sms = new OrangeSDK(CommunicationMessage::SENDER_ID);
  250.                         //foreach ($schoolTeacherCallSheet->getSchoolTeacherCallSheetLines() as $key => $schoolTeacherCallSheetLine) {
  251.                             if ($schoolTeacherCallSheetLine->getIsAbsent()) {
  252.                                 $message = "";
  253.                                 $contacts = [];
  254.                                 $contacts[] = '225'.str_replace(' ', '',trim($schoolTeacherCallSheetLine->getRegistrationStudentRegistration()->getStudent()->getNotificationPhoneNumber()));
  255.                                 $contact = '225'.str_replace(' ', '',trim($schoolTeacherCallSheetLine->getRegistrationStudentRegistration()->getStudent()->getNotificationPhoneNumber()));
  256.                                 
  257.                                 $message = $schoolTeacherCallSheetLine->getRegistrationStudentRegistration()->getStudent()->getName()." A ETE ABSENT ";
  258.                                 $message = $message . " de ".$schoolTeacherCallSheet->getSettingTimeTable()->getLabel() ;
  259.                                 $message = $message . " AU COURS DE " . $schoolTeacherCallSheet->getSchoolMatter()->getLabel();
  260.                                 $message = $message . " CE " . $schoolTeacherCallSheet->getCreateDate()->format('d-m-Y');
  261.                                 
  262.             
  263.                                 if ($establishment->getSmsGateway() == 'OCI') {
  264.                                     $oci_response = $sms->message($message)
  265.                                     ->as($establishment->getOciSmsSender())
  266.                                     ->from($establishment->getOciSmsPhone())
  267.                                     ->to(intval($contact));
  268.             
  269.                                     try {
  270.                                         $oci_response->send();
  271.                                     } catch (\Throwable $th) {
  272.                                         $this->addFlash('warning', $th->getMessage());
  273.                                     }
  274.             
  275.                                     $communicationMessage = new CommunicationMessage();
  276.                                     $communicationMessage->setCode($contact.$schoolTeacherCallSheetLine->getId());
  277.                                     $communicationMessage->setContacts($contacts);
  278.                                     $communicationMessage->setContent($message);
  279.                                     $communicationMessage->setEstablishment($establishment);
  280.                                     $communicationMessage->setType($smsSender::UNICODE_CHARSET);
  281.                                     $entityManager->persist($communicationMessage);
  282.                                 }else {
  283.                                     
  284.                                     $response = $smsSender->sendSmsByEstablishment($establishment, $message, $contacts, $smsSender::UNICODE_CHARSET);
  285.                                     $responses = explode(':', $response);
  286.                                     $code = trim($responses[1]);
  287.             
  288.                                     $communicationMessage = new CommunicationMessage();
  289.                                     $communicationMessage->setCode($code);
  290.                                     $communicationMessage->setContacts($contacts);
  291.                                     $communicationMessage->setContent($message);
  292.                                     $communicationMessage->setEstablishment($establishment);
  293.                                     $communicationMessage->setType($smsSender::UNICODE_CHARSET);
  294.                                     $entityManager->persist($communicationMessage);
  295.                                 }
  296.                             }
  297.                         //}
  298.                         
  299.                     }
  300.                     $success++;
  301.                 }
  302.             }
  303.         }
  305.         try {
  306.             $entityManager->flush();
  307.             $this->addFlash('success', $success. " SMS envoyé(s)");
  308.             return $this->json(['code' => 200, 'message' => $success. " SMS envoyé(s)"], 200);
  309.         } catch (\Throwable $th) {
  310.             $this->addFlash('warning', $th->getMessage());
  311.         }
  312.         
  313.         $this->addFlash('warning', "Traitement non effectuée");
  314.         return $this->json(['code' => 500, 'message' => "Traitement non effectuée"], 200);
  315.     }
  316. }