Source code for agency.views.organisation

from onegov.agency import _
from onegov.agency import AgencyApp
from onegov.agency.collections import ExtendedAgencyCollection
from onegov.agency.collections import ExtendedPersonCollection
from onegov.agency.layout import DefaultLayout
from onegov.agency.models import ExtendedAgency
from onegov.agency.models import ExtendedPerson
from onegov.core.security import Private
from onegov.org.elements import Link
from onegov.org.models import Organisation
from onegov.people import AgencyMembership
from onegov.people import AgencyMembershipCollection
from sqlalchemy import or_


from typing import TYPE_CHECKING
if TYPE_CHECKING:
    from onegov.agency.request import AgencyRequest
    from onegov.core.types import RenderData


@AgencyApp.html(
    model=Organisation,
    name='view-hidden',
    template='hidden.pt',
    permission=Private
)


def view_hidden_agencies(
    self: Organisation,
    request: 'AgencyRequest'
) -> 'RenderData':

    session = request.session

    agencies = ExtendedAgencyCollection(session).query()
    agencies = agencies.filter(
        or_(
            ExtendedAgency.meta['access'] != 'public',
            ExtendedAgency.published.is_(False)
        )
    )
    agencies = agencies.order_by(None).order_by(ExtendedAgency.title)

    memberships = AgencyMembershipCollection(session).query(
        order_by='order_within_agency'
    )
    memberships = memberships.filter(
        or_(
            AgencyMembership.meta['access'] != 'public',
            AgencyMembership.published.is_(False)
        )
    )
    memberships = memberships.order_by(None).order_by(AgencyMembership.title)

    people = ExtendedPersonCollection(session).query()
    people = people.filter(
        or_(
            ExtendedPerson.meta['access'] != 'public',
            ExtendedPerson.published.is_(False)
        )
    )
    people = people.order_by(None).order_by(
        ExtendedPerson.last_name,
        ExtendedPerson.first_name
    )

    layout = DefaultLayout(self, request)
    assert isinstance(layout.breadcrumbs, list)
    layout.breadcrumbs.append(Link(_('Hidden contents'), '#'))

    return {
        'title': _('Hidden contents'),
        'agencies': agencies.all(),
        'memberships': memberships.all(),
        'people': people.all(),
        'layout': layout
    }