PHP storedProcedure::selectNowの例

コード例 #1

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

$service = $_GET['service'];
$title = $_GET['title'];
$paidVia = $_GET['paidVia'];
$cashPaid = $_GET['cashPaid'];
$batchNo = $_GET['batchNo'];
$username = $_GET['username'];
$quantity = $_GET['quantity'];
$inventoryFrom = $_GET['inventoryFrom'];
$room = $_GET['room'];
$paycash = $_GET['paycash'];
$ro = new storedProcedure();
$cashUnpaid = 0;
$phic = 0;
$company = 0;
$ro->getPatientProfile($registrationNo);
if ($title == "MEDICINE" && $ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode) < $quantity) {
    $ro->getBack("Sorry, Not Enough Stock");
} else {
    if ($title == "SUPPLIES" && $ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode) < $quantity) {
        $ro->getBack("Sorry, Not Enough Stock");
    } else {
        if ($title == "MISCELLANEOUS") {
            $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/availableCharges/quantityMisc.php?status={$status}&registrationNo={$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 {
            if ($title == "OXYGEN") {
                $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/availableCharges/quantityMisc.php?status={$status}&registrationNo={$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 {
                if ($title == "NURSING-CHARGES") {
                    $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/availableCharges/quantityMisc.php?status={$status}&registrationNo={$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 {
                    if ($description == "HAND SCRUBBING FEE/PERSON") {

コード例 #2

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

if (isset($_GET['stockCardNo'])) {
    $stockCardNo = $_GET['stockCardNo'];
} else {
    $stockCardNo = "";
}
if (isset($_GET['doctorSpecialization'])) {
    $docSpecialization = $_GET['doctorSpecialization'];
} else {
    $docSpecialization = "";
}
$ro = new storedProcedure();
$cashUnpaid = 0;
$phic = 0;
$company = 0;
$ro->getPatientProfile($registrationNo);
if ($title == "MEDICINE" && $ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode) < $quantity) {
    $ro->getBack("Sorry, Not Enough Stock");
} else {
    if ($title == "SUPPLIES" && $ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode) < $quantity) {
        $ro->getBack("Sorry, Not Enough Stock");
    } else {
        if ($title == "MISCELLANEOUS") {
            $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/availableCharges/quantityMisc.php?status={$status}&registrationNo={$registrationNo}&chargesCode={$chargesCode}&description={$description}&sellingPrice={$sellingPrice}&discount={$discount}&dateCharge={$timeCharge}&room={$room}&chargeBy={$chargeBy}&service={$service}&title={$title}&paidVia={$paidVia}&cashPaid={$cashPaid}&batchNo={$batchNo}&username={$username}&inventoryFrom={$inventoryFrom}");
        } else {
            if ($title == "OXYGEN") {
                $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/availableCharges/quantityMisc.php?status={$status}&registrationNo={$registrationNo}&chargesCode={$chargesCode}&description={$description}&sellingPrice={$sellingPrice}&discount={$discount}&dateCharge={$timeCharge}&room={$room}&chargeBy={$chargeBy}&service={$service}&title={$title}&paidVia={$paidVia}&cashPaid={$cashPaid}&batchNo={$batchNo}&username={$username}&inventoryFrom={$inventoryFrom}");
            } else {
                if ($title == "NURSING-CHARGES") {
                    $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/availableCharges/quantityMisc.php?status={$status}&registrationNo={$registrationNo}&chargesCode={$chargesCode}&description={$description}&sellingPrice={$sellingPrice}&discount={$discount}&dateCharge={$timeCharge}&room={$room}&chargeBy={$chargeBy}&service={$service}&title={$title}&paidVia={$paidVia}&cashPaid={$cashPaid}&batchNo={$batchNo}&username={$username}&inventoryFrom={$inventoryFrom}");
                } else {
                    //$dateCharge = $year."-".$month."-".$day;

コード例 #3

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

<?php

include "../../../storedProcedure.php";
$registrationNo = $_GET['registrationNo'];
$protoType = $_GET['protoType'];
$room = $_GET['room'];
$username = $_GET['username'];
$ro = new storedProcedure();
if ($protoType == "Discharged") {
    $ro->EditNow("room", "Description", $room, "Status", "Vacant");
    $ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "dateUnregistered", date("Y-m-d"));
    $ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "timeUnregistered", $ro->getSynapseTime());
    $ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "unregisteredBy", $username);
    if ($ro->selectNow("registrationDetails", "type", "registrationNo", $registrationNo) == "OPD") {
        $ro->lockedAccountItems($registrationNo, date('Y-m-d H:i:s'), $username);
        $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "mgh", "yes_" . $username);
        $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "mgh_date", date("Y-m-d"));
    } else {
    }
} else {
    $ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "dateUnregistered", "");
    $ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "timeUnregistered", "");
    $ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "room", "");
    $ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "unregisteredBy", "");
    $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "mgh", "");
    $ro->editNow("registrationDetails", "registrationNo", $registrationNo, "mgh_date", "");
}
echo "\n<script type='text/javascript'>";
if ($protoType == "Discharged") {
    echo "alert('Patient is now Discharged');";
} else {

コード例 #4

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

require_once '../authentication.php';
$date = $_POST['date'];
$username = $_POST['username'];
$ro = new storedProcedure();
echo "<html>";
echo "<head>";
echo "<script src='http://" . $ro->getMyUrl() . "/jquery.js'></script>";
echo "<script>";
?>

function playBuzzer(){
        $("body").append("<embed src='/COCONUT/bell.mp3' autostart='true' loop='false' width='2' height='0'></embed>");
}

<?php 
if ($ro->totalRequest($date) != $ro->selectNow("admin2request_forApproved_total", "currentTotal", "code", "1")) {
    if ($ro->totalRequest($date) > $ro->selectNow("admin2request_forApproved_total", "currentTotal", "code", "1")) {
        ?>
playBuzzer();
<?php 
    } else {
    }
    $ro->editNow("admin2request_forApproved_total", "code", "1", "currentTotal", $ro->totalRequest($date));
} else {
}
?>

<?php 
if ($ro->totalRequest($date) > 0) {
    echo "   \nvar title = document.title;\ndocument.title = (title == 'For Approval' ? '(" . $ro->totalRequest($date) . ") New Request' : 'For Approval');";
} else {

コード例 #5

ファイル: addCharges_Feb-2-2015.php プロジェクト: rickyx12/mendero

$service = $_GET['service'];
$title = $_GET['title'];
$paidVia = $_GET['paidVia'];
$cashPaid = $_GET['cashPaid'];
$batchNo = $_GET['batchNo'];
$username = $_GET['username'];
$quantity = $_GET['quantity'];
$inventoryFrom = $_GET['inventoryFrom'];
$room = $_GET['room'];
$paycash = $_GET['paycash'];
$ro = new storedProcedure();
$cashUnpaid = 0;
$phic = 0;
$company = 0;
$ro->getPatientProfile($registrationNo);
if ($title == "MEDICINE" && $ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode) < $quantity) {
    $ro->getBack("Sorry, Not Enough Stock");
} else {
    if ($title == "SUPPLIES" && $ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode) < $quantity) {
        $ro->getBack("Sorry, Not Enough Stock");
    } else {
        if ($title == "MISCELLANEOUS") {
            $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/availableCharges/quantityMisc.php?status={$status}&registrationNo={$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 {
            if ($title == "OXYGEN") {
                $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/availableCharges/quantityMisc.php?status={$status}&registrationNo={$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 {
                if ($title == "NURSING-CHARGES") {
                    $ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/availableCharges/quantityMisc.php?status={$status}&registrationNo={$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 {
                    if ($description == "HAND SCRUBBING FEE/PERSON") {