微信展示数据详情页面

fengxiang

2018-04-25 4f708def438b40d2a55c4bb479eb67acf8076a95

 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;

@@ -8,18 +9,22 @@


import javax.annotation.Resource;



import com.github.pagehelper.PageHelper;

import com.moral.common.bean.Constants;

import com.moral.common.bean.PageBean;

import com.moral.common.util.*;

import com.moral.entity.Device;

import com.moral.mapper.DeviceMapper;

import org.apache.commons.collections.CollectionUtils;

import org.springframework.stereotype.Service;



import com.github.pagehelper.PageHelper;

import com.moral.common.bean.Constants;

import com.moral.common.bean.PageBean;

import com.moral.common.util.ExampleUtil;

import com.moral.common.util.RedisUtils;

import com.moral.common.util.StringUtils;

import com.moral.common.util.ValidateUtil;

import com.moral.entity.Device;

import com.moral.entity.MonitorPoint;

import com.moral.mapper.DeviceMapper;

import com.moral.mapper.MonitorPointMapper;

import com.moral.service.MonitorPointService;



import tk.mybatis.mapper.entity.Example;

import tk.mybatis.mapper.entity.Example.Criteria;



@@ -39,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());

@@ -149,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(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 + "')";

   }



    /**

@@ -171,4 +192,26 @@
        }).collect(Collectors.toList());

        return list;

    }



    @Override

   public List<MonitorPoint> getMonitorPointsByOrganizationId(Integer orgId) {

      Example example = new Example(MonitorPoint.class);

      Criteria criteria = example.createCriteria();

		
      criteria.andEqualTo("isDelete", Constants.IS_DELETE_FALSE);

      if (Constants.isNotSpecialOrgId(orgId)) {

         criteria.andEqualTo("organizationId", orgId);

      }

      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);

   }

}