From 9f2c35bcddcd835efc25ed53d3a9c8816781bb5f Mon Sep 17 00:00:00 2001
From: k94314517 <8417338+k94314517@user.noreply.gitee.com>
Date: 星期二, 27 二月 2024 14:36:42 +0800
Subject: [PATCH] ERP接口

---
 server/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitsServiceImpl.java |   51 ++++++++++++++++++++++++++++++++++-----------------
 1 files changed, 34 insertions(+), 17 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 c6a99d6..a2a4137 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
@@ -123,10 +123,11 @@
         //鏅�氳瀹�
         visits.setType(Constants.ONE);
         //闅忚浜哄憳鏁伴噺
-        visits.setMemberNum(CollectionUtils.isNotEmpty(visits.getWithUserList())?visits.getWithUserList().size()+1:1);
+        visits.setMemberNum(CollectionUtils.isNotEmpty(visits.getWithUserList())?visits.getWithUserList().size():0);
         //璁垮淇℃伅(浣跨敤韬唤璇佸彿鏌ヨ鏄惁宸插瓨鍦ㄦ敼鏅�氳瀹紝娌℃湁鍒欐柊澧烇紝瀛樺湪鍒欐洿鏂皁penid绛変俊鎭�),鍖呮嫭闅忚浜哄憳鏍¢獙鍜屽鐞�
         Member member =dealMemberAndVisits(visits);
         visits.setMemberId(member.getId());
+        visits.setVisitType(Integer.valueOf(systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.MDJ_VISIT_REQUIRED).getCode()));
         //鍒濆鍖栬瀹俊鎭�
         initVisitInfo(visits,date);
         visitsMapper.insert(visits);
@@ -548,6 +549,8 @@
                 v.setHkStatus(Constants.ZERO);
                 v.setReason(visits.getReason());
                 v.setDoors(visits.getDoors());
+                v.setType(visits.getType());
+                v.setVisitType(visits.getVisitType());
                 v.setStatus(Constants.VisitStatus.submitCheck);
             }
             //鎵归噺鎻掑叆鏁版嵁
@@ -684,7 +687,7 @@
 
     private Member getMemberListParam(String cardno, Visits visits, List<Member> addList, List<Member> editList) {
         if(!StringUtils.isNotBlank(visits.getCarNos())
-//                &&!Constants.checkCarNo(visits.getCarNos())
+                &&Objects.isNull(Constants.getVehiclePlateNo(visits.getCarNos()))
         ){
             throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "瀵逛笉璧凤紝杞︾墝鍙枫��"+visits.getCarNos()+"銆戜笉鍚堟硶锛岃鏍稿疄鍚庨噸璇晘");
         }
@@ -730,7 +733,9 @@
                 throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "瀵逛笉璧凤紝璇ヨ韩浠借瘉鍙疯绂佹璁块棶鐢宠锛屽鏈夌枒闂紝璇疯仈绯绘偍鐨勬嫓璁夸汉杩涜鏍稿疄");
             }
             //鏍告煡棰勭害鐢ㄦ埛鏄惁瀛樺湪鏈绂荤殑棰勭害璁板綍
-            isExsitNoOutVisisRecord(member);
+
+//            isExsitNoOutVisisRecord(member);
+
             member.setFaceImg(visits.getFaceImg());
             member.setImgurl(StringUtils.isNotBlank(visits.getImgurl())?visits.getImgurl():null);
             member.setEditDate(visits.getCreateDate());
@@ -751,9 +756,10 @@
         }
         //鏍规嵁鎵嬫満鍙峰拰韬唤璇佸彿鐮佹煡璇� 褰撳墠棰勭害鐨勬椂闂存槸鍚︿笌鍏朵粬棰勭害璁板綍鏈夊啿绐�
         if (visitsMapper.selectCount(new QueryWrapper<Visits>().lambda()
-                        .notIn(Visits::getStatus,Constants.VisitStatus.cancel,Constants.VisitStatus.cancel,Constants.VisitStatus.noPass,Constants.VisitStatus.xfFail)
-                .and(ms -> ms.eq(Visits::getPhone, visits.getPhone())
-                        .or().eq(Visits::getIdcardDecode, Constants.getTuominStr(cardno)))
+                        .notIn(Visits::getStatus,Constants.VisitStatus.cancel,Constants.VisitStatus.noPass,Constants.VisitStatus.xfFail)
+//                .and(ms -> ms.eq(Visits::getPhone, visits.getPhone())
+//                        .or().eq(Visits::getIdcardDecode, Constants.getTuominStr(cardno)))
+                .eq(Visits::getIdcardDecode, Constants.getTuominStr(cardno))
                 .and(ms -> ms.apply(" visits.STARTTIME <= '" + DateUtil.DateToStr(visits.getStarttime(),"yyyy-MM-dd HH:mm:ss") + "' and visits.ENDTIME >= '" + DateUtil.DateToStr(visits.getStarttime(),"yyyy-MM-dd HH:mm:ss") + "' ")
                         .or().apply(" visits.STARTTIME <= '" + DateUtil.DateToStr(visits.getEndtime(),"yyyy-MM-dd HH:mm:ss") + "' and visits.ENDTIME >= '" + DateUtil.DateToStr(visits.getEndtime(),"yyyy-MM-dd HH:mm:ss") + "' ")
                 )) > Constants.ZERO) {
@@ -978,6 +984,7 @@
         MPJLambdaWrapper<Visits> queryWrapper = new MPJLambdaWrapper<>();
 
         queryWrapper.selectAll(Visits.class);
+        queryWrapper.select("  ( select count(distinct(v.CAR_NOS)) from visits v where v.PARENT_ID = t.ID and v.CAR_NOS is not null  and v.CAR_NOS != ''  and v.CAR_NOS != t.CAR_NOS ) as carNum  ");
         queryWrapper.selectAs(Member::getName,Visits::getReceptMemberName);
         queryWrapper.selectAs(Company::getName,Visits::getReceptMemberDepartment);
         queryWrapper.leftJoin(Member.class,Member::getId,Visits::getReceptMemberId);
@@ -993,6 +1000,12 @@
         queryWrapper.isNull(Visits::getParentId);
         queryWrapper.orderByDesc(Visits::getCreateDate);
         IPage<Visits> result = visitsJoinMapper.selectJoinPage(page, Visits.class,queryWrapper);
+
+        for (Visits visits:result.getRecords()) {
+            if(StringUtils.isNotBlank(visits.getCarNos())){
+                visits.setCarNum(visits.getCarNum() + Constants.ONE);
+            }
+        }
         return PageData.from(result);
     }
 
@@ -1005,12 +1018,12 @@
 
     @Override
     public PageData<Visits> retentionPage(PageWrap<Visits> pageWrap) {
+        String code= systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.TIMEOUT_WARNING).getCode();
         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.select("TIMESTAMPDIFF( MINUTE, NOW(), t.OUT_DATE) AS timeOut");
         queryWrapper.selectAs(Member::getType,Visits::getMemberType);
         queryWrapper.selectAs(Company::getName,Visits::getReceptMemberDepartment);
         queryWrapper.leftJoin(Member.class,Member::getId,Visits::getReceptMemberId);
@@ -1018,6 +1031,9 @@
         queryWrapper.leftJoin(" member m on m.id=t.MEMBER_ID");
 
         queryWrapper.eq(Objects.nonNull(pageWrap.getModel().getLevelStatus()),Visits::getStatus,Constants.VisitStatus.signin);
+
+        queryWrapper.apply(Objects.nonNull(pageWrap.getModel().getLevelStatus())," TIMESTAMPDIFF( MINUTE, NOW(), t.OUT_DATE) <= "+code+"  ");
+
         queryWrapper.ne("m.type ",Constants.TWO);
         queryWrapper.eq(Visits::getIsdeleted,Constants.ZERO);
         queryWrapper.eq(Objects.nonNull(pageWrap.getModel().getType()),Visits::getType,pageWrap.getModel().getType());
@@ -1026,20 +1042,20 @@
                 .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.isNull(!Objects.nonNull(pageWrap.getModel().getLevelStatus()),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);
+                if(s.getStatus().equals(Constants.VisitStatus.signin)){
+                    if(s.getTimeOut()<=Integer.valueOf(code)&&s.getTimeOut()>=0){
+                        s.setOutStatus(Constants.TWO);
+                    }else if(s.getTimeOut()>Constants.ZERO){
+                        s.setOutStatus(Constants.ZERO);
+                    }else{
+                        s.setOutStatus(Constants.ONE);
+                    }
                 }
-
             });
         }
 
@@ -1061,6 +1077,7 @@
         VisitDetailVO visitDetailVO = new VisitDetailVO();
         visitDetailVO.setStatus(visits.getStatus());
         visitDetailVO.setCarNos(visits.getCarNos());
+        visitDetailVO.setPhone(visits.getPhone());
         visitDetailVO.setVisitUserName(member.getName());
         visitDetailVO.setVisitReason(visits.getReason());
         visitDetailVO.setVisitTime(DateUtil.DateToStr(visits.getStarttime(),"yyyy-MM-dd HH:mm") + " 鑷� " + DateUtil.DateToStr(visits.getEndtime(),"yyyy-MM-dd HH:mm") );

--
Gitblit v1.9.3