-
Notifications
You must be signed in to change notification settings - Fork 0
/
order.js
99 lines (86 loc) · 2.16 KB
/
order.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
const Order = require("../models/Order");
const {
verifyToken,
verifyTokenAndAuthorization,
verifyTokenAndAdmin,
} = require("./verifyToken");
const router = require("express").Router();
//CREATE
router.post("/", verifyToken, async (req, res) => {
const newOrder = new Order(req.body);
try {
const savedOrder = await newOrder.save();
res.status(200).json(savedOrder);
} catch (err) {
res.status(500).json(err);
}
});
//UPDATE
router.put("/:id", verifyTokenAndAdmin, async (req, res) => {
try {
const updatedOrder = await Order.findByIdAndUpdate(
req.params.id,
{
$set: req.body,
},
{ new: true }
);
res.status(200).json(updatedOrder);
} catch (err) {
res.status(500).json(err);
}
});
//DELETE
router.delete("/:id", verifyTokenAndAdmin, async (req, res) => {
try {
await Order.findByIdAndDelete(req.params.id);
res.status(200).json("Order has been deleted...");
} catch (err) {
res.status(500).json(err);
}
});
//GET USER ORDERS
router.get("/find/:userId", verifyTokenAndAuthorization, async (req, res) => {
try {
const orders = await Order.find({ userId: req.params.userId });
res.status(200).json(orders);
} catch (err) {
res.status(500).json(err);
}
});
// //GET ALL
router.get("/", verifyTokenAndAdmin, async (req, res) => {
try {
const orders = await Order.find();
res.status(200).json(orders);
} catch (err) {
res.status(500).json(err);
}
});
// GET MONTHLY INCOME
router.get("/income", verifyTokenAndAdmin, async (req, res) => {
const date = new Date();
const lastMonth = new Date(date.setMonth(date.getMonth() - 1));
const previousMonth = new Date(new Date().setMonth(lastMonth.getMonth() - 1));
try {
const income = await Order.aggregate([
{ $match: { createdAt: { $gte: previousMonth } } },
{
$project: {
month: { $month: "$createdAt" },
sales: "$amount",
},
},
{
$group: {
_id: "$month",
total: { $sum: "$sales" },
},
},
]);
res.status(200).json(income);
} catch (err) {
res.status(500).json(err);
}
});
module.exports = router;