From f677ae3dff51661e4cc0607b9863b859dbccd204 Mon Sep 17 00:00:00 2001
From: zhengyuxuan <zhengyuxuan1995>
Date: 星期四, 20 三月 2025 18:04:07 +0800
Subject: [PATCH] fix:退款申请时间

---
 LifePayment/LifePayment.Application/LifePay/LifePayService.cs |  215 +++++++++++++++++++++++++++++++++++++++++++++++++----
 1 files changed, 198 insertions(+), 17 deletions(-)

diff --git a/LifePayment/LifePayment.Application/LifePay/LifePayService.cs b/LifePayment/LifePayment.Application/LifePay/LifePayService.cs
index e3fc6ef..b10cf07 100644
--- a/LifePayment/LifePayment.Application/LifePay/LifePayService.cs
+++ b/LifePayment/LifePayment.Application/LifePay/LifePayService.cs
@@ -19,7 +19,12 @@
 using Volo.Abp.EventBus.Distributed;
 using Z.EntityFramework.Plus;
 using ZeroD.Util;
+using Alipay.EasySDK.Payment.Common.Models;
 using static LifePayment.Domain.Shared.LifePaymentConstant;
+using ZeroD.Util.Fadd;
+using Nest;
+using Volo.Abp.Domain.Entities;
+using Volo.Abp.ObjectMapping;
 
 namespace LifePayment.Application;
 
@@ -33,6 +38,7 @@
     private readonly IRepository<LifePayOrder, Guid> _lifePayOrderRepository;
     private readonly IRepository<LifePayUser, Guid> _lifePayUserRepository;
     private readonly IRepository<LifePayIntroInfo, Guid> _lifePayIntroInfoRepository;
+    private readonly IRepository<DallyStatistics, Guid> _dallyStatisticsRepository;
     private readonly IRepository<LifePayChannles, Guid> _lifePayChannlesRep;
     private readonly IRepository<LifePayAccount, Guid> _lifePayAccount;
     private readonly IDataFilter dataFilter;
@@ -51,6 +57,7 @@
                           IRepository<LifePayUser, Guid> lifePayUserRepository,
                           IRepository<LifePayPremium, Guid> lifePayPremiumRepository,
                           IRepository<LifePayIntroInfo, Guid> lifePayIntroInfoRepository,
+                          IRepository<DallyStatistics, Guid> dallyStatisticsRepository,
                           IAliPayApi aliPayApi,
                           IWxPayApi wxPayApi,
                           IOptions<WxPayOption> wxPayOptions,
@@ -66,6 +73,7 @@
         _lifePayUserRepository = lifePayUserRepository;
         _lifePayPremiumRepository = lifePayPremiumRepository;
         _lifePayIntroInfoRepository = lifePayIntroInfoRepository;
+        _dallyStatisticsRepository = dallyStatisticsRepository;
         _aliPayApi = aliPayApi;
         _wxPayApi = wxPayApi;
         _wxPayOptions = wxPayOptions.Value;
@@ -77,6 +85,38 @@
     }
 
     #region 鏌ヨ
+
+    public async Task<TopStatisticsOutput> GetTopStatistics()
+    {
+        var today = DateTime.Now.ToString("yyyy-MM-dd");
+        var statistics = await _dallyStatisticsRepository.Where(x => x.CreationTime.ToString("yyyy-MM-dd") == today).FirstOrDefaultAsync();
+        if (statistics == null)
+        {
+            //var accumulatedReceipts = await _lifePayOrderRepository.Where(x => x.CreationTime < today).SumAsync(x => x.PayAmount);
+
+            var entity = new DallyStatistics()
+            {
+                Id = GuidGenerator.Create(),
+                CreationTime = DateTime.Now,
+                Amount = "0",
+                AccumulatedReceipts = "0",
+                ReceiptsYesterda = "0",
+                AccumulatedOrders = "0",
+                OrdersNumYesterda = "0",
+                YesterdaSuccess = "0",
+                YesterdaFail = "0",
+                AccumulatedUsers = "0",
+            };
+
+            return new TopStatisticsOutput();
+        }
+        else
+        {
+            var result = ObjectMapper.Map<DallyStatistics,TopStatisticsOutput>(statistics);
+            return result;
+        }
+
+    }
 
     /// <summary>
     /// 鑾峰彇鐢佃垂闈㈠��
@@ -166,7 +206,8 @@
     {
         return await _channelFilter.GetChannelLifePayUserFilter(_lifePayUserRepository).Where(x => x.IsDeleted == false)
             .WhereIf(!string.IsNullOrEmpty(input.QueryCondition), x => x.PhoneNumber.Contains(input.QueryCondition) || x.Name.Contains(input.QueryCondition))
-            .WhereIf(input.CreationTime.HasValue, x => x.CreationTime.ToString("yyyy-MM-dd") == input.CreationTime.Value.ToString("yyyy-MM-dd"))
+            .WhereIf(input.CreationTimeBegin.HasValue, x => x.CreationTime >= input.CreationTimeBegin)
+            .WhereIf(input.CreationTimeEnd.HasValue, x => x.CreationTime <= input.CreationTimeEnd)
                                             .Select(x =>
                                                    new UserListOutput()
                                                    {
@@ -209,7 +250,6 @@
                                     })
                                     .GetPageResult(input.PageModel);
         }
-
     }
 
     /// <summary>
@@ -219,7 +259,6 @@
     /// <returns></returns>
     public async Task<PageOutput<LifePayOrderListOutput>> GetLifePayOrderPage(QueryLifePayOrderListInput input)
     {
-
         var result = await (from a in _channelFilter.GetChannelLifePayOrderFilter(_lifePayOrderRepository)
                       .WhereIf(input.BeginFinishTime.HasValue, x => x.FinishTime >= input.BeginFinishTime)
                                             .WhereIf(input.EndFinishTime.HasValue, x => x.FinishTime <= input.EndFinishTime)
@@ -255,8 +294,105 @@
                                 RefundCheckRemark = a.RefundCheckRemark,
                                 RefundApplyRemark = a.RefundApplyRemark,
                                 RefundTime = a.RefundTime,
-                                ChannelName = b.ChannlesName
+                                ChannelName = b.ChannlesName,
+                                ActualRechargeAmount = a.ActualRechargeAmount,
+                                PlatformDeductionAmount = a.PlatformDeductionAmount,
+                                ACOOLYStatus = a.ACOOLYStatus,
+                                LifePayRefundStatus = a.LifePayRefundStatus,
                             }).GetPageResult(input.PageModel);
+
+        return result;
+    }
+
+    public async Task<LifePayOrderOutput> GetLifePayOrderDetail(string orderNo)
+    {
+        var order = await _lifePayOrderRepository.Where(x => x.OrderNo == orderNo).FirstOrDefaultAsync();
+        var platformRate = await _lifePayRateRepository.FirstOrDefaultAsync(r => r.RateType == LifePayRateTypeEnum.渚涘簲鍟嗘姌鎵d环);
+        var channle = await _lifePayChannlesRep.FirstOrDefaultAsync(r => r.ChannlesNum == order.ChannelId);
+        var premium = await _lifePayPremiumRepository.Where(x => x.IsDeleted == false && x.PremiumType == order.LifePayType).FirstOrDefaultAsync();
+        CheckExtensions.IfTrueThrowUserFriendlyException(order == null, "璁㈠崟涓嶅瓨鍦�");
+        var user = await _lifePayUserRepository.FirstOrDefaultAsync(x => x.Id == order.UserId);
+        
+        var channlesRakePrice = (order.PayAmount - (order.PlatformDeductionAmount == null ? 0 : order.PlatformDeductionAmount)) * channle.ChannlesRakeRate / 100;
+        var result = new LifePayOrderOutput()
+                {
+            UserName = user.Name,
+            UserPhoneNumber = user.PhoneNumber,
+            DiscountAmount = order.DiscountAmount,
+            FinishTime = order.FinishTime,
+            Id = order.Id,
+            OutOrderNo = order.OutOrderNo,
+            LifePayChannle = channle.ChannlesName,
+            Status = order.LifePayOrderStatus,
+            LifePayOrderType = order.LifePayOrderType,
+            LifePayType = order.LifePayType,
+            OrderNo = order.OrderNo,
+            PayAmount = order.PayAmount,
+            RechargeAmount = order.RechargeAmount,
+            PayStatus = order.PayStatus,
+            PayTime = order.PayTime,
+            OrderParamDetailJsonStr = order.OrderParamDetailJsonStr,
+            RefundCredentialsImgUrl = order.RefundCredentialsImgUrl.GetOssPath(),
+            CreationTime = order.CreationTime,
+            RefundCheckRemark = order.RefundCheckRemark,
+            RefundApplyRemark = order.RefundApplyRemark,
+            RefundTime = order.RefundTime,
+            ACOOLYOrderNo = order.ACOOLYOrderNo,
+            LifePayRefundStatus = order.LifePayRefundStatus,
+            ActualRechargeAmount = order.ActualRechargeAmount,
+            RefundPrice = order.RefundPrice,
+            PlatformRate = platformRate.Rate,
+            PlatformPrice = order.PlatformDeductionAmount,
+            ChannleRate = channle.ChannlesRate,
+            ChannlesRakeRate = channle.ChannlesRakeRate,
+            ChannlesRakePrice = channlesRakePrice.HasValue ? 0 : Math.Round(channlesRakePrice.Value, 2),
+            PremiumRate = premium == null ? 0 : premium.Rate,
+            PremiumPrice = premium == null ? 0 : Math.Round(order.PayAmount * premium.Rate, 2),
+            Profit = (order.PayAmount - order.PlatformDeductionAmount) * (1.00m - channle.ChannlesRakeRate / 100) - (premium == null ? 0 : Math.Round(order.PayAmount * premium.Rate, 2))
+        };
+
+        return result;
+    }
+
+    public async Task<LifePayRefundOrderOutput> GetLifePayRefundOrderDetail(string orderNo)
+    {
+        var order = await _lifePayOrderRepository.Where(x => x.OrderNo == orderNo).FirstOrDefaultAsync();
+        var platformRate = await _lifePayRateRepository.FirstOrDefaultAsync(r => r.RateType == LifePayRateTypeEnum.渚涘簲鍟嗘姌鎵d环);
+        var channle = await _lifePayChannlesRep.FirstOrDefaultAsync(r => r.ChannlesNum == order.ChannelId);
+        var premium = await _lifePayPremiumRepository.Where(x => x.IsDeleted == false && x.PremiumType == order.LifePayType).FirstOrDefaultAsync();
+        CheckExtensions.IfTrueThrowUserFriendlyException(order == null, "璁㈠崟涓嶅瓨鍦�");
+        var user = await _lifePayUserRepository.FirstOrDefaultAsync(x => x.Id == order.UserId);
+
+        var channlesRakePrice = (order.PayAmount - (order.PlatformDeductionAmount == null ? 0 : order.PlatformDeductionAmount)) * channle.ChannlesRakeRate / 100;
+        var result = new LifePayRefundOrderOutput()
+        {
+            UserName = user.Name,
+            UserPhoneNumber = user.PhoneNumber,
+            DiscountAmount = order.DiscountAmount,
+            FinishTime = order.FinishTime,
+            Id = order.Id,
+            OutOrderNo = order.OutOrderNo,
+            LifePayChannle = channle.ChannlesName,
+            Status = order.LifePayOrderStatus,
+            LifePayOrderType = order.LifePayOrderType,
+            LifePayType = order.LifePayType,
+            OrderNo = order.OrderNo,
+            PayAmount = order.PayAmount,
+            RechargeAmount = order.RechargeAmount,
+            PayStatus = order.PayStatus,
+            PayTime = order.PayTime,
+            RefundCredentialsImgUrl = order.RefundCredentialsImgUrl.GetOssPath(),
+            CreationTime = order.CreationTime,
+            RefundCheckRemark = order.RefundCheckRemark,
+            RefundApplyRemark = order.RefundApplyRemark,
+            RefundApplyTime = order.RefundApplyTime,
+            RefundTime = order.RefundTime,
+            RefundOrderNo = order.RefundOrderNo,
+            ACOOLYOrderNo = order.ACOOLYOrderNo,
+            LifePayRefundStatus = order.LifePayRefundStatus,
+            ActualRechargeAmount = order.ActualRechargeAmount,
+            RefundPrice = order.RefundPrice,
+        };
 
         return result;
     }
@@ -337,6 +473,8 @@
 
         return result;
     }
+
+
 
     /// <summary>
     /// 鏍规嵁璁㈠崟鍙疯幏鍙栨敮浠樼姸鎬�
@@ -550,7 +688,7 @@
 
         var orderInput = new CreateLifePayOrderInput
         {
-            OrderNo = CreateOrderNo(),
+            OrderNo = channle.ChannlesNum + CreateOrderNo(),
             LifePayOrderStatus = LifePayOrderStatusEnum.寰呯‘璁�,
             LifePayOrderType = LifePayOrderTypeEnum.璇濊垂璁㈠崟,
             //LifePayType = input.LifePayType,
@@ -594,7 +732,7 @@
 
         var orderInput = new CreateLifePayOrderInput
         {
-            OrderNo = CreateOrderNo(),
+            OrderNo = channle.ChannlesNum + CreateOrderNo(),
             LifePayOrderStatus = LifePayOrderStatusEnum.寰呯‘璁�,
             LifePayOrderType = LifePayOrderTypeEnum.鐢佃垂璁㈠崟,
             // LifePayType = input.LifePayType,
@@ -638,7 +776,7 @@
 
         var orderInput = new CreateLifePayOrderInput
         {
-            OrderNo = CreateOrderNo(),
+            OrderNo = channle.ChannlesNum + CreateOrderNo(),
             LifePayOrderStatus = LifePayOrderStatusEnum.寰呯‘璁�,
             LifePayOrderType = LifePayOrderTypeEnum.鐕冩皵璁㈠崟,
             // LifePayType = input.LifePayType,
@@ -872,10 +1010,12 @@
                 OpenId = openid
             }
         };
+        Logger.LogError("璋冪敤璇锋眰锛�" + req.ToJson());
         var timestamp = DateTimeOffset.Now.ToUnixTimeSeconds();
         string nonce = Guid.NewGuid().ToString();
 
         var res = await _wxPayApi.PayTransactionsJsAPI(req);
+        Logger.LogError("璋冪敤缁撴灉锛�" + res.ToJson());
         string package = "prepay_id=" + res.PrepayId;
         ModelPaymentMiniPay info = new ModelPaymentMiniPay();
         if (res != null)
@@ -966,7 +1106,7 @@
     /// <param name="orderNo"></param>
     /// <param name="outOrderNo"></param>
     /// <returns></returns>
-    public async Task ACOOLYOrderNotifyHandler(string orderNo, string acoolyOrderNo, LifePayOrderStatusEnum status)
+    public async Task ACOOLYOrderNotifyHandler(string orderNo, string acoolyOrderNo, LifePayOrderStatusEnum status, ACOOLYStatusEnum acoolyStatus, decimal payAmount)
     {
         var order = await _lifePayOrderRepository.Where(x => x.OrderNo == orderNo).FirstOrDefaultAsync();
         CheckExtensions.IfTrueThrowUserFriendlyException(order == null, "璁㈠崟涓嶅瓨鍦�");
@@ -977,6 +1117,8 @@
         }
 
         order.LifePayOrderStatus = status;
+        order.ACOOLYStatus = acoolyStatus;
+        order.PlatformDeductionAmount = payAmount;
         if (acoolyOrderNo.IsNotNullOrEmpty())
         {
             order.ACOOLYOrderNo = acoolyOrderNo;
@@ -991,6 +1133,7 @@
         {
             order.PayStatus = LifePayStatusEnum.寰呴��娆�;
         }
+
 
         await _lifePayOrderRepository.UpdateAsync(order);
     }
@@ -1016,15 +1159,50 @@
             throw new UserFriendlyException("褰撳墠璁㈠崟鐘舵�佹棤娉曢��娆�");
         }
 
-        /// TODO 閫�娆捐姹傚畬鎴愬悗濡備綍鎿嶄綔
-        /// var refundResult = await WxPayDomesticRefunds(order.OrderNo, order.RefundApplyRemark, Convert.ToInt32(order.PayAmount * 100), Convert.ToInt32(order.PayAmount * 100));
+        var outRefundNo = order.ChannelId + CreateRefundOrderNo();
+        order.RefundOrderNo = outRefundNo;
+        switch (order.LifePayType)
+        {
+            case LifePayTypeEnum.WxPay:
+                var wxRefundResult = await WxPayDomesticRefunds(order.OrderNo, outRefundNo,order.RefundApplyRemark, Convert.ToInt32(order.PayAmount * 100), Convert.ToInt32(order.PayAmount * 100));
+                if (wxRefundResult.Status == "SUCCESS")
+                {
+                    order.PayStatus = LifePayStatusEnum.宸查��娆�;
+                    order.LifePayOrderStatus = LifePayOrderStatusEnum.宸查��娆�;
+                    order.LifePayRefundStatus = LifePayRefundStatusEnum.宸查��娆�;
+                }
+                else if (wxRefundResult.Status == "PROCESSING")
+                {
+                    order.PayStatus = LifePayStatusEnum.閫�娆句腑;
+                    order.LifePayOrderStatus = LifePayOrderStatusEnum.閫�娆句腑;
+                    order.LifePayRefundStatus = LifePayRefundStatusEnum.閫�娆句腑;
+                }
+                else
+                {
+                    order.PayStatus = LifePayStatusEnum.寰呴��娆�;
+                    order.LifePayOrderStatus = LifePayOrderStatusEnum.閫�娆惧け璐�;
+                    order.LifePayRefundStatus = LifePayRefundStatusEnum.寰呴��娆�;
+                }
 
-        order.PayStatus = LifePayStatusEnum.宸查��娆�;
-        order.LifePayOrderStatus = LifePayOrderStatusEnum.宸查��娆�;
+                break;
+            case LifePayTypeEnum.AliPay:
+                var aliRefundResult = await AliTradeRefund(new AlipayTradeRefundRequest() { OutTradeNo = order.OrderNo, RefundAmount = order.PayAmount.ToString() });
+                if (aliRefundResult.Code != AlipayResultCode.Success)
+                {
+                    throw new UserFriendlyException("閫�娆惧け璐�");
+                }
+
+                order.PayStatus = LifePayStatusEnum.宸查��娆�;
+                order.LifePayOrderStatus = LifePayOrderStatusEnum.宸查��娆�;
+                break;
+            default: throw new UserFriendlyException("閫�娆惧け璐�");
+        }
+
         order.RefundCredentialsImgUrl = input.RefundCredentialsImgUrl;
         order.RefundCheckRemark = input.RefundCheckRemark;
         order.RefundTime = DateTime.Now;
         order.RefundCheckUserId = CurrentUser.Id;
+        order.RefundPrice = order.PayAmount;
 
         await _lifePayOrderRepository.UpdateAsync(order);
 
@@ -1064,7 +1242,7 @@
 
         order.LifePayOrderStatus = LifePayOrderStatusEnum.閫�娆惧緟瀹℃牳;
         order.RefundApplyRemark = input.RefundApplyRemark;
-        order.RefundTime = DateTime.Now;
+        order.RefundApplyTime = DateTime.Now;
 
         await _lifePayOrderRepository.UpdateAsync(order);
     }
@@ -1078,12 +1256,12 @@
     /// <param name="total"></param>
     /// <param name="currency"></param>
     /// <returns></returns>
-    public async Task<WxPayDomesticRefundsReponse> WxPayDomesticRefunds(string outTradeNo, string reason, int refund, int total, string currency = "CNY")
+    public async Task<WxPayDomesticRefundsReponse> WxPayDomesticRefunds(string outTradeNo,string outRefundNo, string reason, int refund, int total, string currency = "CNY")
     {
         WxPayDomesticRefundsRequest req = new WxPayDomesticRefundsRequest
         {
             OutTradeNo = outTradeNo,
-            OutRefundNo = CreateRefundOrderNo(),
+            OutRefundNo = outRefundNo,
             Reason = reason,
             Amount = new Model_WxPayDomesticRefunds_Amount
             {
@@ -1098,7 +1276,10 @@
         return res;
     }
 
-
+    private async Task<AlipayTradeRefundResponse> AliTradeRefund(AlipayTradeRefundRequest input)
+    {
+        return await _aliPayApi.TradeRefund(input);
+    }
 
     public async Task<int> AddUpdateUserAccount(AddUpdateUserAccountInput input)
     {
@@ -1493,7 +1674,6 @@
         CheckExtensions.IfTrueThrowUserFriendlyException(amount <= 0,
                                                          CustomeErrorMessage.SometingMustSometing,
                                                          "鑾峰彇鏀粯浜岀淮鐮佹椂閲戦", "澶т簬0");
-
         var res = await _wxPayApi.PayTransactionsH5(new PayTransactionsNativeH5
         {
             Appid = _wxPayOptions.AppID,
@@ -1546,6 +1726,7 @@
 
         return res.QrCode;
     }
+
     /// <summary>
     /// 鏋勯�犲緟绛惧悕瀛楃涓�
     /// </summary>

--
Gitblit v1.9.1