From 5ee0f1eac6dc0f45dc2e922102c09c8078ac0ee7 Mon Sep 17 00:00:00 2001
From: Agnibho Mondal <mondal@agnibho.com>
Date: Mon, 7 Jun 2021 08:25:41 +0530
Subject: [PATCH] Minor

---
 lib/db.php      | 7 +++++++
 www/archive.php | 2 +-
 2 files changed, 8 insertions(+), 1 deletion(-)

diff --git a/lib/db.php b/lib/db.php
index 1cfdb5a..1bff683 100644
--- a/lib/db.php
+++ b/lib/db.php
@@ -380,6 +380,13 @@ class DB extends SQLite3 {
     $result=$stmt->execute();
     return($result);
   }
+  function getArchivedPatientList(){
+    global $log;
+    if(!checkAccess("info", "dbGet")) return false;
+    $stmt=$this->prepare("SELECT pid,ward,bed,name,diagnosis FROM patients WHERE status!='admitted' ORDER BY UPPER(ward),bed;");
+    $result=$stmt->execute();
+    return($result);
+  }
   function getRequisitionList(){
     global $log;
     if(!checkAccess("requisition", "dbGet")) return false;
diff --git a/www/archive.php b/www/archive.php
index 1ebfe0a..a59846b 100644
--- a/www/archive.php
+++ b/www/archive.php
@@ -1,6 +1,6 @@
 <?php
 require(dirname(__DIR__)."/require.php");
-$list=$db->getPatientList();
+$list=$db->getArchivedPatientList();
 $showList="";
 while($arr=$list->fetchArray()){
   $pid=$arr["pid"];
-- 
2.39.5