From 1c20c8231980a8d4b91688ff8641a06d3b2f68ab Mon Sep 17 00:00:00 2001
From: MrShi <1878285526@qq.com>
Date: 星期二, 14 十月 2025 16:34:22 +0800
Subject: [PATCH] 改bug

---
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitsServiceImpl.java |  573 ++++++++++++++++++++++++++++++++++++++++++++++----------
 1 files changed, 467 insertions(+), 106 deletions(-)

diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitsServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitsServiceImpl.java
index d4a6aa1..d9ab31f 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitsServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitsServiceImpl.java
@@ -13,11 +13,13 @@
 import com.doumee.core.exception.BusinessException;
 import com.doumee.core.haikang.model.HKConstants;
 import com.doumee.core.haikang.model.param.BaseResponse;
+import com.doumee.core.haikang.model.param.request.ParkReservationDelRequest;
 import com.doumee.core.haikang.model.param.request.VisitAppointmentCancelRequest;
 import com.doumee.core.haikang.model.param.request.VisitAppointmentOutRequest;
 import com.doumee.core.haikang.model.param.request.VisitAppointmentRequest;
 import com.doumee.core.haikang.model.param.respose.VisitAppointmentResponse;
 import com.doumee.core.haikang.service.HKService;
+import com.doumee.dao.business.dao.*;
 import com.doumee.service.business.third.model.LoginUserInfo;
 import com.doumee.service.business.third.model.PageData;
 import com.doumee.service.business.third.model.PageWrap;
@@ -27,10 +29,6 @@
 import com.doumee.dao.admin.response.InterestedListVO;
 import com.doumee.dao.admin.response.PCWorkPlatformDataVO;
 import com.doumee.dao.business.*;
-import com.doumee.dao.business.dao.CompanyMapper;
-import com.doumee.dao.business.dao.MemberMapper;
-import com.doumee.dao.business.dao.SmsConfigMapper;
-import com.doumee.dao.business.dao.SmsEmailMapper;
 import com.doumee.dao.business.dto.ResetPasswordDTO;
 import com.doumee.dao.business.join.DeviceJoinMapper;
 import com.doumee.dao.business.join.VisitsJoinMapper;
@@ -60,6 +58,7 @@
 import com.doumee.service.business.third.EmayService;
 import com.github.xiaoymin.knife4j.core.util.CollectionUtils;
 import com.github.yulichang.wrapper.MPJLambdaWrapper;
+import lombok.extern.slf4j.Slf4j;
 import org.apache.commons.lang3.StringUtils;
 import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
@@ -77,6 +76,7 @@
  * @date 2023/11/30 15:33
  */
 @Service
+@Slf4j
 public class VisitsServiceImpl implements VisitsService {
 
     @Autowired
@@ -84,7 +84,11 @@
     @Autowired
     private VisitsJoinMapper visitsMapper;
     @Autowired
+    private UserActionMapper userActionMapper;
+    @Autowired
     private ApproveMapper approveMapper;
+    @Autowired
+    private NoticesJoinMapper noticesJoinMapper;
     @Autowired
     private ApproveParamMapper approveParamMapper;
     @Autowired
@@ -107,6 +111,8 @@
     private ErpTool erpTool;
 
     @Autowired
+    private VisitParkMapper visitParkMapper;
+    @Autowired
     private WxPlatNotice wxPlatNotice;
 
     @Autowired
@@ -120,9 +126,9 @@
     @Autowired
     private ApproveService approveService;
     @Autowired
-    private NoticesJoinMapper noticesJoinMapper;
-    @Autowired
     private InoutDayCountMapper inoutDayCountMapper;
+    @Autowired
+    private InoutRecordMapper inoutRecordMapper;
     @Autowired
     private CarEventMapper carEventMapper;
 
@@ -168,7 +174,7 @@
             if (erpVisitDTO.getEndtime().getTime() <= erpVisitDTO.getStarttime().getTime()) {
                 throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "瀵逛笉璧凤紝棰勭害缁撴潫鏃堕棿蹇呴』澶т簬寮�濮嬫椂闂达紒");
             }
-            if (Constants.equalsInteger(Constants.ZERO, erpVisitDTO.getIdcardType()) && erpVisitDTO.getIdcardNo().length() != 18
+            if (StringUtils.isNotBlank(erpVisitDTO.getIdcardNo()) && Constants.equalsInteger(Constants.ZERO, erpVisitDTO.getIdcardType()) && erpVisitDTO.getIdcardNo().length() != 18
                 //&&!IdcardUtil.isValidCard(visits.getIdcardNo())
             ){
                 throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "瀵逛笉璧凤紝韬唤璇佸彿鐮佹湁璇紝璇锋牳瀹炲悗閲嶈瘯锛�");
@@ -236,9 +242,8 @@
         getHkDeviceRoles(visits,isERP);
         //妫�楠屾嫓璁夸汉鏄惁鍚堟硶
         Member visitMember = isValideVisitedUser(visits.getReceptMemberId());
-        if(Constants.equalsInteger(Constants.ZERO, visits.getIdcardType())
-                &&visits.getIdcardNo().length()!=18
-        ){
+        if(StringUtils.isNotBlank(visits.getIdcardNo()) && Constants.equalsInteger(Constants.ZERO, visits.getIdcardType())
+                &&visits.getIdcardNo().length()!=18 ){
             throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "瀵逛笉璧凤紝韬唤璇佸彿鐮佹湁璇紝璇锋牳瀹炲悗閲嶈瘯锛�");
         }
         Date date = new Date();
@@ -287,7 +292,7 @@
         }else if(dataSyncConfig.getVisitorDataOrigin().equals(Constants.ZERO)){
             visits.setStatus(Constants.VisitStatus.waitCheck);
             visitsMapper.updateById(visits);
-            approveService.createApproveFlow(visits.getType(),visits.getId(),visits.getReceptMemberId());
+            approveService.createApproveFlow(visits.getType(),visits.getId(),visits.getReceptMemberId(),member);
         }else{
             throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(), "瀵逛笉璧凤紝鍙戣捣鎷滆瀹℃壒鐢宠澶辫触锛�");
         }
@@ -299,8 +304,7 @@
             WxPlatNotice wxPlatNotice = new WxPlatNotice();
             wxPlatNotice.sendVisitTemplateNotice(systemDictDataBiz,
                     wxNoticeConfigMapper,visits,
-                    Constants.equalsInteger(visits.getType(),Constants.TWO)?WxPlatConstants.visitReportContent.visitReportUpload:WxPlatConstants.visitContent.visitUpload,
-                    systemDictDataBiz.queryByCode(Constants.WX_PLATFORM,Constants.WX_PLATFORM_ACCESS_TOKEN).getCode(),
+                    Constants.equalsInteger(visits.getType(),Constants.TWO)?WxPlatConstants.visitReportContent.visitReportUpload:WxPlatConstants.visitContent.visitUpload, 
                     Arrays.asList(visits.getOpenid().split(","))
             );
         }
@@ -309,7 +313,6 @@
 
         return visits.getId();
     }
-
 
     @Override
     @Transactional(rollbackFor = {BusinessException.class,Exception.class})
@@ -338,13 +341,12 @@
                 wxPlatNotice.sendVisitTemplateNotice(systemDictDataBiz,
                         wxNoticeConfigMapper,visits,
                         Constants.equalsInteger(visits.getType(),Constants.TWO)?WxPlatConstants.visitReportContent.visitReportUpload:WxPlatConstants.visitContent.visitUpload,
-                        systemDictDataBiz.queryByCode(Constants.WX_PLATFORM,Constants.WX_PLATFORM_ACCESS_TOKEN).getCode(),
                         Arrays.asList(systemUser.getOpenid().split(","))
                 );
             }
         }
 
-        approveService.createApproveFlow(visits.getType(),visits.getId(),visits.getReceptMemberId());
+        approveService.createApproveFlow(visits.getType(),visits.getId(),visits.getReceptMemberId(),null);
         return visits.getId();
     }
 
@@ -413,7 +415,7 @@
             throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀹℃壒璁板綍宸插鐞�!");
         }
         Visits visits = visitsMapper.selectById(approve.getObjId());
-        if(Objects.isNull(visits)){
+        if(Objects.isNull(visits)||Constants.equalsInteger(visits.getIsdeleted(),Constants.ONE)){
             throw new BusinessException(ResponseStatus.DATA_EMPTY);
         }
         if(!auditApproveDTO.getMemberId().equals(approve.getChekorId())){
@@ -565,7 +567,7 @@
                 .eq(ApproveParam::getLevel,Constants.ONE)
                 .eq(ApproveParam::getMemberType,Constants.ZERO)
                 .last("limit 1"));
-         return  Objects.isNull(approveParam)?null:approveParam.getId();
+        return  Objects.isNull(approveParam)?null:approveParam.getId();
     }
 
 
@@ -687,7 +689,7 @@
         if(Constants.equalsInteger(visits.getType(),Constants.ZERO)
              ||  Constants.equalsInteger(visits.getType(),Constants.ONE)){
             if(  visits.getIdcardType() == null
-                    ||  StringUtils.isBlank( visits.getIdcardNo() ) || StringUtils.isBlank(visits.getFaceImg()) ){
+                    || StringUtils.isBlank(visits.getFaceImg()) ){
                 throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "瀵逛笉璧凤紝淇℃伅濉啓涓嶆纭紒");
             }
         }
@@ -894,38 +896,41 @@
         List<Member> addList = new ArrayList<>();
         List<Member> editList = new ArrayList<>();
         //鐢宠浜轰俊鎭�
-        Member m = getMemberListParam(visits.getIdcardNo(),visits,addList,editList);
+        Member m = getMemberListParam(visits.getPhone(),visits.getIdcardNo(),visits,addList,editList);
         //闅忚浜哄憳淇℃伅澶勭悊
-        if(visits.getWithUserList()!= null && visits.getWithUserList().size()>0){
-            for(Visits model:visits.getWithUserList()){
-                model.setBirthday(Constants.getBirthdyByCardNo(model.getIdcardNo()));
-                model.setStarttime(visits.getStarttime());
-                model.setEndtime(visits.getEndtime());
-                //鏍¢獙闅忚浜哄憳濉姤鏁版嵁鍚堟硶鎬�
-                isValidWithVisitParam(model,addList,editList);
-                model.setCreateDate(visits.getCreateDate());
-                Member visitsMember = getMemberListParam(model.getIdcardNo(),model,addList,editList);
-                model.setMemberId(visitsMember.getId());
-            }
-        }
+//        if(visits.getWithUserList()!= null && visits.getWithUserList().size()>0){
+//            for(Visits model:visits.getWithUserList()){
+//                model.setBirthday(Constants.getBirthdyByCardNo(model.getIdcardNo()));
+//                model.setStarttime(visits.getStarttime());
+//                model.setEndtime(visits.getEndtime());
+//                //鏍¢獙闅忚浜哄憳濉姤鏁版嵁鍚堟硶鎬�
+//                isValidWithVisitParam(model,addList,editList);
+//                model.setCreateDate(visits.getCreateDate());
+//                Member visitsMember = getMemberListParam(model.getIdcardNo(),model,addList,editList);
+//                model.setMemberId(visitsMember.getId());
+//            }
+//        }
         return  m;
     }
 
-    private Member getMemberListParam(String cardno, Visits visits, List<Member> addList, List<Member> editList) {
+    private Member getMemberListParam(String phone,String cardno, Visits visits, List<Member> addList, List<Member> editList) {
         if(StringUtils.isNotBlank(visits.getCarNos())
                 &&Objects.isNull(Constants.getVehiclePlateNo(visits.getCarNos()))
         ){
             throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "瀵逛笉璧凤紝杞︾墝鍙枫��"+visits.getCarNos()+"銆戜笉鍚堟硶锛岃鏍稿疄鍚庨噸璇晘");
         }
-        if(Constants.equalsInteger(Constants.ZERO, visits.getIdcardType())&&cardno.length()!=18
-            //&&!IdcardUtil.isValidCard(cardno)
-        ){
-            throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "瀵逛笉璧凤紝韬唤璇併��"+cardno+"銆戝彿鐮佹湁璇紝璇锋牳瀹炲悗閲嶈瘯锛�");
-        }
+
+//        if(StringUtils.isNotBlank(cardno)&&Constants.equalsInteger(Constants.ZERO, visits.getIdcardType())&&cardno.length()!=18
+//            //&&!IdcardUtil.isValidCard(cardno)
+//        ){
+//            throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "瀵逛笉璧凤紝韬唤璇併��"+cardno+"銆戝彿鐮佹湁璇紝璇锋牳瀹炲悗閲嶈瘯锛�");
+//        }
         Member member = memberMapper.selectOne(new QueryWrapper<Member>().lambda()
                 .eq(Member::getType,Constants.memberType.visitor)
                 .eq(Member::getIdcardType,visits.getIdcardType())
-                .eq(Member::getIdcardNo,DESUtil.encrypt(Constants.EDS_PWD, cardno)).last("limit 1" )
+                .eq(Member::getPhone,phone)
+//                .eq(Member::getIdcardNo,DESUtil.encrypt(Constants.EDS_PWD, cardno))
+                .last("limit 1" )
         );
         if(member == null){
             member = new Member();
@@ -933,12 +938,14 @@
             member.setCreateDate(visits.getCreateDate());
             member.setIsdeleted(Constants.ZERO);
             member.setIdcardNo(visits.getIdcardNo());
-            member.setBirthday(Constants.getBirthdyByCardNo(cardno));
             member.setIdcardDecode(visits.getIdcardDecode());
-            member.setIdcardNo(DESUtil.encrypt(Constants.EDS_PWD, cardno));//韬唤璇佸彿鍔犲瘑
-            member.setIdcardDecode(Constants.getTuominStr(cardno));//鑴辨晱鎵嬫満鍙�
+            if(StringUtils.isNotBlank(cardno)){
+                member.setBirthday(Constants.getBirthdyByCardNo(cardno));
+                member.setIdcardNo(DESUtil.encrypt(Constants.EDS_PWD, cardno));//韬唤璇佸彿鍔犲瘑
+                member.setIdcardDecode(Constants.getTuominStr(cardno));//鑴辨晱鎵嬫満鍙�
+                member.setSex(Constants.getSexByCardNo(cardno));
+            }
             member.setFaceImg(visits.getFaceImg());
-            member.setSex(Constants.getSexByCardNo(cardno));
             member.setImgurl(StringUtils.isNotBlank(visits.getImgurl())?visits.getImgurl():null);
             member.setIdcardType(visits.getIdcardType());
             member.setName(visits.getName());
@@ -946,7 +953,6 @@
             member.setOpenid(visits.getOpenid());
             member.setType(Constants.memberType.visitor);
             member.setStatus(Constants.ZERO);
-            member.setSex(Constants.getSexByCardNo(cardno));
             member.setHkStatus(Constants.ZERO);
             member.setErpStatus(Constants.ZERO);
             member.setVisitCompanyName(visits.getCompanyName());
@@ -956,7 +962,7 @@
         }else{
             if(!Constants.equalsInteger(Constants.ZERO,member.getStatus() )){
                 //濡傛灉鐢ㄦ埛鐘舵�佸紓甯革紝鍒欐彁绀�
-                throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "瀵逛笉璧凤紝銆�"+member.getName()+"銆戣韩浠借瘉鍙枫��"+cardno+"銆戝湪榛戝悕鍗曞唴锛屾棤娉曠敵璇疯繘鍏ュ洯鍖�");
+                throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "瀵逛笉璧凤紝銆�"+member.getName()+"銆戝湪榛戝悕鍗曞唴锛屾棤娉曠敵璇疯繘鍏ュ洯鍖�");
             }
             //鏍告煡棰勭害鐢ㄦ埛鏄惁瀛樺湪鏈绂荤殑棰勭害璁板綍
 //            isExsitNoOutVisisRecord(member);
@@ -964,13 +970,15 @@
             member.setImgurl(StringUtils.isNotBlank(visits.getImgurl())?visits.getImgurl():null);
             member.setEditDate(visits.getCreateDate());
             member.setIsdeleted(Constants.ZERO);
-            member.setSex(Constants.getSexByCardNo(cardno));
-            member.setIdcardNo(DESUtil.encrypt(Constants.EDS_PWD, cardno));//韬唤璇佸彿鍔犲瘑
-            member.setIdcardDecode(Constants.getTuominStr(cardno));//鑴辨晱韬唤璇佸彿
+            if(StringUtils.isNotBlank(cardno)){
+                member.setBirthday(Constants.getBirthdyByCardNo(cardno));
+                member.setIdcardNo(DESUtil.encrypt(Constants.EDS_PWD, cardno));//韬唤璇佸彿鍔犲瘑
+                member.setIdcardDecode(Constants.getTuominStr(cardno));//鑴辨晱鎵嬫満鍙�
+                member.setSex(Constants.getSexByCardNo(cardno));
+            }
             member.setName(visits.getName());
             member.setPhone(visits.getPhone());
             member.setOpenid(visits.getOpenid());
-            member.setSex(Constants.getSexByCardNo(cardno));
             member.setHkStatus(Constants.ZERO);
             member.setErpStatus(Constants.ZERO);
             member.setVisitCompanyName(visits.getCompanyName());
@@ -978,21 +986,20 @@
         }
         //鏍规嵁鎵嬫満鍙峰拰韬唤璇佸彿鐮佹煡璇� 褰撳墠棰勭害鐨勬椂闂存槸鍚︿笌鍏朵粬棰勭害璁板綍鏈夊啿绐�
         if (visitsMapper.selectCount(new QueryWrapper<Visits>().lambda()
+                        .eq(Visits::getIsdeleted,Constants.ZERO)
                         .notIn(Visits::getStatus,Constants.VisitStatus.cancel
                                 ,Constants.VisitStatus.noPass
                                 ,Constants.VisitStatus.xfFail
                                 ,Constants.VisitStatus.signout
                                 ,Constants.VisitStatus.invalid)
-                .eq(Visits::getIdcardDecode, Constants.getTuominStr(cardno))
-                .and(ms -> ms.eq(Visits::getPhone, visits.getPhone())
-                        .or().eq(Visits::getIdcardDecode, Constants.getTuominStr(cardno)))
+                .and(ms -> ms.eq(Visits::getPhone, visits.getPhone()))
                 .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") + "' ")
                         .or().apply(" visits.STARTTIME >= '" + DateUtil.DateToStr(visits.getStarttime(),"yyyy-MM-dd HH:mm:ss") + "' and visits.STARTTIME <= '" + DateUtil.DateToStr(visits.getEndtime(),"yyyy-MM-dd HH:mm:ss") + "' ")
                         .or().apply(" visits.ENDTIME >= '" + DateUtil.DateToStr(visits.getStarttime(),"yyyy-MM-dd HH:mm:ss") + "' and visits.ENDTIME <= '" + DateUtil.DateToStr(visits.getEndtime(),"yyyy-MM-dd HH:mm:ss") + "' ")
                 )
         ) > Constants.ZERO) {
-            throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "瀵逛笉璧凤紝鎵嬫満鍙枫��"+member.getPhone()+"銆戞垨韬唤璇併��"+ member.getIdcardDecode() +"銆戝瓨鍦ㄩ绾︽椂闂村啿绐侊紝鏃犳硶鐢宠鍝︼紒");
+            throw  new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "瀵逛笉璧凤紝鎵嬫満鍙枫��"+member.getPhone()+"銆戝瓨鍦ㄩ绾︽椂闂村啿绐侊紝鏃犳硶鐢宠鍝︼紒");
         }
         return  member;
     }
@@ -1003,6 +1010,7 @@
      */
     private void isExsitNoOutVisisRecord(Member member) {
         Visits v = visitsMapper.selectOne(new QueryWrapper<Visits>().lambda()
+                .eq(Visits::getIsdeleted,Constants.ZERO)
                 .eq(Visits::getPhone, member.getPhone())
                 .eq(Visits::getStatus,Constants.VisitStatus.xfSuccess)
                 .last(" limit 1" )
@@ -1040,6 +1048,7 @@
             problemLog.setUserId(member.getId());
             problemLog.setPhone(member.getPhone());
             problemLog.setLogId(visits.getId());
+            problemLog.setCompanyName(visits.getCompanyName());
             problemLogMapper.updateById(problemLog);
         }
     }
@@ -1137,6 +1146,32 @@
     public void deleteById(Integer id) {
         visitsMapper.deleteById(id);
     }
+    @Override
+    @Transactional(rollbackFor ={BusinessException.class,Exception.class})
+    public  void deleteById(Integer id,LoginUserInfo user) {
+        Visits model = visitsMapper.selectById(id);
+        if(model ==null || Constants.equalsInteger(model.getIsdeleted(),Constants.ONE)){
+            throw  new BusinessException(ResponseStatus.DATA_EMPTY);
+        }
+        Date date = new Date();
+        visitsMapper.update(null,new UpdateWrapper<Visits>().lambda()
+                .set(Visits::getIsdeleted,Constants.ONE)
+                .set(Visits::getEditDate,new Date())
+                .set(Visits::getEditor,user.getId())
+                .eq(Visits::getId,id));
+        String[] params = new String[3];
+        params[0] = user.getRealname();
+        params[1]=DateUtil.getPlusTime2(date);
+        if(Constants.equalsInteger(model.getType(),Constants.TWO)){
+            params[2]="銆愯溅鐗屽彿锛�"+model.getCarNos()+"銆�-銆愬崟浣嶏細"+model.getCompanyName()+" "+model.getName()+" "+model.getPhone()+"銆�-銆愭椂闂达細"+DateUtil.getPlusTime2(model.getStarttime())+"-"+DateUtil.getPlusTime2(model.getEndtime())+"銆�";
+            //璁板綍鍒犻櫎璁垮鎶ュ鏃ュ織
+            UserActionServiceImpl.saveUserActionBiz(user,id,Constants.UserActionType.VISIT_CAR_DEL,userActionMapper,date,params, JSONObject.toJSONString(model));
+        }else{
+            params[2]="銆愬崟浣嶏細"+model.getCompanyName()+"銆�-銆愯瀹細"+model.getName()+" "+model.getPhone()+"銆�-銆愭椂闂达細"+DateUtil.getPlusTime2(model.getStarttime())+"-"+DateUtil.getPlusTime2(model.getEndtime())+"銆�";
+            //璁板綍鍒犻櫎璁垮鐢宠鏃ュ織
+            UserActionServiceImpl.saveUserActionBiz(user,id,Constants.UserActionType.VISIT_DEL,userActionMapper,date,params, JSONObject.toJSONString(model));
+        }
+    }
 
     @Override
     public void delete(Visits visits) {
@@ -1180,6 +1215,7 @@
         queryWrapper.leftJoin("Member t3 on t.CREATE_MEMBER_ID=t3.id");
 
         queryWrapper.eq(Visits::getId,id);
+        queryWrapper.eq(Visits::getIsdeleted,Constants.ZERO);
         Visits result = visitsJoinMapper.selectJoinOne(Visits.class,queryWrapper);
 
         if(result!=null){
@@ -1190,6 +1226,8 @@
                 List<DeviceRole> deviceRoleList= deviceRoleMapper.selectList(deviceQuery);
                 result.setDeviceRoleList(deviceRoleList);
             }
+        }else{
+            throw  new BusinessException(ResponseStatus.DATA_EMPTY);
         }
 
         MPJLambdaWrapper<Visits> visitQuery = new MPJLambdaWrapper<>();
@@ -1258,6 +1296,7 @@
 
         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.select("  ( select count(distinct(v.id)) from retention v where v.member_id = t.member_id and v.type=1 )",Visits::getRetentionNum);
         queryWrapper.selectAs(Member::getName,Visits::getReceptMemberName);
         queryWrapper.selectAs(Company::getName,Visits::getReceptMemberDepartment);
         queryWrapper.leftJoin(Member.class,Member::getId,Visits::getReceptMemberId);
@@ -1289,6 +1328,9 @@
         queryWrapper.isNull(Visits::getParentId);
         queryWrapper.eq(Objects.nonNull(pageWrap.getModel().getMemberId()),Visits::getMemberId,pageWrap.getModel().getMemberId());
         queryWrapper.eq(Objects.nonNull(pageWrap.getModel().getReceptMemberId()),Visits::getReceptMemberId,pageWrap.getModel().getReceptMemberId());
+        queryWrapper.ge(Objects.nonNull(pageWrap.getModel().getQueryStarttime()),Visits::getStarttime,Utils.Date.getStart(pageWrap.getModel().getQueryStarttime()));
+        queryWrapper.le(Objects.nonNull(pageWrap.getModel().getQueryEndtime()),Visits::getStarttime,Utils.Date.getEnd(pageWrap.getModel().getQueryEndtime()));
+
 
         if(Objects.nonNull(pageWrap.getModel().getBusinessStatus())){
             if(Constants.equalsInteger(pageWrap.getModel().getBusinessStatus(),Constants.TWO)){
@@ -1373,7 +1415,7 @@
     @Override
     public VisitDetailVO getVisitDetail(Integer id,Integer memberId){
         Visits visits = visitsMapper.selectById(id);
-        if(Objects.isNull(visits)){
+        if(Objects.isNull(visits) || Constants.equalsInteger(visits.getIsdeleted(),Constants.ONE)){
             throw new BusinessException(ResponseStatus.DATA_EMPTY);
         }
         Member member = memberMapper.selectById(visits.getReceptMemberId());
@@ -1495,26 +1537,44 @@
 
 
     @Override
+    @Transactional(rollbackFor = {BusinessException.class,Exception.class})
+    public  void  visitLevelForCarOut(Visits visits){
+        visits.setRemark("璺熼殢璁垮杞﹁締绂诲洯鑷姩绛剧");
+        visitLevelBiz(visits);
+    }
+    @Override
+    @Transactional(rollbackFor = {BusinessException.class,Exception.class})
     public void  visitLevel(Integer visitId){
         Visits visits = visitsMapper.selectById(visitId);
-        if(Objects.isNull(visits)){
-            throw new BusinessException(ResponseStatus.DATA_EMPTY);
-        }
-        if(!visits.getStatus().equals(Constants.VisitStatus.signin)){
-            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璁垮璁板綍鐘舵�侀敊璇紝璇峰埛鏂伴噸璇�");
-        }
-        VisitAppointmentOutRequest request = new VisitAppointmentOutRequest();
-        request.setOrderId(visits.getHkId());
-        //璋冪敤娴峰悍寮哄埗绛剧
-        BaseResponse response =  HKService.iccmSignoff(request);
-//        BaseResponse response =  HKService.outVisitAppiontment(request);
-        visitsMapper.update(null,new UpdateWrapper<Visits>().lambda().set(Visits::getStatus,Constants.VisitStatus.signout)
-                .eq(Visits::getId,visitId));
+        visits.setRemark("骞冲彴绠$悊鍛樻墜鍔ㄧ绂绘垚鍔�");
+        visitLevelBiz(visits);
         //浜у嚭鍦ㄥ満浜哄憳淇℃伅
         retentionMapper.delete(new UpdateWrapper<Retention>().lambda()
                 .eq(Retention::getType,Constants.memberType.visitor)
                 .eq(Retention::getMemberId,visits.getMemberId()));
     }
+
+    private void visitLevelBiz(Visits visits) {
+        if(Objects.isNull(visits)){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY);
+        }
+        if(!visits.getStatus().equals(Constants.VisitStatus.signin)){
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"浠呮敮鎸併�愭嫓璁夸腑銆戠姸鎬佽繘琛岃绂诲満鎿嶄綔锛岃鍒锋柊閲嶈瘯");
+        }
+        VisitAppointmentOutRequest request = new VisitAppointmentOutRequest();
+        request.setOrderId(visits.getHkId());
+        //璋冪敤娴峰悍寮哄埗绛剧
+        BaseResponse response =  HKService.iccmSignoff(request);
+        if(response!=null &&StringUtils.isNotBlank(response.getCode()) && StringUtils.equals(response.getCode(),HKConstants.RESPONSE_SUCCEE)){
+            visitsMapper.update(null,new UpdateWrapper<Visits>().lambda()
+                    .set(Visits::getStatus,Constants.VisitStatus.signout)
+                    .set(Visits::getRemark,visits.getRemark())
+                    .eq(Visits::getId,visits.getId()));
+        }else{
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璁垮绛剧澶辫触锛岃鍒锋柊閲嶈瘯");
+        }
+    }
+
     @Override
     public void  visitCancel(Integer visitId){
         Visits visits = visitsMapper.selectById(visitId);
@@ -1536,6 +1596,155 @@
                 .eq(Retention::getType,Constants.memberType.visitor)
                 .eq(Retention::getMemberId,visits.getMemberId()));
     }
+
+
+    @Override
+    public void  visitsSelfCancel(Integer visitId,Integer memberId,String openid){
+        Visits visits = visitsMapper.selectById(visitId);
+        if(Objects.isNull(visits)){
+            throw new BusinessException(ResponseStatus.DATA_EMPTY);
+        }
+/*        if(!(Constants.equalsInteger(memberId,visits.getMemberId()))){
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鏃犳鎿嶄綔鏉冮檺");
+        }*/
+        if(!StringUtils.equals(openid,visits.getOpenid())){
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鏃犳鎿嶄綔鏉冮檺");
+        }
+        this.visitsCancelBiz(visits);
+    }
+
+    @Override
+    public void  visitsCancel(Integer visitId,LoginUserInfo loginUserInfo) {
+        Visits visits = visitsMapper.selectById(visitId);
+        if (Objects.isNull(visits)) {
+            throw new BusinessException(ResponseStatus.DATA_EMPTY);
+        }
+        if(!(
+                 CollectionUtils.isNotEmpty(loginUserInfo.getPermissions()) &&
+                        loginUserInfo.getPermissions().stream().filter(i->i.equals("business:visits:cancel"))
+                                .collect(Collectors.toList()).size()>0)){
+            throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鏃犳鎿嶄綔鏉冮檺");
+        }
+        this.visitsCancelBiz(visits);
+    }
+    /**
+     * 澶勭悊寰呭鏍搞�佸鏍镐腑銆佸凡瀹℃牳鐨勬暟鎹彇娑堜笟鍔�
+     * 2025骞�3鏈�25鏃�14:10:10
+     */
+    public void  visitsCancelBiz(Visits visits){ 
+        UpdateWrapper<Visits> updateWrapper = new UpdateWrapper();
+        updateWrapper.lambda().set(Visits::getStatus,Constants.VisitStatus.cancel)
+                .set(Visits::getEditDate,DateUtil.getCurrDateTime())
+                .set(Visits::getEditor,visits.getEditor())
+                .eq(Visits::getId,visits.getId());
+        //璁垮鎶ュ
+        if(Constants.equalsInteger(visits.getType(),Constants.TWO)){
+            if(!(Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.waitCheck)
+                    ||Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.submitCheck)
+                    || Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.pass))){
+                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璁垮璁板綍鐘舵�侀敊璇紝鏃犳硶杩涜璇ユ搷浣�");
+            }
+            if(Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.pass)
+                    && Constants.equalsInteger(visits.getHkStatus(),Constants.ONE)
+                    &&StringUtils.isNotBlank(visits.getCarNos())){
+                //鍙栨秷鍋滆溅鍦洪绾�
+                List<VisitPark> visitParkList = visitParkMapper.selectList(new QueryWrapper<VisitPark>().lambda()
+                        .eq(VisitPark::getCarCode,visits.getCarNos())
+                        .eq(VisitPark::getObjType,Constants.ONE)
+                        .eq(VisitPark::getHkStatus,Constants.ONE)
+                        .isNotNull(VisitPark::getHkId)
+                        .apply("  END_TIME > now() ")
+                        .orderByDesc(VisitPark::getCreateDate)
+                );
+                if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(visitParkList)){
+                    for (VisitPark visitPark:visitParkList) {
+                        ParkReservationDelRequest param = new ParkReservationDelRequest();
+                        param.setReserveOrderNo(visitPark.getHkId());
+                        BaseResponse response =  HKService.parkReservationDeletion(param);
+                        if(response!=null
+                                && StringUtils.equals(response.getCode(), HKConstants.RESPONSE_SUCCEE)){
+                            visitPark.setHkStatus(Constants.THREE);
+                            visitPark.setIsdeleted(Constants.ONE);
+                            visitPark.setEditDate(new Date());
+                            visitParkMapper.updateById(visitPark);
+                        }else{
+                            throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),response.getMsg());
+                        }
+                    }
+                    updateWrapper.lambda().set(Visits::getHkStatus,Constants.ZERO).set(Visits::getHkDate,DateUtil.getCurrDateTime());
+                }
+            }
+        }else{
+            //璁垮鐢宠
+            if(!(Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.waitCheck)||Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.submitCheck)
+                    || Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.pass)|| Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.xfSuccess))){
+                throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"璁垮璁板綍鐘舵�侀敊璇紝璇峰埛鏂伴噸璇�");
+            }
+            if(Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.xfSuccess)
+                    && Constants.equalsInteger(visits.getHkStatus(),Constants.ONE)
+                    &&StringUtils.isNotBlank(visits.getHkRecordId())){
+                VisitAppointmentCancelRequest request = new VisitAppointmentCancelRequest();
+                request.setAppointRecordIds(new String[]{visits.getHkRecordId()});
+                BaseResponse response =  HKService.iccmCancelAppointment(request);
+                if(response==null || !StringUtils.equals(response.getCode(), HKConstants.RESPONSE_SUCCEE) || response.getData()==null){
+                    throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(),response.getMsg());
+                }
+                updateWrapper.lambda().set(Visits::getHkStatus,Constants.ZERO).set(Visits::getHkDate,DateUtil.getCurrDateTime());
+            }
+        }
+
+        if(Constants.equalsInteger(visits.getStatus(),Constants.ZERO)||Constants.equalsInteger(visits.getStatus(),Constants.ONE)){
+            //鏇存柊瀹℃壒涓殑璁板綍涓哄彇娑�
+            approveMapper.update(null,
+                    new UpdateWrapper<Approve>().lambda()
+                            .set(Approve::getEditDate,new Date())
+                            .set(Approve::getStatus,Constants.approveStatus.cancel)
+                            .set(Approve::getStatusInfo,"鎵嬪姩鍙栨秷")
+                            .set(Approve::getCheckInfo,"鎵嬪姩鍙栨秷")
+                            .eq(Approve::getIsdeleted,Constants.ZERO)
+                            .in(Approve::getStatus,Constants.approveStatus.auditIng,Constants.approveStatus.wait)
+                            .eq(Approve::getObjId,visits.getId())
+                            .eq(Approve::getObjType,visits.getType()));
+            //鏇存柊寰呭姙娑堟伅鐘舵��
+            noticesJoinMapper.update(null,
+                    new UpdateWrapper<Notices>().lambda()
+                            .set(Notices::getEditDate,new Date())
+                            .set(Notices::getInfo,"鎵嬪姩鍙栨秷")
+                            .setSql(" param4 = user_id ")
+                            .set(Notices::getStatus,Constants.ONE)
+                            .set(Notices::getParam2,Constants.ONE)//鏍囪宸插鐞�
+                            .eq(Notices::getStatus,Constants.ZERO)
+                            .eq(Notices::getParam2,Constants.ZERO)//寰呭鐞�
+                            .eq(Notices::getObjId,visits.getId())
+                            .eq(Notices::getObjType,!Constants.equalsInteger(visits.getType(),Constants.TWO)?
+                                    Constants.noticesObjectType.visit:Constants.noticesObjectType.visitReporting)
+            );
+
+            Approve approve = new Approve();
+            approve.setCreateDate(new Date());
+            approve.setIsdeleted(Constants.ZERO);
+            approve.setRemark("鎵嬪姩鍙栨秷");
+            approve.setChekorId(visits.getEditor());
+            approve.setTitle("鍙栨秷棰勭害");
+            approve.setStatus(Constants.THREE);
+            approve.setStatusInfo("鎵嬪姩鍙栨秷");
+            approve.setObjId(visits.getId());
+            approve.setLevel(9999);
+            approve.setApproveType(2);
+            approve.setDriverParam(Constants.ZERO);
+            approve.setAddrParam(Constants.ZERO);
+            approve.setObjType(visits.getType());
+            approve.setType(Constants.ZERO);
+            approve.setCheckDate(new Date());
+            approveMapper.insert(approve);
+        }
+
+        visitsMapper.update(null,updateWrapper);
+    }
+
+
+
+
     @Override
     public  void visitResend(Integer visitId) {
         MPJLambdaWrapper<Visits> queryWrapper = new MPJLambdaWrapper<>();
@@ -1554,7 +1763,7 @@
         }
         List<DeviceRole> roleList = deviceRoleMapper.selectList(new QueryWrapper<DeviceRole>().lambda()
                 .eq(DeviceRole::getType, Constants.ONE));
-        String path = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode()
+        String path = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_LOCAL_RESOURCE_PATH).getCode()
                 +systemDictDataBiz.queryByCode(Constants.FTP,Constants.MEMBER_IMG).getCode();
 
       HkSyncVisitServiceImpl.getUpdateModelByResponseIccm(visits,new Date(),roleList,path);
@@ -1612,7 +1821,7 @@
                     .apply(" DATE(TIME_INFO) = CURDATE()  ")
                     .last(" limit 1 ")
             );
-
+ 
             //浠婃棩鍦ㄥ洯浜烘暟
             pcWorkPlatformDataVO.setTodayInParkUserNum(
                     retentionList.stream().filter(i->!Constants.equalsInteger(i.getType(),Constants.THREE)).count()
@@ -1623,8 +1832,7 @@
 
             //鍦ㄥ洯闀挎湡鐩稿叧鏂逛汉鏁�
             pcWorkPlatformDataVO.setInParkLwUserNum(
-                    retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.TWO)
-                            && Constants.equalsInteger(i.getCompanyType(),Constants.ZERO)).count()
+                    retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.FOUR)).count()
             );
             pcWorkPlatformDataVO.setLwUserInNum(Constants.ZERO);
             pcWorkPlatformDataVO.setLwUserOutNum(Constants.ZERO);
@@ -1636,6 +1844,10 @@
             );
             pcWorkPlatformDataVO.setVisitUserNum(Constants.ZERO);
             pcWorkPlatformDataVO.setSignLevelNum(Constants.ZERO);
+
+            //鍦ㄥ洯璐ц繍杞﹁締鍙告満
+            pcWorkPlatformDataVO.setInParkDriverUserNum(
+                    retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.FIVE)&&Objects.isNull(i.getCompanyType())).count());
 
             //鍦ㄥ洯杞﹁締
             pcWorkPlatformDataVO.setTodayInParkCarNum(
@@ -1663,24 +1875,39 @@
             List<InterestedListVO> weekVisitList = new ArrayList<>();
             List<InterestedListVO> weekCarList = new ArrayList<>();
             List<InterestedListVO> lwList = new ArrayList<>();
+            List<InterestedListVO> internalList = new ArrayList<>();
             //鏌ヨ涓冨ぉ鍓嶇殑璁垮璁板綍鏁伴噺
-            List<Visits> visitsList = visitsMapper.selectList(new QueryWrapper<Visits>().lambda().in(Visits::getStatus,
-                    Constants.VisitStatus.signin,Constants.VisitStatus.signout)
-                    .apply(" STARTTIME >   CURDATE() - INTERVAL 7 DAY " )
+//            List<Visits> visitsList = visitsMapper.selectList(new QueryWrapper<Visits>().lambda().in(Visits::getStatus,
+//                    Constants.VisitStatus.signin,Constants.VisitStatus.signout)
+//                    .apply(" STARTTIME >   CURDATE() - INTERVAL 7 DAY " )
+//            );
+
+            List<InoutRecord> inoutRecordList = inoutRecordMapper.selectList(new QueryWrapper<InoutRecord>().lambda()
+                    .eq(InoutRecord::getInOrOut,Constants.ZERO).eq(InoutRecord::getIsdeleted,Constants.ZERO)
+                    .apply(" TIME_INFO >   CURDATE() - INTERVAL 7 DAY " )
             );
 
-            List<CarEvent> carEventList = carEventMapper.selectList(new QueryWrapper<CarEvent>().lambda()
-                    .in(CarEvent::getEventType,"771760131","771760130")
-                    .apply(" STR_TO_DATE(happen_time, '%Y-%m-%dT%H:%i:%s') > CURDATE() - INTERVAL 7 DAY  " )
-            );
+//            List<CarEvent> carEventList = carEventMapper.selectList(new QueryWrapper<CarEvent>().lambda()
+//                    .in(CarEvent::getEventType,"771760131","771760130")
+//                    .apply(" STR_TO_DATE(happen_time, '%Y-%m-%dT%H:%i:%s') > CURDATE() - INTERVAL 7 DAY  " )
+//            );
 
             for (String days:weekDays) {
                 InterestedListVO visitVO = new InterestedListVO();
                 visitVO.setName(days);
-                if(CollectionUtils.isNotEmpty(visitsList)){
+                if(CollectionUtils.isNotEmpty(inoutRecordList)){
                     //澶勭悊璁垮浜哄憳鏁伴噺
-                    List<Visits> daysList = visitsList.stream().filter(i->Objects.nonNull(i.getStarttime())&&DateUtil.dateToString(i.getStarttime(),"yyyy-MM-dd").equals(days)).collect(Collectors.toList());
-                    List<String> memberIds = daysList.stream().map(i->i.getMemberId().toString()).collect(Collectors.toList());
+//                    List<Visits> daysList = visitsList.stream().filter(i->Objects.nonNull(i.getStarttime())&&DateUtil.dateToString(i.getStarttime(),"yyyy-MM-dd").equals(days)).collect(Collectors.toList());
+//                    List<String> memberIds = daysList.stream().map(i->i.getMemberId().toString()).collect(Collectors.toList());
+
+                    List<String> memberIds  = inoutRecordList.stream().filter(i->
+                                    Objects.isNull(i.getCarCode())
+                                            && Constants.equalsInteger(i.getMemberType(),Constants.ONE)
+                                            && Constants.equalsInteger(i.getInOrOut(),Constants.ZERO)
+                                            && Objects.nonNull(i.getMemberPhone())&&DateUtil.dateToString(i.getTimeInfo(),"yyyy-MM-dd").equals(days)
+                            )
+                            .map(i->i.getMemberPhone())
+                            .collect(Collectors.toList());
                     if(CollectionUtils.isNotEmpty(memberIds)){
                         visitVO.setNum(new HashSet<String>(memberIds).size());
                     }
@@ -1691,51 +1918,83 @@
 
 
                 visitVO.setName(days);
+                weekVisitList.add(visitVO);
+
                 InterestedListVO carVO = new InterestedListVO();
+                carVO.setNum(Constants.ZERO);
                 carVO.setName(days);
 
-
-                if(CollectionUtils.isNotEmpty(carEventList)){
+                if(CollectionUtils.isNotEmpty(inoutRecordList)){
                     //澶勭悊璁垮浜哄憳鏁伴噺
-                    List<CarEvent> daysList = carEventList.stream().filter(i->StringUtils.isNotBlank(i.getHappenTime()) && i.getHappenTime().substring(0,10).equals(days)).collect(Collectors.toList());
-                    List<String> carCodeList = daysList.stream().map(i->i.getPlateNos()).collect(Collectors.toList());
+//                    List<CarEvent> daysList = carEventList.stream().filter(i->StringUtils.isNotBlank(i.getHappenTime()) && i.getHappenTime().substring(0,10).equals(days)).collect(Collectors.toList());
+//                    List<String> carCodeList = daysList.stream().map(i->i.getPlateNos()).collect(Collectors.toList());
+                    List<String> carCodeList  = inoutRecordList.stream().filter(i->
+                                    Objects.nonNull(i.getCarCode())
+                                            && Constants.equalsInteger(i.getInOrOut(),Constants.ZERO)
+                                            &&DateUtil.dateToString(i.getTimeInfo(),"yyyy-MM-dd").equals(days)
+                            )
+                            .map(i->i.getCarCode())
+                            .collect(Collectors.toList());
                     if(CollectionUtils.isNotEmpty(carCodeList)){
                         carVO.setNum(new HashSet<String>(carCodeList).size());
                     }
                 }
                 if(Objects.isNull(carVO.getNum())){
-                    visitVO.setNum(Constants.ZERO);
+                    carVO.setNum(Constants.ZERO);
                 }
-                weekVisitList.add(visitVO);
                 weekCarList.add(carVO);
             }
             pcWorkPlatformDataVO.setWeekVisitList(weekVisitList );
             pcWorkPlatformDataVO.setWeekCarList(weekCarList);
 
             List<Company> companyList = companyMapper.selectList(new QueryWrapper<Company>().lambda()
-                    .eq(Company::getType,Constants.ZERO)
                     .eq(Company::getIsdeleted,Constants.ZERO)
+                    .orderByAsc(Company::getSortnum)
             );
 
             if(CollectionUtils.isNotEmpty(companyList)){
-                List<Integer> companyIds = companyList.stream().map(i->i.getId()).collect(Collectors.toList());
-                List<Retention> retentionList = retentionMapper.selectList(
-                        new QueryWrapper<Retention>().lambda()
-                                .eq(Retention::getType,Constants.TWO)
-                                .in(Retention::getCompanyId,companyIds)
-                );
-                for (Company company:companyList) {
-                    Integer count = retentionList.stream().filter(i->Constants.equalsInteger(i.getCompanyId(),company.getId())).collect(Collectors.toList()).size();
-                    if(count>0){
-                        InterestedListVO lw = new InterestedListVO();
-                        lw.setNum(count);
-                        lw.setName(company.getName());
-                        lwList.add(lw);
+                List<Company>  lwCompanyList  = companyList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.ZERO)).collect(Collectors.toList());
+                if(CollectionUtils.isNotEmpty(lwCompanyList)){
+                    List<Integer> lwCompanyIds = lwCompanyList.stream().map(i->i.getId()).collect(Collectors.toList());
+                    List<Retention> retentionList = retentionMapper.selectList(
+                            new QueryWrapper<Retention>().lambda()
+                                    .eq(Retention::getIsdeleted,Constants.ZERO)
+                                    .eq(Retention::getType,Constants.FOUR)
+                                    .in(Retention::getCompanyId,lwCompanyIds)
+                    );
+                    for (Company company:lwCompanyList) {
+                        Integer count = retentionList.stream().filter(i->Constants.equalsInteger(i.getCompanyId(),company.getId())).collect(Collectors.toList()).size();
+                        if(count>0){
+                            InterestedListVO lw = new InterestedListVO();
+                            lw.setNum(count);
+                            lw.setName(company.getName());
+                            lwList.add(lw);
+                        }
+                    }
+                }
+
+                List<Company>  internalCompanyList  = companyList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.ONE)).collect(Collectors.toList());
+                if(CollectionUtils.isNotEmpty(internalCompanyList)){
+                    List<Integer> internalCompanyIds = internalCompanyList.stream().map(i->i.getId()).collect(Collectors.toList());
+                    List<Retention> retentionList = retentionMapper.selectList(
+                            new QueryWrapper<Retention>().lambda()
+                                    .eq(Retention::getIsdeleted,Constants.ZERO)
+                                    .eq(Retention::getType,Constants.TWO)
+                                    .in(Retention::getCompanyId,internalCompanyIds)
+                    );
+                    for (Company company:internalCompanyList) {
+                        Integer count = retentionList.stream().filter(i->Constants.equalsInteger(i.getCompanyId(),company.getId())).collect(Collectors.toList()).size();
+                        if(count>0){
+                            InterestedListVO lw = new InterestedListVO();
+                            lw.setNum(count);
+                            lw.setName(company.getName());
+                            internalList.add(lw);
+                        }
                     }
                 }
             }
-
-            pcWorkPlatformDataVO.setLwList(lwList   );
+            pcWorkPlatformDataVO.setInternalList(internalList);
+            pcWorkPlatformDataVO.setLwList(lwList);
         }else if(Constants.equalsInteger(queryType,Constants.THREE)) {
             if (Objects.isNull(loginUserInfo.getMemberId())) {
                 pcWorkPlatformDataVO.setNoticesList(new ArrayList<>());
@@ -1805,6 +2064,7 @@
         List<Visits> visitsList = visitsMapper.selectList(new QueryWrapper<Visits>().lambda()
                 .eq(Visits::getStatus,Constants.VisitStatus.signin)
                 .eq(Visits::getSendTimeOutNotice,Constants.ZERO)
+                .eq(Visits::getIsdeleted,Constants.ZERO)
                 .apply("   now() >=  DATE_ADD(ENDTIME,INTERVAL -"+times+" MINUTE)   ")
         );
         Integer visitTimeCount = 0;
@@ -1850,10 +2110,111 @@
                 );
             }
         }
-
-
-
     }
+    @Override
+    public void visitNoCheckCancel(){
+        log.info("===============寰呭鎵硅褰曡秴鏃惰嚜鍔ㄥ彇娑堥绾�===========start=======");
+        List<Visits> visitsList = visitsMapper.selectList(new QueryWrapper<Visits>().lambda()
+                .eq(Visits::getIsdeleted,Constants.ZERO)
+                .eq(Visits::getStatus,Constants.VisitStatus.waitCheck)
+                .apply(" now() >=  ENDTIME ")
+        );
+        if(visitsList!=null){
+            Date date =new Date();
+            for(Visits s :visitsList){
+                dealAutoCancelBiz(s,date);
+             }
+        }
+        log.info("===============寰呭鎵硅褰曡秴鏃惰嚜鍔ㄥ彇娑堥绾�===========end=======");
+    }
+
+    @Transactional
+    private void dealAutoCancelBiz(Visits s, Date date) {
+        visitsMapper.update(null,new UpdateWrapper<Visits>().lambda()
+                .set(Visits::getStatus,Constants.VisitStatus.cancel)
+                .set(Visits::getEditDate,date)
+                .set(Visits::getRemark,"棰勭害鎴鏃堕棿宸茶繃鏈鎵癸紝绯荤粺鑷姩鍙栨秷")
+                .eq(Visits::getId,s.getId()));
+
+        VisitsServiceImpl.dealCancelNoticesData(noticesJoinMapper,approveMapper,"绯荤粺鍙栨秷",s.getId(),
+                s.getType(),
+                !Constants.equalsInteger(s.getType(),Constants.TWO)?Constants.noticesObjectType.visit:Constants.noticesObjectType.visitReporting
+        );
+
+        Approve approve = new Approve();
+        approve.setCreateDate(new Date());
+        approve.setIsdeleted(Constants.ZERO);
+        approve.setRemark("绯荤粺鑷姩鍙栨秷");
+        approve.setTitle("鍙栨秷棰勭害");
+        approve.setStatus(Constants.THREE);
+        approve.setStatusInfo("瓒呮椂鑷姩鍙栨秷");
+        approve.setObjId(s.getId());
+        approve.setLevel(9999);
+        approve.setApproveType(2);
+        approve.setDriverParam(Constants.ZERO);
+        approve.setAddrParam(Constants.ZERO);
+        approve.setObjType(s.getType());
+        approve.setType(Constants.ZERO);
+        approve.setCheckDate(new Date());
+        approveMapper.insert(approve);
+
+//        //鏇存柊瀹℃壒涓殑璁板綍涓哄彇娑�
+//        approveMapper.update(null,
+//                new UpdateWrapper<Approve>().lambda()
+//                        .set(Approve::getEditDate,date)
+//                        .set(Approve::getStatus,Constants.approveStatus.cancel)
+//                        .set(Approve::getStatusInfo,"绯荤粺宸插彇娑�")
+//                        .set(Approve::getCheckInfo,"璁块棶鏃堕棿宸茶繃锛岀郴缁熻嚜鍔ㄥ彇娑�")
+//                        .eq(Approve::getIsdeleted,Constants.ZERO)
+//                        .in(Approve::getStatus,Constants.approveStatus.auditIng,Constants.approveStatus.wait)
+//                        .eq(Approve::getObjId,s.getId())
+//                        .eq(Approve::getObjType,s.getType()));
+//        //鏇存柊寰呭姙娑堟伅鐘舵��
+//        noticesJoinMapper.update(null,
+//                new UpdateWrapper<Notices>().lambda()
+//                        .set(Notices::getEditDate,date)
+//                        .set(Notices::getInfo,"宸插彇娑�")
+////                        .set(Notices::getStatus,Constants.ONE)
+//                        .set(Notices::getParam2,Constants.FOUR)//宸插彇娑�
+//                        .eq(Notices::getIsdeleted,Constants.ZERO)
+//                        .eq(Notices::getStatus,Constants.ZERO)
+//                        .eq(Notices::getParam2,Constants.ZERO)//寰呭鐞�
+//                        .eq(Notices::getObjId,s.getId())
+//                        .eq(Notices::getObjType,Constants.equalsInteger(s.getType(),Constants.ZERO)?Constants.noticesObjectType.visit:Constants.noticesObjectType.visitReporting)
+//        );
+    }
+
+
+    public static void  dealCancelNoticesData(NoticesJoinMapper noticesJoinMapper,ApproveMapper approveMapper,String info,Integer objId,Integer approveObjectType,Integer noticesType){
+        if(Objects.nonNull(approveObjectType)){
+            approveMapper.update(null,
+                    new UpdateWrapper<Approve>().lambda()
+                            .set(Approve::getEditDate,new Date())
+                            .set(Approve::getStatus,Constants.approveStatus.cancel)
+                            .set(Approve::getStatusInfo,info)
+                            .set(Approve::getCheckInfo,info)
+                            .eq(Approve::getIsdeleted,Constants.ZERO)
+                            .in(Approve::getStatus,Constants.approveStatus.auditIng,Constants.approveStatus.wait)
+                            .eq(Approve::getObjId,objId)
+                            .eq(Approve::getObjType,approveObjectType));
+        }
+        if(Objects.nonNull(noticesType)){
+            //鏇存柊寰呭姙娑堟伅鐘舵��
+            noticesJoinMapper.update(null,
+                    new UpdateWrapper<Notices>().lambda()
+                            .set(Notices::getEditDate,new Date())
+                            .set(Notices::getInfo,"鑷姩鍙栨秷")
+                            .setSql(" param4 = user_id ")
+                            .set(Notices::getStatus,Constants.ONE)
+                            .set(Notices::getParam2,Constants.ONE)//宸插彇娑�
+                            .eq(Notices::getStatus,Constants.ZERO)
+                            .eq(Notices::getParam2,Constants.ZERO)//寰呭鐞�
+                            .eq(Notices::getObjId,objId)
+                            .eq(Notices::getObjType,noticesType)
+            );
+        }
+    }
+
 
 
 }

--
Gitblit v1.9.3