<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; } }