锁的位置管理

whyclxw

2025-04-22 c510153793c2a4e0dc7d845d8944315776088320

锁的位置管理

 src/main/java/com/whyc/mapper/LockAddressMapper.java

@@ -8,4 +8,6 @@
public interface LockAddressMapper extends CustomMapper<LockAddress>{
    //锁的位置信息
    List<LockAddress> getAddressList(@Param("lockIdList") List<Integer> lockIdList);
    //机房下所有锁的位置
    List<LockAddress> getAllAddress(@Param("stationId") Integer stationId);
}

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

@@ -255,8 +255,10 @@
        //根据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));
@@ -283,7 +285,7 @@
        }
        PageInfo pageInfo= PageInfoUtils.list2PageInfo(linfs, dto.getPageNum(), dto.getPageSize());
        map.put("pageInfo",pageInfo);
        return new Response().setIII(1,linfs!=null,map,addressList,"实时获取获取区域下所有锁的状态");
        return new Response().setIV(1,linfs!=null,map,addressList,AllAddressList,"实时获取获取区域下所有锁的状态");
    }
    //查询锁的信息和id卡
    public Response getLockId(LockIdDto dto) {

 src/main/resources/mapper/LockAddressMapper.xml

@@ -14,4 +14,13 @@
            </if>
        </where>
    </select>
    <select id="getAllAddress" resultType="com.whyc.pojo.plus_inf.LockAddress">
        select tb_lock_address.*
        from plus_inf.tb_lock_address
        <where>
            <if test="stationId!=null">
                and tb_lock_address.station_id=#{stationId}
            </if>
        </where>
    </select>
</mapper>