| | |
| | | using FlexJobApi.Core; |
| | | using Furion.DatabaseAccessor; |
| | | using Furion.FriendlyException; |
| | | using MediatR; |
| | | using Microsoft.EntityFrameworkCore; |
| | | using System; |
| | |
| | | /// 任务人员查询处理器 |
| | | /// </summary> |
| | | public class TaskUserQueryHandler( |
| | | IRepository<TaskInfoUser> rep) : |
| | | IRepository<TaskInfoUser> rep) : |
| | | IRequestHandler<GetTaskUsersQuery, GetTaskUsersQueryResult>, |
| | | IRequestHandler<GetArrangeTaskUsersQuery, GetArrangeTaskUsersQueryResult> |
| | | { |
| | |
| | | var q = rep.AsQueryable().AsNoTracking() |
| | | .OrderBy(it => it.CreatedTime) |
| | | .Where(it => it.TaskInfo.EnterpriseId == logier.EnterpriseId && it.TaskInfoId == request.Id); |
| | | if (request.Keywords.IsNotNull()) |
| | | { |
| | | q = q.Where(it => |
| | | it.EnterpriseEmployee.User.Name.Contains(request.Keywords) |
| | | || it.EnterpriseEmployee.User.Identity.Contains(request.Keywords) |
| | | || it.EnterpriseEmployee.User.PhoneNumber.Contains(request.Keywords)); |
| | | } |
| | | if (request.HireStatus.HasValue) |
| | | { |
| | | q = q.Where(it => it.EnterpriseEmployee.HireStatus == request.HireStatus); |
| | | } |
| | | var s = q |
| | | .Select(it => new GetTaskUsersQueryResultItem |
| | | { |
| | |
| | | PersonalIdentityContent = it.EnterpriseEmployee.User.PersonalIdentity.Content, |
| | | EducationalBackgroundCode = it.EnterpriseEmployee.User.EducationalBackgroundCode, |
| | | EducationalBackgroundContent = it.EnterpriseEmployee.User.EducationalBackground.Content, |
| | | TaskCount = it.EnterpriseEmployee.User.TaskInfoUsers.Count(tu => tu.EnterpriseEmployee.HireStatus == EnumTaskUserHireStatus.Pass), |
| | | TaskCount = it.EnterpriseEmployee.TaskInfoUsers.Count(tu => tu.EnterpriseEmployee.HireStatus == EnumTaskUserHireStatus.Pass), |
| | | WorkSeniority = it.EnterpriseEmployee.User.WorkSeniority, |
| | | WorkExperience = it.EnterpriseEmployee.User.WorkExperience, |
| | | HireStatus = it.EnterpriseEmployee.HireStatus |
| | |
| | | var logier = JwtUtils.GetCurrentLogier(); |
| | | var q = rep.AsQueryable().AsNoTracking() |
| | | .OrderBy(it => it.CreatedTime) |
| | | .Where(it => |
| | | it.TaskInfo.EnterpriseId == logier.EnterpriseId |
| | | .Where(it => |
| | | it.TaskInfo.EnterpriseId == logier.EnterpriseId |
| | | && it.TaskInfoId == request.Id |
| | | && it.EnterpriseEmployee.HireStatus == EnumTaskUserHireStatus.Pass |
| | | && it.EnterpriseEmployee.UserSignContractStatus == EnumTaskUserSignContractStatus.Pass |
| | | && it.EnterpriseEmployee.EnterpriseSignContractStatus == EnumTaskUserSignContractStatus.Pass); |
| | | if (request.ArrangeStatus.HasValue) |
| | | { |
| | | q = q.Where(it=>it.ArrangeStatus == request.ArrangeStatus); |
| | | q = q.Where(it => it.ArrangeStatus == request.ArrangeStatus); |
| | | } |
| | | if (request.Keywords.IsNotNull()) |
| | | { |
| | |
| | | PersonalIdentityContent = it.EnterpriseEmployee.User.PersonalIdentity.Content, |
| | | EducationalBackgroundCode = it.EnterpriseEmployee.User.EducationalBackgroundCode, |
| | | EducationalBackgroundContent = it.EnterpriseEmployee.User.EducationalBackground.Content, |
| | | TaskCount = it.EnterpriseEmployee.User.TaskInfoUsers.Count(tu => tu.EnterpriseEmployee.HireStatus == EnumTaskUserHireStatus.Pass), |
| | | TaskCount = it.EnterpriseEmployee.TaskInfoUsers.Count(tu => tu.EnterpriseEmployee.HireStatus == EnumTaskUserHireStatus.Pass), |
| | | WorkSeniority = it.EnterpriseEmployee.User.WorkSeniority, |
| | | WorkExperience = it.EnterpriseEmployee.User.WorkExperience, |
| | | ArrangeStatus = it.ArrangeStatus |