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) {