3H.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;)VNIntAtvIDP ActivitéRActivityaxesLjava/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; Exceptions[&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; ^ _` composeQuery(Ljava/util/Map;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;Lcom/edeal/frontline/kpi/ICalcAxis;)Ljava/lang/String; b cdlogger Lorg/apache/commons/logging/Log;fcannot get the query hjiorg/apache/commons/logging/Log klerror*(Ljava/lang/Object;Ljava/lang/Throwable;)Vnjava/lang/StringBuilderpSQL Error in performing query [ mr s(Ljava/lang/String;)V mu vwappend-(Ljava/lang/String;)Ljava/lang/StringBuilder;y]: Z{ |} getMessage()Ljava/lang/String; m }toString Z *(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; m "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 qLjava/lang/StringBuilder;jh$Lcom/edeal/frontline/kpi/JoinHelper;, ucode: } getUserCode h info(Ljava/lang/Object;)V  0equalsA.ActIDcommaZaxis   innerJoin&(Ljava/lang/String;)Ljava/lang/String;1 LEFT OUTER JOIN MvaIntActID ON MvaColID = IntID   INNER JOIN Actor    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; com/edeal/frontline/FlLocale  getLocale()Ljava/util/Locale;   !localeLjava/util/Locale; #  %'&java/util/Locale (!FRANCE % %+ ,!FRENCH.Nombre0NumberflLocaleLcom/edeal/frontline/FlLocale;resultgetDescription 6 48Comptage:Counting getSignature*(Ljava/lang/String;)Ljava/util/Collection;O(Ljava/lang/String;)Ljava/util/Collection; ?A@java/util/Collections BC emptyList()Ljava/util/List;dispose=()Ljava/util/Collection; SourceFileActSynthMethod.java! /* !  YL+YYSY!SY#SY&S(+W+1Y3YSY5SY#SY7S9;+W+>Y@YSYBSY#SYBS@DJ+W+YMYSYOSY#SYQS(+W+ "$&2'^()(*,  STU SVWXYZ\ :*+-]:::*aegZYmYoqtxtzt~::: : *::  : Y- :: *a  g  ZYmYqtxt t~ : *a  g  ZYmYqtxt t~ ZUU Z1456!7I:L;O<R=U?^@gArBCDEFGHIJO   5LOR U A A U VZ6@ BB_`YZWmY:Y*:ܶtW*,*-*tW*,*-*, tW*,*-*~ BU VXZ([2\=^E`NaWbadeemhwijl H  |U  mmYZ& +tW*amYqt~ +tWK@ +@tW23 +tWM +MtW :qru vy0z?{F|X}_~qx 4  7YZ--+t,tW]-30+tW+mY q, tt~tW"-M+t,MtW 2 $5=R[_p * !:5*+*+"M*$)**) -M/M, (,/3 5 512'3  (45*+*+5M*$)**) 7M9M, (,/3 5 512'3  (;<=8>    D+   ;E.>   FG