Server IP : 162.240.98.243 / Your IP : 18.226.4.191 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("../dbconnection.php"); require_once('../DBManager.php'); require_once('../LoginManager.php'); $DisplayForm=True; $sql= "SELECT * FROM patient_invace WHERE prescriptionid='$_GET[prescriptionid]' AND discription='Admission_fees' AND status='Paid'"; $qsql = mysqli_query($con,$sql); if($rh = mysqli_fetch_array($qsql)) { $DisplayForm=False; echo "<script>window.location='Print_HospitalCourseFinalPay.php?prescriptionid=$rh[prescriptionid]&patientid=$_GET[patientid]'</script>"; } if($DisplayForm) { ?> <?php include("dbconnection.php"); require_once('../DBManager.php'); require_once('../patientmanager.php'); include("header.php"); include("dashboarddocument.php"); if(isset($_POST['signup'])) { $count=count($_POST["invaceid2"]); for($i=0;$i<$count;$i++){ $sql="UPDATE patient_invace SET discount='" . $_POST['discount'][$i] . "',grand_total='" . $_POST['priceNew'][$i] . "',paymentmode='" . $_POST['paymentmode'][$i] . "',status='" . $_POST['status'][$i] . "' WHERE invaceid='" . $_POST['invaceid2'][$i] . "'"; $qsql = mysqli_query($con,$sql); } $price= implode(",", $_POST["priceNew"]); $discription2= implode(",", $_POST["discription2"]); $updated_at=date("F d, Y / h:i:s A"); $created_at=date("F d, Y / h:i:s A"); $sql2="INSERT INTO `HospitalCourseFinalPay1`(`prescriptionid`, `patientid`, `pricetotal`, `pricedue`, `price`, `itemName`, `created_by`, `updated_by`) VALUES ('$_GET[prescriptionid]','$_GET[patientid]','$_POST[grand_total]','$_POST[discount]','$price','$discription2','$created_at','$updated_at')"; $qsql2 = mysqli_query($con,$sql2); if($qsql==1){ if($qsql2==1){ echo "<script>alert('Update successfully');</script> <script>window.location='Print_HospitalCourseFinalPay.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]'</script> </script>"; }} } ?> <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> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script> <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"> <div class='center'> <section id="memo"> <div class="logo"> <?php $narayan=LoginManager::currentUser(); $usertype=LoginManager::getUserTypeByuname("$narayan"); $sql ="SELECT * FROM site_users WHERE userno='$usertype'"; $qsql = mysqli_query($con,$sql); if($rs = mysqli_fetch_array($qsql)) { $sql ="SELECT * FROM hco WHERE adminid='$rs[entered_by]'"; $qsql = mysqli_query($con,$sql); if($rs = mysqli_fetch_array($qsql)) { $sql ="SELECT * FROM admin WHERE id='$rs[adminid]'"; $qsql = mysqli_query($con,$sql); if($ra = mysqli_fetch_array($qsql)) { echo" <img data-logo='' src='uploads/$rs[Logo]' /> </div> <div class='company-info'> <div>$ra[hsname]</div> <div> <span style='font-size:18px'>$rs[Street] | $rs[Locality]</br>$ra[EmailID] | $ra[numbers]</p></span> </div> "; } } } ?> <br> </section> <br> <?php include("dbconnection.php"); $sql ="SELECT * FROM addaspatient WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'"; $qsql = mysqli_query($con,$sql); if($rs = mysqli_fetch_array($qsql)) $sql1 ="SELECT * FROM patient WHERE patientid='$rs[patientid]'"; $qsql1 = mysqli_query($con,$sql1); if($rspi1 = mysqli_fetch_array($qsql1)) $sqlpatient = "SELECT * FROM patient_invace WHERE prescriptionid='$rs[prescriptionid]' AND patientid='$_GET[patientid]'"; $qsqlpatient = mysqli_query($con,$sqlpatient); if($rsp = mysqli_fetch_array($qsqlpatient)) $sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp[entered_by]'"; $qsqlpatient1 = mysqli_query($con,$sqlpatient1); if($rsn = mysqli_fetch_array($qsqlpatient1)) echo" <div class='checkbox'><span style='float: left; font-size:19px;'>Date : $rsp[created_at]</span><span style='float: right; font-size:19px;'>Invoice Number :<b>$rsp[invaceid]</b></span></div> <br> <div class='checkbox'><span style='float: left; font-size:19px;'>UHID : $rspi1[patientid]</span><span style='float: right; font-size:19px;'>Name :<b>$rspi1[patientname]</b></span></div> <br> <div class='checkbox'><span style='float: left; font-size:19px;'>Age: $rspi1[dob]</span><span style='float: right; font-size:19px;'>SEX :<b>$rspi1[gendor]</b></span></div> <div class='card-body'>"; ?> <table class="table table-bordered table-hover" id="myTable"> <tr> <th><strong>Date & Time <br>Towards </strong></th> <th><strong>Admission fees <br> & Status</strong></th> <th><strong>Assisted by </strong></th> </tr> <?php include("dbconnection.php"); $sql ="SELECT * FROM addaspatient WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]'"; $qsql = mysqli_query($con,$sql); while($rs = mysqli_fetch_array($qsql)) { $sqlpatient = "SELECT * FROM patient_invace WHERE prescriptionid='$rs[prescriptionid]' AND discription='Nurse Note' OR prescriptionid='$rs[prescriptionid]' AND discription='Ryles tube' OR prescriptionid='$rs[prescriptionid]' AND discription='FFP Transfusion' OR prescriptionid='$rs[prescriptionid]' AND discription='Electrotherapy laser' OR prescriptionid='$rs[prescriptionid]' AND discription='Electrotherapy' OR prescriptionid='$rs[prescriptionid]' AND discription='csf' OR prescriptionid='$rs[prescriptionid]' AND discription='IVP' OR prescriptionid='$rs[prescriptionid]' AND discription='Ventilator' OR prescriptionid='$rs[prescriptionid]' AND discription='Nebulization' OR prescriptionid='$rs[prescriptionid]' AND discription='BIPAP' OR prescriptionid='$rs[prescriptionid]' AND discription='Admission_fees' OR prescriptionid='$rs[prescriptionid]' AND discription='Oxygen' AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='Catheterization' AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='Physiotherapy' AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='Dietician' AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='Tranfusion' AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='Dialysis' AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='Dressing Small' AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='Dressing Medium' AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='Dressing Large' AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='Suction' AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='BI-PAP' AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='CPAP' AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='Echo Charges' AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='ECT' AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='Intubation' AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='PAC' AND pricetotal!='0' OR prescriptionid='$rs[prescriptionid]' AND discription='RBS Records' AND pricetotal!='0'"; $qsqlpatient = mysqli_query($con,$sqlpatient); while($rsp = mysqli_fetch_array($qsqlpatient)) { $sqlpatient1 = "SELECT * FROM site_users WHERE userno='$rsp[entered_by]'"; $qsqlpatient1 = mysqli_query($con,$sqlpatient1); while($rsn = mysqli_fetch_array($qsqlpatient1)) { echo " <form name='signup' method='post'> <tbody> <tr> <td> $rsp[created_at] <br>$rsp[discription] <input type='hidden' name='invaceid2[]' value='$rsp[invaceid]'> <input type='hidden' name=' discription2[]' value='$rsp[discription]'> <input type='hidden' name='prescriptionid[]' value='$_GET[prescriptionid]'> <input type='hidden' name='patientid[]' value='$_GET[patientid]'> <input type='hidden' name='status[]' value='Paid'><br> "; ?> <?php include('master_hospital_Course_durtion.php'); ?> <?php echo " <input type='hidden' value='$h' class='Hours' name='Hours[]' id='Hours'> "; echo "<input class='' id='' name='priceNew[]' type='hidden' value='$z'/>"; echo "</td> <td> $z <br> <input class='price2' id='price2' name='price[]' type='hidden' value='$z'/> "; $usertype=$rsp['status']; if($usertype == 'Paid'){ echo "Paid <input class='price3' id='price3' name='price[]' type='hidden' value='$z'/>"; } else{ echo "Due <b>$z</b> <input class='price1' id='price1' name='price[]' type='hidden' value='$z'/> "; }echo "</td> <td> $rsn[name]</td> </tr> "; } } } ?> <tr><td colspan='3'> <?php $sqlpatient2 = "SELECT * FROM patient_invace WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]'"; $qsqlpatient2 = mysqli_query($con,$sqlpatient2); if($rsn2 = mysqli_fetch_array($qsqlpatient2)) { ?> <div class='checkbox'><span style='float: right; font-size:19px;'>Total Amount : <i class='fa fa-inr'></i> <b> <span style='float: right; font-size:19px;' align='right' id='result'></span></b></span> </div><br> <div class='checkbox'><span style='float: right; font-size:19px;'>Due Amount : <i class='fa fa-inr'></i> <b> <span style='float: right; font-size:19px;' align='right' id='val1'></span></b></span> </div><br> <div class='checkbox'><span style='float: right; font-size:19px;'>Paid Amount : <i class='fa fa-inr'></i> <b> <span style='float: right; font-size:19px;' align='right' id='val3'></span></b></span> </div> <br> <input type='hidden' id='cBalance' value=''> <div class='checkbox'> <span style='float: right; font-size:19px;'>Discount % :<input type='number' name='discount[]' id='chDiscount' size='2'> </span></div> <br> <br> <div class='checkbox'><span style='float: right; font-size:19px;'>Grand Total : <input type='text' value='' name='grand_total' size='2' id='result2' required></span></div> <BR><BR> <div class='checkbox'><span style='float: right; font-size:19px;'>Payment Mode : <select name='paymentmode[]'> <option value='Cash'>Cash</option> <option value='Card'>Card</option> <option value='UPI'>UPI</option> </select></span></div> <input type='submit' name='signup' value='Pay' class='btn btn-info' > </form> <?php } ?> <br> </td></tr> </table> <br> </div> <script> $(document).on("change keyup blur", "#chDiscount", function() { var main = $('#cBalance').val(); var disc = $('#chDiscount').val(); var dec = (disc / 100).toFixed(2); //its convert 10 into 0.10 var mult = main * dec; // gives the value for subtract from main value var discont = main - mult; $('#result2').val(discont); }); var table = document.getElementById("myTable"), sumVal2 = 0, sumVal1 = 0, sumVal3 = 0; $(".price2").each(function() { sumVal2 += Number($(this).val()); }); document.getElementById("result").innerHTML = "" + sumVal2; $('#cBalance').val(sumVal2); $('#result2').val(sumVal2); console.log(sumVal2); $(".price1").each(function() { sumVal1 += Number($(this).val()); }); document.getElementById("val1").innerHTML = "" + sumVal1; console.log(sumVal1); $(".price3").each(function() { sumVal3 += Number($(this).val()); }); document.getElementById("val3").innerHTML = "" + sumVal3; console.log(sumVal3); </script> <?php } ?>