Changeset 2103 for branches/release-36/php/lib/mtdb_base.php

Timestamp:

04/25/08 11:36:53 (19 months ago)

Author:

fumiakiy

Message:

Implemented PHP version of pager related tags. Dynamically published archives can now be pagination-enabled by adding these tags and specify "auto" to limit and offset.

Files:

• branches/release-36/php/lib/mtdb_base.php (modified) (6 diffs)

branches/release-36/php/lib/mtdb_base.php

@@ -413 +413 @@
     }
 
-    function &fetch_entries($args) {
+    function &fetch_entries($args, &$total_count = NULL) {
         if ($sql = $this->include_exclude_blogs($args)) {
             $blog_filter = 'and entry_blog_id ' . $sql;
@@ -422 +422 @@
         }
 
+        $pagination = 0;
         # automatically include offset if in request
         if ($args['offset'] == 'auto') {
+            $pagination = 1;
             $args['offset'] = 0;
             if ($args['limit'] || $args['lastn']) {
@@ -801 +803 @@
             $post_select_limit = $rco;
             $no_resort = 1;
+        } elseif ( !is_null($total_count) ) {
+            $orig_limit = $limit;
+            $orig_offset = $offset;
         } else {
             $sql = $this->apply_limit_sql($sql . " <LIMIT>", $limit, $offset);
@@ -810 +815 @@
         $entries = array();
         $j = 0;
-        $offset = $post_select_offset ? $post_select_offset : 0;
+        $offset = $post_select_offset ? $post_select_offset : $orig_offset;
         $limit = $post_select_limit ? $post_select_limit : 0;
         $id_list = array();
+        $_total_count = 0;
         while (true) {
             $e = $this->query_fetch(ARRAY_A);
@@ -826 +832 @@
                 }
             }
+            $_total_count++;
+            if ( !is_null($total_count) ) {
+                if ( ($orig_limit > 0)
+                  && ( ($_total_count-$offset) > $orig_limit) ) {
+                    // collected all the entries; only count numbers;
+                    continue;
+                }
+            }
             if ($offset && ($j++ < $offset)) continue;
             $e['entry_authored_on'] = $this->db2ts($e['entry_authored_on']);
@@ -833 +847 @@
             $this->_comment_count_cache[$e['entry_id']] = $e['entry_comment_count'];
             $this->_ping_count_cache[$e['entry_id']] = $e['entry_ping_count'];
-            if (($limit > 0) && (count($entries) >= $limit)) break;
+            if ( is_null($total_count) ) {
+                // the request does not want total count; break early
+                if (($limit > 0) && (count($entries) >= $limit)) break;
+            }
+        }
+        if ( !is_null($total_count) ) {
+            $total_count = $_total_count;
         }