3yAcom/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 * valueOf&(Ljava/lang/Object;)Ljava/lang/String; /com/edeal/frontline/kpi/methods/KPIMethodHelper getSQLlimitForKPImethod3(Lcom/edeal/frontline/FlContext;)Ljava/lang/String;qLjava/lang/StringBuilder;jh$Lcom/edeal/frontline/kpi/JoinHelper;"axis.getUserCode(): $ % getUserCode ' ()info(Ljava/lang/Object;)V + ) - . printStackTrace0, 2 *4 5Aequals7 PO.ProPrdIDcommaaxisstrCommaa= INNER JOIN ProductOpportunity ? @A getSqlHelper*()Lcom/edeal/frontline/kpi/impl/SqlHelper; C DasF PO ON OppID=PO.ProOppID getUnit2(Lcom/edeal/frontline/FlLocale;)Ljava/lang/String; JLKcom/edeal/frontline/FlLocale MN getLocale()Ljava/util/Locale; P QRlocaleLjava/util/Locale; T GH VXWjava/util/Locale YRFRANCE V4 V\ ]RFRENCH_Nombre de commandesanumber of ordersflLocaleLcom/edeal/frontline/FlLocale;resultgetDescription g eHiComptage commandeskOrders countingdispose getSignature=()Ljava/util/Collection; prqjava/util/Collections st 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*,*-*:Y*^Z\]_#a-b7cBeJf\gehnixklmnqruvwyzR 1n   rs +*zY!#&:*zŹ*,/:1:#(3#(:+YW#`3+Y`W#h3+YhW\#D3$* +YDW,#W3+Y6W&)Z&+9>CGL[_x*R+++8 + +9+C:1_;1 b *.**/(rs x--#`3+,`WT-#h3+,hW3-#W3%+Y<,>BEW. #4DUjsw*xxx x9 /GH 5*+IO*+SM*OUZ*O[Z ^M`M,(,/3 55bc'd1 (*eH 5*+IO*+fM*OUZ*O[Z hMjM,(,/3 55bc'd1 (*l  + m !n .o mu!v 8oQ1wx