package com.moral.api.service.impl;
|
|
import com.alibaba.excel.util.StringUtils;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.moral.api.entity.SysTest;
|
import com.moral.api.mapper.SysTestMapper;
|
import com.moral.api.service.SysTestService;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.moral.api.utils.AqiUtils;
|
import com.moral.util.DateUtils;
|
import org.springframework.stereotype.Service;
|
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* <p>
|
* 服务实现类
|
* </p>
|
*
|
* @author moral
|
* @since 2023-08-01
|
*/
|
@Service
|
public class SysTestServiceImpl extends ServiceImpl<SysTestMapper, SysTest> implements SysTestService {
|
|
@Override
|
public List<SysTest> listAll(String startTime,String endTime, String mac) {
|
QueryWrapper<SysTest> queryWrapper = new QueryWrapper<>();
|
// queryWrapper.between(!StringUtils.isEmpty(startTime)&&!StringUtils.isEmpty(endTime),"time",startTime,endTime);
|
queryWrapper.eq(!StringUtils.isEmpty(startTime),"time", DateUtils.convertDate(startTime));
|
queryWrapper.eq(!StringUtils.isEmpty(mac),"mac",mac);
|
queryWrapper.orderByAsc("time","mac");
|
List<SysTest> listAll = this.baseMapper.selectList(queryWrapper);
|
for(SysTest s : listAll){
|
Map<String,Object> map = new HashMap<>();
|
map.put("PM2_5",s.getPm25());
|
map.put("PM10",s.getPm10());
|
map.put("CO",s.getCo());
|
map.put("SO2",s.getSo2());
|
map.put("NO2",s.getNo2());
|
map.put("O3",s.getO3());
|
Map<String,Object> getAqi = AqiUtils.getAqi(map);
|
s.setSu(getAqi.get("SU").toString());
|
s.setAqi(getAqi.get("AQI").toString());
|
}
|
return listAll;
|
}
|
}
|
