3r.com/edeal/frontline/kpi/methods/ActSynthMethod*com/edeal/frontline/kpi/AbstractCalcMethod()VCode  LineNumberTableLocalVariableTablethis0Lcom/edeal/frontline/kpi/methods/ActSynthMethod;getSupportedAxes()Ljava/util/Collection; Signature=()Ljava/util/Collection;java/util/LinkedList  com/edeal/frontline/kpi/RefAxisIntStiIDjava/lang/String (com/edeal/frontline/kpi/AbstractCalcAxis   FRENCH_LOCALELjava/lang/String;"Etat $ % ENGLISH_LOCALE'State ) *((Ljava/lang/String;[Ljava/lang/String;)V ,.-java/util/List /0add(Ljava/lang/Object;)Z2com/edeal/frontline/kpi/FobAxis4IntActID6 Acteur(s)8Actor(s):Actor 1< =:(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)V? com/edeal/frontline/kpi/TimeAxisAIntDateCDate EGF'com/edeal/frontline/kpi/TimeGranularity HIWEEK)Lcom/edeal/frontline/kpi/TimeGranularity; >K Lc(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Lcom/edeal/frontline/kpi/TimeGranularity;)VN"com/edeal/frontline/kpi/StringAxisP IntDate_YearRAnnée du DateT Year of Date M<WIntAtvIDY Activité[ActivityaxesLjava/util/List;LocalVariableTypeTable5Ljava/util/List;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; Exceptionsd&com/edeal/frontline/FrontlineException(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; g hi composeQuery(Ljava/util/Map;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;)Ljava/lang/String; k lmlogger Lorg/apache/commons/logging/Log;ocannot get the query qsrorg/apache/commons/logging/Log tuerror*(Ljava/lang/Object;Ljava/lang/Throwable;)Vwjava/lang/StringBuilderySQL Error in performing query [ v{ |(Ljava/lang/String;)V v~ append-(Ljava/lang/String;)Ljava/lang/StringBuilder;]: c  getMessage()Ljava/lang/String; v toString c *(Ljava/lang/String;Ljava/lang/Throwable;)V  ctxLcom/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 !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/sql/ResultSet;Ljava/sql/Connection;)V java/sql/SQLException com/edeal/frontline/Utils cleanUp@(Ljava/sql/Connection;Ljava/sql/Statement;Ljava/sql/ResultSet;)V"SQLException in performing query [ java/lang/ExceptionException in performing query [paramsLjava/util/Map;calLjava/util/Calendar;axis1#Lcom/edeal/frontline/kpi/ICalcAxis;axis2axis3querye(Lcom/edeal/frontline/FrontlineException;dataSet#Lcom/edeal/frontline/kpi/DBDataSet;conLjava/sql/Connection;stLjava/sql/Statement;rsLjava/sql/ResultSet;sqleLjava/sql/SQLException;Ljava/lang/Exception;FLjava/util/Map; StackMapTable java/util/Mapjava/util/Calendar!com/edeal/frontline/kpi/ICalcAxisjava/sql/ResultSet(Ljava/util/Map;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;)Ljava/lang/String; v "com/edeal/frontline/kpi/JoinHelper "(Lcom/edeal/frontline/FlContext;)VSELECT COUNT(*)   addAxisFieldd(Ljava/lang/StringBuilder;ZLcom/edeal/frontline/kpi/JoinHelper;Lcom/edeal/frontline/kpi/ICalcAxis;)V FROM Interaction   addAxisJoinc(Ljava/lang/StringBuilder;Lcom/edeal/frontline/kpi/JoinHelper;Lcom/edeal/frontline/kpi/ICalcAxis;)V GROUP BY   addAxisFieldG  valueOf&(Ljava/lang/Object;)Ljava/lang/String; /com/edeal/frontline/kpi/methods/KPIMethodHelper getSQLlimitForKPImethod3(Lcom/edeal/frontline/FlContext;)Ljava/lang/String;qLjava/lang/StringBuilder;jh$Lcom/edeal/frontline/kpi/JoinHelper;axis.getUserCode():   getUserCode q   info(Ljava/lang/Object;)V q t  printStackTrace, ucode:  0equals IntStiID IntDate  A.ActID " IntAtvID $, EXTRACT(YEAR FROM IntDate) AS IntDate_Year commaZaxisstrComma* IntDate_Year , . /0 innerJoin&(Ljava/lang/String;)Ljava/lang/String;21 LEFT OUTER JOIN MvaIntActID ON MvaColID = IntID 4 INNER JOIN Actor 6 78 getSqlHelper*()Lcom/edeal/frontline/kpi/impl/SqlHelper; :<;&com/edeal/frontline/kpi/impl/SqlHelper =as? A ON MvaText = A.ActID getUnit2(Lcom/edeal/frontline/FlLocale;)Ljava/lang/String; CEDcom/edeal/frontline/FlLocale FG getLocale()Ljava/util/Locale; I JKlocaleLjava/util/Locale; M @A OQPjava/util/Locale RKFRANCE O OU VKFRENCHXNombreZNumberflLocaleLcom/edeal/frontline/FlLocale;resultgetDescription ` ^AbComptagedCounting getSignature*(Ljava/lang/String;)Ljava/util/Collection;O(Ljava/lang/String;)Ljava/util/Collection; ikjjava/util/Collections lm emptyList()Ljava/util/List;dispose=()Ljava/util/Collection; SourceFileActSynthMethod.java! /* "  KYL+YYSY!SY#SY&S(+W+1Y3YSY5SY#SY7S9;+W+>Y@YSYBSY#SYBS@DJ+W+MYOYSYQSY#SYSSOU+W+YVYSYXSY#SYZS(+W+ & %'2(^)*)+,.  \]^ \_`abce :*+-f:::*jnpcYvYxz}}}::: : *::  : Y- :: *j  p  cYvYz}} } : *j  p  cYvYz}} } cUU Z3678!9I<L=O>R?UA^BgCrDEFGHIJKLQ   5LOR U A A ^ Vc6@ BBhibcnvY:Y*:}W*,*-*}W*,*-*, }W*,*-*vYz*} BW XZ\(]2^=`EbNcWdafegmjwkln H  ^  mvbcF*jvYz} :*j ::*jvYz}  +vYz}}W@ +vYz}}W3 +vYz}}WXV +vYz!}}W,O+vYz#}}W&) Vstw&x+y9z>|C}G~Ll{+E HF FF%&FF'+C(  b K+++(bc`O*jvYz} :*j ::*jvYz} +vYz)}}W *+-58 >5:HMRV[{ H %&':RC( q <bc--++},-}W]-30+1}W+vY3z,59}>}}W"-V++},V-}W 2 $5=R[_p * '!:@A5*+BH*+LM*HNS*HTS WMYM, (,/3 5 5[\']  (^A5*+BH*+_M*HNS*HTS aMcM, (,/3 5 5[\']  (efg8h   J n+   eo.h   pq