Conseil pour le suivi de conso du chauffage

nicoto94 · Avril 13, 2024, 10:31

Salut a tous
Je souhaiterai créer un équipement Consommation chauffage totale qui regrouperai tous mes différents chauffages afin de pouvoir avoir des notifications journalière
Je pensais donc indiquer tous mes radiateurs avec leurs consommations dans cet équipement:

( #[Chambre parentale][Module_chauffage_chb_parentale][Consommation]# + #[Chambre filles][Module_chauffage_chb_filles][Consommation]# + #[Chambre Hamza][Module_chauffage_chb_Hamza][Consommation]# )

Indiquer pour cet Equipment L’électricité global en parent puis pour tous mes radiateurs indiqués L’Equipement chauffage totale pour parent ?

Qu’ en pensez vous ?

En vous remerciant par avance

Bonne soirée a tous

superbricolo · Avril 14, 2024, 6:50

Oui, ça va fonctionner. Tu peux également sommer les puissances

nicoto94 · Avril 14, 2024, 12:39

Je l avais fait également :

( #[Chambre parentale][Module_chauffage_chb_parentale][Puissance]# + #[Chambre filles][Module_chauffage_chb_filles][Puissance]# + #[Chambre Hamza][Module_chauffage_chb_Hamza][Puissance]# )

Par contre depuis ; j ai une erreur :

Erreur sur la fonction deamon_start du plugin : Vous devez attendre au moins 45 secondes entre deux lancements du démon. Dernier lancement : 2024-04-14 01:15:04

2379|[2024-04-14 11:15:05] ERROR  : Erreur sur la fonction deamon_start du plugin : Vous devez attendre au moins 45 secondes entre deux lancements du démon. Dernier lancement : 2024-04-14 11:15:05
2380|[2024-04-14 11:20:02] INFO  : CrontabJour:REPLACE INTO conso_jour (`timestamp`,rec_date,periode,hp,hc,hp2,hc2,hp3,hc3,idx_max_hp,idx_min_hp,idx_max_hc,idx_min_hc,idx_max_hp2,idx_min_hp2,idx_max_hc2,idx_min_hc2,idx_max_hp3,idx_min_hp3,idx_max_hc3,idx_min_hc3,id_eq,temp_max,temp_min,temp_moy,dju_clim,dju) 				SELECT 				MIN(`timestamp`) AS `timestamp`  , 				`conso_teleinfo`.`rec_date` AS `rec_date`, 				DATE_FORMAT(`conso_teleinfo`.`rec_date`,'%a %e %y') AS `periode`, 	((MAX(`hchp`) - MIN(`hchp`)) / 1000)  AS hp, ((MAX(`hchc`) - MIN(`hchc`)) / 1000)  AS hc, ((MAX(`hchp2`) - MIN(`hchp2`)) / 1000)  AS hp2, ((MAX(`hchc2`) - MIN(`hchc2`)) / 1000)  AS hc2, ((MAX(`hchp3`) - MIN(`hchp3`)) / 1000)  AS hp3, ((MAX(`hchc3`) - MIN(`hchc3`)) / 1000)  AS h3,MAX(hchp) as idx_max_hp, 				MIN(hchp) as idx_min_hp, 				MAX(hchc) as idx_max_hc, 				MIN(hchc) as idx_min_hc, 				MAX(hchp2) as idx_max_hp2, 				MIN(hchp2) as idx_min_hp2, 				MAX(hchc2) as idx_max_hc2, 				MIN(hchc2) as idx_min_hc2, 				MAX(hchp3) as idx_max_hp3, 				MIN(hchp3) as idx_min_hp3, 				MAX(hchc3) as idx_max_hc3, 				MIN(hchc3) as idx_min_hc3, 				id_equipement, 				FORMAT(MAX(temp),2) AS temp_max, 				FORMAT(MIN(NULLIF(temp,0)),2) AS temp_min, 				FORMAT(AVG(NULLIF(temp,0)),2) AS temp_moy, CASE WHEN DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN 						    DATE_FORMAT(STR_TO_DATE('06-15', '%m-%d'), '%m-%d') AND 						    DATE_FORMAT(STR_TO_DATE('09-15', '%m-%d'), '%m-%d')  THEN 0 WHEN 17 = 0 THEN 0 		WHEN FORMAT(AVG(NULLIF(temp,0)),2) = 0 THEN 0 		WHEN 17 >= FORMAT(MAX(temp),2) THEN 0 		WHEN 17 <= FORMAT(MIN(NULLIF(temp,0)),2) THEN FORMAT(AVG(NULLIF(temp,0)),2)-17 		WHEN FORMAT(MIN(NULLIF(temp,0)),2) < 17 AND 17 <= FORMAT(MAX(temp),2) THEN (FORMAT(MAX(temp),2)-17) * (0.08+0.42* (FORMAT(MAX(NULLIF(temp,0)),2)-17) / (FORMAT(MAX(temp),2) - FORMAT(MIN(NULLIF(temp,0)),2))) 		END AS dju_clim,  CASE WHEN DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN 							DATE_FORMAT(STR_TO_DATE('10-15', '%m-%d'), '%m-%d') AND	'12-31' AND  						DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN	'01-01' AND 							DATE_FORMAT(STR_TO_DATE('04-15', '%m-%d'), '%m-%d')  THEN 0  WHEN 17 = 0 THEN 0 		WHEN 	FORMAT(AVG(NULLIF(temp,0)),2) = 0 THEN 0 		WHEN 17 >= FORMAT(MAX(temp),2) THEN 17 - FORMAT(AVG(NULLIF(temp,0)),2) 		WHEN 17 <= FORMAT(MIN(NULLIF(temp,0)),2) THEN 0 		WHEN FORMAT(MIN(NULLIF(temp,0)),2) < 17 AND 17 <= FORMAT(MAX(temp),2) THEN (17-FORMAT(MIN(NULLIF(temp,0)),2)) * (0.08+0.42* (17-FORMAT(MIN(NULLIF(temp,0)),2)) / (FORMAT(MAX(temp),2) - FORMAT(MIN(NULLIF(temp,0)),2))) 		END AS dju 	 FROM `conso_teleinfo`	INNER JOIN eqLogic ON id=id_equipement 	where rec_date >= SUBDATE(CURRENT_DATE, INTERVAL 1 DAY) GROUP BY rec_date,id_equipement
2381|[2024-04-14 11:25:03] ERROR  : Erreur sur la fonction deamon_start du plugin : Vous devez attendre au moins 45 secondes entre deux lancements du démon. Dernier lancement : 2024-04-14 11:25:03
2382|[2024-04-14 11:40:03] INFO  : CrontabJour:REPLACE INTO conso_jour (`timestamp`,rec_date,periode,hp,hc,hp2,hc2,hp3,hc3,idx_max_hp,idx_min_hp,idx_max_hc,idx_min_hc,idx_max_hp2,idx_min_hp2,idx_max_hc2,idx_min_hc2,idx_max_hp3,idx_min_hp3,idx_max_hc3,idx_min_hc3,id_eq,temp_max,temp_min,temp_moy,dju_clim,dju) 				SELECT 				MIN(`timestamp`) AS `timestamp`  , 				`conso_teleinfo`.`rec_date` AS `rec_date`, 				DATE_FORMAT(`conso_teleinfo`.`rec_date`,'%a %e %y') AS `periode`, 	((MAX(`hchp`) - MIN(`hchp`)) / 1000)  AS hp, ((MAX(`hchc`) - MIN(`hchc`)) / 1000)  AS hc, ((MAX(`hchp2`) - MIN(`hchp2`)) / 1000)  AS hp2, ((MAX(`hchc2`) - MIN(`hchc2`)) / 1000)  AS hc2, ((MAX(`hchp3`) - MIN(`hchp3`)) / 1000)  AS hp3, ((MAX(`hchc3`) - MIN(`hchc3`)) / 1000)  AS h3,MAX(hchp) as idx_max_hp, 				MIN(hchp) as idx_min_hp, 				MAX(hchc) as idx_max_hc, 				MIN(hchc) as idx_min_hc, 				MAX(hchp2) as idx_max_hp2, 				MIN(hchp2) as idx_min_hp2, 				MAX(hchc2) as idx_max_hc2, 				MIN(hchc2) as idx_min_hc2, 				MAX(hchp3) as idx_max_hp3, 				MIN(hchp3) as idx_min_hp3, 				MAX(hchc3) as idx_max_hc3, 				MIN(hchc3) as idx_min_hc3, 				id_equipement, 				FORMAT(MAX(temp),2) AS temp_max, 				FORMAT(MIN(NULLIF(temp,0)),2) AS temp_min, 				FORMAT(AVG(NULLIF(temp,0)),2) AS temp_moy, CASE WHEN DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN 						    DATE_FORMAT(STR_TO_DATE('06-15', '%m-%d'), '%m-%d') AND 						    DATE_FORMAT(STR_TO_DATE('09-15', '%m-%d'), '%m-%d')  THEN 0 WHEN 17 = 0 THEN 0 		WHEN FORMAT(AVG(NULLIF(temp,0)),2) = 0 THEN 0 		WHEN 17 >= FORMAT(MAX(temp),2) THEN 0 		WHEN 17 <= FORMAT(MIN(NULLIF(temp,0)),2) THEN FORMAT(AVG(NULLIF(temp,0)),2)-17 		WHEN FORMAT(MIN(NULLIF(temp,0)),2) < 17 AND 17 <= FORMAT(MAX(temp),2) THEN (FORMAT(MAX(temp),2)-17) * (0.08+0.42* (FORMAT(MAX(NULLIF(temp,0)),2)-17) / (FORMAT(MAX(temp),2) - FORMAT(MIN(NULLIF(temp,0)),2))) 		END AS dju_clim,  CASE WHEN DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN 							DATE_FORMAT(STR_TO_DATE('10-15', '%m-%d'), '%m-%d') AND	'12-31' AND  						DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN	'01-01' AND 							DATE_FORMAT(STR_TO_DATE('04-15', '%m-%d'), '%m-%d')  THEN 0  WHEN 17 = 0 THEN 0 		WHEN 	FORMAT(AVG(NULLIF(temp,0)),2) = 0 THEN 0 		WHEN 17 >= FORMAT(MAX(temp),2) THEN 17 - FORMAT(AVG(NULLIF(temp,0)),2) 		WHEN 17 <= FORMAT(MIN(NULLIF(temp,0)),2) THEN 0 		WHEN FORMAT(MIN(NULLIF(temp,0)),2) < 17 AND 17 <= FORMAT(MAX(temp),2) THEN (17-FORMAT(MIN(NULLIF(temp,0)),2)) * (0.08+0.42* (17-FORMAT(MIN(NULLIF(temp,0)),2)) / (FORMAT(MAX(temp),2) - FORMAT(MIN(NULLIF(temp,0)),2))) 		END AS dju 	 FROM `conso_teleinfo`	INNER JOIN eqLogic ON id=id_equipement 	where rec_date >= SUBDATE(CURRENT_DATE, INTERVAL 1 DAY) GROUP BY rec_date,id_equipement
2383|[2024-04-14 11:55:04] ERROR  : Erreur sur la fonction deamon_start du plugin : Vous devez attendre au moins 45 secondes entre deux lancements du démon. Dernier lancement : 2024-04-14 11:55:04
2384|[2024-04-14 12:00:04] INFO  : CrontabJour:REPLACE INTO conso_jour (`timestamp`,rec_date,periode,hp,hc,hp2,hc2,hp3,hc3,idx_max_hp,idx_min_hp,idx_max_hc,idx_min_hc,idx_max_hp2,idx_min_hp2,idx_max_hc2,idx_min_hc2,idx_max_hp3,idx_min_hp3,idx_max_hc3,idx_min_hc3,id_eq,temp_max,temp_min,temp_moy,dju_clim,dju) 				SELECT 				MIN(`timestamp`) AS `timestamp`  , 				`conso_teleinfo`.`rec_date` AS `rec_date`, 				DATE_FORMAT(`conso_teleinfo`.`rec_date`,'%a %e %y') AS `periode`, 	((MAX(`hchp`) - MIN(`hchp`)) / 1000)  AS hp, ((MAX(`hchc`) - MIN(`hchc`)) / 1000)  AS hc, ((MAX(`hchp2`) - MIN(`hchp2`)) / 1000)  AS hp2, ((MAX(`hchc2`) - MIN(`hchc2`)) / 1000)  AS hc2, ((MAX(`hchp3`) - MIN(`hchp3`)) / 1000)  AS hp3, ((MAX(`hchc3`) - MIN(`hchc3`)) / 1000)  AS h3,MAX(hchp) as idx_max_hp, 				MIN(hchp) as idx_min_hp, 				MAX(hchc) as idx_max_hc, 				MIN(hchc) as idx_min_hc, 				MAX(hchp2) as idx_max_hp2, 				MIN(hchp2) as idx_min_hp2, 				MAX(hchc2) as idx_max_hc2, 				MIN(hchc2) as idx_min_hc2, 				MAX(hchp3) as idx_max_hp3, 				MIN(hchp3) as idx_min_hp3, 				MAX(hchc3) as idx_max_hc3, 				MIN(hchc3) as idx_min_hc3, 				id_equipement, 				FORMAT(MAX(temp),2) AS temp_max, 				FORMAT(MIN(NULLIF(temp,0)),2) AS temp_min, 				FORMAT(AVG(NULLIF(temp,0)),2) AS temp_moy, CASE WHEN DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN 						    DATE_FORMAT(STR_TO_DATE('06-15', '%m-%d'), '%m-%d') AND 						    DATE_FORMAT(STR_TO_DATE('09-15', '%m-%d'), '%m-%d')  THEN 0 WHEN 17 = 0 THEN 0 		WHEN FORMAT(AVG(NULLIF(temp,0)),2) = 0 THEN 0 		WHEN 17 >= FORMAT(MAX(temp),2) THEN 0 		WHEN 17 <= FORMAT(MIN(NULLIF(temp,0)),2) THEN FORMAT(AVG(NULLIF(temp,0)),2)-17 		WHEN FORMAT(MIN(NULLIF(temp,0)),2) < 17 AND 17 <= FORMAT(MAX(temp),2) THEN (FORMAT(MAX(temp),2)-17) * (0.08+0.42* (FORMAT(MAX(NULLIF(temp,0)),2)-17) / (FORMAT(MAX(temp),2) - FORMAT(MIN(NULLIF(temp,0)),2))) 		END AS dju_clim,  CASE WHEN DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN 							DATE_FORMAT(STR_TO_DATE('10-15', '%m-%d'), '%m-%d') AND	'12-31' AND  						DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN	'01-01' AND 							DATE_FORMAT(STR_TO_DATE('04-15', '%m-%d'), '%m-%d')  THEN 0  WHEN 17 = 0 THEN 0 		WHEN 	FORMAT(AVG(NULLIF(temp,0)),2) = 0 THEN 0 		WHEN 17 >= FORMAT(MAX(temp),2) THEN 17 - FORMAT(AVG(NULLIF(temp,0)),2) 		WHEN 17 <= FORMAT(MIN(NULLIF(temp,0)),2) THEN 0 		WHEN FORMAT(MIN(NULLIF(temp,0)),2) < 17 AND 17 <= FORMAT(MAX(temp),2) THEN (17-FORMAT(MIN(NULLIF(temp,0)),2)) * (0.08+0.42* (17-FORMAT(MIN(NULLIF(temp,0)),2)) / (FORMAT(MAX(temp),2) - FORMAT(MIN(NULLIF(temp,0)),2))) 		END AS dju 	 FROM `conso_teleinfo`	INNER JOIN eqLogic ON id=id_equipement 	where rec_date >= SUBDATE(CURRENT_DATE, INTERVAL 1 DAY) GROUP BY rec_date,id_equipement
2385|[2024-04-14 12:20:03] INFO  : CrontabJour:REPLACE INTO conso_jour (`timestamp`,rec_date,periode,hp,hc,hp2,hc2,hp3,hc3,idx_max_hp,idx_min_hp,idx_max_hc,idx_min_hc,idx_max_hp2,idx_min_hp2,idx_max_hc2,idx_min_hc2,idx_max_hp3,idx_min_hp3,idx_max_hc3,idx_min_hc3,id_eq,temp_max,temp_min,temp_moy,dju_clim,dju) 				SELECT 				MIN(`timestamp`) AS `timestamp`  , 				`conso_teleinfo`.`rec_date` AS `rec_date`, 				DATE_FORMAT(`conso_teleinfo`.`rec_date`,'%a %e %y') AS `periode`, 	((MAX(`hchp`) - MIN(`hchp`)) / 1000)  AS hp, ((MAX(`hchc`) - MIN(`hchc`)) / 1000)  AS hc, ((MAX(`hchp2`) - MIN(`hchp2`)) / 1000)  AS hp2, ((MAX(`hchc2`) - MIN(`hchc2`)) / 1000)  AS hc2, ((MAX(`hchp3`) - MIN(`hchp3`)) / 1000)  AS hp3, ((MAX(`hchc3`) - MIN(`hchc3`)) / 1000)  AS h3,MAX(hchp) as idx_max_hp, 				MIN(hchp) as idx_min_hp, 				MAX(hchc) as idx_max_hc, 				MIN(hchc) as idx_min_hc, 				MAX(hchp2) as idx_max_hp2, 				MIN(hchp2) as idx_min_hp2, 				MAX(hchc2) as idx_max_hc2, 				MIN(hchc2) as idx_min_hc2, 				MAX(hchp3) as idx_max_hp3, 				MIN(hchp3) as idx_min_hp3, 				MAX(hchc3) as idx_max_hc3, 				MIN(hchc3) as idx_min_hc3, 				id_equipement, 				FORMAT(MAX(temp),2) AS temp_max, 				FORMAT(MIN(NULLIF(temp,0)),2) AS temp_min, 				FORMAT(AVG(NULLIF(temp,0)),2) AS temp_moy, CASE WHEN DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN 						    DATE_FORMAT(STR_TO_DATE('06-15', '%m-%d'), '%m-%d') AND 						    DATE_FORMAT(STR_TO_DATE('09-15', '%m-%d'), '%m-%d')  THEN 0 WHEN 17 = 0 THEN 0 		WHEN FORMAT(AVG(NULLIF(temp,0)),2) = 0 THEN 0 		WHEN 17 >= FORMAT(MAX(temp),2) THEN 0 		WHEN 17 <= FORMAT(MIN(NULLIF(temp,0)),2) THEN FORMAT(AVG(NULLIF(temp,0)),2)-17 		WHEN FORMAT(MIN(NULLIF(temp,0)),2) < 17 AND 17 <= FORMAT(MAX(temp),2) THEN (FORMAT(MAX(temp),2)-17) * (0.08+0.42* (FORMAT(MAX(NULLIF(temp,0)),2)-17) / (FORMAT(MAX(temp),2) - FORMAT(MIN(NULLIF(temp,0)),2))) 		END AS dju_clim,  CASE WHEN DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN 							DATE_FORMAT(STR_TO_DATE('10-15', '%m-%d'), '%m-%d') AND	'12-31' AND  						DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN	'01-01' AND 							DATE_FORMAT(STR_TO_DATE('04-15', '%m-%d'), '%m-%d')  THEN 0  WHEN 17 = 0 THEN 0 		WHEN 	FORMAT(AVG(NULLIF(temp,0)),2) = 0 THEN 0 		WHEN 17 >= FORMAT(MAX(temp),2) THEN 17 - FORMAT(AVG(NULLIF(temp,0)),2) 		WHEN 17 <= FORMAT(MIN(NULLIF(temp,0)),2) THEN 0 		WHEN FORMAT(MIN(NULLIF(temp,0)),2) < 17 AND 17 <= FORMAT(MAX(temp),2) THEN (17-FORMAT(MIN(NULLIF(temp,0)),2)) * (0.08+0.42* (17-FORMAT(MIN(NULLIF(temp,0)),2)) / (FORMAT(MAX(temp),2) - FORMAT(MIN(NULLIF(temp,0)),2))) 		END AS dju 	 FROM `conso_teleinfo`	INNER JOIN eqLogic ON id=id_equipement 	where rec_date >= SUBDATE(CURRENT_DATE, INTERVAL 1 DAY) GROUP BY rec_date,id_equipement
2386|[2024-04-14 12:40:03] INFO  : CrontabJour:REPLACE INTO conso_jour (`timestamp`,rec_date,periode,hp,hc,hp2,hc2,hp3,hc3,idx_max_hp,idx_min_hp,idx_max_hc,idx_min_hc,idx_max_hp2,idx_min_hp2,idx_max_hc2,idx_min_hc2,idx_max_hp3,idx_min_hp3,idx_max_hc3,idx_min_hc3,id_eq,temp_max,temp_min,temp_moy,dju_clim,dju) 				SELECT 				MIN(`timestamp`) AS `timestamp`  , 				`conso_teleinfo`.`rec_date` AS `rec_date`, 				DATE_FORMAT(`conso_teleinfo`.`rec_date`,'%a %e %y') AS `periode`, 	((MAX(`hchp`) - MIN(`hchp`)) / 1000)  AS hp, ((MAX(`hchc`) - MIN(`hchc`)) / 1000)  AS hc, ((MAX(`hchp2`) - MIN(`hchp2`)) / 1000)  AS hp2, ((MAX(`hchc2`) - MIN(`hchc2`)) / 1000)  AS hc2, ((MAX(`hchp3`) - MIN(`hchp3`)) / 1000)  AS hp3, ((MAX(`hchc3`) - MIN(`hchc3`)) / 1000)  AS h3,MAX(hchp) as idx_max_hp, 				MIN(hchp) as idx_min_hp, 				MAX(hchc) as idx_max_hc, 				MIN(hchc) as idx_min_hc, 				MAX(hchp2) as idx_max_hp2, 				MIN(hchp2) as idx_min_hp2, 				MAX(hchc2) as idx_max_hc2, 				MIN(hchc2) as idx_min_hc2, 				MAX(hchp3) as idx_max_hp3, 				MIN(hchp3) as idx_min_hp3, 				MAX(hchc3) as idx_max_hc3, 				MIN(hchc3) as idx_min_hc3, 				id_equipement, 				FORMAT(MAX(temp),2) AS temp_max, 				FORMAT(MIN(NULLIF(temp,0)),2) AS temp_min, 				FORMAT(AVG(NULLIF(temp,0)),2) AS temp_moy, CASE WHEN DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN 						    DATE_FORMAT(STR_TO_DATE('06-15', '%m-%d'), '%m-%d') AND 						    DATE_FORMAT(STR_TO_DATE('09-15', '%m-%d'), '%m-%d')  THEN 0 WHEN 17 = 0 THEN 0 		WHEN FORMAT(AVG(NULLIF(temp,0)),2) = 0 THEN 0 		WHEN 17 >= FORMAT(MAX(temp),2) THEN 0 		WHEN 17 <= FORMAT(MIN(NULLIF(temp,0)),2) THEN FORMAT(AVG(NULLIF(temp,0)),2)-17 		WHEN FORMAT(MIN(NULLIF(temp,0)),2) < 17 AND 17 <= FORMAT(MAX(temp),2) THEN (FORMAT(MAX(temp),2)-17) * (0.08+0.42* (FORMAT(MAX(NULLIF(temp,0)),2)-17) / (FORMAT(MAX(temp),2) - FORMAT(MIN(NULLIF(temp,0)),2))) 		END AS dju_clim,  CASE WHEN DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN 							DATE_FORMAT(STR_TO_DATE('10-15', '%m-%d'), '%m-%d') AND	'12-31' AND  						DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN	'01-01' AND 							DATE_FORMAT(STR_TO_DATE('04-15', '%m-%d'), '%m-%d')  THEN 0  WHEN 17 = 0 THEN 0 		WHEN 	FORMAT(AVG(NULLIF(temp,0)),2) = 0 THEN 0 		WHEN 17 >= FORMAT(MAX(temp),2) THEN 17 - FORMAT(AVG(NULLIF(temp,0)),2) 		WHEN 17 <= FORMAT(MIN(NULLIF(temp,0)),2) THEN 0 		WHEN FORMAT(MIN(NULLIF(temp,0)),2) < 17 AND 17 <= FORMAT(MAX(temp),2) THEN (17-FORMAT(MIN(NULLIF(temp,0)),2)) * (0.08+0.42* (17-FORMAT(MIN(NULLIF(temp,0)),2)) / (FORMAT(MAX(temp),2) - FORMAT(MIN(NULLIF(temp,0)),2))) 		END AS dju 	 FROM `conso_teleinfo`	INNER JOIN eqLogic ON id=id_equipement 	where rec_date >= SUBDATE(CURRENT_DATE, INTERVAL 1 DAY) GROUP BY rec_date,id_equipement
2387|[2024-04-14 12:50:04] ERROR  : Erreur sur la fonction deamon_start du plugin : Vous devez attendre au moins 45 secondes entre deux lancements du démon. Dernier lancement : 2024-04-14 12:50:04
2388|[2024-04-14 13:00:05] INFO  : CrontabJour:REPLACE INTO conso_jour (`timestamp`,rec_date,periode,hp,hc,hp2,hc2,hp3,hc3,idx_max_hp,idx_min_hp,idx_max_hc,idx_min_hc,idx_max_hp2,idx_min_hp2,idx_max_hc2,idx_min_hc2,idx_max_hp3,idx_min_hp3,idx_max_hc3,idx_min_hc3,id_eq,temp_max,temp_min,temp_moy,dju_clim,dju) 				SELECT 				MIN(`timestamp`) AS `timestamp`  , 				`conso_teleinfo`.`rec_date` AS `rec_date`, 				DATE_FORMAT(`conso_teleinfo`.`rec_date`,'%a %e %y') AS `periode`, 	((MAX(`hchp`) - MIN(`hchp`)) / 1000)  AS hp, ((MAX(`hchc`) - MIN(`hchc`)) / 1000)  AS hc, ((MAX(`hchp2`) - MIN(`hchp2`)) / 1000)  AS hp2, ((MAX(`hchc2`) - MIN(`hchc2`)) / 1000)  AS hc2, ((MAX(`hchp3`) - MIN(`hchp3`)) / 1000)  AS hp3, ((MAX(`hchc3`) - MIN(`hchc3`)) / 1000)  AS h3,MAX(hchp) as idx_max_hp, 				MIN(hchp) as idx_min_hp, 				MAX(hchc) as idx_max_hc, 				MIN(hchc) as idx_min_hc, 				MAX(hchp2) as idx_max_hp2, 				MIN(hchp2) as idx_min_hp2, 				MAX(hchc2) as idx_max_hc2, 				MIN(hchc2) as idx_min_hc2, 				MAX(hchp3) as idx_max_hp3, 				MIN(hchp3) as idx_min_hp3, 				MAX(hchc3) as idx_max_hc3, 				MIN(hchc3) as idx_min_hc3, 				id_equipement, 				FORMAT(MAX(temp),2) AS temp_max, 				FORMAT(MIN(NULLIF(temp,0)),2) AS temp_min, 				FORMAT(AVG(NULLIF(temp,0)),2) AS temp_moy, CASE WHEN DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN 						    DATE_FORMAT(STR_TO_DATE('06-15', '%m-%d'), '%m-%d') AND 						    DATE_FORMAT(STR_TO_DATE('09-15', '%m-%d'), '%m-%d')  THEN 0 WHEN 17 = 0 THEN 0 		WHEN FORMAT(AVG(NULLIF(temp,0)),2) = 0 THEN 0 		WHEN 17 >= FORMAT(MAX(temp),2) THEN 0 		WHEN 17 <= FORMAT(MIN(NULLIF(temp,0)),2) THEN FORMAT(AVG(NULLIF(temp,0)),2)-17 		WHEN FORMAT(MIN(NULLIF(temp,0)),2) < 17 AND 17 <= FORMAT(MAX(temp),2) THEN (FORMAT(MAX(temp),2)-17) * (0.08+0.42* (FORMAT(MAX(NULLIF(temp,0)),2)-17) / (FORMAT(MAX(temp),2) - FORMAT(MIN(NULLIF(temp,0)),2))) 		END AS dju_clim,  CASE WHEN DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN 							DATE_FORMAT(STR_TO_DATE('10-15', '%m-%d'), '%m-%d') AND	'12-31' AND  						DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN	'01-01' AND 							DATE_FORMAT(STR_TO_DATE('04-15', '%m-%d'), '%m-%d')  THEN 0  WHEN 17 = 0 THEN 0 		WHEN 	FORMAT(AVG(NULLIF(temp,0)),2) = 0 THEN 0 		WHEN 17 >= FORMAT(MAX(temp),2) THEN 17 - FORMAT(AVG(NULLIF(temp,0)),2) 		WHEN 17 <= FORMAT(MIN(NULLIF(temp,0)),2) THEN 0 		WHEN FORMAT(MIN(NULLIF(temp,0)),2) < 17 AND 17 <= FORMAT(MAX(temp),2) THEN (17-FORMAT(MIN(NULLIF(temp,0)),2)) * (0.08+0.42* (17-FORMAT(MIN(NULLIF(temp,0)),2)) / (FORMAT(MAX(temp),2) - FORMAT(MIN(NULLIF(temp,0)),2))) 		END AS dju 	 FROM `conso_teleinfo`	INNER JOIN eqLogic ON id=id_equipement 	where rec_date >= SUBDATE(CURRENT_DATE, INTERVAL 1 DAY) GROUP BY rec_date,id_equipement
2389|[2024-04-14 13:20:03] INFO  : CrontabJour:REPLACE INTO conso_jour (`timestamp`,rec_date,periode,hp,hc,hp2,hc2,hp3,hc3,idx_max_hp,idx_min_hp,idx_max_hc,idx_min_hc,idx_max_hp2,idx_min_hp2,idx_max_hc2,idx_min_hc2,idx_max_hp3,idx_min_hp3,idx_max_hc3,idx_min_hc3,id_eq,temp_max,temp_min,temp_moy,dju_clim,dju) 				SELECT 				MIN(`timestamp`) AS `timestamp`  , 				`conso_teleinfo`.`rec_date` AS `rec_date`, 				DATE_FORMAT(`conso_teleinfo`.`rec_date`,'%a %e %y') AS `periode`, 	((MAX(`hchp`) - MIN(`hchp`)) / 1000)  AS hp, ((MAX(`hchc`) - MIN(`hchc`)) / 1000)  AS hc, ((MAX(`hchp2`) - MIN(`hchp2`)) / 1000)  AS hp2, ((MAX(`hchc2`) - MIN(`hchc2`)) / 1000)  AS hc2, ((MAX(`hchp3`) - MIN(`hchp3`)) / 1000)  AS hp3, ((MAX(`hchc3`) - MIN(`hchc3`)) / 1000)  AS h3,MAX(hchp) as idx_max_hp, 				MIN(hchp) as idx_min_hp, 				MAX(hchc) as idx_max_hc, 				MIN(hchc) as idx_min_hc, 				MAX(hchp2) as idx_max_hp2, 				MIN(hchp2) as idx_min_hp2, 				MAX(hchc2) as idx_max_hc2, 				MIN(hchc2) as idx_min_hc2, 				MAX(hchp3) as idx_max_hp3, 				MIN(hchp3) as idx_min_hp3, 				MAX(hchc3) as idx_max_hc3, 				MIN(hchc3) as idx_min_hc3, 				id_equipement, 				FORMAT(MAX(temp),2) AS temp_max, 				FORMAT(MIN(NULLIF(temp,0)),2) AS temp_min, 				FORMAT(AVG(NULLIF(temp,0)),2) AS temp_moy, CASE WHEN DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN 						    DATE_FORMAT(STR_TO_DATE('06-15', '%m-%d'), '%m-%d') AND 						    DATE_FORMAT(STR_TO_DATE('09-15', '%m-%d'), '%m-%d')  THEN 0 WHEN 17 = 0 THEN 0 		WHEN FORMAT(AVG(NULLIF(temp,0)),2) = 0 THEN 0 		WHEN 17 >= FORMAT(MAX(temp),2) THEN 0 		WHEN 17 <= FORMAT(MIN(NULLIF(temp,0)),2) THEN FORMAT(AVG(NULLIF(temp,0)),2)-17 		WHEN FORMAT(MIN(NULLIF(temp,0)),2) < 17 AND 17 <= FORMAT(MAX(temp),2) THEN (FORMAT(MAX(temp),2)-17) * (0.08+0.42* (FORMAT(MAX(NULLIF(temp,0)),2)-17) / (FORMAT(MAX(temp),2) - FORMAT(MIN(NULLIF(temp,0)),2))) 		END AS dju_clim,  CASE WHEN DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN 							DATE_FORMAT(STR_TO_DATE('10-15', '%m-%d'), '%m-%d') AND	'12-31' AND  						DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN	'01-01' AND 							DATE_FORMAT(STR_TO_DATE('04-15', '%m-%d'), '%m-%d')  THEN 0  WHEN 17 = 0 THEN 0 		WHEN 	FORMAT(AVG(NULLIF(temp,0)),2) = 0 THEN 0 		WHEN 17 >= FORMAT(MAX(temp),2) THEN 17 - FORMAT(AVG(NULLIF(temp,0)),2) 		WHEN 17 <= FORMAT(MIN(NULLIF(temp,0)),2) THEN 0 		WHEN FORMAT(MIN(NULLIF(temp,0)),2) < 17 AND 17 <= FORMAT(MAX(temp),2) THEN (17-FORMAT(MIN(NULLIF(temp,0)),2)) * (0.08+0.42* (17-FORMAT(MIN(NULLIF(temp,0)),2)) / (FORMAT(MAX(temp),2) - FORMAT(MIN(NULLIF(temp,0)),2))) 		END AS dju 	 FROM `conso_teleinfo`	INNER JOIN eqLogic ON id=id_equipement 	where rec_date >= SUBDATE(CURRENT_DATE, INTERVAL 1 DAY) GROUP BY rec_date,id_equipement

superbricolo · Avril 14, 2024, 12:51

Tu as fait testé sur ta commande avec les sommes pour vérifier si c’était ok?

nicoto94 · Avril 14, 2024, 12:55

ouais c est good

edit; j ai oublié une conso peut être que c est cela qui fait déconner le démon…?

superbricolo · Avril 14, 2024, 1:01

Je ne pense pas

nicoto94 · Avril 14, 2024, 1:05

Pourtant je n ai rien fait de particulier ; je n ai même pas effectuer la maj de chez Jeedom de peur d avoir un problème…

superbricolo · Avril 14, 2024, 1:07

tu peux faire une copie d’écran du paramétrage de ton équipement

nicoto94 · Avril 14, 2024, 1:21

Consommation:

( #[Chambre parentale][Module_chauffage_chb_parentale][Consommation]# + #[Chambre filles][Module_chauffage_chb_filles][Consommation]# + #[Chambre Hamza][Module_chauffage_chb_Hamza][Consommation]# + #[Salle d eau][Module_chauffage_chb_sde][Consommation]# + #[Salon][Virtuel_salon][Conso totale chauffage rdc]# )

Puissance:

( #[Chambre parentale][Module_chauffage_chb_parentale][Puissance]# + #[Chambre filles][Module_chauffage_chb_filles][Puissance]# + #[Chambre Hamza][Module_chauffage_chb_Hamza][Puissance]# + #[Salle d eau][Module_chauffage_chb_sde][Puissance]# + #[Salon][Virtuel_salon][Puissance chauffage rdc]# )

nicoto94 · Avril 14, 2024, 1:23

Et les autres équipements chauffage ont pour parent l équipement conso chauffage totale

superbricolo · Avril 14, 2024, 1:33

Tout me parait bien pourtant. Essais de ne pas mettre toutes les commandes pour essayer

nicoto94 · Avril 14, 2024, 1:34

commandes puissances ou conso ?

nicoto94 · Avril 14, 2024, 9:11

Salut Superbricolo, j avais essayé en indiquant dans l équipement conso chauffage totale; uniquement la puissance et la consommation d une de mes radiateurs …Sans succès

superbricolo · Avril 14, 2024, 9:53

J’ai réactivé ton équipement. Et là pour moi ça fonctionne. J’ai juste corrigé les données du jour car tu avais une énorme conso parce que que tu n’as pas tout renseigné dès le départ quand tu as sauvegardé l’équipement
Il faudra que tu remettes la somme

nicoto94 · Avril 14, 2024, 10:09

merci beaucoup et encore désolé pour le dérangement
Passes une bonne soirée

superbricolo · Avril 14, 2024, 10:13

En fait j’ai rien fait. Juste réactivé l’équipement

nicoto94 · Avril 14, 2024, 10:20

Je l avais désactivé afin de vérifier si j avais toujours des erreurs dans les logs du plugin suivi conso…
J ai toujours le démon qui s arrête

0088|[2024-04-15 00:15:05] ERROR  : Erreur sur la fonction deamon_start du plugin : Vous devez attendre au moins 45 secondes entre deux lancements du démon. Dernier lancement : 2024-04-15 00:15:04

EDIT:

nicoto94 · Avril 15, 2024, 6:44

Salut superbricolo
C est bizarre ; j ai des messages récurrents comme si les équipements ne communiquaient avec le plu plugin…?

0128|[2024-04-15 08:25:04] ERROR  : Erreur sur la fonction deamon_start du plugin : Vous devez attendre au moins 45 secondes entre deux lancements du démon. Dernier lancement : 2024-04-15 08:25:04
0129|[2024-04-15 08:40:03] INFO  : CrontabJour:REPLACE INTO conso_jour (`timestamp`,rec_date,periode,hp,hc,hp2,hc2,hp3,hc3,idx_max_hp,idx_min_hp,idx_max_hc,idx_min_hc,idx_max_hp2,idx_min_hp2,idx_max_hc2,idx_min_hc2,idx_max_hp3,idx_min_hp3,idx_max_hc3,idx_min_hc3,id_eq,temp_max,temp_min,temp_moy,dju_clim,dju) 				SELECT 				MIN(`timestamp`) AS `timestamp`  , 				`conso_teleinfo`.`rec_date` AS `rec_date`, 				DATE_FORMAT(`conso_teleinfo`.`rec_date`,'%a %e %y') AS `periode`, 	((MAX(`hchp`) - MIN(`hchp`)) / 1000)  AS hp, ((MAX(`hchc`) - MIN(`hchc`)) / 1000)  AS hc, ((MAX(`hchp2`) - MIN(`hchp2`)) / 1000)  AS hp2, ((MAX(`hchc2`) - MIN(`hchc2`)) / 1000)  AS hc2, ((MAX(`hchp3`) - MIN(`hchp3`)) / 1000)  AS hp3, ((MAX(`hchc3`) - MIN(`hchc3`)) / 1000)  AS h3,MAX(hchp) as idx_max_hp, 				MIN(hchp) as idx_min_hp, 				MAX(hchc) as idx_max_hc, 				MIN(hchc) as idx_min_hc, 				MAX(hchp2) as idx_max_hp2, 				MIN(hchp2) as idx_min_hp2, 				MAX(hchc2) as idx_max_hc2, 				MIN(hchc2) as idx_min_hc2, 				MAX(hchp3) as idx_max_hp3, 				MIN(hchp3) as idx_min_hp3, 				MAX(hchc3) as idx_max_hc3, 				MIN(hchc3) as idx_min_hc3, 				id_equipement, 				FORMAT(MAX(temp),2) AS temp_max, 				FORMAT(MIN(NULLIF(temp,0)),2) AS temp_min, 				FORMAT(AVG(NULLIF(temp,0)),2) AS temp_moy, CASE WHEN DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN 						    DATE_FORMAT(STR_TO_DATE('06-15', '%m-%d'), '%m-%d') AND 						    DATE_FORMAT(STR_TO_DATE('09-15', '%m-%d'), '%m-%d')  THEN 0 WHEN 17 = 0 THEN 0 		WHEN FORMAT(AVG(NULLIF(temp,0)),2) = 0 THEN 0 		WHEN 17 >= FORMAT(MAX(temp),2) THEN 0 		WHEN 17 <= FORMAT(MIN(NULLIF(temp,0)),2) THEN FORMAT(AVG(NULLIF(temp,0)),2)-17 		WHEN FORMAT(MIN(NULLIF(temp,0)),2) < 17 AND 17 <= FORMAT(MAX(temp),2) THEN (FORMAT(MAX(temp),2)-17) * (0.08+0.42* (FORMAT(MAX(NULLIF(temp,0)),2)-17) / (FORMAT(MAX(temp),2) - FORMAT(MIN(NULLIF(temp,0)),2))) 		END AS dju_clim,  CASE WHEN DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN 							DATE_FORMAT(STR_TO_DATE('10-15', '%m-%d'), '%m-%d') AND	'12-31' AND  						DATE_FORMAT(rec_date, '%m-%d') NOT BETWEEN	'01-01' AND 							DATE_FORMAT(STR_TO_DATE('04-15', '%m-%d'), '%m-%d')  THEN 0  WHEN 17 = 0 THEN 0 		WHEN 	FORMAT(AVG(NULLIF(temp,0)),2) = 0 THEN 0 		WHEN 17 >= FORMAT(MAX(temp),2) THEN 17 - FORMAT(AVG(NULLIF(temp,0)),2) 		WHEN 17 <= FORMAT(MIN(NULLIF(temp,0)),2) THEN 0 		WHEN FORMAT(MIN(NULLIF(temp,0)),2) < 17 AND 17 <= FORMAT(MAX(temp),2) THEN (17-FORMAT(MIN(NULLIF(temp,0)),2)) * (0.08+0.42* (17-FORMAT(MIN(NULLIF(temp,0)),2)) / (FORMAT(MAX(temp),2) - FORMAT(MIN(NULLIF(temp,0)),2))) 		END AS dju 	 FROM `conso_teleinfo`	INNER JOIN eqLogic ON id=id_equipement 	where rec_date >= SUBDATE(CURRENT_DATE, INTERVAL 1 DAY) GROUP BY rec_date,id_equipement

superbricolo · Avril 15, 2024, 8:09

C’est bizarre, car hier quand j’ai réactivé il n’y avait pas d’erreurs. Je me reconnecte et jette un coup d’oeil vite fait

superbricolo · Avril 15, 2024, 8:31

Je pense que tu as un soucis avec les sommes de tes consommations

A mon avis tu sommes des kWh avec des Wh. Je pense que #[Salon][Virtuel_salon][Conso totale chauffage rdc]# est en Wh, hors toi tu l’as considéré en kWh.

On le voit dans les données, car quand tu as de la consommation ça augmente trop vite.

Du coup j’ai corrigé ton paramétrage comme ça:

#[Chambre parentale][Module_chauffage_chb_parentale][Consommation]# + #[Chambre filles][Module_chauffage_chb_filles][Consommation]# + #[Chambre Hamza][Module_chauffage_chb_Hamza][Consommation]# + #[Salle d eau][Module_chauffage_chb_sde][Consommation]# + #[Salon][Virtuel_salon][Conso totale chauffage rdc]#/1000

Sinon j’ai corrigé encore un écart important sur la journée sans doute quand tu as ajouté les sommes

Le problème provient en fait de l’écart trop important sur 1 journée qui doit dépasser la taille de la colonne dans la base de données. comme j’ai re-corrigé, il n’y a plus d’erreur