//$paidz1 = (( $ro->sumPartial_new($registrationNo,"amountPaid") + $ro->sumPartial_new($registrationNo,"pf")) + $ro->sumPartial_new($registrationNo,"admitting") ); $ro->descPartialPayment($registrationNo, $username); //ipakita ung payment ng px na cash $ro->getCompanyPayment($registrationNo, $ro->getRegistrationDetails_company()); //ipakita ung payment ng px s company $ro->getPHICPayment($registrationNo); //ipakita ung payment ng px sa phic echo "<Tr>"; echo "<td> </tD>"; echo "<td> </tD>"; echo "<td> </tD>"; echo "<td> </tD>"; echo "<td> </tD>"; //echo "<td> <b>".number_format( $ro->sumPartial_new($registrationNo) ,2)."</b> </tD>"; echo "</tr>"; $refund = $ro->doubleSelectNow("patientPayment", "amountPaid", "registrationNo", $registrationNo, "paymentFor", "REFUND"); echo "<tr>"; echo "<Td> <b>REFUND</b></td>"; echo "<TD></tD>"; echo "<td></td>"; echo "<td></td>"; echo "<TD>" . number_format($refund, 2) . "</tD>"; echo "</tr>"; $totalCompanyPayment = $ro->getCompanyPayment_total + $ro->getCompanyPayment_discount + $ro->getCompanyPayment_tax(); echo "<Tr>"; echo "<td> <b>Balance</b></tD>"; echo "<td> </tD>"; echo "<td> <b>" . number_format($grandTotalPHIC - $ro->getPHICPayment_total(), 2) . "</b></tD>"; echo "<td> <b>" . number_format($grandTotalCompany1 - $totalCompanyPayment, 2) . "</b></tD>"; $paidz = $ro->sumPartial_new($registrationNo, "amountPaid"); //$remainBalance = ( $grandTotalz - $ro->sumPartial_new($registrationNo) );
$actual += $ro->getDoctorsFee_anesth_total(); $phic += $ro->getDoctorsFee_anesth_phic(); $excess += $ro->getDoctorsFee_anesth_cashUnpaid(); echo "<td> <font size=2>" . $ro->getDoctorsFee_anesth_total() . "</font></tD>"; echo "<td> <font size=2>" . $ro->getDoctorsFee_anesth_phic() . "</font></tD>"; echo "<td> <font size=2>" . $ro->getDoctorsFee_anesth_company() . "</font></tD>"; echo "<td> <font size=2>" . $ro->getDoctorsFee_anesth_cashUnpaid() . "</font></tD>"; echo "</tr>"; echo "<tr>"; echo "<td> <b><font size=2>TOTAL</font></b></tD>"; echo "<td> <b><font size=2>" . number_format($actual, 2) . "</font></b></tD>"; echo "<td> <b><font size=2>" . number_format($phic, 2) . "</font></b></tD>"; echo "<td> <b><font size=2>" . number_format($company, 2) . "</font></b></tD>"; echo "<td> <b><font size=2>" . number_format($excess, 2) . "</font></b></tD>"; echo "</tr>"; $totalPd = $ro->doubleSelectNow("patientCharges", "cashPaid", "title", "DIALYSIS", "registrationNo", $registrationNo) + $ro->doubleSelectNow("patientCharges", "cashPaid", "title", "MEDICINE", "registrationNo", $registrationNo) + $ro->doubleSelectNow("patientCharges", "cashPaid", "title", "LABORATORY", "registrationNo", $registrationNo) + $ro->doubleSelectNow("patientCharges", "cashPaid", "title", "OXYGEN", "registrationNo", $registrationNo) + $ro->doubleSelectNow("patientCharges", "cashPaid", "title", "ADDITIONAL-CHARGES", "registrationNo", $registrationNo) + $ro->doubleSelectNow("patientCharges", "cashPaid", "title", "HPS", "registrationNo", $registrationNo) + $ro->doubleSelectNow("patientCharges", "cashPaid", "title", "EMERGENCY-FEE", "registrationNo", $registrationNo) + $ro->getDoctorsFee_atteding_cashPaid() + $ro->getDoctorsFee_anesth_cashPaid(); $totalPd1 = $ro->getTotal_hdu("cashPaid", "DIALYSIS", $registrationNo) + $ro->getTotal_hdu("cashPaid", "MEDICINE", $registrationNo) + $ro->getTotal_hdu("cashPaid", "LABORATORY", $registrationNo) + $ro->getTotal_hdu("cashPaid", "OXYGEN", $registrationNo) + $ro->getTotal_hdu("cashPaid", "ADDITIONAL-CHARGES", $registrationNo) + $ro->getTotal_hdu("cashPaid", "HPS", $registrationNo) + $ro->getTotal_hdu("cashPaid", "EMERGENCY-FEE", $registrationNo) + $ro->getDoctorsFee_atteding_cashUnpaid() + $ro->getDoctorsFee_anesth_cashUnpaid(); echo "<tr>"; echo "<td> <b><font size=2>Payment</font></b></tD>"; echo "<td> </tD>"; echo "<td> </tD>"; echo "<td> </tD>"; echo "<td> <font size=2>" . number_format($totalPd1, 2) . "</font></tD>"; echo "</tr>"; $balance = $excess - $totalPd1; echo "<tr>"; echo "<td> <b><font size=2>TOTAL</font></b></tD>"; echo "<td> </tD>"; echo "<td> </tD>"; echo "<td> </tD>"; echo "<td> <b><font size=2>" . number_format($balance, 2) . "</font></b></tD>";
$ro->coconutFormStart("get", "http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/individualPayment/paidItems.php"); $ro->coconutHidden("registrationNo", $registrationNo); $ro->coconutHidden("username", $username); $ro->coconutTableStart(); $ro->coconutTableRowStart(); $ro->coconutTableHeader(""); $ro->coconutTableHeader("Description"); $ro->coconutTableHeader("QTY;"); $ro->coconutTableHeader("Price"); $ro->coconutTableHeader("Discount"); $ro->coconutTableHeader("Total"); $ro->coconutTableRowStop(); for ($x = 0; $x < $countz; $x++) { $ro->coconutTableRowStart(); $ro->coconutTableData("<input type='checkbox' name='itemNo[]' value='" . $itemNo[$x] . "' checked>"); $ro->coconutTableData($ro->doubleSelectNow("patientCharges", "description", "itemNo", $itemNo[$x], "registrationNo", $registrationNo)); $ro->coconutTableData($ro->doubleSelectNow("patientCharges", "quantity", "itemNo", $itemNo[$x], "registrationNo", $registrationNo)); $ro->coconutTableData($ro->doubleSelectNow("patientCharges", "sellingPrice", "itemNo", $itemNo[$x], "registrationNo", $registrationNo)); $ro->coconutTableData($ro->doubleSelectNow("patientCharges", "discount", "itemNo", $itemNo[$x], "registrationNo", $registrationNo)); $ro->coconutTableData($ro->doubleSelectNow("patientCharges", "cashUnpaid", "itemNo", $itemNo[$x], "registrationNo", $registrationNo)); $discount += $ro->doubleSelectNow("patientCharges", "discount", "itemNo", $itemNo[$x], "registrationNo", $registrationNo); $total += $ro->doubleSelectNow("patientCharges", "cashUnpaid", "itemNo", $itemNo[$x], "registrationNo", $registrationNo); $ro->coconutTableRowStop(); } $ro->coconutTableRowStart(); $ro->coconutTableData(" "); $ro->coconutTableData(" <b>PHARMACY</b>"); $ro->coconutTableData(" "); $ro->coconutTableData(" "); $ro->coconutTableData(" "); $ro->coconutTableData(" <font color=red>" . $ro->sumFromPharmacy($registrationNo) . "</font>");
<?php include "../../myDatabase2.php"; $registrationNo = $_GET['registrationNo']; $itemNo = $_GET['itemNo']; $quantity = $_GET['quantity']; $username = $_GET['username']; $show = $_GET['show']; $desc = $_GET['desc']; $ro = new database2(); $titlez = $ro->getTitle($itemNo); if ($ro->doubleSelectNow("patientCharges", "quantity", "itemNo", $itemNo, "registrationNo", $registrationNo) < $quantity) { echo "<br><br><br><font color=red>Ooopsss.. you are trying to return {$quantity} but there is only " . $ro->doubleSelectNow("patientCharges", "quantity", "itemNo", $itemNo, "registrationNo", $registrationNo) . " Dispensed to the patient</font>"; } else { if (($ro->getTitle($itemNo) == "MEDICINE" || $ro->getTitle($itemNo) == "SUPPLIES") && $ro->getChargesStatusDept($itemNo)) { if ($ro->selectNow("inventory", "autoDispense", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)) == "yes") { $currentQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)); // current qty ng meds/sup sa inventory $newQTY = $currentQTY + $quantity; //dagdag inventory once return $ro->editNow("inventory", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo), "quantity", $newQTY); // update qty sa database $ro->deletePatientCharges($registrationNo, $itemNo); } else { $ro->editNow("patientCharges", "itemNo", $itemNo, "status", "Return"); $ro->editNow("patientCharges", "itemNo", $itemNo, "dateReturn", date("Y-m-d")); $ro->editNow("patientCharges", "itemNo", $itemNo, "departmentStatus", $quantity . "_" . $registrationNo); $ro->returnInventory($itemNo, $registrationNo, $ro->selectNow("patientCharges", "description", "itemNo", $itemNo), $quantity, date("Y-m-d") . "@" . $ro->getSynapseTime(), $username); /* $regNo = $ro->selectNow("patientCharges","registrationNo","itemNo",$itemNo); $chargeCodez = $ro->selectNow("patientCharges","chargesCode","itemNo",$itemNo);
<?php include "../../myDatabase2.php"; $registrationNo = $_POST['registrationNo']; $username = $_POST['username']; $ro = new database2(); $requestNo = $ro->doubleSelectNow("billingRequest", "requestNo", "registrationNo", $registrationNo, "status", "pending"); $ro->editNow("billingRequest", "requestNo", $requestNo, "status", "completed"); $ro->editNow("billingRequest", "requestNo", $requestNo, "finishBy", $username); $ro->editNow("billingRequest", "requestNo", $requestNo, "dateFinish", date("Y-m-d")); $ro->editNow("billingRequest", "requestNo", $requestNo, "timeFinish", date("H:i:s")); $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientProfile_right.php?username={$username}®istrationNo={$registrationNo}");
echo "<tr>"; echo "<Td><b>TOTAL RECEIPTS FOR THE DAY</b></td>"; echo "<tD> </tD>"; echo "<tD> </tD>"; echo "<tD> <b>AMOUNT</b></tD>"; echo "</tr>"; echo "<tr>"; echo "<Td> </td>"; echo "<tD> </tD>"; echo "<tD> </tD>"; echo "<tD> </tD>"; echo "</tr>"; echo "<tr>"; echo "<Td> Cash(In-Patient)</td>"; echo "<tD> </tD>"; echo "<tD> " . number_format($ro->doubleSelectNow("cashCollection", "amount", "date", $year . "-" . $month . "-" . $day, "type", "Cash_Inpatient"), 2) . "</tD>"; echo "<tD> <b>" . number_format($ro->doubleSelectNow("cashCollection", "amount", "date", $year . "-" . $month . "-" . $day, "type", "Cash_Inpatient"), 2) . "</b></tD>"; echo "</tr>"; echo "<tr>"; echo "<Td> <b>HOSPITAL COLLECTION</b></td>"; echo "<tD> </tD>"; echo "<tD> </tD>"; echo "<tD> </tD>"; echo "</tr>"; echo "<tr>"; echo "<Td> </td>"; echo "<tD> </tD>"; echo "<tD> </tD>"; echo "<tD> </tD>"; echo "</tr>"; $ro->cashCollection_mmc($year . "-" . $month . "-" . $day, "Hospital Collection");
} </script> <a href="#" onClick="printF('printData')" style="text-decoration:none; color:black;">PRINT</a> <div id='printData'> <?php echo "<center><img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/mendero.png' width='60%' height='20%'></center>"; //echo "<center><div style='border:0px solid #000000; width:700px; height:auto; border-color:black black black black;'>"; echo ""; //echo "<font size=5><b><a href='#' style='color:#000; text-decoration:none;'>".$ro->getReportInformation("hmoSOA_name")."</a></b></font>"; //echo "<br><font size=2>".$ro->getReportInformation("hmoSOA_address")."</font>"; echo "<center>"; echo "<table border=0>"; echo "<tr>"; echo "<td>Patient#: </td><td>" . $ro->getRegistrationDetails_patientNo() . "</td>"; echo "<td> Registration#: </td><td> " . $ro->getRegistrationDetails_registrationNo() . "</td>"; echo "<td> Room: " . $room1[0] . " " . $ro->doubleSelectNow("patientCharges", "sellingPrice", "registrationNo", $registrationNo, "description", $ro->getRegistrationDetails_room()) . "/day x " . $ro->doubleSelectNow("patientCharges", "quantity", "registrationNo", $registrationNo, "description", $ro->getRegistrationDetails_room()) . "</td>"; echo "</tr>"; echo "<tr>"; echo "<td>Name: </td><td> <a href='#' onClick='printF(printData)' style='text-decoration:none; color:black;'>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</a></td>"; echo "<td> " . $ro->coconutText("Physician") . "</td><td> " . $ro->getAttendingDoc($registrationNo, "Attending") . "</td>"; echo "<td> Case: " . $ro->selectNow("registrationDetails", "privateORhouse_case", "registrationNo", $registrationNo) . "</td>"; echo "</tr>"; echo "<tr>"; echo "<Td>" . $ro->coconutText("Admitted") . ": </td><td> " . $ro->getRegistrationDetails_dateRegistered() . "@" . $ro->getRegistrationDetails_timeRegistered() . "</td>"; //echo "<td>CaseType:</td><TD>".$ro->getRegistrationDetails_caseType()."</tD>"; echo "<Td> " . $ro->coconutText("Discharged") . ": </td><td> " . $ro->getRegistrationDetails_dateUnregistered() . "@" . $ro->getRegistrationDetails_timeUnregistered() . "</td>"; echo "</tr>"; if ($ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo) != "") { $hmoLimit = number_format($ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo), 2); } else { if ($ro->selectNow("Company", "type", "companyName", $ro->getRegistrationDetails_company()) == "insurance") {
<?php include "../../../myDatabase2.php"; $itemNo = $_GET['itemNo']; $registrationNo = $_GET['registrationNo']; $username = $_GET['username']; $qty = $_GET['qty']; $orNo = $_GET['orNo']; $ro = new database2(); $ro->getPatientProfile($registrationNo); if ($ro->doubleSelectNow("patientCharges", "quantity", "itemNo", $itemNo, "registrationNo", $registrationNo) < $qty) { echo "<script> alert('Pls Return a quantity that will not more than " . $ro->doubleSelectNow("patientCharges", "quantity", "itemNo", $itemNo, "registrationNo", $registrationNo) . "'); window.back();</script>"; } else { if ($ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo) == $qty) { $ro->editNow("patientCharges", "itemNo", $itemNo, "status", "DELETED_" . $username . "[" . date("Y-m-d") . "@" . date("H:i:s") . "]-(return)"); } else { $deductedQTY = $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo) - $qty; $discountedPriceEachItem = $ro->selectNow("patientCharges", "cashPaid", "itemNo", $itemNo) / $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo); $discountEachItem = $ro->selectNow("patientCharges", "discount", "itemNo", $itemNo) / $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo); $ro->editNow("patientCharges", "itemNo", $itemNo, "total", $discountedPriceEachItem * $deductedQTY); $ro->editNow("patientCharges", "itemNo", $itemNo, "discount", $discountEachItem * $deductedQTY); $ro->editNow("patientCharges", "itemNo", $itemNo, "cashPaid", $discountedPriceEachItem * $deductedQTY); $ro->editNow("patientCharges", "itemNo", $itemNo, "quantity", $deductedQTY); } $ro->returnInventory_pharmacy($itemNo, $registrationNo, $ro->selectNow("patientCharges", "description", "itemNo", $itemNo), $qty, date("Y-m-d") . "@" . date("H:i:s"), $username); $ro->addVoidPayment($registrationNo . "_" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName(), $itemNo . "_" . $ro->selectNow("patientCharges", "description", "itemNo", $itemNo), $ro->selectNow("patientCharges", "cashPaid", "itemNo", $itemNo), date("H:i:s"), date("Y-m-d"), $username, $orNo); $newQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)) + $qty; $ro->editNow("inventory", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo), "quantity", $newQTY); } $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientProfile_handler.php?registrationNo={$registrationNo}&username={$username}");
$ro->coconutFormStart("get", "reconcileDetails_editNow.php"); $ro->coconutHidden("reconcileNo", $reconcileNo); $ro->coconutHidden("registrationNo", $registrationNo); $ro->coconutBoxStart("500", "200"); echo "<Br>"; echo "<table border=0>"; echo "<Tr>"; echo "<Td>Patient </tD>"; echo "<td>"; $ro->coconutTextBox_readonly("patient", $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName()); echo "</td>"; echo "</tr>"; echo "<Tr>"; echo "<Td>Ref No#: </tD>"; echo "<td>"; $ro->coconutTextBox("refno", $ro->doubleSelectNow("phicReconcile", "refno", "registrationNo", $registrationNo, "reconcileNo", $reconcileNo)); echo "</td>"; echo "</tr>"; echo "<Tr>"; echo "<Td>Amount </tD>"; echo "<td>"; $ro->coconutTextBox("amount", $ro->doubleSelectNow("phicReconcile", "amount", "registrationNo", $registrationNo, "reconcileNo", $reconcileNo)); echo "</td>"; echo "</tr>"; $datePd = preg_split("/\\_/", $ro->doubleSelectNow("phicReconcile", "date", "registrationNo", $registrationNo, "reconcileNo", $reconcileNo)); echo "<Tr>"; echo "<tD>Date </td>"; echo "<tD>"; $ro->coconutComboBoxStart_short("month"); echo "<option value='" . $datePd[0] . "'>" . $datePd[0] . "</option>"; echo "<option value='Jan'>Jan</option>";
echo "<Td><b>PHYSICIAN:</b> </tD>"; echo "<tD>" . $ro->getAttendingDoc($registrationNo, "Attending") . "</tD>"; echo "</tr>"; echo "</table>"; echo "<Br><Br><Br><Br>"; echo "<Table border=1 cellspacing=0>"; echo "<tr>"; echo "<th> HOSPITAL CHARGES </th>"; echo "<th> </th>"; echo "<th> </th>"; echo "<th> ACTUAL </th>"; echo "<th> MEDICARE </th>"; echo "<th> EXCESS </th>"; echo "</tr>"; echo "<tr>"; echo "<td> <b>A. ROOM</b> " . $ro->doubleSelectNow("patientCharges", "quantity", "registrationNo", $registrationNo, "description", $ro->selectNow("registrationDetails", "room", "registrationNo", $registrationNo)) . " DAYS AT " . $ro->selectNow("room", "rate", "Description", $ro->getRegistrationDetails_room()) . "</td>"; echo "<td> </td>"; echo "<td> </td>"; echo "<td> " . number_format($ro->doubleSelectNow("patientCharges", "total", "registrationNo", $registrationNo, "description", $ro->getRegistrationDetails_room()), 2) . "</tD>"; echo "<td> " . number_format($ro->doubleSelectNow("patientCharges", "phic", "registrationNo", $registrationNo, "description", $ro->getRegistrationDetails_room()), 2) . "</tD>"; echo "<td> " . number_format($ro->doubleSelectNow("patientCharges", "company", "registrationNo", $registrationNo, "description", $ro->getRegistrationDetails_room()), 2) . "</tD>"; echo "</tr>"; echo "<tr>"; echo "<td> <b>B. DRUGS AND MEDICINES</b></tD>"; echo "<tD> <b>QTY</b></tD>"; echo "<tD> <b>UNIT COST</b></tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "</tR>"; $ro->hmo_meds($registrationNo);
<?php include "../../myDatabase2.php"; $registrationNo = $_GET['registrationNo']; $itemNo = $_GET['itemNo']; $count = count($itemNo); $ro = new database2(); for ($x = 0; $x < $count; $x++) { if ($ro->doubleSelectNow("patientCharges", "rBannyStatus", "registrationNo", $registrationNo, "itemNo", $itemNo[$x]) == "exclude") { $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo[$x], "rBannyStatus", ""); } else { $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo[$x], "rBannyStatus", "exclude"); } } $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/rBanny/itemException.php?registrationNo={$registrationNo}");