Edit C:\Users\Administrator\Desktop\galaxie\WEB-INF\classes\com\edeal\frontline\helper\custom\CustomListInteractions.class
Êþº¾ 3m 8com/edeal/frontline/helper/custom/CustomListInteractions ,com/edeal/frontline/grid/CustomListResultSet logger Lorg/apache/commons/logging/Log; nb I ConstantValue <clinit> ()V Code %org/apache/commons/logging/LogFactory getLog 3(Ljava/lang/Class;)Lorg/apache/commons/logging/Log; LineNumberTable LocalVariableTable <init> this :Lcom/edeal/frontline/helper/custom/CustomListInteractions; 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 1 IntStiID:Val 3 IntAtvID 5 IntDate 7 IntTimeBeg 9 IntTimeEnd ; IntCatID = IntSubject ? IntDetails A EntCorpName C 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 L &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;>;>; O Q P com/edeal/frontline/FlContext R S getDataDictionary &()Lcom/edeal/frontline/DataDictionary; U consolidated # W X Y get &(Ljava/lang/Object;)Ljava/lang/Object; [ java/lang/String ] _ a ` java/lang/Boolean b c valueOf (Z)Ljava/lang/Boolean; e g f #org/apache/commons/lang/StringUtils h i isEmpty (Ljava/lang/String;)Z k java/lang/StringBuilder m WHERE PerFctParentID= j o p (Ljava/lang/String;)V r PerFctParentID t v u (com/edeal/frontline/navigation/FlRequest w x getSearchCriteria &(Ljava/lang/String;)Ljava/lang/String; z | { com/edeal/frontline/Utils } ~ formatToSQL E(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Ljava/lang/String; j ? ? ? append -(Ljava/lang/String;)Ljava/lang/StringBuilder; j ? ? ? toString ()Ljava/lang/String; Z ? b ? &(Ljava/lang/Object;)Ljava/lang/String; ? AND PerFctIsActive = ? ? ? java/lang/Integer b ? (I)Ljava/lang/Integer; z ? } ? E(Lcom/edeal/frontline/FlContext;Ljava/lang/Number;)Ljava/lang/String; ? corfield ? CorEntID ? ? ? "com/edeal/frontline/DataDictionary ? ? getFieldByName 3(Ljava/lang/String;)Lcom/edeal/frontline/FieldBean; ? ¡ com/edeal/frontline/FieldBean ¢ ? getFldSql ¤ id ? ¦ § ? getFldFobID ? © ª « getTable G(Ljava/lang/String;Ljava/lang/String;)Lcom/edeal/frontline/ObjectsBean; ¯ ® com/edeal/frontline/ObjectsBean ° ? getObjRadical ² ID ´ WHERE ¶ = ¸ and IntType_= º IntType_ t ¼ ½ x getParameter j À lSELECT distinct(IntID),IntID,IntStiID,IntAtvID,IntDate,IntTimeBeg,IntTimeEnd,IntCatID,IntSubject,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 Ô , z Ö × Ø 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 ä O è é ê 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 x getString û enforceAccess (ILjava/lang/String;)Z Ä next t getSession "()Ljavax/servlet/http/HttpSession; Sti Te1 ? 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; ?!" 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object; ä$%& add (Ljava/lang/Object;)Z( SQL Exception ß*+, error *(Ljava/lang/Object;Ljava/lang/Throwable;)V./ close ò. ì.3 Frontline Exception5 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;>;>; StackMapTablee javax/servlet/http/HttpSession>h java/lang/Throwable getNumberOfResults ()I SourceFile CustomListInteractions.java ! ) ¸ ³ ± <