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