sciret-svn

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

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

Revision: 657
          http://sciret.svn.sourceforge.net/sciret/?rev=657&view=rev
Author:   alpeb
Date:     2008-08-28 20:46:48 +0000 (Thu, 28 Aug 2008)

Log Message:
-----------
fixed bad query

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

Modified: trunk/models/ArticleGateway.php
===================================================================
--- trunk/models/ArticleGateway.php	2008-08-28 20:45:04 UTC (rev 656)
+++ trunk/models/ArticleGateway.php	2008-08-28 20:46:48 UTC (rev 657)
@@ -87,7 +87,7 @@
                 break;
             case 'withFullName':
                 $query = 'SELECT SQL_CALC_FOUND_ROWS art.art_id, is_bookmark, q_id, title, url, expires, question, SUBSTRING(content, 1, '.EXCERPT_LENGTH.') AS excerpt, cat_id, published, draft, art.user_id, views, created, modified, modified_user_id, votes_1, votes_2, votes_3, votes_4, votes_5, firstname, lastname '
-                        .'FROM articles art LEFT JOIN users u ON art.user_id = u.id'
+                        .'FROM articles art LEFT JOIN users u ON art.user_id = u.id '
                         . $where . " ORDER BY $order $direction";
                 if ($numRecords != -1) {
                     $query .= ' LIMIT ' . (int)$offset . ', ' . (int)$numRecords;


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

[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.