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 +3 4/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;)V ACBjava/util/List DEadd(Ljava/lang/Object;)ZG Rs_BgDateIDate de débutK Start DateM"com/edeal/frontline/kpi/StringAxisO Rs_ResaStatusQStatut de la réservationS Date 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~EntDepartmentID_Département du TiersDepartment of TiersEntCtrID Pays du TiersCountry 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;)Vjava/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/ExceptionException 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/ResultSetdispose getSignature=()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_ / 01 addAxisJoinc(Ljava/lang/StringBuilder;Lcom/edeal/frontline/kpi/JoinHelper;Lcom/edeal/frontline/kpi/ICalcAxis;)V3 GROUP BYqLjava/lang/StringBuilder;jh$Lcom/edeal/frontline/kpi/JoinHelper; 9 : getUserCode (< =Eequals ? A2 INNER JOIN Enterprise as E ON Rs_HotelID=E.EntID C. INNER JOIN Person as P ON Rs_Contact=P.PerID axisF,H Rs_CrDtJ Rs_BgDateL Rs_ResaStatusN Rs_ContactP Rs_TypeR Rs_OrigineT Rs_CusFourniNameV P.PerCtrIDX E.EntDepartmentID_Z E.EntCtrIDcommaZgetUnit2(Lcom/edeal/frontline/FlLocale;)Ljava/lang/String; `bacom/edeal/frontline/FlLocale cd getLocale()Ljava/util/Locale; f ghlocaleLjava/util/Locale; j ]^ lnmjava/util/Locale ohFRANCE l< lr shFRENCHuMoyenne des nuitéswAverage number of nightsflLocaleLcom/edeal/frontline/FlLocale;resultgetDescription } {^$Moyenne des nuités par réservationAverage 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*SY0SY2SY5S&7=@W+$YF(Y*SYHSY2SYJSF7=@W+LYN(Y*SYPSY2SYRSNT@W+LYW(Y*SYYSY2SY[SWT@W+LY](Y*SY_SY2SYaS]T@W+LYc(Y*SYeSY2SYgScT@W+iYk(Y*SYmSY2SYoSoq@W+rYt(Y*SYvSY2SYxSz@W+rY}(Y*SYSY2SYSz@W+rY(Y*SYSY2SYSz@W+2 *+7,f-./01B2l345  .9   #:*+-:0:*!Y#:Y-*Y::: : *::  : Y- :: *    YY ޶ : *    YY  eeb?ABC$D-E?HYJ\K_LbMeOnPwQRSTUVWXYZ ]###### /+-\_b e A A # -  V(,Z (BB  +b  .e  gY :!Y*#:$W&W*,(*-(*(,W*,.*-.*., 2W*,(*-(*(Fk lnp(r2s<tGvPxYybzl|p}yH 4567   y!01 j--8};*>+@W*Y>`>-8t; +BW-8;*>+@W*Y>`>2 ",:BPW_i*jj45j67jD &&*+ . +EW8&;+GW8F;+IW8F;+IW8N;+KW8k;+MW8W;+OW8];+QWh8c;+SWN8t;+UW48};+WW8; +YW#!),;CFU]`owz %-4..45.[\.67.D   ]^ 5*+_e*+iM*ekp*eqp tMvM,(,/3 55xy'z/ (({^ 5*+_e*+|M*ekp*eqp ~MM,(,/3 55xy'z/ (( 6/