Edit C:\Users\Administrator\Desktop\Back\Livraison EVQG22\com\edeal\frontline\helper\custom\CustomListAffiliatesTiers.class
Êþº¾ 3Y ;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; getNumberOfResults ()I 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 / EntDispName_ 1 EntPhone 3 EntWeb 5 EntCtrID 7 EntCtrID:Val 9 EntZip ; EntCity = EntDepartmentID_ ? EntTriName_ A EntStarClassID_ C EntStarClassID_:Val E EntCheNbID_ G EntCheNbID_:Val I EntCocNbID_ K EntCocNbID_:Val M Ct_NumContrat O Ct_Statut Q Ct_Statut:Val S Ct_CodeContrat U Ct_DateSignature W Ct_DateEffet Y Ct_DateAdhesion [ Ct_DateFin ] Lo_ID _ Lo_Nom a PerID c PerCivID e PerCivID:Val g PerName i PerFstName k Ct_TypeContrat 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 t &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;>;>; w y x com/edeal/frontline/FlContext z { getDataDictionary &()Lcom/edeal/frontline/DataDictionary; } java/util/ArrayList | ? java/lang/StringBuilder ? actorID ? ? ? javax/servlet/http/HttpSession ? ? getAttribute &(Ljava/lang/String;)Ljava/lang/Object; ? java/lang/String ? ? ? ? isEmpty ()Z ? com/edeal/frontline/ActorBean ? ? ? 5(Ljava/lang/String;Ljavax/servlet/http/HttpSession;)V ? ? ? ? getActPartitionID ()Ljava/lang/String; ? PrtMode:RefVal ? ? ? !com/edeal/frontline/PartitionBean ? lookup X(Ljavax/servlet/http/HttpSession;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object; ¢ WHERE ¤ ¥ (Ljava/lang/String;)V § DIFFUSION ? © ª « equals (Ljava/lang/Object;)Z PrtID ¯ [Ljava/lang/String; ± PrtMode= ³ PrtMode µ RESTRICTION · ¹ ¸ "com/edeal/frontline/DataDictionary º » getRefIdByCode 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; ½ ¿ ¾ com/edeal/frontline/Utils À Á formatToSQL E(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Ljava/lang/String; Ã Ä Å append -(Ljava/lang/String;)Ljava/lang/StringBuilder; Ç È ? toString ? Ê Ë Ì listSummary Z(Lcom/edeal/frontline/FlContext;[Ljava/lang/String;[[Ljava/lang/String;)Ljava/util/Vector; Î _ ( (EXISTS (SELECT MvaColID FROM MvaEntPartitionID WHERE MvaColID = ext.EntID AND MvaText IN ( ? Ð Ñ Ò valueOf &(Ljava/lang/Object;)Ljava/lang/String; Ô , Ö Ø × java/util/Vector Ù size Ö Û Ü Ý elementAt (I)Ljava/lang/Object; ß java/util/Hashtable Þ á â ã get &(Ljava/lang/Object;)Ljava/lang/Object; å W ))) or (NOT EXISTS(SELECT MvaID FROM MvaEntPartitionID WHERE MvaColID = ext.EntID) )) ç \ ( (EXISTS (SELECT MvaColID FROM MvaEntPartitionID WHERE MvaColID = ext.EntID AND MvaText = é V )) or (NOT EXISTS(SELECT MvaID FROM MvaEntPartitionID WHERE MvaColID = ext.EntID) )) ë +FieldNotInitializedException ActPartitionID í ï î org/apache/commons/logging/Log ð ñ error (Ljava/lang/Object;)V ó AccessDeniedException Actor : õ ÷ ö )com/edeal/frontline/AccessDeniedException ø ù getStackTrace ()[Ljava/lang/StackTraceElement; û Ä ü -(Ljava/lang/Object;)Ljava/lang/StringBuilder; þ FrontlineException s ÷ java/util/Date java/lang/Boolean Ñ (Z)Ljava/lang/Boolean; Sg_Tiers (com/edeal/frontline/navigation/FlRequest getSearchCriteria &(Ljava/lang/String;)Ljava/lang/String; ½ ? (Ljava/lang/String;)Z AND EntID = % ? ? toUpperCase AND UPPER(EntDispName_) LIKE AND UPPER(EntTriName_) LIKE AND EntCtrID = ! AND UPPER(EntZip) LIKE # AND Lo_Dep = % EntLocalityID_' AND Lo_ID = ) AND UPPER(EntCity) LIKE + AND EntStarClassID_ = - AND EntCheNbID_ = / AND EntCocNbID_ = 1 Sg_Contrat3 AND Ct_ID = 5 AND UPPER(Ct_NumContrat) LIKE 7 AND UPPER(PerName) LIKE 9 AND UPPER(PerFstName) LIKE ; Ct_DateSignature$From= AND Ct_DateSignature >= ? Ct_DateSignature$ToA AND Ct_DateSignature <= C AND UPPER(Ct_TypeContrat) LIKE E AND Ct_TypeContrat not in (G PTI FAK PRM )O EntAdhState_Q ADHACTIFS ADHNNACTIFU AND Ct_Statut = W VALY AND Ct_ContratPrincipal isnull [ AND ( Ct_DateFin > ½] À^ C(Lcom/edeal/frontline/FlContext;Ljava/util/Date;)Ljava/lang/String;` OR Ct_DateFin isnull )b AND Ct_Statut IN (d SUSf ECHh RMPj AND EntID NOT IN ( l ) SELECT DISTINCT(EntID) FROM Signataire_ n 6 INNER JOIN MvaSg_Tiers mvsg on mvsg.MvaColID = Sg_ID p 3 INNER JOIN Enterprise ext on mvsg.MvaText = EntID r + INNER JOIN Contrat_ on Sg_Contrat = Ct_ID t ) ?vw ? toLowerCasey pername ?{|} contains (Ljava/lang/CharSequence;)Z perfstname ?? ? booleanValue?ISelect distinct(Ct_ID), EntID, EntDispName_, EntPhone, EntWeb, EntCtrID, EntZip, EntCity, EntTriName_, EntStarClassID_, EntCheNbID_, EntCocNbID_, Lo_ID, Lo_Nom, Ct_Statut, Ct_CodeContrat, Ct_NumContrat, Ct_DateSignature, Ct_DateEffet, Ct_DateFin, Ct_DateAdhesion, mvct.MvaText PerID, per.pername, per.perfstname From Signataire_ ? !Select count(*) From Signataire_ ?,Select distinct(Ct_ID), EntID, EntDispName_, EntPhone, EntWeb, EntCtrID, EntZip, EntCity, EntTriName_, EntStarClassID_, EntCheNbID_, EntCocNbID_, Lo_ID, Lo_Nom, Ct_Statut, Ct_CodeContrat, Ct_NumContrat, Ct_DateSignature, Ct_DateEffet, Ct_DateFin, Ct_DateAdhesion, mvct.MvaText PerID From Signataire_ ? 5inner join MvaSg_Tiers mvsg on mvsg.MvaColID = Sg_ID ? 2inner join Enterprise ext on mvsg.MvaText = EntID ? *inner join Contrat_ on Sg_Contrat = Ct_ID ? 4left outer join Localite_ on EntLocalityID_ = Lo_ID ? <left outer join MvaSg_Contact mvct on mvct.MvaColID = Sg_ID ? 2inner join person per on mvct.MvaText = per.PerID w??? getConnection ()Ljava/sql/Connection;??? java/sql/Connection?? prepareStatement 0(Ljava/lang/String;)Ljava/sql/PreparedStatement; ¢¡ java/sql/PreparedStatement£¤ executeQuery ()Ljava/sql/ResultSet;¦¨§ java/sql/ResultSet© ? next¦«¬ getInt (I)I¦¯° close ¯?¯´ ORDER BY ½¶·¸ implodeList 9([Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;º LIMIT ¼ Ľ (I)Ljava/lang/StringBuilder;¿ OFFSET Á !***Liste des Tiers, Total count: íÃÄ ñ infoÆ -***Liste des tiers affilies, sql Count query:È '***Liste des tiers affilies, sql query: ÊÌË com/edeal/frontline/BasicBeanÍÎ listSQL Y(Ljavax/servlet/http/HttpSession;[Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector; ÖÐÑÒ iterator ()Ljava/util/Iterator;ÔÖÕ java/util/Iterator©× ()Ljava/lang/Object; ·ÙÚ getRefDispÜ java/lang/Integer Û Ç |ßà « addÔâã ? hasNextå 0com/edeal/frontline/FieldNotInitializedExceptionç java/sql/SQLExceptioné java/lang/Exception 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; res Ljava/util/ArrayList; queryWhere Ljava/lang/StringBuilder; sqlQuery sqlQueryCount queryWhere2 sqlQueryPerson actID Ljava/lang/String; actPrtID prtMode actor Lcom/edeal/frontline/ActorBean; prts Ljava/util/Vector; i row Ljava/util/Hashtable; prtID e 2Lcom/edeal/frontline/FieldNotInitializedException; +Lcom/edeal/frontline/AccessDeniedException; (Lcom/edeal/frontline/FrontlineException; dateDuJour Ljava/util/Date; jointureContact Ljava/lang/Boolean; SearchEntName pSg_tiers pEntCorpName pEntTriName_ pEntCtrID pEntZip pEntDep pLocalite pEntCity pEntTriname pEntStars pEntChems pEntCocs pCt_ID pCt_NumContrat pPerName pPerFstName pCt_DateSignatureFrom pCt_DateSignatureTo ct_TypeContrat adhState adhID nnadhID con Ljava/sql/Connection; ps Ljava/sql/PreparedStatement; rs Ljava/sql/ResultSet; Ljava/sql/SQLException; min max keys list iter Ljava/util/Iterator; val ct_ID entID entCorpName entPhone entWeb entCtr entZip entCity entTri entStar entCh entCoc ct_numcontrat statutCtr int_ct_CodeContrat Ljava/lang/Integer; ct_DateSignature ct_DateEffet ct_DateFin ct_DateAdh perCiv perID nomPersonne prenomPersonne lo_ID localiteNom ct_TypeContrat_2 9Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/Object;>; PLjava/util/ArrayList<Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/Object;>;>; StackMapTableV java/lang/Throwable SourceFile CustomListAffiliatesTiers.java ! ) ¸ ³ ± ! <