[chronojump] On jumps multisession statistics, now show all jumps of each person



commit d6376617ab795bb7b286d67b276b00fe2eb85484
Author: Xavier de Blas <xaviblas gmail com>
Date:   Sat Dec 10 00:21:46 2016 +0100

    On jumps multisession statistics, now show all jumps of each person

 src/sqlite/stat.cs |    8 ++++----
 1 files changed, 4 insertions(+), 4 deletions(-)
---
diff --git a/src/sqlite/stat.cs b/src/sqlite/stat.cs
index 5f201bb..2a286d7 100644
--- a/src/sqlite/stat.cs
+++ b/src/sqlite/stat.cs
@@ -55,11 +55,11 @@ class SqliteStat : Sqlite
                //if there's more than one session, it sends the avg or max
                string groupByString = "";
                if (ini.Length > 0) {
-                       groupByString = " GROUP BY jump.personID, jump.sessionID ";
+                       groupByString = " GROUP BY jump.type, jump.personID, jump.sessionID ";
                }
                //if multisession, order by person.name, sessionID for being able to present results later
                if(multisession) {
-                       orderByString = orderByString + tp + ".name, sessionID, ";
+                       orderByString = orderByString + tp + ".name, jump.type, sessionID, ";
                }
                
                Sqlite.Open();
@@ -146,11 +146,11 @@ class SqliteStat : Sqlite
                //there's no chance of mixing tv and weight of different jumps in multisessions because only 
tv is returned
                string groupByString = "";
                if (ini.Length > 0) {
-                       groupByString = " GROUP BY jump.personID, jump.sessionID ";
+                       groupByString = " GROUP BY jump.type, jump.personID, jump.sessionID ";
                }
                //if multisession, order by person.name, sessionID for being able to present results later
                if(multisession) {
-                       orderByString = orderByString + "" + tp + ".name, jump.sessionID, ";
+                       orderByString = orderByString + "" + tp + ".name, jump.type, jump.sessionID, ";
                }
                
                Sqlite.Open();


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]