Example usage for org.apache.ibatis.session RowBounds RowBounds

Introduction

In this page you can find the example usage for org.apache.ibatis.session RowBounds RowBounds.

Prototype

public RowBounds(int offset, int limit)

Source Link

Usage

From source file:com.esofthead.mycollab.core.persistence.service.DefaultSearchService.java

License:Open Source License

@Override
public List findAbsoluteListByCriteria(S searchCriteria, int firstIndex, int numberOftems) {
    return getSearchMapper().findPagableListByCriteria(searchCriteria, new RowBounds(firstIndex, numberOftems));
}

From source file:com.esofthead.mycollab.core.persistence.service.DefaultService.java

License:Open Source License

@Override
public List findAbsoluteListByCriteria(S searchCriteria, int firstIndex, int numberOfItems) {
    return getSearchMapper().findPagableListByCriteria(searchCriteria,
            new RowBounds(firstIndex, numberOfItems));
}

From source file:com.esofthead.mycollab.module.project.service.ibatis.ProjectActivityStreamServiceImpl.java

License:Open Source License

@Override
public List<ProjectActivityStream> getProjectActivityStreams(
        @CacheKey SearchRequest<ActivityStreamSearchCriteria> searchRequest) {
    return projectMapperExt.getProjectActivityStreams(searchRequest.getSearchCriteria(),
            new RowBounds((searchRequest.getCurrentPage() - 1) * searchRequest.getNumberOfItems(),
                    searchRequest.getNumberOfItems()));
}

From source file:com.esofthead.mycollab.module.project.service.ibatis.ProjectGenericTaskServiceImpl.java

License:Open Source License

@Override
public List<ProjectGenericTaskCount> findPagableTaskCountListByCriteria(
        SearchRequest<ProjectGenericTaskSearchCriteria> searchRequest) {
    return projectGenericTaskMapper.findPagableTaskCountListByCriteria(searchRequest.getSearchCriteria(),
            new RowBounds((searchRequest.getCurrentPage() - 1) * searchRequest.getNumberOfItems(),
                    searchRequest.getNumberOfItems()));
}

From source file:com.esofthead.mycollab.module.project.service.ibatis.ProjectTaskServiceImpl.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*from   w ww  .java 2s. c om*/
public List<SimpleTask> findSubTasks(int parentTaskId, int sAccountId) {
    TaskSearchCriteria searchCriteria = new TaskSearchCriteria();
    searchCriteria.setSaccountid(new NumberSearchField(sAccountId));
    searchCriteria.setParentTaskId(new NumberSearchField(parentTaskId));
    return taskMapperExt.findPagableListByCriteria(searchCriteria, new RowBounds(0, Integer.MAX_VALUE));
}

From source file:com.esofthead.mycollab.module.project.service.ibatis.ProjectTaskServiceImpl.java

License:Open Source License

@Override
public List<SimpleTask> findSubTasksOfGroup(int taskgroupId, @CacheKey int sAccountId) {
    TaskSearchCriteria searchCriteria = new TaskSearchCriteria();
    searchCriteria.setSaccountid(new NumberSearchField(sAccountId));
    searchCriteria.setTaskListId(new NumberSearchField(taskgroupId));
    return taskMapperExt.findPagableListByCriteria(searchCriteria, new RowBounds(0, Integer.MAX_VALUE));
}

From source file:com.esofthead.mycollab.module.project.service.ibatis.StandupReportServiceImpl.java

License:Open Source License

@Override
public SimpleStandupReport findStandupReportByDateUser(int projectId, String username, Date onDate,
        Integer sAccountId) {// ww w .java2  s.  c om
    StandupReportSearchCriteria criteria = new StandupReportSearchCriteria();
    criteria.setProjectId(new NumberSearchField(projectId));
    criteria.setLogBy(new StringSearchField(SearchField.AND, username));
    criteria.setOnDate(new DateSearchField(SearchField.AND, onDate));
    List reports = standupReportMapperExt.findPagableListByCriteria(criteria,
            new RowBounds(0, Integer.MAX_VALUE));

    if (CollectionUtils.isNotEmpty(reports)) {
        return (SimpleStandupReport) reports.get(0);
    }

    return null;
}

From source file:com.esofthead.mycollab.module.user.service.mybatis.UserServiceDBImpl.java

License:Open Source License

@Override
public SimpleUser findUserByUserNameInAccount(String username, Integer accountId) {
    UserSearchCriteria criteria = new UserSearchCriteria();
    criteria.setUsername(new StringSearchField(username));
    criteria.setSaccountid(new NumberSearchField(accountId));

    List<SimpleUser> users = userMapperExt.findPagableListByCriteria(criteria,
            new RowBounds(0, Integer.MAX_VALUE));
    if (CollectionUtils.isEmpty(users)) {
        return null;
    } else {//  ww w. j a  va2s .  c o  m
        return users.get(0);
    }
}

From source file:com.fitibo.aotearoa.controller.HomeController.java

License:Apache License

@RequestMapping("orders")
@Authentication//from   w  w w .  j  av a 2s  .c  o  m
public String queryOrder(@RequestParam(value = "keyword", defaultValue = "") String keyword,
        @RequestParam(value = "uuid", defaultValue = "") String uuid,
        @RequestParam(value = "referencenumber", defaultValue = "") String referenceNumber,
        @RequestParam(value = "status", defaultValue = "0") int status,
        @RequestParam(value = "pagesize", defaultValue = "10") int pageSize,
        @RequestParam(value = "pagenumber", defaultValue = "0") int pageNumber, Map<String, Object> model) {
    Preconditions.checkNotNull(getToken());
    model.put("module", MODULE_QUERY_ORDER);
    model.put("statusList", OrderStatus.values());
    model.put("status", status);
    model.put("pageSize", pageSize);
    model.put("pageNumber", pageNumber);
    model.put("keyword", keyword);
    model.put("uuid", uuid);
    model.put("referenceNumber", referenceNumber);
    switch (getToken().getRole()) {
    case Admin:
        model.put("orders", orderMapper.findAllByMultiFields(uuid, keyword, referenceNumber, status,
                new RowBounds(pageNumber * pageSize, pageSize)));
        break;
    case Agent:
        model.put("orders", orderMapper.findByAgentIdAndMultiFields(getToken().getId(), uuid, keyword,
                referenceNumber, status, new RowBounds(pageNumber * pageSize, pageSize)));
        break;
    default:
        throw new ResourceNotFoundException();
    }
    return "orders";
}

From source file:com.fitibo.aotearoa.controller.HomeController.java

License:Apache License

@RequestMapping("skus/{skuId}/tickets/{ticketId}")
@Authentication(Role.Admin)/*from   w  w w.  ja va2s  . c  om*/
public String skuTicketDetail(@PathVariable("skuId") int skuId, @PathVariable("ticketId") int ticketId,
        @RequestParam(value = "pagesize", defaultValue = "10") int pageSize,
        @RequestParam(value = "pagenumber", defaultValue = "0") int pageNumber, Map<String, Object> model) {
    SkuTicket ticket = skuTicketMapper.findById(ticketId);
    if (ticket == null) {
        throw new ResourceNotFoundException();
    }
    Sku sku = skuMapper.findById(skuId);
    Preconditions.checkArgument(sku != null && skuId == ticket.getSkuId(), "invalid skuId:" + skuId);
    List<SkuTicketPrice> skuTicketPrices = skuTicketPriceMapper.findBySkuTicketId(ticket.getId(),
            new RowBounds(pageNumber * pageSize, pageSize));
    model.put("sku", sku);
    model.put("ticket", ticket);
    model.put("ticketPrices", Lists.transform(skuTicketPrices, ObjectParser::parse));
    model.put("module", MODULE_SKU_TICKET_DETAIL);
    model.put("pageSize", pageSize);
    model.put("pageNumber", pageNumber);
    model.put("skuId", skuId);
    model.put("ticketId", ticketId);
    return "sku_ticket_detail";
}