<?php
include "../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$caserate = $_GET['caserate'];
$ro = new database2();
$ro->coconutDesign();
echo "<Br><Br><br>";
$caseRate_amount = $ro->selectNow("rBanny_caserate", "amount", "caseNo", $caserate);
//amount ng selected caserate
$hospitalBill = $ro->getTotal("total", "Room And Board", $registrationNo) + $ro->getTotal("total", "MEDICINE", $registrationNo) + $ro->getTotal("total", "SUPPLIES", $registrationNo) + $ro->getTotal("total", "LABORATORY", $registrationNo) + $ro->getTotal("total", "RADIOLOGY", $registrationNo) + $ro->getTotal("total", "NURSING-CHARGES", $registrationNo) + $ro->getTotal("total", "MISCELLANEOUS", $registrationNo) + $ro->getTotal("total", "OR/DR/ER Fee", $registrationNo) + $ro->getTotal("total", "OXYGEN", $registrationNo);
$pf = $ro->getTotal("phic", "PROFESSIONAL FEE", $registrationNo);
$targetAmount = $caseRate_amount - $caseRate_amount * 0.3;
echo "<Center>";
echo "<font color='blue' size=5><i>[R-Banny]-[noReset mode]</i></font>";
$ro->coconutBoxStart("500", "130");
echo "<br><font color=red size=4>Caserate</font>: " . $ro->selectNow("rBanny_caserate", "caserate", "caseNo", $caserate) . " [" . number_format($caseRate_amount, 2) . "]";
echo "<br>";
echo "<font color=red size=4>Hospital Bill: </font>" . number_format($hospitalBill, 2);
echo "<Br>";
echo "<font color=red size=4>Professional Fee: </font>" . number_format($pf, 2);
echo "<Br>";
$ro->coconutFormStart("get", "http://" . $ro->getMyUrl() . "/COCONUT/rBanny/analyzingData_noReset.php");
//$cazeRate = $ro->selectNow("availableICD","hospital","icdCode",$ro->selectNow("patientICD","icdCode","registrationNo",$registrationNo));
echo "<i><font color=blue size=4>Target Amount: </font></i><br>" . $ro->coconutTextBox_return("targetAmount", $ro->getFirstCaseRate($ro->selectNow("patientICD", "icdCode", "registrationNo", $registrationNo)));
echo "<br><Br>";
//$ro->coconutHidden("targetAmount",$targetAmount);
$ro->coconutHidden("cash", $ro->getTotal("cashUnpaid", "", $registrationNo));
$ro->coconutHidden("registrationNo", $registrationNo);
if ($hospitalBill > $targetAmount) {
$ro->coconutButton("Proceed");
$toTime_seconds = $_GET['toTime_seconds'];
$username = $_GET['username'];
$registrationNo = $_GET['registrationNo'];
$shift = $_GET['shift'];
$ro = new database2();
$ro->coconutDesign();
?>
<script type="text/javascript" src="http://<?php
echo $ro->getMyUrl();
?>
/jquery1.11.1.js"></script>
<?php
$patno = $ro->selectNow("registrationDetails", "patientNo", "registrationNo", $registrationNo);
echo strtoupper($ro->selectNow("patientRecord", "lastName", "patientNo", $patno)) . ", " . strtoupper($ro->selectNow("patientRecord", "firstName", "patientNo", $patno));
echo "<br><br>";
$ro->coconutFormStart("get", "editChargesCashier1.php");
$ro->coconutHidden("itemNo", $itemNo);
$ro->coconutHidden("month", $month);
$ro->coconutHidden("day", $day);
$ro->coconutHidden("year", $year);
$ro->coconutHidden("fromTime_hour", $fromTime_hour);
$ro->coconutHidden("fromTime_minutes", $fromTime_minutes);
$ro->coconutHidden("fromTime_seconds", $fromTime_seconds);
$ro->coconutHidden("toTime_hour", $toTime_hour);
$ro->coconutHidden("toTime_minutes", $toTime_minutes);
$ro->coconutHidden("toTime_seconds", $toTime_seconds);
$ro->coconutHidden("username", $username);
$ro->coconutHidden("registrationNo", $registrationNo);
<?php
include "../../../myDatabase2.php";
$itemNo = $_GET['itemNo'];
$countItem = count($itemNo);
$registrationNo = $_GET['registrationNo'];
$mode = $_GET['mode'];
$ro = new database2();
if ($mode == "cash2company1") {
for ($x = 0; $x < $countItem; $x++) {
$ro->getPatientChargesToEdit($itemNo[$x]);
$totalTransfer = $ro->selectNow("patientCharges", "company1", "itemNo", $itemNo[$x]) + $ro->patientCharges_cashUnpaid();
$ro->EditNow("patientCharges", "itemNo", $itemNo[$x], "company1", $totalTransfer);
$ro->EditNow("patientCharges", "itemNo", $itemNo[$x], "cashUnpaid", 0);
}
} else {
if ($mode == "company1_to_cash") {
for ($x = 0; $x < $countItem; $x++) {
$ro->getPatientChargesToEdit($itemNo[$x]);
$totalTransfer = $ro->selectNow("patientCharges", "company1", "itemNo", $itemNo[$x]) + $ro->patientCharges_cashUnpaid();
$ro->EditNow("patientCharges", "itemNo", $itemNo[$x], "cashUnpaid", $totalTransfer);
$ro->EditNow("patientCharges", "itemNo", $itemNo[$x], "company1", 0);
}
} else {
if ($mode == "company2company1") {
for ($x = 0; $x < $countItem; $x++) {
$ro->getPatientChargesToEdit($itemNo[$x]);
$totalTransfer = $ro->selectNow("patientCharges", "company1", "itemNo", $itemNo[$x]) + $ro->patientCharges_company();
$ro->EditNow("patientCharges", "itemNo", $itemNo[$x], "company1", $totalTransfer);
$ro->EditNow("patientCharges", "itemNo", $itemNo[$x], "company", 0);
}
<?php
include "../../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$itemNo = $_GET['itemNo'];
$username = $_GET['username'];
$ro = new database2();
$ro->coconutDesign();
$dateAdmit = $ro->selectNow("registrationDetails", "dateRegistered", "registrationNo", $registrationNo);
$ro->coconutFormStart("get", "computeDays1.php");
$ro->coconutHidden("registrationNo", $registrationNo);
$ro->coconutHidden("itemNo", $itemNo);
$ro->coconutHidden("dateIn", $dateAdmit);
$ro->coconutHidden("username", $username);
echo "<br><br><Br><Br>Date Admitted: " . $dateAdmit;
echo "<Br>";
echo "Date Discharge: ";
$ro->coconutComboBoxStart_short("month");
echo "<option value='" . date("m") . "'>" . date("M") . "</option>";
echo "<option value='01'>Jan</option>";
echo "<option value='02'>Feb</option>";
echo "<option value='03'>Mar</option>";
echo "<option value='04'>Apr</option>";
echo "<option value='05'>May</option>";
echo "<option value='06'>Jun</option>";
echo "<option value='07'>Jul</option>";
echo "<option value='08'>Aug</option>";
echo "<option value='09'>Sep</option>";
echo "<option value='10'>Oct</option>";
echo "<option value='11'>Nov</option>";
echo "<option value='12'>Dec</option>";
<?php
include "../../myDatabase2.php";
$inventoryCode = $_GET['inventoryCode'];
$ro = new database2();
echo "<br><bR><br><br>";
echo "<center>";
echo "<table border=1 cellpadding=1 cellspacing=0>";
echo "<Tr>";
echo "<th> Description </th>";
echo "<th> Beginning QTY </th>";
echo "<th> Remaining QTY </th>";
echo "<th> Dispensed QTY </th>";
echo "</tr>";
echo "<tr>";
echo "<td> " . $ro->selectNow("inventory", "description", "inventoryCode", $inventoryCode) . "</tD>";
echo "<td> " . ($ro->selectNow("inventory", "quantity", "inventoryCode", $inventoryCode) + $ro->getQTY_dispensed($inventoryCode)) . "</tD>";
echo "<td> " . $ro->selectNow("inventory", "quantity", "inventoryCode", $inventoryCode) . "</tD>";
echo "<td> " . $ro->getQTY_dispensed($inventoryCode) . "</tD>";
echo "</tr>";
echo "</table>";
echo "</center>";
include "../../../myDatabase2.php";
if (isset($_POST['registrationNo']) && isset($_POST['itemNo'])) {
$registrationNo = $_POST['registrationNo'];
$itemNo = $_POST['itemNo'];
} else {
$registrationNo = 0;
$itemNo = 0;
}
$ro = new database2();
echo "<div style='background:#47a3da; margin:10px; height:320px; width:500px; border-radius:15px;' >";
echo "<br>";
echo "<table border=0>";
echo "<Tr>";
echo "<td> <font color='white' size=4>Name:</font> </td>";
echo "<td><font color='white' size=4><i>" . $ro->selectNow("patientRecord", "lastName", "patientNo", $ro->selectNow("registrationDetails", "patientNo", "registrationNo", $registrationNo)) . ", " . $ro->selectNow("patientRecord", "firstName", "patientNo", $ro->selectNow("registrationDetails", "patientNo", "registrationNo", $registrationNo)) . "</i></font></td>";
echo "</tr>";
echo "<Tr>";
echo "<td> <font color='white' size=4>Age:</font> </td>";
echo "<td><font color='white' size=4><i>" . $ro->selectNow("patientRecord", "Age", "patientNo", $ro->selectNow("registrationDetails", "patientNo", "registrationNo", $registrationNo)) . "</i></font></td>";
echo "</tr>";
echo "<Tr>";
echo "<td> <font color='white' size=4>Sex:</font> </td>";
echo "<td><font color='white' size=4><i>" . $ro->selectNow("patientRecord", "Gender", "patientNo", $ro->selectNow("registrationDetails", "patientNo", "registrationNo", $registrationNo)) . "</i></font></td>";
echo "</tr>";
echo "</table>";
echo "<div style='background:yellow; height:5px;'></div>";
echo "<table border=0>";
echo "<Tr>";
echo "<td> <font color='white' size=4>Height:</font> </td>";
if ($ro->selectNow("registrationDetails", "height", "registrationNo", $registrationNo) != "HEIGHT") {
<?php
include "../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$itemNo = $_GET['itemNo'];
$quantity = $_GET['quantity'];
$username = $_GET['username'];
$show = $_GET['show'];
$desc = $_GET['desc'];
$ro = new database2();
$titlez = $ro->getTitle($itemNo);
if ($ro->doubleSelectNow("patientCharges", "quantity", "itemNo", $itemNo, "registrationNo", $registrationNo) < $quantity) {
echo "<br><br><br><font color=red>Ooopsss.. you are trying to return {$quantity} but there is only " . $ro->doubleSelectNow("patientCharges", "quantity", "itemNo", $itemNo, "registrationNo", $registrationNo) . " Dispensed to the patient</font>";
} else {
if (($ro->getTitle($itemNo) == "MEDICINE" || $ro->getTitle($itemNo) == "SUPPLIES") && $ro->getChargesStatusDept($itemNo)) {
if ($ro->selectNow("inventory", "autoDispense", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo)) == "yes") {
$currentQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo));
// current qty ng meds/sup sa inventory
$newQTY = $currentQTY + $quantity;
//dagdag inventory once return
$ro->editNow("inventory", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo), "quantity", $newQTY);
// update qty sa database
$ro->deletePatientCharges($registrationNo, $itemNo);
} else {
$ro->editNow("patientCharges", "itemNo", $itemNo, "status", "Return");
$ro->editNow("patientCharges", "itemNo", $itemNo, "dateReturn", date("Y-m-d"));
$ro->editNow("patientCharges", "itemNo", $itemNo, "departmentStatus", $quantity . "_" . $registrationNo);
$ro->returnInventory($itemNo, $registrationNo, $ro->selectNow("patientCharges", "description", "itemNo", $itemNo), $quantity, date("Y-m-d") . "@" . $ro->getSynapseTime(), $username);
/*
$regNo = $ro->selectNow("patientCharges","registrationNo","itemNo",$itemNo);
$chargeCodez = $ro->selectNow("patientCharges","chargesCode","itemNo",$itemNo);
<tr>
<th>#</th>
<th>Patient</th>
<th> </th>
</tr>
</thead>
<tbody>
<?php
if ($ro4->opd_patient_census_registrationNo() != "") {
?>
<?php
foreach ($ro4->opd_patient_census_registrationNo() as $registrationNo) {
?>
<tr>
<td> <?php
echo $ro->selectNow("registrationDetails", "pxCount", "registrationNo", $registrationNo);
?>
</td>
<td> <?php
echo $ro->selectNow("patientRecord", "lastName", "patientNo", $ro->selectNow("registrationDetails", "patientNo", "registrationNo", $registrationNo));
?>
, <?php
echo $ro->selectNow("patientRecord", "firstName", "patientNo", $ro->selectNow("registrationDetails", "patientNo", "registrationNo", $registrationNo));
?>
</td>
<?php
if ($ro->selectNow("registrationDetails", "mgh_date", "registrationNo", $registrationNo) != "") {
?>
<td><span class="glyphicon glyphicon-ok"></span></td>
<?php
echo "<tr>";
echo "<td>Patient#: </td><td>" . $ro->getRegistrationDetails_patientNo() . "</td>";
echo "<td> </td>";
echo "<td>Registration#: </td><td>" . $ro->getRegistrationDetails_registrationNo() . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td>Name: </td><td> <a href='#' onClick='printF(printData)' style='text-decoration:none; color:black;'>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</a></td>";
echo "<td> </td><td>" . $ro->coconutText("Physician") . "</td><td> " . $ro->getAttendingDoc($registrationNo, "Attending") . "</td>";
echo "</tr>";
echo "<tr>";
echo "<Td>" . $ro->coconutText("Admitted") . ": </td><td> " . $ro->getRegistrationDetails_dateRegistered() . "@" . $ro->getRegistrationDetails_timeRegistered() . "</td>";
echo "<td> </td>";
//echo "<td>CaseType:</td><TD>".$ro->getRegistrationDetails_caseType()."</tD>";
echo "<Td>" . $ro->coconutText("Discharged") . ": </td><td> " . $ro->getRegistrationDetails_dateUnregistered() . "@" . $ro->getRegistrationDetails_timeUnregistered() . "</td>";
echo "</tr>";
if ($ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo) != "") {
$hmoLimit = number_format($ro->selectNow("registrationDetails", "LimitHMO", "registrationNo", $registrationNo), 2);
} else {
if ($ro->selectNow("Company", "type", "companyName", $ro->getRegistrationDetails_company()) == "insurance") {
//check kung insurance..
$hmoLimit = number_format(2000, 2);
} else {
$hmoLimit = "";
}
}
if ($ro->selectNow("registrationDetails", "company", "registrationNo", $registrationNo) != "") {
echo "<tr>";
echo "<td>Company:</td>";
echo "<td>" . $ro->getRegistrationDetails_company() . " - {$hmoLimit} </td>";
echo "<td> </td>";
echo "<td></td>";
$ro->getPatientProfile($registrationNo);
$cashz = 0;
$phicz = 0;
$company = 0;
$gt = 0;
$hospitalBill_cash = 0;
$hospitalBill_phic = 0;
$hospitalBill_company = 0;
$hospitalBill_gt = 0;
$pf_cash = 0;
$pf_phic = 0;
$pf_company = 0;
$pf_gt = 0;
$room = preg_split("/\\-/", $ro->getRegistrationDetails_room());
$room1 = preg_split("/\\_/", $room[0]);
$roomRate = $ro->selectNow("room", "rate", "Description", $ro->getRegistrationDetails_room());
?>
<script type="text/javascript">
function printF(printData)
{
var a = window.open ('', '',"status=1,scrollbars=1, width=auto,height=auto");
a.document.write(document.getElementById(printData).innerHTML.replace(/<a\/?[^>]+>/gi, ''));
a.document.close();
a.focus();
a.print();
a.close();
}
</script>
<style type="text/css">
<!--
$preparation = $_GET['preparation'];
$phic = $_GET['phic'];
$added = $_GET['added'];
$criticalLevel = $_GET['criticalLevel'];
$supplier = $_GET['supplier'];
$suppliesUNITCOST = $_GET['suppliesUNITCOST'];
$autoDispense = $_GET['autoDispense'];
$status = $_GET['status'];
$classification = $_GET['classification'];
$ipdPrice = $_GET['ipdPrice'];
$opdPrice = $_GET['opdPrice'];
$unitOfMeasure = $_GET['unitOfMeasure'];
$inventoryCode = $_GET['inventoryCode'];
$quantity = $_GET['quantity'];
$inventoryLocation = $_GET['inventoryLocation'];
$dateAdded = date("Y-m-d");
$timeAdded = date("H:i:s");
$begCapital = "";
$begQTY = "";
$description1 = "";
$genericName1 = "";
$biQTY = "";
$biInventoryCode = "";
$encodedQTY = $quantity;
$ro = new database2();
//pinagkunan ng quantity
$source_QTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $inventoryCode);
//ung natirang quantity pagtapos bawasan
$source_newQTY = $source_QTY - $quantity;
$ro->editNow("inventory", "inventoryCode", $inventoryCode, "quantity", $source_newQTY);
$ro->transferMedicine($stockCardNo, $description, $generic, $unitcost, $quantity, $expiration, $addedBy, $dateAdded, $timeAdded, $inventoryLocation, $inventoryType, $branch, $transition, $remarks, $preparation, $phic, $added, $criticalLevel, $supplier, $begCapital, $begQTY, $suppliesUNITCOST, $autoDispense, $status, $classification, $description1, $genericName1, $ipdPrice, $opdPrice, $unitOfMeasure, $biQTY, $biInventoryCode, $encodedQTY, $inventoryCode);
<?php
include "../../../myDatabase2.php";
$username = $_GET['username'];
$chargeNo = $_GET['chargeNo'];
$ro = new database2();
$ro->coconutDesign();
$timeStart = preg_split("/\\:/", $ro->selectNow("generatorCharge", "timeStart", "chargeNo", $chargeNo));
$timeStop = preg_split("/\\:/", $ro->selectNow("generatorCharge", "timeStop", "chargeNo", $chargeNo));
echo "<Br><Br><BR>";
$ro->coconutFormStart("get", "manual1_new.php");
$ro->coconutBoxStart("500", "250");
$ro->coconutHidden("username", $username);
$ro->coconutHidden("chargeNo", $chargeNo);
echo "<Br>";
echo "<table border=0>";
/*
echo "<Tr>";
echo "<Td>Date</tD>";
echo "<td>";
$ro->coconutComboBoxStart_short("month");
echo "<option value='01'>Jan</option>";
echo "<option value='02'>Feb</option>";
echo "<option value='03'>Mar</option>";
echo "<option value='04'>Apr</option>";
echo "<option value='05'>May</option>";
echo "<option value='06'>Jun</option>";
echo "<option value='07'>Jul</option>";
echo "<option value='08'>Aug</option>";
echo "<option value='09'>Sep</option>";
echo "<option value='10'>Oct</option>";
echo "";
//echo "<font size=5><b><a href='#' style='color:#000; text-decoration:none;'>".$ro->getReportInformation("hmoSOA_name")."</a></b></font>";
//echo "<br><font size=2>".$ro->getReportInformation("hmoSOA_address")."</font>";
echo "<center>";
echo "<table>";
echo "<tr>";
echo "<td>Name: </td><td> <a href='#' onClick='printF(printData)' style='text-decoration:none; color:black;'>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</a></td>";
echo "<td> </td><td>" . $ro->coconutText("Physician") . "</td><td> " . $ro->getAttendingDoc($registrationNo, "Attending") . "</td>";
echo "</tr>";
echo "<tr>";
echo "<Td>" . $ro->coconutText("Admitted") . ": </td><td> " . $ro->getRegistrationDetails_dateRegistered() . "</td>";
echo "<td> </td>";
//echo "<td>CaseType:</td><TD>".$ro->getRegistrationDetails_caseType()."</tD>";
echo "<Td>" . $ro->coconutText("Discharged") . ": </td><td> " . $ro->getRegistrationDetails_dateUnregistered() . "@" . $ro->getRegistrationDetails_timeUnregistered() . "</td>";
echo "</tr>";
if ($ro->selectNow("registrationDetails", "package", "registrationNo", $registrationNo) != "") {
$package = $ro->selectNow("registrationDetails", "package", "registrationNo", $registrationNo);
$splitPackage = preg_split("/\\_/", $package);
echo "<tr>";
if ($ro->getPatientRecord_phic() == "NO") {
echo "<Td>Package: " . $splitPackage[1] . " - " . $ro->selectNow("hospitalPackage", "packagePrice", "packageNo", $splitPackage[0]) . "</td>";
} else {
echo "<Td>Package: " . $splitPackage[1] . " - " . $ro->selectNow("hospitalPackage", "package_phicPrice", "packageNo", $splitPackage[0]) . "</td>";
}
echo "</tr>";
} else {
}
//echo "<tr>";
//echo "<Td>".$ro->coconutText("Company").": </td><td> ".$ro->getRegistrationDetails_company()."</td>";
//echo "<td> </tD>";
//echo "<Td>".$ro->coconutText("Fx Diagnosis:").": </td><td> ".$ro->getRegistrationDetails_finalDiagnosis()."</td>";
<td>
<?php
$total = $lab + $xray + $utz + $ctscan + $ecg + $erfee + $or + $misc + $spirometry + $meds + $supp + $pf + $room + $cardiac + $pt + $ot + $st + $others;
echo $total;
$grandTotal += $total;
?>
</td>
<td> </td>
<td> </td>
<td> </td>
<td>
<?php
$disc = round($ro2->selectNow("registrationDetails", "discount", "registrationNo", $registrationNo), 2);
echo $disc;
$discTotal += $disc;
?>
</td>
<td>
<?php
$excessDeduction = $ro2->selectNow("registrationDetails", "hmoManualExcessValue", "registrationNo", $registrationNo) + $ro2->selectNow("registrationDetails", "PHICportion", "registrationNo", $registrationNo) + $ro2->selectNow("registrationDetails", "excessMaxBenefits", "registrationNo", $registrationNo) + $ro2->selectNow("registrationDetails", "excessRoom", "registrationNo", $registrationNo) + $ro2->selectNow("registrationDetails", "excessPF", "registrationNo", $registrationNo);
$hmo = round($ro4->inpatient_paymentMode_total_charges($registrationNo, "company") + $ro4->inpatient_paymentMode_total_inventory($registrationNo, "company") - $excessDeduction, 2);
echo $hmo;
$hmoTotal += $hmo;
?>
</td>
<td>
<?php
include "../../myDatabase2.php";
$username = $_GET['username'];
$ro = new database2();
echo "<center><br>";
$ro->coconutFormStart("post", "create_ipd_census.php");
$ro->coconutHidden("username", $username);
$ro->coconutTableStart();
$ro->coconutTableRowStart();
$ro->coconutTableHeader("Room");
$ro->coconutTableHeader("Reg#");
$ro->coconutTableHeader("Patient");
$ro->coconutTableHeader("Admitted");
$ro->coconutTableHeader("Company");
$ro->coconutTableHeader("Cash");
$ro->coconutTableHeader("PhilHealth");
$ro->coconutTableHeader("Company");
$ro->coconutTableRowStop();
$ro->currentAdmitted("3rd floor");
$ro->currentAdmitted("2nd floor");
$ro->coconutTableStop();
echo "<Br>";
if ($ro->selectNow("ipdCensus", "id", "date", date("Y-m-d")) != "") {
//dont show button
} else {
$ro->coconutButton("Create Inpatient Census");
}
$ro->coconutFormStop();
<?php
include "../../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$itemNo = $_GET['itemNo'];
$dateIn = $_GET['dateIn'];
$month = $_GET['month'];
$day = $_GET['day'];
$year = $_GET['year'];
$username = $_GET['username'];
$ro = new database2();
$dateOut = $year . "-" . $month . "-" . $day;
$out = new DateTime($dateOut);
$in = new DateTime($dateIn);
$days = $out->diff($in)->d;
if ($ro->selectNow("patientCharges", "phic", "itemNo", $itemNo) < 1) {
$ro->editNow("patientCharges", "itemNo", $itemNo, "quantity", $days);
$ro->editNow("patientCharges", "itemNo", $itemNo, "total", $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $itemNo) * $days);
$ro->editNow("patientCharges", "itemNo", $itemNo, "cashUnpaid", $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $itemNo) * $days);
$ro->editNow("patientCharges", "itemNo", $itemNo, "phic", "0");
$ro->editNow("patientCharges", "itemNo", $itemNo, "company", "0");
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientChargesTitle.php?registrationNo={$registrationNo}&title=Room and Board&username={$username}&show=&desc=");
} else {
$cashUnpaid = $ro->selectNow("patientCharges", "cashUnpaid", "itemNo", $itemNo);
$hmo = $ro->selectNow("patientCharges", "company", "itemNo", $itemNo);
$philhealth = $ro->selectNow("patientCharges", "phic", "itemNo", $itemNo);
$newTotal = $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $itemNo) * $days;
$ro->editNow("patientCharges", "itemNo", $itemNo, "quantity", $days);
$ro->editNow("patientCharges", "itemNo", $itemNo, "total", $newTotal);
$ro->editNow("patientCharges", "itemNo", $itemNo, "cashUnpaid", $newTotal - $philhealth);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientChargesTitle.php?registrationNo={$registrationNo}&title=Room and Board&username={$username}&show=&desc=");
<?php
include "../../myDatabase2.php";
$verificationNo = $_POST['verificationNo'];
$inventoryCode = $_POST['inventoryCode'];
$description = $_POST['description'];
$qty = $_POST['qty'];
$borrowerDepartment = $_POST['borrowerDepartment'];
$returnBy = $_POST['returnBy'];
$ro = new database2();
$newQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $inventoryCode) + $qty;
$ro->editNow("inventory", "inventoryCode", $inventoryCode, "quantity", $newQTY);
$ro->csrReturnItem($verificationNo, $inventoryCode, $description, $qty, $borrowerDepartment, $returnBy, date("Y-m-d"), $ro->getSynapseTime());
echo "<br><Br><Br><center><font color=red>{$description} Returned</font>";
<?php
include "../../../myDatabase2.php";
$inventoryCode = $_GET['inventoryCode'];
$month = $_GET['month'];
$day = $_GET['day'];
$year = $_GET['year'];
$month1 = $_GET['month1'];
$day1 = $_GET['day1'];
$year1 = $_GET['year1'];
$ro = new database2();
echo "<br>";
echo "<center><font size=5>" . $ro->selectNow("inventory", "description", "inventoryCode", $inventoryCode) . "</font></center>";
echo "<center>{$month} {$day}, {$year} - {$month1} {$day1}, {$year1}</center>";
$ro->dispensedMonitor($inventoryCode, $month, $day, $year, $month1, $day1, $year1);
echo "<br><br>";
$ro->getRequestedDept($inventoryCode, $year . "-" . $month . "-" . $day, $year1 . "-" . $month1 . "-" . $day1);
$adatePaidstr = strtotime($adatePaid);
$adatePaidfmt = date("M d, Y", $adatePaidstr);
$btotCP = 0;
$bsql = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT cashPaid, title, paidBy, doctorsPF FROM patientCharges WHERE (status='PAID' OR status='BALANCE') AND registrationNo='{$aregistrationNo}' AND paidVia='Cash'");
while ($bfetch = mysqli_fetch_array($bsql)) {
$bcashPaid = $bfetch['cashPaid'];
$btitle = $bfetch['title'];
$bpaidBy = $bfetch['paidBy'];
$bdoctorsPF = $bfetch['doctorsPF'];
if ($btitle == 'PROFESSIONAL FEE') {
$btotCP += $bcashPaid;
} else {
$btotCP += $bcashPaid;
}
}
$patno = $cuz->selectNow("registrationDetails", "patientNo", "registrationNo", $aregistrationNo);
$patient = strtoupper($cuz->selectNow("patientRecord", "lastName", "patientNo", $patno)) . ", " . strtoupper($cuz->selectNow("patientRecord", "firstName", "patientNo", $patno));
echo "\n <tr>\n <td><div align='left' class='style4'>{$adatePaidfmt} - {$atimePaid}</div></td>\n <td><div align='left' class='style4'>{$patient}</div></td>\n <td><div align='center' class='style4'>\n";
$cashorsql = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT orNO FROM patientCharges WHERE registrationNo='{$aregistrationNo}' AND (status='PAID' OR status='BALANCE') AND paidVia='Cash' GROUP BY orNO");
$cashorcount = mysqli_num_rows($cashorsql);
$cashcounter = 0;
while ($cashorfetch = mysqli_fetch_array($cashorsql)) {
$cashorNO = $cashorfetch['orNO'];
$cashcounter++;
if ($cashcounter == $cashorcount) {
echo $cashorNO;
} else {
echo $cashorNO . "; ";
}
}
echo "\n </div></td>\n <td><div align='center' class='style4'>{$bpaidBy}</div></td>\n <td><div align='right' class='style4'>" . number_format($btotCP, 2, '.', ',') . "</div></td>\n </tr>\n";
<?php
include "../../../myDatabase2.php";
$date1 = $_GET['date1'];
$date2 = $_GET['date2'];
$service = $_GET['service'];
$chargesCode = $_GET['chargesCode'];
$ro = new database2();
echo "<center><br>";
echo $ro->selectNow("Doctors", "Name", "doctorCode", $chargesCode);
echo "<br><font size=2>({$date1} to {$date2})</font>";
$ro->getTopDoctors_with_px($date1, $date2, "ATTENDING", $chargesCode);
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>";
echo "</table>";
echo "<hr>";
echo "<Table border=0 cellpadding=0 cellspacing=0>";
echo "<tr>";
echo "<th> <font class='heading'><b>DATE</b></font> </th>";
//echo "<th> <font class='heading'><b>Ref#</b></font> </th>";
echo "<th width='30%'> <font class='heading'><b>Particulars</b></font> </th>";
echo "<th> <font class='heading'><b>QTY</b></font> </th>";
echo "<th> <font class='heading'><b>Price</b></font> </th>";
echo "<th> <font class='heading'><b>Charges</b></font> </th>";
echo "<th> <font class='heading'><b>Credit</b></font> </th>";
echo "<th> <font class='heading'><b>Bal</b></font> </th>";
echo "<th> <font class='heading'><b>PHIC</b></font> </th>";
echo "<th> <font class='heading'><b>HMO</b></font> </th>";
<?php
include "../../../myDatabase2.php";
$username = $_POST['username'];
$password = $_POST['password'];
$ro = new database2();
$ro->coconutDesign();
$user = $ro->selectNow("registeredUser", "username", "password", $password);
if ($username == "" && $password == "") {
$ro->getBack("Authentication Error");
} else {
if ($username == $user) {
//header("Location: /COCONUT/requestition/batchRequest/getRequestNo.php?username=$username");
echo "<Br><Br><BR><Br>";
$ro->coconutBoxStart("500", "100");
echo "<Br>";
echo "<table border=0>";
echo "<Tr>";
echo "<Td><a style='text-decoration:none;' href='http://" . $ro->getMyUrl() . "/COCONUT/requestition/batchRequest/getRequestNo.php?username={$username}'><font color=blue>Request</font></a></tD>";
echo "<td> </td>";
echo "<Td><a style='text-decoration:none;' href='http://" . $ro->getMyUrl() . "/COCONUT/requestition/consumedInventory.php?username={$username}'><font color=red>Consume</font></a></tD>";
echo "</tr>";
echo "</table>";
$ro->coconutBoxStop();
} else {
echo "<script type='text/javascript'>\nalert('Incorrect Password');\nhistory.back();\n</script>";
}
}
$ro->getPatientProfile($registrationNo);
$cashz = 0;
$phicz = 0;
$company = 0;
$gt = 0;
$hospitalBill_cash = 0;
$hospitalBill_phic = 0;
$hospitalBill_company = 0;
$hospitalBill_gt = 0;
$pf_cash = 0;
$pf_phic = 0;
$pf_company = 0;
$pf_gt = 0;
$room = preg_split("/\\-/", $ro->getRegistrationDetails_room());
$room1 = preg_split("/\\_/", $room[0]);
$roomRate = $ro->selectNow("room", "rate", "Description", $ro->getRegistrationDetails_room());
?>
<script type="text/javascript">
function printF(printData)
{
var a = window.open ('', '',"status=1,scrollbars=1, width=auto,height=auto");
a.document.write(document.getElementById(printData).innerHTML.replace(/<a\/?[^>]+>/gi, ''));
a.document.close();
a.focus();
a.print();
a.close();
}
</script>
<a href="#" onClick="printF('printData')" style="text-decoration:none; color:black;">PRINT</a>
<div id='printData'>
<?php
include "../../../myDatabase2.php";
$packageNo = $_GET['packageNo'];
$inventoryCode = $_GET['inventoryCode'];
$qty = $_GET['qty'];
$ro = new database2();
$desc = $ro->selectNow("inventory", "description", "inventoryCode", $inventoryCode);
$inventoryType = $ro->selectNow("inventory", "inventoryType", "inventoryCode", $inventoryCode);
$title = "";
if ($inventoryType == "medicine") {
$title = "MEDICINE";
} else {
$title = "SUPPLIES";
}
$ro->editNow("hospitalPackage", "packageNo", $packageNo, "packageIncluded_description", $desc . "_" . $inventoryCode . "_" . $title);
$ro->editNow("hospitalPackage", "packageNo", $packageNo, "packageIncluded_qty", $qty);
echo "<br><br><br><center><font color=red size=4> SUCCESSFULLY UPDATED </font>";
}
var aSound = document.createElement('audio');
aSound.setAttribute('src', 'doorbell.wav');
<?php
if ($module == "PHARMACY") {
$tag = "MEDICINE";
} else {
if ($module == "LABORATORY") {
$tag = "LABORATORY";
} else {
$tag = "CSR";
}
}
if ($ro->selectNow("requestCount", "currentTotal", "department", $tag) != $ro->countDeptRequest($tag, $myDate)) {
$ro->editNow("requestCount", "department", $tag, "currentTotal", $ro->countDeptRequest($tag, $myDate));
?>
aSound.play();
<?php
} else {
}
?>
<?php
echo "</script>";
echo "</head>";
echo "<body>";
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>";
<?php
include "../../myDatabase2.php";
$returnNo = $_GET['returnNo'];
$inventoryCode = $_GET['inventoryCode'];
$returnFrom = $_GET['returnFrom'];
$returnTo = $_GET['returnTo'];
$username = $_GET['username'];
$qtyReturn = $_GET['qtyReturn'];
$ro = new database2();
echo "<br><br><br><br><br><br>";
$ro->coconutFormStart("get", "http://" . $ro->getMyUrl() . "/COCONUT/inventory/receiveDepartmentReturn1.php");
$ro->coconutHidden("returnTo", $returnTo);
$ro->coconutHidden("username", $username);
$ro->coconutHidden("returnNo", $returnNo);
$ro->coconutHidden("inventoryCode", $inventoryCode);
$ro->coconutHidden("qtyReturn", $qtyReturn);
$ro->coconutBoxStart_red("500", "70");
echo "<br>";
echo "Received Return of {$qtyReturn} pcs <b>" . $ro->selectNow("inventory", "description", "inventoryCode", $inventoryCode) . "</b> of <b>{$returnFrom}</b>?";
echo "<br><br>";
$ro->coconutButton("Proceed");
$ro->coconutBoxStop();
$ro->coconutFormStop();
echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/Reports/inventoryReport/inventoryMovementOption1.php?menu=beginningBalance&stockCardNo={$stockCardNo}' style='text-decoration:none; color:red;'>Beginning Balance</a>";
echo "<br><Br>";
if ($movementNo != "") {
echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/Reports/inventoryReport/inventoryMovementOption1.php?menu=firstThreePurchases&stockCardNo={$stockCardNo}&movementNo={$movementNo}' style='text-decoration:none; color:red;'>3 months Purchases Jan/Feb/Mar</a>";
echo "<hr>";
echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/Reports/inventoryReport/inventoryMovementOption1.php?menu=secondThreePurchases&stockCardNo={$stockCardNo}&movementNo={$movementNo}' style='text-decoration:none; color:blue;'>3 months Purchases Apr/May/Jun</a>";
echo "<hr>";
echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/Reports/inventoryReport/inventoryMovementOption1.php?menu=thirdThreePurchases&stockCardNo={$stockCardNo}&movementNo={$movementNo}' style='text-decoration:none; color:red;'>3 months Purchases Jul/Aug/Sep</a>";
echo "<hr>";
echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/Reports/inventoryReport/inventoryMovementOption1.php?menu=fourthThreePurchases&stockCardNo={$stockCardNo}&movementNo={$movementNo}' style='text-decoration:none; color:blue;'>3 months Purchases Oct/Nov/Dec</a>";
echo "<hr>";
echo "<br><br><br>";
echo "<hr>";
echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/Reports/inventoryReport/inventoryMovementOption1.php?menu=medicineType&stockCardNo={$stockCardNo}&movementNo={$movementNo}' style='text-decoration:none; color:red;'>Medicine Type</a>";
echo "<hr>";
echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/inventory/addInventory.php?username=xx&status=old&stockCardNo={$stockCardNo}&description={$description}&genericName=" . $ro->selectNow("inventoryStockCard", "genericName", "stockCardNo", $stockCardNo) . "' style='text-decoration:none; color:blue;'>Add New Quantity</a>";
echo "<hr>";
} else {
echo "<a href='#' style='text-decoration:none; color:gray;'>3 months Purchases Jan/Feb/Mar</a>";
echo "<hr>";
echo "<a href='#' style='text-decoration:none; color:gray;'>3 months Purchases Apr/May/Jun</a>";
echo "<hr>";
echo "<a href='#' style='text-decoration:none; color:gray;'>3 months Purchases Jul/Aug/Sep</a>";
echo "<hr>";
echo "<a href='#' style='text-decoration:none; color:gray;'>3 months Purchases Oct/Nov/Dec</a>";
echo "<hr>";
echo "<br><br><br>";
echo "<hr>";
echo "<a href='#' style='text-decoration:none; color:gray;'>Medicine Type</a>";
echo "<hr>";
echo "<a href='http://" . $ro->getMyUrl() . "/COCONUT/inventory/addInventory.php?username=xx&status=old&stockCardNo={$stockCardNo}&description={$description}&genericName=" . $ro->selectNow("inventoryStockCard", "genericName", "stockCardNo", $stockCardNo) . "' style='text-decoration:none; color:blue;'>Add New Quantity</a>";
<?php
include "../../myDatabase2.php";
$verificationNo = $_GET['verificationNo'];
$countVerification = count($verificationNo);
$username = $_GET['username'];
$ro = new database2();
for ($x = 0; $x < $countVerification; $x++) {
$identifier = preg_split("/\\_/", $verificationNo[$x]);
// $identifier[0]=verificationNo, identifier[1]=inventoryCode
//echo $verificationNo[$x];//verificationNo na galing sa inventoryManager table [serve as unique identifier]
if ($ro->selectNow("inventory", "quantity", "inventoryCode", $identifier[1]) >= $ro->selectNow("inventoryManager", "quantity", "verificationNo", $identifier[0])) {
//double check kung mas mataas p ung in stock qty
$newQTY = $ro->selectNow("inventory", "quantity", "inventoryCode", $identifier[1]) - $ro->selectNow("inventoryManager", "quantity", "verificationNo", $identifier[0]);
$ro->editNow("inventory", "inventoryCode", $identifier[1], "quantity", $newQTY);
$generic = "";
$pricing = $ro->selectNow("inventory", "unitcost", "inventoryCode", $identifier[1]);
$expiration = "";
//addNewMedicine($description,$generic,$unitcost,$quantity,$expiration,$addedBy,$dateAdded,$timeAdded,$inventoryLocation,$inventoryType,$branch,$transition,$remarks,$preparation,$phic,$added,$criticalLevel,$supplier,$begCapital,$begQTY,$suppliesUNITCOST)
$ro->addNewMedicine($ro->selectNow("inventoryManager", "description", "verificationNo", $identifier[0]), $generic, $pricing, $ro->selectNow("inventoryManager", "quantity", "verificationNo", $identifier[0]), $expiration, $ro->selectNow("inventoryManager", "requestingUser", "verificationNo", $identifier[0]), date("Y-m-d"), $ro->getSynapseTime(), $ro->selectNow("inventoryManager", "requestingDepartment", "verificationNo", $identifier[0]), $ro->selectNow("inventory", "inventoryType", "inventoryCode", $identifier[1]), "Consolacion", "requestition", "from inventoryCode:" . $identifier[1] . " issued by:" . $username, "", "", "", "", "", "", $ro->selectNow("inventoryManager", "quantity", "verificationNo", $identifier[0]), $ro->selectNow("inventory", "suppliesUNITCOST", "inventoryCode", $identifier[1]), "yes");
//insert to inventory table
$ro->editNow("inventoryManager", "verificationNo", $identifier[0], "status", "dispensed");
$ro->editNow("inventoryManager", "verificationNo", $identifier[0], "dispensedDate", date("Y-m-d"));
} else {
echo "<font color=red>Sorry... " . $ro->selectNow("inventoryManager", "description", "verificationNo", $identifier[0]) . " Cannot be dispensed because there's only " . $ro->selectNow("inventory", "quantity", "inventoryCode", $identifier[1]) . " in stock</font> ";
}
}
<?php
include "../../myDatabase2.php";
$registrationNo = $_GET['registrationNo'];
$targetAmount = $_GET['targetAmount'];
$ro = new database2();
$itemz = preg_split("/\\_/", $ro->getMaximumTotal_rBanny($registrationNo, "Room and Board"));
$ro->getPatientChargesToEdit($itemz[1]);
if ($ro->getTotal("cashUnpaid", "Room And Board", $registrationNo) > 0) {
echo "<br><Br><br><br><br>";
echo "<font color=red>R-Banny is now Calculating Room</font><br>";
echo "Total: " . $itemz[0];
echo "<br>";
echo "Item#: " . $itemz[1];
if ($targetAmount >= $itemz[0]) {
$ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", "0");
$ro->editNow("patientCharges", "itemNo", $itemz[1], "Company", "0");
$ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $itemz[0]);
} else {
//echo "<br><Br><br><br><font color=blue size=5>R-Banny is Having a trouble in Computation</font>";
$newCash = $itemz[0] - $targetAmount;
$newPHIC = $ro->selectNow("patientCharges", "total", "itemNo", $itemz[1]) - $newCash;
$ro->editNow("patientCharges", "itemNo", $itemz[1], "cashUnpaid", $newCash);
$ro->editNow("patientCharges", "itemNo", $itemz[1], "Company", "0");
$ro->editNow("patientCharges", "itemNo", $itemz[1], "phic", $newPHIC);
}
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/rBanny/consumedRoom.php?registrationNo={$registrationNo}&targetAmount={$targetAmount}");
} else {
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/rBanny/consumedMeds.php?registrationNo={$registrationNo}&targetAmount={$targetAmount}");
}
<?php
include "../../../myDatabase2.php";
$itemNo = $_POST['itemNo'];
$cash = $_POST['cash'];
$company = $_POST['company'];
$phic = $_POST['phic'];
$company1 = $_POST['company1'];
$ro = new database2();
$ro->editNow("patientCharges", "itemNo", $itemNo, "cashUnpaid", $cash);
$ro->editNow("patientCharges", "itemNo", $itemNo, "company", $company);
$ro->editNow("patientCharges", "itemNo", $itemNo, "phic", $phic);
$ro->editNow("patientCharges", "itemNo", $itemNo, "company1", $company1);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/additionalCompany/transfertoAdditionalCompany.php?registrationNo=" . $ro->selectNow("patientCharges", "registrationNo", "itemNo", $itemNo) . "&mode=");
?>
