From 1dd42ed5a57487c52a05954bc94f663d7e12981c Mon Sep 17 00:00:00 2001
From: sunpengfei <i@angelzzz.com>
Date: 星期四, 14 八月 2025 10:37:10 +0800
Subject: [PATCH] feat:开发
---
FlexJobApi.UserServer.Application/UserResumes/Queries/UserResumeQueryHandler.cs | 257 ++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 252 insertions(+), 5 deletions(-)
diff --git a/FlexJobApi.UserServer.Application/UserResumes/Queries/UserResumeQueryHandler.cs b/FlexJobApi.UserServer.Application/UserResumes/Queries/UserResumeQueryHandler.cs
index 4eaf42e..cae6953 100644
--- a/FlexJobApi.UserServer.Application/UserResumes/Queries/UserResumeQueryHandler.cs
+++ b/FlexJobApi.UserServer.Application/UserResumes/Queries/UserResumeQueryHandler.cs
@@ -1,6 +1,9 @@
锘縰sing FlexJobApi.Core;
using Furion.DatabaseAccessor;
+using Furion.FriendlyException;
+using Mapster;
using MediatR;
+using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Linq;
@@ -13,15 +16,259 @@
/// 鐢ㄦ埛绠�鍘嗘煡璇㈠鐞嗗櫒
/// </summary>
public class UserResumeQueryHandler(
- IRepository<UserResume> rep
+ IRepository<User> rep
) :
- IRequestHandler<GetUserResumeQuery, GetUserResumeQueryResult>
+ IRequestHandler<GetUserResumesQuery, GetUserResumesQueryResult>,
+ IRequestHandler<GetUserResumeQuery, GetUserResumeQueryResult>,
+ IRequestHandler<GetUserResumePersonalQuery, GetUserResumePersonalQueryResult>,
+ IRequestHandler<GetUserResumeJobSeekingQuery, GetUserResumeJobSeekingQueryResult>,
+ IRequestHandler<GetUserResumeCredentialsQuery, List<GetUserResumeCredentialsQueryResultItem>>,
+ IRequestHandler<GetUserResumeCredentialQuery, GetUserResumeCredentialQueryResult>,
+ IRequestHandler<GetUserResumeWorkExperienceQuery, GetUserResumeWorkExperienceQueryResult>,
+ IRequestHandler<GetUserResumeDetailQuery, GetUserResumeDetailQueryResult>
{
- private readonly IRepository<UserResume> rep = rep;
+ private readonly IRepository<User> rep = rep;
- public Task<GetUserResumeQueryResult> Handle(GetUserResumeQuery request, CancellationToken cancellationToken)
+ /// <summary>
+ /// 鏌ヨ绠�鍘嗗垎椤靛垪琛ㄦ暟鎹�
+ /// </summary>
+ /// <param name="request"></param>
+ /// <param name="cancellationToken"></param>
+ /// <returns></returns>
+ public async Task<GetUserResumesQueryResult> Handle(GetUserResumesQuery request, CancellationToken cancellationToken)
{
- throw new NotImplementedException();
+ 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.UserExpectJobs.Any(j =>
+ request.UserExpectJobs.Contains(j.ExpectJobCode)
+ || j.ExpectJob.ParentId.HasValue
+ && (request.UserExpectJobs.Contains(j.ExpectJob.Parent.Code))));
+ }
+ if (request.Gender.HasValue)
+ {
+ q = q.Where(it => it.Gender == request.Gender);
+ }
+ if (request.PersonalIdentityCode.IsNotNull())
+ {
+ q = q.Where(it => it.PersonalIdentityCode == request.PersonalIdentityCode);
+ }
+ if (request.AgeMin.HasValue)
+ {
+ q = q.Where(it => it.Age >= request.AgeMin);
+ }
+ if (request.AgeMax.HasValue)
+ {
+ q = q.Where(it => it.Age <= request.AgeMax);
+ }
+ if (request.UserCredentials.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,
+ Avatar = it.Avatar,
+ Name = it.Name,
+ Gender = it.Gender,
+ IsReal = it.IsReal,
+ Age = it.Age,
+ PersonalIdentityCode = it.PersonalIdentityCode,
+ PersonalIdentityContent = it.PersonalIdentity.Content,
+ EducationalBackgroundCode = it.EducationalBackgroundCode,
+ EducationalBackgroundContent = it.EducationalBackground.Content,
+ 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;
}
+
+ /// <summary>
+ /// 鏌ヨ鐢ㄦ埛绠�鍘�
+ /// </summary>
+ /// <param name="request"></param>
+ /// <param name="cancellationToken"></param>
+ /// <returns></returns>
+ public async Task<GetUserResumeQueryResult> Handle(GetUserResumeQuery request, CancellationToken cancellationToken)
+ {
+ var logier = JwtUtils.GetCurrentLogier();
+ if (logier.Type == EnumUserType.Personal)
+ {
+ request.UserId = logier.Id;
+ }
+ EnterpriseEmployee? enterpriseEmployee = null;
+ if (logier.Type == EnumUserType.Enterprise && request.UserId == null && request.EnterpriseEmployeeId.HasValue)
+ {
+ enterpriseEmployee = await rep.Change<EnterpriseEmployee>().AsQueryable().AsNoTracking()
+ .Where(it => it.EnterpriseId == logier.EnterpriseId && it.Id == request.EnterpriseEmployeeId)
+ .FirstOrDefaultAsync(cancellationToken);
+ if (enterpriseEmployee == null) throw Oops.Oh(EnumErrorCodeType.s404, "璇ョ伒宸�");
+ request.UserId = enterpriseEmployee.UserId;
+ }
+ else if (request.UserId == null) throw Oops.Oh(EnumErrorCodeType.s400, "璇烽�夋嫨鐢ㄦ埛");
+
+ GetUserResumeQueryResult? model = null;
+ if (request.UserId.HasValue)
+ {
+ model = await rep.AsQueryable().AsNoTracking()
+ .Where(it => it.Id == request.UserId)
+ .GetDetail<User, GetUserResumeQueryResult>(cancellationToken);
+ }
+ else if (enterpriseEmployee != null)
+ {
+ model = new GetUserResumeQueryResult
+ {
+ Name = enterpriseEmployee.Name,
+ ContactPhoneNumber = enterpriseEmployee.ContactPhoneNumber,
+ Identity = enterpriseEmployee.Identity,
+ Gender = enterpriseEmployee.Gender,
+ Age = enterpriseEmployee.Age,
+ };
+ }
+ if (model == null) throw Oops.Oh(EnumErrorCodeType.s404, "璇ヤ俊鎭�");
+
+ model.TaskInfoUsers = model.TaskInfoUsers.Where(it => it.SignContractTime.HasValue).ToList();
+ if (model.Id.HasValue)
+ {
+ model.TaskInfoUsers = rep.Change<TaskInfoUser>().AsQueryable().AsNoTracking()
+ .Where(it => it.EnterpriseEmployee.UserId == model.Id && it.EnterpriseEmployee.EnterpriseSignContractTime.HasValue)
+ .Select(it => new GetUserResumeQueryResultExperience
+ {
+ SignContractTime = it.EnterpriseEmployee.EnterpriseSignContractTime,
+ EnterpriseName = it.TaskInfo.Enterprise.EnterpriseName,
+ Name = it.TaskInfo.Name
+ })
+ .ToList();
+ 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 && it.UserId == model.Id)
+ .Select(it => it.IsCollected)
+ .FirstOrDefaultAsync();
+ }
+ }
+ if (model.CityCode.IsNotNull())
+ {
+ model.CompleteRate += 20;
+ }
+ if (model.JobSeekingStatus.HasValue)
+ {
+ model.CompleteRate += 20;
+ }
+ if (model.UserCredentials.IsNotNull())
+ {
+ model.CompleteRate += 20;
+ }
+ if (model.WorkExperience.IsNotNull() || model.WorkSeniority.IsNotNull())
+ {
+ model.CompleteRate += 20;
+ }
+ if (model.Weight.HasValue || model.Height.HasValue || model.Photos.IsNotNull())
+ {
+ model.CompleteRate += 20;
+ }
+
+ return model;
+ }
+
+ /// <summary>
+ /// 鏌ヨ鐢ㄦ埛绠�鍘�-涓汉淇℃伅
+ /// </summary>
+ /// <param name="request"></param>
+ /// <param name="cancellationToken"></param>
+ /// <returns></returns>
+ public Task<GetUserResumePersonalQueryResult> Handle(GetUserResumePersonalQuery request, CancellationToken cancellationToken)
+ {
+ return rep.GetPersonalQueryable(false)
+ .GetDetail<User, GetUserResumePersonalQueryResult>(cancellationToken);
+ }
+
+ /// <summary>
+ /// 鏌ヨ鐢ㄦ埛绠�鍘�-姹傝亴鎰忓悜
+ /// </summary>
+ /// <param name="request"></param>
+ /// <param name="cancellationToken"></param>
+ /// <returns></returns>
+ public Task<GetUserResumeJobSeekingQueryResult> Handle(GetUserResumeJobSeekingQuery request, CancellationToken cancellationToken)
+ {
+ return rep.GetPersonalQueryable(false)
+ .GetDetail<User, GetUserResumeJobSeekingQueryResult>(cancellationToken);
+ }
+
+ /// <summary>
+ /// 鏌ヨ鐢ㄦ埛绠�鍘�-璧勬牸璇佷功鍒楄〃
+ /// </summary>
+ /// <param name="request"></param>
+ /// <param name="cancellationToken"></param>
+ /// <returns></returns>
+ public async Task<List<GetUserResumeCredentialsQueryResultItem>> Handle(GetUserResumeCredentialsQuery request, CancellationToken cancellationToken)
+ {
+ return await rep.GetPersonalQueryable(false)
+ .SelectMany(it => it.UserCredentials)
+ .OrderBy(it => it.CreatedTime)
+ .ProjectToType<GetUserResumeCredentialsQueryResultItem>()
+ .ToListAsync(cancellationToken);
+ }
+
+ /// <summary>
+ /// 鏌ヨ鐢ㄦ埛绠�鍘�-璧勬牸璇佷功
+ /// </summary>
+ /// <param name="request"></param>
+ /// <param name="cancellationToken"></param>
+ /// <returns></returns>
+ public Task<GetUserResumeCredentialQueryResult> Handle(GetUserResumeCredentialQuery request, CancellationToken cancellationToken)
+ {
+ return rep.GetPersonalQueryable(false)
+ .SelectMany(it => it.UserCredentials)
+ .Where(it => it.Id == request.Id)
+ .GetDetail<UserCredential, GetUserResumeCredentialQueryResult>(cancellationToken);
+ }
+
+ /// <summary>
+ /// 鏌ヨ鐢ㄦ埛绠�鍘�-宸ヤ綔缁忛獙
+ /// </summary>
+ /// <param name="request"></param>
+ /// <param name="cancellationToken"></param>
+ /// <returns></returns>
+ public Task<GetUserResumeWorkExperienceQueryResult> Handle(GetUserResumeWorkExperienceQuery request, CancellationToken cancellationToken)
+ {
+ return rep.GetPersonalQueryable(false)
+ .GetDetail<User, GetUserResumeWorkExperienceQueryResult>(cancellationToken);
+ }
+
+ /// <summary>
+ /// 鏌ヨ鐢ㄦ埛绠�鍘�-璇︾粏淇℃伅
+ /// </summary>
+ /// <param name="request"></param>
+ /// <param name="cancellationToken"></param>
+ /// <returns></returns>
+ public Task<GetUserResumeDetailQueryResult> Handle(GetUserResumeDetailQuery request, CancellationToken cancellationToken)
+ {
+ return rep.GetPersonalQueryable(false)
+ .GetDetail<User, GetUserResumeDetailQueryResult>(cancellationToken);
+ }
+
}
}
--
Gitblit v1.9.1