From 1c20c8231980a8d4b91688ff8641a06d3b2f68ab Mon Sep 17 00:00:00 2001 From: MrShi <1878285526@qq.com> Date: 星期二, 14 十月 2025 16:34:22 +0800 Subject: [PATCH] 改bug --- server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitsServiceImpl.java | 186 ++++++++++++++++++++++++---------------------- 1 files changed, 98 insertions(+), 88 deletions(-) diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitsServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitsServiceImpl.java index 8cf3245..d9ab31f 100644 --- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitsServiceImpl.java +++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitsServiceImpl.java @@ -689,7 +689,7 @@ if(Constants.equalsInteger(visits.getType(),Constants.ZERO) || Constants.equalsInteger(visits.getType(),Constants.ONE)){ if( visits.getIdcardType() == null - || StringUtils.isBlank( visits.getIdcardNo() ) || StringUtils.isBlank(visits.getFaceImg()) ){ + || StringUtils.isBlank(visits.getFaceImg()) ){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "瀵逛笉璧凤紝淇℃伅濉啓涓嶆纭紒"); } } @@ -896,38 +896,41 @@ List<Member> addList = new ArrayList<>(); List<Member> editList = new ArrayList<>(); //鐢宠浜轰俊鎭� - Member m = getMemberListParam(visits.getIdcardNo(),visits,addList,editList); + Member m = getMemberListParam(visits.getPhone(),visits.getIdcardNo(),visits,addList,editList); //闅忚浜哄憳淇℃伅澶勭悊 - if(visits.getWithUserList()!= null && visits.getWithUserList().size()>0){ - for(Visits model:visits.getWithUserList()){ - model.setBirthday(Constants.getBirthdyByCardNo(model.getIdcardNo())); - model.setStarttime(visits.getStarttime()); - model.setEndtime(visits.getEndtime()); - //鏍¢獙闅忚浜哄憳濉姤鏁版嵁鍚堟硶鎬� - isValidWithVisitParam(model,addList,editList); - model.setCreateDate(visits.getCreateDate()); - Member visitsMember = getMemberListParam(model.getIdcardNo(),model,addList,editList); - model.setMemberId(visitsMember.getId()); - } - } +// if(visits.getWithUserList()!= null && visits.getWithUserList().size()>0){ +// for(Visits model:visits.getWithUserList()){ +// model.setBirthday(Constants.getBirthdyByCardNo(model.getIdcardNo())); +// model.setStarttime(visits.getStarttime()); +// model.setEndtime(visits.getEndtime()); +// //鏍¢獙闅忚浜哄憳濉姤鏁版嵁鍚堟硶鎬� +// isValidWithVisitParam(model,addList,editList); +// model.setCreateDate(visits.getCreateDate()); +// Member visitsMember = getMemberListParam(model.getIdcardNo(),model,addList,editList); +// model.setMemberId(visitsMember.getId()); +// } +// } return m; } - private Member getMemberListParam(String cardno, Visits visits, List<Member> addList, List<Member> editList) { + private Member getMemberListParam(String phone,String cardno, Visits visits, List<Member> addList, List<Member> editList) { if(StringUtils.isNotBlank(visits.getCarNos()) &&Objects.isNull(Constants.getVehiclePlateNo(visits.getCarNos())) ){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "瀵逛笉璧凤紝杞︾墝鍙枫��"+visits.getCarNos()+"銆戜笉鍚堟硶锛岃鏍稿疄鍚庨噸璇晘"); } - if(Constants.equalsInteger(Constants.ZERO, visits.getIdcardType())&&cardno.length()!=18 - //&&!IdcardUtil.isValidCard(cardno) - ){ - throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "瀵逛笉璧凤紝韬唤璇併��"+cardno+"銆戝彿鐮佹湁璇紝璇锋牳瀹炲悗閲嶈瘯锛�"); - } + +// if(StringUtils.isNotBlank(cardno)&&Constants.equalsInteger(Constants.ZERO, visits.getIdcardType())&&cardno.length()!=18 +// //&&!IdcardUtil.isValidCard(cardno) +// ){ +// throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "瀵逛笉璧凤紝韬唤璇併��"+cardno+"銆戝彿鐮佹湁璇紝璇锋牳瀹炲悗閲嶈瘯锛�"); +// } Member member = memberMapper.selectOne(new QueryWrapper<Member>().lambda() .eq(Member::getType,Constants.memberType.visitor) .eq(Member::getIdcardType,visits.getIdcardType()) - .eq(Member::getIdcardNo,DESUtil.encrypt(Constants.EDS_PWD, cardno)).last("limit 1" ) + .eq(Member::getPhone,phone) +// .eq(Member::getIdcardNo,DESUtil.encrypt(Constants.EDS_PWD, cardno)) + .last("limit 1" ) ); if(member == null){ member = new Member(); @@ -935,12 +938,14 @@ member.setCreateDate(visits.getCreateDate()); member.setIsdeleted(Constants.ZERO); member.setIdcardNo(visits.getIdcardNo()); - member.setBirthday(Constants.getBirthdyByCardNo(cardno)); member.setIdcardDecode(visits.getIdcardDecode()); - member.setIdcardNo(DESUtil.encrypt(Constants.EDS_PWD, cardno));//韬唤璇佸彿鍔犲瘑 - member.setIdcardDecode(Constants.getTuominStr(cardno));//鑴辨晱鎵嬫満鍙� + if(StringUtils.isNotBlank(cardno)){ + member.setBirthday(Constants.getBirthdyByCardNo(cardno)); + member.setIdcardNo(DESUtil.encrypt(Constants.EDS_PWD, cardno));//韬唤璇佸彿鍔犲瘑 + member.setIdcardDecode(Constants.getTuominStr(cardno));//鑴辨晱鎵嬫満鍙� + member.setSex(Constants.getSexByCardNo(cardno)); + } member.setFaceImg(visits.getFaceImg()); - member.setSex(Constants.getSexByCardNo(cardno)); member.setImgurl(StringUtils.isNotBlank(visits.getImgurl())?visits.getImgurl():null); member.setIdcardType(visits.getIdcardType()); member.setName(visits.getName()); @@ -948,7 +953,6 @@ member.setOpenid(visits.getOpenid()); member.setType(Constants.memberType.visitor); member.setStatus(Constants.ZERO); - member.setSex(Constants.getSexByCardNo(cardno)); member.setHkStatus(Constants.ZERO); member.setErpStatus(Constants.ZERO); member.setVisitCompanyName(visits.getCompanyName()); @@ -958,7 +962,7 @@ }else{ if(!Constants.equalsInteger(Constants.ZERO,member.getStatus() )){ //濡傛灉鐢ㄦ埛鐘舵�佸紓甯革紝鍒欐彁绀� - throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "瀵逛笉璧凤紝銆�"+member.getName()+"銆戣韩浠借瘉鍙枫��"+cardno+"銆戝湪榛戝悕鍗曞唴锛屾棤娉曠敵璇疯繘鍏ュ洯鍖�"); + throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "瀵逛笉璧凤紝銆�"+member.getName()+"銆戝湪榛戝悕鍗曞唴锛屾棤娉曠敵璇疯繘鍏ュ洯鍖�"); } //鏍告煡棰勭害鐢ㄦ埛鏄惁瀛樺湪鏈绂荤殑棰勭害璁板綍 // isExsitNoOutVisisRecord(member); @@ -966,13 +970,15 @@ member.setImgurl(StringUtils.isNotBlank(visits.getImgurl())?visits.getImgurl():null); member.setEditDate(visits.getCreateDate()); member.setIsdeleted(Constants.ZERO); - member.setSex(Constants.getSexByCardNo(cardno)); - member.setIdcardNo(DESUtil.encrypt(Constants.EDS_PWD, cardno));//韬唤璇佸彿鍔犲瘑 - member.setIdcardDecode(Constants.getTuominStr(cardno));//鑴辨晱韬唤璇佸彿 + if(StringUtils.isNotBlank(cardno)){ + member.setBirthday(Constants.getBirthdyByCardNo(cardno)); + member.setIdcardNo(DESUtil.encrypt(Constants.EDS_PWD, cardno));//韬唤璇佸彿鍔犲瘑 + member.setIdcardDecode(Constants.getTuominStr(cardno));//鑴辨晱鎵嬫満鍙� + member.setSex(Constants.getSexByCardNo(cardno)); + } member.setName(visits.getName()); member.setPhone(visits.getPhone()); member.setOpenid(visits.getOpenid()); - member.setSex(Constants.getSexByCardNo(cardno)); member.setHkStatus(Constants.ZERO); member.setErpStatus(Constants.ZERO); member.setVisitCompanyName(visits.getCompanyName()); @@ -986,16 +992,14 @@ ,Constants.VisitStatus.xfFail ,Constants.VisitStatus.signout ,Constants.VisitStatus.invalid) - .eq(Visits::getIdcardDecode, Constants.getTuominStr(cardno)) - .and(ms -> ms.eq(Visits::getPhone, visits.getPhone()) - .or().eq(Visits::getIdcardDecode, Constants.getTuominStr(cardno))) + .and(ms -> ms.eq(Visits::getPhone, visits.getPhone())) .and(ms -> ms.apply(" visits.STARTTIME <= '" + DateUtil.DateToStr(visits.getStarttime(),"yyyy-MM-dd HH:mm:ss") + "' and visits.ENDTIME >= '" + DateUtil.DateToStr(visits.getStarttime(),"yyyy-MM-dd HH:mm:ss") + "' ") .or().apply(" visits.STARTTIME <= '" + DateUtil.DateToStr(visits.getEndtime(),"yyyy-MM-dd HH:mm:ss") + "' and visits.ENDTIME >= '" + DateUtil.DateToStr(visits.getEndtime(),"yyyy-MM-dd HH:mm:ss") + "' ") .or().apply(" visits.STARTTIME >= '" + DateUtil.DateToStr(visits.getStarttime(),"yyyy-MM-dd HH:mm:ss") + "' and visits.STARTTIME <= '" + DateUtil.DateToStr(visits.getEndtime(),"yyyy-MM-dd HH:mm:ss") + "' ") .or().apply(" visits.ENDTIME >= '" + DateUtil.DateToStr(visits.getStarttime(),"yyyy-MM-dd HH:mm:ss") + "' and visits.ENDTIME <= '" + DateUtil.DateToStr(visits.getEndtime(),"yyyy-MM-dd HH:mm:ss") + "' ") ) ) > Constants.ZERO) { - throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "瀵逛笉璧凤紝鎵嬫満鍙枫��"+member.getPhone()+"銆戞垨韬唤璇併��"+ member.getIdcardDecode() +"銆戝瓨鍦ㄩ绾︽椂闂村啿绐侊紝鏃犳硶鐢宠鍝︼紒"); + throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "瀵逛笉璧凤紝鎵嬫満鍙枫��"+member.getPhone()+"銆戝瓨鍦ㄩ绾︽椂闂村啿绐侊紝鏃犳硶鐢宠鍝︼紒"); } return member; } @@ -1292,6 +1296,7 @@ queryWrapper.selectAll(Visits.class); queryWrapper.select(" ( select count(distinct(v.CAR_NOS)) from visits v where v.PARENT_ID = t.ID and v.CAR_NOS is not null and v.CAR_NOS != '' and v.CAR_NOS != t.CAR_NOS ) as carNum "); + queryWrapper.select(" ( select count(distinct(v.id)) from retention v where v.member_id = t.member_id and v.type=1 )",Visits::getRetentionNum); queryWrapper.selectAs(Member::getName,Visits::getReceptMemberName); queryWrapper.selectAs(Company::getName,Visits::getReceptMemberDepartment); queryWrapper.leftJoin(Member.class,Member::getId,Visits::getReceptMemberId); @@ -1594,12 +1599,15 @@ @Override - public void visitsSelfCancel(Integer visitId,Integer memberId){ + public void visitsSelfCancel(Integer visitId,Integer memberId,String openid){ Visits visits = visitsMapper.selectById(visitId); if(Objects.isNull(visits)){ throw new BusinessException(ResponseStatus.DATA_EMPTY); } - if(!(Constants.equalsInteger(memberId,visits.getMemberId()))){ +/* if(!(Constants.equalsInteger(memberId,visits.getMemberId()))){ + throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鏃犳鎿嶄綔鏉冮檺"); + }*/ + if(!StringUtils.equals(openid,visits.getOpenid())){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鏃犳鎿嶄綔鏉冮檺"); } this.visitsCancelBiz(visits); @@ -1613,7 +1621,8 @@ } if(!( CollectionUtils.isNotEmpty(loginUserInfo.getPermissions()) && - loginUserInfo.getPermissions().stream().filter(i->i.equals("business:visits:cancel")).collect(Collectors.toList()).size()>0)){ + loginUserInfo.getPermissions().stream().filter(i->i.equals("business:visits:cancel")) + .collect(Collectors.toList()).size()>0)){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鏃犳鎿嶄綔鏉冮檺"); } this.visitsCancelBiz(visits); @@ -1630,7 +1639,8 @@ .eq(Visits::getId,visits.getId()); //璁垮鎶ュ if(Constants.equalsInteger(visits.getType(),Constants.TWO)){ - if(!(Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.waitCheck)||Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.submitCheck) + if(!(Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.waitCheck) + ||Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.submitCheck) || Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.pass))){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璁垮璁板綍鐘舵�侀敊璇紝鏃犳硶杩涜璇ユ搷浣�"); } @@ -1753,7 +1763,7 @@ } List<DeviceRole> roleList = deviceRoleMapper.selectList(new QueryWrapper<DeviceRole>().lambda() .eq(DeviceRole::getType, Constants.ONE)); - String path = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode() + String path = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_LOCAL_RESOURCE_PATH).getCode() +systemDictDataBiz.queryByCode(Constants.FTP,Constants.MEMBER_IMG).getCode(); HkSyncVisitServiceImpl.getUpdateModelByResponseIccm(visits,new Date(),roleList,path); @@ -1814,11 +1824,7 @@ //浠婃棩鍦ㄥ洯浜烘暟 pcWorkPlatformDataVO.setTodayInParkUserNum( - inoutRecordMapper.selectCount(new QueryWrapper<InoutRecord>().lambda() - .isNotNull(InoutRecord::getMemberPhone) - .isNull(InoutRecord::getCarCode) - .apply( " DATE(TIME_INFO) = CURDATE() " )) - //retentionList.stream().filter(i->!Constants.equalsInteger(i.getType(),Constants.THREE)).count() + retentionList.stream().filter(i->!Constants.equalsInteger(i.getType(),Constants.THREE)).count() ); pcWorkPlatformDataVO.setTodayInUserNum(Constants.ZERO); @@ -1826,13 +1832,7 @@ //鍦ㄥ洯闀挎湡鐩稿叧鏂逛汉鏁� pcWorkPlatformDataVO.setInParkLwUserNum( - inoutRecordMapper.selectCount(new QueryWrapper<InoutRecord>().lambda() - .eq(InoutRecord::getMemberType,Constants.TWO) - .isNotNull(InoutRecord::getMemberPhone) - .isNull(InoutRecord::getCarCode) - .apply( " DATE(TIME_INFO) = CURDATE() " )) -// retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.TWO) -// && Constants.equalsInteger(i.getCompanyType(),Constants.ZERO)).count() + retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.FOUR)).count() ); pcWorkPlatformDataVO.setLwUserInNum(Constants.ZERO); pcWorkPlatformDataVO.setLwUserOutNum(Constants.ZERO); @@ -1840,30 +1840,18 @@ //鍦ㄥ洯璁垮鏁伴噺 pcWorkPlatformDataVO.setInParkVisitUserNum( - inoutRecordMapper.selectCount(new QueryWrapper<InoutRecord>().lambda() - .eq(InoutRecord::getMemberType,Constants.ZERO) - .isNotNull(InoutRecord::getMemberPhone) - .isNull(InoutRecord::getCarCode) - .apply( " DATE(TIME_INFO) = CURDATE() " )) - //retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.ONE)&&Objects.isNull(i.getCompanyType())).count() + retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.ONE)&&Objects.isNull(i.getCompanyType())).count() ); pcWorkPlatformDataVO.setVisitUserNum(Constants.ZERO); pcWorkPlatformDataVO.setSignLevelNum(Constants.ZERO); //鍦ㄥ洯璐ц繍杞﹁締鍙告満 - pcWorkPlatformDataVO.setInParkDriverUserNum(inoutRecordMapper.selectCount(new QueryWrapper<InoutRecord>().lambda() - .eq(InoutRecord::getMemberType,Constants.THREE) - .isNotNull(InoutRecord::getMemberPhone) - .isNull(InoutRecord::getCarCode) - .apply( " DATE(TIME_INFO) = CURDATE() " ))); + pcWorkPlatformDataVO.setInParkDriverUserNum( + retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.FIVE)&&Objects.isNull(i.getCompanyType())).count()); //鍦ㄥ洯杞﹁締 pcWorkPlatformDataVO.setTodayInParkCarNum( - inoutRecordMapper.selectCount(new QueryWrapper<InoutRecord>().lambda() - .isNotNull(InoutRecord::getCarCode) - .isNull(InoutRecord::getMemberPhone) - .apply( " DATE(TIME_INFO) = CURDATE() " )) - //retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.THREE)).count() + retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.THREE)).count() ); pcWorkPlatformDataVO.setTodayInCarNum(Constants.ZERO); pcWorkPlatformDataVO.setTodayOutCarNum(Constants.ZERO); @@ -1889,23 +1877,37 @@ List<InterestedListVO> lwList = new ArrayList<>(); List<InterestedListVO> internalList = new ArrayList<>(); //鏌ヨ涓冨ぉ鍓嶇殑璁垮璁板綍鏁伴噺 - List<Visits> visitsList = visitsMapper.selectList(new QueryWrapper<Visits>().lambda().in(Visits::getStatus, - Constants.VisitStatus.signin,Constants.VisitStatus.signout) - .apply(" STARTTIME > CURDATE() - INTERVAL 7 DAY " ) +// List<Visits> visitsList = visitsMapper.selectList(new QueryWrapper<Visits>().lambda().in(Visits::getStatus, +// Constants.VisitStatus.signin,Constants.VisitStatus.signout) +// .apply(" STARTTIME > CURDATE() - INTERVAL 7 DAY " ) +// ); + + List<InoutRecord> inoutRecordList = inoutRecordMapper.selectList(new QueryWrapper<InoutRecord>().lambda() + .eq(InoutRecord::getInOrOut,Constants.ZERO).eq(InoutRecord::getIsdeleted,Constants.ZERO) + .apply(" TIME_INFO > CURDATE() - INTERVAL 7 DAY " ) ); - List<CarEvent> carEventList = carEventMapper.selectList(new QueryWrapper<CarEvent>().lambda() - .in(CarEvent::getEventType,"771760131","771760130") - .apply(" STR_TO_DATE(happen_time, '%Y-%m-%dT%H:%i:%s') > CURDATE() - INTERVAL 7 DAY " ) - ); +// List<CarEvent> carEventList = carEventMapper.selectList(new QueryWrapper<CarEvent>().lambda() +// .in(CarEvent::getEventType,"771760131","771760130") +// .apply(" STR_TO_DATE(happen_time, '%Y-%m-%dT%H:%i:%s') > CURDATE() - INTERVAL 7 DAY " ) +// ); for (String days:weekDays) { InterestedListVO visitVO = new InterestedListVO(); visitVO.setName(days); - if(CollectionUtils.isNotEmpty(visitsList)){ + if(CollectionUtils.isNotEmpty(inoutRecordList)){ //澶勭悊璁垮浜哄憳鏁伴噺 - List<Visits> daysList = visitsList.stream().filter(i->Objects.nonNull(i.getStarttime())&&DateUtil.dateToString(i.getStarttime(),"yyyy-MM-dd").equals(days)).collect(Collectors.toList()); - List<String> memberIds = daysList.stream().map(i->i.getMemberId().toString()).collect(Collectors.toList()); +// List<Visits> daysList = visitsList.stream().filter(i->Objects.nonNull(i.getStarttime())&&DateUtil.dateToString(i.getStarttime(),"yyyy-MM-dd").equals(days)).collect(Collectors.toList()); +// List<String> memberIds = daysList.stream().map(i->i.getMemberId().toString()).collect(Collectors.toList()); + + List<String> memberIds = inoutRecordList.stream().filter(i-> + Objects.isNull(i.getCarCode()) + && Constants.equalsInteger(i.getMemberType(),Constants.ONE) + && Constants.equalsInteger(i.getInOrOut(),Constants.ZERO) + && Objects.nonNull(i.getMemberPhone())&&DateUtil.dateToString(i.getTimeInfo(),"yyyy-MM-dd").equals(days) + ) + .map(i->i.getMemberPhone()) + .collect(Collectors.toList()); if(CollectionUtils.isNotEmpty(memberIds)){ visitVO.setNum(new HashSet<String>(memberIds).size()); } @@ -1916,33 +1918,39 @@ visitVO.setName(days); + weekVisitList.add(visitVO); + InterestedListVO carVO = new InterestedListVO(); + carVO.setNum(Constants.ZERO); carVO.setName(days); - - if(CollectionUtils.isNotEmpty(carEventList)){ + if(CollectionUtils.isNotEmpty(inoutRecordList)){ //澶勭悊璁垮浜哄憳鏁伴噺 - List<CarEvent> daysList = carEventList.stream().filter(i->StringUtils.isNotBlank(i.getHappenTime()) && i.getHappenTime().substring(0,10).equals(days)).collect(Collectors.toList()); - List<String> carCodeList = daysList.stream().map(i->i.getPlateNos()).collect(Collectors.toList()); +// List<CarEvent> daysList = carEventList.stream().filter(i->StringUtils.isNotBlank(i.getHappenTime()) && i.getHappenTime().substring(0,10).equals(days)).collect(Collectors.toList()); +// List<String> carCodeList = daysList.stream().map(i->i.getPlateNos()).collect(Collectors.toList()); + List<String> carCodeList = inoutRecordList.stream().filter(i-> + Objects.nonNull(i.getCarCode()) + && Constants.equalsInteger(i.getInOrOut(),Constants.ZERO) + &&DateUtil.dateToString(i.getTimeInfo(),"yyyy-MM-dd").equals(days) + ) + .map(i->i.getCarCode()) + .collect(Collectors.toList()); if(CollectionUtils.isNotEmpty(carCodeList)){ carVO.setNum(new HashSet<String>(carCodeList).size()); } } if(Objects.isNull(carVO.getNum())){ - visitVO.setNum(Constants.ZERO); + carVO.setNum(Constants.ZERO); } - weekVisitList.add(visitVO); weekCarList.add(carVO); } pcWorkPlatformDataVO.setWeekVisitList(weekVisitList ); pcWorkPlatformDataVO.setWeekCarList(weekCarList); List<Company> companyList = companyMapper.selectList(new QueryWrapper<Company>().lambda() - .eq(Company::getType,Constants.ZERO) .eq(Company::getIsdeleted,Constants.ZERO) + .orderByAsc(Company::getSortnum) ); - - if(CollectionUtils.isNotEmpty(companyList)){ List<Company> lwCompanyList = companyList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.ZERO)).collect(Collectors.toList()); @@ -1950,7 +1958,8 @@ List<Integer> lwCompanyIds = lwCompanyList.stream().map(i->i.getId()).collect(Collectors.toList()); List<Retention> retentionList = retentionMapper.selectList( new QueryWrapper<Retention>().lambda() - .eq(Retention::getType,Constants.TWO) + .eq(Retention::getIsdeleted,Constants.ZERO) + .eq(Retention::getType,Constants.FOUR) .in(Retention::getCompanyId,lwCompanyIds) ); for (Company company:lwCompanyList) { @@ -1969,6 +1978,7 @@ List<Integer> internalCompanyIds = internalCompanyList.stream().map(i->i.getId()).collect(Collectors.toList()); List<Retention> retentionList = retentionMapper.selectList( new QueryWrapper<Retention>().lambda() + .eq(Retention::getIsdeleted,Constants.ZERO) .eq(Retention::getType,Constants.TWO) .in(Retention::getCompanyId,internalCompanyIds) ); -- Gitblit v1.9.3