Edit C:\Users\Administrator\Desktop\Back\Livraison EVQG22\com\edeal\frontline\helper\custom\CustomListContratsPrincipaux.class
Êþº¾ 3 >com/edeal/frontline/helper/custom/CustomListContratsPrincipaux ,com/edeal/frontline/grid/CustomListResultSet logger Lorg/apache/commons/logging/Log; nb I <clinit> ()V Code 8com/edeal/frontline/helper/custom/CustomListContratTiers %org/apache/commons/logging/LogFactory getLog 3(Ljava/lang/Class;)Lorg/apache/commons/logging/Log; LineNumberTable LocalVariableTable <init> this @Lcom/edeal/frontline/helper/custom/CustomListContratsPrincipaux; getFieldMapping ()Ljava/util/HashMap; Signature ;()Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/String;>; $ java/util/HashMap # ' Ct_ID # ) * + put 8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object; - Ct_NumContrat / Ct_CodeContrat 1 Ct_DateSignature 3 Ct_DateEffet 5 Ct_TypeContrat 7 Ct_TypeContrat:Val 9 Ct_NatureContrat ; Ct_NatureContrat:Val = Ct_Statut ? Ct_Statut:Val A Ct_DateFin C EntID E PerID 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 N &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;>;>; Q S R com/edeal/frontline/FlContext T U getDataDictionary &()Lcom/edeal/frontline/DataDictionary; W java/lang/StringBuilder V Z # WHERE Ct_ContratPrincipal is null V \ ] ^ append -(Ljava/lang/String;)Ljava/lang/StringBuilder; ` b a (com/edeal/frontline/navigation/FlRequest c d getSearchCriteria &(Ljava/lang/String;)Ljava/lang/String; f h g com/edeal/frontline/Utils i j isEmpty (Ljava/lang/String;)Z l % V n o (Ljava/lang/String;)V q s r java/lang/String t u toUpperCase ()Ljava/lang/String; V w x u toString z AND UPPER(Ct_NumContrat) LIKE f | } ~ formatToSQL E(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Ljava/lang/String; ? Ct_DateSignature$From ? AND Ct_DateSignature >= ? Ct_DateSignature$To ? AND Ct_DateSignature <= ? AND Ct_Statut = ? AND Ct_TypeContrat = ? AND Ct_NatureContrat = ? ©SELECT Ct_ID, Ct_NumContrat, Ct_DateSignature, Ct_DateFin, Ct_DateEffet, Ct_Statut, Ct_TypeContrat, Ct_CodeContrat, Ct_NatureContrat ,EntID ,sg_contact.MvaText as PerID ? FROM Contrat_ ctr ? 8Left join Signataire_ sg_ on sg_.sg_contrat = ctr.Ct_ID ? @Left join MvaSg_Tiers sg_tiers on sg_tiers.MvaColID = sg_.Sg_ID ? 9Left join Enterprise ent on sg_tiers.MvaText = ent.EntID ? FLeft join MvaSg_Contact sg_contact on sg_.Sg_ID = sg_contact.MvaColID V ? ] ? 3(Ljava/lang/CharSequence;)Ljava/lang/StringBuilder; ? &CustomListContratPrincipaux sql query: V ? ] -(Ljava/lang/Object;)Ljava/lang/StringBuilder; ¢ ¤ £ org/apache/commons/logging/Log ¥ ¦ info (Ljava/lang/Object;)V ¨ java/util/ArrayList § « ¬ com/edeal/frontline/BasicBean ® ¯ listSQL Y(Ljavax/servlet/http/HttpSession;[Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector; ± ³ ² java/util/Vector ´ µ size ()I « · ® ¸ [(Ljavax/servlet/http/HttpSession;[Ljava/lang/String;Ljava/lang/String;II)Ljava/util/Vector; ± ± » ¼ ½ elementAt (I)Ljava/lang/Object; ¿ java/util/Hashtable ¾ Á  à get &(Ljava/lang/Object;)Ljava/lang/Object; Å Ç java/lang/Integer É java/util/Date Ë Í Ì "com/edeal/frontline/DataDictionary Î Ï getRefDisp X(Ljavax/servlet/http/HttpSession;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object; § Ñ Ò Ó add (Ljava/lang/Object;)Z 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; queryWhere Ljava/lang/StringBuilder; numContrat Ljava/lang/String; pCt_DateSignatureFrom pCt_DateSignatureTo statutRegl typeContr natureContr sqlQuery list Ljava/util/Vector; res Ljava/util/ArrayList; keys listTemp fe (Lcom/edeal/frontline/FrontlineException; count i row Ljava/util/Hashtable; ctrID numCtr cdCtr dateEff Ljava/util/Date; dateFin dateSign ctrStatut typeContrat natureContrat entid perid 9Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/Object;>; OLjava/util/Vector<Ljava/util/Hashtable<Ljava/lang/String;Ljava/lang/String;>;>; PLjava/util/ArrayList<Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/Object;>;>; StackMapTable javax/servlet/http/HttpSession Ü getNumberOfResults SourceFile !CustomListContratsPrincipaux.java ! ) ¸ ³ ± <