src/Controller/WebsiteController.php line 393

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();
  34.         $versions_php = array();
  36.         foreach ($websites as $key => $website_infos) {
  37.             if($website_infos->getStatut() != 'archive') {
  38.                 $websitesNotArchive[] = $website_infos;
  39.                 if($website_infos->getVersionPhp() && !in_array($website_infos->getVersionPhp(),$versions_php)) 
  40.                     $versions_php[] = $website_infos->getVersionPhp();
  41.             }
  42.             if( !empty( $website_infos->getStats() ) && $website_infos->getStats() != "-"){
  43.                 $stats = unserialize($website_infos->getStats());
  44.                 $website_infos->setStatsArray($stats);
  45.             }
  46.         }
  47.         asort($versions_php);
  49.         // $last_line = system('curl -i -k -X GET -u publigo:Em~uh569 "https://ns3164592.ip-51-91-73.eu:8443/api/v2/domains"', $retval);
  50.         
  51.         // dd($last_line);
  53.         return $this->render('website/index.html.twig', [
  54.             'versions_php' => $versions_php,
  55.             'websites' => $websitesNotArchive,
  56.             'pageClass' => 'websites',
  57.             'controller_name' => 'WebsiteController',
  58.         ]);
  59.     }
  60.     /**
  61.      * @Route("/archive-website", name="archive_website")
  62.      */
  63.     public function archiveWebsite(Request $request): Response
  64.     {
  66.         $websites = $this->em->getRepository(Website::class)->findBy(array('statut' => 'archive'));
  68.         return $this->render('website/archive.html.twig', [
  69.             'websites' => $websites,
  70.             'pageClass' => 'websites',
  71.             'controller_name' => 'WebsiteController',
  72.         ]);
  73.     }
  75.     /**
  76.      * @Route("/add-website/{domain}/{subfolder}", methods={"GET"}, name="add_website")
  77.      */
  78.     public function addWebsite($domain, $subfolder = "")
  79.     {
  80.         $date_creation = new \DateTime('now');
  82.         $url_principal = ($subfolder != "") ? $domain.'/'.$subfolder : $domain ;
  84.         $website = new Website();
  85.         $website->setUrlPrincipal($url_principal);
  86.         $website->setDateCreation($date_creation);
  87.         $website->setCmsType('-');
  88.         $website->setCmsVersion('-');
  89.         $website->setServeur('-');
  90.         $website->setVersionPhp('-');
  91.         $website->setIsHttps(false);
  92.         $website->setIsRgpd(false);
  93.         $website->setStatut('en-cours');
  94.         $this->em->persist($website);
  95.         $this->em->flush();
  97.         $datas = $this->updateWebsite($domain);
  99.         $error = '';
  100.         if ($error != '') {
  101.             return new JsonResponse(['error' => $error], JsonResponse::HTTP_CREATED);
  102.         } else {
  103.             return new JsonResponse($datas, JsonResponse::HTTP_CREATED);      
  104.         }
  105.     }
  107.     /**
  108.      * @Route("/remove-website/{domain}/{subfolder}", methods={"GET"}, name="remove_website")
  109.      */
  110.     public function removeWebsite($domain, $subfolder = "")
  111.     {
  112.         $error = '';
  113.         $is_remove = false;
  114.         $url_principal = ($subfolder != "") ? $domain.'/'.$subfolder : $domain ;
  115.         $website = $this->em->getRepository(Website::class)->findOneBy( array("url_principal" => $url_principal));
  117.         if($website) {
  118.             $this->em->remove($website);
  119.             $this->em->flush();
  120.             $is_remove = true;
  121.         } else {
  122.             $error = 404;
  123.         }
  125.         if ($error != '') {
  126.             return new JsonResponse(['error' => $error], JsonResponse::HTTP_CREATED);
  127.         } else {
  128.             return new JsonResponse(['remove' => $is_remove], JsonResponse::HTTP_CREATED);
  129.         }
  130.     }
  132.     /**
  133.      * @Route("/change-website/{domain}/{subfolder}", methods={"GET"}, name="change_website")
  134.      */
  135.     public function changeWebsite($domain, $subfolder = "", Request $request)
  136.     {
  137.         $error = '';
  138.         $is_updated = false;
  139.         $url_principal = ($subfolder != "") ? $domain.'/'.$subfolder : $domain ;
  140.         $website = $this->em->getRepository(Website::class)->findOneBy( array("url_principal" => $url_principal));
  142.         if($website) {
  143.             $website->setStatut($request->query->get('status'));
  144.             if($request->query->get('status') == 'archive') {
  145.                 $today = new \DateTime('now');
  146.                 $website->setDateArchive($today);
  147.             }
  148.             $website->setStatut($request->query->get('status'));
  149.             $this->em->flush();
  150.             $is_updated = true;
  151.         } else {
  152.             $error = 404;
  153.         }
  155.         if ($error != '') {
  156.             return new JsonResponse(['error' => $error], JsonResponse::HTTP_CREATED);
  157.         } else {
  158.             return new JsonResponse(['updatedStatus' => $is_updated], JsonResponse::HTTP_CREATED);
  159.         }
  160.     }
  162.     /**
  163.      * @Route("/update-website/{domain}/{subfolder}", methods={"GET"}, name="update_website")
  164.      */
  165.     public function updateWebsite($domain, $subfolder = "", $is_wix = false)
  166.     {
  168.         $error = '';
  170.         $url_principal = ($subfolder != "") ? $domain.'/'.$subfolder : $domain ;
  171.         $suffix = ($is_wix === true) ? '' : 'publigo-website-infos.php' ;
  172.         
  173.         if(substr_count($url_principal, '.') == 1) $prefix = "www.";
  174.         elseif(substr_count($url_principal, '.') == 2) $prefix = "";
  176.         $website = $this->em->getRepository(Website::class)->findOneBy( array("url_principal" => $url_principal));
  177.         if(!$is_wix && $website && $website->getCmsType() == "Wix") {
  178.             $is_wix = true;
  179.             $suffix = '';
  180.         }
  182.         $statusCode = false;
  183.         $is_https = true;
  184.         try {
  185.             $response = $this->client->request(
  186.                 'GET',
  187.                 'https://'.$prefix.$url_principal.'/'.$suffix
  188.             );
  189.             $statusCode = $response->getStatusCode();
  191.         } catch (\Exception $e){
  193.             $is_https = false;
  195.             try {
  196.                 $response = $this->client->request(
  197.                     'GET',
  198.                     'http://'.$prefix.$url_principal.'/'.$suffix
  199.                 );
  200.                 $statusCode = $response->getStatusCode();
  202.             } catch (\Exception $e){
  204.                 $statusCode == $response->getStatusCode();
  205.             }
  206.         }
  208.         if($response->getStatusCode() == 200 && strpos(strtolower($response->getContent()),"wix") !== false) $is_wix = true;
  210.         if($is_wix) {
  212.             $datas = array(
  213.                 "is_active" => $website->getStatut(),
  214.                 "cms" => $website->getCmsType(),
  215.                 "version" => $website->getCmsVersion(),
  216.                 "created_date" => $website->getDateCreation()->format('Y-m-d'),
  217.                 "server_domain" => "Wix",
  218.                 "is_https" => $is_https,
  219.                 "php_version" => $website->getVersionPhp(),
  220.                 "is_rgpd" => (strpos(strtolower($response->getContent()),"rgpd") !== false) ? true : $website->isIsRgpd(),
  221.             );
  222.             $website->setServeur($datas['server_domain']);
  223.             $website->setIsHttps($datas['is_https']);
  224.             $website->setIsRgpd($datas['is_rgpd']);
  226.             if(strpos(strtolower($response->getContent()),"publigo") !== false
  227.                 || strpos(strtolower($response->getContent()),"39 laclergerie") !== false) 
  228.             {
  229.                 $datas['is_active'] = "actif";
  230.                 $website->setStatut('actif');
  231.             } else {
  232.                 $datas['is_active'] = "inactif";
  233.                 $website->setStatut('inactif');
  234.             }
  236.             $this->em->persist($website);
  237.             $this->em->flush();
  239.         } elseif(($statusCode == 500 || $statusCode == 503 || $statusCode == 403 || $statusCode == 520) && $website) {
  241.             $datas = array(
  242.                 "is_active" => "inactif",
  243.                 "cms" => $website->getCmsType(),
  244.                 "version" => $website->getCmsVersion(),
  245.                 "created_date" => $website->getDateCreation(),
  246.                 "server_domain" => $website->getServeur(),
  247.                 "is_https" => $website->isIsHttps(),
  248.                 "php_version" => $website->getVersionPhp(),
  249.                 "is_rgpd" => $website->isIsRgpd(),
  250.                 "size" => $website->getSize(),
  251.             );
  253.             $website->setStatut('inactif');
  254.             $this->em->persist($website);
  255.             $this->em->flush();
  257.         } elseif($statusCode != 404 && strpos($response->getContent(),"Gandi.net") === false && !$is_wix ) {
  259.             $datas = json_decode($response->getContent());
  261.             if(!is_object($datas)) dd($url_principal,$datas);
  263.             $date_creation = \DateTime::createFromFormat('Y-m-d', $datas->created_date);
  265.             $website->setDateCreation($date_creation);
  266.             $website->setCmsType($datas->cms);
  267.             $website->setCmsVersion($datas->version);
  268.             $website->setServeur($datas->server_domain);
  269.             $website->setVersionPhp($datas->php_version);
  270.             $website->setIsHttps($datas->is_https);
  271.             $website->setIsRgpd($datas->is_rgpd);
  272.             $website->setStatut($datas->is_active);
  273.             if(isset($datas->size)) $website->setSize($datas->size);
  274.             $this->em->persist($website);
  275.             $this->em->flush();
  277.         } else {
  279.             // $error = $statusCode;
  280.             $datas = json_decode('{"is_active":"inactif","cms":"-","version":"-","created_date":"-","server_domain":"-","is_https":false,"php_version":"-","is_rgpd":false,"size":null}');
  282.             $datas = array(
  283.                 "is_active" => "inactif",
  284.                 "cms" => $website->getCmsType(),
  285.                 "version" => $website->getCmsVersion(),
  286.                 "created_date" => $website->getDateCreation(),
  287.                 "server_domain" => $website->getServeur(),
  288.                 "is_https" => $website->isIsHttps(),
  289.                 "php_version" => $website->getVersionPhp(),
  290.                 "is_rgpd" => $website->isIsRgpd(),
  291.                 "size" => $website->getSize(),
  292.             );
  294.             $shema = $is_https ? "https" : "http" ;
  295.             try {
  296.                 $test = $this->client->request(
  297.                     'GET',
  298.                     $shema.'://'.$prefix.$url_principal.'/'
  299.                 );
  300.                 $statusCode = $test->getStatusCode();
  302.                 $ip_domain = gethostbyname($prefix.$url_principal);
  303.                 $server_domain = file_get_contents('https://www.publigo.fr/serveur-publigo.php?ip='.$ip_domain);
  305.                 if(strpos($test->getContent(),"<title>Site en cours de maintenance ou désactivé. Merci de votre compréhension.</title>") !== false 
  306.                     || $server_domain == ""
  307.                     ) {
  308.                         $website->setStatut('inactif');
  309.                         $this->em->persist($website);
  310.                         $this->em->flush();
  311.                 }
  312.             } catch (\Exception $e){
  313.                 dd($e);
  314.             }
  316.         }
  318.         // dd($website, $datas, $date_creation);
  320.         if ($error != '') {
  321.             return new JsonResponse(['error' => $error], JsonResponse::HTTP_CREATED);
  322.         } else {
  323.             return new JsonResponse($datas, JsonResponse::HTTP_CREATED);      
  324.         }
  325.     }
  327.     /**
  328.      * @Route("/check-ga3/", methods={"GET"}, name="check_ga3")
  329.      */
  330.     public function checkGa3()
  331.     {
  332.         $websites = $this->em->getRepository(Website::class)->findBy( array("statut" => 'actif'));
  333.         $websites_changed = array();
  334.         $error = '';
  335.         $subfolder = "";
  336.         $suffix = '';
  338.         foreach ($websites as $key => $website) {
  340.             if($website->getCmsType() != "Wix") {
  342.                 $domain = $website->getUrlPrincipal();
  344.                 $url_principal = ($subfolder != "") ? $domain.'/'.$subfolder : $domain ;
  345.                 
  346.                 if(substr_count($url_principal, '.') == 1) $prefix = "www.";
  347.                 elseif(substr_count($url_principal, '.') == 2) $prefix = "";
  349.                 $statusCode = false;
  350.                 $is_https = true;
  351.                 try {
  352.                     $response = $this->client->request(
  353.                         'GET',
  354.                         'https://'.$prefix.$url_principal.'/'.$suffix
  355.                     );
  356.                     $statusCode = $response->getStatusCode();
  358.                 } catch (\Exception $e){
  360.                     $is_https = false;
  362.                     try {
  363.                         $response = $this->client->request(
  364.                             'GET',
  365.                             'http://'.$prefix.$url_principal.'/'.$suffix
  366.                         );
  367.                         $statusCode = $response->getStatusCode();
  369.                     } catch (\Exception $e){
  371.                         $statusCode == $response->getStatusCode();
  372.                     }
  373.                 }
  376.                 if($statusCode == 200) $clean_content = str_replace('X-UA-', '', $response->getContent());
  377.                 if($statusCode == 200 && strpos(strtolower($clean_content),'ua-') ) {
  378.                     echo '<div>';
  379.                         echo '<a href="http://'.$url_principal.'" target="_blank">'.$url_principal.'</a> : '.$website->getCmsType()."<br>";
  380.                     echo '</div>';
  381.                 }
  383.             }
  385.         }
  386.         die();
  387.         return true;
  388.     }
  390.     /**
  391.      * @Route("/cron-website/", methods={"GET"}, name="cron_website")
  392.      */
  393.     public function cronWebsite()
  394.     {
  395.         $websites = $this->em->getRepository(Website::class)->findBy( array("statut" => 'actif'));
  396.         $websites_changed = array();
  397.         $error = '';
  399.         foreach ($websites as $key => $website) {
  400.             $datas_origine = json_encode( array(
  401.                 'is_active' => $website->getStatut(),
  402.                 'cms' => $website->getCmsType(),
  403.                 'version' => $website->getCmsVersion(),
  404.                 'created_date' => $website->getDateCreation()->format('Y-m-d'),
  405.                 'server_domain' => $website->getServeur(),
  406.                 'is_https' => $website->isIsHttps(),
  407.                 'php_version' => $website->getVersionPhp(),
  408.                 'is_rgpd' => $website->isIsRgpd(),
  409.                 'size' => $website->getSize(),
  410.             ));
  411.             $is_wix = ($website->getCmsType() == "Wix") ? true : false;
  412.             $datas_check = $this->updateWebsite($website->getUrlPrincipal(),'',$is_wix)->getContent();
  413.             if($datas_origine != $datas_check) $websites_changed[$website->getUrlPrincipal()] = $datas_check;
  415.             // sleep(1.5);
  416.         }
  418.         foreach ($websites_changed as $key => $website_changed) {
  419.             echo $key." : ".$website_changed."\n";
  420.         }
  422.         if ($error != '') {
  423.             return new JsonResponse(['error' => $error], JsonResponse::HTTP_CREATED);
  424.         } else {
  425.             // return new JsonResponse($websites_changed, JsonResponse::HTTP_CREATED);
  426.             return new JsonResponse(array(), JsonResponse::HTTP_CREATED);
  427.         }
  429.     }
  431. }