PHP database::EditNow方法代码示例

<?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}&registrationNo={$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='{$uname}' AND password='{$delpass}'");
$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}&registrationNo={$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&registrationNo=';\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";