/**
* Constructor.
*/
private function __construct()
{
$this->commentDao = BOL_CommentDao::getInstance();
$this->commentEntityDao = BOL_CommentEntityDao::getInstance();
$this->configs[self::CONFIG_COMMENTS_ON_PAGE] = 10;
$this->configs[self::CONFIG_MB_COMMENTS_ON_PAGE] = 3;
$this->configs[self::CONFIG_MB_COMMENTS_COUNT_TO_LOAD] = 10;
//$this->configs[self::CONFIG_ALLOWED_TAGS] = array('a', 'b', 'i', 'span', 'u', 'strong', 'br');
//$this->configs[self::CONFIG_ALLOWED_ATTRS] = array('style', 'href');
}
public function isDuplicateComment($groupId, $data)
{
$commentDao = BOL_CommentDao::getInstance();
$entityDao = BOL_CommentEntityDao::getInstance();
$query = "SELECT COUNT(*) FROM " . $commentDao->getTableName() . " a," . $entityDao->getTableName() . " b\n WHERE a.message = '" . addslashes($data) . "'\n AND b.entityId = " . $groupId . "\n AND b.id = a.commentEntityId \n AND b.entityType = 'groups_wal'\n AND b.pluginKey = 'groups'";
$count = $this->dbo->queryForColumn($query);
if ($count > 0) {
return true;
} else {
return false;
}
}
public function findUserPostCommentList($userId, $first, $count)
{
if ($first < 0) {
$first = 0;
}
if ($count < 0) {
$count = 1;
}
$query = "\n\t\tSELECT `c`.*, `ce`.`entityId`\n\t\tFROM `{$this->getTableName()}` as `p`\n\t\tINNER JOIN `" . BOL_CommentEntityDao::getInstance()->getTableName() . "` as `ce`\n\t\t\tON( `p`.`id` = `ce`.`entityId` and `entityType` = 'blog-post' )\n\t\tINNER JOIN `" . BOL_CommentDao::getInstance()->getTableName() . "` as `c`\n\t\t\tON( `ce`.`id` = `c`.`commentEntityId` )\n\n\t\tWHERE `p`.`authorId` = ? AND `p`.`isDraft` = 0\n\t\tORDER BY `c`.`createStamp` DESC\n\t\tLIMIT ?, ?\n\t\t";
return $this->dbo->queryForList($query, array($userId, $first, $count));
}
public function countPopularGoals()
{
$sql = "SELECT COUNT(*) FROM `" . $this->getTableName() . "` AS `g`\n LEFT JOIN `" . BOL_CommentEntityDao::getInstance()->getTableName() . "` AS `ce` ON ( `g`.`id` = `ce`.`entityId` AND `entityType` = 'ocsfundraising_project' )\n LEFT JOIN `" . BOL_CommentDao::getInstance()->getTableName() . "` AS `c` ON (`ce`.`id` = `c`.`commentEntityId`)\n ";
return $this->dbo->queryForColumn($sql);
}
