Examples with CourseStatEntry org.olat.modules.coach.model.CourseStatEntry used on opensource projects

Example 1 with CourseStatEntry

use of org.olat.modules.coach.model.CourseStatEntry in project OpenOLAT by OpenOLAT.

the class CourseListController method previousCourse.

private void previousCourse(UserRequest ureq) {
    CourseStatEntry currentEntry = courseCtrl.getEntry();
    int previousIndex = tableCtr.getIndexOfSortedObject(currentEntry) - 1;
    if (previousIndex < 0 || previousIndex >= tableCtr.getRowCount()) {
        previousIndex = tableCtr.getRowCount() - 1;
    }
    CourseStatEntry previousEntry = (CourseStatEntry) tableCtr.getSortedObjectAt(previousIndex);
    selectCourse(ureq, previousEntry);
}

Example 2 with CourseStatEntry

use of org.olat.modules.coach.model.CourseStatEntry in project OpenOLAT by OpenOLAT.

the class CourseListController method nextCourse.

private void nextCourse(UserRequest ureq) {
    CourseStatEntry currentEntry = courseCtrl.getEntry();
    int nextIndex = tableCtr.getIndexOfSortedObject(currentEntry) + 1;
    if (nextIndex < 0 || nextIndex >= tableCtr.getRowCount()) {
        nextIndex = 0;
    }
    CourseStatEntry nextEntry = (CourseStatEntry) tableCtr.getSortedObjectAt(nextIndex);
    selectCourse(ureq, nextEntry);
}

Example 3 with CourseStatEntry

use of org.olat.modules.coach.model.CourseStatEntry in project OpenOLAT by OpenOLAT.

the class CourseListController method event.

@Override
protected void event(UserRequest ureq, Controller source, Event event) {
    if (source == tableCtr) {
        if (event instanceof TableEvent) {
            TableEvent e = (TableEvent) event;
            if ("select".equals(e.getActionId())) {
                CourseStatEntry courseStat = (CourseStatEntry) tableCtr.getTableDataModel().getObject(e.getRowId());
                selectCourse(ureq, courseStat);
            }
        }
    } else if (source == courseCtrl) {
        if (event == Event.CHANGED_EVENT) {
            hasChanged = true;
        } else if ("next.course".equals(event.getCommand())) {
            nextCourse(ureq);
        } else if ("previous.course".equals(event.getCommand())) {
            previousCourse(ureq);
        }
    }
    super.event(ureq, source, event);
}

Example 4 with CourseStatEntry

use of org.olat.modules.coach.model.CourseStatEntry in project OpenOLAT by OpenOLAT.

the class CoachingDAO method getCoursesStatisticsUserInfosForCoach.

private boolean getCoursesStatisticsUserInfosForCoach(Identity coach, Map<Long, CourseStatEntry> map) {
    NativeQueryBuilder sb = new NativeQueryBuilder(1024, dbInstance);
    sb.append("select").append("  sg_re.repositoryentry_id as re_id,").append("  count(distinct sg_participant.fk_identity_id) as student_id,").append("  count(distinct pg_initial_launch.id) as pg_id").append(" from o_repositoryentry sg_re ").append(" inner join o_re_to_group togroup on (togroup.fk_entry_id = sg_re.repositoryentry_id)").append(" inner join o_bs_group_member sg_coach on (sg_coach.fk_group_id=togroup.fk_group_id and sg_coach.g_role = 'coach')").append(" inner join o_bs_group_member sg_participant on (sg_participant.fk_group_id=sg_coach.fk_group_id and sg_participant.g_role='participant')").append(" left join o_as_user_course_infos pg_initial_launch").append("   on (pg_initial_launch.fk_resource_id = sg_re.fk_olatresource and pg_initial_launch.fk_identity = sg_participant.fk_identity_id)").append(" where sg_coach.fk_identity_id=:coachKey and ( ").append("   (sg_re.accesscode >= ").append(RepositoryEntry.ACC_USERS).append(// BAR
    " and sg_coach.g_role = 'coach') ").append("   or ").append("   (sg_re.accesscode = ").append(RepositoryEntry.ACC_OWNERS).append(" and sg_re.membersonly=").appendTrue().append(")) ").append(" group by sg_re.repositoryentry_id");
    List<?> rawList = dbInstance.getCurrentEntityManager().createNativeQuery(sb.toString()).setParameter("coachKey", coach.getKey()).getResultList();
    for (Object rawObject : rawList) {
        Object[] rawStats = (Object[]) rawObject;
        Long repoKey = ((Number) rawStats[0]).longValue();
        CourseStatEntry entry = map.get(repoKey);
        if (entry != null) {
            entry.setCountStudents(((Number) rawStats[1]).intValue());
            entry.setInitialLaunch(((Number) rawStats[2]).intValue());
        }
    }
    return rawList.size() > 0;
}

Example 5 with CourseStatEntry

use of org.olat.modules.coach.model.CourseStatEntry in project OpenOLAT by OpenOLAT.

the class CoachingDAOTest method getStatistics_owner.

@Test
public void getStatistics_owner() throws URISyntaxException {
    URL coachingCourseUrl = CoachingLargeTest.class.getResource("CoachingCourse.zip");
    File coachingCourseFile = new File(coachingCourseUrl.toURI());
    RepositoryEntry re1 = CourseFactory.deployCourseFromZIP(coachingCourseFile, UUID.randomUUID().toString(), 4);
    RepositoryEntry re2 = CourseFactory.deployCourseFromZIP(coachingCourseFile, UUID.randomUUID().toString(), 4);
    RepositoryEntry re3 = CourseFactory.deployCourseFromZIP(coachingCourseFile, UUID.randomUUID().toString(), 4);
    dbInstance.commitAndCloseSession();
    // members of courses
    Identity coach = JunitTestHelper.createAndPersistIdentityAsAuthor("Coach-1-" + UUID.randomUUID());
    repositoryService.addRole(coach, re1, GroupRoles.owner.name());
    repositoryService.addRole(coach, re2, GroupRoles.owner.name());
    repositoryService.addRole(coach, re3, GroupRoles.coach.name());
    Identity participant1 = JunitTestHelper.createAndPersistIdentityAsRndUser("Coaching-Part-1");
    repositoryService.addRole(participant1, re1, GroupRoles.participant.name());
    Identity participant2 = JunitTestHelper.createAndPersistIdentityAsRndUser("Coaching-Part-2");
    repositoryService.addRole(participant2, re1, GroupRoles.participant.name());
    dbInstance.commitAndCloseSession();
    // members of group of re 2
    BusinessGroup group2 = businessGroupService.createBusinessGroup(null, "Coaching-grp-1", "tg", null, null, false, false, re2);
    Identity participant3 = JunitTestHelper.createAndPersistIdentityAsRndUser("Coaching-Part-3");
    businessGroupRelationDao.addRole(participant3, group2, GroupRoles.participant.name());
    Identity participant4 = JunitTestHelper.createAndPersistIdentityAsRndUser("Coaching-Part-4");
    businessGroupRelationDao.addRole(participant4, group2, GroupRoles.participant.name());
    dbInstance.commitAndCloseSession();
    // members of group of re 3
    BusinessGroup group3 = businessGroupService.createBusinessGroup(null, "Coaching-grp-1", "tg", null, null, false, false, re3);
    Identity participant5 = JunitTestHelper.createAndPersistIdentityAsRndUser("Coaching-Part-5");
    businessGroupRelationDao.addRole(participant5, group3, GroupRoles.participant.name());
    Identity participant6 = JunitTestHelper.createAndPersistIdentityAsRndUser("Coaching-Part-6");
    businessGroupRelationDao.addRole(participant6, group3, GroupRoles.participant.name());
    dbInstance.commitAndCloseSession();
    // make statements participant 1
    effManager.createUserEfficiencyStatement(new Date(), 6.0f, true, participant1, re1.getOlatResource());
    effManager.createUserEfficiencyStatement(new Date(), 4.0f, false, participant2, re1.getOlatResource());
    effManager.createUserEfficiencyStatement(new Date(), 5.5f, true, participant3, re2.getOlatResource());
    effManager.createUserEfficiencyStatement(new Date(), null, null, participant4, re2.getOlatResource());
    effManager.createUserEfficiencyStatement(new Date(), 4.0f, true, participant5, re3.getOlatResource());
    effManager.createUserEfficiencyStatement(new Date(), 3.0f, false, participant6, re3.getOlatResource());
    dbInstance.commitAndCloseSession();
    // make user infos
    userCourseInformationsManager.updateUserCourseInformations(re1.getOlatResource(), participant1);
    userCourseInformationsManager.updateUserCourseInformations(re2.getOlatResource(), participant1);
    userCourseInformationsManager.updateUserCourseInformations(re3.getOlatResource(), participant1);
    userCourseInformationsManager.updateUserCourseInformations(re1.getOlatResource(), participant2);
    userCourseInformationsManager.updateUserCourseInformations(re2.getOlatResource(), participant2);
    userCourseInformationsManager.updateUserCourseInformations(re2.getOlatResource(), participant3);
    userCourseInformationsManager.updateUserCourseInformations(re2.getOlatResource(), participant4);
    userCourseInformationsManager.updateUserCourseInformations(re3.getOlatResource(), participant5);
    userCourseInformationsManager.updateUserCourseInformations(re3.getOlatResource(), participant6);
    dbInstance.commitAndCloseSession();
    // owner can see participant 1,2,3 and 4
    // p1 has 1 assessment in re1
    // p2 has 1 assessment in re1
    // p3 has 2 assessments in re1 and re2
    // p4 has 1 assessment in re2
    // 5 and p6 has 1 assessment in re3
    List<GroupStatEntry> nativeGroupStats = coachingDAO.getGroupsStatisticsNative(coach);
    Assert.assertNotNull(nativeGroupStats);
    Assert.assertEquals(1, nativeGroupStats.size());
    GroupStatEntry entryGroup2 = getGroupStatEntry(group2, nativeGroupStats);
    Assert.assertNotNull(entryGroup2);
    Assert.assertEquals(2, entryGroup2.getCountDistinctStudents());
    Assert.assertEquals(2, entryGroup2.getInitialLaunch());
    Assert.assertEquals(1, entryGroup2.getCountPassed());
    Assert.assertEquals(0, entryGroup2.getCountFailed());
    Assert.assertEquals(1, entryGroup2.getCountNotAttempted());
    Assert.assertEquals(5.5f, entryGroup2.getAverageScore(), 0.0001f);
    // re 3 is removed because coach has no visible participants within
    List<CourseStatEntry> nativeCourseStats = coachingDAO.getCoursesStatisticsNative(coach);
    Assert.assertNotNull(nativeCourseStats);
    Assert.assertEquals(2, nativeCourseStats.size());
    // re 1
    CourseStatEntry entryCourse1 = getCourseStatEntry(re1, nativeCourseStats);
    Assert.assertNotNull(entryCourse1);
    Assert.assertEquals(2, entryCourse1.getCountStudents());
    Assert.assertEquals(2, entryCourse1.getInitialLaunch());
    Assert.assertEquals(1, entryCourse1.getCountPassed());
    Assert.assertEquals(1, entryCourse1.getCountFailed());
    Assert.assertEquals(0, entryCourse1.getCountNotAttempted());
    Assert.assertEquals(5.0f, entryCourse1.getAverageScore(), 0.0001f);
    // re 2
    CourseStatEntry entryCourse2 = getCourseStatEntry(re2, nativeCourseStats);
    Assert.assertNotNull(entryCourse2);
    Assert.assertEquals(2, entryCourse2.getCountStudents());
    Assert.assertEquals(2, entryCourse2.getInitialLaunch());
    Assert.assertEquals(1, entryCourse2.getCountPassed());
    Assert.assertEquals(0, entryCourse2.getCountFailed());
    Assert.assertEquals(1, entryCourse2.getCountNotAttempted());
    Assert.assertEquals(5.5f, entryCourse2.getAverageScore(), 0.0001f);
    List<UserPropertyHandler> userPropertyHandlers = userManager.getUserPropertyHandlersFor(UserListController.usageIdentifyer, false);
    // user native
    List<StudentStatEntry> nativeUserStats = coachingDAO.getStudentsStatisticsNative(coach, userPropertyHandlers);
    Assert.assertNotNull(nativeUserStats);
    Assert.assertEquals(4, nativeUserStats.size());
    // participant1 is only in re 1
    StudentStatEntry entryParticipant1 = getStudentStatEntry(participant1, nativeUserStats);
    Assert.assertNotNull(entryParticipant1);
    Assert.assertEquals(1, entryParticipant1.getCountPassed());
    Assert.assertEquals(0, entryParticipant1.getCountFailed());
    Assert.assertEquals(0, entryParticipant1.getCountNotAttempted());
    Assert.assertEquals(1, entryParticipant1.getInitialLaunch());
    Assert.assertEquals(1, entryParticipant1.getCountRepo());
    // participant2 is only in re 1
    StudentStatEntry entryParticipant2 = getStudentStatEntry(participant2, nativeUserStats);
    Assert.assertNotNull(entryParticipant2);
    Assert.assertEquals(0, entryParticipant2.getCountPassed());
    Assert.assertEquals(1, entryParticipant2.getCountFailed());
    Assert.assertEquals(0, entryParticipant2.getCountNotAttempted());
    Assert.assertEquals(1, entryParticipant2.getInitialLaunch());
    Assert.assertEquals(1, entryParticipant2.getCountRepo());
    // participant3 is in re 2 ( via group 2)
    StudentStatEntry entryParticipant3 = getStudentStatEntry(participant3, nativeUserStats);
    Assert.assertNotNull(entryParticipant3);
    Assert.assertEquals(1, entryParticipant3.getCountPassed());
    Assert.assertEquals(0, entryParticipant3.getCountFailed());
    Assert.assertEquals(0, entryParticipant3.getCountNotAttempted());
    Assert.assertEquals(1, entryParticipant3.getInitialLaunch());
    Assert.assertEquals(1, entryParticipant3.getCountRepo());
    // participant4 is in re 2 ( via group 2)
    StudentStatEntry entryParticipant4 = getStudentStatEntry(participant4, nativeUserStats);
    Assert.assertNotNull(entryParticipant4);
    Assert.assertEquals(0, entryParticipant4.getCountPassed());
    Assert.assertEquals(0, entryParticipant4.getCountFailed());
    Assert.assertEquals(1, entryParticipant4.getCountNotAttempted());
    Assert.assertEquals(1, entryParticipant4.getInitialLaunch());
    Assert.assertEquals(1, entryParticipant4.getCountRepo());
}