package com.hxzk.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.github.pagehelper.PageHelper;
|
import com.github.pagehelper.PageInfo;
|
import com.hxzk.mapper.KaoQinDao;
|
import com.hxzk.pojo.TbAchor;
|
import com.hxzk.pojo.TbKaoqing;
|
import com.hxzk.pojo.TbTag;
|
import com.hxzk.service.KaoQinService;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import java.text.ParseException;
|
import java.text.SimpleDateFormat;
|
import java.time.LocalDate;
|
import java.time.format.DateTimeFormatter;
|
import java.time.temporal.ChronoUnit;
|
import java.util.Date;
|
import java.util.List;
|
|
@Service
|
public class KaoQinServiceImpl extends ServiceImpl<KaoQinDao, TbKaoqing> implements KaoQinService {
|
|
@Autowired
|
KaoQinDao kaoQinDao;
|
|
@Override
|
public PageInfo<TbKaoqing> findAll(Integer page, Integer limit) {
|
QueryWrapper queryWrapper = new QueryWrapper<>();
|
PageHelper.startPage(page, limit);
|
LocalDate currentDate = LocalDate.now();
|
DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyyMMdd");
|
String formattedDate = currentDate.format(formatter);
|
List<TbKaoqing> cardList = kaoQinDao.findAllKaoQin(formattedDate);
|
PageInfo<TbKaoqing> info = new PageInfo<>(cardList);
|
return info;
|
}
|
|
@Override
|
public PageInfo<TbKaoqing> findSearch(Integer page, Integer limit, TbKaoqing achor) {
|
PageHelper.startPage(page, limit);
|
List<TbKaoqing> cardList = null;
|
String dateStr = achor.getName();
|
String dateStr1 = achor.getBumen();
|
SimpleDateFormat inputFormat = new SimpleDateFormat("yyyy-MM-dd");
|
SimpleDateFormat outputFormat = new SimpleDateFormat("yyyyMMdd");
|
try {
|
Date date = inputFormat.parse(dateStr);
|
Date date1 = inputFormat.parse(dateStr1);
|
String outputDateStr = outputFormat.format(date);
|
String outputDateStr1 = outputFormat.format(date1);
|
achor.setName(outputDateStr);
|
achor.setBumen(outputDateStr1);
|
achor.setIntime(dateStr);
|
achor.setOuttime(dateStr1);
|
} catch (ParseException e) {
|
e.printStackTrace();
|
}
|
if (achor.getTagid() == null || achor.getTagid().equals("")) {
|
String s = achor.getIntime().split(" ")[0];
|
String e = achor.getOuttime().split(" ")[0];
|
String[] start = s.split("-");
|
String[] end = e.split("-");
|
String sql = new String();
|
//只根据时间查询
|
LocalDate startDate = LocalDate.of(Integer.parseInt(start[0]), Integer.parseInt(start[1]), Integer.parseInt(start[2]));
|
LocalDate endDate = LocalDate.of(Integer.parseInt(end[0]), Integer.parseInt(end[1]), Integer.parseInt(end[2]));
|
long numOfDaysBetween = ChronoUnit.DAYS.between(startDate, endDate);
|
// 计算两个日期之间的天数
|
for (int i = 1; i <= numOfDaysBetween; i++) {
|
LocalDate date = startDate.plusDays(i);
|
String riqi = date.toString().split("-")[0]+date.toString().split("-")[1]+date.toString().split("-")[2];
|
sql += " UNION select * from tb_kaoqing_" + riqi+" ";
|
achor.setBumen(sql);}
|
cardList = kaoQinDao.findSearchTime(achor);
|
} else {
|
if (achor.getName() == null || achor.getName().equals("")) {
|
LocalDate currentDate = LocalDate.now();
|
DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyyMMdd");
|
String formattedDate = currentDate.format(formatter);
|
achor.setName(formattedDate);
|
cardList = kaoQinDao.findSearch(achor);
|
} else {
|
cardList = kaoQinDao.findSearch(achor);
|
}
|
//根据时间和输入的姓名进行查询
|
|
}
|
PageInfo<TbKaoqing> info = new PageInfo<>(cardList);
|
return info;
|
}
|
}
|
