store_node/cloudfunctions/getUserInfo/index.js

// 云函数getUserInfo
const cloud = require('wx-server-sdk')

// 初始化cloud
cloud.init({
  env: 'cloud1-5gqeisa06659849a'
})
const db = cloud.database()

exports.main = async (event, context) => {
  const wxContext = cloud.getWXContext()
  const openid = wxContext.OPENID

  try {
    // 获取用户信息
    const userInfo = await db.collection('users').where({
      openid: openid
    }).get()

    if (userInfo.data.length === 0) {
      return {
        success: false,
        message: '用户不存在'
      }
    }

    // 获取订单计数
    const waitingOrders = await db.collection('orders').where({
      buyerOpenid: openid,
      status: 'waiting'
    }).count()

    const processingOrders = await db.collection('orders').where({
      buyerOpenid: openid,
      status: 'processing'
    }).count()

    const completedOrders = await db.collection('orders').where({
      buyerOpenid: openid,
      status: 'completed'
    }).count()

    const refundOrders = await db.collection('orders').where({
      buyerOpenid: openid,
      status: 'refund'
    }).count()

    return {
      success: true,
      userInfo: userInfo.data[0],
      orderCount: {
        waiting: waitingOrders.total,
        processing: processingOrders.total,
        completed: completedOrders.total,
        refund: refundOrders.total
      }
    }
  } catch (error) {
    console.error('获取用户信息失败', error)
    return {
      success: false,
      message: '获取用户信息失败',
      error: error.message
    }
  }
}