<?php
include "../../myDatabase.php";
$comment = $_GET['comment'];
$username = $_GET['username'];
$ro = new database();
if ($comment != "") {
$ro->addNewNote("", "guest", $username, $comment, date("M d, Y"), $ro->getSynapseTime());
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Homepage/homepage.php");
} else {
echo "\n<script type='text/javascript'>\nalert('Pls put a message');\nhistory.back();\n</script>\n\n";
}
<?php
include "../../myDatabase.php";
$ro = new database();
$ro->gotoPage("http://www.sourcecodester.com/php/4169/synapse-hospital-system.html");
//$ro->gotoPage("http://www.youtube.com/watch?v=U7ZzjCXEwTU");
<?php
include "../../myDatabase.php";
$verificationNo = $_GET['verificationNo'];
$requestingDepartment = $_GET['requestingDepartment'];
$requestingBranch = $_GET['requestingBranch'];
$requestTo_department = $_GET['requestTo_department'];
$requestTo_branch = $_GET['requestTo_branch'];
$username = $_GET['username'];
$ro = new database();
$ro->editNow("inventoryManager", "verificationNo", $verificationNo, "status", "DELETED_" . $username);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/availableMedicine/showRequestList.php?requestingDepartment={$requestingDepartment}&requestingBranch={$requestingBranch}&requestTo_department={$requestTo_department}&requestTo_branch={$requestTo_branch}&username={$username}");
<?php
include "../../myDatabase.php";
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$chargesCode = $_GET['chargesCode'];
$reqdate = $_GET['reqdate'];
$itemNo = $_GET['itemNo'];
$ro = new database();
//ito ung magssabi kung saang result page dapat mappunta based sa subcategory ng charges
if ($ro->selectNow("availableCharges", "subCategory", "chargesCode", $chargesCode) == "hematology") {
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/core2_lab/addHematology.php?registrationNo={$registrationNo}&username={$username}&itemNo={$itemNo}");
} else {
if ($ro->selectNow("availableCharges", "subCategory", "chargesCode", $chargesCode) == "clinchem") {
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Laboratory/clinChemData.php?registrationNo={$registrationNo}&itemNo={$itemNo}");
} else {
if ($ro->selectNow("availableCharges", "subCategory", "chargesCode", $chargesCode) == "urinalysis") {
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Laboratory/urinalysis.php?registrationNo={$registrationNo}&itemNo={$itemNo}");
} else {
if ($ro->selectNow("availableCharges", "subCategory", "chargesCode", $chargesCode) == "serology") {
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Laboratory/serologyData.php?registrationNo={$registrationNo}&itemNo={$itemNo}");
} else {
if ($ro->selectNow("availableCharges", "subCategory", "chargesCode", $chargesCode) == "fecalysis") {
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Laboratory/fecalysisData.php?registrationNo={$registrationNo}&itemNo={$itemNo}");
} else {
}
}
}
}
}
$phicMed_excess = $_GET['phicMed_excess'];
$ro = new database();
$ro->getPatientProfile($registrationNo);
$ro->getPHIClimit_setter($casetype);
if ($phicMed_excess > 0) {
$ro->getHighestCharges_itemNo("MEDICINE", $registrationNo, $phicMed_excess);
//phic meds n pnkmataas n phic Covered
$lesz = $ro->highestCharges_getPHIC() - $phicMed_excess;
//bbwsan ung may pnkmataas n cashUnpaid
//echo $phicMed_excess;
//PRA SA MEDS
$ro->editNow("patientCharges", "itemNo", $ro->highestCharges_getItemNo(), "phic", $lesz);
//bbwsan ung cashUnpa
$ro->editNow("patientCharges", "itemNo", $ro->highestCharges_getItemNo(), "cashUnpaid", $phicMed_excess);
}
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/phicLimit/limitMagic1.php?registrationNo={$registrationNo}&casetype={$casetype}&phicSup_excess={$phicSup_excess}");
/*
else if($phicSup_excess > 0) {
$newPHIC = $phicSup_excess - $ro->getPHIClimit_supplies();
$ro->editNow("patientCharges","itemNo",$ro->getHighestCharges_itemNo("SUPPLIES","phic",$registrationNo),"phic",$ro->getPHIClimit_supplies());
$newCASH_sup = $ro->getTotal("cashUnpaid","",$registrationNo) + $phicSup_excess;
$ro->editNow("patientCharges","itemNo",$ro->getHighestCharges_itemNo("SUPPLIES","phic",$registrationNo),"cashUnpaid",$newCASH_sup);
}else {
}
if($phicSup_excess > 0) {
$newPHIC = $phicSup_excess - $ro->getPHIClimit_supplies();
$ro->editNow("patientCharges","itemNo",$ro->getHighestCharges_itemNo("SUPPLIES","phic",$registrationNo),"phic",$ro->getPHIClimit_supplies());
$newCASH_sup = $ro->getTotal("cashUnpaid","",$registrationNo) + $phicSup_excess;
$ro->editNow("patientCharges","itemNo",$ro->getHighestCharges_itemNo("SUPPLIES","phic",$registrationNo),"cashUnpaid",$newCASH_sup);
}
*/
<?php
include "../../../myDatabase.php";
$unlockNo = $_GET['unlockNo'];
$username = $_GET['username'];
$registrationNo = $_GET['registrationNo'];
$ro = new database();
$ro->editNow("pxUnlocked", "unlockNo", $unlockNo, "timeClosed", $ro->getSynapseTime());
$ro->editNow("pxUnlocked", "unlockNo", $unlockNo, "dateClosed", date("Y-m-d"));
$ro->editNow("pxUnlocked", "unlockNo", $unlockNo, "status", "Closed");
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/currentPatient/locked/showLocked.php?registrationNo={$registrationNo}&username={$username}");
$sellingPrice = $_GET['sellingPrice'];
$discount = $_GET['discount'];
$timeCharge = $_GET['timeCharge'];
$room = $_GET['room'];
$chargeBy = $_GET['chargeBy'];
$service = $_GET['service'];
$title = $_GET['title'];
$paidVia = $_GET['paidVia'];
$cashPaid = $_GET['cashPaid'];
$batchNo = $_GET['batchNo'];
$username = $_GET['username'];
$inventoryFrom = $_GET['inventoryFrom'];
$ro = new database();
echo "\n<style type='text/css'>\n.qty {\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight:25px;\n\twidth: 100px;\n\tpadding:4px 4px 4px 10px;\n}\n\n</style>\n\n";
if ($ro->selectNow("availableCharges", "subCategory", "chargesCode", $chargesCode) == "ambulance") {
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/availableMisc/ambulanceQty.php?status={$status}®istrationNo={$registrationNo}&chargesCode={$chargesCode}&description={$description}&sellingPrice={$sellingPrice}&discount={$discount}&timeCharge={$timeCharge}&room={$room}&chargeBy={$chargeBy}&service={$service}&title={$title}&paidVia={$paidVia}&cashPaid={$cashPaid}&batchNo={$batchNo}&username={$username}&inventoryFrom={$inventoryFrom}");
} else {
//addCharges.php
echo "<br><Br><Br>";
echo "<form method='get' action='http://" . $ro->getMyUrl() . "/COCONUT/availableCharges/addCharges.php'>";
echo "<center><div style='border:1px solid #000000; width:400px; height:100px;\t'>";
echo "<br><table border=0 cellpadding=0 cellspacing=0>";
echo "<tr>";
echo "<td><font size=4>Quantity:</font></td>";
echo "<td><input type=text class='qty' name='quantity' value='1'></td>";
echo "</tr>";
echo "<tr><td> </td></tr>";
echo "<tr>";
echo "<td><input type='button' class='button' value=' Back '\nonClick='javascript: history.go(-1)' style='border:1px solid #000000; background-color:transparent;'></td>";
echo "<td> </td>";
echo "<td><input type=submit value='Proceed' style='border:1px solid #000000; background-color:transparent; color:red; height:20px;'></td>";
<?php
include "../../../myDatabase.php";
$stockCardNo = $_GET['stockCardNo'];
$description = $_GET['description'];
$genericName = $_GET['genericName'];
$startLetter = $_GET['startLetter'];
$ro = new database();
$ro->editNow("inventoryStockCard", "stockCardNo", $stockCardNo, "description", $description);
$ro->editNow("inventoryStockCard", "stockCardNo", $stockCardNo, "genericName", $genericName);
$ro->editNow("inventory", "stockCardNo", $stockCardNo, "description", $description);
$ro->editNow("inventory", "stockCardNo", $stockCardNo, "genericName", $genericName);
$ro->editNow("patientCharges", "stockCardNo", $stockCardNo, "description", $description);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/inventory/stockCard/stockCardList.php?startLetter={$startLetter}");
<?php
include "../../myDatabase.php";
$itemNo = $_GET['itemNo'];
$username = $_GET['username'];
$ro = new database();
$ro->deleteNow("forDeletion", "itemNo", $itemNo);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/ADMIN/requestDelete_update.php?username={$username}");
include "../myDatabase.php";
$inventoryCode = $_POST['inventoryCode'];
$refNo = $_POST['refNo'];
$description = $_POST['description'];
$generic = $_POST['generic'];
$unitcost = $_POST['unitcost'];
$qty = $_POST['qty'];
$fgqty = $_POST['fgqty'];
$unit = $_POST['unit'];
$sino = $_POST['sino'];
$page = $_POST['page'];
$username = $_POST['username'];
$ro = new database();
$ro->editNow("salesInvoiceItems", "refNo", $refNo, "description", $description);
$ro->editNow("inventory", "inventoryCode", $inventoryCode, "description", $description);
$ro->editNow("inventory", "inventoryCode", $inventoryCode, "genericName", $generic);
$ro->editNow("salesInvoiceItems", "refNo", $refNo, "unitPrice", $unitcost);
if ($ro->selectNow("inventory", "inventoryType", "inventoryCode", $inventoryCode) == "medicine") {
$ro->editNow("inventory", "inventoryCode", $inventoryCode, "unitcost", $unitcost);
} else {
$ro->editNow("invnetory", "inventoryCode", $inventoryCode, "suppliesUNITCOST", $unitcost);
}
$ro->editNow("salesInvoiceItems", "refNo", $refNo, "quantity", $qty);
$ro->editNow("salesInvoiceItems", "refNo", $refNo, "fgquantity", $fgqty);
$ro->editNow("inventory", "inventoryCode", $inventoryCode, "quantity", $qty);
$ro->editNow("inventory", "inventoryCode", $inventoryCode, "fgQuantity", $fgqty);
$ro->editNow("salesInvoiceItems", "refNo", $refNo, "unit", $unit);
$ro->editNow("inventory", "inventoryCode", $inventoryCode, "preparation", $unit);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/Purchasing/CreatedReceivingReport.php?username={$username}&sino={$sino}&page={$page}&username={$username}");
$day2 = $_GET['day2'];
$year2 = $_GET['year2'];
$timeCharge2 = $_GET['timeCharge2'];
$chargeBy2 = $_GET['chargeBy2'];
$service2 = $_GET['service2'];
$title2 = $_GET['title2'];
$paidVia2 = $_GET['paidVia2'];
$cashPaid2 = $_GET['cashPaid2'];
$batchNo2 = $_GET['batchNo2'];
$username2 = $_GET['username2'];
$discount2 = $_GET['discount2'];
$inventoryFrom2 = $_GET['inventoryFrom2'];
$room2 = $_GET['room2'];
$paycash2 = $_GET['paycash2'];
$remarks2 = $_GET['remarks2'];
$ro = new database();
if ($classification == "noInventory") {
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/availableMedicine/addMe.php?status={$status}®istrationNo={$registrationNo}&chargesCode={$chargesCode}&description={$description}&sellingPrice={$sellingPrice}&discount={$discount}&timeCharge={$timeCharge}&room={$room}&chargeBy={$chargeBy}&service={$service}&title={$title}&paidVia={$paidVia}&cashPaid={$cashPaid}&batchNo={$batchNo}&username={$username}&inventoryFrom={$inventoryFrom}&paycash={$paycash}&remarks=&quantity=1&month=" . date("m") . "&day=" . date("d") . "&year=" . date("Y") . "");
} else {
if ($chargesCode == '' && $description == '') {
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/availableMedicine/addCharges_cash.php?status={$status2}&quantity={$qty2}®istrationNo={$registrationNo2}&chargesCode={$chargesCode2}&description={$description2}&sellingPrice={$sellingPrice2}&month={$month2}&day={$day2}&year={$year2}&timeCharge={$timeCharge2}&chargeBy={$chargeBy2}&service={$service2}&title={$title2}&paidVia={$paidVia2}&cashPaid={$cashPaid2}&batchNo={$batchNo2}&username={$username2}&discount={$discount2}&inventoryFrom={$inventoryFrom2}&room={$room2}&paycash={$paycash2}&remarks={$remarks2}");
} else {
if ($ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode) < 1) {
$ro->getBack("Sorry, Out of Stock");
}
echo "\n<style type='text/css'>\n.qty {\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight:25px;\n\twidth: 100px;\n\tpadding:4px 4px 4px 10px;\n}\n\n</style>\n\n";
//addCharges.php
echo "<br><Br><Br>";
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/availableCharges/addChargesSyringe.php?quantity=1&status={$status}®istrationNo={$registrationNo}&chargesCode={$chargesCode}&description={$description}&sellingPrice={$sellingPrice}&timeCharge={$timeCharge}&chargeBy={$chargeBy}&service={$service}&title={$title}&paidVia={$paidVia}&cashPaid={$cashPaid}&batchNo={$batchNo}&username={$username}&discount={$discount}&inventoryFrom={$inventoryFrom}&room={$room}&paycash={$paycash}&remarks={$remarks}&status2={$status2}&qty2={$qty2}®istrationNo2={$registrationNo2}&chargesCode2={$chargesCode2}&description2={$description2}&sellingPrice2={$sellingPrice2}&month2={$month2}&day2={$day2}&year2={$year2}&timeCharge2={$timeCharge2}&chargeBy2={$chargeBy2}&service2={$service2}&title2={$title2}&paidVia2={$paidVia2}&cashPaid2={$cashPaid2}&batchNo2={$batchNo2}&username2={$username2}&discount2={$discount2}&inventoryFrom2={$inventoryFrom2}&room2={$room2}&paycash2={$paycash2}&remarks2={$remarks2}");
}
}
<?php
include "../../myDatabase.php";
$inventoryCode = $_POST['inventoryCode'];
$markup = $_POST['markup'];
$ro = new database();
for ($a = 0, $b = 0; $a < count($inventoryCode), $b < count($markup); $a++, $b++) {
$ro->editNow("inventory", "inventoryCode", $inventoryCode[$a], "unitcost", $markup[$b]);
}
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Reports/markupPrice.php");
<?php
include "../../myDatabase.php";
$casetype = $_GET['casetype'];
$medicine = $_GET['medicine'];
$supplies = $_GET['supplies'];
$room = $_GET['room'];
$pf = $_GET['pf'];
$suppliesOnly = $_GET['suppliesOnly'];
$username = $_GET['username'];
$ro = new database();
$ro->editNow("phicLimit", "casetype", $casetype, "medicine", $medicine);
$ro->editNow("phicLimit", "casetype", $casetype, "supplies", $supplies);
$ro->editNow("phicLimit", "casetype", $casetype, "room", $room);
$ro->editNow("phicLimit", "casetype", $casetype, "pf", $pf);
$ro->editNow("phicLimit", "casetype", $casetype, "suppliesOnly", $suppliesOnly);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/casetype/showCasetype.php?username={$username}");
<?php
include "../../../myDatabase.php";
$itemNo = $_GET['itemNo'];
$batchNo = $_GET['batchNo'];
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database();
if ($ro->selectNow("inventory", "autoDispense", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)) == "yes") {
echo "<script type='text/javascript'>alert('You cannot delete that meds/sup here its already dispensed pls return instead in Medicine menu');</script>";
} else {
//$ro->deleteNow("patientCharges","itemNo",$itemNo);
$ro->editNow("patientCharges", "itemNo", $itemNo, "status", "DELETED_" . $username);
}
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/android/mobileECART/showCart_update.php?registrationNo={$registrationNo}&batchNo={$batchNo}&username={$username}");
<?php
include "../../../myDatabase.php";
$registrationNo = $_GET['registrationNo'];
$advised = $_GET['advised'];
$followUp = $_GET['followUp'];
$ro = new database();
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "advised", $advised);
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "followUp", $followUp);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/android/doctor/newPlan.php?registrationNo={$registrationNo}");
<?php
include "../../../myDatabase.php";
$type = $_GET['type'];
$username = $_GET['username'];
$ro = new database();
if ($type == "OPD") {
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Reports/doctorReport/selectShift_ADMIN.php?username={$username}");
} else {
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Reports/doctorReport/shift_ipd.php?username={$username}");
}
<?php
include "../../myDatabase.php";
$sssID = $_POST['sssID'];
$range1 = $_POST['range1'];
$range2 = $_POST['range2'];
$monthlySalaryCredit = $_POST['monthlySalaryCredit'];
$ER = $_POST['ER'];
$EE = $_POST['EE'];
$total = $_POST['total'];
$EC_ER = $_POST['EC_ER'];
$username = $_POST['username'];
$ro = new database();
$ro->editNow("contribution_sss", "sssID", $sssID, "range1", $range1);
$ro->editNow("contribution_sss", "sssID", $sssID, "range2", $range2);
$ro->editNow("contribution_sss", "sssID", $sssID, "monthlySalaryCredit", $monthlySalaryCredit);
$ro->editNow("contribution_sss", "sssID", $sssID, "ER", $ER);
$ro->editNow("contribution_sss", "sssID", $sssID, "EE", $EE);
$ro->editNow("contribution_sss", "sssID", $sssID, "total", $total);
$ro->editNow("contribution_sss", "sssID", $sssID, "EC_ER", $EC_ER);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/payroll/sssTable.php?username={$username}");
<?php
include "../../myDatabase.php";
$taxNo = $_POST['taxNo'];
$username = $_POST['username'];
$monthType = $_POST['monthType'];
$status = $_POST['status'];
$amount = $_POST['amount'];
$exemption = $_POST['exemption'];
$statusBracket = $_POST['statusBracket'];
$ro = new database();
$ro->editNow("contribution_withholdingTax", "taxNo", $taxNo, "monthType", $monthType);
$ro->editNow("contribution_withholdingTax", "taxNo", $taxNo, "status", $status);
$ro->editNow("contribution_withholdingTax", "taxNo", $taxNo, "amount", $amount);
$ro->editNow("contribution_withholdingTax", "taxNo", $taxNo, "exemption", $exemption);
$ro->editNow("contribution_withholdingTax", "taxNo", $taxNo, "statusBracket", $statusBracket);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/payroll/withholdingTaxTable.php?username={$username}");
<?php
include "../../myDatabase.php";
$function = $_GET['function'];
$description = $_GET['description'];
$value = $_GET['val'];
$id = $_GET['id'];
$username = $_GET['username'];
$ro = new database();
$ro->editNow("reportHeading", "headingNo", $id, "description", $description);
$ro->editNow("reportHeading", "headingNo", $id, "information", $value);
$ro->gotoPage("misc.php?username={$username}");
<?php
include "../../myDatabase.php";
$type = $_GET['type'];
$reportName = $_GET['reportName'];
$ro = new database();
if ($type == "OPD") {
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Reports/hmoSOA.php?reportName={$reportName}");
} else {
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Reports/hmoSOA_ipd.php?reportName={$reportName}");
}
include "../../myDatabase.php";
session_start();
$username = $_GET['username'];
$registrationNo = $_GET['registrationNo'];
$registrationNo = $_SESSION['registrationNo'];
//$module = $_SESSION['module'];
$_SESSION['username'] = $username;
//$_SESSION['registrationNo'] = $registrationNo;
$ro = new database();
$ro->getPatientProfile($_GET['registrationNo']);
if (!isset($_SESSION['username']) || !isset($_SESSION['registrationNo'])) {
header("Location:/COCONUT/patientProfile/unknownUser/verifyUser.php?registrationNo={$_GET['registrationNo']} ");
die;
}
if ($_GET['username'] == "") {
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/unknownUser/verifyUser.php?registrationNo={$registrationNo}");
}
?>
<link rel="stylesheet" type="text/css" href="http://<?php
echo $ro->getMyUrl();
?>
/COCONUT/flow/rickyCSS1.css" />
<script type="text/javascript" src="http://<?php
echo $ro->getMyUrl();
?>
/jquery.js"></script>
<script type="text/javascript" src="http://<?php
echo $ro->getMyUrl();
?>
/jquery.autocomplete.js"></script>
<?php
include "../../../myDatabase.php";
$floor = $_GET['floor'];
$branch = $_GET['branch'];
$floorNo = $_GET['floorNo'];
$username = $_GET['username'];
$show = $_GET['show'];
$desc = $_GET['desc'];
$ro = new database();
$ro->EditNow("floor", "floorNo", $floorNo, "description", $floor);
$ro->EditNow("floor", "floorNo", $floorNo, "branch", $branch);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/masterfile/floor.php?username={$username}&desc={$desc}&show={$show}");
<?php
include "../../../myDatabase.php";
$planNo = $_POST['planNo'];
$registrationNo = $_POST['registrationNo'];
$ro = new database();
$ro->deleteNow("doctorsPlan", "planNo", $planNo);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/android/doctor/planPreview_update.php?registrationNo={$registrationNo}");
<?php
include "../../myDatabase3.php";
$date = $_GET['date'];
$date1 = $_GET['date1'];
$type = $_GET['type'];
$title = $_GET['title'];
$datePaid = $_GET['datePaid'];
$registrationNo = $_GET['registrationNo'];
$ro = new database();
//echo "Start date and End Date is not match";
$dateDischarged = $ro->doubleSelectNow("patientCharges", "datePaid", "registrationNo", $registrationNo, "status", "PAID");
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "dateUnregistered", $dateDischarged);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/billing/patientAccount.php?date={$date}&date1={$date1}&type={$type}&title={$title}");
<?php
include "../../myDatabase.php";
$radioSavedNo = $_GET['radioSavedNo'];
$username = $_GET['username'];
$module = $_GET['module'];
$doctorCode = $_GET['doctorCode'];
$ro = new database();
$ro->editNow("radioSavedReport", "radioSavedNo", $radioSavedNo, "approved", "yes");
$ro->editNow("radioSavedReport", "radioSavedNo", $radioSavedNo, "approvedDate", date("Y-m-d"));
$ro->editNow("radioSavedReport", "radioSavedNo", $radioSavedNo, "approvedTime", $ro->getSynapseTime());
$ro->editNow("radioSavedReport", "radioSavedNo", $radioSavedNo, "approvedBy", $username);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/radiology/forApproval.php?username={$username}&module={$module}&doctorCode={$doctorCode}");
<?php
include "../../myDatabase.php";
$payrollNo = $_POST['payrollNo'];
$username = $_POST['username'];
$empID = $_POST['empID'];
$ro = new database();
$ro->editNow("employeePayroll", "payrollNo", $payrollNo, "status", "DELETED_" . $username);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/payroll/employeeDetails.php?employeeID={$empID}&username={$username}");
<?php
include "../../../myDatabase.php";
$date = $_GET['date'];
$shift = $_GET['shift'];
$attrNo = $_GET['attrNo'];
$ro = new database();
$dateIndividual = preg_split("/\\-/", $date);
$year = $dateIndividual[0];
$month = $dateIndividual[1];
$day = $dateIndividual[2];
$ro->deleteNow("dailyCashiersAttr", "attrNo", $attrNo);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Cashier/cashierReport/dailyCashiersReport.php?month={$month}&day={$day}&year={$year}&shift={$shift}");
<?php
include "../../../myDatabase.php";
$itemNo = $_GET['itemNo'];
$batchNo = $_GET['batchNo'];
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database();
if ($ro->selectNow("inventory", "inventoryLocation", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)) != "PHARMACY") {
//echo "<script type='text/javascript'>alert('You cannot delete that meds/sup here its already dispensed pls return instead in Medicine menu');</script>";
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/itemDepartment.php?itemNo={$itemNo}&username={$username}&return=ecart");
} else {
//$ro->deleteNow("patientCharges","itemNo",$itemNo);
$ro->editNow("patientCharges", "itemNo", $itemNo, "status", "DELETED_" . $username . "[" . date("Y-m-d") . "@" . $ro->getSynapseTime() . "]");
}
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/ECART/showCart_update.php?registrationNo={$registrationNo}&batchNo={$batchNo}&username={$username}");
$case = $_GET['case'];
$ro = new database();
$ro->getPHIClimit_setter($casetype);
echo $cash - $ro->getPHIClimit_room();
echo "<br><br>";
$itemz = preg_split("/\\_/", $ro->getMaximumTotal_any($registrationNo, "Room And Board"));
echo "Price:" . $itemz[0];
echo "<br><br>item no." . $itemz[1];
$ro->getPatientChargesToEdit($itemz[1]);
if ($itemz[0] >= $ro->getPHIClimit_room()) {
$newCash = $ro->patientCharges_cashUnpaid() - ($ro->getPHIClimit_room() - $ro->getTotal("phic", "Room And Board", $registrationNo));
if ($newCash > 1) {
$ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", $newCash);
$ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $ro->getPHIClimit_room() - $ro->getTotal("phic", "Room And Board", $registrationNo));
} else {
$ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", "0");
$ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $ro->patientCharges_cashUnpaid());
}
} else {
$ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", "0");
$ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $ro->patientCharges_cashUnpaid());
}
if ($ro->getTotal("phic", "Room And Board", $registrationNo) != $ro->getPHIClimit_room()) {
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/phicLimit/phicFuller_room.php?registrationNo={$registrationNo}&casetype={$casetype}&cash=&case={$case}");
} else {
if ($ro->getMaximumTotal_any_checker($registrationNo, "Room And Board") == 0) {
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/phicLimit/phicFuller_PF.php?registrationNo={$registrationNo}&casetype={$casetype}&cash=&case={$case}");
} else {
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/phicLimit/phicFuller_PF.php?registrationNo={$registrationNo}&casetype={$casetype}&cash=&case={$case}");
}
}
<?php
include "../../../myDatabase.php";
$date = $_GET['date'];
$date1 = $_GET['date1'];
$registrationNo = $_GET['registrationNo'];
$datePaid = $_GET['datePaid'];
$ro = new database();
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "dateUnregistered", $datePaid);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/Reports/doctorReport/transactionSummary_pf.php?date={$date}&date1={$date1}");
