using IStation.ChEr.Application;
using IStation.ChEr.Model;

namespace IStation.Application
{
    /// <summary>
    /// Debug
    /// </summary>
    [Route("Debug")]
    [ApiDescriptionSettings("Debug", Name = "Debug(调试)", Order = 9900)]
    public class DebugController : IDynamicApiController
    {
        private IStation.ChEr.BLL.WaterPredictRecord bll = new IStation.ChEr.BLL.WaterPredictRecord();

        /// <summary>
        ///Debug log
        /// </summary>
        [Route("LogInfo")]
        [HttpGet]
        public string LogInfo()
        {
            /*      List<WaterPredictRecord> waterPredictRecord = new List<WaterPredictRecord>();
                ConnectHelper connectHelper = new ConnectHelper();
                var list = ConnectHelper.ReadPumpAllDayAccOutWater(new DateTime(2023, 1, 1), new DateTime(2023, 11, 14));
                foreach (var item in list)
                {
                    foreach (var item2 in item.pumpOutWater)
                    {
                        int dayHour = int.Parse(string.Format("{0:00}{1:00}{2:00}", item2.DateTime.Month, item2.DateTime.Day, item2.DateTime.Hour));

                        waterPredictRecord.Add(new WaterPredictRecord { DayHour = dayHour, RealValue = item2.Total });
                    }
                }
                bll.Inserts(waterPredictRecord);*/
            List<SSAData> sSADatas = new List<SSAData>();
            /* var path = "C:\\Users\\ZKC\\Desktop\\工now.csv";
             int totalLines = File.ReadLines(path, Encoding.GetEncoding("gb2312")).Count();//总行数
             System.IO.FileStream fs = new System.IO.FileStream(path, System.IO.FileMode.Open);
             System.IO.StreamReader sr = new System.IO.StreamReader(fs, Encoding.GetEncoding("gb2312"));
             string tempText;
             //   int line = 0;
             double total = 0;
             for (int i = 0; i < totalLines; i++)
             {
                 tempText = sr.ReadLine();
                 string[] arr = tempText.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
                 if (Convert.ToDateTime(arr[0]).Minute == 0)
                 {
                     sSADatas.Add(new SSAData { DateTime = Convert.ToDateTime(arr[0]), Total = Convert.ToDouble(arr[1]) });
                 }
             }
             var nee = new List<WaterPredictRecord>();
             double lastValue = 1;
             foreach (var item in sSADatas)
             {
                 if (item.DateTime.Minute == 0)
                 {
                     if (lastValue != 1)
                     {
                         int historyhour = int.Parse(string.Format("{0:00}{1:00}{2:00}", item.DateTime.Month, item.DateTime.Day, item.DateTime.Hour));
                         nee.Add(new WaterPredictRecord() { DayHour = historyhour, RealTotalValue = item.Total, RealDifferenceValue = item.Total - lastValue });
                         lastValue = item.Total;
                     }
                     else
                     {
                         int historyhour = int.Parse(string.Format("{0:00}{1:00}{2:00}", item.DateTime.Month, item.DateTime.Day, item.DateTime.Hour));
                         nee.Add(new WaterPredictRecord() { DayHour = historyhour, RealTotalValue = item.Total, RealDifferenceValue = 0 });
                         lastValue = item.Total;
                     }
                 }
             }
             bll.Inserts(nee);*/
            double lastValue = 1;
            var historylist = new List<WaterPredictRecord>();
            var historydata = ConnectHelper.GetByPumpOneDayWaterData(DateTime.Today.AddDays(-15), DateTime.Today, "1h");
            foreach (var item in historydata)
            {
                if (lastValue != 1)
                {
                    int historyhour = int.Parse(string.Format("{0:00}{1:00}{2:00}", item.DateTime.Month, item.DateTime.Day, item.DateTime.Hour));
                    historylist.Add(new WaterPredictRecord() { DayHour = historyhour, RealTotalValue = item.Total, RealDifferenceValue = item.Total - lastValue });
                    lastValue = item.Total;
                }
                else
                {
                    int historyhour = int.Parse(string.Format("{0:00}{1:00}{2:00}", item.DateTime.Month, item.DateTime.Day, item.DateTime.Hour));
                    historylist.Add(new WaterPredictRecord() { DayHour = historyhour, RealTotalValue = item.Total, RealDifferenceValue = 0 });
                    lastValue = item.Total;
                }
            }
            bll.Inserts(historylist);
            // int a = 0;
            /*  for (DateTime i = DateTime.Today.AddDays(-12); i < DateTime.Today; i = i.AddDays(1))
              {
                  for (int k = 0; k < 24; k++)
                  {
                      var ssso = int.Parse(string.Format("{0:00}{1:00}{2:00}", i.Month, i.Day, k));
                      alllist[a].DayHour = ssso;
                      a++;
                  }
              }
              bll.Updates(alllist);*/
            SSAData.insert2daysPredictData();  //插入两天预测数据
            var todayData = ConnectHelper.GetByPumpOneDayWaterData(DateTime.Today, DateTime.Today.AddDays(1), "1h").Where(x => x.DateTime.Hour <= DateTime.Now.Hour).ToList();
            var starthour = int.Parse(string.Format("{0:00}{1:00}{2:00}", DateTime.Now.Month, DateTime.Now.Day, 0));
            var endhour = int.Parse(string.Format("{0:00}{1:00}{2:00}", todayData.Last().DateTime.Month, todayData.Last().DateTime.Day, todayData.Last().DateTime.Hour));
            var alllist2 = bll.GetEnd2Days(300);
            var currentdata = alllist2.Where(x => x.DayHour >= starthour && x.DayHour <= endhour).OrderBy(x => x.DayHour).ToList();
            //找出所有数据中和取实时数据匹配的数据并赋值
            for (int i = 0; i < currentdata.Count; i++)
            {
                currentdata[i].RealTotalValue = todayData[i].Total;
                if (i >= 1)
                {
                    currentdata[i].RealDifferenceValue = todayData[i].Total - todayData[i - 1].Total;
                }
                else
                {
                    //   currentdata[i].RealDifferenceValue = todayData[i].Total-bll.GetEnd2Days(24).Last().RealValue;
                }
            }
            bll.UpdatesRealValue(currentdata);
            return "ok";
        }

        /// <summary>
        ///  最近3条记录
        /// </summary>
        [Route("GetLastRecord3")]
        [HttpGet]
        public List<IStation.ChEr.Model.WaterPredictRecord> GetLastRecord3()
        {
            IStation.ChEr.BLL.WaterPredictRecord bll = new ChEr.BLL.WaterPredictRecord();

            return bll.GetLast(3);
        }

        /// <summary>
        /// 保存到数据库
        /// </summary>
        [Route("InsertRecord")]
        [HttpGet]
        public string InsertRecord()
        {
            IStation.ChEr.BLL.WaterPredictRecord bll = new ChEr.BLL.WaterPredictRecord();
            int dayHour = int.Parse(string.Format("{0:00}{1:00}{2:00}", DateTime.Now.Month, DateTime.Now.Day, DateTime.Now.Hour));
            bll.Insert(new ChEr.Model.WaterPredictRecord() { DayHour = dayHour, RealTotalValue = -1, LastPredictTime = DateTime.Now, PredictTime = DateTime.Now, LastPredictValue = 104, PredictValueList = "101,103,105,107" });
            return "ok";
        }
    }
}