echo "<center>"; $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(" ");
echo "<th>Date</th>"; echo "<th>Examinations</th>"; echo "<th>Total</th>"; echo "<th>Rebate</th>"; $ro->coconutTableRowStop(); $ro->coconutTableRowStart(); $ro->getPxNameByAttendingDoctor($doctorCode,$date,$date1,"IPD"); $ro->coconutTableRowStop(); $ro->coconutTableStop(); */ echo "OPD Patients"; $ro->coconutTableStart(); $ro->coconutTableRowStart(); echo "<th>Patient</th>"; echo "<th>Date</th>"; echo "<th>Examinations</th>"; echo "<th>Total</th>"; echo "<th>Rebate</th>"; $ro->coconutTableRowStop(); $ro->coconutTableRowStart(); $ro->getPxNameByAttendingDoctor($doctorCode, $date, $date1, "OPD", $title); $ro->coconutTableRowStop(); $ro->coconutTableRowStart(); $ro->coconutTableData("<b>Total</b>"); $ro->coconutTableData(""); $ro->coconutTableData(""); $ro->coconutTableData(" " . number_format($ro->getPxChargesByHorizontal_grandTotal(), 2)); $ro->coconutTableData(" " . number_format($ro->getPxNameBasedOnDateCharged_rebateTotal(), 2)); $ro->coconutTableRowStop(); $ro->coconutTableStop();
$ro->coconutTableStart(); $ro->coconutTableRowStart(); $ro->coconutTableHeader(" "); $ro->coconutTableHeader("Patient"); $ro->coconutTableHeader("LABORATORY"); $ro->coconutTableHeader("RADIOLOGY"); $ro->coconutTableHeader("MEDICINE"); $ro->coconutTableHeader("SUPPLIES"); $ro->coconutTableHeader("BLOODBANK"); $ro->coconutTableHeader("NBS"); $ro->coconutTableHeader("MISCLLANEOUS"); $ro->coconutTableHeader("NURSING CARE"); $ro->coconutTableHeader("ECG"); $ro->coconutTableRowStop(); $ro->coconutTableRowStart(); $ro->coconutTableData(" "); $ro->coconutTableData(" "); $ro->coconutTableData(" "); $ro->coconutTableData(" "); $ro->coconutTableData(" "); $ro->coconutTableData(" "); $ro->coconutTableData(" "); $ro->coconutTableData(" "); $ro->coconutTableData(" "); $ro->coconutTableData(" "); $ro->coconutTableData(" "); $ro->coconutTableRowStop(); $ro->coconutTableRowStart(); $ro->coconutTableData(" <B>Discharged</b>"); $ro->coconutTableData(" <font color=red><b>Charge To Bill</b></font>"); $ro->coconutTableData(" ");
} } } $ro = new database2(); $totalz = 0; echo "<Center><font size=4><B>{$description}</b></font><br><font size=2>({$monthWord} {$year})</font> <br>"; echo "<Br><font color=red>Consumed by Patient</font>"; $ro->coconutTableStart(); $ro->coconutTableRowStart(); $ro->coconutTableHeader("Date"); $ro->coconutTableHeader("Quantity"); $ro->coconutTableRowStop(); for ($x = 1; $x < 32; $x++) { if ($x < 10) { $ro->coconutTableRowStart(); $ro->coconutTableData($monthWord . " {$x}," . $year); $ro->coconutTableData($ro->getFastMovingChart($month, "0" . $x, $year, $description, "All", $inventoryCode)); $totalz += $ro->getFastMovingChart($month, "0" . $x, $year, $description, "All", $inventoryCode); $ro->coconutTableRowStop(); } else { $ro->coconutTableRowStart(); $ro->coconutTableData($monthWord . " {$x}," . $year); $ro->coconutTableData($ro->getFastMovingChart($month, $x, $year, $description, "All", $inventoryCode)); $totalz += $ro->getFastMovingChart($month, $x, $year, $description, "All", $inventoryCode); $ro->coconutTableRowStop(); } } $ro->coconutTableRowStart(); $ro->coconutTableData("<b>TOTAL</b>"); $ro->coconutTableData($totalz); $ro->coconutTableRowStop();
<?php include "../../myDatabase2.php"; $month = $_GET['month']; $day = $_GET['day']; $year = $_GET['year']; $month1 = $_GET['month1']; $day1 = $_GET['day1']; $year1 = $_GET['year1']; $ro = new database2(); echo "<br><Br>"; echo "<center><font size=5>PhilHealth Receivable for PHARMACY</font></center>"; echo "<center><font size=3>( {$month} {$day}, {$year} - {$month1} {$day1}, {$year1} )</font></center>"; echo "<Br>"; echo "<center>"; $ro->coconutTableStart(); $ro->coconutTableRowStart(); $ro->coconutTableHeader("Discharged"); $ro->coconutTableHeader("Patient"); $ro->coconutTableHeader("MEDICINE"); $ro->coconutTableHeader("SUPPLIES"); $ro->coconutTableRowStop(); $ro->discharged_name($month, $day, $year, $month1, $day1, $year1); $ro->coconutTableRowStart(); $ro->coconutTableData("<b>TOTAL</b>"); $ro->coconutTableData(""); $ro->coconutTableData(" <B>" . number_format($ro->discharged_name_medicine(), 2) . "</b>"); $ro->coconutTableData(" <B>" . number_format($ro->discharged_name_supplies(), 2) . "</b>"); $ro->coconutTableRowStop(); $ro->coconutTableStop();