DB::dbClose();
foreach ($data as $item) {
$id_pool = $item['id'];
$name = $item['name'];
$toUpdate = $item['toUpdate'];
$id_saison = $item['saison'];
if ($toUpdate != 'Y') {
writelog($logFile, strtoupper($name), "toUpdate of pool '{$name}' (id={$id_pool}) is set to 'N'");
continue;
}
writelog($logFile, strtoupper($name), "Pool {$name} ({$id_pool})");
DB::dbConnect(strtolower($name));
$periode = $upd->getPeriode($id_pool, $id_saison, $today);
$next_per = $periode + 1;
$nbre_per = $upd->getNombrePeriodes($id_pool, $id_saison);
$dates = $upd->getPeriodeDates($id_pool, $id_saison, $periode);
$date_begin_per = $dates['date_begin'];
$date_end_per = $dates['date_end'];
unset($dates);
$dates = $upd->getPeriodeDates($id_pool, $id_saison, $periode + 1);
$dateNews = $dates['date_begin'];
// l'update se fait seulement lors de la dernière journée de la période courante.
if ($date_end_per != $today) {
writelog($logFile, strtoupper($name), "Today is not the last day of the period. No update will be done.");
DB::dbClose();
continue;
}
// on va chercher les ballotages de la période courante.
$q = "SELECT id,id_gerant,id_player,nbre_oui\n FROM ballotage\n WHERE id_pool = {$id_pool}\n AND date_debut >= '{$date_begin_per}'\n AND date_fin <= '{$date_end_per}'\n AND saison_id = {$id_saison}";
$data = DB::dbSelect($q);
if (count($data) > 0) {
