Produits Entr'ouvert » Combo

from django.db.models.expressions import RawSQL

from django.utils.timezone import make_aware, now

from .models import BasketItem, PaymentBackend, Regie, Transaction

class BasketItemErrorListView(ListView):

    model = BasketItem

    template_name = 'lingo/basketitem_error_list.html'

    paginate_by = 10

    def get_queryset(self):

        raw = (

            'SELECT %s FROM lingo_transaction '

            'INNER JOIN lingo_transaction_items '

            'ON "lingo_transaction"."id" = "lingo_transaction_items"."transaction_id" '

            'AND "lingo_transaction_items"."basketitem_id"="lingo_basketitem"."id" '

            'ORDER BY start_date DESC LIMIT 1')

        queryset = (

            BasketItem.objects

            .annotate(bank_transaction_id=RawSQL(raw % 'bank_transaction_id', []))

            .annotate(transaction_status=RawSQL(raw % 'status', []))

            .order_by())

        queryset1 = (

            queryset

            .filter(

                notification_date__isnull=True,

                cancellation_date__isnull=True,

                payment_date__lt=now() - datetime.timedelta(minutes=300)))

        queryset2 = queryset.filter(transaction_status=eopayment.ERROR)

        return queryset1.union(queryset2).order_by('-creation_date')

{% extends "lingo/manager_base.html" %}

{% load i18n %}

{% block appbar %}

<h2>{% trans 'Payments in error' %}</h2>

{% endblock %}

{% block breadcrumb %}

{{ block.super }}

<a href="{% url 'lingo-manager-payment-error-list' %}">{% trans 'Payments in error' %}</a>

{% endblock %}

{% block content %}

{% if object_list %}

<table class="main">

<thead>

  <tr>

   <th>{% trans 'Item' %}</th>

   <th>{% trans 'Amount' %}</th>

   <th colspan="2">{% trans 'Date' %}</th>

  </tr>

</thead>

<tbody>

{% for object in object_list %}

<tr>

  <td><a href="{{ object.source_url }}">{{ object.subject }}</a></td>

  <td class="price">{{ object.amount }} €</td>

  <td>{{ object.payment_date }}</td>

  <td>

    {% if object.transaction_status != 99 %}

      <a href="{% url 'lingo-manager-homepage' %}?q={{ object.bank_transaction_id }}">{% trans "See transaction" %}</a>

    {% endif %}

  </td>

</tr>

{% endfor %}

</tbody>

</table>

{% include "gadjo/pagination.html" %}

{% else %}

<div class="big-msg-info">

  {% blocktrans %}

  This site doesn't have any payment in error yet.

  {% endblocktrans %}

</div>

{% endif %}

{% endblock %}

<a href="{% url 'lingo-manager-payment-error-list' %}">{% trans 'Payments in error' %}</a>

                            RegieDeleteView, TransactionListView, BasketItemErrorListView,

                            download_transactions_csv, PaymentBackendListView,

                            PaymentBackendCreateView, PaymentBackendUpdateView,

                            PaymentBackendDeleteView)

    url('^payments/error/$', BasketItemErrorListView.as_view(), name='lingo-manager-payment-error-list'),

def test_basketitem_error_list(app, admin_user, payment_backend):

    regie = Regie.objects.create(

        label='test-regie', slug='test-regie', payment_backend=payment_backend)

    user = User.objects.create_user('dimebag', 'dime@bag.pan', 'pwd')

    date_now = now()

    date_in_past = date_now - datetime.timedelta(minutes=300)

    # item with payment_date and notification_date, status PAID

    # => not displayed

    item1 = BasketItem.objects.create(

        user=user,

        regie=regie,

        subject='item 1',

        source_url='http://example.net/1',

        amount=1,

        payment_date=date_in_past,

        notification_date=date_in_past)

    transaction11 = Transaction.objects.create(

        status=eopayment.ERROR,

        order_id='order id 1.1',

        bank_transaction_id='bank_id_11',

        amount=1)

    transaction11.items.add(item1)

    transaction12 = Transaction.objects.create(

        status=eopayment.PAID,

        order_id='order id 1.2',

        bank_transaction_id='bank_id_12',

        amount=1)

    transaction12.items.add(item1)

    # item with payment_date and notification_date, status ERROR

    # => displayed

    item2 = BasketItem.objects.create(

        user=user,

        regie=regie,

        subject='item 2',

        source_url='http://example.net/2',

        amount=2,

        payment_date=date_in_past,

        notification_date=date_in_past)

    transaction21 = Transaction.objects.create(

        status=eopayment.ERROR,

        order_id='order id 2.1',

        bank_transaction_id='bank_id_21',

        amount=2)

    transaction21.items.add(item2)

    transaction22 = Transaction.objects.create(

        status=eopayment.ERROR,

        order_id='order id 2.2',

        bank_transaction_id='bank_id_22',

        amount=2)

    transaction22.items.add(item2)

    # item without dates, status ERROR

    # => displayed

    item3 = BasketItem.objects.create(

        user=user,

        regie=regie,

        subject='item 3',

        source_url='http://example.net/3',

        amount=3)

    transaction3 = Transaction.objects.create(

        status=eopayment.ERROR,

        order_id='order id 3',

        bank_transaction_id='bank_id_3',

        amount=3)

    transaction3.items.add(item3)

    # item with payment_date but no notification_date, too young

    # => not displayed

    item4 = BasketItem.objects.create(

        user=user,

        regie=regie,

        subject='item 4',

        source_url='http://example.net/4',

        amount=4,

        payment_date=date_now,

        notification_date=None)

    transaction4 = Transaction.objects.create(

        order_id='order id 4',

        bank_transaction_id='bank_id_4',

        amount=4)

    transaction4.items.add(item4)

    # item with payment_date but no notification_date, in the past

    # => displayed

    item5 = BasketItem.objects.create(

        user=user,

        regie=regie,

        subject='item 5',

        source_url='http://example.net/5',

        amount=5,

        payment_date=date_in_past,

        notification_date=None)

    transaction5 = Transaction.objects.create(

        order_id='order id 5',

        bank_transaction_id='bank_id_5',

        amount=5)

    transaction5.items.add(item5)

    # item with payment_date, no notification_date, but a cancellation_date, in the past

    # => not displayed

    item6 = BasketItem.objects.create(

        user=user,

        regie=regie,

        subject='item 6',

        source_url='http://example.net/6',

        amount=6,

        payment_date=date_in_past,

        notification_date=None,

        cancellation_date=date_now)

    transaction6 = Transaction.objects.create(

        order_id='order id 6',

        bank_transaction_id='bank_id_6',

        amount=6)

    transaction6.items.add(item6)

    app = login(app)

    resp = app.get('/manage/lingo/payments/error/', status=200)

    assert list(resp.context['object_list']) == [item5, item3, item2]

    assert '<a href="%s">' % item5.source_url in resp.text

    assert '<a href="%s">' % item3.source_url in resp.text

    assert '<a href="%s">' % item2.source_url in resp.text

    assert '/manage/lingo/?q=%s' % transaction5.bank_transaction_id in resp.text

    assert '/manage/lingo/?q=%s' % transaction3.bank_transaction_id not in resp.text

    assert '/manage/lingo/?q=%s' % transaction22.bank_transaction_id not in resp.text