Server IP : 162.240.98.243 / Your IP : 18.118.154.106 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("workdeskmenu.php"); include("header.php"); ?> <style> .p{ color: black; font-weight: 900; } /* Automatic Serial Number Row */ .css-serial { font-weight: 900; color: black; counter-reset: serial-number; /* Set the serial number counter to 0 */ } .css-serial td:first-child:before { counter-increment: serial-number; /* Increment the serial number counter */ content: counter(serial-number); /* Display the counter */ } </style> <style> #topright { position: absolute; right: 0; top: 0; margin-top: 73px; margin-right: 30px; display: block; height: 70px; width: 70px; background: url(TRbanner.gif) no-repeat; text-indent: -999em; text-decoration: none; } #toprightj { position: absolute; right: 0; top: 0; margin-top: 73px; margin-right: 120px; display: block; height: 70px; width: 70px; background: url(TRbanner.gif) no-repeat; text-indent: -999em; text-decoration: none; } #toprightb { position: absolute; right: 0; top: 0; margin-top: 73px; margin-right: 200px; display: block; height: 70px; width: 70px; background: url(TRbanner.gif) no-repeat; text-indent: -999em; text-decoration: none; } .center { border: 1px solid grey; text-align:; } .center2 { border: 5px solid grey; text-align:; } </style> <style> h2 { color: #4287f5; } a img { border: none; } #memo { padding-top: 50px; margin: 0 20px 0 60px; border-bottom: 1px solid #ddd; height: 150px; } #memo .logo { float: left; margin-right: 20px; } #memo .logo img { width: 150px; height: 100px; } #memo .company-info { float: right; text-align: right; } #memo .company-info > div:first-child { font-weight: bold; font-size: 22px; color: #1e73be; } #memo .company-info span { font-size: 11px; min-width: 20px; } </style> <div class="content-wrapper"> <!-- Content Header (Page header) --> <section class="content-header"> <!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"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" /> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script> <title>In House Patient</title> <body> <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> <script> function myFunction() { var checkBox = document.getElementById("myCheck"); var text = document.getElementById("text"); if (checkBox.checked == true){ text.style.display = "block"; } else { text.style.display = "none"; } } function myFunction2() { var checkBox = document.getElementById("myCheck2"); var text = document.getElementById("text2"); if (checkBox.checked == true){ text.style.display = "block"; } else { text.style.display = "none"; } } </script> </head> <h3 Align='center'>MRD Discharge </h3> <br> <?php $patient=$con->query("SELECT * FROM `patient` WHERE `patientid`='$_GET[patientid]'"); $RowPatient=$patient->fetch_assoc(); echo "<h4 style='text-align:center;color:red;'>$RowPatient[patientname]</h4>"; ?> <div class="checkbox"> <input name="Addiction" id="myCheck2" onclick="myFunction2()" class="shopitem-list" type="checkbox"><span>Custom Date </span> </div> <div id="text2" style="display:none" > <form action="" method="GET"> <div class="row"> <div class="col-md-4"> <div class="form-group"> <label>From Date</label> <input type="date" name="from_date" value="<?php if(isset($_GET['from_date'])){ echo $_GET['from_date']; } ?>" class="form-control"> </div> </div> <div class="col-md-4"> <div class="form-group"> <label>To Date</label> <input type="date" name="to_date" value="<?php if(isset($_GET['to_date'])){ echo $_GET['to_date']; } ?>" class="form-control"> </div> </div> <div class="col-md-4"> <div class="form-group"> <br> <button type="submit" class="btn btn-primary">Apply</button> </div> </div> </div> </form> </div> </span> <table class="order-table table-borderd css-serial" id='myTable'> <tr> <th>SR No</th> <th>Patient Details </th> <th>Details </th> </tr> <?php if (isset($_GET['page_no']) && $_GET['page_no']!="") { $page_no = $_GET['page_no']; } else { $page_no = 1; } $total_records_per_page = 10; $offset = ($page_no-1) * $total_records_per_page; $previous_page = $page_no - 1; $next_page = $page_no + 1; $adjacents = "2"; include("dbconnection.php"); require_once('../DBManager.php'); require_once('../LoginManager.php'); $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)) { { $from_date = $_GET['from_date']; $to_date = $_GET['to_date']; } //$result_count = mysqli_query($con,"SELECT COUNT(*) As total_records FROM addaspatient WHERE hospitalid='$re[entered_by]' AND date(admintedDate) BETWEEN '$from_date' AND '$to_date' AND (typevisit='IPD')"); $result_count = mysqli_query($con,"SELECT COUNT(*) As total_records FROM discharge WHERE hospital_id='$re[entered_by]'"); $total_records = mysqli_fetch_array($result_count); $total_records = $total_records['total_records']; $total_no_of_pages = ceil($total_records / $total_records_per_page); $second_last = $total_no_of_pages - 1; // total page minus 1 $sql2190 ="SELECT * FROM addaspatient WHERE hospitalid='$re[entered_by]' AND date(admintedDate) BETWEEN '$from_date' AND '$to_date' AND (typevisit='IPD') ORDER BY prescriptionid DESC"; //$sql2190 ="SELECT * FROM discharge WHERE hospital_id='$re[entered_by]' AND status='Discharge' LIMIT $offset, $total_records_per_page"; $qsql2190 = mysqli_query($con,$sql2190); while($rs = mysqli_fetch_array($qsql2190)) { $sql3 ="SELECT * FROM addaspatient WHERE patientid='$rs[patientid]' AND prescriptionid='$rs[prescriptionid]' "; $qsql3 = mysqli_query($con,$sql3); while($rsr = mysqli_fetch_array($qsql3)){ $sql4 ="SELECT * FROM patient WHERE patientid='$rsr[patientid]'"; $qsql4 = mysqli_query($con,$sql4); while($rp = mysqli_fetch_array($qsql4)){ $RFA ="SELECT * FROM request_for_admission WHERE patientid='$rsr[patientid]' AND prescriptionid='$rsr[prescriptionid]'"; $qRFA = mysqli_query($con,$RFA); while($rRFA = mysqli_fetch_array($qRFA)){ $NutritionalScreen=$con->query("SELECT * FROM `save_activity` WHERE userno='$rsr[patientid]' AND prescriptionid='$rsr[prescriptionid]' AND discription='Discharge<br>Doc.no-'"); $RowScreen=$NutritionalScreen->fetch_assoc(); echo "<tr> <td> </td> <td> <b>Date :</b> $rsr[created_at] <br> <b>UHID :</b> $rsr[patientid] <br><b>Patient Name</b> $rp[patientname]<br> <b>Type of visit :</b> $rsr[typevisit]<br> <b>Department :</b> $rsr[casetype]<br> <b>Reason of visit :</b> $rRFA[Reason_for_Admission]<br> </td> <td>"; echo "$rs[status] "; if($RowScreen[status]=='1'){ echo "<i class='fa fa-check-square-o' aria-hidden='true' style='color:green;'></i>"; }else{ echo "<i class='fa fa-times' aria-hidden='true' style='color:red;'></i>"; } echo "</a></td> </tr> "; } } }} } ?> </table> </div> </div> <html> <head> <title>Select only one checkbox at time</title> <script src="http://cdnjs.cloudflare.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script> </head> <body> </body> </html> <script> $(document).ready(function(){ $('.openPopup').on('click',function(){ var dataURL = $(this).attr('data-href'); $('.modal-body').load(dataURL,function(){ $('#myModal').modal({show:true}); }); }); }); </script> <script src="https://code.jquery.com/jquery-3.5.1.js"></script> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/js/bootstrap.bundle.min.js"></script>