<?php session_start(); require_once("../../inc/confNetisse.php"); header('Content-type: application/json'); $type = $_REQUEST["type"]; $from = $_REQUEST["from"]; $from_year_to_purge = $GLOBALS["BO_CONF"]["PURGE_YEAR"] ? $GLOBALS["BO_CONF"]["PURGE_YEAR"] : 5; $DATA_NB_TO_PURGE = 0; $DATA_PURGE_PROCESS = $from; $DATA_NB_PURGED = 0; $output = array(); $all = $_REQUEST['all'] == 'all' ? '>=' :'='; switch ($type) { case 'show_nb_data_to_purge': $DATA_PURGE = ""; $years = $_REQUEST["years"]; sort($years); $TOTALTOPURGE = 0; foreach ($years as $year) { $q = "SELECT COUNT(*) nb FROM ( SELECT date_arrivee FROM ca_historique_clients WHERE date_arrivee BETWEEN '".$year."-01-01 00:00:00' AND '".$year."-12-31 23:59:59' ORDER BY date_arrivee DESC ) s "; $result = excuteQuery($q); $n = $result['stmt']->fetchObject(); if($_REQUEST['all'] && $_REQUEST['all']!=""){ $DATA_NB_PURGED = $n->nb; } $TOTALTOPURGE = $TOTALTOPURGE + $n->nb; $DATA_PURGE .= "<span class='years-purged'><i class='fa fa-info-circle'></i> ".$year." (".$n->nb." visites)</span>"; } break; case 'purgeText': $LOG = "##########################################\r\n"; $LOG .= date('Y-m-d H:i:s')."\r\n"; $LOG .= "Purge ".$_REQUEST['from']." par ".$_SESSION['nom']." \r\n"; $fp = fopen ("../outils/logs/purge.txt", "a+"); fwrite($fp, $LOG); fclose ($fp); break; case 'delete': $q = "DELETE ca_historique_client_motifs FROM ca_historique_client_motifs INNER JOIN ca_historique_clients ON ca_historique_client_motifs.id_client = ca_historique_clients.id_client WHERE ca_historique_clients.date_arrivee BETWEEN '".$from."-01-01 00:00:00' AND '".$from."-12-31 23:59:59'"; $result = excuteQuery($q); $q = "DELETE FROM ca_historique_clients WHERE date_arrivee BETWEEN '".$from."-01-01 00:00:00' AND '".$from."-12-31 23:59:59'"; $result = excuteQuery($q); $afa = (isset($GLOBALS["BO_CONF"]["AFA"]) && $GLOBALS["BO_CONF"]["AFA"]) ? true : false; if($afa){ $q = "DELETE FROM ca_historique_pile_cc WHERE date_arrivee BETWEEN '".$from."-01-01 00:00:00' AND '".$from."-12-31 23:59:59'"; $result = excuteQuery($q); } $q = "DELETE FROM ca_statistiques WHERE date_arrivee BETWEEN '".$from."-01-01 00:00:00' AND '".$from."-12-31 23:59:59'"; // $q = "UPDATE ca_historique_clients SET telephone = 222 WHERE date_arrivee BETWEEN '".$from."-01-01 00:00:00' AND '".$from."-12-31 23:59:59'"; // $q = "UPDATE ca_statistiques SET telephone = 555 WHERE date_arrivee BETWEEN '".$from."-01-01 00:00:00' AND '".$from."-12-31 23:59:59'"; $result = excuteQuery($q); $DATA_NB_PURGED = $result['stmt']->rowCount(); $DATA_PURGE = "<span class='years-purged'><i class='fa fa-check'></i> ".$from." (".$DATA_NB_PURGED." visites)</span>"; break; } $output = array( 'data_purge' => $DATA_PURGE, 'data_nb_purged' => $DATA_NB_PURGED ); if($type == 'show_nb_data_to_purge'){ $output['total_data_to_purge'] = $TOTALTOPURGE; $output['years'] = $_REQUEST["years"]; } if($type == 'delete'){ $output['year_purged'] = $from; } echo json_encode($output);