| Server IP : 162.240.98.243 / Your IP : 18.226.200.54 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/NewHR/ |
Upload File : |
<?php
session_start();
include("../dbconnection.php");
require_once("../../LoginManager.php");
require_once("../../DBManager.php");
require_once("../../patientmanager.php");
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'];
if(isset($_POST['AddSpecify']))
{
$sql2 ="INSERT INTO medi_condition_final(patientid,medicalcon,Specify,Status) values('$_POST[patientid]','$_POST[first_chk_bx]','$_POST[Specify]','$_POST[Status]')";
if($qsql2 = mysqli_query($con,$sql2))
{
//echo "<script>alert('Medication record inserted successfully...');</script><script>window.location='MedicalCondition.php';</script>;</script>";
}}
if(isset($_POST['medical_condition']))
{ $medicalcon = $_POST['medicalcon'];
for ($i=0; $i<sizeof($medicalcon);$i++) {
$CheckPatient = $con->query("SELECT * FROM `medi_condition_final` WHERE `patientid` = '$_POST[patientid]' AND `medicalcon` = '$medicalcon[$i]'");
$numSU=mysqli_num_rows($CheckPatient);
if($numSU > 0){
echo "<script>alert('".$medicalcon[$i]." Already Exists');</script>";
}else{
$sql ="INSERT INTO medi_condition_final(patientid,medicalcon,Specify,Status) values('$_POST[patientid]','$medicalcon[$i]','$_POST[Specify]','$_POST[Status]')";
//echo $sql;
if($qsql = mysqli_query($con,$sql))
{
echo "<script>alert('Medication record inserted successfully...');</script><script>window.location='MedicalCondition.php';</script>;</script>";
}
else
{
echo mysqli_error($con);
}
}
}
}
if(isset($_GET['del'])){
$Medi_Condition=$con->query("DELETE FROM `medi_condition_final` WHERE medicalcoid='$_GET[del]'");
if($Medi_Condition==1){
echo "<script>alert('Medication Record Delete Successfully...');</script><script>window.location='MedicalCondition.php';</script>;</script>";
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
<meta charset="utf-8" />
<title>Medical Condition</title>
<meta name="description" content="Common form elements and layouts" />
<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/chosen.min.css" />
<link rel="stylesheet" href="assets/css/bootstrap-datepicker3.min.css" />
<link rel="stylesheet" href="assets/css/bootstrap-timepicker.min.css" />
<link rel="stylesheet" href="assets/css/daterangepicker.min.css" />
<link rel="stylesheet" href="assets/css/bootstrap-datetimepicker.min.css" />
<link rel="stylesheet" href="assets/css/bootstrap-colorpicker.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">
<?php include('includes/header.php'); ?>
<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>
<div class="sidebar-shortcuts" id="sidebar-shortcuts">
<div class="sidebar-shortcuts-large" id="sidebar-shortcuts-large">
<button class="btn btn-success">
<i class="ace-icon fa fa-signal"></i>
</button>
<button class="btn btn-info">
<i class="ace-icon fa fa-pencil"></i>
</button>
<button class="btn btn-warning">
<i class="ace-icon fa fa-users"></i>
</button>
<button class="btn btn-danger">
<i class="ace-icon fa fa-cogs"></i>
</button>
</div>
<div class="sidebar-shortcuts-mini" id="sidebar-shortcuts-mini">
<span class="btn btn-success"></span>
<span class="btn btn-info"></span>
<span class="btn btn-warning"></span>
<span class="btn btn-danger"></span>
</div>
</div><!-- /.sidebar-shortcuts -->
<?php include('includes/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>
<a href="#">Add</a>
</li>
<li class="active">Medical Condition</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">
<div class="ace-settings-container" id="ace-settings-container">
<div class="btn btn-app btn-xs btn-warning ace-settings-btn" id="ace-settings-btn">
<i class="ace-icon fa fa-cog bigger-130"></i>
</div>
<div class="ace-settings-box clearfix" id="ace-settings-box">
<div class="pull-left width-50">
<div class="ace-settings-item">
<div class="pull-left">
<select id="skin-colorpicker" class="hide">
<option data-skin="no-skin" value="#438EB9">#438EB9</option>
<option data-skin="skin-1" value="#222A2D">#222A2D</option>
<option data-skin="skin-2" value="#C6487E">#C6487E</option>
<option data-skin="skin-3" value="#D0D0D0">#D0D0D0</option>
</select>
</div>
<span> Choose Skin</span>
</div>
<div class="ace-settings-item">
<input type="checkbox" class="ace ace-checkbox-2 ace-save-state" id="ace-settings-navbar" autocomplete="off" />
<label class="lbl" for="ace-settings-navbar"> Fixed Navbar</label>
</div>
<div class="ace-settings-item">
<input type="checkbox" class="ace ace-checkbox-2 ace-save-state" id="ace-settings-sidebar" autocomplete="off" />
<label class="lbl" for="ace-settings-sidebar"> Fixed Sidebar</label>
</div>
<div class="ace-settings-item">
<input type="checkbox" class="ace ace-checkbox-2 ace-save-state" id="ace-settings-breadcrumbs" autocomplete="off" />
<label class="lbl" for="ace-settings-breadcrumbs"> Fixed Breadcrumbs</label>
</div>
<div class="ace-settings-item">
<input type="checkbox" class="ace ace-checkbox-2" id="ace-settings-rtl" autocomplete="off" />
<label class="lbl" for="ace-settings-rtl"> Right To Left (rtl)</label>
</div>
<div class="ace-settings-item">
<input type="checkbox" class="ace ace-checkbox-2 ace-save-state" id="ace-settings-add-container" autocomplete="off" />
<label class="lbl" for="ace-settings-add-container">
Inside
<b>.container</b>
</label>
</div>
</div><!-- /.pull-left -->
<div class="pull-left width-50">
<div class="ace-settings-item">
<input type="checkbox" class="ace ace-checkbox-2" id="ace-settings-hover" autocomplete="off" />
<label class="lbl" for="ace-settings-hover"> Submenu on Hover</label>
</div>
<div class="ace-settings-item">
<input type="checkbox" class="ace ace-checkbox-2" id="ace-settings-compact" autocomplete="off" />
<label class="lbl" for="ace-settings-compact"> Compact Sidebar</label>
</div>
<div class="ace-settings-item">
<input type="checkbox" class="ace ace-checkbox-2" id="ace-settings-highlight" autocomplete="off" />
<label class="lbl" for="ace-settings-highlight"> Alt. Active Item</label>
</div>
</div><!-- /.pull-left -->
</div><!-- /.ace-settings-box -->
</div><!-- /.ace-settings-container -->
<div class="page-header">
<h1>
Add
<small>
<i class="ace-icon fa fa-angle-double-right"></i>
Medical Condition
</small>
</h1>
</div><!-- /.page-header -->
<div class="row">
<div class="col-xs-12">
<!-- PAGE CONTENT BEGINS -->
<div class="row">
<div class="col-xs-12">
<table id="dynamic-table" class="table table-striped table-bordered table-hover">
<thead>
<tr>
<th><strong>Medical Condition</strong></th>
<th><strong>Status</strong></th>
<th><strong>Action </strong></th>
</tr>
</thead>
<tbody>
<?php
$MCF ="SELECT * FROM medi_condition_final WHERE patientid='$harilal'";
$qMCF = mysqli_query($con,$MCF);
while($rMCF = mysqli_fetch_array($qMCF))
{
echo "
<tr> <td> $rMCF[medicalcon] <b>$rMCF[Specify]</b></td>
<td> $rMCF[Status]</td>
<td>
<a href='MedicalCondition.php?del=$rMCF[medicalcoid]'><i class='fa fa-trash-o' aria-hidden='true' style='color:red; font-size:20px;'></i></a>
</td>
</tr>
";
}
?>
</tbody>
<tfoot>
</tfoot>
</table>
</div><!-- /.span -->
</div><!-- /.row -->
<div class="row">
<div class='col-xs-12'>
<form method="post" >
<table id="example2" class="table table-bordered table-hover">
<tbody>
<input type="hidden" name="patientid" id="patientid" value="<?php echo $rs['userno'] ?>">
<tr>
<td>Medical Condition <br>(Multiple Selection)</td>
<td>
<div class="row">
<div class='col-sm-3'><input type="checkbox" name="medicalcon[]" value="Diabetes" checked> Diabetes</div>
<div class='col-sm-3'><input type="checkbox" name="medicalcon[]" value="Thyroid"> Thyroid</div>
<div class='col-sm-3'><input type="checkbox" name="medicalcon[]" value="Cholesterol"> Cholesterol</div>
<div class='col-sm-3'><input type="checkbox" name="medicalcon[]" value="Physical Injury"> Physical Injury</div>
<div class='col-sm-3'><input type="checkbox" name="medicalcon[]" value="Heart Condition"> Heart Condition</div>
<div class='col-sm-3'><input type="checkbox" name="medicalcon[]" value="Anemia"> Anemia</div>
<div class='col-sm-3'><input type="checkbox" name="medicalcon[]" value="Thalassemia"> Thalassemia</div>
<div class='col-sm-3'><input type="checkbox" name="medicalcon[]" value="HIV"> HIV</div>
<div class='col-sm-3'><input type="checkbox" name="medicalcon[]" value="Low Blood Pressure"> Low Blood Pressure</div>
<div class='col-sm-3'><input type="checkbox" name="medicalcon[]" value="High Blood Pressure"> High Blood Pressure</div>
<div class='col-sm-3'><input type="checkbox" name="medicalcon[]" value="Hypertension"> Hypertension</div>
<div class='col-sm-3'><input type="checkbox" name="medicalcon[]" value="Depression"> Depression</div>
<div class='col-sm-3'><input type="checkbox" name="medicalcon[]" value="Physically challenged"> Physically challenged</div>
<div class='col-sm-3'><input type="checkbox" name="medicalcon[]" value="Mentally challenged"> Mentally challenged</div>
<div class='col-sm-3'><input type="checkbox" name="medicalcon[]" value="Terminally ill"> Terminally ill</div>
<?php
$sql1 ="SELECT * FROM patient WHERE patientid='$harilal'";
$qsql1 = mysqli_query($con,$sql1);
while($rspi1 = mysqli_fetch_array($qsql1))
{
$sex=$rspi1['gendor'];
if($sex == 'Female'){
echo"
<div class='col-sm-3'><input type='checkbox' name='medicalcon[]' value='PCOD'> PCOD</div>
<div class='col-sm-3'><input type='checkbox' name='medicalcon[]' value='Pregnancy'> Pregnancy</div>";
}else
{
echo"";
}
}
?>
</div>
</td>
</tr>
<tr><td></td>
<td>
<div class='row'>
<div class='col-sm-12'><input type="hidden" name="Status" value="Active" /></div>
</div>
</td>
</tr>
<tr>
<td colspan="2" align="right">
<input type="submit" name="medical_condition" id="submit" value="Add Record" class="btn btn-info">
</td>
</tr>
<tr>
<td colspan="2" ></td>
</tr>
</tbody>
</table>
</form>
<form method="post" >
<table id="example2" class="table table-bordered table-hover">
<tbody>
<input type="hidden" name="patientid" id="patientid" value="<?php echo $rs['userno'] ?>">
<tr>
</tr>
<tr><td colspan='2'>
<div class='col-sm-3'><input type="checkbox" name="first_chk_bx" id="first_chk_bx" value="History of Surgery & Treatment" > History of Surgery & Treatment</div>
<div id="first_list_bx" style="display:none;"> <label><b>Specify</b></label> <input type="text" name="Specify" class='form-control'>
<input type="hidden" name="Status" value="Active" />
<input type="submit" name="AddSpecify" id="submit" value="Add Record" class="btn btn-info" style='float:right;margin:5px;'>
</div>
</td></tr>
</tbody>
</table>
</form>
</div>
</div>
<div class="hr hr-18 dotted hr-double"></div>
<!-- PAGE CONTENT ENDS -->
</div><!-- /.col -->
</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]-->
<!--[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 -->
<script>
document.getElementById('btn').addEventListener("click", function(){
this.classList.add("loading");
this.innerHTML = "Loading...";
});
</script>
<script type="text/javascript">
$('#first_chk_bx').click(function() {
if($(this).is(":checked")){
$("#first_list_bx").show();
}
else{
$("#first_list_bx").hide();
}
});
</script>
</body>
</html>