@Override
public SealListResp queryList(SealListVo sealListVo) {
QueryWrapper<ElectronicSealTotal> wrapper = new QueryWrapper<>();
wrapper.eq(StringUtil.isNotEmpty(sealListVo.getUserName()), "user_name", sealListVo.getUserName()).
eq(StringUtil.isNotEmpty(sealListVo.getUserType()), "user_type", sealListVo.getUserType()).
eq(StringUtil.isNotEmpty(sealListVo.getUserIdNo()), "info_sn", sealListVo.getUserIdNo()).
eq(StringUtil.isNotEmpty(sealListVo.getCertSn()), "cert_sn", sealListVo.getCertSn()).
eq(StringUtil.isNotEmpty(sealListVo.getAppName()), "app_name", sealListVo.getAppName()).
eq(sealListVo.getStatus() != 0, "seal_status", sealListVo.getStatus());
if (StringUtil.isNotEmpty(sealListVo.getBeginTime())) {
wrapper.ge("create_time", sealListVo.getBeginTime());
}
if (StringUtil.isNotEmpty(sealListVo.getEndTime())) {
Date date = DateFormater.formatEndTime(sealListVo.getEndTime());
wrapper.le("create_time", date);
}
wrapper.orderBy(true, false, "create_time");
//分页
//默认pagenum,pagesize 1,10
Long pageNum = 1L;
Long pageSize = 10L;
if (StringUtil.isNotEmpty(sealListVo.getPageNum())) {
pageNum = Long.parseLong(sealListVo.getPageNum());
}
if (StringUtil.isNotEmpty(sealListVo.getPageNum())) {
pageSize = Long.parseLong(sealListVo.getPageSize());
}
//分页
Page<ElectronicSealTotal> page = new Page<>(pageNum, pageSize);
IPage<ElectronicSealTotal> sealIPage = electronicSealTotalService.page(page, wrapper);
List<SealListResult> sealListResults = new ArrayList<SealListResult>();
for (ElectronicSealTotal sealTotal : sealIPage.getRecords()) {
ElectronicSeal seal = electronicSealService.getOne(Wrappers.<ElectronicSeal>lambdaQuery()
.eq(ElectronicSeal::getSealSn, sealTotal.getSealSn()));
SealListResult sealListResult = new SealListResult();
if (ObjectUtils.isNotEmpty(seal)) {
BeanUtils.copyProperties(seal, sealListResult);
sealListResult.setStatus(seal.getSealStatus());
String ESseal =fdfsService.download(seal.getSealUri());
sealListResult.setSeal(ESseal);
//拼装缺失的数据
//idno idnotype
sealListResult.setUserIdNo(seal.getInfoSn());
sealListResult.setUserIdNoType(seal.getInfoType());
//根据stampSn查询印章信息
String stampSn = seal.getStampSn();
Stamp stamp = stampService.getOne(Wrappers.<Stamp>lambdaQuery().eq(Stamp::getStampSn, stampSn));
sealListResult.setPicType(stamp.getStampFormat());
sealListResult.setPicData(stamp.getStampUri());
sealListResults.add(sealListResult);
}
}
SealListResp sealListResp = new SealListResp();
String total = String.valueOf(sealIPage.getTotal());
sealListResp.setTotal(total);
sealListResp.setData(sealListResults);
return sealListResp;
}