| | |
| | | |
| | | import io.swagger.annotations.*; |
| | | import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport; |
| | | import io.swagger.models.auth.In; |
| | | import lombok.AllArgsConstructor; |
| | | |
| | | import javax.validation.Valid; |
| | | |
| | | import org.springblade.common.cache.DictCache; |
| | | import org.springblade.common.enums.DictEnum; |
| | | import org.springblade.core.cache.utils.CacheUtil; |
| | | import org.springblade.core.mp.support.Condition; |
| | | import org.springblade.core.mp.support.Query; |
| | | import org.springblade.core.tool.api.R; |
| | | import org.springblade.core.tool.utils.Func; |
| | | import org.springblade.modules.desk.entity.Notice; |
| | | import org.springblade.modules.desk.vo.NoticeVO; |
| | | import org.springblade.modules.desk.wrapper.NoticeWrapper; |
| | | import org.springblade.core.tool.support.Kv; |
| | | import org.springblade.modules.dispatcher.vo.DispatcherVO; |
| | | import org.springblade.modules.information.vo.InformationVO; |
| | | import org.springblade.modules.information.vo.ResponseVo; |
| | | import org.springblade.modules.jurisdiction.service.JurisdictionService; |
| | | import org.springblade.modules.jurisdiction.vo.JurisdictionVO; |
| | | import org.springblade.modules.member.service.IMemberService; |
| | | import org.springblade.modules.shareholder.service.IShareholderService; |
| | | import org.springblade.modules.system.entity.Dept; |
| | | import org.springblade.modules.system.service.IDeptService; |
| | | import org.springblade.modules.system.service.IUserDeptService; |
| | | import org.springframework.web.bind.annotation.*; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import org.springblade.modules.information.entity.Information; |
| | | import org.springblade.modules.information.vo.InformationVO; |
| | | import org.springblade.modules.information.service.IInformationService; |
| | | import org.springblade.core.boot.ctrl.BladeController; |
| | | import springfox.documentation.annotations.ApiIgnore; |
| | | |
| | | import java.text.DecimalFormat; |
| | | import java.util.List; |
| | | import java.util.ArrayList; |
| | | import java.util.Map; |
| | | import java.util.HashMap; |
| | | |
| | | import java.util.*; |
| | | |
| | | import static org.springblade.core.cache.constant.CacheConstant.SYS_CACHE; |
| | | |
| | | /** |
| | | * 控制器 |
| | |
| | | @GetMapping("/page") |
| | | @ApiOperationSupport(order = 3) |
| | | @ApiOperation(value = "分页", notes = "传入information") |
| | | public R<IPage<Information>> page(Information information, Query query) { |
| | | IPage<Information> pages = informationService.selectInformationPage(Condition.getPage(query), information); |
| | | public R<IPage<InformationVO>> page(InformationVO information, Query query) { |
| | | IPage<InformationVO> pages = informationService.selectInformationPage(Condition.getPage(query), information); |
| | | return R.data(pages); |
| | | } |
| | | |
| | |
| | | @ApiOperationSupport(order = 4) |
| | | @ApiOperation(value = "新增", notes = "传入information") |
| | | public R save(@Valid @RequestBody Information information) { |
| | | Dept dept = new Dept(); |
| | | //String departmentid = information.getDepartmentid(); |
| | | //Long l = Long.parseLong(departmentid); |
| | | //自招保安公司 |
| | | if (information.getStats().equals("0")) { |
| | | Long i = 1420222768149966850L; |
| | | dept.setParentId(i); |
| | | dept.setTenantId("000000"); |
| | | dept.setDeptName(information.getEnterprisename()); |
| | | dept.setAncestors("0,1420222768149966850"); |
| | | dept.setDeptCategory(1); |
| | | } |
| | | //保安培训公司 |
| | | if (information.getStats().equals("1")) { |
| | | Long i = 1418458374477549569L; |
| | | dept.setParentId(i); |
| | | dept.setTenantId("000000"); |
| | | dept.setDeptName(information.getEnterprisename()); |
| | | dept.setAncestors("0,1418458374477549569"); |
| | | dept.setDeptCategory(1); |
| | | |
| | | } |
| | | //保安服务公司 |
| | | if (information.getStats().equals("2")) { |
| | | Long i = 1413470343230877697L; |
| | | dept.setParentId(i); |
| | | dept.setTenantId("000000"); |
| | | dept.setDeptName(information.getEnterprisename()); |
| | | dept.setAncestors("0,1413470343230877697"); |
| | | dept.setDeptCategory(1); |
| | | } |
| | | //武装守押公司 |
| | | if (information.getStats().equals("3")) { |
| | | Long i = 1420222961377357825L; |
| | | dept.setParentId(i); |
| | | dept.setTenantId("000000"); |
| | | dept.setDeptName(information.getEnterprisename()); |
| | | dept.setAncestors("0,1420222961377357825"); |
| | | dept.setDeptCategory(1); |
| | | } |
| | | //dept.setId(l); |
| | | if (iDeptService.submit(dept)) { |
| | | CacheUtil.clear(SYS_CACHE); |
| | | // 返回懒加载树更新节点所需字段 |
| | | Kv kv = Kv.create().set("id", String.valueOf(dept.getId())).set("tenantId", dept.getTenantId()) |
| | | .set("deptCategoryName", DictCache.getValue(DictEnum.ORG_CATEGORY, dept.getDeptCategory())); |
| | | String id = kv.get("id").toString(); |
| | | information.setDepartmentid(id); |
| | | } |
| | | return R.status(informationService.save(information)); |
| | | } |
| | | |
| | |
| | | @PostMapping("/remove") |
| | | @ApiOperationSupport(order = 8) |
| | | @ApiOperation(value = "删除", notes = "传入ids") |
| | | public R remove(String creditcode) { |
| | | informationService.deleteIn(creditcode); |
| | | informationService.deleteSh(creditcode); |
| | | informationService.deleteMe(creditcode); |
| | | public R remove(String ids) { |
| | | informationService.deleteIn(ids); |
| | | informationService.deleteSh(ids); |
| | | informationService.deleteMe(ids); |
| | | return R.success("删除成功"); |
| | | } |
| | | |
| | | /** |
| | | * 首页保安公司统计接口 |
| | | * |
| | | * @return |
| | | */ |
| | | @PostMapping("/SelectCount") |
| | | public R SelectCount() { |
| | | List<Map<Object, String>> list = iDeptService.selectCount(); |
| | | List<Map<String, Object>> lists = new ArrayList<>(); |
| | | for (int i = 0; i < list.size(); i++) { |
| | | String title = list.get(i).get("title");//部门名称 |
| | | String departmentid = String.valueOf(list.get(i).get("jurisdiction"));//部门id |
| | | Map<String, Object> map = new HashMap<String, Object>(); |
| | | Map maps = informationService.selectCount(departmentid); |
| | | map.put("name", title); |
| | | map.put("server", maps); |
| | | lists.add(map); |
| | | } |
| | | return R.data(lists); |
| | | } |
| | | |
| | | /** |
| | | * 首页保安持证统计接口 |
| | | * |
| | | * @return |
| | | */ |
| | | @PostMapping("/SelectCounthold") |
| | | public R SelectCounthold() { |
| | | List<Map<Object, String>> list = iDeptService.selectCount(); |
| | | List<Map<String, Object>> lists = new ArrayList<>(); |
| | | for (int i = 0; i < list.size(); i++) { |
| | | int cznumber = 0;//总的持证数量 |
| | | int wcznumber = 0;//总的未持证数量 |
| | | String title = list.get(i).get("title");//部门名称 |
| | | Map<String, Object> map = new HashMap<String, Object>(); |
| | | Map<Object, Integer> objectStringMap = iDeptService.selectHold(String.valueOf(list.get(i).get("jurisdiction"))); |
| | | if (objectStringMap==null) { |
| | | map.put("name", title); |
| | | map.put("cz", cznumber); |
| | | map.put("wcz", wcznumber); |
| | | lists.add(map); |
| | | } |
| | | else { |
| | | cznumber = objectStringMap.get("cz"); |
| | | wcznumber = objectStringMap.get("wcz"); |
| | | map.put("name", title); |
| | | map.put("cz", cznumber); |
| | | map.put("wcz", wcznumber); |
| | | lists.add(map); |
| | | } |
| | | } |
| | | return R.data(lists); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 统计保安公司未持证的保安的公司数量 |
| | | */ |
| | | @PostMapping("/selectInCount") |
| | | public R selectInCount(String jurisdiction,String deptid) { |
| | | List<Map<Object, String>> maps = informationService.selectInCount(jurisdiction,deptid); |
| | | public R selectInCount(String jurisdiction, String deptid) { |
| | | List<Map<Object, String>> maps = informationService.selectInCount(jurisdiction, deptid); |
| | | Map<String, Object> map = new HashMap<String, Object>(); |
| | | map.put("Count",maps.size()); |
| | | map.put("List",maps); |
| | | map.put("Count", maps.size()); |
| | | map.put("List", maps); |
| | | List<Map<String, Object>> lists = new ArrayList<>(); |
| | | lists.add(map); |
| | | return R.data(lists); |
| | |
| | | |
| | | |
| | | /** |
| | | * 未缴社保数量 |
| | | * 通过辖区查询机构id,然后通过机构id查询当前机构交社保的人数(numj单位已交社保数量;numz单位人员总数) |
| | | */ |
| | | @PostMapping("/selectCs") |
| | | public R selectCs(String jurisdiction,String deptid) { |
| | | List<Map<String, Object>> maps = informationService.selectCs(jurisdiction,deptid); |
| | | public R selectCs(String jurisdiction, String deptid) { |
| | | List<Map<String, Object>> maps = informationService.selectCs(jurisdiction, deptid); |
| | | List<Map<String, Object>> lists = new ArrayList<>(); |
| | | List<Map<String, Object>> lists1 = new ArrayList<>(); |
| | | Map<String, Object> map1 = new HashMap<String, Object>(); |
| | | Integer count=0; |
| | | for (int i=0;i<maps.size();i++){ |
| | | Integer count = 0; |
| | | for (int i = 0; i < maps.size(); i++) { |
| | | Map<String, Object> map = new HashMap<String, Object>(); |
| | | //交社保数 |
| | | String numjs = maps.get(i).get("numj").toString(); |
| | |
| | | String deptname = maps.get(i).get("deptname").toString(); |
| | | //统计未交社保人数 |
| | | int i1 = numz - numj; |
| | | count+=i1; |
| | | map.put("count",i1); |
| | | map.put("name",deptname); |
| | | count += i1; |
| | | map.put("count", i1); |
| | | map.put("name", deptname); |
| | | lists1.add(map); |
| | | } |
| | | map1.put("Count",count); |
| | | map1.put("List",lists1); |
| | | map1.put("Count", count); |
| | | map1.put("List", lists1); |
| | | lists.add(map1); |
| | | return R.data(lists); |
| | | } |
| | |
| | | |
| | | /** |
| | | * 统计这个月和上个月交社保的人数,以及金额 |
| | | * |
| | | * @return |
| | | */ |
| | | @PostMapping("/selectTo") |
| | | public R selectTo(String jurisdiction,String deptid) { |
| | | public R selectTo(String jurisdiction, String deptid) { |
| | | //上个月人数数量 |
| | | Integer lnum=0; |
| | | Integer lnum = 0; |
| | | //这个月人数数量 |
| | | Integer tnum=0; |
| | | Integer tnum = 0; |
| | | Integer znum = 0; |
| | | //上个月派遣人数 |
| | | Integer tpznum = 0; |
| | | //这个月人数数量 |
| | | Integer lpznum = 0; |
| | | Integer pznum = 0; |
| | | //上个月总人数 |
| | | Integer tznum = 0; |
| | | //这个月总人数 |
| | | Integer lznum = 0; |
| | | Integer sbnum = 0; |
| | | //上个月金额 |
| | | Double lmount=0.0; |
| | | Double lmount = 0.0; |
| | | //这个月金额 |
| | | Double tmount=0.0; |
| | | Double tmount = 0.0; |
| | | Double tamountnum = 0.0; |
| | | Map<String, Object> map = new HashMap<String, Object>(); |
| | | List<Map<String, Object>> lists = new ArrayList<>(); |
| | | List<Map<String, Object>> list = informationService.selectTo(jurisdiction,deptid); |
| | | for (int i=0;i<list.size();i++){ |
| | | List<Map<String, Object>> list = informationService.selectTo(jurisdiction, deptid); |
| | | for (int i = 0; i < list.size(); i++) { |
| | | String lastmonths = list.get(i).get("lastmonth").toString(); |
| | | Integer lastmonth=Integer.parseInt(lastmonths); |
| | | lnum+=lastmonth; |
| | | Integer lastmonth = Integer.parseInt(lastmonths); |
| | | lnum += lastmonth; |
| | | String thismouths = list.get(i).get("thismouth").toString(); |
| | | Integer thismouth=Integer.parseInt(thismouths); |
| | | tnum+=thismouth; |
| | | Integer thismouth = Integer.parseInt(thismouths); |
| | | tnum += thismouth; |
| | | //社保总数 |
| | | String nums = list.get(i).get("num").toString(); |
| | | Integer numss = Integer.parseInt(nums); |
| | | znum += numss; |
| | | |
| | | String lastamounts = list.get(i).get("lastamount").toString(); |
| | | Double lastamount =Double.parseDouble(lastamounts); |
| | | lmount+=lastamount; |
| | | Double lastamount = Double.parseDouble(lastamounts); |
| | | lmount += lastamount; |
| | | String thisamounts = list.get(i).get("thisamount").toString(); |
| | | Double thisamount =Double.parseDouble(thisamounts); |
| | | tmount+=thisamount; |
| | | Double thisamount = Double.parseDouble(thisamounts); |
| | | tmount += thisamount; |
| | | //缴纳总数 |
| | | String amountnums = list.get(i).get("amountnum").toString(); |
| | | Double amountnumss = Double.parseDouble(amountnums); |
| | | tamountnum += amountnumss; |
| | | |
| | | String userthismouth = list.get(i).get("userthismouth").toString(); |
| | | Integer userthismouths = Integer.parseInt(userthismouth); |
| | | lpznum += userthismouths; |
| | | String userlastmouth = list.get(i).get("userlastmouth").toString(); |
| | | Integer userlastmouths = Integer.parseInt(userlastmouth); |
| | | tpznum += userlastmouths; |
| | | |
| | | String usernums = list.get(i).get("usernum").toString(); |
| | | Integer usernumss = Integer.parseInt(usernums); |
| | | pznum += usernumss; |
| | | //公司派遣总数 |
| | | String userpcthismouth = list.get(i).get("userpcthismouth").toString(); |
| | | Integer userpcthismouths = Integer.parseInt(userpcthismouth); |
| | | lznum += userpcthismouths; |
| | | String userpclastmouth = list.get(i).get("userpclastmouth").toString(); |
| | | Integer userpclastmouths = Integer.parseInt(userpclastmouth); |
| | | tznum += userpclastmouths; |
| | | //缴纳社保总数 |
| | | String userpcnums = list.get(i).get("userpcnum").toString(); |
| | | Integer userpcnumss = Integer.parseInt(userpcnums); |
| | | sbnum += userpcnumss; |
| | | |
| | | } |
| | | map.put("lastmonth",lnum); |
| | | map.put("thismouth",tnum); |
| | | map.put("lastamount",lmount); |
| | | map.put("thisamount",tmount); |
| | | map.put("lastmonth", lnum); |
| | | map.put("thismouth", tnum); |
| | | map.put("znum", znum); |
| | | map.put("lastamount", lmount); |
| | | map.put("thisamount", tmount); |
| | | map.put("tamountnum", tamountnum); |
| | | map.put("userlastmouth", tpznum); |
| | | map.put("userthismouth", lpznum); |
| | | map.put("usernum", pznum); |
| | | map.put("userpcthismouth", lznum); |
| | | map.put("userpclastmouth", tznum); |
| | | map.put("userpcnum", sbnum); |
| | | lists.add(map); |
| | | return R.data(lists); |
| | | } |
| | |
| | | |
| | | /** |
| | | * 查询本年所有月份交社保人数 |
| | | * |
| | | * @return |
| | | */ |
| | | @GetMapping("/queryYearSoil") |
| | | public R queryYearSoil(String jurisdiction,String deptid) { |
| | | public R queryYearSoil(String jurisdiction, String deptid) { |
| | | Calendar cal = Calendar.getInstance(); |
| | | String year = String.valueOf(cal.get(Calendar.YEAR)); |
| | | Map<String, String> map = informationService.queryYearSoil(year,jurisdiction,deptid); |
| | | map = (HashMap<String, String>) sortMapBykeyAsc(map) ;//key升序 |
| | | Map<String, String> map = informationService.queryYearSoil(year, jurisdiction, deptid); |
| | | map = (HashMap<String, String>) sortMapBykeyAsc(map);//key升序 |
| | | return R.data(map); |
| | | } |
| | | |
| | | /** |
| | | * 查询本年所有月份社保金额 |
| | | * 查询本年所有月份派遣人数 |
| | | * |
| | | * @return |
| | | */ |
| | | @GetMapping("/queryYearPz") |
| | | public R queryYearPz(String jurisdiction, String deptid) { |
| | | Calendar cal = Calendar.getInstance(); |
| | | String year = String.valueOf(cal.get(Calendar.YEAR)); |
| | | Map<String, String> map = informationService.queryYearPz(year, jurisdiction, deptid); |
| | | map = (HashMap<String, String>) sortMapBykeyAsc(map);//key升序 |
| | | return R.data(map); |
| | | } |
| | | |
| | | /** |
| | | * 查询本年所有月份社保金额(公司经济运营趋势) |
| | | * |
| | | * @return |
| | | */ |
| | | @GetMapping("/queryYearAn") |
| | | public R queryYearAn(String jurisdiction,String deptid) { |
| | | public R queryYearAn(String jurisdiction, String deptid) { |
| | | Calendar cal = Calendar.getInstance(); |
| | | String year = String.valueOf(cal.get(Calendar.YEAR)); |
| | | Map<String, String> map = informationService.queryYearAn(year,jurisdiction,deptid); |
| | | map = (HashMap<String, String>) sortMapBykeyAsc(map) ;//key升序 |
| | | Map<String, String> map = informationService.queryYearAn(year, jurisdiction, deptid); |
| | | map = (HashMap<String, String>) sortMapBykeyAsc(map);//key升序 |
| | | return R.data(map); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 公司运营智能统计 |
| | | * |
| | | * @return |
| | | */ |
| | | @GetMapping("/queryCounts") |
| | | public R queryCounts(String jurisdiction,String deptid) { |
| | | public R queryCounts(String jurisdiction, String deptid) { |
| | | List<Map<String, Object>> lists = new ArrayList<>(); |
| | | Integer a=0; |
| | | Integer b=0; |
| | | Integer zca=0; |
| | | Integer zcb=0; |
| | | Integer cza=0; |
| | | Integer czb=0; |
| | | Integer sba=0; |
| | | Integer sbb=0; |
| | | Integer kha=0; |
| | | Integer khb=0; |
| | | Integer pqa=0; |
| | | Integer pqb=0; |
| | | Integer a = 0; |
| | | Integer b = 0; |
| | | Integer num = 0; |
| | | Integer znum = 0; |
| | | Integer cznum = 0; |
| | | Integer sbnum = 0; |
| | | Integer khnum = 0; |
| | | Integer pqnum = 0; |
| | | Integer zca = 0; |
| | | Integer zcb = 0; |
| | | Integer cza = 0; |
| | | Integer czb = 0; |
| | | Integer sba = 0; |
| | | Integer sbb = 0; |
| | | Integer kha = 0; |
| | | Integer khb = 0; |
| | | Integer pqa = 0; |
| | | Integer pqb = 0; |
| | | Integer integer = 0; |
| | | String deptname = null; |
| | | String jurname = null; |
| | | //保安员数量 |
| | | Map<String, Object> map = new HashMap<String, Object>(); |
| | | Map<String, Object> mapzc = new HashMap<String, Object>(); |
| | |
| | | Map<String, Object> mapkh = new HashMap<String, Object>(); |
| | | Map<String, Object> mappq = new HashMap<String, Object>(); |
| | | Map<String, Object> mapC = new HashMap<String, Object>(); |
| | | List<Map<Object, Integer>> maps = informationService.queryCountB(jurisdiction, deptid); |
| | | for (int i=0;i<maps.size();i++){ |
| | | List<Map<Object, Object>> maps = informationService.queryCountB(jurisdiction, deptid); |
| | | for (int i = 0; i < maps.size(); i++) { |
| | | //这个月数量 |
| | | a+=maps.get(i).get("thisnum"); |
| | | String thisnum = maps.get(i).get("thisnum").toString(); |
| | | a += Integer.valueOf(thisnum); |
| | | //上个月数量 |
| | | b+= maps.get(i).get("lastnum"); |
| | | |
| | | String lastnum = maps.get(i).get("lastnum").toString(); |
| | | b += Integer.valueOf(lastnum); |
| | | String nums = maps.get(i).get("num").toString(); |
| | | num += Integer.valueOf(nums); |
| | | String fznums = maps.get(i).get("fznum").toString(); |
| | | integer += Integer.valueOf(fznums); |
| | | } |
| | | map.put("thisnum",a); |
| | | map.put("lastnum",b); |
| | | mapC.put("baoan",map); |
| | | map.put("thisnum", a); |
| | | map.put("lastnum", b); |
| | | if(deptid.equals("")|| deptid.equals("null")){ |
| | | map.put("num", num-integer); |
| | | } |
| | | else { |
| | | map.put("num", num); |
| | | } |
| | | map.put("List", maps); |
| | | mapC.put("baoan", map); |
| | | //正常保安员数量 |
| | | List<Map<Object, Integer>> maps1 = informationService.queryCountZc(jurisdiction, deptid); |
| | | for (int i=0;i<maps1.size();i++){ |
| | | List<Map<Object, Object>> maps1 = informationService.queryCountZc(jurisdiction, deptid); |
| | | for (int i = 0; i < maps1.size(); i++) { |
| | | //这个月数量 |
| | | zca+= maps1.get(i).get("thisnum"); |
| | | String thisnum = maps1.get(i).get("thisnum").toString(); |
| | | zca += Integer.valueOf(thisnum); |
| | | //上个月数量 |
| | | zcb+= maps1.get(i).get("lastnum"); |
| | | String lastnum = maps1.get(i).get("lastnum").toString(); |
| | | zcb += Integer.valueOf(lastnum); |
| | | String nums = maps1.get(i).get("num").toString(); |
| | | znum += Integer.valueOf(nums); |
| | | } |
| | | mapzc.put("thisnum",zca); |
| | | mapzc.put("lastnum",zcb); |
| | | mapC.put("zcbaoan",mapzc); |
| | | mapzc.put("thisnum", zca); |
| | | mapzc.put("lastnum", zcb); |
| | | mapzc.put("num", znum); |
| | | mapzc.put("List", maps1); |
| | | mapC.put("zcbaoan", mapzc); |
| | | //持证保安数量 |
| | | List<Map<Object, Integer>> maps2 = informationService.queryCountCz(jurisdiction, deptid); |
| | | for (int i=0;i<maps2.size();i++){ |
| | | List<Map<Object, Object>> maps2 = informationService.queryCountCz(jurisdiction, deptid); |
| | | for (int i = 0; i < maps2.size(); i++) { |
| | | //这个月数量 |
| | | cza+=maps2.get(i).get("thisnum"); |
| | | String thisnum = maps2.get(i).get("thisnum").toString(); |
| | | cza += Integer.valueOf(thisnum); |
| | | //上个月数量 |
| | | czb+= maps2.get(i).get("lastnum"); |
| | | String lastnum = maps2.get(i).get("lastnum").toString(); |
| | | czb += Integer.valueOf(lastnum); |
| | | String nums = maps2.get(i).get("num").toString(); |
| | | cznum += Integer.valueOf(nums); |
| | | } |
| | | mapcz.put("thisnum",cza); |
| | | mapcz.put("lastnum",czb); |
| | | mapC.put("czbaoan",mapcz); |
| | | mapcz.put("thisnum", cza); |
| | | mapcz.put("lastnum", czb); |
| | | mapcz.put("num", cznum); |
| | | mapcz.put("List", maps2); |
| | | mapC.put("czbaoan", mapcz); |
| | | //缴纳社保数量 |
| | | List<Map<Object, Integer>> maps3 = informationService.queryCountSb(jurisdiction, deptid); |
| | | for (int i=0;i<maps3.size();i++){ |
| | | List<Map<Object, Object>> maps3 = informationService.queryCountSb(jurisdiction, deptid); |
| | | for (int i = 0; i < maps3.size(); i++) { |
| | | //这个月数量 |
| | | sba+=maps3.get(i).get("thisnum"); |
| | | String thisnum = maps3.get(i).get("thisnum").toString(); |
| | | sba += Integer.valueOf(thisnum); |
| | | //上个月数量 |
| | | sbb+=maps3.get(i).get("lastnum"); |
| | | String lastnum = maps3.get(i).get("lastnum").toString(); |
| | | sbb += Integer.valueOf(lastnum); |
| | | String nums = maps3.get(i).get("num").toString(); |
| | | sbnum += Integer.valueOf(nums); |
| | | } |
| | | mapsb.put("thisnum",sba); |
| | | mapsb.put("lastnum",sbb); |
| | | mapC.put("sbbaoan",mapsb); |
| | | mapsb.put("thisnum", sba); |
| | | mapsb.put("lastnum", sbb); |
| | | mapsb.put("num", sbnum); |
| | | mapsb.put("List", maps3); |
| | | mapC.put("sheb", mapsb); |
| | | //服务客户数量 |
| | | List<Map<Object, Integer>> maps4 = informationService.queryCountKh(jurisdiction, deptid); |
| | | for (int i=0;i<maps4.size();i++){ |
| | | List<Map<Object, Object>> maps4 = informationService.queryCountKh(jurisdiction, deptid); |
| | | for (int i = 0; i < maps4.size(); i++) { |
| | | //这个月数量 |
| | | kha+=maps4.get(i).get("thisnum"); |
| | | String thisnum = maps4.get(i).get("thisnum").toString(); |
| | | kha += Integer.valueOf(thisnum); |
| | | //上个月数量 |
| | | khb+=maps4.get(i).get("lastnum"); |
| | | String lastnum = maps4.get(i).get("lastnum").toString(); |
| | | khb += Integer.valueOf(lastnum); |
| | | String nums = maps4.get(i).get("num").toString(); |
| | | khnum += Integer.valueOf(nums); |
| | | } |
| | | mapkh.put("thisnum",kha); |
| | | mapkh.put("lastnum",khb); |
| | | mapC.put("kh",mapkh); |
| | | mapkh.put("thisnum", kha); |
| | | mapkh.put("lastnum", khb); |
| | | mapkh.put("num", khnum); |
| | | mapkh.put("List", maps4); |
| | | mapC.put("kh", mapkh); |
| | | //保安派遣数量 |
| | | List<Map<Object, Integer>> maps5 = informationService.queryCountPq(jurisdiction, deptid); |
| | | for (int i=0;i<maps5.size();i++){ |
| | | List<Map<Object, Object>> maps5 = informationService.queryCountPq(jurisdiction, deptid); |
| | | for (int i = 0; i < maps5.size(); i++) { |
| | | //这个月数量 |
| | | pqa+=maps5.get(i).get("thisnum"); |
| | | String thisnum = maps5.get(i).get("thisnum").toString(); |
| | | pqa += Integer.valueOf(thisnum); |
| | | //上个月数量 |
| | | pqb+=maps5.get(i).get("lastnum"); |
| | | String lastnum = maps5.get(i).get("lastnum").toString(); |
| | | pqb += Integer.valueOf(lastnum); |
| | | String nums = maps5.get(i).get("num").toString(); |
| | | pqnum += Integer.valueOf(nums); |
| | | } |
| | | mappq.put("thisnum",pqa); |
| | | mappq.put("lastnum",pqb); |
| | | mapC.put("paiq",mappq); |
| | | mappq.put("thisnum", pqa); |
| | | mappq.put("lastnum", pqb); |
| | | mappq.put("num", pqnum); |
| | | mappq.put("List", maps5); |
| | | mapC.put("paiq", mappq); |
| | | lists.add(mapC); |
| | | return R.data(lists); |
| | | } |
| | | |
| | | |
| | | |
| | | /** |
| | | * 查询本年公司运营智能统计 |
| | | * |
| | | * @return |
| | | */ |
| | | @GetMapping("/queryYearG") |
| | | public R queryYearG(String jurisdiction,String deptid) { |
| | | public R queryYearG(String jurisdiction, String deptid) { |
| | | Calendar cal = Calendar.getInstance(); |
| | | String year = String.valueOf(cal.get(Calendar.YEAR)); |
| | | Map<String, Object> mapz = new HashMap<String, Object>(); |
| | | Map<String, Object> mapzc1= new HashMap<String, Object>(); |
| | | Map<String, Object> mapcz1= new HashMap<String, Object>(); |
| | | Map<String, Object> mapsb1= new HashMap<String, Object>(); |
| | | Map<String, Object> mapzc1 = new HashMap<String, Object>(); |
| | | Map<String, Object> mapcz1 = new HashMap<String, Object>(); |
| | | Map<String, Object> mapsb1 = new HashMap<String, Object>(); |
| | | List<Map<String, Object>> lists = new ArrayList<>(); |
| | | Map<String, String> map = informationService.queryYearZ(year,jurisdiction,deptid); |
| | | map = (HashMap<String, String>) sortMapBykeyAsc(map) ;//key升序 |
| | | mapz.put("baoan",map); |
| | | Map<String, String> map = informationService.queryYearZ(year, jurisdiction, deptid); |
| | | map = (HashMap<String, String>) sortMapBykeyAsc(map);//key升序 |
| | | mapz.put("baoan", map); |
| | | lists.add(mapz); |
| | | //正常保安数量 |
| | | Map<String, String> mapzc = informationService.queryYearZc(year,jurisdiction,deptid); |
| | | mapzc = (HashMap<String, String>) sortMapBykeyAsc(mapzc) ;//key升序 |
| | | mapzc1.put("zc",mapzc); |
| | | Map<String, String> mapzc = informationService.queryYearZc(year, jurisdiction, deptid); |
| | | mapzc = (HashMap<String, String>) sortMapBykeyAsc(mapzc);//key升序 |
| | | mapzc1.put("zc", mapzc); |
| | | lists.add(mapzc1); |
| | | //保安持证数量 |
| | | Map<String, String> mapcz = informationService.queryYearZc(year,jurisdiction,deptid); |
| | | mapcz = (HashMap<String, String>) sortMapBykeyAsc(mapcz) ;//key升序 |
| | | mapcz1.put("cz",mapcz); |
| | | Map<String, String> mapcz = informationService.queryYearCz(year, jurisdiction, deptid); |
| | | mapcz = (HashMap<String, String>) sortMapBykeyAsc(mapcz);//key升序 |
| | | mapcz1.put("chiz", mapcz); |
| | | lists.add(mapcz1); |
| | | //缴纳社保数 |
| | | Map<String, String> mapsb = informationService.queryYearSoil(year,jurisdiction,deptid); |
| | | mapsb = (HashMap<String, String>) sortMapBykeyAsc(mapsb) ;//key升序 |
| | | mapsb1.put("sb",mapsb); |
| | | Map<String, String> mapsb = informationService.queryYearSoil(year, jurisdiction, deptid); |
| | | mapsb = (HashMap<String, String>) sortMapBykeyAsc(mapsb);//key升序 |
| | | mapsb1.put("sheb", mapsb); |
| | | //保安派遣 |
| | | Map<String, String> mapde = informationService.queryYearBanan(year, jurisdiction, deptid); |
| | | mapde = (HashMap<String, String>) sortMapBykeyAsc(mapde);//key升序 |
| | | mapsb1.put("paiq", mapde); |
| | | lists.add(mapsb1); |
| | | return R.data(lists); |
| | | } |
| | |
| | | |
| | | /** |
| | | * 查询本年所有月份的客户数量 |
| | | * |
| | | * @return |
| | | */ |
| | | @GetMapping("/queryYearKh") |
| | | public R queryYearKh(String jurisdiction,String deptid) { |
| | | public R queryYearKh(String jurisdiction, String deptid) { |
| | | Calendar cal = Calendar.getInstance(); |
| | | String year = String.valueOf(cal.get(Calendar.YEAR)); |
| | | Map<String, String> map = informationService.queryYearKh(year,jurisdiction,deptid); |
| | | map = (HashMap<String, String>) sortMapBykeyAsc(map) ;//key升序 |
| | | Map<String, String> map = informationService.queryYearKh(year, jurisdiction, deptid); |
| | | map = (HashMap<String, String>) sortMapBykeyAsc(map);//key升序 |
| | | return R.data(map); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 查询本年所有月份的保安派遣数量 |
| | | * |
| | | * @return |
| | | */ |
| | | @GetMapping("/queryYearBanan") |
| | | public R queryYearBanan(String jurisdiction, String deptid) { |
| | | Calendar cal = Calendar.getInstance(); |
| | | String year = String.valueOf(cal.get(Calendar.YEAR)); |
| | | Map<String, String> map = informationService.queryYearBanan(year, jurisdiction, deptid); |
| | | map = (HashMap<String, String>) sortMapBykeyAsc(map);//key升序 |
| | | return R.data(map); |
| | | } |
| | | |
| | | //升序 |
| | | public static Map<String, String> sortMapBykeyAsc(Map<String, String> oriMap) { |
| | | public static Map<String, String> sortMapBykeyAsc(Map<String, String> oriMap) { |
| | | Map<String, String> sortedMap = new LinkedHashMap<String, String>(); |
| | | try { |
| | | if (oriMap != null && !oriMap.isEmpty()) { |
| | |
| | | return sortedMap; |
| | | } |
| | | |
| | | /** |
| | | * 统计用户资格异常的数量 |
| | | * |
| | | * @return |
| | | */ |
| | | @PostMapping("/selectExtypeUser") |
| | | public int selectExtypeUser() { |
| | | return informationService.selectExtypeUser(); |
| | | } |
| | | |
| | | |
| | | |
| | | /** |
| | | * 单位删除 |
| | | */ |
| | | @PostMapping("/deleteDept") |
| | | public R deleteDept(String ids) { |
| | | informationService.deleteDept(ids); |
| | | return R.success("删除成功"); |
| | | } |
| | | |
| | | /** |
| | | * 保安员统计 |
| | | */ |
| | | @PostMapping("/selectLi") |
| | | public R<IPage> selectLi(String jurisdiction, String deptid, String stats, String startTime, String endTime, Query query) { |
| | | IPage list = informationService.selectLi(Condition.getPage(query), jurisdiction, deptid, stats, startTime, endTime); |
| | | 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); |
| | | } |
| | | |
| | | /** |
| | | * 保安员详情 |
| | | */ |
| | | @PostMapping("/selectUIn") |
| | | public R<IPage> selectUIn(String deptid, String name, String hold, String photo, String examinationtype, String dispatch, String soil, Query query) { |
| | | IPage list = informationService.selectUIn(Condition.getPage(query), deptid, name, hold, photo, examinationtype, dispatch, soil); |
| | | return R.data(list); |
| | | } |
| | | |
| | | /** |
| | | * 业务统计明细 |
| | | */ |
| | | @PostMapping("/selectDis") |
| | | public R<IPage> selectDis(String jurisdiction, String deptid, String fid, Query query) { |
| | | IPage list = informationService.selectDis(Condition.getPage(query), jurisdiction, deptid, fid); |
| | | return R.data(list); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 服务单位下拉 |
| | | */ |
| | | @PostMapping("/selectFw") |
| | | public R selectFw() { |
| | | List<Map<Object, Object>> list = informationService.selectFw(); |
| | | return R.data(list); |
| | | } |
| | | |
| | | /** |
| | | * 公司材料不全数量统计 |
| | | */ |
| | | @PostMapping("/selectCl") |
| | | public R selectCl(String jurisdiction) { |
| | | Map<String, Object> map = new HashMap<String, Object>(); |
| | | Integer count = 0; |
| | | List<Map<String, Object>> lists = new ArrayList<>(); |
| | | List<Map<Object, Object>> maps = informationService.selectCl(jurisdiction); |
| | | for (int i = 0; i < maps.size(); i++) { |
| | | String num = maps.get(i).get("num").toString(); |
| | | count += Integer.valueOf(num); |
| | | } |
| | | map.put("count", count); |
| | | map.put("list", maps); |
| | | lists.add(map); |
| | | return R.data(lists); |
| | | } |
| | | |
| | | /** |
| | | * @return |
| | | */ |
| | | @PostMapping("/selectAge") |
| | | public R selectAge(String jurisdiction, String deptid) { |
| | | List<Map<Object, Object>> list = informationService.selectAge(jurisdiction, deptid); |
| | | int qcount = 0;//青年 |
| | | int zcount = 0;//中年 |
| | | int lcount = 0;//老年 |
| | | for (int i = 0; i < list.size(); i++) { |
| | | String age = list.get(i).get("age").toString(); |
| | | int a = Integer.parseInt(age); |
| | | if (a <= 0) { |
| | | continue; |
| | | } else if (a >= 19 && a < 35) { |
| | | qcount++; |
| | | } else if (a >= 36 && a < 59) { |
| | | zcount++; |
| | | } else { |
| | | lcount++; |
| | | } |
| | | } |
| | | Map map = new HashMap(); |
| | | map.put("qcount", qcount); |
| | | map.put("zcount", zcount); |
| | | map.put("lcount", lcount); |
| | | return R.data(map); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 首页保安公司统计接口 |
| | | * |
| | | * @return |
| | | */ |
| | | @PostMapping("/SelectCount") |
| | | public R SelectCount() { |
| | | //查出所有辖区 |
| | | List<Map<Object, Object>> list = informationService.selJur(); |
| | | List<Map<String, Object>> lists = new ArrayList<>(); |
| | | for (int i = 0; i < list.size(); i++) { |
| | | Map<String, Object> map = new HashMap<String, Object>(); |
| | | Map<String, Object> mapc = new HashMap<String, Object>(); |
| | | String id = list.get(i).get("id").toString(); |
| | | //查出辖区下面所有的子菜单 |
| | | String childer = informationService.selJurchilder(id); |
| | | String[] split = childer.split(","); |
| | | String strArrays = ""; |
| | | for (int j = 0; j < split.length; j++) { |
| | | strArrays += "'" + split[j] + "',"; |
| | | } |
| | | String substring = strArrays.substring(0, strArrays.length() - 1); |
| | | List<Map<Object, Object>> maps = informationService.seleJuList(substring); |
| | | mapc.put("confess", maps.get(0).get("num")); |
| | | mapc.put("staff", maps.get(1).get("num")); |
| | | mapc.put("security", maps.get(2).get("num")); |
| | | mapc.put("armed", maps.get(3).get("num")); |
| | | mapc.put("region", maps.get(4).get("num")); |
| | | map.put("name", list.get(i).get("deptname")); |
| | | map.put("server", mapc); |
| | | lists.add(map); |
| | | } |
| | | return R.data(lists); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 首页保安持证统计接口 |
| | | * |
| | | * @return |
| | | */ |
| | | @PostMapping("/SelectCounthold") |
| | | public R SelectCounthold() { |
| | | List<Map<Object, Object>> list = informationService.selJur(); |
| | | List<Map<String, Object>> lists = new ArrayList<>(); |
| | | for (int i = 0; i < list.size(); i++) { |
| | | int cznumber = 0;//总的持证数量 |
| | | int wcznumber = 0;//总的未持证数量 |
| | | String id = list.get(i).get("id").toString(); |
| | | //查出辖区下面所有的子菜单 |
| | | String childer = informationService.selJurchilder(id); |
| | | String[] split = childer.split(","); |
| | | String strArrays = ""; |
| | | for (int j = 0; j < split.length; j++) { |
| | | strArrays += "'" + split[j] + "',"; |
| | | } |
| | | String deptid = strArrays.substring(0, strArrays.length() - 1); |
| | | Map<String, Object> map = new HashMap<String, Object>(); |
| | | List<Map<String, Object>> objectStringMap = iDeptService.selectHold(deptid); |
| | | if (objectStringMap.size() == 0) { |
| | | map.put("name", list.get(i).get("deptname")); |
| | | map.put("cz", cznumber); |
| | | map.put("wcz", wcznumber); |
| | | lists.add(map); |
| | | } else { |
| | | for (int c = 0; c < objectStringMap.size(); c++) { |
| | | String cz = objectStringMap.get(c).get("cz").toString(); |
| | | cznumber += Integer.valueOf(cz); |
| | | String wcz = objectStringMap.get(c).get("wcz").toString(); |
| | | wcznumber += Integer.valueOf(wcz); |
| | | } |
| | | map.put("name", list.get(i).get("deptname")); |
| | | map.put("cz", cznumber); |
| | | map.put("wcz", wcznumber); |
| | | lists.add(map); |
| | | |
| | | } |
| | | } |
| | | return R.data(lists); |
| | | } |
| | | |
| | | /** |
| | | * 统计保安员表现差的数量 |
| | | * |
| | | * @param jurisdiction |
| | | * @param deptid |
| | | * @param type 1:当天 2:当月 3:全部 |
| | | * @return |
| | | */ |
| | | @PostMapping("/selectBx") |
| | | public R selectBx(String jurisdiction, String deptid, String type) { |
| | | Map<String, Object> map = new HashMap<String, Object>(); |
| | | Integer count = 0; |
| | | List<Map<String, Object>> lists = new ArrayList<>(); |
| | | if (jurisdiction.equals("1372091709474910209") || "".equals(jurisdiction)) { |
| | | List<Map<Object, Object>> maps = informationService.selectBx(jurisdiction, deptid, type); |
| | | for (int i = 0; i < maps.size(); i++) { |
| | | String num = maps.get(i).get("num").toString(); |
| | | count += Integer.valueOf(num); |
| | | } |
| | | map.put("count", count); |
| | | map.put("list", maps); |
| | | lists.add(map); |
| | | } else { |
| | | // String childer = informationService.selJurchilder(jurisdiction); |
| | | // String[] split = childer.split(","); |
| | | // String strArrays = ""; |
| | | // for (int j = 0; j < split.length; j++) { |
| | | // strArrays += "'" + split[j] + "',"; |
| | | // } |
| | | // String jurisdictiond = strArrays.substring(0, strArrays.length() - 1); |
| | | List<Map<Object, Object>> maps = informationService.selectBx(jurisdiction, deptid, type); |
| | | for (int i = 0; i < maps.size(); i++) { |
| | | String num = maps.get(i).get("num").toString(); |
| | | count += Integer.valueOf(num); |
| | | } |
| | | map.put("count", count); |
| | | map.put("list", maps); |
| | | lists.add(map); |
| | | } |
| | | |
| | | return R.data(lists); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 统计保安员资格异常的数量 |
| | | * |
| | | * @param jurisdiction |
| | | * @param deptid |
| | | * @param type 1:当天 2:当月 3:全部 |
| | | * @return |
| | | */ |
| | | @PostMapping("/selectExtype") |
| | | public R selectExtype(String jurisdiction, String deptid, String type) { |
| | | Map<String, Object> map = new HashMap<String, Object>(); |
| | | Integer count = 0; |
| | | List<Map<String, Object>> lists = new ArrayList<>(); |
| | | if (jurisdiction.equals("1372091709474910209") || "".equals(jurisdiction)) { |
| | | List<Map<Object, Object>> maps = informationService.selectExtype(jurisdiction, deptid, type); |
| | | for (int i = 0; i < maps.size(); i++) { |
| | | String num = maps.get(i).get("num").toString(); |
| | | count += Integer.valueOf(num); |
| | | } |
| | | map.put("count", count); |
| | | map.put("list", maps); |
| | | lists.add(map); |
| | | } else { |
| | | String childer = informationService.selJurchilder(jurisdiction); |
| | | String[] split = childer.split(","); |
| | | String strArrays = ""; |
| | | for (int j = 0; j < split.length; j++) { |
| | | strArrays += "'" + split[j] + "',"; |
| | | } |
| | | String jurisdictiond = strArrays.substring(0, strArrays.length() - 1); |
| | | List<Map<Object, Object>> maps = informationService.selectExtype(jurisdictiond, deptid, type); |
| | | for (int i = 0; i < maps.size(); i++) { |
| | | String num = maps.get(i).get("num").toString(); |
| | | count += Integer.valueOf(num); |
| | | } |
| | | map.put("count", count); |
| | | map.put("list", maps); |
| | | lists.add(map); |
| | | } |
| | | |
| | | return R.data(lists); |
| | | } |
| | | |
| | | /** |
| | | * 违规经营 |
| | | */ |
| | | @PostMapping("/selectWg") |
| | | public R selectWg(String jurisdiction) { |
| | | if (jurisdiction.equals("1372091709474910209") || jurisdiction.equals("") ) { |
| | | List<Map<Object, Object>> list = informationService.selectWg(jurisdiction); |
| | | List list1 = new ArrayList(); |
| | | int count = 0; |
| | | Map map = new HashMap(); |
| | | for (int i = 0; i < list.size(); i++) { |
| | | //总数 |
| | | String znums = list.get(i).get("znum").toString(); |
| | | int znum = Integer.parseInt(znums); |
| | | //持证人数 |
| | | String cznums = list.get(i).get("cznum").toString(); |
| | | int cznum = Integer.parseInt(cznums); |
| | | //缴纳社保人数 |
| | | String sbnums = list.get(i).get("sbnum").toString(); |
| | | int sbnum = Integer.parseInt(sbnums); |
| | | //保安总人数为0 |
| | | if (znum == 0) { |
| | | continue; |
| | | } else { |
| | | int a = znum / 2; |
| | | if (cznum <= a || sbnum <= a) { |
| | | count++; |
| | | list1.add(list.get(i)); |
| | | } |
| | | } |
| | | } |
| | | map.put("count", count); |
| | | map.put("list", list1); |
| | | return R.data(map); |
| | | } else { |
| | | String childer = informationService.selJurchilder(jurisdiction); |
| | | String[] split = childer.split(","); |
| | | String strArrays = ""; |
| | | for (int j = 0; j < split.length; j++) { |
| | | strArrays += "'" + split[j] + "',"; |
| | | } |
| | | String jurisdictiond = strArrays.substring(0, strArrays.length() - 1); |
| | | List<Map<Object, Object>> list = informationService.selectWg(jurisdictiond); |
| | | List list1 = new ArrayList(); |
| | | int count = 0; |
| | | Map map = new HashMap(); |
| | | for (int i = 0; i < list.size(); i++) { |
| | | //总数 |
| | | String znums = list.get(i).get("znum").toString(); |
| | | int znum = Integer.parseInt(znums); |
| | | //持证人数 |
| | | String cznums = list.get(i).get("cznum").toString(); |
| | | int cznum = Integer.parseInt(cznums); |
| | | //缴纳社保人数 |
| | | String sbnums = list.get(i).get("sbnum").toString(); |
| | | int sbnum = Integer.parseInt(sbnums); |
| | | //保安总人数为0 |
| | | if (znum == 0) { |
| | | continue; |
| | | } else { |
| | | int a = znum / 2; |
| | | if (cznum <= a || sbnum <= a) { |
| | | count++; |
| | | list1.add(list.get(i)); |
| | | } |
| | | } |
| | | } |
| | | map.put("count", count); |
| | | map.put("list", list1); |
| | | return R.data(map); |
| | | } |
| | | |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 经营不善 |
| | | */ |
| | | @PostMapping("/selectJy") |
| | | public R selectJy(String jurisdiction) { |
| | | if (jurisdiction.equals("1372091709474910209")) { |
| | | List<Map<Object, Object>> list = informationService.selectJy(jurisdiction); |
| | | List list1 = new ArrayList(); |
| | | Map map = new HashMap(); |
| | | int count = 0; |
| | | for (int i = 0; i < list.size(); i++) { |
| | | String num = list.get(i).get("fwnum").toString(); |
| | | int a = Integer.parseInt(num); |
| | | if (a == 0) { |
| | | count++; |
| | | list1.add(list.get(i)); |
| | | } |
| | | } |
| | | map.put("count", count); |
| | | map.put("List", list1); |
| | | return R.data(map); |
| | | } else { |
| | | String childer = informationService.selJurchilder(jurisdiction); |
| | | String[] split = childer.split(","); |
| | | String strArrays = ""; |
| | | for (int j = 0; j < split.length; j++) { |
| | | strArrays += "'" + split[j] + "',"; |
| | | } |
| | | String jurisdictiond = strArrays.substring(0, strArrays.length() - 1); |
| | | List<Map<Object, Object>> list = informationService.selectJy(jurisdictiond); |
| | | List list1 = new ArrayList(); |
| | | Map map = new HashMap(); |
| | | int count = 0; |
| | | for (int i = 0; i < list.size(); i++) { |
| | | String num = list.get(i).get("fwnum").toString(); |
| | | int a = Integer.parseInt(num); |
| | | if (a == 0) { |
| | | count++; |
| | | list1.add(list.get(i)); |
| | | } |
| | | } |
| | | map.put("count", count); |
| | | map.put("List", list1); |
| | | return R.data(map); |
| | | } |
| | | |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 有实无名 |
| | | */ |
| | | @PostMapping("/selectYs") |
| | | public R selectYs(String jurisdiction) { |
| | | if (jurisdiction.equals("1372091709474910209")) { |
| | | List<Map<Object, Object>> list = informationService.selectYs(jurisdiction); |
| | | List list1 = new ArrayList(); |
| | | Map map = new HashMap(); |
| | | int count = 0; |
| | | for (int i = 0; i < list.size(); i++) { |
| | | String num = list.get(i).get("znum").toString(); |
| | | int a = Integer.parseInt(num); |
| | | if (a == 0) { |
| | | count++; |
| | | list1.add(list.get(i)); |
| | | } |
| | | } |
| | | map.put("count", count); |
| | | map.put("List", list1); |
| | | return R.data(map); |
| | | } else { |
| | | String childer = informationService.selJurchilder(jurisdiction); |
| | | String[] split = childer.split(","); |
| | | String strArrays = ""; |
| | | for (int j = 0; j < split.length; j++) { |
| | | strArrays += "'" + split[j] + "',"; |
| | | } |
| | | String jurisdictiond = strArrays.substring(0, strArrays.length() - 1); |
| | | List<Map<Object, Object>> list = informationService.selectYs(jurisdictiond); |
| | | List list1 = new ArrayList(); |
| | | Map map = new HashMap(); |
| | | int count = 0; |
| | | for (int i = 0; i < list.size(); i++) { |
| | | String num = list.get(i).get("znum").toString(); |
| | | int a = Integer.parseInt(num); |
| | | if (a == 0) { |
| | | count++; |
| | | list1.add(list.get(i)); |
| | | } |
| | | } |
| | | map.put("count", count); |
| | | map.put("List", list1); |
| | | return R.data(map); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 公司处罚数量统计 |
| | | */ |
| | | @PostMapping("/selectCf") |
| | | public R selectCf(String jurisdiction) { |
| | | Map<String, Object> map = new HashMap<String, Object>(); |
| | | Integer count = 0; |
| | | List<Map<String, Object>> lists = new ArrayList<>(); |
| | | if (jurisdiction.equals("1372091709474910209")) { |
| | | List<Map<Object, Object>> maps = informationService.selectCf(jurisdiction); |
| | | map.put("count", maps.size()); |
| | | return R.data(map); |
| | | } else { |
| | | String childer = informationService.selJurchilder(jurisdiction); |
| | | String[] split = childer.split(","); |
| | | String strArrays = ""; |
| | | for (int j = 0; j < split.length; j++) { |
| | | strArrays += "'" + split[j] + "',"; |
| | | } |
| | | String jurisdictiond = strArrays.substring(0, strArrays.length() - 1); |
| | | List<Map<Object, Object>> maps = informationService.selectCf(jurisdictiond); |
| | | map.put("count", maps.size()); |
| | | return R.data(map); |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 单位列表 |
| | | */ |
| | | @PostMapping("/selectIn") |
| | | public R selectIn(String jurisdiction) { |
| | | if (jurisdiction.equals("1372091709474910209") || "".equals(jurisdiction)) { |
| | | List<Map<Object, Object>> maps = informationService.selectIn(jurisdiction); |
| | | return R.data(maps); |
| | | } else { |
| | | String childer = informationService.selJurchilder(jurisdiction); |
| | | String[] split = childer.split(","); |
| | | String strArrays = ""; |
| | | for (int j = 0; j < split.length; j++) { |
| | | strArrays += "'" + split[j] + "',"; |
| | | } |
| | | String jurisdictiond = strArrays.substring(0, strArrays.length() - 1); |
| | | List<Map<Object, Object>> maps = informationService.selectIn(jurisdictiond); |
| | | return R.data(maps); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 公司运营情况进入图表 |
| | | */ |
| | | @PostMapping("/selectTb") |
| | | public R<IPage> selectTb(String jurisdiction, String enterpriseName, Query query) { |
| | | if (jurisdiction.equals("1372091709474910209") || "".equals(jurisdiction)) { |
| | | IPage list = informationService.selectTb(Condition.getPage(query), jurisdiction, enterpriseName); |
| | | return R.data(list); |
| | | } else { |
| | | String childer = informationService.selJurchilder(jurisdiction); |
| | | String[] split = childer.split(","); |
| | | String strArrays = ""; |
| | | for (int j = 0; j < split.length; j++) { |
| | | strArrays += "'" + split[j] + "',"; |
| | | } |
| | | String jurisdictiond = strArrays.substring(0, strArrays.length() - 1); |
| | | IPage list = informationService.selectTb(Condition.getPage(query), jurisdictiond, enterpriseName); |
| | | return R.data(list); |
| | | } |
| | | |
| | | } |
| | | |
| | | /** |
| | | * 公司经济情况进入图表 |
| | | */ |
| | | @PostMapping("/selectJj") |
| | | public R<IPage> selectJj(String jurisdiction, String enterpriseName, Query query) { |
| | | if (jurisdiction.equals("1372091709474910209") || "".equals(jurisdiction)) { |
| | | IPage list = informationService.selectJj(Condition.getPage(query), jurisdiction, enterpriseName); |
| | | return R.data(list); |
| | | } else { |
| | | String childer = informationService.selJurchilder(jurisdiction); |
| | | String[] split = childer.split(","); |
| | | String strArrays = ""; |
| | | for (int j = 0; j < split.length; j++) { |
| | | strArrays += "'" + split[j] + "',"; |
| | | } |
| | | String jurisdictiond = strArrays.substring(0, strArrays.length() - 1); |
| | | IPage list = informationService.selectJj(Condition.getPage(query), jurisdictiond, enterpriseName); |
| | | return R.data(list); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 业务统计情况 |
| | | */ |
| | | @PostMapping("/selectYw") |
| | | public R<IPage> selectYw(String jurisdiction, String deptid, String stats, String startTime, String endTime, Query query) { |
| | | if (jurisdiction.equals("1372091709474910209") || "".equals(jurisdiction)) { |
| | | IPage list = informationService.selectYw(Condition.getPage(query), jurisdiction, deptid, stats, startTime, endTime); |
| | | return R.data(list); |
| | | } else { |
| | | // String childer = informationService.selJurchilder(jurisdiction); |
| | | // String[] split = childer.split(","); |
| | | // String strArrays = ""; |
| | | // for (int j = 0; j < split.length; j++) { |
| | | // strArrays += "'" + split[j] + "',"; |
| | | // } |
| | | // String jurisdictiond = strArrays.substring(0, strArrays.length() - 1); |
| | | IPage list = informationService.selectYw(Condition.getPage(query), jurisdiction, deptid, stats, startTime, endTime); |
| | | return R.data(list); |
| | | } |
| | | } |
| | | |
| | | @PostMapping("/selectPCount") |
| | | public R selectPCount(String jurisdiction, String deptid) { |
| | | Map<String, Object> map = new HashMap<String, Object>(); |
| | | List<Map<String, Object>> lists = new ArrayList<>(); |
| | | // String childer = informationService.selJurchilder(jurisdiction); |
| | | // String[] split = childer.split(","); |
| | | // String strArrays = ""; |
| | | // for (int j = 0; j < split.length; j++) { |
| | | // strArrays += "'" + split[j] + "',"; |
| | | // } |
| | | Integer pnums = 0; |
| | | Integer wpnums = 0; |
| | | if (jurisdiction.equals("1372091709474910209") || "".equals(jurisdiction)) { |
| | | List<Map<String, Object>> list = informationService.seleP(jurisdiction, deptid); |
| | | for (int i = 0; i < list.size(); i++) { |
| | | String pnum = list.get(i).get("pnum").toString(); |
| | | Integer a = Integer.parseInt(pnum); |
| | | pnums += a; |
| | | String wpnum = list.get(i).get("wpnum").toString(); |
| | | Integer b = Integer.parseInt(wpnum); |
| | | wpnums += b; |
| | | } |
| | | } else { |
| | | //String jurisdictiond = strArrays.substring(0, strArrays.length() - 1); |
| | | List<Map<String, Object>> list = informationService.seleP(jurisdiction, deptid); |
| | | for (int i = 0; i < list.size(); i++) { |
| | | String pnum = list.get(i).get("pnum").toString(); |
| | | Integer a = Integer.parseInt(pnum); |
| | | pnums += a; |
| | | String wpnum = list.get(i).get("wpnum").toString(); |
| | | Integer b = Integer.parseInt(wpnum); |
| | | wpnums += b; |
| | | } |
| | | } |
| | | // Map map1 = informationService.selectPcount(jurisdiction, deptid); |
| | | // String pnum = map1.get("pnum").toString(); |
| | | // Integer a = Integer.valueOf(pnum); |
| | | // Map map2 = informationService.selectWPcount(jurisdiction, deptid); |
| | | // String wpnum = map2.get("wpnum").toString(); |
| | | // Integer b = Integer.valueOf(wpnum); |
| | | map.put("PCount", pnums); |
| | | map.put("WPCount", wpnums); |
| | | lists.add(map); |
| | | return R.data(lists); |
| | | } |
| | | |
| | | /** |
| | | * 分局预警统计 |
| | | */ |
| | | @PostMapping("/selectFj") |
| | | public R selectFj() { |
| | | //辖区信息 |
| | | List<Map<Object, Object>> list = informationService.selectJur(); |
| | | List<Map<String, Object>> lists = new ArrayList<>(); |
| | | for (int i = 0; i < list.size(); i++) { |
| | | Integer count = 0; |
| | | int countwg = 0; |
| | | int countjy = 0; |
| | | int countwm = 0; |
| | | Map<String, Object> map = new HashMap<String, Object>(); |
| | | //辖区id |
| | | String id = list.get(i).get("id").toString(); |
| | | //辖区名称 |
| | | String jurname = list.get(i).get("dept_name").toString(); |
| | | String childer = informationService.selJurchilder(id); |
| | | String[] split = childer.split(","); |
| | | String strArrays = ""; |
| | | for (int j = 0; j < split.length; j++) { |
| | | strArrays += "'" + split[j] + "',"; |
| | | } |
| | | String jurisdiction = strArrays.substring(0, strArrays.length() - 1); |
| | | //保安员表现差预警数量 |
| | | List<Map<Object, Object>> mapbx = informationService.selectBx(jurisdiction, "", ""); |
| | | for (int ibx = 0; ibx < mapbx.size(); ibx++) { |
| | | String num = mapbx.get(ibx).get("num").toString(); |
| | | count += Integer.valueOf(num); |
| | | } |
| | | //保安员资格异常的数量 |
| | | List<Map<Object, Object>> mapEx = informationService.selectExtype(jurisdiction, "", ""); |
| | | for (int iex = 0; iex < mapEx.size(); iex++) { |
| | | String num = mapEx.get(iex).get("num").toString(); |
| | | count += Integer.valueOf(num); |
| | | } |
| | | List<Map<Object, Object>> maps = informationService.seleFj(jurisdiction); |
| | | for (int z = 0; z < maps.size(); z++) { |
| | | //违规经营 |
| | | //总数 |
| | | String znums = maps.get(z).get("znum").toString(); |
| | | int znum = Integer.parseInt(znums); |
| | | //持证人数 |
| | | String cznums = maps.get(z).get("cznum").toString(); |
| | | int cznum = Integer.parseInt(cznums); |
| | | //缴纳社保人数 |
| | | String sbnums = maps.get(z).get("sbnum").toString(); |
| | | int sbnum = Integer.parseInt(sbnums); |
| | | //保安总人数为0 |
| | | if (znum == 0) { |
| | | } else { |
| | | int a = znum / 2; |
| | | if (cznum <= a || sbnum <= a) { |
| | | countwg++; |
| | | } |
| | | } |
| | | //经营不善 |
| | | String num = maps.get(z).get("fwnum").toString(); |
| | | int a = Integer.parseInt(num); |
| | | if (a == 0) { |
| | | countjy++; |
| | | } |
| | | //有实无名 |
| | | String numw = maps.get(z).get("znum").toString(); |
| | | int aw = Integer.parseInt(numw); |
| | | if (aw == 0) { |
| | | countwm++; |
| | | } |
| | | } |
| | | //处罚 |
| | | List<Map<Object, Object>> mapc = informationService.selectCf(jurisdiction); |
| | | int size = mapc.size(); |
| | | map.put("Count", count + countjy + countwg + countwm + size); |
| | | map.put("jurname", jurname); |
| | | lists.add(map); |
| | | } |
| | | return R.data(lists); |
| | | } |
| | | |
| | | @PostMapping("/selectBxc") |
| | | public R<IPage> selectBxc(String jurisdiction,String type,Query query) { |
| | | IPage maps = informationService.selectBxc(Condition.getPage(query), jurisdiction,type); |
| | | return R.data(maps); |
| | | } |
| | | |
| | | /** |
| | | * 获取部门信息() |
| | | * @param information |
| | | * @return |
| | | */ |
| | | @GetMapping("/getInformationDetails") |
| | | public R getInformationDetails(InformationVO information) { |
| | | return R.data(informationService.getInformationDetails(information)); |
| | | } |
| | | } |