From c599900db9ab533bc702b94b19ac89edbe191724 Mon Sep 17 00:00:00 2001 From: xufenglei <xufenglei> Date: Mon, 23 Apr 2018 16:08:35 +0800 Subject: [PATCH] 报警 级别 --- src/main/java/com/moral/service/impl/MonitorPointServiceImpl.java | 28 +++++++++++++++++++++++++++- 1 files changed, 27 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/moral/service/impl/MonitorPointServiceImpl.java b/src/main/java/com/moral/service/impl/MonitorPointServiceImpl.java index baa1462..3274397 100644 --- a/src/main/java/com/moral/service/impl/MonitorPointServiceImpl.java +++ b/src/main/java/com/moral/service/impl/MonitorPointServiceImpl.java @@ -1,5 +1,6 @@ package com.moral.service.impl; +import java.util.ArrayList; import java.util.Arrays; import java.util.HashMap; import java.util.List; @@ -43,6 +44,7 @@ } @Override public List<MonitorPoint> queryWithStateByMap(Map<String, Object> params){ + params.put("isDelete",Constants.IS_DELETE_FALSE); List<MonitorPoint> monitorPointList = monitorPointMapper.selectByMap(params); for(MonitorPoint monitorPoint:monitorPointList){ Integer state = getStateFromRedis(monitorPoint.getId()); @@ -153,10 +155,25 @@ Criteria criteria = example.createCriteria(); criteria.andEqualTo("isDelete", Constants.IS_DELETE_FALSE).andLike("name", "%" + name + "%"); - example.or().andEqualTo("isDelete", Constants.IS_DELETE_FALSE).andCondition("getPY(REPLACE (REPLACE (name,'���',''),'���','')) like ", "%" + name + "%"); + example.or().andEqualTo("isDelete", Constants.IS_DELETE_FALSE) + .andCondition("getPY(" + getReplaceStr("name") + ") like ", "%" + name + "%"); List<MonitorPoint> monitorPoints = monitorPointMapper.selectByExample(example); return monitorPoints; + } + + private String getReplaceStr(String name){ + List<String[]> list = new ArrayList<String[]>(); + list.add(new String[]{"���",""}); + list.add(new String[]{"���",""}); + for (String[] string : list) { + name = replace(name,string[0],string[1]); + } + return name; + } + + private String replace(String name,String fromStr,String toStr){ + return "REPLACE (" + name + ",'" + fromStr + "','" + toStr + "')"; } /** @@ -188,4 +205,13 @@ example.orderBy("name").asc(); return monitorPointMapper.selectByExample(example); } + @Override + public List<MonitorPoint> getMonitorPointsByRegion(Map<String, Object> parameters) { + Example example = new Example(MonitorPoint.class); + Criteria criteria = example.createCriteria(); + + criteria.andEqualTo("isDelete", Constants.IS_DELETE_FALSE); + criteria.andEqualTo(parameters.get("name").toString(), parameters.get("value")); + return monitorPointMapper.selectByExample(example); + } } -- Gitblit v1.8.0