Edit C:\Users\Administrator\Desktop\Back\Livraison EVQG22\com\edeal\frontline\helper\custom\CustomListInteractionsForActorTodo.class
Êþº¾ 3 Dcom/edeal/frontline/helper/custom/CustomListInteractionsForActorTodo ,com/edeal/frontline/grid/CustomListResultSet logger Lorg/apache/commons/logging/Log; nb I <clinit> ()V Code %org/apache/commons/logging/LogFactory getLog 3(Ljava/lang/Class;)Lorg/apache/commons/logging/Log; LineNumberTable LocalVariableTable <init> this FLcom/edeal/frontline/helper/custom/CustomListInteractionsForActorTodo; 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 / IntStiID:RefVal 1 IntAtvID 3 IntDate 5 IntCatID 7 IntCatID:Val 9 IntSubject ; IntDetails = IntType_ ? IntType_:Val A IntTheme_ C IntTheme_:Val E IntMedID G IntMedID:Val I IntTimeBeg K IntTimeEnd M IntTiersConc_ O IntTiersConc_:EntTriName_ Q EntID 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 Z &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 ` a getDataDictionary &()Lcom/edeal/frontline/DataDictionary; c Sti e Te1 g TODO i k j "com/edeal/frontline/DataDictionary l m getRefIdByCode J(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; o type ! q r s get &(Ljava/lang/Object;)Ljava/lang/Object; u java/lang/String w y x #org/apache/commons/lang/StringUtils z { isEmpty (Ljava/lang/String;)Z } COR i l ? 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; ? java/lang/StringBuilder ? cannot find Interaction type [ ? ? ? (Ljava/lang/String;)V ? ? ? ? append -(Ljava/lang/String;)Ljava/lang/StringBuilder; ? ]. No filter applied ? ? ? ? toString ()Ljava/lang/String; ? ? ? org/apache/commons/logging/Log ? ? error (Ljava/lang/Object;)V ? actor ? ? ? (com/edeal/frontline/navigation/FlRequest ? ? getSearchCriteria &(Ljava/lang/String;)Ljava/lang/String; ¡ IntCorID:CorEntID £ IntCorID:CorPerID ¥ IntDate$From § IntDate$To ? ª ©SELECT distinct(IntID),IntID,IntStiID,IntAtvID,IntDate,IntCatID,IntSubject,IntDetails,IntType_,IntTheme_,IntMedID,IntTimeBeg,IntTimeEnd,IntTiersConc_,EntTriName_,EntID ¬ FROM Interaction ® (LEFT JOIN MvaIntActID ON MvaColID=IntID ° /LEFT JOIN enterprise ON EntID = IntTiersConc_ ² java/util/ArrayList ± µ IntStiID= · ¹ ¸ com/edeal/frontline/Utils º » formatToSQL E(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Ljava/lang/String; ± ½ ¾ ¿ add (Ljava/lang/Object;)Z Á IntAtvID= à IntType_= Å IntTheme_= Ç IntMedID= É IntCatID= Ë IntDate >= · Í Î Ï formatDateFromWeb D(Ljavax/servlet/http/HttpSession;Ljava/lang/String;)Ljava/util/Date; · Ñ º Ò C(Lcom/edeal/frontline/FlContext;Ljava/util/Date;)Ljava/lang/String; Ô IntTiersConc_= Ö Ø × java/util/Calendar Ù Ú getInstance ()Ljava/util/Calendar; Ö Ü Ý Þ setTime (Ljava/util/Date;)V Ö à á â set (II)V Ö ä å æ getTime ()Ljava/util/Date; è IntDate <= ê 9LEFT JOIN MvaIntCorID mvacor ON mvacor.MvaColID = IntID ì =LEFT JOIN Correspondent corr ON mvacor.MvaText = corr.CorID î corr.CorEntID = ð corr.CorPerID = ò actorID ô ö õ javax/servlet/http/HttpSession ÷ ø getAttribute &(Ljava/lang/String;)Ljava/lang/Object; t ú z û ()Z ý com/edeal/frontline/ActorBean ü ÿ 5(Ljava/lang/String;Ljavax/servlet/http/HttpSession;)V ü ? getActPartitionID PrtMode:RefVal !com/edeal/frontline/PartitionBean lookup X(Ljavax/servlet/http/HttpSession;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object; DIFFUSION t ¿ equals PrtID [Ljava/lang/String; PrtMode= PrtMode RESTRICTION listSummary Z(Lcom/edeal/frontline/FlContext;[Ljava/lang/String;[[Ljava/lang/String;)Ljava/util/Vector;" [ ( (EXISTS (SELECT MvaColID FROM MvaIntPartitionID WHERE MvaColID = IntID AND MvaText IN ( t$%& valueOf &(Ljava/lang/Object;)Ljava/lang/String;( , *,+ java/util/Vector-. size ()I *012 elementAt (I)Ljava/lang/Object;4 java/util/Hashtable 3 q7 S ))) or (NOT EXISTS(SELECT MvaID FROM MvaIntPartitionID WHERE MvaColID = IntID) ))9 W ( EXISTS (SELECT MvaColID FROM MvaIntPartitionID WHERE MvaColID = IntID AND MvaText = ; ))= +FieldNotInitializedException ActPartitionID? AccessDeniedException Actor : ACB )com/edeal/frontline/AccessDeniedExceptionDE getStackTrace ()[Ljava/lang/StackTraceElement; ?G ?H -(Ljava/lang/Object;)Ljava/lang/StringBuilder;J FrontlineException YC ±MNO iterator ()Ljava/util/Iterator;QSR java/util/IteratorTU next ()Ljava/lang/Object;W WHERE Y AND Q[\ û hasNext^ AND IntStiID = '` 'b ORDER BY ·def implodeList 9([Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;h CustomListInteraction sql query: ?jk ? infom MvaColIDo EntTriName_ qsr com/edeal/frontline/BasicBeantu listSQL Y(Ljavax/servlet/http/HttpSession;[Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector; ]wxy getConnection ()Ljava/sql/Connection;{}| java/sql/Connection~ createStatement ()Ljava/sql/Statement;??? java/sql/Statement?? 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??T û i??? getRefDisp 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object;???? getDate #(Ljava/lang/String;)Ljava/sql/Date; i???¡ å¢ #(Ljava/lang/String;)Ljava/sql/Time;¤ SQL Exception ?¦ ?§ *(Ljava/lang/Object;Ljava/lang/Throwable;)V?©ª close?©{©® Frontline Exception° 0com/edeal/frontline/FieldNotInitializedException² java/sql/SQLException session Ljavax/servlet/http/HttpSession; context Lcom/edeal/frontline/FlContext; flRequest *Lcom/edeal/frontline/navigation/FlRequest; parameters orderby beginIndex nbEntry dico $Lcom/edeal/frontline/DataDictionary; todo Ljava/lang/String; typeINT intTypID fe (Lcom/edeal/frontline/FrontlineException; intActID intAtvID corEntID corPerID intDateFrom intDateTo intStiID intTheme_ intMedID intCatID intType_ sqlQuery Ljava/lang/StringBuilder; whereClause Ljava/util/ArrayList; dateTo Ljava/util/Calendar; dtTo Ljava/util/Date; actID actPrtID prtMode queryWhere2 Lcom/edeal/frontline/ActorBean; prts Ljava/util/Vector; i row Ljava/util/Hashtable; prtID e 2Lcom/edeal/frontline/FieldNotInitializedException; +Lcom/edeal/frontline/AccessDeniedException; fFirstCondition Z whereCondition res con Ljava/sql/Connection; stmt Ljava/sql/Statement; rs Ljava/sql/ResultSet; keys listTemp fCanRead j emptyInt %Lcom/edeal/frontline/InteractionBean; intID count sqle Ljava/sql/SQLException; 9Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/Object;>; )Ljava/util/ArrayList<Ljava/lang/String;>; PLjava/util/ArrayList<Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/Object;>;>; StackMapTableÿ java/lang/Throwable getNumberOfResults SourceFile 'CustomListInteractionsForActorTodo.java ! ) ¸ ³ ± # <