/** Returns the number of student placements for the specified school and school year. */ protected int getPrivateSchoolOCCPlacementCount(int schoolId, String schoolYearName) throws RemoteException { PreparedQuery query = null; if (!schoolYearName.equals("0")) { ReportBusiness rb = getReportBusiness(); query = getQuery(QUERY_PRIVATE); if (query == null) { query = new PreparedQuery(getConnection()); query.setSelectCountDistinctUsers(); query.setPlacements(rb.getSchoolSeasonId()); query.setNotNackaCitizens(); query.setSchoolType(); // parameter 1 query.setSchoolYearName(); // parameter 2 query.setSchool(); // parameter 3 query.prepare(); setQuery(QUERY_PRIVATE, query); } if (schoolYearName.equals("F")) { query.setInt(1, rb.getPreSchoolClassTypeId()); } else { query.setInt(1, rb.getElementarySchoolTypeId()); } query.setString(2, schoolYearName); query.setInt(3, schoolId); } else { // 6 years old students query = getQuery(QUERY_PRIVATE_6_YEAR_STUDENTS); if (query == null) { query = new PreparedQuery(getConnection()); query.setSelectCountDistinctUsers(); query.setPlacements(getReportBusiness().getSchoolSeasonId()); query.setNotNackaCitizens(); query.setOnlyStudentsBorn(getReportBusiness().getSchoolSeasonStartYear() - 6); query.setSchoolYearName("1"); query.setSchoolTypeElementarySchool(); query.setSchool(); // parameter 1 query.prepare(); setQuery(QUERY_PRIVATE_6_YEAR_STUDENTS, query); } query.setInt(1, schoolId); } return query.execute(); }