fhx
2024-09-04 befed57f02ae2906217c5e1a901191a760560645
1.修改更新sql
1个文件已修改
4 ■■■■ 已修改文件
phi_platform_user/src/main/java/com/hx/phip/util/api/OrderPayMoneyUtil.java 4 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
phi_platform_user/src/main/java/com/hx/phip/util/api/OrderPayMoneyUtil.java
@@ -2406,10 +2406,10 @@
        values.put("orderId", orderId);
        values.put("orderItemId", orderItemId);
        if(StringUtils.isEmpty(orderItemSonId)){
            sqlSentence.setSqlSentence(" userProjectItemId = #{m.userProjectItemId} where orderId = #{m.orderId} and orderItemId = #{m.orderItemId} and userProjectItemId is null ");
            sqlSentence.setSqlSentence(" userProjectItemId = #{m.userProjectItemId}, isUserPro = 1 where orderId = #{m.orderId} and orderItemId = #{m.orderItemId} and userProjectItemId is null ");
        }else{
            values.put("orderItemSonId", orderItemSonId);
            sqlSentence.setSqlSentence(" userProjectItemId = #{m.userProjectItemId} where orderId = #{m.orderId} and orderItemId = #{m.orderItemId} and orderItemSonId = #{m.orderItemSonId} and userProjectItemId is null ");
            sqlSentence.setSqlSentence(" userProjectItemId = #{m.userProjectItemId}, isUserPro = 1 where orderId = #{m.orderId} and orderItemId = #{m.orderItemId} and orderItemSonId = #{m.orderItemSonId} and userProjectItemId is null ");
        }
        commonService.updateWhere(TreatProjectMapper.class, sqlSentence);
    }