3Icom/edeal/frontline/helper/custom/CustomListCorrespondancesForInteraction,com/edeal/frontline/grid/CustomListResultSetlogger Lorg/apache/commons/logging/Log;nbI ConstantValue listeCorrsIDsLjava/lang/String;corrIDsLjava/util/Vector;()VCode8com/edeal/frontline/helper/custom/CustomListInteractions %org/apache/commons/logging/LogFactory getLog3(Ljava/lang/Class;)Lorg/apache/commons/logging/Log;  LineNumberTableLocalVariableTable "  $  & ( thisKLcom/edeal/frontline/helper/custom/CustomListCorrespondancesForInteraction;getFieldMapping()Ljava/util/HashMap; Signature;()Ljava/util/HashMap;0java/util/HashMap /"3IntID /5 67put8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;9 IntSubject;IntDate=IntActID? IntStiID:ValA IntReportmapLjava/util/HashMap;LocalVariableTypeTable9Ljava/util/HashMap; getResultSet(Ljavax/servlet/http/HttpSession;Lcom/edeal/frontline/FlContext;Lcom/edeal/frontline/navigation/FlRequest;Ljava/util/HashMap;[Ljava/lang/String;II)Ljava/util/ArrayList; ExceptionsJ&com/edeal/frontline/FrontlineException (Ljavax/servlet/http/HttpSession;Lcom/edeal/frontline/FlContext;Lcom/edeal/frontline/navigation/FlRequest;Ljava/util/HashMap;[Ljava/lang/String;II)Ljava/util/ArrayList;>; MONcom/edeal/frontline/FlContext PQgetDataDictionary&()Lcom/edeal/frontline/DataDictionary; SUT(com/edeal/frontline/navigation/FlRequest VWgetSearchCriteria&(Ljava/lang/String;)Ljava/lang/String;Yjava/util/ArrayList X"\; ^`_com/edeal/frontline/Utils ab explodeList8(Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector; dfejava/util/Vector gh elementAt(I)Ljava/lang/Object;jjava/lang/Stringljava/lang/StringBuilder k"o3SELECT IntID,IntSubject,IntDate,IntStiID,IntReport kq rsappend-(Ljava/lang/String;)Ljava/lang/StringBuilder;uFROM Interaction wWHERE IntID = ky z(Ljava/lang/String;)V ^| }~ formatToSQLE(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Ljava/lang/String; k toString()Ljava/lang/String; CustomListInteraction sql query: k r-(Ljava/lang/Object;)Ljava/lang/StringBuilder; org/apache/commons/logging/Log info(Ljava/lang/Object;)V M  getConnection()Ljava/sql/Connection; java/sql/Connection createStatement()Ljava/sql/Statement; java/sql/Statement  executeQuery((Ljava/lang/String;)Ljava/sql/ResultSet; java/sql/ResultSet next()Z W getString #org/apache/commons/lang/StringUtils isEmpty(Ljava/lang/String;)Z getDate#(Ljava/lang/String;)Ljava/sql/Date;IntStiID "com/edeal/frontline/DataDictionary  getRefDispX(Ljavax/servlet/http/HttpSession;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object; X add(Ljava/lang/Object;)Z SQL Exception error*(Ljava/lang/Object;Ljava/lang/Throwable;)V close d size()Ijava/sql/SQLExceptionsession Ljavax/servlet/http/HttpSession;contextLcom/edeal/frontline/FlContext; flRequest*Lcom/edeal/frontline/navigation/FlRequest; parametersorderby[Ljava/lang/String; beginIndexnbEntrydico$Lcom/edeal/frontline/DataDictionary;resLjava/util/ArrayList;currIDconLjava/sql/Connection;stmtLjava/sql/Statement;rsLjava/sql/ResultSet;isqlQueryLjava/lang/StringBuilder; queryWherejcountsqleLjava/sql/SQLException;9Ljava/util/HashMap;PLjava/util/ArrayList;>; StackMapTablejavax/servlet/http/HttpSessionjava/lang/ThrowablegetNumberOfResults SourceFile,CustomListCorrespondancesForInteraction.java!     )  O*!*#* %*'   )*+,-.@/Y1L+224W+884W+::4W+<<4W+>>4W+@@4W+"$%&'#(,)5*>+@)*8BCD 8BEFGHI-K)U,L:-2R: XYZ:  9: * []': : :6*'ci: kYm: :npWtpWkYvx, {p:pWkYx,:  :  :6 6ջ/Y1:2224W8884W:::4W8 < 4W>+4W@@@4W Wp"a:: : U:P:: : :: : :*'ȡ  &)+257>AA034689*;-<0=3?9@GBPCTE\FdG{HILMNOQSUVWXZ[]+^<`KaUcdd}fgijUlmpqtuxynpqt uxy{p&q+t2u7x>yC?RU)*UUUUCUUUOG > 3 -% 0" 36PT BC D U> BT!9MS/iXiki(/' MS/iXikiWIID MS/iXikiIIMS/iXikiIII MS/iX, )*