Edit C:\Windows\install\galaxie_p02_26-09\WEB-INF\classes\com\edeal\frontline\kpi\methods\GiftCheque_CustomCountMethod.class
Êþº¾ 3J <com/edeal/frontline/kpi/methods/GiftCheque_CustomCountMethod *com/edeal/frontline/kpi/AbstractCalcMethod <init> ()V Code LineNumberTable LocalVariableTable this >Lcom/edeal/frontline/kpi/methods/GiftCheque_CustomCountMethod; getSupportedAxes ()Ljava/util/Collection; Signature =()Ljava/util/Collection<Lcom/edeal/frontline/kpi/ICalcAxis;>; java/util/LinkedList com/edeal/frontline/kpi/TimeAxis GchCrDt java/lang/String (com/edeal/frontline/kpi/AbstractCalcAxis FRENCH_LOCALE Ljava/lang/String; " Date de création $ % ENGLISH_LOCALE ' Date of Creation ) + * 'com/edeal/frontline/kpi/TimeGranularity , - DAY )Lcom/edeal/frontline/kpi/TimeGranularity; / 0 c(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Lcom/edeal/frontline/kpi/TimeGranularity;)V 2 4 3 java/util/List 5 6 add (Ljava/lang/Object;)Z 8 GchValidityDt : Date de validité < Effective Date > com/edeal/frontline/kpi/RefAxis @ GchStatusID B Statut D Department = F G ((Ljava/lang/String;[Ljava/lang/String;)V I "com/edeal/frontline/kpi/StringAxis K GchMontant M Montant O Amount H Q R :(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)V T com/edeal/frontline/kpi/FobAxis V CgcCustomer X Client Z Customer \ Correspondent S Q _ GchUseWithAdherent a (Utilisation du chèque chez lâ??affilié c Partner e Enterprise axes Ljava/util/List; LocalVariableTypeTable 5Ljava/util/List<Lcom/edeal/frontline/kpi/ICalcAxis;>; run °(Ljava/util/Map;Ljava/util/Calendar;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;)Lcom/edeal/frontline/kpi/IDataSet; ç(Ljava/util/Map<Lcom/edeal/frontline/kpi/CalcParam;Ljava/lang/String;>;Ljava/util/Calendar;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;)Lcom/edeal/frontline/kpi/IDataSet; n o p composeQuery ?(Ljava/util/Map;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;)Ljava/lang/String; r s t logger Lorg/apache/commons/logging/Log; v x w &com/edeal/frontline/FrontlineException y z getMessage ()Ljava/lang/String; | ~ } org/apache/commons/logging/Log ? error *(Ljava/lang/Object;Ljava/lang/Throwable;)V ? #com/edeal/frontline/kpi/ListDataSet ? ? ? !com/edeal/frontline/kpi/Aggregate ? ? SUM #Lcom/edeal/frontline/kpi/Aggregate; ? ? ? £(Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/Aggregate;Ljava/lang/Iterable;)V ? java/lang/StringBuilder ? Requete : ? ? ? (Ljava/lang/String;)V ? ? ? ? append -(Ljava/lang/String;)Ljava/lang/StringBuilder; ? ? ? z toString | ? ? ? info (Ljava/lang/Object;)V ? ¡ ctx Lcom/edeal/frontline/FlContext; £ ¥ ¤ com/edeal/frontline/FlContext ¦ § getConnection ()Ljava/sql/Connection; © « ª java/sql/Connection ¬ createStatement ()Ljava/sql/Statement; ¯ ± ° java/sql/Statement ² ³ executeQuery ((Ljava/lang/String;)Ljava/sql/ResultSet; µ !com/edeal/frontline/kpi/DBDataSet ´ · ¸ ¸(Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/Aggregate;Ljava/sql/ResultSet;Ljava/sql/Connection;)V º x » java/sql/SQLException ½ ¿ ¾ com/edeal/frontline/Utils À Á cleanUp @(Ljava/sql/Connection;Ljava/sql/Statement;Ljava/sql/ResultSet;)V params Ljava/util/Map; cal Ljava/util/Calendar; axis1 #Lcom/edeal/frontline/kpi/ICalcAxis; axis2 axis3 query e (Lcom/edeal/frontline/FrontlineException; it Ljava/lang/Iterable; dataSet #Lcom/edeal/frontline/kpi/DBDataSet; con Ljava/sql/Connection; st Ljava/sql/Statement; rs Ljava/sql/ResultSet; sqle Ljava/sql/SQLException; FLjava/util/Map<Lcom/edeal/frontline/kpi/CalcParam;Ljava/lang/String;>; 9Ljava/lang/Iterable<Lcom/edeal/frontline/kpi/SnapValue;>; StackMapTable Ý java/util/Map ß java/util/Calendar á !com/edeal/frontline/kpi/ICalcAxis ã java/sql/ResultSet Exceptions Ã(Ljava/util/Map<Lcom/edeal/frontline/kpi/CalcParam;Ljava/lang/String;>;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;)Ljava/lang/String; ? è "com/edeal/frontline/kpi/JoinHelper ç ê ë "(Lcom/edeal/frontline/FlContext;)V í SELECT COUNT (*) ï ð ñ addAxisField d(Ljava/lang/StringBuilder;ZLcom/edeal/frontline/kpi/JoinHelper;Lcom/edeal/frontline/kpi/ICalcAxis;)V ó FROM GiftCheque_ õ ö ÷ addAxisJoin c(Ljava/lang/StringBuilder;Lcom/edeal/frontline/kpi/JoinHelper;Lcom/edeal/frontline/kpi/ICalcAxis;)V ù GROUP BY q Ljava/lang/StringBuilder; jh $Lcom/edeal/frontline/kpi/JoinHelper; dispose getSignature =()Ljava/util/Collection<Lcom/edeal/frontline/kpi/CalcParam;>; java/util/Collections emptyList ()Ljava/util/List; , à z getUserCode 6 equals GchCrDt GchValidityDt GchStatusID GchMontant join_1.CgcID GchUseWithAdherent comma Z axis C LEFT OUTER JOIN CmdGiftCheque_ as join_1 ON GchCgcID=join_1.CgcID getUnit 2(Lcom/edeal/frontline/FlLocale;)Ljava/lang/String; #%$ com/edeal/frontline/FlLocale&' getLocale ()Ljava/util/Locale; )*+ locale Ljava/util/Locale; - ! /10 java/util/Locale2+ FRANCE / /56+ FRENCH8 Nombre de Chèques cadeaux: Gift Cheques flLocale Lcom/edeal/frontline/FlLocale; result getDescription @>!B &Decompte du nombre de Chèques CadeauxD Gift Cheques counting *(Ljava/lang/String;)Ljava/util/Collection; O(Ljava/lang/String;)Ljava/util/Collection<Lcom/edeal/frontline/kpi/CalcParam;>; arg0 SourceFile !GiftCheque_CustomCountMethod.java ! / *· ± "