classes/paper/PaperCommentDAO.inc.php

Go to the documentation of this file.

<?php

//$Id$

import('paper.PaperComment');

class PaperCommentDAO extends DAO {
   function &getPaperComments($paperId, $commentType = null, $assocId = null) {
      $paperComments = array();

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

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

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

      return $paperComments;
   }

   function &getPaperCommentsByUserId($userId) {
      $paperComments = array();

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

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

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

      return $paperComments;
   }

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

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

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

      return $returner;
   }

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

      $paperComment =& $this->_returnPaperCommentFromRow($result->GetRowAssoc(false));

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

      return $paperComment;
   }  

   function &_returnPaperCommentFromRow($row) {
      $paperComment = new PaperComment();
      $paperComment->setId($row['comment_id']);
      $paperComment->setCommentType($row['comment_type']);
      $paperComment->setRoleId($row['role_id']);
      $paperComment->setPaperId($row['paper_id']);
      $paperComment->setAssocId($row['assoc_id']);
      $paperComment->setAuthorId($row['author_id']);
      $paperComment->setCommentTitle($row['comment_title']);
      $paperComment->setComments($row['comments']);
      $paperComment->setDatePosted($this->datetimeFromDB($row['date_posted']));
      $paperComment->setDateModified($this->datetimeFromDB($row['date_modified']));
      $paperComment->setViewable($row['viewable']);

      HookRegistry::call('PaperCommentDAO::_returnPaperCommentFromRow', array(&$paperComment, &$row));

      return $paperComment;
   }

   function insertPaperComment(&$paperComment) {
      $this->update(
         sprintf('INSERT INTO paper_comments
            (comment_type, role_id, paper_id, assoc_id, author_id, date_posted, date_modified, comment_title, comments, viewable)
            VALUES
            (?, ?, ?, ?, ?, %s, %s, ?, ?, ?)',
            $this->datetimeToDB($paperComment->getDatePosted()), $this->datetimeToDB($paperComment->getDateModified())),
         array(
            $paperComment->getCommentType(),
            $paperComment->getRoleId(),
            $paperComment->getPaperId(),
            $paperComment->getAssocId(),
            $paperComment->getAuthorId(),
            String::substr($paperComment->getCommentTitle(), 0, 255),
            $paperComment->getComments(),
            $paperComment->getViewable() === null ? 0 : $paperComment->getViewable()
         )
      );

      $paperComment->setId($this->getInsertPaperCommentId());
      return $paperComment->getId();      
   }

   function getInsertPaperCommentId() {
      return $this->getInsertId('paper_comments', 'comment_id');
   }  

   function deletePaperComment($paperComment) {
      $this->deletePaperCommentById($paperComment->getId());
   }

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

   function deletePaperComments($paperId) {
      return $this->update(
         'DELETE FROM paper_comments WHERE paper_id = ?', $paperId
      );
   }

   function updatePaperComment($paperComment) {
      $this->update(
         sprintf('UPDATE paper_comments
            SET
               comment_type = ?,
               role_id = ?,
               paper_id = ?,
               assoc_id = ?,
               author_id = ?,
               date_posted = %s,
               date_modified = %s,
               comment_title = ?,
               comments = ?,
               viewable = ?
            WHERE comment_id = ?',
            $this->datetimeToDB($paperComment->getDatePosted()), $this->datetimeToDB($paperComment->getDateModified())),
         array(
            $paperComment->getCommentType(),
            $paperComment->getRoleId(),
            $paperComment->getPaperId(),
            $paperComment->getAssocId(),
            $paperComment->getAuthorId(),
            String::substr($paperComment->getCommentTitle(), 0, 255),
            $paperComment->getComments(),
            $paperComment->getViewable() === null ? 1 : $paperComment->getViewable(),
            $paperComment->getId()
         )
      );
   }
}

?>

---