3;com/edeal/frontline/kpi/methods/OpportunityNumberCalcMethod*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  LineNumberTableLocalVariableTablethis=Lcom/edeal/frontline/kpi/methods/OpportunityNumberCalcMethod;getSupportedAxes()Ljava/util/Collection; Signature=()Ljava/util/Collection;$java/util/LinkedList #'com/edeal/frontline/kpi/FobAxis)OppActID+java/lang/String -/.(com/edeal/frontline/kpi/AbstractCalcAxis 01 FRENCH_LOCALELjava/lang/String;3Commercial responsable -5 61ENGLISH_LOCALE8 Sales rep:Actor &< =:(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)V ?A@java/util/List BCadd(Ljava/lang/Object;)ZEcom/edeal/frontline/kpi/RefAxisGOppStuIDIStatutKStatus DM N((Ljava/lang/String;[Ljava/lang/String;)VPOppStoIDREtatTStateV com/edeal/frontline/kpi/TimeAxisXOppCrDtZDate de création\ Creation date ^`_'com/edeal/frontline/kpi/TimeGranularity abMONTH)Lcom/edeal/frontline/kpi/TimeGranularity; Ud ec(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Lcom/edeal/frontline/kpi/TimeGranularity;)VgOppDateiDate de signaturek Signing datem ActDeptIDoDépartement du commercialqSales Rep Depts DepartmentuActSitIDwSite du commercialySales Rep site{Site}EntOriIDOrigine du contactContact originEntActIDCommercial du compteAccount Sales repEntAtvIDActivité de l'entrepriseBusiness activity"com/edeal/frontline/kpi/StringAxisEntZipEntreprise-DepartementEnterprise-Department <  subStringFromStart'(Ljava/lang/String;I)Ljava/lang/String;axesLjava/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;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;]:  getMessage()Ljava/lang/String; toString *(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 ) *+ addAxisJoinc(Ljava/lang/StringBuilder;Lcom/edeal/frontline/kpi/JoinHelper;Lcom/edeal/frontline/kpi/ICalcAxis;)V - /WHERE OppDate IS NOT NULL 1 GROUP BY *3 45valueOf&(Ljava/lang/Object;)Ljava/lang/String; 798/com/edeal/frontline/kpi/methods/KPIMethodHelper :;getSQLlimitForKPImethod3(Lcom/edeal/frontline/FlContext;)Ljava/lang/String;qLjava/lang/StringBuilder;jh$Lcom/edeal/frontline/kpi/JoinHelper;Aaxis.getUserCode(): C D getUserCode F GHinfo(Ljava/lang/Object;)V J H L M printStackTraceO, Q *S TCequalsV AD.ActDeptIDX ASI.ActSitIDZ E.EntOriID\ E.EntActID^ E.EntAtvID`E.EntZipcommaaxisstrCommaaf h ij innerJoin&(Ljava/lang/String;)Ljava/lang/String;l INNER JOIN Actor n op getSqlHelper*()Lcom/edeal/frontline/kpi/impl/SqlHelper; r sasu AD ON OppActID=AD.actID w ASI ON OppActID=ASI.actID y INNER JOIN Enterprise { E ON OppEntID=E.entID getUnit2(Lcom/edeal/frontline/FlLocale;)Ljava/lang/String; com/edeal/frontline/FlLocale  getLocale()Ljava/util/Locale;  localeLjava/util/Locale;  |} java/util/Locale FRANCE S  FRENCHNombreNumberflLocaleLcom/edeal/frontline/FlLocale;resultgetDescription  }Comptage opportunitésOpportunities countingdispose getSignature=()Ljava/util/Collection; java/util/Collections  emptyList()Ljava/util/List;*(Ljava/lang/String;)Ljava/util/Collection;O(Ljava/lang/String;)Ljava/util/Collection; SourceFile OpportunityNumberCalcMethod.java!   F**Y*#%#  !"  #Y%L+&Y(*Y,SY2SY4SY7S9;>W+DYF*Y,SYHSY4SYJSL>W+DYO*Y,SYQSY4SYSSL>W+UYW*Y,SYYSY4SY[SW]c>W+UYf*Y,SYhSY4SYjSf]c>W+&Yl*Y,SYnSY4SYpSr;>W+&Yt*Y,SYvSY4SYxSz;>W+DY|*Y,SY~SY4SYSL>W+&Y*Y,SYSY4SYS9;>W+DY*Y,SYSY4SYSL>W+Y*Y,SYSY4SYS>W+Y**Y,SYSY4SYS>W+:+-4.^/0123>4h5678:  !  :*+-:::*YY¶ɿ::: : *::  : Y- :: *    YY  ɿ: *    YY  ɿUUZ?BCD!EIHLIOJRKUM^NgOrPQRSTUVWX]15LOR U  A  A V*6@ *BB! *Y:Y*: W*,"*-"*"&W*,(*-(*(*, .W, 0W*,"*-"*":Y2*6ưRbdfi$k.l8mCoLqUr^shwoxx{||R<=>?1  x $% yB*Y@BƹE:*IKN:P:B(R#(:+Y2ƶWBFR#F:+Y2ƶWBOR#O:+Y2ƶWkBWR+Y2WƶW@BfR$*,+Y2fƶWBlR +Y2UƶWBtR +Y2WƶWB|R +Y2YƶWBR +Y2[ƶW`BR +Y2]ƶW4BR%+Y2*_ƶW&)$&+9>CGL[_x1C]o Af BB<=Ba B>?Bb+Cc1_d1d1d1b *...*/+++++0*+ --B(R+e,(gW-BFR+e,FgW-BOR+e,OgW-BlR(+Yk,mqtƶWT-BtR(+Yk,mqvƶW!-B|RJ*%+Yx,mqzƶW*Y`+e,|gW-BR9*%+Yx,mqzƶW*Y`-BR9*%+Yx,mqzƶW*Y`D-BR6*%+Yx,mqzƶW*Y`*$5FWhy#4;PY]gx*<=>?b!!!2266 6 6 |} 5*+~*+M** MM,(,/3 55'1 (*} 5*+~*+M** MM,(,/3 55'1 (*  +  ! . ! 8 1