src/Controller/DashboardController.php line 23

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Alert;
  6. use App\Entity\AlertProduct;
  7. use App\Entity\Competitor;
  8. use App\Entity\CompetitorProduct;
  9. use App\Entity\PriceScraped;
  10. use DateInterval;
  11. use DateTime;
  12. use http\Env\Request;
  13. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  14. use Symfony\Component\HttpFoundation\JsonResponse;
  15. use Symfony\Component\HttpFoundation\Response;
  16. use Symfony\Component\Routing\Annotation\Route;
  18. class DashboardController extends AbstractController
  19. {
  20.     /**
  21.      * @Route("/", name="home")
  22.      */
  23.     public function index(): Response
  24.     {
  25.         $em = $this->getDoctrine()->getManager();
  26.         $interval = $this->lastScrapedCard();
  27.         $nbErrors = $this->countProductError();
  28.         $monitoredProduct = $em->getRepository(CompetitorProduct::class)->findMonitoredProducts();
  29.         $number_prices_scrapped = $this->countPriceScrap();
  30.         $compScrap = $this->countCompScrap();
  32.         if($monitoredProduct)
  33.             $monitoredProduct = count($monitoredProduct);
  34.         else
  35.             $monitoredProduct = 0;
  37.         return $this->render('dashboard/index.html.twig', [
  38.             'interval' => $interval,
  39.             'nbErrors' => $nbErrors,
  40.             'monitoredProduct' => $monitoredProduct,
  41.             'pricesScrapped' => $number_prices_scrapped,
  42.             'compScrap' => $compScrap
  43.         ]);
  44.     }
  46.     public function lastScrapedCard(): string
  47.     {
  48.         $em = $this->getDoctrine()->getManager();
  49.         $idLast =  $em->getRepository(PriceScraped::class)->findLastScrap();
  50.         $lastScrap = $em->getRepository(PriceScraped::class)->findOneBy(['id' => $idLast[0][1]]);
  52.         $dateLastScrap = $lastScrap->getDate();
  53.         $date = new DateTime('now');
  55.         $intervalDate = $dateLastScrap->diff($date);
  56.         $interval = ($intervalDate->h)*60 +  $intervalDate->i;
  57.         if($intervalDate->h > 0 || $intervalDate->i > 5){
  58.             return '<p class="uk-margin-remove-bottom uk-padding-small uk-padding-remove-bottom"><i class="fas fa-exclamation-triangle fa-xl uk-margin-small-right" style="color: orange"></i>Attention, il y a peut-être un caillou dans l\'engrenage :</p>
  59.                     <p class="uk-padding-small uk-padding-remove-top uk-margin-small-left">dernier prix relevé il y a '.$interval.' minutes</p>';
  60.         }else{
  61.             return '<p class="uk-padding-small"><i class="fas fa-check-circle fa-xl uk-margin-small-right" style="color: green"></i>La routourne tourne rond, dernier prix relevé à '.$dateLastScrap->format('h:i').' sur 
  62.             '.$em->getRepository(Competitor::class)->findOneBy(['competitor_id' => $lastScrap->getCompetitorId()])->getBrand().'</p>';
  63.         }
  64.     }
  66.     public function countProductError(): string
  67.     {
  68.         $em = $this->getDoctrine()->getManager();
  69.         $date = new DateTime('now');
  70.         $interval = $date->sub(new DateInterval('P7D'));
  71.         $products = $em->getRepository(PriceScraped::class)->findProductError($interval);
  72.         if ($products)
  73.             $nb_errors = '<p class="uk-padding-small"><i class="fas fa-exclamation-triangle fa-xl uk-margin-small-right" style="color: orange"></i>'.count($products).' Produits n\'ont pas pu être mis à jour</p>';
  74.         else
  75.             $nb_errors = '';
  77.         return $nb_errors;
  78.     }
  81.     public function countPriceScrap(){
  82.         $em = $this->getDoctrine()->getManager();
  83.         $date = new DateTime('now');
  84.         $intervalDate = $date->sub(new DateInterval('P7D'));
  85.         $pricesScrapped = $em->getRepository(PriceScraped::class)->findPriceScrap($intervalDate);
  87.         if($pricesScrapped)
  88.             return count($pricesScrapped);
  89.         else
  90.             return 0;
  91.     }
  93.     /**
  94.      * count the number of competitor activated
  95.      * @return int
  96.      */
  97.     public function countCompScrap(){
  98.         $em = $this->getDoctrine()->getManager();
  99.         $date = new DateTime('now');
  100.         $intervalDate = $date->sub(new DateInterval('P7D'));
  101.         $compScrap = $em->getRepository(PriceScraped::class)->findCompScrap($intervalDate);
  103.         if($compScrap)
  104.             return count($compScrap);
  105.         else
  106.             return 0;
  107.     }
  109.     /**
  110.      * construct table with all alerts
  111.      * @Route("/load/dashboardTable", name="dashboard_table")
  112.      */
  113.     public function constructTable(\Symfony\Component\HttpFoundation\Request $request){
  115.         $data = $request->request->all();
  116.         $em = $this->getDoctrine()->getManager();
  117.         $alerts = $em->getRepository(Alert::class)->findAll();
  119.         foreach($alerts as $alert){
  120.             $alert_table['icon'] = '<p class="uk-align-center">'.$alert->getIconLink().'</p>';
  121.             $alert_table['alert_level'] = '<p style="text-align: center">'.$alert->getAlertLevel().'</p>';
  122.             $alert_table['name'] = '<p class="uk-align-center">'.$alert->getMessage().'</p>';
  124.             $alerted_products = $em->getRepository(AlertProduct::class)->findBy(['alert_level' => $alert->getAlertLevel()]);
  125.             if($alerted_products){
  126.                 $number_products = count($alerted_products);
  127.             }else
  128.                 $number_products = 0;
  130.             $alert_table['number_products'] = '<p class="uk-align-center">'.$number_products.'</p>';
  131.             $alert_table['list_products'] = '<a href="https://pricedemo.romapps.com/comparativeTable/'.$alert->getAlertLevel().'" 
  132.                                                 class="uk-button uk-button-primary uk-margin-small-left uk-align-center">Voir produits</a>';
  134.             $alerts_table[] = $alert_table;
  135.         }
  137.         $json_alerts_table = json_encode($alerts_table);
  138.         $returnResponse = new JsonResponse($json_alerts_table);
  139.         $returnResponse->setJson($json_alerts_table);
  140.         return $returnResponse;
  141.     }
  142. }