All files / src/controllers/statistics-controllers usersStatistics.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
 
 
 
2x
2x
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
2x
 
 
 
 
 
 
import UsersModel from "../../models/Users.js";
 
export default async function usersStatistics() {
    try {
        const result = await UsersModel.aggregate([
            {
                $group: {
                    _id: "users",
                    usersCount: { $count: {} },
                    verifiedUsers: {
                        $sum: {
                            $cond: {
                                if: "$hisEmailVerified",
                                then: 1,
                                else: 0,
                            }
                        }
                    },
                    customersCount: {
                        $sum: {
                            $cond: {
                                if: { $gt: [{ $size: "$userOrders" }, 0] },
                                then: 1,
                                else: 0,
                            }
                        }
                    }
                }
            },
            { $unset: ["_id"] }
        ])
        return result[0] || {}
    } catch (error) {
        console.log(error)
        return null;
    }
}