From bbded09310548aa903533424af08945711c844c3 Mon Sep 17 00:00:00 2001 From: Agnibho Mondal Date: Thu, 14 Mar 2024 19:50:17 +0530 Subject: [PATCH] Order transaction and vaccination by date --- transaction.py | 2 +- vaccination.py | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/transaction.py b/transaction.py index 95d6a7f..a8a2153 100644 --- a/transaction.py +++ b/transaction.py @@ -47,7 +47,7 @@ def delete(cursor, tid): def list(cursor, iid): try: - result=cursor.execute("SELECT * FROM transactions WHERE iid=?", (iid,)) + result=cursor.execute("SELECT * FROM transactions WHERE iid=? ORDER BY date", (iid,)) if(cursor.rowcount==0): return (False, "Record not found.") else: diff --git a/vaccination.py b/vaccination.py index aaf4ceb..34abbb9 100644 --- a/vaccination.py +++ b/vaccination.py @@ -47,7 +47,7 @@ def delete(cursor, vid): def list_by_patient(cursor, pid): try: - result=cursor.execute("SELECT * FROM vaccination LEFT JOIN inventory ON vaccination.iid=inventory.iid WHERE pid=?", (pid,)) + result=cursor.execute("SELECT * FROM vaccination LEFT JOIN inventory ON vaccination.iid=inventory.iid WHERE pid=? ORDER BY vaccination.date", (pid,)) if(cursor.rowcount==0): return (False, "Record not found.") else: @@ -57,7 +57,7 @@ def list_by_patient(cursor, pid): def list_by_inventory(cursor, iid): try: - result=cursor.execute("SELECT * FROM vaccination LEFT JOIN patients ON vaccination.pid=patients.pid WHERE iid=?", (iid,)) + result=cursor.execute("SELECT * FROM vaccination LEFT JOIN patients ON vaccination.pid=patients.pid WHERE iid=? ORDER BY vaccination.date", (iid,)) if(cursor.rowcount==0): return (False, "Record not found.") else: -- 2.39.5