function transformData($tableauData)
{
$cleanTabData = array();
$day = new \DateTime('NOW');
foreach ($tableauData as $date => $lineDayData) {
// 1 line = 1 date
if ($date != 'lastUpdate') {
$cleanElemDay = array();
foreach ($lineDayData as $key => $lineHoure) {
// 1 lineHoure = 1 hour
$cleanElemHoure = array();
$cleanElemHoure['heure'] = WindFinderGetData::getHoureClean($lineHoure["houre"]);
$cleanElemHoure['wind'] = $lineHoure['wind'];
$cleanElemHoure['maxWind'] = $lineHoure['windMax'];
$cleanElemHoure['temp'] = $lineHoure['temp'];
$cleanElemHoure['orientation'] = WindFinderGetData::getOrientationClean($lineHoure['orientation']);
$cleanElemDay[] = $cleanElemHoure;
}
$datePrev = WindFinderGetData::getDateClean($date);
$cleanTabData[$datePrev] = $cleanElemDay;
} else {
// lastUpdate
$cleanTabData['update'] = array(array(WindFinderGetData::getLastUpdateClean($lineDayData[0][0])));
}
}
return $cleanTabData;
}
function saveData($tableauData, $dataWindPrev, $entityManager)
{
// $tableauData
// 2011-12-05 -> 13=>[wind=>17.5|orientation=>NNO...] | 19=>[wind=>12|orientation=>NO...] | 22=>...
$now = new \DateTime("now");
$result = array();
foreach ($tableauData as $date => $lineWindData) {
if ($date !== 'update') {
$prevDate = new PrevisionDate();
$prevDate->setCreated($now);
$prevDate->setDatePrev(new \DateTime($date));
$windCalculate = array("max" => 0, "min" => 0, "cumul" => 0, "nbPrev" => 0);
foreach ($lineWindData as $dataPrev) {
if (isset($dataPrev["wind"]) && !empty($dataPrev["wind"]) && strlen($dataPrev["wind"]) > 0) {
$prev = new Prevision();
$prev->setOrientation($dataPrev["orientation"]);
$prev->setWind($dataPrev["wind"]);
$hour = new \DateTime();
if (isset($dataPrev["heure"]) && !empty($dataPrev["heure"]) && strlen($dataPrev["heure"]) > 0) {
$hour->setTime($dataPrev["heure"], "00");
} else {
$hour->setTime("01", "00");
}
$prev->setTime($hour);
if (isset($dataPrev["meteo"])) {
$prev->setMeteo($dataPrev["meteo"]);
}
if (isset($dataPrev["precipitation"])) {
$prev->setPrecipitation($dataPrev["precipitation"]);
}
if (isset($dataPrev["temp"])) {
$prev->setTemp($dataPrev["temp"]);
}
WindFinderGetData::calculateWind($windCalculate, $prev);
$prev->setPrevisionDate($prevDate);
$prevDate->addListPrevision($prev);
$entityManager->persist($prevDate);
$entityManager->persist($prev);
//$entityManager->flush(); // car sinon les éléments ne sont pas obligatoirement enregistrer dans l'ordre des heures
}
}
//TODO: calculate average etc...
$prevDate->setWindAverage(0);
if ($windCalculate["nbPrev"] > 0) {
$prevDate->setWindAverage($windCalculate["max"] / $windCalculate["nbPrev"]);
}
$prevDate->setWindMax($windCalculate["max"]);
$prevDate->setWindMin($windCalculate["min"]);
$prevDate->setWindGauss(0);
$prevDate->setWindMiddle(0);
$prevDate->setDataWindPrev($dataWindPrev);
$dataWindPrev->addListPrevisionDate($prevDate);
$entityManager->persist($prevDate);
$entityManager->flush();
$result[] = $prevDate;
} else {
// last update
if (isset($lineWindData[0]) && isset($lineWindData[0][0])) {
try {
$dataWindPrev->setLastUpdate(new \DateTime($lineWindData[0][0]));
} catch (\Exception $e) {
// DO nothing
}
}
}
}
//$entityManager->persist($dataWindPrev);
//$entityManager->flush();
return $result;
}
