function FindByPagination($perpage, $pagenum)
{
// Check to see if there is a page number. If not, set it to page 1
if (!isset($pagenum)) {
$pagenum = 1;
}
$last = Images::FindLastPage($perpage);
// Ensure the page number isn't below one, or more than the maximum pages
if ($pagenum < 1) {
$pagenum = 1;
} elseif ($pagenum > $last) {
$pagenum = $last;
}
// Sets the limit value for the query
$max = 'LIMIT ' . ($pagenum - 1) * $perpage . ', ' . $perpage;
return MyActiveRecord::FindBySQL('Images', "SELECT * FROM images ORDER BY id DESC {$max}");
}
function display_page_content()
{
//$images = Images::FindAll();
//$images = array_reverse($images);
$pagenum = getRequestVarAtIndex(2);
$imagesperpage = 12;
$lastpage = Images::FindLastPage($imagesperpage);
$images = Images::FindByPagination($imagesperpage, $pagenum);
$numbernav = "";
if (count($images) > 0) {
$pagenum = $pagenum == "" ? 1 : $pagenum;
if ($pagenum > 1) {
$numbernav .= "<a class=\"pageprev\" href=\"" . get_link("admin/list_images/" . ($pagenum - 1)) . "\">Newer</a>";
}
$counter = 1;
while ($counter <= $lastpage) {
$thispage = $counter == $pagenum ? " class=\"thispage\"" : "";
$numbernav .= "<a{$thispage} href=\"" . get_link("admin/list_images/" . $counter) . "\">{$counter}</a>";
$counter++;
}
if ($pagenum != $lastpage) {
$numbernav .= "<a class=\"pagenext\" href=\"" . get_link("admin/list_images/" . ($pagenum + 1)) . "\">Older</a>";
}
}
?>
<div id="edit-header" class="imagenav">
<div class="nav-left column">
<h1>Choose an Image to Edit</h1>
</div>
<div class="nav-right column">
<a href="<?php
echo get_link("admin/add_image");
?>
" class="hcd_button">Add a New Image</a>
</div>
<div class="clearleft"></div>
</div>
<div class="page-numbers">
<?php
echo $numbernav;
?>
</div>
<?php
if (count($images) > 0) {
?>
<div id="imageDisplay">
<?php
foreach ($images as $image) {
echo "\t\t<div class=\"image\"><a href=\"" . get_link("/admin/edit_image/{$image->id}") . "\">";
//$image->displayThumbnail();
echo '<img src="' . get_link('images/view/' . $image->id) . '" alt="' . $image->name . '">';
echo "</a>{$image->name}</div>\n";
}
?>
<div class="clearleft"></div>
</div>
<?php
} else {
echo '<h3>There are no images yet! <a href="' . get_link("admin/add_image") . '">Add one if you like</a>.</h3>';
}
?>
<div class="page-numbers">
<?php
echo $numbernav;
?>
</div>
<?php
}
