# HG changeset patch
# User František Kučera <franta-hg@frantovo.cz>
# Date 1234641870 -3600
# Node ID 02e4aba218a34265f1d97fe141e4cf0d6546d9c7
# Parent  0e73428ba7b149b8e9dd6f185aa464141b3824b3
Agregace souhrnů za období – seskupení, součet počtů, výběr maximální data (zobrazuje se poslední pokus z dané IP pro daný cíl)

diff -r 0e73428ba7b1 -r 02e4aba218a3 java/HrisniciSpameri/src/java/cz/frantovo/hrisniciSpameri/dao/SouhrnDAO.sql.xml
--- a/java/HrisniciSpameri/src/java/cz/frantovo/hrisniciSpameri/dao/SouhrnDAO.sql.xml	Sat Feb 14 20:17:33 2009 +0100
+++ b/java/HrisniciSpameri/src/java/cz/frantovo/hrisniciSpameri/dao/SouhrnDAO.sql.xml	Sat Feb 14 21:04:30 2009 +0100
@@ -3,21 +3,41 @@
 <properties>
     <entry key="DENNI_SOUHRN">
         <![CDATA[
-        SELECT *
-        FROM souhrn
-        JOIN cil ON (cil.id = souhrn.cil)
+        SELECT  max(den) AS den,
+                ip,
+                domena,
+                sum(pocet) AS pocet,
+                cil,
+                id,
+                nazev,
+                url,
+                selekt,
+                databaze
+        FROM    souhrn
+                JOIN cil ON (cil.id = souhrn.cil)
         WHERE   den >= date_trunc('day', ?::date)
                 AND den <= date_trunc('day', ?::date)
+        GROUP BY ip, domena, cil, id, nazev, url, selekt, databaze
         ]]>
     </entry>
     <entry key="DENNI_SOUHRN_CIL">
         <![CDATA[
-        SELECT *
-        FROM souhrn
-        JOIN cil ON (cil.id = souhrn.cil)
+        SELECT  max(den) AS den,
+                ip,
+                domena,
+                sum(pocet) AS pocet,
+                cil,
+                id,
+                nazev,
+                url,
+                selekt,
+                databaze
+        FROM    souhrn
+                JOIN cil ON (cil.id = souhrn.cil)
         WHERE   den >= date_trunc('day', ?::date)
                 AND den <= date_trunc('day', ?::date)
                 AND cil = ?
+        GROUP BY ip, domena, cil, id, nazev, url, selekt, databaze
         ]]>
     </entry>
 </properties>
\ No newline at end of file