<?php include "../../../myDatabase1.php"; $registrationNo = $_GET['registrationNo']; $ro = new database1(); //echo $registrationNo; $ro->getPatientProfile($registrationNo); $totalPHIC = $ro->getTotal("phic", "MEDICINE", $registrationNo) + $ro->getTotal("phic", "SUPPLIES", $registrationNo) + $ro->getTotal("phic", "LABORATORY", $registrationNo) + $ro->getTotal("phic", "RADIOLOGY", $registrationNo) + $ro->getTotal("phic", "ECG", $registrationNo) + $ro->getTotal("phic", "NURSING-CHARGES", $registrationNo) + $ro->getTotal("phic", "MISCELLANEOUS", $registrationNo) + $ro->getTotal("phic", "OTHERS", $registrationNo) + $ro->getTotal("phic", "OR/DR/ER FEE", $registrationNo) + $ro->getTotal("phic", "Room And Board", $registrationNo) + $ro->getTotal("phic", "PROFESSIONAL FEE", $registrationNo); $ro->coconutTableStart(); $ro->coconutTableRowStart(); $ro->coconutTableHeader("Category"); $ro->coconutTableHeader("PhilHealth"); $ro->coconutTableRowStop(); $ro->coconutTableRowStart(); $ro->coconutTableData("MEDICINE"); $ro->coconutTableData(number_format($ro->getTotal("phic", "MEDICINE", $registrationNo), 2)); $ro->coconutTableRowStop(); $ro->coconutTableRowStart(); $ro->coconutTableData("SUPPLIES"); $ro->coconutTableData(number_format($ro->getTotal("phic", "SUPPLIES", $registrationNo), 2)); $ro->coconutTableRowStop(); $ro->coconutTableRowStart(); $ro->coconutTableData("LABORATORY"); $ro->coconutTableData(number_format($ro->getTotal("phic", "LABORATORY", $registrationNo), 2)); $ro->coconutTableRowStop(); $ro->coconutTableRowStart(); $ro->coconutTableData("RADIOLOGY"); $ro->coconutTableData(number_format($ro->getTotal("phic", "RADIOLOGY", $registrationNo), 2)); $ro->coconutTableRowStop(); $ro->coconutTableRowStart(); $ro->coconutTableData("ECG");
<?php include "../../myDatabase1.php"; $username = $_GET['username']; $month = $_GET['month']; $day = $_GET['day']; $year = $_GET['year']; $dept = $_GET['dept']; $ro = new database1(); echo "<br>"; echo "<Center>"; $ro->coconutTableStart(); $ro->coconutTableRowStart(); $ro->coconutTableHeader("Patient"); $ro->coconutTableHeader("Description"); $ro->coconutTableHeader("Balance"); $ro->coconutTableHeader("PhilHealth"); $ro->coconutTableHeader("Company"); $ro->coconutTableRowStop(); $ro->getCollectionPerDept($username, $month, $day, $year, $dept); $ro->getCollectionPerDept1($username, $month, $day, $year, $dept); $ro->coconutTableRowStart(); $ro->coconutTableData("<b>Total</b>"); $ro->coconutTableData(""); $ro->coconutTableData(number_format($ro->getCollectionPerDept_total, 2)); $ro->coconutTableData(number_format($ro->getCollectionPerDept_phic, 2)); $ro->coconutTableData(number_format($ro->getCollectionPerDept_company, 2)); $ro->coconutTableRowStop(); $ro->coconutTableStop();
echo "<center><font size=3>( {$month} {$year} )</font></center>"; echo "<center><br>"; echo "\n<style type='text/css'>\ntr:hover { background-color:yellow;color:black;}\n\na { text-decoration:none; color:black; }\n</style>"; $totalIncome = 0; $totalExpenses = 0; $ro->coconutTableStart(); $ro->coconutTableRowStart(); $ro->coconutTableHeader("Date"); $ro->coconutTableHeader("IPD"); $ro->coconutTableHeader("OPD"); $ro->coconutTableHeader("Income"); $ro->coconutTableHeader("Expenses"); $ro->coconutTableRowStop(); $ro->coconutTableRowStart(); $firstDay = $ro->getPxRevenueDaily_ipd($month, "01", $year) + $ro->getPxRevenueDaily_opd($month, "01", $year); $ro->coconutTableData(" {$month} 1, {$year} "); $ro->coconutTableData(number_format($ro->getPxRevenueDaily_ipd($month, "01", $year), 2)); $ro->coconutTableData(number_format($ro->getPxRevenueDaily_opd($month, "01", $year), 2)); $ro->coconutTableData(number_format($firstDay, 2)); $ro->coconutTableData(number_format($ro->getMonthlyExpenses($month, "01", $year) * 1000, 2)); $totalIncome += $firstDay; $totalExpenses += $ro->getMonthlyExpenses($month, "01", $year); $ro->coconutTableRowStop(); $ro->coconutTableRowStart(); $secondDay = $ro->getPxRevenueDaily_ipd($month, "02", $year) + $ro->getPxRevenueDaily_opd($month, "02", $year); $ro->coconutTableData(" {$month} 2, {$year} "); $ro->coconutTableData(number_format($ro->getPxRevenueDaily_ipd($month, "02", $year), 2)); $ro->coconutTableData(number_format($ro->getPxRevenueDaily_opd($month, "02", $year), 2)); $ro->coconutTableData(number_format($secondDay, 2)); $ro->coconutTableData(number_format($ro->getMonthlyExpenses($month, "02", $year) * 1000, 2)); $totalIncome += $secondDay;