Edit C:\Windows\install\galaxie_p02_26-09\WEB-INF\classes\com\edeal\frontline\helper\custom\CustomListInteractionsForActor.class
Êþº¾ 3} @com/edeal/frontline/helper/custom/CustomListInteractionsForActor ,com/edeal/frontline/grid/CustomListResultSet logger Lorg/apache/commons/logging/Log; nb I <clinit> ()V Code %org/apache/commons/logging/LogFactory getLog 3(Ljava/lang/Class;)Lorg/apache/commons/logging/Log; LineNumberTable LocalVariableTable <init> this BLcom/edeal/frontline/helper/custom/CustomListInteractionsForActor; getFieldMapping ()Ljava/util/HashMap; Signature ;()Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/String;>; " java/util/HashMap ! % IntID ! ' ( ) put 8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object; + IntActID - IntStiID / IntStiID:RefVal 1 IntAtvID 3 IntDate 5 IntCatID 7 IntCatID:Val 9 IntSubject ; IntDetails = IntType_ ? IntType_:Val A IntTheme_ C IntTheme_:Val E IntMedID G IntMedID:Val map Ljava/util/HashMap; LocalVariableTypeTable 9Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/String;>; getResultSet ¨(Ljavax/servlet/http/HttpSession;Lcom/edeal/frontline/FlContext;Lcom/edeal/frontline/navigation/FlRequest;Ljava/util/HashMap;[Ljava/lang/String;II)Ljava/util/ArrayList; Exceptions P &com/edeal/frontline/FrontlineException (Ljavax/servlet/http/HttpSession;Lcom/edeal/frontline/FlContext;Lcom/edeal/frontline/navigation/FlRequest;Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/Object;>;[Ljava/lang/String;II)Ljava/util/ArrayList<Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/Object;>;>; S U T com/edeal/frontline/FlContext V W getDataDictionary &()Lcom/edeal/frontline/DataDictionary; Y type ! [ \ ] get &(Ljava/lang/Object;)Ljava/lang/Object; _ java/lang/String a c b #org/apache/commons/lang/StringUtils d e isEmpty (Ljava/lang/String;)Z g COR i k j "com/edeal/frontline/DataDictionary l m getRefIdByCode 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; o java/lang/StringBuilder q cannot find Interaction type [ n s t (Ljava/lang/String;)V n v w x append -(Ljava/lang/String;)Ljava/lang/StringBuilder; z ]. No filter applied n | } ~ toString ()Ljava/lang/String; ? ? ? org/apache/commons/logging/Log ? ? error (Ljava/lang/Object;)V ? actor ? ? ? (com/edeal/frontline/navigation/FlRequest ? ? getSearchCriteria &(Ljava/lang/String;)Ljava/lang/String; ? IntCorID:CorEntID ? IntCorID:CorPerID ? IntDate$From ? IntDate$To n ? rSELECT distinct(IntID),IntID,IntStiID,IntAtvID,IntDate,IntCatID,IntSubject,IntDetails,IntType_,IntTheme_,IntMedID ? FROM MvaIntActID ? #JOIN Interaction ON MvaColID=IntID ? java/util/ArrayList ? MvaText= ¢ ¤ £ com/edeal/frontline/Utils ¥ ¦ formatToSQL E(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Ljava/lang/String; ? ¨ © ª add (Ljava/lang/Object;)Z ¬ IntStiID= ® IntAtvID= ° IntType_= ² IntTheme_= ´ IntMedID= ¶ IntCatID= ¸ IntDate >= ¢ º » ¼ formatDateFromWeb D(Ljavax/servlet/http/HttpSession;Ljava/lang/String;)Ljava/util/Date; ¢ ¾ ¥ ¿ C(Lcom/edeal/frontline/FlContext;Ljava/util/Date;)Ljava/lang/String; Á à  java/util/Calendar Ä Å getInstance ()Ljava/util/Calendar; Á Ç È É setTime (Ljava/util/Date;)V Á Ë Ì Í set (II)V Á Ï Ð Ñ getTime ()Ljava/util/Date; Ó IntDate <= Õ v(EXISTS (SELECT MvaColID FROM MvaIntCorID JOIN Correspondent ON MvaText = CorID WHERE MvaColID = IntID AND CorEntID = × )) Ù v(EXISTS (SELECT MvaColID FROM MvaIntCorID JOIN Correspondent ON MvaText = CorID WHERE MvaColID = IntID AND CorPerID = ? Û Ü Ý iterator ()Ljava/util/Iterator; ß á à java/util/Iterator â ã next ()Ljava/lang/Object; å WHERE ç AND ^ é ê ë valueOf &(Ljava/lang/Object;)Ljava/lang/String; ß í î ï hasNext ()Z ñ ORDER BY ó , ¢ õ ö ÷ implodeList 9([Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; ù CustomListInteraction sql query: n û w ü -(Ljava/lang/Object;)Ljava/lang/StringBuilder; ? þ ÿ ? info S getConnection ()Ljava/sql/Connection; java/sql/Connection createStatement ()Ljava/sql/Statement; java/sql/Statement executeQuery ((Ljava/lang/String;)Ljava/sql/ResultSet; #com/edeal/frontline/InteractionBean #(Ljavax/servlet/http/HttpSession;)V java/sql/ResultSet ? getString enforceAccess (ILjava/lang/String;)Z â ï i!"