| Server IP : 162.240.98.243 / Your IP : 18.223.206.225 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("../LoginManager.php");
require_once("../DBManager.php");
include("dashboarddocument.php");
include("opdtest2322.php");
?>
<?php session_start();
require_once("../patientmanager.php");
require_once("../DBManager.php");
if(isset($_POST[status]))
{
PatientManager::medimgnt("$_GET[prescriptionid]","$_GET[patientid]","$_POST[medicine_id]","$_POST[timeslot]","$_POST[admissiondate]","$_POST[status]","$_POST[entered_by]");
}
?>
<?php
include("dbconnection.php");
if(isset($_GET[delid]))
{
$sql ="DELETE FROM Dressing WHERE id='$_GET[delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully..');</script>";
}
}
?>
<style>
.center {
border: 1px solid grey;
text-align:;
}
</style>
<style>
.p{
color: black;
font-weight: 900;
}
/* Automatic Serial Number Row */
.css-serial {
font-weight: 900;
color: black;
counter-reset: serial-number; /* Set the serial number counter to 0 */
}
.css-serial td:first-child:before {
counter-increment: serial-number; /* Increment the serial number counter */
content: counter(serial-number); /* Display the counter */
}
</style>
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<h3 align='center'>Medication Management </h3>
<div class='center'>
<table id="example2" id ="demo" class="table table-bordered table-hover">
<tr>
<th>Medication Details</th>
<th>Administered By & At</th>
<th>Towards</th>
<th>Action</th>
</tr>
<?php
include("dbconnection.php");
$sql ="SELECT * FROM medication_mng WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'";
$qsql = mysqli_query($con,$sql);
while($rs123 = mysqli_fetch_array($qsql))
{
$sql ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
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>$rsdoctor[name]</td>";
}
echo"<td>$rs123[status]</td>";
}
}
}
?>
</table>
</div>
<br><br>
<div class='center'>
<table id="example2" id ="demo" class="table table-bordered table-hover css-serial">
<tr>
<th>Sr. No</th>
<th>Time Slot</th>
<th>Medication Details</th>
<th>Action</th>
</tr>
<?php
include("dbconnection.php");
$sql ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' ORDER BY id ASC";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
if($rs[st0]!='')
{
echo "</td>";
echo" <tr><td></td><td>$rs[st0]";
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 "";
} echo"";
echo"
</td>
<td>
<div class='btn-group'>
<button type='button' class='btn btn-default dropdown-toggle' data-toggle='dropdown' aria-haspopup='true' aria-expanded='false'>
Action <span class='caret'></span>
</button>
<ul class='dropdown-menu'>
<li><form name='status' method='post'>
<input type='hidden' name='medicine_id' value='$rs[id]'>
<input type='hidden' name='timeslot' value='09:00-10:00'>
<button style='height:30px;width:200px' value='Disperse' name='status' type='submit'> Disperse</button>
<button style='height:30px;width:200px' value='Ignore' name='status' type='submit'> Ignore</button>
<button style='height:30px;width:200px' value='Remove' name='status' type='submit'> Remove</button>
</form>
</ul>
</div>
</td>
</tr>
";
}
if($rs[st1]!='')
{
echo "</td>";
echo" <tr><td></td><td>$rs[st1]";
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 "";
} echo" ";
echo"
</td>
<td>
<div class='btn-group'>
<button type='button' class='btn btn-default dropdown-toggle' data-toggle='dropdown' aria-haspopup='true' aria-expanded='false'>
Action <span class='caret'></span>
</button>
<ul class='dropdown-menu'>
<li><form name='status' method='post'>
<input type='hidden' name='medicine_id' value='$rs[id]'>
<input type='hidden' name='timeslot' value='$rs[1]'>
<button style='height:30px;width:200px' value='Disperse' name='status' type='submit'> Disperse</button>
<button style='height:30px;width:200px' value='Ignore' name='status' type='submit'> Ignore</button>
<button style='height:30px;width:200px' value='Remove' name='status' type='submit'> Remove</button>
</form>
</ul>
</div>
</td>
</tr>
";
}
if($rs[st2]!='')
{
echo "</td>";
echo" <tr><td></td><td>$rs[st1]";
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 "";
} echo" ";
echo"
</td>
<td>
<div class='btn-group'>
<button type='button' class='btn btn-default dropdown-toggle' data-toggle='dropdown' aria-haspopup='true' aria-expanded='false'>
Action <span class='caret'></span>
</button>
<ul class='dropdown-menu'>
<li><form name='status' method='post'>
<input type='hidden' name='medicine_id' value='$rs[id]'>
<input type='hidden' name='timeslot' value='$rs[1]'>
<button style='height:30px;width:200px' value='Disperse' name='status' type='submit'> Disperse</button>
<button style='height:30px;width:200px' value='Ignore' name='status' type='submit'> Ignore</button>
<button style='height:30px;width:200px' value='Remove' name='status' type='submit'> Remove</button>
</form>
</ul>
</div>
</td>
</tr>
";
}
if($rs[st3]!='')
{
echo "</td>";
echo" <tr><td></td><td>$rs[st1]";
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 "";
} echo" ";
echo"
</td>
<td>
<div class='btn-group'>
<button type='button' class='btn btn-default dropdown-toggle' data-toggle='dropdown' aria-haspopup='true' aria-expanded='false'>
Action <span class='caret'></span>
</button>
<ul class='dropdown-menu'>
<li><form name='status' method='post'>
<input type='hidden' name='medicine_id' value='$rs[id]'>
<input type='hidden' name='timeslot' value='$rs[1]'>
<button style='height:30px;width:200px' value='Disperse' name='status' type='submit'> Disperse</button>
<button style='height:30px;width:200px' value='Ignore' name='status' type='submit'> Ignore</button>
<button style='height:30px;width:200px' value='Remove' name='status' type='submit'> Remove</button>
</form>
</ul>
</div>
</td>
</tr>
";
}
if($rs[st4]!='')
{
echo "</td>";
echo" <tr><td></td><td>$rs[st1]";
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 "";
} echo" ";
echo"
</td>
<td>
<div class='btn-group'>
<button type='button' class='btn btn-default dropdown-toggle' data-toggle='dropdown' aria-haspopup='true' aria-expanded='false'>
Action <span class='caret'></span>
</button>
<ul class='dropdown-menu'>
<li><form name='status' method='post'>
<input type='hidden' name='medicine_id' value='$rs[id]'>
<input type='hidden' name='timeslot' value='$rs[1]'>
<button style='height:30px;width:200px' value='Disperse' name='status' type='submit'> Disperse</button>
<button style='height:30px;width:200px' value='Ignore' name='status' type='submit'> Ignore</button>
<button style='height:30px;width:200px' value='Remove' name='status' type='submit'> Remove</button>
</form>
</ul>
</div>
</td>
</tr>
";
}
if($rs[st5]!='')
{
echo "</td>";
echo" <tr><td></td><td>$rs[st1]";
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 "";
} echo" ";
echo"
</td>
<td>
<div class='btn-group'>
<button type='button' class='btn btn-default dropdown-toggle' data-toggle='dropdown' aria-haspopup='true' aria-expanded='false'>
Action <span class='caret'></span>
</button>
<ul class='dropdown-menu'>
<li><form name='status' method='post'>
<input type='hidden' name='medicine_id' value='$rs[id]'>
<input type='hidden' name='timeslot' value='$rs[1]'>
<button style='height:30px;width:200px' value='Disperse' name='status' type='submit'> Disperse</button>
<button style='height:30px;width:200px' value='Ignore' name='status' type='submit'> Ignore</button>
<button style='height:30px;width:200px' value='Remove' name='status' type='submit'> Remove</button>
</form>
</ul>
</div>
</td>
</tr>
";
}
}
?>
</div>