$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
$newQTY = $currentQTY - $itemQTY;
// less sa inventory as in qty after ibawas ung desired qty
$ro->editNow("inventory", "inventoryCode", $packageIncluded[1], "quantity", $newQTY);
// update qty sa database
$ro->addCharges_cash_autoDispense("UNPAID", $registrationNo, $packageIncluded[1], $packageIncluded[0], $medPrice[1], "0.00", "0.00", "0.00", "0.00", "0.00", $ro->getSynapseTime(), date("Y-m-d"), $username, $services, $packageIncluded[2], "Cash", "0.00", $batchNo, $itemQTY, $ro->selectNow("inventory", "inventoryLocation", "inventoryCode", $packageIncluded[1]), $ro->getRegistrationDetails_branch(), $ro->getRegistrationDetails_room(), "dispensedBy_" . $username, $ro->getSynapseTime());
} else {
$ro->addCharges_cash("UNPAID", $registrationNo, $packageIncluded[1], $packageIncluded[0], $medPrice[1], "0.00", "0.00", "0.00", "0.00", "0.00", $ro->getSynapseTime(), date("Y-m-d"), $username, $services, $packageIncluded[2], "Cash", "0.00", $batchNo, $itemQTY, $ro->selectNow("inventory", "inventoryLocation", "inventoryCode", $packageIncluded[1]), $ro->getRegistrationDetails_branch(), $ro->getRegistrationDetails_room());
}
} else {
if ($packageIncluded[2] == "SUPPLIES") {
$services = "Others";
$supPrice = $ro->selectNow("hospitalPackage", "unitcost", "packageNo", $packageNo[$x]);
//original
//$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());
if ($ro->selectNow("inventory", "autoDispense", "inventoryCode", $packageIncluded[1]) == "yes") {
$currentQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $packageIncluded[1]);
// current qty ng meds sa inventory
$newQTY = $currentQTY - $itemQTY;
<?php
include "../../../myDatabase1.php";
$packageName = $_GET['packageName'];
$packagePrice = $_GET['packagePrice'];
$ro = new database1();
$ro->editNow("hospitalPackage", "packageName", $packageName, "packagePrice", $packagePrice);
<?php
include "../../../myDatabase1.php";
$username = $_GET['username'];
$hospital = $_GET['hospital'];
$address = $_GET['address'];
$headingNo = $_GET['headingNo'];
$ro = new database1();
$ro->editNow("radioHeading", "headingNo", $headingNo, "hospital", $hospital);
$ro->editNow("radioHeading", "headingNo", $headingNo, "address", $address);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Results/Radiology/radioHeadingMasterfile.php?username={$username}");
} 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
if ($remainingLimit >= $totalPrice) {
//cover lahat
//check autoDispense????
if ($ro->selectNow("inventory", "autoDispense", "inventoryCode", $chargesCode) == "yes") {
$currentQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode);
// current qty ng meds/sup sa inventory
$newQTY = $currentQTY - $quantity;
// less sa inventory as in qty after ibawas ung desired qty ng user
$ro->editNow("inventory", "inventoryCode", $chargesCode, "quantity", $newQTY);
// update qty sa database
$ro->addCharges_cash_autoDispense($status, $registrationNo, $chargesCode, $description, $sellingPrice * 0.15 + $sellingPrice, "0", $totalPrice, "0", $totalPrice, "0", $timeCharge, date("Y-m-d"), $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room, "dispensedBy_" . $username, $ro->getSynapseTime());
} else {
//nka cash price pa e2 instead n nka philhealth price
$ro->addCharges_cash($status, $registrationNo, $chargesCode, $description, $sellingPrice, "0", $totalPrice, "0", $totalPrice, "0", $timeCharge, date("Y-m-d"), $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room, $remarks, "");
}
} else {
//hindi lahat cover so hahatiin ung total pra maging eksakto sa allowed phic supplies limit
$excess = $totalPrice - $remainingLimit;
//check autoDispense????
if ($ro->selectNow("inventory", "autoDispense", "inventoryCode", $chargesCode) == "yes") {
$currentQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode);
// current qty ng meds/sup sa inventory
$newQTY = $currentQTY - $quantity;
// less sa inventory as in qty after ibawas ung desired qty ng user
$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 {
$services = "PROFESSIONAL FEE";
$sellingPrice = 0;
}
}
}
/*
$ro->addCharges_cash("UNPAID",$registrationNo,$packageIncluded[1],$packageIncluded[0],$sellingPrice,"0.00","0.00","0.00","0.00","0.00",$ro->getSynapseTime(),date("M_d_Y"),$username,$services,$packageIncluded[2],"Cash","0.00",$batchNo,$ro->selectNow("hospitalPackage","packageIncluded_qty","packageNo",$packageNo[$x]),"PHARMACY",$ro->getRegistrationDetails_branch(),$ro->getRegistrationDetails_room());
*/
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "package", $ro->selectNow("hospitalPackage", "packageNo", "packageNo", $packageNo[$x]) . "_" . $ro->selectNow("hospitalPackage", "packageName", "packageNo", $packageNo[$x]));
}
echo "\r\n<script type='text/javascript'>\r\nwindow.parent.location.reload();\r\n</script>\r\n\r\n";
<?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";
$registrationNo = $_GET['registrationNo'];
$ro = new database1();
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "dateUnregistered", date("M_d_Y"));
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "timeUnregistered", $ro->getSynapseTime());
echo "\n<script type='text/javascript'>\nalert('Patient is now Discharged');\n</script>\n\n\n";
<?php
include "../../../myDatabase1.php";
$username = $_GET['username'];
$title = $_GET['title'];
$report = $_GET['report'];
$reportNo = $_GET['reportNo'];
$ro = new database1();
$ro->editNow("radioReportList", "reportNo", $reportNo, "title", $title);
$ro->editNow("radioReportList", "reportNo", $reportNo, "report", $report);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Results/Radiology/radioReportTemplateMasterfile.php?username={$username}");
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "cashPaid", $ro->doubleSelectNow("patientCharges", "cashUnpaid", "itemNo", $itemNo[$x], "registrationNo", $registrationNo));
// kuhain ang total price at ilagay sa cashPaid cols
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "cashUnpaid", "0");
// gwen 0 ang cashUnpaid cols
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "status", "PAID");
// tagged as PAID
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "datePaid", $datePaid);
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "control_datePaid", $year . "-" . $m . "-" . $day);
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "timePaid", $ro->getSynapseTime());
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "paidBy", $username);
// gwen 0 ang cashUnpaid cols
/*
$newQty = ( $ro->selectNow("inventory","quantity","inventoryCode", $ro->selectNow("patientCharges","chargesCode","itemNo",$itemNo[$x])) - $ro->selectNow("patientCharges","quantity","itemNo",$itemNo[$x]) );
$ro->editNow("inventory","inventoryCode",$ro->doubleSelectNow("patientCharges","chargesCode","itemNo",$itemNo[$x],"registrationNo",$registrationNo),"quantity",$newQty);
*/
//$ro->doubleEditNow("patientCharges","itemNo",$itemNo[$x],"registrationNo",$registrationNo,"departmentStatus","dispensedBy_".$username);
//$ro->doubleEditNow("patientCharges","itemNo",$itemNo[$x],"registrationNo",$registrationNo,"departmentTime",$ro->getSynapseTime());
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "orNO", $orNO);
$ro->doubleEditNow("patientCharges", "itemNo", $itemNo[$x], "registrationNo", $registrationNo, "receiptType", $receiptType);
}
$ro->getPatientProfile($registrationNo);
if ($ro->getPatientRecord_firstName() == "N/A" && $ro->getPatientRecord_middleName() == "N/A") {
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "dateUnregistered", date("Y-m-d"));
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "timeUnregistered", $ro->getSynapseTime());
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "mgh", "Synapse System");
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "mgh_date", date("Y-m-d"));
$ro->gotoPage("/COCONUT/patientProfile/individualPayment/checkBalance.php?registrationNo={$registrationNo}&username={$username}");
} else {
$ro->gotoPage("/COCONUT/patientProfile/individualPayment/checkBalance.php?registrationNo={$registrationNo}&username={$username}");
}
<?php
include "../../myDatabase1.php";
$registrationNo = $_GET['registrationNo'];
$package = $_GET['package'];
$ro = new database1();
$ro->editNow("phicTransmit", "registrationNo", $registrationNo, "package", $package);
echo "\n\n<script type='text/javascript'>\nalert('Package Amount Activated');\n</script>\n\n";
<?php
include "../../../myDatabase1.php";
$itemNo = $_GET['itemNo'];
$countz = count($itemNo);
$registrationNo = $_GET['registrationNo'];
$user = $_GET['username'];
$ro = new database1();
$ro->getPatientProfile($registrationNo);
for ($x = 0; $x < $countz; $x++) {
$ricky = preg_split("/\\_/", $itemNo[$x]);
// combine itemNo + total = itemNo_total_orNo
$ro->getPatientChargesToEdit($ricky[0]);
$ro->addVoidPayment($registrationNo . "_" . $ro->getPatientRecord_completeName(), $ricky[0] . "_" . $ro->patientCharges_Description(), $ro->patientCharges_cashPaid(), $ro->getSynapseTime(), date("Y-m-d"), $user, $ricky[2]);
$ro->editNow("patientCharges", "itemNo", $ricky[0], "status", "UNPAID");
$ro->editNow("patientCharges", "itemNo", $ricky[0], "orNo", "");
$ro->editNow("patientCharges", "itemNo", $ricky[0], "cashPaid", "0");
$ro->editNow("patientCharges", "itemNo", $ricky[0], "datePaid", "");
$ro->editNow("patientCharges", "itemNo", $ricky[0], "timePaid", "");
$ro->editNow("patientCharges", "itemNo", $ricky[0], "paidBy", "");
$ro->editNow("patientCharges", "itemNo", $ricky[0], "cashUnpaid", $ricky[1]);
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "dateUnregistered", "");
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "timeUnregistered", "");
}
echo "\n<script type='text/javascript'>\nalert('Void Payment Success');\nwindow.location = 'http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientProfile_handler.php?registrationNo={$registrationNo}&username={$user}';\n</script>\n\n";
$services = "Examination";
$chargesPrice = $ro->selectNow("hospitalPackage", "Added", "packageNo", $packageNo[$x]);
$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 = $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
$newQTY = $currentQTY - $itemQTY;
// less sa inventory as in qty after ibawas ung desired qty
$ro->editNow("inventory", "inventoryCode", $packageIncluded[1], "quantity", $newQTY);
// update qty sa database
$ro->addCharges_cash_autoDispense("UNPAID", $registrationNo, $packageIncluded[1], $packageIncluded[0], $medPrice[1], "0.00", "0.00", "0.00", "0.00", "0.00", $ro->getSynapseTime(), date("Y-m-d"), $username, $services, $packageIncluded[2], "Cash", "0.00", $batchNo, $itemQTY, $ro->selectNow("inventory", "inventoryLocation", "inventoryCode", $packageIncluded[1]), $ro->getRegistrationDetails_branch(), $ro->getRegistrationDetails_room(), "dispensedBy_" . $username, $ro->getSynapseTime());
} else {
$ro->addCharges_cash("UNPAID", $registrationNo, $packageIncluded[1], $packageIncluded[0], $medPrice, "0.00", $medPrice, $medPrice, "0.00", "0.00", $ro->getSynapseTime(), date("Y-m-d"), $username, $services, $packageIncluded[2], "Cash", "0.00", $batchNo, $itemQTY, $ro->selectNow("inventory", "inventoryLocation", "inventoryCode", $packageIncluded[1]), $ro->getRegistrationDetails_branch(), $ro->getRegistrationDetails_room(), "", "", "", "", "", "");
}
} else {
if ($packageIncluded[2] == "SUPPLIES") {
$services = "Others";
$supPrice = $ro->selectNow("hospitalPackage", "Added", "packageNo", $packageNo[$x]);
//original
$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(), "", "", "", "", "", "");
//$ro->addCharges_cash("UNPAID",$registrationNo,$packageIncluded[1],$packageIncluded[0],$supPrice,"0.00","0.00","0.00","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 {
$services = "PROFESSIONAL FEE";
$sellingPrice = 0;
<?php
include "../../../myDatabase1.php";
$registrationNo = $_POST['registrationNo'];
$username = $_POST['username'];
$month = $_POST['month'];
$day = $_POST['day'];
$year = $_POST['year'];
$month_due = $_POST['month_due'];
$day_due = $_POST['day_due'];
$year_due = $_POST['year_due'];
$promisorryNote = $_POST['promisorryNote'];
$balance = $_POST['balance'];
$ro = new database1();
$startDate = $month . "_" . $day . "_" . $year;
$dueDate = $month_due . "_" . $day_due . "_" . $year_due;
$ro->editNow("promisorryNote", "registrationNo", $registrationNo, "startDate", $startDate);
$ro->editNow("promisorryNote", "registrationNo", $registrationNo, "dueDate", $dueDate);
$ro->editNow("promisorryNote", "registrationNo", $registrationNo, "amount", $balance);
$ro->editNow("promisorryNote", "registrationNo", $registrationNo, "note", $promisorryNote);
$ro->editNow("promisorryNote", "registrationNo", $registrationNo, "postedBy", $username);
header("Location: /COCONUT/patientProfile/patientProfile_handler.php?registrationNo={$registrationNo}&username={$username}");
}
///$newTotal = ($newPrice * $ro->patientCharges_quantity());
} else {
$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.35;
} 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.35;
}
//company HMO Price
//$newTotal = ($newPrice * $ro->patientCharges_quantity());
}
}
$newTotal = $newPrice * $ro->patientCharges_quantity();
if ($type == "CASH") {
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "sellingPrice", $newPrice);
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "total", $newTotal);
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "cashUnpaid", $newTotal);
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "phic", "0");
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "company", "0");
} else {
if ($type == "PhilHealth") {
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "sellingPrice", $newPrice);
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "total", $newTotal);
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "cashUnpaid", "0");
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "phic", $newTotal);
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "company", "0");
} else {
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "sellingPrice", $newPrice);
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "total", $newTotal);
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "cashUnpaid", "0");
<?php
include "../../myDatabase1.php";
$itemNo = $_GET['itemNo'];
$username = $_GET['username'];
$ro = new database1();
$ro->editNow("patientCharges", "itemNo", $itemNo, "departmentStatus", "");
echo "Pls Click the Patient's Name to view his/her Laboratories..";
<?php
include "../../../myDatabase1.php";
$templateNo = $_POST['templateNo'];
$title = $_POST['title'];
$formTemplate = $_POST['formTemplate'];
$ro = new database1();
$ro->editNow("labResultList", "templateNo", $templateNo, "title", $title);
$ro->editNow("labResultList", "templateNo", $templateNo, "template", $formTemplate);
echo "<script type='text/javascript' >";
echo "window.location='http://" . $this->getMyUrl() . "/COCONUT/Laboratory/resultList/resultFormMasterfile.php '";
echo "</script>";
$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(
function () {
$(this).addClass("hover").children().addClass("hover");
$(this).parent().prev().find("span.arrow:first").addClass("pre_hover");
},
<?php
include "../../../myDatabase1.php";
$registrationNo = $_GET['registrationNo'];
$countz = count($registrationNo);
$month = $_GET['month'];
$day = $_GET['day'];
$year = $_GET['year'];
$ro = new database1();
for ($x = 0; $x < $countz; $x++) {
$ro->editNow("registrationDetails", "registrationNo", $registrationNo[$x], "mgh", "");
$ro->editNow("registrationDetails", "registrationNo", $registrationNo[$x], "mgh_date", "");
}
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/MGH/showMGH.php?month={$month}&day={$day}&year={$year}&username=");
