Minor

diff --git a/lib/db.php b/lib/db.php
index 88333d7865294f58f0cbdc509f23170b0e111537..c6cdde3cb9a8a6c3ea26736ea6e5c0f2668cdaaa 100644 (file)
--- 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);
   }