Esempi in PHP per database2::doubleSelectNow

Esempio n. 1

File: summaryCompany.php Progetto: rickyx12/mendero

//$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>&nbsp;</tD>";
echo "<td>&nbsp;</tD>";
echo "<td>&nbsp;</tD>";
echo "<td>&nbsp;</tD>";
echo "<td>&nbsp;</tD>";
//echo "<td>&nbsp;<b>".number_format( $ro->sumPartial_new($registrationNo) ,2)."</b>&nbsp;</tD>";
echo "</tr>";
$refund = $ro->doubleSelectNow("patientPayment", "amountPaid", "registrationNo", $registrationNo, "paymentFor", "REFUND");
echo "<tr>";
echo "<Td>&nbsp;<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>&nbsp;<b>Balance</b></tD>";
echo "<td>&nbsp;</tD>";
echo "<td>&nbsp;<b>" . number_format($grandTotalPHIC - $ro->getPHICPayment_total(), 2) . "</b></tD>";
echo "<td>&nbsp;<b>" . number_format($grandTotalCompany1 - $totalCompanyPayment, 2) . "</b></tD>";
$paidz = $ro->sumPartial_new($registrationNo, "amountPaid");
//$remainBalance = ( $grandTotalz - $ro->sumPartial_new($registrationNo) );

Esempio n. 2

File: dialysisSOA_test.php Progetto: rickyx12/protacio

$actual += $ro->getDoctorsFee_anesth_total();
$phic += $ro->getDoctorsFee_anesth_phic();
$excess += $ro->getDoctorsFee_anesth_cashUnpaid();
echo "<td>&nbsp;<font size=2>" . $ro->getDoctorsFee_anesth_total() . "</font></tD>";
echo "<td>&nbsp;<font size=2>" . $ro->getDoctorsFee_anesth_phic() . "</font></tD>";
echo "<td>&nbsp;<font size=2>" . $ro->getDoctorsFee_anesth_company() . "</font></tD>";
echo "<td>&nbsp;<font size=2>" . $ro->getDoctorsFee_anesth_cashUnpaid() . "</font></tD>";
echo "</tr>";
echo "<tr>";
echo "<td>&nbsp;<b><font size=2>TOTAL</font></b></tD>";
echo "<td>&nbsp;<b><font size=2>" . number_format($actual, 2) . "</font></b></tD>";
echo "<td>&nbsp;<b><font size=2>" . number_format($phic, 2) . "</font></b></tD>";
echo "<td>&nbsp;<b><font size=2>" . number_format($company, 2) . "</font></b></tD>";
echo "<td>&nbsp;<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>&nbsp;<b><font size=2>Payment</font></b></tD>";
echo "<td>&nbsp;</tD>";
echo "<td>&nbsp;</tD>";
echo "<td>&nbsp;</tD>";
echo "<td>&nbsp;<font size=2>" . number_format($totalPd1, 2) . "</font></tD>";
echo "</tr>";
$balance = $excess - $totalPd1;
echo "<tr>";
echo "<td>&nbsp;<b><font size=2>TOTAL</font></b></tD>";
echo "<td>&nbsp;</tD>";
echo "<td>&nbsp;</tD>";
echo "<td>&nbsp;</tD>";
echo "<td>&nbsp;<b><font size=2>" . number_format($balance, 2) . "</font></b></tD>";

Esempio n. 3

File: showSelectedMeds.php Progetto: rickyx12/protacio

$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("&nbsp;");
$ro->coconutTableData("&nbsp;<b>PHARMACY</b>");
$ro->coconutTableData("&nbsp;");
$ro->coconutTableData("&nbsp;");
$ro->coconutTableData("&nbsp;");
$ro->coconutTableData("&nbsp;<font color=red>" . $ro->sumFromPharmacy($registrationNo) . "</font>");

Esempio n. 4

File: deletePatientCharges_redirect.php Progetto: rickyx12/mendero

<?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);

Esempio n. 5

File: finalBill.php Progetto: rickyx12/protacio

<?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}&registrationNo={$registrationNo}");

Esempio n. 6

File: cashCollection_output_with_receivables.php Progetto: rickyx12/mendero

echo "<tr>";
echo "<Td><b>TOTAL RECEIPTS FOR THE DAY</b></td>";
echo "<tD>&nbsp;</tD>";
echo "<tD>&nbsp;</tD>";
echo "<tD>&nbsp;<b>AMOUNT</b></tD>";
echo "</tr>";
echo "<tr>";
echo "<Td>&nbsp;</td>";
echo "<tD>&nbsp;</tD>";
echo "<tD>&nbsp;</tD>";
echo "<tD>&nbsp;</tD>";
echo "</tr>";
echo "<tr>";
echo "<Td>&nbsp;Cash(In-Patient)</td>";
echo "<tD>&nbsp;</tD>";
echo "<tD>&nbsp;" . number_format($ro->doubleSelectNow("cashCollection", "amount", "date", $year . "-" . $month . "-" . $day, "type", "Cash_Inpatient"), 2) . "</tD>";
echo "<tD>&nbsp;<b>" . number_format($ro->doubleSelectNow("cashCollection", "amount", "date", $year . "-" . $month . "-" . $day, "type", "Cash_Inpatient"), 2) . "</b></tD>";
echo "</tr>";
echo "<tr>";
echo "<Td>&nbsp;<b>HOSPITAL COLLECTION</b></td>";
echo "<tD>&nbsp;</tD>";
echo "<tD>&nbsp;</tD>";
echo "<tD>&nbsp;</tD>";
echo "</tr>";
echo "<tr>";
echo "<Td>&nbsp;</td>";
echo "<tD>&nbsp;</tD>";
echo "<tD>&nbsp;</tD>";
echo "<tD>&nbsp;</tD>";
echo "</tr>";
$ro->cashCollection_mmc($year . "-" . $month . "-" . $day, "Hospital Collection");

Esempio n. 7

File: summary.php Progetto: rickyx12/protacio

}
</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#:&nbsp;</td><td>" . $ro->getRegistrationDetails_patientNo() . "</td>";
echo "<td>&nbsp;&nbsp;Registration#:&nbsp;</td><td>&nbsp;" . $ro->getRegistrationDetails_registrationNo() . "</td>";
echo "<td>&nbsp;Room:&nbsp;" . $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:&nbsp;</td><td>&nbsp;<a href='#' onClick='printF(printData)' style='text-decoration:none; color:black;'>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</a></td>";
echo "<td>&nbsp;&nbsp;" . $ro->coconutText("Physician") . "</td><td>&nbsp;" . $ro->getAttendingDoc($registrationNo, "Attending") . "</td>";
echo "<td>&nbsp;Case: " . $ro->selectNow("registrationDetails", "privateORhouse_case", "registrationNo", $registrationNo) . "</td>";
echo "</tr>";
echo "<tr>";
echo "<Td>" . $ro->coconutText("Admitted") . ":&nbsp;</td><td>&nbsp;" . $ro->getRegistrationDetails_dateRegistered() . "@" . $ro->getRegistrationDetails_timeRegistered() . "</td>";
//echo "<td>CaseType:</td><TD>".$ro->getRegistrationDetails_caseType()."</tD>";
echo "<Td>&nbsp;&nbsp;" . $ro->coconutText("Discharged") . ":&nbsp;</td><td>&nbsp;" . $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") {

Esempio n. 8

File: returnItem1.php Progetto: rickyx12/mendero

<?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}");

Esempio n. 9

File: reconcileDetails_edit.php Progetto: rickyx12/protacio

$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&nbsp;</tD>";
echo "<td>";
$ro->coconutTextBox_readonly("patient", $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName());
echo "</td>";
echo "</tr>";
echo "<Tr>";
echo "<Td>Ref No#:&nbsp;</tD>";
echo "<td>";
$ro->coconutTextBox("refno", $ro->doubleSelectNow("phicReconcile", "refno", "registrationNo", $registrationNo, "reconcileNo", $reconcileNo));
echo "</td>";
echo "</tr>";
echo "<Tr>";
echo "<Td>Amount&nbsp;</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&nbsp;</td>";
echo "<tD>";
$ro->coconutComboBoxStart_short("month");
echo "<option value='" . $datePd[0] . "'>" . $datePd[0] . "</option>";
echo "<option value='Jan'>Jan</option>";

Esempio n. 10

File: hmoSOA_04112014.php Progetto: rickyx12/protacio

echo "<Td><b>PHYSICIAN:</b>&nbsp;</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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HOSPITAL CHARGES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</th>";
echo "<th>&nbsp;</th>";
echo "<th>&nbsp;</th>";
echo "<th>&nbsp;&nbsp;ACTUAL&nbsp;&nbsp;</th>";
echo "<th>&nbsp;&nbsp;MEDICARE&nbsp;&nbsp;</th>";
echo "<th>&nbsp;&nbsp;EXCESS&nbsp;&nbsp;</th>";
echo "</tr>";
echo "<tr>";
echo "<td>&nbsp;<b>A.&nbsp;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>&nbsp;</td>";
echo "<td>&nbsp;</td>";
echo "<td>&nbsp;" . number_format($ro->doubleSelectNow("patientCharges", "total", "registrationNo", $registrationNo, "description", $ro->getRegistrationDetails_room()), 2) . "</tD>";
echo "<td>&nbsp;" . number_format($ro->doubleSelectNow("patientCharges", "phic", "registrationNo", $registrationNo, "description", $ro->getRegistrationDetails_room()), 2) . "</tD>";
echo "<td>&nbsp;" . number_format($ro->doubleSelectNow("patientCharges", "company", "registrationNo", $registrationNo, "description", $ro->getRegistrationDetails_room()), 2) . "</tD>";
echo "</tr>";
echo "<tr>";
echo "<td>&nbsp;<b>B.&nbsp; DRUGS AND MEDICINES</b></tD>";
echo "<tD>&nbsp;<b>QTY</b></tD>";
echo "<tD>&nbsp;<b>UNIT COST</b></tD>";
echo "<Td>&nbsp;</tD>";
echo "<Td>&nbsp;</tD>";
echo "<Td>&nbsp;</tD>";
echo "</tR>";
$ro->hmo_meds($registrationNo);

Esempio n. 11

File: itemException1.php Progetto: rickyx12/protacio

<?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}");