Symfony Profiler

<?php
namespace App\Controller;
use App\Entity\Faqs;
use App\Entity\Blogs;
use App\Entity\Avis;
use App\Entity\Themes;
use App\Entity\Galeries;
use App\Entity\Villes;
use App\Entity\Thematiques;
use App\Entity\Actualites;
use App\Entity\Formations;
use App\Entity\References;
use App\Entity\Mentions;
use App\Entity\Managements;
use App\Entity\Bannieres;
use App\Entity\Inscriptions;
use App\Entity\Demandeformations;
use App\Entity\Expertises;
use App\Entity\Themeshanghai;
use App\Entity\Videos;
use App\Entity\Albums;
use App\Form\RechercheFormType;
use App\Form\RechercheNatFormType;
use Doctrine\ORM\EntityManager;
use App\Form\BlogFormType;
use App\Form\ProduitFormType;
use App\Form\InscriptionFormType;
use App\Form\NewInscriptionFormType;
use App\Service\GeoIpService;
use App\Repository\BlogsRepository;
use App\Repository\DemandeformationsRepository;
use App\Repository\InscriptionsRepository;
use App\Repository\AvisRepository;
use App\Repository\ManagementsRepository;
use App\Repository\MentionsRepository;
use App\Repository\VillesRepository;
use App\Repository\GaleriesRepository;
use App\Repository\ThemesRepository;
use App\Repository\FormationsRepository;
use App\Repository\AboutsRepository;
use App\Repository\ThematiquesRepository;
use App\Repository\ValeursRepository;
use App\Repository\BannieresRepository;
use App\Repository\ActualitesRepository;
use App\Repository\PartenairesRepository;
use App\Repository\ReferenceclientsRepository;
use App\Repository\InformationsRepository;
use App\Repository\AlbumsRepository;
use App\Repository\VideosRepository;
use App\Repository\ExpertisesRepository;
use App\Repository\ThemeshanghaiRepository;
use App\Entity\Certificats;
use App\Form\CertificatFormType;
use App\Form\EditCertificatFormType;
use App\Repository\CertificatsRepository;
//use Symfony\Component\Mime\Email;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
use Symfony\Component\Routing\Annotation\Route;
use Symfony\Component\String\Slugger\SluggerInterface;
use App\Form\ContactFormType;
use App\Form\DevisFormType;
use App\Form\CombinedFormType;
use App\Form\DemandeformationFormType;
use Symfony\Bridge\Twig\Mime\TemplatedEmail;
use Symfony\Component\Mime\Email;
use Symfony\Component\Mailer\MailerInterface;
use Symfony\Component\HttpFoundation\JsonResponse;
use Knp\Component\Pager\PaginatorInterface;
use Doctrine\ORM\EntityManagerInterface;
use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use Symfony\Component\Security\Http\Authentication\AuthenticationUtils;
use App\Entity\Certyous;
use App\Form\CertyouFormType;
use App\Entity\Inscriptionpersos;
use App\Form\EditCertyouFormType;
use App\Repository\CertyousRepository;
use App\Form\InscriptionCertyouFormType;
use App\Repository\InscriptionpersosRepository;
use App\Entity\Sessions;
use App\Form\SessionFormType;
use App\Form\EditSessionFormType;
use App\Repository\SessionsRepository;
use Symfony\Contracts\HttpClient\HttpClientInterface;
class FrontController extends AbstractController
{
private HttpClientInterface $client;
public function __construct(HttpClientInterface $client)
{
$this->client = $client;
}
#[Route('/', name: 'front.inter.index', methods:['GET'])]
public function index(
Request $request,
MentionsRepository $mentionRepository,
ThematiquesRepository $thematiqueRepository,
BannieresRepository $banniereRepository,
ReferenceclientsRepository $referenceRepository,
EntityManagerInterface $entityManager
): Response
{
$thematiqueLimit = $thematiqueRepository->findBy([], ['id' => 'DESC'], 20 );
//dd($thematiqueLimit);
$annee = date('Y');
// 1️⃣ Requête Doctrine (sans tri sur dates_session)
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select(
'for.id','for.image','for.dates_session','for.prix','for.devise','th.nom',
'th.slug','thm.nom AS thmnom','vil.nom AS vilnom','vil.pays'
)
->from(Formations::class, 'for')
->innerJoin(Themes::class, 'th', 'WITH', 'for.theme = th.id')
->innerJoin(Villes::class, 'vil', 'WITH', 'for.ville = vil.id')
->innerJoin(Thematiques::class, 'thm', 'WITH', 'th.thematique = thm.id');
$formations = $queryBuilder->getQuery()->getResult();
// 2️⃣ Fonction : extraction DATE DE DÉBUT
$extractDateDebut = function (?string $datesSession): ?\DateTime {
if (!$datesSession) {
return null;
}
$moisFr = [
'janv'=>1,'janvier'=>1,
'févr'=>2,'fevr'=>2,'février'=>2,
'mars'=>3,
'avr'=>4,'avril'=>4,
'mai'=>5,
'juin'=>6,
'juil'=>7,'juillet'=>7,
'août'=>8,'aout'=>8,
'sept'=>9,'septembre'=>9,
'oct'=>10,'octobre'=>10,
'nov'=>11,'novembre'=>11,
'déc'=>12,'dec'=>12,'décembre'=>12
];
// Nettoyage
$text = strtolower(trim($datesSession));
$text = str_replace(['.', ','], '', $text);
/**
* Exemples acceptés :
* 23 nov au 04 dec
* 29 juin au 10 juil
* 07 au 18 sept
*/
if (preg_match('/(\d{1,2})\s*(janv|févr|fevr|mars|avr|mai|juin|juil|août|aout|sept|oct|nov|déc)?\s*au\s*\d{1,2}\s*(janv|févr|fevr|mars|avr|mai|juin|juil|août|aout|sept|oct|nov|déc)/i', $text, $m)) {
$jourDebut = (int) $m[1];
$moisDebutTxt = $m[2] ?: $m[3]; // parfois avant, parfois après "au"
$moisDebut = $moisFr[$moisDebutTxt] ?? null;
if (!$moisDebut) {
return null;
}
$today = new \DateTime('today');
$year = (int) $today->format('Y');
$date = new \DateTime(sprintf('%04d-%02d-%02d', $year, $moisDebut, $jourDebut));
// Si la date est déjà passée → année suivante
if ($date < $today) {
$date->modify('+1 year');
}
return $date;
}
return null;
};
$today = new \DateTime('today');
// 3️⃣ Filtrer UNIQUEMENT les formations à venir
$formations = array_filter($formations, function ($f) use ($extractDateDebut) {
return $extractDateDebut($f['dates_session']) !== null;
});
// 4️⃣ Trier : plus proche → plus éloignée
usort($formations, function ($a, $b) use ($extractDateDebut) {
return $extractDateDebut($a['dates_session'])
<=> $extractDateDebut($b['dates_session']);
});
// 5️⃣ Limiter à 3 formations (optionnel)
$formations = array_slice($formations, 0, 3);
//dd($formations);
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select('actu')
->from(Actualites::class, 'actu')
->orderBy('actu.createdat', 'DESC')
->setMaxResults(2);
$actualite = $queryBuilder->getQuery()->getResult();
$reference = $referenceRepository->findAll();
$mentions = $mentionRepository->findAll();
$bannieres = $banniereRepository->findAll();
// dd($mentions);
return $this->render('front/index.html.twig',[
'annee' => $annee,
'banniere' => $bannieres,
'mentions' => $mentions,
'reference' => $reference,
'formations' => $formations,
'thematiqueLimit' => $thematiqueLimit,
'actualite' => $actualite
]);
}
#[Route('/mediatheque/albums', name: 'front.inter.album', methods:['GET'])]
public function album(
Request $request,
PaginatorInterface $paginator,
AlbumsRepository $albumRepository,
VideosRepository $videoRepository,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select('al, MIN(g.imgGal) AS image')
->from(Albums::class, 'al')
->innerJoin(Galeries::class, 'g', 'WITH', 'al.slug = g.nom')
->where('al.statut = :statut')
->setParameter('statut', 'Publié')
->groupBy('al.id')
->orderBy('al.createdat', 'DESC');
$albums = $queryBuilder->getQuery()->getResult();
//dd($albums);
$pagination = $paginator->paginate(
$queryBuilder,
$request->query->getInt('page', 1),
12
);
/*$albums = $albumRepository->findAll();
$videos = $videoRepository->findAll();*/
$mentions = $mentionRepository->findAll();
return $this->render('front/multimedia/album.html.twig',[
'pagination' => $pagination,
'mentions' => $mentions
]);
}
#[Route('/notre-expertise', name: 'front.inter.expertise', methods:['GET'])]
public function expertise(
Request $request,
ReferenceclientsRepository $referenceRepository,
ExpertisesRepository $expertiseRepository,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
$expertise = $expertiseRepository->findBy(['statut' => 'Publié']);
//dd($expertise);
$mentions = $mentionRepository->findAll();
$reference = $referenceRepository->findAll();
//dd($reference);
return $this->render('front/expertise.html.twig',[
'reference' => $reference,
'expertise' => $expertise,
'mentions' => $mentions
]);
}
#[Route('/mediatheque/album/{slug}', name: 'front.inter.image', methods:['GET'])]
public function galerie(
$slug,
Request $request,
AlbumsRepository $albumRepository,
GaleriesRepository $galerieRepository,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
//$galerie = $galerieRepository->findBy(['nom' => $slug]);
$queryBuilder = $entityManager->createQueryBuilder()
->select('gal.nom, gal.imgGal AS image')
->from(Galeries::class, 'gal')
->where('gal.nom = :slug')
->setParameter('slug', $slug);
$galerie = $queryBuilder->getQuery()->getArrayResult(); // retourne un tableau
$mentions = $mentionRepository->findAll();
return $this->render('front/multimedia/galerie.html.twig',[
'slug' => $slug,
'galeries' => $galerie,
'mentions' => $mentions
]);
}
#[Route('/mediatheque/video', name: 'front.inter.video', methods:['GET'])]
public function video(
Request $request,
VideosRepository $videoRepository,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
$videos = $videoRepository->findBy(
['statut' => 'Publié'],
['createdat' => 'DESC']
);
//dd($videos);
$mentions = $mentionRepository->findAll();
return $this->render('front/multimedia/video.html.twig',[
'videos' => $videos,
'mentions' => $mentions
]);
}
//-----------------------------------------------------------------------------------------------------
#[Route('/formations/certificats/certificats-internationaux-II', name: 'front.inter.certificat.certyou', methods:['GET'])]
public function certificat_certyou(
Request $request,
PaginatorInterface $paginator,
CertyousRepository $certyouRepository,
ManagementsRepository $managementRepository,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
$certyou = $certyouRepository->findAll();
$manageLimit = $managementRepository->findBy([], ['id' => 'DESC'], 10 );
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select(
'cert.id','cert.prixpresentiel','cert.prixvirtuelle',
'cert.devise','cert.theme','cert.duree','cert.slug',
'cert.type','cert.createdat'
)
->from(Certyous::class, 'cert');
$certyous = $queryBuilder->getQuery()->getResult();
$pagination = $paginator->paginate(
$queryBuilder,
$request->query->getInt('page', 1),
12
);
$mentions = $mentionRepository->findAll();
return $this->render('front/certyou.html.twig',[
'manageLimit' => $manageLimit,
'pagination' => $certyous,
'mentions' => $mentions,
]);
}
///---------------------------------------------------------------------------------------------------
#[Route('/formations/certificats/certificats-internationaux-II/{slug}/code{id}', name: 'front.inter.certificat.certyou.inscription', methods:['GET','POST'])]
public function certificat_certyou_inscription(
$id,
$slug,
Request $request,
MailerInterface $mailer,
PaginatorInterface $paginator,
CertyousRepository $certyouRepository,
SessionsRepository $sessionRepository,
ManagementsRepository $managementRepository,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
//$certyou = $certyouRepository->findAll();
$manageLimit = $managementRepository->findBy([], ['id' => 'DESC'], 10 );
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select('cert')
->from(Certyous::class, 'cert')
->where('cert.slug = :slug')
->setParameter('slug', $slug);
$certyou = $queryBuilder->getQuery()->getOneOrNullResult();
if (!$certyou) {
$this->addFlash('danger','Certificat introuvable');
}
$nomTheme = $certyou?->getTheme();
$Inscriptionpersos = new Inscriptionpersos();
$InscriptionCertyouForm = $this->createForm(InscriptionCertyouFormType::class,null, [
'certyou' => $certyou
]);
$InscriptionCertyouForm->handleRequest($request);
if($InscriptionCertyouForm->isSubmitted()){
$theme = str_replace('-', ' ', $slug);
$choix = htmlspecialchars($InscriptionCertyouForm->get('choix')->getData());
$type = htmlspecialchars($InscriptionCertyouForm->get('type')->getData());
$lieux = htmlspecialchars($InscriptionCertyouForm->get('lieu')->getData());
$sessionEntity = $InscriptionCertyouForm->get('session')->getData();
$session = $sessionEntity ? $sessionEntity->getSession() : '';
//$choix = $certyou->getType();
$duree = $certyou->getDuree();
$devise = $certyou->getDevise();
//$duree = htmlspecialchars($InscriptionCertyouForm->get('duree')->getData());
//$prixvirtuelle = htmlspecialchars($InscriptionCertyouForm->get('prixvirtuelle')->getData());
//$prixpresentiel = htmlspecialchars($InscriptionCertyouForm->get('prixpresentiel')->getData());
//$prixVirtuelle = $certificat->getPrixvirtuelle();
//$prixPresentiel = $certificat->getPrixpresentiel();
$civilite = $InscriptionCertyouForm->get('civilite')->getData();
$nom = $InscriptionCertyouForm->get('nom')->getData();
$prenoms = $InscriptionCertyouForm->get('prenoms')->getData();
$fonction = $InscriptionCertyouForm->get('fonction')->getData();
$adresse = $InscriptionCertyouForm->get('adresse')->getData();
$mail = $InscriptionCertyouForm->get('mail')->getData();
$entreprise = $InscriptionCertyouForm->get('entreprise')->getData();
$siteweb = $InscriptionCertyouForm->get('siteweb')->getData();
$nbparticipant = $InscriptionCertyouForm->get('nbparticipant')->getData();
$pays = $InscriptionCertyouForm->get('pays')->getData();
$ville = $InscriptionCertyouForm->get('ville')->getData();
$boitepostale = $InscriptionCertyouForm->get('boitepostale')->getData();
$whatsapp = $InscriptionCertyouForm->get('whatsapp')->getData();
$telephone = $InscriptionCertyouForm->get('telephone')->getData();
$commentaire = $InscriptionCertyouForm->get('commentaire')->getData();
$token = $InscriptionCertyouForm->get('recaptchaToken')->getData();
if ($type === 'presentiel') {
//$prix = 'presentiel ' . $InscriptionCertyouForm->get('prixpresentiel')->getData();
$prix = $certyou->getPrixpresentiel();
} else {
//$prix = 'virtuelle ' . $InscriptionCertyouForm->get('prixvirtuelle')->getData();
$prix = $certyou->getPrixvirtuelle();
}
if ($lieux === '') {
$lieu = 'classe uniquement virtuelle';
} else {
$lieu = $lieux;
}
if(!$commentaire){
$commentaire = " ";
}else{
$commentaire = $InscriptionCertyouForm->get('commentaire')->getData();
}
/*dd($nom ,$prenoms ,$fonction ,$adresse ,$mail ,$entreprise ,$siteweb ,$nbparticipant ,$pays ,$ville ,$boitepostale ,
$whatsapp, $telephone, $theme, $type, $duree, $lieu, $prix, $session, $commentaire);*/
$destinataire = 'inscriptions@cimef-international.org';
$expediteur = $mail;
$reponse = $expediteur;
$suj = "INSCRIPTION FORMATION 2026";
$codehtml = '<html><body>'.
'<table width="100%" cellpadding="0" cellspacing="0" style="background-color:#f4f6f8; padding:20px;">
<tr>
<td align="center">
<table width="600" cellpadding="0" cellspacing="0" style="background-color:#ffffff; border-radius:6px; overflow:hidden; box-shadow:0 2px 6px rgba(0,0,0,0.08);">
<tr>
<td style="background-color:#051a53; padding:20px; color:#ffffff; text-align:center;">
<h2 style="margin:0;">Confirmation d\'inscription</h2>
</td>
</tr>
<tr>
<td style="padding:25px; color:#333333; font-size:14px; line-height:1.6;">
<p>Inscription de '.$civilite.' '.$prenoms.' '.$nom.' à la formation <strong>'.$theme.'</strong> organisée par <strong>CIMEF International</strong>.</p>
<p>Veuillez trouver ci-dessous le récapitulatif :</p>
<hr style="border:none; border-top:1px solid #e0e0e0; margin:20px 0;">
<h4 style="margin-bottom:8px; color:#0d6efd;">Informations personnelles</h4>
<p>
<strong>Nom & Prénoms :</strong> '.$prenoms.' '.$nom.'<br>
<strong>Fonction :</strong> '.$fonction.'<br>
<strong>Entreprise :</strong> '.$entreprise.'<br>
<strong>Adresse :</strong> '.$adresse.'<br>
<strong>Pays / Ville :</strong> '.$pays.' / '.$ville.'<br>
<strong>Boîte postale :</strong> '.$boitepostale.'
</p>
<h4 style="margin-bottom:8px; color:#0d6efd;">Coordonnées</h4>
<p>
<strong>Email :</strong> '.$mail.'<br>
<strong>Téléphone :</strong> '.$telephone.'<br>
<strong>WhatsApp :</strong> '.$whatsapp.'<br>
<strong>Site web :</strong> '.$siteweb.'
</p>
<h4 style="margin-bottom:8px; color:#0d6efd;">Détails de participation</h4>
<p>
<strong>Nombre de participants :</strong> '.$nbparticipant.'<br>
<strong>Commentaire :</strong> '.$commentaire.'
</p>
<h4 style="margin-bottom:8px; color:#0d6efd;">Détail de la formation</h4>
<p>
<strong>Thème :</strong> '.$theme.'<br>
<strong>Type :</strong> '.$type.'<br>
<strong>Durée :</strong> '.$duree.'<br>
<strong>Lieu :</strong> '.$lieu.'<br>
<strong>Prix :</strong> '.$prix.' '.$devise.'<br>
<strong>Session :</strong> '.$session.'
</p>
</td>
</tr>
<tr>
<td style="background-color:#f1f1f1; padding:15px; text-align:center; font-size:12px; color:#777777;">
© '.date("Y").' CIMEF International — Tous droits réservés
</td>
</tr>
</table>
</td>
</tr>
</table>
</body></html>';
$response = $this->client->request(
'POST',
'https://www.google.com/recaptcha/api/siteverify',
[
'body' => [
'secret' => $_ENV['RECAPTCHA_SECRET_KEY'],
'response' => $token,
]
]
);
$result = $response->toArray();
if (!$result['success'] || !isset($result['score']) || $result['score'] < 0.5) {
return $this->addFlash('warning','Vérification reCAPTCHA échouée.');
}
/*
$secretKey = '6LfPYkosAAAAAJQFLCC-9U5bF6KdFTPrgmbxg5Ux';
$value = $request->get('g-recaptcha-response');
if (!$value) {
$this->addFlash('warning', 'Veuillez cocher le reCAPTCHA');
return $this->redirectToRoute('front.seminaire.nationaux',['seminaires' => $seminaires,'slug' => $slug]);
}
$userIP = $_SERVER['REMOTE_ADDR'];
$url = "https://www.google.com/recaptcha/api/siteverify?secret=$secretKey&response=$value&remoteip=$userIP";
$response = \file_get_contents($url);
$response = json_decode((string)$response);
//dd($response);
if(!$response->success){
$this->addFlash('warning','Cocher le champs recaptcha svp!');
return $this->redirectToRoute('front.seminaire.nationaux',['seminaires' => $seminaires,'slug' => $slug]);
}
*/
$email = (new Email())
->from('CIMEF International <inscriptions@cimef-international.org>')
->to($destinataire) // destinataire principal
->cc('medias@cimef-international.com') // COPIE
->replyTo($expediteur) // Reply-To:
->subject($suj)
->text(strip_tags($codehtml))
->html($codehtml);// Subject:
//->html($codehtml, 'text/html'); // Content-Type + charset utf-8
$mailer->send($email);
$Inscriptionpersos->setNom($nom);
$Inscriptionpersos->setPrenoms($prenoms);
$Inscriptionpersos->setFonction($fonction);
$Inscriptionpersos->setAdresse($adresse);
$Inscriptionpersos->setMail($mail);
$Inscriptionpersos->setEntreprise($entreprise);
$Inscriptionpersos->setSiteweb($siteweb);
$Inscriptionpersos->setNbparticipant($nbparticipant);
$Inscriptionpersos->setPays($pays);
$Inscriptionpersos->setVille($ville);
$Inscriptionpersos->setBoitepostale($boitepostale);
$Inscriptionpersos->setWhatsapp($whatsapp);
$Inscriptionpersos->setTelephone($telephone);
$Inscriptionpersos->setCommentaire($commentaire);
$Inscriptionpersos->setTheme($theme);
$Inscriptionpersos->setType($type);
$Inscriptionpersos->setDuree($duree);
$Inscriptionpersos->setLieu($lieu);
$Inscriptionpersos->setPrix($prix);
$Inscriptionpersos->setSession($session);
$entityManager->persist($Inscriptionpersos);
$entityManager->flush();
$this->addFlash(
'success',
'Votre inscription à été bien enregistrée');
return $this->redirectToRoute('front.inter.certificat.certyou',['slug' => $slug,'id' => $id]);
}
//dd($nomTheme);
$mentions = $mentionRepository->findAll();
return $this->render('front/inscriptions/inscription-certyou.html.twig',[
'id' => $id,
'slug' => $slug,
'theme' => $nomTheme,
'certyou' => $certyou,
'mentions' => $mentions,
'manageLimit' => $manageLimit,
'inscriptionCertyouForm' => $InscriptionCertyouForm->createView(),
]);
}
//-----------------------------------------------------------------------------------------------------
#[Route('/formations/certificats/certificats-internationaux-I', name: 'front.inter.certificat.inter', methods:['GET'])]
public function certificat(
Request $request,
PaginatorInterface $paginator,
CertificatsRepository $certificatRepository,
ManagementsRepository $managementRepository,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
$certificat = $certificatRepository->findAll();
$manageLimit = $managementRepository->findBy([], ['id' => 'DESC'], 10 );
$queryBuilder = $entityManager->createQueryBuilder();
$sub = $entityManager->createQueryBuilder()
->select('MAX(c2.createdat)')
->from(Certificats::class, 'c2')
->where('c2.theme = cert.theme');
$queryBuilder
->select('cert.id','cert.session','cert.prix','cert.slug','cert.devise',
'vil.nom AS vilnom','vil.pays','cert.createdat','cert.type','cert.theme')
->from(Certificats::class, 'cert')
->innerJoin(Villes::class, 'vil', 'WITH', 'cert.ville = vil.id')
->where($queryBuilder->expr()->eq('cert.createdat', '(' . $sub->getDQL() . ')'))
->orderBy('cert.createdat', 'DESC');
$certificat = $queryBuilder->getQuery()->getResult();
$pagination = $paginator->paginate(
$queryBuilder,
$request->query->getInt('page', 1),
12
);
$mentions = $mentionRepository->findAll();
return $this->render('front/certificat.html.twig',[
'manageLimit' => $manageLimit,
'pagination' => $certificat,
'mentions' => $mentions,
]);
}
#[Route('/formtaions/certificats/certificats-internationaux-I/{slug}', name: 'front.inter.detail.certificat', methods:['GET'])]
public function detail_certificat(
$slug,
Request $request,
PaginatorInterface $paginator,
CertificatsRepository $certificatRepository,
ManagementsRepository $managementRepository,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
$certificat = $certificatRepository->findAll();
$manageLimit = $managementRepository->findBy([], ['id' => 'DESC'], 10 );
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select(
'cert.id','cert.session','cert.prix','cert.slug',
'cert.devise','cert.theme','vil.nom AS vilnom',
'vil.pays','cert.createdat','cert.type'
)
->from(Certificats::class, 'cert')
->innerJoin(Villes::class, 'vil', 'WITH', 'cert.ville = vil.id')
->where('cert.slug = :slug')
->setParameter('slug', $slug);
$certificat = $queryBuilder->getQuery()->getResult();
$pagination = $paginator->paginate(
$queryBuilder,
$request->query->getInt('page', 1),
12
);
$mentions = $mentionRepository->findAll();
return $this->render('front/liste-certificat.html.twig',[
'manageLimit' => $manageLimit,
'pagination' => $pagination,
'mentions' => $mentions,
'slug' => $slug
]);
}
#[Route('/presentation', name: 'front.inter.presentation', methods:['GET'])]
public function presentation(
Request $request,
PartenairesRepository $partenaireRepository,
FormationsRepository $formationRepository,
AboutsRepository $aboutRepository,
ValeursRepository $valeurRepository,
AvisRepository $avisRepository,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
$avis = $avisRepository->findAll();
$All_partenaire = $partenaireRepository->findAll();
$All_about = $aboutRepository->findAll();
$All_valeur = $valeurRepository->findAll();
$mentions = $mentionRepository->findAll();
return $this->render('front/qui-sommes-nous.html.twig',[
'partenaires' => $All_partenaire,
'valeur' => $All_valeur,
'mentions' => $mentions,
'about' => $All_about,
'avis' => $avis,
]);
}
#[Route('/formations/rencontre-top-management', name: 'front.top.management', methods:['GET'])]
public function management(
Request $request,
PaginatorInterface $paginator,
MentionsRepository $mentionRepository,
ManagementsRepository $managementRepository,
EntityManagerInterface $entityManager
): Response
{
$manageLimit = $managementRepository->findBy([], ['id' => 'DESC'], 10 );
// dd($manageLimit);
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select('man')
->from(Managements::class, 'man')
->orderBy('man.createdat', 'DESC');
$listmanagement = $queryBuilder->getQuery()->getResult();
$pagination = $paginator->paginate(
$queryBuilder,
$request->query->getInt('page', 1),
10
);
$mentions = $mentionRepository->findAll();
return $this->render('front/rencontre-management.html.twig',[
'mentions' => $mentions,
'pagination' => $listmanagement,
'manageLimit' => $manageLimit
]);
}
#[Route('/formations/rencontre-top-management/{slug}', name: 'front.seminaire.management.detail', methods:['GET'])]
public function detail_management(
$slug,
Request $request,
ManagementsRepository $managementRepository,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
$query = $managementRepository->findOneBy(array('slug' => $slug));
$mentions = $mentionRepository->findAll();
// dd($query);
return $this->render('front/detail/detail-rencontre.html.twig',[
'mentions' => $mentions,
'query' => $query,
'slug' => $slug
]);
}
#[Route('/formations/seminaires/internationaux', name: 'front.seminaire.internationaux', methods:['GET'])]
public function sem_inter(
Request $request,
PaginatorInterface $paginator,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
$recherche = $this->createForm(RechercheFormType::class);
$recherche->handleRequest($request);
$annee = (int) date('Y');
$today = new \DateTime('today');
$mentions = $mentionRepository->findAll();
$qb = $entityManager->createQueryBuilder();
$qb ->select('for','th','thm','vil')
->from(Formations::class, 'for')
->innerJoin('for.theme', 'th')
->innerJoin('th.thematique', 'thm')
->innerJoin('for.ville', 'vil')
->Where('vil != :ville')
->setParameter('ville', 'SHANGHAI');
if ($recherche->isSubmitted() && $recherche->isValid()) {
$mot = $recherche->get('mot')->getData();
if(empty($mot)){
// Aucun thème sélectionné
$this->addFlash('warning', 'Veuillez sélectionner un thème pour la recherche.');
return $this->redirectToRoute('front.seminaire.internationaux'); // ou autre redirection
}
$ville = $recherche->get('ville')->getData();
if ($ville && strtoupper($ville->getNom()) === 'SHANGHAI') {
// On ignore silencieusement
$ville = null;
}
$nom = $mot->getNom();
if ($mot) {
$qb ->andWhere($qb->expr()->orX('th.nom LIKE :mot','thm.nom LIKE :mot'))
->setParameter('mot', '%' . $nom . '%');
}
if ($ville) {
$qb ->andWhere('vil = :ville')
->setParameter('ville', $ville);
}
}
$formations = $qb->getQuery()->getResult();
$extractDateDebut = function (?string $datesSession): ?\DateTime {
if (!$datesSession) return null;
$mois = [
'janv'=>1,'janvier'=>1,
'févr'=>2,'fevr'=>2,'février'=>2,
'mars'=>3,
'avr'=>4,'avril'=>4,
'mai'=>5,
'juin'=>6,
'juil'=>7,'juillet'=>7,
'août'=>8,'aout'=>8,
'sept'=>9,'septembre'=>9,
'oct'=>10,'octobre'=>10,
'nov'=>11,'novembre'=>11,
'déc'=>12,'dec'=>12,'décembre'=>12
];
$text = strtolower(str_replace(['.', ','], '', trim($datesSession)));
if (!preg_match(
'/(\d{1,2})\s*(janv|févr|fevr|mars|avr|mai|juin|juil|août|aout|sept|oct|nov|déc)?\s*au\s*\d{1,2}\s*(janv|févr|fevr|mars|avr|mai|juin|juil|août|aout|sept|oct|nov|déc)/i',
$text,
$m
)) {
return null;
}
$jour = (int) $m[1];
$moisTxt = $m[2] ?: $m[3];
$moisNum = $mois[$moisTxt] ?? null;
if (!$moisNum) return null;
$date = new \DateTime(sprintf('%d-%02d-%02d', date('Y'), $moisNum, $jour));
if ($date < new \DateTime('today')) {
$date->modify('+1 year');
}
return $date;
};
$formationsParTheme = [];
foreach ($formations as $formation) {
$dateDebut = $extractDateDebut($formation->getDatesSession());
if (!$dateDebut || $dateDebut < $today || (int)$dateDebut->format('Y') !== $annee) {
continue;
}
$themeId = $formation->getTheme()->getId();
if (
!isset($formationsParTheme[$themeId]) ||
$dateDebut < $formationsParTheme[$themeId]['date']
) {
$formationsParTheme[$themeId] = [
'formation' => $formation,
'date' => $dateDebut
];
}
}
$formationsFinales = array_map(fn($f) => $f['formation'], $formationsParTheme);
usort($formationsFinales, function ($a, $b) use ($extractDateDebut) {
return $extractDateDebut($a->getDatesSession())
<=> $extractDateDebut($b->getDatesSession());
});
$pagination = $paginator->paginate(
$formationsFinales,
$request->query->getInt('page', 1),
12
);
return $this->render('front/seminaire_inter.html.twig', [
'annee' => $annee,
'mentions' => $mentions,
'pagination' => $pagination,
'recherche' => $recherche->createView(),
]);
}
#[Route('/formations/seminaires/nationaux', name: 'front.seminaire.nationaux', methods:['GET'])]
public function semNat(
Request $request,
GeoIpService $geo,
PaginatorInterface $paginator,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
$annee = date('Y');
$today = new \DateTime();
// 🌍 Géo IP
$geoData = $geo->getGeoData($request->getClientIp());
$pays = $geoData['country'] ?? '';
$ville = $geoData['city'] ?? '';
// Correction du nom du pays
if ($pays === 'Local' || $pays === 'Ivory Coast') {
$getpays = "Côte d'ivoire";
} else {
$getpays = $pays;
}
// 🔍 Formulaire de recherche
$rechercheNat = $this->createForm(RechercheNatFormType::class);
$rechercheNat->handleRequest($request);
// 🔹 Requête pour récupérer les formations nationales
$qb = $entityManager->createQueryBuilder()
->select('f', 'th', 'thm', 'vil')
->from(Formations::class, 'f')
->innerJoin('f.theme', 'th')
->innerJoin('th.thematique', 'thm')
->innerJoin('f.ville', 'vil')
->where('vil.pays = :pays')
->setParameter('pays', $getpays);
// 🔍 Filtrer par recherche si soumise
if ($rechercheNat->isSubmitted() && $rechercheNat->isValid()) {
$mot = $rechercheNat->get('mot')->getData() ?? '';
if(empty($mot)){
// Aucun thème sélectionné
$this->addFlash('warning', 'Veuillez sélectionner un thème pour la recherche.');
return $this->redirectToRoute('front.seminaire.nationaux'); // ou autre redirection
}
$nom = $mot->getNom();
if ($mot) {
$qb->andWhere(
$qb->expr()->orX(
'th.nom LIKE :mot',
'thm.nom LIKE :mot'
)
)->setParameter('mot', '%' . $nom . '%');
}
}
// 📄 Récupération des formations
$formations = $qb->getQuery()->getResult();
$extractDates = function(?string $datesSession): ?array {
if (!$datesSession) return null;
$moisFr = [
'janv'=>1,'janvier'=>1,'févr'=>2,'fevr'=>2,'février'=>2,
'mars'=>3,'avr'=>4,'avril'=>4,'mai'=>5,'juin'=>6,
'juil'=>7,'juillet'=>7,'août'=>8,'aout'=>8,
'sept'=>9,'septembre'=>9,'oct'=>10,'octobre'=>10,
'nov'=>11,'novembre'=>11,'déc'=>12,'dec'=>12,'décembre'=>12
];
$text = strtolower(trim($datesSession));
$text = str_replace(['.', ','], '', $text);
if (preg_match('/(\d{1,2})\s*(\w+)?\s*au\s*(\d{1,2})\s*(\w+)?/i', $text, $m)) {
$jourDebut = (int)$m[1];
$moisDebut = $moisFr[$m[2] ?? ''] ?? null;
$jourFin = (int)$m[3];
$moisFin = $moisFr[$m[4] ?? ''] ?? $moisDebut;
if (!$moisDebut || !$moisFin) return null;
$annee = (int)date('Y');
$dateDebut = new \DateTime(sprintf('%04d-%02d-%02d', $annee, $moisDebut, $jourDebut));
$dateFin = new \DateTime(sprintf('%04d-%02d-%02d', $annee, $moisFin, $jourFin));
if ($dateFin < $dateDebut) $dateFin->modify('+1 year');
return ['debut' => $dateDebut, 'fin' => $dateFin];
}
return null;
};
// 🔹 Filtrer uniquement les formations à venir
$today = new \DateTime('today');
$formations = array_filter($formations, function($f) use ($extractDates, $today) {
$dates = $extractDates($f->getDatesSession());
if (!$dates) return false;
// garder uniquement les formations dont la date de début est après aujourd'hui
return $dates['debut'] > $today;
});
// 🔹 Trier par date la plus proche
usort($formations, function($a, $b) use ($extractDates) {
return $extractDates($a->getDatesSession())['debut'] <=> $extractDates($b->getDatesSession())['debut'];
});
// 📄 Pagination
$pagination = $paginator->paginate(
$formations,
$request->query->getInt('page', 1),
12
);
$mentions = $mentionRepository->findAll();
// 🔹 Rendu Twig
return $this->render('front/seminaire_nat.html.twig', [
'annee' => $annee,
'mentions' => $mentions,
'recherche' => $rechercheNat->createView(),
'pagination' => $pagination,
'ville' => $ville,
'pays' => $getpays,
]);
}
#[Route('/formations/{seminaires}/{slug}/{id}code/inscription', name: 'front.inscription', methods:['GET','POST'])]
public function inscription_sem(
$slug,
$seminaires,
$id,
Request $request,
MailerInterface $mailer,
InscriptionsRepository $inscriptionRepository,
ThemeshanghaiRepository $themeshanghaiRepository,
VillesRepository $villeRepository,
ThemesRepository $themeRepository,
FormationsRepository $formationRepository,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
$annee = date('Y');
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select('for.id', 'for.dates_session', 'for.prix', 'for.devise', 'th.nom',
'thm.nom AS thmnom','vil.nom AS vilnom','vil.pays','for.created_at',
'th.slug','th.description','for.devise','vil.longitude','vil.latitude'
)
->from(Formations::class, 'for')
->innerJoin(Themes::class, 'th', 'WITH', 'for.theme = th.id')
->innerJoin(Villes::class, 'vil', 'WITH', 'for.ville = vil.id')
->innerJoin(Thematiques::class, 'thm', 'WITH', 'th.thematique= thm.id')
->where('th.slug = :theme')
->andwhere('for.id = :forid')
->setParameter('theme', $slug)
->setParameter('forid', $id);
$query = $queryBuilder->getQuery()->getResult();
$mentions = $mentionRepository->findAll();
$queryBuilder1 = $entityManager->createQueryBuilder();
$queryBuilder1
->select(
'cert.id','cert.session','cert.prix','cert.slug',
'cert.devise','cert.theme','vil.nom AS vilnom',
'vil.pays','cert.createdat','cert.type'
)
->from(Certificats::class, 'cert')
->innerJoin(Villes::class, 'vil', 'WITH', 'cert.ville = vil.id')
->where('cert.slug = :slug')
->andwhere('cert.id = :id')
->setParameter('slug', $slug)
->setParameter('id', $id);
$certificat = $queryBuilder1->getQuery()->getOneOrNullResult();
$queryBuilder2 = $entityManager->createQueryBuilder();
$queryBuilder2
->select(
'shan.id','shan.session','shan.prix','shan.slug',
'shan.devise','shan.theme','shan.ville','shan.createdat','shan.updatedat'
)
->from(Themeshanghai::class, 'shan')
->where('shan.slug = :slug')
->andwhere('shan.id = :id')
->setParameter('slug', $slug)
->setParameter('id', $id);
$shanghai = $queryBuilder2->getQuery()->getOneOrNullResult();
$inscription = new Inscriptions();
$inscriptionForm = $this->createForm(InscriptionFormType::class, $inscription);
$inscriptionForm->handleRequest($request);
if ($inscriptionForm->isSubmitted()) {
$civilite = $inscriptionForm->get('civilite')->getData();
$nom = $inscriptionForm->get('nom')->getData();
$prenoms = $inscriptionForm->get('prenoms')->getData();
$fonction = $inscriptionForm->get('fonction')->getData();
$adresse = $inscriptionForm->get('adresse')->getData();
$mail = $inscriptionForm->get('mail')->getData();
$entreprise = $inscriptionForm->get('entreprise')->getData();
$site = $inscriptionForm->get('siteweb')->getData();
$nbparticipant = $inscriptionForm->get('nbparticipant')->getData();
$pays = $inscriptionForm->get('pays')->getData();
$ville = $inscriptionForm->get('ville')->getData();
$boitepostale = $inscriptionForm->get('boitepostale')->getData();
$whatsapp = $inscriptionForm->get('whatsapp')->getData();
$telephone = $inscriptionForm->get('telephone')->getData();
$commentaire = $inscriptionForm->get('commentaire')->getData();
$formation = $formationRepository->find($id);
$formationShanghai = $themeshanghaiRepository->find($id);
$token = $inscriptionForm->get('recaptchaToken')->getData();
if($query){
$theme = $formation->getTheme();
$idville = $formation->getVille();
$session = $formation->getDatesSession();
$prix = $formation->getPrix();
$devise = $formation->getDevise();
$villes = $villeRepository->find($idville);
$nomtheme = $theme->getNom();
$nomville = $villes->getNom();
}
if(!$site){
$siteweb = 'Pas renseigné';
}else{
$siteweb = $inscriptionForm->get('siteweb')->getData();
}
if($certificat){
$nomtheme = $certificat['theme'];
$nomville = $certificat['vilnom'];
$nompays = $certificat['pays'];
$session = $certificat['session'];
$prix = $certificat['prix'];
$devise = $certificat['devise'];
}
if($shanghai){
$nomtheme = $shanghai['theme'];
$nomville = $shanghai['ville'];
$nompays = '';
$session = $shanghai['session'];
$prix = $shanghai['prix'];
$devise = $shanghai['devise'];
}
//dd($certificat);
if(!$commentaire){
$commentaire = " ";
}else{
$commentaire = $inscriptionForm->get('commentaire')->getData();
}
$response = $this->client->request(
'POST',
'https://www.google.com/recaptcha/api/siteverify',
[
'body' => [
'secret' => $_ENV['RECAPTCHA_SECRET_KEY'],
'response' => $token,
]
]
);
$result = $response->toArray();
if (!$result['success'] || !isset($result['score']) || $result['score'] < 0.5) {
return $this->addFlash('warning','Vérification reCAPTCHA échouée.');
}
/*
$inscription->setNom($nom);
$inscription->setPrenoms($prenoms);
$inscription->setFonction($fonction);
$inscription->setAdresse($adresse);
$inscription->setMail($mail);
$inscription->setEntreprise($entreprise);
$inscription->setSiteweb($siteweb);
$inscription->setNbparticipant($nbparticipant);
$inscription->setPays($pays);
$inscription->setVille( $ville);
$inscription->setBoitepostale($boitepostale);
$inscription->setWhatsapp($whatsapp);
$inscription->setTelephone($telephone);
$inscription->setCommentaire($commentaire);
$inscription->setFormation($formation);
$entityManager->persist($inscription);
$entityManager->flush();
*/
$destinataire = 'inscriptions@cimef-international.org';
$expediteur = $mail;
$reponse = $expediteur;
$suj = "INSCRIPTION FORMATION 2026";
$codehtml = '<html><body>'.
'<table width="100%" cellpadding="0" cellspacing="0" style="background-color:#f4f6f8; padding:20px;">
<tr>
<td align="center">
<table width="600" cellpadding="0" cellspacing="0" style="background-color:#ffffff; border-radius:6px; overflow:hidden; box-shadow:0 2px 6px rgba(0,0,0,0.08);">
<tr>
<td style="background-color:#051a53; padding:20px; color:#ffffff; text-align:center;">
<h2 style="margin:0;">Confirmation d\'inscription</h2>
</td>
</tr>
<tr>
<td style="padding:25px; color:#333333; font-size:14px; line-height:1.6;">
<p>Inscription de '.$civilite.' '.$prenoms.' '.$nom.' à la formation <strong>'.$nomtheme.'</strong> organisée par <strong>CIMEF International</strong>.</p>
<p>Veuillez trouver ci-dessous le récapitulatif :</p>
<hr style="border:none; border-top:1px solid #e0e0e0; margin:20px 0;">
<h4 style="margin-bottom:8px; color:#0d6efd;">Informations personnelles</h4>
<p>
<strong>Nom & Prénoms :</strong> '.$prenoms.' '.$nom.'<br>
<strong>Fonction :</strong> '.$fonction.'<br>
<strong>Entreprise :</strong> '.$entreprise.'<br>
<strong>Adresse :</strong> '.$adresse.'<br>
<strong>Pays / Ville :</strong> '.$pays.' / '.$ville.'<br>
<strong>Boîte postale :</strong> '.$boitepostale.'
</p>
<h4 style="margin-bottom:8px; color:#0d6efd;">Coordonnées</h4>
<p>
<strong>Email :</strong> '.$mail.'<br>
<strong>Téléphone :</strong> '.$telephone.'<br>
<strong>WhatsApp :</strong> '.$whatsapp.'<br>
<strong>Site web :</strong> '.$siteweb.'
</p>
<h4 style="margin-bottom:8px; color:#0d6efd;">Détails de participation</h4>
<p>
<strong>Nombre de participants :</strong> '.$nbparticipant.'<br>
<strong>Commentaire :</strong> '.$commentaire.'
</p>
<h4 style="margin-bottom:8px; color:#0d6efd;">Détail de la formation</h4>
<p>
<strong>Thème :</strong> '.$nomtheme.'<br>
<strong>Ville :</strong> '.$nomville.'<br>
<strong>Prix :</strong> '.$prix.''.$devise.'<br>
<strong>Session :</strong> '.$session.'
</p>
</td>
</tr>
<tr>
<td style="background-color:#f1f1f1; padding:15px; text-align:center; font-size:12px; color:#777777;">
© '.date("Y").' CIMEF International — Tous droits réservés
</td>
</tr>
</table>
</td>
</tr>
</table>
</body></html>';
/*
$secretKey = '6LfPYkosAAAAAJQFLCC-9U5bF6KdFTPrgmbxg5Ux';
$value = $request->get('g-recaptcha-response');
if (!$value) {
$this->addFlash('warning', 'Veuillez cocher le reCAPTCHA');
return $this->redirectToRoute('front.seminaire.nationaux',['seminaires' => $seminaires,'slug' => $slug]);
}
$userIP = $_SERVER['REMOTE_ADDR'];
$url = "https://www.google.com/recaptcha/api/siteverify?secret=$secretKey&response=$value&remoteip=$userIP";
$response = \file_get_contents($url);
$response = json_decode((string)$response);
if(!$response->success){
$this->addFlash('warning','Cocher le champs recaptcha svp!');
return $this->redirectToRoute('front.seminaire.nationaux',['seminaires' => $seminaires,'slug' => $slug]);
}
*/
$email = (new Email())
->from('CIMEF International <inscriptions@cimef-international.org>')
->to($destinataire) // destinataire principal
->cc('medias@cimef-international.com') // COPIE
->replyTo($expediteur) // Reply-To:
->subject($suj)
->text(strip_tags($codehtml))
->html($codehtml);// Subject:
//->html($codehtml, 'text/html'); // Content-Type + charset utf-8
$mailer->send($email);
$this->addFlash(
'success',
'Votre inscription à été bien enregistrée');
return $this->redirectToRoute('front.seminaire.nationaux',['seminaires' => $seminaires,'slug' => $slug]);
}
//dd($seminaires);
if($query){
return $this->render('front/inscriptions/inscription-seminaire.html.twig',[
'slug' => $slug,
'query' => $query,
'annee' => $annee,
'type' => $seminaires,
'mentions' => $mentions,
'inscriptionForm' => $inscriptionForm->createView(),
]);
}elseif($shanghai){
$nomtheme = $shanghai['theme'];
$nomville = $shanghai['ville'];
$nompays = '';
$session = $shanghai['session'];
$prix = $shanghai['prix'];
$devise = $shanghai['devise'];
return $this->render('front/inscriptions/inscription-certificat.html.twig',[
'slug' => $slug,
'prix' => $prix,
'annee' => $annee,
'pays' => $nompays,
'devise' => $devise,
'ville' => $nomville,
'theme' => $nomtheme,
'type' => $seminaires,
'session' => $session,
'mentions' => $mentions,
'certificat' => $shanghai,
'inscriptionForm' => $inscriptionForm->createView(),
]);
}else{
$nomtheme = $certificat['theme'];
$nomville = $certificat['vilnom'];
$nompays = $certificat['pays'];
$session = $certificat['session'];
$prix = $certificat['prix'];
$devise = $certificat['devise'];
return $this->render('front/inscriptions/inscription-certificat.html.twig',[
'slug' => $slug,
'prix' => $prix,
'annee' => $annee,
'pays' => $nompays,
'devise' => $devise,
'ville' => $nomville,
'theme' => $nomtheme,
'type' => $seminaires,
'session' => $session,
'mentions' => $mentions,
'certificat' => $certificat,
'inscriptionForm' => $inscriptionForm->createView(),
]);
}
}
#[Route('/formations/rencontre-des-top-management/{slug}/{id}code/inscription-manager', name: 'front.inscription.management', methods:['GET','POST'])]
public function inscription_man(
$slug,
$id,
Request $request,
MailerInterface $mailer,
InscriptionsRepository $inscriptionRepository,
ManagementsRepository $managementRepository,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
$annee = date('Y');
$queryBuilder_1 = $entityManager->createQueryBuilder();
$queryBuilder_1
->select('man')
->from(Managements::class, 'man')
->where('man.slug = :theme')
->andwhere('man.id = :forid')
->setParameter('theme', $slug)
->setParameter('forid', $id);
$query_1 = $queryBuilder_1->getQuery()->getResult();
$mentions = $mentionRepository->findAll();
$inscription = new Inscriptions();
$inscriptionForm = $this->createForm(InscriptionFormType::class, $inscription);
$inscriptionForm->handleRequest($request);
if ($inscriptionForm->isSubmitted()) {
$nom = $inscriptionForm->get('nom')->getData();
$prenoms = $inscriptionForm->get('prenoms')->getData();
$fonction = $inscriptionForm->get('fonction')->getData();
$adresse = $inscriptionForm->get('adresse')->getData();
$mail = $inscriptionForm->get('mail')->getData();
$entreprise = $inscriptionForm->get('entreprise')->getData();
$siteweb = $inscriptionForm->get('siteweb')->getData();
$nbparticipant = $inscriptionForm->get('nbparticipant')->getData();
$pays = $inscriptionForm->get('pays')->getData();
$ville = $inscriptionForm->get('ville')->getData();
$boitepostale = $inscriptionForm->get('boitepostale')->getData();
$whatsapp = $inscriptionForm->get('whatsapp')->getData();
$telephone = $inscriptionForm->get('telephone')->getData();
$commentaire = $inscriptionForm->get('commentaire')->getData();
$management = $managementRepository->find($id);
//dd($formation->getId());
$token = $inscriptionForm->get('recaptchaToken')->getData();
$theme = $management->getTheme();
$ville = $management->getVille();
$datedebut = $management->getDateDebut();
$datefin = $management->getDateFin();
$prix = $management->getPrix();
$devise = $management->getDevise();
if(!$commentaire){
$commentaire = "...";
}else{
$commentaire = $inscriptionForm->get('commentaire')->getData();
}
//$codehtml = "test";
$codehtml = '<html><body>'.
'<table width="100%" cellpadding="0" cellspacing="0" style="background-color:#f4f6f8; padding:20px;">
<tr>
<td align="center">
<table width="600" cellpadding="0" cellspacing="0" style="background-color:#ffffff; border-radius:6px; overflow:hidden; box-shadow:0 2px 6px rgba(0,0,0,0.08);">
<tr>
<td style="background-color:#051a53; padding:20px; color:#ffffff; text-align:center;">
<h2 style="margin:0;">Confirmation d\'inscription</h2>
</td>
</tr>
<tr>
<td style="padding:25px; color:#333333; font-size:14px; line-height:1.6;">
<p>Inscription de M/Mme <strong>'.$prenoms.' '.$nom.'</strong> à la formation <strong>'.$nomtheme.'</strong> organisée par <strong>CIMEF International</strong>.</p>
<p>Veuillez trouver ci-dessous le récapitulatif :</p>
<hr style="border:none; border-top:1px solid #e0e0e0; margin:20px 0;">
<h4 style="margin-bottom:8px; color:#0d6efd;">Informations personnelles</h4>
<p>
<strong>Nom & Prénoms :</strong> '.$prenoms.' '.$nom.'<br>
<strong>Fonction :</strong> '.$fonction.'<br>
<strong>Entreprise :</strong> '.$entreprise.'<br>
<strong>Adresse :</strong> '.$adresse.'<br>
<strong>Pays / Ville :</strong> '.$pays.' / '.$ville.'<br>
<strong>Boîte postale :</strong> '.$boitepostale.'
</p>
<h4 style="margin-bottom:8px; color:#0d6efd;">Coordonnées</h4>
<p>
<strong>Email :</strong> '.$mail.'<br>
<strong>Téléphone :</strong> '.$telephone.'<br>
<strong>WhatsApp :</strong> '.$whatsapp.'<br>
<strong>Site web :</strong> '.$siteweb.'
</p>
<h4 style="margin-bottom:8px; color:#0d6efd;">Détails de participation</h4>
<p>
<strong>Nombre de participants :</strong> '.$nbparticipant.'<br>
<strong>Commentaire :</strong> '.$commentaire.'
</p>
<h4 style="margin-bottom:8px; color:#0d6efd;">Détail de la formation</h4>
<p>
<strong>Thème :</strong> '.$theme.'<br>
<strong>Ville :</strong> '.$ville.'<br>
<strong>Prix :</strong> '.$prix.''.$devise.'<br>
<strong>Date de la rencontre :</strong> Du'.$datedebut.' au '.$datefin.'<br>
</p>
</td>
</tr>
<tr>
<td style="background-color:#f1f1f1; padding:15px; text-align:center; font-size:12px; color:#777777;">
© '.date("Y").' CIMEF International — Tous droits réservés
</td>
</tr>
</table>
</td>
</tr>
</table>
</body></html>';
/*
$secretKey = '6LfPYkosAAAAAJQFLCC-9U5bF6KdFTPrgmbxg5Ux';
$value = $request->get('g-recaptcha-response');
if (!$value) {
return $this->addFlash('warning', 'Veuillez cocher le reCAPTCHA');
}
$userIP = $_SERVER['REMOTE_ADDR'];
$url = "https://www.google.com/recaptcha/api/siteverify?secret=$secretKey&response=$value&remoteip=$userIP";
$response = \file_get_contents($url);
$response = json_decode((string)$response);
//dd($response);
if(!$response->success){
return $this->addFlash('warning','Cocher le champs recaptcha svp!');
}
*/
$response = $this->client->request(
'POST',
'https://www.google.com/recaptcha/api/siteverify',
[
'body' => [
'secret' => $_ENV['RECAPTCHA_SECRET_KEY'],
'response' => $token,
]
]
);
$result = $response->toArray();
if (!$result['success'] || !isset($result['score']) || $result['score'] < 0.5) {
return $this->addFlash('warning','Vérification reCAPTCHA échouée.');
}
$destinataire = 'inscriptions@cimef-international.org';
$expediteur = $mail;
$reponse = $expediteur;
$suj = "INSCRIPTION FORMATION 2026";
$email = (new Email())
->from('CIMEF International <inscriptions@cimef-international.org>')
->to($destinataire) // destinataire principal
->cc('medias@cimef-international.com') // COPIE
->replyTo($expediteur) // Reply-To:
->subject($suj)
->text(strip_tags($codehtml))
->html($codehtml);// Subject:
//->html($codehtml, 'text/html'); // Content-Type + charset utf-8
$mailer->send($email);
$inscription->setNom($nom);
$inscription->setPrenoms($prenoms);
$inscription->setFonction($fonction);
$inscription->setAdresse($adresse);
$inscription->setMail($mail);
$inscription->setEntreprise($entreprise);
$inscription->setSiteweb($siteweb);
$inscription->setNbparticipant($nbparticipant);
$inscription->setPays($pays);
$inscription->setVille( $ville);
$inscription->setBoitepostale($boitepostale);
$inscription->setWhatsapp($whatsapp);
$inscription->setTelephone($telephone);
$inscription->setCommentaire($commentaire);
$inscription->setFormation($management);
$entityManager->persist($inscription);
$entityManager->flush();
$this->addFlash(
'success',
'Votre inscription à été bien enregistrée');
return $this->redirectToRoute('front.top.management');
}
return $this->render('front/inscriptions/inscription-top-management.html.twig',[
'query_1' => $query_1,
'annee' => $annee,
'mentions' => $mentions,
'inscriptionForm' => $inscriptionForm->createView(),
]);
}
#[Route('/formations/seminaire-a-la-carte', name: 'front.seminaire-a-la-carte', methods:['GET','POST'])]
public function inscription_seminaire_sur_mesure(
Request $request,
MailerInterface $mailer,
InscriptionsRepository $inscriptionRepository,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
//dd($seminaires);
$annee = date('Y');
$mentions = $mentionRepository->findAll();
$demandeformation = new Demandeformations();
$demandeformationsForm = $this->createForm(DemandeformationFormType::class, $demandeformation);
$demandeformationsForm->handleRequest($request);
if ($demandeformationsForm->isSubmitted()) {
$civilite = $demandeformationsForm->get('civilite')->getData();
$nom = $demandeformationsForm->get('nom')->getData();
$prenoms = $demandeformationsForm->get('prenoms')->getData();
$fonction = $demandeformationsForm->get('fonction')->getData();
$adresse = $demandeformationsForm->get('adresse')->getData();
$mail = $demandeformationsForm->get('mail')->getData();
$entreprise = $demandeformationsForm->get('entreprise')->getData();
$siteweb = $demandeformationsForm->get('siteweb')->getData();
$nombrepart = $demandeformationsForm->get('nombrepart')->getData();
$lieu = $demandeformationsForm->get('lieu')->getData();
$theme = $demandeformationsForm->get('theme')->getData();
$duree = $demandeformationsForm->get('duree')->getData();
$telephone = $demandeformationsForm->get('telephone')->getData();
$commentaire = $demandeformationsForm->get('commentaire')->getData();
//dd($formation->getId());
$token = $demandeformationsForm->get('recaptchaToken')->getData();
if(!$commentaire){
$commentaire = "...";
}else{
$commentaire = $demandeformationsForm->get('commentaire')->getData();
}
$demandeformation->setNom($nom);
$demandeformation->setPrenoms($prenoms);
$demandeformation->setFonction($fonction);
$demandeformation->setAdresse($adresse);
$demandeformation->setMail($mail);
$demandeformation->setEntreprise($entreprise);
$demandeformation->setSiteweb($siteweb);
$demandeformation->setNombrepart($nombrepart);
$demandeformation->setLieu($lieu);
$demandeformation->setTheme($theme);
$demandeformation->setDuree($duree);
$demandeformation->setTelephone($telephone);
$demandeformation->setCommentaire($commentaire);
$entityManager->persist($demandeformation);
$entityManager->flush();
$destinataire = 'inscriptions@cimef-international.org';
$expediteur = $mail;
$reponse = $expediteur;
$suj = "INSCRIPTION FORMATION 2026";
//$codehtml = "test";
$codehtml = '<html><body>'.
'<table width="100%" cellpadding="0" cellspacing="0" style="background-color:#f4f6f8; padding:20px;">
<tr>
<td align="center">
<table width="600" cellpadding="0" cellspacing="0" style="background-color:#ffffff; border-radius:6px; overflow:hidden; box-shadow:0 2px 6px rgba(0,0,0,0.08);">
<tr>
<td style="background-color:#051a53; padding:20px; color:#ffffff; text-align:center;">
<h2 style="margin:0;">Demande de dévis</h2>
</td>
</tr>
<tr>
<td style="padding:25px; color:#333333; font-size:14px; line-height:1.6;">
<p>Demande de dévis de '.$civilite.' <strong>'.$prenoms.' '.$nom.'</strong> pour une formation avec pour thème :<strong>'.$theme.'</strong>.</p>
<p>Veuillez trouver ci-dessous le récapitulatif :</p>
<hr style="border:none; border-top:1px solid #e0e0e0; margin:20px 0;">
<h4 style="margin-bottom:8px; color:#0d6efd;">Informations personnelles</h4>
<p>
<strong>Nom & Prénoms :</strong> '.$prenoms.' '.$nom.'<br>
<strong>Fonction :</strong> '.$fonction.'<br>
<strong>Entreprise :</strong> '.$entreprise.'<br>
<strong>Adresse :</strong> '.$adresse.'<br>
</p>
<h4 style="margin-bottom:8px; color:#0d6efd;">Coordonnées</h4>
<p>
<strong>Email :</strong> '.$mail.'<br>
<strong>Téléphone :</strong> '.$telephone.'<br>
<strong>Site web :</strong> '.$siteweb.'
</p>
<h4 style="margin-bottom:8px; color:#0d6efd;">Détails de participation</h4>
<p>
<strong>Nombre de participants :</strong> '.$nombrepart.'<br>
<strong>Commentaire :</strong> '.$commentaire.'
</p>
<h4 style="margin-bottom:8px; color:#0d6efd;">Détail de la formation</h4>
<p>
<strong>Thème :</strong> '.$theme.'<br>
<strong>Lieu :</strong> '.$lieu.'<br>
<strong>Date :</strong> '.$duree.'
</p>
</td>
</tr>
<tr>
<td style="background-color:#f1f1f1; padding:15px; text-align:center; font-size:12px; color:#777777;">
© '.date("Y").' CIMEF International — Tous droits réservés
</td>
</tr>
</table>
</td>
</tr>
</table>
</body></html>';
/*
$secretKey = '6LfPYkosAAAAAJQFLCC-9U5bF6KdFTPrgmbxg5Ux';
$value = $request->get('g-recaptcha-response');
if (!$value) { $this->addFlash('warning', 'Veuillez cocher le reCAPTCHA');
$this->addFlash('warning','Cocher le champs recaptcha svp!');
return $this->render('front/inscriptions/formation-a-la-carte.html.twig',[
'annee' => $annee,
'mentions' => $mentions,
'demandeformationsForm' => $demandeformationsForm->createView(),
]);
}
$userIP = $_SERVER['REMOTE_ADDR'];
$url = "https://www.google.com/recaptcha/api/siteverify?secret=$secretKey&response=$value&remoteip=$userIP";
$response = \file_get_contents($url);
$response = json_decode((string)$response);
//dd($response);
if(!$response->success){
$this->addFlash('warning','Cocher le champs recaptcha svp!');
return $this->render('front/inscriptions/formation-a-la-carte.html.twig',[
'annee' => $annee,
'mentions' => $mentions,
'demandeformationsForm' => $demandeformationsForm->createView(),
]);
}
*/
$response = $this->client->request(
'POST',
'https://www.google.com/recaptcha/api/siteverify',
[
'body' => [
'secret' => $_ENV['RECAPTCHA_SECRET_KEY'],
'response' => $token,
]
]
);
$result = $response->toArray();
if (!$result['success'] || !isset($result['score']) || $result['score'] < 0.5) {
$this->addFlash(
'warning',
'Vérification reCAPTCHA échouée.'
);
return $this->render('front/inscriptions/formation-a-la-carte.html.twig',[
'annee' => $annee,
'mentions' => $mentions,
'demandeformationsForm' => $demandeformationsForm->createView(),
]);
}
$email = (new Email())
->from('CIMEF International <inscriptions@cimef-international.org>')
->to($destinataire) // destinataire principal
->cc('medias@cimef-international.com') // COPIE
->replyTo($expediteur) // Reply-To:
->subject($suj)
->text(strip_tags($codehtml))
->html($codehtml);// Subject:
//->html($codehtml, 'text/html'); // Content-Type + charset utf-8
$mailer->send($email);
$this->addFlash(
'success',
'Votre inscription à été bien enregistrée');
return $this->redirectToRoute('front.inter.index');
}
return $this->render('front/inscriptions/formation-a-la-carte.html.twig',[
'annee' => $annee,
'mentions' => $mentions,
'demandeformationsForm' => $demandeformationsForm->createView(),
]);
}
#[Route('/formations/seminaires-internationaux/{slug}/{id}code', name: 'front.seminaire.inter.detail', methods:['GET'])]
public function detail_sem_int(
$slug,
$id,
Request $request,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
$type = "Séminaires internationaux";
$annee = date('Y');
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select('for.id', 'for.dates_session', 'for.prix', 'for.devise', 'th.nom',
'thm.nom AS thmnom','vil.nom AS vilnom','vil.pays','for.created_at',
'th.slug','th.description','for.devise','vil.longitude','vil.latitude'
)
->from(Formations::class, 'for')
->innerJoin(Themes::class, 'th', 'WITH', 'for.theme = th.id')
->innerJoin(Villes::class, 'vil', 'WITH', 'for.ville = vil.id')
->innerJoin(Thematiques::class, 'thm', 'WITH', 'th.thematique = thm.id')
->where('th.slug = :theme')
->andwhere('for.id = :forid')
->setParameter('theme', $slug)
->setParameter('forid', $id);
$query = $queryBuilder->getQuery()->getResult();
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select('for.id', 'for.dates_session', 'for.prix', 'for.devise', 'th.nom',
'thm.nom AS thmnom','vil.nom AS vilnom','vil.pays','for.created_at',
'th.slug','th.description','for.devise','vil.longitude','vil.latitude',
'for.image'
)
->from(Formations::class, 'for')
->innerJoin(Themes::class, 'th', 'WITH', 'for.theme = th.id')
->innerJoin(Villes::class, 'vil', 'WITH', 'for.ville = vil.id')
->innerJoin(Thematiques::class, 'thm', 'WITH', 'th.thematique = thm.id')
->where('th.slug = :theme')
->andwhere('for.id != :forid')
->setParameter('theme', $slug)
->setParameter('forid', $id);
$formations = $queryBuilder->getQuery()->getResult();
$mentions = $mentionRepository->findAll();
$locations = [];
foreach ($query as $row) {
if (!empty($row['latitude']) && !empty($row['longitude'])) {
$locations[] = [
'lat' => (float) $row['latitude'],
'lng' => (float) $row['longitude'],
'ville' => strtoupper($row['vilnom']),
'pays' => strtoupper($row['pays']),
];
}
}
return $this->render('front/detail/detail-seminaire-inter.html.twig',[
'formations' => $formations,
'locations' => $locations,
'mentions' => $mentions,
'annee' => $annee,
'type' => $type,
'query' => $query,
'slug' => $slug
]);
}
#[Route('/formations/seminaires-nationaux/{slug}/{id}code', name: 'front.seminaire.nation.detail', methods:['GET'])]
public function detail_sem_nat(
$slug,
$id,
Request $request,
GeoIpService $geo,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
$type = "Séminaires nationaux";
$annee = date('Y');
// 🌍 Géo IP
$geoData = $geo->getGeoData($request->getClientIp());
$pays = $geoData['country'] ?? '';
$ville = $geoData['city'] ?? '';
// Correction du nom du pays
if ($pays === 'Local' || $pays === 'Ivory Coast') {
$getpays = "Côte d'ivoire";
} else {
$getpays = $pays;
}
//dd($getpays);
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select('for.id', 'for.dates_session', 'for.prix', 'for.devise', 'th.nom',
'thm.nom AS thmnom','vil.nom AS vilnom','vil.pays','for.created_at',
'th.slug','th.description','for.devise','vil.longitude','vil.latitude'
)
->from(Formations::class, 'for')
->innerJoin(Themes::class, 'th', 'WITH', 'for.theme = th.id')
->innerJoin(Villes::class, 'vil', 'WITH', 'for.ville = vil.id')
->innerJoin(Thematiques::class, 'thm', 'WITH', 'th.thematique = thm.id')
->where('th.slug = :theme')
->andwhere('for.id = :forid')
->setParameter('theme', $slug)
->setParameter('forid', $id);
$query = $queryBuilder->getQuery()->getResult();
$mentions = $mentionRepository->findAll();
$locations = [];
foreach ($query as $row) {
if (!empty($row['latitude']) && !empty($row['longitude'])) {
$locations[] = [
'lat' => (float) $row['latitude'],
'lng' => (float) $row['longitude'],
'ville' => strtoupper($row['vilnom']),
'pays' => strtoupper($row['pays']),
];
}
}
$today = new \DateTime('today');
// Fonction pour extraire date de début et fin depuis dates_session
$extractDates = function(?string $datesSession): ?array {
if (!$datesSession) return null;
$moisFr = [
'janv'=>1,'janvier'=>1,'févr'=>2,'fevr'=>2,'février'=>2,
'mars'=>3,'avr'=>4,'avril'=>4,'mai'=>5,'juin'=>6,
'juil'=>7,'juillet'=>7,'août'=>8,'aout'=>8,
'sept'=>9,'septembre'=>9,'oct'=>10,'octobre'=>10,
'nov'=>11,'novembre'=>11,'déc'=>12,'dec'=>12,'décembre'=>12
];
$text = strtolower(trim($datesSession));
$text = str_replace(['.', ','], '', $text);
if (preg_match('/(\d{1,2})\s*(\w+)?\s*au\s*(\d{1,2})\s*(\w+)?/i', $text, $m)) {
$jourDebut = (int)$m[1];
$moisDebut = $moisFr[$m[2] ?? ''] ?? null;
$jourFin = (int)$m[3];
$moisFin = $moisFr[$m[4] ?? ''] ?? $moisDebut;
if (!$moisDebut || !$moisFin) return null;
$annee = (int)date('Y');
$dateDebut = new \DateTime(sprintf('%04d-%02d-%02d', $annee, $moisDebut, $jourDebut));
$dateFin = new \DateTime(sprintf('%04d-%02d-%02d', $annee, $moisFin, $jourFin));
if ($dateFin < $dateDebut) $dateFin->modify('+1 year');
return ['debut' => $dateDebut, 'fin' => $dateFin];
}
return null;
};
// Requête Doctrine
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select('for.id', 'for.dates_session', 'for.prix', 'for.devise', 'th.nom',
'thm.nom AS thmnom','vil.nom AS vilnom','vil.pays','for.created_at',
'th.slug','th.description','for.devise','vil.longitude','vil.latitude',
'for.image'
)
->from(Formations::class, 'for')
->innerJoin(Themes::class, 'th', 'WITH', 'for.theme = th.id')
->innerJoin(Villes::class, 'vil', 'WITH', 'for.ville = vil.id')
->innerJoin(Thematiques::class, 'thm', 'WITH', 'th.thematique = thm.id')
->where('th.slug = :theme')
->andWhere('for.id != :forid')
->andWhere('vil.pays = :pays')
->setParameter('theme', $slug)
->setParameter('forid', $id)
->setParameter('pays', $getpays);
$results = $queryBuilder->getQuery()->getResult();
// Filtrer uniquement les formations à venir
$formations = array_filter($results, function($f) use ($extractDates, $today) {
$dates = $extractDates($f['dates_session']);
return $dates && $dates['debut'] > $today;
});
// Trier par date de début la plus proche
usort($formations, function($a, $b) use ($extractDates) {
return $extractDates($a['dates_session'])['debut'] <=> $extractDates($b['dates_session'])['debut'];
});
// Maintenant $formationsAvenir contient uniquement les formations à venir
return $this->render('front/detail/detail-seminaire-inter.html.twig',[
'formations' => $formations,
'locations' => $locations,
'annee' => $annee,
'type' => $type,
'mentions' => $mentions,
'query' => $query,
'slug' => $slug
]);
}
#[Route('/blogs', name: 'front.blog', methods:['GET'])]
public function blog(
Request $request,
MentionsRepository $mentionRepository,
ManagementsRepository $managementRepository,
PaginatorInterface $paginator,
BlogsRepository $blogRepository,
EntityManagerInterface $entityManager
): Response
{
$All_blog = $blogRepository->findBy(['statut' => 'Publié'], ['createdat' => 'DESC']);
$manageLimit = $managementRepository->findBy([], ['id' => 'DESC'], 10 );
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select('blog')
->from(Blogs::class, 'blog')
->where('blog.statut = :statut')
->setParameter('statut', 'Publié')
->orderBy('blog.createdat', 'DESC');
$pagination = $paginator->paginate(
$queryBuilder,
$request->query->getInt('page', 1),
12
);
$last_blog = $blogRepository->findBy(['statut' => 'Publié'], ['createdat' => 'DESC'],limit: 4);
$mentions = $mentionRepository->findAll();
return $this->render('front/blog.html.twig',[
'mentions' => $mentions,
'last_blog' => $last_blog,
'pagination' => $pagination,
'manageLimit' => $manageLimit
]);
}
#[Route('/blog/{slug}', name: 'front.detail.blog', methods:['GET','POST'])]
public function detailblog(
$slug,
Request $request,
BlogsRepository $blogRepository,
MentionsRepository $mentionRepository,
ManagementsRepository $managementRepository,
EntityManagerInterface $entityManager
): Response
{
$Allblog = $blogRepository->findAll();
$detblog = $blogRepository->findOneBy(array('slug' => $slug));
$last_blog = $blogRepository->findBy([], ['createdat' => 'ASC']);
$manageLimit = $managementRepository->findBy([], ['id' => 'DESC'], 10 );
$mentions = $mentionRepository->findAll();
return $this->render('front/detail/detail-blog.html.twig',[
'detblog' => $detblog,
'blog' => $Allblog,
'mentions' => $mentions,
'last_blog' => $last_blog,
'manageLimit' => $manageLimit
]);
}
#[Route('/actualites', name: 'front.actualite', methods:['GET'])]
public function actualite(
Request $request,
MentionsRepository $mentionRepository,
ManagementsRepository $managementRepository,
PaginatorInterface $paginator,
ActualitesRepository $actualiteRepository,
EntityManagerInterface $entityManager
): Response
{
$All_actu = $actualiteRepository->findBy(['statut' => 'Publié'], ['createdat' => 'DESC']);
$manageLimit = $managementRepository->findBy([], ['id' => 'DESC'], 10 );
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select('actu')
->from(Actualites::class, 'actu')
->where('actu.statut = :statut')
->setParameter('statut', 'Publié')
->orderBy('actu.createdat', 'DESC');
$pagination = $paginator->paginate(
$queryBuilder,
$request->query->getInt('page', 1),
12
);
$last_actu = $actualiteRepository->findBy(['statut' => 'Publié'], ['createdat' => 'DESC'],limit: 4);
$mentions = $mentionRepository->findAll();
return $this->render('front/actualite.html.twig',[
'mentions' => $mentions,
'last_actu' => $last_actu,
'pagination' => $pagination,
'manageLimit' => $manageLimit
]);
}
#[Route('/actualite/{slug}', name: 'front.detail.actu', methods:['GET','POST'])]
public function detailactu(
$slug,
Request $request,
ActualitesRepository $actuRepository,
MentionsRepository $mentionRepository,
ManagementsRepository $managementRepository,
EntityManagerInterface $entityManager
): Response
{
$Allactu = $actuRepository->findAll();
$detactu = $actuRepository->findOneBy(array('slug' => $slug));
$last_actu = $actuRepository->findBy([], ['createdat' => 'ASC']);
$manageLimit = $managementRepository->findBy([], ['id' => 'DESC'], 10 );
$mentions = $mentionRepository->findAll();
return $this->render('front/detail/detail-actualite.html.twig',[
'detactu' => $detactu,
'actualite' => $Allactu,
'mentions' => $mentions,
'last_actu' => $last_actu,
'manageLimit' => $manageLimit
]);
}
#[Route('/mentions/{slug}', name: 'front.mention.detail', methods:['GET','POST'])]
public function detailmention(
$slug,
Request $request,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
$detmention = $mentionRepository->findOneBy(array('slug' => $slug));
$mentions = $mentionRepository->findAll();
return $this->render('front/detail/detail-mention.html.twig',[
'detmention' => $detmention,
'mentions' => $mentions,
]);
}
#[Route('/presentation/nos-centres', name: 'front.centres', methods:['GET'])]
public function centres(
Request $request,
VillesRepository $villeRepository,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
$Ville = $villeRepository->findAll();
$locations = [
[
'lat' => 5.399573993486265,
'lng' => -3.9608326481739446,
'ville' => 'ABIDJAN',
'Pays' => 'CÔTE D\'IVOIRE',
],
[
'lat' => 48.82503553852063,
'lng' => 2.3943687952459913,
'ville' => 'PARIS',
'pays' => 'FRANCE',
],
[
'lat' => 33.61983014582587,
'lng' => -7.591902517162099,
'ville' => 'CASABLANCA',
'pays' => 'MAROC',
],
[
'lat' => 14.671959307245515,
'lng' => -17.428349942742518,
'ville' => 'DAKAR',
'pays' => 'SENEGAL',
],
[
'lat' => 25.222641788192867,
'lng' => 55.4419721341237,
'ville' => 'DUBAI',
'pays' => 'EMIRATS ARABES UNIS',
],
[
'lat' => 41.008441347309684,
'lng' => 28.969801288596543,
'ville' => 'ISTANBUL',
'pays' => 'TURQUIE',
],
[
'lat' => 40.71278802621601,
'lng' => -74.0050546180957,
'ville' => 'NEW YORK',
'pays' => 'USA',
],
[
'lat' => 45.50191624423104,
'lng' => -73.57059318260778,
'ville' => 'MONTREAL',
'pays' => 'CANADA',
],
[
'lat' => 31.25354887891074,
'lng' => 121.44798285112802,
'ville' => 'SHANGHAI',
'pays' => 'CHNE',
],
];
$mentions = $mentionRepository->findAll();
return $this->render('front/centres.html.twig',[
'locations' => $locations,
'mentions' => $mentions,
'ville' => $Ville
]);
}
#[Route('/presentation/nos-partenaires', name: 'front.nos-partenaires', methods:['GET'])]
public function partenaires(
Request $request,
PartenairesRepository $partenaireRepository,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
$partenaires = $partenaireRepository->findAll();
$groupes = [];
foreach ($partenaires as $p) {
$groupes[$p->getPaysPart()][] = $p;
}
$mentions = $mentionRepository->findAll();
return $this->render('front/partenaire.html.twig',[
'mentions' => $mentions,
'groupes' => $groupes
]);
}
#[Route('/presentation/nos-centres/{slug}', name: 'front.detail.centre', methods:['GET'])]
public function detail_centre(
$slug,
Request $request,
GaleriesRepository $galRepository,
VillesRepository $villeRepository,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select('gal.imgGal', 'gal.nom')
->from(Galeries::class, 'gal')
->where('gal.nom = :nom')
->setParameter('nom', $slug);
$detgal = $queryBuilder->getQuery()->getResult();
//$detgal = $galRepository->findOneBy(array('nom' => $slug));
//$detgal = $galRepository->findAll();
$detcentres = $villeRepository->findOneBy(array('slug' => $slug));
$mentions = $mentionRepository->findAll();
return $this->render('front/detail/detail-centre.html.twig',[
'slug' => $slug,
'detcentre' => $detcentres,
'mentions' => $mentions,
'detgal' => $detgal
]);
}
#[Route('/financement-des-etudes', name: 'front.financement.etude', methods:['GET','POST'])]
public function financement(): Response
{
return $this->render('front/admissions/financement.html.twig');
}
#[Route('/nos-thematiques', name: 'front.inter.thematique', methods:['GET','POST'])]
public function thematiques(
Request $request,
PaginatorInterface $paginator,
ThematiquesRepository $thematiqueRepository,
ManagementsRepository $managementRepository,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
$manageLimit = $managementRepository->findBy([], ['id' => 'DESC'], 10 );
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select('thm.id, thm.nom, thm.slug, thm.description, COUNT(th.id) AS nbThemes')
->from(Thematiques::class, 'thm')
->innerJoin(Themes::class, 'th', 'WITH', 'thm.id = th.thematique')
->groupBy('thm.id, thm.nom, thm.slug, thm.description');
$query = $queryBuilder->getQuery()->getResult();
$pagination = $paginator->paginate(
$queryBuilder,
$request->query->getInt('page', 1),
12
);
//dd($query);
$mentions = $mentionRepository->findAll();
return $this->render('front/thematique.html.twig',[
'manageLimit' => $manageLimit,
'pagination' => $query,
'mentions' => $mentions
]);
}
#[Route('/nos-thematiques/{slug}/code{id}', name: 'front.thematique.detail', methods: ['GET'])]
public function detail_thematique(
$id,
$slug,
Request $request,
PaginatorInterface $paginator,
ThemesRepository $themeRepository,
ThematiquesRepository $thematiqueRepository,
ManagementsRepository $managementRepository,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
$slug = strtolower(trim($slug));
$manageLimit = $managementRepository->findBy([], ['id' => 'DESC'], 10 );
$thematique = $thematiqueRepository->findOneBy(['slug' => $slug]);
// dd($slug);
$nomThematique = $thematique->getNom();
if (!$thematique) {
$this->addFlash('danger','Cette thématique est introuvable');
return $this->redirectToRoute('front.inter.thematique');
}
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select('th.id', 'th.nom', 'th.slug' , 'th.description')
->from(Themes::class, 'th')
->where('th.thematique = :id')
->setParameter('id', $id);
$query = $queryBuilder->getQuery()->getResult();
$pagination = $paginator->paginate(
$queryBuilder,
$request->query->getInt('page', 1),
12
);
//dd($slug);
$mentions = $mentionRepository->findAll();
return $this->render('front/detail/detail-thematique.html.twig',[
'nomThematique' => $nomThematique,
'manageLimit' => $manageLimit,
'thematique' => $thematique,
'pagination' => $query,
'mentions' => $mentions,
'slug' => $slug
]);
}
#[Route('/nos-thematiques/{slugThematique}/{slug}', name: 'front.thematique.date.theme', methods: ['GET'])]
public function detail_thematique_theme(
$slug,
$slugThematique,
Request $request,
SluggerInterface $slugger,
PaginatorInterface $paginator,
ThemesRepository $themeRepository,
ThematiquesRepository $thematiqueRepository,
FormationsRepository $formationRepository,
ManagementsRepository $managementRepository,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
$annee = date('Y');
$manageLimit = $managementRepository->findBy([], ['id' => 'DESC'], 10 );
$thematique = $thematiqueRepository->findOneBy(['slug' => $slugThematique]);
$theme = $themeRepository->findOneBy(['slug' => $slug]);
if (!$theme) {
$this->addFlash('danger','Cette thème est introuvable');
return $this->redirectToRoute('front.inter.thematique');
}
$themeId = $theme->getId();
$thematiqueId = $theme->getId();
$thematique = $thematiqueRepository->findOneBy(['slug' => $slugThematique]);
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select('th.nom','th.slug','thm.slug AS thematiqueSlug',
'th.description','vil.longitude','vil.latitude'
)
->from(Formations::class, 'for')
->innerJoin(Themes::class, 'th', 'WITH', 'for.theme = th.id')
->innerJoin(Thematiques::class, 'thm', 'WITH', 'th.thematique = thm.id')
->innerJoin(Villes::class, 'vil', 'WITH', 'for.ville = vil.id')
->where('th.slug = :themeSlug')
->andWhere('thm.slug = :thematiqueSlug')
->setParameter('themeSlug', $slug)
->setParameter('thematiqueSlug', $slugThematique)
->orderBy('for.created_at', 'DESC')
->setMaxResults(1);
$query = $queryBuilder->getQuery()->getResult();
//dd($query);
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select('for.id','vil.nom AS vilnom','vil.pays')
->from(Formations::class, 'for')
->innerJoin(Themes::class, 'th', 'WITH', 'for.theme = th.id')
->innerJoin(Villes::class, 'vil', 'WITH', 'for.ville = vil.id')
->innerJoin(Thematiques::class, 'thm', 'WITH', 'th.thematique = thm.id')
->where('for.theme = :id')
->setParameter('id', $themeId);
$ville = $queryBuilder->getQuery()->getResult();
//dd($query);
//dd($thematique);
$mentions = $mentionRepository->findAll();
return $this->render('front/detail/detail-thematique-theme-date.html.twig',[
'manageLimit' => $manageLimit,
'thematique' => $thematique,
'query' => $query,
'ville' => $ville,
'annee' => $annee,
'mentions' => $mentions,
'slug' => $slug,
'slugThematique' => $slugThematique
]);
}
#[Route('/inscription-{annee}', name: 'front.inscriptions', methods: ['GET', 'POST'])]
public function inscription(
Request $request,
MailerInterface $mailer,
ThemesRepository $themesRepository,
VillesRepository $villesRepository,
EntityManagerInterface $entityManager,
MentionsRepository $mentionRepository,
FormationsRepository $formationsRepository
): Response {
$annee = date('Y');
/* =========================
AJAX
========================= */
if ($request->isXmlHttpRequest()) {
/* THÉMATIQUE → THÈMES */
if ($request->request->get('action') === 'themes') {
$thematiqueVal = $request->request->get('thematiqueVal');
$themes = $themesRepository->findBy(
['thematique' => $thematiqueVal],
['nom' => 'ASC']
);
$data = [];
foreach ($themes as $theme) {
$data[] = [
'id' => $theme->getId(),
'nom' => $theme->getNom(),
];
}
return new JsonResponse($data);
}
/* THÈME → LIEUX */
if ($request->request->get('action') === 'lieux') {
$themeId = $request->request->get('themeVal');
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select(
'for.id', 'for.dates_session AS session', 'for.prix', 'for.devise', 'th.nom',
'vil.nom AS vilnom','vil.pays','for.created_at','th.slug',
'th.description','for.devise'
)
->from(Formations::class, 'for')
->innerJoin(Themes::class,'th', 'WITH', 'for.theme = th.id')
->innerJoin(Villes::class, 'vil', 'WITH', 'for.ville = vil.id')
->where('th.id = :idtheme')
->setParameter('idtheme', $themeId);
$formations = $queryBuilder->getQuery()->getResult();
//dump($themeId,$formations);
$data = [];
foreach ($formations as $formation) {
$data[] = [
'id' => $formation['id'],
'prix' => $formation['prix'],
'lieu' => $formation['vilnom'],
'devise' => $formation['devise'],
'session' => $formation['session'],
];
}
return new JsonResponse($data);
}
/* LIEU → SESSION + PRIX */
if ($request->request->get('action') === 'lieu_details') {
$formationId = $request->request->get('formationId');
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select(
'for.dates_session AS session',
'for.prix',
'for.devise'
)
->from(Formations::class, 'for')
->where('for.id = :id')
->setParameter('id', $formationId);
$formation = $queryBuilder->getQuery()->getOneOrNullResult();
if (!$formation) {
return new JsonResponse(['error' => 'Formation introuvable'], 404);
}
return new JsonResponse([
'session' => $formation['session'],
'prix' => $formation['prix'],
'devise' => $formation['devise'],
]);
}
}
/* =========================
AFFICHAGE NORMAL
========================= */
$inscription = new Inscriptions();
$form = $this->createForm(NewInscriptionFormType::class);
$form->handleRequest($request);
if ($form->isSubmitted()) {
$civilite = $form->get('civilite')->getData();
$nom = $form->get('nom')->getData();
$prenoms = $form->get('prenoms')->getData();
$fonction = $form->get('fonction')->getData();
$telephone = $form->get('telephone')->getData();
$adresse = $form->get('adresse')->getData();
$mail = $form->get('mail')->getData();
$entreprise = $form->get('entreprise')->getData();
$siteweb = $form->get('siteweb')->getData();
$nombrepart = $form->get('nbparticipant')->getData();
$pays = $form->get('pays')->getData();
$ville = $form->get('ville')->getData();
$boitepostale = $form->get('boitepostale')->getData();
$whatsapp = $form->get('whatsapp')->getData();
$theme = $form->get('theme')->getData();
//$lieu = $form->get('lieu')->getData();
$periode = $form->get('periode')->getData();
$telephone = $form->get('telephone')->getData();
$commentaire = $form->get('commentaire')->getData();
$token = $form->get('recaptchaToken')->getData();
if(!$commentaire){
$commentaire = "pas renseigné";
}else{
$commentaire = $form->get('commentaire')->getData();
}
if(!$siteweb){
$siteweb = "pas renseigné";
}else{
$siteweb = $form->get('siteweb')->getData();
}
if(!$adresse){
$adresse = "pas renseigné";
}else{
$adresse = $form->get('adresse')->getData();
}
if(!$boitepostale){
$boitepostale = "pas renseigné";
}else{
$boitepostale = $form->get('boitepostale')->getData();
}
$themeId = $theme->getId();
$nomtheme = $theme->getNom();
//dd($form);
$Seminaires = $formationsRepository->findOneBy(array('theme' => $themeId, 'dates_session' => $periode));
/*$formationId = $formations->getId();*/
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select(
'for.id', 'for.dates_session AS session', 'for.prix', 'for.devise', 'th.nom',
'vil.nom AS vilnom','vil.pays','for.created_at','th.slug', 'th.id AS themeId',
'th.description','for.devise'
)
->from(Formations::class, 'for')
->innerJoin(Themes::class,'th', 'WITH', 'for.theme = th.id')
->innerJoin(Villes::class, 'vil', 'WITH', 'for.ville = vil.id')
->where('th.id = :idtheme')
->andwhere('for.dates_session = :sessions')
->setParameter('idtheme', $themeId)
->setParameter('sessions', $periode);
$formations = $queryBuilder->getQuery()->getResult();
$villeForm = $formations[0]['vilnom'];
$prixForm = $formations[0]['prix'];
$deviseForm = $formations[0]['devise'];
//dd($villeForm, $villeForm, $prixForm, $deviseForm);
$destinataire = 'inscriptions@cimef-international.org';
$expediteur = $mail;
$reponse = $expediteur;
$suj = "INSCRIPTION FORMATION 2026";
$codehtml = '<html><body>'.
'<table width="100%" cellpadding="0" cellspacing="0" style="background-color:#f4f6f8; padding:20px;">
<tr>
<td align="center">
<table width="600" cellpadding="0" cellspacing="0" style="background-color:#ffffff; border-radius:6px; overflow:hidden; box-shadow:0 2px 6px rgba(0,0,0,0.08);">
<tr>
<td style="background-color:#051a53; padding:20px; color:#ffffff; text-align:center;">
<h2 style="margin:0;">Demande de dévis</h2>
</td>
</tr>
<tr>
<td style="padding:25px; color:#333333; font-size:14px; line-height:1.6;">
<p>Demande de dévis de '.$civilite.' <strong>'.$prenoms.' '.$nom.'</strong> pour une formation avec pour thème :<strong>'.$nomtheme.'</strong>.</p>
<p>Veuillez trouver ci-dessous le récapitulatif :</p>
<hr style="border:none; border-top:1px solid #e0e0e0; margin:20px 0;">
<h4 style="margin-bottom:8px; color:#0d6efd;">Informations personnelles</h4>
<p>
<strong>Nom & Prénoms :</strong> '.$prenoms.' '.$nom.'<br>
<strong>Fonction :</strong> '.$fonction.'<br>
<strong>Entreprise :</strong> '.$entreprise.'<br>
<strong>Adresse :</strong> '.$adresse.'<br>
<strong>Pays / Ville :</strong> '.$pays.' / '.$ville.'<br>
</p>
<h4 style="margin-bottom:8px; color:#0d6efd;">Coordonnées</h4>
<p>
<strong>Email :</strong> '.$mail.'<br>
<strong>Téléphone :</strong> '.$telephone.'<br>
<strong>Whatsapp :</strong> '.$whatsapp.'<br>
<strong>Site web :</strong> '.$siteweb.'
</p>
<h4 style="margin-bottom:8px; color:#0d6efd;">Détails de participation</h4>
<p>
<strong>Nombre de participants :</strong> '.$nombrepart.'<br>
<strong>Commentaire :</strong> '.$commentaire.'
</p>
<h4 style="margin-bottom:8px; color:#0d6efd;">Détail de la formation</h4>
<p>
<strong>Thème :</strong> '.$nomtheme.'<br>
<strong>Lieu :</strong> '.$villeForm.'<br>
<strong>Période :</strong> '.$periode.'<br>
<strong>Prix :</strong> '.$prixForm.' '.$deviseForm.'
</p>
</td>
</tr>
<tr>
<td style="background-color:#f1f1f1; padding:15px; text-align:center; font-size:12px; color:#777777;">
© '.date("Y").' CIMEF International — Tous droits réservés
</td>
</tr>
</table>
</td>
</tr>
</table>
</body></html>';
/*
$secretKey = '6LfPYkosAAAAAJQFLCC-9U5bF6KdFTPrgmbxg5Ux';
$value = $request->get('g-recaptcha-response');
if (!$value) { $this->addFlash('warning', 'Veuillez cocher le reCAPTCHA');
$this->addFlash('warning','Cocher le champs recaptcha svp!');
return $this->render('front/inscriptions/inscription-index.html.twig', [
'annee' => date('Y'),
'mentions' => $mentions,
'demandeformationsForm' => $form->createView(),
]);
}
$userIP = $_SERVER['REMOTE_ADDR'];
$url = "https://www.google.com/recaptcha/api/siteverify?secret=$secretKey&response=$value&remoteip=$userIP";
$response = \file_get_contents($url);
$response = json_decode((string)$response);
//dd($response);
if(!$response->success){
$this->addFlash('warning','Cocher le champs recaptcha svp!');
return $this->render('front/inscriptions/inscription-index.html.twig', [
'annee' => date('Y'),
'mentions' => $mentions,
'demandeformationsForm' => $form->createView(),
]);
}
*/
$response = $this->client->request(
'POST',
'https://www.google.com/recaptcha/api/siteverify',
[
'body' => [
'secret' => $_ENV['RECAPTCHA_SECRET_KEY'],
'response' => $token,
]
]
);
$result = $response->toArray();
if (!$result['success'] || !isset($result['score']) || $result['score'] < 0.5) {
$this->addFlash(
'warning',
'Vérification reCAPTCHA échouée.'
);
$mentions = $mentionRepository->findAll();
return $this->render('front/inscriptions/inscription-index.html.twig', [
'annee' => date('Y'),
'mentions' => $mentions,
'demandeformationsForm' => $form->createView(),
]);
}
$email = (new Email())
->from('CIMEF International <inscriptions@cimef-international.org>')
->to($destinataire) // destinataire principal
->cc('medias@cimef-international.com') // COPIE
->replyTo($expediteur) // Reply-To:
->subject($suj)
->text(strip_tags($codehtml))
->html($codehtml);// Subject:
//->html($codehtml, 'text/html'); // Content-Type + charset utf-8
$mailer->send($email);
$inscription->setNom($nom);
$inscription->setPrenoms($prenoms);
$inscription->setFonction($fonction);
$inscription->setAdresse($adresse);
$inscription->setMail($mail);
$inscription->setEntreprise($entreprise);
$inscription->setSiteweb($siteweb);
$inscription->setNbparticipant($nombrepart);
$inscription->setPays($pays);
$inscription->setVille( $ville);
$inscription->setBoitepostale($boitepostale);
$inscription->setWhatsapp($whatsapp);
$inscription->setTelephone($telephone);
$inscription->setCommentaire($commentaire);
$inscription->setFormation($Seminaires);
$entityManager->persist($inscription);
$entityManager->flush();
$this->addFlash(
'success',
'Votre inscription à été bien enregistrée');
return $this->redirectToRoute('front.inscriptions',['annee' => $annee]);
}
$mentions = $mentionRepository->findAll();
return $this->render('front/inscriptions/inscription-index.html.twig', [
'annee' => date('Y'),
'mentions' => $mentions,
'demandeformationsForm' => $form->createView(),
]);
}
#[Route('/catalogue-CIMEF-INTERNATIONAL-2026', name: 'front.catalogue', methods:['GET'])]
public function catalogue(
Request $request,
ManagementsRepository $managementRepository,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
return $this->render('front/cato.html.twig',[
'no_base_style' => true
]);
}
#[Route('/contact', name: 'front.contact', methods:['GET','POST'])]
public function contact(
Request $request,
MailerInterface $mailer,
MentionsRepository $mentionRepository,
EntityManagerInterface $entityManager
): Response
{
$mentions = $mentionRepository->findAll();
$contactForm = $this->createForm(ContactFormType::class);
$contactForm->handleRequest($request);
if($contactForm->isSubmitted()){
$nom = htmlspecialchars($contactForm->get('nom')->getData());
$mail = htmlspecialchars($contactForm->get('email')->getData());
$sujet = htmlspecialchars($contactForm->get('sujet')->getData());
$contact = htmlspecialchars($contactForm->get('contact')->getData());
$message = htmlspecialchars($contactForm->get('message')->getData());
$token = $contactForm->get('recaptchaToken')->getData();
$besoinArray = $contactForm->get('besoin')->getData();
$besoin = implode(', ', array_map('htmlspecialchars', $besoinArray));
$response = $this->client->request(
'POST',
'https://www.google.com/recaptcha/api/siteverify',
[
'body' => [
'secret' => $_ENV['RECAPTCHA_SECRET_KEY'],
'response' => $token,
]
]
);
$result = $response->toArray();
if (!$result['success'] || !isset($result['score']) || $result['score'] < 0.5) {
$this->addFlash(
'warning',
'Vérification reCAPTCHA échouée.'
);
return $this->render('front/contact.html.twig',[
'contactForm' => $contactForm->createView(),
'mentions' => $mentions
]);
}
$destinataire = 'contact@cimef-international.org';
$expediteur = $mail;
$reponse = $expediteur;
$suj = $sujet;
$codehtml = '
<!DOCTYPE html>
<html lang="fr">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Nouveau message de contact</title>
</head>
<body style="margin: 0; padding: 20px; font-family: Arial, sans-serif; background-color: #f8f9fa;">
<table width="100%" cellpadding="0" cellspacing="0" style="max-width: 700px; margin: 0 auto; background: white; border-radius: 10px; overflow: hidden; box-shadow: 0 4px 12px rgba(5, 26, 83, 0.1);">

<tr>
<td style="background: linear-gradient(135deg, #051a53 0%, #0a2a7a 100%); padding: 30px 30px 25px 30px; text-align: center; border-top: 4px solid #ff6600;">
<table width="100%" cellpadding="0" cellspacing="0">
<tr>
<td style="color: white; font-size: 28px; font-weight: bold; padding-bottom: 10px;">
CIMEF-INTERNATIONAL
</td>
</tr>
<tr>
<td style="color: white; font-size: 22px; font-weight: 600; padding-bottom: 8px;">
Nouveau message de contact
</td>
</tr>
<tr>
<td style="color: rgba(255, 255, 255, 0.9); font-size: 16px;">
Formulaire de contact • Site de CIMEF-INTERNATIONAL
</td>
</tr>
</table>
</td>
</tr>

<tr>
<td style="padding: 30px;">
<table width="100%" cellpadding="0" cellspacing="0">
<tr>
<td style="background-color: rgba(255, 102, 0, 0.1); color: #ff6600; padding: 10px 15px; border-radius: 20px; font-weight: bold; font-size: 14px; text-align: center; margin-bottom: 25px;">
Nouveau message reçu
</td>
</tr>
<tr>
<td style="padding-bottom: 20px; color: #555; line-height: 1.6;">
Bonjour,<br>
Un visiteur a rempli le formulaire de contact de votre site de formation.
</td>
</tr>

<tr>
<td>
<table width="100%" cellpadding="0" cellspacing="0" style="margin-bottom: 25px;">
<tr>
<td width="50%" style="padding: 15px; background-color: #f8f9ff; border-left: 4px solid #051a53; border-radius: 5px;">
<div style="font-size: 12px; color: #6c757d; font-weight: bold; text-transform: uppercase; margin-bottom: 5px;">
Nom complet
</div>
<div style="font-size: 16px; color: #051a53; font-weight: bold;">
'.$nom.'
</div>
</td>
<td width="10"></td>
<td width="50%" style="padding: 15px; background-color: #f8f9ff; border-left: 4px solid #ff6600; border-radius: 5px;">
<div style="font-size: 12px; color: #6c757d; font-weight: bold; text-transform: uppercase; margin-bottom: 5px;">
Adresse email
</div>
<div style="font-size: 16px; color: #ff6600; font-weight: bold;">
<a href="mailto:'.$mail.'" style="color: #ff6600; text-decoration: none;">'.$mail.'</a>
</div>
</td>
</tr>
<tr height="15"></tr>
<tr>
<td width="50%" style="padding: 15px; background-color: #f8f9ff; border-left: 4px solid #051a53; border-radius: 5px;">
<div style="font-size: 12px; color: #6c757d; font-weight: bold; text-transform: uppercase; margin-bottom: 5px;">
Objet du message
</div>
<div style="font-size: 16px; color: #051a53; font-weight: bold;">
'.$sujet.'
</div>
</td>
<td width="10"></td>
<td width="50%" style="padding: 15px; background-color: #f8f9ff; border-left: 4px solid #ff6600; border-radius: 5px;">
<div style="font-size: 12px; color: #6c757d; font-weight: bold; text-transform: uppercase; margin-bottom: 5px;">
Date d\'envoi
</div>
<div style="font-size: 16px; color: #051a53; font-weight: bold;">
'.$contact.'
</div>
</td>
</tr>
<tr height="15"></tr>
<tr>
<td width="100%" style="padding: 15px; background-color: #f8f9ff; border-left: 4px solid #051a53; border-radius: 5px;">
<div style="font-size: 12px; color: #6c757d; font-weight: bold; text-transform: uppercase; margin-bottom: 5px;">
Type de besoin
</div>
<div style="font-size: 16px; color: #051a53; font-weight: bold;">
'.$besoin.'
</div>
</td>
</tr>
</table>
</td>
</tr>

<tr>
<td>
<div style="color: #051a53; font-size: 18px; font-weight: bold; padding-bottom: 10px; border-bottom: 2px solid rgba(255, 102, 0, 0.3); margin-bottom: 15px;">
Message
</div>
<div style="background-color: #f8f9ff; padding: 20px; border-radius: 8px; border: 1px solid rgba(5, 26, 83, 0.1); white-space: pre-wrap; line-height: 1.6;">
'.$message.'
</div>
</td>
</tr>

<tr>
<td style="padding-top: 30px;">
<div style="background-color: rgba(5, 26, 83, 0.05); padding: 15px; border-radius: 8px; font-size: 14px; color: #555; line-height: 1.5;">
<strong style="color: #ff6600;">Information :</strong> Cet email a été envoyé automatiquement depuis le formulaire de contact de votre plateforme de formation.
</div>
</td>
</tr>
</table>
</td>
</tr>

<tr>
<td style="background-color: #f8f9ff; padding: 25px 30px; text-align: center; border-top: 1px solid rgba(5, 26, 83, 0.1);">
<div style="color: #051a53; font-size: 20px; font-weight: bold; margin-bottom: 10px;">
CIMEF-INTERNATIONAL
</div>
<div style="color: #6c757d; font-size: 14px; line-height: 1.5; margin-bottom: 20px;">
La formation précède la compétitivité
</div>
<div style="color: #6c757d; font-size: 12px; padding-top: 20px; border-top: 1px solid rgba(5, 26, 83, 0.1);">
© 2026 CIMEF-INTERNATIONAL. Tous droits réservés.<br>
Cet email a été généré automatiquement.
</div>
</td>
</tr>
</table>
</body>
</html>';
$email = (new Email())
->from('CIMEF International <contact@cimef-international.org>')
->to($destinataire) // destinataire principal
->replyTo($expediteur)
->subject($suj)
->text(strip_tags($codehtml))
->html($codehtml);
/*->html('<html><body>'.
'<p>Bonjour vous avez un nouveau message de M/Mme <b>'.$nom.' </b><br>'.
''.$message.'<br>'.
'Vous pouvez mecm\'écrire à l\'adresse suivante <b>'.$mail.'<br>'.
'</p>'.
'</body></html>');*/
$mailer->send($email);
$this->addFlash( 'success','Votre message a été envoyé');
return $this->redirectToRoute('front.contact');
}
return $this->render('front/contact.html.twig',[
'contactForm' => $contactForm->createView(),
'mentions' => $mentions
]);
}
#[Route('/formations/shanghai', name: 'front.inter.shanghai', methods:['GET'])]
public function shanghai(
Request $request,
MentionsRepository $mentionRepository,
ThemeshanghaiRepository $themeshanghaiRepository,
ManagementsRepository $managementRepository,
EntityManagerInterface $entityManager
): Response
{
$shanghai = $themeshanghaiRepository->findAll();
//dd($shanghai);
$manageLimit = $managementRepository->findBy([], ['id' => 'DESC'], 10 );
$queryBuilder = $entityManager->createQueryBuilder();
$queryBuilder
->select('for','th','thm','vil')
->from(Formations::class, 'for')
->innerJoin('for.theme', 'th')
->innerJoin('th.thematique', 'thm')
->innerJoin('for.ville', 'vil')
->Where('vil = :ville')
->setParameter('ville', 'SHANGHAI');
$formationShanghai = $queryBuilder->getQuery()->getResult();
$mentions = $mentionRepository->findAll();
return $this->render('front/shanghai.html.twig',[
'pagination' => $shanghai,
'manageLimit' => $manageLimit,
'mentions' => $mentions,
]);
}
}

src/Controller/FrontController.php line 235