From d4f2a19b10ac242a807d9aa583566256ba5e5e0c Mon Sep 17 00:00:00 2001
From: =?utf8?q?St=C3=A9phane=20Jacob?= <jacou@melix.net>
Date: Sat, 12 Jul 2008 00:14:04 +0200
Subject: [PATCH 1/1] Indicates the bounds of the page's display if possible
 (Closes #854)

---
 ChangeLog                              |  1 +
 classes/plset.php                      | 42 ++++++++++++++++++++++++++--------
 templates/include/plview.minifiche.tpl |  4 ++--
 templates/include/plview.multipage.tpl |  1 +
 4 files changed, 36 insertions(+), 12 deletions(-)

diff --git a/ChangeLog b/ChangeLog
index 6068643..49b1284 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -48,6 +48,7 @@ Bug/Wish:
         - Fix display of autocompletion menu (use plugin's latest version) -ALK
         - Clicking on the "..." entry no longer replaces search with "..." -ALK
         - #850: Fix autocompletion bug when changing an advanced search    -ALK
+        - #854: Indicates the bounds of the page's display if possible     -JAC
 
     * Xnet:
         - #821: Fix infinite loop when user can't be authenticated         -FRU
diff --git a/classes/plset.php b/classes/plset.php
index 648d814..231b4d4 100644
--- a/classes/plset.php
+++ b/classes/plset.php
@@ -80,7 +80,8 @@ class PlSet
                           $limit";
 //        echo $query;
 //        print_r($this);
-        $it    = XDB::iterator($query);
+        $it    = XDB::query($query);
+        $it    = $it->fetchAllAssoc();
         $count = XDB::query('SELECT FOUND_ROWS()');
         $this->count = intval($count->fetchOneCell());
         return $it;
@@ -255,17 +256,38 @@ abstract class MultipageView implements PlView
 
     public function apply(PlatalPage &$page)
     {
-        $page->assign('order', Env::v('order', $this->defaultkey));
+        $res = $this->set->get($this->fields(),
+                               $this->joins(),
+                               $this->where(),
+                               $this->groupBy(),
+                               $this->order(),
+                               $this->entriesPerPage,
+                               $this->offset);
+        $order       = Env::v('order', $this->defaultkey);
+        $end         = end($res);
+        $show_bounds = 0;
+        if (($order == "name") || ($order == "-name")) {
+            $first       = $res[0]['nom'];
+            $last        = $end['nom'];
+            $show_bounds = 1;
+        } elseif (($order == "promo") || ($order == "-promo")) {
+            $first       = $end['promo'];
+            $last        = $res[0]['promo'];
+            $show_bounds = 1;
+        }
+        if (($show_bounds) && ($order{0} == '-')) {
+            $aux   = $first;
+            $first = $last;
+            $last  = $aux;
+        }
+
+        $page->assign('first', $first);
+        $page->assign('last', $last);
+        $page->assign('show_bounds', $show_bounds);
+        $page->assign('order', $order);
         $page->assign('orders', $this->sortkeys);
         $page->assign_by_ref('plview', $this);
-        $page->assign_by_ref('set',
-                             $this->set->get($this->fields(),
-                                             $this->joins(),
-                                             $this->where(),
-                                             $this->groupBy(),
-                                             $this->order(),
-                                             $this->entriesPerPage,
-                                             $this->offset));
+        $page->assign_by_ref('set', $res);
         $count = $this->set->count();
         $this->pages = intval(ceil($count / $this->entriesPerPage));
         return 'include/plview.multipage.tpl';
diff --git a/templates/include/plview.minifiche.tpl b/templates/include/plview.minifiche.tpl
index 2527d2f..4753463 100644
--- a/templates/include/plview.minifiche.tpl
+++ b/templates/include/plview.minifiche.tpl
@@ -21,13 +21,13 @@
 {**************************************************************************}
 
 <div class="contact-list" style="clear: both">
-{iterate from=$set item=res}
+{foreach from=$set item=res}
   {if $res.contact}
   {include file="include/minifiche.tpl" c=$res show_action="retirer"}
   {else}
   {include file="include/minifiche.tpl" c=$res show_action="ajouter"}
   {/if}
-{/iterate}
+{/foreach}
 </div>
 
 {* vim:set et sw=2 sts=2 sws=2 enc=utf-8: *}
diff --git a/templates/include/plview.multipage.tpl b/templates/include/plview.multipage.tpl
index 348a72d..854c320 100644
--- a/templates/include/plview.multipage.tpl
+++ b/templates/include/plview.multipage.tpl
@@ -23,6 +23,7 @@
 {capture name=pages}
 {if $plview->pages > 1}
 <div class="center pages">
+  {if $show_bounds}[{$first} - {$last}]{/if}
   {if $plview->page neq 1}
   <a href="{$platal->pl_self()}{$plset_search}order={$order}&amp;page=1">{icon name=resultset_first title="Première page"}</a>{*
   *}<a href="{$platal->pl_self()}{$plset_search}order={$order}&amp;page={$plview->page-1}">{icon name=resultset_previous title="Page précédente"}</a>
-- 
2.1.4