$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$batchNo = $_GET['batchNo'];
$unitcost = $_GET['unitcost'];
$Added = $_GET['Added'];
$ro = new database1();
$ro->getPatientProfile($registrationNo);
for ($x = 0; $x < $countz; $x++) {
$packageIncluded = preg_split("/\\_/", $ro->selectNow("hospitalPackage", "packageIncluded_description", "packageNo", $packageNo[$x]));
$itemQTY = $ro->selectNow("hospitalPackage", "packageIncluded_qty", "packageNo", $packageNo[$x]);
//addCharges_cash($status,$registrationNo,$chargesCode,$description,$sellingPrice,$discount,$total,$cashUnpaid,$phic,$company,$timeCharge,$dateCharge,$chargeBy,$service,$title,$paidVia,$cashPaid,$batchNo,$quantity,$inventoryFrom,$branch,$room)
$sellingPrice;
if ($packageIncluded[2] == "LABORATORY" || $packageIncluded[2] == "RADIOLOGY" || $packageIncluded[2] == "ECG" || $packageIncluded[2] == "OR/DR/ER Fee" || $packageIncluded[2] == "REHAB") {
$services = "Examination";
$chargesPrice = $ro->selectNow("availableCharges", "PRIVATE", "chargesCode", $packageIncluded[1]);
$ro->addCharges_cash("UNPAID", $registrationNo, $packageIncluded[1], $packageIncluded[0], $chargesPrice, "0.00", $chargesPrice, $chargesPrice, "0.00", "0.00", $ro->getSynapseTime(), date("Y-m-d"), $username, $services, $packageIncluded[2], "Cash", "0.00", $batchNo, $ro->selectNow("hospitalPackage", "packageIncluded_qty", "packageNo", $packageNo[$x]), $ro->selectNow("inventory", "inventoryLocation", "inventoryCode", $packageIncluded[1]), $ro->getRegistrationDetails_branch(), $ro->getRegistrationDetails_room());
} else {
if ($packageIncluded[2] == "MEDICINE") {
$services = "Medication";
$medPrice = preg_split("/\\_/", $ro->selectNow("hospitalPackage", "Added", "packageNo", $packageNo[$x]));
//original
//$ro->addCharges_cash("UNPAID",$registrationNo,$packageIncluded[1],$packageIncluded[0],$medPrice[1],"0.00",$medPrice[1],$medPrice[1],"0.00","0.00",$ro->getSynapseTime(),date("Y-m-d"),$username,$services,$packageIncluded[2],"Cash","0.00",$batchNo,$ro->selectNow("hospitalPackage","packageIncluded_qty","packageNo",$packageNo[$x]),"PHARMACY",$ro->getRegistrationDetails_branch(),$ro->getRegistrationDetails_room());
if ($ro->selectNow("inventory", "autoDispense", "inventoryCode", $packageIncluded[1]) == "yes") {
//check autoDispense
$currentQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $packageIncluded[1]);
// current qty ng meds sa inventory
$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());
<?php
include "../../../myDatabase1.php";
$packageNo = $_GET['packageNo'];
$countz = count($packageNo);
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database1();
$ro->getPatientProfile($registrationNo);
for ($x = 0; $x < $countz; $x++) {
$packageIncluded = preg_split("/\\_/", $ro->selectNow("hospitalPackage", "packageIncluded_description", "packageNo", $packageNo[$x]));
//addCharges_cash($status,$registrationNo,$chargesCode,$description,$sellingPrice,$discount,$total,$cashUnpaid,$phic,$company,$timeCharge,$dateCharge,$chargeBy,$service,$title,$paidVia,$cashPaid,$batchNo,$quantity,$inventoryFrom,$branch,$room)
if ($packageIncluded[2] != "MEDICINE" || $packageIncluded[2] != "PROFESSIONAL FEE") {
$services = "Examination";
} else {
if ($packageIncluded[2] == "MEDICINE") {
$services = "Medication";
} else {
$services = "PROFESSIONAL FEE";
}
}
$ro->addCharges_cash("UNPAID", $registrationNo, $packageIncluded[1], $packageIncluded[0], "0.00", "0.00", "0.00", "0.00", "0.00", "0.00", $ro->getSynapseTime(), date("M_d_Y"), $username, $services, $packageIncluded[2], "Cash", "0.00", "package", $ro->selectNow("hospitalPackage", "packageIncluded_qty", "packageNo", $packageNo[$x]), "", $ro->getRegistrationDetails_branch(), $ro->getRegistrationDetails_room());
}
echo "\n<script type='text/javascript'>\nwindow.parent.location.reload();\n</script>\n\n";
$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->editNow("inventory", "inventoryCode", $chargesCode, "quantity", $newQTY);
// update qty sa database
$ro->addCharges_cash_autoDispense($status, $registrationNo, $chargesCode, $description, $sellingPrice * 0.15 + $sellingPrice, "0", $totalPrice, $excess, $remainingLimit, "0", $timeCharge, date("Y-m-d"), $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room, "dispensedBy_" . $username, $ro->getSynapseTime());
} else {
if ($remainingLimit <= 0) {
