Symfony Profiler

<?php
namespace App\Controller;
use App\Entity\Student;
use App\Entity\Subscription;
use App\Entity\ClassRoom;
use App\Form\StudentType;
use App\Repository\StudentRepository;
use App\Repository\EvaluationRepository;
use App\Repository\SequenceRepository;
use App\Repository\MarkRepository;
use Knp\Snappy\Pdf;
use App\Repository\SchoolYearRepository;
use App\Repository\SubscriptionRepository;
use App\Repository\PaymentRepository;
use App\Repository\QuaterRepository;
use App\Repository\InstallmentRepository;
use App\Repository\PaymentPlanRepository;
use App\Repository\MainTeacherRepository;
use Doctrine\ORM\EntityManagerInterface;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
use Symfony\Component\Routing\Annotation\Route;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\Method;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\ParamConverter;
use App\Service\SchoolYearService;
use App\Entity\User;
/**
* Studentme controller.
*
* @Route("/prof/students")
*/
class StudentController extends AbstractController
{
private EntityManagerInterface $em;
private $repo;
private $scRepo;
private $seqRepo;
private SubscriptionRepository $subRepo;
private $markRepo;
private $evalRepo;
private $qtRepo;
private $snappy;
private SchoolYearService $schoolYearService;
private PaymentPlanRepository $ppRepo;
private InstallmentRepository $instRepo;
private PaymentRepository $pRepo;
private MainTeacherRepository $mainTeacherRepo;
public function __construct(
PaymentRepository $pRepo,
InstallmentRepository $instRepo,
PaymentPlanRepository $ppRepo,
SchoolYearService $schoolYearService,
EntityManagerInterface $em,
SubscriptionRepository $subRepo,
MarkRepository $markRepo,
EvaluationRepository $evalRepo,
StudentRepository $repo,
SequenceRepository $seqRepo,
SchoolYearRepository $scRepo,
QuaterRepository $qtRepo,
MainTeacherRepository $mainTeacherRepo,
Pdf $snappy
) {
$this->em = $em;
$this->repo = $repo;
$this->scRepo = $scRepo;
$this->markRepo = $markRepo;
$this->seqRepo = $seqRepo;
$this->evalRepo = $evalRepo;
$this->subRepo = $subRepo;
$this->qtRepo = $qtRepo;
$this->snappy = $snappy;
$this->ppRepo = $ppRepo;
$this->pRepo = $pRepo;
$this->instRepo = $instRepo;
$this->mainTeacherRepo = $mainTeacherRepo;
$this->schoolYearService = $schoolYearService;
}
// =========================================================
// CORRECTION 2 : méthode privée mutualisée pour l'auth
// Remplace les 6 lignes répétées dans chaque action
// =========================================================
private function checkAuth(): ?Response
{
if (!$this->getUser()) {
$this->addFlash('warning', 'You need login first!');
return $this->redirectToRoute('app_login');
}
/** @var User $user */
$user = $this->getUser();
if (!$user->isVerified()) {
$this->addFlash('warning', 'You need to have a verified account!');
return $this->redirectToRoute('app_login');
}
return null;
}
/**
* @Route("/create", name="admin_students_new", methods={"GET","POST"})
*/
public function create(Request $request): Response
{
if ($redirect = $this->checkAuth()) return $redirect;
$student = new Student();
$form = $this->createForm(StudentType::class, $student);
$numero = $this->repo->getNumeroDispo();
$student->setMatricule($numero);
$form->handleRequest($request);
if ($form->isSubmitted() && $form->isValid()) {
if ($student->getEntryClass() != null) {
$sub = new Subscription();
$sub->setStudent($student);
$sub->setClassRoom($student->getEntryClass());
$sub->setSchoolYear($this->schoolYearService->sessionYearById());
$this->em->persist($sub);
}
$this->em->persist($student);
$this->em->flush();
$this->addFlash('success', 'Student succesfully created');
return $this->redirectToRoute('admin_students', [
'type' => "new_students_not_yet_registered_checkbox",
]);
}
return $this->render('student/new.html.twig', ['form' => $form->createView()]);
}
/**
* Lists all Studentme entities.
*
* @Route("/{type}", name="admin_students")
* @Method("GET")
* @Template()
*/
public function indexAction($type)
{
if ($redirect = $this->checkAuth()) return $redirect;
$year = $this->schoolYearService->sessionYearById();
switch ($type) {
case "new_students_not_yet_registered_checkbox":
$students = $this->repo->findNewStudents($year);
break;
case "new_registered_students_checkbox":
$students = $this->repo->findNewRegisteredStudents($year);
break;
case "registered_former_students_checkbox":
$students = $this->repo->findFormerRegisteredStudents($year);
break;
case "complete_registered_students_checkbox":
// CORRECTION 1 : $year passé en argument (Option B appliquée dans le repo)
$students = $this->repo->findEnrolledStudentsThisYear2($year);
break;
default:
$students = $this->repo->findEnrolledStudentsThisYear2();
break;
}
return $this->render('student/list.html.twig', compact("students"));
}
/**
* @Route("/{id}/unregister/{room_id}", name="admin_students_unregister", requirements={"id"="\d+", "room_id"="\d+"})
* @ParamConverter("std", options={"mapping": {"id": "id"}})
* @ParamConverter("room", options={"mapping": {"room_id": "id"}})
*/
public function unregisterAction(Student $std, ClassRoom $room)
{
if ($redirect = $this->checkAuth()) return $redirect;
$year = $this->schoolYearService->sessionYearById();
$sub = $this->subRepo->findOneBy(["student" => $std, "classRoom" => $room, "schoolYear" => $year]);
$this->em->remove($sub);
$this->em->flush();
return $this->redirectToRoute('admin_classrooms_show', ["id" => $room->getId()]);
}
/**
* Finds and displays a Studentme entity.
*
* @Route("/{id}/show", name="admin_students_show", requirements={"id"="\d+"})
* @Method("GET")
* @Template()
*/
public function showAction(Student $student)
{
if ($redirect = $this->checkAuth()) return $redirect;
$year = $this->schoolYearService->sessionYearById();
$seq = $this->seqRepo->findOneBy(["activated" => true]);
$sub = $this->subRepo->findOneBy(["student" => $student, "schoolYear" => $year]);
$results = [
'student' => $student,
'cours' => null,
'session1' => null,
'session2' => null,
'session3' => null,
'session4' => null,
'session5' => null,
'session6' => null,
];
$payments = $this->pRepo->findBy(["subscription" => $sub], ['updatedAt' => 'ASC']);
$paymentPlan = $this->ppRepo->findOneBy(["schoolYear" => $year]);
if ($sub != null) {
$installments = $this->instRepo->findBy(["paymentPlan" => $paymentPlan, "classRoom" => $sub->getClassRoom()]);
} else {
$installments = $this->instRepo->findBy(["paymentPlan" => $paymentPlan]);
}
$seqs = $this->seqRepo->findSequenceThisYear($year);
$evalSeqs = [];
if ($sub != null) {
foreach ($seqs as $seq) {
$evalSeqs[$seq->getId()] = $this->evalRepo->findBy([
"classRoom" => $sub->getClassRoom(),
"sequence" => $seq,
]);
}
$courses = [];
$averageSeqs = [];
foreach ($evalSeqs[$seq->getId()] as $eval) {
$courses[] = $eval->getCourse()->getWording();
}
foreach ($seqs as $seq) {
$average = [];
foreach ($evalSeqs[$seq->getId()] as $eval) {
$mark = $this->markRepo->findOneBy(["student" => $student, "evaluation" => $eval]);
if ($mark) {
$average[] = $mark->getValue();
}
}
$averageSeqs[$seq->getId()] = $average;
}
$filename = "assets/images/student/" . $student->getMatricule() . ".jpg";
$file_exists = file_exists($filename);
$results['payments'] = $payments;
$results['payment_plan'] = $paymentPlan;
$results['installments'] = $installments;
$results['sub'] = $sub;
$results['file_exists'] = $file_exists;
$results['cours'] = json_encode($courses);
foreach ($seqs as $seq) {
$results[strtolower($seq->getWording())] = json_encode($averageSeqs[$seq->getId()]);
}
}
return $this->render('student/show.html.twig', $results);
}
/**
* Displays a form to edit an existing Studentme entity.
*
* @Route("/{id}/edit", name="admin_students_edit", requirements={"id"="\d+"}, methods={"GET","PUT"})
* @Template()
*/
public function edit(Request $request, Student $student): Response
{
if ($redirect = $this->checkAuth()) return $redirect;
$form = $this->createForm(StudentType::class, $student, ['method' => 'PUT']);
$form->handleRequest($request);
if ($form->isSubmitted() && $form->isValid()) {
$this->em->flush();
$this->addFlash('success', 'Student succesfully updated');
$year = $this->schoolYearService->sessionYearById();
$sub = $this->subRepo->findOneBy(["student" => $student, "schoolYear" => $year]);
return $this->redirectToRoute('admin_classrooms_show', ["id" => $sub->getClassRoom()->getId()]);
}
return $this->render('student/edit.html.twig', [
'student' => $student,
'form' => $form->createView(),
]);
}
/**
* Deletes a Studentme entity.
*
* @Route("/{id}/delete", name="admin_students_delete", requirements={"id"="\d+"}, methods={"DELETE"})
*/
public function delete(Student $student, Request $request): Response
{
if ($redirect = $this->checkAuth()) return $redirect;
if ($this->isCsrfTokenValid('students_deletion' . $student->getId(), $request->request->get('csrf_token'))) {
$this->em->remove($student);
$this->em->flush();
$this->addFlash('info', 'Student succesfully deleted');
}
return $this->redirectToRoute('admin_students', [
'type' => "new_students_not_yet_registered_checkbox",
]);
}
/**
* Build student's school certificate
*
* @Route("/{id}/certificate", name="admin_student_certificate", requirements={"id"="\d+"})
*/
public function schoolCertificate(Pdf $pdf, Student $std): Response
{
if ($redirect = $this->checkAuth()) return $redirect;
$year = $this->schoolYearService->sessionYearById();
$sub = $this->subRepo->findOneBy(["student" => $std, "schoolYear" => $year]);
$html = $this->renderView('student/school_certificate.html.twig', [
'year' => $year,
'std' => $std,
'sub' => $sub,
]);
return new Response($pdf->getOutputFromHtml($html), 200, [
'Content-Type' => 'application/pdf',
'Content-Disposition' => 'inline; filename="certif_' . $std->getMatricule() . '.pdf"',
]);
}
/**
* @Route("/{id}/receipt", name="admin_student_receipt", requirements={"id"="\d+"})
*/
public function tuitionReceiptAction(Pdf $pdf, Student $std): Response
{
if ($redirect = $this->checkAuth()) return $redirect;
$year = $this->schoolYearService->sessionYearById();
$sub = $this->subRepo->findOneBy(["student" => $std, "schoolYear" => $year]);
$payments = $this->pRepo->findBy(["subscription" => $sub], ['updatedAt' => 'ASC']);
$paymentPlan = $this->ppRepo->findOneBy(["schoolYear" => $year]);
$installments = $this->instRepo->findBy(["paymentPlan" => $paymentPlan, "classRoom" => $sub->getClassRoom()]);
$html = $this->renderView('student/templating/tuition_receipt.html.twig', [
'year' => $year,
'std' => $std,
'sub' => $sub,
'payments' => $payments,
'payment_plan' => $paymentPlan,
'installments' => $installments,
]);
return new Response($pdf->getOutputFromHtml($html), 200, [
'Content-Type' => 'application/pdf',
'Content-Disposition' => 'inline; filename="recu_' . $std->getMatricule() . '.pdf"',
]);
}
/**
* @Route("/{id}/badge", name="admin_student_badge", requirements={"id"="\d+"})
*/
public function schoolBadge(Pdf $pdf, Student $std): Response
{
if ($redirect = $this->checkAuth()) return $redirect;
$year = $this->schoolYearService->sessionYearById();
$sub = $this->subRepo->findOneBy(["student" => $std, "schoolYear" => $year]);
$filename = "assets/images/student/" . $std->getMatricule() . ".jpg";
$fileExist = file_exists($filename);
$html = $this->renderView('student/badge.html.twig', [
'sub' => $sub,
'fileExist' => $fileExist,
]);
return new Response($pdf->getOutputFromHtml($html), 200, [
'Content-Type' => 'application/pdf',
'Content-Disposition' => 'inline; filename="badge_' . $std->getMatricule() . '.pdf"',
]);
}
/**
* @Route("/{id}/reportCardTrim2024", name="admin_students_reportcards_quat_2024", requirements={"id"="\d+"})
* @Method("GET")
* @Template()
*/
public function reporCardTrimAction2024(Pdf $pdf, Student $std, Request $request)
{
if ($redirect = $this->checkAuth()) return $redirect;
$headerFontSize = $request->request->get('header_font_size');
$lineHeight = $request->request->get('line_height');
$copyright = $request->request->get('copyright') == "on";
$connection = $this->em->getConnection();
$year = $this->schoolYearService->sessionYearById();
$sub = $this->subRepo->findOneBy(["student" => $std, "schoolYear" => $year]);
$quater = $this->qtRepo->findOneBy(["activated" => true]);
$students = $this->repo->findEnrolledStudentsThisYearInClass($sub->getClassRoom(), $year);
$mainTeacher = $this->mainTeacherRepo->findOneBy([
"classRoom" => $sub->getClassRoom(),
"schoolYear" => $year,
])->getTeacher();
$filename = "assets/images/student/" . $std->getMatricule() . ".jpg";
$fileExist = file_exists($filename);
$query = "SELECT DISTINCT sequence.id as sequence, course.id as course_id, course.wording, course.coefficient,
mark.value, mark.weight, mark.rank2, evaluation.mini as mini, evaluation.maxi as maxi,
evaluation.competence, attribution.teacher_id, school_year.id, user.full_name
FROM sequence
JOIN evaluation ON evaluation.sequence_id = sequence.id
JOIN course ON evaluation.course_id = course.id
JOIN attribution ON attribution.course_id = course.id
JOIN user ON user.id = attribution.teacher_id
JOIN mark ON evaluation.id = mark.evaluation_id
JOIN quater ON sequence.quater_id = quater.id
JOIN school_year ON quater.school_year_id = school_year.id AND school_year.id = attribution.year_id
WHERE quater.id = :quater_id AND mark.student_id = :student_id
ORDER BY course.id, sequence.id";
$params = [
'quater_id' => $quater->getId(),
'student_id' => $std->getId(),
];
$result = $connection->executeQuery($query, $params);
$data = $result->fetchAllAssociative();
$html = $this->renderView('student/reportcard/quaterly_2024.html.twig', [
'year' => $year,
'quater' => $quater,
'mainTeacher' => $mainTeacher,
'data' => $data,
'std' => $std,
'students' => $students,
'room' => $sub->getClassRoom(),
'lineHeight' => 0.75 * $lineHeight,
'headerFontSize' => 0.75 * $headerFontSize,
'copyright' => $copyright,
'fileExist' => $fileExist,
]);
return new Response($pdf->getOutputFromHtml($html), 200, [
'Content-Type' => 'application/pdf',
'Content-Disposition' => 'inline; filename="bull_' . $quater->getId() . '_' . $std->getMatricule() . '.pdf"',
]);
}
/**
* @Route("/{id}/reportCardTrim", name="admin_students_reportcards_quat", requirements={"id"="\d+"})
* @Method("GET")
* @Template()
*/
public function reporCardTrimAction(Pdf $pdf, Student $std)
{
if ($redirect = $this->checkAuth()) return $redirect;
$connection = $this->em->getConnection();
$year = $this->schoolYearService->sessionYearById();
$sub = $this->subRepo->findOneBy(["student" => $std, "schoolYear" => $year]);
$quater = $this->qtRepo->findOneBy(["activated" => true]);
$sequences = $this->seqRepo->findBy(["quater" => $quater]);
$filename = "assets/images/student/" . $std->getMatricule() . ".jpg";
$fileExist = file_exists($filename);
// CORRECTION 3 : execute() déprécié → executeStatement()
$i = 1;
foreach ($sequences as $seq) {
$sql = "CREATE OR REPLACE VIEW V_STUDENT_MARK_SEQ" . $i . " AS
SELECT DISTINCT eval.id as eval, crs.id as crs, room.id as room,
teach.full_name as teacher, modu.id as module, m.value as value, m.weight as weight
FROM mark m
JOIN student std ON m.student_id = std.id
JOIN evaluation eval ON m.evaluation_id = eval.id
JOIN class_room room ON eval.class_room_id = room.id
JOIN course crs ON eval.course_id = crs.id
JOIN attribution att ON att.course_id = crs.id
JOIN user teach ON att.teacher_id = teach.id
JOIN module modu ON modu.id = crs.module_id
JOIN sequence seq ON seq.id = eval.sequence_id
WHERE std.id = ? AND eval.sequence_id = ?
ORDER BY crs.id";
$connection->executeStatement($sql, [$std->getId(), $seq->getId()]);
$i++;
}
$connection->executeStatement(
"CREATE OR REPLACE VIEW V_STUDENT_MARK_QUATER AS
SELECT DISTINCT seq1.crs as crs,
(seq1.value * seq1.weight + seq2.value * seq2.weight) / (seq1.weight + seq2.weight) as value,
greatest(seq1.weight, seq2.weight) as weight,
seq1.weight as weight1, seq2.weight as weight2,
seq1.value as value1, seq2.value as value2,
seq1.teacher as teacher, seq1.module as module, seq1.room as room
FROM V_STUDENT_MARK_SEQ1 seq1
JOIN V_STUDENT_MARK_SEQ2 seq2 ON seq1.crs = seq2.crs
ORDER BY seq1.crs"
);
// CORRECTION 3 : fetchAll() déprécié → fetchAllAssociative()
$dataQuater = $connection->executeQuery("SELECT * FROM V_STUDENT_MARK_QUATER")->fetchAllAssociative();
$html = $this->renderView('student/reportcardTrimApc.html.twig', [
'year' => $year,
'quater' => $quater,
'data' => $dataQuater,
'sequences' => $sequences,
'std' => $std,
'room' => $sub->getClassRoom(),
'fileExist' => $fileExist,
]);
return new Response($pdf->getOutputFromHtml($html), 200, [
'Content-Type' => 'application/pdf',
'Content-Disposition' => 'inline; filename="bull_' . $quater->getId() . '_' . $std->getMatricule() . '.pdf"',
]);
}
/**
* @Route("/{id}/reportCardYear", name="admin_students_reportcards_year", requirements={"id"="\d+"})
* @Method("GET")
* @Template()
*/
public function reporCardYear(Student $std, Request $request)
{
if ($redirect = $this->checkAuth()) return $redirect;
$headerFontSize = $request->request->get('header_font_size');
$lineHeight = $request->request->get('line_height');
$copyright = $request->request->get('copyright') == "on";
$connection = $this->em->getConnection();
$year = $this->schoolYearService->sessionYearById();
$sequences = $this->seqRepo->findSequenceThisYear($year);
$sub = $this->subRepo->findOneBy(["student" => $std, "schoolYear" => $year]);
$filename = "assets/images/student/" . $std->getMatricule() . ".jpg";
$fileExist = file_exists($filename);
// CORRECTION 3 : execute() déprécié → executeStatement()
$i = 1;
foreach ($sequences as $seq) {
$sql = "CREATE OR REPLACE VIEW V_STUDENT_MARK_SEQ" . $i . " AS
SELECT DISTINCT eval.id as eval, crs.id as crs, room.id as room, year.id as year,
teach.id as teacher, modu.id as module, m.value as value, m.weight as weight
FROM mark m
JOIN student std ON m.student_id = std.id
JOIN evaluation eval ON m.evaluation_id = eval.id
JOIN class_room room ON eval.class_room_id = room.id
JOIN course crs ON eval.course_id = crs.id
JOIN attribution att ON att.course_id = crs.id
JOIN user teach ON att.teacher_id = teach.id
JOIN module modu ON modu.id = crs.module_id
JOIN sequence seq ON seq.id = eval.sequence_id
JOIN quater quat ON seq.quater_id = quat.id
JOIN school_year year ON quat.school_year_id = year.id
WHERE std.id = ? AND room.id = ? AND eval.sequence_id = ?
ORDER BY crs.id";
$connection->executeStatement($sql, [$std->getId(), $sub->getClassRoom()->getId(), $seq->getId()]);
$i++;
}
$connection->executeStatement(
"CREATE OR REPLACE VIEW V_STUDENT_MARK_QUATER1 AS
SELECT DISTINCT seq1.crs as crs,
(seq1.value * seq1.weight + seq2.value * seq2.weight) / (seq1.weight + seq2.weight) as value,
greatest(seq1.weight, seq2.weight) as weight,
seq1.teacher as teacher, seq1.module as modu, seq1.room as room
FROM V_STUDENT_MARK_SEQ1 seq1
JOIN V_STUDENT_MARK_SEQ2 seq2 ON seq1.crs = seq2.crs
ORDER BY seq1.crs"
);
$connection->executeStatement(
"CREATE OR REPLACE VIEW V_STUDENT_MARK_QUATER2 AS
SELECT DISTINCT seq1.crs as crs,
(seq1.value * seq1.weight + seq2.value * seq2.weight) / (seq1.weight + seq2.weight) as value,
greatest(seq1.weight, seq2.weight) as weight,
seq1.teacher as teacher, seq1.module as modu, seq1.room as room
FROM V_STUDENT_MARK_SEQ3 seq1
JOIN V_STUDENT_MARK_SEQ4 seq2 ON seq1.crs = seq2.crs
ORDER BY seq1.crs"
);
$connection->executeStatement(
"CREATE OR REPLACE VIEW V_STUDENT_MARK_QUATER3 AS
SELECT DISTINCT seq1.crs as crs,
(seq1.value * seq1.weight + seq2.value * seq2.weight) / (seq1.weight + seq2.weight) as value,
greatest(seq1.weight, seq2.weight) as weight,
seq1.teacher as teacher, seq1.module as modu, seq1.room as room
FROM V_STUDENT_MARK_SEQ5 seq1
JOIN V_STUDENT_MARK_SEQ6 seq2 ON seq1.crs = seq2.crs
ORDER BY seq1.crs"
);
$connection->executeStatement(
"CREATE OR REPLACE VIEW ANNUAL_DATA AS
SELECT DISTINCT
course.wording as course, course.coefficient as coef,
module.name as module,
user.full_name as teacher,
quat1.value as value1, quat1.weight as weight1,
quat2.value as value2, quat2.weight as weight2,
quat3.value as value3, quat3.weight as weight3,
(quat1.value * quat1.weight + quat2.value * quat2.weight + quat3.value * quat3.weight)
/ (quat1.weight + quat2.weight + quat3.weight) as value
FROM V_STUDENT_MARK_QUATER1 quat1
JOIN class_room ON class_room.id = quat1.room
JOIN course ON course.id = quat1.crs
JOIN module ON course.module_id = quat1.modu
JOIN user ON user.id = quat1.teacher
JOIN V_STUDENT_MARK_QUATER2 quat2 ON quat1.crs = quat2.crs
JOIN V_STUDENT_MARK_QUATER3 quat3 ON quat2.crs = quat3.crs
ORDER BY module"
);
// CORRECTION 3 : fetchAll() déprécié → fetchAllAssociative()
$dataYear = $connection->executeQuery("SELECT * FROM ANNUAL_DATA")->fetchAllAssociative();
$html = $this->renderView('student/reportcardYearApc.html.twig', [
'year' => $year,
'data' => $dataYear,
'std' => $std,
'room' => $sub->getClassRoom(),
'headerFontSize' => 0.75 * $headerFontSize,
'lineHeight' => 1.5 * $lineHeight,
'copyright' => $copyright,
'fileExist' => $fileExist,
]);
return new Response($this->snappy->getOutputFromHtml($html), 200, [
'Content-Type' => 'application/pdf',
'Content-Disposition' => 'attachment; filename="BUL_ANN_' . $std->getMatricule() . '.pdf"',
]);
}
}

src/Controller/StudentController.php line 196