Changeset 610 in tmcsimulator

Timestamp:

04/01/2020 01:36:31 PM (6 years ago)

Author:

liquan

Message:

Modified search criteria on start and end date, and search by closure id for search page.

Location:

branches/LCSv1

Files:

• controllers/default.py (modified) (1 diff)
• databases/storage.sqlite (modified) (previous)

branches/LCSv1/controllers/default.py

@@ -71 +71 @@
         msg += " Route = " + session.route
     if (len(session.startdate) != 0):
-        query = query & (db.closures.startdate == session.startdate)
+        query = query & (db.closures.startdate >= session.startdate)
         msg += "Start date = " + session.startdate
     if (len(session.enddate) != 0):
-        query = query & (db.closures.enddate == session.enddate)
-        msg += "Start date = " + session.enddate
+        query = query & (db.closures.startdate <= session.enddate)
+        msg += "End date = " + session.enddate
     
     # if no restrictions entered then get all entries