while ($row = mysql_fetch_array($result)) { if ($row['firstName'] == "N/A") { } else { echo "<Tr id='rowz'>"; $ro->censusRegistered_patient += 1; $ro->coconutTableData("<span class='style4'>" . $row['lastName'] . " " . $row['firstName'] . " " . $row['middleName'] . "</span>"); $ro->coconutTableData("<span class='style4'>" . $row['Age'] . "</span>"); $ro->coconutTableData("<span class='style4'>" . strtoupper($row['Gender']) . "</span>"); //$ro->coconutTableData("<span class='style4'>".$ro->selectNow("Doctors","Specialization1","Name",$ro->getAttendingDoc($row['registrationNo'],"ATTENDING"))."</span>"); if ($row['phic'] == "YES") { $ro->coconutTableData("<span class='style4'>NH</span>"); } else { $ro->coconutTableData("<span class='style4'>NN</span>"); } $ro->coconutTableData("<span class='style4'>" . $row['Company'] . "</span>"); $ro->coconutTableData("<span class='style4'>" . $ro->getAttendingDoc($row['registrationNo'], "ATTENDING") . "</span>"); $ro->coconutTableData("<span class='style4'>" . ($type = $ro->selectNow("registrationDetails", "room", "registrationNo", $row['registrationNo']) . "</span>")); $ro->coconutTableData("<span class='style4'>" . $row['timeRegistered'] . "@" . $row['dateRegistered'] . "</span>"); $ro->coconutTableData("<span class='style4'>" . $row['registeredBy'] . "</span>"); $ro->coconutTableData("<a href='http://" . $ro->getMyUrl() . "/COCONUT/Reports/Census/registrationCensusDelete.php?username={$username}®istrationNo={$row['registrationNo']}&fromMonth={$fromMonth}&fromDay={$fromDay}&fromYear={$fromYear}&toMonth={$toMonth}&toDay={$toDay}&toYear={$toYear}&type={$type}&dept={$dept}'><img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/delete.jpeg'></a>"); echo "</tr>"; } } $ro->coconutTableData("<span class='style2'>TOTAL PATIENT</span>"); $ro->coconutTableData("<span class='style2'>" . $ro->censusRegistered_patient . "</span>"); $ro->coconutTableData(""); $ro->coconutTableData(""); $ro->coconutTableData(""); $ro->coconutTableData(""); $ro->coconutTableData(""); $ro->coconutTableData("");
echo "<th class='header'>Service</th>"; echo "<th class='header'>PHIC</th>"; echo "<th class='header'>Insurance</th>"; echo "<th class='header'>Attending</th>"; echo "<th class='header'>Registered</th>"; echo "<th class='header'>Registered By</th>"; echo "</tr>"; while ($row = mysqli_fetch_array($result)) { if ($row['firstName'] == "N/A") { } else { echo "<Tr id='rowz'>"; $ro->censusRegistered_patient += 1; echo "<td>" . $row['lastName'] . " " . $row['firstName'] . " " . $row['middleName'] . "</td>"; echo "<td>" . $row['Age'] . "</td>"; echo "<td>" . $row['Gender'] . "</td>"; echo "<td>" . $ro->selectNow("Doctors", "Specialization1", "Name", $ro->getAttendingDoc($row['registrationNo'], "ATTENDING")) . "</td>"; if ($row['phic'] == "YES") { echo "<td>NH</td>"; } else { echo "<td>NN</td>"; } echo "<td>" . $row['Company'] . "</td>"; echo "<td>" . $ro->getAttendingDoc($row['registrationNo'], "ATTENDING") . "</td>"; echo "<td>" . $row['timeRegistered'] . "@" . $row['dateRegistered'] . "</td>"; echo "<td>" . $row['registeredBy'] . "</td>"; echo "</tr>"; } } echo "<tr>"; echo "<td>Total Patient</td>"; echo "<td>" . $ro->censusRegistered_patient . "</td>";
} else { $dateUnregisteredstr = strtotime($dateUnregistered); $dateUnregisteredfmt = date("m/d/Y", $dateUnregisteredstr) . "-"; } $Birthdatestr = strtotime($Birthdate); $Birthdatefmt = date("m/d/Y", $Birthdatestr); $agedatefmt = date("m/d/Y", $Birthdatestr); $birthDate = explode("/", $agedatefmt); $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]; $bsql = mysql_query("SELECT description FROM patientCharges WHERE registrationNo='{$registrationNo}' AND (status NOT LIKE 'Discharged' OR status NOT LIKE 'DELETED_%%%%') AND title='Room And Board' ORDER BY dateCharge"); $bcount = mysql_num_rows($bsql); if ($bcount == 0) { $room = "No Room Assigned"; } else { while ($bfetch = mysql_fetch_array($bsql)) { $room = $bfetch['description']; } } $num++; if ($num < 10) { $numfmt = "0" . $num; } else { $numfmt = $num; } echo "\n <tr>\n <form name='Submit' method='post' action='../COCONUT/currentPatient/patientInterface1.php' target='_blank'>\n <input type='hidden' name='username' value='{$username}' />\n <input type='hidden' name='registrationNo' value='{$registrationNo}' />\n <td class='table1Bottom'><div align='left' class='style5'><input name='rno' type='submit' class='button01' value='{$registrationNo}' /></di></td>\n </form>\n <td class='table1Bottom1Left'><div align='center' class='style5'> {$dateRegisteredfmt} </di></td>\n <td class='table1Bottom1Left'><div align='center' class='style5'> {$timeRegistered} </di></td>\n <form name='Submit' method='post' action='../COCONUT/currentPatient/patientInterface1.php' target='_blank'>\n <input type='hidden' name='username' value='{$username}' />\n <input type='hidden' name='registrationNo' value='{$registrationNo}' />\n <td class='table1Bottom1Left'><div align='left' class='style5'> <input type='submit' name='name' class='button01' value='" . strtoupper($patientname) . "' /></di></td>\n </form>\n <td class='table1Bottom1Left'><div align='center' class='style5'> {$Birthdatefmt} </di></td>\n <td class='table1Bottom1Left'><div align='center' class='style5'> {$age} </di></td>\n <td class='table1Bottom1Left'><div align='center' class='style5'> {$sex} </di></td>\n <td class='table1Bottom1Left'><div align='left' class='style5'> " . strtoupper($Address) . " </di></td>\n <td class='table1Bottom1Left'><div align='center' class='style5'> {$phicfmt} </di></td>\n <td class='table1Bottom1Left'><div align='left' class='style5'> " . strtoupper($initialDiagnosis) . " </di></td>\n <td class='table1Bottom1Left'><div align='left' class='style5'> " . strtoupper($cuz->selectNow("patientICD", "diagnosis", "registrationNo", $registrationNo)) . " </di></td>\n <td class='table1Bottom1Left'><div align='left' class='style5'> " . strtoupper($cuz->getAttendingDoc($registrationNo, "ATTENDING")) . " </di></td>\n <td class='table1Bottom1Left'><div align='center' class='style5'> " . strtoupper($cuz->selectNow("registrationDetails", "dischargedCondition", "registrationNo", $registrationNo)) . " </di></td>\n <td class='table1Bottom1Left'><div align='center' class='style5'> {$dateUnregisteredfmt}" . $timeUnregistered . " </di></td>\n </tr>\n"; } echo "\n </table>\n</div>\n"; ?> </body> </html>
</font></td> <td><font size=5>Blood Pressure</font> </td> <td><font size=5><?php echo $ro->getRegistrationDetails_bloodPressure(); ?> </font></td> </tr> <tr> <td><font size=5>Final Diagnosis</font> </td> <td><font size=5><?php echo $ro->getRegistrationDetails_finalDiagnosis(); ?> </font></td> <td><font size=5>Attending Physician</font> </td> <td><font size=5><?php echo $ro->getAttendingDoc($registrationNo, "Attending"); ?> </font></td> </tr> <tr> <td>Birthdate</td> <td><?php echo $ro->getPatientRecord_Birthdate(); ?> </td> <td><font size=5>Admitting Physiscian</font> </td> <td><font size=5><?php echo $ro->getAttendingDoc($registrationNo, "Admitting"); ?> </font></td> </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>"; echo "<th> Actual </th>"; echo "<th> Company </th>"; echo "<th> PhilHealth </th>";
echo "<td><font size=3>Patient:</font></tD><td><font size=3>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . " " . $ro->getPatientRecord_middleName() . "</font></tD>\n<td width='30%'> </td>\n<td><font size=3>Date Admitted:</font></td>\n<td><font size=3>" . $ro->getRegistrationDetails_dateRegistered() . "</font></tD>\n"; echo "</tR>"; echo "<tr>"; echo "<td><font size=3>Age:</font></td><td><font size=3>" . $ro->getPatientRecord_age() . "</font></tD>\n<td width='30%'> </td>\n<td><font size=3>Sex:</font></td><td><font size=3>" . $ro->getPatientRecord_gender() . "</font></tD>\n"; echo "</tr>"; echo "<tr>"; echo "<td><font size=3>Company:</font></tD><td><font size=3>" . $ro->getRegistrationDetails_company() . "</font></tD>\n<td width='30%'> </td>\n<td><font size=3>PhilHealth:</font></td><td><font size=3>" . $ro->getPatientRecord_phicType() . "</font></tD>\n"; echo "</tr>"; echo "<tr>"; echo "<td><font size=3>Height:</font></tD><td><font size=3>" . $ro->getRegistrationDetails_height() . "</font></tD>\n<td width='30%'> </td>\n<td><font size=3>Weight:</font></td><td><font size=3>" . $ro->getRegistrationDetails_weight() . "</font></tD>\n"; echo "</tr>"; echo "<tr>"; echo "<td><font size=3>Temperature:</font></tD><td><font size=3>" . $ro->getRegistrationDetails_temperature() . "</font></tD>\n<td width='30%'> </td>\n<td><font size=3>Blood Pressure:</font></td><tD><font size=3>" . $ro->getRegistrationDetails_bloodPressure() . "</font></tD>\n"; echo "</tr>"; echo "<tr>"; echo "<td><font size=3>Diagnosis:</font></tD><td><font size=3>" . $ro->getRegistrationDetails_IxDx() . "</font></tD>\n<td width='30%'> </td>\n<td><font size=3>Att. Physician:</font></td>\n<td>" . $ro->getAttendingDoc($registrationNo, "Attending") . "</tD>\n"; echo "</tr>"; echo "<tr>"; echo "<td><font size=3>Birthdate:</font></tD><td><font size=3>" . $ro->getPatientRecord_Birthdate() . "</font></tD>\n<td width='30%'> </td>\n<td><font size=3>Admitting Doc.:</font></td>\n<td>" . $ro->getAttendingDoc($registrationNo, "Admitting") . "</tD>\n"; echo "</tr>"; echo "<tr>"; echo "<td><font size=3>Admitted By:</font></tD><td><font size=2>" . $ro->getRegistrationDetails_registeredBy() . "</font></tD>\n<td width='30%'> </td>\n<td> <input type=checkbox checked><font size=3>HOUSE CASE</font> </tD><td> <input type=checkbox><font size=3>PRIVATE</font> </td>\n"; echo "</tr>"; echo "<tr>"; echo "<td><font size=3>Address:</font></tD> <td><font size=3>" . $ro->getPatientRecord_address() . "</font></tD> "; echo "</tr>"; echo "</table>"; echo "</center>"; echo "<hr>"; echo "<font size=4>I request and authorize medical or surgical treatment as may deemed necessary and appropriate<br>by the physician and his/her designees participating in my care. This care may include diagnostic,<Br>radiology and laboratory procedure,blood transfusion,anesthesia,therapeutic procedures,drugs and nursing and hospital care</font>"; echo "<Br><br><font size=4>I understand that if surgery or surgical procedures is recommended i will have to sign an informed consent</font>";
<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 { echo "<tD> " . $dispense[1] . " </td>"; } echo "<tD> " . $dispense[2] . " </td>"; echo "</tr>";
$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"; } } echo "\n </table></td>\n </tr>\n </table></td>\n</div>\n"; ?> </body> </html>
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>
echo "<td><font size=3>Patient:</font></tD><td><font size=3>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . " " . $ro->getPatientRecord_middleName() . "</font></tD>\n<td width='30%'> </td>\n<td><font size=3>Date Admitted:</font></td>\n<td><font size=3>" . $ro->getRegistrationDetails_dateRegistered() . "</font></tD>\n"; echo "</tR>"; echo "<tr>"; echo "<td><font size=3>Age:</font></td><td><font size=3>" . $ro->getPatientRecord_age() . "</font></tD>\n<td width='30%'> </td>\n<td><font size=3>Sex:</font></td><td><font size=3>" . $ro->getPatientRecord_gender() . "</font></tD>\n"; echo "</tr>"; echo "<tr>"; echo "<td><font size=3>Company:</font></tD><td><font size=3>" . $ro->getRegistrationDetails_company() . "</font></tD>\n<td width='30%'> </td>\n<td><font size=3>PhilHealth:</font></td><td><font size=3>" . $ro->getPatientRecord_phicType() . "</font></tD>\n"; echo "</tr>"; echo "<tr>"; echo "<td><font size=3>Height:</font></tD><td><font size=3>" . $ro->getRegistrationDetails_height() . "</font></tD>\n<td width='30%'> </td>\n<td><font size=3>Weight:</font></td><td><font size=3>" . $ro->getRegistrationDetails_weight() . "</font></tD>\n"; echo "</tr>"; echo "<tr>"; echo "<td><font size=3>Temperature:</font></tD><td><font size=3>" . $ro->getRegistrationDetails_temperature() . "</font></tD>\n<td width='30%'> </td>\n<td><font size=3>Blood Pressure:</font></td><tD><font size=3>" . $ro->getRegistrationDetails_bloodPressure() . "</font></tD>\n"; echo "</tr>"; echo "<tr>"; echo "<td><font size=3>Diagnosis:</font></tD><td><font size=3>" . $ro->getRegistrationDetails_IxDx() . "</font></tD>\n<td width='30%'> </td>\n<td><font size=3>Att. Physician:</font></td>\n<td>" . $ro->getAttendingDoc($registrationNo, "Attending") . "</tD>\n"; echo "</tr>"; echo "<tr>"; echo "<td><font size=3>Birthdate:</font></tD><td><font size=3>" . $ro->getPatientRecord_Birthdate() . "</font></tD>\n<td width='30%'> </td>\n<td><font size=3>Admitting Doc.:</font></td>\n<td>" . $ro->getAttendingDoc($registrationNo, "Admitting") . "</tD>\n"; echo "</tr>"; echo "<tr>"; echo "<td><font size=3>Admitted By:</font></tD><td><font size=2>" . $ro->getRegistrationDetails_registeredBy() . "</font></tD>\n<td width='30%'> </td>\n<td> <input type=checkbox checked><font size=3>HOUSE CASE</font> </tD><td> <input type=checkbox><font size=3>PRIVATE</font> </td>\n"; echo "</tr>"; echo "<tr>"; echo "<td><font size=3>Address:</font></tD> <td><font size=3>" . $ro->getPatientRecord_address() . "</font></tD> "; echo "</tr>"; echo "</table>"; echo "</center>"; echo "<hr>"; echo "<br>"; echo "<center><b><font size=5>" . $ro->getReportInformation("hmoSOA_name") . "</font></b></center>";
<?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 { } echo "<Tr>"; $dispense = preg_split("/\\_/", $dispensed[$x]); if ($ro->selectNow("patientCharges", "status", "itemNo", $remitted[$z]) == "PAID") { echo "<tD><span class='style4'>(Pd)</span><span class='style5'> " . strtoupper($dispense[1]) . " </span></td>";