Examples with AccessRights org.olat.modules.portfolio.model.AccessRights used on opensource projects

Example 11 with AccessRights

use of org.olat.modules.portfolio.model.AccessRights in project openolat by klemens.

the class BinderDAO method getBinderAccesRights.

public List<AccessRights> getBinderAccesRights(BinderRef binder, IdentityRef identity) {
    if (binder == null) {
        return Collections.emptyList();
    }
    StringBuilder sb = new StringBuilder();
    sb.append("select membership.role, ident, invitation from pfbinder as binder").append(" inner join binder.baseGroup as baseGroup").append(" inner join baseGroup.members as membership");
    if (identity != null) {
        sb.append(" on (membership.identity.key =:identityKey)");
    }
    sb.append(" inner join membership.identity as ident").append(" inner join fetch ident.user as identUser").append(" left join binvitation as invitation on (invitation.baseGroup.key=baseGroup.key and identUser.email=invitation.mail)").append(" where binder.key=:binderKey");
    TypedQuery<Object[]> query = dbInstance.getCurrentEntityManager().createQuery(sb.toString(), Object[].class).setParameter("binderKey", binder.getKey());
    if (identity != null) {
        query.setParameter("identityKey", identity.getKey());
    }
    List<Object[]> objects = query.getResultList();
    List<AccessRights> rightList = new ArrayList<>(objects.size());
    for (Object[] object : objects) {
        String role = (String) object[0];
        Identity member = (Identity) object[1];
        Invitation invitation = (Invitation) object[2];
        AccessRights rights = new AccessRights();
        rights.setRole(PortfolioRoles.valueOf(role));
        rights.setBinderKey(binder.getKey());
        rights.setIdentity(member);
        rights.setInvitation(invitation);
        rightList.add(rights);
    }
    return rightList;
}

Example 12 with AccessRights

use of org.olat.modules.portfolio.model.AccessRights in project openolat by klemens.

the class BinderDAO method getSectionAccesRights.

public List<AccessRights> getSectionAccesRights(Page page) {
    if (page == null) {
        return Collections.emptyList();
    }
    StringBuilder sb = new StringBuilder();
    sb.append("select binder.key, section.key, page.key, membership.role, ident, invitation from pfpage as page").append(" inner join page.section as section").append(" inner join section.binder as binder").append(" inner join section.baseGroup as baseGroup").append(" inner join baseGroup.members as membership").append(" inner join membership.identity as ident").append(" inner join fetch ident.user as identUser").append(" left join binvitation as invitation on (invitation.baseGroup.key=binder.baseGroup.key and identUser.email=invitation.mail)").append(" where page.key=:pageKey");
    TypedQuery<Object[]> query = dbInstance.getCurrentEntityManager().createQuery(sb.toString(), Object[].class).setParameter("pageKey", page.getKey());
    List<Object[]> objects = query.getResultList();
    List<AccessRights> rightList = new ArrayList<>(objects.size());
    for (Object[] object : objects) {
        Long binderKey = (Long) object[0];
        Long sectionKey = (Long) object[1];
        Long pageKey = (Long) object[2];
        String role = (String) object[3];
        Identity member = (Identity) object[4];
        Invitation invitation = (Invitation) object[5];
        AccessRights rights = new AccessRights();
        rights.setRole(PortfolioRoles.valueOf(role));
        rights.setBinderKey(binderKey);
        rights.setSectionKey(sectionKey);
        rights.setPageKey(pageKey);
        rights.setIdentity(member);
        rights.setInvitation(invitation);
        rightList.add(rights);
    }
    return rightList;
}

Example 13 with AccessRights

use of org.olat.modules.portfolio.model.AccessRights in project openolat by klemens.

the class BinderDAO method getPageAccesRights.

public List<AccessRights> getPageAccesRights(BinderRef binder, IdentityRef identity) {
    if (binder == null) {
        return Collections.emptyList();
    }
    StringBuilder sb = new StringBuilder();
    sb.append("select section.key, page.key, membership.role, ident, invitation from pfbinder as binder").append(" inner join binder.sections as section").append(" inner join section.pages as page").append(" inner join page.baseGroup as baseGroup").append(" inner join baseGroup.members as membership");
    if (identity != null) {
        sb.append(" on (membership.identity.key=:identityKey)");
    }
    sb.append(" inner join membership.identity as ident").append(" inner join fetch ident.user as identUser").append(" left join binvitation as invitation on (invitation.baseGroup.key=binder.baseGroup.key and identUser.email=invitation.mail)").append(" where binder.key=:binderKey");
    TypedQuery<Object[]> query = dbInstance.getCurrentEntityManager().createQuery(sb.toString(), Object[].class).setParameter("binderKey", binder.getKey());
    if (identity != null) {
        query.setParameter("identityKey", identity.getKey());
    }
    List<Object[]> objects = query.getResultList();
    List<AccessRights> rightList = new ArrayList<>(objects.size());
    for (Object[] object : objects) {
        Long sectionKey = (Long) object[0];
        Long pageKey = (Long) object[1];
        String role = (String) object[2];
        Identity member = (Identity) object[3];
        Invitation invitation = (Invitation) object[4];
        AccessRights rights = new AccessRights();
        rights.setRole(PortfolioRoles.valueOf(role));
        rights.setBinderKey(binder.getKey());
        rights.setSectionKey(sectionKey);
        rights.setPageKey(pageKey);
        rights.setIdentity(member);
        rights.setInvitation(invitation);
        rightList.add(rights);
    }
    return rightList;
}

Example 14 with AccessRights

use of org.olat.modules.portfolio.model.AccessRights in project openolat by klemens.

the class BinderDAO method getPageAccesRights.

public List<AccessRights> getPageAccesRights(Page page) {
    if (page == null) {
        return Collections.emptyList();
    }
    StringBuilder sb = new StringBuilder();
    sb.append("select binder.key, section.key, page.key, membership.role, ident, invitation from pfpage as page").append(" inner join page.section as section").append(" inner join section.binder as binder").append(" inner join page.baseGroup as baseGroup").append(" inner join baseGroup.members as membership").append(" inner join membership.identity as ident").append(" inner join fetch ident.user as identUser").append(" left join binvitation as invitation on (invitation.baseGroup.key=binder.baseGroup.key and identUser.email=invitation.mail)").append(" where page.key=:pageKey");
    TypedQuery<Object[]> query = dbInstance.getCurrentEntityManager().createQuery(sb.toString(), Object[].class).setParameter("pageKey", page.getKey());
    List<Object[]> objects = query.getResultList();
    List<AccessRights> rightList = new ArrayList<>(objects.size());
    for (Object[] object : objects) {
        Long binderKey = (Long) object[0];
        Long sectionKey = (Long) object[1];
        Long pageKey = (Long) object[2];
        String role = (String) object[3];
        Identity member = (Identity) object[4];
        Invitation invitation = (Invitation) object[5];
        AccessRights rights = new AccessRights();
        rights.setRole(PortfolioRoles.valueOf(role));
        rights.setBinderKey(binderKey);
        rights.setSectionKey(sectionKey);
        rights.setPageKey(pageKey);
        rights.setIdentity(member);
        rights.setInvitation(invitation);
        rightList.add(rights);
    }
    return rightList;
}

Example 15 with AccessRights

use of org.olat.modules.portfolio.model.AccessRights in project openolat by klemens.

the class BinderDAO method getSectionAccesRights.

public List<AccessRights> getSectionAccesRights(BinderRef binder, IdentityRef identity) {
    if (binder == null) {
        return Collections.emptyList();
    }
    StringBuilder sb = new StringBuilder();
    sb.append("select section.key, membership.role, ident, invitation from pfbinder as binder").append(" inner join binder.sections as section").append(" inner join section.baseGroup as baseGroup").append(" inner join baseGroup.members as membership");
    if (identity != null) {
        sb.append(" on (membership.identity.key =:identityKey)");
    }
    sb.append(" inner join membership.identity as ident").append(" inner join fetch ident.user as identUser").append(" left join binvitation as invitation on (invitation.baseGroup.key=binder.baseGroup.key and identUser.email=invitation.mail)").append(" where binder.key=:binderKey");
    TypedQuery<Object[]> query = dbInstance.getCurrentEntityManager().createQuery(sb.toString(), Object[].class).setParameter("binderKey", binder.getKey());
    if (identity != null) {
        query.setParameter("identityKey", identity.getKey());
    }
    List<Object[]> objects = query.getResultList();
    List<AccessRights> rightList = new ArrayList<>(objects.size());
    for (Object[] object : objects) {
        Long sectionKey = (Long) object[0];
        String role = (String) object[1];
        Identity member = (Identity) object[2];
        Invitation invitation = (Invitation) object[3];
        AccessRights rights = new AccessRights();
        rights.setRole(PortfolioRoles.valueOf(role));
        rights.setBinderKey(binder.getKey());
        rights.setSectionKey(sectionKey);
        rights.setIdentity(member);
        rights.setInvitation(invitation);
        rightList.add(rights);
    }
    return rightList;
}