</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 $pxRefund = $ro4->inpatient_refund_total($registrationNo, "Cash"); ?> <?php if ($pxRefund > 0) { ?> <tr> <td> <?php echo $ro4->formatDate($ro->selectNow("registrationDetails", "dateUnregistered", "registrationNo", $registrationNo)); ?> </td> <td> <?php $patientNo = $ro->selectNow("registrationDetails", "patientNo", "registrationNo", $registrationNo); $lastName = $ro->selectNow("patientRecord", "lastName", "patientNo", $patientNo);
<td> <?php //$bal = round(( round($unpaid,2) - round($cash + $creditCard + $disc ,2) ),2); echo "x".$bal; $bal = round(round($unpaid, 2) - round($cash + $creditCard + $disc, 2), 2); echo $bal; if ($bal > 0) { $balTotal += $bal; } else { //kpg negative wag n isama sa total kc meron nman syang kabanggang account na excess payment } ?> </td> <td> <?php $refund = $ro4->inpatient_refund_total($registrationNo, "CASH"); echo $refund; $refundTotal += $refund; ?> </td> <td> <?php $grandBal = $bal + $refund; echo $grandBal; $grandBalTotal += $grandBal; ?> </td> <td>
<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> <?php echo $ro4->formatDate($ro->selectNow("registrationDetails", "dateUnregistered", "registrationNo", $registrationNo)); ?>