<?php
include "../../../myDatabase2.php";
$itemNo = $_POST['itemNo'];
$cash = $_POST['cash'];
$company = $_POST['company'];
$phic = $_POST['phic'];
$company1 = $_POST['company1'];
$ro = new database2();
$ro->editNow("patientCharges", "itemNo", $itemNo, "cashUnpaid", $cash);
$ro->editNow("patientCharges", "itemNo", $itemNo, "company", $company);
$ro->editNow("patientCharges", "itemNo", $itemNo, "phic", $phic);
$ro->editNow("patientCharges", "itemNo", $itemNo, "company1", $company1);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/additionalCompany/transfertoAdditionalCompany.php?registrationNo=" . $ro->selectNow("patientCharges", "registrationNo", "itemNo", $itemNo) . "&mode=");
?>
<?php
include "../../../myDatabase2.php";
$doctorCode = $_GET['doctorCode'];
$username = $_GET['username'];
$ro = new database2();
$ro->coconutDesign();
echo "<link rel='stylesheet' type='text/css' href='../css/default.css' />";
echo "\n<center>\n<header class='clearfix' style='margin:15px;'>\n<span>Synapse System</span>\n</header>\n";
echo "<div style='background:#47a3da; margin:10px; height:auto; width:150px; border-radius:15px;' >";
echo "<Br>";
echo "<table border='0' width='150px;'>";
echo "<tr>\n<th><font color='white' size=4>Name</font></th>\n</tr>";
$ro->androidViewPatient($doctorCode);
echo "</table>";
echo "</div>";
echo "<br>\n<a href='http://" . $ro->getMyUrl() . "/COCONUT/android/doctor/doctorInterface.php?username={$username}&doctorCode={$doctorCode}' style='text-decoration:none; color:#47a3da;' target='_parent'>Back To Menu</a>";
<?php
include "../../../myDatabase2.php";
$inventoryCode = $_GET['inventoryCode'];
$department = $_GET['department'];
$description = $_GET['description'];
$date = $_GET['date'];
$time = $_GET['time'];
$username = $_GET['username'];
$ro = new database2();
$ro->coconutDesign();
echo "<br><br><br><br><center><font size=2 color=red>{$description}</font></center>";
$ro->coconutFormStart("get", "http://" . $ro->getMyUrl() . "/COCONUT/inventory/department/inventoryLog.php");
$ro->coconutHidden("inventoryCode", $inventoryCode);
$ro->coconutHidden("department", $department);
$ro->coconutHidden("description", $description);
$ro->coconutHidden("date", $date);
$ro->coconutHidden("time", $time);
$ro->coconutHidden("username", $username);
$ro->coconutBoxStart("500", "85");
echo "<br>";
echo "<table border=0>";
echo "<Tr>";
echo "<td>QTY: </td>";
echo "<td>";
$ro->coconutTextBox_short("qty", "1");
echo "</td>";
echo "</tr>";
echo "</table>";
echo "<br>";
$ro->coconutButton("Proceed");
<?php
include "../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$itemNo = $_GET['itemNo'];
$description = $_GET['description'];
$quantity = $_GET['quantity'];
$username = $_GET['username'];
$show = $_GET['show'];
$desc = $_GET['desc'];
$ro = new database2();
/*
if( ($ro->getTitle($itemNo) == "MEDICINE" || $ro->getTitle($itemNo) == "SUPPLIES") && $ro->selectNow("registeredUser","module","username",$username) != "PHARMACY" ) {
echo "<br><Br><Br><font color=red>PHARMACY NA LANG MAG RERETURN.
<bR>
NAHIYA AKO SAYO EH BKA BUSY KA. =)</font>";
*/
//}else {
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/verifyDelete_redirect.php?registrationNo={$registrationNo}&itemNo={$itemNo}&description={$description}&quantity={$quantity}&username={$username}&show={$show}&desc={$desc}");
//}
<?php
include "../../myDatabase2.php";
$username = $_GET['username'];
$registrationNo = $_GET['registrationNo'];
$status = $_GET['status'];
$ro = new database2();
echo "\n<style type='text/css'>\n.head {\nfont-size:13px;\n}\n\n.find {\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight: 25px;\n\twidth: 370px;\n\tborder-color:black black black black;\n\tbackground:#FFFFFF url(http://" . $ro->getMyUrl() . "/COCONUT/myImages/search.jpeg) no-repeat 4px 4px;\n\tpadding:4px 4px 4px 22px;\n}\n\n\n.button {\n\tborder: 1px solid #000;\n\tcolor: #fff;\n\theight: 23px;\n\twidth: 70px;\n\tborder-color:black black black black;\n\ttext-align:center;\n\tbackground-color:#3b5998;\n}\n\n</style>\n\n";
echo "<script type='text/javascript'>\n\nvar charges = 'Find Charges';\nfunction SetMsg (txt,active) {\n if (txt == null) return;\n \n \n if (active) {\n if (txt.value == charges) txt.value = ''; \n } else {\n if (txt.value == '') txt.value = charges;\n }\n}\n\n</script>";
echo "<form method='get' action='patientCharges.php' >";
echo "<input type=text name='desc'\t\n\tonfocus='SetMsg(this, true);'\n \tonblur='SetMsg(this,false);' \n\tvalue='Find Charges'\n\tautocomplete='off'\t\n\tclass='find'> ";
echo "<input type=hidden name='show' value='search'>";
echo "<input type=hidden name='registrationNo' value='{$registrationNo}'>";
echo "<input type=hidden name='username' value='{$username}'>";
echo "<form>";
echo "<br><br> ";
echo "<table border=1 cellpadding=0 cellspacing=0 rules=all>";
echo "<tr>";
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'>Service</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 "<th bgcolor='#3b5998'> <font color=white class='head'>Balance</font> </th>";
$timeChargex = $ro->selectNow("patientCharges","timeCharge","itemNo",$itemNo);
$dateChargex = $ro->selectNow("patientCharges","dateCharge","itemNo",$itemNo);
$chargeByx = $ro->selectNow("patientCharges","chargeBy","itemNo",$itemNo);
$servicex = $ro->selectNow("patientCharges","service","itemNo",$itemNo);
$titlex = $ro->selectNow("patientCharges","title","itemNo",$itemNo);
$paidViax = $ro->selectNow("patientCharges","paidVia","itemNo",$itemNo);
$cashPaidx = $ro->selectNow("patientCharges","cashPaid","itemNo",$itemNo);
$batchNox = $ro->selectNow("patientCharges","batchNo","itemNo",$itemNo);
$inventoryFromx = $ro->selectNow("patientCharges","inventoryFrom","itemNo",$itemNo);
$branch="Consolacion";
$roomx = $ro->selectNow("patientCharges","room","itemNo",$itemNo);
$ro->addCharges_cash("Return",$regNo,$chargeCodez,$desc,$sp,$disc,$totz,$excess,$phicx,$companyx,$timeChargex,$dateChargex,$chargeByx,$servicex,$titlex,$paidViax,$cashPaidx,$batchNox,$quantity,$inventoryFromx,$branch,$roomx);
*/
//$ro->changeQTY($ro->getChargesCode($itemNo),($ro->getCurrentQTY($ro->getChargesCode($itemNo)) + $quantity) );
//$ro->deletePatientCharges($registrationNo,$itemNo);
}
} else {
if ($ro->getTitle($itemNo) == "MEDICINE" || $ro->getTitle($itemNo) == "SUPPLIES") {
$ro->editNow("patientCharges", "itemNo", $itemNo, "status", "DELETED_" . $username . "[" . date("Y-m-d") . "@" . $ro->getSynapseTime() . "]");
} else {
//$ro->deletePatientCharges($registrationNo,$itemNo);
$ro->editNow("patientCharges", "itemNo", $itemNo, "status", "DELETED_" . $username . "[" . date("Y-m-d") . "@" . $ro->getSynapseTime() . "]");
}
}
echo "\n<script type='text/javascript'>\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientChargesTitle.php?registrationNo={$registrationNo}&title={$titlez}&username={$username}&show={$show}&desc={$desc}';\n</script>\n";
}
?>
<?php
include "../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$package = $_GET['package'];
$ro = new database2();
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "prePackage", $package);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientProfile_handler.php?registrationNo={$registrationNo}&username={$username}");
<?php
include "../../../myDatabase2.php";
$registrationNo = $_POST['registrationNo'];
$username = $_POST['username'];
$company1 = $_POST['company1'];
$company2 = $_POST['company2'];
$ro = new database2();
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "company1", $company1);
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "company2", $company2);
echo "\n<script type='text/javascript'>\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientProfile_handler.php?registrationNo={$registrationNo}&username={$username}';\n</script>\n\n";
<?php
include "../../../myDatabase2.php";
$radioSavedNo = $_GET['radioSavedNo'];
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database2();
$ro->deleteNow("radioSavedReport", "radioSavedNo", $radioSavedNo);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Results/clinicalChemistry/view_labTest_done.php?registrationNo={$registrationNo}&username={$username}");
<?php
include "../../../myDatabase2.php";
$templateNo = $_POST['templateNo'];
$ro = new database2();
$ro->deleteNow("labResultList", "templateNo", $templateNo);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Laboratory/resultList/resultFormMasterfile.php");
<?php
include "../../../myDatabase2.php";
$registrationNo = $_POST['registrationNo'];
$username = $_POST['username'];
$companyName = $_POST['companyName'];
$columnToGet = $_POST['columnToGet'];
$ro = new database2();
$ro->getPatientProfile($registrationNo);
$ro->coconutDesign();
$ro->coconutFormStart("post", "http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/Payments/companyPayment1.php");
$ro->coconutHidden("registrationNo", $registrationNo);
$ro->coconutHidden("postBy", $username);
$ro->coconutHidden("itemNo", "");
$ro->coconutHidden("doctor", "");
$ro->coconutHidden("companyName", $companyName);
$ro->coconutHidden("columnToGet", $columnToGet);
echo "<Br><br><br>";
$ro->coconutBoxStart("500", "320");
echo "<br>";
echo "<table>";
echo "<tr>";
echo "<td>Ref#</td>";
echo "<td>";
$ro->coconutTextBox("refNo", "");
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td>Check#</td>";
echo "<td>";
$ro->coconutTextBox("checkNo", "");
<?php
include "../../../myDatabase2.php";
$refNo = $_POST['refNo'];
$registrationNo = $_POST['registrationNo'];
$amount = $_POST['amount'];
$tax = $_POST['tax'];
$month = $_POST['month'];
$day = $_POST['day'];
$year = $_POST['year'];
$postBy = $_POST['postBy'];
$ro = new database2();
$date = $year . "-" . $month . "-" . $day;
$ro->addPHICPayment($refNo, $registrationNo, $amount, $tax, $date, $postBy);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientProfile_right.php?registrationNo={$registrationNo}&username={$postBy}");
<?php
include "../../myDatabase2.php";
$packageNo = $_GET['packageNo'];
$packageName = $_GET['packageName'];
$price = $_GET['price'];
$ro = new database2();
$ro->editNow("hospitalPackage", "packageNo", $packageNo, "Added", $price);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/hospitalPackage/showAddedPackage_update.php?packageName={$packageName}");
$ro = new database2();
$ro->coconutDesign();
echo "<Br><Br><br>";
$caseRate_amount = $ro->selectNow("rBanny_caserate", "amount", "caseNo", $caserate);
//amount ng selected caserate
$hospitalBill = $ro->getTotal("total", "Room And Board", $registrationNo) + $ro->getTotal("total", "MEDICINE", $registrationNo) + $ro->getTotal("total", "SUPPLIES", $registrationNo) + $ro->getTotal("total", "LABORATORY", $registrationNo) + $ro->getTotal("total", "RADIOLOGY", $registrationNo) + $ro->getTotal("total", "NURSING-CHARGES", $registrationNo) + $ro->getTotal("total", "MISCELLANEOUS", $registrationNo) + $ro->getTotal("total", "OR/DR/ER Fee", $registrationNo) + $ro->getTotal("total", "OXYGEN", $registrationNo);
$pf = $ro->getTotal("phic", "PROFESSIONAL FEE", $registrationNo);
$targetAmount = $caseRate_amount - $caseRate_amount * 0.3;
echo "<Center>";
echo "<font color='blue' size=5><i>[R-Banny]-[noReset mode]</i></font>";
$ro->coconutBoxStart("500", "130");
echo "<br><font color=red size=4>Caserate</font>: " . $ro->selectNow("rBanny_caserate", "caserate", "caseNo", $caserate) . " [" . number_format($caseRate_amount, 2) . "]";
echo "<br>";
echo "<font color=red size=4>Hospital Bill: </font>" . number_format($hospitalBill, 2);
echo "<Br>";
echo "<font color=red size=4>Professional Fee: </font>" . number_format($pf, 2);
echo "<Br>";
$ro->coconutFormStart("get", "http://" . $ro->getMyUrl() . "/COCONUT/rBanny/analyzingData_noReset.php");
//$cazeRate = $ro->selectNow("availableICD","hospital","icdCode",$ro->selectNow("patientICD","icdCode","registrationNo",$registrationNo));
echo "<i><font color=blue size=4>Target Amount: </font></i><br>" . $ro->coconutTextBox_return("targetAmount", $ro->getFirstCaseRate($ro->selectNow("patientICD", "icdCode", "registrationNo", $registrationNo)));
echo "<br><Br>";
//$ro->coconutHidden("targetAmount",$targetAmount);
$ro->coconutHidden("cash", $ro->getTotal("cashUnpaid", "", $registrationNo));
$ro->coconutHidden("registrationNo", $registrationNo);
if ($hospitalBill > $targetAmount) {
$ro->coconutButton("Proceed");
} else {
//echo "<Br><font size=4 color=red>R-Banny Cannot analyze you're data because Target Amount is Higher [".number_format($targetAmount,2)."] than the Patient's Bill [".number_format($hospitalBill,2)."] </font>";
}
$ro->coconutFormStop();
$ro->coconutBoxStop();
echo "</tr>";
echo "<Tr>";
echo "<td> <font color='white' size=4>Temp:</font> </td>";
if ($ro->selectNow("registrationDetails", "temperature", "registrationNo", $registrationNo) != "TEMPERATURE") {
echo "<td><font color='white' size=4><i>" . $ro->selectNow("registrationDetails", "temperature", "registrationNo", $registrationNo) . "</i></font></td>";
} else {
echo "<td></td>";
}
echo "</tr>";
echo "</table>";
echo " <font color='white' size=4>Complaints</font>";
echo "<center><div style='background-color:white; width:480px; height:80px; text-align:left; border-radius:5px; font-size:15px;' scrolling='yes'>" . $ro->selectNow("registrationDetails", "initialDiagnosis", "registrationNo", $registrationNo) . "</div>";
echo "</div>";
echo "<br><br>";
echo "<div style='float:left; width:100%; '>";
$ro->coconutFormStart("post", "http://" . $ro->getMyUrl() . "/COCONUT/android/doctor/mobileSOAP.php");
$ro->coconutHidden("registrationNo", $registrationNo);
$ro->coconutHidden("itemNo", $itemNo);
echo "<button style='border: none;\n\tbackground: #47a3da;\n\tcolor: #fff;\n\tpadding: 1.5em;\n\tdisplay: block;\n\twidth: 20%;\n\tcursor: pointer;\n\tmargin: -20px 0;\n\tfont-size: 0.9em;'>S.O.A.P & Add Charges</button>";
$ro->coconutFormStop();
echo "</div>";
echo "<div style='float:right; position:absolute; margin: 0 0 0 240px; width:100%;'>";
$ro->coconutFormStart("get", "http://" . $ro->getMyUrl() . "/COCONUT/android/doctor/viewHospitalCharges.php");
$ro->coconutHidden("registrationNo", $registrationNo);
echo "<button style='border: none;\n\tbackground: #47a3da;\n\tcolor: #fff;\n\tpadding: 1.5em;\n\tdisplay: block;\n\twidth: 20%;\n\tcursor: pointer;\n\tmargin: -20px 0;\n\tfont-size: 0.9em;'>View Hospital Charges</button>";
$ro->coconutFormStop();
echo "</div>";
echo "<br><br><br><br><br>";
echo "<div style='float:left; height:20%; width:100%; '>";
$ro->coconutFormStart("get", "http://" . $ro->getMyUrl() . "/COCONUT/android/doctor/planPreview_handler.php");
$ro->coconutHidden("registrationNo", $registrationNo);
<?php
include "../../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$itemNo = $_GET['itemNo'];
$countz = count($itemNo);
$ro = new database2();
$ro->coconutDesign();
$total = 0;
$discount = 0;
echo "<center>";
$ro->coconutFormStart("get", "http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/individualPayment/paidItems.php");
$ro->coconutHidden("registrationNo", $registrationNo);
$ro->coconutHidden("username", $username);
$ro->coconutTableStart();
$ro->coconutTableRowStart();
$ro->coconutTableHeader("");
$ro->coconutTableHeader("Description");
$ro->coconutTableHeader("QTY;");
$ro->coconutTableHeader("Price");
$ro->coconutTableHeader("Discount");
$ro->coconutTableHeader("Total");
$ro->coconutTableRowStop();
for ($x = 0; $x < $countz; $x++) {
$ro->coconutTableRowStart();
$ro->coconutTableData("<input type='checkbox' name='itemNo[]' value='" . $itemNo[$x] . "' checked>");
$ro->coconutTableData($ro->doubleSelectNow("patientCharges", "description", "itemNo", $itemNo[$x], "registrationNo", $registrationNo));
$ro->coconutTableData($ro->doubleSelectNow("patientCharges", "quantity", "itemNo", $itemNo[$x], "registrationNo", $registrationNo));
$ro->coconutTableData($ro->doubleSelectNow("patientCharges", "sellingPrice", "itemNo", $itemNo[$x], "registrationNo", $registrationNo));
$ro->coconutTableData($ro->doubleSelectNow("patientCharges", "discount", "itemNo", $itemNo[$x], "registrationNo", $registrationNo));
<?php
include "../../../myDatabase2.php";
$collectionNo = $_GET['collectionNo'];
$month = $_GET['month'];
$day = $_GET['day'];
$year = $_GET['year'];
$ro = new database2();
$ro->deleteNow("cashCollection", "collectionNo", $collectionNo);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Cashier/cashCollection/cashCollectionDetails.php?month={$month}&day={$day}&year={$year}");
$itemNo = $_GET['itemNo'];
$dateIn = $_GET['dateIn'];
$month = $_GET['month'];
$day = $_GET['day'];
$year = $_GET['year'];
$username = $_GET['username'];
$ro = new database2();
$dateOut = $year . "-" . $month . "-" . $day;
$out = new DateTime($dateOut);
$in = new DateTime($dateIn);
$days = $out->diff($in)->d;
if ($ro->selectNow("patientCharges", "phic", "itemNo", $itemNo) < 1) {
$ro->editNow("patientCharges", "itemNo", $itemNo, "quantity", $days);
$ro->editNow("patientCharges", "itemNo", $itemNo, "total", $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $itemNo) * $days);
$ro->editNow("patientCharges", "itemNo", $itemNo, "cashUnpaid", $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $itemNo) * $days);
$ro->editNow("patientCharges", "itemNo", $itemNo, "phic", "0");
$ro->editNow("patientCharges", "itemNo", $itemNo, "company", "0");
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientChargesTitle.php?registrationNo={$registrationNo}&title=Room and Board&username={$username}&show=&desc=");
} else {
$cashUnpaid = $ro->selectNow("patientCharges", "cashUnpaid", "itemNo", $itemNo);
$hmo = $ro->selectNow("patientCharges", "company", "itemNo", $itemNo);
$philhealth = $ro->selectNow("patientCharges", "phic", "itemNo", $itemNo);
$newTotal = $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $itemNo) * $days;
$ro->editNow("patientCharges", "itemNo", $itemNo, "quantity", $days);
$ro->editNow("patientCharges", "itemNo", $itemNo, "total", $newTotal);
$ro->editNow("patientCharges", "itemNo", $itemNo, "cashUnpaid", $newTotal - $philhealth);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientChargesTitle.php?registrationNo={$registrationNo}&title=Room and Board&username={$username}&show=&desc=");
}
?>
t
<script type="text/javascript">
function printF(printData)
{
var a = window.open ('', '',"status=1,scrollbars=1, width=auto,height=auto");
a.document.write(document.getElementById(printData).innerHTML.replace(/<a\/?[^>]+>/gi, ''));
a.document.close();
a.focus();
a.print();
a.close();
}
</script>
<a href="#" onClick="printF('printData')" style="text-decoration:none; color:black;">PRINT</a>
<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>";
<?php
include "../../../myDatabase2.php";
$username = $_POST['username'];
$password = $_POST['password'];
$ro = new database2();
$ro->coconutDesign();
$user = $ro->selectNow("registeredUser", "username", "password", $password);
if ($username == "" && $password == "") {
$ro->getBack("Authentication Error");
} else {
if ($username == $user) {
//header("Location: /COCONUT/requestition/batchRequest/getRequestNo.php?username=$username");
echo "<Br><Br><BR><Br>";
$ro->coconutBoxStart("500", "100");
echo "<Br>";
echo "<table border=0>";
echo "<Tr>";
echo "<Td><a style='text-decoration:none;' href='http://" . $ro->getMyUrl() . "/COCONUT/requestition/batchRequest/getRequestNo.php?username={$username}'><font color=blue>Request</font></a></tD>";
echo "<td> </td>";
echo "<Td><a style='text-decoration:none;' href='http://" . $ro->getMyUrl() . "/COCONUT/requestition/consumedInventory.php?username={$username}'><font color=red>Consume</font></a></tD>";
echo "</tr>";
echo "</table>";
$ro->coconutBoxStop();
} else {
echo "<script type='text/javascript'>\nalert('Incorrect Password');\nhistory.back();\n</script>";
}
}
<?php
include "../../../myDatabase2.php";
$registrationNo = $_POST['registrationNo'];
$itemNo = $_POST['itemNo'];
$subjective = $_POST['subjective'];
$objective = $_POST['objectives'];
$assessment = $_POST['assessment'];
$ro = new database2();
$ro->getBatchNo();
$myFile = $ro->getReportInformation("homeRoot") . "/COCONUT/trackingNo/batchNo.dat";
$fh = fopen($myFile, 'r');
$batchNo = fread($fh, 100);
fclose($fh);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/android/doctor/mobileAddCharges.php?batchNo={$batchNo}®istrationNo={$registrationNo}&itemNo={$itemNo}&subjective={$subjective}&objective={$objective}&assessment={$assessment}&username=ricky");
<?php
include "../../myDatabase2.php";
$returnNo = $_GET['returnNo'];
$inventoryCode = $_GET['inventoryCode'];
$returnFrom = $_GET['returnFrom'];
$returnTo = $_GET['returnTo'];
$username = $_GET['username'];
$qtyReturn = $_GET['qtyReturn'];
$ro = new database2();
echo "<br><br><br><br><br><br>";
$ro->coconutFormStart("get", "http://" . $ro->getMyUrl() . "/COCONUT/inventory/receiveDepartmentReturn1.php");
$ro->coconutHidden("returnTo", $returnTo);
$ro->coconutHidden("username", $username);
$ro->coconutHidden("returnNo", $returnNo);
$ro->coconutHidden("inventoryCode", $inventoryCode);
$ro->coconutHidden("qtyReturn", $qtyReturn);
$ro->coconutBoxStart_red("500", "70");
echo "<br>";
echo "Received Return of {$qtyReturn} pcs <b>" . $ro->selectNow("inventory", "description", "inventoryCode", $inventoryCode) . "</b> of <b>{$returnFrom}</b>?";
echo "<br><br>";
$ro->coconutButton("Proceed");
$ro->coconutBoxStop();
$ro->coconutFormStop();
$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'];
$module = $_GET['module'];
$username = $_GET['username'];
$branch = $_GET['branch'];
$myDate = $year . "-" . $month . "-" . $day;
$ro = new database2();
echo "<html>";
echo "<head>";
echo "<script src='http://" . $ro->getMyUrl() . "/jquery.js'></script>";
echo "<script>";
?>
function playBuzzer(){
$("body").append("<embed src='doorbell.wav' autostart='true' loop='false' width='2' height='0'></embed>");
}
var aSound = document.createElement('audio');
aSound.setAttribute('src', 'doorbell.wav');
<?php
if ($module == "PHARMACY") {
$tag = "MEDICINE";
} else {
if ($module == "LABORATORY") {
$tag = "LABORATORY";
<?php
include "../../myDatabase2.php";
$ro = new database2();
$ro->coconutDesign();
echo "<Br><br><br><br>";
$ro->coconutFormStart("get", "http://" . $ro->getMyUrl() . "/COCONUT/Doctor/doctorModule/ipdPatient_dept.php");
$ro->coconutBoxStart("500", "80");
echo "<br>";
$ro->coconutComboBoxStart_long("doctor");
$ro->showOption("Doctors", "Name");
$ro->coconutComboBoxStop();
echo "<Br><br>";
$ro->coconutButton("Proceed");
$ro->coconutBoxStop();
$ro->coconutFormStop();
<?php
include "../../../myDatabase2.php";
$stockCardNo = $_GET['stockCardNo'];
$description = $_GET['description'];
$movementNo = $_GET['movementNo'];
$ro = new database2();
$ro->coconutDesign();
echo "<br>";
echo "<center><b><i>" . $description . "</i></b></center>";
$ro->coconutBoxStart("400", "400");
echo "<Br>";
echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/Reports/inventoryReport/inventoryMovementOption1.php?menu=beginningBalance&stockCardNo={$stockCardNo}' style='text-decoration:none; color:red;'>Beginning Balance</a>";
echo "<br><Br>";
if ($movementNo != "") {
echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/Reports/inventoryReport/inventoryMovementOption1.php?menu=firstThreePurchases&stockCardNo={$stockCardNo}&movementNo={$movementNo}' style='text-decoration:none; color:red;'>3 months Purchases Jan/Feb/Mar</a>";
echo "<hr>";
echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/Reports/inventoryReport/inventoryMovementOption1.php?menu=secondThreePurchases&stockCardNo={$stockCardNo}&movementNo={$movementNo}' style='text-decoration:none; color:blue;'>3 months Purchases Apr/May/Jun</a>";
echo "<hr>";
echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/Reports/inventoryReport/inventoryMovementOption1.php?menu=thirdThreePurchases&stockCardNo={$stockCardNo}&movementNo={$movementNo}' style='text-decoration:none; color:red;'>3 months Purchases Jul/Aug/Sep</a>";
echo "<hr>";
echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/Reports/inventoryReport/inventoryMovementOption1.php?menu=fourthThreePurchases&stockCardNo={$stockCardNo}&movementNo={$movementNo}' style='text-decoration:none; color:blue;'>3 months Purchases Oct/Nov/Dec</a>";
echo "<hr>";
echo "<br><br><br>";
echo "<hr>";
echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/Reports/inventoryReport/inventoryMovementOption1.php?menu=medicineType&stockCardNo={$stockCardNo}&movementNo={$movementNo}' style='text-decoration:none; color:red;'>Medicine Type</a>";
echo "<hr>";
echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/inventory/addInventory.php?username=xx&status=old&stockCardNo={$stockCardNo}&description={$description}&genericName=" . $ro->selectNow("inventoryStockCard", "genericName", "stockCardNo", $stockCardNo) . "' style='text-decoration:none; color:blue;'>Add New Quantity</a>";
echo "<hr>";
} else {
echo "<a href='#' style='text-decoration:none; color:gray;'>3 months Purchases Jan/Feb/Mar</a>";
<?php
include "../../../myDatabase2.php";
$ro = new database2();
$ro->coconutDesign();
echo "<br><br><br><Br>";
$ro->coconutFormStart("get", "http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/promisorryNote/promisorryNoteReport1.php");
$ro->coconutBoxStart("500", "120");
echo "<Br>";
echo "<table border=0>";
echo "<Tr>";
echo "<td>From</td>";
echo "<Td>";
$ro->coconutComboBoxStart_short("month");
echo "<option value='01'>Jan</option>";
echo "<option value='02'>Feb</option>";
echo "<option value='03'>Mar</option>";
echo "<option value='04'>Apr</option>";
echo "<option value='05'>May</option>";
echo "<option value='06'>Jun</option>";
echo "<option value='07'>Jul</option>";
echo "<option value='08'>Aug</option>";
echo "<option value='09'>Sep</option>";
echo "<option value='10'>Oct</option>";
echo "<option value='11'>Nov</option>";
echo "<option value='12'>Dec</option>";
$ro->coconutComboBoxStop();
echo "-";
$ro->coconutComboBoxStart_short("day");
for ($x = 1; $x < 32; $x++) {
if ($x < 10) {
$pulse = $_GET['pulse'];
$respiratory = $_GET['respiratory'];
$from = $_GET['from'];
$infectionControl = $_GET['infectionControl'];
$service = $_GET['service'];
$serviceOthers = $_GET['serviceOthers'];
if ($service == 'Others') {
$newservice = "Others-" . $serviceOthers;
} else {
$newservice = $service;
}
$ro = new database2();
?>
<link rel="stylesheet" type="text/css" href="http://<?php
echo $ro->getMyUrl();
?>
/COCONUT/flow/rickyCSS1.css" />
<script type='text/javascript'>
$("#breadcrumbs a").hover(
function () {
$(this).addClass("hover").children().addClass("hover");
$(this).parent().prev().find("span.arrow:first").addClass("pre_hover");
},
function () {
$(this).removeClass("hover").children().removeClass("hover");
$(this).parent().prev().find("span.arrow:first").removeClass("pre_hover");
}
);
</script>
<?php
include "../../myDatabase2.php";
$ro = new database2();
$ro->coconutDesign();
echo "<br><br><br><br>";
$ro->coconutFormStart("get", "http://" . $ro->getMyUrl() . "/COCONUT/Company/companyPaymentReport1.php");
$ro->coconutBoxStart("500", "120");
echo "<Br>";
echo "<table border=0>";
echo "<Tr>";
echo "<td><font size=2>Source of Date</font></td>";
echo "<td>";
$ro->coconutComboBoxStart_long("dateSource");
echo "<option value='dateEncoded'>Date Encoded</option>";
echo "<option value='datePaid'>Date Paid</option>";
$ro->coconutComboBoxStop();
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td>From Date</td>";
echo "<td>";
$ro->coconutComboBoxStart_short("month");
echo "<option value='01'>Jan</option>";
echo "<option value='02'>Feb</option>";
echo "<option value='03'>Mar</option>";
echo "<option value='04'>Apr</option>";
echo "<option value='05'>May</option>";
echo "<option value='06'>Jun</option>";
echo "<option value='07'>Jul</option>";
echo "<option value='08'>Aug</option>";
<?php
include "../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$targetAmount = $_GET['targetAmount'];
$ro = new database2();
$itemz = preg_split("/\\_/", $ro->getMaximumTotal_rBanny($registrationNo, "Room and Board"));
$ro->getPatientChargesToEdit($itemz[1]);
if ($ro->getTotal("cashUnpaid", "Room And Board", $registrationNo) > 0) {
echo "<br><Br><br><br><br>";
echo "<font color=red>R-Banny is now Calculating Room</font><br>";
echo "Total: " . $itemz[0];
echo "<br>";
echo "Item#: " . $itemz[1];
if ($targetAmount >= $itemz[0]) {
$ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", "0");
$ro->editNow("patientCharges", "itemNo", $itemz[1], "Company", "0");
$ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $itemz[0]);
} else {
//echo "<br><Br><br><br><font color=blue size=5>R-Banny is Having a trouble in Computation</font>";
$newCash = $itemz[0] - $targetAmount;
$newPHIC = $ro->selectNow("patientCharges", "total", "itemNo", $itemz[1]) - $newCash;
$ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", $newCash);
$ro->editNow("patientCharges", "itemNo", $itemz[1], "Company", "0");
$ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $newPHIC);
}
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/rBanny/consumedRoom.php?registrationNo={$registrationNo}&targetAmount={$targetAmount}");
} else {
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/rBanny/consumedMeds.php?registrationNo={$registrationNo}&targetAmount={$targetAmount}");
}
<?php
include "../../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$phicPaymentNo = $_GET['phicPaymentNo'];
$username = $_GET['username'];
$ro = new database2();
$ro->editNow("phicPayment", "phicPaymentNo", $phicPaymentNo, "status", "DELETED_" . $username . "_" . date("Y-m-d"));
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/Payments/viewPHICPayment.php?registrationNo={$registrationNo}&username={$username}");
