= date_arrivee THEN SEC_TO_TIME(TIMESTAMPDIFF(SECOND, date_arrivee, date_priseencharge)) ELSE NULL END) AS duree_attente, (CASE WHEN date_cloture AND date_cloture >= date_priseencharge THEN SEC_TO_TIME(TIMESTAMPDIFF(SECOND, date_priseencharge, date_cloture)) ELSE NULL END) AS duree_rdv, rdv, id_conseiller, id_action, nfcprov, client, entite, civ, nom, prenom, matricule, partpro, cancelled".$additionnalColumns." FROM ca_clients"; $r = excuteQuery($q); $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_dcc.txt", "a+"); fwrite($fp, $LOG); fclose ($fp); ?>