Exemple #1
0
					<thead>
						<tr>
							<th>Reg#</th>
							<th>Discharged</th>
							<th>Patient</th>
							<th>Balance</th>
							<th></th>
						</tr>
					</thead>
					<tbody>
						<?php 
foreach ($ro4->inpatient_discharged_registrationNo() as $registrationNo) {
    ?>
						<?php 
    //get balance px
    $unpaid = round($ro4->inpatient_paymentMode_total_charges($registrationNo, "cashUnpaid") + $ro4->inpatient_paymentMode_total_inventory($registrationNo, "cashUnpaid") + $ro4->inpatient_paymentMode_total_inventory_takeHomeMeds($registrationNo, "cashUnpaid") + $ro->selectNow("registrationDetails", "hmoManualExcessValue", "registrationNo", $registrationNo) + $ro->selectNow("registrationDetails", "PHICportion", "registrationNo", $registrationNo) + $ro->selectNow("registrationDetails", "excessMaxBenefits", "registrationNo", $registrationNo) + $ro->selectNow("registrationDetails", "excessRoom", "registrationNo", $registrationNo) + $ro->selectNow("registrationDetails", "excessPF", "registrationNo", $registrationNo), 2);
    $cash = $ro4->inpatient_payment_total($registrationNo, "Cash");
    $balPaid = $ro4->inpatient_balancePayment_total($registrationNo, "Cash");
    $creditCard = $ro4->inpatient_payment_total($registrationNo, "Credit Card");
    $disc = round($ro->selectNow("registrationDetails", "discount", "registrationNo", $registrationNo), 2);
    $totalPaid = $cash + $balPaid + $creditCard + $disc;
    $bal = $unpaid - $totalPaid;
    ?>

							<?php 
    if ($bal > 0) {
        ?>
							<tr>
								<td><?php 
        echo $registrationNo;
        ?>
					</thead>
					<tbody>
						<?php 
foreach ($ro4->inpatient_discharged_registrationNo() as $registrationNo) {
    ?>
							<?php 
    $cashPayment = $ro4->inpatient_payment_total($registrationNo, "Cash");
    ?>
							<?php 
    $creditCardPayment = $ro4->inpatient_payment_total($registrationNo, "Credit Card");
    ?>
							<?php 
    $discount = $ro->selectNow("registrationDetails", "discount", "registrationNo", $registrationNo);
    ?>
							<?php 
    $pxCharges = round($ro4->inpatient_paymentMode_total_charges($registrationNo, "cashUnpaid") + $ro4->inpatient_paymentMode_total_inventory($registrationNo, "cashUnpaid") + $ro4->inpatient_paymentMode_total_inventory_takeHomeMeds($registrationNo, "cashUnpaid"), 2);
    ?>
							<?php 
    $hmoExcess = $ro->selectNow("registrationDetails", "hmoManualExcessValue", "registrationNo", $registrationNo) + $ro->selectNow("registrationDetails", "PHICportion", "registrationNo", $registrationNo) + $ro->selectNow("registrationDetails", "excessMaxBenefits", "registrationNo", $registrationNo) + $ro->selectNow("registrationDetails", "excessRoom", "registrationNo", $registrationNo) + $ro->selectNow("registrationDetails", "excessPF", "registrationNo", $registrationNo);
    ?>
							<?php 
    $pxTotalCharges = $pxCharges + $hmoExcess;
    ?>
							<?php 
    $pxPayment = $cashPayment + $creditCardPayment + $discount;
    ?>
							<?php 
    $pxBalance = $pxTotalCharges - $pxPayment;
    ?>
							<?php 
    if ($pxBalance > 0) {