|  |  |  | 
|---|
|  |  |  | .leftJoin(Member.class,Member::getId,JkIccard::getMemberId) | 
|---|
|  |  |  | .eq(JkIccard::getIsdeleted,Constants.ZERO) | 
|---|
|  |  |  | .eq(Objects.nonNull(model.getStatus()),JkIccard::getStatus,model.getStatus()) | 
|---|
|  |  |  | .eq(Objects.nonNull(model.getUserType()),JkIccard::getUserType,model.getUserType()) | 
|---|
|  |  |  | .like(StringUtils.isNotBlank(model.getCode()),JkIccard::getCode,model.getCode()) | 
|---|
|  |  |  | .like(StringUtils.isNotBlank(model.getMemberName()),Member::getName,model.getMemberName()) | 
|---|
|  |  |  | .orderByDesc(JkIccard::getCreateDate) | 
|---|
|  |  |  | 
|---|
|  |  |  | } | 
|---|
|  |  |  |  | 
|---|
|  |  |  |  | 
|---|
|  |  |  | @Override | 
|---|
|  |  |  | public Integer getMemberIdByCode(String code){ | 
|---|
|  |  |  | JkIccard jkIccard = jkIccardMapper.selectOne(new QueryWrapper<JkIccard>().lambda() | 
|---|
|  |  |  | .eq(JkIccard::getIsdeleted,Constants.ZERO) | 
|---|
|  |  |  | .eq(JkIccard::getStatus,Constants.ONE) | 
|---|
|  |  |  | .eq(JkIccard::getCode,code) | 
|---|
|  |  |  | .last(" limit 1 ") | 
|---|
|  |  |  | ); | 
|---|
|  |  |  | if(Objects.isNull(jkIccard)){ | 
|---|
|  |  |  | throw new BusinessException(ResponseStatus.DATA_EMPTY); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | return jkIccard.getMemberId(); | 
|---|
|  |  |  |  | 
|---|
|  |  |  | } | 
|---|
|  |  |  |  | 
|---|
|  |  |  |  | 
|---|
|  |  |  | } | 
|---|