| | |
| | | |
| | | private void addMemberModelByType(Integer id,Integer type, List<IdentityInfo> list,String path) { |
| | | MPJLambdaWrapper<IdentityInfo> wrapper = new MPJLambdaWrapper<IdentityInfo>() |
| | | .selectAll(IdentityInfo.class).selectAs(SystemUser::getUsername,IdentityInfo::getEditorName) |
| | | .selectAll(IdentityInfo.class) |
| | | .selectAs(SystemUser::getUsername,IdentityInfo::getEditorName) |
| | | .leftJoin(SystemUser.class,SystemUser::getId,IdentityInfo::getUpdateUser) |
| | | .orderByDesc(IdentityInfo::getCreateTime )//取最新一条 |
| | | .eq(IdentityInfo::getMemberId,id) |
| | |
| | | .last("limit 1"); |
| | | IdentityInfo model = identityInfoMapper.selectJoinOne(IdentityInfo.class,wrapper); |
| | | if(model !=null){ |
| | | model.setImgList(new ArrayList<>()); |
| | | if(StringUtils.isNotBlank(model.getImg1())){ |
| | | model.setImg1(path+model.getImg1()); |
| | | model.getImgList().add(model.getImg1()); |
| | | } |
| | | if(StringUtils.isNotBlank(model.getImg2())){ |
| | | model.setImg2(path+model.getImg2()); |
| | | model.getImgList().add(model.getImg2()); |
| | | } |
| | | if(StringUtils.isNotBlank(model.getImg3())) { |
| | | model.setImg3(path + model.getImg3()); |
| | | model.getImgList().add(model.getImg3()); |
| | | } |
| | | if(StringUtils.isNotBlank(model.getImg4())){ |
| | | model.setImg4(path+model.getImg4()); |
| | | model.getImgList().add(model.getImg4()); |
| | | } |
| | | initModelImage(model,path); |
| | | list.add(model); |
| | | } |
| | | } |
| | |
| | | MPJLambdaWrapper<IdentityInfo> queryWrapper = new MPJLambdaWrapper<>(); |
| | | Utils.MP.blankToNull(pageWrap.getModel()); |
| | | pageWrap.getModel().setDeleted(Constants.ZERO); |
| | | queryWrapper.selectAll(IdentityInfo.class).selectAs(SystemUser::getUsername,IdentityInfo::getEditorName) |
| | | queryWrapper.selectAll(IdentityInfo.class) |
| | | .selectAs(Member::getNickName,IdentityInfo::getMemberName) |
| | | .selectAs(Member::getOpenid,IdentityInfo::getOpenid) |
| | | .selectAs(SystemUser::getUsername,IdentityInfo::getEditorName) |
| | | .leftJoin(Member.class,Member::getId,IdentityInfo::getMemberId) |
| | | .leftJoin(SystemUser.class,SystemUser::getId,IdentityInfo::getUpdateUser); |
| | | if (pageWrap.getModel().getId() != null) { |
| | | queryWrapper.eq(IdentityInfo::getId, pageWrap.getModel().getId()); |
| | |
| | | queryWrapper.le(IdentityInfo::getUpdateTime, Utils.Date.getEnd(pageWrap.getModel().getUpdateTime())); |
| | | } |
| | | if (pageWrap.getModel().getRemark() != null) { |
| | | queryWrapper.eq(IdentityInfo::getRemark, pageWrap.getModel().getRemark()); |
| | | queryWrapper.like(IdentityInfo::getRemark, pageWrap.getModel().getRemark()); |
| | | } |
| | | if (pageWrap.getModel().getType() != null) { |
| | | queryWrapper.eq(IdentityInfo::getType, pageWrap.getModel().getType()); |
| | |
| | | queryWrapper.eq(IdentityInfo::getAuthType, pageWrap.getModel().getAuthType()); |
| | | } |
| | | if (pageWrap.getModel().getLinkName() != null) { |
| | | queryWrapper.eq(IdentityInfo::getLinkName, pageWrap.getModel().getLinkName()); |
| | | queryWrapper.like(IdentityInfo::getLinkName, pageWrap.getModel().getLinkName()); |
| | | } |
| | | if (pageWrap.getModel().getTelephone() != null) { |
| | | queryWrapper.eq(IdentityInfo::getTelephone, pageWrap.getModel().getTelephone()); |
| | | queryWrapper.like(IdentityInfo::getTelephone, pageWrap.getModel().getTelephone()); |
| | | } |
| | | if (pageWrap.getModel().getLocation() != null) { |
| | | queryWrapper.eq(IdentityInfo::getLocation, pageWrap.getModel().getLocation()); |
| | | queryWrapper.like(IdentityInfo::getLocation, pageWrap.getModel().getLocation()); |
| | | } |
| | | if (pageWrap.getModel().getCompanyName() != null) { |
| | | queryWrapper.eq(IdentityInfo::getCompanyName, pageWrap.getModel().getCompanyName()); |
| | | queryWrapper.like(IdentityInfo::getCompanyName, pageWrap.getModel().getCompanyName()); |
| | | } |
| | | if (pageWrap.getModel().getLat() != null) { |
| | | queryWrapper.eq(IdentityInfo::getLat, pageWrap.getModel().getLat()); |
| | |
| | | queryWrapper.le(IdentityInfo::getAuditTime, Utils.Date.getEnd(pageWrap.getModel().getAuditTime())); |
| | | } |
| | | if (pageWrap.getModel().getAuditRemark() != null) { |
| | | queryWrapper.eq(IdentityInfo::getAuditRemark, pageWrap.getModel().getAuditRemark()); |
| | | queryWrapper.like(IdentityInfo::getAuditRemark, pageWrap.getModel().getAuditRemark()); |
| | | } |
| | | for(PageWrap.SortData sortData: pageWrap.getSorts()) { |
| | | if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { |
| | | queryWrapper.orderByDesc(sortData.getProperty()); |
| | | } else { |
| | | queryWrapper.orderByAsc(sortData.getProperty()); |
| | | queryWrapper.orderByAsc(IdentityInfo::getAuditStatus ); |
| | | queryWrapper.orderByDesc(IdentityInfo::getCreateTime ); |
| | | PageData<IdentityInfo> result = PageData.from(identityInfoMapper.selectJoinPage(page,IdentityInfo.class, queryWrapper)); |
| | | if(result!=null && result.getRecords()!=null){ |
| | | String path = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.RESOURCE_PATH).getCode() |
| | | +systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.INENTITY_FILES).getCode(); |
| | | for (IdentityInfo model :result.getRecords()){ |
| | | initModelImage(model,path); |
| | | } |
| | | } |
| | | return PageData.from(identityInfoMapper.selectJoinPage(page,IdentityInfo.class, queryWrapper)); |
| | | |
| | | return result; |
| | | |
| | | } |
| | | |
| | | private void initModelImage(IdentityInfo model, String path) { |
| | | model.setImgList(new ArrayList<>()); |
| | | if(StringUtils.isNotBlank(model.getImg1())){ |
| | | model.setImg1(path+model.getImg1()); |
| | | model.getImgList().add(model.getImg1()); |
| | | } |
| | | if(StringUtils.isNotBlank(model.getImg2())){ |
| | | model.setImg2(path+model.getImg2()); |
| | | model.getImgList().add(model.getImg2()); |
| | | } |
| | | if(StringUtils.isNotBlank(model.getImg3())) { |
| | | model.setImg3(path + model.getImg3()); |
| | | model.getImgList().add(model.getImg3()); |
| | | } |
| | | if(StringUtils.isNotBlank(model.getImg4())){ |
| | | model.setImg4(path+model.getImg4()); |
| | | model.getImgList().add(model.getImg4()); |
| | | } |
| | | } |
| | | |
| | | @Override |
| | |
| | | QueryWrapper<IdentityInfo> wrapper = new QueryWrapper<>(identityInfo); |
| | | return identityInfoMapper.selectCount(wrapper); |
| | | } |
| | | |
| | | |
| | | public void audit(){ |
| | | |
| | | |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | } |