3Dcom/edeal/frontline/helper/custom/CustomListCorrespondancesForPerson,com/edeal/frontline/grid/CustomListResultSetlogger Lorg/apache/commons/logging/Log;nbI ConstantValue()VCode8com/edeal/frontline/helper/custom/CustomListInteractions %org/apache/commons/logging/LogFactory getLog3(Ljava/lang/Class;)Lorg/apache/commons/logging/Log;  LineNumberTableLocalVariableTable    thisFLcom/edeal/frontline/helper/custom/CustomListCorrespondancesForPerson;getFieldMapping()Ljava/util/HashMap; Signature;()Ljava/util/HashMap;&java/util/HashMap %)IntID %+ ,-put8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;/IntActID1IntStiID3 IntStiID:Val5IntAtvID7IntDate9 IntTimeBeg; IntTimeEnd=IntCatID? IntCatID:ValA IntSubjectC IntTheme_E IntTheme_:ValGIntMedIDI IntMedID:ValK IntDetailsM EntCorpNameOPerFctIDmapLjava/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; ExceptionsX&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;>; []\com/edeal/frontline/FlContext ^_getDataDictionary&()Lcom/edeal/frontline/DataDictionary;a consolidated %c deget&(Ljava/lang/Object;)Ljava/lang/Object;gjava/lang/Stringikjava/lang/StringBuildermWHERE IntType_=' jo p(Ljava/lang/String;)VrIntType_tCOR vxw"com/edeal/frontline/DataDictionary yzgetRefIdByCode8(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  formatToSQLE(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;corfieldCorEntID v getFieldByName3(Ljava/lang/String;)Lcom/edeal/frontline/FieldBean; com/edeal/frontline/FieldBean  getFldSqlid  getFldFobID v getTableG(Ljava/lang/String;Ljava/lang/String;)Lcom/edeal/frontline/ObjectsBean; com/edeal/frontline/ObjectsBean  getObjRadicalIDEntID f equals(Ljava/lang/Object;)Z AND ( = OR IntTiersConc_= IntTiersConc_) AND jSELECT 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 ,  implodeList9([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;)Vjava/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;0Sti2Te1 v4 56 getRefDispj(Ljavax/servlet/http/HttpSession;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object;  8 9:getDate#(Ljava/lang/String;)Ljava/sql/Date;  < =>getTime#(Ljava/lang/String;)Ljava/sql/Time; v@ 5AX(Ljavax/servlet/http/HttpSession;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object; vC 5D8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object; F GaddI SQL Exception K LMerror*(Ljava/lang/Object;Ljava/lang/Throwable;)V  O P close O  OTFrontline ExceptionVjava/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;Ljava/lang/String; queryWhereisConsolidatedLjava/lang/Boolean; corFieldNamecorFldLcom/edeal/frontline/FieldBean; corFobField corFobRadIDsqlQueryLjava/lang/StringBuilder;resLjava/util/ArrayList;conLjava/sql/Connection;stmtLjava/sql/Statement;rsLjava/sql/ResultSet;fCanReadZjemptyInt%Lcom/edeal/frontline/InteractionBean;intIDcountsqleLjava/sql/SQLException;fe(Lcom/edeal/frontline/FrontlineException;9Ljava/util/HashMap;PLjava/util/ArrayList;>; StackMapTablejavax/servlet/http/HttpSession_java/lang/ThrowablegetNumberOfResults()I SourceFile'CustomListCorrespondancesForPerson.java!    )   < **    !"#$ >%Y'L+((*W+..*W+00*W+22*W+44*W+66*W+88*W+::*W+<<*W+>>*W+@@*W+BB*W+DD*W+FF*W+HH*W+JJ*W+LL*W+NN*W+R!"#$#%,&5'>(G)P*Y+b,k-t.}/01235 PQR PSTUVW#Y r,Z:`bf: h: jYlnqsu{{: :  H: jYn,-{: jY n{,{: bf:  :  :  :jY ĸnɶ{:˶͙JjY nѶ{{Ӷ{,-{ն{,-׶{ٶ{: 0jY n۶{{Ӷ{,-{: jY:  ޶{W  {W {W {W {W  {W {W  {W jYn{{WjYn Y: :::,: : :66Y+:'(:$6`6 (66%Y':(:$6 (*W0600*W2,Z-+/103*W444*W67667*W8;88;*W:;::;*W<->+<<?*W<<*W@@@*WB-D+BB?*WBB*WF-H+FF?*WFF*WJJJ*W JLLL*WNNNNB*W EW(:HJN:Q:R::SJN:Q:RU:P:N:Q:R:N:Q:R: UUUUWUUU""$+.U07:U<CFUKRUUW^aUcjmUy:>@A5B;CCDIEdFGHIJMNOPQ!R$SQYZZb[j\r^z_`bcdgijlqrstwxyz{|"},/:DSdgjs~ *;GXg#2CKZkz"$+07<CHKRW^cjo.r rWXrYZr[\r]Qr^_r`ralbc`ad \ed ;7fg hd ij kd~ldZmn op qrst|uvwx"y,z{:|dgL}s*PQ~|d ~ R r]o s*P55 [%vfffff, [%vff j/(c[%vffj  [%vffj  f[%vffj  f4%fA888'& [%vffj  UXUIUIUDWXUIUIUD [%vffj  UIUIU[%vffj  IUIUIU ,