我想要获取所有在mongodb和nodejs最近7天内有最多火花的用户

const MongoClient = require('mongodb').MongoClient;

// 连接到mongodb数据库
MongoClient.connect('mongodb://localhost:27017', function(err, client) {
  if (err) throw err;

  // 选择数据库和集合
  const db = client.db('mydb');
  const collection = db.collection('users');

  // 计算最近7天的日期范围
  const currentDate = new Date();
  const sevenDaysAgo = new Date(currentDate.getTime() - 7 * 24 * 60 * 60 * 1000);

  // 构建聚合管道
  const pipeline = [
    {
      $match: {
        createdAt: {
          $gte: sevenDaysAgo,
          $lte: currentDate
        }
      }
    },
    {
      $group: {
        _id: '$userId',
        sparks: { $sum: '$sparks' }
      }
    },
    {
      $sort: {
        sparks: -1
      }
    }
  ];

  // 执行聚合查询
  collection.aggregate(pipeline).toArray(function(err, result) {
    if (err) throw err;

    // 输出结果
    console.log(result);

    // 关闭数据库连接
    client.close();
  });
});