From 70577a6d6cf2bded29e71dcad11a0c2605193d20 Mon Sep 17 00:00:00 2001
From: lishuai <260038442@qq.com>
Date: 星期二, 26 十二月 2023 10:32:31 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'

---
 server/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitsServiceImpl.java |  328 ++++++++++++++++++++++++++++--------------------------
 1 files changed, 171 insertions(+), 157 deletions(-)

diff --git a/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitsServiceImpl.java b/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitsServiceImpl.java
index c3f0a31..e35fe39 100644
--- a/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitsServiceImpl.java
+++ b/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitsServiceImpl.java
@@ -3,6 +3,11 @@
 import cn.hutool.core.util.IdcardUtil;
 import com.doumee.biz.system.SystemDictDataBiz;
 import com.doumee.core.constants.ResponseStatus;
+import com.doumee.core.erp.ErpConstants;
+import com.doumee.core.erp.ErpTool;
+import com.doumee.core.erp.model.openapi.request.erp.ApproveAddRequest;
+import com.doumee.core.erp.model.openapi.request.erp.UserInfoRequest;
+import com.doumee.core.erp.model.openapi.response.erp.ApproveInfoResponse;
 import com.doumee.core.exception.BusinessException;
 import com.doumee.core.haikang.model.HKConstants;
 import com.doumee.core.haikang.model.HKTools;
@@ -17,30 +22,31 @@
 import com.doumee.core.utils.DESUtil;
 import com.doumee.core.utils.DateUtil;
 import com.doumee.core.utils.Utils;
+import com.doumee.dao.admin.response.MemberInfoDTO;
 import com.doumee.dao.business.DeviceRoleMapper;
 import com.doumee.dao.business.MemberMapper;
 import com.doumee.dao.business.ProblemLogMapper;
 import com.doumee.dao.business.VisitsMapper;
-import com.doumee.dao.business.model.DeviceRole;
-import com.doumee.dao.business.model.Member;
-import com.doumee.dao.business.model.ProblemLog;
-import com.doumee.dao.business.model.Visits;
+import com.doumee.dao.business.join.DeviceJoinMapper;
+import com.doumee.dao.business.join.VisitsJoinMapper;
+import com.doumee.dao.business.model.*;
 import com.doumee.service.business.VisitsService;
 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 io.swagger.models.auth.In;
 import org.apache.commons.lang3.StringUtils;
+import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
 import org.springframework.util.CollectionUtils;
 import org.springframework.util.DigestUtils;
 
-import java.util.ArrayList;
-import java.util.Arrays;
-import java.util.Date;
-import java.util.List;
+import java.util.*;
+import java.util.stream.Collectors;
 
 /**
  * 璁垮鐢宠淇℃伅琛⊿ervice瀹炵幇
@@ -58,9 +64,15 @@
     private ProblemLogMapper problemLogMapper ;
     @Autowired
     private MemberMapper memberMapper ;
+    @Autowired
+    private VisitsJoinMapper visitsJoinMapper;
 
     @Autowired
     private SystemDictDataBiz systemDictDataBiz;
+    @Autowired
+    private DeviceJoinMapper deviceJoinMapper;
+
+
     @Override
     public Integer create(Visits visits) {
         visitsMapper.insert(visits);
@@ -81,7 +93,7 @@
         //鑾峰彇鐢宠鐨勬捣搴疯闂棬绂佺粍淇℃伅
         String[] hkIds = getHkDeviceRoles(visits);
         //妫�楠屾嫓璁夸汉鏄惁鍚堟硶
-        isValideVisitedUser(visits.getReceptMemberId());
+        Member visitMember = isValideVisitedUser(visits.getReceptMemberId());
         if(Constants.equalsInteger(Constants.ZERO, visits.getIdcardType()) &&!IdcardUtil.isValidCard(visits.getIdcardNo())){
             throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "瀵逛笉璧凤紝韬唤璇佸彿鐮佹湁璇紝璇锋牳瀹炲悗閲嶈瘯锛�");
         }
@@ -91,9 +103,9 @@
         //鍒濆鍖栬瀹俊鎭�
         initVisitInfo(visits,date);
         //鍙戣捣ERP瀹℃壒鐢宠
-        String erpid = startSendErpCheck(visits);
-        if(StringUtils.isNotBlank(erpid)){
-            visits.setErpId(erpid);
+        String erpId = startSendErpCheck(visits,visitMember);
+        if(StringUtils.isNotBlank(erpId)){
+            visits.setErpId(erpId);
         }else{
             throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(), "瀵逛笉璧凤紝鍙戣捣鎷滆瀹℃壒鐢宠澶辫触锛�");
         }
@@ -191,7 +203,43 @@
         visits.setCreateDate(date);
     }
 
-    private String startSendErpCheck(Visits visits) {
+    private String startSendErpCheck(Visits visits,Member visitMember) {
+        ApproveAddRequest param = new ApproveAddRequest();
+        List<Visits> withUserVisitsList = visits.getWithUserList();
+        List<UserInfoRequest> withUserList = new ArrayList<>();
+        if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(withUserVisitsList)){
+            for (Visits v:withUserVisitsList) {
+                UserInfoRequest userInfoRequest = new UserInfoRequest();
+                userInfoRequest.setName(v.getName());
+                userInfoRequest.setIdNo(v.getIdcardNo());
+                userInfoRequest.setSex(v.getSex());
+                userInfoRequest.setPhone(v.getPhone());
+                userInfoRequest.setFaceImg(v.getFaceImg());
+                userInfoRequest.setHealthImg(v.getImgurl());
+                withUserList.add(userInfoRequest);
+            }
+            param.setWithUserList(withUserList);
+        }
+        param.setId(visits.getId());
+        param.setBeVisitedUserId(visitMember.getErpId());
+        param.setVisitorWorkUint(visits.getCompanyName());
+        param.setPurpose(visits.getReason());
+        param.setStartTime(DateUtil.getDate(visits.getStarttime(),"yyyy-MM-dd HH:mm:ss"));
+        param.setEndTime(DateUtil.getDate(visits.getEndtime(),"yyyy-MM-dd HH:mm:ss"));
+        if(StringUtils.isNotBlank(visits.getCarNos())){
+            param.setCarNo(Arrays.asList(visits.getCarNos().split(",")));
+        }
+        if(StringUtils.isNotBlank(visits.getDoors())){
+             List<DeviceRole> deviceRoleList = deviceRoleMapper.selectList(new QueryWrapper<DeviceRole>().lambda().in(DeviceRole::getId,Arrays.asList(visits.getDoors().split(","))));
+             if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(deviceRoleList)){
+                 param.setRoleIds(deviceRoleList.stream().map(m->m.getId()).collect(Collectors.toList()));
+                 param.setRoleNames(deviceRoleList.stream().map(m->m.getName()).collect(Collectors.toList()));
+             }
+        }
+        ApproveInfoResponse response = ErpTool.submitApprove(ErpConstants.approveUrl,param);
+        if(!Objects.isNull(response)){
+            return response.getId().toString();
+        }
         return  null;
     }
 
@@ -264,7 +312,7 @@
             member.setOpenid(visits.getOpenid());
             member.setType(Constants.memberType.visitor);
             member.setStatus(Constants.ZERO);
-            member.setSex(visits.getSex());
+            member.setSex(Constants.getSexByCardNo(cardno));
             // 鏂板璁垮璁板綍
             addList.add(member);
         }else{
@@ -281,9 +329,19 @@
             member.setName(visits.getName());
             member.setPhone(visits.getPhone());
             member.setOpenid(visits.getOpenid());
-            member.setSex(visits.getSex());
+            member.setSex(Constants.getSexByCardNo(cardno));
             // 鏇存柊璁垮淇℃伅,
             editList.add(member);
+        }
+        //鏍规嵁鎵嬫満鍙峰拰韬唤璇佸彿鐮佹煡璇� 褰撳墠棰勭害鐨勬椂闂存槸鍚︿笌鍏朵粬棰勭害璁板綍鏈夊啿绐�
+        if (visitsMapper.selectCount(new QueryWrapper<Visits>().lambda()
+                .eq(Visits::getPhone, member.getPhone())
+                .and(ms -> ms.eq(Visits::getPhone, member.getPhone())
+                        .or().eq(Visits::getIdcardDecode, member.getIdcardDecode()))
+                .and(ms -> ms.apply(" visits.STARTTIME <= '" + visits.getStarttime() + "' and visits.ENDTIME >= '" + visits.getStarttime() + "' ")
+                        .or().apply(" visits.STARTTIME <= '" + visits.getEndtime() + "' and visits.ENDTIME >= '" + visits.getEndtime() + "' ")
+                )) > Constants.ZERO) {
+            throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "瀵逛笉璧凤紝鎵嬫満鍙枫��"+member.getPhone()+"銆戞垨韬唤璇併��"+ member.getIdcardDecode() +"銆戝瓨鍦ㄩ绾︽椂闂村啿绐侊紝鏃犳硶鐢宠鍝︼紒");
         }
         return  member;
     }
@@ -301,6 +359,9 @@
         if(v !=null){
             throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "瀵逛笉璧凤紝鎵嬫満鍙枫��"+member.getPhone()+"銆戝瓨鍦ㄦ湭绛剧棰勭害鐢宠锛屼笉鑳介噸澶嶇敵璇峰摝锛�");
         }
+
+
+
     }
 
     private List<Member> isValideWithUsers(List<Visits> withUserList) {
@@ -445,7 +506,38 @@
 
     @Override
     public Visits findById(Integer id) {
-        return visitsMapper.selectById(id);
+
+        MPJLambdaWrapper<Visits> queryWrapper = new MPJLambdaWrapper<>();
+        queryWrapper.selectAll(Visits.class);
+        queryWrapper.selectAs(Member::getName,Visits::getReceptMemberName);
+        queryWrapper.selectAs(Company::getName,Visits::getReceptMemberDepartment);
+        queryWrapper.leftJoin(Member.class,Member::getId,Visits::getReceptMemberId);
+        queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId);
+
+        queryWrapper.eq(Visits::getId,id);
+        Visits result = visitsJoinMapper.selectJoinOne(Visits.class,queryWrapper);
+
+        if(result!=null){
+            if(StringUtils.isNotBlank(result.getDoors())){
+                String[] doorList=result.getDoors().split(",");
+                MPJLambdaWrapper<Device> deviceQuery = new MPJLambdaWrapper<>();
+                deviceQuery.in(Device::getId,doorList);
+                List<Device> deviceList= deviceJoinMapper.selectList(deviceQuery);
+                result.setDeviceList(deviceList);
+            }
+        }
+
+        MPJLambdaWrapper<Visits> visitQuery = new MPJLambdaWrapper<>();
+        visitQuery.selectAll(Visits.class);
+        visitQuery.eq(Visits::getParentId,result.getId());
+        visitQuery.isNotNull(Visits::getParentId);
+        visitQuery.eq(Visits::getIsdeleted,Constants.ZERO);
+        List<Visits> visitsList = visitsJoinMapper.selectList(visitQuery);
+        Visits v = new Visits();
+        BeanUtils.copyProperties(result,v);
+        visitsList.add(0,v);
+        result.setWithUserList(visitsList);
+        return result;
     }
 
     @Override
@@ -463,147 +555,25 @@
     @Override
     public PageData<Visits> findPage(PageWrap<Visits> pageWrap) {
         IPage<Visits> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
-        QueryWrapper<Visits> queryWrapper = new QueryWrapper<>();
-        Utils.MP.blankToNull(pageWrap.getModel());
-        if (pageWrap.getModel().getId() != null) {
-            queryWrapper.lambda().eq(Visits::getId, pageWrap.getModel().getId());
-        }
-        if (pageWrap.getModel().getCreator() != null) {
-            queryWrapper.lambda().eq(Visits::getCreator, pageWrap.getModel().getCreator());
-        }
-        if (pageWrap.getModel().getCreateDate() != null) {
-            queryWrapper.lambda().ge(Visits::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate()));
-            queryWrapper.lambda().le(Visits::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate()));
-        }
-        if (pageWrap.getModel().getEditor() != null) {
-            queryWrapper.lambda().eq(Visits::getEditor, pageWrap.getModel().getEditor());
-        }
-        if (pageWrap.getModel().getEditDate() != null) {
-            queryWrapper.lambda().ge(Visits::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate()));
-            queryWrapper.lambda().le(Visits::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate()));
-        }
-        if (pageWrap.getModel().getIsdeleted() != null) {
-            queryWrapper.lambda().eq(Visits::getIsdeleted, pageWrap.getModel().getIsdeleted());
-        }
-        if (pageWrap.getModel().getRemark() != null) {
-            queryWrapper.lambda().eq(Visits::getRemark, pageWrap.getModel().getRemark());
-        }
-        if (pageWrap.getModel().getMemberId() != null) {
-            queryWrapper.lambda().eq(Visits::getMemberId, pageWrap.getModel().getMemberId());
-        }
-        if (pageWrap.getModel().getCompanyId() != null) {
-            queryWrapper.lambda().eq(Visits::getCompanyId, pageWrap.getModel().getCompanyId());
-        }
-        if (pageWrap.getModel().getFaceImg() != null) {
-            queryWrapper.lambda().eq(Visits::getFaceImg, pageWrap.getModel().getFaceImg());
-        }
-        if (pageWrap.getModel().getImgurl() != null) {
-            queryWrapper.lambda().eq(Visits::getImgurl, pageWrap.getModel().getImgurl());
-        }
-        if (pageWrap.getModel().getType() != null) {
-            queryWrapper.lambda().eq(Visits::getType, pageWrap.getModel().getType());
-        }
-        if (pageWrap.getModel().getName() != null) {
-            queryWrapper.lambda().eq(Visits::getName, pageWrap.getModel().getName());
-        }
-        if (pageWrap.getModel().getBirthday() != null) {
-            queryWrapper.lambda().ge(Visits::getBirthday, Utils.Date.getStart(pageWrap.getModel().getBirthday()));
-            queryWrapper.lambda().le(Visits::getBirthday, Utils.Date.getEnd(pageWrap.getModel().getBirthday()));
-        }
-        if (pageWrap.getModel().getPhone() != null) {
-            queryWrapper.lambda().eq(Visits::getPhone, pageWrap.getModel().getPhone());
-        }
-        if (pageWrap.getModel().getCompanyName() != null) {
-            queryWrapper.lambda().eq(Visits::getCompanyName, pageWrap.getModel().getCompanyName());
-        }
-        if (pageWrap.getModel().getIdcardNo() != null) {
-            queryWrapper.lambda().eq(Visits::getIdcardNo, pageWrap.getModel().getIdcardNo());
-        }
-        if (pageWrap.getModel().getCode() != null) {
-            queryWrapper.lambda().eq(Visits::getCode, pageWrap.getModel().getCode());
-        }
-        if (pageWrap.getModel().getClasses() != null) {
-            queryWrapper.lambda().eq(Visits::getClasses, pageWrap.getModel().getClasses());
-        }
-        if (pageWrap.getModel().getMemberNum() != null) {
-            queryWrapper.lambda().eq(Visits::getMemberNum, pageWrap.getModel().getMemberNum());
-        }
-        if (pageWrap.getModel().getStarttime() != null) {
-            queryWrapper.lambda().ge(Visits::getStarttime, Utils.Date.getStart(pageWrap.getModel().getStarttime()));
-            queryWrapper.lambda().le(Visits::getStarttime, Utils.Date.getEnd(pageWrap.getModel().getStarttime()));
-        }
-        if (pageWrap.getModel().getEndtime() != null) {
-            queryWrapper.lambda().ge(Visits::getEndtime, Utils.Date.getStart(pageWrap.getModel().getEndtime()));
-            queryWrapper.lambda().le(Visits::getEndtime, Utils.Date.getEnd(pageWrap.getModel().getEndtime()));
-        }
-        if (pageWrap.getModel().getReason() != null) {
-            queryWrapper.lambda().eq(Visits::getReason, pageWrap.getModel().getReason());
-        }
-        if (pageWrap.getModel().getDoorSelect() != null) {
-            queryWrapper.lambda().eq(Visits::getDoorSelect, pageWrap.getModel().getDoorSelect());
-        }
-        if (pageWrap.getModel().getDoors() != null) {
-            queryWrapper.lambda().eq(Visits::getDoors, pageWrap.getModel().getDoors());
-        }
-        if (pageWrap.getModel().getReceptMemberId() != null) {
-            queryWrapper.lambda().eq(Visits::getReceptMemberId, pageWrap.getModel().getReceptMemberId());
-        }
-        if (pageWrap.getModel().getStatus() != null) {
-            queryWrapper.lambda().eq(Visits::getStatus, pageWrap.getModel().getStatus());
-        }
-        if (pageWrap.getModel().getCheckorId() != null) {
-            queryWrapper.lambda().eq(Visits::getCheckorId, pageWrap.getModel().getCheckorId());
-        }
-        if (pageWrap.getModel().getCheckDate() != null) {
-            queryWrapper.lambda().ge(Visits::getCheckDate, Utils.Date.getStart(pageWrap.getModel().getCheckDate()));
-            queryWrapper.lambda().le(Visits::getCheckDate, Utils.Date.getEnd(pageWrap.getModel().getCheckDate()));
-        }
-        if (pageWrap.getModel().getCheckInfo() != null) {
-            queryWrapper.lambda().eq(Visits::getCheckInfo, pageWrap.getModel().getCheckInfo());
-        }
-        if (pageWrap.getModel().getEndCheckorId() != null) {
-            queryWrapper.lambda().eq(Visits::getEndCheckorId, pageWrap.getModel().getEndCheckorId());
-        }
-        if (pageWrap.getModel().getEndCheckDate() != null) {
-            queryWrapper.lambda().ge(Visits::getEndCheckDate, Utils.Date.getStart(pageWrap.getModel().getEndCheckDate()));
-            queryWrapper.lambda().le(Visits::getEndCheckDate, Utils.Date.getEnd(pageWrap.getModel().getEndCheckDate()));
-        }
-        if (pageWrap.getModel().getEndCheckInfo() != null) {
-            queryWrapper.lambda().eq(Visits::getEndCheckInfo, pageWrap.getModel().getEndCheckInfo());
-        }
-        if (pageWrap.getModel().getIdcardType() != null) {
-            queryWrapper.lambda().eq(Visits::getIdcardType, pageWrap.getModel().getIdcardType());
-        }
-        if (pageWrap.getModel().getCarNos() != null) {
-            queryWrapper.lambda().eq(Visits::getCarNos, pageWrap.getModel().getCarNos());
-        }
-        if (pageWrap.getModel().getParentId() != null) {
-            queryWrapper.lambda().eq(Visits::getParentId, pageWrap.getModel().getParentId());
-        }
-        if (pageWrap.getModel().getUserAnswerId() != null) {
-            queryWrapper.lambda().eq(Visits::getUserAnswerId, pageWrap.getModel().getUserAnswerId());
-        }
-        if (pageWrap.getModel().getHkId() != null) {
-            queryWrapper.lambda().eq(Visits::getHkId, pageWrap.getModel().getHkId());
-        }
-        if (pageWrap.getModel().getHkStatus() != null) {
-            queryWrapper.lambda().eq(Visits::getHkStatus, pageWrap.getModel().getHkStatus());
-        }
-        if (pageWrap.getModel().getHkDate() != null) {
-            queryWrapper.lambda().ge(Visits::getHkDate, Utils.Date.getStart(pageWrap.getModel().getHkDate()));
-            queryWrapper.lambda().le(Visits::getHkDate, Utils.Date.getEnd(pageWrap.getModel().getHkDate()));
-        }
-        if (pageWrap.getModel().getErpId() != null) {
-            queryWrapper.lambda().eq(Visits::getErpId, pageWrap.getModel().getErpId());
-        }
-        for(PageWrap.SortData sortData: pageWrap.getSorts()) {
-            if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) {
-                queryWrapper.orderByDesc(sortData.getProperty());
-            } else {
-                queryWrapper.orderByAsc(sortData.getProperty());
-            }
-        }
-        return PageData.from(visitsMapper.selectPage(page, queryWrapper));
+        MPJLambdaWrapper<Visits> queryWrapper = new MPJLambdaWrapper<>();
+
+        queryWrapper.selectAll(Visits.class);
+        queryWrapper.selectAs(Member::getName,Visits::getReceptMemberName);
+        queryWrapper.selectAs(Company::getName,Visits::getReceptMemberDepartment);
+        queryWrapper.leftJoin(Member.class,Member::getId,Visits::getReceptMemberId);
+        queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId);
+
+        queryWrapper.eq(Visits::getIsdeleted,Constants.ZERO);
+        queryWrapper.eq(Objects.nonNull(pageWrap.getModel().getType()),Visits::getType,pageWrap.getModel().getType());
+        queryWrapper.and(StringUtils.isNotBlank(pageWrap.getModel().getName()),ms->ms.like(Visits::getPhone,pageWrap.getModel().getName())
+                .or().like(Visits::getPhone,pageWrap.getModel().getName()))
+                .eq(StringUtils.isNotBlank(pageWrap.getModel().getIdcardNo()),Visits::getIdcardNo,StringUtils.isNotBlank(pageWrap.getModel().getIdcardNo()))
+                .eq(StringUtils.isNotBlank(pageWrap.getModel().getCompanyName()),Visits::getCompanyName,pageWrap.getModel().getCompanyName())
+                .eq(Objects.nonNull(pageWrap.getModel().getStatus()),Visits::getStatus,pageWrap.getModel().getStatus());
+        queryWrapper.isNull(Visits::getParentId);
+        queryWrapper.orderByDesc(Visits::getCreateDate);
+        IPage<Visits> result = visitsJoinMapper.selectJoinPage(page, Visits.class,queryWrapper);
+        return PageData.from(result);
     }
 
     @Override
@@ -611,4 +581,48 @@
         QueryWrapper<Visits> wrapper = new QueryWrapper<>(visits);
         return visitsMapper.selectCount(wrapper);
     }
+
+
+    @Override
+    public PageData<Visits> retentionPage(PageWrap<Visits> pageWrap) {
+        IPage<Visits> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
+        MPJLambdaWrapper<Visits> queryWrapper = new MPJLambdaWrapper<>();
+
+        queryWrapper.selectAll(Visits.class);
+        queryWrapper.selectAs(Member::getName,Visits::getReceptMemberName);
+        queryWrapper.select("TIMESTAMPDIFF(MINUTE,t.ENDTIME , NOW()) AS timeOut");
+        queryWrapper.selectAs(Member::getType,Visits::getMemberType);
+        queryWrapper.selectAs(Company::getName,Visits::getReceptMemberDepartment);
+        queryWrapper.leftJoin(Member.class,Member::getId,Visits::getReceptMemberId);
+        queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId);
+        queryWrapper.leftJoin(" member m on m.id=t.MEMBER_ID");
+
+        queryWrapper.ne("m.type ",Constants.TWO);
+        queryWrapper.eq(Visits::getIsdeleted,Constants.ZERO);
+        queryWrapper.eq(Objects.nonNull(pageWrap.getModel().getType()),Visits::getType,pageWrap.getModel().getType());
+        queryWrapper.and(StringUtils.isNotBlank(pageWrap.getModel().getName()),ms->ms.like(Visits::getPhone,pageWrap.getModel().getName())
+                .or().like(Visits::getPhone,pageWrap.getModel().getName()))
+                .eq(StringUtils.isNotBlank(pageWrap.getModel().getIdcardNo()),Visits::getIdcardNo,StringUtils.isNotBlank(pageWrap.getModel().getIdcardNo()))
+                .eq(StringUtils.isNotBlank(pageWrap.getModel().getCompanyName()),Visits::getCompanyName,pageWrap.getModel().getCompanyName())
+                .eq(Objects.nonNull(pageWrap.getModel().getStatus()),Visits::getStatus,pageWrap.getModel().getStatus());
+        queryWrapper.isNull(Visits::getOutDate);
+        queryWrapper.orderByDesc(Visits::getEditDate);
+       String code= systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.TIMEOUT_FREEZE).getCode();
+        IPage<Visits> result = visitsJoinMapper.selectJoinPage(page, Visits.class,queryWrapper);
+        if(result!=null&&result.getRecords()!=null){
+            result.getRecords().stream().forEach(s ->{
+                if(s.getTimeOut()>=Constants.ZERO){
+                    s.setOutStatus(Constants.ONE);
+                }else if(s.getTimeOut()<=Integer.valueOf(code)&&s.getTimeOut()>0){
+                    s.setOutStatus(Constants.TWO);
+                }else{
+                    s.setOutStatus(Constants.ZERO);
+                }
+
+            });
+        }
+
+        return PageData.from(result);
+    }
+
 }

--
Gitblit v1.9.3