<?php
include "../../myDatabase.php";
include "../../myDatabase4.php";
$ro = new database();
$ro4 = new database4();
$ro4->ending_inventory_list();
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<script src="../../jquery-2.1.4.min.js"></script>
<link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link>
<script src="../../bootstrap-3.3.6/js/bootstrap.js"></script>
<script>
$(document).ready(function(){
$("#medicineBtn").click(function(){
window.location = "inventory-ending-comparison-medicine.php";
});
});
</script>
</head>
<body>
<div class="container">
<h3>Ending Inventory Supplies</h3>
<div class="btn-group">
<button id="medicineBtn" type="button" class="btn btn-default">Medicine</button>
<?php
require_once "../authentication.php";
include "../../myDatabase.php";
include "../../myDatabase4.php";
$inventoryLocation = $_POST['inventoryLocation'];
$batchNo = $_POST['batchNo'];
$registrationNo = $_POST['registrationNo'];
$pharmacyClass = "";
$nursingClass = "";
$orClass = "";
$erClass = "";
$ro = new database();
$ro4 = new database4();
$ro4->charges_cart($batchNo, $registrationNo);
if ($inventoryLocation == "PHARMACY") {
$pharmacyClass = "btn btn-success";
} else {
$pharmacyClass = "btn btn-default";
}
if ($inventoryLocation == "NURSING") {
$nursingClass = "btn btn-success";
} else {
$nursingClass = "btn btn-default";
}
if ($inventoryLocation == "OR") {
$orClass = "btn btn-success";
} else {
$orClass = "btn btn-default";
}
if ($inventoryLocation == "E.R") {
<?php
require_once "../authentication.php";
include "../../myDatabase.php";
include "../../myDatabase4.php";
$desc = $_POST['desc'];
$inventoryLocation = $_POST['inventoryLocation'];
$batchNo = $_POST['batchNo'];
$registrationNo = $_POST['registrationNo'];
$ro = new database();
$ro4 = new database4();
$ro4->search_inventory($desc, $inventoryLocation);
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title></title>
<script src="../js/open.js"></script>
<script src="../js/jquery.jstepper.min.js"></script>
<link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link>
<script>
$(document).ready(function(){
<?php
foreach ($ro4->search_inventory_inventoryCode() as $inventoryCode) {
?>
var qty = "<?php
<?php
include "../../myDatabase.php";
include "../../myDatabase4.php";
?>
<?php
$date1 = $_GET['date1'];
$date2 = $_GET['date2'];
$phicTotal = 0;
$ro = new database();
$ro4 = new database4();
$ro4->inpatient_discharged($date1, $date2);
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
<meta charset="UTF-8">
<script src="../../jquery-2.1.4.min.js"></script>
<script src="../js/jquery-ui.min.js"></script>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link>
<link rel="stylesheet" href="../js/jquery-ui.css"></link>
<link rel="stylesheet" href="../js/jquery-ui.theme.min.css"></link>
<script>
$(document).ready(function(){
$(".date").datepicker({
dateFormat:'yy-mm-dd',
});
<?php
include "../../../myDatabase.php";
include "../../../myDatabase4.php";
$chargesCode = $_POST['chargesCode'];
$date1 = $_POST['date1'];
$date2 = $_POST['date2'];
$ro = new database();
$ro4 = new database4();
$price = $ro->selectNow("availableCharges", "WARD", "chargesCode", $chargesCode);
$census = $ro4->count_charges($chargesCode, $date1, $date2, "IPD");
//if( $census > 0 ) {
echo $census . "-" . number_format($price * $census, 2);
//}else {
//echo " - ";
//}
<?php include "../../myDatabase3.php"; include "../../myDatabase4.php"; $date1 = $_GET['date1']; $date2 = $_GET['date2']; $totalCr = 0; ?> <?php $ro3 = new database3(); $ro4 = new database4(); ?> <?php $ro3->creditCardPatient($date1, $date2); ?> <!DOCTYPE html> <html> <head> <title></title> <meta charset="UTF-8"> <script src="../../jquery-2.1.4.min.js"></script> <script src="../js/jquery-ui.min.js"></script> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link> <link rel="stylesheet" href="../js/jquery-ui.css"></link> <link rel="stylesheet" href="../js/jquery-ui.theme.min.css"></link>
<?php
require_once "../authentication.php";
include "../../myDatabase.php";
include "../../myDatabase4.php";
$ro = new database();
$ro4 = new database4();
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Emergency Room</title>
<script src="../js/jquery-2.1.4.min.js"></script>
<script src="../js/jquery-ui.min.js"></script>
<script src="../js/jquery.fixedMenu.js"></script>
<script src="../js/open.js"></script>
<link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link>
<link rel="stylesheet" href="../../Registration/menu/fixedMenu_style1.css"></link>
<link rel="stylesheet" href="../myCSS/jquery-ui.css"></link>
<link rel="stylesheet" href="../myCSS/breadcrumb.css"></link>
<script>
$(document).ready(function(){
$(".menu").fixedMenu();
$("#searchPx").click(function(){
var data = {
username:'******'registeredUser', 'username', 'employeeID', $_SESSION['employeeID']);
<?php
include "../../myDatabase4.php";
include "../../myDatabase.php";
session_start();
$ro = new database4();
$ro1 = new database();
$ro->inventory_list("medicine");
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<script src="../../jquery-2.1.4.min.js"></script>
<script src="../js/jquery-ui.min.js"></script>
<script src="../js/jquery.tooltipster.min.js"></script>
<script src="../../bootstrap-3.3.6/js/bootstrap.js"></script>
<link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link>
<link rel="stylesheet" href="../js/jquery-ui.css"></link>
<link rel="stylesheet" href="../js/jquery-ui.theme.min.css"></link>
<link rel="stylesheet" href="../myCSS/tooltipster.css"></link>
<link rel="stylesheet" href="../myCSS/tooltipster-noir.css"></link>
<script>
$(document).ready(function(){
<?php
foreach ($ro->inventory_list_inventoryCode() as $inventoryCode) {
?>
<?php
if (isset($_POST['year'])) {
$year = $_POST['year'];
} else {
$year = date("Y");
}
?>
<?php
$wordMonth = array("01" => "January", "02" => "February", "03" => "March", "04" => "April", "05" => "May", "06" => "June", "07" => "July", "08" => "August", "09" => "September", "10" => "October", "11" => "November", "12" => "December");
?>
<?php
$ro = new database();
$ro4 = new database4();
?>
<?php
$balanceTotal = 0;
?>
<?php
$ro4->inpatient_discharged($year . "-" . $month . "-01", $year . "-" . $month . "-31");
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title></title>
<?php
include "../../myDatabase.php";
include "../../myDatabase4.php";
$title = $_GET['title'];
$ro = new database();
$ro4 = new database4();
$ro4->charges_list($title);
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title></title>
<script src="../js/jquery-2.1.4.min.js"></script>
<link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link>
<script>
$(document).ready(function(){
var isChrome = /Chrome/.test(navigator.userAgent) && /Google Inc/.test(navigator.vendor);
if( isChrome == true ) {
$("#export").click(function(){
var data='<table>'+$("#chargesList").html().replace(/<a\/?[^>]+>/gi, '')+'</table>';
var reportName = '<?php
echo $title . ' [' . $ro4->formatDate(date('Y-m-d')) . ']';
?>
';
$('body').prepend("<form method='post' action='../../export-to-excel/exporttoexcel.php' style='display:none' id='ReportTableData'><input type='text' name='tableData' value='"+data+"' ><input type='text' name='reportName' value='"+reportName+"'></form>");
$('#ReportTableData').submit().remove();
return false;
<?php
require_once "../authentication.php";
include "../../myDatabase.php";
include "../../myDatabase4.php";
$invoiceNo = $_POST['invoiceNo'];
$supplier = $_POST['supplier'];
$terms = $_POST['terms'];
$date = $_POST['date'];
$ro = new database();
$ro4 = new database4();
$purchaseDate = date("Ymd");
$counterDate = $ro->selectNow("counters", "counterDate", "id", "1");
$counter01 = $ro->selectNow("counters", "counter01", "id", "1");
if ($purchaseDate != $counterDate) {
$ro->editNow("counters", "id", "1", "counterDate", $purchaseDate);
$ro->editNow("counters", "id", "1", "counter01", "0");
} else {
$newCounter01 = $counter01 + 1;
$ro->editNow("counters", "counterdate", $purchaseDate, "counter01", $newCounter01);
}
if ($counter01 < 10) {
$sino = date("Ymd") . "000" . $counter01;
} else {
if ($counter01 > 9 && $counter01 < 100) {
$sino = date("Ymd") . "00" . $counter01;
} else {
if ($counter01 > 99 && $counter01 < 1000) {
$sino = date("Ymd") . "0" . $counter01;
} else {
$sino = date("Ymd") . $counter01;
$opd_medicine = $_POST['opd_medicine']; $opd_supplies = $_POST['opd_supplies']; $opd_spyrometry = $_POST['opd_spyrometry']; $opd_derma = $_POST['opd_derma']; $opd_others = $_POST['opd_others']; $opd_OR = $_POST['opd_OR']; $opd_PT = $_POST['opd_PT']; $opd_OT = $_POST['opd_OT']; $opd_ST = $_POST['opd_ST']; $opd_cardiacMonitor = $_POST['opd_cardiacMonitor']; $opd_PF_payable = $_POST['opd_PF_payable']; $opd_misc = $_POST['opd_misc']; $opd_OT_payables = $_POST['opd_OT_payables']; $opd_ST_payables = $_POST['opd_ST_payables']; $ro2 = new database2(); $ro4 = new database4(); $lab; $labTotal = 0; $xray; $xrayTotal = 0; $utz; $utzTotal = 0; $ctscan; $ctscanTotal = 0; $ecg; $ecgTotal = 0; $erfee; $erfeeTotal = 0; $or; $orTotal = 0; $misc;
<?php
include "../../myDatabase.php";
include "../../myDatabase4.php";
$ro = new database();
$ro4 = new database4();
$ro4->inventory_list("supplies");
?>
<!doctype html>
<html>
<head>
<title>Movement</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<script src="../../jquery-2.1.4.min.js"></script>
<link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link>
<script src="../../bootstrap-3.3.6/js/bootstrap.js"></script>
<script>
$(document).ready(function() {
$("#medicineBtn").click(function(){
window.location = "movement-medicine.php";
//console.log("123");
});
});
</script>
</head>
<body>
<div class="container">
<div class="row">
<?php
include "../../myDatabase4.php";
include "../../myDatabase.php";
$ro = new database4();
$ro1 = new database();
$reportDate;
if (isset($_POST["date"])) {
$reportDate = $_POST["date"];
} else {
$reportDate = date("Y-m-d");
}
?>
<!doctype html>
<html>
<head>
<title>HMO SHIFTING</title>
<script language="javascript" src="../js/jquery-2.1.4.min.js"></script>
<script langugae="javascript" src="../js/jquery-ui.min.js"></script>
<script language="javascript" src="../../bootstrap-3.3.6/js/bootstrap.min.js"></script>
<link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link>
<link rel="stylesheet" href="../js/jquery-ui.css"></link>
<link rel="stylesheet" href="../js/jquery-ui.theme.min.css"></link>
<style>
#patientName {
text-decoration: none;
color:black;
}
</style>
<script>
$(document).ready(function() {
<?php include "../../myDatabase.php"; include "../../myDatabase4.php"; $inventoryType = $_GET['inventoryType']; $year = "2016"; $totalItems = 0; $firstQuarterTotal = 0; $secondQuarterTotal = 0; $thirdQuarterTotal = 0; $fourthQuarterTotal = 0; //$inventoryType = "medicine" $ro = new database(); $ro4 = new database4(); $ro4->stock_card_list($inventoryType); ?> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title></title> <link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link> <meta name="viewport" content="width=device-width, initial-scale=1"> <script src="../../jquery-2.1.4.min.js"></script> <script src="../js/jquery.tooltipster.min.js"></script> <link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link> <script src="../../bootstrap-3.3.6/js/bootstrap.js"></script> <link rel="stylesheet" href="../myCSS/tooltipster.css"></link> <link rel="stylesheet" href="../myCSS/tooltipster-noir.css"></link> <script>
<?php
require_once "../authentication.php";
include "../../myDatabase.php";
include "../../myDatabase4.php";
if (isset($_POST['pxName'])) {
$pxName = $_POST['pxName'];
} else {
$pxName = "avoidLike";
}
$ro = new database();
$ro4 = new database4();
$ro4->search_laboratory_result($pxName);
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title></title>
<script src="../js/jquery-2.1.4.min.js"></script>
<script src="../js/open.js"></script>
<link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link>
<script>
$(document).ready(function(){
$("#searchBtn").click(function(){
var pxName = $("#pxName").val();
if( pxName != "" ) {
open("POST","lab-result-list-search.php",{pxName:pxName},"_self");
}else {
<?php
include "../../../myDatabase.php";
include "../../../myDatabase4.php";
$fromRegistered = $_POST['fromRegistered'];
$toRegistered = $_POST['toRegistered'];
$type = $_POST['type'];
$dept = $_POST['dept'];
$ro = new database();
$ro4 = new database4();
echo "<center>";
//echo "<font size=6>".$ro->getReportInformation("hmoSOA_name")."</font>";
//echo "<br><font size=3>".$ro->getReportInformation("hmoSOA_address")."</font>";
//echo "<Br><font size=3>($branch)</font>";
?>
<script src="../../js/jquery-2.1.4.min.js"></script>
<script src="../../js/open.js"></script>
<script>
$(document).ready(function(){
var isChrome = /Chrome/.test(navigator.userAgent) && /Google Inc/.test(navigator.vendor);
if( isChrome == true ) {
$("#export").click(function(result){
var data='<table>'+$("#census").html().replace(/<a\/?[^>]+>/gi, '')+'</table>';
var reportName = '<?php
echo 'Census ' . $type . ' [' . $ro4->formatDate($fromRegistered) . ' to ' . $ro4->formatDate($toRegistered) . ' ]';
?>
';
<?php
include "../../myDatabase.php";
include "../../myDatabase4.php";
$ro = new database();
$ro4 = new database4();
$itemNo = $_POST['itemNo'];
$paid = $_POST['paid'];
$ro4->registration_details($ro->selectNow("registrationDetails", "patientNo", "registrationNo", $ro->selectNow("patientCharges", "registrationNo", "itemNo", $itemNo)));
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<script src="../../jquery-2.1.4.min.js"></script>
<link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link>
<script src="../../bootstrap-3.3.6/js/bootstrap.js"></script>
</head>
<body>
<div class="container">
<h3><?php
echo $ro->selectNow("patientRecord", "completeName", "patientNo", $ro->selectNow("registrationDetails", "patientNo", "registrationNo", $ro->selectNow("patientCharges", "registrationNo", "itemNo", $itemNo)));
?>
</h3>
<h4>Paid - <?php
echo $paid;
?>
</h4>
<div class="col-md-6">
<table class="table table-hover">
<?php
require_once '../authentication.php';
include "../../myDatabase.php";
include "../../myDatabase4.php";
$ro = new database();
$ro4 = new database4();
$username = $ro->selectNow('registeredUser', 'username', 'employeeID', $_SESSION['employeeID']);
$module = $ro->selectNow('registeredUser', 'module', 'employeeID', $_SESSION['employeeID']);
$ro->showPatientHistory($ro->doubleSelectNow('patientRecord', 'patientNo', 'completeName', $_POST['patientSearch'], "statusz", ""));
?>
<html>
<head>
<title>PATIENT PROFILE</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<link rel="stylesheet" type="text/css" href="http://<?php
echo $ro->getMyUrl();
?>
/COCONUT/flow/rickyCSS1.css" />
<script type="text/javascript" src="http://<?php
echo $ro->getMyUrl();
?>
/jquery.js"></script>
<script type="text/javascript" src="http://<?php
echo $ro->getMyUrl();
?>
/jquery.autocomplete.js"></script>
<?php
require_once "../authentication.php";
include "../../myDatabase.php";
include "../../myDatabase4.php";
$module = $_POST['module'];
$ro = new database();
$ro4 = new database4();
$ro4->pending_request($module);
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title></title>
<script src="../js/jquery-2.1.4.min.js"></script>
<script src="../js/jquery-ui.js"></script>
<script src="../js/jquery.tooltipster.min.js"></script>
<script src="../js/open.js"></script>
<link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link>
<link rel="stylesheet" href="../myCSS/jquery-ui.css"></link>
<link rel="stylesheet" href="../myCSS/tooltipster.css"></link>
<link rel="stylesheet" href="../myCSS/tooltipster-noir.css"></link>
<script>
$(document).ready(function(){
<?php
foreach ($ro4->pending_request_batchNo() as $batchNo) {
?>
//require_once "../authentication.php";
include "../../myDatabase.php";
include "../../myDatabase4.php";
if (isset($_POST['fromDate'])) {
$fromDate = $_POST['fromDate'];
} else {
$fromDate = "";
}
if (isset($_POST['toDate'])) {
$toDate = $_POST['toDate'];
} else {
$toDate = "";
}
$totalPurchase = 0;
$ro = new database();
$ro4 = new database4();
$ro4->view_purchases($fromDate, $toDate);
$fromYear = substr($fromDate, 0, 4);
$fromMonth = substr($fromDate, 4, 2);
$fromDay = substr($fromDate, 6, 2);
$formatFromDate = $fromYear . "-" . $fromMonth . "-" . $fromDay;
$toYear = substr($toDate, 0, 4);
$toMonth = substr($toDate, 4, 2);
$toDay = substr($toDate, 6, 2);
$formatToDate = $toYear . "-" . $toMonth . "-" . $toDay;
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<?php
require_once "../authentication.php";
include "../../myDatabase.php";
include "../../myDatabase4.php";
$ro = new database();
$ro4 = new database4();
$ro4->list_requesition();
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title></title>
<script src="../js/jquery-2.1.4.min.js"></script>
<script src="../../bootstrap-3.3.6/js/bootstrap.js"></script>
<link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link>
<script>
$(document).ready(function(){
<?php
foreach ($ro4->list_requesition_batchNo() as $batchNo) {
?>
<?php
$ro4->pending_request_details($batchNo);
?>
$("#issueBtn<?php
echo $batchNo;
?>
").click(function(){
<?php
require_once "../authentication.php";
include "../../myDatabase.php";
include "../../myDatabase4.php";
$inventoryCode = $_POST['inventoryCode'];
$requesitionNo = $_POST['requesitionNo'];
$requestQTY = $_POST['requestQTY'];
$module = $_POST['module'];
$ro = new database();
$ro4 = new database4();
$stockCardNo = $ro->selectNow("inventory", "stockCardNo", "inventoryCode", $inventoryCode);
$description = $ro->selectNow("inventory", "description", "inventoryCode", $inventoryCode);
$genericName = $ro->selectNow("inventory", "genericName", "inventoryCode", $inventoryCode);
$qty = $requestQTY;
$inventoryType = $ro->selectNow("inventory", "inventoryType", "inventoryCode", $inventoryCode);
$requestToDept = "Stockroom";
$requestingDept = $module;
$requestingUser = $ro->selectNow("registeredUser", "username", "employeeID", $_SESSION['employeeID']);
$dateRequested = date("Y-m-d");
$timeRequested = date("H:i:s");
$status = "requesting";
$batchNo = $requesitionNo;
$request = array("inventoryCode" => $inventoryCode, "stockCardNo" => $stockCardNo, "description" => $description, "genericName" => $genericName, "quantity" => $qty, "inventoryType" => $inventoryType, "requestTo_department" => $requestToDept, "requestingDepartment" => $requestingDept, "requestingUser" => $requestingUser, "dateRequested" => $dateRequested, "timeRequested" => $timeRequested, "status" => $status, "batchNo" => $batchNo);
$ro4->insertNow("inventoryManager", $request);
<?php
include "../../../myDatabase4.php";
include "../../../myDatabase2.php";
$ro4 = new database4();
$ro = new database2();
if (isset($_POST['date'])) {
$date = $_POST['date'];
} else {
$date = date("Y-m-d");
}
$ro4->opd_patient_census($date, $date);
$ro4->room_list();
$count = 1;
$totalAdmitted = 1;
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<script src="../../../jquery-2.1.4.min.js"></script>
<script src="../../js/jquery-ui.min.js"></script>
<link rel="stylesheet" href="../../../bootstrap-3.3.6/css/bootstrap.css"></link>
<script src="../../../bootstrap-3.3.6/js/bootstrap.js"></script>
<link rel="stylesheet" href="../../js/jquery-ui.css"></link>
<link rel="stylesheet" href="../../js/jquery-ui.theme.min.css"></link>
<script>
$(document).ready(function(){
$("#date").datepicker({
<?php
include "../../myDatabase.php";
include "../../myDatabase4.php";
if (isset($_GET['invoiceNo'])) {
$invoiceNo = $_GET['invoiceNo'];
} else {
$invoiceNo = "avoidLike";
}
$ro = new database();
$ro4 = new database4();
$ro4->search_invoice($invoiceNo);
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title></title>
<script src="../js/jquery-2.1.4.min.js"></script>
<script src="../js/jquery.tooltipster.min.js"></script>
<script src="../../bootstrap-3.3.6/js/bootstrap.min.js"></script>
<script src="../js/open.js"></script>
<link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link>
<link rel="stylesheet" href="../myCSS/tooltipster.css"></link>
<link rel="stylesheet" href="../myCSS/tooltipster-noir.css"></link>
<script>
$(document).ready(function(){
<?php
<?php include "../../myDatabase.php"; include "../../myDatabase4.php"; $month = $_GET['month']; $day = $_GET['day']; $year = $_GET['year']; $month1 = $_GET['month1']; $day1 = $_GET['day1']; $year1 = $_GET['year1']; $username = $_GET['username']; $ro = new database(); $ro4 = new database4(); $date = $year . "-" . $month . "-" . $day; $date1 = $year1 . "-" . $month1 . "-" . $day1; $dates = $ro4->formatDate($date); $dates1 = $ro4->formatDate($date1); echo "Near Expiry<Br>"; echo $dates . " - " . $dates1; $ro->expiration($month, $day, $year, $month1, $day1, $year1, $username);
<?php
require_once "../authentication.php";
include "../../myDatabase.php";
include "../../myDatabase4.php";
$endingNo = $_POST['endingNo'];
$stockCardNo = $_POST['stockCardNo'];
$endingNo1 = "";
$totalEnding = 0;
$ro = new database();
$ro4 = new database4();
$user = $ro->selectNow('registeredUser', 'username', 'employeeID', $_SESSION['employeeID']);
foreach ($endingNo as $end) {
$totalEnding += $ro->selectNow("endingInventory", "endingQTY", "endingNo", $end);
$endingNo1 = $end;
$ro->editNow("endingInventory", "endingNo", $end, "status", "encoded_" . $user);
}
if ($ro->selectNow("inventoryStockCard", "inventoryType", "stockCardNo", $ro->selectNow("endingInventory", "stockCardNo", "endingNo", $endingNo1)) == "medicine") {
$stockCardNo = $ro->selectNow("endingInventory", "stockCardNo", "endingNo", $endingNo1);
$genericName = $ro->selectNow("inventoryStockCard", "genericName", "stockCardNo", $stockCardNo);
$brandName = $ro->selectNow("inventoryStockCard", "description", "stockCardNo", $stockCardNo);
$preparation = $ro->selectNow("inventory", "preparation", "stockCardNo", $stockCardNo);
$qty = $totalEnding;
$unitcost = $ro->selectNow("endingInventory", "unitcost", "endingNo", $endingNo1);
//selectLast($table,$cols,$identifier,$identifierData,$ordering)
$opdPrice = $ro4->selectLast("inventory", "opdPrice", "stockCardNo", $stockCardNo, "inventoryCode");
$ipdPrice = $ro4->selectLast("inventory", "ipdPrice", "stockCardNo", $stockCardNo, "inventoryCode");
$expiration = $ro4->selectLast('inventory', 'expiration', 'stockCardNo', $stockCardNo, 'inventoryCode');
$remarks = "Ending inventory - " . date('Y-m-d');
$locked = "no";
$criticalLevel = "5";
<?php
require_once "../authentication.php";
include "../../myDatabase.php";
include "../../myDatabase4.php";
$ro = new database();
$ro4 = new database4();
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Nursing</title>
<script src="../js/jquery-2.1.4.min.js"></script>
<script src="../js/jquery-ui.min.js"></script>
<script src="../js/jquery.fixedMenu.js"></script>
<script src="../js/open.js"></script>
<link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link>
<link rel="stylesheet" href="../../Registration/menu/fixedMenu_style1.css"></link>
<link rel="stylesheet" href="../myCSS/jquery-ui.css"></link>
<link rel="stylesheet" href="../myCSS/breadcrumb.css"></link>
<script>
$(document).ready(function(){
$(".menu").fixedMenu();
$("#searchPx").click(function(){
var data = {
username:'******'registeredUser', 'username', 'employeeID', $_SESSION['employeeID']);
include "../../myDatabase.php";
include "../../myDatabase4.php";
$stockCardNo = $_POST['stockCardNo'];
$brandName = $_POST['brandName'];
$genericName = $_POST['genericName'];
$currentQTY = $_POST['currentQTY'];
$endingQTY = $_POST['endingQTY'];
$unitcost = $_POST['unitcost'];
$inventoryLocation = $_POST['inventoryLocation'];
$dateAdded = $_POST['dateAdded'];
$quarter = $_POST['quarter'];
?>
<?php
$ro = new database();
$ro4 = new database4();
$data = array("stockCardNo" => $stockCardNo, "currentQTY" => $currentQTY, "endingQTY" => $endingQTY, "unitcost" => $unitcost, "inventoryLocation" => $inventoryLocation, "date" => $dateAdded . " " . date("H:i:s"), "quarter" => $quarter, "username" => $ro->selectNow('registeredUser', 'username', 'employeeID', $_SESSION['employeeID']));
$ro4->insertNow("endingInventory", $data);
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<script src="../../jquery-2.1.4.min.js"></script>
<link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link>
<script src="../../bootstrap-3.3.6/js/bootstrap.js"></script>
</head>
<body>
<div class="container">
<?php include "../../myDatabase.php"; include "../../myDatabase4.php"; $stockCardNo = $_POST['stockCardNo']; $quarter = $_POST['quarter']; $totalCost = 0; $ro = new database(); $ro4 = new database4(); $ro4->ending_inventory_list_details($stockCardNo, $quarter); ?> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title></title> <link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link> </head> <body> <table class="table table-hover"> <thead> <tr> <th>QTY</th> <th>Unitcost</th> <th>Total</th> <th>Location</th> <th>Encoded</th> <th> </th> </tr> </thead> <tbody>
