3o()VCode  LineNumberTableLocalVariableTablethis>Lcom/edeal/frontline/kpi/methods/GiftCheque_CustomCountMethod;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"com/edeal/frontline/kpi/StringAxis: GchCrDt_Year<Année (Date de création)>Year (Date of Creation) 7@ A:(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)VC GchValidityDtEDate de validitéGEffective DateIcom/edeal/frontline/kpi/RefAxisK GchStatusIDMStatutO Department HQ R((Ljava/lang/String;[Ljava/lang/String;)VT GchMontantVMontantXAmountZcom/edeal/frontline/kpi/FobAxis\ CgcCustomer^Client`Customerb Correspondent Y@eGchUseWithAdherentg(Utilisation du chèque chez l’affiliéiPartnerk 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; t uv composeQuery(Ljava/util/Map;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;)Ljava/lang/String; x yzlogger Lorg/apache/commons/logging/Log; |~}&com/edeal/frontline/FrontlineException  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; toString 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 ~java/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 COUNT (*)   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 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;dispose getSignature=()Ljava/util/Collection; java/util/Collections  emptyList()Ljava/util/List;, axis.getUserCode(): ! " getUserCode $~%java/lang/Exception ' $) *printStackTrace , -6equals/ GchCrDt1+ EXTRACT(YEAR FROM GchCrDt) AS GchCrDt_Year3 GchValidityDt5 GchStatusID7 GchMontant9 join_1.CgcID; GchUseWithAdherentcommaZaxisstrCommaLjava/lang/Exception;Bucode: DC LEFT OUTER JOIN CmdGiftCheque_ as join_1 ON GchCgcID=join_1.CgcID getUnit2(Lcom/edeal/frontline/FlLocale;)Ljava/lang/String; HJIcom/edeal/frontline/FlLocale KL getLocale()Ljava/util/Locale; N OPlocaleLjava/util/Locale; R EF TVUjava/util/Locale WPFRANCE T, TZ [PFRENCH]Nombre de Chèques cadeaux_ Gift ChequesflLocaleLcom/edeal/frontline/FlLocale;resultgetDescription e cFg&Decompte du nombre de Chèques CadeauxiGift Cheques counting*(Ljava/lang/String;)Ljava/util/Collection;O(Ljava/lang/String;)Ljava/util/Collection;arg0 SourceFile!GiftCheque_CustomCountMethod.java! /* "  BYL+YYSY!SY#SY&S(.1W+7Y9YSY;SY#SY=S9?1W+YBYSYDSY#SYFSB(.1W+HYJYSYLSY#SYNSP1W+7YSYSYUSY#SYWSS?1W+YY[YSY]SY#SY_Sac1W+YYdYSYfSY#SYhSjc1W+ & %&7'c()*+,@- B :lmn :lopqr, :*+-s:0:*w{Y:Y-*wY::: : *::  : Y- :: *w    |e N2456$7-8?;Y=\>_?b@eBnCwDEFGHK   +-\\_YbV eS  n-N|,Z uv|nY:Y*:W*,*-*W*,*-*, W*,*-*Y* BQ RTV(W2X=ZE\N]W^a`eamdwefg H   n  m+ l  . o  |w~::*wY :*w#&( + +Y.W 9+ +Y0W B+ +Y2W J+ +Y4W S+ +Y6WX [+ +Y8W, d++Y:W47$ vtu vwz4{9|G}L[ux %(7QTc} H~ ~ ~<=~~> s? 9@  b$++++++(|[ 9+*wY :*w#&(::*wYA +Y9W *+-58$ :5:HMRV[{ H  <=>:@RB? q$ ;|z-- [+ +CW  *  >EF5*+GM*+QM*MSX*MYX \M^M, (,/3 5 5`a'b  (cF5*+GM*+dM*MSX*MYX fMhM, (,/3 5 5`a'b  (jk6   l mn