From f2f0eb7d4101f99d251d6dbff47b8265509f5a1e Mon Sep 17 00:00:00 2001
From: lin <sbla5888@163.com>
Date: Wed, 20 Mar 2024 17:20:30 +0800
Subject: [PATCH] 租客管理查询
---
src/main/java/org/springblade/modules/house/mapper/HouseholdMapper.xml | 4 ++++
src/main/java/org/springblade/modules/house/vo/HouseholdVO.java | 3 +++
2 files changed, 7 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/modules/house/mapper/HouseholdMapper.xml b/src/main/java/org/springblade/modules/house/mapper/HouseholdMapper.xml
index ac7de1b..ef2b42f 100644
--- a/src/main/java/org/springblade/modules/house/mapper/HouseholdMapper.xml
+++ b/src/main/java/org/springblade/modules/house/mapper/HouseholdMapper.xml
@@ -238,6 +238,10 @@
<!-- 等于18 就是租户 -->
<if test="household.relationship!=null and household.relationship == 18">
and jh.relationship = #{household.relationship}
+
+ <if test="household.minors!=null and household.minors ==1">
+ and TIMESTAMPDIFF(year, substring(jh.id_card, 7, 8), now()) < 18
+ </if>
</if>
<!-- 不等于18 就是非租户 -->
<if test="household.relationship!=null and household.relationship != 18">
diff --git a/src/main/java/org/springblade/modules/house/vo/HouseholdVO.java b/src/main/java/org/springblade/modules/house/vo/HouseholdVO.java
index a0b2bb3..5807d1c 100644
--- a/src/main/java/org/springblade/modules/house/vo/HouseholdVO.java
+++ b/src/main/java/org/springblade/modules/house/vo/HouseholdVO.java
@@ -174,6 +174,9 @@
*/
private Integer limit;
+ @ApiModelProperty(value = "未成年", example = "")
+ private Integer minors;
+
/**
* 角色名称
*/
--
Gitblit v1.9.3