[Sciret-svn] SF.net SVN: sciret:[690] trunk/models/ArticleGateway.php

[<al...@us...>]

Revision: 690
          http://sciret.svn.sourceforge.net/sciret/?rev=690&view=rev
Author:   alpeb
Date:     2008-09-23 20:41:51 +0000 (Tue, 23 Sep 2008)

Log Message:
-----------
added getArticlesForUser() method

Modified Paths:
--------------
    trunk/models/ArticleGateway.php

Modified: trunk/models/ArticleGateway.php
===================================================================
--- trunk/models/ArticleGateway.php	2008-09-23 17:11:08 UTC (rev 689)
+++ trunk/models/ArticleGateway.php	2008-09-23 20:41:51 UTC (rev 690)
@@ -329,6 +329,23 @@
         return new ArticleIterator($resultSet, $totalNumItems);
     }
 
+    public function getArticlesForUser($user)
+    {
+        $query = 'SELECT art_id, is_bookmark, q_id, title, url, expires, question, SUBSTRING(content, 1, '.EXCERPT_LENGTH.') AS excerpt, cat_id, published, draft, user_id, views, created, modified, modified_user_id, votes_1, votes_2, votes_3, votes_4, votes_5 '
+               . 'FROM articles '
+               . 'WHERE user_id=? '
+               . 'ORDER BY created DESC';
+        $result = DB::getInstance()->query($query, $user->id);
+        $resultSet = $result->fetchAll(Zend_Db::FETCH_ASSOC);
+
+        $query2 = 'SELECT FOUND_ROWS()';
+        $result2 = DB::getInstance()->query($query2);
+        $rows = $result2->fetch();
+        $totalNumItems = $rows['FOUND_ROWS()'];
+
+        return new ArticleIterator($resultSet, $totalNumItems);
+    }
+
     function delete($id) {
         $article = new Article($id);
         foreach ($article->getFiles() as $file) {


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.