private List<Athlete> getAthletesWithCompetionResults(Long competitionid) { Query q = em.createNativeQuery( "select distinct a.* from athlete a join result r on a.id = r.athlete_id and r.competition_id = ?", Athlete.class); q.setParameter(1, competitionid); List<Athlete> as = q.getResultList(); TypedQuery<Result> tq = em.createNamedQuery("Result.findByCompetition", Result.class); tq.setParameter("competitionId", competitionid); List<Result> results = tq.getResultList(); Map<Long, List<Result>> map = new HashMap<>(); for (Result r : results) { List<Result> entry = map.get(r.getAthlete_id()); if (entry != null) { entry.add(r); } else { List<Result> list = new ArrayList<>(); list.add(r); map.put(r.getAthlete_id(), list); } } for (Athlete a : as) { a.setResults(map.get(a.getId())); } return as; }
private List<Athlete> filterAndSortByTotalPoints(Competition competition, List<Athlete> list) { for (Athlete a : list) { a.setCategory(null); List<Result> rs = new ArrayList<>(); for (Result r : a.getResults()) { if (r.getCompetition().equals(competition)) { rs.add(r); } } a.setResults(rs); } Collections.sort(list, new AthleteCompetitionResultComparator(competition)); return list; }
private List<Athlete> filterAndSort(Series series, List<Athlete> list) { List<Athlete> filtered = new ArrayList<>(); for (Athlete athlete : list) { if (athlete.getCategory().getEvents().size() * series.getCompetitions().size() == athlete.getResults().size()) { athlete.setCategory(null); List<Result> rs = new ArrayList<>(); for (Result r : athlete.getResults()) { rs.add(r); } athlete.setResults(rs); filtered.add(athlete); } } Collections.sort(filtered, new AthleteSeriesResultComparator(series)); return filtered; }
public SeriesRankingVO getSeriesRanking(Long seriesId) { Series series = em.find(Series.class, seriesId); if (series == null) { return null; } TypedQuery<Athlete> q = em.createNamedQuery("Athlete.findBySeries", Athlete.class); q.setParameter("series_id", seriesId); List<Athlete> list = q.getResultList(); for (Athlete a : list) { TypedQuery<Result> tq = em.createNamedQuery("Result.findByAthleteAndSeries", Result.class); tq.setParameter("athleteId", a.getId()); tq.setParameter("seriesId", seriesId); List<Result> results = tq.getResultList(); a.setResults(results); } TypedQuery<Competition> qc = em.createNamedQuery("Competition.findAll", Competition.class); qc.setParameter("series_id", seriesId); List<Competition> cs = qc.getResultList(); series.setCompetitions(cs); SeriesRankingVO ranking = new SeriesRankingVO(); ranking.setSeries(series); Map<Category, List<Athlete>> map = new HashMap<>(); for (Athlete a : list) { List<Athlete> as = map.get(a.getCategory()); if (as == null) { as = new ArrayList<>(); } as.add(a); map.put(a.getCategory(), as); } for (Map.Entry<Category, List<Athlete>> entry : map.entrySet()) { SeriesRankingCategoryVO rc = new SeriesRankingCategoryVO(); Category c = entry.getKey(); rc.setCategory(c); rc.setAthletes(filterAndSort(series, entry.getValue())); ranking.getCategories().add(rc); } Collections.sort(ranking.getCategories()); return ranking; }