using cylsg.Application.Orders.Dtos;
using cylsg.Application.Users.Dtos;
using cylsg.Core;
using cylsg.Model.OrderModel;
using cylsg.Model.UserModel;
using Furion.LinqBuilder;
using MapsterMapper;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Expressions;
using System.Security.Claims;
using System.Text;
using System.Threading.Tasks;
using static SKIT.FlurlHttpClient.Wechat.Api.Models.CgibinAccountGetAccountBasicInfoResponse.Types;

namespace cylsg.Application.Orders
{
    /// <summary>
    /// 订单公司接口
    /// </summary>
    public class OrderCompanyAppService : IDynamicApiController
    {
        private readonly ISystemService _systemService;
        private ISqlSugarClient _sqlSugarClient;
        private IMapper _mapper;
        public OrderCompanyAppService(ISystemService systemService, ISqlSugarClient sqlSugarClient, IMapper mapper)
        {
            _systemService = systemService;
            _sqlSugarClient = sqlSugarClient;
            _mapper = mapper;
        }


        /// <summary>
        /// 查询公司已经发布的招工订单
        /// </summary>
        /// <param name="page"></param>
        /// <returns></returns>
        [Authorize]
        [HttpPost]
        public async Task<PageResult<OrderDto>> PostMyListPage(OrderPageSearch page)
        {
            var UserID = App.User?.FindFirstValue("UserID");
            int userid = 0;
            if (!string.IsNullOrEmpty(UserID))
            {
                userid = int.Parse(UserID);
            }

            PageResult<OrderDto> result = new PageResult<OrderDto>();
            var orderRepository = new BaseRepository<Order>();
            var userCompanyRes = new BaseRepository<UserCompany>();

            //查询公司的所有员工的所有招工订单
            var userCompany = await userCompanyRes.GetFirstAsync(x => x.UserId == userid && x.IsEn == true && x.IsDeleted == false);
            if (userCompany == null)
            {
                throw Oops.Oh("你没有公司！");
            }
            var userCompanies = await userCompanyRes.GetListAsync(x => x.Suppliercode == userCompany.Suppliercode && x.IsEn == true && x.IsDeleted == false);
            var userids = userCompanies.Select(x => x.UserId).ToList();

            Expression<Func<Order, bool>> expression = t => true;

            expression = expression.And(t => t.IsDeleted == false /*&& t.IsEn == true*/
            && userids.Contains(t.OrderUserId)); //t.OrderUserId == userid

            if (!string.IsNullOrEmpty(page.OrderName))
            {
                expression = expression.And(t => t.OrderName.Contains(page.OrderName));
            }
            if (page.WordStartTime.HasValue)
            {
                expression = expression.And(t => t.WordStartTime >= page.WordStartTime);
            }
            if (page.WordEndTime.HasValue)
            {
                expression = expression.And(t => t.WordStartTime <= page.WordEndTime);
            }
            if (page.IsEn.HasValue)
            {
                expression = expression.And(t => t.IsEn == page.IsEn);
            }
            

            RefAsync<int> total = 0;


            var orderBiddingRepository = new BaseRepository<OrderBidding>();

            var data = await orderRepository.Context.Queryable<Order>()
                    .Where(expression)
                    .OrderByDescending(c => c.WordStartTime)
                    .ToPageListAsync(page.PageIndex, page.PageSize, total);
            var datadto = _mapper.Map<List<OrderDto>>(data);

            if (datadto != null && datadto.Count > 0)
            {
                foreach (var orderDto in datadto)
                {
                    switch (orderDto.OrderStatus)
                    {
                        case (int)OrderStatuses.fabu: orderDto.OrderStatusName = "发布"; break;
                        case (int)OrderStatuses.zhaogongwanbi: orderDto.OrderStatusName = "招工完毕"; break;
                        case (int)OrderStatuses.jiesuanwanbi: orderDto.OrderStatusName = "结算完毕"; break;
                        default: break;
                    }

                    var orderBiddings = await orderBiddingRepository.CountAsync(x => x.OrderId == orderDto.Id && x.IsSelected == true && x.IsEn == true && x.IsDeleted == false);
                    orderDto.WorderCounted = orderBiddings;

                }

            }
            result.Items = datadto;
            result.PageIndex = page.PageIndex;
            result.PageSize = page.PageSize;
            result.TotalCount = total;

            return result;
        }


        /// <summary>
        /// 保存招工信息（新增/修改）
        /// </summary>
        /// <returns></returns>
        [Authorize]
        [HttpPost]
        public async Task<bool> saveOrder(OrderDto orderDto)
        {

            var UserID = App.User?.FindFirstValue("UserID");
            int userid = 0;
            string NickName = App.User?.FindFirstValue("NickName");
            if (!string.IsNullOrEmpty(UserID))
            {
                userid = int.Parse(UserID);
            }


            if (!string.IsNullOrEmpty(orderDto.OrderName) && orderDto.OrderName.Length > 100)
            {
                throw Oops.Oh("招工名称长度过长！");
            }
            if (!string.IsNullOrEmpty(orderDto.Demand) && orderDto.Demand.Length > 2000)
            {
                throw Oops.Oh("需求长度过长！");
            }
            if (!string.IsNullOrEmpty(orderDto.WorderAddress) && orderDto.WorderAddress.Length > 500)
            {
                throw Oops.Oh("工作地点长度过长！");
            }
            if (!string.IsNullOrEmpty(orderDto.ContactPhone) && orderDto.ContactPhone.Length > 30)
            {
                throw Oops.Oh("联系电话长度过长！");
            }

            var userCompanyRes = new BaseRepository<UserCompany>();
            var userCompany = await userCompanyRes.GetFirstAsync(p => p.UserId == userid && p.IsEn == true && p.IsDeleted == false);
            if (userCompany == null || string.IsNullOrEmpty(userCompany.BusinessLicense))
            {
                throw Oops.Oh("请先完成公司认证才能发布招工！");
            }

            var orderRes = new BaseRepository<Order>();
            bool res;
            if (!orderDto.Zixinganpai.HasValue)
            {
                orderDto.Zixinganpai = false;
            }
            if (orderDto.Id > 0)
            {
                var order = await orderRes.GetByIdAsync(orderDto.Id);
                if (order.OrderStatus > 0 && order.IsEn == true)
                {
                    throw Oops.Oh("招工已经结束不能修改！");
                }
                var orderBiddingRes = new BaseRepository<OrderBidding>();
                var count = await orderBiddingRes.CountAsync(x=>x.OrderId == orderDto.Id && x.IsEn == true && x.IsDeleted == true && x.IsSelected == true);
                if (count > 0 && order.IsEn == true)
                {
                    throw Oops.Oh("已经确认招工人员，不能修改！");
                }


                if (order.IsEn == false)
                {
                    var orderBiddings = await orderBiddingRes.GetListAsync(x => x.OrderId == orderDto.Id);
                    foreach (var orderBidding in orderBiddings)
                    {
                        res = await orderBiddingRes.DeleteByIdAsync(orderBidding.Id);
                    }
                }

                order.OrderName = orderDto.OrderName;
                order.WordStartTime = orderDto.WordStartTime;
                order.WordEndTime = orderDto.WordEndTime;
                order.StartTime = orderDto.StartTime;
                order.EndTime = orderDto.EndTime;
                order.Demand = orderDto.Demand;
                order.WorderCount = orderDto.WorderCount;
                order.WorderAddress = orderDto.WorderAddress;
                order.ContactPhone = orderDto.ContactPhone;
                order.WorkerType = orderDto.WorkerType;
                order.WorkPrice = orderDto.WorkPrice;
                order.OrderStatus = 0;
                order.IsEn = true;
                order.UpDataBy = NickName;
                order.UpDataTime = DateTime.Now;
                res = await orderRes.UpdateAsync(order);


                
                   

            }
            else
            {
                var order = _mapper.Map<Order>(orderDto);
                order.UpDataBy = NickName;
                order.UpDataTime = DateTime.Now;
                order.CreateBy = NickName;
                order.CreateTime = DateTime.Now;
                order.OrderStatus = 0;
                order.OrderUserId = userid;
                order.IsEn = true;
                res = await orderRes.InsertAsync(order);
            }







            return res;
        }



        /// <summary>
        /// 公司选择工人
        /// </summary>
        /// <returns></returns>
        [Authorize]
        [HttpPost]
        public async Task<bool> saveQueRen(QueRenDto queRenDto)
        {

            var UserID = App.User?.FindFirstValue("UserID");
            int userid = 0;
            string NickName = App.User?.FindFirstValue("NickName");
            if (!string.IsNullOrEmpty(UserID))
            {
                userid = int.Parse(UserID);
            }

            var orderBiddingRes = new BaseRepository<OrderBidding>();
            var orderRes = new BaseRepository<Order>();

            var orderBidding = await orderBiddingRes.GetByIdAsync(queRenDto.OrderBiddingId);
            if (orderBidding == null || orderBidding.IsEn != true || orderBidding.IsDeleted == true )
            {
                throw Oops.Oh("该投递已经无效！");
            }
            if(orderBidding.IsSelected == true)
            {
                throw Oops.Oh("该投递已经确认，不能重复确认！");
            }

            var order = await orderRes.GetByIdAsync(orderBidding.OrderId);
            if (order == null || order.OrderStatus > 0)
            {
                throw Oops.Oh("该招工状态已经无法投递！");
            }

            var orderBiddings = await orderBiddingRes.CountAsync(x => x.OrderId == orderBidding.OrderId && x.IsSelected == true && x.IsDeleted == false && x.IsEn == true);
            if (orderBiddings >= order.WorderCount)
            {
                throw Oops.Oh("招工人数已经满了，不能报名！");
            }



            bool res;

            orderBidding.IsSelected = true;
            orderBidding.Selectedtime = DateTime.Now;
            orderBidding.UpDataBy = NickName;
            orderBidding.UpDataTime = DateTime.Now;


            res = await orderBiddingRes.UpdateAsync(orderBidding);

            if(order.WorderCount == (orderBiddings + 1))
            {
                order.OrderStatus = 1;
                res = await orderRes.UpdateAsync(order);
            }

            return res;
        }



        /// <summary>
        /// 公司不录用一个工人
        /// </summary>
        /// <returns></returns>
        [Authorize]
        [HttpPost]
        public async Task<bool> saveBuLuYong(QueRenDto queRenDto)
        {

            var UserID = App.User?.FindFirstValue("UserID");
            int userid = 0;
            string NickName = App.User?.FindFirstValue("NickName");
            if (!string.IsNullOrEmpty(UserID))
            {
                userid = int.Parse(UserID);
            }

            var orderBiddingRes = new BaseRepository<OrderBidding>();
            var orderRes = new BaseRepository<Order>();

            var orderBidding = await orderBiddingRes.GetByIdAsync(queRenDto.OrderBiddingId);
            if (orderBidding == null || orderBidding.IsEn != true || orderBidding.IsDeleted == true)
            {
                throw Oops.Oh("该投递已经无效！");
            }
            if (orderBidding.IsSelected == true)
            {
                throw Oops.Oh("该投递已经审核，不能不录用！");
            }

            var order = await orderRes.GetByIdAsync(orderBidding.OrderId);
            if (order == null || order.OrderStatus > 0)
            {
                throw Oops.Oh("该招工状态已经无法投递！");
            }

 



            bool res;

            orderBidding.IsSelected = false;
            //orderBidding.Selectedtime = DateTime.Now;
            orderBidding.UpDataBy = NickName;
            orderBidding.UpDataTime = DateTime.Now;


            res = await orderBiddingRes.UpdateAsync(orderBidding);

         

            return res;
        }



        /// <summary>
        /// 公司取消选择工人
        /// </summary>
        /// <returns></returns>
        [Authorize]
        [HttpPost]
        public async Task<bool> saveQuXiao(QueRenDto queRenDto)
        {

            var UserID = App.User?.FindFirstValue("UserID");
            int userid = 0;
            string NickName = App.User?.FindFirstValue("NickName");
            if (!string.IsNullOrEmpty(UserID))
            {
                userid = int.Parse(UserID);
            }

            var orderBiddingRes = new BaseRepository<OrderBidding>();
            var orderRes = new BaseRepository<Order>();
            var orderBiddingDetailRes = new BaseRepository<OrderBiddingDetail>();

            var orderBidding = await orderBiddingRes.GetByIdAsync(queRenDto.OrderBiddingId);
            if (orderBidding == null || orderBidding.IsEn != true || orderBidding.IsDeleted == true)
            {
                throw Oops.Oh("该投递已经无效！");
            }
            if (orderBidding.IsSelected != true)
            {
                throw Oops.Oh("该投递没有确认，不能取消！");
            }

            var count = await orderBiddingDetailRes.CountAsync(x => x.OrderBiddingId == orderBidding.Id && x.IsEn == true && x.IsDeleted == false);
            if (count>0)
            {
                throw Oops.Oh("该工人已有打卡信息，不能取消招工！");
            }

            var order = await orderRes.GetByIdAsync(orderBidding.OrderId);



            bool res;

            orderBidding.IsSelected = null;
            orderBidding.Selectedtime = null;
            orderBidding.UpDataBy = NickName;
            orderBidding.UpDataTime = DateTime.Now;


            res = await orderBiddingRes.UpdateAsync(orderBidding);
            if (!res)
            {
                throw Oops.Oh("取消工人招工失败！");
            }
            order.OrderStatus = 0;
            res = await orderRes.UpdateAsync(order);

            return res;
        }




        /// <summary>
        /// 查询公司下工人的打卡记录
        /// </summary>
        /// <param name="page"></param>
        /// <returns></returns>
        [Authorize]
        [HttpPost]
        public async Task<PageResult<OrderDakaDto>> PostMyComDakaListPage(OrderDakaPageSearch page)
        {
            var UserID = App.User?.FindFirstValue("UserID");
            int userid = 0;
            if (!string.IsNullOrEmpty(UserID))
            {
                userid = int.Parse(UserID);
            }

            PageResult<OrderDakaDto> result = new PageResult<OrderDakaDto>();
            var orderRepository = new BaseRepository<Order>();
            var userCompanyRes = new BaseRepository<UserCompany>();
            //查询公司的所有员工的所有招工订单
            var userCompany = await userCompanyRes.GetFirstAsync(x => x.UserId == userid && x.IsEn == true && x.IsDeleted == false);
            if (userCompany == null)
            {
                throw Oops.Oh("你没有公司！");
            }
            var userCompanies = await userCompanyRes.GetListAsync(x => x.Suppliercode == userCompany.Suppliercode && x.IsEn == true && x.IsDeleted == false);
            var userids = userCompanies.Select(x => x.UserId).ToList();

            RefAsync<int> total = 0;


            var orderBiddingDetailCheckRepository = new BaseRepository<OrderBiddingDetailCheck>();
            var userWorkerRes = new BaseRepository<UserWorker>();
            var data = await orderRepository.Context.Queryable<Order, OrderBidding, OrderBiddingDetail, UserWorker>((a, b, c, d) =>
                 new JoinQueryInfos(JoinType.Inner, a.Id == b.OrderId,
                 JoinType.Inner, b.Id == c.OrderBiddingId,
                   JoinType.Inner, b.WorkerUserId == d.UserId 
                ))
                     .Where((a, b, c, d) => a.IsEn == true && a.IsDeleted == false && b.IsEn == true && b.IsDeleted == false && c.IsEn == true && c.IsDeleted == false
                     && b.IsSelected == true && userids.Contains(a.OrderUserId)) //a.OrderUserId == userid
                      .WhereIF(page.WordDate.HasValue, (a, b, c, d) => (c.WorkDate == page.WordDate))
                        .WhereIF(page.WordDateStart.HasValue, (a, b, c, d) => (c.WorkDate >= page.WordDateStart))
                       .WhereIF(page.WordDateEnd.HasValue, (a, b, c, d) => (c.WorkDate <= page.WordDateEnd))
                      .WhereIF(page.IsJieSuan.HasValue && page.IsJieSuan == true, (a, b, c, d) => (c.IsShenPi == 2))
                        .WhereIF(page.IsJieSuan.HasValue && page.IsJieSuan == false, (a, b, c, d) => (c.IsShenPi < 2))
                          .WhereIF(!string.IsNullOrEmpty(page.WorkerUserName), (a, b, c, d) => (d.name.Contains(page.WorkerUserName)))
                          .WhereIF(page.WorkerUserId >0 , (a, b, c, d) => (b.WorkerUserId == page.WorkerUserId)) 
                          .OrderByDescending((a,b,c) => c.WorkDate)
                      .Select((a, b, c, d) => new OrderDakaDto
                      {
                          OrderBiddingDetailId = c.Id,
                          OrderName = a.OrderName,
                          WorkDate = c.WorkDate,
                          WorkTime = c.WorkTime,
                          WorkerType = a.WorkerType,
                          WorkPrice = a.WorkPrice,
                          TodaySalary = c.TodaySalary,
                          IsShenPi = c.IsShenPi,
                          WorkCount = c.WorkCount,
                          WorkerUserId = b.WorkerUserId,
                          WorkerUserName = d.name,
                      })
                      
                    .ToPageListAsync(page.PageIndex, page.PageSize, total);



            var heji =  orderRepository.Context.Queryable<Order, OrderBidding, OrderBiddingDetail, UserWorker>((a, b, c, d) =>
                new JoinQueryInfos(JoinType.Inner, a.Id == b.OrderId,
                JoinType.Inner, b.Id == c.OrderBiddingId,
                  JoinType.Inner, b.WorkerUserId == d.UserId
               ))
                    .Where((a, b, c, d) => a.IsEn == true && a.IsDeleted == false && b.IsEn == true && b.IsDeleted == false && c.IsEn == true && c.IsDeleted == false
                    && b.IsSelected == true && userids.Contains(a.OrderUserId)) //a.OrderUserId == userid
                     .WhereIF(page.WordDate.HasValue, (a, b, c, d) => (c.WorkDate == page.WordDate))
                       .WhereIF(page.WordDateStart.HasValue, (a, b, c, d) => (c.WorkDate >= page.WordDateStart))
                      .WhereIF(page.WordDateEnd.HasValue, (a, b, c, d) => (c.WorkDate <= page.WordDateEnd))
                     .WhereIF(page.IsJieSuan.HasValue && page.IsJieSuan == true, (a, b, c, d) => (c.IsShenPi == 2))
                       .WhereIF(page.IsJieSuan.HasValue && page.IsJieSuan == false, (a, b, c, d) => (c.IsShenPi < 2))
                         .WhereIF(!string.IsNullOrEmpty(page.WorkerUserName), (a, b, c, d) => (d.name.Contains(page.WorkerUserName)))
                          .WhereIF(page.WorkerUserId > 0, (a, b, c, d) => (b.WorkerUserId == page.WorkerUserId))
                     .Sum((a, b, c, d) => c.TodaySalary);

            if (data != null && data.Count > 0)
            {
                foreach (var dakaDto in data)
                {
                    int hours = 0;
                    int minutes = 0;
                    var orderBiddingDetailChecks = await orderBiddingDetailCheckRepository.GetListAsync(x => x.OrderBiddingDetailId == dakaDto.OrderBiddingDetailId && x.IsEn == true && x.IsDeleted == false);
                    string DakaMingxi = "";
                    for (int i = 0; i < orderBiddingDetailChecks.Count; i++)
                    {
                        if (i != orderBiddingDetailChecks.Count - 1)
                        {
                            DakaMingxi += orderBiddingDetailChecks[i].Checktime.Value.ToString("HH:mm") + "-";
                        }
                        else
                        {
                            DakaMingxi += orderBiddingDetailChecks[i].Checktime.Value.ToString("HH:mm");
                        }

                        if (i == 1 || i == 3 || i == 5 || i == 7 || i == 9 || i == 11 || i == 13 || i == 15 || i == 17 || i == 19)
                        {
                            var timeDifference = orderBiddingDetailChecks[i].Checktime.Value - orderBiddingDetailChecks[i - 1].Checktime.Value;
                            hours += timeDifference.Hours;
                            minutes += timeDifference.Minutes;

                        }
                    }

                    //如果当天还没有填写申请，则计算工作时间和工资
                    if (dakaDto.IsShenPi == 0)
                    {
                        dakaDto.WorkTime = hours + (minutes / 60);
                        if (dakaDto.WorkerType == 0)
                        {
                            dakaDto.TodaySalary = dakaDto.WorkTime * dakaDto.WorkPrice;
                        }
                        else
                        {
                            var WorkCount = dakaDto.WorkCount ?? 0;
                            dakaDto.TodaySalary = WorkCount * dakaDto.WorkPrice;
                        }

                    }

                    switch (dakaDto.IsShenPi)
                    {
                        case (int)IsShenPis.baocun: dakaDto.IsShenPiName = "未审核"; break;
                        case (int)IsShenPis.tijiao: dakaDto.IsShenPiName = "未审核"; break;
                        case (int)IsShenPis.yishenpi: dakaDto.IsShenPiName = "已审核"; break;
                        default: break;
                    }

                    switch (dakaDto.WorkerType)
                    {
                        case (int)WorkerTypes.time: dakaDto.WorkerTypeName = "计时"; break;
                        case (int)WorkerTypes.count: dakaDto.WorkerTypeName = "计件"; break;
                        default: break;
                    }

                  



                    dakaDto.DakaMingxi = DakaMingxi;


                    //var userWorker = await userWorkerRes.GetFirstAsync(x => x.UserId == dakaDto.WorkerUserId && x.IsEn == true && x.IsDeleted == false );
                    //if (userWorker != null)
                    //{
                    //    dakaDto.WorkerUserName = userWorker.name;
                    //}

                }

            }
            result.Items = data;
            result.PageIndex = page.PageIndex;
            result.PageSize = page.PageSize;
            result.TotalCount = total;
            result.Heji = heji ?? 0;
            return result;
        }





        /// <summary>
        /// 公司确认工人当天打卡详情
        /// </summary>
        /// <returns></returns>
        [Authorize]
        [HttpPost]
        public async Task<bool> saveDakaDetail(DakaQuerenDetailDto dakaDto)
        {

            var UserID = App.User?.FindFirstValue("UserID");
            int userid = 0;
            string NickName = App.User?.FindFirstValue("NickName");
            if (!string.IsNullOrEmpty(UserID))
            {
                userid = int.Parse(UserID);
            }

            var orderBiddingRes = new BaseRepository<OrderBidding>();
            var orderRes = new BaseRepository<Order>();
            var orderBiddingDetailRes = new BaseRepository<OrderBiddingDetail>();
            var userTiXianDetailRes = new BaseRepository<UserTiXianDetail>();
            //var OrderBiddingDetailCheckRes = new BaseRepository<OrderBiddingDetailCheck>();
            var userWorkerRes = new BaseRepository<UserWorker>();
            var userCompanyRes = new BaseRepository<UserCompany>();

            var orderBiddingDetail = await orderBiddingDetailRes.GetByIdAsync(dakaDto.OrderBiddingDetailId);
            var orderBidding = await orderBiddingRes.GetByIdAsync(orderBiddingDetail.OrderBiddingId);
            var order = await orderRes.GetByIdAsync(orderBidding.OrderId);

            if (orderBidding == null || orderBidding.IsDeleted == true || orderBidding.IsEn == false || orderBidding.IsSelected != true)
            {
                throw Oops.Oh("该投递状态无法打卡确认！");
            }
            //if (order == null || order.OrderStatus > 1)
            //{
            //    throw Oops.Oh("该招工状态已无法打卡确认！");
            //}
            var res = false;
            try
            {
                var TodaySalary = orderBiddingDetail.TodaySalary.HasValue?  orderBiddingDetail.TodaySalary.Value:0;
                if(orderBiddingDetail.IsShenPi == (int)IsShenPis.yishenpi)
                {
                    TodaySalary = dakaDto.TodaySalary.Value - TodaySalary;
                }
                else
                {
                    TodaySalary = dakaDto.TodaySalary.Value;
                }
                orderRes.Context.Ado.BeginTran();

                orderBiddingDetail.WorkTime = dakaDto.WorkTime;
                orderBiddingDetail.WorkCount = dakaDto.WorkCount;
                orderBiddingDetail.TodaySalary = dakaDto.TodaySalary;
                orderBiddingDetail.IsShenPi = (int)IsShenPis.yishenpi;
                orderBiddingDetail.ShenPitime = DateTime.Now;
                orderBiddingDetail.UpDataBy = NickName;
                orderBiddingDetail.UpDataTime = DateTime.Now;
                orderBiddingDetail.IsTiXian = true;
                orderBiddingDetail.TiXiantime = DateTime.Now;
                //orderBiddingDetail.CreateBy = NickName;
                //orderBiddingDetail.CreateTime = DateTime.Now;
                res = await orderBiddingDetailRes.UpdateAsync(orderBiddingDetail);
                if (!res)
                {
                    orderRes.Context.Ado.RollbackTran();
                    throw Oops.Oh("结算失败！");
                }

                var userCompany = await userCompanyRes.GetFirstAsync(x => x.UserId == order.OrderUserId);
             
                if (userCompany!=null  )
                {
                    var userCompanies = await userCompanyRes.CountAsync(x => x.Suppliercode == userCompany.Suppliercode && x.IsEn == true && x.IsDeleted == false && x.IsTiXian == true);
                    if (userCompanies > 0)
                    {
                        //插入用户的结算金额
                        UserTiXianDetail userTiXianDetail = new UserTiXianDetail();
                        userTiXianDetail.UserId = orderBidding.WorkerUserId;
                        userTiXianDetail.YiTiXianJine = TodaySalary;
                        userTiXianDetail.ZhiChuShouRu = (int)ZhiChuShouRus.shouru;
                        userTiXianDetail.Remark = userCompany.Suppliername + " " + orderBiddingDetail.WorkDate.Value.ToString("yyyy-MM-dd");
                        userTiXianDetail.UpDataBy = NickName;
                        userTiXianDetail.UpDataTime = DateTime.Now;
                        userTiXianDetail.CreateBy = NickName;
                        userTiXianDetail.CreateTime = DateTime.Now;

                        res = await userTiXianDetailRes.InsertAsync(userTiXianDetail);
                        if (!res)
                        {
                            orderRes.Context.Ado.RollbackTran();
                            throw Oops.Oh("结算失败！");
                        }
                        var userWorker = await userWorkerRes.GetFirstAsync(x => x.UserId == orderBidding.WorkerUserId);
                        if (userWorker != null)
                        {
                            var TiXianZonge = userWorker.TiXianZonge ?? 0;

                            userWorker.TiXianZonge = TiXianZonge + TodaySalary;
                            res = await userWorkerRes.UpdateAsync(userWorker);
                            if (!res)
                            {
                                orderRes.Context.Ado.RollbackTran();
                                throw Oops.Oh("结算失败！");
                            }
                        }
                    }
                }

                

               

                //判断订单是否可以修改为结算状态

                if (order.WordEndTime <= DateTime.Now)
                {
                    var sss =   await orderBiddingRes.GetListAsync(x => x.OrderId == order.Id && x.IsEn == true && x.IsDeleted == false && x.IsSelected == true);
                    var  bbb =sss.Select(x => x.Id).ToList();
                    var oCount = await orderBiddingDetailRes.CountAsync(x => bbb.Contains(x.OrderBiddingId) && x.IsEn == true && x.IsDeleted == false && x.IsShenPi != (int)IsShenPis.yishenpi);
                    if (oCount == 0)
                    {
                        order.OrderStatus = (int)OrderStatuses.jiesuanwanbi;
                        res = await orderRes.UpdateAsync(order);
                        if (!res)
                        {
                            orderRes.Context.Ado.RollbackTran();
                            throw Oops.Oh("结算失败！");
                        }
                    }

                   
                }





                orderRes.Context.Ado.CommitTran();
            }
            catch (Exception ex )
            {
                orderRes.Context.Ado.RollbackTran();
                throw Oops.Oh(ex.Message);
            }
           






            




            return res;
        }




        /// <summary>
        /// 查询公司下所有员工
        /// </summary>
        /// <param name="page"></param>
        /// <returns></returns>
        [Authorize]
        [HttpPost]
        public async Task<List<UserCompanyDto>> PostMystaffList()
        {
            var UserID = App.User?.FindFirstValue("UserID");
            int userid = 0;
            if (!string.IsNullOrEmpty(UserID))
            {
                userid = int.Parse(UserID);
            }


            var userCompanyRes = new BaseRepository<UserCompany>();
            var userRes = new BaseRepository<User>();


            var userCompany = await userCompanyRes.GetFirstAsync(x => x.UserId == userid && x.IsEn == true && x.IsDeleted == false);
            if (userCompany == null)
            {
                throw Oops.Oh("你没有公司！");
            }
            var userCompanies = await userCompanyRes.GetListAsync(x => x.Suppliercode == userCompany.Suppliercode && x.IsEn == true && x.IsDeleted == false);

            var datadtos = _mapper.Map<List<UserCompanyDto>>(userCompanies);

            foreach (var datadto in datadtos)
            {
                var user = await userRes.GetByIdAsync(datadto.UserId);
                datadto.Nickname = user.Nickname;
            }


            return datadtos;
        }


        /// <summary>
        /// 保存公司下所有员工是否管理员
        /// </summary>
        /// <param name="staffAdminDto"></param>
        /// <returns></returns>
        [Authorize]
        [HttpPost]
        public async Task<bool> SaveStaffAdmin(StaffAdminDto staffAdminDto)
        {

            var UserID = App.User?.FindFirstValue("UserID");
            int userid = 0;
            string NickName = App.User?.FindFirstValue("NickName");
            if (!string.IsNullOrEmpty(UserID))
            {
                userid = int.Parse(UserID);
            }
            var userCompanyRes = new BaseRepository<UserCompany>();
            

            var res = false;

            var userCompany = await userCompanyRes.GetByIdAsync(staffAdminDto.ComId);
            if(staffAdminDto.IsAdmin == false)
            {
                var userCompanies = await userCompanyRes.CountAsync(x => x.Suppliercode == userCompany.Suppliercode && x.Id != userCompany.Id && x.IsAdmin == true && x.IsEn == true && x.IsDeleted == false);
                if (userCompanies <= 0)
                {
                    throw Oops.Oh("一个公司必须至少一个管理员！");
                }
            }
           
            if (userCompany != null)
            {
                userCompany.IsAdmin = staffAdminDto.IsAdmin;
                userCompany.UpDataBy = NickName;
                userCompany.UpDataTime = DateTime.Now;
                res = await userCompanyRes.UpdateAsync(userCompany);
            }



            return res;
        }





        /// <summary>
        /// 职位删除功能
        /// </summary>
        /// <returns></returns>
        [Authorize]
        [HttpPost]
        public async Task<bool> deleteOrder(BaoMingDto baoMingDto)
        {

            var UserID = App.User?.FindFirstValue("UserID");
            int userid = 0;
            string NickName = App.User?.FindFirstValue("NickName");
            if (!string.IsNullOrEmpty(UserID))
            {
                userid = int.Parse(UserID);
            }

            //var orderBiddingRes = new BaseRepository<OrderBidding>();
            var orderRes = new BaseRepository<Order>();
            //var userWorkerRes = new BaseRepository<UserWorker>();
           

            var order = await orderRes.GetByIdAsync(baoMingDto.OrderId);
            if (order.OrderStatus > 0)
            {
                throw Oops.Oh("已经招工完毕或者结算，无法下架");
            }

            bool res;
            order.IsEn = false;
            order.UpDataBy = NickName;
            order.UpDataTime = DateTime.Now;

            res = await orderRes.UpdateAsync(order);

            return res;
        }




        /// <summary>
        /// 查询公司下工人的工资额度
        /// </summary>
        /// <param name="page"></param>
        /// <returns></returns>
        [Authorize]
        [HttpPost]
        public async Task<PageResult<OrderDakaDto>> PostMyComGongZiListPage(OrderDakaPageSearch page)
        {
            var UserID = App.User?.FindFirstValue("UserID");
            int userid = 0;
            if (!string.IsNullOrEmpty(UserID))
            {
                userid = int.Parse(UserID);
            }

            PageResult<OrderDakaDto> result = new PageResult<OrderDakaDto>();
            var orderRepository = new BaseRepository<Order>();
            var userCompanyRes = new BaseRepository<UserCompany>();
            //查询公司的所有员工的所有招工订单
            var userCompany = await userCompanyRes.GetFirstAsync(x => x.UserId == userid && x.IsEn == true && x.IsDeleted == false);
            if (userCompany == null)
            {
                throw Oops.Oh("你没有公司！");
            }
            var userCompanies = await userCompanyRes.GetListAsync(x => x.Suppliercode == userCompany.Suppliercode && x.IsEn == true && x.IsDeleted == false);
            var userids = userCompanies.Select(x => x.UserId).ToList();

            RefAsync<int> total = 0;


            var orderBiddingDetailCheckRepository = new BaseRepository<OrderBiddingDetailCheck>();
            var userWorkerRes = new BaseRepository<UserWorker>();
            var data = await orderRepository.Context.Queryable<Order, OrderBidding, OrderBiddingDetail, UserWorker>((a, b, c, d) =>
                 new JoinQueryInfos(JoinType.Inner, a.Id == b.OrderId,
                 JoinType.Inner, b.Id == c.OrderBiddingId,
                   JoinType.Inner, b.WorkerUserId == d.UserId
                ))
                     .Where((a, b, c, d) => a.IsEn == true && a.IsDeleted == false && b.IsEn == true && b.IsDeleted == false && c.IsEn == true && c.IsDeleted == false
                     && b.IsSelected == true && c.IsShenPi == 2 && userids.Contains(a.OrderUserId)) //a.OrderUserId == userid
                      .WhereIF(page.WordDate.HasValue, (a, b, c, d) => (c.WorkDate == page.WordDate))
                      .WhereIF(page.WordDateStart.HasValue, (a, b, c, d) => (c.WorkDate >= page.WordDateStart))
                      .WhereIF(page.WordDateEnd.HasValue, (a, b, c, d) => (c.WorkDate <= page.WordDateEnd))
                         .WhereIF(!string.IsNullOrEmpty(page.WorkerUserName), (a, b, c, d) => (d.name.Contains(page.WorkerUserName)))
                       .GroupBy((a, b, c, d) => new { b.WorkerUserId, d.name })

                      .Select((a, b, c, d) => new OrderDakaDto
                      {

                          TodaySalary = SqlFunc.AggregateSumNoNull(c.TodaySalary),
                          WorkerUserId = b.WorkerUserId,
                          WorkerUserName = d.name,
                      })

                    .ToPageListAsync(page.PageIndex, page.PageSize, total);




            var heji = orderRepository.Context.Queryable<Order, OrderBidding, OrderBiddingDetail, UserWorker>((a, b, c, d) =>
                 new JoinQueryInfos(JoinType.Inner, a.Id == b.OrderId,
                 JoinType.Inner, b.Id == c.OrderBiddingId,
                   JoinType.Inner, b.WorkerUserId == d.UserId
                ))
                     .Where((a, b, c, d) => a.IsEn == true && a.IsDeleted == false && b.IsEn == true && b.IsDeleted == false && c.IsEn == true && c.IsDeleted == false
                     && b.IsSelected == true && c.IsShenPi == 2 && userids.Contains(a.OrderUserId)) //a.OrderUserId == userid
                      .WhereIF(page.WordDate.HasValue, (a, b, c, d) => (c.WorkDate == page.WordDate))
                      .WhereIF(page.WordDateStart.HasValue, (a, b, c, d) => (c.WorkDate >= page.WordDateStart))
                      .WhereIF(page.WordDateEnd.HasValue, (a, b, c, d) => (c.WorkDate <= page.WordDateEnd))
                         .WhereIF(!string.IsNullOrEmpty(page.WorkerUserName), (a, b, c, d) => (d.name.Contains(page.WorkerUserName)))
                      .Sum((a, b, c, d) => c.TodaySalary);

            result.Items = data;
            result.PageIndex = page.PageIndex;
            result.PageSize = page.PageSize;
            result.TotalCount = total;
            result.Heji = heji ?? 0;
            return result;
        }
    }
}