dgm_office_view.

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

7/27/2012 12:13 PM

<?php
require_once("../includes/function.php");
require_once("../includes/session.php");
require_once("../includes/database.php");
require_once("../includes/dgm.php");
require_once("../includes/user.php");
if(!$session->is_logged_in()) {
redirect_to("login.php");
}
?>
<?php
if(isset($_GET['submit'])){
$keyword = $_GET['search'];
$dgm_offices = $dgm::find_by_keyword($keyword);
if(empty($dgm_offices)){
$message = "No results for the current search";
$view_dgm_offices = array();
} else {
$view_dgm_offices = $dgm_offices;
}
$pagination = "";
} else {

$tbl_name="dgm";
//your table name
// How many adjacent pages should be shown on each side?
$adjacents = 3;
/*
First get total number of rows in data table.
If you have a WHERE clause in your query, make sure you mirror it here.
*/
$query = "SELECT COUNT(*) as num FROM $tbl_name WHERE data_mining=1";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages['num'];
/* Setup vars for query. */
$targetpage = "dgm_office_view.php";

//your file name

(the name of

this file)
43
44
45
46
47
48
49

$limit = 30;
//how many items to show per page
$page = (isset($_GET['page'])) ? (int)$_GET['page'] : 0;
if($page)
$start = ($page - 1) * $limit;

//first item to display on

this page
50
51

else
$start = 0;

//if no page var is given, set

start to 0
52
53
54
55
56
57

/* Get data. */
$view_dgm_offices = DgmOffice::find_all_with_pagination($start, $limit);
/* Setup page vars for display. */
if ($page == 0) $page = 1;

//if no page var is given,

default to 1.
58
59
60
61
62
63
64
65
66
67
68
69
70

$prev = $page - 1;
$next = $page + 1;
$lastpage = ceil($total_pages/$limit);
items per page, rounded up.
$lpm1 = $lastpage - 1;

//previous page is page - 1

/*
Now we apply our rules and draw the pagination object.
We're actually saving the code to a variable in case we want to draw
it more than once.
*/
$pagination = "";
if($lastpage > 1)
{
$pagination .= "<div class=\"pagination\">";
Page 1 of 4

dgm_office_view.php
71
72
73

7/27/2012 12:13 PM
//previous button
if ($page > 1)
$pagination.= "<a href=\"$targetpage?page=$prev\"><<

previous</a>";
74
75
76
77
78

else
$pagination.= "<span class=\"disabled\"><< previous</span>";
//pages
if ($lastpage < 7 + ($adjacents * 2))

//not enough pages to bother

breaking it up
79
80
81
82
83
84
85

{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a
href=\"$targetpage?page=$counter\">$counter</a>";

86
87
88

}
}
elseif($lastpage > 5 + ($adjacents * 2))

//enough pages to hide

some
{

89
90
91
92
93

//close to beginning; only hide later pages

94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129

{
if ($counter == $page)
$pagination.= "<span
class=\"current\">$counter</span>";
else
$pagination.= "<a
href=\"$targetpage?page=$counter\">$counter</a>";
}
$pagination.= "...";
$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
$pagination.= "<a
href=\"$targetpage?page=$lastpage\">$lastpage</a>";
}
//in middle; hide some front and some back
elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents
* 2))
{
$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
$pagination.= "...";
for ($counter = $page - $adjacents; $counter <= $page +
$adjacents; $counter++)
{
if ($counter == $page)
$pagination.= "<span
class=\"current\">$counter</span>";
else
$pagination.= "<a
href=\"$targetpage?page=$counter\">$counter</a>";
}
$pagination.= "...";
$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
$pagination.= "<a
href=\"$targetpage?page=$lastpage\">$lastpage</a>";
}
//close to end; only hide early pages
else
{
$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
$pagination.= "...";
for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter
<= $lastpage; $counter++)
{
if ($counter == $page)
Page 2 of 4

dgm_office_view.php
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160

161
162
163

164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194

7/27/2012 12:13 PM

$pagination.= "<span
class=\"current\">$counter</span>";
else
$pagination.= "<a
href=\"$targetpage?page=$counter\">$counter</a>";
}
}
}
//next button
if ($page < $counter - 1)
$pagination.= "<a href=\"$targetpage?page=$next\">next >></a>";
else
$pagination.= "<span class=\"disabled\">next >></span>";
$pagination.= "</div>\n";
}
$keyword = "";
}
?>
<?php $title = "DGM Office";
include("layout/header.php");

?>

<div id="container">
<div id="search-area">
<form method="get" action="dgm_office_view.php">
<table align="right" cellpadding="0px" cellspacing="0px" class="table">
<tr>
<td style="border-style:solid none solid
solid;border-color:#f45110;border-width:1px;">
<input name="search" id="search" style="width:150px; border:0px
solid; height:17px; padding:0px 3px; position:relative;"
type="text" placeholder="Search DGM office" value="<?php
htmlentities($keyword);?>">
</td>
<td
style="border-style:solid;border-color:#f45110;border-width:1px;">
<input type="submit" id="search_image" name="submit" value=""
style="border-style: none; background:
url('images/icon/Search.png') no-repeat; width: 24px; height:
20px;">
</td>
</tr>
</table>
</form>
</div>
<h1 class="h1">DGM Office</h1>
<?php echo $message; ?>
<table id="search_result">
<col width="15%"/>
<col width="15%"/>
<col width="35%"/>
<col width="25%"/>
<col width="5%"/>
<col width="5%"/>
<tbody id="search_result_header">
<tr>
<th>AGM Code</th>
<th>DGM Code</th>
<th>DGM Office</th>
<th>Incharge</th>
<th colspan="2">Action</th>
</tr>
<?php $mod = true; ?>
<?php foreach($view_dgm_offices as $view_dgm_office){ ?>
<tbody id="search_result_body">
<tr>
<?php
Page 3 of 4

dgm_office_view.php
195
196
197
198
199
200
201

202

203
204
205
206
207
208
209

210

211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232

7/27/2012 12:13 PM

$mod = !$mod;
if($mod==0){
$view_row =
"<td>$view_dgm_office->agm_code</td>";
$view_row .=
"<td>$view_dgm_office->dgm_code</td>";
$view_row .=
"<td>$view_dgm_office->dgm_office</td>";
$view_row .=
"<td>$view_dgm_office->incharge</td>";
$view_row .= "<td><a
href=\"dgm_office_update.php?id={$view_dgm_office>id}\"/><img style=\"border-style: none; width:
24px; height: 20px;\"
src=\"images/icon/edit.png\" /></a></td>";
$view_row .= "<td><a
href=\"dgm_office_update.php?id={$view_dgm_office>id}\"/><img style=\"border-style: none; width:
24px; height: 20px;\"
src=\"images/icon/delete.png\" /></a></td>";
echo $view_row;
} else {
$view_row = "<td style=\"background-color:
#ffcc66;\">$view_dgm_office->agm_code</td>";
$view_row .= "<td style=\"background-color:
#ffcc66;\">$view_dgm_office->dgm_code</td>";
$view_row .= " <td style=\"background-color:
#ffcc66;\">$view_dgm_office->dgm_office</td>";
$view_row .= "<td style=\"background-color:
#ffcc66;\">$view_dgm_office->incharge</td>";
$view_row .= "<td style=\"background-color:
#ffcc66;\"><a
href=\"dgm_office_update.php?id={$view_dgm_office>id}\"/><img style=\"border-style: none; width:
24px; height: 20px;\"
src=\"images/icon/edit.png\" /></a></td>";
$view_row .= "<td style=\"background-color:
#ffcc66;\"><a
href=\"dgm_office_update.php?id={$view_dgm_office>id}\"/><img style=\"border-style: none; width:
24px; height: 20px;\"
src=\"images/icon/delete.png\" /></a></td>";
echo $view_row;
}
}
?>
</tbody>
<?php echo $pagination; ?>
<?=$pagination?>
</tbody>
</table>
</form>

</div>
<div class="imgico">
<div><a href="dgm_office.php"><img src="images/icon/add.png" class="img1"
title="View" /></a></div>
</div>
<?php include("layout/footer.php"); ?>

Page 4 of 4