| | |
| | | public async Task<GetPersonalUserInfosQueryResult> Handle(GetPersonalUserInfosQuery request, CancellationToken cancellationToken) |
| | | { |
| | | var logier = JwtUtils.GetCurrentLogier(); |
| | | var q = rep.AsQueryable().AsNoTracking(); |
| | | var q = rep.AsQueryable().AsNoTracking() |
| | | .Where(it => it.Type == EnumUserType.Personal); |
| | | if (request.Keywords.IsNotNull()) |
| | | { |
| | | q = q.Where(it => |
| | |
| | | if (request.HireTimeBegin.HasValue && request.HireTimeEnd.HasValue) |
| | | { |
| | | q = q.Where(it => |
| | | it.EnterpriseEmployees.Any(e => |
| | | e.HireStatus == EnumTaskUserHireStatus.Pass |
| | | && e.HireTime.HasValue |
| | | && request.HireTimeBegin <= e.HireTime |
| | | && e.HireTime <= request.HireTimeEnd)); |
| | | it.EnterpriseEmployees.SelectMany(ee => ee.TaskInfoUsers).Any(tu => |
| | | tu.HireStatus == EnumTaskUserHireStatus.Pass |
| | | && tu.HireTime.HasValue |
| | | && request.HireTimeBegin <= tu.HireTime |
| | | && tu.HireTime <= request.HireTimeEnd)); |
| | | } |
| | | if (request.SignContractBegin.HasValue && request.SignContractEnd.HasValue) |
| | | { |
| | |
| | | IsReal = it.IsReal, |
| | | RealTime = it.RealTime, |
| | | HireTime = it.EnterpriseEmployees |
| | | .SelectMany(ee => ee.TaskInfoUsers) |
| | | .OrderByDescending(e => e.HireTime) |
| | | .Where(e => e.HireStatus == EnumTaskUserHireStatus.Pass && e.HireTime.HasValue) |
| | | .Select(e => e.HireTime) |
| | |
| | | .OrderBy(tu => tu.CreatedTime) |
| | | .Select(tu => tu.CreatedTime as DateTimeOffset?) |
| | | .FirstOrDefault(), |
| | | HireStatus = it.HireStatus, |
| | | HireTime = it.HireTime, |
| | | HireStatus = it.TaskInfoUsers.Any(tu => tu.HireStatus == EnumTaskUserHireStatus.Pass) |
| | | ? EnumTaskUserHireStatus.Pass |
| | | : it.TaskInfoUsers.Any(tu => tu.HireStatus == EnumTaskUserHireStatus.Refuse) |
| | | ? EnumTaskUserHireStatus.Refuse |
| | | : EnumTaskUserHireStatus.Wait, |
| | | HireTime = it.TaskInfoUsers |
| | | .OrderBy(tu => tu.HireTime) |
| | | .Where(tu => tu.HireStatus == EnumTaskUserHireStatus.Pass && tu.HireTime.HasValue) |
| | | .Select(tu => tu.HireTime) |
| | | .FirstOrDefault(), |
| | | UserSignContractStatus = it.UserSignContractStatus, |
| | | EnterpriseSignContractStatus = it.EnterpriseSignContractStatus, |
| | | EnterpriseSignContractTime = it.EnterpriseSignContractTime, |