Edit C:\Users\Administrator\Desktop\Back\Livraison EVQG22\com\edeal\frontline\kpi\methods\Reservation_CustomGuestAvgNuiteMethod.class
Êþº¾ 3? Ecom/edeal/frontline/kpi/methods/Reservation_CustomGuestAvgNuiteMethod *com/edeal/frontline/kpi/AbstractCalcMethod sqlHlpr (Lcom/edeal/frontline/kpi/impl/SqlHelper; entJoinCount I <init> ()V Code &com/edeal/frontline/kpi/impl/SqlHelper ctx Lcom/edeal/frontline/FlContext; "(Lcom/edeal/frontline/FlContext;)V LineNumberTable LocalVariableTable this GLcom/edeal/frontline/kpi/methods/Reservation_CustomGuestAvgNuiteMethod; getSupportedAxes ()Ljava/util/Collection; Signature =()Ljava/util/Collection<Lcom/edeal/frontline/kpi/ICalcAxis;>; " java/util/LinkedList ! % com/edeal/frontline/kpi/TimeAxis ' Rs_CrDt ) java/lang/String + - , (com/edeal/frontline/kpi/AbstractCalcAxis . / FRENCH_LOCALE Ljava/lang/String; 1 Date de création + 3 4 / ENGLISH_LOCALE 6 Date 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;)V A C B java/util/List D E add (Ljava/lang/Object;)Z G Rs_BgDate I Date de début K Start Date M "com/edeal/frontline/kpi/StringAxis O Rs_ResaStatus Q Statut de la réservation S Date of end L U V :(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)V X Rs_Type Z Type de la réservation \ Resa type ^ Rs_Origine ` Origine de la réservation b Resa Orig. d Rs_CusFourniName f Nom du Fournisseur h Provider Name j com/edeal/frontline/kpi/FobAxis l Rs_Contact n Contact p Person i U s com/edeal/frontline/kpi/RefAxis u PerCtrID w Pays de Provenance du Guest y 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 Tiers axes Ljava/util/List; LocalVariableTypeTable 5Ljava/util/List<Lcom/edeal/frontline/kpi/ICalcAxis;>; 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<Lcom/edeal/frontline/kpi/CalcParam;Ljava/lang/String;>;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 [ params Ljava/util/Map; cal Ljava/util/Calendar; axis1 #Lcom/edeal/frontline/kpi/ICalcAxis; axis2 axis3 query e (Lcom/edeal/frontline/FrontlineException; it Ljava/lang/Iterable; dataSet #Lcom/edeal/frontline/kpi/DBDataSet; con Ljava/sql/Connection; st Ljava/sql/Statement; rs Ljava/sql/ResultSet; sqle Ljava/sql/SQLException; Ljava/lang/Exception; FLjava/util/Map<Lcom/edeal/frontline/kpi/CalcParam;Ljava/lang/String;>; 9Ljava/lang/Iterable<Lcom/edeal/frontline/kpi/SnapValue;>; StackMapTable java/util/Map java/util/Calendar !com/edeal/frontline/kpi/ICalcAxis java/sql/ResultSet dispose getSignature =()Ljava/util/Collection<Lcom/edeal/frontline/kpi/CalcParam;>; java/util/Collections emptyList ()Ljava/util/List; Ã(Ljava/util/Map<Lcom/edeal/frontline/kpi/CalcParam;Ljava/lang/String;>;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)) ) *+ addAxisField d(Ljava/lang/StringBuilder;ZLcom/edeal/frontline/kpi/JoinHelper;Lcom/edeal/frontline/kpi/ICalcAxis;)V- FROM Reservation_ / 01 addAxisJoin c(Ljava/lang/StringBuilder;Lcom/edeal/frontline/kpi/JoinHelper;Lcom/edeal/frontline/kpi/ICalcAxis;)V3 GROUP BY (5 67 valueOf &(Ljava/lang/Object;)Ljava/lang/String; 9;: /com/edeal/frontline/kpi/methods/KPIMethodHelper <= getSQLlimitForKPImethod 3(Lcom/edeal/frontline/FlContext;)Ljava/lang/String; q Ljava/lang/StringBuilder; jh $Lcom/edeal/frontline/kpi/JoinHelper; C D ¦ getUserCode (F G E equals I K h 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 O 2 INNER JOIN Enterprise as E ON Rs_HotelID=E.EntID axisR axis.getUserCode(): ¨T « à ïV W printStackTraceY , [ ] Rs_CrDt_ Rs_BgDatea Rs_ResaStatusc Rs_Contacte Rs_Typeg Rs_Originei Rs_CusFourniNamek P.PerCtrIDm L.Lo_Depo E.EntCtrID comma Z strComma getUnit 2(Lcom/edeal/frontline/FlLocale;)Ljava/lang/String; vxw com/edeal/frontline/FlLocale yz getLocale ()Ljava/util/Locale; | }~ locale Ljava/util/Locale; ? st ??? java/util/Locale ?~ FRANCE ?F ?? ?~ FRENCH? Moyenne des nuités? Average number of nights flLocale Lcom/edeal/frontline/FlLocale; result getDescription ? ?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<Lcom/edeal/frontline/kpi/CalcParam;>; 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² 2SY?S· z¹ @ W+» rY?½ (Y² *SY?SY² 2SY?S· z¹ @ W+° 2 * , 7 - f . ? / ¾ 0 ê 1 2B 3l 4? 5À 6  º ? ? ? º ? ? ? ? . ² ?° : ? ? ? ? ? Å #:*+-· ?:§ 0:*´ ?¶ £¹ § » !Y· #:» Y-² ?· ¯°*´ ?» ²Y´· ¶¶ ¹¶ ½¹ À ::: : *´ ¶ Ä:¹ Ê : ¹ Ð : » ÖY-² Ø · Û:§ ?: *´ ? ¶ Þ ¹ § ¸ á» ?Y» ²Yç· ¶¶ ¹é¶ ¹ ¶ Þ¶ ¹¶ ½ · ë¿: *´ ? ¶ î ¹ § ¸ á» ?Y» ²Yñ· ¶¶ ¹é¶ ¹ ¶ î¶ ¹¶ ½ · ë¿° ? e ? ? ß e ? Ý ï b @ B C D $ E - F ? I Y K \ L _ M b N e P n Q w R ? 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¶ ¹¶ ½° F l m o q ( s 2 t < u G w P y Y z b { l } p ~ y ? ? ? ? ? ? ? H µ µ ó ô µ ÷ ø µ ù ø µ ú ø ¬>? ?@A ? µ ó ý y ²! 01 ? ? ê j-Ç ±-¹B }¶E? *´H? +J¶ ¹W*Y´H`µH-¹B t¶E? +L¶ ¹W-¹B ?¶E? *´H? +N¶ ¹W*Y´H`µH± 2 ? ? ? ? " ? , ? : ? B ? P ? W ? _ ? i ? * j j>? j@A jP ø && *+ ? ? [ .Ç ±*´ ?» ²YQ· ¶¹B ¶ ¹¶ ½¹ À § :*´ ?¶ î¹S ¶UX: ? Z:¹B &¶E? +» ²Y¸4· ¶\¶ ¹¶ ½¶ ¹W§¸¹B F¶E? +» ²Y¸4· ¶^¶ ¹¶ ½¶ ¹W§?¹B F¶E? +» ²Y¸4· ¶^¶ ¹¶ ½¶ ¹W§`¹B N¶E? +» ²Y¸4· ¶`¶ ¹¶ ½¶ ¹W§4¹B k¶E? +» ²Y¸4· ¶b¶ ¹¶ ½¶ ¹W§¹B W¶E? +» ²Y¸4· ¶d¶ ¹¶ ½¶ ¹W§ ܹB ]¶E? +» ²Y¸4· ¶f¶ ¹¶ ½¶ ¹W§ °¹B c¶E? +» ²Y¸4· ¶h¶ ¹¶ ½¶ ¹W§ ?¹B t¶E? +» ²Y¸4· ¶j¶ ¹¶ ½¶ ¹W§ X¹B }¶E? +» ²Y¸4· ¶l¶ ¹¶ ½¶ ¹W§ ,¹B ?¶E? +» ²Y¸4· ¶n¶ ¹¶ ½¶ ¹W± & ) ï ¦ ) ? ¡ & ¢ + £ 9 ¤ > ¦ C § G ¨ L « [ ¬ u x ® ? ¯ ¡ ° ¤ ± ³ ² Í ³ Ð ´ ß µ ù ¶ ü · ¸% ¹( º7 »Q ¼T ½c ¾} ¿? À? Á© ¬ û ÄÕ ÅØ Æç Ç È É Ê- Í H . .>? .pq .@A .P ø + ü Cër / b ïü (++++++++++( st ? 5*+¶uµ{*+·M*´{²?¶?? *´{²?¶?? ?M§ ?M,° Ò Ó Õ ( Ö , × / Ø 3 Ú 5 5?? '? / ü ( ( ?t ? 5*+¶uµ{*+·?M*´{²?¶?? *´{²?¶?? ?M§ ?M,° Þ ß á ( â , ã / ä 3 æ 5 5?? '? / ü ( ( ? ? 6 ° ë ? / ? ?
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de