| Server IP : 162.240.98.243 / Your IP : 18.216.232.11 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/FO/Patient/ |
Upload File : |
<?php
session_start();
include("../../dbconnection.php");
require_once("../../../LoginManager.php");
require_once("../../../DBManager.php");
require_once("../../../patientmanager.php");
$title='Change Bed';
if(!isset($_SESSION['uname']))
{
echo "<script>alert('Session Expired..');</script><script>window.location='../index.php';</script>";
}
$narayan=LoginManager::currentUser();
$harilal=LoginManager::getUserTypeByuname("$narayan");
$sql ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsql = mysqli_query($con,$sql);
$rs = mysqli_fetch_array($qsql);
$sql ="SELECT * FROM hco WHERE adminid='$rs[entered_by]'";
$qsql = mysqli_query($con,$sql);
$rs1 = mysqli_fetch_array($qsql);
$usertype=$rs1['adminid'];
$sql13 ="SELECT * FROM admin WHERE id='$rs[entered_by]'";
$qsql13 = mysqli_query($con,$sql13);
$reas = mysqli_fetch_array($qsql13);
$DisplayForm=True;
$today = date('Y-m-d');
$sql1 ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsql1 = mysqli_query($con,$sql1);
while($rh1 = mysqli_fetch_array($qsql1))
{
$sql ="SELECT * FROM discharge WHERE hospital_id='$rh1[entered_by]' AND patientid='$_GET[patientid]' AND date(admissiondate) = '$today' AND typevisit='Opd_Emergency' AND prescriptionid='$_GET[prescriptionid]' OR hospital_id='$rh1[entered_by]' AND patientid='$_GET[patientid]' AND date(admissiondate) = '$today' AND typevisit='OPD' AND prescriptionid='$_GET[prescriptionid]'";
$qsql = mysqli_query($con,$sql);
if($rh = mysqli_fetch_array($qsql))
{
$DisplayForm=False;
echo "<script>window.location='opdtransfer.php?prescriptionid=$rh[prescriptionid]&patientid=$rh[patientid]'</script>";
}
}
if($DisplayForm)
{
?>
<?php
//Code for Registration
if(isset($_POST['signup']))
{
$updated_at=date("F d, Y / h:i:s A");
date_default_timezone_set('Asia/Kolkata');
$datetime= date("Y-m-d H:i:s"); // time in India
$sql ="UPDATE request_for_admission SET Ward='$_POST[Ward]',Bed='$_POST[Bed]',updated_at='$updated_at' WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'";
$sql4 ="UPDATE transferbed SET Discharge='$datetime', day='$_POST[DischargeDays]',status='1' WHERE srno='$_POST[Transfer_srno]'";
$qsql = mysqli_query($con,$sql4);
$sql2 ="UPDATE bedindex SET status='Active',prescriptionid='' WHERE prescriptionid='$_GET[prescriptionid]'";
$bedindex = mysqli_query($con,$sql2);
$sql3 ="UPDATE bedindex SET status='Inactive',prescriptionid='$_GET[prescriptionid]' WHERE bedid='$_POST[Bed]'";
$bedindex2 = mysqli_query($con,$sql3);
//
PatientManager::transferbedpatient("$_GET[prescriptionid]","$_POST[Bed]","$datetime","");
if($qsql = mysqli_query($con,$sql))
{
echo "<script>alert('Update successfully');</script><script>window.history.go(-1)</script>;</script>";
}
//}
else {
echo "Sorry, there was an error uploading your file.";
}
}
//
if(isset($_POST['TimeUpdate'])){
$TimeUpdate ="UPDATE transferbed SET Discharge='$_POST[DischargeTime]', day='$_POST[DischargeDays]',status='1' WHERE srno='$_POST[Transfer_srno]'";
if($RowTime = mysqli_query($con,$TimeUpdate))
{
echo "<script>alert('Update successfully');</script><script>window.history.go(-1)</script>;</script>";
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
<meta charset="utf-8" />
<title><?php echo $title; ?></title>
<meta name="description" content="3 styles with inline editable feature" />
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0" />
<!-- bootstrap & fontawesome -->
<link rel="stylesheet" href="../assets/css/bootstrap.min.css" />
<link rel="stylesheet" href="../assets/font-awesome/4.5.0/css/font-awesome.min.css" />
<!-- page specific plugin styles -->
<link rel="stylesheet" href="../assets/css/jquery-ui.custom.min.css" />
<link rel="stylesheet" href="../assets/css/jquery.gritter.min.css" />
<link rel="stylesheet" href="../assets/css/select2.min.css" />
<link rel="stylesheet" href="../assets/css/bootstrap-datepicker3.min.css" />
<link rel="stylesheet" href="../assets/css/bootstrap-editable.min.css" />
<!-- text fonts -->
<link rel="stylesheet" href="../assets/css/fonts.googleapis.com.css" />
<!-- ace styles -->
<link rel="stylesheet" href="../assets/css/ace.min.css" class="ace-main-stylesheet" id="main-ace-style" />
<!--[if lte IE 9]>
<link rel="stylesheet" href="../assets/css/ace-part2.min.css" class="ace-main-stylesheet" />
<![endif]-->
<link rel="stylesheet" href="../assets/css/ace-skins.min.css" />
<link rel="stylesheet" href="../assets/css/ace-rtl.min.css" />
<!--[if lte IE 9]>
<link rel="stylesheet" href="../assets/css/ace-ie.min.css" />
<![endif]-->
<!-- inline styles related to this page -->
<!-- ace settings handler -->
<script src="../assets/js/ace-extra.min.js"></script>
<!-- HTML5shiv and Respond.js for IE8 to support HTML5 elements and media queries -->
<!--[if lte IE 8]>
<script src="../assets/js/html5shiv.min.js"></script>
<script src="../assets/js/respond.min.js"></script>
<![endif]-->
</head>
<body class="no-skin">
<div id="navbar" class="navbar navbar-default ace-save-state">
<?php include('../includes/header.php'); ?><!-- /.navbar-container -->
</div>
<div class="main-container ace-save-state" id="main-container">
<script type="text/javascript">
try{ace.settings.loadState('main-container')}catch(e){}
</script>
<div id="sidebar" class="sidebar responsive ace-save-state">
<script type="text/javascript">
try{ace.settings.loadState('sidebar')}catch(e){}
</script>
<!-- /.sidebar-shortcuts -->
<?php include('sidebar.php'); ?><!-- /.nav-list -->
<div class="sidebar-toggle sidebar-collapse" id="sidebar-collapse">
<i id="sidebar-toggle-icon" class="ace-icon fa fa-angle-double-left ace-save-state" data-icon1="ace-icon fa fa-angle-double-left" data-icon2="ace-icon fa fa-angle-double-right"></i>
</div>
</div>
<div class="main-content">
<div class="main-content-inner">
<div class="breadcrumbs ace-save-state" id="breadcrumbs">
<ul class="breadcrumb">
<li>
<i class="ace-icon fa fa-home home-icon"></i>
<a href="#">Home</a>
</li>
<li class="active"><?php echo $title; ?></li>
</ul><!-- /.breadcrumb -->
<div class="nav-search" id="nav-search">
<form class="form-search">
<span class="input-icon">
<input type="text" placeholder="Search ..." class="nav-search-input" id="nav-search-input" autocomplete="off" />
<i class="ace-icon fa fa-search nav-search-icon"></i>
</span>
</form>
</div><!-- /.nav-search -->
</div>
<div class="page-content">
<!-- /.ace-settings-container -->
<div class="page-header">
<h1>
Add
<small>
<i class="ace-icon fa fa-angle-double-right"></i>
<?php echo $title ?>
</small>
</h1>
</div><!-- /.page-header -->
<div class="row">
<div class='col-xs-12'>
<div class='content-wrapper'>
<table class="table table-bordered table-hover">
<thead>
<tr>
<th><strong>Transfer In</strong></th>
<th><strong>Transfer Out</strong></th>
<th><strong>Towards </strong></th>
<th><strong>Duration </strong></th>
<th><strong> <section class="content-header">Action</section> </strong></th>
</tr>
</thead>
<?php
$sql ="SELECT * FROM addaspatient WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'";
$qsql = mysqli_query($con,$sql);
if($rs = mysqli_fetch_array($qsql))
{
$sqlpatient = "SELECT * FROM transferbed WHERE prescriptionid='$rs[prescriptionid]' ORDER BY srno ASC";
$qsqlpatient = mysqli_query($con,$sqlpatient);
while($rsp = mysqli_fetch_array($qsqlpatient))
{
$sqlpatient1 = "SELECT * FROM bedindex WHERE bedid='$rsp[towords]'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
$sqlpatient12 = "SELECT * FROM ward WHERE wardid='$rsn[wardid]'";
$qsqlpatient12 = mysqli_query($con,$sqlpatient12);
while($rsn12 = mysqli_fetch_array($qsqlpatient12))
{
$date1 =$rsp['datetime'];
$date2 =$rsp['Discharge'];
$datetime= date("Y-m-d H:i:s");
$timestamp1 = strtotime($date1);
$timestamp2 = strtotime($date2);
$day = round(abs($timestamp2 - $timestamp1)/(60*60*24));
//echo $day;
// $diff = abs(strtotime($date2) - strtotime($date1));
// $years = floor($diff / (365*60*60*24));
// $months = floor(($diff - $years * 365*60*60*24) / (30*60*60*24));
// $day = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24));
// $sqlPatientDay="SELECT prescriptionid ,DATEDIFF('$rsp[Discharge]','$rsp[datetime]') AS BedDays FROM transferbed Where prescriptionid='$rs[prescriptionid]' GROUP BY prescriptionid";
$sqlBedDetailCharge = "SELECT * FROM BedDetailCharge WHERE prescriptionid='$rs[prescriptionid]' AND patientid='$_GET[patientid]' AND ward='$rsn[wardid]'";
$qsqlBedDetailCharge = mysqli_query($con,$sqlBedDetailCharge);
$rBedDetailCharge = mysqli_fetch_array($qsqlBedDetailCharge);
echo " <tbody>
<tr> <td> $rsp[datetime]</td>
<td> $rsp[Discharge]</td>
<td> $rsn12[ward_type]-$rsn12[ward_name]-$rsn[bedname] <br></td>
<td>";
?><?php
if($day=='0'){
echo '1 day';
}elseif($day==$rsp['day']){
echo $day.' days';
}
else {
echo "1 day";
}
?>
<?php echo"</td>
<td>
<section class='content-header'>
" ;
if($rsp['Discharge']==''){
echo " | <a href='#' data-toggle='modal' data-target='#modalTrans$rsp[srno]'><i class='fa fa-exchange' aria-hidden='true' style='color:#3e049d; font-size:20px;'></i></a>";
echo "<div id='modalTrans$rsp[srno]' class='modal fade' role='dialog'>
<div class='modal-dialog'>
<!-- Modal content-->
<form method='post'> <div class='modal-content'>
<div class='modal-header'>
<button type='button' class='close' data-dismiss='modal'>×</button>
<h4 class='modal-title' style='text-align-last: left'>Transfer Bed</h4>
</div>
<div class='modal-body'>";
echo "<table class='table table-bordered table-hover'>";
$sql ="SELECT * FROM addaspatient WHERE prescriptionid=$_GET[prescriptionid] AND patientid=$_GET[patientid]";
$qsql = mysqli_query($con,$sql);
if($rs = mysqli_fetch_array($qsql))
{
if(IPD==$rs[typevisit])
{
echo "<tr>
<td width='50%'> Ward </td><td><select onchange='loadbedva(this.value)' id='Ward' name='Ward' class='form-control'>";
$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))
{
$sql21 ="SELECT * FROM ward WHERE wardid='$rs[Ward]' AND (ward_department='2' OR ward_department='1')";
$qsql21 = mysqli_query($con,$sql21);
if($rs11 = mysqli_fetch_array($qsql21))
{
$sql22 ="SELECT * FROM bedindex WHERE bedid='$rs[Bed]'";
$qsql22 = mysqli_query($con,$sql22);
while($rs12 = mysqli_fetch_array($qsql22))
{
echo"<option value='$rs11[wardid]'> $rs11[ward_type] - $rs11[ward_name]</option>";
$sql1 ="SELECT * FROM site_users WHERE userno='$harilal'";
$qsql1 = mysqli_query($con,$sql1);
if($rh1 = mysqli_fetch_array($qsql1))
{
$sql2 ="SELECT * FROM ward WHERE adminid='$rh1[entered_by]' AND (ward_department='2' OR ward_department='1')";
$qsql2 = mysqli_query($con,$sql2);
while($rh2 = mysqli_fetch_array($qsql2))
{
echo "<option value='$rh2[wardid]' data-id='$rh2[wardid]'> $rh2[ward_type] - $rh2[ward_name]</option>";
}
}
}
}
}
echo "</select></td></tr>";
$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))
{
$sql21 ="SELECT * FROM ward WHERE wardid='$rs[Ward]'";
$qsql21 = mysqli_query($con,$sql21);
if($rs11 = mysqli_fetch_array($qsql21))
{
$sql22 ="SELECT * FROM bedindex WHERE bedid='$rs[Bed]'";
$qsql22 = mysqli_query($con,$sql22);
while($rs12 = mysqli_fetch_array($qsql22))
{
echo"
<input type='hidden' placeholder='Bed No.' value='$rs12[bedid]' name='bedid' class='form-control'>
<input type='hidden' placeholder='wardid' value='$rs12[wardid]' name='wardid' class='form-control'>
<input type='hidden' name='ward' id='ward' style='color: black; border-bottom: 1px solid;'>
<tr id='pavnid'>
<td width='50%'>Bed</td>
<td width='50%'>
<input type='text' placeholder='Bed No.' value='$rs12[bedname]' name='Bed' class='form-control'>
<br>
</td>
</tr>
";
}
}
}
}
}
echo "<tr>
<td colspan='2'>
<input type='hidden' name='Transfer_srno' value='$rsp[srno]'/>";?>
<input type='hidden' name='DischargeDays' value='<?php
if($day=='0'){
echo '1';
}elseif($day==$rsp['day']){
echo $day.'';
}
else {
echo "1";
}
?>' />
<?php echo "</td>
</tr> </table>
</div>
<div class='modal-footer'>
<button type='submit' name='signup' class='btn btn-success'>Transfer</button>
<button type='button' class='btn btn-default' data-dismiss='modal'>Close</button>
</div>
</div></form>
</div>
</div>";
}else{
echo "| <a href='#' data-toggle='modal' data-target='#modalRegister$rsp[srno]'><i class='fa fa-pencil-square-o' aria-hidden='true' style='color:green; font-size:20px;'></i></a>";
echo "<div id='modalRegister$rsp[srno]' class='modal fade' role='dialog'>
<div class='modal-dialog'>
<!-- Modal content-->
<form method='post'> <div class='modal-content'>
<div class='modal-header'>
<button type='button' class='close' data-dismiss='modal'>×</button>
<h4 class='modal-title' style='text-align-last: left'>Update</h4>
</div>
<div class='modal-body'>
<table class='table table-hover table-bordered'>
<tr>
<td>Date & Time</td>
<td><input type='text' name='DischargeTime' value='$rsp[Discharge]' /></td>
</tr>
<tr>
<td>Days</td><td>";?>
<input type='text' name='DischargeDays' value='<?php if($day=='0'){
echo '1';
}elseif($day==$day){
echo $day;
}
?>' />
<?php echo "</td></tr>
<tr>
<td colspan='2'>
<input type='hidden' name='Transfer_srno' value='$rsp[srno]'/>
</td>
</tr>
</table>
</div>
<div class='modal-footer'>
<input type='submit' class='btn btn-success' name='TimeUpdate' value='Save' />
<button type='button' class='btn btn-default' data-dismiss='modal'>Close</button>
</div>
</div></form>
</div>
</div>";
}
?>
<?php
echo "</section>
</td>
</tr>
";
}
}
}
}
?> </tbody>
<tfoot>
</tfoot>
</table>
<script>
function loadbedva(bedid)
{
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("pavnid").innerHTML = this.responseText;
}
};
xmlhttp.open("GET","loadbed.php?bedid="+bedid,true);
xmlhttp.send();
}
</script>
</div>
</div><!-- /.row -->
</div><!-- /.page-content -->
</div>
</div><!-- /.main-content -->
<?php include('includes/footer.php'); ?>
<a href="#" id="btn-scroll-up" class="btn-scroll-up btn btn-sm btn-inverse">
<i class="ace-icon fa fa-angle-double-up icon-only bigger-110"></i>
</a>
</div><!-- /.main-container -->
<!-- basic scripts -->
<!--[if !IE]> -->
<script src="../assets/js/jquery-2.1.4.min.js"></script>
<!-- <![endif]-->
<script>
var mySelect = document.getElementById("Ward");
mySelect.addEventListener("change", function() {
var myOption = mySelect.options[mySelect.selectedIndex].getAttribute("data-id");
document.getElementById('ward').value = myOption;
});
</script>
<script>
var myBed = document.getElementById("Bed");
myBed.addEventListener("change", function() {
var myBedId = myBed.options[myBed.selectedIndex].getAttribute("data-bed");
document.getElementById('bedid1').value = myBedId;
});
</script>
<!--[if IE]>
<script src="../assets/js/jquery-1.11.3.min.js"></script>
<![endif]-->
<script type="text/javascript">
if('ontouchstart' in document.documentElement) document.write("<script src='../assets/js/jquery.mobile.custom.min.js'>"+"<"+"/script>");
</script>
<script src="../assets/js/bootstrap.min.js"></script>
<!-- page specific plugin scripts -->
<!--[if lte IE 8]>
<script src="../assets/js/excanvas.min.js"></script>
<![endif]-->
<script src="../assets/js/jquery-ui.custom.min.js"></script>
<script src="../assets/js/jquery.ui.touch-punch.min.js"></script>
<script src="../assets/js/chosen.jquery.min.js"></script>
<script src="../assets/js/spinbox.min.js"></script>
<script src="../assets/js/bootstrap-datepicker.min.js"></script>
<script src="../assets/js/bootstrap-timepicker.min.js"></script>
<script src="../assets/js/moment.min.js"></script>
<script src="../assets/js/daterangepicker.min.js"></script>
<script src="../assets/js/bootstrap-datetimepicker.min.js"></script>
<script src="../assets/js/bootstrap-colorpicker.min.js"></script>
<script src="../assets/js/jquery.knob.min.js"></script>
<script src="../assets/js/autosize.min.js"></script>
<script src="../assets/js/jquery.inputlimiter.min.js"></script>
<script src="../assets/js/jquery.maskedinput.min.js"></script>
<script src="../assets/js/bootstrap-tag.min.js"></script>
<!-- ace scripts -->
<script src="../assets/js/ace-elements.min.js"></script>
<script src="../assets/js/ace.min.js"></script>
<!-- inline scripts related to this page -->
</body>
</html>
<?php } ?>