WebDBFShow/Controllers/ReportController.cs - master - Gerz/WebDbfShow

WebDBFShow/Controllers/ReportController.cs

58 строк2 KB

Gerz

Add two mini stat function

11 мар 2023, 13:42

11 мар 2023, 13:42ed81efd

using Contracts;
using Entities.Dto;
using Entities.Models;
using Microsoft.AspNetCore.Mvc;
using Repository;
using Mapster;
using Microsoft.AspNetCore.Cors;
using System.Reflection.PortableExecutable;
using Contracts.DBF;
using Entities.Query;

namespace WebDBFShow.Controllers
{
    [Route("api/[controller]")]
    [ApiController]
    public class ReportController : ControllerBase
    {
        ILogger<ReportController> _logger;
        IShowService _service;
        IFileDbReader _reader;
        public ReportController(ILogger<ReportController> logger, IShowService service, IFileDbReader reader)
        {
            _logger = logger;            
            _service = service;
            _reader = reader;
        }

        [HttpPost]
        [EnableCors("Policy1")]
        [Route("statistics")]
        public ActionResult Statistics([FromForm] string? fileName)
        {
            var stat = _reader.CalculateStatistics(fileName);
            return Ok(stat);
        }

        [HttpPost]
        [EnableCors("Policy1")]
        [Route("group")]
        public ActionResult Group([FromForm] string? field, string? fileName)
        {            
            var stat = _reader.CalculateGroup(Request.Form["fileName"].ToString(), Request.Form["field"].ToString());
            return Ok(stat);
        }

        [HttpPost]
        [EnableCors("Policy1")]
        [Route("ministat")]           
        public ActionResult MiniStatFunction(QueryMiniStat query) {
            switch (query.FuncName) { 
                case "countunique":return Ok(_reader.CountUniqueRecordsInColumn(query.FileName, query.Field));
                case "countvalue": return Ok(_reader.CountValueRecordsInColumn(query.FileName, query.Field, query.Value));
                default: return NotFound();
            }
        }

    }
}