| | |
| | | import cn.hutool.core.util.IdcardUtil; |
| | | import com.doumee.biz.system.SystemDictDataBiz; |
| | | import com.doumee.core.constants.ResponseStatus; |
| | | import com.doumee.core.erp.ErpConstants; |
| | | import com.doumee.core.erp.ErpTool; |
| | | import com.doumee.core.erp.model.openapi.request.erp.ApproveAddRequest; |
| | | import com.doumee.core.erp.model.openapi.request.erp.UserInfoRequest; |
| | | 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.HKTools; |
| | |
| | | import com.doumee.core.model.PageWrap; |
| | | import com.doumee.core.utils.Constants; |
| | | import com.doumee.core.utils.DESUtil; |
| | | import com.doumee.core.utils.DateUtil; |
| | | import com.doumee.core.utils.Utils; |
| | | import com.doumee.dao.admin.response.MemberInfoDTO; |
| | | import com.doumee.dao.business.DeviceRoleMapper; |
| | | import com.doumee.dao.business.MemberMapper; |
| | | import com.doumee.dao.business.ProblemLogMapper; |
| | | import com.doumee.dao.business.VisitsMapper; |
| | | import com.doumee.dao.business.model.DeviceRole; |
| | | import com.doumee.dao.business.model.Member; |
| | | import com.doumee.dao.business.model.ProblemLog; |
| | | import com.doumee.dao.business.model.Visits; |
| | | import com.doumee.dao.business.join.DeviceJoinMapper; |
| | | import com.doumee.dao.business.join.VisitsJoinMapper; |
| | | import com.doumee.dao.business.model.*; |
| | | import com.doumee.service.business.VisitsService; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | 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.Transactional; |
| | | import org.springframework.util.CollectionUtils; |
| | | import org.springframework.util.DigestUtils; |
| | | |
| | | import java.util.ArrayList; |
| | | import java.util.Arrays; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.*; |
| | | import java.util.stream.Collectors; |
| | | |
| | | /** |
| | | * 访客申请信息表Service实现 |
| | |
| | | private ProblemLogMapper problemLogMapper ; |
| | | @Autowired |
| | | private MemberMapper memberMapper ; |
| | | @Autowired |
| | | private VisitsJoinMapper visitsJoinMapper; |
| | | |
| | | @Autowired |
| | | private SystemDictDataBiz systemDictDataBiz; |
| | | @Autowired |
| | | private DeviceJoinMapper deviceJoinMapper; |
| | | |
| | | |
| | | @Override |
| | | public Integer create(Visits visits) { |
| | | visitsMapper.insert(visits); |
| | |
| | | //获取申请的海康访问门禁组信息 |
| | | String[] hkIds = getHkDeviceRoles(visits); |
| | | //检验拜访人是否合法 |
| | | isValideVisitedUser(visits.getReceptMemberId()); |
| | | //检查随访人员是否合法,生成随访人员新增集合 |
| | | List<Member> withUsers = isValideWithUsers(visits.getWithUserList()); |
| | | |
| | | Member visitMember = isValideVisitedUser(visits.getReceptMemberId()); |
| | | if(Constants.equalsInteger(Constants.ZERO, visits.getIdcardType()) &&!IdcardUtil.isValidCard(visits.getIdcardNo())){ |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(), "对不起,身份证号码有误,请核实后重试!"); |
| | | } |
| | | Date date = new Date(); |
| | | //访客信息(使用身份证号查询是否已存在改普通访客,没有则新增,存在则更新openid等信息) |
| | | //访客信息(使用身份证号查询是否已存在改普通访客,没有则新增,存在则更新openid等信息),包括随访人员校验和处理 |
| | | Member member =dealMemberAndVisits(visits); |
| | | //初始化访客信息 |
| | | initVisitInfo(visits,date); |
| | | //发起ERP审批申请 |
| | | String erpid = startSendErpCheck(visits); |
| | | if(StringUtils.isNotBlank(erpid)){ |
| | | visits.setErpId(erpid); |
| | | String erpId = startSendErpCheck(visits,visitMember); |
| | | if(StringUtils.isNotBlank(erpId)){ |
| | | visits.setErpId(erpId); |
| | | }else{ |
| | | throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(), "对不起,发起拜访审批申请失败!"); |
| | | } |
| | |
| | | visits.setCreateDate(date); |
| | | } |
| | | |
| | | private String startSendErpCheck(Visits visits) { |
| | | private String startSendErpCheck(Visits visits,Member visitMember) { |
| | | ApproveAddRequest param = new ApproveAddRequest(); |
| | | List<Visits> withUserVisitsList = visits.getWithUserList(); |
| | | List<UserInfoRequest> withUserList = new ArrayList<>(); |
| | | if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(withUserVisitsList)){ |
| | | for (Visits v:withUserVisitsList) { |
| | | UserInfoRequest userInfoRequest = new UserInfoRequest(); |
| | | userInfoRequest.setName(v.getName()); |
| | | userInfoRequest.setIdNo(v.getIdcardNo()); |
| | | userInfoRequest.setSex(v.getSex()); |
| | | userInfoRequest.setPhone(v.getPhone()); |
| | | userInfoRequest.setFaceImg(v.getFaceImg()); |
| | | userInfoRequest.setHealthImg(v.getImgurl()); |
| | | withUserList.add(userInfoRequest); |
| | | } |
| | | param.setWithUserList(withUserList); |
| | | } |
| | | param.setId(visits.getId()); |
| | | param.setBeVisitedUserId(visitMember.getErpId()); |
| | | param.setVisitorWorkUint(visits.getCompanyName()); |
| | | param.setPurpose(visits.getReason()); |
| | | param.setStartTime(DateUtil.getDate(visits.getStarttime(),"yyyy-MM-dd HH:mm:ss")); |
| | | param.setEndTime(DateUtil.getDate(visits.getEndtime(),"yyyy-MM-dd HH:mm:ss")); |
| | | if(StringUtils.isNotBlank(visits.getCarNos())){ |
| | | param.setCarNo(Arrays.asList(visits.getCarNos().split(","))); |
| | | } |
| | | if(StringUtils.isNotBlank(visits.getDoors())){ |
| | | List<DeviceRole> deviceRoleList = deviceRoleMapper.selectList(new QueryWrapper<DeviceRole>().lambda().in(DeviceRole::getId,Arrays.asList(visits.getDoors().split(",")))); |
| | | if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(deviceRoleList)){ |
| | | param.setRoleIds(deviceRoleList.stream().map(m->m.getId()).collect(Collectors.toList())); |
| | | param.setRoleNames(deviceRoleList.stream().map(m->m.getName()).collect(Collectors.toList())); |
| | | } |
| | | } |
| | | ApproveInfoResponse response = ErpTool.submitApprove(ErpConstants.approveUrl,param); |
| | | if(!Objects.isNull(response)){ |
| | | return response.getId().toString(); |
| | | } |
| | | return null; |
| | | } |
| | | |
| | | private String visitAppiontment(Visits visits) { |
| | | VisitAppointmentRequest param = new VisitAppointmentRequest(); |
| | | param.setVisitStartTime(HKTools.getISO8601Timestamp(visits.getStarttime())); |
| | | param.setVisitEndTime(HKTools.getISO8601Timestamp(visits.getStarttime())); |
| | | param.setVisitStartTime(DateUtil.getISO8601Timestamp(visits.getStarttime())); |
| | | param.setVisitEndTime(DateUtil.getISO8601Timestamp(visits.getStarttime())); |
| | | BaseResponse<VisitAppointmentResponse> res = HKService.visitAppiontment(param); |
| | | if(res==null || !StringUtils.equals(res.getCode(), HKConstants.RESPONSE_SUCCEE) || res.getData()==null){ |
| | | //如果发起预约失败 |
| | |
| | | } |
| | | |
| | | /** |
| | | * 校驗申請人信息,有则修改,无则新增,并绑定最新openid数据 |
| | | * 访客信息(使用身份证号查询是否已存在改普通访客,没有则新增,存在则更新openid等信息),包括随访人员校验和处理 |
| | | * @param visits |
| | | * @return |
| | | */ |
| | |
| | | member.setOpenid(visits.getOpenid()); |
| | | member.setType(Constants.memberType.visitor); |
| | | member.setStatus(Constants.ZERO); |
| | | member.setSex(visits.getSex()); |
| | | member.setSex(Constants.getSexByCardNo(cardno)); |
| | | // 新增访客记录 |
| | | addList.add(member); |
| | | }else{ |
| | |
| | | member.setName(visits.getName()); |
| | | member.setPhone(visits.getPhone()); |
| | | member.setOpenid(visits.getOpenid()); |
| | | member.setSex(visits.getSex()); |
| | | member.setSex(Constants.getSexByCardNo(cardno)); |
| | | // 更新访客信息, |
| | | editList.add(member); |
| | | } |
| | | //根据手机号和身份证号码查询 当前预约的时间是否与其他预约记录有冲突 |
| | | if (visitsMapper.selectCount(new QueryWrapper<Visits>().lambda() |
| | | .eq(Visits::getPhone, member.getPhone()) |
| | | .and(ms -> ms.eq(Visits::getPhone, member.getPhone()) |
| | | .or().eq(Visits::getIdcardDecode, member.getIdcardDecode())) |
| | | .and(ms -> ms.apply(" visits.STARTTIME <= '" + visits.getStarttime() + "' and visits.ENDTIME >= '" + visits.getStarttime() + "' ") |
| | | .or().apply(" visits.STARTTIME <= '" + visits.getEndtime() + "' and visits.ENDTIME >= '" + visits.getEndtime() + "' ") |
| | | )) > Constants.ZERO) { |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "对不起,手机号【"+member.getPhone()+"】或身份证【"+ member.getIdcardDecode() +"】存在预约时间冲突,无法申请哦!"); |
| | | } |
| | | return member; |
| | | } |
| | |
| | | if(v !=null){ |
| | | throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(), "对不起,手机号【"+member.getPhone()+"】存在未签离预约申请,不能重复申请哦!"); |
| | | } |
| | | |
| | | |
| | | |
| | | } |
| | | |
| | | private List<Member> isValideWithUsers(List<Visits> withUserList) { |
| | |
| | | |
| | | @Override |
| | | public Visits findById(Integer id) { |
| | | return visitsMapper.selectById(id); |
| | | |
| | | MPJLambdaWrapper<Visits> queryWrapper = new MPJLambdaWrapper<>(); |
| | | queryWrapper.selectAll(Visits.class); |
| | | queryWrapper.selectAs(Member::getName,Visits::getReceptMemberName); |
| | | queryWrapper.selectAs(Company::getName,Visits::getReceptMemberDepartment); |
| | | queryWrapper.leftJoin(Member.class,Member::getId,Visits::getReceptMemberId); |
| | | queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId); |
| | | |
| | | queryWrapper.eq(Visits::getId,id); |
| | | Visits result = visitsJoinMapper.selectJoinOne(Visits.class,queryWrapper); |
| | | |
| | | if(result!=null){ |
| | | if(StringUtils.isNotBlank(result.getDoors())){ |
| | | String[] doorList=result.getDoors().split(","); |
| | | MPJLambdaWrapper<Device> deviceQuery = new MPJLambdaWrapper<>(); |
| | | deviceQuery.in(Device::getId,doorList); |
| | | List<Device> deviceList= deviceJoinMapper.selectList(deviceQuery); |
| | | result.setDeviceList(deviceList); |
| | | } |
| | | } |
| | | |
| | | MPJLambdaWrapper<Visits> visitQuery = new MPJLambdaWrapper<>(); |
| | | visitQuery.selectAll(Visits.class); |
| | | visitQuery.eq(Visits::getParentId,result.getId()); |
| | | visitQuery.isNotNull(Visits::getParentId); |
| | | visitQuery.eq(Visits::getIsdeleted,Constants.ZERO); |
| | | List<Visits> visitsList = visitsJoinMapper.selectList(visitQuery); |
| | | Visits v = new Visits(); |
| | | BeanUtils.copyProperties(result,v); |
| | | visitsList.add(0,v); |
| | | result.setWithUserList(visitsList); |
| | | return result; |
| | | } |
| | | |
| | | @Override |
| | |
| | | @Override |
| | | public PageData<Visits> findPage(PageWrap<Visits> pageWrap) { |
| | | IPage<Visits> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); |
| | | QueryWrapper<Visits> queryWrapper = new QueryWrapper<>(); |
| | | Utils.MP.blankToNull(pageWrap.getModel()); |
| | | if (pageWrap.getModel().getId() != null) { |
| | | queryWrapper.lambda().eq(Visits::getId, pageWrap.getModel().getId()); |
| | | } |
| | | if (pageWrap.getModel().getCreator() != null) { |
| | | queryWrapper.lambda().eq(Visits::getCreator, pageWrap.getModel().getCreator()); |
| | | } |
| | | if (pageWrap.getModel().getCreateDate() != null) { |
| | | queryWrapper.lambda().ge(Visits::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())); |
| | | queryWrapper.lambda().le(Visits::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())); |
| | | } |
| | | if (pageWrap.getModel().getEditor() != null) { |
| | | queryWrapper.lambda().eq(Visits::getEditor, pageWrap.getModel().getEditor()); |
| | | } |
| | | if (pageWrap.getModel().getEditDate() != null) { |
| | | queryWrapper.lambda().ge(Visits::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())); |
| | | queryWrapper.lambda().le(Visits::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())); |
| | | } |
| | | if (pageWrap.getModel().getIsdeleted() != null) { |
| | | queryWrapper.lambda().eq(Visits::getIsdeleted, pageWrap.getModel().getIsdeleted()); |
| | | } |
| | | if (pageWrap.getModel().getRemark() != null) { |
| | | queryWrapper.lambda().eq(Visits::getRemark, pageWrap.getModel().getRemark()); |
| | | } |
| | | if (pageWrap.getModel().getMemberId() != null) { |
| | | queryWrapper.lambda().eq(Visits::getMemberId, pageWrap.getModel().getMemberId()); |
| | | } |
| | | if (pageWrap.getModel().getCompanyId() != null) { |
| | | queryWrapper.lambda().eq(Visits::getCompanyId, pageWrap.getModel().getCompanyId()); |
| | | } |
| | | if (pageWrap.getModel().getFaceImg() != null) { |
| | | queryWrapper.lambda().eq(Visits::getFaceImg, pageWrap.getModel().getFaceImg()); |
| | | } |
| | | if (pageWrap.getModel().getImgurl() != null) { |
| | | queryWrapper.lambda().eq(Visits::getImgurl, pageWrap.getModel().getImgurl()); |
| | | } |
| | | if (pageWrap.getModel().getType() != null) { |
| | | queryWrapper.lambda().eq(Visits::getType, pageWrap.getModel().getType()); |
| | | } |
| | | if (pageWrap.getModel().getName() != null) { |
| | | queryWrapper.lambda().eq(Visits::getName, pageWrap.getModel().getName()); |
| | | } |
| | | if (pageWrap.getModel().getBirthday() != null) { |
| | | queryWrapper.lambda().ge(Visits::getBirthday, Utils.Date.getStart(pageWrap.getModel().getBirthday())); |
| | | queryWrapper.lambda().le(Visits::getBirthday, Utils.Date.getEnd(pageWrap.getModel().getBirthday())); |
| | | } |
| | | if (pageWrap.getModel().getPhone() != null) { |
| | | queryWrapper.lambda().eq(Visits::getPhone, pageWrap.getModel().getPhone()); |
| | | } |
| | | if (pageWrap.getModel().getCompanyName() != null) { |
| | | queryWrapper.lambda().eq(Visits::getCompanyName, pageWrap.getModel().getCompanyName()); |
| | | } |
| | | if (pageWrap.getModel().getIdcardNo() != null) { |
| | | queryWrapper.lambda().eq(Visits::getIdcardNo, pageWrap.getModel().getIdcardNo()); |
| | | } |
| | | if (pageWrap.getModel().getCode() != null) { |
| | | queryWrapper.lambda().eq(Visits::getCode, pageWrap.getModel().getCode()); |
| | | } |
| | | if (pageWrap.getModel().getClasses() != null) { |
| | | queryWrapper.lambda().eq(Visits::getClasses, pageWrap.getModel().getClasses()); |
| | | } |
| | | if (pageWrap.getModel().getMemberNum() != null) { |
| | | queryWrapper.lambda().eq(Visits::getMemberNum, pageWrap.getModel().getMemberNum()); |
| | | } |
| | | if (pageWrap.getModel().getStarttime() != null) { |
| | | queryWrapper.lambda().ge(Visits::getStarttime, Utils.Date.getStart(pageWrap.getModel().getStarttime())); |
| | | queryWrapper.lambda().le(Visits::getStarttime, Utils.Date.getEnd(pageWrap.getModel().getStarttime())); |
| | | } |
| | | if (pageWrap.getModel().getEndtime() != null) { |
| | | queryWrapper.lambda().ge(Visits::getEndtime, Utils.Date.getStart(pageWrap.getModel().getEndtime())); |
| | | queryWrapper.lambda().le(Visits::getEndtime, Utils.Date.getEnd(pageWrap.getModel().getEndtime())); |
| | | } |
| | | if (pageWrap.getModel().getReason() != null) { |
| | | queryWrapper.lambda().eq(Visits::getReason, pageWrap.getModel().getReason()); |
| | | } |
| | | if (pageWrap.getModel().getDoorSelect() != null) { |
| | | queryWrapper.lambda().eq(Visits::getDoorSelect, pageWrap.getModel().getDoorSelect()); |
| | | } |
| | | if (pageWrap.getModel().getDoors() != null) { |
| | | queryWrapper.lambda().eq(Visits::getDoors, pageWrap.getModel().getDoors()); |
| | | } |
| | | if (pageWrap.getModel().getReceptMemberId() != null) { |
| | | queryWrapper.lambda().eq(Visits::getReceptMemberId, pageWrap.getModel().getReceptMemberId()); |
| | | } |
| | | if (pageWrap.getModel().getStatus() != null) { |
| | | queryWrapper.lambda().eq(Visits::getStatus, pageWrap.getModel().getStatus()); |
| | | } |
| | | if (pageWrap.getModel().getCheckorId() != null) { |
| | | queryWrapper.lambda().eq(Visits::getCheckorId, pageWrap.getModel().getCheckorId()); |
| | | } |
| | | if (pageWrap.getModel().getCheckDate() != null) { |
| | | queryWrapper.lambda().ge(Visits::getCheckDate, Utils.Date.getStart(pageWrap.getModel().getCheckDate())); |
| | | queryWrapper.lambda().le(Visits::getCheckDate, Utils.Date.getEnd(pageWrap.getModel().getCheckDate())); |
| | | } |
| | | if (pageWrap.getModel().getCheckInfo() != null) { |
| | | queryWrapper.lambda().eq(Visits::getCheckInfo, pageWrap.getModel().getCheckInfo()); |
| | | } |
| | | if (pageWrap.getModel().getEndCheckorId() != null) { |
| | | queryWrapper.lambda().eq(Visits::getEndCheckorId, pageWrap.getModel().getEndCheckorId()); |
| | | } |
| | | if (pageWrap.getModel().getEndCheckDate() != null) { |
| | | queryWrapper.lambda().ge(Visits::getEndCheckDate, Utils.Date.getStart(pageWrap.getModel().getEndCheckDate())); |
| | | queryWrapper.lambda().le(Visits::getEndCheckDate, Utils.Date.getEnd(pageWrap.getModel().getEndCheckDate())); |
| | | } |
| | | if (pageWrap.getModel().getEndCheckInfo() != null) { |
| | | queryWrapper.lambda().eq(Visits::getEndCheckInfo, pageWrap.getModel().getEndCheckInfo()); |
| | | } |
| | | if (pageWrap.getModel().getIdcardType() != null) { |
| | | queryWrapper.lambda().eq(Visits::getIdcardType, pageWrap.getModel().getIdcardType()); |
| | | } |
| | | if (pageWrap.getModel().getCarNos() != null) { |
| | | queryWrapper.lambda().eq(Visits::getCarNos, pageWrap.getModel().getCarNos()); |
| | | } |
| | | if (pageWrap.getModel().getParentId() != null) { |
| | | queryWrapper.lambda().eq(Visits::getParentId, pageWrap.getModel().getParentId()); |
| | | } |
| | | if (pageWrap.getModel().getUserAnswerId() != null) { |
| | | queryWrapper.lambda().eq(Visits::getUserAnswerId, pageWrap.getModel().getUserAnswerId()); |
| | | } |
| | | if (pageWrap.getModel().getHkId() != null) { |
| | | queryWrapper.lambda().eq(Visits::getHkId, pageWrap.getModel().getHkId()); |
| | | } |
| | | if (pageWrap.getModel().getHkStatus() != null) { |
| | | queryWrapper.lambda().eq(Visits::getHkStatus, pageWrap.getModel().getHkStatus()); |
| | | } |
| | | if (pageWrap.getModel().getHkDate() != null) { |
| | | queryWrapper.lambda().ge(Visits::getHkDate, Utils.Date.getStart(pageWrap.getModel().getHkDate())); |
| | | queryWrapper.lambda().le(Visits::getHkDate, Utils.Date.getEnd(pageWrap.getModel().getHkDate())); |
| | | } |
| | | if (pageWrap.getModel().getErpId() != null) { |
| | | queryWrapper.lambda().eq(Visits::getErpId, pageWrap.getModel().getErpId()); |
| | | } |
| | | for(PageWrap.SortData sortData: pageWrap.getSorts()) { |
| | | if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { |
| | | queryWrapper.orderByDesc(sortData.getProperty()); |
| | | } else { |
| | | queryWrapper.orderByAsc(sortData.getProperty()); |
| | | } |
| | | } |
| | | return PageData.from(visitsMapper.selectPage(page, queryWrapper)); |
| | | MPJLambdaWrapper<Visits> queryWrapper = new MPJLambdaWrapper<>(); |
| | | |
| | | queryWrapper.selectAll(Visits.class); |
| | | queryWrapper.selectAs(Member::getName,Visits::getReceptMemberName); |
| | | queryWrapper.selectAs(Company::getName,Visits::getReceptMemberDepartment); |
| | | queryWrapper.leftJoin(Member.class,Member::getId,Visits::getReceptMemberId); |
| | | queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId); |
| | | |
| | | queryWrapper.eq(Visits::getIsdeleted,Constants.ZERO); |
| | | queryWrapper.eq(Objects.nonNull(pageWrap.getModel().getType()),Visits::getType,pageWrap.getModel().getType()); |
| | | queryWrapper.and(StringUtils.isNotBlank(pageWrap.getModel().getName()),ms->ms.like(Visits::getPhone,pageWrap.getModel().getName()) |
| | | .or().like(Visits::getPhone,pageWrap.getModel().getName())) |
| | | .eq(StringUtils.isNotBlank(pageWrap.getModel().getIdcardNo()),Visits::getIdcardNo,StringUtils.isNotBlank(pageWrap.getModel().getIdcardNo())) |
| | | .eq(StringUtils.isNotBlank(pageWrap.getModel().getCompanyName()),Visits::getCompanyName,pageWrap.getModel().getCompanyName()) |
| | | .eq(Objects.nonNull(pageWrap.getModel().getStatus()),Visits::getStatus,pageWrap.getModel().getStatus()); |
| | | queryWrapper.isNull(Visits::getParentId); |
| | | queryWrapper.orderByDesc(Visits::getCreateDate); |
| | | IPage<Visits> result = visitsJoinMapper.selectJoinPage(page, Visits.class,queryWrapper); |
| | | return PageData.from(result); |
| | | } |
| | | |
| | | @Override |
| | |
| | | QueryWrapper<Visits> wrapper = new QueryWrapper<>(visits); |
| | | return visitsMapper.selectCount(wrapper); |
| | | } |
| | | |
| | | |
| | | @Override |
| | | public PageData<Visits> retentionPage(PageWrap<Visits> pageWrap) { |
| | | IPage<Visits> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); |
| | | MPJLambdaWrapper<Visits> queryWrapper = new MPJLambdaWrapper<>(); |
| | | |
| | | queryWrapper.selectAll(Visits.class); |
| | | queryWrapper.selectAs(Member::getName,Visits::getReceptMemberName); |
| | | queryWrapper.select("TIMESTAMPDIFF(MINUTE,t.ENDTIME , NOW()) AS timeOut"); |
| | | queryWrapper.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.ne("m.type ",Constants.TWO); |
| | | queryWrapper.eq(Visits::getIsdeleted,Constants.ZERO); |
| | | queryWrapper.eq(Objects.nonNull(pageWrap.getModel().getType()),Visits::getType,pageWrap.getModel().getType()); |
| | | queryWrapper.and(StringUtils.isNotBlank(pageWrap.getModel().getName()),ms->ms.like(Visits::getPhone,pageWrap.getModel().getName()) |
| | | .or().like(Visits::getPhone,pageWrap.getModel().getName())) |
| | | .eq(StringUtils.isNotBlank(pageWrap.getModel().getIdcardNo()),Visits::getIdcardNo,StringUtils.isNotBlank(pageWrap.getModel().getIdcardNo())) |
| | | .eq(StringUtils.isNotBlank(pageWrap.getModel().getCompanyName()),Visits::getCompanyName,pageWrap.getModel().getCompanyName()) |
| | | .eq(Objects.nonNull(pageWrap.getModel().getStatus()),Visits::getStatus,pageWrap.getModel().getStatus()); |
| | | queryWrapper.isNull(Visits::getOutDate); |
| | | queryWrapper.orderByDesc(Visits::getEditDate); |
| | | String code= systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.TIMEOUT_FREEZE).getCode(); |
| | | IPage<Visits> result = visitsJoinMapper.selectJoinPage(page, Visits.class,queryWrapper); |
| | | if(result!=null&&result.getRecords()!=null){ |
| | | result.getRecords().stream().forEach(s ->{ |
| | | if(s.getTimeOut()>=Constants.ZERO){ |
| | | s.setOutStatus(Constants.ONE); |
| | | }else if(s.getTimeOut()<=Integer.valueOf(code)&&s.getTimeOut()>0){ |
| | | s.setOutStatus(Constants.TWO); |
| | | }else{ |
| | | s.setOutStatus(Constants.ZERO); |
| | | } |
| | | |
| | | }); |
| | | } |
| | | |
| | | return PageData.from(result); |
| | | } |
| | | |
| | | } |