3\Ccom/edeal/frontline/kpi/methods/Reservation_CustomASSOSUMBgDtMethod*com/edeal/frontline/kpi/AbstractCalcMethodsqlHlpr(Lcom/edeal/frontline/kpi/impl/SqlHelper;()VCode   &com/edeal/frontline/kpi/impl/SqlHelper  ctxLcom/edeal/frontline/FlContext;  "(Lcom/edeal/frontline/FlContext;)V  LineNumberTableLocalVariableTablethisELcom/edeal/frontline/kpi/methods/Reservation_CustomASSOSUMBgDtMethod;getSupportedAxes()Ljava/util/Collection; Signature=()Ljava/util/Collection; java/util/LinkedList  # com/edeal/frontline/kpi/TimeAxis% Rs_BgDt_Date'java/lang/String )+*(com/edeal/frontline/kpi/AbstractCalcAxis ,- FRENCH_LOCALELjava/lang/String;/Date de Début de booking )1 2-ENGLISH_LOCALE4 Check-in Date 687'com/edeal/frontline/kpi/TimeGranularity 9:DAY)Lcom/edeal/frontline/kpi/TimeGranularity; "< =c(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Lcom/edeal/frontline/kpi/TimeGranularity;)V ?A@java/util/List BCadd(Ljava/lang/Object;)ZE"com/edeal/frontline/kpi/StringAxisG Rs_BgDt_YearIAnnée de Début de bookingK Check-in Year DM N:(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)VPcom/edeal/frontline/kpi/FobAxisREntStructureLocalID_T AssociationV Enterprise OMaxesLjava/util/List;LocalVariableTypeTable5Ljava/util/List;run(Ljava/util/Map;Ljava/util/Calendar;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;)Lcom/edeal/frontline/kpi/IDataSet; Exceptions`&com/edeal/frontline/FrontlineException(Ljava/util/Map;Ljava/util/Calendar;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;)Lcom/edeal/frontline/kpi/IDataSet; c de composeQuery(Ljava/util/Map;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;)Ljava/lang/String; g hilogger Lorg/apache/commons/logging/Log; _k lm getMessage()Ljava/lang/String; oqporg/apache/commons/logging/Log rserror*(Ljava/lang/Object;Ljava/lang/Throwable;)Vu#com/edeal/frontline/kpi/ListDataSet wyx!com/edeal/frontline/kpi/Aggregate z{SUM#Lcom/edeal/frontline/kpi/Aggregate; t} ~(Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/Aggregate;Ljava/lang/Iterable;)Vjava/lang/StringBuilder Requete :  (Ljava/lang/String;)V  append-(Ljava/lang/String;)Ljava/lang/StringBuilder;  mtoString o info(Ljava/lang/Object;)V com/edeal/frontline/FlContext  getConnection()Ljava/sql/Connection; java/sql/Connection createStatement()Ljava/sql/Statement; java/sql/Statement  executeQuery((Ljava/lang/String;)Ljava/sql/ResultSet;!com/edeal/frontline/kpi/DBDataSet (Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/Aggregate;Ljava/sql/ResultSet;Ljava/sql/Connection;)V kjava/sql/SQLException com/edeal/frontline/Utils cleanUp@(Ljava/sql/Connection;Ljava/sql/Statement;Ljava/sql/ResultSet;)V"SQLException in performing query []: _ *(Ljava/lang/String;Ljava/lang/Throwable;)V kjava/lang/ExceptionException in performing query [paramsLjava/util/Map;calLjava/util/Calendar;axis1#Lcom/edeal/frontline/kpi/ICalcAxis;axis2axis3querye(Lcom/edeal/frontline/FrontlineException;itLjava/lang/Iterable;dataSet#Lcom/edeal/frontline/kpi/DBDataSet;conLjava/sql/Connection;stLjava/sql/Statement;rsLjava/sql/ResultSet;sqleLjava/sql/SQLException;Ljava/lang/Exception;FLjava/util/Map;9Ljava/lang/Iterable; StackMapTable java/util/Mapjava/util/Calendar!com/edeal/frontline/kpi/ICalcAxisjava/sql/ResultSetdispose getSignature=()Ljava/util/Collection; java/util/Collections  emptyList()Ljava/util/List;(Ljava/util/Map;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;)Ljava/lang/String;  "com/edeal/frontline/kpi/JoinHelper SELECT SUM(Rs_ResaMontant)   addAxisFieldd(Ljava/lang/StringBuilder;ZLcom/edeal/frontline/kpi/JoinHelper;Lcom/edeal/frontline/kpi/ICalcAxis;)V FROM Reservation_   addAxisJoinc(Ljava/lang/StringBuilder;Lcom/edeal/frontline/kpi/JoinHelper;Lcom/edeal/frontline/kpi/ICalcAxis;)V WHERE Rs_ResaStatus IN ('Réservation confirmée sur stock', 'Erreur en attente de paiement', 'Option acceptée', 'Confirmation sur stock')  GROUP BY   addAxisFieldG & valueOf&(Ljava/lang/Object;)Ljava/lang/String;   /com/edeal/frontline/kpi/methods/KPIMethodHelper   getSQLlimitForKPImethod3(Lcom/edeal/frontline/FlContext;)Ljava/lang/String;qLjava/lang/StringBuilder;jh$Lcom/edeal/frontline/kpi/JoinHelper;  m getUserCode & Cequals1 LEFT JOIN Enterprise as E ON Rs_HotelID=E.entID axisaxis.getUserCode(): o r   printStackTrace", $&6 (date_trunc('month',Rs_BgDate))::date AS Rs_BgDt_Date(- EXTRACT(YEAR FROM Rs_BgDate) AS Rs_BgDt_Year* E.EntStructureLocalID_commaZstrComma/ Rs_BgDt_Date1 Rs_BgDt_YeargetUnit2(Lcom/edeal/frontline/FlLocale;)Ljava/lang/String; 576com/edeal/frontline/FlLocale 89 getLocale()Ljava/util/Locale; ; <=localeLjava/util/Locale; ? 23 ACBjava/util/Locale D=FRANCE A AG H=FRENCHJChiffre d'affaires €LTurnoverflLocaleLcom/edeal/frontline/FlLocale;resultgetDescription R P3T=ASSO : Chiffre d'affaires par date de début (jour) et annéeV;ASSO : Chiffre d'affaires par date de debut (jour) et annee*(Ljava/lang/String;)Ljava/util/Collection;O(Ljava/lang/String;)Ljava/util/Collection;arg0 SourceFile(Reservation_CustomASSOSUMBgDtMethod.java!  F* * Y*#%#  Y!L+"Y$&Y(SY.SY0SY3S$5;>W+DYF&Y(SYHSY0SYJSFL>W+OYQ&Y(SYSSY0SYSSUW>W+()7*c+,XYZ X[\]^_a  #:*+-b:0:*fjnY!:tY-v|*fY::: : *::  : Y-v :: *f  n  _YY  : *f  n  _YY  _eeb1345$6-7?:Y<\=_>b?eAnBwCDEFGHIJKL O###### -+-\_b e A A Z#-V&_,Z &BB +T  .W de^_ Y:Y*:WW*,*-*W*,*-*W, W*,*-*Y*J] ^`b&d0e:fEhMjVk_linqpuq}tuvwH  Z  }^_ z--Q +W|}~* ^_ *fY:*f!:#:$ +Y%WXF +Y'W,Q+Y)W&)F&+9>CGL[uxH +,+C--b &++(^_ *fY:*f!:#:$ +Y.WXF +Y0W,Q+Y)W&)F&+9>CGL[uxH +,+C--b &++(23 5*+4:*+>M*:@E*:FE IMKM,(,/3 55MN'O- (&P3 5*+4:*+QM*:@E*:FE SMUM,(,/3 55MN'O- (&WX 6Y-Z[