src/Controller/CompanyController.php line 645

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Swift_Mailer;
  6. use Swift_Message;
  8. use App\Entity\ProductClick;
  9. use Sensio\Bundle\FrameworkExtraBundle\Configuration\IsGranted;
  10. use App\Entity\Subcategory;
  11. use App\Service\FileUploader;
  12. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  13. use App\Service\RegisteredToNewsletterChecker;
  14. use Doctrine\ORM\EntityManagerInterface;
  15. use PhpOffice\PhpSpreadsheet\IOFactory;
  16. use Symfony\Component\Security\Core\Security;
  17. use Symfony\Bridge\Twig\Mime\TemplatedEmail;
  18. use Symfony\Component\Form\Extension\Core\Type\ChoiceType;
  19. use Symfony\Component\Form\Extension\Core\Type\EmailType;
  20. use Symfony\Component\Form\Extension\Core\Type\FileType;
  21. use Symfony\Component\Form\Extension\Core\Type\NumberType;
  22. use Symfony\Component\Form\Extension\Core\Type\PasswordType;
  23. use Symfony\Component\Form\Extension\Core\Type\SubmitType;
  24. use App\Entity\CompanyFav;
  25. use App\Entity\CompanyFavoris;
  26. use App\Entity\ProductFav;
  27. use App\Entity\Visite;
  28. use App\Entity\Product;
  30. use App\Repository\CompanyFavorisRepository;
  31. use App\Repository\VisiteRepository;
  32. use Doctrine\Common\Collections\ArrayCollection;
  33. use Symfony\Component\Form\Extension\Core\Type\TextareaType;
  34. use Symfony\Component\Form\Extension\Core\Type\TextType;
  35. use phpDocumentor\Reflection\Types\Integer;
  36. use phpDocumentor\Reflection\Types\String_;
  37. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  38. use Symfony\Component\HttpFoundation\File\File;
  39. use Symfony\Component\HttpFoundation\Response;
  41. use Symfony\Component\Mime\Address;
  42. use Symfony\Component\Routing\Annotation\Route;
  43. use App\Entity\Company;
  44. use App\Repository\CompanyRepository;
  45. use App\Entity\Category;
  46. use App\Entity\Marchandise;
  47. use App\Entity\NewsLetterUser;
  48. use App\Form\CompanyType;
  49. use Symfony\Bundle\FrameworkBundle\Controller;
  50. use Sensio\Bundle\FrameworkExtraBundle\Configuration;
  51. use Symfony\Component\HttpFoundation\Request;
  52. use Symfony\Component\Form\FormTypeInterface;
  53. use Cocur\Slugify\Slugify;
  54. use Symfony\Component\HttpFoundation\Session\Session;
  55. use Symfony\Component\Routing\RouterInterface;
  56. use Symfony\Component\Security\Core\Encoder\UserPasswordEncoderInterface;
  57. use Symfony\Component\Serializer\SerializerInterface;
  58. use Symfony\Component\Validator\Validator\ValidatorInterface;
  59. use Symfony\Component\HttpFoundation\JsonResponse;
  60. use App\Service\TraduireContenu;
  61. use App\Repository\CategoryRepository;
  62. use App\Repository\UserRepository;
  63. use Symfony\Component\Mime\Email;
  65. use Symfony\Component\Mailer\MailerInterface;
  67. use Symfony\Component\Form\FormError;
  68. use Symfony\Contracts\HttpClient\HttpClientInterface;
  69. use App\Form\DesactivateCompanyType;
  70. use App\Repository\SubcategoryRepository;
  71. use App\Service\CryptService;
  72. use Symfony\Component\Serializer\Encoder\JsonEncoder;
  73. use Symfony\Component\Serializer\Encoder\XmlEncoder;
  74. use Symfony\Component\Serializer\Normalizer\ObjectNormalizer;
  75. use Symfony\Component\Serializer\Serializer;
  76. use App\Entity\GetUser;
  77. use App\Entity\User;
  78. use App\Service\CallApiService;
  80. // use Doctrine\ORM\EntityManagerInterface as EntityManager;
  82. class CompanyController extends AbstractController
  83. {
  84.     private $em;
  85.     private $traduireContenu;
  86.     private $client;
  88.     public function __construct(EntityManagerInterface $em, TraduireContenu $traduireContenu, HttpClientInterface $client)
  89.     {
  91.         $this->client = $client;
  92.         $this->em = $em;
  93.         $this->traduireContenu = $traduireContenu;
  94.     }
  98.     /**
  99.      * @Route("/redirectRegister/", name="redirect_inscription")
  100.      */
  101.     public function setGaeaUserId(Request $request, SerializerInterface $serializer, CategoryRepository $catrep, FileUploader $fileUploader)
  102.     {
  103.         $em = $this->getDoctrine()->getManager();
  104.         //$contenu = $request->getContent();
  105.         $contenu = $request->request->get('objArr');
  107.         $contenuDecode = json_decode($contenu, true);
  108.         //dump($contenuDecode);
  109.         //$company = $serializer->deserialize($contenu, Company::class, 'json');
  110.         $categories_name = $contenuDecode['categories'];
  111.         //dump($categories_name);
  112.         //$categories_name = $request->request->get('objArr')['categories'];
  113.         $categories = new ArrayCollection();
  114.         foreach ($categories_name as $category_name) {
  115.             $categories[] = $catrep->findOneBy(['name' => $category_name]);
  116.         }
  118.         //dump ($categories);
  120.         $gaeauserid = $contenuDecode['gaeaUserId'];
  121.         $username = $contenuDecode['username'];
  122.         $rue = $contenuDecode['street'];
  123.         $name = $contenuDecode['name'];
  124.         $username = $contenuDecode['username'];
  125.         $ville = $contenuDecode['city'];
  126.         $raisonsociale = $contenuDecode['socialreason'];
  127.         $codepostale = $contenuDecode['postcode'];
  128.         $canton = $contenuDecode['region'];
  129.         $pays = $contenuDecode['country'];
  130.         $latitude = $contenuDecode['latitude'];
  131.         $longitude = $contenuDecode['longtitude'];
  132.         $tel = $contenuDecode['phone'];
  133.         $site = $contenuDecode['urlwebsite'];
  134.         $linkedin = $contenuDecode['urllinkedin'];
  135.         $facebook = $contenuDecode['urlfacebook'];
  136.         $twitter = $contenuDecode['urltwitter'];
  137.         $débutactivité = $contenuDecode['startingdate'];
  138.         $certif = $contenuDecode['certification'];
  139.         $vision = $contenuDecode['vision'];
  140.         $zoneinfluence = $contenuDecode['influencezone'];
  141.         $descritpion = $contenuDecode['description'];
  142.         $evaluation = $contenuDecode['wantevaluation'];
  143.         $niveau = $contenuDecode['niveau'];
  144.         $file = $request->files->get('file');
  145.         // dump($request);
  146.         // dump($request->files);
  147.         $nom = $contenuDecode['nom'];
  148.         $prenom = $contenuDecode['prenom'];
  149.         $image = $contenuDecode['image'];
  151.         $Setcompany = new Company();
  153.         if (!is_null($file)) {
  155.             $path = $this->getParameter('companies');
  156.             // dump($path);
  157.             $filename = $fileUploader->upload($file, $path);
  158.             // dump($file);
  159.             // dump($filename);
  160.             $Setcompany->setImage($filename);
  161.         }
  163.         $Setcompany->setName($name);
  164.         $Setcompany->setStreet($rue);
  165.         $Setcompany->setCity($ville);
  166.         $Setcompany->setsocialreason($raisonsociale);
  167.         $Setcompany->setPostcode($codepostale);
  168.         $Setcompany->setRegion($canton);
  169.         $Setcompany->setCountry($pays);
  170.         $Setcompany->setPhone($tel);
  171.         $Setcompany->setUrlwebsite($site);
  172.         $Setcompany->setUrllinkedin($linkedin);
  173.         $Setcompany->setUrlfacebook($facebook);
  174.         $Setcompany->setUrltwitter($twitter);
  175.         //$Setcompany->setstartingdate(new \DateTime($débutactivité));
  176.         $Setcompany->setstartingdate($débutactivité);
  177.         $Setcompany->setCertification($certif);
  178.         $Setcompany->setLastname($nom);
  179.         $Setcompany->setFirstname($prenom);
  180.         //$Setcompany->setImage($image);
  183.         foreach ($categories as $cat) {
  184.             $Setcompany->addCategory($cat);
  185.         }
  187.         $Setcompany->setVision($vision);
  188.         $Setcompany->setInfluencezone($zoneinfluence);
  189.         $Setcompany->setDescription($descritpion);
  190.         $Setcompany->setWantevaluation($evaluation);
  191.         $Setcompany->setLatitude($latitude);
  192.         $Setcompany->setLongtitude($longitude);
  195.         $Setcompany->setgaeaUserId($gaeauserid);
  197.         $Setcompany->setUsername($username);
  199.         $Setcompany->setRole('ROLE_COMPANY');
  200.         $slugify = new Slugify();
  201.         $slug = $slugify->slugify($name);
  202.         $Setcompany->setSlug($slug);
  203.         $Setcompany->setActivated(true);
  204.         $Setcompany->setActived(true);
  205.         $Setcompany->setEmailValidated(false);
  206.         $token = bin2hex(random_bytes(21));
  207.         $Setcompany->setToken($token);
  208.         $Setcompany->setInscriptiondate(new \DateTime());
  209.         $Setcompany->setNiveau($niveau);
  210.         $em = $this->getDoctrine()->getManager();
  211.         $em->persist($Setcompany);
  214.         //enregistrement a la newsletter
  215.         if ($contenuDecode['newsletter']) {
  217.             $existingNewsletterUser = $em->getRepository(NewsLetterUser::class)->findOneBy(['mail' => $contenuDecode['mail']]);
  218.             if ($existingNewsletterUser) {
  219.                 $em->remove($existingNewsletterUser);
  220.                 //$existingNewsletterUser->setUserId($Setcompany);
  221.             }
  222.             $newsletterUser = new NewsLetterUser();
  223.             // dump($Setcompany);
  224.             $newsletterUser->setUserId($Setcompany);
  225.             $newsletterUser->setNom($nom);
  226.             $newsletterUser->setPrenom($prenom);
  227.             $newsletterUser->setCodePostal($codepostale);
  228.             $newsletterUser->setVille($ville);
  229.             $newsletterUser->setMail($contenuDecode['mail']);
  232.             $em->persist($newsletterUser);
  233.         }
  235.         $em->flush();
  237.         return $this->json(['status' => 200, 'message' => "Ok"]);
  238.     }
  240.     /**
  241.      * @Route("/newsletter/inscription", name="newsletter_inscription", methods={"POST"})
  242.      */
  243.     public function inscriptionNewsletter(Request $request, MailerInterface $mailer, SessionInterface $session, EntityManagerInterface $entityManager)
  244.     {
  246.         $userEmail = $session->get('email');
  248.         $username = $session->get('username');
  249.         //$userVille = $session->get('ville');
  250.         /* $userPrenom = $session->get('prenom');
  251.         
  252.         $userCodePostal = $session->get('code_postal');*/
  255.         if (empty($userEmail)) {
  256.             return new JsonResponse(['status' => 'error', 'message' => 'Les données nécessaires n\'ont pas été trouvées dans la session']);
  257.         }
  258.         $existingUser = $entityManager->getRepository(NewsLetterUser::class)->findOneBy(['mail' => $userEmail]);
  259.         if ($existingUser) {
  260.             return new JsonResponse(['status' => 'success']);
  261.         }
  263.         $newsLetterUser = new NewsLetterUser();
  264.         $newsLetterUser->setMail($userEmail);
  265.         $newsLetterUser->setNom($username);
  266.         //$newsLetterUser->setVille($userVille);
  267.         /* $newsLetterUser->setPrenom($userPrenom);
  268.         
  269.        
  270.         $newsLetterUser->setCodePostal($userCodePostal);*/
  273.         try {
  274.             $entityManager->persist($newsLetterUser);
  275.             $entityManager->flush();
  276.         } catch (\Exception $e) {
  277.             return new JsonResponse(['status' => 'error', 'message' => 'Une erreur s\'est produite lors de la sauvegarde des données: ' . $e->getMessage()]);
  278.         }
  280.         // Envoyer l'e-mail de confirmation
  281.         $email = (new Email())
  282.             ->from('contact@sustlivprogram.org')
  283.             ->to($userEmail)
  284.             ->subject('Inscription à la Newsletter')
  285.             ->text('Vous êtes bien inscrit à la newsletter.');
  287.         try {
  288.             $mailer->send($email);
  289.         } catch (\Exception $e) {
  290.             return new JsonResponse(['status' => 'error', 'message' => 'Une erreur s\'est produite lors de l\'inscription à la newsletter: ' . $e->getMessage()]);
  291.         }
  293.         return new JsonResponse(['status' => 'success']);
  294.     }
  295.     /**
  296.      * @Route("/newsletter/desinscription", name="newsletter_desinscription", methods={"POST"})
  297.      */
  298.     public function desinscriptionNewsletter(Request $request, EntityManagerInterface $entityManager)
  299.     {
  300.         $userEmail = $request->getSession()->get('email');
  302.         if (empty($userEmail)) {
  303.             return new JsonResponse(['status' => 'error', 'message' => 'Les données nécessaires n\'ont pas été trouvées dans la session']);
  304.         }
  306.         $existingUser = $entityManager->getRepository(NewsLetterUser::class)->findOneBy(['mail' => $userEmail]);
  308.         if (!$existingUser) {
  309.             return new JsonResponse(['status' => 'success']);
  310.         }
  313.         try {
  314.             $entityManager->remove($existingUser);
  315.             $entityManager->flush();
  316.         } catch (\Exception $e) {
  317.             return new JsonResponse(['status' => 'error', 'message' => 'Une erreur s\'est produite lors de la désinscription: ' . $e->getMessage()]);
  318.         }
  320.         return new JsonResponse(['status' => 'success']);
  321.     }
  324.     /**
  325.      * @Route("/newsletter/check-subscription", name="newsletter_check_subscription", methods={"GET"})
  326.      */
  327.     public function checkSubscription(Request $request, EntityManagerInterface $entityManager)
  328.     {
  329.         $userEmail = $request->getSession()->get('email');
  331.         if (empty($userEmail)) {
  332.             return new JsonResponse(['status' => 'error', 'message' => 'Les données nécessaires n\'ont pas été trouvées dans la session']);
  333.         }
  335.         $existingUser = $entityManager->getRepository(NewsLetterUser::class)->findOneBy(['mail' => $userEmail]);
  337.         if ($existingUser) {
  338.             return new JsonResponse(['status' => 'subscribed']);
  339.         }
  340.         return new JsonResponse(['status' => 'not_subscribed']);
  341.     }
  345.     public function getAllCategories($langue)
  346.     {
  347.         //récupération de toutes les catégories en francais
  349.         $categories = $this->getDoctrine()->getRepository(Category::class)->findBy(["unicity" => 1]);
  350.         $tabtraduit = [];
  351.         foreach ($categories as $category) {
  352.             $trad = $category;
  353.             if ($langue != "fr") {
  354.                 $trad = $this->traduireContenu->retourTrad($category, $langue);
  355.             }
  356.             array_push($tabtraduit, $trad);
  357.         }
  358.         //dd($tabtraduit);
  359.         return $tabtraduit;
  360.     }
  362.     /**
  363.      * @Route("/{_locale<en|fr|de|it|es>}/deactivateAccount/", name="deactivate_account")
  364.      */
  365.     public function deactivateAccount()
  366.     {
  368.         $Setcompany = $this->getUser();
  370.         //$Setcompany->actived = false;
  372.         $em = $this->getDoctrine()->getManager();
  373.         $em->flush();
  374.         return $this->json(['status' => 200, 'message' => "Ok"]);
  375.     }
  378.     /**
  379.      * @Route("/{_locale<en|fr|de|it|es>}/redirectModify/", name="redirect_modification")
  380.      */
  381.     public function modifgaeauser(Request $request, CategoryRepository $catrep, FileUploader $fileUploader)
  382.     {
  383.         //$contenu = $request->getContent();
  384.         $contenu = $request->request->get('objArr');
  385.         $contenuDecode = json_decode($contenu, true);
  386.         //$company = $serializer->deserialize($contenu, Company::class, 'json');
  388.         /*$categories_name = $contenuDecode['categories'];
  390.         $categories = new ArrayCollection();
  391.         foreach($categories_name as $category_name){
  392.             $categories[] = $catrep->findOneBy(['name'=>$category_name]);
  393.         }*/
  394.         $rue = $contenuDecode['street'];
  395.         $name = $contenuDecode['name'];
  396.         $ville = $contenuDecode['city'];
  397.         $raisonsociale = $contenuDecode['socialreason'];
  398.         $codepostale = $contenuDecode['postcode'];
  399.         $canton = $contenuDecode['departement'];
  400.         $pays = $contenuDecode['country'];
  401.         $tel = $contenuDecode['phone'];
  402.         $site = $contenuDecode['urlwebsite'];
  403.         $linkedin = $contenuDecode['urllinkedin'];
  404.         $facebook = $contenuDecode['urlfacebook'];
  405.         $twitter = $contenuDecode['urltwitter'];
  406.         $débutactivité = $contenuDecode['startingdate'];
  407.         $certif = $contenuDecode['certification'];
  408.         $vision = $contenuDecode['vision'];
  409.         $zoneinfluence = $contenuDecode['influencezone'];
  410.         $descritpion = $contenuDecode['description'];
  411.         $evaluation = $contenuDecode['wantevaluation'];
  412.         $latitude = $contenuDecode['latitude'];
  413.         $longitude = $contenuDecode['longtitude'];
  414.         $niveau = $contenuDecode['niveau'];
  415.         $lastname = $contenuDecode['nom'];
  416.         $firstname = $contenuDecode['prenom'];
  417.         $file = $request->files->get('file');
  419.         $Setcompany = $this->getUser();
  420.         /*$currentCategories = $Setcompany->getCategories();
  421.         foreach($currentCategories as $cat){
  422.             $Setcompany -> removeCategory($cat);
  423.         }*/
  425.         if (!is_null($file)) {
  426.             $path = $this->getParameter('companies');
  427.             $filename = $fileUploader->upload($file, $path);
  428.             $Setcompany->setImage($filename);
  429.         }
  432.         $Setcompany->setName($name);
  433.         $Setcompany->setStreet($rue);
  434.         $Setcompany->setCity($ville);
  435.         $Setcompany->setsocialreason($raisonsociale);
  436.         $Setcompany->setPostcode(intval($codepostale));
  437.         $Setcompany->setRegion($canton);
  438.         $Setcompany->setCountry($pays);
  439.         $Setcompany->setPhone($tel);
  440.         $Setcompany->setUrlwebsite($site);
  441.         $Setcompany->setUrllinkedin($linkedin);
  442.         $Setcompany->setUrlfacebook($facebook);
  443.         $Setcompany->setUrltwitter($twitter);
  444.         $Setcompany->setstartingdate(new \DateTime($débutactivité));
  445.         $Setcompany->setCertification($certif);
  446.         $Setcompany->setLatitude($latitude);
  447.         $Setcompany->setLongtitude($longitude);
  448.         $Setcompany->setVision($vision);
  449.         $Setcompany->setInfluencezone($zoneinfluence);
  450.         $Setcompany->setDescription($descritpion);
  451.         $Setcompany->setWantevaluation($evaluation);
  452.         $Setcompany->setNiveau($niveau);
  453.         $Setcompany->setLastName($lastname);
  454.         $Setcompany->setFirstName($firstname);
  455.         /*foreach($categories as $cat){
  456.             $Setcompany -> addCategory($cat);
  457.         }*/
  459.         $em = $this->getDoctrine()->getManager();
  460.         $em->flush();
  461.         return $this->json(['status' => 200, 'message' => "Ok"]);
  462.     }
  464.     /**
  465.      * @Route("/{_locale<en|fr|de|it|es>}/redirectModifyCategories/", name="redirect_modification_cat")
  466.      */
  467.     public function modifcategories(Request $request, CategoryRepository $catrep)
  468.     {
  470.         //$contenu = $request->request->get('objArr');
  471.         $contenu = $request->getContent();
  472.         $contenuDecode = json_decode($contenu, true);
  474.         $categories_name = $contenuDecode['categories'];
  475.         $categories = new ArrayCollection();
  476.         foreach ($categories_name as $category_name) {
  477.             $categories[] = $catrep->findOneBy(['name' => $category_name]);
  478.         }
  480.         $Setcompany = $this->getUser();
  481.         $currentCategories = $Setcompany->getCategories();
  482.         foreach ($currentCategories as $cat) {
  483.             $Setcompany->removeCategory($cat);
  484.         }
  486.         foreach ($categories as $cat) {
  487.             $Setcompany->addCategory($cat);
  488.         }
  490.         $em = $this->getDoctrine()->getManager();
  491.         $em->flush();
  492.         //return $this->redirectToRoute('companyProfileShow');
  493.         //return $this->redirect($this->generateUrl('companyProfileShow'));
  494.         return $this->json(['status' => 200, 'message' => "Ok"]);
  495.         /*$company = $this->getUser();
  496.         $categories = $this->em->getRepository(Category::class)->findAll();
  497.         return $this->render('company/profile.html.twig', [
  498.             'company' => $company,
  499.             'categories' => $categories,
  500.         ]);*/
  501.     }
  504.     public function findCatByName($name)
  505.     {
  506.         $em = $this->getDoctrine()->getManager();
  507.         $category = $em
  508.             ->getRepository(Category::class)
  509.             ->findBy(['name' => $name]);
  510.         return ($category);
  511.     }
  513.     /**
  514.      *
  515.      * Require ROLE_ADMIN for all the actions of this controller
  516.      *
  517.      * @isGranted("PUBLIC_ACCESS")
  518.      *
  519.      * @Route("/{_locale<fr|en|de|it|es>}/inscription-entreprise", name="companyRegister")
  520.      */
  521.     public function registerAction(Request $request)
  522.     {
  524.         //$this->denyAccessUnlessGranted('ROLE_ADMIN');
  525.         //$hasAccess = $this->isGranted('ROLE_ADMIN');
  528.         $session = $request->getSession();
  529.         $langue = $session->get("_locale");
  530.         $categories = $this->getAllCategories($langue);
  531.         foreach ($categories as $category) {
  532.             foreach ($category->getSubcategories() as $subcat) {
  533.                 $category->addSubcategory($subcat);
  534.             }
  535.         }
  537.         $intYear = idate("Y");
  540.         //return $this->render('company/register_OLD.html.twig', [
  541.         return $this->render('company/register.html.twig', [
  542.             'categories' => $categories,
  543.             'currentYear' => $intYear
  544.         ]);
  545.     }
  549.     // /**
  550.     //  * @Route("/{_locale<en|fr|de|it|es>}/inscription-entreprise-2/", name="companyRegister2")
  551.     //  */
  552.     // public function registerAction2(Request $request)
  553.     // {
  554.     //     //Extract from the request : id, email, username
  555.     //     if($request !== null){
  556.     //         $contenu = $request->getContent();
  557.     //         $userrv = explode("&",$contenu);
  558.     //         $gaeaid = substr($userrv[0],3);
  559.     //         $id = intval($gaeaid);
  561.     //     $email = str_replace("%40","@",substr($userrv[1],6));
  562.     //     $username = str_replace("%40","@",substr($userrv[2],9));
  563.     // }
  565.     //     $categories = $this->em->getRepository(Category::class)->findAll();
  567.     // foreach($categories as $category)
  568.     // {
  569.     //     foreach ($category->getSubcategories() as $subcat)
  570.     //     {
  571.     //         $category->addSubcategory($subcat);
  572.     //     }
  573.     // }
  575.     //     $intYear = idate("Y");
  579.     //     return $this->render('company/register-2.html.twig',[
  580.     //         'categories'=>$categories,
  581.     //         'currentYear' => $intYear,
  582.     //         'gaeaId' => $id,
  583.     //         'email' => $email,
  584.     //         'username' => $username,
  585.     //     ]);
  586.     // }
  591.     //  /**
  592.     //  * @Route("/inscription-entreprise-2", name="companyRegister2")
  593.     //  */
  594.     //  public function registerAction2(Request $request)
  595.     //  {
  596.     //      $categories = $this->em->getRepository(Category::class)->findAll();
  598.     //      foreach($categories as $category)
  599.     //      {
  601.     //          foreach ($category->getSubcategories() as $subcat)
  602.     //          {
  604.     //              $category->addSubcategory($subcat);
  605.     //          }
  606.     //      }
  608.     //      $intYear = idate("Y");
  612.     //      return $this->render('company/register-2.html.twig',[
  613.     //          'categories'=>$categories,
  614.     //          'currentYear' => $intYear,
  615.     //          'hhh'=>null
  617.     //      ]);
  618.     //  }
  624.     /**
  625.      * @Route("/checklogin", name="checklogin")
  626.      */
  627.     public function checklogin()
  628.     {
  629.         $loggedIn = $this->isGranted('IS_AUTHENTICATED_FULLY');
  630.         return $this->json(['loggedIn' => $loggedIn]);
  631.     }
  634.     /**
  635.      * @Route("/entreprise/{slug}", name="companyShow")
  636.      */
  637.     public function show($slug)
  638.     {
  642.         $em = $this->getDoctrine()->getManager();
  643.         $company = $em->getRepository(Company::class)->findOneBy(['slug' => $slug]);
  644.         $date = (new \DateTime());
  645.         $visit = $em->getRepository(Visite::class)->findOneBy(array('companySlug' => $slug, 'date' => $date));
  648.         if ($visit == null) :
  649.             $visite = new Visite();
  651.             $visite->setDate($date);
  652.             $visite->setCompanySlug($slug);
  653.             $visite->setNumber(1);
  654.             $em->persist($visite);
  655.             $em->flush();
  656.         else :
  658.             $visit->setNumber($visit->getNumber() + 1);
  659.             $em->persist($visit);
  660.             $em->flush();
  662.         endif;
  663.         $products = $em->getRepository(Product::class)->findBy(array('company' => $company));
  665.         if ($this->isGranted('IS_AUTHENTICATED_FULLY')) {
  666.             $em = $this->getDoctrine()->getManager();
  667.             $company = $em->getRepository(Company::class)->findOneBy(array('slug' => $slug));
  668.             $user = $this->getUser();
  669.             $companyFav = $em->getRepository(CompanyFav::class)->findOneBy(array('user' => $user, 'company' => $company));
  671.             if ($companyFav == null) {
  672.                 $n = 0;
  673.             } else {
  674.                 $n = 1;
  675.             }
  676.         } else {
  677.             $n = 3;
  678.         }
  684.         return $this->render('company/entreprise.html.twig', [
  686.             'company' => $company,
  687.             'visit' => $visit,
  688.             'products' => $products,
  689.             'n' => $n
  691.         ]);
  692.     }
  696.     /**
  697.      * @Route("/product2/{id}", name="companyShowFromId")
  698.      */
  699.     public function showFromId($id)
  700.     {
  701.         $em = $this->getDoctrine()->getManager();
  702.         $company = $em->getRepository(Company::class)->findOneBy(['id' => $id]);
  703.         $em = $this->getDoctrine()->getManager();
  704.         $date = (new \DateTime());
  705.         $visit = $em->getRepository(Visite::class)->findOneBy(array('companySlug' => $company->getSlug(), 'date' => $date));
  708.         if ($visit == null) :
  709.             $visite = new Visite();
  711.             $visite->setDate($date);
  712.             $visite->setCompanySlug($company->getSlug());
  713.             $visite->setNumber(1);
  714.             $em->persist($visite);
  715.             $em->flush();
  716.         else :
  718.             $visit->setNumber($visit->getNumber() + 1);
  719.             $em->persist($visit);
  720.             $em->flush();
  722.         endif;
  723.         $products = $em->getRepository(Product::class)->findBy(array('company' => $company));
  725.         if ($this->isGranted('IS_AUTHENTICATED_FULLY')) {
  726.             $em = $this->getDoctrine()->getManager();
  727.             $company = $em->getRepository(Company::class)->findOneBy(array('slug' => $company->getSlug()));
  728.             $user = $this->getUser();
  729.             $companyFav = $em->getRepository(CompanyFav::class)->findOneBy(array('user' => $user, 'company' => $company));
  732.             if ($companyFav == null) {
  733.                 $n = 0;
  734.             } else {
  735.                 $n = 1;
  736.             }
  737.         } else {
  738.             $n = 3;
  739.         }
  742.         return $this->render('company/entreprise.html.twig', [
  744.             'company' => $company,
  745.             'visit' => $visit,
  746.             'products' => $products,
  747.             'n' => $n
  749.         ]);
  750.     }
  753.     public function showProducts()
  754.     {
  755.         //$this->denyAccessUnlessGranted('IS_AUTHENTICATED_FULLY');
  756.         $marchandises = $this->getDoctrine()
  757.             ->getRepository('App:Marchandise')
  758.             ->createQueryBuilder('p')
  759.             ->andWhere('p.company = :id')
  760.             ->setParameter('id', $this->getUser()->getId())
  761.             ->getQuery()
  762.             ->getArrayResult();
  763.         //dump($marchandises);
  764.         return $this->render('product/manage.html.twig', [
  765.             'marchandises' => $marchandises
  766.         ]);
  767.     }
  772.     /**
  773.      * @Route("/api/profile/entreprise",methods={"GET"})
  774.      */
  775.     public function api_profile_entreprise(Request $request, TraduireContenu $traduireContenu, UserRepository $userRepository, SerializerInterface $serializer)
  776.     {
  777.         /*
  778.         $encoders = [new XmlEncoder(), new JsonEncoder()];
  779.         $normalizers = [new ObjectNormalizer()];
  781.         $serializer = new Serializer($normalizers, $encoders);
  782.         */
  783.         //$this->denyAccessUnlessGranted('IS_AUTHENTICATED_FULLY');
  784.         $em = $this->getDoctrine()->getManager();
  785.         //dump($_SESSION);
  787.         //if ($request->getSession() !== "") {    
  788.         $id = $_SESSION['_sf2_attributes']['gaeaUserId'];
  789.         $email = $_SESSION['_sf2_attributes']['email'];
  790.         $username = $_SESSION['_sf2_attributes']['username'];
  792.         //$contenu = explode("&", $request->getContent());
  793.         //dump($contenu);
  795.         //$email = str_replace("%40", "@", substr($contenu[1], 6));
  796.         //$username = str_replace("%40", "@", substr($contenu[2], 9));
  797.         /*
  798.             if ($this->getUser()->getEmail() !== $email)
  799.                 $this->getUser()->setEmail($email);
  800.             if ($this->getUser()->getUsername() !== $username)
  801.                 $this->getUser()->setUsername($username);
  803.             $em->persist($this->getUser());
  804.             $em->flush();
  805.             */
  806.         //}
  808.         //$company = $this->getUser();
  809.         $company = $userRepository->findOneByGaeaId($id);
  810.         $company_array = json_decode($serializer->serialize($company, "json", ['groups' => ['company']]), true);
  811.         //dd(count($company->getCompanyFavCompanies()->toArray()));
  812.         //dd($company_array);
  813.         $company_array['companyFavCompanies'] = count($company->getCompanyFavCompanies()->toArray());
  814.         $company_array["email"] = $email;
  815.         //dump($company);
  817.         $categories = $this->em->getRepository(Category::class)->findAll();
  818.         $categories = json_decode($serializer->serialize($categories, "json", ['groups' => ['category', 'company']]));
  819.         // nouveau changement
  820.         $categoriesLang = $this->getDoctrine()->getRepository(Category::class)->findBy(["unicity" => 1]);
  821.         $tabtraduit = [];
  822.         $session = $request->getSession();
  823.         $langue = $session->get("_locale");
  824.         foreach ($categoriesLang as $category) {
  825.             $trad = $category;
  826.             if ($langue != "fr") {
  827.                 $trad = $this->traduireContenu->retourTrad($category, $langue);
  828.             }
  829.             array_push($tabtraduit, json_decode($serializer->serialize($trad, "json", ['groups' => ['category', 'company']])));
  830.             // fin nouveau changement
  831.         }
  833.         $subcategories = $em->getRepository(Subcategory::class)->findByCompany($company);
  834.         $subcategories = json_decode($serializer->serialize($subcategories, "json", ['groups' => ['category', 'company']]), true);
  836.         if (explode('\\', $em->getClassMetadata(get_class($company))->getName())[2] == 'Person') {
  837.             return $this->redirectToRoute('personProfile');
  838.         }
  839.         foreach ($company->getCompanyFavCompanies() as $fav) {
  840.             $company->addCompanyFavCompany($fav);
  841.         }
  842.         return new JsonResponse([
  843.             'company' => $company_array,
  844.             //'categories' => $categories,
  845.             'categoriesLang' => $tabtraduit,
  846.             'subcategories' => $subcategories
  847.         ]);
  848.     }
  849.     /**
  850.      * @Route("/{_locale<en|fr|de|it|es>}/profile/entreprise", name="companyProfileShow",methods={"GET","POST"})
  851.      */
  852.     public function showProfile(Request $request, TraduireContenu $traduireContenu, UserRepository $userRepository)
  853.     {
  854.         return $this->render('company/profile.html.twig');
  855.         // fin nouveau changement
  856.     }
  863.     // /**
  864.     //  * @Route("/profile/entreprise", name="companyProfileShow")
  865.     //  */
  866.     // public function showProfile(Request $request)
  867.     // {
  868.     //     //$this->denyAccessUnlessGranted('IS_AUTHENTICATED_FULLY');
  869.     //     $em = $this->getDoctrine()->getManager();
  870.     //     $company = $this->getUser();
  872.     //     $categories = $this->em->getRepository(Category::class)->findAll();
  874.     //     $subcategories = $em->getRepository(Subcategory::class)->findByCompany($company);
  876.     //     if (explode('\\', $em->getClassMetadata(get_class($company))->getName())[2] == 'Person') {
  877.     //         return $this->redirectToRoute('personProfile');
  878.     //     }
  879.     //     foreach ($company->getCompanyFavCompanies() as $fav) {
  880.     //         $company->addCompanyFavCompany($fav);
  881.     //     }
  882.     //     return $this->render('company/profile.html.twig', [
  883.     //        'company' => $company,
  884.     //         'categories' => $categories,
  885.     //         'subcategories' => $subcategories
  886.     //     ]);
  887.     // }
  889.     /**
  890.      * @Route("/activationProfil/{gaeaid}/", name="activationProfil")
  891.      */
  892.     public function activation(Request $request)
  893.     {
  894.         $msg = "Erreur";
  895.         $gaeaid = $request->get('gaeaid');
  896.         $em = $this->getDoctrine()->getManager();
  897.         $user = $em->getRepository(User::class)->findOneBy(array('gaeaUserId' => $gaeaid));
  898.         if ($user != null) {
  899.             $rep = true;
  900.             $rep2 = false;
  901.             $user->setActived($rep);
  902.             $msg = "Réussite !";
  903.         }
  904.         return new JsonResponse(['userId' => $user->getId(), 'userActivated' => $user->getActived(), 'gaeaId' => $gaeaid, 'message' => $msg]);
  905.     }
  907.     /**
  908.      * @Route("/parametres/entreprise", name="compagnySettings")
  909.      */
  910.     public function showSettings(Request $request, MailerInterface $mailer, RegisteredToNewsletterChecker $registeredToNewsletterChecker)
  911.     {
  912.         $this->denyAccessUnlessGranted('IS_AUTHENTICATED_FULLY');
  913.         $company = $this->getUser();
  914.         $email = $request->getSession()->get('email');
  915.         $categories = $this->em->getRepository(Category::class)->findAll();
  916.         $intYear = idate("Y");
  917.         $registeredToNewsletter = $registeredToNewsletterChecker->check();
  919.         $desactivateForm = $this->createForm(DesactivateCompanyType::class);
  920.         $desactivateForm->handleRequest($request);
  921.         if ($desactivateForm->isSubmitted()) {
  922.             if ($desactivateForm->isValid()) {
  923.                 $emailForm = $desactivateForm->get('email')->getData();
  924.                 if ($emailForm === $email) {
  925.                     $passwordForm = $desactivateForm->get('password')->getData();
  926.                     $encryptedPassword = md5($passwordForm);
  927.                     $response = $this->client->request(
  928.                         'POST',
  929.                         '   http://127.0.0.1:8001/apictrl/login',
  930.                         [
  931.                             'json' => [
  932.                                 'email' => $emailForm,
  933.                                 'password' => $encryptedPassword
  934.                             ],
  935.                         ]
  936.                     );
  937.                     $decodedPayload = $response->toArray();
  938.                     if (isset($decodedPayload['id'])) {
  939.                         $company->setActivated(false);
  940.                         $this->em->flush();
  941.                         $cryptService = new CryptService();
  942.                         $encryptString = $cryptService->encrypt($company->getId());
  943.                         $url = $this->generateUrl('companyActivate',  ['hash' => $encryptString]);
  945.                         // envoyer par mail http://localhost/company/activate/{encryptString}
  946.                         $activateEmail = (new TemplatedEmail())
  947.                             ->from('no-reply@repertoirevert.org')
  948.                             ->to(new Address($email))
  949.                             ->subject('A CONSERVER - Désactivation de votre compte Répertoire Vert')
  950.                             ->htmlTemplate('emails/re-activation.html.twig')
  951.                             ->context([
  952.                                 'url' => 'https://repertoirevert.org' . $url,
  953.                                 //'url' => 'https://127.0.0.1:8000'.$url,
  954.                             ]);
  955.                         // A REACTIVER QUAND L'ENVOI DE MAIL MARCHERA SUR LE SERVEUR
  956.                         //$mailer->send($activateEmail);
  958.                         return $this->redirectToRoute('logout');
  959.                     } else {
  960.                         $desactivateForm->addError(new FormError($decodedPayload['message']));
  961.                     }
  962.                 } else {
  963.                     $desactivateForm->addError(new FormError('La désactivation du compte n\'est pas celle du compte actuel '));
  964.                 }
  965.             }
  966.         }
  968.         if (!$company->getActivated()) {
  969.             die('Votre profile n\'est pas activé veuillez réactiver votre compte');
  970.         }
  971.         return $this->render('company/settings.html.twig', [
  972.             // 'company' => $company,
  973.             'email' => $email,
  974.             // 'currentYear' => $intYear,
  975.             // 'categories' => $categories,
  976.             // 'desactivateForm' => $desactivateForm->createView(),
  977.             'registeredToNewsletter' => $registeredToNewsletter,
  978.         ]);
  979.     }
  982.     /**
  983.      * @Route("/company/activate/{hash}", name="companyActivate")
  984.      */
  985.     public function activateCompany($hash, Request $request)
  986.     {
  987.         $cryptService = new CryptService();
  988.         $decryptString = $cryptService->decrypt($hash);
  989.         $company = $this->em->getRepository(Company::class)->find($decryptString);
  990.         if (isset($company)) {
  991.             $company->setActivated(true);
  992.             $this->em->flush();
  993.         }
  994.         return $this->redirectToRoute('accountActivated');
  995.         //K084a2pUeHc0b3d5bUg1U3lwRWkwdz09
  996.     }
  998.     /**
  999.      * @Route("/administration/disable/company/{id}", name="companyDisable")
  1000.      */
  1001.     public function disableCompany($id, Request $request)
  1002.     {
  1003.         $em = $this->getDoctrine()->getManager();
  1004.         $company = $em->getRepository('App:Company')->findOneBy(array('id' => $id));
  1005.         if ($request->getMethod() == "POST" and ($company->isActived(true))) {
  1006.             $company->setActived(false);
  1007.             $em->flush();
  1008.             $this->addFlash(
  1009.                 'notice',
  1010.                 'Entreprise désactivée'
  1011.             );
  1012.             return $this->redirectToRoute('companyManage');
  1013.         }
  1014.         return $this->render('company/disable.html.twig', [
  1015.             'company' => $company
  1016.         ]);
  1017.     }
  1020.     /**
  1021.      * @Route("/user/disable/company/{id}", name="companyDisableItself")
  1022.      */
  1023.     public function companyDisableItself($id, Request $request)
  1024.     {
  1025.         $em = $this->getDoctrine()->getManager();
  1026.         $company = $em->getRepository('App:Company')->findOneBy(array('id' => $id));
  1027.         if ($company->isActived(true)) {
  1028.             $company->setActived(false);
  1029.             $em->flush();
  1030.             $this->addFlash(
  1031.                 'notice',
  1032.                 'Votre compte entreprise a été désactivé.
  1033.                 Vous avez reçu un email de réactivation
  1034.                 de votre compte entreprise.'
  1035.             );
  1037.             $this->sendAccountReActivationMail($company->getEmail(), $company->getToken());
  1038.         }
  1039.         return $this->render('user/login.html.twig', [
  1040.             'company' => $company
  1041.         ]);
  1042.     }
  1043.     /**
  1044.      * @Route("/user/enable/company/{id}", name="companyReEnableItself")
  1045.      */
  1046.     public function companyReEnableItself($email, Request $request)
  1047.     {
  1048.         $em = $this->getDoctrine()->getManager();
  1049.         $company = $em->getRepository('App:Company')->findOneBy(array('email' => $email));
  1050.         if ($company->isActived(false)) {
  1051.             $company->setActived(true);
  1052.             $em->flush();
  1053.         }
  1054.         return $this->render('user/login.html.twig', [
  1055.             'company' => $company
  1056.         ]);
  1057.     }
  1059.     /**
  1060.      * @Route("/entreprise/recherche/{param}", name="companySearch")
  1061.      */
  1062.     public function search($param)
  1063.     {
  1064.         $em = $this->getDoctrine()->getManager();
  1065.         $companies = $em->getRepository(Company::class)->createQueryBuilder('p')
  1066.             ->andWhere('p.name LIKE :param')
  1067.             ->setParameter('param', '%' . $param . '%')
  1068.             ->getQuery();
  1069.         $companies = $companies->execute();
  1070.         return $this->render('company/search.html.twig', [
  1071.             'companies' => $companies
  1072.         ]);
  1073.     }
  1075.     /**
  1076.      * @Route("/administration/companies/",name="companyManage")
  1077.      */
  1078.     public function manage(Request $request)
  1079.     {
  1080.         $em = $this->getDoctrine()->getManager();
  1081.         $companies = $em->getRepository('App:User')->findBy(['role' => 'ROLE_COMPANY']);
  1082.         return $this->render('company/manage.html.twig', [
  1083.             'companies' => $companies,
  1084.         ]);
  1085.     }
  1087.     public function sendRegistrationMail($email, $token, \Swift_Mailer $mailer)
  1088.     {
  1089.         $message = (new \Swift_Message('Merci de valider votre adresse mail'))
  1090.             ->setFrom('no_reply@repertoirevert.org')
  1091.             ->setTo($email)
  1092.             ->setBody(
  1093.                 $this->renderView(
  1094.                     // app/Resources/views/Emails/registration.html.twig
  1095.                     'emails/registration-company.html.twig',
  1096.                     [
  1097.                         'email' => $email,
  1098.                         'token' => $token
  1099.                     ]
  1100.                 ),
  1101.                 'text/html'
  1102.             );
  1103.         try {
  1104.             $mailer->send($message);
  1105.         } catch (\Swift_TransportException $e) {
  1106.             echo $e->getMessage();
  1107.         }
  1108.         return $this->redirectToRoute('login');
  1109.     }
  1111.     public function sendAccountReActivationMail($email, $token, \Swift_Mailer $mailer)
  1112.     {
  1113.         $message = (new \Swift_Message('Merci de valider votre adresse mail'))
  1114.             ->setFrom('no_reply@repertoirevert.org')
  1115.             ->setTo($email)
  1116.             ->setBody(
  1117.                 $this->renderView(
  1118.                     // app/Resources/views/Emails/registration.html.twig
  1119.                     'emails/re-activation.html.twig',
  1120.                     [
  1121.                         'email' => $email,
  1122.                         'token' => $token
  1123.                     ]
  1124.                 ),
  1125.                 'text/html'
  1126.             );
  1127.         $mailer->send($message);
  1128.         /*
  1129.         try {
  1130.             $mailer->send($message);
  1131.         } catch (\Swift_TransportException $e) {
  1132.             echo $e->getMessage();
  1133.         }
  1134.         return $this->redirectToRoute('login');*/
  1135.     }
  1137.     /**
  1138.      * @Route("/addFavoris/{slug}", name="addFavoris")
  1139.      */
  1140.     public function addFavoris($slug)
  1141.     {
  1143.         $em = $this->getDoctrine()->getManager();
  1144.         $company = $em->getRepository(Company::class)->findOneBy(['slug' => $slug]);
  1145.         $date = (new \DateTime());
  1146.         $user = $this->getUser();
  1147.         $user->addCompanyFavs($company);
  1150.         $fav = $em->getRepository(CompanyFavoris::class)->findOneBy(['CompanySlug' => $slug, 'date' => $date]);
  1152.         if ($fav == null) :
  1153.             $favo = new CompanyFavoris();
  1154.             $favo->setDate($date);
  1155.             $favo->setCompanySlug($slug);
  1156.             $favo->setNumber(1);
  1157.             $em->persist($favo);
  1158.             $em->flush();
  1160.         else :
  1162.             $fav->setNumber($fav->getNumber() + 1);
  1163.             $em->persist($fav);
  1164.             $em->flush();
  1166.         endif;
  1167.         $products = $em->getRepository(Product::class)->findBy(array('company' => $company));
  1168.         $n = 1;
  1171.         return $this->render('company/show.html.twig', [
  1172.             'company' => $company,
  1173.             'products' => $products,
  1174.             'fav' => $fav,
  1175.             'n' => $n
  1176.         ]);
  1177.     }
  1179.     /**
  1180.      * @Route("/deleteFavoris/{slug}", name="deleteFavoris")
  1181.      */
  1182.     public function deleteFavoris($slug)
  1183.     {
  1187.         $em = $this->getDoctrine()->getManager();
  1188.         $company = $em->getRepository(Company::class)->findOneBy(['slug' => $slug]);
  1189.         $user = $this->getUser();
  1190.         $date = (new \DateTime());
  1191.         $favoris = $em->getRepository(CompanyFavoris::class)->findOneBy(array('CompanySlug' => $company->getSlug(), 'date' => $date));
  1192.         $user->deleteCompanyFavs($company);
  1193.         if ($favoris->getNumber() == 1) {
  1194.             $em->remove($favoris);
  1195.         } else {
  1197.             $favoris->setNumber($favoris->getNumber() - 1);
  1198.         }
  1200.         $em->flush();
  1202.         $products = $em->getRepository(Product::class)->findBy(array('company' => $company));
  1203.         $n = 0;
  1205.         return $this->render('company/show.html.twig', [
  1207.             'company' => $company,
  1208.             'products' => $products,
  1209.             'n' => $n
  1211.         ]);
  1212.     }
  1213.     /**
  1214.      * @Route("/companiesFav", name="companiesFav")
  1215.      * @return
  1216.      */
  1217.     public function companiesFav()
  1218.     {
  1219.         $em = $this->getDoctrine()->getManager();
  1220.         $companiesFav = $em->getRepository(CompanyFav::class)->findBy(['user' => $this->getUser()]);
  1221.         $companies = new ArrayCollection();
  1222.         foreach ($companiesFav as $comp) {
  1223.             $companies[] = $comp->getCompany();
  1224.         }
  1225.         return $this->render('company/companiesFav.html.twig', [
  1226.             'companies' => $companies,
  1227.             'companiesFav' => $companiesFav
  1228.         ]);
  1229.     }
  1230.     /**
  1231.      * @Route("/Map/Entreprises", name="MapEntreprises")
  1232.      */
  1233.     public function MapCompanies()
  1234.     {
  1236.         $em = $this->getDoctrine()->getManager();
  1237.         $companies = $em->getRepository(Company::class)->findAll();
  1239.         return $this->render('page/map.html.twig', [
  1240.             'companies' => json_encode($companies)
  1241.         ]);
  1242.     }
  1244.     /**
  1245.      * @Route("/tarifs-niveaux", name="tarifs-niveaux")
  1246.      */
  1247.     public function tarifsNiveaux(): Response
  1248.     {
  1249.         return $this->render('company/tarifs_niveaux.html.twig');
  1250.     }
  1253.     //"/company/show/{companyId}/{subcategoryId}/{categoryId}", name="ShowCompanyDetails" , requirements={"id"="\d+"}
  1254.     // function show companydetails
  1255.     /**
  1256.      * @Route("/company/show/{companyId}", name="ShowCompanyDetails" , requirements={"id"="\d+"})
  1257.      *
  1258.      *
  1259.      */
  1261.     public function showDetails(Request $request, $companyId, CompanyRepository $companyRepository, SubcategoryRepository $subcategoryRepository)
  1262.     {
  1263.         $em = $this->getDoctrine()->getManager();
  1264.        
  1265.         $company = $companyRepository->findOneBy(['id' => $companyId]);
  1266.         // dump($company);
  1267.         $categoryCompany = $company->getCategories();
  1268.         //  dump($categoryCompany);
  1269.         $langue = $request->getSession()->get("_locale");
  1270.         $liste_categories_traduites = new ArrayCollection();
  1271.         if ($langue != "fr") {
  1272.             //$category = $this->traduireContenu->retourTrad($category, $langue);
  1273.             //$all_categories = $em->getRepository(Category::class)->findBy(['unicity' => 1]);
  1274.             foreach ($categoryCompany as $categorie) {
  1275.                 $liste_categories_traduites->add($this->traduireContenu->retourTrad($categorie, $langue));
  1276.             }
  1277.         } else {
  1278.             foreach ($categoryCompany as $categorie) {
  1279.                 $liste_categories_traduites->add($categorie);
  1280.             }
  1281.         }
  1282.         //  dump($liste_categories_traduites);
  1283.         //$categories = $this->em->getRepository(Category::class)->findAll();
  1284.         // dump($company->getId());  OK!!!
  1285.         $subcategories = $subcategoryRepository->findByCompany($company->getId());
  1286.         //  dump($subcategories);
  1287.        
  1288.         $liste_subcategory_traduites = new ArrayCollection();
  1289.         if ($langue != "fr") {
  1290.             foreach ($subcategories as $subcategory) {
  1291.                 $slug = $subcategory->getSlug();
  1292.                 $liste_subcategory_traduites->add($subcategoryRepository->findOneBy(['slug' => $slug, 'unicity' => 0]));
  1293.             }
  1294.         } else {
  1295.             foreach ($subcategories as $subcategory) {
  1296.                 $slug = $subcategory->getSlug();
  1297.                 $liste_subcategory_traduites->add($subcategory);
  1298.             }
  1299.         }
  1301.         $categorySubcategoriesMap = [];
  1302.         foreach ($liste_categories_traduites as $category) {
  1303.         $categorySubcategoriesMap[$category->getId()] = [];
  1304.         }
  1305.         foreach ($subcategories as $subcategory) {
  1306.             foreach ($subcategory->getCategories() as $categoryOfSubcategory) {
  1307.                 if (isset($categorySubcategoriesMap[$categoryOfSubcategory->getId()])) {
  1308.                     $categorySubcategoriesMap[$categoryOfSubcategory->getId()][] = $subcategory;
  1309.                 }
  1310.             }
  1311.         }
  1313.         
  1315.         $date = (new \DateTime());
  1317.         $clicks = $em->getRepository(Visite::class)->findOneBy(array('company' => $company, 'date' => $date));
  1320.         if ($clicks == null) :
  1321.             $click = new Visite();
  1323.             $click->setDate($date);
  1324.             $click->setCompany($company);
  1325.             $click->setNumber(1);
  1326.             $em->persist($click);
  1327.             $em->flush();
  1328.         else :
  1330.             $clicks->setNumber($clicks->getNumber() + 1);
  1331.             $em->persist($clicks);
  1332.             $em->flush();
  1334.         endif;
  1335.         // dump($liste_categories_traduites);
  1336.         return $this->render('company/showCompanyDetails.html.twig', [
  1338.             'company' => $company,
  1339.             'categories' => $liste_categories_traduites,
  1340.             'products' => $company->getProducts(),
  1341.             'subcategories' => $liste_subcategory_traduites,
  1342.             'categorySubcategoriesMap' => $categorySubcategoriesMap,
  1344.         ]);
  1345.     }
  1347.     ///////////// Enregistrement des entreprises du fichiers excel dans la bdd + Envoi du mail de réinitialisation mdp //////////////
  1348.     /**
  1349.      * @Route("/upload-excel", name="xlsx")
  1350.      */
  1351.     public function getCompaniesfromExcel()
  1352.     {
  1355.         $fileFolder = __DIR__ . '/../../public/uploads/';  //choose the folder in which the uploaded file will be stored
  1357.         $spreadsheet = IOFactory::load($fileFolder . "/entreprises-a-upload.xlsx"); // Here we are able to read from the excel file
  1358.         $row = $spreadsheet->getActiveSheet()->removeRow(1, 20); // I added this to be able to remove the first file line
  1359.         $sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true); // here, the read data is turned into an array
  1360.         //dd($sheetData);
  1362.         foreach ($sheetData as $Row) {
  1363.             //for($i=0; $i < 57; $i++){
  1365.             /*$name = $sheetData[$i]['A'];
  1366.             $description = $sheetData[$i]['B'];
  1367.             $email= $sheetData[$i]['C'];
  1368.             $tel = $sheetData[$i]['D'];*/
  1369.             $email = $Row['C'];
  1370.             $password = bin2hex(random_bytes(8));
  1372.             /////////// Ajout des entreprises du fichier excel dans la bdd => FAIT ///////////
  1373.             /*if($name != null) {
  1375.                 $response = $this->client->request(
  1376.                     'POST',
  1377.                     '   http://127.0.0.1:8001/apictrl/add/gaeauser', [
  1378.                     'json' => [
  1379.                         'url' => 'rv',
  1380.                         'username' => $name,
  1381.                         'email' => $email,
  1382.                         'password' => $password,
  1383.                         'newpassword' => $password
  1384.                     ]
  1385.                 ]);
  1387.                 $content = $response->getContent();
  1388.                 $content = json_decode($content);
  1390.                 $company = new Company();
  1392.                 $company->setName($name);
  1393.                 $company->setStreet('');
  1394.                 $company->setCity('');
  1395.                 $company->setsocialreason('');
  1396.                 $company->setPostcode('');
  1397.                 $company->setRegion('');
  1398.                 $company->setCountry('');
  1399.                 $company->setPhone($tel);
  1400.                 $company->setstartingdate(new \DateTime());
  1402.                 $company->setVision('');
  1403.                 $company->setInfluencezone('');
  1404.                 if($description == null) {
  1405.                     $company->setDescription('');
  1406.                 } else {
  1407.                     $company->setDescription($description);
  1408.                 }
  1409.                 $company->setWantevaluation(0);
  1410.                 $company->setLatitude(0);
  1411.                 $company->setLongtitude(0);
  1414.                 $company->setgaeaUserId($content->id);
  1415.                 $company->setRole('ROLE_COMPANY');
  1416.                 $slugify = new Slugify();
  1417.                 $slug = $slugify->slugify($name);
  1418.                 $company->setSlug($slug);
  1419.                 $company->setActivated(true);
  1420.                 $company->setActived(true);
  1421.                 $company->setEmailValidated(false);
  1422.                 $token = bin2hex(random_bytes(21));
  1423.                 $company->setToken($token);
  1424.                 $company->setInscriptiondate(new \DateTime());
  1425.                 $company->setNiveau('N.0');
  1426.                 $em = $this->getDoctrine()->getManager();
  1427.                 $em->persist($company);
  1428.                 $em->flush();
  1429.             }*/
  1432.             /////////// Envoi du mail de réinitialisation de mdp //////////////
  1433.             if ($email != null) {
  1434.                 $response = $this->client->request(
  1435.                     'POST',
  1436.                     '   http://127.0.0.1:8001/apictrl/requestpassword',
  1437.                     [
  1438.                         'json' => [
  1439.                             'url' => 'https://www.repertoirevert.org',
  1440.                             'email' => $email,
  1441.                         ]
  1442.                     ]
  1443.                 );
  1444.             }
  1445.         }
  1447.         return $this->json(['status' => 200, 'message' => "Ok"]);
  1448.     }
  1449.     /**
  1450.      * @Route("/apiGaeaUser",methods={"POST"})
  1451.      */
  1452.     public function ApiGaeaUser(Request $request, CategoryRepository $catrep)
  1453.     {
  1456.         $em = $this->getDoctrine()->getManager();
  1457.         function longueur_entre($chaine, $min, $max, $required = true)
  1458.         {
  1459.             if (isset($chaine)) {
  1460.                 return strlen($chaine) <= $max && strlen($chaine) >= $min;
  1461.             } else {
  1462.                 if ($required) {
  1463.                     return false;
  1464.                 } else {
  1465.                     return true;
  1466.                 }
  1467.             }
  1468.         }
  1469.         $contenuDecode = $_POST;
  1470.         //$contenuDecode = json_decode($request->getContent(),true);
  1471.         $Username = $contenuDecode['Username'];
  1472.         $Firstname = $contenuDecode['Firstname'];
  1473.         $Lastname = $contenuDecode['Lastname'];
  1474.         $Password = $contenuDecode['Password'];
  1475.         $PasswordConfirm = $contenuDecode['PasswordConfirm'];
  1476.         $Email = $contenuDecode['Email'];
  1477.         $EmailConfirm = $contenuDecode['EmailConfirm'];
  1478.         $Name = $contenuDecode['Name'];
  1479.         $Socialreason = $contenuDecode['Socialreason'];
  1480.         $Street = $contenuDecode['Street'];
  1481.         $Postcode = $contenuDecode['Postcode'];
  1482.         $Region = $contenuDecode['Region'];
  1483.         $City = $contenuDecode['City'];
  1484.         $Country = $contenuDecode['Country'];
  1485.         $Phone = $contenuDecode['Phone'];
  1486.         $Urlwebsite = $contenuDecode['Urlwebsite'];
  1487.         $Urlfacebook = $contenuDecode['Urlfacebook'];
  1488.         $Urllinkedin = $contenuDecode['Urllinkedin'];
  1489.         $Urltwitter = $contenuDecode['Urltwitter'];
  1490.         $Startingdate = $contenuDecode['Startingdate'];
  1491.         $Certification = $contenuDecode['Certification'];
  1492.         $Influencezone = $contenuDecode['Influencezone'];
  1493.         $Categories = json_decode($contenuDecode['Categories'], true);
  1494.         $Wantevaluation = $contenuDecode['Wantevaluation'];
  1495.         $Description = $contenuDecode['Description'];
  1496.         $Vision = $contenuDecode['Vision'];
  1497.         if (
  1498.             longueur_entre($Username, 3, 50) &&
  1499.             longueur_entre($Firstname, 3, 50) &&
  1500.             longueur_entre($Lastname, 3, 50) &&
  1501.             longueur_entre($Password, 8, 2147483647) &&
  1502.             longueur_entre($PasswordConfirm, 8, 2147483647) &&
  1503.             isset($Email) &&
  1504.             isset($EmailConfirm) &&
  1505.             longueur_entre($Name, 3, 100) &&
  1506.             longueur_entre($Socialreason, 2, 50) &&
  1507.             longueur_entre($Street, 2, 50, false) &&
  1508.             longueur_entre($Postcode, 3, 15, false) &&
  1509.             longueur_entre($Region, 3, 254, false) &&
  1510.             longueur_entre($City, 3, 254, false) &&
  1511.             longueur_entre($Country, 3, 254, false) &&
  1512.             longueur_entre($Phone, 3, 20, false) &&
  1513.             longueur_entre($Urlwebsite, 3, 254, false) &&
  1514.             longueur_entre($Urlfacebook, 3, 254, false) &&
  1515.             longueur_entre($Urllinkedin, 3, 254, false) &&
  1516.             longueur_entre($Urltwitter, 3, 254, false) &&
  1517.             isset($Startingdate) &&
  1518.             isset($Certification) &&
  1519.             isset($Influencezone) &&
  1520.             isset($Categories) &&
  1521.             isset($Wantevaluation) &&
  1522.             longueur_entre($Description, 3, 508, false) &&
  1523.             longueur_entre($Vision, 3, 508, false) &&
  1524.             $Email == $EmailConfirm
  1525.         ) {
  1526.             $categories_tableau = new ArrayCollection();
  1527.             foreach ($Categories as $category_name) {
  1528.                 $categories_tableau[] = $catrep->findOneBy(['name' => $category_name]);
  1529.             }
  1530.             //$url = "   http://127.0.0.1:8001/apictrl/add/gaeauser";
  1531.             $url = "http://gaea21user.sustlivprogram.org/apictrl/add/gaeauser";
  1532.             $data = array(
  1533.                 'email' => $Email,
  1534.                 'username' => $Username,
  1535.                 'password' => $Password,
  1536.                 'newpassword' => $PasswordConfirm
  1537.             );
  1538.             $data_json = json_encode($data);
  1539.             $ch = curl_init();
  1540.             curl_setopt($ch, CURLOPT_URL, $url);
  1541.             curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/json'));
  1542.             curl_setopt($ch, CURLOPT_POST, 1);
  1543.             curl_setopt($ch, CURLOPT_POSTFIELDS, $data_json);
  1544.             curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  1545.             $response  = curl_exec($ch);
  1546.             curl_close($ch);
  1547.             if (isset(json_decode($response, true)["id"])) {
  1548.                 $Setcompany = new Company();
  1550.                 $Setcompany->setName($Name);
  1551.                 $Setcompany->setStreet($Street);
  1552.                 $Setcompany->setCity($City);
  1553.                 $Setcompany->setsocialreason($Socialreason);
  1554.                 $Setcompany->setPostcode($Postcode);
  1555.                 $Setcompany->setRegion($Region);
  1556.                 $Setcompany->setCountry($Country);
  1557.                 $Setcompany->setPhone($Phone);
  1558.                 $Setcompany->setUrlwebsite($Urlwebsite);
  1559.                 $Setcompany->setUrllinkedin($Urllinkedin);
  1560.                 $Setcompany->setUrlfacebook($Urlfacebook);
  1561.                 $Setcompany->setUrltwitter($Urltwitter);
  1562.                 $Setcompany->setstartingdate(new \DateTime($Startingdate));
  1563.                 $Setcompany->setCertification($Certification);
  1564.                 $Setcompany->setLastname($Lastname);
  1565.                 $Setcompany->setFirstname($Firstname);
  1567.                 foreach ($categories_tableau as $cat) {
  1568.                     $Setcompany->addCategory($cat);
  1569.                 }
  1571.                 $Setcompany->setVision($Vision);
  1572.                 $Setcompany->setInfluencezone($Influencezone);
  1573.                 $Setcompany->setDescription($Description);
  1574.                 $Setcompany->setWantevaluation($Wantevaluation);
  1575.                 $Setcompany->setLatitude(0);
  1576.                 $Setcompany->setLongtitude(0);
  1579.                 $Setcompany->setgaeaUserId(json_decode($response, true)["id"]);
  1581.                 $Setcompany->setUsername($Username);
  1586.                 $Setcompany->setRole('ROLE_COMPANY');
  1587.                 $slugify = new Slugify();
  1588.                 $slug = $slugify->slugify($Name);
  1589.                 $Setcompany->setSlug($slug);
  1590.                 $Setcompany->setActivated(true);
  1591.                 $Setcompany->setActived(true);
  1592.                 $Setcompany->setEmailValidated(false);
  1593.                 $token = bin2hex(random_bytes(21));
  1594.                 $Setcompany->setToken($token);
  1595.                 $Setcompany->setInscriptiondate(new \DateTime());
  1596.                 $Setcompany->setNiveau($Wantevaluation ? 'N.1' : 'N.0');
  1597.                 $em = $this->getDoctrine()->getManager();
  1598.                 $em->persist($Setcompany);
  1599.                 $em->flush();
  1600.             }
  1601.             if (isset(json_decode($response, true)["id"])) {
  1602.                 return $this->json(["id" => json_decode($response, true)["id"], "erreur" => "false"]);
  1603.             } else {
  1604.                 return $this->json(["erreur" => "true", "erreur_message" => json_decode($response, true)["message"]]);
  1605.             }
  1606.         } else {
  1607.             return $this->json(["erreur" => "true", "erreur_message" => "Formulaire d'inscription non valide."]);
  1608.         }
  1609.     }
  1611.     /**
  1612.      * @Route("/{_locale<en|fr|de|it|es>}/qui-sommes-nous/", name="companyQSN")
  1613.      */
  1614.     public function quiSommesNous()
  1615.     {
  1616.         return $this->render('quisommesnous/company/quisommesnous.html.twig');
  1617.     }
  1619.     /**
  1620.      * @Route("/{_locale<en|fr|de|it|es>}/qui-sommes-nous2/", name="companyQSN2")
  1621.      */
  1622.     public function quiSommesNous2()
  1623.     {
  1624.         return $this->render('quisommesnous/company/quisommesnous2.html.twig');
  1625.     }
  1627.     /**
  1628.      * @Route("/{_locale<en|fr|de|it|es>}/qui-sommes-nous3/", name="companyQSN3")
  1629.      */
  1630.     public function quiSommesNous3()
  1631.     {
  1632.         return $this->render('quisommesnous/company/quisommesnous3.html.twig');
  1633.     }
  1635.     /**
  1636.      * @Route("/{_locale<en|fr|de|it|es>}/qui-sommes-nous4/", name="companyQSN4")
  1637.      */
  1638.     public function quiSommesNous4()
  1639.     {
  1640.         return $this->render('quisommesnous/company/quisommesnous4.html.twig');
  1641.     }
  1643.     /**
  1644.      * @Route("/{_locale<en|fr|de|it|es>}/qui-sommes-nous5/", name="companyQSN5")
  1645.      */
  1646.     public function quiSommesNous5()
  1647.     {
  1648.         return $this->render('quisommesnous/company/quisommesnous5.html.twig');
  1649.     }
  1651.     /**
  1652.      * @Route("/{_locale<en|fr|de|it|es>}/communaute/", name="communaute")
  1653.      */
  1654.     public function communaute(Request $request)
  1655.     {
  1657.         $session = $request->getSession();
  1658.         $langue = $session->get("_locale");
  1659.         $em = $this->getDoctrine()->getManager();
  1660.         $categoryCommunaute = $em->getRepository(Category::class)->findOneBy(['slug' => 'communaute', 'unicity' => 1]);
  1661.         if (!$categoryCommunaute) {
  1662.             throw $this->createNotFoundException('La categorie n\'existe pas');
  1663.         }
  1664.         if ($langue != "fr") {
  1665.             $categoryCommunaute = $this->traduireContenu->retourTrad($categoryCommunaute, $langue);
  1666.         }
  1667.         $subcategoryCommunaute = $categoryCommunaute->getSubcategories();
  1669.         $all_categories = $em->getRepository(Category::class)->findBy(['unicity' => 1]);
  1670.         $liste_categories_traduites = [];
  1671.         foreach ($all_categories as $categorie_particuliere) {
  1672.             $liste_categories_traduites[] = $this->traduireContenu->retourTrad($categorie_particuliere, $langue);
  1673.         }
  1675.         return $this->render('company/communaute.html.twig', [
  1676.             'subcategoryCommunaute' => $subcategoryCommunaute,
  1677.             'categories' => $liste_categories_traduites
  1678.         ]);
  1679.     }
  1681.      /**
  1682.      * @Route("/fr/listing", name="listing")
  1683.      */
  1684.     public function listing(CallApiService $CallApiService)
  1685.     {
  1686.         $companies = $CallApiService->merged_users_companies();
  1688.         return $this->render('company/listing.html.twig', [
  1689.             'companies' => $companies
  1690.         ]);
  1691.     }
  1693.     /**
  1694.      * @Route("/fr/export_CSV", name="export_CSV" )
  1695.      */
  1696.     public function export_CSV(Request $request)
  1697.     {
  1699.         $companies = $request->request->get('companies');
  1700.         $array_companies = json_decode($companies, true);
  1701.  
  1702.         $dataToCsv = [];
  1704.         foreach($array_companies as $company){
  1705.             $dataToCsv[] = [
  1706.                 $company['name'],
  1707.                 $company['email'],
  1708.                 $company['phone'],
  1709.             ];
  1710.         }
  1712.         $lines = [];
  1713.         foreach ($dataToCsv as $row) {
  1714.             $lines[] = implode(',', $row);
  1715.         }
  1717.         $data = implode(PHP_EOL, $lines);
  1718.         $data = "Nom, Email, Téléphone".PHP_EOL.$data;
  1719.       
  1720.         return new Response(
  1721.             $data,
  1722.             200,
  1723.             [
  1724.                 'Content-Type' => 'text/csv',
  1725.                 "Content-disposition" => "attachment; filename=Listing.csv"
  1726.             ]
  1727.         );
  1729.     }
  1730. }