<?php
include "../../myDatabase.php";
$ro = new database();
$ro->deleteNow("ipdCensus", "id", $_POST['id']);
//header("Location: addToCensus.php?registrationNo=$_GET[registrationNo]");
<?php
include "../../myDatabase.php";
$verificationNo = $_POST['verificationNo'];
$ro = new database();
$ro->deleteNow("inventoryManager", "verificationNo", $verificationNo);
<?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";
$username = $_GET['username'];
$supplierName = $_GET['supplierName'];
$supplierCode = $_GET['supplierCode'];
$ro = new database();
$ro->deleteNow("supplier", "supplierCode", $supplierCode);
echo "\n<script type='text/javascript'>\nalert('{$supplierName} is now deleted');\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/masterfile/supplier.php?username={$username}';\n</script>\n\n";
<?php
include "../../myDatabase.php";
$valuesNo = $_GET['valuesNo'];
$labNo = $_GET['labNo'];
$registrationNo = $_GET['registrationNo'];
$itemNo = $_GET['itemNo'];
$description = $_GET['description'];
$pathologist = $_GET['pathologist'];
$medTech = $_GET['medTech'];
$receivedMonth = $_GET['receivedMonth'];
$receivedDay = $_GET['receivedDay'];
$receivedYear = $_GET['receivedYear'];
$releasedMonth = $_GET['releasedMonth'];
$releasedDay = $_GET['releasedDay'];
$releasedYear = $_GET['releasedYear'];
$branch = $_GET['branch'];
$ro = new database();
$ro->deleteNow("laboratoryResultsValue", "valuesNo", $valuesNo);
echo "\n<script type='text/javascript'>\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/Results/editResultValue.php?labNoz={$labNo}®istrationNo={$registrationNo}&itemNo={$itemNo}&description={$description}&pathologist={$pathologist}&medTech={$medTech}&receivedMonth={$receivedMonth}&receivedDay={$receivedDay}&receivedYear={$receivedYear}&releasedMonth={$releasedMonth}&releasedDay={$releasedDay}&releasedYear={$releasedYear}&branch={$branch}'\n</script>\n\n";
<?php
include "../../../myDatabase.php";
$username = $_GET['username'];
$companyNo = $_GET['companyNo'];
$companyName = $_GET['companyName'];
$ro = new database();
$ro->deleteNow("Company", "companyNo", $companyNo);
echo "\n<script type='text/javascript'>\nalert('{$companyName} is now deleted');\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/masterfile/company.php?username={$username}';\n</script>\n\n";
<?php
include "../../../myDatabase.php";
$icdNo = $_GET['icdNo'];
$icdCode = $_GET['icdCode'];
$ro = new database();
$ro->deleteNow("patientICD", "icdNo", $icdNo);
echo "\n\n<script type='text/javascript'>\nalert('{$icdCode} is now Deleted');\n</script>\n\n";
<?php
include "../../../myDatabase.php";
$username = $_GET['username'];
$serviceNo = $_GET['serviceNo'];
$serviceName = $_GET['serviceName'];
$specialization = $_GET['specialization'];
$ro = new database();
$ro->deleteNow("DoctorService", "serviceNo", $serviceNo);
echo "\n\n<script type='text/javascript'>\nalert('The {$serviceName} in {$specialization} is now deleted');\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/masterfile/doctorService.php?username={$username}';\n</script>\n\n";
<?php
include "../../myDatabase.php";
$labNo = $_GET['labNo'];
$description = $_GET['description'];
$ro = new database();
$ro->deleteNow("laboratoryResults", "labNo", $labNo);
$ro->deleteNow("laboratoryResultsValue", "labNo", $labNo);
echo "\n\n<script type='text/javascript'>\nalert('{$description} Results is now Deleted');\n</script>\n\n";
<?php
include "../../myDatabase.php";
$noteNo = $_GET['noteNo'];
$noteType = $_GET['noteType'];
$registrationNo = $_GET['registrationNo'];
$ro = new database();
$ro->deleteNow("patientNotes", "noteNo", $noteNo);
echo "\n\n<script type='text/javascript'>\nalert('Successfully Deleted');\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/patientNotes/viewNote.php?noteType={$noteType}®istrationNo={$registrationNo}&username=';\n</script>\n\n";
<?php
include "../../../myDatabase.php";
$patientNo = $_GET['patientNo'];
$lastName = $_GET['lastName'];
$firstName = $_GET['firstName'];
$middleName = $_GET['middleName'];
$username = $_GET['username'];
$show = $_GET['show'];
$desc = $_GET['desc'];
$ro = new database();
$ro->deleteNow("patientRecord", "patientNo", $patientNo);
$ro->deleteNow("registrationDetails", "patientNo", $patientNo);
echo "\n<script type='text/javascript'>\nalert('All Records of {$lastName} {$firstName} {$middleName} is now totally deleted');\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/masterfile/patientRecord.php?username={$username}&show={$show}&desc={$desc}';\n</script>\n\n";
<?php
include "../../../myDatabase.php";
$reconcileNo = $_GET['reconcileNo'];
$registrationNo = $_GET['registrationNo'];
$ro = new database();
$ro->deleteNow("phicReconcile", "reconcileNo", $reconcileNo);
echo "\n<script language='javascript' type='text/javascript'>\nfunction closeWindow() {\nwindow.open('','_parent','');\nwindow.close();\n}\n</script> \n";
echo "<Br><Br><Br>";
echo "<a href='javascript:closeWindow();' style='text-decoration:none; color:red;'>CLOSE</a>";
<?php
include "../../myDatabase1.php";
$packageNo = $_GET['packageNo'];
$packageName = $_GET['packageName'];
$ro = new database();
$ro->deleteNow("hospitalPackage", "packageNo", $packageNo);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/hospitalPackage/showAddedPackage_update.php?packageName={$packageName}");
<?php
include "../../myDatabase.php";
$radioNo = $_GET['radioNo'];
$description = $_GET['description'];
$ro = new database();
$ro->deleteNow("radiologyResults", "radioNo", $radioNo);
echo "\n\n<script type='text/javascript'>\nalert('{$description} Results is now Deleted');\n</script>\n\n";
<?php
include "../../../myDatabase.php";
$limitNo = $_GET['limitNo'];
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database();
$ro->deleteNow("patientCreditLimit", "limitNo", $limitNo);
echo "<script type='text/javascript' >";
echo "window.location='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/creditLimit/viewCreditLimit.php?username={$username}®istrationNo={$registrationNo}' ";
echo "</script>";
<?php
include "../../../myDatabase.php";
$username = $_GET['username'];
$icdTrackNo = $_GET['icdTrackNo'];
$diagnosis = $_GET['diagnosis'];
$icdCode = $_GET['icdCode'];
$show = $_GET['show'];
$ro = new database();
$ro->deleteNow("availableICD", "icdTrackNo", $icdTrackNo);
echo "\n\n<script type='text/javascript'>\nalert('The ICD Code {$icdCode} with a Diagnosis of {$diagnosis} is now deleted');\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/masterfile/icdCode.php?username={$username}&show={$show}&desc=&protoType=maintenance®istrationNo=';\n</script>\n\n";
<?php
include "../../../myDatabase.php";
$roomNo = $_GET['roomNo'];
$description = $_GET['description'];
$type = $_GET['type'];
$rate = $_GET['rate'];
$username = $_GET['username'];
$show = $_GET['show'];
$desc = $_GET['desc'];
$ro = new database();
$ro->deleteNow("room", "roomNo", $roomNo);
echo "\n\n<script type='text/javascript'>\nalert('The {$description} is now deleted');\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/masterfile/viewRoom.php?username={$username}&show={$show}&desc=';\n</script>\n\n";
<?php
include "../../../myDatabase.php";
$floorNo = $_GET['floorNo'];
$description = $_GET['description'];
$branch = $_GET['branch'];
$username = $_GET['username'];
$show = $_GET['show'];
$desc = $_GET['desc'];
$ro = new database();
$ro->deleteNow("floor", "floorNo", $floorNo);
echo "\n\n<script type='text/javascript'>\nalert('{$description} in {$branch} Branch is now deleted');\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/masterfile/floor.php?username={$username}&show={$show}&desc={$desc}';\n</script>\n\n";
<?php
include "../../../myDatabase.php";
$username = $_GET['username'];
$doctorCode = $_GET['doctorCode'];
$name = $_GET['name'];
$show = $_GET['show'];
$ro = new database();
$ro->deleteNow("Doctors", "doctorCode", $doctorCode);
echo "\n\n<script type='text/javascript'>\nalert('{$name} is now deleted in the list of Doctors');\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/masterfile/doctor.php?username={$username}&show={$show}';\n</script>\n\n";
<?php
include "../../myDatabase.php";
$preparationNo = $_POST['preparationNo'];
$ro = new database();
$ro->deleteNow("inventoryPreparation", "preparationNo", $preparationNo);
<?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}");
<?php
include "../../../myDatabase.php";
$username = $_GET['username'];
$description = $_GET['description'];
$chargesCode = $_GET['chargesCode'];
$ro = new database();
$ro->deleteNow("availableCharges", "chargesCode", $chargesCode);
echo "\n\n<script type='text/javascript'>\nalert('{$description} is now deleted in the list of Charges');\n</script>\n\n";
<?php
include "../../myDatabase.php";
$fileNo = $_POST['fileNo'];
$ro = new database();
$file = "../../" . $ro->selectNow("uploadedFiles", "fileUrl", "fileNo", $fileNo);
unlink($file);
$ro->deleteNow("uploadedFiles", "fileNo", $fileNo);
<?php
include "../../myDatabase.php";
$casetype = $_GET['casetype'];
$username = $_GET['username'];
$ro = new database();
$ro->deleteNow("phicLimit", "casetype", $casetype);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/casetype/showCasetype.php?username={$username}");
<?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 "../../../myDatabase.php";
$username = $_GET['username'];
$employeeID = $_GET['employeeID'];
$user = $_GET['user'];
$ro = new database();
$ro->deleteNow("registeredUser", "employeeID", $employeeID);
echo "\n<script type='text/javascript'>\nalert('{$user} is now deleted');\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/masterfile/user.php?username={$username}';\n</script>\n\n";
<?php
include "../../../myDatabase.php";
$registrationNo = $_GET['registrationNo'];
$ro = new database();
$ro->deleteNow("registrationDetails", "registrationNo", $registrationNo);
echo "<center><Br><br><Br><br><font color=red size=5>Successfully Deleted</font>";
<?php
session_start();
include "../../../myDatabase.php";
include "../../../myDatabase4.php";
$collectionNo = $_POST['collectionNo'];
$ro = new database();
$ro4 = new database4();
echo $collectionNo . "<br>";
if ($ro->selectNow("collectionReport", "paidVia", "collectionNo", $collectionNo) == "Cash") {
$remainingPd = $ro->selectNow("patientCharges", "cashPaid", "itemNo", $ro->selectNow("collectionReport", "itemNo", "collectionNo", $collectionNo)) - $ro->selectNow("collectionReport", "amountPaid", "collectionNo", $collectionNo);
} else {
$remainingPd = $ro->selectNow("patientCharges", "amountPaidFromCreditCard", "itemNo", $ro->selectNow("collectionReport", "itemNo", "collectionNo", $collectionNo)) - $ro->selectNow("collectionReport", "amountPaid", "collectionNo", $collectionNo);
}
$totalCashUnpaid = $ro->selectNow("patientCharges", "cashUnpaid", "itemNo", $ro->selectNow("collectionReport", "itemNo", "collectionNo", $collectionNo)) + $ro->selectNow("collectionReport", "amountPaid", "collectionNo", $collectionNo);
if ($ro->selectNow("collectionReport", "paidVia", "collectionNo", $collectionNo) == "Cash") {
$ro->editNow("patientCharges", "itemNo", $ro->selectNow("collectionReport", "itemNo", "collectionNo", $collectionNo), "cashPaid", $remainingPd);
} else {
$ro->editNow("patientCharges", "itemNo", $ro->selectNow("collectionReport", "itemNo", "collectionNo", $collectionNo), "amountPaidFromCreditCard", $remainingPd);
}
$ro->editNow("patientCharges", "itemNo", $ro->selectNow("collectionReport", "itemNo", "collectionNo", $collectionNo), "cashUnpaid", $totalCashUnpaid);
$ro->editNow("patientCharges", "itemNo", $ro->selectNow("collectionReport", "itemNo", "collectionNo", $collectionNo), "status", "UNPAID");
if ($ro->selectNow("collectionReport", "paidVia", "collectionNo", $collectionNo) == "Cash") {
$ro->editNow("patientCharges", "itemNo", $ro->selectNow("collectionReport", "itemNo", "collectionNo", $collectionNo), "cashPaid", "0");
} else {
$ro->editNow("patientCharges", "itemNo", $ro->selectNow("collectionReport", "itemNo", "collectionNo", $collectionNo), "amountPaidFromCreditCard", "0");
}
$voidTable = array("collectionNo" => $collectionNo, "registrationNo" => $ro->selectNow("collectionReport", "registrationNo", "collectionNo", $collectionNo), "itemNo" => $ro->selectNow("collectionReport", "itemNo", "collectionNo", $collectionNo), "shift" => $ro->selectNow("collectionReport", "shift", "collectionNo", $collectionNo), "description" => $ro->selectNow("collectionReport", "description", "collectionNo", $collectionNo), "amountPaid" => $ro->selectNow("collectionReport", "amountPaid", "collectionNo", $collectionNo), "orNo" => $ro->selectNow("collectionReport", "orNo", "collectionNo", $collectionNo), "type" => $ro->selectNow("collectionReport", "type", "collectionNo", $collectionNo), "paidBy" => $ro->selectNow("collectionReport", "paidBy", "collectionNo", $collectionNo), "timePaid" => $ro->selectNow("collectionReport", "timePaid", "collectionNo", $collectionNo), "datePaid" => $ro->selectNow("collectionReport", "datePaid", "collectionNo", $collectionNo), "paidVia" => $ro->selectNow("collectionReport", "paidVia", "collectionNo", $collectionNo), "voidBy" => $_SESSION['username']);
$ro4->insertNow("collectionReport_void", $voidTable);
$ro->deleteNow("collectionReport", "collectionNo", $collectionNo);
<?php
include "../../../myDatabase.php";
$branchID = $_GET['branchID'];
$branch = $_GET['branch'];
$username = $_GET['username'];
$ro = new database();
$ro->deleteNow("branch", "branchID", $branchID);
echo "\n\n<script type='text/javascript'>\nalert('{$branch} Branch is now deleted');\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/masterfile/branch.php?username={$username}';\n</script>\n\n";
<?php
include "../../../myDatabase.php";
$username = $_GET['username'];
$serviceNo = $_GET['serviceNo'];
$service = $_GET['service'];
$category = $_GET['category'];
$show = $_GET['show'];
$ro = new database();
$ro->deleteNow("Services", "serviceNo", $serviceNo);
echo "\n\n<script type='text/javascript'>\nalert('The {$service} in {$category} is now deleted');\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/masterfile/chargesService.php?username={$username}&show={$show}';\n</script>\n\n";