<?php include "../../../myDatabase.php"; $username = $_GET['username']; $registrationNo = $_GET['registrationNo']; $icdNo = $_GET['icdNo']; $icdCode = $_GET['icdCode']; $diagnosis = $_GET['diagnosis']; $ro = new database(); $ro->EditNow("patientICD", "icdNo", $icdNo, "icdCode", $icdCode); $ro->EditNow("patientICD", "icdNo", $icdNo, "diagnosis", $diagnosis); echo "\n\n<script type='text/javascript'>\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/viewICD.php?username={$username}®istrationNo={$registrationNo}';\n</script>\n\n\n";
include "../../../myDatabase.php"; $cuz = new database(); mysql_connect($cuz->myHost(), $cuz->getUser(), $cuz->getPass()); mysql_select_db($cuz->getDB()); $registrationNo = $_GET['registrationNo']; $username = $_GET['username']; $fromMonth = $_GET['fromMonth']; $fromDay = $_GET['fromDay']; $fromYear = $_GET['fromYear']; $toMonth = $_GET['toMonth']; $toDay = $_GET['toDay']; $toYear = $_GET['toYear']; $type = $_GET['type']; $dept = $_GET['dept']; $uname = $_POST['uname']; $delpass = $_POST['delpass']; $asql = mysql_query("SELECT * FROM registeredUser WHERE username='******' AND password='******'"); $acount = mysql_num_rows($asql); $dateRegistered = $cuz->selectNow("registrationDetails", "dateRegistered", "registrationNo", $registrationNo); if ($acount != 0) { $date = date("Y-m-d"); $time = date("H:i:s"); $delete = "DELETED_" . $uname . "[" . $date . "@" . $time . "]_" . $dateRegistered; //$ro->deleteNow("registrationDetails","registrationNo",$registrationNo); $cuz->EditNow("registrationDetails", "registrationNo", $registrationNo, "dateRegistered", $delete); echo "<center><Br><br><Br><br><font color=red size=5>Successfully Deleted</font>"; echo "<META HTTP-EQUIV='Refresh'CONTENT='3;URL=registrationCensus.php?username={$username}&fromMonth={$fromMonth}&fromDay={$fromDay}&fromYear={$fromYear}&toMonth={$toMonth}&toDay={$toDay}&toYear={$toYear}&type={$type}&dept={$dept}'>"; } else { echo "<center><Br><br><Br><br><font color=red size=5>You are not authorized to delete the Patient.</font>"; echo "<META HTTP-EQUIV='Refresh'CONTENT='3;URL=registrationCensus.php?username={$username}&fromMonth={$fromMonth}&fromDay={$fromDay}&fromYear={$fromYear}&toMonth={$toMonth}&toDay={$toDay}&toYear={$toYear}&type={$type}&dept={$dept}'>"; }
// Registration Status [new] $ro->addNewPatientRecord($patientNo, $lastname, $firstname, $middlename, $completeName, $ro->calculate_age($birthDate), $patientContact, $birthDate, $gender, $seniorCitizen, $address, $philHealth, $civilStatus, $religion); if ($room == "OPD") { $ro->addNewRegistration($patientNo, $registrationNo, $bloodpressure, $patientTemperature, $height, $weight, $company, $diagnosis, $dateRegistered, $serverTime, $ro->getUserBranch($password), "OPD", "OPD_OPD", $ro->getUserRegistered(), $casetype, "2000", date("Y-m-d"), $diet, $pulse, $respiratory); } else { if ($room == "ER") { $ro->addNewRegistration($patientNo, $registrationNo, $bloodpressure, $patientTemperature, $height, $weight, $company, $diagnosis, $dateRegistered, $serverTime, $ro->getUserBranch($password), "ER", "ER_ER", $ro->getUserRegistered(), $casetype, "2000", date("Y-m-d"), $diet, $pulse, $respiratory); } else { if ($room == "OR/DR") { $ro->addNewRegistration($patientNo, $registrationNo, $bloodpressure, $patientTemperature, $height, $weight, $company, $diagnosis, $dateRegistered, $serverTime, $ro->getUserBranch($password), "OR/DR", "OR/DR_OR/DR", $ro->getUserRegistered(), $casetype, "2000", date("Y-m-d"), $diet, $pulse, $respiratory); } else { $ro->addNewRegistration($patientNo, $registrationNo, $bloodpressure, $patientTemperature, $height, $weight, $company, $diagnosis, $dateRegistered, $serverTime, $ro->getUserBranch($password), "IPD", $room, $ro->getUserRegistered(), $casetype, "2000", date("Y-m-d"), $diet, $pulse, $respiratory); $timezone = "Asia/Manila"; date_default_timezone_set($timezone); //ADD ROOM $ro->EditNow("room", "Description", $room, "status", "Occupied"); //GWEN OCCUPIED ANG STATUS NG ROOM $ro->getRoom($room); $ro->addCharges_cash("UNPAID", $registrationNo, $room, $room, $ro->room_rate(), 0, $ro->room_rate(), $ro->room_rate(), 0, 0, $serverTime, $dateRegistered, $ro->getUserRegistered(), "Confinement", "Room And Board", "Cash", 0, "", 1, "", $ro->getUserBranch($password), ""); } } } } else { // Registration Status [old] if ($room == "OPD") { $ro->addNewRegistration($patientNo, $registrationNo, $bloodpressure, $patientTemperature, $height, $weight, $company, $diagnosis, $dateRegistered, $serverTime, $ro->getUserBranch($password), "OPD", "OPD_OPD", $ro->getUserRegistered(), $casetype, "2000", date("Y-m-d"), $diet, $pulse, $respiratory); } else { if ($room == "ER") { $ro->addNewRegistration($patientNo, $registrationNo, $bloodpressure, $patientTemperature, $height, $weight, $company, $diagnosis, $dateRegistered, $serverTime, $ro->getUserBranch($password), "ER", "ER_ER", $ro->getUserRegistered(), $casetype, "2000", date("Y-m-d"), $diet, $pulse, $respiratory); } else { if ($room == "OR/DR") {
<?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"; $supplierCode = $_GET['supplierCode']; $supplierName = $_GET['supplierName']; $address = $_GET['address']; $contactPerson = $_GET['contactPerson']; $contactNo = $_GET['contactNo']; $description = $_GET['description']; $username = $_GET['username']; $ro = new database(); $ro->EditNow("supplier", "supplierCode", $supplierCode, "supplierName", $supplierName); $ro->EditNow("supplier", "supplierCode", $supplierCode, "address", $address); $ro->EditNow("supplier", "supplierCode", $supplierCode, "contactPerson", $contactPerson); $ro->EditNow("supplier", "supplierCode", $supplierCode, "contactNo", $contactNo); $ro->EditNow("supplier", "supplierCode", $supplierCode, "description", $description); echo "\n\n<script type='text/javascript'>\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/masterfile/supplier.php?username={$username}';\n</script>\n\n";
<?php include "../../../myDatabase.php"; $type = $_GET['type']; $assign = $_GET['assign']; $registrationNo = $_GET['registrationNo']; $username = $_GET['username']; $countz = count($assign); $ro = new database(); $ro->getPatientProfile($registrationNo); for ($x = 0; $x < $countz; $x++) { $assignPayment = preg_split("/\\_/", $assign[$x]); $ro->getPatientChargesToEdit($assignPayment[0]); if ($assignPayment[1] == "cash") { $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "cashUnpaid", $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $assignPayment[0]) * $ro->selectNow("patientCharges", "quantity", "itemNo", $assignPayment[0])); // iLLgay sa cash ///ccguraduhin n mgging zero ung total sa mga column mga column n e2 dahil mppunta Lhat sa cash $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "company", 0); $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "phic", 0); $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "discount", 0); $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "doctorsPF", 0); $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "doctorsPF_payable", 0); $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "vat", 0); $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "otShare", 0); $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "total", $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $assignPayment[0]) * $ro->selectNow("patientCharges", "quantity", "itemNo", $assignPayment[0])); } else { if ($assignPayment[1] == "hmo") { $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "company", $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $assignPayment[0]) * $ro->selectNow("patientCharges", "quantity", "itemNo", $assignPayment[0])); $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "cashUnpaid", 0); $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "phic", 0); $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "discount", 0);
$hmoLimit = $_GET['hmoLimit']; $discount = $_GET['discount']; $companyDiscount = $_GET['companyDiscount']; $package = $_GET['package']; $pinNo = $_GET['pinNo']; $seniorNo = $_GET['seniorNo']; if (isset($_GET['CashLIMIT'])) { $CashLIMIT = $_GET['CashLIMIT']; } else { } $ro = new database(); $ro->getPatientProfile($registrationNo); //if($ro->selectNow("registeredUser","module","username",$username) == "CASHIER" && $discount > $ro->getReportInformation("cashierDisc") ) { //$ro->getBack("Sorry,You put a discount that is higher to your allowable discount which is".$ro->getReportInformation("cashierDisc")); //}else { $ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "discount", $discount); $ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "companyDiscount", $companyDiscount); //} $ro->editCompleteName($patientNo, $lastname . " " . $firstname . " " . $middlename); $ro->editLastName($patientNo, $lastname); $ro->editFirstName($patientNo, $firstname); $ro->editMiddleName($patientNo, $middlename); $ro->editAge($patientNo, $age); $ro->editCivilStatus($patientNo, $civilStatus); $ro->editBirthDate($patientNo, $birthdate); $ro->editContactNo($patientNo, $contactNo); $ro->editSenior($patientNo, $senior); $ro->editPHIC($patientNo, $PhilHealth); //$ro->editCompany($patientNo,$company); //$ro->editTimeRegistered($patientNo,$timeRegistered); //$ro->editDateRegistered($patientNo,$dateRegistered);
$registrationNo = $_GET['registrationNo']; $username = $_GET['username']; $show = $_GET['show']; $desc = $_GET['desc']; $transfer = $_GET['transfer']; $countz = count($transfer); $ro = new database(); $Ftype = $ro->selectNow("registrationDetails", "type", "registrationNo", $registrationNo); $dateRegistered = $ro->selectNow("registrationDetails", "dateRegistered", "registrationNo", $registrationNo); $dateRegisteredfmt = date("Ymd", strtotime($dateRegistered)); if ($Ftype == "IPD") { if ($desc == "cash2company") { for ($x = 0; $x < $countz; $x++) { $ro->getPatientChargesToEdit($transfer[$x]); $totalTransfer = $ro->patientCharges_cashUnpaid() + $ro->patientCharges_company(); $ro->EditNow("patientCharges", "itemNo", $transfer[$x], "company", $totalTransfer); $ro->EditNow("patientCharges", "itemNo", $transfer[$x], "cashUnpaid", 0); } } else { if ($desc == "cash2phic") { for ($x = 0; $x < $countz; $x++) { $ro->getPatientChargesToEdit($transfer[$x]); $totalTransfer = $ro->patientCharges_cashUnpaid() + $ro->patientCharges_phic(); $ro->EditNow("patientCharges", "itemNo", $transfer[$x], "phic", $totalTransfer); $ro->EditNow("patientCharges", "itemNo", $transfer[$x], "cashUnpaid", 0); } } else { if ($desc == "cash2package") { for ($x = 0; $x < $countz; $x++) { $ro->getPatientChargesToEdit($transfer[$x]); $totalTransfer = $ro->patientCharges_cashUnpaid();
<?php include "../../../myDatabase.php"; $registrationNo = $_GET['registrationNo']; $paymentNo = $_GET['paymentNo']; $username = $_GET['username']; $paymentFor = $_GET['paymentFor']; $amountPaid = $_GET['amountPaid']; $timePaid = $_GET['timePaid']; $datePaid = $_GET['datePaid']; $pf = $_GET['pf']; $admitting = $_GET['admitting']; $ro = new database(); $ro->EditNow("patientPayment", "paymentNo", $paymentNo, "paymentFor", $paymentFor); $ro->EditNow("patientPayment", "paymentNo", $paymentNo, "amountPaid", $amountPaid); $ro->EditNow("patientPayment", "paymentNo", $paymentNo, "timePaid", $timePaid); $ro->EditNow("patientPayment", "paymentNo", $paymentNo, "datePaid", $datePaid); $ro->EditNow("patientPayment", "paymentNo", $paymentNo, "paidBy", $username); $ro->EditNow("patientPayment", "paymentNo", $paymentNo, "pf", $pf); $ro->EditNow("patientPayment", "paymentNo", $paymentNo, "admitting", $admitting); /* echo " <script type='text/javascript'> window.location='http://".$ro->getMyUrl()."/COCONUT/patientProfile/Payments/viewPayment.php?registrationNo=$registrationNo&username=$username'; </script> "; */
<?php include "../../../myDatabase.php"; $type = $_GET['type']; $assign = $_GET['assign']; $registrationNo = $_GET['registrationNo']; $username = $_GET['username']; $countz = count($assign); $ro = new database(); $ro->getPatientProfile($registrationNo); for ($x = 0; $x < $countz; $x++) { $assignPayment = preg_split("/\\_/", $assign[$x]); $ro->getPatientChargesToEdit($assignPayment[0]); if ($assignPayment[1] == "cash") { $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "cashUnpaid", $ro->patientCharges_total()); // iLLgay sa cash ///ccguraduhin n mgging zero ung total sa mga column mga column n e2 dahil mppunta Lhat sa cash $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "company", 0); $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "phic", 0); $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "charity", 0); } else { if ($assignPayment[1] == "hmo") { $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "company", $ro->patientCharges_total()); $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "cashUnpaid", 0); $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "phic", 0); $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "charity", 0); } else { if ($assignPayment[1] == "phic") { $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "phic", $ro->patientCharges_total()); $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "cashUnpaid", 0); $ro->EditNow("patientCharges", "itemNo", $assignPayment[0], "company", 0);
<?php include "../../../myDatabase.php"; $registrationNo = $_GET['registrationNo']; $limitNo = $_GET['limitNo']; $username = $_GET['username']; $limitTo = $_GET['limitTo']; $limitVia = $_GET['limitVia']; $amountLimit = $_GET['amountLimit']; $ro = new database(); $ro->EditNow("patientCreditLimit", "limitNo", $limitNo, "limitTo", $limitTo); $ro->EditNow("patientCreditLimit", "limitNo", $limitNo, "limitVia", $limitVia); $ro->EditNow("patientCreditLimit", "limitNo", $limitNo, "amountLimit", $amountLimit); $ro->EditNow("patientCreditLimit", "limitNo", $limitNo, "username", $username); 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"; $registrationNo = $_GET['registrationNo']; $room = $_GET['roomz']; $username = $_GET['username']; $originalRoom = $_GET['originalRoom']; $ro = new database(); $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "room", $room); $timezone = "Asia/Manila"; date_default_timezone_set($timezone); //$ro->EditNow("registrationDetails","registrationNo",$registrationNo,"dateUnregistered",""); //$ro->EditNow("registrationDetails","registrationNo",$registrationNo,"timeUnregistered",""); //$ro->deleteRoom($registrationNo); // delete original room ... incase nag transfer ng ibang room $ro->editNow("room", "Description", $originalRoom, "status", "Vacant"); // set vacant the room when discharge or transfer $ro->getRoom($room); // source of data pra sa room... pra makuha ung rate ng room from the masterfile $ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "room", $room); $ro->addCharges_cash("UNPAID", $registrationNo, $room, $room, $ro->room_rate(), 0, $ro->room_rate(), $ro->room_rate(), 0, 0, date("H:i:s"), date("Y-m-d"), $username, "Confinement", "Room And Board", "Cash", 0, "", 1, "", $ro->room_branch(), ""); //add room $ro->EditNow("room", "Description", $room, "status", "Occupied"); // gwen occupied ang room $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientProfile_handler.php?registrationNo={$registrationNo}&username={$username} ");
<?php include "../../../myDatabase.php"; $icdCode = $_GET['icdCode']; $diagnosis = $_GET['diagnosis']; $icdTrackNo = $_GET['icdTrackNo']; $username = $_GET['username']; $ro = new database(); $ro->EditNow("availableICD", "icdTrackNo", $icdTrackNo, "icdCode", $icdCode); $ro->EditNow("availableICD", "icdTrackNo", $icdTrackNo, "diagnosis", $diagnosis); echo "<script type='text/javascript'>\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/masterfile/icdCode.php?username={$username}&desc=&show=All&protoType=maintenance®istrationNo=';\n</script>";
<?php include "../../../myDatabase.php"; $registrationNo = $_GET['registrationNo']; $show = $_GET['show']; $desc = $_GET['desc']; $transfer = $_GET['transfer']; $countz = count($transfer); $ro = new database(); if ($desc == "cash2company") { for ($x = 0; $x < $countz; $x++) { $ro->getPatientChargesToEdit($transfer[$x]); $totalTransfer = $ro->patientCharges_cashUnpaid() + $ro->patientCharges_company(); $ro->EditNow("patientCharges", "itemNo", $transfer[$x], "company", $totalTransfer); $ro->EditNow("patientCharges", "itemNo", $transfer[$x], "cashUnpaid", 0); $ro->EditNow("patientCharges", "itemNo", $transfer[$x], "remarks", ""); } } else { if ($desc == "cash2phic") { for ($x = 0; $x < $countz; $x++) { $ro->getPatientChargesToEdit($transfer[$x]); $totalTransfer = $ro->patientCharges_cashUnpaid() + $ro->patientCharges_phic(); $ro->EditNow("patientCharges", "itemNo", $transfer[$x], "phic", $totalTransfer); $ro->EditNow("patientCharges", "itemNo", $transfer[$x], "cashUnpaid", 0); $ro->EditNow("patientCharges", "itemNo", $transfer[$x], "remarks", ""); } } else { if ($desc == "cash2package") { for ($x = 0; $x < $countz; $x++) { $ro->getPatientChargesToEdit($transfer[$x]); $totalTransfer = $ro->patientCharges_cashUnpaid();
<?php include "../../../myDatabase.php"; $roomNo = $_GET['roomNo']; $description = $_GET['description']; $type = $_GET['type']; $rate = $_GET['rate']; $branch = $_GET['branch']; $username = $_GET['username']; $show = $_GET['show']; $desc = $_GET['desc']; $floor = $_GET['floor']; $status = $_GET['status']; $ro = new database(); $myRoom = $description . "_" . $type; $ro->EditNow("room", "roomNo", $roomNo, "Description", $myRoom); $ro->EditNow("room", "roomNo", $roomNo, "type", $type); $ro->EditNow("room", "roomNo", $roomNo, "rate", $rate); $ro->EditNow("room", "roomNo", $roomNo, "branch", $branch); $ro->EditNow("room", "roomNo", $roomNo, "floor", $floor); $ro->EditNow("room", "roomNo", $roomNo, "status", $status); echo "\n\n<script type='text/javascript'>\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/masterfile/viewRoom.php?username={$username}&show={$show}&desc={$desc}';\n</script>\n\n";
$package = $_GET['package']; $pinNo = $_GET['pinNo']; $seniorNo = $_GET['seniorNo']; $discountType = $_GET['discountType']; $interest = $_GET['interest']; $patientTax = $_GET['patientTax']; if (isset($_GET['CashLIMIT'])) { $CashLIMIT = $_GET['CashLIMIT']; } else { } $ro = new database(); $ro->getPatientProfile($registrationNo); //if($ro->selectNow("registeredUser","module","username",$username) == "CASHIER" && $discount > $ro->getReportInformation("cashierDisc") ) { //$ro->getBack("Sorry,You put a discount that is higher to your allowable discount which is".$ro->getReportInformation("cashierDisc")); //}else { $ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "discount", $discount); $ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "companyDiscount", $companyDiscount); //} $ro->editCompleteName($patientNo, $lastname . " " . $firstname . " " . $middlename); $ro->editLastName($patientNo, $lastname); $ro->editFirstName($patientNo, $firstname); $ro->editMiddleName($patientNo, $middlename); $ro->editAge($patientNo, $age); $ro->editCivilStatus($patientNo, $civilStatus); $ro->editBirthDate($patientNo, $birthdate); $ro->editContactNo($patientNo, $contactNo); $ro->editSenior($patientNo, $senior); $ro->editPHIC($patientNo, $PhilHealth); //$ro->editCompany($patientNo,$company); //$ro->editTimeRegistered($patientNo,$timeRegistered); //$ro->editDateRegistered($patientNo,$dateRegistered);