Edit C:\Users\Administrator\Desktop\Back\Livraison EVQG22\com\edeal\frontline\tasks\action\custom\FindDevisKO.class
Êþº¾ 3 ¹ 3com/edeal/frontline/tasks/action/custom/FindDevisKO *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 5Lcom/edeal/frontline/tasks/action/custom/FindDevisKO; run <([Ljava/lang/String;)Lcom/edeal/frontline/tasks/ETaskStatus; Exceptions +com/edeal/frontline/UnfinishedTaskException --- BEGIN ! # " org/apache/commons/logging/Log $ % info (Ljava/lang/Object;)V ' ( ) FINISH_WITH_SUCCES 'Lcom/edeal/frontline/tasks/ETaskStatus; + , - getContext !()Lcom/edeal/frontline/FlContext; / 1 0 com/edeal/frontline/FlContext 2 3 getDataDictionary &()Lcom/edeal/frontline/DataDictionary; 5 java/util/Vector 4 8 java/lang/String : pvtpersonid < java/lang/StringBuffer ; ? b select pvtpersonid from personevent inner join event on evtid = pvteventid where evtcode='EVQG20' ; A B C append ,(Ljava/lang/String;)Ljava/lang/StringBuffer; E java/lang/StringBuilder G --- D I J (Ljava/lang/String;)V D L B M -(Ljava/lang/Object;)Ljava/lang/StringBuilder; D O P Q toString ()Ljava/lang/String; ; O T V U com/edeal/frontline/BasicBean W X listSQL X(Lcom/edeal/frontline/FlContext;[Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector; Z --- SQL request returned : 4 \ ] ^ size ()I D ` B a (I)Ljava/lang/StringBuilder; c tiers à traiter D e B f -(Ljava/lang/String;)Ljava/lang/StringBuilder; 4 h i j elementAt (I)Ljava/lang/Object; l java/util/Hashtable k n o p get &(Ljava/lang/Object;)Ljava/lang/Object; r frpid t SELECT frpid v ' FROM formresponse where frppersonid=' x ' z " and frpformid='00012d001cc71b7c' | % order by frpversionnum_ desc limit 1 ~ lignes de devis pour le tiers ? QrsID ? ? Select QrsID from questionresponse inner join formresponse on frpid=qrsfrpid inner join linkformquestion on lfqid = qrslfqid where frpid=' ? " and lfqname_='ProductOpportunity' ? Réponses ProductOpportunity ? --- Tiers lié à la personne ? impacté ? ? ? java/lang/Exception ? printStackTrace ? --- Fin du traitement : ? tiers impactés arg0 [Ljava/lang/String; status context Lcom/edeal/frontline/FlContext; dico $Lcom/edeal/frontline/DataDictionary; counter I result Ljava/util/Vector; keys sqlQuery Ljava/lang/StringBuffer; i row Ljava/util/Hashtable; PerID Ljava/lang/String; result2 keys2 sqlQuery2 row2 result3 keys3 sqlQuery3 e Ljava/lang/Exception; fe StackMapTable ? ´ %com/edeal/frontline/tasks/ETaskStatus ¶ "com/edeal/frontline/DataDictionary SourceFile FindDevisKO.java ! ) ¸ ³ ± / *· ± :² ¹ ² &M*¶ *N-¶ .:6» 4Y· 6:½ 7Y9S:» ;Y· =:>¶ @W² » DYF· H¶ K¶ N¹ -¶ R¸ S:² » DYY· H¶ [¶ _b¶ d¶ N¹ Æ®¶ [?¦6 §n ¶ gÀ k: 9¶ mÀ 7:» 4Y· 6:½ 7YqS: » ;Y· =:s¶ @W» DYu· H¶ dw¶ dy¶ d{¶ d¶ N¶ @W- ¶ R¸ S:² » DYY· H¶ [¶ _}¶ d¶ d¶ N¹ Æ Ð¶ [? ȶ gÀ k:q¶ mÀ 7:» 4Y· 6:½ 7YS:» ;Y· =:» DY?· H¶ dw¶ d?¶ d¶ N¶ @W-¶ R¸ S:² » DYY· H¶ [¶ _?¶ d¶ N¹ Æ ¶ [? 8² » DY?· H¶ d?¶ d¶ N¹ ?§ :¶ ?§ :¶ ?? ¶ [¡þ?² » DY?· H¶ _?¶ d¶ N¹ § : ¶ ?,° ?ïò ? þùü ? Z.1 ? Î 3 ! % "