Edit C:\Users\Administrator\Desktop\CGI\LIVRAISONS\v1.6.4\02-APPLI\WEB-INF\classes\com\edeal\frontline\helper\custom\GuideGenerationHelper.class
Êþº¾ 3 7com/edeal/frontline/helper/custom/GuideGenerationHelper java/lang/Object 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> this 9Lcom/edeal/frontline/helper/custom/GuideGenerationHelper; getLfqByCodeAndName i(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector; Exceptions &com/edeal/frontline/FrontlineException )com/edeal/frontline/AccessDeniedException ! java/lang/String # LfqID % LfqLnkFrmQtParentID_ ' LfqStoredInFldID_ ) LfqStoreInObjID_ + LfqFormQuestionID - LfqPosition / LfqCode_ 1 LfqName_ 3 LfqValue_ 5 LfqQuery_ 7 java/lang/StringBuilder 6 : Eselect LfqID,LfqLnkFrmQtParentID_,LfqStoredInFldID_,LfqStoreInObjID_, 6 < = > append -(Ljava/lang/String;)Ljava/lang/StringBuilder; @ ZLfqFormQuestionID,LfqPosition,LfqCode_,LfqName_,LfqValue_,LfqQuery_ from LinkFormQuestion B where LfqFormID = D F E com/edeal/frontline/Utils G H formatToSQL E(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Ljava/lang/String; J AND LfqName_ = L AND LfqCode_ = N order by LfqPosition ASC P lfq query :: 6 R S (Ljava/lang/String;)V 6 U V W toString ()Ljava/lang/String; Y [ Z org/apache/commons/logging/Log \ ] info (Ljava/lang/Object;)V _ a ` (com/edeal/frontline/LinkFormQuestionBean b c listSQL X(Lcom/edeal/frontline/FlContext;[Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector; context Lcom/edeal/frontline/FlContext; formID Ljava/lang/String; lfqName lfqCode lfqs Ljava/util/Vector; keys [Ljava/lang/String; sqlQuery Ljava/lang/StringBuilder; +checkOrCreateLfqProductOpportunityByPrdCode W(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; m t LfqFormID = v LfqCode_ = x LfqName_ = z ProductOpportunity _ | } ~ listSummary Z(Lcom/edeal/frontline/FlContext;[Ljava/lang/String;[[Ljava/lang/String;)Ljava/util/Vector; ? ? ? java/util/Vector ? ? size ()I ? ? ? ? elementAt (I)Ljava/lang/Object; ? java/util/Hashtable ? ? ? ? get &(Ljava/lang/Object;)Ljava/lang/Object; ? ? ? java/lang/Exception ? printStackTrace ? LfqPosition DESC _ ? } ? m(Lcom/edeal/frontline/FlContext;[Ljava/lang/String;[[Ljava/lang/String;[Ljava/lang/String;)Ljava/util/Vector; ? java/lang/Integer ? ? ? ? intValue ? FqtID ¡ FqtLabel = £ Hidden ¥ | ¦ $com/edeal/frontline/FormQuestionBean ¨ ª © com/edeal/frontline/FlContext « ¬ getDataDictionary &()Lcom/edeal/frontline/DataDictionary; ® Nlf ° Te1 ² LFQHIDE ´ ¶ µ "com/edeal/frontline/DataDictionary · ¸ getRefIdByCode J(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; _ º » "(Lcom/edeal/frontline/FlContext;)V _ ½ ¾ S setLfqFormID _ À Á S setLfqFormQuestionID _ Ã Ä Å setLfqPosition (I)V _ Ç È É setCustomProperty '(Ljava/lang/String;Ljava/lang/Object;)V Ë LfqNatureID_ Í LfqIsInit_ Ï Ñ Ð java/lang/Boolean Ò Ó valueOf (Z)Ljava/lang/Boolean; Õ LfqHtmlDisabled_ _ × Ø Ù save '()Lcom/edeal/frontline/OperationResult; _ Û Ü W getLfqID prdCode flds query [[Ljava/lang/String; result depline Ljava/util/Hashtable; e Ljava/lang/Exception; position I flds2 query2 orderby2 result2 flds3 query3 result3 lfqnatureid_ e1 lfq *Lcom/edeal/frontline/LinkFormQuestionBean; StackMapTable initLfqCotisation |(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/HashMap; Signature Ë(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/HashMap<Ljava/lang/String;Ljava/util/Hashtable<Ljava/lang/String;Ljava/lang/Object;>;>; ù "com/edeal/frontline/EnterpriseBean ø û ü 4(Ljava/lang/String;Lcom/edeal/frontline/FlContext;)V þ java/util/HashMap ý ProID ProOppID ProPrdID ProPrdID:PrdCode ProQuantity ProDesignation ProPrice ProRemise_ ProPrdID:PrdTVADefaut_ ProMontantTva_ ProUnitHTrem_ ProMontantHTrem_ ProPrdTaxeParafiscale_ ProMontantTpf_ ProPrdID:PrdCode ASC EntCotDevID_ ø!"# getCustomProperty &(Ljava/lang/String;)Ljava/lang/Object;% (com/edeal/frontline/QuestionResponseBean $ º $() S setQrsFrpID+ Opportunity- FIL / $12 S setQrsLfqID $45 S setQrsText $ ×8 ProOppID = : ?; *com/edeal/frontline/ProductOpportunityBean ?> "OppCompteClient_:Ct_NombreChambres @BA #com/edeal/frontline/OpportunityBeanCD lookup W(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object;F C********** FormHelper : initLfqCotisation : nombre d'hebergement : 6H =I (I)Ljava/lang/StringBuilder;K ;********** FormHelper : initLfqCotisation : entCotDevID_ : M W********** FormHelper : initLfqCotisation : nombre d'hebergement non initialis� : ?OP W getMessage YRS ] warnU EntCotAssoDevID_W DEPY S********** FormHelper : initLfqCotisation : nombre d'hebergement apr�s test : [ W********** FormHelper : initLfqCotisation : nombre d'hebergement,prdCode,proQuantity : ] ,_ Pl_a COTHEBc PrdRegles_ eBf com/edeal/frontline/ProductBean hji java/lang/Systemkl out Ljava/io/PrintStream;n PrdRegles_= prq java/io/PrintStreams S println uvw isEmpty ()Z yz{ equals (Ljava/lang/Object;)Z } p q $? Å setQrsInstance? ? Ò? (I)Ljava/lang/String; ý??{ containsKey ý??? put 8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object; frpID entID pTypeLogis ent $Lcom/edeal/frontline/EnterpriseBean; dico $Lcom/edeal/frontline/DataDictionary; entCotAssoDevID_ entCotDevID_ cotisation Ljava/util/HashMap; prodep profil orderby qrs *Lcom/edeal/frontline/QuestionResponseBean; lfqID fe (Lcom/edeal/frontline/FrontlineException; nbHebergements depLfqID i line prdID proID proQuantity depProID lfqProID qrs1 qrs2 qrs3 LocalVariableTypeTable bLjava/util/HashMap<Ljava/lang/String;Ljava/util/Hashtable<Ljava/lang/String;Ljava/lang/Object;>;>; à initEnterpriseAddress j(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V² ²SELECT LfqID,LfqLnkFrmQtParentID_,LfqStoredInFldID_,LfqStoreInObjID_,LfqFormQuestionID,LfqPosition,LfqCode_,LfqName_,LfqValue_,LfqQuery_ FROM LinkFormQuestion WHERE LfqFormID = ´ AND LfqName_ = 'Enterprise'¶ : AND LfqCode_ = 'EntVoieNum_|EntNatureVoieID_|EntLblVoie_'¸ ORDER BY LfqPosition ASCº EntVoieNum_ øB ½¾ W trimÀ (FormHelper:initEnterpriseAddress (EntID= ): EntVoieNum_ is null.Ä nullÆ EntNatureVoieID_:ValÈ ): EntNatureVoieID_:Val is null.Ê EntLblVoie_Ì ): EntLblVoie_ is null.Î EntGeoCplt_Ð EntBP_Ò EntLieuDit_Ô EntAd1Ö EntAd2 Ø ÒÙ &(Ljava/lang/Object;)Ljava/lang/String;Û Ý + ßàá replaceAll 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; ãä ? length typeTiers entVoieNum natureVoie lblVoie entgeocplt_ address1 address2 row adr_qrs ;Ljava/util/Hashtable<Ljava/lang/String;Ljava/lang/Object;>; getLfqsListñ Tó 4 AND (lfqtypetiers_ is null OR lfqtypetiers_ like '% õö÷ charAt (I)C 6ù =ú (C)Ljava/lang/StringBuilder;ü %')þ ´SELECT LfqID,LfqLnkFrmQtParentID_,LfqStoredInFldID_, LfqStoreInObjID_,LfqFormQuestionID,LfqPosition, LfqCode_,LfqName_,LfqValue_,LfqQuery_ from LinkFormQuestion WHERE LfqFormID = filter W(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector; ï buildLfqQueryHash H(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Ljava/util/Hashtable; ?(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Ljava/util/Hashtable<Ljava/lang/String;Ljava/util/Vector<Ljava/lang/String;>;>; ? | D explodeList 8(Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector; : # ?? lfqQuery lfqQueries q vq OLjava/util/Hashtable<Ljava/lang/String;Ljava/util/Vector<Ljava/lang/String;>;>; &Ljava/util/Vector<Ljava/lang/String;>; initLocaliteQrs X(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V java/lang/IllegalAccessException java/lang/ClassNotFoundException java/lang/NoSuchMethodException! +java/lang/reflect/InvocationTargetException# (com.edeal.frontline.custom.Localite_Bean %'& java/lang/Class() forName %(Ljava/lang/String;)Ljava/lang/Class;+ EntLocalityID_- (com/edeal/frontline/custom/Localite_Bean , û ,01 W getLo_Dep3 Dp_5 Te2 ´789 getRefDisp J(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object;; Rg_= Ctr? Localite_ Aï C FqtType ¥B ´FGá getRefCodeI FqtDispTypeK FREC %NOP getMethod @(Ljava/lang/String;[Ljava/lang/Class;)Ljava/lang/reflect/Method; RTS java/lang/reflect/MethodUV invoke 9(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; UY Localite [ ] REF_ Lo_Pays $ab S setQrsRefValIDd Lo_Reg ? g COMBO ?ij{ addl 0com/edeal/frontline/FieldNotInitializedException c Ljava/lang/Class; loca *Lcom/edeal/frontline/custom/Localite_Bean; locID regID paysID depid regVal paysVal p lfqFormQuestionID questionType dispType codes value Ljava/lang/Object; paramTypes [Ljava/lang/Class; mlookup Ljava/lang/reflect/Method; args [Ljava/lang/Object; values r? initEnterpriseQrs? "com.edeal.frontline.EnterpriseBean? Enterprise ??? contains (Ljava/lang/CharSequence;)Z? EntThema_? EntNatureVoieID_ ´??? getFieldByName 3(Ljava/lang/String;)Lcom/edeal/frontline/FieldBean;? FldFltID ??? com/edeal/frontline/FieldBean? W getFldFltID ¡£¢ ,com/edeal/frontline/dataimport/BeanOutSource¤¥ getJavaType &(Ljava/lang/String;)Ljava/lang/String;§ java.lang.Boolean ©ª« equalsIgnoreCase (Ljava/lang/String;)Z EntPtitDej_ ϯ°w booleanValue² YNO´ Val¶ NO2¸ OUIº ATTFILE¼ EntPhotoID_¾ %com/edeal/frontline/custom/Photo_Bean ½ ûÁ Po_Apercu ½ÃÄ W getID ½BÇ EntPhoto2ID_É EntSegRes_Ë EntRatachHotelID_ DÍΫ isNullEmptyString fldbean Lcom/edeal/frontline/FieldBean; strType ptitDej Z refval attID photoID photo 'Lcom/edeal/frontline/custom/Photo_Bean; entRatachHotelID_ entParent entSegRes initPersonQrsÞ com.edeal.frontline.PersonBeanà com/edeal/frontline/PersonBean ß ûã Personå DIR çè« startsWithê RECEPTì CHEFCUISINE îïð split '(Ljava/lang/String;)[Ljava/lang/String; ßòó W getPerEntID õ÷ö 2com/edeal/frontline/helper/custom/EnterpriseHelperø q getEntPerByFuncCodeú PerName ßüý W getPerCivIDÿ RelTe1 RelRefID = ' ' RelLngID = ' EntRefLngID_ 6 = -(Ljava/lang/Object;)Ljava/lang/StringBuilder; RelTe1 ASC ? !com/edeal/frontline/RefLocaleBean perID per Lcom/edeal/frontline/PersonBean; lfqCodeVals perFctCode pers perId val fields orderBy list initMarqueQrs Marque &com.edeal.frontline.custom.Marque_Bean! java/util/Date $&% 0com/edeal/frontline/helper/custom/Contrat_Helper' H getContratPrincipaleCt_ID) 'com/edeal/frontline/custom/Contrat_Bean ( û (,- W getCt_TypeContrat (/0 W getCt_Marque2 ^[GuideGenerationHelper - initMarqueQrs] - error lors de la récupération du ct.getCt_Marque() Y45 ] error7 &com/edeal/frontline/custom/Marque_Bean 6 û: Ma_Nom< X[GuideGenerationHelper - initMarqueQrs] - error l'ors de l'initalisation du champ Ma_Nom> i[GuideGenerationHelper - initMarqueQrs] - error l'ors de l'initalisation des champs liée au objet Marque m now Ljava/util/Date; ct_ID ct )Lcom/edeal/frontline/custom/Contrat_Bean; type_contrat marqueID mr (Lcom/edeal/frontline/custom/Marque_Bean; initContractQrsK 'com.edeal.frontline.custom.Contrat_BeanM Contrat_ $OP H getActifContractID initEquipmentsQrsS Equipement_ U ?WXY entrySet ()Ljava/util/Set;[ ?\ java/util/Set^ Eq_TiersID = [`ab iterator ()Ljava/util/Iterator;dfe java/util/Iteratorgh next ()Ljava/lang/Object;j java/util/Map$Entryilmh getKeyioph getValuer :RefValt in ( vxw ,com/edeal/frontline/helper/custom/FormHelperyz formatLfqQueryToSQL E(Lcom/edeal/frontline/FlContext;Ljava/util/Vector;)Ljava/lang/String;| )d~w hasNext? Eq_NameID ? |? *com/edeal/frontline/custom/Equipement_Bean? Eq_prix_min_|Eq_prix_max_? Eq_prix_min_? Eq_prix_max_ ??? java/lang/Double ? U hashQr k entry Ljava/util/Map$Entry; key Flds vects eqName eqVal OLjava/util/Map$Entry<Ljava/lang/String;Ljava/util/Vector<Ljava/lang/String;>;>; initFerYearHotel? FerPlageBgDt? FerPlageEndDt? FerTiersID = ¡ FerMillesime = ?£ Ò¤ '(Ljava/lang/String;)Ljava/lang/Integer;¦ FerIsHebdo = 0 ¨ FerCategorie = ª FerCategorie¬ HOTEL ´® ·á ° |± *com/edeal/frontline/custom/Fermetures_Bean³ ISELECT LfqID,LfqQuery_,LfqCode_ from LinkFormQuestion WHERE LfqFormID = µ Fermetures_· FerPlageBgDt|FerPlageEndDt¹ AND LfqQuery_ = » FerCategorie:HOTEL½ query: pMillesime l ferPlageBg ferPlageEnd initFerYearRestoÄ RESTOÆ FerCategorie:RESTO initFerHebdoRestoÉ FerCommentsË FerIsHebdo = 1 initFerHebdoHotel initTextesÏ Textes_Ñ RÓ TxtTiersID = Õ TxtContent × |Ø &com/edeal/frontline/custom/Textes_Bean txtContent initTimeTables |(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)VÝ Horaires_ ?ßàá parseInt (Ljava/lang/String;)I ?ã Òä (I)Ljava/lang/Integer;æ TimTiersID = è TimMillesime = Dê Gë E(Lcom/edeal/frontline/FlContext;Ljava/lang/Number;)Ljava/lang/String;í TimPlageBgTimeï TimPlageEndTimeñ TimSecPlageBgTimeó TimSecPlageEndTimeõ TimIsOpen24h÷ TimIsClosed ù |ú *com/edeal/frontline/custom/Timetables_Bean ?uý 00:00ÿ 00:01 23:59 CHIN CHOUT millesime Ljava/lang/Integer; isOpen24h isClosed timPlageBgTime timPlageEndTime timSecPlageBgTime timSecPlageEndTime initPriceQrs Price_ PrxTiersID = PrxMillesime = PrxMin PrxMax PrxPrestationID | %com/edeal/frontline/custom/Price_Bean PrxPrestationID:SET ?!"# doubleValue ()D % Ò& (D)Ljava/lang/String; millesimeGuide prxMin D prxMax insertThematique Y(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;I)V themaID n thema addThematique ?(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;ILjava/lang/String;)I3 Eh_ 5+, e_VAL vals t_VAL E1orE2 get_LFQ_IDofThema< FSELECT LfqID FROM linkformquestion WHERE lfqquery_ like 'EntThema_:%' > AND lfqformid = @ ORDER BY LfqPosition limit 1 B &[get lfqid of lfq entThema] sql query: cts initAutresLabelsF Ol_LibelleTRH Ol_Tiers = J Ol_Millesime = L |M )com/edeal/frontline/custom/OtherLbls_BeanO @SELECT LfqID,LfqQuery_ from LinkFormQuestion WHERE LfqFormID = Q OtherLbls_S AND LfqQuery_ like U Ol_LibelleTR:% ý ? oLabels refCode LfqQuery labelsCodes instance code 9Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/String;>; initThemaOfEnvies `: Hb java/lang/StringBuffer a e .DELETE FROM questionresponse where qrslfqid = g AND qrsfrpid = i ; ak =l ,(Ljava/lang/String;)Ljava/lang/StringBuffer; ¨nop getConnection ()Ljava/sql/Connection;rts java/sql/Connectionuv createStatement ()Ljava/sql/Statement; a Uy{z java/sql/Statement|« executey~ closer~? BIENETRE? EAUMER? NEIGE? FAMENF? MOT? RANDPED? VELO? AMOUR? GOURMAND? INSO? GOLF? OENOLOGIE? SPA? SPAEXC? GOLF1 OENOTOURISME¢ ENVDOUCE¤ ENVMER¦ ENVEAU¨ SKIª SEJFAM¬ MOTO® RANDO° GOURM² OENO´ (¶ ,¸ ) º # select envcategoryid from envies_ ¼ E left join refvalues r1 on r1.refid = envcategoryid and r1.refval in ¾ where EnvTiersID = 'À 6' and envsubcategoryid is null and refval is not null  [get e1] sql query:Ä envcategoryid Æ aÇ &com/edeal/frontline/custom/Envies_BeanÉ ;Ë E1_ Í01Ï java/sql/SQLException Ljava/lang/StringBuffer; con Ljava/sql/Connection; stmt Ljava/sql/Statement; thematiques envies listEnvies e1_vals cts_e1 sqlQuery_e1 flds_e1Ý java/lang/Throwable createPersonEventIfDoesntExistà PvtIDâ SELECT PvtID FROM personeventä + INNER JOIN form ON frmeventid = pvteventidæ ) INNER JOIN person ON pvtpersonid = peridè WHERE perentid = ê AND frmid = ì pvt query :: î aï #com/edeal/frontline/PersonEventBeanñ PvtPersonID îB ôõ updatePvtForGeneration ÷ø H getPersonFromEnterprise ß º ßûü S setPerEntIDþ PerFctID EXPL ß S setPerFctID ß S setPerCivID ß W getPerFstName ß S setPerFstName _ ß W getPerName ß S setPerName ß × ßà FrmEventID B com/edeal/frontline/FormBean î º î S setPvtPersonID î!"