From 2ef33d415b0926d20002d170149e99b8cc6250d5 Mon Sep 17 00:00:00 2001
From: Agnibho Mondal <mondal@agnibho.com>
Date: Thu, 3 Jun 2021 02:43:44 +0530
Subject: [PATCH] Option to delete drug

---
 lib/db.php         | 12 +++++++++++-
 www/res/custom.css |  5 ++++-
 www/treatment.php  | 17 +++++++++++++----
 3 files changed, 28 insertions(+), 6 deletions(-)

diff --git a/lib/db.php b/lib/db.php
index 18ad8b5..88333d7 100644
--- a/lib/db.php
+++ b/lib/db.php
@@ -175,6 +175,15 @@ class DB extends SQLite3 {
     $stmt->execute();
     $log->log(null, "drug_omitted", $id);
   }
+  function deleteDrug($id){
+    global $log;
+    if(!checkAccess("treatment", "dbSet")) return false;
+    $stmt=$this->prepare("UPDATE treatment SET omit=:omit WHERE rowid=:id;");
+    $stmt->bindValue(":omit", -1);
+    $stmt->bindValue(":id", $id);
+    $stmt->execute();
+    $log->log(null, "drug_deleted", $id);
+  }
   function giveDrug($id, $given){
     global $log;
     if(!checkAccess("nursing", "dbSet")) return false;
@@ -262,8 +271,9 @@ class DB extends SQLite3 {
   function getDrugs($pid){
     global $log;
     if(!checkAccess("treatment", "dbGet")) return false;
-    $stmt=$this->prepare("SELECT rowid,* FROM treatment WHERE pid=:pid ORDER BY omit,start;");
+    $stmt=$this->prepare("SELECT rowid,* FROM treatment WHERE pid=:pid AND omit!=:omit ORDER BY omit,start;");
     $stmt->bindValue(":pid", $pid);
+    $stmt->bindValue(":omit", -1);
     $result=$stmt->execute();
     return($result);
   }
diff --git a/www/res/custom.css b/www/res/custom.css
index 9e5575c..f3c0280 100644
--- a/www/res/custom.css
+++ b/www/res/custom.css
@@ -1,6 +1,9 @@
 .omit{
 	text-decoration: line-through;
 }
-.omit>td>button{
+.omit>td>button.nomit{
+	display: none;
+}
+.nomit>td>button.omit{
 	display: none;
 }
diff --git a/www/treatment.php b/www/treatment.php
index 6ce66d3..1d6b152 100644
--- a/www/treatment.php
+++ b/www/treatment.php
@@ -16,6 +16,9 @@ if(!empty($_GET["pid"])){
   elseif(!empty($_POST["omit"])){
     $db->omitDrug($_POST["omit"], $_POST["date"], $_POST["time"]);
   }
+  elseif(!empty($_POST["delete"])){
+    $db->deleteDrug($_POST["delete"]);
+  }
   elseif(!empty($_POST["drug"])){
     $db->addDrug($pid, $_POST["drug"], $_POST["dose"], $_POST["route"], $_POST["frequency"], $_POST["date"], $_POST["time"], $_POST["duration"], $_POST["extra_note"]);
   }
@@ -26,7 +29,7 @@ if(!empty($_GET["pid"])){
       $omit="omit";
     }
     else{
-      $omit="";
+      $omit="nomit";
       //try{
       //  if($drug["start"]+$drug["duration"]*24*3600<time()){
       //    $db->omitDrug($drug["rowid"]);
@@ -47,9 +50,11 @@ if(!empty($_GET["pid"])){
     else{
       $end="";
     }
-    $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"]).$end."</td><td>".$drug["duration"]."</td><td>".$drug["addl"]."</td><td>".$last."</td><td><button type='submit' class='btn btn-success confirm' name='give' value='".$drug["rowid"]."' form='administer' ".$omit." ".checkAccess("nursing", "form").">Give</button></td><td><button type='submit' class='btn btn-warning confirm' name='omit' value='".$drug["rowid"]."' form='omitter' ".$omit." ".checkAccess("treatment", "form").">Omit</button></td></tr>";
+    if(filter_var($drug["duration"], FILTER_VALIDATE_INT)){
+      $drug["duration"]=$drug["duration"]. " days";
+    }
+    $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"]).$end."</td><td>".$drug["duration"]."</td><td>".$drug["addl"]."</td><td>".$last."</td><td><button type='submit' class='btn btn-success nomit confirm' name='give' value='".$drug["rowid"]."' form='administer' ".$omit." ".checkAccess("nursing", "form").">Give</button><button type='submit' class='btn btn-warning nomit confirm' name='omit' value='".$drug["rowid"]."' form='omitter' ".$omit." ".checkAccess("treatment", "form").">Omit</button><button type='submit' class='btn btn-secondary omit confirm' name='delete' value='".$drug["rowid"]."' form='delete' ".$omit." ".checkAccess("treatment", "form").">Delete</button></td></tr>";
   }
-  $view=$view."</table>";
   $form=schema2form("forms/drugs.schema.json");
   if(checkAccess("treatment")=="all" && $db->getStatus($pid)->fetchArray()["status"]=="admitted"){
     $hideForm="";
@@ -79,8 +84,12 @@ if(!empty($_GET["pid"])){
             <input type="hidden" name="date">
             <input type="hidden" name="time">
           </form>
+          <form method='post' id='delete'>
+            <input type="hidden" name="date">
+            <input type="hidden" name="time">
+          </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>Given</th><th></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></tr>
             <?php echo $view;?>
           </table>
         </div>
-- 
2.39.5