update detail statistic saving

BITS-SG05-G6 · xian-94 · Jan 10, 2024 · Jan 9, 2024 · Jan 9, 2024 · Jan 9, 2024
commit ea7d64ec3f6970a3573bba4fdaff91d7941663ea
diff --git a/controllers/savingGoalStatisticController.js b/controllers/savingGoalStatisticController.js
@@ -44,3  44,105 @@ exports.getTotalAndTargetByDate = async (req, res, next) => {
     next(new ErrorHandler(err.message, 500));
   }
 };
 
 exports.getThisMonthSaving = async (req, res, next) => {
   const user = req.userID;
   const { savingID } = req.params;
 
   try {
     const currentDate = new Date();
     const startOfMonth = new Date(currentDate.getFullYear(), currentDate.getMonth(), 1);
     const endOfMonth = new Date(currentDate.getFullYear(), currentDate.getMonth()   1, 0);
 
     const transactionsThisMonth = await NormalTransaction.aggregate([
       {
         $match: {
           user: new mongoose.Types.ObjectId(user),
           saving: new mongoose.Types.ObjectId(savingID),
           date: {
             $gte: startOfMonth,
             $lte: endOfMonth,
           },
         },
       },
       {
         $group: {
           _id: { $dateToString: { format: "%Y-%m-%d", date: "$date" } },
           total: { $sum: "$VND" },
         },
       },
     ]);
 
     const savingGoal = await Saving.findById(savingID);
     if (!savingGoal) {
       return next(new ErrorHandler("Saving goal not found", 404));
     }
 
     const thisMonthTotal = transactionsThisMonth.map((transaction) => {
       const { _id, total } = transaction;
       const targetDate = _id;
       const target = savingGoal.target || 0; // Assuming target is stored in the SavingGoal model
       return {
         date: targetDate,
         target: target,
         total: total,
       };
     });
 
     res.status(200).json({ targetsList: thisMonthTotal });
   } catch (err) {
     next(new ErrorHandler(err.message, 500));
   }
 };
 
 
 exports.getLastMonthSaving = async (req, res, next) => {
   const user = req.userID;
   const { savingID } = req.params;
 
   try {
     const currentDate = new Date();
     const startOfLastMonth = new Date(currentDate.getFullYear(), currentDate.getMonth() - 1, 1);
     const endOfLastMonth = new Date(currentDate.getFullYear(), currentDate.getMonth(), 0);
 
     const transactionsLastMonth = await NormalTransaction.aggregate([
       {
         $match: {
           user: new mongoose.Types.ObjectId(user),
           saving: new mongoose.Types.ObjectId(savingID),
           date: {
             $gte: startOfLastMonth,
             $lte: endOfLastMonth,
           },
         },
       },
       {
         $group: {
           _id: { $dateToString: { format: "%Y-%m-%d", date: "$date" } },
           total: { $sum: "$VND" },
         },
       },
     ]);
 
     const savingGoal = await Saving.findById(savingID);
     if (!savingGoal) {
       return next(new ErrorHandler("Saving goal not found", 404));
     }
 
     const lastMonthTotal = transactionsLastMonth.map((transaction) => {
       const { _id, total } = transaction;
       const targetDate = _id;
       const target = savingGoal.target || 0; // Assuming target is stored in the SavingGoal model
       return {
         date: targetDate,
         target: target,
         total: total,
       };
     });
 
     res.status(200).json({ targetsList: lastMonthTotal });
   } catch (err) {
     next(new ErrorHandler(err.message, 500));
   }
 };
 
diff --git a/routes/statisticDetailRoute.js b/routes/statisticDetailRoute.js
@@ -16,5  16,7 @@ router.get('/wallet/lastmonth/:walletID',isAuthenticated, statisticWalletDetail.
 
 //Saving goal
 router.get('/savinggoal/:savingID',isAuthenticated, statisticSavingGoal.getTotalAndTargetByDate);
 router.get('/savinggoal/thismonth/:savingID',isAuthenticated, statisticSavingGoal.getThisMonthSaving);
 router.get('/savinggoal/lastmonth/:savingID',isAuthenticated, statisticSavingGoal.getLastMonthSaving);
 
 module.exports = router;