Bonjour,
j’ai fait une mise à jour du plugin suivi conso ce matin mais depuis j’ai toutes les 30 minutes un message d’erreur.
Voici un extrait du log en debug :
[2025-01-02 14:00:16] DEBUG : GetCalculPrice Date deb: 2025-1-01 Date fin:2025-12-31 Type graph:mois Requete: SELECT 727 as id_equipement, id_parent,tva,tva_abo, abonnement, annee, mois, jour, semaine, sum(hp) as hp,sum(hc) as hc ,sum(hp2) as hp2,sum(hc2) as hc2 ,sum(hp3) as hp3,sum(hc3) as hc3 , sum(total_hp) as total_hp, sum(total_hc) as total_hc , sum(total_hp2) as total_hp2, sum(total_hc2) as total_hc2 , sum(total_hp3) as total_hp3, sum(total_hc3) as total_hc3 , sum(kwh) as kwh, prix_hp, prix_hc, prix_hp2, prix_hc2, prix_hp3, prix_hc3, temp_min, temp_max, temp_moy, dju, dju_clim, mois, cat_month 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, IF(DATE_FORMAT(s.rec_date,"%c") = 12 AND DATE_FORMAT(s.rec_date,"%v") = 1,52,DATE_FORMAT(s.rec_date,"%v")) AS semaine, IF(DATE_FORMAT(s.rec_date,"%c") = 1 AND DATE_FORMAT(s.rec_date,"%v") in (52,53),CONCAT(DATE_FORMAT(s.rec_date,"sem %v")," ",DATE_FORMAT(DATE_SUB(s.rec_date, INTERVAL 1 YEAR),"%y")) , IF(DATE_FORMAT(s.rec_date,"%c") = 12 AND DATE_FORMAT(s.rec_date,"%v") = 1,CONCAT(DATE_FORMAT(s.rec_date,"sem %v")," ",DATE_FORMAT(DATE_ADD(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),3) AS hp, ROUND(SUM(s.hc),3) AS hc, ROUND(SUM(s.hp2),3) AS hp2, ROUND(SUM(s.hc2),3) AS hc2, ROUND(SUM(s.hp3),3) AS hp3, ROUND(SUM(s.hc3),3) AS hc3, ROUND(SUM((SELECT SUM(ifnull(hc,0)) 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")) ) * s.hp/1000 ),2) AS kwh, (SELECT SUM(FORMAT(montant,2, "fr_FR") * (1 + cst.valeur/100)) AS 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" ) ) ) 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(SUM(hc),4, "fr_FR") 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" ) ) ) as prix_hc, (SELECT FORMAT(SUM(hp),4, "fr_FR") 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" ) ) ) as prix_hp, (SELECT FORMAT(SUM(hc2),4, "fr_FR") 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" ) ) ) as prix_hc2, (SELECT FORMAT(SUM(hp2),4, "fr_FR") 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" ) ) ) as prix_hp2, (SELECT FORMAT(SUM(hc3),4, "fr_FR") 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" ) ) ) as prix_hc3, (SELECT FORMAT(SUM(hp3),4, "fr_FR") 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" ) ) ) as prix_hp3, (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")) and global = 1 limit 0,1) as tva, CASE WHEN "electricity" IN ("gaz","oil","water") THEN 0 ELSE ROUND(SUM((SELECT SUM(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")) ) * s.hc ),2) END AS total_hc, CASE WHEN "electricity" = "gaz" THEN ROUND(SUM((SELECT (SUM(FORMAT(hp,4)) * hc) 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")) ) * s.hp/1000 ),2) WHEN "electricity" IN ("oil") THEN ROUND(SUM((SELECT FORMAT(SUM(hp),4, "fr_FR") 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")) ) * s.hp ),2) ELSE ROUND(SUM((SELECT SUM(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")) ) * s.hp ),2) END AS total_hp, CASE WHEN "electricity" IN ("gaz","oil","water") THEN 0 ELSE ROUND(SUM((SELECT SUM(FORMAT(hc2,4)) AS hc2 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")) ) * s.hc2 ),2) END AS total_hc2, CASE WHEN "electricity" IN ("gaz","oil","water") THEN 0 ELSE ROUND(SUM((SELECT SUM(FORMAT(hp2,4)) AS hp2 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")) ) * s.hp2 ),2) END AS total_hp2, CASE WHEN "electricity" IN ("gaz","oil","water") THEN 0 ELSE ROUND(SUM((SELECT SUM(FORMAT(hc3,4)) AS hc3 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")) ) * s.hc3 ),2) END AS total_hc3, CASE WHEN "electricity" IN ("gaz","oil","water") THEN 0 ELSE ROUND(SUM((SELECT SUM(FORMAT(hp3,4)) AS hp3 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")) ) * s.hp3 ),2) END AS total_hp3 FROM conso_jour s WHERE id_eq = 727 AND (rec_date BETWEEN "2025-1-01" AND "2025-12-31" ) GROUP BY cat_month ORDER BY rec_date ASC) as req GROUP by req.cat_month ORDER BY req.rec_date ASC [2025-01-02 14:00:16] DEBUG : GetCalculPrice Date deb: 2025-01-02 Date fin:2025-01-02 Type graph:jours Requete: SELECT 727 as id_equipement, id_parent,tva,tva_abo, abonnement, annee, mois, jour, semaine, sum(hp) as hp,sum(hc) as hc ,sum(hp2) as hp2,sum(hc2) as hc2 ,sum(hp3) as hp3,sum(hc3) as hc3 , sum(total_hp) as total_hp, sum(total_hc) as total_hc , sum(total_hp2) as total_hp2, sum(total_hc2) as total_hc2 , sum(total_hp3) as total_hp3, sum(total_hc3) as total_hc3 , sum(kwh) as kwh, prix_hp, prix_hc, prix_hp2, prix_hc2, prix_hp3, prix_hc3, 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, IF(DATE_FORMAT(s.rec_date,"%c") = 12 AND DATE_FORMAT(s.rec_date,"%v") = 1,52,DATE_FORMAT(s.rec_date,"%v")) AS semaine, IF(DATE_FORMAT(s.rec_date,"%c") = 1 AND DATE_FORMAT(s.rec_date,"%v") in (52,53),CONCAT(DATE_FORMAT(s.rec_date,"sem %v")," ",DATE_FORMAT(DATE_SUB(s.rec_date, INTERVAL 1 YEAR),"%y")) , IF(DATE_FORMAT(s.rec_date,"%c") = 12 AND DATE_FORMAT(s.rec_date,"%v") = 1,CONCAT(DATE_FORMAT(s.rec_date,"sem %v")," ",DATE_FORMAT(DATE_ADD(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),3) AS hp, ROUND(SUM(s.hc),3) AS hc, ROUND(SUM(s.hp2),3) AS hp2, ROUND(SUM(s.hc2),3) AS hc2, ROUND(SUM(s.hp3),3) AS hp3, ROUND(SUM(s.hc3),3) AS hc3, ROUND(SUM((SELECT SUM(ifnull(hc,0)) 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")) ) * s.hp/1000 ),2) AS kwh, (SELECT SUM(FORMAT(montant,2, "fr_FR") * (1 + cst.valeur/100)) AS 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" ) ) ) 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(SUM(hc),4, "fr_FR") 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" ) ) ) as prix_hc, (SELECT FORMAT(SUM(hp),4, "fr_FR") 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" ) ) ) as prix_hp, (SELECT FORMAT(SUM(hc2),4, "fr_FR") 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" ) ) ) as prix_hc2, (SELECT FORMAT(SUM(hp2),4, "fr_FR") 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" ) ) ) as prix_hp2, (SELECT FORMAT(SUM(hc3),4, "fr_FR") 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" ) ) ) as prix_hc3, (SELECT FORMAT(SUM(hp3),4, "fr_FR") 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" ) ) ) as prix_hp3, (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")) and global = 1 limit 0,1) as tva, CASE WHEN "electricity" IN ("gaz","oil","water") THEN 0 ELSE ROUND(SUM((SELECT SUM(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")) ) * s.hc ),2) END AS total_hc, CASE WHEN "electricity" = "gaz" THEN ROUND(SUM((SELECT (SUM(FORMAT(hp,4)) * hc) 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")) ) * s.hp/1000 ),2) WHEN "electricity" IN ("oil") THEN ROUND(SUM((SELECT FORMAT(SUM(hp),4, "fr_FR") 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")) ) * s.hp ),2) ELSE ROUND(SUM((SELECT SUM(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")) ) * s.hp ),2) END AS total_hp, CASE WHEN "electricity" IN ("gaz","oil","water") THEN 0 ELSE ROUND(SUM((SELECT SUM(FORMAT(hc2,4)) AS hc2 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")) ) * s.hc2 ),2) END AS total_hc2, CASE WHEN "electricity" IN ("gaz","oil","water") THEN 0 ELSE ROUND(SUM((SELECT SUM(FORMAT(hp2,4)) AS hp2 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")) ) * s.hp2 ),2) END AS total_hp2, CASE WHEN "electricity" IN ("gaz","oil","water") THEN 0 ELSE ROUND(SUM((SELECT SUM(FORMAT(hc3,4)) AS hc3 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")) ) * s.hc3 ),2) END AS total_hc3, CASE WHEN "electricity" IN ("gaz","oil","water") THEN 0 ELSE ROUND(SUM((SELECT SUM(FORMAT(hp3,4)) AS hp3 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")) ) * s.hp3 ),2) END AS total_hp3 FROM conso_jour s WHERE id_eq = 727 AND (rec_date BETWEEN "2025-01-02" AND "2025-01-02" ) GROUP BY cat_jours ORDER BY rec_date ASC) as req GROUP by req.cat_jours ORDER BY req.rec_date ASC [2025-01-02 14:00:16] ERROR : Erreur sur la fonction cron30 du plugin : Call to undefined function HP()
Voici ma page santé :
La page du plugin :
Merci d’avance pour votre aide
Jean-François
