echo "<table border=0>"; echo "<td>Address: </tD>"; echo "<tD>" . $ro->getPatientRecord_address() . "</tD>"; echo "</table>"; echo "<center>" . $ro->checkAllReturns_notification($registrationNo) . "<br>" . $ro->checkForDispense_notification($registrationNo); echo "<table border=1 cellpadding=1 cellspacing=0 rules=all>"; echo "<tr>"; echo "<th> Particular </th>"; echo "<th> Actual </th>"; echo "<th> PhilHealth </th>"; echo "<th> Company </th>"; echo "<th> Cash </th>"; echo "</tr>"; echo "<tr>"; echo "<td> <font size=3>Room</font> </td>"; if ($ro->getTotal("total", "Room And Board", $registrationNo) > 0) { echo "<td> "; echo number_format($ro->getTotal("total", "Room And Board", $registrationNo), 2); echo " </td>"; $gt += $ro->getTotal("total", "Room And Board", $registrationNo); $hospitalBill_gt += $ro->getTotal("total", "Room And Board", $registrationNo); } else { echo "<Td> </td>"; } ////////////// PHIC ROOM if ($ro->getTotal("phic", "Room And Board", $registrationNo) > 0) { echo "<td> " . number_format($ro->getTotal("phic", "Room And Board", $registrationNo), 2) . " </td>"; $phicz += $ro->getTotal("phic", "Room And Board", $registrationNo); $hospitalBill_phic += $ro->getTotal("phic", "Room And Board", $registrationNo); } else { echo "<Td> </td>";
<?php include "../../myDatabase2.php"; $registrationNo = $_GET['registrationNo']; $targetAmount = $_GET['targetAmount']; $ro = new database2(); $itemz = preg_split("/\\_/", $ro->getMaximumTotal_rBanny($registrationNo, "Room and Board")); $ro->getPatientChargesToEdit($itemz[1]); if ($ro->getTotal("cashUnpaid", "Room And Board", $registrationNo) > 0) { echo "<br><Br><br><br><br>"; echo "<font color=red>R-Banny is now Calculating Room</font><br>"; echo "Total: " . $itemz[0]; echo "<br>"; echo "Item#: " . $itemz[1]; if ($targetAmount >= $itemz[0]) { $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", "0"); $ro->editNow("patientCharges", "itemNo", $itemz[1], "Company", "0"); $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $itemz[0]); } else { //echo "<br><Br><br><br><font color=blue size=5>R-Banny is Having a trouble in Computation</font>"; $newCash = $itemz[0] - $targetAmount; $newPHIC = $ro->selectNow("patientCharges", "total", "itemNo", $itemz[1]) - $newCash; $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", $newCash); $ro->editNow("patientCharges", "itemNo", $itemz[1], "Company", "0"); $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $newPHIC); } $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/rBanny/consumedRoom.php?registrationNo={$registrationNo}&targetAmount={$targetAmount}"); } else { $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/rBanny/consumedMeds.php?registrationNo={$registrationNo}&targetAmount={$targetAmount}"); }
echo "<td> " . number_format(trim($gtWithoutPHIC + $pfTotal), 2) . "</td>"; echo "<td> </td>"; echo "</tr>"; echo "<tr>"; echo "<td> <font size=2><b>PhilHealth</b></font></td>"; echo "<td> </td>"; echo "<td> <font size=2><b>1st Case</b></font></td>"; echo "<td> <font size=2><b>2nd Case</b></font></td>"; echo "<td> </td>"; echo "<td> </td>"; echo "<td> </td>"; echo "<td> </td>"; echo "<td> </td>"; echo "</tr>"; $firstCase_hospitalBill = number_format(trim($ro->getTotal_No_pf("phic", "", $registrationNo)), 2); $firstCase_professionalFee = number_format($ro->getTotal("phic", "PROFESSIONAL FEE", $registrationNo), 2); $totalCaseRate = $ro->getTotal_No_pf("phic", "", $registrationNo) + $ro->getTotal("phic", "PROFESSIONAL FEE", $registrationNo); echo "<tr>"; echo "<td> </td>"; echo "<td> <font size=2><b>Hospital Bill</b></font></td>"; echo "<td> <font size=2>" . $firstCase_hospitalBill . "</font></td>"; echo "<td> </td>"; echo "<td> </td>"; echo "<td> </td>"; echo "<td> </td>"; echo "<td> </td>"; echo "<td> </td>"; echo "</tr>"; echo "<tr>"; echo "<td> </td>"; echo "<td> <font size=2><b>Professional Fee</b></font></td>";
<?php include "../../myDatabase2.php"; $registrationNo = $_GET['registrationNo']; $caserate = $_GET['caserate']; $ro = new database2(); $ro->coconutDesign(); echo "<Br><Br><br>"; $caseRate_amount = $ro->selectNow("rBanny_caserate", "amount", "caseNo", $caserate); //amount ng selected caserate $hospitalBill = $ro->getTotal("total", "Room And Board", $registrationNo) + $ro->getTotal("total", "MEDICINE", $registrationNo) + $ro->getTotal("total", "SUPPLIES", $registrationNo) + $ro->getTotal("total", "LABORATORY", $registrationNo) + $ro->getTotal("total", "RADIOLOGY", $registrationNo) + $ro->getTotal("total", "NURSING-CHARGES", $registrationNo) + $ro->getTotal("total", "MISCELLANEOUS", $registrationNo) + $ro->getTotal("total", "OR/DR/ER Fee", $registrationNo) + $ro->getTotal("total", "OXYGEN", $registrationNo); $pf = $ro->getTotal("phic", "PROFESSIONAL FEE", $registrationNo); $targetAmount = $caseRate_amount - $caseRate_amount * 0.3; echo "<Center>"; echo "<font color='blue' size=5><i>[R-Banny]-[noReset mode]</i></font>"; $ro->coconutBoxStart("500", "130"); echo "<br><font color=red size=4>Caserate</font>: " . $ro->selectNow("rBanny_caserate", "caserate", "caseNo", $caserate) . " [" . number_format($caseRate_amount, 2) . "]"; echo "<br>"; echo "<font color=red size=4>Hospital Bill: </font>" . number_format($hospitalBill, 2); echo "<Br>"; echo "<font color=red size=4>Professional Fee: </font>" . number_format($pf, 2); echo "<Br>"; $ro->coconutFormStart("get", "http://" . $ro->getMyUrl() . "/COCONUT/rBanny/analyzingData_noReset.php"); //$cazeRate = $ro->selectNow("availableICD","hospital","icdCode",$ro->selectNow("patientICD","icdCode","registrationNo",$registrationNo)); echo "<i><font color=blue size=4>Target Amount: </font></i><br>" . $ro->coconutTextBox_return("targetAmount", $ro->getFirstCaseRate($ro->selectNow("patientICD", "icdCode", "registrationNo", $registrationNo))); echo "<br><Br>"; //$ro->coconutHidden("targetAmount",$targetAmount); $ro->coconutHidden("cash", $ro->getTotal("cashUnpaid", "", $registrationNo)); $ro->coconutHidden("registrationNo", $registrationNo); if ($hospitalBill > $targetAmount) { $ro->coconutButton("Proceed");
if ($ro->getRegistrationDetails_room() != "OPD_OPD") { // enable room echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientChargesTitle.php?registrationNo={$registrationNo}&title=Room And Board&username={$username}&show=&desc=' target='rightFrame'><font size=2>Room</font></a></li>"; } else { //disable room echo ""; } echo "</ul>"; echo "<ul>"; /////////// LOCKED ACCOUNT KAPAG CONSUMED NA UNG LIMIT //////////////////////// if ($ro->selectNow("registrationDetails", "mgh", "registrationNo", $registrationNo) == "") { // enable charges kung hindi pa MGH if ($ro->getRegistrationDetails_type() == "OR/DR" || $ro->getRegistrationDetails_type() == "OPD") { echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/chargesCartPassword.php?registrationNo=" . $ro->getRegistrationDetails_registrationNo() . "&username={$username}&room=" . $ro->getRegistrationDetails_room() . "&batchNo={$batchNo}' target='rightFrame'><font size=2>Charges Cart</font></a></li>"; } else { $totalBalanceNow = $ro->getTotal("cashUnpaid", "", $registrationNo) - $ro->getAllPayment($registrationNo); if ($ro->getRegistrationDetails_company() != "") { //kpg may hmo if ($ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo) != "") { //meron hmo limit if ($totalBalanceNow >= $ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo)) { //mas mataas n ung total balance kaysa sa hmo limit if ($ro->selectNow("registeredUser", "module", "username", $username) == "PHARMACY" || $ro->selectNow("registeredUser", "module", "username", $username) == "CASHIER") { //kpg pharmacy or cashier pwede mag charge echo "<li>" . $ro->coconutImages_return("locked1.jpeg") . "<a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/chargesCartPassword.php?registrationNo=" . $ro->getRegistrationDetails_registrationNo() . "&username={$username}&room=" . $ro->getRegistrationDetails_room() . "&batchNo={$batchNo}' target='rightFrame'><font size=2 color=red>Charges Cart</font></a></li>"; } else { if ($ro->checkPermission($registrationNo) != "") { echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/chargesCartPassword.php?registrationNo=" . $ro->getRegistrationDetails_registrationNo() . "&username={$username}&room=" . $ro->getRegistrationDetails_room() . "&batchNo={$batchNo}' target='rightFrame'><font size=2>Charges Cart</font></a></li>"; } else { //kpg ndi pharmacy or cashier ndi pde mag charge echo $ro->coconutImages_return("locked1.jpeg") . "<font size=2 color=blue>[LOCKED ACCOUNT]</font><br><font size=2 color=red>" . $ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo) . " Limit of " . $ro->getRegistrationDetails_company() . " for this Patient is Already Consumed</font>";
$cash = $_GET['cash']; $targetAmount = $_GET['targetAmount']; $ro = new database2(); //echo ( $cash - $targetAmount ); echo "<center><br>"; $itemz = preg_split("/\\_/", $ro->getMaximumTotal_rBanny($registrationNo)); //format cashUnpaid_itemNo echo "<Br>"; echo "Item#: " . $itemz[1]; echo "<br>Price: " . $itemz[0]; echo "<br><b>Analyzing " . $ro->selectNow("patientCharges", "description", "itemNo", $itemz[1]) . "</b>"; //check kung ilan na lang ung natitira sa target amount kpg bnwsan na sa current phic ng px $pxPHIC = $ro->getCurrentPHIC_check_rBanny($registrationNo) - $targetAmount; //check kung mas mataas pa ung total ng item kaysa sa natitirang sa targetAmount if ($itemz[0] >= $pxPHIC) { $newCash = $ro->selectNow("patientCharges", "cashUnpaid", "itemNo", $itemz[1]) - ($targetAmount - $ro->getTotal("phic", "", $registrationNo)); if ($newCash > 1) { $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", $newCash); $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $targetAmount - $ro->getTotal("phic", "", $registrationNo)); } else { $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $ro->selectNow("patientCharges", "cashUnpaid", "itemNo", $itemz[1])); $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", "0"); } } else { $excessPHIC = $itemz[0] - $targetAmount; $exactPHIC = $itemz[0] - $excessPHIC; $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", $excessPHIC); $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $exactPHIC); } if ($ro->getTotal("phic", "", $registrationNo) != $targetAmount) { $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/rBanny/analyzing_rBanny.php?registrationNo={$registrationNo}&cash={$cash}&targetAmount={$targetAmount}");
echo "</tr>"; echo "<Tr>"; echo "<td><input type='checkbox'><font size=2>PhilHealth benefit is enough to cover HCI and PF Charges</font> <br> <font size=2> No purchases of drugs/medicines,supplies,diagnostics, and co-pay for professional fees by the member/patient </font> </td>"; echo "</tr>"; echo "</table>"; $ro->phic_DrugsMeds("1", $registrationNo); $ro->phic_OTHERS($registrationNo); $actualCharges = $ro->getRoomPHIC_total($registrationNo) + $ro->phic_DrugsMeds_totalCharges() + $ro->phic_OTHERS_totalCharges(); $phicCharges = $ro->getRoomPHIC_cover($registrationNo) + $ro->phic_DrugsMeds_totalPHIC() + $ro->phic_OTHERS_totalPHIC(); $unpaidCharges = $actualCharges - $phicCharges; echo "<center><table style='width:860px;' cellspacing=0 cellpadding=1 border=1 >"; echo "<Tr>"; echo "<Td width='430px;' > </td>"; echo "<td width='430px;'> <center><font size=2>Total Actual Charges*</font></center> </td>"; echo "</tr>"; if ($ro->getTotal("cashUnpaid", "", $registrationNo) > 0) { echo "<Tr>"; echo "<td> <font size=2>Total Health Care Institution Fees</font> </td>"; echo "<td> <Center> <input type='text' class='amount' value=''> </center> </td>"; echo "</tr>"; echo "<Tr>"; echo "<td> <font size=2>Total Professional Fees</font> </td>"; echo "<td> <Center> <input type='text' class='amount' value=''> </center> </td>"; echo "</tr>"; echo "<Tr>"; echo "<td> <font size=2> Grand Total </font> </td>"; echo "<td> <Center> <input type='text' class='amount' value=''> </center> </td>"; echo "</tr>"; } else { echo "<Tr>"; echo "<td> <font size=2>Total Health Care Institution Fees</font> </td>";
//echo "<table border=0>"; //echo "<td>Address: </tD>"; //echo "<tD>".$ro->getPatientRecord_address()."</tD>"; //echo "</table>"; echo "<center><br>"; echo "<table border=1 cellpadding=1 cellspacing=0 rules=all>"; echo "<tr>"; echo "<th> Particular </th>"; echo "<th> Actual </th>"; echo "<th> PhilHealth </th>"; echo "<th> Company </th>"; echo "<th> Cash </th>"; echo "</tr>"; echo "<tr>"; echo "<td> <font size=3>Room</font> </td>"; if ($ro->getTotal("total", "Room And Board", $registrationNo) > 0) { echo "<td> <input type='text' class='editable' value='" . number_format($ro->getTotal("total", "Room And Board", $registrationNo), 2) . "'> </td>"; $gt += $ro->getTotal("total", "Room And Board", $registrationNo); $hospitalBill_gt += $ro->getTotal("total", "Room And Board", $registrationNo); } else { echo "<Td> <input type='text' class='editable' value=''></td>"; } ////////////// PHIC ROOM if ($ro->getTotal("phic", "Room And Board", $registrationNo) > 0) { echo "<td> <input type='text' class='editable' value='" . number_format($ro->getTotal("phic", "Room And Board", $registrationNo), 2) . "'> </td>"; $phicz += $ro->getTotal("phic", "Room And Board", $registrationNo); $hospitalBill_phic += $ro->getTotal("phic", "Room And Board", $registrationNo); } else { echo "<Td> <input type='text' class='editable' value=''></td>"; } ////////COMPANY ROOM
echo number_format($soa->ventilator_excess(), 2); echo " </td>"; $cashz += $soa->ventilator_excess(); $hospitalBill_cash += $soa->ventilator_excess(); } else { echo "<td> </tD>"; } echo "</tr>"; } else { } /////////////VENTILATOR //////////////PULSE OXIMETER if ($ro->checkIfTitleExist($registrationNo, "PULSE_OXIMETER") > 0) { echo "<tr>"; echo "<td> PULSE OXIMETER </td>"; if ($ro->getTotal("total", "PULSE_OXIMETER", $registrationNo) > 0) { echo "<td> "; echo number_format($ro->getTotal("total", "PULSE_OXIMETER", $registrationNo), 2); echo " </td>"; $gt += $ro->getTotal("total", "PULSE_OXIMETER", $registrationNo); $hospitalBill_gt += $ro->getTotal("total", "PULSE_OXIMETER", $registrationNo); } else { echo "<Td> </td>"; } ///////////////// PHIC PULSE_OXIMETER if ($ro->getTotal("phic", "PULSE_OXIMETER", $registrationNo) > 0) { echo "<td> "; echo number_format($ro->getTotal("phic", "PULSE_OXIMETER", $registrationNo), 2); echo " </td>"; $phicz += $ro->getTotal("phic", "PULSE_OXIMETER", $registrationNo); $hospitalBill_phic += $ro->getTotal("phic", "PULSE_OXIMETER", $registrationNo);
<?php include "../../myDatabase2.php"; $registrationNo = $_GET['registrationNo']; $targetAmount = $_GET['targetAmount']; $ro = new database2(); $itemz = preg_split("/\\_/", $ro->getMaximumTotal_rBanny($registrationNo, "MEDICINE")); if ($ro->getTotal("cashUnpaid", "MEDICINE", $registrationNo) > 0) { echo "<br><Br><br><br><br>"; echo "<font color=red>R-Banny is Completed the Room</font><br>"; echo "<font color=red>R-Banny is now Calculating Medicine</font><br>"; echo "Total: " . $itemz[0]; echo "<br>"; echo "Item#: " . $itemz[1]; $ro->getPatientChargesToEdit($itemz[1]); if ($targetAmount >= $itemz[0]) { $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", "0"); $ro->editNow("patientCharges", "itemNo", $itemz[1], "Company", "0"); $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $itemz[0]); } else { //echo "<br><Br><br><br><font color=blue size=5>R-Banny is Having a trouble in Computation</font>"; $newCash = $itemz[0] - $targetAmount; $newPHIC = $ro->selectNow("patientCharges", "total", "itemNo", $itemz[1]) - $newCash; $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", $newCash); $ro->editNow("patientCharges", "itemNo", $itemz[1], "Company", "0"); $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $newPHIC); } $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/rBanny/consumedMeds.php?registrationNo={$registrationNo}&targetAmount={$targetAmount}"); } else { $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/rBanny/consumedSup.php?registrationNo={$registrationNo}&targetAmount={$targetAmount}"); }
echo "<Td> <input type='text' class='editable' value='' ></tD>"; echo "<Td> <input type='text' class='editable' value='' ></tD>"; echo "</tr>"; echo "<tr>"; echo "<td> <b>D.OPERATING ROOM FEE</b></tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> " . $ro->doubleSelectNow("patientCharges", "hmoPrice", "registrationNo", $registrationNo, "description", "OPERATING ROOM FEE") . "</tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "</tr>"; echo "<tr>"; echo "<td> <b>E.MISCELLANEOUS</b></tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> " . $ro->getTotal("hmoPrice", "MISCELLANEOUS", $registrationNo) . "</tD>"; echo "<Td> </tD>"; echo "<Td> " . $ro->getTotal("company", "MISCELLANEOUS", $registrationNo) . "</tD>"; echo "</tr>"; echo "<tr>"; echo "<td> <b>F.OXYGEN</b></tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> " . $ro->getTotal("hmoPrice", "OXYGEN", $registrationNo) . "</tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "</tr>"; echo "<tr>"; echo "<td> <b>G.NURSING CARE</b></tD>"; echo "<Td> </tD>"; echo "<Td> </tD>";
//echo "<td>Address: </tD>"; //echo "<tD>".$ro->getPatientRecord_address()."</tD>"; //echo "</table>"; echo "<center><br>"; echo "<table border=1 cellpadding=1 cellspacing=0 rules=all>"; echo "<tr>"; echo "<th> Particular </th>"; echo "<th> Actual </th>"; echo "<th> PhilHealth </th>"; echo "<th> Company </th>"; echo "<th> Cash </th>"; echo "<th> Discount </th>"; echo "</tr>"; echo "<tr>"; echo "<td> <font size=3>Room</font> </td>"; if ($ro->getTotal("total", "Room And Board", $registrationNo) > 0) { echo "<td> "; echo number_format($ro->getTotal("total", "Room And Board", $registrationNo), 2); echo " </td>"; $gt += $ro->getTotal("total", "Room And Board", $registrationNo); $hospitalBill_gt += $ro->getTotal("total", "Room And Board", $registrationNo); } else { echo "<Td> </td>"; } ////////////// PHIC ROOM if ($ro->getTotal("phic", "Room And Board", $registrationNo) > 0) { echo "<td> "; echo number_format($ro->getTotal("phic", "Room And Board", $registrationNo), 2); echo " </td>"; $phicz += $ro->getTotal("phic", "Room And Board", $registrationNo); $hospitalBill_phic += $ro->getTotal("phic", "Room And Board", $registrationNo);
<?php include "../../myDatabase2.php"; $registrationNo = $_GET['registrationNo']; $targetAmount = $_GET['targetAmount']; $ro = new database2(); $itemz = preg_split("/\\_/", $ro->getMaximumTotal_rBanny($registrationNo, "SUPPLIES")); if ($ro->getTotal("cashUnpaid", "SUPPLIES", $registrationNo) > 0) { echo "<br><Br><br><br><br>"; echo "<font color=red>R-Banny is Completed the Room</font><br>"; echo "<font color=red>R-Banny is Completed the Medicine</font><br>"; echo "<font color=red>R-Banny is now Calculating Supplies</font><br>"; echo "Total: " . $itemz[0]; echo "<br>"; echo "Item#: " . $itemz[1]; $ro->getPatientChargesToEdit($itemz[1]); if ($targetAmount >= $itemz[0]) { $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", "0"); $ro->editNow("patientCharges", "itemNo", $itemz[1], "Company", "0"); $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $itemz[0]); } else { $newCash = $itemz[0] - $targetAmount; $newPHIC = $ro->selectNow("patientCharges", "total", "itemNo", $itemz[1]) - $newCash; $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", $newCash); $ro->editNow("patientCharges", "itemNo", $itemz[1], "Company", "0"); $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $newPHIC); } $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/rBanny/consumedSup.php?registrationNo={$registrationNo}&targetAmount={$targetAmount}"); } else { echo "reached"; }