Doctrine

Timestamp:

02/19/08 02:37:09 (17 months ago)

Author:

guilhermeblanco

Message:

Second parameter support in Doctrine_Pager::setCountQuery and added new method: Doctrine_Pager::getResultsInPage(), which returns the numbers of itens in current page

Files:

• branches/0.10/lib/Doctrine/Pager.php (modified) (4 diffs)
• branches/0.9/lib/Doctrine/Pager.php (modified) (4 diffs)
• trunk/lib/Doctrine/Pager.php (modified) (4 diffs)

branches/0.10/lib/Doctrine/Pager.php

@@ -384 +384 @@
 
     /**
+     * getResultsInPage
+     *
+     * Returns the number of itens in current page
+     *
+     * @return int    Number of itens in current page
+     */
+    public function getResultsInPage()
+    {
+        $page = $this->getPage();
+
+        if ($page != $this->getLastPage()) {
+            return $page * $this->getMaxPerPage();
+        }
+
+        $offset = ($this->getPage() - 1) * $this->getMaxPerPage();
+
+        return abs($this->getNumResults() - $offset);
+    }
+
+
+    /**
      * getQuery
      *
@@ -433 +454 @@
      * Defines the counter query to be used by pager
      *
-     * @param Doctrine_Query     Accepts either a Doctrine_Query object or a string 
-     *                           (which does the Doctrine_Query class creation).
-     * @return void
-     */
-    public function setCountQuery($query)
+     * @param Doctrine_Query  Accepts either a Doctrine_Query object or a string 
+     *                        (which does the Doctrine_Query class creation).
+     * @param array           Optional params to be used by counter Doctrine_Query. 
+     *                        If not defined, the params passed to execute method will be used.
+     * @return void
+     */
+    public function setCountQuery($query, $params = null)
     {
         if (is_string($query)) {
@@ -444 +467 @@
 
         $this->_countQuery = $query;
+
+        $this->setCountQueryParams($params);
 
         $this->_setExecuted(false);
@@ -477 +502 @@
             $this->_countQueryParams = array_merge($this->_countQueryParams, $params);
         } else {
+            if ($params !== null && !is_array($params)) {
+                $params = array($params);
+            }
+
             $this->_countQueryParams = $params;
         }

branches/0.9/lib/Doctrine/Pager.php

@@ -384 +384 @@
 
     /**
+     * getResultsInPage
+     *
+     * Returns the number of itens in current page
+     *
+     * @return int    Number of itens in current page
+     */
+    public function getResultsInPage()
+    {
+        $page = $this->getPage();
+
+        if ($page != $this->getLastPage()) {
+            return $page * $this->getMaxPerPage();
+        }
+
+        $offset = ($this->getPage() - 1) * $this->getMaxPerPage();
+
+        return abs($this->getNumResults() - $offset);
+    }
+
+
+    /**
      * getQuery
      *
@@ -433 +454 @@
      * Defines the counter query to be used by pager
      *
-     * @param Doctrine_Query     Accepts either a Doctrine_Query object or a string 
-     *                           (which does the Doctrine_Query class creation).
-     * @return void
-     */
-    public function setCountQuery($query)
+     * @param Doctrine_Query  Accepts either a Doctrine_Query object or a string 
+     *                        (which does the Doctrine_Query class creation).
+     * @param array           Optional params to be used by counter Doctrine_Query. 
+     *                        If not defined, the params passed to execute method will be used.
+     * @return void
+     */
+    public function setCountQuery($query, $params = null)
     {
         if (is_string($query)) {
@@ -444 +467 @@
 
         $this->_countQuery = $query;
+
+        $this->setCountQueryParams($params);
 
         $this->_setExecuted(false);
@@ -477 +502 @@
             $this->_countQueryParams = array_merge($this->_countQueryParams, $params);
         } else {
+            if ($params !== null && !is_array($params)) {
+                $params = array($params);
+            }
+
             $this->_countQueryParams = $params;
         }

trunk/lib/Doctrine/Pager.php

@@ -384 +384 @@
 
     /**
+     * getResultsInPage
+     *
+     * Returns the number of itens in current page
+     *
+     * @return int    Number of itens in current page
+     */
+    public function getResultsInPage()
+    {
+        $page = $this->getPage();
+
+        if ($page != $this->getLastPage()) {
+            return $page * $this->getMaxPerPage();
+        }
+
+        $offset = ($this->getPage() - 1) * $this->getMaxPerPage();
+
+        return abs($this->getNumResults() - $offset);
+    }
+
+
+    /**
      * getQuery
      *
@@ -433 +454 @@
      * Defines the counter query to be used by pager
      *
-     * @param Doctrine_Query     Accepts either a Doctrine_Query object or a string 
-     *                           (which does the Doctrine_Query class creation).
-     * @return void
-     */
-    public function setCountQuery($query)
+     * @param Doctrine_Query  Accepts either a Doctrine_Query object or a string 
+     *                        (which does the Doctrine_Query class creation).
+     * @param array           Optional params to be used by counter Doctrine_Query. 
+     *                        If not defined, the params passed to execute method will be used.
+     * @return void
+     */
+    public function setCountQuery($query, $params = null)
     {
         if (is_string($query)) {
@@ -444 +467 @@
 
         $this->_countQuery = $query;
+
+        $this->setCountQueryParams($params);
 
         $this->_setExecuted(false);
@@ -477 +502 @@
             $this->_countQueryParams = array_merge($this->_countQueryParams, $params);
         } else {
+            if ($params !== null && !is_array($params)) {
+                $params = array($params);
+            }
+
             $this->_countQueryParams = $params;
         }