售后列表查询

Cui Zhi Feng

2024-08-26 4159cb55928c9873e96e616bf812b8df56ae0106

售后列表查询

 src/main/java/com/mzl/flower/dto/request/payment/OrderItemSalesQueryDTO.java

@@ -11,6 +11,9 @@
    @ApiModelProperty(value = "订单id")
    private String orderId;

    @ApiModelProperty(value = "订单商品id")
    private String orderItemId;

    @ApiModelProperty(value = "商品名称")
    private String flowerName;


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

@@ -77,6 +77,10 @@
        join t_order o on si.order_id = o.id
        left join t_station s on s.id = oi.station_id
        WHERE oi.deleted = 0
        <if test="condition.orderItemId != null and condition.orderItemId != ''">
            AND si.order_item_id = #{condition.orderItemId}
        </if>

        <if test="condition.orderId != null and condition.orderId != ''">
            AND si.order_id = #{condition.orderId}
        </if>