<?php include "../../myDatabase2.php"; $registrationNo = $_POST['registrationNo']; $excessPF = $_POST['excessPF']; $excessRoom = $_POST['excessRoom']; $excessMaxBenefits = $_POST['excessMaxBenefits']; $PHICportion = $_POST['PHICportion']; $manual = $_POST['manual']; $manualValue = $_POST['manualValue']; $ro = new database2(); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "excessPF", $excessPF); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "excessRoom", $excessRoom); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "excessMaxBenefits", $excessMaxBenefits); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "PHICportion", $PHICportion); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "hmoManualExcess", $manual); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "hmoManualExcessValue", $manualValue);
$quantity = $_GET['quantity']; $username = $_GET['username']; $show = $_GET['show']; $desc = $_GET['desc']; $ro = new database2(); $titlez = $ro->getTitle($itemNo); if ($ro->doubleSelectNow("patientCharges", "quantity", "itemNo", $itemNo, "registrationNo", $registrationNo) < $quantity) { echo "<br><br><br><font color=red>Ooopsss.. you are trying to return {$quantity} but there is only " . $ro->doubleSelectNow("patientCharges", "quantity", "itemNo", $itemNo, "registrationNo", $registrationNo) . " Dispensed to the patient</font>"; } else { if (($ro->getTitle($itemNo) == "MEDICINE" || $ro->getTitle($itemNo) == "SUPPLIES") && $ro->getChargesStatusDept($itemNo)) { if ($ro->selectNow("inventory", "autoDispense", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)) == "yes") { $currentQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)); // current qty ng meds/sup sa inventory $newQTY = $currentQTY + $quantity; //dagdag inventory once return $ro->editNow("inventory", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo), "quantity", $newQTY); // update qty sa database $ro->deletePatientCharges($registrationNo, $itemNo); } else { $ro->editNow("patientCharges", "itemNo", $itemNo, "status", "Return"); $ro->editNow("patientCharges", "itemNo", $itemNo, "dateReturn", date("Y-m-d")); $ro->editNow("patientCharges", "itemNo", $itemNo, "departmentStatus", $quantity . "_" . $registrationNo); $ro->returnInventory($itemNo, $registrationNo, $ro->selectNow("patientCharges", "description", "itemNo", $itemNo), $quantity, date("Y-m-d") . "@" . $ro->getSynapseTime(), $username); /* $regNo = $ro->selectNow("patientCharges","registrationNo","itemNo",$itemNo); $chargeCodez = $ro->selectNow("patientCharges","chargesCode","itemNo",$itemNo); $desc = $ro->selectNow("patientCharges","description","itemNo",$itemNo); $sp = $ro->selectNow("patientCharges","sellingPrice","itemNo",$itemNo); $disc = $ro->selectNow("patientCharges","discount","itemNo",$itemNo); $totz = ($ro->selectNow("patientCharges","sellingPrice","itemNo",$itemNo) * $quantity); $excess = $ro->selectNow("patientCharges","cashUnpaid","itemNo",$itemNo);
var aSound = document.createElement('audio'); aSound.setAttribute('src', 'doorbell.wav'); <?php if ($module == "PHARMACY") { $tag = "MEDICINE"; } else { if ($module == "LABORATORY") { $tag = "LABORATORY"; } else { $tag = "CSR"; } } if ($ro->selectNow("requestCount", "currentTotal", "department", $tag) != $ro->countDeptRequest($tag, $myDate)) { $ro->editNow("requestCount", "department", $tag, "currentTotal", $ro->countDeptRequest($tag, $myDate)); ?> aSound.play(); <?php } else { } ?> <?php echo "</script>"; echo "</head>"; echo "<body>"; echo "<font size=1>BRANCH:</font> <font size=2 color=red>{$branch}</font> "; echo "<br><font size=1>DATE:</font> <font size=1>{$month} {$day}, {$year}</font>"; echo "<br><font size=1>{$fromTime_hour}:{$fromTime_minutes}:{$fromTime_seconds} - </font><font size=1>{$toTime_hour}:{$toTime_minutes}:{$toTime_seconds}</font>"; if ($module != "CSR") {
<?php include "../../myDatabase2.php"; $itemNo = $_GET['itemNo']; $hmoPrice = $_GET['hmoPrice']; $company = $_GET['company']; $ro = new database2(); $ro->editNow("patientCharges", "itemNo", $itemNo, "hmoPrice", $hmoPrice); $ro->editNow("patientCharges", "itemNo", $itemNo, "company", $company);
<?php include "../../myDatabase2.php"; $verificationNo = $_GET['verificationNo']; $countVerification = count($verificationNo); $username = $_GET['username']; $ro = new database2(); for ($x = 0; $x < $countVerification; $x++) { $identifier = preg_split("/\\_/", $verificationNo[$x]); // $identifier[0]=verificationNo, identifier[1]=inventoryCode //echo $verificationNo[$x];//verificationNo na galing sa inventoryManager table [serve as unique identifier] if ($ro->selectNow("inventory", "quantity", "inventoryCode", $identifier[1]) >= $ro->selectNow("inventoryManager", "quantity", "verificationNo", $identifier[0])) { //double check kung mas mataas p ung in stock qty $newQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $identifier[1]) - $ro->selectNow("inventoryManager", "quantity", "verificationNo", $identifier[0]); $ro->editNow("inventory", "inventoryCode", $identifier[1], "quantity", $newQTY); $generic = ""; $pricing = $ro->selectNow("inventory", "unitcost", "inventoryCode", $identifier[1]); $expiration = ""; //addNewMedicine($description,$generic,$unitcost,$quantity,$expiration,$addedBy,$dateAdded,$timeAdded,$inventoryLocation,$inventoryType,$branch,$transition,$remarks,$preparation,$phic,$added,$criticalLevel,$supplier,$begCapital,$begQTY,$suppliesUNITCOST) $ro->addNewMedicine($ro->selectNow("inventoryManager", "description", "verificationNo", $identifier[0]), $generic, $pricing, $ro->selectNow("inventoryManager", "quantity", "verificationNo", $identifier[0]), $expiration, $ro->selectNow("inventoryManager", "requestingUser", "verificationNo", $identifier[0]), date("Y-m-d"), $ro->getSynapseTime(), $ro->selectNow("inventoryManager", "requestingDepartment", "verificationNo", $identifier[0]), $ro->selectNow("inventory", "inventoryType", "inventoryCode", $identifier[1]), "Consolacion", "requestition", "from inventoryCode:" . $identifier[1] . " issued by:" . $username, "", "", "", "", "", "", $ro->selectNow("inventoryManager", "quantity", "verificationNo", $identifier[0]), $ro->selectNow("inventory", "suppliesUNITCOST", "inventoryCode", $identifier[1]), "yes"); //insert to inventory table $ro->editNow("inventoryManager", "verificationNo", $identifier[0], "status", "dispensed"); $ro->editNow("inventoryManager", "verificationNo", $identifier[0], "dispensedDate", date("Y-m-d")); } else { echo "<font color=red>Sorry... " . $ro->selectNow("inventoryManager", "description", "verificationNo", $identifier[0]) . " Cannot be dispensed because there's only " . $ro->selectNow("inventory", "quantity", "inventoryCode", $identifier[1]) . " in stock</font> "; } }
<?php include "../../../myDatabase2.php"; $username = $_GET['username']; //$month = $_GET['month']; //$day = $_GET['day']; //$year = $_GET['year']; //$date = $_GET['date']; $chargeNo = $_GET['chargeNo']; $startHour = $_GET['startHour']; $startMinute = $_GET['startMinute']; $startSeconds = $_GET['startSeconds']; $stopHour = $_GET['stopHour']; $stopMinute = $_GET['stopMinute']; $stopSeconds = $_GET['stopSeconds']; $status = $_GET['status']; $hours = $_GET['hours']; $ro = new database2(); $newTimeStart = $startHour . ":" . $startMinute . ":" . $startSeconds; $newTimeStop = $stopHour . ":" . $stopMinute . ":" . $stopSeconds; $ro->editNow("generatorCharge", "chargeNo", $chargeNo, "timeStart", $newTimeStart); $ro->editNow("generatorCharge", "chargeNo", $chargeNo, "timeStop", $newTimeStop); $ro->editNow("generatorCharge", "chargeNo", $chargeNo, "status", $status); $ro->editNow("generatorCharge", "chargeNo", $chargeNo, "hours", $hours);
<?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";
} if (isset($_GET['instruction1'])) { $instruction1 = $_GET['instruction1']; } else { $instruction1 = ""; } if (isset($_GET['indication1'])) { $indication1 = $_GET['indication1']; } else { $indication1 = ""; } $ro = new database2(); $ro->getPatientProfile($registrationNo); $currentTotal = $quantity * $sellingPrice; $grandTotal = $currentTotal; if ($decision == "yes") { $dateCharge = date("Y-m-d"); $ro->addCharges_cash_mobile($status, $registrationNo, $chargesCode, $description, $sellingPrice, "0", $grandTotal, $grandTotal, 0, 0, $timeCharge, $dateCharge, $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room); if ($title == "MEDICINE") { $ro->addNewPlan($registrationNo, $description, $timing1, $instruction1, $indication1, $quantity); } else { } } else { if ($title != "MEDICINE") { $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "advised", $ro->selectNow("registrationDetails", "advised", "registrationNo", $registrationNo) . "," . $description); $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/android/doctor/mobileAddCharges_charges.php?registrationNo={$registrationNo}&username={$username}&room={$room}&batchNo={$batchNo}"); } else { $ro->addNewPlan_fromCharging($registrationNo, $description, $timing1, $instruction1, $indication1, $quantity, $batchNo, $room, $username); $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/android/doctor/mobileAddCharges_medicine.php?registrationNo={$registrationNo}&username={$username}&room={$room}&batchNo={$batchNo}"); } }
$expiration = $ro->selectNow("inventory", "expiration", "inventoryCode", $inventoryCode[$i]); $serverTime = $ro->getSynapseTime(); $inventoryLocation = $ro->selectNow("inventoryManager", "requestingDepartment", "verificationNo", $verificationNo[$i]); $branch = "Consolacion"; $inventoryType = $ro->selectNow("inventory", "inventoryType", "inventoryCode", $inventoryCode[$i]); $transition = " Issued By " . $ro->selectNow("inventoryManager", "requestTo_department", "verificationNo", $verificationNo[$v]) . " / Issued Staff {$username}"; $remarks = "requestitionNo_{$verificationNo[$v]} / from inventoryCode of {$inventoryCode[$i]}"; $quantity = $ro->selectNow("inventoryManager", "quantity", "verificationNo", $verificationNo[$v]); $currentQTY = $ro->getCurrentQTY($inventoryCode[$i]) - $quantity; $requestingUser = $ro->selectNow("inventoryManager", "requestingUser", "verificationNo", $verificationNo[$v]); $invqty = $ro->selectNow("inventory", "quantity", "inventoryCode", $inventoryCode[$i]); if ($quantity > $invqty) { } else { if ($inventoryType == "medicine") { $ro->addNewMedicine1($description, $generic, $unitcost, $quantity, $expiration, $requestingUser, $date, $serverTime, $inventoryLocation, $inventoryType, $branch, $transition, $remarks, $ro->selectNow("inventory", "Added", "inventoryCode", $inventoryCode[$i]), $inventoryCode[$i]); } else { $ro->addNewMedicine1($description, $generic, $unitcost, $quantity, $expiration, $requestingUser, $date, $serverTime, $inventoryLocation, $inventoryType, $branch, $transition, $remarks, $ro->selectNow("inventory", "unitcost", "inventoryCode", $inventoryCode[$i]), $inventoryCode[$i]); } $timezone = "Asia/Manila"; date_default_timezone_set($timezone); $ro->editNow("inventoryManager", "verificationNo", $verificationNo[$v], "dateIssued", date("Y-m-d")); $ro->editNow("inventoryManager", "verificationNo", $verificationNo[$v], "timeIssued", date("H:i:s")); $ro->editNow("inventoryManager", "verificationNo", $verificationNo[$v], "issuedBy", $username); $ro->editNow("inventoryManager", "verificationNo", $verificationNo[$v], "status", "dispensed"); $ro->editNow("inventoryManager", "verificationNo", $verificationNo[$v], "quantityIssued", $quantity); $newQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $inventoryCode[$i]) - $quantity; $ro->editNow("inventory", "inventoryCode", $inventoryCode[$i], "quantity", $newQTY); $ro->editNow("inventoryManager", "verificationNo", $verificationNo[$v], "status", "Received"); //$ro->addNewMedicine1($description,$generic,$unitcost,$quantity,$expiration,$addedBy,$date,$time,$inventoryLocation,$inventoryType,$branch,$transition,$remarks,$ro->selectNow("inventory","Added","inventoryCode",$inventoryCode)); } }
$ro = new database2(); //echo ( $cash - $targetAmount ); echo "<center><br>"; $itemz = preg_split("/\\_/", $ro->getMaximumTotal_rBanny($registrationNo)); //format cashUnpaid_itemNo echo "<Br>"; echo "Item#: " . $itemz[1]; echo "<br>Price: " . $itemz[0]; echo "<br><b>Analyzing " . $ro->selectNow("patientCharges", "description", "itemNo", $itemz[1]) . "</b>"; //check kung ilan na lang ung natitira sa target amount kpg bnwsan na sa current phic ng px $pxPHIC = $ro->getCurrentPHIC_check_rBanny($registrationNo) - $targetAmount; //check kung mas mataas pa ung total ng item kaysa sa natitirang sa targetAmount if ($itemz[0] >= $pxPHIC) { $newCash = $ro->selectNow("patientCharges", "cashUnpaid", "itemNo", $itemz[1]) - ($targetAmount - $ro->getTotal("phic", "", $registrationNo)); if ($newCash > 1) { $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", $newCash); $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $targetAmount - $ro->getTotal("phic", "", $registrationNo)); } else { $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $ro->selectNow("patientCharges", "cashUnpaid", "itemNo", $itemz[1])); $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", "0"); } } else { $excessPHIC = $itemz[0] - $targetAmount; $exactPHIC = $itemz[0] - $excessPHIC; $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", $excessPHIC); $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $exactPHIC); } if ($ro->getTotal("phic", "", $registrationNo) != $targetAmount) { $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/rBanny/analyzing_rBanny.php?registrationNo={$registrationNo}&cash={$cash}&targetAmount={$targetAmount}"); } else { echo "<br><Br><Br><center><font size=5 color=red><i>R-Banny is now completed the PhilHealth CaseRate</i></font></center>";
<?php include "../../myDatabase2.php"; $registrationNo = $_GET['registrationNo']; $username = $_GET['username']; $ro = new database2(); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "verified", $username . "+" . date("M_d_Y") . "+" . $ro->getSynapseTime()); echo "<font color=red>Patient is now Verified</font>"; ?>
<?php include "../../../myDatabase2.php"; $itemNo = $_GET['itemNo']; $registrationNo = $_GET['registrationNo']; $username = $_GET['username']; $ro = new database2(); $ro->editNow("core2_laboratoryResultChecker", "itemNo", $itemNo, "status", "DELETED_{$username}-@" . date("Y-m-d") . "-" . $ro->getSynapseTime()); $ro->editNow("labSavedResult", "itemNo", $itemNo, "status", "DELETED_{$username}-@" . date("Y-m-d") . "-" . $ro->getSynapseTime()); echo "<br><Br><br<center>"; echo $ro->selectNow("patientCharges", "description", "itemNo", $itemNo) . " Result is now Deleted";
<?php include "../../../myDatabase2.php"; $username = $_GET['username']; $idNo = $_GET['idNo']; $transactionNo = $_GET['transactionNo']; $ro = new database2(); $ro->editNow("disbursement", "idNo", $idNo, "status", "DELETED"); $ro->editNow("disbursement", "idNo", $idNo, "deleteDetails", date("Y-m-d") . "_" . date("H:i:s") . "_" . $username); if ($fromPage == "encode") { $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/accounting/cashDisbursement/disbursementUpdate.php?transactionNo={$transactionNo}&username={$username}"); } else { $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/accounting/cashDisbursement/editDisbursementEntry/disbursementUpdate.php?transactionNo={$transactionNo}&username={$username}"); }
color: #000; height: 28px; width: 381px; border-color:red red red red; font-size:15px; text-align:center; background-color:white; } .button:hover { background-color:yellow; color:black; } .button1:hover { background-color:yellow; color:black; } </style> <?php $ro->editNow("convenienceInventory", "inventoryNo", $inventoryNo, "description", $description); $ro->editNow("convenienceInventory", "inventoryNo", $inventoryNo, "qty", $qty); echo "<center><br><br><br>"; echo "<form method='post' action='http://" . $ro->getMyUrl() . "/COCONUT/convenience/viewInventory.php'>"; $ro->coconutHidden("username", $username); echo "<input type=submit value='Back to Inventory List' class='button'>"; echo "</form>";
<?php include "../../../myDatabase2.php"; $username = $_GET['username']; //$month = $_GET['month']; //$day = $_GET['day']; //$year = $_GET['year']; $date = $_GET['date']; $startHour = $_GET['startHour']; $startMinute = $_GET['startMinute']; $startSeconds = $_GET['startSeconds']; $stopHour = $_GET['stopHour']; $stopMinute = $_GET['stopMinute']; $stopSeconds = $_GET['stopSeconds']; $status = $_GET['status']; $hours = $_GET['hours']; $ro = new database2(); $newTimeStart = $startHour . ":" . $startMinute . ":" . $startSeconds; $newTimeStop = $stopHour . ":" . $stopMinute . ":" . $stopSeconds; $ro->editNow("generatorCharge", "dateStart", $date, "timeStart", $newTimeStart); $ro->editNow("generatorCharge", "dateStart", $date, "timeStop", $newTimeStop); $ro->editNow("generatorCharge", "dateStart", $date, "status", $status); $ro->editNow("generatorCharge", "dateStart", $date, "hours", $hours);
<?php include "../../myDatabase2.php"; $username = $_POST['username']; $refNo = $_POST['refNo']; $accountNo = $_POST['accountNo']; $accountName = $_POST['accountName']; $bold = $_POST['bold']; $ro = new database2(); $ro->editNow("accountTitle", "refNo", $refNo, "accountNo", $accountNo); $ro->editNow("accountTitle", "refNo", $refNo, "accountTitle", $accountName); $ro->editNow("accountTitle", "refNo", $refNo, "bold", $bold); echo "<br><br><br><Br><Br>"; $ro->coconutFormStart("post", "/COCONUT/accounting/chartOfAccounts.php"); $ro->coconutHidden("username", $username); echo "<center>"; echo "<form><input type='submit' style='border:1px solid #ff0000; font-size:100%;' value='Back to Chart of Accounts'></form>"; $ro->coconutFormStop();
<?php include "../../../myDatabase2.php"; $registrationNo = $_GET['registrationNo']; $isCash = $_GET['isCash']; $username = $_GET['username']; $ro = new database2(); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "isPackageCash", $isCash); $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientProfile_right.php?registrationNo={$registrationNo}&username={$username}");
<?php include "../../../myDatabase2.php"; $registrationNo = $_GET['registrationNo']; $itemNo = $_GET['itemNo']; $username = $_GET['username']; $chiefComplaints = $_GET['chiefComplaints']; $doctorsOrder = $_GET['doctorsOrder']; $ro = new database2(); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "initialDiagnosis", $chiefComplaints); if ($ro->selectNow("SOAP", "itemNo", "itemNo", $itemNo) == "") { $ro->insert_soap($itemNo, $registrationNo, $chiefComplaints, "", "", $doctorsOrder); } else { $ro->editNow("SOAP", "itemNo", $itemNo, "plan", $doctorsOrder); } $ro->coconutFormStart("post", "http://" . $ro->getMyUrl() . "/COCONUT/android/doctor/viewPatient_information.php"); $ro->coconutHidden("registrationNo", $registrationNo); $ro->coconutHidden("itemNo", $itemNo); $ro->coconutHidden("username", $username); echo "<br><br><br><br><br><center>"; $ro->coconutBoxStart("400", "60"); echo "<br>"; $ro->coconutButton("Proceed"); $ro->coconutBoxStop(); $ro->coconutFormStop(); ?>
<?php include "../../myDatabase2.php"; $registrationNo = $_POST['registrationNo']; $username = $_POST['username']; $ro = new database2(); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "finishER", date("Y-m-d") . "@" . date("H:i:s") . "@" . $username);
<?php include "../../../myDatabase2.php"; $itemNo = $_GET['itemNo']; $countItem = count($itemNo); $registrationNo = $_GET['registrationNo']; $username = $_GET['username']; $ro = new database2(); for ($x = 0; $x < $countItem; $x++) { $ro->editNow("room", "Description", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo[$x]), "status", "Vacant"); $ro->editNow("patientCharges", "itemNo", $itemNo[$x], "status", "Discharged"); } $ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "dateUnregistered", date("Y-m-d")); $ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "timeUnregistered", $ro->getSynapseTime()); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "mgh", $username); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "unregisteredBy", $username); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "mgh_date", date("Y-m-d") . "@" . $ro->getSynapseTime()); echo "<center><br><Br><Br><font color=red>Patient Discharged</font>";
include "../../../myDatabase2.php"; $registrationNo = $_GET['registrationNo']; $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="); }
<?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}");
<?php include "../../../myDatabase2.php"; $packageNo = $_GET['packageNo']; $inventoryCode = $_GET['inventoryCode']; $qty = $_GET['qty']; $ro = new database2(); $desc = $ro->selectNow("inventory", "description", "inventoryCode", $inventoryCode); $inventoryType = $ro->selectNow("inventory", "inventoryType", "inventoryCode", $inventoryCode); $title = ""; if ($inventoryType == "medicine") { $title = "MEDICINE"; } else { $title = "SUPPLIES"; } $ro->editNow("hospitalPackage", "packageNo", $packageNo, "packageIncluded_description", $desc . "_" . $inventoryCode . "_" . $title); $ro->editNow("hospitalPackage", "packageNo", $packageNo, "packageIncluded_qty", $qty); echo "<br><br><br><center><font color=red size=4> SUCCESSFULLY UPDATED </font>";
<?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"; $verificationNo = $_POST['verificationNo']; $inventoryCode = $_POST['inventoryCode']; $description = $_POST['description']; $qty = $_POST['qty']; $borrowerDepartment = $_POST['borrowerDepartment']; $returnBy = $_POST['returnBy']; $ro = new database2(); $newQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $inventoryCode) + $qty; $ro->editNow("inventory", "inventoryCode", $inventoryCode, "quantity", $newQTY); $ro->csrReturnItem($verificationNo, $inventoryCode, $description, $qty, $borrowerDepartment, $returnBy, date("Y-m-d"), $ro->getSynapseTime()); echo "<br><Br><Br><center><font color=red>{$description} Returned</font>";
include "../../myDatabase2.php"; $username = $_POST['username']; $password = $_POST['password']; $registrationNo = $_POST['registrationNo']; $status = $_POST['status']; $station = $_POST['station']; $timeDischarged = date("H:i:s"); $ro = new database2(); if ($username == "") { $ro->getBack("AUTHENTICATION ERROR"); } else { if ($password == "") { $ro->getBack("AUTHENTICATION ERROR"); } else { if ($username == "" && $password == "") { $ro->getBack("AUTHENTICATION ERROR"); } else { if ($ro->getEmployeeId_username($username, $password) != "") { if ($status == "Discharged") { $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "timeDischargedFromNS", $timeDischarged); } else { } $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "nurseStationStatus", $status); echo " <center><br><br><br><br><br><br>Patient Updated <br>{$status}: {$timeDischarged} <br><br> <form method='post' action='showStationRoom.php'><input type='submit' value='<< Back To Patient List' style='border:1px solid #ff0000; background-color:transparent; height:40px; ' ><input type='hidden' name='station' value='{$station}' > </form>"; } else { $ro->getBack("AUTHENTICATION ERROR"); } } } }
<?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"; $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}");
<?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']; $refNo = $_GET['refNo']; $username = $_GET['username']; $ro = new database2(); $ro->editNow("companyPayment", "refNo", $refNo, "status", "DELETED_" . $username . "_" . date("Y-m-d")); $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/Payments/viewCompanyPayment.php?registrationNo={$registrationNo}&username={$username}");