Search in sources :

Example 16 with WorkspaceRoleEntity

use of fi.otavanopisto.muikku.model.workspace.WorkspaceRoleEntity in project muikku by otavanopisto.

the class WorkspaceRoleEntityDAO method listByArchetype.

public List<WorkspaceRoleEntity> listByArchetype(WorkspaceRoleArchetype archetype) {
    EntityManager entityManager = getEntityManager();
    CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
    CriteriaQuery<WorkspaceRoleEntity> criteria = criteriaBuilder.createQuery(WorkspaceRoleEntity.class);
    Root<WorkspaceRoleEntity> root = criteria.from(WorkspaceRoleEntity.class);
    criteria.select(root);
    criteria.where(criteriaBuilder.equal(root.get(WorkspaceRoleEntity_.archetype), archetype));
    return entityManager.createQuery(criteria).getResultList();
}
Also used : CriteriaBuilder(javax.persistence.criteria.CriteriaBuilder) EntityManager(javax.persistence.EntityManager) WorkspaceRoleEntity(fi.otavanopisto.muikku.model.workspace.WorkspaceRoleEntity)

Example 17 with WorkspaceRoleEntity

use of fi.otavanopisto.muikku.model.workspace.WorkspaceRoleEntity in project muikku by otavanopisto.

the class WorkspaceSystemRESTService method synchronizeWorkspaceUsers.

@GET
@Path("/syncworkspaceusers/{ID}")
@RESTPermit(handling = Handling.INLINE)
public Response synchronizeWorkspaceUsers(@PathParam("ID") Long workspaceEntityId, @Context Request request) {
    // Admins only
    if (!sessionController.isSuperuser()) {
        return Response.status(Status.UNAUTHORIZED).build();
    }
    logger.info(String.format("Synchronizing users of workspace entity %d", workspaceEntityId));
    // Workspace
    WorkspaceEntity workspaceEntity = workspaceEntityController.findWorkspaceEntityById(workspaceEntityId);
    if (workspaceEntity == null) {
        return Response.status(Status.NOT_FOUND).build();
    }
    // Student role
    WorkspaceRoleEntity workspaceStudentRole = roleController.findWorkspaceRoleEntityById(getWorkspaceStudentRoleId());
    // Workspace students in Muikku
    List<WorkspaceUserEntity> muikkuWorkspaceStudents = workspaceUserEntityController.listWorkspaceUserEntitiesByRole(workspaceEntity, workspaceStudentRole);
    logger.info(String.format("Before synchronizing, Muikku course has %d active students", muikkuWorkspaceStudents.size()));
    // Course students in Pyramus
    List<WorkspaceUser> pyramusCourseStudents = workspaceController.listWorkspaceStudents(workspaceEntity);
    logger.info(String.format("Before synchronizing, Pyramus course has %d active students", pyramusCourseStudents.size()));
    // Loop through Pyramus students
    for (WorkspaceUser pyramusCourseStudent : pyramusCourseStudents) {
        String pyramusStudentId = pyramusCourseStudent.getUserIdentifier().getIdentifier();
        String pyramusCourseStudentId = pyramusCourseStudent.getIdentifier().getIdentifier();
        // Find Muikku student corresponding to Pyramus student
        String muikkuWorkspaceStudentId = null;
        WorkspaceUserEntity muikkuWorkspaceStudent = null;
        for (int i = 0; i < muikkuWorkspaceStudents.size(); i++) {
            muikkuWorkspaceStudentId = muikkuWorkspaceStudents.get(i).getIdentifier();
            if (StringUtils.equals(muikkuWorkspaceStudentId, pyramusCourseStudentId)) {
                muikkuWorkspaceStudent = muikkuWorkspaceStudents.get(i);
                muikkuWorkspaceStudents.remove(i);
                break;
            }
        }
        if (muikkuWorkspaceStudent == null) {
            // Restore an archived workspace student, if possible
            muikkuWorkspaceStudent = workspaceUserEntityController.findWorkspaceUserEntityByWorkspaceUserIdentifierAndArchived(pyramusCourseStudent.getIdentifier(), Boolean.TRUE);
            if (muikkuWorkspaceStudent != null) {
                workspaceUserEntityController.unarchiveWorkspaceUserEntity(muikkuWorkspaceStudent);
                logger.info(String.format("Unarchived workspace student %s", pyramusCourseStudentId));
                SchoolDataIdentifier muikkuStudentIdentifier = new SchoolDataIdentifier(muikkuWorkspaceStudent.getUserSchoolDataIdentifier().getIdentifier(), muikkuWorkspaceStudent.getUserSchoolDataIdentifier().getDataSource().getIdentifier());
                ensureCorrectWorkspaceStudent(muikkuWorkspaceStudent, muikkuStudentIdentifier, pyramusCourseStudent.getUserIdentifier());
            } else {
                // Workspace student with workspace student identifier still not found, even amongst archived workspace students
                UserSchoolDataIdentifier userSchoolDataIdentifier = userSchoolDataIdentifierController.findUserSchoolDataIdentifierBySchoolDataIdentifier(pyramusCourseStudent.getUserIdentifier());
                if (userSchoolDataIdentifier == null) {
                    logger.severe(String.format("Unable to fix missing workspace student: UserSchoolDataIdentifier for Pyramus student %s not found", pyramusStudentId));
                } else {
                    // Try to find workspace student with workspace + student combo
                    muikkuWorkspaceStudent = workspaceUserEntityController.findWorkspaceUserEntityByWorkspaceAndUserSchoolDataIdentifierIncludeArchived(workspaceEntity, userSchoolDataIdentifier);
                    if (muikkuWorkspaceStudent != null) {
                        // Found. Might be archived but definitely has the wrong workspace student identifier
                        if (muikkuWorkspaceStudent.getArchived()) {
                            workspaceUserEntityController.unarchiveWorkspaceUserEntity(muikkuWorkspaceStudent);
                        }
                        if (!muikkuWorkspaceStudent.getIdentifier().equals(pyramusCourseStudent.getIdentifier().getIdentifier())) {
                            workspaceUserEntityController.updateIdentifier(muikkuWorkspaceStudent, pyramusCourseStudent.getIdentifier().getIdentifier());
                        }
                    } else {
                        // Not found. Create a new workspace student
                        muikkuWorkspaceStudent = workspaceUserEntityController.createWorkspaceUserEntity(userSchoolDataIdentifier, workspaceEntity, pyramusCourseStudentId, workspaceStudentRole);
                        logger.info(String.format("Created workspace student %s", muikkuWorkspaceStudent.getIdentifier()));
                    }
                }
            }
        } else {
            // Workspace student found with workspace student identifier. We still need to ensure that the underlying student is the same as in Pyramus
            SchoolDataIdentifier muikkuStudentIdentifier = new SchoolDataIdentifier(muikkuWorkspaceStudent.getUserSchoolDataIdentifier().getIdentifier(), muikkuWorkspaceStudent.getUserSchoolDataIdentifier().getDataSource().getIdentifier());
            ensureCorrectWorkspaceStudent(muikkuWorkspaceStudent, muikkuStudentIdentifier, pyramusCourseStudent.getUserIdentifier());
        }
    }
    // The remaining Muikku students in muikkuWorkspaceStudents were not in Pyramus so archive them from Muikku
    if (!muikkuWorkspaceStudents.isEmpty()) {
        for (WorkspaceUserEntity muikkuWorkspaceStudent : muikkuWorkspaceStudents) {
            workspaceUserEntityController.archiveWorkspaceUserEntity(muikkuWorkspaceStudent);
        }
        logger.info(String.format("Archived %d Muikku workspace students that were not present in Pyramus", muikkuWorkspaceStudents.size()));
    }
    // Student count in Muikku after synchronizing, which should be the same as in Pyramus before synchronization
    muikkuWorkspaceStudents = workspaceUserEntityController.listWorkspaceUserEntitiesByRole(workspaceEntity, workspaceStudentRole);
    logger.info(String.format("After synchronizing, Muikku course has %d active students", pyramusCourseStudents.size()));
    // Course staff maintenance
    // Teacher role
    WorkspaceRoleEntity workspaceTeacherRole = roleController.findWorkspaceRoleEntityById(getWorkspaceTeacherRoleId());
    // Workspace teachers in Muikku
    List<WorkspaceUserEntity> muikkuWorkspaceTeachers = workspaceUserEntityController.listWorkspaceUserEntitiesByRole(workspaceEntity, workspaceTeacherRole);
    logger.info(String.format("Before synchronizing, Muikku course has %d active teachers", muikkuWorkspaceTeachers.size()));
    // Course teachers in Pyramus
    List<WorkspaceUser> pyramusCourseTeachers = workspaceController.listWorkspaceStaffMembers(workspaceEntity);
    logger.info(String.format("Before synchronizing, Pyramus course has %d active teachers", pyramusCourseTeachers.size()));
    for (WorkspaceUser pyramusCourseTeacher : pyramusCourseTeachers) {
        String pyramusCourseTeacherId = pyramusCourseTeacher.getIdentifier().getIdentifier();
        String pyramusTeacherId = pyramusCourseTeacher.getUserIdentifier().getIdentifier();
        WorkspaceUserEntity muikkuWorkspaceTeacher = null;
        for (int i = 0; i < muikkuWorkspaceTeachers.size(); i++) {
            String muikkuCourseTeacherId = muikkuWorkspaceTeachers.get(i).getIdentifier();
            if (muikkuCourseTeacherId.equals(pyramusCourseTeacherId)) {
                muikkuWorkspaceTeacher = muikkuWorkspaceTeachers.get(i);
                muikkuWorkspaceTeachers.remove(i);
                break;
            }
        }
        if (muikkuWorkspaceTeacher == null) {
            muikkuWorkspaceTeacher = workspaceUserEntityController.findWorkspaceUserEntityByWorkspaceUserIdentifierAndArchived(pyramusCourseTeacher.getIdentifier(), Boolean.TRUE);
            if (muikkuWorkspaceTeacher != null) {
                workspaceUserEntityController.unarchiveWorkspaceUserEntity(muikkuWorkspaceTeacher);
                logger.info(String.format("Unarchived workspace teacher %s", pyramusCourseTeacherId));
                if (!muikkuWorkspaceTeacher.getIdentifier().equals(pyramusCourseTeacher.getIdentifier().getIdentifier())) {
                    workspaceUserEntityController.updateIdentifier(muikkuWorkspaceTeacher, pyramusCourseTeacher.getIdentifier().getIdentifier());
                }
            } else {
                UserSchoolDataIdentifier userSchoolDataIdentifier = userSchoolDataIdentifierController.findUserSchoolDataIdentifierBySchoolDataIdentifier(pyramusCourseTeacher.getUserIdentifier());
                if (userSchoolDataIdentifier == null) {
                    logger.severe(String.format("Unable to fix missing workspace teacher: UserSchoolDataIdentifier for Pyramus teacher %s not found", pyramusTeacherId));
                } else {
                    muikkuWorkspaceTeacher = workspaceUserEntityController.findWorkspaceUserEntityByWorkspaceAndUserSchoolDataIdentifierIncludeArchived(workspaceEntity, userSchoolDataIdentifier);
                    if (muikkuWorkspaceTeacher != null) {
                        if (muikkuWorkspaceTeacher.getArchived()) {
                            workspaceUserEntityController.unarchiveWorkspaceUserEntity(muikkuWorkspaceTeacher);
                        }
                        if (!muikkuWorkspaceTeacher.getIdentifier().equals(pyramusCourseTeacher.getIdentifier().getIdentifier())) {
                            workspaceUserEntityController.updateIdentifier(muikkuWorkspaceTeacher, pyramusCourseTeacher.getIdentifier().getIdentifier());
                        }
                    } else {
                        muikkuWorkspaceTeacher = workspaceUserEntityController.createWorkspaceUserEntity(userSchoolDataIdentifier, workspaceEntity, pyramusCourseTeacherId, workspaceTeacherRole);
                        logger.info(String.format("Created workspace teacher %", muikkuWorkspaceTeacher.getIdentifier()));
                    }
                }
            }
        }
    }
    // The remaining Muikku teachers in muikkuWorkspaceTeachers were not in Pyramus so archive them from Muikku
    if (!muikkuWorkspaceTeachers.isEmpty()) {
        for (WorkspaceUserEntity muikkuWorkspaceTeacher : muikkuWorkspaceTeachers) {
            workspaceUserEntityController.archiveWorkspaceUserEntity(muikkuWorkspaceTeacher);
        }
        logger.info(String.format("Archived %d Muikku workspace teachers that were not present in Pyramus", muikkuWorkspaceTeachers.size()));
    }
    return null;
}
Also used : SchoolDataIdentifier(fi.otavanopisto.muikku.schooldata.SchoolDataIdentifier) UserSchoolDataIdentifier(fi.otavanopisto.muikku.model.users.UserSchoolDataIdentifier) UserSchoolDataIdentifier(fi.otavanopisto.muikku.model.users.UserSchoolDataIdentifier) WorkspaceUserEntity(fi.otavanopisto.muikku.model.workspace.WorkspaceUserEntity) WorkspaceEntity(fi.otavanopisto.muikku.model.workspace.WorkspaceEntity) WorkspaceRoleEntity(fi.otavanopisto.muikku.model.workspace.WorkspaceRoleEntity) WorkspaceUser(fi.otavanopisto.muikku.schooldata.entity.WorkspaceUser) Path(javax.ws.rs.Path) RESTPermit(fi.otavanopisto.security.rest.RESTPermit) GET(javax.ws.rs.GET)

Aggregations

WorkspaceRoleEntity (fi.otavanopisto.muikku.model.workspace.WorkspaceRoleEntity)17 WorkspaceUserEntity (fi.otavanopisto.muikku.model.workspace.WorkspaceUserEntity)6 RoleEntity (fi.otavanopisto.muikku.model.users.RoleEntity)5 WorkspaceEntity (fi.otavanopisto.muikku.model.workspace.WorkspaceEntity)5 UserSchoolDataIdentifier (fi.otavanopisto.muikku.model.users.UserSchoolDataIdentifier)4 EntityManager (javax.persistence.EntityManager)4 CriteriaBuilder (javax.persistence.criteria.CriteriaBuilder)4 SchoolDataSource (fi.otavanopisto.muikku.model.base.SchoolDataSource)3 Permission (fi.otavanopisto.muikku.model.security.Permission)3 EnvironmentRoleEntity (fi.otavanopisto.muikku.model.users.EnvironmentRoleEntity)3 RoleSchoolDataIdentifier (fi.otavanopisto.muikku.model.users.RoleSchoolDataIdentifier)3 WorkspaceRoleArchetype (fi.otavanopisto.muikku.model.workspace.WorkspaceRoleArchetype)3 SchoolDataIdentifier (fi.otavanopisto.muikku.schooldata.SchoolDataIdentifier)3 ArrayList (java.util.ArrayList)3 RolePermission (fi.otavanopisto.muikku.model.security.RolePermission)2 EnvironmentRoleArchetype (fi.otavanopisto.muikku.model.users.EnvironmentRoleArchetype)2 UserEntity (fi.otavanopisto.muikku.model.users.UserEntity)2 MuikkuPermissionCollection (fi.otavanopisto.muikku.security.MuikkuPermissionCollection)2 RESTPermit (fi.otavanopisto.security.rest.RESTPermit)2 Path (javax.ws.rs.Path)2