using cylsg.Model.ECTEModel;
using cylsg.Model.utilityViewModel;
using cylsg.utility.Extend;
using ECTESTOA;
using Furion.LinqBuilder;
using Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Expressions;
using System.Text;
using System.Threading.Tasks;

namespace cylsg.Application.CyOS
{
    /// <summary>
    /// 川印报销经理API
    /// </summary>
    [Authorize]
    [ApiDescriptionSettings("CYOA")]
    public class CyOSBaoXiaoJingLiController: IDynamicApiController
    {
        private readonly IOAServices _OAServices;
        private readonly ISqlSugarClient _SugarClient;
        private ECTESTOAPermissions Permissions;
        public CyOSBaoXiaoJingLiController(IOAServices oaservices, ISqlSugarClient sugarClient)
        {
            _OAServices = oaservices;
            _SugarClient = sugarClient.AsTenant().GetConnection("ECTESTOADB");
        }


        /// <summary>
        ///  查询
        /// </summary>
        [HttpPost]
        public async Task<WorekPlandto> getplanelist(SearchOaWorekPlan param)
        {
            if (!await CheckRols())
            {
                throw Oops.Oh("没有权限");
            }

            Expression<Func<OaWorkPlan, bool>> SearchList = (x) => true;

            //川印工作单
            SearchList = SearchList.And(x => x.ApprovalStatus != PlanStatusType.Uncommitted);
            SearchList = SearchList.And(x => x.MemberId == _OAServices.firmId);
            SearchList = SearchList.And(x => x.PlanType == 3);
            SearchList = SearchList.And(x => x.PlanDataType == 17);
            //必须有两个人审批过了
            SearchList = SearchList.And(x => x.OaWorkPlanShenpis.Count(y=>y.Buzhou==1)>1||(x.ApprovalStatus!= PlanStatusType.unApproval));
            if (!string.IsNullOrEmpty(param.StaffName))
            {
                SearchList = SearchList.And(x => x.SentStaff.Name.Contains(param.StaffName));
            }
            if (param.StaffMemberIdId != null)
            {
                SearchList = SearchList.And(x => x.MemberId == param.StaffMemberIdId);
            }
            if (param.PlanDataType > 0)
            {
                SearchList = SearchList.And(x => x.PlanDataType == param.PlanDataType);
            }
            if (param.PlanStartTimeStart != null)
            {
                SearchList = SearchList.And(x => x.PlanStartTime >param.PlanStartTimeStart);
            }
            if (param.PlanStartTimeEnd != null)
            {
                SearchList = SearchList.And(x => x.PlanStartTime <= param.PlanStartTimeEnd.Value.AddDays(1));
            }
            //审批状态
            if (param.ApprovalStatus != null)
            {
               
                    SearchList = SearchList.And(x => x.ApprovalStatus == param.ApprovalStatus);
               

            }

            //报销状态
            if (param.EvaluationStatus != null)
            {
                SearchList = SearchList.And(x => x.EvaluationStatus == param.EvaluationStatus);
            }
            //强制增加员工过滤
            RefAsync<int> totle = 0;
            var data = await _SugarClient.Queryable<OaWorkPlan>().Includes(x => x.OaWorkPlanShenpis.Where(y=>y.Buzhou==1).ToList()).Includes(x => x.Depart)
                .Where(SearchList).OrderByDescending(x => x.PlanStartTime).ToPageListAsync(param.page.PageIndex, param.page.PageSize, totle);


            var sum = await _SugarClient.Queryable<OaWorkPlan>()
                .Where(SearchList).SumAsync(x=>x.PlanMoney);
            param.page.TotalCount = totle;
            return new WorekPlandto

            {
                list = data,
                page = param.page,
                TotalMoney = sum ?? 0
            };


        }

        /// <summary>
        ///  获取报销单详情
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        [HttpGet]
        public async Task<OaWorkPlan> GetPlanInfo(int id)
        {
            if (!await CheckRols())
            {
                throw Oops.Oh("没有权限");
            }
            return await _SugarClient.Queryable<OaWorkPlan>().Includes(x=>x.OaWorkPlanShenpis,y=>y.ApprovalStaff).Includes(x=>x.SentStaff).Includes(x=>x.Depart).Includes(x=>x.WorkPlanAttachments).Where(x => x.Keyid == id).FirstAsync();
        }

        /// <summary>
        /// 审批权限
        /// </summary>       
        /// <returns></returns>
        [HttpPost]
        public async Task<bool> BaoxiaoPlan(OaWorkPlanShenpi param)
        {
            if (param.ApprovalStatus == PlanStatusType.unApproval)
                throw Oops.Oh("不可设置为未审批状态");

            if (!await CheckRols())
            {
                throw Oops.Oh("没有权限");
            }
            var data = await _SugarClient.Queryable<OaWorkPlan>().Includes(x => x.OaWorkPlanShenpis).Where(x => x.Keyid == param.OA_WorkPlanId).FirstAsync();
            if (data == null)
                throw Oops.Oh("没有找到报销单");
            if ( data.ApprovalStatus != PlanStatusType.unApproval)
                throw Oops.Oh("报销单已经批复完毕");
            if (data.ApprovalStatus == PlanStatusType.Uncommitted)
            {
                throw Oops.Oh("报销单未提交不可审批");
            }
            OaWorkPlanShenpi shenpi = data.OaWorkPlanShenpis.Where(x => x.ApprovalStaffId == Permissions.MemberId&&x.Buzhou==2).FirstOrDefault();
            await _SugarClient.AsTenant().BeginTranAsync();
            try
            {
                if (shenpi != null)
                {
                    //已经批复
                    throw Oops.Oh("报销单已经批复完毕 不可更改");
                    //shenpi.ApprovalStatus = param.ApprovalStatus;
                    //shenpi.Buzhou = 2;
                    //shenpi.ApprovalTime = DateTime.Now;
                    //shenpi.ApprovalContent = param.ApprovalContent;

                    //await _SugarClient.Updateable(shenpi).ExecuteCommandAsync();

                }
                else
                {
                    shenpi = new OaWorkPlanShenpi()
                    {
                        ApprovalStaffId = Permissions.MemberId,
                        ApprovalContent = param.ApprovalContent,
                        ApprovalStatus = param.ApprovalStatus,
                        ApprovalTime = DateTime.Now,
                        ///总经理审批为2
                        Buzhou = 2,
                        CreateTime = DateTime.Now,
                        Operator = Permissions.Name,
                        OA_WorkPlanId = param.OA_WorkPlanId,

                    };
                    await _SugarClient.Insertable(shenpi).ExecuteCommandAsync();
                }
                if(!(param.RewardResult?.isPureNum()==true))
                {
                    throw Oops.Oh("科目选择错误");
                }
                //审批时可修改内容
                data.RewardResult = param.RewardResult;
                data.PlanContent = param.PlanContent;
                if(param.PlanMoney>0&&param.PlanMoney<=data.PlanMoney)
                data.PlanMoney = param.PlanMoney;



                data.ApprovalTime = DateTime.Now;
                data.ApprovalStatus = param.ApprovalStatus;
                data.ApprovalContent = param.ApprovalContent;
                data.LastUpdateTime = DateTime.Now;




                await _SugarClient.Updateable(data).ExecuteCommandAsync();
                await _SugarClient.AsTenant().CommitTranAsync();
                return true;
            }
            catch (Exception e)
            {

                await _SugarClient.AsTenant().RollbackTranAsync();
                throw;
            }

        }

        /// <summary>
        /// 批量审批
        /// </summary>
        [HttpPost]
        public async Task<bool> BatchShenPi(BatchShenPiIn param)
        {
            if (param.ApprovalStatus == PlanStatusType.unApproval)
                throw Oops.Oh("不可设置为未审批状态");
            if (!param.OA_WorkPlanIds.Any())
                throw Oops.Oh("未选中任何报销单");
            if (!await CheckRols())
            {
                throw Oops.Oh("没有权限");
            }
          
            var dataList = await _SugarClient.Queryable<OaWorkPlan>().Includes(x => x.OaWorkPlanShenpis).In(param.OA_WorkPlanIds).ToListAsync();
            if (dataList == null||dataList.Count==0)
                throw Oops.Oh("没有找到报销单");
            try
            {
                await _SugarClient.AsTenant().BeginTranAsync();
                foreach (var item in dataList)
                {
                    if (item.ApprovalStatus != PlanStatusType.unApproval)
                    {
                        await _SugarClient.AsTenant().RollbackTranAsync();
                        throw Oops.Oh($"{item.SentStaff.Name} 的报销单:{item.PlanContent}---已经批复完毕，终止本次操作");
                    }
                    if (item.ApprovalStatus == PlanStatusType.Uncommitted)
                    {
                        await _SugarClient.AsTenant().RollbackTranAsync();
                        throw Oops.Oh($"{item.SentStaff.Name} 的报销单:{item.PlanContent}---已经未提交或者未完成前置审批，终止本次操作");
                    }
                   if( item.OaWorkPlanShenpis.Where(x=>x.Buzhou == 1&&x.ApprovalStatus== PlanStatusType.Yes).Count()<2)
                    {
                        await _SugarClient.AsTenant().RollbackTranAsync();
                        throw Oops.Oh($"{item.SentStaff.Name} 的报销单:{item.PlanContent}---未完成前置审批，终止本次操作");
                    }
                    OaWorkPlanShenpi shenpi = item.OaWorkPlanShenpis.Where(x => x.ApprovalStaffId == Permissions.MemberId && x.Buzhou == 2).FirstOrDefault();
                    if (shenpi != null)
                    {
                        await _SugarClient.AsTenant().RollbackTranAsync();
                        //已经批复
                        throw Oops.Oh($"{item.SentStaff.Name} 的报销单:{item.PlanContent} ----报销单已经批复完毕 不可更改,操作终止");
                     

                    }
                    else
                    {
                        shenpi = new OaWorkPlanShenpi()
                        {
                            ApprovalStaffId = Permissions.MemberId,
                            ApprovalContent = param.ApprovalContent,
                            ApprovalStatus = param.ApprovalStatus,
                            ApprovalTime = DateTime.Now,
                            //总经理审批为2
                            Buzhou = 2,
                            CreateTime = DateTime.Now,
                            Operator = Permissions.Name,
                            OA_WorkPlanId = item.Keyid,

                        };
                        await _SugarClient.Insertable(shenpi).ExecuteCommandAsync();
                    }

                    //审批时可修改内容
                 
                  



                    item.ApprovalTime = DateTime.Now;
                    item.ApprovalStatus = param.ApprovalStatus;
                    item.ApprovalContent = param.ApprovalContent;
                    item.LastUpdateTime = DateTime.Now;




                    await _SugarClient.Updateable(item).ExecuteCommandAsync();
                   
                }
                await _SugarClient.AsTenant().CommitTranAsync();
                return true;
            }
            catch (Exception)
            {
                await _SugarClient.AsTenant().RollbackTranAsync();
                throw;
            }
           
           

        }

        /// <summary>
        /// 判断是否具有权限
        /// </summary>
        /// <returns></returns>
        private async Task<bool> CheckRols()
        {
            var pr = await _OAServices.GetOAPermissions();
            Permissions = pr;
            if (pr != null && pr.MemberId != null)
            {

                if (pr.BF_Isbaoxiaojingli)
                    return true;
                else return false;

            }
            else
                return false;
        }
    }
    /// <summary>
    /// 批量审批参数
    /// </summary>
    public class BatchShenPiIn
    {
        /// <summary>
        /// 工作计划ID 报销单ID
        /// </summary>
        [Required]
        public int[] OA_WorkPlanIds { get; set; }

        /// <summary>
        /// 审批状态
        /// </summary>       
        [Required]
        public PlanStatusType? ApprovalStatus { get; set; }       

        /// <summary>
        /// 审批内容
        /// </summary>       
        public string ApprovalContent { get; set; }
    }
}