-
Notifications
You must be signed in to change notification settings - Fork 1
/
trailer.php
108 lines (106 loc) · 3.04 KB
/
trailer.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
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
<?php
session_start();
include("class.trailer.dao.php");
include_once("header.php");
$dao = new DAOtrailer();
?>
<center><b><u><font face ="Britannic Bold"><h1>Trailer</h1></font></u></b></center><br>
<a href="form.trailer.php" class="btn btn-info">Add trailer</a><br>
<table class="table table-striped">
<tr class ="info">
<td>#</td>
<td>Make</td>
<td>Year Model</td>
<td>Year First Sold</td>
<td>Vlf Class</td>
<td>Vehicle Type</td>
<td>License Type</td>
<td>License Number</td>
<td>Model Body Type</td>
<td>MP</td>
<td>MO</td>
<td>AX</td>
<td>WC</td>
<td>Unladen G Cgw</td>
<td>Vehicle Id Num</td>
<td>Vehicle Use Type</td>
<td>Date Issued</td>
<td>Cc Alco</td>
<td>Date Fee Recieved</td>
<td>Picture</td>
<td>Registered Owner</td>
<td>Amount Due</td>
<td>Amount Recieved</td>
<td>Amount Paid</td>
<td><b>Edit</b></td>
<td><b>Delete</b></td>
</tr>
<?php
$rec_per_page = 10;
if(isset($_GET['page']))
$page = $_GET['page'];
else
$page = 1;
$limit1 = ($page-1)*$rec_per_page;
$limit2 = ($page)*$rec_per_page;
$total_recs = $dao->getCount();
$rec = $dao->getAllByUser($_SESSION["uid"],$limit1, $limit2);
$pages = ceil($total_recs/$rec_per_page);
if($page==1) $prev = $page;
else $prev=$page-1;
if($page==$pages) $next = $page;
else $next=$page+1;
$i = 0;
if ($rec) foreach($rec as $row) {
$i++;
?>
<tr>
<tbody>
<td><? echo $i ?> </td>
<td><? echo $row->make ?> </td>
<td><? echo $row->yr_model ?> </td>
<td><? echo $row->yr_first_sold ?> </td>
<td><? echo $row->vlf_class ?> </td>
<td><? echo $row->type_veh ?> </td>
<td><? echo $row->type_lic ?> </td>
<td><? echo $row->license_num ?> </td>
<td><? echo $row->body_type_model ?> </td>
<td><? echo $row->mp ?> </td>
<td><? echo $row->mo ?> </td>
<td><? echo $row->ax ?> </td>
<td><? echo $row->wc ?> </td>
<td><? echo $row->unladen_g_cgw ?> </td>
<td><? echo $row->vehicle_id_num ?> </td>
<td><? echo $row->type_vehicle_use ?> </td>
<td><? echo $row->date_issued ?> </td>
<td><? echo $row->cc_alco ?> </td>
<td><? echo $row->dt_fee_recvd ?> </td>
<td><? echo $row->pic ?> </td>
<td><? echo $row->registered_owner ?> </td>
<td><? echo $row->amount_due ?> </td>
<td><? echo $row->amount_recvd ?> </td>
<td><? echo $row->amount_paid ?> </td>
<th><a href='form.trailer.php?id=<? echo $row->trailer_id ?>'><img src="img/edit.png" width = 20 height = 20 /></a></th>
<th><a href='delete.trailer.php?id=<? echo $row->trailer_id ?>'><img src="img/del.png" width = 20 height = 20 /></a></th>
</tr>
</tbody>
<?}
else echo "<tr><td colspan='17'><center><br><br><br><b>No Trailers are added yet.</b></center></td></tr>";
?>
</table>
<?
if($page != 1){
?> <a href="trailer.php?page=<?=$prev?>" style="margin-right:20px">Prev</a>
<?}
for ($p =1; $p<=$pages ; $p++){
?> <a href="trailer.php?page=<?=$p?>"><?=$p."/".$pages?></a>
<?
}
if($page != $pages){
?><a href="trailer.php?page=<?=$next?>" style="margin-left:20px">Next</a>
<a href="trailer.php?page=<?=$pages?>"style="margin-left:12px">Last</a><br />
<?}
?>
<?php
include("footer.php");
?>