} else {
}
$phicCovered = $_GET['phicCovered'];
$branch = $_GET['branch'];
$username = $_GET['username'];
$show = $_GET['show'];
$desc = $_GET['desc'];
$datePaid_month = $_GET['datePaid_month'];
$datePaid_day = $_GET['datePaid_day'];
$datePaid_year = $_GET['datePaid_year'];
$timePaid_hour = $_GET['timePaid_hour'];
$timePaid_minutes = $_GET['timePaid_minutes'];
$timePaid_seconds = $_GET['timePaid_seconds'];
$paidBy = $_GET['paidBy'];
$remarks = $_GET['remarks'];
$ro = new database3();
$datePaid = $datePaid_month . "_" . $datePaid_day . "_" . $datePaid_year;
$timePaid = $timePaid_hour . ":" . $timePaid_minutes . ":" . $timePaid_seconds;
$total = $quantity * $sellingPrice;
$totalCovered = $cashCovered + $companyCovered + $phicCovered + $discount;
//$totalCovered = ($cashCovered + $companyCovered + $phicCovered) ;
//check if total covered is equal to the grand total
if ($totalCovered != $total) {
//if not equal,dont edit but prompt the user that was not tally
echo "\n<script type='text/javascript'>\nalert('Sorry,The Cash Covered + Company Covered + PHIC Covered = ({$totalCovered}) this Total Covered is not equal to the Total which is ({$total}) only');\nwindow.back(-1);\n</script>";
} else {
$beforeEdit_sellingPrice = $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $itemNo);
$beforeEdit_quantity = $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo);
$beforeEdit_discount = $ro->selectNow("patientCharges", "discount", "itemNo", $itemNo);
$beforeEdit_total = $ro->selectNow("patientCharges", "total", "itemNo", $itemNo);
$beforeEdit_cash = $ro->selectNow("patientCharges", "cashUnpaid", "itemNo", $itemNo);
<?php
include "../../../myDatabase3.php";
$stockCardNo = $_GET['stockCardNo'];
$startLetter = $_GET['startLetter'];
$count = count($stockCardNo);
$ro = new database3();
/*
for($x=0;$x<$count;$x++) {
echo $stockCardNo[$x]."- ".$ro->selectNow("inventoryStockCard","description","stockCardNo",$stockCardNo[$x])."<Br>";
}
echo "<br>";
echo "<a href='stockCardList2.php?stockCardNo1=".$stockCardNo[0]."&stockCardNo2=".$stockCardNo[1]."'>Merge ".$stockCardNo[0]." to ".$stockCardNo[1]."</a>";
*/
for ($x = 0; $x < $count; $x++) {
$ro->editNow("inventory", "stockCardNo", $stockCardNo[$x], "stockCardNo", end($stockCardNo));
$ro->editNow("patientCharges", "stockCardNo", $stockCardNo[$x], "stockCardNo", end($stockCardNo));
}
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/inventory/stockCard/stockCardList.php?startLetter={$startLetter}");
<?php
include "../myDatabase3.php";
$ro = new database3();
$ro->listDiscountType();
//$ro->getMedtechName("asas");
<?php
include "../../myDatabase3.php";
$registrationNo = $_GET['registrationNo'];
if (isset($_GET['show'])) {
$show = $_GET['show'];
} else {
$show = "All";
}
if (isset($_GET['checked'])) {
$checked = $_GET['checked'];
} else {
$checked = "";
}
$ro = new database3();
if ($ro->selectNow("registrationDetails", "type", "registrationNo", $registrationNo) == "OPD") {
echo "<font color=red>Update to Outpatient Price</font><br><font size=2>Updated price will be in cash column</font>";
} else {
if ($ro->selectNow("registrationDetails", "type", "registrationNo", $registrationNo) == "IPD") {
echo "<font color=red>Update to Inpatient Price</font><br><font size=2>Updated price will be in cash column</font>";
} else {
}
}
if ($checked == "") {
echo "<center><a href='/COCONUT/patientProfile/updatePrice.php?registrationNo={$registrationNo}&show={$show}&checked=checked' style='text-decoration:none; color:Red;'>Check All</a>";
} else {
echo "<center><a href='/COCONUT/patientProfile/updatePrice.php?registrationNo={$registrationNo}&show={$show}&checked=' style='text-decoration:none; color:Red;'>Uncheck All</a>";
}
$ro->updatePricez($registrationNo, $show, $checked);
<?php
include "../../myDatabase3.php";
$registrationNo = $_GET['registrationNo'];
$ro = new database3();
$ro->coconutDesign();
$ro->getPatientProfile($registrationNo);
echo "<br><br><br>";
$ro->coconutFormStart("get", "reporting1.php");
$ro->coconutHidden("registrationNo", $registrationNo);
echo "<center><font color=blue>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName() . "</font>";
$ro->coconutBoxStart("500", "100");
echo "<br>";
echo "<table border=0>";
$datez = "";
if ($ro->getRegistrationDetails_dateUnregistered() != "") {
$datez = $ro->getRegistrationDetails_dateUnregistered();
} else {
$datez = date("Y-m-d");
}
/*
echo "<tr>";
echo "<td></td>";
echo "<td><font color=red>(YYYY-MM-DD)</font></td>";
echo "</tr>";
*/
//echo "<tr>";
//echo "<td>Reporting Date</td>";
//echo "<td>";
$ro->coconutHidden("reportDate", $datez);
//echo "</td>";
<?php include "../../myDatabase3.php"; include "../../myDatabase4.php"; $date1 = $_GET['date1']; $date2 = $_GET['date2']; ?> <?php $personalBalance = 0; ?> <?php $ro3 = new database3(); $ro4 = new database4(); ?> <?php $ro3->personalBalancePatient($date1, $date2); ?> <!DOCTYPE html> <html> <head> <title></title> <meta charset="UTF-8"> <script src="../../jquery-2.1.4.min.js"></script> <script src="../js/jquery-ui.min.js"></script> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link> <link rel="stylesheet" href="../js/jquery-ui.css"></link>
<?php
include "../../../myDatabase3.php";
$itemNo = $_GET['itemNo'];
$countz = count($itemNo);
$registrationNo = $_GET['registrationNo'];
$user = $_GET['username'];
$ro = new database3();
$ro->getPatientProfile($registrationNo);
for ($x = 0; $x < $countz; $x++) {
$collectionNo = $ro->selectNow("collectionReport", "collectionNo", "itemNo", $itemNo[$x]);
$ro->addVoidPayment($registrationNo . "_" . $ro->getPatientRecord_completeName(), $itemNo[$x] . "_" . $ro->patientCharges_Description(), $ro->patientCharges_cashPaid(), $ro->getSynapseTime(), date("Y-m-d"), $user);
$ro->voidItemized_OPD($collectionNo, $itemNo[$x], $user);
$newCashUnpaid = $ro->selectNow("patientCharges", "sellingPrice", "itemNo", $itemNo[$x]) * $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo[$x]);
$newCashUnpaid1 = $newCashUnpaid - $ro->selectNow("patientCharges", "discount", "itemNo", $itemNo[$x]);
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "status", "UNPAID");
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "orNo", "");
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "cashPaid", "");
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "datePaid", "");
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "timePaid", "");
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "paidBy", "");
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "cashUnpaid", $newCashUnpaid1);
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "amountPaidFromCreditCard", "");
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "doctorsPF", "");
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "doctorsPF_payable", "");
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "cardType", "");
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "reportShift", "");
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "dateUnregistered", "");
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "timeUnregistered", "");
}
echo "\n<script type='text/javascript'>\nalert('Void Payment Success');\nwindow.location = 'http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/patientProfile_handler.php?registrationNo={$registrationNo}&username={$user}';\n</script>\n\n";
<?php
include "../../myDatabase3.php";
$date = $_GET['date'];
$date1 = $_GET['date1'];
$type = $_GET['type'];
$title = $_GET['title'];
$ro = new database3();
echo $date . "<Br>";
echo $date1 . "<Br>";
echo $title . "-" . $type;
echo "<br><br>";
$ro->patientAccountOPD_mismatch($date, $date1, $type, $title);
if ($type == "IPD") {
$ro->patientAccount($date, $date1, $type, $title);
} else {
echo "<Br><br><center>";
echo "<Table border=0 width='90%'>";
echo "<tr>";
echo "<th>Patient</th>";
echo "<th>Particulars</th>";
echo "<th>Disc</th>";
echo "<th>UNPAID</th>";
echo "<th>HMO</th>";
echo "<th>PHIC</th>";
echo "<th>CASH</th>";
echo "<th>Cr.Card</th>";
echo "<th>Total</th>";
if ($title == "OT" || $title == "ST") {
echo "<th>Hospital</th>";
echo "<th>PF</th>";
$invoiceNo = $_GET['invoiceNo'];
$checkNo = $_GET['checkNo'];
$bank = $_GET['bank'];
$orNo = $_GET['orNo'];
$paymentMode = $_GET['paymentMode'];
$description = $_GET['description'];
$vattable = $_GET['vattable'];
$vat = $_GET['vat'];
$wTax = $_GET['wTax'];
$netTotal = $_GET['netTotal'];
$payee = $_GET['payee'];
$date = $_GET['date'];
$username = $_GET['username'];
$vat = $_GET['vat'];
$voucherNo = $_GET['voucherNo'];
$ro = new database3();
for ($x = 0; $x < $count; $x++) {
$invoiceTotal = $ro->purchasingPayablesTotal($siNo[$x]);
$vattable = round($invoiceTotal / 1.12, 2);
$vat = round($invoiceTotal - $vattable, 2);
$wTax = round($vattable * 0.01, 2);
$netTotal = round($invoiceTotal - $wTax, 2);
echo $siNo[$x] . "......." . "Vattable: " . $vattable . "........Vat: " . $vat . "........wTax: " . $wTax . ".......Net: " . $netTotal . "<Br>";
if ($paymentMode == "cash") {
$voucherNo1 = "CA" . $voucherNo;
} else {
$voucherNo1 = "CH" . $voucherNo;
}
$ro->payment_voucher_purhcasing($ro->selectNow("salesInvoice", "invoiceNo", "siNo", $siNo[$x]), $checkNo, $bank, $orNo, $paymentMode, $description, $invoiceTotal, $vattable, $wTax, $vat, $payee, $date, $username, $voucherNo1);
if ($paymentMode == "cash") {
$ro->addToPurchaseJournal($voucherNo1, $invoiceNo, "INVENTORY", $invoiceTotal, "", $siNo[$x], date("Y-m-d"));
<?php
include "../../myDatabase3.php";
$month = $_GET['month'];
$day = $_GET['day'];
$year = $_GET['year'];
$month1 = $_GET['month1'];
$day1 = $_GET['day1'];
$year1 = $_GET['year1'];
$ro = new database3();
$date = $year . $month . $day;
$date1 = $year1 . $month1 . $day1;
$datez_m = substr($date, 0, 4);
$datez_d = substr($date, 4, 2);
$datez_y = substr($date, 6, 4);
$datez_m1 = substr($date1, 0, 4);
$datez_d1 = substr($date1, 4, 2);
$datez_y1 = substr($date1, 6, 4);
$date_format = $datez_m . "-" . $datez_d . "-" . $datez_y;
$date1_format = $datez_m1 . "-" . $datez_d1 . "-" . $datez_y1;
echo $date_format . "<Br>";
echo $date1_format . "<Br>";
?>
<script src="../js/jquery-2.1.4.min.js"></script>
<script>
$(document).ready(function(){
var isChrome = /Chrome/.test(navigator.userAgent) && /Google Inc/.test(navigator.vendor);
if( isChrome == true ) {
$("#export").click(function(){
<?php
include "../myDatabase3.php";
$inventoryCode = $_GET['inventoryCode'];
$refNo = $_GET['refNo'];
$sino = $_GET['sino'];
$page = $_GET['page'];
$username = $_GET['username'];
$ro = new database3();
$ro->coconutDesign();
$description = $ro->selectNow("salesInvoiceItems", "description", "inventoryCode", $inventoryCode);
$generic = $ro->selectNow("inventory", "genericName", "inventoryCode", $inventoryCode);
$unitcost = $ro->selectNow("salesInvoiceItems", "unitPrice", "inventoryCode", $inventoryCode);
$qty = $ro->selectNow("salesInvoiceItems", "quantity", "inventoryCode", $inventoryCode);
$fgqty = $ro->selectNow("salesInvoiceItems", "fgquantity", "inventoryCode", $inventoryCode);
$unit = $ro->selectNow("salesInvoiceItems", "unit", "inventoryCode", $inventoryCode);
echo "<br><br>";
$ro->coconutFormStart("post", "editPurchasing1.php");
$ro->coconutHidden("inventoryCode", $inventoryCode);
$ro->coconutHidden("refNo", $refNo);
$ro->coconutHidden("sino", $sino);
$ro->coconutHidden("page", $page);
$ro->coconutHidden("username", $username);
$ro->coconutBoxStart("500", "300");
echo "<br>";
echo "<table border=0>";
echo "<tr>";
echo "<td>Description</td>";
echo "<td>";
$ro->coconutTextBox("description", $description);
echo "</td>";
<?php
include "../../../myDatabase3.php";
$invoiceNo = $_GET['invoiceNo'];
$ro = new database3();
echo "<Br>";
echo "<center><font size=5>Protacio Hospital</font>";
echo "<br><br><br>";
echo "<font size=4>Accounts Payable Voucher</font>";
echo "<Table border='0' width='80%'>";
echo "</tr>";
echo "<td align='right'>AP.NO.<input type='text' style='border-top:0px; border-right:0px; border-left:0px; border-bottom:1px solid #000000; width:15%;' value='" . $ro->selectNow("purchaseJournal", "vouchersCode", "invoiceNo", $invoiceNo) . "'></td>";
echo "</tr>";
$date = $ro->selectNow("purchaseJournal", "date", "invoiceNo", $invoiceNo);
$yearDate = substr($date, "0", "4");
$monthDate = substr($date, "5", "2");
$dayDate = substr($date, "6", "2");
echo "</tr>";
echo "<td align='right'>Date.<input type='text' style='border-top:0px; border-right:0px; align:center; border-left:0px; border-bottom:1px solid #000000; width:15%;' value='{$yearDate}-{$monthDate}-{$dayDate}'></td>";
echo "</tr>";
echo "</table>";
echo "<Table border='1' cellspacing=0 width='80%'>";
echo "<tr>";
echo "<th>PARTICULARS</th>";
echo "</tr>";
$ro->purchaseJournal_items($invoiceNo);
echo "</table>";
echo "<Br><br>";
echo "<Table border='1' width='80%' cellspacing=0>";
echo "<tr>";
echo "<th>Description</th>";
<?php
include "../../myDatabase3.php";
$registrationNo = $_GET['registrationNo'];
$cashInputted = $_GET['cashInputted'];
$targetAmount = $_GET['targetAmount'];
$username = $_GET['username'];
$orNO = $_GET['orNO'];
$datePaid = $_GET['datePaid'];
$shift = $_GET['shift'];
$ro = new database3();
$excessPaid1 = 0;
$doctorsPF;
$otShare;
$deductions;
//echo ( $cash - $targetAmount );
echo "<center><br>";
$itemz = preg_split("/\\_/", $ro->getMaximumTotal_rBanny_cash_cashier($registrationNo));
echo "<Br>";
echo "Item#: " . $itemz[1];
echo "<br>Price: " . $itemz[0];
echo "<br><b>Analyzing " . $ro->selectNow("patientCharges", "description", "itemNo", $itemz[1]) . "</b>";
//check kung ilan na lang ung natitira sa target amount kpg bnwsan na sa current Paid ng px
if ($ro->getCurrentPaid_check_rBanny($registrationNo) >= $targetAmount) {
$pxPaid = $ro->getCurrentPaid_check_rBanny($registrationNo) - $targetAmount;
} else {
$pxPaid = $targetAmount - $ro->getCurrentPaid_check_rBanny($registrationNo);
}
//check kung mas mataas pa ung total ng item kaysa sa natitirang sa targetAmount=payment ng px
if ($itemz[0] >= $pxPaid) {
$newCash = $ro->selectNow("patientCharges", "cashUnpaid", "itemNo", $itemz[1]) - $targetAmount;
<?php
include "../../myDatabase3.php";
$registrationNo = $_GET['registrationNo'];
$username = $_GET['username'];
$shift = $_GET['shift'];
$ro = new database3();
$month = date("m");
$day = date("d");
$year = date("Y");
$fromTime_hour = date("H");
$fromTime_minutes = date("i");
$fromTime_seconds = date("s");
$toTime_hour = date("H");
$toTime_minutes = date("i");
$toTime_seconds = date("s");
$ro->getPatientChargesUnpaid($month, $day, $year, $fromTime_hour, $fromTime_minutes, $fromTime_seconds, $toTime_hour, $toTime_minutes, $toTime_seconds, $username, $registrationNo, $shift, "BALANCE");
<?php include "../../myDatabase3.php"; $date = $_GET['date']; $date1 = $_GET['date1']; $ro = new database3(); $ro->ipdPaymentsz_discountPatient($date, $date1);
$inventoryCode = $_POST['inventoryCode'];
$description = $_POST['description'];
$additional = $_POST['additional'];
//unitcost
$unitcost = $_POST['unitcost'];
//sellingPrice
$quantity = $_POST['quantity'];
$dateAdded = $_POST['dateAdded'];
$inventoryLocation = $_POST['inventoryLocation'];
$phic = $_POST['phic'];
$remarks = $_POST['remarks'];
$supplier = $_POST['supplier'];
$criticalLevel = $_POST['criticalLevel'];
$expiration = $_POST['expiration'];
$username = $_POST['username'];
$ro = new database3();
$ro->editNow("inventory", "inventoryCode", $inventoryCode, "description", $description);
if ($ro->selectNow("inventory", "inventoryType", "inventoryCode", $inventoryCode) == "medicine") {
$ro->editNow("inventory", "inventoryCode", $inventoryCode, "unitcost", $unitcost);
$ro->editNow("inventory", "inventoryCode", $inventoryCode, "Added", $additional);
} else {
$ro->editNow("inventory", "inventoryCode", $inventoryCode, "unitcost", $additional);
$ro->editNow("inventory", "inventoryCode", $inventoryCode, "suppliesUNITCOST", $unitcost);
}
//edit history
$generic = "";
$inventoryType = "supplies";
$qty = $ro->selectNow("inventory", "quantity", "inventoryCode", $inventoryCode);
$unitcost = $ro->selectNow("inventory", "suppliesUNITCOST", "inventoryCode", $inventoryCode);
$opdPrice = $ro->selectNow("inventory", "unitcost", "inventoryCode", $inventoryCode);
$ipdPrice = $ro->selectNow("inventory", "unitcost", "inventoryCode", $inventoryCode);
<?php
include "../../myDatabase3.php";
$itemNo = $_GET['itemNo'];
$count = count($itemNo);
$registrationNo = $_GET['registrationNo'];
$type = $_GET['type'];
$ro = new database3();
$price = "";
for ($x = 0; $x < $count; $x++) {
echo $itemNo[$x];
if ($type == "OPD") {
if ($ro->selectNow("patientCharges", "title", "itemNo", $itemNo[$x]) == "MEDICINE" || $ro->selectNow("patientCharges", "title", "itemNo", $itemNo[$x]) == "SUPPLIES") {
$sellingPrice = $ro->selectNow("inventory", "opdPrice", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo[$x]));
} else {
$sellingPrice = $ro->selectNow("availableCharges", "OPD", "chargesCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo[$x]));
}
} else {
if ($ro->selectNow("patientCharges", "title", "itemNo", $itemNo[$x]) == "MEDICINE" || $ro->selectNow("patientCharges", "title", "itemNo", $itemNo[$x]) == "SUPPLIES") {
$sellingPrice = $ro->selectNow("inventory", "ipdPrice", "inventoryCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo[$x]));
} else {
$sellingPrice = $ro->selectNow("availableCharges", "PRIVATE", "chargesCode", $ro->selectNow("patientCharges", "chargesCode", "itemNo", $itemNo[$x]));
}
}
$qty = $ro->selectNow("patientCharges", "quantity", "itemNo", $itemNo[$x]);
$total = $sellingPrice * $qty;
$ro->updatePriceNow_inventory($registrationNo, $itemNo[$x], $sellingPrice, $total);
}
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/patientProfile/updatePrice.php?registrationNo={$registrationNo}");
<?php
include "../../myDatabase3.php";
$username = $_GET['username'];
$ro = new database3();
$ro->coconutDesign();
echo "<Br><br><br><center>";
$ro->coconutBoxStart_red("500", "100");
$ro->coconutFormStart("post", "/COCONUT/currentPatient/patientInterface1.php");
$ro->coconutHidden("username", $username);
$ro->coconutHidden("registrationNo", "28690");
$ro->coconutHidden("from", "Cashier");
echo "<Br><br>";
$ro->coconutButton("Enter Walkin");
$ro->coconutFormStop();
$ro->coconutBoxStop();
<?php
include "../../myDatabase3.php";
$dateReport = $_GET['dateReport'];
$shiftReport = $_GET['shiftReport'];
$registrationNo = $_GET['registrationNo'];
$count = count($registrationNo);
$ro = new database3();
for ($x = 0; $x < $count; $x++) {
//echo $dateReport."-".$shiftReport;
$ro->getPatientProfile($registrationNo[$x]);
echo "<Br>" . $ro->getPatientRecord_lastName() . ", " . $ro->getPatientRecord_firstName();
$ro->updatePxNow($registrationNo[$x], $dateReport, $shiftReport);
}
<?php
include "../../../myDatabase3.php";
$invoiceNo = $_GET['invoiceNo'];
$ro = new database3();
$paymentMode = $ro->selectNow("vouchers", "paymentMode", "invoiceNo", $invoiceNo);
if ($paymentMode == "cash") {
//do nothing
} else {
$ro->gotoPage("http://" . $ro->getMyUrl() . "/COCONUT/accounting/voucher/voucherOutput.php?invoiceNo={$invoiceNo}");
}
<?php
include "../../myDatabase3.php";
$registrationNo = $_GET['registrationNo'];
$itemNo = $_GET['itemNo'];
$shift = $_GET['shift'];
$username = $_GET['username'];
$monthDischarged = $_GET['monthDischarged'];
$dayDischarged = $_GET['dayDischarged'];
$yearDischarged = $_GET['yearDischarged'];
$dateDischarged = $yearDischarged . "-" . $monthDischarged . "-" . $dayDischarged;
$ro = new database3();
//echo $registrationNo."<br>";
//echo $shift."<br>";
//echo $dateDischarged."<br>";
for ($x = 0; $x < count($itemNo); $x++) {
//echo $itemNo[$x]."<br>";
$ro->editNow("patientCharges", "itemNo", $itemNo[$x], "reportShift", $shift);
}
$ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "dateUnregistered", $dateDischarged);
$ro->EditNow("registrationDetails", "registrationNo", $registrationNo, "timeUnregistered", $ro->getSynapseTime());
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "mgh", $username);
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "unregisteredBy", $username);
$ro->editNow("registrationDetails", "registrationNo", $registrationNo, "mgh_date", $dateDischarged . "@" . $ro->getSynapseTime());
$ro->addDischargeHistory($registrationNo, "Closed", date("H:i:s"), $dateDischarged, $username);
echo "<center><br><Br><Br><font color=red>Patient Discharged</font>";
<?php
include "../../../myDatabase3.php";
$doctorName = $_GET['doctorName'];
$month = $_GET['month'];
$day = $_GET['day'];
$year = $_GET['year'];
$month1 = $_GET['month1'];
$day1 = $_GET['day1'];
$year1 = $_GET['year1'];
$ro = new database3();
$date = $year . "-" . $month . "-" . $day;
$date1 = $year1 . "-" . $month1 . "-" . $day1;
echo "<center><font size=5><b>" . $ro->getReportInformation("hmoSOA_name") . "</b></font>\n<br> <font size=4><b>PF LISTING</b></font>\n<br><font size=2><b>(Discharged {$month} {$day}, {$year} - {$month1} {$day1}, {$year1} )</b></font>\n\n</centeR>";
echo "<br><br>";
$ro->individual_doc_PF($doctorName, $month, $day, $year, $month1, $day1, $year1);
echo "<br><br>";
$ro->doctorPatient($doctorName, $date, $date1, "OPD");
<?php include "../../myDatabase3.php"; include "../../myDatabase4.php"; $date1 = $_GET['date1']; $date2 = $_GET['date2']; $totalCr = 0; ?> <?php $ro3 = new database3(); $ro4 = new database4(); ?> <?php $ro3->creditCardPatient($date1, $date2); ?> <!DOCTYPE html> <html> <head> <title></title> <meta charset="UTF-8"> <script src="../../jquery-2.1.4.min.js"></script> <script src="../js/jquery-ui.min.js"></script> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="../../bootstrap-3.3.6/css/bootstrap.css"></link> <link rel="stylesheet" href="../js/jquery-ui.css"></link> <link rel="stylesheet" href="../js/jquery-ui.theme.min.css"></link>
<?php
include "../myDatabase3.php";
$discountType = $_POST['discountType'];
$ro = new database3();
$ro->addDiscountTypez($discountType);
$ro->gotoPage("http://" . $ro->getMyUrl() . "/Maintenance/addDiscountType.php");
<?php
include "../../myDatabase3.php";
$ro = new database3();
$ro->updatePx("2015-10-30");
<?php
include "../../myDatabase3.php";
$cols = $_GET['cols'];
$date = $_GET['date'];
$date1 = $_GET['date1'];
$title = $_GET['title'];
$ro = new database3();
if ($cols == "cashUnpaid") {
$ro->transactionSummary_getPatient_cash($date, $date1, $title);
} else {
if ($cols == "hmo") {
$ro->transactionSummary_getPatient_hmo($date, $date1, $title);
} else {
}
}
<?php
include "../../../myDatabase3.php";
$ro = new database3();
$ro->coconutDesign();
$siNo = $_GET['siNo'];
$count = count($siNo);
$invoiceNo = $_GET['invoiceNo'];
$username = $_GET['username'];
$voucherNo = $ro->selectNow("trackingNo", "value", "name", "trackingNo");
$ro->editNow("trackingNo", "name", "trackingNo", "value", $voucherNo + 1);
/*
$ro->getVouchersNo();
$myFile = $ro->getReportInformation("homeRoot")."/COCONUT/trackingNo/voucherNo.dat";
$fh = fopen($myFile, 'r');
$voucherNo = fread($fh, 100);
fclose($fh);
*/
/*
for($x=0;$x<$count;$x++) {
//echo $siNo[$x];
$data = preg_split ("/\-/",$siNo[$x]);
$supplier = $ro->selectNow("supplier","supplierName","supplierCode",$data[2]);
$username = $data[3];
$invoiceNo = $ro->selectNow("salesInvoice","invoiceNo","siNo",$data[0]);
if( $ro->selectNow("supplier","vatable","supplierCode",$data[2]) == "yes" ) {
$lessVAT = ($data[1] / 1.12);
$vat = ( $data[1] - $lessVAT );
}else {
$lessVAT = $date[1];
$vat = 0;
<?php
include "../../../myDatabase3.php";
$startLetter = $_GET['startLetter'];
$ro = new database3();
echo "\n<style type='text/css'>\ntr:hover { background-color:yellow; color:black;}\na { border_bottom:10px; color:black; }\n\ntr.border_bottom td {\n border-bottom:1pt solid #CCCCCC;\n}\n\n</style>";
echo "<font><a href='sortStockCard.php' style='text-decoration:none; color:red;'>Stock Card starting letter {$startLetter}</a></font>";
echo "<form method='get' action='stockCardList1.php'>";
echo "<table border=1 cellspacing=0>";
echo "<tr>";
echo "<th> </th>";
echo "<th>stockCardNo</th>";
echo "<th>Description</th>";
echo "<th>Generic</th>";
echo "<th>Inventory tbl</th>";
echo "<th>PatientCharges tbl</th>";
echo "<td> </td>";
echo "</tr>";
$ro->stockCardMerge($startLetter);
echo "</table>";
$ro->coconutHidden("startLetter", $startLetter);
echo "<input type='submit' value='Proceed'>";
echo "</form>";
<?php
require_once "../authentication.php";
include "../../myDatabase3.php";
$supplier = $_POST['supplier'];
$ro = new database3();
$username = $ro->selectNow("registeredUser", "username", "employeeID", $_SESSION['employeeID']);
echo "<center>";
echo $ro->selectNow("supplier", "supplierName", "supplierCode", $supplier);
echo "<Br>";
echo $ro->selectNow("supplier", "address", "supplierCode", $supplier);
echo "<Br>";
echo $ro->selectNow("supplier", "contactPerson", "supplierCode", $supplier) . " - " . $ro->selectNow("supplier", "contactNo", "supplierCode", $supplier);
$ro->purchasingPayables($supplier, $username);
<?php
include "../../myDatabase3.php";
$inventoryCode = $_POST['inventoryCode'];
$description = $_POST['description'];
$generic = $_POST['generic'];
$quantity = $_POST['quantity'];
$unitcost = $_POST['unitcost'];
$ipdPrice = $_POST['ipdPrice'];
$opdPrice = $_POST['opdPrice'];
$expiration = $_POST['expiration'];
$ro = new database3();
/*
echo $inventoryCode."<br>";
echo $description."<br>";
echo $generic."<br>";
echo $quantity."<br>";
echo $unitcost."<br>";
echo $ipdPrice."<br>";
echo $opdPrice."<br>";
*/
//edit history
$beforeEdit_qty = $ro->selectNow("inventory", "quantity", "inventoryCode", $inventoryCode);
$beforeEdit_unitcost = $ro->selectNow("inventory", "unitcost", "inventoryCode", $inventoryCode);
$beforeEdit_opdPrice = $ro->selectNow("inventory", "opdPrice", "inventoryCode", $inventoryCode);
$beforeEdit_ipdPrice = $ro->selectNow("inventory", "ipdPrice", "inventoryCode", $inventoryCode);
$beforeEdit_dateAdded = $ro->selectNow("inventory", "dateAdded", "inventoryCode", $inventoryCode);
$beforeEdit_timeAdded = $ro->selectNow("inventory", "timeAdded", "inventoryCode", $inventoryCode);
$beforeEdit_username = $ro->selectNow("inventory", "addedBy", "inventoryCode", $inventoryCode);
$stockCardNo = $ro->selectNow("inventory", "stockCardNo", "inventoryCode", $inventoryCode);
$inventoryType = $ro->selectNow("inventory", "inventoryType", "inventoryCode", $inventoryCode);
