<?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";
$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());
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->editNow("inventory", "inventoryCode", $chargesCode, "quantity", $newQTY); // update qty sa database
$countz = count($packageNo); $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])); //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; } }
echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/discharged/discharged.php?registrationNo={$registrationNo}&protoType=Undischarged&room='><img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/locked1.jpeg'></a> <font size=2 color=red><b>" . $ro->getRegistrationDetails_type() . "</b></font><br>"; } echo "<font class='informationLabel'>Patient No:</font> " . $ro->getRegistrationDetails_patientNo(); echo "<br><font class='informationLabel'>Registration No:</font> " . $ro->getRegistrationDetails_registrationNo(); echo "<br><font class='informationLabel'>Age:</font> " . $ro->getPatientRecord_age(); echo "<br><font class='informationLabel'>Gender:</font> " . $ro->getPatientRecord_gender(); echo "<br><font class='informationLabel'>Civil Status:</font> " . $ro->getPatientRecord_civilStatus(); echo "<br><font class='informationLabel'>Birth Date:</font> " . $ro->getPatientRecord_Birthdate(); echo "<br><font class='informationLabel'>Contact No#:</font> " . $ro->getPatientRecord_contactNo(); echo "<br><font class='informationLabel'>Senior:</font> " . $ro->getPatientRecord_senior(); echo "<br><font class='informationLabel'>PhilHealth:</font> " . $ro->getPatientRecord_phic(); echo "<br><font class='informationLabel'>PhilHealth Type:</font> " . $ro->getPHICtype_patientRecord(); echo "<br><font class='informationLabel'>Company:</font> " . $ro->getRegistrationDetails_company(); echo "<br><font class='informationLabel'>Time Registered:</font> " . $ro->getRegistrationDetails_timeRegistered(); echo "<br><font class='informationLabel'>Date Registered:</font> " . $ro->getRegistrationDetails_dateRegistered(); echo "<br><font class='informationLabel'>Branch Registered:</font> " . $ro->getRegistrationDetails_branch(); echo "<br><font class='informationLabel'>Case Type:</font> <a href='#' style='text-decoration:none; color:black;'>" . $ro->getRegistrationDetails_caseType() . "</a>"; echo "<br><font class='informationLabel'>Package:</font> <a href='#' style='text-decoration:none; color:black;'>" . $ro->getRegistrationDetails_package() . "</a>"; echo "<br><font class='informationLabel'>Room:</font> " . $room[0]; echo "<br><font class='informationLabel'>Address:</font> " . $ro->getPatientRecord_address(); echo "<br><font class='informationLabel'>Registered By:</font> " . $ro->getRegistrationDetails_registeredBy(); if ($ro->selectNow("reportHeading", "information", "reportName", "Credit Limit") == "Activate" and $ro->selectNow("registrationDetails", "type", "registrationNo", $registrationNo) == "IPD") { echo "<br><font class='informationLabel' color=blue>Allowed Balance:</font> " . number_format($ro->selectNow("registrationDetails", "LimitCASH", "registrationNo", $registrationNo), 2); echo "<br><font class='informationLabel' color=red>Current Balance:</font> " . number_format($ro->may_naibayad_naba_ang_patient($registrationNo), 2); } else { } if ($ro->getRegistrationDetails_dateUnregistered() != "") { echo "<br><font class='informationLabel'>Time Discharged:</font> " . $ro->getRegistrationDetails_timeUnregistered(); echo "<br><font class='informationLabel'>Discharged:</font> " . $ro->getRegistrationDetails_dateUnregistered(); } else { echo "";