Merge remote-tracking branch 'origin/master'
| | |
| | | THIS_YEAR_MONTH("THIS_YEAR_MONTH", "当年月份"), |
| | | LAST_YEAR("LAST_YEAR", "去年"), |
| | | THIS_YEAR("THIS_YEAR_MONTH", "今年"), |
| | | LAST_HOUR_24("LAST_HOUR_24", "最近24小时"), |
| | | CUSTOM("CUSTOM", "自定义"); |
| | | |
| | | private String code; |
| | |
| | | whereSql.append(indItem.getTimeLabel()); |
| | | whereSql.append("' < '"); |
| | | whereSql.append(DateUtils.format(calendar.getTime(), PATTERN_MON)); |
| | | whereSql.append("' AND '"); |
| | | whereSql.append("' AND "); |
| | | whereSql.append(indItem.getTimeLabel()); |
| | | whereSql.append(" >= '"); |
| | | calendar.add(Calendar.MONTH, -1); |
| | |
| | | whereSql.append(indItem.getTimeLabel()); |
| | | whereSql.append(" <= '"); |
| | | whereSql.append(DateUtils.format(calendar.getTime(), PATTERN_MON)); |
| | | whereSql.append("' AND '"); |
| | | whereSql.append("' AND "); |
| | | whereSql.append(indItem.getTimeLabel()); |
| | | whereSql.append("' >= '"); |
| | | calendar.add(Calendar.MONTH, -12); |
| | |
| | | whereSql.append(DateUtils.format(calendar.getTime(), PATTERN_YEAR)); |
| | | whereSql.append("'"); |
| | | break; |
| | | case LAST_HOUR_24: |
| | | whereSql.append(indItem.getTimeLabel()); |
| | | whereSql.append(" <= '"); |
| | | whereSql.append(DateUtils.format(calendar.getTime(), DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND)); |
| | | whereSql.append("' AND "); |
| | | whereSql.append(indItem.getTimeLabel()); |
| | | whereSql.append(" >= '"); |
| | | calendar.add(Calendar.HOUR_OF_DAY, -24); |
| | | whereSql.append(DateUtils.format(calendar.getTime(), DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND)); |
| | | whereSql.append("'"); |
| | | break; |
| | | case CUSTOM: |
| | | whereSql.append(indItem.getTimeLabel()); |
| | | whereSql.append(" <= '"); |
| | |
| | | |
| | | |
| | | -- t_st_schedule_record 创建复合索引 |
| | | CREATE INDEX idx_scheme_id_create_time ON t_st_schedule_record (scheme_id, create_time DESC); |
| | | CREATE INDEX idx_st_schedule_record_scheme_result_time ON t_st_schedule_record (scheme_id, result_code, schedule_time DESC, create_time DESC); |
| | |
| | | return true; |
| | | } |
| | | |
| | | /** |
| | | * 计算功率因数 p²/(根号:p²+Q²) |
| | | **/ |
| | | public Double calculateCos(Double PValue,Double QValue) { |
| | | // 绝对值 |
| | | PValue = Math.abs(PValue); |
| | | QValue = Math.abs(QValue); |
| | | //PValue [0,0.001] 直接判断为关闭返回0 |
| | | if (PValue >= 0 && PValue <= 0.001) { |
| | | return 0.0; |
| | | }else { |
| | | BigDecimal result = new BigDecimal(PValue).divide(BigDecimal.valueOf(Math.sqrt(Math.pow(PValue, 2) + Math.pow(QValue, 2))), 2, BigDecimal.ROUND_HALF_UP); |
| | | return result.doubleValue(); |
| | | } |
| | | } |
| | | |
| | | private Date[] calResultTime(ItemVO predictItem, Date startTimeReq, Date endTimeReq, int lengthLeft, int lengthRight) { |
| | | Date[] result = new Date[3]; |
| | | Date predictTime = predictItem.getLastTime(); |
| | |
| | | } |
| | | //返回结果是否存在 |
| | | if (result.get(stScheduleModelOutDTO.getResultKey()) == null) { |
| | | log.error(result.get(stScheduleModelOutDTO.getResultKey()) + "resultKey匹配失败"); |
| | | log.error(stScheduleModelOutDTO.getResultKey() + "resultKey匹配失败"); |
| | | continue; |
| | | } |
| | | Object resultValue = result.get(stScheduleModelOutDTO.getResultKey()); |
| | |
| | | break; |
| | | case IND: |
| | | case IND_ASCII: |
| | | dateTime = calculateTime(originalTime, true, columnItem.getDataLength(), columnItem.getGranularity()); |
| | | dateTime = calculateTime(originalTime, true, columnItem.getDataLength() - 1, columnItem.getGranularity()); |
| | | break; |
| | | case NORMALITEM: |
| | | case MERGEITEM: |
| | |
| | | switch (ModelParamType.getEumByCode(columnItem.getParamType())) { |
| | | case DATAPOINT: |
| | | case PLAN: |
| | | dateTime = calculateTime(originalTime, true, 1, columnItem.getGranularity()); |
| | | break; |
| | | case IND: |
| | | case IND_ASCII: |
| | | dateTime = calculateTime(originalTime, true, 1, columnItem.getGranularity()); |
| | | dateTime = originalTime; |
| | | break; |
| | | case NORMALITEM: |
| | | case MERGEITEM: |