| | |
| | | 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; |
| | | |
| | |
| | | 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); |
| | | } |
| | | |
| | | } |