productDev/dmvisit.git

			@@ -211,6 +211,9 @@
			insert.setHkId(UUID.randomUUID().toString().replace("-",""));
			insert.setHkStatus(Constants.ONE);
			insert.setSex(Constants.getSexByCardNo( member.getIdcardNo()));//根据身份证号获取性别
			insert.setJobDate(member.getJobDate());
			insert.setIsDangyuan(member.getIsDangyuan());
			insert.setPositionId(member.getPositionId());
			if(StringUtils.isNotBlank(member.getIdcardNo())){
			insert.setBirthday( DateUtil.fromStringToDate("yyyyMMdd",IdcardUtil.getBirthByIdCard(member.getIdcardNo())));
			insert.setIdcardNo(DESUtil.encrypt(Constants.EDS_PWD, member.getIdcardNo()));//身份证号加密
			@@ -1125,6 +1128,7 @@
			.selectAs(Company::getName,Member::getCompanyName) ;
			queryWrapper.selectAs(Position::getName,Member::getPositionName);
			queryWrapper.leftJoin(Position.class,Position::getId,Member::getPositionId);
			queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId);
			if(StringUtils.isNotBlank(member.getName())){
			queryWrapper.like(Member::getName,member.getName());
			}
			@@ -1139,6 +1143,12 @@
			}
			if(null != member.getCompanyId()) {
			queryWrapper.eq(Member::getCompanyId,member.getCompanyId());
			}
			if(null != member.getQuerySpecial() && Constants.equalsInteger(member.getQuerySpecial(),Constants.ONE)){
			String companySpecialId = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.SPECIAL_COMPANY_ID).getCode();
			if(StringUtils.isNotBlank(companySpecialId)){
			queryWrapper.apply(" find_in_set('"+companySpecialId+"',REPLACE(t3.company_path,'/',',')) ");
			}
			}
			queryWrapper.eq(Member::getIsdeleted,Constants.ZERO);
			queryWrapper.eq(Member::getWorkStatus,Constants.ZERO);
			@@ -1375,6 +1385,8 @@
			queryWrapper.selectAs(Company::getCompanyNamePath,Member::getCompanyNamePath);
			queryWrapper.selectAs(Company::getCompanyPath,Member::getCompanyPath);
			queryWrapper.select(" ( select count(1) from member_card mc where mc.isdeleted = 0 and mc.member_id = t.id ) as memberCardCount ");
			queryWrapper.select(" ( select max(tt.END_TIME) from train_time tt where tt.isdeleted = 0 and tt.member_id = t.id ) as trainEndTime ");

			queryWrapper.leftJoin(SystemUser.class,SystemUser::getId,Member::getEditor);
			queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId);
			queryWrapper.selectAs(Position::getName,Member::getPositionName);
			@@ -1450,6 +1462,19 @@
			if(StringUtils.isNotBlank(memberInfoDTO.getImgurl())){
			memberInfoDTO.setImgurlFull(prefixUrl + memberInfoDTO.getImgurl());
			}
			memberInfoDTO.setHasFace(memberInfoDTO.getFaceId()!=null?Constants.ONE:Constants.ZERO);
			if(Constants.equalsInteger(Constants.ONE,memberInfoDTO.getAuthStatus())){
			if(memberInfoDTO.getStartTime() ==null \|\| memberInfoDTO.getEndTime() ==null ){
			memberInfoDTO.setRoleTimeInfo("长期有效");
			}else{
			memberInfoDTO.setRoleTimeInfo(DateUtil.getPlusTime2(memberInfoDTO.getStartTime())+"至"+DateUtil.getPlusTime2(memberInfoDTO.getEndTime()));
			}
			}else{
			memberInfoDTO.setRoleTimeInfo("-");
			}
			memberInfoDTO.setAuthStatus(Constants.formatIntegerNum(memberInfoDTO.getAuthStatus()));
			memberInfoDTO.setWorkStatus(Constants.formatIntegerNum(memberInfoDTO.getWorkStatus()));
			memberInfoDTO.setSex(Constants.formatIntegerNum(memberInfoDTO.getSex()));
			}
			}
			return PageData.from(memberIPage);
			@@ -1629,9 +1654,11 @@
			}catch (Exception e){

			}
			List<Member> memberList = memberMapper.selectList(new QueryWrapper<Member>()
			.lambda().eq(Member::getIsdeleted,Constants.ZERO)
			.eq(Member::getType,Constants.memberType.internal)
			List<Member> memberList = memberJoinMapper.selectJoinList(Member.class,new MPJLambdaWrapper<Member>()
			.selectAll(Member.class)
			.leftJoin(Company.class,Company::getId,Member::getCompanyId)
			.eq(Member::getIsdeleted,Constants.ZERO)
			.eq(Company::getType,Constants.ZERO)
			.eq(Member::getStatus,Constants.ZERO)
			.isNotNull(Member::getHkId)
			.apply("to_days(LAST_VISIT_DATE)+ "+days+" < to_days(now())" ));