//echo "<font size=5><b><a href='#' style='color:#000; text-decoration:none;'>".$ro->getReportInformation("hmoSOA_name")."</a></b></font>"; //echo "<br><font size=2>".$ro->getReportInformation("hmoSOA_address")."</font>"; echo "<center>"; echo "<table border=0>"; echo "<tr>"; echo "<td>Patient#: </td><td>" . $ro->getRegistrationDetails_patientNo() . "</td>"; echo "<td> Registration#: </td><td> " . $ro->getRegistrationDetails_registrationNo() . "</td>"; echo "<td> Room: " . $room1[0] . " </td>"; echo "</tr>"; echo "<tr>"; echo "<td>Name: </td><td> <a href='#' onClick='printF(printData)' style='text-decoration:none; color:black;'>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</a></td>"; echo "<td align='right'> " . $ro->coconutText("Physician") . " : </td><td> " . $ro->getAttendingDoc($registrationNo, "Attending") . "</td>"; echo "<td> Case: " . $ro->selectNow("registrationDetails", "privateORhouse_case", "registrationNo", $registrationNo) . "</td>"; echo "</tr>"; echo "<tr>"; echo "<Td>" . $ro->coconutText("Admitted") . ": </td><td> " . $ro->getRegistrationDetails_dateRegistered() . "@" . $ro->getRegistrationDetails_timeRegistered() . "</td>"; //echo "<td>CaseType:</td><TD>".$ro->getRegistrationDetails_caseType()."</tD>"; echo "<Td align='right'> " . $ro->coconutText("Discharged") . ": </td><td> " . $ro->getRegistrationDetails_dateUnregistered() . "@" . $ro->getRegistrationDetails_timeUnregistered() . "</td>"; echo "</tr>"; if ($ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo) != "") { $hmoLimit = number_format($ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo), 2); } else { if ($ro->selectNow("Company", "type", "companyName", $ro->getRegistrationDetails_company()) == "insurance") { //check kung insurance.. $hmoLimit = number_format(2000, 2); } else { $hmoLimit = ""; } } if ($ro->selectNow("registrationDetails", "company", "registrationNo", $registrationNo) != "") { echo "<tr>";
<?php include "../../../myDatabase2.php"; $registrationNo = $_GET['registrationNo']; $username = $_GET['username']; $ro = new database2(); $ro->coconutDesign(); $ro->getPatientProfile($registrationNo); echo "<b>Date Admitted</b> " . $ro->getRegistrationDetails_dateRegistered(); echo "<Br>"; echo "<b>Date Discharged</b> " . $ro->getRegistrationDetails_dateUnregistered(); echo "<Br><Br><Br><BR><BR><br>"; $ro->coconutFormStart("get", "checkGenerator1.php"); $ro->coconutHidden("registrationNo", $registrationNo); $ro->coconutHidden("username", $username); $ro->coconutBoxStart("500", "120"); echo "<Br>"; echo "<table border=0>"; echo "<Tr>"; echo "<Td>From</td>"; echo "<Td>"; $ro->coconutComboBoxStart_short("month"); echo "<option value='01'>Jan</option>"; echo "<option value='02'>Feb</option>"; echo "<option value='03'>Mar</option>"; echo "<option value='04'>Apr</option>"; echo "<option value='05'>May</option>"; echo "<option value='06'>Jun</option>"; echo "<option value='07'>Jul</option>"; echo "<option value='08'>Aug</option>"; echo "<option value='09'>Sep</option>";
//echo "<center><font size=5><b><a href='#' style='color:#000; text-decoration:none;'>".$ro->getReportInformation("hmoSOA_name")."</a></b></font>"; //echo "<br><font size=2>".$ro->getReportInformation("hmoSOA_address")."</font>"; echo "<center>"; echo "<table border=0>"; echo "<tr>"; echo "<td><span class='txtSize'>Patient#:</span> </td><td><span class='txtSize'>" . $ro->getRegistrationDetails_patientNo() . "</span></td>"; echo "<td> <span class='txtSize'>Registration#:</span> </td><td> <span class='txtSize'>" . $ro->getRegistrationDetails_registrationNo() . "</span></td>"; echo "<td> <span class='txtSize'>Room:</span> <span class='txtSize'>" . $room1[0] . "</span></td>"; echo "</tr>"; echo "<tr>"; echo "<td><span class='txtSize'>Name:</span> </td><td> <a href='#' style='text-decoration:none; font-size:12px; color:black;'>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</a></td>"; echo "<td align='left'> <span class='txtSize'>Physician:</span> </td><td> <span class='txtSize'>" . $ro->getAttendingDoc($registrationNo, "Attending") . "</span></td>"; echo "<td> <span class='txtSize'>Case:" . $ro->selectNow("registrationDetails", "privateORhouse_case", "registrationNo", $registrationNo) . "</span></td>"; echo "</tr>"; echo "<tr>"; echo "<Td><span class='txtSize'>Admitted:</span> </td><td> <span class='txtSize'>" . $ro->getRegistrationDetails_dateRegistered() . "@" . $ro->getRegistrationDetails_timeRegistered() . "</span></td>"; //echo "<td>CaseType:</td><TD>".$ro->getRegistrationDetails_caseType()."</tD>"; echo "<Td align='left'> <span class='txtSize'>Discharged:</span> </td><td> <span class='txtSize'>" . $ro->getRegistrationDetails_dateUnregistered() . "@" . $ro->getRegistrationDetails_timeUnregistered() . "</span></td>"; echo "</tr>"; if ($ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo) != "") { $hmoLimit = number_format($ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo), 2); } else { if ($ro->selectNow("Company", "type", "companyName", $ro->getRegistrationDetails_company()) == "insurance") { //check kung insurance.. $hmoLimit = number_format(2000, 2); } else { $hmoLimit = ""; } } if ($ro->selectNow("registrationDetails", "company", "registrationNo", $registrationNo) != "") { echo "<tr>";
//echo "<center><font size=5><b><a href='#' style='color:#000; text-decoration:none;'>".$ro->getReportInformation("hmoSOA_name")."</a></b></font>"; //echo "<br><font size=2>".$ro->getReportInformation("hmoSOA_address")."</font>"; echo "<center>"; echo "<table border=0>"; echo "<tr>"; echo "<td><span class='Arial11Black'>Patient#:</span> </td><td><span class='Arial11BlackBold'>" . $ro->getRegistrationDetails_patientNo() . "</span></td>"; echo "<td><span class='Arial11Black'> Registration#: </span></td><td><span class='Arial11BlackBold'> " . $ro->getRegistrationDetails_registrationNo() . "</span></td>"; echo "<td><span class='Arial11Black'> Room: </span><span class='Arial11BlackBold'>" . $room1[0] . "</span></td>"; echo "</tr>"; echo "<tr>"; echo "<td><span class='Arial11Black'>Name:</span> </td><td> <span class='Arial11BlackBold'>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</span></td>"; echo "<td align='left'> <span class='Arial11Black'>Physician:</span> </td><td> <span class='Arial11BlackBold'>" . $ro->getAttendingDoc($registrationNo, "Attending") . "</span></td>"; echo "<td> <span class='Arial11Black'>Case: </span><span class='Arial11BlackBold'>" . $ro->selectNow("registrationDetails", "privateORhouse_case", "registrationNo", $registrationNo) . "</span></td>"; echo "</tr>"; echo "<tr>"; echo "<Td><span class='Arial11Black'>Admitted:</span> </td><td> <span class='Arial11BlackBold'>" . $ro->getRegistrationDetails_dateRegistered() . "@" . $ro->getRegistrationDetails_timeRegistered() . "</span></td>"; //echo "<td>CaseType:</td><TD>".$ro->getRegistrationDetails_caseType()."</tD>"; echo "<Td align='left'> <span class='Arial11Black'>Discharged:</span> </td><td> <span class='Arial11BlackBold'>" . $ro->getRegistrationDetails_dateUnregistered() . "@" . $ro->getRegistrationDetails_timeUnregistered() . "</span></td>"; echo "</tr>"; if ($ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo) != "") { $hmoLimit = number_format($ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo), 2); } else { if ($ro->selectNow("Company", "type", "companyName", $ro->getRegistrationDetails_company()) == "insurance") { //check kung insurance.. $hmoLimit = number_format(2000, 2); } else { $hmoLimit = ""; } } if ($ro->selectNow("registrationDetails", "company", "registrationNo", $registrationNo) != "") { echo "<tr>";
echo "<br> <font class='informationLabel'>PhilHealth:</font> " . $ro->getPatientRecord_phic() . " <a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/Payments/phicPayment_selection.php?registrationNo={$registrationNo}&username={$username}' style='text-decoration:none;'><font color='red' size=2>[Payment]</font></a>"; //echo "<br><font class='informationLabel'>Religion:</font> ".$ro->getPHICtype_patientRecord(); echo "<br> <font class='informationLabel'>Company:</font> " . $ro->getRegistrationDetails_company() . " <a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/Payments/companyPayment_selection.php?registrationNo={$registrationNo}&username={$username}' style='text-decoration:none;'><font color='red' size=2>[Payment]</font></a>"; if ($ro->selectNow("registrationDetails", "company1", "registrationNo", $registrationNo) != "") { echo "<br> <font class='informationLabel'>Company1:</font> " . $ro->selectNow("registrationDetails", "company1", "registrationNo", $registrationNo); } else { } if ($ro->selectNow("registrationDetails", "company2", "registrationNo", $registrationNo) != "") { echo "<br> <font class='informationLabel'>Company2:</font> " . $ro->selectNow("registrationDetails", "company2", "registrationNo", $registrationNo); } else { } //echo "<br><font class='informationLabel'>Mother's Name:</font> ".$ro->selectNow("patientRecord","mothersName","patientNo",$ro->getRegistrationDetails_patientNo()); //echo "<br><font class='informationLabel'>Father's Name:</font> ".$ro->selectNow("patientRecord","fathersName","patientNo",$ro->getRegistrationDetails_patientNo()); if ($ro->selectNow("registrationDetails", "type", "registrationNo", $registrationNo) == "OPD") { echo "<br> <font class='informationLabel'>Time Registered:</font> " . $ro4->formatTime($ro->getRegistrationDetails_timeRegistered()); echo "<br> <font class='informationLabel'>Date Registered:</font> " . $ro4->formatDate($ro->getRegistrationDetails_dateRegistered()); } else { echo "<br><font class='informationLabel'>Time Registered:</font> " . $ro4->formatTime($ro->getRegistrationDetails_timeRegistered()); echo "<br><div class='col-xs-3 input-group'>\n\t\t\t\t<span class='input-group-addon'><i class='glyphicon glyphicon-time'></i> Admitted</span>\n\t\t\t\t<input type='text' class='form-control' id='timeAdmission' placeholder='click to add time'>\n\t\t\t\t<span class='input-group-btn'>\n\t\t\t\t\t<button id='saveTimeBtn' class='" . $buttonClass . "'>\n\t\t\t\t\t\tSave\n\t\t\t\t\t</button>\n\t\t\t\t</span>\n\t\t\t</div>"; echo "<font class='informationLabel'>Date Registered:</font> " . $ro4->formatDate($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->selectNow("registrationDetails", "privateORhouse_case", "registrationNo", $registrationNo) . "</a>"; //selectNow($table,$cols,$identifier,$identifierData) echo "<br> <font class='informationLabel'>Room:</font> " . $room[0]; echo "<br> <font class='informationLabel'>Address:</font> " . $ro->getPatientRecord_address(); echo "<br> <font class='informationLabel'>Email:</font> " . $ro->selectNow("patientRecord", "email", "patientNo", $ro->selectNow("registrationDetails", "patientNo", "registrationNo", $registrationNo)); echo "<br> <font class='informationLabel'>Registered By:</font> " . $ro->getRegistrationDetails_registeredBy(); if ($ro->getRegistrationDetails_type() == "IPD") { if ($ro->selectNow("nbs", "motherRegistrationNo", "motherRegistrationNo", $registrationNo) != "") { echo "<br>" . $ro->coconutImages_return("mother.jpeg");
} else { if ($ro->selectNow("registrationDetails", "verified", "registrationNo", $registrationNo) == "" && $ro->selectNow("registrationDetails", "certified", "registrationNo", $registrationNo) != "") { echo "<img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/certified.jpeg'>"; } else { if ($ro->selectNow("registrationDetails", "verified", "registrationNo", $registrationNo) != "" && $ro->selectNow("registrationDetails", "certified", "registrationNo", $registrationNo) != "") { echo "<img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/verified.jpeg'>"; echo " "; echo "<img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/certified.jpeg'>"; } else { echo ""; } } } 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'>Diet</font> " . $ro->selectNow("dietList", "dietName", "dietNo", $ro->selectNow("registrationDetails", "diet", "registrationNo", $registrationNo)); //selectNow($table,$cols,$identifier,$identifierData) 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->selectNow("nbs", "motherRegistrationNo", "motherRegistrationNo", $registrationNo) != "") { echo "<br>" . $ro->coconutImages_return("mother.jpeg"); $ro->getBabies($registrationNo); echo "<br><a href='/COCONUT/patientProfile/nbs/searchBaby.php?registrationNo={$registrationNo}&username={$username}' style='text-decoration:none;'><font class='informationLabel' color=red>[+1 Baby]</font></a> "; } else { if ($ro->selectNow("nbs", "motherRegistrationNo", "babyRegistrationNo", $registrationNo) != "") { echo "<br> " . $ro->coconutImages_return("mother.jpeg") . " - <font color=blue>" . $ro->selectNow("patientRecord", "lastName", "patientNo", $ro->selectNow("registrationDetails", "patientNo", "registrationNo", $ro->selectNow("nbs", "motherRegistrationNo", "babyRegistrationNo", $registrationNo))) . ", " . $ro->selectNow("patientRecord", "firstName", "patientNo", $ro->selectNow("registrationDetails", "patientNo", "registrationNo", $ro->selectNow("nbs", "motherRegistrationNo", "babyRegistrationNo", $registrationNo))) . "</font> "; } else {
echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td><b>DATE DISCHARGED:</b></tD>"; echo "<td>" . $ro->getRegistrationDetails_dateUnregistered() . "</td>"; echo "</tr>"; echo "<tr>"; echo "<td><b>DATE ADMITTED:</b> </td>"; echo "<tD>" . $ro->getRegistrationDetails_dateRegistered() . "</td>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> </tD>"; echo "<Td> </tD>";
<td width='70%'> </td> <td> <?php echo "<font size=4>Date: <u>" . date("M d, Y") . "</u>____</font>"; ?> </td> </tr> </table> <br> <font size=4><b>TO WHOM IT MAY CONCERN:</b></font> <br> <font size=4>This is to certify that base on our record. <u><?php echo $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName(); ?> </u> who was confined/admitted at Pagadian City Medical Center from <?php echo "<u>" . $ro->getRegistrationDetails_dateRegistered() . "</u>"; ?> to <?php echo "<u>" . $ro->getRegistrationDetails_dateUnregistered() . "</u>"; ?> had no medicare deductions for hospital charges including professional fees to the amount of <input type=text class='underLine'> (<b>P</b><input type=text class='underLine1'>) were fully paid by the patient/member under Official Receipt No./s<input type=text class='underLine1'></font> <br><Br> <font size=3>This waiver is being issued upon the request of the above mentioned patient for whatever legal purpose it may serve</font> <br><Br> <table border=0 width='100%'> <tr> <td width='70%'> </td> <td> <input type=text class='underLine1'><Br><Font size=2>Medical Director/Cashier/Finance .Mgr/Officer</font></td> </tr>