| | |
| | | private readonly IRepository<User> rep = rep; |
| | | |
| | | /// <summary> |
| | | /// 查询灵工分页列表数据 |
| | | /// 查询简历分页列表数据 |
| | | /// </summary> |
| | | /// <param name="request"></param> |
| | | /// <param name="cancellationToken"></param> |
| | |
| | | { |
| | | var logier = JwtUtils.GetCurrentLogier(); |
| | | var q = rep.AsQueryable().AsNoTracking(); |
| | | if (request.TaskInfoId.HasValue) |
| | | { |
| | | q = q.Where(it => it.EnterpriseEmployees.Any(ee => ee.TaskInfoUsers.Any(tu => tu.TaskInfoId == request.TaskInfoId))); |
| | | } |
| | | if (request.UserExpectJobs.IsNotNull()) |
| | | { |
| | | q = q.Where(it => |
| | |
| | | it.UserCredentials.Any(c => |
| | | request.UserCredentials.Contains(c.TypeCode))); |
| | | } |
| | | if (logier.Type == EnumUserType.Enterprise && request.IsCollected == true) |
| | | { |
| | | q = q.Where(it => it.EnterpriseUserCollects.Any(c => c.EnterpriseId == logier.EnterpriseId && c.IsCollected)); |
| | | } |
| | | if (logier.Type == EnumUserType.Enterprise && request.IsContacted == true) |
| | | { |
| | | q = q.Where(it => it.EnterpriseUserCollects.Any(c => c.EnterpriseId == logier.EnterpriseId && c.IsContacted)); |
| | | } |
| | | var s = q.Select(it => new GetUserResumesQueryResultItem |
| | | { |
| | | Id = it.Id, |
| | |
| | | PersonalIdentityContent = it.PersonalIdentity.Content, |
| | | EducationalBackgroundCode = it.EducationalBackgroundCode, |
| | | EducationalBackgroundContent = it.EducationalBackground.Content, |
| | | TaskCount = it.TaskInfoUsers.Count(tu => tu.SignContractStatus == EnumTaskUserSignContractStatus.Pass), |
| | | TaskCount = it.EnterpriseEmployees.Where(ee => ee.HireStatus == EnumTaskUserHireStatus.Pass).Sum(ee => ee.TaskInfoUsers.Count()), |
| | | WorkSeniority = it.WorkSeniority, |
| | | WorkExperience = it.WorkExperience |
| | | WorkExperience = it.WorkExperience, |
| | | CreatedTime = it.CreatedTime, |
| | | }); |
| | | var result = await request.PageModel.GetPagedListAsync<GetUserResumesQueryResult, GetUserResumesQueryResultItem>(s, cancellationToken); |
| | | return result; |
| | |
| | | request.UserId = logier.Id; |
| | | } |
| | | if (request.UserId == null) throw Oops.Oh(EnumErrorCodeType.s400, "请选择用户"); |
| | | var model = await request.UserId.Value |
| | | var model = await rep.AsQueryable().AsNoTracking() |
| | | .Where(it => it.Id == request.UserId) |
| | | .GetDetail<User, GetUserResumeQueryResult>(cancellationToken); |
| | | model.TaskInfoUsers = model.TaskInfoUsers.Where(it => it.SignContractTime.HasValue).ToList(); |
| | | model.TaskCount = await rep.Change<TaskInfoUser>().AsQueryable().AsNoTracking() |
| | | .Where(it => it.UserId == model.Id && it.HireStatus == EnumTaskUserHireStatus.Pass) |
| | | .Where(it => it.EnterpriseEmployee.UserId == model.Id && it.EnterpriseEmployee.HireStatus == EnumTaskUserHireStatus.Pass) |
| | | .CountAsync(); |
| | | if (model.CityCode.IsNotNull()) |
| | | { |