Search in sources :

Example 31 with StudentStatEntry

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

the class CoachingDAO method getStudentsStastisticInfosForOwner.

private boolean getStudentsStastisticInfosForOwner(IdentityRef coach, Map<Long, StudentStatEntry> map, List<UserPropertyHandler> userPropertyHandlers) {
    NativeQueryBuilder sb = new NativeQueryBuilder(1024, dbInstance);
    sb.append("select").append("  sg_participant_id.id as part_id,").append("  sg_participant_id.name as part_name,").append("  sg_participant_user.user_id as part_user_id,");
    writeUserProperties("sg_participant_user", sb, userPropertyHandlers);
    sb.append("  ").appendToArray("sg_re.repositoryentry_id").append(" as re_ids,").append("  ").appendToArray("pg_initial_launch.id").append(" as pg_ids").append(" from o_repositoryentry sg_re").append(" inner join o_re_to_group owngroup on (owngroup.fk_entry_id = sg_re.repositoryentry_id)").append(" inner join o_bs_group_member sg_owner on (sg_owner.fk_group_id=owngroup.fk_group_id ").append("  and owngroup.r_defgroup=").appendTrue().append(" and sg_owner.g_role='owner' and sg_owner.fk_identity_id=:coachKey)").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_participant on (sg_participant.fk_group_id=togroup.fk_group_id and sg_participant.g_role='participant')").append(" inner join o_bs_identity sg_participant_id on (sg_participant_id.id=sg_participant.fk_identity_id)").append(" inner join o_user sg_participant_user on (sg_participant_user.fk_identity=sg_participant_id.id)").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_id.id)").append(" where sg_re.accesscode >= ").append(RepositoryEntry.ACC_OWNERS).append(" and sg_re.fk_olatresource in (").append("  select sg_res.resource_id from o_olatresource sg_res where sg_res.resname = 'CourseModule'").append(" )").append(" group by sg_participant_id.id, sg_participant_user.user_id");
    if (dbInstance.isOracle()) {
        sb.append(", sg_participant_id.name");
        writeUserPropertiesGroupBy("sg_participant_user", sb, userPropertyHandlers);
    }
    List<?> rawList = dbInstance.getCurrentEntityManager().createNativeQuery(sb.toString()).setParameter("coachKey", coach.getKey()).getResultList();
    int numOfProperties = userPropertyHandlers.size();
    Map<Long, StudentStatEntry> stats = new HashMap<>();
    for (Object rawObject : rawList) {
        Object[] rawStat = (Object[]) rawObject;
        int pos = 0;
        Long identityKey = ((Number) rawStat[pos++]).longValue();
        String identityName = (String) rawStat[pos++];
        // user key
        ((Number) rawStat[pos++]).longValue();
        StudentStatEntry entry;
        if (map.containsKey(identityKey)) {
            entry = map.get(identityKey);
            pos += numOfProperties;
        } else {
            String[] userProperties = new String[numOfProperties];
            for (int i = 0; i < numOfProperties; i++) {
                userProperties[i] = (String) rawStat[pos++];
            }
            entry = new StudentStatEntry(identityKey, identityName, userProperties);
            map.put(identityKey, entry);
        }
        appendArrayToSet(rawStat[pos++], entry.getRepoIds());
        appendArrayToSet(rawStat[pos++], entry.getLaunchIds());
        stats.put(entry.getIdentityKey(), entry);
    }
    return rawList.size() > 0;
}
Also used : HashMap(java.util.HashMap) NativeQueryBuilder(org.olat.core.commons.persistence.NativeQueryBuilder) StudentStatEntry(org.olat.modules.coach.model.StudentStatEntry)

Example 32 with StudentStatEntry

use of org.olat.modules.coach.model.StudentStatEntry in project openolat by klemens.

the class CoachingDAOTest method getStatistics_emptyStatements_emptyCourseInfos.

/**
 * This is an important test to check if the return values of the statistics
 * are correctly handled because some of them can be null or 0.
 *
 * @throws URISyntaxException
 */
@Test
public void getStatistics_emptyStatements_emptyCourseInfos() 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);
    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.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();
    // groups
    BusinessGroup group1 = businessGroupService.createBusinessGroup(null, "Coaching-grp-1", "tg", null, null, false, false, re1);
    Identity participant3 = JunitTestHelper.createAndPersistIdentityAsRndUser("Coaching-Part-3");
    businessGroupRelationDao.addRole(participant3, group1, GroupRoles.participant.name());
    Identity participant4 = JunitTestHelper.createAndPersistIdentityAsRndUser("Coaching-Part-4");
    businessGroupRelationDao.addRole(participant4, group1, GroupRoles.participant.name());
    dbInstance.commitAndCloseSession();
    // check groups statistics
    List<GroupStatEntry> nativeGroupStats = coachingDAO.getGroupsStatisticsNative(coach);
    Assert.assertNotNull(nativeGroupStats);
    Assert.assertEquals(1, nativeGroupStats.size());
    GroupStatEntry entryGroup1 = getGroupStatEntry(group1, nativeGroupStats);
    Assert.assertNotNull(entryGroup1);
    Assert.assertEquals(2, entryGroup1.getCountDistinctStudents());
    Assert.assertEquals(0, entryGroup1.getInitialLaunch());
    Assert.assertEquals(0, entryGroup1.getCountPassed());
    Assert.assertEquals(0, entryGroup1.getCountFailed());
    Assert.assertEquals(2, entryGroup1.getCountNotAttempted());
    Assert.assertNull(entryGroup1.getAverageScore());
    // courses
    List<CourseStatEntry> nativeCourseStats = coachingDAO.getCoursesStatisticsNative(coach);
    Assert.assertNotNull(nativeCourseStats);
    Assert.assertEquals(1, nativeCourseStats.size());
    // re 1
    CourseStatEntry entryCourse1 = getCourseStatEntry(re1, nativeCourseStats);
    Assert.assertNotNull(entryCourse1);
    Assert.assertEquals(4, entryCourse1.getCountStudents());
    Assert.assertEquals(0, entryCourse1.getInitialLaunch());
    Assert.assertEquals(0, entryCourse1.getCountPassed());
    Assert.assertEquals(0, entryCourse1.getCountFailed());
    Assert.assertEquals(4, entryCourse1.getCountNotAttempted());
    Assert.assertNull(entryCourse1.getAverageScore());
    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());
    // participants have all the same statistics
    Identity[] participants = new Identity[] { participant1, participant2, participant3, participant4 };
    for (Identity participant : participants) {
        StudentStatEntry entryParticipant = getStudentStatEntry(participant, nativeUserStats);
        Assert.assertNotNull(entryParticipant);
        Assert.assertEquals(0, entryParticipant.getCountPassed());
        Assert.assertEquals(0, entryParticipant.getCountFailed());
        Assert.assertEquals(1, entryParticipant.getCountNotAttempted());
        Assert.assertEquals(0, entryParticipant.getInitialLaunch());
        Assert.assertEquals(1, entryParticipant.getCountRepo());
    }
}
Also used : BusinessGroup(org.olat.group.BusinessGroup) RepositoryEntry(org.olat.repository.RepositoryEntry) URL(java.net.URL) GroupStatEntry(org.olat.modules.coach.model.GroupStatEntry) StudentStatEntry(org.olat.modules.coach.model.StudentStatEntry) CourseStatEntry(org.olat.modules.coach.model.CourseStatEntry) Identity(org.olat.core.id.Identity) File(java.io.File) UserPropertyHandler(org.olat.user.propertyhandlers.UserPropertyHandler) CoachingLargeTest(org.olat.modules.coach.CoachingLargeTest) Test(org.junit.Test)

Example 33 with StudentStatEntry

use of org.olat.modules.coach.model.StudentStatEntry in project openolat by klemens.

the class CoachingDAOTest method getStatistics_notAttempted.

/**
 * 3 courses in the same business group
 *
 * @throws URISyntaxException
 */
@Test
public void getStatistics_notAttempted() 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, re1, GroupRoles.coach.name());
    repositoryService.addRole(coach, re2, GroupRoles.coach.name());
    repositoryService.addRole(coach, re3, GroupRoles.coach.name());
    Identity participant1 = JunitTestHelper.createAndPersistIdentityAsRndUser("Coaching-Part-1");
    repositoryService.addRole(participant1, re2, GroupRoles.participant.name());
    Identity participant2 = JunitTestHelper.createAndPersistIdentityAsRndUser("Coaching-Part-2");
    repositoryService.addRole(participant2, re1, GroupRoles.participant.name());
    dbInstance.commitAndCloseSession();
    // members of 2 groups
    BusinessGroup group = businessGroupService.createBusinessGroup(coach, "Coaching-grp-1", "tg", null, null, false, false, re1);
    businessGroupService.addResourceTo(group, re2);
    businessGroupService.addResourceTo(group, re3);
    businessGroupRelationDao.addRole(participant1, group, GroupRoles.participant.name());
    businessGroupRelationDao.addRole(participant2, group, 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, participant1, re2.getOlatResource());
    effManager.createUserEfficiencyStatement(new Date(), 2.0f, false, participant1, re3.getOlatResource());
    // make statements participant 2
    effManager.createUserEfficiencyStatement(new Date(), 6.0f, true, participant2, re1.getOlatResource());
    effManager.createUserEfficiencyStatement(new Date(), null, null, participant2, re2.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);
    dbInstance.commitAndCloseSession();
    // check course
    List<CourseStatEntry> nativeStats = coachingDAO.getCoursesStatisticsNative(coach);
    Assert.assertNotNull(nativeStats);
    Assert.assertEquals(3, nativeStats.size());
    CourseStatEntry entryRe1 = getCourseStatEntry(re1, nativeStats);
    Assert.assertEquals(2, entryRe1.getCountStudents());
    Assert.assertEquals(2, entryRe1.getCountPassed());
    Assert.assertEquals(0, entryRe1.getCountFailed());
    Assert.assertEquals(0, entryRe1.getCountNotAttempted());
    Assert.assertEquals(2, entryRe1.getInitialLaunch());
    Assert.assertEquals(6.0f, entryRe1.getAverageScore(), 0.0001);
    CourseStatEntry entryRe2 = getCourseStatEntry(re2, nativeStats);
    Assert.assertEquals(2, entryRe2.getCountStudents());
    Assert.assertEquals(0, entryRe2.getCountPassed());
    Assert.assertEquals(1, entryRe2.getCountFailed());
    Assert.assertEquals(1, entryRe2.getCountNotAttempted());
    Assert.assertEquals(2, entryRe2.getInitialLaunch());
    Assert.assertEquals(4.0f, entryRe2.getAverageScore(), 0.0001);
    CourseStatEntry entryRe3 = getCourseStatEntry(re3, nativeStats);
    Assert.assertEquals(2, entryRe3.getCountStudents());
    Assert.assertEquals(0, entryRe3.getCountPassed());
    Assert.assertEquals(1, entryRe3.getCountFailed());
    Assert.assertEquals(1, entryRe3.getCountNotAttempted());
    Assert.assertEquals(1, entryRe3.getInitialLaunch());
    Assert.assertEquals(2.0f, entryRe3.getAverageScore(), 0.0001);
    List<UserPropertyHandler> userPropertyHandlers = userManager.getUserPropertyHandlersFor(UserListController.usageIdentifyer, false);
    // user native
    List<StudentStatEntry> nativeUserStats = coachingDAO.getStudentsStatisticsNative(coach, userPropertyHandlers);
    Assert.assertNotNull(nativeUserStats);
    Assert.assertEquals(2, nativeUserStats.size());
    // participant1
    StudentStatEntry entryParticipant1 = getStudentStatEntry(participant1, nativeUserStats);
    Assert.assertNotNull(entryParticipant1);
    Assert.assertEquals(1, entryParticipant1.getCountPassed());
    Assert.assertEquals(2, entryParticipant1.getCountFailed());
    Assert.assertEquals(0, entryParticipant1.getCountNotAttempted());
    Assert.assertEquals(3, entryParticipant1.getInitialLaunch());
    Assert.assertEquals(3, entryParticipant1.getCountRepo());
    // participant2
    StudentStatEntry entryParticipant2 = getStudentStatEntry(participant2, nativeUserStats);
    Assert.assertNotNull(entryParticipant2);
    Assert.assertEquals(1, entryParticipant2.getCountPassed());
    Assert.assertEquals(0, entryParticipant2.getCountFailed());
    Assert.assertEquals(2, entryParticipant2.getCountNotAttempted());
    Assert.assertEquals(2, entryParticipant2.getInitialLaunch());
    Assert.assertEquals(3, entryParticipant1.getCountRepo());
    // group native
    List<GroupStatEntry> nativeGroupStats = coachingDAO.getGroupsStatisticsNative(coach);
    Assert.assertNotNull(nativeGroupStats);
    Assert.assertEquals(1, nativeGroupStats.size());
    // group 1
    GroupStatEntry entryGroup1 = getGroupStatEntry(group, nativeGroupStats);
    Assert.assertNotNull(entryGroup1);
    Assert.assertEquals(6, entryGroup1.getCountStudents());
    Assert.assertEquals(2, entryGroup1.getCountDistinctStudents());
    Assert.assertEquals(3, entryGroup1.getCountCourses());
    Assert.assertEquals(2, entryGroup1.getCountPassed());
    Assert.assertEquals(2, entryGroup1.getCountFailed());
    Assert.assertEquals(2, entryGroup1.getCountNotAttempted());
    Assert.assertEquals(5, entryGroup1.getInitialLaunch());
    Assert.assertEquals(4.5f, entryGroup1.getAverageScore(), 0.0001f);
}
Also used : BusinessGroup(org.olat.group.BusinessGroup) RepositoryEntry(org.olat.repository.RepositoryEntry) URL(java.net.URL) Date(java.util.Date) StudentStatEntry(org.olat.modules.coach.model.StudentStatEntry) GroupStatEntry(org.olat.modules.coach.model.GroupStatEntry) CourseStatEntry(org.olat.modules.coach.model.CourseStatEntry) Identity(org.olat.core.id.Identity) File(java.io.File) UserPropertyHandler(org.olat.user.propertyhandlers.UserPropertyHandler) CoachingLargeTest(org.olat.modules.coach.CoachingLargeTest) Test(org.junit.Test)

Example 34 with StudentStatEntry

use of org.olat.modules.coach.model.StudentStatEntry in project openolat by klemens.

the class CoachingDAOTest method getStatistics_permissionOnCourses.

/**
 * Check the access permissions on course (coach can only see courses with memebrsOnly, or access >= 3)
 *
 * @throws URISyntaxException
 */
@Test
public void getStatistics_permissionOnCourses() throws URISyntaxException {
    URL coachingCourseUrl = CoachingLargeTest.class.getResource("CoachingCourse.zip");
    File coachingCourseFile = new File(coachingCourseUrl.toURI());
    RepositoryEntry re1 = CourseFactory.deployCourseFromZIP(coachingCourseFile, UUID.randomUUID().toString(), 1);
    RepositoryEntry re2 = CourseFactory.deployCourseFromZIP(coachingCourseFile, UUID.randomUUID().toString(), 2);
    RepositoryEntry re3 = CourseFactory.deployCourseFromZIP(coachingCourseFile, UUID.randomUUID().toString(), 3);
    dbInstance.commitAndCloseSession();
    // members of courses
    Identity courseCoach = JunitTestHelper.createAndPersistIdentityAsAuthor("Coach-1-" + UUID.randomUUID());
    Identity groupCoach = JunitTestHelper.createAndPersistIdentityAsAuthor("Coach-1-" + UUID.randomUUID());
    repositoryService.addRole(courseCoach, re1, GroupRoles.coach.name());
    repositoryService.addRole(courseCoach, re2, GroupRoles.coach.name());
    repositoryService.addRole(courseCoach, re3, GroupRoles.coach.name());
    // add participants to courses
    Identity participant1 = JunitTestHelper.createAndPersistIdentityAsRndUser("Coaching-Part-1");
    repositoryService.addRole(participant1, re1, GroupRoles.participant.name());
    Identity participant11 = JunitTestHelper.createAndPersistIdentityAsRndUser("Coaching-Part-11");
    repositoryService.addRole(participant11, re1, GroupRoles.participant.name());
    Identity participant2 = JunitTestHelper.createAndPersistIdentityAsRndUser("Coaching-Part-2");
    repositoryService.addRole(participant2, re2, GroupRoles.participant.name());
    Identity participant21 = JunitTestHelper.createAndPersistIdentityAsRndUser("Coaching-Part-21");
    repositoryService.addRole(participant21, re2, GroupRoles.participant.name());
    Identity participant3 = JunitTestHelper.createAndPersistIdentityAsRndUser("Coaching-Part-3");
    repositoryService.addRole(participant3, re3, GroupRoles.participant.name());
    Identity participant31 = JunitTestHelper.createAndPersistIdentityAsRndUser("Coaching-Part-31");
    repositoryService.addRole(participant31, re3, GroupRoles.participant.name());
    dbInstance.commitAndCloseSession();
    // members of group of re 1
    BusinessGroup group1 = businessGroupService.createBusinessGroup(groupCoach, "Coaching-grp-1", "tg", null, null, false, false, re1);
    Identity participantG1 = JunitTestHelper.createAndPersistIdentityAsRndUser("Coaching-Part-g1");
    businessGroupRelationDao.addRole(participantG1, group1, GroupRoles.participant.name());
    Identity participantG11 = JunitTestHelper.createAndPersistIdentityAsRndUser("Coaching-Part-g11");
    businessGroupRelationDao.addRole(participantG11, group1, GroupRoles.participant.name());
    dbInstance.commitAndCloseSession();
    // members of group of re 2
    BusinessGroup group2 = businessGroupService.createBusinessGroup(groupCoach, "Coaching-grp-2", "tg", null, null, false, false, re2);
    Identity participantG2 = JunitTestHelper.createAndPersistIdentityAsRndUser("Coaching-Part-g2");
    businessGroupRelationDao.addRole(participantG2, group2, GroupRoles.participant.name());
    Identity participantG21 = JunitTestHelper.createAndPersistIdentityAsRndUser("Coaching-Part-g22");
    businessGroupRelationDao.addRole(participantG21, group2, GroupRoles.participant.name());
    dbInstance.commitAndCloseSession();
    // members of group of re 3
    BusinessGroup group3 = businessGroupService.createBusinessGroup(groupCoach, "Coaching-grp-3", "tg", null, null, false, false, re3);
    Identity participantG3 = JunitTestHelper.createAndPersistIdentityAsRndUser("Coaching-Part-g3");
    businessGroupRelationDao.addRole(participantG3, group3, GroupRoles.participant.name());
    Identity participantG31 = JunitTestHelper.createAndPersistIdentityAsRndUser("Coaching-Part-g33");
    businessGroupRelationDao.addRole(participantG31, group3, GroupRoles.participant.name());
    dbInstance.commitAndCloseSession();
    // make statements participants
    effManager.createUserEfficiencyStatement(new Date(), 6.230429f, true, participant1, re1.getOlatResource());
    effManager.createUserEfficiencyStatement(new Date(), 4.182317f, false, participant11, re1.getOlatResource());
    effManager.createUserEfficiencyStatement(new Date(), 4.095833f, false, participantG1, re1.getOlatResource());
    effManager.createUserEfficiencyStatement(new Date(), 4.578924f, false, participantG11, re1.getOlatResource());
    effManager.createUserEfficiencyStatement(new Date(), 2.2894727f, true, participant2, re2.getOlatResource());
    effManager.createUserEfficiencyStatement(new Date(), null, null, participant21, re2.getOlatResource());
    effManager.createUserEfficiencyStatement(new Date(), 5.2347774f, true, participantG2, re2.getOlatResource());
    effManager.createUserEfficiencyStatement(new Date(), null, null, participantG21, re2.getOlatResource());
    effManager.createUserEfficiencyStatement(new Date(), 4.0f, true, participant3, re3.getOlatResource());
    effManager.createUserEfficiencyStatement(new Date(), 3.0f, false, participant31, re3.getOlatResource());
    effManager.createUserEfficiencyStatement(new Date(), 5.5f, true, participantG3, re3.getOlatResource());
    effManager.createUserEfficiencyStatement(new Date(), 1.0f, false, participantG31, re3.getOlatResource());
    dbInstance.commitAndCloseSession();
    // make user infos
    userCourseInformationsManager.updateUserCourseInformations(re1.getOlatResource(), participant1);
    userCourseInformationsManager.updateUserCourseInformations(re1.getOlatResource(), participant11);
    userCourseInformationsManager.updateUserCourseInformations(re1.getOlatResource(), participantG1);
    userCourseInformationsManager.updateUserCourseInformations(re1.getOlatResource(), participantG11);
    userCourseInformationsManager.updateUserCourseInformations(re2.getOlatResource(), participant2);
    userCourseInformationsManager.updateUserCourseInformations(re2.getOlatResource(), participant21);
    userCourseInformationsManager.updateUserCourseInformations(re2.getOlatResource(), participantG2);
    userCourseInformationsManager.updateUserCourseInformations(re2.getOlatResource(), participantG21);
    userCourseInformationsManager.updateUserCourseInformations(re3.getOlatResource(), participant3);
    userCourseInformationsManager.updateUserCourseInformations(re3.getOlatResource(), participant31);
    userCourseInformationsManager.updateUserCourseInformations(re3.getOlatResource(), participantG3);
    userCourseInformationsManager.updateUserCourseInformations(re3.getOlatResource(), participantG31);
    dbInstance.commitAndCloseSession();
    // course coach cannot see groups
    List<GroupStatEntry> courseCoachGroupStats = coachingDAO.getGroupsStatisticsNative(courseCoach);
    Assert.assertNotNull(courseCoachGroupStats);
    Assert.assertEquals(0, courseCoachGroupStats.size());
    List<GroupStatEntry> groupCoachGroupStats = coachingDAO.getGroupsStatisticsNative(groupCoach);
    Assert.assertNotNull(groupCoachGroupStats);
    Assert.assertEquals(1, groupCoachGroupStats.size());
    GroupStatEntry entryGroup3 = getGroupStatEntry(group3, groupCoachGroupStats);
    Assert.assertNotNull(entryGroup3);
    Assert.assertEquals(2, entryGroup3.getCountDistinctStudents());
    Assert.assertEquals(2, entryGroup3.getInitialLaunch());
    Assert.assertEquals(1, entryGroup3.getCountPassed());
    Assert.assertEquals(1, entryGroup3.getCountFailed());
    Assert.assertEquals(0, entryGroup3.getCountNotAttempted());
    Assert.assertEquals(3.25f, entryGroup3.getAverageScore(), 0.0001f);
    // course statistics
    List<CourseStatEntry> courseCoachCourseStats = coachingDAO.getCoursesStatisticsNative(courseCoach);
    Assert.assertNotNull(courseCoachCourseStats);
    Assert.assertEquals(1, courseCoachCourseStats.size());
    CourseStatEntry entryCourse3 = getCourseStatEntry(re3, courseCoachCourseStats);
    Assert.assertNotNull(entryCourse3);
    Assert.assertEquals(2, entryCourse3.getCountStudents());
    Assert.assertEquals(2, entryCourse3.getInitialLaunch());
    Assert.assertEquals(1, entryCourse3.getCountPassed());
    Assert.assertEquals(1, entryCourse3.getCountFailed());
    Assert.assertEquals(0, entryCourse3.getCountNotAttempted());
    Assert.assertEquals(3.5f, entryCourse3.getAverageScore(), 0.0001f);
    // group coach can see course 3
    List<CourseStatEntry> groupCoachCourseStats = coachingDAO.getCoursesStatisticsNative(groupCoach);
    Assert.assertNotNull(groupCoachCourseStats);
    Assert.assertEquals(1, groupCoachCourseStats.size());
    CourseStatEntry entryCourse3g = getCourseStatEntry(re3, groupCoachCourseStats);
    Assert.assertEquals(2, entryCourse3g.getCountStudents());
    Assert.assertEquals(2, entryCourse3g.getInitialLaunch());
    Assert.assertEquals(1, entryCourse3g.getCountPassed());
    Assert.assertEquals(1, entryCourse3g.getCountFailed());
    Assert.assertEquals(0, entryCourse3g.getCountNotAttempted());
    Assert.assertEquals(3.25f, entryCourse3g.getAverageScore(), 0.0001f);
    List<UserPropertyHandler> userPropertyHandlers = userManager.getUserPropertyHandlersFor(UserListController.usageIdentifyer, false);
    // user native
    List<StudentStatEntry> courseCoachUserStats = coachingDAO.getStudentsStatisticsNative(courseCoach, userPropertyHandlers);
    Assert.assertNotNull(courseCoachUserStats);
    Assert.assertEquals(2, courseCoachUserStats.size());
    // participant3 is only in re 1
    StudentStatEntry entryParticipant3 = getStudentStatEntry(participant3, courseCoachUserStats);
    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());
    // participant31 is only in re 1
    StudentStatEntry entryParticipant31 = getStudentStatEntry(participant31, courseCoachUserStats);
    Assert.assertNotNull(entryParticipant31);
    Assert.assertEquals(0, entryParticipant31.getCountPassed());
    Assert.assertEquals(1, entryParticipant31.getCountFailed());
    Assert.assertEquals(0, entryParticipant31.getCountNotAttempted());
    Assert.assertEquals(1, entryParticipant31.getInitialLaunch());
    Assert.assertEquals(1, entryParticipant31.getCountRepo());
    // group coach
    List<StudentStatEntry> groupCoachUserStats = coachingDAO.getStudentsStatisticsNative(groupCoach, userPropertyHandlers);
    Assert.assertNotNull(groupCoachUserStats);
    Assert.assertEquals(2, groupCoachUserStats.size());
    // participantG3 is in re 3 ( via group 3)
    StudentStatEntry entryParticipantG3 = getStudentStatEntry(participantG3, groupCoachUserStats);
    Assert.assertNotNull(entryParticipantG3);
    Assert.assertEquals(1, entryParticipantG3.getCountPassed());
    Assert.assertEquals(0, entryParticipantG3.getCountFailed());
    Assert.assertEquals(0, entryParticipantG3.getCountNotAttempted());
    Assert.assertEquals(1, entryParticipantG3.getInitialLaunch());
    Assert.assertEquals(1, entryParticipantG3.getCountRepo());
    // participantG3 is in re 3 ( via group 3)
    StudentStatEntry entryParticipantG31 = getStudentStatEntry(participantG31, groupCoachUserStats);
    Assert.assertNotNull(entryParticipantG31);
    Assert.assertEquals(0, entryParticipantG31.getCountPassed());
    Assert.assertEquals(1, entryParticipantG31.getCountFailed());
    Assert.assertEquals(0, entryParticipantG31.getCountNotAttempted());
    Assert.assertEquals(1, entryParticipantG31.getInitialLaunch());
    Assert.assertEquals(1, entryParticipantG31.getCountRepo());
}
Also used : BusinessGroup(org.olat.group.BusinessGroup) RepositoryEntry(org.olat.repository.RepositoryEntry) URL(java.net.URL) Date(java.util.Date) GroupStatEntry(org.olat.modules.coach.model.GroupStatEntry) StudentStatEntry(org.olat.modules.coach.model.StudentStatEntry) CourseStatEntry(org.olat.modules.coach.model.CourseStatEntry) Identity(org.olat.core.id.Identity) File(java.io.File) UserPropertyHandler(org.olat.user.propertyhandlers.UserPropertyHandler) CoachingLargeTest(org.olat.modules.coach.CoachingLargeTest) Test(org.junit.Test)

Example 35 with StudentStatEntry

use of org.olat.modules.coach.model.StudentStatEntry in project openolat by klemens.

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());
}
Also used : BusinessGroup(org.olat.group.BusinessGroup) RepositoryEntry(org.olat.repository.RepositoryEntry) URL(java.net.URL) Date(java.util.Date) GroupStatEntry(org.olat.modules.coach.model.GroupStatEntry) StudentStatEntry(org.olat.modules.coach.model.StudentStatEntry) CourseStatEntry(org.olat.modules.coach.model.CourseStatEntry) Identity(org.olat.core.id.Identity) File(java.io.File) UserPropertyHandler(org.olat.user.propertyhandlers.UserPropertyHandler) CoachingLargeTest(org.olat.modules.coach.CoachingLargeTest) Test(org.junit.Test)

Aggregations

StudentStatEntry (org.olat.modules.coach.model.StudentStatEntry)46 Test (org.junit.Test)16 File (java.io.File)14 URL (java.net.URL)14 Identity (org.olat.core.id.Identity)14 BusinessGroup (org.olat.group.BusinessGroup)14 CoachingLargeTest (org.olat.modules.coach.CoachingLargeTest)14 RepositoryEntry (org.olat.repository.RepositoryEntry)14 UserPropertyHandler (org.olat.user.propertyhandlers.UserPropertyHandler)14 CourseStatEntry (org.olat.modules.coach.model.CourseStatEntry)12 GroupStatEntry (org.olat.modules.coach.model.GroupStatEntry)12 Date (java.util.Date)10 HashMap (java.util.HashMap)10 NativeQueryBuilder (org.olat.core.commons.persistence.NativeQueryBuilder)10 Map (java.util.Map)4 Query (javax.persistence.Query)4 SelectionEvent (org.olat.core.gui.components.form.flexible.impl.elements.table.SelectionEvent)4 SearchCoachedIdentityParams (org.olat.modules.coach.model.SearchCoachedIdentityParams)4 ArrayList (java.util.ArrayList)2 FlexiTableSearchEvent (org.olat.core.gui.components.form.flexible.impl.elements.table.FlexiTableSearchEvent)2