huiting/cloudfunctions/getMessage/index.js

// 云函数入口文件
const cloud = require('wx-server-sdk')

cloud.init()
const db = cloud.database()

// 云函数入口函数
exports.main = async (event, context) => {
  const {
    OPENID
  } = cloud.getWXContext()

  const message = await db.collection('message')
    .aggregate()
    .match({
      _id: event.msg_id
    })
    .lookup({
      from: 'publisher',
      localField: 'pub_id',
      foreignField: '_id',
      as: 'publisher'
    })
    .end()
  if (message.list.length !== 1) {
    return {
      errMsg: '信息不存在',
      status: 'ERR'
    }
  }

  message.list[0].publisher = message.list[0].publisher[0]
  message.list[0].favorite = (await db.collection('favorite')
    .where({
      user_id: OPENID,
      msg_id: event.msg_id
    })
    .count()).total === 1

  await db.collection('read')
    .add({
      data: {
        user_id: OPENID,
        msg_id: event.msg_id || '',
        read_time: new Date()
      }
    })

  return {
    data: message.list[0],
    status: 'OK'
  }
}