From cd2da89b1e0ec372b8764d97b41757db0a90688c Mon Sep 17 00:00:00 2001
From: Agnibho Mondal <mondal@agnibho.com>
Date: Fri, 11 Jun 2021 02:44:19 +0530
Subject: [PATCH] Fixed departure

---
 lib/db.php        | 7 +++++--
 www/printdata.php | 4 +++-
 www/view.php      | 4 +++-
 3 files changed, 11 insertions(+), 4 deletions(-)

diff --git a/lib/db.php b/lib/db.php
index 9cdffbc..86e3760 100644
--- a/lib/db.php
+++ b/lib/db.php
@@ -267,9 +267,10 @@ class DB extends SQLite3 {
   function setDischarged($pid){
     global $log;
     if(!checkAccess("discharge", "dbSet")) return false;
-    $stmt=$this->prepare("UPDATE patients SET status=:discharged WHERE pid=:pid;");
+    $stmt=$this->prepare("UPDATE patients SET status=:discharged,departure=:time WHERE pid=:pid;");
     $stmt->bindValue(":pid", $pid);
     $stmt->bindValue(":discharged", "discharged");
+    $stmt->bindValue(":time", time());
     $stmt->execute();
     $log->log($pid, "discharged", null);
   }
@@ -281,8 +282,10 @@ class DB extends SQLite3 {
     $stmt->bindValue(":time", strtotime($post["date"].$post["time"]));
     $stmt->bindValue(":data", json_encode($post));
     $stmt->execute();
-    $stmt=$this->prepare("UPDATE patients SET status='expired' WHERE pid=:pid;");
+    $stmt=$this->prepare("UPDATE patients SET status=:expired,departure=:time WHERE pid=:pid;");
     $stmt->bindValue(":pid", $pid);
+    $stmt->bindValue(":expired", "expired");
+    $stmt->bindValue(":time", time());
     $stmt->execute();
     $log->log($pid, "death_declare", json_encode($post));
   }
diff --git a/www/printdata.php b/www/printdata.php
index 60178f2..2e2bf64 100644
--- a/www/printdata.php
+++ b/www/printdata.php
@@ -9,6 +9,7 @@ $death="<h4>Medical Cause of Death</h4>";
 if($_GET["pid"]){
   $pid=$_GET["pid"];
   $status=$db->getStatus($pid)->fetchArray()["status"];
+  $departure=$db->getDeparture($pid)->fetchArray()["departure"];
   $info=getInfo($pid);
   $history=viewData($db->getHistory($pid)->fetchArray()["history"]);
   $physicianArray=$db->getAllData($pid, "physician");
@@ -78,7 +79,8 @@ $discharge=$discharge."</ol>";
       <h2><?php echo CONFIG_TITLE;?></h2>
       <h4><?php echo "Patient Record";?></h4>
       <?php echo $info;?>
-      <?php echo "<p><strong>Status: </strong>".$status."</p>";?>
+      <?php echo "<p><strong>Status: </strong>".$status."<br>";?>
+      <?php if(!empty($departure)) echo "(".date("M d, Y h:i a", $departure).")</p>"; ?>
       <?php echo $history;?>
       <?php foreach($physician as $p) echo $p;?>
       <?php foreach($nursing as $n) echo $n;?>
diff --git a/www/view.php b/www/view.php
index 8267a4d..8e63acc 100644
--- a/www/view.php
+++ b/www/view.php
@@ -24,9 +24,11 @@ if(isSet($_GET["pid"])){
   $status=$db->getStatus($pid)->fetchArray()["status"];
   if($status!="admitted"){
     $archive="disabled";
+    $departure=$db->getDeparture($pid)->fetchArray()["departure"];
   }
   else{
     $archive="";
+    $departure="";
   }
   $info=viewData($db->getAdmissionData($pid)->fetchArray()["data"]);
   $history=$db->getHistory($pid)->fetchArray()["history"];
@@ -128,7 +130,7 @@ if(isSet($_GET["pid"])){
         </ul>
         <div class="tab-content" id="viewtabs">
           <div class="tab-pane fade show active" id="info" role="tabpanel" aria-labelledby="info-tab">
-            <div class='card'><div class='card-body'>Status: <?php echo $status;?></div></div>
+            <div class='card'><div class='card-body'>Status: <?php echo $status;?><?php if(!empty($departure)) echo " (".date("M d, Y h:i a", $departure).")"; ?></div></div>
             <div class="row">
               <div class="col-md-6">
                 <?php echo $info;?>
-- 
2.39.5