src/Controller/SecurityController.php line 860

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  4. use App\Entity\Sondage;
  5. use App\Entity\TypeSondage;
  6. use App\Entity\Comment;
  7. use App\Entity\Enquetes; 
  8. use App\Entity\ReponseUser;
  9. use App\Entity\Infousers;
  10. use App\Entity\PayeUsers;
  11. use App\Entity\UserVip;
  12. use App\Entity\User;
  13. use App\Entity\UsersAuthToken;
  14. use App\Entity\Forums;
  15. use App\Entity\UserNiveauAtteint;
  16. use App\Entity\UserOccupationPrincipale;
  17. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  18. use Symfony\Component\HttpFoundation\Response;
  19. use Symfony\Component\HttpFoundation\Request;
  20. use Symfony\Component\Routing\Annotation\Route;
  21. use Symfony\Component\Security\Http\Authentication\AuthenticationUtils;
  22. use Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken;
  23. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  24. use Symfony\Component\Security\Core\Security;
  25. use Pusher\Pusher;
  26. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  27. use Symfony\Component\Security\Core\Encoder\UserPasswordEncoderInterface;
  28. use Symfony\Component\Security\Csrf\TokenGenerator\TokenGeneratorInterface;
  29. use Symfony\Component\Mailer\MailerInterface;
  30. use Symfony\Contracts\Translation\TranslatorInterface;
  31. use Symfony\Component\Mime\Email;
  33. class SecurityController extends AbstractController
  34. {
  35.     private $session;
  36.     private $security;
  37.     private $pusher;
  38.     public function __construct(SessionInterface $session,Security $security,Pusher $pusher)
  39.     {
  40.         $this->session = $session;
  41.         $this->security = $security;
  42.         $this->pusher = $pusher;
  43.     }
  44.     
  45.     public function redirectadmin()
  46.     {
  47.         if($this->getUser()){
  48.             return null;
  49.         }
  50.         return $this->redirectToRoute('home');
  51.         
  52.     }
  53.     public function home()
  54.     {
  55.         return $this->redirectToRoute('home');
  56.     }
  57.      public function index(Request $request)
  58.     {
  59.         if($request->get('auth') && $request->get('auth')=="success"){
  60.             $entityManager = $this->getDoctrine()->getManager();
  61.             $tokenuser = uniqid().$request->get('_csrf_token').uniqid();
  62.             $user = $entityManager->getRepository(User::class)->findOneBy(['username' => $request->get('login')]);
  63.             if (!$user) {
  64.                 $user = $entityManager->getRepository(User::class)->findOneBy(['phone' => $request->get('login')]);
  65.             }
  66.             if (!$user) {
  67.                 $user = $entityManager->getRepository(User::class)->findOneBy(['email' => $request->get('login')]);
  68.             }
  69.             if ($user) {
  70.                 
  71.                 $AuthToken = new UsersAuthToken();
  72.                 $AuthToken->setIdUser($user->getId());
  73.                 $AuthToken->setToken($tokenuser);
  74.                 $AuthToken->setCreateAt(new \DateTime("now"));
  75.                 $AuthToken->setExpired(0);
  76.                 $entityManager->persist($AuthToken);
  77.                 $entityManager->flush();
  78.                 
  79.                 return $this->redirectToRoute('home',["token"=>$tokenuser]);
  80.             }
  81.         }
  82.         if ($this->getUser()) {
  83.             $page_sondage = $this->session->get('page_sondage');
  84.             if ($page_sondage && $page_sondage!=""){
  85.                 $reponseuser = new ReponseuserController($this->security,$this->pusher);
  86.                 $user_sondage = $this->session->get('reponse_user_sondage');
  87.                 $user_sondage_type = $this->session->get('reponse_user_sondage_type');
  88.                 if($user_sondage !=""){
  89.                     $request->attributes->set('user_sondage',$user_sondage);
  90.                     $request->attributes->set('user_sondage_type',$user_sondage_type);
  91.                     $request->attributes->set('user_sondage_login','oui');
  92.                     $reponseuser->voter_sondage($request,$page_sondage,$this->getDoctrine());
  94.                 }
  95.                 
  96.                 $sondage= $this->getDoctrine()->getRepository(Sondage::class)->find($page_sondage);
  97.                 if($request->getLocale()=="fr"){
  98.                     $slug = $sondage->getSlugFr();
  99.                 }else{
  100.                     $slug = $sondage->getSlugAr();
  101.                 }
  102.                 if($sondage->getCategories()){
  103.                     $categorie= $this->getDoctrine()->getRepository(TypeSondage::class)->find($sondage->getCategories()[0]);
  104.                     if($request->getLocale()=="fr"){
  105.                         $categorie=$categorie->getSlug();
  106.                     }else{
  107.                         $categorie=$categorie->getArSlug();
  108.                     }
  109.                     
  110.                 }else{
  111.                     $categorie="null";
  112.                 }
  113.                 $this->session->set('page_sondage',"");
  114.                 $this->session->set('user_sondage',"");
  115.                 $this->session->set('user_sondage_type',"");
  116.                 $this->session->set('user_sondage_login',"");
  117.                 if($request->get('token') && $request->get('token')!=""){
  118.                     return $this->redirectToRoute('detail_sondage', array(
  119.                         'categorie' => $categorie,
  120.                         'slug' =>   $slug,
  121.                         'token' =>$request->get('token')
  122.                     ));
  123.                 }else{
  124.                     return $this->redirectToRoute('detail_sondage', array(
  125.                         'categorie' => $categorie,
  126.                         'slug' =>   $slug
  127.                     ));
  128.                 }
  129.                 
  130.             }
  131.         }
  132.         $sondages = $this->getDoctrine()->getRepository(Sondage::class)->findBy(['post_status' => 'publish'],['id' => 'DESC']);
  133.         $sql = "
  134.            SELECT s.id as id_s , 
  135.                 (SELECT count(*) FROM reponse_user r WHERE s.id = r.id_sondage ) as nbvotes ,
  136.                 (SELECT count(*) FROM comment c WHERE s.id = c.id_sondage ) as nbcomments
  137.             FROM sondage s
  138.         ";
  139.         $nbvotesnbcomments = $this->getDoctrine()->getManager()->getConnection()->prepare($sql);
  140.         $nbvotesnbcomments->execute();
  141.         $nbvotesnbcomments = $nbvotesnbcomments->fetchAll();
  142.         $nbvotes_nbcomments = [];
  143.         foreach ($nbvotesnbcomments as $key => $value) {
  144.             $nbvotes_nbcomments [$value["id_s"]] = $value;
  145.         }
  147.         $sondages_art_culture = $this->get_sondages_home_by_categorie($sondages,1,$request->getLocale(),4,$nbvotes_nbcomments);
  149.         $sondages_celebrites = $this->get_sondages_home_by_categorie($sondages,2,$request->getLocale(),6,$nbvotes_nbcomments);
  150.         $sondages_divertissement = $this->get_sondages_home_by_categorie($sondages,3,$request->getLocale(),4,$nbvotes_nbcomments);
  151.         $sondages_economie = $this->get_sondages_home_by_categorie($sondages,4,$request->getLocale(),4,$nbvotes_nbcomments);
  152.         $sondages_medias = $this->get_sondages_home_by_categorie($sondages,5,$request->getLocale(),4,$nbvotes_nbcomments);
  153.         $sondages_santes = $this->get_sondages_home_by_categorie($sondages,12,$request->getLocale(),4,$nbvotes_nbcomments);
  154.         $sondages_society = $this->get_sondages_home_by_categorie($sondages,8,$request->getLocale(),6,$nbvotes_nbcomments);
  155.         $sondages_policy = $this->get_sondages_home_by_categorie($sondages,9,$request->getLocale(),4,$nbvotes_nbcomments);
  156.         $sondages_sport = $this->get_sondages_home_by_categorie($sondages,7,$request->getLocale(),5,$nbvotes_nbcomments);
  157.         $sondages_divers = $this->get_sondages_home_by_categorie($sondages,11,$request->getLocale(),5,$nbvotes_nbcomments);
  158.         
  160.         
  162.         $typesondage = $this->getDoctrine()->getRepository(TypeSondage::class)->findAll();
  163.         $categories = [] ;
  164.         foreach ($typesondage as $key => $value) {
  165.             $categories [$value->getId()] =$value;
  166.         }
  167.         $sondages_slider = $this->prepare_slider_home($request->getLocale());
  168.         $pays= $this->getDoctrine()->getRepository(PayeUsers::class)->findBy(['parent' => null]);
  169.         $paysSondage=[];
  170.         foreach ($pays as $key => $value) {
  171.             if($request->getLocale()=="fr"){
  172.                 $paysSondage [$value->getId()] =$value->getLibelle();
  173.             }elseif($request->getLocale()=="ar"){
  174.                 $paysSondage [$value->getId()] =$value->getLibelleAr();
  175.             }
  176.         }
  177.         return $this->render('security/index.html.twig', [
  178.             'page'                      => 'Home',
  179.             'controller_name'           => 'SecurityController',
  180.             'categories'                => $categories,
  181.             'sondages_slider'              => $sondages_slider,
  182.             'sondages_art_culture'      => $sondages_art_culture,
  183.             'sondages_celebrites'       => $sondages_celebrites,
  184.             'sondages_divertissement'   => $sondages_divertissement,
  185.             'sondages_economie'         => $sondages_economie,
  186.             'sondages_medias'           => $sondages_medias,
  187.             'sondages_santes'           => $sondages_santes,
  188.             'sondages_sport'            => $sondages_sport,
  189.             'sondages_society'          => $sondages_society,
  190.             'sondages_policy'           => $sondages_policy,
  191.             'sondages_divers'           => $sondages_divers,
  192.             'pays'                      => $paysSondage
  193.         ]);
  194.     }
  195.     public function get_sondages_home_by_categorie($sondages,$categorie,$long,$nb_sondages,$nbvotes_nbcomments)
  196.     {
  197.         if($long=="fr"){
  198.             foreach ($sondages as $key => $sondage) {
  199.                 if( $sondage->getLongSondage() =="ar" ){
  200.                     unset($sondages[$key]);
  201.                 }else{
  202.                     if(!in_array($categorie, $sondage->getCategories())){
  203.                         unset($sondages[$key]);
  204.                     }
  205.                 }
  207.             }
  208.         }else{
  209.             foreach ($sondages as $key => $sondage) {
  210.                 if( $sondage->getLongSondage() =="fr" ){
  211.                     unset($sondages[$key]);
  212.                 }else{
  213.                     if(!in_array($categorie, $sondage->getCategories())){
  214.                         unset($sondages[$key]);
  215.                     }
  216.                 }
  217.             }
  218.         }
  219.         
  221.         $new_sondages=[];
  222.         //if($nb_sondages<=sizeof($sondages)){
  223.             $i=0;
  224.             foreach ($sondages as $key => $sondage) {
  225.                 if($i<$nb_sondages){
  226.                 $new_sondages [] =$sondage; 
  227.                 }else{
  228.                     break;
  229.                 }
  230.                 $i++;
  231.             }
  232.             foreach ($new_sondages as $key => &$sondage) {
  233.                 //$comments = $this->getDoctrine()->getRepository(Comment::class)->findBy(['id_sondage'=>$sondage->getId()]);
  234.                 $sondage->{'nbcomments'} = $nbvotes_nbcomments[$sondage->getId()]["nbcomments"];//sizeof($comments);
  235.                 //$reponseUser= $this->getDoctrine()->getRepository(ReponseUser::class)->findBy(["id_sondage"=>$sondage->getId()]);
  236.                 $sondage->{'nbvotes'} = $nbvotes_nbcomments[$sondage->getId()]["nbvotes"]+$sondage->getVoteVartuel();//sizeof($reponseUser);
  238.             }
  239.         //}
  240.         return $new_sondages;
  241.     }
  242.     public function admin(Request $request)
  243.     {
  244.         if ($this->getUser()) {
  245.             if ($this->getUser()->getValid()==null){
  246.                 // $PayesUser = $this->getDoctrine()->getRepository(PayeUsers::class)->findBy(['parent' => 1]);
  247.                 
  248.                 // foreach ($PayesUser  as $key => &$PayeUser ) {
  249.                 //     $filss = $this->getDoctrine()->getRepository(PayeUsers::class)->findBy(['parent' => $PayeUser->getId()]);
  250.                 //     foreach ($filss  as $key => &$fils ) {
  251.                 //         $fils->{'fils'}=$this->getDoctrine()->getRepository(PayeUsers::class)->findBy(['parent' => $fils->getId()]);
  252.                 //     }
  253.                 //     $PayeUser->{'fils'}=$filss;
  254.                 // }
  255.                 // $infouser = $this->getDoctrine()->getRepository(Infousers::class)->findBy(['id_user'=>$this->getUser()->getId()]);
  256.                 // $NiveausAtteint = $this->getDoctrine()->getRepository(UserNiveauAtteint::class)->findAll();
  257.                 // $OccupationsPrincipale = $this->getDoctrine()->getRepository(UserOccupationPrincipale::class)->findAll();
  258.                 // return $this->render('user/complete_info.html.twig', [
  259.                 //     'page'                  => 'User',
  260.                 //     'controller_name'       => 'UserController',
  261.                 //     'PayesUser'             => $PayesUser,
  262.                 //     'infouser'              => $infouser[0],
  263.                 //     'NiveausAtteint'        => $NiveausAtteint,
  264.                 //     'OccupationsPrincipale' => $OccupationsPrincipale 
  265.                 // ]);
  266.             }
  267.             $page_sondage = $this->session->get('page_sondage');
  268.             if ($page_sondage && $page_sondage!=""){
  269.                 $reponseuser = new ReponseuserController($this->security,$this->pusher);
  270.                 $user_sondage = $this->session->get('reponse_user_sondage');
  271.                 $user_sondage_type = $this->session->get('reponse_user_sondage_type');
  272.                 if($user_sondage !=""){
  273.                     $request->attributes->set('user_sondage',$user_sondage);
  274.                     $request->attributes->set('user_sondage_type',$user_sondage_type);
  275.                     $request->attributes->set('user_sondage_login','oui');
  276.                     $reponseuser->voter_sondage($request,$page_sondage,$this->getDoctrine());
  278.                 }
  279.                 
  280.                 $sondage= $this->getDoctrine()->getRepository(Sondage::class)->find($page_sondage);
  281.                 if($request->getLocale()=="fr"){
  282.                     $slug = $sondage->getSlugFr();
  283.                 }else{
  284.                     $slug = $sondage->getSlugAr();
  285.                 }
  286.                 if($sondage->getCategories()){
  287.                     $categorie= $this->getDoctrine()->getRepository(TypeSondage::class)->find($sondage->getCategories()[0]);
  288.                     if($request->getLocale()=="fr"){
  289.                         $categorie=$categorie->getSlug();
  290.                     }else{
  291.                         $categorie=$categorie->getArSlug();
  292.                     }
  293.                     
  294.                 }else{
  295.                     $categorie="null";
  296.                 }
  297.                 $this->session->set('page_sondage',"");
  298.                 $this->session->set('user_sondage',"");
  299.                 $this->session->set('user_sondage_type',"");
  300.                 $this->session->set('user_sondage_login',"");
  301.                 return $this->redirectToRoute('detail_sondage', array(
  302.                 'categorie' => $categorie,
  303.                 'slug' =>   $slug
  304.                 ));
  305.             }
  306.             $page_enquete = $this->session->get('page_enquete');
  307.             if ($page_enquete && $page_enquete!=""){
  308.                 $sondage= $this->getDoctrine()->getRepository(Enquetes::class)->find($page_enquete);
  309.                 $categorie=$sondage->getCategories()[0];
  310.                 $this->session->set('page_enquete',"");
  311.                 return $this->redirectToRoute('detail_enquete_id', array(
  312.                 'id_categorie' => $categorie,
  313.                 'id' =>   $page_enquete
  314.                 ));
  315.             }
  316.             $infouser = $this->getDoctrine()->getRepository(Infousers::class)->findBy(['id_user'=>$this->getUser()->getId()]);
  317.             if($infouser){
  318.                 $info_user= $infouser[0];
  319.                 $all_points_user= $this->getDoctrine()->getRepository(ReponseUser::class)->findBy(["id_user"=>$this->getUser()->getId()]);
  320.                 $points_sondage = 0;
  321.                 foreach ($all_points_user as $key => $value) {
  322.                     $points_sondage +=$value->getNpPoints();
  323.                 }
  324.                 $points_vip = 0;
  325.                 if ($this->getUser()->getUserVip()==7) {
  326.                     $all_points_user= $this->getDoctrine()->getRepository(UserVip::class)->findBy(["id_user"=>$this->getUser()->getId()]);
  327.                     foreach ($all_points_user as $key => $value) {
  328.                         $points_vip +=$value->getNbPoint();
  329.                     }
  330.                 }
  331.                 $points_heritage = 0;
  332.                 $infouser_parents = $this->getDoctrine()->getRepository(Infousers::class)->findBy(['id_parent'=>$this->getUser()->getId()]);
  333.                 foreach ($infouser_parents as $key => $infouser_parent) {
  334.                     if($infouser_parent->getValide()==1){
  335.                         $points_heritage = $points_heritage + 200 ;
  336.                     }
  337.                 }
  338.             }
  339.             return $this->render('admin/index.html.twig', [
  340.              'page'             => 'Home',
  341.              'controller_name'  => 'SecurityController',
  342.              'infouser'         => $infouser[0],
  343.              'points_vip'       => $points_vip,
  344.              'points_sondage'   => $points_sondage,
  345.              'points_heritage' => $points_heritage,
  346.              'token' => $request->get("token")
  347.             ]);
  348.         }else{
  349.              return $this->redirectToRoute('home');
  350.         }
  351.         
  352.     }
  353.     
  354.     /**
  355.      * @Route("/blockmonaccount", name="blockmonaccount")
  356.     */
  357.     public function blockmonaccount(Request $request)
  358.     {
  360.         if ($this->getUser()) {
  361.             $infouser = $this->getDoctrine()->getRepository(Infousers::class)->findBy(['id_user'=>$this->getUser()->getId()]);
  362.             return $this->render('security/block_mon_account.html.twig', [
  363.                 'user'      => $this->getUser(),
  364.                 'infouser'  => $infouser[0],
  365.                 'connected' =>  "oui"
  366.            ]);
  367.         }else{
  368.             return $this->render('security/block_mon_account.html.twig', [
  369.                 'user'      => null,
  370.                 'infouser'  => null,
  371.                 'connected' =>  "non"
  372.            ]);
  373.         }
  374.         
  375.     }
  376.     
  378.     
  379.     /**
  380.      * @Route("/nav_categories-{slog_name}", name="nav_categories")
  381.     */
  382.     public function nav_categories($slog_name = null)
  383.     {
  384.         $sql = "UPDATE `sondage` SET expirer=1 WHERE date_fin <  CURDATE()  OR (date_fin =  CURDATE() AND `time_fin`<= CURTIME())";
  385.         $update_sondage = $this->getDoctrine()->getManager()->getConnection()->prepare($sql);
  386.         $update_sondage->execute();
  387.         $categories = $this->getDoctrine()->getRepository(TypeSondage::class)->findBy([],["sort"=>"ASC"]);
  388.         foreach ($categories as $key => $categorie) {
  389.             if($categorie->getSort()==0)
  390.                 unset( $categories[$key] );
  391.         }
  392.         //dd($slog_name);
  393.         return $this->render('nav_categories.html.twig', [
  394.              'nav_categories'              => $categories,
  395.              'slog_name'  =>  $slog_name
  396.         ]);
  397.     }
  398.     
  399.     /**
  400.      * @Route("/get_parrain", name="get_parrain")
  401.     */
  402.     public function get_parrain()
  403.     {
  404.         $name="";
  405.         $user = $this->getUser();
  407.         if( $user  && !in_array("ROLE_ADMIN", $user->getRoles())){
  408.             $infouser = $this->getDoctrine()->getRepository(Infousers::class)->findBy(["id_user"=>$user->getId()]);
  409.             if($infouser){
  410.                 $parent = $this->getDoctrine()->getRepository(Infousers::class)->find($infouser[0]->getIdParent());
  411.                 if($parent){
  412.                     $name=$parent->getNom();
  413.                 }
  414.             }
  415.         }
  416.         
  417.         return $this->render('admin/get_parrain.html.twig', [
  418.              'name'=> $name
  419.         ]);
  420.     }
  421.     public function login(Request $request,AuthenticationUtils $authenticationUtils): Response
  422.     {
  423.         if($request->get('sondage')){
  424.             $this->session->set('page_sondage', $request->get('sondage'));
  425.             $this->session->set('reponse_user_sondage', $request->get('user_sondage'));
  426.             $this->session->set('reponse_user_sondage_type', $request->get('user_sondage_type'));
  427.         }
  428.         if($request->get('enquete')){
  429.             $this->session->set('page_enquete', $request->get('enquete'));
  430.         }
  431.        
  432.         
  433.         
  434.         if ($this->getUser()) {
  435.              return $this->redirectToRoute('home');
  436.         }
  438.         // get the login error if there is one
  439.         $error = $authenticationUtils->getLastAuthenticationError();
  440.         // last username entered by the user
  441.         $lastUsername = $authenticationUtils->getLastUsername();
  443.         return $this->render('security/login.html.twig', ['last_username' => $lastUsername, 'error' => $error]);
  444.     }
  445.     
  446.     
  448.     public function logout()
  449.     {
  450.         
  451.         //throw new \LogicException('This method can be blank - it will be intercepted by the logout key on your firewall.');
  452.     }
  453.     
  454.     public function app_logout_user(Request $request)
  455.     {
  456.        
  457.         dd($request->get('token'));
  458.         
  459.     }
  460.     public function login_google(Request $request)
  461.     {
  462.         if ($this->getUser()) {
  463.              return $this->redirectToRoute('home');
  464.         }
  465.         $user = $this->getDoctrine()->getRepository(User::class)->findBy(["email" => $request->get("google_email")]);
  466.         if($user && sizeof($user)>0 ){
  467.             $user = $user[0];
  468.             if($user->getIdGoogle() == $request->get("google_id") ){
  469.                 $token = new UsernamePasswordToken($user, null, 'main', $user->getRoles());
  470.                 $this->get('security.token_storage')->setToken($token);
  471.                 $this->get('session')->set('_security_main', serialize($token));
  472.                 $entityManager = $this->getDoctrine()->getManager();
  473.                 $tokenuser = uniqid().$request->get('_csrf_token').uniqid();
  474.                 $AuthToken = new UsersAuthToken();
  475.                 $AuthToken->setIdUser($user->getId());
  476.                 $AuthToken->setToken($tokenuser);
  477.                 $AuthToken->setCreateAt(new \DateTime("now"));
  478.                 $AuthToken->setExpired(0);
  479.                 $entityManager->persist($AuthToken);
  480.                 $entityManager->flush();
  481.                 return $this->redirectToRoute('home',["token"=>$tokenuser]);
  482.             }else{
  483.                 return $this->redirectToRoute('app_login',['error' => "l'email google existe déjà"]);
  484.             }
  485.         }else{
  486.             return $this->redirectToRoute('add_user',[
  487.                 "email"=>$request->get("google_email"),
  488.                 "name"=>$request->get("google_name"),
  489.                 "prenom"=>$request->get("google_prenom"),
  490.                 "google_id"=>$request->get("google_id"),
  491.                 "login"=>$request->get("google_login"),
  492.                 "photo"=>$request->get("google_photo"),
  493.             ]);
  494.         }
  495.     }
  496.     public function login_facebook(Request $request)
  497.     {
  498.         if ($this->getUser()) {
  499.             return $this->redirectToRoute('home');
  500.         }
  501.         $user = $this->getDoctrine()->getRepository(User::class)->findBy(["email" => $request->get("fb_email")]);
  502.         if($user && sizeof($user)>0 ){
  503.             $user = $user[0];
  504.             if($user->getIdFacebook() == $request->get("fb_id") ){
  505.                 $token = new UsernamePasswordToken($user, null, 'main', $user->getRoles());
  506.                 $this->get('security.token_storage')->setToken($token);
  507.                 $this->get('session')->set('_security_main', serialize($token));
  508.                 $entityManager = $this->getDoctrine()->getManager();
  509.                 $tokenuser = uniqid().$request->get('_csrf_token').uniqid();
  510.                 $AuthToken = new UsersAuthToken();
  511.                 $AuthToken->setIdUser($user->getId());
  512.                 $AuthToken->setToken($tokenuser);
  513.                 $AuthToken->setCreateAt(new \DateTime("now"));
  514.                 $AuthToken->setExpired(0);
  515.                 $entityManager->persist($AuthToken);
  516.                 $entityManager->flush();
  517.                 return $this->redirectToRoute('home',["token"=>$tokenuser]);
  518.             }else{
  519.                 return $this->redirectToRoute('app_login',['error' => "l'email facebook existe déjà"]);
  520.             }
  521.         }else{
  522.             return $this->redirectToRoute('add_user',[
  523.                 "email"=>$request->get("fb_email"),
  524.                 "name"=>$request->get("fb_name"),
  525.                 "prenom"=>$request->get("fb_prenom"),
  526.                 "fb_id"=>$request->get("fb_id"),
  527.                 "login"=>$request->get("fb_login"),
  528.                 "photo"=>$request->get("fb_photo"),
  529.             ]);
  530.         }
  531.        
  532.     }
  533.     public function login_key_token(Request $request)
  534.     {
  535.         if ($request->get("login_key_token")!="") {
  536.             $token = $this->getDoctrine()->getRepository(UsersAuthToken::class)->findOneBy(["token" => $request->get("login_key_token")]);
  537.             if( $token ){
  538.                 $user = $this->getDoctrine()->getRepository(User::class)->find($token->getIdUser());
  539.                 $token = new UsernamePasswordToken($user, null, 'main', $user->getRoles());
  540.                 $this->get('security.token_storage')->setToken($token);
  541.                 $this->get('session')->set('_security_main', serialize($token));
  542.                 return new Response("connected"); 
  543.             }
  544.         }
  545.         return new Response("error"); 
  546.     }
  547.     
  549.     public function forgottenPassword(Request $request, UserPasswordEncoderInterface $encoder, MailerInterface $mailer, TokenGeneratorInterface $tokenGenerator,TranslatorInterface $translator): Response
  550.     {
  551.         if ($request->isMethod('POST')) {
  552.  
  553.             $email = $request->request->get('email');
  554.  
  555.             $entityManager = $this->getDoctrine()->getManager();
  556.             $user = $entityManager->getRepository(User::class)->findOneByEmail($email);
  557.  
  558.             if ($user === null) {
  559.                 $this->addFlash('danger', 'Email Inconnu, recommence !');
  560.                 return $this->redirectToRoute('app_forgotten_password');
  561.             }
  562.             $token = $tokenGenerator->generateToken();
  563.  
  564.             try{
  565.                 $user->setResetToken($token);
  566.                 $entityManager->flush();
  567.             } catch (\Exception $e) {
  568.                 $this->addFlash('warning', $e->getMessage());
  569.                 return $this->redirectToRoute('home');
  570.             }
  571.  
  572.             $url = $this->generateUrl('app_reset_password', array('token' => $token), UrlGeneratorInterface::ABSOLUTE_URL);
  573.             $infouser = $this->getDoctrine()->getRepository(Infousers::class)->findBy(['id_user'=>$user->getId()]);
  574.             $message = (new Email())
  575.                 ->from('noreply@e-sondage.com')
  576.                 ->to($user->getEmail())
  577.                 ->subject($translator->trans('Oubli de mot de passe - Réinisialisation'))
  578.                 ->text('Sending emails is fun again!')
  579.                 ->html($this->renderView('security/emails/resetPasswordMail.html.twig', ['user'=>$user,'infouser'=>$infouser[0],'url'=>$url ] ));
  580.             $mailer->send($message);
  581.  
  582.             $this->addFlash('notice', 'Mail envoyé, tu vas pouvoir te connecter à nouveau !');
  583.  
  584.             
  585.             return $this->redirectToRoute('valider_email',["type"=>"reset_password"]); 
  586.         }
  587.  
  588.         return $this->render('security/forgottenPassword.html.twig');
  589.     }
  590.  
  592.     public function resetPassword(Request $request, string $token, UserPasswordEncoderInterface $passwordEncoder)
  593.     {
  594.         $entityManager = $this->getDoctrine()->getManager();
  595.         $user = $entityManager->getRepository(User::class)->findOneBy(["reset_token"=>$token]);
  596.         /* @var $user User */
  597.         if ($user === null) {
  598.             $this->addFlash('danger', 'Mot de passe non reconnu');
  599.             return $this->redirectToRoute('home');
  600.         }
  601.         //Reset avec le mail envoyé
  602.         if ($request->isMethod('POST')) {
  603.             
  604.             $password = $passwordEncoder->encodePassword($user, $request->get('password'));
  605.             $user->setResetToken(null);
  606.             $entityManager->flush();
  607.             $entityManager->getRepository(User::class)->upgradePassword($user,$password);
  608.             // $user->setPassword($passwordEncoder->encodePassword($user, $request->get('password')));
  609.             // 
  610.  
  611.             $this->addFlash('notice', 'Mot de passe mis à jour !');
  612.  
  613.             return $this->redirectToRoute('app_login');
  615.         }else {
  616.             return $this->render('security/resetPassword.html.twig', ['token' => $token]);
  617.         }
  618.  
  619.     }
  620.     public function prepare_slider_home($long)
  621.     {
  622.         $sondages_slider = $this->getDoctrine()->getRepository(Sondage::class)->findBy(["top" => "on",'post_status' => 'publish'],['date_deb' => 'DESC']);
  623.         $enquetes_slider = $this->getDoctrine()->getRepository(Enquetes::class)->findBy(["top" => "on"],['id' => 'DESC']);
  624.         
  625.         foreach ($sondages_slider as $key => $slider) {
  626.             if ($long=="fr") {
  627.                 if( $slider->getLongSondage() =="ar" ){
  628.                     unset($sondages_slider[$key]);
  629.                 } 
  630.             }else{
  631.                  if( $slider->getLongSondage() =="fr" ){
  632.                     unset($sondages_slider[$key]);
  633.                 } 
  634.             }
  635.         }
  636.         foreach ($enquetes_slider as $key => $slider) {
  637.             if ($long=="fr") {
  638.                 if( $slider->getLongEnquete() =="ar" ){
  639.                     unset($enquetes_slider[$key]);
  640.                 } 
  641.             }else{
  642.                  if( $slider->getLongEnquete() =="fr" ){
  643.                     unset($enquetes_slider[$key]);
  644.                 } 
  645.             }
  646.         }
  647.         $slider_home=[];
  648.         foreach ($sondages_slider as $key => $sondage) {
  649.             $reponseUser= $this->getDoctrine()->getRepository(ReponseUser::class)->findBy(["id_sondage"=>$sondage->getId()]);
  650.             $reponseUser =sizeof($reponseUser);
  651.             $slider_home[]=[
  652.                 "id"=>$sondage->getId(),
  653.                 "name" => ($long=="fr") ? $sondage->getNameSondage() : $sondage->getArNameSondage() ,
  654.                 "categories" => $sondage->getCategories(),
  655.                 "image"=>$sondage->getImage(),
  656.                 "expirer"=>$sondage->getExpirer(),
  657.                 "dateFin" => $sondage->getDateFin(),
  658.                 "timeFin" => $sondage->getTimeFin(),
  659.                 "paye_sondage" => $sondage->getPayeSondage(),
  660.                 "slug" => ($long=="fr") ? $sondage->getSlugFr() : $sondage->getSlugAr() ,
  661.                 "nbvotes" => $reponseUser+$sondage->getVoteVartuel(),
  662.                 "nbcomments" => "0",
  663.                 "type" => "sondage"
  664.             ];
  665.         }
  666.         // foreach ($enquetes_slider as $key => $enquete) {
  667.         //     $slider_home[]=[
  668.         //         "id"=>$sondage->getId(),
  669.         //         "name" => ($long=="fr") ? $enquete->getNameEnquete() : $enquete->getArNameEnquete() ,
  670.         //         "categories" => $enquete->getCategories(),
  671.         //         "image"=>$enquete->getImage(),
  672.         //         "expirer"=>$enquete->getExpirer(),
  673.         //         "dateFin" => $enquete->getDateFin(),
  674.         //         "timeFin" => $enquete->getTimeFin(),
  675.         //         "paye_sondage" => $sondage->getPayeSondage(),
  676.         //         "slug" => ($long=="fr") ? $enquete->getSlugFr() : $enquete->getSlugAr() ,
  677.         //         "nbvotes" => "0",
  678.         //         "nbcomments" => "0",
  679.         //         "type" => "enquete"
  680.                 
  681.         //     ];
  682.         // }
  683.         $new_slider_home=[];
  684.         foreach ($slider_home as $key => $slider) {
  685.             $slider_s1=$slider_home[0];
  686.             try {
  687.                 if($slider_home[$key+1]){
  688.                     $slider_s1=$slider_home[$key+1];
  689.                 }
  690.             } catch (\Throwable $th) {}
  691.             $slider_s2=$slider_home[1];
  692.             try {
  693.                 if($slider_home[$key+2]){
  694.                     $slider_s2=$slider_home[$key+2];
  695.                 }
  696.             } catch (\Throwable $th) {}
  697.             $new_slider_home[]=[
  698.                 "slider_p" => $slider,
  699.                 "slider_s1" => $slider_s1,
  700.                 "slider_s2" => $slider_s2,
  701.             ];
  702.         }
  703.         //dd( $new_slider_home );
  704.         // $sondages_slider_old=[];
  705.         // foreach ($sondages_slider as $key => $slider) {
  706.         //     $sondages_slider_old[]=$slider;
  707.         // }
  708.         // $sondages_slider= $sondages_slider_old;
  709.         // $new_sondages_slider=[];  
  710.         // $i=0; 
  711.         // $block_sondages_slider=[]; 
  712.         
  713.         // foreach ($sondages_slider as $key => $slider) {
  714.         //     if ($i==0) {
  715.         //         $block_sondages_slider=[]; 
  716.         //     }
  717.         //     $block_sondages_slider [] = $slider;
  718.         //     $i++;
  719.         //     if ($i==3) {
  720.         //        $new_sondages_slider [] = $block_sondages_slider;
  721.         //        $i=0;
  722.         //     }
  723.         // }
  725.         // if ($i==2) {
  726.         //     $block_sondages_slider [] = $sondages_slider[0];
  727.         //     $new_sondages_slider [] = $block_sondages_slider;
  728.         // }
  729.         // if ($i==1) {
  730.         //     $block_sondages_slider [] = $sondages_slider[0];
  731.         //     $block_sondages_slider [] = $sondages_slider[1];
  732.         //     $new_sondages_slider [] = $block_sondages_slider;
  733.         // }
  734.         
  735.         return  $new_slider_home;
  736.        
  737.     }
  738.     
  739.     public function Categories(Request $request,$categorie)
  740.     {
  741.         if($request->getLocale()=="fr"){
  742.             $categorie_id = $this->getDoctrine()->getRepository(TypeSondage::class)->findBy(["slug"=>$categorie]);
  743.         }else{
  744.             $categorie_id = $this->getDoctrine()->getRepository(TypeSondage::class)->findBy(["ar_slug"=>$categorie]);
  745.         }
  746.         if(!$categorie_id){
  747.               if($request->getLocale()=="ar"){
  748.                 $categorie_id = $this->getDoctrine()->getRepository(TypeSondage::class)->findBy(["slug"=>$categorie]);
  749.             }else{
  750.                 $categorie_id = $this->getDoctrine()->getRepository(TypeSondage::class)->findBy(["ar_slug"=>$categorie]);
  751.             }           
  752.         }
  753.         if($categorie_id){
  754.             $categorie_id =$categorie_id[0];
  755.             $categorie_id = $categorie_id->getId();
  756.             $sondages = $this->getDoctrine()->getRepository(Sondage::class)->findBy(['post_status' => 'publish'],['date_deb' => 'DESC']);
  757.             $enquetes = $this->getDoctrine()->getRepository(Enquetes::class)->findBy([],['id' => 'DESC']);
  758.             $forums = $this->getDoctrine()->getRepository(Forums::class)->findBy([],['id' => 'DESC']);
  759.             if($request->getLocale()=="fr"){
  760.                 foreach ($sondages as $key => $sondage) {
  761.                     if( $sondage->getLongSondage() =="ar" ){
  762.                         unset($sondages[$key]);
  763.                     }else{
  764.                         if(!in_array($categorie_id, $sondage->getCategories())){
  765.                             unset($sondages[$key]);
  766.                         }
  767.                     }
  769.                 }
  770.                 foreach ($enquetes as $key => $enquete) {
  771.                     if( $enquete->getLongEnquete() =="ar" ){
  772.                         unset($enquetes[$key]);
  773.                     }else{
  774.                         if(!in_array($categorie_id, $enquete->getCategories())){
  775.                             unset($enquetes[$key]);
  776.                         }
  777.                     }
  779.                 }
  780.             }else{
  781.                 foreach ($sondages as $key => $sondage) {
  782.                     if( $sondage->getLongSondage() =="fr" ){
  783.                         unset($sondages[$key]);
  784.                     }else{
  785.                         if(!in_array($categorie_id, $sondage->getCategories())){
  786.                             unset($sondages[$key]);
  787.                         }
  788.                     }
  789.                 }
  790.                 foreach ($enquetes as $key => $enquete) {
  791.                     if( $enquete->getLongEnquete() =="fr" ){
  792.                         unset($enquetes[$key]);
  793.                     }else{
  794.                         if(!in_array($categorie_id, $enquete->getCategories())){
  795.                             unset($enquetes[$key]);
  796.                         }
  797.                     }
  799.                 }
  800.             }
  801.         }else{
  802.             $sondages = [] ;
  803.             $enquetes = [] ;
  804.             $forums = [] ;
  805.         }
  806.         $all=[];
  807.         foreach ($sondages as $key => &$sondage) {
  808.             $comments = $this->getDoctrine()->getRepository(Comment::class)->findBy(['id_sondage'=>$sondage->getId()]);
  809.             $sondage->{'nbcomments'} = sizeof($comments);
  810.             $reponseUser= $this->getDoctrine()->getRepository(ReponseUser::class)->findBy(["id_sondage"=>$sondage->getId()]);
  811.             $sondage->{'nbvotes'} = sizeof($reponseUser);
  812.             $sondage->{'namefr'} = $sondage->getNameSondage();
  813.             $sondage->{'namear'} = $sondage->getArNameSondage();
  814.             $sondage->{'slugfr'} = $sondage->getSlugFr();
  815.             $sondage->{'slugar'} = $sondage->getSlugAr();
  816.             $sondage->{'descriptionfr'} = $sondage->getDescriptionFr();
  817.             $sondage->{'descriptionar'} = $sondage->getDescriptionAr();
  818.             $sondage->{'typeall'} = "sondage";
  819.             $all[]= $sondage;
  820.         }
  821.         foreach ($enquetes as $key => &$enquete) {
  822.             //$comments = $this->getDoctrine()->getRepository(Comment::class)->findBy(['id_sondage'=>$sondage->getId()]);
  823.             $enquete->{'nbcomments'} = 0;//sizeof($comments);
  824.             //$reponseUser= $this->getDoctrine()->getRepository(ReponseUser::class)->findBy(["id_sondage"=>$sondage->getId()]);
  825.             $enquete->{'nbvotes'} = 0;//sizeof($reponseUser);
  826.             $enquete->{'namefr'} = $enquete->getNameEnquete();
  827.             $enquete->{'namear'} = $enquete->getArNameEnquete();
  828.             $enquete->{'slugfr'} = $enquete->getSlugFr();
  829.             $enquete->{'slugar'} = $enquete->getSlugAr();
  830.             $enquete->{'descriptionfr'} = $enquete->getDescriptionFr();
  831.             $enquete->{'descriptionar'} = $enquete->getDescriptionAr();
  832.             $enquete->{'typeall'} = "enquete";
  833.             $all[]= $enquete;
  834.         }
  835.         foreach ($forums as $key => &$forum) {
  836.             //$comments = $this->getDoctrine()->getRepository(Comment::class)->findBy(['id_sondage'=>$sondage->getId()]);
  837.             $forum->{'nbcomments'} = 0;//sizeof($comments);
  838.             //$reponseUser= $this->getDoctrine()->getRepository(ReponseUser::class)->findBy(["id_sondage"=>$sondage->getId()]);
  839.             $forum->{'nbvotes'} = 0;//sizeof($reponseUser);
  840.             $forum->{'namefr'} = $forum->getLibelle();
  841.             $forum->{'namear'} = $forum->getLibelle();
  842.             $forum->{'slugfr'} = $forum->getSlug();
  843.             $forum->{'slugar'} = $forum->getSlug();
  844.             $forum->{'descriptionfr'} = $forum->getDescription();
  845.             $forum->{'descriptionar'} = $forum->getDescription();
  846.             $forum->{'expirer'} = 0;
  847.             $forum->{'nbPoint'} = 0;
  848.             $forum->{'typeall'} = "forum";
  849.             $all[]= $forum;
  850.         }
  851.         
  854.         $categories = $this->getDoctrine()->getRepository(TypeSondage::class)->findAll();
  855.         $liste_categories=[];
  856.         foreach ($categories as $key => $value) {
  857.             $liste_categories[$value->getId()] = $value;
  858.         } 
  859.         
  860.         $categorie_name = $liste_categories[$categorie_id]->getLibelle();
  861.         if($request->getLocale()=="ar")
  862.             $categorie_name = $liste_categories[$categorie_id]->getArLibelle();
  863.         //dd($all);
  864.         return $this->render('liste-categories-all.html.twig', [
  865.             'controller_name'       => 'Home',
  866.             'categorie_id'        =>  $categorie_id,
  867.             'categorie'             => $categorie,
  868.             'all'              => $all,
  869.             'liste_categories'      => $liste_categories,
  870.             'categorie_name'       => $categorie_name
  871.           ]);
  872.     }
  873.      /**
  874.      * @Route("/change-locale/{locale}", name="change_locale")
  875.     */
  876.     public function changeLocale(Request $request,$locale)
  877.     {
  878.         $request->getSession()->set("_locale",$locale);
  879.         $url = $request->headers->get('referer');
  880.         $url = str_replace("/ar","/".$locale,$url);
  881.         $url = str_replace("/fr","/".$locale,$url); 
  882.         $ref = str_replace("app_dev.php/", "", parse_url( $url,PHP_URL_PATH ));
  883.         $route = $this->container->get('router')->match($ref)['_route'];
  885.         return $this->redirectToRoute($route);
  886.         //return $this->redirect( $url );
  887.     }
  888.     /**
  889.      * @Route("/{_locale}/typed_text", name="typed_text")
  890.     */
  891.     public function typed_text(Request $request)
  892.     {
  893.         return $this->render('typed_text.html.twig');
  894.     }
  895.     /**
  896.      * @Route("/{_locale}/pusher", name="pusher")
  897.     */
  898.     public function pusher(Request $request,Pusher $pusher)
  899.     {
  900.         $pusher->trigger('nb-votes-sondage', 'update', [
  901.             "id"=>55,
  902.             "nbVotes" => 366
  903.         ]);
  904.         return $this->render('typed_text.html.twig');
  905.     }
  908. }
  912.