| | |
| | | import cn.hutool.core.lang.Validator; |
| | | 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.dao.business.vo.VisitEventCountVO; |
| | | import com.doumee.service.business.third.model.PageData; |
| | | import com.doumee.service.business.third.model.PageWrap; |
| | | import com.doumee.core.utils.Constants; |
| | | import com.doumee.core.utils.Utils; |
| | | import com.doumee.dao.admin.request.VisitEventQuery; |
| | | import com.doumee.dao.admin.response.DeviceEventDTO; |
| | | import com.doumee.dao.admin.response.VisitEventDTO; |
| | | import com.doumee.dao.business.VisitEventMapper; |
| | | import com.doumee.dao.business.join.VisitEventJoinMapper; |
| | | 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.VisitEventVo; |
| | | import com.doumee.service.business.VisitEventService; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; |
| | |
| | | if (pageWrap.getModel().getIdNo() != null) { |
| | | queryWrapper.lambda().eq(VisitEvent::getIdNo, pageWrap.getModel().getIdNo()); |
| | | } |
| | | if (pageWrap.getModel().getInOrOut() != null) { |
| | | queryWrapper.lambda().eq(VisitEvent::getInOrOut, pageWrap.getModel().getInOrOut()); |
| | | } |
| | | if (pageWrap.getModel().getBeVisitedPersonName() != null) { |
| | | queryWrapper.lambda().eq(VisitEvent::getBeVisitedPersonName, pageWrap.getModel().getBeVisitedPersonName()); |
| | | } |
| | |
| | | } |
| | | return PageData.from(visitEventDTOIPage); |
| | | } |
| | | |
| | | @Override |
| | | public VisitEventCountVO countNum(VisitEvent model){ |
| | | VisitEventCountVO data = new VisitEventCountVO(); |
| | | data.setEventNum(0l); |
| | | data.setVisitorNum(0l); |
| | | Long count = visitEventJoinMapper.selectCount(new QueryWrapper<VisitEvent>().lambda() |
| | | .ge(StringUtils.isNotBlank(model.getStartTime()), VisitEvent::getCreateDate, model.getStartTime()) |
| | | .le(StringUtils.isNotBlank(model.getEndTime()), VisitEvent::getCreateDate,model.getEndTime()) |
| | | .eq(VisitEvent::getInOrOut,Constants.ZERO) |
| | | .isNotNull(VisitEvent::getVisitorId) |
| | | .eq(VisitEvent::getEventType,HKConstants.EventTypes.VISIT_SIGN_ICCM_PASS.getKey()) |
| | | ); |
| | | if(count!=null){ |
| | | data.setEventNum(count); |
| | | } |
| | | Long count1 = visitEventJoinMapper.selectCount(new QueryWrapper<VisitEvent>().lambda() |
| | | .ge(StringUtils.isNotBlank(model.getStartTime()),VisitEvent::getCreateDate, model.getStartTime()) |
| | | .le(StringUtils.isNotBlank(model.getEndTime()), VisitEvent::getCreateDate,model.getEndTime()) |
| | | .eq( VisitEvent::getIsdeleted,Constants.ZERO) |
| | | .eq( VisitEvent::getInOrOut,Constants.ZERO) |
| | | .isNotNull(VisitEvent::getVisitorId) |
| | | .eq(VisitEvent::getEventType,HKConstants.EventTypes.VISIT_SIGN_ICCM_PASS.getKey()) |
| | | .groupBy(VisitEvent::getVisitorId) |
| | | ); |
| | | if(count1!=null){ |
| | | data.setVisitorNum(count); |
| | | } |
| | | return data; |
| | | } |
| | | @Override |
| | | public List<VisitEvent> findPageExcel(PageWrap<VisitEvent> pageWrap) { |
| | | IPage<VisitEvent> visitEventExcel = getDataInfo(pageWrap); |
| | |
| | | .eq(Objects.nonNull(pageWrap.getModel().getEventType()), |
| | | VisitEvent::getEventType, |
| | | pageWrap.getModel().getEventType()) |
| | | .eq(Objects.nonNull(pageWrap.getModel().getInOrOut()), |
| | | VisitEvent::getInOrOut, |
| | | pageWrap.getModel().getInOrOut()) |
| | | .ge(StringUtils.isNotBlank(pageWrap.getModel().getStartTime()), |
| | | VisitEvent::getCreateDate, |
| | | pageWrap.getModel().getStartTime()) |