$phicTotal += $phic; ?> </td> <td> <?php $unpaid = round($ro4->inpatient_paymentMode_total_charges($registrationNo, "cashUnpaid") + $ro4->inpatient_paymentMode_total_inventory($registrationNo, "cashUnpaid") + $ro4->inpatient_paymentMode_total_inventory_takeHomeMeds($registrationNo, "cashUnpaid") + $ro2->selectNow("registrationDetails", "hmoManualExcessValue", "registrationNo", $registrationNo) + $ro2->selectNow("registrationDetails", "PHICportion", "registrationNo", $registrationNo) + $ro2->selectNow("registrationDetails", "excessMaxBenefits", "registrationNo", $registrationNo) + $ro2->selectNow("registrationDetails", "excessRoom", "registrationNo", $registrationNo) + $ro2->selectNow("registrationDetails", "excessPF", "registrationNo", $registrationNo), 2); echo $unpaid; $unpaidTotal += $unpaid; ?> </td> <td> <?php $cash = $ro4->inpatient_payment_total($registrationNo, "CASH"); echo $cash; $cashTotal += $cash; ?> </td> <td> <?php $creditCard = $ro4->inpatient_payment_total($registrationNo, "Credit Card"); echo $creditCard; $creditCardTotal += $creditCard; ?> </td> <td> <?php
<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; ?> </td>
</form> <div class="col-md-7"> <table class="table table-hover"> <thead> <tr> <th>Date</th> <th>Patient</th> <th>Amount</th> </tr> </thead> <tbody> <?php foreach ($ro4->inpatient_discharged_registrationNo() as $registrationNo) { ?> <?php $cash = $ro4->inpatient_payment_total($registrationNo, $payment); ?> <?php $refund = $ro4->inpatient_refund_total($registrationNo, $payment); ?> <?php $pxCash = $cash - $refund; ?> <?php $paymentTotal += $pxCash; ?> <?php if ($pxCash > 0) { ?> <tr> <td>