| Server IP : 162.240.98.243 / Your IP : 3.144.37.196 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/Pharmacy/ |
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='uPaid'";
$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("dashboard_pharma.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
}
?>