| Server IP : 162.240.98.243 / Your IP : 18.189.178.53 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("header.php");
include 'dashboarddocument.php';
?>
<style>
#topright {
position: absolute;
right: 0;
top: 0;
margin-top: 73px;
margin-right: 30px;
display: block;
height: 70px;
width: 70px;
background: url(TRbanner.gif) no-repeat;
text-indent: -999em;
text-decoration: none;
}
#toprightj {
position: absolute;
right: 0;
top: 0;
margin-top: 73px;
margin-right: 120px;
display: block;
height: 70px;
width: 70px;
background: url(TRbanner.gif) no-repeat;
text-indent: -999em;
text-decoration: none;
}
#toprightb {
position: absolute;
right: 0;
top: 0;
margin-top: 73px;
margin-right: 200px;
display: block;
height: 70px;
width: 70px;
background: url(TRbanner.gif) no-repeat;
text-indent: -999em;
text-decoration: none;
}
.center {
border: 1px solid grey;
text-align:;
}
.center2 {
border: 5px solid grey;
text-align:;
}
</style>
<form>
<div class="content-wrapper">
<div class='center'>
<?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM emp WHERE adminid='$harilal'";
$qsql = mysqli_query($con,$sql);
if($rt = mysqli_fetch_array($qsql))
{
if(on==$rt[iso])
{
?>
<p STYLE='font-size:18px'> AN ISO 9001:2015 Certified co.</p>
<?php
}
}
?>
<?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM emp WHERE adminid='$harilal'";
$qsql = mysqli_query($con,$sql);
if($rt = mysqli_fetch_array($qsql))
{
if(on==$rt[iso14])
{
?>
<p STYLE='font-size:18px'> AN ISO 14001:2015 Certified co.</p>
<?php
}
}
?>
<?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM emp WHERE adminid='$harilal'";
$qsql = mysqli_query($con,$sql);
if($rt = mysqli_fetch_array($qsql))
{
if(on==$rt[iso27])
{
?>
<p STYLE='font-size:18px'> AN ISO 27001 Certified co.</p>
<?php
}
}
?>
<?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM emp WHERE adminid='$harilal'";
$qsql = mysqli_query($con,$sql);
if($rt = mysqli_fetch_array($qsql))
{
if(on==$rt[NABH])
{
?>
<img id='topright' align='top' src='uploads/nabh.png' width='70' height='70'>
<?php
}
}
?>
<?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM emp WHERE adminid='$harilal'";
$qsql = mysqli_query($con,$sql);
if($rt = mysqli_fetch_array($qsql))
{
if(on==$rt[NABL])
{
?>
<img id='toprightb' align='right' src='uploads/nabl.png' width='70' height='70'>
<?php
}
}
?>
<?php
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM emp WHERE adminid='$harilal'";
$qsql = mysqli_query($con,$sql);
if($rt = mysqli_fetch_array($qsql))
{
if(on==$rt[JCI])
{
?>
<img id='toprightj' align='right' src='uploads/JCI.png' width='70' height='70'>
<?php
}
}
?>
<br><br>
<section id="memo">
<div class="logo">
<?php
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM hco WHERE adminid='$usertype'";
$qsql = mysqli_query($con,$sql);
if($rs = mysqli_fetch_array($qsql))
{
$sql ="SELECT * FROM admin WHERE id='$rs[adminid]'";
$qsql = mysqli_query($con,$sql);
if($ra = mysqli_fetch_array($qsql))
{
echo"
<img data-logo='' src='uploads/$rs[Logo]' />
</div>
<div class='company-info'>
<div>$ra[hsname]</div>
<div>
<span style='font-size:18px'>$rs[Street] | $rs[Locality]</br>$ra[EmailID] | $ra[numbers]</p></span>
</div>
";
}
}
?>
<br>
</section>
<br><br>
</table><h2 align="center">Vitals</h2>
<table id="example2" class="table table-bordered table-hover">
<thead>
<tr>
<div class='card-header d-flex p-0'>
<ul class='nav nav-pills ml-auto p-2'>
<th>Wt </th>
<th>SPo2 </th>
<th>RBS </th>
<th>Temp</th>
<th>Pulse</th>
<th>BP</th>
</tr>
</thead>
<tr><?php
$sql ="SELECT * FROM request_for_admission WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo " <tbody>
<tr> <td> $rs[Wt]</td>
<td> $rs[SPo2]</td>
<td> $rs[RBS]</td>
<td> $rs[Temp]</td>
<td> $rs[Pulse]</td>
<td> $rs[BP]/$rs[BP2]</td>
";
}
?>
</tr>
</thead>
</tbody>
</table>
<br>
<br>
<h2 align="center">Diagnosis</h2>
<?php
session_start();
require_once('../LoginManager.php');
require_once('../DBManager.php');
$sql ="SELECT * FROM addaspatient WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
if($rs = mysqli_fetch_array($qsql))
{
if(General==$rs[casetype])
{
?>
<?php
$sql ="SELECT * FROM opdslip WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo" <table id='example2' class='table table-bordered table-hover'>
<tr><td>Admission diagnosis</td><td>$rs[Admission_diagnosis]</td></tr>
";
}
?>
</table>
<?php
}
}
?>
<?php
session_start();
$sql ="SELECT * FROM potential WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$DisplayForm=True;
$sql1 ="SELECT * FROM potential WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND operative_date='$rs[operative_date]'";
$qsql1 = mysqli_query($con,$sql1);
while($rh1 = mysqli_fetch_array($qsql1))
{
$DisplayForm=False;
echo "";
}
if($DisplayForm)
{
echo "";
} else{
?>
<?php
$sql ="SELECT * FROM potential WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo" <table id='example2' class='table table-bordered table-hover'>
<tr><td>Operative procedure date</td><td>$rs[operative_date]</td></tr>
</table> ";
}
?>
<?php
}
}
?>
<?php
session_start();
require_once('../LoginManager.php');
require_once('../DBManager.php');
$sql ="SELECT * FROM addaspatient WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
if($rs = mysqli_fetch_array($qsql))
{
if(Pregnancy==$rs[casetype])
{
?>
<?php
$sql ="SELECT * FROM opdslip WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo" <table id='example2' class='table table-bordered table-hover'>
<tr><td>Admission diagnosis</td><td>$rs[Admission_diagnosis]</td></tr>
<tr><td>Operative procedure date</td><td>$rs[procedure_date]</td></tr>
";
}
?>
</table>
<?php
}
}
?>
<?php
session_start();
require_once('../LoginManager.php');
require_once('../DBManager.php');
$sql ="SELECT * FROM addaspatient WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
if($rs = mysqli_fetch_array($qsql))
{
if(Eye_Care==$rs[casetype])
{
?>
<table id="example2" class="table table-bordered table-hover">
<tr><th>Admission diagnosis</th>
<th>Note</th>
<th>Eye</th>
</tr>
<tr>
<?php
$sql ="SELECT * FROM opdslip WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo " <tbody>
<td> $rs[Admission_diagnosis]</td>
<td> $rs[note] </td>
<td> $rs[eyetype] </td>
";
}
?>
<?php
}
}
?>
</table>
<br><br>
<h2 align="center">Investigation</h2>
<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 (Upload)</strong></th>
</tr>
</thead>
<?php
$sql ="SELECT * FROM investigation WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo " <tbody>
<tr> <td> $rs[created_at]</td>
<td> $rs[Investigation]</td>
<td> $rs[Result]</td>
<td> $rs[Evidence]</td>
</tr>
";
}
?>
</tbody>
</table>
<br><br>
<h2>Rx</h2>
<table id="example2" class="table table-bordered table-hover">
<thead>
<tr>
<div class='card-header d-flex p-0'>
<ul class='nav nav-pills ml-auto p-2'>
<th><strong>Drug & Dose </strong></th>
<th><strong> Route</strong></th>
<th><strong>Frequency </strong></th>
<th><strong>Duration</strong></th>
</tr>
</thead>
<?php
$sql ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND poa='Opd_Medicine' AND prescriptionid='$_GET[prescriptionid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo" <tr>";
echo "<td>
";
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]-$rs[Dose]";
}
else
{
echo"$rs[DRUGS]-$rs[Dose]";
}
echo" <br><td>$rs[Route]</td> ";
echo" <td>";
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 "";
}
echo"</td>";
echo" <td>$rs[duration] ";
switch ($rs[durationselect]) {
case '1':
echo "Days";
break;
case '7':
echo "Week";
break;
case '28':
echo "Month";
break;
default:
echo "";
}
echo"
</td>
</tr>
";
}
?>
</thead>
</tbody>
<tfoot>
</tfoot>
</table>
<br>
<table id="example2" class="table table-bordered table-hover">
<?php
$sql ="SELECT * FROM potential WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'";
$qsql = mysqli_query($con,$sql);
while($rsp = mysqli_fetch_array($qsql))
{
echo " <tbody>
<tr> <td>Potential side effect</td>
<td>$rsp[Potential_Side_Effects]</td>
</tr><tr>
<td>Alternative Mode of Treatment</td>
<td>$rsp[Mode_Treatment]</td>
</tr>
<tr>
<td>Available Treatment Facility Options</td>
<td>$rsp[treatment_Facility]</td>
</tr>
<tr>
<td>Options for Second Opinious</td>
<td>$rsp[Second_Opinious]</td>
</tr>
<tr>
<td>Referral to Higher Center for Better Care</td>
<td>$rsp[Referral_Higher_Center]</td>
</tr>
";
}
?> </tr>
</thead>
</tbody>
<tfoot>
</tfoot>
</table>
<table id='example2' class='table table-bordered table-hover'>
<?php
$sql ="SELECT * FROM request_for_admission WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
$sqldoctor= "SELECT * FROM site_users WHERE userno='$rs[Admitted_Under]'";
$qsqldoctor = mysqli_query($con,$sqldoctor);
while($rsdoctor = mysqli_fetch_array($qsqldoctor))
{
echo"
<tr><td>Admitted Under</td><td>$rsdoctor[name]</td></tr>
";
}
}
?>
<?php
$sql ="SELECT * FROM request_for_admission WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo"
<tr><td>Attending Nurse</td><td>$rs[Attending_Nurse]</td></tr>
";
}
?>
</table>
</form>
</div>
<head>
<style>
h2 {
color: #4287f5;
}
a img {
border: none;
}
#memo {
padding-top: 50px;
margin: 0 20px 0 60px;
border-bottom: 1px solid #ddd;
height: 150px;
}
#memo .logo {
float: left;
margin-right: 20px;
}
#memo .logo img {
width: 150px;
height: 100px;
}
#memo .company-info {
float: right;
text-align: right;
}
#memo .company-info > div:first-child {
font-weight: bold;
font-size: 22px;
color: #1e73be;
}
#memo .company-info span {
font-size: 11px;
min-width: 20px;
}
</style>
<script>$(function () {
$("#example1").DataTable({
"responsive": true,
"autoWidth": false,
});
$('#example2').DataTable({
"paging": true,
"lengthChange": false,
"searching": false,
"ordering": true,
"info": true,
"autoWidth": false,
"responsive": true,
});
});</script>
</div>