| Server IP : 162.240.98.243 / Your IP : 18.221.224.144 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/www/login.easenup.in/Pharmacy/ |
Upload File : |
<?php
include("dbconnection.php");
require_once('../../DBManager.php');
require_once('../../patientmanager.php');
include("header.php");
include("dashboard_pharma.php");
if(isset($_POST['Action_med']))
{
$sql ="UPDATE consumable_slot SET action_consumable='$_POST[Action_med]',status='$_POST[status]',batchno='$_POST[batchno]' WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND Con_Slot_id='$_POST[id]'";
if($qsql = mysqli_query($con,$sql))
{
echo "<script>alert('Successfully Submit');</script>";
} else {
echo "Sorry, there was an error uploading your file.";
}
}
?>
<?php
include("dbconnection.php");
require_once('../../DBManager.php');
require_once('../../patientmanager.php');
include("header.php");
if(isset($_POST[opdmedicine]))
{
$updated_at=date("F d, Y / h:i:s A");
$created_at=date("F d, Y / h:i:s A");
$consumable_slot=$con->query("INSERT INTO `consumable_slot`( `prescriptionid`, `patientid`, `consumable_id`, `admin_id`, `slot_id`, `qtyGiven`, `UpdateQty`, `ReturnQty`, `POA`, `action_consumable`, `Dr_Id`, `entered_by`, `created_at`, `Updated_by`, `DisperseBy`) VALUES ('$_GET[prescriptionid]','$_GET[patientid]','$_POST[Consumable_id]','$_POST[Admin_id]','Null','$_POST[Quantity]','Null','Null','$_POST[poa]','process','$_POST[drid]','$_POST[Admin_id]','$created_at','$updated_at','Pharmacy')");
echo $consumable_slot;
if($consumable_slot==1){
echo "<script>alert('Consumable add successfully..');</script><script>window.location='Consumable_order.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]'</script>";
}
}
if(isset($_POST[action]))
{
$sql ="UPDATE consumable_slot SET action_consumable='$_POST[action]', qtyGiven='$_POST[quantitygiven]', UpdateQty='$_POST[SubQty]', batchno='$_POST[batchno]' WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND Con_Slot_id='$_POST[srno]'";
if($qCS = mysqli_query($con,$sql))
{
} else {
echo "Sorry, there was an error uploading your file.";
}
// PatientManager::medicineslotupdate("$_GET[prescriptionid]","$_GET[patientid]","$_GET[medicine_id]","$_POST[admin_id]","$_POST[quantitygiven]","$_POST[slot_id]","$_POST[price]","$_POST[pricetotal]","$_POST[action]","$_POST[batchno]","$_POST[entered_by]");
}
if(isset($_POST['action']))
{
$TotalQuantity="UPDATE consumable_inventory SET totalQty='$_POST[SubQty]' WHERE batchno='$_POST[batchno]'";
if($qTQ = mysqli_query($con,$TotalQuantity))
{
} else {
echo "Sorry, there was an error uploading your file.";
}
}
if(isset($_GET['id']))
{
$consumable_slot="UPDATE `consumable_slot` SET `status`='0',action_consumable='Refuse' WHERE `Con_Slot_id`='$_GET[id]' AND `prescriptionid`='$_GET[prescriptionid]' AND `patientid`='$_GET[patientid]'";
if($qMD = mysqli_query($con,$consumable_slot))
{
header("Location:Consumable_order.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]");
}
}
?>
<!DOCTYPE html>
<html> <head>
<script src="../js/jquery.min.js"></script>
<script type="text/javascript">
jQuery(document).ready(function($) {
// Find the toggles and hide their content
$('.toggle').each(function(){
$(this).find('.toggle-content').hide();
});
// When a toggle is clicked (activated) show their content
$('.toggle a.toggle-trigger').click(function(){
var el = $(this), parent = el.closest('.toggle');
if( el.hasClass('active') )
{
parent.find('.toggle-content').slideToggle();
el.removeClass('active');
}
else
{
parent.find('.toggle-content').slideToggle();
el.addClass('active');
}
return false;
});
}); //End
</script>
<!-- Toggle CSS -->
<style type="text/css">
/* Main toggle */
.toggle {
font-size: 13px;
line-height:20px;
font-family: "HelveticaNeue", "Helvetica Neue", Helvetica, Arial, sans-serif;
background: #ffffff; /* Main background */
margin-bottom: 10px;
border: 1px solid #e5e5e5;
-webkit-border-radius: 5px;
-moz-border-radius: 5px;
border-radius: 5px;
}
/* Toggle Link text */
.toggle a.toggle-trigger {
display:block;
padding: 10px 10px 10px 10px;
position:relative;
text-decoration: none;
color: #666;
}
/* Toggle Link hover state */
.toggle a.toggle-trigger:hover {
opacity: .8;
text-decoration: none;
}
/* Toggle link when clicked */
.toggle a.active {
text-decoration: none;
border-bottom: 1px solid #e5e5e5;
-webkit-box-shadow: 0 8px 6px -6px #ccc;
-moz-box-shadow: 0 8px 6px -6px #ccc;
box-shadow: 0 8px 6px -6px #ccc;
color: #000;
}
/* Lets add a "-" before the toggle link */
.toggle a.toggle-trigger:before {
content: "-"; /* You can add any symbol, font icon, or graphic icon */
margin-right: 3px;
font-size: 1.3em;
}
/* When the toggle is active, change the "-" to a "+" */
.toggle a.active.toggle-trigger:before {
content: "+";
}
/* The content of the toggle */
.toggle .toggle-content {
padding: 10px 10px 10px 10px;
color:#666;
}
.GFG {
background-color: white;
border: 1px solid black;
color: black;
padding: 5px 10px;
text-align: center;
display: inline-block;
font-size: 20px;
margin: 10px 10px 10px 10px;
cursor: pointer;
text-decoration:none;
}
</style>
<script>
function selection(){
var selected=document.getElementById("select1").value;
if(selected==0){
document.getElementById("input1").removeAttribute("text");
}else{
//elsewhere actions
}
}
</script>
<link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
<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>
$( 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>
</head>
<h3><i class="fa fa-angle-right"></i> Medication Order</h3>
<style>
form{
margin: 20px 0;
}
form input, button{
padding: 5px;
}
table{
width: 100%;
margin-bottom: 20px;
border-collapse: collapse;
}
table, th, td{
border: 1px solid #cdcdcd;
}
table th, table td{
padding: 10px;
text-align: left;
}
<style>
table{
border: solid 1px gray;
width: 100%;
}
</style>
</head>
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<div class="toggle">
<!-- Toggle Link -->
<a href="#" title="Title of Toggle" class="toggle-trigger">Consumable Order Timiline</a>
<!-- Toggle Content to display -->
<div class="toggle-content">
<p><?php include("Consumable_order_timline.php"); ?></p>
</div><!-- .toggle-content (end) -->
</div><!-- .toggle (end) -->
<!-- Toggle #2 -->
<input type="search" class="light-table-filter" data-table="order-table" placeholder="Search">
<div id="container">
<table border="1" class="order-table">
<tbody>
<tr>
<th>Date & Time </th>
<th>Consumable Details</th>
<th>Quantity</th>
<th style='width:25%;'>Action</th>
</tr>
</tbody>
<tr>
<?php
include("dbconnection.php");
require_once('../../DBManager.php');
require_once('../../LoginManager.php');
$narayan=LoginManager::currentUser();
$usertype=LoginManager::getUserTypeByuname("$narayan");
$sql1 ="SELECT * FROM consumable_slot WHERE prescriptionid='$_GET[prescriptionid]' AND action_consumable='process' AND status='1'";
$qsql1 = mysqli_query($con,$sql1);
while($re1 = mysqli_fetch_array($qsql1))
{
$sql3 =$con->query("SELECT * FROM consumable_inventory WHERE Consumable_id='$re1[consumable_id]'");
$re3=$sql3->fetch_assoc();
?>
<script>
function sum<?php echo $re3['inventory_id'] ?>() {
var txtFirstNumberValue = document.getElementById('txt1<?php echo $re3['inventory_id'] ?>').value;
var txtSecondNumberValue = document.getElementById('txt2<?php echo $re3['inventory_id'] ?>').value;
var result = parseInt(txtFirstNumberValue) - parseInt(txtSecondNumberValue);
if (!isNaN(result)) {
document.getElementById('txt3<?php echo $re3['inventory_id'] ?>').value = result;
}
}
$(document).ready(function () {
$("#chosen_a<?php echo $re3['inventory_id'] ?>").change(function () {
$('#txt1<?php echo $re3['inventory_id'] ?>').val($('#chosen_a<?php echo $re3['inventory_id'] ?> option:selected').data('id'));
});
$("#ValDisperse").click(function() {
var num1 = $("#txt1<?php echo $re3['inventory_id'] ?>").val();
var num2 = $("#txt2<?php echo $re3['inventory_id'] ?>").val();
var answer = parseInt(num1) - parseInt(num2);
//alert(answer);
$("#txt3<?php echo $re3['inventory_id'] ?>").val(answer);
});
});
$(document).ready(function(){
})
</script>
<?php
$sql2 ="SELECT * FROM site_users WHERE userno='$re1[entered_by]'";
$qsql2 = mysqli_query($con,$sql2);
while($re = mysqli_fetch_array($qsql2))
{
$sql3=$con->query("SELECT * FROM `consumable_stock` where Consumable_id='$re1[consumable_id]'");
while($rms=$sql3->fetch_assoc()){
if($rms['Category']==$rms['Category']){
$conqty=$re1['qtyGiven'];
}
}
echo "
<td><b>Created at:</b> $re1[created_at]
<br><b>Created By:</b>$re[name]
</td><td><b>Name :</b>";
if (is_numeric($re1[consumable_id]))
{
$sql ="SELECT * FROM consumable_stock WHERE Consumable_id='$re1[consumable_id]'";
$qsql = mysqli_query($con,$sql);
while($re2 = mysqli_fetch_array($qsql))
echo"$re2[ConsumableName] ($re2[Category])";
echo"";
}
else
{
echo"$re1[consumable_id]";
}
echo"
</td>
";
if($re1[status] == '1'){
$sql21="SELECT * FROM consumable_slot WHERE consumable_id='$re1[consumable_id]' AND prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$qsql21 = mysqli_query($con,$sql21);
while($rs21 = mysqli_fetch_array($qsql21))
$pavan=$rs21[Con_Slot_id];
echo " <form name='action' method='POST'><td>";
echo " <select name='batchno' id='chosen_a$re3[inventory_id]' required>
<option value='' disabled selected required>Batch No</option>";
$sql3 ="SELECT * FROM consumable_inventory WHERE Consumable_id='$re1[consumable_id]'";
$qsql3 = mysqli_query($con,$sql3);
while($batch = mysqli_fetch_array($qsql3))
{
echo"
<option value='$batch[batchno]' data-id='$batch[totalQty]'>$batch[batchno]</option>
";
}
echo"
</select>";
echo "<div name='text-panel$re3[inventory_id]' id='text-panel$re3[inventory_id]'>";
echo "<input type='hidden' name='inventoryId' value='$re3[inventory_id]'/ >
<input type='number' required value='$conqty' id='txt2$re3[inventory_id]' name='quantitygiven' onkeyup='sum$re3[inventory_id]();' maxlength='2' size='2' style='margin-top:12px'> $rms[Category]
<br>
<input type='hidden' id='txt1$re3[inventory_id]' value='$re3[totalQty]' onkeyup='sum$re3[inventory_id]();' style='width:25%;'/><br>
<input type='hidden' id='txt3$re3[inventory_id]' name='SubQty' value='$re3[totalQty]' style='width:25%;'/>";
echo "</div>";
// echo "<br> <input type='number' value='$z' name='quantitygiven' maxlength='2' size='2' style='margin-top:12px;' > $rms[Category]";
echo"
<input type='hidden' name='id' value='$re1[Con_Slot_id]'></td>
<td><input type='hidden' name='consumable_id' value='$re1[consumable_id]'>
<input type='hidden' name='srno' value='$pavan'>
";
echo " <input type='submit' name='action' value='Disperse' id='ValDisperse' class='btn btn-success'> <br>";
// echo "<input type='text' name='deActiveId' value='$re1[id]'> <br> <input type='submit' name='action' value='Refuse' class='btn btn-info'>";
echo "<a href='Consumable_order.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$re1[Con_Slot_id]' class='btn btn-info' style='margin-top:5px; width:97%;'>Refuse</a>";
echo "
</form>";
}else{
echo " <form name='action' method='POST'><td>";
echo " <select name='batchno' id='chosen_a$re3[inventory_id]' required>
<option value='' disabled selected required>Batch No</option>";
$sql3 ="SELECT * FROM consumable_inventory WHERE Consumable_id='$re1[consumable_id]'";
$qsql3 = mysqli_query($con,$sql3);
while($batch = mysqli_fetch_array($qsql3))
{
echo"
<option value='$batch[batchno]' data-id='$batch[totalQty]'>$batch[batchno]</option>
";
}
echo"
</select>";
echo "<div name='text-panel$re3[inventory_id]' id='text-panel$re3[inventory_id]'>";
echo "<input type='hidden' name='inventoryId' value='$re3[inventory_id]'/ >
<input type='number' required value='$z' id='txt2$re3[inventory_id]' name='quantitygiven' onkeyup='sum$re3[inventory_id]();' maxlength='2' size='2' style='margin-top:12px'> $rms[Category]
<br>
<input type='hidden' id='txt1$re3[inventory_id]' value='$re3[totalQty]' onkeyup='sum$re3[inventory_id]();' style='width:25%;'/><br>
<input type='hidden' id='txt3$re3[inventory_id]' name='SubQty' value='$re3[totalQty]' style='width:25%;'/>";
echo "</div>";
// echo "<br> <input type='number' value='$z' name='quantitygiven' maxlength='2' size='2' style='margin-top:12px;' > $rms[Category]";
echo"
<input type='hidden' name='id' value='$re1[Con_Slot_id]'></td>
<td><input type='hidden' name='consumable_id' value='$re1[consumable_id]'>
<input type='hidden' name='srno' value='$pavan'>
";
echo " <input type='submit' name='action' value='Disperse' id='ValDisperse' class='btn btn-success'> <br>";
// echo "<input type='text' name='deActiveId' value='$re1[id]'> <br> <input type='submit' name='action' value='Refuse' class='btn btn-info'>";
echo "<a href='Consumable_order.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$re1[Con_Slot_id]' class='btn btn-info' style='margin-top:5px; width:97%;'>Refuse</a>";
echo "
</form>";
}
echo"
</td>
</tr> ";
}
}
?>
<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>
<!--new medicine -->
<!-- Button trigger modal -->
<button type="button" class="btn btn-primary" data-toggle="modal" data-target="#exampleModal" style='height:40px;width:200px; float:right;'>
Add Consumable
</button>
<!-- Modal -->
<div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-text="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<center> <h3 class="modal-title" id="exampleModalLabel" style='height:auto;width:auto;float:left;text-align:center;'><b>Add Consumable Order</b></h3></center>
<button type="button" class="close" data-dismiss="modal" aria-label="Close" style='height:auto;width:auto;float:right;'>
<span aria-text="true">×</span>
</button>
</div>
<div class="">
<form class='form1' name="opdmedicine" id="myForm" method="post">
<?php
$sql ="SELECT * FROM addaspatient WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo"<input type='hidden' name='drid' value='$rs[Admitted_Under]'>";
$sql1 ="SELECT * FROM opdslip WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'";
$qsql1 = mysqli_query($con,$sql1);
while($rs1 = mysqli_fetch_array($qsql1))
{
echo"<input type='hidden' name='treatmentid' value='$rs1[tratment]'>";
}
}
?>
<label>Consumable Name</label> <input onkeyup="this.value = this.value.toUpperCase();" onchange="drmdiload(this.value)" name='ConsumableName' 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 consumable_stock WHERE Admin_id='$re[entered_by]'";
$qsql = mysqli_query($con,$sql);
while($rs = mysqli_fetch_array($qsql))
{
echo "
<option value='$rs[Consumable_id]'>$rs[ConsumableName]</option>
";
}
}
?>
</datalist>
<div id='divmedidr'>
</div>
<label>Quantity</label>
<input type="text" placeholder="Quantity" name="Quantity">
<input type="hidden" name="status" value="Active">
<input type="hidden" name="poa" value="IPD_Consumable" >
<input type="submit" value="Add" class="btn btn-primary" style='height:40px;width:100px' name="opdmedicine">
</form>
</div>
<div class="modal-footer">
</div>
</div>
</div>
</div>
<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","loadConsumable.php?drmeid="+drmeid,true);
xmlhttp.send();
}
</script>
<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","loadConsumable.php?drmeid="+drmeid,true);
xmlhttp.send();
}
</script>
</body>
</html>