| src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml | ●●●●● patch | view | raw | blame | history |
src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml
@@ -1678,7 +1678,7 @@ <select id="selectAge" resultType="java.util.HashMap"> SELECT YEAR (now()) - YEAR (substring(bu.cardid, 7, 8)) AS age IFNULL(YEAR (now()) - YEAR (substring(bu.cardid, 7, 8)),0) AS age FROM blade_user bu LEFT JOIN sys_information si ON si.departmentid = bu.dept_id