<?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>&nbsp;&nbsp;<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>&nbsp;&nbsp;<font size=2 color=red><b>" . $ro->getRegistrationDetails_type() . "</b></font><br>";
}
echo "<font class='informationLabel'>Patient No:</font>&nbsp;" . $ro->getRegistrationDetails_patientNo();
echo "<br><font class='informationLabel'>Registration No:</font>&nbsp;" . $ro->getRegistrationDetails_registrationNo();
echo "<br><font class='informationLabel'>Age:</font>&nbsp;" . $ro->getPatientRecord_age();
echo "<br><font class='informationLabel'>Civil Status:</font>&nbsp;" . $ro->getPatientRecord_civilStatus();
echo "<br><font class='informationLabel'>Birth Date:</font>&nbsp;" . $ro->getPatientRecord_Birthdate();
echo "<br><font class='informationLabel'>Contact No#:</font>&nbsp;" . $ro->getPatientRecord_contactNo();
echo "<br><font class='informationLabel'>Senior:</font>&nbsp;" . $ro->getPatientRecord_senior();
echo "<br><font class='informationLabel'>PhilHealth:</font>&nbsp;" . $ro->getPatientRecord_phic();
echo "<br><font class='informationLabel'>Company:</font>&nbsp;" . $ro->getRegistrationDetails_company();
echo "<br><font class='informationLabel'>Time Registered:</font>&nbsp;" . $ro->getRegistrationDetails_timeRegistered();
echo "<br><font class='informationLabel'>Date Registered:</font>&nbsp;" . $ro->getRegistrationDetails_dateRegistered();
echo "<br><font class='informationLabel'>Branch Registered:</font>&nbsp;" . $ro->getRegistrationDetails_branch();
echo "<br><font class='informationLabel'>Room:</font>&nbsp;" . $room[0];
echo "<br><font class='informationLabel'>Address:</font>&nbsp;" . $ro->getPatientRecord_address();
echo "<br><font class='informationLabel'>Registered By:</font>&nbsp;" . $ro->getRegistrationDetails_registeredBy();
if ($ro->getRegistrationDetails_dateUnregistered() != "") {
Exemple #2
0
        $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") . ":&nbsp;</td><td>&nbsp;" . $ro->getRegistrationDetails_company() . "</td>";
echo "<td>&nbsp;</tD>";
echo "<Td>" . $ro->coconutText("Fx Diagnosis:") . ":&nbsp;</td><td>&nbsp;" . $ro->getRegistrationDetails_finalDiagnosis() . "</td>";
echo "</tr>";
echo "<tr>";
echo "<Td>" . $ro->coconutText("Admitted") . ":&nbsp;</td><td>&nbsp;" . $ro->getRegistrationDetails_dateRegistered() . "</td>";
echo "<td>&nbsp;</td>";
echo "<Td>" . $ro->coconutText("Discharged") . ":&nbsp;</td><td>&nbsp;" . $ro->getRegistrationDetails_dateUnregistered() . "</td>";
echo "</tr>";
echo "<tr>";
echo "<Td>" . $ro->coconutText("Age") . "</tD><td>&nbsp;" . $ro->getPatientRecord_age() . "</tD>";
echo "<tD>&nbsp;</tD>";
echo "<Td>" . $ro->coconutText("Room:") . "</tD><td>" . $ro->getRegistrationDetails_room() . "</tD>";
echo "</tr>";
echo "<tr>";
echo "<td>" . $ro->coconutText("Att.Doctor") . "</tD><td>&nbsp;<font size=2>" . $ro->getAttendingDoc($registrationNo, "Attending") . "</font></td>";
echo "<td></td>";
echo "<td>" . $ro->coconutText("Admitting Doc") . "</td><tD>&nbsp;<font size=2>" . $ro->getAttendingDoc($registrationNo, "Admitting") . "</font></tD>";
echo "</tr>";
echo "</table>";
echo "<table border=0>";
echo "<td>Address:&nbsp;</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>&nbsp;Particular&nbsp;</th>";
Exemple #4
0
<?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 "&nbsp;<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#:&nbsp;" . $registrationNo . "&nbsp;&nbsp;&nbsp;&nbsp;Batch#:&nbsp;" . $dispensedNo;
    echo "<br>";
    echo "Name:&nbsp;" . $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>&nbsp;" . $dispense[1] . "&nbsp;</td>";
        } else {
Exemple #6
0
$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>&nbsp;&nbsp;<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>&nbsp;&nbsp;<font size=2 color=red><b>" . $ro->getRegistrationDetails_type() . "</b></font><br>";
}
echo "<font class='informationLabel'>Patient No:</font>&nbsp;" . $ro->getRegistrationDetails_patientNo();
echo "<br><font class='informationLabel'>Registration No:</font>&nbsp;" . $ro->getRegistrationDetails_registrationNo();
echo "<br><font class='informationLabel'>Age:</font>&nbsp;" . $ro->getPatientRecord_age();
echo "<br><font class='informationLabel'>Gender:</font>&nbsp;" . $ro->getPatientRecord_gender();
echo "<br><font class='informationLabel'>Civil Status:</font>&nbsp;" . $ro->getPatientRecord_civilStatus();
echo "<br><font class='informationLabel'>Birth Date:</font>&nbsp;" . $ro->getPatientRecord_Birthdate();
echo "<br><font class='informationLabel'>Contact No#:</font>&nbsp;" . $ro->getPatientRecord_contactNo();
echo "<br><font class='informationLabel'>Senior:</font>&nbsp;" . $ro->getPatientRecord_senior();
echo "<br><font class='informationLabel'>PhilHealth:</font>&nbsp;" . $ro->getPatientRecord_phic();
echo "<br><font class='informationLabel'>PhilHealth Type:</font>&nbsp;" . $ro->getPHICtype_patientRecord();
echo "<br><font class='informationLabel'>Company:</font>&nbsp;" . $ro->getRegistrationDetails_company();
echo "<br><font class='informationLabel'>Time Registered:</font>&nbsp;" . $ro->getRegistrationDetails_timeRegistered();
echo "<br><font class='informationLabel'>Date Registered:</font>&nbsp;" . $ro->getRegistrationDetails_dateRegistered();
echo "<br><font class='informationLabel'>Branch Registered:</font>&nbsp;" . $ro->getRegistrationDetails_branch();
echo "<br><font class='informationLabel'>Case Type:</font>&nbsp;<a href='#' style='text-decoration:none; color:black;'>" . $ro->getRegistrationDetails_caseType() . "</a>";
echo "<br><font class='informationLabel'>Package:</font>&nbsp;<a href='#' style='text-decoration:none; color:black;'>" . $ro->getRegistrationDetails_package() . "</a>";
Exemple #9
0
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>&nbsp;</td><td>&nbsp;" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</td>\n<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td><td>" . $ro->coconutText("Reg#") . "</td><td>&nbsp;{$registrationNo}</td>\n</tr>\n\n<tr>\n<Td><b>" . $ro->coconutText("PHIC") . ":</b>&nbsp;</td><td>&nbsp;" . $ro->getPatientRecord_phic() . "</td>\n<td>&nbsp;</td>\n<td><b>CaseType:</b></td><TD>" . $ro->getRegistrationDetails_caseType() . "</tD>\n</tr>\n\n<tr>\n<Td><b>" . $ro->coconutText("Company") . ":</b>&nbsp;</td><td>&nbsp;" . $ro->getRegistrationDetails_company() . "</td>\n<td>&nbsp;</tD>\n<Td><b>" . $ro->coconutText("Fx Diagnosis:") . ":</b>&nbsp;</td><td>&nbsp;" . $ro->getRegistrationDetails_finalDiagnosis() . "</td>\n</tr>\n\n<tr>\n<Td><b>" . $ro->coconutText("Admitted") . ":</b>&nbsp;</td><td>&nbsp;" . $ro->getRegistrationDetails_dateRegistered() . "</td>\n<td>&nbsp;</td>\n<Td><b>" . $ro->coconutText("Discharged") . ":</b>&nbsp;</td><td>&nbsp;" . $ro->getRegistrationDetails_dateUnregistered() . "</td>\n</tr>\n\n<tr>\n<Td><b>" . $ro->coconutText("Age") . ":</b></tD><td>&nbsp;" . $ro->getPatientRecord_age() . "</tD>\n<tD>&nbsp;</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>&nbsp;<font size=2>" . $ro->getAttendingDoc($registrationNo, "Attending") . "</font></td>\n<td></td>\n<td><b>" . $ro->coconutText("Admitting Doc") . ":</b></td><tD>&nbsp;<font size=2>" . $ro->getAttendingDoc($registrationNo, "Admitting") . "</font></tD>\n</tr>\n</table>\n\n<table>\n<td><b>Address:</b>&nbsp;</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>&nbsp;Particular&nbsp;</th>\n<th>&nbsp;Actual&nbsp;</th>\n<th>&nbsp;PhilHealth&nbsp;</th>\n<th>&nbsp;Company&nbsp;</th>\n<th>&nbsp;Cash&nbsp;</th>\n</tr>\n\n<tr>\n<td>&nbsp;Medicine&nbsp;</td>\n<Td>&nbsp;{$medActual}</td>\n<td>&nbsp;{$medPHIC}</td>\n<td>&nbsp;{$medCompany}</td>\n<td>&nbsp;{$medCash}</td>\n</tr>\n\n\n<Tr>\n<td>&nbsp;Supplies</td>\n<td>&nbsp;{$supActual}</td>\n<td>&nbsp;{$supPHIC}</td>\n<td>&nbsp;{$supCompany}</td>\n<Td>&nbsp;{$supCash}</td>\n</tr>\n\n<Tr>\n<td>&nbsp;Laboratory</td>\n<td>&nbsp;{$labActual}</td>\n<td>&nbsp;{$labPHIC}</td>\n<td>&nbsp;{$labCompany}</td>\n<Td>&nbsp;{$labCash}</td>\n</tr>\n\n<Tr>\n<td>&nbsp;Radiology</td>\n<td>&nbsp;{$radActual}</td>\n<td>&nbsp;{$radPHIC}</td>\n<td>&nbsp;{$radCompany}</td>\n<Td>&nbsp;{$radCash}</td>\n</tr>\n\n<Tr>\n<td>&nbsp;Nursing Charges</td>\n<td>&nbsp;{$nsChargesActual}</td>\n<td>&nbsp;{$nsChargesPHIC}</td>\n<td>&nbsp;{$nsChargesCompany}</td>\n<Td>&nbsp;{$nsChargesCash}</td>\n</tr>\n\n<Tr>\n<td>&nbsp;Miscellaneous</td>\n<td>&nbsp;{$miscActual}</td>\n<td>&nbsp;{$miscPHIC}</td>\n<td>&nbsp;{$miscCompany}</td>\n<Td>&nbsp;{$miscCash}</td>\n</tr>\n\n<Tr>\n<td>&nbsp;Others</td>\n<td>&nbsp;{$othersActual}</td>\n<td>&nbsp;{$othersPHIC}</td>\n<td>&nbsp;{$othersCompany}</td>\n<Td>&nbsp;{$othersCash}</td>\n</tr>\n\n<Tr>\n<td>&nbsp;OR/DR/ER Fee</td>\n<td>&nbsp;{$orActual}</td>\n<td>&nbsp;{$orPHIC}</td>\n<td>&nbsp;{$orCompany}</td>\n<Td>&nbsp;{$orCash}</td>\n</tr>\n\n<Tr>\n<td>&nbsp;Rehab</td>\n<td>&nbsp;{$rehabActual}</td>\n<td>&nbsp;{$rehabPHIC}</td>\n<td>&nbsp;{$rehabCompany}</td>\n<Td>&nbsp;{$rehabCash}</td>\n</tr>\n\n<Tr>\n<td><font size=2>Room @ " . $ro->getQTY_room($registrationNo) . " day(s)</font> </td>\n<td>&nbsp;{$roomActual}</td>\n<td>&nbsp;{$roomPHIC}</td>\n<td>&nbsp;{$roomCompany}</td>\n<Td>&nbsp;{$roomCash}</td>\n</tr>\n\n<Tr>\n<td>&nbsp;<b>Hospital Bill</b></tD>\n<td>&nbsp;<b>" . number_format($hospitalBill_gt, 2) . "</b></tD>\n<td>&nbsp;<b>" . number_format($hospitalBill_phic, 2) . "</b></tD>\n<td>&nbsp;<b>" . number_format($hospitalBill_company, 2) . "</b></tD>\n<td>&nbsp;<b>" . number_format($hospitalBill_cash, 2) . "</b></tD>\n</tr>\n\n<Tr>\n<td>&nbsp;</tD>\n<td>&nbsp;</tD>\n<td>&nbsp;</tD>\n<td>&nbsp;</tD>\n<td>&nbsp;</tD>\n</tr>\n\n<tr>\n<td>&nbsp;</tD>\n<td>&nbsp;</tD>\n<td>&nbsp;</tD>\n<td>&nbsp;</tD>\n<td>&nbsp;</tD>\n</tr>\n\n" . $ro->getPatientDoc_soa2pdf($registrationNo) . "\n\n<tr>\n<td>&nbsp;<b>Professional Fee</b></tD>\n<td>&nbsp;<b>" . number_format($pf_gt, 2) . "</b></tD>\n<td>&nbsp;<b>" . number_format($pf_phic, 2) . "</b></tD>\n<td>&nbsp;<b>" . number_format($pf_company, 2) . "</b></tD>\n<td>&nbsp;<b>" . number_format($pf_cash, 2) . "</b></tD>\n</tr>\n\n\n<Tr>\n<td>&nbsp;</tD>\n<td>&nbsp;</tD>\n<td>&nbsp;</tD>\n<td>&nbsp;</tD>\n<td>&nbsp;</tD>\n</tr>\n\n<tr>\n<td>&nbsp;</tD>\n<td>&nbsp;</tD>\n<td>&nbsp;</tD>\n<td>&nbsp;</tD>\n<td>&nbsp;</tD>\n</tr>\n\n\n<tr>\n<td>&nbsp;<b>Total</b></tD>\n<td>&nbsp;<b>" . number_format($hospitalBill_gt + $pf_gt, 2) . "</b></tD>\n<td>&nbsp;<b>" . number_format($hospitalBill_phic + $pf_phic, 2) . "</b></tD>\n<td>&nbsp;<b>" . number_format($hospitalBill_company + $pf_company, 2) . "</b></tD>\n<td>&nbsp;<b>" . number_format($hospitalBill_cash + $pf_cash, 2) . "</b></tD>\n</tr>\n\n\n<tr>\n<td>&nbsp;<b>Discount</b></tD>\n<td>&nbsp;</tD>\n<td>&nbsp;</tD>\n<td>&nbsp;</tD>\n<td>&nbsp;<b>" . number_format($patientDiscount, 2) . "</b></tD>\n</tr>\n\n<tr>\n<td>&nbsp;<b>Grand Total</b></tD>\n<td>&nbsp;</tD>\n<td>&nbsp;</tD>\n<td>&nbsp;</tD>\n<td>&nbsp;<b>" . number_format($grandTotal, 2) . "</b></tD>\n</tr>\n\n<tr>\n<td>&nbsp;<b>Payments</b></tD>\n<td>&nbsp;</tD>\n<td>&nbsp;</tD>\n<td>&nbsp;</tD>\n<td>&nbsp;<b>" . number_format($ro->getPaymentHistory_showUp_returnPaid(), 2) . "</b></tD>\n</tr>\n\n<tr>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n</tr>\n\n\n<tr>\n<td>&nbsp;<b>BALANCE</b></td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;<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>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</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>&nbsp;</td>\n</tr>\n<tr>\n<td>&nbsp;</td>\n</tr>\n<tr>\n<td>&nbsp;</td>\n</tr>\n<tr>\n<td>&nbsp;</td>\n</tr>\n<tr>\n<td>&nbsp;</td>\n</tr>\n\n<tr>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n<td>&nbsp;</td>\n\n<tD>&nbsp;&nbsp;\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>"
Exemple #10
0
.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'>&nbsp;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>&nbsp;</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'>&nbsp;Patient Name:</div></td>\n            </tr>\n            <tr>\n              <td width='auto'><div align='left' class='couriernew14blackbold'>&nbsp;<u>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . " " . $ro->getPatientRecord_middleName() . "&nbsp;</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'>&nbsp;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>&nbsp;</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'>&nbsp;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'>&nbsp;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>&nbsp;</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'>&nbsp;Description&nbsp;</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'>&nbsp;" . $afetch['description'] . "&nbsp;</div></td>\n                </tr>\n";
    if ($afetch['remarks'] != "") {
        echo "\n                <tr>\n                  <td valign='top'><div align='left' class='couriernew11black'>&nbsp;(" . $afetch['remarks'] . ")&nbsp;</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#:&nbsp;</span><span class='style5'>" . $registrationNo . "</span><span class='style4'>&nbsp;&nbsp;&nbsp;&nbsp;Batch#:&nbsp;</span><span class='style5'>" . $dispensedNo . "</span>";
    echo "<br>";
    echo "<span class='style4'>Name:&nbsp;</span><span class='style5'>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</span>";
    echo "<br>";
    echo "<span class='style4'>PHIC:&nbsp;</span><span class='style5'>" . $ro->getPatientRecord_phic() . " + " . $ro->getRegistrationDetails_company() . "</span>";
    echo "<br>";
    echo "<span class='style4'>Date:&nbsp;</span><span class='style5'>" . date("M d, Y") . " @ " . $ro->getSynapseTime() . "</span>";
    echo "<Br>";
    echo "<span class='style4'>Room:&nbsp;</span><span class='style5'>" . $ro->getRegistrationDetails_room() . "</span>";
    echo "<br>";
    echo "<span class='style4'>Pharmacy:&nbsp;</span><span class='style5'>" . $username . "</span>";
    echo "<br>";
    echo "<span class='style4'>Doctor:&nbsp;</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'>&nbsp;Particulars&nbsp;</td>";
    echo "<td class='style4'>&nbsp;QTY&nbsp;</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>