本文整理汇总了PHP中database2::doubleSelectNow方法的典型用法代码示例。如果您正苦于以下问题:PHP database2::doubleSelectNow方法的具体用法?PHP database2::doubleSelectNow怎么用?PHP database2::doubleSelectNow使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类database2
的用法示例。
在下文中一共展示了database2::doubleSelectNow方法的11个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1:
//$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) );
示例2:
$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>";
示例3:
$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>");
示例4: date
<?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);
示例5: date
<?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}");
示例6:
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");
示例7:
}
</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") {
示例8: alert
<?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}");
示例9:
$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>";
示例10:
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);
示例11: count
<?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}");