[2019-11-27 20:40:55][DEBUG] : GetCalculPrice Requete:  SELECT                             63 as id_equipement,                             id_parent,     					    tva, 						    tva_abo, 						    abonnement, 						    annee, 						    mois, 						    jour, 						    semaine, sum(hp) as hp,sum(hc) as hc ,  sum(total_hp) as total_hp,sum(total_hc) as total_hc , 	prix_hp, 						    prix_hc, 							temp_min, 							temp_max, 							temp_moy, 							dju, 							dju_clim, 							mois, 						     cat_jours   as categorie  , 						    rec_date FROM ( 						    SELECT 								FORMAT(MIN(temp_min),2) AS temp_min, 								FORMAT(MAX(temp_max),2) AS temp_max, 								FORMAT(AVG(temp_moy),2) AS temp_moy, 								SUM(dju) AS dju, 								SUM(dju_clim) AS dju_clim, 						        "non" as id_parent, 								`timestamp`, 								rec_date, 								rec_date as cat_jours, 								DATE_FORMAT(s.`rec_date`,"%Y") AS annee, 								DATE_FORMAT(s.`rec_date`,"%c") AS mois, 								DATE_FORMAT(s.`rec_date`,"%e") AS jour, 								DATE_FORMAT(s.`rec_date`,"%v") AS semaine, 								IF(DATE_FORMAT(s.`rec_date`,"%c") = 1 AND DATE_FORMAT(s.`rec_date`,"%v") = 52,CONCAT(DATE_FORMAT(s.`rec_date`,"sem %v")," ",DATE_FORMAT(DATE_SUB(s.`rec_date`, INTERVAL 1 YEAR),"%y")) , DATE_FORMAT(s.`rec_date`,"sem %v %y")) AS cat_semaine, /*Ajout du 1er janviers 2017 dans la semaie 52 de 2016*/ 								-- DATE_FORMAT(s.`rec_date`,"sem %v %y") AS cat_semaine, 								DATE_FORMAT(s.`rec_date`,"%b %y") AS cat_month, 								DATE_FORMAT(s.`rec_date`,"%y") AS cat_anne, 								ROUND(SUM(s.hp),2) AS hp, 								ROUND(SUM(s.hc),2) AS hc, 								(SELECT FORMAT(montant,2) AS abo FROM conso_abo aa	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as abonnement, 								(SELECT cst.valeur tva_abo FROM conso_abo aa	INNER JOIN conso_tva cst on cst.id = aa.id_tva	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as tva_abo, 								(SELECT FORMAT(hc,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1) as prix_hc, 								(SELECT FORMAT(hp,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as prix_hp, 							    (SELECT  FORMAT(valeur ,2)  FROM conso_tva where UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d")) limit 0,1) as tva, 							    SUM(ROUND((SELECT FORMAT(hc,4) AS hc FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hc, 2)) AS total_hc, 							    SUM(ROUND((SELECT FORMAT(hp,4) AS hp FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hp, 2)) AS total_hp 								FROM  conso_jour s 								WHERE id_eq = 63 AND  (	`timestamp` BETWEEN   UNIX_TIMESTAMP("2019-11-27") AND UNIX_TIMESTAMP("2019-11-27") or `rec_date` BETWEEN   "2019-11-27" AND "2019-11-27" )  GROUP BY   cat_jours  ORDER BY rec_date ASC) as req 										GROUP by  req.cat_jours   ORDER BY req.rec_date ASC	
[2019-11-27 20:40:55][DEBUG] : date_deb:2019-11-27 date_fin:2019-11-27
[2019-11-27 20:40:55][DEBUG] : requete taxe: 	SELECT 	 	DATE_FORMAT(s.`rec_date`,"sem %v %y")    as categorie  , 	conso_taxe.global, 	conso_taxe.inte, 	conso_taxe.fixe, 	ROUND(SUM(s.hp),2) AS hp, 	ROUND(SUM(s.hc),2) AS hc, 	ROUND(SUM(s.hc)+SUM(s.hp),2) AS total, 	rec_date, 	CASE WHEN conso_taxe.inte > 0 THEN ROUND(conso_taxe.prix * round(SUM(CASE WHEN conso_taxe.type_ecq = "water" THEN s.hc/1000 else s.hc END),2) * (1+(conso_tva.valeur/100)),2) ELSE 0 END AS inte_hc, 	CASE WHEN conso_taxe.inte > 0 THEN ROUND(conso_taxe.prix * round(SUM(CASE WHEN conso_taxe.type_ecq = "water" THEN s.hp/1000 else s.hp END),2) * (1+(conso_tva.valeur/100)),2) ELSE 0 END AS inte_hp, 	CASE WHEN conso_taxe.inte > 0 THEN ROUND(conso_taxe.prix * round(SUM(CASE WHEN conso_taxe.type_ecq = "water" THEN (s.hp)/1000 ELSE s.hp+s.hc END),2) * (1+(conso_tva.valeur/100)),2) ELSE 0 END AS total_inte, 	CASE WHEN conso_taxe.global > 0 THEN ROUND((round(SUM(CASE WHEN conso_taxe.type_ecq = "water" THEN (s.hp)/1000 else s.hp+s.hc END ),2)*conso_taxe.prix)*(1+(conso_tva.valeur/100)),2) ELSE 0 END AS multi_ttc, 	CASE WHEN conso_taxe.fixe > 0 THEN ROUND(conso_taxe.prix/(DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1)*(1+(conso_tva.valeur/100)),2) ELSE 0 END AS fixe_day, 	CASE WHEN conso_taxe.fixe > 0 THEN ROUND(conso_taxe.prix/(DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1)*(1+(conso_tva.valeur/100))*7,2) ELSE 0 END AS fixe_week, 	CASE WHEN conso_taxe.fixe > 0 THEN ROUND(conso_taxe.prix/(DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1)*(1+(conso_tva.valeur/100))* 			(CASE WHEN "2019-11-27" between conso_taxe.date_debut and conso_taxe.date_fin and "2019-11-27" between conso_taxe.date_debut and conso_taxe.date_fin THEN (DATEDIFF("2019-11-27","2019-11-27")+1)  			WHEN "2019-11-27" between conso_taxe.date_debut and conso_taxe.date_fin and "2019-11-27" > conso_taxe.date_fin THEN (DATEDIFF(conso_taxe.date_fin,"2019-11-27")+1) 			WHEN "2019-11-27" between conso_taxe.date_debut and conso_taxe.date_fin and "2019-11-27" < conso_taxe.date_debut THEN (DATEDIFF("2019-11-27",conso_taxe.date_debut)+1) 			ELSE (DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1) END),2) 		 ELSE 0 END AS fixe_month, 	CASE WHEN conso_taxe.fixe > 0 THEN ROUND(conso_taxe.prix/(DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1)*(1+(conso_tva.valeur/100))*365,2) ELSE 0 END AS fixe_year,  	conso_taxe.id, 	conso_taxe.libelle , 	conso_taxe.prix , 	rec_date AS cat_jours, 	DATE_FORMAT(s.`rec_date`,"%Y") AS annee, 	DATE_FORMAT(s.`rec_date`,"%c") AS mois, 	DATE_FORMAT(s.`rec_date`,"%e") AS jour, 	DATE_FORMAT(s.`rec_date`,"%v") AS semaine, 	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 	FROM  conso_jour s 	LEFT JOIN conso_taxe ON 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 conso_taxe.type_ecq = "electricity" 	LEFT JOIN conso_tva ON conso_taxe.id_tva = conso_tva.id 	WHERE id_eq =63 AND 	(`rec_date` BETWEEN   "2019-11-27" AND "2019-11-27" ) 	GROUP by categorie  ,conso_taxe.id ORDER BY rec_date ASC
[2019-11-27 20:40:55][DEBUG] : GetCalculPrice Requete:  SELECT                             63 as id_equipement,                             id_parent,     					    tva, 						    tva_abo, 						    abonnement, 						    annee, 						    mois, 						    jour, 						    semaine, sum(hp) as hp,sum(hc) as hc ,  sum(total_hp) as total_hp,sum(total_hc) as total_hc , 	prix_hp, 						    prix_hc, 							temp_min, 							temp_max, 							temp_moy, 							dju, 							dju_clim, 							mois, 						     cat_jours   as categorie  , 						    rec_date FROM ( 						    SELECT 								FORMAT(MIN(temp_min),2) AS temp_min, 								FORMAT(MAX(temp_max),2) AS temp_max, 								FORMAT(AVG(temp_moy),2) AS temp_moy, 								SUM(dju) AS dju, 								SUM(dju_clim) AS dju_clim, 						        "non" as id_parent, 								`timestamp`, 								rec_date, 								rec_date as cat_jours, 								DATE_FORMAT(s.`rec_date`,"%Y") AS annee, 								DATE_FORMAT(s.`rec_date`,"%c") AS mois, 								DATE_FORMAT(s.`rec_date`,"%e") AS jour, 								DATE_FORMAT(s.`rec_date`,"%v") AS semaine, 								IF(DATE_FORMAT(s.`rec_date`,"%c") = 1 AND DATE_FORMAT(s.`rec_date`,"%v") = 52,CONCAT(DATE_FORMAT(s.`rec_date`,"sem %v")," ",DATE_FORMAT(DATE_SUB(s.`rec_date`, INTERVAL 1 YEAR),"%y")) , DATE_FORMAT(s.`rec_date`,"sem %v %y")) AS cat_semaine, /*Ajout du 1er janviers 2017 dans la semaie 52 de 2016*/ 								-- DATE_FORMAT(s.`rec_date`,"sem %v %y") AS cat_semaine, 								DATE_FORMAT(s.`rec_date`,"%b %y") AS cat_month, 								DATE_FORMAT(s.`rec_date`,"%y") AS cat_anne, 								ROUND(SUM(s.hp),2) AS hp, 								ROUND(SUM(s.hc),2) AS hc, 								(SELECT FORMAT(montant,2) AS abo FROM conso_abo aa	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as abonnement, 								(SELECT cst.valeur tva_abo FROM conso_abo aa	INNER JOIN conso_tva cst on cst.id = aa.id_tva	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as tva_abo, 								(SELECT FORMAT(hc,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1) as prix_hc, 								(SELECT FORMAT(hp,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as prix_hp, 							    (SELECT  FORMAT(valeur ,2)  FROM conso_tva where UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d")) limit 0,1) as tva, 							    SUM(ROUND((SELECT FORMAT(hc,4) AS hc FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hc, 2)) AS total_hc, 							    SUM(ROUND((SELECT FORMAT(hp,4) AS hp FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hp, 2)) AS total_hp 								FROM  conso_jour s 								WHERE id_eq = 63 AND  (	`timestamp` BETWEEN   UNIX_TIMESTAMP("2019-11-26") AND UNIX_TIMESTAMP("2019-11-26") or `rec_date` BETWEEN   "2019-11-26" AND "2019-11-26" )  GROUP BY   cat_jours  ORDER BY rec_date ASC) as req 										GROUP by  req.cat_jours   ORDER BY req.rec_date ASC	
[2019-11-27 20:40:55][DEBUG] : date_deb:2019-11-26 date_fin:2019-11-26
[2019-11-27 20:40:55][DEBUG] : requete taxe: 	SELECT 	 	DATE_FORMAT(s.`rec_date`,"sem %v %y")    as categorie  , 	conso_taxe.global, 	conso_taxe.inte, 	conso_taxe.fixe, 	ROUND(SUM(s.hp),2) AS hp, 	ROUND(SUM(s.hc),2) AS hc, 	ROUND(SUM(s.hc)+SUM(s.hp),2) AS total, 	rec_date, 	CASE WHEN conso_taxe.inte > 0 THEN ROUND(conso_taxe.prix * round(SUM(CASE WHEN conso_taxe.type_ecq = "water" THEN s.hc/1000 else s.hc END),2) * (1+(conso_tva.valeur/100)),2) ELSE 0 END AS inte_hc, 	CASE WHEN conso_taxe.inte > 0 THEN ROUND(conso_taxe.prix * round(SUM(CASE WHEN conso_taxe.type_ecq = "water" THEN s.hp/1000 else s.hp END),2) * (1+(conso_tva.valeur/100)),2) ELSE 0 END AS inte_hp, 	CASE WHEN conso_taxe.inte > 0 THEN ROUND(conso_taxe.prix * round(SUM(CASE WHEN conso_taxe.type_ecq = "water" THEN (s.hp)/1000 ELSE s.hp+s.hc END),2) * (1+(conso_tva.valeur/100)),2) ELSE 0 END AS total_inte, 	CASE WHEN conso_taxe.global > 0 THEN ROUND((round(SUM(CASE WHEN conso_taxe.type_ecq = "water" THEN (s.hp)/1000 else s.hp+s.hc END ),2)*conso_taxe.prix)*(1+(conso_tva.valeur/100)),2) ELSE 0 END AS multi_ttc, 	CASE WHEN conso_taxe.fixe > 0 THEN ROUND(conso_taxe.prix/(DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1)*(1+(conso_tva.valeur/100)),2) ELSE 0 END AS fixe_day, 	CASE WHEN conso_taxe.fixe > 0 THEN ROUND(conso_taxe.prix/(DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1)*(1+(conso_tva.valeur/100))*7,2) ELSE 0 END AS fixe_week, 	CASE WHEN conso_taxe.fixe > 0 THEN ROUND(conso_taxe.prix/(DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1)*(1+(conso_tva.valeur/100))* 			(CASE WHEN "2019-11-26" between conso_taxe.date_debut and conso_taxe.date_fin and "2019-11-26" between conso_taxe.date_debut and conso_taxe.date_fin THEN (DATEDIFF("2019-11-26","2019-11-26")+1)  			WHEN "2019-11-26" between conso_taxe.date_debut and conso_taxe.date_fin and "2019-11-26" > conso_taxe.date_fin THEN (DATEDIFF(conso_taxe.date_fin,"2019-11-26")+1) 			WHEN "2019-11-26" between conso_taxe.date_debut and conso_taxe.date_fin and "2019-11-26" < conso_taxe.date_debut THEN (DATEDIFF("2019-11-26",conso_taxe.date_debut)+1) 			ELSE (DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1) END),2) 		 ELSE 0 END AS fixe_month, 	CASE WHEN conso_taxe.fixe > 0 THEN ROUND(conso_taxe.prix/(DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1)*(1+(conso_tva.valeur/100))*365,2) ELSE 0 END AS fixe_year,  	conso_taxe.id, 	conso_taxe.libelle , 	conso_taxe.prix , 	rec_date AS cat_jours, 	DATE_FORMAT(s.`rec_date`,"%Y") AS annee, 	DATE_FORMAT(s.`rec_date`,"%c") AS mois, 	DATE_FORMAT(s.`rec_date`,"%e") AS jour, 	DATE_FORMAT(s.`rec_date`,"%v") AS semaine, 	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 	FROM  conso_jour s 	LEFT JOIN conso_taxe ON 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 conso_taxe.type_ecq = "electricity" 	LEFT JOIN conso_tva ON conso_taxe.id_tva = conso_tva.id 	WHERE id_eq =63 AND 	(`rec_date` BETWEEN   "2019-11-26" AND "2019-11-26" ) 	GROUP by categorie  ,conso_taxe.id ORDER BY rec_date ASC
[2019-11-27 20:40:55][DEBUG] : GetCalculPrice Requete:  SELECT                             63 as id_equipement,                             id_parent,     					    tva, 						    tva_abo, 						    abonnement, 						    annee, 						    mois, 						    jour, 						    semaine, sum(hp) as hp,sum(hc) as hc ,  sum(total_hp) as total_hp,sum(total_hc) as total_hc , 	prix_hp, 						    prix_hc, 							temp_min, 							temp_max, 							temp_moy, 							dju, 							dju_clim, 							mois, 						     cat_semaine   as categorie  , 						    rec_date FROM ( 						    SELECT 								FORMAT(MIN(temp_min),2) AS temp_min, 								FORMAT(MAX(temp_max),2) AS temp_max, 								FORMAT(AVG(temp_moy),2) AS temp_moy, 								SUM(dju) AS dju, 								SUM(dju_clim) AS dju_clim, 						        "non" as id_parent, 								`timestamp`, 								rec_date, 								rec_date as cat_jours, 								DATE_FORMAT(s.`rec_date`,"%Y") AS annee, 								DATE_FORMAT(s.`rec_date`,"%c") AS mois, 								DATE_FORMAT(s.`rec_date`,"%e") AS jour, 								DATE_FORMAT(s.`rec_date`,"%v") AS semaine, 								IF(DATE_FORMAT(s.`rec_date`,"%c") = 1 AND DATE_FORMAT(s.`rec_date`,"%v") = 52,CONCAT(DATE_FORMAT(s.`rec_date`,"sem %v")," ",DATE_FORMAT(DATE_SUB(s.`rec_date`, INTERVAL 1 YEAR),"%y")) , DATE_FORMAT(s.`rec_date`,"sem %v %y")) AS cat_semaine, /*Ajout du 1er janviers 2017 dans la semaie 52 de 2016*/ 								-- DATE_FORMAT(s.`rec_date`,"sem %v %y") AS cat_semaine, 								DATE_FORMAT(s.`rec_date`,"%b %y") AS cat_month, 								DATE_FORMAT(s.`rec_date`,"%y") AS cat_anne, 								ROUND(SUM(s.hp),2) AS hp, 								ROUND(SUM(s.hc),2) AS hc, 								(SELECT FORMAT(montant,2) AS abo FROM conso_abo aa	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as abonnement, 								(SELECT cst.valeur tva_abo FROM conso_abo aa	INNER JOIN conso_tva cst on cst.id = aa.id_tva	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as tva_abo, 								(SELECT FORMAT(hc,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1) as prix_hc, 								(SELECT FORMAT(hp,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as prix_hp, 							    (SELECT  FORMAT(valeur ,2)  FROM conso_tva where UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d")) limit 0,1) as tva, 							    SUM(ROUND((SELECT FORMAT(hc,4) AS hc FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hc, 2)) AS total_hc, 							    SUM(ROUND((SELECT FORMAT(hp,4) AS hp FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hp, 2)) AS total_hp 								FROM  conso_jour s 								WHERE id_eq = 63 AND  (	`timestamp` BETWEEN   UNIX_TIMESTAMP("2019-11-25") AND UNIX_TIMESTAMP("2019-12-01") or `rec_date` BETWEEN   "2019-11-25" AND "2019-12-01" )  GROUP BY   cat_semaine  ORDER BY rec_date ASC) as req 										GROUP by  req.cat_semaine   ORDER BY req.rec_date ASC	
[2019-11-27 20:40:55][DEBUG] : date_deb:2019-11-25 date_fin:2019-12-01
[2019-11-27 20:40:55][DEBUG] : requete taxe: 	SELECT 	 	DATE_FORMAT(s.`rec_date`,"sem %v %y")    as categorie  , 	conso_taxe.global, 	conso_taxe.inte, 	conso_taxe.fixe, 	ROUND(SUM(s.hp),2) AS hp, 	ROUND(SUM(s.hc),2) AS hc, 	ROUND(SUM(s.hc)+SUM(s.hp),2) AS total, 	rec_date, 	CASE WHEN conso_taxe.inte > 0 THEN ROUND(conso_taxe.prix * round(SUM(CASE WHEN conso_taxe.type_ecq = "water" THEN s.hc/1000 else s.hc END),2) * (1+(conso_tva.valeur/100)),2) ELSE 0 END AS inte_hc, 	CASE WHEN conso_taxe.inte > 0 THEN ROUND(conso_taxe.prix * round(SUM(CASE WHEN conso_taxe.type_ecq = "water" THEN s.hp/1000 else s.hp END),2) * (1+(conso_tva.valeur/100)),2) ELSE 0 END AS inte_hp, 	CASE WHEN conso_taxe.inte > 0 THEN ROUND(conso_taxe.prix * round(SUM(CASE WHEN conso_taxe.type_ecq = "water" THEN (s.hp)/1000 ELSE s.hp+s.hc END),2) * (1+(conso_tva.valeur/100)),2) ELSE 0 END AS total_inte, 	CASE WHEN conso_taxe.global > 0 THEN ROUND((round(SUM(CASE WHEN conso_taxe.type_ecq = "water" THEN (s.hp)/1000 else s.hp+s.hc END ),2)*conso_taxe.prix)*(1+(conso_tva.valeur/100)),2) ELSE 0 END AS multi_ttc, 	CASE WHEN conso_taxe.fixe > 0 THEN ROUND(conso_taxe.prix/(DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1)*(1+(conso_tva.valeur/100)),2) ELSE 0 END AS fixe_day, 	CASE WHEN conso_taxe.fixe > 0 THEN ROUND(conso_taxe.prix/(DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1)*(1+(conso_tva.valeur/100))*7,2) ELSE 0 END AS fixe_week, 	CASE WHEN conso_taxe.fixe > 0 THEN ROUND(conso_taxe.prix/(DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1)*(1+(conso_tva.valeur/100))* 			(CASE WHEN "2019-11-25" between conso_taxe.date_debut and conso_taxe.date_fin and "2019-12-01" between conso_taxe.date_debut and conso_taxe.date_fin THEN (DATEDIFF("2019-12-01","2019-11-25")+1)  			WHEN "2019-11-25" between conso_taxe.date_debut and conso_taxe.date_fin and "2019-12-01" > conso_taxe.date_fin THEN (DATEDIFF(conso_taxe.date_fin,"2019-11-25")+1) 			WHEN "2019-12-01" between conso_taxe.date_debut and conso_taxe.date_fin and "2019-11-25" < conso_taxe.date_debut THEN (DATEDIFF("2019-12-01",conso_taxe.date_debut)+1) 			ELSE (DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1) END),2) 		 ELSE 0 END AS fixe_month, 	CASE WHEN conso_taxe.fixe > 0 THEN ROUND(conso_taxe.prix/(DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1)*(1+(conso_tva.valeur/100))*365,2) ELSE 0 END AS fixe_year,  	conso_taxe.id, 	conso_taxe.libelle , 	conso_taxe.prix , 	rec_date AS cat_jours, 	DATE_FORMAT(s.`rec_date`,"%Y") AS annee, 	DATE_FORMAT(s.`rec_date`,"%c") AS mois, 	DATE_FORMAT(s.`rec_date`,"%e") AS jour, 	DATE_FORMAT(s.`rec_date`,"%v") AS semaine, 	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 	FROM  conso_jour s 	LEFT JOIN conso_taxe ON 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 conso_taxe.type_ecq = "electricity" 	LEFT JOIN conso_tva ON conso_taxe.id_tva = conso_tva.id 	WHERE id_eq =63 AND 	(`rec_date` BETWEEN   "2019-11-25" AND "2019-12-01" ) 	GROUP by categorie  ,conso_taxe.id ORDER BY rec_date ASC
[2019-11-27 20:40:55][DEBUG] : GetCalculPrice Requete:  SELECT                             63 as id_equipement,                             id_parent,     					    tva, 						    tva_abo, 						    abonnement, 						    annee, 						    mois, 						    jour, 						    semaine, sum(hp) as hp,sum(hc) as hc ,  sum(total_hp) as total_hp,sum(total_hc) as total_hc , 	prix_hp, 						    prix_hc, 							temp_min, 							temp_max, 							temp_moy, 							dju, 							dju_clim, 							mois, 						     cat_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, 								DATE_FORMAT(s.`rec_date`,"%v") AS semaine, 								IF(DATE_FORMAT(s.`rec_date`,"%c") = 1 AND DATE_FORMAT(s.`rec_date`,"%v") = 52,CONCAT(DATE_FORMAT(s.`rec_date`,"sem %v")," ",DATE_FORMAT(DATE_SUB(s.`rec_date`, INTERVAL 1 YEAR),"%y")) , DATE_FORMAT(s.`rec_date`,"sem %v %y")) AS cat_semaine, /*Ajout du 1er janviers 2017 dans la semaie 52 de 2016*/ 								-- DATE_FORMAT(s.`rec_date`,"sem %v %y") AS cat_semaine, 								DATE_FORMAT(s.`rec_date`,"%b %y") AS cat_month, 								DATE_FORMAT(s.`rec_date`,"%y") AS cat_anne, 								ROUND(SUM(s.hp),2) AS hp, 								ROUND(SUM(s.hc),2) AS hc, 								(SELECT FORMAT(montant,2) AS abo FROM conso_abo aa	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as abonnement, 								(SELECT cst.valeur tva_abo FROM conso_abo aa	INNER JOIN conso_tva cst on cst.id = aa.id_tva	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as tva_abo, 								(SELECT FORMAT(hc,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1) as prix_hc, 								(SELECT FORMAT(hp,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as prix_hp, 							    (SELECT  FORMAT(valeur ,2)  FROM conso_tva where UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d")) limit 0,1) as tva, 							    SUM(ROUND((SELECT FORMAT(hc,4) AS hc FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hc, 2)) AS total_hc, 							    SUM(ROUND((SELECT FORMAT(hp,4) AS hp FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hp, 2)) AS total_hp 								FROM  conso_jour s 								WHERE id_eq = 63 AND  (	`timestamp` BETWEEN   UNIX_TIMESTAMP("2019-11-01") AND UNIX_TIMESTAMP("2019-11-30") or `rec_date` BETWEEN   "2019-11-01" AND "2019-11-30" )  GROUP BY   cat_month  ORDER BY rec_date ASC) as req 										GROUP by  req.cat_month   ORDER BY req.rec_date ASC	
[2019-11-27 20:40:55][DEBUG] : date_deb:2019-11-01 date_fin:2019-11-30
[2019-11-27 20:40:55][DEBUG] : requete taxe: 	SELECT 	 DATE_FORMAT(s.`rec_date`,"%b %y")   as categorie  , 	conso_taxe.global, 	conso_taxe.inte, 	conso_taxe.fixe, 	ROUND(SUM(s.hp),2) AS hp, 	ROUND(SUM(s.hc),2) AS hc, 	ROUND(SUM(s.hc)+SUM(s.hp),2) AS total, 	rec_date, 	CASE WHEN conso_taxe.inte > 0 THEN ROUND(conso_taxe.prix * round(SUM(CASE WHEN conso_taxe.type_ecq = "water" THEN s.hc/1000 else s.hc END),2) * (1+(conso_tva.valeur/100)),2) ELSE 0 END AS inte_hc, 	CASE WHEN conso_taxe.inte > 0 THEN ROUND(conso_taxe.prix * round(SUM(CASE WHEN conso_taxe.type_ecq = "water" THEN s.hp/1000 else s.hp END),2) * (1+(conso_tva.valeur/100)),2) ELSE 0 END AS inte_hp, 	CASE WHEN conso_taxe.inte > 0 THEN ROUND(conso_taxe.prix * round(SUM(CASE WHEN conso_taxe.type_ecq = "water" THEN (s.hp)/1000 ELSE s.hp+s.hc END),2) * (1+(conso_tva.valeur/100)),2) ELSE 0 END AS total_inte, 	CASE WHEN conso_taxe.global > 0 THEN ROUND((round(SUM(CASE WHEN conso_taxe.type_ecq = "water" THEN (s.hp)/1000 else s.hp+s.hc END ),2)*conso_taxe.prix)*(1+(conso_tva.valeur/100)),2) ELSE 0 END AS multi_ttc, 	CASE WHEN conso_taxe.fixe > 0 THEN ROUND(conso_taxe.prix/(DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1)*(1+(conso_tva.valeur/100)),2) ELSE 0 END AS fixe_day, 	CASE WHEN conso_taxe.fixe > 0 THEN ROUND(conso_taxe.prix/(DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1)*(1+(conso_tva.valeur/100))*7,2) ELSE 0 END AS fixe_week, 	CASE WHEN conso_taxe.fixe > 0 THEN ROUND(conso_taxe.prix/(DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1)*(1+(conso_tva.valeur/100))* 			(CASE WHEN "2019-11-01" between conso_taxe.date_debut and conso_taxe.date_fin and "2019-11-30" between conso_taxe.date_debut and conso_taxe.date_fin THEN (DATEDIFF("2019-11-30","2019-11-01")+1)  			WHEN "2019-11-01" between conso_taxe.date_debut and conso_taxe.date_fin and "2019-11-30" > conso_taxe.date_fin THEN (DATEDIFF(conso_taxe.date_fin,"2019-11-01")+1) 			WHEN "2019-11-30" between conso_taxe.date_debut and conso_taxe.date_fin and "2019-11-01" < conso_taxe.date_debut THEN (DATEDIFF("2019-11-30",conso_taxe.date_debut)+1) 			ELSE (DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1) END),2) 		 ELSE 0 END AS fixe_month, 	CASE WHEN conso_taxe.fixe > 0 THEN ROUND(conso_taxe.prix/(DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1)*(1+(conso_tva.valeur/100))*365,2) ELSE 0 END AS fixe_year,  	conso_taxe.id, 	conso_taxe.libelle , 	conso_taxe.prix , 	rec_date AS cat_jours, 	DATE_FORMAT(s.`rec_date`,"%Y") AS annee, 	DATE_FORMAT(s.`rec_date`,"%c") AS mois, 	DATE_FORMAT(s.`rec_date`,"%e") AS jour, 	DATE_FORMAT(s.`rec_date`,"%v") AS semaine, 	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 	FROM  conso_jour s 	LEFT JOIN conso_taxe ON 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 conso_taxe.type_ecq = "electricity" 	LEFT JOIN conso_tva ON conso_taxe.id_tva = conso_tva.id 	WHERE id_eq =63 AND 	(`rec_date` BETWEEN   "2019-11-01" AND "2019-11-30" ) 	GROUP by categorie  ,conso_taxe.id ORDER BY rec_date ASC
[2019-11-27 20:40:55][DEBUG] : GetCalculPrice Requete:  SELECT                             63 as id_equipement,                             id_parent,     					    tva, 						    tva_abo, 						    abonnement, 						    annee, 						    mois, 						    jour, 						    semaine, sum(hp) as hp,sum(hc) as hc ,  sum(total_hp) as total_hp,sum(total_hc) as total_hc , 	prix_hp, 						    prix_hc, 							temp_min, 							temp_max, 							temp_moy, 							dju, 							dju_clim, 							mois, 						     cat_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, 								DATE_FORMAT(s.`rec_date`,"%v") AS semaine, 								IF(DATE_FORMAT(s.`rec_date`,"%c") = 1 AND DATE_FORMAT(s.`rec_date`,"%v") = 52,CONCAT(DATE_FORMAT(s.`rec_date`,"sem %v")," ",DATE_FORMAT(DATE_SUB(s.`rec_date`, INTERVAL 1 YEAR),"%y")) , DATE_FORMAT(s.`rec_date`,"sem %v %y")) AS cat_semaine, /*Ajout du 1er janviers 2017 dans la semaie 52 de 2016*/ 								-- DATE_FORMAT(s.`rec_date`,"sem %v %y") AS cat_semaine, 								DATE_FORMAT(s.`rec_date`,"%b %y") AS cat_month, 								DATE_FORMAT(s.`rec_date`,"%y") AS cat_anne, 								ROUND(SUM(s.hp),2) AS hp, 								ROUND(SUM(s.hc),2) AS hc, 								(SELECT FORMAT(montant,2) AS abo FROM conso_abo aa	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as abonnement, 								(SELECT cst.valeur tva_abo FROM conso_abo aa	INNER JOIN conso_tva cst on cst.id = aa.id_tva	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as tva_abo, 								(SELECT FORMAT(hc,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1) as prix_hc, 								(SELECT FORMAT(hp,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as prix_hp, 							    (SELECT  FORMAT(valeur ,2)  FROM conso_tva where UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d")) limit 0,1) as tva, 							    SUM(ROUND((SELECT FORMAT(hc,4) AS hc FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hc, 2)) AS total_hc, 							    SUM(ROUND((SELECT FORMAT(hp,4) AS hp FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hp, 2)) AS total_hp 								FROM  conso_jour s 								WHERE id_eq = 63 AND  (	`timestamp` BETWEEN   UNIX_TIMESTAMP("2018-01-01") AND UNIX_TIMESTAMP("2019-1") or `rec_date` BETWEEN   "2018-01-01" AND "2019-1" )  GROUP BY   cat_month  ORDER BY rec_date ASC) as req 										GROUP by  req.cat_month   ORDER BY req.rec_date ASC	
[2019-11-27 20:40:56][DEBUG] : init autre du 2019-11-21 au 2019-11-27
[2019-11-27 20:40:56][DEBUG] : GetCalculPrice Requete:  SELECT                             63 as id_equipement,                             id_parent,     					    tva, 						    tva_abo, 						    abonnement, 						    annee, 						    mois, 						    jour, 						    semaine, sum(hp) as hp,sum(hc) as hc ,  sum(total_hp) as total_hp,sum(total_hc) as total_hc , 	prix_hp, 						    prix_hc, 							temp_min, 							temp_max, 							temp_moy, 							dju, 							dju_clim, 							mois, 						     cat_jours   as categorie  , 						    rec_date FROM ( 						    SELECT 								FORMAT(MIN(temp_min),2) AS temp_min, 								FORMAT(MAX(temp_max),2) AS temp_max, 								FORMAT(AVG(temp_moy),2) AS temp_moy, 								SUM(dju) AS dju, 								SUM(dju_clim) AS dju_clim, 						        "non" as id_parent, 								`timestamp`, 								rec_date, 								rec_date as cat_jours, 								DATE_FORMAT(s.`rec_date`,"%Y") AS annee, 								DATE_FORMAT(s.`rec_date`,"%c") AS mois, 								DATE_FORMAT(s.`rec_date`,"%e") AS jour, 								DATE_FORMAT(s.`rec_date`,"%v") AS semaine, 								IF(DATE_FORMAT(s.`rec_date`,"%c") = 1 AND DATE_FORMAT(s.`rec_date`,"%v") = 52,CONCAT(DATE_FORMAT(s.`rec_date`,"sem %v")," ",DATE_FORMAT(DATE_SUB(s.`rec_date`, INTERVAL 1 YEAR),"%y")) , DATE_FORMAT(s.`rec_date`,"sem %v %y")) AS cat_semaine, /*Ajout du 1er janviers 2017 dans la semaie 52 de 2016*/ 								-- DATE_FORMAT(s.`rec_date`,"sem %v %y") AS cat_semaine, 								DATE_FORMAT(s.`rec_date`,"%b %y") AS cat_month, 								DATE_FORMAT(s.`rec_date`,"%y") AS cat_anne, 								ROUND(SUM(s.hp),2) AS hp, 								ROUND(SUM(s.hc),2) AS hc, 								(SELECT FORMAT(montant,2) AS abo FROM conso_abo aa	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as abonnement, 								(SELECT cst.valeur tva_abo FROM conso_abo aa	INNER JOIN conso_tva cst on cst.id = aa.id_tva	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as tva_abo, 								(SELECT FORMAT(hc,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1) as prix_hc, 								(SELECT FORMAT(hp,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as prix_hp, 							    (SELECT  FORMAT(valeur ,2)  FROM conso_tva where UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d")) limit 0,1) as tva, 							    SUM(ROUND((SELECT FORMAT(hc,4) AS hc FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hc, 2)) AS total_hc, 							    SUM(ROUND((SELECT FORMAT(hp,4) AS hp FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hp, 2)) AS total_hp 								FROM  conso_jour s 								WHERE id_eq = 63 AND  (	`timestamp` BETWEEN   UNIX_TIMESTAMP("2019-11-21") AND UNIX_TIMESTAMP("2019-11-27") or `rec_date` BETWEEN   "2019-11-21" AND "2019-11-27" )  GROUP BY   cat_jours  ORDER BY rec_date ASC) as req 										GROUP by  req.cat_jours   ORDER BY req.rec_date ASC	
[2019-11-27 20:40:56][DEBUG] : GetCalculPrice Requete:  SELECT                             63 as id_equipement,                             id_parent,     					    tva, 						    tva_abo, 						    abonnement, 						    annee, 						    mois, 						    jour, 						    semaine, sum(hp) as hp,sum(hc) as hc ,  sum(total_hp) as total_hp,sum(total_hc) as total_hc , 	prix_hp, 						    prix_hc, 							temp_min, 							temp_max, 							temp_moy, 							dju, 							dju_clim, 							mois, 						     cat_jours   as categorie  , 						    rec_date FROM ( 						    SELECT 								FORMAT(MIN(temp_min),2) AS temp_min, 								FORMAT(MAX(temp_max),2) AS temp_max, 								FORMAT(AVG(temp_moy),2) AS temp_moy, 								SUM(dju) AS dju, 								SUM(dju_clim) AS dju_clim, 						        "non" as id_parent, 								`timestamp`, 								rec_date, 								rec_date as cat_jours, 								DATE_FORMAT(s.`rec_date`,"%Y") AS annee, 								DATE_FORMAT(s.`rec_date`,"%c") AS mois, 								DATE_FORMAT(s.`rec_date`,"%e") AS jour, 								DATE_FORMAT(s.`rec_date`,"%v") AS semaine, 								IF(DATE_FORMAT(s.`rec_date`,"%c") = 1 AND DATE_FORMAT(s.`rec_date`,"%v") = 52,CONCAT(DATE_FORMAT(s.`rec_date`,"sem %v")," ",DATE_FORMAT(DATE_SUB(s.`rec_date`, INTERVAL 1 YEAR),"%y")) , DATE_FORMAT(s.`rec_date`,"sem %v %y")) AS cat_semaine, /*Ajout du 1er janviers 2017 dans la semaie 52 de 2016*/ 								-- DATE_FORMAT(s.`rec_date`,"sem %v %y") AS cat_semaine, 								DATE_FORMAT(s.`rec_date`,"%b %y") AS cat_month, 								DATE_FORMAT(s.`rec_date`,"%y") AS cat_anne, 								ROUND(SUM(s.hp),2) AS hp, 								ROUND(SUM(s.hc),2) AS hc, 								(SELECT FORMAT(montant,2) AS abo FROM conso_abo aa	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as abonnement, 								(SELECT cst.valeur tva_abo FROM conso_abo aa	INNER JOIN conso_tva cst on cst.id = aa.id_tva	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as tva_abo, 								(SELECT FORMAT(hc,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1) as prix_hc, 								(SELECT FORMAT(hp,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as prix_hp, 							    (SELECT  FORMAT(valeur ,2)  FROM conso_tva where UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d")) limit 0,1) as tva, 							    SUM(ROUND((SELECT FORMAT(hc,4) AS hc FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hc, 2)) AS total_hc, 							    SUM(ROUND((SELECT FORMAT(hp,4) AS hp FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hp, 2)) AS total_hp 								FROM  conso_jour s 								WHERE id_eq = 63 AND 	( timestamp BETWEEN UNIX_TIMESTAMP(DATE_SUB("2019-11-21", INTERVAL 1 YEAR)) and UNIX_TIMESTAMP(DATE_SUB("2019-11-27", INTERVAL 1 YEAR))                                     or                                     `rec_date` BETWEEN   DATE_SUB("2019-11-21", INTERVAL 1 YEAR) AND DATE_SUB("2019-11-27", INTERVAL 1 YEAR) ) GROUP BY   cat_jours  ORDER BY rec_date ASC) as req 										GROUP by  req.cat_jours   ORDER BY req.rec_date ASC	
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2019-11-01 au 2019-11-30
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 30 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.09 date debut 2019-11-01 Date fin 2019-11-30
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : datedeb:2019-11-21 mois:11 Taxe fixe:12.63 2019-11-27 2019-11-21 21 7
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:0.37 hp:14.05 hc:10.52 VARIABLE Debut 2019-11-21 Fin 2019-11-27 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:0.64 hp:14.05 hc:10.52 VARIABLE Debut 2019-11-21 Fin 2019-11-27 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2019-11-01 au 2019-11-30
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 30 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.09 date debut 2019-11-01 Date fin 2019-11-30
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : datedeb:2019-11-22 mois:11 Taxe fixe:12.63 2019-11-27 2019-11-21 22 7
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:0.39 hp:13.81 hc:12.47 VARIABLE Debut 2019-11-21 Fin 2019-11-27 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:0.68 hp:13.81 hc:12.47 VARIABLE Debut 2019-11-21 Fin 2019-11-27 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2019-11-01 au 2019-11-30
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 30 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.09 date debut 2019-11-01 Date fin 2019-11-30
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : datedeb:2019-11-23 mois:11 Taxe fixe:12.63 2019-11-27 2019-11-21 23 7
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:0.45 hp:18.18 hc:11.7 VARIABLE Debut 2019-11-21 Fin 2019-11-27 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:0.78 hp:18.18 hc:11.7 VARIABLE Debut 2019-11-21 Fin 2019-11-27 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : init autre du 2018-12-01 au 2019-11-30
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2019-11-01 au 2019-11-30
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 30 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.09 date debut 2019-11-01 Date fin 2019-11-30
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : datedeb:2019-11-24 mois:11 Taxe fixe:12.63 2019-11-27 2019-11-21 24 7
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:0.48 hp:22.24 hc:9.59 VARIABLE Debut 2019-11-21 Fin 2019-11-27 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:0.83 hp:22.24 hc:9.59 VARIABLE Debut 2019-11-21 Fin 2019-11-27 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : GetCalculPrice Requete:  SELECT                             63 as id_equipement,                             id_parent,     					    tva, 						    tva_abo, 						    abonnement, 						    annee, 						    mois, 						    jour, 						    semaine, sum(hp) as hp,sum(hc) as hc ,  sum(total_hp) as total_hp,sum(total_hc) as total_hc , 	prix_hp, 						    prix_hc, 							temp_min, 							temp_max, 							temp_moy, 							dju, 							dju_clim, 							mois, 						     cat_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, 								DATE_FORMAT(s.`rec_date`,"%v") AS semaine, 								IF(DATE_FORMAT(s.`rec_date`,"%c") = 1 AND DATE_FORMAT(s.`rec_date`,"%v") = 52,CONCAT(DATE_FORMAT(s.`rec_date`,"sem %v")," ",DATE_FORMAT(DATE_SUB(s.`rec_date`, INTERVAL 1 YEAR),"%y")) , DATE_FORMAT(s.`rec_date`,"sem %v %y")) AS cat_semaine, /*Ajout du 1er janviers 2017 dans la semaie 52 de 2016*/ 								-- DATE_FORMAT(s.`rec_date`,"sem %v %y") AS cat_semaine, 								DATE_FORMAT(s.`rec_date`,"%b %y") AS cat_month, 								DATE_FORMAT(s.`rec_date`,"%y") AS cat_anne, 								ROUND(SUM(s.hp),2) AS hp, 								ROUND(SUM(s.hc),2) AS hc, 								(SELECT FORMAT(montant,2) AS abo FROM conso_abo aa	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as abonnement, 								(SELECT cst.valeur tva_abo FROM conso_abo aa	INNER JOIN conso_tva cst on cst.id = aa.id_tva	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as tva_abo, 								(SELECT FORMAT(hc,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1) as prix_hc, 								(SELECT FORMAT(hp,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as prix_hp, 							    (SELECT  FORMAT(valeur ,2)  FROM conso_tva where UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d")) limit 0,1) as tva, 							    SUM(ROUND((SELECT FORMAT(hc,4) AS hc FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hc, 2)) AS total_hc, 							    SUM(ROUND((SELECT FORMAT(hp,4) AS hp FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hp, 2)) AS total_hp 								FROM  conso_jour s 								WHERE id_eq = 63 AND  (	`timestamp` BETWEEN   UNIX_TIMESTAMP("2018-12-01") AND UNIX_TIMESTAMP("2019-11-30") or `rec_date` BETWEEN   "2018-12-01" AND "2019-11-30" )  GROUP BY   cat_month  ORDER BY rec_date ASC) as req 										GROUP by  req.cat_month   ORDER BY req.rec_date ASC	
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2019-11-01 au 2019-11-30
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 30 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.09 date debut 2019-11-01 Date fin 2019-11-30
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : datedeb:2019-11-25 mois:11 Taxe fixe:12.63 2019-11-27 2019-11-21 25 7
[2019-11-27 20:40:56][DEBUG] : GetCalculPrice Requete:  SELECT                             63 as id_equipement,                             id_parent,     					    tva, 						    tva_abo, 						    abonnement, 						    annee, 						    mois, 						    jour, 						    semaine, sum(hp) as hp,sum(hc) as hc ,  sum(total_hp) as total_hp,sum(total_hc) as total_hc , 	prix_hp, 						    prix_hc, 							temp_min, 							temp_max, 							temp_moy, 							dju, 							dju_clim, 							mois, 						     cat_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, 								DATE_FORMAT(s.`rec_date`,"%v") AS semaine, 								IF(DATE_FORMAT(s.`rec_date`,"%c") = 1 AND DATE_FORMAT(s.`rec_date`,"%v") = 52,CONCAT(DATE_FORMAT(s.`rec_date`,"sem %v")," ",DATE_FORMAT(DATE_SUB(s.`rec_date`, INTERVAL 1 YEAR),"%y")) , DATE_FORMAT(s.`rec_date`,"sem %v %y")) AS cat_semaine, /*Ajout du 1er janviers 2017 dans la semaie 52 de 2016*/ 								-- DATE_FORMAT(s.`rec_date`,"sem %v %y") AS cat_semaine, 								DATE_FORMAT(s.`rec_date`,"%b %y") AS cat_month, 								DATE_FORMAT(s.`rec_date`,"%y") AS cat_anne, 								ROUND(SUM(s.hp),2) AS hp, 								ROUND(SUM(s.hc),2) AS hc, 								(SELECT FORMAT(montant,2) AS abo FROM conso_abo aa	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as abonnement, 								(SELECT cst.valeur tva_abo FROM conso_abo aa	INNER JOIN conso_tva cst on cst.id = aa.id_tva	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as tva_abo, 								(SELECT FORMAT(hc,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1) as prix_hc, 								(SELECT FORMAT(hp,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as prix_hp, 							    (SELECT  FORMAT(valeur ,2)  FROM conso_tva where UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d")) limit 0,1) as tva, 							    SUM(ROUND((SELECT FORMAT(hc,4) AS hc FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hc, 2)) AS total_hc, 							    SUM(ROUND((SELECT FORMAT(hp,4) AS hp FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hp, 2)) AS total_hp 								FROM  conso_jour s 								WHERE id_eq = 63 AND 	( timestamp BETWEEN UNIX_TIMESTAMP(DATE_SUB("2018-12-01", INTERVAL 1 YEAR)) and UNIX_TIMESTAMP(DATE_SUB("2019-11-30", INTERVAL 1 YEAR))                                     or                                     `rec_date` BETWEEN   DATE_SUB("2018-12-01", INTERVAL 1 YEAR) AND DATE_SUB("2019-11-30", INTERVAL 1 YEAR) ) GROUP BY   cat_month  ORDER BY rec_date ASC) as req 										GROUP by  req.cat_month   ORDER BY req.rec_date ASC	
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:0.33 hp:11.82 hc:10.09 VARIABLE Debut 2019-11-21 Fin 2019-11-27 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:0.57 hp:11.82 hc:10.09 VARIABLE Debut 2019-11-21 Fin 2019-11-27 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2018-12-01 au 2018-12-31
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2019-11-01 au 2019-11-30
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 31 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.1 date debut 2018-12-01 Date fin 2018-12-31
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 30 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.09 date debut 2019-11-01 Date fin 2019-11-30
[2019-11-27 20:40:56][DEBUG] : datedeb:2018-12-01 mois:12 Taxe fixe:11.84 2019-11-30 2018-12-01 1 365
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : datedeb:2019-11-26 mois:11 Taxe fixe:12.63 2019-11-27 2019-11-21 26 7
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:17.84 hp:683.34 hc:509.78 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:0.35 hp:13.15 hc:10.11 VARIABLE Debut 2019-11-21 Fin 2019-11-27 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:31.04 hp:683.34 hc:509.78 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:0.61 hp:13.15 hc:10.11 VARIABLE Debut 2019-11-21 Fin 2019-11-27 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2019-01-01 au 2019-01-31
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2019-11-01 au 2019-11-30
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 31 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.1 date debut 2019-01-01 Date fin 2019-01-31
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 30 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.09 date debut 2019-11-01 Date fin 2019-11-30
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : datedeb:2019-01-01 mois:1 Taxe fixe:11.84 2019-11-30 2018-12-01 1 365
[2019-11-27 20:40:56][DEBUG] : datedeb:2019-11-27 mois:11 Taxe fixe:12.63 2019-11-27 2019-11-21 27 7
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:0.19 hp:3.47 hc:8.91 VARIABLE Debut 2019-11-21 Fin 2019-11-27 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:20.57 hp:761.62 hc:614.4 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:0.33 hp:3.47 hc:8.91 VARIABLE Debut 2019-11-21 Fin 2019-11-27 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:35.79 hp:761.62 hc:614.4 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2019-02-01 au 2019-02-28
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 28 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.09 date debut 2019-02-01 Date fin 2019-02-28
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : datedeb:2019-02-01 mois:2 Taxe fixe:12.63 2019-11-30 2018-12-01 1 365
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:15.55 hp:549.97 hc:490.36 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:27.06 hp:549.97 hc:490.36 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2019-03-01 au 2019-03-31
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 31 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.1 date debut 2019-03-01 Date fin 2019-03-31
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : datedeb:2019-03-01 mois:3 Taxe fixe:12.64 2019-11-30 2018-12-01 1 365
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:11.91 hp:427.88 hc:368.46 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:20.72 hp:427.88 hc:368.46 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2019-04-01 au 2019-04-30
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 30 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.09 date debut 2019-04-01 Date fin 2019-04-30
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : datedeb:2019-04-01 mois:4 Taxe fixe:12.63 2019-11-30 2018-12-01 1 365
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:9.34 hp:338.1 hc:286.54 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:16.25 hp:338.1 hc:286.54 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2019-05-01 au 2019-05-31
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 31 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.1 date debut 2019-05-01 Date fin 2019-05-31
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : datedeb:2019-05-01 mois:5 Taxe fixe:12.64 2019-11-30 2018-12-01 1 365
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:6.53 hp:185.14 hc:251.5 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:11.36 hp:185.14 hc:251.5 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2019-06-01 au 2019-06-30
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 30 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.09 date debut 2019-06-01 Date fin 2019-06-30
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : datedeb:2019-06-01 mois:6 Taxe fixe:12.63 2019-11-30 2018-12-01 1 365
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:5.48 hp:186.33 hc:180.44 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:9.54 hp:186.33 hc:180.44 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2019-07-01 au 2019-07-31
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 31 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.1 date debut 2019-07-01 Date fin 2019-07-31
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : datedeb:2019-07-01 mois:7 Taxe fixe:12.64 2019-11-30 2018-12-01 1 365
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:6.41 hp:247.48 hc:181.28 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:11.15 hp:247.48 hc:181.28 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2019-08-01 au 2019-08-31
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 31 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.1 date debut 2019-08-01 Date fin 2019-08-31
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : datedeb:2019-08-01 mois:8 Taxe fixe:12.64 2019-11-30 2018-12-01 1 365
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:5.73 hp:221.85 hc:161.72 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:9.97 hp:221.85 hc:161.72 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2019-09-01 au 2019-09-30
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 30 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.09 date debut 2019-09-01 Date fin 2019-09-30
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : datedeb:2019-09-01 mois:9 Taxe fixe:12.63 2019-11-30 2018-12-01 1 365
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:5.5 hp:199.96 hc:168.11 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:9.57 hp:199.96 hc:168.11 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2019-10-01 au 2019-10-31
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 31 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.1 date debut 2019-10-01 Date fin 2019-10-31
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : datedeb:2019-10-01 mois:10 Taxe fixe:12.64 2019-11-30 2018-12-01 1 365
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:5.41 hp:181.33 hc:180.55 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:9.41 hp:181.33 hc:180.55 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2019-11-01 au 2019-11-30
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 30 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.09 date debut 2019-11-01 Date fin 2019-11-30
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : datedeb:2019-11-19 mois:11 Taxe fixe:12.63 2019-11-30 2018-12-01 19 365
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:8.69 hp:338.14 hc:243.37 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:15.12 hp:338.14 hc:243.37 VARIABLE Debut 2018-12-01 Fin 2019-11-30 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : init autre du 2019-11-04 au 2019-12-01
[2019-11-27 20:40:56][DEBUG] : GetCalculPrice Requete:  SELECT                             63 as id_equipement,                             id_parent,     					    tva, 						    tva_abo, 						    abonnement, 						    annee, 						    mois, 						    jour, 						    semaine, sum(hp) as hp,sum(hc) as hc ,  sum(total_hp) as total_hp,sum(total_hc) as total_hc , 	prix_hp, 						    prix_hc, 							temp_min, 							temp_max, 							temp_moy, 							dju, 							dju_clim, 							mois, 						     cat_semaine   as categorie  , 						    rec_date FROM ( 						    SELECT 								FORMAT(MIN(temp_min),2) AS temp_min, 								FORMAT(MAX(temp_max),2) AS temp_max, 								FORMAT(AVG(temp_moy),2) AS temp_moy, 								SUM(dju) AS dju, 								SUM(dju_clim) AS dju_clim, 						        "non" as id_parent, 								`timestamp`, 								rec_date, 								rec_date as cat_jours, 								DATE_FORMAT(s.`rec_date`,"%Y") AS annee, 								DATE_FORMAT(s.`rec_date`,"%c") AS mois, 								DATE_FORMAT(s.`rec_date`,"%e") AS jour, 								DATE_FORMAT(s.`rec_date`,"%v") AS semaine, 								IF(DATE_FORMAT(s.`rec_date`,"%c") = 1 AND DATE_FORMAT(s.`rec_date`,"%v") = 52,CONCAT(DATE_FORMAT(s.`rec_date`,"sem %v")," ",DATE_FORMAT(DATE_SUB(s.`rec_date`, INTERVAL 1 YEAR),"%y")) , DATE_FORMAT(s.`rec_date`,"sem %v %y")) AS cat_semaine, /*Ajout du 1er janviers 2017 dans la semaie 52 de 2016*/ 								-- DATE_FORMAT(s.`rec_date`,"sem %v %y") AS cat_semaine, 								DATE_FORMAT(s.`rec_date`,"%b %y") AS cat_month, 								DATE_FORMAT(s.`rec_date`,"%y") AS cat_anne, 								ROUND(SUM(s.hp),2) AS hp, 								ROUND(SUM(s.hc),2) AS hc, 								(SELECT FORMAT(montant,2) AS abo FROM conso_abo aa	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as abonnement, 								(SELECT cst.valeur tva_abo FROM conso_abo aa	INNER JOIN conso_tva cst on cst.id = aa.id_tva	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as tva_abo, 								(SELECT FORMAT(hc,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1) as prix_hc, 								(SELECT FORMAT(hp,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as prix_hp, 							    (SELECT  FORMAT(valeur ,2)  FROM conso_tva where UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d")) limit 0,1) as tva, 							    SUM(ROUND((SELECT FORMAT(hc,4) AS hc FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hc, 2)) AS total_hc, 							    SUM(ROUND((SELECT FORMAT(hp,4) AS hp FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hp, 2)) AS total_hp 								FROM  conso_jour s 								WHERE id_eq = 63 AND  (	`timestamp` BETWEEN   UNIX_TIMESTAMP("2019-11-04") AND UNIX_TIMESTAMP("2019-12-01") or `rec_date` BETWEEN   "2019-11-04" AND "2019-12-01" )  GROUP BY   cat_semaine  ORDER BY rec_date ASC) as req 										GROUP by  req.cat_semaine   ORDER BY req.rec_date ASC	
[2019-11-27 20:40:56][DEBUG] : GetCalculPrice Requete:  SELECT                             63 as id_equipement,                             id_parent,     					    tva, 						    tva_abo, 						    abonnement, 						    annee, 						    mois, 						    jour, 						    semaine, sum(hp) as hp,sum(hc) as hc ,  sum(total_hp) as total_hp,sum(total_hc) as total_hc , 	prix_hp, 						    prix_hc, 							temp_min, 							temp_max, 							temp_moy, 							dju, 							dju_clim, 							mois, 						     cat_semaine   as categorie  , 						    rec_date FROM ( 						    SELECT 								FORMAT(MIN(temp_min),2) AS temp_min, 								FORMAT(MAX(temp_max),2) AS temp_max, 								FORMAT(AVG(temp_moy),2) AS temp_moy, 								SUM(dju) AS dju, 								SUM(dju_clim) AS dju_clim, 						        "non" as id_parent, 								`timestamp`, 								rec_date, 								rec_date as cat_jours, 								DATE_FORMAT(s.`rec_date`,"%Y") AS annee, 								DATE_FORMAT(s.`rec_date`,"%c") AS mois, 								DATE_FORMAT(s.`rec_date`,"%e") AS jour, 								DATE_FORMAT(s.`rec_date`,"%v") AS semaine, 								IF(DATE_FORMAT(s.`rec_date`,"%c") = 1 AND DATE_FORMAT(s.`rec_date`,"%v") = 52,CONCAT(DATE_FORMAT(s.`rec_date`,"sem %v")," ",DATE_FORMAT(DATE_SUB(s.`rec_date`, INTERVAL 1 YEAR),"%y")) , DATE_FORMAT(s.`rec_date`,"sem %v %y")) AS cat_semaine, /*Ajout du 1er janviers 2017 dans la semaie 52 de 2016*/ 								-- DATE_FORMAT(s.`rec_date`,"sem %v %y") AS cat_semaine, 								DATE_FORMAT(s.`rec_date`,"%b %y") AS cat_month, 								DATE_FORMAT(s.`rec_date`,"%y") AS cat_anne, 								ROUND(SUM(s.hp),2) AS hp, 								ROUND(SUM(s.hc),2) AS hc, 								(SELECT FORMAT(montant,2) AS abo FROM conso_abo aa	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as abonnement, 								(SELECT cst.valeur tva_abo FROM conso_abo aa	INNER JOIN conso_tva cst on cst.id = aa.id_tva	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as tva_abo, 								(SELECT FORMAT(hc,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1) as prix_hc, 								(SELECT FORMAT(hp,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as prix_hp, 							    (SELECT  FORMAT(valeur ,2)  FROM conso_tva where UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d")) limit 0,1) as tva, 							    SUM(ROUND((SELECT FORMAT(hc,4) AS hc FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hc, 2)) AS total_hc, 							    SUM(ROUND((SELECT FORMAT(hp,4) AS hp FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hp, 2)) AS total_hp 								FROM  conso_jour s 								WHERE id_eq = 63 AND 	( timestamp BETWEEN UNIX_TIMESTAMP(DATE_SUB("2019-11-04", INTERVAL 1 YEAR)) and UNIX_TIMESTAMP(DATE_SUB("2019-12-01", INTERVAL 1 YEAR))                                     or                                     `rec_date` BETWEEN   DATE_SUB("2019-11-04", INTERVAL 1 YEAR) AND DATE_SUB("2019-12-01", INTERVAL 1 YEAR) ) GROUP BY   cat_semaine  ORDER BY rec_date ASC) as req 										GROUP by  req.cat_semaine   ORDER BY req.rec_date ASC	
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2019-11-01 au 2019-11-30
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 30 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.09 date debut 2019-11-01 Date fin 2019-11-30
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : datedeb:2019-11-04 mois:11 Taxe fixe:12.63 2019-12-01 2019-11-04 4 28
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:1.8 hp:71.15 hc:49.47 VARIABLE Debut 2019-11-04 Fin 2019-12-01 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:3.13 hp:71.15 hc:49.47 VARIABLE Debut 2019-11-04 Fin 2019-12-01 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2019-11-01 au 2019-11-30
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 30 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.09 date debut 2019-11-01 Date fin 2019-11-30
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : datedeb:2019-11-11 mois:11 Taxe fixe:12.63 2019-12-01 2019-11-04 11 28
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:2.64 hp:103.99 hc:72.33 VARIABLE Debut 2019-11-04 Fin 2019-12-01 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:4.59 hp:103.99 hc:72.33 VARIABLE Debut 2019-11-04 Fin 2019-12-01 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2019-11-01 au 2019-11-30
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 30 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.09 date debut 2019-11-01 Date fin 2019-11-30
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : datedeb:2019-11-19 mois:11 Taxe fixe:12.63 2019-12-01 2019-11-04 19 28
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:2.77 hp:110.21 hc:75.18 VARIABLE Debut 2019-11-04 Fin 2019-12-01 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:4.82 hp:110.21 hc:75.18 VARIABLE Debut 2019-11-04 Fin 2019-12-01 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : Début recherche taxes période mois:2019-11-01 au 2019-11-30
[2019-11-27 20:40:56][DEBUG] : cas 0 Taxe nbjour mois: 30 nbjourTaxe:5479
[2019-11-27 20:40:56][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.09 date debut 2019-11-01 Date fin 2019-11-30
[2019-11-27 20:40:56][DEBUG] : Recherche FIN
[2019-11-27 20:40:56][DEBUG] : datedeb:2019-11-25 mois:11 Taxe fixe:12.63 2019-12-01 2019-11-04 25 28
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:0.86 hp:28.44 hc:29.12 VARIABLE Debut 2019-11-04 Fin 2019-12-01 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:56][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:1.5 hp:28.44 hc:29.12 VARIABLE Debut 2019-11-04 Fin 2019-12-01 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:58][DEBUG] : init autre du 2019-01-01 au 2019-10-31
[2019-11-27 20:40:58][DEBUG] : GetCalculPrice Requete:  SELECT                             63 as id_equipement,                             id_parent,     					    tva, 						    tva_abo, 						    abonnement, 						    annee, 						    mois, 						    jour, 						    semaine, sum(hp) as hp,sum(hc) as hc ,  sum(total_hp) as total_hp,sum(total_hc) as total_hc , 	prix_hp, 						    prix_hc, 							temp_min, 							temp_max, 							temp_moy, 							dju, 							dju_clim, 							mois, 						     cat_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, 								DATE_FORMAT(s.`rec_date`,"%v") AS semaine, 								IF(DATE_FORMAT(s.`rec_date`,"%c") = 1 AND DATE_FORMAT(s.`rec_date`,"%v") = 52,CONCAT(DATE_FORMAT(s.`rec_date`,"sem %v")," ",DATE_FORMAT(DATE_SUB(s.`rec_date`, INTERVAL 1 YEAR),"%y")) , DATE_FORMAT(s.`rec_date`,"sem %v %y")) AS cat_semaine, /*Ajout du 1er janviers 2017 dans la semaie 52 de 2016*/ 								-- DATE_FORMAT(s.`rec_date`,"sem %v %y") AS cat_semaine, 								DATE_FORMAT(s.`rec_date`,"%b %y") AS cat_month, 								DATE_FORMAT(s.`rec_date`,"%y") AS cat_anne, 								ROUND(SUM(s.hp),2) AS hp, 								ROUND(SUM(s.hc),2) AS hc, 								(SELECT FORMAT(montant,2) AS abo FROM conso_abo aa	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as abonnement, 								(SELECT cst.valeur tva_abo FROM conso_abo aa	INNER JOIN conso_tva cst on cst.id = aa.id_tva	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as tva_abo, 								(SELECT FORMAT(hc,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1) as prix_hc, 								(SELECT FORMAT(hp,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as prix_hp, 							    (SELECT  FORMAT(valeur ,2)  FROM conso_tva where UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d")) limit 0,1) as tva, 							    SUM(ROUND((SELECT FORMAT(hc,4) AS hc FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hc, 2)) AS total_hc, 							    SUM(ROUND((SELECT FORMAT(hp,4) AS hp FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hp, 2)) AS total_hp 								FROM  conso_jour s 								WHERE id_eq = 63 AND  (	`timestamp` BETWEEN   UNIX_TIMESTAMP("2019-01-01") AND UNIX_TIMESTAMP("2019-10-31") or `rec_date` BETWEEN   "2019-01-01" AND "2019-10-31" )  GROUP BY   cat_month  ORDER BY rec_date ASC) as req 										GROUP by  req.cat_month   ORDER BY req.rec_date ASC	
[2019-11-27 20:40:58][DEBUG] : GetCalculPrice Requete:  SELECT                             63 as id_equipement,                             id_parent,     					    tva, 						    tva_abo, 						    abonnement, 						    annee, 						    mois, 						    jour, 						    semaine, sum(hp) as hp,sum(hc) as hc ,  sum(total_hp) as total_hp,sum(total_hc) as total_hc , 	prix_hp, 						    prix_hc, 							temp_min, 							temp_max, 							temp_moy, 							dju, 							dju_clim, 							mois, 						     cat_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, 								DATE_FORMAT(s.`rec_date`,"%v") AS semaine, 								IF(DATE_FORMAT(s.`rec_date`,"%c") = 1 AND DATE_FORMAT(s.`rec_date`,"%v") = 52,CONCAT(DATE_FORMAT(s.`rec_date`,"sem %v")," ",DATE_FORMAT(DATE_SUB(s.`rec_date`, INTERVAL 1 YEAR),"%y")) , DATE_FORMAT(s.`rec_date`,"sem %v %y")) AS cat_semaine, /*Ajout du 1er janviers 2017 dans la semaie 52 de 2016*/ 								-- DATE_FORMAT(s.`rec_date`,"sem %v %y") AS cat_semaine, 								DATE_FORMAT(s.`rec_date`,"%b %y") AS cat_month, 								DATE_FORMAT(s.`rec_date`,"%y") AS cat_anne, 								ROUND(SUM(s.hp),2) AS hp, 								ROUND(SUM(s.hc),2) AS hc, 								(SELECT FORMAT(montant,2) AS abo FROM conso_abo aa	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as abonnement, 								(SELECT cst.valeur tva_abo FROM conso_abo aa	INNER JOIN conso_tva cst on cst.id = aa.id_tva	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as tva_abo, 								(SELECT FORMAT(hc,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1) as prix_hc, 								(SELECT FORMAT(hp,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as prix_hp, 							    (SELECT  FORMAT(valeur ,2)  FROM conso_tva where UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d")) limit 0,1) as tva, 							    SUM(ROUND((SELECT FORMAT(hc,4) AS hc FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hc, 2)) AS total_hc, 							    SUM(ROUND((SELECT FORMAT(hp,4) AS hp FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hp, 2)) AS total_hp 								FROM  conso_jour s 								WHERE id_eq = 63 AND 	( timestamp BETWEEN UNIX_TIMESTAMP(DATE_SUB("2019-01-01", INTERVAL 1 YEAR)) and UNIX_TIMESTAMP(DATE_SUB("2019-10-31", INTERVAL 1 YEAR))                                     or                                     `rec_date` BETWEEN   DATE_SUB("2019-01-01", INTERVAL 1 YEAR) AND DATE_SUB("2019-10-31", INTERVAL 1 YEAR) ) GROUP BY   cat_month  ORDER BY rec_date ASC) as req 										GROUP by  req.cat_month   ORDER BY req.rec_date ASC	
[2019-11-27 20:40:58][DEBUG] : GetCalculPrice Requete:  SELECT                             63 as id_equipement,                             id_parent,     					    tva, 						    tva_abo, 						    abonnement, 						    annee, 						    mois, 						    jour, 						    semaine, sum(hp) as hp,sum(hc) as hc ,  sum(total_hp) as total_hp,sum(total_hc) as total_hc , 	prix_hp, 						    prix_hc, 							temp_min, 							temp_max, 							temp_moy, 							dju, 							dju_clim, 							mois, 						     cat_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, 								DATE_FORMAT(s.`rec_date`,"%v") AS semaine, 								IF(DATE_FORMAT(s.`rec_date`,"%c") = 1 AND DATE_FORMAT(s.`rec_date`,"%v") = 52,CONCAT(DATE_FORMAT(s.`rec_date`,"sem %v")," ",DATE_FORMAT(DATE_SUB(s.`rec_date`, INTERVAL 1 YEAR),"%y")) , DATE_FORMAT(s.`rec_date`,"sem %v %y")) AS cat_semaine, /*Ajout du 1er janviers 2017 dans la semaie 52 de 2016*/ 								-- DATE_FORMAT(s.`rec_date`,"sem %v %y") AS cat_semaine, 								DATE_FORMAT(s.`rec_date`,"%b %y") AS cat_month, 								DATE_FORMAT(s.`rec_date`,"%y") AS cat_anne, 								ROUND(SUM(s.hp),2) AS hp, 								ROUND(SUM(s.hc),2) AS hc, 								(SELECT FORMAT(montant,2) AS abo FROM conso_abo aa	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as abonnement, 								(SELECT cst.valeur tva_abo FROM conso_abo aa	INNER JOIN conso_tva cst on cst.id = aa.id_tva	where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( aa.date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( aa.date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as tva_abo, 								(SELECT FORMAT(hc,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1) as prix_hc, 								(SELECT FORMAT(hp,4) AS hc FROM conso_price  where type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d" ) ) limit 0,1 ) as prix_hp, 							    (SELECT  FORMAT(valeur ,2)  FROM conso_tva where UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP( DATE_FORMAT( date_debut,  "%Y-%m-%d" ) ) AND UNIX_TIMESTAMP( DATE_FORMAT( date_fin,  "%Y-%m-%d")) limit 0,1) as tva, 							    SUM(ROUND((SELECT FORMAT(hc,4) AS hc FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hc, 2)) AS total_hc, 							    SUM(ROUND((SELECT FORMAT(hp,4) AS hp FROM conso_price WHERE  type_ecq like "electricity" AND UNIX_TIMESTAMP(DATE_FORMAT(rec_date , "%Y-%m-%d")) BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(date_debut, "%Y-%m-%d")) AND UNIX_TIMESTAMP(DATE_FORMAT(date_fin, "%Y-%m-%d")) limit 0,1 ) * s.hp, 2)) AS total_hp 								FROM  conso_jour s 								WHERE id_eq = 63 AND  (	`timestamp` BETWEEN   UNIX_TIMESTAMP("2018-11-01") AND UNIX_TIMESTAMP("2018-11-30") or `rec_date` BETWEEN   "2018-11-01" AND "2018-11-30" )  GROUP BY   cat_month  ORDER BY rec_date ASC) as req 										GROUP by  req.cat_month   ORDER BY req.rec_date ASC	
[2019-11-27 20:40:58][DEBUG] : date_deb:2017-11-01 date_fin:2017-11-30
[2019-11-27 20:40:58][DEBUG] : requete taxe: 	SELECT 	 DATE_FORMAT(s.`rec_date`,"%b %y")   as categorie  , 	conso_taxe.global, 	conso_taxe.inte, 	conso_taxe.fixe, 	ROUND(SUM(s.hp),2) AS hp, 	ROUND(SUM(s.hc),2) AS hc, 	ROUND(SUM(s.hc)+SUM(s.hp),2) AS total, 	rec_date, 	CASE WHEN conso_taxe.inte > 0 THEN ROUND(conso_taxe.prix * round(SUM(CASE WHEN conso_taxe.type_ecq = "water" THEN s.hc/1000 else s.hc END),2) * (1+(conso_tva.valeur/100)),2) ELSE 0 END AS inte_hc, 	CASE WHEN conso_taxe.inte > 0 THEN ROUND(conso_taxe.prix * round(SUM(CASE WHEN conso_taxe.type_ecq = "water" THEN s.hp/1000 else s.hp END),2) * (1+(conso_tva.valeur/100)),2) ELSE 0 END AS inte_hp, 	CASE WHEN conso_taxe.inte > 0 THEN ROUND(conso_taxe.prix * round(SUM(CASE WHEN conso_taxe.type_ecq = "water" THEN (s.hp)/1000 ELSE s.hp+s.hc END),2) * (1+(conso_tva.valeur/100)),2) ELSE 0 END AS total_inte, 	CASE WHEN conso_taxe.global > 0 THEN ROUND((round(SUM(CASE WHEN conso_taxe.type_ecq = "water" THEN (s.hp)/1000 else s.hp+s.hc END ),2)*conso_taxe.prix)*(1+(conso_tva.valeur/100)),2) ELSE 0 END AS multi_ttc, 	CASE WHEN conso_taxe.fixe > 0 THEN ROUND(conso_taxe.prix/(DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1)*(1+(conso_tva.valeur/100)),2) ELSE 0 END AS fixe_day, 	CASE WHEN conso_taxe.fixe > 0 THEN ROUND(conso_taxe.prix/(DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1)*(1+(conso_tva.valeur/100))*7,2) ELSE 0 END AS fixe_week, 	CASE WHEN conso_taxe.fixe > 0 THEN ROUND(conso_taxe.prix/(DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1)*(1+(conso_tva.valeur/100))* 			(CASE WHEN "2017-11-01" between conso_taxe.date_debut and conso_taxe.date_fin and "2017-11-30" between conso_taxe.date_debut and conso_taxe.date_fin THEN (DATEDIFF("2017-11-30","2017-11-01")+1)  			WHEN "2017-11-01" between conso_taxe.date_debut and conso_taxe.date_fin and "2017-11-30" > conso_taxe.date_fin THEN (DATEDIFF(conso_taxe.date_fin,"2017-11-01")+1) 			WHEN "2017-11-30" between conso_taxe.date_debut and conso_taxe.date_fin and "2017-11-01" < conso_taxe.date_debut THEN (DATEDIFF("2017-11-30",conso_taxe.date_debut)+1) 			ELSE (DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1) END),2) 		 ELSE 0 END AS fixe_month, 	CASE WHEN conso_taxe.fixe > 0 THEN ROUND(conso_taxe.prix/(DATEDIFF(conso_taxe.date_fin,conso_taxe.date_debut)+1)*(1+(conso_tva.valeur/100))*365,2) ELSE 0 END AS fixe_year,  	conso_taxe.id, 	conso_taxe.libelle , 	conso_taxe.prix , 	rec_date AS cat_jours, 	DATE_FORMAT(s.`rec_date`,"%Y") AS annee, 	DATE_FORMAT(s.`rec_date`,"%c") AS mois, 	DATE_FORMAT(s.`rec_date`,"%e") AS jour, 	DATE_FORMAT(s.`rec_date`,"%v") AS semaine, 	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 	FROM  conso_jour s 	LEFT JOIN conso_taxe ON 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 conso_taxe.type_ecq = "electricity" 	LEFT JOIN conso_tva ON conso_taxe.id_tva = conso_tva.id 	WHERE id_eq =63 AND 	(`rec_date` BETWEEN   "2017-11-01" AND "2017-11-30" ) 	GROUP by categorie  ,conso_taxe.id ORDER BY rec_date ASC
[2019-11-27 20:40:58][DEBUG] : Début recherche taxes période mois:2019-01-01 au 2019-01-31
[2019-11-27 20:40:58][DEBUG] : cas 0 Taxe nbjour mois: 31 nbjourTaxe:5479
[2019-11-27 20:40:58][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.1 date debut 2019-01-01 Date fin 2019-01-31
[2019-11-27 20:40:58][DEBUG] : Recherche FIN
[2019-11-27 20:40:58][DEBUG] : datedeb:2019-01-01 mois:1 Taxe fixe:11.84 2019-10-31 2019-01-01 1 304
[2019-11-27 20:40:58][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:20.57 hp:761.62 hc:614.4 VARIABLE Debut 2019-01-01 Fin 2019-10-31 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:58][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:35.79 hp:761.62 hc:614.4 VARIABLE Debut 2019-01-01 Fin 2019-10-31 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:58][DEBUG] : Début recherche taxes période mois:2019-02-01 au 2019-02-28
[2019-11-27 20:40:58][DEBUG] : cas 0 Taxe nbjour mois: 28 nbjourTaxe:5479
[2019-11-27 20:40:58][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.09 date debut 2019-02-01 Date fin 2019-02-28
[2019-11-27 20:40:58][DEBUG] : Recherche FIN
[2019-11-27 20:40:58][DEBUG] : datedeb:2019-02-01 mois:2 Taxe fixe:12.63 2019-10-31 2019-01-01 1 304
[2019-11-27 20:40:58][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:15.55 hp:549.97 hc:490.36 VARIABLE Debut 2019-01-01 Fin 2019-10-31 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:58][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:27.06 hp:549.97 hc:490.36 VARIABLE Debut 2019-01-01 Fin 2019-10-31 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:58][DEBUG] : Début recherche taxes période mois:2019-03-01 au 2019-03-31
[2019-11-27 20:40:58][DEBUG] : cas 0 Taxe nbjour mois: 31 nbjourTaxe:5479
[2019-11-27 20:40:58][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.1 date debut 2019-03-01 Date fin 2019-03-31
[2019-11-27 20:40:58][DEBUG] : Recherche FIN
[2019-11-27 20:40:58][DEBUG] : datedeb:2019-03-01 mois:3 Taxe fixe:12.64 2019-10-31 2019-01-01 1 304
[2019-11-27 20:40:58][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:11.91 hp:427.88 hc:368.46 VARIABLE Debut 2019-01-01 Fin 2019-10-31 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:58][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:20.72 hp:427.88 hc:368.46 VARIABLE Debut 2019-01-01 Fin 2019-10-31 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:58][DEBUG] : Début recherche taxes période mois:2019-04-01 au 2019-04-30
[2019-11-27 20:40:58][DEBUG] : cas 0 Taxe nbjour mois: 30 nbjourTaxe:5479
[2019-11-27 20:40:58][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.09 date debut 2019-04-01 Date fin 2019-04-30
[2019-11-27 20:40:58][DEBUG] : Recherche FIN
[2019-11-27 20:40:58][DEBUG] : datedeb:2019-04-01 mois:4 Taxe fixe:12.63 2019-10-31 2019-01-01 1 304
[2019-11-27 20:40:58][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:9.34 hp:338.1 hc:286.54 VARIABLE Debut 2019-01-01 Fin 2019-10-31 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:58][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:16.25 hp:338.1 hc:286.54 VARIABLE Debut 2019-01-01 Fin 2019-10-31 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:58][DEBUG] : Début recherche taxes période mois:2019-05-01 au 2019-05-31
[2019-11-27 20:40:58][DEBUG] : cas 0 Taxe nbjour mois: 31 nbjourTaxe:5479
[2019-11-27 20:40:58][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.1 date debut 2019-05-01 Date fin 2019-05-31
[2019-11-27 20:40:58][DEBUG] : Recherche FIN
[2019-11-27 20:40:58][DEBUG] : datedeb:2019-05-01 mois:5 Taxe fixe:12.64 2019-10-31 2019-01-01 1 304
[2019-11-27 20:40:58][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:6.53 hp:185.14 hc:251.5 VARIABLE Debut 2019-01-01 Fin 2019-10-31 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:58][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:11.36 hp:185.14 hc:251.5 VARIABLE Debut 2019-01-01 Fin 2019-10-31 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:58][DEBUG] : Début recherche taxes période mois:2019-06-01 au 2019-06-30
[2019-11-27 20:40:58][DEBUG] : cas 0 Taxe nbjour mois: 30 nbjourTaxe:5479
[2019-11-27 20:40:58][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.09 date debut 2019-06-01 Date fin 2019-06-30
[2019-11-27 20:40:58][DEBUG] : Recherche FIN
[2019-11-27 20:40:58][DEBUG] : datedeb:2019-06-01 mois:6 Taxe fixe:12.63 2019-10-31 2019-01-01 1 304
[2019-11-27 20:40:58][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:5.48 hp:186.33 hc:180.44 VARIABLE Debut 2019-01-01 Fin 2019-10-31 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:58][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:9.54 hp:186.33 hc:180.44 VARIABLE Debut 2019-01-01 Fin 2019-10-31 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:58][DEBUG] : Début recherche taxes période mois:2019-07-01 au 2019-07-31
[2019-11-27 20:40:58][DEBUG] : cas 0 Taxe nbjour mois: 31 nbjourTaxe:5479
[2019-11-27 20:40:58][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.1 date debut 2019-07-01 Date fin 2019-07-31
[2019-11-27 20:40:58][DEBUG] : Recherche FIN
[2019-11-27 20:40:58][DEBUG] : datedeb:2019-07-01 mois:7 Taxe fixe:12.64 2019-10-31 2019-01-01 1 304
[2019-11-27 20:40:58][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:6.41 hp:247.48 hc:181.28 VARIABLE Debut 2019-01-01 Fin 2019-10-31 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:58][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:11.15 hp:247.48 hc:181.28 VARIABLE Debut 2019-01-01 Fin 2019-10-31 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:58][DEBUG] : Début recherche taxes période mois:2019-08-01 au 2019-08-31
[2019-11-27 20:40:58][DEBUG] : cas 0 Taxe nbjour mois: 31 nbjourTaxe:5479
[2019-11-27 20:40:58][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.1 date debut 2019-08-01 Date fin 2019-08-31
[2019-11-27 20:40:58][DEBUG] : Recherche FIN
[2019-11-27 20:40:58][DEBUG] : datedeb:2019-08-01 mois:8 Taxe fixe:12.64 2019-10-31 2019-01-01 1 304
[2019-11-27 20:40:58][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:5.73 hp:221.85 hc:161.72 VARIABLE Debut 2019-01-01 Fin 2019-10-31 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:58][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:9.97 hp:221.85 hc:161.72 VARIABLE Debut 2019-01-01 Fin 2019-10-31 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:58][DEBUG] : Début recherche taxes période mois:2019-09-01 au 2019-09-30
[2019-11-27 20:40:58][DEBUG] : cas 0 Taxe nbjour mois: 30 nbjourTaxe:5479
[2019-11-27 20:40:58][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.09 date debut 2019-09-01 Date fin 2019-09-30
[2019-11-27 20:40:58][DEBUG] : Recherche FIN
[2019-11-27 20:40:58][DEBUG] : datedeb:2019-09-01 mois:9 Taxe fixe:12.63 2019-10-31 2019-01-01 1 304
[2019-11-27 20:40:58][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:5.5 hp:199.96 hc:168.11 VARIABLE Debut 2019-01-01 Fin 2019-10-31 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:58][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:9.57 hp:199.96 hc:168.11 VARIABLE Debut 2019-01-01 Fin 2019-10-31 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:58][DEBUG] : Début recherche taxes période mois:2019-10-01 au 2019-10-31
[2019-11-27 20:40:58][DEBUG] : cas 0 Taxe nbjour mois: 31 nbjourTaxe:5479
[2019-11-27 20:40:58][DEBUG] : 1 Taxe moisContribution Tarifaire d 'Acheminement Electricité (CTA) 14.21 fixe 0.1 date debut 2019-10-01 Date fin 2019-10-31
[2019-11-27 20:40:58][DEBUG] : Recherche FIN
[2019-11-27 20:40:58][DEBUG] : datedeb:2019-10-01 mois:10 Taxe fixe:12.64 2019-10-31 2019-01-01 1 304
[2019-11-27 20:40:58][DEBUG] : 2 Taxe:Contribution au service Public d'Electricite (CSPE) 0.0125 montant:5.41 hp:181.33 hc:180.55 VARIABLE Debut 2019-01-01 Fin 2019-10-31 taxe debut:2005-01-01 fin:2020-01-01
[2019-11-27 20:40:58][DEBUG] : 2 Taxe:Taxe sur la consommation finale d'Electricité (TCFE) 0.00925 montant:9.41 hp:181.33 hc:180.55 VARIABLE Debut 2019-01-01 Fin 2019-10-31 taxe debut:2005-01-01 fin:2020-01-01