| Server IP : 172.66.157.178 / Your IP : 172.16.20.3 Web Server : Apache/2.4.25 (Debian) System : Linux f64a392e70de 5.4.0-216-generic #236-Ubuntu SMP Fri Apr 11 19:53:21 UTC 2025 x86_64 User : application ( 1000) PHP Version : 5.6.40 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /app/classes/article/ |
Upload File : |
<?php
/**
* @file classes/article/ArticleCommentDAO.inc.php
*
* Copyright (c) 2013-2019 Simon Fraser University
* Copyright (c) 2003-2019 John Willinsky
* Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
*
* @class ArticleCommentDAO
* @ingroup article
* @see ArticleComment
*
* @brief Operations for retrieving and modifying ArticleComment objects.
*/
import('classes.article.ArticleComment');
class ArticleCommentDAO extends DAO {
/**
* Retrieve ArticleComments by article id
* @param $articleId int
* @param $commentType int
* @return ArticleComment objects array
*/
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;
}
/**
* Retrieve ArticleComments by user id
* @param $userId int
* @return ArticleComment objects array
*/
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;
}
/**
* Retrieve most recent ArticleComment
* @param $articleId int
* @param $commentType int
* @return ArticleComment
*/
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;
}
/**
* Retrieve Article Comment by comment id
* @param $commentId int
* @return ArticleComment object
*/
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;
}
/**
* Creates and returns an article comment object from a row
* @param $row array
* @return ArticleComment object
*/
function &_returnArticleCommentFromRow($row) {
$articleComment = new ArticleComment();
$articleComment->setId($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;
}
/**
* inserts a new article comment into article_comments table
* @param ArticleComment object
* @return Article Comment Id int
*/
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(),
PKPString::substr($articleComment->getCommentTitle(), 0, 255),
$articleComment->getComments(),
$articleComment->getViewable() === null ? 0 : $articleComment->getViewable()
)
);
$articleComment->setId($this->getInsertArticleCommentId());
return $articleComment->getId();
}
/**
* Get the ID of the last inserted article comment.
* @return int
*/
function getInsertArticleCommentId() {
return $this->getInsertId('article_comments', 'comment_id');
}
/**
* removes an article comment from article_comments table
* @param ArticleComment object
*/
function deleteArticleComment($articleComment) {
$this->deleteArticleCommentById($articleComment->getId());
}
/**
* removes an article note by id
* @param noteId int
*/
function deleteArticleCommentById($commentId) {
$this->update(
'DELETE FROM article_comments WHERE comment_id = ?', $commentId
);
}
/**
* Delete all comments for an article.
* @param $articleId int
*/
function deleteArticleComments($articleId) {
return $this->update(
'DELETE FROM article_comments WHERE article_id = ?', $articleId
);
}
/**
* updates an article comment
* @param ArticleComment object
*/
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(),
PKPString::substr($articleComment->getCommentTitle(), 0, 255),
$articleComment->getComments(),
$articleComment->getViewable() === null ? 1 : $articleComment->getViewable(),
$articleComment->getId()
)
);
}
}
?>