<?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}");
