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

Example 1 with GroupStatEntry

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

the class CoachingLargeTest method getGroupsStatistics.

@Test
public void getGroupsStatistics() {
    List<GroupStatEntry> groupStatEntries = coachingService.getGroupsStatistics(coach10);
    Assert.assertNotNull(groupStatEntries);
    List<Long> coachedGroups = coachToGroupCourseMap.get(coach10.getKey());
    Assert.assertNotNull(coachedGroups);
    Assert.assertEquals(coachedGroups.size(), groupStatEntries.size());
    List<Long> groupStatsKeys = new ArrayList<>();
    for (GroupStatEntry statEntry : groupStatEntries) {
        groupStatsKeys.add(statEntry.getGroupKey());
    }
    Assert.assertTrue(groupStatsKeys.containsAll(coachedGroups));
    Assert.assertTrue(coachedGroups.containsAll(groupStatsKeys));
}

Example 2 with GroupStatEntry

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

the class GroupListController 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())) {
                GroupStatEntry groupStatistic = (GroupStatEntry) tableCtr.getTableDataModel().getObject(e.getRowId());
                selectGroup(ureq, groupStatistic);
            }
        }
    } else if (source == groupCtrl) {
        if (event == Event.CHANGED_EVENT) {
            hasChanged = true;
        } else if ("next.group".equals(event.getCommand())) {
            nextGroup(ureq);
        } else if ("previous.group".equals(event.getCommand())) {
            previousGroup(ureq);
        }
    }
    super.event(ureq, source, event);
}

Example 3 with GroupStatEntry

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

the class CoachingDAO method getGroupsStatisticsStatementForOwner.

private boolean getGroupsStatisticsStatementForOwner(Identity coach, Map<Long, GroupStatEntry> map) {
    NativeQueryBuilder sb = new NativeQueryBuilder(1024, dbInstance);
    sb.append("select").append(" fin_statement.bgp_id,").append(" fin_statement.re_id,").append(" sum(case when fin_statement.passed=").appendTrue().append(" then 1 else 0 end) as num_of_passed,").append(" sum(case when fin_statement.passed=").appendFalse().append(" then 1 else 0 end) as num_of_failed,").append(" sum(fin_statement.score) as avg_score ").append("from ( select ").append("  distinct sg_statement.id as id,").append("  togroup.fk_group_id as bgp_id,").append("  togroup.fk_entry_id as re_id,").append("  sg_statement.passed as passed,").append("  sg_statement.score as score ").append(" from o_repositoryentry sg_re ").append(" inner join o_re_to_group owngroup on (owngroup.r_defgroup=").appendTrue().append(" and 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 and sg_owner.g_role = 'owner') ").append(" inner join o_re_to_group togroup on (togroup.r_defgroup=").appendFalse().append(" and 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_as_eff_statement sg_statement on (sg_statement.fk_identity = sg_participant.fk_identity_id and sg_statement.fk_resource_id = sg_re.fk_olatresource) ").append(" where sg_owner.fk_identity_id=:coachKey and sg_re.accesscode >= ").append(RepositoryEntry.ACC_OWNERS).append(") ").appendAs().append(" fin_statement ").append("group by fin_statement.bgp_id, fin_statement.re_id ");
    List<?> rawList = dbInstance.getCurrentEntityManager().createNativeQuery(sb.toString()).setParameter("coachKey", coach.getKey()).getResultList();
    for (Object rawObject : rawList) {
        Object[] rawStats = (Object[]) rawObject;
        Long baseGroupKey = ((Number) rawStats[0]).longValue();
        Long repoKey = ((Number) rawStats[1]).longValue();
        GroupStatEntry entry = map.get(baseGroupKey);
        if (entry != null && !entry.getRepoIds().contains(repoKey)) {
            int passed = ((Number) rawStats[2]).intValue();
            int failed = ((Number) rawStats[3]).intValue();
            entry.setCountFailed(failed + entry.getCountFailed());
            entry.setCountPassed(passed + entry.getCountPassed());
            if (rawStats[4] != null) {
                entry.setSumScore(entry.getSumScore() + ((Number) rawStats[4]).floatValue());
            }
            entry.getRepoIds().add(repoKey);
        }
    }
    return rawList.size() > 0;
}

Example 4 with GroupStatEntry

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

the class CoachingDAO method getGroupsStatisticsInfosForCoach.

private boolean getGroupsStatisticsInfosForCoach(Identity coach, Map<Long, GroupStatEntry> map) {
    NativeQueryBuilder sb = new NativeQueryBuilder(1024, dbInstance);
    sb.append("select ").append("  togroup.fk_group_id as basegr_id, ").append("  togroup.fk_entry_id as re_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.r_defgroup=").appendFalse().append(" and 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 togroup.fk_group_id, togroup.fk_entry_id ");
    List<?> rawList = dbInstance.getCurrentEntityManager().createNativeQuery(sb.toString()).setParameter("coachKey", coach.getKey()).getResultList();
    for (Object rawObject : rawList) {
        Object[] rawStats = (Object[]) rawObject;
        Long baseGroupKey = ((Number) rawStats[0]).longValue();
        GroupStatEntry entry = map.get(baseGroupKey);
        if (entry != null) {
            Long repoKey = ((Number) rawStats[1]).longValue();
            if (!entry.getRepoIds().contains(repoKey)) {
                int initalLaunch = ((Number) rawStats[2]).intValue();
                entry.setInitialLaunch(initalLaunch + entry.getInitialLaunch());
                entry.setCountCourses(entry.getCountCourses() + 1);
                entry.getRepoIds().add(repoKey);
            }
        }
    }
    return rawList.size() > 0;
}

Example 5 with GroupStatEntry

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

the class CoachingDAO method getGroupsStatisticsInfosForOwner.

private boolean getGroupsStatisticsInfosForOwner(Identity coach, Map<Long, GroupStatEntry> map) {
    NativeQueryBuilder sb = new NativeQueryBuilder(1024, dbInstance);
    sb.append("select ").append("  togroup.fk_group_id as basegr_id, ").append("  togroup.fk_entry_id as re_id, ").append("  count(distinct pg_initial_launch.id) as pg_id ").append(" from o_repositoryentry sg_re  ").append(" inner join o_re_to_group owngroup on (owngroup.r_defgroup=").appendTrue().append(" and 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 and sg_owner.g_role = 'owner') ").append(" inner join o_re_to_group togroup on (togroup.r_defgroup=").appendFalse().append(" and 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(" 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_owner.fk_identity_id=:coachKey and sg_re.accesscode >= ").append(RepositoryEntry.ACC_OWNERS).append(" group by togroup.fk_group_id, togroup.fk_entry_id ");
    List<?> rawList = dbInstance.getCurrentEntityManager().createNativeQuery(sb.toString()).setParameter("coachKey", coach.getKey()).getResultList();
    for (Object rawObject : rawList) {
        Object[] rawStats = (Object[]) rawObject;
        Long baseGroupKey = ((Number) rawStats[0]).longValue();
        GroupStatEntry entry = map.get(baseGroupKey);
        if (entry != null) {
            Long repoKey = ((Number) rawStats[1]).longValue();
            if (!entry.getRepoIds().contains(repoKey)) {
                int initalLaunch = ((Number) rawStats[2]).intValue();
                entry.setInitialLaunch(initalLaunch + entry.getInitialLaunch());
                entry.setCountCourses(entry.getCountCourses() + 1);
                entry.getRepoIds().add(repoKey);
            }
        }
    }
    return rawList.size() > 0;
}