Server IP : 162.240.98.243 / Your IP : 3.147.84.157 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('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>