using System; using System.Collections.Generic; using System.Configuration; using System.Data.Entity; using System.Linq; using System.Threading.Tasks; using System.Web.Mvc; using Abp.Auditing; using Abp.Domain.Repositories; using IwbZero.Authorization.Base; using IwbZero.Authorization.Base.Users; using IwbZero.ToolCommon.StringModel; using WeApp.Configuration; using WeApp.TrainingCamp; using WeEngine.Statistic; namespace WeApp.BaseSystem.ExQuery { [AllowAnonymous, DisableAuditing] public class ExQueryAppService : IwbAppServiceBase, IExQueryAppService { public ExQueryAppService(IRepository userLoginRepository, IRepository campRepository, IRepository campGroupRepository) { _userLoginRepository = userLoginRepository; _campRepository = campRepository; _campGroupRepository = campGroupRepository; } protected IRepository _userLoginRepository { get; } protected IRepository _campRepository { get; } protected IRepository _campGroupRepository { get; } public async Task Statistic() { var date = DateTime.Now.AddHours(-2); var today = DateTime.Today; StatisticUserDto statisticUser = new StatisticUserDto { TotalLogin = await _userLoginRepository.CountAsync(a => a.Result == IwbLoginResultType.Success), TodayLogin = await _userLoginRepository.CountAsync(a => a.Result == IwbLoginResultType.Success && a.CreationTime >= today), Online = await _userLoginRepository.CountAsync(a => a.Result == IwbLoginResultType.Success && a.CreationTime >= date), Playing = await _campGroupRepository.CountAsync(a => a.CampGroupState != CampGroupStateDefinition.New && a.CampGroupState != CampGroupStateDefinition.End && a.CampGroupState != CampGroupStateDefinition.Error) }; statisticUser.Online = statisticUser.Online < statisticUser.Playing ? statisticUser.Playing : statisticUser.Online; statisticUser.TodayLogin = statisticUser.TodayLogin < statisticUser.Online ? statisticUser.Online : statisticUser.TodayLogin; StatisticCampDto statisticCamp = new StatisticCampDto() { CampCount = await _campRepository.CountAsync(a => a.CampState != CampStateDefinition.New), PlayCount = await _campGroupRepository.CountAsync(a => a.CampGroupState != CampGroupStateDefinition.New), //PlayerTotalCount = TodayPlayCount = await _campGroupRepository.CountAsync(a => (a.CampGroupState != CampGroupStateDefinition.New) && a.CreationTime >= today), //TodayPlayerTotalCount = }; statisticCamp.PlayerTotalCount = statisticCamp.PlayCount * 5; statisticCamp.TodayPlayerTotalCount = statisticCamp.TodayPlayCount * 5; List playingCamps = await _campGroupRepository.GetAllIncluding(a => a.CampInfo).Where(a => a.CampInfo != null && (a.CampInfo.CampState == CampStateDefinition.Audit || a.CampInfo.CampState == CampStateDefinition.Run) && a.CampGroupState != CampGroupStateDefinition.End && a.CampGroupState != CampGroupStateDefinition.Error).Select(a => new PlayingCampDto() { No = a.Id, Name = a.CampInfo.Name + " - " + a.Name, }).ToListAsync(); StatisticDto statistic = new StatisticDto() { UserInfo = statisticUser, CampInfo = statisticCamp, PlayingInfo = playingCamps.Select(MapPlayingCampDto).ToList(), }; return statistic; } private readonly string WebRootUrl = ConfigurationManager.AppSettings["WebRootUrl"]?.Ew("/") ?? "Http://ShVber.com:5027/"; private PlayingCampDto MapPlayingCampDto(PlayingCampDto dto) { dto.Url = $"{WebRootUrl}Exercise/display/{dto.No}"; return dto; } } }