From 46f02bf038104c6f53ec0bf801f2b1bfdbbcd50a Mon Sep 17 00:00:00 2001
From: Agnibho Mondal <mondal@agnibho.com>
Date: Thu, 3 Jun 2021 05:44:08 +0530
Subject: [PATCH] Minor

---
 lib/db.php | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/lib/db.php b/lib/db.php
index 88333d7..c6cdde3 100644
--- a/lib/db.php
+++ b/lib/db.php
@@ -383,9 +383,10 @@ class DB extends SQLite3 {
   function getRequisitionList(){
     global $log;
     if(!checkAccess("requisition", "dbGet")) return false;
-    $stmt=$this->prepare("SELECT requisition.rowid,requisition.* FROM requisition INNER JOIN patients ON requisition.pid=patients.pid WHERE requisition.status!=:status AND patients.status=:admitted ORDER BY requisition.room,requisition.test;");
+    $stmt=$this->prepare("SELECT requisition.rowid,requisition.* FROM requisition INNER JOIN patients ON requisition.pid=patients.pid WHERE requisition.status!=:status AND patients.status=:admitted AND requisition.time<:today ORDER BY requisition.room,requisition.test;");
     $stmt->bindValue(":status", "done");
     $stmt->bindValue(":admitted", "admitted");
+    $stmt->bindValue(":today", time());
     $result=$stmt->execute();
     return($result);
   }
-- 
2.39.5