MERN Full Stack Web Development Course in Pune

const router = require('express').Router();
const Order = require('../models/Order');
const auth = require('../middleware/auth');

router.get('/revenue-report', auth, async (req, res) => {
  try {
    const report = await Order.aggregate([
      { $match: { status: 'completed' } },
      { $group: { _id: '$productId', totalRev: { $sum: '$price' } } }
    ]);
    res.json(report);
  } catch (err) {
    res.status(500).json({ error: err.message });
  }
});

+---------------------------------------------+
|               User Document                 |
| _id: ObjectId (PK)                          |
| name: String                                |
| email: String (Unique)                      |
| role: String (default: 'student')           |
+---------------------+-----------------------+
                      | (1-to-Many Relationship)
                      v
+---------------------+-----------------------+
|              Order Document                 |
| _id: ObjectId (PK)                          |
| userId: ObjectId (FK -> User)               |
| productId: String                           |
| status: String ('pending', 'completed')     |
+---------------------------------------------+

Meet Your Mentor: Hambirrao P

Lead Technology Trainer

Hambirrao P is a senior enterprise technology specialist with 12+ years of hands-on coding experience in enterprise software design, including Spring Boot architecture, Python CLI automation, React layouts, and AWS cloud migrations. He has individually mentored 800+ developers in Pune since 2012.