Server IP : 162.240.98.243 / Your IP : 18.117.99.152 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("../patientmanager.php"); require_once("../DBManager.php"); if(isset($_POST[CPAPva])) { PatientManager::CPAP("$_GET[prescriptionid]","$_GET[patientid]","$_POST[CPAP]","$_POST[CPAP_start]","$_POST[CPAP_stop]","$_POST[duration]","$_POST[entered_by]"); } ?> <?php if(isset($_POST['updateCPAP'])) { $sql6="UPDATE CPAP SET CPAP='$_POST[CPAP]',CPAP_stop='$_POST[CPAP_stop]',duration='$_POST[duration]' WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND CPAP='on'"; if($qsql6 = mysqli_query($con,$sql6)) { echo "<script>alert('Update successfully');</script><script>window.location='nursingrecodstest.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]'</script>;</script>"; $sql4 ="SELECT * FROM CPAP WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND id='$_POST[id]'"; $qsql4 = mysqli_query($con,$sql4); while($rpn = mysqli_fetch_array($qsql4)) { $date1 =$rpn[CPAP_start]; $date2 =$rpn[CPAP_stop]; $timestamp1 = strtotime($date1); $timestamp2 = strtotime($date2); $hour = abs($timestamp2 - $timestamp1)/(60*60); $d8=round($hour); if ($rpn[CPAP_stop]=='') { if ($d8 < "1") { } } else { $total=$d8; } require_once('../DBManager.php'); require_once('../LoginManager.php'); $narayan=LoginManager::currentUser(); $usertype=LoginManager::getUserTypeByuname("$narayan"); $today = date('Y-m-d'); $sql1 ="SELECT * FROM site_users WHERE userno='$usertype'"; $qsql1 = mysqli_query($con,$sql1); if($re = mysqli_fetch_array($qsql1)) { $sql56 ="SELECT * FROM request_for_admission WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'"; $qsql56 = mysqli_query($con,$sql56); while($rs56 = mysqli_fetch_array($qsql56)) { $sql212 ="SELECT * FROM tarifrate WHERE tarifid='10' AND hospitalid='$re[entered_by]' AND wardid='$rs56[Ward]'"; $qsql212 = mysqli_query($con,$sql212); if($rs112 = mysqli_fetch_array($qsql212)) { $subbill=$total*$rs112[rate]; $msg=mysqli_query($con,"insert into patient_invace(patientid, prescriptionid,discription,pagetype,link,pricetotal,discount,grand_total,paymentmode,status,entered_by,created_at,updated_at) values('$_GET[patientid]','$_GET[prescriptionid]','CPAP','$total','drinvace.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&id=$_POST[id]','$subbill','','','','','$usertype','','')"); { } } } } } } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta name="description" content=""> <meta name="author" content="Dashboard"> <meta name="keyword" content="Dashboard, Bootstrap, Admin, Template, Theme, Responsive, Fluid, Retina"> <title>CPAP </title> <h3><i class="fa fa-angle-right"></i> CPAP </h3> <body> <?php $DisplayForm=True; $sql5 ="SELECT * FROM CPAP WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND CPAP='on'"; $qsql5 = mysqli_query($con,$sql5); if($rt5 = mysqli_fetch_array($qsql5)) { $DisplayForm=False; echo " <form name='updateCPAP' method='post'>";?> <input type='hidden' name='CPAP_stop1' id='' value="<?php echo date("F d, Y / h:i:s A") ?>"> <!--<input type='hidden' name='CPAP_stop' id='myCheckCPAP'>--> <?php include("dbconnection.php"); require_once('../DBManager.php'); require_once('../LoginManager.php'); $narayan=LoginManager::currentUser(); $harilal=LoginManager::getUserTypeByuname("$narayan"); $sql1 ="SELECT * FROM site_users WHERE userno='$harilal'"; $qsql1 = mysqli_query($con,$sql1); if($re = mysqli_fetch_array($qsql1)) $transferbed="SELECT * FROM `request_for_admission` WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' "; $qTransferbed = mysqli_query($con,$transferbed); if($rTransferbed = mysqli_fetch_array($qTransferbed)) $sql41 ="SELECT * FROM CPAP WHERE ward_id='$rTransferbed[Ward]' AND bed_id='$rTransferbed[Bed]'"; $qsql41 = mysqli_query($con,$sql41); if($rpn1 = mysqli_fetch_array($qsql41)) date_default_timezone_set('Asia/Kolkata'); $date = date('y-m-d h:i:s'); $date1 ="$rpn1[CPAP_start]"; $date2 =$date; $timestamp1 = strtotime($date1); $timestamp2 = strtotime($date2); $hour = abs($timestamp2 - $timestamp1)/(60*60); $d8=round($hour); echo" <br> <input type='hidden' name='bedid' id='bedid' value='$rpn1[bed_id]'/> <input type='hidden' name='wardid' id='Ward' value='$rpn1[ward_id]'/> <input type='hidden' name='duration' id='duration' value='$d8'/> "; echo" <input type='hidden' name='id' value='$rt5[id]'> <input type='hidden' name='CPAP_stop' value='20$date'> <script> var today = new Date(); var time = today.getHours() + ':' + today.getMinutes() + ':' + today.getSeconds(); document.getElementById('myCheckCPAP').value = time; </script> <button type='submit' name='updateCPAP'>Stop</button> </form>"; } if($DisplayForm) { ?> <form name="CPAPva" method="post"> <input type='hidden' value='on' name='CPAP'> <input type='hidden' name='CPAP_start' id='' value="<?php echo date('y-m-d h:i:s') ?>"> <!--<input type='hidden' name='CPAP_start' id='myCheckCPAPstart'>--> <script> var today = new Date(); var time = today.getHours() + ':' + today.getMinutes() + ':' + today.getSeconds(); document.getElementById('myCheckCPAPstart').value = time; </script> <button type='submit' name='CPAPva'>Start</button> </form> <?php } ?> <style> form{ margin: 20px 0; } form input, button{ padding: 5px; } table{ width: 100%; margin-bottom: 20px; border-collapse: collapse; } table, th, td{ border: 1px solid #cdcdcd; } table th, table td{ padding: 10px; text-align: left; } <style> table{ border: solid 1px gray; width: 100%; } </style> </head> <div id="container"> <table border="1"> <tbody> <tr> <th><div align="center">Start At </div></th> <th><div align="center">Stop At </div></th> <th><div align="center">Duration </div></th> <th><div align="center">Created By</div></th> <th><div align="center">Action</div></th> </tr> </tbody> <?php include("dbconnection.php"); require_once('../DBManager.php'); require_once('../LoginManager.php'); $sql4 ="SELECT * FROM CPAP WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'"; $qsql4 = mysqli_query($con,$sql4); while($rpn = mysqli_fetch_array($qsql4)) { $sql1 ="SELECT * FROM site_users WHERE userno='$rpn[entered_by]'"; $qsql1 = mysqli_query($con,$sql1); while($re = mysqli_fetch_array($qsql1)) { $date1 =$rpn[CPAP_start]; $date2 =$rpn[CPAP_stop]; $timestamp1 = strtotime($date1); $timestamp2 = strtotime($date2); $hour = abs($timestamp2 - $timestamp1)/(60*60); $d8=round($hour); echo " <tbody> <tr> <td> $rpn[CPAP_start]</td> <td> $rpn[CPAP_stop]</td> <td>"; if ($rpn[CPAP_stop]=='') { if ($d8 < "1") { } } else { echo"$d8 <input type='hidden' name='duration' id='duration' value='$d8'/>"; } echo "</td> <td> $re[name]</td> <td> <a href='#'><i class='fa fa-eye' aria-hidden='true' style='font-size:20px;'></i></a></td> </tr> "; } } ?> </tbody> <tfoot> </tfoot> </table> </div>