| Server IP : 162.240.98.243 / Your IP : 3.22.77.63 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/ |
Upload File : |
<?php
session_start();
require_once('../LoginManager.php');
require_once('../DBManager.php');
include('menu.php');
include('header.php');
if(isset($_POST['signup']))
{
LoginManager::department("$_POST[name]","$_POST[usertype]","$_POST[department_section]","$_POST[Heading_department]","$_POST[Number_beds]","$_POST[entered_by]");
}
if(isset($_GET[delid]))
{
$sql ="DELETE FROM department WHERE srno='$_GET[delid]'";
$qsql=mysqli_query($con,$sql);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted Successfully..');</script><script>window.location='$_SERVER[PHP_SELF]'</script>";
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
</head>
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />
<title> Pt Signup</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="new2.css">
</head>
<body>
<div class="content-wrapper">
<section class="content-header">
<table id="example2" class="table table-bordered table-hover">
<thead>
<tr>
<th><strong>Department</strong></th>
<th><strong>Department section </strong></th>
<th><strong>User Id </strong></th>
<th><strong>Password</strong></th>
<th><strong>Action</strong></th>
</tr>
</thead>
<tr>
<?php
include("dbconnection.php");
$narayan=LoginManager::currentUser();
$hari=LoginManager::getUserTypeByuname("$narayan");
$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$hari'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
$sql2 ="SELECT * FROM department WHERE entered_by='$rsn[entered_by]'";
$qsql2 = mysqli_query($con,$sql2);
while($rs = mysqli_fetch_array($qsql2))
{
$sql3 ="SELECT * FROM site_users WHERE userno='$rs[departmentid]'";
$qsql3 = mysqli_query($con,$sql3);
while($rs1 = mysqli_fetch_array($qsql3))
{
switch ($rs[name]) {
case 'DP_Intensive_care':
echo ' <td> Intensive care unit Nursing station</td>';
break;
case 'DP_General_ward':
echo ' <td> General ward Nursing Station</td>';
break;
case 'DP_Doctors_Notepad':
echo ' <td> Doctors Notepad</td>';
break;
case 'DP_reception':
echo ' <td> Reception</td>';
break;
case 'OPD_Front_desk':
echo ' <td> OPD Front desk</td>';
break;
case 'DP_SEMI_Pvt_ward':
echo ' <td> SEMI Pvt ward</td>';
break;
case 'DP_Pvt_Ward':
echo ' <td> Pvt Ward Nursing station</td>';
break;
case 'DP_OT_complex':
echo ' <td> OT complex Nursing station</td>';
break;
case 'DP_Pharmacy':
echo ' <td> Pharmacy</td>';
break;
case 'DP_Laboratory':
echo ' <td> Laboratory</td>';
break;
case 'DP_Diagnostic':
echo ' <td> Diagnostic</td>';
break;
case 'DP_Accounts':
echo ' <td> Accounts</td>';
break;
case 'e_a_nursing_station':
echo ' <td> E&A Nursing Station</td>';
break;
default:
echo '';
}
echo "
<td> $rs[department_section]</td>
<td> $rs1[uname]</td>
<td> $rs1[password]</td>
<td><a href='department_view.php?departmentid=$rs[departmentid]' ><i class='fa fa-eye' aria-hidden='true' style='color:black; font-size:20px;'></i></a> | <a href='department_edit.php?departmentid=$rs[departmentid]'><i class='fa fa-pencil-square-o' aria-hidden='true' style='color:blue;font-size:20px;'></i></a>| <a href='department.php?departmentid=$rs[departmentid]&delid=$rs[srno]'><i class='fa fa-trash-o' aria-hidden='true' style='color:red;font-size:20px;'></i></a></td>
</tr>
";
}
}
}
?> </tbody>
<tfoot>
</tfoot>
</table>
<style>
.box{
display: none;
}
.box1{
display: none;
}
.box2{
display: none;
}
.box3{
display: none;
}
.box4{
display: none;
}
</style>
<script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
<form name="signup" method="post" name="submit">
<h3><i class="fa fa-angle-right"></i> Department Access
</h3>
<script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
<script>
$(document).ready(function(){
$("select").change(function(){
$(this).find("option:selected").each(function(){
var optionValue = $(this).attr("value");
if(optionValue){
$(".box").not("." + optionValue).hide();
$("." + optionValue).show();
} else{
$(".box").hide();
}
});
}).change();
});
</script>
<script>
$(document).ready(function(){
$("select").change(function(){
$(this).find("option:selected").each(function(){
var optionValue = $(this).attr("value");
if(optionValue){
$(".box4").not("." + optionValue).hide();
$("." + optionValue).show();
} else{
$(".box4").hide();
}
});
}).change();
});
</script>
<script>
$(document).ready(function(){
$("select").change(function(){
$(this).find("option:selected").each(function(){
var optionValue = $(this).attr("value");
if(optionValue){
$(".box1").not("." + optionValue).hide();
$("." + optionValue).show();
} else{
$(".box1").hide();
}
});
}).change();
});
</script>
<script>
$(document).ready(function(){
$("select").change(function(){
$(this).find("option:selected").each(function(){
var optionValue = $(this).attr("value");
if(optionValue){
$(".box2").not("." + optionValue).hide();
$("." + optionValue).show();
} else{
$(".box2").hide();
}
});
}).change();
});
</script>
<script>
$(document).ready(function(){
$("select").change(function(){
$(this).find("option:selected").each(function(){
var optionValue = $(this).attr("value");
if(optionValue){
$(".box3").not("." + optionValue).hide();
$("." + optionValue).show();
} else{
$(".box3").hide();
}
});
}).change();
});
</script>
<body>
<label>Department</label>
<select name="name">
<option>Department</option>
<option value="DP_reception">Reception</option>
<option value="DP_Doctors_Notepad">Doctors Notepad </option>
<option value="OPD_Front_desk">OPD Nursing station </option>
<option value="e_a_nursing_station">E & A Nursing Station </option>
<option value="DP_General_ward">General ward Nursing Station</option>
<option value="DP_SEMI_Pvt_ward">SEMI Pvt ward </option>
<option value="DP_Pvt_Ward">Pvt Ward Nursing station </option>
<option value="DP_Intensive_care">Intensive care unit Nursing station </option>
<option value="DP_OT_complex">OT complex Nursing
station </option>
<option value="DP_Pharmacy">Pharmacy</option>
<option value="DP_Laboratory">Laboratory </option>
<option value="DP_Diagnostic">Diagnostic</option>
<option value="DP_Accounts">Billing and Accounts</option>
</select>
<label>Department section</label>
<input type="text" placeholder='Department section' name="department_section">
<p class="OPD_Front_desk box4">
<select name="Heading_department" id="select2">
<option value="">Select Dr</option>
<?php
include("dbconnection.php");
$narayan=LoginManager::currentUser();
$hari=LoginManager::getUserTypeByuname("$narayan");
$sqlpatient1 = "SELECT * FROM site_users WHERE userno='$hari'";
$qsqlpatient1 = mysqli_query($con,$sqlpatient1);
while($rsn = mysqli_fetch_array($qsqlpatient1))
{
$sqldoctor= "SELECT * FROM dr Where entered_by='$rsn[entered_by]'";
$qsqldoctor = mysqli_query($con,$sqldoctor);
while($rsdoctor = mysqli_fetch_array($qsqldoctor))
{
if($rsdoctor[drid] == $rsedit[Drname])
{
echo "<option value='$rsdoctor[drid]' selected>$rsdoctor[drid]-$rsdoctor[Drname]</option>";
}
else
{
echo "<option value='$rsdoctor[drid]'>$rsdoctor[drid]-$rsdoctor[Drname]</option>";
}
}
}
?>
</select>
</p>
<p class="DP_General_ward box">
<label>Number Of Bed</label><input type="text" name="Number_beds"></p>
<p class="e_a_nursing_station box4">
<label>Number Of Bed</label><input type="text" name="Number_beds"></p>
<p class="DP_SEMI_Pvt_ward box1">
<label>Number Of Bed</label><input type="text" name="Number_beds"></p>
<p class="DP_Pvt_Ward box2">
<label>Number Of Bed</label><input type="text" name="Number_beds"></p>
<p class="DP_Intensive_care box3">
<label>Number Of Bed</label><input type="text" name="Number_beds"></p>
<button type="submit" name="signup">Create
</button>
</form>
</body>
</html>