From b19ec338f5cbdd93e9f77579ee96d6c6037acdfe Mon Sep 17 00:00:00 2001 From: jinpengyong <jpy123456> Date: Wed, 09 Feb 2022 15:26:32 +0800 Subject: [PATCH] 督办单列表加入区域名字 --- screen-api/src/main/java/com/moral/api/service/impl/CityAqiYearlyServiceImpl.java | 15 +++++++++++++++ 1 files changed, 15 insertions(+), 0 deletions(-) diff --git a/screen-api/src/main/java/com/moral/api/service/impl/CityAqiYearlyServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/CityAqiYearlyServiceImpl.java index 10bd866..10b54c3 100644 --- a/screen-api/src/main/java/com/moral/api/service/impl/CityAqiYearlyServiceImpl.java +++ b/screen-api/src/main/java/com/moral/api/service/impl/CityAqiYearlyServiceImpl.java @@ -1,10 +1,15 @@ package com.moral.api.service.impl; +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.moral.api.entity.CityAqiYearly; import com.moral.api.mapper.CityAqiYearlyMapper; import com.moral.api.service.CityAqiYearlyService; 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 CityAqiYearlyServiceImpl extends ServiceImpl<CityAqiYearlyMapper, CityAqiYearly> implements CityAqiYearlyService { + @Autowired + CityAqiYearlyMapper cityAqiYearlyMapper; + + @Override + public List<CityAqiYearly> getCityAqiYearlyByRegionCodeAndTime(Integer regionCode, Date startDate, Date endDate) { + QueryWrapper<CityAqiYearly> queryWrapper = new QueryWrapper<>(); + queryWrapper.eq("city_code",regionCode); + queryWrapper.between("time",startDate,endDate); + return cityAqiYearlyMapper.selectList(queryWrapper); + } } -- Gitblit v1.8.0