springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComActActEvaluateVO.java
@@ -4,6 +4,7 @@ import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import org.springframework.format.annotation.DateTimeFormat; import java.io.Serializable; import java.util.Date; @@ -75,4 +76,14 @@ @ApiModelProperty(value = "分页-每页记录数", example = "10") private Long pageSize = 10L; @ApiModelProperty("开始时间") @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss") @JsonFormat(pattern="yyyy-MM-dd HH:mm:ss") private Date startTime; @ApiModelProperty("结束时间") @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss") @JsonFormat(pattern="yyyy-MM-dd HH:mm:ss") private Date endTime; } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActActEvaluateMapper.xml
@@ -53,6 +53,12 @@ <if test="comActActEvaluateVO.createAt != null"> AND caae.create_at = #{comActActEvaluateVO.createAt} </if> <if test="comActActEvaluateVO.startTime != null"> AND caae.create_at >= #{comActActEvaluateVO.startTime} </if> <if test="comActActEvaluateVO.endTime != null"> AND #{comActActEvaluateVO.endTime} >= caae.create_at </if> order by caae.create_at desc </select>