<?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);