<th>Phone No</th>
<th>Business Name</th>
<th>Status</th>
<th>Rent/M</th>
<th>Arrears(<?php
echo $month;
?>
)</th>
</tr>
</thead>
<tbody>
<?php
foreach ($tenants as $tnt) {
?>
<?php
$bal = Arrears::findByPeriodForTenant($tnt->id, $start, $end);
//echo var_dump($bal);
$arrears = 0.0;
if (is_null($bal) && $tnt->getPaymentStatus() == 0) {
$arrears = Room::findByTenantId($tnt->id)->getRent();
} elseif (!is_null($bal)) {
$arrears = $bal->getAmountOwed();
}
?>
<tr <?php
if ($tnt->getPaymentStatus() == 0) {
echo ' style="background:red;color:white;"';
}
?>
>
<td align="right"><a href="tenant.php?tid=<?php
/**
* Delete a rent payment
* @todo Delete records from both the rent and payment_status tables
* @return boolean
*/
public function deletePayment()
{
$start = $this->getStartPeriod();
$end = $this->getEndPeriod();
$tenant_id = $this->_tid;
$payment_status = PaymentStatus::findByPeriod($tenant_id, $start, $end);
$arrears = Arrears::findByPeriodForTenant($tenant_id, $start, $end);
$db = Database::getInstance();
$mysqli = $db->getConnection();
$mysqli->autocommit(false);
if (!is_null($arrears)) {
if ($arrears->arrearsExist($tenant_id, $start, $end)) {
$arrears->deleteTenantArrearsForPeriod($start, $end);
}
}
$payment_status->delete();
$this->delete();
if (!$mysqli->commit()) {
$mysqli->rollback();
$mysqli->autocommit(true);
return false;
} else {
$mysqli->autocommit(true);
return true;
}
}
