WEP_V2.1.3/SourceCode/We.App/WeApp.Application/BaseSystem/ExQuery/ExQueryAppService.cs

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<UserLoginAttempt, long> userLoginRepository, IRepository<CampInfo, string> campRepository, IRepository<CampGroupInfo, string> campGroupRepository)
        {
            _userLoginRepository = userLoginRepository;
            _campRepository = campRepository;
            _campGroupRepository = campGroupRepository;
        }

        protected IRepository<UserLoginAttempt, long> _userLoginRepository { get; }
        protected IRepository<CampInfo, string> _campRepository { get; }
        protected IRepository<CampGroupInfo, string> _campGroupRepository { get; }

        public async Task<StatisticDto> 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<PlayingCampDto> 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;
        }
    }
}