| Server IP : 162.240.98.243 / Your IP : 3.135.249.220 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("header.php");
?>
<?php
session_start();
include("dbconnection.php");
require_once('../DBManager.php');
require_once("../LoginManager.php");
require_once('../patientmanager.php');
if(isset($_POST[opdmedicine]))
{
PatientManager::Medicine("$_GET[prescriptionid]","$_GET[patientid]","$_POST[DRUGS]","$_POST[Dose]","$_POST[Route]","$_POST[Frequency]","$_POST[duration]","$_POST[potential]","$_POST[poa]","$_POST[status]","$_POST[Action]","$_POST[availability]","$_POST[batchno]","$_POST[st0]","$_POST[st1]","$_POST[st2]","$_POST[st3]","$_POST[st4]","$_POST[st5]","$_POST[drid]","$_POST[treatmentid]","$_POST[entered_by]");
}
elseif(isset($_POST[status]))
{
PatientManager::medimgnt("$_GET[prescriptionid]","$_GET[patientid]","$_POST[medicine_id]","$_POST[DRUGS]","$_POST[timeslot]","$_POST[admissiondate]","$_POST[status]","$_POST[entered_by]");
}
if(isset($_POST[statusmedicineva]))
{
$sql ="UPDATE medicinede SET status='$_POST[status]' WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND id='$_GET[id]'";
if($qsql = mysqli_query($con,$sql))
{
echo "<script>
window.history.go(-1)</script>";
}
}
?>
<?php
include("dbconnection.php");
if(isset($_GET[delid]))
{
$sql ="DELETE FROM medicinede WHERE id='$_GET[delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully..');</script>";
}
}
?>
<?php
include("dbconnection.php");
if(isset($_GET[delid]))
{
$sql12911 ="DELETE FROM medication_mng WHERE id='$_GET[delid]'";
$qsql12911=mysqli_query($con,$sql12911);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Un-done successfully..');</script>";
}
}
?>
<?php session_start();
require_once("../patientmanager.php");
require_once("../DBManager.php");
?>
<title>Title of the document</title>
<style>
#loaderImg {
position: absolute;
top: 0;
bottom: 0;
left: 0;
right: 0;
margin: auto;
border: 10px solid grey;
border-radius: 50%;
border-top: 10px solid black;
width: 100px;
height: 100px;
animation: spin 1s linear infinite;
}
@keyframes spin {
0% {
-webkit-transform: rotate(0deg);
transform: rotate(0deg);
}
100% {
-webkit-transform: rotate(360deg);
transform: rotate(360deg);
}
}
</style>
<style>
.modal {
display: none;
position: fixed;
z-index: 8;
left: 0;
top: 0;
width: 100%;
height: 100%;
overflow: auto;
background-color: rgb(0, 0, 0);
background-color: rgba(0, 0, 0, 0.4);
}
.modal-content {
margin: 50px auto;
border: 1px solid #999;
width: 60%;
}
h2,p {
margin: 0 0 20px;
font-weight: 400;
}
.form1 {
padding: 25px;
margin: 25px;
box-shadow: 0 2px 5px #f5f5f5;
background: #eee;
}
input,
textarea, select {
width: 100%;
padding: 6px;
margin-bottom: 20px;
border: 1px solid #1c87c9;
outline: none;
}
.contact-form button {
width: 100%;
padding: 10px;
border: none;
background: #1c87c9;
font-size: 16px;
font-weight: 400;
color: #fff;
}
button:hover {
background: #2371a0;
}
.close {
color: #aaa;
float: right;
font-size: 58px;
font-weight: bold;
}
.close:hover,
.close:focus {
color: black;
text-decoration: none;
cursor: pointer;
}
button.button {
display: inline-block;
border-bottom: #02274a 1px solid;
font-size: 19px;
cursor: pointer;
}
button.button:hover {
border-bottom: #a99567 1px solid;
color: #a99567;
}
</style>
<script src="https://code.jquery.com/jquery-1.12.4.js"></script>
<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$('#myForm').submit(function() {
$('#loaderImg').show();
return true;
});
});
</script>
<script>
$( function() {
$.widget( "custom.combobox", {
_create: function() {
this.wrapper = $( "<span>" )
.addClass( "custom-combobox" )
.insertAfter( this.element );
this.element.hide();
this._createAutocomplete();
this._createShowAllButton();
},
_createAutocomplete: function() {
var selected = this.element.children( ":selected" ),
value = selected.val() ? selected.text() : "";
this.input = $( "<input>" )
.appendTo( this.wrapper )
.val( value )
.attr( "title", "" )
.addClass( "custom-combobox-input ui-widget ui-widget-content ui-state-default ui-corner-left" )
.autocomplete({
delay: 0,
minLength: 0,
source: $.proxy( this, "_source" )
})
.tooltip({
classes: {
"ui-tooltip": "ui-state-highlight"
}
});
this._on( this.input, {
autocompleteselect: function( event, ui ) {
ui.item.option.selected = true;
this._trigger( "select", event, {
item: ui.item.option
});
},
autocompletechange: "_removeIfInvalid"
});
},
_createShowAllButton: function() {
var input = this.input,
wasOpen = false;
$( "<a>" )
.attr( "tabIndex", -1 )
.attr( "title", "Show All Items" )
.tooltip()
.appendTo( this.wrapper )
.button({
icons: {
primary: "ui-icon-triangle-1-s"
},
text: false
})
.removeClass( "ui-corner-all" )
.addClass( "custom-combobox-toggle ui-corner-right" )
.on( "mousedown", function() {
wasOpen = input.autocomplete( "widget" ).is( ":visible" );
})
.on( "click", function() {
input.trigger( "focus" );
// Close if already visible
if ( wasOpen ) {
return;
}
// Pass empty string as value to search for, displaying all results
input.autocomplete( "search", "" );
});
},
_source: function( request, response ) {
var matcher = new RegExp( $.ui.autocomplete.escapeRegex(request.term), "i" );
response( this.element.children( "option" ).map(function() {
var text = $( this ).text();
if ( this.value && ( !request.term || matcher.test(text) ) )
return {
label: text,
value: text,
option: this
};
}) );
},
_removeIfInvalid: function( event, ui ) {
// Selected an item, nothing to do
if ( ui.item ) {
return;
}
// Search for a match (case-insensitive)
var value = this.input.val(),
valueLowerCase = value.toLowerCase(),
valid = false;
this.element.children( "option" ).each(function() {
if ( $( this ).text().toLowerCase() === valueLowerCase ) {
this.selected = valid = true;
return false;
}
});
// Found a match, nothing to do
if ( valid ) {
return;
}
// Remove invalid value
this.input
.val( "" )
.attr( "title", value + " didn't match any item" )
.tooltip( "open" );
this.element.val( "" );
this._delay(function() {
this.input.tooltip( "close" ).attr( "title", "" );
}, 2500 );
this.input.autocomplete( "instance" ).term = "";
},
_destroy: function() {
this.wrapper.remove();
this.element.show();
}
});
$( "#combobox" ).combobox();
$( "#toggle" ).on( "click", function() {
$( "#combobox" ).toggle();
});
} );
</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</th>
<th>Towards</th>
<th>Action</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='$today'";
$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);
if($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 '1':
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>";
// echo "$rs123[timeslot]";
echo "
</td>
<td><a href='testmedifinal.php?prescriptionid=$rs123[prescriptionid]&patientid=$rs123[patientid]&delid=$rs123[id]'><i class='fa fa-undo' style='font-size:20px;'></i></a></td>
</tr> ";
}
}
}
?>
<tr > <td colspan='4'><a href='show_testmedifinal.php?prescriptionid=<?php echo $_GET['prescriptionid'] ?>&patientid=<?php echo $_GET['patientid'] ?>' style='float:right;margin:12px;'><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 448 512"><!--!Font Awesome Free 6.5.1 by @fontawesome - https://fontawesome.com License - https://fontawesome.com/license/free Copyright 2024 Fonticons, Inc.--><path d="M0 96C0 43 43 0 96 0H384h32c17.7 0 32 14.3 32 32V352c0 17.7-14.3 32-32 32v64c17.7 0 32 14.3 32 32s-14.3 32-32 32H384 96c-53 0-96-43-96-96V96zM64 416c0 17.7 14.3 32 32 32H352V384H96c-17.7 0-32 14.3-32 32zM208 112v48H160c-8.8 0-16 7.2-16 16v32c0 8.8 7.2 16 16 16h48v48c0 8.8 7.2 16 16 16h32c8.8 0 16-7.2 16-16V224h48c8.8 0 16-7.2 16-16V176c0-8.8-7.2-16-16-16H272V112c0-8.8-7.2-16-16-16H224c-8.8 0-16 7.2-16 16z" /></svg> view</a></td></tr>
</table>
</div>
<br><br>
<div class='center'>
<label>Select Slot </label>
<select type="search" class="light-table-filter" data-table="order-table" name="Education" class="form-control">
<option value="" disabled selected> Select Slot</option>
<?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='00:00-01:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='00:00-01:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='00:00-01:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='00:00-01:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='00:00-01:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='00:00-01:00'>00:00-01:00</option>";
}
?>
<?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='01:00-02:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='01:00-02:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='01:00-02:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='01:00-02:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='01:00-02:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='01:00-02:00'>01:00-02:00</option>";
}
?>
<?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='02:00-03:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='02:00-03:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='02:00-03:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='02:00-03:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='02:00-03:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='02:00-03:00'>02:00-03:00</option>";
}
?>
<?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='03:00-04:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='03:00-04:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='03:00-04:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='03:00-04:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='03:00-04:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='03:00-04:00'>03:00-04:00</option>";
}
?>
<?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='04:00-05:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='04:00-05:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='04:00-05:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='04:00-05:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='04:00-05:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='04:00-05:00'>04:00-05:00</option>";
}
?><?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='05:00-06:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='05:00-06:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='05:00-06:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='05:00-06:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='05:00-06:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='05:00-06:00'>05:00-06:00</option>";
}
?>
<?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='06:00-07:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='06:00-07:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='06:00-07:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='06:00-07:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='06:00-07:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='06:00-07:00'>06:00-07:00</option>";
}
?><?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='07:00-08:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='07:00-08:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='07:00-08:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='07:00-08:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='07:00-08:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='07:00-08:00'>07:00-08:00</option>";
}
?>
<?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='08:00-09:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='08:00-09:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='08:00-09:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='08:00-09:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='08:00-09:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='08:00-09:00'>08:00-09:00</option>";
}
?>
<?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='09:00-10:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='09:00-10:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='09:00-10:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='09:00-10:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='09:00-10:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='09:00-10:00'>09:00-10:00</option>";
}
?>
<?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='10:00-11:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='10:00-11:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='10:00-11:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='10:00-11:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='10:00-11:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='10:00-11:00'>10:00-11:00</option>";
}
?>
<?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='11:00-12:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='11:00-12:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='11:00-12:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='11:00-12:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='11:00-12:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='11:00-12:00'>11:00-12:00</option>";
}
?>
<?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='12:00-13:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='12:00-13:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='12:00-13:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='12:00-13:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='12:00-13:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='12:00-13:00'>12:00-13:00</option>";
}
?>
<?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='13:00-14:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='13:00-14:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='13:00-14:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='13:00-14:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='13:00-14:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='13:00-14:00'>13:00-14:00</option>";
}
?>
<?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='14:00-15:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='14:00-15:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='14:00-15:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='14:00-15:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='14:00-15:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='14:00-15:00'>14:00-15:00</option>";
}
?>
<?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='15:00-16:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='15:00-16:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='15:00-16:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='15:00-16:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='15:00-16:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='15:00-16:00'>15:00-16:00</option>";
}
?>
<?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='16:00-17:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='16:00-17:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='16:00-17:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='16:00-17:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='16:00-17:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='16:00-17:00'>16:00-17:00</option>";
}
?>
<?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='17:00-18:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='17:00-18:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='17:00-18:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='17:00-18:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='17:00-18:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='17:00-18:00'>17:00-18:00</option>";
}
?>
<?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='18:00-19:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='18:00-19:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='18:00-19:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='18:00-19:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='18:00-19:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='18:00-19:00'>18:00-19:00</option>";
}
?>
<?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='19:00-20:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='19:00-20:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='19:00-20:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='19:00-20:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='19:00-20:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='19:00-20:00'>19:00-20:00</option>";
}
?>
<?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='19:00-20:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='20:00-21:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='20:00-21:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='20:00-21:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='20:00-21:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='20:00-21:00'>20:00-21:00</option>";
}
?>
<?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='21:00-22:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='21:00-22:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='21:00-22:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='21:00-22:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='21:00-22:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='21:00-22:00'>21:00-22:00</option>";
}
?>
<?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='22:00-23:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='22:00-23:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='22:00-23:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='22:00-23:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='22:00-23:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='22:00-23:00'>22:00-23:00</option>";
}
?>
<?php
include("dbconnection.php");
$sql100 ="SELECT * FROM medicinede WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st0='23:00-00:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st1='23:00-00:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st2='23:00-00:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st3='23:00-00:00' OR patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND status='Active' AND st4='23:00-00:00'";
$qsql100 = mysqli_query($con,$sql100);
if($rs100 = mysqli_fetch_array($qsql100))
{
echo"<option value='23:00-00:00'>23:00-00:00</option>";
}
?>
</select>
<div id='divmb'></div>
<table id="example2" id ="demo" class="order-table 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");
$today = date('Y/m/d');
$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]!='')
{
$DisplayForm=True;
$sql7 ="SELECT * FROM medication_mng WHERE prescriptionid='$_GET[prescriptionid]' AND timeslot='$rs[st0]' AND medicine_id='$rs[id]' AND admissiondate='$today'";
$qsql7 = mysqli_query($con,$sql7);
if($rs7 = mysqli_fetch_array($qsql7))
{
$DisplayForm=False;
echo "";
}
if($DisplayForm)
{
echo"<tr><td></td><td>$rs[st0]</td>";
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 '1':
echo "QWK (every week)";
break;
default:
echo "";
} echo"";
echo"<br> Note: $rs[potential]</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[st0]'><input type='hidden' name='DRUGS' value='$rs[DRUGS]'>
<button style='height:auto;width:100%; padding:10px' value='Disperse' name='status' type='submit'> Disperse</button>
<button style='height:auto;width:100%;padding:10px' value='Ignore' name='status' type='submit'> Ignore</button>
</form>
<a href='testmedifinal.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&delid=$rs[id]' class='btn btn-primary' style='margin:10px 10px;color:#000000;'>Remove</a>
</li><li>
<a href='ordercreate.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&id=$rs[id]' data-modal='modalOne' class='btn btn-success' style='margin:10px;color:#000000;'>Create Order</a>
</li>
</ul>
</div>
</td>
</tr>
";
}
}
if($rs[st1]!='')
{
$DisplayForm=True;
$sql7 ="SELECT * FROM medication_mng WHERE prescriptionid='$_GET[prescriptionid]' AND timeslot='$rs[st1]' AND medicine_id='$rs[id]' AND admissiondate='$today'";
$qsql7 = mysqli_query($con,$sql7);
if($rs7 = mysqli_fetch_array($qsql7))
{
$DisplayForm=False;
echo "";
}
if($DisplayForm)
{
echo"<tr><td></td><td>$rs[st1]</td>";
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 '1':
echo "QWK (every week)";
break;
default:
echo "";
} echo"";
echo"<br> Note: $rs[potential]</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[st1]'><input type='hidden' name='DRUGS' value='$rs[DRUGS]'>
<button style='height:auto;width:100%; padding:10px' value='Disperse' name='status' type='submit'> Disperse</button>
<button style='height:auto;width:100%;padding:10px' value='Ignore' name='status' type='submit'> Ignore</button>
</form>
<a href='testmedifinal.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&delid=$rs[id]' class='btn btn-primary' style='margin:10px 10px;color:#000000;'>Remove</a>
</li><li>
<a href='ordercreate.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&id=$rs[id]' data-modal='modalOne' class='btn btn-success' style='margin:10px;color:#000000;'>Create Order</a>
</li>
</ul>
</div>
</td>
</tr>
";
}
}
if($rs[st2]!='')
{
$DisplayForm=True;
$sql7 ="SELECT * FROM medication_mng WHERE prescriptionid='$_GET[prescriptionid]' AND timeslot='$rs[st2]' AND medicine_id='$rs[id]' AND admissiondate='$today'";
$qsql7 = mysqli_query($con,$sql7);
if($rs7 = mysqli_fetch_array($qsql7))
{
$DisplayForm=False;
echo "";
}
if($DisplayForm)
{
echo"<tr><td></td><td>$rs[st2]</td>";
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 '1':
echo "QWK (every week)";
break;
default:
echo "";
} echo"";
echo"<br> Note: $rs[potential]</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[st2]'><input type='hidden' name='DRUGS' value='$rs[DRUGS]'>
<button style='height:auto;width:100%; padding:10px' value='Disperse' name='status' type='submit'> Disperse</button>
<button style='height:auto;width:100%;padding:10px' value='Ignore' name='status' type='submit'> Ignore</button>
</form>
<a href='testmedifinal.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&delid=$rs[id]' class='btn btn-primary' style='margin:10px 10px;color:#000000;'>Remove</a>
</li><li>
<a href='ordercreate.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&id=$rs[id]' data-modal='modalOne' class='btn btn-success' style='margin:10px;color:#000000;'>Create Order</a>
</li>
</ul>
</div>
</td>
</tr>
";
}
}
if($rs[st3]!='')
{
$DisplayForm=True;
$sql7 ="SELECT * FROM medication_mng WHERE prescriptionid='$_GET[prescriptionid]' AND timeslot='$rs[st3]' AND medicine_id='$rs[id]' AND admissiondate='$today'";
$qsql7 = mysqli_query($con,$sql7);
if($rs7 = mysqli_fetch_array($qsql7))
{
$DisplayForm=False;
echo "";
}
if($DisplayForm)
{
echo"<tr><td></td><td>$rs[st3]</td>";
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 '1':
echo "QWK (every week)";
break;
default:
echo "";
} echo"";
echo"<br> Note: $rs[potential]</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[st3]'><input type='hidden' name='DRUGS' value='$rs[DRUGS]'>
<button style='height:auto;width:100%; padding:10px' value='Disperse' name='status' type='submit'> Disperse</button>
<button style='height:auto;width:100%;padding:10px' value='Ignore' name='status' type='submit'> Ignore</button>
</form>
<a href='testmedifinal.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&delid=$rs[id]' class='btn btn-primary' style='margin:10px 10px;color:#000000;'>Remove</a>
</li><li>
<a href='ordercreate.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&id=$rs[id]' data-modal='modalOne' class='btn btn-success' style='margin:10px;color:#000000;'>Create Order</a>
</li>
</ul>
</div>
</td>
</tr>
";
}
}
if($rs[st4]!='')
{
$DisplayForm=True;
$sql7 ="SELECT * FROM medication_mng WHERE prescriptionid='$_GET[prescriptionid]' AND timeslot='$rs[st4]' AND medicine_id='$rs[id]' AND admissiondate='$today'";
$qsql7 = mysqli_query($con,$sql7);
if($rs7 = mysqli_fetch_array($qsql7))
{
$DisplayForm=False;
echo "";
}
if($DisplayForm)
{
echo"<tr><td></td><td>$rs[st4]</td>";
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 '1':
echo "QWK (every week)";
break;
default:
echo "";
} echo"";
echo"<br> Note: $rs[potential]</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[st4]'><input type='hidden' name='DRUGS' value='$rs[DRUGS]'>
<button style='height:auto;width:100%; padding:10px' value='Disperse' name='status' type='submit'> Disperse</button>
<button style='height:auto;width:100%;padding:10px' value='Ignore' name='status' type='submit'> Ignore</button>
</form>
<a href='testmedifinal.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&delid=$rs[id]' class='btn btn-primary' style='margin:10px 10px;color:#000000;'>Remove</a>
</li><li>
<a href='ordercreate.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&id=$rs[id]' data-modal='modalOne' class='btn btn-success' style='margin:10px;color:#000000;'>Create Order</a>
</li>
</ul>
</div>
</td>
</tr>
";
}
}
if($rs[st5]!='')
{
$DisplayForm=True;
$sql7 ="SELECT * FROM medication_mng WHERE prescriptionid='$_GET[prescriptionid]' AND timeslot='$rs[st5]' AND medicine_id='$rs[id]' AND admissiondate='$today'";
$qsql7 = mysqli_query($con,$sql7);
if($rs7 = mysqli_fetch_array($qsql7))
{
$DisplayForm=False;
echo "";
}
if($DisplayForm)
{
echo"
<tr><td></td><td>$rs[st5]</td>";
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 '1':
echo "QWK (every week)";
break;
default:
echo "";
} echo"";
echo"<br> Note: $rs[potential]</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[st5]'><input type='hidden' name='DRUGS' value='$rs[DRUGS]'>
<button style='height:auto;width:100%; padding:10px' value='Disperse' name='status' type='submit'> Disperse</button>
<button style='height:auto;width:100%;padding:10px' value='Ignore' name='status' type='submit'> Ignore</button>
</form>
<a href='testmedifinal.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&delid=$rs[id]' class='btn btn-primary' style='margin:10px 10px;color:#000000;'>Remove</a>
</li><li>
<a href='ordercreate.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&id=$rs[id]' data-modal='modalOne' class='btn btn-success' style='margin:10px;color:#000000;'>Create Order</a>
</li>
</ul>
</div>
</td>
</tr>
";
}
}
}
?>
</table>
<p align="right">
<button class="button" data-modal="modalOne"> Add Medication</button>
</p>
<div id="modalOne" class="modal">
<div class="modal-content">
<div class="contact-form">
<a class="close">×</a>
<div style = "display:none;" id = "loaderImg"> <div class="loader"> </div> </div>
<form name="opdmedicine" method="post" id="myForm">
<label>Drug Name</label> <input onkeyup="this.value = this.value.toUpperCase();" onchange="drmdiload(this.value)" name='DRUGS' type='text' list='DRUGS' />
<datalist name='DRUGS' id='DRUGS'>
<?php
include("dbconnection.php");
require_once('../DBManager.php');
require_once('../LoginManager.php');
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
$sql1 ="SELECT * FROM site_users WHERE userno='$usertype'";
$qsql1 = mysqli_query($con,$sql1);
if($re = mysqli_fetch_array($qsql1))
{
$sql ="SELECT * FROM medicine_stok WHERE admin_id='$re[entered_by]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo "
<option value>Select one...</option>
<option value='$rs[medicine_id]'>$rs[DRUGS_name]-$rs[Dose]</option>
";
}
}
?>
</datalist>
<div id='divmedidr'>
<label>Dose</label>
<input type="text" placeholder="In mg" name="Dose" id="dose" class="form-control" />
<label>Cotegory</label>
<select onchange="cotegory(this.value)" class="form-control" name="Category" id="Category">
<option value="" disabled selected>Category </option>
<option value="Injectable">Injectable </option>
<option value="IV Fluid">IV Fluid </option>
<option value="Capsule">Capsule </option>
<option value="Tablet">Tablet </option>
<option value="Syrup">Syrup </option>
<option value="Powder">Powder </option>
<option value="Ointment">Ointment</option>
<option value="Drop">Drop</option>
<option value="Solution">Solution</option>
<option value="Patch">Patch</option>
</select>
</div>
<label>Route</label>
<select class="form-control" name="Route" id="Route" name="Route">
<option value="" disabled selected>Route </option>
<option value="Orally">Orally</option>
<option value="IV/IM">IV/IM</option>
<option value="Sublingually/ Buccally">Sublingually/ Buccally</option>
<option value="Vaginally">Vaginally</option>
<option value="Ocular/ Otic"> Ocular/ Otic </option>
<option value="Nasally">Nasally</option>
<option value="Inhalation/Nebulization">Inhalation/Nebulization</option>
<option value="cutaneously/systemic">cutaneously/systemic</option>
<option value="transdermally">transdermally</option>
<option value="Rectal">Rectal</option>
</select>
<label> Frequency</label>
<select class="form-control" onchange="frequency(this.value)" name="Frequency" id="Frequency" class="form-control">
<option value="" disabled selected>Frequency </option>
<option value="01">OD (Once Daily)</option>
<option value="2">BID/b.i.d. (twice a day)</option>
<option value="3">TID/t.id. (three times a day)</option>
<option value="04">QID/q.i.d. (four times a day)</option>
<option value="1"> QHS (every bedtime) </option>
<option value="6">Q4h (every 4 hours)</option>
<option value="4">Q4-6h (every 4 to 6 hours)</option>
<option value="1">QWK (every week)</option>
</select>
<div id='frequency'></div>
<div>
<label>Duration</label>
<input type="number" placeholder='In Days' name="duration">
</div>
<label>Note</label>
<input type="text" placeholder="Instruction, Potential side effects, Food Intake" name="potential">
<input type="hidden" name="status" value="Active">
<input type="hidden" name="poa" value="ipd_Medicine" >
<input type="submit" value="Add" name="opdmedicine">
</form>
</div> </div> </div>
<table id="example2" id ="demo" class="table table-bordered table-hover">
<?php
$sql ="SELECT * FROM addaspatient WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql = mysqli_query($con,$sql);
if($rs = mysqli_fetch_array($qsql))
{
echo " <tbody>
";
}
?>
</tbody>
</table>
<script>
let modalBtns = [...document.querySelectorAll(".button")];
modalBtns.forEach(function(btn) {
btn.onclick = function() {
let modal = btn.getAttribute('data-modal');
document.getElementById(modal)
.style.display = "block";
}
});
let closeBtns = [...document.querySelectorAll(".close")];
closeBtns.forEach(function(btn) {
btn.onclick = function() {
let modal = btn.closest('.modal');
modal.style.display = "none";
}
});
window.onclick = function(event) {
if(event.target.className === "modal") {
event.target.style.display = "none";
}
}
</script>
<script>
function drmdiload(drmeid)
{
if (window.XMLHttpRequest) {
// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp = new XMLHttpRequest();
} else {
// code for IE6, IE5
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange = function() {
if (this.readyState == 4 && this.status == 200) {
document.getElementById("divmedidr").innerHTML = this.responseText;
}
};
xmlhttp.open("GET","loaddrug.php?drmeid="+drmeid,true);
xmlhttp.send();
}
function frequency(frid)
{
if (window.XMLHttpRequest) {
// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp = new XMLHttpRequest();
} else {
// code for IE6, IE5
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange = function() {
if (this.readyState == 4 && this.status == 200) {
document.getElementById("frequency").innerHTML = this.responseText;
}
};
xmlhttp.open("GET","loadfrequency.php?frid="+frid,true);
xmlhttp.send();
}
</script>
</body>
</html>
<script>
function mobile(mbid)
{
if (window.XMLHttpRequest) {
// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp = new XMLHttpRequest();
} else {
// code for IE6, IE5
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange = function() {
if (this.readyState == 4 && this.status == 200) {
document.getElementById("divmb").innerHTML = this.responseText;
}
};
xmlhttp.open("GET","loadtimeslot.php?mbid="+mbid,true);
xmlhttp.send();
}
</script>