blame | history | patch | commit | commitdiff | show whitespace
kaiyu
2021-09-08 f183af46a77eb7049a15e379eece4adbb59a9738 
 screen-api/src/main/java/com/moral/api/service/impl/HistorySecondUavServiceImpl.java


@@ -1,10 +1,17 @@


package com.moral.api.service.impl;




import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;


import com.moral.api.entity.HistorySecondUav;


import com.moral.api.mapper.HistorySecondUavMapper;


import com.moral.api.service.HistorySecondUavService;


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.util.ArrayList;


import java.util.Date;


import java.util.List;




/**


 * <p>


@@ -17,4 +24,27 @@


@Service


public class HistorySecondUavServiceImpl extends ServiceImpl<HistorySecondUavMapper, HistorySecondUav> implements HistorySecondUavService {




    @Autowired


    HistorySecondUavMapper historySecondUavMapper;




    @Override


    public List<Date> queryDate(Integer organizationId) {


        //构造查询条件


        QueryWrapper<HistorySecondUav> queryWrapper = new QueryWrapper<>();


        queryWrapper.eq("organization_id",organizationId);


        //设置查询时间范围为180天


        Date endDate = new Date();


        Date startDate = DateUtils.addDays(endDate, -180);


        queryWrapper.between("batch",startDate,endDate);


        //设置查询字段


        queryWrapper.select("DISTINCT batch");


        //查询结果


        List<HistorySecondUav> historySecondUavs = historySecondUavMapper.selectList(queryWrapper);


        //结果转为Date集合


        List<Date> result = new ArrayList<>();


        for (HistorySecondUav historySecondUav : historySecondUavs) {


            result.add(historySecondUav.getBatch());


        }


        return result;


    }


}