Examples with LectureBlockWithTeachers org.olat.modules.lecture.model.LectureBlockWithTeachers used on opensource projects

Example 11 with LectureBlockWithTeachers

use of org.olat.modules.lecture.model.LectureBlockWithTeachers in project openolat by klemens.

the class LectureBlockDAO method getLecturesBlockWithTeachers.

/**
 * @param entry The course (mandatory)
 * @param teacher The teacher (optional)
 * @return
 */
public List<LectureBlockWithTeachers> getLecturesBlockWithTeachers(RepositoryEntryRef entry) {
    List<LectureBlock> blocks = getLectureBlocks(entry);
    Map<Long, LectureBlockWithTeachers> blockMap = new HashMap<>();
    for (LectureBlock block : blocks) {
        blockMap.put(block.getKey(), new LectureBlockWithTeachers(block));
    }
    // append the coaches
    StringBuilder sc = new StringBuilder();
    sc.append("select block.key, coach").append(" from lectureblock block").append(" inner join block.teacherGroup tGroup").append(" inner join tGroup.members membership").append(" inner join membership.identity coach").append(" inner join fetch coach.user usercoach").append(" where membership.role='").append("teacher").append("' and block.entry.key=:repoEntryKey");
    // get all, it's quick
    List<Object[]> rawCoachs = dbInstance.getCurrentEntityManager().createQuery(sc.toString(), Object[].class).setParameter("repoEntryKey", entry.getKey()).getResultList();
    for (Object[] rawCoach : rawCoachs) {
        Long blockKey = (Long) rawCoach[0];
        Identity coach = (Identity) rawCoach[1];
        LectureBlockWithTeachers block = blockMap.get(blockKey);
        if (block != null) {
            block.getTeachers().add(coach);
        }
    }
    return new ArrayList<>(blockMap.values());
}

Example 12 with LectureBlockWithTeachers

use of org.olat.modules.lecture.model.LectureBlockWithTeachers in project openolat by klemens.

the class LecturesBlocksEntryExport method addContent.

private void addContent(OpenXMLWorksheet exportSheet) {
    for (LectureBlockWithTeachers block : blocks) {
        Row row = exportSheet.newRow();
        LectureBlock lectureBlock = block.getLectureBlock();
        int pos = 0;
        row.addCell(pos++, lectureBlock.getTitle());
        row.addCell(pos++, lectureBlock.getLocation());
        row.addCell(pos++, formatDate(lectureBlock.getStartDate()));
        row.addCell(pos++, formatTime(lectureBlock.getStartDate()));
        row.addCell(pos++, formatTime(lectureBlock.getEndDate()));
        StringBuilder teachers = new StringBuilder();
        for (Identity teacher : block.getTeachers()) {
            if (teachers.length() > 0)
                teachers.append(", ");
            teachers.append(userManager.getUserDisplayName(teacher));
        }
        row.addCell(pos++, teachers.toString());
        if (lectureBlock.getRollCallStatus() == null) {
            pos++;
        } else {
            String status = LectureBlockStatusCellRenderer.getStatus(lectureBlock, translator);
            if (status != null) {
                row.addCell(pos++, status);
            } else {
                pos++;
            }
        }
        row.addCell(pos++, formatter.formatDate(lectureBlock.getAutoClosedDate()));
        row.addCell(pos++, toInt(lectureBlock.getPlannedLecturesNumber()));
        row.addCell(pos++, toInt(lectureBlock.getEffectiveLecturesNumber()));
        row.addCell(pos++, formatTime(lectureBlock.getEffectiveEndDate()));
        Reason reason = lectureBlock.getReasonEffectiveEnd();
        if (reason == null) {
            pos++;
        } else {
            row.addCell(pos++, reason.getTitle());
        }
        row.addCell(pos++, lectureBlock.getComment());
    }
}