PHP database2::getTotal 예제들

예제 #1

파일: summaryCompany.php 프로젝트: rickyx12/mendero

echo "<table border=0>";
echo "<td>Address:&nbsp;</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>&nbsp;Particular&nbsp;</th>";
echo "<th>&nbsp;Actual&nbsp;</th>";
echo "<th>&nbsp;PhilHealth&nbsp;</th>";
echo "<th>&nbsp;Company&nbsp;</th>";
echo "<th>&nbsp;Cash&nbsp;</th>";
echo "</tr>";
echo "<tr>";
echo "<td>&nbsp;<font size=3>Room</font> &nbsp;</td>";
if ($ro->getTotal("total", "Room And Board", $registrationNo) > 0) {
    echo "<td>&nbsp;";
    echo number_format($ro->getTotal("total", "Room And Board", $registrationNo), 2);
    echo "&nbsp;</td>";
    $gt += $ro->getTotal("total", "Room And Board", $registrationNo);
    $hospitalBill_gt += $ro->getTotal("total", "Room And Board", $registrationNo);
} else {
    echo "<Td>&nbsp;</td>";
}
////////////// PHIC ROOM
if ($ro->getTotal("phic", "Room And Board", $registrationNo) > 0) {
    echo "<td>&nbsp;" . number_format($ro->getTotal("phic", "Room And Board", $registrationNo), 2) . "&nbsp;</td>";
    $phicz += $ro->getTotal("phic", "Room And Board", $registrationNo);
    $hospitalBill_phic += $ro->getTotal("phic", "Room And Board", $registrationNo);
} else {
    echo "<Td>&nbsp;</td>";

예제 #2

파일: consumedRoom.php 프로젝트: rickyx12/protacio

<?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:&nbsp;" . $itemz[0];
    echo "<br>";
    echo "Item#:&nbsp;" . $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}");
}

예제 #3

파일: detailedTotalOnly_nov-13-2015.php 프로젝트: rickyx12/protacio

echo "<td>&nbsp;" . number_format(trim($gtWithoutPHIC + $pfTotal), 2) . "</td>";
echo "<td>&nbsp;</td>";
echo "</tr>";
echo "<tr>";
echo "<td>&nbsp;<font size=2><b>PhilHealth</b></font></td>";
echo "<td>&nbsp;</td>";
echo "<td>&nbsp;<font size=2><b>1st Case</b></font></td>";
echo "<td>&nbsp;<font size=2><b>2nd Case</b></font></td>";
echo "<td>&nbsp;</td>";
echo "<td>&nbsp;</td>";
echo "<td>&nbsp;</td>";
echo "<td>&nbsp;</td>";
echo "<td>&nbsp;</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>&nbsp;</td>";
echo "<td>&nbsp;<font size=2><b>Hospital Bill</b></font></td>";
echo "<td>&nbsp;<font size=2>" . $firstCase_hospitalBill . "</font></td>";
echo "<td>&nbsp;</td>";
echo "<td>&nbsp;</td>";
echo "<td>&nbsp;</td>";
echo "<td>&nbsp;</td>";
echo "<td>&nbsp;</td>";
echo "<td>&nbsp;</td>";
echo "</tr>";
echo "<tr>";
echo "<td>&nbsp;</td>";
echo "<td>&nbsp;<font size=2><b>Professional Fee</b></font></td>";

예제 #4

파일: approximate_noReset.php 프로젝트: rickyx12/protacio

<?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>:&nbsp;" . $ro->selectNow("rBanny_caserate", "caserate", "caseNo", $caserate) . "&nbsp;[" . number_format($caseRate_amount, 2) . "]";
echo "<br>";
echo "<font color=red size=4>Hospital Bill:&nbsp;</font>" . number_format($hospitalBill, 2);
echo "<Br>";
echo "<font color=red size=4>Professional Fee:&nbsp;</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:&nbsp;</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");

예제 #5

파일: patientProfile_left.php 프로젝트: rickyx12/mendero

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>";

예제 #6

파일: analyzing_rBanny.php 프로젝트: rickyx12/protacio

$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#:&nbsp;" . $itemz[1];
echo "<br>Price:&nbsp;" . $itemz[0];
echo "<br><b>Analyzing &nbsp;" . $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}");

예제 #7

파일: cf2back.php 프로젝트: rickyx12/mendero

echo "</tr>";
echo "<Tr>";
echo "<td><input type='checkbox'><font size=2>PhilHealth benefit is enough to cover HCI and PF Charges</font> <br> &nbsp;&nbsp; <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;' >&nbsp; </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> &nbsp; <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> &nbsp; <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> &nbsp; <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> &nbsp; <font size=2>Total Health Care Institution Fees</font> </td>";

예제 #8

파일: summaryEditable.php 프로젝트: rickyx12/protacio

//echo "<table border=0>";
//echo "<td>Address:&nbsp;</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>&nbsp;Particular&nbsp;</th>";
echo "<th>&nbsp;Actual&nbsp;</th>";
echo "<th>&nbsp;PhilHealth&nbsp;</th>";
echo "<th>&nbsp;Company&nbsp;</th>";
echo "<th>&nbsp;Cash&nbsp;</th>";
echo "</tr>";
echo "<tr>";
echo "<td>&nbsp;<font size=3>Room</font> &nbsp;</td>";
if ($ro->getTotal("total", "Room And Board", $registrationNo) > 0) {
    echo "<td>&nbsp;<input type='text' class='editable' value='" . number_format($ro->getTotal("total", "Room And Board", $registrationNo), 2) . "'>&nbsp;</td>";
    $gt += $ro->getTotal("total", "Room And Board", $registrationNo);
    $hospitalBill_gt += $ro->getTotal("total", "Room And Board", $registrationNo);
} else {
    echo "<Td>&nbsp;<input type='text' class='editable' value=''></td>";
}
////////////// PHIC ROOM
if ($ro->getTotal("phic", "Room And Board", $registrationNo) > 0) {
    echo "<td>&nbsp;<input type='text' class='editable' value='" . number_format($ro->getTotal("phic", "Room And Board", $registrationNo), 2) . "'>&nbsp;</td>";
    $phicz += $ro->getTotal("phic", "Room And Board", $registrationNo);
    $hospitalBill_phic += $ro->getTotal("phic", "Room And Board", $registrationNo);
} else {
    echo "<Td>&nbsp;<input type='text' class='editable' value=''></td>";
}
////////COMPANY ROOM

예제 #9

파일: summary-apr26.php 프로젝트: rickyx12/protacio

        echo number_format($soa->ventilator_excess(), 2);
        echo "&nbsp;</td>";
        $cashz += $soa->ventilator_excess();
        $hospitalBill_cash += $soa->ventilator_excess();
    } else {
        echo "<td>&nbsp;</tD>";
    }
    echo "</tr>";
} else {
}
/////////////VENTILATOR
//////////////PULSE OXIMETER
if ($ro->checkIfTitleExist($registrationNo, "PULSE_OXIMETER") > 0) {
    echo "<tr>";
    echo "<td>&nbsp;PULSE OXIMETER&nbsp;</td>";
    if ($ro->getTotal("total", "PULSE_OXIMETER", $registrationNo) > 0) {
        echo "<td>&nbsp;";
        echo number_format($ro->getTotal("total", "PULSE_OXIMETER", $registrationNo), 2);
        echo "&nbsp;</td>";
        $gt += $ro->getTotal("total", "PULSE_OXIMETER", $registrationNo);
        $hospitalBill_gt += $ro->getTotal("total", "PULSE_OXIMETER", $registrationNo);
    } else {
        echo "<Td>&nbsp;</td>";
    }
    ///////////////// PHIC PULSE_OXIMETER
    if ($ro->getTotal("phic", "PULSE_OXIMETER", $registrationNo) > 0) {
        echo "<td>&nbsp;";
        echo number_format($ro->getTotal("phic", "PULSE_OXIMETER", $registrationNo), 2);
        echo "&nbsp;</td>";
        $phicz += $ro->getTotal("phic", "PULSE_OXIMETER", $registrationNo);
        $hospitalBill_phic += $ro->getTotal("phic", "PULSE_OXIMETER", $registrationNo);

예제 #10

파일: consumedMeds.php 프로젝트: rickyx12/protacio

<?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:&nbsp;" . $itemz[0];
    echo "<br>";
    echo "Item#:&nbsp;" . $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}");
}

예제 #11

파일: hmoSOA_04112014.php 프로젝트: rickyx12/protacio

echo "<Td>&nbsp;<input type='text' class='editable' value='' ></tD>";
echo "<Td>&nbsp;<input type='text' class='editable' value='' ></tD>";
echo "</tr>";
echo "<tr>";
echo "<td>&nbsp;<b>D.OPERATING ROOM FEE</b></tD>";
echo "<Td>&nbsp;</tD>";
echo "<Td>&nbsp;</tD>";
echo "<Td>&nbsp;" . $ro->doubleSelectNow("patientCharges", "hmoPrice", "registrationNo", $registrationNo, "description", "OPERATING ROOM FEE") . "</tD>";
echo "<Td>&nbsp;</tD>";
echo "<Td>&nbsp;</tD>";
echo "</tr>";
echo "<tr>";
echo "<td>&nbsp;<b>E.MISCELLANEOUS</b></tD>";
echo "<Td>&nbsp;</tD>";
echo "<Td>&nbsp;</tD>";
echo "<Td>&nbsp;" . $ro->getTotal("hmoPrice", "MISCELLANEOUS", $registrationNo) . "</tD>";
echo "<Td>&nbsp;</tD>";
echo "<Td>&nbsp;" . $ro->getTotal("company", "MISCELLANEOUS", $registrationNo) . "</tD>";
echo "</tr>";
echo "<tr>";
echo "<td>&nbsp;<b>F.OXYGEN</b></tD>";
echo "<Td>&nbsp;</tD>";
echo "<Td>&nbsp;</tD>";
echo "<Td>&nbsp;" . $ro->getTotal("hmoPrice", "OXYGEN", $registrationNo) . "</tD>";
echo "<Td>&nbsp;</tD>";
echo "<Td>&nbsp;</tD>";
echo "</tr>";
echo "<tr>";
echo "<td>&nbsp;<b>G.NURSING CARE</b></tD>";
echo "<Td>&nbsp;</tD>";
echo "<Td>&nbsp;</tD>";

예제 #12

파일: discountSummary.php 프로젝트: rickyx12/protacio

//echo "<td>Address:&nbsp;</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>&nbsp;Particular&nbsp;</th>";
echo "<th>&nbsp;Actual&nbsp;</th>";
echo "<th>&nbsp;PhilHealth&nbsp;</th>";
echo "<th>&nbsp;Company&nbsp;</th>";
echo "<th>&nbsp;Cash&nbsp;</th>";
echo "<th>&nbsp;Discount&nbsp;</th>";
echo "</tr>";
echo "<tr>";
echo "<td>&nbsp;<font size=3>Room</font> &nbsp;</td>";
if ($ro->getTotal("total", "Room And Board", $registrationNo) > 0) {
    echo "<td>&nbsp;";
    echo number_format($ro->getTotal("total", "Room And Board", $registrationNo), 2);
    echo "&nbsp;</td>";
    $gt += $ro->getTotal("total", "Room And Board", $registrationNo);
    $hospitalBill_gt += $ro->getTotal("total", "Room And Board", $registrationNo);
} else {
    echo "<Td>&nbsp;</td>";
}
////////////// PHIC ROOM
if ($ro->getTotal("phic", "Room And Board", $registrationNo) > 0) {
    echo "<td>&nbsp;";
    echo number_format($ro->getTotal("phic", "Room And Board", $registrationNo), 2);
    echo "&nbsp;</td>";
    $phicz += $ro->getTotal("phic", "Room And Board", $registrationNo);
    $hospitalBill_phic += $ro->getTotal("phic", "Room And Board", $registrationNo);

예제 #13

파일: consumedSup.php 프로젝트: rickyx12/protacio

<?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:&nbsp;" . $itemz[0];
    echo "<br>";
    echo "Item#:&nbsp;" . $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";
}