From 17efddc6a667670dca682bf36b51a43e99615e6d Mon Sep 17 00:00:00 2001
From: k94314517 <8417338+k94314517@user.noreply.gitee.com>
Date: 星期三, 16 十月 2024 15:59:38 +0800
Subject: [PATCH] 代码初始化

---
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/VisitsServiceImpl.java |  252 +++++++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 247 insertions(+), 5 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 dee709a..3098750 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
@@ -12,11 +12,16 @@
 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.param.BaseListPageResponse;
 import com.doumee.core.haikang.model.param.BaseResponse;
+import com.doumee.core.haikang.model.param.request.FacePictureCheckRequest;
 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.AscDeviceStatusInfoResponse;
+import com.doumee.core.haikang.model.param.respose.FacePictureCheckResponse;
 import com.doumee.core.haikang.model.param.respose.VisitAppointmentResponse;
 import com.doumee.core.haikang.service.HKService;
+import com.doumee.core.model.LoginUserInfo;
 import com.doumee.core.model.PageData;
 import com.doumee.core.model.PageWrap;
 import com.doumee.core.utils.Constants;
@@ -24,6 +29,8 @@
 import com.doumee.core.utils.DateUtil;
 import com.doumee.core.utils.Utils;
 import com.doumee.core.wx.wxPlat.WxPlatNotice;
+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.dto.ResetPasswordDTO;
@@ -31,7 +38,10 @@
 import com.doumee.dao.business.join.VisitsJoinMapper;
 import com.doumee.dao.business.model.*;
 import com.doumee.dao.system.SystemUserMapper;
+import com.doumee.dao.system.dto.NoticesDTO;
 import com.doumee.dao.system.dto.ResetSystemUserPwdDTO;
+import com.doumee.dao.system.join.NoticesJoinMapper;
+import com.doumee.dao.system.model.Notices;
 import com.doumee.dao.system.model.SystemUser;
 import com.doumee.dao.web.reqeust.AuditApproveDTO;
 import com.doumee.dao.web.reqeust.ErpVisitDTO;
@@ -50,13 +60,23 @@
 import com.doumee.service.business.impl.hksync.HkSyncVisitServiceImpl;
 import com.github.xiaoymin.knife4j.core.util.CollectionUtils;
 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.Propagation;
 import org.springframework.transaction.annotation.Transactional;
+import sun.misc.BASE64Encoder;
 
+import java.io.ByteArrayOutputStream;
+import java.io.IOException;
+import java.io.InputStream;
+import java.net.HttpURLConnection;
+import java.net.URL;
+import java.nio.file.Files;
+import java.nio.file.Path;
+import java.nio.file.Paths;
 import java.util.*;
 import java.util.stream.Collectors;
 
@@ -108,7 +128,10 @@
     private SystemUserMapper systemUserMapper;
     @Autowired
     private ApproveService approveService;
-
+    @Autowired
+    private NoticesJoinMapper noticesJoinMapper;
+    @Autowired
+    private InoutDayCountMapper inoutDayCountMapper;
 
     @Override
     public Integer create(Visits visits) {
@@ -206,7 +229,8 @@
         getHkDeviceRoles(visits,isERP);
         //妫�楠屾嫓璁夸汉鏄惁鍚堟硶
         Member visitMember = isValideVisitedUser(visits.getReceptMemberId());
-        if(Constants.equalsInteger(Constants.ZERO, visits.getIdcardType())&&visits.getIdcardNo().length()!=18
+        if(Constants.equalsInteger(Constants.ZERO, visits.getIdcardType())
+                &&visits.getIdcardNo().length()!=18
         ){
             throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "瀵逛笉璧凤紝韬唤璇佸彿鐮佹湁璇紝璇锋牳瀹炲悗閲嶈瘯锛�");
         }
@@ -221,6 +245,26 @@
         visits.setVisitType(Integer.valueOf(systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.MDJ_VISIT_REQUIRED).getCode()));
         //鍒濆鍖栬瀹俊鎭�
         initVisitInfo(visits,date);
+
+        if(StringUtils.isNotBlank(visits.getFaceImg())&&(Constants.equalsInteger(visits.getType(),Constants.ZERO)|| Constants.equalsInteger(visits.getType(),Constants.TWO))){
+            //浜鸿劯璇勫垎
+            FacePictureCheckRequest param = new FacePictureCheckRequest();
+            String prefixUrl = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode() +
+                    systemDictDataBiz.queryByCode(Constants.FTP,Constants.MEMBER_IMG).getCode();
+            param.setFacePicUrl(prefixUrl + visits.getFaceImg());
+            BaseResponse<FacePictureCheckResponse> response = HKService.facePictureCheck(param);
+            if(response == null || !StringUtils.equals(response.getCode(), HKConstants.RESPONSE_SUCCEE)){
+                throw  new BusinessException(ResponseStatus.SERVER_ERROR.getCode(), "瀵逛笉璧凤紝浜鸿劯璇勫垎鑾峰彇鏁版嵁澶辫触~");
+            }
+            FacePictureCheckResponse facePictureCheckResponse = response.getData();
+            if(Objects.isNull(facePictureCheckResponse) || Objects.isNull(facePictureCheckResponse.getCheckResult())){
+                throw  new BusinessException(ResponseStatus.SERVER_ERROR.getCode(), "瀵逛笉璧凤紝浜鸿劯璇勫垎鑾峰彇鏁版嵁澶辫触~");
+            }
+            if(!facePictureCheckResponse.getCheckResult()){
+                throw  new BusinessException(ResponseStatus.SERVER_ERROR.getCode(), facePictureCheckResponse.getStatusMessage());
+            }
+        }
+
         visitsMapper.insert(visits);
 
         //鍙戣捣ERP瀹℃壒鐢宠
@@ -251,8 +295,6 @@
 
         return visits.getId();
     }
-
-
 
 
     @Override
@@ -618,7 +660,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.getIdcardNo() ) || StringUtils.isBlank(visits.getFaceImg()) ){
                 throw  new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "瀵逛笉璧凤紝淇℃伅濉啓涓嶆纭紒");
             }
         }
@@ -1141,6 +1183,15 @@
                         result.getType(),
                         memberId)
         );
+        if(Constants.equalsInteger(result.getStatus(),Constants.VisitStatus.xfSuccess)
+                || Constants.equalsInteger(result.getStatus(),Constants.VisitStatus.xfFail)
+                || Constants.equalsInteger(result.getStatus(),Constants.VisitStatus.signin)
+                || Constants.equalsInteger(result.getStatus(),Constants.VisitStatus.signout)
+                || Constants.equalsInteger(result.getStatus(),Constants.VisitStatus.invalid)){
+            result.setBusinessStatus(Constants.VisitStatus.pass);
+        }else{
+            result.setBusinessStatus(result.getStatus());
+        }
 
         return result;
     }
@@ -1260,6 +1311,15 @@
         VisitDetailVO visitDetailVO = new VisitDetailVO();
         visitDetailVO.setCreateTime(visits.getCreateDate());
         visitDetailVO.setStatus(visits.getStatus());
+        if(Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.xfSuccess)
+        || Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.xfFail)
+        || Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.signin)
+        || Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.signout)
+        || Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.invalid)){
+            visitDetailVO.setBusinessStatus(Constants.VisitStatus.pass);
+        }else{
+            visitDetailVO.setBusinessStatus(visits.getStatus());
+        }
         visitDetailVO.setCarNos(visits.getCarNos());
         visitDetailVO.setPhone(visits.getPhone());
         visitDetailVO.setVisitUserName(member.getName());
@@ -1444,4 +1504,186 @@
         systemUserBiz.resetPwd(dto);
     }
 
+    /**
+     *
+     * @param queryType 鏌ヨ绫诲瀷锛�1=鍦ㄥ洯浜烘暟锛�2=鎶ヨ〃鏁版嵁锛�3=寰呭姙浜嬮」锛�4=瓒呮椂棰勮
+     * @param loginUserInfo
+     * @return
+     */
+    @Override
+    public PCWorkPlatformDataVO getPcWorkPlatformData(Integer queryType ,LoginUserInfo loginUserInfo){
+        PCWorkPlatformDataVO pcWorkPlatformDataVO = new PCWorkPlatformDataVO();
+        if(Constants.equalsInteger(queryType,Constants.ONE)){
+            List<Retention> retentionList = retentionMapper.selectJoinList(Retention.class,
+                    new MPJLambdaWrapper<Retention>()
+                            .selectAll(Retention.class)
+                            .selectAs(Company::getType,Retention::getCompanyType)
+                            .leftJoin(Company.class,Company::getId,Retention::getCompanyId)
+            );
+
+            InoutDayCount inoutDayCount = inoutDayCountMapper.selectOne(new QueryWrapper<InoutDayCount>()
+                            .lambda()
+                    .apply(" DATE(TIME_INFO) = CURDATE()  ")
+                    .last(" limit 1 ")
+            );
+
+            //浠婃棩鍦ㄥ洯浜烘暟
+            pcWorkPlatformDataVO.setTodayInParkUserNum(
+                    retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.TWO)).count()
+            );
+
+            pcWorkPlatformDataVO.setTodayInUserNum(Constants.ZERO);
+            pcWorkPlatformDataVO.setTodayOutUserNum(Constants.ZERO);
+
+            //鍦ㄥ洯闀挎湡鐩稿叧鏂逛汉鏁�
+            pcWorkPlatformDataVO.setInParkLwUserNum(
+                    retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.TWO) && Constants.equalsInteger(i.getCompanyType(),Constants.ZERO)).count()
+            );
+            pcWorkPlatformDataVO.setLwUserInNum(Constants.ZERO);
+            pcWorkPlatformDataVO.setLwUserOutNum(Constants.ZERO);
+
+
+            //鍦ㄥ洯璁垮鏁伴噺
+            pcWorkPlatformDataVO.setInParkVisitUserNum(
+                    retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.TWO)&&Objects.isNull(i.getCompanyType())).count()
+            );
+            pcWorkPlatformDataVO.setVisitUserNum(Constants.ZERO);
+            pcWorkPlatformDataVO.setSignLevelNum(Constants.ZERO);
+
+            //鍦ㄥ洯杞﹁締
+            pcWorkPlatformDataVO.setTodayInParkCarNum(
+                    retentionList.stream().filter(i->Constants.equalsInteger(i.getType(),Constants.THREE)).count()
+            );
+            pcWorkPlatformDataVO.setTodayInCarNum(Constants.ZERO);
+            pcWorkPlatformDataVO.setTodayOutCarNum(Constants.ZERO);
+            if(Objects.nonNull(inoutDayCount)){
+                //鐩稿叧鏂�
+                pcWorkPlatformDataVO.setLwUserInNum(inoutDayCount.getInOtherMemberNum());
+                pcWorkPlatformDataVO.setLwUserOutNum(inoutDayCount.getOutOtherMemberNum());
+                //璁垮
+                pcWorkPlatformDataVO.setVisitUserNum(inoutDayCount.getInVisitorNum());
+                pcWorkPlatformDataVO.setSignLevelNum(inoutDayCount.getOutVisitorNum());
+                //杞﹁締
+                pcWorkPlatformDataVO.setTodayInCarNum(inoutDayCount.getInCarNum());
+                pcWorkPlatformDataVO.setTodayOutCarNum(inoutDayCount.getOutCarNum());
+                //鎬讳汉鏁�
+                pcWorkPlatformDataVO.setTodayInUserNum(pcWorkPlatformDataVO.getLwUserInNum() + pcWorkPlatformDataVO.getVisitUserNum() + inoutDayCount.getInSelfMemberNum() );
+                pcWorkPlatformDataVO.setTodayOutUserNum(pcWorkPlatformDataVO.getLwUserOutNum() + pcWorkPlatformDataVO.getSignLevelNum() + inoutDayCount.getOutSelfMemberNum() );
+            }
+
+        }else if(Constants.equalsInteger(queryType,Constants.TWO)){
+            List<String> weekDays = DateUtil.getBeforDays(new Date(),7);
+            List<InterestedListVO> weekVisitList = new ArrayList<>();
+            List<InterestedListVO> weekCarList = new ArrayList<>();
+            List<InterestedListVO> lwList = new ArrayList<>();
+
+            for (String days:weekDays) {
+                InoutDayCount inoutDayCount = inoutDayCountMapper.selectOne(new QueryWrapper<InoutDayCount>()
+                        .lambda()
+                        .apply(" DATE(TIME_INFO) = '"+days+"' ")
+                        .last("  limit 1  ")
+                );
+                InterestedListVO visitVO = new InterestedListVO();
+                visitVO.setName(days);
+                InterestedListVO carVO = new InterestedListVO();
+                carVO.setName(days);
+                if(Objects.isNull(inoutDayCount)){
+                    visitVO.setNum(Constants.ZERO);
+                    carVO.setNum(Constants.ZERO);
+                }else{
+                    visitVO.setNum(inoutDayCount.getInVisitorNum());
+                    carVO.setNum(inoutDayCount.getInCarNum());
+                }
+                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)
+            );
+
+            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()
+                                .in(Retention::getCompanyId,companyIds)
+                );
+                for (Company company:companyList) {
+                    Integer count = retentionList.stream().filter(i->Constants.equalsInteger(i.getCompanyId(),company.getId())).collect(Collectors.toList()).size();
+                    InterestedListVO lw = new InterestedListVO();
+                    lw.setNum(count);
+                    lw.setName(company.getName());
+                    lwList.add(lw);
+                }
+            }
+
+            pcWorkPlatformDataVO.setLwList(lwList   );
+        }else if(Constants.equalsInteger(queryType,Constants.THREE)) {
+            MPJLambdaWrapper<Notices> queryWrapper = new MPJLambdaWrapper<>();
+            queryWrapper.selectAll(Notices.class);
+            if (Objects.isNull(loginUserInfo.getMemberId())) {
+                queryWrapper.eq("1", "2");
+            } else {
+                queryWrapper.eq(Notices::getStatus, Constants.ZERO);
+                queryWrapper.eq(Notices::getSendacopy, Constants.ZERO);
+                queryWrapper.eq(Notices::getParam2, Constants.ZERO);
+                queryWrapper.eq(Notices::getUserId, loginUserInfo.getMemberId());
+            }
+            queryWrapper.orderByDesc(Notices::getCreateDate);
+            List<Notices> noticesList = noticesJoinMapper.selectList(queryWrapper);
+            pcWorkPlatformDataVO.setNoticesList(noticesList);
+            pcWorkPlatformDataVO.setNoticesNum(noticesList.size());
+            if(noticesList.size() > 5 ){
+                pcWorkPlatformDataVO.setNoticesList(noticesList.subList(0,5));
+            }else{
+                pcWorkPlatformDataVO.setNoticesList(noticesList);
+            }
+        }else{
+            String code= systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.TIMEOUT_WARNING).getCode();
+            MPJLambdaWrapper<Visits> queryWrapper = new MPJLambdaWrapper<>();
+            queryWrapper.selectAll(Visits.class);
+            queryWrapper.selectAs(Member::getName,Visits::getReceptMemberName);
+            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);
+            queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId);
+            queryWrapper.leftJoin(" member m on m.id= t.MEMBER_ID");
+            queryWrapper.eq(Visits::getStatus,Constants.VisitStatus.signin);
+            queryWrapper.apply(" TIMESTAMPDIFF( MINUTE, NOW(), t.OUT_DATE) <= "+code+"  ");
+            queryWrapper.ne("m.type ",Constants.TWO);
+            queryWrapper.eq(Visits::getIsdeleted,Constants.ZERO);
+            queryWrapper.orderByDesc(Visits::getEditDate);
+            List<Visits> result = visitsJoinMapper.selectList(queryWrapper);
+            if(result!=null&&result!=null){
+                result.stream().forEach(s ->{
+                    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);
+                        }
+                    }
+                });
+            }
+            pcWorkPlatformDataVO.setTimeOutVisitNum(result.size());
+            if(result.size() > 3 ){
+                pcWorkPlatformDataVO.setTimeOutVisitList(result.subList(0,3));
+            }else{
+                pcWorkPlatformDataVO.setTimeOutVisitList(result);
+            }
+
+
+        }
+
+
+
+
+        return pcWorkPlatformDataVO;
+    }
 }

--
Gitblit v1.9.3