Edit C:\Users\Administrator\Desktop\Back\Livraison EVQG22\com\edeal\frontline\tasks\action\custom\AffectCTCReferencesActorsToEnterprisesByDepart2017.class
Êþº¾ 3 î Zcom/edeal/frontline/tasks/action/custom/AffectCTCReferencesActorsToEnterprisesByDepart2017 *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 \Lcom/edeal/frontline/tasks/action/custom/AffectCTCReferencesActorsToEnterprisesByDepart2017; 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; / java/lang/String 1 '79','86'|00012d0012ca49ef 3 '60','76'|00012d001365504e 5 '45'|00012d0012d1ce8a 7 '43'|00012d0012af8618 9 '69'|00012d0012af873f ; '01','1'|00012d0012af879c = .'400','401','402','403','404'|00012d001355878c ? '29','56'|00012d0016cddda7 A µSELECT DISTINCT EntID FROM Enterprise LEFT JOIN Localite_ ON Lo_ID = EntLocalityID_ LEFT JOIN RefValues ON RefID=Lo_Dep LEFT JOIN MvaEntActsID_ ON MvaColID = EntID WHERE RefTe3 IN ( Cµ) AND EntID IN ( SELECT Distinct EntID FROM Contrat_ LEFT JOIN Signataire_ ON Sg_Contrat = Ct_ID LEFT JOIN MvaSg_Tiers ON MvaColID = Sg_ID LEFT JOIN Enterprise ON EntID = MvaText LEFT JOIN Refvalues r1 on r1.RefID = Ct_Statut LEFT JOIN Refvalues r2 on r2.RefID = Ct_TypeContrat WHERE r2.RefVal='L' AND r1.RefVal = 'VAL' AND ( Ct_DateFin IS NULL OR Ct_DateFin > NOW()) AND Ct_CodeContrat IS NOT NULL AND Ct_ContratPrincipal IS NULL ) E java/util/ArrayList D H \| . J K L split '(Ljava/lang/String;)[Ljava/lang/String; N com/edeal/frontline/ActorBean M P Q 4(Ljava/lang/String;Lcom/edeal/frontline/FlContext;)V M S T U getActID ()Ljava/lang/String; W java/lang/StringBuilder Y %--- Actor introuvable sur la BDD. id= V [ \ (Ljava/lang/String;)V V ^ _ ` append -(Ljava/lang/String;)Ljava/lang/StringBuilder; V b c U toString e java/util/Vector d h EntID j java/lang/StringBuffer i i m _ n ,(Ljava/lang/String;)Ljava/lang/StringBuffer; p --- V r _ s -(Ljava/lang/Object;)Ljava/lang/StringBuilder; i b v x w com/edeal/frontline/BasicBean y z listSQL X(Lcom/edeal/frontline/FlContext;[Ljava/lang/String;Ljava/lang/String;)Ljava/util/Vector; | --- SQL request returned : d ~ ? size ()I V ? _ ? (I)Ljava/lang/StringBuilder; ? Affiliates. d ? ? ? elementAt (I)Ljava/lang/Object; ? java/util/Hashtable ? ? ? ? get &(Ljava/lang/Object;)Ljava/lang/Object; ? "com/edeal/frontline/EnterpriseBean ? P d ? ? % addElement ? EntActsID_ ? ? ? ? setCustomProperty '(Ljava/lang/String;Ljava/lang/Object;)V ? ? ? ? save '()Lcom/edeal/frontline/OperationResult; ¡ 7 probleme au cours de l'enregistrement de l'affilié : £ ¥ ¤ java/lang/Exception ¦ U getMessage ! ¨ © % error « Affiliates from departments : . were successfully updated for the actor id =' ¯ '. D ± ² ³ add (Ljava/lang/Object;)Z D µ ¶ · iterator ()Ljava/util/Iterator; ¹ » º java/util/Iterator ¼ ½ next ()Ljava/lang/Object; ¹ ¿ À Á hasNext ()Z à --- END. arg0 [Ljava/lang/String; status context Lcom/edeal/frontline/FlContext; affectations query_part1 Ljava/lang/String; query_part2 bilan Ljava/util/ArrayList; affectation departements CTC_Actor e Ljava/lang/Exception; result Ljava/util/Vector; keys sqlQuery Ljava/lang/StringBuffer; nb_of_affiliates I i row Ljava/util/Hashtable; affiliate $Lcom/edeal/frontline/EnterpriseBean; consTechIDs fe b LocalVariableTypeTable )Ljava/util/ArrayList<Ljava/lang/String;>; &Ljava/util/Vector<Ljava/lang/String;>; StackMapTable Å é %com/edeal/frontline/tasks/ETaskStatus ë com/edeal/frontline/FlContext SourceFile 7AffectCTCReferencesActorsToEnterprisesByDepart2017.java ! ) ¸ ³ ± / *· ± 7² ¹ ² &M*¶ *N½ .Y0SY2SY4SY6SY8SY:SY<SY>S:@:B:» DY· F:Y: ¾6 6 §? 2:G¶ I2: G¶ I2: » MY -· O¶ RW§ !:² » VYX· Z ¶ ]¶ a¹ §K» dY· f:½ .YgS:» iY· k:¶ lW ¶ lW¶ lW² » VYo· Z¶ q¶ a¹ 6-¶ t¸ u:² » VY{· Z¶ }¶ ??¶ ]¶ a¹ Æ ?¶ }? }6§ m¶ ?À ?:g¶ ?À .:» ?Y-· ?:» dY· f: ¶ ??¶ ?¶ ?W?§ !:² » VY · Z¶ ¢¶ ]¶ a¹ § ?¶ }¡ÿ?» VYo· Z¶ ?ª¶ ] ¶ ]¬¶ ] ¶ ]®¶ ]¶ a¶ °W§ :² ¶ ¢¹ § ? ¡þe¶ ´: § ¹ ¸ À .:² ¹ ¹ ¾ ?ÿ㲠¹ ,° ? ? ? £Y?? £ åè £ Þ 7 ! # $ % $ & ) ' . ( 3 ) 9 * ? + B # D . H 3 L C U D j E u F ? H ? I ? J ¬ K ¯ N ¸ O à P Ì Q Ô R Ü S ä T ý V X Y. Z; [A \M ]Y `e an ku l~ m? n? o? p¨ [µ tå uê v÷ D y z! y+ |5 } ò 7 7 Ä Å ) Æ ) $ Ç È Dó É Å Hï Ê Ë Lë Ì Ë Uâ Í Î j? Ï Ë u? Ð Ë ?w Ñ Ë ? Ò Ó ¸? Ô Õ Ã4 Ö Å Ì+ × Ø ÷ Ù Ú > w Û Ú M [ Ü Ý Y O h Ë e " Þ ß n à Õ ? Ò Ó ê á Ó â Ë ã Uâ Í ä n à å æ & ÿ c ç è ê ç . . D ç ÿ - ç è ê ç . . D . ç . . £ ÿ ? ç è ê ç . . D . ç . . d ç i ÿ H ç è ê ç . . D . ç . . d ç i ? . £ù ú r £ÿ ç è ê ç . . D ç ÿ ç è ê ç . . D ¹ ì í
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de