fetch( PDO::FETCH_ASSOC )['nb'];
echo "NB CONSEILLERS DANS ca_conseiller_agence = ".$NBCACONSEILLERS;
// NOMBRE TOTAL DE CLIENTS DANS ca_client_motifs
$q = "SELECT count(id_conseiller) as nb FROM `ca_conseiller_agence` WHERE temporaire = 1";
$r = excuteQuery($q);
$NBCACONSEILLERSTEMP = $r['stmt']->fetch( PDO::FETCH_ASSOC )['nb'];
echo "NB CONSEILLERS TEMPORAIRES DANS ca_conseiller_agence = ".$NBCACONSEILLERSTEMP;
if ($NBCACONSEILLERSTEMP > 0) {
$NBTOTALPREVU = $NBCACONSEILLERS - $NBCACONSEILLERSTEMP;
echo "DELETE de ca_conseiller_agence";
$q = "DELETE FROM ca_conseiller_agence WHERE temporaire = 1";
$r = excuteQuery($q);
$LOG .= "=> DELETE\r\n";
$q = "SELECT count(id_conseiller) as nb FROM `ca_conseiller_agence`";
$r = excuteQuery($q);
$NBCACONSEILLERSAPRES = $r['stmt']->fetch( PDO::FETCH_ASSOC )['nb'];
echo "NB CONSEILLERS DANS ca_conseiller_agence APRES = ".$NBCACONSEILLERSAPRES;
$LOG .= "NB CONSEILLERS DANS ca_conseiller_agence APRES = ".$NBCACONSEILLERSAPRES."\r\n";
echo "
NBCACONSEILLERSAVANT (".$NBCACONSEILLERS.") = NBCACONSEILLERSAPRES (".$NBCACONSEILLERSAPRES.")";
$LOG .= "NBCACONSEILLERSAVANT (".$NBCACONSEILLERS.") = NBCACONSEILLERSAPRES (".$NBCACONSEILLERSAPRES.")\r\n";
if ($NBCACONSEILLERSAPRES == $NBTOTALPREVU) {
echo "OK => DELETE EFFECTUEE";
$LOG .= "=> DELETE EFFECTUEE\r\n";
} else {
echo "PROBLEME DE CORRESPONDANCE : NBCACONSEILLERSAPRES != TOTAL PREVU";
$LOG .= "===> PROBLEME DE CORRESPONDANCE : NBCACONSEILLERSAPRES != TOTAL PREVU\r\n";
}
} else {
$LOG .= "=> Aucun conseiller temporaire...\r\n";
}
$timeend=microtime(true);
$time=$timeend-$timestart;
$page_load_time = number_format($time, 3);
$scriptStart = date("H:i:s", $timestart);
$scriptEnd = date("H:i:s", $timeend);
$timeLoad = $page_load_time;
$LOG .= "DUREE = ".$timeLoad." s\r\n";
echo "Debut du script: ".date("H:i:s", $timestart);
echo "
Fin du script: ".date("H:i:s", $timeend);
echo "
Script execute en " . $page_load_time . " sec";
$fp = fopen ("logs/cron_temps.txt", "a+");
fwrite($fp, $LOG);
fclose ($fp);
?>