<?php
include "../../../myDatabase1.php";
$registrationNo = $_GET['registrationNo'];
$dispensedNo = $_GET['dispensedNo'];
$ro = new database1();
$ro->getPatientProfile($registrationNo);
echo "<center><b><font size=4>" . $ro->getReportInformation("hmoSOA_name") . "</font></b></center>";
echo "<center><b><font size=2>" . $ro->getReportInformation("hmoSOA_address") . "</font></b></center>";
echo "<center><font size=2>Tel No. (062) 2143237</font></center>";
echo "<br>";
echo "Reg#: " . $registrationNo . " Batch#: " . $dispensedNo;
echo "<br>";
echo "Name: " . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName();
echo "<br>";
echo "Date Print: " . date("M d, Y");
echo "<br>";
echo "PhilHealth: " . $ro->getPatientRecord_phic();
echo "<br><br>";
$ro->getBatchMeds($registrationNo, $dispensedNo);
$room = preg_split("/\\_/", $ro->getRegistrationDetails_room());
echo "<br>";
if ($ro->getRegistrationDetails_dateUnregistered() == "") {
echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/discharged/discharged.php?registrationNo={$registrationNo}&protoType=Discharged&room=" . $ro->getRegistrationDetails_room() . "'><img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/unlock.jpeg'></a> <font size=2 color=red><b>" . $ro->getRegistrationDetails_type() . "</b></font><br>";
} else {
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 {
}
$room = $_GET['room'];
$quantity = $_GET['quantity'];
$remarks = $_GET['remarks'];
$ro = new database1();
$ro->getPHIClimit_setter($ro->selectNow("registrationDetails", "casetype", "registrationNo", $registrationNo));
$ro->getPatientProfile($registrationNo);
// kunin ang data ng patient
//$totalPrice = $sellingPrice * $quantity; //kunin ang total price
//selectNow($table,$cols,$identifier,$identifierData)
//$ro->selectNow("inventory","phic","inventoryCode",$chargesCode); // ttgnan kung cover ba ng philhealth ung medicine
//number_format($ro->getCurrentPHIC_check($registrationNo,"MEDICINE") - $ro->getPHIClimit_medicine(),2)
if ($quantity == 0) {
$ro->getBack("Zero is not Allowed");
} 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());
$inventoryFrom = $_GET['inventoryFrom'];
$room = $_GET['room'];
$quantity = $_GET['quantity'];
$ro = new database1();
$ro->getPHIClimit_setter($ro->selectNow("registrationDetails", "casetype", "registrationNo", $registrationNo));
$ro->getPatientProfile($registrationNo);
// kunin ang data ng patient
//$totalPrice = $sellingPrice * $quantity; //kunin ang total price
//selectNow($table,$cols,$identifier,$identifierData)
//$ro->selectNow("inventory","phic","inventoryCode",$chargesCode); // ttgnan kung cover ba ng philhealth ung medicine
if ($quantity == 0) {
$ro->getBack("Zero is not Allowed");
} else {
//number_format($ro->getCurrentPHIC_check($registrationNo,"MEDICINE") - $ro->getPHIClimit_medicine(),2)
$remainingLimit = $ro->getPHIClimit_medicine() - $ro->getCurrentPHIC_check($registrationNo, "MEDICINE");
if ($ro->getPatientRecord_phic() == "YES") {
//cover at pasok pa sa phic limit ng meds
$totalPrice = $sellingPrice * $quantity;
//phic price
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", $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 {
