From 68ae0e6a2dc077d8b85187ee3dbee4b87a6c9b90 Mon Sep 17 00:00:00 2001
From: k94314517 <8417338+k94314517@user.noreply.gitee.com>
Date: 星期四, 21 三月 2024 18:02:16 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'
---
server/dmvisit_service/src/main/java/com/doumee/service/business/impl/CarEventServiceImpl.java | 171 +++++++++++++++++++++++++++++++++++---------------------
1 files changed, 107 insertions(+), 64 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 0ebafb6..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
@@ -10,11 +10,14 @@
import com.doumee.core.utils.Utils;
import com.doumee.dao.admin.request.VisitEventQuery;
import com.doumee.dao.admin.response.CarEventDTO;
+import com.doumee.dao.admin.response.DeviceEventDTO;
+import com.doumee.dao.admin.response.VisitEventDTO;
import com.doumee.dao.business.CarEventMapper;
import com.doumee.dao.business.join.CarEventJoinMapper;
import com.doumee.dao.business.model.*;
import com.doumee.dao.system.SystemDictDataMapper;
import com.doumee.dao.system.model.SystemDictData;
+import com.doumee.dao.system.vo.CarEventVo;
import com.doumee.service.business.CarEventService;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
@@ -26,10 +29,7 @@
import org.springframework.stereotype.Service;
import org.springframework.util.CollectionUtils;
-import java.util.Arrays;
-import java.util.List;
-import java.util.Map;
-import java.util.Objects;
+import java.util.*;
import java.util.function.Function;
import java.util.stream.Collectors;
@@ -276,68 +276,111 @@
@Override
public PageData<CarEventDTO> findVisitCarPage(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<VisitEvent> 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)
- .leftJoin(Company.class,Company::getId,Member::getCompanyId);
- queryWrapper.selectAll(CarEvent.class)
- .selectAs(Member::getType,CarEventDTO::getPersonType)
- .selectAs(Member::getPhone,CarEventDTO::getPersonPhone)
- .selectAs(Member::getIdcardDecode,CarEventDTO::getPersonIdcardDecode)
- .selectAs(Member::getName,CarEventDTO::getPersonName)
- .selectAs(Company::getName,CarEventDTO::getPersonCompanyName);
- 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())
- .like(StringUtils.isNotBlank(pageWrap.getModel().getCompanyName()),
- Company::getName,
- pageWrap.getModel().getCompanyName())
- .eq(StringUtils.isNotBlank(pageWrap.getModel().getMemberType()),
- Member::getType,
- pageWrap.getModel().getMemberType())
- .eq(Objects.nonNull(pageWrap.getModel().getEventType()),
- CarEvent::getEventType,
- pageWrap.getModel().getEventType())
- .ge(Objects.nonNull(pageWrap.getModel().getStartTime()),
- CarEvent::getCreateDate, pageWrap.getModel().getStartTime())
- .le(Objects.nonNull(pageWrap.getModel().getEndTime()),
- CarEvent::getCreateDate, pageWrap.getModel().getEndTime());
- IPage<CarEventDTO> carEventDTOIPage = carEventJoinMapper.selectJoinPage(page, CarEventDTO.class, queryWrapper);
+ IPage<CarEventDTO> carEventDTOIPage = getDataInfo(pageWrap);
if(null != carEventDTOIPage && carEventDTOIPage.getRecords().size() > 0) {
- List<String> codes = Arrays.asList(Constants.FTP_RESOURCE_PATH,Constants.CAR_EVENT_IMG);
- List<SystemDictData> list = systemDictDataMapper.list(codes);
- Map<String,SystemDictData> dataMap = list.stream().collect(Collectors.toMap(SystemDictData::getLabel, Function.identity()));
- carEventDTOIPage.getRecords().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());
- }
- });
+ carEventDTOIPage.setRecords(newCarEventDTO(carEventDTOIPage.getRecords()));
}
return PageData.from(carEventDTOIPage);
}
+
+ @Override
+ public List<CarEventVo> findPageExcel(PageWrap<CarEvent> 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();
+ vo.setEventTypeName(HKConstants.EventTypes.getName(obj.getEventType())) ;
+ if(null != obj.getPersonType()) {
+ if(Constants.ZERO == obj.getPersonType()){
+ vo.setTypeName(Constants.Status.LW_FK.getDes());
+ }else if(Constants.ONE == obj.getPersonType()) {
+ vo.setTypeName(Constants.Status.PT_FK.getDes());
+ }else {
+ vo.setTypeName(Constants.Status.NB_FK.getDes());
+ }
+ }else {
+ vo.setTypeName("");
+ }
+ vo.setPlateNos(obj.getPlateNos());
+ vo.setPersonName(obj.getPersonName());
+ vo.setPersonPhone(obj.getPersonPhone());
+ vo.setPersonCompanyName(obj.getPersonCompanyName());
+ vo.setParkName(obj.getParkName());
+ vo.setGateName(obj.getGateName());
+ vo.setInoutType(obj.getInoutType());
+ vo.setHappenTime(obj.getHappenTime());
+ newDataList.add(vo);
+ });
+ }
+ return newDataList;
+ }
+
+ private IPage<CarEventDTO> getDataInfo(PageWrap<CarEvent> pageWrap) {
+
+ IPage<CarEvent> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
+ MPJLambdaWrapper<CarEvent> queryWrapper = new MPJLambdaWrapper<>();
+ Utils.MP.blankToNull(pageWrap.getModel());
+
+ queryWrapper
+ .leftJoin(Member.class,Member::getId,CarEvent::getMemberId)
+ .leftJoin(Company.class,Company::getId,Member::getCompanyId);
+ queryWrapper.selectAll(CarEvent.class)
+ .selectAs(Member::getType,CarEventDTO::getPersonType)
+ .selectAs(Member::getPhone,CarEventDTO::getPersonPhone)
+ .selectAs(Member::getIdcardDecode,CarEventDTO::getPersonIdcardDecode)
+ .selectAs(Member::getName,CarEventDTO::getPersonName)
+ .selectAs(Company::getName,CarEventDTO::getPersonCompanyName);
+
+ queryWrapper
+ .like(StringUtils.isNotBlank(pageWrap.getModel().getPlateNos()),
+ CarEvent::getPlateNos,
+ pageWrap.getModel().getPlateNos())
+
+ .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( pageWrap.getModel().getMemberType()!=null,
+ Member::getType,
+ pageWrap.getModel().getMemberType())
+ .eq(Objects.nonNull(pageWrap.getModel().getEventType()),
+ CarEvent::getEventType,
+ pageWrap.getModel().getEventType())
+ .ge(Objects.nonNull(pageWrap.getModel().getStartTime()),
+ CarEvent::getCreateDate, pageWrap.getModel().getStartTime())
+ .le(Objects.nonNull(pageWrap.getModel().getEndTime()),
+ CarEvent::getCreateDate, pageWrap.getModel().getEndTime())
+ .orderByDesc(CarEvent::getCreateDate);
+ IPage<CarEventDTO> carEventDTOIPage = carEventJoinMapper.selectJoinPage(page, CarEventDTO.class, queryWrapper);
+ return carEventDTOIPage;
+ }
+
+ private List<CarEventDTO> newCarEventDTO(List<CarEventDTO> newCarEventDTOList) {
+ List<String> codes = Arrays.asList(Constants.FTP_RESOURCE_PATH,Constants.CAR_EVENT_IMG);
+ List<SystemDictData> list = systemDictDataMapper.list(codes);
+ Map<String,SystemDictData> dataMap = list.stream().collect(Collectors.toMap(SystemDictData::getLabel, Function.identity()));
+ List<CarEventDTO> newDataList = new ArrayList<>();
+ newCarEventDTOList.stream().forEach(obj->{
+ 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