/**
* @Template()
*
* http://localhost/Wind/web/app_dev.php/admin/BO/ajax/spot/save/nbHoureNav/1
*/
public function saveNbHoureNavAction($id = null)
{
$em = $this->container->get('doctrine.orm.entity_manager');
$spot = $em->find('LaPoizWindBundle:Spot', $id);
if (!$spot) {
return $this->render('LaPoizWindBundle:Default:errorBlock.html.twig', array('errMessage' => "Spot not find !"));
}
list($tabDataNbHoureNav, $tabDataMeteo) = NbHoureNav::createTabNbHoureNav($spot, $em);
$tabNbHoureNav = NbHoureNav::calculateNbHourNav($tabDataNbHoureNav);
$tabMeteo = NbHoureMeteo::calculateMeteoNav($tabDataMeteo);
// Save nbHoure on spot
foreach ($tabNbHoureNav as $keyDate => $tabWebSite) {
foreach ($tabWebSite as $keyWebSite => $nbHoureNav) {
$noteDates = ManageNote::getNotesDate($spot, \DateTime::createFromFormat('Y-m-d', $keyDate), $em);
$nbHoureNavObj = ManageNote::getNbHoureNav($noteDates, $keyWebSite, $em);
$nbHoureNavObj->setNbHoure($nbHoureNav);
$em->persist($nbHoureNavObj);
$em->persist($noteDates);
}
}
// Save meteo
foreach ($tabMeteo as $keyDate => $tabMeteoDay) {
$noteDates = ManageNote::getNotesDate($spot, \DateTime::createFromFormat('Y-m-d', $keyDate), $em);
$noteDates->setTempMax($tabMeteoDay["tempMax"]);
$noteDates->setTempMin($tabMeteoDay["tempMin"]);
$noteDates->setMeteoBest($tabMeteoDay["meteoBest"]);
$noteDates->setMeteoWorst($tabMeteoDay["meteoWorst"]);
$em->persist($noteDates);
}
$em->flush();
return $this->render('LaPoizWindBundle:BackOffice/Test:nbHoureNav.html.twig', array('spot' => $spot, 'tabNbHoure' => $tabNbHoureNav, 'tabMeteo' => $tabMeteo, 'message' => "", 'saveSuccess' => true));
}
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();
foreach ($listSpot as $spot) {
$output->writeln('<info>Note du Spot ' . $spot->getNom() . ' - </info>');
// On efface les vielles notes (avant aujourd'hui)
ManageNote::deleteOldData($spot, $em);
list($tabDataNbHoureNav, $tabDataMeteo) = NbHoureNav::createTabNbHoureNav($spot, $em);
$tabNbHoureNav = NbHoureNav::calculateNbHourNav($tabDataNbHoureNav);
$output->writeln('<info> *** Nb Heure nav ***</info>');
// Save nbHoure on spot
foreach ($tabNbHoureNav as $keyDate => $tabWebSite) {
$output->writeln('<info>' . $keyDate . ': ');
$nbHoureNavCalc = 0;
$nbSiteCalc = 0;
foreach ($tabWebSite as $keyWebSite => $nbHoureNav) {
$output->writeln('<info> ' . $keyWebSite . ' : ' . $nbHoureNav . '</info> ');
$noteDates = ManageNote::getNotesDate($spot, \DateTime::createFromFormat('Y-m-d', $keyDate), $em);
$nbHoureNavObj = ManageNote::getNbHoureNav($noteDates, $keyWebSite, $em);
$nbHoureNavObj->setNbHoure($nbHoureNav);
$em->persist($nbHoureNavObj);
$em->persist($noteDates);
if ($nbHoureNav > 0) {
$nbSiteCalc++;
$nbHoureNavCalc += $nbHoureNav;
}
}
if ($nbSiteCalc > 0) {
$output->writeln('<info> ' . $keyDate . ' : ' . $nbHoureNavCalc . ' / ' . $nbSiteCalc . ' = ' . $nbHoureNavCalc / $nbSiteCalc . '</info> ');
$noteDates->setNbHoureNavCalc($nbHoureNavCalc / $nbSiteCalc);
$em->persist($noteDates);
}
}
$output->writeln('<info> *** Meteo ***</info>');
// Save meteo
$tabMeteo = NbHoureMeteo::calculateMeteoNav($tabDataMeteo);
foreach ($tabMeteo as $keyDate => $tabMeteoDay) {
$output->writeln('<info> Calcule Meteo of ' . $keyDate . '</info> ');
$noteDates = ManageNote::getNotesDate($spot, \DateTime::createFromFormat('Y-m-d', $keyDate), $em);
$noteDates->setTempMax($tabMeteoDay["tempMax"]);
$noteDates->setTempMin($tabMeteoDay["tempMin"]);
$noteDates->setMeteoBest($tabMeteoDay["meteoBest"]);
$noteDates->setMeteoWorst($tabMeteoDay["meteoWorst"]);
$em->persist($noteDates);
}
$output->writeln('<info> *** T C de l eau ***</info>');
//********** Température de l'eau **********
try {
$tabTempWater = null;
$tabTempWater = TempWaterGetData::getTempWaterFromSpot($spot, $output);
} catch (\Exception $e) {
$output->writeln('<warn>' . $e->getMessage() . '</warn>');
$output->writeln('<warn> * End Warn * </warn>');
}
if ($tabTempWater != null) {
$currentDay = new \DateTime("now");
foreach ($tabTempWater as $numJourFromToday => $tempWater) {
$noteDates = ManageNote::getNotesDate($spot, clone $currentDay, $em);
$noteDates->setTempWater($tempWater);
$em->persist($noteDates);
$currentDay = date_add($currentDay, new \DateInterval('P1D'));
// Jour suivant
}
}
$output->writeln('<info>******************************</info>');
}
$em->flush();
}