$month = $_GET['month']; $day = $_GET['day']; $year = $_GET['year']; $fromTime_hour = $_GET['fromTime_hour']; $fromTime_minutes = $_GET['fromTime_minutes']; $fromTime_seconds = $_GET['fromTime_seconds']; $toTime_hour = $_GET['toTime_hour']; $toTime_minutes = $_GET['toTime_minutes']; $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");
<?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!!";
} else { } } } } } } } } } } } } $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); */
<?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);
$totalDays = $dateOut[1] + 31 - $dateIn[1]; } else { if ($dateIn[0] == "Nov") { $totalDays = $dateOut[1] + 30 - $dateIn[1]; } else { } } } } } } } } } } } } } //echo "Total Days ".$totalDays; $totalPrice = $ro->doubleSelectNow("patientCharges", "sellingPrice", "registrationNo", $registrationNo, "description", $ro->getRegistrationDetails_room()) * $totalDays; $totalPHIC = 500 * $totalDays; $totalExcess = $totalPrice - $totalPHIC; //echo "<br>Total Price ".$totalPrice; //echo "<br>Total PhilHealth ".$totalPHIC; //echo "<br>Total Excess ".($totalPrice - $totalPHIC); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "description", $ro->getRegistrationDetails_room(), "quantity", $totalDays); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "description", $ro->getRegistrationDetails_room(), "total", $totalPrice); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "description", $ro->getRegistrationDetails_room(), "phic", $totalPHIC); $ro->doubleEditNow("patientCharges", "registrationNo", $registrationNo, "description", $ro->getRegistrationDetails_room(), "cashUnpaid", $totalExcess); //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->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/SOAoption/summary.php?registrationNo={$registrationNo}&username={$username}");
<?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']; $itemNo = $_GET['itemNo']; $radioReport = $_GET['radioReport']; $ro = new database1(); $ro->doubleEditNow("radioSavedReport", "registrationNo", $registrationNo, "itemNo", $itemNo, "radioReport", $radioReport); $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Reports/radiologyReport/radioReport_output_doctor.php?registrationNo={$registrationNo}&itemNo={$itemNo}&description=" . $ro->selectNow("patientCharges", "description", "itemNo", $itemNo));