Edit C:\Users\Administrator\Desktop\Back\Livraison EVQG22\com\edeal\frontline\helper\custom\EnterprisePersonEventHelper.class
Êþº¾ 3 Í =com/edeal/frontline/helper/custom/EnterprisePersonEventHelper 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 ?Lcom/edeal/frontline/helper/custom/EnterprisePersonEventHelper; getJSOpenWindowEditResponse W(Ljava/lang/String;Ljava/lang/String;Lcom/edeal/frontline/FlContext;)Ljava/lang/String; EVQSTAT java/lang/String ! " isEmpty ()Z $ & % com/edeal/frontline/FlContext ' ( getDataDictionary &()Lcom/edeal/frontline/DataDictionary; * java/util/Vector ) - frmID / evtCode 1 perID 3 pertoken 5 pvtcrdt 7 java/lang/StringBuffer 6 : 7SELECT frmID,evtCode,perID,pertoken,pvtcrdt From Event 6 < = > append ,(Ljava/lang/String;)Ljava/lang/StringBuffer; @ & LEFT JOIN Form on evtID = frmeventID B - LEFT JOIN personevent on pvteventid = evtID D ) LEFT JOIN person on perid = pvtpersonid F java/lang/StringBuilder H WHERE evtcode LIKE ' E J K (Ljava/lang/String;)V E M = N -(Ljava/lang/String;)Ljava/lang/StringBuilder; P %' E R S T toString ()Ljava/lang/String; V AND perentid = X Z Y com/edeal/frontline/Utils [ \ formatToSQL E(Lcom/edeal/frontline/FlContext;Ljava/lang/String;)Ljava/lang/String; ^ ` AND pvtfrpid IS NOT NULL b ORDER BY pvtcrdt DESC LIMIT 1 d f e org/apache/commons/logging/Log g h info (Ljava/lang/Object;)V 6 R k m l com/edeal/frontline/BasicBean n o listSQL X(Lcom/edeal/frontline/FlContext;[Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector; ) q r s size ()I ) u v w elementAt (I)Ljava/lang/Object; y java/util/Hashtable x { | } get &(Ljava/lang/Object;)Ljava/lang/Object; ?EnterprisePersonEventHelper.getJSOpenWindowEditResponse : We can build the link, some values are null or empty (check the query above results) : frmID= ? ,evtID= ? ,perID= ? ,pertoken= ? . d ? ? h error ? kEnterprisePersonEventHelper.getJSOpenWindowEditResponse : there is nothing to show, no form with an entID=' ? ' and evtCode like ' ? %', check the SQL query above ! ? kEnterprisePersonEventHelper.getJSOpenWindowEditResponse : connection to server is down or the query is bad. ? ? ? &com/edeal/frontline/FrontlineException ? printStackTrace ? formID= ? &perID= ? &event= ? &utk= ¡ yEnterprisePersonEventHelper.getJSOpenWindowEditResponse parameters are not correct! : entID(first param) is empty or Null entID Ljava/lang/String; eventStatPrefix context Lcom/edeal/frontline/FlContext; formID event utk dico $Lcom/edeal/frontline/DataDictionary; result Ljava/util/Vector; keys [Ljava/lang/String; sqlQuery Ljava/lang/StringBuffer; i I row Ljava/util/Hashtable; fe (Lcom/edeal/frontline/FrontlineException; StackMapTable º "com/edeal/frontline/DataDictionary ¯ getQuestGuideCurrentMillesime ¾ java/util/Date ½ ½ Á  s getYear Ä AND FrmMillesime_ = E Æ = Ç (I)Ljava/lang/StringBuilder; currentDate Ljava/util/Date; year SourceFile EnterprisePersonEventHelper.java ! ) ¸ ³ ± / *· ± Ë N:::+Ç L*Æð*¶ ?é,¶ #:» )Y· +:½ Y,SY.SY0SY2SY4S: » 6Y· 8: 9¶ ;W ?¶ ;W A¶ ;W C¶ ;W » EYG· I+¶ LO¶ L¶ Q¶ ;W » EYU· I,*¸ W¶ L]¶ L¶ Q¶ ;W _¶ ;W a¶ ;W² ¹ c , ¶ i¸ j:Æ Â¶ p? º6¶ p¢ è¶ tÀ x:,¶ zÀ N0¶ zÀ :.¶ zÀ :2¶ zÀ :-Æ 1-¶ ? *Æ %¶ ? Æ ¶ ? Æ ¶ ? {² » EY~· I-¶ L?¶ L¶ L?¶ L¶ L?¶ L¶ L?¶ L¶ Q¹ ? °² » EY?· I*¶ L?¶ L+¶ L?¶ L¶ Q¹ ? °:² ?¹ ? ¶ ?°» EY?· I-¶ L?¶ L¶ L?¶ L¶ L?¶ L¶ L¶ Q°² ¹ ? ° È?Á ??¿Á ? ? $ # , K T \ d l t ? ! ® "