Edit C:\Users\Administrator\Desktop\galaxie\WEB-INF\classes\com\edeal\frontline\helper\custom\CustomListCorrespondancesForPerson.class
Êþº¾ 3? Dcom/edeal/frontline/helper/custom/CustomListCorrespondancesForPerson ,com/edeal/frontline/grid/CustomListResultSet logger Lorg/apache/commons/logging/Log; nb I ConstantValue <clinit> ()V Code 8com/edeal/frontline/helper/custom/CustomListInteractions %org/apache/commons/logging/LogFactory getLog 3(Ljava/lang/Class;)Lorg/apache/commons/logging/Log; LineNumberTable LocalVariableTable <init> this FLcom/edeal/frontline/helper/custom/CustomListCorrespondancesForPerson; 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 1 IntStiID 3 IntStiID:Val 5 IntAtvID 7 IntDate 9 IntTimeBeg ; IntTimeEnd = IntCatID ? IntCatID:Val A IntSubject C IntTheme_ E IntTheme_:Val G IntMedID I IntMedID:Val K IntDetails M EntCorpName O PerFctID 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 X &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;>;>; [ ] \ com/edeal/frontline/FlContext ^ _ getDataDictionary &()Lcom/edeal/frontline/DataDictionary; a consolidated % c d e get &(Ljava/lang/Object;)Ljava/lang/Object; g java/lang/String i k java/lang/StringBuilder m WHERE IntType_=' j o p (Ljava/lang/String;)V r IntType_ t COR v x w "com/edeal/frontline/DataDictionary y z getRefIdByCode 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; j | } ~ append -(Ljava/lang/String;)Ljava/lang/StringBuilder; ? ' j ? ? ? toString ()Ljava/lang/String; ? ? ? java/lang/Boolean ? ? valueOf (Z)Ljava/lang/Boolean; ? ? ? #org/apache/commons/lang/StringUtils ? ? isEmpty (Ljava/lang/String;)Z ? AND PerFctParentID= ? PerFctParentID ? ? ? (com/edeal/frontline/navigation/FlRequest ? ? getSearchCriteria &(Ljava/lang/String;)Ljava/lang/String; ? ? ? com/edeal/frontline/Utils ? formatToSQL E(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Ljava/lang/String; f ¢ ? £ &(Ljava/lang/Object;)Ljava/lang/String; ¥ AND PerFctIsActive = § © ¨ java/lang/Integer ? ª (I)Ljava/lang/Integer; ? ¬ ? E(Lcom/edeal/frontline/FlContext;Ljava/lang/Number;)Ljava/lang/String; ¯ corfield ± CorEntID v ³ ´ µ getFieldByName 3(Ljava/lang/String;)Lcom/edeal/frontline/FieldBean; · ¹ ¸ com/edeal/frontline/FieldBean º ? getFldSql ¼ id · ¾ ¿ ? getFldFobID v Á  à getTable G(Ljava/lang/String;Ljava/lang/String;)Lcom/edeal/frontline/ObjectsBean; Å Ç Æ com/edeal/frontline/ObjectsBean È ? getObjRadical Ê ID Ì EntID f Î Ï Ð equals (Ljava/lang/Object;)Z Ò AND ( Ô = Ö OR IntTiersConc_= Ø IntTiersConc_ Ú ) Ü AND j ß SELECT distinct(IntID),IntID,IntStiID,IntAtvID,IntDate,IntTimeBeg,IntTimeEnd,IntCatID,IntSubject,IntMedID,IntTheme_,IntDetails ? á â ã booleanValue ()Z å ,EntCorpName,PerFctID ç FROM MvaIntCorID é #JOIN Interaction ON MvaColID=IntID ë $JOIN Correspondent ON CorID=MvaText í JOIN Person ON PerID=CorPerID ï "JOIN Enterprise ON EntID=PerEntID ñ ORDER BY ó , ? õ ö ÷ implodeList 9([Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; ù CustomListInteraction sql query: j û } ü -(Ljava/lang/Object;)Ljava/lang/StringBuilder; þ ÿ org/apache/commons/logging/Log info (Ljava/lang/Object;)V java/util/ArrayList [ getConnection ()Ljava/sql/Connection; java/sql/Connection createStatement ()Ljava/sql/Statement; java/sql/Statement setFetchSize (I)V 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 )* ã next ?,-. getSession "()Ljavax/servlet/http/HttpSession;0 Sti2 Te1 v456 getRefDisp j(Ljavax/servlet/http/HttpSession;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object; 89: getDate #(Ljava/lang/String;)Ljava/sql/Date; <=> getTime #(Ljava/lang/String;)Ljava/sql/Time; v@5A X(Ljavax/servlet/http/HttpSession;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object; vC5D 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object; FG Ð addI SQL Exception þKLM error *(Ljava/lang/Object;Ljava/lang/Throwable;)V OP closeOOT Frontline ExceptionV java/sql/SQLException session Ljavax/servlet/http/HttpSession; context Lcom/edeal/frontline/FlContext; flRequest *Lcom/edeal/frontline/navigation/FlRequest; parameters orderby [Ljava/lang/String; beginIndex nbEntry dico $Lcom/edeal/frontline/DataDictionary; Ljava/lang/String; queryWhere isConsolidated Ljava/lang/Boolean; corFieldName corFld Lcom/edeal/frontline/FieldBean; corFobField corFobRadID sqlQuery Ljava/lang/StringBuilder; res Ljava/util/ArrayList; con Ljava/sql/Connection; stmt Ljava/sql/Statement; rs Ljava/sql/ResultSet; fCanRead Z j emptyInt %Lcom/edeal/frontline/InteractionBean; intID count sqle Ljava/sql/SQLException; fe (Lcom/edeal/frontline/FrontlineException; 9Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/Object;>; PLjava/util/ArrayList<Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/Object;>;>; StackMapTable? javax/servlet/http/HttpSession_? java/lang/Throwable getNumberOfResults ()I SourceFile 'CustomListCorrespondancesForPerson.java ! ) ¸ ³ ± <