| | |
| | | import cn.hutool.core.lang.Validator; |
| | | import cn.hutool.core.util.PhoneUtil; |
| | | import cn.hutool.core.util.ReUtil; |
| | | import com.doumee.core.haikang.model.HKConstants; |
| | | import com.doumee.core.model.PageData; |
| | | import com.doumee.core.model.PageWrap; |
| | | import com.doumee.core.utils.Constants; |
| | | import com.doumee.core.utils.Utils; |
| | | import com.doumee.dao.admin.request.DeviceEventQuery; |
| | | import com.doumee.dao.admin.response.DeviceEventDTO; |
| | | import com.doumee.dao.business.DeviceEventMapper; |
| | | import com.doumee.dao.business.join.DeviceEventJoinMapper; |
| | | import com.doumee.dao.business.model.Company; |
| | | import com.doumee.dao.business.model.Device; |
| | | import com.doumee.dao.business.model.DeviceEvent; |
| | | import com.doumee.dao.business.model.Member; |
| | | import com.doumee.dao.system.SystemDictDataMapper; |
| | | import com.doumee.dao.system.model.SystemDictData; |
| | | import com.doumee.dao.system.vo.SystemDictDataListVO; |
| | | import com.doumee.service.business.DeviceEventService; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.github.yulichang.wrapper.MPJLambdaWrapper; |
| | | import com.sun.org.apache.xerces.internal.xs.StringList; |
| | | import org.apache.commons.lang3.StringUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | import org.springframework.util.CollectionUtils; |
| | | |
| | | import java.util.List; |
| | | import java.util.Objects; |
| | | import java.util.*; |
| | | import java.util.function.Function; |
| | | import java.util.stream.Collectors; |
| | | |
| | | /** |
| | | * 门禁事件推送记录表Service实现 |
| | |
| | | |
| | | @Autowired |
| | | private DeviceEventJoinMapper deviceEventJoinMapper; |
| | | |
| | | @Autowired |
| | | private SystemDictDataMapper systemDictDataMapper; |
| | | |
| | | @Override |
| | | public Integer create(DeviceEvent deviceEvent) { |
| | |
| | | if (pageWrap.getModel().getExtEventRoleID() != null) { |
| | | queryWrapper.lambda().eq(DeviceEvent::getExtEventRoleID, pageWrap.getModel().getExtEventRoleID()); |
| | | } |
| | | if (pageWrap.getModel().getExtEventSubDevID() != null) { |
| | | queryWrapper.lambda().eq(DeviceEvent::getExtEventSubDevID, pageWrap.getModel().getExtEventSubDevID()); |
| | | if (pageWrap.getModel().getExtEventEubDevID() != null) { |
| | | queryWrapper.lambda().eq(DeviceEvent::getExtEventEubDevID, pageWrap.getModel().getExtEventEubDevID()); |
| | | } |
| | | if (pageWrap.getModel().getExtEventSwipNum() != null) { |
| | | queryWrapper.lambda().eq(DeviceEvent::getExtEventSwipNum, pageWrap.getModel().getExtEventSwipNum()); |
| | | if (pageWrap.getModel().getExtEventEwipNum() != null) { |
| | | queryWrapper.lambda().eq(DeviceEvent::getExtEventEwipNum, pageWrap.getModel().getExtEventEwipNum()); |
| | | } |
| | | if (pageWrap.getModel().getExtEventType() != null) { |
| | | queryWrapper.lambda().eq(DeviceEvent::getExtEventType, pageWrap.getModel().getExtEventType()); |
| | |
| | | } |
| | | |
| | | @Override |
| | | public PageData<DeviceEventDTO> findDeviceEventDTOPage(PageWrap<DeviceEventQuery> pageWrap) { |
| | | public PageData<DeviceEventDTO> findDeviceEventDTOPage(PageWrap<DeviceEvent> pageWrap) { |
| | | |
| | | IPage<DeviceEvent> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); |
| | | MPJLambdaWrapper<DeviceEvent> queryWrapper = new MPJLambdaWrapper<>(); |
| | |
| | | boolean b = Validator.hasChinese(pageWrap.getModel().getKeyWords()); |
| | | //是否包含英文 |
| | | boolean hasWord = ReUtil.contains(PatternPool.WORD, pageWrap.getModel().getKeyWords()); |
| | | queryWrapper.leftJoin(Member.class,Member::getId,DeviceEvent::getExtEventPersonNo) |
| | | queryWrapper.leftJoin(Member.class,Member::getHkId,DeviceEvent::getExtEventPersonNo) |
| | | .leftJoin(Company.class,Company::getId,Member::getCompanyId) |
| | | .leftJoin(Device.class,Device::getHkId,DeviceEvent::getSrcParentIndex) |
| | | .selectAll(DeviceEvent.class) |
| | | .selectAs(Member::getName,DeviceEventDTO::getPersonName) |
| | | .selectAs(Member::getType,DeviceEventDTO::getPersonType) |
| | | .selectAs(Member::getPhone,DeviceEventDTO::getPersonPhone) |
| | | .selectAs(Member::getIdcardDecode,DeviceEventDTO::getPersonIdcardDecode) |
| | | .selectAs(Device::getName,DeviceEventDTO::getDevName) |
| | | .selectAs(Company::getName,DeviceEventDTO::getPersonCompanyName); |
| | | queryWrapper.like(number, |
| | | Member::getPhone, |
| | | pageWrap.getModel().getKeyWords()) |
| | | .like((b||hasWord), |
| | | Member::getName, |
| | | pageWrap.getModel().getKeyWords()) |
| | | queryWrapper.like(number, Member::getPhone, pageWrap.getModel().getKeyWords()) |
| | | .like((b||hasWord),Member::getName, pageWrap.getModel().getKeyWords()) |
| | | .eq(StringUtils.isNotBlank(pageWrap.getModel().getPersonType()), |
| | | Member::getType, |
| | | pageWrap.getModel().getPersonType()) |
| | | .eq(StringUtils.isNotBlank(pageWrap.getModel().getEventType()), |
| | | .eq(Objects.nonNull(pageWrap.getModel().getEventType()), |
| | | DeviceEvent::getEventType, |
| | | pageWrap.getModel().getEventType()) |
| | | .ge(Objects.nonNull(pageWrap.getModel().getStartTime()), |
| | | DeviceEvent::getCreateDate, |
| | | Utils.Date.getStart(pageWrap.getModel().getStartTime())) |
| | | .le(Objects.nonNull(pageWrap.getModel().getStartTime()), |
| | | pageWrap.getModel().getStartTime()) |
| | | .le(Objects.nonNull(pageWrap.getModel().getEndTime()), |
| | | DeviceEvent::getCreateDate, |
| | | Utils.Date.getDayEnd(pageWrap.getModel().getEndTime())); |
| | | |
| | | pageWrap.getModel().getEndTime()); |
| | | queryWrapper.orderByDesc(DeviceEvent::getHappenTime); |
| | | IPage<DeviceEventDTO> deviceEventDTOIPage = deviceEventJoinMapper.selectJoinPage(page, DeviceEventDTO.class, queryWrapper); |
| | | if(null != deviceEventDTOIPage && deviceEventDTOIPage.getRecords().size() > 0) { |
| | | deviceEventDTOIPage.setRecords(newDeviceEvent(deviceEventDTOIPage.getRecords())); |
| | | } |
| | | return PageData.from(deviceEventDTOIPage); |
| | | } |
| | | |
| | | // 对图片进行判断处理 |
| | | private List<DeviceEventDTO> newDeviceEvent(List<DeviceEventDTO> DeviceEventDTOList) { |
| | | List<DeviceEventDTO> newDeviceEventDTOS = new ArrayList<>(); |
| | | for (DeviceEventDTO dto:DeviceEventDTOList) { |
| | | if(StringUtils.isNotBlank(dto.getExtEventPictureURL())) { |
| | | String extEventPictureURL = dto.getExtEventPictureURL(); |
| | | // 使用split("/")将URL按照"/"进行分割成多个部分 |
| | | String[] parts = extEventPictureURL.split("\\\\"); |
| | | String newStr = parts[0]; |
| | | boolean number = Validator.isNumber(newStr); |
| | | if(number) { |
| | | List<String> codes = Arrays.asList(Constants.FTP_RESOURCE_PATH,Constants.DEVICE_EVENT_IMG); |
| | | List<SystemDictData> list = systemDictDataMapper.list(codes); |
| | | if(null != list && list.size() > 0) { |
| | | Map<String,SystemDictData> dataMap = list.stream().collect(Collectors.toMap(SystemDictData::getLabel, Function.identity())); |
| | | dto.setExtEventPictureURL(dataMap.get(Constants.FTP_RESOURCE_PATH).getCode() |
| | | +dataMap.get(Constants.DEVICE_EVENT_IMG).getCode() |
| | | +dto.getExtEventPictureURL()); |
| | | } |
| | | }else { |
| | | dto.setExtEventPictureURL(null); |
| | | } |
| | | } |
| | | if(Constants.formatIntegerNum(dto.getEventType()) == HKConstants.EventTypes.DOOR_FACE_AUTH_SUCCESS.getKey()){ |
| | | dto.setEventTypeName(HKConstants.EventTypes.DOOR_FACE_AUTH_SUCCESS.getName()); |
| | | }else if(Constants.formatIntegerNum(dto.getEventType()) == HKConstants.EventTypes.DOOR_FACE_AUTH_FAIL.getKey()){ |
| | | dto.setEventTypeName(HKConstants.EventTypes.DOOR_FACE_AUTH_FAIL.getName()); |
| | | } |
| | | newDeviceEventDTOS.add(dto); |
| | | } |
| | | return newDeviceEventDTOS; |
| | | } |
| | | } |