Êþº¾3€Fcom/edeal/frontline/kpi/methods/GiftCheque_UsedWithAdCustomCountMethod*com/edeal/frontline/kpi/AbstractCalcMethod()VCode LineNumberTableLocalVariableTablethisHLcom/edeal/frontline/kpi/methods/GiftCheque_UsedWithAdCustomCountMethod;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;)V243java/util/List56add(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/FobAxisQCgcCustomerSClientUCustomerW 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; ijkcomposeQueryŒ(Ljava/util/Map;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;)Ljava/lang/String; mnologger Lorg/apache/commons/logging/Log; qsr&com/edeal/frontline/FrontlineExceptiontu getMessage()Ljava/lang/String;wyxorg/apache/commons/logging/Logz{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;)Vˆjava/lang/StringBuilderŠ Requete : ‡Œ(Ljava/lang/String;)V ‡‘append-(Ljava/lang/String;)Ljava/lang/StringBuilder; ‡“”utoStringw–—˜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 µs¶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/MapÚjava/util/CalendarÜ!com/edeal/frontline/kpi/ICalcAxisÞjava/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;)VèSELECT 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;='PO' OR ='TB'='PA' ='IN' ) AND GchUseWithAdherent notnull GROUP BY ì addAxisFieldG valueOf&(Ljava/lang/Object;)Ljava/lang/String; /com/edeal/frontline/kpi/methods/KPIMethodHelpergetSQLlimitForKPImethod3(Lcom/edeal/frontline/FlContext;)Ljava/lang/String;qLjava/lang/StringBuilder;jh$Lcom/edeal/frontline/kpi/JoinHelper;disposegetSignature=()Ljava/util/Collection; &('java/util/Collections)* emptyList()Ljava/util/List;,, .0axis.getUserCode():Û23ugetUserCode 5s6java/lang/Exceptionw8z˜ 5:;printStackTrace =>6equals@ GchCrDtB+ EXTRACT(YEAR FROM GchCrDt) AS GchCrDt_YearD GchValidityDtF GchStatusIDH GchMontantJ join_1.CgcCustomerL GchUseWithAdherentcommaZaxisstrCommaLjava/lang/Exception;Sucode: UC LEFT OUTER JOIN CmdGiftCheque_ as join_1 ON GchCgcID=join_1.CgcID getUnit2(Lcom/edeal/frontline/FlLocale;)Ljava/lang/String; Y[Zcom/edeal/frontline/FlLocale\] getLocale()Ljava/util/Locale; _`alocaleLjava/util/Locale; cVW egfjava/util/LocalehaFRANCE e= eklaFRENCHnNombre de ChÃ¨ques cadeauxpGift ChequesflLocaleLcom/edeal/frontline/FlLocale;resultgetDescription vtWx1Nombre de chÃ¨ques encaissÃ©s par un Logis donnÃ©z)Gift Cheques Used with Adherents counting*(Ljava/lang/String;)Ljava/util/Collection;O(Ljava/lang/String;)Ljava/util/Collection;arg0 SourceFile+GiftCheque_UsedWithAdCustomCountMethod.java!/*·± " z»Y·L+»Y½Y²SY!SY²#SY&S²(·.¹1W+»7Y9½Y²SY;SY²#SY=S9·?¹1W+»YB½Y²SYDSY²#SYFSB²(·.¹1W+»7YH½Y²SYJSY²#SYLSH·?¹1W+»NYP½Y²SYRSY²#SYTSV·X¹1W+»NYY½Y²SY[SY²#SY]S_·X¹1W+° "%&7'c(’)¾*ê+, abcadefg,¸:*+-·h:§0:*´l¶p¹v»Y·:»|Y-²~·„°*´l»‡Y‰·‹¶Ž¶’¹•::: : *´™¶:¹£: ¹©: »¯Y-²~ ·±:§:*´l¶´¹v ¸·°qe—šµ N1345$6-7?:Y<\=_>b?eAnBwC‚D—EœF¬GµJŽ¸ ¸½¾¸¿À¸ÁÂ¸ÃÂ¸ÄÂµÅ +ÆÇ-ÈÉ\\ÊË_YÌÍbVÎÏ eSÐÑ œÒÓc¸½Ô-ÈÕÖNÿ×ÙÛÛÛq,ÿZ×ÙÛÛÛ¯¤ªÝµjkßqà1@»‡Y·á:»âY*´™·ä:ç¶ŽW*,·é*-·é*·éí¶ŽWï¶ñ¶ŽW*,·õ*-·õ*·õù¶ŽWïû¶ý¶Ž¶ŽW¶ŽWïû¶ý¶Ž¶ŽW¶ŽWïû¶ý¶Ž¶ŽW¶ŽWïû¶ý¶Ž ¶ŽW¶ŽW ¶ŽW,Æ¶ŽW*,·*-·*·»‡Y¶’¸·‹*´™¸¶Ž¶’° nP QSU(V2W=YE[R][^d_navb‹c”d©e²fÇgÐhåiîj÷kûlopq#rH@ @½¾@ÁÂ@ÃÂ@ÄÂ 7* !c@½ÔÖý‡â"+± y #$.¸%° | ëìßqw~Ç±+:š-:*´l»‡Y/·‹¹1¶Ž¶’¹•§:*´l¶4¹7¶9¹1¶<™ +»‡Y¸·‹?¶Ž¶’¶ŽW§¹19¶<™ +»‡Y¸·‹A¶Ž¶’¶ŽW§Ü¹1B¶<™ +»‡Y¸·‹C¶Ž¶’¶ŽW§°¹1ï¶<™ +»‡Y¸·‹E¶Ž¶’¶ŽW§„¹1H¶<™ +»‡Y¸·‹G¶Ž¶’¶ŽW§X¹1P¶<™ +»‡Y¸·‹I¶Ž¶’¶ŽW§,¹1Y¶<™+»‡Y¸·‹K¶Ž¶’¶ŽW±475 v‚ƒ„‡4ˆ9‰GŠLŒ[uŽx‡¡‘¤’³“Í”Ð•ß–ù—ü˜™%š(›7œQTžcŸ}¡H~ ~~MN~ !~OÂsP 9ÆQÖü b5++++++(ìßq[¡Ç±¹19¶<™…*´l»‡Y/·‹¹1¶Ž¶’¹•§:*´l¶4¹7¶9+:š-:*´l»‡YR·‹¹1¶Ž¶’¹•+»‡Y¸·‹9¶Ž¶’¶ŽW§*+-·é±585 :¥¦¨5©:ªH«MR®V¯[±{²”³—´ ¶H¡ ¡¡MN¡ !¡OÂ:ÆQRBP Öq5ü ú;÷øßqz-Ç±-¹1P¶<™+T¶ŽW± º¼½¿* !OÂÖVW›5*+¶Xµ^*+·bM*´^²d¶iš*´^²j¶i™ mM§oM,° ÃÄÆ(Ç,È/É3Ì 5 5qr's Ö ü(tW›5*+¶Xµ^*+·uM*´^²d¶iš*´^²j¶i™ wM§yM,° ÑÒÔ(Õ,Ö/×3Ù 5 5qr's Ö ü(#{|6° ß } ~