static function calculateWindAllPrev(WebSite $allPrevWebSite, Spot $spot, EntityManager $em)
{
// Find dataWindPrev with allPrevWebsite and spot
$dataWindPrevAllPrev = $em->getRepository('LaPoizWindBundle:DataWindPrev')->getWithWebsiteAndSpot($allPrevWebSite, $spot);
// Delete all old data
AllPrevGetData::deleteOldData($dataWindPrevAllPrev, $em);
$arrayEveryDay = array();
// Pour chaque site de prevision remplis le tableau avec ses prévisions (vent, orientation)
foreach ($spot->getDataWindPrev() as $dataWindPrev) {
if ($dataWindPrev->getWebsite()->getNom() !== WebsiteGetData::allPrevName) {
foreach ($dataWindPrev->getListPrevisionDate() as $previsionDate) {
AllPrevGetData::getPrevisionValue($arrayEveryDay, $previsionDate, $dataWindPrev->getWebsite()->getNom());
}
}
}
// $arrayEveryDay['Y-m-d']['H']['wind/orient'][websiteName]
//$toto = $arrayEveryDay;
// Calcul la moyenne pour chaque heure (avec coef pour le spot)
foreach ($arrayEveryDay as $keyDate => $arrayHours) {
$previsionDate = new PrevisionDate();
$previsionDate->setDataWindPrev($dataWindPrevAllPrev);
$previsionDate->setDatePrev(new \DateTime($keyDate));
$previsionDate->setCreated(new \DateTime("now"));
$dataWindPrevAllPrev->addListPrevisionDate($previsionDate);
foreach ($arrayHours as $keyH => $arrayData) {
// $arrayData['wind/orient'][websiteName]
$nbWebsite = count($arrayData['wind']);
if ($nbWebsite > 0) {
$windTotal = 0;
foreach ($arrayData['wind'] as $keywebsiteName => $windValue) {
$windTotal += $windValue;
}
$orientTotal = 0;
foreach ($arrayData['orient'] as $keywebsiteName => $orientationValue) {
$orientTotal += $orientationValue;
}
$prevision = new Prevision();
$prevision->setOrientation($orientTotal / $nbWebsite);
// Ne marche pas autour de l'orientation NNE et NNO
$prevision->setWind($windTotal / $nbWebsite);
$hour = new \DateTime();
$hour->setTime($keyH, "00");
$prevision->setTime($hour);
$prevision->setPrevisionDate($previsionDate);
$em->persist($prevision);
}
}
$em->persist($previsionDate);
$em->persist($dataWindPrevAllPrev);
}
$em->flush();
}
protected function execute(InputInterface $input, OutputInterface $output)
{
$em = $this->getContainer()->get('doctrine.orm.entity_manager');
// récupere tous les spots
$listSpot = $em->getRepository('LaPoizWindBundle:Spot')->findAll();
$allPrevWebSite = $em->getRepository('LaPoizWindBundle:WebSite')->findWithName(WebsiteGetData::allPrevName);
foreach ($listSpot as $spot) {
$output->writeln('<info>*** Spot ' . $spot->getNom() . ' ***</info>');
// Find dataWindPrev with allPrevWebsite and spot
$dataWindPrevAllPrev = $em->getRepository('LaPoizWindBundle:DataWindPrev')->getWithWebsiteAndSpot($allPrevWebSite, $spot);
// Delete all old data
AllPrevGetData::deleteOldData($dataWindPrevAllPrev, $em);
// Construit un tableau avec toutes les heures pour les 7 prochains jours
// Pour chaque site de prevision remplis le tableau avec ses prévisions (vent, vents max, orientation)
// Pour chaque site remplis les cases vide en fonction des éléments remplis
// Calcul la moyenne pour chaque heure (avec coef pour le spot)
}
$em->flush();
}