From 71aee54a3d5d89d3fc51a8edde6783fcd4312c7b Mon Sep 17 00:00:00 2001
From: Agnibho Mondal <mondal@agnibho.com>
Date: Sat, 22 May 2021 16:11:45 +0530
Subject: [PATCH] Sorted requisition list

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

diff --git a/lib/db.php b/lib/db.php
index df9589a..33d8cab 100644
--- a/lib/db.php
+++ b/lib/db.php
@@ -361,7 +361,7 @@ class DB extends SQLite3 {
   function getRequisitionList(){
     global $log;
     if(!checkAccess("requisition", "dbGet")) return false;
-    $stmt=$this->prepare("SELECT rowid,pid,test,sample,room,time,form FROM requisition WHERE status=:active;");
+    $stmt=$this->prepare("SELECT rowid,pid,test,sample,room,time,form FROM requisition WHERE status=:active ORDER BY room;");
     $stmt->bindValue(":active", "active");
     $result=$stmt->execute();
     return($result);
-- 
2.39.2