Example #1
0
def representatives(request, filter=None, action=None):

    if action:
        if action == "mailout":
            if request.method == "POST":
                representative_ids = logic.get_action_ids(request)
                representatives = [get_object_or_404(User, pk=rid) for rid in representative_ids]
                return redirect(mailer.logic.new(representatives, request.user))

    representatives = User.objects\
        .select_related('baseprofile', 'baseprofile__representativeprofile__organisation__name')\
        .filter(baseprofile__representativeprofile__isnull=False)\
        .order_by('first_name')

    export_filename = "representatives-export.xls"

    if ("mailer_new" in request.GET):
        return redirect(mailer.logic.new(representatives, request.user))

    if 'export' in request.REQUEST:
        if request.REQUEST['export'] == 'xls':
            return xls.XlsResponse([
                xls.Column("First name", lambda x: x.first_name),
                xls.Column("Last name", lambda x: x.last_name),
                xls.Column("Email", lambda x: x.email),
                xls.Column("Organisation", lambda x: x.baseprofile.representativeprofile.organisation.name),
                ], representatives, export_filename)

    return render_to_response("profiles/representatives.html", {
        'representatives': representatives,
        'filter': filter,
        'action': action,
        }, context_instance=RequestContext(request))
Example #2
0
File: views.py Project: somair/xvs
def representatives(request, filter=None, action=None):

    if action:
        if action == "mailout":
            if request.method == "POST":
                representative_ids = logic.get_action_ids(request)
                representatives = [
                    get_object_or_404(User, pk=rid)
                    for rid in representative_ids
                ]
                return redirect(mailer.logic.new(representatives,
                                                 request.user))

    representatives = User.objects\
        .select_related('baseprofile', 'baseprofile__representativeprofile__organisation__name')\
        .filter(baseprofile__representativeprofile__isnull=False)\
        .order_by('first_name')

    export_filename = "representatives-export.xls"

    if ("mailer_new" in request.GET):
        return redirect(mailer.logic.new(representatives, request.user))

    if 'export' in request.REQUEST:
        if request.REQUEST['export'] == 'xls':
            return xls.XlsResponse([
                xls.Column("First name", lambda x: x.first_name),
                xls.Column("Last name", lambda x: x.last_name),
                xls.Column("Email", lambda x: x.email),
                xls.Column(
                    "Organisation", lambda x: x.baseprofile.
                    representativeprofile.organisation.name),
            ], representatives, export_filename)

    return render_to_response("profiles/representatives.html", {
        'representatives': representatives,
        'filter': filter,
        'action': action,
    },
                              context_instance=RequestContext(request))
Example #3
0
File: views.py Project: somair/xvs
def volunteers(request,
               position_id=None,
               filter=None,
               action=None,
               organisation_id=''):

    if not request.user.is_staff:
        organisation_id = request.user.get_profile(
        ).representativeprofile.organisation.id

    position = None

    if action:
        if action == "recommend":
            position = get_object_or_404(Position, pk=position_id)
            if request.method == "POST":
                volunteer_ids = logic.get_action_ids(request)
                volunteers = [
                    get_object_or_404(User, pk=vid) for vid in volunteer_ids
                ]
                positions.logic.recommend_position(request, position,
                                                   volunteers)
        if action == "mailout":
            if request.method == "POST":
                volunteer_ids = logic.get_action_ids(request)
                volunteers = [
                    get_object_or_404(User, pk=vid) for vid in volunteer_ids
                ]
                return redirect(
                    mailer.logic.new(volunteers, request.user,
                                     organisation_id))

    type_filter_form = VolunteerTypeFilterForm(request.GET)
    type_filter_form.is_valid()
    grad_filter = type_filter_form.cleaned_data['postgrad']
    international_filter = type_filter_form.cleaned_data['international']
    course_filter = type_filter_form.cleaned_data['course']
    category_filter = type_filter_form.cleaned_data['category']
    faculty_filter = type_filter_form.cleaned_data['faculty']
    hours_filter = type_filter_form.cleaned_data['hours']
    year_filter = type_filter_form.cleaned_data['year']

    column_filter_form = ColumnFilterForm(request.GET)
    column_filter_form.is_valid()
    columns = column_filter_form.cleaned_data['columns']

    if grad_filter == []:
        grad_filter = all_of(GRAD_CHOICES)
    if international_filter == []:
        international_filter = all_of(INTERNATIONAL_CHOICES)
    if columns == []:
        columns = VOLUNTEER_COLUMN_CHOICES_DEFAULT

    type_filter_form.data = {
        'postgrad': grad_filter,
        'international': international_filter,
        'course': course_filter,
        'faculty': faculty_filter,
        'category': category_filter,
        'hours': hours_filter,
        'year': year_filter,
    }

    column_filter_form.data = {
        'columns': columns,
    }

    # The __in operator doesn't work for NULL. Instead, __isnull must be used.
    grad_filter_exp = Q(
        baseprofile__volunteerprofile__postgrad__in=booleanise(grad_filter))
    if 'None' in grad_filter:
        grad_filter_exp |= Q(
            baseprofile__volunteerprofile__postgrad__isnull=True)

    # In the special case that all ineternational choices are chosen, we also select records
    # for students who don't have an international status.
    if set(international_filter) == set(all_of(INTERNATIONAL_CHOICES)):
        international_filter.append("")
    international_filter_exp = Q(
        baseprofile__volunteerprofile__international__in=international_filter)

    ### BASE QUERY ###

    volunteers = User.objects\
        .filter(baseprofile__is_volunteer=True, baseprofile__archived=(filter == 'deactivated'))\
        .filter(international_filter_exp)\
        .filter(grad_filter_exp)\
        .order_by('first_name')

    ### ORGANISATION FILTER ###
    organisation = None
    if organisation_id:
        volunteers = volunteers.filter(
            commitment__organisation__id=organisation_id)
        organisation = Organisation.objects.get(pk=organisation_id)

    ### ADD FILTERS ###

    if course_filter:
        volunteers = volunteers.filter(
            baseprofile__volunteerprofile__course__icontains=course_filter)

    if year_filter and year_filter != "ALL":
        volunteers = volunteers.filter(
            baseprofile__volunteerprofile__year__exact=int(year_filter))

    if faculty_filter:
        volunteers = volunteers.filter(
            baseprofile__volunteerprofile__school=faculty_filter.name)

    if category_filter:
        volunteers = volunteers.filter(
            baseprofile__volunteerprofile__categories=category_filter)

    if hours_filter == "HAS_HOURS":
        volunteers = volunteers.filter(timerecord__isnull=False)

    if hours_filter == "NO_HOURS":
        volunteers = volunteers.filter(timerecord__isnull=True)

    ### ADD FOREIGN COLUMNS ###

    if 'year' in columns:
        volunteers = volunteers.select_related(
            'baseprofile__volunteerprofile__year')

    if 'course' in columns:
        volunteers = volunteers.select_related(
            'baseprofile__volunteerprofile__course')

    ### ADD COMPLEX COLUMNS ###

    if 'offers' in columns:
        volunteers = volunteers.annotate(Count('offers_made'))

    if 'last_accepted' in columns or filter == 'uncommitted':
        volunteers = volunteers.annotate(
            last_accepted=Max('offers_made__time_representative_accepted'))

    if 'last_offered' in columns or filter == 'inactive':
        volunteers = volunteers.annotate(
            last_offered=Max('offers_made__time_volunteer_accepted'))

    ### ADDITIONAL FILTERING (should be converted to generic filters above) ###

    export_filename = "volunteers-export.xls"

    if filter == 'uncommitted':
        # Filter by volunteers who have never been accepted by a representative.
        volunteers = volunteers.filter(last_accepted__isnull=True)
        export_filename = "uncommitted-volunteers-export.xls"
    if filter == 'inactive':
        # Filter by volunteers who have never agreed to a position.
        volunteers = volunteers.filter(last_offered__isnull=True)
        export_filename = "inactive-volunteers-export.xls"

    if 'export' in request.REQUEST:
        if request.REQUEST['export'] == 'xls':
            xls_columns = [
                xls.Column("First name", lambda x: x.first_name),
                xls.Column("Last name", lambda x: x.last_name),
                xls.Column("Email", lambda x: x.email),
            ]

            if settings.FEATURE_DISPLAY_STUDENT_ID:
                xls_columns.append(
                    xls.Column(
                        "Student ID",
                        lambda x: x.get_profile().volunteerprofile.student_id))

            if "course" in columns:
                xls_columns.append(
                    xls.Column(
                        "Course",
                        lambda x: x.baseprofile.volunteerprofile.course))

            if "registered" in columns:
                xls_columns.append(
                    xls.Column("Registered", lambda x: x.date_joined))

            if "grad_year" in columns:
                xls_columns.append(
                    xls.Column("Grad. year",
                               lambda x: x.baseprofile.volunteerprofile.year))

            if "offers" in columns:
                xls_columns.append(
                    xls.Column("Offers", lambda x: x.offers_made__count))

            if "last_accepted" in columns:
                xls_columns.append(
                    xls.Column("Last accepted", lambda x: x.last_accepted))

            if "hours_logged" in columns:
                xls_columns.append(
                    xls.Column("Hours logged",
                               lambda x: x.get_profile().total_hours()))
                xls_columns.append(
                    xls.Column(
                        "Hours confirmed",
                        lambda x: x.get_profile().total_confirmed_hours()))

            return xls.XlsResponse(xls_columns, volunteers, export_filename)

    ### POST_PROCESSING ###

    return render_to_response("profiles/volunteers.html", {
        'volunteers': volunteers,
        'organisation': organisation,
        'filter': filter,
        'tform': type_filter_form,
        'cform': column_filter_form,
        'columns': columns,
        'action': action,
        'position': position,
    },
                              context_instance=RequestContext(request))
Example #4
0
def volunteers(request, position_id=None, filter=None, action=None, organisation_id=''):

    if not request.user.is_staff:
        organisation_id = request.user.get_profile().representativeprofile.organisation.id

    position = None

    if action:
        if action == "recommend":
            position = get_object_or_404(Position, pk=position_id)
            if request.method == "POST":
                volunteer_ids = logic.get_action_ids(request)
                volunteers = [get_object_or_404(User, pk=vid) for vid in volunteer_ids]
                positions.logic.recommend_position(request, position, volunteers)
        if action == "mailout":
            if request.method == "POST":
                volunteer_ids = logic.get_action_ids(request)
                volunteers = [get_object_or_404(User, pk=vid) for vid in volunteer_ids]
                return redirect(mailer.logic.new(volunteers, request.user, organisation_id))

    type_filter_form = VolunteerTypeFilterForm(request.GET)
    type_filter_form.is_valid()
    grad_filter = type_filter_form.cleaned_data['postgrad']
    international_filter = type_filter_form.cleaned_data['international']
    course_filter = type_filter_form.cleaned_data['course']
    category_filter = type_filter_form.cleaned_data['category']
    faculty_filter = type_filter_form.cleaned_data['faculty']
    hours_filter = type_filter_form.cleaned_data['hours']
    year_filter = type_filter_form.cleaned_data['year']

    column_filter_form = ColumnFilterForm(request.GET)
    column_filter_form.is_valid()
    columns = column_filter_form.cleaned_data['columns']

    if grad_filter == []:
        grad_filter = all_of(GRAD_CHOICES)
    if international_filter == []:
        international_filter = all_of(INTERNATIONAL_CHOICES)
    if columns == []:
        columns = VOLUNTEER_COLUMN_CHOICES_DEFAULT

    type_filter_form.data = {
        'postgrad': grad_filter,
        'international': international_filter,
        'course': course_filter,
        'faculty': faculty_filter,
        'category': category_filter,
        'hours': hours_filter,
        'year': year_filter,
    }

    column_filter_form.data = {
        'columns': columns,
    }

    # The __in operator doesn't work for NULL. Instead, __isnull must be used.
    grad_filter_exp = Q(baseprofile__volunteerprofile__postgrad__in=booleanise(grad_filter))
    if 'None' in grad_filter:
         grad_filter_exp |= Q(baseprofile__volunteerprofile__postgrad__isnull=True)

    # In the special case that all ineternational choices are chosen, we also select records
    # for students who don't have an international status.
    if set(international_filter) == set(all_of(INTERNATIONAL_CHOICES)):
        international_filter.append("")
    international_filter_exp = Q(baseprofile__volunteerprofile__international__in=international_filter)

    ### BASE QUERY ###

    volunteers = User.objects\
        .filter(baseprofile__is_volunteer=True, baseprofile__archived=(filter == 'deactivated'))\
        .filter(international_filter_exp)\
        .filter(grad_filter_exp)\
        .order_by('first_name')

    ### ORGANISATION FILTER ###
    organisation = None
    if organisation_id:
        volunteers = volunteers.filter(commitment__organisation__id=organisation_id)
        organisation = Organisation.objects.get(pk=organisation_id)

    ### ADD FILTERS ###

    if course_filter:
        volunteers = volunteers.filter(baseprofile__volunteerprofile__course__icontains=course_filter)

    if year_filter and year_filter != "ALL":
        volunteers = volunteers.filter(baseprofile__volunteerprofile__year__exact=int(year_filter))

    if faculty_filter:
        volunteers = volunteers.filter(baseprofile__volunteerprofile__school=faculty_filter.name)

    if category_filter:
        volunteers = volunteers.filter(baseprofile__volunteerprofile__categories=category_filter)

    if hours_filter == "HAS_HOURS":
        volunteers = volunteers.filter(timerecord__isnull=False)

    if hours_filter == "NO_HOURS":
        volunteers = volunteers.filter(timerecord__isnull=True)

    ### ADD FOREIGN COLUMNS ###

    if 'year' in columns:
        volunteers = volunteers.select_related('baseprofile__volunteerprofile__year')

    if 'course' in columns:
        volunteers = volunteers.select_related('baseprofile__volunteerprofile__course')

    ### ADD COMPLEX COLUMNS ###

    if 'offers' in columns:
        volunteers = volunteers.annotate(Count('offers_made'))

    if 'last_accepted' in columns or filter == 'uncommitted':
        volunteers = volunteers.annotate(last_accepted=Max('offers_made__time_representative_accepted'))

    if 'last_offered' in columns or filter == 'inactive':
        volunteers = volunteers.annotate(last_offered=Max('offers_made__time_volunteer_accepted'))

    ### ADDITIONAL FILTERING (should be converted to generic filters above) ###

    export_filename = "volunteers-export.xls"

    if filter == 'uncommitted':
        # Filter by volunteers who have never been accepted by a representative.
        volunteers = volunteers.filter(last_accepted__isnull=True)
        export_filename = "uncommitted-volunteers-export.xls"
    if filter == 'inactive':
        # Filter by volunteers who have never agreed to a position.
        volunteers = volunteers.filter(last_offered__isnull=True)
        export_filename = "inactive-volunteers-export.xls"

    if 'export' in request.REQUEST:
        if request.REQUEST['export'] == 'xls':
            xls_columns = [
                xls.Column("First name", lambda x: x.first_name),
                xls.Column("Last name", lambda x: x.last_name),
                xls.Column("Email", lambda x: x.email),
            ]

            if settings.FEATURE_DISPLAY_STUDENT_ID:
                xls_columns.append(xls.Column("Student ID", lambda x: x.get_profile().volunteerprofile.student_id))

            if "course" in columns:
                xls_columns.append(xls.Column("Course", lambda x: x.baseprofile.volunteerprofile.course))

            if "registered" in columns:
                xls_columns.append(xls.Column("Registered", lambda x: x.date_joined))

            if "grad_year" in columns:
                xls_columns.append(xls.Column("Grad. year", lambda x: x.baseprofile.volunteerprofile.year))

            if "offers" in columns:
                xls_columns.append(xls.Column("Offers", lambda x: x.offers_made__count))

            if "last_accepted" in columns:
                xls_columns.append(xls.Column("Last accepted", lambda x: x.last_accepted))

            if "hours_logged" in columns:
                xls_columns.append(xls.Column("Hours logged", lambda x: x.get_profile().total_hours()))
                xls_columns.append(xls.Column("Hours confirmed", lambda x: x.get_profile().total_confirmed_hours()))

            return xls.XlsResponse(xls_columns, volunteers, export_filename)

    ### POST_PROCESSING ###

    return render_to_response("profiles/volunteers.html", {
            'volunteers': volunteers,
            'organisation': organisation,
            'filter': filter,
            'tform': type_filter_form,
            'cform': column_filter_form,
            'columns': columns,
            'action': action,
            'position': position,
            }, context_instance=RequestContext(request))