| | |
| | | .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) |
| | |
| | | public Integer getMemberIdByCode(String code){ |
| | | JkIccard jkIccard = jkIccardMapper.selectOne(new QueryWrapper<JkIccard>().lambda() |
| | | .eq(JkIccard::getIsdeleted,Constants.ZERO) |
| | | .eq(JkIccard::getStatus,Constants.ZERO) |
| | | .eq(JkIccard::getStatus,Constants.ONE) |
| | | .eq(JkIccard::getCode,code) |
| | | .last(" limit 1 ") |
| | | ); |