Edit C:\Users\Administrator\Desktop\Back\Livraison EVQG22\com\edeal\frontline\tasks\action\custom\UpdateRestoFormResponseTask_.class
Êþº¾ 3º Dcom/edeal/frontline/tasks/action/custom/UpdateRestoFormResponseTask_ *com/edeal/frontline/tasks/FlTaskActionUnit 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 FLcom/edeal/frontline/tasks/action/custom/UpdateRestoFormResponseTask_; run <([Ljava/lang/String;)Lcom/edeal/frontline/tasks/ETaskStatus; Exceptions +com/edeal/frontline/UnfinishedTaskException ! getContext !()Lcom/edeal/frontline/FlContext; # EVQG21 % ' & Zcom/edeal/frontline/tasks/action/custom/UpdateHotelRestoAndHotelSansRestoFormResponseTask_ ( ) getEventIDByEventCode E(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Ljava/lang/String; + , - getRestoLPerListIds E(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Ljava/util/Vector; % / 0 ) getFormIDByEventCode 2 RESTO 4 Enterprise 6 7 8 getLfqsList j(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;I)Ljava/util/Vector; : < ; java/util/Vector = > iterator ()Ljava/util/Iterator; @ B A java/util/Iterator C D next ()Ljava/lang/Object; F java/util/Hashtable H perid E J K L get &(Ljava/lang/Object;)Ljava/lang/Object; N java/lang/String P perentid R T S com/edeal/frontline/Utils U V isNullEmptyString (Ljava/lang/String;)Z X Z Y 4com/edeal/frontline/helper/custom/FormResponseHelper [ \ retrieveResponse k(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;)Lcom/edeal/frontline/FormResponseBean; X ^ _ \ getInitFrpVersion a c b $com/edeal/frontline/FormResponseBean d e getFrpID ()Ljava/lang/String; g h i updateInitFrp ?(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/util/Vector;)V k 6Erreur Lors de la recuperation de la valeur du champ m o n org/apache/commons/logging/Log p q error *(Ljava/lang/Object;Ljava/lang/Throwable;)V M s t u equals (Ljava/lang/Object;)Z @ w x y hasNext ()Z { | } FINISH_WITH_ERROR 'Lcom/edeal/frontline/tasks/ETaskStatus; ? } FINISH_WITH_SUCCES ? 0com/edeal/frontline/FieldNotInitializedException ? java/lang/Exception var1 [Ljava/lang/String; context Lcom/edeal/frontline/FlContext; evtId Ljava/lang/String; persIds Ljava/util/Vector; formID lfqsEnt perI Ljava/util/Hashtable; perId perEntId frp &Lcom/edeal/frontline/FormResponseBean; initFrp initFrpID ex 2Lcom/edeal/frontline/FieldNotInitializedException; frpID fle Ljava/lang/Exception; LocalVariableTypeTable OLjava/util/Vector<Ljava/util/Hashtable<Ljava/lang/String;Ljava/lang/String;>;>; ;Ljava/util/Hashtable<Ljava/lang/String;Ljava/lang/String;>; StackMapTable ? ¢ com/edeal/frontline/FlContext ¤ java/lang/StringBuilder ¦ <<<< handling the form Response £ ¨ © (Ljava/lang/String;)V £ « ¬ append -(Ljava/lang/String;)Ljava/lang/StringBuilder; ¯ perid ± / entId ³ type £ µ ¶ e toString m ¸ ¹ º info (Ljava/lang/Object;)V ¼ ½ ¾ initEnterpriseQrs |(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/util/Vector;)V ? À Á  getStackTrace ()[Ljava/lang/StackTraceElement; m Ä p º Æ Ç È initEnterpriseAddress j(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V entID typeTiers lfqs e Signature ?(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Ljava/util/Vector<Ljava/util/Hashtable<Ljava/lang/String;Ljava/lang/String;>;>; ¡ Ð Ñ Ò getDataDictionary &()Lcom/edeal/frontline/DataDictionary; : Õ Ct_TypeContrat × L Ù Û Ú "com/edeal/frontline/DataDictionary Ü Ý getRefIdByCode 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; ß Ct_Statut á VAL £ ä 1SELECT distinct perid , perentid from personevent æ ) inner join person on pvtpersonid = perid è * inner join enterprise on perentid = entid ê 3 inner join refvalues r1 on r1.refid = PvtParStatus ì - inner join refvalues r on r.refid = enttyeid î where pvteventid = R ð ñ ) formatToSQL ó T and r.refval = 'RESTO' and entratachhotelid_ IS NOT NULL and entratachhotelid_ in ( õ Y SELECT Distinct MvaText FROM MvaSg_Tiers left outer join Signataire_ ON Sg_ID = MvaColID ÷ I left outer join Contrat_ on Sg_Contrat = Ct_ID WHERE ( Ct_TypeContrat = ù ) AND Ct_Statut = û 1 AND ( Ct_DateFin IS NULL OR Ct_DateFin > NOW())) ý sqlQuery : £ ÿ ¬ -(Ljava/lang/Object;)Ljava/lang/StringBuilder; ¡ getConnection ()Ljava/sql/Connection; java/sql/Connection createStatement ()Ljava/sql/Statement; java/sql/Statement executeQuery ((Ljava/lang/String;)Ljava/sql/ResultSet; java/sql/ResultSet getString &(Ljava/lang/String;)Ljava/lang/String; E E put 8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object; : u add C y" +Erreur lors d'exécution de la requete SQL $% close$$ )+* &com/edeal/frontline/FrontlineException, printStackTrace. java/sql/SQLException dico $Lcom/edeal/frontline/DataDictionary; listPerIds ct_TypeContrat ct_Statut sqlQuery Ljava/lang/StringBuilder; con Ljava/sql/Connection; stmt Ljava/sql/Statement; rs Ljava/sql/ResultSet; row Ljava/sql/SQLException; e1 (Lcom/edeal/frontline/FrontlineException;A java/lang/Throwable §(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;I)Ljava/util/Vector<Ljava/util/Hashtable<Ljava/lang/String;Ljava/lang/String;>;>;D LfqIDF LfqLnkFrmQtParentID_H LfqStoredInFldID_J LfqStoreInObjID_L LfqFormQuestionIDN LfqPositionP LfqCode_R LfqName_T LfqValue_V LfqQuery_X TZ 4 AND (lfqtypetiers_ is null OR lfqtypetiers_ like '% M\]^ charAt (I)C £` ¬a (C)Ljava/lang/StringBuilder;c %') and lfqposition < £e ¬f (I)Ljava/lang/StringBuilder;h ´SELECT LfqID,LfqLnkFrmQtParentID_,LfqStoredInFldID_, LfqStoreInObjID_,LfqFormQuestionID,LfqPosition, LfqCode_,LfqName_,LfqValue_,LfqQuery_ from LinkFormQuestion WHERE LfqFormID = j AND LfqName_ = l order by LfqPosition ASCn lfq query :: prq (com/edeal/frontline/LinkFormQuestionBeanst listSQL X(Lcom/edeal/frontline/FlContext;[Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector; lfqName lfqPosition I keys filter getQrspByFrPId o(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;)Lcom/edeal/frontline/QuestionResponseBean;} frpID QrsFrpID = ? QrsLfqID = ??? (com/edeal/frontline/QuestionResponseBean?? list Z(Lcom/edeal/frontline/FlContext;[[Ljava/lang/String;[Ljava/lang/String;)Ljava/util/Vector;? Aucune reponse pour : [Form : ? , LinkFormQuestion : ? ] :??? size ()I :? K? (I)Ljava/lang/Object; lfqId response *Lcom/edeal/frontline/QuestionResponseBean; queryFrp [[Ljava/lang/String; listQrp fe >Ljava/util/Vector<Lcom/edeal/frontline/QuestionResponseBean;>;? initLocaliteQrs java/lang/IllegalAccessException¢ java/lang/ClassNotFoundException¤ java/lang/NoSuchMethodException¦ )com/edeal/frontline/AccessDeniedException¨ +java/lang/reflect/InvocationTargetExceptionª (com.edeal.frontline.custom.Localite_Bean ¬® java/lang/Class¯° forName %(Ljava/lang/String;)Ljava/lang/Class;² "com/edeal/frontline/EnterpriseBean ±´ µ 4(Ljava/lang/String;Lcom/edeal/frontline/FlContext;)V· ¹ EntLocalityID_ ±»¼½ getCustomProperty &(Ljava/lang/String;)Ljava/lang/Object;¿ (com/edeal/frontline/custom/Localite_Bean ¾´ ¾Âà e getLo_DepÅ Dp_Ç Te2 ÙÉÊË getRefDisp J(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object;Í Rg_ ÙÏ ÜÐ J(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;Ò CtrÔ Localite_ :Ö×? elementAtÙ FqtType ÛÝÜ $com/edeal/frontline/FormQuestionBeanÞß lookup W(Lcom/edeal/frontline/FlContext;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object; Ùáâ Ý getRefCodeä FqtDispTypeæ | Rèéê explodeList 8(Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector;ì FREÞ ¬ïðñ getMethod @(Ljava/lang/String;[Ljava/lang/Class;)Ljava/lang/reflect/Method;ó java/lang/Object õ÷ö java/lang/reflect/Methodøù invoke 9(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object; ûz{ ò µþ 8>>>> Aucune réponse n'a été trouvé pour la question / >>>> set The new Qrs ? "(Lcom/edeal/frontline/FlContext;)V ? © setQrsFrpID ? © setQrsLfqID ? © setQrsText ? save '()Lcom/edeal/frontline/OperationResult; ? e getQrsText <<<< set The old Qrs ? e getQrsFrpID with new Value Localite m"# º warn% ?+( REF* Lo_Pays, >>>> set The new Qrs Pays ?./ © setQrsRefValID ?123 setQrsInstance (I)V ?56 e getQrsRefValID8 Lo_Reg M µ; Lo_Dep= COMBO entType c Ljava/lang/Class; ent $Lcom/edeal/frontline/EnterpriseBean; loca *Lcom/edeal/frontline/custom/Localite_Bean; locID regID paysID depid regVal paysVal p lfqID lfqFormQuestionID questionType dispType lfqCode codes value Ljava/lang/Object; paramTypes [Ljava/lang/Class; mlookup Ljava/lang/reflect/Method; args [Ljava/lang/Object; qrs values r &Ljava/util/Vector<Ljava/lang/String;>;UYa "com.edeal.frontline.EnterpriseBean Mcd y isEmptyf EntLblVoie_ Mhij contains (Ljava/lang/CharSequence;)Zl EntThema_n EntVoieNum_p EntNatureVoieID_r EntSegRes_t EntRatachHotelID_ entRatachHotelID_ entParent entSegResy ²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 ±Ý M?? e trim? (FormHelper:initEnterpriseAddress (EntID=? ): EntVoieNum_ is null.? null? EntNatureVoieID_:Val? ): EntNatureVoieID_:Val is null.? ): EntLblVoie_ is null.? EntGeoCplt_? EntBP_? EntLieuDit_? EntAd1? EntAd2? >>>> set The new Qrs Adresse 1 ? >>>> set The new Qrs Adresse 2 M? ¡ valueOf &(Ljava/lang/Object;)Ljava/lang/String;£ + M¥¦ Ý replaceAll M¨©? length« <<<< set The old Qrs Adresse 1 qrsId ¯ <<<< set The old Qrs Adresse 2 entVoieNum natureVoie lblVoie entgeocplt_ address1 address2 adr_qrs ;Ljava/util/Hashtable<Ljava/lang/String;Ljava/lang/Object;>; SourceFile !UpdateRestoFormResponseTask_.java ! ) ¸ ³ ± / *· ± ù ý*¶ M,"¸ $N*,-¶ *:,"¸ .:,13¸ 5:¶ 9:§ µ¹ ? À E:Æ ¤: : G¶ IÀ M: O¶ IÀ M: ¸ Q? ~ ¸ Q? v, ¸ W:, ¸ ]:: ¶ `: *, 1· f§ :² j¹ l ¶ `:¶ r? %*, 1· f§ :² j¹ l ¹ v ?ÿG§ M² z°² ~° ? £ ¦ ? ´ Ö Ù ? ñ ô ? r $ % &