From b2f2adab687a8d5d49fcc479f4857ec303e4b9f0 Mon Sep 17 00:00:00 2001
From: kaiyu <404897439@qq.com>
Date: Tue, 15 Mar 2022 10:35:08 +0800
Subject: [PATCH] screen-api 判断优良天非空
---
screen-api/src/main/java/com/moral/api/service/impl/CityAqiMonthlyServiceImpl.java | 13 +++++++++++++
1 files changed, 13 insertions(+), 0 deletions(-)
diff --git a/screen-api/src/main/java/com/moral/api/service/impl/CityAqiMonthlyServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/CityAqiMonthlyServiceImpl.java
index e0be3d1..5806e82 100644
--- a/screen-api/src/main/java/com/moral/api/service/impl/CityAqiMonthlyServiceImpl.java
+++ b/screen-api/src/main/java/com/moral/api/service/impl/CityAqiMonthlyServiceImpl.java
@@ -5,9 +5,12 @@
import com.moral.api.mapper.CityAqiMonthlyMapper;
import com.moral.api.service.CityAqiMonthlyService;
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.io.*;
+import java.util.ArrayList;
import java.util.Date;
import java.util.List;
@@ -32,4 +35,14 @@
queryWrapper.between("time",startDate,endDate);
return cityAqiMonthlyMapper.selectList(queryWrapper);
}
+
+ @Override
+ public CityAqiMonthly getCityAqiMonthByRegionCodeAndTime(Integer regionCode, Date time){
+ time = DateUtils.getFirstDayOfMonth(time);
+ QueryWrapper<CityAqiMonthly> queryWrapper = new QueryWrapper<>();
+ queryWrapper.eq("city_code",regionCode);
+ queryWrapper.eq("time",time);
+ return cityAqiMonthlyMapper.selectOne(queryWrapper);
+ }
+
}
--
Gitblit v1.8.0