fix：还原

cloudroam

2024-09-27 1cb569b71cb45bd8e162d617125f0e249c02cd91

fix：还原

 src/main/resources/mapper/payment/OrderItemMapper.xml

@@ -29,7 +29,20 @@
            where oic.order_item_id = oi.id
            and oic.type = 'reduce'
            and oic.audit_status = 'AGREED'
        ) reduceAmountSELECT oi.*, s.name stationName, si.contact_tel supplierTel, si.contact_name supplierContact
        ) reduceAmount
        , (select oic.deduct_amount from t_order_item_check oic
            where oic.order_item_id = oi.id
            and oic.type = 'lack'
            and oic.audit_status = 'AGREED'
        ) lackAmount
        FROM t_order_item oi
        WHERE oi.deleted = 0
        and oi.status = 'abnormal'
        and oi.order_id = #{orderId}
    </select>

    <select id="getPlatformOrderItems" resultType="com.mzl.flower.dto.response.payment.OrderItemPlatformListDTO">
        SELECT oi.*, s.name stationName, si.contact_tel supplierTel, si.contact_name supplierContact
                             , (select oic.num from t_order_item_check oic where oic.order_item_id = oi.id and oic.type = 'replace') replaceNum
                             , (select oic.num from t_order_item_check oic where oic.order_item_id = oi.id and oic.type = 'reduce') reduceNum
                             , (select oic.num from t_order_item_check oic where oic.order_item_id = oi.id and oic.type = 'lack') lackNum
@@ -44,19 +57,6 @@
                 left join t_order_item_settlement ois on ois.order_item_id = oi.id
        WHERE oi.deleted = 0
          and oi.order_id = #{orderId}
        , (select oic.deduct_amount from t_order_item_check oic
            where oic.order_item_id = oi.id
            and oic.type = 'lack'
            and oic.audit_status = 'AGREED'
        ) lackAmount
        FROM t_order_item oi
        WHERE oi.deleted = 0
        and oi.status = 'abnormal'
        and oi.order_id = #{orderId}
    </select>

    <select id="getPlatformOrderItems" resultType="com.mzl.flower.dto.response.payment.OrderItemPlatformListDTO">

    </select>

    <select id="getOrderItems" resultType="com.mzl.flower.dto.response.payment.OrderItemListDTO">