合并sql

ZhuDongming

2019-08-19 f1374915909bb5bddb8d3a7fad84b3955fd69778

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

@@ -3,14 +3,10 @@
import static com.moral.common.bean.Constants.NULL_VALUE;

import static org.springframework.util.ObjectUtils.isEmpty;



import java.io.FileNotFoundException;

import java.io.IOException;

import java.math.BigDecimal;

import java.text.ParseException;

import java.text.SimpleDateFormat;

import java.time.LocalDate;

import java.time.LocalDateTime;

import java.time.format.DateTimeFormatter;

import java.time.temporal.TemporalAdjusters;

import java.util.ArrayList;

import java.util.Arrays;

@@ -41,13 +37,11 @@
import org.springframework.util.ObjectUtils;



import com.alibaba.fastjson.JSON;

import com.alibaba.fastjson.JSONObject;

import com.alibaba.fastjson.TypeReference;

import com.moral.common.util.CalculateUtils;

import com.moral.common.util.ParameterUtils;

import com.moral.common.util.ReportTimeFormat;

import com.moral.common.util.ResourceUtil;

import com.moral.common.util.StringUtils;

import com.moral.common.util.ValidateUtil;

import com.moral.entity.Sensor;

import com.moral.entity.charts.DataCondition;

@@ -59,9 +53,6 @@
import com.moral.mapper.HistoryMinutelyMapper;

import com.moral.mapper.SensorMapper;

import com.moral.service.HistoryMinutelyService;

import com.moral.service.SensorService;



import lombok.val;



@Service

@SuppressWarnings({"unchecked", "unused", "rawtypes"})

@@ -546,23 +537,23 @@
     */

    @Override

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

        String startTime=parameters.get("startTime").toString();

        Boolean flag=null;

        String startTime = parameters.get("startTime").toString();

        Boolean flag = null;

        try {

            flag = DateUtils.isSameDay(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(startTime), new Date());

        }catch (ParseException e) {

        } catch (ParseException e) {

            e.printStackTrace();

        }

        List<Sensor> sensors=sensorMapper.getSensorsByMac(parameters);

        List<String> sensorKeys=new ArrayList<>();

        for(Sensor sensor:sensors){

        List<Sensor> sensors = sensorMapper.getSensorsByMac(parameters);

        List<String> sensorKeys = new ArrayList<>();

        for (Sensor sensor : sensors) {

            sensorKeys.add(sensor.getSensorKey());

        }

        parameters.put("sensorKeys", sensorKeys);

        List<Map<String, Object>> listMap=null;

        if(flag){

        List<Map<String, Object>> listMap = null;

        if (flag) {

            listMap = historyMapper.getSensorDataToday(parameters);

        }else{

        } else {

            listMap = historyMinutelyMapper.getSensorData(parameters);

        }

        List<Map<String, Object>> listMapNew = new ArrayList<>();

@@ -573,11 +564,7 @@
                for (String key : map.keySet()) {

                    for (Sensor sensor : sensors) {

                        if (sensor.getSensorKey().equals(key)) {

                            if("e79".equals(key)||"e80".equals(key)||"e81".equals(key)){

                                new_map.put(sensor.getDescription(), StringUtils.scientificCountingConversion(map.get(key).toString())+sensor.getUnit());

                            }else{

                                new_map.put(sensor.getDescription(), map.get(key)+sensor.getUnit());

                            }

                            new_map.put(sensor.getDescription(), new BigDecimal(map.get(key).toString()).stripTrailingZeros().toPlainString() + sensor.getUnit());

                        }

                    }

                }

@@ -590,24 +577,24 @@


    @Override

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

        String startTime=parameters.get("startTime").toString();

        Boolean flag=null;

        String startTime = parameters.get("startTime").toString();

        Boolean flag = null;

        try {

            flag = DateUtils.isSameDay(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(startTime), new Date());

        }catch (ParseException e) {

        } catch (ParseException e) {

            e.printStackTrace();

        }

        List<Sensor> sensors=sensorMapper.getSensorsByMac(parameters);

        List<String> sensorKeys=new ArrayList<>();

        for(Sensor sensor:sensors){

        List<Sensor> sensors = sensorMapper.getSensorsByMac(parameters);

        List<String> sensorKeys = new ArrayList<>();

        for (Sensor sensor : sensors) {

            sensorKeys.add(sensor.getSensorKey());

        }

        parameters.put("sensorKeys", sensorKeys);

        List<Map<String, Object>> listMap=null;

        if(flag){

            listMap = historyMapper.getSensorDataTodayMin(parameters);

        }else{

            listMap = historyMinutelyMapper.getSensorDataMin(parameters);

        List<Map<String, Object>> listMap = null;

        if (flag) {

            listMap = historyMapper.getSensorDataToday(parameters);

        } else {

            listMap = historyMinutelyMapper.getSensorData(parameters);

        }

        List<Map<String, Object>> listMapNew = new ArrayList<>();

        Map<String, Object> new_map = new LinkedHashMap<>();

@@ -616,12 +603,8 @@
                new_map.put("时间", map.get("time"));

                for (String key : map.keySet()) {

                    for (Sensor sensor : sensors) {

                        if (sensor.getSensorKey().equals(key)) {

                            if("e79".equals(key)||"e80".equals(key)||"e81".equals(key)){

                                new_map.put(sensor.getDescription(), StringUtils.scientificCountingConversion(map.get(key).toString().replace("\"", "")));

                            }else{

                                new_map.put(sensor.getDescription(), map.get(key).toString().replace("\"", ""));

                            }

                        if (("min" + sensor.getSensorKey()).equals(key)) {

                            new_map.put(sensor.getDescription(), new BigDecimal(map.get(key).toString().replace("\"", "")).stripTrailingZeros().toPlainString());

                        }

                    }

                }

@@ -634,24 +617,24 @@


    @Override

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

        String startTime=parameters.get("startTime").toString();

        Boolean flag=null;

        String startTime = parameters.get("startTime").toString();

        Boolean flag = null;

        try {

            flag = DateUtils.isSameDay(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(startTime), new Date());

        }catch (ParseException e) {

        } catch (ParseException e) {

            e.printStackTrace();

        }

        List<Sensor> sensors=sensorMapper.getSensorsByMac(parameters);

        List<String> sensorKeys=new ArrayList<>();

        for(Sensor sensor:sensors){

        List<Sensor> sensors = sensorMapper.getSensorsByMac(parameters);

        List<String> sensorKeys = new ArrayList<>();

        for (Sensor sensor : sensors) {

            sensorKeys.add(sensor.getSensorKey());

        }

        parameters.put("sensorKeys", sensorKeys);

        List<Map<String, Object>> listMap=null;

        if(flag){

            listMap = historyMapper.getSensorDataTodayMax(parameters);

        }else{

            listMap = historyMinutelyMapper.getSensorDataMax(parameters);

        List<Map<String, Object>> listMap = null;

        if (flag) {

            listMap = historyMapper.getSensorDataToday(parameters);

        } else {

            listMap = historyMinutelyMapper.getSensorData(parameters);

        }

        List<Map<String, Object>> listMapNew = new ArrayList<>();

        Map<String, Object> new_map = new LinkedHashMap<>();

@@ -660,12 +643,8 @@
                new_map.put("时间", map.get("time"));

                for (String key : map.keySet()) {

                    for (Sensor sensor : sensors) {

                        if (sensor.getSensorKey().equals(key)) {

                            if("e79".equals(key)||"e80".equals(key)||"e81".equals(key)){

                                new_map.put(sensor.getDescription(), StringUtils.scientificCountingConversion(map.get(key).toString().replace("\"", "")));

                            }else{

                                new_map.put(sensor.getDescription(), map.get(key).toString().replace("\"", ""));

                            }

                        if (("max" + sensor.getSensorKey()).equals(key)) {

                            new_map.put(sensor.getDescription(), new BigDecimal(map.get(key).toString().replace("\"", "")).stripTrailingZeros().toPlainString());

                        }

                    }

                }