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

Example 1 with AssessedBinder

use of org.olat.modules.portfolio.model.AssessedBinder in project OpenOLAT by OpenOLAT.

the class SharedWithMeQueries method searchSharedBindersTwo.

private void searchSharedBindersTwo(Identity member, List<AssessedBinder> binders) {
    StringBuilder sb = new StringBuilder(2048);
    sb.append("select binder.key,").append("  section.key, section.status, section.title, section.pos, section.endDate,").append("  page.key, page.status, page.lastModified, page.lastPublicationDate,").append("  body.lastModified, max(parts.lastModified), infos.recentLaunch").append(" from pfbinder as binder").append(" inner join binder.sections as section").append(" inner join section.pages as page").append(" inner join page.body as body").append(" left join body.parts as parts").append(" left join pfbinderuserinfos as infos on (infos.binder.key=binder.key and infos.identity.key=:identityKey)").append(" where exists (select membership.key from bgroupmember as membership").append("   where membership.group.key=binder.baseGroup.key and membership.identity.key=:identityKey and membership.role in ('").append(PortfolioRoles.coach.name()).append("','").append(PortfolioRoles.reviewer.name()).append("')").append(" ) or exists (select sectionMembership.key from bgroupmember as sectionMembership").append("   where sectionMembership.group.key=section.baseGroup.key and sectionMembership.identity.key=:identityKey and sectionMembership.role in ('").append(PortfolioRoles.coach.name()).append("','").append(PortfolioRoles.reviewer.name()).append("')").append(" ) or exists (select page.key from pfpage as coachedPage").append("   inner join coachedPage.baseGroup as pageGroup").append("   inner join pageGroup.members as pageMembership on (pageMembership.identity.key=:identityKey and pageMembership.role in ('").append(PortfolioRoles.coach.name()).append("','").append(PortfolioRoles.reviewer.name()).append("'))").append("   where coachedPage.key=page.key").append(" ) group by binder.key, section.key, section.status, section.title, section.pos, section.endDate,").append("    page.key, page.status, page.lastModified, page.lastPublicationDate, body.lastModified, infos.recentLaunch");
    Date now = new Date();
    List<Object[]> objects = dbInstance.getCurrentEntityManager().createQuery(sb.toString(), Object[].class).setParameter("identityKey", member.getKey()).getResultList();
    if (objects.size() > 0) {
        Set<Long> sectionKeys = new HashSet<>();
        Map<Long, AssessedBinder> keyToBinder = binders.stream().collect(Collectors.toMap(b -> b.getBinderKey(), b -> b));
        for (Object[] object : objects) {
            int pos = 0;
            Long binderKey = (Long) object[pos++];
            AssessedBinder binder = keyToBinder.get(binderKey);
            if (binder == null) {
                continue;
            }
            Long sectionKey = (Long) object[pos++];
            String sectionStatus = (String) object[pos++];
            String sectionTitle = (String) object[pos++];
            Number sectionPosNumber = (Number) object[pos++];
            Date sectionEndDate = (Date) object[pos++];
            ;
            Long pageKey = (Long) object[pos++];
            String pageStatus = (String) object[pos++];
            Date pageLastModified = (Date) object[pos++];
            Date pageLastPublication = (Date) object[pos++];
            Date bodyLastModified = (Date) object[pos++];
            Date partLastModified = (Date) object[pos++];
            Date recentLaunch = (Date) object[pos++];
            Date lastModified = pageLastModified;
            if (lastModified == null || (lastModified != null && partLastModified != null && partLastModified.after(lastModified))) {
                lastModified = partLastModified;
            }
            if (lastModified == null || (lastModified != null && bodyLastModified != null && bodyLastModified.after(lastModified))) {
                lastModified = bodyLastModified;
            }
            if (lastModified != null && (binder.getLastModified() == null || binder.getLastModified().before(lastModified))) {
                binder.setLastModified(lastModified);
            }
            if (binder.getRecentLaunch() == null) {
                binder.setRecentLaunch(recentLaunch);
            }
            if (pageKey != null && pageStatus == null) {
                binder.incrementNumOfDraftPages();
            } else if (StringHelper.containsNonWhitespace(pageStatus)) {
                PageStatus status = PageStatus.valueOf(pageStatus);
                if (PageStatus.isClosed(status, sectionEndDate, now)) {
                    binder.incrementNumOfClosedPages();
                } else if (PageStatus.draft.name().equals(pageStatus)) {
                    binder.incrementNumOfDraftPages();
                } else if (PageStatus.inRevision.name().equals(pageStatus)) {
                    binder.incrementNumOfInRevisionPages();
                }
            }
            if (recentLaunch == null && pageLastPublication != null) {
                binder.incrementNumOfNewlyPublishedPages();
            } else if (recentLaunch != null && pageLastPublication != null && recentLaunch.before(pageLastPublication)) {
                binder.incrementNumOfNewlyPublishedPages();
            }
            if (!sectionKeys.contains(sectionKey)) {
                SectionStatus status = SectionStatus.notStarted;
                if (StringHelper.containsNonWhitespace(sectionStatus)) {
                    status = SectionStatus.valueOf(sectionStatus);
                }
                if (status == SectionStatus.notStarted || status == SectionStatus.inProgress) {
                    binder.setNumOfOpenSections(binder.getNumOfOpenSections() + 1);
                }
                if (status == SectionStatus.inProgress || status == SectionStatus.submitted || status == SectionStatus.closed) {
                    if (binder.getSections() == null) {
                        binder.setSections(new ArrayList<>());
                    }
                    int sectionPos = sectionPosNumber == null ? -1 : sectionPosNumber.intValue();
                    binder.getSections().add(new AssessedBinderSection(sectionKey, sectionTitle, sectionPos));
                    sectionKeys.add(sectionKey);
                }
            }
        }
    }
}

Example 2 with AssessedBinder

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

the class SharedWithMeQueries method searchSharedBindersOne.

private List<AssessedBinder> searchSharedBindersOne(Identity member, String searchString) {
    StringBuilder sb = new StringBuilder(2048);
    sb.append("select binder.key, binder.title, entry.displayname, aEntry.score, aEntry.passed, owner").append(" from pfbinder as binder").append(" inner join binder.baseGroup as baseGroup").append(" inner join baseGroup.members as ownership on (ownership.role='").append(PortfolioRoles.owner.name()).append("')").append(" inner join ownership.identity as owner").append(" inner join fetch owner.user as owneruser").append(// entry -> assessment entry -> owner
    " left join binder.entry as entry").append(" left join assessmententry as aEntry on (aEntry.identity.key=owner.key and aEntry.repositoryEntry.key=entry.key and ((binder.subIdent is null and aEntry.subIdent is null) or binder.subIdent=aEntry.subIdent))").append(" where (").append(" exists (select membership.key from bgroupmember as membership").append("   where membership.group.key=baseGroup.key and membership.identity.key=:identityKey and membership.role in ('").append(PortfolioRoles.coach.name()).append("','").append(PortfolioRoles.reviewer.name()).append("')").append(" )").append(" or exists (select section.key from pfsection as section").append("   inner join section.baseGroup as sectionGroup").append("   inner join sectionGroup.members as sectionMembership on (sectionMembership.identity.key=:identityKey and sectionMembership.role in ('").append(PortfolioRoles.coach.name()).append("','").append(PortfolioRoles.reviewer.name()).append("'))").append("   where section.binder.key=binder.key").append(" )").append(" or exists (select page.key from pfpage as page").append("   inner join page.baseGroup as pageGroup").append("   inner join pageGroup.members as pageMembership on (pageMembership.identity.key=:identityKey and pageMembership.role in ('").append(PortfolioRoles.coach.name()).append("','").append(PortfolioRoles.reviewer.name()).append("'))").append("   where page.section.binder.key=binder.key").append(" ))");
    if (StringHelper.containsNonWhitespace(searchString)) {
        searchString = makeFuzzyQueryString(searchString);
        sb.append(" and (");
        appendFuzzyLike(sb, "binder.title", "searchString", dbInstance.getDbVendor());
        sb.append(" or ");
        appendFuzzyLike(sb, "binder.summary", "searchString", dbInstance.getDbVendor());
        sb.append(" or ");
        appendFuzzyLike(sb, "owner.name", "searchString", dbInstance.getDbVendor());
        sb.append(" or ");
        appendFuzzyLike(sb, "owneruser.lastName", "searchString", dbInstance.getDbVendor());
        sb.append(" or ");
        appendFuzzyLike(sb, "owneruser.firstName", "searchString", dbInstance.getDbVendor());
        sb.append(" or ");
        appendFuzzyLike(sb, "entry.displayname", "searchString", dbInstance.getDbVendor());
        sb.append(")");
    }
    sb.append(" and (binder.status is null or binder.status='").append(BinderStatus.open.name()).append("')");
    TypedQuery<Object[]> query = dbInstance.getCurrentEntityManager().createQuery(sb.toString(), Object[].class).setParameter("identityKey", member.getKey());
    if (StringHelper.containsNonWhitespace(searchString)) {
        query.setParameter("searchString", searchString.toLowerCase());
    }
    List<Object[]> objects = query.getResultList();
    List<AssessedBinder> assessedBinders = new ArrayList<>(objects.size());
    for (Object[] object : objects) {
        int pos = 0;
        Long binderKey = (Long) object[pos++];
        String binderTitle = (String) object[pos++];
        String entryDisplayname = (String) object[pos++];
        BigDecimal score = (BigDecimal) object[pos++];
        Boolean passed = (Boolean) object[pos++];
        Identity owner = (Identity) object[pos++];
        assessedBinders.add(new AssessedBinder(binderKey, binderTitle, entryDisplayname, passed, score, owner));
    }
    return assessedBinders;
}

Example 3 with AssessedBinder

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

the class SharedBindersController method loadModel.

private void loadModel(String searchString) {
    List<AssessedBinder> assessedBinders = portfolioService.searchSharedBindersWith(getIdentity(), searchString);
    List<SharedItemRow> rows = new ArrayList<>(assessedBinders.size());
    for (AssessedBinder assessedBinder : assessedBinders) {
        SharedItemRow row = new SharedItemRow(assessedBinder.getAssessedIdentity(), userPropertyHandlers, getLocale());
        row.setBinderTitle(assessedBinder.getBinderTitle());
        row.setBinderKey(assessedBinder.getBinderKey());
        row.setLastModified(assessedBinder.getLastModified());
        row.setEntryDisplayName(assessedBinder.getEntryDisplayname());
        row.setAssessmentEntry(assessedBinder);
        row.setRecentLaunch(assessedBinder.getRecentLaunch());
        List<AssessedBinderSection> sections = assessedBinder.getSections();
        if (sections != null && sections.size() > 1) {
            Collections.sort(sections, new AssessedBinderSectionComparator());
        }
        row.setSections(sections);
        row.setNumOfOpenSections(assessedBinder.getNumOfOpenSections());
        row.setNumOfDraftPages(assessedBinder.getNumOfDraftPages());
        row.setNumOfInRevisionPages(assessedBinder.getNumOfInRevisionPages());
        row.setNumOfClosedPages(assessedBinder.getNumOfClosedPages());
        row.setNumOfNewlyPublishedPages(assessedBinder.getNumOfNewlyPublishedPages());
        rows.add(row);
    }
    model.setObjects(rows);
    tableEl.reset();
    tableEl.reloadData();
}

Example 4 with AssessedBinder

use of org.olat.modules.portfolio.model.AssessedBinder in project OpenOLAT by OpenOLAT.

the class SharedWithMeQueries method searchSharedBindersOne.

private List<AssessedBinder> searchSharedBindersOne(Identity member, String searchString) {
    StringBuilder sb = new StringBuilder(2048);
    sb.append("select binder.key, binder.title, entry.displayname, aEntry.score, aEntry.passed, owner").append(" from pfbinder as binder").append(" inner join binder.baseGroup as baseGroup").append(" inner join baseGroup.members as ownership on (ownership.role='").append(PortfolioRoles.owner.name()).append("')").append(" inner join ownership.identity as owner").append(" inner join fetch owner.user as owneruser").append(// entry -> assessment entry -> owner
    " left join binder.entry as entry").append(" left join assessmententry as aEntry on (aEntry.identity.key=owner.key and aEntry.repositoryEntry.key=entry.key and ((binder.subIdent is null and aEntry.subIdent is null) or binder.subIdent=aEntry.subIdent))").append(" where (").append(" exists (select membership.key from bgroupmember as membership").append("   where membership.group.key=baseGroup.key and membership.identity.key=:identityKey and membership.role in ('").append(PortfolioRoles.coach.name()).append("','").append(PortfolioRoles.reviewer.name()).append("')").append(" )").append(" or exists (select section.key from pfsection as section").append("   inner join section.baseGroup as sectionGroup").append("   inner join sectionGroup.members as sectionMembership on (sectionMembership.identity.key=:identityKey and sectionMembership.role in ('").append(PortfolioRoles.coach.name()).append("','").append(PortfolioRoles.reviewer.name()).append("'))").append("   where section.binder.key=binder.key").append(" )").append(" or exists (select page.key from pfpage as page").append("   inner join page.baseGroup as pageGroup").append("   inner join pageGroup.members as pageMembership on (pageMembership.identity.key=:identityKey and pageMembership.role in ('").append(PortfolioRoles.coach.name()).append("','").append(PortfolioRoles.reviewer.name()).append("'))").append("   where page.section.binder.key=binder.key").append(" ))");
    if (StringHelper.containsNonWhitespace(searchString)) {
        searchString = makeFuzzyQueryString(searchString);
        sb.append(" and (");
        appendFuzzyLike(sb, "binder.title", "searchString", dbInstance.getDbVendor());
        sb.append(" or ");
        appendFuzzyLike(sb, "binder.summary", "searchString", dbInstance.getDbVendor());
        sb.append(" or ");
        appendFuzzyLike(sb, "owner.name", "searchString", dbInstance.getDbVendor());
        sb.append(" or ");
        appendFuzzyLike(sb, "owneruser.lastName", "searchString", dbInstance.getDbVendor());
        sb.append(" or ");
        appendFuzzyLike(sb, "owneruser.firstName", "searchString", dbInstance.getDbVendor());
        sb.append(" or ");
        appendFuzzyLike(sb, "entry.displayname", "searchString", dbInstance.getDbVendor());
        sb.append(")");
    }
    sb.append(" and (binder.status is null or binder.status='").append(BinderStatus.open.name()).append("')");
    TypedQuery<Object[]> query = dbInstance.getCurrentEntityManager().createQuery(sb.toString(), Object[].class).setParameter("identityKey", member.getKey());
    if (StringHelper.containsNonWhitespace(searchString)) {
        query.setParameter("searchString", searchString.toLowerCase());
    }
    List<Object[]> objects = query.getResultList();
    List<AssessedBinder> assessedBinders = new ArrayList<>(objects.size());
    for (Object[] object : objects) {
        int pos = 0;
        Long binderKey = (Long) object[pos++];
        String binderTitle = (String) object[pos++];
        String entryDisplayname = (String) object[pos++];
        BigDecimal score = (BigDecimal) object[pos++];
        Boolean passed = (Boolean) object[pos++];
        Identity owner = (Identity) object[pos++];
        assessedBinders.add(new AssessedBinder(binderKey, binderTitle, entryDisplayname, passed, score, owner));
    }
    return assessedBinders;
}

Example 5 with AssessedBinder

use of org.olat.modules.portfolio.model.AssessedBinder in project OpenOLAT by OpenOLAT.

the class SharedBindersController method loadModel.

private void loadModel(String searchString) {
    List<AssessedBinder> assessedBinders = portfolioService.searchSharedBindersWith(getIdentity(), searchString);
    List<SharedItemRow> rows = new ArrayList<>(assessedBinders.size());
    for (AssessedBinder assessedBinder : assessedBinders) {
        SharedItemRow row = new SharedItemRow(assessedBinder.getAssessedIdentity(), userPropertyHandlers, getLocale());
        row.setBinderTitle(assessedBinder.getBinderTitle());
        row.setBinderKey(assessedBinder.getBinderKey());
        row.setLastModified(assessedBinder.getLastModified());
        row.setEntryDisplayName(assessedBinder.getEntryDisplayname());
        row.setAssessmentEntry(assessedBinder);
        row.setRecentLaunch(assessedBinder.getRecentLaunch());
        List<AssessedBinderSection> sections = assessedBinder.getSections();
        if (sections != null && sections.size() > 1) {
            Collections.sort(sections, new AssessedBinderSectionComparator());
        }
        row.setSections(sections);
        row.setNumOfOpenSections(assessedBinder.getNumOfOpenSections());
        row.setNumOfDraftPages(assessedBinder.getNumOfDraftPages());
        row.setNumOfInRevisionPages(assessedBinder.getNumOfInRevisionPages());
        row.setNumOfClosedPages(assessedBinder.getNumOfClosedPages());
        row.setNumOfNewlyPublishedPages(assessedBinder.getNumOfNewlyPublishedPages());
        rows.add(row);
    }
    model.setObjects(rows);
    tableEl.reset();
    tableEl.reloadData();
}