刷新方案

文件目录：org.jeecg.modules.demo.apimanage.service
image.png

  1. /**
  2.      * 按钮刷新更新时间(用户长时间在同一页面上)
  3.      * @param map
  4.      * @param jsonObject
  5.      * @return
  6.      */
  7.     public ResponseResult selectDeviceAllTimer(Map<String, Object> map, JSONObject jsonObject) {
  8.         List<Map<String, Object>> timeList = null;
  9.         String userId = String.valueOf(jsonObject.get("userId"));
  10.         timeList = nhiotgreenhousedeviceinfoService.selectNhiotDeviceUdateTime(userId);
  11.         map.put("dataTime", timeList);
  12.         return ResponseResult.success(map);
  14.     }

农嗨云存储过程

backup_device_operation_his 该存储过程是把设备操作历史记录的三天前的数据 拷贝到 备份表
check_cloudeye 该存储过程是获取云眼设备的各种数据 整合到一个表里面
这个存储过程可以优化速度 前提是不查询云眼的截图
优化代码如下：

  1. SELECT
  2.     DISTINCT  cloudeye.cloudeye_id,
  3.     cloudeye.online_state,
  4.     cloudeye.update_time,
  5.     equipment.create_time,
  6.     device.user_id
  7. FROM
  8.     nh_iot_cloudeye_live AS cloudeye
  9.     LEFT JOIN nh_iot_device_equipment_code_info AS equipment ON cloudeye.cloudeye_id = equipment.equipment_code 
  10.     LEFT JOIN nh_iot_device AS device ON device.device_id=equipment.equipment_code 
  11. WHERE
  12.     equipment.equipment_type = 6 and equipment.isuse=1 and device.isdel=0 and device.device_type=6     
  13.     and device.isdel=0;


check_greenhouse 该存储过程整合云棚数据新增到表
field_moth_stat 云田一月数据统计
field_week_stat 云田一周数据统计