using FlexJobApi.Core;
|
using Furion.DatabaseAccessor;
|
using Furion.FriendlyException;
|
using Mapster;
|
using MediatR;
|
using Microsoft.EntityFrameworkCore;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace FlexJobApi.UserServer.Application
|
{
|
/// <summary>
|
/// 用户简历查询处理器
|
/// </summary>
|
public class UserResumeQueryHandler(
|
IRepository<User> rep,
|
IRepository<TaskInfoUser> repTaskInfoUser
|
) :
|
IRequestHandler<GetOpenUserResumesQuery, GetUserResumesQueryResult>,
|
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<User> rep = rep;
|
private readonly IRepository<TaskInfoUser> repTaskInfoUser = repTaskInfoUser;
|
|
/// <summary>
|
/// 查询开放简历分页列表数据
|
/// </summary>
|
/// <param name="request"></param>
|
/// <param name="cancellationToken"></param>
|
/// <returns></returns>
|
public Task<GetUserResumesQueryResult> Handle(GetOpenUserResumesQuery request, CancellationToken cancellationToken)
|
{
|
return Handle(request.Adapt<GetUserResumesQuery>(), cancellationToken);
|
}
|
|
/// <summary>
|
/// 查询简历分页列表数据
|
/// </summary>
|
/// <param name="request"></param>
|
/// <param name="cancellationToken"></param>
|
/// <returns></returns>
|
public async Task<GetUserResumesQueryResult> Handle(GetUserResumesQuery request, CancellationToken cancellationToken)
|
{
|
Console.WriteLine(111);
|
var logier = JwtUtils.GetCurrentLogier();
|
var q = rep.AsQueryable().AsNoTracking()
|
.Where(it => it.Type == EnumUserType.Personal);
|
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 != null && logier.Type == EnumUserType.Enterprise && request.IsCollected == true)
|
{
|
q = q.Where(it => it.EnterpriseUserCollects.Any(c => c.EnterpriseId == logier.EnterpriseId && c.IsCollected));
|
}
|
if (logier != null && 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,
|
ContactPhoneNumber = it.ContactPhoneNumber,
|
Identity = it.Identity,
|
RealTime = it.RealTime,
|
PersonalIdentityCode = it.PersonalIdentityCode,
|
PersonalIdentityContent = it.PersonalIdentity.Content,
|
EducationalBackgroundCode = it.EducationalBackgroundCode,
|
EducationalBackgroundContent = it.EducationalBackground.Content,
|
TaskCount = it.EnterpriseEmployees.SelectMany(ee => ee.TaskInfoUsers).Count(tu => tu.HireStatus == EnumTaskUserHireStatus.Pass),
|
WorkSeniority = it.WorkSeniority,
|
WorkExperience = it.WorkExperience,
|
CreatedTime = it.CreatedTime,
|
HireStatus = request.TaskInfoId.HasValue
|
? it.EnterpriseEmployees
|
.SelectMany(ee => ee.TaskInfoUsers)
|
.Where(tu => tu.TaskInfoId == request.TaskInfoId)
|
.Select(tu => tu.HireStatus as EnumTaskUserHireStatus?)
|
.FirstOrDefault()
|
: null
|
});
|
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 != null && logier.Type == EnumUserType.Personal)
|
{
|
request.UserId = logier.Id;
|
}
|
EnterpriseEmployee? enterpriseEmployee = null;
|
if (logier != null && 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, "信息");
|
|
if (model.Id.HasValue)
|
{
|
model.TaskInfoUsers = repTaskInfoUser.AsQueryable().AsNoTracking()
|
.Where(it =>
|
it.EnterpriseEmployee.UserId == model.Id
|
&& it.HireStatus == EnumTaskUserHireStatus.Pass
|
&& it.HireTime.HasValue)
|
.Select(it => new GetUserResumeQueryResultExperience
|
{
|
HireTime = it.HireTime,
|
EnterpriseName = it.TaskInfo.Enterprise.EnterpriseName,
|
Name = it.TaskInfo.Name
|
})
|
.ToList();
|
model.TaskCount = await repTaskInfoUser.AsQueryable().AsNoTracking()
|
.Where(it => it.EnterpriseEmployee.UserId == model.Id && it.HireStatus == EnumTaskUserHireStatus.Pass)
|
.CountAsync();
|
if (logier != null && 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);
|
}
|
|
}
|
}
|
