sunpengfei
2025-08-22 680ee6957a7faaf65b997f5ae424a502902f9368
FlexJobApi.UserServer.Application/EnterpriseEmployees/Queries/EnterpriseEmployeeQueryHandler.cs
@@ -18,7 +18,8 @@
            IRepository<EnterpriseEmployee> rep
        ) :
        IRequestHandler<GetEnterpriseEmployeesQuery, GetEnterpriseEmployeesQueryResult>,
        IRequestHandler<GetEnterpriseEmployeeQuery, GetEnterpriseEmployeeQueryResult>
        IRequestHandler<GetEnterpriseEmployeeQuery, GetEnterpriseEmployeeQueryResult>,
        IRequestHandler<GetEnterpriseEmployeeElectronSignsQuery, GetEnterpriseEmployeeElectronSignsQueryResult>
    {
        private readonly IRepository<EnterpriseEmployee> rep = rep;
@@ -57,7 +58,7 @@
            }
            if (request.HireStatus.HasValue)
            {
                q = q.Where(it => it.HireStatus == request.HireStatus);
                q = q.Where(it => it.TaskInfoUsers.Any(tu => tu.HireStatus == request.HireStatus));
            }
            if (request.IsReal.HasValue)
            {
@@ -80,18 +81,26 @@
                Gender = it.Gender,
                Age = it.Age,
                ContactPhoneNumber = it.ContactPhoneNumber,
                UserIsReal = it.User.IsReal,
                UserIsReal = it.User.IsReal == true,
                RealMethod = it.User.RealMethod,
                PersonalIdentityCode = it.User.PersonalIdentityCode,
                PersonalIdentityContent = it.User.PersonalIdentity.Content,
                EducationalBackgroundCode = it.User.EducationalBackgroundCode,
                EducationalBackgroundContent = it.User.EducationalBackground.Content,
                TaskCount = it.User.EnterpriseEmployees.Where(ee => ee.HireStatus == EnumTaskUserHireStatus.Pass).Sum(ee => ee.TaskInfoUsers.Count()),
                TaskCount = it.User.EnterpriseEmployees.SelectMany(ee => ee.TaskInfoUsers).Count(tu => tu.HireStatus == EnumTaskUserHireStatus.Pass),
                WorkSeniority = it.User.WorkSeniority,
                WorkExperience = it.User.WorkExperience,
                HireStatus = it.HireStatus,
                HireStatus = it.TaskInfoUsers.Any(tu => tu.HireStatus == EnumTaskUserHireStatus.Pass)
                    ? EnumTaskUserHireStatus.Pass
                    : it.TaskInfoUsers.Any(tu => tu.HireStatus == EnumTaskUserHireStatus.Refuse)
                    ? EnumTaskUserHireStatus.Refuse
                    : EnumTaskUserHireStatus.Wait,
                UserSignContractStatus = it.UserSignContractStatus,
                HireTime = it.HireTime,
                HireTime = it.TaskInfoUsers
                    .OrderBy(tu => tu.HireTime)
                    .Where(tu => tu.HireStatus == EnumTaskUserHireStatus.Pass && tu.HireTime.HasValue)
                    .Select(tu => tu.HireTime)
                    .FirstOrDefault(),
                UserRealTime = it.User.RealTime,
                UserSignContractTime = it.UserSignContractTime,
                EnterpriseSignContractStatus = it.EnterpriseSignContractStatus,
@@ -127,8 +136,39 @@
                    .Select(it => it.CreatedTime as DateTimeOffset?)
                    .FirstOrDefaultAsync(cancellationToken);
            }
            return model;
        }
        /// <summary>
        /// 查询个人用户签约列表
        /// </summary>
        /// <param name="request"></param>
        /// <param name="cancellationToken"></param>
        /// <returns></returns>
        public async Task<GetEnterpriseEmployeeElectronSignsQueryResult> Handle(GetEnterpriseEmployeeElectronSignsQuery request, CancellationToken cancellationToken)
        {
            var logier = JwtUtils.GetCurrentLogier();
            var q = rep.AsQueryable().AsNoTracking()
                .Where(it => it.UserId == logier.Id);
            if (request.UserSignContractStatus.HasValue)
            {
                q = q.Where(it => it.UserSignContractStatus == request.UserSignContractStatus.Value);
            }
            else
            {
                q = q.Where(it =>
                    it.UserSignContractStatus == EnumTaskUserSignContractStatus.Wait
                    || it.UserSignContractStatus == EnumTaskUserSignContractStatus.Effect
                    || it.UserSignContractStatus == EnumTaskUserSignContractStatus.Stop);
            }
            var s = q.Select(it => new GetEnterpriseEmployeeElectronSignsQueryResultItem
            {
                Id = it.Id,
                EnterpriseName = it.Enterprise.EnterpriseName,
                UserSignContractStatus = it.UserSignContractStatus,
            });
            return await request.PageModel.GetPagedListAsync<GetEnterpriseEmployeeElectronSignsQueryResult, GetEnterpriseEmployeeElectronSignsQueryResultItem>(s, cancellationToken);
        }
    }
}