智慧保安后台管理-验收版本
parent: ffa79b72 | patch | commit | ignore whitespace
tangzy
2021-12-01 f8eb33545cf6068a6cf21a53eae27076ecd8349c 
1.保安员统计
1 files modified
2 ■■■■■ changed files
src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml 2 ●●●●● patch | view | raw | blame | history 
 src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml


@@ -1218,7 +1218,7 @@


        A.stats,


        j.dept_name AS jurname


        FROM


        ( SELECT jurisdiction, departmentid,enterpriseName,stats,create_time FROM sys_information where stats !=1) A


        ( SELECT jurisdiction, departmentid,enterpriseName,stats FROM sys_information where stats !=1) A


        LEFT JOIN (


        SELECT


        J.znum+J.fznum as num,