classes/article/ArticleCommentDAO.inc.php

<?php

// $Id: ArticleCommentDAO.inc.php,v 1.18 2008/07/01 01:16:09 asmecher Exp $


import('article.ArticleComment');

class ArticleCommentDAO extends DAO {
   function &getArticleComments($articleId, $commentType = null, $assocId = null) {
      $articleComments = array();

      if ($commentType == null) {
         $result = &$this->retrieve(
            'SELECT a.* FROM article_comments a WHERE article_id = ? ORDER BY date_posted',  $articleId
         );
      } else {
         if ($assocId == null) {
            $result = &$this->retrieve(
               'SELECT a.* FROM article_comments a WHERE article_id = ? AND comment_type = ? ORDER BY date_posted',  array($articleId, $commentType)
            );
         } else {
            $result = &$this->retrieve(
               'SELECT a.* FROM article_comments a WHERE article_id = ? AND comment_type = ? AND assoc_id = ? ORDER BY date_posted',
               array($articleId, $commentType, $assocId)
            );
         }           
      }

      while (!$result->EOF) {
         $articleComments[] = &$this->_returnArticleCommentFromRow($result->GetRowAssoc(false));
         $result->moveNext();
      }

      $result->Close();
      unset($result);

      return $articleComments;
   }

   function &getArticleCommentsByUserId($userId) {
      $articleComments = array();

      $result = &$this->retrieve(
         'SELECT a.* FROM article_comments a WHERE author_id = ? ORDER BY date_posted',   $userId
      );

      while (!$result->EOF) {
         $articleComments[] = &$this->_returnArticleCommentFromRow($result->GetRowAssoc(false));
         $result->moveNext();
      }

      $result->Close();
      unset($result);

      return $articleComments;
   }

   function getMostRecentArticleComment($articleId, $commentType = null, $assocId = null) {
      if ($commentType == null) {
         $result = &$this->retrieveLimit(
            'SELECT a.* FROM article_comments a WHERE article_id = ? ORDER BY date_posted DESC',
            $articleId,
            1
         );
      } else {
         if ($assocId == null) {
            $result = &$this->retrieveLimit(
               'SELECT a.* FROM article_comments a WHERE article_id = ? AND comment_type = ? ORDER BY date_posted DESC',
               array($articleId, $commentType),
               1
            );
         } else {
            $result = &$this->retrieveLimit(
               'SELECT a.* FROM article_comments a WHERE article_id = ? AND comment_type = ? AND assoc_id = ? ORDER BY date_posted DESC',
               array($articleId, $commentType, $assocId),
               1
            );
         }           
      }

      $returner = null;
      if (isset($result) && $result->RecordCount() != 0) {
         $returner = &$this->_returnArticleCommentFromRow($result->GetRowAssoc(false));
      }

      $result->Close();
      unset($result);

      return $returner;
   }

   function &getArticleCommentById($commentId) {
      $result = &$this->retrieve(
         'SELECT a.* FROM article_comments a WHERE comment_id = ?', $commentId
      );

      $articleComment = &$this->_returnArticleCommentFromRow($result->GetRowAssoc(false));

      $result->Close();
      unset($result);

      return $articleComment;
   }  

   function &_returnArticleCommentFromRow($row) {
      $articleComment = &new ArticleComment();
      $articleComment->setCommentId($row['comment_id']);
      $articleComment->setCommentType($row['comment_type']);
      $articleComment->setRoleId($row['role_id']);
      $articleComment->setArticleId($row['article_id']);
      $articleComment->setAssocId($row['assoc_id']);
      $articleComment->setAuthorId($row['author_id']);
      $articleComment->setCommentTitle($row['comment_title']);
      $articleComment->setComments($row['comments']);
      $articleComment->setDatePosted($this->datetimeFromDB($row['date_posted']));
      $articleComment->setDateModified($this->datetimeFromDB($row['date_modified']));
      $articleComment->setViewable($row['viewable']);

      HookRegistry::call('ArticleCommentDAO::_returnArticleCommentFromRow', array(&$articleComment, &$row));

      return $articleComment;
   }

   function insertArticleComment(&$articleComment) {
      $this->update(
         sprintf('INSERT INTO article_comments
            (comment_type, role_id, article_id, assoc_id, author_id, date_posted, date_modified, comment_title, comments, viewable)
            VALUES
            (?, ?, ?, ?, ?, %s, %s, ?, ?, ?)',
            $this->datetimeToDB($articleComment->getDatePosted()), $this->datetimeToDB($articleComment->getDateModified())),
         array(
            $articleComment->getCommentType(),
            $articleComment->getRoleId(),
            $articleComment->getArticleId(),
            $articleComment->getAssocId(),
            $articleComment->getAuthorId(),
            $articleComment->getCommentTitle(),
            $articleComment->getComments(),
            $articleComment->getViewable() === null ? 0 : $articleComment->getViewable()
         )
      );

      $articleComment->setCommentId($this->getInsertArticleCommentId());
      return $articleComment->getCommentId();      
   }

   function getInsertArticleCommentId() {
      return $this->getInsertId('article_comments', 'comment_id');
   }  

   function deleteArticleComment($articleComment) {
      $this->deleteArticleCommentById($articleComment->getCommentId());
   }

   function deleteArticleCommentById($commentId) {
      $this->update(
         'DELETE FROM article_comments WHERE comment_id = ?', $commentId
      );
   }

   function deleteArticleComments($articleId) {
      return $this->update(
         'DELETE FROM article_comments WHERE article_id = ?', $articleId
      );
   }

   function updateArticleComment($articleComment) {
      $this->update(
         sprintf('UPDATE article_comments
            SET
               comment_type = ?,
               role_id = ?,
               article_id = ?,
               assoc_id = ?,
               author_id = ?,
               date_posted = %s,
               date_modified = %s,
               comment_title = ?,
               comments = ?,
               viewable = ?
            WHERE comment_id = ?',
            $this->datetimeToDB($articleComment->getDatePosted()), $this->datetimeToDB($articleComment->getDateModified())),
         array(
            $articleComment->getCommentType(),
            $articleComment->getRoleId(),
            $articleComment->getArticleId(),
            $articleComment->getAssocId(),
            $articleComment->getAuthorId(),
            $articleComment->getCommentTitle(),
            $articleComment->getComments(),
            $articleComment->getViewable() === null ? 1 : $articleComment->getViewable(),
            $articleComment->getCommentId()
         )
      );
   }
}

?>

---