From f183af46a77eb7049a15e379eece4adbb59a9738 Mon Sep 17 00:00:00 2001
From: kaiyu <404897439@qq.com>
Date: Wed, 08 Sep 2021 11:16:33 +0800
Subject: [PATCH] screen-api 增加获取无人机飞行日期接口
---
screen-api/src/main/java/com/moral/api/service/impl/HistorySecondUavServiceImpl.java | 30 ++++++++++++++++++++++++++++++
1 files changed, 30 insertions(+), 0 deletions(-)
diff --git a/screen-api/src/main/java/com/moral/api/service/impl/HistorySecondUavServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/HistorySecondUavServiceImpl.java
index c0da684..81620b9 100644
--- a/screen-api/src/main/java/com/moral/api/service/impl/HistorySecondUavServiceImpl.java
+++ b/screen-api/src/main/java/com/moral/api/service/impl/HistorySecondUavServiceImpl.java
@@ -1,10 +1,17 @@
package com.moral.api.service.impl;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.moral.api.entity.HistorySecondUav;
import com.moral.api.mapper.HistorySecondUavMapper;
import com.moral.api.service.HistorySecondUavService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.moral.util.DateUtils;
+import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
+
+import java.util.ArrayList;
+import java.util.Date;
+import java.util.List;
/**
* <p>
@@ -17,4 +24,27 @@
@Service
public class HistorySecondUavServiceImpl extends ServiceImpl<HistorySecondUavMapper, HistorySecondUav> implements HistorySecondUavService {
+ @Autowired
+ HistorySecondUavMapper historySecondUavMapper;
+
+ @Override
+ public List<Date> queryDate(Integer organizationId) {
+ //������������������
+ QueryWrapper<HistorySecondUav> queryWrapper = new QueryWrapper<>();
+ queryWrapper.eq("organization_id",organizationId);
+ //���������������������������180���
+ Date endDate = new Date();
+ Date startDate = DateUtils.addDays(endDate, -180);
+ queryWrapper.between("batch",startDate,endDate);
+ //������������������
+ queryWrapper.select("DISTINCT batch");
+ //������������
+ List<HistorySecondUav> historySecondUavs = historySecondUavMapper.selectList(queryWrapper);
+ //������������Date������
+ List<Date> result = new ArrayList<>();
+ for (HistorySecondUav historySecondUav : historySecondUavs) {
+ result.add(historySecondUav.getBatch());
+ }
+ return result;
+ }
}
--
Gitblit v1.8.0