<?php $LOG = "##########################################\r\n"; $LOG .= "MISE A JOUR DISPONIBILITE DA\r\n"; $LOG .= date('Y-m-d H:i:s')."\r\n"; $timestart=microtime(true); require_once("../../inc/confNetisse.php"); // VARENNES VAUZELLES // MERCREDI : // ID Isabelle LEFEBVRE = 14 => PRESENTE // ID Victoria L HOTELIER = 34 => ABSENTE // ID Clarisse FELISMINO = 28 => ABSENTE // ID Sophie TANAPIN = 24 => ABSENTE // SAMEDI : // ID Marie- Pierre POUCHAT = 30 => ABSENTE $dw = date( "N", $timestamp); $q = "UPDATE ca_conseillers set id_agence=4, groupe=1, inactif=1 WHERE id_conseiller=14"; $r = excuteQuery($q); $q = "UPDATE ca_conseillers set inactif=0 WHERE id_conseiller IN (34,28,24,30)"; $r = excuteQuery($q); if($dw == 4){ $q = "UPDATE ca_conseillers set id_agence=4, groupe=1, inactif=0 WHERE id_conseiller=14"; $r = excuteQuery($q); $q = "UPDATE ca_conseillers set inactif=1 WHERE id_conseiller IN (34,28,24)"; $r = excuteQuery($q); $LOG .= "MERCREDI \r\n"; } else if ($dw == 7) { $q = "UPDATE ca_conseillers set inactif=1 WHERE id_conseiller IN (30)"; $r = excuteQuery($q); $LOG .= "SAMEDI \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 "<li>Debut du script: ".date("H:i:s", $timestart); echo "<br>Fin du script: ".date("H:i:s", $timeend); echo "<br>Script execute en " . $page_load_time . " sec"; $fp = fopen ("logs/cron.txt", "a+"); fwrite($fp, $LOG); fclose ($fp);