From 56af0f468f321d41db70343abf558d61cda58d31 Mon Sep 17 00:00:00 2001
From: sunpengfei <i@angelzzz.com>
Date: 星期五, 05 九月 2025 15:40:20 +0800
Subject: [PATCH] feat:开发

---
 FlexJobApi.UserServer.Application/EnterpriseWallets/Queries/EnterpriseWalletQueryHandler.cs |  226 ++++++++++++++++++++++++++++++++++++++++++++++++--------
 1 files changed, 193 insertions(+), 33 deletions(-)

diff --git a/FlexJobApi.UserServer.Application/EnterpriseWallets/Queries/EnterpriseWalletQueryHandler.cs b/FlexJobApi.UserServer.Application/EnterpriseWallets/Queries/EnterpriseWalletQueryHandler.cs
index 140759f..05d4624 100644
--- a/FlexJobApi.UserServer.Application/EnterpriseWallets/Queries/EnterpriseWalletQueryHandler.cs
+++ b/FlexJobApi.UserServer.Application/EnterpriseWallets/Queries/EnterpriseWalletQueryHandler.cs
@@ -1,9 +1,12 @@
-锘縰sing FlexJobApi.Core;
+锘縰sing Aop.Api.Domain;
+using Azure;
+using FlexJobApi.Core;
 using Furion.DatabaseAccessor;
 using Furion.FriendlyException;
 using Mapster;
 using MediatR;
 using Microsoft.EntityFrameworkCore;
+using StackExchange.Redis;
 using System;
 using System.Collections.Generic;
 using System.Linq;
@@ -17,11 +20,18 @@
     /// </summary>
     public class EnterpriseWalletQueryHandler(
             IRepository<EnterpriseWallet> rep,
+            IRepository<EnterpriseWalletTransaction> repEnterpriseWalletTransaction,
+            IRepository<EnterpriseWalletExpandindirectOrder> repEnterpriseWalletExpandindirectOrder,
+            IRepository<Enterprise> repEnterprise,
             AlipayUtils alipayUtils
         ) :
-        IRequestHandler<GetEnterpriseWalletQuery, GetEnterpriseWalletQueryResult>
+        IRequestHandler<GetEnterpriseWalletQuery, GetEnterpriseWalletQueryResult>,
+        IRequestHandler<GetEnterpriseWalletTransactionQuery, GetEnterpriseWalletTransactionQueryResult>
     {
         private readonly IRepository<EnterpriseWallet> rep = rep;
+        private readonly IRepository<EnterpriseWalletTransaction> repEnterpriseWalletTransaction = repEnterpriseWalletTransaction;
+        private readonly IRepository<EnterpriseWalletExpandindirectOrder> repEnterpriseWalletExpandindirectOrder = repEnterpriseWalletExpandindirectOrder;
+        private readonly IRepository<Enterprise> repEnterprise = repEnterprise;
         private readonly AlipayUtils alipayUtils = alipayUtils;
 
         /// <summary>
@@ -30,44 +40,194 @@
         /// <param name="request"></param>
         /// <param name="cancellationToken"></param>
         /// <returns></returns>
+        [UnitOfWork(false)]
         public async Task<GetEnterpriseWalletQueryResult> Handle(GetEnterpriseWalletQuery request, CancellationToken cancellationToken)
         {
             var logier = JwtUtils.GetCurrentLogier();
-            var entity = await rep.AsQueryable()
-                .Where(it => it.EnterpriseId == logier.EnterpriseId && it.Access == request.Access)
-                .FirstOrDefaultAsync();
-            if (entity == null) throw Oops.Oh(EnumErrorCodeType.s404, "浼佷笟閽卞寘");
-            if (entity.SignStatus == EnumEnterpriseWalletSignStatus.Apply)
+            if (request.EnterpriseId == null || logier.Type == EnumUserType.Enterprise)
             {
-                var response = alipayUtils.UserAgreementQuery(new Aop.Api.Domain.AlipayUserAgreementQueryModel
-                {
-                    PersonalProductCode = entity.PersonalProductCode,
-                    SignScene = entity.SignScene,
-                    ExternalAgreementNo = entity.Code,
-                    ThirdPartyType = entity.ThirdPartyType,
-                });
-                if (response.IsError) throw Oops.Oh(EnumErrorCodeType.s510, response.SubMsg ?? response.Msg);
-                entity.AgreementNo = response.AgreementNo;
-                entity.SignTime = response.SignTime.ToDateTime();
-                entity.ValidTime = response.ValidTime.ToDateTime();
-                entity.InvalidTime = response.InvalidTime.ToDateTime();
-                entity.SignStatus = response.Status == "TEMP"
-                    ? EnumEnterpriseWalletSignStatus.Apply
-                    : response.Status == "NORMAL"
-                    ? EnumEnterpriseWalletSignStatus.Normal
-                    : response.Status == "STOP"
-                    ? EnumEnterpriseWalletSignStatus.Stop
-                    : throw Oops.Oh(EnumErrorCodeType.s510, "鐘舵�佸紓甯�");
-                entity.PricipalType = response.PricipalType;
-                entity.AlipayLogonId = response.AlipayLogonId;
-                entity.PrincipalId = response.PrincipalId;
-                entity.PrincipalOpenId = response.PrincipalOpenId;
-                entity.ZmOpenId = response.ZmOpenId;
-                entity.CreditAuthMode = response.CreditAuthMode;
-                await rep.UpdateAsync(entity);
+                request.EnterpriseId = logier.EnterpriseId;
             }
+            var enterprise = repEnterprise.AsQueryable().AsNoTracking()
+                .Where(it => it.Id == request.EnterpriseId)
+                .FirstOrDefault();
+            if (enterprise == null) throw Oops.Oh(EnumErrorCodeType.s404, "浼佷笟");
+            var entity = await rep.AsQueryable()
+                .Where(it => it.EnterpriseId == request.EnterpriseId && it.Access == request.Access)
+                .FirstOrDefaultAsync();
+            if (entity == null)
+            {
+                return new GetEnterpriseWalletQueryResult
+                {
+                    Access = request.Access,
+                    SignStatus = EnumEnterpriseWalletSignStatus.Wait,
+                    ExpandindirectOrderStatus = EnumEnterpriseWalletExpandindirectOrderStatus.Wait
+                };
+            }
+            var update = false;
+            if (entity.Access == EnumEnterpriseWalletAccess.Alipay)
+            {
+                if (entity.SignStatus == EnumEnterpriseWalletSignStatus.Apply)
+                {
+                    var response = alipayUtils.UserAgreementQuery(new Aop.Api.Domain.AlipayUserAgreementQueryModel
+                    {
+                        PersonalProductCode = entity.PersonalProductCode,
+                        SignScene = entity.SignScene,
+                        ExternalAgreementNo = entity.Code,
+                        ThirdPartyType = entity.ThirdPartyType,
+                    });
+                    if (response.IsError) throw Oops.Oh(EnumErrorCodeType.s510, response.SubMsg ?? response.Msg);
+                    entity.AgreementNo = response.AgreementNo;
+                    entity.SignTime = response.SignTime.ToDateTime();
+                    entity.ValidTime = response.ValidTime.ToDateTime();
+                    entity.InvalidTime = response.InvalidTime.ToDateTime();
+                    entity.SignStatus = response.Status == "TEMP"
+                        ? EnumEnterpriseWalletSignStatus.Apply
+                        : response.Status == "NORMAL"
+                        ? EnumEnterpriseWalletSignStatus.Normal
+                        : response.Status == "STOP"
+                        ? EnumEnterpriseWalletSignStatus.Stop
+                        : throw Oops.Oh(EnumErrorCodeType.s510, "鐘舵�佸紓甯�");
+                    entity.PricipalType = response.PricipalType;
+                    entity.AlipayLogonId = response.AlipayLogonId;
+                    entity.PrincipalId = response.PrincipalId;
+                    entity.PrincipalOpenId = response.PrincipalOpenId;
+                    entity.ZmOpenId = response.ZmOpenId;
+                    entity.CreditAuthMode = response.CreditAuthMode;
+                    update = true;
+                }
+
+                if (entity.SignStatus == EnumEnterpriseWalletSignStatus.Normal && entity.AccountBookStatus != EnumEnterpriseWalletAccountBookStatus.Normal)
+                {
+                    var response = alipayUtils.FundAccountbookCreate(new Aop.Api.Domain.AlipayFundAccountbookCreateModel
+                    {
+                        MerchantUserId = entity.Code,
+                        MerchantUserType = "BUSINESS_ORGANIZATION",
+                        SceneCode = "SATF_FUND_BOOK",
+                        ExtInfo = new
+                        {
+                            agreement_no = entity.AgreementNo,
+                            cert_no = enterprise.SocietyCreditCode
+                        }.ToJson()
+                    });
+                    if (response.IsError) throw Oops.Oh(EnumErrorCodeType.s510, response.SubMsg ?? response.Msg);
+                    entity.AccountBookId = response.AccountBookId;
+                    entity.BankAccName = response.ExtCardInfo.BankAccName;
+                    entity.CardBank = response.ExtCardInfo.CardBank;
+                    entity.CardBranch = response.ExtCardInfo.CardBranch;
+                    entity.CardDeposit = response.ExtCardInfo.CardDeposit;
+                    entity.CardLocation = response.ExtCardInfo.CardLocation;
+                    entity.CardNo = response.ExtCardInfo.CardNo;
+                    entity.AccountBookStatus = response.ExtCardInfo.Status == "A"
+                        ? EnumEnterpriseWalletAccountBookStatus.Normal
+                        : EnumEnterpriseWalletAccountBookStatus.Exception;
+                    update = true;
+                }
+
+                if (entity.AccountBookStatus == EnumEnterpriseWalletAccountBookStatus.Normal)
+                {
+                    var response = alipayUtils.FundAccountbookQuery(new AlipayFundAccountbookQueryModel
+                    {
+                        AccountBookId = entity.AccountBookId,
+                        SceneCode = "SATF_FUND_BOOK",
+                        MerchantUserId = entity.Code,
+                    });
+                    if (response.IsError) throw Oops.Oh(EnumErrorCodeType.s510, response.SubMsg ?? response.Msg);
+                    entity.Balance = response.AvailableAmount.ToDecimal() ?? 0;
+                    update = true;
+                }
+            }
+
+            if (update)
+            {
+                await rep.UpdateNowAsync(entity);
+            }
+
             var model = entity.Adapt<GetEnterpriseWalletQueryResult>();
+
+            var expandindirectOrder = await repEnterpriseWalletExpandindirectOrder.AsQueryable().AsNoTracking()
+                .OrderByDescending(it => it.CreatedTime)
+                .Where(it => it.WalletId == model.Id)
+                .Select(it => new
+                {
+                    it.OrderStatus
+                })
+                .FirstOrDefaultAsync();
+            model.ExpandindirectOrderStatus = expandindirectOrder == null
+                ? EnumEnterpriseWalletExpandindirectOrderStatus.Wait
+                : expandindirectOrder.OrderStatus;
+
             return model;
         }
+
+        /// <summary>
+        /// 鏌ヨ浼佷笟閽卞寘浜ゆ槗璇︽儏
+        /// </summary>
+        /// <param name="request"></param>
+        /// <param name="cancellationToken"></param>
+        /// <returns></returns>
+        public async Task<GetEnterpriseWalletTransactionQueryResult> Handle(GetEnterpriseWalletTransactionQuery request, CancellationToken cancellationToken)
+        {
+            var entity = await repEnterpriseWalletTransaction.AsQueryable()
+                .Where(it => it.Id == request.Id)
+                .FirstOrDefaultAsync();
+            if (entity == null) throw Oops.Oh(EnumErrorCodeType.s404, "浜ゆ槗");
+            var response = alipayUtils.FundTransCommonQuery(new Aop.Api.Domain.AlipayFundTransCommonQueryModel
+            {
+                ProductCode = entity.ProductCode,
+                BizScene = entity.BizScene,
+                OutBizNo = entity.Code
+            });
+            if (response.IsError) throw Oops.Oh(EnumErrorCodeType.s510, response.SubMsg ?? response.Msg);
+            entity.OrderId = response.OrderId;
+            entity.InflowSettleSerialNo = response.InflowSettleSerialNo;
+            entity.SettleSerialNo = response.SettleSerialNo;
+            entity.ReceiverOpenId = response.ReceiverOpenId;
+            entity.ReceiverUserId = response.ReceiverUserId;
+            entity.PayFundOrderId = response.PayFundOrderId;
+            entity.ArrivalTimeEnd = response.ArrivalTimeEnd.ToDateTime();
+            entity.OrderFee = response.OrderFee.ToDecimal();
+            entity.ErrorCode = response.ErrorCode;
+            entity.FailReason = response.FailReason;
+            entity.FailInstReason = response.FailInstReason;
+            entity.FailInstName = response.FailInstName;
+            entity.FailInstErrorCode = response.FailInstErrorCode;
+            entity.SubStatus = response.SubStatus;
+            entity.TransDate = response.PayDate.ToDateTime();
+            entity.Status = response.Status;
+            entity.TransactionStatus = response.Status == "SUCCESS"
+                ? EnumEnterpriseWalletTransactionStatus.Success
+                : response.Status == "DEALING"
+                ? EnumEnterpriseWalletTransactionStatus.Dealing
+                : response.Status == "REFUND"
+                ? EnumEnterpriseWalletTransactionStatus.Refund
+                : response.Status == "FAIL"
+                ? EnumEnterpriseWalletTransactionStatus.Fail
+                : throw Oops.Oh(EnumErrorCodeType.s510, $"鏈瘑鍒殑鐘舵�侊細{response.Status}");
+            await repEnterpriseWalletTransaction.UpdateAsync(entity);
+            if (entity.TransactionStatus == EnumEnterpriseWalletTransactionStatus.Success)
+            {
+                await GetBalance(entity.WalletId);
+            }
+            return entity.Adapt<GetEnterpriseWalletTransactionQueryResult>();
+        }
+
+        private async Task GetBalance(Guid id)
+        {
+            var entity = await rep.AsQueryable()
+                .Where(it => it.Id == id)
+                .FirstOrDefaultAsync();
+            if (entity == null) throw Oops.Oh(EnumErrorCodeType.s404, "浼佷笟閽卞寘");
+            var response = alipayUtils.FundAccountbookQuery(new AlipayFundAccountbookQueryModel
+            {
+                AccountBookId = entity.AccountBookId,
+                SceneCode = "SATF_FUND_BOOK",
+                MerchantUserId = entity.Code,
+            });
+            if (response.IsError) throw Oops.Oh(EnumErrorCodeType.s510, response.SubMsg ?? response.Msg);
+            entity.Balance = response.AvailableAmount.ToDecimal() ?? 0;
+            await rep.UpdateNowAsync(entity);
+        }
+
     }
 }

--
Gitblit v1.9.1