Edit C:\Users\Administrator\Desktop\galaxie\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 X(Lcom/edeal/frontline/FlContext;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 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 = typeTiers 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 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 + û +/0 W getLo_Dep2 Dp_4 Te2 ´678 getRefDisp J(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object;: Rg_< Ctr> Localite_ @î B FqtType ¥B ´EFá getRefCodeH FqtDispTypeJ FREC $MNO getMethod @(Ljava/lang/String;[Ljava/lang/Class;)Ljava/lang/reflect/Method; QSR java/lang/reflect/MethodTU invoke 9(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; UX Localite Z \ REF^ Lo_Pays $`a S setQrsRefValIDc Lo_Reg ? f COMBO ?hi{ addk 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 j(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V? "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å PerName ßçè W getPerEntID ßêë 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; val pers fields orderBy list initContractQrs 'com.edeal.frontline.custom.Contrat_Bean Contrat_ 0com/edeal/frontline/helper/custom/Contrat_Helper H getActifContractID 'com/edeal/frontline/custom/Contrat_Bean û ct_ID ct )Lcom/edeal/frontline/custom/Contrat_Bean; initEquipmentsQrs Equipement_ ? entrySet ()Ljava/util/Set; ?! java/util/Set# Eq_TiersID = %&' iterator ()Ljava/util/Iterator;)+* java/util/Iterator,- next ()Ljava/lang/Object;/ java/util/Map$Entry.12- getKey.45- getValue7 :RefVal9 in ( ;=< ,com/edeal/frontline/helper/custom/FormHelper>? formatLfqQueryToSQL E(Lcom/edeal/frontline/FlContext;Ljava/util/Vector;)Ljava/lang/String;A ))CDw hasNextF Eq_NameID H |I *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;>;>; initFerYearHotelU FerPlageBgDtW FerPlageEndDtY FerTiersID = [ FerMillesime = ?] Ò^ '(Ljava/lang/String;)Ljava/lang/Integer;` FerIsHebdo = 0 b FerCategorie = d FerCategorief HOTEL ´h ·á j |k *com/edeal/frontline/custom/Fermetures_Beanm ISELECT LfqID,LfqQuery_,LfqCode_ from LinkFormQuestion WHERE LfqFormID = o Fermetures_q FerPlageBgDt|FerPlageEndDts AND LfqQuery_ = u FerCategorie:HOTELw query: pMillesime l ferPlageBg ferPlageEnd initFerYearResto~ RESTO? FerCategorie:RESTO initFerHebdoResto? FerComments? FerIsHebdo = 1 initFerHebdoHotel initPriceQrs |(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V? Price_ ???? parseInt (Ljava/lang/String;)I ?? Ò? (I)Ljava/lang/Integer;? PrxPrestationID:SET ? U? PrxTiersID = ? PrxMillesime = D? G? E(Lcom/edeal/frontline/FlContext;Ljava/lang/Number;)Ljava/lang/String;? PrxMin? PrxMax¡ PrxPrestationID £ |¤ %com/edeal/frontline/custom/Price_Bean ??§ java/lang/Double ¦©ª« doubleValue ()D Ò® (D)Ljava/lang/String; millesime Ljava/lang/Integer; 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;)I½ Eh_ ¿µ¶ e_VAL vals t_VAL E1orE2 get_LFQ_IDofThemaÆ FSELECT LfqID FROM linkformquestion WHERE lfqquery_ like 'EntThema_:%' È AND lfqformid = Ê ORDER BY LfqPosition limit 1 Ì &[get lfqid of lfq entThema] sql query: cts initAutresLabelsÐ Ol_LibelleTRÒ Ol_Tiers = Ô Ol_Millesime = Ö |× )com/edeal/frontline/custom/OtherLbls_BeanÙ @SELECT LfqID,LfqQuery_ from LinkFormQuestion WHERE LfqFormID = Û OtherLbls_Ý AND LfqQuery_ like ß Ol_LibelleTR:% áâã split '(Ljava/lang/String;)[Ljava/lang/String; ý ? oLabels refCode LfqQuery labelsCodes instance code 9Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/String;>; initThemaOfEnvies îÄ 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. OENOTOURISME0 BNETRE2 ENVEAU4 NGE6 SEJFAM8 MOTO: RANDO< GOURM> (@ ,B ) D # select envcategoryid from envies_ F E left join refvalues r1 on r1.refid = envcategoryid and r1.refval in H where EnvTiersID = 'J 6' and envsubcategoryid is null and refval is not null L [get e1] sql query:N envcategoryid P aQ &com/edeal/frontline/custom/Envies_BeanS ;U E1_ Wº»Y java/sql/SQLException Ljava/lang/StringBuffer; con Ljava/sql/Connection; stmt Ljava/sql/Statement; thematiques envies listEnvies e1_vals cts_e1 sqlQuery_e1 flds_e1g java/lang/Throwable createPersonEventIfDoesntExistj PvtIDl SELECT PvtID FROM personeventn + INNER JOIN form ON frmeventid = pvteventidp ) INNER JOIN person ON pvtpersonid = peridr WHERE perentid = t AND frmid = v pvt query :: x ay #com/edeal/frontline/PersonEventBean{ PvtPersonID xB ~° 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 x º x¨© S setPvtPersonID x«¬ S setPvtEventID® PvtInsStatus° TOSEND x²³ S setPvtInsStatusµ PvtParStatus· NORES x¹º S setPvtParStatus¼ PvtFinStatus_¾ PRN x Ç x × xà ÃÄÅ updatePerToken 4(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)V tiersID pvtID res parentPerID parentPer newPer fnie 2Lcom/edeal/frontline/FieldNotInitializedException; evtID newPvt %Lcom/edeal/frontline/PersonEventBean;Ò PerIDÔ SELECT perid FROM personÖ * INNER JOIN enterprise ON entid = perentidØ ) INNER JOIN refvalues ON refid = perfctidÚ WHERE refval = 'EXPL' Ü 3 AND (PerFctExitDt IS NULL OR PerFctExitDt > NOW())Þ AND entid = à ORDER BY perupd DESCâ LIMIT 1ä per query :: æ PerToken ßB éê« endsWith ìí? substringï -INVALID_TOKEN_ERROR : The person with the ID ñ has an invalid token ó 4 , we updated the pertoken column with this value : Yõö ] errorø UPDATE Person SET PerToken = ú WHERE PerID = PERTOKEN_LENGTH token newToken x û x S setPvtFrpID cDELETE FROM questionresponse WHERE qrsfrpid IN (SELECT frpid FROM formresponse WHERE frppersonid = AND frpformid= ) ; -DELETE FROM formresponse WHERE frppersonid = InitWebFormPvtAction : pvt doesDevisCotisationExist 4(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Z EntCotDevID_:OppMillesime_ =EnterpriseBean.lookup(context, "EntCotDevID_:OppMillesime_", ) just throw an error : Millesime ¨¥ getContextParameter @context.getContextParameter("Millesime"); just throw an error : EntID oppMillesime_ optMillesime setPvtStatusAfterGeneration initGuide j(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Z# $Veuillez renseigner ID du formulaire R& $Veuillez renseigner ID de entreprise( $com/edeal/frontline/FormResponseBean ' º+ FrmMillesime_- ? The field 'FrmMillesime_' not initialized to get 'Millesime' :/ Millesime must be parametrized x12 W getPvtPersonID '45 S setFrpFormID '78 S setFrpPersonID: FrpStatus< TOCOMPLETE '>? S setFrpStatusA FrpVersionNum_ ' Ç ' × 'à F° ?HIJ getStackTrace ()[Ljava/lang/StackTraceElement; L?? N¯° PÜ° R° T?V INSOLITX MAISON ZS? \?? ^|? `?? b?? dì? fÎ?h L j ô õ frp &Lcom/edeal/frontline/FormResponseBean; initGuideForm X(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Z p ! rts 2com/edeal/frontline/helper/custom/EnterpriseHelperuv getListIdsTiersAssociesGuide B(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Ljava/util/Map;xzy java/util/Map{ keySetx ? ~h q ?Å tiers Ljava/util/Map; TiersPvtID 5Ljava/util/Map<Ljava/lang/String;Ljava/lang/String;>; SourceFile GuideGenerationHelper.java InnerClasses Entry ! ) ¸ ³ ± 0 / *· ± . [ ½: ½ Y"SY$SY&SY(SY*SY,SY.SY0SY2SY 4S:» 6Y· 8:9¶ ;W?¶ ;WA¶ ;*+¸ C¶ ;WI¶ ;*,¸ C¶ ;WK¶ ;*-¸ C¶ ;WM¶ ;W² » 6YO· Q¶ T¶ ;¶ T¹ X *¶ T¸ ^:° >