use of org.olat.group.model.BusinessGroupToSearch in project OpenOLAT by OpenOLAT.
the class BusinessGroupDAO method searchPublishedBusinessGroups.
/**
* @return
*/
public List<OpenBusinessGroupRow> searchPublishedBusinessGroups(BusinessGroupQueryParams params, IdentityRef identity) {
// need resources, access type, membership, num of pending, num of participants
StringBuilder sb = new StringBuilder();
sb.append("select bgi, ").append(" (select count(nParticipants.key) from bgroupmember as nParticipants ").append(" where nParticipants.group.key=bgi.baseGroup and nParticipants.role='").append(GroupRoles.participant.name()).append("'").append(" ) as numOfParticipants,").append(" (select count(reservation.key) from resourcereservation as reservation ").append(" where reservation.resource.key=bgi.resource.key").append(" ) as numOfReservations").append(" from businessgrouptosearch as bgi ").append(" inner join fetch bgi.resource as bgResource ").append(" inner join fetch bgi.baseGroup as bGroup ");
filterBusinessGroupToSearch(sb, params, false);
TypedQuery<Object[]> queryObjects = dbInstance.getCurrentEntityManager().createQuery(sb.toString(), Object[].class);
filterBusinessGroupToSearchParameters(queryObjects, params, identity, false);
List<Object[]> objects = queryObjects.getResultList();
List<OpenBusinessGroupRow> groups = new ArrayList<>(objects.size());
Map<Long, OpenBusinessGroupRow> keyToGroup = new HashMap<>();
Map<Long, OpenBusinessGroupRow> resourceKeyToGroup = new HashMap<>();
for (Object[] object : objects) {
BusinessGroupToSearch businessGroup = (BusinessGroupToSearch) object[0];
if (!keyToGroup.containsKey(businessGroup.getKey())) {
Long numOfParticipants = (Long) object[1];
Long numOfReservations = (Long) object[2];
OpenBusinessGroupRow row = new OpenBusinessGroupRow(businessGroup, numOfParticipants, numOfReservations);
groups.add(row);
keyToGroup.put(businessGroup.getKey(), row);
resourceKeyToGroup.put(businessGroup.getResource().getKey(), row);
}
}
loadRelations(keyToGroup, params, identity);
loadOfferAccess(resourceKeyToGroup);
loadMemberships(identity, keyToGroup);
return groups;
}
use of org.olat.group.model.BusinessGroupToSearch in project OpenOLAT by OpenOLAT.
the class BusinessGroupDAO method searchBusinessGroupsStatistics.
public List<StatisticsBusinessGroupRow> searchBusinessGroupsStatistics(BusinessGroupQueryParams params) {
StringBuilder sb = new StringBuilder();
sb.append("select bgi, ").append(" (select count(nCoaches.key) from bgroupmember as nCoaches ").append(" where nCoaches.group.key=bgi.baseGroup.key and nCoaches.role='").append(GroupRoles.coach.name()).append("'").append(" ) as numOfCoaches,").append(" (select count(nParticipants.key) from bgroupmember as nParticipants ").append(" where nParticipants.group.key=bgi.baseGroup.key and nParticipants.role='").append(GroupRoles.participant.name()).append("'").append(" ) as numOfParticipants,").append(" (select count(nWaiting.key) from bgroupmember as nWaiting ").append(" where bgi.waitingListEnabled=true and nWaiting.group.key=bgi.baseGroup.key and nWaiting.role='").append(GroupRoles.waiting.name()).append("'").append(" ) as numWaiting,").append(" (select count(reservation.key) from resourcereservation as reservation ").append(" where reservation.resource.key=bgi.resource.key").append(" ) as numOfReservations").append(" from businessgrouptosearch as bgi").append(" inner join fetch bgi.resource as bgResource ").append(" inner join bgi.baseGroup as bGroup ");
filterBusinessGroupToSearch(sb, params, false);
sb.append(" order by bgi.name");
TypedQuery<Object[]> objectsQuery = dbInstance.getCurrentEntityManager().createQuery(sb.toString(), Object[].class);
filterBusinessGroupToSearchParameters(objectsQuery, params, null, false);
List<Object[]> objects = objectsQuery.getResultList();
List<StatisticsBusinessGroupRow> groups = new ArrayList<>(objects.size());
for (Object[] object : objects) {
BusinessGroupToSearch businessGroup = (BusinessGroupToSearch) object[0];
Number numOfCoaches = (Number) object[1];
Number numOfParticipants = (Number) object[2];
Number numWaiting = (Number) object[3];
Number numPending = (Number) object[4];
StatisticsBusinessGroupRow row = new StatisticsBusinessGroupRow(businessGroup, numOfCoaches, numOfParticipants, numWaiting, numPending);
groups.add(row);
}
return groups;
}
use of org.olat.group.model.BusinessGroupToSearch in project OpenOLAT by OpenOLAT.
the class BusinessGroupDAO method searchBusinessGroupsForSelection.
public List<StatisticsBusinessGroupRow> searchBusinessGroupsForSelection(BusinessGroupQueryParams params, IdentityRef identity) {
StringBuilder sb = new StringBuilder();
sb.append("select bgi, ").append(" (select count(nCoaches.key) from bgroupmember as nCoaches ").append(" where nCoaches.group.key=bgi.baseGroup.key and nCoaches.role='").append(GroupRoles.coach.name()).append("'").append(" ) as numOfCoaches,").append(" (select count(nParticipants.key) from bgroupmember as nParticipants ").append(" where nParticipants.group.key=bgi.baseGroup.key and nParticipants.role='").append(GroupRoles.participant.name()).append("'").append(" ) as numOfParticipants,").append(" (select count(nWaiting.key) from bgroupmember as nWaiting ").append(" where bgi.waitingListEnabled=true and nWaiting.group.key=bgi.baseGroup.key and nWaiting.role='").append(GroupRoles.waiting.name()).append("'").append(" ) as numWaiting,").append(" (select count(reservation.key) from resourcereservation as reservation ").append(" where reservation.resource.key=bgi.resource.key").append(" ) as numOfReservations,").append(" (select count(mark.key) from ").append(MarkImpl.class.getName()).append(" as mark ").append(" where mark.creator.key=:identityKey and mark.resId=bgi.key and mark.resName='BusinessGroup'").append(" ) as marks").append(" from businessgrouptosearch as bgi").append(" inner join fetch bgi.resource as bgResource ").append(" inner join bgi.baseGroup as bGroup ");
filterBusinessGroupToSearch(sb, params, false);
TypedQuery<Object[]> objectsQuery = dbInstance.getCurrentEntityManager().createQuery(sb.toString(), Object[].class);
filterBusinessGroupToSearchParameters(objectsQuery, params, identity, true);
List<Object[]> objects = objectsQuery.getResultList();
List<StatisticsBusinessGroupRow> groups = new ArrayList<>(objects.size());
Map<Long, BusinessGroupRow> keyToGroup = new HashMap<>();
for (Object[] object : objects) {
BusinessGroupToSearch businessGroup = (BusinessGroupToSearch) object[0];
Number numOfCoaches = (Number) object[1];
Number numOfParticipants = (Number) object[2];
Number numWaiting = (Number) object[3];
Number numPending = (Number) object[4];
Number marked = (Number) object[5];
StatisticsBusinessGroupRow row = new StatisticsBusinessGroupRow(businessGroup, numOfCoaches, numOfParticipants, numWaiting, numPending);
groups.add(row);
row.setMarked(marked == null ? false : marked.longValue() > 0);
keyToGroup.put(businessGroup.getKey(), row);
}
loadRelations(keyToGroup, params, identity);
return groups;
}
use of org.olat.group.model.BusinessGroupToSearch in project openolat by klemens.
the class BusinessGroupDAO method searchBusinessGroupsStatistics.
public List<StatisticsBusinessGroupRow> searchBusinessGroupsStatistics(BusinessGroupQueryParams params) {
StringBuilder sb = new StringBuilder();
sb.append("select bgi, ").append(" (select count(nCoaches.key) from bgroupmember as nCoaches ").append(" where nCoaches.group.key=bgi.baseGroup.key and nCoaches.role='").append(GroupRoles.coach.name()).append("'").append(" ) as numOfCoaches,").append(" (select count(nParticipants.key) from bgroupmember as nParticipants ").append(" where nParticipants.group.key=bgi.baseGroup.key and nParticipants.role='").append(GroupRoles.participant.name()).append("'").append(" ) as numOfParticipants,").append(" (select count(nWaiting.key) from bgroupmember as nWaiting ").append(" where bgi.waitingListEnabled=true and nWaiting.group.key=bgi.baseGroup.key and nWaiting.role='").append(GroupRoles.waiting.name()).append("'").append(" ) as numWaiting,").append(" (select count(reservation.key) from resourcereservation as reservation ").append(" where reservation.resource.key=bgi.resource.key").append(" ) as numOfReservations").append(" from businessgrouptosearch as bgi").append(" inner join fetch bgi.resource as bgResource ").append(" inner join bgi.baseGroup as bGroup ");
filterBusinessGroupToSearch(sb, params, false);
sb.append(" order by bgi.name");
TypedQuery<Object[]> objectsQuery = dbInstance.getCurrentEntityManager().createQuery(sb.toString(), Object[].class);
filterBusinessGroupToSearchParameters(objectsQuery, params, null, false);
List<Object[]> objects = objectsQuery.getResultList();
List<StatisticsBusinessGroupRow> groups = new ArrayList<>(objects.size());
for (Object[] object : objects) {
BusinessGroupToSearch businessGroup = (BusinessGroupToSearch) object[0];
Number numOfCoaches = (Number) object[1];
Number numOfParticipants = (Number) object[2];
Number numWaiting = (Number) object[3];
Number numPending = (Number) object[4];
StatisticsBusinessGroupRow row = new StatisticsBusinessGroupRow(businessGroup, numOfCoaches, numOfParticipants, numWaiting, numPending);
groups.add(row);
}
return groups;
}
use of org.olat.group.model.BusinessGroupToSearch in project openolat by klemens.
the class BusinessGroupDAO method searchBusinessGroupsForRepositoryEntry.
/**
* @param entry
* @return
*/
public List<StatisticsBusinessGroupRow> searchBusinessGroupsForRepositoryEntry(BusinessGroupQueryParams params, IdentityRef identity, RepositoryEntryRef entry) {
// name, externalId, description, resources, tutors, participants, free places, waiting, access
StringBuilder sb = new StringBuilder();
sb.append("select bgi, ").append(" (select count(nCoaches.key) from bgroupmember as nCoaches ").append(" where nCoaches.group.key=bgi.baseGroup.key and nCoaches.role='").append(GroupRoles.coach.name()).append("'").append(" ) as numOfCoaches,").append(" (select count(nParticipants.key) from bgroupmember as nParticipants ").append(" where nParticipants.group.key=bgi.baseGroup.key and nParticipants.role='").append(GroupRoles.participant.name()).append("'").append(" ) as numOfParticipants,").append(" (select count(nWaiting.key) from bgroupmember as nWaiting ").append(" where nWaiting.group.key=bgi.baseGroup.key and nWaiting.role='").append(GroupRoles.waiting.name()).append("'").append(" ) as numWaiting,").append(" (select count(reservation.key) from resourcereservation as reservation ").append(" where reservation.resource.key=bgi.resource.key").append(" ) as numOfReservations").append(" from businessgrouptosearch as bgi").append(" inner join fetch bgi.resource as bgResource ").append(" inner join bgi.baseGroup as bGroup ");
if (params.getRepositoryEntry() == null) {
// make sur the restricition is applied
params.setRepositoryEntry(entry);
}
filterBusinessGroupToSearch(sb, params, false);
TypedQuery<Object[]> objectsQuery = dbInstance.getCurrentEntityManager().createQuery(sb.toString(), Object[].class);
filterBusinessGroupToSearchParameters(objectsQuery, params, identity, false);
List<Object[]> objects = objectsQuery.getResultList();
List<StatisticsBusinessGroupRow> groups = new ArrayList<>(objects.size());
Map<Long, BusinessGroupRow> keyToGroup = new HashMap<>();
Map<Long, BusinessGroupRow> resourceKeyToGroup = new HashMap<>();
for (Object[] object : objects) {
BusinessGroupToSearch businessGroup = (BusinessGroupToSearch) object[0];
Number numOfCoaches = (Number) object[1];
Number numOfParticipants = (Number) object[2];
Number numWaiting = (Number) object[3];
Number numPending = (Number) object[4];
StatisticsBusinessGroupRow row = new StatisticsBusinessGroupRow(businessGroup, numOfCoaches, numOfParticipants, numWaiting, numPending);
groups.add(row);
keyToGroup.put(businessGroup.getKey(), row);
resourceKeyToGroup.put(businessGroup.getResource().getKey(), row);
}
loadOfferAccess(resourceKeyToGroup);
loadRelations(keyToGroup, params, identity);
return groups;
}
Aggregations