Edit C:\Users\Administrator\Desktop\Back\Livraison EVQG22\com\edeal\frontline\kpi\methods\OpportunityCustomNumberCalcMethod.class
Êþº¾ 3y Acom/edeal/frontline/kpi/methods/OpportunityCustomNumberCalcMethod *com/edeal/frontline/kpi/AbstractCalcMethod sqlHlpr (Lcom/edeal/frontline/kpi/impl/SqlHelper; entJoinCount I oppDateInUse Z <init> ()V Code &com/edeal/frontline/kpi/impl/SqlHelper ctx Lcom/edeal/frontline/FlContext; "(Lcom/edeal/frontline/FlContext;)V LineNumberTable LocalVariableTable this CLcom/edeal/frontline/kpi/methods/OpportunityCustomNumberCalcMethod; getSupportedAxes ()Ljava/util/Collection; Signature =()Ljava/util/Collection<Lcom/edeal/frontline/kpi/ICalcAxis;>; $ java/util/LinkedList # ' com/edeal/frontline/kpi/RefAxis ) OppStoID + java/lang/String - / . (com/edeal/frontline/kpi/AbstractCalcAxis 0 1 FRENCH_LOCALE Ljava/lang/String; 3 Statut - 5 6 1 ENGLISH_LOCALE 8 Status & : ; ((Ljava/lang/String;[Ljava/lang/String;)V = ? > java/util/List @ A add (Ljava/lang/Object;)Z C com/edeal/frontline/kpi/TimeAxis E OppDatComm_ G Date de commande I Order date K OppDate M O N 'com/edeal/frontline/kpi/TimeGranularity P Q WEEK )Lcom/edeal/frontline/kpi/TimeGranularity; B S T c(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Lcom/edeal/frontline/kpi/TimeGranularity;)V V com/edeal/frontline/kpi/FobAxis X ProPrdID Z Produit \ Product U ^ _ :(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)V a OppBizProviderID c Tiers Fournisseur e Provider g Enterprise i OppEntID k Tiers Hôtelier 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 t &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; w x y 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; ? ]: 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/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 count(*) ô õ ö addAxisField d(Ljava/lang/StringBuilder;ZLcom/edeal/frontline/kpi/JoinHelper;Lcom/edeal/frontline/kpi/ICalcAxis;)V ø FROM Opportunity ú î ü ý þ innerJoin &(Ljava/lang/String;)Ljava/lang/String; addAxisJoin c(Ljava/lang/StringBuilder;Lcom/edeal/frontline/kpi/JoinHelper;Lcom/edeal/frontline/kpi/ICalcAxis;)V WHERE RefVal î field 8(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 getSQLlimitForKPImethod 3(Lcom/edeal/frontline/FlContext;)Ljava/lang/String; q Ljava/lang/StringBuilder; jh $Lcom/edeal/frontline/kpi/JoinHelper;" axis.getUserCode(): æ$ % ? getUserCode ?' () info (Ljava/lang/Object;)V ?+ ?) Æ- . printStackTrace0 , 2 *4 5 A equals7 PO.ProPrdID comma axis strComma a= INNER JOIN ProductOpportunity î? @A getSqlHelper *()Lcom/edeal/frontline/kpi/impl/SqlHelper; C D ? asF PO ON OppID=PO.ProOppID getUnit 2(Lcom/edeal/frontline/FlLocale;)Ljava/lang/String; JLK com/edeal/frontline/FlLocale MN getLocale ()Ljava/util/Locale; P QR locale Ljava/util/Locale; T GH VXW java/util/Locale YR FRANCE V4 V\ ]R FRENCH_ Nombre de commandesa number of orders flLocale Lcom/edeal/frontline/FlLocale; result getDescription g eHi Comptage commandesk Orders counting dispose getSignature =()Ljava/util/Collection<Lcom/edeal/frontline/kpi/CalcParam;>; prq java/util/Collections st emptyList ()Ljava/util/List; *(Ljava/lang/String;)Ljava/util/Collection; O(Ljava/lang/String;)Ljava/util/Collection<Lcom/edeal/frontline/kpi/CalcParam;>; SourceFile &OpportunityCustomNumberCalcMethod.java ! F *· *» Y*´ · µ ± # % # ! " E ç» #Y· %L+» &Y(½ *Y² ,SY2SY² 4SY7S· 9¹ < W+» BYD½ *Y² ,SYFSY² 4SYHSJ² L· R¹ < W+» UYW½ *Y² ,SYYSY² 4SY[S[· ]¹ < W+» UY`½ *Y² ,SYbSY² 4SYdSf· ]¹ < W+» UYh½ *Y² ,SYjSY² 4SYfSf· ]¹ < W+° + - 2 . a / ? 0 ¹ 1 å 2 ç ß l m n ß l o p q r s ! u ? :*+-· v:§ ::*´ z~¹ ? » sY» ?Y?· ?¶ ??¶ ?¶ ?¶ ?¶ ?· ?¿::: : *´ ¶ ?:¹ £ : ¹ © : » ¯Y-² ± · ·:§ ?: *´ z ¶ º ¹ ? ¸ ½» sY» ?Y÷ ?¶ ??¶ ? ¶ º¶ ?¶ ? · ?¿: *´ z ¶ Å ¹ ? ¸ ½» sY» ?YÈ· ?¶ ??¶ ? ¶ Ŷ ?¶ ? · ?¿° s U ? ? » U ? Í Æ Z 7 : ; < ! = I @ L A O B R C U E ^ F g G r H ? I ? J ? K ¥ L Í M Ï N ß O è P U ? Ê Ë Ì Í Î Ï Ð Ï Ñ Ï Ò 1 5 Ó Ô L Ç Õ Ö O Ä × Ø R Á Ù Ú U ¾ Û Ü ? A Ý Þ Ï A Ó ß n Ê à á V ÿ â ä æ æ æ * s6ÿ @ â ä æ æ æ * ¯ ¤ ª è »÷ B Æû B x y r s ! ê à ô*µ ë» ?Y· í:» îY*´ · ð:ñ¶ ?W*,· ó*-· ó*· ó÷¶ ?Wù¶ ?(¶ û¶ ?W*,· ÿ*-· ÿ*· ÿ¶ ?W(¶¶ ? ¶ ?W*´ ? ¶ ?W,Æ ¶ ?W*,· ó*-· ó*· ó¶ ?:» ?Y¸· ?*´ ¸¶ ?¶ ?° ^ Z \ ] _ # a - b 7 c B e J f \ g e h n i x k ? l ? m ? n § q « r ´ u ¾ v È w Ó y Ú z R ô ô Ê Ë ô Î Ï ô Ð Ï ô Ñ Ï æ Ù Ú Ò 1 n ô Ê à á ý § ? î õ ö r s +Ç ±*´ z» ?Y!· ?¹# ¶ ?¶ ?¹& § :*´ z¶ Ź* ¶,/: ? 1:¹# (¶3? #(:+» ?Y¸· ?¶ ?¶ ?¶ ?W§ ²¹# `¶3? +» ?Y¸· ?`¶ ?¶ ?¶ ?W§ ?¹# h¶3? +» ?Y¸· ?h¶ ?¶ ?¶ ?W§ \¹# D¶3? $*µ +» ?Y¸· ?D¶ ?¶ ?¶ ?W§ ,¹# W¶3? +» ?Y¸· ?6¶ ?¶ ?¶ ?W± & ) Æ Z ? ? & ? + ? 9 ? > ? C ? G ? L ? [ ? _ ? x ? ? ? £ ? µ ? Î ? à ? å ? þ ? ?* ? R + + +8 + +9 Ï + Ó ß C è: 1 _ ; 1 á b Æü *.**/( r s ô x-Ç ±-¹# `¶3? +ù¶ ?,`¶ û¶ ?W§ T-¹# h¶3? +ù¶ ?,h¶ û¶ ?W§ 3-¹# W¶3? %+» ?Y<· ?,¶>¶B¶ ?E¶ ?¶ ?¶ ?W± . ? ? ¢ £ # ¤ 4 ¥ D ¦ U § j ¨ s § w ª * x x x x9 Ï á / GH ? 5*+¶IµO*+·SM*´O²U¶Z? *´O²[¶Z? ^M§ `M,° ® ¯ ± ( ² , ³ / ´ 3 · 5 5bc 'd 1 á ü ( * eH ? 5*+¶IµO*+·fM*´O²U¶Z? *´O²[¶Z? hM§ jM,° ¼ ½ ¿ ( À , Á /  3 Å 5 5bc 'd 1 á ü ( * l + ± É m ! n . ¸o° Ì mu ! v 8 ¸o° Ñ Q 1 w x
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de