如何在nodejs的Mongoose框架中获取一段时间内每一个月的数据总和

const mongoose = require('mongoose');

// 定义数据模型
const dataSchema = new mongoose.Schema({
  date: { type: Date, required: true },
  value: { type: Number, required: true }
});

const Data = mongoose.model('Data', dataSchema);

// 获取一段时间内每一个月的数据总和
const getMonthlyDataSum = async (startDate, endDate) => {
  try {
    const result = await Data.aggregate([
      {
        $match: {
          date: { $gte: startDate, $lte: endDate }
        }
      },
      {
        $group: {
          _id: { $month: '$date' },
          total: { $sum: '$value' }
        }
      }
    ]);

    return result;
  } catch (error) {
    console.error(error);
    throw error;
  }
};

// 使用示例
const startDate = new Date('2022-01-01');
const endDate = new Date('2022-12-31');

getMonthlyDataSum(startDate, endDate)
  .then(result => {
    console.log(result);
  })
  .catch(error => {
    console.error(error);
  });