<?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) . "");
<?php
include "../../../myDatabase1.php";
$headingNo = $_GET['headingNo'];
$username = $_GET['username'];
$ro = new database1();
$ro->deleteNow("radioHeading", "headingNo", $headingNo);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Results/Radiology/radioHeadingMasterfile.php?username={$username}");
//$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);
}
$ro->gotoPage("http://" . $ro->getMyUrl() . "/Department/patientDepartmentProfile.php?registrationNo={$registrationNo}&module={$module}&month={$month}&day={$day}&year={$year}&fromTime_hour={$fromTime_hour}&fromTime_minutes={$fromTime_minutes}&fromTime_seconds={$fromTime_seconds}&toTime_hour={$toTime_hour}&toTime_minutes={$toTime_minutes}&toTime_seconds={$toTime_seconds}&username={$username}");
<?php
include "../../../myDatabase1.php";
$reportNo = $_GET['reportNo'];
$username = $_GET['username'];
$ro = new database1();
$ro->deleteNow("radioReportList", "reportNo", $reportNo);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Results/Radiology/radioReportTemplateMasterfile.php?username={$username}");
$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"));
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "timeUnregistered", $ro->getSynapseTime());
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "mgh", "Synapse System");
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "mgh_date", date("Y-m-d"));
$ro->gotoPage("/COCONUT/patientProfile/individualPayment/checkBalance.php?registrationNo={$registrationNo}&username={$username}");
} else {
$ro->gotoPage("/COCONUT/patientProfile/individualPayment/checkBalance.php?registrationNo={$registrationNo}&username={$username}");
}
} 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";
$hospitalName = $_GET['hospitalName'];
$hospitalAddress = $_GET['hospitalAddress'];
$username = $_GET['username'];
$ro = new database1();
$ro->radioHeading($hospitalName, $hospitalAddress);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Results/Radiology/addHospital.php?username={$username}");
<?php
include "../../../myDatabase1.php";
$registrationNo = $_GET['registrationNo'];
$countz = count($registrationNo);
$month = $_GET['month'];
$day = $_GET['day'];
$year = $_GET['year'];
$ro = new database1();
for ($x = 0; $x < $countz; $x++) {
$ro->editNow("registrationDetails", "registrationNo", $registrationNo[$x], "mgh", "");
$ro->editNow("registrationDetails", "registrationNo", $registrationNo[$x], "mgh_date", "");
}
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/MGH/showMGH.php?month={$month}&day={$day}&year={$year}&username=");
<?php
include "../../../myDatabase1.php";
$title = $_GET['title'];
$template = $_GET['template'];
$username = $_GET['username'];
$ro = new database1();
$ro->addRadioTemplate($title, $template);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Results/Radiology/addRadioTemplate.php?username={$username}");