|  |  | 
 |  |  | 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.FacePictureCheckRequest; | 
 |  |  | 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.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.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; | 
 |  |  | import com.doumee.core.utils.*; | 
 |  |  | import com.doumee.core.wx.WXConstant; | 
 |  |  | import com.doumee.core.wx.wxPlat.WxPlatConstants; | 
 |  |  | 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.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; | 
 |  |  | import com.doumee.dao.business.model.*; | 
 |  |  |  | 
 |  |  | import com.doumee.dao.business.model.Member; | 
 |  |  | import com.doumee.dao.system.SystemUserMapper; | 
 |  |  | import com.doumee.dao.system.dto.ResetSystemUserPwdDTO; | 
 |  |  | import com.doumee.dao.system.join.NoticesJoinMapper; | 
 |  |  | 
 |  |  | 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; | 
 |  |  | 
 |  |  |  * @date 2023/11/30 15:33 | 
 |  |  |  */ | 
 |  |  | @Service | 
 |  |  | @Slf4j | 
 |  |  | public class VisitsServiceImpl implements VisitsService { | 
 |  |  |  | 
 |  |  |     @Autowired | 
 |  |  | 
 |  |  |     @Autowired | 
 |  |  |     private VisitsJoinMapper visitsMapper; | 
 |  |  |     @Autowired | 
 |  |  |     private UserActionMapper userActionMapper; | 
 |  |  |     @Autowired | 
 |  |  |     private ApproveMapper approveMapper; | 
 |  |  |     @Autowired | 
 |  |  |     private NoticesJoinMapper noticesJoinMapper; | 
 |  |  |     @Autowired | 
 |  |  |     private ApproveParamMapper approveParamMapper; | 
 |  |  |     @Autowired | 
 |  |  | 
 |  |  |     private SystemUserMapper systemUserMapper; | 
 |  |  |     @Autowired | 
 |  |  |     private ApproveService approveService; | 
 |  |  |     @Autowired | 
 |  |  |     private NoticesJoinMapper noticesJoinMapper; | 
 |  |  |     @Autowired | 
 |  |  |     private InoutDayCountMapper inoutDayCountMapper; | 
 |  |  |     @Autowired | 
 |  |  | 
 |  |  |             } | 
 |  |  |             if (Constants.equalsInteger(Constants.ZERO, erpVisitDTO.getIdcardType()) && erpVisitDTO.getIdcardNo().length() != 18 | 
 |  |  |                 //&&!IdcardUtil.isValidCard(visits.getIdcardNo()) | 
 |  |  |             ) { | 
 |  |  |             ){ | 
 |  |  |                 throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "对不起,身份证号码有误,请核实后重试!"); | 
 |  |  |             } | 
 |  |  |  | 
 |  |  |             Visits visits = new Visits(); | 
 |  |  |             //根据被访问人ERP主键查询系统内人员主键信息 | 
 |  |  |             Member member = memberMapper.selectOne(new QueryWrapper<Member>().lambda() | 
 |  |  | 
 |  |  |     @Override | 
 |  |  |     @Transactional(rollbackFor = {BusinessException.class,Exception.class}) | 
 |  |  |     public Integer createFk(Visits visits,Boolean isERP,Integer source) { | 
 |  |  |         visits.setId(null); | 
 |  |  |         isValidBaseParam(visits); | 
 |  |  |         //检查是否必须答题,并且符合答题要求 | 
 |  |  |         ProblemLog problemLog = isValidProblemLog(visits,source); | 
 |  |  | 
 |  |  |         }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(), "对不起,发起拜访审批申请失败!"); | 
 |  |  |         } | 
 |  |  | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         approveService.createApproveFlow(visits.getType(),visits.getId(),visits.getReceptMemberId()); | 
 |  |  |         approveService.createApproveFlow(visits.getType(),visits.getId(),visits.getReceptMemberId(),null); | 
 |  |  |         return visits.getId(); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  | 
 |  |  |             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())){ | 
 |  |  | 
 |  |  |         } | 
 |  |  |         //根据手机号和身份证号码查询 当前预约的时间是否与其他预约记录有冲突 | 
 |  |  |         if (visitsMapper.selectCount(new QueryWrapper<Visits>().lambda() | 
 |  |  |                         .eq(Visits::getIsdeleted,Constants.ZERO) | 
 |  |  |                         .notIn(Visits::getStatus,Constants.VisitStatus.cancel | 
 |  |  |                                 ,Constants.VisitStatus.noPass | 
 |  |  |                                 ,Constants.VisitStatus.xfFail | 
 |  |  | 
 |  |  |      */ | 
 |  |  |     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" ) | 
 |  |  | 
 |  |  |     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) { | 
 |  |  | 
 |  |  |         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){ | 
 |  |  | 
 |  |  |                 List<DeviceRole> deviceRoleList= deviceRoleMapper.selectList(deviceQuery); | 
 |  |  |                 result.setDeviceRoleList(deviceRoleList); | 
 |  |  |             } | 
 |  |  |         }else{ | 
 |  |  |             throw  new BusinessException(ResponseStatus.DATA_EMPTY); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         MPJLambdaWrapper<Visits> visitQuery = new MPJLambdaWrapper<>(); | 
 |  |  | 
 |  |  |         }else{ | 
 |  |  |             result.setBusinessStatus(result.getStatus()); | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |         Notices notices = noticesJoinMapper.selectOne(new QueryWrapper<Notices>().lambda() | 
 |  |  |                 .eq(Notices::getObjId,id) | 
 |  |  |                 .eq(Notices::getType,Constants.equalsInteger(result.getType(),Constants.TWO)?Constants.noticesObjectType.visitReporting:Constants.noticesObjectType.visit) | 
 |  |  |                 .eq(Notices::getUserId,memberId) | 
 |  |  |                 .eq(Notices::getSendacopy,Constants.ZERO) | 
 |  |  |                 .orderByDesc(Notices::getId).last(" limit 1 ")); | 
 |  |  |         if(Objects.nonNull(notices)){ | 
 |  |  |             if(Constants.equalsInteger(notices.getStatus(),Constants.ZERO)){ | 
 |  |  |                 result.setInfo("待我处理"); | 
 |  |  |             }else{ | 
 |  |  |                 result.setInfo(notices.getInfo()); | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |         return result; | 
 |  |  |     } | 
 |  |  | 
 |  |  |     @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()); | 
 |  |  | 
 |  |  |                             memberId) | 
 |  |  |             ); | 
 |  |  | //        } | 
 |  |  |         if(Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.waitCheck)||Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.submitCheck)){ | 
 |  |  |             Notices notices = noticesJoinMapper.selectOne(new QueryWrapper<Notices>().lambda().eq(Notices::getObjId,visits.getId()) | 
 |  |  |                     .eq(Notices::getType,Constants.equalsInteger(visits.getType(),Constants.TWO)?Constants.noticesObjectType.visitReporting:Constants.noticesObjectType.visit) | 
 |  |  |                     .eq(Notices::getUserId,memberId) | 
 |  |  |                     .eq(Notices::getSendacopy,Constants.ZERO) | 
 |  |  |                     .last(" limit 1 ") | 
 |  |  |             ); | 
 |  |  |             visitDetailVO.setInfoStatus(1); | 
 |  |  |             if(Objects.nonNull(notices)){ | 
 |  |  |                 visitDetailVO.setInfo(notices.getInfo()); | 
 |  |  |             }else{ | 
 |  |  |                 visitDetailVO.setInfo("暂无"); | 
 |  |  |             } | 
 |  |  |         }else if(Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.noPass)){ | 
 |  |  |             visitDetailVO.setInfoStatus(Constants.VisitStatus.noPass); | 
 |  |  |             visitDetailVO.setInfo("审批未通过"); | 
 |  |  |  | 
 |  |  |         }else if(Constants.equalsInteger(visits.getStatus(),Constants.VisitStatus.cancel)){ | 
 |  |  |             visitDetailVO.setInfoStatus(Constants.VisitStatus.cancel); | 
 |  |  |             visitDetailVO.setInfo("已取消"); | 
 |  |  |         }else{ | 
 |  |  |             visitDetailVO.setInfoStatus(Constants.VisitStatus.pass); | 
 |  |  |             visitDetailVO.setInfo("审批已通过"); | 
 |  |  |         Notices notices = noticesJoinMapper.selectOne(new QueryWrapper<Notices>().lambda() | 
 |  |  |                 .eq(Notices::getObjId,id) | 
 |  |  |                 .eq(Notices::getType,Constants.equalsInteger(visits.getType(),Constants.TWO)?Constants.noticesObjectType.visitReporting:Constants.noticesObjectType.visit) | 
 |  |  |                 .eq(Notices::getUserId,memberId) | 
 |  |  |                 .eq(Notices::getSendacopy,Constants.ZERO) | 
 |  |  |                 .orderByDesc(Notices::getId).last(" limit 1 ")); | 
 |  |  |         if(Objects.nonNull(notices)){ | 
 |  |  |             if(Constants.equalsInteger(notices.getStatus(),Constants.ZERO)){ | 
 |  |  |                 visitDetailVO.setInfo("待我处理"); | 
 |  |  |             }else{ | 
 |  |  |                 visitDetailVO.setInfo(notices.getInfo()); | 
 |  |  |             } | 
 |  |  |         } | 
 |  |  |  | 
 |  |  |         return visitDetailVO; | 
 |  |  |     } | 
 |  |  |  | 
 |  |  | 
 |  |  |             throw new BusinessException(ResponseStatus.DATA_EMPTY); | 
 |  |  |         } | 
 |  |  |         if(!visits.getStatus().equals(Constants.VisitStatus.signin)){ | 
 |  |  |             throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"访客记录状态错误,请刷新重试"); | 
 |  |  |             throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"仅支持【拜访中】状态进行该离场操作,请刷新重试"); | 
 |  |  |         } | 
 |  |  |         VisitAppointmentOutRequest request = new VisitAppointmentOutRequest(); | 
 |  |  |         request.setOrderId(visits.getHkId()); | 
 |  |  |         //调用海康强制签离 | 
 |  |  |         BaseResponse response =  HKService.outVisitAppiontment(request); | 
 |  |  |         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)); | 
 |  |  |         //产出在场人员信息 | 
 |  |  | 
 |  |  |         if(!visits.getStatus().equals(Constants.VisitStatus.xfSuccess)){ | 
 |  |  |             throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"访客记录状态错误,请刷新重试"); | 
 |  |  |         } | 
 |  |  |         VisitAppointmentOutRequest request = new VisitAppointmentOutRequest(); | 
 |  |  |         request.setOrderId(visits.getHkId()); | 
 |  |  |         VisitAppointmentCancelRequest request = new VisitAppointmentCancelRequest(); | 
 |  |  |         request.setAppointRecordIds(new String[]{visits.getHkId()}); | 
 |  |  |         //调用海康强制签离 | 
 |  |  |         BaseResponse response =  HKService.outVisitAppiontment(request); | 
 |  |  | //        BaseResponse response =  HKService.outVisitAppiontment(request); | 
 |  |  |         BaseResponse response =  HKService.iccmCancelAppointment(request); | 
 |  |  |         visitsMapper.update(null,new UpdateWrapper<Visits>().lambda().set(Visits::getStatus,Constants.VisitStatus.signout) | 
 |  |  |                 .eq(Visits::getId,visitId)); | 
 |  |  |         //产出在场人员信息 | 
 |  |  | 
 |  |  |         dto.setPassword(resetPasswordDTO.getPassword()); | 
 |  |  |         dto.setId(systemUser.getId()); | 
 |  |  |         dto.setOperaUserId(systemUser.getId()); | 
 |  |  |         dto.setNeedChangePwd(Constants.ONE); | 
 |  |  |         systemUserBiz.resetPwd(dto); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  | 
 |  |  |                             .selectAll(Retention.class) | 
 |  |  |                             .selectAs(Company::getType,Retention::getCompanyType) | 
 |  |  |                             .leftJoin(Company.class,Company::getId,Retention::getCompanyId) | 
 |  |  |                             .eq(Retention::getIsdeleted,Constants.ZERO) | 
 |  |  |             ); | 
 |  |  |  | 
 |  |  |             InoutDayCount inoutDayCount = inoutDayCountMapper.selectOne(new QueryWrapper<InoutDayCount>() | 
 |  |  | 
 |  |  |                 ); | 
 |  |  |                 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); | 
 |  |  |                     if(count>0){ | 
 |  |  |                         InterestedListVO lw = new InterestedListVO(); | 
 |  |  |                         lw.setNum(count); | 
 |  |  |                         lw.setName(company.getName()); | 
 |  |  |                         lwList.add(lw); | 
 |  |  |                     } | 
 |  |  |                 } | 
 |  |  |             } | 
 |  |  |  | 
 |  |  | 
 |  |  |  | 
 |  |  |  | 
 |  |  |     } | 
 |  |  |     @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())); | 
 |  |  |         //更新审批中的记录为取消 | 
 |  |  |         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) | 
 |  |  |         ); | 
 |  |  |     } | 
 |  |  |  | 
 |  |  |  | 
 |  |  | } |