583-订单管理-订单列表统计页面增加一个，筛选地区的下拉列表，例如昆明-呈贡区等等

cloudroam

2024-12-10 c8ea01fdd9fc8ebf5e1fcbbd56fee7071e4d5809

583-订单管理-订单列表统计页面增加一个，筛选地区的下拉列表，例如昆明-呈贡区等等

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

@@ -82,4 +82,13 @@

    @ApiModelProperty(value = "用户账号")
    private String createName;

    @ApiModelProperty("服务区域-省")
    private String province;

    @ApiModelProperty("服务区域-市")
    private String city;

    @ApiModelProperty("服务区域-区")
    private String region;
}

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

@@ -94,6 +94,15 @@
        <if test="condition.orderNo != null and condition.orderNo != ''">
            AND q.order_no LIKE concat('%', #{condition.orderNo},'%')
        </if>
        <if test="condition.province != null and condition.province != ''">
            AND q.customer_province LIKE concat('%', #{condition.province},'%')
        </if>
        <if test="condition.city != null and condition.city != ''">
            AND q.customer_city LIKE concat('%', #{condition.city},'%')
        </if>
        <if test="condition.region != null and condition.region != ''">
            AND q.customer_region LIKE concat('%', #{condition.region},'%')
        </if>
        <if test="condition.customerAddress != null and condition.customerAddress != ''">
            AND q.customer_address LIKE concat('%', #{condition.customerAddress},'%')
        </if>