src/Controller/GraphController.php line 38

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use DateTime;
  6. use App\Entity\Site;
  7. use App\Repository\MeteoRepository;
  8. use App\Repository\PrevisMeteoRepository;
  9. use App\Repository\SiteRepository;
  10. use App\Service\PetitsOutils;
  11. use DateInterval;
  12. use Symfony\Component\HttpFoundation\Request;
  13. use Symfony\Component\HttpFoundation\Response;
  14. use Symfony\Component\Routing\Annotation\Route;
  15. use Symfony\Bridge\Doctrine\Form\Type\EntityType;
  16. use Symfony\Component\Form\Extension\Core\Type\TextType;
  17. use Symfony\Component\Form\Extension\Core\Type\SubmitType;
  18. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  20. class GraphController extends AbstractController
  21. {
  22.     private $petitsOutils;
  23.     private $siteRepository;
  24.     private $meteoRepository;
  25.     private $previsMeteoRepository;
  27.     public function __construct(PetitsOutils $petitsOutils, SiteRepository $siteRepository, MeteoRepository $meteoRepository, PrevisMeteoRepository $previsMeteoRepository )
  28.     {
  29.         $this->petitsOutils = $petitsOutils;
  30.         $this->siteRepository = $siteRepository;
  31.         $this->meteoRepository = $meteoRepository;
  32.         $this->previsMeteoRepository = $previsMeteoRepository;
  33.     }
  35.     /**
  36.      * @Route("/graph/dates",name="graph-dates")
  37.      */
  38.     public function choixDates(Request $request): Response
  39.     {
  40.         $route = 'graph';
  41.         $defaultData = [];
  42.         $form = $this->createFormBuilder($defaultData)
  43.         ->add('debut', TextType::class,array(
  44.             'label' =>"début",
  45.             'attr' => array(
  46.                 'class' => 'js-datepicker',
  47.             )))
  48.             ->add('fin', TextType::class,array(
  49.                 'label' =>"fin",
  50.                 'attr' => array(
  51.                     'class' => 'js-datepicker',
  52.                 )
  53.             ))
  54.             ->add('site',EntityType::class,array(
  55.                 'class'=>Site::class,
  57.             ))
  58.             ->add('ok', SubmitType::class)
  59.             ->getForm();
  61.         $form->handleRequest($request);
  63.         if($form->isSubmitted() && $form->isValid()){
  64.             $data = $form->getData();
  65.             $debut = $this->petitsOutils->frenchDateToEnglish($data['debut']);
  66.             
  67.             $fin = $this->petitsOutils->frenchDateToEnglish($data['fin']);
  68.             return $this->redirectToRoute($route,array(
  69.                 'debut'=>$debut,
  70.                 'fin'=>$fin,
  71.                 'site'=>$data['site']->getId()
  72.             ));
  73.         }
  74.         return $this->renderForm('graph/dates.html.twig', [
  75.             'form' => $form
  76.         ]);
  77.     }
  78.     /**
  79.      * @Route("/graph",name="graph")
  80.      */
  81.     public function graph(Request $request): Response
  82.     {
  83.         $debut = $request->query->get('debut');
  84.         $fin = $request->query->get('fin');
  85.         $siteId = $request->query->get('site');
  87.         $debut = new DateTime($debut);
  88.         $fin = new DateTime($fin);
  89.         $site = $this->siteRepository->find($siteId);
  91.         $pastdatas = $this->meteoRepository->findBetweenDatesForSite($debut,$fin,$site);
  92.         $previsdatas = $this->previsMeteoRepository->findBetweenDatesForSite($debut,$fin,$site);
  93.         //dd($previsdatas);
  94.         $datas = array_merge($pastdatas,$previsdatas);
  95.         usort($datas, function($a, $b)
  96.         {
  97.             return strcmp($a->getDate()->format('Y-m-d H'), $b->getDate()->format('Y-m-d H'));
  98.         });
  99.         //dd($datas);
  100.         //températures
  101.         $temp = array();
  102.         //pluvio
  103.         $pluie = array();
  104.         foreach($datas as $d){
  105.             $heure = $d->getDate();
  106.             
  107.             $stamp = strtotime($heure->format('Y-m-d H:i:00')); // get unix timestamp
  108.             $heure_in_ms = $stamp*1000;
  109.             $temp [] = array($heure_in_ms,floatval($d->getT()));
  110.             $pluie [] = array($heure_in_ms,floatval($d->getRR()));
  111.         }
  112.         $temp = json_encode($temp);
  113.         $pluie = json_encode($pluie);
  115.         return $this->render('/graph/index.html.twig',[
  116.             'site' => $site,
  117.             'temp' => $temp,
  118.             'pluie' => $pluie
  119.         ]);
  120.     }
  121. }