Server IP : 162.240.98.243 / Your IP : 3.144.31.163 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(); include("dbconnection.php"); require_once("../patientmanager.php"); require_once("../DBManager.php"); if(isset($_POST[add_team])) { { $sql ="INSERT INTO surury_team(teamid,prescriptionid,patientid,surgeryid,team) values(Null,'$_POST[prescriptionid]','$_POST[patientid]','$_GET[surgeryid]','$_POST[team]')"; if($qsql = mysqli_query($con,$sql)) { PatientManager::setActivityLog("$_GET[patientid]","$_GET[prescriptionid]","Pre-Assessment Sheet<br>Surgery Team","showpage_add_team.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&srno=","$_POST[entered_by]"); echo "<script>alert('Team inserted successfully...');</script><script>window.location='PreOperativeAssessmentSheet.php?patientid=$_GET[patientid]&prescriptionid=$_GET[prescriptionid]&surgeryid=$_GET[surgeryid]';</script>;</script>"; } else { echo mysqli_error($con); } } } ?> <?php include("dbconnection.php"); if(isset($_GET[delid])) { $sql ="DELETE FROM surury_team WHERE teamid='$_GET[delid]'"; $qsql=mysqli_query($con,$sql); if(mysqli_affected_rows($con) == 1) { echo "<script>alert('Deleted successfully..');</script>"; } } ?> <meta name=”viewport” content=”width=device-width; initial-scale=1.0; maximum-scale=1.0; user-scalable=0;” /> <table id="example2" class="table table-bordered table-hover"> <thead> <tr> <ul class='nav nav-pills ml-auto p-2'> <th><strong>Surgery Team</strong></th> <th><strong>Action</strong></th> </tr> </thead> <?php include("dbconnection.php"); $sql ="SELECT * FROM surury_team WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'"; $qsql = mysqli_query($con,$sql); while($rs = mysqli_fetch_array($qsql)) { $sql1 ="SELECT * FROM site_users WHERE userno='$rs[team]'"; $qsql1 = mysqli_query($con,$sql1); while($rs1 = mysqli_fetch_array($qsql1)) { echo " <tbody> <tr> <td> $rs1[name]</td> <td><a href='PreOperativeAssessmentSheet.php?prescriptionid=$rs[prescriptionid]&patientid=$rs[patientid]&delid=$rs[teamid]&surgeryid=$rs[surgeryid]'><i class='fa fa-trash-o' style='font-size:20px; color:red;'></i></a></td> </tr> "; } } ?> </tr> </thead> </tbody> <tfoot> </tfoot> </table> <!DOCTYPE html> <html> <head> <title>Demo Select Box With Search Option Using Jquery - AllPHPTricks.com</title> <link rel="stylesheet" href="select2.min.css" /> <style> .select2-dropdown {top: 22px !important; left: 8px !important;} </style> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script> <script type="text/javascript"> $(document).ready(function(){ $('#myForm').submit(function() { $('#loaderImg').show(); return true; }); }); </script> <style> #loaderImg { position: absolute; top: 0; bottom: 0; left: 0; right: 0; margin: auto; border: 10px solid grey; border-radius: 50%; border-top: 10px solid black; width: 100px; height: 100px; animation: spin 1s linear infinite; } @keyframes spin { 0% { -webkit-transform: rotate(0deg); transform: rotate(0deg); } 100% { -webkit-transform: rotate(360deg); transform: rotate(360deg); } } </style> </head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <body> <div style = "display:none;" id = "loaderImg"> <div class="loader"> </div> </div> <form method="post" action="" name="add_team" id="myForm" onSubmit="return validateform()"> <table width="532" border="3"> <table id="example2" class="table table-bordered table-hover"> <tbody> <?php $sqlpatient= "SELECT * FROM addaspatient WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'"; $qsqlpatient = mysqli_query($con,$sqlpatient); while($rspatient=mysqli_fetch_array($qsqlpatient)) { echo " <input type='hidden' name='prescriptionid' id='prescriptionid' value='$rspatient[prescriptionid]'></td><input type='hidden' name='patientid' id='patientid' value='$rspatient[patientid]'></td>"; } ?> </tr> <?php require_once("../LoginManager.php"); require_once("../DBManager.php"); include("dbconnection.php"); $narayan=LoginManager::currentUser(); $usertype=LoginManager::getUserTypeByuname("$narayan"); $sql123 ="SELECT * FROM site_users WHERE userno='$usertype'"; $qsql123 = mysqli_query($con,$sql123); if($re23 = mysqli_fetch_array($qsql123)) { echo" <input type='hidden' name='entered_by' value='$re23[userno]'>"; } ?> <tr> <td>Surgery Team</td> <td><select name="team" id="team" class="form-control"> <option value='' disabled selected>Select Surgery Team</option> <?php include("dbconnection.php"); $username = "ventexint@gmail.com"; $apikey = "eebcced9-0ca1-4a6f-940b-c616276e2ec9"; $sendername = "EASNUP"; $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)) { $sqldoctor= "SELECT * FROM site_users WHERE usertype='Doctor' and entered_by='$re[entered_by]' or usertype='Nurse' and entered_by='$re[entered_by]' or usertype='RMO' and entered_by='$re[entered_by]' or usertype='OT' and entered_by='$re[entered_by]'"; $qsqldoctor = mysqli_query($con,$sqldoctor); while($rsdoctor = mysqli_fetch_array($qsqldoctor)) { echo "<option value='$rsdoctor[userno]'>$rsdoctor[name]</option>"; } } ?> </select></td> </tr> </tr> </tbody> </table> <tr> <td colspan="2" align="center"><input type="submit" name="add_team" id="add_team" value="ADD" /></td> </tr> </form> <script> $(function () { $("#example1").DataTable({ "responsive": true, "autoWidth": false, }); $('#example2').DataTable({ "paging": true, "lengthChange": false, "searching": false, "ordering": true, "info": true, "autoWidth": false, "responsive": true, }); }); </script>