src/Controller/WebsiteController.php line 29

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Website;
  6. use Doctrine\ORM\EntityManagerInterface;
  8. use Symfony\Contracts\HttpClient\HttpClientInterface;
  9. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  10. use Symfony\Component\HttpFoundation\Response;
  11. use Symfony\Component\HttpFoundation\Request;
  12. use Symfony\Component\Routing\Annotation\Route;
  13. use Symfony\Component\HttpFoundation\JsonResponse;
  14. use Symfony\Component\Validator\Constraints\DateTime;
  16. class WebsiteController extends AbstractController
  17. {
  19.     private $em;
  21.     public function __construct(EntityManagerInterface $em, HttpClientInterface $client)
  22.     {
  23.         $this->em = $em;
  24.         $this->client = $client;
  25.     }
  26.     /**
  27.      * @Route("/website", name="app_website")
  28.      */
  29.     public function index(Request $request): Response
  30.     {
  32.         $websites = $this->em->getRepository(Website::class)->findAll();
  33.         $websitesNotArchive = array();
  35.         foreach ($websites as $key => $website_infos) {
  36.             if($website_infos->getStatut() != 'archive') {
  37.                 $websitesNotArchive[] = $website_infos;
  38.             }
  39.             if( !empty( $website_infos->getStats() ) && $website_infos->getStats() != "-"){
  40.                 $stats = unserialize($website_infos->getStats());
  41.                 $website_infos->setStatsArray($stats);
  42.             }
  43.         }
  45.         // $last_line = system('curl -i -k -X GET -u publigo:Em~uh569 "https://ns3164592.ip-51-91-73.eu:8443/api/v2/domains"', $retval);
  46.         
  47.         // dd($last_line);
  49.         return $this->render('website/index.html.twig', [
  50.             'websites' => $websitesNotArchive,
  51.             'pageClass' => 'websites',
  52.             'controller_name' => 'WebsiteController',
  53.         ]);
  54.     }
  55.     /**
  56.      * @Route("/archive-website", name="archive_website")
  57.      */
  58.     public function archiveWebsite(Request $request): Response
  59.     {
  61.         $websites = $this->em->getRepository(Website::class)->findBy(array('statut' => 'archive'));
  63.         return $this->render('website/archive.html.twig', [
  64.             'websites' => $websites,
  65.             'pageClass' => 'websites',
  66.             'controller_name' => 'WebsiteController',
  67.         ]);
  68.     }
  70.     /**
  71.      * @Route("/add-website/{domain}/{subfolder}", methods={"GET"}, name="add_website")
  72.      */
  73.     public function addWebsite($domain, $subfolder = "")
  74.     {
  75.         $date_creation = new \DateTime('now');
  77.         $url_principal = ($subfolder != "") ? $domain.'/'.$subfolder : $domain ;
  79.         $website = new Website();
  80.         $website->setUrlPrincipal($url_principal);
  81.         $website->setDateCreation($date_creation);
  82.         $website->setCmsType('-');
  83.         $website->setCmsVersion('-');
  84.         $website->setServeur('-');
  85.         $website->setVersionPhp('-');
  86.         $website->setIsHttps(false);
  87.         $website->setIsRgpd(false);
  88.         $website->setStatut('en-cours');
  89.         $this->em->persist($website);
  90.         $this->em->flush();
  92.         $datas = $this->updateWebsite($domain);
  94.         $error = '';
  95.         if ($error != '') {
  96.             return new JsonResponse(['error' => $error], JsonResponse::HTTP_CREATED);
  97.         } else {
  98.             return new JsonResponse($datas, JsonResponse::HTTP_CREATED);      
  99.         }
  100.     }
  102.     /**
  103.      * @Route("/remove-website/{domain}/{subfolder}", methods={"GET"}, name="remove_website")
  104.      */
  105.     public function removeWebsite($domain, $subfolder = "")
  106.     {
  107.         $error = '';
  108.         $is_remove = false;
  109.         $url_principal = ($subfolder != "") ? $domain.'/'.$subfolder : $domain ;
  110.         $website = $this->em->getRepository(Website::class)->findOneBy( array("url_principal" => $url_principal));
  112.         if($website) {
  113.             $this->em->remove($website);
  114.             $this->em->flush();
  115.             $is_remove = true;
  116.         } else {
  117.             $error = 404;
  118.         }
  120.         if ($error != '') {
  121.             return new JsonResponse(['error' => $error], JsonResponse::HTTP_CREATED);
  122.         } else {
  123.             return new JsonResponse(['remove' => $is_remove], JsonResponse::HTTP_CREATED);
  124.         }
  125.     }
  127.     /**
  128.      * @Route("/change-website/{domain}/{subfolder}", methods={"GET"}, name="change_website")
  129.      */
  130.     public function changeWebsite($domain, $subfolder = "", Request $request)
  131.     {
  132.         $error = '';
  133.         $is_updated = false;
  134.         $url_principal = ($subfolder != "") ? $domain.'/'.$subfolder : $domain ;
  135.         $website = $this->em->getRepository(Website::class)->findOneBy( array("url_principal" => $url_principal));
  137.         if($website) {
  138.             $website->setStatut($request->query->get('status'));
  139.             if($request->query->get('status') == 'archive') {
  140.                 $today = new \DateTime('now');
  141.                 $website->setDateArchive($today);
  142.             }
  143.             $website->setStatut($request->query->get('status'));
  144.             $this->em->flush();
  145.             $is_updated = true;
  146.         } else {
  147.             $error = 404;
  148.         }
  150.         if ($error != '') {
  151.             return new JsonResponse(['error' => $error], JsonResponse::HTTP_CREATED);
  152.         } else {
  153.             return new JsonResponse(['updatedStatus' => $is_updated], JsonResponse::HTTP_CREATED);
  154.         }
  155.     }
  157.     /**
  158.      * @Route("/update-website/{domain}/{subfolder}", methods={"GET"}, name="update_website")
  159.      */
  160.     public function updateWebsite($domain, $subfolder = "", $is_wix = false)
  161.     {
  163.         $error = '';
  165.         $url_principal = ($subfolder != "") ? $domain.'/'.$subfolder : $domain ;
  166.         $suffix = ($is_wix === true) ? '' : 'publigo-website-infos.php' ;
  167.         
  168.         if(substr_count($url_principal, '.') == 1) $prefix = "www.";
  169.         elseif(substr_count($url_principal, '.') == 2) $prefix = "";
  171.         $website = $this->em->getRepository(Website::class)->findOneBy( array("url_principal" => $url_principal));
  172.         if(!$is_wix && $website && $website->getCmsType() == "Wix") {
  173.             $is_wix = true;
  174.             $suffix = '';
  175.         }
  177.         $statusCode = false;
  178.         $is_https = true;
  179.         try {
  180.             $response = $this->client->request(
  181.                 'GET',
  182.                 'https://'.$prefix.$url_principal.'/'.$suffix
  183.             );
  184.             $statusCode = $response->getStatusCode();
  186.         } catch (\Exception $e){
  188.             $is_https = false;
  190.             try {
  191.                 $response = $this->client->request(
  192.                     'GET',
  193.                     'http://'.$prefix.$url_principal.'/'.$suffix
  194.                 );
  195.                 $statusCode = $response->getStatusCode();
  197.             } catch (\Exception $e){
  199.                 $statusCode == $response->getStatusCode();
  200.             }
  201.         }
  203.         if($response->getStatusCode() == 200 && strpos(strtolower($response->getContent()),"wix") !== false) $is_wix = true;
  205.         if($is_wix) {
  207.             $datas = array(
  208.                 "is_active" => $website->getStatut(),
  209.                 "cms" => $website->getCmsType(),
  210.                 "version" => $website->getCmsVersion(),
  211.                 "created_date" => $website->getDateCreation()->format('Y-m-d'),
  212.                 "server_domain" => "Wix",
  213.                 "is_https" => $is_https,
  214.                 "php_version" => $website->getVersionPhp(),
  215.                 "is_rgpd" => (strpos(strtolower($response->getContent()),"rgpd") !== false) ? true : $website->isIsRgpd(),
  216.             );
  217.             $website->setServeur($datas['server_domain']);
  218.             $website->setIsHttps($datas['is_https']);
  219.             $website->setIsRgpd($datas['is_rgpd']);
  221.             if(strpos(strtolower($response->getContent()),"publigo") !== false
  222.                 || strpos(strtolower($response->getContent()),"39 laclergerie") !== false) 
  223.             {
  224.                 $datas['is_active'] = "actif";
  225.                 $website->setStatut('actif');
  226.             } else {
  227.                 $datas['is_active'] = "inactif";
  228.                 $website->setStatut('inactif');
  229.             }
  231.             $this->em->persist($website);
  232.             $this->em->flush();
  234.         } elseif(($statusCode == 500 || $statusCode == 503 || $statusCode == 403 || $statusCode == 520) && $website) {
  236.             $datas = array(
  237.                 "is_active" => "inactif",
  238.                 "cms" => $website->getCmsType(),
  239.                 "version" => $website->getCmsVersion(),
  240.                 "created_date" => $website->getDateCreation(),
  241.                 "server_domain" => $website->getServeur(),
  242.                 "is_https" => $website->isIsHttps(),
  243.                 "php_version" => $website->getVersionPhp(),
  244.                 "is_rgpd" => $website->isIsRgpd(),
  245.                 "size" => $website->getSize(),
  246.             );
  248.             $website->setStatut('inactif');
  249.             $this->em->persist($website);
  250.             $this->em->flush();
  252.         } elseif($statusCode != 404 && strpos($response->getContent(),"Gandi.net") === false && !$is_wix ) {
  254.             $datas = json_decode($response->getContent());
  256.             $date_creation = \DateTime::createFromFormat('Y-m-d', $datas->created_date);
  258.             $website->setDateCreation($date_creation);
  259.             $website->setCmsType($datas->cms);
  260.             $website->setCmsVersion($datas->version);
  261.             $website->setServeur($datas->server_domain);
  262.             $website->setVersionPhp($datas->php_version);
  263.             $website->setIsHttps($datas->is_https);
  264.             $website->setIsRgpd($datas->is_rgpd);
  265.             $website->setStatut($datas->is_active);
  266.             if($datas->size) $website->setSize($datas->size);
  267.             $this->em->persist($website);
  268.             $this->em->flush();
  270.         } else {
  272.             // $error = $statusCode;
  273.             $datas = json_decode('{"is_active":"inactif","cms":"-","version":"-","created_date":"-","server_domain":"-","is_https":false,"php_version":"-","is_rgpd":false,"size":null}');
  275.             $datas = array(
  276.                 "is_active" => "inactif",
  277.                 "cms" => $website->getCmsType(),
  278.                 "version" => $website->getCmsVersion(),
  279.                 "created_date" => $website->getDateCreation(),
  280.                 "server_domain" => $website->getServeur(),
  281.                 "is_https" => $website->isIsHttps(),
  282.                 "php_version" => $website->getVersionPhp(),
  283.                 "is_rgpd" => $website->isIsRgpd(),
  284.                 "size" => $website->getSize(),
  285.             );
  287.             $shema = $is_https ? "https" : "http" ;
  288.             try {
  289.                 $test = $this->client->request(
  290.                     'GET',
  291.                     $shema.'://'.$prefix.$url_principal.'/'
  292.                 );
  293.                 $statusCode = $test->getStatusCode();
  295.                 $ip_domain = gethostbyname($prefix.$url_principal);
  296.                 $server_domain = file_get_contents('https://www.publigo.fr/serveur-publigo.php?ip='.$ip_domain);
  298.                 if(strpos($test->getContent(),"<title>Site en cours de maintenance ou désactivé. Merci de votre compréhension.</title>") !== false 
  299.                     || $server_domain == ""
  300.                     ) {
  301.                         $website->setStatut('inactif');
  302.                         $this->em->persist($website);
  303.                         $this->em->flush();
  304.                 }
  305.             } catch (\Exception $e){
  306.                 dd($e);
  307.             }
  309.         }
  311.         // dd($website, $datas, $date_creation);
  313.         if ($error != '') {
  314.             return new JsonResponse(['error' => $error], JsonResponse::HTTP_CREATED);
  315.         } else {
  316.             return new JsonResponse($datas, JsonResponse::HTTP_CREATED);      
  317.         }
  318.     }
  320.     /**
  321.      * @Route("/check-ga3/", methods={"GET"}, name="check_ga3")
  322.      */
  323.     public function checkGa3()
  324.     {
  325.         $websites = $this->em->getRepository(Website::class)->findBy( array("statut" => 'actif'));
  326.         $websites_changed = array();
  327.         $error = '';
  328.         $subfolder = "";
  329.         $suffix = '';
  331.         foreach ($websites as $key => $website) {
  333.             if($website->getCmsType() != "Wix") {
  335.                 $domain = $website->getUrlPrincipal();
  337.                 $url_principal = ($subfolder != "") ? $domain.'/'.$subfolder : $domain ;
  338.                 
  339.                 if(substr_count($url_principal, '.') == 1) $prefix = "www.";
  340.                 elseif(substr_count($url_principal, '.') == 2) $prefix = "";
  342.                 $statusCode = false;
  343.                 $is_https = true;
  344.                 try {
  345.                     $response = $this->client->request(
  346.                         'GET',
  347.                         'https://'.$prefix.$url_principal.'/'.$suffix
  348.                     );
  349.                     $statusCode = $response->getStatusCode();
  351.                 } catch (\Exception $e){
  353.                     $is_https = false;
  355.                     try {
  356.                         $response = $this->client->request(
  357.                             'GET',
  358.                             'http://'.$prefix.$url_principal.'/'.$suffix
  359.                         );
  360.                         $statusCode = $response->getStatusCode();
  362.                     } catch (\Exception $e){
  364.                         $statusCode == $response->getStatusCode();
  365.                     }
  366.                 }
  369.                 if($statusCode == 200) $clean_content = str_replace('X-UA-', '', $response->getContent());
  370.                 if($statusCode == 200 && strpos(strtolower($clean_content),'ua-') ) {
  371.                     echo '<div>';
  372.                         echo '<a href="http://'.$url_principal.'" target="_blank">'.$url_principal.'</a> : '.$website->getCmsType()."<br>";
  373.                     echo '</div>';
  374.                 }
  376.             }
  378.         }
  379.         die();
  380.         return true;
  381.     }
  383.     /**
  384.      * @Route("/cron-website/", methods={"GET"}, name="cron_website")
  385.      */
  386.     public function cronWebsite()
  387.     {
  388.         $websites = $this->em->getRepository(Website::class)->findBy( array("statut" => 'actif'));
  389.         $websites_changed = array();
  390.         $error = '';
  392.         foreach ($websites as $key => $website) {
  393.             $datas_origine = json_encode( array(
  394.                 'is_active' => $website->getStatut(),
  395.                 'cms' => $website->getCmsType(),
  396.                 'version' => $website->getCmsVersion(),
  397.                 'created_date' => $website->getDateCreation()->format('Y-m-d'),
  398.                 'server_domain' => $website->getServeur(),
  399.                 'is_https' => $website->isIsHttps(),
  400.                 'php_version' => $website->getVersionPhp(),
  401.                 'is_rgpd' => $website->isIsRgpd(),
  402.                 'size' => $website->getSize(),
  403.             ));
  404.             $is_wix = ($website->getCmsType() == "Wix") ? true : false;
  405.             $datas_check = $this->updateWebsite($website->getUrlPrincipal(),'',$is_wix)->getContent();
  406.             if($datas_origine != $datas_check) $websites_changed[$website->getUrlPrincipal()] = $datas_check;
  408.             // sleep(1.5);
  409.         }
  411.         foreach ($websites_changed as $key => $website_changed) {
  412.             echo $key." : ".$website_changed."\n";
  413.         }
  415.         if ($error != '') {
  416.             return new JsonResponse(['error' => $error], JsonResponse::HTTP_CREATED);
  417.         } else {
  418.             // return new JsonResponse($websites_changed, JsonResponse::HTTP_CREATED);
  419.             return new JsonResponse(array(), JsonResponse::HTTP_CREATED);
  420.         }
  422.     }
  424. }