From fed0f0b4f2abeca2ee641ee3f95416f68a06fe09 Mon Sep 17 00:00:00 2001 From: sunpengfei <i@angelzzz.com> Date: 星期三, 13 八月 2025 19:06:44 +0800 Subject: [PATCH] feat:开发 --- FlexJobApi.FlexJobServer.Application/TaskCheckReceives/Queries/TaskCheckReceiveQueryHandler.cs | 97 +++++++++++++++++++++++++++++++++++++++++++----- 1 files changed, 86 insertions(+), 11 deletions(-) diff --git a/FlexJobApi.FlexJobServer.Application/TaskCheckReceives/Queries/TaskCheckReceiveQueryHandler.cs b/FlexJobApi.FlexJobServer.Application/TaskCheckReceives/Queries/TaskCheckReceiveQueryHandler.cs index ef3b8e8..eafd2a4 100644 --- a/FlexJobApi.FlexJobServer.Application/TaskCheckReceives/Queries/TaskCheckReceiveQueryHandler.cs +++ b/FlexJobApi.FlexJobServer.Application/TaskCheckReceives/Queries/TaskCheckReceiveQueryHandler.cs @@ -49,6 +49,14 @@ { q = q.Where(it => it.EnterpriseId == logier.EnterpriseId); } + if (request.Keywords.IsNotNull()) + { + q = q.Where(it => + it.TaskInfoUsers.Any(tu => + tu.EnterpriseEmployee.User.Name.Contains(request.Keywords) + || tu.EnterpriseEmployee.User.PhoneNumber.Contains(request.Keywords) + || tu.EnterpriseEmployee.User.Identity.Contains(request.Keywords))); + } if (logier.ClientType == EnumClientType.Wxmp) { if (request.CheckReceiveStatus == null) @@ -60,8 +68,9 @@ throw Oops.Oh(EnumErrorCodeType.s400, "璇烽�夋嫨鏃ユ湡"); } q = q.Where(it => - it.TaskInfoUsers.Any(tu => - tu.EnterpriseEmployee.UserId == logier.Id + (logier.Type == EnumUserType.Enterprise ? it.EnterpriseId == logier.EnterpriseId : true) + && it.TaskInfoUsers.Any(tu => + (logier.Type == EnumUserType.Personal ? tu.EnterpriseEmployee.UserId == logier.Id : true) && (request.CheckReceiveStatus == EnumTaskCheckReceiveStatus.WaitSubmit ? !tu.Submits.Any(s => s.Date.Date == request.Date.Value.Date) : tu.Submits.Any(s => @@ -84,7 +93,23 @@ q = q.Where(it => it.CheckReceiveStatus == request.CheckReceiveStatus); } } - var s = q.ProjectToType<GetCheckReceiveTasksQueryResultItem>(); + var s = q.Select(it => new GetCheckReceiveTasksQueryResultItem + { + Id = it.Id, + Name = it.Name, + Code = it.Code, + BillingMethod = it.BillingMethod, + ServiceFee = it.ServiceFee, + SettlementCycle = it.SettlementCycle, + CreatedTime = it.CreatedTime, + BeginTime = it.BeginTime, + EndTime = it.EndTime, + AddressName = it.AddressName, + LastCheckReceiveTime = it.LastCheckReceiveTime, + CheckReceiveStatus = logier.Type == EnumUserType.Enterprise && logier.ClientType == EnumClientType.Wxmp && request.Date.HasValue + ? request.CheckReceiveStatus + : it.CheckReceiveStatus, + }); return await request.PageModel.GetPagedListAsync<GetCheckReceiveTasksQueryResult, GetCheckReceiveTasksQueryResultItem>(s, cancellationToken); } @@ -109,9 +134,32 @@ { q = q.Where(it => it.TaskInfo.EnterpriseId == logier.EnterpriseId); } + if (logier.Type == EnumUserType.Enterprise && logier.ClientType == EnumClientType.Wxmp) + { + if (request.CheckReceiveStatus == null) + { + throw Oops.Oh(EnumErrorCodeType.s400, "璇烽�夋嫨楠屾敹鐘舵��"); + } + if (request.Date == null) + { + throw Oops.Oh(EnumErrorCodeType.s400, "璇烽�夋嫨鏃ユ湡"); + } + q = q.Where(it => + it.TaskInfo.EnterpriseId == logier.EnterpriseId + && (request.CheckReceiveStatus == EnumTaskCheckReceiveStatus.WaitSubmit + ? !it.Submits.Any(s => s.Date.Date == request.Date.Value.Date) + : it.Submits.Any(s => + s.Date.Date == request.Date.Value.Date + && (request.CheckReceiveStatus == EnumTaskCheckReceiveStatus.WaitSubmit + ? s.CheckReceiveStatus == EnumTaskUserSubmitCheckReceiveStatus.WaitSubmit + : (request.CheckReceiveStatus == EnumTaskCheckReceiveStatus.WaitCheckReceive + ? s.CheckReceiveStatus == EnumTaskUserSubmitCheckReceiveStatus.WaitCheckReceive + : (s.CheckReceiveStatus == EnumTaskUserSubmitCheckReceiveStatus.Success + || s.CheckReceiveStatus == EnumTaskUserSubmitCheckReceiveStatus.Fail)))))); + } var s = q.Select(it => new GetCheckReceiveTaskQueryResultItem { - Id = it.TaskInfoId, + Id = it.Id, TaskInfoCode = it.TaskInfo.Code, TaskInfoName = it.TaskInfo.Name, Avatar = it.EnterpriseEmployee.User.Avatar, @@ -122,13 +170,22 @@ ContactPhoneNumber = it.EnterpriseEmployee.User.ContactPhoneNumber, IsReal = it.EnterpriseEmployee.User.IsReal, RealMethod = it.EnterpriseEmployee.User.RealMethod, - CheckReceiveStatus = it.CheckReceiveStatus, + CheckReceiveStatus = logier.Type == EnumUserType.Enterprise && logier.ClientType == EnumClientType.Wxmp && request.Date.HasValue + ? it.Submits + .Where(s => s.Date == request.Date) + .Select(s => (s.CheckReceiveStatus == EnumTaskUserSubmitCheckReceiveStatus.WaitSubmit + ? EnumTaskCheckReceiveStatus.WaitSubmit + : s.CheckReceiveStatus == EnumTaskUserSubmitCheckReceiveStatus.WaitCheckReceive + ? EnumTaskCheckReceiveStatus.WaitCheckReceive + : EnumTaskCheckReceiveStatus.Completed) as EnumTaskCheckReceiveStatus?) + .FirstOrDefault() ?? EnumTaskCheckReceiveStatus.WaitSubmit + : it.CheckReceiveStatus, LastSubmitTime = it.LastSubmitTime, }); var result = await request.PageModel.GetPagedListAsync<GetCheckReceiveTaskQueryResult, GetCheckReceiveTaskQueryResultItem>(s, cancellationToken); result.ObjectData = await repTaskInfo.AsQueryable().AsNoTracking() - .Where(it => it.Id == request.TaskInfoId) - .GetDetail<TaskInfo, GetCheckReceiveTaskQueryResultObjectData>(); + .Where(it => it.Id == request.TaskInfoId) + .GetDetail<TaskInfo, GetCheckReceiveTaskQueryResultObjectData>(); return result; } @@ -156,6 +213,8 @@ result.ObjectData = await repTaskInfoUser.AsQueryable().AsNoTracking() .Where(it => it.Id == request.Id) .GetDetail<TaskInfoUser, GetCheckReceiveTaskUserSubmitsQueryResultObjectData>(); + result.ObjectData.EnterpriseEmployeeUser.IsBindBankCard = await repTaskInfo.Change<UserBankCard>().AsQueryable().AsNoTracking() + .AnyAsync(it => it.UserId == result.ObjectData.EnterpriseEmployeeUser.Id); return result; } @@ -165,11 +224,27 @@ /// <param name="request"></param> /// <param name="cancellationToken"></param> /// <returns></returns> - public Task<GetCheckReceiveTaskUserSubmitQueryResult> Handle(GetCheckReceiveTaskUserSubmitQuery request, CancellationToken cancellationToken) + public async Task<GetCheckReceiveTaskUserSubmitQueryResult> Handle(GetCheckReceiveTaskUserSubmitQuery request, CancellationToken cancellationToken) { - return repTaskInfoUserSubmit.AsQueryable().AsNoTracking() - .Where(it => it.Id == request.Id) - .GetDetail<TaskInfoUserSubmit, GetCheckReceiveTaskUserSubmitQueryResult>(); + var q = repTaskInfoUserSubmit.AsQueryable().AsNoTracking(); + if (request.SubmitId.HasValue) + { + q = q.Where(it => it.Id == request.SubmitId.Value); + } + else if (request.Date.HasValue && request.TaskInfoId.HasValue) + { + q = q.Where(it => it.Date.Date == request.Date.Value.Date && it.TaskInfoUser.TaskInfoId == request.TaskInfoId.Value); + } + else if (request.Date.HasValue && request.TaskInfoUserId.HasValue) + { + q = q.Where(it => it.Date.Date == request.Date.Value.Date && it.TaskInfoUserId == request.TaskInfoUserId.Value); + } + var model = await q.GetDetail<TaskInfoUserSubmit, GetCheckReceiveTaskUserSubmitQueryResult>(); + model.Files = await repTaskInfoUserSubmit.Change<TaskInfoUserSubmitFile>().AsQueryable().AsNoTracking() + .Where(it => it.SubmitId == model.Id) + .Select(it => it.File) + .ToListAsync(); + return model; } } } -- Gitblit v1.9.1