| | |
| | | private readonly IRepository<User> rep = rep; |
| | | |
| | | /// <summary> |
| | | /// 查询灵工分页列表数据 |
| | | /// 查询简历分页列表数据 |
| | | /// </summary> |
| | | /// <param name="request"></param> |
| | | /// <param name="cancellationToken"></param> |
| | |
| | | var q = rep.AsQueryable().AsNoTracking(); |
| | | if (request.TaskInfoId.HasValue) |
| | | { |
| | | q = q.Where(it => it.TaskInfoUsers.Any(tu => tu.TaskInfoId == request.TaskInfoId)); |
| | | q = q.Where(it => it.EnterpriseEmployees.Any(ee => ee.TaskInfoUsers.Any(tu => tu.TaskInfoId == request.TaskInfoId))); |
| | | } |
| | | if (request.UserExpectJobs.IsNotNull()) |
| | | { |
| | |
| | | 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.EnterpriseEmployee.HireStatus == EnumTaskUserHireStatus.Pass), |
| | | TaskCount = it.EnterpriseEmployees.Where(ee => ee.HireStatus == EnumTaskUserHireStatus.Pass).Sum(ee => ee.TaskInfoUsers.Count()), |
| | | WorkSeniority = it.WorkSeniority, |
| | | WorkExperience = it.WorkExperience, |
| | | CreatedTime = it.CreatedTime, |
| | | }); |
| | | var result = await request.PageModel.GetPagedListAsync<GetUserResumesQueryResult, GetUserResumesQueryResultItem>(s, cancellationToken); |
| | | return result; |
| | |
| | | model.TaskCount = await rep.Change<TaskInfoUser>().AsQueryable().AsNoTracking() |
| | | .Where(it => it.EnterpriseEmployee.UserId == model.Id && it.EnterpriseEmployee.HireStatus == EnumTaskUserHireStatus.Pass) |
| | | .CountAsync(); |
| | | if (logier.Type == EnumUserType.Enterprise) |
| | | { |
| | | model.IsCollected = await rep.Change<EnterpriseUserCollect>().AsQueryable().AsNoTracking() |
| | | .Where(it => it.EnterpriseId == logier.EnterpriseId) |
| | | .Select(it => it.IsCollected) |
| | | .FirstOrDefaultAsync(); |
| | | } |
| | | if (model.CityCode.IsNotNull()) |
| | | { |
| | | model.CompleteRate += 20; |
| | |
| | | { |
| | | model.CompleteRate += 20; |
| | | } |
| | | |
| | | return model; |
| | | } |
| | | |