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