using Edu.Common.Plugin;
using Edu.Model.ViewModel.Scroll;
using Edu.Model.ViewModel.User;
using Edu.Repository.Scroll;
using Edu.Repository.User;
using Senparc.Weixin.Annotations;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using VT.FW.DB;

namespace Edu.Module.Course
{
    /// <summary>
    /// 学员预约处理类
    /// </summary>
    public class PlanAppoimentModule
    {
        /// <summary>
        /// 学员预约仓储层
        /// </summary>
        private readonly RB_Plan_AppointmentRepository plan_AppointmentRepository = new RB_Plan_AppointmentRepository();

        /// <summary>
        /// 学员预约详情仓储层
        /// </summary>
        private readonly RB_Plan_Appointment_DetailsRepository plan_Appointment_DetailsRepository = new RB_Plan_Appointment_DetailsRepository();

        /// <summary>
        /// 字典仓储层对象
        /// </summary>
        private readonly Rb_dictvalueRepository dictvalueRepository = new Rb_dictvalueRepository();

        /// <summary>
        /// 上课时段
        /// </summary>
        private readonly RB_Scroll_CourseTimeRepository scroll_CourseTimeRepository = new RB_Scroll_CourseTimeRepository();

        /// <summary>
        /// 获取上课时段列表
        /// </summary>
        /// <param name="group_Id"></param>
        /// <returns></returns>
        public List<CourseTimeModel> GetScrollCourseTimeList(int group_Id)
        {
            List<CourseTimeModel> timeList = new List<CourseTimeModel>();
            var list = scroll_CourseTimeRepository.GetList(new RB_Scroll_CourseTime_ViewModel() { Group_Id = group_Id });
            foreach (var item in list.Where(qitem=>qitem.Id==1))
            {
                item.TimeList = new List<CourseTimeModel>();
                if (!string.IsNullOrEmpty(item.Content))
                {
                    timeList = JsonHelper.DeserializeObject<List<CourseTimeModel>>(item.Content);
                }
            }
            if (timeList == null || (timeList != null && timeList.Count <= 0))
            {
                timeList.Add(new CourseTimeModel()
                {
                    StartTime = "09:30",
                    EndTime = "11:00",
                    Sort = 1
                });
                timeList.Add(new CourseTimeModel()
                {
                    StartTime = "11:10",
                    EndTime = "12:40",
                    Sort = 2
                });
                timeList.Add(new CourseTimeModel()
                {
                    StartTime = "13:30",
                    EndTime = "15:00",
                    Sort = 3
                });
                timeList.Add(new CourseTimeModel()
                {
                    StartTime = "15:10",
                    EndTime = "16:40",
                    Sort = 4
                });
                timeList.Add(new CourseTimeModel()
                {
                    StartTime = "16:50",
                    EndTime = "18:20",
                    Sort = 5
                });
                timeList.Add(new CourseTimeModel()
                {
                    StartTime = "19:00",
                    EndTime = "20:30",
                    Sort = 6
                });
            }
            return timeList;
        }

        /// <summary>
        /// 获取学员预约列表
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        public List<RB_Plan_Appointment_ViewModel> GetPlanAppointmentListModule(RB_Plan_Appointment_ViewModel query)
        {
            return plan_AppointmentRepository.GetPlanAppointmentListRepository(query);
        }

        /// <summary>
        /// 获取学员预约详情列表
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        public List<RB_Plan_Appointment_Details_ViewModel> GetPlanAppointmentDetailsListModule(RB_Plan_Appointment_Details_ViewModel query)
        {
            return plan_Appointment_DetailsRepository.GetPlanAppointmentDetailsListRepository(query);
        }

        /// <summary>
        /// 获取学员预约截止日期配置
        /// </summary>
        /// <param name="Group_Id"></param>
        /// <returns></returns>
        public RB_Dictvalue_Extend GetPlanAppointmentConfigModule(RB_Dictvalue_Extend query)
        {
            var model = dictvalueRepository.GetList(query)?.FirstOrDefault();
            return model;
        }

        /// <summary>
        /// 新增修改学员预约配置
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool SetPlanAppointmentConfigModule(RB_Dictvalue_Extend model)
        {
            bool flag = false;
            if (model.ID > 0)
            {
                Dictionary<string, object> fileds = new Dictionary<string, object>()
                {
                    {nameof(RB_Dictvalue_Extend.Code),model.Code }
                };
                flag = dictvalueRepository.Update(fileds, new WhereHelper(nameof(RB_Dictvalue_Extend.ID), model.ID));
            }
            else
            {
                var newId = dictvalueRepository.Insert(model);
                model.ID = newId;
                flag = newId > 0;
            }
            return flag;
        }

        /// <summary>
        /// 新增修改学员预约
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool SetPlanAppointmentModule(RB_Plan_Appointment_ViewModel model)
        {
            bool flag = false;
            var oldModel = GetPlanAppointmentListModule(new RB_Plan_Appointment_ViewModel()
            {
                QDate = Common.ConvertHelper.FormatDate(model.Date),
            })?.Where(qitem => qitem.StartTime == model.StartTime && qitem.EndTime == model.EndTime)?.FirstOrDefault();
            model.Id = oldModel?.Id ?? 0;
            if (model.Id > 0)
            {
                Dictionary<string, object> fileds = new Dictionary<string, object>()
                {
                    {nameof(RB_Plan_Appointment_ViewModel.Group_Id),model.Group_Id },
                };
                flag = plan_AppointmentRepository.Update(fileds, new WhereHelper(nameof(RB_Plan_Appointment_ViewModel.Id), model.Id));
            }
            else
            {
                var newId = plan_AppointmentRepository.Insert(model);
                model.Id = newId;
                flag = newId > 0;
            }
            var oldList = GetPlanAppointmentDetailsListModule(new RB_Plan_Appointment_Details_ViewModel()
            {
                PlanAppointmentId = model.Id
            });
            if (model.DetailsList != null && model.DetailsList.Count > 0)
            {
                foreach (var item in model.DetailsList)
                {
                    var oldDetailModel = oldList?.Where(qitem => qitem.Status == 0 && qitem.StuId == item.StuId)?.FirstOrDefault();
                    item.DetailsId = oldDetailModel?.DetailsId ?? 0;
                    item.PlanAppointmentId = model.Id;
                    if (item.DetailsId > 0)
                    {
                        plan_Appointment_DetailsRepository.Update(item);
                    }
                    else
                    {
                        plan_Appointment_DetailsRepository.Insert(item);
                    }
                }
            }
            return flag;
        }

        /// <summary>
        /// 学员根据编号删除预约信息
        /// </summary>
        /// <param name="DetailsId"></param>
        /// <returns></returns>
        public bool RemovePlanAppointmentModule(int DetailsId)
        {
            Dictionary<string, object> fileds = new Dictionary<string, object>()
            {
                {nameof(RB_Plan_Appointment_Details_ViewModel.Status),1 }
            };
            bool flag = plan_Appointment_DetailsRepository.Update(fileds, new WhereHelper(nameof(RB_Plan_Appointment_Details_ViewModel.DetailsId), DetailsId));
            return flag;
        }

        /// <summary>
        /// 获取学员预约列表
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        public List<RB_Plan_Appointment_Details_ViewModel> GetPlanAppointmentStatic(RB_Plan_Appointment_Details_ViewModel query)
        {
            return plan_Appointment_DetailsRepository.GetPlanAppointmentStaticRepository(query);
        }

        /// <summary>
        /// 小程序学员预约记录统计
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        public List<object> GetStuPlanAppointListModule(RB_Plan_Appointment_Details_ViewModel query)
        {
            List<object> list = new List<object>();
            var timeList = GetScrollCourseTimeList(query.Group_Id);
            var dataList = GetPlanAppointmentStatic(query);
            if (dataList != null && dataList.Count>0)
            {
                var dayList = dataList.GroupBy(qitem => new { qitem.Date }).Select(qitem => new { qitem.Key.Date }).OrderBy(qitem => qitem.Date);
                foreach (var item in dayList)
                {
                    var tempDataList = dataList?.Where(qitem => Common.ConvertHelper.FormatDate(qitem.Date) == Common.ConvertHelper.FormatDate(item.Date) && qitem.Status == 0  )?.ToList();
                    List<object> subList = new List<object>();
                    foreach (var subItem in tempDataList)
                    {
                       var timeModel= timeList.FirstOrDefault(qitem => qitem.StartTime == subItem.StartTime);
                        subList.Add(new
                        {
                            subItem.StartTime,
                            subItem.EndTime,
                            Sort=timeModel?.Sort??0,
                        });
                    }
                    list.Add(new
                    {
                        DateStr = Common.ConvertHelper.FormatDate(item.Date),
                        SubList = subList
                    });
                }
            }
            return list;
        }

        /// <summary>
        /// 获取学员预约统计
        /// </summary>
        /// <param name="startDate"></param>
        /// <param name="endDate"></param>
        /// <param name="Group_Id"></param>
        /// <returns></returns>
        public List<object> GetPlanAppointmentStaticModule(string startDate, string endDate, int Group_Id)
        {
            List<object> list = new List<object>();
            DateTime start = Convert.ToDateTime(startDate);
            DateTime end = Convert.ToDateTime(endDate);
            int days = (end - start).Days;
            var timeList = GetScrollCourseTimeList(Group_Id);
            var dataList = GetPlanAppointmentStatic(new RB_Plan_Appointment_Details_ViewModel()
            {
                QStartDate = startDate,
                QEndDate = endDate,
                Group_Id = Group_Id
            });
            List<RB_Plan_Appointment_Details_ViewModel> detailsList = new List<RB_Plan_Appointment_Details_ViewModel>();
            if (dataList != null && dataList.Count > 0)
            {
                string ids = string.Join(",", dataList.Select(qitem => qitem.PlanAppointmentId));
                detailsList = GetPlanAppointmentStatic(new Model.ViewModel.Scroll.RB_Plan_Appointment_Details_ViewModel()
                {
                    QPlanAppointmentIds = ids
                })?.Where(qitem=>qitem.Status==0)?.ToList();
            }

            for (var i = 0; i <= days; i++)
            {
                DateTime newDate = start.AddDays(i);
                List<object> subTimeList = new List<object>();
                foreach (var item in timeList)
                {
                    var tempDataList = dataList?.Where(qitem => Common.ConvertHelper.FormatDate(qitem.Date) == Common.ConvertHelper.FormatDate(newDate) && qitem.Status == 0 && qitem.StartTime == item.StartTime && qitem.EndTime == item.EndTime)?.ToList();
                    subTimeList.Add(new
                    {
                        item.StartTime,
                        item.EndTime,
                        item.Sort,
                        StuAppointNum = tempDataList?.Count() ?? 0,
                        SubDate = Common.ConvertHelper.FormatDate(newDate),
                        PlanAppointmentId = tempDataList?.FirstOrDefault()?.PlanAppointmentId ?? 0,
                        StuList = detailsList?.Where(qitem => qitem.PlanAppointmentId == (tempDataList?.FirstOrDefault()?.PlanAppointmentId ?? 0))
                        ?.Select(qitem => new
                        {
                            qitem.StuId,
                            qitem.StuName,
                            qitem.StartTime,
                            qitem.EndTime,
                            DateStr = Common.ConvertHelper.FormatDate(qitem.Date),
                            CreateTime = Common.ConvertHelper.FormatTime(qitem.CreateTime),
                            qitem.Status,
                            StatusStr = qitem.Status == 0 ? "正常" : "取消"
                        })
                    });
                }

                var obj = new
                {
                    DateStr = Common.ConvertHelper.FormatDate(newDate),
                    WeekStr= Common.ConvertHelper.GetWeekDay(newDate),
                    TimeList= subTimeList
                };
                list.Add(obj);
            }
            return list;
        }

        /// <summary>
        /// 获取学员预约统计
        /// </summary>
        /// <param name="startDate"></param>
        /// <param name="endDate"></param>
        /// <param name="StuId"></param>
        /// <returns></returns>
        public List<object> GetStuAppointPlanModule(string startDate, string endDate, int Group_Id ,int StuId)
        {
            List<object> list = new List<object>();
      
            var timeList = GetScrollCourseTimeList(Group_Id);
            var dataList = GetPlanAppointmentStatic(new RB_Plan_Appointment_Details_ViewModel()
            {
                QStartDate = startDate,
                QEndDate = endDate,
                Group_Id = Group_Id,
                StuId=StuId,
            });
            foreach (var item in dataList.OrderBy(qitem=>qitem.Date))
            {
                var tempTime = timeList?.FirstOrDefault(qitem => qitem.StartTime == item.StartTime && qitem.EndTime == item.EndTime);
                list.Add(new
                {
                    Date = Common.ConvertHelper.FormatDate(item.Date),
                    item.StuName,
                    item.StuId,
                    item.StartTime,
                    item.EndTime,
                    TimeId = tempTime?.Sort ?? 0
                });
            }
            return list;
        }
    }
}