$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%'> </td>"; echo "<td width='10%'> </td>"; echo "<td width='30%'> <b>IPD</b></td>"; echo "<td width='10%'> </td>"; echo "<td width='10%'> </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******************/
} } } } } 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); $opdCardiacMonitor = $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_covered("CARDIAC MONITOR", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("CARDIAC MONITOR", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("CARDIAC MONITOR", $date, $date1); $opdCTSCAN = $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_covered("CTSCAN", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("ULTRASOUND", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("CTSCAN", $date, $date1); $opdLaboratory = $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_covered("LABORATORY", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("LABORATORY", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("LABORATORY", $date, $date1); $opdMedicine = $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_covered("MEDICINE", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("MEDICINE", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("MEDICINE", $date, $date1); $opdSupplies = $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_covered("SUPPLIES", "COMPANY", $date, $date1) + $ro->transactionSummary_opd_department_debit_personalBalance("SUPPLIES", $date, $date1) + $ro->transactionSummary_opd_department_debit_discount("SUPPLIES", $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> <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> " . number_format($creditCard, 2) . " </td>"; echo "</tr>"; } else { echo "<td> <b>Credit Card</b></td>"; echo "<td> </td>"; echo "</tr>";