All files / src/controllers/statistics-controllers productsStatistics.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
 
 
 
2x
2x
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
2x
 
 
 
 
import ProductsModel from "../../models/Products.js";
 
export default async function productsStatistics() {
    try {
        const result = await ProductsModel.aggregate([
            {
                $group: {
                    _id: "products",
                    totalProducts: { $count: {} },
                    totalProductsSold: { $sum: "$sold" },
                    totalInStock: { $sum: "$amount" },
                    productsOutOfStock: {
                        $sum: {
                            $cond: {
                                if: { $eq: ["$amount", 0] },
                                then: { $sum: 1 },
                                else: { $sum: 0 }
                            }
                        }
                    },
                    categories: { $addToSet: "$category" },
                    series: { $addToSet: "$series" }
                }
            },
            {
                $set: {
                    categoriesCount: { $size: "$categories" },
                    seriesCount: { $size: "$series" }
                }
            },
            { $unset: ["_id", "categories", "series"] }
        ])
        return result[0] || {}
    } catch (error) {
        return null;
    }
}