]> Softwares of Agnibho - simpleipd.git/commitdiff
Minor
authorAgnibho Mondal <mondal@agnibho.com>
Sun, 13 Jun 2021 12:22:22 +0000 (17:52 +0530)
committerAgnibho Mondal <mondal@agnibho.com>
Sun, 13 Jun 2021 12:22:22 +0000 (17:52 +0530)
lib/db.php

index 86e37608ebe006bd7ca5e54046f9f7782914295a..73671742d31d91cd930cb463f941a216c390a780 100644 (file)
@@ -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());