1

zj

2026-01-27 deda94f94f5af2c820c6b600f0f7e2b041248434

1

 src/main/java/com/nq/dao/UserPositionMapper.java

@@ -51,4 +51,5 @@

  List<UserPosition> synchronizePrice();

  BigDecimal CountPositionAllProfitAndLoseByUserId(@Param("userId") Integer userId);
}

 src/main/java/com/nq/service/impl/UserServiceImpl.java

@@ -1830,7 +1830,8 @@
        PositionVO positionVO = this.iUserPositionService.findUserPositionAllProfitAndLose(user.getId());
        userInfoVO.setAllFreezAmt(positionVO.getAllFreezAmt());
        BigDecimal allProfitAndLose = positionVO.getAllProfitAndLose();
        userInfoVO.setAllProfitAndLose(allProfitAndLose);
        BigDecimal profitAndLose = this.userPositionMapper.CountPositionAllProfitAndLoseByUserId(user.getId());
        userInfoVO.setAllProfitAndLose(allProfitAndLose.add(profitAndLose));

//        BigDecimal userAllAmt = user.getUserAmt();
        BigDecimal userAllAmt = user.getEnableAmt();

 src/main/resources/mapper/UserPositionMapper.xml

@@ -549,6 +549,11 @@
    WHERE sell_order_id is not null
  </select>

  <select id="CountPositionAllProfitAndLoseByUserId" resultType="decimal" parameterType="integer">
    SELECT sum(all_profit_and_lose) FROM user_position
    WHERE sell_order_id is not null and user_id = #{userId}
  </select>


  <delete id="deleteByUserId" parameterType="integer">
    DELETE FROM user_position WHERE user_id = #{userId}