<?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="); ?>