Edit C:\Users\Administrator\Desktop\CGI\BACKUPS\V1.6.3\Backup_20230509\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Þ INIT PERSON STARTED:à com.edeal.frontline.PersonBeanâ com/edeal/frontline/PersonBean á ûå per 6ç =è -(Ljava/lang/Object;)Ljava/lang/StringBuilder;ê Person jì?x iñ DIR óô« startsWithö RECEPTø CHEFCUISINE úûü split '(Ljava/lang/String;)[Ljava/lang/String;þ lfqCodeVals pers á W getPerEntID 2com/edeal/frontline/helper/custom/EnterpriseHelper q getEntPerByFuncCode? perId| ITS ELSE PerName ITS PERNAME á W getPerCivID val RelTe1 RelRefID = ' ' RelLngID = '! EntRefLngID_# RelTe1 ASC % ?& !com/edeal/frontline/RefLocaleBean ß) list£?- value.toString()?0 REEEF2 lfqCode14 lfqCode26 perFctCode8 values.elementAt(r) perID Lcom/edeal/frontline/PersonBean; fields orderBy initMarqueQrs? MarqueA &com.edeal.frontline.custom.Marque_BeanC java/util/Date B FHG 0com/edeal/frontline/helper/custom/Contrat_HelperI H getContratPrincipaleCt_IDK 'com/edeal/frontline/custom/Contrat_Bean J û JNO W getCt_TypeContrat JQR W getCt_MarqueT ^[GuideGenerationHelper - initMarqueQrs] - error lors de la récupération du ct.getCt_Marque() YVW ] errorY &com/edeal/frontline/custom/Marque_Bean X û\ 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; initContractQrsm 'com.edeal.frontline.custom.Contrat_Beano Contrat_ Fqr H getActifContractID initEquipmentsQrsu Equipement_ w ?yz{ entrySet ()Ljava/util/Set;} ?~ java/util/Set? Eq_TiersID = }??? iterator ()Ljava/util/Iterator;??? java/util/Iterator?? next ()Ljava/lang/Object;? java/util/Map$Entry???? getKey???? getValue? :RefVal? in ( ??? ,com/edeal/frontline/helper/custom/FormHelper?? formatLfqQueryToSQL E(Lcom/edeal/frontline/FlContext;Ljava/util/Vector;)Ljava/lang/String;? )? ¡w hasNext£ Eq_NameID ¥ |¦ *com/edeal/frontline/custom/Equipement_Bean hashQr k entry Ljava/util/Map$Entry; key Flds vects eqName 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/ PrxMax1 PrxPrestationID 3 |4 %com/edeal/frontline/custom/Price_Bean6 PrxPrestationID:SET ??9 java/lang/Double 8;<= 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;)IM Eh_ OEF e_VAL vals t_VAL E1orE2 get_LFQ_IDofThemaV FSELECT LfqID FROM linkformquestion WHERE lfqquery_ like 'EntThema_:%' X AND lfqformid = Z ORDER BY LfqPosition limit 1 \ &[get lfqid of lfq entThema] sql query: cts initAutresLabels` Ol_LibelleTRb Ol_Tiers = d Ol_Millesime = f |g )com/edeal/frontline/custom/OtherLbls_Beani @SELECT LfqID,LfqQuery_ from LinkFormQuestion WHERE LfqFormID = k OtherLbls_m AND LfqQuery_ like o Ol_LibelleTR:% ý ? oLabels refCode LfqQuery labelsCodes instance code 9Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/String;>; initThemaOfEnvies zT H| java/lang/StringBuffer { .DELETE FROM questionresponse where qrslfqid = ? AND qrsfrpid = ? ; {? =? ,(Ljava/lang/String;)Ljava/lang/StringBuffer; ¨??? getConnection ()Ljava/sql/Connection;??? java/sql/Connection?? createStatement ()Ljava/sql/Statement; { U??? java/sql/Statement?« execute??? close??? 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_ çJKé 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 á%&