use of org.olat.modules.coach.model.GroupStatEntry in project OpenOLAT by OpenOLAT.
the class CoachingDAO method getGroupsStatisticsStatementForCoach.
private boolean getGroupsStatisticsStatementForCoach(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 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(" 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_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(") ").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;
}
use of org.olat.modules.coach.model.GroupStatEntry in project OpenOLAT by OpenOLAT.
the class GroupsTableDataModel method getValueAt.
@Override
public Object getValueAt(int row, int col) {
GroupStatEntry g = groups.get(row);
int numOfStudents = g.getCountStudents();
switch(Columns.getValueAt(col)) {
case name:
{
return g.getGroupName();
}
case countCourses:
{
return new Integer(g.getCountCourses());
}
case countStudents:
{
return new Integer(numOfStudents);
}
case initialLaunch:
{
int count = g.getCountCourses() * g.getCountStudents();
if (count == 0) {
return new LightedValue(null, Light.grey);
}
int launch = g.getInitialLaunch();
Light light = Light.yellow;
if (launch == count) {
light = Light.green;
} else if (launch == 0) {
light = Light.red;
}
return new LightedValue(launch, light);
}
case countPassed:
{
if (numOfStudents == 0) {
return numOfStudents;
}
ProgressValue val = new ProgressValue();
val.setTotal(numOfStudents);
val.setGreen(g.getCountPassed());
return val;
}
case countPassedLight:
{
if (numOfStudents == 0) {
return new LightedValue(null, Light.grey);
}
int passed = g.getCountPassed();
Light light = Light.yellow;
if (passed == numOfStudents) {
light = Light.green;
} else if (passed == 0) {
light = Light.red;
}
return new LightedValue(passed, light);
}
case averageScore:
return g.getAverageScore();
case statistics:
{
return g;
}
}
return null;
}
use of org.olat.modules.coach.model.GroupStatEntry 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());
}
use of org.olat.modules.coach.model.GroupStatEntry in project OpenOLAT by OpenOLAT.
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());
}
}
use of org.olat.modules.coach.model.GroupStatEntry in project openolat by klemens.
the class CoachingDAOTest method getStatistics_empty.
/**
* 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_empty() 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());
// groups
BusinessGroup group = businessGroupService.createBusinessGroup(null, "Coaching-grp-1", "tg", null, null, false, false, re1);
dbInstance.commitAndCloseSession();
Assert.assertNotNull(group);
// groups (method doesn't return courses without participant)
List<GroupStatEntry> nativeGroupStats = coachingDAO.getGroupsStatisticsNative(coach);
Assert.assertNotNull(nativeGroupStats);
Assert.assertEquals(0, nativeGroupStats.size());
// courses (method doesn't return courses without participant)
List<CourseStatEntry> nativeCourseStats = coachingDAO.getCoursesStatisticsNative(coach);
Assert.assertNotNull(nativeCourseStats);
Assert.assertEquals(0, nativeCourseStats.size());
List<UserPropertyHandler> userPropertyHandlers = userManager.getUserPropertyHandlersFor(UserListController.usageIdentifyer, false);
// user native
List<StudentStatEntry> nativeUserStats = coachingDAO.getStudentsStatisticsNative(coach, userPropertyHandlers);
Assert.assertNotNull(nativeUserStats);
Assert.assertEquals(0, nativeUserStats.size());
}
Aggregations