条件分页查询
@Override
public CommonResult AllFactorSign( ReportPageRequest request) {
//条件查询
LambdaQueryWrapper<SmsTemplate> queryWrapper = new LambdaQueryWrapper<>();
if (StrUtil.isNotBlank(request.getNameOrOrderOrCode())) {
queryWrapper.like(SmsTemplate::getTemplateName, request.getNameOrOrderOrCode())
.or().like(SmsTemplate::getOrderId, request.getNameOrOrderOrCode())
.or().like(SmsTemplate::getTemplateCode, request.getNameOrOrderOrCode());
}
if (Objects.nonNull(request.getTemplateType())) {
queryWrapper.eq(SmsTemplate::getTemplateType, request.getTemplateType());
}
if (Objects.nonNull(request.getCreateTime())) {
queryWrapper.apply((ObjectUtil.isNotNull(request.getCreateTime())), "DATE_FORMAT(create_time, '%Y-%m-%d') = {0}", request.getCreateTime());
}
if (StrUtil.isNotBlank(request.getTemplateStatus())) {
queryWrapper.eq(SmsTemplate::getTemplateStatus, request.getTemplateStatus());
}
//current:当前页 size:条数
Page<SmsTemplate> page = new Page<>(request.getCurrent(), request.getSize());
//根据条件查询数据
IPage<SmsTemplate> iPage = smsTemplateMapper.selectPage(page, queryWrapper);
List<SmsTemplate> list = iPage.getRecords();
return CommonResult.success(list);
}
ReportPageRequest
@Data
public class ReportPageRequest {
/**
* 模板名称,工单号,模板code
*/
@ApiModelProperty(name = "nameOrOrderOrCode", value = "模板名称/工单号/模板code--0:验证码。1:短信通知。2:推广短信。3:国际/港澳台消息。")
private String nameOrOrderOrCode;
/**
* 模板类型
*/
@ApiModelProperty(name = "templateType", value = "模板类型--0:验证码。1:短信通知。2:推广短信。3:国际/港澳台消息。")
private Integer templateType;
/**
* 模板创建时间
*/
private LocalDate createTime;
/**
* 模板审核状态
*/
@ApiModelProperty(name = "templateStatus", value = "模板审核状态--approving:审核中 approved:审核通过 rejected:审核未通过")
private String templateStatus;
/**
* 当前页数
*/
private Integer current;
/**
* 当前条数
*/
private Integer size;
}