| | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public IPage selectLi(IPage page,String jurisdiction, String deptid,String stats,String startTime,String endTime) { |
|---|
| | | return page.setRecords(baseMapper.selectLi(page,jurisdiction, deptid,stats,startTime,endTime)); |
|---|
| | | List<InformationStatisticsVO> list = baseMapper.selectLi(page, jurisdiction, deptid, stats, startTime, endTime); |
|---|
| | | if (list.size()>0) { |
|---|
| | | //遍历 |
|---|
| | | for (InformationStatisticsVO informationStatisticsVO : list) { |
|---|
| | | List<Dept> deptList = baseMapper.getDeptHashChildrens(informationStatisticsVO); |
|---|
| | | //有子级 |
|---|
| | | if (deptList.size()>0){ |
|---|
| | | Dept dept = new Dept(); |
|---|
| | | dept.setId(Long.parseLong(informationStatisticsVO.getDepartmentid())); |
|---|
| | | //查询当前子单位的人数 |
|---|
| | | Integer z = baseMapper.selectInformationUserNumCount(dept) + informationStatisticsVO.getNum(); |
|---|
| | | informationStatisticsVO.setNum(z); |
|---|
| | | //持证人数 |
|---|
| | | Integer c = baseMapper.selectInformationHoldNumCount(dept) + informationStatisticsVO.getCznum(); |
|---|
| | | informationStatisticsVO.setCznum(c); |
|---|
| | | //已派遣人数 |
|---|
| | | Integer p = baseMapper.selectInformationDispatcherNumCount(dept) + informationStatisticsVO.getPqnum(); |
|---|
| | | informationStatisticsVO.setPqnum(p); |
|---|
| | | //未派遣人数 |
|---|
| | | Integer wpq = baseMapper.selectInformationNotDispatcherNumCount(dept) + informationStatisticsVO.getWpqnum(); |
|---|
| | | informationStatisticsVO.setWpqnum(wpq); |
|---|
| | | //已采集照片数 |
|---|
| | | Integer ycjzp = baseMapper.selectInformationUnitAvatarNumCount(dept) + informationStatisticsVO.getYcjzpnum(); |
|---|
| | | informationStatisticsVO.setYcjzpnum(ycjzp); |
|---|
| | | //未采集照片数 |
|---|
| | | Integer wcjzp = baseMapper.selectInformationUnitNotAvatarNumCount(dept) + informationStatisticsVO.getWcjzpnum(); |
|---|
| | | informationStatisticsVO.setWcjzpnum(wcjzp); |
|---|
| | | //已采集指纹数 |
|---|
| | | Integer ycjzw = baseMapper.selectInformationUnitZwNumCount(dept) + informationStatisticsVO.getYcjzwnum(); |
|---|
| | | informationStatisticsVO.setYcjzwnum(ycjzw); |
|---|
| | | //审查异常数 |
|---|
| | | Integer scyc = baseMapper.selectInformationUnitYcNumCount(dept) + informationStatisticsVO.getScycnum(); |
|---|
| | | informationStatisticsVO.setScycnum(scyc); |
|---|
| | | //缴纳社保数 |
|---|
| | | Integer jnsb = baseMapper.selectInformationUnitJnsbNumCount(dept) + informationStatisticsVO.getJnsbnum(); |
|---|
| | | informationStatisticsVO.setJnsbnum(jnsb); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | } |
|---|
| | | return page.setRecords(list); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
