From 84686e27975d3384dce903e59d0bd19630ac338b Mon Sep 17 00:00:00 2001 From: xuxueyang <xuxy@fengyuntec.com> Date: 星期三, 18 九月 2024 16:07:05 +0800 Subject: [PATCH] update 积分查询 --- src/main/resources/mapper/point/CustomerPointMapper.xml | 8 ++++---- src/main/java/com/mzl/flower/dto/request/point/QueryPointDetailDTO.java | 4 ++-- 2 files changed, 6 insertions(+), 6 deletions(-) diff --git a/src/main/java/com/mzl/flower/dto/request/point/QueryPointDetailDTO.java b/src/main/java/com/mzl/flower/dto/request/point/QueryPointDetailDTO.java index 1c92bde..f236ea1 100644 --- a/src/main/java/com/mzl/flower/dto/request/point/QueryPointDetailDTO.java +++ b/src/main/java/com/mzl/flower/dto/request/point/QueryPointDetailDTO.java @@ -12,10 +12,10 @@ private Long customerId; @ApiModelProperty("记录日期") - private LocalDate recordDateStart; + private String recordDateStart; @ApiModelProperty("记录日期") - private LocalDate recordDateEnd; + private String recordDateEnd; @ApiModelProperty("积分类型-point_type") private String type; diff --git a/src/main/resources/mapper/point/CustomerPointMapper.xml b/src/main/resources/mapper/point/CustomerPointMapper.xml index 9514779..004ba1c 100644 --- a/src/main/resources/mapper/point/CustomerPointMapper.xml +++ b/src/main/resources/mapper/point/CustomerPointMapper.xml @@ -35,14 +35,14 @@ <if test="dto.userId!= null and dto.userId != ''"> and t.user_id = #{dto.userId} </if> - <if test="dto.recordDateStart!=null "> + <if test="dto.recordDateStart!=null and dto.recordDateStart!='' "> <![CDATA[ - AND t.record_date >= #{dto.createDateBegin} + AND t.record_date >= #{dto.recordDateStart} ]]> </if> - <if test="dto.recordDateEnd!=null "> + <if test="dto.recordDateEnd!=null and dto.recordDateEnd!='' "> <![CDATA[ - AND t.record_date <= #{dto.createDateEnd} + AND t.record_date <= #{dto.recordDateEnd} ]]> </if> <if test="dto.type!=null and dto.type != null"> -- Gitblit v1.9.3