Edit C:\Users\Administrator\Desktop\Back\Livraison EVQG22\com\edeal\frontline\kpi\filters\WebOperationRegroupmentFilter.class
Êþº¾ 3 ? =com/edeal/frontline/kpi/filters/WebOperationRegroupmentFilter %com/edeal/frontline/kpi/DynamicFilter <init> ()V Code LineNumberTable LocalVariableTable this ?Lcom/edeal/frontline/kpi/filters/WebOperationRegroupmentFilter; getWhereConditions ?(Ljavax/servlet/http/HttpServletRequest;Lcom/edeal/frontline/FlContext;ILcom/edeal/frontline/kpi/ICalcAxis;Ljava/lang/String;)Ljava/lang/String; id %javax/servlet/http/HttpServletRequest getParameter &(Ljava/lang/String;)Ljava/lang/String; com/edeal/frontline/FlContext getDataDictionary &()Lcom/edeal/frontline/DataDictionary; ! Ses # Te1 % FINAL ' ) ( "com/edeal/frontline/DataDictionary * + getRefIdByCode J(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; - 3SELECT DISTINCT WopRegroupement FROM EmailingStats / java/lang/StringBuilder 1 3 2 java/lang/String 4 5 valueOf &(Ljava/lang/Object;)Ljava/lang/String; . 7 8 (Ljava/lang/String;)V : 1 LEFT OUTER JOIN MassEmailing ON EmlID = EstEmlID . < = > append -(Ljava/lang/String;)Ljava/lang/StringBuilder; . @ A B toString ()Ljava/lang/String; D . LEFT OUTER JOIN EMailLink ON ElnID = EstElnID F 1 LEFT OUTER JOIN WebOperation ON WopID = ElnWopID H WHERE EstEmlStatus = J L K com/edeal/frontline/Utils M N formatToSQL E(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Ljava/lang/String; P AND WopRegroupement IS NOT NULL R AND EstEmlID = T AND V IN ( X ) Z [ \ logger Lorg/apache/commons/logging/Log; ^ No emailingID in request ` b a org/apache/commons/logging/Log c d warn (Ljava/lang/Object;)V f &com/edeal/frontline/FrontlineException s 'Ljavax/servlet/http/HttpServletRequest; ctx Lcom/edeal/frontline/FlContext; axisNumber I axis #Lcom/edeal/frontline/kpi/ICalcAxis; field Ljava/lang/String; ret dico $Lcom/edeal/frontline/DataDictionary; finalStatusID query StackMapTable x !com/edeal/frontline/kpi/ICalcAxis canFilter &(Lcom/edeal/frontline/kpi/ICalcAxis;)Z | WopRegroupement w ~ B getUserCode 1 ? ? ? equals (Ljava/lang/Object;)Z SourceFile "WebOperationRegroupmentFilter.java ! / *· ± ä ì:+¹ Æ Ò,¶ :: "$¶ &:§ : ,: » .Y ¸ 0· 69¶ ;¶ ?: » .Y ¸ 0· 6C¶ ;¶ ?: » .Y ¸ 0· 6E¶ ;¶ ?: » .Y ¸ 0· 6G¶ ;,¸ I¶ ;O¶ ;¶ ?: » .Y ¸ 0· 6Q¶ ;,+¹ ¸ I¶ ;¶ ?: » .YS· 6¶ ;U¶ ; ¶ ;W¶ ;¶ ?:§ *´ Y]¹ _ ° % ( e B % * . D Z p ? ¹ Û Þ é "