huiting/cloudfunctions/listPublishers/index.js

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

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

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

  if (event.user_id) {
    const managers = await db.collection('manager')
      .aggregate()
      .match({
        user_id: event.user_id
      })
      .skip(event.page_token)
      .limit(event.page_size)
      .lookup({
        from: 'publisher',
        localField: 'pub_id',
        foreignField: '_id',
        as: 'publisher'
      })
      .end()

    for (let i = 0; i < managers.list.length; i++) {
      managers.list[i].publisher = managers.list[i].publisher[0]
    }

    return {
      list: managers.list,
      next_page_token: event.page_token + managers.list.length,
      status: 'OK'
    }
  } else {
    const publishers = await db.collection('manager')
      .aggregate()
      .skip(event.page_token)
      .limit(event.page_size)
      .end()

    return {
      list: publishers.list,
      next_page_token: event.page_token + publishers.list.length,
      status: 'OK'
    }
  }
}