Changeset 350

Timestamp:

01/15/07 11:29:32 (2 years ago)

Author:

bballizlife

Message:

add method to jDaoFactoryBase : countBy($searchcond)

Files:

• trunk/lib/jelix/dao/jDaoBase.class.php (modified) (2 diffs)

trunk/lib/jelix/dao/jDaoBase.class.php

@@ -4 +4 @@
- * @subpackage  dao
- * @author      Laurent Jouanneau
-
+ Loic Mathaud
- * @copyright   2005-2006 Laurent Jouanneau
+ * @copyright   2007 Loic Mathaud
- * @link        http://www.jelix.org
- * @licence     http://www.gnu.org/licenses/lgpl.html GNU Lesser General Public Licence, see LICENCE file
@@ -272 +273 @@
-    }
-
+    /**
+     * return the number of records corresponding to the conditions stored into the
+     * jDaoConditions object.
+     * @author Loic Mathaud
+     * @copyright 2007 Loic Mathaud
+     * @since 1.0b2
+     * @param jDaoConditions $searchcond
+     * @return int the count
+     */
+    public function countBy($searchcond) {
+        $query = 'SELECT COUNT(*) as c '.$this->_fromClause.$this->_whereClause;
+        if (!$searchcond->isEmpty ()){
+            $query .= ($this->_whereClause !='' ? ' AND ' : ' WHERE ');
+            $query .= $this->_createConditionsClause($searchcond);
+        }
+        $rs  =  $this->_conn->query ($query);
+        $res =  $rs->fetch();
+        return intval($res->c);
+    }
+    
-    abstract protected function _getPkWhereClauseForSelect($pk);
-    abstract protected function _getPkWhereClauseForNonSelect($pk);