3Ccom/edeal/frontline/kpi/methods/GiftCheque_PerimesCustomCountMethod*com/edeal/frontline/kpi/AbstractCalcMethod()VCode  LineNumberTableLocalVariableTablethisELcom/edeal/frontline/kpi/methods/GiftCheque_PerimesCustomCountMethod;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 DateI GchMontantKMontantMAmountOcom/edeal/frontline/kpi/FobAxisQ CgcCustomerSClientUCustomerW Correspondent N@ZGchUseWithAdherent\(Utilisation du chèque chez l’affilié^Partner` 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; i jk composeQuery(Ljava/util/Map;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;)Ljava/lang/String; m nologger Lorg/apache/commons/logging/Log; qsr&com/edeal/frontline/FrontlineException tu getMessage()Ljava/lang/String; wyxorg/apache/commons/logging/Log z{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; utoString w 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 sjava/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_  GchStatusID  innerJoin&(Ljava/lang/String;)Ljava/lang/String;   addAxisJoinc(Ljava/lang/StringBuilder;Lcom/edeal/frontline/kpi/JoinHelper;Lcom/edeal/frontline/kpi/ICalcAxis;)V WHERE RefVal field8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;='OT'java/util/Date   OR   GchValidityDt <    formatToSQLDate$(Ljava/util/Date;)Ljava/lang/String; 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; dateDuJourLjava/util/Date;dispose getSignature=()Ljava/util/Collection; ')(java/util/Collections *+ emptyList()Ljava/util/List;-, /1axis.getUserCode(): 3 4u getUserCode 6s7java/lang/Exception w9 z 6; <printStackTrace > ?6equalsA GchCrDtC+ EXTRACT(YEAR FROM GchCrDt) AS GchCrDt_YearE GchValidityDtG GchStatusIDI GchMontantK join_1.CgcCustomerM GchUseWithAdherentcommaZaxisstrCommaLjava/lang/Exception;Tucode: VC LEFT OUTER JOIN CmdGiftCheque_ as join_1 ON GchCgcID=join_1.CgcID getUnit2(Lcom/edeal/frontline/FlLocale;)Ljava/lang/String; Z\[com/edeal/frontline/FlLocale ]^ getLocale()Ljava/util/Locale; ` ablocaleLjava/util/Locale; d WX fhgjava/util/Locale ibFRANCE f> fl mbFRENCHoNombre de Chèques cadeauxq Gift ChequesflLocaleLcom/edeal/frontline/FlLocale;resultgetDescription w uXy0Decompte du nombre de Chèques Cadeaux périmés{Gift Cheques expired counting*(Ljava/lang/String;)Ljava/util/Collection;O(Ljava/lang/String;)Ljava/util/Collection;arg0 SourceFile(GiftCheque_PerimesCustomCountMethod.java! /* "  zYL+YYSY!SY#SY&S(.1W+7Y9YSY;SY#SY=S9?1W+YBYSYDSY#SYFSB(.1W+7YHYSYJSY#SYLSH?1W+NYPYSYRSY#SYTSVX1W+NYYYSY[SY#SY]S_X1W+ "%&7'c()*+,  abc adefg, :*+-h:0:*lpvY:|Y-~*lY::: : *::  : Y-~ :: *l  v  qe N1345$6-7?:Y<\=_>b?eAnBwCDEFGJ   +-\\_YbV eS  c-Nq,Z jkqY:Y*:W*,*-*WW*,*-*WWY:WY W, W*,*-*Y* ZQ RTV(W2X=ZE[R][^d_navbcdefgjklm R   m!"c #+ r  $%.& u  qw~,:.:*lY02:*l58:2= +Y@W29= +YBW2B= +YDW2= +YFW2H= +YHWX2P= +YJW,2Y=+YLW476 vz{ |}49GL[ux %(7QTc} H~ ~~NO~ ~P sQ 9R  b6++++++(q[29=*lY02:*l58:,:.:*lYS2+Y9W *+-586 :5:HMRV[{ H NO P:RRBQ q6 ;qz--2P= +UW  *  PWX5*+Y_*+cM*_ej*_kj nMpM, (,/3 5 5rs't  (uX5*+Y_*+vM*_ej*_kj xMzM, (,/3 5 5rs't  ($|}6   ~