| | |
| | | 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; |
| | | |
| | |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.concurrent.atomic.AtomicReference; |
| | | |
| | | /** |
| | | * 组织机构详情控制层 2 |
| | |
| | | * 首页分局预警统计(保安员预警(表现差,审查异常),保安公司预警(考试通过率低于50%,持证率低于50%,社保缴纳率低于50%,派遣率低于50%)) |
| | | * @return |
| | | */ |
| | | @PostMapping("/selectSubstationWarnInfo") |
| | | @GetMapping("/selectSubstationWarnInfo") |
| | | public R selectSubstationWarnInfo() { |
| | | //辖区信息 |
| | | List<Map<Object, Object>> list = informationService.selectJur(); |
| | |
| | | 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 |
| | | ( |