| | |
| | | import java.math.RoundingMode; |
| | | import java.text.ParseException; |
| | | import java.text.SimpleDateFormat; |
| | | import java.time.LocalDateTime; |
| | | import java.time.ZoneId; |
| | | import java.time.*; |
| | | import java.util.*; |
| | | import java.util.stream.Collectors; |
| | | import javax.annotation.Resource; |
| | |
| | | return ServerResponse.createBySuccess(BigDecimal.ZERO); |
| | | } |
| | | // 计算7天前的时间 |
| | | Date sevenDaysAgo = Date.from(LocalDateTime.now().minusDays(7).atZone(ZoneId.systemDefault()).toInstant()); |
| | | // Date sevenDaysAgo = Date.from(LocalDateTime.now().minusDays(7).atZone(ZoneId.systemDefault()).toInstant()); |
| | | // |
| | | // List<UserPosition> userPositions = userPositionMapper.selectList( |
| | | // new QueryWrapper<UserPosition>() |
| | | // .eq("user_id", userId) |
| | | // .and(wrapper -> wrapper |
| | | // .isNotNull("sell_order_id") |
| | | // .ge("sell_order_time", sevenDaysAgo) |
| | | // .or() |
| | | // .isNull("sell_order_id") |
| | | // .ge("buy_order_time", sevenDaysAgo) |
| | | // ) |
| | | // ); |
| | | // 获取当前日期 |
| | | LocalDate today = LocalDate.now(); |
| | | |
| | | // 获取当前周的周一和周日 |
| | | LocalDate startOfWeek = today.with(DayOfWeek.MONDAY); // 本周周一 |
| | | LocalDate endOfWeek = today.with(DayOfWeek.SUNDAY); // 本周周日 |
| | | |
| | | // 获取当前周周一和周日的开始时间和结束时间 |
| | | LocalDateTime startOfWeekTime = startOfWeek.atStartOfDay(); // 周一 00:00:00 |
| | | LocalDateTime endOfWeekTime = endOfWeek.atTime(LocalTime.MAX); // 周日 23:59:59.999999999 |
| | | |
| | | // 转换为Date类型 |
| | | Date startOfWeekDate = Date.from(startOfWeekTime.atZone(ZoneId.systemDefault()).toInstant()); |
| | | Date endOfWeekDate = Date.from(endOfWeekTime.atZone(ZoneId.systemDefault()).toInstant()); |
| | | // 执行查询 |
| | | List<UserPosition> userPositions = userPositionMapper.selectList( |
| | | new QueryWrapper<UserPosition>() |
| | | .eq("user_id", userId) |
| | | .and(wrapper -> wrapper |
| | | .isNotNull("sell_order_id") |
| | | .ge("sell_order_time", sevenDaysAgo) |
| | | .ge("sell_order_time", startOfWeekDate) // 过滤sell_order_time >= 本周周一 |
| | | .le("sell_order_time", endOfWeekDate) // 过滤sell_order_time <= 本周周日 |
| | | .or() |
| | | .isNull("sell_order_id") |
| | | .ge("buy_order_time", sevenDaysAgo) |
| | | .ge("buy_order_time", startOfWeekDate) // 过滤buy_order_time >= 本周周一 |
| | | .le("buy_order_time", endOfWeekDate) // 过滤buy_order_time <= 本周周日 |
| | | ) |
| | | ); |
| | | BigDecimal weeklyProfit = BigDecimal.ZERO; |