PHP storedProcedure Examples

Example #1

File: discharged1.php Project: rickyx12/mendero

<?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 {
    echo "alert('Patient is now Active');";

Example #2

File: requestForm1.php Project: rickyx12/protacio

<?php

include "../../../storedProcedure.php";
$description = $_POST['description'];
$qty = $_POST['qty'];
$price = $_POST['price'];
$total = $_POST['total'];
$username = $_POST['username'];
$password = $_POST['password'];
$ro = new storedProcedure();
$ro->requestLog($username, $password);
if ($username == "" && $password == "") {
    echo "<script type='text/javascript'>";
    echo "alert('Authentication Error');";
    echo "window.back(-1)";
    echo "</script>";
} else {
    $username1 = mysql_real_escape_string(strip_tags($username));
    $password1 = mysql_real_escape_string(strip_tags($password));
    $description1 = mysql_real_escape_string(strip_tags($description));
    $qty1 = mysql_real_escape_string(strip_tags($qty));
    $price1 = mysql_real_escape_string(strip_tags($price));
    $total1 = mysql_real_escape_string(strip_tags($total));
    if ($username == $ro->requestLog_username() && $password == $ro->requestLog_password()) {
        $ro->request2admin($description1, $qty1, $price1, $total1, $username1, getenv("REMOTE_ADDR") . "-" . php_uname("n"), $ro->getSynapseTime(), date("Y-m-d"));
        echo "<script type='text/javascript'>";
        echo "alert('Request Delivered!');";
        echo "window.location='http://" . $ro->getMyUrl() . "/LOGINPAGE/module.php'";
        echo "</script>";
    } else {
        echo "<script type='text/javascript'>";

Example #3

File: setMGH1.php Project: rickyx12/protacio

<?php

include "../../../storedProcedure.php";
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$ro = new storedProcedure();
$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"));
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientProfile_handler.php?registrationNo={$registrationNo}&username={$username}");

Example #4

File: addMe_jul-13-2015.php Project: rickyx12/protacio

include "../../storedProcedure.php";
$status = $_GET['status'];
$registrationNo = $_GET['registrationNo'];
$chargesCode = $_GET['chargesCode'];
$description = $_GET['description'];
$sellingPrice = $_GET['sellingPrice'];
$discount = $_GET['discount'];
$timeCharge = $_GET['timeCharge'];
$chargeBy = $_GET['chargeBy'];
$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 = "";
$paycash = $_GET['paycash'];
$remarks = $_GET['remarks'];
$ro = new storedProcedure();
$cashUnpaid = 0;
$phic = 0;
$company = 0;
$ro->getPatientProfile($registrationNo);
$dateCharge = date("Y-m-d");
$currentTotal = $quantity * $sellingPrice;
$totalDiscount = 0;
$grandTotal = $currentTotal - $totalDiscount;
$ro->addCharges_cash_noInventory($status, $registrationNo, $chargesCode, $description, $sellingPrice, $totalDiscount, $grandTotal, $grandTotal, 0, 0, $timeCharge, $dateCharge, $username, $service, $title, $paidVia, $cashPaid, $batchNo, $quantity, $inventoryFrom, $ro->getRegistrationDetails_branch(), $room);

Example #5

File: approvalLog.php Project: rickyx12/protacio

<?php

include "../../../storedProcedure.php";
$ro = new storedProcedure();
$ro->coconutDesign();
?>

<link rel="stylesheet" type="text/css" href="http://<?php 
echo $ro->getMyUrl();
?>
/COCONUT/flow/rickyCSS1.css" />

<script type='text/javascript'>
$("#breadcrumbs a").hover(
    function () {
        $(this).addClass("hover").children().addClass("hover");
        $(this).parent().prev().find("span.arrow:first").addClass("pre_hover");
    },
    function () {
        $(this).removeClass("hover").children().removeClass("hover");
        $(this).parent().prev().find("span.arrow:first").removeClass("pre_hover");
    }
);
</script>

<ol id="breadcrumbs">

      
        <li><a href="http://<?php 
echo $ro->getMyUrl();
?>

Example #6

File: requestStatus.php Project: rickyx12/protacio

<?php

include "../../../storedProcedure.php";
$date = $_POST['date'];
$ro = new storedProcedure();
echo "<center>";
$ro->coconutTableStart();
$ro->coconutTableRowStart();
$ro->coconutTableHeader("Description");
$ro->coconutTableHeader("QTY");
$ro->coconutTableHeader("Price");
$ro->coconutTableHeader("Total");
$ro->coconutTableHeader("Request By");
$ro->coconutTableHeader("Status");
$ro->coconutTableHeader("Released By");
$ro->coconutTableHeader("Released To");
$ro->coconutTableHeader("Amount Released");
$ro->coconutTableRowStart();
$ro->coconutTableData("<font color=red>Approved</font>");
$ro->coconutTableData("");
$ro->coconutTableData("");
$ro->coconutTableData("");
$ro->coconutTableData("");
$ro->coconutTableData("");
$ro->coconutTableData("");
$ro->coconutTableData("");
$ro->coconutTableData("");
$ro->coconutTableRowStop();
$ro->requestStatusReport($date, "APPROVED");
$ro->coconutTableRowStart();
$ro->coconutTableData("");

Example #7

File: totalApproved.php Project: rickyx12/protacio

<?php

include "../../../storedProcedure.php";
$date = $_POST['date'];
$ro = new storedProcedure();
$ro->adminApproved($date);

Example #8

File: requestStatus_date.php Project: rickyx12/protacio

<?php

include "../../../storedProcedure.php";
$date = $_GET['date'];
$ro = new storedProcedure();
$ro->coconutDesign();
echo "<script src='http://" . $ro->getMyUrl() . "/COCONUT/js/jquery-1.9.1.js'></script>";
echo "<script src='http://" . $ro->getMyUrl() . "/COCONUT/js/jquery-ui.js'></script>";
echo "<link rel='stylesheet' type='text/css' href='http://" . $ro->getMyUrl() . "/COCONUT/myCSS/jquery-ui.css' />";
echo "<script>";
echo "\$(function() {\n\$('#date').datepicker({ 'dateFormat':'yy-mm-dd' });\n});\n";
echo "</script>";
echo "<br><Br><br><br><br>";
$ro->coconutFormStart("post", "requestStatus.php");
$ro->coconutBoxStart("500", "100");
echo "<br>";
echo "<table border=0>";
echo "<tr>";
echo "<Td>Date</td>";
echo "<Td>";
$ro->coconutTextBox("date", $date);
echo "</td>";
echo "</tr>";
echo "</table>";
echo "<br>";
$ro->coconutButton("Proceed");
$ro->coconutBoxStop();
$ro->coconutFormStop();

Example #9

File: viewApprovedRequest.php Project: rickyx12/protacio

<?php

include "../../../storedProcedure.php";
$username = $_GET['username'];
$date = $_GET['date'];
$ro = new storedProcedure();
$ro->showApprovedRequest($date, $username);

Example #10

File: table.php Project: rickyx12/protacio

<?php

include "../../../storedProcedure.php";
require_once '../authentication.php';
$date = $_POST['date'];
$username = $_POST['username'];
$makeDo = $_POST['makeDo'];
$ro = new storedProcedure();
echo "<html>";
echo "<head>";
if ($makeDo == "putStatus") {
    if (isset($_POST['requestNo']) && isset($_POST['status'])) {
        $requestNo = $_POST['requestNo'];
        $status = $_POST['status'];
        $ro->editNow("admin2request", "requestNo", $requestNo, "status", $status . "_" . $username);
        $ro->editNow("admin2request", "requestNo", $requestNo, "status_time", $ro->getSynapseTime());
        $ro->editNow("admin2request", "requestNo", $requestNo, "status_date", date("Y-m-d"));
        $ro->editNow("admin2request", "requestNo", $requestNo, "status_encodeIn", getenv("REMOTE_ADDR") . "-" . php_uname("n"));
    } else {
    }
}
?>



<link rel="stylesheet" type="text/css" href="http://<?php 
echo $ro->getMyUrl();
?>
/COCONUT/flow/rickyCSS1.css" />

<script type='text/javascript'>

Example #11

File: searchTransaction1.php Project: rickyx12/protacio

<?php

include "../../storedProcedure.php";
$patientName = $_GET['patientName'];
$month = $_GET['month'];
$day = $_GET['day'];
$year = $_GET['year'];
$fromTime_hour = $_GET['fromTime_hour'];
$fromTime_minutes = $_GET['fromTime_minutes'];
$fromTime_seconds = $_GET['fromTime_seconds'];
$toTime_hour = $_GET['toTime_hour'];
$toTime_minutes = $_GET['toTime_minutes'];
$toTime_seconds = $_GET['toTime_seconds'];
$username = $_GET['username'];
$ro = new storedProcedure();
$ro->searchTransactionPatient($patientName, $month, $day, $year, $fromTime_hour, $fromTime_minutes, $fromTime_seconds, $toTime_hour, $toTime_minutes, $toTime_seconds, $username);

Example #12

File: addChargesSyringe.php Project: rickyx12/protacio

$paidVia2 = $_GET['paidVia2'];
$cashPaid2 = $_GET['cashPaid2'];
$batchNo2 = $_GET['batchNo2'];
$username2 = $_GET['username2'];
$discount2 = $_GET['discount2'];
$inventoryFrom2 = $_GET['inventoryFrom2'];
$room2 = $_GET['room2'];
$paycash2 = $_GET['paycash2'];
$remarks2 = $_GET['remarks2'];
$docSpecialization = "";
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 {
        $dateCharge = date("Y-m-d");
        $currentTotal = $quantity * $sellingPrice;
        $totalDiscount = 0;
        $grandTotal = $currentTotal - $totalDiscount;
        //check autoDispense????

Example #13

File: getTable.php Project: rickyx12/protacio

<?php

include "../../../storedProcedure.php";
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 

Example #14

File: upload (copy).php Project: rickyx12/protacio

<?php

include "../../storedProcedure.php";
$username = $_POST['username'];
//If directory doesnot exists create it.
$output_dir = "xXxuserFilesxXx/";
$ro = new storedProcedure();
if (isset($_FILES["myfile"])) {
    $ret = array();
    $error = $_FILES["myfile"]["error"];
    if (!is_array($_FILES["myfile"]['name'])) {
        $fileName = $_FILES["myfile"]["name"] . $_POST['username'];
        move_uploaded_file($_FILES["myfile"]["tmp_name"], $output_dir . $_FILES["myfile"]["name"]);
        $ro->uploadedFilesInformation($_FILES["myfile"]["name"], "COCONUT/uploader/" . $output_dir . $_FILES["myfile"]["name"], $username);
        //echo "<br> Error: ".$_FILES["myfile"]["error"];
        $ret[$fileName] = $output_dir . $fileName;
    } else {
        $fileCount = count($_FILES["myfile"]['name']);
        for ($i = 0; $i < $fileCount; $i++) {
            $fileName = $_FILES["myfile"]["name"][$i];
            $ret[$fileName] = $output_dir . $fileName;
            move_uploaded_file($_FILES["myfile"]["tmp_name"][$i], $output_dir . $fileName);
            $ro->uploadedFilesInformation($_FILES["myfile"]["name"], "COCONUT/uploader/" . $output_dir . $_FILES["myfile"]["name"], $username);
        }
    }
    echo json_encode($ret);
}

Example #15

File: addMe_date.php Project: rickyx12/protacio

$title = $_GET['title'];
$paidVia = $_GET['paidVia'];
$cashPaid = $_GET['cashPaid'];
$batchNo = $_GET['batchNo'];
$username = $_GET['username'];
$quantity = $_GET['quantity'];
$inventoryFrom = $_GET['inventoryFrom'];
$room = "";
$paycash = $_GET['paycash'];
$remarks = $_GET['remarks'];
echo "<script src='../js/jquery-2.1.4.min.js'></script>";
echo "<script src='../js/jquery-ui.min.js'></script>";
echo "<link rel='stylesheet' href='../myCSS/coconutCSS.css'></link>";
echo "<link rel='stylesheet' href='../myCSS/jquery-ui.css'></link>";
echo "\n\n<script>\n\t\$(document).ready(function(){\n\t\t\$('#dateCharge').datepicker({\n\t\t\tdateFormat:'yy-mm-dd'\n\t\t});\n\t});\n</script>\n\n";
$ro = new storedProcedure();
$ro->coconutDesign();
$ro->coconutFormStart("get", "http://" . $ro->getMyUrl() . "/COCONUT/availableMedicine/addMe.php");
echo "<br><br>";
$ro->coconutBoxStart("500", "100");
echo "<Br>";
echo "<font color=red>{$description}</font>";
echo "<br>";
echo "<table border=0>";
echo "<tr>";
echo "<Td>Date Charge&nbsp;</td>";
echo "<Td>";
/*
$ro->coconutComboBoxStart_short("month");
echo "<option value='".date("m")."'>".date("M")."</option>";
echo "<option value='01'>Jan</option>";

Example #16

File: upload.php Project: rickyx12/mendero

<?php

include "../../storedProcedure.php";
$username = $_POST['username'];
$parameterz = preg_split("/\\-/", $username);
//If directory doesnot exists create it.
$output_dir = "xXxdicomxXx/";
$ro = new storedProcedure();
if (isset($_FILES["myfile"])) {
    $ret = array();
    $error = $_FILES["myfile"]["error"];
    if (!is_array($_FILES["myfile"]['name'])) {
        $fileName = $_FILES["myfile"]["name"] . $_POST['username'];
        move_uploaded_file($_FILES["myfile"]["tmp_name"], $output_dir . $_FILES["myfile"]["name"]);
        $ro->uploadedFilesInformation($_FILES["myfile"]["name"], "/COCONUT/uploader/" . $output_dir . $_FILES["myfile"]["name"], $parameterz[0], $parameterz[2], $parameterz[1]);
        //echo "<br> Error: ".$_FILES["myfile"]["error"];
        $ret[$fileName] = $output_dir . $fileName;
    } else {
        $fileCount = count($_FILES["myfile"]['name']);
        for ($i = 0; $i < $fileCount; $i++) {
            $fileName = $_FILES["myfile"]["name"][$i];
            $ret[$fileName] = $output_dir . $fileName;
            move_uploaded_file($_FILES["myfile"]["tmp_name"][$i], $output_dir . $fileName);
            $ro->uploadedFilesInformation($_FILES["myfile"]["name"], "/COCONUT/uploader/" . $output_dir . $_FILES["myfile"]["name"], $username, $itemNo, $registrationNo);
        }
    }
    echo json_encode($ret);
}

Example #17

File: addCharges.php Project: rickyx12/mendero

$description = $_GET['description'];
$sellingPrice = $_GET['sellingPrice'];
$discount = $_GET['discount'];
$timeCharge = $_GET['timeCharge'];
$chargeBy = $_GET['chargeBy'];
$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}");

Example #18

File: patientList_storedProc.php Project: rickyx12/protacio

<?php

include "../storedProcedure.php";
$month = $_GET['month'];
$day = $_GET['day'];
$year = $_GET['year'];
$fromTime_hour = $_GET['fromTime_hour'];
$fromTime_minutes = $_GET['fromTime_minutes'];
$fromTime_seconds = $_GET['fromTime_seconds'];
$toTime_hour = $_GET['toTime_hour'];
$toTime_minutes = $_GET['toTime_minutes'];
$toTime_seconds = $_GET['toTime_seconds'];
$module = $_GET['module'];
$username = $_GET['username'];
$branch = $_GET['branch'];
$ro = new storedProcedure();
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>";
echo "\n<table border=1 cellpadding=0 cellspacing=0 rules=all>\n<tr>\n<th>&nbsp;Name&nbsp;</th>\n<th>&nbsp;Amount&nbsp;</th>\n</tr>";
$ro->getTransactionPatient($month, $day, $year, $fromTime_hour, $fromTime_minutes, $fromTime_seconds, $toTime_hour, $toTime_minutes, $toTime_seconds, $module, $branch, $username);
echo "</table>";