From a420446603579e65c058e7627a9d9e662549c734 Mon Sep 17 00:00:00 2001
From: Agnibho Mondal <mondal@agnibho.com>
Date: Wed, 26 May 2021 12:31:13 +0530
Subject: [PATCH] Modified requisition query

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

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