<?php include "../../myDatabase.php"; $registrationNo = $_GET['registrationNo']; $ro = new database(); $ro->getPatientProfile($registrationNo); $ro->setPatientRecord($ro->getRegistrationDetails_patientNo()); echo "\n<style type='text/css'>\n.informationLabel {\nfont-size:15px;\nfont-weight:bold;\n}\n\n.initialDiagnosis {\n\tborder: 1px solid #CCC;\n\tcolor: #000;\n\theight:80px;\n\twidth: 350px;\n\tpadding:4px 4px 4px 2px;\n}\n\n\n</style>"; $room = preg_split("/\\_/", $ro->getRegistrationDetails_room()); echo "<br>"; if ($ro->getRegistrationDetails_dateUnregistered() == "") { echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/discharged/discharged.php?registrationNo={$registrationNo}&protoType=Discharged'><img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/unlock.jpeg'></a> <font size=2 color=red><b>" . $ro->getRegistrationDetails_type() . "</b></font><br>"; } else { echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/discharged/discharged.php?registrationNo={$registrationNo}&protoType=Undischarged'><img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/locked1.jpeg'></a> <font size=2 color=red><b>" . $ro->getRegistrationDetails_type() . "</b></font><br>"; } echo "<font class='informationLabel'>Patient No:</font> " . $ro->getRegistrationDetails_patientNo(); echo "<br><font class='informationLabel'>Registration No:</font> " . $ro->getRegistrationDetails_registrationNo(); echo "<br><font class='informationLabel'>Age:</font> " . $ro->getPatientRecord_age(); echo "<br><font class='informationLabel'>Civil Status:</font> " . $ro->getPatientRecord_civilStatus(); echo "<br><font class='informationLabel'>Birth Date:</font> " . $ro->getPatientRecord_Birthdate(); echo "<br><font class='informationLabel'>Contact No#:</font> " . $ro->getPatientRecord_contactNo(); echo "<br><font class='informationLabel'>Senior:</font> " . $ro->getPatientRecord_senior(); echo "<br><font class='informationLabel'>PhilHealth:</font> " . $ro->getPatientRecord_phic(); echo "<br><font class='informationLabel'>Company:</font> " . $ro->getRegistrationDetails_company(); echo "<br><font class='informationLabel'>Time Registered:</font> " . $ro->getRegistrationDetails_timeRegistered(); echo "<br><font class='informationLabel'>Date Registered:</font> " . $ro->getRegistrationDetails_dateRegistered(); echo "<br><font class='informationLabel'>Branch Registered:</font> " . $ro->getRegistrationDetails_branch(); echo "<br><font class='informationLabel'>Room:</font> " . $room[0]; echo "<br><font class='informationLabel'>Address:</font> " . $ro->getPatientRecord_address(); echo "<br><font class='informationLabel'>Registered By:</font> " . $ro->getRegistrationDetails_registeredBy(); if ($ro->getRegistrationDetails_dateUnregistered() != "") {
$ro->coconutTextBox("cashLimit",$ro->getRegistrationDetails_limitCASH()); echo "</td>"; echo "<tr>"; */ $ro->coconutHidden("cashLimit", ""); echo "<tr>"; echo "<td>" . $ro->coconutText("HMO Limit:") . "</td>"; echo "<td>"; $ro->coconutTextBox("hmoLimit", $ro->getRegistrationDetails_limitHMO()); echo "</td>"; echo "<tr>"; } else { $ro->coconutHidden("cashLimit", ""); $ro->coconutHidden("hmoLimit", ""); } echo "<input type=hidden name='room' value='" . $ro->getRegistrationDetails_room() . "'>"; } else { echo "<input type=hidden name='room' value='" . $ro->getRegistrationDetails_room() . "'>"; echo "<input type=hidden name='cashLimit' value=''>"; echo "<input type=hidden name='hmoLimit' value=''>"; } if ($ro->selectNow("registeredUser", "module", "username", $username) == "PHARMACY" || $ro->selectNow("registeredUser", "module", "username", $username) == "BILLING" || $ro->selectNow("registeredUser", "module", "username", $username) == "CASHIER") { echo "<tr>"; echo "<td>Cash Limit</td>"; echo "<td>"; $ro->coconutTextBox("CashLIMIT", $ro->selectNow("registrationDetails", "LimitCASH", "registrationNo", $registrationNo)); echo "</td>"; echo "</tr>"; } else { } if ($ro->getRegistrationDetails_dateUnregistered() != "") {
echo "<td>CaseType:</td><TD>" . $ro->getRegistrationDetails_caseType() . "</tD>"; echo "</tr>"; echo "<tr>"; echo "<Td>" . $ro->coconutText("Company") . ": </td><td> " . $ro->getRegistrationDetails_company() . "</td>"; echo "<td> </tD>"; echo "<Td>" . $ro->coconutText("Fx Diagnosis:") . ": </td><td> " . $ro->getRegistrationDetails_finalDiagnosis() . "</td>"; echo "</tr>"; echo "<tr>"; echo "<Td>" . $ro->coconutText("Admitted") . ": </td><td> " . $ro->getRegistrationDetails_dateRegistered() . "</td>"; echo "<td> </td>"; echo "<Td>" . $ro->coconutText("Discharged") . ": </td><td> " . $ro->getRegistrationDetails_dateUnregistered() . "</td>"; echo "</tr>"; echo "<tr>"; echo "<Td>" . $ro->coconutText("Age") . "</tD><td> " . $ro->getPatientRecord_age() . "</tD>"; echo "<tD> </tD>"; echo "<Td>" . $ro->coconutText("Room:") . "</tD><td>" . $ro->getRegistrationDetails_room() . "</tD>"; echo "</tr>"; echo "<tr>"; echo "<td>" . $ro->coconutText("Att.Doctor") . "</tD><td> <font size=2>" . $ro->getAttendingDoc($registrationNo, "Attending") . "</font></td>"; echo "<td></td>"; echo "<td>" . $ro->coconutText("Admitting Doc") . "</td><tD> <font size=2>" . $ro->getAttendingDoc($registrationNo, "Admitting") . "</font></tD>"; echo "</tr>"; echo "</table>"; 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>";
<?php include "../../../myDatabase.php"; session_start(); $registrationNo = $_GET['registrationNo']; $ro = new database(); $ro->getPatientProfile($registrationNo); $ro->coconutDesign(); $ro->coconutHeading("User Verification", "COCONUT/NURSING/initializeNursing.php"); unset($_SESSION['registrationNo']); session_destroy(); echo "<Br>"; echo "<center>"; $ro->coconutImages("lock2.jpeg"); echo " <font size=2 color=red>Pls Login first to access the Profile of " . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . " in " . $ro->getRegistrationDetails_room() . " </font>"; echo "<br>"; $ro->coconutFormStart("post", "verifyUser1.php"); $ro->coconutHidden("registrationNo", $registrationNo); $ro->coconutBoxStart("500", "150"); echo "<br><table border=0>"; echo "<tr>"; echo "<Td>" . $ro->coconutText("Username") . "</tD>"; echo "<td>"; $ro->coconutTextBox("username", ""); echo "</td>"; echo "</tr>"; echo "<tr>"; echo "<td>" . $ro->coconutText("Password") . "</td>"; echo "<td>"; echo "<input type=password name='password' class='txtBox' value=''>"; echo "</td>";
</script> <a href='#' onClick="printF('printData')" style="text-decoration:none;"><?php echo $ro->coconutImages("printer.jpeg"); ?> <font color=red>Print</font></a><Br><Br> <?php echo "<div id='printData'>"; echo "Reg#: " . $registrationNo . " Batch#: " . $dispensedNo; echo "<br>"; echo "Name: " . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName(); echo "<br>"; echo "PHIC:" . $ro->getPatientRecord_phic() . " + " . $ro->getRegistrationDetails_company(); echo "<br>"; echo "Date" . date("M d, Y") . " @ " . $ro->getSynapseTime(); echo "<Br>"; echo "Room:" . $ro->getRegistrationDetails_room(); echo "<br>"; echo "Pharmacy:" . $username; echo "<br>"; echo "Doctor:" . $ro->getAttendingDoc($registrationNo, "Attending"); echo "<table border=1 cellpadding=1 cellspacing=1>"; echo "<tr>"; echo "<th>Particulars</th>"; echo "<th>QTY</th>"; echo "</tr>"; for ($x = 0, $z = 0; $x < $disp, $z < $countz; $x++, $z++) { echo "<Tr>"; $dispense = preg_split("/\\_/", $dispensed[$x]); if ($ro->selectNow("patientCharges", "status", "itemNo", $remitted[$z]) == "PAID") { echo "<tD><b>(Pd)</b> " . $dispense[1] . " </td>"; } else {
$acount = mysql_num_rows($asql); if ($acount == 0) { $dateCharge = ""; $timeCharge = ""; $chargeBy = ""; } else { while ($afetch = mysql_fetch_array($asql)) { $dateCharge = $afetch['dateCharge']; $timeCharge = $afetch['timeCharge']; $chargeBy = $afetch['chargeBy']; } } $birthDatefmt = date("m/d/Y", strtotime($ro->getPatientRecord_birthDate())); $birthDate = explode("/", $birthDatefmt); $age = date("md", date("U", mktime(0, 0, 0, $birthDate[0], $birthDate[1], $birthDate[2]))) > date("md") ? date("Y") - $birthDate[2] - 1 : date("Y") - $birthDate[2]; if ($ro->getRegistrationDetails_room() == "") { $widthroom = "150"; } else { $widthroom = "auto"; } if ($ro->getRegistrationDetails_company() == "") { $widthcom = "150"; } else { $widthcom = "auto"; } echo "\n<div align='left'>\n <table width='100%' border='0' cellpadding='0' cellspacing='0'>\n <tr>\n <td><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n <tr>\n <td width='50%'><div align='left'><table border='0' cellspacing='0' cellpadding='0'>\n <tr>\n <td width='auto'><div align='left' class='couriernew13black'>Patient ID</div></td>\n <td width='10'><div align='center' class='couriernew13black'>:</div></td>\n <td width='auto' class='table1Bottom'><div align='left' class='couriernew15blackbold'>" . $ro->getRegistrationDetails_patientNo() . "</div></td>\n </tr>\n </table></div></td>\n <td width='50%'><div align='right'><table border='0' cellspacing='0' cellpadding='0'>\n <tr>\n <td width='auto'><div align='left' class='couriernew13black'>Date-Time Printed</div></td>\n <td width='10'><div align='center' class='couriernew13black'>:</div></td>\n <td width='auto' class='table1Bottom'><div align='left' class='couriernew15blackbold'>" . date("m/d/Y H:i") . "</div></td>\n </tr>\n </table></div></td>\n </tr>\n </table></td>\n </tr>\n <tr>\n <td height='6'></td>\n </tr>\n <tr>\n <td><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n <tr>\n <td width='auto'><div align='left'><table border='0' cellspacing='0' cellpadding='0'>\n <tr>\n <td width='auto'><div align='left' class='couriernew13black'>Patient Name</div></td>\n <td width='10'><div align='center' class='couriernew13black'>:</div></td>\n <td width='auto' class='table1Bottom'><div align='left' class='couriernew15blackbold'>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . " " . $ro->getPatientRecord_middleName() . "</div></td>\n </tr>\n </table></div></td>\n <td width='auto'><div align='right'><table border='0' cellspacing='0' cellpadding='0'>\n <tr>\n <td width='auto'><div align='left' class='couriernew13black'>Date-Time Requested</div></td>\n <td width='10'><div align='center' class='couriernew13black'>:</div></td>\n <td width='auto' class='table1Bottom'><div align='left' class='couriernew15blackbold'>" . date("m/d/Y", strtotime($dateCharge)) . " " . date("H:i", strtotime($timeCharge)) . "</div></td>\n </tr>\n </table></div></td>\n </tr>\n </table></td>\n </tr>\n <tr>\n <td height='6'></td>\n </tr>\n <tr>\n <td><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n <tr>\n <td width='auto'><div align='left'><table border='0' cellspacing='0' cellpadding='0'>\n <tr>\n <td width='auto'><div align='left' class='couriernew13black'>Date Of Birth</div></td>\n <td width='10'><div align='center' class='couriernew13black'>:</div></td>\n <td width='auto' class='table1Bottom'><div align='left' class='couriernew15blackbold'>" . date("M d, Y", strtotime($ro->getPatientRecord_birthDate())) . "</div></td>\n </tr>\n </table></div></td>\n <td width='auto'><div align='right'><table border='0' cellspacing='0' cellpadding='0'>\n <tr>\n <td width='auto'><div align='left' class='couriernew13black'>Requested By</div></td>\n <td width='10'><div align='center' class='couriernew13black'>:</div></td>\n <td width='150' class='table1Bottom'><div align='left' class='couriernew15blackbold'>{$chargeBy}</div></td>\n </tr>\n </table></div></td>\n </tr>\n </table></td>\n </tr>\n <tr>\n <td height='6'></td>\n </tr>\n <tr>\n <td><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n <tr>\n <td width='auto'><div align='left'><table border='0' cellspacing='0' cellpadding='0'>\n <tr>\n <td width='auto'><div align='left' class='couriernew13black'>Age</div></td>\n <td width='10'><div align='center' class='couriernew13black'>:</div></td>\n <td width='30' class='table1Bottom'><div align='left' class='couriernew15blackbold'>{$age}</div></td>\n <td width='10'></td>\n <td width='auto'><div align='left' class='couriernew13black'>Gender</div></td>\n <td width='10'><div align='center' class='couriernew13black'>:</div></td>\n <td width='80' class='table1Bottom'><div align='left' class='couriernew15blackbold'>" . strtoupper($ro->getPatientRecord_Gender()) . "</div></td>\n </tr>\n </table></div></td>\n <td width='auto'><div align='right'><table border='0' cellspacing='0' cellpadding='0'>\n <tr>\n <td width='auto'><div align='left' class='couriernew13black'>Physician</div></td>\n <td width='10'><div align='center' class='couriernew13black'>:</div></td>\n <td width='auto' class='table1Bottom'><div align='left' class='couriernew15blackbold'>" . $ro->getAttendingDoc($registrationNo, "ATTENDING") . "</div></td>\n </tr>\n </table></div></td>\n </tr>\n </table></td>\n </tr>\n <tr>\n <td height='6'></td>\n </tr>\n <tr>\n <td><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n <tr>\n <td width='auto'><div align='left'><table border='0' cellspacing='0' cellpadding='0'>\n <tr>\n <td width='auto'><div align='left' class='couriernew13black'>Room</div></td>\n <td width='10'><div align='center' class='couriernew13black'>:</div></td>\n <td width='{$widthroom}' class='table1Bottom'><div align='left' class='couriernew15blackbold'>" . $ro->getRegistrationDetails_room() . "</div></td>\n </tr>\n </table></div></td>\n <td width='auto'><div align='right'><table border='0' cellspacing='0' cellpadding='0'>\n <tr>\n <td width='auto'><div align='left' class='couriernew13black'>Company</div></td>\n <td width='10'><div align='center' class='couriernew13black'>:</div></td>\n <td width='{$widthcom}' class='table1Bottom'><div align='left' class='couriernew15blackbold'>" . $ro->getRegistrationDetails_company() . "</div></td>\n </tr>\n </table></div></td>\n </tr>\n </table></td>\n </tr>\n <tr>\n <td height='20'></td>\n </tr>\n <tr>\n <td><div align='left' class='couriernew15black'>REQUEST/S</div></td>\n </tr>\n <tr>\n <td height='10'></td>\n </tr>\n <tr>\n <td><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n <tr>\n <td width='auto'><div align='left' class='couriernew12black'>DESCRIPTION</div></td>\n </tr>\n"; $asql = mysql_query("SELECT description, timeCharge, remarks, chargeBy, status FROM patientCharges WHERE registrationNo = '{$registrationNo}' AND departmentStatus = '' AND title = 'LABORATORY' AND status NOT LIKE 'DELETED_%%%%%%' AND dateCharge='{$dateCharge}' "); while ($afetch = mysql_fetch_array($asql)) { echo "\n <tr>\n <td><div align='left' class='couriernew16blackbold'>" . $afetch['description'] . "</div></td>\n </tr>\n"; if ($afetch['remarks'] != "") { echo "\n <tr>\n <td valign='top'><div align='left' class='couriernew12black'>(" . $afetch['remarks'] . ")</div></td>\n </tr>\n";
} /* if($ro->getRegistrationDetails_room() != "OPD_OPD") { echo "<li><a href='http://".$ro->getMyUrl()."/COCONUT/patientProfile/creditLimit/viewCreditLimit.php?registrationNo=$registrationNo&username=$username' target='rightFrame'><font size=2>Credit Limit</font></a></li>"; }else { echo ""; } */ echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientCharges.php?registrationNo=" . $ro->getRegistrationDetails_registrationNo() . "&username={$username}&show=All&desc=' target='rightFrame'><font size=2>Charges</font></a></li>"; echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientChargesTitle.php?registrationNo={$registrationNo}&title=PROFESSIONAL FEE&username={$username}&show=&desc=' target='rightFrame'><font size=2>Doctor</font></a></li>"; echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientChargesTitle.php?registrationNo={$registrationNo}&title=LABORATORY&username={$username}&show=&desc=' target='rightFrame'><font size=2>Laboratory</font></a></li>"; echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientChargesTitle.php?registrationNo={$registrationNo}&title=RADIOLOGY&username={$username}&show=&desc=' target='rightFrame'><font size=2>Radiology</font></a></li>"; echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientChargesTitle.php?registrationNo={$registrationNo}&title=MEDICINE&username={$username}&show=&desc=' target='rightFrame'><font size=2>Medicine</font></a></li>"; echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientChargesTitle.php?registrationNo={$registrationNo}&title=SUPPLIES&username={$username}&show=&desc=' target='rightFrame'><font size=2>Supplies</font></a></li>"; echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientChargesTitle.php?registrationNo={$registrationNo}&title=OTHERS&username={$username}&show=&desc=' target='rightFrame'><font size=2>Others</font></a></li>"; if ($ro->getRegistrationDetails_room() != "OPD_OPD") { // enable room echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientChargesTitle.php?registrationNo={$registrationNo}&title=Room And Board&username={$username}&show=&desc=' target='rightFrame'><font size=2>Room</font></a></li>"; } else { //disable room echo ""; } echo "</ul>"; echo "<ul>"; if ($ro->checkCreditLimit($registrationNo) > 0 && $ro->getRegistrationDetails_type() == "IPD") { // kpg IPD check kung may creditLimit ang patient as "PATIENT" kung meron execute the limit.... //setter pra sa allowed credit limit ng ipd $ro->viewCreditLimit_setter($registrationNo, "PATIENT", "cashUnpaid", $username); //current balance ng patient $current = $ro->getCurrentCredit($registrationNo, $ro->viewCreditLimit_setter_limitTo(), $ro->viewCreditLimit_setter_limitVia()) - $ro->getCurrentPaid($registrationNo, $ro->viewCreditLimit_setter_limitTo(), $ro->viewCreditLimit_setter_limitVia()); if ($current <= $ro->viewCreditLimit_setter_amountLimit()) {
<?php include "../../myDatabase.php"; $registrationNo = $_GET['registrationNo']; $ro = new database(); $ro->getPatientProfile($registrationNo); $ro->setPatientRecord($ro->getRegistrationDetails_patientNo()); echo "\n<style type='text/css'>\n.informationLabel {\nfont-size:15px;\nfont-weight:bold;\n}\n\n.initialDiagnosis {\n\tborder: 1px solid #CCC;\n\tcolor: #000;\n\theight:80px;\n\twidth: 350px;\n\tpadding:4px 4px 4px 2px;\n}\n\n\n</style>"; $room = preg_split("/\\_/", $ro->getRegistrationDetails_room()); echo "<br>"; if ($ro->getRegistrationDetails_dateUnregistered() == "") { echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/discharged/discharged.php?registrationNo={$registrationNo}&protoType=Discharged&room=" . $ro->getRegistrationDetails_room() . "'><img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/unlock.jpeg'></a> <font size=2 color=red><b>" . $ro->getRegistrationDetails_type() . "</b></font><br>"; } else { echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/discharged/discharged.php?registrationNo={$registrationNo}&protoType=Undischarged&room='><img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/locked1.jpeg'></a> <font size=2 color=red><b>" . $ro->getRegistrationDetails_type() . "</b></font><br>"; } echo "<font class='informationLabel'>Patient No:</font> " . $ro->getRegistrationDetails_patientNo(); echo "<br><font class='informationLabel'>Registration No:</font> " . $ro->getRegistrationDetails_registrationNo(); echo "<br><font class='informationLabel'>Age:</font> " . $ro->getPatientRecord_age(); echo "<br><font class='informationLabel'>Gender:</font> " . $ro->getPatientRecord_gender(); echo "<br><font class='informationLabel'>Civil Status:</font> " . $ro->getPatientRecord_civilStatus(); echo "<br><font class='informationLabel'>Birth Date:</font> " . $ro->getPatientRecord_Birthdate(); echo "<br><font class='informationLabel'>Contact No#:</font> " . $ro->getPatientRecord_contactNo(); echo "<br><font class='informationLabel'>Senior:</font> " . $ro->getPatientRecord_senior(); echo "<br><font class='informationLabel'>PhilHealth:</font> " . $ro->getPatientRecord_phic(); echo "<br><font class='informationLabel'>PhilHealth Type:</font> " . $ro->getPHICtype_patientRecord(); echo "<br><font class='informationLabel'>Company:</font> " . $ro->getRegistrationDetails_company(); echo "<br><font class='informationLabel'>Time Registered:</font> " . $ro->getRegistrationDetails_timeRegistered(); echo "<br><font class='informationLabel'>Date Registered:</font> " . $ro->getRegistrationDetails_dateRegistered(); echo "<br><font class='informationLabel'>Branch Registered:</font> " . $ro->getRegistrationDetails_branch(); echo "<br><font class='informationLabel'>Case Type:</font> <a href='#' style='text-decoration:none; color:black;'>" . $ro->getRegistrationDetails_caseType() . "</a>"; echo "<br><font class='informationLabel'>Package:</font> <a href='#' style='text-decoration:none; color:black;'>" . $ro->getRegistrationDetails_package() . "</a>";
if ($ro->getTotal("phic", "PROFESSIONAL FEE", $registrationNo) > 0) { $pf_phic += $ro->getPatient_phic(); } else { } if ($ro->getTotal("company", "PROFESSIONAL FEE", $registrationNo) > 0) { $pf_company += $ro->getPatient_company(); } else { } if ($ro->getTotal("cashUnpaid", "PROFESSIONAL FEE", $registrationNo) > 0) { $pf_cash += $ro->getPatient_cashUnpaid(); } else { } /*****************************************************/ /************* DISCOUNT ******************************/ $patientDiscount = 0; if ($ro->getRegistrationDetails_discount() != "") { $patientDiscount = $ro->getRegistrationDetails_discount(); } else { $patientDiscount = "0.00"; } /*****************************************************/ /***************** PAYMENT **************************/ $ro->getPaymentHistory_showUp_returnPaid_setter($registrationNo); /****************************************************/ $gross = $hospitalBill_cash - $ro->getPaymentHistory_showUp_returnPaid(); $grandTotal = $gross - $ro->getRegistrationDetails_discount() + $pf_cash; $content = "\n<div align='center' style='border:0px solid #000000; width:700px; height:auto; border-color:black black black black;' >\n<font size=5><b>" . $ro->getReportInformation("hmoSOA_name") . "</b></font>\n<br><font size=2>" . $ro->getReportInformation("hmoSOA_address") . "</font>\n<br><br>\n</div>\n<table >\n<tr>\n<td><b>" . $ro->coconutText("Name") . ":</b> </td><td> " . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</td>\n<td> </td><td>" . $ro->coconutText("Reg#") . "</td><td> {$registrationNo}</td>\n</tr>\n\n<tr>\n<Td><b>" . $ro->coconutText("PHIC") . ":</b> </td><td> " . $ro->getPatientRecord_phic() . "</td>\n<td> </td>\n<td><b>CaseType:</b></td><TD>" . $ro->getRegistrationDetails_caseType() . "</tD>\n</tr>\n\n<tr>\n<Td><b>" . $ro->coconutText("Company") . ":</b> </td><td> " . $ro->getRegistrationDetails_company() . "</td>\n<td> </tD>\n<Td><b>" . $ro->coconutText("Fx Diagnosis:") . ":</b> </td><td> " . $ro->getRegistrationDetails_finalDiagnosis() . "</td>\n</tr>\n\n<tr>\n<Td><b>" . $ro->coconutText("Admitted") . ":</b> </td><td> " . $ro->getRegistrationDetails_dateRegistered() . "</td>\n<td> </td>\n<Td><b>" . $ro->coconutText("Discharged") . ":</b> </td><td> " . $ro->getRegistrationDetails_dateUnregistered() . "</td>\n</tr>\n\n<tr>\n<Td><b>" . $ro->coconutText("Age") . ":</b></tD><td> " . $ro->getPatientRecord_age() . "</tD>\n<tD> </tD>\n<Td><b>" . $ro->coconutText("Room:") . "</b></tD><td>" . $ro->getRegistrationDetails_room() . "</tD>\n</tr>\n\n<tr>\n<td><b>" . $ro->coconutText("Att.Doctor") . ":</b></tD><td> <font size=2>" . $ro->getAttendingDoc($registrationNo, "Attending") . "</font></td>\n<td></td>\n<td><b>" . $ro->coconutText("Admitting Doc") . ":</b></td><tD> <font size=2>" . $ro->getAttendingDoc($registrationNo, "Admitting") . "</font></tD>\n</tr>\n</table>\n\n<table>\n<td><b>Address:</b> </tD>\n<tD>" . $ro->getPatientRecord_address() . "</tD>\n</table>\n\n<br><br>\n\n<table border=1 cellpadding=1 cellspacing=0>\n<tr>\n<th> Particular </th>\n<th> Actual </th>\n<th> PhilHealth </th>\n<th> Company </th>\n<th> Cash </th>\n</tr>\n\n<tr>\n<td> Medicine </td>\n<Td> {$medActual}</td>\n<td> {$medPHIC}</td>\n<td> {$medCompany}</td>\n<td> {$medCash}</td>\n</tr>\n\n\n<Tr>\n<td> Supplies</td>\n<td> {$supActual}</td>\n<td> {$supPHIC}</td>\n<td> {$supCompany}</td>\n<Td> {$supCash}</td>\n</tr>\n\n<Tr>\n<td> Laboratory</td>\n<td> {$labActual}</td>\n<td> {$labPHIC}</td>\n<td> {$labCompany}</td>\n<Td> {$labCash}</td>\n</tr>\n\n<Tr>\n<td> Radiology</td>\n<td> {$radActual}</td>\n<td> {$radPHIC}</td>\n<td> {$radCompany}</td>\n<Td> {$radCash}</td>\n</tr>\n\n<Tr>\n<td> Nursing Charges</td>\n<td> {$nsChargesActual}</td>\n<td> {$nsChargesPHIC}</td>\n<td> {$nsChargesCompany}</td>\n<Td> {$nsChargesCash}</td>\n</tr>\n\n<Tr>\n<td> Miscellaneous</td>\n<td> {$miscActual}</td>\n<td> {$miscPHIC}</td>\n<td> {$miscCompany}</td>\n<Td> {$miscCash}</td>\n</tr>\n\n<Tr>\n<td> Others</td>\n<td> {$othersActual}</td>\n<td> {$othersPHIC}</td>\n<td> {$othersCompany}</td>\n<Td> {$othersCash}</td>\n</tr>\n\n<Tr>\n<td> OR/DR/ER Fee</td>\n<td> {$orActual}</td>\n<td> {$orPHIC}</td>\n<td> {$orCompany}</td>\n<Td> {$orCash}</td>\n</tr>\n\n<Tr>\n<td> Rehab</td>\n<td> {$rehabActual}</td>\n<td> {$rehabPHIC}</td>\n<td> {$rehabCompany}</td>\n<Td> {$rehabCash}</td>\n</tr>\n\n<Tr>\n<td><font size=2>Room @ " . $ro->getQTY_room($registrationNo) . " day(s)</font> </td>\n<td> {$roomActual}</td>\n<td> {$roomPHIC}</td>\n<td> {$roomCompany}</td>\n<Td> {$roomCash}</td>\n</tr>\n\n<Tr>\n<td> <b>Hospital Bill</b></tD>\n<td> <b>" . number_format($hospitalBill_gt, 2) . "</b></tD>\n<td> <b>" . number_format($hospitalBill_phic, 2) . "</b></tD>\n<td> <b>" . number_format($hospitalBill_company, 2) . "</b></tD>\n<td> <b>" . number_format($hospitalBill_cash, 2) . "</b></tD>\n</tr>\n\n<Tr>\n<td> </tD>\n<td> </tD>\n<td> </tD>\n<td> </tD>\n<td> </tD>\n</tr>\n\n<tr>\n<td> </tD>\n<td> </tD>\n<td> </tD>\n<td> </tD>\n<td> </tD>\n</tr>\n\n" . $ro->getPatientDoc_soa2pdf($registrationNo) . "\n\n<tr>\n<td> <b>Professional Fee</b></tD>\n<td> <b>" . number_format($pf_gt, 2) . "</b></tD>\n<td> <b>" . number_format($pf_phic, 2) . "</b></tD>\n<td> <b>" . number_format($pf_company, 2) . "</b></tD>\n<td> <b>" . number_format($pf_cash, 2) . "</b></tD>\n</tr>\n\n\n<Tr>\n<td> </tD>\n<td> </tD>\n<td> </tD>\n<td> </tD>\n<td> </tD>\n</tr>\n\n<tr>\n<td> </tD>\n<td> </tD>\n<td> </tD>\n<td> </tD>\n<td> </tD>\n</tr>\n\n\n<tr>\n<td> <b>Total</b></tD>\n<td> <b>" . number_format($hospitalBill_gt + $pf_gt, 2) . "</b></tD>\n<td> <b>" . number_format($hospitalBill_phic + $pf_phic, 2) . "</b></tD>\n<td> <b>" . number_format($hospitalBill_company + $pf_company, 2) . "</b></tD>\n<td> <b>" . number_format($hospitalBill_cash + $pf_cash, 2) . "</b></tD>\n</tr>\n\n\n<tr>\n<td> <b>Discount</b></tD>\n<td> </tD>\n<td> </tD>\n<td> </tD>\n<td> <b>" . number_format($patientDiscount, 2) . "</b></tD>\n</tr>\n\n<tr>\n<td> <b>Grand Total</b></tD>\n<td> </tD>\n<td> </tD>\n<td> </tD>\n<td> <b>" . number_format($grandTotal, 2) . "</b></tD>\n</tr>\n\n<tr>\n<td> <b>Payments</b></tD>\n<td> </tD>\n<td> </tD>\n<td> </tD>\n<td> <b>" . number_format($ro->getPaymentHistory_showUp_returnPaid(), 2) . "</b></tD>\n</tr>\n\n<tr>\n<td> </td>\n<td> </td>\n<td> </td>\n<td> </td>\n<td> </td>\n</tr>\n\n\n<tr>\n<td> <b>BALANCE</b></td>\n<td> </td>\n<td> </td>\n<td> </td>\n<td> <b> " . number_format($hospitalBill_cash + $pf_cash - $ro->getPaymentHistory_showUp_returnPaid(), 2) . " </b></td>\n</tr>\n\n</table>\n\n<br><br><br><br>\n<hr>\n<br><br>\n\n<Table>\n\n<td style='width:90%;'>\n<font size=2><u>MYNARD A. BAJO</u><Br><b>Billing Officer</b></font>\n</td>\n\n\n<td> </td>\n<td> </td>\n<td> </td>\n<td> </td>\n<td> </td>\n<td> </td>\n<td> </td>\n<td> </td>\n<td> </td>\n<td> </td>\n<td> </td>\n<td> </td>\n<td> </td>\n\n\n\n\n\n<td>\n<font size=2><u>HAZEL S. CASTIGADOR</u><Br><b>Medical Clerk</b></font>\n</td>\n\n\n<tr>\n<td> </td>\n</tr>\n<tr>\n<td> </td>\n</tr>\n<tr>\n<td> </td>\n</tr>\n<tr>\n<td> </td>\n</tr>\n<tr>\n<td> </td>\n</tr>\n\n<tr>\n<td> </td>\n<td> </td>\n<td> </td>\n<td> </td>\n<td> </td>\n<td> </td>\n<td> </td>\n<td> </td>\n<td> </td>\n\n<tD> \n<font size=2>Certified Correct:<br></font>\n<br>\n<font size=2><u>MARIBETH B. SANDIG</u><Br><b>Hospital Administrator</b></font>\n</tD>\n</tr>\n</table>\n\n<br><br><br><br><br><br><br>\n\n\n\n\n\n"; $pdfFile = "/opt/lampp/htdocs/SOA_" . $ro->getPatientRecord_lastName() . "_" . $ro->getPatientRecord_firstName() . "-" . $registrationNo . ".pdf"; $html2pdf->WriteHTML($content); $html2pdf->Output($pdfFile); //echo "<table border=1>".$ro->getPatientDoc_soa2pdf($registrationNo)."</table>"
.astyle {text-decoration: none;} .table1Bottom {border-bottom: 1px solid #000000;} </style> </head> <body> <?php include "../../myDatabase2.php"; $ro = new database(); $registrationNo = $_GET['registrationNo']; $dateCharge = $_GET['dateCharge']; mysql_connect($ro->myHost(), $ro->getUser(), $ro->getPass()); mysql_select_db($ro->getDB()); $ro->getPatientProfile($registrationNo); $birthDatefmt = date("m/d/Y", strtotime($ro->getPatientRecord_birthDate())); $birthDate = explode("/", $birthDatefmt); $age = date("md", date("U", mktime(0, 0, 0, $birthDate[0], $birthDate[1], $birthDate[2]))) > date("md") ? date("Y") - $birthDate[2] - 1 : date("Y") - $birthDate[2]; echo "\n<div align='left'>\n <table width='345' border='0' cellpadding='0' cellspacing='0' bordercolor='#000000'>\n <tr>\n <td valign='top'><table width='100%' border='0' cellpadding='0' cellspacing='0' bordercolor='#000000'>\n <tr>\n <td valign='top'><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n <tr>\n <td height='6' colspan='6'></td>\n </tr>\n <tr>\n <td width='80'><div align='left' class='couriernew11black'> Patient ID</div></td>\n <td width='6'><div align='center' class='couriernew11black'>:</div></td>\n <td width='75'><div align='left' class='couriernew13blackbold'><u>" . $ro->getRegistrationDetails_patientNo() . "</u></div></td>\n <td width='35'><div align='left' class='couriernew11black'>Date</div></td>\n <td width='6'><div align='center' class='couriernew11black'>:</div></td>\n <td width='auto'><div align='right' class='couriernew10blackbold'><u>" . date("m/d/Y - H:i:s") . "</u> </div></td>\n </tr>\n <tr>\n <td height='6' colspan='6'></td>\n </tr>\n </table></td>\n </tr>\n <tr>\n <td valign='top'><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n <tr>\n <td height='10'><div align='left' class='couriernew12black'> Patient Name:</div></td>\n </tr>\n <tr>\n <td width='auto'><div align='left' class='couriernew14blackbold'> <u>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . " " . $ro->getPatientRecord_middleName() . " </u></div></td>\n </tr>\n </table></td>\n </tr>\n <tr>\n <td valign='top'><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n <tr>\n <td height='10' colspan='6'></td>\n </tr>\n <tr>\n <td width='45'><div align='left' class='couriernew12black'> B-Date</div></td>\n <td width='6'><div align='center' class='couriernew12black'>:</div></td>\n <td width='196'><div align='left' class='couriernew12blackbold'><u>" . $ro->getPatientRecord_birthDate() . "</u></div></td>\n <td width='50'><div align='left' class='couriernew12black'>Age/Sex</div></td>\n <td width='6'><div align='center' class='couriernew12black'>:</div></td>\n <td width='auto'><div align='right' class='couriernew12blackbold'><u>{$age}/" . strtoupper($ro->getPatientRecord_Gender()) . "</u> </div></td>\n </tr>\n </table></td>\n </tr>\n <tr>\n <td valign='top'><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n <tr>\n <td height='6' colspan='3'></td>\n </tr>\n <tr>\n <td width='55'><div align='left' class='couriernew12black'> Physician</div></td>\n <td width='6'><div align='center' class='couriernew12black'>:</div></td>\n <td width='auto'><div align='left' class='couriernew12blackbold'><u>" . $ro->getAttendingDoc($registrationNo, "ATTENDING") . "</u></div></td>\n </tr>\n </table></td>\n </tr>\n <tr>\n <td valign='top'><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n <tr>\n <td height='6' colspan='3'></td>\n </tr>\n <tr>\n <td width='30'><div align='left' class='couriernew12black'> Room</div></td>\n <td width='6'><div align='center' class='couriernew12black'>:</div></td>\n <td width='auto'><div align='left' class='couriernew12blackbold'><u>" . $ro->getRegistrationDetails_room() . "</u> </div></td>\n </tr>\n </table></td>\n </tr>\n <tr>\n <td valign='top'><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n <tr>\n <td height='20'></td>\n </tr>\n <tr>\n <td><div align='center'><table width='100%' border='0' cellpadding='0' cellspacing='0'>\n <tr>\n <td width='auto'><div align='left' class='couriernew10blackbold'> Description </div></td>\n </tr>\n"; $asql = mysql_query("SELECT description,timeCharge,remarks,chargeBy,status FROM patientCharges WHERE registrationNo = '{$registrationNo}' AND departmentStatus = '' AND title = 'LABORATORY' AND status NOT LIKE 'DELETED_%%%%%%' AND dateCharge='{$dateCharge}' "); while ($afetch = mysql_fetch_array($asql)) { echo "\n <tr>\n <td valign='top'><div align='left' class='couriernew14blackbold'> " . $afetch['description'] . " </div></td>\n </tr>\n"; if ($afetch['remarks'] != "") { echo "\n <tr>\n <td valign='top'><div align='left' class='couriernew11black'> (" . $afetch['remarks'] . ") </div></td>\n </tr>\n"; } } echo "\n </table></div></td>\n </tr>\n </table></td>\n </tr>\n </table></td>\n </tr>\n </table>\n</div>\n"; ?> </body> </html>
<a href='#' onClick="printF('printData')" style="text-decoration:none;"><?php echo $ro->coconutImages("printer.jpeg"); ?> <font color=red>Print</font></a><Br><Br> <?php echo "<div id='printData'>"; echo "\n<style type='text/css'>\n<!--\n.style1 {font-family: Arial;font-size: 16px;color: #000000;font-weight: bold;}\n.style2 {font-family: 'Times New Roman';font-size: 16px;color: #FF0000;font-weight: bold;}\n.style3 {text-decoration: none;font-family: Arial;font-size: 12px;color: #000000;font-weight: bold;}\n.style4 {font-family: Arial;font-size: 12px;color: #000000;font-weight: bold;}\n.style5 {font-family: Arial;font-size: 14px;color: #000000;}\n.style6 {font-family: Arial;font-size: 12px;color: #FFFFFF;}\n.style7 {font-family: Arial;font-size: 11px;color: #000000;}\n.style8 {font-family: Arial;font-size: 12px;color: #FFFFFF;font-weight: bold;}\n-->\n</style>\n"; echo "<span class='style4'>Reg#: </span><span class='style5'>" . $registrationNo . "</span><span class='style4'> Batch#: </span><span class='style5'>" . $dispensedNo . "</span>"; echo "<br>"; echo "<span class='style4'>Name: </span><span class='style5'>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</span>"; echo "<br>"; echo "<span class='style4'>PHIC: </span><span class='style5'>" . $ro->getPatientRecord_phic() . " + " . $ro->getRegistrationDetails_company() . "</span>"; echo "<br>"; echo "<span class='style4'>Date: </span><span class='style5'>" . date("M d, Y") . " @ " . $ro->getSynapseTime() . "</span>"; echo "<Br>"; echo "<span class='style4'>Room: </span><span class='style5'>" . $ro->getRegistrationDetails_room() . "</span>"; echo "<br>"; echo "<span class='style4'>Pharmacy: </span><span class='style5'>" . $username . "</span>"; echo "<br>"; echo "<span class='style4'>Doctor: </span><span class='style5'>" . $ro->getAttendingDoc($registrationNo, "Attending") . "</span>"; echo "<br /><br />"; echo "<table border=1 bordercolor=black cellpadding=0 cellspacing=0>"; echo "<tr>"; echo "<td class='style4'> Particulars </td>"; echo "<td class='style4'> QTY </td>"; echo "</tr>"; for ($x = 0, $z = 0; $x < $disp, $z < $countz; $x++, $z++) { if ($ro->selectNow("patientCharges", "dispensedNo", "itemNo", $remitted[$z]) == "") { $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $remitted[$z], "dispensedNo", $dispensedNo); } else { }
<form id="form1" name="form1" method="post" action=""> <table width="800" border="0" cellspacing="1" cellpadding="1"> <tr> <td width="100" height="27"><b>Name:</b></td> <td width="230"><?php echo $ro->getPatientRecord_completeName(); ?> </td> <td width="70"><b>Age:</b></td> <td width="157"><?php echo $ro->getPatientRecord_Age(); ?> </td> <td width="101"><b>Room:</b></td> <td width="123"><?php echo $ro->getRegistrationDetails_room(); ?> </td> </tr> <tr> <td><b>Reg. No:</b> </td> <td><?php echo $registrationNo; ?> </td> <td><B>Sex:</b></td> <td><?php echo $ro->getPatientRecord_gender(); ?> </td> <td><b>Request Date:</b> </td>