From 6001ccc7e7052b64931235b65a8b5d02f35ad1bd Mon Sep 17 00:00:00 2001 From: sunpengfei <i@angelzzz.com> Date: 星期四, 14 八月 2025 09:56:24 +0800 Subject: [PATCH] feat:开发 --- FlexJobApi.FlexJobServer.Application/TaskCheckReceives/Commands/TaskCheckReceiveCommandHandler.cs | 50 +++++++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 49 insertions(+), 1 deletions(-) diff --git a/FlexJobApi.FlexJobServer.Application/TaskCheckReceives/Commands/TaskCheckReceiveCommandHandler.cs b/FlexJobApi.FlexJobServer.Application/TaskCheckReceives/Commands/TaskCheckReceiveCommandHandler.cs index aae3fb4..761c75c 100644 --- a/FlexJobApi.FlexJobServer.Application/TaskCheckReceives/Commands/TaskCheckReceiveCommandHandler.cs +++ b/FlexJobApi.FlexJobServer.Application/TaskCheckReceives/Commands/TaskCheckReceiveCommandHandler.cs @@ -20,7 +20,8 @@ IRepository<TaskInfoUserSubmit> repTaskInfoUserSubmit ) : IRequestHandler<SubmitCheckReceiveTaskCommand, Guid>, - IRequestHandler<CheckReceiveTaskCommand, Guid> + IRequestHandler<CheckReceiveTaskCommand, Guid>, + IRequestHandler<ExportTaskCheckReceiveTaskUsersCommand, string> { private readonly IRepository<TaskInfo> repTaskInfo = repTaskInfo; private readonly IRepository<TaskInfoUser> repTaskInfoUser = repTaskInfoUser; @@ -154,5 +155,52 @@ await repTaskInfoUserSubmit.UpdateAsync(submit); return submit.Id; } + + /// <summary> + /// 瀵煎嚭楠屾敹璁板綍 + /// </summary> + /// <param name="request"></param> + /// <param name="cancellationToken"></param> + /// <returns></returns> + public async Task<string> Handle(ExportTaskCheckReceiveTaskUsersCommand request, CancellationToken cancellationToken) + { + var models = await repTaskInfoUserSubmit.AsQueryable().AsNoTracking() + .Where(it => it.TaskInfoUser.TaskInfoId == request.Id) + .Select(it => new ExportTaskCheckReceiveTaskUsersCommandModel + { + UserId = it.TaskInfoUser.EnterpriseEmployee.UserId!.Value, + Name = it.TaskInfoUser.EnterpriseEmployee.User.Name, + Identity = it.TaskInfoUser.EnterpriseEmployee.User.Identity, + ContactPhoneNumber = it.TaskInfoUser.EnterpriseEmployee.User.ContactPhoneNumber, + CheckReceiveStatus = it.CheckReceiveStatus, + CheckReceiveTime = it.CheckReceiveTime, + Bank = "123", + Code = "456" + }) + .ToListAsync(cancellationToken); + if (models.IsNotNull()) + { + var userIds = models.DistinctSelect(it => it.UserId); + var bankCards = await repTaskInfoUserSubmit.Change<UserBankCard>().AsQueryable().AsNoTracking() + .Where(it => userIds.Contains(it.UserId)) + .Select(it => new + { + it.UserId, + it.Bank, + it.Code + }) + .ToListAsync(cancellationToken); + foreach (var model in models) + { + var bankCard = bankCards.FirstOrDefault(it => it.UserId == model.UserId); + model.Bank = bankCard?.Bank; + model.Code = bankCard?.Code; + } + } + + var url = await models.ExportExcelToOSS("TaskCheckReceive/Export", "楠屾敹璁板綍.xlsx"); + url = AliyunOSSUtils.GetUrl(url); + return url; + } } } -- Gitblit v1.9.1