<?php include "../../../myDatabase1.php"; $reportNo = $_GET['reportNo']; $ro = new database1(); echo $ro->selectNow("radioReportList", "title", "reportNo", $reportNo); echo "<Br><Br>"; echo $ro->selectNow("radioReportList", "report", "reportNo", $reportNo);
$chargesCode = $_GET['chargesCode']; $description = $_GET['description']; $sellingPrice = $_GET['sellingPrice']; $discount = $_GET['discount']; $timeCharge = $_GET['timeCharge']; $room = $_GET['room']; $chargeBy = $_GET['chargeBy']; $service = $_GET['service']; $title = $_GET['title']; $paidVia = $_GET['paidVia']; $cashPaid = $_GET['cashPaid']; $batchNo = $_GET['batchNo']; $username = $_GET['username']; $inventoryFrom = $_GET['inventoryFrom']; $ro = new database1(); if ($ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode) < 1) { $ro->getBack("Sorry, Out of Stock"); } echo "\n<style type='text/css'>\n.qty {\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight:25px;\n\twidth: 100px;\n\tpadding:4px 4px 4px 10px;\n}\n\n</style>\n\n"; //addCharges.php echo "<br><Br><Br>"; echo "<form method='get' action='http://" . $ro->getMyUrl() . "/COCONUT/availableSupplies/phicCovered.php'>"; echo "<center><div style='border:1px solid #000000; width:400px; height:100px;\t'>"; echo "<br><table border=0 cellpadding=0 cellspacing=0>"; echo "<tr>"; echo "<td><font size=4>Quantity:</font></td>"; echo "<td><input type=text class='qty' name='quantity' value='1'></td>"; echo "</tr>"; echo "<tr><td> </td></tr>"; echo "<tr>"; echo "<td><input type='button' class='button' value=' Back '\nonClick='javascript: history.go(-1)' style='border:1px solid #000000; background-color:transparent;'></td>";
$ro = new database1(); ?> <script type="text/javascript" src="/ckeditor/ckeditor.js"></script> <?php echo "\n<style type='text/css'>\n\n.txtArea {\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight: auto;\n\twidth:900px;\n\tpadding:4px 4px 4px 5px;\n\tfont-size:20px;\n}\n\n</style>\n"; $ro->getPatientProfile($registrationNo); $ro->coconutFormStart("get", "radioReport_update.php"); $ro->coconutHidden("registrationNo", $registrationNo); $ro->coconutHidden("itemNo", $itemNo); echo "<table border=0 width='160%'>"; echo "<tr>"; echo "<td><b>Name:</b> " . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</td>"; 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");
<?php include "../../../myDatabase1.php"; $registrationNo = $_GET['registrationNo']; $itemNo = $_GET['itemNo']; $physician = $_GET['physician']; $radioReport = $_GET['radioReport']; $radtech = $_GET['radtech']; $ro = new database1(); if (isset($_GET['approved'])) { $ro->radioReportInsert($registrationNo, $itemNo, date("Y-m-d"), $physician, $radioReport, "Mendero Medical Center", "Consolacion,Cebu", $ro->getSynapseTime(), "yes", date("Y-m-d"), $ro->getSynapseTime(), $physician, $radtech); } else { $ro->radioReportInsert($registrationNo, $itemNo, date("Y-m-d"), $physician, $radioReport, "Mendero Medical Center", "Consolacion,Cebu", $ro->getSynapseTime(), "", "", "", "", $radtech); } $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Reports/radiologyReport/radioReport_output.php?itemNo={$itemNo}®istrationNo={$registrationNo}&description=" . $ro->selectNow("patientCharges", "description", "itemNo", $itemNo) . "");
<?php include "../../../myDatabase1.php"; $packageNo = $_GET['packageNo']; $countz = count($packageNo); $registrationNo = $_GET['registrationNo']; $username = $_GET['username']; $ro = new database1(); $ro->getPatientProfile($registrationNo); for ($x = 0; $x < $countz; $x++) { $packageIncluded = preg_split("/\\_/", $ro->selectNow("hospitalPackage", "packageIncluded_description", "packageNo", $packageNo[$x])); //addCharges_cash($status,$registrationNo,$chargesCode,$description,$sellingPrice,$discount,$total,$cashUnpaid,$phic,$company,$timeCharge,$dateCharge,$chargeBy,$service,$title,$paidVia,$cashPaid,$batchNo,$quantity,$inventoryFrom,$branch,$room) if ($packageIncluded[2] != "MEDICINE" || $packageIncluded[2] != "PROFESSIONAL FEE") { $services = "Examination"; } else { if ($packageIncluded[2] == "MEDICINE") { $services = "Medication"; } else { $services = "PROFESSIONAL FEE"; } } $ro->addCharges_cash("UNPAID", $registrationNo, $packageIncluded[1], $packageIncluded[0], "0.00", "0.00", "0.00", "0.00", "0.00", "0.00", $ro->getSynapseTime(), date("M_d_Y"), $username, $services, $packageIncluded[2], "Cash", "0.00", "package", $ro->selectNow("hospitalPackage", "packageIncluded_qty", "packageNo", $packageNo[$x]), "", $ro->getRegistrationDetails_branch(), $ro->getRegistrationDetails_room()); } echo "\n<script type='text/javascript'>\nwindow.parent.location.reload();\n</script>\n\n";
<?php include "../packageControl.php"; include "../../../myDatabase1.php"; $packageName = $_GET['packageName']; $registrationNo = $_GET['registrationNo']; $username = $_GET['username']; $package = new hospitalPackage(); $ro = new database1(); /* $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 "<center><font size=2 color=red>UNCHECK means the medicine/supplies is not available in the pharmacy</font>"; echo "<Br><Br>"; $package->showAddedPackage_onPatient($packageName, $registrationNo, $username, $batchNo);
<?php include "../../../myDatabase1.php"; $packageNo = $_GET['packageNo']; $countz = count($packageNo); $registrationNo = $_GET['registrationNo']; $username = $_GET['username']; $batchNo = $_GET['batchNo']; $unitcost = $_GET['unitcost']; $Added = $_GET['Added']; $ro = new database1(); $ro->getPatientProfile($registrationNo); for ($x = 0; $x < $countz; $x++) { $packageIncluded = preg_split("/\\_/", $ro->selectNow("hospitalPackage", "packageIncluded_description", "packageNo", $packageNo[$x])); //addCharges_cash($status,$registrationNo,$chargesCode,$description,$sellingPrice,$discount,$total,$cashUnpaid,$phic,$company,$timeCharge,$dateCharge,$chargeBy,$service,$title,$paidVia,$cashPaid,$batchNo,$quantity,$inventoryFrom,$branch,$room) $sellingPrice; if ($packageIncluded[2] == "LABORATORY" || $packageIncluded[2] == "RADIOLOGY" || $packageIncluded[2] == "ECG" || $packageIncluded[2] == "OR/DR/ER/ Fee" || $packageIncluded[2] == "REHAB") { $services = "Examination"; $chargesPrice = $ro->selectNow("availableCharges", "PRIVATE", "chargesCode", $packageIncluded[1]); $ro->addCharges_cash("UNPAID", $registrationNo, $packageIncluded[1], $packageIncluded[0], $chargesPrice, "0.00", $chargesPrice, $chargesPrice, "0.00", "0.00", $ro->getSynapseTime(), date("Y-m-d"), $username, $services, $packageIncluded[2], "Cash", "0.00", $batchNo, $ro->selectNow("hospitalPackage", "packageIncluded_qty", "packageNo", $packageNo[$x]), "PHARMACY", $ro->getRegistrationDetails_branch(), $ro->getRegistrationDetails_room()); } else { if ($packageIncluded[2] == "MEDICINE") { $services = "Medication"; $medPrice = preg_split("/\\_/", $ro->selectNow("hospitalPackage", "Added", "packageNo", $packageNo[$x])); $ro->addCharges_cash("UNPAID", $registrationNo, $packageIncluded[1], $packageIncluded[0], $medPrice[1], "0.00", $medPrice[1], $medPrice[1], "0.00", "0.00", $ro->getSynapseTime(), date("Y-m-d"), $username, $services, $packageIncluded[2], "Cash", "0.00", $batchNo, $ro->selectNow("hospitalPackage", "packageIncluded_qty", "packageNo", $packageNo[$x]), "PHARMACY", $ro->getRegistrationDetails_branch(), $ro->getRegistrationDetails_room()); } else { if ($packageIncluded[2] == "SUPPLIES") { $services = "Others"; $supPrice = $ro->selectNow("hospitalPackage", "unitcost", "packageNo", $packageNo[$x]); $ro->addCharges_cash("UNPAID", $registrationNo, $packageIncluded[1], $packageIncluded[0], $supPrice, "0.00", $supPrice, $supPrice, "0.00", "0.00", $ro->getSynapseTime(), date("Y-m-d"), $username, $services, $packageIncluded[2], "Cash", "0.00", $batchNo, $ro->selectNow("hospitalPackage", "packageIncluded_qty", "packageNo", $packageNo[$x]), "PHARMACY", $ro->getRegistrationDetails_branch(), $ro->getRegistrationDetails_room()); } else {
a.document.close(); a.focus(); a.print(); a.close(); } </script> <a href="#" onClick="printF('printData')" style="text-decoration:none; color:black;"><font color=red>PRINT</font></a> <div id='printData'> <?php echo "<center><a href='http://" . $ro->getMyUrl() . "/COCONUT/Reports/radiologyReport/radioReport_output_doctor.php?registrationNo={$registrationNo}&itemNo={$itemNo}&description={$description}'><img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/mendero.png' width='40%;' height='20%'></a></center>"; echo "<br>"; echo "<table border=0 width='100%;'>"; echo "<Tr>"; echo "<td><b>NAME:</b> " . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</td>"; echo "<tD align='left'><b>DATE:</b> " . $ro->selectNow("radioSavedReport", "date", "itemNo", $itemNo) . "</tD>"; echo "</tr>"; echo "<tr>"; echo "<td><b>PATIENT NO:</b> " . $ro->getRegistrationDetails_patientNo() . "</td>"; echo "<td><b>AGE:</b> " . $ro->getPatientRecord_age() . "/" . $ro->getPatientRecord_gender() . "</td>"; echo "</tr>"; echo "<tr>"; echo "<td><b>PERFORMED: </b> " . $ro->selectNow("radioSavedReport", "performed", "itemNo", $itemNo) . "</td>"; echo "</tr>"; echo "<tr>"; echo "<td><B>PROCEDURE:</b> " . $ro->selectNow("patientCharges", "description", "itemNo", $itemNo) . "</td>"; echo "</tr>"; echo "</table>"; echo "</center>"; echo "<font size=4>" . $ro->selectNow("radioSavedReport", "radioReport", "itemNo", $itemNo) . "</font>"; echo "<br><br><br><br>";
<?php include "../../../myDatabase1.php"; $itemNo = $_GET['itemNo']; $count = count($itemNo); $registrationNo = $_GET['registrationNo']; $username = $_GET['username']; $type = $_GET['type']; $ro = new database1(); for ($x = 0; $x < $count; $x++) { //echo "<br>".$itemNo[$x]; if ($type == "PhilHealth") { $ro->getPatientChargesToEdit($itemNo[$x]); if ($ro->selectNow("patientCharges", "title", "itemNo", $itemNo[$x]) == "MEDICINE" || $ro->selectNow("patientCharges", "title", "itemNo", $itemNo[$x]) == "SUPPLIES") { $newPrice = $ro->getInventoryPrice($ro->patientCharges_chargesCode()) + $ro->getInventoryPrice($ro->patientCharges_chargesCode()) * 0.25; } else { $newPrice = $ro->selectNow("availableCharges", "OPD", "chargesCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo[$x])) + $ro->selectNow("availableCharges", "OPD", "chargesCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo[$x])) * 0.25; } //phic Price //$newTotal = ($newPrice * $ro->patientCharges_quantity()); } else { if ($type == "CASH") { $ro->getPatientChargesToEdit($itemNo[$x]); if ($ro->selectNow("patientCharges", "title", "itemNo", $itemNo[$x]) == "MEDICINE" || $ro->selectNow("patientCharges", "title", "itemNo", $itemNo[$x]) == "SUPPLIES") { $newPrice = $ro->getInventoryPrice($ro->patientCharges_chargesCode()); //phic Price } else { $newPrice = $ro->selectNow("availableCharges", "OPD", "chargesCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo[$x])); } ///$newTotal = ($newPrice * $ro->patientCharges_quantity()); } else {
<?php include "../../../myDatabase1.php"; $username = $_GET['username']; $itemNo = $_GET['itemNo']; $registrationNo = $_GET['registrationNo']; $ro = new database1(); $ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "cashPaid", $ro->doubleSelectNow("patientCharges", "cashUnpaid", "itemNo", $itemNo, "registrationNo", $registrationNo)); // kuhain ang total price at ilagay sa cashPaid cols $ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "cashUnpaid", "0"); // gwen 0 ang cashUnpaid cols $ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "status", "PAID"); // tagged as PAID $ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "datePaid", date("M_d_Y")); $ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "timePaid", $ro->getSynapseTime()); $ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "paidBy", $username); // gwen 0 ang cashUnpaid cols $newQty = $ro->selectNow("inventory", "quantity", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)) - $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo); $ro->editNow("inventory", "inventoryCode", $ro->doubleSelectNow("patientCharges", "chargesCode", "itemNo", $itemNo, "registrationNo", $registrationNo), "quantity", $newQty); $ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "departmentStatus", "dispensedBy_" . $username); $ro->doubleEditNow("patientCharges", "itemNo", $itemNo, "registrationNo", $registrationNo, "departmentTime", $ro->getSynapseTime());
<?php include "../../../myDatabase1.php"; $paymentNo = $_GET['paymentNo']; $registrationNo = $_GET['registrationNo']; $username = $_GET['username']; $ro = new database1(); $ro->getPatientProfile($registrationNo); $ro->addVoidPayment($registrationNo . "_" . $ro->getPatientRecord_completeName(), "IPD_DELETE_" . $ro->selectNow("patientPayment", "paymentFor", "paymentNo", $paymentNo), $ro->selectNow("patientPayment", "amountPaid", "paymentNo", $paymentNo), $ro->getSynapseTime(), date("Y-m-d"), $username); $ro->deleteNow("patientPayment", "paymentNo", $paymentNo); echo "\n\n<script type='text/javascript'>\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/Payments/viewPayment.php?username={$username}®istrationNo={$registrationNo}'\n</script>\n\n";
echo "<tr>"; echo "<td><b>AGE: </b>" . $ro->getPatientRecord_age() . "/" . $ro->getPatientRecord_gender() . "</td>"; echo "<td></td>"; echo "</tr>"; echo "<tr>"; echo "<td><b>PROCEDURE:</b> {$description}</td>"; echo "<td></td>"; echo "</tr>"; echo "<tr>"; echo "<td></td>"; echo "</tr>"; echo "<tr>"; echo "<td></td>"; echo "</tr>"; echo "</table>"; $text = $ro->selectNow("radioReportList", "report", "title", $report); //$breaks = array("<br>","<br/>","<b>","</b>"); //$text1 = str_ireplace($breaks, "\r\n",$text); echo "<textarea id='report' name='radioReport'>"; echo $text; echo "</textarea>"; echo "<br>"; echo "<input type='checkbox' name='approved'><font color=red>Approved</font>"; echo "<bR><br>"; $ro->coconutButton("Proceed"); $ro->coconutFormStop(); echo "</div></div>"; ?> <script type="text/javascript" src="http://<?php echo $ro->getMyUrl();
$description = $_GET['description']; $sellingPrice = $_GET['sellingPrice']; $timeCharge = $_GET['timeCharge']; $chargeBy = $_GET['chargeBy']; $service = $_GET['service']; $title = $_GET['title']; $paidVia = $_GET['paidVia']; $cashPaid = $_GET['cashPaid']; $batchNo = $_GET['batchNo']; $username = $_GET['username']; $discount = $_GET['discount']; $inventoryFrom = $_GET['inventoryFrom']; $room = $_GET['room']; $quantity = $_GET['quantity']; $ro = new database1(); $ro->getPHIClimit_setter($ro->selectNow("registrationDetails", "casetype", "registrationNo", $registrationNo)); $ro->getPatientProfile($registrationNo); // kunin ang data ng patient //$totalPrice = $sellingPrice * $quantity; //kunin ang total price //selectNow($table,$cols,$identifier,$identifierData) //$ro->selectNow("inventory","phic","inventoryCode",$chargesCode); // ttgnan kung cover ba ng philhealth ung medicine if ($quantity == 0) { $ro->getBack("Zero is not Allowed"); } else { //number_format($ro->getCurrentPHIC_check($registrationNo,"MEDICINE") - $ro->getPHIClimit_medicine(),2) $remainingLimit = $ro->getPHIClimit_medicine() - $ro->getCurrentPHIC_check($registrationNo, "MEDICINE"); if ($ro->getPatientRecord_phic() == "YES") { //cover at pasok pa sa phic limit ng meds $totalPrice = $sellingPrice * $quantity; //phic price if ($remainingLimit >= $totalPrice) {
<?php include "../../myDatabase1.php"; $password = $_POST['password']; $comment = $_POST['comment']; $ro = new database1(); if ($ro->selectNow("registeredUser", "username", "password", $password) != "") { $username = $ro->selectNow("registeredUser", "username", "password", $password); header("Location: /COCONUT/Homepage/addComment.php?username={$username}&comment={$comment}"); } else { echo "<script type='text/javascript'>\nalert('Incorrect Password');\nhistory.back();\n</script>"; }
<?php include "../myDatabase1.php"; $patientNo = $_GET['patientNo']; $date = $_GET['date']; $ro = new database1(); if ($ro->selectNow("reportHeading", "information", "reportName", "stopDoubleRegistration") == "Activate") { if ($ro->checkingStop($patientNo, date("Y-m-d")) == "") { header("Location:http://" . $ro->getMyUrl() . "/Registration/newRecord_again.php?patientNo={$patientNo}"); } else { header("Location:http://" . $ro->getMyUrl() . "/Registration/stopRegistration.php"); } } else { header("Location:http://" . $ro->getMyUrl() . "/Registration/newRecord_again.php?patientNo={$patientNo}"); }
<?php include "../../../myDatabase1.php"; $registrationNo = $_GET['registrationNo']; $username = $_GET['username']; $ro = new database1(); if ($ro->selectNow("promisorryNote", "registrationNo", "registrationNo", $registrationNo) != "") { header("Location: editPromisorry.php?username={$username}®istrationNo={$registrationNo}"); } else { header("Location: addPromisorry.php?username={$username}®istrationNo={$registrationNo}"); }
$sellingPrice = $_GET['sellingPrice']; $timeCharge = $_GET['timeCharge']; $chargeBy = $_GET['chargeBy']; $service = $_GET['service']; $title = $_GET['title']; $paidVia = $_GET['paidVia']; $cashPaid = $_GET['cashPaid']; $batchNo = $_GET['batchNo']; $username = $_GET['username']; $discount = $_GET['discount']; $inventoryFrom = $_GET['inventoryFrom']; $room = $_GET['room']; $quantity = $_GET['quantity']; $remarks = $_GET['remarks']; $ro = new database1(); $ro->getPHIClimit_setter($ro->selectNow("registrationDetails", "casetype", "registrationNo", $registrationNo)); $ro->getPatientProfile($registrationNo); // kunin ang data ng patient //$totalPrice = $sellingPrice * $quantity; //kunin ang total price //selectNow($table,$cols,$identifier,$identifierData) //$ro->selectNow("inventory","phic","inventoryCode",$chargesCode); // ttgnan kung cover ba ng philhealth ung medicine //number_format($ro->getCurrentPHIC_check($registrationNo,"MEDICINE") - $ro->getPHIClimit_medicine(),2) if ($quantity == 0) { $ro->getBack("Zero is not Allowed"); } else { $remainingLimit = $ro->getPHIClimit_suppliesOnly() - $ro->getTotal("phic", "SUPPLIES", $registrationNo); if ($ro->selectNow("inventory", "phic", "inventoryCode", $chargesCode) == "yes" && $ro->getPatientRecord_phic() == "YES") { //cover at pasok pa sa phic limit ng meds //$totalPrice = (($sellingPrice * 0.15) + $sellingPrice) * $quantity; //phic price $totalPrice = $sellingPrice * $quantity; // cashPrice muna for temporary
echo "<style type='text/css'>"; echo "\n\n.linez{\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight: 28px;\n\twidth: 300px;\n\tfont-weight:bold;\n\tborder-color:white white black white;\n\tfont-size:15px;\n\n}\n\n"; echo "</style>"; //echo "<br>"; //echo "<center><font size=4><b>MENDERO MEDICAL CENTER</b></font></center>"; //echo "<center><b><font size=3><b>LABORATORY DEPARTMENT</b></font></b></center>"; //echo "<center><font size=3>Consolacion, Cebu City</font></center>"; //echo "<center><font size=3>Tel No. 062-2143237</font></center>"; echo "<br><br><br><Br><br><Br><Br><Br>"; echo "<center>"; echo "<table border=0 cellspacing=0 cellpadding=1 width='100%' >"; echo "<tr>"; echo "<td><B>Patient ID:</b></td>"; echo "<td><input type='text' class='linez' value='" . $ro->getRegistrationDetails_patientNo() . "'></td>"; echo "<td><B>Date:</b></td>"; echo "<td><input type='text' class='linez' value='" . $ro->selectNow("labSavedResult", "date", "itemNo", $itemNo) . "@" . $ro->selectNow("labSavedResult", "time", "itemNo", $itemNo) . "'></td>"; echo "</tr>"; echo "<tr>"; echo "<td><b>Name:</b></td>"; echo "<td><input type='text' class='linez' value='" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . " " . $ro->getPatientRecord_middleName() . "'></td>"; echo "<td><b>Age/Sex:</b></td>"; echo "<td><input type='text' class='linez' value='" . $ro->getPatientRecord_age() . "/" . $ro->getPatientRecord_gender() . "'></td>"; echo "</tr>"; echo "<tr>"; echo "<Td><b>Date of Birth:</td>"; echo "<td></b><input type='text' class='linez' value='" . $ro->getPatientRecord_birthDate() . "'></tD>"; echo "<td><b>Status:</td>"; echo "<td></b><input type='text' class='linez' value='" . $ro->getPatientRecord_civilStatus() . "'></tD>"; echo "</tr>"; echo "<tr>"; echo "<Td><b>Physician:</b></td>";
$itemNo = $_GET['itemNo']; $username = $_GET['username']; $module = $_GET['module']; $month = $_GET['month']; $day = $_GET['day']; $year = $_GET['year']; $fromTime_hour = $_GET['fromTime_hour']; $fromTime_minutes = $_GET['fromTime_minutes']; $fromTime_seconds = $_GET['fromTime_seconds']; $toTime_hour = $_GET['toTime_hour']; $toTime_minutes = $_GET['toTime_minutes']; $toTime_seconds = $_GET['toTime_seconds']; $ro = new database1(); //$ro->doubleEditNow("patientCharges","registrationNo",$registrationNo,"itemNo",$itemNo,"status","PAID"); //$ro->doubleEditNow("patientCharges","registrationNo",$registrationNo,"itemNo",$itemNo,"cashUnpaid","0.00"); if ($ro->selectNow("patientCharges", "title", "itemNo", $itemNo) == "MEDICINE") { $price = preg_split("/\\_/", $ro->selectNow("inventory", "Added", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo))); $totalPay = $price[1] * $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "status", "PAID"); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "cashUnpaid", "0.00"); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "phic", "0.00"); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "company", "0.00"); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "cashPaid", $totalPay); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "sellingPrice", $price[1]); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "total", $totalPay); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "datePaid", date("Y-m-d")); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "timePaid", $ro->getSynapseTime()); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "paidBy", $username); } else { //supplies $totalPay = $ro->selectNow("inventory", "unitcost", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)) * $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo);
$ro->coconutTableRowStop(); $ro->coconutTableRowStart(); $ro->coconutTableData("Room's"); $ro->coconutTableData(number_format($ro->getTotal("phic", "Room And Board", $registrationNo), 2)); $ro->coconutTableRowStop(); $ro->coconutTableRowStart(); $ro->coconutTableData("PROFESSIONAL FEE"); $ro->coconutTableData(number_format($ro->getTotal("phic", "PROFESSIONAL FEE", $registrationNo), 2)); $ro->coconutTableRowStop(); $ro->coconutTableRowStart(); $ro->coconutTableData("<b>TOTAL PHILHEALTH</b>"); $ro->coconutTableData("<font color=red><b>" . number_format($totalPHIC, 2) . "</b></font>"); $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);
<?php include "../../../myDatabase1.php"; $packageNo = $_GET['packageNo']; $countz = count($packageNo); $registrationNo = $_GET['registrationNo']; $username = $_GET['username']; $batchNo = $_GET['batchNo']; $unitcost = $_GET['unitcost']; $Added = $_GET['Added']; $ro = new database1(); $ro->getPatientProfile($registrationNo); for ($x = 0; $x < $countz; $x++) { $packageIncluded = preg_split("/\\_/", $ro->selectNow("hospitalPackage", "packageIncluded_description", "packageNo", $packageNo[$x])); $itemQTY = $ro->selectNow("hospitalPackage", "packageIncluded_qty", "packageNo", $packageNo[$x]); //addCharges_cash($status,$registrationNo,$chargesCode,$description,$sellingPrice,$discount,$total,$cashUnpaid,$phic,$company,$timeCharge,$dateCharge,$chargeBy,$service,$title,$paidVia,$cashPaid,$batchNo,$quantity,$inventoryFrom,$branch,$room) $sellingPrice; if ($packageIncluded[2] == "LABORATORY" || $packageIncluded[2] == "RADIOLOGY" || $packageIncluded[2] == "ECG" || $packageIncluded[2] == "OR/DR/ER Fee" || $packageIncluded[2] == "REHAB") { $services = "Examination"; $chargesPrice = $ro->selectNow("availableCharges", "PRIVATE", "chargesCode", $packageIncluded[1]); $ro->addCharges_cash("UNPAID", $registrationNo, $packageIncluded[1], $packageIncluded[0], $chargesPrice, "0.00", $chargesPrice, $chargesPrice, "0.00", "0.00", $ro->getSynapseTime(), date("Y-m-d"), $username, $services, $packageIncluded[2], "Cash", "0.00", $batchNo, $ro->selectNow("hospitalPackage", "packageIncluded_qty", "packageNo", $packageNo[$x]), $ro->selectNow("inventory", "inventoryLocation", "inventoryCode", $packageIncluded[1]), $ro->getRegistrationDetails_branch(), $ro->getRegistrationDetails_room()); } else { if ($packageIncluded[2] == "MEDICINE") { $services = "Medication"; $medPrice = preg_split("/\\_/", $ro->selectNow("hospitalPackage", "Added", "packageNo", $packageNo[$x])); //original //$ro->addCharges_cash("UNPAID",$registrationNo,$packageIncluded[1],$packageIncluded[0],$medPrice[1],"0.00",$medPrice[1],$medPrice[1],"0.00","0.00",$ro->getSynapseTime(),date("Y-m-d"),$username,$services,$packageIncluded[2],"Cash","0.00",$batchNo,$ro->selectNow("hospitalPackage","packageIncluded_qty","packageNo",$packageNo[$x]),"PHARMACY",$ro->getRegistrationDetails_branch(),$ro->getRegistrationDetails_room()); if ($ro->selectNow("inventory", "autoDispense", "inventoryCode", $packageIncluded[1]) == "yes") { //check autoDispense $currentQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $packageIncluded[1]); // current qty ng meds sa inventory
echo "<td>Address: <input type='text' value='" . $ro->getPatientRecord_address() . "' class='address'> </td>"; echo "</tr>"; echo "<tr>"; echo "<td>Date Admitted: <input type='text' value='" . $ro->getRegistrationDetails_dateRegistered() . "' class='dateAdmitted'> </td>"; echo "</tr>"; echo "<tr>"; echo "<td>Date Discharged: <input type='text' value='" . $ro->getRegistrationDetails_dateUnregistered() . "' class='dateDischarged'> </td>"; echo "</tr>"; $ro->clinicalCoverSheet_atteding($registrationNo); echo "<tr>"; echo "<td>Admitting Diagnosis: <input type='text' value='" . $ro->getRegistrationDetails_IxDx() . "' class='admittingDiagnosis'> </td>"; echo "</tr>"; echo "<tr>"; echo "<td><font color='white'>Admitting Diagnosis:</font> <input type='text' value='' class='admittingDiagnosis'> </td>"; echo "</tr>"; if ($ro->selectNow("patientICD", "diagnosis", "registrationNo", $registrationNo) != "") { echo "<tr>"; echo "<td><font>Final Diagnosis:</font> <input type='text' value='" . substr($ro->clinicalCoverSheet_finalDiagnosis($registrationNo), 0, 56) . "' class='finalDiagnosis'> </td>"; echo "</tr>"; if (strlen($ro->clinicalCoverSheet_finalDiagnosis($registrationNo)) > 56) { echo "<tr>"; echo "<td><font color='white'>Final Diagnosis:</font> <input type='text' value='" . substr($ro->clinicalCoverSheet_finalDiagnosis($registrationNo), 56, 56) . "' class='finalDiagnosis'> </td>"; echo "</tr>"; } else { echo "<tr>"; echo "<td><font color='white'>Final Diagnosis:</font> <input type='text' value='' class='finalDiagnosis'> </td>"; echo "</tr>"; } if (strlen($ro->clinicalCoverSheet_finalDiagnosis($registrationNo)) > 112) { echo "<tr>"; echo "<td><font color='white'>Final Diagnosis:</font> <input type='text' value='" . substr($ro->clinicalCoverSheet_finalDiagnosis($registrationNo), 112, 56) . "' class='finalDiagnosis'> </td>";
include "../../../myDatabase1.php"; $title = $_GET['title']; $templateNo = $_GET['templateNo']; $ro = new database1(); $ro->coconutDesign(); echo "<br>"; echo "<font size=4>TITLE: </font>"; $ro->coconutFormStart("post", "editResultForm1.php"); $ro->coconutTextBox("title", $title); $ro->coconutHidden("templateNo", $templateNo); ?> <script type="text/javascript" src="/ckeditor/ckeditor.js"></script> <?php echo "<textarea id='formTemplate' name='formTemplate'>" . $ro->selectNow("labResultList", "template", "templateNo", $templateNo) . "</textarea>"; $ro->coconutFormStop(); ?> <script type="text/javascript"> CKEDITOR.replace( 'formTemplate', { enterMode : CKEDITOR.ENTER_BR, skin : 'office2003', extraPlugins:'autogrow' }); </script>
echo "<br><font class='informationLabel'>Civil Status:</font> " . $ro->getPatientRecord_civilStatus(); echo "<br><font class='informationLabel'>Birth Date:</font> " . $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'>PhilHealth:</font> " . $ro->getPatientRecord_phic(); echo "<br><font class='informationLabel'>PhilHealth Type:</font> " . $ro->getPHICtype_patientRecord(); 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'>Package:</font> <a href='#' style='text-decoration:none; color:black;'>" . $ro->getRegistrationDetails_package() . "</a>"; 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("reportHeading", "information", "reportName", "Credit Limit") == "Activate" and $ro->selectNow("registrationDetails", "type", "registrationNo", $registrationNo) == "IPD") { echo "<br><font class='informationLabel' color=blue>Allowed Balance:</font> " . number_format($ro->selectNow("registrationDetails", "LimitCASH", "registrationNo", $registrationNo), 2); echo "<br><font class='informationLabel' color=red>Current Balance:</font> " . number_format($ro->may_naibayad_naba_ang_patient($registrationNo), 2); } else { } if ($ro->getRegistrationDetails_dateUnregistered() != "") { echo "<br><font class='informationLabel'>Time Discharged:</font> " . $ro->getRegistrationDetails_timeUnregistered(); echo "<br><font class='informationLabel'>Discharged:</font> " . $ro->getRegistrationDetails_dateUnregistered(); } else { echo ""; } echo "<br><br><font size=2 color=red><b>VITAL SIGN</b></font>"; echo "<br><font class='informationLabel'>Height:</font> " . $ro->getRegistrationDetails_height(); echo "<br><font class='informationLabel'>Weight:</font> " . $ro->getRegistrationDetails_weight(); echo "<br><font class='informationLabel'>Blood Pressure:</font> " . $ro->getRegistrationDetails_bloodPressure(); echo "<br><font class='informationLabel'>Temperature:</font> " . $ro->getRegistrationDetails_temperature();
<?php include "../../../myDatabase1.php"; $registrationNo = $_GET['registrationNo']; $itemNo = $_GET['itemNo']; $description = $_GET['description']; $branch = $_GET['branch']; $ro = new database1(); $ro->coconutDesign(); echo "<br><br><br>"; $ro->getPatientProfile($registrationNo); if ($ro->selectNow("radioSavedReport", "itemNo", "itemNo", $itemNo) != "") { echo "{$description} <font color=red> is For Approval of " . $ro->selectNow("radioSavedReport", "physician", "itemNo", $itemNo) . "</font>"; } else { //$ro->coconutFormStart("get","radioReport.php"); echo "<form method='get' action='radioReport.php' target='_blank'>"; $ro->coconutHidden("registrationNo", $registrationNo); $ro->coconutHidden("itemNo", $itemNo); $ro->coconutHidden("description", $description); echo "<center><font color=red>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</font>"; $ro->coconutBoxStart("500", "145"); echo "<br>"; echo "<table border=0>"; echo "<tr>"; echo "<td>Report</td>"; echo "<td>"; $ro->coconutComboBoxStart_long("report"); $ro->showOption_radio(); $ro->coconutComboBoxStop(); echo "</td>"; echo "</tr>";
<?php include "../../../myDatabase1.php"; $registrationNo = $_GET['registrationNo']; $ro = new database1(); echo "<br><Br><br>"; echo "<font color=blue><b>PhilHealth Package</b></font>: " . number_format($ro->selectNow("package", "price", "description", $ro->selectNow("registrationDetails", "package", "registrationNo", $registrationNo)), 2); echo "<Br>"; echo "<font color=green><b>Total PhilHealth Covered</b></font>: " . number_format($ro->getTotal_paidVia($registrationNo, "phic"), 2); $descrepancy = $ro->selectNow("package", "price", "description", $ro->selectNow("registrationDetails", "package", "registrationNo", $registrationNo)) - $ro->getTotal_paidVia($registrationNo, "phic"); echo "<br>"; echo "<font color=red><b>Descrepancy:</b></font> " . number_format($descrepancy, 2); echo "<br><br>"; $misc = $ro->getTotal("cashUnpaid", "MISCELLANEOUS", $registrationNo); $nsCharges = $ro->getTotal("cashUnpaid", "NURSING-CHARGES", $registrationNo); $medicine = $ro->getTotal("cashUnpaid", "MEDICINE", $registrationNo); $supplies = $ro->getTotal("cashUnpaid", "SUPPLIES", $registrationNo); if ($descrepancy > $misc) { echo "MISCELLANEOUS: " . number_format($ro->getTotal("cashUnpaid", "MISCELLANEOUS", $registrationNo), 2); } else { if ($descrepancy > $nsCharges) { echo "NURSING-CHARGES: " . number_format($ro->getTotal("cashUnpaid", "NURSING-CHARGES", $registrationNo), 2); } else { if ($descrepancy > $medicine) { echo "MEDICINE: " . number_format($ro->getTotal("cashUnpaid", "MEDICINE", $registrationNo), 2); } else { if ($descrepancy > $supplies) { echo "SUPPLIES: " . number_format($ro->getTotal("cashUnpaid", "SUPPLIES", $registrationNo), 2); } else { } }
$from = $_GET['from']; $ro = new database1(); /* $ro->getRegistrationNo(); $myFile = $ro->getReportInformation("homeRoot")."/COCONUT/trackingNo/registrationNo.dat"; $fh = fopen($myFile, 'r'); $registrationNo = fread($fh, 100); fclose($fh); $ro->getPatientID(); $myFile = $ro->getReportInformation("homeRoot")."/COCONUT/trackingNo/patientID.dat"; $fh = fopen($myFile, 'r'); $patientNo = fread($fh, 100); fclose($fh); */ $registrationNo = $ro->selectNow("trackingNo", "value", "name", "registrationNo"); $patientNo = $ro->selectNow("trackingNo", "value", "name", "patientNo"); $incrementRegistrationNo = $ro->selectNow("trackingNo", "value", "name", "registrationNo") + 1; $incrementPatientNo = $ro->selectNow("trackingNo", "value", "name", "patientNo") + 1; $ro->editNow("trackingNo", "name", "registrationNo", "value", $incrementRegistrationNo); $ro->editNow("trackingNo", "name", "patientNo", "value", $incrementPatientNo); $ro->coconutDesign(); ?> <link rel="stylesheet" type="text/css" href="http://<?php echo $ro->getMyUrl(); ?> /COCONUT/flow/rickyCSS1.css" /> <script type='text/javascript'> $("#breadcrumbs a").hover(
<?php include "../../../myDatabase1.php"; $username = $_GET['username']; $registrationNo = $_GET['registrationNo']; $ro = new database1(); echo "<script type='text/javascript' src='/ckeditor/ckeditor.js'></script>"; $ro->coconutDesign(); $startDate = preg_split("/\\_/", $ro->selectNow("promisorryNote", "startDate", "registrationNo", $registrationNo)); $dueDate = preg_split("/\\_/", $ro->selectNow("promisorryNote", "dueDate", "registrationNo", $registrationNo)); $ro->coconutFormStart("post", "editPromisorry1.php"); echo "<table border=0>"; echo "<tr>"; echo "<td>Date </tD>"; echo "<td>"; $ro->coconutComboBoxStart_short("month"); echo "<option value='" . $startDate[0] . "'>" . $startDate[0] . "</option>"; echo "<option value='Jan'>Jan</option>"; echo "<option value='Feb'>Feb</option>"; echo "<option value='Mar'>Mar</option>"; echo "<option value='Apr'>Apr</option>"; echo "<option value='May'>May</option>"; echo "<option value='Jun'>Jun</option>"; echo "<option value='Jul'>Jul</option>"; echo "<option value='Aug'>Aug</option>"; echo "<option value='Sep'>Sep</option>"; echo "<option value='Oct'>Oct</option>"; echo "<option value='Nov'>Nov</option>"; echo "<option value='Dec'>Dec</option>"; $ro->coconutComboBoxStop(); echo " ";
<?php include "../../myDatabase1.php"; $registrationNo = $_GET['registrationNo']; $username = $_GET['username']; $ro = new database1(); $ro->getBatchNo(); $myFile = $ro->getReportInformation("homeRoot") . "/COCONUT/trackingNo/batchNo.dat"; $fh = fopen($myFile, 'r'); $batchNo = fread($fh, 100); fclose($fh); echo "\r\n\r\n<style type='text/css'>\r\na \r\n{ \r\ntext-decoration:none;\r\ncolor:black;\r\nfont-weight:bold;\r\n }\r\nul { list-style-type:none; }\r\ndisplay: block;\r\n</style>\r\n\r\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><font size=2 color=red>" . $ro->getPatientRecord_lastName() . " " . $ro->getPatientRecord_firstName() . " " . $ro->getPatientRecord_middleName() . "</font><hr>"; } echo "<ul>"; echo "<li><a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientProfile_right.php?registrationNo=" . $ro->getRegistrationDetails_registrationNo() . "' 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 ""; }
<?php include "../../myDatabase1.php"; $registrationNo = $_GET['registrationNo']; $itemNo = $_GET['itemNo']; $username = $_GET['username']; $ro = new database1(); $ro->coconutDesign(); echo "\n<style type='text/css'>\n\n.txtArea {\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight: 380px;\n\twidth: 690px;\n\tpadding:4px 4px 4px 5px;\n\tfont-size:15px;\n}\n\n</style>\n"; echo "<br>"; echo "<b>" . $ro->selectNow("patientCharges", "description", "itemNo", $itemNo) . "</b>"; echo "<br><Br>"; echo "<b><b>"; $ro->coconutFormStart("get", "addMisc1.php"); $ro->coconutHidden("examName", $ro->selectNow("patientCharges", "description", "itemNo", $itemNo)); $ro->coconutHidden("registrationNo", $registrationNo); $ro->coconutHidden("itemNo", $itemNo); $ro->coconutHidden("username", $username); echo "<textarea name='examResult' class='txtArea'></textarea>"; echo "<br><br>"; $ro->coconutButton("Proceed"); $ro->coconutFormStop();