3aAcom/edeal/frontline/kpi/methods/OpportunityCustomNumberCalcMethod*com/edeal/frontline/kpi/AbstractCalcMethodsqlHlpr(Lcom/edeal/frontline/kpi/impl/SqlHelper; entJoinCountI oppDateInUseZ()VCode  &com/edeal/frontline/kpi/impl/SqlHelper  ctxLcom/edeal/frontline/FlContext;  "(Lcom/edeal/frontline/FlContext;)V  LineNumberTableLocalVariableTablethisCLcom/edeal/frontline/kpi/methods/OpportunityCustomNumberCalcMethod;getSupportedAxes()Ljava/util/Collection; Signature=()Ljava/util/Collection;$java/util/LinkedList #'com/edeal/frontline/kpi/RefAxis)OppStoID+java/lang/String -/.(com/edeal/frontline/kpi/AbstractCalcAxis 01 FRENCH_LOCALELjava/lang/String;3Statut -5 61ENGLISH_LOCALE8Status &: ;((Ljava/lang/String;[Ljava/lang/String;)V =?>java/util/List @Aadd(Ljava/lang/Object;)ZC com/edeal/frontline/kpi/TimeAxisE OppDatComm_GDate de commandeI Order dateKOppDate MON'com/edeal/frontline/kpi/TimeGranularity PQWEEK)Lcom/edeal/frontline/kpi/TimeGranularity; BS Tc(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Lcom/edeal/frontline/kpi/TimeGranularity;)VVcom/edeal/frontline/kpi/FobAxisXProPrdIDZProduit\Product U^ _:(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)VaOppBizProviderIDcTiers FournisseureProviderg EnterpriseiOppEntIDkTiers HôtelieraxesLjava/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; Exceptionst&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; w xy 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;cannot get the query org/apache/commons/logging/Log error*(Ljava/lang/Object;Ljava/lang/Throwable;)Vjava/lang/StringBuilderSQL Error in performing query [ (Ljava/lang/String;)V append-(Ljava/lang/String;)Ljava/lang/StringBuilder;]: s  getMessage()Ljava/lang/String; toString s *(Ljava/lang/String;Ljava/lang/Throwable;)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 !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/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 [ java/lang/ExceptionException in performing query [paramsLjava/util/Map;calLjava/util/Calendar;axis1#Lcom/edeal/frontline/kpi/ICalcAxis;axis2axis3querye(Lcom/edeal/frontline/FrontlineException;dataSet#Lcom/edeal/frontline/kpi/DBDataSet;conLjava/sql/Connection;stLjava/sql/Statement;rsLjava/sql/ResultSet;sqleLjava/sql/SQLException;Ljava/lang/Exception;FLjava/util/Map; StackMapTable java/util/Mapjava/util/Calendar!com/edeal/frontline/kpi/ICalcAxisjava/sql/ResultSet(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 count(*)   addAxisFieldd(Ljava/lang/StringBuilder;ZLcom/edeal/frontline/kpi/JoinHelper;Lcom/edeal/frontline/kpi/ICalcAxis;)V FROM Opportunity  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; ='ORD'   AND OppDatComm_ IS NOT NULL  GROUP BY qLjava/lang/StringBuilder;jh$Lcom/edeal/frontline/kpi/JoinHelper;,   getUserCode * Aequals  PO.ProPrdIDcommaaxisa% INNER JOIN ProductOpportunity ' () getSqlHelper*()Lcom/edeal/frontline/kpi/impl/SqlHelper; + ,as. PO ON OppID=PO.ProOppID getUnit2(Lcom/edeal/frontline/FlLocale;)Ljava/lang/String; 243com/edeal/frontline/FlLocale 56 getLocale()Ljava/util/Locale; 8 9:localeLjava/util/Locale; < /0 >@?java/util/Locale A:FRANCE > >D E:FRENCHGNombre de commandesInumber of ordersflLocaleLcom/edeal/frontline/FlLocale;resultgetDescription O M0QComptage commandesSOrders countingdispose getSignature=()Ljava/util/Collection; XZYjava/util/Collections [\ emptyList()Ljava/util/List;*(Ljava/lang/String;)Ljava/util/Collection;O(Ljava/lang/String;)Ljava/util/Collection; SourceFile&OpportunityCustomNumberCalcMethod.java!   F**Y*#%#  !" E#Y%L+&Y(*Y,SY2SY4SY7S9<W+BYD*Y,SYFSY4SYHSJLR<W+UYW*Y,SYYSY4SY[S[]<W+UY`*Y,SYbSY4SYdSf]<W+UYh*Y,SYjSY4SYfSf]<W++-2.a/012lmn lopqrs!u  :*+-v:::*z~sYY::: : *::  : Y- :: *z    sYY÷  : *z    sYYȷ Ŷ sUUZ7:;<!=I@LAOBRCUE^FgGrHIJKLMNOPU15LOR U A A n V*s6@ *BBxyrs! *Y:Y*:W*,*-*W(W*,*-*W( W* W, W*,*-*:^Z\]_#a-b7cBeJf\gehnixklmnqruvwyzR1n   rs B +W((:+Wj` +`WQh +hW8D* +DWW +WF !%,>EW^pu|>! "%#1  rs x--`+,`WT-h+,hW3-W%+Y$,&*-W. #4DUjsw*xxxx" //0 5*+17*+;M*7=B*7CB FMHM,(,/3 55JK'L1 (*M0 5*+17*+NM*7=B*7CB PMRM,(,/3 55JK'L1 (*T  + U !V .W U]!^ 8W91_`