{% if items %}

  <ul>

    {% for item in items %}

      <li>{{ item.quantity }} &times; {{ item.product }} {{ suffix }}</li>

    {% endfor %}

  </ul>

{% endif %}

{% extends "registrasion/base.html" %}

{% load registrasion_tags %}

{% block content %}

<h2>Item summary for {{ user.attendee.attendeeprofilebase.attendee_name }}

  (id={{user.id}})</h2>

<h3>Paid Items</h3>

<p>You cannot remove paid items from someone's registration. You must first

  cancel the invoice that added those items. You will need to re-add the items

  from that invoice for the user to have them available again.</p>

{% include "registrasion/_items_list.html" with items=paid %}

<br />

<h3>Cancelled Items</h3>

{% include "registrasion/_items_list.html" with items=cancelled %}

<br />

<h3>Amend pending items</h3>

<form class="form-horizontal" method="POST">

  {% csrf_token %}

  {% include "_form_snippet.html" with form=form %}

  <br/>

  <input class="btn btn-primary" type="submit">

</form>

<br />

<h3>Generate invoice</h3>

<div class="btn-group">

  <a class="btn btn-primary" href="{% url "checkout" user.id %}">Check out cart and view invoice</a>

</div>

<br />

<h3>Apply voucher</h3>

<form class="form-horizontal" method="POST">

  {% csrf_token %}

  {% include "_form_snippet.html" with form=voucher_form %}

  <br/>

  <input class="btn btn-primary" type="submit">

</form>

{% endblock %}

{% extends "registrasion/base.html" %}

{% load lca2018_tags %}

{% block scripts_extra %}

{{ form.media.js }}

<script type="text/javascript">

    postcode_label = $("label[for='id_profile-state']");

    postcode_help = $("#id_profile-state + p");

      $('#id_profile-country').change(function () {

        if ($(this).val() == 'AU' )  {

          postcode_label.addClass('label-required');

          postcode_help.show();

        } else {

          postcode_label.removeClass('label-required');

          postcode_help.hide();

        } });

        $("#id_profile-country").change();

      </script>

{% endblock %}

{% block proposals_body %}

  <p>These details will appear on your badge, your invoices, and will be used to order catered food at the conference.</p>

  <form class="form-horizontal" method="post" action="">

    {% csrf_token %}

    <fieldset>

      {% include "_form_snippet.html" with form=form %}

      <br />

      <input class="btn btn-primary" type="submit" value="Save Profile" />

      {% if user.attendee %}

      <a class="btn btn-light" href="{% url "dashboard" %}">Cancel</a>

      {% endif %}

    </fieldset>

  </form>

{% endblock %}

{% extends "registrasion/base.html" %}

{% load registrasion_tags %}

{% load lca2018_tags %}

{% block page_title %}Review your selection{% endblock %}

{% block page_lead %}

  Please ensure that you have selected all of the products you require, including

  t-shirts and social event tickets.

{% endblock %}

{% block scripts_extra %}

  {{ voucher_form.media.js }}

  {{ form.media.js }}

{% endblock %}

{% block proposals_body %}

  {% items_pending as pending %}

  {% if pending %}

  <div class="my-4">

    <p>You've selected the following items, which will be in your invoice when you check out:<p>

    {% include "registrasion/_items_list.html" with items=pending %}

  </div>

  {% endif %}

  {% items_purchased as purchased %}

  {% if purchased %}

  <div class="my-4">

    <p>You've already paid for the following items:</p>

    {% include "registrasion/_items_list.html" with items=purchased suffix="<em>(PAID)</em>" %}

  </div>

  {% endif %}

  <div class="my-4">

    {% missing_categories as missing %}

    {% if missing %}

    <div class="alert alert-warning my-4 pb-4">

      <h4 class="alert-heading">You have empty categories</h4>

      <p>You have <em>not</em> selected anything from the following

        categories. If your ticket includes any of these, you still need to

        make a selection:

      </p>

      {% include "registrasion/_category_list.html" with categories=missing %}

    </div>

    {% endif %}

  </div>

  <div class="my-4">

    <p>If you have been given a voucher, please <a id="voucher-form-button" href="{% url "voucher_code" %}">enter your voucher code</a> now.

    </p>

  </div>

  <div class="my-4">

    {% if pending %}

    <p>You can either check out an invoice and pay for your selections, or return to

        the dashboard.</p>

    <a class="btn btn-primary" href="{% url "checkout" %}">

      <i class="fa fa-credit-card"></i> Check out and pay

    </a>

    <a class="btn btn-light" href="{% url "dashboard" %}">Return to dashboard</a>

    {% else %}

    <p>You have no items that need to be paid.</p>

    <div class="form-actions">

      <a class="btn btn-light" href="{% url "dashboard" %}">Return to dashboard</a>

    </div>

    {% endif %}

  </div>

{% endblock %}

{% extends "registrasion/base.html" %}

{% load crispy_forms_tags %}

{% block proposals_body %}

  <form method="post" action="">

    {% csrf_token %}

    <div class="panel panel-primary">

      <div class="panel-body">

        {{ voucher_form|crispy}}

      </div>

      <div class="panel-footer">

        <input class="btn btn-primary" type="submit" value="Apply voucher code" />

        <a href="{% url "dashboard" %}" class="btn btn-default">Back to dashboard</a>

      </div>

    </div>

  </form>

{% endblock %}

{% load i18n %}

{% load proposal_tags %}

{% load review_tags %}

{% load teams_tags %}

{% load registrasion_tags %}

{% load lca2018_tags %}

{% load lca2019_tags %}

{% load staticfiles %}

{% if user.is_staff %}

<div class="mb-4">

  <div class="row">

    <div class="col-12">

      <h2>{% trans "Administration" %}</h2>

      <p>The following administrative tools are available to you:

        <ul class="list-unstyled">

          <li><a href="{% url "reports_list" %}">Reports</a></li>

        </ul>

      </p>

    </div>

  </div>

</div>

{% endif %}

<div class="mb-4">

  <div class="row">

    <div class="col-12">

      <h2>{% trans "Attend" %} {% conference_name %}</h2>

    </div>

  </div>

  {% if not user.attendee.completed_registration %}

  <div class="row">

    <div class="col-12">

      <h3>Register</h3>

      <p>To attend the conference, you must create an attendee profile and purchase your ticket</p>

      <div>

        <a class="btn btn-lg btn-primary" role="button" href="{% url "guided_registration" %}">Get your ticket</a>

      </div>

    </div>

  </div>

  {% else %}

  <div class="row">

    <div class="col-md-6 mb-3 mb-md-0">

      <h3>Attendee Profile</h3>

      <p>If you would like to change the details on your badge or your attendee statistics, you may edit your attendee profile here.</p>

      <div>

        <a class="btn btn-primary" role="button" href="{% url "attendee_edit" %}">Edit attendee profile</a>

      </div>

    </div>

    <div class="col-md-6 mb-3 mb-md-0">

      <h3>Account Management</h3>

      <p>If you would like to change your registered email address or password, you can use our self-service account management portal</p>

      <div>

        <a class="btn btn-primary" role="button" href="https://login.linux.conf.au/manage/">Account Management</a>

      </div>

    </div>

  </div>

  {% items_pending as pending %}

  <div class="row">

    <div class="col-12">

      <h3 class="my-3">Account</h3>

    </div>

  </div>

  <div class="row">

    {% if pending %}

      <h4>Items pending payment</h4>

      {% include "registrasion/_items_list.html" with items=pending %}

    </div>

    {% endif %}

    {% items_purchased as purchased %}

    {% if purchased %}

      <h4>Paid Items</h4>

      {% include "registrasion/_items_list.html" with items=purchased %}

    </div>

    {% endif %}

      <h4>Add/Update Items</h4>

    </div>

    {% invoices as invoices %}

    {% if invoices %}

      <h4>Invoices</h4>

      <ul>

        {% for invoice in invoices %}

        <li{% if invoice.is_void %} class="void-invoice" style="display: none;"{% endif %}>

          <a href="{% url "invoice" invoice.id %}" >Invoice {{ invoice.id }}</a> - ${{ invoice.value }} ({{ invoice.get_status_display }})

        </li>

        {% endfor %}

      </ul>

      {% if invoices|any_is_void %}

      <div class="mt-auto">

      </div>

      {% endif %}

    </div>

    {% endif %}

    {% if false %}

      <h4>Raffle Tickets</h4>

      <p><a href="/raffle/tickets/">View all my raffle tickets</a></p>

      {# REMOVE HARDCODED CATEGORY NUMBER!!!! #}

      <p><a href="/tickets/category/8">Buy raffle tickets</a></p>

    </div>

    {% endif %}

    {% available_credit as credit %}

    {% if credit %}

      <h4>Credit</h4>

      <p>You have ${{ credit }} leftover from refunded invoices. This credit will be automatically applied to new invoices. Contact the conference organisers if you wish to arrange a refund to your original payment source.</p>

    </div>

    {% endif %}

  </div>

  {% endif %} {# user.attendee.completed_registration #}

</div>

from django import template

from django.forms import Form

import re

register = template.Library()

@register.filter

def has_required_fields(form):

    for field in form:

        if isinstance(field, Form):

            if has_required_fields(field):

                return True

        if field.field.required:

            return True

    return False

@register.filter

def has_price_fields(form):

    for field in form:

        if isinstance(field, Form):

            return has_price_fields(field)

        help_text = field.field.help_text or ''

        if '$' in help_text:

            return True

        label = field.field.label or ''

        if '$' in label:

            return True

        choices = getattr(field.field, 'choices', [])

        if choices:

            for choice_id, choice_text in choices:

                if '$' in choice_text:

                    return True

    return False

@register.filter

def any_is_void(invoices):

    for invoice in invoices:

        if invoice.is_void:

            return True

    return False

@register.filter

def listlookup(lookup, target):

    try:

        return lookup[target]

    except IndexError:

        return None

@register.filter

def clean_text(txt):

    # Remove double/triple/+ spaces from `txt` and replace with single space

    return re.sub(r' {2,}' , ' ', txt)

@register.filter

def twitter_handle(txt):

    # Add @ to twitter handle if not present

    return txt if txt.startswith('@') else '@{}'.format(txt)

from . import forms

import collections

import datetime

import itertools

from django.conf import settings

from django.contrib.auth.decorators import user_passes_test

from django.contrib.auth.models import User

from django.core.urlresolvers import reverse

from django.db import models

from django.db.models import F, Q, Subquery, OuterRef

from django.db.models import Count, Max, Sum

from django.db.models import Case, When, Value

from django.db.models.fields.related import RelatedField

from django.db.models.fields import CharField

from django.shortcuts import render

from registrasion.controllers.cart import CartController

from registrasion.controllers.item import ItemController

from registrasion.models import conditions

from registrasion.models import commerce

from registrasion.models import people

from registrasion import util

from registrasion import views

from symposion.schedule import models as schedule_models

from .reports import get_all_reports

from .reports import Links

from .reports import ListReport

from .reports import QuerysetReport

from .reports import report_view

import bleach

def CURRENCY():

    return models.DecimalField(decimal_places=2)

AttendeeProfile = util.get_object_from_name(settings.ATTENDEE_PROFILE_MODEL)

@user_passes_test(views._staff_only)

def reports_list(request):

    ''' Lists all of the reports currently available. '''

    reports = []

    for report in get_all_reports():

        reports.append({

            "name": report.__name__,

            "title": report.title,

            "url": reverse(report),

            "description": report.__doc__,

        })

    reports.sort(key=lambda report: report["name"])

    ctx = {

        "reports": reports,

    }

    return render(request, "registrasion/reports_list.html", ctx)

# Report functions

@report_view("Reconcilitation")

def reconciliation(request, form):

    ''' Shows the summary of sales, and the full history of payments and

    refunds into the system. '''

    return [

        sales_payment_summary(),

        items_sold(),

        payments(),

        credit_note_refunds(),

    ]

def items_sold():

    ''' Summarises the items sold and discounts granted for a given set of

    products, or products from categories. '''

    data = None

    headings = None

    line_items = commerce.LineItem.objects.filter(

        invoice__status=commerce.Invoice.STATUS_PAID,

    ).select_related("invoice")

    line_items = line_items.order_by(

        # sqlite requires an order_by for .values() to work

        "-price", "description",

    ).values(

        "price", "description",

    ).annotate(

        total_quantity=Sum("quantity"),

    )

    headings = ["Description", "Quantity", "Price", "Total"]

    data = []

    total_income = 0

    for line in line_items:

        cost = line["total_quantity"] * line["price"]

        data.append([

            line["description"], line["total_quantity"],

            line["price"], cost,

        ])

        total_income += cost

    data.append([

        "(TOTAL)", "--", "--", total_income,

    ])

    return ListReport("Items sold", headings, data)

def sales_payment_summary():

    ''' Summarises paid items and payments. '''

    def value_or_zero(aggregate, key):

        return aggregate[key] or 0

    def sum_amount(payment_set):

        a = payment_set.values("amount").aggregate(total=Sum("amount"))

        return value_or_zero(a, "total")

    headings = ["Category", "Total"]

    data = []

    # Summarise all sales made (= income.)

    sales = commerce.LineItem.objects.filter(

        invoice__status=commerce.Invoice.STATUS_PAID,

    ).values(

        "price", "quantity"

    ).aggregate(

        total=Sum(F("price") * F("quantity"), output_field=CURRENCY()),

    )

    sales = value_or_zero(sales, "total")

    all_payments = sum_amount(commerce.PaymentBase.objects.all())

    # Manual payments

    # Credit notes generated (total)

    # Payments made by credit note

    # Claimed credit notes

    all_credit_notes = 0 - sum_amount(commerce.CreditNote.objects.all())

    unclaimed_credit_notes = 0 - sum_amount(commerce.CreditNote.unclaimed())

    claimed_credit_notes = sum_amount(

        commerce.CreditNoteApplication.objects.all()

    )

    refunded_credit_notes = 0 - sum_amount(commerce.CreditNote.refunded())

    data.append(["Items on paid invoices", sales])

    data.append(["All payments", all_payments])

    data.append(["Sales - Payments ", sales - all_payments])

    data.append(["All credit notes", all_credit_notes])

    data.append(["Credit notes paid on invoices", claimed_credit_notes])

    data.append(["Credit notes refunded", refunded_credit_notes])

    data.append(["Unclaimed credit notes", unclaimed_credit_notes])

    data.append([

        "Credit notes - (claimed credit notes + unclaimed credit notes)",

        all_credit_notes - claimed_credit_notes -

        refunded_credit_notes - unclaimed_credit_notes

        ])

    return ListReport("Sales and Payments Summary", headings, data)

def payments():

    ''' Shows the history of payments into the system '''

    payments = commerce.PaymentBase.objects.all()

    return QuerysetReport(

        "Payments",

        ["invoice__id", "id", "reference", "amount"],

        payments,

        link_view=views.invoice,

    )

def credit_note_refunds():

    ''' Shows all of the credit notes that have been generated. '''

    notes_refunded = commerce.CreditNote.refunded()

    return QuerysetReport(

        "Credit note refunds",

        ["id", "creditnoterefund__reference", "amount"],

        notes_refunded,

        link_view=views.credit_note,

    )

def group_by_cart_status(queryset, order, values):

    queryset = queryset.annotate(

        is_reserved=Case(

            When(cart__in=commerce.Cart.reserved_carts(), then=Value(True)),

            default=Value(False),

            output_field=models.BooleanField(),

        ),

    )

    values = queryset.order_by(*order).values(*values)

    values = values.annotate(

        total_paid=Sum(Case(

            When(

                cart__status=commerce.Cart.STATUS_PAID,

                then=F("quantity"),

            ),

            default=Value(0),

        )),

        total_refunded=Sum(Case(

            When(

                cart__status=commerce.Cart.STATUS_RELEASED,

                then=F("quantity"),

            ),

            default=Value(0),

        )),

        total_unreserved=Sum(Case(

            When(

                (

                    Q(cart__status=commerce.Cart.STATUS_ACTIVE) &

                    Q(is_reserved=False)

                ),

                then=F("quantity"),

            ),

            default=Value(0),

        )),

        total_reserved=Sum(Case(

            When(

                (

                    Q(cart__status=commerce.Cart.STATUS_ACTIVE) &

                    Q(is_reserved=True)

                ),

                then=F("quantity"),

            ),

            default=Value(0),

        )),

    )

    return values

@report_view("Limits")

def limits(request, form):

    ''' Shows the summary of sales against stock limits. '''

    product_items = commerce.ProductItem.objects.filter(

        cart__status=commerce.Invoice.STATUS_PAID,

    ).values(

        "product", "product__name",

    ).annotate(

        total_quantity=Sum("quantity")

    )

    limits = conditions.TimeOrStockLimitFlag.objects.all().order_by("-limit")

    headings = ["Product", "Quantity"]

    reports = []

    for limit in limits:

        data = []

        total = 0

        limit_items = product_items.filter(product__in=limit.all_products)

        for product in limit_items:

            data.append([product['product__name'], product['total_quantity']])

            total += product['total_quantity']

        if limit.limit:

            data.append(['(TOTAL)', '%s/%s' % (total, limit.limit)])

        else:

            data.append(['(TOTAL)', total])

        description = limit.description

        extras = []

        if limit.start_time:

            extras.append('Starts: %s' % (limit.start_time))

        if limit.end_time:

            extras.append('Ends: %s' % (limit.end_time))

        if extras:

            description += ' (' + ', '.join(extras) + ')'

        reports.append(ListReport(description, headings, data))

    # now get discount items

    discount_items = conditions.DiscountBase.objects.select_subclasses()

    data = []

    for discount in discount_items.all():

        quantity = 0

        for item in discount.discountitem_set.filter(cart__status=2):

            quantity += item.quantity

        description = discount.description

        extras = []

        if getattr(discount, 'start_time', None):

            extras.append('Starts: %s' % (discount.start_time))

        if getattr(discount, 'end_time', None):

            extras.append('Ends: %s' % (discount.end_time))

        if extras:

            description += ' (' + ', '.join(extras) + ')'

        if getattr(discount, 'limit', None):

            data.append([description, '%s/%s' % (quantity, discount.limit)])

        else:

            data.append([description, quantity])

    headings = ["Discount", "Quantity"]

    reports.append(ListReport('Discounts', headings, data))

    vprod=Subquery(conditions.VoucherFlag.objects.filter(

        voucher__code__in=OuterRef("cart__vouchers__code")).values("products"))

    vcat=Subquery(conditions.VoucherFlag.objects.filter(

        voucher__code__in=OuterRef("cart__vouchers__code")).values("categories"))

    invoices_using_vouchers=commerce.Invoice.objects.filter((

        Q(lineitem__product__in=vprod)|

        Q(lineitem__product__category__in=vcat)

    )).filter(

        status=commerce.Invoice.STATUS_PAID).order_by(

            "cart__vouchers__code").select_related("user")

    vouchers = []

    for inv in invoices_using_vouchers:

        code=inv.cart.vouchers.all().values("code")[0]["code"]

        vouchers.append((code,inv.id,inv))

    voucher_headings = ["Code","Invoice#","Details"]

    reports.append(ListReport('Vouchers', voucher_headings, vouchers))

    return reports

@report_view("Product status", form_type=forms.ProductAndCategoryForm)

def product_status(request, form):

    ''' Summarises the inventory status of the given items, grouping by

    invoice status. '''

    products = form.cleaned_data["product"]

    categories = form.cleaned_data["category"]

    items = commerce.ProductItem.objects.filter(

        Q(product__in=products) | Q(product__category__in=categories),

    ).select_related("cart", "product")

    items = group_by_cart_status(

        items,

        ["product__category__order", "product__order"],

        ["product", "product__category__name", "product__name"],

    )

    headings = [

        "Product", "Paid", "Reserved", "Unreserved", "Refunded",

    ]

    data = []

    for item in items:

        data.append([

            "%s - %s" % (

                item["product__category__name"], item["product__name"]

            ),

            item["total_paid"],

            item["total_reserved"],