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 CooperVisitService: ICooperVisitService
    {
        private readonly zhengcaioaContext _context;
        private readonly IMapper _mapper;
        public CooperVisitService(zhengcaioaContext context, IMapper mapper)
        {
            _context = context;
            _mapper = mapper;
        }


        public ResultEntity save(CooperVisitDTO dto)
        {
            ResultEntity resultEntity = new ResultEntity();
            try
            {


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


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

                    updateproject.Vistime = entity.Vistime;
                    updateproject.VisType = entity.VisType;
                    updateproject.Viscustomer = entity.Viscustomer;
                    updateproject.Jtype = entity.Jtype;
                    updateproject.Jdr = entity.Jdr;
                    updateproject.Zw = entity.Zw;
                    updateproject.Talk = entity.Talk;
                    updateproject.Khfk = entity.Khfk;
                    updateproject.Yx = entity.Yx;
                    updateproject.Jy = entity.Jy;


                    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 CooperVisitDTO Get(string id)
        {

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

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

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


            return result;
        }

        public ResultDataEntity<CooperVisitDTO> SearchByPaging(CooperVisitDTOSearch searchEntity)
        {



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




            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 Vistimestart = DateTime.Now;
            DateTime Vistimeend = DateTime.Now;
            if (!string.IsNullOrWhiteSpace(searchEntity.Vistime))
            {
                string[] Vistimes = searchEntity.Vistime.Split("|");
                DateTime.TryParse(Vistimes[0], out Vistimestart);
                DateTime.TryParse(Vistimes[1], out Vistimeend);
                //Vistimeend = Vistimeend.AddDays(1);
            }


            var query = (from a in _context.CooperVisits
                         join b in listCode.Where(x => x.CodeTable == "CooperVisit" && x.CodeField == "visType")
                           on a.VisType equals b.CodeSn
                            into bzsssss
                         from bzzzzz in bzsssss.DefaultIfEmpty()

                         join c in listCode.Where(x => x.CodeTable == "CooperVisit" && x.CodeField == "jtype")
                         on a.Jtype equals c.CodeSn
                           into czsssss
                         from czzzzz in czsssss.DefaultIfEmpty()

                         join d in listCode.Where(x => x.CodeTable == "CooperVisit" && x.CodeField == "zw")
                          on a.Zw equals d.CodeSn
                            into dzsssss
                         from dzzzzz in dzsssss.DefaultIfEmpty()

                         join e in listCode.Where(x => x.CodeTable == "CooperVisit" && x.CodeField == "yx")
                         on a.Yx equals e.CodeSn
                           into ezsssss
                         from ezzzzz in ezsssss.DefaultIfEmpty()

                         join f in listCode.Where(x => x.CodeTable == "CooperVisit" && x.CodeField == "jy")
                          on a.Jy equals f.CodeSn
                            into fzsssss
                         from fzzzzz in fzsssss.DefaultIfEmpty()

                         join zz in _context.CooperatecustomCustomers
                         on a.Viscustomer equals zz.Id

                         //join g in _context.Areas on zz.Sheng equals g.CodeId
                         //join h in _context.Areas on zz.City equals h.CodeId
                         //join i in _context.Areas on zz.AreaId equals i.CodeId

                         join zzz in _context.PltUsers.Where(x => x.RecStatus == "A")
                        on a.Creater equals zzz.Id
                        into zsssss
                         from zzzzz in zsssss.DefaultIfEmpty()


                         where a.RecStatus == "A"
                          && (string.IsNullOrWhiteSpace(searchEntity.Vistime) || (a.Vistime >= Vistimestart && a.Vistime <= Vistimeend))
                         && (string.IsNullOrWhiteSpace(searchEntity.Name) || zz.Name.Contains(searchEntity.Name.Trim()))
                          && (string.IsNullOrWhiteSpace(searchEntity.Khly) || zz.Khly == searchEntity.Khly.Trim())
                           && (string.IsNullOrWhiteSpace(searchEntity.Hyfl) || zz.Hyfl == searchEntity.Hyfl.Trim())
                            && (string.IsNullOrWhiteSpace(searchEntity.Khlx) || zz.Khlx == searchEntity.Khlx.Trim())
                             && (string.IsNullOrWhiteSpace(searchEntity.Ywjl) || zz.Ywjl == searchEntity.Ywjl.Trim())
                              && (string.IsNullOrWhiteSpace(searchEntity.Sheng) || zz.Sheng == searchEntity.Sheng.Trim())
                               && (string.IsNullOrWhiteSpace(searchEntity.City) || zz.City == searchEntity.City.Trim())
                                && (string.IsNullOrWhiteSpace(searchEntity.AreaId) || zz.AreaId == searchEntity.AreaId.Trim())
                                 && (string.IsNullOrWhiteSpace(searchEntity.Viscustomer) || a.Viscustomer == searchEntity.Viscustomer.Trim())
                         select new CooperVisitDTO
                         {
                             Id = a.Id,
                             Vistime = a.Vistime,
                             VisType = a.VisType,
                             Viscustomer = a.Viscustomer,
                             Name = zz.Name,
                             Jtype = a.Jtype,
                             Jdr = a.Jdr,
                             //ShengName = g.Name + "-" + h.Name + "-" + i.Name,
                             VisTypeName = bzzzzz.Comments,
                             JtypeName = czzzzz.Comments,
                             ZwName = dzzzzz.Comments,
                             YxName = ezzzzz.Comments,
                             JyName = fzzzzz.Comments,
                             Zw = a.Zw,
                             Talk = a.Talk,
                             Khfk = a.Khfk,
                             Yx = a.Yx,

                             Jy = a.Jy,
                             Creater = a.Creater,
                             Createtime = a.Createtime,
                             CreaterName = zzzzz.UserName,
                             RecStatus = a.RecStatus,
                             Modifier = a.Modifier,
                             Modifytime = a.Modifytime,
                             VistimeName = a.Vistime.ToString("yyyy-MM-dd"),
                         }
                ).OrderByDescending(x => x.Vistime).ToList();



            //if (searchEntity.totalrows == 0)
                searchEntity.totalrows = query.Count();
            var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
            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.CooperVisits.Find(id);
            if (model != null)
            {
                model.RecStatus = "D";
                model.Modifier = userid;
                model.Modifytime = DateTime.Now;
                _context.SaveChanges();
            }

            return result;
        }

        /// <summary>
        /// 获取所有有效合作客户
        /// </summary>
        /// <returns></returns>
        public List<CooperatecustomCustomerDTO> GetList(string[] id=null)
        {
            List<CooperatecustomCustomerDTO> result = new List<CooperatecustomCustomerDTO>();
            if (id != null)
            {
               // var listCooperVisits = _context.CooperVisits.Where(r => id.Contains(r.Id) && r.RecStatus == "A").Select(x => x.Viscustomer).ToList();

                var listCooperatecustomCustomers = _context.CooperatecustomCustomers.Where(r => id.Contains(r.Id) && r.RecStatus == "A").ToList();

                result = _mapper.Map<List<CooperatecustomCustomerDTO>>(listCooperatecustomCustomers);
            }
            else
            {
                var listCooperatecustomCustomers = _context.CooperatecustomCustomers.ToList();

                result = _mapper.Map<List<CooperatecustomCustomerDTO>>(listCooperatecustomCustomers);
            }




            return result;
        }

        public List<CooperVisitDTO> GetListsalary(string userid, DateTime datemin, DateTime datemax)
        {
            
            
                // var listCooperVisits = _context.CooperVisits.Where(r => id.Contains(r.Id) && r.RecStatus == "A").Select(x => x.Viscustomer).ToList();

                var listCooperatecustomCustomers = _context.CooperVisits.Where(r =>  r.RecStatus == "A"&& r.Creater == userid && r.Vistime >= datemin && r.Vistime < datemax).ToList();

               var result = _mapper.Map<List<CooperVisitDTO>>(listCooperatecustomCustomers);
             




            return result;
        }
    }
}