Produits Entr'ouvert » w.c.s.

    formdata = data_class()

    formdata.data = {

    formdata.just_created()

    formdata.jump_status('new')

    formdata.store()

import datetime

import os

import re

import pytest

from wcs import fields

from wcs.blocks import BlockDef

from wcs.carddef import CardDef

from wcs.formdef import FormDef

from wcs.qommon.http_request import HTTPRequest

from wcs.workflows import Workflow, WorkflowCriticalityLevel

from ..utilities import clean_temporary_pub, create_temporary_pub, get_app, login

from .test_all import create_environment, create_superuser, create_user

@pytest.fixture

def pub(request, emails):

    pub = create_temporary_pub(sql_mode=True)

    req = HTTPRequest(None, {'SCRIPT_NAME': '/', 'SERVER_NAME': 'example.net'})

    pub.set_app_dir(req)

    pub.cfg['identification'] = {'methods': ['password']}

    pub.cfg['language'] = {'language': 'en'}

    pub.write_cfg()

    with open(os.path.join(pub.app_dir, 'site-options.cfg'), 'w') as fd:

        fd.write(

            '''

    [api-secrets]

    coucou = 1234

    '''

        )

    return pub

def teardown_module(module):

    clean_temporary_pub()

def test_backoffice_listing_order(pub):

    create_superuser(pub)

    create_environment(pub)

    formdef = FormDef.get_by_urlname('form-title')

    ids = []

    for i, formdata in enumerate(formdef.data_class().select(order_by='id')):

        if formdata.status in ('wf-new', 'wf-accepted'):

            ids.append(formdata.id)

            formdata.receipt_time = datetime.datetime(2015, 1, 1, 10, i).timetuple()

            # ordered with odd-numbered ids then even-numbered ids

            formdata.evolution[-1].time = datetime.datetime(2015, 2, 1, 10 + i % 2, i).timetuple()

            formdata.store()

    inversed_receipt_time_order = list(reversed([str(x) for x in sorted(ids)]))

    last_update_time_order = [

        str(x) for x in sorted(ids, key=lambda x: int(x) if int(x) % 2 else int(x) + 1000)

    ]

    app = login(get_app(pub))

    resp = app.get('/backoffice/management/form-title/')

    assert resp.text.count('data-link') == 17

    ids = [x.strip('/') for x in re.findall(r'data-link="(.*?)"', resp.text)]

    assert ids == inversed_receipt_time_order

    resp = app.get('/backoffice/management/form-title/?order_by=receipt_time')

    assert resp.text.count('data-link') == 17

    ids = [x.strip('/') for x in re.findall(r'data-link="(.*?)"', resp.text)]

    assert ids == list(reversed(inversed_receipt_time_order))

    resp = app.get('/backoffice/management/form-title/?order_by=last_update_time')

    assert resp.text.count('data-link') == 17

    ids = [x.strip('/') for x in re.findall(r'data-link="(.*?)"', resp.text)]

    assert ids == last_update_time_order

    resp = app.get('/backoffice/management/form-title/?order_by=-last_update_time')

    assert resp.text.count('data-link') == 17

    ids = [x.strip('/') for x in re.findall(r'data-link="(.*?)"', resp.text)]

    assert ids == list(reversed(last_update_time_order))

    if not pub.site_options.has_section('options'):

        pub.site_options.add_section('options')

        pub.site_options.set('options', 'default-sort-order', '-last_update_time')

        with open(os.path.join(pub.app_dir, 'site-options.cfg'), 'w') as fd:

            pub.site_options.write(fd)

    resp = app.get('/backoffice/management/form-title/')

    assert resp.text.count('data-link') == 17

    ids = [x.strip('/') for x in re.findall(r'data-link="(.*?)"', resp.text)]

    assert ids == list(reversed(last_update_time_order))

    # try invalid values

    resp = app.get('/backoffice/management/form-title/?order_by=toto.plop', status=400)

def test_backoffice_criticality_in_formdef_listing_order(pub):

    create_user(pub)

    create_environment(pub)

    wf = Workflow.get_default_workflow()

    wf.id = '2'

    wf.criticality_levels = [

        WorkflowCriticalityLevel(name='green'),

        WorkflowCriticalityLevel(name='yellow'),

        WorkflowCriticalityLevel(name='red'),

    ]

    wf.store()

    formdef = FormDef.get_by_urlname('form-title')

    formdef.workflow_id = wf.id

    formdef.store()

    formdata1, formdata2, formdata3, formdata4 = [

        x for x in formdef.data_class().select() if x.status == 'wf-new'

    ][:4]

    formdata1.set_criticality_level(1)

    formdata1.store()

    formdata1_str = '>%s<' % formdata1.get_display_id()

    formdata2.set_criticality_level(2)

    formdata2.store()

    formdata2_str = '>%s<' % formdata2.get_display_id()

    formdata3.set_criticality_level(2)

    formdata3.store()

    formdata3_str = '>%s<' % formdata3.get_display_id()

    formdata4_str = '>%s<' % formdata4.get_display_id()

    app = login(get_app(pub))

    resp = app.get('/backoffice/management/form-title/?order_by=-criticality_level&limit=100')

    assert resp.text.index(formdata1_str) > resp.text.index(formdata2_str)

    assert resp.text.index(formdata1_str) > resp.text.index(formdata3_str)

    assert resp.text.index(formdata1_str) < resp.text.index(formdata4_str)

    resp = app.get('/backoffice/management/form-title/?order_by=criticality_level&limit=100')

    assert resp.text.index(formdata1_str) < resp.text.index(formdata2_str)

    assert resp.text.index(formdata1_str) < resp.text.index(formdata3_str)

    assert resp.text.index(formdata1_str) > resp.text.index(formdata4_str)

def test_backoffice_criticality_in_global_listing_order(pub):

    create_user(pub)

    create_environment(pub)

    wf = Workflow.get_default_workflow()

    wf.id = '2'

    wf.criticality_levels = [

        WorkflowCriticalityLevel(name='green'),

        WorkflowCriticalityLevel(name='yellow'),

        WorkflowCriticalityLevel(name='red'),

    ]

    wf.store()

    formdef = FormDef.get_by_urlname('form-title')

    formdef.workflow_id = wf.id

    formdef.store()

    formdata1, formdata2, formdata3, formdata4 = [

        x for x in formdef.data_class().select() if x.status == 'wf-new'

    ][:4]

    formdata1.set_criticality_level(1)

    formdata1.store()

    formdata1_str = '>%s<' % formdata1.get_display_id()

    formdata2.set_criticality_level(2)

    formdata2.store()

    formdata2_str = '>%s<' % formdata2.get_display_id()

    formdata3.set_criticality_level(2)

    formdata3.store()

    formdata3_str = '>%s<' % formdata3.get_display_id()

    formdata4_str = '>%s<' % formdata4.get_display_id()

    app = login(get_app(pub))

    resp = app.get('/backoffice/management/listing?order_by=-criticality_level&limit=100')

    assert resp.text.index(formdata1_str) > resp.text.index(formdata2_str)

    assert resp.text.index(formdata1_str) > resp.text.index(formdata3_str)

    assert resp.text.index(formdata1_str) < resp.text.index(formdata4_str)

    resp = app.get('/backoffice/management/listing?order_by=criticality_level&limit=100')

    assert resp.text.index(formdata1_str) < resp.text.index(formdata2_str)

    assert resp.text.index(formdata1_str) < resp.text.index(formdata3_str)

    assert resp.text.index(formdata1_str) > resp.text.index(formdata4_str)

def test_backoffice_block_columns_order(pub):

    pub.user_class.wipe()

    create_superuser(pub)

    pub.role_class.wipe()

    role = pub.role_class(name='test')

    role.store()

    CardDef.wipe()

    carddef = CardDef()

    carddef.name = 'foo'

    carddef.fields = [

        fields.StringField(id='1', label='First Name', type='string', varname='first_name'),

        fields.StringField(id='2', label='Last Name', type='string', varname='last_name'),

    ]

    carddef.digest_templates = {'default': '{{ form_var_first_name }} {{ form_var_last_name }}'}

    carddef.store()

    carddef.data_class().wipe()

    card = carddef.data_class()()

    card.data = {

        '1': 'Foo',

        '2': 'Bar',

    }

    card.store()

    card2 = carddef.data_class()()

    card2.data = {

        '1': 'Bar2',

        '2': 'Foo2',

    }

    card2.store()

    BlockDef.wipe()

    block = BlockDef()

    block.name = 'foobar'

    block.fields = [

        fields.StringField(id='123', required=True, label='Test', type='string'),

        fields.ItemField(id='456', label='card field', type='item', data_source={'type': 'carddef:foo'}),

    ]

    block.store()

    FormDef.wipe()

    formdef = FormDef()

    formdef.name = 'form-title'

    formdef.fields = [

        fields.BlockField(id='8', label='Block', type='block:foobar', varname='data', max_items=3),

    ]

    formdef.workflow_roles = {'_receiver': role.id}

    formdef.store()

    data_class = formdef.data_class()

    data_class.wipe()

    formdata1 = data_class()

    formdata1.data = {

        '8': {

            'data': [{'123': 'blah', '456': card.id, '456_display': card.default_digest}],

            'schema': {},  # not important here

        },

        '8_display': 'blah',

    }

    formdata1.just_created()

    formdata1.jump_status('new')

    formdata1.store()

    formdata2 = data_class()

    formdata2.data = {

        '8': {

            'data': [{'123': 'blah', '456': card2.id, '456_display': card2.default_digest}],

            'schema': {},  # not important here

        },

        '8_display': 'blah',

    }

    formdata2.just_created()

    formdata2.jump_status('new')

    formdata2.store()

    formdata3 = data_class()

    formdata3.data = {

        '8': {

            'data': [{'123': 'blah'}],

            'schema': {},  # not important here

        },

        '8_display': 'blah',

    }

    formdata3.just_created()

    formdata3.jump_status('new')

    formdata3.store()

    # XXX ordering is done on card id, to be fixed with #60742

    app = login(get_app(pub))

    resp = app.get('/backoffice/management/form-title/?order_by=f8-456')

    ids = [int(x.strip('/')) for x in re.findall(r'data-link="(.*?)"', resp.text)]

    assert ids == [formdata1.id, formdata2.id, formdata3.id]

    resp = app.get('/backoffice/management/form-title/?order_by=-f8-456')

    ids = [int(x.strip('/')) for x in re.findall(r'data-link="(.*?)"', resp.text)]

    assert ids == [formdata3.id, formdata2.id, formdata1.id]