コード例 #1
0
ファイル: comment_service.php プロジェクト: vazahat/dudex
 /**
  * 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');
 }
コード例 #2
0
ファイル: feed_dao.php プロジェクト: vazahat/dudex
 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;
     }
 }
コード例 #3
0
ファイル: post_dao.php プロジェクト: vazahat/dudex
 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));
 }
コード例 #4
0
ファイル: comment_dao.php プロジェクト: hardikamutech/loov
 public function findBatchCommentsList($entities)
 {
     if (empty($entities)) {
         return array();
     }
     $queryParts = array();
     $queryParams = array();
     $genId = 1;
     foreach ($entities as $entity) {
         $queryParts[] = " SELECT * FROM ( SELECT `c`.*, `ce`.`entityType`, `ce`.`entityId` FROM `" . $this->getTableName() . "` AS `c`\n\t\t\tLEFT JOIN `" . BOL_CommentEntityDao::getInstance()->getTableName() . "` AS `ce` ON ( `c`.`" . self::COMMENT_ENTITY_ID . "` = `ce`.`id` )\n\t\t\tWHERE `ce`.`" . BOL_CommentEntityDao::ENTITY_TYPE . "` = ? AND `ce`.`" . BOL_CommentEntityDao::ENTITY_ID . "` = ?\n\t\t\tORDER BY `" . self::CREATE_STAMP . "` DESC\n\t\t\tLIMIT 0, ? ) AS `al" . $genId++ . "` " . PHP_EOL;
         $queryParams[] = $entity['entityType'];
         $queryParams[] = $entity['entityId'];
         $queryParams[] = (int) $entity['countOnPage'];
     }
     $query = implode(" UNION ALL ", $queryParts);
     return $this->dbo->queryForObjectList($query, $this->getDtoClassName(), $queryParams);
 }
コード例 #5
0
ファイル: goal_dao.php プロジェクト: vazahat/dudex
 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);
 }