Êþº¾3Ecom/edeal/frontline/kpi/methods/Reservation_CustomGuestAvgNuiteMethod*com/edeal/frontline/kpi/AbstractCalcMethodsqlHlpr(Lcom/edeal/frontline/kpi/impl/SqlHelper;entJoinCountI()VCode &com/edeal/frontline/kpi/impl/SqlHelper ctxLcom/edeal/frontline/FlContext; "(Lcom/edeal/frontline/FlContext;)V LineNumberTableLocalVariableTablethisGLcom/edeal/frontline/kpi/methods/Reservation_CustomGuestAvgNuiteMethod;getSupportedAxes()Ljava/util/Collection; Signature=()Ljava/util/Collection;"java/util/LinkedList ! % com/edeal/frontline/kpi/TimeAxis'Rs_CrDt)java/lang/String +-,(com/edeal/frontline/kpi/AbstractCalcAxis./ FRENCH_LOCALELjava/lang/String;1Date de crÃ©ation +34/ENGLISH_LOCALE6Date of Creation 8:9'com/edeal/frontline/kpi/TimeGranularity;<DAY)Lcom/edeal/frontline/kpi/TimeGranularity; $> ?c(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Lcom/edeal/frontline/kpi/TimeGranularity;)VACBjava/util/ListDEadd(Ljava/lang/Object;)ZG Rs_BgDateIDate de dÃ©butK Start DateM"com/edeal/frontline/kpi/StringAxisO Rs_ResaStatusQStatut de la rÃ©servationSDate of end LU V:(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)VXRs_TypeZType de la rÃ©servation\ Resa type^ Rs_Origine`Origine de la rÃ©servationb Resa Orig.dRs_CusFourniNamefNom du Fournisseurh Provider Namejcom/edeal/frontline/kpi/FobAxisl Rs_ContactnContactpPerson iUscom/edeal/frontline/kpi/RefAxisuPerCtrIDwPays de Provenance du Guesty Guest Country r{ |((Ljava/lang/String;[Ljava/lang/String;)V~Lo_Dep€DÃ©partement du Tiers‚Department of Tiers„EntCtrID† Pays du TiersˆCountry of TiersaxesLjava/util/List;LocalVariableTypeTable5Ljava/util/List;getAggregate%()Lcom/edeal/frontline/kpi/Aggregate; ’‘!com/edeal/frontline/kpi/Aggregate“”AVERAGE#Lcom/edeal/frontline/kpi/Aggregate;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; œžcomposeQueryŒ(Ljava/util/Map;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;)Ljava/lang/String; ¡¢logger Lorg/apache/commons/logging/Log; ˜¤¥¦ getMessage()Ljava/lang/String;¨ª©org/apache/commons/logging/Log«¬error*(Ljava/lang/Object;Ljava/lang/Throwable;)V®#com/edeal/frontline/kpi/ListDataSet ° ±£(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; ²¾¿¦toString¨ÁÂÃ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 ÙÚ”SUM ÖÜ Ý¸(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;)Vè"SQLException in performing query [ê]: ˜ì í*(Ljava/lang/String;Ljava/lang/Throwable;)V ï¤ðjava/lang/ExceptionòException 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/ResultSetdisposegetSignature=()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 'AVG(cast(Rs_NuiteRoom as int)) )*+addAxisFieldd(Ljava/lang/StringBuilder;ZLcom/edeal/frontline/kpi/JoinHelper;Lcom/edeal/frontline/kpi/ICalcAxis;)V- FROM Reservation_ /01addAxisJoinc(Ljava/lang/StringBuilder;Lcom/edeal/frontline/kpi/JoinHelper;Lcom/edeal/frontline/kpi/ICalcAxis;)V3 GROUP BY (567valueOf&(Ljava/lang/Object;)Ljava/lang/String; 9;:/com/edeal/frontline/kpi/methods/KPIMethodHelper<=getSQLlimitForKPImethod3(Lcom/edeal/frontline/FlContext;)Ljava/lang/String;qLjava/lang/StringBuilder;jh$Lcom/edeal/frontline/kpi/JoinHelper;CD¦getUserCode (FGEequals IKh LEFT JOIN Enterprise as E ON Rs_HotelID=E.EntID LEFT JOIN Localite_ as L ON E.EntLocalityID_ = L.Lo_ID M. INNER JOIN Person as P ON Rs_Contact=P.PerID O2 INNER JOIN Enterprise as E ON Rs_HotelID=E.EntID axisRaxis.getUserCode():¨T«Ã ïVW printStackTraceY, [] Rs_CrDt_ Rs_BgDatea Rs_ResaStatusc Rs_Contacte Rs_Typeg Rs_Originei Rs_CusFourniNamek P.PerCtrIDm L.Lo_Depo E.EntCtrIDcommaZstrCommagetUnit2(Lcom/edeal/frontline/FlLocale;)Ljava/lang/String; vxwcom/edeal/frontline/FlLocaleyz getLocale()Ljava/util/Locale; |}~localeLjava/util/Locale; €st ‚„ƒjava/util/Locale…~FRANCE ‚F ‚ˆ‰~FRENCH‹Moyenne des nuitÃ©sAverage number of nightsflLocaleLcom/edeal/frontline/FlLocale;resultgetDescription “‘t•$Moyenne des nuitÃ©s par rÃ©servation—Average number of nights *(Ljava/lang/String;)Ljava/util/Collection;O(Ljava/lang/String;)Ljava/util/Collection;arg0 SourceFile*Reservation_CustomGuestAvgNuiteMethod.java! F*·*»Y*´·µ±#%# 4Â»!Y·#L+»$Y&½(Y²*SY0SY²2SY5S&²7·=¹@W+»$YF½(Y²*SYHSY²2SYJSF²7·=¹@W+»LYN½(Y²*SYPSY²2SYRSN·T¹@W+»LYW½(Y²*SYYSY²2SY[SW·T¹@W+»LY]½(Y²*SY_SY²2SYaS]·T¹@W+»LYc½(Y²*SYeSY²2SYgSc·T¹@W+»iYk½(Y²*SYmSY²2SYoSo·q¹@W+»rYt½(Y²*SYvSY²2SYxS·z¹@W+»rY}½(Y²*SYSY²2SYS·z¹@W+»rYƒ½(Y²*SY…SY²2SY‡S·z¹@W+°2*,7-f.’/¾0ê12B3l4–5À6Âº‰Š‹º‰ŒŽ.²°:•–—˜šÅ#:*+-·›:§0:*´Ÿ¶£¹§»!Y·#:»Y-²·¯°*´Ÿ»²Y´·¶¶¹¶½¹À::: : *´¶Ä:¹Ê: ¹Ð: »ÖY-²Ø ·Û:§‰:*´Ÿ¶Þ¹§ ¸á»˜Y»²Yç·¶¶¹é¶¹¶Þ¶¹¶½·ë¿:*´Ÿ¶î¹§ ¸á»˜Y»²Yñ·¶¶¹é¶¹¶î¶¹¶½·ë¿°˜e—šße—Ýïb@BCD$E-F?IYK\L_MbNePnQwR‚S—TœU¬VµWÝXßYïZø[ ^˜##óô#õö#÷ø#ùø#úø û/+üý-þÿ\Ç_ÄbÁ e¾ œA ßAü ‹#ó-þ Vÿ(˜,ÿZ(ÖËÑß÷BïûB +±c.¸°fž—˜~µ»²Y· :»!Y*´·#:$¶¹W&¶¹W*,·(*-·(*·(,¶¹W*,·.*-·.*·.,Æ2¶¹W*,·(*-·(*·(»²Y¶½¸4·¶*´¸8¶¹¶½°Fl moq(s2t<uGwPyYzb{l}p~yƒ‚ƒ˜„Hµµóôµ÷øµùøµúø ¬>?Ÿ@A‹µó ýy²!01—˜êj-Ç±-¹B}¶E™*´Hš+J¶¹W*Y´H`µH-¹Bt¶E™+L¶¹W-¹Bƒ¶E™*´Hš+N¶¹W*Y´H`µH±2‰‹Œ"Ž,‘:’B•P–W—_˜i›*jj>?j@AjPø &&*+—˜[.Ç±*´Ÿ»²YQ·¶¹B¶¹¶½¹À§:*´Ÿ¶î¹S¶UX:šZ:¹B&¶E™ +»²Y¸4·¶\¶¹¶½¶¹W§¸¹BF¶E™ +»²Y¸4·¶^¶¹¶½¶¹W§Œ¹BF¶E™ +»²Y¸4·¶^¶¹¶½¶¹W§`¹BN¶E™ +»²Y¸4·¶`¶¹¶½¶¹W§4¹Bk¶E™ +»²Y¸4·¶b¶¹¶½¶¹W§¹BW¶E™ +»²Y¸4·¶d¶¹¶½¶¹W§Ü¹B]¶E™ +»²Y¸4·¶f¶¹¶½¶¹W§°¹Bc¶E™ +»²Y¸4·¶h¶¹¶½¶¹W§„¹Bt¶E™ +»²Y¸4·¶j¶¹¶½¶¹W§X¹B}¶E™ +»²Y¸4·¶l¶¹¶½¶¹W§,¹Bƒ¶E™+»²Y¸4·¶n¶¹¶½¶¹W±&)ï¦)Ÿ¡&¢+£9¤>¦C§G¨L«[¬ux®‡¯¡°¤±³²Í³Ð´ßµù¶ü·¸%¹(º7»Q¼T½c¾}¿€ÀÁ©Â¬Ã»ÄÕÅØÆçÇÈÉÊ-ÍH..>?.pq.@A.Pø+ü Cër/ bïü (++++++++++(st›5*+¶uµ{*+·M*´{²¶†š*´{²‡¶†™ ŠM§ŒM,°ÒÓÕ(Ö,×/Ø3Ú 55Ž'/ ü((‘t›5*+¶uµ{*+·’M*´{²¶†š*´{²‡¶†™ ”M§–M,°Þßá(â,ã/ä3æ 55Ž'/ ü((˜™6°ëš/›œ