<?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');";
<?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'>";
<?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}");
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);
<?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(); ?>
<?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("");
<?php include "../../../storedProcedure.php"; $date = $_POST['date']; $ro = new storedProcedure(); $ro->adminApproved($date);
<?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();
<?php include "../../../storedProcedure.php"; $username = $_GET['username']; $date = $_GET['date']; $ro = new storedProcedure(); $ro->showApprovedRequest($date, $username);
<?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'>
<?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);
$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????
<?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
<?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); }
$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 </td>"; echo "<Td>"; /* $ro->coconutComboBoxStart_short("month"); echo "<option value='".date("m")."'>".date("M")."</option>"; echo "<option value='01'>Jan</option>";
<?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); }
$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}®istrationNo={$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}®istrationNo={$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}");
<?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> <font size=2 color=red>{$branch}</font> "; echo "<br><font size=1>DATE:</font> <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> Name </th>\n<th> Amount </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>";