| Server IP : 162.240.98.243 / Your IP : 18.217.107.229 Web Server : Apache System : Linux server.bti.yaw.mybluehostin.me 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : btiyawmy ( 1003) PHP Version : 7.2.34 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/btiyawmy/public_html/login.easenup.in/ |
Upload File : |
<?php
session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');
include 'dashboarddocument.php';
include("../dbconnection.php");
?>
<?php
include 'fileheader.php';
?>
<h3 align='center'>Case Summery</h3>
<table id="example2" class="table table-bordered table-hover">
<tr>
<th>Created at</th>
<th>Diagnosis</th>
<th>Treatment/Surgery</th>
</tr>
<?php
$sql ="SELECT * FROM diagnosis_timiline WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'";
$qsql = mysqli_query($con,$sql);
while($rs4 = mysqli_fetch_array($qsql))
{
echo" <td>$rs4[created_at]</td>
<td> $rs4[diagnosis]</td>
<td> ";
$sqlpatient1 = "SELECT * FROM list_tretment Where trid='$rs4[Surgery]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo"
$rsn[tratment]";
}
echo"</td>
</tr>
";
}
?>
</table>
<table id="example2" class="table table-bordered table-hover">
<thead>
<tr>
<th><strong>Towords</strong></th>
<th><strong>Vitals</strong></th>
</tr>
</thead>
<?php
include("dbconnection.php");
$sql ="SELECT * FROM vitals_final WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND updated_at='$_GET[updated_at]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$sql12 ="SELECT * FROM site_users WHERE userno='$rs[entered_by]' ";
$qsql12 = mysqli_query($con,$sql12);
while($rs1 = mysqli_fetch_array($qsql12))
echo"
<tr><td> <b>Date & Time : </b></b>$rs[created_at] <br><b>Created By :</b> $rs1[name] <br><b>Towords : </b> $rs[poa]</td><td>
<b>BMI : </b>
$rs[bmi]<br> <b>Weight : </b>
$rs[Wt]<br><b>BP(mmHg) : </b>$rs[BP2]/$rs[BP]<br><b>RBS : </b>$rs[RBS]<br><b>HR : </b>$rs[HR]<br><b>Temp : </b>$rs[Temp]<br><b>Spo2 : </b>$rs[Spo2]<br><b>Pulse : </b>$rs[Pulse]</td>
</tr>
";
}
?> </tbody>
<tfoot>
</tfoot>
</table>
<table id="example2" id ="demo" class="table table-bordered table-hover">
<thead>
<tr>
<div id="listingTable">
<div class='card-header d-flex p-0'>
<ul class='nav nav-pills ml-auto p-2'>
<th><strong>Date Time</strong></th>
<th><strong>Investigation</strong></th>
<th><strong>Result</strong></th>
<th><strong>Evidence</strong></th>
</tr>
</thead>
<?php
include("dbconnection.php");
$sql ="SELECT * FROM investigation WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND updated_at='$_GET[created_at]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo " <tbody>
<tr> <td> $rs[created_at]</td>
<td> ";
if (is_numeric($rs[Category]))
{
$sql1 ="SELECT * FROM labdepartment WHERE labdepartmentid='$rs[Category]'";
$qsql1 = mysqli_query($con,$sql1);
while($rh1 = mysqli_fetch_array($qsql1))
echo "$rh1[lab_department_name]";
}
if (is_numeric($rs[Sub_Category]))
{
$sql1 ="SELECT * FROM radiobodypart WHERE radiobodypartid='$rs[Sub_Category]'";
$qsql1 = mysqli_query($con,$sql1);
while($rh1 = mysqli_fetch_array($qsql1))
echo "- $rh1[bodypart]";
}
if (is_numeric($rs[Sub_Category]))
{
$sql1 ="SELECT * FROM list_Investigation WHERE ivid='$rs[Investigation]'";
$qsql1 = mysqli_query($con,$sql1);
while($rh1 = mysqli_fetch_array($qsql1))
echo "- $rh1[Investigation]";
}
$sqlpatient1 = "SELECT * FROM list_Investigation WHERE ivid='$rs[ivid]' OR ivid='$rs[Investigation]' AND labdepartmentid='Unspecified'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
echo"
$rsn[Investigation]"; }
echo"</b></td>
<td> $rs[Result]</td>
<td> $rs[Evidence]</td>
</tr>
";
}
?>
</tbody>
</table>
<table id="example2" id ="demo" class="table table-bordered table-hover">
<tr>
<th>Medication Details</th>
<th>Administered By & At</th>
<th>Towards</th>
</tr>
<?php
include("dbconnection.php");
$today = date('Y/m/d');
$sql ="SELECT * FROM medication_mng WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND admissiondate='$_GET[created_at]'";
$qsql = mysqli_query($con,$sql);
while($rs123 = mysqli_fetch_array($qsql))
{
$sql99 ="SELECT * FROM medicinede WHERE DRUGS='$rs123[DRUGS]' AND prescriptionid='$rs123[prescriptionid]'";
$qsql99 = mysqli_query($con,$sql99);
while($rs= mysqli_fetch_array($qsql99))
{
echo" <tr>";
echo "<td><b>Drug : </b>";
if (is_numeric($rs[DRUGS]))
{
$sql1 ="SELECT * FROM medicine_stok WHERE medicine_id='$rs[DRUGS]'";
$qsql1 = mysqli_query($con,$sql1);
while($rs1 = mysqli_fetch_array($qsql1))
echo"$rs1[DRUGS_name]";
}
else
{
echo"$rs[DRUGS]";
}
echo" <br><b>Dose : </b>$rs[Dose]<br><b>Route : </b>$rs[Route]<br>"; echo "<b>Frequency :</b> ";
switch ($rs[Frequency]) {
case '01':
echo "OD (Once Daily)";
break;
case '2':
echo "BID/b.i.d. (twice a day)";
break;
case '3':
echo "TID/t.id. (three times a day)";
break;
case '04':
echo "QID/q.i.d. (four times a day)";
break;
case '1':
echo "QHS (every bedtime)";
break;
case '6':
echo "Q4h (every 4 hours)";
break;
case '4':
echo "Q4-6h (every 4 to 6 hours)";
break;
case '0.143':
echo "QWK (every week)";
break;
default:
echo "";
}
if (is_numeric($rs123[entered_by]))
{
$sqldoctor= "SELECT * FROM site_users WHERE userno='$rs123[entered_by]'";
$qsqldoctor = mysqli_query($con,$sqldoctor);
while($rsdoctor = mysqli_fetch_array($qsqldoctor))
{
echo"
</td><td> <b>By :</b>$rsdoctor[name]
<br><b>At :</b> $rs123[created_at]</td>";
}
echo"<td>$rs123[status] <br> $rs123[timeslot]</td>
</tr> ";
}
}
}
?>
</table>