List of usage examples for org.springframework.data.domain Page getTotalElements
long getTotalElements();
From source file:de.hska.ld.oidc.listeners.LDToSSSEventListener.java
private void checkIfDocumentsHaveAnAttachedEpisode(DocumentReadListEvent event) { Page<Document> documentPage = (Page<Document>) event.getSource(); List<DocumentListItemDto> documentListItemDtoList = new ArrayList<>(); documentPage.forEach(doc -> {//from ww w . ja v a 2 s . c o m Long documentId = doc.getId(); DocumentSSSInfo documentSSSInfo = documentSSSInfoService.getDocumentSSSInfoById(documentId); DocumentListItemDto documentListItemDto = new DocumentListItemDto(doc); if (documentSSSInfo != null) { documentListItemDto.setHasConnectedEpisode(true); } documentListItemDtoList.add(documentListItemDto); }); try { Field pageableField = PageImpl.class.getSuperclass().getDeclaredField("pageable"); pageableField.setAccessible(true); Pageable pageable = (Pageable) pageableField.get(documentPage); Page<DocumentListItemDto> documentListItemDtoPage = new PageImpl<DocumentListItemDto>( documentListItemDtoList, pageable, documentPage.getTotalElements()); event.setResultDocument(documentListItemDtoPage); } catch (NoSuchFieldException e) { e.printStackTrace(); } catch (IllegalAccessException e) { e.printStackTrace(); } }
From source file:com.demo.ticketservice.dao.TicketServiceRepositoryIntegrationTests.java
@Test @Transactional//from w ww.jav a 2s. co m public void findsFirstPageOfEventVenues() { Page<EventVenue> eventVenues = this.eventVenueRepository.findAll(new PageRequest(0, 10)); List<EventVenue> eventVenueList = eventVenues.getContent(); for (EventVenue eventVenue : eventVenueList) { List<EventVenueTicketLevel> eventVenueTicketLevels = eventVenueTicketLevelRepository .findByEventVenueId(eventVenue.getId()); assertThat(eventVenueTicketLevels.size(), is(equalTo(4))); for (EventVenueTicketLevel eventVenueTicketLevel : eventVenueTicketLevels) { List<Seat> seats = seatRepository.findByEventVenueTicketLevelId(eventVenueTicketLevel.getId()); assertThat(seats.size(), is(equalTo(100))); //System.out.println(seatRepository.numberOfavailableSeatsByEventVenueTicketLevelId(eventVenueTicketLevel.getId())); List<Seat> availableSeats = seatRepository .retriveAvailableSeatsByEventVenueTicketLevelId(eventVenueTicketLevel); //assertThat(seatRepository.numberOfavailableSeatsByEventVenueTicketLevelId(eventVenueTicketLevel), is(equalTo(availableSeats.size()))); break; } } System.out.println(seatRepository.numberOfavailableSeats()); List<Seat> availableSeats = seatRepository.retriveAvailableSeats(); //assertThat(seatRepository.numberOfavailableSeats(), is(equalTo(availableSeats.size()))); assertThat(eventVenues.getTotalElements(), is(equalTo(1L))); }
From source file:com.wiiyaya.provider.main.service.impl.BatchServiceImpl.java
@Override public EasyUiDataGrid<BatchDto> getAllBatchs(BatchDto batchDto, Pageable pageRequest) { List<BatchDto> batchDtoList = new ArrayList<>(); Page<Batch> batchDbs = batchDao.findAllJF(new JF() { @Override// ww w . ja v a 2s . c o m public void prepareQry(JPQLQuery qry, boolean notCountQry) { BatchQry.searchBatch(qry, notCountQry, batchDto); } }, pageRequest); for (Batch batch : batchDbs) { BatchDto temp = new BatchDto(); temp.setId(batch.getId()); temp.setTaskName(batch.getTaskName()); temp.setTaskGroup(batch.getTaskGroup()); temp.setTaskClass(batch.getTaskClass()); temp.setStartDate(batch.getStartDate()); temp.setEndDate(batch.getEndDate()); temp.setHolidayRest(batch.isHolidayRest()); temp.setSimpleTask(batch.isSimpleTask()); if (batch.isSimpleTask()) { temp.setWorkingDay(batch.getWorkingDay()); temp.setRepeatCount(batch.getRepeatCount()); temp.setRepeatInterval(batch.getRepeatInterval()); } else { temp.setCronExpression(batch.getCronExpression()); } batchDtoList.add(temp); } return new EasyUiDataGrid<>(batchDtoList, batchDbs.getTotalElements()); }
From source file:access.database.DatabaseAccessor.java
/** * Gets a list of data from the database * /*from w w w . j a v a2s. c o m*/ * @param page * The page number to start at * @param pageSize * The number of results per page * @param sortBy * The field to sort by * @param order * The order "asc" or "desc" * @param keyword * Keyword filtering * @param userName * Username filtering * @param createdByJobId * Filter by the ID of the Job that created this Data * @return List of Data items */ public DataResourceListResponse getDataList(Integer page, Integer pageSize, String sortBy, String order, String keyword, String userName, String createdByJobId) { Pagination pagination = new Pagination(null, page, pageSize, sortBy, order); Page<DataResourceEntity> results; if (StringUtils.isNotEmpty(userName) && StringUtils.isNotEmpty(keyword)) { // Both parameters specified results = dataResourceDao.getDataResourceForUserAndKeyword(keyword, userName, pagination); } else if (StringUtils.isNotEmpty(userName)) { // Query by User results = dataResourceDao.getDataResourceListByUser(userName, pagination); } else if (StringUtils.isNotEmpty(keyword)) { // Query by Keyword results = dataResourceDao.getDataResourceListByKeyword(keyword, pagination); } else if (StringUtils.isNotEmpty(createdByJobId)) { // Query by Keyword results = dataResourceDao.getDataResourceListByCreatedJobId(createdByJobId, pagination); } else { // Query all Jobs results = dataResourceDao.getDataResourceList(pagination); } // Collect the Jobs List<DataResource> dataResources = new ArrayList<DataResource>(); for (DataResourceEntity dataResourceEntity : results) { dataResources.add(dataResourceEntity.getDataResource()); } // Set Pagination count pagination.setCount(results.getTotalElements()); // Return the complete List return new DataResourceListResponse(dataResources, pagination); }
From source file:com.qingbo.ginkgo.ygb.customer.impl.CustomerServiceImpl.java
/** * ??/*from ww w. j a v a 2 s . c om*/ */ @Override public Result<PageObject<User>> page(SpecParam<User> specs, Pager pager) { // TODO Auto-generated method stub logger.info(SimpleLogFormater.formatParams(specs, pager)); Result<PageObject<User>> result; // ? if (specs == null || pager == null) { result = errors.newFailure("CST1071"); logger.info(SimpleLogFormater.formatResult(result)); return result; } if (pager.getPageSize() <= 0) { result = errors.newFailure("CMS1072"); logger.info(SimpleLogFormater.formatResult(result)); return result; } // ? Pageable pageable = pager.getDirection() == null || pager.getProperties() == null ? new PageRequest(pager.getCurrentPage() - 1, pager.getPageSize()) : new PageRequest(pager.getCurrentPage() - 1, pager.getPageSize(), Direction.valueOf(pager.getDirection()), pager.getProperties().split(",")); // ? specs.eq("deleted", false); // // Page<User> resultSet = null; try { resultSet = userRepository.findAll(SpecUtil.spec(specs), pageable); } catch (Exception e) { result = errors.newFailure("CST0008"); logger.error(SimpleLogFormater.formatException(result.getMessage(), e)); logger.info(SimpleLogFormater.formatResult(result)); return result; } // result = Result .newSuccess(new PageObject<User>((int) resultSet.getTotalElements(), resultSet.getContent())); logger.info(SimpleLogFormater.formatResult(result)); return result; }
From source file:uk.ac.ebi.ep.controller.BrowseTaxonomyController.java
@RequestMapping(value = SEARCH_BY_TAX_ID, method = RequestMethod.GET) public String searchByTaxId(@ModelAttribute("searchModel") SearchModel searchModel, @RequestParam(value = "entryid", required = true) Long entryID, @RequestParam(value = "entryname", required = false) String entryName, Model model, HttpServletRequest request, HttpSession session, Pageable pageable, RedirectAttributes attributes) { pageable = new PageRequest(0, SEARCH_PAGESIZE, Sort.Direction.ASC, "function", "entryType"); Page<UniprotEntry> page = this.enzymePortalService.findEnzymesByTaxonomy(entryID, pageable); List<Species> species = enzymePortalService.findSpeciesByTaxId(entryID); List<Compound> compouds = enzymePortalService.findCompoundsByTaxId(entryID); List<Disease> diseases = enzymePortalService.findDiseasesByTaxId(entryID); List<EcNumber> enzymeFamilies = enzymePortalService.findEnzymeFamiliesByTaxId(entryID); SearchParams searchParams = searchModel.getSearchparams(); searchParams.setStart(0);/*from www.j av a2 s . c o m*/ searchParams.setType(SearchParams.SearchType.KEYWORD); searchParams.setText(entryName); searchParams.setSize(SEARCH_PAGESIZE); searchModel.setSearchparams(searchParams); List<UniprotEntry> result = page.getContent(); int current = page.getNumber() + 1; int begin = Math.max(1, current - 5); int end = Math.min(begin + 10, page.getTotalPages()); model.addAttribute("page", page); model.addAttribute("beginIndex", begin); model.addAttribute("endIndex", end); model.addAttribute("currentIndex", current); model.addAttribute("organismName", entryName); model.addAttribute("taxId", entryID); // model.addAttribute("summaryEntries", result); SearchResults searchResults = new SearchResults(); searchResults.setTotalfound(page.getTotalElements()); SearchFilters filters = new SearchFilters(); filters.setSpecies(species); filters.setCompounds(compouds); filters.setEcNumbers(enzymeFamilies); filters.setDiseases(diseases); searchResults.setSearchfilters(filters); searchResults.setSummaryentries(result); searchModel.setSearchresults(searchResults); model.addAttribute("searchModel", searchModel); model.addAttribute("searchConfig", searchConfig); model.addAttribute("searchFilter", filters); String searchKey = getSearchKey(searchModel.getSearchparams()); cacheSearch(session.getServletContext(), searchKey, searchResults); setLastSummaries(session, searchResults.getSummaryentries()); clearHistory(session); addToHistory(session, searchModel.getSearchparams().getType(), searchKey); return RESULT; }
From source file:uk.ac.ebi.ep.controller.BrowseTaxonomyController.java
@RequestMapping(value = SEARCH_BY_TAX_ID + "/page={pageNumber}", method = RequestMethod.GET) public String searchByTaxIdPaginated(@PathVariable Integer pageNumber, @ModelAttribute("searchModel") SearchModel searchModel, @RequestParam(value = "entryid", required = true) Long entryID, @RequestParam(value = "entryname", required = false) String entryName, Model model, HttpSession session, RedirectAttributes attributes) { if (pageNumber < 1) { pageNumber = 1;// w ww . j a va 2 s .c om } Pageable pageable = new PageRequest(pageNumber - 1, SEARCH_PAGESIZE, Sort.Direction.ASC, "function", "entryType"); Page<UniprotEntry> page = this.enzymePortalService.findEnzymesByTaxonomy(entryID, pageable); List<Species> species = enzymePortalService.findSpeciesByTaxId(entryID); List<Compound> compouds = enzymePortalService.findCompoundsByTaxId(entryID); List<Disease> diseases = enzymePortalService.findDiseasesByTaxId(entryID); List<EcNumber> enzymeFamilies = enzymePortalService.findEnzymeFamiliesByTaxId(entryID); SearchParams searchParams = searchModel.getSearchparams(); searchParams.setStart(0); searchParams.setType(SearchParams.SearchType.KEYWORD); searchParams.setText(entryName); searchParams.setSize(SEARCH_PAGESIZE); searchModel.setSearchparams(searchParams); List<UniprotEntry> result = page.getContent(); int current = page.getNumber() + 1; int begin = Math.max(1, current - 5); int end = Math.min(begin + 10, page.getTotalPages()); model.addAttribute("page", page); model.addAttribute("beginIndex", begin); model.addAttribute("endIndex", end); model.addAttribute("currentIndex", current); model.addAttribute("organismName", entryName); model.addAttribute("taxId", entryID); // model.addAttribute("summaryEntries", result); SearchResults searchResults = new SearchResults(); searchResults.setTotalfound(page.getTotalElements()); SearchFilters filters = new SearchFilters(); filters.setSpecies(species); filters.setCompounds(compouds); filters.setEcNumbers(enzymeFamilies); filters.setDiseases(diseases); searchResults.setSearchfilters(filters); searchResults.setSummaryentries(result); searchModel.setSearchresults(searchResults); model.addAttribute("searchModel", searchModel); model.addAttribute("searchConfig", searchConfig); model.addAttribute("searchFilter", filters); String searchKey = getSearchKey(searchModel.getSearchparams()); cacheSearch(session.getServletContext(), searchKey, searchResults); setLastSummaries(session, searchResults.getSummaryentries()); clearHistory(session); addToHistory(session, searchModel.getSearchparams().getType(), searchKey); return RESULT; }
From source file:com.github.vanroy.springdata.jest.JestElasticsearchTemplateTests.java
@Test public void shouldDeleteDocumentForGivenId() { // given//from ww w. j a v a2 s. c om String documentId = randomNumeric(5); SampleEntity sampleEntity = SampleEntity.builder().id(documentId).message("some message") .version(System.currentTimeMillis()).build(); IndexQuery indexQuery = getIndexQuery(sampleEntity); elasticsearchTemplate.index(indexQuery); // when elasticsearchTemplate.delete(INDEX_NAME, TYPE_NAME, documentId); elasticsearchTemplate.refresh(SampleEntity.class); // then SearchQuery searchQuery = new NativeSearchQueryBuilder().withQuery(termQuery("id", documentId)).build(); Page<SampleEntity> sampleEntities = elasticsearchTemplate.queryForPage(searchQuery, SampleEntity.class); assertThat(sampleEntities.getTotalElements(), equalTo(0L)); }
From source file:com.github.vanroy.springdata.jest.JestElasticsearchTemplateTests.java
@Test public void shouldDeleteEntityForGivenId() { // given/* www .j a v a2 s . c om*/ String documentId = randomNumeric(5); SampleEntity sampleEntity = SampleEntity.builder().id(documentId).message("some message") .version(System.currentTimeMillis()).build(); IndexQuery indexQuery = getIndexQuery(sampleEntity); elasticsearchTemplate.index(indexQuery); // when elasticsearchTemplate.delete(SampleEntity.class, documentId); elasticsearchTemplate.refresh(SampleEntity.class); // then SearchQuery searchQuery = new NativeSearchQueryBuilder().withQuery(termQuery("id", documentId)).build(); Page<SampleEntity> sampleEntities = elasticsearchTemplate.queryForPage(searchQuery, SampleEntity.class); assertThat(sampleEntities.getTotalElements(), equalTo(0L)); }
From source file:com.github.vanroy.springdata.jest.JestElasticsearchTemplateTests.java
@Test public void shouldDeleteDocumentForGivenQuery() { // given// ww w .j a va 2s.co m String documentId = randomNumeric(5); SampleEntity sampleEntity = SampleEntity.builder().id(documentId).message("some message") .version(System.currentTimeMillis()).build(); IndexQuery indexQuery = getIndexQuery(sampleEntity); elasticsearchTemplate.index(indexQuery); elasticsearchTemplate.refresh(SampleEntity.class); // when DeleteQuery deleteQuery = new DeleteQuery(); deleteQuery.setQuery(termQuery("id", documentId)); elasticsearchTemplate.delete(deleteQuery, SampleEntity.class); elasticsearchTemplate.refresh(SampleEntity.class); // then SearchQuery searchQuery = new NativeSearchQueryBuilder().withQuery(termQuery("id", documentId)).build(); Page<SampleEntity> sampleEntities = elasticsearchTemplate.queryForPage(searchQuery, SampleEntity.class); assertThat(sampleEntities.getTotalElements(), equalTo(0L)); }