} 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);