expengo_realm_groupAmountByModes.js

exports = async (input) => {
  const {from, to} = input;
  const collection = context.services.get('mongodb-atlas').db('expengo').collection("expenses");
  const user = context.user.id;
  
  // Pipeline to filter relevant expenses as per the date range
  // and group them by the mode name and calculate the total amount
  // per mode.
  const pipeline = [
    {
      $match: {
        author: new BSON.ObjectId(user), 
        createdAt: {$gte: new Date(from), $lte: new Date(to)}
      }
    }, 
    {
      $group: {
        _id: "$mode", 
        amount: {$sum: "$amount"}
      }
    }, 
    {
      $project: {
        mode: "$_id", 
        amount: 1, 
        _id: 0
      }
    }
  ];
  const modes = await collection.aggregate(pipeline).toArray();
  return { modes };
};