1.单位接口编写

tangzy

2021-08-13 0becea6a049bff7a86833ef818ab51196a27b3a4

1.单位接口编写

 src/main/java/org/springblade/modules/information/controller/InformationController.java

@@ -745,4 +745,29 @@
        return R.data(list);
    }


    /**
     * 单位类型统计
     */
    @PostMapping("/seCountI")
    public R seCountI(String jurisdiction,String deptid) {
        List<Map<Object, Object>> list = informationService.seCountI(jurisdiction, deptid);
        return R.data(list);
    }

    /**
     * 保安在职男女数量
     */
    @PostMapping("/seCountUg")
    public R seCountUg(String jurisdiction,String deptid) {
        String mnum = informationService.seCountUm(jurisdiction, deptid);
        String gnum = informationService.seCountUg(jurisdiction, deptid);
        Map map = new HashMap();
        map.put("mnum",mnum);
        map.put("gnum",gnum);
        List list = new ArrayList();
        list.add(map);
        return R.data(list);
    }

}

 src/main/java/org/springblade/modules/information/mapper/InformationMapper.java

@@ -61,6 +61,9 @@
    List<Map<Object,Object>> selectJur();
    List<Map<Object,Object>> selectExtype(String jurisdiction,String deptid);
    List<Map<Object,Object>> selectBx(String jurisdiction,String deptid);
    List<Map<Object,Object>> seCountI(String jurisdiction,String deptid);
    String seCountUm(String jurisdiction,String deptid);
    String seCountUg(String jurisdiction,String deptid);
    List<Map<Object,Object>> selectIn(String jurisdiction);

    Map<String, String> queryYearZ(String year,String jurisdiction,String deptid);

 src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml

@@ -910,4 +910,34 @@
            and A.dept_id =#{deptid}
        </if>
    </select>

    <select id="seCountI" resultType="java.util.HashMap">
        SELECT COUNT(*) as num,stats FROM sys_information
        where 1=1
        <if test="deptid!=null and deptid!=''">
            and departmentid=#{deptid}
        </if>
        <if test="jurisdiction!=null and jurisdiction!=''and jurisdiction!='1123598813738675201'">
            AND jurisdiction=#{jurisdiction}
        </if>
        GROUP BY stats
    </select>
    <select id="seCountUm" resultType="java.lang.String">
        SELECT COUNT(*) as mnum FROM `blade_user` WHERE status=1 AND sex=1
        <if test="deptid!=null and deptid!=''">
            and dept_id=#{deptid}
        </if>
        <if test="jurisdiction!=null and jurisdiction!=''and jurisdiction!='1123598813738675201'">
            AND jurisdiction=#{jurisdiction}
        </if>
    </select>
    <select id="seCountUg" resultType="java.lang.String">
        SELECT COUNT(*) as gnum FROM `blade_user` WHERE status=1 AND sex=2
        <if test="deptid!=null and deptid!=''">
            and dept_id=#{deptid}
        </if>
        <if test="jurisdiction!=null and jurisdiction!=''and jurisdiction!='1123598813738675201'">
            AND jurisdiction=#{jurisdiction}
        </if>
    </select>
</mapper>

 src/main/java/org/springblade/modules/information/service/IInformationService.java

@@ -70,4 +70,7 @@
    List<Map<Object,Object>> selectIn(String jurisdiction);
    void deleteDept(String ids);
    List<Map<Object,Object>> selectLi(String jurisdiction,String deptid);
    List<Map<Object,Object>> seCountI(String jurisdiction,String deptid);
    String seCountUm(String jurisdiction,String deptid);
    String seCountUg(String jurisdiction,String deptid);
}

 src/main/java/org/springblade/modules/information/service/impl/InformationServiceImpl.java

@@ -185,5 +185,20 @@
        return baseMapper.selectLi(jurisdiction, deptid);
    }

    @Override
    public List<Map<Object, Object>> seCountI(String jurisdiction, String deptid) {
        return baseMapper.seCountI(jurisdiction, deptid);
    }

    @Override
    public String seCountUm(String jurisdiction, String deptid) {
        return baseMapper.seCountUm(jurisdiction, deptid);
    }

    @Override
    public String seCountUg(String jurisdiction, String deptid) {
        return baseMapper.seCountUg(jurisdiction, deptid);
    }


}