Server IP : 162.240.98.243 / Your IP : 3.22.74.160 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 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 ""; ?>