From 21a44d6cb9a372bce5c7418d2a82c88bb0485e60 Mon Sep 17 00:00:00 2001 From: kaiyu <404897439@qq.com> Date: Mon, 17 Jan 2022 14:44:56 +0800 Subject: [PATCH] screen-api 完成城市空气质量同期对比接口 --- screen-api/src/main/java/com/moral/api/service/impl/CityAqiMonthlyServiceImpl.java | 15 +++++++++++++++ 1 files changed, 15 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 e72937b..e0be3d1 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 @@ -1,10 +1,15 @@ package com.moral.api.service.impl; +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.moral.api.entity.CityAqiMonthly; import com.moral.api.mapper.CityAqiMonthlyMapper; import com.moral.api.service.CityAqiMonthlyService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; + +import java.util.Date; +import java.util.List; /** * <p> @@ -17,4 +22,14 @@ @Service public class CityAqiMonthlyServiceImpl extends ServiceImpl<CityAqiMonthlyMapper, CityAqiMonthly> implements CityAqiMonthlyService { + @Autowired + CityAqiMonthlyMapper cityAqiMonthlyMapper; + + @Override + public List<CityAqiMonthly> getCityAqiMonthByRegionCodeAndTime(Integer regionCode, Date startDate, Date endDate) { + QueryWrapper<CityAqiMonthly> queryWrapper = new QueryWrapper<>(); + queryWrapper.eq("city_code",regionCode); + queryWrapper.between("time",startDate,endDate); + return cityAqiMonthlyMapper.selectList(queryWrapper); + } } -- Gitblit v1.8.0