//echo "<font size=4><b>".$ro->getReportInformation("hmoSOA_name")."</b></font><br>";
//echo "<font size=2>".$ro->getReportInformation("hmoSOA_address")."</font><br>";
//echo "<font size=2>".$ro->getRegistrationDetails_branch()."</font><br>";
echo "<table border=0>";
echo "<tr>";
echo "<td><font class='labelz'><b>Name:</b></font></td><td><font size=2>" . $ro->getPatientRecord_completeName() . "</font></td>";
echo "<td> </td>";
echo "<Td><font class='labelz'><b>Registration#:</b></font></td>";
echo "<td><font size=2>" . $ro->getRegistrationDetails_registrationNo() . "</td>";
echo "</tr>";
echo "<tr>";
echo "<Td><font class='labelz'><B>Age:</b></td>";
echo "<Td><font size=2>" . $ro->getPatientRecord_age() . " yrs Old</font></td>";
echo "<Td> </td>";
echo "<td><font class='labelz'><b> Senior:</b></font></td>";
echo "<td><font size=2>" . $ro->getPatientRecord_senior() . "</font></td>";
echo "</tr>";
echo "<tr>";
echo "<Td><font class='labelz'><b>Company:</b></font></td>";
echo "<td><font size=2>" . $ro->getRegistrationDetails_company() . "</font></tD>";
echo "<td><font class='labelz'>Diagnosis:</font></td>";
echo "<tD><font class='labelz'>" . $ro->soap_assessmentz() . " " . $ro->selectNow("registrationDetails", "finalDiagnosis", "registrationNo", $registrationNo) . "</font></tD>";
echo "</tr>";
if ($ro->getRegistrationDetails_type() == "IPD") {
$ro->chargesForSOA_ipd($registrationNo, $show, "", "");
} else {
$ro->chargesForSOA($registrationNo, $show, "", "");
}
echo "</table>";
echo "<br>";
echo "</div>";
$inventoryCode = $_GET['inventoryCode'];
$username = $_GET['username'];
$ro = new database();
?>
<link rel="stylesheet" type="text/css" href="http://<?php
echo $ro->getMyUrl();
?>
/COCONUT/myCSS/coconutCSS.css" />
<?php
$timezone = "Asia/Manila";
date_default_timezone_set($timezone);
$currentQTY = $ro->getCurrentQTY($inventoryCode) - $issuedQTY;
$expiration = preg_split("/\\_/", $ro->selectNow("inventory", "expiration", "inventoryCode", $inventoryCode));
echo "<form method='get' action='receivingRequestDetails1.php' >";
echo "<input type=hidden name='currentQTY' value='{$currentQTY}'>";
echo "<input type=hidden name='verificationNo' value='{$verificationNo}'>";
echo "<input type=hidden name='inventoryCode' value='{$inventoryCode}'>";
echo "<input type=hidden name='unitcost' value='" . $ro->selectNow("inventory", "unitcost", "inventoryCode", $inventoryCode) . "'>";
//$_GET['unitcost']
echo "<input type=hidden name='generic' value='" . $ro->selectNow("inventory", "genericName", "inventoryCode", $inventoryCode) . "'>";
//$_GET['generic']
echo "<input type=hidden name='date' value='" . date("M_d_Y") . "'>";
//$_GET['date']
echo "<input type=hidden name='username' value='{$username}'>";
// $_GET['addedBy']
echo "<input type=hidden name='month' value='" . $expiration[0] . "'>";
// $_GET['month']
echo "<input type=hidden name='day' value='" . $expiration[1] . "'>";
<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
echo $ro->selectNow('inventory', 'quantity', 'inventoryCode', $inventoryCode);
?>
";
var qty1 = parseInt(qty);
$('#chargeQTY<?php
echo $inventoryCode;
?>
').jStepper({
minValue:1,
maxValue:qty1
});
$("#chargeBtn<?php
echo $inventoryCode;
?>
<?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);
<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
if ($ro4->search_invoice_siNo() != "") {
?>
<?php
foreach ($ro4->search_invoice_siNo() as $siNo) {
?>
<?php
$invoiceNo = $ro->selectNow("salesInvoice", "invoiceNo", "siNo", $siNo);
?>
$(".details").tooltipster({
content: $('<span>Loading....</span>'),
position: 'right',
theme: 'tooltipster-noir',
contentAsHTML:true,
functionBefore:function(origin,continueTooltip) {
continueTooltip();
if( origin.data('ajax') !== 'cached' ){
$.ajax({
type:'POST',
url:'invoice-details.php',
data:{'siNo':<?php
echo $siNo;
?>
<?php
include "../myDatabase.php";
include "updater.php";
$itemNo = $_GET['itemNo'];
$ro = new database();
$u = new updater();
for ($x = 0; $x < count($itemNo); $x++) {
$registrationNo = $ro->selectNow("patientCharges", "registrationNo", "itemNo", $itemNo[$x]);
$itemNo1 = $itemNo[$x];
$shift = $ro->selectNow("patientCharges", "reportShift", "itemNo", $itemNo[$x]);
$description = "OPD";
$cashPaid = $ro->selectNow("patientCharges", "cashPaid", "itemNo", $itemNo[$x]);
$orNo = $ro->selectNow("patientCharges", "orNO", "itemNo", $itemNo[$x]);
$type = "OPD";
$paidBy = $ro->selectNow("patientCharges", "paidBy", "itemNo", $itemNo[$x]);
$timePaid = $ro->selectNow("patientCharges", "timePaid", "itemNo", $itemNo[$x]);
$datePaid = $ro->selectNow("patientCharges", "datePaid", "itemNo", $itemNo[$x]);
$paidVia = $ro->selectNow("patientCharges", "paidVia", "itemNo", $itemNo[$x]);
$u->transferCollection($registrationNo, $itemNo1, $shift, $description, $cashPaid, $orNo, $type, $paidBy, $timePaid, $datePaid, $paidVia);
}
if ($row['firstName'] == "N/A") {
} else {
echo "<Tr id='rowz'>";
$ro->censusRegistered_patient += 1;
$ro->coconutTableData("<span class='style4'>" . $row['lastName'] . " " . $row['firstName'] . " " . $row['middleName'] . "</span>");
$ro->coconutTableData("<span class='style4'>" . $row['Age'] . "</span>");
$ro->coconutTableData("<span class='style4'>" . strtoupper($row['Gender']) . "</span>");
//$ro->coconutTableData("<span class='style4'>".$ro->selectNow("Doctors","Specialization1","Name",$ro->getAttendingDoc($row['registrationNo'],"ATTENDING"))."</span>");
if ($row['phic'] == "YES") {
$ro->coconutTableData("<span class='style4'>NH</span>");
} else {
$ro->coconutTableData("<span class='style4'>NN</span>");
}
$ro->coconutTableData("<span class='style4'>" . $row['Company'] . "</span>");
$ro->coconutTableData("<span class='style4'>" . $ro->getAttendingDoc($row['registrationNo'], "ATTENDING") . "</span>");
$ro->coconutTableData("<span class='style4'>" . ($type = $ro->selectNow("registrationDetails", "room", "registrationNo", $row['registrationNo']) . "</span>"));
$ro->coconutTableData("<span class='style4'>" . $row['timeRegistered'] . "@" . $row['dateRegistered'] . "</span>");
$ro->coconutTableData("<span class='style4'>" . $row['registeredBy'] . "</span>");
$ro->coconutTableData("<a href='http://" . $ro->getMyUrl() . "/COCONUT/Reports/Census/registrationCensusDelete.php?username={$username}®istrationNo={$row['registrationNo']}&fromMonth={$fromMonth}&fromDay={$fromDay}&fromYear={$fromYear}&toMonth={$toMonth}&toDay={$toDay}&toYear={$toYear}&type={$type}&dept={$dept}'><img src='http://" . $ro->getMyUrl() . "/COCONUT/myImages/delete.jpeg'></a>");
echo "</tr>";
}
}
$ro->coconutTableData("<span class='style2'>TOTAL PATIENT</span>");
$ro->coconutTableData("<span class='style2'>" . $ro->censusRegistered_patient . "</span>");
$ro->coconutTableData("");
$ro->coconutTableData("");
$ro->coconutTableData("");
$ro->coconutTableData("");
$ro->coconutTableData("");
$ro->coconutTableData("");
$ro->coconutTableStop();
<?php
include "myDatabase.php";
$endingNo = $_GET['endingNo'];
$ro = new database();
foreach ($endingNo as $endingNo) {
$inventoryCode = $ro->selectNow("endingInventory", "inventoryCode", "endingNo", $endingNo);
$unitcost = $ro->selectNow("inventory", "unitcost", "inventoryCode", $inventoryCode);
$ro->editNow("endingInventory", "endingNo", $endingNo, "unitcost", round($unitcost, 2));
echo $inventoryCode;
}
for ($c = 1; $c <= $opdnum; $c++) {
//For C
$rnopc = "rop" . $c;
$selectrdc = $_POST[$rnopc];
if ($selectrdc != "") {
//If C
$csql = mysql_query("SELECT SUM(sellingPrice*quantity) AS creditqsp, SUM(pc.discount) AS totcdiscount, SUM(pc.total) AS totctotal, SUM(pc.discount+pc.cashUnpaid+pc.cashPaid+pc.cashPaidFromBalance+pc.phic+pc.company+pc.amountPaidFromCreditCard) AS othertot FROM patientCharges pc, registrationDetails rd WHERE pc.registrationNo=rd.registrationNo AND rd.type='OPD' AND pc.status NOT LIKE 'DELETED_%%%%' AND pc.title='{$title}' AND rd.registrationNo='{$selectrdc}' ORDER BY pc.dateCharge,pc.timeCharge");
//$csql=mysql_query("SELECT pc.sellingPrice, pc.quantity, pc.discount, pc.total, pc.discount, pc.cashUnpaid, pc.cashPaid, pc.cashPaidFromBalance, pc.phic, pc.company, pc.amountPaidFromCreditCard FROM patientCharges pc, registrationDetails rd WHERE pc.registrationNo=rd.registrationNo AND rd.type='OPD' AND pc.status NOT LIKE 'DELETED_%%%%' AND pc.title='$title' AND rd.registrationNo='$selectrdc' ORDER BY pc.dateCharge,pc.timeCharge");
while ($cfetch = mysql_fetch_array($csql)) {
$totcdiscount = $cfetch['totcdiscount'];
$totctotal = $cfetch['totctotal'];
$othertot = $cfetch['othertot'];
$creditqsp = $cfetch['creditqsp'];
$totalall += $creditqsp;
if ($creditqsp > 0) {
$patientNo = $cuz->selectNow("registrationDetails", "patientNo", "registrationNo", $selectrdc);
$lastName = $cuz->selectNow("patientRecord", "lastName", "patientNo", $patientNo);
$firstName = $cuz->selectNow("patientRecord", "firstName", "patientNo", $patientNo);
$middleName = $cuz->selectNow("patientRecord", "middleName", "patientNo", $patientNo);
$dateRegistered = $cuz->selectNow("registrationDetails", "dateRegistered", "registrationNo", $selectrdc);
$name = $lastName . ", " . $firstName . " " . $middleName;
echo "\n <tr>\n <form name='Submit' method='post' action='../COCONUT/currentPatient/patientInterface1.php' target='_blank'>\n <input type='hidden' name='username' value='{$username}' />\n <input type='hidden' name='registrationNo' value='{$selectrdc}' />\n <td class='table1Bottom1Right'><div align='left'><input type='submit' name='Submit' class='button03' value='" . strtoupper($name) . "' /></div></td>\n </form>\n <td class='table1Bottom1Right'><div align='center' class='arial14black'> " . date("M d, Y", strtotime($dateRegistered)) . " </div></td>\n <td class='table1Bottom'><a href='../COCONUT/patientProfile/SOAoption/newSOA/newDetailed.php?registrationNo={$selectrdc}&username={$username}&show=try' class='astyle' target='_blank'><div align='right' class='arial14black'> " . number_format($creditqsp, 2) . " </div></a></td>\n </tr>\n";
}
}
}
//If C
}
//For C
echo "\n <tr>\n <td class='table1Top2Bottom1Right' colspan='2'><div align='right' class='arial14blackbold'> TOTAL </div></td>\n <td class='table1Top2Bottom'><div align='right' class='arial14blackbold'> " . number_format($totalall, 2) . " </div></td>\n </tr>\n </table></td>\n </tr>\n</table>\n</div>\n";
?>
</body>
echo "<th class='header'>Service</th>";
echo "<th class='header'>PHIC</th>";
echo "<th class='header'>Insurance</th>";
echo "<th class='header'>Attending</th>";
echo "<th class='header'>Registered</th>";
echo "<th class='header'>Registered By</th>";
echo "</tr>";
while ($row = mysqli_fetch_array($result)) {
if ($row['firstName'] == "N/A") {
} else {
echo "<Tr id='rowz'>";
$ro->censusRegistered_patient += 1;
echo "<td>" . $row['lastName'] . " " . $row['firstName'] . " " . $row['middleName'] . "</td>";
echo "<td>" . $row['Age'] . "</td>";
echo "<td>" . $row['Gender'] . "</td>";
echo "<td>" . $ro->selectNow("Doctors", "Specialization1", "Name", $ro->getAttendingDoc($row['registrationNo'], "ATTENDING")) . "</td>";
if ($row['phic'] == "YES") {
echo "<td>NH</td>";
} else {
echo "<td>NN</td>";
}
echo "<td>" . $row['Company'] . "</td>";
echo "<td>" . $ro->getAttendingDoc($row['registrationNo'], "ATTENDING") . "</td>";
echo "<td>" . $row['timeRegistered'] . "@" . $row['dateRegistered'] . "</td>";
echo "<td>" . $row['registeredBy'] . "</td>";
echo "</tr>";
}
}
echo "<tr>";
echo "<td>Total Patient</td>";
echo "<td>" . $ro->censusRegistered_patient . "</td>";
<?php
include "../../../myDatabase.php";
$requestNo = $_GET['requestNo'];
$ro = new database();
$requestNo = mysql_real_escape_string(strip_tags($requestNo));
echo "\n<style type='text/css'>\ntr:hover { background-color:yellow; color:black;}\na { text-decoration:none; color:black; }\n</style>";
echo "Request#:" . $requestNo;
echo "<br>";
$ro->coconutTableStart();
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>Description</b>");
$ro->coconutTableData($ro->selectNow("admin2request", "description", "requestNo", $requestNo));
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>QTY</b>");
$ro->coconutTableData($ro->selectNow("admin2request", "qty", "requestNo", $requestNo));
$ro->coconutTableRowStop();
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>Price</b>");
$ro->coconutTableData($ro->selectNow("admin2request", "price", "requestNo", $requestNo));
$ro->coconutTableRowStop();
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>Total</b>");
$ro->coconutTableData($ro->selectNow("admin2request", "total", "requestNo", $requestNo));
$ro->coconutTableRowStop();
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>Request</b>");
$ro->coconutTableData($ro->selectNow("admin2request", "time", "requestNo", $requestNo) . " @ " . $ro->selectNow("admin2request", "date", "requestNo", $requestNo));
$ro->coconutTableRowStop();
$ro->coconutTableRowStart();
$ro->coconutTableData("<b>Request By</b>");
include "../../../myDatabase.php";
$cuz = new database();
mysql_connect($cuz->myHost(), $cuz->getUser(), $cuz->getPass());
mysql_select_db($cuz->getDB());
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$fromMonth = $_GET['fromMonth'];
$fromDay = $_GET['fromDay'];
$fromYear = $_GET['fromYear'];
$toMonth = $_GET['toMonth'];
$toDay = $_GET['toDay'];
$toYear = $_GET['toYear'];
$type = $_GET['type'];
$dept = $_GET['dept'];
$uname = $_POST['uname'];
$delpass = $_POST['delpass'];
$asql = mysql_query("SELECT * FROM registeredUser WHERE username='******' AND password='******'");
$acount = mysql_num_rows($asql);
$dateRegistered = $cuz->selectNow("registrationDetails", "dateRegistered", "registrationNo", $registrationNo);
if ($acount != 0) {
$date = date("Y-m-d");
$time = date("H:i:s");
$delete = "DELETED_" . $uname . "[" . $date . "@" . $time . "]_" . $dateRegistered;
//$ro->deleteNow("registrationDetails","registrationNo",$registrationNo);
$cuz->EditNow("registrationDetails", "registrationNo", $registrationNo, "dateRegistered", $delete);
echo "<center><Br><br><Br><br><font color=red size=5>Successfully Deleted</font>";
echo "<META HTTP-EQUIV='Refresh'CONTENT='3;URL=registrationCensus.php?username={$username}&fromMonth={$fromMonth}&fromDay={$fromDay}&fromYear={$fromYear}&toMonth={$toMonth}&toDay={$toDay}&toYear={$toYear}&type={$type}&dept={$dept}'>";
} else {
echo "<center><Br><br><Br><br><font color=red size=5>You are not authorized to delete the Patient.</font>";
echo "<META HTTP-EQUIV='Refresh'CONTENT='3;URL=registrationCensus.php?username={$username}&fromMonth={$fromMonth}&fromDay={$fromDay}&fromYear={$fromYear}&toMonth={$toMonth}&toDay={$toDay}&toYear={$toYear}&type={$type}&dept={$dept}'>";
}
var charges = 'Search Charges';
function SetMsg (txt,active) {
if (txt == null) return;
if (active) {
if (txt.value == charges) txt.value = '';
} else {
if (txt.value == '') txt.value = charges;
}
}
window.onload=function() { SetMsg(document.getElementById('charges', false)); }
</script>
<?php
echo "<body onload='DisplayTime();'>";
echo "<form name='addCharge'>";
echo " <input type=text name='availableCharges' id='charges' style=' \n\tbackground:#FFFFFF no-repeat 4px 4px;\n\tpadding:4px 4px 4px 2px;\n\tborder:1px solid #CCCCCC;\n\twidth:400px;\n\theight:25px;' class='txtBox'\n\tonfocus='SetMsg(this, true);'\n \tonblur='SetMsg(this,false);'\n\tonkeyup='showResult();' \n\tvalue='Search Charges'\n>";
echo "<p id='curTime'></p>";
echo "<input type=hidden name='packageNo' value='{$packageNo}'>";
echo "<input type=hidden name='inventoryLocation' value='" . $ro->selectNow("inventory", "inventoryLocation", "inventoryCode", $desc[1]) . "'>";
echo "</form>";
echo "<div id='livesearch'></div>";
echo "</body>";
?>
<tr>
<td>
<h5>
<?php
echo $stockCardNo;
?>
</h5>
</td>
<?php
if ($inventoryType == "medicine") {
?>
<td>
<h5>
<?php
echo $ro->selectNow("inventoryStockCard", "genericName", "stockCardNo", $stockCardNo);
?>
</h5>
</td>
<?php
}
?>
<td>
<h5>
<?php
echo $ro->selectNow("inventoryStockCard", "description", "stockCardNo", $stockCardNo);
?>
</h5>
</td>
<td>
<?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>
$paidVia = $_GET['paidVia'];
$cashPaid = $_GET['cashPaid'];
$batchNo = $_GET['batchNo'];
$username = $_GET['username'];
$inventoryFrom = $_GET['inventoryFrom'];
$paycash = $_GET['paycash'];
$remarks = $_GET['remarks'];
$stockCardNo = $_GET['stockCardNo'];
$ro = new database();
$ro->coconutDesign();
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<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";
if ($ro->selectNow("inventory", "quantity", "inventoryCode", $chargesCode) < 1) {
$ro->getBack("Sorry, Out of Stock");
}
echo "\n<style type='text/css'>\n.qty {\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight:25px;\n\twidth: 100px;\n\tpadding:4px 4px 4px 10px;\n}\n\n</style>\n\n";
//addCharges.php
echo "<br><Br>";
echo "<form method='get' action='http://" . $ro->getMyUrl() . "/COCONUT/availableMedicine/addCharges_cash.php'>";
echo "<center>\n<font color=red>" . $description . "</font>\n<div style='border:1px solid #000000; width:470px; height:130px;\t'>";
echo "<br><table border=0 cellpadding=0 cellspacing=0>";
echo "<tr>";
echo "<td><font size=2>Quantity:</font></td>";
echo "<td><input type=text class='qty' name='quantity' value='1'></td>";
echo "</tr>";
echo "<tr>";
echo "<td><font size=2>Date Charge</font> </td>";
echo "<td>";
<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']);
?>
',
module:'ER',
'patientSearch':''
};
open("POST","../currentPatient/patientInterface.php",data,'_blank')
});
$("#doctorPx").click(function(){
open("POST","../Doctor/showDocName.php",{},'departmentX');
});
$("#requestInventory").click(function(){
data = {
module:'E.R'
<?php
require_once "../authentication.php";
include "../../myDatabase.php";
$module = $_POST['module'];
$ro = new database();
$username = $ro->selectNow("registeredUser", "username", "employeeID", $_SESSION['employeeID']);
echo "<script src='../js/jquery-2.1.4.min.js'></script>";
echo "<script src='../js/open.js'></script>";
echo "\n<script>\n\t\$(document).ready(function(){\n\n\t\t\$('#signin').click(function(){\n\t\t\topen('POST','maintenanceHeading.php',{module:'" . $module . "'},'_self');\n\t\t});\n\n\t});\n</script>\n";
echo "\n<style type='text/css'>\na { text-decoration:none; color:red; }\n.style1 {\n\tfont-family: Arial;\n\tfont-size: 12px;\n\tcolor: #0033FF;\n\tfont-weight: bold;\n}\n.style2 {\n\tfont-family: Arial;\n\tfont-size: 12px;\n\tcolor: #FF0000;\n\tfont-weight: bold;\n}\n.style3 {\n\tfont-family: Arial;\n\tfont-size: 14px;\n\tcolor: #000000;\n\tfont-weight: bold;\n}\n</style>\n\n";
$ro->coconutDesign();
$ro->coconutHeading("MAINTENANCE", "COCONUT/maintenance/initializeMaintenance.php");
$ro->coconutUpperMenuStart();
$ro->coconutUpperMenuStop();
$url = "http://" . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'];
//kuhain ang current web address
/*
if ( (!isset($username) && !isset($module)) ) {
header("Location:/LOGINPAGE/module.php ");
die();
}
*/
echo "<br><br><center>";
$ro->coconutBoxStart("600", "100");
echo "<br>";
echo "<span class='style3'>Logged in as {$username}</span>";
echo "<Br>";
echo "<a href='../session/out.php'><span class='style2'><< Sign Out</span></a> ";
echo " <a id='signin' href='#'><span class='style1'>Sign In >></span></a>";
$ro->coconutBoxStop();
<thead>
<tr>
<th>Date</th>
<th>Invoice#</th>
<th>Supplier</th>
<th>Amount</th>
</tr>
</thead>
<tbody>
<?php
foreach ($ro4->view_purchases_siNo() as $siNo) {
?>
<tr>
<td>
<?php
$date = $ro->selectNow("salesInvoice", "recievedDate", "siNo", $siNo);
$year = substr($date, 0, 4);
$month = substr($date, 4, 2);
$day = substr($date, 6, 2);
$formatDate = $year . "-" . $month . "-" . $day;
echo $ro4->formatDate($formatDate);
?>
</td>
<td>
<?php
echo $ro->selectNow("salesInvoice", "invoiceNo", "siNo", $siNo);
?>
</td>
<td>
<span class="details<?php
echo $siNo;
echo "<br><br>";
echo "<table border=0>";
echo "<tr>";
echo "<td><font class='labelz'><b>Name:</b></font></td><td><font size=2>" . $ro->getPatientRecord_completeName() . "</font></td>";
echo "<td> </td>";
echo "<Td><font class='labelz'><b>Registration#:</b></font></td>";
echo "<td><font size=2>" . $ro->getRegistrationDetails_registrationNo() . "</td>";
echo "</tr>";
echo "<tr>";
echo "<Td><font class='labelz'><B>Age:</b></td>";
echo "<Td><font size=2>" . $ro->getPatientRecord_age() . " yrs Old</font></td>";
echo "<Td> </td>";
echo "<td><font class='labelz'><b> Senior:</b></font></td>";
echo "<td><font size=2>" . $ro->getPatientRecord_senior() . "</font></td>";
echo "</tr>";
echo "<tr>";
echo "<Td><font class='labelz'><b>Company:</b></font></td>";
echo "<td><font size=2>" . $ro->getRegistrationDetails_branch() . "</font></tD>";
echo "<td><font class='labelz'><b>Diagnosis</b></font></td>";
echo "<td><font size='2'>";
echo $ro->selectNow("registrationDetails", "finalDiagnosis", "registrationNo", $registrationNo);
echo "</font></td>";
echo "</tr>";
if ($ro->getRegistrationDetails_type() == "IPD") {
$ro->chargesForSOA_ipd_hospital($registrationNo, $show, "", "");
} else {
$ro->chargesForSOA_hospital($registrationNo, $show, "", "");
}
echo "</table>";
echo "<br>";
echo "</div>";
<th>Date</th>
<th>Patient</th>
<th>Amount</th>
</tr>
</thead>
<tbody>
<?php
foreach ($ro4->inpatient_discharged_registrationNo() as $registrationNo) {
?>
<?php
if ($ro4->inpatient_phic_total($registrationNo) > 0) {
?>
<tr>
<td>
<?php
echo $ro4->formatDate($ro->selectNow("registrationDetails", "dateUnregistered", "registrationNo", $registrationNo));
?>
</td>
<td>
<?php
$patientNo = $ro->selectNow("registrationDetails", "patientNo", "registrationNo", $registrationNo);
$lastName = $ro->selectNow("patientRecord", "lastName", "patientNo", $patientNo);
$firstName = $ro->selectNow("patientRecord", "firstName", "patientNo", $patientNo);
echo $lastName . ", " . $firstName;
?>
</td>
<td>
<?php
$phicTotal += $ro4->inpatient_phic_total($registrationNo);
<?php
include "../../myDatabase.php";
$payrollNo = $_GET['payrollNo'];
$empID = $_GET['empID'];
$username = $_GET['username'];
$ro = new database();
$ro->coconutFormStart("post", "/COCONUT/payroll/deletePayroll1.php");
$ro->coconutHidden("payrollNo", $payrollNo);
$ro->coconutHidden("empID", $empID);
$ro->coconutHidden("username", $username);
echo "<br><br><br><br><br><BR>";
$ro->coconutBoxStart_red("500", "100");
echo "<br>";
echo "<font color=red> Delete Payroll of</font> <font color='blue'>" . $ro->selectNow("registeredUser", "completeName", "employeeID", $empID) . "<font color=red> from " . $ro->selectNow("employeePayroll", "payFrom", "payrollNo", $payrollNo) . " to " . $ro->selectNow("employeePayroll", "payTo", "payrollNo", $payrollNo) . "?? </font>";
echo "<br><br>";
echo "<input type='submit' value='Delete' style='border:1px solid #ff0000;'>";
$ro->coconutBoxStop();
$ro->coconutFormStop();
<?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 " - ";
//}
include "../myDatabase.php";
$username = $_GET['username'];
$sino = $_GET['sino'];
$page = $_GET['page'];
$status = $_GET['status'];
$oldStockCardNo = $_GET['stockCardNo'];
$description = $_GET['description'];
$genericName = $_GET['genericName'];
$invoiceNo = $_GET['invoiceNo'];
$ro = new database();
$GLOBALS["___mysqli_ston"] = mysqli_connect($ro->myHost(), $ro->getUser(), $ro->getPass());
(bool) mysqli_query($GLOBALS["___mysqli_ston"], "USE " . $ro->getDB());
$description1 = $_GET['description'];
$genericName1 = $_GET['genericName'];
if ($status == "new") {
$stockCardNo = $ro->selectNow("trackingNo", "value", "name", "stockCardNo");
/*
$ro->getInventoryStockCardNo();
$myFile = $ro->getReportInformation("homeRoot")."/COCONUT/trackingNo/stockCardNo.dat";
$fh = fopen($myFile, 'r');
$stockCardNo = fread($fh, 100);
fclose($fh);
*/
} else {
$stockCardNo = $oldStockCardNo;
}
$day = date("d");
$month = date("m");
$year = date("Y");
echo "\n<div align='left'>\n <table width='400' border='1' cellpadding='0' cellspacing='0' bordercolor='#000000' bgcolor='#000000'>\n <tr>\n <form method='post' action='addInventory_insert.php'>\n <td><table width='400' bgcolor='#0066FF' border='0' cellpadding='0' cellspacing='0' bgcolor='#FFFFFF'>\n <tr>\n <td colspan='3' height='30' class='style1'><div align='left'> Add Medicine</div></td>\n </tr>\n <tr>\n <td width='133' class='style2'><div align='left'> Description</div></td>\n <td width='15' class='style2'><div align='center'>:</div></td>\n <td width='252' class='style2'><div align='left'>\n";
if ($status == "old") {
'},function(result){
open('POST','dept-charges.php',data,'_self');
console.log(result);
});
});
<?php
}
?>
<?php
}
?>
$("#chargesCart").click(function() {
var redirect_room = '<?php
echo $ro->selectNow('registrationDetails', 'room', 'registrationNo', $registrationNo);
?>
';
var redirect_username = '******'registeredUser', 'username', 'employeeID', $_SESSION["employeeID"]);
?>
';
var redirect_batchNo = '<?php
echo $batchNo;
?>
';
var redirect_registrationNo = '<?php
echo $registrationNo;
?>
';
/Maintenance/addCharges.php?module=OR/DR/ER Fee&username=<?php
echo $username;
?>
" target="departmentX">OR/DR/ER/ICU Fee</a></li>
<li><a href="http://<?php
echo $ro->getMyUrl();
?>
/Maintenance/addCharges.php?module=ENDOSCOPY&username=<?php
echo $username;
?>
" target="departmentX">ENDOSCOPY Charges</a></li>
<?php
//check kung nka activate ung rehab module [Activate execute rehab module] [Deactivate don't execute rehab]
if ($ro->selectNow("reportHeading", "information", "reportName", "rehab") == "Activate") {
?>
<li><a href="http://<?php
echo $ro->getMyUrl();
?>
/Maintenance/addCharges.php?module=REHAB&username=<?php
echo $username;
?>
" target="departmentX">Rehab Charges</a></li>
<?php
} else {
}
?>
<?php
//check kung nka activate ung dialysis module [Activate execute dialysis module] [Deactivate don't execute dialysis]
<?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";
} else {
$dateUnregisteredstr = strtotime($dateUnregistered);
$dateUnregisteredfmt = date("m/d/Y", $dateUnregisteredstr) . "-";
}
$Birthdatestr = strtotime($Birthdate);
$Birthdatefmt = date("m/d/Y", $Birthdatestr);
$agedatefmt = date("m/d/Y", $Birthdatestr);
$birthDate = explode("/", $agedatefmt);
$age = date("md", date("U", mktime(0, 0, 0, $birthDate[0], $birthDate[1], $birthDate[2]))) > date("md") ? date("Y") - $birthDate[2] - 1 : date("Y") - $birthDate[2];
$bsql = mysql_query("SELECT description FROM patientCharges WHERE registrationNo='{$registrationNo}' AND (status NOT LIKE 'Discharged' OR status NOT LIKE 'DELETED_%%%%') AND title='Room And Board' ORDER BY dateCharge");
$bcount = mysql_num_rows($bsql);
if ($bcount == 0) {
$room = "No Room Assigned";
} else {
while ($bfetch = mysql_fetch_array($bsql)) {
$room = $bfetch['description'];
}
}
$num++;
if ($num < 10) {
$numfmt = "0" . $num;
} else {
$numfmt = $num;
}
echo "\n <tr>\n <form name='Submit' method='post' action='../COCONUT/currentPatient/patientInterface1.php' target='_blank'>\n <input type='hidden' name='username' value='{$username}' />\n <input type='hidden' name='registrationNo' value='{$registrationNo}' />\n <td class='table1Bottom'><div align='left' class='style5'><input name='rno' type='submit' class='button01' value='{$registrationNo}' /></di></td>\n </form>\n <td class='table1Bottom1Left'><div align='center' class='style5'> {$dateRegisteredfmt} </di></td>\n <td class='table1Bottom1Left'><div align='center' class='style5'> {$timeRegistered} </di></td>\n <form name='Submit' method='post' action='../COCONUT/currentPatient/patientInterface1.php' target='_blank'>\n <input type='hidden' name='username' value='{$username}' />\n <input type='hidden' name='registrationNo' value='{$registrationNo}' />\n <td class='table1Bottom1Left'><div align='left' class='style5'> <input type='submit' name='name' class='button01' value='" . strtoupper($patientname) . "' /></di></td>\n </form>\n <td class='table1Bottom1Left'><div align='center' class='style5'> {$Birthdatefmt} </di></td>\n <td class='table1Bottom1Left'><div align='center' class='style5'> {$age} </di></td>\n <td class='table1Bottom1Left'><div align='center' class='style5'> {$sex} </di></td>\n <td class='table1Bottom1Left'><div align='left' class='style5'> " . strtoupper($Address) . " </di></td>\n <td class='table1Bottom1Left'><div align='center' class='style5'> {$phicfmt} </di></td>\n <td class='table1Bottom1Left'><div align='left' class='style5'> " . strtoupper($initialDiagnosis) . " </di></td>\n <td class='table1Bottom1Left'><div align='left' class='style5'> " . strtoupper($cuz->selectNow("patientICD", "diagnosis", "registrationNo", $registrationNo)) . " </di></td>\n <td class='table1Bottom1Left'><div align='left' class='style5'> " . strtoupper($cuz->getAttendingDoc($registrationNo, "ATTENDING")) . " </di></td>\n <td class='table1Bottom1Left'><div align='center' class='style5'> " . strtoupper($cuz->selectNow("registrationDetails", "dischargedCondition", "registrationNo", $registrationNo)) . " </di></td>\n <td class='table1Bottom1Left'><div align='center' class='style5'> {$dateUnregisteredfmt}" . $timeUnregistered . " </di></td>\n </tr>\n";
}
echo "\n </table>\n</div>\n";
?>
</body>
</html>
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">
<h3> </h3>
} else {
$truebdoctorsPF = $bdoctorsPF;
}
if ($bamountPaidFromCreditCard == '') {
$truebamountPaidFromCreditCard = 0;
} else {
$truebamountPaidFromCreditCard = $bamountPaidFromCreditCard;
}
$totspmdpf = $truesp[0] - $truebdoctorsPF;
$totPF += $totspmdpf;
$errorst = $totspmdpf - ($bdiscount + $bcashUnpaid + $bphic + $bcompany + $bcashPaid + $truebamountPaidFromCreditCard);
$error += $errorst;
//if($errorst!=0){
//echo "$bitemNo | $errorst = ((".$truesp[0]."-$truebdoctorsPF)-($bdiscount+$bcashUnpaid+$bphic+$bcompany+$bcashPaid+$truebamountPaidFromCreditCard))<br>";
//}
}
$totalall += $totamountPaidFromCreditCard + $pfamountPaidFromCreditCard;
if ($totamountPaidFromCreditCard + $pfamountPaidFromCreditCard != 0) {
$patientNo = $cuz->selectNow("registrationDetails", "patientNo", "registrationNo", $registrationNo);
$lastName = $cuz->selectNow("patientRecord", "lastName", "patientNo", $patientNo);
$firstName = $cuz->selectNow("patientRecord", "firstName", "patientNo", $patientNo);
$middleName = $cuz->selectNow("patientRecord", "middleName", "patientNo", $patientNo);
$name = $lastName . ", " . $firstName . " " . $middleName;
echo "\n <tr>\n <form name='Submit' method='post' action='../COCONUT/currentPatient/patientInterface1.php' target='_blank'>\n <input type='hidden' name='username' value='{$username}' />\n <input type='hidden' name='registrationNo' value='{$registrationNo}' />\n <td class='table1Bottom1Right'><div align='left'><input type='submit' name='Submit' class='button03' value='{$name}' /></div></td>\n </form>\n <td class='table1Bottom1Right'><div align='center' class='arial14black'> " . date("M d, Y", strtotime($dateRegistered)) . " </div></td>\n <td class='table1Bottom'><a href='../COCONUT/patientProfile/SOAoption/newSOA/newDetailed.php?registrationNo={$registrationNo}&username={$username}&show=try' class='astyle' target='_blank'><div align='right' class='arial14black'> " . number_format($totamountPaidFromCreditCard + $pfamountPaidFromCreditCard, 2) . " </div></a></td>\n </tr>\n";
}
}
echo "\n <tr>\n <td class='table1Top2Bottom1Right' colspan='2'><div align='right' class='arial14blackbold'> TOTAL </div></td>\n <td class='table1Top2Bottom'><div align='right' class='arial14blackbold'> " . number_format($totalall, 2) . " </div></td>\n </tr>\n </table></td>\n </tr>\n</table>\n</div>\n";
?>
</body>
</html>
