Edit C:\Users\Administrator\Desktop\Back\Livraison EVQG22\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å 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 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_ / ?123 entrySet ()Ljava/util/Set;5 ?6 java/util/Set8 Eq_TiersID = 5:;< iterator ()Ljava/util/Iterator;>@? java/util/IteratorAB next ()Ljava/lang/Object;D java/util/Map$EntryCFGB getKeyCIJB getValueL :RefValN in ( PRQ ,com/edeal/frontline/helper/custom/FormHelperST formatLfqQueryToSQL E(Lcom/edeal/frontline/FlContext;Ljava/util/Vector;)Ljava/lang/String;V )>XYw 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;>;>; initFerYearHotelj FerPlageBgDtl FerPlageEndDtn FerTiersID = p FerMillesime = ?r Òs '(Ljava/lang/String;)Ljava/lang/Integer;u FerIsHebdo = 0 w FerCategorie = y 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_® TimTiersID = ° TimPlageBgTime² TimPlageEndTime´ TimSecPlageBgTime¶ TimSecPlageEndTime¸ TimIsOpen24hº TimIsClosed ¼ |½ *com/edeal/frontline/custom/Timetables_Bean¿ 00:00Á 00:01à 23:59Å CHINÇ CHOUT isOpen24h isClosed timPlageBgTime timPlageEndTime timSecPlageBgTime timSecPlageEndTime initPriceQrsÐ 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:% ý ? oLabels refCode LfqQuery labelsCodes instance code 9Ljava/util/HashMap<Ljava/lang/String;Ljava/lang/String;>; initThemaOfEnvies 0 H2 java/lang/StringBuffer 1 5 .DELETE FROM questionresponse where qrslfqid = 7 AND qrsfrpid = 9 ; 1; =< ,(Ljava/lang/String;)Ljava/lang/StringBuffer; ¨>?@ getConnection ()Ljava/sql/Connection;BDC java/sql/ConnectionEF createStatement ()Ljava/sql/Statement; 1 UIKJ java/sql/StatementL« executeINO closeBNR BIENETRET EAUMERV NEIGEX FAMENFZ MOT\ RANDPED^ VELO` AMOURb GOURMANDd INSOf GOLFh OENOLOGIEj SPAl SPAEXCn GOLF1p OENOTOURISMEr ENVDOUCEt ENVMERv BNETREx ENVEAUz NGE| SEJFAM~ MOTO? RANDO? GOURM? (? ,? ) ? # 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_ ? ? 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 ¾ñò S setPvtEventIDô PvtInsStatusö TOSEND ¾øù S setPvtInsStatusû PvtParStatusý NORES ¾ÿ S setPvtParStatus PvtFinStatus_ PRN ¾ Ç ¾ × ¾Ã 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 /0« endsWith 23? substring5 -INVALID_TOKEN_ERROR : The person with the ID 7 has an invalid token 9 4 , we updated the pertoken column with this value : Y;<