feat:开发

sunpengfei

12 小时以前 5c45bc53e2c18e45130c21048df4af4896455c6d

 FlexJobApi.FlexJobServer.Application/TaskCheckReceives/Queries/TaskCheckReceiveQueryHandler.cs

@@ -1,5 +1,7 @@
using FlexJobApi.Core;
using Aop.Api.Domain;
using FlexJobApi.Core;
using Furion.DatabaseAccessor;
using Furion.DistributedIDGenerator;
using Furion.FriendlyException;
using Mapster;
using MediatR;
@@ -9,6 +11,7 @@
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using TaskInfo = FlexJobApi.Core.TaskInfo;

namespace FlexJobApi.FlexJobServer.Application
{
@@ -18,6 +21,7 @@
    public class TaskCheckReceiveQueryHandler(
        IRepository<TaskInfo> repTaskInfo,
        IRepository<TaskInfoUser> repTaskInfoUser,
        IRepository<User> repUser,
        IRepository<TaskInfoUserSubmit> repTaskInfoUserSubmit) :
        IRequestHandler<GetCheckReceiveTasksQuery, GetCheckReceiveTasksQueryResult>,
        IRequestHandler<GetCheckReceiveTaskQuery, GetCheckReceiveTaskQueryResult>,
@@ -38,9 +42,8 @@
        {
            var now = DateTime.Now;
            var logier = JwtUtils.GetCurrentLogier();
            var q = repTaskInfo.AsQueryable().AsNoTracking()
                .OrderBy(it => it.CreatedTime)
                .Where(it => it.BeginTime <= now.Date && now.Date <= it.EndTime);
            IQueryable<TaskInfo> q = repTaskInfo.AsQueryable().AsNoTracking()
                .OrderBy(it => it.CreatedTime);

            if (logier.Type == EnumUserType.Personal)
            {
@@ -78,7 +81,8 @@
                    && 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 => s.Date.Date == request.Date.Value.Date)
                        || tu.Submits.Any(s => s.Date.Date == request.Date.Value.Date && s.CheckReceiveStatus == EnumTaskUserSubmitCheckReceiveStatus.WaitSubmit))
                        : tu.Submits.Any(s =>
                            s.Date.Date == request.Date.Value.Date
                            && (request.CheckReceiveStatus == EnumTaskCheckReceiveStatus.WaitSubmit
@@ -130,7 +134,7 @@
            var logier = JwtUtils.GetCurrentLogier();
            var q = repTaskInfoUser.AsQueryable().AsNoTracking()
                .OrderBy(it => it.CreatedTime)
                .Where(it => it.TaskInfoId == request.TaskInfoId);
                .Where(it => it.TaskInfoId == request.TaskInfoId && it.ArrangeStatus == EnumTaskUserArrangeStatus.Complete);

            if (logier.Type == EnumUserType.Personal)
            {
@@ -153,7 +157,8 @@
                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)
                        || it.Submits.Any(s => s.Date.Date == request.Date.Value.Date && s.CheckReceiveStatus == EnumTaskUserSubmitCheckReceiveStatus.WaitSubmit))
                        : it.Submits.Any(s =>
                            s.Date.Date == request.Date.Value.Date
                            && (request.CheckReceiveStatus == EnumTaskCheckReceiveStatus.WaitSubmit
@@ -201,49 +206,75 @@
        /// <param name="request"></param>
        /// <param name="cancellationToken"></param>
        /// <returns></returns>
        [UnitOfWork(false)]
        public async Task<GetCheckReceiveTaskUserSubmitsQueryResult> Handle(GetCheckReceiveTaskUserSubmitsQuery request, CancellationToken cancellationToken)
        {
            var logier = JwtUtils.GetCurrentLogier();
            var q = repTaskInfoUserSubmit.AsQueryable().AsNoTracking()
                .OrderByDescending(it => it.CreatedTime)
                .AsQueryable();
            TaskInfoUser? taskUser = null;
            if (logier.Type == EnumUserType.Personal)
            {
                if (request.TaskInfoId == null) throw Oops.Oh(EnumErrorCodeType.s400, "请选择任务");
                q = q.Where(it => it.TaskInfoUser.TaskInfoId == request.TaskInfoId && it.TaskInfoUser.EnterpriseEmployee.UserId == logier.Id);
                if (request.TaskInfoId == null) throw Oops.Oh(EnumErrorCodeType.s404, "任务");
                taskUser = await repTaskInfoUser.AsQueryable()
                    .Include(it => it.TaskInfo)
                    .Include(it => it.EnterpriseEmployee).ThenInclude(it => it.User)
                    .Where(it =>
                        it.TaskInfoId == request.TaskInfoId
                        && it.EnterpriseEmployee.UserId == logier.Id)
                    .FirstOrDefaultAsync();
            }
            else
            {
                if (request.Id == null) throw Oops.Oh(EnumErrorCodeType.s400, "请选择灵工");
                q = q.Where(it => it.TaskInfoUserId == request.Id);
            }
            var s = q.Select(it => new GetCheckReceiveTaskUserSubmitsQueryResultItem
            {
                Id = it.Id,
                CreatedTime = it.CreatedTime,
                Files = it.Files.Select(f => f.File).ToList(),
                CheckReceiveStatus = it.CheckReceiveStatus,
                CheckReceiveTime = it.CheckReceiveTime,
            });
            var result = await request.PageModel.GetPagedListAsync<GetCheckReceiveTaskUserSubmitsQueryResult, GetCheckReceiveTaskUserSubmitsQueryResultItem>(s, cancellationToken);
            if (request.Id.HasValue)
            {
                result.ObjectData = await repTaskInfoUser.AsQueryable().AsNoTracking()
                taskUser = await repTaskInfoUser.AsQueryable()
                    .Include(it => it.TaskInfo)
                    .Include(it => it.EnterpriseEmployee).ThenInclude(it => it.User)
                    .Where(it => it.Id == request.Id)
                    .GetDetail<TaskInfoUser, GetCheckReceiveTaskUserSubmitsQueryResultObjectData>();
                    .FirstOrDefaultAsync();
            }
            else if (request.TaskInfoId.HasValue)
            if (taskUser == null) throw Oops.Oh(EnumErrorCodeType.s404, "任务");
            var q = repTaskInfoUserSubmit.AsQueryable().AsNoTracking()
                .Include(it => it.Files)
                .OrderByDescending(it => it.Date)
                .Where(it => it.TaskInfoUserId == taskUser.Id);
            var dates = await q
                .Select(it => it.Date)
                .ToListAsync();
            for (DateTime i = taskUser.TaskInfo.BeginTime.Date; i <= taskUser.TaskInfo.EndTime.Date; i = i.AddDays(1))
            {
                result.ObjectData = await repTaskInfoUser.AsQueryable().AsNoTracking()
                    .Where(it => it.TaskInfoId == request.TaskInfoId)
                    .GetDetail<TaskInfoUser, GetCheckReceiveTaskUserSubmitsQueryResultObjectData>();
                if (!dates.Contains(i))
                {
                    var entity = new TaskInfoUserSubmit
                    {
                        TaskInfoUserId = taskUser.Id,
                        Date = i,
                        CheckReceiveStatus = EnumTaskUserSubmitCheckReceiveStatus.WaitSubmit
                    };
                    await repTaskInfoUserSubmit.InsertNowAsync(entity);
                }
            }
            if (result.ObjectData != null)

            var s = q
                .Select(it => new GetCheckReceiveTaskUserSubmitsQueryResultItem
                {
                    Id = it.Id,
                    Date = it.Date,
                    CreatedTime = it.CheckReceiveStatus == EnumTaskUserSubmitCheckReceiveStatus.WaitSubmit
                        ? null
                        : it.CreatedTime,
                    Files = it.Files.Select(f => f.File).ToList(),
                    CheckReceiveStatus = it.CheckReceiveStatus,
                    CheckReceiveTime = it.CheckReceiveTime,
                });
            var result = await request.PageModel.GetPagedListAsync<GetCheckReceiveTaskUserSubmitsQueryResult, GetCheckReceiveTaskUserSubmitsQueryResultItem>(s, cancellationToken);

            result.ObjectData = new GetCheckReceiveTaskUserSubmitsQueryResultObjectData
            {
                result.ObjectData.EnterpriseEmployeeUser.IsBindBankCard = await repTaskInfo.Change<UserBankCard>()
                    .AsQueryable().AsNoTracking()
                    .AnyAsync(it => it.UserId == result.ObjectData.EnterpriseEmployeeUser.Id);
            }
                EnterpriseEmployeeUser = taskUser.EnterpriseEmployee.User.Adapt<GetCheckReceiveTaskUserSubmitsQueryResultObjectDataEnterpriseEmployeeUser>(),
                TaskInfo = taskUser.TaskInfo.Adapt<GetCheckReceiveTaskUserSubmitsQueryResultObjectDataTaskInfo>()
            };
            result.ObjectData.EnterpriseEmployeeUser.IsBindBankCard = await repTaskInfo.Change<UserBankCard>()
                .AsQueryable().AsNoTracking()
                .AnyAsync(it => it.UserId == result.ObjectData.EnterpriseEmployeeUser.Id);
            return result;
        }

@@ -255,20 +286,82 @@
        /// <returns></returns>
        public async Task<GetCheckReceiveTaskUserSubmitQueryResult> Handle(GetCheckReceiveTaskUserSubmitQuery request, CancellationToken cancellationToken)
        {
            var q = repTaskInfoUserSubmit.AsQueryable().AsNoTracking();
            var logier = JwtUtils.GetCurrentLogier();
            TaskInfoUserSubmit? entity = null;
            var q = repTaskInfoUserSubmit.AsQueryable();
            if (request.SubmitId.HasValue)
            {
                q = q.Where(it => it.Id == request.SubmitId.Value);
                entity = await q.FirstOrDefaultAsync();
                if (entity == null)
                {
                    throw Oops.Oh(EnumErrorCodeType.s404, "提交信息");
                }
            }
            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);
                var taskUser = await repTaskInfoUser.AsQueryable().AsNoTracking()
                    .Where(it =>
                        it.EnterpriseEmployee.UserId == logier.Id
                        && it.TaskInfoId == request.TaskInfoId)
                    .FirstOrDefaultAsync();
                if (taskUser == null) throw Oops.Oh(EnumErrorCodeType.s404, "任务");
                q = q.Where(it =>
                    it.Date.Date == request.Date.Value.Date
                    && it.TaskInfoUserId == taskUser.Id);
                entity = await q.FirstOrDefaultAsync();
                if (entity == null)
                {
                    entity = new TaskInfoUserSubmit
                    {
                        Id = IDGen.NextID(),
                        TaskInfoUserId = taskUser.Id,
                        Date = request.Date.Value.Date,
                        CheckReceiveStatus = EnumTaskUserSubmitCheckReceiveStatus.WaitSubmit,
                        CreatedTime = DateTime.Now
                    };
                    await repTaskInfoUserSubmit.InsertAsync(entity);
                }
            }
            else if (request.Date.HasValue && request.TaskInfoUserId.HasValue)
            {
                q = q.Where(it => it.Date.Date == request.Date.Value.Date && it.TaskInfoUserId == request.TaskInfoUserId.Value);
                q = q.Where(it =>
                    it.Date.Date == request.Date.Value.Date
                    && it.TaskInfoUserId == request.TaskInfoUserId.Value);
                entity = await q.FirstOrDefaultAsync();
                if (entity == null)
                {
                    entity = new TaskInfoUserSubmit
                    {
                        Id = IDGen.NextID(),
                        TaskInfoUserId = request.TaskInfoUserId.Value,
                        Date = request.Date.Value.Date,
                        CheckReceiveStatus = EnumTaskUserSubmitCheckReceiveStatus.WaitSubmit,
                        CreatedTime = DateTime.Now
                    };
                    await repTaskInfoUserSubmit.InsertAsync(entity);
                }
            }
            var model = await q.GetDetail<TaskInfoUserSubmit, GetCheckReceiveTaskUserSubmitQueryResult>();
            if (entity == null)
            {
                throw Oops.Oh(EnumErrorCodeType.s404, "提交信息");
            }

            var model = new GetCheckReceiveTaskUserSubmitQueryResult
            {
                Id = entity.Id,
                Date = entity.Date,
                CreatedTime = entity.CreatedTime,
                CheckReceiveStatus = entity.CheckReceiveStatus,
            };
            if (model.CheckReceiveStatus == EnumTaskUserSubmitCheckReceiveStatus.WaitSubmit)
            {
                model.CreatedTime = null;
            }
            model.TaskInfoUserEnterpriseEmployeeUser = await repUser.AsQueryable().AsNoTracking()
                .Where(it => it.EnterpriseEmployees.Any(ee => ee.TaskInfoUsers.Any(tu => tu.Id == entity.TaskInfoUserId)))
                .ProjectToType<GetCheckReceiveTaskUserSubmitsQueryResultObjectDataEnterpriseEmployeeUser>()
                .FirstOrDefaultAsync();
            model.Files = await repTaskInfoUserSubmit.Change<TaskInfoUserSubmitFile>().AsQueryable().AsNoTracking()
                .Where(it => it.SubmitId == model.Id)
                .Select(it => it.File)