Symfony Profiler

<?php
namespace App\Controller;
use App\Entity\Company;
use App\Repository\CountryRepository;
use App\Repository\RegionRepository;
use App\Repository\PrefectureRepository;
use App\Repository\JobOfferRepository;
use App\Repository\JobAppliedRepository;
use App\Repository\SchoolRepository;
use App\Services\DashboardService;
use App\Services\CompanyService;
use DateTime;
use Doctrine\ORM\EntityManagerInterface;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\IsGranted;
use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use Symfony\Bundle\FrameworkBundle\Controller\Controller;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\Security;
use Symfony\Component\Routing\Annotation\Route;
use Symfony\Contracts\Translation\TranslatorInterface;
#[Route('/dashboard')]
#[Security("is_granted('ROLE_ADMIN')
or is_granted('ROLE_ADMIN_PAYS')
or is_granted('ROLE_ADMIN_REGIONS')
or is_granted('ROLE_ADMIN_VILLES')
or is_granted('ROLE_LEGISLATEUR')
or is_granted('ROLE_DIRECTEUR')
or is_granted('ROLE_ETABLISSEMENT')
or is_granted('ROLE_PRINCIPAL')
or is_granted('ROLE_ENTREPRISE')
or is_granted('ROLE_DIPLOME')
")]
class DashboardController extends AbstractController {
private EntityManagerInterface $em;
private CountryRepository $countryRepository;
private RegionRepository $regionRepository;
private PrefectureRepository $prefectureRepository;
private JobOfferRepository $jobOfferRepository;
private SchoolRepository $schoolRepository;
private JobAppliedRepository $jobAppliedRepository;
private DashboardService $dashboardService;
private CompanyService $companyService;
private TranslatorInterface $translator;
public function __construct(
EntityManagerInterface $em,
CountryRepository $countryRepository,
RegionRepository $regionRepository,
PrefectureRepository $prefectureRepository,
JobOfferRepository $jobOfferRepository,
SchoolRepository $schoolRepository,
JobAppliedRepository $jobAppliedRepository,
DashboardService $dashboardService,
CompanyService $companyService,
TranslatorInterface $translator
) {
$this->em = $em;
$this->countryRepository = $countryRepository;
$this->regionRepository = $regionRepository;
$this->prefectureRepository = $prefectureRepository;
$this->jobOfferRepository = $jobOfferRepository;
$this->jobAppliedRepository = $jobAppliedRepository;
$this->schoolRepository = $schoolRepository;
$this->dashboardService = $dashboardService;
$this->companyService = $companyService;
$this->translator = $translator;
}
#[Route(path: '/', name: 'dashboard_index', methods: ['GET', 'POST'])]
public function indexAction(Request $request): Response {
$this->cleanJobApplied();
if ($this->getUser()->getCompany()) {
if(!$this->getUser()->getCompany()->getAgreeRgpd())
return $this->redirectToRoute('front_company_edit');
if(!$this->companyService->checkSatisfaction($this->getUser()->getCompany()))
return $this->redirectToRoute('front_company_satisfactioncompany_new');
}
return $this->dashboardService->checkAccountBefore(function () use ($request) {
$validCountries = $this->countryRepository->findBy(['valid' => 'true']);
if (!$validCountries) {
$validCountries = $this->countryRepository->findAll();
} else {
$userCountry = $this->getUser()->getCountry();
if ($userCountry)
$validCountries = $this->countryRepository->findById($userCountry);
}
$validRegions = [];
foreach ($validCountries as $validCountry) {
$regions = $this->regionRepository->findBy(['country' => $validCountry]);
$validRegions = array_merge($validRegions, $regions);
}
$validPrefectures = [];
foreach ($validRegions as $validRegion) {
$prefectures = $this->prefectureRepository->findBy(['region' => $validRegion]);
$validPrefectures = array_merge($validPrefectures, $prefectures);
}
// Récupération de la date de référence pour l'intervalle de temps, par défaut = date courante
$referenceDateTxt = $request->request->get('referenceDate');
$session = $request->getSession();
if (!$referenceDateTxt && $session->has('referenceDate')) {
$referenceDateTxt = $session->get('referenceDate');
}
if (!$referenceDateTxt) {
$referenceDateTxt = (new DateTime())->format('Y-m-d');
}
$session->set('referenceDate', $referenceDateTxt);
$referenceDate = (new \DateTime($referenceDateTxt))->format('Y-m-d');
// Récupération de la date de début pour l'intervalle de temps, par défaut = date courante
$startDateTxt = $request->request->get('beginDate');
if (!$startDateTxt && $session->has('beginDate')) {
$startDateTxt = $session->get('beginDate');
}
if (!$startDateTxt) {
$startDateTxt = (new DateTime())->sub(new \DateInterval('P3Y'))->format('Y-m-d');
}
$session->set('beginDate', $startDateTxt);
$startDate = (new \DateTime($startDateTxt))->format('Y-m-d');
// Récupération de l'intervalle de temps sélectionné par le formulaire et renvoie la date du premier jour */
$selectedDuration = $request->request->get('selectDuration');
if ($selectedDuration) {
$session->set('selectDuration', $selectedDuration);
}
// Sinon récupération par la variable de session, sinon paramétrage à 3 mois
if (!$selectedDuration) {
$selectedDuration = ($session->has('selectDuration')) ? $session->get('selectDuration') : '3 ans';
}
$idSelectCountry = $request->request->get('selectCountry');
if ($idSelectCountry) {
$session->set('pays', $idSelectCountry);
} else {
if ($session->has('pays')) {
$idSelectCountry = $session->get('pays');
}
}
if (!$idSelectCountry) {
foreach ($validCountries as $country) {
$idSelectCountry = $country->getId();
}
}
$idSelectRegion = $request->request->get('selectRegion');
if ($idSelectRegion) {
$session->set('region', $idSelectRegion);
}
$idSelectPrefecture = $request->request->get('selectPrefecture');
if ($idSelectPrefecture) {
$session->set('prefecture', $idSelectPrefecture);
}
// adaptation aux multi administrateurs
if ($this->getUser()->hasRole('ROLE_ADMIN') or
$this->getUser()->hasRole('ROLE_DIRECTEUR')) {
//nothing to do, validRegions all regions
} else if ($this->getUser()->hasRole('ROLE_ADMIN_PAYS') or
$this->getUser()->hasRole('ROLE_LEGISLATEUR')) {
$validRegions = $this->getUser()->getCountry()->getRegions();
} else if ($this->getUser()->hasRole('ROLE_ADMIN_REGIONS')) {
$validRegions = $this->getUser()->getAdminRegions();
} else if ($this->getUser()->hasRole('ROLE_ADMIN_VILLES')) {
$validRegions = [];
$selectedCities = $this->getUser()->getAdminCities();
foreach ($selectedCities as $selectedCity){
if($selectedCity) {
$regionExist = false;
foreach ($validRegions as $validRegion) {
if ($validRegion->getId() == $selectedCity->getRegion()->getId()) {
$regionExist = true;
}
}
if (!$regionExist) {
$validRegions[] = $selectedCity->getRegion();
}
}
}
} else {
// adpatation for Actors
if($_ENV['STRUCT_PROVINCE_COUNTRY_CITY'] == 'true') {
$validRegions = [];
if($this->getUser()->getRegion())
$validRegions[] = $this->getUser()->getRegion();
}
}
$userSchool = $this->getUser()->getSchool() ;
// only for Principal Role
if($this->getUser()->getPrincipalSchool()) {
$userSchool = $this->schoolRepository->find($this->getUser()->getPrincipalSchool());
if($_ENV['STRUCT_PROVINCE_COUNTRY_CITY'] == 'true') {
if($userSchool->getCity()) {
if(!$validRegions)
$validRegions[] = $userSchool->getCity()->getRegion();
$idSelectRegion = $userSchool->getCity()->getRegion()->getId();
}
}
}
return $this->render('Dashboard/index.html.twig', [
'countries' => $validCountries,
'regions' => $validRegions,
'prefectures' => $validPrefectures,
'idSelectedCountry' => $idSelectCountry,
'idSelectedRegion' => $idSelectRegion,
'idSelectedPrefecture' => $idSelectPrefecture,
'selectedDuration' => $selectedDuration,
'startDate' => $startDate,
'referenceDate' => $referenceDate,
'userSchool' => $userSchool,
]);
});
}
#[Route(path: '/export_pdf', name: 'export_pdf_index', methods: ['GET'])]
public function exportPdfAction(): Response {
return $this->redirectToRoute('dashboard_index');
}
/**
* clean the table of job Applied when appliedDate is too old
* @return void
*/
private function cleanJobApplied (): void {
$dateStr = date('Y', strtotime("-3 year")) . "-01-01";
$date = date_create_from_format('Y-m-d', $dateStr);
$jobsApplied = $this->jobAppliedRepository->findBeforeYear($date);
foreach ($jobsApplied as $jobApplied) {
$this->em->remove($jobApplied);
$this->em->flush();
}
if($jobsApplied) {
$this->addFlash('warning', $this->translator->trans('flashbag.number_removed_from_jobs_applied', ['{number}' => date('Y', strtotime("-3 year"))]));
}
}
}

src/Controller/DashboardController.php line 74