From f24ad52eb311f7592fc5f8b9a66a494284813d99 Mon Sep 17 00:00:00 2001 From: k94314517 <8417338+k94314517@user.noreply.gitee.com> Date: 星期二, 19 三月 2024 15:38:52 +0800 Subject: [PATCH] ERP接口 --- server/dmvisit_service/src/main/java/com/doumee/service/business/impl/CarEventServiceImpl.java | 67 ++++++++++++++------------------- 1 files changed, 28 insertions(+), 39 deletions(-) diff --git a/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/CarEventServiceImpl.java b/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/CarEventServiceImpl.java index 12f16d6..76454bb 100644 --- a/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/CarEventServiceImpl.java +++ b/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/CarEventServiceImpl.java @@ -283,22 +283,14 @@ return PageData.from(carEventDTOIPage); } - + @Override public List<CarEventVo> findPageExcel(PageWrap<CarEvent> pageWrap) { - IPage<CarEventDTO> carEventExcel= getDataInfo(pageWrap); + IPage<CarEventDTO> carEventExcel = getDataInfo(pageWrap); List<CarEventVo> newDataList = new ArrayList<>(); if(null != carEventExcel && carEventExcel.getRecords().size() > 0) { carEventExcel.getRecords().stream().forEach(obj->{ CarEventVo vo = new CarEventVo(); - if(Constants.formatIntegerNum(obj.getEventType()) == HKConstants.EventTypes.PARK_LINE_IN.getKey()){ - vo.setEventTypeName(HKConstants.EventTypes.PARK_LINE_IN.getName()); - }else if(Constants.formatIntegerNum(obj.getEventType()) == HKConstants.EventTypes.PARK_PASS_IN.getKey()){ - vo.setEventTypeName(HKConstants.EventTypes.PARK_PASS_IN.getName()); - }else if(Constants.formatIntegerNum(obj.getEventType()) == HKConstants.EventTypes.PARK_LINE_OUT.getKey()){ - vo.setEventTypeName(HKConstants.EventTypes.PARK_LINE_OUT.getName()); - }else{ - vo.setEventTypeName(HKConstants.EventTypes.PARK_PASS_OUT.getName()); - } + vo.setEventTypeName(HKConstants.EventTypes.getName(obj.getEventType())) ; if(null != obj.getPersonType()) { if(Constants.ZERO == obj.getPersonType()){ vo.setTypeName(Constants.Status.LW_FK.getDes()); @@ -325,19 +317,13 @@ } private IPage<CarEventDTO> getDataInfo(PageWrap<CarEvent> pageWrap) { - //鏄惁鏄暟瀛� - boolean number = Validator.isNumber(pageWrap.getModel().getKeyWords()); - //鏄惁鍖呭惈涓枃 - boolean b = Validator.hasChinese(pageWrap.getModel().getKeyWords()); - //鏄惁鍖呭惈鑻辨枃 - boolean hasWord = ReUtil.contains(PatternPool.WORD, pageWrap.getModel().getKeyWords()); IPage<CarEvent> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); MPJLambdaWrapper<CarEvent> queryWrapper = new MPJLambdaWrapper<>(); Utils.MP.blankToNull(pageWrap.getModel()); - queryWrapper.leftJoin(Cars.class,Cars::getCode,CarEvent::getPlateNos) - .leftJoin(Member.class,Member::getId,Cars::getMemberId) + queryWrapper + .leftJoin(Member.class,Member::getId,CarEvent::getMemberId) .leftJoin(Company.class,Company::getId,Member::getCompanyId); queryWrapper.selectAll(CarEvent.class) .selectAs(Member::getType,CarEventDTO::getPersonType) @@ -345,19 +331,18 @@ .selectAs(Member::getIdcardDecode,CarEventDTO::getPersonIdcardDecode) .selectAs(Member::getName,CarEventDTO::getPersonName) .selectAs(Company::getName,CarEventDTO::getPersonCompanyName); - queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getPlateNos()), + + queryWrapper + .like(StringUtils.isNotBlank(pageWrap.getModel().getPlateNos()), CarEvent::getPlateNos, pageWrap.getModel().getPlateNos()) - .like(number, - Member::getPhone, - pageWrap.getModel().getKeyWords()) - .like((b || hasWord), - Member::getPhone, - pageWrap.getModel().getKeyWords()) + + .and(StringUtils.isNotBlank(pageWrap.getModel().getKeyWords()),i->i.like(Member::getPhone,pageWrap.getModel().getKeyWords()).or().like(Member::getPhone, + pageWrap.getModel().getKeyWords())) .like(StringUtils.isNotBlank(pageWrap.getModel().getCompanyName()), Company::getName, pageWrap.getModel().getCompanyName()) - .eq(StringUtils.isNotBlank(pageWrap.getModel().getMemberType()), + .eq( pageWrap.getModel().getMemberType()!=null, Member::getType, pageWrap.getModel().getMemberType()) .eq(Objects.nonNull(pageWrap.getModel().getEventType()), @@ -366,7 +351,8 @@ .ge(Objects.nonNull(pageWrap.getModel().getStartTime()), CarEvent::getCreateDate, pageWrap.getModel().getStartTime()) .le(Objects.nonNull(pageWrap.getModel().getEndTime()), - CarEvent::getCreateDate, pageWrap.getModel().getEndTime()); + CarEvent::getCreateDate, pageWrap.getModel().getEndTime()) + .orderByDesc(CarEvent::getCreateDate); IPage<CarEventDTO> carEventDTOIPage = carEventJoinMapper.selectJoinPage(page, CarEventDTO.class, queryWrapper); return carEventDTOIPage; } @@ -377,18 +363,21 @@ Map<String,SystemDictData> dataMap = list.stream().collect(Collectors.toMap(SystemDictData::getLabel, Function.identity())); List<CarEventDTO> newDataList = new ArrayList<>(); newCarEventDTOList.stream().forEach(obj->{ - obj.setVehiclePicUrl(dataMap.get(Constants.FTP_RESOURCE_PATH).getCode() - +dataMap.get(Constants.CAR_EVENT_IMG).getCode() - +obj.getVehiclePicUrl()); - if(Constants.formatIntegerNum(obj.getEventType()) == HKConstants.EventTypes.PARK_LINE_IN.getKey()){ - obj.setEventTypeName(HKConstants.EventTypes.PARK_LINE_IN.getName()); - }else if(Constants.formatIntegerNum(obj.getEventType()) == HKConstants.EventTypes.PARK_PASS_IN.getKey()){ - obj.setEventTypeName(HKConstants.EventTypes.PARK_PASS_IN.getName()); - }else if(Constants.formatIntegerNum(obj.getEventType()) == HKConstants.EventTypes.PARK_LINE_OUT.getKey()){ - obj.setEventTypeName(HKConstants.EventTypes.PARK_LINE_OUT.getName()); - }else{ - obj.setEventTypeName(HKConstants.EventTypes.PARK_PASS_OUT.getName()); + if(obj.getVehiclePicUrl()!=null + && !obj.getVehiclePicUrl().startsWith(HKConstants.IMG_INDEX) + && !obj.getVehiclePicUrl().startsWith(HKConstants.IMG_INDEX_ERROR)){ + obj.setVehiclePicUrl(dataMap.get(Constants.FTP_RESOURCE_PATH).getCode() + +dataMap.get(Constants.CAR_EVENT_IMG).getCode() + +obj.getVehiclePicUrl()); } + if(obj.getPlatePicUrl()!=null + && !obj.getVehiclePicUrl().startsWith(HKConstants.IMG_INDEX) + && !obj.getVehiclePicUrl().startsWith(HKConstants.IMG_INDEX_ERROR)){ + obj.setPlatePicUrl(dataMap.get(Constants.FTP_RESOURCE_PATH).getCode() + +dataMap.get(Constants.CAR_EVENT_IMG).getCode() + +obj.getPlatePicUrl()); + } + obj.setEventTypeName(HKConstants.EventTypes.getName(obj.getEventType()) ); newDataList.add(obj); }); return newDataList; -- Gitblit v1.9.3