| | |
| | | if (channleList.Count() == 0) |
| | | { |
| | | /// 账户余额 |
| | | var accountBalance = totalRechargeReceipts - await _lifePayOrderRepository.Where(x => x.PayStatus == LifePayStatusEnum.已支付 |
| | | && (x.ACOOLYStatus == ACOOLYStatusEnum.充值成功 || x.ACOOLYStatus == ACOOLYStatusEnum.已完成 || x.ACOOLYStatus == ACOOLYStatusEnum.部分充值成功)) |
| | | var accountBalance = totalRechargeReceipts - await _lifePayOrderRepository.Where(x => x.ACOOLYStatus == ACOOLYStatusEnum.充值成功 || x.ACOOLYStatus == ACOOLYStatusEnum.已完成 || x.ACOOLYStatus == ACOOLYStatusEnum.部分充值成功) |
| | | .SumAsync(x => x.PlatformDeductionAmount); |
| | | topStatisticsOutput.Amount = accountBalance ?? 0; |
| | | |
| | | } |
| | | |
| | | return topStatisticsOutput; |
| | |
| | | if (channleList.Count() == 0) |
| | | { |
| | | /// 账户余额 |
| | | var accountBalance = totalRechargeReceipts - await _lifePayOrderRepository.Where(x => x.PayStatus == LifePayStatusEnum.已支付 |
| | | && (x.ACOOLYStatus == ACOOLYStatusEnum.充值成功 || x.ACOOLYStatus == ACOOLYStatusEnum.已完成 || x.ACOOLYStatus == ACOOLYStatusEnum.部分充值成功)) |
| | | var accountBalance = totalRechargeReceipts - await _lifePayOrderRepository.Where(x => x.ACOOLYStatus == ACOOLYStatusEnum.充值成功 || x.ACOOLYStatus == ACOOLYStatusEnum.已完成 || x.ACOOLYStatus == ACOOLYStatusEnum.部分充值成功) |
| | | .SumAsync(x => x.PlatformDeductionAmount); |
| | | topStatisticsOutput.Amount = accountBalance ?? 0; |
| | | } |
| | |
| | | /// 累计用户 |
| | | var accumulatedUsers = await _lifePayUserRepository.Where(x => x.IsDeleted == false).WhereIf(!string.IsNullOrWhiteSpace(channleId), x => x.CreationChannleNum == channleId).CountAsync(); |
| | | /// 昨日活跃用户 |
| | | var yesterdayActiveUsers = await _lifePayUserRepository.Where(x => x.IsDeleted == false).WhereIf(!string.IsNullOrWhiteSpace(channleId), x => x.CreationChannleNum == channleId).Where(x => x.LastLoginTime >= today.AddDays(-1) && x.LastLoginTime < today).CountAsync(); |
| | | |
| | | var yesterdayActiveUsers = await (from a in _lifePayUserRepository |
| | | join b in _lifePayOrderRepository on a.Id equals b.UserId |
| | | where b.CreationTime >= today.AddDays(-1) && b.CreationTime < today |
| | | && (b.ACOOLYStatus == ACOOLYStatusEnum.充值中 || b.ACOOLYStatus == ACOOLYStatusEnum.充值成功 || b.ACOOLYStatus == ACOOLYStatusEnum.已完成 || b.ACOOLYStatus == ACOOLYStatusEnum.部分充值成功) |
| | | select b).Distinct().CountAsync(); |
| | | /// 累计佣金 |
| | | var accumulatedChannlesRakePrice = await _lifePayChannlesRakeRepository.Where(x => x.IsDeleted == false && x.FinishTime < today) |
| | | .WhereIf(!string.IsNullOrWhiteSpace(channleId), x => x.ChannelId == channleId).SumAsync(x => x.ChannlesRakePrice); |
| | | |