/** 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();
}
