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

Example 6 with AssessedBinder

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

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);
                }
            }
        }
    }
}