/**
* Retrieves all user projects that they are authorized to modify.
*
* @param db - the database connection
* @param user - the user to find projects for
* @return ProjectList - the list of projects the user is authorized to modify
* @throws SQLException - generated trying to retrieve the data
*/
private ProjectList findUserProjects(Connection db, User user) throws SQLException {
ProjectList tmpList = new ProjectList();
ProjectList returnList = new ProjectList();
tmpList.setOpenProjectsOnly(true);
tmpList.setProjectsForUser(user.getId());
tmpList.buildList(db);
for (Project p : tmpList) {
if (ProjectUtils.hasAccess(p.getId(), user, "project-lists-modify")) {
returnList.add(p);
}
}
return returnList;
}
