Edit C:\Windows\install\galaxie_p01-10\com\edeal\frontline\helper\custom\CustomListAffiliatesTiers.class
Êþº¾ 3? ;com/edeal/frontline/helper/custom/CustomListAffiliatesTiers ,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 =Lcom/edeal/frontline/helper/custom/CustomListAffiliatesTiers; getFieldMapping ()Ljava/util/HashMap; Signature ;()Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/String;>; " java/util/HashMap ! % EntID ! ' ( ) put 8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object; + Ct_ID - EntCorpName / EntPhone 1 EntWeb 3 EntCtrID 5 EntCtrID:Val 7 EntZip 9 EntCity ; EntTriName_ = EntStarClassID_ ? Ct_NumContrat A Ct_CodeContrat C Ct_DateSignature E Ct_DateEffet G Ct_DateFin map Ljava/util/HashMap; LocalVariableTypeTable 9Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/String;>; getNumberOfResults ()I 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 R &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;>;>; U W V com/edeal/frontline/FlContext X Y getDataDictionary &()Lcom/edeal/frontline/DataDictionary; [ java/util/ArrayList Z ^ java/lang/StringBuilder ] a WHERE Ct_TypeContrat = ] c d (Ljava/lang/String;)V f Ct_TypeContrat h L j l k "com/edeal/frontline/DataDictionary m n getRefIdByCode 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; p r q com/edeal/frontline/Utils s t formatToSQL E(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Ljava/lang/String; ] v w x append -(Ljava/lang/String;)Ljava/lang/StringBuilder; ] z { | toString ()Ljava/lang/String; ~ Sg_Tiers ? ? ? (com/edeal/frontline/navigation/FlRequest ? ? getSearchCriteria &(Ljava/lang/String;)Ljava/lang/String; p ? ? ? isEmpty (Ljava/lang/String;)Z ? AND EntID = ? Sg_Tiers:EntCorpName ? % ? ? ? java/lang/String ? | toUpperCase ? AND UPPER(EntCorpName) LIKE ? Sg_Tiers:EntTriName_ ? AND UPPER(EntTriName_) LIKE ? Sg_Tiers:EntCtrID ? AND EntCtrID = ? Sg_Tiers:EntZip ¡ AND UPPER(EntZip) LIKE £ Sg_Tiers:EntCity ¥ AND UPPER(EntCity) LIKE § Sg_Tiers:EntStarClassID_ © AND EntStarClassID_ = « Sg_Contrat AND Ct_ID = ¯ AND UPPER(Ct_NumContrat) LIKE ± Ct_DateSignature$From ³ AND Ct_DateSignature >= µ Ct_DateSignature$To · AND Ct_DateSignature <= ¹ ÑSelect distinct(Ct_ID), EntID, EntCorpName, EntPhone, EntWeb, EntCtrID, EntZip, EntCity, EntTriName_, EntStarClassID_, Ct_CodeContrat, Ct_NumContrat, Ct_DateSignature, Ct_DateEffet, Ct_DateFin From Enterprise » *inner join MvaSg_Tiers on MvaText = EntID ½ +inner join Signataire_ on Sg_ID = MvaColID ¿ *inner join Contrat_ on Sg_Contrat = Ct_ID Á ORDER BY à , p Å Æ Ç implodeList 9([Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; É (***Liste des tiers affiliés, sql query: ] Ë w Ì -(Ljava/lang/Object;)Ljava/lang/StringBuilder; Î Ð Ï org/apache/commons/logging/Log Ñ Ò info (Ljava/lang/Object;)V Ô Ö Õ com/edeal/frontline/BasicBean × Ø listSQL [(Ljavax/servlet/http/HttpSession;[Ljava/lang/String;Ljava/lang/String;II)Ljava/util/Vector; Ú Ü Û java/util/Vector Ý M size Ú ß à á iterator ()Ljava/util/Iterator; ã å ä java/util/Iterator æ ç next ()Ljava/lang/Object; é java/util/Hashtable è ë ì í get &(Ljava/lang/Object;)Ljava/lang/Object; j ï ð ñ getRefDisp X(Ljavax/servlet/http/HttpSession;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object; ó java/lang/Integer ò z ö java/util/Date Z ø ù ú add (Ljava/lang/Object;)Z ã ü ý þ hasNext ()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; res Ljava/util/ArrayList; queryWhere Ljava/lang/StringBuilder; sqlQuery pSg_tiers Ljava/lang/String; pEntCorpName pEntTriName_ pEntCtrID pEntZip pEntCity pEntTriname pEntStars pCt_ID pCt_NumContrat pCt_DateSignatureFrom pCt_DateSignatureTo keys list Ljava/util/Vector; iter Ljava/util/Iterator; row Ljava/util/Hashtable; val ct_ID entID entCorpName entPhone entWeb entCtr entZip entCity entTri entStar ct_numcontrat int_ct_CodeContrat Ljava/lang/Integer; ct_DateSignature Ljava/util/Date; ct_DateEffet ct_DateFin 9Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/Object;>; PLjava/util/ArrayList<Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/Object;>;>; StackMapTable; javax/servlet/http/HttpSession SourceFile CustomListAffiliatesTiers.java ! ) ¸ ³ ± <