From db218c44b2469baf89ed0b919b828714a61e9d6e Mon Sep 17 00:00:00 2001
From: Agnibho Mondal <mondal@agnibho.com>
Date: Mon, 31 May 2021 23:36:36 +0530
Subject: [PATCH] Added sample tracing

---
 lib/db.php    | 19 ++++++++++++++-----
 www/index.php | 15 ++++++++++++++-
 2 files changed, 28 insertions(+), 6 deletions(-)

diff --git a/lib/db.php b/lib/db.php
index 354f3a8..1b726ea 100644
--- a/lib/db.php
+++ b/lib/db.php
@@ -192,11 +192,20 @@ class DB extends SQLite3 {
     $stmt->bindValue(":time", strtotime($date." ".$time));
     $stmt->bindValue(":room", $room);
     $stmt->bindValue(":form", $form);
-    $stmt->bindValue(":status", "active");
+    $stmt->bindValue(":status", "sent");
     $stmt->bindValue(":addl", $addl);
     $stmt->execute();
     $log->log($pid, "requisition_added", json_encode([$test,$room,$form]));
   }
+  function receiveRequisition($id){
+    global $log;
+    if(!checkAccess("report", "dbSet")) return false;
+    $stmt=$this->prepare("UPDATE requisition SET status=:status WHERE rowid=:id;");
+    $stmt->bindValue(":status", "received");
+    $stmt->bindValue(":id", $id);
+    $stmt->execute();
+    $log->log(null, "requisition_received", $id);
+  }
   function omitRequisition($id){
     global $log;
     if(!checkAccess("requisition", "dbSet")) return false;
@@ -267,9 +276,9 @@ class DB extends SQLite3 {
   function getRequisitions($pid){
     global $log;
     if(!checkAccess("requisition", "dbGet")) return false;
-    $stmt=$this->prepare("SELECT rowid,* FROM requisition WHERE pid=:pid AND status=:status ORDER BY room;");
+    $stmt=$this->prepare("SELECT rowid,* FROM requisition WHERE pid=:pid AND status!=:status ORDER BY room;");
     $stmt->bindValue(":pid", $pid);
-    $stmt->bindValue(":status", "active");
+    $stmt->bindValue(":status", "done");
     $result=$stmt->execute();
     return($result);
   }
@@ -362,8 +371,8 @@ 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=:active AND patients.status=:admitted ORDER BY requisition.room,requisition.test;");
-    $stmt->bindValue(":active", "active");
+    $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");
     $result=$stmt->execute();
     return($result);
diff --git a/www/index.php b/www/index.php
index 2813278..2465d09 100644
--- a/www/index.php
+++ b/www/index.php
@@ -1,5 +1,8 @@
 <?php
 require(dirname(__DIR__)."/require.php");
+if(!empty($_POST["req"])){
+  $db->receiveRequisition($_POST["req"]);
+}
 $list=$db->getAdmittedPatientList();
 $showList="";
 while($arr=$list->fetchArray()){
@@ -21,7 +24,16 @@ while($arr=$reqs->fetchArray()){
   else{
     $test="<a href='report.php?pid=".$pid."&form=report-other&req=".$arr["rowid"]."&src=index'>".$arr["test"]."</a>";
   }
-  $showReqs=$showReqs."<tr><td>".$test."</td><td>".$arr["sample"]."</td><td>".$arr["room"]."</td><td>".date("M j", $arr["time"])."</td><td><a href='view.php?pid=".$pid."' target='_blank'>".$pid."</a></td></tr><tr><td></td><td colspan='4'>".$arr["addl"]."</td></tr>";
+  if($arr["status"]=="received"){
+    $received="<span class='badge badge-success'>Sample Received</span>";
+  }
+  elseif(checkAccess("report")){
+    $received="<button class='btn btn-sm btn-outline-danger confirm' form='sample' name='req' value='".$arr["rowid"]."'>Receive Sample</button>";
+  }
+  else{
+    $received="<span class='badge badge-warning'>Sample Not Received</span>";
+  }
+  $showReqs=$showReqs."<tr><td>".$test."</td><td>".$arr["sample"]."</td><td>".$arr["room"]."</td><td>".date("M j", $arr["time"])."</td><td><a href='view.php?pid=".$pid."' target='_blank'>".$pid."</a></td></tr><tr><td></td><td colspan='3'>".$arr["addl"]."</td><td>".$received."</td></tr>";
 }
 ?>
 <!DOCTYPE html>
@@ -47,6 +59,7 @@ while($arr=$reqs->fetchArray()){
       <div class="card">
         <div class="card-body">
           <h4 class="card-title">Requisition List</h4>
+          <form id="sample" method="post"></form>
           <table class="table table-striped">
             <tr><th>Test Needed</th><th>Sample</th><th>Place</th><th>Date</th><th>Patient ID</th></tr>
             <?php echo $showReqs;?>
-- 
2.39.5