推送和导出

whyclxw

2025-04-28 73729d9227f8c1af365a09948553975e9805ab68

推送和导出

 src/main/java/com/whyc/service/ExportService.java

@@ -36,7 +36,6 @@
                ,"plus_lock_his","tb_lock_his_"+lockId,his);
        //获取锁的信息
        LockInf linf=linfMapper.getlinfBylockId(lockId);

        //当前日期
        String nowFormat = new SimpleDateFormat("yyyyMMddHHmmss").format(new Date());
        String excelName = "bl-"+nowFormat;
@@ -52,7 +51,6 @@
        row1.setHeightInPoints(20.0f);
        row1.createCell(0).setCellValue("所属机房："+linf.getStationName());
        row1.createCell(1).setCellValue("锁的名称："+linf.getLockName());
        row1.createCell(2).setCellValue("锁的类型：实体锁");
        rowNumSheet++;

        Row row2 =  sheet.createRow(rowNumSheet);

 src/main/java/com/whyc/service/LockInfService.java

@@ -284,39 +284,43 @@
        map.put("closeNum",0);
        map.put("unLoadNum",0);
        //根据dto中stationid和包机组id查询出管理的lockid
        List<Integer> lockIdList=bjLockMapper.getLocIdByStationidAndBjId(dto.getStationId(),dto.getBaojiId());
        List<LockInf> linfs=mapper.getRealLock(lockIdList);
        //包机组下锁的位置信息
        List<LockAddress> addressList=addressMapper.getAddressList(lockIdList);
        //机房下所有锁的位置
        List<LockAddress> AllAddressList=addressMapper.getAllAddress(dto.getStationId());
        if(linfs!=null&&linfs.size()>0){
            map.put("sumLinf",linfs.size());
            Map<Integer, List<LockInf>> onlinemap = linfs.stream().collect(Collectors.groupingBy(LockInf::getLockOnline));
            for (Integer state : onlinemap.keySet()) {
                if(state==0){
                    map.put("offLineNum", onlinemap.get(0).size());//离线
        try {
            List<Integer> lockIdList=bjLockMapper.getLocIdByStationidAndBjId(dto.getStationId(),dto.getBaojiId());
            List<LockInf> linfs=mapper.getRealLock(lockIdList);
            //包机组下锁的位置信息
            List<LockAddress> addressList=addressMapper.getAddressList(lockIdList);
            //机房下所有锁的位置
            List<LockAddress> AllAddressList=addressMapper.getAllAddress(dto.getStationId());
            if(linfs!=null&&linfs.size()>0){
                map.put("sumLinf",linfs.size());
                Map<Integer, List<LockInf>> onlinemap = linfs.stream().collect(Collectors.groupingBy(LockInf::getLockOnline));
                for (Integer state : onlinemap.keySet()) {
                    if(state==0){
                        map.put("offLineNum", onlinemap.get(0).size());//离线
                    }
                    if(state==1){
                        map.put("onlineNum", onlinemap.get(1).size());//在线
                    }
                }
                if(state==1){
                    map.put("onlineNum", onlinemap.get(1).size());//在线
                Map<Integer, List<LockInf>> openmap = linfs.stream().collect(Collectors.groupingBy(LockInf::getLockState));
                for (Integer open : openmap.keySet()) {
                    if(open==0){
                        map.put("closeNum", openmap.get(0).size());//闭锁
                    }
                    if(open==1){
                        map.put("openNum", openmap.get(1).size());//开锁
                    }
                    if(open==-1){
                        map.put("unLoadNum", openmap.get(-1).size());//未安装
                    }
                }
            }
            Map<Integer, List<LockInf>> openmap = linfs.stream().collect(Collectors.groupingBy(LockInf::getLockState));
            for (Integer open : openmap.keySet()) {
                if(open==0){
                    map.put("closeNum", openmap.get(0).size());//闭锁
                }
                if(open==1){
                    map.put("openNum", openmap.get(1).size());//开锁
                }
                if(open==-1){
                    map.put("unLoadNum", openmap.get(-1).size());//未安装
                }
            }
            PageInfo pageInfo= PageInfoUtils.list2PageInfo(linfs, dto.getPageNum(), dto.getPageSize());
            map.put("pageInfo",pageInfo);
            return new Response().setIV(1,linfs!=null,map,addressList,AllAddressList,"实时获取获取区域下所有锁的状态");
        } catch (Exception e) {
            return new Response().set(1,false,"实时获取获取区域下所有锁的状态");
        }
        PageInfo pageInfo= PageInfoUtils.list2PageInfo(linfs, dto.getPageNum(), dto.getPageSize());
        map.put("pageInfo",pageInfo);
        return new Response().setIV(1,linfs!=null,map,addressList,AllAddressList,"实时获取获取区域下所有锁的状态");
    }
    //查询锁的信息和id卡
    public Response getLockId(LockIdDto dto) {

 src/main/resources/mapper/LockInfMapper.xml

@@ -67,8 +67,8 @@
        ,tb_station_inf.station_name,tb_station_inf.station_name1,tb_station_inf.station_name2,tb_station_inf.station_name3,tb_station_inf.station_name4
        from plus_inf.tb_lock_inf,plus_inf.tb_station_inf
        <where>
            and tb_lock_inf.del_flag=0
            tb_lock_inf.station_id=tb_station_inf.station_id
            and tb_lock_inf.del_flag=0
            and lock_id=#{lockId}
        </where>
        order by tb_lock_inf.num asc