mongotemplate模糊查_MongoTemplate实现分页查询，模糊匹配

public Paging queryHelpDocList(HelpDocListQuery query) {

try {

logger.error("查询帮助文档列表入参 ：【{}】",JSONObject.toJSONString(query));

Paging paging = new Paging<>();

if (null != query.getPage() && null != query.getPageSize()) {

paging.setPage(query.getPage());

paging.setPageSize(query.getPageSize());

}

Integer page = query.getPage();

Integer pageSize = query.getPageSize();

List operations = new ArrayList<>();

if (null != query.getKeyword()) {

Pattern pattern = Pattern.compile("^.*" + query.getKeyword() + ".*$", Pattern.CASE_INSENSITIVE);

Criteria criteria = Criteria.where("title").regex(pattern);

operations.add(Aggregation.match(criteria));

}

if (null != query.getApp()) {

operations.add(Aggregation.match(Criteria.where("app").is(query.getApp())));

}

if (null != query.getCategoryCode()) {

operations.add(Aggregation.match(Criteria.where("categoryCode").is(query.getCategoryCode())));

}

long totalCount = 0;

//获取满足添加的总页数

if (null != operations && operations.size() > 0) {

Aggregation aggregationCount = Aggregation.newAggregation(operations);

AggregationResults resultsCount = template.aggregate(aggregationCount, "help_doc", HelpDocCategoryDto.class);

totalCount = resultsCount.getMappedResults().size();

} else {

List list = template.findAll(HelpDoc.class);

totalCount = list.size();

}

operations.add(Aggregation.skip((long) (page - 1) * pageSize));

operations.add(Aggregation.limit(pageSize));

operations.add(Aggregation.lookup("doc_category", "categoryCode", "code", "category"));

operations.add(Aggregation.sort(Sort.Direction.DESC, "solveCount"));

Aggregation aggregation = Aggregation.newAggregation(operations);

AggregationResults results = template.aggregate(aggregation, "help_doc", HelpDocCategoryDto.class);

paging.setData(results.getMappedResults());

paging.setTotalCount(totalCount);

return paging;

} catch (HelpException e) {

logger.error("查询帮助文档列表异常 -- ErrCode：[{}]，ErrMessage：[{}]", e.getErrCode(), e.getErrMessage());

throw e;

} catch (Exception e) {

throw e;

}

}

@Getter

@Setter

public class Paging implements Serializable {

/**

* 当前页数

*/

private int page = 1;

/**

* 每页条数

* 此参数为0时，不分页

*/

private int pageSize = 20;

/**

* 总条数

*/

private long totalCount;

/**

* 数据

*/

private List data;

public void setPageSize(int pageSize) {

if (0 < pageSize) {

this.pageSize = pageSize;

} else {

this.pageSize = 20;

}

}

/**

* 指定 page 页数据的起始条目数

*

* @return

*/

public int calculateSkip() {

return (page - 1) * pageSize;

}

}

@Getter

@Setter

public class HelpDocCategoryDto {

boolean isTop;

boolean isCategoryTop;

String code;

int app;

int solveCount;

int unSolveCount;

String categoryCode;

DocCategory category;

String title;

String staticHtmlPath;

String content;

Date createTime;

Date updateTime;

}

@Getter

@Setter

public class HelpDocListQuery implements Serializable {

private Integer page = 1;

private Integer pageSize = 20;

/**

* 匹配标题

*/

private String keyword;

/**

* 客户端：1 医生端 2 患者端

*/

private Integer app;

/**

* 分类code

*/

private String categoryCode;

}