optimisationStats.php 1.04 KB
Newer Older
Hamza Arfaoui's avatar
Hamza Arfaoui committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
<?php
$timestart=microtime(true);
require_once("../../inc/confNetisse.php"); 
ini_set('memory_limit','-1');
$queryA = "SELECT id_agence FROM  ca_agences";
$resultA = excuteQuery($queryA);
while($agence = $resultA->fetchObject()){
	$query = "SELECT *, TIMEDIFF(date_priseencharge,date_arrivee) as DA, TIMEDIFF(date_cloture,date_priseencharge) as DR FROM ca_clients WHERE id_agence=".intval($agence->id_agence); 
	$result = excuteQuery($queryA);
	$dataArray = array();
	while($row = $result['stmt']->fetch( PDO::FETCH_ASSOC )){
		$dataArray[] = $row;
	}
	$serialized = serialize($dataArray);
	$stmt = excuteQuery($GLOBALS['cnx'],"INSERT INTO ca_historique_stats VALUES('',".intval($agence->id_agence).",'','".$serialized."')");
	if(!$stmt['status'])
		wts_die (var_dump($stmt['stmt']->errorInfo()));
}
$timeend=microtime(true);
$time=$timeend-$timestart;
$page_load_time = number_format($time, 3);
echo "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";
?>