<?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";
<?php include "../../../myDatabase1.php"; $registrationNo = $_GET['registrationNo']; $itemNo = $_GET['itemNo']; $username = $_GET['username']; $countz = count($itemNo); $ro = new database1(); for ($x = 0; $x < $countz; $x++) { $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo[$x], "status", "UNPAID"); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo[$x], "departmentStatus", "dispensedBy_" . $username); $ro->doubleEditNow("returnInventory", "registrationNo", $registrationNo, "itemNo", $itemNo[$x], "returnDetails_PHARMACY", date("Y-m-d") . "@" . $ro->getSynapseTime()); $ro->doubleEditNow("returnInventory", "registrationNo", $registrationNo, "itemNo", $itemNo[$x], "returnPHARMACY", "cancelledBy_" . $username); } echo "Cancelling of return meds completed!!";
<?php include "../../../myDatabase1.php"; $registrationNo = $_GET['registrationNo']; $itemNo = $_GET['itemNo']; $physician = $_GET['physician']; $radioReport = $_GET['radioReport']; $radtech = $_GET['radtech']; $ro = new database1(); if (isset($_GET['approved'])) { $ro->radioReportInsert($registrationNo, $itemNo, date("Y-m-d"), $physician, $radioReport, "Mendero Medical Center", "Consolacion,Cebu", $ro->getSynapseTime(), "yes", date("Y-m-d"), $ro->getSynapseTime(), $physician, $radtech); } else { $ro->radioReportInsert($registrationNo, $itemNo, date("Y-m-d"), $physician, $radioReport, "Mendero Medical Center", "Consolacion,Cebu", $ro->getSynapseTime(), "", "", "", "", $radtech); } $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Reports/radiologyReport/radioReport_output.php?itemNo={$itemNo}®istrationNo={$registrationNo}&description=" . $ro->selectNow("patientCharges", "description", "itemNo", $itemNo) . "");
$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; } }
$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
$toTime_seconds = $_GET['toTime_seconds']; $ro = new database1(); //$ro->doubleEditNow("patientCharges","registrationNo",$registrationNo,"itemNo",$itemNo,"status","PAID"); //$ro->doubleEditNow("patientCharges","registrationNo",$registrationNo,"itemNo",$itemNo,"cashUnpaid","0.00"); if ($ro->selectNow("patientCharges", "title", "itemNo", $itemNo) == "MEDICINE") { $price = preg_split("/\\_/", $ro->selectNow("inventory", "Added", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo))); $totalPay = $price[1] * $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "status", "PAID"); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "cashUnpaid", "0.00"); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "phic", "0.00"); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "company", "0.00"); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "cashPaid", $totalPay); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "sellingPrice", $price[1]); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "total", $totalPay); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "datePaid", date("Y-m-d")); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "timePaid", $ro->getSynapseTime()); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "paidBy", $username); } else { //supplies $totalPay = $ro->selectNow("inventory", "unitcost", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)) * $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "status", "PAID"); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "cashUnpaid", "0.00"); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "phic", "0.00"); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "company", "0.00"); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "cashPaid", $totalPay); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "sellingPrice", $ro->selectNow("inventory", "unitcost", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo))); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "total", $totalPay); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "datePaid", date("Y-m-d")); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "timePaid", $ro->getSynapseTime()); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "itemNo", $itemNo, "paidBy", $username); }
<?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";
} } } } } $datePaid = $year . "-" . $month . "-" . $day; for ($x = 0; $x < $countz; $x++) { $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"));
<?php include "../../../myDatabase1.php"; $short = $_GET['short']; $title = $_GET['title']; $registrationNo = $_GET['registrationNo']; $doctor = $_GET['doctor']; $pf = $_GET['pf']; $ro = new database1(); //addCharges_cash($status,$registrationNo,$chargesCode,$description,$sellingPrice,$discount,$total,$cashUnpaid,$phic,$company,$timeCharge,$dateCharge,$chargeBy,$service,$title,$paidVia,$cashPaid,$batchNo,$quantity,$inventoryFrom,$branch,$room) $ro->addCharges_magicPackage("UNPAID", $registrationNo, "mp", $title, $short, "0", $short, "0", $short, "0", $ro->getSynapseTime(), date("M_d_Y"), "billing", "Package", $title, "Cash", "0", "", "1", "", "Pagadian", ""); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "description", $doctor, "phic", $pf); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "description", $doctor, "sellingPrice", $pf . "/" . $pf); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "description", $doctor, "total", $pf);
<?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";
<?php include "../../../myDatabase1.php"; $paymentNo = $_GET['paymentNo']; $registrationNo = $_GET['registrationNo']; $username = $_GET['username']; $ro = new database1(); $ro->getPatientProfile($registrationNo); $ro->addVoidPayment($registrationNo . "_" . $ro->getPatientRecord_completeName(), "IPD_DELETE_" . $ro->selectNow("patientPayment", "paymentFor", "paymentNo", $paymentNo), $ro->selectNow("patientPayment", "amountPaid", "paymentNo", $paymentNo), $ro->getSynapseTime(), date("Y-m-d"), $username); $ro->deleteNow("patientPayment", "paymentNo", $paymentNo); echo "\n\n<script type='text/javascript'>\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/Payments/viewPayment.php?username={$username}®istrationNo={$registrationNo}'\n</script>\n\n";