'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;
|
}
|
}
|