3L=com/edeal/frontline/kpi/methods/GiftCheque_CustomAmountMethod*com/edeal/frontline/kpi/AbstractCalcMethod()VCode  LineNumberTableLocalVariableTablethis?Lcom/edeal/frontline/kpi/methods/GiftCheque_CustomAmountMethod;getSupportedAxes()Ljava/util/Collection; Signature=()Ljava/util/Collection;java/util/LinkedList   com/edeal/frontline/kpi/TimeAxisGchCrDtjava/lang/String (com/edeal/frontline/kpi/AbstractCalcAxis   FRENCH_LOCALELjava/lang/String;"Date de création $ % ENGLISH_LOCALE'Date of Creation )+*'com/edeal/frontline/kpi/TimeGranularity ,-DAY)Lcom/edeal/frontline/kpi/TimeGranularity; / 0c(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Lcom/edeal/frontline/kpi/TimeGranularity;)V 243java/util/List 56add(Ljava/lang/Object;)Z8 GchValidityDt:Date de validité<Effective Date>com/edeal/frontline/kpi/RefAxis@ GchStatusIDBStatutD Department =F G((Ljava/lang/String;[Ljava/lang/String;)VI"com/edeal/frontline/kpi/StringAxisK GchMontantMMontantOAmount HQ R:(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)VTcom/edeal/frontline/kpi/FobAxisV CgcCustomerXClientZCustomer\ Correspondent SQ_GchUseWithAdherenta(Utilisation du chèque chez l’affiliécPartnere EnterpriseaxesLjava/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;(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; n op composeQuery(Ljava/util/Map;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;)Ljava/lang/String; r stlogger Lorg/apache/commons/logging/Log; vxw&com/edeal/frontline/FrontlineException yz getMessage()Ljava/lang/String; |~}org/apache/commons/logging/Log error*(Ljava/lang/Object;Ljava/lang/Throwable;)V#com/edeal/frontline/kpi/ListDataSet !com/edeal/frontline/kpi/Aggregate SUM#Lcom/edeal/frontline/kpi/Aggregate; (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; ztoString | info(Ljava/lang/Object;)V  ctxLcom/edeal/frontline/FlContext; 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 xjava/sql/SQLException com/edeal/frontline/Utils cleanUp@(Ljava/sql/Connection;Ljava/sql/Statement;Ljava/sql/ResultSet;)VparamsLjava/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;FLjava/util/Map;9Ljava/lang/Iterable; StackMapTable java/util/Mapjava/util/Calendar!com/edeal/frontline/kpi/ICalcAxisjava/sql/ResultSet Exceptions(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 "(Lcom/edeal/frontline/FlContext;)VSELECT SUM(GchMontant)   addAxisFieldd(Ljava/lang/StringBuilder;ZLcom/edeal/frontline/kpi/JoinHelper;Lcom/edeal/frontline/kpi/ICalcAxis;)V FROM GiftCheque_   addAxisJoinc(Ljava/lang/StringBuilder;Lcom/edeal/frontline/kpi/JoinHelper;Lcom/edeal/frontline/kpi/ICalcAxis;)V GROUP BYqLjava/lang/StringBuilder;jh$Lcom/edeal/frontline/kpi/JoinHelper;dispose getSignature=()Ljava/util/Collection; java/util/Collections  emptyList()Ljava/util/List; ,   z getUserCode  6equals GchCrDt GchValidityDt GchStatusID GchMontant join_1.CgcID GchUseWithAdherentcommaZaxis!C LEFT OUTER JOIN CmdGiftCheque_ as join_1 ON GchCgcID=join_1.CgcID getUnit2(Lcom/edeal/frontline/FlLocale;)Ljava/lang/String; %'&com/edeal/frontline/FlLocale () getLocale()Ljava/util/Locale; + ,-localeLjava/util/Locale; / "# 132java/util/Locale 4-FRANCE 1 17 8-FRENCH:CA des chèques Cadeaux<Gift Cheques CAflLocaleLcom/edeal/frontline/FlLocale;resultgetDescription B @#D'Somme des montants des Chèques cadeauxFBookings counting*(Ljava/lang/String;)Ljava/util/Collection;O(Ljava/lang/String;)Ljava/util/Collection;arg0 SourceFile"GiftCheque_CustomAmountMethod.java! /* "  xYL+YYSY!SY#SY&S(.1W+Y7YSY9SY#SY;S7(.1W+=Y?YSYASY#SYCSE1W+HYJYSYLSY#SYNSJP1W+SYUYSYWSY#SYYS[]1W+SY^YSY`SY#SYbSd]1W+ "%&7'f()*+,  fgh fijkl, :*+-m:0:*qu{Y:Y-*qY::: : *::  : Y- :: *q  {  ve N1345$6-7?:Y<\=_>b?eAnBwCDEFGJ   +-\\_YbV eS  h-Nv,Z opvcY:Y*:WW*,*-*W*,*-*, W*,*-* FP QST&V0W:XEZM\V]_^i`maudefg H  h  u+ l  . o  vZ + W +W 7+Wh ?+WN J+W4 U+W ^ +W Rtuw!x)y,z;{C|F}U~]`owz 4   vz-- U + W  * "#5*+$**+.M**05**65 9M;M, (,/3 5 5=>'?  (@#5*+$**+AM**05**65 CMEM, (,/3 5 5=>'?  (GH6   I JK