From 9dd99f873295f895dc11ac77d652d922f215b80d Mon Sep 17 00:00:00 2001
From: Agnibho Mondal <mondal@agnibho.com>
Date: Fri, 21 May 2021 03:50:46 +0530
Subject: [PATCH] Added drug administration record

---
 data.schema.sql   |  1 +
 lib/db.php        | 17 +++++++++++++++++
 www/treatment.php | 25 ++++++++++++++++++++++---
 3 files changed, 40 insertions(+), 3 deletions(-)

diff --git a/data.schema.sql b/data.schema.sql
index 579ec18..9875979 100644
--- a/data.schema.sql
+++ b/data.schema.sql
@@ -63,6 +63,7 @@ frequency text,
 start int,
 end int,
 duration text,
+administer text,
 omit boolean,
 addl text
 );
diff --git a/lib/db.php b/lib/db.php
index 2d2e5b4..0f245dc 100644
--- a/lib/db.php
+++ b/lib/db.php
@@ -173,6 +173,15 @@ class DB extends SQLite3 {
     $stmt->execute();
     $log->log(null, "drug_omitted", $id);
   }
+  function giveDrug($id, $given){
+    global $log;
+    if(!checkAccess("treatment", "dbSet")) return false;
+    $stmt=$this->prepare("UPDATE treatment SET administer=:given WHERE rowid=:id;");
+    $stmt->bindValue(":given", $given);
+    $stmt->bindValue(":id", $id);
+    $stmt->execute();
+    $log->log(null, "drug_given", $id);
+  }
   function addRequisition($pid, $test, $sample, $date, $time, $room, $form){
     global $log;
     if(!checkAccess("requisition", "dbSet")) return false;
@@ -246,6 +255,14 @@ class DB extends SQLite3 {
     $result=$stmt->execute();
     return($result);
   }
+  function getAdminister($pid){
+    global $log;
+    if(!checkAccess("nursing", "dbGet")) return false;
+    $stmt=$this->prepare("SELECT rowid,administer FROM treatment WHERE pid=:pid;");
+    $stmt->bindValue(":pid", $pid);
+    $result=$stmt->execute();
+    return($result);
+  }
   function getRequisitions($pid){
     global $log;
     if(!checkAccess("requisition", "dbGet")) return false;
diff --git a/www/treatment.php b/www/treatment.php
index 72b6ad0..b4b9bc4 100644
--- a/www/treatment.php
+++ b/www/treatment.php
@@ -2,7 +2,18 @@
 require(dirname(__DIR__)."/require.php");
 if(!empty($_GET["pid"])){
   $pid=$_GET["pid"];
-  if(!empty($_POST["omit"])){
+  if(!empty($_POST["give"])){
+    $administer=$db->getAdminister($pid)->fetchArray();
+    if(!empty($administer["administer"])){
+      $given=(array)json_decode($administer["administer"]);
+    }
+    else{
+      $given=[];
+    }
+    array_push($given, time());
+    $db->giveDrug($_POST["give"], json_encode($given));
+  }
+  elseif(!empty($_POST["omit"])){
     $db->omitDrug($_POST["omit"]);
   }
   elseif(!empty($_POST["drug"])){
@@ -23,7 +34,14 @@ if(!empty($_GET["pid"])){
       //  }
       //} catch(TypeError $e){}
     }
-    $view=$view."<tr class='".$omit."'><td>".$drug["drug"]."</td><td>".$drug["dose"]."</td><td>".$drug["route"]."</td><td>".$drug["frequency"]."</td><td>".date("M j", $drug["start"])."</td><td>".$drug["duration"]."</td><td>".$drug["addl"]."</td><td><button type='submit' class='btn btn-warning' name='omit' value='".$drug["rowid"]."' form='omitter' ".$omit." ".checkAccess("treatment", "form").">Omit</button></td></tr>";
+    if(!empty($drug["administer"])){
+      $administer=json_decode($drug["administer"]);
+      $last=date("H:i", end($administer));
+    }
+    else{
+      $last="";
+    }
+    $view=$view."<tr class='".$omit."'><td>".$drug["drug"]."</td><td>".$drug["dose"]."</td><td>".$drug["route"]."</td><td>".$drug["frequency"]."</td><td>".date("M j", $drug["start"])."</td><td>".$drug["duration"]."</td><td>".$drug["addl"]."</td><td>".$last."</td><td><button type='submit' class='btn btn-success' name='give' value='".$drug["rowid"]."' form='administer' ".$omit." ".checkAccess("nursing", "form").">Give</button></td><td><button type='submit' class='btn btn-warning' name='omit' value='".$drug["rowid"]."' form='omitter' ".$omit." ".checkAccess("treatment", "form").">Omit</button></td></tr>";
   }
   $view=$view."</table>";
   $form=schema2form("forms/drugs.schema.json");
@@ -42,8 +60,9 @@ if(!empty($_GET["pid"])){
         <div class="card-body">
           <h4 class="card-title">Medicine List</h4>
           <form method='post' id='omitter'></form>
+          <form method='post' id='administer'></form>
           <table class="table">
-            <tr><th>Drug</th><th>Dose</th><th>Route</th><th>Frequency</th><th>Start</th><th>Duration</th><th>Note</th><th></th></tr>
+            <tr><th>Drug</th><th>Dose</th><th>Route</th><th>Frequency</th><th>Start</th><th>Duration</th><th>Note</th><th>Given</th><th></th><th></th></tr>
             <?php echo $view;?>
           </table>
         </div>
-- 
2.39.5