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 qLjava/lang/StringBuilder;jh$Lcom/edeal/frontline/kpi/JoinHelper;7, 9 : getUserCode *< =Cequals? AD.ActDeptIDA ASI.ActSitIDC E.EntOriIDE E.EntActIDG E.EntAtvIDIE.EntZipcommaaxisaN P QR innerJoin&(Ljava/lang/String;)Ljava/lang/String;T INNER JOIN Actor V WX getSqlHelper*()Lcom/edeal/frontline/kpi/impl/SqlHelper; Z [as] AD ON OppActID=AD.actID _ ASI ON OppActID=ASI.actID a INNER JOIN Enterprise c E ON OppEntID=E.entID getUnit2(Lcom/edeal/frontline/FlLocale;)Ljava/lang/String; gihcom/edeal/frontline/FlLocale jk getLocale()Ljava/util/Locale; m nolocaleLjava/util/Locale; q de sutjava/util/Locale voFRANCE s< sy zoFRENCH|Nombre~NumberflLocaleLcom/edeal/frontline/FlLocale;resultgetDescription  eComptage 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*,"*-"*":Rbdfi$k.l8mCoLqUr^shwoxx{||R23451  x $% ?B +6W8(;(:+W8F;F:+W8O;O:+W8W; +WW8f;*,+fW8l;+>W8t;+@Wp8|;+BWV8;+DW<8;+FW"8;+*HW~ !%,>BI[_fx1ARBB23BJ B45BK%L1BL1_L1  *+ --8(;+M,(OW-8F;+M,FOW-8O;+M,OOW-8l;(+YS,UY\ƶWT-8t;(+YS,UY^ƶW!-8|;J*%+Y`,UYbƶW*Y`+M,|OW-8;9*%+Y`,UYbƶW*Y`-8;9*%+Y`,UYbƶW*Y`D-8;6*%+Y`,UYbƶW*Y`*$5FWhy#4;PY]gx*2345K!!!2266 6 6 de 5*+fl*+pM*lrw*lxw {M}M,(,/3 55'1 (*e 5*+fl*+M*lrw*lxw MM,(,/3 55'1 (*  +  ! . ! 8n1