$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>
