reset-dcc-stats.php 2.77 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 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82
<?php
$LOG = "##########################################\r\n";
$LOG .= date('Y-m-d H:i:s')."\r\n";
$timestart=microtime(true);
require_once("../../inc/confNetisse.php");
ini_set('memory_limit','-1');
ini_set('max_execution_time', 0);

$q = "TRUNCATE `ca_statistiques`";
$r = excuteQuery($q);
$q = "
INSERT INTO 
ca_statistiques ( 
    id_client, 
    id_agence,
    date_arrivee, 
    date_priseencharge, 
    date_cloture, 
    duree_attente, 
    duree_rdv, 
    rdv, 
    id_conseiller, 
    id_action,
    nfcprov,
    entite,
    civ, 
    nom, 
    prenom 
) 
SELECT id_client, 
       id_agence, 
       (CASE date_arrivee WHEN '0000-00-00 00:00:00' THEN NULL ELSE date_arrivee END) AS date_arrivee, 
       (CASE date_priseencharge WHEN '0000-00-00 00:00:00' THEN NULL ELSE date_priseencharge END) AS date_priseencharge, 
       (CASE date_cloture WHEN '0000-00-00 00:00:00' THEN NULL ELSE date_cloture END) AS date_cloture, 
       (CASE WHEN date_priseencharge AND date_priseencharge >= 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,
       entite,  
       civ, 
       nom, 
       prenom

FROM ca_historique_clients
UNION
SELECT id_client, 
       id_agence, 
       (CASE date_arrivee WHEN '0000-00-00 00:00:00' THEN NULL ELSE date_arrivee END) AS date_arrivee, 
       (CASE date_priseencharge WHEN '0000-00-00 00:00:00' THEN NULL ELSE date_priseencharge END) AS date_priseencharge, 
       (CASE date_cloture WHEN '0000-00-00 00:00:00' THEN NULL ELSE date_cloture END) AS date_cloture, 
       (CASE WHEN date_priseencharge AND date_priseencharge >= 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,
       entite,  
       civ, 
       nom, 
       prenom
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 "<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_dcc.txt", "a+");
fwrite($fp, $LOG);
fclose ($fp);

?>