| | |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Component; |
| | | |
| | | import java.util.ArrayList; |
| | | import java.util.Date; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | import com.alibaba.fastjson.JSON; |
| | | import com.moral.api.entity.HistoryDaily; |
| | | import com.moral.api.service.HistoryDailyService; |
| | | import com.moral.api.service.HistoryFiveMinutelyService; |
| | | import com.moral.api.service.HistoryHourlyService; |
| | | import com.moral.api.service.HistoryMonthlyService; |
| | | import com.moral.api.service.HistoryWeeklyService; |
| | | import com.xxl.job.core.biz.model.ReturnT; |
| | | import com.xxl.job.core.context.XxlJobHelper; |
| | | import com.xxl.job.core.handler.annotation.XxlJob; |
| | | |
| | | import javax.xml.crypto.Data; |
| | | import java.util.Date; |
| | | |
| | | @Component |
| | | public class HistoryTableInsertTask { |
| | | |
| | | @Autowired |
| | | private HistoryFiveMinutelyService historyFiveMinutelyService; |
| | | |
| | | @Autowired |
| | | private HistoryHourlyService historyHourlyService; |
| | | |
| | | @Autowired |
| | | private HistoryDailyService historyDailyService; |
| | | |
| | | @Autowired |
| | | private HistoryFiveMinutelyService historyFiveMinutelyService; |
| | | private HistoryWeeklyService historyWeeklyService; |
| | | |
| | | @Autowired |
| | | private HistoryMonthlyService historyMonthlyService; |
| | | |
| | | //5分钟数据统计 |
| | | @XxlJob("insertHistoryFiveMinutely") |
| | | public ReturnT insertHistoryFiveMinutely() { |
| | | try { |
| | | /* List<Map<String, Object>> list = new ArrayList<>(); |
| | | Map<String, Object> map = new HashMap<>(); |
| | | map.put("mac", "123456"); |
| | | Date date = new Date(); |
| | | map.put("time", date); |
| | | Map<String, Object> value = new HashMap<>(); |
| | | value.put("e1", 10); value.put("e2", 20); |
| | | map.put("value", JSON.toJSONString(value)); |
| | | list.add(map); |
| | | String timeUnits = DateUtils.dateToDateString(date, DateUtils.yyyyMM_EN);*/ |
| | | |
| | | historyFiveMinutelyService.insertHistoryFiveMinutely(); |
| | | } catch (Exception e) { |
| | | XxlJobHelper.log(e.getMessage()); |
| | | return ReturnT.FAIL; |
| | | return new ReturnT(ReturnT.FAIL_CODE, e.getMessage()); |
| | | } |
| | | return ReturnT.SUCCESS; |
| | | } |
| | |
| | | @XxlJob("insertHistoryDaily") |
| | | public ReturnT insertHistoryDaily() { |
| | | try { |
| | | List<HistoryDaily> list = new ArrayList<>(); |
| | | HistoryDaily historyDaily = new HistoryDaily(); |
| | | historyDaily.setMac("123456"); |
| | | historyDaily.setTime(new Date()); |
| | | Map<String, Object> value = new HashMap<>(); |
| | | value.put("e1", 1); |
| | | value.put("e2", 2); |
| | | historyDaily.setValue(JSON.toJSONString(value)); |
| | | for (int i = 0; i < 20000; i++) { |
| | | list.add(historyDaily); |
| | | } |
| | | historyDailyService.insertHistoryDaily(list); |
| | | Date now = new Date(); |
| | | historyDailyService.insertHistoryDaily(null); |
| | | } catch (Exception e) { |
| | | XxlJobHelper.log(e.getMessage()); |
| | | return ReturnT.FAIL; |
| | | } |
| | | return ReturnT.SUCCESS; |
| | | } |
| | | |
| | | //周数据统计 |
| | | @XxlJob("insertHistoryWeekly") |
| | | public ReturnT insertHistoryWeekly() { |
| | | try { |
| | | historyWeeklyService.insertHistoryWeekly(); |
| | | } catch (Exception e) { |
| | | XxlJobHelper.log(e.getMessage()); |
| | | return new ReturnT(ReturnT.FAIL_CODE, e.getMessage()); |
| | | } |
| | | return ReturnT.SUCCESS; |
| | | } |
| | | |
| | | //月数据统计 |
| | | @XxlJob("insertHistoryMonthly") |
| | | public ReturnT insertHistoryMonthly() { |
| | | try { |
| | | historyMonthlyService.insertHistoryMonthly(); |
| | | } catch (Exception e) { |
| | | XxlJobHelper.log(e.getMessage()); |
| | | return new ReturnT(ReturnT.FAIL_CODE, e.getMessage()); |
| | | } |
| | | return ReturnT.SUCCESS; |
| | | } |
| | | |
| | | //缺失小时数据补充 |
| | | @XxlJob("historyHourlySupplement") |
| | | public ReturnT historyHourlySupplement() { |
| | | try { |
| | | historyHourlyService.insertHistoryHourly(); |
| | | } catch (Exception e) { |
| | | XxlJobHelper.log(e.getMessage()); |
| | | return new ReturnT(ReturnT.FAIL_CODE, e.getMessage()); |
| | | } |
| | | return ReturnT.SUCCESS; |
| | | } |
| | | |
| | | //设备小时数据,最大值,最小值,均值统计任务 |
| | | @XxlJob("insertHistoryHourlyComplete") |
| | | public ReturnT insertHistoryHourlyComplete(){ |
| | | try { |
| | | historyHourlyService.insertHistoryHourlyComplete(); |
| | | } catch (Exception e) { |
| | | e.printStackTrace(); |
| | | return new ReturnT(ReturnT.FAIL_CODE, e.getMessage()); |
| | | } |
| | | return ReturnT.SUCCESS; |
| | | } |
| | | |
| | | @XxlJob("dateToChangShu") |
| | | public ReturnT dateToChangShu(){ |
| | | try { |
| | | historyHourlyService.dateToChangShu(null); |
| | | } catch (Exception e) { |
| | | e.printStackTrace(); |
| | | return new ReturnT(ReturnT.FAIL_CODE, e.getMessage()); |
| | | } |
| | | return ReturnT.SUCCESS; |
| | | } |
| | | } |