src/Controller/FunctionController.php line 52

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  6. use Symfony\Component\HttpFoundation\Session\Session;
  7. use Symfony\Component\HttpFoundation\RequestStack;
  8. use mysqli;
  9. use App\Entity\Baskets;
  10. use App\Entity\Masterdata;
  11. use App\Form\BasketsType;
  12. use App\Form\CaptchaType;
  13. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  14. use Symfony\Component\HttpFoundation\Response;
  15. use Symfony\Component\Routing\Annotation\Route;
  16. use Symfony\Component\HttpFoundation\Request;
  17. use Gregwar\Captcha\CaptchaBuilder;
  18. use App\Service;
  20. class FunctionController extends AbstractController
  21. {
  22.     /**
  23.      * @Route("/function", name="function")
  24.      */
  25.     public function index(): Response
  26.     {
  27.         return $this->render('function/index.html.twig', [
  28.             'controller_name' => 'FunctionController',
  29.         ]);
  30.     }
  31.     
  32.     public function getHeader()
  33.     {   
  34.         $mysqli = new mysqli("localhost", "root", "", "netweddfront");
  35.         require_once($_SERVER['DOCUMENT_ROOT'] . '/Diocese/admin/sanitize.php');
  36.         $_SESSION['locale'] = 'fr_FR';
  37.         $language = (isset($_GET['language'])) ? sanitize_paranoid_string($mysqli,$_GET['language']) : $_SESSION['locale'];
  38.         $_SESSION['locale'] = $language; 
  39.         if (strpos($_SERVER["HTTP_USER_AGENT"], "Safari")
  40.             && !strpos($_SERVER["HTTP_USER_AGENT"], "Chrome")) {
  41.             if (count($_COOKIE) === 0) {
  42.                 echo "<script> 
  43.                 top.location = 'http://www.pourvotremariage.net/scripts/setSession.php';
  44.                 </script>";
  45.                 exit(); // need to be there in order not to load the rest of the page
  46.             }
  47.         }  
  48.         
  49.     }
  52.     public function getAllXML ()
  53.     {   
  54.         $xmls = array();
  55.         $url =$_SERVER["DOCUMENT_ROOT"] . '/baskets.xml';
  56.         $xml = simplexml_load_file($url, 'SimpleXMLElement');
  57.         // $url =$_SERVER["DOCUMENT_ROOT"] . '/Projetdiocese/public/baskets.xml';
  58.         // $xml = simplexml_load_file($url, 'SimpleXMLElement');
  59.         $url2 =$_SERVER["DOCUMENT_ROOT"] . '/Diocese/scripts/masterdata.xml';
  60.         $xml2 = simplexml_load_file($url2, 'SimpleXMLElement');
  61.         $url3 =$_SERVER["DOCUMENT_ROOT"] . '/Diocese/scripts/arbredecision.xml';
  62.         $xml3 = simplexml_load_file($url3, 'SimpleXMLElement');
  63.         $url4 =$_SERVER["DOCUMENT_ROOT"] . '/Diocese/scripts/arbredecisioncopy.xml';
  64.         $xml4 = simplexml_load_file($url4, 'SimpleXMLElement');
  65.         $xmls[] = $xml;
  66.         $xmls[] = $xml2;
  67.         $xmls[] = $xml3;
  68.         $xmls[] = $xml4;
  69.         return $xmls;
  70.     }
  72.     public function search_Basket($unXml,$unIdSession)
  73.     {   
  74.         $leslectures = array();
  75.         // Recherche du panier selon l'id session
  76.         foreach($unXml->baskets->Basket as $lePanier){
  77.             if($lePanier->phpsessid == $unIdSession){
  78.                 $leslectures[] = $lePanier->element;
  79.             }
  80.         }
  81.         return $leslectures;
  82.     }
  84.     public function searchOne($numType,$xmlmasterdata,$language,$code)
  85.     {   
  86.         $laLecture = array();
  87.         foreach($xmlmasterdata->masterdata->Ecrits as $lesEcrits)
  88.         {
  89.          if($lesEcrits->type == $numType && $lesEcrits->language == $language && $lesEcrits->code == $code){
  90.                 if (!in_array($lesEcrits,$laLecture)){
  91.                     $laLecture[] = $lesEcrits; 
  92.                 }
  93.             }
  94.         }
  95.         return $laLecture;
  96.     }
  98.     public function search_All_Readings($unXml,$uneLangue)
  99.     {   
  100.         $masterdata = array();
  101.         foreach($unXml->masterdata->Ecrits as $desEcrits){
  102.             if($desEcrits->type > 2000 and $desEcrits->type < 3000 and $desEcrits->language=$uneLangue){
  103.                 $masterdata[]=$desEcrits;
  104.             }
  105.         }
  106.         return $masterdata;
  107.     }
  109.     public function search_All_Prayers($unXml,$uneLangue)
  110.     {   
  111.         $masterdata = array();
  112.         foreach($unXml->masterdata->Ecrits as $desEcrits){
  113.             if($desEcrits->type > 3000 and $desEcrits->type < 4000 and $desEcrits->language=$uneLangue){
  114.                 $masterdata[]=$desEcrits;
  115.             }
  116.         }
  117.         return $masterdata;
  118.     }
  120.     public function getPartie($unXml)
  121.     {   
  122.         foreach ($unXml as $collection){
  123.             switch ($collection->type) {
  124.                 case 2100:
  125.                     $collection->typeStr = "PROPHETS";
  126.                     $collection->typeTrd = "Ancien Testament";
  127.                     break;
  128.                 case 2200:
  129.                     $collection->typeStr = "PSALM";
  130.                     $collection->typeTrd = "Psaumes";
  131.                     break;
  132.                 case 2300:
  133.                     $collection->typeStr = "APOSTLES";
  134.                     $collection->typeTrd = "Nouveau Testament";
  135.                     break;
  136.                 case 2500:
  137.                     $collection->typeStr = "GOSPEL";
  138.                     $collection->typeTrd = "Evangiles";
  139.                     break;  
  140.                 case 3100:
  141.                     $collection->typeStr = "CREED";
  142.                     $collection->typeTrd = "Profession de Foi";
  143.                     break;
  144.                 case 3200:
  145.                     $collection->typeStr = "DIALOGUE";
  146.                     $collection->typeTrd = "Dialogue initial";
  147.                     break;
  148.                 case 3310:
  149.                     $collection->typeStr = "VOWS";
  150.                     $collection->typeTrd = "Echange des consentements";
  151.                     break;
  152.                 case 3500:
  153.                     $collection->typeStr = "BLESSING";
  154.                     $collection->typeTrd = "Bénédiction nuptiale";
  155.                     break;  
  156.                 case 3700:
  157.                     $collection->typeStr = "INTERCESSIONS";
  158.                     $collection->typeTrd = "Prière universelle";
  159.                     break;
  160.             }
  161.             
  162.         }
  163.     }
  164.     public function msgChoixL($masterdata,$arbredecisioncopy)
  165.     {
  166.         $message = "";
  167.         $dossier = array(); 
  168.         foreach ($masterdata as $collection) {
  169.            $dossier[] = $collection->typeStr;
  170.         }
  171.         $typesPanier = array();
  172.         if(count($dossier)>0){
  173.             for ($i=0; $i < count($dossier); $i++) {    
  174.                 foreach ($arbredecisioncopy->Lecture->{$dossier[$i]} as $Choix) {
  175.                     $typesPanier[] = $Choix;
  176.                 }
  177.             }
  178.         }
  180.         $dom = dom_import_simplexml($arbredecisioncopy->Choix);
  181.         $countfc = 0;
  182.         $countcd = 0;
  183.             foreach ($dossier as $leslectures) {
  184.                 for ($i=0; $i < count($leslectures) ; $i++) { 
  185.                     if($arbredecisioncopy->Lecture->{$leslectures[$i]}->Contrainte == "Facultatif"){
  186.                         $countfc +=1;
  187.                     }
  188.                     if($arbredecisioncopy->Lecture->{$leslectures[$i]}->Contrainte == "Condition" && in_array(strval($arbredecisioncopy->Lecture->{$leslectures[$i]}->Contrainte->Condition),$dossier)){
  189.                         $countcd +=1;
  190.                     }
  191.                 }
  192.             }
  193.         // Vérifier les types de lecture en double
  194.         $doublons = array();
  195.         $double = 0;
  196.         for ($i=0; $i < count($dossier) ; $i++) { 
  197.             
  198.             if($i==count($dossier)-1){
  199.                 // var_dump($dossier[$i],$doublons);
  200.                 if(in_array(strval($dossier[$i]),$doublons)){
  201.                     $doublons[] = $dossier[$i];
  202.                     $double +=1;
  203.                 }
  204.             }
  205.             else {
  206.                 if(in_array($dossier[$i],$doublons)){
  207.                     $double +=1;
  208.                 }
  209.                 $doublons[] = $dossier[$i];
  210.             }
  211.         }
  214.         if (count($dossier)<4) {
  215.             // Vérifier les lectures facultatives
  216.             if(count($dossier)==3 && $countfc >=1 && $countcd == 0){
  217.                 if(!str_contains($message,$arbredecisioncopy->Complet3)){
  218.                     $message = $arbredecisioncopy->Complet3;
  219.                 }
  220.             }
  221.             elseif(count($dossier)==3 && $countfc <1 && $countcd >=1){
  222.                 if(!str_contains($message,$arbredecisioncopy->Complet3L)){
  223.                     $message = $arbredecisioncopy->Complet3L;
  224.                 }
  225.             }
  226.             elseif(count($dossier)==3 && $countfc <1 && $countcd <1){
  227.                 if(!str_contains($message,$arbredecisioncopy->Complet3)){
  228.                     $message = $arbredecisioncopy->Complet3;
  229.                 }
  230.             }
  231.             elseif(count($dossier)==3 && $countfc <1 && $countcd >=1){
  232.                 if(!str_contains($message,$arbredecisioncopy->Complet3)){
  233.                     $message = $arbredecisioncopy->Complet3;
  234.                 }
  235.             }
  236.             elseif(count($dossier)==3 && $countfc <1 && $countcd ==0){
  237.                 if(!str_contains($message,$arbredecisioncopy->Complet3)){
  238.                     $message = $arbredecisioncopy->Complet3;
  239.                 }
  240.             }
  241.             elseif(!str_contains($message,$dom->childNodes->item(0)->nodeName)){
  242.                 $message .= $dom->childNodes->item(0)->nodeValue;
  243.             }
  244.         }
  245.         // || count($dossier)==3 && $countfc <1 && $countcd <1
  246.         for ($i=1; $i < count($dom->childNodes) ; $i++) {
  247.             if(!in_array($dom->childNodes->item($i)->nodeName,$typesPanier)){
  248.                 // if(!(count($dossier)==3 && $countfc >=1 && $countcd == 0 )){
  249.                 //     $message .= $dom->childNodes->item($i)->nodeValue;
  250.                 // }
  251.                 $message .= $dom->childNodes->item($i)->nodeValue;
  252.             }
  253.             else{
  254.                 if (count($dossier)>4 || $double>=1) {
  255.                     if(!str_contains($message,$arbredecisioncopy->Surplus)){
  256.                         $message = $arbredecisioncopy->Surplus;
  257.                     }
  258.                 }
  259.                 elseif(count($dossier)==4){
  260.                     if(!str_contains($message,$arbredecisioncopy->Complet)){
  261.                         $message = $arbredecisioncopy->Complet;
  262.                     }
  263.                 }
  264.             }
  265.         }
  266.         return $message;
  267.     }
  269.     public function msgChoixP($masterdata,$arbredecisioncopy)
  270.     {
  271.         $message = "";
  272.         $dossier = array(); 
  273.         foreach ($masterdata as $collection) {
  274.            $dossier[] = $collection->typeStr;
  275.         }
  276.         $typesPanier = array();
  277.         
  278.         if(count($dossier)>0){
  279.             for ($i=0; $i < count($dossier); $i++) {    
  280.                 foreach ($arbredecisioncopy->Prière->{$dossier[$i]} as $Choix) {
  281.                     $typesPanier[] = $Choix;
  282.                 }
  283.             }
  284.         }
  285.         $dom = dom_import_simplexml($arbredecisioncopy->Choix2);
  286.             $countfc = 0;
  287.             foreach ($dossier as $lesPrières) {
  288.                 for ($i=0; $i < count($lesPrières) ; $i++) { 
  289.                     if($arbredecisioncopy->Prière->{$lesPrières[$i]}->Contrainte == "Facultatif"){
  290.                         $countfc +=1;
  291.                     }
  292.                 }
  293.             }
  294.             if (count($dossier)<5) {
  295.             if(!str_contains($message,$dom->childNodes->item(0)->nodeName)){
  296.                 $message .= $dom->childNodes->item(0)->nodeValue;
  297.             }
  298.             }
  299.             for ($i=1; $i < count($dom->childNodes) ; $i++) { 
  300.             if(!in_array($dom->childNodes->item($i)->nodeName,$typesPanier)){
  301.                     $message .= $dom->childNodes->item($i)->nodeValue;
  302.                     
  303.             }
  304.             else{
  305.                 if(count($dossier)==5){
  306.                     if(!str_contains($message,$arbredecisioncopy->CompletP)){
  307.                         $message = $arbredecisioncopy->CompletP;
  308.                     }
  309.                 }
  310.                 elseif (count($dossier)>=5) {
  311.                     if(!str_contains($message,$arbredecisioncopy->SurplusP)){
  312.                         $message = $arbredecisioncopy->SurplusP;
  313.                     }
  314.                 }
  315.             }
  316.          }
  317.          return $message;
  318.     }
  320.     public function create_Basket($sessId,$xmlmasterdata,$xmlbaskets,$code)
  321.     {
  322.         $id = 0;
  323.         $basket = new Baskets();
  324.         $basket-> setPhpsessid($sessId);
  325.         foreach($xmlmasterdata->masterdata->Ecrits as $lesEcrits){
  326.             if($lesEcrits->code == $code){
  327.                 $id = $lesEcrits->id;
  328.                 break;
  329.             }
  330.         }
  331.         // Récupérer le type d'Ecrit
  332.         $typeEcrit = 0;
  333.         foreach($xmlmasterdata->masterdata->Ecrits as $lesEcrits){
  334.           if($lesEcrits->code == $code){
  335.               $typeEcrit = $lesEcrits->type;
  336.               break;
  337.           }
  338.         }
  339.         
  340.         $basket->setElement(intval($id));
  341.         $basket->setCreated(date_create("now"));
  342.         
  343.         $newbasket = $xmlbaskets->baskets->addChild('Basket');
  344.         $newbasket->addChild("phpsessid",strval($basket->getPhpsessid()));
  345.         $newbasket->addChild("element",strval($basket->getElement()));
  346.         $newbasket->addChild("created",date_format($basket->getCreated(), 'Y-m-d H:i:s'));
  347.         $xmlbaskets->saveXML('baskets.xml');
  348.         return $typeEcrit;
  349.     }
  351.     public function delete_Basket($sessId,$xmlmasterdata,$xmlbaskets,$code)
  352.     {
  353.         $id = 0;
  354.         $basket = new Baskets();
  355.         $basket-> setPhpsessid($sessId);
  356.         foreach($xmlmasterdata->masterdata->Ecrits as $lesEcrits){
  357.             if($lesEcrits->code == $code){
  358.                 $id = $lesEcrits->id;
  359.                 break;
  360.             }
  361.         }
  362.         // Récupérer le type d'Ecrit
  363.         $typeEcrit = 0;
  364.         foreach($xmlmasterdata->masterdata->Ecrits as $lesEcrits){
  365.           if($lesEcrits->code == $code){
  366.               $typeEcrit = $lesEcrits->type;
  367.               break;
  368.           }
  369.         }
  370.         
  371.         // Supprime le panier
  372.         foreach($xmlbaskets->baskets->Basket as $lePanier){
  373.             if($lePanier->phpsessid == $sessId && $lePanier->element == intval($id)){
  374.                 $dom = dom_import_simplexml($lePanier);
  375.                 $dom->parentNode->removeChild($dom);
  376.                 $xmlbaskets->saveXML('baskets.xml');
  377.             }
  378.           }
  379.         return $typeEcrit;
  380.     }
  381.     
  382.     public function searchByType($numType,$xmlmasterdata,$language,$code)
  383.     {   
  384.         $leslectures = array();
  385.         foreach($xmlmasterdata->masterdata->Ecrits as $lesEcrits)
  386.         {
  387.          if($lesEcrits->type == $numType && $lesEcrits->language == $language){
  388.                 if (!in_array($lesEcrits,$leslectures)){
  389.                     $leslectures[] = $lesEcrits; 
  390.                 }
  391.             }
  392.         }
  393.         return $leslectures;
  394.     }
  396.     public function createBooklet($opening,$masterdata,$masterdata2)
  397.     {
  398.         $texte ="";
  399.         foreach ($masterdata as $lesEcrits) {
  400.             $texte .= "<strong>$lesEcrits->name</strong>";
  401.             $texte .= "<br>";
  402.             $texte .= "Lectures du ";
  403.             $texte .= $lesEcrits->book;
  404.             $texte .= "<br>";
  405.             $texte .= $lesEcrits->chapters;
  406.             $texte .= "<br>";
  407.             $texte .= $lesEcrits->print;
  408.         }
  410.         foreach ($masterdata2 as $lesEcrits) {
  411.             $texte .= "<strong>$lesEcrits->name</strong>";
  412.             $texte .= "<br>";
  413.             $texte .= $lesEcrits->book;
  414.             $texte .= "<br>";
  415.             $texte .= $lesEcrits->screen;
  416.         }
  418.         $phpWord = new \PhpOffice\PhpWord\PhpWord();
  419.         $section = $phpWord->addSection();
  420.         $section->addText( 
  421.             $opening . $texte
  422.        );
  423.         $objWriter = \PhpOffice\PhpWord\IOFactory::createWriter($phpWord, 'HTML');
  424.         $date = date_create("now");
  425.         $date = date_format($date, 'Ymd-His');
  426.         $objWriter->save("$date.doc");
  427.     chmod("$date.doc",0755);
  428.         return "$date.doc";
  430.     }
  431. }