LambdaQueryWrapper<EnergyRechargeRecord> queryWrapper = Wrappers.lambdaQuery();
if (StrUtil.isNotBlank(query.getPayTimeStart())) {
queryWrapper.ge(EnergyRechargeRecord::getPayTime, query.getPayTimeStart());
}
if (StrUtil.isNotBlank(query.getPayTimeEnd())) {
queryWrapper.le(EnergyRechargeRecord::getPayTime, query.getPayTimeEnd());
}
//平台订单号/第三方充值订单号
if (StrUtil.isNotBlank(query.getOrderNo())) {
queryWrapper.and((i) -> i.like(EnergyRechargeRecord::getOrderNo, query.getOrderNo())
.or().like(EnergyRechargeRecord::getPayOrderNo, query.getOrderNo()));
}
// if (StrUtil.isNotBlank(query.getPayOrderNo())) {
// queryWrapper.eq(EnergyRechargeRecord::getPayOrderNo, query.getPayOrderNo());
// }
// if (StrUtil.isNotBlank(query.getBizType())) {
// String bizTypeDesc = BizTypeEnum.LOOK_UP.getOrDefault(query.getBizType(), null);
// queryWrapper.eq(EnergyRechargeRecord::getBizTypeDesc, bizTypeDesc);
// }
//户号或者名称
String mbrConsNoAndName = query.getMbrConsNoAndName();
if (StrUtil.isNotBlank(query.getMbrConsNoAndName())) {
queryWrapper.and((i) -> i.like(EnergyRechargeRecord::getMbrConsNo, mbrConsNoAndName)
.or().like(EnergyRechargeRecord::getMbrConsName, mbrConsNoAndName));
}
//倒序
queryWrapper.orderByDesc(EnergyRechargeRecord::getPayTime);
if (StrUtil.isNotBlank(query.getMbrConsId())) {
queryWrapper.eq(EnergyRechargeRecord::getMbrConsId, query.getMbrConsId());
}
IPage<EnergyRechargeRecord> page = new Page<>(query.getPageNum(), query.getPageSize());
//户号或者名称
String mbrConsNoAndName = query.getMbrConsNoAndName();
if (StrUtil.isNotBlank(query.getMbrConsNoAndName())) {
queryWrapper.and((i) -> i.like(EnergyRechargeRecord::getMbrConsNo, mbrConsNoAndName)
.or().like(EnergyRechargeRecord::getMbrConsName, mbrConsNoAndName));
}