<?php
include "../../myDatabase1.php";
$ro = new database1();
$ro->coconutDesign();
echo "<br><br><br><br><br>";
$ro->coconutFormStart("get", "addPackage1.php");
$ro->coconutBoxStart("500", "80");
echo "<Br>";
echo "<table border=0>";
echo "<tr>";
echo "<Td>Package Name </tD>";
echo "<td>";
$ro->coconutTextBox("packageName", "");
echo "</td>";
echo "</tr>";
echo "</table>";
echo "<br>";
$ro->coconutButton("Proceed");
$ro->coconutBoxStop();
$ro->coconutFormStop();
echo "<td><font size=2>THIS HOSPITAL FROM <input type=text class='underLine2' value='" . $ro->getRegistrationDetails_dateRegistered() . "'></font>\n<font size=2>TO</font>\n<input type=text class='underLine2' value='" . $ro->getRegistrationDetails_dateUnregistered() . "' >\n</td>";
echo "</tr>";
echo "<tr>";
echo "<td><font size=2>WITH THE FOLLOWING FINDINGS AND OR DIAGNOSIS:</font><input type='text' name='d1' class='underline2'></td>";
echo "</tr>";
echo "</table>";
echo "<input type=text name='d2' class='underLine3'>";
echo "<br>";
echo "<input type=text name='d3' class='underLine3'>";
echo "<br><Br>";
echo "<table border=0>";
echo "<tr>";
echo "<td><font size=2>THE CERTIFICATION IS ISSUED UPON REQUEST OF</font> <input type=text class='underLine'> </td>";
echo "</tr>";
echo "<tr>";
echo "<td><font size=2>FOR</font> <input type=text class='underLine3'> </td>";
echo "</tr>";
echo "</table>";
echo "<br><br>";
echo "<table border=0>";
echo "<tr>";
echo "<td width='25%'> </td>";
echo "<td width='10%'><input type='text' class='underLine4' value='" . $ro->getAttendingDoc($registrationNo, "Attending") . "'><br> <font size=2>ATTENDING PHYSICIAN</font></td>";
echo "</tr>";
echo "</table>";
$ro->coconutHidden("registrationNo", $registrationNo);
$ro->coconutButton("Printable Version");
$ro->coconutFormStop();
?>
</div>
echo "<td><b>Date:</b> " . $ro->selectNow("radioSavedReport", "date", "itemNo", $itemNo) . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td><b>Age/Sex</b> " . $ro->getPatientRecord_age() . "/" . $ro->getPatientRecord_gender() . "</td>";
echo "<td>Physician: <b>" . $ro->selectNow("radioSavedReport", "physician", "itemNo", $itemNo) . "</b></td>";
echo "</tr>";
echo "<tr>";
echo "<td><b>Room:</b> " . $ro->getRegistrationDetails_room() . "</td>";
echo "<td>Examination: <b>{$description}</b></td>";
echo "</tr>";
echo "</table>";
echo "<textarea id='report' name='radioReport' class='txtArea'>";
echo $ro->doubleSelectNow("radioSavedReport", "radioReport", "registrationNo", $registrationNo, "itemNo", $itemNo);
echo "</textarea>";
echo "<br><br>";
$ro->coconutButton("edit");
$ro->coconutFormStop();
?>
<script type="text/javascript">
CKEDITOR.replace( 'report',
{
enterMode : CKEDITOR.ENTER_BR,
skin : 'office2003'
});
</script>
<?php
include "../../../myDatabase1.php";
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$type = $_GET['type'];
$status = $_GET['status'];
$ro = new database1();
$ro->coconutFormStart("get", "showInventory.php");
$ro->coconutHidden("registrationNo", $registrationNo);
$ro->coconutHidden("username", $username);
$ro->coconutHidden("type", $type);
$ro->coconutHidden("status", "yes");
$ro->coconutButton("Check All");
$ro->coconutFormStop();
$ro->updatePrice_inventory($registrationNo, $username, $type, $status);
<?php
include "../../../myDatabase1.php";
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database1();
$ro->coconutDesign();
echo "<br><br><br><Br>";
$ro->coconutFormStart("get", "setMGH1.php");
$ro->coconutBoxStart("800", "80");
echo "<Br>";
echo "<font color=red size=2>If you tag the patient as <B>LOCKED</b> his/her profile will be totally locked and nobody can edit,change or delete the information,charges and payment that was saved before he/she tag Locked </font>";
$ro->coconutHidden("registrationNo", $registrationNo);
$ro->coconutHidden("username", $username);
echo "<Br><br>";
$ro->coconutButton("Locked Account");
$ro->coconutBoxStop();
$ro->coconutFormStop();
$ro->coconutTableRowStop();
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>PHILHEALTH PACKAGE</b>");
$ro->coconutTableData("<b>" . number_format($ro->selectNow("package", "price", "description", $ro->getRegistrationDetails_package()), 2) . "</b>");
$ro->coconutTableRowStop();
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>SHORT</b>");
$ro->coconutTableData("<font color=red><b>" . number_format($ro->selectNow("package", "price", "description", $ro->getRegistrationDetails_package()) - $totalPHIC, 2) . "</b></font>");
$ro->coconutTableRowStop();
$ro->coconutTableStop();
echo "<br><Br>";
$shortPHIC = $ro->selectNow("package", "price", "description", $ro->getRegistrationDetails_package()) - $totalPHIC;
$ro->coconutFormStart("get", "magicPackage1.php");
$ro->coconutHidden("short", $shortPHIC);
$ro->coconutHidden("registrationNo", $registrationNo);
$ro->coconutButton("Apply Short Package");
$ro->coconutFormStop();
/*
echo "MEDICINE: ".number_format($ro->getTotal("phic","MEDICINE",$registrationNo),2);
echo "<br>";
echo "SUPPLIES: ".number_format($ro->getTotal("phic","SUPPLIES",$registrationNo),2);
echo "<br>";
echo "LABORATORY: ".number_format($ro->getTotal("phic","LABORATORY",$registrationNo),2);
echo "<br>";
echo "RADIOLOGY: ".number_format($ro->getTotal("phic","RADIOLOGY",$registrationNo),2);
echo "<br>";
echo "ECG: ".number_format($ro->getTotal("phic","ECG",$registrationNo),2);
echo "<br>";
echo "NURSING: ".number_format($ro->getTotal("phic","NURSING-CHARGES",$registrationNo),2);
echo "<br>";
echo "MISCELLANEOUS: ".number_format($ro->getTotal("phic","MISCELLANEOUS",$registrationNo),2);
$ro->coconutTableData("<b>SHORT</b>");
$ro->coconutTableData("<font color=red><b>" . number_format($ro->selectNow("package", "price", "description", $ro->getRegistrationDetails_package()) - $totalPHIC, 2) . "</b></font>");
$ro->coconutTableRowStop();
$ro->coconutTableStop();
echo "<br><Br>";
$shortPHIC = $ro->selectNow("package", "price", "description", $ro->getRegistrationDetails_package()) - $totalPHIC;
$ro->coconutFormStart("get", "magicPackage1.php");
$ro->coconutHidden("short", $shortPHIC);
$ro->coconutHidden("registrationNo", $registrationNo);
$ro->coconutHidden("hb", $hb - $totalPHIC);
$ro->coconutHidden("pf", $ro->selectNow("package", "pf", "description", $ro->getRegistrationDetails_package()));
$ro->coconutComboBoxStart_long("doctor");
$ro->showOption_doubleWhere("patientCharges", "description", "registrationNo", $registrationNo, "title", "PROFESSIONAL FEE");
$ro->coconutComboBoxStop();
echo "<br><Br>";
$ro->coconutButton("Apply Short Package");
$ro->coconutFormStop();
$ro->coconutFormStart("get", "consumePackage.php");
$ro->coconutHidden("registrationNo", $registrationNo);
$ro->coconutButton("Consume Package >>");
$ro->coconutFormStop();
/*
echo "MEDICINE: ".number_format($ro->getTotal("phic","MEDICINE",$registrationNo),2);
echo "<br>";
echo "SUPPLIES: ".number_format($ro->getTotal("phic","SUPPLIES",$registrationNo),2);
echo "<br>";
echo "LABORATORY: ".number_format($ro->getTotal("phic","LABORATORY",$registrationNo),2);
echo "<br>";
echo "RADIOLOGY: ".number_format($ro->getTotal("phic","RADIOLOGY",$registrationNo),2);
echo "<br>";
echo "ECG: ".number_format($ro->getTotal("phic","ECG",$registrationNo),2);
<?php
include "../../myDatabase1.php";
$username = $_GET['username'];
$ro = new database1();
$ro->coconutDesign();
$ro->coconutFormStart("get", "manualSearch1.php");
$ro->coconutHidden("username", $username);
echo "<center><br><Br>";
$ro->coconutTextBox("patientName", "");
echo "<br><br>";
$ro->coconutButton("Search");
$ro->coconutFormStop();
