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

@@ -76,4 +76,7 @@

    @ApiModelProperty(hidden = true)
    private boolean customerQuery = false;

    @ApiModelProperty(value = "库位")
    private String warehouseLocationCode;
}

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

@@ -145,6 +145,9 @@
                and oi.flower_name LIKE concat('%', #{condition.flowerName},'%')
            )
        </if>
        <if test="condition.warehouseLocationCode != null and condition.warehouseLocationCode != ''">
            AND q.warehouse_location_code LIKE concat('%', #{condition.warehouseLocationCode},'%')
        </if>

        ORDER BY q.create_time desc, q.payment_time desc
    </select>