Produits Entr'ouvert » Combo

from .models import TIME_FILTERS, ChartCell, ChartNgCell

class ChartNgPartialForm(ChartFiltersMixin, forms.ModelForm):

    class Meta:

        model = ChartNgCell

        fields = (

            'time_range',

            'time_range_start',

            'time_range_end',

        )

    def __init__(self, *args, **kwargs):

        super().__init__(*args, **kwargs)

        self.fields.update(self.get_filter_fields(self.instance))

        for field in self.fields.values():

            field.required = False

    def clean(self):

        for filter_ in self.instance.statistic.filters:

            if filter_['id'] in self.data:

                self.instance.filter_params[filter_['id']] = self.cleaned_data.get(filter_['id'])

class ChartFiltersForm(ChartFiltersMixin, forms.ModelForm):

    class Meta:

        model = ChartNgCell

        fields = (

            'time_range',

            'time_range_start',

            'time_range_end',

        )

        widgets = {

            'time_range_start': forms.DateInput(attrs={'type': 'date'}, format='%Y-%m-%d'),

            'time_range_end': forms.DateInput(attrs={'type': 'date'}, format='%Y-%m-%d'),

        }

    def __init__(self, *args, **kwargs):

        page = kwargs.pop('page')

        super().__init__(*args, **kwargs)

        self.fields['time_range'].choices = BLANK_CHOICE_DASH + TIME_FILTERS

        chart_cells = list(ChartNgCell.objects.filter(page=page, statistic__isnull=False).order_by('order'))

        if not chart_cells:

            self.fields.clear()

            return

        first_cell = chart_cells[0]

        for field in self._meta.fields:

            self.fields[field].initial = getattr(first_cell, field)

        dynamic_fields = self.get_filter_fields(first_cell)

        dynamic_fields_values = {k: v for k, v in first_cell.filter_params.items()}

        for cell in chart_cells[1:]:

            cell_filter_fields = self.get_filter_fields(cell)

            # keep only common fields

            dynamic_fields = {k: v for k, v in dynamic_fields.items() if k in cell_filter_fields}

            # keep only same value fields

            for field, value in cell.filter_params.items():

                if field in dynamic_fields and value != dynamic_fields_values.get(field):

                    del dynamic_fields[field]

            if cell.time_range != first_cell.time_range:

                for field in self._meta.fields:

                    self.fields.pop(field, None)

            # ensure compatible choices lists

            for field_name, field in cell_filter_fields.items():

                if field_name in dynamic_fields:

                    dynamic_fields[field_name].choices = [

                        x for x in dynamic_fields[field_name].choices if x in field.choices

                    ]

                    if dynamic_fields[field_name].choices == []:

                        del dynamic_fields[field_name]

        self.fields.update(dynamic_fields)

from combo.apps.dataviz.models import TIME_FILTERS, TIME_FILTERS_TEMPLATE

                choices=TIME_FILTERS + TIME_FILTERS_TEMPLATE,

# Generated by Django 2.2.19 on 2022-01-18 10:17

import django.db.models.deletion

from django.db import migrations, models

class Migration(migrations.Migration):

    dependencies = [

        ('data', '0051_link_cell_max_length'),

        ('auth', '0011_update_proxy_permissions'),

        ('dataviz', '0020_auto_20220118_1103'),

    ]

    operations = [

        migrations.CreateModel(

            name='ChartFiltersCell',

            fields=[

                (

                    'id',

                    models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID'),

                ),

                ('placeholder', models.CharField(max_length=20)),

                ('order', models.PositiveIntegerField()),

                ('slug', models.SlugField(blank=True, verbose_name='Slug')),

                (

                    'extra_css_class',

                    models.CharField(

                        blank=True, max_length=100, verbose_name='Extra classes for CSS styling'

                    ),

                ),

                (

                    'template_name',

                    models.CharField(blank=True, max_length=50, null=True, verbose_name='Cell Template'),

                ),

                ('public', models.BooleanField(default=True, verbose_name='Public')),

                (

                    'restricted_to_unlogged',

                    models.BooleanField(default=False, verbose_name='Restrict to unlogged users'),

                ),

                ('last_update_timestamp', models.DateTimeField(auto_now=True)),

                ('groups', models.ManyToManyField(blank=True, to='auth.Group', verbose_name='Groups')),

                ('page', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='data.Page')),

            ],

            options={

                'verbose_name': 'Filters',

            },

        ),

    ]

TIME_FILTERS = [

]

TIME_FILTERS_TEMPLATE = [('range-template', _('Free range (template)'))]

        choices=TIME_FILTERS + TIME_FILTERS_TEMPLATE,

@register_cell_class

class ChartFiltersCell(CellBase):

    title = _('Filters')

    default_template_name = 'combo/chart-filters.html'

    max_one_by_page = True

    class Meta:

        verbose_name = _('Filters')

    @classmethod

    def is_enabled(cls):

        return settings.STATISTICS_PROVIDERS

    def get_cell_extra_context(self, context):

        from .forms import ChartFiltersForm

        ctx = super().get_cell_extra_context(context)

        ctx['form'] = ChartFiltersForm(page=self.page)

        return ctx

{% load i18n %}

{% block cell-content %}

<h2>{{ cell.title }}</h2>

<div>

  {% if form.fields %}

  <form method='get' enctype='multipart/form-data' id='chart-filters'>

    {{ form.as_p }}

    <div class='buttons'>

      <button class='submit-button'>{% trans 'Refresh' %}</button>

    </div>

  </form>

  {% else %}

  <p>

  {% blocktrans trimmed %}

  No filters are available. Note that only filters that are shared between all chart cells will appear. Furthermore, in case they have a value, it must be the same accross all cells.

  {% endblocktrans %}

  </p>

  {% endif %}

</div>

<script>

  $(function () {

    start_field = $('#id_time_range_start');

    end_field = $('#id_time_range_end');

    $('#id_time_range').change(function() {

      if(this.value == 'range') {

        start_field.parent().show();

        end_field.parent().show();

      } else {

        start_field.parent().hide();

        end_field.parent().hide();

      }

    }).change();

    $('#chart-filters').submit(function(e) {

      e.preventDefault();

      $(window).trigger('combo:refresh-graphs');

    });

  });

</script>

{% endblock %}

    var filter_params = $('#chart-filters').serialize();

            "{% url 'combo-dataviz-graph' cell=cell.id %}?width=" + new_width + '&' + filter_params);

  $(window).on('combo:refresh-graphs', function() {

    var filter_params = $('#chart-filters').serialize();

    $('#chart-{{cell.id}}').attr('src',

          "{% url 'combo-dataviz-graph' cell=cell.id %}?width=" + last_width + '&' + filter_params);

  });

from .forms import ChartNgPartialForm

        form = ChartNgPartialForm(request.GET, instance=self.cell)

        if not form.is_valid():

            return self.svg_error(_('Wrong parameters.'))

            chart = form.instance.get_chart(

from combo.apps.dataviz.models import ChartFiltersCell, ChartNgCell, Gauge, Statistic, UnsupportedDataSet

@with_httmock(new_api_mock)

def test_chart_filters_cell(new_api_statistics, app, admin_user, nocache):

    page = Page.objects.create(title='One', slug='index')

    ChartFiltersCell.objects.create(page=page, order=1, placeholder='content')

    app = login(app)

    resp = app.get('/')

    assert 'No filters are available' in resp.text

    # add unconfigured chart

    first_cell = ChartNgCell.objects.create(page=page, order=2, placeholder='content')

    resp = app.get('/')

    assert 'No filters are available' in resp.text

    # add statistics to chart

    first_cell.statistic = Statistic.objects.get(slug='one-serie')

    first_cell.save()

    resp = app.get('/')

    assert len(resp.form.fields) == 7

    assert 'time_range_start' in resp.form.fields

    assert 'time_range_end' in resp.form.fields

    time_range_field = resp.form['time_range']

    assert time_range_field.value == ''

    assert time_range_field.options == [

        ('', True, '---------'),

        ('previous-year', False, 'Previous year'),

        ('current-year', False, 'Current year'),

        ('next-year', False, 'Next year'),

        ('previous-month', False, 'Previous month'),

        ('current-month', False, 'Current month'),

        ('next-month', False, 'Next month'),

        ('previous-week', False, 'Previous week'),

        ('current-week', False, 'Current week'),

        ('next-week', False, 'Next week'),

        ('range', False, 'Free range (date)'),

    ]

    time_interval_field = resp.form['time_interval']

    assert time_interval_field.value == 'month'

    assert time_interval_field.options == [

        ('day', False, 'Day'),

        ('month', True, 'Month'),

        ('year', False, 'Year'),

        ('week', False, 'Week'),

        ('weekday', False, 'Week day'),

    ]

    service_field = resp.form['service']

    assert service_field.value == 'chrono'

    assert service_field.options == [

        ('', False, '---------'),

        ('chrono', True, 'Chrono'),

        ('combo', False, 'Combo'),

    ]

    ou_field = resp.form['ou']

    assert ou_field.value == ''

    assert ou_field.options == [

        ('', True, '---------'),

        ('default', False, 'Default OU'),

        ('other', False, 'Other OU'),

    ]

    # adding new cell with same statistics changes nothing

    cell = ChartNgCell(page=page, order=3, placeholder='content')

    cell.statistic = Statistic.objects.get(slug='one-serie')

    cell.save()

    old_resp = resp

    resp = app.get('/')

    for field in ('time_range', 'time_interval', 'service', 'ou'):

        assert resp.form[field].options == old_resp.form[field].options

    # changing one filter value makes it disappear

    cell.filter_params = {'ou': 'default'}

    cell.save()

    resp = app.get('/')

    assert 'ou' not in resp.form.fields

    for field in ('time_range', 'time_interval', 'service'):

        assert resp.form[field].options == old_resp.form[field].options

    # setting the same value for the other cell makes it appear again

    first_cell.filter_params = {'ou': 'default'}

    first_cell.save()

    resp = app.get('/')

    assert resp.form['ou'].value == 'default'

    # changing statistics type of cell remove some fields

    cell.statistic = Statistic.objects.get(slug='daily')

    cell.save()

    resp = app.get('/')

    assert 'ou' not in resp.form.fields

    assert 'service' not in resp.form.fields

    for field in ('time_range', 'time_interval'):

        assert resp.form[field].options == old_resp.form[field].options

    # changing time_interval value makes interval fields disappear

    cell.time_range = 'next-year'

    cell.save()

    old_resp = resp

    resp = app.get('/')

    assert 'time_range' not in resp.form.fields

    assert 'time_range_start' not in resp.form.fields

    assert 'time_range_end' not in resp.form.fields

    assert resp.form['time_interval'].options == old_resp.form['time_interval'].options

    # setting the same value for the other cell makes it appear again

    first_cell.time_range = 'next-year'

    first_cell.save()

    resp = app.get('/')

    assert resp.form['time_range'].value == 'next-year'

    assert resp.form['time_interval'].options == old_resp.form['time_interval'].options

    # only common choices are shown

    first_cell.statistic.filters[0]['options'].remove({'id': 'day', 'label': 'Day'})

    first_cell.statistic.save()

    resp = app.get('/')

    assert resp.form['time_interval'].options == [

        ('month', True, 'Month'),

        ('year', False, 'Year'),

    ]

    # if no common choices exist, field is removed

    first_cell.statistic.filters[0]['options'] = [{'id': 'random', 'label': 'Random'}]

    first_cell.statistic.save()

    resp = app.get('/')

    assert 'time_interval' not in resp.form.fields

    assert resp.form['time_range'].value == 'next-year'

    # form is not shown if no common filters exist

    first_cell.time_range = 'current-year'

    first_cell.save()

    resp = app.get('/')

    assert 'No filters are available' in resp.text

@with_httmock(new_api_mock)

def test_chartng_cell_api_view_get_parameters(app, normal_user, new_api_statistics, nocache):

    page = Page.objects.create(title='One', slug='index')

    cell = ChartNgCell(page=page, order=1, placeholder='content')

    cell.statistic = Statistic.objects.get(slug='one-serie')

    cell.save()

    location = '/api/dataviz/graph/%s/' % cell.id

    app.get(location)

    request = new_api_mock.call['requests'][0]

    assert 'time_interval=' not in request.url

    assert 'ou=' not in request.url

    cell.filter_params = {'time_interval': 'month', 'ou': 'default'}

    cell.save()

    app.get(location)

    request = new_api_mock.call['requests'][1]

    assert 'time_interval=month' in request.url

    assert 'ou=default' in request.url

    app.get(location + '?time_interval=year')

    request = new_api_mock.call['requests'][2]

    assert 'time_interval=year' in request.url

    assert 'ou=default' in request.url

    cell.filter_params.clear()

    cell.statistic = Statistic.objects.get(slug='filter-multiple')

    cell.save()

    app.get(location + '?color=green&color=blue')

    request = new_api_mock.call['requests'][3]

    assert 'color=green&color=blue' in request.url

    # unknown params

    app.get(location + '?time_interval=month&ou=default')

    request = new_api_mock.call['requests'][4]

    assert 'time_interval=' not in request.url

    assert 'ou=' not in request.url

    # wrong params

    resp = app.get(location + '?time_range_start=xxx')

    assert 'Wrong parameters' in resp.text

    assert len(new_api_mock.call['requests']) == 5

        assert len(ctx.captured_queries) in [308, 309]

        assert len(ctx.captured_queries) == 277

        assert len(ctx.captured_queries) == 71

        assert len(ctx.captured_queries) == 146

        assert len(ctx.captured_queries) == 225