| | |
| | | import com.moral.common.bean.Constants;
|
| | | import com.moral.common.bean.PageBean;
|
| | | import com.moral.common.bean.PageResult;
|
| | | import com.moral.common.exception.BusinessException;
|
| | | import com.moral.common.util.ExampleUtil;
|
| | | import com.moral.common.util.RedisUtils;
|
| | | import com.moral.mapper.MonitorPointMapper;
|
| | | import org.apache.commons.collections.MapUtils;
|
| | | import org.apache.commons.lang3.BooleanUtils;
|
| | | import org.apache.commons.lang3.StringUtils;
|
| | | import org.apache.log4j.Logger;
|
| | | import org.springframework.stereotype.Service;
|
| | | import org.springframework.transaction.annotation.Transactional;
|
| | | import org.springframework.util.ObjectUtils;
|
| | |
| | |
|
| | | @Service
|
| | | public class DeviceServiceImpl implements DeviceService {
|
| | |
|
| | | Logger log = Logger.getLogger(DeviceServiceImpl.class);
|
| | | //-----------------------redis key前缀-开始---------------------------------
|
| | | private static String AlARM = "alarm";//警报阀值储存key前缀
|
| | | private static String ADJUST="adjust";//校准值存储key前缀
|
| | | private static String DEVICE = "device";//设备信息数据key前缀
|
| | | private static String STATE = "state";//设备实时状态key前缀
|
| | | private static String DATA = "data";//设备实时数据key前缀
|
| | | //-----------------------redis key前缀-结束---------------------------------
|
| | | private String keysConnect(String... keys) {
|
| | | StringBuilder key = new StringBuilder(keys[0]);
|
| | | for(int i=1;i<keys.length;i++) {
|
| | | key.append("_");
|
| | | key.append(keys[i]);
|
| | | }
|
| | | return key.toString().toLowerCase();
|
| | | }
|
| | | @Resource
|
| | | private DeviceMapper deviceMapper;
|
| | | @Resource
|
| | |
| | | device.setId(queryDevice.getId());
|
| | | deviceMapper.updateByPrimaryKeySelective(device);
|
| | | }
|
| | | //刷新redis里的信息
|
| | | refreshDeviceInRedis(device.getMac());
|
| | | }
|
| | |
|
| | | @Override
|
| | |
| | | ValidateUtil.notNull(uid, "param.is.null");
|
| | | Device device = new Device();
|
| | | device.setOperateUserId(uid);
|
| | | PageHelper.startPage(pageIndex, pageSize);
|
| | | PageHelper.startPage(pageIndex, pageSize,false);
|
| | | List<Device> devices = deviceMapper.select(device);
|
| | | return devices;
|
| | | }
|
| | |
|
| | | /**
|
| | | *
|
| | | * @param mac
|
| | | * @param fromCache
|
| | | * @return 包含组织数组
|
| | | */
|
| | | @Override
|
| | | public Device getDeviceByMac (String mac ,boolean fromCache){
|
| | | if(fromCache){
|
| | | Device device = getDeviceFromRedis(mac);
|
| | | if(device==null) {
|
| | | device = deviceMapper.selectWithOrgIdsByMac(mac);
|
| | | if(device!=null){
|
| | | setDeviceToRedis(mac,device);
|
| | | }
|
| | | }
|
| | | return device;
|
| | | }else {
|
| | | return deviceMapper.selectWithOrgIdsByMac(mac);
|
| | | }
|
| | |
|
| | | }
|
| | |
|
| | | /**
|
| | | * 默认会从缓存取
|
| | | * @param mac
|
| | | * @return
|
| | | */
|
| | | @Override
|
| | | public Device getDeviceByMac(String mac) {
|
| | | ValidateUtil.notEmpty(mac, "param.is.null");
|
| | | Device device = new Device();
|
| | | device.setMac(mac);
|
| | | device = deviceMapper.selectOne(device);
|
| | | return device;
|
| | |
|
| | | return getDeviceByMac(mac,true);
|
| | | }
|
| | | /*
|
| | | * 获取报警阀值在redis里的key
|
| | | */
|
| | | private String getDeviceKey(String mac) {
|
| | | return keysConnect(DEVICE,mac);
|
| | | }
|
| | | /*
|
| | | * 将校正值存入redis方法组 开始
|
| | | */
|
| | | private void setDeviceToRedis(String mac,Device device){
|
| | | String key = getDeviceKey(mac);
|
| | | Device simpleDevice = new Device();
|
| | | simpleDevice.setId(device.getId());// id
|
| | | simpleDevice.setName(device.getName());// name
|
| | | simpleDevice.setAddress(device.getAddress());// address
|
| | | simpleDevice.setDeviceVersionId(device.getDeviceVersionId());// version
|
| | | simpleDevice.setMac(device.getMac()); // mac
|
| | | simpleDevice.setMonitorPointId(device.getMonitorPointId());// 监控地id
|
| | | simpleDevice.setOrganizationIds(device.getOrganizationIds());// 组织数组
|
| | | redisUtils.set(key,simpleDevice);
|
| | | }
|
| | | private Device getDeviceFromRedis(String mac) {
|
| | | String key = getDeviceKey(mac);
|
| | | return redisUtils.get(key,Device.class);
|
| | | }
|
| | |
|
| | | /**
|
| | | *
|
| | | * @param map
|
| | | * map里 包括 组织id和4个坐标点
|
| | | * @return
|
| | | * @return 返回未删除结果集
|
| | | */
|
| | | @Override
|
| | | public List<Device> query(Map<String, Object> map) {
|
| | |
| | | * @param deviceName
|
| | | * @param pageSize
|
| | | * @param pageNo
|
| | | * @return
|
| | | * @return 返回未删除结果
|
| | | */
|
| | | @Override
|
| | | public PageResult query(Integer orgId, String deviceName, Integer pageSize, Integer pageNo) {
|
| | | if(!ObjectUtils.isEmpty(pageSize)&&!ObjectUtils.isEmpty(pageNo)){
|
| | | PageHelper.startPage(pageNo,pageSize);
|
| | | }
|
| | | List<Device> list = deviceMapper.selectByOrgIdAndDevName(orgId,deviceName);
|
| | | String state = null;
|
| | | switch (deviceName){
|
| | | case "正常":
|
| | | state = "0";
|
| | | deviceName = null;break;
|
| | | case "轻度":
|
| | | state = "1";
|
| | | deviceName = null;break;
|
| | | case "中度":
|
| | | state = "2";
|
| | | deviceName = null;break;
|
| | | case "重度":
|
| | | state = "3";
|
| | | deviceName = null;break;
|
| | | case "维保":
|
| | | state = "4";
|
| | | deviceName = null;break;
|
| | | }
|
| | | List<Device> list = deviceMapper.selectByOrgIdAndDevName(orgId,state,deviceName);
|
| | | //从redis里取状态
|
| | | loadDeviceState(list);
|
| | | if(list instanceof Page){
|
| | |
| | | * @param mpId
|
| | | * @param pageSize
|
| | | * @param pageNo
|
| | | * @return
|
| | | * @return 返回未删除结果
|
| | | */
|
| | | @Override
|
| | | public PageResult query(Integer orgId, Integer mpId, Integer pageSize, Integer pageNo) {
|
| | |
| | | }
|
| | | return device;
|
| | | }
|
| | | /*
|
| | | 刷新 redis 设备的信息
|
| | |
|
| | | /**
|
| | | * 要在数据库更改后刷新
|
| | | * 刷新 redis 设备的信息
|
| | | * @param mac
|
| | | */
|
| | | private void refreshDeviceInRedis(Device device){
|
| | | if(!StringUtils.isBlank(device.getMac())){
|
| | | Device simpleDevice = new Device();
|
| | | simpleDevice.setId(device.getId());// id
|
| | | simpleDevice.setName(device.getName());// name
|
| | | simpleDevice.setAddress(device.getAddress());// address
|
| | | simpleDevice.setDeviceVersionId(device.getDeviceVersionId());// version
|
| | | simpleDevice.setMac(device.getMac()); // mac
|
| | | simpleDevice.setMonitorPointId(device.getMonitorPointId());// 监控地id
|
| | | simpleDevice.setOrganizationIds(device.getOrganizationIds());// 组织数组
|
| | | if(device.getMonitorPointId()!=null){
|
| | | List<Integer> orgIds = monitorPointMapper.selectOrganizationIds(device.getMonitorPointId());
|
| | | simpleDevice.setOrganizationIds(orgIds);
|
| | | }
|
| | | String key = "device_"+device.getMac();
|
| | | redisUtils.set(key,simpleDevice);
|
| | | }
|
| | | private void refreshDeviceInRedis(String mac){
|
| | | if(!StringUtils.isBlank(mac)){
|
| | | Device devQuery = new Device();
|
| | | devQuery.setMac(mac);
|
| | | Device device = deviceMapper.selectOne(devQuery);
|
| | | if(device.getMonitorPointId()!=null){
|
| | | List<Integer> orgIds = monitorPointMapper.selectOrganizationIds(device.getMonitorPointId());
|
| | | device.setOrganizationIds(orgIds);
|
| | | }
|
| | | String key = "device_"+mac;
|
| | | redisUtils.set(key,device);
|
| | | }else
|
| | | {
|
| | | log.warn("param mac is null in method [refreshDeviceInRedis]");
|
| | | }
|
| | | }
|
| | | @Override
|
| | | public PageBean queryByPageBean(PageBean pageBean) {
|
| | | public int countByExample(PageBean pageBean){
|
| | | Example example = ExampleUtil.generateExample(ENTITY_CLASS,pageBean);
|
| | | addDeletesToExample(example);
|
| | | return deviceMapper.selectCountByExample(example);
|
| | | }
|
| | |
|
| | | /**
|
| | | * 增加删除条件过滤
|
| | | * @param example
|
| | | */
|
| | | private void addDeletesToExample(Example example){
|
| | | List<Example.Criteria> criteriaList = example.getOredCriteria();
|
| | | if(criteriaList!=null&&criteriaList.size()>0){
|
| | | for(Example.Criteria cri : criteriaList){
|
| | |
| | | }else {
|
| | | example.or().andNotEqualTo("isDelete",Constants.IS_DELETE_TRUE);
|
| | | }
|
| | | }
|
| | | @Override
|
| | | public PageBean queryByPageBean(PageBean pageBean) {
|
| | | Example example = ExampleUtil.generateExample(ENTITY_CLASS,pageBean);
|
| | | addDeletesToExample(example);
|
| | | if(pageBean.getPageSize()>0){
|
| | | PageHelper.startPage(pageBean.getPageIndex(),pageBean.getPageSize());
|
| | | }
|
| | |
| | | Device device = new Device();
|
| | | device.setIsDelete(Constants.IS_DELETE_TRUE);
|
| | | if(ids!=null&&ids.length>0){
|
| | | Example example = new Example(ENTITY_CLASS);
|
| | | example.or().andIn("id", Arrays.asList(ids));
|
| | | if(ids.length==1){
|
| | | device.setId(ids[0]);
|
| | | deviceMapper.updateByPrimaryKeySelective(device);
|
| | | }else{
|
| | | Example example = new Example(ENTITY_CLASS);
|
| | | example.or().andIn("id", Arrays.asList(ids));
|
| | | deviceMapper.updateByExampleSelective(device,example);
|
| | | }
|
| | |
|
| | | List<Device> deviceList = deviceMapper.selectByExample(example);
|
| | | List<String> adjustAndDeviceKeys = deviceList.stream().collect(
|
| | | ArrayList<String>::new,
|
| | | (list,dev) -> {
|
| | | if(!StringUtils.isBlank(dev.getMac())){
|
| | | list.add("device_"+dev.getMac());
|
| | | list.add("adjust_"+dev.getMac());
|
| | | }
|
| | | },
|
| | | (oList,nList)-> {
|
| | | oList.addAll(nList);
|
| | | }
|
| | | );
|
| | | redisUtils.remove(adjustAndDeviceKeys.toArray(new String [adjustAndDeviceKeys.size()]));
|
| | | }
|
| | | }
|
| | |
|
| | |
| | | public void addOrModify(Device device){
|
| | | try{
|
| | | //mac 转小写
|
| | | if(StringUtils.isBlank(device.getMac())){
|
| | | if(!StringUtils.isBlank(device.getMac())){
|
| | | device.setMac(device.getMac().toLowerCase());
|
| | | }
|
| | | if(device.getId()==null){
|
| | |
| | | deviceMapper.insertSelective(device);
|
| | | }else{
|
| | | deviceMapper.updateByPrimaryKeySelective(device);
|
| | | //刷新redis里设备信息
|
| | | refreshDeviceInRedis(device);
|
| | | }
|
| | | //刷新redis里设备信息
|
| | | refreshDeviceInRedis(device.getMac());
|
| | | }
|
| | | catch (Exception ex){
|
| | | throw ex;
|
| | | }
|
| | | }
|
| | |
|
| | | @Override
|
| | | public List<Map> countByTimes(Date start,Date end,String format){
|
| | | if(start==null||end==null||StringUtils.isBlank(format)){
|
| | | log.error("some params is null");
|
| | | throw new BusinessException("some params is null");
|
| | | }
|
| | | return deviceMapper.countByTimes(start, end, format);
|
| | | }
|
| | | @Override
|
| | | public List<Device> getDevicesByMonitorPointId(Integer monitorPointId) {
|
| | | Device device = new Device();
|
| | |
| | | }).collect(Collectors.toList());
|
| | | return list;
|
| | | }
|
| | |
|
| | | @Override
|
| | | public Device queryById(Integer id) {
|
| | | return deviceMapper.selectByPrimaryKey(id);
|
| | | }
|
| | |
|
| | | @Override
|
| | | public List<Device> getDevicesByProfessionId(Map<String, Object> parameters) {
|
| | | |
| | | return deviceMapper.getDevicesByProfession(parameters);
|
| | | }
|
| | |
|
| | | }
|