Edit C:\Windows\install\galaxie_p02_26-09\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 ? IntSubject A IntTheme_ C IntTheme_:Val E IntMedID G IntMedID:Val I IntDetails K EntCorpName M 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 V &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;>;>; Y [ Z com/edeal/frontline/FlContext \ ] getDataDictionary &()Lcom/edeal/frontline/DataDictionary; _ consolidated % a b c get &(Ljava/lang/Object;)Ljava/lang/Object; e java/lang/String g i java/lang/StringBuilder k WHERE IntType_=' h m n (Ljava/lang/String;)V p IntType_ r COR t v u "com/edeal/frontline/DataDictionary w x getRefIdByCode 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; h z { | append -(Ljava/lang/String;)Ljava/lang/StringBuilder; ~ ' h ? ? ? 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; d ? ¡ &(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 t ± ² ³ getFieldByName 3(Ljava/lang/String;)Lcom/edeal/frontline/FieldBean; µ · ¶ com/edeal/frontline/FieldBean ¸ ? getFldSql º id µ ¼ ½ ? getFldFobID t ¿ À Á getTable G(Ljava/lang/String;Ljava/lang/String;)Lcom/edeal/frontline/ObjectsBean; Ã Å Ä com/edeal/frontline/ObjectsBean Æ ? getObjRadical È ID Ê AND Ì = h Ï 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: h ë { ì -(Ljava/lang/Object;)Ljava/lang/StringBuilder; î ð ï org/apache/commons/logging/Log ñ ò info (Ljava/lang/Object;)V ô java/util/ArrayList ó Y ÷ ø ù 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; Sti" Te1 t$%& getRefDisp j(Ljavax/servlet/http/HttpSession;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object;()* getDate #(Ljava/lang/String;)Ljava/sql/Date;,-. getTime #(Ljava/lang/String;)Ljava/sql/Time; t0%1 X(Ljavax/servlet/http/HttpSession;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object; t3%4 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object; ó678 add (Ljava/lang/Object;)Z: SQL Exception î<=> error *(Ljava/lang/Object;Ljava/lang/Throwable;)V@A close@ û@E Frontline ExceptionG 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;>;>; StackMapTablew javax/servlet/http/HttpSessionPz java/lang/Throwable getNumberOfResults ()I SourceFile 'CustomListCorrespondancesForPerson.java ! ) ¸ ³ ± <