parr_api/PARR.API/Controllers/V1/Statistics/StatTemplateController.cs

using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using PARR.API.Contracts.V1;
using PARR.API.Contracts.V1.Requests.BaseRequests;
using PARR.API.Contracts.V1.Responses.Base;
using PARR.API.Contracts.V1.Responses.Statistics;
using PARR.API.Controllers.V1.Base;
using PARR.API.Helpers;
using PARR.Core.Repositories.Interfaces;
using PARR.Core.Services.NextRunServices;
using PARR.Domain.Common.Roles;
using PARR.Domain.Entities;
using PARR.Domain.Enums;

namespace PARR.API.Controllers.V1.Statistics
{
    /// <summary>
    /// Статистика по шаблонам
    /// </summary>
    [Authorize(Roles = ParrRoles.Administrator.Role)]
    public class StatTemplateController : BaseApiController
    {
        private readonly ITemplateRepository _templateRepository;
        private readonly INextRunService _nextRunService;

        public StatTemplateController(
            ITemplateRepository templateRepository,
            INextRunService nextRunService
            )
        {
            _templateRepository = templateRepository;
            _nextRunService = nextRunService;
        }

        /// <summary>
        /// Статистика по шаблонам
        /// </summary>
        /// <returns></returns>
        [HttpGet(ApiRoutes.StatTemplate.Get)]
        public async Task<IActionResult> Get()
        {
            var response = new StatTemplateResponse
            {
                ActivateScheduleCount = await _templateRepository.Get().AsNoTracking().CountAsync(t => t.IsActiveSchedule),
                ActivateTemplateCount = await _templateRepository.Get().AsNoTracking().CountAsync(t => t.IsActiveTemplate),
                TemplateAgentCount = await _templateRepository.Get().AsNoTracking().CountAsync(t => t.Job!.Group!.IsAgent),
                TemplateCount = await _templateRepository.Get().AsNoTracking().CountAsync(),
                SyncEsppScheduleCount = await _templateRepository.Get().AsNoTracking().CountAsync(t => t.RobotConfigurations.Any(c => c.RobotCode == (int)RobotsEnum.ScheduleOrder && c.TaskStatusCode == (int)TaskStatusEnum.Ok)),
                SyncEsppTemplatesCount = await _templateRepository.Get().AsNoTracking().CountAsync(t => t.RobotConfigurations.Any(c => c.RobotCode == (int)RobotsEnum.TemplateOrder && c.TaskStatusCode == (int)TaskStatusEnum.Ok))
            };

            return Ok(new Response<StatTemplateResponse>(response, true));
        }


        /// <summary>
        /// Получить статистику созданных шаблонов (расписаний) в БД ПАРР
        /// </summary>
        /// <param name="timeZoneQuery"></param>
        /// <param name="startPeriodDays"></param>
        /// <returns></returns>
        [HttpGet(ApiRoutes.StatTemplate.GetForPeriod)]
        public async Task<IActionResult> GetForPeriod([FromQuery] TimeZoneOffsetClient timeZoneQuery, [FromQuery] int startPeriodDays = 3)
        {
            // Формируем период
            var userEnd = DateOnly.FromDateTime(DateTimeOffset.UtcNow.ToOffset(timeZoneQuery.TimeZoneOffset).DateTime);
            var userStart = userEnd.AddDays(-startPeriodDays);

            var (utcStart, utcEnd) = TimeZoneDateHelper.GetUtcDateRange(
                                                            userStart,
                                                            userEnd.AddDays(1),
                                                            timeZoneQuery.TimeZoneOffset);

            var allRecords = await _templateRepository.Get()
                            .AsNoTracking()
                            .FilterByDateRangeUtc(t => t.DateCreated, utcStart, utcEnd)
                            .Select(t => new { t.Id, t.DateCreated })
                            .ToListAsync();

            var resultDict = allRecords.GroupByUserDate(t => t.DateCreated, timeZoneQuery.TimeZoneOffset);


            var daysList = await _nextRunService.GetWorkDaysAsync(userStart, userEnd, false);

            var response = daysList.Select(date => new StatTemplatePeriodResponse
            {
                Date = date,
                CreatedTemplatesCount = resultDict.TryGetValue(date, out var cnt) ? cnt : 0
            }).OrderBy(t => t.Date).ToList();

            return Ok(new Response<List<StatTemplatePeriodResponse>>(response, true));
        }


        /// <summary>
        /// Получить кол-во шаблонов у которых ИД расписания null и нет задания на создание расписания
        /// </summary>
        /// <returns></returns>
        [HttpGet(ApiRoutes.StatTemplate.GetTemplatesWithoutScheduleAndTaskCount)]
        public async Task<IActionResult> GetTemplatesWithoutScheduleAndTaskCount()
        {
            var count = await _templateRepository.Get()
                                    .CountAsync(t =>
                                            t.ScheduleEsppId == null
                                            && !t.RobotConfigurations.Any(x =>
                                                x.RobotCode == (int)RobotsEnum.ScheduleOrder
                                                && x.TaskStatusCode == (int)TaskStatusEnum.Creating
                                                )
                                     );

            var resposne = new StatTemplatesWithoutScheduleResponse(count);

            return Ok(new Response<StatTemplatesWithoutScheduleResponse>(resposne, true));
        }


    }
}