<div class="col-md-8">
<table class="table table-hover">
<thead>
<tr>
<th>Patient</th>
<th>Admitted</th>
<th>Receivables</th>
</tr>
</thead>
<tbody>
<?php
foreach ($ro4->inpatient_discharged_registrationNo() as $registrationNo) {
?>
<?php
$phic = round($ro4->inpatient_paymentMode_total_charges($registrationNo, "phic") + $ro4->inpatient_paymentMode_total_inventory($registrationNo, "phic"), 2);
$patientType = $ro->selectNow("registrationDetails", "type", "registrationNo", $registrationNo);
?>
<?php
if ($phic > 0) {
?>
<tr>
<td>
<?php
$patientNo = $ro->selectNow("registrationDetails", "patientNo", "registrationNo", $registrationNo);
$lastName = $ro->selectNow("patientRecord", "lastName", "patientNo", $patientNo);
$firstName = $ro->selectNow("patientRecord", "firstName", "patientNo", $patientNo);
echo strtoupper($lastName) . ", " . strtoupper($firstName);
$totalPatient += 1;
?>
</td>
<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) {
