From 037710cf97cf388051a1cabaf0c51f1e8c2b35b3 Mon Sep 17 00:00:00 2001 From: Agnibho Mondal Date: Sun, 13 Jun 2021 17:52:22 +0530 Subject: [PATCH] Minor --- lib/db.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/db.php b/lib/db.php index 86e3760..7367174 100644 --- a/lib/db.php +++ b/lib/db.php @@ -411,7 +411,7 @@ 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 AND requisition.time<:today 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 ORDER BY requisition.room,requisition.test;"); $stmt->bindValue(":status", "done"); $stmt->bindValue(":admitted", "admitted"); $stmt->bindValue(":today", time()); -- 2.39.5