using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using AutoMapper;
using DTO;
using IServices;
using Microsoft.AspNetCore.Mvc.Rendering;
using Microsoft.EntityFrameworkCore;
using zhengcaioa.Models;

namespace Services
{
    public class FiOrderrecievemoneyService:IFiOrderrecievemoneyService
    {
        private readonly zhengcaioaContext _context;
        private readonly IMapper _mapper;
        public FiOrderrecievemoneyService(zhengcaioaContext context, IMapper mapper)
        {
            _context = context;
            _mapper = mapper;
        }
        public ResultEntity save(FiOrderrecievemoneyDTO dto)
        {
            ResultEntity resultEntity = new ResultEntity();
            try
            {


                var entity = _mapper.Map<FiOrderrecievemoney>(dto);


                if (String.IsNullOrEmpty(entity.Id))
                {
                    entity.Id = Guid.NewGuid().ToString();
                    _context.FiOrderrecievemoneys.Add(entity);
                }
                else
                {
                    var updateproject = _context.FiOrderrecievemoneys.Find(entity.Id);

                    updateproject.OrderId = entity.OrderId;
                    updateproject.Recievemoney = entity.Recievemoney;
                    updateproject.PayType = entity.PayType;
                    updateproject.PayTime = entity.PayTime;
                    updateproject.Remark = entity.Remark;
                    updateproject.RecStatus = entity.RecStatus;
                    updateproject.Modifier = entity.Modifier;
                    updateproject.Modifytime = entity.Modifytime;

                }

                _context.SaveChanges();
                resultEntity.ReturnID = entity.Id;
                resultEntity.Result = true;
            }
            catch (Exception ex)
            {
                resultEntity.Result = false;
                resultEntity.Message = "保存失败，请联系管理员";

            }
            return resultEntity;
        }

        public FiOrderrecievemoneyDTO Get(string id)
        {

            var entity = _context.FiOrderrecievemoneys.Find(id);

            if (entity.RecStatus != "A")
            {
                entity = new FiOrderrecievemoney();
            }

            var result = _mapper.Map<FiOrderrecievemoneyDTO>(entity);


            return result;
        }

        public ResultDataEntity<FiOrderrecievemoneyDTO> SearchByPaging(FiOrderrecievemoneyDTOSearch searchEntity)
        {



            ResultDataEntity<FiOrderrecievemoneyDTO> data = new ResultDataEntity<FiOrderrecievemoneyDTO>();
            List<FiOrderrecievemoneyDTO> list = new List<FiOrderrecievemoneyDTO>();




            var listCode = (from a in _context.SysCodeDtls
                            join b in _context.SysCodes
                            on a.CodeId equals b.Id
                            where a.RecStatus == "A"
                                          && b.RecStatus == "A"
                            select new CodeDataEntity()
                            {
                                CodeId = b.Id,
                                CodeTable = b.CodeTable,
                                CodeField = b.CodeField,
                                CodeSn = a.CodeSn,
                                Comments = a.Comments,
                                Contents = a.Contents,
                                RecStatus = a.RecStatus,
                                Sort = a.Sort
                            }
                      );
            DateTime XdTimestart = DateTime.Now;
            DateTime XdTimeend = DateTime.Now;
            if (!string.IsNullOrWhiteSpace(searchEntity.XdTime))
            {
                string[] XdTimes = searchEntity.XdTime.Split("|");
                DateTime.TryParse(XdTimes[0], out XdTimestart);
                DateTime.TryParse(XdTimes[1], out XdTimeend);
                //XdTimeend = XdTimeend.AddDays(1);
            }

            ///FiOrderrecievemoneys
            var query = (from a in _context.CooperOrders
                         join l in _context.FiOrderrecievemoneys.Where(x => x.RecStatus == "A").GroupBy(q => new { q.OrderId }).Select(q => new
                         {
                             OrderId = q.Key.OrderId,
                             YishouMoney = q.Sum(x=>x.Recievemoney),
                         }
                          )
                         on a.Id equals l.OrderId
                        into lsss
                         from lll in lsss.DefaultIfEmpty()


                         join b in listCode.Where(x => x.CodeTable == "CooperOrder" && x.CodeField == "shouli_status")
                         on a.ShouliStatus equals b.CodeSn
                         into bsss
                         from bbb in bsss.DefaultIfEmpty()

                         join c in listCode.Where(x => x.CodeTable == "CooperOrder" && x.CodeField == "huifang_status")
                        on a.HuifangStatus equals c.CodeSn
                        into csss
                         from ccc in csss.DefaultIfEmpty()

                         join d in listCode.Where(x => x.CodeTable == "CooperOrder" && x.CodeField == "pingjia_status")
                       on a.PingjiaStatus equals d.CodeSn
                       into dsss
                         from ddd in dsss.DefaultIfEmpty()

                         join e in listCode.Where(x => x.CodeTable == "system" && x.CodeField == "shifou")
                        on a.ChedanStatus equals e.CodeSn
                        into esssss
                         from eee in esssss.DefaultIfEmpty()

                         join f in listCode.Where(x => x.CodeTable == "CooperVisit" && x.CodeField == "jtype")
                         on a.OrderType equals f.CodeSn
                          into fsssss
                         from fff in fsssss.DefaultIfEmpty()


                         join g in _context.CooperatecustomCustomers.Where(x => x.RecStatus == "A")
                          on a.Khdw equals g.Id
                         into gsss
                         from ggg in gsss.DefaultIfEmpty()

                         join h in _context.Projects.Where(x => x.RecStatus == "A")
                        on a.OrderPro equals h.Id
                       into hsss
                         from hhh in hsss.DefaultIfEmpty()

                         join i in listCode.Where(x => x.CodeTable == "system" && x.CodeField == "shifou")
                       on a.WangongStatus equals i.CodeSn
                       into isssss
                         from iii in isssss.DefaultIfEmpty()

                         join j in listCode.Where(x => x.CodeTable == "system" && x.CodeField == "shifou")
                       on a.SonghuoStatus equals j.CodeSn
                       into jsssss
                         from jjj in jsssss.DefaultIfEmpty()

                         join k in _context.Oayouhuis.Where(x => x.Recstatus == "A")
                      on a.Id equals k.CooperOrderId
                      into ksssss
                         from kkk in ksssss.DefaultIfEmpty()


                         join n in _context.FiBooks
                   on a.OrderType1 equals n.Id
                   into nsssss
                         from nnn in nsssss.DefaultIfEmpty()

                         join m in _context.FiMembers
                   on a.OrderType1 equals m.Id
                   into msssss
                         from mmm in msssss.DefaultIfEmpty()

                         join s in _context.PltUsers
         on a.Creater equals s.Id
         into ssssss
                         from sss in ssssss.DefaultIfEmpty()

                         where a.RecStatus == "A"  && a.ChedanStatus == "D"
                          && (string.IsNullOrWhiteSpace(searchEntity.XdTime) || (a.XdTime >= XdTimestart && a.XdTime <= XdTimeend))
                          && (string.IsNullOrWhiteSpace(searchEntity.OrderType) || a.OrderType == searchEntity.OrderType.Trim())
                          && (string.IsNullOrWhiteSpace(searchEntity.OrderNo) || a.OrderNo.Contains(searchEntity.OrderNo.Trim()))
                          && (string.IsNullOrWhiteSpace(searchEntity.HuiyuanId) || ggg.HuiyuanId == searchEntity.HuiyuanId.Trim())
                           && (string.IsNullOrWhiteSpace(searchEntity.StartTime) || a.XdTime >= DateTime.Parse(searchEntity.StartTime) )
                            && (string.IsNullOrWhiteSpace(searchEntity.EndTime) ||  a.XdTime <= DateTime.Parse(searchEntity.EndTime).AddSeconds(1))
                              && ((searchEntity.HuiyuanIds == null || searchEntity.HuiyuanIds.Length == 0) || searchEntity.HuiyuanIds.Contains(ggg.HuiyuanId))
                                && ((searchEntity.OrderTypes == null || searchEntity.OrderTypes.Length == 0) || searchEntity.OrderTypes.Contains(a.OrderType))
                                && (string.IsNullOrWhiteSpace(searchEntity.OrderType1) || a.OrderType1 == searchEntity.OrderType1.Trim())





                         select new FiOrderrecievemoneyDTO
                         {
                             Id = a.Id,
                             OrderId = a.Id,
                             XdTime = a.XdTime,
                             XdTimeName = a.XdTime.ToString("yyyy-MM-dd HH:mm:ss"),
                             OrderNo = a.OrderNo,
                             OrderNum = a.OrderNum,
                             Khdw = a.Khdw,
                             KhdwName = ggg.Name,
                             OrderType = a.OrderType,
                             OrderTypeName = fff.Comments,
                             OrderTypeName1 = fff.Comments +"-"+ (string.IsNullOrEmpty(nnn.BookName) ? string.IsNullOrEmpty(mmm.MemberType) ? a.OrderType1 : mmm.MemberType : nnn.BookName) + (string.IsNullOrEmpty(a.OrderType2)?"":"-"+ a.OrderType2),
                             Money = (a.Money ?? 0)/* - (a.Youhui ?? 0)*/,
                             YishouMoney = lll.YishouMoney??0,
                             WeishouMoney = (a.Money ?? 0) /*- (a.Youhui ?? 0)*/ - (lll.YishouMoney??0),

                             HuiyuanId = ggg.HuiyuanId,



                             Remark = a.Remark,

                             Creater = a.Creater,
                             Createtime = a.Createtime,
                             CreaterName = sss.UserName,
                             RecStatus = a.RecStatus,
                             Modifier = a.Modifier,
                             Modifytime = a.Modifytime,
                             OrderStatus =  bbb.Comments ,
                         }
                ).OrderByDescending(x => x.OrderNo).ToList();

            if ( !string.IsNullOrWhiteSpace(searchEntity.Fkzt)){
                if (searchEntity.Fkzt.Trim().Equals("01"))
                {
                    query = query.Where(x => x.YishouMoney <= 0 && x.WeishouMoney>0).OrderByDescending(x => x.OrderNo).ToList();
                }
                else if (searchEntity.Fkzt.Trim().Equals("02"))
                {
                    query = query.Where(x => x.YishouMoney > 0 && x.WeishouMoney > 0).OrderByDescending(x => x.OrderNo).ToList();
                }
                else if (searchEntity.Fkzt.Trim().Equals("03"))
                {
                    query = query.Where(x => x.WeishouMoney <= 0).OrderByDescending(x => x.OrderNo).ToList();
                }
            }

            //if (searchEntity.totalrows == 0)
                searchEntity.totalrows = query.Count();
            data.Heji1 = Math.Round(query.Sum(x => x.OrderNum) ?? 0, 2);
            data.Heji2 = Math.Round(query.Sum(x => x.Money) , 2);
            data.Heji3 = Math.Round(query.Sum(x => x.YishouMoney), 2);
            data.Heji4 = Math.Round(query.Sum(x => x.WeishouMoney), 2);
            var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
            data.DangyeHeji1 = Math.Round(lianlist.Sum(x => x.OrderNum)??0, 2);
            data.DangyeHeji2 = Math.Round(lianlist.Sum(x => x.Money), 2);
            data.DangyeHeji3 = Math.Round(lianlist.Sum(x => x.YishouMoney) , 2);
            data.DangyeHeji4 = Math.Round(lianlist.Sum(x => x.WeishouMoney) , 2);
            data.LoadData(searchEntity, lianlist);
            return data;
        }






        /// <summary>
        /// 修改主表状态
        /// </summary>
        /// <param name="id">主id</param>
        /// <param name="userid">用户</param>
        /// <returns></returns>
        public ResultEntity ModifyStatus(string id, string userid)
        {
            ResultEntity result = new ResultEntity();
            result.Result = true;

            var model = _context.FiOrderrecievemoneys.Find(id);
            if (model != null)
            {
                model.RecStatus = "D";
                model.Modifier = userid;
                model.Modifytime = DateTime.Now;
                _context.SaveChanges();
            }

            return result;
        }

        public List<FiOrderrecievemoneyDTO> GetList(string orderid = "")
        {

            var entity = _context.FiOrderrecievemoneys.Where(x=>x.OrderId == orderid && x.RecStatus == "A");

         

            var result = _mapper.Map<List<FiOrderrecievemoneyDTO>>(entity);


            return result;
        }

    }
}