Edit C:\Users\Administrator\Desktop\Back\Livraison EVQG22\com\edeal\frontline\helper\custom\Contrat_Helper.class
Êþº¾ 3¯ 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 OppNumFact_ IS NULL u EntMbm w y x com/edeal/frontline/FlContext z { 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' w 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;,.- java/util/Iterator/ í next1 S '345 equals (Ljava/lang/Object;)Z7 Ct_TypeContrat "9:; getRefCode 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; '= m> &(Ljava/lang/Object;)Ljava/lang/String;@ B ,,DEF hasNext ()Z HI W getMessage ?KL ? warn 'NOP 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 &c ASELECT Distinct Ct_ID,Ct_CodeContrat,Ct_ContratPrincipal,Ct_CrDt e FROM Contrat_ g . inner join Signataire_ ON Sg_Contrat = Ct_ID i , inner join MvaSg_Tiers ON MvaColID = Sg_ID k * inner join Enterprise ON EntID = MvaText m 1 inner join Refvalues r1 on r1.RefID = Ct_Statut o 6 inner join Refvalues r2 on r2.RefID = Ct_TypeContrat q WHERE (r2.RefVal = 'L') s AND EntID = u ) order by Ct_CrDt descw [getActifContractID] sql query:y 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 ( ?Z _? 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 ?¼½5 containsKey j¿À ? intValue j Và (I)Ljava/lang/String;Å [getAffiliateNumber] sql query: code getAffiliateNumberByPersonIDÉ +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 Ñ AND PerID = perID "getAffiliateNumberByPersonID_onlyL getAffiliateType Ö_ 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 äçèF 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 = Cr_Etat OUV "; getRefIdByCode [getNbEnseignes] : ? .com/edeal/frontline/custom/ContratProduit_Bean java/lang/Long longValue ()J (J)V ¿ PrdMaxQt_ !Ý" com/edeal/frontline/ProductBean$ Cannot find any enseigne prdID ensnb ens ensnbMax getNbEnseignesSubContracts X(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)I ,??. ProID0 CSELECT Distinct (ProID) As ProID ,ProQuantity From ContratProduit_ 2 0 INNER JOIN Opportunity ON OppID = Cr_Commande_ 4 : INNER JOIN ProductOpportunity ON ProOppID = Cr_Commande_ 6 WHERE Cr_Contrat = 8 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;>; =àá? PrdIDA +SELECT Distinct PrdID From ContratProduit_ C * INNER JOIN Product ON PrdID = Cr_Produit E + INNER JOIN Contrat_ ON Ct_ID = Cr_Contrat G AND PrdIncludedInCot_ = 1 I AND ( '0'='1'K Pf_M STACIO Nu1 "QRS getRefDisp J(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object;U java/lang/Double T¿X OR PrdFamilleProduit_ = Z [GetPrdCodesFromContract] : #\]5 add prdcodes canlocens qCot prdFamiValues flag Ljava/lang/Double; getPrdCodesFromSubContractf [GetPrdCodesFromSubContract] : getAllAffiliates 3(Lcom/edeal/frontline/FlContext;)Ljava/util/Vector;j +SELECT Distinct Ct_ID,Ct_CodeContrat,EntID l ? AND Ct_CodeContrat IS NOT NULL AND Ct_ContratPrincipal IS NULLn [getAllAffiliates] sql query:p ('')r Sales.Contrat.Types.Passerellet 4Le paramètre GiftCheque_Decalage doit être défini ?v w *(Ljava/lang/Object;Ljava/lang/Throwable;)V y{z #org/apache/commons/lang/StringUtils| ? isNotBlank~ ; '??? split '(Ljava/lang/String;)[Ljava/lang/String;? ( D Í DN optPasserelleReservit types ct getPrdCodesFromContractForCotTab? Tye '?ÙF entTye entTyeValues initContrat_Bean_ |(Lcom/edeal/frontline/FlContext;Ljavax/servlet/http/HttpSession;Ljava/lang/String;)Lcom/edeal/frontline/custom/Contrat_Bean; y?? ? 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; SourceFile Contrat_Helper.java ! % ) ¸ ³ ± >