Exemple #1
0
<?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>";
echo "\n\n<script>\n\n\$(document).ready(function(){\n\t\$('#date').datepicker({\n\t\tdateFormat:'yy-mm-dd'\n\t});\n});\n\n</script>\n\n<style>\n.shortField {\n\tborder: 1px solid #000;\n\tcolor: #000;\n\theight: 30px;\n\twidth: 120px;\n\tpadding:4px 4px 4px 5px;\n}\n</style>\n\n\n";
$invoiceTotal1 = "";
$ro->coconutFormStart("get", "addVouchers_purchasing1.php");
for ($x = 0; $x < $count; $x++) {
    $invoiceTotal = $ro->purchasingPayablesTotal($siNo[$x]);
    //echo "<input type='checkbox' style='visibility:hidden' name='siNo[]' value='".$siNo[$x]."' checked>Invoice#".$ro->selectNow("salesInvoice","invoiceNo","siNo",$siNo[$x])." - ".number_format(round($invoiceTotal,2),2)."<br>";
    echo "<input type='checkbox' style='visibility:hidden' name='siNo[]' value='" . $siNo[$x] . "' checked>";
    $invoiceTotal1 += $invoiceTotal;
    $supplier = $ro->selectNow("supplier", "supplierName", "supplierCode", $ro->selectNow("salesInvoice", "supplier", "siNo", $siNo[$x]));
}
echo "Invoice Total&nbsp;<b>" . number_format(round($invoiceTotal1, 2), 2) . "</b>";
$vattable = round($invoiceTotal1 / 1.12, 2);
$vat = round($invoiceTotal1 - $vattable, 2);
$wTax = round($vattable * 0.01, 2);
$netTotal = round($invoiceTotal1 - $wTax, 2);
$ro->coconutHidden("invoiceNo", $invoiceNo);
$ro->coconutHidden("username", $username);
$ro->coconutHidden("vat", $vat);
$ro->coconutHidden("voucherNo", $voucherNo);
$ro->coconutBoxStart("500", "420");
echo "<br>";
echo "<table>";
echo "<tr>";
echo "<TD>Check#</tD>";
echo "<TD>";
$ro->coconutTextBox("checkNo", "");
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<TD>Bank</tD>";
echo "<TD>";
Exemple #3
0
<?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();
Exemple #4
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>&nbsp;</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>&nbsp;</td>";
echo "</tr>";
$ro->stockCardMerge($startLetter);
echo "</table>";
$ro->coconutHidden("startLetter", $startLetter);
echo "<input type='submit' value='Proceed'>";
echo "</form>";
Exemple #5
0
$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>";
echo "</tr>";
echo "<tr>";
echo "<td>Generic</td>";
Exemple #6
0
$title = $_GET['title'];
$paidVia = $_GET['paidVia'];
$cashPaid = $_GET['cashPaid'];
$batchNo = $_GET['batchNo'];
$username = $_GET['username'];
$quantity = $_GET['quantity'];
$inventoryFrom = $_GET['inventoryFrom'];
$paycash = $_GET['paycash'];
$remarks = $_GET['remarks'];
$ro = new database3();
$ro->coconutDesign();
if ($title == "BALANCE") {
    echo "<br><br>";
    $ro->coconutFormStart("get", "/COCONUT/availableCharges/addCharges.php");
    $ro->coconutBoxStart("500", "80");
    $ro->coconutHidden("status", $status);
    $ro->coconutHidden("registrationNo", $registrationNo);
    $ro->coconutHidden("chargesCode", $chargesCode);
    $ro->coconutHidden("description", $description);
    $ro->coconutHidden("discount", $discount);
    $ro->coconutHidden("timeCharge", $timeCharge);
    $ro->coconutHidden("chargeBy", $chargeBy);
    $ro->coconutHidden("service", $service);
    $ro->coconutHidden("title", $title);
    $ro->coconutHidden("paidVia", $paidVia);
    $ro->coconutHidden("cashPaid", $cashPaid);
    $ro->coconutHidden("batchNo", $batchNo);
    $ro->coconutHidden("username", $username);
    $ro->coconutHidden("quantity", $quantity);
    $ro->coconutHidden("inventoryFrom", $inventoryFrom);
    $ro->coconutHidden("paycash", $paycash);
$stTotal = $ro3->showTherapyAccounts_total();
$stCreditCard = $ro3->showTherapyAccounts_creditCard();
$stCash = $ro3->showTherapyAccounts_cash();
$stHMO = $ro3->showTherapyAccounts_hmo();
$stPHIC = $ro3->showTherapyAccounts_phic();
$stUnpaid = $ro3->showTherapyAccounts_unpaid();
$stShare = $ro3->showTherapyAccounts_pf();
$st_Payables = $ro3->showTherapyAccounts_payable();
$st_hmo_Payables = $ro3->showTherapyAccounts_hmo_payable();
$stDiscount = $ro3->showTherapyAccounts_discount();
echo "</table>";
?>

<?php 
echo "<Br>From {$date} to {$date1}<bR>";
$ro3->coconutHidden("month", $month);
$ro3->coconutHidden("day", $day);
$ro3->coconutHidden("year", $year);
$ro3->coconutHidden("month1", $month1);
$ro3->coconutHidden("day1", $day1);
$ro3->coconutHidden("year1", $year1);
$ro3->coconutHidden("deposit_cash", $deposit_cash);
$ro3->coconutHidden("deposit_creditCard", $deposit_creditCard);
$ro3->coconutHidden("balancePaid_cash", $balancePaid_cash);
$ro3->coconutHidden("balancePaid_creditCard", $balancePaid_creditCard);
echo "<br><br><br>";
echo "OPD:&nbsp;" . number_format($ro3->showPFaccounts_total() + $ro3->_opd_totalz() + $otTotal + $stTotal, 2);
echo "<Br>";
echo "IPD:&nbsp;" . number_format($ro3->showAllAccountTitle_ipd_total(), 2);
echo "<br>";
echo "<a href='#' id='totalLink' style='text-decoration:none; color:black'>Total:&nbsp;" . number_format($ro3->showPFaccounts_total() + $ro3->_opd_totalz() + $otTotal + $stTotal + $ro3->showAllAccountTitle_ipd_total(), 2) . "</a>";
Exemple #8
0
<?php

include "../../../myDatabase3.php";
$date = $_GET['date'];
$shift = $_GET['shift'];
$ro = new database3();
$ro->coconutDesign();
echo "<Br><br><br><br><br><br><Br><Br>";
$ro->coconutFormStart("get", "attributes1.php");
$ro->coconutHidden("date", $date);
$ro->coconutHidden("shift", $shift);
echo "<table border=0>";
echo "<tr>";
echo "<td>";
$ro->coconutComboboxStart_long("attributes");
echo "<option></option>";
echo "<option>Cash</option>";
echo "<option>Cr.Card</option>";
echo "<option>Voucher</option>";
echo "<option>Check</option>";
echo "<option>Change</option>";
$ro->coconutComboBoxStop();
echo "</td>";
echo "<td>";
$ro->coconutTextBox_short("amount", "");
echo "</td>";
echo "</tr>";
echo "<Tr>";
echo "<td>";
$ro->coconutTextBox("attributeName", "");
echo "</td>";
Exemple #9
0
<?php

include "../../myDatabase3.php";
$patientCount = $_GET['patientCount'];
$username = $_GET['username'];
$ro = new database3();
echo "<br><br>";
$ro->coconutFormStart("get", "viewPx1.php");
$ro->coconutHidden("username", $username);
echo "<input type='text' name='patientCount' value='' autocomplete='off' style='border:1px solid #ff0000; height:5%;' placeholder='&nbsp;Patient Count' >";
$ro->coconutFormStop();
$ro->showPatientViaCount($patientCount, date("Y-m-d"), $username);