cshenfu
2024-06-27 58aa6e282bb343503be3cb198948328ea3ed7b79
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
'use strict';
module.exports = {
    /**
     * 此函数名称
     * @url user/pub/test1 前端调用的url参数地址
     * data 请求参数
     * @param {String} params1  参数1
     */
    main: async (event) => {
        let { data = {}, userInfo, util, filterResponse, originalParam } = event;
        let { customUtil, config, pubFun, vk, db, _ } = util;
        let { uid } = data;
        let res = { code: 0, msg: "", data: {} };
        // 业务逻辑开始-----------------------------------------------------------
        // 今日收入
        var today = new Date(new Date().toLocaleDateString()).getTime();
        res.data.t_d_money = await vk.baseDao.sum({
            dbName: "uni-id-base-order",
            fieldName: "total_fee",
            whereJson: {
                status: 2,
                create_time: _.and(_.gt(today), _.lt(today + 24 * 60 * 60 * 1000))
            }
        });
 
        //昨日收入
        res.data.y_d_money = await vk.baseDao.sum({
            dbName: "uni-id-base-order",
            fieldName: "total_fee",
            whereJson: {
                status: 2,
                create_time: _.and(_.gt(today - 24 * 60 * 60 * 1000), _.lt(today))
            }
        });
 
 
        //今日付费订单数
        res.data.t_d_count = await vk.baseDao.count({
            dbName: "uni-id-base-order",
            whereJson: {
                status: 2,
                create_time: _.and(_.gt(today), _.lt(today + 24 * 60 * 60 * 1000))
            }
        });
 
        //昨日付费订单数
        res.data.y_d_count = await vk.baseDao.count({
            dbName: "uni-id-base-order",
            whereJson: {
                status: 2,
                create_time: _.and(_.gt(today - 24 * 60 * 60 * 1000), _.lt(today))
            }
        });
 
        //总用户
        res.data.total_user = await vk.baseDao.count({
            dbName: "uni-id-users",
            whereJson: {
 
            }
        });
 
        //今日新注册
        res.data.t_d_user = await vk.baseDao.count({
            dbName: "uni-id-users",
            whereJson: {
                register_date: _.and(_.gt(today), _.lt(today + 24 * 60 * 60 * 1000))
            }
        });
 
        //本月收益
        let monthS = vk.pubfn.getMonthOffsetStartAndEnd(0).startTime
        let monthE = vk.pubfn.getMonthOffsetStartAndEnd(0).endTime
        res.data.t_m_money = await vk.baseDao.sum({
            dbName: "uni-id-base-order",
            fieldName: "total_fee",
            whereJson: {
                status: 2,
                create_time: _.and(_.gt(monthS), _.lt(monthE))
            }
        })
 
        //上月收益
        let monthLS = vk.pubfn.getMonthOffsetStartAndEnd(-1).startTime
        let monthLE = vk.pubfn.getMonthOffsetStartAndEnd(-1).endTime
        res.data.p_m_money = await vk.baseDao.sum({
            dbName: "uni-id-base-order",
            fieldName: "total_fee",
            whereJson: {
                status: 2,
                create_time: _.and(_.gt(monthLS), _.lt(monthLE))
            }
        });
 
 
        // 业务逻辑结束-----------------------------------------------------------
        return res;
    }
}