[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:29][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:30][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:30][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:30][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:30][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:30][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:30][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:30][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:30][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:30][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:30][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:30][DEBUG] : panel_price HP type_abo:HP
[2024-04-04 18:42:30][INFO] : N° parent:672
[2024-04-04 18:42:30][DEBUG] : GetTabPie Requete:SELECT 				myid AS id, 				 IF(IFNULL(istotal,0)>0 ,"Total",IF(categorie="NC",myname,categorie))  AS name_cat, 				isHCHP , 				istotal , 				IFNULL(SUM(shc),0) + IFNULL(SUM(shc2),0) + IFNULL(SUM(shc3),0) AS totalhc, 				IFNULL(SUM(shp),0) + IFNULL(SUM(shp2),0) + IFNULL(SUM(shp3),0) AS totalhp, 				IFNULL(ROUND(SUM(shp)+SUM(shc),2),0) +IFNULL(ROUND(SUM(shp2)+SUM(shc2),2),0) + IFNULL(ROUND(SUM(shp3)+SUM(shc3),2),0) AS total,  				ROUND(SUM(hcprix),2) + ROUND(SUM(hcprix2),2) + ROUND(SUM(hcprix3),2) AS  prixhc, 				ROUND(SUM(hpprix),2) + ROUND(SUM(hpprix2),2) + ROUND(SUM(hpprix3),2) AS  prixhp, 				ROUND(SUM(totalprix),2) AS prix,  				IFNULL(ROUND((SUM(shc)+SUM(shc2)+SUM(shc3))*100/(case WHEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) > (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) THEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) ELSE (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) END),2),0) AS total_percent_ecq_hc, 				IFNULL(ROUND((SUM(shp)+SUM(shp2)+SUM(shp3))*100/(case WHEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) > (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) THEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) ELSE (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) END),2),0) AS total_percent_ecq_hp, 				IFNULL((SUM(shc)+SUM(shc2)+SUM(shc3))*100/(SUM(shp)+SUM(shc)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)),0) AS percent_ecq_hc, 				IFNULL((SUM(shp)+SUM(shp2)+SUM(shp3))*100/(SUM(shp)+SUM(shc)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)),0) AS percent_ecq_hp,  				IFNULL(ROUND((SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3))*100/ (case WHEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) > (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) THEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) ELSE (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) END),2),0) AS percent_ecq_reel, 				IFNULL(ROUND((SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3))*100/ (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3),2),0) AS percent_ecq, 				myid 			FROM ( 				SELECT 					CASE 						WHEN configuration  like  '%"visibleConsumptionLight":"1"%' THEN "Lumieres" 						WHEN configuration  like  '%"visibleConsumptionElectrical":"1"%' THEN "Electromenager" 						WHEN configuration  like  '%"visibleConsumptionAutomatism":"1"%' THEN "Automatisme" 						WHEN configuration  like  '%"visibleConsumptionHeating":"1"%' THEN "Chauffage" 						WHEN configuration  like  '%"visibleConsumptionMultimedia":"1"%' THEN "Multimedia" 						WHEN configuration  LIKE  '%"visibleConsumptionVehicules":"1"%' THEN "Véhicules" 						WHEN configuration  LIKE  '%"visibleConsumptionHardware":"1"%' THEN "Mat. Informatique" 						WHEN configuration  LIKE  '%"visibleConsumptionAirConditioner":"1"%' THEN "Climatisation" 						WHEN configuration  LIKE  '%"visibleConsumptionSwimmingPool":"1"%' THEN "Piscine" 						WHEN configuration  LIKE  '%"visibleConsumptionAutomation":"1"%' THEN "Domotique" 						WHEN configuration  LIKE  '%"visibleConsumptionOther":"1"%' THEN "Autres" 						ELSE "NC" 					END as categorie, 				id AS myid, 				IF(INSTR(configuration, '"type_abo":"HCHP"' )>0 or INSTR(configuration, '"type_abo":"TEMPO"' )>0, 1 , 0 ) AS isHCHP , 				IF(INSTR(configuration, '"total":"1"' )>0 or id = 672, 1 , 0 ) AS istotal , 				NAME AS myname, 				/* MIN(j.rec_date) AS DATE,*/ 				periode, 				hc AS shc, 				hp AS shp, 				hc2 AS shc2, 				hp2 AS shp2, 				hc3 AS shc3, 				hp3 AS shp3, 				totalhp, 				totalhc, 				totalhp2, 				totalhc2, 				totalhp3, 				totalhc3, 				prix_hc * hc AS hcprix, 				prix_hp * hp AS hpprix, 				prix_hc2 * hc2 AS hcprix2, 				prix_hp2 * hp2 AS hpprix2, 				prix_hc3 * hc3 AS hcprix3, 				prix_hp3 * hp3 AS hpprix3, 				(prix_hc * hc) + (prix_hp * hp) + (prix_hc2 * hc2) + (prix_hp2 * hp2) + (prix_hc3 * hc3) + (prix_hp3 * hp3) AS totalprix, 				DATE_FORMAT(j.`rec_date`,"%d%c%Y") AS mois, 				j.`rec_date`, 				p.id_eq 				FROM conso_jour j 				INNER JOIN 				( 					SELECT jo.id_eq, 					DATE_FORMAT(jo.`rec_date`,"%d%c%Y"), 					jo.rec_date, 					SUM(hp) AS totalhp, 					SUM(hc) AS totalhc, 					SUM(hp2) AS totalhp2, 					SUM(hc2) AS totalhc2, 					SUM(hp3) AS totalhp3, 					SUM(hc3) AS totalhc3, 					(SELECT FORMAT(hc,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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 hp FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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(hc2,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hc2, 					(SELECT FORMAT(hp2,4) AS hp FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hp2, 					(SELECT FORMAT(hc3,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hc3, 					(SELECT FORMAT(hp3,4) AS hp FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hp3 					FROM 						conso_jour jo 					INNER JOIN 						eqLogic eqc ON eqc.id = jo.id_eq 					WHERE 						jo.id_eq in (932,989,990,997,998,1000,1001,1003,1004,1005,1006,1008,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1024,1025,1041,1042,1048,1053,1055,1060,1066,1091,1168,1211,1220,1234,1239,1241,1242,672) and 						DATE_FORMAT(jo.`rec_date`,"%d%c%Y")  = DATE_FORMAT(CURDATE()- INTERVAL 0 DAY,"%d%c%Y") 						AND   configuration LIKE "%elect%" 						AND (configuration LIKE '%"total":"1"%' or id = 672) 					GROUP BY 						DATE_FORMAT(jo.`rec_date`,"%d%c%Y"), jo.id_eq 				    ) AS p ON DATE_FORMAT(p.`rec_date`,"%d%c%Y") = DATE_FORMAT(j.`rec_date`,"%d%c%Y")  				INNER JOIN eqLogic eq ON eq.id = j.id_eq AND isEnable = 1 				WHERE 				j.id_eq in (932,989,990,997,998,1000,1001,1003,1004,1005,1006,1008,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1024,1025,1041,1042,1048,1053,1055,1060,1066,1091,1168,1211,1220,1234,1239,1241,1242,672) and 				DATE_FORMAT(j.`rec_date`,"%d%c%Y")  = DATE_FORMAT(CURDATE()- INTERVAL 0 DAY,"%d%c%Y")  AND 				configuration LIKE "%elect%" 				/* GROUP BY  j.id_eq*/ 			) AS res 			 GROUP BY  DATE_FORMAT(res.`rec_date`,"%d%c%Y"), name_cat ORDER BY istotal DESC 
[2024-04-04 18:42:30][DEBUG] : GetTabpie Total global HP < total HP id:672 Total HC:0 Total HC:0
[2024-04-04 18:42:30][DEBUG] : GetTabpie id:672 Total HC:0 Total HP:1049.9150448367
[2024-04-04 18:42:30][DEBUG] : GetTabPie Equipement:42
[2024-04-04 18:42:30][INFO] : N° parent:672
[2024-04-04 18:42:30][DEBUG] : GetTabPie Requete:SELECT 				myid AS id, 				 IF(IFNULL(istotal,0)>0 ,"Total",IF(categorie="NC",myname,categorie))  AS name_cat, 				isHCHP , 				istotal , 				IFNULL(SUM(shc),0) + IFNULL(SUM(shc2),0) + IFNULL(SUM(shc3),0) AS totalhc, 				IFNULL(SUM(shp),0) + IFNULL(SUM(shp2),0) + IFNULL(SUM(shp3),0) AS totalhp, 				IFNULL(ROUND(SUM(shp)+SUM(shc),2),0) +IFNULL(ROUND(SUM(shp2)+SUM(shc2),2),0) + IFNULL(ROUND(SUM(shp3)+SUM(shc3),2),0) AS total,  				ROUND(SUM(hcprix),2) + ROUND(SUM(hcprix2),2) + ROUND(SUM(hcprix3),2) AS  prixhc, 				ROUND(SUM(hpprix),2) + ROUND(SUM(hpprix2),2) + ROUND(SUM(hpprix3),2) AS  prixhp, 				ROUND(SUM(totalprix),2) AS prix,  				IFNULL(ROUND((SUM(shc)+SUM(shc2)+SUM(shc3))*100/(case WHEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) > (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) THEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) ELSE (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) END),2),0) AS total_percent_ecq_hc, 				IFNULL(ROUND((SUM(shp)+SUM(shp2)+SUM(shp3))*100/(case WHEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) > (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) THEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) ELSE (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) END),2),0) AS total_percent_ecq_hp, 				IFNULL((SUM(shc)+SUM(shc2)+SUM(shc3))*100/(SUM(shp)+SUM(shc)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)),0) AS percent_ecq_hc, 				IFNULL((SUM(shp)+SUM(shp2)+SUM(shp3))*100/(SUM(shp)+SUM(shc)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)),0) AS percent_ecq_hp,  				IFNULL(ROUND((SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3))*100/ (case WHEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) > (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) THEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) ELSE (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) END),2),0) AS percent_ecq_reel, 				IFNULL(ROUND((SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3))*100/ (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3),2),0) AS percent_ecq, 				myid 			FROM ( 				SELECT 					CASE 						WHEN configuration  like  '%"visibleConsumptionLight":"1"%' THEN "Lumieres" 						WHEN configuration  like  '%"visibleConsumptionElectrical":"1"%' THEN "Electromenager" 						WHEN configuration  like  '%"visibleConsumptionAutomatism":"1"%' THEN "Automatisme" 						WHEN configuration  like  '%"visibleConsumptionHeating":"1"%' THEN "Chauffage" 						WHEN configuration  like  '%"visibleConsumptionMultimedia":"1"%' THEN "Multimedia" 						WHEN configuration  LIKE  '%"visibleConsumptionVehicules":"1"%' THEN "Véhicules" 						WHEN configuration  LIKE  '%"visibleConsumptionHardware":"1"%' THEN "Mat. Informatique" 						WHEN configuration  LIKE  '%"visibleConsumptionAirConditioner":"1"%' THEN "Climatisation" 						WHEN configuration  LIKE  '%"visibleConsumptionSwimmingPool":"1"%' THEN "Piscine" 						WHEN configuration  LIKE  '%"visibleConsumptionAutomation":"1"%' THEN "Domotique" 						WHEN configuration  LIKE  '%"visibleConsumptionOther":"1"%' THEN "Autres" 						ELSE "NC" 					END as categorie, 				id AS myid, 				IF(INSTR(configuration, '"type_abo":"HCHP"' )>0 or INSTR(configuration, '"type_abo":"TEMPO"' )>0, 1 , 0 ) AS isHCHP , 				IF(INSTR(configuration, '"total":"1"' )>0 or id = 672, 1 , 0 ) AS istotal , 				NAME AS myname, 				/* MIN(j.rec_date) AS DATE,*/ 				periode, 				hc AS shc, 				hp AS shp, 				hc2 AS shc2, 				hp2 AS shp2, 				hc3 AS shc3, 				hp3 AS shp3, 				totalhp, 				totalhc, 				totalhp2, 				totalhc2, 				totalhp3, 				totalhc3, 				prix_hc * hc AS hcprix, 				prix_hp * hp AS hpprix, 				prix_hc2 * hc2 AS hcprix2, 				prix_hp2 * hp2 AS hpprix2, 				prix_hc3 * hc3 AS hcprix3, 				prix_hp3 * hp3 AS hpprix3, 				(prix_hc * hc) + (prix_hp * hp) + (prix_hc2 * hc2) + (prix_hp2 * hp2) + (prix_hc3 * hc3) + (prix_hp3 * hp3) AS totalprix, 				DATE_FORMAT(j.`rec_date`,"%d%c%Y") AS mois, 				j.`rec_date`, 				p.id_eq 				FROM conso_jour j 				INNER JOIN 				( 					SELECT jo.id_eq, 					DATE_FORMAT(jo.`rec_date`,"%d%c%Y"), 					jo.rec_date, 					SUM(hp) AS totalhp, 					SUM(hc) AS totalhc, 					SUM(hp2) AS totalhp2, 					SUM(hc2) AS totalhc2, 					SUM(hp3) AS totalhp3, 					SUM(hc3) AS totalhc3, 					(SELECT FORMAT(hc,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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 hp FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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(hc2,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hc2, 					(SELECT FORMAT(hp2,4) AS hp FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hp2, 					(SELECT FORMAT(hc3,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hc3, 					(SELECT FORMAT(hp3,4) AS hp FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hp3 					FROM 						conso_jour jo 					INNER JOIN 						eqLogic eqc ON eqc.id = jo.id_eq 					WHERE 						jo.id_eq in (932,989,990,997,998,1000,1001,1003,1004,1005,1006,1008,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1024,1025,1041,1042,1048,1053,1055,1060,1066,1091,1168,1211,1220,1234,1239,1241,1242,672) and 						DATE_FORMAT(jo.`rec_date`,"%d%c%Y")  = DATE_FORMAT(CURDATE()- INTERVAL 1 DAY,"%d%c%Y") 						AND   configuration LIKE "%elect%" 						AND (configuration LIKE '%"total":"1"%' or id = 672) 					GROUP BY 						DATE_FORMAT(jo.`rec_date`,"%d%c%Y"), jo.id_eq 				    ) AS p ON DATE_FORMAT(p.`rec_date`,"%d%c%Y") = DATE_FORMAT(j.`rec_date`,"%d%c%Y")  				INNER JOIN eqLogic eq ON eq.id = j.id_eq AND isEnable = 1 				WHERE 				j.id_eq in (932,989,990,997,998,1000,1001,1003,1004,1005,1006,1008,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1024,1025,1041,1042,1048,1053,1055,1060,1066,1091,1168,1211,1220,1234,1239,1241,1242,672) and 				DATE_FORMAT(j.`rec_date`,"%d%c%Y")  = DATE_FORMAT(CURDATE()- INTERVAL 1 DAY,"%d%c%Y")  AND 				configuration LIKE "%elect%" 				/* GROUP BY  j.id_eq*/ 			) AS res 			 GROUP BY  DATE_FORMAT(res.`rec_date`,"%d%c%Y"), name_cat ORDER BY istotal DESC 
[2024-04-04 18:42:30][DEBUG] : GetTabpie id:672 Total HC:0 Total HP:18.930999755859375
[2024-04-04 18:42:30][DEBUG] : GetTabPie Equipement:42
[2024-04-04 18:42:30][INFO] : N° parent:672
[2024-04-04 18:42:30][DEBUG] : GetTabPie Requete:SELECT 				myid AS id, 				 IF(IFNULL(istotal,0)>0 ,"Total",IF(categorie="NC",myname,categorie))  AS name_cat, 				isHCHP , 				istotal , 				IFNULL(SUM(shc),0) + IFNULL(SUM(shc2),0) + IFNULL(SUM(shc3),0) AS totalhc, 				IFNULL(SUM(shp),0) + IFNULL(SUM(shp2),0) + IFNULL(SUM(shp3),0) AS totalhp, 				IFNULL(ROUND(SUM(shp)+SUM(shc),2),0) +IFNULL(ROUND(SUM(shp2)+SUM(shc2),2),0) + IFNULL(ROUND(SUM(shp3)+SUM(shc3),2),0) AS total,  				ROUND(SUM(hcprix),2) + ROUND(SUM(hcprix2),2) + ROUND(SUM(hcprix3),2) AS  prixhc, 				ROUND(SUM(hpprix),2) + ROUND(SUM(hpprix2),2) + ROUND(SUM(hpprix3),2) AS  prixhp, 				ROUND(SUM(totalprix),2) AS prix,  				IFNULL(ROUND((SUM(shc)+SUM(shc2)+SUM(shc3))*100/(case WHEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) > (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) THEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) ELSE (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) END),2),0) AS total_percent_ecq_hc, 				IFNULL(ROUND((SUM(shp)+SUM(shp2)+SUM(shp3))*100/(case WHEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) > (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) THEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) ELSE (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) END),2),0) AS total_percent_ecq_hp, 				IFNULL((SUM(shc)+SUM(shc2)+SUM(shc3))*100/(SUM(shp)+SUM(shc)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)),0) AS percent_ecq_hc, 				IFNULL((SUM(shp)+SUM(shp2)+SUM(shp3))*100/(SUM(shp)+SUM(shc)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)),0) AS percent_ecq_hp,  				IFNULL(ROUND((SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3))*100/ (case WHEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) > (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) THEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) ELSE (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) END),2),0) AS percent_ecq_reel, 				IFNULL(ROUND((SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3))*100/ (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3),2),0) AS percent_ecq, 				myid 			FROM ( 				SELECT 					CASE 						WHEN configuration  like  '%"visibleConsumptionLight":"1"%' THEN "Lumieres" 						WHEN configuration  like  '%"visibleConsumptionElectrical":"1"%' THEN "Electromenager" 						WHEN configuration  like  '%"visibleConsumptionAutomatism":"1"%' THEN "Automatisme" 						WHEN configuration  like  '%"visibleConsumptionHeating":"1"%' THEN "Chauffage" 						WHEN configuration  like  '%"visibleConsumptionMultimedia":"1"%' THEN "Multimedia" 						WHEN configuration  LIKE  '%"visibleConsumptionVehicules":"1"%' THEN "Véhicules" 						WHEN configuration  LIKE  '%"visibleConsumptionHardware":"1"%' THEN "Mat. Informatique" 						WHEN configuration  LIKE  '%"visibleConsumptionAirConditioner":"1"%' THEN "Climatisation" 						WHEN configuration  LIKE  '%"visibleConsumptionSwimmingPool":"1"%' THEN "Piscine" 						WHEN configuration  LIKE  '%"visibleConsumptionAutomation":"1"%' THEN "Domotique" 						WHEN configuration  LIKE  '%"visibleConsumptionOther":"1"%' THEN "Autres" 						ELSE "NC" 					END as categorie, 				id AS myid, 				IF(INSTR(configuration, '"type_abo":"HCHP"' )>0 or INSTR(configuration, '"type_abo":"TEMPO"' )>0, 1 , 0 ) AS isHCHP , 				IF(INSTR(configuration, '"total":"1"' )>0 or id = 672, 1 , 0 ) AS istotal , 				NAME AS myname, 				/* MIN(j.rec_date) AS DATE,*/ 				periode, 				hc AS shc, 				hp AS shp, 				hc2 AS shc2, 				hp2 AS shp2, 				hc3 AS shc3, 				hp3 AS shp3, 				totalhp, 				totalhc, 				totalhp2, 				totalhc2, 				totalhp3, 				totalhc3, 				prix_hc * hc AS hcprix, 				prix_hp * hp AS hpprix, 				prix_hc2 * hc2 AS hcprix2, 				prix_hp2 * hp2 AS hpprix2, 				prix_hc3 * hc3 AS hcprix3, 				prix_hp3 * hp3 AS hpprix3, 				(prix_hc * hc) + (prix_hp * hp) + (prix_hc2 * hc2) + (prix_hp2 * hp2) + (prix_hc3 * hc3) + (prix_hp3 * hp3) AS totalprix, 				DATE_FORMAT(j.`rec_date`,"%c%Y") AS mois, 				j.`rec_date`, 				p.id_eq 				FROM conso_jour j 				INNER JOIN 				( 					SELECT jo.id_eq, 					DATE_FORMAT(jo.`rec_date`,"%c%Y"), 					jo.rec_date, 					SUM(hp) AS totalhp, 					SUM(hc) AS totalhc, 					SUM(hp2) AS totalhp2, 					SUM(hc2) AS totalhc2, 					SUM(hp3) AS totalhp3, 					SUM(hc3) AS totalhc3, 					(SELECT FORMAT(hc,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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 hp FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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(hc2,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hc2, 					(SELECT FORMAT(hp2,4) AS hp FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hp2, 					(SELECT FORMAT(hc3,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hc3, 					(SELECT FORMAT(hp3,4) AS hp FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hp3 					FROM 						conso_jour jo 					INNER JOIN 						eqLogic eqc ON eqc.id = jo.id_eq 					WHERE 						jo.id_eq in (932,989,990,997,998,1000,1001,1003,1004,1005,1006,1008,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1024,1025,1041,1042,1048,1053,1055,1060,1066,1091,1168,1211,1220,1234,1239,1241,1242,672) and 						DATE_FORMAT(jo.`rec_date`,"%c%Y")  = DATE_FORMAT(CURDATE()- INTERVAL 0 DAY,"%c%Y") 						AND   configuration LIKE "%elect%" 						AND (configuration LIKE '%"total":"1"%' or id = 672) 					GROUP BY 						DATE_FORMAT(jo.`rec_date`,"%c%Y"), jo.id_eq 				    ) AS p ON DATE_FORMAT(p.`rec_date`,"%c%Y") = DATE_FORMAT(j.`rec_date`,"%c%Y")  				INNER JOIN eqLogic eq ON eq.id = j.id_eq AND isEnable = 1 				WHERE 				j.id_eq in (932,989,990,997,998,1000,1001,1003,1004,1005,1006,1008,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1024,1025,1041,1042,1048,1053,1055,1060,1066,1091,1168,1211,1220,1234,1239,1241,1242,672) and 				DATE_FORMAT(j.`rec_date`,"%c%Y")  = DATE_FORMAT(CURDATE()- INTERVAL 0 DAY,"%c%Y")  AND 				configuration LIKE "%elect%" 				/* GROUP BY  j.id_eq*/ 			) AS res 			 GROUP BY  DATE_FORMAT(res.`rec_date`,"%c%Y"), name_cat ORDER BY istotal DESC 
[2024-04-04 18:42:30][DEBUG] : GetTabpie Total global HP < total HP id:672 Total HC:0 Total HC:0
[2024-04-04 18:42:30][DEBUG] : GetTabpie id:672 Total HC:0 Total HP:3262.9170220178
[2024-04-04 18:42:30][DEBUG] : GetTabPie Equipement:42
[2024-04-04 18:42:30][INFO] : N° parent:672
[2024-04-04 18:42:30][DEBUG] : GetTabPie Requete:SELECT 				myid AS id, 				 IF(IFNULL(istotal,0)>0 ,"Total",IF(categorie="NC",myname,categorie))  AS name_cat, 				isHCHP , 				istotal , 				IFNULL(SUM(shc),0) + IFNULL(SUM(shc2),0) + IFNULL(SUM(shc3),0) AS totalhc, 				IFNULL(SUM(shp),0) + IFNULL(SUM(shp2),0) + IFNULL(SUM(shp3),0) AS totalhp, 				IFNULL(ROUND(SUM(shp)+SUM(shc),2),0) +IFNULL(ROUND(SUM(shp2)+SUM(shc2),2),0) + IFNULL(ROUND(SUM(shp3)+SUM(shc3),2),0) AS total,  				ROUND(SUM(hcprix),2) + ROUND(SUM(hcprix2),2) + ROUND(SUM(hcprix3),2) AS  prixhc, 				ROUND(SUM(hpprix),2) + ROUND(SUM(hpprix2),2) + ROUND(SUM(hpprix3),2) AS  prixhp, 				ROUND(SUM(totalprix),2) AS prix,  				IFNULL(ROUND((SUM(shc)+SUM(shc2)+SUM(shc3))*100/(case WHEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) > (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) THEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) ELSE (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) END),2),0) AS total_percent_ecq_hc, 				IFNULL(ROUND((SUM(shp)+SUM(shp2)+SUM(shp3))*100/(case WHEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) > (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) THEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) ELSE (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) END),2),0) AS total_percent_ecq_hp, 				IFNULL((SUM(shc)+SUM(shc2)+SUM(shc3))*100/(SUM(shp)+SUM(shc)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)),0) AS percent_ecq_hc, 				IFNULL((SUM(shp)+SUM(shp2)+SUM(shp3))*100/(SUM(shp)+SUM(shc)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)),0) AS percent_ecq_hp,  				IFNULL(ROUND((SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3))*100/ (case WHEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) > (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) THEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) ELSE (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) END),2),0) AS percent_ecq_reel, 				IFNULL(ROUND((SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3))*100/ (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3),2),0) AS percent_ecq, 				myid 			FROM ( 				SELECT 					CASE 						WHEN configuration  like  '%"visibleConsumptionLight":"1"%' THEN "Lumieres" 						WHEN configuration  like  '%"visibleConsumptionElectrical":"1"%' THEN "Electromenager" 						WHEN configuration  like  '%"visibleConsumptionAutomatism":"1"%' THEN "Automatisme" 						WHEN configuration  like  '%"visibleConsumptionHeating":"1"%' THEN "Chauffage" 						WHEN configuration  like  '%"visibleConsumptionMultimedia":"1"%' THEN "Multimedia" 						WHEN configuration  LIKE  '%"visibleConsumptionVehicules":"1"%' THEN "Véhicules" 						WHEN configuration  LIKE  '%"visibleConsumptionHardware":"1"%' THEN "Mat. Informatique" 						WHEN configuration  LIKE  '%"visibleConsumptionAirConditioner":"1"%' THEN "Climatisation" 						WHEN configuration  LIKE  '%"visibleConsumptionSwimmingPool":"1"%' THEN "Piscine" 						WHEN configuration  LIKE  '%"visibleConsumptionAutomation":"1"%' THEN "Domotique" 						WHEN configuration  LIKE  '%"visibleConsumptionOther":"1"%' THEN "Autres" 						ELSE "NC" 					END as categorie, 				id AS myid, 				IF(INSTR(configuration, '"type_abo":"HCHP"' )>0 or INSTR(configuration, '"type_abo":"TEMPO"' )>0, 1 , 0 ) AS isHCHP , 				IF(INSTR(configuration, '"total":"1"' )>0 or id = 672, 1 , 0 ) AS istotal , 				NAME AS myname, 				/* MIN(j.rec_date) AS DATE,*/ 				periode, 				hc AS shc, 				hp AS shp, 				hc2 AS shc2, 				hp2 AS shp2, 				hc3 AS shc3, 				hp3 AS shp3, 				totalhp, 				totalhc, 				totalhp2, 				totalhc2, 				totalhp3, 				totalhc3, 				prix_hc * hc AS hcprix, 				prix_hp * hp AS hpprix, 				prix_hc2 * hc2 AS hcprix2, 				prix_hp2 * hp2 AS hpprix2, 				prix_hc3 * hc3 AS hcprix3, 				prix_hp3 * hp3 AS hpprix3, 				(prix_hc * hc) + (prix_hp * hp) + (prix_hc2 * hc2) + (prix_hp2 * hp2) + (prix_hc3 * hc3) + (prix_hp3 * hp3) AS totalprix, 				DATE_FORMAT(j.`rec_date`,"%v%c%Y") AS mois, 				j.`rec_date`, 				p.id_eq 				FROM conso_jour j 				INNER JOIN 				( 					SELECT jo.id_eq, 					DATE_FORMAT(jo.`rec_date`,"%v%c%Y"), 					jo.rec_date, 					SUM(hp) AS totalhp, 					SUM(hc) AS totalhc, 					SUM(hp2) AS totalhp2, 					SUM(hc2) AS totalhc2, 					SUM(hp3) AS totalhp3, 					SUM(hc3) AS totalhc3, 					(SELECT FORMAT(hc,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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 hp FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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(hc2,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hc2, 					(SELECT FORMAT(hp2,4) AS hp FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hp2, 					(SELECT FORMAT(hc3,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hc3, 					(SELECT FORMAT(hp3,4) AS hp FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hp3 					FROM 						conso_jour jo 					INNER JOIN 						eqLogic eqc ON eqc.id = jo.id_eq 					WHERE 						jo.id_eq in (932,989,990,997,998,1000,1001,1003,1004,1005,1006,1008,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1024,1025,1041,1042,1048,1053,1055,1060,1066,1091,1168,1211,1220,1234,1239,1241,1242,672) and 						DATE_FORMAT(jo.`rec_date`,"%v%c%Y")  = DATE_FORMAT(CURDATE()- INTERVAL 0 DAY,"%v%c%Y") 						AND   configuration LIKE "%elect%" 						AND (configuration LIKE '%"total":"1"%' or id = 672) 					GROUP BY 						DATE_FORMAT(jo.`rec_date`,"%v%c%Y"), jo.id_eq 				    ) AS p ON DATE_FORMAT(p.`rec_date`,"%v%c%Y") = DATE_FORMAT(j.`rec_date`,"%v%c%Y")  				INNER JOIN eqLogic eq ON eq.id = j.id_eq AND isEnable = 1 				WHERE 				j.id_eq in (932,989,990,997,998,1000,1001,1003,1004,1005,1006,1008,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1024,1025,1041,1042,1048,1053,1055,1060,1066,1091,1168,1211,1220,1234,1239,1241,1242,672) and 				DATE_FORMAT(j.`rec_date`,"%v%c%Y")  = DATE_FORMAT(CURDATE()- INTERVAL 0 DAY,"%v%c%Y")  AND 				configuration LIKE "%elect%" 				/* GROUP BY  j.id_eq*/ 			) AS res 			 GROUP BY  DATE_FORMAT(res.`rec_date`,"%v%c%Y"), name_cat ORDER BY istotal DESC 
[2024-04-04 18:42:30][DEBUG] : GetTabpie Total global HP < total HP id:672 Total HC:0 Total HC:0
[2024-04-04 18:42:30][DEBUG] : GetTabpie id:672 Total HC:0 Total HP:3262.9170220178
[2024-04-04 18:42:30][DEBUG] : GetTabPie Equipement:42
[2024-04-04 18:42:30][INFO] : N° parent:672
[2024-04-04 18:42:30][DEBUG] : GetTabPie Requete:SELECT 				myid AS id, 				 IF(IFNULL(istotal,0)>0 ,"Total",IF(categorie="NC",myname,categorie))  AS name_cat, 				isHCHP , 				istotal , 				IFNULL(SUM(shc),0) + IFNULL(SUM(shc2),0) + IFNULL(SUM(shc3),0) AS totalhc, 				IFNULL(SUM(shp),0) + IFNULL(SUM(shp2),0) + IFNULL(SUM(shp3),0) AS totalhp, 				IFNULL(ROUND(SUM(shp)+SUM(shc),2),0) +IFNULL(ROUND(SUM(shp2)+SUM(shc2),2),0) + IFNULL(ROUND(SUM(shp3)+SUM(shc3),2),0) AS total,  				ROUND(SUM(hcprix),2) + ROUND(SUM(hcprix2),2) + ROUND(SUM(hcprix3),2) AS  prixhc, 				ROUND(SUM(hpprix),2) + ROUND(SUM(hpprix2),2) + ROUND(SUM(hpprix3),2) AS  prixhp, 				ROUND(SUM(totalprix),2) AS prix,  				IFNULL(ROUND((SUM(shc)+SUM(shc2)+SUM(shc3))*100/(case WHEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) > (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) THEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) ELSE (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) END),2),0) AS total_percent_ecq_hc, 				IFNULL(ROUND((SUM(shp)+SUM(shp2)+SUM(shp3))*100/(case WHEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) > (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) THEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) ELSE (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) END),2),0) AS total_percent_ecq_hp, 				IFNULL((SUM(shc)+SUM(shc2)+SUM(shc3))*100/(SUM(shp)+SUM(shc)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)),0) AS percent_ecq_hc, 				IFNULL((SUM(shp)+SUM(shp2)+SUM(shp3))*100/(SUM(shp)+SUM(shc)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)),0) AS percent_ecq_hp,  				IFNULL(ROUND((SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3))*100/ (case WHEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) > (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) THEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) ELSE (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) END),2),0) AS percent_ecq_reel, 				IFNULL(ROUND((SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3))*100/ (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3),2),0) AS percent_ecq, 				myid 			FROM ( 				SELECT 					CASE 						WHEN configuration  like  '%"visibleConsumptionLight":"1"%' THEN "Lumieres" 						WHEN configuration  like  '%"visibleConsumptionElectrical":"1"%' THEN "Electromenager" 						WHEN configuration  like  '%"visibleConsumptionAutomatism":"1"%' THEN "Automatisme" 						WHEN configuration  like  '%"visibleConsumptionHeating":"1"%' THEN "Chauffage" 						WHEN configuration  like  '%"visibleConsumptionMultimedia":"1"%' THEN "Multimedia" 						WHEN configuration  LIKE  '%"visibleConsumptionVehicules":"1"%' THEN "Véhicules" 						WHEN configuration  LIKE  '%"visibleConsumptionHardware":"1"%' THEN "Mat. Informatique" 						WHEN configuration  LIKE  '%"visibleConsumptionAirConditioner":"1"%' THEN "Climatisation" 						WHEN configuration  LIKE  '%"visibleConsumptionSwimmingPool":"1"%' THEN "Piscine" 						WHEN configuration  LIKE  '%"visibleConsumptionAutomation":"1"%' THEN "Domotique" 						WHEN configuration  LIKE  '%"visibleConsumptionOther":"1"%' THEN "Autres" 						ELSE "NC" 					END as categorie, 				id AS myid, 				IF(INSTR(configuration, '"type_abo":"HCHP"' )>0 or INSTR(configuration, '"type_abo":"TEMPO"' )>0, 1 , 0 ) AS isHCHP , 				IF(INSTR(configuration, '"total":"1"' )>0 or id = 672, 1 , 0 ) AS istotal , 				NAME AS myname, 				/* MIN(j.rec_date) AS DATE,*/ 				periode, 				hc AS shc, 				hp AS shp, 				hc2 AS shc2, 				hp2 AS shp2, 				hc3 AS shc3, 				hp3 AS shp3, 				totalhp, 				totalhc, 				totalhp2, 				totalhc2, 				totalhp3, 				totalhc3, 				prix_hc * hc AS hcprix, 				prix_hp * hp AS hpprix, 				prix_hc2 * hc2 AS hcprix2, 				prix_hp2 * hp2 AS hpprix2, 				prix_hc3 * hc3 AS hcprix3, 				prix_hp3 * hp3 AS hpprix3, 				(prix_hc * hc) + (prix_hp * hp) + (prix_hc2 * hc2) + (prix_hp2 * hp2) + (prix_hc3 * hc3) + (prix_hp3 * hp3) AS totalprix, 				DATE_FORMAT(j.`rec_date`,"%Y") AS mois, 				j.`rec_date`, 				p.id_eq 				FROM conso_jour j 				INNER JOIN 				( 					SELECT jo.id_eq, 					DATE_FORMAT(jo.`rec_date`,"%Y"), 					jo.rec_date, 					SUM(hp) AS totalhp, 					SUM(hc) AS totalhc, 					SUM(hp2) AS totalhp2, 					SUM(hc2) AS totalhc2, 					SUM(hp3) AS totalhp3, 					SUM(hc3) AS totalhc3, 					(SELECT FORMAT(hc,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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 hp FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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(hc2,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hc2, 					(SELECT FORMAT(hp2,4) AS hp FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hp2, 					(SELECT FORMAT(hc3,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hc3, 					(SELECT FORMAT(hp3,4) AS hp FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hp3 					FROM 						conso_jour jo 					INNER JOIN 						eqLogic eqc ON eqc.id = jo.id_eq 					WHERE 						jo.id_eq in (932,989,990,997,998,1000,1001,1003,1004,1005,1006,1008,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1024,1025,1041,1042,1048,1053,1055,1060,1066,1091,1168,1211,1220,1234,1239,1241,1242,672) and 						DATE_FORMAT(jo.`rec_date`,"%Y")  = DATE_FORMAT(CURDATE()- INTERVAL 0 DAY,"%Y") 						AND   configuration LIKE "%elect%" 						AND (configuration LIKE '%"total":"1"%' or id = 672) 					GROUP BY 						DATE_FORMAT(jo.`rec_date`,"%Y"), jo.id_eq 				    ) AS p ON DATE_FORMAT(p.`rec_date`,"%Y") = DATE_FORMAT(j.`rec_date`,"%Y")  				INNER JOIN eqLogic eq ON eq.id = j.id_eq AND isEnable = 1 				WHERE 				j.id_eq in (932,989,990,997,998,1000,1001,1003,1004,1005,1006,1008,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1024,1025,1041,1042,1048,1053,1055,1060,1066,1091,1168,1211,1220,1234,1239,1241,1242,672) and 				DATE_FORMAT(j.`rec_date`,"%Y")  = DATE_FORMAT(CURDATE()- INTERVAL 0 DAY,"%Y")  AND 				configuration LIKE "%elect%" 				/* GROUP BY  j.id_eq*/ 			) AS res 			 GROUP BY  DATE_FORMAT(res.`rec_date`,"%Y"), name_cat ORDER BY istotal DESC 
[2024-04-04 18:42:31][DEBUG] : GetTabpie Total global HP < total HP id:672 Total HC:0 Total HC:0
[2024-04-04 18:42:31][DEBUG] : GetTabpie id:672 Total HC:0 Total HP:19520.563128034
[2024-04-04 18:42:31][DEBUG] : GetTabPie Equipement:42
[2024-04-04 18:42:31][INFO] : N° parent:672
[2024-04-04 18:42:31][DEBUG] : GetTabPie Requete:SELECT 				myid AS id, 				 IF(IFNULL(istotal,0)>0 ,"Total",IF(categorie="NC",myname,categorie))  AS name_cat, 				isHCHP , 				istotal , 				IFNULL(SUM(shc),0) + IFNULL(SUM(shc2),0) + IFNULL(SUM(shc3),0) AS totalhc, 				IFNULL(SUM(shp),0) + IFNULL(SUM(shp2),0) + IFNULL(SUM(shp3),0) AS totalhp, 				IFNULL(ROUND(SUM(shp)+SUM(shc),2),0) +IFNULL(ROUND(SUM(shp2)+SUM(shc2),2),0) + IFNULL(ROUND(SUM(shp3)+SUM(shc3),2),0) AS total,  				ROUND(SUM(hcprix),2) + ROUND(SUM(hcprix2),2) + ROUND(SUM(hcprix3),2) AS  prixhc, 				ROUND(SUM(hpprix),2) + ROUND(SUM(hpprix2),2) + ROUND(SUM(hpprix3),2) AS  prixhp, 				ROUND(SUM(totalprix),2) AS prix,  				IFNULL(ROUND((SUM(shc)+SUM(shc2)+SUM(shc3))*100/(case WHEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) > (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) THEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) ELSE (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) END),2),0) AS total_percent_ecq_hc, 				IFNULL(ROUND((SUM(shp)+SUM(shp2)+SUM(shp3))*100/(case WHEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) > (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) THEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) ELSE (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) END),2),0) AS total_percent_ecq_hp, 				IFNULL((SUM(shc)+SUM(shc2)+SUM(shc3))*100/(SUM(shp)+SUM(shc)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)),0) AS percent_ecq_hc, 				IFNULL((SUM(shp)+SUM(shp2)+SUM(shp3))*100/(SUM(shp)+SUM(shc)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)),0) AS percent_ecq_hp,  				IFNULL(ROUND((SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3))*100/ (case WHEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) > (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) THEN (SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3)) ELSE (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3) END),2),0) AS percent_ecq_reel, 				IFNULL(ROUND((SUM(shc)+SUM(shp)+SUM(shc2)+SUM(shp2)+SUM(shc3)+SUM(shp3))*100/ (res.totalhc+res.totalhp+res.totalhc2+res.totalhp2+res.totalhc3+res.totalhp3),2),0) AS percent_ecq, 				myid 			FROM ( 				SELECT 					CASE 						WHEN configuration  like  '%"visibleConsumptionLight":"1"%' THEN "Lumieres" 						WHEN configuration  like  '%"visibleConsumptionElectrical":"1"%' THEN "Electromenager" 						WHEN configuration  like  '%"visibleConsumptionAutomatism":"1"%' THEN "Automatisme" 						WHEN configuration  like  '%"visibleConsumptionHeating":"1"%' THEN "Chauffage" 						WHEN configuration  like  '%"visibleConsumptionMultimedia":"1"%' THEN "Multimedia" 						WHEN configuration  LIKE  '%"visibleConsumptionVehicules":"1"%' THEN "Véhicules" 						WHEN configuration  LIKE  '%"visibleConsumptionHardware":"1"%' THEN "Mat. Informatique" 						WHEN configuration  LIKE  '%"visibleConsumptionAirConditioner":"1"%' THEN "Climatisation" 						WHEN configuration  LIKE  '%"visibleConsumptionSwimmingPool":"1"%' THEN "Piscine" 						WHEN configuration  LIKE  '%"visibleConsumptionAutomation":"1"%' THEN "Domotique" 						WHEN configuration  LIKE  '%"visibleConsumptionOther":"1"%' THEN "Autres" 						ELSE "NC" 					END as categorie, 				id AS myid, 				IF(INSTR(configuration, '"type_abo":"HCHP"' )>0 or INSTR(configuration, '"type_abo":"TEMPO"' )>0, 1 , 0 ) AS isHCHP , 				IF(INSTR(configuration, '"total":"1"' )>0 or id = 672, 1 , 0 ) AS istotal , 				NAME AS myname, 				/* MIN(j.rec_date) AS DATE,*/ 				periode, 				hc AS shc, 				hp AS shp, 				hc2 AS shc2, 				hp2 AS shp2, 				hc3 AS shc3, 				hp3 AS shp3, 				totalhp, 				totalhc, 				totalhp2, 				totalhc2, 				totalhp3, 				totalhc3, 				prix_hc * hc AS hcprix, 				prix_hp * hp AS hpprix, 				prix_hc2 * hc2 AS hcprix2, 				prix_hp2 * hp2 AS hpprix2, 				prix_hc3 * hc3 AS hcprix3, 				prix_hp3 * hp3 AS hpprix3, 				(prix_hc * hc) + (prix_hp * hp) + (prix_hc2 * hc2) + (prix_hp2 * hp2) + (prix_hc3 * hc3) + (prix_hp3 * hp3) AS totalprix, 				DATE_FORMAT(j.`rec_date`,"%Y") AS mois, 				j.`rec_date`, 				p.id_eq 				FROM conso_jour j 				INNER JOIN 				( 					SELECT jo.id_eq, 					DATE_FORMAT(jo.`rec_date`,"%Y"), 					jo.rec_date, 					SUM(hp) AS totalhp, 					SUM(hc) AS totalhc, 					SUM(hp2) AS totalhp2, 					SUM(hc2) AS totalhc2, 					SUM(hp3) AS totalhp3, 					SUM(hc3) AS totalhc3, 					(SELECT FORMAT(hc,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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 hp FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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(hc2,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hc2, 					(SELECT FORMAT(hp2,4) AS hp FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hp2, 					(SELECT FORMAT(hc3,4) AS hc FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hc3, 					(SELECT FORMAT(hp3,4) AS hp FROM conso_price  WHERE type_ecq LIKE "%elect%" AND UNIX_TIMESTAMP(DATE_FORMAT(jo.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_hp3 					FROM 						conso_jour jo 					INNER JOIN 						eqLogic eqc ON eqc.id = jo.id_eq 					WHERE 						jo.id_eq in (932,989,990,997,998,1000,1001,1003,1004,1005,1006,1008,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1024,1025,1041,1042,1048,1053,1055,1060,1066,1091,1168,1211,1220,1234,1239,1241,1242,672) and 						DATE_FORMAT(jo.`rec_date`,"%Y")  = DATE_FORMAT(CURDATE()- INTERVAL 365 DAY,"%Y") 						AND   configuration LIKE "%elect%" 						AND (configuration LIKE '%"total":"1"%' or id = 672) 					GROUP BY 						DATE_FORMAT(jo.`rec_date`,"%Y"), jo.id_eq 				    ) AS p ON DATE_FORMAT(p.`rec_date`,"%Y") = DATE_FORMAT(j.`rec_date`,"%Y")  				INNER JOIN eqLogic eq ON eq.id = j.id_eq AND isEnable = 1 				WHERE 				j.id_eq in (932,989,990,997,998,1000,1001,1003,1004,1005,1006,1008,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1024,1025,1041,1042,1048,1053,1055,1060,1066,1091,1168,1211,1220,1234,1239,1241,1242,672) and 				DATE_FORMAT(j.`rec_date`,"%Y")  = DATE_FORMAT(CURDATE()- INTERVAL 365 DAY,"%Y")  AND 				configuration LIKE "%elect%" 				/* GROUP BY  j.id_eq*/ 			) AS res 			 GROUP BY  DATE_FORMAT(res.`rec_date`,"%Y"), name_cat ORDER BY istotal DESC 
[2024-04-04 18:42:32][DEBUG] : GetTabpie Total global HP < total HP id:672 Total HC:0 Total HC:0
[2024-04-04 18:42:32][DEBUG] : GetTabpie id:672 Total HC:0 Total HP:13030.98080229
[2024-04-04 18:42:32][DEBUG] : GetTabPie Equipement:42
[2024-04-04 18:42:34][DEBUG] : Action loadingDash équipement:672 trame hier
[2024-04-04 18:42:38][DEBUG] : Recherche id en cours 2
[2024-04-04 18:42:38][DEBUG] :  Nb équipement avt:select count(*) as nb_equipement FROM `eqLogic` WHERE `eqType_name` = "conso" and configuration like '%\"parent_id\":\"672\"%' or id = 672
[2024-04-04 18:42:38][DEBUG] :  nb_equipement42