C’est bizarre, dans ton log je ne vois pas les messages que j’ai ajouté. cela dit, c’est peut-être justement une indication sur l’absence de statistique.
Normalement en début de log, tu aurais du avoir un truc du style:
[2019-11-23 11:19:04][DEBUG] : GetTabPie Equipement:3
[2019-11-23 11:19:04][DEBUG] : GetTabPie Equipement:3
[2019-11-23 11:19:05][DEBUG] : GetTabPie Equipement:3
[2019-11-23 11:19:05][DEBUG] : GetTabPie Equipement:3
[2019-11-23 11:19:05][DEBUG] : Equipement:1999 type:electricity Parent:
[2019-11-23 11:19:05][DEBUG] : Equipement:2001 type:water Parent:
[2019-11-23 11:19:05][DEBUG] : Equipement:2016 type:electricity Parent:1999
[2019-11-23 11:19:05][DEBUG] : Equipement:2017 type:electricity Parent:1999
[2019-11-23 11:19:05][DEBUG] : Nb équipement:3
[2019-11-23 11:19:06][DEBUG] : GetCalculPrice Requete: SELECT 1999 as id_equipement, id_parent, tva, tva_abo, abonnement, annee, mois, jour, semaine, sum(hp) as hp,sum(hc) as hc , sum(total_hp) as total_hp,sum(total_hc) as total_hc , prix_hp, prix_hc, temp_min, temp_max, temp_moy, dju, dju_clim, mois, cat_jours as categorie , rec_date FROM ( SELECT FORMAT(MIN(temp_min),2) AS temp_min, FORMAT(MAX(temp_max),2) AS temp_max, FORMAT(AVG(temp_moy),2) AS temp_moy, SUM(dju) AS dju, SUM(dju_clim) AS dju_clim, "non" as id_parent, `timestamp`, rec_date, rec_date as cat_jours, DATE_FORMAT(s.`rec_date`,"%Y") AS annee, DATE_FORMAT(s.`rec_date`,"%c") AS mois, DATE_FORMAT(s.`rec_date`,"%e") AS jour, DATE_FORMAT(s.`rec_date`,"%v") AS semaine, IF(DATE_FORMAT(s.`rec_date`,"%c") = 1 AND DATE_FORMAT(s.`rec_date`,"%v") = 52,CONCAT(DATE_FORMAT(s.`rec_date`,"sem %v")," ",DATE_FORMAT(DATE_SUB(s.`rec_date`, INTERVAL 1 YEAR),"%y")) , DATE_FORMAT(s.`rec_date`,"sem %v %y")) AS cat_semaine, /*Ajout du 1er janviers 2017 dans la semaie 52 de 2016*/ -- DATE_FORMAT(s.`rec_date`,"sem %v %y") AS cat_semaine, DATE_FORMAT(s.`rec_date`,"%b %y") AS cat_month, DATE_FORMAT(s.`rec_date`,"%y") AS cat_anne, ROUND(SUM(s.hp),2) AS hp, ROUND(SUM(s.hc),2) AS hc, (SELECT FORMAT(montant,2) AS abo FROM conso_abo aa where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut, "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin, "%Y-%m-%d" ) ) limit 0,1 ) as abonnement, (SELECT cst.valeur tva_abo FROM conso_abo aa INNER JOIN conso_tva cst on cst.id = aa.id_tva where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut, "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin, "%Y-%m-%d" ) ) limit 0,1 ) as tva_abo, (SELECT FORMAT(hc,4) AS hc FROM conso_price where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut, "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin, "%Y-%m-%d" ) ) limit 0,1) as prix_hc, (SELECT FORMAT(hp,4) AS hc FROM conso_price where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut, "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin, "%Y-%m-%d" ) ) limit 0,1 ) as prix_hp, (SELECT FORMAT(valeur ,2) FROM conso_tva where UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut, "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin, "%Y-%m-%d")) limit 0,1) as tva, SUM(ROUND((SELECT FORMAT(hc,4) AS hc FROM conso_price WHERE type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hc, 2)) AS total_hc, SUM(ROUND((SELECT FORMAT(hp,4) AS hp FROM conso_price WHERE type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hp, 2)) AS total_hp FROM conso_jour s WHERE id_eq = 1999 AND ( `timestamp` BETWEEN UNIX_TIMESTAMP("2019-11-23") AND UNIX_TIMESTAMP("2019-11-23") or `rec_date` BETWEEN "2019-11-23" AND "2019-11-23" ) GROUP BY cat_jours ORDER BY rec_date ASC) as req GROUP by req.cat_jours ORDER BY req.rec_date ASC
[2019-11-23 11:19:06][DEBUG] : date_deb:2019-11-23 date_fin:2019-11-23