-
Notifications
You must be signed in to change notification settings - Fork 2
/
view_payment.php
77 lines (74 loc) · 2.48 KB
/
view_payment.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
<?php include 'db_connect.php' ?>
<?php
$tenants = $conn->query("SELECT t.*,concat(t.lastname,', ',t.firstname,' ',t.middlename) as name,h.house_no,h.price FROM tenants t inner join houses h on h.id = t.house_id where t.id = {$_GET['id']} ");
foreach ($tenants->fetch_array() as $k => $v) {
if (!is_numeric($k)) {
$$k = $v;
}
}
$months = abs(strtotime(date('Y-m-d') . " 23:59:59") - strtotime($date_in . " 23:59:59"));
$months = floor(($months) / (30 * 60 * 60 * 24));
$payable = $price * $months;
$paid = $conn->query("SELECT SUM(amount) as paid FROM payments where tenant_id =" . $_GET['id']);
$last_payment = $conn->query("SELECT * FROM payments where tenant_id =" . $_GET['id'] . " order by unix_timestamp(date_created) desc limit 1");
$paid = $paid->num_rows > 0 ? $paid->fetch_array()['paid'] : 0;
$last_payment = $last_payment->num_rows > 0 ? date("M d, Y", strtotime($last_payment->fetch_array()['date_created'])) : 'N/A';
$outstanding = $payable - $paid;
?>
<div class="container-fluid">
<div class="col-lg-12">
<div class="row">
<div class="col-md-4">
<div id="details">
<large><b>Details</b></large>
<hr>
<p>Tenant: <b><?php echo ucwords($name) ?></b></p>
<p>Monthly Rental Rate: <b><?php echo number_format($price, 2) ?></b></p>
<p>Outstanding Balance: <b><?php echo number_format($outstanding, 2) ?></b></p>
<p>Total Paid: <b><?php echo number_format($paid, 2) ?></b></p>
<p>Rent Started: <b><?php echo date("M d, Y", strtotime($date_in)) ?></b></p>
<p>Payable Months: <b><?php echo $months ?></b></p>
</div>
</div>
<div class="col-md-8">
<large><b>Payment List</b></large>
<hr>
<table class="table table-condensed table-striped">
<thead>
<tr>
<th>Date</th>
<th>Invoice</th>
<th>Amount</th>
</tr>
</thead>
<tbody>
<?php
$payments = $conn->query("SELECT * FROM payments where tenant_id = $id");
if ($payments->num_rows > 0) :
while ($row = $payments->fetch_assoc()) :
?>
<tr>
<td><?php echo date("M d, Y", strtotime($row['date_created'])) ?></td>
<td><?php echo $row['invoice'] ?></td>
<td class='text-right'><?php echo number_format($row['amount'], 2) ?></td>
</tr>
<?php endwhile; ?>
<?php else : ?>
<?php endif; ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<style>
#details p {
margin: unset;
padding: unset;
line-height: 1.3em;
}
td,
th {
padding: 3px !important;
}
</style>