PHP database2::editNowの例

コード例 #1

ファイル: excess1.php プロジェクト: rickyx12/protacio

<?php

include "../../myDatabase2.php";
$registrationNo = $_POST['registrationNo'];
$excessPF = $_POST['excessPF'];
$excessRoom = $_POST['excessRoom'];
$excessMaxBenefits = $_POST['excessMaxBenefits'];
$PHICportion = $_POST['PHICportion'];
$manual = $_POST['manual'];
$manualValue = $_POST['manualValue'];
$ro = new database2();
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "excessPF", $excessPF);
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "excessRoom", $excessRoom);
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "excessMaxBenefits", $excessMaxBenefits);
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "PHICportion", $PHICportion);
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "hmoManualExcess", $manual);
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "hmoManualExcessValue", $manualValue);

コード例 #2

ファイル: deletePatientCharges_redirect.php プロジェクト: rickyx12/mendero

$quantity = $_GET['quantity'];
$username = $_GET['username'];
$show = $_GET['show'];
$desc = $_GET['desc'];
$ro = new database2();
$titlez = $ro->getTitle($itemNo);
if ($ro->doubleSelectNow("patientCharges", "quantity", "itemNo", $itemNo, "registrationNo", $registrationNo) < $quantity) {
    echo "<br><br><br><font color=red>Ooopsss.. you are trying to return {$quantity} but there is only " . $ro->doubleSelectNow("patientCharges", "quantity", "itemNo", $itemNo, "registrationNo", $registrationNo) . " Dispensed to the patient</font>";
} else {
    if (($ro->getTitle($itemNo) == "MEDICINE" || $ro->getTitle($itemNo) == "SUPPLIES") && $ro->getChargesStatusDept($itemNo)) {
        if ($ro->selectNow("inventory", "autoDispense", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)) == "yes") {
            $currentQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo));
            // current qty ng meds/sup sa inventory
            $newQTY = $currentQTY + $quantity;
            //dagdag inventory once return
            $ro->editNow("inventory", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo), "quantity", $newQTY);
            // update qty sa database
            $ro->deletePatientCharges($registrationNo, $itemNo);
        } else {
            $ro->editNow("patientCharges", "itemNo", $itemNo, "status", "Return");
            $ro->editNow("patientCharges", "itemNo", $itemNo, "dateReturn", date("Y-m-d"));
            $ro->editNow("patientCharges", "itemNo", $itemNo, "departmentStatus", $quantity . "_" . $registrationNo);
            $ro->returnInventory($itemNo, $registrationNo, $ro->selectNow("patientCharges", "description", "itemNo", $itemNo), $quantity, date("Y-m-d") . "@" . $ro->getSynapseTime(), $username);
            /*
            $regNo = $ro->selectNow("patientCharges","registrationNo","itemNo",$itemNo);
            $chargeCodez = $ro->selectNow("patientCharges","chargesCode","itemNo",$itemNo);
            $desc = $ro->selectNow("patientCharges","description","itemNo",$itemNo);
            $sp = $ro->selectNow("patientCharges","sellingPrice","itemNo",$itemNo);
            $disc = $ro->selectNow("patientCharges","discount","itemNo",$itemNo);
            $totz = ($ro->selectNow("patientCharges","sellingPrice","itemNo",$itemNo) * $quantity);
            $excess = $ro->selectNow("patientCharges","cashUnpaid","itemNo",$itemNo);

コード例 #3

ファイル: patientList_POST.php プロジェクト: rickyx12/mendero

     var aSound = document.createElement('audio');
     aSound.setAttribute('src', 'doorbell.wav');

<?php 
if ($module == "PHARMACY") {
    $tag = "MEDICINE";
} else {
    if ($module == "LABORATORY") {
        $tag = "LABORATORY";
    } else {
        $tag = "CSR";
    }
}
if ($ro->selectNow("requestCount", "currentTotal", "department", $tag) != $ro->countDeptRequest($tag, $myDate)) {
    $ro->editNow("requestCount", "department", $tag, "currentTotal", $ro->countDeptRequest($tag, $myDate));
    ?>
aSound.play();
<?php 
} else {
}
?>

<?php 
echo "</script>";
echo "</head>";
echo "<body>";
echo "<font size=1>BRANCH:</font>&nbsp;<font size=2 color=red>{$branch}</font> ";
echo "<br><font size=1>DATE:</font>&nbsp;<font size=1>{$month} {$day}, {$year}</font>";
echo "<br><font size=1>{$fromTime_hour}:{$fromTime_minutes}:{$fromTime_seconds} - </font><font size=1>{$toTime_hour}:{$toTime_minutes}:{$toTime_seconds}</font>";
if ($module != "CSR") {

コード例 #4

ファイル: hmoPrice1.php プロジェクト: rickyx12/protacio

<?php

include "../../myDatabase2.php";
$itemNo = $_GET['itemNo'];
$hmoPrice = $_GET['hmoPrice'];
$company = $_GET['company'];
$ro = new database2();
$ro->editNow("patientCharges", "itemNo", $itemNo, "hmoPrice", $hmoPrice);
$ro->editNow("patientCharges", "itemNo", $itemNo, "company", $company);

コード例 #5

ファイル: dispensedCSR.php プロジェクト: rickyx12/mendero

<?php

include "../../myDatabase2.php";
$verificationNo = $_GET['verificationNo'];
$countVerification = count($verificationNo);
$username = $_GET['username'];
$ro = new database2();
for ($x = 0; $x < $countVerification; $x++) {
    $identifier = preg_split("/\\_/", $verificationNo[$x]);
    // $identifier[0]=verificationNo, identifier[1]=inventoryCode
    //echo $verificationNo[$x];//verificationNo na galing sa inventoryManager table [serve as unique identifier]
    if ($ro->selectNow("inventory", "quantity", "inventoryCode", $identifier[1]) >= $ro->selectNow("inventoryManager", "quantity", "verificationNo", $identifier[0])) {
        //double check kung mas mataas p ung in stock qty
        $newQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $identifier[1]) - $ro->selectNow("inventoryManager", "quantity", "verificationNo", $identifier[0]);
        $ro->editNow("inventory", "inventoryCode", $identifier[1], "quantity", $newQTY);
        $generic = "";
        $pricing = $ro->selectNow("inventory", "unitcost", "inventoryCode", $identifier[1]);
        $expiration = "";
        //addNewMedicine($description,$generic,$unitcost,$quantity,$expiration,$addedBy,$dateAdded,$timeAdded,$inventoryLocation,$inventoryType,$branch,$transition,$remarks,$preparation,$phic,$added,$criticalLevel,$supplier,$begCapital,$begQTY,$suppliesUNITCOST)
        $ro->addNewMedicine($ro->selectNow("inventoryManager", "description", "verificationNo", $identifier[0]), $generic, $pricing, $ro->selectNow("inventoryManager", "quantity", "verificationNo", $identifier[0]), $expiration, $ro->selectNow("inventoryManager", "requestingUser", "verificationNo", $identifier[0]), date("Y-m-d"), $ro->getSynapseTime(), $ro->selectNow("inventoryManager", "requestingDepartment", "verificationNo", $identifier[0]), $ro->selectNow("inventory", "inventoryType", "inventoryCode", $identifier[1]), "Consolacion", "requestition", "from inventoryCode:" . $identifier[1] . " issued by:" . $username, "", "", "", "", "", "", $ro->selectNow("inventoryManager", "quantity", "verificationNo", $identifier[0]), $ro->selectNow("inventory", "suppliesUNITCOST", "inventoryCode", $identifier[1]), "yes");
        //insert to inventory table
        $ro->editNow("inventoryManager", "verificationNo", $identifier[0], "status", "dispensed");
        $ro->editNow("inventoryManager", "verificationNo", $identifier[0], "dispensedDate", date("Y-m-d"));
    } else {
        echo "<font color=red>Sorry... " . $ro->selectNow("inventoryManager", "description", "verificationNo", $identifier[0]) . " Cannot be dispensed because there's only " . $ro->selectNow("inventory", "quantity", "inventoryCode", $identifier[1]) . " in stock</font> ";
    }
}

コード例 #6

ファイル: manual1_new.php プロジェクト: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$username = $_GET['username'];
//$month = $_GET['month'];
//$day = $_GET['day'];
//$year = $_GET['year'];
//$date = $_GET['date'];
$chargeNo = $_GET['chargeNo'];
$startHour = $_GET['startHour'];
$startMinute = $_GET['startMinute'];
$startSeconds = $_GET['startSeconds'];
$stopHour = $_GET['stopHour'];
$stopMinute = $_GET['stopMinute'];
$stopSeconds = $_GET['stopSeconds'];
$status = $_GET['status'];
$hours = $_GET['hours'];
$ro = new database2();
$newTimeStart = $startHour . ":" . $startMinute . ":" . $startSeconds;
$newTimeStop = $stopHour . ":" . $stopMinute . ":" . $stopSeconds;
$ro->editNow("generatorCharge", "chargeNo", $chargeNo, "timeStart", $newTimeStart);
$ro->editNow("generatorCharge", "chargeNo", $chargeNo, "timeStop", $newTimeStop);
$ro->editNow("generatorCharge", "chargeNo", $chargeNo, "status", $status);
$ro->editNow("generatorCharge", "chargeNo", $chargeNo, "hours", $hours);

コード例 #7

ファイル: addCompany1.php プロジェクト: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$registrationNo = $_POST['registrationNo'];
$username = $_POST['username'];
$company1 = $_POST['company1'];
$company2 = $_POST['company2'];
$ro = new database2();
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "company1", $company1);
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "company2", $company2);
echo "\n<script type='text/javascript'>\nwindow.location='http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientProfile_handler.php?registrationNo={$registrationNo}&username={$username}';\n</script>\n\n";

コード例 #8

ファイル: addCharges.php プロジェクト: rickyx12/protacio

}
if (isset($_GET['instruction1'])) {
    $instruction1 = $_GET['instruction1'];
} else {
    $instruction1 = "";
}
if (isset($_GET['indication1'])) {
    $indication1 = $_GET['indication1'];
} else {
    $indication1 = "";
}
$ro = new database2();
$ro->getPatientProfile($registrationNo);
$currentTotal = $quantity * $sellingPrice;
$grandTotal = $currentTotal;
if ($decision == "yes") {
    $dateCharge = date("Y-m-d");
    $ro->addCharges_cash_mobile($status, $registrationNo, $chargesCode, $description, $sellingPrice, "0", $grandTotal, $grandTotal, 0, 0, $timeCharge, $dateCharge, $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room);
    if ($title == "MEDICINE") {
        $ro->addNewPlan($registrationNo, $description, $timing1, $instruction1, $indication1, $quantity);
    } else {
    }
} else {
    if ($title != "MEDICINE") {
        $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "advised", $ro->selectNow("registrationDetails", "advised", "registrationNo", $registrationNo) . "," . $description);
        $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/android/doctor/mobileAddCharges_charges.php?registrationNo={$registrationNo}&username={$username}&room={$room}&batchNo={$batchNo}");
    } else {
        $ro->addNewPlan_fromCharging($registrationNo, $description, $timing1, $instruction1, $indication1, $quantity, $batchNo, $room, $username);
        $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/android/doctor/mobileAddCharges_medicine.php?registrationNo={$registrationNo}&username={$username}&room={$room}&batchNo={$batchNo}");
    }
}

コード例 #9

ファイル: requestDisp.php プロジェクト: rickyx12/mendero

    $expiration = $ro->selectNow("inventory", "expiration", "inventoryCode", $inventoryCode[$i]);
    $serverTime = $ro->getSynapseTime();
    $inventoryLocation = $ro->selectNow("inventoryManager", "requestingDepartment", "verificationNo", $verificationNo[$i]);
    $branch = "Consolacion";
    $inventoryType = $ro->selectNow("inventory", "inventoryType", "inventoryCode", $inventoryCode[$i]);
    $transition = " Issued By " . $ro->selectNow("inventoryManager", "requestTo_department", "verificationNo", $verificationNo[$v]) . " / Issued Staff {$username}";
    $remarks = "requestitionNo_{$verificationNo[$v]} / from inventoryCode of {$inventoryCode[$i]}";
    $quantity = $ro->selectNow("inventoryManager", "quantity", "verificationNo", $verificationNo[$v]);
    $currentQTY = $ro->getCurrentQTY($inventoryCode[$i]) - $quantity;
    $requestingUser = $ro->selectNow("inventoryManager", "requestingUser", "verificationNo", $verificationNo[$v]);
    $invqty = $ro->selectNow("inventory", "quantity", "inventoryCode", $inventoryCode[$i]);
    if ($quantity > $invqty) {
    } else {
        if ($inventoryType == "medicine") {
            $ro->addNewMedicine1($description, $generic, $unitcost, $quantity, $expiration, $requestingUser, $date, $serverTime, $inventoryLocation, $inventoryType, $branch, $transition, $remarks, $ro->selectNow("inventory", "Added", "inventoryCode", $inventoryCode[$i]), $inventoryCode[$i]);
        } else {
            $ro->addNewMedicine1($description, $generic, $unitcost, $quantity, $expiration, $requestingUser, $date, $serverTime, $inventoryLocation, $inventoryType, $branch, $transition, $remarks, $ro->selectNow("inventory", "unitcost", "inventoryCode", $inventoryCode[$i]), $inventoryCode[$i]);
        }
        $timezone = "Asia/Manila";
        date_default_timezone_set($timezone);
        $ro->editNow("inventoryManager", "verificationNo", $verificationNo[$v], "dateIssued", date("Y-m-d"));
        $ro->editNow("inventoryManager", "verificationNo", $verificationNo[$v], "timeIssued", date("H:i:s"));
        $ro->editNow("inventoryManager", "verificationNo", $verificationNo[$v], "issuedBy", $username);
        $ro->editNow("inventoryManager", "verificationNo", $verificationNo[$v], "status", "dispensed");
        $ro->editNow("inventoryManager", "verificationNo", $verificationNo[$v], "quantityIssued", $quantity);
        $newQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $inventoryCode[$i]) - $quantity;
        $ro->editNow("inventory", "inventoryCode", $inventoryCode[$i], "quantity", $newQTY);
        $ro->editNow("inventoryManager", "verificationNo", $verificationNo[$v], "status", "Received");
        //$ro->addNewMedicine1($description,$generic,$unitcost,$quantity,$expiration,$addedBy,$date,$time,$inventoryLocation,$inventoryType,$branch,$transition,$remarks,$ro->selectNow("inventory","Added","inventoryCode",$inventoryCode));
    }
}

コード例 #10

ファイル: analyzing_rBanny.php プロジェクト: rickyx12/protacio

$ro = new database2();
//echo ( $cash - $targetAmount );
echo "<center><br>";
$itemz = preg_split("/\\_/", $ro->getMaximumTotal_rBanny($registrationNo));
//format cashUnpaid_itemNo
echo "<Br>";
echo "Item#:&nbsp;" . $itemz[1];
echo "<br>Price:&nbsp;" . $itemz[0];
echo "<br><b>Analyzing &nbsp;" . $ro->selectNow("patientCharges", "description", "itemNo", $itemz[1]) . "</b>";
//check kung ilan na lang ung natitira sa target amount kpg bnwsan na sa current phic ng px
$pxPHIC = $ro->getCurrentPHIC_check_rBanny($registrationNo) - $targetAmount;
//check kung mas mataas pa ung total ng item kaysa sa natitirang sa targetAmount
if ($itemz[0] >= $pxPHIC) {
    $newCash = $ro->selectNow("patientCharges", "cashUnpaid", "itemNo", $itemz[1]) - ($targetAmount - $ro->getTotal("phic", "", $registrationNo));
    if ($newCash > 1) {
        $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", $newCash);
        $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $targetAmount - $ro->getTotal("phic", "", $registrationNo));
    } else {
        $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $ro->selectNow("patientCharges", "cashUnpaid", "itemNo", $itemz[1]));
        $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", "0");
    }
} else {
    $excessPHIC = $itemz[0] - $targetAmount;
    $exactPHIC = $itemz[0] - $excessPHIC;
    $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", $excessPHIC);
    $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $exactPHIC);
}
if ($ro->getTotal("phic", "", $registrationNo) != $targetAmount) {
    $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/rBanny/analyzing_rBanny.php?registrationNo={$registrationNo}&cash={$cash}&targetAmount={$targetAmount}");
} else {
    echo "<br><Br><Br><center><font size=5 color=red><i>R-Banny is now completed the PhilHealth CaseRate</i></font></center>";

コード例 #11

ファイル: verified1.php プロジェクト: rickyx12/protacio

<?php

include "../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database2();
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "verified", $username . "+" . date("M_d_Y") . "+" . $ro->getSynapseTime());
echo "<font color=red>Patient is now Verified</font>";
?>

コード例 #12

ファイル: deleteResult.php プロジェクト: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$itemNo = $_GET['itemNo'];
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database2();
$ro->editNow("core2_laboratoryResultChecker", "itemNo", $itemNo, "status", "DELETED_{$username}-@" . date("Y-m-d") . "-" . $ro->getSynapseTime());
$ro->editNow("labSavedResult", "itemNo", $itemNo, "status", "DELETED_{$username}-@" . date("Y-m-d") . "-" . $ro->getSynapseTime());
echo "<br><Br><br<center>";
echo $ro->selectNow("patientCharges", "description", "itemNo", $itemNo) . " Result is now Deleted";

コード例 #13

ファイル: deleteDisbursementEntry.php プロジェクト: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$username = $_GET['username'];
$idNo = $_GET['idNo'];
$transactionNo = $_GET['transactionNo'];
$ro = new database2();
$ro->editNow("disbursement", "idNo", $idNo, "status", "DELETED");
$ro->editNow("disbursement", "idNo", $idNo, "deleteDetails", date("Y-m-d") . "_" . date("H:i:s") . "_" . $username);
if ($fromPage == "encode") {
    $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/accounting/cashDisbursement/disbursementUpdate.php?transactionNo={$transactionNo}&username={$username}");
} else {
    $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/accounting/cashDisbursement/editDisbursementEntry/disbursementUpdate.php?transactionNo={$transactionNo}&username={$username}");
}

コード例 #14

ファイル: editInventory1.php プロジェクト: rickyx12/protacio

	color: #000;
	height: 28px;
	width: 381px;
	border-color:red red red red;
	font-size:15px;
	text-align:center;
	background-color:white;
}

.button:hover {
background-color:yellow;
color:black;
}

.button1:hover {
background-color:yellow;
color:black;
}


</style>


<?php 
$ro->editNow("convenienceInventory", "inventoryNo", $inventoryNo, "description", $description);
$ro->editNow("convenienceInventory", "inventoryNo", $inventoryNo, "qty", $qty);
echo "<center><br><br><br>";
echo "<form method='post' action='http://" . $ro->getMyUrl() . "/COCONUT/convenience/viewInventory.php'>";
$ro->coconutHidden("username", $username);
echo "<input type=submit value='Back to Inventory List' class='button'>";
echo "</form>";

コード例 #15

ファイル: manual1.php プロジェクト: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$username = $_GET['username'];
//$month = $_GET['month'];
//$day = $_GET['day'];
//$year = $_GET['year'];
$date = $_GET['date'];
$startHour = $_GET['startHour'];
$startMinute = $_GET['startMinute'];
$startSeconds = $_GET['startSeconds'];
$stopHour = $_GET['stopHour'];
$stopMinute = $_GET['stopMinute'];
$stopSeconds = $_GET['stopSeconds'];
$status = $_GET['status'];
$hours = $_GET['hours'];
$ro = new database2();
$newTimeStart = $startHour . ":" . $startMinute . ":" . $startSeconds;
$newTimeStop = $stopHour . ":" . $stopMinute . ":" . $stopSeconds;
$ro->editNow("generatorCharge", "dateStart", $date, "timeStart", $newTimeStart);
$ro->editNow("generatorCharge", "dateStart", $date, "timeStop", $newTimeStop);
$ro->editNow("generatorCharge", "dateStart", $date, "status", $status);
$ro->editNow("generatorCharge", "dateStart", $date, "hours", $hours);

コード例 #16

ファイル: editAccountTitle1.php プロジェクト: rickyx12/protacio

<?php

include "../../myDatabase2.php";
$username = $_POST['username'];
$refNo = $_POST['refNo'];
$accountNo = $_POST['accountNo'];
$accountName = $_POST['accountName'];
$bold = $_POST['bold'];
$ro = new database2();
$ro->editNow("accountTitle", "refNo", $refNo, "accountNo", $accountNo);
$ro->editNow("accountTitle", "refNo", $refNo, "accountTitle", $accountName);
$ro->editNow("accountTitle", "refNo", $refNo, "bold", $bold);
echo "<br><br><br><Br><Br>";
$ro->coconutFormStart("post", "/COCONUT/accounting/chartOfAccounts.php");
$ro->coconutHidden("username", $username);
echo "<center>";
echo "<form><input type='submit' style='border:1px solid #ff0000; font-size:100%;' value='Back to Chart of Accounts'></form>";
$ro->coconutFormStop();

コード例 #17

ファイル: isPackageCash1.php プロジェクト: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$isCash = $_GET['isCash'];
$username = $_GET['username'];
$ro = new database2();
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "isPackageCash", $isCash);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientProfile_right.php?registrationNo={$registrationNo}&username={$username}");

コード例 #18

ファイル: addDoctorsOrder.php プロジェクト: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$itemNo = $_GET['itemNo'];
$username = $_GET['username'];
$chiefComplaints = $_GET['chiefComplaints'];
$doctorsOrder = $_GET['doctorsOrder'];
$ro = new database2();
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "initialDiagnosis", $chiefComplaints);
if ($ro->selectNow("SOAP", "itemNo", "itemNo", $itemNo) == "") {
    $ro->insert_soap($itemNo, $registrationNo, $chiefComplaints, "", "", $doctorsOrder);
} else {
    $ro->editNow("SOAP", "itemNo", $itemNo, "plan", $doctorsOrder);
}
$ro->coconutFormStart("post", "http://" . $ro->getMyUrl() . "/COCONUT/android/doctor/viewPatient_information.php");
$ro->coconutHidden("registrationNo", $registrationNo);
$ro->coconutHidden("itemNo", $itemNo);
$ro->coconutHidden("username", $username);
echo "<br><br><br><br><br><center>";
$ro->coconutBoxStart("400", "60");
echo "<br>";
$ro->coconutButton("Proceed");
$ro->coconutBoxStop();
$ro->coconutFormStop();
?>

コード例 #19

ファイル: finishER1.php プロジェクト: rickyx12/protacio

<?php

include "../../myDatabase2.php";
$registrationNo = $_POST['registrationNo'];
$username = $_POST['username'];
$ro = new database2();
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "finishER", date("Y-m-d") . "@" . date("H:i:s") . "@" . $username);

コード例 #20

ファイル: discharge_new1.php プロジェクト: rickyx12/mendero

<?php

include "../../../myDatabase2.php";
$itemNo = $_GET['itemNo'];
$countItem = count($itemNo);
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new database2();
for ($x = 0; $x < $countItem; $x++) {
    $ro->editNow("room", "Description", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo[$x]), "status", "Vacant");
    $ro->editNow("patientCharges", "itemNo", $itemNo[$x], "status", "Discharged");
}
$ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "dateUnregistered", date("Y-m-d"));
$ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "timeUnregistered", $ro->getSynapseTime());
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "mgh", $username);
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "unregisteredBy", $username);
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "mgh_date", date("Y-m-d") . "@" . $ro->getSynapseTime());
echo "<center><br><Br><Br><font color=red>Patient Discharged</font>";

コード例 #21

ファイル: computeDays1.php プロジェクト: rickyx12/protacio

include "../../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$itemNo = $_GET['itemNo'];
$dateIn = $_GET['dateIn'];
$month = $_GET['month'];
$day = $_GET['day'];
$year = $_GET['year'];
$username = $_GET['username'];
$ro = new database2();
$dateOut = $year . "-" . $month . "-" . $day;
$out = new DateTime($dateOut);
$in = new DateTime($dateIn);
$days = $out->diff($in)->d;
if ($ro->selectNow("patientCharges", "phic", "itemNo", $itemNo) < 1) {
    $ro->editNow("patientCharges", "itemNo", $itemNo, "quantity", $days);
    $ro->editNow("patientCharges", "itemNo", $itemNo, "total", $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $itemNo) * $days);
    $ro->editNow("patientCharges", "itemNo", $itemNo, "cashUnpaid", $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $itemNo) * $days);
    $ro->editNow("patientCharges", "itemNo", $itemNo, "phic", "0");
    $ro->editNow("patientCharges", "itemNo", $itemNo, "company", "0");
    $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientChargesTitle.php?registrationNo={$registrationNo}&title=Room and Board&username={$username}&show=&desc=");
} else {
    $cashUnpaid = $ro->selectNow("patientCharges", "cashUnpaid", "itemNo", $itemNo);
    $hmo = $ro->selectNow("patientCharges", "company", "itemNo", $itemNo);
    $philhealth = $ro->selectNow("patientCharges", "phic", "itemNo", $itemNo);
    $newTotal = $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $itemNo) * $days;
    $ro->editNow("patientCharges", "itemNo", $itemNo, "quantity", $days);
    $ro->editNow("patientCharges", "itemNo", $itemNo, "total", $newTotal);
    $ro->editNow("patientCharges", "itemNo", $itemNo, "cashUnpaid", $newTotal - $philhealth);
    $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientChargesTitle.php?registrationNo={$registrationNo}&title=Room and Board&username={$username}&show=&desc=");
}

コード例 #22

ファイル: deletePHICPayment1.php プロジェクト: rickyx12/mendero

<?php

include "../../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$phicPaymentNo = $_GET['phicPaymentNo'];
$username = $_GET['username'];
$ro = new database2();
$ro->editNow("phicPayment", "phicPaymentNo", $phicPaymentNo, "status", "DELETED_" . $username . "_" . date("Y-m-d"));
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/Payments/viewPHICPayment.php?registrationNo={$registrationNo}&username={$username}");

コード例 #23

ファイル: updateNow.php プロジェクト: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$packageNo = $_GET['packageNo'];
$inventoryCode = $_GET['inventoryCode'];
$qty = $_GET['qty'];
$ro = new database2();
$desc = $ro->selectNow("inventory", "description", "inventoryCode", $inventoryCode);
$inventoryType = $ro->selectNow("inventory", "inventoryType", "inventoryCode", $inventoryCode);
$title = "";
if ($inventoryType == "medicine") {
    $title = "MEDICINE";
} else {
    $title = "SUPPLIES";
}
$ro->editNow("hospitalPackage", "packageNo", $packageNo, "packageIncluded_description", $desc . "_" . $inventoryCode . "_" . $title);
$ro->editNow("hospitalPackage", "packageNo", $packageNo, "packageIncluded_qty", $qty);
echo "<br><br><br><center><font color=red size=4> SUCCESSFULLY UPDATED </font>";

コード例 #24

ファイル: editCharges1.php プロジェクト: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$itemNo = $_POST['itemNo'];
$cash = $_POST['cash'];
$company = $_POST['company'];
$phic = $_POST['phic'];
$company1 = $_POST['company1'];
$ro = new database2();
$ro->editNow("patientCharges", "itemNo", $itemNo, "cashUnpaid", $cash);
$ro->editNow("patientCharges", "itemNo", $itemNo, "company", $company);
$ro->editNow("patientCharges", "itemNo", $itemNo, "phic", $phic);
$ro->editNow("patientCharges", "itemNo", $itemNo, "company1", $company1);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/additionalCompany/transfertoAdditionalCompany.php?registrationNo=" . $ro->selectNow("patientCharges", "registrationNo", "itemNo", $itemNo) . "&mode=");
?>

コード例 #25

ファイル: csrReturn1.php プロジェクト: rickyx12/mendero

<?php

include "../../myDatabase2.php";
$verificationNo = $_POST['verificationNo'];
$inventoryCode = $_POST['inventoryCode'];
$description = $_POST['description'];
$qty = $_POST['qty'];
$borrowerDepartment = $_POST['borrowerDepartment'];
$returnBy = $_POST['returnBy'];
$ro = new database2();
$newQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $inventoryCode) + $qty;
$ro->editNow("inventory", "inventoryCode", $inventoryCode, "quantity", $newQTY);
$ro->csrReturnItem($verificationNo, $inventoryCode, $description, $qty, $borrowerDepartment, $returnBy, date("Y-m-d"), $ro->getSynapseTime());
echo "<br><Br><Br><center><font color=red>{$description} Returned</font>";

コード例 #26

ファイル: nurseStationStatus1.php プロジェクト: rickyx12/mendero

include "../../myDatabase2.php";
$username = $_POST['username'];
$password = $_POST['password'];
$registrationNo = $_POST['registrationNo'];
$status = $_POST['status'];
$station = $_POST['station'];
$timeDischarged = date("H:i:s");
$ro = new database2();
if ($username == "") {
    $ro->getBack("AUTHENTICATION ERROR");
} else {
    if ($password == "") {
        $ro->getBack("AUTHENTICATION ERROR");
    } else {
        if ($username == "" && $password == "") {
            $ro->getBack("AUTHENTICATION ERROR");
        } else {
            if ($ro->getEmployeeId_username($username, $password) != "") {
                if ($status == "Discharged") {
                    $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "timeDischargedFromNS", $timeDischarged);
                } else {
                }
                $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "nurseStationStatus", $status);
                echo " <center><br><br><br><br><br><br>Patient Updated <br>{$status}: {$timeDischarged} <br><br> <form method='post' action='showStationRoom.php'><input type='submit' value='<< Back To Patient List' style='border:1px solid #ff0000; background-color:transparent; height:40px; ' ><input type='hidden' name='station' value='{$station}' > </form>";
            } else {
                $ro->getBack("AUTHENTICATION ERROR");
            }
        }
    }
}

コード例 #27

ファイル: select_prePackage1.php プロジェクト: rickyx12/protacio

<?php

include "../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$package = $_GET['package'];
$ro = new database2();
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "prePackage", $package);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientProfile_handler.php?registrationNo={$registrationNo}&username={$username}");

コード例 #28

ファイル: editItem1.php プロジェクト: rickyx12/protacio

<?php

include "../../myDatabase2.php";
$packageNo = $_GET['packageNo'];
$packageName = $_GET['packageName'];
$price = $_GET['price'];
$ro = new database2();
$ro->editNow("hospitalPackage", "packageNo", $packageNo, "Added", $price);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/hospitalPackage/showAddedPackage_update.php?packageName={$packageName}");

コード例 #29

ファイル: consumedRoom.php プロジェクト: rickyx12/protacio

<?php

include "../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$targetAmount = $_GET['targetAmount'];
$ro = new database2();
$itemz = preg_split("/\\_/", $ro->getMaximumTotal_rBanny($registrationNo, "Room and Board"));
$ro->getPatientChargesToEdit($itemz[1]);
if ($ro->getTotal("cashUnpaid", "Room And Board", $registrationNo) > 0) {
    echo "<br><Br><br><br><br>";
    echo "<font color=red>R-Banny is now Calculating Room</font><br>";
    echo "Total:&nbsp;" . $itemz[0];
    echo "<br>";
    echo "Item#:&nbsp;" . $itemz[1];
    if ($targetAmount >= $itemz[0]) {
        $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", "0");
        $ro->editNow("patientCharges", "itemNo", $itemz[1], "Company", "0");
        $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $itemz[0]);
    } else {
        //echo "<br><Br><br><br><font color=blue size=5>R-Banny is Having a trouble in Computation</font>";
        $newCash = $itemz[0] - $targetAmount;
        $newPHIC = $ro->selectNow("patientCharges", "total", "itemNo", $itemz[1]) - $newCash;
        $ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", $newCash);
        $ro->editNow("patientCharges", "itemNo", $itemz[1], "Company", "0");
        $ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $newPHIC);
    }
    $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/rBanny/consumedRoom.php?registrationNo={$registrationNo}&targetAmount={$targetAmount}");
} else {
    $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/rBanny/consumedMeds.php?registrationNo={$registrationNo}&targetAmount={$targetAmount}");
}

コード例 #30

ファイル: deleteCompanyPayment1.php プロジェクト: rickyx12/protacio

<?php

include "../../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$refNo = $_GET['refNo'];
$username = $_GET['username'];
$ro = new database2();
$ro->editNow("companyPayment", "refNo", $refNo, "status", "DELETED_" . $username . "_" . date("Y-m-d"));
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/Payments/viewCompanyPayment.php?registrationNo={$registrationNo}&username={$username}");