package com.fzzy.api.view.pr;
|
|
import com.bstek.dorado.annotation.DataProvider;
|
import com.bstek.dorado.annotation.DataResolver;
|
import com.bstek.dorado.annotation.Expose;
|
|
import com.bstek.dorado.data.provider.Page;
|
import com.fzzy.api.entity.ApiComData;
|
import com.fzzy.api.utils.ContextUtil;
|
import com.fzzy.api.view.repository.ApiComDataRep;
|
|
import lombok.extern.slf4j.Slf4j;
|
|
import org.apache.commons.lang.StringUtils;
|
import org.springframework.beans.BeanUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.data.domain.PageRequest;
|
import org.springframework.data.domain.Pageable;
|
import org.springframework.data.domain.Sort;
|
import org.springframework.data.jpa.domain.Specification;
|
import org.springframework.stereotype.Component;
|
|
import javax.persistence.criteria.CriteriaBuilder;
|
import javax.persistence.criteria.CriteriaQuery;
|
import javax.persistence.criteria.Predicate;
|
import javax.persistence.criteria.Root;
|
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @Desc: 通用接口数据表 管理入口
|
* @author: Andy
|
* @update-time: 2022/10/8
|
*/
|
@Slf4j
|
@Component
|
public class ApiComDataPR {
|
|
@Autowired
|
private ApiComDataRep rep;
|
|
/**
|
* apiComDataPR#listAll
|
*
|
* @return
|
*/
|
@DataProvider
|
public List<ApiComData> listAll() {
|
return rep.findAll();
|
}
|
|
/**
|
* apiComDataPR#updateSave
|
*
|
* @param entity
|
*/
|
@DataResolver
|
public void updateSave(ApiComData entity) {
|
// 手动将doradoEntity对象转换为标准Bean对象
|
ApiComData data = new ApiComData();
|
BeanUtils.copyProperties(entity, data);
|
rep.save(data);
|
}
|
|
/**
|
* apiComDataPR#delData
|
*
|
* @param data
|
*/
|
@Expose
|
public String delData(ApiComData data) {
|
|
rep.deleteById(data.getId());
|
|
return null;
|
}
|
|
/**
|
* apiComDataPR#pageList
|
*
|
* @return
|
*/
|
@SuppressWarnings("serial")
|
@DataProvider
|
public void pageList(Page<ApiComData> page, Map<String, Object> param) {
|
//多参数分页查询
|
Pageable pageable = PageRequest.of(page.getPageNo() - 1, page.getPageSize(), Sort.Direction.DESC, "uploadTime");
|
|
if (null == param) {
|
org.springframework.data.domain.Page<ApiComData> japPage = rep.findAll(pageable);
|
page.setEntityCount((int) japPage.getTotalElements());
|
page.setEntities(japPage.getContent());
|
|
return;
|
}
|
|
Specification<ApiComData> specification = new Specification<ApiComData>() {
|
public Predicate toPredicate(Root<ApiComData> root, CriteriaQuery<?> query, CriteriaBuilder cb) {
|
List<Predicate> predicates = new ArrayList<Predicate>(); //所有的断言
|
|
String str = (String) param.get("kqdm");
|
if (StringUtils.isNotBlank(str)) {
|
Predicate predicate1 = cb.equal(root.get("kqdm"), str);
|
predicates.add(predicate1);
|
}
|
str = (String) param.get("inteId");
|
if (StringUtils.isNotBlank(str)) {
|
Predicate predicate2 = cb.equal(root.get("inteId"), str);
|
predicates.add(predicate2);
|
}
|
|
Date start = (Date) param.get("start");
|
if (null != start) {
|
Predicate predicate3 = cb.greaterThan(root.<Date>get("uploadTime"), ContextUtil.getCurZero(start));
|
predicates.add(predicate3);
|
}
|
Date end = (Date) param.get("end");
|
if (null != end) {
|
Predicate predicate4 = cb.lessThan(root.<Date>get("uploadTime"), ContextUtil.getNextZero(end));
|
predicates.add(predicate4);
|
}
|
|
return cb.and(predicates.toArray(new Predicate[0]));
|
}
|
};
|
|
log.debug("---------分页参数查询----------{}", param.toString());
|
org.springframework.data.domain.Page<ApiComData> japPage = rep.findAll(specification, pageable);
|
page.setEntityCount((int) japPage.getTotalElements());
|
page.setEntities(japPage.getContent());
|
}
|
|
}
|
