| Server IP : 162.240.98.243 / Your IP : 18.191.181.252 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/FO/Patient/ |
Upload File : |
<?php
if(isset($_GET['invaceid']))
{
$sql1 ="DELETE FROM patient_invace WHERE invaceid='$_GET[invaceid]'";
$qsql1=mysqli_query($con,$sql1);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>
window.history.go(-1)</script>;</script>";
}
}
$sql ="SELECT * FROM addaspatient WHERE patientid='$_GET[patientid]' AND prescriptionid='$_GET[prescriptionid]' AND typevisit='IPD'";
$qsql = mysqli_query($con,$sql);
if($rs = mysqli_fetch_array($qsql))
$sqlpatient = "SELECT * FROM `request_for_admission` WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]'";
$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))
$ward=$con->query("SELECT * FROM `ward` where wardid='$rsp[Ward]'"); $RowWard=$ward->fetch_assoc();
if($rsp['pagetype']=='Request for Admission'){
$type="Admission";
}
$PatientInvoice=$con->query("SELECT * FROM patient_invace WHERE prescriptionid='$rs[prescriptionid]' AND discription='Admission_fees' AND pricetotal!='0'");
$RowInvoice=$PatientInvoice->fetch_assoc();
$z=$rsp['rate'];
echo " <tr>
<td>
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$_GET[prescriptionid]' />
<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]' />
$rsp[created_at] </td>
<td> <b>$type </b>
<input class='type' id='type' name='type' type='hidden' value='$type'/>
<br> ($RowWard[ward_type])
<input class='ward_type' id='ward_type' name='ward_type' type='hidden' value='$RowWard[ward_type]'/>
</td>
<td> 1
<input class='Quantity' id='Quantity' name='Quantity' type='hidden' value='1'/>
</td>
<td> ";
echo "<b>$z</b>";
echo "</td><td>";
echo "<input class='price2' id='price2' name='price$RowInvoice[invaceid]' type='hidden' value='$z'/>
";
$usertype=$RowInvoice['status'];
if($usertype == 'Paid'){
echo "Paid <input class='price3' id='price3' name='price$RowInvoice[invaceid]' type='hidden' value='$z'/>";
echo "<input class='status' id='status' name='status' type='hidden' value='Paid'/>";
} else{
echo "Due
<input class='price1' id='price1' name='price$RowInvoice[invaceid]' type='hidden' value='$z'/>
";
echo "<input class='status' id='status' name='status' type='hidden' value='Due'/>";
}echo "</td>
<td> <a href='BillingSet.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&invaceid=$RowInvoice[invaceid]''><i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
</tr> ";
// <------------Oxygen-------------->
if(isset($_GET['OxygenId']))
{
$sql1 ="UPDATE `Oxygen` SET status='0' WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND id='$_GET[OxygenId]'";
$qsql1=mysqli_query($con,$sql1);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>
window.history.go(-1)</script>;</script>";
}
}
$sql51 ="SELECT * FROM Oxygen WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND status='1'";
$qsql51 = mysqli_query($con,$sql51);
while($rt51 = mysqli_fetch_array($qsql51)){
$ward=$con->query("SELECT * FROM `ward` where wardid='$rt51[ward_id]'"); $RowWard=$ward->fetch_assoc();
$date1 =$rt51['Oxygen_start'];
$date2 =$rt51['Oxygen_stop'];
$timestamp1 = strtotime($date1);
$timestamp2 = strtotime($date2);
$hour = abs($timestamp2 - $timestamp1)/(60*60);
$d8=round($hour);
$tarifrate =$con->query("SELECT * FROM `tarifrate` WHERE hospitalid='$rt51[entered_by]' AND tarifid='27' AND wardid='$rt51[ward_id]'");
$rs112 =$tarifrate->fetch_array();
$z=$d8*$rs112['rate'];
echo " <tr> <td>
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$_GET[prescriptionid]' />
<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]' />
$rt51[created_at] </td>
<td> <b>Oxygen
<input class='type' id='type' name='type' type='hidden' value='Oxygen'/>
</b><br> ($RowWard[ward_type])
<input class='ward_type' id='ward_type' name='ward_type' type='hidden' value='$RowWard[ward_type]'/>
</td>
<td> <b>$d8 Hours </b>
<input class='Quantity' id='Quantity' name='Quantity' type='hidden' value='$d8 Hours'/>
</td>
<td> ";
echo "<b>$z</b>";
echo "</td><td>";
echo "<input class='price2' id='price2' name='price$rsn[invaceid]' type='hidden' value='$z'/>
";
$usertype=$rsp['status'];
if($usertype == 'Paid'){
echo "Paid <input class='price3' id='price3' name='price$rsn[invaceid]' type='hidden' value='$z'/>";
echo "<input class='status' id='status' name='status' type='hidden' value='Paid'/>";
} else{
echo "Due
<input class='price1' id='price1' name='price$rsn[invaceid]' type='hidden' value='$z'/>
";
echo "<input class='status' id='status' name='status' type='hidden' value='Due'/>";
}echo "</td>
<td><section class='content-header'> <a href='BillingSet.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&OxygenId=$rt51[id]''><i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
</tr> ";
}
// <------------BIPAP-------------->
if(isset($_GET['BIPAPId']))
{
$sql1 ="UPDATE `BIPAP` SET status='0' WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND id='$_GET[BIPAPId]'";
$qsql1=mysqli_query($con,$sql1);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>
window.history.go(-1)</script>;</script>";
}
}
echo "";
$sql51 ="SELECT CONCAT(prescriptionid, ' ', patientid) AS full_name, BIPAP_start, BIPAP_stop, TIMESTAMPDIFF(HOUR, BIPAP_stop,BIPAP_start) AS hours, MOD(TIMESTAMPDIFF(MINUTE, BIPAP_stop,BIPAP_start), 60) AS minutes,created_at,prescriptionid,patientid,id,ward_id,entered_by,status FROM BIPAP WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND status='1'";
$qsql51 = mysqli_query($con,$sql51);
while($rt51 = mysqli_fetch_array($qsql51)){
$ward=$con->query("SELECT * FROM `ward` where wardid='$rt51[ward_id]'"); $RowWard=$ward->fetch_assoc();
$duration= $rt51['hours'];
$date1 =$rt51['BIPAP_start'];
$date2 =$rt51['BIPAP_stop'];
$timestamp1 = strtotime($date1);
$timestamp2 = strtotime($date2);
$hour = abs($timestamp2 - $timestamp1)/(60*60);
$d8=round($hour);
$tarifrate =$con->query("SELECT * FROM `tarifrate` WHERE hospitalid='$rt51[entered_by]' AND tarifid='7' AND wardid='$rt51[ward_id]'");
$rs112 =$tarifrate->fetch_array();
$z=$d8*$rs112['rate'];
echo " <tr> <td>
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$_GET[prescriptionid]' />
<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]' />
$rt51[created_at] </td>
<td> <b>BIPAP
<input class='type' id='type' name='type' type='hidden' value='BIPAP'/>
</b><br> ($RowWard[ward_type])
<input class='ward_type' id='ward_type' name='ward_type' type='hidden' value='$RowWard[ward_type]'/>
</td>
<td> <b>$d8 Hours </b>
<input class='Quantity' id='Quantity' name='Quantity' type='hidden' value='$d8 Hours'/>
</td>
<td> ";
echo "<b>$z</b>";
echo "</td><td>";
echo "<input class='price2' id='price2' name='price$rsn[invaceid]' type='hidden' value='$z'/>
";
$usertype=$rsp['status'];
if($usertype == 'Paid'){
echo "Paid <input class='price3' id='price3' name='price$rsn[invaceid]' type='hidden' value='$z'/>";
echo "<input class='status' id='status' name='status' type='hidden' value='Paid'/>";
} else{
echo "Due
<input class='price1' id='price1' name='price$rsn[invaceid]' type='hidden' value='$z'/>
";
echo "<input class='status' id='status' name='status' type='hidden' value='Due'/>";
}echo "</td>
<td><section class='content-header'> <a href='BillingSet.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&BIPAPId=$rt51[id]''><i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
</tr> ";
}
echo "";
//<------------------Ventilator---------------------->
if(isset($_GET['VentilatorId']))
{
$sql1 ="UPDATE `Ventilator` SET status='0' WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND id='$_GET[VentilatorId]'";
$qsql1=mysqli_query($con,$sql1);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>
window.history.go(-1)</script>;</script>";
}
}
echo "";
$sql51 ="SELECT CONCAT(prescriptionid, ' ', patientid) AS full_name, Ventilator_start, Ventilator_stop, TIMESTAMPDIFF(HOUR, Ventilator_stop, Ventilator_start) AS hours, MOD(TIMESTAMPDIFF(MINUTE, Ventilator_stop, Ventilator_start), 60) AS minutes,created_at,prescriptionid,patientid,id,ward_id,entered_by,status FROM Ventilator WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND status='1'";
$qsql51 = mysqli_query($con,$sql51);
while($rt51 = mysqli_fetch_array($qsql51)){
$ward=$con->query("SELECT * FROM `ward` where wardid='$rt51[ward_id]'"); $RowWard=$ward->fetch_assoc();
$duration= $rt51['hours'];
$date1 =$rt51['Ventilator_start'];
$date2 =$rt51['Ventilator_stop'];
$timestamp1 = strtotime($date1);
$timestamp2 = strtotime($date2);
$hour = abs($timestamp2 - $timestamp1)/(60*60);
$d8=round($hour);
$tarifrate =$con->query("SELECT * FROM `tarifrate` WHERE hospitalid='$rt51[entered_by]' AND tarifid='7' AND wardid='$rt51[ward_id]'");
$rs112 =$tarifrate->fetch_array();
$z=$d8*$rs112['rate'];
echo " <tr> <td>
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$_GET[prescriptionid]' />
<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]' />
$rt51[created_at] </td>
<td> <b>Ventilator
<input class='type' id='type' name='type' type='hidden' value='Ventilator'/>
</b><br> ($RowWard[ward_type])
<input class='ward_type' id='ward_type' name='ward_type' type='hidden' value='$RowWard[ward_type]'/>
</td>
<td> <b>$d8 Hours </b>
<input class='Quantity' id='Quantity' name='Quantity' type='hidden' value='$d8 Hours'/>
</td>
<td> ";
echo "<b>$z</b>";
echo "</td><td>";
echo "<input class='price2' id='price2' name='price$rsn[invaceid]' type='hidden' value='$z'/>
";
$usertype=$rsp['status'];
if($usertype == 'Paid'){
echo "Paid <input class='price3' id='price3' name='price$rsn[invaceid]' type='hidden' value='$z'/>";
echo "<input class='status' id='status' name='status' type='hidden' value='Paid'/>";
} else{
echo "Due
<input class='price1' id='price1' name='price$rsn[invaceid]' type='hidden' value='$z'/>
";
echo "<input class='status' id='status' name='status' type='hidden' value='Due'/>";
}echo "</td>
<td><section class='content-header'> <a href='BillingSet.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&VentilatorId=$rt51[id]'><i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
</tr> ";
}
echo "";
//<-------------------CPAP---------------------->
if(isset($_GET['CPAPId']))
{
$sql1 ="UPDATE `CPAP` SET status='0' WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND id='$_GET[CPAPId]'";
$qsql1=mysqli_query($con,$sql1);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>
window.history.go(-1)</script>;</script>";
}
}
echo "";
$sql51 ="SELECT CONCAT(prescriptionid, ' ', patientid) AS full_name, CPAP_start, CPAP_stop, TIMESTAMPDIFF(HOUR, CPAP_stop, CPAP_start) AS hours, MOD(TIMESTAMPDIFF(MINUTE, CPAP_stop, CPAP_start), 60) AS minutes,created_at,prescriptionid,patientid,id,ward_id,entered_by,status FROM CPAP WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND status='1'";
$qsql51 = mysqli_query($con,$sql51);
while($rt51 = mysqli_fetch_array($qsql51)){
$ward=$con->query("SELECT * FROM `ward` where wardid='$rt51[ward_id]'"); $RowWard=$ward->fetch_assoc();
$duration= $rt51['hours'];
$date1 =$rt51['CPAP_start'];
$date2 =$rt51['CPAP_stop'];
$timestamp1 = strtotime($date1);
$timestamp2 = strtotime($date2);
$hour = abs($timestamp2 - $timestamp1)/(60*60);
$d8=round($hour);
$tarifrate =$con->query("SELECT * FROM `tarifrate` WHERE hospitalid='$rt51[entered_by]' AND tarifid='7' AND wardid='$rt51[ward_id]'");
$rs112 =$tarifrate->fetch_array();
$z=$d8*$rs112['rate'];
echo " <tr> <td>
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$_GET[prescriptionid]' />
<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]' />
$rt51[created_at] </td>
<td> <b>CPAP
<input class='type' id='type' name='type' type='hidden' value='CPAP'/>
</b><br> ($RowWard[ward_type])
<input class='ward_type' id='ward_type' name='ward_type' type='hidden' value='$RowWard[ward_type]'/>
</td>
<td> <b>$d8 Hours </b>
<input class='Quantity' id='Quantity' name='Quantity' type='hidden' value='$d8 Hours'/>
</td>
<td> ";
echo "<b>$z</b>";
echo "</td><td>";
echo "<input class='price2' id='price2' name='price$rsn[invaceid]' type='hidden' value='$z'/>
";
$usertype=$rsp['status'];
if($usertype == 'Paid'){
echo "Paid <input class='price3' id='price3' name='price$rsn[invaceid]' type='hidden' value='$z'/>";
echo "<input class='status' id='status' name='status' type='hidden' value='Paid'/>";
} else{
echo "Due
<input class='price1' id='price1' name='price$rsn[invaceid]' type='hidden' value='$z'/>
";
echo "<input class='status' id='status' name='status' type='hidden' value='Due'/>";
}echo "</td>
<td><section class='content-header'> <a href='BillingSet.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&CPAPId=$rt51[id]''><i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
</tr> ";
}
echo "";
//<-------------------Record Sheet Dressing Small---------------------->
if(isset($_GET['DressingSId']))
{
$sql1 ="UPDATE `Dressing` SET status='0' WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND id='$_GET[DressingSId]'";
$qsql1=mysqli_query($con,$sql1);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>
window.history.go(-1)</script>;</script>";
}
}
echo "";
$sql51 ="SELECT * FROM Dressing WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND done='Dressing Small' AND status='1'";
$qsql51 = mysqli_query($con,$sql51);
while($rt51 = mysqli_fetch_array($qsql51)){
$ward=$con->query("SELECT * FROM `ward` where wardid='$rt51[ward_id]'"); $RowWard=$ward->fetch_assoc();
echo " <tr> <td>
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$_GET[prescriptionid]' />
<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]' />
$rt51[created_at] </td>
<td> <b>$rt51[done]
<input class='type' id='type' name='type' type='hidden' value='$rt51[done]'/>
</b><br> ($RowWard[ward_type])
<input class='ward_type' id='ward_type' name='ward_type' type='hidden' value='$RowWard[ward_type]'/>
</td>
<td> <b>1 </b>
<input class='Quantity' id='Quantity' name='Quantity' type='hidden' value='1'/>
</td>
";
echo "
<td> ";
echo "<b>$rt51[rate]</b>";
echo "</td><td>";
echo "<input class='price2' id='price2' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
$usertype=$rsp['status'];
if($usertype == 'Paid'){
echo "Paid <input class='price3' id='price3' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>";
echo "<input class='status' id='status' name='status' type='hidden' value='Paid'/>";
} else{
echo "Due
<input class='price1' id='price1' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
echo "<input class='status' id='status' name='status' type='hidden' value='Due'/>";
}echo "</td>
<td><section class='content-header'> <a href='BillingSet.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&DressingSId=$rt51[id]''><i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
</tr> ";
}
echo "";
//<-------------------Record Sheet Dressing Medium---------------------->
if(isset($_GET['DressingMId']))
{
$sql1 ="UPDATE `Dressing` SET status='0' WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND id='$_GET[DressingMId]'";
$qsql1=mysqli_query($con,$sql1);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>
window.history.go(-1)</script>;</script>";
}
}
echo "";
$sql51 ="SELECT * FROM Dressing WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND done='Dressing Medium' AND status='1'";
$qsql51 = mysqli_query($con,$sql51);
while($rt51 = mysqli_fetch_array($qsql51)){
$ward=$con->query("SELECT * FROM `ward` where wardid='$rt51[ward_id]'"); $RowWard=$ward->fetch_assoc();
echo " <tr> <td>
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$_GET[prescriptionid]' />
<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]' />
$rt51[created_at] </td>
<td> <b>$rt51[done]
<input class='type' id='type' name='type' type='hidden' value='$rt51[done]'/>
</b><br> ($RowWard[ward_type])
<input class='ward_type' id='ward_type' name='ward_type' type='hidden' value='$RowWard[ward_type]'/>
</td>
<td> <b>1 </b>
<input class='Quantity' id='Quantity' name='Quantity' type='hidden' value='1'/>
</td> ";
echo "
<td> ";
echo "<b>$rt51[rate]</b>";
echo "</td><td>";
echo "<input class='price2' id='price2' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
$usertype=$rsp['status'];
if($usertype == 'Paid'){
echo "Paid <input class='price3' id='price3' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>";
echo "<input class='status' id='status' name='status' type='hidden' value='Paid'/>";
} else{
echo "Due
<input class='price1' id='price1' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
echo "<input class='status' id='status' name='status' type='hidden' value='Due'/>";
}echo "</td>
<td><section class='content-header'> <a href='BillingSet.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&DressingMId=$rt51[id]''><i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
</tr> ";
}
echo "";
//<-------------------Record Sheet Dressing Large---------------------->
if(isset($_GET['DressingLId']))
{
$sql1 ="UPDATE `Dressing` SET status='0' WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND id='$_GET[DressingLId]'";
$qsql1=mysqli_query($con,$sql1);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>
window.history.go(-1)</script>;</script>";
}
}
echo "";
$sql51 ="SELECT * FROM Dressing WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND done='Dressing Large' AND status='1'";
$qsql51 = mysqli_query($con,$sql51);
while($rt51 = mysqli_fetch_array($qsql51)){
$ward=$con->query("SELECT * FROM `ward` where wardid='$rt51[ward_id]'"); $RowWard=$ward->fetch_assoc();
echo " <tr> <td>
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$_GET[prescriptionid]' />
<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]' />
$rt51[created_at] </td>
<td> <b>$rt51[done]
<input class='type' id='type' name='type' type='hidden' value='$rt51[done]'/>
</b><br> ($RowWard[ward_type])
<input class='ward_type' id='ward_type' name='ward_type' type='hidden' value='$RowWard[ward_type]'/>
</td>
<td> <b>1 </b>
<input class='Quantity' id='Quantity' name='Quantity' type='hidden' value='1'/>
</td> ";
echo "
<td> ";
echo "<b>$rt51[rate]</b>";
echo "</td><td>";
echo "<input class='price2' id='price2' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
$usertype=$rsp['status'];
if($usertype == 'Paid'){
echo "Paid <input class='price3' id='price3' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>";
echo "<input class='status' id='status' name='status' type='hidden' value='Paid'/>";
} else{
echo "Due
<input class='price1' id='price1' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
echo "<input class='status' id='status' name='status' type='hidden' value='Due'/>";
}echo "</td>
<td><section class='content-header'> <a href='BillingSet.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&DressingLId=$rt51[id]''><i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
</tr> ";
}
echo "";
//<-------------------Record Sheet Catheterization---------------------->
if(isset($_GET['CatheterizationId']))
{
$sql1 ="UPDATE `Catheterization` SET status='0' WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND id='$_GET[CatheterizationId]'";
$qsql1=mysqli_query($con,$sql1);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>
window.history.go(-1)</script>;</script>";
}
}
echo "";
$sql51 ="SELECT * FROM Catheterization WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND Catheterization='Done' AND status='1'";
$qsql51 = mysqli_query($con,$sql51);
while($rt51 = mysqli_fetch_array($qsql51)){
$ward=$con->query("SELECT * FROM `ward` where wardid='$rt51[ward_id]'"); $RowWard=$ward->fetch_assoc();
echo " <tr> <td>
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$_GET[prescriptionid]' />
<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]' />
$rt51[created_at] </td>
<td> <b>Catheterization
<input class='type' id='type' name='type' type='hidden' value='Catheterization'/>
</b><br> ($RowWard[ward_type])
<input class='ward_type' id='ward_type' name='ward_type' type='hidden' value='$RowWard[ward_type]'/>
</td>
<td> <b>1 </b>
<input class='Quantity' id='Quantity' name='Quantity' type='hidden' value='1'/>
</td> ";
echo "
<td> ";
echo "<b>$rt51[rate]</b>";
echo "</td><td>";
echo "<input class='price2' id='price2' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
$usertype=$rsp['status'];
if($usertype == 'Paid'){
echo "Paid <input class='price3' id='price3' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>";
echo "<input class='status' id='status' name='status' type='hidden' value='Paid'/>";
} else{
echo "Due
<input class='price1' id='price1' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
echo "<input class='status' id='status' name='status' type='hidden' value='Due'/>";
}echo "</td>
<td><section class='content-header'> <a href='BillingSet.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&CatheterizationId=$rt51[id]''><i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
</tr> ";
}
echo "";
//<-------------------Record Sheet Suction---------------------->
if(isset($_GET['SuctionId']))
{
$sql1 ="UPDATE `Suction` SET status='0' WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND id='$_GET[SuctionId]'";
$qsql1=mysqli_query($con,$sql1);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>
window.history.go(-1)</script>;</script>";
}
}
echo "";
$sql51 ="SELECT * FROM Suction WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND Suction='Done' AND status='1'";
$qsql51 = mysqli_query($con,$sql51);
while($rt51 = mysqli_fetch_array($qsql51)){
$ward=$con->query("SELECT * FROM `ward` where wardid='$rt51[ward_id]'"); $RowWard=$ward->fetch_assoc();
echo " <tr> <td>
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$_GET[prescriptionid]' />
<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]' />
$rt51[created_at] </td>
<td> <b>Suction
<input class='type' id='type' name='type' type='hidden' value='Suction'/>
</b><br> ($RowWard[ward_type])
<input class='ward_type' id='ward_type' name='ward_type' type='hidden' value='$RowWard[ward_type]'/>
</td>
<td> <b>1 </b>
<input class='Quantity' id='Quantity' name='Quantity' type='hidden' value='1'/>
</td>";
echo "
<td> ";
echo "<b>$rt51[rate]</b>";
echo "</td><td>";
echo "<input class='price2' id='price2' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
$usertype=$rsp['status'];
if($usertype == 'Paid'){
echo "Paid <input class='price3' id='price3' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>";
echo "<input class='status' id='status' name='status' type='hidden' value='Paid'/>";
} else{
echo "Due
<input class='price1' id='price1' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
echo "<input class='status' id='status' name='status' type='hidden' value='Due'/>";
}echo "</td>
<td><section class='content-header'> <a href='BillingSet.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&SuctionId=$rt51[id]''><i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
</tr> ";
}
echo "";
//<-------------------Record Sheet Nebulization---------------------->
if(isset($_GET['NebulizationId']))
{
$sql1 ="UPDATE `Nebulization` SET status='0' WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND id='$_GET[NebulizationId]'";
$qsql1=mysqli_query($con,$sql1);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>
window.history.go(-1)</script>;</script>";
}
}
echo "";
$sql51 ="SELECT * FROM Nebulization WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND Nebulization_done='Done' AND status='1'";
$qsql51 = mysqli_query($con,$sql51);
while($rt51 = mysqli_fetch_array($qsql51)){
$ward=$con->query("SELECT * FROM `ward` where wardid='$rt51[ward_id]'"); $RowWard=$ward->fetch_assoc();
echo " <tr> <td>
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$_GET[prescriptionid]' />
<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]' />
$rt51[created_at] </td>
<td> <b>Nebulization
<input class='type' id='type' name='type' type='hidden' value='Nebulization'/>
</b><br> ($RowWard[ward_type])
<input class='ward_type' id='ward_type' name='ward_type' type='hidden' value='$RowWard[ward_type]'/>
</td>
<td> <b>1 </b>
<input class='Quantity' id='Quantity' name='Quantity' type='hidden' value='1'/>
</td>";
echo "</b></td>
<td> ";
echo "<b>$rt51[rate]</b>";
echo "</td><td>";
echo "<input class='price2' id='price2' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
$usertype=$rsp['status'];
if($usertype == 'Paid'){
echo "Paid <input class='price3' id='price3' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>";
echo "<input class='status' id='status' name='status' type='hidden' value='Paid'/>";
} else{
echo "Due
<input class='price1' id='price1' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
echo "<input class='status' id='status' name='status' type='hidden' value='Due'/>";
}echo "</td>
<td><section class='content-header'> <a href='BillingSet.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&NebulizationId=$rt51[id]''><i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
</tr> ";
}
echo "";
//<-------------------Record Sheet Intubation---------------------->
if(isset($_GET['IntubationId']))
{
$sql1 ="UPDATE `Intubation` SET status='0' WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND id='$_GET[IntubationId]'";
$qsql1=mysqli_query($con,$sql1);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>
window.history.go(-1)</script>;</script>";
}
}
echo "";
$sql51 ="SELECT * FROM Intubation WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND Intubation='Done' AND status='1'";
$qsql51 = mysqli_query($con,$sql51);
while($rt51 = mysqli_fetch_array($qsql51)){
$ward=$con->query("SELECT * FROM `ward` where wardid='$rt51[ward_id]'"); $RowWard=$ward->fetch_assoc();
echo " <tr> <td>
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$_GET[prescriptionid]' />
<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]' />
$rt51[created_at] </td>
<td> <b>Intubation
<input class='type' id='type' name='type' type='hidden' value='Intubation'/>
</b><br> ($RowWard[ward_type])
<input class='ward_type' id='ward_type' name='ward_type' type='hidden' value='$RowWard[ward_type]'/>
</td>
<td> <b>1 </b>
<input class='Quantity' id='Quantity' name='Quantity' type='hidden' value='1'/>
</td>";
echo "
<td> ";
echo "<b>$rt51[rate]</b>";
echo "</td><td>";
echo "<input class='price2' id='price2' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
$usertype=$rsp['status'];
if($usertype == 'Paid'){
echo "Paid <input class='price3' id='price3' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>";
echo "<input class='status' id='status' name='status' type='hidden' value='Paid'/>";
} else{
echo "Due
<input class='price1' id='price1' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
echo "<input class='status' id='status' name='status' type='hidden' value='Due'/>";
}echo "</td>
<td><section class='content-header'> <a href='BillingSet.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&IntubationId=$rt51[id]''><i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
</tr> ";
}
echo "";
//<-------------------Record Sheet ivpcentralline---------------------->
if(isset($_GET['ivpcentrallineId']))
{
$sql1 ="UPDATE `ivpcentralline` SET status='0' WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND id='$_GET[ivpcentrallineId]'";
$qsql1=mysqli_query($con,$sql1);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>
window.history.go(-1)</script>;</script>";
}
}
echo "";
$sql51 ="SELECT * FROM ivpcentralline WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND ivp_done='Done' AND status='1'";
$qsql51 = mysqli_query($con,$sql51);
while($rt51 = mysqli_fetch_array($qsql51)){
$ward=$con->query("SELECT * FROM `ward` where wardid='$rt51[ward_id]'"); $RowWard=$ward->fetch_assoc();
echo " <tr> <td>
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$_GET[prescriptionid]' />
<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]' />
$rt51[created_at] </td>
<td> <b>ivpcentralline
<input class='type' id='type' name='type' type='hidden' value='ivpcentralline'/>
</b><br> ($RowWard[ward_type])
<input class='ward_type' id='ward_type' name='ward_type' type='hidden' value='$RowWard[ward_type]'/>
</td>
<td> <b>1 </b>
<input class='Quantity' id='Quantity' name='Quantity' type='hidden' value='1'/>
</td>";
echo "
<td> ";
echo "<b>$rt51[rate]</b>";
echo "</td><td>";
echo "<input class='price2' id='price2' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
$usertype=$rsp['status'];
if($usertype == 'Paid'){
echo "Paid <input class='price3' id='price3' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>";
echo "<input class='status' id='status' name='status' type='hidden' value='Paid'/>";
} else{
echo "Due
<input class='price1' id='price1' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
echo "<input class='status' id='status' name='status' type='hidden' value='Due'/>";
}echo "</td>
<td><section class='content-header'> <a href='BillingSet.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&ivpcentrallineId=$rt51[id]''><i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
</tr> ";
}
echo "";
//<-------------------Record Sheet Ryles_tube---------------------->
if(isset($_GET['Ryles_tubeId']))
{
$sql1 ="UPDATE `Ryles_tube` SET status='0' WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND id='$_GET[Ryles_tubeId]'";
$qsql1=mysqli_query($con,$sql1);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>
window.history.go(-1)</script>;</script>";
}
}
echo "";
$sql51 ="SELECT * FROM Ryles_tube WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND Ryles_tube='Done' AND status='1'";
$qsql51 = mysqli_query($con,$sql51);
while($rt51 = mysqli_fetch_array($qsql51)){
$ward=$con->query("SELECT * FROM `ward` where wardid='$rt51[ward_id]'"); $RowWard=$ward->fetch_assoc();
echo " <tr> <td>
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$_GET[prescriptionid]' />
<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]' />
$rt51[created_at] </td>
<td> <b>Ryles_tube
<input class='type' id='type' name='type' type='hidden' value='Ryles_tube'/>
</b><br> ($RowWard[ward_type])
<input class='ward_type' id='ward_type' name='ward_type' type='hidden' value='$RowWard[ward_type]'/>
</td>
<td> <b>1 </b>
<input class='Quantity' id='Quantity' name='Quantity' type='hidden' value='1'/>
</td>";
echo "
<td> ";
echo "<b>$rt51[rate]</b>";
echo "</td><td>";
echo "<input class='price2' id='price2' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
$usertype=$rsp['status'];
if($usertype == 'Paid'){
echo "Paid <input class='price3' id='price3' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>";
echo "<input class='status' id='status' name='status' type='hidden' value='Paid'/>";
} else{
echo "Due
<input class='price1' id='price1' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
echo "<input class='status' id='status' name='status' type='hidden' value='Due'/>";
}echo "</td>
<td><section class='content-header'> <a href='BillingSet.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&Ryles_tubeId=$rt51[id]''><i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
</tr> ";
}
echo "";
//<-------------------Record Sheet blood transfusion---------------------->
if(isset($_GET['bloodId']))
{
$sql1 ="UPDATE `bloodtransfusion` SET status='0' WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND id='$_GET[bloodId]'";
$qsql1=mysqli_query($con,$sql1);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>
window.history.go(-1)</script>;</script>";
}
}
echo "";
$sql51 ="SELECT * FROM bloodtransfusion WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND Diagnosis='Diagnosis' AND status='1'";
$qsql51 = mysqli_query($con,$sql51);
while($rt51 = mysqli_fetch_array($qsql51)){
$ward=$con->query("SELECT * FROM `ward` where wardid='$rt51[ward_id]'"); $RowWard=$ward->fetch_assoc();
echo " <tr> <td>
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$_GET[prescriptionid]' />
<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]' />
$rt51[created_at] </td>
<td> <b>Blood Transfusion
<input class='type' id='type' name='type' type='hidden' value='Blood Transfusion'/>
</b><br> ($RowWard[ward_type])
<input class='ward_type' id='ward_type' name='ward_type' type='hidden' value='$RowWard[ward_type]'/>
</td>
<td> <b>1 </b>
<input class='Quantity' id='Quantity' name='Quantity' type='hidden' value='1'/>
</td>";
echo "
<td> ";
echo "<b>$rt51[rate]</b>";
echo "</td><td>";
echo "<input class='price2' id='price2' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
$usertype=$rsp['status'];
if($usertype == 'Paid'){
echo "Paid <input class='price3' id='price3' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>";
echo "<input class='status' id='status' name='status' type='hidden' value='Paid'/>";
} else{
echo "Due
<input class='price1' id='price1' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
echo "<input class='status' id='status' name='status' type='hidden' value='Due'/>";
}echo "</td>
<td><section class='content-header'> <a href='BillingSet.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&bloodId=$rt51[id]''><i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
</tr> ";
}
echo "";
//<-------------------Record Sheet FFPTransfusion---------------------->
if(isset($_GET['FFPTransfusionId']))
{
$sql1 ="UPDATE `FFPTransfusion` SET status='0' WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND id='$_GET[FFPTransfusionId]'";
$qsql1=mysqli_query($con,$sql1);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>
window.history.go(-1)</script>;</script>";
}
}
echo "";
$sql51 ="SELECT * FROM FFPTransfusion WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND FFPTransfusion='Done' AND status='1'";
$qsql51 = mysqli_query($con,$sql51);
while($rt51 = mysqli_fetch_array($qsql51)){
$ward=$con->query("SELECT * FROM `ward` where wardid='$rt51[ward_id]'"); $RowWard=$ward->fetch_assoc();
echo " <tr> <td>
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$_GET[prescriptionid]' />
<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]' />
$rt51[created_at] </td>
<td> <b>FFP Transfusion
<input class='type' id='type' name='type' type='hidden' value='FFP Transfusion'/>
</b><br> ($RowWard[ward_type])
<input class='ward_type' id='ward_type' name='ward_type' type='hidden' value='$RowWard[ward_type]'/>
</td>
<td> <b>1 </b>
<input class='Quantity' id='Quantity' name='Quantity' type='hidden' value='1'/>
</td>";
echo "
<td> ";
echo "<b>$rt51[rate]</b>";
echo "</td><td>";
echo "<input class='price2' id='price2' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
$usertype=$rsp['status'];
if($usertype == 'Paid'){
echo "Paid <input class='price3' id='price3' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>";
echo "<input class='status' id='status' name='status' type='hidden' value='Paid'/>";
} else{
echo "Due
<input class='price1' id='price1' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
echo "<input class='status' id='status' name='status' type='hidden' value='Due'/>";
}echo "</td>
<td><section class='content-header'> <a href='BillingSet.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&FFPTransfusionId=$rt51[id]''><i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
</tr> ";
}
echo "";
//<-------------------Record Sheet Dialysisnurse---------------------->
if(isset($_GET['DialysisId']))
{
$sql1 ="UPDATE `Dialysis` SET status='0' WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND id='$_GET[DialysisId]'";
$qsql1=mysqli_query($con,$sql1);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>
window.history.go(-1)</script>;</script>";
}
}
echo "";
$sql51 ="SELECT * FROM Dialysis WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND status='1'";
$qsql51 = mysqli_query($con,$sql51);
while($rt51 = mysqli_fetch_array($qsql51)){
$ward=$con->query("SELECT * FROM `ward` where wardid='$rt51[ward_id]'"); $RowWard=$ward->fetch_assoc();
echo " <tr> <td>
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$_GET[prescriptionid]' />
<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]' />
$rt51[created_at] </td>
<td> <b>Dialysis
<input class='type' id='type' name='type' type='hidden' value='Dialysis'/>
</b><br> ($RowWard[ward_type])
<input class='ward_type' id='ward_type' name='ward_type' type='hidden' value='$RowWard[ward_type]'/>
</td>
<td> <b>1 </b>
<input class='Quantity' id='Quantity' name='Quantity' type='hidden' value='1'/>
</td>";
echo "
<td> ";
echo "<b>$rt51[rate]</b>";
echo "</td><td>";
echo "<input class='price2' id='price2' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
$usertype=$rsp['status'];
if($usertype == 'Paid'){
echo "Paid <input class='price3' id='price3' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>";
echo "<input class='status' id='status' name='status' type='hidden' value='Paid'/>";
} else{
echo "Due
<input class='price1' id='price1' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
echo "<input class='status' id='status' name='status' type='hidden' value='Due'/>";
}echo "</td>
<td><section class='content-header'> <a href='BillingSet.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&DialysisId=$rt51[id]''><i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
</tr> ";
}
echo "";
//<-------------------Record Sheet ect---------------------->
if(isset($_GET['ectId']))
{
$sql1 ="UPDATE `ect` SET status='0' WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND id='$_GET[ectId]'";
$qsql1=mysqli_query($con,$sql1);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>
window.history.go(-1)</script>;</script>";
}
}
echo "";
$sql51 ="SELECT * FROM ect WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND ect='Done' AND status='1'";
$qsql51 = mysqli_query($con,$sql51);
while($rt51 = mysqli_fetch_array($qsql51)){
$ward=$con->query("SELECT * FROM `ward` where wardid='$rt51[ward_id]'"); $RowWard=$ward->fetch_assoc();
echo " <tr> <td>
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$_GET[prescriptionid]' />
<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]' />
$rt51[created_at] </td>
<td> <b>ETC
<input class='type' id='type' name='type' type='hidden' value='ETC'/>
</b><br> ($RowWard[ward_type])
<input class='ward_type' id='ward_type' name='ward_type' type='hidden' value='$RowWard[ward_type]'/>
</td>
<td> <b>1 </b>
<input class='Quantity' id='Quantity' name='Quantity' type='hidden' value='1'/>
</td>";
echo "
<td> ";
echo "<b>$rt51[rate]</b>";
echo "</td><td>";
echo "<input class='price2' id='price2' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
$usertype=$rsp['status'];
if($usertype == 'Paid'){
echo "Paid <input class='price3' id='price3' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>";
echo "<input class='status' id='status' name='status' type='hidden' value='Paid'/>";
} else{
echo "Due
<input class='price1' id='price1' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
echo "<input class='status' id='status' name='status' type='hidden' value='Due'/>";
}echo "</td>
<td><section class='content-header'> <a href='BillingSet.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&ectId=$rt51[id]''><i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
</tr> ";
}
echo "";
//<-------------------Record Sheet Electrotherapy---------------------->
if(isset($_GET['ElectrotherapyId']))
{
$sql1 ="UPDATE `Electrotherapy` SET status='0' WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND id='$_GET[ElectrotherapyId]'";
$qsql1=mysqli_query($con,$sql1);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>
window.history.go(-1)</script>;</script>";
}
}
echo "";
$sql51 ="SELECT * FROM Electrotherapy WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND Electrotherapy='Done' AND status='1'";
$qsql51 = mysqli_query($con,$sql51);
while($rt51 = mysqli_fetch_array($qsql51)){
$ward=$con->query("SELECT * FROM `ward` where wardid='$rt51[ward_id]'"); $RowWard=$ward->fetch_assoc();
echo " <tr> <td>
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$_GET[prescriptionid]' />
<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]' />
$rt51[created_at] </td>
<td> <b>Electrotherapy
<input class='type' id='type' name='type' type='hidden' value='Electrotherapy'/>
</b><br> ($RowWard[ward_type])
<input class='ward_type' id='ward_type' name='ward_type' type='hidden' value='$RowWard[ward_type]'/>
</td>
<td> <b>1 </b>
<input class='Quantity' id='Quantity' name='Quantity' type='hidden' value='1'/>
</td>";
echo "
<td> ";
echo "<b>$rt51[rate]</b>";
echo "</td><td>";
echo "<input class='price2' id='price2' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
$usertype=$rsp['status'];
if($usertype == 'Paid'){
echo "Paid <input class='price3' id='price3' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>";
echo "<input class='status' id='status' name='status' type='hidden' value='Paid'/>";
} else{
echo "Due
<input class='price1' id='price1' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
echo "<input class='status' id='status' name='status' type='hidden' value='Due'/>";
}echo "</td>
<td><section class='content-header'> <a href='BillingSet.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&ElectrotherapyId=$rt51[id]''><i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
</tr> ";
}
echo "";
//<-------------------Record Sheet Electrotherapylaser---------------------->
if(isset($_GET['ElectrotherapylaserId']))
{
$sql1 ="UPDATE `Electrotherapylaser` SET status='0' WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND id='$_GET[ElectrotherapylaserId]'";
$qsql1=mysqli_query($con,$sql1);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>
window.history.go(-1)</script>;</script>";
}
}
echo "";
$sql51 ="SELECT * FROM Electrotherapylaser WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND Electrotherapylaser='Done' AND status='1'";
$qsql51 = mysqli_query($con,$sql51);
while($rt51 = mysqli_fetch_array($qsql51)){
$ward=$con->query("SELECT * FROM `ward` where wardid='$rt51[ward_id]'"); $RowWard=$ward->fetch_assoc();
echo " <tr> <td>
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$_GET[prescriptionid]' />
<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]' />
$rt51[created_at] </td>
<td> <b>Electro Therapy Laser
<input class='type' id='type' name='type' type='hidden' value='Electro Therapy Laser'/>
</b><br> ($RowWard[ward_type])
<input class='ward_type' id='ward_type' name='ward_type' type='hidden' value='$RowWard[ward_type]'/>
</td>
<td> <b>1 </b>
<input class='Quantity' id='Quantity' name='Quantity' type='hidden' value='1'/>
</td>";
echo "</b></td>
<td> ";
echo "<b>$rt51[rate]</b>";
echo "</td><td>";
echo "<input class='price2' id='price2' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
$usertype=$rsp['status'];
if($usertype == 'Paid'){
echo "Paid <input class='price3' id='price3' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>";
} else{
echo "Due
<input class='price1' id='price1' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
}echo "</td>
<td><section class='content-header'> <a href='BillingSet.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&ElectrotherapylaserId=$rt51[id]''><i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
</tr> ";
}
echo "";
//<-------------------Record Sheet Physiotherapy---------------------->
if(isset($_GET['PhysiotherapyId']))
{
$sql1 ="UPDATE `Physiotherapy` SET status='0' WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND id='$_GET[PhysiotherapyId]'";
$qsql1=mysqli_query($con,$sql1);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>
window.history.go(-1)</script>;</script>";
}
}
echo "";
$sql51 ="SELECT * FROM Physiotherapy WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND Physiotherapy='Done' AND status='1'";
$qsql51 = mysqli_query($con,$sql51);
while($rt51 = mysqli_fetch_array($qsql51)){
$ward=$con->query("SELECT * FROM `ward` where wardid='$rt51[ward_id]'"); $RowWard=$ward->fetch_assoc();
echo " <tr> <td>
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$_GET[prescriptionid]' />
<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]' />
$rt51[created_at] </td>
<td> <b>Physiotherapy
<input class='type' id='type' name='type' type='hidden' value='Physiotherapy'/>
</b><br> ($RowWard[ward_type])
<input class='ward_type' id='ward_type' name='ward_type' type='hidden' value='$RowWard[ward_type]'/>
</td>
<td> <b>1 </b>
<input class='Quantity' id='Quantity' name='Quantity' type='hidden' value='1'/>
</td>";
echo "<td> ";
echo "<b>$rt51[rate]</b>";
echo "</td><td>";
echo "<input class='price2' id='price2' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
$usertype=$rsp['status'];
if($usertype == 'Paid'){
echo "Paid <input class='price3' id='price3' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>";
echo "<input class='status' id='status' name='status' type='hidden' value='Paid'/>";
} else{
echo "Due
<input class='price1' id='price1' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
echo "<input class='status' id='status' name='status' type='hidden' value='Due'/>";
}echo "</td>
<td><section class='content-header'> <a href='BillingSet.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&PhysiotherapyId=$rt51[id]''><i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
</tr> ";
}
echo "";
//<-------------------Record Sheet Dietician---------------------->
if(isset($_GET['DieticianId']))
{
$sql1 ="UPDATE `Dietician` SET status='0' WHERE patientid='$_GET[patientid]' AND prescriptionid='$rs[prescriptionid]' AND id='$_GET[DieticianId]'";
$qsql1=mysqli_query($con,$sql1);
if(mysqli_affected_rows($con) == 1)
{
echo "<script>alert('Deleted successfully...');</script><script>
window.history.go(-1)</script>;</script>";
}
}
echo "";
$sql51 ="SELECT * FROM Dietician WHERE prescriptionid='$_GET[prescriptionid]' AND patientid='$_GET[patientid]' AND Dietician='Done' AND status='1'";
$qsql51 = mysqli_query($con,$sql51);
while($rt51 = mysqli_fetch_array($qsql51)){
$ward=$con->query("SELECT * FROM `ward` where wardid='$rt51[ward_id]'"); $RowWard=$ward->fetch_assoc();
echo " <tr> <td>
<input type='hidden' name='prescriptionid' id='prescriptionid' value='$_GET[prescriptionid]' />
<input type='hidden' name='patientid' id='patientid' value='$_GET[patientid]' />
$rt51[created_at] </td>
<td> <b>Dietician
<input class='type' id='type' name='type' type='hidden' value='Dietician'/>
</b><br> ($RowWard[ward_type])
<input class='ward_type' id='ward_type' name='ward_type' type='hidden' value='$RowWard[ward_type]'/>
</td>
<td> <b>1 </b>
<input class='Quantity' id='Quantity' name='Quantity' type='hidden' value='1'/>
</td>";
echo "</b></td>
<td> ";
echo "<b>$rt51[rate]</b>";
echo "</td><td>";
echo "<input class='price2' id='price2' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
$usertype=$rsp['status'];
if($usertype == 'Paid'){
echo "Paid <input class='price3' id='price3' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>";
echo "<input class='status' id='status' name='status' type='hidden' value='Paid'/>";
} else{
echo "Due
<input class='price1' id='price1' name='price$rsn[invaceid]' type='hidden' value='$rt51[rate]'/>
";
echo "<input class='status' id='status' name='status' type='hidden' value='Due'/>";
}echo "</td>
<td><section class='content-header'> <a href='BillingSet.php?prescriptionid=$_GET[prescriptionid]&patientid=$_GET[patientid]&DieticianId=$rt51[id]''><i class='fa fa-trash-o' style='font-size:20px;color:red'></i></a>
</tr> ";
}
echo "";
?>