Examples with BusinessGroupRow org.olat.group.model.BusinessGroupRow used on opensource projects

Example 56 with BusinessGroupRow

use of org.olat.group.model.BusinessGroupRow 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;
}

Example 57 with BusinessGroupRow

use of org.olat.group.model.BusinessGroupRow in project openolat by klemens.

the class AbstractBusinessGroupListController method getSelectedItems.

protected List<BusinessGroupRow> getSelectedItems() {
    Set<Integer> selections = tableEl.getMultiSelectedIndex();
    List<BusinessGroupRow> rows = new ArrayList<>(selections.size());
    for (Integer i : selections) {
        BusinessGroupRow row = groupTableModel.getObject(i.intValue());
        if (row != null) {
            rows.add(row);
        }
    }
    return rows;
}

Example 58 with BusinessGroupRow

use of org.olat.group.model.BusinessGroupRow in project openolat by klemens.

the class FavoritBusinessGroupListController method searchTableItems.

@Override
protected List<BGTableItem> searchTableItems(BusinessGroupQueryParams params) {
    List<BusinessGroupRow> rows = businessGroupService.findBusinessGroupsWithMemberships(params, getIdentity());
    List<BGTableItem> items = new ArrayList<>(rows.size());
    for (BusinessGroupRow row : rows) {
        BusinessGroupMembership membership = row.getMember();
        Boolean allowLeave = membership != null;
        Boolean allowDelete = isAdmin() ? Boolean.TRUE : (membership == null ? null : new Boolean(membership.isOwner()));
        FormLink markLink = uifactory.addFormLink("mark_" + row.getKey(), "mark", "", null, null, Link.NONTRANSLATED);
        markLink.setIconLeftCSS(row.isMarked() ? Mark.MARK_CSS_LARGE : Mark.MARK_ADD_CSS_LARGE);
        BGTableItem item = new BGTableItem(row, markLink, allowLeave, allowDelete);
        items.add(item);
    }
    return items;
}

Example 59 with BusinessGroupRow

use of org.olat.group.model.BusinessGroupRow in project openolat by klemens.

the class SearchBusinessGroupListController method searchTableItems.

@Override
protected List<BGTableItem> searchTableItems(BusinessGroupQueryParams params) {
    List<BusinessGroupRow> rows = businessGroupService.findBusinessGroupsWithMemberships(params, getIdentity());
    List<BGTableItem> items = new ArrayList<>(rows.size());
    for (BusinessGroupRow row : rows) {
        BusinessGroupMembership membership = row.getMember();
        Boolean allowLeave = membership != null;
        Boolean allowDelete = isAdmin() ? Boolean.TRUE : (membership == null ? null : new Boolean(membership.isOwner()));
        FormLink markLink = uifactory.addFormLink("mark_" + row.getKey(), "mark", "", null, null, Link.NONTRANSLATED);
        markLink.setIconLeftCSS(row.isMarked() ? Mark.MARK_CSS_LARGE : Mark.MARK_ADD_CSS_LARGE);
        BGTableItem item = new BGTableItem(row, markLink, allowLeave, allowDelete);
        items.add(item);
    }
    return items;
}

Example 60 with BusinessGroupRow

use of org.olat.group.model.BusinessGroupRow in project openolat by klemens.

the class BusinessGroupListController method searchTableItems.

@Override
protected List<BGTableItem> searchTableItems(BusinessGroupQueryParams params) {
    List<BusinessGroupRow> rows = businessGroupService.findBusinessGroupsWithMemberships(params, getIdentity());
    List<BGTableItem> items = new ArrayList<>(rows.size());
    for (BusinessGroupRow row : rows) {
        BusinessGroupMembership membership = row.getMember();
        Boolean allowLeave = membership != null;
        Boolean allowDelete = isAdmin() ? Boolean.TRUE : (membership == null ? null : new Boolean(membership.isOwner()));
        FormLink markLink = uifactory.addFormLink("mark_" + row.getKey(), "mark", "", null, null, Link.NONTRANSLATED);
        markLink.setIconLeftCSS(row.isMarked() ? Mark.MARK_CSS_LARGE : Mark.MARK_ADD_CSS_LARGE);
        BGTableItem item = new BGTableItem(row, markLink, allowLeave, allowDelete);
        items.add(item);
    }
    return items;
}