Edit C:\Users\Administrator\Desktop\Back\Livraison EVQG22\com\edeal\frontline\kpi\methods\ProductOpportunityAmountCalcMethod.class
Êþº¾ 3ª Bcom/edeal/frontline/kpi/methods/ProductOpportunityAmountCalcMethod *com/edeal/frontline/kpi/AbstractCalcMethod sqlHlpr (Lcom/edeal/frontline/kpi/impl/SqlHelper; entJoinCount I <init> ()V Code &com/edeal/frontline/kpi/impl/SqlHelper ctx Lcom/edeal/frontline/FlContext; "(Lcom/edeal/frontline/FlContext;)V LineNumberTable LocalVariableTable this DLcom/edeal/frontline/kpi/methods/ProductOpportunityAmountCalcMethod; getSupportedAxes ()Ljava/util/Collection; Signature =()Ljava/util/Collection<Lcom/edeal/frontline/kpi/ICalcAxis;>; " java/util/LinkedList ! % com/edeal/frontline/kpi/FobAxis ' PrdFamilyID ) java/lang/String + - , (com/edeal/frontline/kpi/AbstractCalcAxis . / FRENCH_LOCALE Ljava/lang/String; 1 Famille de produit + 3 4 / ENGLISH_LOCALE 6 Product family 8 ProductFamily $ : ; :(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)V = ? > java/util/List @ A add (Ljava/lang/Object;)Z C OppActID E Commercial responsable G Sales rep I Actor K com/edeal/frontline/kpi/RefAxis M OppStuID O Statut Q Status J S T ((Ljava/lang/String;[Ljava/lang/String;)V V OppStoID X Etat Z State \ com/edeal/frontline/kpi/TimeAxis ^ OppCrDt ` Date de création b Creation date d f e 'com/edeal/frontline/kpi/TimeGranularity g h DAY )Lcom/edeal/frontline/kpi/TimeGranularity; [ j k c(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Lcom/edeal/frontline/kpi/TimeGranularity;)V m OppDate o Date de signature q Signing date s ActDeptID u Département du commercial w Sales Rep Dept y Department { ActSitID } Site du commercial Sales Rep site ? Site ? EntOriID ? Origine du contact ? Contact origin ? EntActID ? Commercial du compte ? Account Sales rep ? EntAtvID ? Activité de l'entreprise ? Business activity ? "com/edeal/frontline/kpi/StringAxis ? EntZip ? Entreprise-Departement ? Enterprise-Department ? : ? ? subStringFromStart '(Ljava/lang/String;I)Ljava/lang/String; axes Ljava/util/List; LocalVariableTypeTable 5Ljava/util/List<Lcom/edeal/frontline/kpi/ICalcAxis;>; 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<Lcom/edeal/frontline/kpi/CalcParam;Ljava/lang/String;>;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;)V ¼ java/lang/StringBuilder ¾ SQL 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/Exception þ Exception in performing query [ params Ljava/util/Map; cal Ljava/util/Calendar; axis1 #Lcom/edeal/frontline/kpi/ICalcAxis; axis2 axis3 query e (Lcom/edeal/frontline/FrontlineException; dataSet #Lcom/edeal/frontline/kpi/DBDataSet; con Ljava/sql/Connection; st Ljava/sql/Statement; rs Ljava/sql/ResultSet; sqle Ljava/sql/SQLException; Ljava/lang/Exception; FLjava/util/Map<Lcom/edeal/frontline/kpi/CalcParam;Ljava/lang/String;>; StackMapTable java/util/Map java/util/Calendar !com/edeal/frontline/kpi/ICalcAxis java/sql/ResultSet Ã(Ljava/util/Map<Lcom/edeal/frontline/kpi/CalcParam;Ljava/lang/String;>;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;)Ljava/lang/String; ! » $ "com/edeal/frontline/kpi/JoinHelper # ' SELECT proprice )*+ addAxisField d(Ljava/lang/StringBuilder;ZLcom/edeal/frontline/kpi/JoinHelper;Lcom/edeal/frontline/kpi/ICalcAxis;)V- FROM productopportunity / * INNER JOIN opportunity ON prooppid=oppid 123 addAxisJoin c(Ljava/lang/StringBuilder;Lcom/edeal/frontline/kpi/JoinHelper;Lcom/edeal/frontline/kpi/ICalcAxis;)V (567 valueOf &(Ljava/lang/Object;)Ljava/lang/String; 9;: /com/edeal/frontline/kpi/methods/KPIMethodHelper<= getSQLlimitForKPImethod 3(Lcom/edeal/frontline/FlContext;)Ljava/lang/String; q Ljava/lang/StringBuilder; jh $Lcom/edeal/frontline/kpi/JoinHelper;C axis.getUserCode():EF Ë getUserCode ¶HIJ info (Ljava/lang/Object;)V ¶L ¹J ûNO printStackTraceQ , S (UV A equalsX P.PrdFamilyIDZ AD.ActDeptID\ ASI.ActSitID^ E.EntOriID` E.EntActIDb E.EntAtvIDd E.EntZip comma Z axis strComma ak - INNER JOIN Product as P ON proprdid=P.prdid m #opq innerJoin &(Ljava/lang/String;)Ljava/lang/String;s - INNER JOIN Actor as AD ON OppActID=AD.actID u / INNER JOIN Actor as ASI ON OppActID=ASI.actID w 0 INNER JOIN Enterprise as E ON OppEntID=E.entID getUnit 2(Lcom/edeal/frontline/FlLocale;)Ljava/lang/String; {}| com/edeal/frontline/FlLocale~ getLocale ()Ljava/util/Locale; ??? locale Ljava/util/Locale; ?xy ??? java/util/Locale?? FRANCE ?U ???? FRENCH? Montant (ââ??¬)? Amount (ââ??¬) flLocale Lcom/edeal/frontline/FlLocale; result getDescription ??y? )Montants des opportunitÃ?©s par produits? Opportunity amounts by product dispose getSignature =()Ljava/util/Collection<Lcom/edeal/frontline/kpi/CalcParam;>; ¡£¢ java/util/Collections¤¥ emptyList ()Ljava/util/List; *(Ljava/lang/String;)Ljava/util/Collection; O(Ljava/lang/String;)Ljava/util/Collection<Lcom/edeal/frontline/kpi/CalcParam;>; SourceFile 'ProductOpportunityAmountCalcMethod.java ! F *· *» Y*´ · µ ± ! # ! Ê L» !Y· #L+» $Y&½ (Y² *SY0SY² 2SY5S7· 9¹ < W+» $YB½ (Y² *SYDSY² 2SYFSH· 9¹ < W+» JYL½ (Y² *SYNSY² 2SYPS· R¹ < W+» JYU½ (Y² *SYWSY² 2SYYS· R¹ < W+» [Y]½ (Y² *SY_SY² 2SYaS]² c· i¹ < W+» [Yl½ (Y² *SYnSY² 2SYpSl² c· i¹ < W+» $Yr½ (Y² *SYtSY² 2SYvSx· 9¹ < W+» $Yz½ (Y² *SY|SY² 2SY~S?· 9¹ < W+» JY?½ (Y² *SY?SY² 2SY?S· R¹ < W+» $Y?½ (Y² *SY?SY² 2SY?SH· 9¹ < W+» JY?½ (Y² *SY?SY² 2SY?S· R¹ < W+» ?Y?½ (Y² *SY?SY² 2SY?S?· ?¹ < W+» ?Y*´ ?¶ ?½ (Y² *SY?SY² 2SY?S?· ?¹ < W+° >