基层智治-后台
parent: ddef54b9 | patch | commit | ignore whitespace
linwe
2023-12-23 30db42aa1c69e7f093efbc22dd560ecc959c6c7a 
性别判断
1 files modified
2 ■■■■■ changed files
src/main/java/org/springblade/modules/house/mapper/HouseholdMapper.xml 2 ●●●●● patch | view | raw | blame | history 
 src/main/java/org/springblade/modules/house/mapper/HouseholdMapper.xml


@@ -282,7 +282,7 @@


        ( SELECT


        IF


        (


        id_card IS NULL,


        id_card IS NULL or id_card = '',


        '未知',


        IF


        (SUBSTRING( id_card, 17, 1 ) % 2 = 1, '男', '女' )) AS gender