package cn.exrick.xboot.social.serviceimpl;
|
|
import cn.exrick.xboot.core.common.vo.SearchVo;
|
import cn.exrick.xboot.social.dao.SocialDao;
|
import cn.exrick.xboot.social.entity.Social;
|
import cn.exrick.xboot.social.service.SocialService;
|
import cn.hutool.core.date.DateUtil;
|
import cn.hutool.core.util.StrUtil;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.data.domain.Page;
|
import org.springframework.data.domain.Pageable;
|
import org.springframework.data.jpa.domain.Specification;
|
import org.springframework.lang.Nullable;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import javax.persistence.criteria.*;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
/**
|
* Github登录接口实现
|
* @author Exrick
|
*/
|
@Slf4j
|
@Service
|
@Transactional
|
public class SocialServiceImpl implements SocialService {
|
|
@Autowired
|
private SocialDao socialDao;
|
|
@Override
|
public SocialDao getRepository() {
|
return socialDao;
|
}
|
|
@Override
|
public Social findByOpenIdAndPlatform(String openId, Integer platform) {
|
|
return socialDao.findByOpenIdAndPlatform(openId, platform);
|
}
|
|
@Override
|
public Social findByRelateUsernameAndPlatform(String relateUsername, Integer platform) {
|
|
return socialDao.findByRelateUsernameAndPlatform(relateUsername, platform);
|
}
|
|
@Override
|
public List<Social> findByRelateUsername(String relateUsername) {
|
|
return socialDao.findByRelateUsername(relateUsername);
|
}
|
|
@Override
|
public Page<Social> findByCondition(Social social, SearchVo searchVo, Pageable pageable) {
|
|
return socialDao.findAll(new Specification<Social>() {
|
@Nullable
|
@Override
|
public Predicate toPredicate(Root<Social> root, CriteriaQuery<?> cq, CriteriaBuilder cb) {
|
|
Path<String> usernameField = root.get("username");
|
Path<String> relateUsernameField = root.get("relateUsername");
|
Path<Integer> platformField = root.get("platform");
|
Path<Date> createTimeField = root.get("createTime");
|
|
List<Predicate> list = new ArrayList<>();
|
|
if (StrUtil.isNotBlank(social.getUsername())) {
|
list.add(cb.like(usernameField, '%' + social.getUsername() + '%'));
|
}
|
if (StrUtil.isNotBlank(social.getRelateUsername())) {
|
list.add(cb.like(relateUsernameField, '%' + social.getRelateUsername() + '%'));
|
}
|
if (social.getPlatform() != null) {
|
list.add(cb.equal(platformField, social.getPlatform()));
|
}
|
//创建时间
|
if (StrUtil.isNotBlank(searchVo.getStartDate()) && StrUtil.isNotBlank(searchVo.getEndDate())) {
|
Date start = DateUtil.parse(searchVo.getStartDate());
|
Date end = DateUtil.parse(searchVo.getEndDate());
|
list.add(cb.between(createTimeField, start, DateUtil.endOfDay(end)));
|
}
|
|
Predicate[] arr = new Predicate[list.size()];
|
cq.where(list.toArray(arr));
|
return null;
|
}
|
}, pageable);
|
}
|
}
|
