using AutoMapper;
using DTO;
using IServices;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using zhengcaioa.Models;

namespace Services
{
    public class SimService :ISimService
    {
        private readonly zhengcaioaContext _context;
        private readonly IMapper _mapper;
        public SimService(zhengcaioaContext context, IMapper mapper)
        {
            _context = context;
            _mapper = mapper;
        }

        #region SIM 分配

        /// <summary>
        /// 保存
        /// </summary>
        /// <param name="md"></param>
        /// <returns></returns>
        public ResultEntity Save(SimBind md)
        {
            ResultEntity resultEntity = new ResultEntity();
            try
            {
                var temp = _context.SimBind.Where(e => e.sim_id == md.sim_id).SingleOrDefault();
                if(temp!=null)
                {
                    var users = _context.SimBind.Where(c => c.user_id == md.user_id).ToList();
                    if(users!=null)
                    {
                        foreach(var item in users)
                        {
                            item.user_id = "";
                            item.up_time = DateTime.Now;
                            item.up_user = md.up_user;
                        }
                    }
                    temp.cardpro = md.cardpro;
                    temp.user_id = md.user_id;
                    temp.up_user = md.up_user;
                    temp.up_time = DateTime.Now;
                }
                else
                {
                    md.up_time = DateTime.Now;
                    _context.SimBind.Add(md);
                }               
                _context.SaveChanges();
                resultEntity.Result = true;
            }
            catch (Exception ex)
            {
                resultEntity.Result = false;
                resultEntity.Message = "保存失败，请联系管理员";
                ex.Message.ToString();
            }
            return resultEntity;
        }

        /// <summary>
        /// 解绑
        /// </summary>
        /// <param name="ids"></param>
        /// <returns></returns>
        public ResultEntity UnBind(string ids,string user)
        {
            ResultEntity resultEntity = new ResultEntity();
            try
            {
                var temp = _context.SimBind.Where(e =>ids.Contains(e.sim_id)).ToList();
                if (temp != null)
                {
                    foreach (var item in temp)
                    {
                        item.user_id = "";
                        item.up_time = DateTime.Now;
                        item.up_user = user;
                    }
                }
                _context.SaveChanges();
                resultEntity.Result = true;
            }
            catch (Exception ex)
            {
                resultEntity.Result = false;
                resultEntity.Message = "保存失败，请联系管理员";
                ex.Message.ToString();
            }
            return resultEntity;
        }

        /// <summary>
        /// 绑定信息查询
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public SimBindView Get(string id)
        {
            var entity = _context.SimBindView.Where(c=>c.Id==id).SingleOrDefault();
            if (entity == null)
            {
                entity = new SimBindView();
            }
            return entity;
        }

        /// <summary>
        /// 查询内容
        /// </summary>
        /// <param name="searchEntity"></param>
        /// <returns></returns>
        public ResultDataEntity<SimBindView> SearchByPaging(SimBindDTOSearch searchEntity)
        {
            ResultDataEntity<SimBindView> data = new ResultDataEntity<SimBindView>();
            try
            {
                var codedata= (from e in _context.SysCodes
                 join c in _context.SysCodeDtls
                 on e.Id equals c.CodeId
                 where e.RecStatus == "A"
                 && c.RecStatus == "A"
                 && e.CodeTable == "t_sim_bind"
                 && e.CodeField == "cardpro"
                               select c).OrderBy(x => x.Sort).ToList();

                var dt = _context.SimBindView.OrderBy(c => c.simcard).ToList();                
                if(!string.IsNullOrEmpty(searchEntity.simcard))
                {
                    dt = dt.Where(c => c.simcard.Contains(searchEntity.simcard)).ToList();
                }
                if (!string.IsNullOrEmpty(searchEntity.username))
                {
                    dt = dt.Where(c => !string.IsNullOrEmpty(c.username) && c.username.Contains(searchEntity.username)).ToList();
                }

                //if (searchEntity.totalrows == 0)
                    searchEntity.totalrows = dt.Count();

                var signinList = dt.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();

               signinList= signinList.Select(a=> new SimBindView()
               {
                   cardproChs = ToChs(a.cardpro, codedata),
                   Id = a.Id,
                   simcard = a.simcard,
                   simstatus = a.simstatus,
                   up_time = a.up_time,
                   username = a.username
               }).ToList();

                data.LoadData(searchEntity, signinList);
            }
            catch (Exception ex)
            {
                throw;
            }
            return data;
        }

        private string ToChs(string key,List<SysCodeDtl> list)
        {
            string str = "";
            var item = list.Find(c => c.CodeSn == key);
            if(item!=null)
            {
                str = item.Comments;
            }
            return str;
        }

        #endregion

        #region 费用录入

        /// <summary>
        /// 获取已绑定的电话卡
        /// </summary>
        /// <returns></returns>
        public List<SimBindView> GetBindSim()
        {
            List<SimBindView> list = null;
            try
            {
                list = _context.SimBindView.Where(c=>!string.IsNullOrEmpty(c.userid)).OrderBy(c => c.simcard).ToList();
            }
            catch (Exception er)
            {
                throw;
            }
            return list;
        }

        /// <summary>
        /// 保存
        /// </summary>
        /// <param name="md"></param>
        /// <returns></returns>
        public ResultEntity SaveCost(SimCost md)
        {
            ResultEntity resultEntity = new ResultEntity();
            try
            {
                var temp = _context.SimCost.Where(e => e.sim_id == md.sim_id && e.bill_year==md.bill_year && e.bill_month==md.bill_month).SingleOrDefault();
                var tempBind = _context.SimBindView.Where(e => e.Id == md.sim_id).SingleOrDefault();                
                if (temp != null && temp.status=="0")
                {                    
                    temp.bill_amount = md.bill_amount;
                    //temp.bill_month =md.m;
                    //temp.bill_year = md.accounted_time.Year;
                    temp.sub_userid = md.sub_userid;                    
                    temp.up_time = DateTime.Now;
                    if(tempBind!=null)
                    {
                        temp.allow_amount = decimal.Parse(tempBind.cardpro);
                        temp.user_id = tempBind.userid;
                        temp.amount = temp.allow_amount - temp.bill_amount > 0 ? 0 : temp.allow_amount - temp.bill_amount;
                    }
                }
                else
                {
                    //md.bill_month = md.accounted_time.Month;
                    //md.bill_year = md.accounted_time.Year;

                    //当月重复判断
                    //var monthck = _context.SimCost.Where(c => c.sim_id == md.sim_id && c.bill_year == md.bill_year && c.bill_month == md.bill_month).Count();
                    //if(monthck>0)
                    //{
                    //    resultEntity.Result = false;
                    //    resultEntity.Message = string.Format("此电话卡在[{0}-{1}]月已存在记录，不能重复添加；",md.bill_year,md.bill_month);
                    //    return resultEntity;
                    //}
                    //else
                    {
                        md.up_time = DateTime.Now;
                        md.status = "0";
                        md.accounted_time = DateTime.Now;
                        if (tempBind != null)
                        {
                            md.allow_amount = decimal.Parse(tempBind.cardpro);
                            md.amount = md.allow_amount - md.bill_amount > 0 ? 0 : md.allow_amount - md.bill_amount;
                            md.user_id = tempBind.userid;
                        }
                        _context.SimCost.Add(md);
                    }                    
                }
                _context.SaveChanges();
                resultEntity.Result = true;
            }
            catch (Exception ex)
            {
                resultEntity.Result = false;
                resultEntity.Message = "保存失败，请联系管理员";
                ex.Message.ToString();
            }
            return resultEntity;
        }

        /// <summary>
        /// 绑定信息查询
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public SimCost GetSimCost(int id)
        {
            var entity = _context.SimCost.Where(c => c.id == id).SingleOrDefault();
            if (entity == null)
            {
                entity = new SimCost();
            }
            return entity;
        }

        /// <summary>
        /// 查询内容
        /// </summary>
        /// <param name="searchEntity"></param>
        /// <returns></returns>
        public List<SimCostView> SearchSimCostByPage(string sim ,int year)
        {
            List<SimCostView> data = new List<SimCostView>();
            try
            {
                //var codedata = (from e in _context.SysCodes
                //                join c in _context.SysCodeDtls
                //                on e.Id equals c.CodeId
                //                where e.RecStatus == "A"
                //                && c.RecStatus == "A"
                //                && e.CodeTable == "t_sim_bind"
                //                && e.CodeField == "cardpro"
                //                select c).OrderBy(x => x.Sort).ToList();

                data = _context.SimCostView.Where(c => c.bill_year==year && c.sim_id==sim).OrderBy(c=>c.bill_month).ToList();
                //if (!string.IsNullOrEmpty(searchEntity.searchtime))
                //{
                //    var times = searchEntity.searchtime.Split('|');
                //    if(times.Length==2)
                //    {
                //        DateTime d1 = DateTime.Parse(times[0]);
                //        DateTime d2 = DateTime.Parse(times[1]);
                //        dt = dt.Where(c => c.accounted_time > d1 && c.accounted_time < d2).ToList();
                //    }                    
                //}
                //if (!string.IsNullOrEmpty(searchEntity.searchsim))
                //{
                //    dt = dt.Where(c => !string.IsNullOrEmpty(c.simcard) && c.simcard.Contains(searchEntity.searchsim)).ToList();
                //}
                //SimCostDTOSearch searchEntity = new SimCostDTOSearch();
                //searchEntity.rows = 20;
                //searchEntity.page = 1;

                //if (searchEntity.totalrows == 0)
                //    searchEntity.totalrows = dt.Count();

                //var signinList = dt.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();

                //signinList = signinList.Select(a => new SimBindView()
                //{
                //    cardproChs = ToChs(a.cardpro, codedata),
                //    Id = a.Id,
                //    simcard = a.simcard,
                //    simstatus = a.simstatus,
                //    up_time = a.up_time,
                //    username = a.username
                //}).ToList();

                //data.LoadData(searchEntity, signinList);
            }
            catch (Exception ex)
            {
                throw;
            }
            return data;
        }

        /// <summary>
        /// 查询费用记录
        /// </summary>
        /// <param name="userid"></param>
        /// <param name="bill_year"></param>
        /// <param name="bill_month"></param>
        /// <returns></returns>
        public SimCostView GetSimCost(string userid, int bill_year, int bill_month)
        {

            var entity = _context.SimCostView.Where(x => x.user_id == userid && x.bill_year == bill_year && x.bill_month  == bill_month).FirstOrDefault();
            


            return entity;
        }

        /// <summary>
        /// 查询内容
        /// </summary>
        /// <param name="searchEntity"></param>
        /// <returns></returns>
        public ResultDataEntity<SimCostYearView> SearchSimCostYearByPage(SimCostDTOSearch searchEntity)
        {
            ResultDataEntity<SimCostYearView> data = new ResultDataEntity<SimCostYearView>();
            try
            {
                int year=DateTime.Now.Year;
                if (!string.IsNullOrEmpty(searchEntity.searchtime))
                {
                    year = int.Parse(searchEntity.searchtime);
                }
                
                var dt = (from c in _context.SimCostYearView where c.bill_year==year select c).ToList();
                //添加未有记录的
                var stringId = dt.Select(c => c.sim_id).ToList();
                var nolog = (from c in _context.SimBindView where !stringId.Contains(c.Id) select c).ToList();
                foreach(var item in nolog)
                {
                    SimCostYearView ss = new SimCostYearView();
                    ss.bill_year = year;
                    ss.sim_id = item.Id;
                    ss.sim = item.simcard;
                    dt.Add(ss);
                }
                dt = dt.OrderBy(c => c.sim).ToList();

                if (!string.IsNullOrEmpty(searchEntity.searchsim))
                {
                    dt = dt.Where(c => c.sim==searchEntity.searchsim).ToList();
                }

                //if (searchEntity.totalrows == 0)
                    searchEntity.totalrows = dt.Count();

                var signinList = dt.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
                if(signinList.Count>0)
                {
                    var month = DateTime.Now.Month-1;
                    var ck = (from c in _context.SimCost where c.status == "1" && c.bill_year == year orderby c.bill_month descending select c).FirstOrDefault();
                    if(ck!=null)
                    {
                        month= ck.bill_month;                        
                    }
                    foreach (var item in signinList)
                    {
                        item.month = month;
                    }
                }

                data.LoadData(searchEntity, signinList);
            }
            catch (Exception ex)
            {
                throw;
            }
            return data;
        }

        #endregion
    }
}