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