图片上传

KKSU

2024-05-31 43927c5cc3210bc77455505557befece54e33ca7

图片上传

 src/main/java/cc/mrbird/febs/mall/mapper/MallOrderItemMapper.java

@@ -13,6 +13,7 @@
    List<MallOrderItem> selectItemBySkuIdUnCancel(@Param("skuId") Long skuId, @Param("memberId") Long memberId);

    List<MallOrderItem> selectListByNotInStateAndOrderId(@Param("state")Integer i, @Param("orderId")Long orderId);
    List<MallOrderItem> selectListByStateAndOrderId(@Param("state")Integer i, @Param("orderId")Long orderId);

    void updateStateByOrderId(@Param("state")Integer i,  @Param("orderId")Long id);


 src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallTeamLeaderServiceImpl.java

@@ -420,7 +420,10 @@

            //退款退款金额
            BigDecimal refundAmount = mallRefundEntity.getAmount();
            List<MallOrderItem> mallOrderItemList1 = mallOrderItemMapper.selectListByStateAndOrderId(1,orderId);
            if(CollUtil.isEmpty(mallOrderItemList1)){
            refundAmount = refundAmount.add(mallOrderInfo.getCarriage());
            }
            BigDecimal bb = new BigDecimal(100);
            int refundMoney = refundAmount.multiply(bb).intValue();


 src/main/resources/mapper/modules/MallOrderItemMapper.xml

@@ -19,6 +19,11 @@
        where a.state != #{state} and a.order_id=#{orderId}
    </select>

    <select id="selectListByStateAndOrderId" resultType="cc.mrbird.febs.mall.entity.MallOrderItem">
        select a.* from mall_order_item a
        where a.state = #{state} and a.order_id=#{orderId}
    </select>

    <update id="updateStateByOrderId">
        update mall_order_item
        set state = #{state}