registrasion/reporting/views.py
def speaker_registrations(request, form):
    ''' Shows registration status for speakers with a given proposal kind. '''

    kinds = form.cleaned_data["kind"]

    presentations = schedule_models.Presentation.objects.filter(
        proposal_base__kind__in=kinds,
    ).exclude(
        cancelled=True,
    )

    users = User.objects.filter(
        Q(speaker_profile__presentations__in=presentations) |
        Q(speaker_profile__copresentations__in=presentations)
    )

    paid_carts = commerce.Cart.objects.filter(status=commerce.Cart.STATUS_PAID)

    paid_carts = Case(
        When(cart__in=paid_carts, then=Value(1)),
        default=Value(0),
        output_field=models.IntegerField(),
    )
    users = users.annotate(paid_carts=Sum(paid_carts))
    users = users.order_by("paid_carts")

    return QuerysetReport(
        "Speaker Registration Status",
        ["id", "speaker_profile__name", "email", "paid_carts"],
        users,
        link_view=attendee,
    )

    return []
def speaker_registrations(request, form):
    ''' Shows registration status for speakers with a given proposal kind. '''

    kinds = form.cleaned_data["kind"]

    presentations = schedule_models.Presentation.objects.filter(
        proposal_base__kind__in=kinds,
    ).exclude(
        cancelled=True,
    )

    users = User.objects.filter(
        Q(speaker_profile__presentations__in=presentations) |
        Q(speaker_profile__copresentations__in=presentations)
    )

    paid_carts = commerce.Cart.objects.filter(status=commerce.Cart.STATUS_PAID)

    paid_carts = Case(
        When(cart__in=paid_carts, then=Value(1)),
        default=Value(0),
        output_field=models.IntegerField(),
    )
    users = users.annotate(paid_carts=Sum(paid_carts))
    users = users.order_by("paid_carts")

    return QuerysetReport(
        "Speaker Registration Status",
        ["id", "speaker_profile__name", "email", "paid_carts"],
        users,
        link_view=attendee,
    )

    return []
def speaker_registrations ( request , form ) : kinds = form . cleaned_data [ "kind" ] presentations = schedule_models . Presentation . objects . filter ( proposal_base__kind__in = kinds , ) . exclude ( cancelled = True , ) users = User . objects . filter ( Q ( speaker_profile__presentations__in = presentations ) | Q ( speaker_profile__copresentations__in = presentations ) ) paid_carts = commerce . Cart . objects . filter ( status = commerce . Cart . STATUS_PAID ) paid_carts = Case ( When ( cart__in = paid_carts , then = Value ( 1 ) ) , default = Value ( 0 ) , output_field = models . IntegerField ( ) , ) users = users . annotate ( paid_carts = Sum ( paid_carts ) ) users = users . order_by ( "paid_carts" ) return QuerysetReport ( "Speaker Registration Status" , [ "id" , "speaker_profile__name" , "email" , "paid_carts" ] , users , link_view = attendee , ) return [ ]
Shows registration status for speakers with a given proposal kind.
Shows registration status for speakers with a given proposal kind .