Edit C:\Users\Administrator\Desktop\CGI\LIVRAISONS\v1.6.4\v1.6.4.1 17-07-2024\02-APPLI\WEB-INF\classes\com\edeal\frontline\helper\custom\Contrat_Helper.class
Êþº¾ 3I 0com/edeal/frontline/helper/custom/Contrat_Helper -com/edeal/frontline/helper/Contrat_BaseHelper logger Lorg/apache/commons/logging/Log; <clinit> ()V Code %org/apache/commons/logging/LogFactory getLog 3(Ljava/lang/Class;)Lorg/apache/commons/logging/Log; LineNumberTable LocalVariableTable <init> ,(Lcom/edeal/frontline/custom/Contrat_Bean;)V this 2Lcom/edeal/frontline/helper/custom/Contrat_Helper; bean )Lcom/edeal/frontline/custom/Contrat_Bean; )getAllOnGoingLogisContractsWithoutInvoice y(Lcom/edeal/frontline/FlContext;Ljava/util/Date;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector; Exceptions &com/edeal/frontline/FrontlineException Signature ?(Lcom/edeal/frontline/FlContext;Ljava/util/Date;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector<Ljava/lang/String;>; $ java/util/Vector # & ( java/lang/String * EntID , Ct_ID . java/lang/StringBuffer - & 1 -Select Distinct EntID, Ct_ID From Enterprise - 3 4 5 append ,(Ljava/lang/String;)Ljava/lang/StringBuffer; 7 *inner join MvaSg_Tiers on MvaText = EntID 9 +inner join Signataire_ on Sg_ID = MvaColID ; *inner join Contrat_ on Sg_Contrat = Ct_ID = gleft join Opportunity on OppEntID=EntID and Oppmillesime_ = EntCotisationMil_ and EntCotDevID_ = OppID ? 0inner join Refvalues r1 on r1.RefID = Ct_Statut A 5inner join Refvalues r2 on r2.RefID = Ct_TypeContrat C /inner join Refvalues r3 on r3.RefID = EntTyeID E java/lang/StringBuilder G WHERE r2.RefVal = D I J (Ljava/lang/String;)V L N M com/edeal/frontline/Utils O P formatToSQL E(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Ljava/lang/String; D R 4 S -(Ljava/lang/String;)Ljava/lang/StringBuilder; D U V W toString ()Ljava/lang/String; Y AND r1.RefVal = 'VAL' [ AND r3.RefID in ( ] ^ _ getTiersReservitTypes 3(Lcom/edeal/frontline/FlContext;)Ljava/lang/String; a ) c * AND ( Ct_DateFin IS NULL OR Ct_DateFin > L e O f C(Lcom/edeal/frontline/FlContext;Ljava/util/Date;)Ljava/lang/String; h AND EntCotisationMil_ = j l k java/lang/Integer m n valueOf '(Ljava/lang/String;)Ljava/lang/Integer; D p 4 q -(Ljava/lang/Object;)Ljava/lang/StringBuilder; s AND EntCotDevID_ IS NOT NULL u AND OppNumFact_ IS NULL w EntMbm y { z com/edeal/frontline/FlContext | } getContextParameter &(Ljava/lang/String;)Ljava/lang/String; true ' ? ? ? equalsIgnoreCase (Ljava/lang/String;)Z ? AND EntMbm = 1 ? AND EntCtrID = ? ? ? org/apache/commons/logging/Log ? ? info (Ljava/lang/Object;)V - U ? ? ? com/edeal/frontline/BasicBean ? ? listSQL X(Lcom/edeal/frontline/FlContext;[Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector; # ? ? ? size ()I # ? ? ? elementAt (I)Ljava/lang/Object; ? java/util/Hashtable ? ¡ ¢ get &(Ljava/lang/Object;)Ljava/lang/Object; # ¤ ¥ ? addElement context Lcom/edeal/frontline/FlContext; pDate Ljava/util/Date; pMillesime Ljava/lang/String; typContrat pays logis Ljava/util/Vector; result keys [Ljava/lang/String; sqlQuery Ljava/lang/StringBuffer; optionEntMbm i I row Ljava/util/Hashtable; idLogis LocalVariableTypeTable &Ljava/util/Vector<Ljava/lang/String;>; StackMapTable ¿ java/util/Date ² getAllOnGoingLogisContracts ?(Lcom/edeal/frontline/FlContext;Ljava/util/Date;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector; ±(Lcom/edeal/frontline/FlContext;Ljava/util/Date;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector<Ljava/lang/String;>; Å Ç o AND (Select Max(EvtDate) from Classement_ left join Event on Cl_Comite = EvtID where Cl_Tiers=EntID) BETWEEN É AND Ë j AND (Select Max(EvtDate) from Classement_ left join Event on Cl_Comite = EvtID where Cl_Tiers=EntID) >= Í j AND (Select Max(EvtDate) from Classement_ left join Event on Cl_Comite = EvtID where Cl_Tiers=EntID) <= ' Ï Ð ? length Ò (left join Opportunity on OppEntID=EntID Ô *left join Classement_ on Cl_Tiers = EntID Ö %left join Event on Cl_Comite = EvtID Ø 8 AND ( EntCotisationMil_ IS NULL OR EntCotisationMil_ < Ú OR ( EntCotisationMil_ = Ü M AND EntCotDevID_ not in ( SELECT OppID FROM Opportunity WHERE Oppmillesime_= Þ * AND Opptitle not like '%Echéancier%' ))) datemin datemax dateComiteQuery isDateComite Z getLogisMarqueContrat g(Lcom/edeal/frontline/FlContext;Ljava/util/Date;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; ç Ct_Marque é 1Select Distinct EntID, Ct_Marque From Enterprise ë )inner join Opportunity on OppEntID=EntID í AND ( EntID = # ï ð ñ firstElement ()Ljava/lang/Object; entID fe (Lcom/edeal/frontline/FrontlineException; getAllOnGoingLogisSubContracts ?(Lcom/edeal/frontline/FlContext;Ljava/util/Date;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector; ?(Lcom/edeal/frontline/FlContext;Ljava/util/Date;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector<Ljava/lang/String;>; ù " group by EntID,r2.RefVal ) as res û GSelect EntID from (Select EntID,r2.RefVal,MAX(EvtDate) From Enterprise ý Select EntID From Enterprise ÿ +inner join Classement_ on Cl_Tiers = EntID &inner join Event on Cl_Comite = EvtID WHERE r2.RefVal in ( _ subContractsTypes 1getAllOnGoingLogisSubContractsWithoutInvoiceCount g(Lcom/edeal/frontline/FlContext;Ljava/util/Date;Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector; {(Lcom/edeal/frontline/FlContext;Ljava/util/Date;Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector<Ljava/lang/String;>; %Select EntID, Ct_ID From Enterprise ? ? error #getAllOnGoingLogisSubContractsCount getAllOnGoingSubContractstypes 1Select Distinct r2.RefVal typect From Enterprise AND EntID = ' ' isTheHotelHasaLESubContrat V(Lcom/edeal/frontline/FlContext;Ljava/util/Date;Ljava/lang/String;Ljava/lang/String;)Z -Select Distinct Ct_ID typect From Enterprise AND r2.RefVal = 'LE' y getDataDictionary &()Lcom/edeal/frontline/DataDictionary;" Cp_$ Te2 &(' "com/edeal/frontline/DataDictionary)* getRefList 8(Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector; #,-. iterator ()Ljava/util/Iterator;021 java/util/Iterator3 ñ next5 S '789 equals (Ljava/lang/Object;)Z; Ct_TypeContrat &=>? getRefCode 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; 'A mB &(Ljava/lang/Object;)Ljava/lang/String;D F ,0HIJ hasNext ()Z LM W getMessage ?OP ? warn 'RST substring (II)Ljava/lang/String; subCtTye dico $Lcom/edeal/frontline/DataDictionary; ctTypesValues refID cat cd fle :Ljava/util/Vector<Ljava/util/Vector<Ljava/lang/String;>;>; contractsPrincipauxTypes` P subContractsTypesIDs contractsPrincipauxTypesIDs getActifContractID ¾ & D &g ASELECT Distinct Ct_ID,Ct_CodeContrat,Ct_ContratPrincipal,Ct_CrDt i FROM Contrat_ k . inner join Signataire_ ON Sg_Contrat = Ct_ID m , inner join MvaSg_Tiers ON MvaColID = Sg_ID o * inner join Enterprise ON EntID = MvaText q 1 inner join Refvalues r1 on r1.RefID = Ct_Statut s 6 inner join Refvalues r2 on r2.RefID = Ct_TypeContrat u , WHERE (r2.RefVal = 'L' OR r2.RefVal = 'C') w AND EntID = y ) order by Ct_CrDt desc{ [getActifContractID] sql query:} Ct_CodeContrat Ct_ContratPrincipal? Ct_CrDt ? ?? 'com/edeal/frontline/custom/Contrat_Bean ctID cts now Ljava/lang/StringBuilder; queryWhere flds line getActifContractID_? S WHERE (r2.RefVal = 'L' OR r2.RefVal = 'C' OR r2.RefVal = 'S' OR r2.RefVal = 'DC') getActifContractIDLE? WHERE (r2.RefVal = 'LE') ? $ AND Ct_ContratPrincipal IS NOT NULL getActifContractIDSubContracts W(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;? WHERE (r2.RefVal = '? ') typeCt getActifAdhContractID? ; WHERE r2.RefVal not in ('PR','PT','FA') AND r2.RefVal in ( ?^ _¡ AND Ct_ContratPrincipal IS NULL£ "[getActifAdhContractID] sql query: getAffiliationCt_ID¦ ) WHERE r2.RefVal not in ('QT','PT','FA') ¨ U AND Ct_CodeContrat IS NOT NULL AND Ct_ContratPrincipal IS NULL order by Ct_CrDt desc getAffiliationCt_ID_Cs_O_F« WHERE r2.RefVal in ® _ %contractsPrincipauxTypesForPasserelle° AND r1.RefTe2 = 'O' getAffiliationCt_IDToSendToWeb H(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Ljava/util/Hashtable; n(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Ljava/util/Hashtable<Ljava/lang/String;Ljava/lang/Object;>; ? &¶ DSELECT Distinct Ct_ID, Ct_CodeContrat, Ct_ContratPrincipal, Ct_CrDt ¸ +[getAffiliationCt_IDToSendToWeb] sql query: ;Ljava/util/Hashtable<Ljava/lang/String;Ljava/lang/Object;>; getContratPrincipaleCt_ID getAffiliateNumber½ - WHERE (r2.RefVal = 'L' OR r2.RefVal = 'LE') ¿ order by Ct_CrDt descÁ ,Ct_CrDt ?ÃÄ9 containsKey jÆÇ ? intValue jÉ VÊ (I)Ljava/lang/String;Ì [getAffiliateNumber] sql query: code getAffiliateWithoutLCBSÐ ( WHERE (Ct_NumContrat NOT LIKE '%PDT%') getAffiliateNumberByPersonIDÓ VALÕ EAV ×ÑØ X(Lcom/edeal/frontline/FlContext;Ljava/lang/String;[Ljava/lang/String;)Ljava/lang/String; perID status ÜÞÝ -com/edeal/frontline/helper/custom/EventHelperß _ getContractTypeForQSTListActionsá +SELECT Distinct Ct_CodeContrat FROM Person ã - inner join MvaSg_Contact ON MvaText = PerID å , inner join Signataire_ ON Sg_ID = MvaColID ç + inner join Contrat_ on Sg_Contrat = Ct_ID é ' WHERE (r2.RefVal = 'LE' OR r2.RefID = ë ) í AND (ï OR ñ r1.RefVal = ó AND PerID = contratCondition firstStatut statut "getAffiliateNumberByPersonID_onlyLù AND (r1.RefVal = 'VAL') &getAffiliateNumberByPersonID_onlyLAndC üúØþ &SELECT Distinct r1.RefVal FROM Person WHERE (r2.RefID = r1.RefVal getAffiliateType c P L ? isEmpty Ct_TypeContrat:RefVal ? lookup W(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object; canLocEnseigne F(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;)Z Ct_LocationEnseigne java/lang/Boolean J booleanValue canLocEns getContratNbRooms 4(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)I ? P Ct_NombreChambres Cannot find quantity of rooms" java/lang/Exception nbRoom e Ljava/lang/Exception; getNbEnseignes F(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;)I) Cannot find any contract I, ProQuantity. <SELECT Sum(cr_quantity) As ProQuantity from ContratProduit_0 * GROUP BY Cr_Contrat, Cr_Produit, Cr_Etat 2 HAVING Cr_Produit = 4 AND Cr_Contrat = 6 AND Cr_Etat = 8 Cr_Etat: OUV &<=? getRefIdByCode? [getNbEnseignes] A : C ?D .com/edeal/frontline/custom/ContratProduit_BeanF java/lang/Long EHIJ longValue ()J EL M (J)V EÆP PrdMaxQt_ RS com/edeal/frontline/ProductBeanU Cannot find any enseigne prdID ensnb ens ensnbMax getNbEnseignesSubContracts X(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)I ]??_ ProIDa CSELECT Distinct (ProID) As ProID ,ProQuantity From ContratProduit_ c 0 INNER JOIN Opportunity ON OppID = Cr_Commande_ e : INNER JOIN ProductOpportunity ON ProOppID = Cr_Commande_ g WHERE Cr_Contrat = i AND ProPrdID = getPrdCodesFromContract i(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector; }(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector<Ljava/lang/String;>; np PrdIDr +SELECT Distinct PrdID From ContratProduit_ t * INNER JOIN Product ON PrdID = Cr_Produit v + INNER JOIN Contrat_ ON Ct_ID = Cr_Contrat x AND PrdIncludedInCot_ = 1 z AND ( '0'='1'| Pf_~ STACI? Nu1 &??? getRefDisp J(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object;? java/lang/Double ?Æ? OR PrdFamilleProduit_ = ? [GetPrdCodesFromContract] : #??9 add prdcodes canlocens qCot prdFamiValues flag Ljava/lang/Double; getPrdCodesFromSubContract? [GetPrdCodesFromSubContract] : getAllAffiliates 3(Lcom/edeal/frontline/FlContext;)Ljava/util/Vector;? +SELECT Distinct Ct_ID,Ct_CodeContrat,EntID ? ? AND Ct_CodeContrat IS NOT NULL AND Ct_ContratPrincipal IS NULL? [getAllAffiliates] sql query:¡ ('')£ Sales.Contrat.Types.Passerelle¥ 4Le paramètre GiftCheque_Decalage doit être défini ?§¨ *(Ljava/lang/Object;Ljava/lang/Throwable;)V ª¬« #org/apache/commons/lang/StringUtils ? isNotBlank¯ ; '±²³ split '(Ljava/lang/String;)[Ljava/lang/String;µ ( D Ï DR optPasserelleReservit types ct getPrdCodesFromContractForCotTab½ Tye '¿J entTye entTyeValues initContrat_Bean_ |(Lcom/edeal/frontline/FlContext;Ljavax/servlet/http/HttpSession;Ljava/lang/String;)Lcom/edeal/frontline/custom/Contrat_Bean; ªÅÆ ? isBlank ?È É #(Ljavax/servlet/http/HttpSession;)V ?Ë Ì "(Lcom/edeal/frontline/FlContext;)V ?Î Ï 5(Ljava/lang/String;Ljavax/servlet/http/HttpSession;)V ?Ñ Ò 4(Ljava/lang/String;Lcom/edeal/frontline/FlContext;)VÔ %Contrat_Helper initEnterpriseBean_ : Ö $Contrat_Helper initEnterpriseBean_ :Ø )com/edeal/frontline/AccessDeniedException session Ljavax/servlet/http/HttpSession; idEntite ade +Lcom/edeal/frontline/AccessDeniedException; getAllLogisEcheanToResend E(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Ljava/util/Vector; ?(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Ljava/util/Vector<Ljava/util/Hashtable<Ljava/lang/String;Ljava/lang/String;>;>;â BSelect distinct EntID, c.mvatext as PerID , OppID From Enterprise ä / INNER JOIN MvaSg_Tiers t on t.MvaText = EntID æ , INNER JOIN Signataire_ ON Sg_ID = MvaColID è 3 INNER JOIN mvasg_contact c on c.mvacolid = sg_id ê + INNER JOIN Contrat_ ON Sg_Contrat = Ct_ID ì 1 inner join Refvalues r1 ON r1.RefID = Ct_Statut î 6 INNER JOIN Refvalues r2 ON r2.RefID = Ct_TypeContrat ð C INNER JOIN comptafil_facture on Ct_CodeContrat::varchar = ent_codeò / inner join opportunity on EntCotDevID_= oppid ô . inner join refvalues s ON s.refid = oppstoid ö 0 inner join refvalues m on Ct_ModeReg = m.refid ø WHERE r1.RefVal = 'VAL' ú AND r2.RefVal = 'L' ü ! AND Ct_ContratPrincipal IS NULL þ AND num_reservation = AND s.refval = 'FAC' and oppmillesime_ = 5 and ct_contratprincipal IS NULL AND m.refval = 'MS' sqlQuery : y getConnection ()Ljava/sql/Connection; java/sql/Connection createStatement ()Ljava/sql/Statement; java/sql/Statement executeQuery ((Ljava/lang/String;)Ljava/sql/ResultSet; java/sql/ResultSet } getString L ? isNullEmptyString PerID" OppID ?$%& put 8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;(3J* +Erreur lors d'exécution de la requete SQL ,- close,,1 java/sql/SQLException millesime results con Ljava/sql/Connection; stmt Ljava/sql/Statement; rs Ljava/sql/ResultSet; Ljava/sql/SQLException; OLjava/util/Vector<Ljava/util/Hashtable<Ljava/lang/String;Ljava/lang/String;>;>; ;Ljava/util/Hashtable<Ljava/lang/String;Ljava/lang/String;>;> java/lang/Throwable getAllActifL_C_SContractID G(Lcom/edeal/frontline/FlContext;)Ljava/util/Vector<Ljava/lang/String;>;B SELECT Distinct EntID D F WHERE (r2.RefVal = 'L' OR r2.RefVal = 'C' OR r2.RefVal = 'SWADESHI') F '[getAllActifL_C_SContractID] sql query: SourceFile Contrat_Helper.java ! , ) ¸ ³ ± >