MP查询结果处理（带分页）

@Override

public Page<SocEvent> listPageWithParams(

SocEventPageDto params, Page<SocEvent> pages, QueryWrapper<SocEvent> ew) {

if (ew == null) {

ew = new QueryWrapper();

}

if (params.getStartTime() != null && params.getEndTime()!= null){

ew.between(SocEvent.EVENT_TIME, DateUtils.yyyy_MM_dd_HH_mm_ss(params.getStartTime()), DateUtils.yyyy_MM_dd_HH_mm_ss(params.getEndTime()));

}

if(params.getEventName()!= null && !"".equals(params.getEventName())){

ew.like(SocEvent.EVENT_NAME,params.getEventName());

}

if(params.getEventLevel()!= null && !"".equals(params.getEventLevel())){

ew.like(SocEvent.EVENT_LEVEL,params.getEventLevel());

}

if(params.getCategory()!= null && !"".equals(params.getCategory())){

ew.like(SocEvent.CATEGORY,params.getCategory());

}

if(params.getSubCategory()!= null && !"".equals(params.getSubCategory())){

ew.like(SocEvent.SUB_CATEGORY,params.getSubCategory());

}

if(params.getSrcIp()!= null && !"".equals(params.getSrcIp())){

ew.like(SocEvent.SRC_IP,params.getSrcIp());

}

if(params.getDstIp()!= null && !"".equals(params.getDstIp())){

ew.like(SocEvent.DST_IP,params.getDstIp());

}

if(params.getDeviceIp()!= null && !"".equals(params.getDeviceIp())){

ew.like(SocEvent.DEVICE_IP,params.getDeviceIp());

}

if(params.getSrcPort()!= null){

ew.eq(SocEvent.SRC_PORT,params.getSrcPort());

}

if(params.getDstPort()!= null){

ew.eq(SocEvent.DST_PORT,params.getDstPort());

}

ew.eq(SocEvent.DELETE_FLAG,false);

Page<SocEvent> page = page(pages, ew);

List<SocEvent> records = page.getRecords();

for(SocEvent socEvent:records){

if(socEvent.getEventLevel().equals("1")){

socEvent.setEventLevel("严重");

}

if(socEvent.getEventLevel().equals("2")){

socEvent.setEventLevel("高级");

}

if(socEvent.getEventLevel().equals("3")){

socEvent.setEventLevel("中级");

}

if(socEvent.getEventLevel().equals("4")){

socEvent.setEventLevel("低级");

}

if(socEvent.getEventLevel().equals("5")){

socEvent.setEventLevel("信息");

}

}

page.setRecords(records);

return page;

}

@SysLogInfo("列表")

@ApiOperation("列表")

@PostMapping(value = "/list")

public PageRetDTO<SocEventDto> list(@RequestBody SocEventPageDto pageDto) {

Page<SocEvent> pages = getPage(pageDto);

pages = socEventService.listPageWithParams(pageDto, pages, null);

Page<SocEventDto> dtoPages = getPageDTOFromPageDao(pages, SocEventDto.class);

return getPageRetFromPage(dtoPages);

}