Edit C:\Users\Administrator\Desktop\CGI\LIVRAISONS\V1.6.2\Livraison_20230307\02-APPLI\WEB-INF\classes\com\edeal\frontline\helper\custom\Contrat_Helper.class
Êþº¾ 3B 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 Ò )inner 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 ë 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;.0/ java/util/Iterator1 ï next3 S '567 equals (Ljava/lang/Object;)Z9 Ct_TypeContrat $;<= getRefCode 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; '? m@ &(Ljava/lang/Object;)Ljava/lang/String;B D ,.FGH hasNext ()Z JK W getMessage ?MN ? warn 'PQR 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 &e ASELECT Distinct Ct_ID,Ct_CodeContrat,Ct_ContratPrincipal,Ct_CrDt g FROM Contrat_ i . inner join Signataire_ ON Sg_Contrat = Ct_ID k , inner join MvaSg_Tiers ON MvaColID = Sg_ID m * inner join Enterprise ON EntID = MvaText o 1 inner join Refvalues r1 on r1.RefID = Ct_Statut q 6 inner join Refvalues r2 on r2.RefID = Ct_TypeContrat s , WHERE (r2.RefVal = 'L' OR r2.RefVal = 'C') u AND EntID = w ) order by Ct_CrDt descy [getActifContractID] sql query:{ Ct_CodeContrat} Ct_ContratPrincipal Ct_CrDt ? ?? 'com/edeal/frontline/custom/Contrat_Bean ctID cts now Ljava/lang/StringBuilder; queryWhere flds line 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 ?¾¿7 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 a 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 H booleanValue canLocEns getContratNbRooms 4(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)I 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_) * GROUP BY Cr_Contrat, Cr_Produit, Cr_Etat + HAVING Cr_Produit = - AND Cr_Contrat = / AND Cr_Etat = 1 Cr_Etat3 OUV $56= getRefIdByCode8 [getNbEnseignes] : : <