src/Service/SejourService.php line 1703

Open in your IDE?
  1. <?php
  3. namespace App\Service;
  5. /**
  6.  * Created by PhpStorm.
  8.  * desc:  Service Sejout  ;
  9.  *
  10.  */
  12. use App\Entity\Emailing;
  13. use App\Entity\SejourAttachment;
  14. use App\Service\EmailsCmdService;
  15. use Swift_Image;
  16. use Twig\Environment;
  17. use App\Entity\Sejour;
  18. use App\Entity\Produit;
  19. use App\Entity\Attachment;
  20. use App\Entity\Commande;
  21. use App\Entity\PromoParents;
  22. use App\Entity\PromoSejour;
  23. use App\Entity\ComandeProduit;
  24. use App\Entity\ParentSejour;
  25. use App\Entity\Ref;
  26. use App\Entity\Position;
  27. use App\Entity\Likephoto;
  28. use App\Entity\User;
  29. use App\Entity\Etablisment;
  30. use App\Entity\Jourdescripdate;
  31. use App\Entity\LogPromotions;
  32. use App\Entity\PanierProduit;
  33. use App\Entity\Promotions;
  34. use Swift_Attachment;
  35. use setasign\Fpdi\Fpdi;
  36. use setasign\Fpdi\PdfReader;
  37. use Symfony\Component\HttpKernel\KernelInterface;
  38. use Symfony\Component\DependencyInjection\ParameterBag\ParameterBagInterface;
  39. use \DatePeriod;
  40. use \DateInterval;
  41. use DateTime;
  42. use Doctrine\Persistence\ManagerRegistry;
  43. use Symfony\Contracts\HttpClient\HttpClientInterface;
  44. use App\Repository\AttachmentRepository;
  45. use Symfony\Bridge\Twig\Mime\TemplatedEmail;
  46. use Symfony\Component\Mailer\MailerInterface;
  47. use Symfony\Component\Mime\Address;
  48. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  50. class SejourService
  51. {
  52.     private $em;
  53.     private $mailer;
  54.  
  55.     private $templating;
  56.     private $projectDir;
  57.     private $params;
  59.     private $client;
  60.     private $emailsCmdService;
  61.     private $sejourAttachmentRepository;
  62.     private $mailerInterface;
  64.     public function __construct(ManagerRegistry $em, \Swift_Mailer $mailer, Environment $templating, KernelInterface $kernel, ParameterBagInterface $params, HttpClientInterface $client, AttachmentRepository $sejourAttachmentRepository, EmailsCmdService $emailsCmdService, \Swift_Mailer $mailerInterface)
  65.     {
  66.         $this->em = $em;
  67.         $this->mailer = $mailer;
  68.       
  69.         $this->templating = $templating;
  70.         $this->projectDir = $kernel->getProjectDir();
  71.         $this->params = $params;
  72.       
  73.         $this->client = $client;
  74.         $this->sejourAttachmentRepository = $sejourAttachmentRepository;
  75.         $this->emailsCmdService = $emailsCmdService;
  76.         $this->mailerInterface = $mailerInterface;
  77.     }
  80.     function CreationNouveauSejour($themSejour, $adressSejour, $codePostal, $dateDebut, $FinSejour, $AgeDugroupe, $type, $userid, $NbEnfant, $connpay, $pays, $ville, $prixcnxparent = null, $prixcnxpartenaire = null, $reversecnxpart = null, $reverseventepart = null)
  81.     {
  83.         $sejour = new Sejour();
  84.         $sejour->setCodeSejour($this->GenrateCodeSejour($type, $connpay));
  86.         $sejour->setDateCreationCode(new \DateTime());
  89.         $sejour->setThemSejour($themSejour);
  90.         $sejour->setAdresseSejour($adressSejour);
  91.         if ($codePostal == "") {
  92.             $codePostal = 0;
  93.         }
  94.         $sejour->setCodePostal($codePostal);
  95.         $dateDebutFormat = date_create_from_format('Y-m-d', $dateDebut);
  96.         $sejour->setDateDebutSejour($dateDebutFormat);
  97.         $FinSejourSejour = date_create_from_format('Y-m-d', $FinSejour);
  98.         $sejour->setDateFinSejour($FinSejourSejour);
  100.         $FinSejourSejour->modify('+2 month');
  102.         $sejour->setDateFinCode($FinSejourSejour);
  104.         $Statut = $this->em->getRepository(Ref::class)->findOneBy(array('libiller' => "Crée"));
  106.         $sejour->setStatut($Statut);
  107.         $AgeDugroupeRef = $this->em->getRepository(Ref::class)->findOneBy(array('libiller' => $AgeDugroupe));
  109.         $sejour->setAgeGroup($AgeDugroupeRef);
  110.         $sejour->setNbenfan($NbEnfant);
  111.         $sejour->setNbenfantencours($NbEnfant);
  112.         $sejour->setPays($pays);
  113.         $sejour->setVille($ville);
  114.         $sejour->setPrixcnxparent($prixcnxparent);
  115.         $sejour->setPrixcnxpartenaire($prixcnxpartenaire);
  116.         $sejour->setReversecnxpart($reversecnxpart);
  117.         $sejour->setReverseventepart($reverseventepart);
  118.         //setif sejour gratuie ou non
  119.         $sejour->setPaym($connpay);
  121.         $this->em->getManager()->persist($sejour);
  122.         $this->em->getManager()->flush();
  124.         return $sejour;
  125.     }
  127.     function CreationNouveauSejourParAccompagnateur($themSejour, $adressSejour, $dateDebut, $FinSejour, $AgeDugroupe, $type, $NbEnfant, $connpay, $pays, $ville, $prixcnxparent, $prixcnxpartenaire, $reversecnxpart, $reverseventepart)
  128.     {
  130.         $sejour = new Sejour();
  131.         $sejour->setCodeSejour($this->GenrateCodeSejour($type, $connpay));
  133.         $sejour->setDateCreationCode(new \DateTime());
  135.         $sejour->setThemSejour($themSejour);
  136.         $sejour->setAdresseSejour($adressSejour);
  137.         $dateDebutFormat = date_create_from_format('Y-m-d', $dateDebut);
  138.         $sejour->setDateDebutSejour($dateDebutFormat);
  139.         $FinSejourSejour = date_create_from_format('Y-m-d', $FinSejour);
  140.         $dateFinCode = new \DateTime($FinSejour);
  141.         $dateFinCode->modify('+2 month');
  143.         $sejour->setDateFinCode($dateFinCode);
  144.         $sejour->setDateFinSejour($FinSejourSejour);
  145.         $Statut = $this->em->getRepository(Ref::class)->findOneBy(array('libiller' => "Crée"));
  147.         $sejour->setStatut($Statut);
  148.         $AgeDugroupeRef = $this->em->getRepository(Ref::class)->findOneBy(array('libiller' => $AgeDugroupe));
  150.         $sejour->setAgeGroup($AgeDugroupeRef);
  151.         $sejour->setNbenfan($NbEnfant);
  152.         $sejour->setNbenfantencours($NbEnfant);
  153.         $sejour->setPays($pays);
  154.         $sejour->setVille($ville);
  155.         $sejour->setPrixcnxparent($prixcnxparent);
  156.         $sejour->setPrixcnxpartenaire($prixcnxpartenaire);
  157.         $sejour->setReversecnxpart($reversecnxpart);
  158.         $sejour->setReverseventepart($reverseventepart);
  159.         //set if sejour gratuie ou non 
  160.         $sejour->setPaym($connpay);
  161.         $this->em->getManager()->persist($sejour);
  162.         $this->em->getManager()->flush();
  164.         return $sejour;
  165.     }
  167.     function EnvoyerEmailCodeSejour($idSejour, $TypeSejour)
  168.     {
  169.         $Sejour = $this->em->getRepository(Sejour::class)->find($idSejour);
  170.         $RefEmail = $this->em->getRepository(Ref::class)->find(28);
  172.         $Email = $this->em->getRepository(Emailing::class)->findOneBy(array('typeemail' => $RefEmail, 'statut' => 9));
  174.         $sendTo = $Sejour->getIdEtablisment()->getEmail();
  176.         $message = (new \Swift_Message('Votre code séjour 5sur5sejour'))
  177.             ->setFrom('contact@5sur5sejour.com')
  178.             ->setTo($sendTo);
  179.         //->setBcc(["contact@5sur5sejour.com"]);
  180.         $pathImage2 = $Email->getIdImage2()->getPath();
  181.         $pathImage1 = $Email->getIdImage1()->getPath();
  182.         $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  183.         $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  185.         $iconphoto = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  186.         $iconloca = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  187.         $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  188.         $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  189.         $message->setBody(
  190.             $this->templating->render(
  191.                 'emails/SendCode.html.twig',
  192.                 [
  193.                     "code" => $Sejour->getCodeSejour(),
  194.                     "dateCreation" => $Sejour->getDateCreationCode(),
  195.                     "dateFinCode" => $Sejour->getDateFinCode(),
  196.                     "lieu" => $Sejour->getAdresseSejour(),
  197.                     "image1" => $image1,
  198.                     "image2" => $image2,
  199.                     "iconfooter" => $iconfooter,
  200.                     "iconphoto" => $iconphoto,
  201.                     "iconloca" => $iconloca,
  202.                     "iconmsg" => $iconmsg,
  203.                     "destinataire" => $Sejour->getIdEtablisment()->getNometab()
  204.                 ]
  205.             ),
  206.             'text/html'
  207.         );
  208.         $signMail = $this->params->get('signMail');
  209.         if ($signMail == 'yes') {
  210.             $domainName = $this->params->get('domaine');
  211.             $selector = $this->params->get('selector');
  212.             $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  213.             $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  214.             $message->attachSigner($signer);
  215.         }
  216.         try {
  217.             $done = $this->mailer->send($message);
  218.             //var_dump($done);  
  219.             // var_dump("send it ");
  220.         } catch (\Swift_SwiftException $ex) {
  221.             //var_dump( $ex->getMessage());
  222.         }
  223.     }
  225.     function EnvoyerEmailCodeSejourAccompagnateur($idSejour)
  226.     {
  227.         $logo = '';
  228.         $nom = '';
  229.         $RefEmail = $this->em->getRepository(Ref::class)->find(21);
  231.         $Email = $this->em->getRepository(Emailing::class)->findOneBy(array('typeemail' => $RefEmail, 'statut' => 9));
  232.         $Sejour = $this->em->getRepository(Sejour::class)->find($idSejour);
  233.         if ($Sejour) {
  236.             //dd($sejour);
  237.             $pdf1 = new Fpdi();
  239.             $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  240.             $pdfFilepath1 = $publicDirectory . "Mode_emploi_5sur5sejour_v5_.pdf";
  242.             $pageCount = $pdf1->setSourceFile($pdfFilepath1);
  243.             $pageId = $pdf1->importPage(1, PdfReader\PageBoundaries::MEDIA_BOX);
  245.             $pdf1->addPage();
  246.             $pdf1->useImportedPage($pageId, 0.5, 0.5, 0.5);
  248.             $testText  = "abcdefghijklmnopqrstuvwxyz0123456789";
  250.             $current_date = date('d-M-Y');
  251.             $DateDebut =  "";
  252.             $DateFin = "";
  253.             $Theme = "";
  254.             $Lieu = "";
  255.             $CodeSejour =  "";
  256.             $MotPass =  "";
  257.             $Ville = "";
  258.             $Paye = "";
  261.             if ($Sejour) {
  262.                 $DateDebut = $Sejour->getDateDebutSejour();
  263.                 $DateFin = $Sejour->getDateFinSejour();
  264.                 $Theme = $Sejour->getThemSejour();
  265.                 $Lieu = $Sejour->getAdresseSejour();
  266.                 $CodeSejour = $Sejour->getCodeSejour();
  267.                 $MotPass = $Sejour->getIdAcommp()->getPasswordNonCripted();
  268.                 $Ville = $Sejour->getVille();
  269.                 $Paye = $Sejour->getPays();
  270.             }
  272.             for ($i = 0; $i < $pageCount; $i++) {
  273.                 $tplIdx = $pdf->importPage($i + 1);
  274.                 $pdf->useTemplate($tplIdx, 0, 0, 200, 300, true);
  275.                 $theme = $Theme;
  276.                 if (strlen($theme) > 25) {
  277.                     $pdf->SetFont("Arial", "", 5);
  278.                 } else {
  279.                     $pdf->SetFont("Arial", "", 7);
  280.                 }
  281.                 $strTheme = iconv("UTF-8", "WINDOWS-1252", $theme);
  282.                 $pdf->Text(35, 268, $strTheme);
  283.                 $pdf->SetFont("Arial", "", 8);
  284.                 $lieu = $Lieu;
  285.                 $ville = $Ville;
  286.                 $paye = $Paye;
  287.                 if ($Paye && $Ville) {
  288.                     $strLieu = iconv("UTF-8", "WINDOWS-1252", $ville . "  " . $paye);
  289.                     $pdf->Text(125, 268, $strLieu);
  290.                 } else if ($Paye) {
  291.                     $strLieu = iconv("UTF-8", "WINDOWS-1252", $paye);
  292.                     $pdf->Text(125, 268, $strLieu);
  293.                 } else {
  294.                     $strLieu = iconv("UTF-8", "WINDOWS-1252", $ville);
  295.                     $pdf->Text(125, 268, $strLieu);
  296.                 }
  298.                 $pdf->SetFont("Arial", "", 10);
  299.                 $pdf->Text(80, 279, $CodeSejour);
  300.                 $pdf->SetFont("Arial", "", 10);
  301.                 $pdf->Text(48, 258, $DateDebut->format('d/m/Y'));
  302.                 $pdf->SetFont("Arial", "", 10);
  303.                 $pdf->Text(89, 258, $DateFin->format('d/m/Y'));
  304.             }
  305.             if ($paym == 1) {
  306.                 $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  307.                 $pdfFilepath = $publicDirectory . "Mode d'emploi parent  5sur5séjour" . $idSejour . ".pdf";
  308.                 $pdf->Output($pdfFilepath, "F");
  309.             } else {
  310.                 $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  311.                 $pdfFilepath = $publicDirectory . "Mode d'emploi parent G 5sur5séjour " . $idSejour . ".pdf";
  312.                 $pdf->Output($pdfFilepath, "F");
  313.             }
  315.             $logo = $Sejour->getIdEtablisment()->getLogo();
  316.             $nom = $Sejour->getIdEtablisment()->getNometab();
  317.             $sendTo = $Sejour->getIdAcommp()->getReponseemail();
  318.             $message = (new \Swift_Message('Votre code séjour 5sur5sejour'))
  319.                 ->setFrom('contact@5sur5sejour.com')
  320.                 ->setTo($sendTo);
  321.             //->setBcc(["contact@5sur5sejour.com"]);
  322.             $pathImage2 = $Email->getIdImage2()->getPath();
  323.             $pathImage1 = $Email->getIdImage1()->getPath();
  324.             $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  325.             $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  326.             $iconphoto = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  327.             $iconloca = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  328.             $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  329.             $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  330.             if ($paym == 1) {
  331.                 $message->attach(\Swift_Attachment::fromPath($pdfFilepath));
  332.                 $message->attach(\Swift_Attachment::fromPath($pdfFilepath1));
  333.             } else {
  334.                 $message->attach(\Swift_Attachment::fromPath($pdfFilepath));
  335.                 $message->attach(\Swift_Attachment::fromPath($pdfFilepath1));
  336.             }
  337.             $message->setBody(
  338.                 $this->templating->render(
  339.                     'emails/SendCode.html.twig',
  340.                     [
  341.                         "Password" => $Sejour->getIdAcommp()->getPasswordNonCripted(),
  342.                         "code" => $Sejour->getCodeSejour(),
  343.                         "dateCreation" => $Sejour->getDateCreationCode(),
  344.                         "dateFinCode" => $Sejour->getDateFinCode(),
  345.                         "lieu" => $Sejour->getAdresseSejour(),
  346.                         "image1" => $image1,
  347.                         "image2" => $image2,
  348.                         "iconfooter" => $iconfooter,
  349.                         "iconphoto" => $iconphoto,
  350.                         "iconloca" => $iconloca,
  351.                         "iconmsg" => $iconmsg,
  352.                         'logo' => $logo,
  353.                         'nom' => $nom,
  354.                         "identifiant" => $Sejour->getCodeSejour(),
  355.                         'roles' => $Sejour->getIdAcommp()->getRoles(),
  356.                     ]
  357.                 ),
  358.                 'text/html'
  359.             );
  360.             $signMail = $this->params->get('signMail');
  361.             if ($signMail == 'yes') {
  362.                 $domainName = $this->params->get('domaine');
  363.                 $selector = $this->params->get('selector');
  364.                 $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  365.                 $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  366.                 $message->attachSigner($signer);
  367.             }
  368.             try {
  369.                 $this->mailer->send($message);
  370.             } catch (\Swift_SwiftException $ex) {
  371.                 $ex->getMessage();
  372.             }
  373.         }
  374.     }
  376.     function EnvoyerEmailNewAcco($emailsend, $accompagnateur, $idSejour, $passAcommpa)
  377.     {
  379.         $RefEmail = $this->em->getRepository(Ref::class)->find(16);
  381.         $Email = $this->em->getRepository(Emailing::class)->findOneBy(array('typeemail' => $RefEmail, 'statut' => 9));
  383.         $Sejour = $this->em->getRepository(Sejour::class)->find($idSejour);
  384.         $sendTo = $accompagnateur->getEmail();
  385.         $message = (new \Swift_Message('Bienvenue à 5sur5 séjour '))
  386.             ->setFrom('contact@5sur5sejour.com')
  387.             ->setTo($emailsend);
  388.         //->setBcc(["contact@5sur5sejour.com"]);
  389.         $pathImage2 = $Email->getIdImage2()->getPath();
  390.         $pathImage1 = $Email->getIdImage1()->getPath();
  391.         $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  392.         $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  393.         $iconphoto = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  394.         $iconloca = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  395.         $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  396.         $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  397.         $message->setBody(
  398.             $this->templating->render(
  399.                 'emails/DemandeCreationAcc.html.twig',
  400.                 [
  401.                     "Nomdestinataire" => $accompagnateur->getNom(),
  402.                     "Predestinataire" => $accompagnateur->getPrenom(),
  403.                     "code" => $Sejour->getCodeSejour(),
  404.                     "image1" => $image1,
  405.                     "image2" => $image2,
  406.                     "iconfooter" => $iconfooter,
  407.                     "iconphoto" => $iconphoto,
  408.                     "iconloca" => $iconloca,
  409.                     "iconmsg" => $iconmsg,
  410.                     "identifiant" => $sendTo,
  411.                     "roles" => $accompagnateur->getRoles(),
  412.                     'accompagnateur' => $accompagnateur,
  413.                     "passAcommpa" => $passAcommpa,
  414.                 ]
  415.             ),
  416.             'text/html'
  417.         );
  418.         $signMail = $this->params->get('signMail');
  419.         if ($signMail == 'yes') {
  420.             $domainName = $this->params->get('domaine');
  421.             $selector = $this->params->get('selector');
  422.             $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  423.             $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  424.             $message->attachSigner($signer);
  425.         }
  426.         try {
  427.             $this->mailer->send($message);
  428.         } catch (\Swift_SwiftException $ex) {
  429.             $ex->getMessage();
  430.         }
  431.     }
  433.     function EnvoyerEmailNewPartenaire($partenaire)
  434.     {
  435.         $logo = '';
  436.         $nom = '';
  437.         if ($partenaire->hasRole('ROLE_PARTENAIRE')) {
  438.             $logo = $partenaire->getLogourl();
  439.             $nom = $partenaire->getNometablisment();
  440.         }
  441.         $RefEmail = $this->em->getRepository(Ref::class)->find(17);
  442.         $Email = $this->em->getRepository(Emailing::class)->findOneBy(array('typeemail' => $RefEmail));
  443.         $sendTo = $partenaire->getEmail();
  444.         $message = (new \Swift_Message('Nouveau partenaire'))
  445.             ->setFrom('partenariat-contact@5sur5sejour.com')
  446.             ->setTo($sendTo)
  447.             ->setBcc(["contact@5sur5sejour.com"]);
  448.         $pathImage2 = $Email->getIdImage2()->getPath();
  449.         $pathImage1 = $Email->getIdImage1()->getPath();
  450.         $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  451.         $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  452.         $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  453.         $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  454.         $icon2 = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  455.         $icon3 = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  457.         $message->setBody(
  458.             $this->templating->render(
  459.                 'emails/NewPartenaireEmail.html.twig',
  460.                 [
  461.                     "Nomdestinataire" => $partenaire->getNom(),
  462.                     "Predestinataire" => $partenaire->getPrenom(),
  463.                     "password" => $partenaire->getPasswordNonCripted(),
  464.                     "image1" => $image1,
  465.                     "image2" => $image2,
  466.                     "icon2" => $icon2,
  467.                     "icon3" => $icon3,
  468.                     "iconfooter" => $iconfooter,
  469.                     "iconmsg" => $iconmsg,
  470.                     "idPartenaire" => $partenaire->getId(),
  471.                     "identifiant" => $sendTo,
  472.                     "password" => $partenaire->getPasswordNonCripted(),
  473.                     'logo' => $logo,
  474.                     'nom' => $nom,
  475.                 ]
  476.             ),
  477.             'text/html'
  478.         );
  479.         $signMail = $this->params->get('signMail');
  480.         if ($signMail == 'yes') {
  481.             $domainName = $this->params->get('domaine');
  482.             $selector = $this->params->get('selector');
  483.             $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  484.             $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  485.             $message->attachSigner($signer);
  486.         }
  487.         try {
  488.             $this->mailer->send($message);
  489.         } catch (\Swift_SwiftException $ex) {
  490.             $ex->getMessage();
  491.         }
  492.     }
  494.     function affecterEtablissement($sejour, $etablissement)
  495.     {
  496.         $sejour->setIdEtablisment($etablissement);
  497.         $this->em->getManager()->persist($sejour);
  498.         $this->em->getManager()->flush();
  499.     }
  501.     function affecterAccompaniateur($sejour, $accomp)
  502.     {
  503.         $sejour->setIdAcommp($accomp);
  504.         $this->em->getManager()->persist($sejour);
  505.         $this->em->getManager()->flush();
  506.     }
  508.     function affecterPartenaire($sejour, $etabUser)
  509.     {
  510.         $sejour->setIdPartenaire($etabUser);
  511.         $this->em->getManager()->persist($sejour);
  512.         $this->em->getManager()->flush();
  513.     }
  515.     function affecteretablisment($sejour, $Etablisment)
  516.     {
  517.         $sejour->setIdEtablisment($Etablisment);
  518.         $this->em->getManager()->persist($sejour);
  519.         $this->em->getManager()->flush();
  520.     }
  522.     function GenrateCodeSejour($type, $connpay)
  523.     {
  524.         $Typeabr = "IN";
  525.         $pay = "";
  526.         if ($type == "ECOLES/AUTRES") {
  527.             $Typeabr = "E";
  528.         } elseif ($type == "PARTENAIRES/VOYAGISTES") {
  529.             $Typeabr = "P";
  530.         } elseif ($type == "CSE") {
  531.             $Typeabr = "C";
  532.         }
  533.         if ($connpay == 0) {
  534.             $pay = "F";
  535.         }
  536.         if ($connpay == 1) {
  537.             $pay = "P";
  538.         }
  539.         $date = new \Datetime();
  540.         $Milliseconde = $date->format('u');
  542.         $code = $Typeabr . $pay . $Milliseconde;
  544.         return $code;
  545.     }
  547.     function index($dateTimeDebut, $dateTimeFin)
  548.     {
  549.         if ($dateTimeDebut == null) {
  550.             $Sejours = $this->em->getRepository(Sejour::class)->searshAllSejour();
  551.             //  dd(count($Sejours));
  552.         } else {
  553.             $Sejours = $this->em->getRepository(Sejour::class)->searshDate($dateTimeDebut, $dateTimeFin);
  554.         }
  555.         return $Sejours;
  556.     }
  558.     function getsejour($id)
  559.     {
  560.         $Sejour = $this->em->getRepository(Sejour::class)->find($id);
  561.         return $Sejour;
  562.     }
  564.     function getsejourByAcc($id, $user)
  565.     {
  566.         $Sejour = $this->em->getRepository(Sejour::class)->findOneBy(array("id" => $id, "idAcommp" => $user));
  567.         return $Sejour;
  568.     }
  570.     function getsejourByItab($idEtablisment)
  571.     {
  572.         $Sejour = $this->em->getRepository(Sejour::class)->findBy(array("idEtablisment" => $idEtablisment));
  573.         return $Sejour;
  574.     }
  576.     function getNbreconnxparsejour($id)
  577.     {
  579.         $Sejourfind = $this->em->getRepository(Sejour::class)->find($id);
  580.         if ((substr($Sejourfind->getCodeSejour(), 1, 1) == 'P')) {
  581.             $Sejour = $this->em->getRepository(ParentSejour::class)->findby(['idSejour' => $id, 'payment' => 1]);
  582.         } elseif ((substr($Sejourfind->getCodeSejour(), 1, 1) == 'F')) {
  583.             $Sejour = $this->em->getRepository(ParentSejour::class)->findby(['idSejour' => $id]);
  584.         }
  586.         $NB = sizeof($Sejour);
  588.         return $NB;
  589.     }
  591.     //a terminier le nombre enfant par sejour
  593.     function Nbpersonnecnnx($id)
  594.     {
  595.         $Nbpconnx = $this->em->getRepository(ComandeProduit::class)->searshNbpersoneparNbcnnx($id);
  596.         return $Nbpconnx;
  597.     }
  599.     function Nbpersonnesejour($id)
  600.     {
  601.         $Nbpersone = $this->em->getRepository(ParentSejour::class)->searshNbperpersonneSjour($id);
  602.         return $Nbpersone;
  603.     }
  605.     function nombreenfantparsejour($id)
  606.     {
  607.         $Nbenfant = $this->em->getRepository(sejour::class)->searshNbperson($id);
  608.         return $Nbenfant;
  609.     }
  611.     function Nbpecnnxsejourtype($type, $date = null)
  612.     {
  613.         if ($date == null) {
  614.             $Nbcnxnxpartype = $this->em->getRepository(ParentSejour::class)->searshNBcnnxParSejour($type);
  615.         } else {
  616.             $Nbcnxnxpartype = $this->em->getRepository(ParentSejour::class)->searshNBcnnxParSejourByDate($type, $date);
  617.         }
  618.         return $Nbcnxnxpartype;
  619.     }
  621.     function Nbcommandepartypesejour($type, $date = null)
  622.     {
  623.         if ($date == null) {
  624.             $Nbdemandpartype = $this->em->getRepository(ParentSejour::class)->searshNBcommandeParSejour($type);
  625.         } else {
  626.             $Nbdemandpartype = $this->em->getRepository(ParentSejour::class)->searshNBcommandeParSejourByDate($type, $date);
  627.         }
  628.         return $Nbdemandpartype;
  629.     }
  631.     function Moyenpainierpartypesejour($type, $dateTimeDebut, $dateTimeFin)
  632.     {
  633.         if ($dateTimeDebut == null || $dateTimeFin == null) {
  634.             $panier = $this->em->getRepository(Produit::class)->searshPanierMoyen($type);
  635.         } else {
  636.             $panier = $this->em->getRepository(Produit::class)->searshPanierMoyenByDate($type, $dateTimeDebut, $dateTimeFin);
  637.         }
  638.         return $panier;
  639.     }
  641.     public function typeproduitsevice($id)
  642.     {
  645.         $prod = $this->em->getRepository(Produit::class)->findby(array('idsjour' => $id));
  647.         return $prod;
  648.     }
  650.     public function getatachmentsejour($id): array
  651.     {
  652.         $liste = $this->em->getRepository(Attachment::class)->searshSejourAtachment($id);
  653.         return $liste;
  654.     }
  655.     /**
  656.      * Gets the list of attachements based on the sejour id and attachement type
  657.      * @param string $id The sejour id
  658.      * @param string $type The attachement type
  659.      * @return array The list of photos avec pagination
  660.      */
  661.     public function getCombinedattachSejourPaginee(string $id, string $type = 'photo')
  662.     {
  663.         $liste = [];
  664.         $results = $this->em->getRepository(SejourAttachment::class)->getSejourAttachByPhotoPagination($id, $type);
  667.         return $results;
  668.     }
  669.     /**
  670.      * Gets the list of attachements based on the sejour id and attachement type
  671.      * @param string $id The sejour id
  672.      * @param string $type The attachement type
  673.      * @return array The list of attachements
  674.      */
  675.     /**
  676.      * Gets the list of attachements based on the sejour id, attachement type, and user id.
  677.      * 
  678.      * @param string $id The sejour id
  679.      * @param string $type The attachement type ('photo', 'photoVideo', 'message')
  680.      * @param int|null $userId The user id (optional, for checking favorites)
  681.      * @return array The list of attachements
  682.      */
  683.     public function getCombinedattachSejour_REVISION(string $id, string $type = 'photo', ?int $userId = null): array
  684.     {
  685.         // Récupérer les attachements pour le type 'photoVideo'
  686.         if ($type === 'photoVideo') {
  687.             $groupedAttachments = [];
  688.             $results = $this->em->getRepository(SejourAttachment::class)->getSejourAttachById($id, $type);
  689.             $attachCount = count($results);
  691.             // Récupérer les favoris de l'utilisateur pour ces attachements
  692.             // Ajouter un champ 'isFavorite' à chaque photo
  694.             //$favorites = $this->em->getRepository(Likephoto::class)->searshlikephotousersejour($userId, $id);
  696.             foreach ($results as $result) {
  697.                 $attachmentId = $result->getIdAttchment()->getId();
  698.                 $date = $result->getDateDepotAttachement()->format('Y-m-d');
  699.                 $preListe = [
  700.                     'date_depot_attachement' => $result->getDateDepotAttachement(),
  701.                     'path'          => $result->getIdAttchment()->getPath(),
  702.                     'id_attchment'  => $attachmentId,
  703.                     'idposition'    => $result->getIdAttchment()->getIdposition(),
  704.                     'libiller'      => $result->getIdAttchment()->getIdref()->getLibiller(),
  705.                     'descreption'   => $result->getIdAttchment()->getDescreption(),
  706.                     'is_favorite'   => "",
  707.                 ];
  709.                 // Grouper par date
  710.                 if (!isset($groupedAttachments[$date])) {
  711.                     $groupedAttachments[$date] = [];
  712.                 }
  713.                 $groupedAttachments[$date][] = $preListe;
  714.             }
  716.             // Définir toujours 'total'
  717.             $groupedAttachments['total'] = $attachCount;
  719.             // Trier par date décroissante
  720.             uksort($groupedAttachments, fn($a, $b) => strtotime($b) - strtotime($a));
  722.             return $groupedAttachments;
  723.         }
  725.         // Pour les types 'photo' et 'message'
  726.         $liste = [];
  727.         $results = $type === 'photo' ?
  728.             $this->em->getRepository(SejourAttachment::class)->getSejourAttachByPhoto($id, $type) :
  729.             $this->em->getRepository(SejourAttachment::class)->getSejourAttachByMessage($id, $type);
  731.         // Récupérer les favoris de l'utilisateur
  732.         $favorites = $this->getUserFavorites($userId, array_map(fn($r) => $r->getIdAttchment()->getId(), $results));
  734.         foreach ($results as $result) {
  735.             $attachmentId = $result->getIdAttchment()->getId();
  736.             $preListe = [
  737.                 'id' => $attachmentId,
  738.                 'date_depot_attachement' => $result->getDateDepotAttachement(),
  739.                 'path' => $result->getIdAttchment()->getPath(),
  740.                 'libiller' => $type,
  741.                 'descreption' => $type === 'message' ? $result->getIdAttchment()->getDescreption() : null,
  742.                 'is_favorite' => in_array($attachmentId, $favorites)
  743.             ];
  744.             $liste[] = $preListe;
  745.         }
  747.         return ['total' => count($liste), 'attachments' => $liste];
  748.     }
  749.     /**
  750.      * Gets the list of attachements based on the sejour id, attachement type, and user id.
  751.      * 
  752.      * @param string $id The sejour id
  753.      * @param string $type The attachement type ('watermark', 'original', '900')
  754.      * @param int|null $userId The user id (optional, for checking favorites)
  755.      * @return array The list of attachements
  756.      */
  757.     public function getphotosVideosSejour(string $id, string $type, int $userId): array
  758.     {
  759.         $groupedAttachments = [];
  760.         $sejour = $this->em->getRepository(Sejour::class)->findOneBy(['id' => $id]);
  762.         $dateDebut = $sejour->getDateDebutSejour()->format('Y-m-d');
  763.         $dateFin = $sejour->getDateFinSejour()->format('Y-m-d');
  765.         // Récupérer les messages audio
  766.         $messages = $this->em->getRepository(SejourAttachment::class)->getSejourAttachByMessage($id, "message");
  768.         // Récupérer les photos/vidéos
  769.         $results = $this->em->getRepository(SejourAttachment::class)->getSejourAttachById($id, "photoVideo");
  770.         $attachCount = count($results);
  772.         // Récupérer les favoris de l'utilisateur
  773.         $favorites = $this->getlikephotosejour($userId, $id);
  774.         $favoritePhotoIds = array_map(function ($fav) {
  775.             return $fav->getIdSejourAttchment()->getIdAttchment()->getId();
  776.         }, $favorites);
  778.         // Fusionner les messages audio avec les photos/vidéos
  779.         foreach (array_merge($messages, $results) as $result) {
  780.             $attachmentId = $result->getIdAttchment()->getId();
  781.             $date = $result->getDateDepotAttachement()->format('Y-m-d');
  782.             $attchmentType = $result->getIdAttchment()->getIdref()->getLibiller();
  783.             $path = $result->getIdAttchment()->getPath();
  784.             if ($type == 'watermark' && $attchmentType == 'photo') {
  785.                 $path = preg_replace(
  786.                     '/upload/',
  787.                     'upload/f_auto,q_auto,h_900/l_Logo5Sur5White_nh6tyk,o_10,fl_relative.tiled',
  788.                     $result->getIdAttchment()->getPath()
  789.                 );
  790.             } elseif ($type == 'original') {
  791.                 $path = $result->getIdAttchment()->getPath();
  792.             }
  794.             $preListe = [
  795.                 'date_depot_attachement' => $result->getDateDepotAttachement(),
  796.                 'path' => $path,
  797.                 'id_attchment' => $attachmentId,
  798.                 'idposition' => $result->getIdAttchment()->getIdposition(),
  799.                 'libiller' => $result->getIdAttchment()->getIdref()->getLibiller(),
  800.                 'descreption' => $result->getIdAttchment()->getDescreption(),
  801.                 'is_favorite' => in_array($attachmentId, $favoritePhotoIds),
  802.             ];
  804.             // Initialiser le groupe de la date si nécessaire
  805.             if (!isset($groupedAttachments[$date])) {
  806.                 $groupedAttachments[$date] = [
  807.                     'attachments' => [],
  808.                     'countPhotos' => 0,
  809.                     'countAudio' => 0,
  810.                     'countVideos' => 0,
  811.                     'isFirstDay' => ($date === $dateDebut) ? "yes" : "no",
  812.                     'isLastDay' => ($date === $dateFin) ? "yes" : "no",
  813.                 ];
  814.             }
  816.             $groupedAttachments[$date]['attachments'][] = $preListe;
  818.             // Incrémenter les compteurs en fonction du type d'attachement
  819.             $attachmentType = $result->getIdAttchment()->getIdref()->getLibiller();
  820.             if ($attachmentType === 'photo') {
  821.                 $groupedAttachments[$date]['countPhotos']++;
  822.             } elseif ($attachmentType === 'video') {
  823.                 $groupedAttachments[$date]['countVideos']++;
  824.             } elseif ($attachmentType === 'message') {
  825.                 $groupedAttachments[$date]['countAudio']++;
  826.             }
  827.         }
  829.         // Trier les jours par date
  830.         uksort($groupedAttachments, function ($a, $b) {
  831.             return strtotime($a) - strtotime($b); // Ascendant (pour descendant : strtotime($b) - strtotime($a))
  832.         });
  834.         // Ajouter le total des attachements
  835.         $groupedAttachments['total'] = $attachCount;
  837.         return $groupedAttachments;
  838.     }
  841.     /**
  842.      * Récupérer les favoris pour un utilisateur donné.
  843.      *
  844.      * @param int|null $userId
  845.      * @param array $attachmentIds
  846.      * @return array
  847.      */
  848.     private function getUserFavorites(?int $userId, array $attachmentIds): array
  849.     {
  850.         if (is_null($userId) || empty($attachmentIds)) {
  851.             return [];
  852.         }
  854.         $qb = $this->em->createQueryBuilder()
  855.             ->select('l.idSejourAttchment')
  856.             ->from(Likephoto::class, 'l')
  857.             ->where('l.idUser = :userId')
  858.             ->andWhere('l.idSejourAttchment IN (:attachmentIds)')
  859.             ->setParameter('userId', $userId)
  860.             ->setParameter('attachmentIds', $attachmentIds);
  862.         $results = $qb->getQuery()->getResult();
  863.         return array_map(fn($r) => $r['idSejourAttchment'], $results);
  864.     }
  867.     /**
  868.      * Gets the list of attachments based on the sejour id and attachment type
  869.      * @param string $id The sejour id
  870.      * @param string $type The attachment type
  871.      * @return array The list of attachments
  872.      */ /**
  873.      * Gets the list of attachements based on the sejour id and attachement type
  874.      * @param string $id The sejour id
  875.      * @param string $type The attachement type
  876.      * @return array The list of attachements
  877.      */
  878.     public function getCombinedattachSejour(string $id, string $type = 'photo'): array
  879.     {
  880.         if ($type == 'photoVideo') {
  881.             $groupedAttachments = [];
  882.             $results = $this->em->getRepository(SejourAttachment::class)->getSejourAttachById($id, $type);
  883.             $attachCount = count($results);
  885.             foreach ($results as $result) {
  886.                 $date = $result->getDateDepotAttachement()->format('Y-m-d');
  887.                 $preListe = [
  888.                     'date_depot_attachement' => $result->getDateDepotAttachement(),
  889.                     'path'          => $result->getIdAttchment()->getPath(),
  890.                     'id_attchment'  => $result->getIdAttchment()->getId(),
  891.                     'idposition'    => $result->getIdAttchment()->getIdposition(),
  892.                     'libiller'      => $result->getIdAttchment()->getIdref()->getLibiller(),
  893.                     'descreption'   => $result->getIdAttchment()->getDescreption()
  894.                 ];
  896.                 // Group attachments by date
  897.                 if (!isset($groupedAttachments[$date])) {
  898.                     $groupedAttachments[$date] = [];
  899.                 }
  901.                 $groupedAttachments[$date][] = $preListe;
  902.             }
  904.             uksort($groupedAttachments, function ($a, $b) {
  905.                 return strtotime($b) - strtotime($a);
  906.             });
  908.             if ($attachCount > 0) {
  909.                 $groupedAttachments['total'] = $attachCount;
  910.             }
  912.             return $groupedAttachments;
  913.         }
  915.         if ($type == 'photo') {
  916.             $liste = [];
  917.             $results = $this->em->getRepository(SejourAttachment::class)->getSejourAttachByPhoto($id, $type);
  919.             foreach ($results as $result) {
  920.                 $preListe = [
  921.                     'id' => $result->getIdAttchment()->getId(),
  922.                     'date_depot_attachement' => $result->getDateDepotAttachement(),
  923.                     'path' => $result->getIdAttchment()->getPath()
  924.                 ];
  925.                 $liste[] = $preListe;
  926.             }
  928.             return $liste;
  929.         }
  931.         if ($type == 'message') {
  932.             $liste = [];
  933.             $results = $this->em->getRepository(SejourAttachment::class)->getSejourAttachByMessage($id, $type);
  935.             foreach ($results as $result) {
  936.                 $preListe = [
  937.                     'date_depot_attachement' => $result->getDateDepotAttachement(),
  938.                     'path' => $result->getIdAttchment()->getPath(),
  939.                     'id_attchment' => $result->getIdAttchment()->getId(),
  940.                     'idposition' => $result->getIdAttchment()->getIdposition(),
  941.                     'libiller' => $result->getIdAttchment()->getIdref()->getLibiller(),
  942.                     'descreption' => $result->getIdAttchment()->getDescreption()
  943.                 ];
  944.                 $liste[] = $preListe;
  945.             }
  947.             return $liste;
  948.         }
  949.     }
  950.     public function getatachmentsejourparent($id, $idParent)
  951.     {
  952.         //$liste = $this->em->getRepository(SejourAttachment::class)->findBy(array('idSejour' => $id,'idParent'=>$idParent,'statut'=>"private"));
  953.         $liste = $this->em->getRepository(Attachment::class)->searshSejourAtachmentEpaceParent($id, $idParent);
  955.         return $liste;
  956.     }
  957.     public function getVideosejour($id)
  958.     {
  959.         $liste = $this->em->getRepository(Attachment::class)->searshSejourVideo($id);
  960.         return $liste;
  961.     }
  963.     public function getsejourposition($id)
  964.     {
  965.         $liste = $this->em->getRepository(Position::class)->searshSejourPosition($id);
  966.         return $liste;
  967.     }
  968.     public function getTotalParent($id)
  969.     {
  970.         $liste = $this->em->getRepository(ParentSejour::class)->searshNbperpersonneSjour($id);
  971.         return $liste;
  972.     }
  973.     public function getTotalLikesSejour($id)
  974.     {
  975.         $liste = $this->em->getRepository(Likephoto::class)->getTotalLikes($id);
  976.         return $liste;
  977.     }
  979.     public function countPhotos(int $sejourId): int
  980.     {
  981.         $result = $this->sejourAttachmentRepository->CountsearshSejourAtachment($sejourId);
  982.         return isset($result[0]['COUNT(*)']) ? (int) $result[0]['COUNT(*)'] : 0;
  983.     }
  985.     public function countVideos(int $sejourId): int
  986.     {
  987.         $result = $this->sejourAttachmentRepository->CountsearshSejourVideo($sejourId);
  988.         return isset($result[0]['COUNT(*)']) ? (int) $result[0]['COUNT(*)'] : 0;
  989.     }
  991.     public function countMessages(int $sejourId): int
  992.     {
  993.         $result = $this->sejourAttachmentRepository->CountsearshSejourMessage($sejourId);
  994.         return isset($result[0]['COUNT(*)']) ? (int) $result[0]['COUNT(*)'] : 0;
  995.     }
  997.     /**
  998.      * Return all counts as an associative array.
  999.      */
  1000.     public function countAll(int $sejourId): array
  1001.     {
  1002.         return [
  1003.             'photos'   => $this->countPhotos($sejourId),
  1004.             'videos'   => $this->countVideos($sejourId),
  1005.             'messages' => $this->countMessages($sejourId),
  1006.         ];
  1007.     }
  1008.     public function getsejourmessage($id)
  1009.     {
  1010.         $listeaudio = $this->em->getRepository(Attachment::class)->searshSejourMessage($id);
  1011.         return $listeaudio;
  1012.     }
  1014.     function NBpersonnayaoncomande($id)
  1015.     {
  1016.         $Nbpconnx = $this->em->getRepository(ComandeProduit::class)->searshNbpersoneayontcomande($id);
  1017.         return $Nbpconnx;
  1018.     }
  1020.     function montantttc($id)
  1021.     {
  1022.         $somme = $this->em->getRepository(Commande::class)->searshMttc($id);
  1023.         return $somme;
  1024.     }
  1026.     function affectationAttachement($idSejou, $attachement)
  1027.     {
  1028.         $sejour = $this->em->getRepository(Sejour::class)->find($idSejou);
  1029.         $sejAattch = new SejourAttachment();
  1030.         $sejAattch->setIdSejour($sejour);
  1031.         $sejAattch->setIdAttchment($attachement);
  1032.         $sejAattch->setDateDepotAttachement($attachement->getDate());
  1033.         $sejAattch->setStatut("public");
  1034.         $this->em->getManager()->persist($sejAattch);
  1035.         $this->em->getManager()->flush();
  1036.         return $sejAattch;
  1037.     }
  1039.     function monpropreattachement($idSejou, $attachement, $user)
  1040.     {
  1041.         $sejour = $this->em->getRepository(Sejour::class)->find($idSejou);
  1042.         $sejAattch = new SejourAttachment();
  1043.         $sejAattch->setIdSejour($sejour);
  1044.         $sejAattch->setIdAttchment($attachement);
  1045.         $sejAattch->setDateDepotAttachement($attachement->getDate());
  1046.         $sejAattch->setIdParent($user);
  1047.         $sejAattch->setStatut("private");
  1049.         $this->em->getManager()->persist($sejAattch);
  1050.         $this->em->getManager()->flush();
  1051.         return $sejAattch;
  1052.     }
  1054.     function affectationnbvisiteattachement($idSejou, $idattachement)
  1055.     {
  1057.         $nbs = 0;
  1058.         $sejour = $this->em->getRepository(Sejour::class)->find($idSejou);
  1059.         $attachement = $this->em->getRepository(Attachment::class)->find($idattachement);
  1060.         $sejAattch = $this->em->getRepository(SejourAttachment::class)->findOneBy(array('idAttchment' => $attachement, 'idSejour' => $sejour));
  1061.         if ($sejAattch->getNbpartenaireattch() === null) {
  1062.             $nbs = 0;
  1063.         } else {
  1064.             $nbs = $sejAattch->getNbpartenaireattch();
  1065.         }
  1066.         $sejAattch->setNbpartenaireattch($nbs + 1);
  1067.         $this->em->getManager()->persist($sejAattch);
  1068.         $this->em->getManager()->flush();
  1069.         return $sejAattch;
  1070.     }
  1072.     function EnvoyerEmailNewAccoNewSejour($emailacc, $accompagnateur, $idSejour, $passAcommpa)
  1073.     {
  1075.         $RefEmail = $this->em->getRepository(Ref::class)->find(21);
  1077.         $Email = $this->em->getRepository(Emailing::class)->findOneBy(array('typeemail' => $RefEmail, 'statut' => 9));
  1078.         $Sejour = $this->em->getRepository(Sejour::class)->find($idSejour);
  1079.         $sendTo = $accompagnateur->getEmail();
  1080.         $message = (new \Swift_Message('Bienvenue à 5sur5 séjour '))
  1081.             ->setFrom('contact@5sur5sejour.com')
  1082.             ->setTo($emailacc);
  1083.         //->setBcc(["contact@5sur5sejour.com"]);
  1084.         $pathImage2 = $Email->getIdImage2()->getPath();
  1085.         $pathImage1 = $Email->getIdImage1()->getPath();
  1086.         $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  1087.         $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  1088.         $iconphoto = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  1089.         $iconloca = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  1090.         $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  1091.         $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  1092.         $message->setBody(
  1093.             $this->templating->render(
  1094.                 'emails/DemandeCreationAcc.html.twig',
  1095.                 [
  1096.                     "Nomdestinataire" => $accompagnateur->getNom(),
  1097.                     "Predestinataire" => $accompagnateur->getPrenom(),
  1098.                     "code" => $Sejour->getCodeSejour(),
  1099.                     "dateCreation" => $Sejour->getDateCreationCode(),
  1100.                     "dateFinCode" => $Sejour->getDateFinCode(),
  1101.                     "lieu" => $Sejour->getAdresseSejour(),
  1102.                     "image1" => $image1,
  1103.                     "image2" => $image2,
  1104.                     "iconfooter" => $iconfooter,
  1105.                     "iconphoto" => $iconphoto,
  1106.                     "iconloca" => $iconloca,
  1107.                     "iconmsg" => $iconmsg,
  1108.                     'roles' => $accompagnateur->getRoles(),
  1109.                     "identifiant" => $Sejour->getCodeSejour(),
  1110.                     'accompagnateur' => $accompagnateur,
  1111.                     "passAcommpa" => $passAcommpa,
  1112.                 ]
  1113.             ),
  1114.             'text/html'
  1115.         );
  1116.         $signMail = $this->params->get('signMail');
  1117.         if ($signMail == 'yes') {
  1118.             $domainName = $this->params->get('domaine');
  1119.             $selector = $this->params->get('selector');
  1120.             $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  1121.             $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  1122.             $message->attachSigner($signer);
  1123.         }
  1124.         try {
  1125.             $this->mailer->send($message);
  1126.         } catch (\Swift_SwiftException $ex) {
  1127.             $ex->getMessage();
  1128.         }
  1129.     }
  1131.     // authentification parent 
  1133.     function getsejourpourparent($id)
  1134.     {
  1135.         $Sejour = $this->em->getRepository(Sejour::class)->find($id);
  1136.         return $Sejour;
  1137.     }
  1139.     function getparentsejour($userId, $idSejour)
  1140.     {
  1141.         $Sejour = $this->em->getRepository(ParentSejour::class)->findOneBy(array('idParent' => $userId, 'idSejour' => $idSejour));
  1142.         return $Sejour;
  1143.     }
  1145.     function getlikephotosejour($userId, $idSejour)
  1146.     {
  1148.         $liste = $this->em->getRepository(Likephoto::class)->searshlikephotousersejour($userId, $idSejour);
  1150.         return $liste;
  1151.     }
  1152.     function getTotallikesphotosejour($photoId, $idSejour)
  1153.     {
  1155.         $liste = $this->em->getRepository(Likephoto::class)->getTotalLikesForPhoto($photoId, $idSejour);
  1157.         return $liste;
  1158.     }
  1159.     function getToutesLesphotoSejour($userId, $idSejour)
  1160.     {
  1162.         $liste = $this->em->getRepository(Likephoto::class)->searshlikephotousersejour($userId, $idSejour);
  1164.         return $liste;
  1165.     }
  1167.     function inserparentsejour($userId, $idSejour)
  1168.     {
  1169.         $user = $this->em->getRepository(User::class)->find($userId);
  1170.         $sejour = $this->em->getRepository(Sejour::class)->find($idSejour);
  1171.         $notifsms = $user->getSmsnotif();
  1172.         $notifmail  = $user->getMailnotif();
  1173.         $ParentSejour = new ParentSejour();
  1175.         if ($sejour->getNbenfan() == null || $sejour->getNbenfan() == 0 || $sejour->getNbenfan() == NULL) {
  1176.             $ParentSejour->setFlagPrix(1);
  1177.         } else {
  1178.             if ((sizeof($sejour->getParentSejour()) < $sejour->getNbenfan()) && ((substr($sejour->getCodeSejour(), 1, 1) == 'F'))) {
  1179.                 $ParentSejour->setFlagPrix(1);
  1180.             } elseif (substr($sejour->getCodeSejour(), 1, 1) == 'F') {
  1181.                 $ParentSejour->setFlagPrix(0);
  1182.             }
  1183.         }
  1185.         $ParentSejour->setIdSejour($sejour);
  1186.         $ParentSejour->setIdParent($user);
  1187.         $ParentSejour->setSmsnotif($notifsms);
  1188.         if (strpos($sejour->getCodeSejour(), "EF") !== false) {
  1189.             $ParentSejour->setSmsnotif(0);
  1190.         }
  1191.         $ParentSejour->setMailnotif($notifmail);
  1192.         $ParentSejour->setDateCreation(new \DateTime());
  1193.         $ParentSejour->setPayment(0);
  1194.         $this->em->getManager()->persist($ParentSejour);
  1195.         $this->em->getManager()->flush();
  1197.         return $ParentSejour;
  1198.     }
  1200.     function inserparentsejourPayenet($userId, $idSejour)
  1201.     {
  1202.         $parntsejour = $this->em->getRepository(ParentSejour::class)->findOneBy(array('idParent' => $userId, 'idSejour' => $idSejour));
  1203.         if ($parntsejour == NULL) {
  1204.         }
  1207.         $parntsejour->setPayment(1);
  1208.         $this->em->getManager()->persist($parntsejour);
  1209.         $this->em->getManager()->flush();
  1211.         return $parntsejour;
  1212.     }
  1214.     function sejoursansattach($sejId)
  1215.     {
  1216.         $sejour = $this->em->getRepository(Sejour::class)->find($sejId);
  1217.         return $sejour;
  1218.     }
  1220.     function EnvoyerEmailCodeSejourAccompagnateurviapartenaireenmasse($emailAcommpa, $idSejour, $TypeSejour, $passAcommpa)
  1221.     {
  1222.         $Sejour = $this->em->getRepository(Sejour::class)->find($idSejour);
  1224.         $RefEmail = $this->em->getRepository(Ref::class)->find(29);
  1226.         $Email = $this->em->getRepository(Emailing::class)->findOneBy(array('typeemail' => $RefEmail, 'statut' => 9));
  1228.         $sendTo = $emailAcommpa;
  1230.         $message = (new \Swift_Message('Votre code séjour 5sur5sejour'))
  1231.             ->setFrom('contact@5sur5sejour.com')
  1232.             ->setTo($sendTo);
  1233.         // ->setBcc(["contact@5sur5sejour.com"]);
  1234.         $pathImage2 = $Email->getIdImage2()->getPath();
  1235.         $pathImage1 = $Email->getIdImage1()->getPath();
  1236.         $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  1237.         $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  1238.         $iconphoto = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  1239.         $iconloca = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  1240.         $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  1241.         $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  1242.         $message->setBody(
  1243.             $this->templating->render(
  1244.                 'emails/Demandecreationacompaviapartenaire.html.twig',
  1245.                 [
  1246.                     "code" => $Sejour->getCodeSejour(),
  1247.                     "dateCreation" => $Sejour->getDateCreationCode(),
  1248.                     "dateFinCode" => $Sejour->getDateFinCode(),
  1249.                     "lieu" => $Sejour->getAdresseSejour(),
  1250.                     "image1" => $image1,
  1251.                     "image2" => $image2,
  1252.                     "iconfooter" => $iconfooter,
  1253.                     "iconphoto" => $iconphoto,
  1254.                     "iconloca" => $iconloca,
  1255.                     "iconmsg" => $iconmsg,
  1256.                     'passAcommpa' => $passAcommpa,
  1257.                     "destinataire" => $Sejour->getIdAcommp()->getUsername()
  1258.                 ]
  1259.             ),
  1260.             'text/html'
  1261.         );
  1262.         $signMail = $this->params->get('signMail');
  1263.         if ($signMail == 'yes') {
  1264.             $domainName = $this->params->get('domaine');
  1265.             $selector = $this->params->get('selector');
  1266.             $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  1267.             $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  1268.             $message->attachSigner($signer);
  1269.         }
  1270.         try {
  1271.             $this->mailer->send($message);
  1272.         } catch (\Swift_SwiftException $ex) {
  1273.             $ex->getMessage();
  1274.         }
  1275.     }
  1277.     function EnvoyerEmailSejourAccompa($emailAcommpa, $idSejour, $TypeSejour, $passAcommpa)
  1278.     {
  1279.         $Sejour = $this->em->getRepository(Sejour::class)->find($idSejour);
  1281.         $RefEmail = $this->em->getRepository(Ref::class)->find(29);
  1283.         $Email = $this->em->getRepository(Emailing::class)->findOneBy(array('typeemail' => $RefEmail, 'statut' => 9));
  1285.         $sendTo = $emailAcommpa;
  1287.         $message = (new \Swift_Message('Votre code séjour 5sur5sejour'))
  1288.             ->setFrom('contact@5sur5sejour.com')
  1289.             ->setTo($sendTo);
  1290.         //->setBcc(["contact@5sur5sejour.com"]);
  1291.         $pathImage2 = $Email->getIdImage2()->getPath();
  1292.         $pathImage1 = $Email->getIdImage1()->getPath();
  1293.         $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  1294.         $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  1295.         $iconphoto = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  1296.         $iconloca = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  1297.         $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  1298.         $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  1299.         $message->setBody(
  1300.             $this->templating->render(
  1301.                 // Firas : completer Twig
  1302.                 'emails/EnvoyerEmailSejourAccompa.html.twig',
  1303.                 [
  1304.                     "code" => $Sejour->getCodeSejour(),
  1305.                     "dateCreation" => $Sejour->getDateCreationCode(),
  1306.                     "dateFinCode" => $Sejour->getDateFinCode(),
  1307.                     "lieu" => $Sejour->getAdresseSejour(),
  1308.                     "image1" => $image1,
  1309.                     "image2" => $image2,
  1310.                     "iconfooter" => $iconfooter,
  1311.                     "iconphoto" => $iconphoto,
  1312.                     "iconloca" => $iconloca,
  1313.                     "iconmsg" => $iconmsg,
  1314.                     'passAcommpa' => $passAcommpa,
  1315.                     "destinataire" => $Sejour->getIdAcommp()->getUsername()
  1316.                 ]
  1317.             ),
  1318.             'text/html'
  1319.         );
  1320.         $signMail = $this->params->get('signMail');
  1321.         if ($signMail == 'yes') {
  1322.             $domainName = $this->params->get('domaine');
  1323.             $selector = $this->params->get('selector');
  1324.             $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  1325.             $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  1326.             $message->attachSigner($signer);
  1327.         }
  1328.         try {
  1329.             $this->mailer->send($message);
  1330.         } catch (\Swift_SwiftException $ex) {
  1331.             $ex->getMessage();
  1332.         }
  1333.     }
  1335.     function EnvoyerEmailSejourPartnaire($partnaire, $etab2, $err, $ok, $nomfilevalid, $nomfileinvalid)
  1336.     {
  1337.         $logo = '';
  1338.         $nom = '';
  1339.         if ($partnaire->hasRole('ROLE_PARTENAIRE')) {
  1340.             $logo = $partnaire->getLogourl();
  1341.             $nom = $partnaire->getNometablisment();
  1342.         }
  1343.         $RefEmail = $this->em->getRepository(Ref::class)->find(29);
  1345.         $Email = $this->em->getRepository(Emailing::class)->findOneBy(array('typeemail' => $RefEmail, 'statut' => 9));
  1347.         $sendTo = $partnaire->getEmail();
  1350.         $message = (new \Swift_Message('Vos codes séjour  5sur5Séjour'))
  1351.             ->setFrom('partenariat-contact@5sur5sejour.com')
  1352.             ->setTo($sendTo)
  1353.             ->setBcc(["contact@5sur5sejour.com"]);
  1354.         $pathImage2 = $Email->getIdImage2()->getPath();
  1355.         $pathImage1 = $Email->getIdImage1()->getPath();
  1356.         $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  1357.         $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  1358.         $iconphoto = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  1359.         $iconloca = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  1360.         $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  1361.         $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  1364.         if ($ok > 1) {
  1365.             $message->attach(Swift_Attachment::fromPath($this->projectDir . '/public/message//' . $nomfilevalid)->setFilename('Recap_Excel_' . $etab2->getNometab() . '.xlsx'));
  1366.         }
  1368.         if ($err > 1) {
  1369.             $message->attach(Swift_Attachment::fromPath($this->projectDir . '/public/message//' . $nomfileinvalid)->setFilename('Liste_Sejour_Invalide_' . $etab2->getNometab() . '.xlsx'));
  1370.         }
  1371.         $message->setBody(
  1372.             $this->templating->render(
  1373.                 // Firas : completer Twig
  1374.                 'emails/EnvoyerEmailSejourPartnaire.html.twig',
  1375.                 [
  1376.                     "image1" => $image1,
  1377.                     "image2" => $image2,
  1378.                     "iconfooter" => $iconfooter,
  1379.                     "iconphoto" => $iconphoto,
  1380.                     "iconloca" => $iconloca,
  1381.                     "iconmsg" => $iconmsg,
  1382.                     'logo' => $logo,
  1383.                     'nom' => $nom,
  1384.                 ]
  1385.             ),
  1386.             'text/html'
  1387.         );
  1388.         $signMail = $this->params->get('signMail');
  1389.         if ($signMail == 'yes') {
  1390.             $domainName = $this->params->get('domaine');
  1391.             $selector = $this->params->get('selector');
  1392.             $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  1393.             $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  1394.             $message->attachSigner($signer);
  1395.         }
  1396.         try {
  1397.             $this->mailer->send($message);
  1398.         } catch (\Swift_SwiftException $ex) {
  1399.             $ex->getMessage();
  1400.         }
  1401.     }
  1403.     function modif_lbel_Produit($id, $lbel)
  1404.     {
  1405.         $Album = $this->em->getRepository(Produit::class)->find($id);
  1406.         $Album->setLabele($lbel);
  1409.         $this->em->getManager()->persist($Album);
  1410.         $this->em->getManager()->flush();
  1411.     }
  1413.     function AugmenterNombreVu($array)
  1414.     {
  1415.         $sejourPartenaire = $array[0]->getIdSejour()->getIdPartenaire();
  1416.         $etablism = $this->em->getRepository(Etablisment::class)->findby(['user' => $sejourPartenaire]);
  1417.         $type = $etablism[0]->getTypeetablisment();
  1419.         foreach ($array as $e) {
  1420.             if ($type == "ECOLES/AUTRES") {
  1421.                 if ($e->getNbecoleattch() == NULL) {
  1422.                     $e->setNbecoleattch(1);
  1423.                     $this->em->getManager()->persist($e);
  1424.                     $this->em->getManager()->flush();
  1425.                 } else {
  1426.                     $e->setNbecoleattch($e->getNbecoleattch() + 1);
  1427.                     $this->em->getManager()->persist($e);
  1428.                     $this->em->getManager()->flush();
  1429.                 }
  1430.             }
  1432.             if ($type == "CSE") {
  1433.                 if ($e->getNbconsomateurattch() == NULL) {
  1434.                     $e->setNbconsomateurattch(1);
  1435.                     $this->em->getManager()->persist($e);
  1436.                     $this->em->getManager()->flush();
  1437.                 } else {
  1438.                     $e->setNbconsomateurattch($e->getNbconsomateurattch() + 1);
  1439.                     $this->em->getManager()->persist($e);
  1440.                     $this->em->getManager()->flush();
  1441.                 }
  1442.             }
  1444.             if ($type == "PARTENAIRES/VOYAGISTES") {
  1445.                 if ($e->getNbpartenaireattch() == NULL) {
  1446.                     $e->setNbpartenaireattch(1);
  1447.                     $this->em->getManager()->persist($e);
  1448.                     $this->em->getManager()->flush();
  1449.                 } else {
  1450.                     $e->setNbpartenaireattch($e->getNbpartenaireattch() + 1);
  1451.                     $this->em->getManager()->persist($e);
  1452.                     $this->em->getManager()->flush();
  1453.                 }
  1454.             }
  1455.         }
  1456.     }
  1458.     function Nbrephotosejour($id)
  1459.     {
  1460.         $nombre = $this->em->getRepository(SejourAttachment::class)->SearchNombrephotoonsejour($id);
  1461.         return $nombre;
  1462.     }
  1464.     function NombreMessageSejour($id)
  1465.     {
  1466.         $nombre = $this->em->getRepository(SejourAttachment::class)->NombreMessageSejour($id);
  1467.         return $nombre;
  1468.     }
  1470.     function Nbpersone_commandepartypesejour($type, $dateTimeDebut, $dateTimeFin)
  1471.     {
  1472.         if ($dateTimeDebut == null || $dateTimeFin == null) {
  1473.             $Nbcnxnxpartype = $this->em->getRepository(ComandeProduit::class)->Nbpersone_commandepartypesejoursansdate($type);
  1474.         } else {
  1475.             $Nbcnxnxpartype = $this->em->getRepository(ComandeProduit::class)->Nbpersone_commandepartypesejourAvecdate($type, $dateTimeDebut, $dateTimeFin);
  1476.         }
  1477.         return $Nbcnxnxpartype;
  1478.     }
  1480.     function NombreConnexionParSejour($Sejours)
  1481.     {
  1484.         $NbParent = $this->em->getRepository(ParentSejour::class)->findBy(array('idSejour' => $Sejours));
  1487.         return $NbParent;
  1488.     }
  1490.     function rechercheLesCommandesParSejour($Sejours)
  1491.     {
  1494.         $Commandes = $this->em->getRepository(Commande::class)->findBy(array('idSejour' => $Sejours));
  1497.         return $Commandes;
  1498.     }
  1500.     function sejourParentcnx($idSejour, $idParent)
  1501.     {
  1502.         $Sejour = $this->em->getRepository(ParentSejour::class)->findOneBy(array("idSejour" => $idSejour, "idParent" => $idParent));
  1503.         return $Sejour;
  1504.     }
  1505.     function EnvoyerEmailCodeSejourToPartenaireAndAcco($idSejour)
  1506.     {
  1507.         $logo = '';
  1508.         $nom = '';
  1509.         $RefEmail = $this->em->getRepository(Ref::class)->find(21);
  1510.         $Email = $this->em->getRepository(Emailing::class)->findOneBy(array('typeemail' => $RefEmail, 'statut' => 9));
  1511.         $sejour = $this->em->getRepository(Sejour::class)->find($idSejour);
  1512.         
  1513.         if ($sejour) {
  1514.             // Génération des PDFs
  1515.             $pdf1 = new Fpdi();
  1516.             $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  1517.             $pdfFilepath1 = $publicDirectory . "Mode_emploi_5sur5sejour_v5_.pdf";
  1518.             $pageCount = $pdf1->setSourceFile($pdfFilepath1);
  1519.             
  1520.             // Pour chaque page du PDF source
  1521.             for ($i = 1; $i <= $pageCount; $i++) {
  1522.                 $pageId = $pdf1->importPage($i, PdfReader\PageBoundaries::MEDIA_BOX);
  1523.                 $pdf1->addPage();
  1524.                 $pdf1->useImportedPage($pageId);
  1525.                 
  1526.                 // Ajouter le contenu uniquement sur la première page
  1527.                 if ($i === 1) {
  1528.                     $pdf1->SetFont('Helvetica', '', 12);
  1529.                     $pdf1->SetTextColor(0, 0, 0);
  1530.                     
  1531.                     // Position pour le code séjour
  1532.                     $pdf1->SetXY(50, 100);
  1533.                     $pdf1->Write(0, "Code séjour : " . $sejour->getCodeSejour());
  1534.                     
  1535.                     // Position pour le mot de passe
  1536.                     $pdf1->SetXY(50, 120);
  1537.                     $pdf1->Write(0, "Mot de passe : " . $sejour->getIdAcommp()->getPasswordNonCripted());
  1538.                     
  1539.                     // Informations du séjour
  1540.                     $pdf1->SetXY(50, 140);
  1541.                     $pdf1->Write(0, "Dates : du " . $sejour->getDateDebutSejour()->format('d/m/Y') . " au " . $sejour->getDateFinSejour()->format('d/m/Y'));
  1542.                     
  1543.                     $pdf1->SetXY(50, 160);
  1544.                     $pdf1->Write(0, "Thème : " . $sejour->getThemSejour());
  1545.                     
  1546.                     $pdf1->SetXY(50, 180);
  1547.                     $pdf1->Write(0, "Lieu : " . $sejour->getAdresseSejour());
  1548.                     
  1549.                     $pdf1->SetXY(50, 200);
  1550.                     $pdf1->Write(0, "Ville : " . $sejour->getVille());
  1551.                     
  1552.                     $pdf1->SetXY(50, 220);
  1553.                     $pdf1->Write(0, "Pays : " . $sejour->getPays());
  1554.                 }
  1555.             }
  1556.             
  1557.             $pdfFilepath1Output = $publicDirectory . "Mode d'emploi 5sur5sejour" . $sejour->getId() . ".pdf";
  1558.             $pdf1->Output($pdfFilepath1Output, "F");
  1559.             
  1560.             // Génération du deuxième PDF
  1561.             $pdf = new Fpdi();
  1562.             $paym = $sejour->getPaym();
  1563.             
  1564.             if ($paym == 1) {
  1565.                 $pdfFilepathSource = $publicDirectory . "Mode_emploi_Parent_5sur5sejour_v5_.pdf";
  1566.             } else {
  1567.                 $pdfFilepathSource = $publicDirectory . "Mode_emploi_Parent_G_5sur5sejou_v5_.pdf";
  1568.             }
  1569.             
  1570.             $pageCount = $pdf->setSourceFile($pdfFilepathSource);
  1571.             
  1572.             // Pour chaque page du PDF source
  1573.             for ($i = 1; $i <= $pageCount; $i++) {
  1574.                 $pageId = $pdf->importPage($i, PdfReader\PageBoundaries::MEDIA_BOX);
  1575.                 $pdf->addPage();
  1576.                 $pdf->useImportedPage($pageId);
  1577.                 
  1578.                 // Ajouter le contenu uniquement sur la première page
  1579.                 if ($i === 1) {
  1580.                     $pdf->SetFont('Helvetica', '', 12);
  1581.                     $pdf->SetTextColor(0, 0, 0);
  1582.                     
  1583.                     // Position pour le code séjour
  1584.                     $pdf->SetXY(50, 100);
  1585.                     $pdf->Write(0, "Code séjour : " . $sejour->getCodeSejour());
  1586.                     
  1587.                     // Informations du séjour
  1588.                     $pdf->SetXY(50, 120);
  1589.                     $pdf->Write(0, "Dates : du " . $sejour->getDateDebutSejour()->format('d/m/Y') . " au " . $sejour->getDateFinSejour()->format('d/m/Y'));
  1590.                     
  1591.                     $pdf->SetXY(50, 140);
  1592.                     $pdf->Write(0, "Thème : " . $sejour->getThemSejour());
  1593.                     
  1594.                     $pdf->SetXY(50, 160);
  1595.                     $pdf->Write(0, "Lieu : " . $sejour->getAdresseSejour());
  1596.                     
  1597.                     $pdf->SetXY(50, 180);
  1598.                     $pdf->Write(0, "Ville : " . $sejour->getVille());
  1599.                     
  1600.                     $pdf->SetXY(50, 200);
  1601.                     $pdf->Write(0, "Pays : " . $sejour->getPays());
  1602.                 }
  1603.             }
  1604.             
  1605.             if ($paym == 1) {
  1606.                 $pdfFilepathOutput = $publicDirectory . "Mode d'emploi parent 5sur5séjour" . $sejour->getId() . ".pdf";
  1607.             } else {
  1608.                 $pdfFilepathOutput = $publicDirectory . "Mode d'emploi parent G 5sur5séjour " . $sejour->getId() . ".pdf";
  1609.             }
  1610.             $pdf->Output($pdfFilepathOutput, "F");
  1611.             
  1612.             // Envoi des emails avec EmailsCmdService
  1613.             if ($sejour->getIdEtablisment()) {
  1614.                 // Déterminer l'email du partenaire
  1615.                 if (!is_null($sejour->getIdEtablisment()->getEmail())) {
  1616.                     $emailPartenaire = $sejour->getIdEtablisment()->getEmail();
  1617.                 } else {
  1618.                     $emailPartenaire = $sejour->getIdPartenaire()->getEmail();
  1619.                 }
  1620.                 
  1621.                 // Récupérer le logo et le nom
  1622.                 $logo = $sejour->getIdEtablisment()->getLogo();
  1623.                 $nom = $sejour->getIdEtablisment()->getNometab();
  1624.                 
  1625.                 // Préparer les données pour le template
  1626.                 $extraDataPartenaire = [
  1627.                     "Password" => $sejour->getIdAcommp()->getPasswordNonCripted(),
  1628.                     "code" => $sejour->getCodeSejour(),
  1629.                     "dateCreation" => $sejour->getDateCreationCode(),
  1630.                     "dateFinCode" => $sejour->getDateFinCode(),
  1631.                     "lieu" => $sejour->getAdresseSejour(),
  1632.                     "identifiant" => $sejour->getCodeSejour(),
  1633.                     "theme" => $sejour->getThemSejour(),
  1634.                     "ville" => $sejour->getVille(),
  1635.                     "pays" => $sejour->getPays(),
  1636.                     "dateDebut" => $sejour->getDateDebutSejour(),
  1637.                     "dateFin" => $sejour->getDateFinSejour(),
  1638.                     "motPass" => $sejour->getIdAcommp()->getPasswordNonCripted(),
  1639.                    
  1640.                     'roles' => $sejour->getIdEtablisment()->getUser()->getRoles(),
  1641.                     'fichiers' => [
  1642.                         $pdfFilepathOutput,
  1643.                         $pdfFilepath1Output
  1644.                     ]
  1645.                 ];
  1646.                 
  1647.                 // Envoyer l'email au partenaire
  1648.                 $this->emailsCmdService->sendMail(
  1649.                     $emailPartenaire,
  1650.                     '🔐 Code séjour + mot de passe – Connectez-vous à votre espace 5sur5séjour',
  1651.                     'EnvoiCodeSejourUniquementToAccoAndPartenaire',
  1652.                     $extraDataPartenaire,
  1653.                     ['bcc' => 'contact@5sur5sejour.com']
  1654.                 );
  1655.                 
  1656.                 // Envoyer l'email à l'accompagnateur si différent du partenaire
  1657.                 if ($emailPartenaire != $sejour->getIdAcommp()->getReponseemail()) {
  1658.                     $emailAcco = $sejour->getIdAcommp()->getReponseemail();
  1659.                     
  1660.                     // Préparer les données pour l'accompagnateur
  1661.                     $extraDataAcco = [
  1662.                         "Password" => $sejour->getIdAcommp()->getPasswordNonCripted(),
  1663.                         "code" => $sejour->getCodeSejour(),
  1664.                         "dateCreation" => $sejour->getDateCreationCode(),
  1665.                         "dateFinCode" => $sejour->getDateFinCode(),
  1666.                         "lieu" => $sejour->getAdresseSejour(),
  1667.                         'theme' => $sejour->getThemSejour(),
  1668.                         'ville' => $sejour->getVille(),
  1669.                         'pays' => $sejour->getPays(),   
  1670.                         'dateDebut' => $sejour->getDateDebutSejour(),
  1671.                         'dateFin' => $sejour->getDateFinSejour(),
  1672.                         "identifiant" => $sejour->getCodeSejour(),
  1673.                         "motPass" => $sejour->getIdAcommp()->getPasswordNonCripted(),
  1674.                         
  1675.                         'logo' => $logo,
  1676.                         'nom' => $nom,
  1677.                         'image1' => $image1,
  1678.                         'image2' => $image2,
  1679.                         'iconphoto' => $iconphoto,
  1680.                         'iconfooter' => $iconfooter,
  1681.                         'iconmsg' => $iconmsg,
  1682.                         'roles' => $sejour->getIdAcommp()->getRoles(),
  1683.                         'fichiers' => [
  1684.                             $pdfFilepathOutput,
  1685.                             $pdfFilepath1Output
  1686.                         ]
  1687.                     ];
  1688.                     
  1689.                     // Envoyer l'email à l'accompagnateur
  1690.                     $this->emailsCmdService->sendMail(
  1691.                         $emailAcco,
  1692.                         '🔐 Code séjour + mot de passe – Connectez-vous à votre espace 5sur5séjour',
  1693.                         'EnvoiCodeSejourUniquementToAccoAndPartenaire',
  1694.                         $extraDataAcco
  1695.                     );
  1696.                 }
  1697.             }
  1698.         }
  1699.         
  1700.         return true;
  1701.     }
  1703.     function EnvoyerEmailOKActivation_CompteAcc($idSejour)
  1704.     {
  1705.         $logo = '';
  1706.         $nom = '';
  1707.         $RefEmail = $this->em->getRepository(Ref::class)->find(21);
  1708.         $Email = $this->em->getRepository(Emailing::class)->findOneBy(array('typeemail' => $RefEmail, 'statut' => 9));
  1709.         $sejour = $this->em->getRepository(Sejour::class)->find($idSejour);
  1710.         
  1711.         if ($sejour) {
  1712.             // Génération des PDFs
  1713.             $pdf1 = new Fpdi();
  1714.             $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  1715.             $pdfFilepath1 = $publicDirectory . "Mode_emploi_5sur5sejour_v5_.pdf";
  1716.             $pageCount = $pdf1->setSourceFile($pdfFilepath1);
  1717.             
  1718.             // Pour chaque page du PDF source
  1719.             for ($i = 1; $i <= $pageCount; $i++) {
  1720.                 $pageId = $pdf1->importPage($i, PdfReader\PageBoundaries::MEDIA_BOX);
  1721.                 $pdf1->addPage();
  1722.                 $pdf1->useImportedPage($pageId);
  1723.                 
  1724.                 // Ajouter le contenu uniquement sur la première page
  1725.                 if ($i === 1) {
  1726.                     $pdf1->SetFont('Helvetica', '', 12);
  1727.                     $pdf1->SetTextColor(0, 0, 0);
  1728.                     
  1729.                     // Position pour le code séjour
  1730.                     $pdf1->SetXY(50, 100);
  1731.                     $pdf1->Write(0, "Code séjour : " . $sejour->getCodeSejour());
  1732.                     
  1733.                     // Position pour le mot de passe
  1734.                     $pdf1->SetXY(50, 120);
  1735.                     $pdf1->Write(0, "Mot de passe : " . $sejour->getIdAcommp()->getPasswordNonCripted());
  1736.                     
  1737.                     // Informations du séjour
  1738.                     $pdf1->SetXY(50, 140);
  1739.                     $pdf1->Write(0, "Dates : du " . $sejour->getDateDebutSejour()->format('d/m/Y') . " au " . $sejour->getDateFinSejour()->format('d/m/Y'));
  1740.                     
  1741.                     $pdf1->SetXY(50, 160);
  1742.                     $pdf1->Write(0, "Thème : " . $sejour->getThemSejour());
  1743.                     
  1744.                     $pdf1->SetXY(50, 180);
  1745.                     $pdf1->Write(0, "Lieu : " . $sejour->getAdresseSejour());
  1746.                     
  1747.                     $pdf1->SetXY(50, 200);
  1748.                     $pdf1->Write(0, "Ville : " . $sejour->getVille());
  1749.                     
  1750.                     $pdf1->SetXY(50, 220);
  1751.                     $pdf1->Write(0, "Pays : " . $sejour->getPays());
  1752.                 }
  1753.             }
  1754.             
  1755.             $pdfFilepath1Output = $publicDirectory . "Mode d'emploi 5sur5sejour" . $sejour->getId() . ".pdf";
  1756.             $pdf1->Output($pdfFilepath1Output, "F");
  1757.             
  1758.             // Génération du deuxième PDF
  1759.             $pdf = new Fpdi();
  1760.             $paym = $sejour->getPaym();
  1761.             
  1762.             if ($paym == 1) {
  1763.                 $pdfFilepathSource = $publicDirectory . "Mode_emploi_Parent_5sur5sejour_v5_.pdf";
  1764.             } else {
  1765.                 $pdfFilepathSource = $publicDirectory . "Mode_emploi_Parent_G_5sur5sejou_v5_.pdf";
  1766.             }
  1767.             
  1768.             $pageCount = $pdf->setSourceFile($pdfFilepathSource);
  1769.             
  1770.             // Pour chaque page du PDF source
  1771.             for ($i = 1; $i <= $pageCount; $i++) {
  1772.                 $pageId = $pdf->importPage($i, PdfReader\PageBoundaries::MEDIA_BOX);
  1773.                 $pdf->addPage();
  1774.                 $pdf->useImportedPage($pageId);
  1775.                 
  1776.                 // Ajouter le contenu uniquement sur la première page
  1777.                 if ($i === 1) {
  1778.                     $pdf->SetFont('Helvetica', '', 12);
  1779.                     $pdf->SetTextColor(0, 0, 0);
  1780.                     
  1781.                     // Position pour le code séjour
  1782.                     $pdf->SetXY(50, 100);
  1783.                     $pdf->Write(0, "Code séjour : " . $sejour->getCodeSejour());
  1784.                     
  1785.                     // Informations du séjour
  1786.                     $pdf->SetXY(50, 120);
  1787.                     $pdf->Write(0, "Dates : du " . $sejour->getDateDebutSejour()->format('d/m/Y') . " au " . $sejour->getDateFinSejour()->format('d/m/Y'));
  1788.                     
  1789.                     $pdf->SetXY(50, 140);
  1790.                     $pdf->Write(0, "Thème : " . $sejour->getThemSejour());
  1791.                     
  1792.                     $pdf->SetXY(50, 160);
  1793.                     $pdf->Write(0, "Lieu : " . $sejour->getAdresseSejour());
  1794.                     
  1795.                     $pdf->SetXY(50, 180);
  1796.                     $pdf->Write(0, "Ville : " . $sejour->getVille());
  1797.                     
  1798.                     $pdf->SetXY(50, 200);
  1799.                     $pdf->Write(0, "Pays : " . $sejour->getPays());
  1800.                 }
  1801.             }
  1802.             
  1803.             if ($paym == 1) {
  1804.                 $pdfFilepathOutput = $publicDirectory . "Mode d'emploi parent 5sur5séjour" . $sejour->getId() . ".pdf";
  1805.             } else {
  1806.                 $pdfFilepathOutput = $publicDirectory . "Mode d'emploi parent G 5sur5séjour " . $sejour->getId() . ".pdf";
  1807.             }
  1808.             $pdf->Output($pdfFilepathOutput, "F");
  1809.             $loginUrl = "5sur5sejour.com";
  1810.             $accomp = $this->em->getRepository(User::class)->find($sejour->getIdAcommp());
  1812.             if ($accomp != null) {
  1813.                 $loginUrl = $this->emailsCmdService->requestLoginLink($accomp);
  1814.             }
  1815.           
  1816.                 // Récupérer le logo et le nom
  1817.                 $logo = $sejour->getIdEtablisment()->getLogo();
  1818.                 $nom = $sejour->getIdEtablisment()->getNometab();
  1819.                 
  1820.                 // Préparer les données pour le template
  1821.                 $extraDataEmail = [
  1822.                     "Password" => $sejour->getIdAcommp()->getPasswordNonCripted(),
  1823.                     "code" => $sejour->getCodeSejour(),
  1824.                     "dateCreation" => $sejour->getDateCreationCode(),
  1825.                     "dateFinCode" => $sejour->getDateFinCode(),
  1826.                     "lieu" => $sejour->getAdresseSejour(),
  1827.                     "identifiant" => $sejour->getCodeSejour(),
  1828.                     "theme" => $sejour->getThemSejour(),
  1829.                     "ville" => $sejour->getVille(),
  1830.                     "pays" => $sejour->getPays(),
  1831.                     "dateDebut" => $sejour->getDateDebutSejour(),
  1832.                     "dateFin" => $sejour->getDateFinSejour(),
  1833.                     "motPass" => $sejour->getIdAcommp()->getPasswordNonCripted(),
  1834.                      "codeSejour" => $sejour->getCodeSejour(),
  1835.                     'idSejour' => $sejour->getId(),
  1836.                     "loginUrl" =>  $loginUrl ,
  1837.                     'roles' => $sejour->getIdEtablisment()->getUser()->getRoles(),
  1838.                     'fichiers' => [
  1839.                         $pdfFilepathOutput,
  1840.                         $pdfFilepath1Output
  1841.                     ]
  1842.                 ];
  1843.                 $emailAcco = $sejour->getIdAcommp()->getReponseemail();
  1844.                 // Envoyer l'email au partenaire
  1845.                 $this->emailsCmdService->sendMail(
  1846.                     $emailAcco,
  1847.                     '✅  Votre compte 5sur5séjour est activé ! - Commencez à partager votre séjour',
  1848.                     'ConfirmationActivationAccomp',
  1849.                     $extraDataEmail,
  1850.                     ['bcc' => 'contact@5sur5sejour.com']
  1851.                 );
  1852.                 
  1853.               
  1854.             }
  1855.         
  1856.         
  1857.         return true;
  1858.     }
  1860.     //cette fonction envoi seulement le code sejour aux partenaire et acco s'il existe
  1861.     function EnvoyerEmailCodeSejourToPartenaireAndAcco_old($idSejour)
  1862.     {
  1864.         $logo = '';
  1865.         $nom = '';
  1866.         $RefEmail = $this->em->getRepository(Ref::class)->find(21);
  1868.         $Email = $this->em->getRepository(Emailing::class)->findOneBy(array('typeemail' => $RefEmail, 'statut' => 9));
  1869.         $Sejour = $this->em->getRepository(Sejour::class)->find($idSejour);
  1870.         if ($Sejour) {
  1873.             //dd($sejour);
  1874.             $pdf1 = new Fpdi();
  1876.             $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  1877.             $pdfFilepath1 = $publicDirectory . "Mode_emploi_5sur5sejour_v5_.pdf";
  1879.             $pageCount = $pdf1->setSourceFile($pdfFilepath1);
  1880.             $pageId = $pdf1->importPage(1, PdfReader\PageBoundaries::MEDIA_BOX);
  1882.             $pdf1->addPage();
  1883.             $pdf1->useImportedPage($pageId, 0.5, 0.5, 0.5);
  1885.             $testText  = "abcdefghijklmnopqrstuvwxyz0123456789";
  1887.             $current_date = date('d-M-Y');
  1888.             $DateDebut =  "";
  1889.             $DateFin = "";
  1890.             $Theme = "";
  1891.             $Lieu = "";
  1892.             $CodeSejour =  "";
  1893.             $MotPass =  "";
  1894.             $Ville = "";
  1895.             $Paye = "";
  1898.             if ($Sejour) {
  1899.                 $DateDebut = $Sejour->getDateDebutSejour();
  1900.                 $DateFin = $Sejour->getDateFinSejour();
  1901.                 $Theme = $Sejour->getThemSejour();
  1902.                 $Lieu = $Sejour->getAdresseSejour();
  1903.                 $CodeSejour = $Sejour->getCodeSejour();
  1904.                 $MotPass = $Sejour->getIdAcommp()->getPasswordNonCripted();
  1905.                 $Ville = $Sejour->getVille();
  1906.                 $Paye = $Sejour->getPays();
  1907.             }
  1909.             for ($i = 0; $i < $pageCount; $i++) {
  1910.                 $tplIdx = $pdf1->importPage(1 + $i);
  1911.                 $pdf1->useTemplate($tplIdx, 0, 0, 200, 300, true);
  1912.                 $theme = $Theme;
  1913.                 if (strlen($theme) > 25) {
  1914.                     $pdf1->SetFont("Arial", "", 5);
  1915.                 } else {
  1916.                     $pdf1->SetFont("Arial", "", 7);
  1917.                 }
  1918.                 $strTheme = iconv("UTF-8", "WINDOWS-1252", $theme);
  1919.                 $pdf1->Text(35, 262, $strTheme);
  1920.                 $pdf1->SetFont("Arial", "", 8);
  1921.                 $lieu = $Lieu;
  1922.                 $ville = $Ville;
  1923.                 $paye = $Paye;
  1924.                 if ($Paye && $Ville) {
  1925.                     $strLieu = iconv("UTF-8", "WINDOWS-1252", $ville . "  " . $paye);
  1926.                     $pdf1->Text(125, 262, $strLieu);
  1927.                 } else if ($Paye) {
  1928.                     $strLieu = iconv("UTF-8", "WINDOWS-1252", $paye);
  1929.                     $pdf1->Text(125, 262, $strLieu);
  1930.                 } else {
  1931.                     $strLieu = iconv("UTF-8", "WINDOWS-1252", $ville);
  1932.                     $pdf1->Text(125, 262, $strLieu);
  1933.                 }
  1935.                 $pdf1->SetFont("Arial", "", 10);
  1936.                 $pdf1->Text(50, 252, $DateDebut->format('d/m/Y'));
  1937.                 $pdf1->SetFont("Arial", "", 10);
  1938.                 $pdf1->Text(90, 252, $DateFin->format('d/m/Y'));
  1939.                 $pdf1->SetFont("Arial", "", 10);
  1940.                 $pdf1->Text(90, 271, $CodeSejour);
  1941.                 $pdf1->SetFont("Arial", "", 10);
  1942.                 $pdf1->Text(75, 279, $MotPass);
  1943.             }
  1945.             $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  1946.             $pdfFilepath1 = $publicDirectory . "Mode d'emploi 5sur5sejour" . $idSejour . ".pdf";
  1947.             $pdf1->Output($pdfFilepath1, "F");
  1950.             $pdf = new Fpdi();
  1951.             $paym = $Sejour->getPaym();
  1952.             if ($paym == 1) {
  1953.                 $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  1954.                 $pdfFilepath = $publicDirectory . "Mode_emploi_Parent_5sur5sejour_v5_.pdf";
  1956.                 $pageCount = $pdf->setSourceFile($pdfFilepath);
  1957.             } else {
  1958.                 $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  1959.                 $pdfFilepath = $publicDirectory . "Mode_emploi_Parent_G_5sur5sejou_v5_.pdf";
  1961.                 $pageCount = $pdf->setSourceFile($pdfFilepath);
  1962.             }
  1964.             $pageId = $pdf->importPage(1, PdfReader\PageBoundaries::MEDIA_BOX);
  1966.             $pdf->addPage();
  1967.             $pdf->useImportedPage($pageId, 0.5, 0.5, 0.5);
  1969.             $testText  = "abcdefghijklmnopqrstuvwxyz0123456789";
  1971.             $current_date = date('d-M-Y');
  1972.             $DateDebut =  "";
  1973.             $DateFin = "";
  1974.             $Theme = "";
  1975.             $Lieu = "";
  1976.             $CodeSejour =  "";
  1977.             $Ville = "";
  1978.             $Paye = "";
  1981.             if ($Sejour) {
  1982.                 $DateDebut = $Sejour->getDateDebutSejour();
  1983.                 $DateFin = $Sejour->getDateFinSejour();
  1984.                 $Theme = $Sejour->getThemSejour();
  1985.                 $Lieu = $Sejour->getAdresseSejour();
  1986.                 $CodeSejour = $Sejour->getCodeSejour();
  1987.                 $Ville = $Sejour->getVille();
  1988.                 $Paye = $Sejour->getPays();
  1989.             }
  1991.             for ($i = 0; $i < $pageCount; $i++) {
  1992.                 $tplIdx = $pdf->importPage($i + 1);
  1993.                 $pdf->useTemplate($tplIdx, 0, 0, 200, 300, true);
  1994.                 $theme = $Theme;
  1995.                 if (strlen($theme) > 25) {
  1996.                     $pdf->SetFont("Arial", "", 5);
  1997.                 } else {
  1998.                     $pdf->SetFont("Arial", "", 7);
  1999.                 }
  2000.                 $strTheme = iconv("UTF-8", "WINDOWS-1252", $theme);
  2001.                 $pdf->Text(35, 268, $strTheme);
  2002.                 $pdf->SetFont("Arial", "", 8);
  2003.                 $lieu = $Lieu;
  2004.                 $ville = $Ville;
  2005.                 $paye = $Paye;
  2006.                 if ($Paye && $Ville) {
  2007.                     $strLieu = iconv("UTF-8", "WINDOWS-1252", $ville . "  " . $paye);
  2008.                     $pdf->Text(125, 268, $strLieu);
  2009.                 } else if ($Paye) {
  2010.                     $strLieu = iconv("UTF-8", "WINDOWS-1252", $paye);
  2011.                     $pdf->Text(125, 268, $strLieu);
  2012.                 } else {
  2013.                     $strLieu = iconv("UTF-8", "WINDOWS-1252", $ville);
  2014.                     $pdf->Text(125, 268, $strLieu);
  2015.                 }
  2017.                 $pdf->SetFont("Arial", "", 10);
  2018.                 $pdf->Text(80, 279, $CodeSejour);
  2019.                 $pdf->SetFont("Arial", "", 10);
  2020.                 $pdf->Text(48, 258, $DateDebut->format('d/m/Y'));
  2021.                 $pdf->SetFont("Arial", "", 10);
  2022.                 $pdf->Text(89, 258, $DateFin->format('d/m/Y'));
  2023.             }
  2024.             if ($paym == 1) {
  2025.                 $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  2026.                 $pdfFilepath = $publicDirectory . "Mode d'emploi parent  5sur5séjour" . $idSejour . ".pdf";
  2027.                 $pdf->Output($pdfFilepath, "F");
  2028.             } else {
  2029.                 $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  2030.                 $pdfFilepath = $publicDirectory . "Mode d'emploi parent G 5sur5séjour " . $idSejour . ".pdf";
  2031.                 $pdf->Output($pdfFilepath, "F");
  2032.             }
  2034.             if ($Sejour->getIdEtablisment()) {
  2036.                 if (!is_null($Sejour->getIdEtablisment()->getEmail())) {
  2037.                     $emailPartenaire = $Sejour->getIdEtablisment()->getEmail();
  2038.                 } else {
  2039.                     $emailPartenaire = $Sejour->getIdPartenaire()->getEmail();
  2040.                 }
  2042.                 $partenaire = $Sejour->getIdEtablisment()->getNometab();
  2043.                 $partenaire = $Sejour->getIdEtablisment()->getLogo();
  2045.                 $logo = $Sejour->getIdEtablisment()->getLogo();
  2046.                 $nom = $Sejour->getIdEtablisment()->getNometab();
  2049.                 $message = (new \Swift_Message('Votre code séjour 5sur5sejour'))
  2050.                     ->setFrom('partenariat-contact@5sur5sejour.com')
  2051.                     ->setTo($emailPartenaire)
  2052.                     ->setBcc(["contact@5sur5sejour.com"]);
  2053.                 $pathImage2 = $Email->getIdImage2()->getPath();
  2054.                 $pathImage1 = $Email->getIdImage1()->getPath();
  2055.                 $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  2056.                 $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  2057.                 $iconphoto = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  2058.                 $iconloca = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  2059.                 $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  2060.                 $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  2061.                 if ($paym == 1) {
  2062.                     $message->attach(\Swift_Attachment::fromPath($pdfFilepath));
  2063.                     $message->attach(\Swift_Attachment::fromPath($pdfFilepath1));
  2064.                 } else {
  2065.                     $message->attach(\Swift_Attachment::fromPath($pdfFilepath));
  2066.                     $message->attach(\Swift_Attachment::fromPath($pdfFilepath1));
  2067.                 }
  2068.                 $message->setBody(
  2069.                     $this->templating->render(
  2070.                         'emails/EnvoiCodeSejourUniquementToAccoAndPartenaire.html.twig',
  2071.                         [
  2072.                             "Password" => $Sejour->getIdAcommp()->getPasswordNonCripted(),
  2073.                             "code" => $Sejour->getCodeSejour(),
  2074.                             "dateCreation" => $Sejour->getDateCreationCode(),
  2075.                             "dateFinCode" => $Sejour->getDateFinCode(),
  2076.                             "lieu" => $Sejour->getAdresseSejour(),
  2077.                             "image1" => $image1,
  2078.                             "image2" => $image2,
  2079.                             "iconfooter" => $iconfooter,
  2080.                             "iconphoto" => $iconphoto,
  2081.                             "iconloca" => $iconloca,
  2082.                             "iconmsg" => $iconmsg,
  2083.                             "identifiant" => $Sejour->getCodeSejour(),
  2084.                             'logo' => $logo,
  2085.                             'nom' => $nom,
  2086.                             'roles' => $Sejour->getIdEtablisment()->getUser()->getRoles(),
  2087.                         ]
  2088.                     ),
  2089.                     'text/html'
  2090.                 );
  2091.                 $signMail = $this->params->get('signMail');
  2092.                 if ($signMail == 'yes') {
  2093.                     $domainName = $this->params->get('domaine');
  2094.                     $selector = $this->params->get('selector');
  2095.                     $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  2096.                     $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  2097.                     $message->attachSigner($signer);
  2098.                 }
  2099.                 try {
  2100.                     $this->mailer->send($message);
  2101.                 } catch (\Swift_SwiftException $ex) {
  2102.                     $ex->getMessage();
  2103.                 }
  2105.                 if ($emailPartenaire != $Sejour->getIdAcommp()->getReponseemail()) {
  2106.                     $emailAcco = $Sejour->getIdAcommp()->getReponseemail();
  2107.                     $message = (new \Swift_Message('Votre code séjour 5sur5sejour'))
  2108.                         ->setFrom('contact@5sur5sejour.com')
  2109.                         ->setTo($emailAcco);
  2110.                     //->setBcc(["contact@5sur5sejour.com"]);
  2111.                     $pathImage2 = $Email->getIdImage2()->getPath();
  2112.                     $pathImage1 = $Email->getIdImage1()->getPath();
  2113.                     $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  2114.                     $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  2115.                     $iconphoto = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  2116.                     $iconloca = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  2117.                     $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  2118.                     $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  2119.                     if ($paym == 1) {
  2120.                         $message->attach(\Swift_Attachment::fromPath($pdfFilepath));
  2121.                         $message->attach(\Swift_Attachment::fromPath($pdfFilepath1));
  2122.                     } else {
  2123.                         $message->attach(\Swift_Attachment::fromPath($pdfFilepath));
  2124.                         $message->attach(\Swift_Attachment::fromPath($pdfFilepath1));
  2125.                     }
  2126.                     $message->setBody(
  2127.                         $this->templating->render(
  2128.                             'emails/EnvoiCodeSejourUniquementToAccoAndPartenaire.html.twig',
  2129.                             [
  2130.                                 "Password" => $Sejour->getIdAcommp()->getPasswordNonCripted(),
  2131.                                 "code" => $Sejour->getCodeSejour(),
  2132.                                 "dateCreation" => $Sejour->getDateCreationCode(),
  2133.                                 "dateFinCode" => $Sejour->getDateFinCode(),
  2134.                                 "lieu" => $Sejour->getAdresseSejour(),
  2135.                                 "image1" => $image1,
  2136.                                 "image2" => $image2,
  2137.                                 "iconfooter" => $iconfooter,
  2138.                                 "iconphoto" => $iconphoto,
  2139.                                 "iconloca" => $iconloca,
  2140.                                 "iconmsg" => $iconmsg,
  2141.                                 'logo' => $logo,
  2142.                                 'nom' => $nom,
  2143.                                 "identifiant" => $Sejour->getCodeSejour(),
  2144.                                 'roles' => $Sejour->getIdAcommp()->getRoles(),
  2145.                             ]
  2146.                         ),
  2147.                         'text/html'
  2148.                     );
  2149.                     $signMail = $this->params->get('signMail');
  2150.                     if ($signMail == 'yes') {
  2151.                         $domainName = $this->params->get('domaine');
  2152.                         $selector = $this->params->get('selector');
  2153.                         $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  2154.                         $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  2155.                         $message->attachSigner($signer);
  2156.                     }
  2157.                     try {
  2158.                         $this->mailer->send($message);
  2159.                     } catch (\Swift_SwiftException $ex) {
  2160.                         $ex->getMessage();
  2161.                     }
  2162.                 }
  2163.             }
  2164.         }
  2165.     }
  2167.     //cette fonction envoi seulement le password sejour aux partenaire et acco s'il existe
  2168.     function EnvoyerEmailPasswordSejourToPartenaireAndAcco($idSejour)
  2169.     {
  2171.         $logo = '';
  2172.         $nom = '';
  2173.         $Sejour = $this->em->getRepository(Sejour::class)->find($idSejour);
  2174.         $RefEmail = $this->em->getRepository(Ref::class)->find(28);
  2176.         $Email = $this->em->getRepository(Emailing::class)->findOneBy(array('typeemail' => $RefEmail, 'statut' => 9));
  2177.         if ($Sejour) {
  2178.             if ($Sejour->getIdEtablisment()) {
  2179.                 $emailPartenaire = $Sejour->getIdEtablisment()->getEmail();
  2180.                 $partenaire = $Sejour->getIdEtablisment()->getNometab();
  2181.                 $partenaire = $Sejour->getIdEtablisment()->getLogo();
  2183.                 $logo = $Sejour->getIdEtablisment()->getLogo();
  2184.                 $nom = $Sejour->getIdEtablisment()->getNometab();
  2187.                 $message = (new \Swift_Message('Votre mot de passe 5sur5sejour'))
  2188.                     ->setFrom('partenariat-contact@5sur5sejour.com')
  2189.                     ->setTo($emailPartenaire);
  2190.                 //->setBcc(["contact@5sur5sejour.com"]);
  2193.                 $pathImage2 = $Email->getIdImage2()->getPath();
  2194.                 $pathImage1 = $Email->getIdImage1()->getPath();
  2195.                 $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  2196.                 $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  2197.                 $iconphoto = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  2198.                 $iconloca = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  2199.                 $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  2200.                 $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  2201.                 $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  2202.                 $pdfFilepath = $publicDirectory . "Mode d'emploi 5sur5sejour" . $idSejour . ".pdf";
  2203.                 $message->attach(\Swift_Attachment::fromPath($pdfFilepath));
  2204.                 $message->setBody(
  2205.                     $this->templating->render(
  2206.                         'emails/SendPasswordSejour.html.twig',
  2207.                         [
  2208.                             "Password" => $Sejour->getIdAcommp()->getPasswordNonCripted(),
  2209.                             "image1" => $image1,
  2210.                             "image2" => $image2,
  2211.                             "iconfooter" => $iconfooter,
  2212.                             "iconphoto" => $iconphoto,
  2213.                             "iconloca" => $iconloca,
  2214.                             "iconmsg" => $iconmsg,
  2215.                             'logo' => $logo,
  2216.                             'nom' => $nom,
  2217.                             'roles' => $Sejour->getIdEtablisment()->getUser()->getRoles(),
  2218.                         ]
  2219.                     ),
  2220.                     'text/html'
  2221.                 );
  2222.                 $signMail = $this->params->get('signMail');
  2223.                 if ($signMail == 'yes') {
  2224.                     $domainName = $this->params->get('domaine');
  2225.                     $selector = $this->params->get('selector');
  2226.                     $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  2227.                     $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  2228.                     $message->attachSigner($signer);
  2229.                 }
  2230.                 try {
  2231.                     $this->mailer->send($message);
  2232.                 } catch (\Swift_SwiftException $ex) {
  2233.                     $ex->getMessage();
  2234.                 }
  2237.                 if ($emailPartenaire != $Sejour->getIdAcommp()->getReponseemail()) {
  2238.                     $emailAcco = $Sejour->getIdAcommp()->getReponseemail();
  2239.                     $message = (new \Swift_Message('Votre mot de passe 5sur5sejour'))
  2240.                         ->setFrom('contact@5sur5sejour.com')
  2241.                         ->setTo($emailAcco);
  2242.                     // ->setBcc(["contact@5sur5sejour.com"]);
  2243.                     $pathImage2 = $Email->getIdImage2()->getPath();
  2244.                     $pathImage1 = $Email->getIdImage1()->getPath();
  2245.                     $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  2246.                     $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  2248.                     $iconphoto = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  2249.                     $iconloca = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  2250.                     $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  2251.                     $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  2252.                     $message->attach(\Swift_Attachment::fromPath('pdf/'));
  2253.                     $message->setBody(
  2254.                         $this->templating->render(
  2255.                             'emails/SendPasswordSejour.html.twig',
  2256.                             [
  2257.                                 "Password" => $Sejour->getIdAcommp()->getPasswordNonCripted(),
  2258.                                 "image1" => $image1,
  2259.                                 "image2" => $image2,
  2260.                                 "iconfooter" => $iconfooter,
  2261.                                 "iconphoto" => $iconphoto,
  2262.                                 "iconloca" => $iconloca,
  2263.                                 "iconmsg" => $iconmsg,
  2264.                                 'logo' => $logo,
  2265.                                 'nom' => $nom,
  2266.                                 'roles' => $Sejour->getIdEtablisment()->getUser()->getRoles(),
  2267.                             ]
  2268.                         ),
  2269.                         'text/html'
  2270.                     );
  2271.                     $signMail = $this->params->get('signMail');
  2272.                     if ($signMail == 'yes') {
  2273.                         $domainName = $this->params->get('domaine');
  2274.                         $selector = $this->params->get('selector');
  2275.                         $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  2276.                         $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  2277.                         $message->attachSigner($signer);
  2278.                     }
  2279.                     try {
  2280.                         $done = $this->mailer->send($message);
  2281.                         //var_dump($done);
  2282.                         // var_dump("send it ");
  2283.                     } catch (\Swift_SwiftException $ex) {
  2284.                         //var_dump( $ex->getMessage());
  2285.                     }
  2286.                 }
  2287.             }
  2288.         }
  2289.     }
  2291.     //cette fonction envoi seulement le code sejour aux partenaire
  2292.     function EnvoyerEmailCodeSejourToPartenaire($idSejour)
  2293.     {
  2294.         $logo = '';
  2295.         $nom = '';
  2297.         $RefEmail = $this->em->getRepository(Ref::class)->find(21);
  2299.         $Email = $this->em->getRepository(Emailing::class)->findOneBy(array('typeemail' => $RefEmail, 'statut' => 9));
  2300.         $Sejour = $this->em->getRepository(Sejour::class)->find($idSejour);
  2301.         if ($Sejour) {
  2302.             //dd($sejour);
  2303.             $pdf = new Fpdi();
  2305.             $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  2306.             $pdfFilepath = $publicDirectory . "Mode_emploi_5sur5sejour_v5_.pdf";
  2308.             $pageCount = $pdf->setSourceFile($pdfFilepath);
  2309.             $pageId = $pdf->importPage(1, PdfReader\PageBoundaries::MEDIA_BOX);
  2311.             $pdf->addPage();
  2312.             $pdf->useImportedPage($pageId, 0.5, 0.5, 0.5);
  2314.             $testText  = "abcdefghijklmnopqrstuvwxyz0123456789";
  2316.             $current_date = date('d-M-Y');
  2317.             $DateDebut =  "";
  2318.             $DateFin = "";
  2319.             $Theme = "";
  2320.             $Lieu = "";
  2321.             $CodeSejour =  "";
  2322.             $MotPass =  "";
  2323.             $Ville = "";
  2324.             $Paye = "";
  2327.             if ($Sejour) {
  2328.                 $DateDebut = $Sejour->getDateDebutSejour();
  2329.                 $DateFin = $Sejour->getDateFinSejour();
  2330.                 $Theme = $Sejour->getThemSejour();
  2331.                 $Lieu = $Sejour->getAdresseSejour();
  2332.                 $CodeSejour = $Sejour->getCodeSejour();
  2333.                 $MotPass = $Sejour->getIdAcommp()->getPasswordNonCripted();
  2334.                 $Ville = $Sejour->getVille();
  2335.                 $Paye = $Sejour->getPays();
  2336.             }
  2338.             for ($i = 0; $i < $pageCount; $i++) {
  2339.                 $tplIdx = $pdf->importPage(1 + $i);
  2340.                 $pdf->useTemplate($tplIdx, 0, 0, 200, 300, true);
  2341.                 $theme = $Theme;
  2342.                 if (strlen($theme) > 25) {
  2343.                     $pdf->SetFont("Arial", "", 5);
  2344.                 } else {
  2345.                     $pdf->SetFont("Arial", "", 7);
  2346.                 }
  2347.                 $strTheme = iconv("UTF-8", "WINDOWS-1252", $theme);
  2348.                 $pdf->Text(35, 262, $strTheme);
  2349.                 $pdf->SetFont("Arial", "", 10);
  2350.                 $pdf->Text(50, 252, $DateDebut->format('d/m/Y'));
  2351.                 $pdf->SetFont("Arial", "", 10);
  2352.                 $pdf->Text(90, 252, $DateFin->format('d/m/Y'));
  2353.                 $pdf->SetFont("Arial", "", 8);
  2354.                 $lieu = $Lieu;
  2355.                 $ville = $Ville;
  2356.                 $paye = $Paye;
  2357.                 if ($Paye && $Ville) {
  2358.                     $strLieu = iconv("UTF-8", "WINDOWS-1252", $ville . "  " . $paye);
  2359.                     $pdf->Text(125, 262, $strLieu);
  2360.                 } else if ($Paye) {
  2361.                     $strLieu = iconv("UTF-8", "WINDOWS-1252", $paye);
  2362.                     $pdf->Text(125, 262, $strLieu);
  2363.                 } else {
  2364.                     $strLieu = iconv("UTF-8", "WINDOWS-1252", $ville);
  2365.                     $pdf->Text(125, 262, $strLieu);
  2366.                 }
  2368.                 $pdf->SetFont("Arial", "", 10);
  2369.                 $pdf->Text(90, 271, $CodeSejour);
  2370.                 $pdf->SetFont("Arial", "", 10);
  2371.                 $pdf->Text(75, 279, $MotPass);
  2372.             }
  2373.             $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  2374.             $pdfFilepath = $publicDirectory . "Mode d'emploi 5sur5sejour" . $idSejour . ".pdf";
  2376.             $pdf->Output($pdfFilepath, "F");
  2377.             $pdf = new Fpdi();
  2378.             $paym = $Sejour->getPaym();
  2379.             if ($paym == 1) {
  2380.                 $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  2381.                 $pdfFilepath = $publicDirectory . "Mode_emploi_Parent_5sur5sejour_v5_.pdf";
  2383.                 $pageCount = $pdf->setSourceFile($pdfFilepath);
  2384.             } else {
  2385.                 $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  2386.                 $pdfFilepath = $publicDirectory . "Mode_emploi_Parent_G_5sur5sejou_v5_.pdf";
  2388.                 $pageCount = $pdf->setSourceFile($pdfFilepath);
  2389.             }
  2391.             $pageId = $pdf->importPage(1, PdfReader\PageBoundaries::MEDIA_BOX);
  2393.             $pdf->addPage();
  2394.             $pdf->useImportedPage($pageId, 0.5, 0.5, 0.5);
  2396.             $testText  = "abcdefghijklmnopqrstuvwxyz0123456789";
  2398.             $current_date = date('d-M-Y');
  2399.             $DateDebut =  "";
  2400.             $DateFin = "";
  2401.             $Theme = "";
  2402.             $Lieu = "";
  2403.             $CodeSejour =  "";
  2404.             $Ville = "";
  2405.             $Paye = "";
  2408.             if ($Sejour) {
  2409.                 $DateDebut = $Sejour->getDateDebutSejour();
  2410.                 $DateFin = $Sejour->getDateFinSejour();
  2411.                 $Theme = $Sejour->getThemSejour();
  2412.                 $Lieu = $Sejour->getAdresseSejour();
  2413.                 $CodeSejour = $Sejour->getCodeSejour();
  2414.                 $Ville = $Sejour->getVille();
  2415.                 $Paye = $Sejour->getPays();
  2416.             }
  2418.             for ($i = 0; $i < $pageCount; $i++) {
  2419.                 $tplIdx = $pdf->importPage($i + 1);
  2420.                 $pdf->useTemplate($tplIdx, 0, 0, 200, 300, true);
  2421.                 $theme = $Theme;
  2422.                 if (strlen($theme) > 25) {
  2423.                     $pdf->SetFont("Arial", "", 5);
  2424.                 } else {
  2425.                     $pdf->SetFont("Arial", "", 7);
  2426.                 }
  2427.                 $strTheme = iconv("UTF-8", "WINDOWS-1252", $theme);
  2428.                 $pdf->Text(35, 268, $strTheme);
  2429.                 $pdf->SetFont("Arial", "", 8);
  2430.                 $lieu = $Lieu;
  2431.                 $ville = $Ville;
  2432.                 $paye = $Paye;
  2433.                 if ($Paye  && $Ville) {
  2434.                     $strLieu = iconv("UTF-8", "WINDOWS-1252", $ville . "  " . $paye);
  2435.                     $pdf->Text(125, 268, $strLieu);
  2436.                 } else if ($Paye) {
  2437.                     $strLieu = iconv("UTF-8", "WINDOWS-1252", $paye);
  2438.                     $pdf->Text(125, 268, $strLieu);
  2439.                 } else {
  2440.                     $strLieu = iconv("UTF-8", "WINDOWS-1252", $ville);
  2441.                     $pdf->Text(125, 268, $strLieu);
  2442.                 }
  2444.                 $pdf->SetFont("Arial", "", 10);
  2445.                 $pdf->Text(80, 279, $CodeSejour);
  2446.                 $pdf->SetFont("Arial", "", 10);
  2447.                 $pdf->Text(48, 258, $DateDebut->format('d/m/Y'));
  2448.                 $pdf->SetFont("Arial", "", 10);
  2449.                 $pdf->Text(89, 258, $DateFin->format('d/m/Y'));
  2450.             }
  2451.             if ($paym == 1) {
  2452.                 $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  2453.                 $pdfFilepath = $publicDirectory . "Mode d'emploi parent  5sur5séjour" . $idSejour . ".pdf";
  2454.                 $pdf->Output($pdfFilepath, "F");
  2455.             } else {
  2456.                 $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  2457.                 $pdfFilepath = $publicDirectory . "Mode d'emploi parent  5sur5séjour" . $idSejour . ".pdf";
  2458.                 $pdf->Output($pdfFilepath, "F");
  2459.             }
  2460.             if ($Sejour->getIdEtablisment()) {
  2461.                 $emailPartenaire = $Sejour->getIdEtablisment()->getEmail();
  2462.                 $partenaire = $Sejour->getIdEtablisment()->getNometab();
  2463.                 $partenaire = $Sejour->getIdEtablisment()->getLogo();
  2465.                 $logo = $Sejour->getIdEtablisment()->getLogo();
  2466.                 $nom = $Sejour->getIdEtablisment()->getNometab();
  2467.                 $message = (new \Swift_Message('Votre code séjour 5sur5sejour'))
  2468.                     ->setFrom('partenariat-contact@5sur5sejour.com')
  2469.                     ->setTo($emailPartenaire);
  2470.                 //->setBcc(["contact@5sur5sejour.com"]);
  2471.                 $pathImage2 = $Email->getIdImage2()->getPath();
  2472.                 $pathImage1 = $Email->getIdImage1()->getPath();
  2473.                 $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  2474.                 $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  2475.                 $iconphoto = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  2476.                 $iconloca = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  2477.                 $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  2478.                 $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  2479.                 if ($paym == 1) {
  2480.                     $message->attach(\Swift_Attachment::fromPath($pdfFilepath));
  2481.                 } else {
  2482.                     $message->attach(\Swift_Attachment::fromPath($pdfFilepath));
  2483.                 }
  2484.                 $message->setBody(
  2485.                     $this->templating->render(
  2486.                         'emails/EnvoiCodeSejourUniquementToAccoAndPartenaire.html.twig',
  2487.                         [
  2488.                             "Password" => $Sejour->getIdAcommp()->getPasswordNonCripted(),
  2489.                             "code" => $Sejour->getCodeSejour(),
  2490.                             "dateCreation" => $Sejour->getDateCreationCode(),
  2491.                             "dateFinCode" => $Sejour->getDateFinCode(),
  2492.                             "lieu" => $Sejour->getAdresseSejour(),
  2493.                             "image1" => $image1,
  2494.                             "image2" => $image2,
  2495.                             "iconfooter" => $iconfooter,
  2496.                             "iconphoto" => $iconphoto,
  2497.                             "iconloca" => $iconloca,
  2498.                             "iconmsg" => $iconmsg,
  2499.                             "identifiant" => $Sejour->getCodeSejour(),
  2500.                             'logo' => $logo,
  2501.                             'nom' => $nom,
  2502.                             'roles' => $Sejour->getIdEtablisment()->getUser()->getRoles(),
  2503.                         ]
  2504.                     ),
  2505.                     'text/html'
  2506.                 );
  2507.                 $signMail = $this->params->get('signMail');
  2508.                 if ($signMail == 'yes') {
  2509.                     $domainName = $this->params->get('domaine');
  2510.                     $selector = $this->params->get('selector');
  2511.                     $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  2512.                     $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  2513.                     $message->attachSigner($signer);
  2514.                 }
  2515.                 try {
  2516.                     $this->mailer->send($message);
  2517.                 } catch (\Swift_SwiftException $ex) {
  2518.                     $ex->getMessage();
  2519.                 }
  2520.             }
  2521.         }
  2522.     }
  2524.     //cette fonction envoi seulement le code sejour aux acccompagnateur
  2525.     function EnvoyerEmailCodeSejourToAccomp($idSejour)
  2526.     {
  2527.         $RefEmail = $this->em->getRepository(Ref::class)->find(21);
  2529.         $Email = $this->em->getRepository(Emailing::class)->findOneBy(array('typeemail' => $RefEmail, 'statut' => 9));
  2530.         $Sejour = $this->em->getRepository(Sejour::class)->find($idSejour);
  2531.         if ($Sejour) {
  2532.             $pdf = new Fpdi();
  2534.             $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  2535.             $pdfFilepath = $publicDirectory . "Mode_emploi_5sur5sejour_v5_.pdf";
  2537.             $pageCount = $pdf->setSourceFile($pdfFilepath);
  2538.             $pageId = $pdf->importPage(1, PdfReader\PageBoundaries::MEDIA_BOX);
  2540.             $pdf->addPage();
  2541.             $pdf->useImportedPage($pageId, 0.5, 0.5, 0.5);
  2543.             $testText  = "abcdefghijklmnopqrstuvwxyz0123456789";
  2545.             $current_date = date('d-M-Y');
  2546.             $DateDebut =  "";
  2547.             $DateFin = "";
  2548.             $Theme = "";
  2549.             $Lieu = "";
  2550.             $CodeSejour =  "";
  2551.             $MotPass =  "";
  2552.             $Ville = "";
  2553.             $Paye = "";
  2555.             if ($Sejour) {
  2556.                 $DateDebut = $Sejour->getDateDebutSejour();
  2557.                 $DateFin = $Sejour->getDateFinSejour();
  2558.                 $Theme = $Sejour->getThemSejour();
  2559.                 $Lieu = $Sejour->getAdresseSejour();
  2560.                 $CodeSejour = $Sejour->getCodeSejour();
  2561.                 $MotPass = $Sejour->getIdAcommp()->getPasswordNonCripted();
  2562.                 $Ville = $Sejour->getVille();
  2563.                 $Paye = $Sejour->getPays();
  2564.             }
  2566.             for ($i = 0; $i < $pageCount; $i++) {
  2567.                 $tplIdx = $pdf->importPage(1 + $i);
  2568.                 $pdf->useTemplate($tplIdx, 0, 0, 200, 300, true);
  2569.                 $theme = $Theme;
  2570.                 if (strlen($theme) > 25) {
  2571.                     $pdf->SetFont("Arial", "", 5);
  2572.                 } else {
  2573.                     $pdf->SetFont("Arial", "", 7);
  2574.                 }
  2575.                 $strTheme = iconv("UTF-8", "WINDOWS-1252", $theme);
  2576.                 $pdf->Text(35, 262, $strTheme);
  2577.                 $pdf->SetFont("Arial", "", 8);
  2578.                 $lieu = $Lieu;
  2579.                 $ville = $Ville;
  2580.                 $paye = $Paye;
  2581.                 if ($Paye  && $Ville) {
  2582.                     $strLieu = iconv("UTF-8", "WINDOWS-1252", $ville . "  " . $paye);
  2583.                     $pdf->Text(125, 262, $strLieu);
  2584.                 } elseif ($Paye) {
  2585.                     $strLieu = iconv("UTF-8", "WINDOWS-1252", $paye);
  2586.                     $pdf->Text(125, 262, $strLieu);
  2587.                 } else {
  2588.                     $strLieu = iconv("UTF-8", "WINDOWS-1252", $ville);
  2589.                     $pdf->Text(125, 262, $strLieu);
  2590.                 }
  2592.                 $pdf->SetFont("Arial", "", 10);
  2593.                 $pdf->Text(50, 252, $DateDebut->format('d/m/Y'));
  2594.                 $pdf->SetFont("Arial", "", 10);
  2595.                 $pdf->Text(90, 252, $DateFin->format('d/m/Y'));
  2596.                 $pdf->SetFont("Arial", "", 10);
  2597.                 $pdf->Text(90, 271, $CodeSejour);
  2598.                 $pdf->SetFont("Arial", "", 10);
  2599.                 $pdf->Text(75, 279, $MotPass);
  2600.             }
  2601.             $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  2602.             $pdfFilepath = $publicDirectory . "Mode d'emploi 5sur5sejour" . $idSejour . ".pdf";
  2603.             // $filename= $this->params->get('kernel.project_dir').'/public/pdf/pdfaccompagnateur.pdf';
  2604.             $pdf->Output($pdfFilepath, "F");
  2606.             $pdf = new Fpdi();
  2607.             $paym = $Sejour->getPaym();
  2608.             if ($paym == 1) {
  2609.                 $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  2610.                 $pdfFilepath = $publicDirectory . "Mode_emploi_Parent_5sur5sejour_v5_.pdf";
  2612.                 $pageCount = $pdf->setSourceFile($pdfFilepath);
  2613.             } else {
  2614.                 $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  2615.                 $pdfFilepath = $publicDirectory . "Mode_emploi_Parent_G_5sur5sejou_v5_.pdf";
  2617.                 $pageCount = $pdf->setSourceFile($pdfFilepath);
  2618.             }
  2620.             $pageId = $pdf->importPage(1, PdfReader\PageBoundaries::MEDIA_BOX);
  2622.             $pdf->addPage();
  2623.             $pdf->useImportedPage($pageId, 0.5, 0.5, 0.5);
  2625.             $testText  = "abcdefghijklmnopqrstuvwxyz0123456789";
  2627.             $current_date = date('d-M-Y');
  2628.             $DateDebut =  "";
  2629.             $DateFin = "";
  2630.             $Theme = "";
  2631.             $Lieu = "";
  2632.             $CodeSejour =  "";
  2633.             $Ville = "";
  2634.             $Paye = "";
  2638.             if ($Sejour) {
  2639.                 $DateDebut = $Sejour->getDateDebutSejour();
  2640.                 $DateFin = $Sejour->getDateFinSejour();
  2641.                 $Theme = $Sejour->getThemSejour();
  2642.                 $Lieu = $Sejour->getAdresseSejour();
  2643.                 $CodeSejour = $Sejour->getCodeSejour();
  2644.                 $Ville = $Sejour->getVille();
  2645.                 $Paye = $Sejour->getPays();
  2646.             }
  2648.             for ($i = 0; $i < $pageCount; $i++) {
  2649.                 $tplIdx = $pdf->importPage($i + 1);
  2650.                 $pdf->useTemplate($tplIdx, 0, 0, 200, 300, true);
  2651.                 $theme = $Theme;
  2652.                 if (strlen($theme) > 25) {
  2653.                     $pdf->SetFont("Arial", "", 5);
  2654.                 } else {
  2655.                     $pdf->SetFont("Arial", "", 7);
  2656.                 }
  2657.                 $strTheme = iconv("UTF-8", "WINDOWS-1252", $theme);
  2658.                 $pdf->Text(35, 268, $strTheme);
  2659.                 $pdf->SetFont("Arial", "", 8);
  2660.                 $lieu = $Lieu;
  2661.                 $ville = $Ville;
  2662.                 $paye = $Paye;
  2663.                 if ($Paye  && $Ville) {
  2664.                     $strLieu = iconv("UTF-8", "WINDOWS-1252", $ville . "  " . $paye);
  2665.                     $pdf->Text(125, 268, $strLieu);
  2666.                 } else if ($Paye) {
  2667.                     $strLieu = iconv("UTF-8", "WINDOWS-1252", $paye);
  2668.                     $pdf->Text(125, 268, $strLieu);
  2669.                 } else {
  2670.                     $strLieu = iconv("UTF-8", "WINDOWS-1252", $ville);
  2671.                     $pdf->Text(125, 268, $strLieu);
  2672.                 }
  2674.                 $pdf->SetFont("Arial", "", 10);
  2675.                 $pdf->Text(80, 279, $CodeSejour);
  2676.                 $pdf->SetFont("Arial", "", 10);
  2677.                 $pdf->Text(48, 258, $DateDebut->format('d/m/Y'));
  2678.                 $pdf->SetFont("Arial", "", 10);
  2679.                 $pdf->Text(89, 258, $DateFin->format('d/m/Y'));
  2680.             }
  2681.             if ($paym == 1) {
  2682.                 $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  2683.                 $pdfFilepath = $publicDirectory . "Mode d'emploi parent  5sur5séjour" . $idSejour . ".pdf";
  2684.                 $pdf->Output($pdfFilepath, "F");
  2685.             } else {
  2686.                 $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  2687.                 $pdfFilepath = $publicDirectory . "Mode d'emploi parent  5sur5séjour" . $idSejour . ".pdf";
  2688.                 $pdf->Output($pdfFilepath, "F");
  2689.             }
  2690.             if ($Sejour->getIdAcommp()->getReponseemail()) {
  2691.                 $emailAcco = $Sejour->getIdAcommp()->getReponseemail();
  2692.                 $partenaire = $Sejour->getIdEtablisment()->getNometab();
  2693.                 $partenaire = $Sejour->getIdEtablisment()->getLogo();
  2695.                 $logo = $Sejour->getIdEtablisment()->getLogo();
  2696.                 $nom = $Sejour->getIdEtablisment()->getNometab();
  2697.                 $message = (new \Swift_Message('Votre code séjour 5sur5sejour'))
  2698.                     ->setFrom('contact@5sur5sejour.com')
  2699.                     ->setTo($emailAcco);
  2700.                 //->setBcc(["contact@5sur5sejour.com"]);
  2701.                 $pathImage2 = $Email->getIdImage2()->getPath();
  2702.                 $pathImage1 = $Email->getIdImage1()->getPath();
  2703.                 $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  2704.                 $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  2705.                 $iconphoto = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  2706.                 $iconloca = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  2707.                 $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  2708.                 $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  2709.                 if ($paym == 1) {
  2710.                     $message->attach(\Swift_Attachment::fromPath($pdfFilepath));
  2711.                 } else {
  2712.                     $message->attach(\Swift_Attachment::fromPath($pdfFilepath));
  2713.                 }
  2714.                 $message->setBody(
  2715.                     $this->templating->render(
  2716.                         'emails/EnvoiCodeSejourUniquementToAccoAndPartenaire.html.twig',
  2717.                         [
  2718.                             "Password" => $Sejour->getIdAcommp()->getPasswordNonCripted(),
  2719.                             "code" => $Sejour->getCodeSejour(),
  2720.                             "dateCreation" => $Sejour->getDateCreationCode(),
  2721.                             "dateFinCode" => $Sejour->getDateFinCode(),
  2722.                             "lieu" => $Sejour->getAdresseSejour(),
  2723.                             "image1" => $image1,
  2724.                             "image2" => $image2,
  2725.                             "iconfooter" => $iconfooter,
  2726.                             "iconphoto" => $iconphoto,
  2727.                             "iconloca" => $iconloca,
  2728.                             "iconmsg" => $iconmsg,
  2729.                             'logo' => $logo,
  2730.                             'nom' => $nom,
  2731.                             "identifiant" => $Sejour->getCodeSejour(),
  2732.                             'roles' => $Sejour->getIdAcommp()->getRoles(),
  2733.                         ]
  2734.                     ),
  2735.                     'text/html'
  2736.                 );
  2737.                 $signMail = $this->params->get('signMail');
  2738.                 if ($signMail == 'yes') {
  2739.                     $domainName = $this->params->get('domaine');
  2740.                     $selector = $this->params->get('selector');
  2741.                     $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  2742.                     $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  2743.                     $message->attachSigner($signer);
  2744.                 }
  2745.                 try {
  2746.                     $this->mailer->send($message);
  2747.                 } catch (\Swift_SwiftException $ex) {
  2748.                     $ex->getMessage();
  2749.                 }
  2750.             }
  2751.         }
  2752.     }
  2754.     //cette fonction envoi seulement le password sejour aux partenaire et acco s'il existe
  2755.     function EnvoyerEmailPasswordSejourToPartenaire($idSejour)
  2756.     {
  2757.         $Sejour = $this->em->getRepository(Sejour::class)->find($idSejour);
  2758.         $RefEmail = $this->em->getRepository(Ref::class)->find(28);
  2760.         $Email = $this->em->getRepository(Emailing::class)->findOneBy(array('typeemail' => $RefEmail, 'statut' => 9));
  2761.         if ($Sejour) {
  2762.             if ($Sejour->getIdEtablisment()) {
  2763.                 $emailPartenaire = $Sejour->getIdEtablisment()->getEmail();
  2764.                 $partenaire = $Sejour->getIdEtablisment()->getNometab();
  2765.                 $partenaire = $Sejour->getIdEtablisment()->getLogo();
  2767.                 $logo = $Sejour->getIdEtablisment()->getLogo();
  2768.                 $nom = $Sejour->getIdEtablisment()->getNometab();
  2769.                 $message = (new \Swift_Message('Votre mot de passe 5sur5sejour'))
  2770.                     ->setFrom('partenariat-contact@5sur5sejour.com')
  2771.                     ->setTo($emailPartenaire);
  2772.                 //->setBcc(["contact@5sur5sejour.com"]);
  2775.                 $pathImage2 = $Email->getIdImage2()->getPath();
  2776.                 $pathImage1 = $Email->getIdImage1()->getPath();
  2777.                 $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  2778.                 $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  2779.                 $iconphoto = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  2780.                 $iconloca = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  2781.                 $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  2782.                 $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  2783.                 $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  2784.                 $pdfFilepath = $publicDirectory . "Mode d'emploi 5sur5sejour" . $idSejour . ".pdf";
  2785.                 $message->attach(\Swift_Attachment::fromPath($pdfFilepath));
  2786.                 $message->setBody(
  2787.                     $this->templating->render(
  2788.                         'emails/SendPasswordSejour.html.twig',
  2789.                         [
  2790.                             "Password" => $Sejour->getIdAcommp()->getPasswordNonCripted(),
  2791.                             "image1" => $image1,
  2792.                             "image2" => $image2,
  2793.                             "iconfooter" => $iconfooter,
  2794.                             "iconphoto" => $iconphoto,
  2795.                             "iconloca" => $iconloca,
  2796.                             "iconmsg" => $iconmsg,
  2797.                             'logo' => $logo,
  2798.                             'nom' => $nom,
  2799.                             'roles' => $Sejour->getIdEtablisment()->getUser()->getRoles(),
  2800.                         ]
  2801.                     ),
  2802.                     'text/html'
  2803.                 );
  2804.                 $signMail = $this->params->get('signMail');
  2805.                 if ($signMail == 'yes') {
  2806.                     $domainName = $this->params->get('domaine');
  2807.                     $selector = $this->params->get('selector');
  2808.                     $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  2809.                     $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  2810.                     $message->attachSigner($signer);
  2811.                 }
  2812.                 try {
  2813.                     $this->mailer->send($message);
  2814.                 } catch (\Swift_SwiftException $ex) {
  2815.                     $ex->getMessage();
  2816.                 }
  2817.             }
  2818.         }
  2819.     }
  2821.     //cette fonction envoi seulement le password sejour aux partenaire et acco s'il existe
  2822.     function EnvoyerEmailPasswordSejourToAcco($idSejour)
  2823.     {
  2824.         $Sejour = $this->em->getRepository(Sejour::class)->find($idSejour);
  2825.         $RefEmail = $this->em->getRepository(Ref::class)->find(28);
  2827.         $Email = $this->em->getRepository(Emailing::class)->findOneBy(array('typeemail' => $RefEmail, 'statut' => 9));
  2828.         if ($Sejour) {
  2831.             if ($Sejour->getIdAcommp()->getReponseemail()) {
  2832.                 $emailAcco = $Sejour->getIdAcommp()->getReponseemail();
  2833.                 $partenaire = $Sejour->getIdEtablisment()->getNometab();
  2834.                 $partenaire = $Sejour->getIdEtablisment()->getLogo();
  2836.                 $logo = $Sejour->getIdEtablisment()->getLogo();
  2837.                 $nom = $Sejour->getIdEtablisment()->getNometab();
  2838.                 $message = (new \Swift_Message('Votre mot de passe 5sur5sejour'))
  2839.                     ->setFrom('contact@5sur5sejour.com')
  2840.                     ->setTo($emailAcco);
  2841.                 //->setBcc(["contact@5sur5sejour.com"]);
  2842.                 $pathImage2 = $Email->getIdImage2()->getPath();
  2843.                 $pathImage1 = $Email->getIdImage1()->getPath();
  2844.                 $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  2845.                 $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  2847.                 $iconphoto = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  2848.                 $iconloca = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  2849.                 $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  2850.                 $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  2851.                 $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  2852.                 $pdfFilepath = $publicDirectory . "Mode d'emploi 5sur5sejour" . $idSejour . ".pdf";
  2853.                 $message->attach(\Swift_Attachment::fromPath($pdfFilepath));
  2854.                 $message->setBody(
  2855.                     $this->templating->render(
  2856.                         'emails/SendPasswordSejour.html.twig',
  2857.                         [
  2858.                             "Password" => $Sejour->getIdAcommp()->getPasswordNonCripted(),
  2859.                             "image1" => $image1,
  2860.                             "image2" => $image2,
  2861.                             "iconfooter" => $iconfooter,
  2862.                             "iconphoto" => $iconphoto,
  2863.                             "iconloca" => $iconloca,
  2864.                             "iconmsg" => $iconmsg,
  2865.                             'logo' => $logo,
  2866.                             'nom' => $nom,
  2867.                             'roles' => $Sejour->getIdAcommp()->getRoles(),
  2868.                         ]
  2869.                     ),
  2870.                     'text/html'
  2871.                 );
  2872.                 $signMail = $this->params->get('signMail');
  2873.                 if ($signMail == 'yes') {
  2874.                     $domainName = $this->params->get('domaine');
  2875.                     $selector = $this->params->get('selector');
  2876.                     $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  2877.                     $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  2878.                     $message->attachSigner($signer);
  2879.                 }
  2880.                 try {
  2881.                     $done = $this->mailer->send($message);
  2882.                     //var_dump($done);
  2883.                     // var_dump("send it ");
  2884.                 } catch (\Swift_SwiftException $ex) {
  2885.                     //var_dump( $ex->getMessage());
  2886.                 }
  2887.             }
  2888.         }
  2889.     }
  2891.     //Touhemi 03-07: Modifier les services et les twig des mails séjour en masse pour afficher le logo et le nom de partenaire.
  2892.     //Fonction 1:cette fonction envoi seulement le code sejour aux partenaire et acco s'il existe
  2893.     function EnvoyerEmailCodeSejourToPartenaireAndAccoAvecNomLogoPartenaire($idSejour)
  2894.     {
  2896.         $logo = '';
  2897.         $nom = '';
  2898.         $RefEmail = $this->em->getRepository(Ref::class)->find(21);
  2900.         $Email = $this->em->getRepository(Emailing::class)->findOneBy(array('typeemail' => $RefEmail, 'statut' => 9));
  2901.         $Sejour = $this->em->getRepository(Sejour::class)->find($idSejour);
  2902.         if ($Sejour) {
  2903.             if ($Sejour->getIdEtablisment()) {
  2905.                 $pdf1 = new Fpdi();
  2907.                 $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  2908.                 $pdfFilepath1 = $publicDirectory . "Mode_emploi_5sur5sejour_v5_.pdf";
  2910.                 $pageCount = $pdf1->setSourceFile($pdfFilepath1);
  2911.                 $pageId = $pdf1->importPage(1, PdfReader\PageBoundaries::MEDIA_BOX);
  2913.                 $pdf1->addPage();
  2914.                 $pdf1->useImportedPage($pageId, 0.5, 0.5, 0.5);
  2916.                 $testText  = "abcdefghijklmnopqrstuvwxyz0123456789";
  2918.                 $current_date = date('d-M-Y');
  2919.                 $DateDebut =  "";
  2920.                 $DateFin = "";
  2921.                 $Theme = "";
  2922.                 $Lieu = "";
  2923.                 $CodeSejour =  "";
  2924.                 $MotPass =  "";
  2925.                 $Ville = "";
  2926.                 $Paye = "";
  2928.                 if ($Sejour) {
  2929.                     $DateDebut = $Sejour->getDateDebutSejour();
  2930.                     $DateFin = $Sejour->getDateFinSejour();
  2931.                     $Theme = $Sejour->getThemSejour();
  2932.                     $Lieu = $Sejour->getAdresseSejour();
  2933.                     $CodeSejour = $Sejour->getCodeSejour();
  2934.                     $MotPass = $Sejour->getIdAcommp()->getPasswordNonCripted();
  2935.                     $Ville = $Sejour->getVille();
  2936.                     $Paye = $Sejour->getPays();
  2937.                 }
  2939.                 for ($i = 0; $i < $pageCount; $i++) {
  2940.                     $tplIdx = $pdf1->importPage(1 + $i);
  2941.                     $pdf1->useTemplate($tplIdx, 0, 0, 200, 300, true);
  2942.                     $theme = $Theme;
  2943.                     if (strlen($theme) > 25) {
  2944.                         $pdf1->SetFont("Arial", "", 5);
  2945.                     } else {
  2946.                         $pdf1->SetFont("Arial", "", 7);
  2947.                     }
  2948.                     $strTheme = iconv("UTF-8", "WINDOWS-1252", $theme);
  2949.                     $pdf1->Text(35, 262, $strTheme);
  2950.                     $pdf1->SetFont("Arial", "", 8);
  2951.                     $lieu = $Lieu;
  2952.                     $ville = $Ville;
  2953.                     $paye = $Paye;
  2954.                     if ($Paye  && $Ville) {
  2955.                         $strLieu = iconv("UTF-8", "WINDOWS-1252", $ville . "  " . $paye);
  2956.                         $pdf1->Text(125, 262, $strLieu);
  2957.                     } elseif ($Paye) {
  2958.                         $strLieu = iconv("UTF-8", "WINDOWS-1252", $paye);
  2959.                         $pdf1->Text(125, 262, $strLieu);
  2960.                     } else {
  2961.                         $strLieu = iconv("UTF-8", "WINDOWS-1252", $ville);
  2962.                         $pdf1->Text(125, 262, $strLieu);
  2963.                     }
  2965.                     $pdf1->SetFont("Arial", "", 10);
  2966.                     $pdf1->Text(50, 252, $DateDebut->format('d/m/Y'));
  2967.                     $pdf1->SetFont("Arial", "", 10);
  2968.                     $pdf1->Text(90, 252, $DateFin->format('d/m/Y'));
  2969.                     $pdf1->SetFont("Arial", "", 10);
  2970.                     $pdf1->Text(90, 271, $CodeSejour);
  2971.                     $pdf1->SetFont("Arial", "", 10);
  2972.                     $pdf1->Text(75, 279, $MotPass);
  2973.                 }
  2974.                 $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  2975.                 $pdfFilepath1 = $publicDirectory . "Mode d'emploi 5sur5sejour" . $idSejour . ".pdf";
  2976.                 // $filename= $this->params->get('kernel.project_dir').'/public/pdf/pdfaccompagnateur.pdf';
  2977.                 $pdf1->Output($pdfFilepath1, "F");
  2979.                 $emailPartenaire = $Sejour->getIdEtablisment()->getEmail();
  2982.                 $logo = $Sejour->getIdEtablisment()->getLogo();
  2983.                 $nom = $Sejour->getIdEtablisment()->getNometab();
  2984.                 $pdf = new Fpdi();
  2985.                 $paym = $Sejour->getPaym();
  2986.                 if ($paym == 1) {
  2987.                     $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  2988.                     $pdfFilepath = $publicDirectory . "Mode_emploi_Parent_5sur5sejour_v5_.pdf";
  2989.                     $pageCount = $pdf->setSourceFile($pdfFilepath);
  2990.                 } else {
  2991.                     $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  2992.                     $pdfFilepath = $publicDirectory . "Mode_emploi_Parent_G_5sur5sejou_v5_.pdf";
  2993.                     $pageCount = $pdf->setSourceFile($pdfFilepath);
  2994.                 }
  2996.                 $pageId = $pdf->importPage(1, PdfReader\PageBoundaries::MEDIA_BOX);
  2998.                 $pdf->addPage();
  2999.                 $pdf->useImportedPage($pageId, 0.5, 0.5, 0.5);
  3001.                 $testText  = "abcdefghijklmnopqrstuvwxyz0123456789";
  3003.                 $current_date = date('d-M-Y');
  3004.                 $DateDebut =  "";
  3005.                 $DateFin = "";
  3006.                 $Theme = "";
  3007.                 $Lieu = "";
  3008.                 $CodeSejour =  "";
  3009.                 $Ville = "";
  3010.                 $Paye = "";
  3012.                 if ($Sejour) {
  3013.                     $DateDebut = $Sejour->getDateDebutSejour();
  3014.                     $DateFin = $Sejour->getDateFinSejour();
  3015.                     $Theme = $Sejour->getThemSejour();
  3016.                     $Lieu = $Sejour->getAdresseSejour();
  3017.                     $CodeSejour = $Sejour->getCodeSejour();
  3018.                     $Ville = $Sejour->getVille();
  3019.                     $Paye = $Sejour->getPays();
  3020.                 }
  3022.                 for ($i = 0; $i < $pageCount; $i++) {
  3023.                     $tplIdx = $pdf->importPage($i + 1);
  3024.                     $pdf->useTemplate($tplIdx, 0, 0, 200, 300, true);
  3025.                     $theme = $Theme;
  3026.                     if (strlen($theme) > 25) {
  3027.                         $pdf->SetFont("Arial", "", 5);
  3028.                     } else {
  3029.                         $pdf->SetFont("Arial", "", 7);
  3030.                     }
  3031.                     $strTheme = iconv("UTF-8", "WINDOWS-1252", $theme);
  3032.                     $pdf->Text(35, 268, $strTheme);
  3033.                     $pdf->SetFont("Arial", "", 8);
  3034.                     $lieu = $Lieu;
  3035.                     $ville = $Ville;
  3036.                     $paye = $Paye;
  3037.                     if ($Paye  && $Ville) {
  3038.                         $strLieu = iconv("UTF-8", "WINDOWS-1252", $ville . "  " . $paye);
  3039.                         $pdf->Text(125, 268, $strLieu);
  3040.                     } else if ($Paye) {
  3041.                         $strLieu = iconv("UTF-8", "WINDOWS-1252", $paye);
  3042.                         $pdf->Text(125, 268, $strLieu);
  3043.                     } else {
  3044.                         $strLieu = iconv("UTF-8", "WINDOWS-1252", $ville);
  3045.                         $pdf->Text(125, 268, $strLieu);
  3046.                     }
  3048.                     $pdf->SetFont("Arial", "", 10);
  3049.                     $pdf->Text(80, 279, $CodeSejour);
  3050.                     $pdf->SetFont("Arial", "", 10);
  3051.                     $pdf->Text(48, 258, $DateDebut->format('d/m/Y'));
  3052.                     $pdf->SetFont("Arial", "", 10);
  3053.                     $pdf->Text(89, 258, $DateFin->format('d/m/Y'));
  3054.                 }
  3055.                 if ($paym == 1) {
  3056.                     $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  3057.                     $pdfFilepath = $publicDirectory . "Mode d'emploi parent  5sur5séjour" . $idSejour . ".pdf";
  3058.                     $pdf->Output($pdfFilepath, "F");
  3059.                 } else {
  3060.                     $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  3061.                     $pdfFilepath = $publicDirectory . "Mode d'emploi parent  5sur5séjour" . $idSejour . ".pdf";
  3062.                     $pdf->Output($pdfFilepath, "F");
  3063.                 }
  3064.                 $message = (new \Swift_Message('🔐 Code séjour + mot de passe – Connectez-vous à votre espace 5sur5séjour'))
  3065.                     ->setFrom('partenariat-contact@5sur5sejour.com')
  3066.                     ->setTo($emailPartenaire);
  3067.                 //->setBcc(["contact@5sur5sejour.com"]);
  3068.                 $pathImage2 = $Email->getIdImage2()->getPath();
  3069.                 $pathImage1 = $Email->getIdImage1()->getPath();
  3070.                 $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  3071.                 $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  3072.                 $iconphoto = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  3073.                 $iconloca = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  3074.                 $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  3075.                 $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  3076.                 if ($paym == 1) {
  3077.                     $message->attach(\Swift_Attachment::fromPath($pdfFilepath));
  3078.                 } else {
  3079.                     $message->attach(\Swift_Attachment::fromPath($pdfFilepath));
  3080.                 }
  3081.                 $message->setBody(
  3082.                     $this->templating->render(
  3083.                         'emails/EnvoiCodeSejourEnMassAcc.html.twig',
  3084.                         [
  3085.                             "code" => $Sejour->getCodeSejour(),
  3086.                             "dateCreation" => $Sejour->getDateCreationCode(),
  3087.                             "dateFinCode" => $Sejour->getDateFinCode(),
  3088.                             "lieu" => $Sejour->getAdresseSejour(),
  3089.                             "image1" => $image1,
  3090.                             "image2" => $image2,
  3091.                             "iconfooter" => $iconfooter,
  3092.                             "iconphoto" => $iconphoto,
  3093.                             "iconloca" => $iconloca,
  3094.                             "iconmsg" => $iconmsg,
  3095.                             "identifiant" => $Sejour->getCodeSejour(),
  3096.                             'logo' => $logo,
  3097.                             'nom' => $nom,
  3098.                             'roles' => $Sejour->getIdEtablisment()->getUser()->getRoles(),
  3099.                         ]
  3100.                     ),
  3101.                     'text/html'
  3102.                 );
  3103.                 $signMail = $this->params->get('signMail');
  3104.                 if ($signMail == 'yes') {
  3105.                     $domainName = $this->params->get('domaine');
  3106.                     $selector = $this->params->get('selector');
  3107.                     $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  3108.                     $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  3109.                     $message->attachSigner($signer);
  3110.                 }
  3111.                 try {
  3112.                     $this->mailer->send($message);
  3113.                 } catch (\Swift_SwiftException $ex) {
  3114.                     $ex->getMessage();
  3115.                 }
  3117.                 if ($emailPartenaire != $Sejour->getIdAcommp()->getReponseemail()) {
  3118.                     $emailAcco = $Sejour->getIdAcommp()->getReponseemail();
  3119.                     $message = (new \Swift_Message('Votre code séjour 5sur5sejour'))
  3120.                         ->setFrom('contact@5sur5sejour.com')
  3121.                         ->setTo($emailAcco);
  3122.                     //->setBcc(["contact@5sur5sejour.com"]);
  3123.                     $pathImage2 = $Email->getIdImage2()->getPath();
  3124.                     $pathImage1 = $Email->getIdImage1()->getPath();
  3125.                     $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  3126.                     $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  3127.                     $iconphoto = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  3128.                     $iconloca = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  3129.                     $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  3130.                     $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  3131.                     $message->attach(\Swift_Attachment::fromPath($pdfFilepath1));
  3132.                     if ($paym == 1) {
  3133.                         $message->attach(\Swift_Attachment::fromPath($pdfFilepath));
  3134.                     } else {
  3135.                         $message->attach(\Swift_Attachment::fromPath($pdfFilepath));
  3136.                     }
  3137.                     $message->setBody(
  3138.                         $this->templating->render(
  3139.                             'emails/EnvoiCodeSejourUniquementToAccoAndPartenaire.html.twig',
  3140.                             [
  3141.                                 "Password" => $Sejour->getIdAcommp()->getPasswordNonCripted(),
  3142.                                 "code" => $Sejour->getCodeSejour(),
  3143.                                 "dateCreation" => $Sejour->getDateCreationCode(),
  3144.                                 "dateFinCode" => $Sejour->getDateFinCode(),
  3145.                                 "lieu" => $Sejour->getAdresseSejour(),
  3146.                                 "image1" => $image1,
  3147.                                 "image2" => $image2,
  3148.                                 "iconfooter" => $iconfooter,
  3149.                                 "iconphoto" => $iconphoto,
  3150.                                 "iconloca" => $iconloca,
  3151.                                 "iconmsg" => $iconmsg,
  3152.                                 "identifiant" => $Sejour->getCodeSejour(),
  3153.                                 'logo' => $logo,
  3154.                                 'nom' => $nom,
  3155.                                 'roles' => $Sejour->getIdEtablisment()->getUser()->getRoles(),
  3156.                             ]
  3157.                         ),
  3158.                         'text/html'
  3159.                     );
  3160.                     $signMail = $this->params->get('signMail');
  3161.                     if ($signMail == 'yes') {
  3162.                         $domainName = $this->params->get('domaine');
  3163.                         $selector = $this->params->get('selector');
  3164.                         $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  3165.                         $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  3166.                         $message->attachSigner($signer);
  3167.                     }
  3168.                     try {
  3169.                         $this->mailer->send($message);
  3170.                     } catch (\Swift_SwiftException $ex) {
  3171.                         $ex->getMessage();
  3172.                     }
  3173.                 }
  3174.             }
  3175.         }
  3176.     }
  3178.     // Fonction 2: cette fonction envoi seulement le password sejour aux partenaire et acco s'il existe
  3179.     function EnvoyerEmailPasswordSejourToPartenaireAndAccoAvecNomLogoPartenaire($idSejour)
  3180.     {
  3182.         $logo = '';
  3183.         $nom = '';
  3184.         $Sejour = $this->em->getRepository(Sejour::class)->find($idSejour);
  3185.         $RefEmail = $this->em->getRepository(Ref::class)->find(28);
  3187.         $Email = $this->em->getRepository(Emailing::class)->findOneBy(array('typeemail' => $RefEmail, 'statut' => 9));
  3188.         if ($Sejour) {
  3189.             if ($Sejour->getIdEtablisment()) {
  3190.                 $emailPartenaire = $Sejour->getIdEtablisment()->getEmail();
  3193.                 $logo = $Sejour->getIdEtablisment()->getLogo();
  3194.                 $nom = $Sejour->getIdEtablisment()->getNometab();
  3195.                 //dd($sejour);
  3196.                 $pdf = new Fpdi();
  3197.                 $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  3198.                 $pdfFilepath = $publicDirectory . "Mode_emploi_5sur5sejour_v5_.pdf";
  3200.                 $pageCount = $pdf->setSourceFile($pdfFilepath);
  3201.                 $pageId = $pdf->importPage(1, PdfReader\PageBoundaries::MEDIA_BOX);
  3203.                 $pdf->addPage();
  3204.                 $pdf->useImportedPage($pageId, 0.5, 0.5, 0.5);
  3206.                 $testText  = "abcdefghijklmnopqrstuvwxyz0123456789";
  3208.                 $current_date = date('d-M-Y');
  3209.                 $DateDebut =  "";
  3210.                 $DateFin = "";
  3211.                 $Theme = "";
  3212.                 $Lieu = "";
  3213.                 $CodeSejour =  "";
  3214.                 $MotPass =  "";
  3215.                 $Ville = "";
  3216.                 $Paye = "";
  3218.                 if ($Sejour) {
  3219.                     $DateDebut = $Sejour->getDateDebutSejour();
  3220.                     $DateFin = $Sejour->getDateFinSejour();
  3221.                     $Theme = $Sejour->getThemSejour();
  3222.                     $Lieu = $Sejour->getAdresseSejour();
  3223.                     $CodeSejour = $Sejour->getCodeSejour();
  3224.                     $MotPass = $Sejour->getIdAcommp()->getPasswordNonCripted();
  3225.                     $Ville = $Sejour->getVille();
  3226.                     $Paye = $Sejour->getPays();
  3227.                 }
  3229.                 for ($i = 0; $i < $pageCount; $i++) {
  3230.                     $tplIdx = $pdf->importPage(1 + $i);
  3231.                     $pdf->useTemplate($tplIdx, 0, 0, 200, 300, true);
  3232.                     $theme = $Theme;
  3233.                     if (strlen($theme) > 25) {
  3234.                         $pdf->SetFont("Arial", "", 5);
  3235.                     } else {
  3236.                         $pdf->SetFont("Arial", "", 7);
  3237.                     }
  3238.                     $strTheme = iconv("UTF-8", "WINDOWS-1252", $theme);
  3239.                     $pdf->Text(35, 262, $strTheme);
  3240.                     $pdf->SetFont("Arial", "", 8);
  3241.                     $lieu = $Lieu;
  3242.                     $ville = $Ville;
  3243.                     $paye = $Paye;
  3244.                     if ($Paye && $Ville) {
  3245.                         $strLieu = iconv("UTF-8", "WINDOWS-1252", $ville . "  " . $paye);
  3246.                         $pdf->Text(125, 262, $strLieu);
  3247.                     } else if ($Paye) {
  3248.                         $strLieu = iconv("UTF-8", "WINDOWS-1252", $paye);
  3249.                         $pdf->Text(125, 262, $strLieu);
  3250.                     } else {
  3251.                         $strLieu = iconv("UTF-8", "WINDOWS-1252", $ville);
  3252.                         $pdf->Text(125, 262, $strLieu);
  3253.                     }
  3255.                     $pdf->SetFont("Arial", "", 10);
  3256.                     $pdf->Text(50, 252, $DateDebut->format('d/m/Y'));
  3257.                     $pdf->SetFont("Arial", "", 10);
  3258.                     $pdf->Text(90, 252, $DateFin->format('d/m/Y'));
  3259.                     $pdf->SetFont("Arial", "", 10);
  3260.                     $pdf->Text(90, 271, $CodeSejour);
  3261.                     $pdf->SetFont("Arial", "", 10);
  3262.                     $pdf->Text(75, 279, $MotPass);
  3263.                 }
  3264.                 $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  3265.                 $pdfFilepath = $publicDirectory . "Mode d'emploi 5sur5sejour" . $idSejour . ".pdf";
  3266.                 // $filename= $this->params->get('kernel.project_dir').'/public/pdf/pdfaccompagnateur.pdf';
  3267.                 $pdf->Output($pdfFilepath, "F");
  3269.                 $message = (new \Swift_Message('Votre mot de passe 5sur5sejour'))
  3270.                     ->setFrom('partenariat-contact@5sur5sejour.com')
  3271.                     ->setTo($emailPartenaire);
  3272.                 //->setBcc(["contact@5sur5sejour.com"]);
  3275.                 $pathImage2 = $Email->getIdImage2()->getPath();
  3276.                 $pathImage1 = $Email->getIdImage1()->getPath();
  3277.                 $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  3278.                 $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  3279.                 $iconphoto = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  3280.                 $iconloca = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  3281.                 $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  3282.                 $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  3283.                 $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  3284.                 $pdfFilepath = $publicDirectory . "Mode d'emploi 5sur5sejour" . $idSejour . ".pdf";
  3285.                 $message->attach(\Swift_Attachment::fromPath($pdfFilepath));
  3286.                 $message->setBody(
  3287.                     $this->templating->render(
  3288.                         'emails/EnvoiMotdePassSejouEnMassAcc.html.twig',
  3289.                         [
  3290.                             "Password" => $Sejour->getIdAcommp()->getPasswordNonCripted(),
  3291.                             "image1" => $image1,
  3292.                             "image2" => $image2,
  3293.                             "iconfooter" => $iconfooter,
  3294.                             "iconphoto" => $iconphoto,
  3295.                             "iconloca" => $iconloca,
  3296.                             "iconmsg" => $iconmsg,
  3297.                             'logo' => $logo,
  3298.                             'nom' => $nom,
  3299.                             'roles' => $Sejour->getIdEtablisment()->getUser()->getRoles(),
  3300.                         ]
  3301.                     ),
  3302.                     'text/html'
  3303.                 );
  3304.                 $signMail = $this->params->get('signMail');
  3305.                 if ($signMail == 'yes') {
  3306.                     $domainName = $this->params->get('domaine');
  3307.                     $selector = $this->params->get('selector');
  3308.                     $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  3309.                     $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  3310.                     $message->attachSigner($signer);
  3311.                 }
  3312.                 try {
  3313.                     $this->mailer->send($message);
  3314.                 } catch (\Swift_SwiftException $ex) {
  3315.                     $ex->getMessage();
  3316.                 }
  3319.                 if ($emailPartenaire != $Sejour->getIdAcommp()->getReponseemail()) {
  3320.                     $emailAcco = $Sejour->getIdAcommp()->getReponseemail();
  3321.                     $message = (new \Swift_Message('Votre mot de passe 5sur5sejour'))
  3322.                         ->setFrom('contact@5sur5sejour.com')
  3323.                         ->setTo($emailAcco);
  3324.                     // ->setBcc(["contact@5sur5sejour.com"]);
  3325.                     $pathImage2 = $Email->getIdImage2()->getPath();
  3326.                     $pathImage1 = $Email->getIdImage1()->getPath();
  3327.                     $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  3328.                     $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  3330.                     $iconphoto = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  3331.                     $iconloca = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  3332.                     $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  3333.                     $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  3334.                     $publicDirectory = $this->params->get('kernel.project_dir') . '/public/pdf/';
  3335.                     $pdfFilepath = $publicDirectory . "Mode d'emploi 5sur5sejour" . $idSejour . ".pdf";
  3336.                     $message->attach(\Swift_Attachment::fromPath($pdfFilepath));
  3337.                     $message->setBody(
  3338.                         $this->templating->render(
  3339.                             'emails/EnvoiMotdePassSejouEnMassAcc.html.twig',
  3340.                             [
  3341.                                 "Password" => $Sejour->getIdAcommp()->getPasswordNonCripted(),
  3342.                                 "image1" => $image1,
  3343.                                 "image2" => $image2,
  3344.                                 "iconfooter" => $iconfooter,
  3345.                                 "iconphoto" => $iconphoto,
  3346.                                 "iconloca" => $iconloca,
  3347.                                 "iconmsg" => $iconmsg,
  3348.                                 'logo' => $logo,
  3349.                                 'nom' => $nom,
  3350.                                 'roles' => $Sejour->getIdEtablisment()->getUser()->getRoles(),
  3351.                             ]
  3352.                         ),
  3353.                         'text/html'
  3354.                     );
  3355.                     $signMail = $this->params->get('signMail');
  3356.                     if ($signMail == 'yes') {
  3357.                         $domainName = $this->params->get('domaine');
  3358.                         $selector = $this->params->get('selector');
  3359.                         $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  3360.                         $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  3361.                         $message->attachSigner($signer);
  3362.                     }
  3363.                     try {
  3364.                         $done = $this->mailer->send($message);
  3365.                         //var_dump($done);
  3366.                         // var_dump("send it ");
  3367.                     } catch (\Swift_SwiftException $ex) {
  3368.                         //var_dump( $ex->getMessage());
  3369.                     }
  3370.                 }
  3371.             }
  3372.         }
  3373.     }
  3375.     //Le nombre de séjours créés
  3376.     public function getNbrSejourCree($dateDeb, $dateFin)
  3377.     {
  3378.         $nbrSejourCree = $this->em->getRepository(Sejour::class)->getNbrSejourCree($dateDeb, $dateFin);
  3379.         return $nbrSejourCree;
  3380.     }
  3382.     public function getNbrSejourCreeParPart($dateDeb, $dateFin, $part)
  3383.     {
  3384.         $nbrSejourCree = $this->em->getRepository(Sejour::class)->getNbrSejourCreeParPart($dateDeb, $dateFin, $part);
  3385.         return $nbrSejourCree;
  3386.     }
  3387.     public function getNbrSejourCreeParTypePart($dateDeb, $dateFin, $type)
  3388.     {
  3389.         $nbrSejourCree = $this->em->getRepository(Sejour::class)->getNbrSejourCreeParTypePart($dateDeb, $dateFin, $type);
  3390.         return $nbrSejourCree;
  3391.     }
  3394.     //Le nombre de séjours actifs
  3395.     public function findSejourEncourBetween($dateDeb, $dateFin)
  3396.     {
  3397.         $SejourEncourBetween = $this->em->getRepository(Sejour::class)->findSejourEncourBetween($dateDeb, $dateFin);
  3398.         return $SejourEncourBetween;
  3399.     }
  3401.     public function findSejourEncourBetweenParPart($dateDeb, $dateFin, $part)
  3402.     {
  3403.         $SejourEncourBetween = $this->em->getRepository(Sejour::class)->findSejourEncourBetweenParPart($dateDeb, $dateFin, $part);
  3404.         return $SejourEncourBetween;
  3405.     }
  3407.     //nommbre de sejour encour
  3408.     public function findSejourActiveBetween($dateDeb, $dateFin)
  3409.     {
  3410.         $SejourActiveBetween = $this->em->getRepository(Sejour::class)->findSejourActiveBetween($dateDeb, $dateFin);
  3411.         return $SejourActiveBetween;
  3412.     }
  3414.     public function findSejourActiveBetweenParPart($dateDeb, $dateFin, $part)
  3415.     {
  3416.         $SejourActiveBetween = $this->em->getRepository(Sejour::class)->findSejourActiveBetweenParPart($dateDeb, $dateFin, $part);
  3417.         return $SejourActiveBetween;
  3418.     }
  3420.     public function findSejourActiveBetweenParTypePart($dateDeb, $dateFin, $type)
  3421.     {
  3422.         $SejourActiveBetween = $this->em->getRepository(Sejour::class)->findSejourActiveBetweenParTypePart($dateDeb, $dateFin, $type);
  3423.         return $SejourActiveBetween;
  3424.     }
  3426.     //Le nombre d'enfant declare  moyen par séjour encour
  3427.     public function enfantsdeclarer($sejours)
  3428.     {
  3429.         $nbrEnfantSejours = 0;
  3430.         foreach ($sejours as $sejour) {
  3431.             $nbrEnfantSejours = $nbrEnfantSejours + $sejour->getNbenfan();
  3432.         }
  3433.         return $nbrEnfantSejours;
  3434.     }
  3436.     public function parentConnecte($sejours)
  3437.     {
  3438.         $nbrPArentSejours = 0;
  3439.         foreach ($sejours as $sejour) {
  3441.             $parent_Sejour = $this->em->getRepository(ParentSejour::class)->findBy(array('idSejour' => $sejour));
  3442.             $nbrPArentSejours = $nbrPArentSejours + sizeof($parent_Sejour);
  3443.         }
  3444.         return $nbrPArentSejours;
  3445.     }
  3447.     public function findParentDateBetween($dateDeb, $dateFin)
  3448.     {
  3449.         $findParentDateBetween = $this->em->getRepository(ParentSejour::class)->findParentDateBetween($dateDeb, $dateFin);
  3450.         return $findParentDateBetween;
  3451.     }
  3453.     public function findParentDateBetweenParPart($dateDeb, $dateFin, $part)
  3454.     {
  3455.         $findParentDateBetween = $this->em->getRepository(ParentSejour::class)->findParentDateBetweenParPart($dateDeb, $dateFin, $part);
  3456.         return $findParentDateBetween;
  3457.     }
  3458.     public function findParentDateBetweenParTypePart($dateDeb, $dateFin, $type)
  3459.     {
  3460.         $findParentDateBetween = $this->em->getRepository(ParentSejour::class)->findParentDateBetweenParTypePart($dateDeb, $dateFin, $type);
  3461.         return $findParentDateBetween;
  3462.     }
  3464.     public function FindeUSerParentBetween($dateDeb, $dateFin)
  3465.     {
  3466.         $users = $this->em->getRepository(User::class)->FindeUSerParentBetween($dateDeb, $dateFin);
  3467.         return $users;
  3468.     }
  3470.     public function FindeUSerParentActiveBetween($dateDeb, $dateFin)
  3471.     {
  3472.         $users = $this->em->getRepository(User::class)->FindeUSerParentActiveBetween($dateDeb, $dateFin);
  3473.         return $users;
  3474.     }
  3475.     public function FindeUSerParentActiveBetweenParPart($dateDeb, $dateFin, $part)
  3476.     {
  3477.         $users = $this->em->getRepository(ParentSejour::class)->FindeUSerParentActiveBetweenParPart($dateDeb, $dateFin, $part);
  3478.         return $users;
  3479.     }
  3480.     public function FindeUSerParentActiveBetweenParTypePart($dateDeb, $dateFin, $type)
  3481.     {
  3482.         $users = $this->em->getRepository(ParentSejour::class)->FindeUSerParentActiveBetweenParTypePart($dateDeb, $dateFin, $type);
  3483.         return $users;
  3484.     }
  3486.     public function findSejourEncourBetweenParTypePart($dateDeb, $dateFin, $type)
  3487.     {
  3488.         $users = $this->em->getRepository(ParentSejour::class)->FindeUSerParentActiveBetweenParPart($dateDeb, $dateFin, $type);
  3489.         return $users;
  3490.     }
  3492.     function caConnexionTotalFree()
  3493.     {
  3495.         $etabs = $this->em->getRepository(Etablisment::class)->findAll();
  3496.         $cconnexionFree = 0;
  3497.         $nbrConexxion = 0;
  3498.         foreach ($etabs as $etab) {
  3500.             $sejours = $this->em->getRepository(Sejour::class)->findBy(array("idEtablisment" => $etab));
  3501.             $prixtotPArt = 0;
  3502.             $flag = false;
  3503.             foreach ($sejours as $sejour) {
  3504.                 $lastday = \DateTime::createFromFormat("Y-m-d H:i:s", date("Y-08-01 00:00:00"));
  3506.                 if ((substr($sejour->getCodeSejour(), 1, 1) == 'F')) {
  3507.                     $flag = true;
  3508.                     $parent_sejours = $this->em->getRepository(ParentSejour::class)->findBy(array("idSejour" => $sejour));
  3510.                     $prixConnPArt = $sejour->getPrixcnxpartenaire();
  3511.                     $nbrConexxion = $nbrConexxion + sizeof($parent_sejours);
  3512.                     $prixtotal = $prixConnPArt * sizeof($parent_sejours);
  3513.                     $prixtotPArt = $prixtotPArt + $prixtotal;
  3514.                 }
  3515.             }
  3516.             $cconnexionFree = $cconnexionFree + $prixtotPArt;
  3517.         }
  3520.         return [$cconnexionFree, $nbrConexxion];
  3521.     }
  3523.     function caConnexionTotalFreeParPart($part)
  3524.     {
  3526.         $etabs = $this->em->getRepository(Etablisment::class)->findAll();
  3527.         $cconnexionFree = 0;
  3528.         $nbrConexxion = 0;
  3529.         foreach ($etabs as $etab) {
  3530.             if ($etab->getId() == $part) {
  3531.                 $sejours = $this->em->getRepository(Sejour::class)->findBy(array("idEtablisment" => $etab));
  3532.                 $prixtotPArt = 0;
  3533.                 $flag = false;
  3534.                 foreach ($sejours as $sejour) {
  3535.                     $lastday = \DateTime::createFromFormat("Y-m-d H:i:s", date("Y-08-01 00:00:00"));
  3537.                     if ((substr($sejour->getCodeSejour(), 1, 1) == 'F')) {
  3538.                         $flag = true;
  3539.                         $parent_sejours = $this->em->getRepository(ParentSejour::class)->findBy(array("idSejour" => $sejour));
  3541.                         $prixConnPArt = $sejour->getPrixcnxpartenaire();
  3542.                         $nbrConexxion = $nbrConexxion + sizeof($parent_sejours);
  3543.                         $prixtotal = $prixConnPArt * sizeof($parent_sejours);
  3544.                         $prixtotPArt = $prixtotPArt + $prixtotal;
  3545.                     }
  3546.                 }
  3547.                 $cconnexionFree = $cconnexionFree + $prixtotPArt;
  3548.             }
  3549.         }
  3552.         return [$cconnexionFree, $nbrConexxion];
  3553.     }
  3555.     function caConnexionTotalPaye()
  3556.     {
  3557.         $prixtotPArt = 0;
  3558.         $flag = false;
  3560.         $parent_sejours = $this->em->getRepository(ParentSejour::class)->findBy(array("payment" => 1));
  3562.         $prixConnPArt = 2.9;
  3563.         $nbrConexxion = sizeof($parent_sejours);
  3564.         $prixtotal = $prixConnPArt * sizeof($parent_sejours);
  3565.         $prixtotPArt = $prixtotPArt + $prixtotal;
  3567.         return [$prixtotPArt, $nbrConexxion];
  3568.     }
  3570.     function caConnexionTotalPayeParPart($part)
  3571.     {
  3572.         $prixtotPArt = 0;
  3573.         $flag = false;
  3575.         $parent_sejours = $this->em->getRepository(ParentSejour::class)->findBy(array("payment" => 1));
  3577.         $prixConnPArt = 2.9;
  3578.         $nbrConexxion = 0;
  3579.         foreach ($parent_sejours as $sej) {
  3580.             if ($sej->getIdSejour()->getIdEtablisment()->getId() == $part) {
  3581.                 $nbrConexxion = $nbrConexxion + 1;
  3582.             }
  3583.         }
  3584.         $prixtotal = $prixConnPArt * $nbrConexxion;
  3585.         $prixtotPArt = $prixtotPArt + $prixtotal;
  3587.         return [$prixtotPArt, $nbrConexxion];
  3588.     }
  3590.     function caConnexionTotal()
  3591.     {
  3592.         return [$this->caConnexionTotalPaye()[0] + $this->caConnexionTotalFree()[0], $this->caConnexionTotalPaye()[1] + $this->caConnexionTotalFree()[1]];
  3593.     }
  3595.     function caConnexionTotalParPart($part)
  3596.     {
  3597.         return [$this->caConnexionTotalPayeParPart($part)[0] + $this->caConnexionTotalFreeParPart($part)[0], $this->caConnexionTotalPayeParPart($part)[1] + $this->caConnexionTotalFreeParPart($part)[1]];
  3598.     }
  3600.     function caProduit()
  3601.     {
  3602.         return $this->em->getRepository(Commande::class)->caProduit();
  3603.     }
  3605.     //Le nombre de comptes ouverts
  3606.     //Le nombre comptes activés
  3607.     //Le nombre de commande en cours
  3608.     //Le nombre de commande moyen par sejour
  3609.     //Le CA connexion en cours (décomposé en connexion payé partenaire et connexion payé par parent)
  3610.     //Le montant du panier moyen
  3611.     //Le nombre moyen de produits par commande
  3612.     //Montant du reversement connexion
  3613.     //Montant de reversement commande
  3615.     function caConnexionTotalFreeEncour()
  3616.     {
  3618.         $cconnexionFree = 0;
  3619.         $nbrConexxion = 0;
  3621.         $sejours = $this->em->getRepository(Sejour::class)->findSejourListEncourFree();
  3622.         // dd($sejours);
  3623.         $prixtotPArt = 0;
  3624.         $flag = false;
  3625.         foreach ($sejours as $sejour) {
  3626.             if ((substr($sejour->getCodeSejour(), 1, 1) == 'F')) {
  3627.                 $flag = true;
  3628.                 $parent_sejours = $this->em->getRepository(ParentSejour::class)->findBy(array("idSejour" => $sejour->getId()));
  3629.                 $prixConnPArt = $sejour->getPrixcnxpartenaire();
  3630.                 $nbrConexxion = $nbrConexxion + sizeof($parent_sejours);
  3631.                 $prixtotal = $prixConnPArt * sizeof($parent_sejours);
  3632.                 $prixtotPArt = $prixtotPArt + $prixtotal;
  3633.             }
  3634.         }
  3636.         return $prixtotPArt;
  3637.     }
  3639.     function caConnexionTotalFreeEncourParPart($part)
  3640.     {
  3642.         $cconnexionFree = 0;
  3643.         $nbrConexxion = 0;
  3645.         $sejours = $this->em->getRepository(Sejour::class)->findSejourListEncourFreeParPart($part);
  3646.         // dd($sejours);
  3647.         $prixtotPArt = 0;
  3648.         $flag = false;
  3649.         foreach ($sejours as $sejour) {
  3650.             if ((substr($sejour->getCodeSejour(), 1, 1) == 'F')) {
  3651.                 $flag = true;
  3652.                 $parent_sejours = $this->em->getRepository(ParentSejour::class)->findBy(array("idSejour" => $sejour->getId()));
  3653.                 $prixConnPArt = $sejour->getPrixcnxpartenaire();
  3654.                 $nbrConexxion = $nbrConexxion + sizeof($parent_sejours);
  3655.                 $prixtotal = $prixConnPArt * sizeof($parent_sejours);
  3656.                 $prixtotPArt = $prixtotPArt + $prixtotal;
  3657.             }
  3658.         }
  3660.         return $prixtotPArt;
  3661.     }
  3663.     function caConnexionTotalPayEncour()
  3664.     {
  3665.         $sejours = $this->em->getRepository(Sejour::class)->findSejourListEncourPay();
  3666.         $someparsejour = 0;
  3667.         foreach ($sejours as $sejour) {
  3668.             $parent_sejours = $this->em->getRepository(ParentSejour::class)->findBy(array("idSejour" => $sejour->getId(), 'payment' => 1));
  3669.             $someparsejour = $someparsejour + (sizeof($parent_sejours) * 2.9);
  3670.         }
  3671.         //    var_dump($someparsejour);
  3672.         return $someparsejour;
  3673.     }
  3675.     function caConnexionTotalPayEncourParPart($part)
  3676.     {
  3677.         $sejours = $this->em->getRepository(Sejour::class)->findSejourListEncourPay();
  3678.         $someparsejour = 0;
  3679.         foreach ($sejours as $sejour) {
  3680.             // var_dump($sejour);
  3681.             if ($sejour->getIdEtablisment()->getId() == $part) {
  3682.                 $parent_sejours = $this->em->getRepository(ParentSejour::class)->findBy(array("idSejour" => $sejour->getId(), 'payment' => 1));
  3683.                 $someparsejour = $someparsejour + (sizeof($parent_sejours) * 2.9);
  3684.             }
  3685.         }
  3686.         //    var_dump($someparsejour);
  3687.         return $someparsejour;
  3688.     }
  3690.     public function Formaterarraydate($arraytoFormat, $chantest)
  3691.     {
  3693.         $arrayFInal = array();
  3694.         foreach ($arraytoFormat as $entit) {
  3695.             // var_dump($entit->$chantest()->format('d/m/Y'));
  3696.             if (array_key_exists($entit->$chantest()->format('d/m/Y'), $arrayFInal)) {
  3697.                 array_push($arrayFInal, $entit);
  3698.             } else {
  3699.                 $arrayFInal[$entit->$chantest()->format('d/m/Y')] = array($entit);
  3700.             }
  3701.         }
  3702.         return $arrayFInal;
  3703.     }
  3705.     public function FormaterarraydateBetween($arraytoFormat, $chanttestDEb, $chantestEnd, $dateDEbut, $dateFinoriginal)
  3706.     {
  3707.         //         var_dump("dateFin1");
  3708.         //         var_dump($dateFin);
  3709.         $arrayFInal = array();
  3710.         $dateFin = clone $dateFinoriginal;
  3711.         $dateFin->modify('+1 day');
  3712.         $period = new DatePeriod(
  3713.             $dateDEbut,
  3714.             new DateInterval('P1D'),
  3715.             $dateFin
  3716.         );
  3717.         foreach ($period as $key => $value) {
  3718.             $arrayFInal[$value->format('d/m/Y')] = array();
  3719.             foreach ($arraytoFormat as $entit) {
  3720.                 if ($value <= $entit->$chantestEnd() && $value >= $entit->$chanttestDEb())
  3721.                     if (array_key_exists($value->format('d/m/Y'), $arrayFInal)) {
  3722.                         array_push($arrayFInal[$value->format('d/m/Y')], $entit->getCodeSejour());
  3723.                     } else {
  3724.                         $arrayFInal[$value->format('d/m/Y')] = array($entit->getCodeSejour());
  3725.                     }
  3726.             }
  3727.         }
  3728.         return $arrayFInal;
  3729.     }
  3731.     public function FormaterarraydateBetweennbrEnfant($arraytoFormat, $chanttestDEb, $chantestEnd, $dateDEbut, $dateFin)
  3732.     {
  3733.         $arrayFInal = array();
  3734.         $totalenf = 0;
  3736.         foreach ($arraytoFormat as $entit) {
  3738.             if (array_key_exists($entit->getCodeSejour(), $arrayFInal)) {
  3739.                 $arrayFInal[$entit->getCodeSejour()]['nbrenfdec'] = $arrayFInal[$entit->getCodeSejour()]['nbrenfdec'] + $entit->getNbenfan();
  3740.                 $arrayFInal[$entit->getCodeSejour()]['nbrParentCncte'] = $arrayFInal[$entit->getCodeSejour()]['nbrParentCncte'] + $entit->getCountParentSejour();
  3741.             } else {
  3742.                 $arrayFInal[$entit->getCodeSejour()] = array('nbrenfdec' => $entit->getNbenfan(), 'nbrParentCncte' => $entit->getCountParentSejour());
  3743.             }
  3745.             $totalenf = $totalenf + $entit->getNbenfan();
  3746.         }
  3747.         $arrayFInal = $this->sort_col($arrayFInal, 'nbrParentCncte');
  3748.         $arrayFInal['totenf'] = $totalenf;
  3749.         return  $arrayFInal;
  3750.     }
  3752.     public function FormaterarraydateBetweennbrPArentCncte($arraytoFormat, $chanttest, $dateDEbut, $dateFinoriginal)
  3753.     {
  3754.         $arrayFInal = array();
  3755.         $dateFin = clone $dateFinoriginal;
  3756.         $dateFin->modify('+1 day');
  3757.         $period = new DatePeriod(
  3758.             $dateDEbut,
  3759.             new DateInterval('P1D'),
  3760.             $dateFin
  3761.         );
  3762.         foreach ($period as $key => $value) {
  3763.             $arrayFInal[$value->format('d/m/Y')] = 0;
  3765.             foreach ($arraytoFormat as $entit) {
  3767.                 if ($value->format('d/m/Y') == $entit->$chanttest()->format('d/m/Y')) {
  3769.                     if (array_key_exists($value->format('d/m/Y'), $arrayFInal)) {
  3770.                         $arrayFInal[$value->format('d/m/Y')] = $arrayFInal[$value->format('d/m/Y')] + 1;
  3771.                     } else {
  3772.                         $arrayFInal[$value->format('d/m/Y')] = 1;
  3773.                     }
  3774.                 }
  3775.             }
  3776.         }
  3777.         return $arrayFInal;
  3778.     }
  3780.     function sort_col($table, $colname)
  3781.     {
  3782.         $tn = $ts = $temp_num = $temp_str = array();
  3783.         //    dd($table);
  3784.         foreach ($table as $key => $row) {
  3785.             /*        var_dump($colname);
  3786.         var_dump($key);
  3787.         var_dump($row[$colname]);
  3788.         var_dump(substr($row[$colname],0,1));
  3789.         var_dump(is_numeric(substr($row[$colname],0,1)));
  3790.         var_dump($key);
  3791.  
  3792.         echo '<br>';
  3793.  */
  3794.             if (is_numeric(substr($row[$colname], 0, 1))) {
  3795.                 $tn[$key] = $row[$colname];
  3796.                 $temp_num[$key] = $row;
  3797.             } else {
  3798.                 $ts[$key] = $row[$colname];
  3799.                 $temp_str[$key] = $row;
  3800.             }
  3801.         }
  3802.         unset($table);
  3804.         array_multisort($tn, SORT_DESC, SORT_NUMERIC, $temp_num);
  3805.         array_multisort($ts, SORT_DESC, SORT_STRING, $temp_str);
  3806.         return array_merge($temp_num, $temp_str);
  3807.     }
  3809.     function EnvoyerEmailNewAccompagnateurPlus($partenaire)
  3810.     {
  3811.         $logo = '';
  3812.         $nom = '';
  3813.         if ($partenaire->hasRole('ROLE_PARTENAIRE')) {
  3814.             $logo = $partenaire->getLogourl();
  3815.             $nom = $partenaire->getNometablisment();
  3816.         }
  3817.         $RefEmail = $this->em->getRepository(Ref::class)->find(17);
  3818.         $Email = $this->em->getRepository(Emailing::class)->findOneBy(array('typeemail' => $RefEmail));
  3819.         $sendTo = $partenaire->getEmail();
  3820.         $message = (new \Swift_Message('Nouveau partenaire'))
  3821.             ->setFrom('partenariat-contact@5sur5sejour.com')
  3822.             ->setTo($sendTo);
  3823.         //->setBcc(["contact@5sur5sejour.com"]);
  3825.         $pathImage2 = $Email->getIdImage2()->getPath();
  3826.         $pathImage1 = $Email->getIdImage1()->getPath();
  3827.         $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  3828.         $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  3829.         $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  3830.         $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  3831.         $icon2 = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  3832.         $icon3 = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  3834.         $message->setBody(
  3835.             $this->templating->render(
  3836.                 'emails/AccompagnateurPlusNew.html.twig',
  3837.                 [
  3838.                     "Nomdestinataire" => $partenaire->getNom(),
  3839.                     "Predestinataire" => $partenaire->getPrenom(),
  3840.                     "password" => $partenaire->getPasswordNonCripted(),
  3841.                     "image1" => $image1,
  3842.                     "image2" => $image2,
  3843.                     "icon2" => $icon2,
  3844.                     "icon3" => $icon3,
  3845.                     "iconfooter" => $iconfooter,
  3846.                     "iconmsg" => $iconmsg,
  3847.                     "idPartenaire" => $partenaire->getId(),
  3848.                     "identifiant" => $sendTo,
  3849.                     "password" => $partenaire->getPasswordNonCripted(),
  3850.                     'logo' => $logo,
  3851.                     'nom' => $nom,
  3852.                 ]
  3853.             ),
  3854.             'text/html'
  3855.         );
  3856.         $signMail = $this->params->get('signMail');
  3857.         if ($signMail == 'yes') {
  3858.             $domainName = $this->params->get('domaine');
  3859.             $selector = $this->params->get('selector');
  3860.             $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  3861.             $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  3862.             $message->attachSigner($signer);
  3863.         }
  3864.         try {
  3865.             $this->mailer->send($message);
  3866.         } catch (\Swift_SwiftException $ex) {
  3867.             $ex->getMessage();
  3868.         }
  3869.     }
  3872.     function EnvoyerEmailSejourRecapProduitsSansCommandes($nomfilevalid)
  3873.     {
  3874.         $logo = '';
  3875.         $nom = '';
  3877.         $RefEmail = $this->em->getRepository(Ref::class)->find(29);
  3879.         $Email = $this->em->getRepository(Emailing::class)->findOneBy(array('typeemail' => $RefEmail, 'statut' => 9));
  3881.         $sendTo = "touhemib@gmail.com";
  3884.         $message = (new \Swift_Message('Produits sans commanes'))
  3885.             ->setFrom('touhemib@gmail.com')
  3886.             ->setTo($sendTo);
  3887.         $pathImage2 = $Email->getIdImage2()->getPath();
  3888.         $pathImage1 = $Email->getIdImage1()->getPath();
  3889.         $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  3890.         $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  3891.         $iconphoto = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  3892.         $iconloca = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  3893.         $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  3894.         $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  3898.         $message->attach(Swift_Attachment::fromPath($this->projectDir . '/public/message//' . $nomfilevalid)->setFilename('Recap_Excel_ProduitsSansCommandes.xlsx'));
  3902.         $message->setBody(
  3903.             $this->templating->render(
  3904.                 // Firas : completer Twig
  3905.                 'emails/RecapParentsCreerProduitsSansCommande.html.twig',
  3906.                 [
  3907.                     "image1" => $image1,
  3908.                     "image2" => $image2,
  3909.                     "iconfooter" => $iconfooter,
  3910.                     "iconphoto" => $iconphoto,
  3911.                     "iconloca" => $iconloca,
  3912.                     "iconmsg" => $iconmsg,
  3913.                     'logo' => $logo,
  3914.                     'nom' => $nom,
  3915.                 ]
  3916.             ),
  3917.             'text/html'
  3918.         );
  3919.         $signMail = $this->params->get('signMail');
  3920.         if ($signMail == 'yes') {
  3921.             $domainName = $this->params->get('domaine');
  3922.             $selector = $this->params->get('selector');
  3923.             $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  3924.             $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  3925.             $message->attachSigner($signer);
  3926.         }
  3927.         try {
  3928.             $this->mailer->send($message);
  3929.         } catch (\Swift_SwiftException $ex) {
  3930.             $ex->getMessage();
  3931.         }
  3932.     }
  3937.     function EnvoyerMailExport($nomfilevalid)
  3938.     {
  3939.         $logo = '';
  3940.         $nom = '';
  3942.         $RefEmail = $this->em->getRepository(Ref::class)->find(29);
  3944.         $Email = $this->em->getRepository(Emailing::class)->findOneBy(array('typeemail' => $RefEmail, 'statut' => 9));
  3946.         $sendTo = "touhemib@gmail.com";
  3949.         $message = (new \Swift_Message('Export'))
  3950.             ->setFrom('contact@5sur5sejour.com')
  3951.             ->setTo(['touhemib@gmail.com', 'yousra.tlich@gmail.com']);
  3952.         $pathImage2 = $Email->getIdImage2()->getPath();
  3953.         $pathImage1 = $Email->getIdImage1()->getPath();
  3954.         $image1 = $message->embed(Swift_Image::fromPath("$pathImage1"));
  3955.         $image2 = $message->embed(Swift_Image::fromPath("$pathImage2"));
  3956.         $iconphoto = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_419_pqx0dx.png"));
  3957.         $iconloca = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719650/Groupe_420_uynuqz.png"));
  3958.         $iconmsg = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Groupe_418_wbyysk.png"));
  3959.         $iconfooter = $message->embed(Swift_Image::fromPath("https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png"));
  3963.         $message->attach(Swift_Attachment::fromPath($this->projectDir . '/public/message//' . $nomfilevalid)->setFilename('Recap_Excel_ProduitsSansCommandes.xlsx'));
  3967.         $message->setBody(
  3968.             $this->templating->render(
  3969.                 // Firas : completer Twig
  3970.                 'emails/RecapParentsCreerProduitsSansCommande.html.twig',
  3971.                 [
  3972.                     "image1" => $image1,
  3973.                     "image2" => $image2,
  3974.                     "iconfooter" => $iconfooter,
  3975.                     "iconphoto" => $iconphoto,
  3976.                     "iconloca" => $iconloca,
  3977.                     "iconmsg" => $iconmsg,
  3978.                     'logo' => $logo,
  3979.                     'nom' => $nom,
  3980.                 ]
  3981.             ),
  3982.             'text/html'
  3983.         );
  3984.         $signMail = $this->params->get('signMail');
  3985.         if ($signMail == 'yes') {
  3986.             $domainName = $this->params->get('domaine');
  3987.             $selector = $this->params->get('selector');
  3988.             $PrivateKey = file_get_contents($this->params->get('pathDKIM'));
  3989.             $signer = new \Swift_Signers_DKIMSigner($PrivateKey, $domainName, $selector);
  3990.             $message->attachSigner($signer);
  3991.         }
  3992.         try {
  3993.             $this->mailer->send($message);
  3994.         } catch (\Swift_SwiftException $ex) {
  3995.             $ex->getMessage();
  3996.         }
  3997.     }
  4001.     public function creationPromotion($code, $type, $nbreMaxGeneral, $nbreMaxParUser, $dateDebut, $dateFin, $etat, $pourcentage, $nbreApplique, $strategie)
  4002.     {
  4003.         $statutCreate = $this->em->getRepository(Ref::class)->find(1);
  4005.         $promotion = new Promotions();
  4006.         $promotion->setCode($code);
  4007.         $promotion->setType($type);
  4009.         $promotion->setNbreMaxGeneral(intval($nbreMaxGeneral));
  4010.         $promotion->setNbreMaxParUser(intval($nbreMaxParUser));
  4011.         $promotion->setDateCreation(new \DateTime());
  4012.         $promotion->setStatut($statutCreate);
  4013.         $dateDebutFormat = date_create_from_format('Y-m-d', $dateDebut);
  4014.         $promotion->setDateDebut($dateDebutFormat);
  4015.         $dateFinFormat = date_create_from_format('Y-m-d', $dateFin);
  4016.         $promotion->setDateFin($dateFinFormat);
  4017.         $promotion->setEtat(intval($etat));
  4018.         $promotion->setPourcentage(intval($pourcentage));
  4019.         $promotion->setStrategie($strategie);
  4020.         $promotion->setNbreApplicable($nbreApplique);
  4021.         $this->em->getManager()->persist($promotion);
  4022.         $this->em->getManager()->flush();
  4024.         return $promotion;
  4025.     }
  4029.     public function listePromotions()
  4030.     {
  4032.         $promotions = $this->em->getRepository(Promotions::class)->findBy(array('statut' => 1));
  4033.         return $promotions;
  4034.     }
  4038.     public function detailsPromotion($idPromo)
  4039.     {
  4041.         $promotion = $this->em->getRepository(Promotions::class)->find($idPromo);
  4042.         return $promotion;
  4043.     }
  4047.     public  function deletePromotion($idPromo)
  4048.     {
  4050.         $promotion = $this->em->getRepository(Promotions::class)->find($idPromo);
  4051.         $statutDelete = $this->em->getRepository(Ref::class)->find(39);
  4053.         if ($promotion) {
  4054.             $promotion->setStatut($statutDelete);
  4055.             $this->em->getManager()->persist($promotion);
  4056.             $this->em->getManager()->flush();
  4057.         }
  4058.         return $promotion;
  4059.     }
  4061.     public function updatePromotion($idPromo, $type, $nbreMaxGeneral, $nbreMaxParUser, $dateDebut, $dateFin, $etat, $pourcentage, $nbreApplique)
  4062.     {
  4064.         $promotion = $this->em->getRepository(Promotions::class)->find($idPromo);
  4068.         if ($promotion) {
  4070.             if ($promotion->getType() == "parents") {
  4071.                 $tabParentsPromo = $this->em->getRepository(PromoParents::class)->findBy(array('promotion' => $promotion));
  4072.                 if (sizeof($tabParentsPromo)) {
  4073.                     foreach ($tabParentsPromo as $pp) {
  4074.                         $this->em->remove($pp);
  4075.                         $this->em->getManager()->flush();
  4076.                     }
  4077.                 }
  4078.             }
  4080.             if ($promotion->getType() == "codeSejour") {
  4081.                 $tabSejourParents = $this->em->getRepository(PromoSejour::class)->findBy(array('promotion' => $promotion));
  4082.                 if (sizeof($tabSejourParents)) {
  4083.                     foreach ($tabSejourParents as $pp) {
  4084.                         $this->em->remove($pp);
  4085.                         $this->em->getManager()->flush();
  4086.                     }
  4087.                 }
  4088.             }
  4089.             $promotion->setType($type);
  4091.             $promotion->setNbreMaxGeneral(intval($nbreMaxGeneral));
  4092.             $promotion->setNbreMaxParUser(intval($nbreMaxParUser));
  4093.             $dateDebutFormat = date_create_from_format('Y-m-d', $dateDebut);
  4094.             $promotion->setDateDebut($dateDebutFormat);
  4095.             $dateFinFormat = date_create_from_format('Y-m-d', $dateFin);
  4096.             $promotion->setDateFin($dateFinFormat);
  4097.             $promotion->setEtat(intval($etat));
  4098.             $promotion->setPourcentage(intval($pourcentage));
  4099.             $promotion->setNbreApplicable($nbreApplique);
  4100.             $this->em->getManager()->persist($promotion);
  4101.             $this->em->getManager()->flush();
  4102.         }
  4103.         return $promotion;
  4104.     }
  4107.     public function findPromotionByCode($code)
  4108.     {
  4109.         $promotion = $this->em->getRepository(Promotions::class)->findOneBy(array('code' => $code, 'etat' => 1));
  4111.         return $promotion;
  4112.     }
  4115.     public function checkCodePromoForCreation($code)
  4116.     {
  4117.         $promotion = $this->em->getRepository(Promotions::class)->findOneBy(array('code' => $code));
  4118.         if ($promotion) {
  4119.             $tab['test'] = true;
  4120.             $tab['pourcentage'] = $promotion->getPourcentage();
  4121.             return $tab;
  4122.         } else {
  4124.             $tab['test'] = false;
  4125.             $tab['pourcentage'] = 0;
  4126.             return $tab;
  4127.         }
  4128.     }
  4129.     public function checkCodePromoPrents($code, $user)
  4130.     {
  4132.         $promotion = $this->em->getRepository(Promotions::class)->findOneBy(array('code' => $code, 'etat' => 1));
  4134.         if ($promotion && $user->getShowdetailsphotos() != "4") {
  4136.             $tab['test'] = true;
  4137.             $tab['pourcentage'] = $promotion->getPourcentage();
  4138.             return $tab;
  4139.         } else {
  4141.             $tab['test'] = false;
  4142.             $tab['pourcentage'] = 0;
  4143.             return $tab;
  4144.         }
  4145.     }
  4147.     public function checkCodePromo($code)
  4148.     {
  4149.         $promotion = $this->em->getRepository(Promotions::class)->findOneBy(array('code' => $code, 'etat' => 1));
  4150.         if ($promotion) {
  4151.             $tab['test'] = true;
  4152.             $tab['pourcentage'] = $promotion->getPourcentage();
  4153.             return $tab;
  4154.         } else {
  4156.             $tab['test'] = false;
  4157.             $tab['pourcentage'] = 0;
  4158.             return $tab;
  4159.         }
  4160.     }
  4161.     public function changerEtatPromotion($idPromotion, $etat)
  4162.     {
  4163.         $promotion = $this->em->getRepository(Promotions::class)->find($idPromotion);
  4164.         if ($promotion) {
  4165.             $promotion->setEtat(intval($etat));
  4166.             $this->em->getManager()->persist($promotion);
  4167.             $this->em->getManager()->flush();
  4168.         }
  4169.         return $promotion;
  4170.     }
  4173.     public function createLogPromotion($idPromotion, $idCommande, $idClient)
  4174.     {
  4175.         $logPromotion = new LogPromotions();
  4176.         $logPromotion->setIdPromotion($idPromotion);
  4177.         $logPromotion->setIdClient($idClient);
  4178.         $logPromotion->setIdCommande($idCommande);
  4179.         $logPromotion->setDateCreation(new \DateTime());
  4181.         $this->em->getManager()->persist($logPromotion);
  4182.         $this->em->getManager()->flush();
  4185.         return $logPromotion;
  4186.     }
  4188.     public function checkCodePromoParUser($idPromo, $idClient)
  4189.     {
  4190.         $promotion = $this->em->getRepository(Promotions::class)->find($idPromo);
  4191.         $tabLogPromo = $this->em->getRepository(LogPromotions::class)->findBy(array('idPromotion' => $idPromo, 'idClient' => $idClient));
  4192.         $nbreMaxParUser = $promotion->getNbreMaxParUser();
  4193.         $nbreLog = sizeOf($tabLogPromo);
  4194.         if ($nbreLog == $nbreMaxParUser) {
  4195.             return false;
  4196.         } else {
  4197.             return true;
  4198.         }
  4199.     }
  4202.     public function checkCodePromoAvance($code, $idClient, $idSejour, $role, $panier)
  4203.     {
  4205.         $panierElPromo = [];
  4206.         $promotion = $this->em->getRepository(Promotions::class)->findOneBy(array('code' => $code, 'etat' => 1));
  4207.         if ($promotion) {
  4208.             $type = $promotion->getType();
  4209.             $affectedProducts = $promotion->getStrategie();
  4210.             if ($affectedProducts != 'all' && trim($affectedProducts) != null) {
  4211.                 foreach ($panier as $element) {
  4212.                     $panierProduit = $this->em->getRepository(PanierProduit::class)->findOneBy(array('idPanier' => $element['id']));
  4213.                     if ($panierProduit) {
  4214.                         $produit = $panierProduit->getIdProduit();
  4215.                         if ($produit->getType()->getId() == $affectedProducts) {
  4216.                             $panierElPromo[] = $element['id'];
  4217.                         }
  4218.                     }
  4219.                 }
  4220.                 if (!$panierElPromo) {
  4221.                     $tab['test'] = false;
  4222.                     $tab['pourcentage'] = 0;
  4223.                     return $tab;
  4224.                 }
  4225.             }
  4226.             if (($role == "ROLE_ACC" && $type == "accompagnateur") || ($type == "parent" && $role == "ROLE_PARENT")) {
  4227.                 $tabLogPromo = $this->em->getRepository(LogPromotions::class)->findBy(array('idPromotion' => $promotion, 'idClient' => $idClient));
  4228.                 $nbreMaxParUser = $promotion->getNbreMaxParUser();
  4229.                 $nbreLog = sizeOf($tabLogPromo);
  4231.                 if ($nbreMaxParUser != 0 && $nbreLog == $nbreMaxParUser) {
  4232.                     $tab['test'] = false;
  4233.                     $tab['pourcentage'] = 0;
  4234.                     return $tab;
  4235.                 } else {
  4236.                     $tab['test'] = true;
  4237.                     $tab['pourcentage'] = $promotion->getPourcentage();
  4240.                     $tab['remise'] = $this->caclRemiseInPanier($panier, $promotion->getStrategie(), $promotion->getNbreApplicable(), $promotion->getPourcentage());
  4241.                     return $tab;
  4242.                 }
  4243.             } elseif ($type == "parents" || $type == "Parents") {
  4244.                 $client = $this->em->getRepository(User::class)->find($idClient);
  4245.                 $promoParents = $this->em->getRepository(PromoParents::class)->findOneBy(array('promotion' => $promotion, 'parent' => $client));
  4246.                 if ($promoParents) {
  4247.                     $tabLogPromo = $this->em->getRepository(LogPromotions::class)->findBy(array('idPromotion' => $promotion, 'idClient' => $idClient));
  4248.                     $nbreMaxParUser = $promotion->getNbreMaxParUser();
  4249.                     $nbreLog = sizeOf($tabLogPromo);
  4250.                     if ($nbreMaxParUser != 0 && $nbreLog == $nbreMaxParUser) {
  4251.                         $tab['test'] = false;
  4252.                         $tab['pourcentage'] = 0;
  4253.                         return $tab;
  4254.                     } else {
  4255.                         $tab['test'] = true;
  4256.                         $tab['pourcentage'] = $promotion->getPourcentage();
  4257.                         $tab['remise'] = $this->caclRemiseInPanier($panier, $promotion->getStrategie(), $promotion->getNbreApplicable(), $promotion->getPourcentage());
  4258.                         return $tab;
  4259.                     }
  4260.                 } else {
  4261.                     $tab['test'] = false;
  4262.                     $tab['pourcentage'] = 0;
  4263.                     return $tab;
  4264.                 }
  4265.             } elseif ($type == "codeSejour") {
  4266.                 $sejour = $this->em->getRepository(Sejour::class)->find($idSejour);
  4267.                 $PromoSejour = $this->em->getRepository(PromoSejour::class)->findOneBy(array('promotion' => $promotion, 'sejour' => $sejour));
  4268.                 if ($PromoSejour) {
  4269.                     $tabLogPromo = $this->em->getRepository(LogPromotions::class)->findBy(array('idPromotion' => $promotion, 'idClient' => $idClient));
  4270.                     $nbreMaxParUser = $promotion->getNbreMaxParUser();
  4271.                     $nbreLog = sizeOf($tabLogPromo);
  4272.                     if ($nbreMaxParUser != 0 && $nbreLog == $nbreMaxParUser) {
  4273.                         $tab['test'] = false;
  4274.                         $tab['pourcentage'] = 0;
  4275.                         return $tab;
  4276.                     } else {
  4277.                         $tab['test'] = true;
  4278.                         $tab['pourcentage'] = $promotion->getPourcentage();
  4279.                         $tab['remise'] = $this->caclRemiseInPanier($panier, $promotion->getStrategie(), $promotion->getNbreApplicable(), $promotion->getPourcentage());
  4280.                         return $tab;
  4281.                     }
  4282.                 } else {
  4283.                     $tab['test'] = false;
  4284.                     $tab['pourcentage'] = 0;
  4285.                     return $tab;
  4286.                 }
  4287.             } else {
  4288.                 $tab['test'] = false;
  4289.                 $tab['pourcentage'] = 0;
  4290.                 return $tab;
  4291.             }
  4292.         } else {
  4294.             $tab['test'] = false;
  4295.             $tab['pourcentage'] = 0;
  4296.             return $tab;
  4297.         }
  4298.     }
  4300.     public function caclRemiseInPanier($panier, $strategie, $nbreApplique, $pourcentage)
  4301.     {
  4302.         $ttc = 0;
  4303.         $qte = 0;
  4304.         $tabPrices = array();
  4305.         $remise = 0;
  4306.         if ($nbreApplique == 1) {
  4307.             foreach ($panier as $item) {
  4308.                 $ttc += $item['mnt'] * $item['qte'];
  4309.             }
  4310.             $remise = ($ttc / 100) * $pourcentage;
  4311.         } else {
  4312.             foreach ($panier as $item) {
  4313.                 // $ttc += $item['mnt'] * $item['qte'];
  4314.                 for ($i = 0; $i <  $item['qte']; $i++) {
  4315.                     array_push($tabPrices, $item['mnt']);
  4316.                 }
  4317.                 $qte += $item['qte'];
  4318.             }
  4319.             //    dd($tabPrices);
  4320.             rsort($tabPrices);
  4322.             //    dd($tabPrices);
  4323.             $x = intval($qte / $nbreApplique);
  4324.             $tabPricesPromo =   array_slice($tabPrices, -$x, $x, true);
  4325.             //    $tabPricesSansPromo=   array_slice($tabPrices,0,sizeof($tabPrices)-$x,true);
  4326.             foreach ($tabPricesPromo as $p) {
  4327.                 $remise += ($p / 100) * $pourcentage;
  4328.             }
  4329.         }
  4332.         return $remise;
  4333.     }
  4336.     public function getInfoSejour($sejour)
  4337.     {
  4341.         //info sejour
  4342.         $infoSejour = array(
  4343.             'code_sejour' => $sejour->getCodeSejour(),
  4344.             'date_debut_sejour' => $sejour->getDateDebutSejour(),
  4345.             'date_fin_sejour' => $sejour->getDateFinSejour(),
  4346.             'theme_sejour' => $sejour->getThemSejour(),
  4347.             'nombre_enfants' => $sejour->getNbenfan()
  4348.         );
  4350.         $adresseSejour = array(
  4351.             'code_postale' => $sejour->getCodePostal(),
  4352.             'adresse' => $sejour->getAdresseSejour(),
  4353.             'ville' => $sejour->getVille(),
  4354.             'pays' => $sejour->getPays()
  4355.         );
  4358.         //info acco
  4359.         $accompagnateur = $this->em->getRepository(User::class)->find($sejour->getIdAcommp());
  4360.         $detailsAccompagnateur = array(
  4361.             'nom' => $accompagnateur->getNom(),
  4362.             'prenom' => $accompagnateur->getPrenom(),
  4363.             'email' => $accompagnateur->getEmail()
  4364.         );
  4368.         //info partenaire
  4369.         $partenaire = $this->em->getRepository(User::class)->find($sejour->getIdPartenaire());
  4371.         $detailsPartenaire = array(
  4372.             'nom' => $partenaire->getNom(),
  4373.             'prenom' => $partenaire->getPrenom(),
  4374.             'email' => $partenaire->getEmail()
  4375.         );
  4376.         //info etablissement
  4378.         $etablissement = $this->em->getRepository(Etablisment::class)->find($sejour->getIdEtablisment());
  4379.         $detailsEtablissement = array(
  4380.             'nom' => $etablissement->getNometab(),
  4381.             'type' => $etablissement->getTypeetablisment(),
  4382.             'codePostale' => $etablissement->getCodepostaleatb(),
  4383.             'adresse' => $etablissement->getAdresseetab(),
  4384.             'ville' => $etablissement->getVille(),
  4385.             'pays' => $etablissement->getPays(),
  4386.         );
  4389.         $nombrePhotos = $this->em->getRepository(SejourAttachment::class)->SearchNombrephotoonsejour($sejour->getId());
  4390.         $nombreAudio = $this->em->getRepository(SejourAttachment::class)->NombreMessageSejour($sejour->getId());
  4393.         $listeDescription = $this->em->getRepository(Jourdescripdate::class)->findBy(array('idsejour' => $sejour));
  4394.         $nombreDescriptions = sizeof($listeDescription);
  4398.         $detailsSejour = array(
  4399.             'info_sejour' => $infoSejour,
  4400.             'adresse_sejour' => $adresseSejour,
  4401.             'info_accompagnateur' => $detailsAccompagnateur,
  4402.             'info_partenaire' => $detailsPartenaire,
  4403.             'info_etablissement' => $detailsEtablissement,
  4404.             'nombrePhotos' => $nombrePhotos,
  4405.             'nombreAudio' => $nombreAudio,
  4406.             'nombreDescriptions' => $nombreDescriptions,
  4407.             'listeDescriptions' => $listeDescription
  4408.         );
  4410.         return  $detailsSejour;
  4411.     }
  4413.     /**
  4414.      * Service that generate a random list of photos
  4415.      * @author Firas Belhadj firasbelhadj686@gmail.com
  4416.      * @param array $listeFavorites The list of favorites
  4417.      * @param array $listAlbum The list of sejour photos
  4418.      * @param int $number The number of photos to generate
  4419.      * @param string $strategy The generation strategy (optional)
  4420.      * @return array $randomList
  4421.      */
  4422.     public function generateRandomAlbum(array $listeFavorites, array $listAlbum, int $number, string $strategy = 'FAVORITES_FIRST'): array
  4423.     {
  4424.         $randomList = [];
  4425.         $randFave = [];
  4426.         foreach ($listeFavorites as $key => $fav) {
  4427.             $randFave[$key]['id'] = $fav->getIdSejourAttchment()->getIdAttchment()->getId();
  4428.             $randFave[$key]['path'] = $fav->getIdSejourAttchment()->getIdAttchment()->getPath();
  4429.         }
  4431.         if ($strategy == 'FAVORITES_FIRST') {
  4432.             shuffle($listAlbum);
  4433.             if ($randFave) {
  4434.                 shuffle($randFave);
  4435.                 if (count($randFave) < $number) {
  4436.                     $remaining = $number - count($randFave);
  4437.                     $randomList = array_merge($randFave, array_slice($listAlbum, 0, $remaining));
  4438.                 } else {
  4439.                     $randomList = array_slice($randFave, 0, $number);
  4440.                 }
  4441.                 return $randomList;
  4442.             }
  4443.             $randomList = array_slice($listAlbum, 0, $number);
  4444.         }
  4446.         return $randomList;
  4447.     }
  4449.     function EnvoyerEmailRappelActivation($accompagnateur, $sejour)
  4450.     {
  4451.         try {
  4452.             return $this->emailsCmdService->sendMail(
  4453.                 $accompagnateur->getEmail(),
  4454.                 'Rappel : Activez votre séjour sur 5sur5sejour',
  4455.                 'rappel-activation-sejour',
  4456.                 [
  4457.                     'accompagnateur' => $accompagnateur,
  4458.                     'sejour' => $sejour,
  4459.                     'password' => $accompagnateur->getPasswordNonCripted(),
  4460.                     'image1' => 'https://res.cloudinary.com/apss-factory/image/upload/a_exif/v1582274063/qw7csxayektmq1leqjpp.png',
  4461.                     'iconfooter' => 'https://res.cloudinary.com/apss-factory/image/upload/v1582719651/Picto5sur5_rapbfy.png'
  4462.                 ],
  4463.                 [], // pas de pièces jointes
  4464.                 true // mettre en queue
  4465.             );
  4466.         } catch (\Exception $e) {
  4467.             return false;
  4468.         }
  4469.     }
  4471.   
  4472. }