| | |
| | | queryWrapper.eq("monitor_point_id", mpId); |
| | | } |
| | | |
| | | |
| | | //设备名称或mac模糊查询 |
| | | if (name != null && mac != null) { |
| | | queryWrapper.like("name", name).or().like("mac", mac); |
| | | queryWrapper.eq("is_delete", Constants.NOT_DELETE).like("name", name).or().like("mac", mac); |
| | | } |
| | | |
| | | //排序参数,默认create_time降序 |
| | |
| | | } else { |
| | | queryWrapper.orderByDesc("create_time"); |
| | | } |
| | | //过滤已删除的数据 |
| | | queryWrapper.eq("is_delete", Constants.NOT_DELETE); |
| | | |
| | | Page<Device> devicePage = new Page<>(page, size); |
| | | deviceMapper.selectPage(devicePage, queryWrapper); |
| | | List<Device> devices = devicePage.getRecords(); |
| | |
| | | } |
| | | |
| | | @Override |
| | | @Transactional |
| | | public void judgeDeviceState(Map<String, Object> deviceData) { |
| | | String mac = deviceData.remove("mac").toString(); |
| | | Device device = (Device) redisTemplate.opsForHash().get(RedisConstants.DEVICE_INFO, mac); |
| | |
| | | } |
| | | } |
| | | //修改设备状态 |
| | | UpdateWrapper<Device> updateWrapper = new UpdateWrapper<>(); |
| | | updateWrapper.eq("id", device.getId()).set("state", String.valueOf(state)); |
| | | deviceMapper.update(null, updateWrapper); |
| | | Device device1 = new Device(); |
| | | device1.setId(device.getId()); |
| | | device1.setState(String.valueOf(state)); |
| | | deviceMapper.updateById(device1); |
| | | } |
| | | |
| | | @Override |