Êþº¾3 Icom/edeal/frontline/kpi/methods/Reservation_CustomGuestDurationAvgMethod3*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 LineNumberTableLocalVariableTablethisKLcom/edeal/frontline/kpi/methods/Reservation_CustomGuestDurationAvgMethod3;getSupportedAxes()Ljava/util/Collection; Signature=()Ljava/util/Collection;"java/util/LinkedList ! %"com/edeal/frontline/kpi/StringAxis' Rs_ResaStatus)java/lang/String +-,(com/edeal/frontline/kpi/AbstractCalcAxis./ FRENCH_LOCALELjava/lang/String;1Statut de la rÃ©servation +34/ENGLISH_LOCALE6Date of end $8 9:(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)V;=<java/util/List>?add(Ljava/lang/Object;)ZARs_TypeCType de la rÃ©servationE Resa typeG Rs_OrigineIOrigine de la rÃ©servationK Resa Orig.MRs_CusFourniNameONom du FournisseurQ Provider NameScom/edeal/frontline/kpi/RefAxisUPerCtrIDWPays de Provenance du GuestY Guest Country R[ \((Ljava/lang/String;[Ljava/lang/String;)V^Lo_Dep`DÃ©partement du TiersbDepartment of TiersdEntCtrIDf Pays du TiershCountry of Tiersj com/edeal/frontline/kpi/TimeAxislRs_BgDt_DatenDate de DÃ©but de bookingp Check-in Date rts'com/edeal/frontline/kpi/TimeGranularityuvDAY)Lcom/edeal/frontline/kpi/TimeGranularity; ix yc(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Lcom/edeal/frontline/kpi/TimeGranularity;)V{Rs_CrDt_Date}Date de crÃ©ationDate of CreationaxesLjava/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; 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 Ÿ¡ !com/edeal/frontline/kpi/Aggregate¢£AVERAGE#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; §³´•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 ËÎ Ï¸(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 4AVG(DATE_PART('day', Rs_BgDate - Rs_DateCreation) ) addAxisFieldd(Ljava/lang/StringBuilder;ZLcom/edeal/frontline/kpi/JoinHelper;Lcom/edeal/frontline/kpi/ICalcAxis;)V FROM Reservation_ !"#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; .0//com/edeal/frontline/kpi/methods/KPIMethodHelper12getSQLlimitForKPImethod3(Lcom/edeal/frontline/FlContext;)Ljava/lang/String;qLjava/lang/StringBuilder;jh$Lcom/edeal/frontline/kpi/JoinHelper;89•getUserCode (;<?equals >@h LEFT JOIN Enterprise as E ON Rs_HotelID=E.EntID LEFT JOIN Localite_ as L ON E.EntLocalityID_ = L.Lo_ID B. INNER JOIN Person as P ON Rs_Contact=P.PerID D2 INNER JOIN Enterprise as E ON Rs_HotelID=E.EntID axisGaxis.getUserCode():—Iš¸ áKL printStackTraceN, PRRs_CrDtT Rs_CrDtV Rs_BgDateX Rs_BgDateZ Rs_ResaStatus\ Rs_Contact^ Rs_Contact` Rs_Typeb Rs_Origined Rs_CusFourniNamef P.PerCtrIDh L.Lo_Depj E.EntCtrIDl6 (date_trunc('month',Rs_BgDate))::date AS Rs_BgDt_Daten< (date_trunc('month',Rs_datecreation))::date AS Rs_CrDt_DatecommaZstrCommas Rs_BgDt_Dateu Rs_CrDt_DategetUnit2(Lcom/edeal/frontline/FlLocale;)Ljava/lang/String; y{zcom/edeal/frontline/FlLocale|} getLocale()Ljava/util/Locale; €localeLjava/util/Locale; ƒvw …‡†java/util/LocaleˆFRANCE …; …‹ŒFRENCHŽDÃ©lai Moyen en JoursAverage durationflLocaleLcom/edeal/frontline/FlLocale;resultgetDescription –”w˜1DÃ©lai moyen entre la RÃ©servation et le sÃ©jour š/Duration between Reservation and Beginning Date*(Ljava/lang/String;)Ljava/util/Collection;O(Ljava/lang/String;)Ljava/util/Collection;arg0 SourceFile.Reservation_CustomGuestDurationAvgMethod3.java! F*·*»Y*´·µ±#%# –»!Y·#L+»$Y&½(Y²*SY0SY²2SY5S&·7¹:W+»$Y@½(Y²*SYBSY²2SYDS@·7¹:W+»$YF½(Y²*SYHSY²2SYJSF·7¹:W+»$YL½(Y²*SYNSY²2SYPSL·7¹:W+»RYT½(Y²*SYVSY²2SYXS·Z¹:W+»RY]½(Y²*SY_SY²2SYaS·Z¹:W+»RYc½(Y²*SYeSY²2SYgS·Z¹:W+»iYk½(Y²*SYmSY²2SYoSk²q·w¹:W+»iYz½(Y²*SY|SY²2SY~Sz²q·w¹:W+°.*.4/`0Œ1¸3â4566e7”8–Ž€‚Ž€ƒ„…†‡‰Å#:*+-·Š:§0:*´Ž¶’¹–»!Y·#:»œY-²ž·¤°*´Ž»§Y©·«¶®¶²¹µ::: : *´¶¹:¹¿: ¹Å: »ËY-²ž ·Í:§‰:*´Ž¶Ð¹– ¸Ó»‡Y»§YÙ·«¶®Û¶®¶Ð¶®¶²·Ý¿:*´Ž¶à¹– ¸Ó»‡Y»§Yã·«¶®Û¶®¶à¶®¶²·Ý¿°‡e—šÑe—Ýáb>@AB$C-D?GYI\J_KbLeNnOwP‚Q—RœS¬TµUÝVßWïXøY \˜##åæ#çè#éê#ëê#ìê í/+îï-ðñ\Çòó_ÄôõbÁö÷ e¾øù œAúûßAîü‚#åý-ðþÿVÿ(‡,ÿZ(ËÀÆÑ÷BáûB +±a .¸°dŒ†‡~µ»§Y·:»Y*´·:¶®W¶®W*,·*-·*·¶®W*,· *-· *· ,Æ$¶®W*,·&*-·&*·&»§Y¶²¸)·«*´¸-¶®¶²°Fj kmp(r2s<tGvPxYybzl|p}y€ƒ‚˜ƒHµµåæµéêµëêµìê ¬34Ÿ56‚µåýÿýy§"#†‡ðp-Ç±-¹7]¶:™*´=šX+?¶®W*Y´=`µ=§C-¹7T¶:™+A¶®W§*-¹7c¶:™*´=š+C¶®W*Y´=`µ=±2ˆŠ‹Œ",=E‘V’]“e”o—*pp34p56pEêÿ)&†‡ÑŠÇ±*´Ž»§YF·«¹7¶®¶²¹µ§:*´Ž¶à¹H¶JM:šO:¹7Q¶:™ +»§Y¸)·«S¶®¶²¶®W§¹7U¶:™ +»§Y¸)·«W¶®¶²¶®W§æ¹7U¶:™ +»§Y¸)·«W¶®¶²¶®W§¹¹7&¶:™ +»§Y¸)·«Y¶®¶²¶®W§¹7[¶:™ +»§Y¸)·«]¶®¶²¶®W§`¹7@¶:™ +»§Y¸)·«_¶®¶²¶®W§4¹7F¶:™ +»§Y¸)·«a¶®¶²¶®W§¹7L¶:™ +»§Y¸)·«c¶®¶²¶®W§Ü¹7T¶:™ +»§Y¸)·«e¶®¶²¶®W§°¹7]¶:™ +»§Y¸)·«g¶®¶²¶®W§„¹7c¶:™ +»§Y¸)·«i¶®¶²¶®W§X¹7k¶:™ +»§Y¸)·«k¶®¶²¶®W§,¹7z¶:™+»§Y¸)·«m¶®¶²¶®W±&)á¾/›&ž+Ÿ9 >¢C£G¤L§\¨v©yª‰«£¬¦¶®Ð¯Ó°â±ü²ÿ³´)µ,¶;·U¸X¹gº»„¼“½¾°¿¿ÀÙÁÜÂëÃÄÅÆ1Ç4ÈCÉ]Ê`ËoÌ‰ÎHŠŠ34ŠopŠ56ŠEê+îüCGq/ÿbáü (,,,+,+++++++((†‡ÑŠÇ±*´Ž»§YF·«¹7¶®¶²¹µ§:*´Ž¶à¹H¶JM:šO:¹7Q¶:™ +»§Y¸)·«S¶®¶²¶®W§¹7U¶:™ +»§Y¸)·«W¶®¶²¶®W§æ¹7U¶:™ +»§Y¸)·«W¶®¶²¶®W§¹¹7&¶:™ +»§Y¸)·«Y¶®¶²¶®W§¹7[¶:™ +»§Y¸)·«]¶®¶²¶®W§`¹7@¶:™ +»§Y¸)·«_¶®¶²¶®W§4¹7F¶:™ +»§Y¸)·«a¶®¶²¶®W§¹7L¶:™ +»§Y¸)·«c¶®¶²¶®W§Ü¹7T¶:™ +»§Y¸)·«e¶®¶²¶®W§°¹7]¶:™ +»§Y¸)·«g¶®¶²¶®W§„¹7c¶:™ +»§Y¸)·«i¶®¶²¶®W§X¹7k¶:™ +»§Y¸)·«r¶®¶²¶®W§,¹7z¶:™+»§Y¸)·«t¶®¶²¶®W±&)á¾/ÒÔ&Õ+Ö9×>ÙCÚGÛLÞ\ßvàyá‰â£ã¦ä¶åÐæÓçâèüéÿêë)ì,í;îUïXðgñò„ó“ôõ°ö¿÷ÙøÜùëúûüý1þ4ÿC]`o‰HŠŠ34ŠopŠ56ŠEê+îüCGq/ÿbáü (,,,+,+++++++(vw›5*+¶xµ~*+·‚M*´~²„¶‰š*´~²Š¶‰™ M§M,° ( ,/3 55‘’'“/ÿ ü((”w›5*+¶xµ~*+·•M*´~²„¶‰š*´~²Š¶‰™ —M§™M,°(,/3 55‘’'“/ÿ ü(( ›œ6°"/žŸ