From b565bff0ae1de8485245be28b9fa30e908f148a7 Mon Sep 17 00:00:00 2001 From: sunpengfei <i@angelzzz.com> Date: 星期三, 13 八月 2025 17:47:26 +0800 Subject: [PATCH] feat:开发 --- FlexJobApi.FlexJobServer.Application/TaskUsers/Queries/TaskUserQueryHandler.cs | 113 ++++++++++++++++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 109 insertions(+), 4 deletions(-) diff --git a/FlexJobApi.FlexJobServer.Application/TaskUsers/Queries/TaskUserQueryHandler.cs b/FlexJobApi.FlexJobServer.Application/TaskUsers/Queries/TaskUserQueryHandler.cs index a988103..5846816 100644 --- a/FlexJobApi.FlexJobServer.Application/TaskUsers/Queries/TaskUserQueryHandler.cs +++ b/FlexJobApi.FlexJobServer.Application/TaskUsers/Queries/TaskUserQueryHandler.cs @@ -1,5 +1,8 @@ 锘縰sing FlexJobApi.Core; +using Furion.DatabaseAccessor; +using Furion.FriendlyException; using MediatR; +using Microsoft.EntityFrameworkCore; using System; using System.Collections.Generic; using System.Linq; @@ -8,12 +11,114 @@ namespace FlexJobApi.FlexJobServer.Application { - public class TaskUserQueryHandler - : IRequestHandler<GetTaskUsersQuery, GetTaskUsersQueryResult> + /// <summary> + /// 浠诲姟浜哄憳鏌ヨ澶勭悊鍣� + /// </summary> + public class TaskUserQueryHandler( + IRepository<TaskInfoUser> rep) : + IRequestHandler<GetTaskUsersQuery, GetTaskUsersQueryResult>, + IRequestHandler<GetArrangeTaskUsersQuery, GetArrangeTaskUsersQueryResult> { - public Task<GetTaskUsersQueryResult> Handle(GetTaskUsersQuery request, CancellationToken cancellationToken) + private readonly IRepository<TaskInfoUser> rep = rep; + + /// <summary> + /// B绔煡璇㈠簲鑱樻姤鍚嶅垎椤靛垪琛ㄤ俊鎭� + /// </summary> + /// <param name="request"></param> + /// <param name="cancellationToken"></param> + /// <returns></returns> + public async Task<GetTaskUsersQueryResult> Handle(GetTaskUsersQuery request, CancellationToken cancellationToken) { - throw new NotImplementedException(); + var logier = JwtUtils.GetCurrentLogier(); + 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 + { + Id = it.Id, + EnterpriseEmployeeId = it.EnterpriseEmployeeId, + Avatar = it.EnterpriseEmployee.User.Avatar, + Name = it.EnterpriseEmployee.User.Name, + Identity = it.EnterpriseEmployee.User.Identity, + ContactPhoneNumber = it.EnterpriseEmployee.User.ContactPhoneNumber, + Gender = it.EnterpriseEmployee.User.Gender, + Age = it.EnterpriseEmployee.User.Age, + IsReal = it.EnterpriseEmployee.User.IsReal, + RealMethod = it.EnterpriseEmployee.User.RealMethod, + PersonalIdentityCode = it.EnterpriseEmployee.User.PersonalIdentityCode, + PersonalIdentityContent = it.EnterpriseEmployee.User.PersonalIdentity.Content, + EducationalBackgroundCode = it.EnterpriseEmployee.User.EducationalBackgroundCode, + EducationalBackgroundContent = it.EnterpriseEmployee.User.EducationalBackground.Content, + 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 + }); + return await request.PageModel.GetPagedListAsync<GetTaskUsersQueryResult, GetTaskUsersQueryResultItem>(s, cancellationToken); + } + + /// <summary> + /// B绔煡璇汉鍛樺畨鎺掑垎椤靛垪琛ㄤ俊鎭� + /// </summary> + /// <param name="request"></param> + /// <param name="cancellationToken"></param> + /// <returns></returns> + public async Task<GetArrangeTaskUsersQueryResult> Handle(GetArrangeTaskUsersQuery request, CancellationToken cancellationToken) + { + var logier = JwtUtils.GetCurrentLogier(); + var q = rep.AsQueryable().AsNoTracking() + .OrderBy(it => it.CreatedTime) + .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); + } + 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)); + } + var s = q + .Select(it => new GetArrangeTaskUsersQueryResultItem + { + Id = it.Id, + Avatar = it.EnterpriseEmployee.User.Avatar, + Name = it.EnterpriseEmployee.User.Name, + Identity = it.EnterpriseEmployee.User.Identity, + ContactPhoneNumber = it.EnterpriseEmployee.User.ContactPhoneNumber, + Gender = it.EnterpriseEmployee.User.Gender, + Age = it.EnterpriseEmployee.User.Age, + IsReal = it.EnterpriseEmployee.User.IsReal, + RealMethod = it.EnterpriseEmployee.User.RealMethod, + PersonalIdentityCode = it.EnterpriseEmployee.User.PersonalIdentityCode, + PersonalIdentityContent = it.EnterpriseEmployee.User.PersonalIdentity.Content, + EducationalBackgroundCode = it.EnterpriseEmployee.User.EducationalBackgroundCode, + EducationalBackgroundContent = it.EnterpriseEmployee.User.EducationalBackground.Content, + TaskCount = it.EnterpriseEmployee.TaskInfoUsers.Count(tu => tu.EnterpriseEmployee.HireStatus == EnumTaskUserHireStatus.Pass), + WorkSeniority = it.EnterpriseEmployee.User.WorkSeniority, + WorkExperience = it.EnterpriseEmployee.User.WorkExperience, + ArrangeStatus = it.ArrangeStatus + }); + return await request.PageModel.GetPagedListAsync<GetArrangeTaskUsersQueryResult, GetArrangeTaskUsersQueryResultItem>(s, cancellationToken); } } } -- Gitblit v1.9.1