Fix errors in sum calculation

1 files changed, 14 insertions, 7 deletions

diff --git a/dash/pages/total.py b/dash/pages/total.py
index 130c7f2..9655c51 100644
--- a/dash/pages/total.py
+++ b/dash/pages/total.py
@@ -271,7 +271,7 @@ def make_sums(rangeStart, rangeEnd, satellites):
 
     if len(satellites) > 0:
         formatStrings = ','.join(['%s'] * len(satellites))
-        cursor.execute(stmt + ' AND r.ip IN ({})'.format(formatStrings), tuple([days, rangeStart, rangeEnd] + satellites))
+        cursor.execute(stmt + ' AND r.ip IN ({})'.format(formatStrings), tuple([rangeStart, rangeEnd] + satellites))
     else:
         cursor.execute(stmt, (rangeStart, rangeEnd))
 
@@ -279,12 +279,19 @@ def make_sums(rangeStart, rangeEnd, satellites):
 
     db.closeConnection(dbcon)
 
-    strTimes = 'Total Time: {}h    Total Session Time: {}h    Total Off Time: {}h'.format(
-            int(data['totalTime'] / 3600),
-            int(data['totalSessionTime'] / 3600),
-            int(data['totalOffTime'] / 3600)
-        )
-    strSessions = 'Total Short Sessions: {}    Total Long Sessions: {}'.format(data['shortSessions'], data['longSessions'])
+    try:
+        strTimes = 'Total Time: {}h    Total Session Time: {}h    Total Off Time: {}h'.format(
+                int(data['totalTime'] / 3600),
+                int(data['totalSessionTime'] / 3600),
+                int(data['totalOffTime'] / 3600)
+            )
+    except:
+        strTimes = "No Data available!"
+
+    try:
+        strSessions = 'Total Short Sessions: {}    Total Long Sessions: {}'.format(data['shortSessions'], data['longSessions'])
+    except:
+        strSessions = "No Data available!"
 
     return strTimes, strSessions