From 812e291010042cb7c202a1a5a37226e261e94aa7 Mon Sep 17 00:00:00 2001
From: zyy <zyy@email.com>
Date: Tue, 23 Dec 2025 17:25:30 +0800
Subject: [PATCH] ETF收益修改

---
 trading-order-service/src/main/java/com/yami/trading/service/UsStockTradingDayCalculator.java |  200 ++++++++++++++++++++++++++++++++++++++++
 trading-order-service/src/main/resources/mapper/dz/StockDzMapper.xml                          |    2 
 trading-order-service/src/main/java/com/yami/trading/service/dz/impl/StockDzServiceImpl.java  |   76 +++++++++++++--
 3 files changed, 267 insertions(+), 11 deletions(-)

diff --git a/trading-order-service/src/main/java/com/yami/trading/service/UsStockTradingDayCalculator.java b/trading-order-service/src/main/java/com/yami/trading/service/UsStockTradingDayCalculator.java
new file mode 100644
index 0000000..f28550e
--- /dev/null
+++ b/trading-order-service/src/main/java/com/yami/trading/service/UsStockTradingDayCalculator.java
@@ -0,0 +1,200 @@
+package com.yami.trading.service;
+
+import java.time.*;
+import java.time.temporal.ChronoUnit;
+import java.util.*;
+
+/**
+ * 美股交易日统计工具(适配java.util.Date)
+ */
+public class UsStockTradingDayCalculator {
+    // 美股纽约时区
+    private static final ZoneId NEW_YORK_ZONE = ZoneId.of("America/New_York");
+    // UTC时区(Date转ZonedDateTime的基准)
+    private static final ZoneId UTC_ZONE = ZoneId.of("UTC");
+
+    // ==================== 基础版:仅排除周末 ====================
+    /**
+     * 计算两个Date之间的美股交易日天数(仅排除周六/周日)
+     * @param startDate 开始日期(java.util.Date)
+     * @param endDate 结束日期(java.util.Date)
+     * @return 美股交易日天数
+     */
+    public static int countUsStockTradingDays(Date startDate, Date endDate) {
+        // 1. 参数校验
+        if (startDate == null || endDate == null) {
+            throw new IllegalArgumentException("startDate error");
+        }
+        if (startDate.after(endDate)) {
+            throw new IllegalArgumentException("endDate error");
+        }
+
+        // 2. 将Date转换为纽约时区的LocalDate(核心:按纽约时间算日期)
+        LocalDate startLocalDate = convertDateToNyLocalDate(startDate);
+        LocalDate endLocalDate = convertDateToNyLocalDate(endDate);
+
+        // 3. 遍历日期并统计交易日(非周六/周日)
+        int tradingDays = 0;
+        LocalDate currentDate = startLocalDate;
+        while (!currentDate.isAfter(endLocalDate)) {
+            DayOfWeek dayOfWeek = currentDate.getDayOfWeek();
+            // 非周六、非周日即为交易日
+            if (dayOfWeek != DayOfWeek.SATURDAY && dayOfWeek != DayOfWeek.SUNDAY) {
+                tradingDays++;
+            }
+            currentDate = currentDate.plusDays(1);
+        }
+        return tradingDays;
+    }
+
+    // ==================== 进阶版:排除周末+美股法定节假日 ====================
+    /**
+     * 计算两个Date之间的美股交易日天数(排除周六/周日+美股法定节假日)
+     * @param startDate 开始日期
+     * @param endDate 结束日期
+     * @return 美股交易日天数
+     */
+    public static int countUsStockTradingDaysWithHolidays(Date startDate, Date endDate) {
+        // 基础参数校验
+        if (startDate == null || endDate == null) {
+            throw new IllegalArgumentException("开始日期和结束日期不能为空");
+        }
+        if (startDate.after(endDate)) {
+            throw new IllegalArgumentException("开始日期不能晚于结束日期");
+        }
+
+        // 转换为纽约时区的LocalDate
+        LocalDate startLocalDate = convertDateToNyLocalDate(startDate);
+        LocalDate endLocalDate = convertDateToNyLocalDate(endDate);
+
+        // 预加载周期内涉及年份的美股节假日
+        Set<LocalDate> holidays = new HashSet<>();
+        for (int year = startLocalDate.getYear(); year <= endLocalDate.getYear(); year++) {
+            holidays.addAll(getUsStockHolidays(year));
+        }
+
+        // 遍历统计(非周末+非节假日)
+        int tradingDays = 0;
+        LocalDate currentDate = startLocalDate;
+        while (!currentDate.isAfter(endLocalDate)) {
+            DayOfWeek dayOfWeek = currentDate.getDayOfWeek();
+            if (dayOfWeek != DayOfWeek.SATURDAY && dayOfWeek != DayOfWeek.SUNDAY
+                    && !holidays.contains(currentDate)) {
+                tradingDays++;
+            }
+            currentDate = currentDate.plusDays(1);
+        }
+        return tradingDays;
+    }
+
+    // ==================== 工具方法:Date转纽约时区LocalDate ====================
+    /**
+     * 将java.util.Date转换为纽约时区的LocalDate
+     * @param date 待转换的Date
+     * @return 纽约时区的LocalDate
+     */
+    private static LocalDate convertDateToNyLocalDate(Date date) {
+        // Date -> Instant -> ZonedDateTime(UTC) -> ZonedDateTime(纽约) -> LocalDate
+        Instant instant = date.toInstant();
+        ZonedDateTime utcZoned = instant.atZone(UTC_ZONE);
+        ZonedDateTime nyZoned = utcZoned.withZoneSameInstant(NEW_YORK_ZONE);
+        return nyZoned.toLocalDate();
+    }
+
+    // ==================== 工具方法:获取指定年份的美股法定节假日 ====================
+    /**
+     * 获取指定年份的美股法定节假日(含调休规则)
+     * @param year 年份
+     * @return 节假日LocalDate集合
+     */
+    private static Set<LocalDate> getUsStockHolidays(int year) {
+        Set<LocalDate> holidays = new HashSet<>();
+
+        // 1. 新年(1月1日,周末则调休)
+        LocalDate newYear = LocalDate.of(year, 1, 1);
+        if (newYear.getDayOfWeek() == DayOfWeek.SATURDAY) {
+            newYear = newYear.minusDays(1);
+        } else if (newYear.getDayOfWeek() == DayOfWeek.SUNDAY) {
+            newYear = newYear.plusDays(1);
+        }
+        holidays.add(newYear);
+
+        // 2. 马丁·路德·金日(1月第三个周一)
+        LocalDate mlkDay = LocalDate.of(year, 1, 1);
+        while (mlkDay.getDayOfWeek() != DayOfWeek.MONDAY) {
+            mlkDay = mlkDay.plusDays(1);
+        }
+        mlkDay = mlkDay.plusWeeks(2);
+        holidays.add(mlkDay);
+
+        // 3. 总统日(2月第三个周一)
+        LocalDate presidentsDay = LocalDate.of(year, 2, 1);
+        while (presidentsDay.getDayOfWeek() != DayOfWeek.MONDAY) {
+            presidentsDay = presidentsDay.plusDays(1);
+        }
+        presidentsDay = presidentsDay.plusWeeks(2);
+        holidays.add(presidentsDay);
+
+        // 4. 阵亡将士纪念日(5月最后一个周一)
+        LocalDate memorialDay = LocalDate.of(year, 5, 31);
+        while (memorialDay.getDayOfWeek() != DayOfWeek.MONDAY) {
+            memorialDay = memorialDay.minusDays(1);
+        }
+        holidays.add(memorialDay);
+
+        // 5. 独立日(7月4日,周末则调休)
+        LocalDate independenceDay = LocalDate.of(year, 7, 4);
+        if (independenceDay.getDayOfWeek() == DayOfWeek.SATURDAY) {
+            independenceDay = independenceDay.minusDays(1);
+        } else if (independenceDay.getDayOfWeek() == DayOfWeek.SUNDAY) {
+            independenceDay = independenceDay.plusDays(1);
+        }
+        holidays.add(independenceDay);
+
+        // 6. 劳工节(9月第一个周一)
+        LocalDate laborDay = LocalDate.of(year, 9, 1);
+        while (laborDay.getDayOfWeek() != DayOfWeek.MONDAY) {
+            laborDay = laborDay.plusDays(1);
+        }
+        holidays.add(laborDay);
+
+        // 7. 感恩节(11月第四个周四)
+        LocalDate thanksgiving = LocalDate.of(year, 11, 1);
+        while (thanksgiving.getDayOfWeek() != DayOfWeek.THURSDAY) {
+            thanksgiving = thanksgiving.plusDays(1);
+        }
+        thanksgiving = thanksgiving.plusWeeks(3);
+        holidays.add(thanksgiving);
+
+        // 8. 圣诞节(12月25日,周末则调休)
+        LocalDate christmas = LocalDate.of(year, 12, 25);
+        if (christmas.getDayOfWeek() == DayOfWeek.SATURDAY) {
+            christmas = christmas.minusDays(1);
+        } else if (christmas.getDayOfWeek() == DayOfWeek.SUNDAY) {
+            christmas = christmas.plusDays(1);
+        }
+        holidays.add(christmas);
+
+        return holidays;
+    }
+
+    // ==================== 测试示例 ====================
+    public static void main(String[] args) {
+        // 测试:2025-12-22(周一) ~ 2025-12-28(周日)
+        Calendar cal1 = Calendar.getInstance();
+        cal1.set(2025, Calendar.DECEMBER, 22);
+        Date start = cal1.getTime();
+
+        Calendar cal2 = Calendar.getInstance();
+        cal2.set(2025, Calendar.DECEMBER, 28);
+        Date end = cal2.getTime();
+
+        // 基础版:仅排除周末,共5天(22-26日)
+        int basicDays = countUsStockTradingDays(start, end);
+        // 进阶版:若2025-12-25是圣诞节(周四),则排除,共4天
+        int advancedDays = countUsStockTradingDaysWithHolidays(start, end);
+
+        System.out.println("基础版(仅排周末)交易日数:" + basicDays);  // 输出:5
+        System.out.println("进阶版(排周末+节假日)交易日数:" + advancedDays);  // 输出:4
+    }
+}
\ No newline at end of file
diff --git a/trading-order-service/src/main/java/com/yami/trading/service/dz/impl/StockDzServiceImpl.java b/trading-order-service/src/main/java/com/yami/trading/service/dz/impl/StockDzServiceImpl.java
index 464db72..d211588 100644
--- a/trading-order-service/src/main/java/com/yami/trading/service/dz/impl/StockDzServiceImpl.java
+++ b/trading-order-service/src/main/java/com/yami/trading/service/dz/impl/StockDzServiceImpl.java
@@ -30,6 +30,7 @@
 import com.yami.trading.dao.dz.StockDzMapper;
 import com.yami.trading.service.MarketOpenChecker;
 import com.yami.trading.service.MoneyLogService;
+import com.yami.trading.service.UsStockTradingDayCalculator;
 import com.yami.trading.service.WalletService;
 import com.yami.trading.service.data.DataService;
 import com.yami.trading.service.dz.StockDzService;
@@ -46,6 +47,7 @@
 import java.lang.reflect.Field;
 import java.lang.reflect.Method;
 import java.math.BigDecimal;
+import java.math.RoundingMode;
 import java.text.DecimalFormat;
 import java.util.*;
 
@@ -270,11 +272,34 @@
                     }
                     if (dz.getDayRate() > 0) {
                         Date startTime = dz.getCreateTime();
+                        Date now = new Date();
+                        Calendar calendar = Calendar.getInstance();
+                        calendar.setTime(startTime);
+                        calendar.add(Calendar.DATE, dz.getPeriod());
+                        // 锁仓截至时间
+                        Date resultTime = calendar.getTime();
+                        //显示收益不超过 锁仓截至时间
+                        if(now.getTime() > resultTime.getTime()){
+                            now = resultTime;
+                        }
+                        // 计算美股交易天数
+                        int num = UsStockTradingDayCalculator.countUsStockTradingDays(startTime, now);
                         // 计算相差天数
-                        int num = com.yami.trading.common.util.DateUtil.dateNum(startTime, new Date());
+                        int days = com.yami.trading.common.util.DateUtil.dateNum(startTime, now);
+                        if (days >= dz.getPeriod()) {
+                            num--;
+                        }
                         num = Math.max(1, Math.min(num, dz.getPeriod()));
-                        double dayEarnings = dz.getDayRate() * dz.getVolume();
-                        double profitLoss = dayEarnings * num;
+
+                        double dayEarnings = 0; //日收益
+                        double profitLoss = 0;  //盈利
+                        double volume = dz.getVolume();  //本金
+                        for (int i = 0; i < num; i++) {
+                            dayEarnings = dz.getDayRate() * volume;
+                            profitLoss += dayEarnings;
+                            volume += dayEarnings;
+                        }
+
                         DecimalFormat df = new DecimalFormat("#.##");
                         String resultStr = df.format(profitLoss);
                         String resultStr2 = df.format(dayEarnings);
@@ -654,15 +679,15 @@
                 throw new YamiShopBindException("股票价格0,请重试");
             }
 
+
             Date now = new Date();
+            Calendar calendar = Calendar.getInstance();
+            calendar.setTime(order.getCreateTime());
+            calendar.add(Calendar.DATE, stockDz.getPeriod());
+            // 锁仓截至时间
+            Date resultTime = calendar.getTime();
             if (!isAdmin) {
                 if (stockDz.getPeriod() != null && stockDz.getPeriod() > 0) {
-                    Calendar calendar = Calendar.getInstance();
-                    calendar.setTime(order.getCreateTime());
-                    calendar.add(Calendar.DATE, stockDz.getPeriod());
-                    // 锁仓时间
-                    Date resultTime = calendar.getTime();
-
                     if(now.getTime() < resultTime.getTime()){
                         return Result.failed("未到平仓时间");
                     }
@@ -698,7 +723,14 @@
             if (isETF) {
                 //按日收益率结算
                 closeAmt = order.getPrice();
-                closeAmt = closeAmt + stockDz.getDayRate() * closeAmt * stockDz.getPeriod();
+                Date startTime = order.getCreateTime();
+                // 计算美股交易天数
+                int day = UsStockTradingDayCalculator.countUsStockTradingDays(startTime, resultTime) - 1;
+                day = Math.max(1, Math.min(day, stockDz.getPeriod()));
+                // 复利总金额 = 本金 × (1 + 日收益率) ^ 交易日数
+                closeAmt = closeAmt * Math.pow(1 + stockDz.getDayRate(), day);
+                closeAmt = BigDecimal.valueOf(closeAmt).setScale(4, RoundingMode.DOWN).doubleValue();
+
                 closePrice = closeAmt;
                 closeAmt = closeAmt - orderFree.doubleValue();
             } else {
@@ -763,4 +795,28 @@
     }
 
 
+    public static void main(String[] args) {
+        double dayEarnings = 0; //日收益
+        double profitLoss = 0;  //盈利
+        double volume = 6000;  //本金
+        double price = volume;
+        int num = 11;
+        double dayRate = 0.12;
+        for (int i = 0; i < num; i++) {
+            dayEarnings = dayRate * volume;
+            profitLoss += dayEarnings;
+            volume += dayEarnings;
+        }
+        System.out.println("dayEarnings:" + dayEarnings);
+        System.out.println("profitLoss:" + profitLoss);
+        System.out.println("volume:" + volume);
+
+
+        // 复利总金额 = 本金 × (1 + 日收益率) ^ 交易日数
+        double compoundAmount = price * Math.pow(1 + dayRate, num);
+        // 复利总盈亏 = 复利总金额 - 本金
+        double profitLoss2 = compoundAmount - price;
+        System.out.println("compoundAmount:" + compoundAmount);
+        System.out.println("profitLoss2:" + profitLoss2);
+    }
 }
diff --git a/trading-order-service/src/main/resources/mapper/dz/StockDzMapper.xml b/trading-order-service/src/main/resources/mapper/dz/StockDzMapper.xml
index e8e2b19..07f5950 100644
--- a/trading-order-service/src/main/resources/mapper/dz/StockDzMapper.xml
+++ b/trading-order-service/src/main/resources/mapper/dz/StockDzMapper.xml
@@ -67,7 +67,7 @@
         <if test="userId != null and userId != '' ">
             AND t.party_id = #{userId}
         </if>
-        ORDER BY  t.create_time DESC
+        ORDER BY  t.close_time DESC,t.create_time DESC
     </select>
 
     <select id="getDzCheckList" resultType="com.yami.trading.bean.dz.dto.ExchangeApplyOrderDzDto" parameterType="map">

--
Gitblit v1.9.3