Method targetComment

app/dao/comment.js:202–283

(params = {})

  // 关联目标下的评论
  static async targetComment(params = {}) {
    try {
      const {
        article_id = 0,
        user_id = 0,
        is_replay = 0,
        is_article = 0,
        is_user = 0,
        page_size = 10,
        status = -1,
        page = 1,
        desc = 'created_at'
      } = params;

      // if (!article_id) {
      //   throw new global.errs.NotFound('必须传入article id');
      // }

      const finner = {
        status: 1,
        deleted_at: null
      }

      if (user_id) {
        finner.user_id = user_id
      }

      if (article_id) {
        finner.article_id = article_id
      }

      if (status === -1) {
        delete finner.status
      }

      const comment = await Comment.findAndCountAll({
        where: finner,
        // 每页10条
        limit: page_size,
        offset: (page - 1) * page_size,
        order: [
          [desc, 'DESC']
        ],
        attributes: {
          exclude: ['updated_at']
        },
      })

      let rows = comment.rows
      // 查询评论
      if (parseInt(is_replay, 10) === 1) {
        rows = await CommentDao._handleReply(rows)
      }

      // 查询文章
      if (parseInt(is_article, 10) === 1) {
        rows = await CommentDao._handleArticle(rows)
      }