Example #1
0
$date1 = $year1 . "-" . $month1 . "-" . $day1;
echo "<b>Transaction Summary</b>";
echo "<br><b>From</b> " . $date . " to " . $date1;
echo "\n<style type='text/css'>\ntr:hover { background-color:yellow; color:black;}\na {  border_bottom:10px; color:black; }\n</style>";
echo "<table border=0 width='100%'>";
echo "<tr>";
echo "<td width='30%'><b>OPD</b></td>";
echo "<td width='10%'>&nbsp;</td>";
echo "<td width='10%'>&nbsp;</td>";
echo "<td width='30%'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>IPD</b></td>";
echo "<td width='10%'>&nbsp;</td>";
echo "<td width='10%'>&nbsp;</td>";
/*******************CREDIT SIDE TOTAL*******************/
$opd_paidBalance = $ro->transactionSummary_paidBalance("OPD", $date, $date1);
$ipd_paidBalance = $ro->transactionSummary_paidBalance("IPD", $date, $date1);
$totalClinicRev = $ro->transactionSummary_opd_department_debit_paid("PROFESSIONAL FEE", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("PROFESSIONAL FEE", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("PROFESSIONAL FEE", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("PROFESSIONAL FEE", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("PROFESSIONAL FEE", $date, $date1);
$totalOR = $ro->transactionSummary_opd_department_debit_paid("OR/DR/ER Fee", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("OR/DR/ER Fee", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("OR/DR/ER Fee", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("OR/DR/ER Fee", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("OR/DR/ER Fee", $date, $date1);
$totalERFEE = $ro->transactionSummary_opd_department_debit_paid("ER FEE", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("ER FEE", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("ER FEE", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("ER FEE", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("ER FEE", $date, $date1);
$totalECG = $ro->transactionSummary_opd_department_debit_paid("ECG", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("ECG", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("ECG", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("ECG", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("ECG", $date, $date1);
$totalSPIROMETRY = $ro->transactionSummary_opd_department_debit_paid("SPIROMETRY", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("SPIROMETRY", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("SPIROMETRY", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("SPIROMETRY", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("SPIROMETRY", $date, $date1);
$totalXRAY = $ro->transactionSummary_opd_department_debit_paid("XRAY", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("XRAY", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("XRAY", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("XRAY", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("XRAY", $date, $date1);
$totalUTZ = $ro->transactionSummary_opd_department_debit_paid("ULTRASOUND", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("ULTRASOUND", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("ULTRASOUND", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("ULTRASOUND", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("ULTRASOUND", $date, $date1);
$totalCardiacMonitor = $ro->transactionSummary_opd_department_debit_paid("CARDIAC MONITOR", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("CARDIAC MONITOR", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("CARDIAC MONITOR", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("CARDIAC MONITOR", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("CARDIAC MONITOR", $date, $date1);
$totalCTSCAN = $ro->transactionSummary_opd_department_debit_paid("CTSCAN", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("CTSCAN", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("CTSCAN", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("ULTRASOUND", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("CTSCAN", $date, $date1);
$totalLab = $ro->transactionSummary_opd_department_debit_paid("LABORATORY", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("LABORATORY", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("LABORATORY", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("LABORATORY", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("LABORATORY", $date, $date1);
$totalMed = $ro->transactionSummary_opd_department_debit_paid("MEDICINE", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("MEDICINE", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("MEDICINE", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("MEDICINE", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("MEDICINE", $date, $date1);
$totalSup = $ro->transactionSummary_opd_department_debit_paid("SUPPLIES", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("SUPPLIES", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("SUPPLIES", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("SUPPLIES", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("SUPPLIES", $date, $date1);
$totalPT = $ro->transactionSummary_opd_department_debit_paid("REHAB", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("REHAB", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("REHAB", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("REHAB", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("REHAB", $date, $date1);
$dermaTotal = $ro->transactionSummary_opd_department_debit_paid("DERMATOLOGY", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("DERMATOLOGY", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("DERMATOLOGY", "HMO", $date, $date1);
/*******************CREDIT SIDE TOTAL*******************/
/******************IPD TOTAL******************/
Example #2
0
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}
echo "Trial Balance";
echo "<br>";
echo $monthWord . " " . $year;
/*****************  OPD  ************************/
/*********** debit side *********************/
$opdCreditCard = $ro->transactionSummary_opd_department_debit_paid("LABORATORY", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("MEDICINE", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("SUPPLIES", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("PROFESSIONAL FEE", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("OR/DR/ER Fee", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("ER FEE", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("ECG", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("SPIROMETRY", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("XRAY", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("ULTRASOUND", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("CARDIAC MONITOR", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("CTSCAN", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("REHAB", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("DERMATOLOGY", "amountPaidFromCreditCard", $date, $date1);
$opdCash = $ro->transactionSummary_opd_department_debit_paid("LABORATORY", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("MEDICINE", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("SUPPLIES", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("PROFESSIONAL FEE", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("PROFESSIONAL FEE", "doctorsPF", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("OR/DR/ER Fee", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("ER FEE", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("ECG", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("SPIROMETRY", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("XRAY", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("ULTRASOUND", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("CARDIAC MONITOR", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("CTSCAN", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("REHAB", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("DERMATOLOGY", "cashPaid", $date, $date1);
$opdHMO = $ro->transactionSummary_opd_department_debit_covered("LABORATORY", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("MEDICINE", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("SUPPLIES", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("PROFESSIONAL FEE", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("OR/DR/ER Fee", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("ER FEE", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("ECG", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("SPIROMETRY", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("XRAY", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("ULTRASOUND", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("CARDIAC MONITOR", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("CTSCAN", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("REHAB", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("DERMATOLOGY", "HMO", $date, $date1);
$opdCompany = $ro->transactionSummary_opd_department_debit_covered("LABORATORY", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("MEDICINE", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("SUPPLIES", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("PROFESSIONAL FEE", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("OR/DR/ER Fee", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("ER FEE", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("ECG", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("SPIROMETRY", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("XRAY", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("ULTRASOUND", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("CARDIAC MONITOR", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("CTSCAN", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("REHAB", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("DERMATOLOGY", "COMPANY", $date, $date1);
$opdPersonalBalance = $ro->transactionSummary_opd_department_debit_personalBalance("LABORATORY", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("MEDICINE", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("SUPPLIES", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("PROFESSIONAL FEE", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("OR/DR/ER Fee", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("ER FEE", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("ECG", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("SPIROMETRY", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("XRAY", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("ULTRASOUND", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("CARDIAC MONITOR", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("CTSCAN", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("REHAB", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("DERMATOLOGY", $date, $date1);
$opdDiscount = $ro->transactionSummary_opd_department_debit_discount("LABORATORY", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("MEDICINE", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("SUPPLIES", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("PROFESSIONAL FEE", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("OR/DR/ER Fee", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("ER FEE", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("ECG", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("SPIROMETRY", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("XRAY", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("ULTRASOUND", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("CARDIAC MONITOR", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("CTSCAN", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("REHAB", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("DERMATOLOGY", $date, $date1);
/**********************debit side*********************************/
/*************************credit side***************************/
$opdPaidBalance = $ro->transactionSummary_paidBalance("OPD", $date, $date1);
$opdDoctor = $ro->transactionSummary_opd_department_debit_paid("PROFESSIONAL FEE", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("PROFESSIONAL FEE", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("PROFESSIONAL FEE", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("PROFESSIONAL FEE", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("PROFESSIONAL FEE", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("PROFESSIONAL FEE", $date, $date1);
$opdOR = $ro->transactionSummary_opd_department_debit_paid("OR/DR/ER Fee", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("OR/DR/ER Fee", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("OR/DR/ER Fee", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("OR/DR/ER Fee", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("OR/DR/ER Fee", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("OR/DR/ER Fee", $date, $date1);
$opdERFEE = $ro->transactionSummary_opd_department_debit_paid("ER FEE", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("ER FEE", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("ER FEE", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("ER FEE", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("ER FEE", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("ER FEE", $date, $date1);
$opdECG = $ro->transactionSummary_opd_department_debit_paid("ECG", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("ECG", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("ECG", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("ECG", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("ECG", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("ECG", $date, $date1);
$opdSpirometry = $ro->transactionSummary_opd_department_debit_paid("SPIROMETRY", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("SPIROMETRY", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("SPIROMETRY", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("SPIROMETRY", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("SPIROMETRY", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("SPIROMETRY", $date, $date1);
$opdXray = $ro->transactionSummary_opd_department_debit_paid("XRAY", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("XRAY", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("XRAY", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("XRAY", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("XRAY", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("XRAY", $date, $date1);
$opdUltrasound = $ro->transactionSummary_opd_department_debit_paid("ULTRASOUND", "amountPaidFromCreditCard", $date, $date1) + $ro->transactionSummary_opd_department_debit_paid("ULTRASOUND", "cashPaid", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("ULTRASOUND", "HMO", $date, $date1) + $ro->transactionSummary_opd_department_debit_covered("ULTRASOUND", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("ULTRASOUND", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("ULTRASOUND", $date, $date1);
<?php

include $_SERVER['DOCUMENT_ROOT'] . "/myDatabase2.php";
$title = $_GET['title'];
$date = $_GET['date'];
$date1 = $_GET['date1'];
$ro = new database2();
$creditCard = $ro->transactionSummary_opd_department_debit_paid($title, "amountPaidFromCreditCard", $date, $date1);
$cash = $ro->transactionSummary_opd_department_debit_paid($title, "cashPaid", $date, $date1);
$hmo = $ro->transactionSummary_opd_department_debit_covered($title, "HMO", $date, $date1);
//$company = $ro->transactionSummary_opd_department_debit_covered($title,"COMPANY",$date,$date1);
$personal = $ro->transactionSummary_opd_department_debit_personalBalance($title, $date, $date1);
$discount = $ro->transactionSummary_opd_department_debit_discount($title, $date, $date1);
echo "\n<style type='text/css'>\ntr:hover { background-color:yellow;color:black;}\n\na { text-decoration:none; color:black; }\n</style>";
echo "<center>";
echo "<font size=4 color=red>{$title}</font>";
echo "<br>";
echo "<table border=1 cellspacing=0>";
echo "<Tr>";
echo "<Th>OPD</th>";
echo "<th>Amount</th>";
echo "</tr>";
echo "<tr>";
if ($creditCard > 0) {
    echo "<td>&nbsp;<a href='/COCONUT/billing/transactionSummary_creditCard.php?title={$title}&date={$date}&date1={$date1}' style='text-decoration:none; color:black;' target='rightFrame' ><b>Credit Card</b></a></td>";
    echo "<td>&nbsp;" . number_format($creditCard, 2) . "&nbsp;</td>";
    echo "</tr>";
} else {
    echo "<td>&nbsp;<b>Credit Card</b></td>";
    echo "<td>&nbsp;</td>";
    echo "</tr>";