获取优良天数

xufenglei

2018-08-31 9437c74510c25be9d2413821c65fcf6ca4e6d21a

 src/main/java/com/moral/service/impl/DeviceServiceImpl.java

@@ -4,18 +4,22 @@
import java.util.stream.Collectors;



import javax.annotation.Resource;

import javax.validation.constraints.NotNull;



import com.alibaba.fastjson.TypeReference;

import com.github.pagehelper.Page;

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 com.moral.entity.DeviceVersion;

import com.moral.mapper.*;

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;

@@ -23,14 +27,28 @@
import com.github.pagehelper.PageHelper;

import com.moral.common.util.ValidateUtil;

import com.moral.entity.Device;

import com.moral.mapper.DeviceMapper;

import com.moral.service.AccountService;

import com.moral.service.DeviceService;

import tk.mybatis.mapper.entity.Example;



@Service

public class DeviceServiceImpl implements DeviceService {



   private static 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

@@ -38,8 +56,16 @@
   @Resource

   private AccountService accountService;

    private Class ENTITY_CLASS = Device.class;

    @Resource

   OrganizationMapper orgMapper;

    @Resource

   DeviceVersionMapper deviceVersionMapper;

   @Resource

   RedisUtils redisUtils;

   @Resource

   OrganizationMapper organizationMapper;

   @Resource

   DictionaryDataMapper dictionaryDataMapper;

   @Override

   public Map<String, Object> getDeviceStatesByAccount(Map<String, Object> parameters) {

      ValidateUtil.notNull(parameters.get("accountId"), "param.is.null");

@@ -87,6 +113,8 @@
         device.setId(queryDevice.getId());

         deviceMapper.updateByPrimaryKeySelective(device);

      }

      //刷新redis里的信息

      refreshDeviceInRedis(device.getMac());

   }



   @Override

@@ -94,47 +122,123 @@
      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());// 组织数组

      simpleDevice.setDeviceVersion(device.getDeviceVersion());

      redisUtils.set(key,simpleDevice);

   }

   private Device getDeviceFromRedis(String mac) {

      String key = getDeviceKey(mac);

      return redisUtils.get(key,Device.class);

   }



   /**

    *

    * @param map

    * @param params

    * map里 包括 组织id和4个坐标点

    * @return

    * @return 返回未删除结果集

    */

   @Override

   public List<Device> query(Map<String, Object> map) {

      List <Device> list = deviceMapper.selectByMap(map);

      loadDeviceState(list);

      return list;

   public List<Device> query(Map<String, Object> params) {

      Object orgIdObj = params.get("orgId");

      List<Device> deviceList = null;

      if(orgIdObj != null) {

         Integer orgId = Integer.parseInt(orgIdObj.toString());

         List<Integer> orgIds = orgMapper.selectLowerOrgIds(orgId);

         params.put("orgIds", orgIds);

         deviceList = deviceMapper.selectByMap(params);

         loadDeviceState(deviceList);

      }

      return deviceList;

   }



   /**

    *  根据组织id和设备名称 分页查询设备

    * @param orgId

    * @param deviceName

    * @param pageSize

    * @param pageNo

    * @return

    * @return 返回未删除结果

    */

   @Override

   public PageResult query(Integer orgId, String deviceName, Integer pageSize, Integer pageNo) {

      List<Integer> orgIds = orgMapper.selectLowerOrgIds(orgId);

      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,orgIds,state,deviceName);

      //从redis里取状态

      loadDeviceState(list);

      if(list instanceof Page){

@@ -149,14 +253,15 @@
    * @param mpId

    * @param pageSize

    * @param pageNo

    * @return

    * @return 返回未删除结果

    */

   @Override

   public PageResult query(Integer orgId, Integer mpId, Integer pageSize, Integer pageNo) {

      List<Integer> orgIds = orgMapper.selectLowerOrgIds(orgId);

      if(!ObjectUtils.isEmpty(pageSize)&&!ObjectUtils.isEmpty(pageNo)){

         PageHelper.startPage(pageNo,pageSize);

      }

      List<Device> list = deviceMapper.selectByOrgIdAndMpId(orgId,mpId);

      List<Device> list = deviceMapper.selectByOrgIdAndMpId(orgId,orgIds,mpId);

      //从redis里取状态

      loadDeviceState(list);

      if(list instanceof Page){

@@ -204,27 +309,33 @@
      }

      return device;

   }

   /*

     刷新 redis 设备的信息



   /**

    * 要在数据库更改后刷新

    * 刷新 redis 设备的信息

    * @param mac

    */

   private void refreshDeviceInRedis(Device device){

        if(!StringUtils.isBlank(device.getMac())){

             Device simpleDevice = new Device();

             simpleDevice.setId(device.getId());

             simpleDevice.setDeviceVersion(device.getDeviceVersion());

             simpleDevice.setMac(device.getMac());

             simpleDevice.setMonitorPointId(device.getMonitorPointId());

             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 device = deviceMapper.selectWithOrgIdsByMac(mac);

          setDeviceToRedis(mac,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){

@@ -233,11 +344,16 @@
      }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());

      }

      List<Device> organizationList = deviceMapper.selectWithRelationData(example);

      return new PageBean(organizationList);

      List<Device> deviceList = deviceMapper.selectWithRelationData(example);

      return new PageBean(deviceList);

   }



   @Override

@@ -245,39 +361,69 @@
      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()]));

      }

   }



   @Override

   @Transactional

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

            device.setIsDelete(Constants.IS_DELETE_FALSE);

            deviceMapper.insertSelective(device);

         }else{

         if(device.getId()!=null){

            deviceMapper.updateByPrimaryKeySelective(device);

            //刷新redis里设备信息

            refreshDeviceInRedis(device);

         }else{

            Device deviceQuery = new Device();

            deviceQuery.setMac(device.getMac());

            Device deviceResult = deviceMapper.selectOne(deviceQuery);

            if(deviceResult !=null){

               device.setId(deviceResult.getId());

               deviceMapper.updateByPrimaryKeySelective(device);

            }else {

               device.setState(Constants.DEVICE_STATE_OFFLINE);

               device.setIsDelete(Constants.IS_DELETE_FALSE);

               deviceMapper.insertSelective(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();

@@ -318,4 +464,51 @@
      }).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);

   }



   @Override

   public List<Device> getDevicesByOrganizationId(Map<String, Object> parameters) {

      ValidateUtil.notNull(parameters.get("organizationId"), "param.is.null");

      return deviceMapper.getDevicesByOrganizationId(parameters);

   }

   @Override

    public Map<String,Long> queryDeviceStateSummary(@NotNull Integer orgId){

       Map<String,Object> params = new HashMap<>();

       if(!dictionaryDataMapper.isSupperOrgId(orgId)){

         List<Integer> orgIds = organizationMapper.selectLowerOrgIds(orgId);

         params.put("orgIds",orgIds);

      }

      List<Map<String, Object>> list = deviceMapper.getDeviceStatesByAccount(params);

      Long all = 0L, normal = 0L, abnormal = 0L, stop = 0L;

      for (Map<String, Object> map : list) {

         Long count = (Long) map.get("count");

         all += count;

         switch (Integer.valueOf((String) map.get("state"))) {

            case 0:

               normal = count;

               break;

            case 4:

               stop = count;

               break;

            default:

               abnormal += count;

         }

      }

      Map<String,Long> result = new HashMap<>();

      result.put("all", all);

      result.put("normal", normal);

      result.put("abnormal", abnormal);

      result.put("stop", stop);

      return result;

   }

}