using Common.Models.UnqTables;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Web.Http;

namespace Server.Controllers.DataOverviewController
{
    public class DataViewController : DefaultController
    {
        /// <summary>
        /// 今日数据
        /// </summary>
        /// <returns></returns>
        [HttpPost, ErrorFilter]
        public WebResult GetData()
        {
            //var MaxTimeToday = DateTime.Now; //当前时间
            //var MinTimeToday = Convert.ToDateTime(DateTime.Now.ToString("D").ToString());//当天0点

            //今日数据
            var Today = DateTime.Now.Date;
            var dataToday = Db.Queryable<DataOverview>().Where(f=>f.CreateTime.Date == Today).First();

            if (dataToday == null)
                dataToday = new DataOverview();

            //var MinTimeYesterday = Convert.ToDateTime(DateTime.Now.ToString("D")).AddDays(-1);//昨天0点
            //var MaxTimeYesterday = Convert.ToDateTime(DateTime.Now.ToString("D")).AddSeconds(-1);//昨天23点59分59秒

            //昨日数据
            var Yesterday = DateTime.Now.AddDays(-1).Date;
            var dataYesterday = Db.Queryable<DataOverview>().Where(f => f.CreateTime.Date == Yesterday).First();

            if (dataYesterday == null)
                dataYesterday = new DataOverview();

            return PutData(new { 
                Today = dataToday,
                Yesterday = dataYesterday,
            });
        }

        /// <summary>
        /// 指定范围时间数据
        /// </summary>
        /// <returns></returns>
        [HttpPost, ErrorFilter]
        public WebResult GetDataOverview()
        {
            var MinTime = GetTime("MinTime");
            var MaxTime = GetTime("MaxTime");

            if (MinTime == DateTime.MinValue) MinTime = DateTime.Now.AddMonths(-2);

            if (MaxTime == DateTime.MinValue) MaxTime = DateTime.Now;

            var exp = Expressionable.Create<DataOverview>();

            exp.And(f => f.CreateTime >= MinTime && f.CreateTime <= MaxTime);

            var PageIndex = GetInt("PageIndex", true);
            var PageSzie = GetInt("PageSize", true);
            var tNumber = 0;

            var DataList = Db.Queryable<DataOverview>().Where(exp.ToExpression())
                .ToPageList(PageIndex, PageSzie, ref tNumber);

            return PutData(new PageResult<DataOverview>(DataList, tNumber, PageSzie, PageIndex));
        }
    }
}