智慧保安后台管理-验收版本
Administrator
2021-09-17 b1dea5dac6eef6fa92f170575539c514bf28bbee
统计接口修改
2 files modified
8 ■■■■■ changed files
src/main/java/org/springblade/modules/information/controller/InformationsController.java 4 ●●● patch | view | raw | blame | history
src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml 4 ●●●● patch | view | raw | blame | history
src/main/java/org/springblade/modules/information/controller/InformationsController.java
@@ -9,7 +9,6 @@
import org.springblade.modules.information.vo.InformationVO;
import org.springblade.modules.information.vo.ResponseVo;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
@@ -17,7 +16,6 @@
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.concurrent.atomic.AtomicReference;
/**
 * 组织机构详情控制层 2
@@ -146,7 +144,7 @@
     * 首页分局预警统计(保安员预警(表现差,审查异常),保安公司预警(考试通过率低于50%,持证率低于50%,社保缴纳率低于50%,派遣率低于50%))
     * @return
     */
    @PostMapping("/selectSubstationWarnInfo")
    @GetMapping("/selectSubstationWarnInfo")
    public R selectSubstationWarnInfo() {
        //辖区信息
        List<Map<Object, Object>> list = informationService.selectJur();
src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml
@@ -2049,8 +2049,8 @@
        si.*,
        ifnull(a.count,0) znum,
        ifnull(b.count,0) cnum,
        ifnull(FORMAT((b.count/c.count)*100,2),0) pnum
        ifnull(c.count,0) knum,
        ifnull(FORMAT((b.count/c.count)*100,2),0) pnum,
        ifnull(c.count,0) knum
        from sys_information si
        left join
        (