예제 #1
0
def budget_request(app, story):
    story.append(Paragraph("Budget Request", styles["Heading2"]))
    categories = []
    current_year = {}
    # XXX HACKS -- make current year categories always come first!
    for category in LineItemCategory.objects.filter(
            years__date=app.year).order_by('pk'):
        category_sum = sum_line_items(
            LineItem.objects.filter(application=app, category=category))
        # XXX HACKS
        if category.name.startswith("Current"):
            current_year['name'] = category.name
            current_year['sum'] = category_sum
            current_year[
                'end_balance'] = category_sum - app.balance_forward - app.afap_income
            current_year['object'] = category
        else:
            categories.append({
                'name': category.name,
                'sum': category_sum,
                'object': category
            })
    total_sum = sum([x['sum']
                     for x in categories]) + current_year['end_balance']
    total_sum = total_sum or 0
    total_request = max(total_sum, 0)

    table_data = [
        ("Category", "Amount"),
        ("Balance forward", "$%s" % (app.balance_forward, )),
        ("AFAP Income", "$%s" % (app.afap_income, )),
        ("Current Year", "$%s" % (current_year['sum'], )),
        ("Current year end balance", "$%s" % (current_year['end_balance'], )),
        ("Projected %s expenses and income" % (app.year.range, ), ),
    ]

    for category in categories:
        table_data.append((category['name'], "$%s" % (category['sum'], )))
    print app, total_request
    table_data.append((
        "Sum",
        "$%s" % (total_sum, ),
    ), )
    table_data.append((
        "Request",
        "$%s" % (total_request, ),
    ))
    story.append(
        Table(table_data,
              repeatRows=1,
              style=[('SPAN', (0, 5), (1, 5)),
                     ('GRID', (0, 0), (-1, -1), 1, colors.black)]))
    if current_year['object'].lineitem_set.filter(application=app).exists():
        budget_request_category(app, current_year['object'], story)
    for category in categories:
        if category['object'].lineitem_set.filter(application=app).exists():
            budget_request_category(app, category['object'], story)
예제 #2
0
def budget_request_category(app, category, story):
    story.append(Paragraph(category.name, styles["Heading3"]))
    table_data = [("Description", "Amount")]
    lineitems = LineItem.objects.filter(application=app, category=category)
    for lineitem in lineitems:
        if lineitem.income:
            table_data.append((Paragraph("%s (income)" % (lineitem.description,), styles['Normal']), "$%s" % -lineitem.amount))
        else:
            table_data.append((Paragraph(lineitem.description, styles["Normal"]), "$%s" % lineitem.amount))
    table_data.append(("Sum", "$%s" % sum_line_items(lineitems)))
    story.append(Table(table_data, repeatRows=1, style=[('GRID', (0,0), (-1,-1), 1, colors.black)]))
예제 #3
0
파일: views.py 프로젝트: bkgood/misc-code
def approve(request, year, hash):
    try:
        year = afap.models.Year.objects.get(date=RangedDate(int(year), 1, 1))
        approval = afap.models.Approval.objects.get(key=hash)
    except (ValueError, afap.models.Year.DoesNotExist, afap.models.Approval.DoesNotExist):
        messages.error(request, "Invalid approval link; please check your email account "
            + "for an updated link or contact the person in your organization responsible "
            + "for the AFAP application.")
        return shortcuts.render_to_response('approval.html', {},
            template.RequestContext(request))
    if request.method == 'POST':
        form = afap.forms.ApprovalForm(request.POST, instance=approval)
        if form.is_valid():
            form.save()
            messages.info(request, "Your changes have been saved.")
            return shortcuts.redirect(urlresolvers.reverse(afap.views.approve,
                args=(year.year, hash,)))
        else:
            messages.error(request, "An error occurred in saving your changes, "
                + "please refer to any error messages below.")
    app = afap.forms.ApplicationForm(instance=approval.application)
    budget_request_by_cat = {}
    line_items = afap.models.LineItem.objects.filter(application=approval.application)
    for line_item in line_items:
        try:
            budget_request_by_cat[line_item.category]['line_items'].append(line_item)
        except (KeyError):
            budget_request_by_cat[line_item.category] = {'line_items': [line_item,],}
    budget_request = []
    for category in budget_request_by_cat:
        budget_request.append({
            'category': category,
            'line_items': budget_request_by_cat[category]['line_items'],
            'sum': sum_line_items(budget_request_by_cat[category]['line_items']),
        })
    total_sum = sum([x['sum'] for x in budget_request]) - (
        approval.application.balance_forward + approval.application.afap_income)
    total_request = max(total_sum, 0)
    form = afap.forms.ApprovalForm(instance=approval)
    return shortcuts.render_to_response('approval.html', {
        'form': form, 'application': app, 'budget_request': budget_request, 'approval': approval,
        'total_sum': total_sum, 'total_request': total_request, 'year': year, 'hash': hash,
        'balance_forward': approval.application.balance_forward,
        'afap_income': approval.application.afap_income,},
        template.RequestContext(request))
예제 #4
0
파일: views.py 프로젝트: bkgood/misc-code
def budgetrequestcategory(request, org, year, category):
    LineItemFormSet = modelformset_factory(afap.models.LineItem,
        exclude=('application', 'category'), can_delete=True, extra=10)
    try:
        year = afap.models.Year.objects.get(date=RangedDate(int(year), 1, 1))
    except (ValueError, afap.models.Year.DoesNotExist):
        return shortcuts.redirect(urlresolvers.reverse(home))
    try:
        app = afap.models.Application.objects.get(organization=org, year=year.date)
        category = afap.models.LineItemCategory.objects.get(pk=category, years=year)
    except afap.models.Application.DoesNotExist:
        messages.error(request, "You do not have an application for year %s" % year.range)
        return shortcuts.redirect(urlresolvers.reverse(home))
    except afap.models.LineItemCategory.DoesNotExist:
        return shortcuts.redirect(urlresolvers.reverse(budgetrequest, args=(year.year,)))
    if redirect_to_application(app):
        return shortcuts.redirect(urlresolvers.reverse(application, args=(year.year,)))
    if request.method == 'POST':
        if year.read_only:
            return shortcuts.redirect(urlresolvers.reverse(budgetrequestcategory,
                args=[year.year, category.pk]))
        formset = LineItemFormSet(request.POST)
        if formset.is_valid():
            instances = formset.save(commit=False)
            for instance in instances:
                instance.application = app
                instance.category = category
                instance.save()
            messages.info(request, "Your changes have been saved.")
            return shortcuts.redirect(urlresolvers.reverse(budgetrequestcategory,
                args=[year.year, category.pk]))
    else:
        formset = LineItemFormSet(
            queryset=afap.models.LineItem.objects.filter(application=app, category=category))
    for form in formset.forms:
        form.fields['description'].widget.attrs['class'] = 'itemdescription'
        form.fields['amount'].widget.attrs['class'] = 'itemamount'
        form.fields['income'].widget.attrs['class'] = 'itemincome'
        form.fields['DELETE'].widget.attrs['class'] = 'itemdelete'
    category_sum = sum_line_items(
        afap.models.LineItem.objects.filter(application=app, category=category))
    return shortcuts.render_to_response('budgetrequestcategory.html', {
        'formset': formset, 'year': year, 'active_year': year, 'category': category,
        'category_sum': category_sum, 'read_only': year.read_only,},
        template.RequestContext(request))
예제 #5
0
파일: views.py 프로젝트: bkgood/misc-code
def budgetrequest(request, org, year):
    try:
        year = afap.models.Year.objects.get(date=RangedDate(int(year), 1, 1))
        app = afap.models.Application.objects.get(organization=org, year=year.date)
    except ValueError:
        return shortcuts.redirect(urlresolvers.reverse(home))
    except afap.models.Application.DoesNotExist:
        messages.error(request, "You do not have an application for year %s" % year.range)
        return shortcuts.redirect(urlresolvers.reverse(home))
    if redirect_to_application(app):
        return shortcuts.redirect(urlresolvers.reverse(application, args=(year.year,)))
    if request.method == 'POST':
        if year.read_only:
            return shortcuts.redirect(urlresolvers.reverse(budgetrequest,
                args=(year.year,)))
        form = afap.forms.BudgetRequestForm(request.POST, instance=app)
        if form.is_valid():
            form.save()
            messages.info(request, "Your changes have been saved.")
            return shortcuts.redirect(urlresolvers.reverse(budgetrequest, args=(year.year,)))
    else:
        form = afap.forms.BudgetRequestForm(instance=app)
    categories = []
    current_year = {}
    # XXX HACKS -- make current year categories always come first!
    for category in afap.models.LineItemCategory.objects.filter(years__date=year.date).order_by('pk'):
        category_sum = sum_line_items(
            afap.models.LineItem.objects.filter(application=app, category=category))
        # XXX HACKS
        if category.name.startswith("Current"):
            current_year['name'] = category.name
            current_year['sum'] = category_sum
            current_year['pk'] = category.pk
            current_year['end_balance'] = category_sum - app.balance_forward - app.afap_income
        else:
            categories.append({'name': category.name, 'sum': category_sum, 'pk': category.pk})
    total_sum = sum([x['sum'] for x in categories]) + current_year['end_balance']
    total_sum = total_sum or 0
    total_request = max(total_sum, 0)

    return shortcuts.render_to_response('budgetrequest.html', {
        'categories': categories, 'total_sum': total_sum, 'year': year, 'active_year': year,
        'total_request': total_request, 'form': form, 'current_year': current_year,
        'read_only': year.read_only},
        template.RequestContext(request))
예제 #6
0
def budget_request_category(app, category, story):
    story.append(Paragraph(category.name, styles["Heading3"]))
    table_data = [("Description", "Amount")]
    lineitems = LineItem.objects.filter(application=app, category=category)
    for lineitem in lineitems:
        if lineitem.income:
            table_data.append(
                (Paragraph("%s (income)" % (lineitem.description, ),
                           styles['Normal']), "$%s" % -lineitem.amount))
        else:
            table_data.append(
                (Paragraph(lineitem.description,
                           styles["Normal"]), "$%s" % lineitem.amount))
    table_data.append(("Sum", "$%s" % sum_line_items(lineitems)))
    story.append(
        Table(table_data,
              repeatRows=1,
              style=[('GRID', (0, 0), (-1, -1), 1, colors.black)]))
예제 #7
0
def budget_request(app, story):
    story.append(Paragraph("Budget Request", styles["Heading2"]))
    categories = []
    current_year = {}
    # XXX HACKS -- make current year categories always come first!
    for category in LineItemCategory.objects.filter(years__date=app.year).order_by('pk'):
        category_sum = sum_line_items(
            LineItem.objects.filter(application=app, category=category))
        # XXX HACKS
        if category.name.startswith("Current"):
            current_year['name'] = category.name
            current_year['sum'] = category_sum
            current_year['end_balance'] = category_sum - app.balance_forward - app.afap_income
            current_year['object'] = category
        else:
            categories.append({'name': category.name, 'sum': category_sum, 'object': category})
    total_sum = sum([x['sum'] for x in categories]) + current_year['end_balance']
    total_sum = total_sum or 0
    total_request = max(total_sum, 0)

    table_data = [
        ("Category", "Amount"),
        ("Balance forward", "$%s" % (app.balance_forward,)),
        ("AFAP Income", "$%s" % (app.afap_income,)),
        ("Current Year", "$%s" % (current_year['sum'],)),
        ("Current year end balance", "$%s" % (current_year['end_balance'],)),
        ("Projected %s expenses and income" % (app.year.range,),),
    ]

    for category in categories:
        table_data.append((category['name'], "$%s" % (category['sum'],)))
    print app, total_request
    table_data.append(("Sum", "$%s" % (total_sum,),),)
    table_data.append(("Request", "$%s" % (total_request,),))
    story.append(Table(table_data, repeatRows=1, style=[
        ('SPAN', (0,5), (1,5)),
        ('GRID', (0,0), (-1,-1), 1, colors.black)]))
    if current_year['object'].lineitem_set.filter(application=app).exists():
        budget_request_category(app, current_year['object'], story)
    for category in categories:
        if category['object'].lineitem_set.filter(application=app).exists():
            budget_request_category(app, category['object'], story)