| | |
|---|
| | | var statistics = await _dallyStatisticsRepository.Where(x => x.CreationTime.Date == today).FirstOrDefaultAsync(); |
|---|
| | | if (statistics == null) |
|---|
| | | { |
|---|
| | | var accumulatedReceipts = await _lifePayOrderRepository.Where(x => x.CreationTime < today).SumAsync(x => x.PayAmount); |
|---|
| | | var receiptsYesterday = await _lifePayOrderRepository.Where(x => x.CreationTime >= today.AddDays(-1) && x.CreationTime < today).SumAsync(x => x.PayAmount); |
|---|
| | | /// 累计收款：统计平台账户下订单创建时间在昨天及之前收到的【用户支付成功的金额-退款给用户的金额】； |
|---|
| | | var accumulatedReceipts = await _lifePayOrderRepository.Where(x => x.CreationTime < today && x.PayStatus == LifePayStatusEnum.已支付).SumAsync(x => x.PayAmount) - await _lifePayOrderRepository.Where(x => x.CreationTime < today && x.LifePayRefundStatus == LifePayRefundStatusEnum.已退款).SumAsync(x => x.RefundPrice); |
|---|
| | | /// 昨日收款：统计平台账户下订单创建时间在昨天收到的【用户支付成功的金额-退款给用户的金额】； |
|---|
| | | var receiptsYesterday = await _lifePayOrderRepository.Where(x => x.CreationTime >= today.AddDays(-1) && x.CreationTime < today && x.PayStatus == LifePayStatusEnum.已支付).SumAsync(x => x.PayAmount) - await _lifePayOrderRepository.Where(x => x.CreationTime >= today.AddDays(-1) && x.CreationTime < today && x.LifePayRefundStatus == LifePayRefundStatusEnum.已退款).SumAsync(x => x.PayAmount); |
|---|
| | | /// 累计收入：统计平台账户下订单状态为“已完成”且订单创建时间在昨天及之前收到的【用户实付金额-平台扣款金额-部分退款金额】； |
|---|
| | | var accumulatedIncome = await _lifePayOrderRepository.Where(x => x.CreationTime < today && x.LifePayOrderStatus == LifePayOrderStatusEnum.已完成).SumAsync(x => x.PayAmount - x.PlatformDeductionAmount) - |
|---|
| | | await _lifePayOrderRepository.Where(x => x.CreationTime < today && x.LifePayRefundStatus == LifePayRefundStatusEnum.已退款).SumAsync(x => x.RefundPrice); |
|---|
| | | /// 累计下单：统计平台中订单下单时间在昨天及之前时间的订单记录； |
|---|
| | | var accumulatedOrders = await _lifePayOrderRepository.Where(x => x.CreationTime < today).CountAsync(); |
|---|
| | | var accumulatedIncome = await _lifePayOrderRepository.Where(x => x.CreationTime < today).SumAsync(x => x.RechargeAmount); |
|---|
| | | /// 昨日下单：统计平台中订单下单时间在昨天的订单记录； |
|---|
| | | var ordersNumYesterday = await _lifePayOrderRepository.Where(x => x.CreationTime >= today.AddDays(-1) && x.CreationTime < today).CountAsync(); |
|---|
| | | /// 昨日成功：统计平台中订单状态为“已完成/部分充值成功”且订单下单时间在昨天的订单记录； |
|---|
| | | var yesterdaySuccess = await _lifePayOrderRepository.Where(x => x.CreationTime >= today.AddDays(-1) && x.CreationTime < today && x.LifePayOrderStatus == LifePayOrderStatusEnum.已完成).CountAsync(); |
|---|
| | | var yesterdayFail = await _lifePayOrderRepository.Where(x => x.CreationTime >= today.AddDays(-1) && x.CreationTime < today && x.LifePayOrderStatus == LifePayOrderStatusEnum.退款失败).CountAsync(); |
|---|
| | | /// 昨日失败：统计平台中订单状态为“充值失败/已退款”且订单下单时间在昨天的订单记录； |
|---|
| | | var yesterdayFail = await _lifePayOrderRepository.Where(x => x.CreationTime >= today.AddDays(-1) && x.CreationTime < today && x.LifePayOrderStatus == LifePayOrderStatusEnum.已退款).CountAsync(); |
|---|
| | | /// 累计用户 |
|---|
| | | var accumulatedUsers = await _lifePayUserRepository.CountAsync(); |
|---|
| | | /// 昨日活跃用户 |
|---|
| | | var yesterdayActiveUsers = await _lifePayUserRepository.Where(x => x.LastLoginTime >= today.AddDays(-1)).CountAsync(); |
|---|
| | | |
|---|
| | | var entity = new DallyStatistics() |
|---|
| | | { |
|---|
| | | Id = GuidGenerator.Create(), |
|---|
| | | CreationTime = DateTime.Now, |
|---|
| | | Amount = 0, |
|---|
| | | AccumulatedReceipts = accumulatedReceipts, |
|---|
| | | AccumulatedIncome = accumulatedIncome, |
|---|
| | | AccumulatedReceipts = accumulatedReceipts.HasValue? accumulatedReceipts.Value:0, |
|---|
| | | AccumulatedIncome = accumulatedIncome.HasValue ? accumulatedIncome.Value : 0, |
|---|
| | | ReceiptsYesterday = receiptsYesterday, |
|---|
| | | AccumulatedOrders = accumulatedOrders, |
|---|
| | | OrdersNumYesterday = ordersNumYesterday, |
|---|
