shop/CoreCms.Net.Utility/Helper/ReportsHelper.cs

/***********************************************************************
 *            Project: CoreCms.Net                                     *
 *                Web: https://CoreCms.Net                             *
 *        ProjectName: 核心内容管理系统                                *
 *             Author: 大灰灰                                          *
 *              Email: JianWeie@163.com                                *
 *         CreateTime: 2020-08-31 0:46:50
 *        Description: 暂无
 ***********************************************************************/


using System;
using System.Collections.Generic;
using System.Text;
using CoreCms.Net.Configuration;
using CoreCms.Net.Model.ViewModels.UI;
using CoreCms.Net.Utility.Extensions;

namespace CoreCms.Net.Utility.Helper
{
    /// <summary>
    /// 报表帮助类
    /// </summary>
    public static class ReportsHelper
    {

        //根据时间，返回时间段
        public static WebApiCallBack GetDate(string data, int section)
        {
            var jm = new WebApiCallBack();
            var reportsBackForGetDate = new ReportsBackForGetDate();
            if (!string.IsNullOrEmpty(data))
            {
                var dts = data.Split("到");
                if (dts.Length == 2)
                {
                    reportsBackForGetDate.start = dts[0].Trim().ObjectToDate();
                    reportsBackForGetDate.start = new DateTime(reportsBackForGetDate.start.Year, reportsBackForGetDate.start.Month, reportsBackForGetDate.start.Day, 0, 0, 0);
                    reportsBackForGetDate.end = dts[1].Trim().ObjectToDate();
                    reportsBackForGetDate.end = new DateTime(reportsBackForGetDate.end.Year, reportsBackForGetDate.end.Month, reportsBackForGetDate.end.Day, 23, 59, 59);
                    reportsBackForGetDate.section = 1;
                    jm.data = reportsBackForGetDate;
                }
                else
                {
                    jm.msg = "时间段格式不正确";
                    return jm;
                }
            }
            else
            {
                jm.msg = GlobalErrorCodeVars.Code10000;
                return jm;
            }
            //切片维度，1是小时，2是天，3是周，4是月，5是季度，6是半年，7是年
            if (section > 0)
            {
                reportsBackForGetDate.section = section;
            }
            //算统计需要的参数
            return getTmp(reportsBackForGetDate);

        }

        //根据时间节点和时间粒度算x轴个数
        public static WebApiCallBack getTmp(ReportsBackForGetDate dateArr)
        {
            var jm = new WebApiCallBack();

            if (dateArr.end <= dateArr.start)
            {
                jm.msg = "开始时间必须小于结束时间";
                return jm;
            }
            TimeSpan diffDt = dateArr.end - dateArr.start;  //两个时间相减 。默认得到的是两个的时间差
            switch (dateArr.section)
            {
                case 1:                 //小时
                    dateArr.section = 60 * 60;
                    dateArr.num = Convert.ToInt32(diffDt.TotalHours);
                    break;
                case 2:                 //天
                    dateArr.section = 60 * 60 * 24;
                    dateArr.num = Convert.ToInt32(diffDt.TotalDays);
                    break;
                default:
                    jm.msg = "没有此时间粒度";
                    return jm;
            }
            //算x轴数据个数
            jm.status = true;
            jm.data = dateArr;
            return jm;
        }

        public static WebApiCallBack GetXdata(ReportsBackForGetDate dateArr)
        {
            var jm = new WebApiCallBack();

            //校验,x轴最多1000个
            if (dateArr.num > 1000)
            {
                jm.msg = GlobalErrorCodeVars.Code13226;
                return jm;
            }

            var xType = "";
            switch (dateArr.section)
            {
                case 3600:                 //小时
                    if (dateArr.num <= 24)
                    {
                        xType = "d日H时";
                    }
                    else if (dateArr.num <= 720)
                    {
                        xType = "M月d日H时";
                    }
                    else
                    {
                        xType = "M月d日H时";
                    }
                    break;
                case 86400:                 //天
                    if (dateArr.num <= 31)
                    {
                        xType = "M月d号";
                    }
                    else if (dateArr.num <= 365)
                    {
                        xType = "yyyy年M月dd日";
                    }
                    else
                    {
                        xType = "yyyy年M月dd日";
                    }
                    break;
            }
            if (xType == "")
            {
                jm.msg = GlobalErrorCodeVars.Code10000;
                return jm;
            }

            var arr = new List<string>();
            if (dateArr.section == 3600)
            {
                var dtStart = dateArr.start;
                for (int i = 0; i < dateArr.num; i++)
                {
                    arr.Add(dtStart.AddHours(i).ToString(xType));
                }
            }
            else
            {
                var dtStart = dateArr.start;
                for (int i = 0; i < dateArr.num; i++)
                {
                    arr.Add(dtStart.AddDays(i).ToString(xType));
                }
            }

            jm.status = true;
            jm.data = arr;
            jm.otherData = dateArr;
            return jm;
        }

    }
}