$query->bindValue(":pid", $post["pid"]);
$exist=$query->execute();
if($exist->fetchArray()[0]==0){
- $stmt=$this->prepare("INSERT INTO patients (pid,name,age,sex,status,vp,ward,bed,data) VALUES (:pid,:name,:age,:sex,:status,:vp,:ward,:bed,:data);");
+ $stmt=$this->prepare("INSERT INTO patients (pid,name,age,sex,admission,status,vp,ward,bed,data) VALUES (:pid,:name,:age,:sex,:admission,:status,:vp,:ward,:bed,:data);");
}
else{
- $stmt=$this->prepare("UPDATE patients SET name=:name,age=:age,sex=:sex,ward=:ward,bed=:bed,vp=:vp,data=:data WHERE pid=:pid;");
+ $stmt=$this->prepare("UPDATE patients SET name=:name,age=:age,sex=:sex,admission=:admission,ward=:ward,bed=:bed,vp=:vp,data=:data WHERE pid=:pid;");
}
$stmt->bindValue(":pid", $post["pid"]);
$stmt->bindValue(":name", $post["name"]);
$stmt->bindValue(":age", $post["age"]);
$stmt->bindValue(":sex", $post["sex"]);
+ $stmt->bindValue(":admission", strtotime($post["date"]." ".$post["time"]));
$stmt->bindValue(":status", "admitted");
$stmt->bindValue(":ward", $post["ward"]);
$stmt->bindValue(":bed", $post["bed"]);
header("Location: view.php?pid=".$_GET["pid"]);
exit();
}
+ $all=$db->getAllData($pid, "nursing");
+ $io="";
+ $lastIO="";
+ while($io=="" && $a=$all->fetchArray()){
+ $d=json_decode($a["data"]);
+ $io=$d->intake.$d->output;
+ $lastIO=$d->io_to;
+ }
+ if($lastIO==""){
+ $d=$db->getAdmission($pid)->fetchArray();
+ $dt=new DateTime();
+ $dt->setTimestamp($d["admission"]);
+ $lastIO=$dt->format("H:i");
+ }
if(isSet($_GET["id"])){
$form=schema2form("forms/nursing.schema.json", $pid, $_GET["id"], "nursing");
}
<title>Nursing Notes</title>
</head>
<body>
+ <input type="hidden" id="io_to_val" name="lastIO" value="<?php echo $lastIO;?>">
<div class="container">
<?php include(CONFIG_LIB."top.php");?>
<?php echo getInfo($pid);?>