From 0345d46de590a980d1d18e48f33ef42302cee0bb Mon Sep 17 00:00:00 2001 From: whywhyo <1511349576@qq.com> Date: 星期二, 25 七月 2023 08:42:39 +0800 Subject: [PATCH] 4564 --- zhang-content/src/main/java/com/ruoyi/service/impl/ZfPetServiceImpl.java | 4 +++- ruoyi-admin/src/main/resources/application-druid.yml | 4 ++-- zhang-content/src/main/java/com/ruoyi/domain/ZfPet.java | 8 ++++++++ zhang-content/src/main/java/com/ruoyi/service/impl/ZfCleanServiceImpl.java | 1 + 4 files changed, 14 insertions(+), 3 deletions(-) diff --git a/ruoyi-admin/src/main/resources/application-druid.yml b/ruoyi-admin/src/main/resources/application-druid.yml index 045d564..b2e66b2 100644 --- a/ruoyi-admin/src/main/resources/application-druid.yml +++ b/ruoyi-admin/src/main/resources/application-druid.yml @@ -6,8 +6,8 @@ druid: # 涓诲簱鏁版嵁婧� master: -# url: jdbc:mysql://47.93.189.255:3306/ruoyi?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8 - url: jdbc:mysql://localhost:3306/ruoyi?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8 + url: jdbc:mysql://47.93.189.255:3306/ruoyi?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8 +# url: jdbc:mysql://localhost:3306/ruoyi?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8 username: root password: ZhangApp123! # password: 123456 diff --git a/zhang-content/src/main/java/com/ruoyi/domain/ZfPet.java b/zhang-content/src/main/java/com/ruoyi/domain/ZfPet.java index d320188..2277d46 100644 --- a/zhang-content/src/main/java/com/ruoyi/domain/ZfPet.java +++ b/zhang-content/src/main/java/com/ruoyi/domain/ZfPet.java @@ -143,5 +143,13 @@ @Excel(name = "涓讳汉鍦板潃") private String masterAddress; + @TableField(exist = false) + @Excel(name = "鍑虹敓鏃ユ湡", dateFormat = "yyyy-MM-dd") + private Date birthStart; + + @TableField(exist = false) + @Excel(name = "鍑虹敓鏃ユ湡", dateFormat = "yyyy-MM-dd") + private Date birthEnd; + } diff --git a/zhang-content/src/main/java/com/ruoyi/service/impl/ZfCleanServiceImpl.java b/zhang-content/src/main/java/com/ruoyi/service/impl/ZfCleanServiceImpl.java index 1ed99a3..7254194 100644 --- a/zhang-content/src/main/java/com/ruoyi/service/impl/ZfCleanServiceImpl.java +++ b/zhang-content/src/main/java/com/ruoyi/service/impl/ZfCleanServiceImpl.java @@ -58,6 +58,7 @@ LambdaQueryWrapper<ZfClean> lqw = new LambdaQueryWrapper<>(); lqw.orderByDesc(ZfClean::getCreateTime); lqw.eq(zfClean.getKind() != null, ZfClean::getKind, zfClean.getKind()) + .eq(zfClean.getId()!=null,ZfClean::getId,zfClean.getId()) .like(StringUtils.isNotEmpty(zfClean.getSuitable()), ZfClean::getSuitable, zfClean.getSuitable()) .like(StringUtils.isNotEmpty(zfClean.getType()), ZfClean::getType, zfClean.getType()) .like(StringUtils.isNotEmpty(zfClean.getMethod()), ZfClean::getMethod, zfClean.getMethod()) diff --git a/zhang-content/src/main/java/com/ruoyi/service/impl/ZfPetServiceImpl.java b/zhang-content/src/main/java/com/ruoyi/service/impl/ZfPetServiceImpl.java index 1a6014a..3163216 100644 --- a/zhang-content/src/main/java/com/ruoyi/service/impl/ZfPetServiceImpl.java +++ b/zhang-content/src/main/java/com/ruoyi/service/impl/ZfPetServiceImpl.java @@ -300,11 +300,13 @@ LambdaQueryWrapper<ZfPet> lqw = new LambdaQueryWrapper<>(); lqw.orderByDesc(ZfPet::getCreateTime); lqw.in(ZfPet::getFamilyId,familyIdList); + lqw.eq(zfPet.getId()!=null,ZfPet::getId,zfPet.getId()); lqw.like(StringUtils.isNotEmpty(zfPet.getIdNum()),ZfPet::getIdNum,zfPet.getIdNum()); lqw.like(StringUtils.isNotEmpty(zfPet.getSecurityCode()),ZfPet::getSecurityCode,zfPet.getSecurityCode()); lqw.like(StringUtils.isNotEmpty(zfPet.getType()),ZfPet::getType,zfPet.getType()); lqw.like(StringUtils.isNotEmpty(zfPet.getName()),ZfPet::getName,zfPet.getName()); - lqw.like(zfPet.getBirth()!=null,ZfPet::getBirth,zfPet.getBirth()); +// lqw.like(zfPet.getBirth()!=null,ZfPet::getBirth,zfPet.getBirth()); + lqw.between(zfPet.getBirthStart()!=null && zfPet.getBirthEnd()!=null,ZfPet::getBirth,zfPet.getBirthStart(),zfPet.getBirthEnd()); lqw.like(zfPet.getSex()!=null,ZfPet::getSex,zfPet.getSex()); lqw.like(StringUtils.isNotEmpty(zfPet.getColor()),ZfPet::getColor,zfPet.getColor()); lqw.like(StringUtils.isNotEmpty(zfPet.getProperties()),ZfPet::getProperties,zfPet.getProperties()); -- Gitblit v1.9.1