public List<Country> getAllByWeekend(Country country) { if (country.getPage() != null && country.getRows() != null) { PageHelper.startPage(country.getPage(), country.getRows()); } Weekend<Country> weekend = Weekend.of(Country.class); WeekendCriteria<Country, Object> criteria = weekend.weekendCriteria(); if (country.getCountryname() != null && country.getCountryname().length() > 0) { criteria.andLike(Country::getCountryname, "%" + country.getCountryname() + "%"); } if (country.getCountrycode() != null && country.getCountrycode().length() > 0) { criteria.andLike(Country::getCountrycode, "%" + country.getCountrycode() + "%"); } return countryMapper.selectByExample(weekend); }
criteria.andLike(Log::getUsername, "%" + log.getUsername() + "%"); criteria.andLike(Log::getIp, "%" + log.getIp() + "%"); criteria.andLike(Log::getReqMethod, "%" + log.getReqMethod() + "%"); criteria.andLike(Log::getExecMethod, "%" + log.getExecMethod() + "%"); criteria.andLike(Log::getExecDesc, "%" + log.getExecDesc() + "%"); criteria.andLike(Log::getStatus, "%" + log.getStatus() + "%");
@Override public PageResultSet<RoleDto> findByPage(RoleQuery roleQuery) { PageHelper.offsetPage(roleQuery.getOffset(), roleQuery.getLimit()); if(!StringUtils.isEmpty(roleQuery.getOrderBy())) { PageHelper.orderBy(roleQuery.getOrderBy()); } Weekend<Role> example = Weekend.of(Role.class); WeekendCriteria<Role, Object> criteria = example.weekendCriteria(); if(!StringUtils.isEmpty(roleQuery.getRole())) { criteria.andLike(Role::getRole,"%" + roleQuery.getRole() + "%"); } if(!StringUtils.isEmpty(roleQuery.getDescription())) { criteria.andLike(Role::getDescription,"%" + roleQuery.getDescription() + "%"); } PageResultSet<RoleDto> resultSet = new PageResultSet<>(); List<RoleDto> dtoList = new ArrayList<>(); roleMapper.selectByExample(example).forEach(r -> { RoleDto dto = new RoleDto(r); dto.setResourceNames(getResourceNames(r.getResourceIdList())); dtoList.add(dto); }); long total = roleMapper.selectCountByExample(example); resultSet.setRows(dtoList); resultSet.setTotal(total); return resultSet; }
@Override public PageResultSet<Group> findByPage(GroupQuery groupQuery) { if (!StringUtils.isEmpty(groupQuery.getOrderBy())) { PageHelper.orderBy(groupQuery.getOrderBy()); } Weekend<Group> weekend = Weekend.of(Group.class); WeekendCriteria<Group, Object> criteria = weekend.weekendCriteria(); if (!StringUtils.isEmpty(groupQuery.getName())) { criteria.andLike(Group::getName, groupQuery.getName()); } PageResultSet<Group> resultSet = new PageResultSet<>(); Page page = PageHelper.offsetPage(groupQuery.getOffset(), groupQuery.getLimit()).doSelectPage(() -> groupMapper.selectByExample(weekend)); resultSet.setRows(page); resultSet.setTotal(page.getTotal()); return resultSet; }
@Override public PageResultSet<UserDto> findByPage(UserQuery userQuery) { if(!StringUtils.isEmpty(userQuery.getOrderBy())) { PageHelper.orderBy(userQuery.getOrderBy()); } Weekend<User> example = Weekend.of(User.class); WeekendCriteria<User, Object> criteria = example.weekendCriteria(); if (!StringUtils.isEmpty(userQuery.getUsername())) { criteria.andLike(User::getUsername, "%" + userQuery.getUsername() + "%"); } if(userQuery.getLocked() != null) { criteria.andEqualTo(User::getLocked,userQuery.getLocked()); } List<UserDto> dtoList = new ArrayList<>(); PageHelper.offsetPage(userQuery.getOffset(), userQuery.getLimit()); userMapper.selectByExample(example).forEach(u -> { UserDto dto = new UserDto(u); dto.setOrganizationName(getOrganizationName(Long.valueOf(dto.getOrganizationId()))); dto.setRoleNames(getRoleNames(dto.getRoleIdList())); dto.setGroupNames(getGroupNames(dto.getGroupIdList())); dtoList.add(dto); }); long total = userMapper.selectCountByExample(example); PageResultSet<UserDto> resultSet = new PageResultSet<>(); resultSet.setRows(dtoList); resultSet.setTotal(total); return resultSet; }