1.仓位按照顺序排序

陶杰

2024-12-17 eb1633788e987e59fc28983bc9bb92c3e5a37a2a

1.仓位按照顺序排序

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

@@ -8,7 +8,8 @@
        join t_order o on q.order_id = o.id
        left join t_warehouse w on o.warehouse_id=w.id
        left join t_warehouse_location wl on o.warehouse_location_id=wl.id
        WHERE q.deleted = 0 and o.deleted = 0 and w.deleted=0 and wl.deleted=0
        WHERE q.deleted = 0 and o.deleted = 0
--         and w.deleted=0 and wl.deleted=0
        and q.supplier_id = #{supplierId}
        <if test="condition.orderNo != null and condition.orderNo != ''">
            AND q.order_no LIKE concat('%', #{condition.orderNo},'%')