echo "<tr>"; echo "<td><font class='labelz'><b>Name:</b></font></td><td><font size=2>" . $ro->getPatientRecord_completeName() . "</font></td>"; echo "<td> </td>"; echo "<Td><font class='labelz'><b>Registration#:</b></font></td>"; echo "<td><font size=2>" . $ro->getRegistrationDetails_registrationNo() . "</td>"; echo "</tr>"; echo "<tr>"; echo "<Td><font class='labelz'><B>Age:</b></td>"; echo "<Td><font size=2>" . $ro->getPatientRecord_age() . " yrs Old</font></td>"; echo "<Td> </td>"; echo "<td><font class='labelz'><b> Senior:</b></font></td>"; echo "<td><font size=2>" . $ro->getPatientRecord_senior() . "</font></td>"; echo "</tr>"; echo "<tr>"; echo "<Td><font class='labelz'><b>Company:</b></font></td>"; echo "<td><font size=2>" . $ro->getRegistrationDetails_company() . "</font></tD>"; echo "<td><font class='labelz'>Diagnosis:</font></td>"; echo "<tD><font class='labelz'>" . $ro->soap_assessmentz() . " " . $ro->selectNow("registrationDetails", "finalDiagnosis", "registrationNo", $registrationNo) . "</font></tD>"; echo "</tr>"; echo "</table>"; echo "<hr>"; echo "<Table border=0 cellpadding=0 cellspacing=0>"; echo "<tr>"; echo "<th> <font class='heading'><b>DATE</b></font> </th>"; //echo "<th> <font class='heading'><b>Ref#</b></font> </th>"; echo "<th width='30%'> <font class='heading'><b>Particulars</b></font> </th>"; echo "<th> <font class='heading'><b>QTY</b></font> </th>"; echo "<th> <font class='heading'><b>Price</b></font> </th>"; echo "<th> <font class='heading'><b>Charges</b></font> </th>"; echo "<th> <font class='heading'><b>Credit</b></font> </th>"; echo "<th> <font class='heading'><b>Bal</b></font> </th>";
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>"; echo "<td>Company:</td>"; echo "<td>" . $ro->getRegistrationDetails_company() . " - {$hmoLimit} </td>"; echo "<td> </td>"; echo "<td></td>"; echo "<td></td>"; echo "</tr>"; } else {
echo ""; } else { echo "<br> <font class='informationLabel'>Admission#:</font> <font color='blue'>" . $ro->selectNow("registrationDetails", "manual_registrationNo", "registrationNo", $ro->getRegistrationDetails_registrationNo()) . "</font>"; } //echo "<br><font class='informationLabel'>System#:</font> ".$ro->getRegistrationDetails_patientNo(); //echo "<br><font class='informationLabel'>Registration#:</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> " . $ro4->formatDate($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'>Senior ID#:</font> " . $ro->selectNow("registrationDetails", "seniorID", "registrationNo", $registrationNo); 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 "<td> <b>" . number_format($gross - $ro->getRegistrationDetails_discount() + $pf_cash, 2) . "</b> </tD>"; echo "</tr>"; $grandTotalz = $gross - $ro->getRegistrationDetails_discount() + $pf_cash; //$ro->getPaymentHistory_showUp_returnPaid_setter($registrationNo); //$netTotal = ( ( ($gross - $ro->getRegistrationDetails_discount() ) - $ro->getPaymentHistory_showUp_returnPaid() ) - $ro->sumPartial($registrationNo) ); //if( $netTotal < 0 ) $netTotal=0; //echo "<Tr>"; //echo "<td> <b>Payment's</b></tD>"; //echo "<td> </tD>"; //echo "<td> </tD>"; //echo "<td> </tD>"; //echo "<td> <b>".number_format( $ro->getPaymentHistory_showUp_returnPaid() ,2)."</b> </tD>"; //echo "</tr>"; //$paidz1 = (( $ro->sumPartial_new($registrationNo,"amountPaid") + $ro->sumPartial_new($registrationNo,"pf")) + $ro->sumPartial_new($registrationNo,"admitting") ); $ro->descPartialPayment($registrationNo, $username); $ro->getCompanyPayment($registrationNo, $ro->getRegistrationDetails_company()); $ro->getPHICPayment($registrationNo); echo "<Tr>"; echo "<td> </tD>"; echo "<td> </tD>"; echo "<td> </tD>"; echo "<td> </tD>"; echo "<td> </tD>"; //echo "<td> <b>".number_format( $ro->sumPartial_new($registrationNo) ,2)."</b> </tD>"; echo "</tr>"; $refund = $ro->doubleSelectNow("patientPayment", "amountPaid", "registrationNo", $registrationNo, "paymentFor", "REFUND"); echo "<tr>"; echo "<Td> <b>REFUND</b></td>"; echo "<TD></tD>"; echo "<td></td>"; echo "<td></td>";
// 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>"; /////////// LOCKED ACCOUNT KAPAG CONSUMED NA UNG LIMIT //////////////////////// if ($ro->selectNow("registrationDetails", "mgh", "registrationNo", $registrationNo) == "") { // enable charges kung hindi pa MGH if ($ro->getRegistrationDetails_type() == "OR/DR" || $ro->getRegistrationDetails_type() == "OPD") { echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/chargesCartPassword.php?registrationNo=" . $ro->getRegistrationDetails_registrationNo() . "&username={$username}&room=" . $ro->getRegistrationDetails_room() . "&batchNo={$batchNo}' target='rightFrame'><font size=2>Charges Cart</font></a></li>"; } else { $totalBalanceNow = $ro->getTotal("cashUnpaid", "", $registrationNo) - $ro->getAllPayment($registrationNo); if ($ro->getRegistrationDetails_company() != "") { //kpg may hmo if ($ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo) != "") { //meron hmo limit if ($totalBalanceNow >= $ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo)) { //mas mataas n ung total balance kaysa sa hmo limit if ($ro->selectNow("registeredUser", "module", "username", $username) == "PHARMACY" || $ro->selectNow("registeredUser", "module", "username", $username) == "CASHIER") { //kpg pharmacy or cashier pwede mag charge echo "<li>" . $ro->coconutImages_return("locked1.jpeg") . "<a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/chargesCartPassword.php?registrationNo=" . $ro->getRegistrationDetails_registrationNo() . "&username={$username}&room=" . $ro->getRegistrationDetails_room() . "&batchNo={$batchNo}' target='rightFrame'><font size=2 color=red>Charges Cart</font></a></li>"; } else { if ($ro->checkPermission($registrationNo) != "") { echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/chargesCartPassword.php?registrationNo=" . $ro->getRegistrationDetails_registrationNo() . "&username={$username}&room=" . $ro->getRegistrationDetails_room() . "&batchNo={$batchNo}' target='rightFrame'><font size=2>Charges Cart</font></a></li>"; } else { //kpg ndi pharmacy or cashier ndi pde mag charge echo $ro->coconutImages_return("locked1.jpeg") . "<font size=2 color=blue>[LOCKED ACCOUNT]</font><br><font size=2 color=red>" . $ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo) . " Limit of " . $ro->getRegistrationDetails_company() . " for this Patient is Already Consumed</font>"; }
if ($ro->selectNow("registrationDetails", "verified", "registrationNo", $registrationNo) != "" && $ro->selectNow("registrationDetails", "certified", "registrationNo", $registrationNo) == "") { echo "<img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/verified.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 "<tr>"; echo "<td>Tax</td>"; echo "<td>"; $ro->coconutTextBox_short("tax", ""); echo "</td>"; echo "</tr>"; echo "<tr>"; echo "<td>Discount</td>"; echo "<td>"; $ro->coconutTextBox_short("discount", ""); echo "</td>"; echo "</tr>"; echo "<tr>"; echo "<td>Company</td>"; echo "<td>"; $ro->coconutTextBox_readonly("company", $ro->getRegistrationDetails_company()); echo "</td>"; echo "</tr>"; echo "<tr>"; echo "<td>Date</td>"; echo "<td>"; $ro->coconutComboBoxStart_short("month"); echo "<option value='" . date("m") . "'>" . date("M") . "</option>"; 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>";
include "../../myDatabase2.php"; $registrationNo = $_GET['registrationNo']; $dateCharge = $_GET['dateCharge']; $ro = new database2(); $ro->getPatientProfile($registrationNo); echo "<Br>"; echo "<table border=0 width='70%'>"; echo "<Tr>"; echo "<td><b>Patient ID:</b> " . $ro->getRegistrationDetails_patientNo() . "</td>"; echo "<TD><b>Registration#:</b> {$registrationNo}</tD>"; echo "</tr>"; echo "<Tr>"; echo "<td><b>Patients Name:</b> " . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . " " . $ro->getPatientRecord_middleName() . "</td>"; echo "<td><b>Age:</b> " . $ro->getPatientRecord_Age() . "</td>"; echo "</tr>"; echo "<tr>"; echo "<td><b>D.O.B:</b> " . $ro->getPatientRecord_birthDate() . "</td>"; echo "<tD><b>Sex:</b> " . $ro->getPatientRecord_Gender() . "</td>"; echo "</tr>"; echo "<tr>"; echo "<td><b>Physician:</b> " . $ro->getAttendingDoc($registrationNo, "ATTENDING") . "</td>"; echo "<td><b>Room:</b> " . $ro->getRegistrationDetails_room() . "</td>"; echo "</tr>"; echo "<tr>"; echo "<td><b>Company</b> " . $ro->getRegistrationDetails_company() . "</td>"; echo "<td></td>"; echo "</tr>"; echo "</table>"; echo "<br>"; $ro->printLabRequest($registrationNo, $dateCharge);
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 "<td><span class='txtSize'>Company:</span></td>"; echo "<td><span class='txtSize'>" . $ro->getRegistrationDetails_company() . " - {$hmoLimit}</span> </td>"; echo "<td> </td>"; echo "<td></td>"; echo "<td></td>"; echo "</tr>"; } else {