<div id='printData' class='style1'>
<?php
echo "<center><img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/mendero.png' width='45%' height='12%'></center>";
//echo "<center><div style='border:0px solid #000000; width:700px; height:auto; border-color:black black black black;'>";
echo "";
//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 {
</style>
<?php
echo "<center><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/SOAoption/summary_short.php?registrationNo={$registrationNo}&username={$username}' target='_blank'><img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/mendero.png' width='45%' height='12%'></a></center>";
//echo "<center><div style='border:0px solid #000000; width:700px; height:auto; border-color:black black black black;'>";
echo "";
//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 {
$ro = new database2();
$ro->getPatientProfile($registrationNo);
/*
if(isset($_GET['submit']))
{
$result = $_GET['result'];
addLaboratoryResultInPatient($registrationNo,$itemNo,$chargesCode,$medtech,$date,$result);
}
*/
echo "<script type='text/javascript' src='/ckeditor/ckeditor.js'></script>";
echo "<table border=0 cellspacing=0 cellpadding=1 width='100%' >";
echo "<tr>";
echo "<td> <b>Name:</b> " . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</td>";
echo "<td> <b>Age/Sex:</b> " . $ro->getPatientRecord_Age() . "/" . $ro->getPatientRecord_gender() . "</td>";
echo "<Td> <b>Date:</b> " . date("M d, Y") . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td> <b>D.O.B:</b> " . $ro->getPatientRecord_birthDate() . "</td>";
echo "<Td> <b>WARD:</b> " . $ro->getRegistrationDetails_type() . "</td>";
echo "</tr>";
echo "</table>";
echo "</centeR>";
/*
if( $ro->selectNow("availableCharges","reagents","chargesCode",$chargesCode) != "" ) {
$reagentsz = preg_split ("/\-/", $ro->selectNow("availableCharges","reagents","chargesCode",$chargesCode) );
$ro->getReagentsWillBeUse($reagentsz[0]);
echo "<Br>";
$ro->getReagentsWillBeUse($reagentsz[1]);
<link rel="stylesheet" type="text/css" href="http://<?php
echo $ro->getMyUrl();
?>
/COCONUT/myCSS/coconutCSS.css" />
<?php
$ro->getPatientProfile($registrationNo);
echo "<form method='get' action='addPayment1.php'>";
$ro->coconutHidden("receiptType", "");
$ro->coconutHidden("collectionFor", "IPD");
echo "<input type=hidden name='registrationNo' value='{$registrationNo}'>";
echo "<input type=hidden name='username' value='{$username}'>";
echo "<br>";
echo "<font color=reD>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . " </font>";
echo "<br><br><br><center><div style='border:1px solid #000000; width:600px; height:389px; border-color:black black black black;'>";
echo "<Br>";
echo "<Table border=0>";
echo "<tr>";
echo "<td><font class='labelz'>Payment For </font></tD>";
echo "<tD>";
echo "<select name='paymentFor' class='comboBox'>";
echo "<option value='HOSPITAL BILL'>HOSPITAL BILL</option>";
echo "<option value='DEPOSIT'>DEPOSIT</option>";
echo "<option value='BALANCE PAID'>BALANCE PAID</option>";
echo "<option value='REFUND'>REFUND</option>";
//$ro->showOption("Category","Category");
echo "</select>";
echo "</td>";
echo "</tr>";
<?php
include "../../myDatabase2.php";
$registrationNo = $_POST['registrationNo'];
$username = $_POST['username'];
$ro = new database2();
$ro->coconutDesign();
$ro->getPatientProfile($registrationNo);
echo "<br><br><br>";
$ro->coconutFormStart("post", "http://" . $ro->getMyUrl() . "/COCONUT/ER/finishER1.php");
$ro->coconutHidden("registrationNo", $registrationNo);
$ro->coconutHidden("username", $username);
$ro->coconutBoxStart_red("500", "100");
echo "<Br>";
echo "Remove " . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . " from the list?";
echo "<Br><Br>";
$ro->coconutButton("Yes");
$ro->coconutBoxStop();
$ro->coconutFormStop();
<?php include "../../../myDatabase2.php"; $registrationNo = $_GET['registrationNo']; $ro = new database2(); $ro->getPatientProfile($registrationNo); echo "<div style='background:#47a3da; border-radius:10px; width:550px; height:50px;' >"; echo "<Br>"; echo " <font color='white'><b>Patient:</b></font> <font color='white'><i>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</i></font>"; echo "</div>"; echo "<Br><br>"; $ro->mobileHospitalCharges($registrationNo, "LABORATORY"); $ro->mobileHospitalCharges($registrationNo, "RADIOLOGY"); $ro->mobileHospitalCharges($registrationNo, "MEDICINE");
<?php
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 "</table>";
echo "<br>";
$ro->printLabRequest($registrationNo, $dateCharge);
$ro->getPatientProfile($registrationNo);
echo "<center>";
echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/android/doctor/planPreview_handler.php?registrationNo={$registrationNo}' style='color:black;'><font size=4><b>Protacio Hospital</b></font></a>";
echo "<Br>";
echo "<font size=3>Paranaque City</font>";
//echo "<br>";
//echo "<font size=1>Ledesma Street, Tacurong City, Sultan Kudarat</font>";
//echo "<br>";
//echo "<font size=1>TEL NO.(064) 200-3201 FAX NO.(064) 200-4472</font>";
echo "</center>";
echo "<br>";
echo "<centeR>";
echo "<table border=0>";
echo "<tr>";
echo "<td><font size=1>Name:</font> </td>";
echo "<td><font size=1><b>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</b></font></td>";
echo "<td> </td>";
echo "<td> </td>";
echo "<td> </td>";
echo "<td><font size=1>Date:</font></td>";
echo "<td><font size=1><b>" . date("M, d Y") . "</b></font></td>";
echo "</tr>";
echo "<tr>";
echo "<td><font size=2>Address:</font> </td>";
echo "<td><font size=2><b>" . $ro->getPatientRecord_address() . "</b></font></td>";
echo "<td> </td>";
echo "<td> </td>";
echo "<td> </td>";
echo "<td><font size=2>Age/Sex:</font></td>";
echo "<td><font size=2><b> " . $ro->getPatientRecord_age() . "/" . $ro->getPatientRecord_gender() . "</b></font></td>";
echo "</tr>";
$timeOut_minutes1 = substr($timeOut[1], 0, 1);
$timeOut_minutes2 = substr($timeOut[1], 1, 1);
$pinNo = preg_split("/\\-/", $ro->getRegistrationDetails_PIN());
$pxPin1 = substr($pinNo[0], 0, 1);
$pxPin2 = substr($pinNo[0], 1, 1);
$pxPin3 = substr($pinNo[0], 2, 1);
$pxPin4 = substr($pinNo[0], 3, 1);
$pxPin5 = substr($pinNo[0], 4, 1);
$pxPin6 = substr($pinNo[0], 5, 1);
$pxPin7 = substr($pinNo[0], 6, 1);
$pxPin8 = substr($pinNo[0], 7, 1);
$pxPin9 = substr($pinNo[0], 8, 1);
$pxPin10 = substr($pinNo[0], 9, 1);
$pxPin11 = substr($pinNo[0], 10, 1);
$pxPin12 = substr($pinNo[0], 11, 1);
echo "\n\n<table width='860' border='0' align='center' cellpadding='0' cellspacing='0' bordercolor='#000000'>\n<tr>\n<td><div align='center' style='border:1px #000 solid;'><font size=3><b>PART II - PATIENT CONFINEMENT INFORMATION</b></font></font> </div></td>\n</tr>\n</table>\n\n\n<table width='860' border='0' align='center' cellpadding='0' cellspacing='0' bordercolor='#000000' >\n<td class='style1'><b>1.Name of Patient</b> <input type='text' value=' " . $ro->getPatientRecord_lastName() . " " . $ro->getPatientRecord_firstName() . ", " . $ro->getPatientRecord_middleName() . "' class='pxName'><br><span style='margin:0 0 0 180px;'><font size=1>Last Name</font></span> <span style='margin:0 0 0 100px;'><font size=1>First Name</font></span> <span style='margin:0 0 0 100px;'><font size=1>Middle Name</font></span> <span style='margin:0 0 0 100px;'><font size=1>(example:Dela Cruz Jr Juan,Sipag)</font></span> </tD>\n</tr>\n\n<tr>\n<td class='style1'><b>2.Was patient referred by another Health Care Institution (HCI)</b></td>\n</tr>\n<tr>\n<td>\n<input type='checkbox'><b>NO</b> \n<input type='checkbox'><b>YES</b> \n<input type='text' class='referringHCI' value=''>\n<input type='text' class='addressHCI' value=''>\n<br>\n<span style='margin:0 0 0 150px;'><font size=1>Name of Referring Health Care Institution</font></span>\n<span style='margin:0 0 0 50px;'><font size=1>Building Number and Street Name</font></span>\n<span style='margin:0 0 0 20px;'><font size=1>City/Municipality</font></span>\n<span style='margin:0 0 0 20px;'><font size=1>Province</font></span>\n<span style='margin:0 0 0 20px;'><font size=1>Zip Code</font></span>\n</td>\n</tr>\n\n<tr>\n<td class='style1'><b>3.Confinement Period</b> a.Date Admitted: <input type='text' class='panz' value='" . $monthIn_output1 . "' ><input type='text' class='panz1' value='" . $monthIn_output2 . "' >-<input type='text' class='panz' value='{$day1}' ><input type='text' class='panz1' value='{$day2}' >-<input type='text' class='panz' value='{$year1}' ><input type='text' class='panz1' value='{$year2}' ><input type='text' class='panz1' value='{$year3}' ><input type='text' class='panz1' value='{$year4}' > b.Time Admitted: <input type='text' class='panz' value='{$timeIn_hour2_12hrs}' ><input type='text' class='panz1' value='{$timeIn_hour1_12hrs}' >:<input type='text' class='panz' value='{$timeIn_minutes1}' ><input type='text' class='panz1' value='{$timeIn_minutes2}' > ";
if ($timeIn[0] < 12) {
echo "<input type='radio' checked='true'>AM <input type='radio'>PM";
} else {
echo "<input type='radio'>AM <input type='radio' checked='false'>PM";
}
echo "\n<br>\n<span style='margin:0 0 0 250px;'><font size=1>month</font></span>\n<span style='margin:0 0 0 20px;'><font size=1>day</font></span>\n<span style='margin:0 0 0 30px;'><font size=1>year</font></span>\n<span style='margin:0 0 0 170px;'><font size=1>hour</font></span>\n<span style='margin:0 0 0 25px;'><font size=1>min</font></span>\n</td>\n\n\n</tr>\n\n<tr>\n<td class='style1'><span style='margin:0 0 0 147px;'> a.Date Discharged: <input type='text' class='panz' value='{$monthOut_output1}' ><input type='text' class='panz1' value='{$monthOut_output2}' >-<input type='text' class='panz' value='{$dayOut_output1}' ><input type='text' class='panz1' value='{$dayOut_output2}' >-<input type='text' class='panz' value='{$yearOut_output1}' ><input type='text' class='panz1' value='{$yearOut_output2}' ><input type='text' class='panz1' value='{$yearOut_output3}' ><input type='text' class='panz1' value='{$yearOut_output4}' > b.Time Discharged: <input type='text' class='panz' value='{$timeOut_hour2_12hrs}'><input type='text' class='panz1' value='{$timeOut_hour1_12hrs}' >:<input type='text' class='panz' value='{$timeOut_minutes1}' ><input type='text' class='panz1' value='{$timeOut_minutes2}' >";
if ($timeOut[0] < 12) {
echo "<input type='radio' checked='true'>AM <input type='radio'>PM";
} else {
echo "<input type='radio'>AM <input type='radio' checked='false'>PM";
}
echo "\n<br>\n\n<span style='margin:0 0 0 265px;'><font size=1>month</font></span>\n<span style='margin:0 0 0 20px;'><font size=1>day</font></span>\n<span style='margin:0 0 0 30px;'><font size=1>year</font></span>\n<span style='margin:0 0 0 180px;'><font size=1>hour</font></span>\n<span style='margin:0 0 0 25px;'><font size=1>min</font></span>\n</td>\n\n\n</td>\n</tr>\n";
$improved = "";
if ($ro->selectNow("registrationDetails", "patientDisposition", "registrationNo", $registrationNo) == "improved") {
$improved = "checked";
}
echo "<th bgcolor='#3b5998'> <font color=white class='head'></font> </th>";
echo "<th bgcolor='#3b5998'> <font color=white class='head'></font> </th>";
echo "<th bgcolor='#3b5998'> <font color=white class='head'></font> </th>";
echo "<th bgcolor='#3b5998'> <font color=white class='head'>Description</font> </th>";
echo "<th bgcolor='#3b5998'> <font color=white class='head'>Price</font> </th>";
echo "<th bgcolor='#3b5998'> <font color=white class='head'>QTY</font> </th>";
echo "<th bgcolor='#3b5998'> <font color=white class='head'>Disc</font> </th>";
echo "<th bgcolor='#3b5998'> <font color=white class='head'>Total</font> </th>";
echo "<th bgcolor='#3b5998'> <font color=white class='head'>Time</font> </th>";
echo "<th bgcolor='#3b5998'> <font color=white class='head'>Date</font> </th>";
echo "<th bgcolor='#3b5998'> <font color=white class='head'>User</font> </th>";
echo "<th bgcolor='#3b5998'> <font color=white class='head'>Status</font> </th>";
echo "<th bgcolor='#3b5998'> <font color=white class='head'>Payment</font> </th>";
echo "</tr>";
$ro->getPatientChargesByTitle($registrationNo, $module, $month, $day, $year, $fromTime_hour, $fromTime_minutes, $fromTime_seconds, $toTime_hour, $toTime_minutes, $toTime_seconds, $username, $module, $nod);
echo "</table>";
if ($module == "LABORATORY") {
//echo "<br><br><a href='http://".$ro->getMyUrl()."/COCONUT/Laboratory/labRequest.php?registrationNo=$registrationNo&dateCharge=$dateCharge' target='_blank'><font color=red size=2><< Print Lab Request >></font></a>";
echo "<br><br><a href='http://" . $ro->getMyUrl() . "/COCONUT/Laboratory/labFormPrint.php?registrationNo={$registrationNo}&dateCharge={$dateCharge}' target='_blank'><font color=red size=2><< Print Lab Request >></font></a>";
} else {
}
if ($module == "PHARMACY") {
echo "<Br><br><br>RETURNS<br>";
$ro->showReturnz($registrationNo, $username, $module, $month, $day, $year, $fromTime_hour, $fromTime_minutes, $fromTime_seconds, $toTime_hour, $toTime_minutes, $toTime_seconds, $nod);
} else {
}
echo "<br><br>";
$ro->getPatientProfile($registrationNo);
echo "<form method='post' action='/COCONUT/currentPatient/patientInterface1.php' target='_blank'><input id='namez' style='border:1px solid #000; color:red;' type='submit' value='(" . $registrationNo . ") " . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "'>\n<input type='hidden' name='registrationNo' value='{$registrationNo}'><input type='hidden' name='username' value='" . $username . "'></form>";
<?php
include "../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database2();
$ro->getPatientProfile($registrationNo);
echo "Subsidiary Ledger<br>";
echo "<b>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</b>";
echo "<br>";
echo "<form method='post' action='/COCONUT/currentPatient/patientInterface1.php' target='_blank'><input id='namez' style='border:1px solid #000; color:red;' type='submit' value='View Profile'>\n<input type='hidden' name='registrationNo' value='{$registrationNo}'><input type='hidden' name='username' value='{$username}'></form>";
$ro->accounting_patientSubLedger($registrationNo);
<?php
include "../../../myDatabase2.php";
$itemNo = $_GET['itemNo'];
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$qty = $_GET['qty'];
$orNo = $_GET['orNo'];
$ro = new database2();
$ro->getPatientProfile($registrationNo);
if ($ro->doubleSelectNow("patientCharges", "quantity", "itemNo", $itemNo, "registrationNo", $registrationNo) < $qty) {
echo "<script> alert('Pls Return a quantity that will not more than " . $ro->doubleSelectNow("patientCharges", "quantity", "itemNo", $itemNo, "registrationNo", $registrationNo) . "'); window.back();</script>";
} else {
if ($ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo) == $qty) {
$ro->editNow("patientCharges", "itemNo", $itemNo, "status", "DELETED_" . $username . "[" . date("Y-m-d") . "@" . date("H:i:s") . "]-(return)");
} else {
$deductedQTY = $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo) - $qty;
$discountedPriceEachItem = $ro->selectNow("patientCharges", "cashPaid", "itemNo", $itemNo) / $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo);
$discountEachItem = $ro->selectNow("patientCharges", "discount", "itemNo", $itemNo) / $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo);
$ro->editNow("patientCharges", "itemNo", $itemNo, "total", $discountedPriceEachItem * $deductedQTY);
$ro->editNow("patientCharges", "itemNo", $itemNo, "discount", $discountEachItem * $deductedQTY);
$ro->editNow("patientCharges", "itemNo", $itemNo, "cashPaid", $discountedPriceEachItem * $deductedQTY);
$ro->editNow("patientCharges", "itemNo", $itemNo, "quantity", $deductedQTY);
}
$ro->returnInventory_pharmacy($itemNo, $registrationNo, $ro->selectNow("patientCharges", "description", "itemNo", $itemNo), $qty, date("Y-m-d") . "@" . date("H:i:s"), $username);
$ro->addVoidPayment($registrationNo . "_" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName(), $itemNo . "_" . $ro->selectNow("patientCharges", "description", "itemNo", $itemNo), $ro->selectNow("patientCharges", "cashPaid", "itemNo", $itemNo), date("H:i:s"), date("Y-m-d"), $username, $orNo);
$newQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)) + $qty;
$ro->editNow("inventory", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo), "quantity", $newQTY);
}
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientProfile_handler.php?registrationNo={$registrationNo}&username={$username}");
$reconcileNo = $_GET['reconcileNo'];
$registrationNo = $_GET['registrationNo'];
$ro = new database2();
$ro->getPatientProfile($registrationNo);
$ro->coconutDesign();
echo "<Br><Br><Br>";
$ro->coconutFormStart("get", "reconcileDetails_editNow.php");
$ro->coconutHidden("reconcileNo", $reconcileNo);
$ro->coconutHidden("registrationNo", $registrationNo);
$ro->coconutBoxStart("500", "200");
echo "<Br>";
echo "<table border=0>";
echo "<Tr>";
echo "<Td>Patient </tD>";
echo "<td>";
$ro->coconutTextBox_readonly("patient", $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName());
echo "</td>";
echo "</tr>";
echo "<Tr>";
echo "<Td>Ref No#: </tD>";
echo "<td>";
$ro->coconutTextBox("refno", $ro->doubleSelectNow("phicReconcile", "refno", "registrationNo", $registrationNo, "reconcileNo", $reconcileNo));
echo "</td>";
echo "</tr>";
echo "<Tr>";
echo "<Td>Amount </tD>";
echo "<td>";
$ro->coconutTextBox("amount", $ro->doubleSelectNow("phicReconcile", "amount", "registrationNo", $registrationNo, "reconcileNo", $reconcileNo));
echo "</td>";
echo "</tr>";
$datePd = preg_split("/\\_/", $ro->doubleSelectNow("phicReconcile", "date", "registrationNo", $registrationNo, "reconcileNo", $reconcileNo));
<?php
include "../../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database2();
echo "<style type='text/css'>\n\n.editable{\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight: 15px;\n\twidth: 80px;\n\tborder-color:white white white white;\n\tfont-size:10px;\n\ttext-align:center;\n}\n\n\n</style>";
$ro->getPatientProfile($registrationNo);
echo "<center><font size=4>" . $ro->getReportInformation("hmoSOA_name") . "</font></center>";
echo "<center><font size=3>" . $ro->getReportInformation("hmoSOA_address") . "</font></center>";
echo "<center><font size=2>Tel no. (062) 2143237</font></center>";
echo "<br><Br><Br><br>";
echo "<table border=0 cellspacing=0>";
echo "<tr>";
echo "<td><b>PATIENT:</b></td>";
echo "<tD>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</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>";
<?php include "../../myDatabase2.php"; $registrationNo = $_GET['registrationNo']; $dateCharge = $_GET['dateCharge']; $ro = new database2(); $ro->getPatientProfile($registrationNo); echo "<b>Name: </b>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName(); echo "<Br>"; echo "<b>Age/Sex: </b>" . $ro->getPatientRecord_age() . "/" . $ro->getPatientRecord_gender(); echo "<br>"; echo "<b>D.O.B</b>: " . $ro->getPatientRecord_birthDate(); echo "<br>"; echo "<b>WARD: </b>" . $ro->getRegistrationDetails_room(); echo "<Br>"; echo "<b>Physician:</b> " . $ro->getAttendingDoc($registrationNo, "Attending"); echo "<br>"; echo "<b>Diagnosis:</b> " . $ro->getRegistrationDetails_IxDx(); echo "<Br><Br>"; $ro->printLabRequest($registrationNo, $dateCharge);
$ro->getPatientProfile($registrationNo);
echo "<style type='text/css'>";
echo "\r\n.patientName{\r\n\tborder: 1px solid #000;\r\n\tcolor: #000;\r\n\theight: 28px;\r\n\twidth: 340px;\r\n\tborder-color:white white black white;\r\n\tfont-size:17px;\r\n\r\n}\r\n\r\n.patientAge{\r\n\tborder: 1px solid #000;\r\n\tcolor: #000;\r\n\theight: 28px;\r\n\twidth: 120px;\r\n\tborder-color:white white black white;\r\n\tfont-size:17px;\r\n\r\n}\r\n\r\n.patientAddress{\r\n\tborder: 1px solid #000;\r\n\tcolor: #000;\r\n\theight: 28px;\r\n\twidth: 80%;\r\n\tborder-color:white white black white;\r\n\tfont-size:17px;\r\n\r\n}\r\n\r\n.medicoLegalInformation{\r\n\tborder: 1px solid #000;\r\n\tcolor: #000;\r\n\theight: 28px;\r\n\twidth: 50%;\r\n\tborder-color:white white black white;\r\n\tfont-size:17px;\r\n\r\n}\r\n\r\n.medicoLegalInformation1{\r\n\tborder: 1px solid #000;\r\n\tcolor: #000;\r\n\theight: 28px;\r\n\twidth: 60%;\r\n\tborder-color:white white black white;\r\n\tfont-size:17px;\r\n\r\n}\r\n\r\n.txtBox {\r\n\tborder: 1px solid #000;\r\n\tcolor: #000;\r\n\theight: 130px;\r\n\twidth: 80%;\r\n\tpadding:4px 4px 4px 5px;\r\n}\r\n\r\n";
echo "</style>";
echo "<center>";
echo "<font size=3>Cabrera St,Pagadian City</font>";
echo "<br><font size=2>Philipines</font>";
echo "<br><font size=2>Tel No.(062) 2143737</font>";
echo "<hr>";
echo "<br><b><font size=5>MEDICO LEGAL</font></b>";
$ro->coconutFormStart("post", "medicoLegal_edit1.php");
$ro->coconutHidden("registrationNo", $registrationNo);
echo "<br><br><br>";
echo "<table border=0 width='70%'>";
echo "<Tr>";
echo "<td width='70%'>Name: <input type='text' class='patientName' value='" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "'></td>";
echo "<td width='30%'>Age: <input type='text' class='patientAge' value='" . $ro->getPatientRecord_Age() . "'></td>";
echo "</tr>";
echo "</table>";
echo "<table border=0 width='70%'>";
echo "<td>Address: <input type='text' class='patientAddress' value='" . $ro->getPatientRecord_address() . "'></td>";
echo "</table>";
echo "<Br><br>";
echo "<table border=0 width='70%'>";
echo "<tr>";
echo "<td>DATE OF INCIDENCCE: <input type='text' autocomplete='off' name='dateOfIncidence' class='medicoLegalInformation' value='" . $ro->selectNow("medicoLegal", "dateOfIncidence", "registrationNo", $registrationNo) . "'></td>";
echo "</tr>";
echo "<tr>";
echo "<td>TIME OF INCIDENCCE: <input type='text' autocomplete='off' name='timeOfIncidence' class='medicoLegalInformation' value='" . $ro->selectNow("medicoLegal", "timeOfIncidence", "registrationNo", $registrationNo) . "'></td>";
echo "</tr>";
echo "<tr>";
<div id='printData'>
<?php
echo "<center><img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/mendero.png' width='60%' height='20%'></center>";
//echo "<center><div style='border:0px solid #000000; width:700px; height:auto; border-color:black black black black;'>";
echo "";
//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 {
//require_once('../authentication.php');
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database2();
/*
$ro->getBatchNo();
$myFile = $ro->getReportInformation("homeRoot")."/COCONUT/trackingNo/batchNo.dat";
$fh = fopen($myFile, 'r');
$batchNo = fread($fh, 100);
fclose($fh);
*/
$batchNo = $ro->selectNow("trackingNo", "value", "name", "batchNo");
echo "\n\n<style type='text/css'>\na \n{ \ntext-decoration:none;\ncolor:black;\nfont-weight:bold;\n }\nul { list-style-type:none; }\ndisplay: block;\n</style>\n\n";
$ro->getPatientProfile($registrationNo);
if ($ro->selectNow("registeredUser", "module", "username", $ro->getRegistrationDetails_registeredBy()) == "MI") {
echo "<br><hr><font size=2 color=blue>" . $ro->getPatientRecord_lastName() . " " . $ro->getPatientRecord_firstName() . " " . $ro->getPatientRecord_middleName() . ".</font><hr>";
} else {
echo "<br><hr>\n\n<font size=2 color=red>" . htmlentities($ro->getPatientRecord_lastName()) . " " . htmlentities($ro->getPatientRecord_firstName()) . " " . htmlentities($ro->getPatientRecord_middleName()) . "</font>\n\n<hr>";
}
echo "<ul>";
echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientProfile_right.php?registrationNo=" . $ro->getRegistrationDetails_registrationNo() . "&username={$username}' target='rightFrame'><font size=2>Information</font></a></li>";
if ($ro->getRegistrationDetails_caseType() != "") {
echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/phicLimit/show_phicLimit.php?registrationNo={$registrationNo}&casetype=" . $ro->getRegistrationDetails_caseType() . "' target='rightFrame'><font size=2>Credit Limit</font></a></li>";
} else {
echo "";
}
/*
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 "";
<a href='#' onClick="printF('printData')" style="text-decoration:none;"><?php
echo $ro->coconutImages("printer.jpeg");
?>
<font color=red>Print</font></a><Br><Br>
<div id="printData">
<?php
echo "<Center><font size=3>" . $ro->getReportInformation("hmoSOA_name") . "</font></center>";
echo "<center><font size=2>" . $ro->getReportInformation("hmoSOA_address") . "</font></center>";
echo "<Br>\n<center><b><font size=2>STATEMENT OF ACTUAL CHARGES</font></b></center>\n";
$actual = 0;
$phic = 0;
$company = 0;
$excess = 0;
echo "<font size=2>Name: " . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</font>";
echo " ";
echo "<font size=2>Doctor: " . $ro->getAttendingDoc($registrationNo, "ATTENDING") . "</font>";
echo "<Br>";
echo "<font size=2>Date: " . date("M d, Y") . "</font>";
echo "<Table border=1 cellpadding=1 cellspacing=0>";
echo "<tr>";
echo "<th><font size=2>HOSPITAL CHARGES</font></th>";
echo "<th><font size=2>ACTUAL</font></th>";
echo "<th><font size=2>PHILHEALTH</font></th>";
echo "<th><font size=2>COMPANY</font></th>";
echo "<th><font size=2>EXCESS</font></th>";
echo "</tr>";
echo "<tr>";
echo "<td> <font size=2>DIALYSIS</font></tD>";
$actual += $ro->getTotal_hdu("total", "DIALYSIS", $registrationNo);
<br>
<table border=0 width='100%'>
<tr>
<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>
