include "../../../myDatabase.php"; $registrationNo = $_GET['registrationNo']; $casetype = $_GET['casetype']; $cash = $_GET['cash']; $case = $_GET['case']; $ro = new database(); $ro->getPHIClimit_setter($casetype); echo $cash - $ro->getPHIClimit_room(); echo "<br><br>"; $itemz = preg_split("/\\_/", $ro->getMaximumTotal_any($registrationNo, "Room And Board")); echo "Price:" . $itemz[0]; echo "<br><br>item no." . $itemz[1]; $ro->getPatientChargesToEdit($itemz[1]); if ($itemz[0] >= $ro->getPHIClimit_room()) { $newCash = $ro->patientCharges_cashUnpaid() - ($ro->getPHIClimit_room() - $ro->getTotal("phic", "Room And Board", $registrationNo)); if ($newCash > 1) { $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", $newCash); $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $ro->getPHIClimit_room() - $ro->getTotal("phic", "Room And Board", $registrationNo)); } else { $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", "0"); $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $ro->patientCharges_cashUnpaid()); } } else { $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", "0"); $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $ro->patientCharges_cashUnpaid()); } if ($ro->getTotal("phic", "Room And Board", $registrationNo) != $ro->getPHIClimit_room()) { $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/phicLimit/phicFuller_room.php?registrationNo={$registrationNo}&casetype={$casetype}&cash=&case={$case}"); } else { if ($ro->getMaximumTotal_any_checker($registrationNo, "Room And Board") == 0) {
echo "<br><br>"; echo "<table border=0>"; echo "<tr>"; echo "<td><font class='labelz'><b>Name:</b></font></td><td><font size=2>" . $ro->getPatientRecord_completeName() . "</font></td>"; echo "<td> </td>"; echo "<Td><font class='labelz'><b>Registration#:</b></font></td>"; echo "<td><font size=2>" . $ro->getRegistrationDetails_registrationNo() . "</td>"; echo "</tr>"; echo "<tr>"; echo "<Td><font class='labelz'><B>Age:</b></td>"; echo "<Td><font size=2>" . $ro->getPatientRecord_age() . " yrs Old</font></td>"; echo "<Td> </td>"; echo "<td><font class='labelz'><b> Senior:</b></font></td>"; echo "<td><font size=2>" . $ro->getPatientRecord_senior() . "</font></td>"; echo "</tr>"; echo "<tr>"; echo "<Td><font class='labelz'><b>Company:</b></font></td>"; echo "<td><font size=2>" . $ro->getRegistrationDetails_company() . "</font></tD>"; echo "</tr>"; //if($ro->getRegistrationDetails_type() == "IPD") { $ro->chargesForSOA_ipd($registrationNo, "pharmacy", $category, ""); //}else { //$ro->chargesForSOA($registrationNo,"Category",$category,""); //} echo "</table>"; echo "</center>"; echo "<br><Br><Br>"; echo "Medicine: " . number_format($ro->getTotal("total", "MEDICINE", $registrationNo), 2); echo "<br>"; echo "Supplies: " . number_format($ro->getTotal("total", "SUPPLIES", $registrationNo), 2); echo "</div>";
<?php include "../../../myDatabase.php"; $registrationNo = $_GET['registrationNo']; $casetype = $_GET['casetype']; $ro = new database(); $ro->getPatientProfile($registrationNo); $ro->getPHIClimit_setter($casetype); if ($ro->getPatientRecord_phic() == "yes" || $ro->getPatientRecord_phic() == "YES") { //check kung phic $phicMed = $ro->getTotal("cashUnpaid", "", $registrationNo) - $ro->getPHIClimit_medicine(); echo $phicMed; $ro->editNow("patientCharges", "itemNo", $ro->getHighestCharges_itemNo("MEDICINE", "cashUnpaid", $registrationNo), "phic", $ro->getPHIClimit_medicine()); // magLLgay ng amount based on PHIC-med limit $ro->editNow("patientCharges", "itemNo", $ro->getHighestCharges_itemNo("MEDICINE", "cashUnpaid", $registrationNo), "cashUnpaid", $ro->getTotal("cashUnpaid", "", $registrationNo) - $ro->getPHIClimit_medicine()); // magLLgay ng amount based on PHIC-med limit } else { echo "hello"; }
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> Company </th>"; echo "<th> PhilHealth </th>"; echo "<th> Cash </th>"; echo "</tr>"; echo "<tr>"; echo "<td> Medicine </td>"; if ($ro->getTotal("total", "MEDICINE", $registrationNo) > 0) { echo "<td> "; echo number_format($ro->getTotal("total", "MEDICINE", $registrationNo), 0); echo " </td>"; $gt += $ro->getTotal("total", "MEDICINE", $registrationNo); $hospitalBill_gt += $ro->getTotal("total", "MEDICINE", $registrationNo); } else { echo "<td> </tD>"; } if ($ro->getTotal("company", "MEDICINE", $registrationNo) > 0) { echo "<td> "; echo number_format($ro->getTotal("company", "MEDICINE", $registrationNo), 0); echo " </td>"; $company += $ro->getTotal("company", "MEDICINE", $registrationNo); $hospitalBill_company += $ro->getTotal("company", "MEDICINE", $registrationNo); } else {
<?php include "../../../myDatabase.php"; $registrationNo = $_GET['registrationNo']; $casetype = $_GET['casetype']; $ro = new database(); $ro->getPHIClimit_setter($casetype); $ro->getPatientProfile($registrationNo); echo "PHIC Consumed " . number_format($ro->getTotal("phic", "MEDICINE", $registrationNo), 2); // kunin ang phic n meds echo "<Br>"; echo "PHIC Limit " . $ro->getPHIClimit_medicine(); //allowed Limit ng PHIC pra sa meds echo "<Br>"; $kunin_ang_sobra = $ro->getTotal("phic", "MEDICINE", $registrationNo) - $ro->getPHIClimit_medicine(); $binawas_ang_sobra = $ro->getHighestCharges("MEDICINE", "phic", $registrationNo) - $kunin_ang_sobra; if ($ro->getTotal("phic", "MEDICINE", $registrationNo) > $ro->getPHIClimit_medicine() && ($ro->getPatientRecord_phic() == "YES" || $ro->getPatientRecord_phic() == "yes")) { //ckech kung mas mataas ang credit kaysa sa allowed limit echo "<br>Sobra " . number_format($kunin_ang_sobra, 2); echo "<br>Total: " . ($ro->getTotal("phic", "MEDICINE", $registrationNo) - $kunin_ang_sobra); echo "<br>Total: " . $binawas_ang_sobra; //bbwasan ang charges n may pnka mataas na selling price.. ang ibbwas ay ang sobra sa allowed limit ng PHIC meds $ro->editNow("patientCharges", "itemNo", $ro->getHighestCharges_itemNo("MEDICINE", "phic", $registrationNo), "phic", $binawas_ang_sobra); if ($ro->getRegistrationDetails_company() != "") { //ito ung LLipat ang bayad sa hmo if ($ro->getRegistrationDetails_limitHMO() > $ro->getTotal("company", "", $registrationNo)) { echo "hello"; } else { $ro->editNow("patientCharges", "itemNo", $ro->getHighestCharges_itemNo("MEDICINE", "phic", $registrationNo), "company", $kunin_ang_sobra); } } else {
} else { $ro->coconutTableData($ro->getCurrentPHIC_check($registrationNo, "SUPPLIES")); } /* if($ro->getPHIClimit_room() <= $ro->getCurrentPHIC_check($registrationNo,"Room And Board")) { $ro->coconutTableData($ro->getCurrentPHIC_check($registrationNo,"Room And Board")." - <font color=red>".($ro->getCurrentPHIC_check($registrationNo,"Room And Board") - $ro->getPHIClimit_room() )."</font>"); }else { $ro->coconutTableData($ro->getCurrentPHIC_check($registrationNo,"Room And Board")); } */ if ($ro->getPHIClimit_pf() <= $ro->getCurrentPHIC_check($registrationNo, "PROFESSIONAL FEE")) { $ro->coconutTableData($ro->getCurrentPHIC_check($registrationNo, "PROFESSIONAL FEE") . "- <font color=red>(" . ($ro->getCurrentPHIC_check($registrationNo, "PROFESSIONAL FEE") - $ro->getPHIClimit_pf()) . ")</font>"); } else { $ro->coconutTableData($ro->getCurrentPHIC_check($registrationNo, "PROFESSIONAL FEE")); } if ($ro->getTotal("company", "", $registrationNo) > $ro->getRegistrationDetails_limitHMO()) { $ro->coconutTableData("" . $ro->getTotal("company", "", $registrationNo) . " - <font color='red'>" . ($ro->getTotal("company", "", $registrationNo) - $ro->getRegistrationDetails_limitHMO()) . "</font>"); } else { $ro->coconutTableData($ro->getTotal("company", "", $registrationNo)); } $ro->coconutTableData($ro->getTotal("cashUnpaid", "", $registrationNo)); $ro->coconutTableRowStop(); $ro->coconutTableStop(); echo "<br><br>"; echo "<table border=0>"; echo "<td>"; $ro->coconutFormStart("get", "limitMagic.php"); $ro->coconutHidden("registrationNo", $registrationNo); $ro->coconutHidden("casetype", $casetype); $ro->coconutHidden("phicMed_excess", $ro->getTotal("phic", "MEDICINE", $registrationNo) - $ro->getPHIClimit_medicine()); $total = $ro->getCurrentPHIC_check($registrationNo, "SUPPLIES");
include "../../../myDatabase.php"; $registrationNo = $_GET['registrationNo']; $casetype = $_GET['casetype']; $cash = $_GET['cash']; $case = $_GET['case']; $ro = new database(); $ro->getPHIClimit_setter($casetype); echo $cash - $ro->getPHIClimit_room(); echo "<br><br>"; $itemz = preg_split("/\\_/", $ro->getMaximumTotal_PF($registrationNo, $case)); echo "Price:" . $itemz[0]; echo "<br><br>item no." . $itemz[1]; $ro->getPatientChargesToEdit($itemz[1]); if ($itemz[0] >= $ro->getPHIClimit_pf()) { $newCash = $ro->patientCharges_cashUnpaid() - ($ro->getPHIClimit_pf() - $ro->getTotal("phic", "PROFESSIONAL FEE", $registrationNo)); if ($newCash > 1) { $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", $newCash); $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $ro->getPHIClimit_pf() - $ro->getTotal("phic", "PROFESSIONAL FEE", $registrationNo)); } else { $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", "0"); $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $ro->patientCharges_cashUnpaid()); } } else { $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", "0"); $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $ro->patientCharges_cashUnpaid()); } if ($ro->getTotal("phic", "PROFESSIONAL FEE", $registrationNo) != $ro->getPHIClimit_pf()) { $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/phicLimit/phicFuller_PF.php?registrationNo={$registrationNo}&casetype={$casetype}&cash=&case={$case}"); } else { if ($ro->getMaximumTotal_checker_PF($registrationNo, $case) == 0) {
} else { if ($title == "MEDICINE" && $currentMedicine < 1 && $ro->selectNow("inventory", "phic", "inventoryCode", $chargesCode) == "yes") { $ro->addCharges_cash($status, $registrationNo, $chargesCode, $description, $sellingPrice, $totalDiscount, $grandTotal, 0, $grandTotal, 0, $timeCharge, $dateCharge, $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room); } else { if ($title == "MEDICINE" && $currentMedicine > 0 && $ro->selectNow("inventory", "phic", "inventoryCode", $chargesCode) == "yes") { $ro->addCharges_cash($status, $registrationNo, $chargesCode, $description, $sellingPrice, $totalDiscount, $grandTotal, $grandTotal, 0, 0, $timeCharge, $dateCharge, $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room); } else { echo ""; } } } } } else { if ($ro->getRegistrationDetails_company() != "" && $ro->getPatientRecord_phic() == "NO") { //for hmo/company $currentHMO = $ro->getRegistrationDetails_limitHMO() - $ro->getTotal("company", "", $registrationNo); //if($grandTotal > $currentHMO ) { //check kung pde icover Lhat //$totalCover = $grandTotal - $currentHMO; if ($ro->getRegistrationDetails_company() == "MEDITECH") { //HMO pero dpat nsa cashUnpaid $ro->addCharges_cash($status, $registrationNo, $chargesCode, $description, $sellingPrice, $totalDiscount, $grandTotal, $grandTotal, 0, 0, $timeCharge, $dateCharge, $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room); } else { if ($ro->getRegistrationDetails_company() == "MEDALLION") { //HMO pero dpat nsa cashUnpaid $ro->addCharges_cash($status, $registrationNo, $chargesCode, $description, $sellingPrice, $totalDiscount, $grandTotal, $grandTotal, 0, 0, $timeCharge, $dateCharge, $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room); } else { if ($ro->getRegistrationDetails_company() == "MEDI-SERV") { //HMO pero dpat nsa cashUnpaid $ro->addCharges_cash($status, $registrationNo, $chargesCode, $description, $sellingPrice, $totalDiscount, $grandTotal, $grandTotal, 0, 0, $timeCharge, $dateCharge, $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room); } else { //HMO n nsa hmo column
<?php include "../../../myDatabase.php"; $registrationNo = $_GET['registrationNo']; $casetype = $_GET['casetype']; $ro = new database(); $ro->getPatientProfile($registrationNo); $ro->getPHIClimit_setter($casetype); if ($ro->getPatientRecord_phic() == "yes" || $ro->getPatientRecord_phic() == "YES") { //check kung phic $phicSup = $ro->getTotal("cashUnpaid", "", $registrationNo) - $ro->getPHIClimit_supplies(); echo $phicSup; $ro->editNow("patientCharges", "itemNo", $ro->getHighestCharges_itemNo("SUPPLIES", "cashUnpaid", $registrationNo), "phic", $ro->getPHIClimit_supplies()); // magLLgay ng amount based on PHIC-med limit $ro->editNow("patientCharges", "itemNo", $ro->getHighestCharges_itemNo("SUPPLIES", "cashUnpaid", $registrationNo), "cashUnpaid", $ro->getTotal("cashUnpaid", "", $registrationNo) - $ro->getPHIClimit_supplies()); // magLLgay ng amount based on PHIC-med limit } else { if ($ro->getRegistrationDetails_company() != "") { $ro->editNow("patientCharges", "itemNo", $ro->getHighestCharges_itemNo("", "cashUnpaid", $registrationNo), "company", $ro->getPHIClimit_medicine()); // magLLgay ng amount based on PHIC-med limit } else { echo "hello"; } }
include "../../../myDatabase.php"; require_once dirname(__FILE__) . '../../../../html2pdf/html2pdf.class.php'; $registrationNo = $_GET['registrationNo']; $ro = new database(); $html2pdf = new HTML2PDF('P', 'A4', 'fr'); $ro->getPatientProfile($registrationNo); $medActual; $medPHIC; $medCompany; $medCash; $hospitalBill_gt = 0; $hospitalBill_phic = 0; $hospitalBill_company = 0; $hospitalBill_cash = 0; /******* MEDICINE *********/ if ($ro->getTotal("total", "MEDICINE", $registrationNo) > 0) { $medActual = number_format($ro->getTotal("total", "MEDICINE", $registrationNo), 0); $hospitalBill_gt += $ro->getTotal("total", "MEDICINE", $registrationNo); } else { $medActual = ""; } if ($ro->getTotal("phic", "MEDICINE", $registrationNo) > 0) { $medPHIC = number_format($ro->getTotal("phic", "MEDICINE", $registrationNo), 0); $hospitalBill_phic += $ro->getTotal("phic", "MEDICINE", $registrationNo); } else { $medPHIC = ""; } if ($ro->getTotal("company", "MEDICINE", $registrationNo) > 0) { $medCompany = number_format($ro->getTotal("company", "MEDICINE", $registrationNo), 0); $hospitalBill_company += $ro->getTotal("company", "MEDICINE", $registrationNo); } else {
<?php include "../../../myDatabase.php"; $casetype = $_GET['casetype']; $registrationNo = $_GET['registrationNo']; $ro = new database(); $ro->getPatientProfile($registrationNo); $ro->getPHIClimit_setter($casetype); $currentCash = $ro->getTotal("cashUnpaid", "", $registrationNo); $kulang = $ro->getPHIClimit_medicine() - $ro->getCurrentPHIC_check($registrationNo, "MEDICINE"); $ro->getHighestCharges_itemNo_reverse("MEDICINE", $registrationNo, $kulang); $pandagdag = $ro->highestCharges_getCashUnpaid_reverse() - $kulang; $ro->editNow("patientCharges", "itemNo", $ro->highestCharges_getItemNo_reverse(), "phic", $kulang); //bbwsan ung cashUnpa $ro->editNow("patientCharges", "itemNo", $ro->highestCharges_getItemNo_reverse(), "cashUnpaid", $pandagdag); echo $ro->highestCharges_getItemNo_reverse();
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> Medicine </td>"; $totalMedicine = $ro->getTotal("total", "MEDICINE", $registrationNo); $phicMedicine = $ro->getTotal("phic", "MEDICINE", $registrationNo); $companyMedicine = $ro->getTotal("company", "MEDICINE", $registrationNo); $cashMedicine = $ro->getTotal("cashUnpaid", "MEDICINE", $registrationNo); //if( $ro->getTotal("total","MEDICINE",$registrationNo) > 0 ) { $totalMedicine = $ro->getTotal("total", "MEDICINE", $registrationNo); echo "<td> " . number_format($totalMedicine, 0) . " </td>"; $gt += $totalMedicine; $hospitalBill_gt += $totalMedicine; //}else { //echo "<td> </tD>"; //} /////// PHIC MEDICINE //if( $ro->getTotal("phic","MEDICINE",$registrationNo) > 0 ) { echo "<td> " . number_format($phicMedicine, 0) . " </td>"; $phicz += $phicMedicine;
$casetype = $_GET['casetype']; $cash = $_GET['cash']; $case = $_GET['case']; $ro = new database(); $ro->getPHIClimit_setter($casetype); echo $cash - $ro->getPHIClimit_medicine(); echo "<br><br>"; $itemz = preg_split("/\\_/", $ro->getMaximumTotal($registrationNo, $case)); echo "Price:" . $itemz[0]; echo "<br><br>item no." . $itemz[1]; $ro->getPatientChargesToEdit($itemz[1]); $excessPHIC = $ro->getCurrentPHIC_check($registrationNo, "MEDICINE") - $ro->getPHIClimit_medicine(); //$ro->getCurrentPHIC_check($registrationNo,"MEDICINE") //$ro->getPHIClimit_medicine() if ($itemz[0] >= $excessPHIC) { $newCash = $ro->patientCharges_cashUnpaid() - ($ro->getPHIClimit_medicine() - $ro->getTotal("phic", "MEDICINE", $registrationNo)); if ($newCash > 1) { $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", $newCash); $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $ro->getPHIClimit_medicine() - $ro->getTotal("phic", "MEDICINE", $registrationNo)); } else { $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", "0"); $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $ro->patientCharges_cashUnpaid()); } } else { $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", "0"); $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $ro->patientCharges_cashUnpaid()); } if ($ro->getTotal("phic", "MEDICINE", $registrationNo) != $ro->getPHIClimit_medicine()) { $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/phicLimit/phicFuller.php?registrationNo={$registrationNo}&casetype={$casetype}&cash=&case={$case}"); } else { if ($ro->getMaximumTotal_checker($registrationNo, $case) == 0) {