Produits Entr'ouvert » w.c.s.

    # all changes page: admin user can see all changes (depending on permissions)

    resp = resp.click(href='all-changes/')

    assert '(1-6/6)' in resp

    # he can also see changes from other users

    for snapshot in pub.snapshot_class.select():

        snapshot.user_id = other_user.id

        snapshot.store()

    pub.cfg['admin-permissions'] = {}

    pub.write_cfg()

    resp = app.get('/backoffice/studio/all-changes/')

    assert '(1-20/42)' in resp

    resp = resp.click('<!--Next Page-->')

    assert '21-40/42' in resp.text

    resp = resp.click('<!--Next Page-->')

    assert '41-42/42' in resp.text

    user.is_admin = False

    user.store()

    app.get('/backoffice/studio/all-changes/', status=403)

from wcs.qommon import _, misc, pgettext, template

from wcs.qommon.backoffice.listing import pagination_links

class ChangesDirectory(Directory):

    _q_exports = ['']

    def _q_index(self):

        get_response().breadcrumb.append(('all-changes/', pgettext('studio', 'All changes')))

        html_top(pgettext('studio', 'All Changes'))

        limit = misc.get_int_or_400(

            get_request().form.get('limit', get_publisher().get_site_option('default-page-size')) or 20

        )

        offset = misc.get_int_or_400(get_request().form.get('offset', 0))

        backoffice_root = get_publisher().get_backoffice_root()

        object_types = []

        if backoffice_root.is_accessible('workflows'):

            object_types += [Workflow, MailTemplate]

        if backoffice_root.is_accessible('forms'):

            object_types += [NamedDataSource, BlockDef, FormDef]

        if backoffice_root.is_accessible('workflows'):

            object_types += [NamedDataSource]

        if backoffice_root.is_accessible('settings'):

            object_types += [NamedDataSource, NamedWsCall]

        if backoffice_root.is_accessible('cards'):

            object_types += [CardDef]

        object_types = [ot.xml_root_node for ot in object_types]

        objects = []

        links = ''

        if get_publisher().snapshot_class:

            objects = get_publisher().snapshot_class.get_recent_changes(

                object_types=object_types, limit=limit, offset=offset

            )

            total_count = get_publisher().snapshot_class.count_recent_changes(object_types=object_types)

            links = pagination_links(offset, limit, total_count, load_js=False)

        return template.QommonTemplateResponse(

            templates=['wcs/backoffice/changes.html'],

            context={

                'objects': objects,

                'pagination_links': links,

            },

        )

    def is_accessible(self, user):

        return user.is_admin

    _q_exports = ['', 'deprecations', ('logged-errors', 'logged_errors_dir'), ('all-changes', 'changes_dir')]

    changes_dir = ChangesDirectory()

        user = get_request().user

            'show_all_changes': get_publisher().snapshot_class and user and user.is_admin,

    def get_recent_changes(cls, object_types=None, user=None, limit=5, offset=0):

        elements = cls._get_recent_changes(object_types=object_types, user=user, limit=limit, offset=offset)

    def _get_recent_changes(cls, object_types, user=None, limit=5, offset=0):

        clause = [Contains('object_type', object_types)]

        if user is not None:

            clause.append(Equal('user_id', str(user.id)))

        where_clauses, parameters, dummy = parse_clause(clause)

        sql_statement = 'SELECT object_type, object_id, MAX(timestamp) AS m FROM snapshots'

        sql_statement += ' WHERE ' + ' AND '.join(where_clauses)

        sql_statement += ' GROUP BY object_type, object_id ORDER BY m DESC'

        if limit:

            sql_statement += ' LIMIT %(limit)s'

            parameters['limit'] = limit

        if offset:

            sql_statement += ' OFFSET %(offset)s'

            parameters['offset'] = offset

    @classmethod

    def count_recent_changes(cls, object_types):

        conn, cur = get_connection_and_cursor()

        clause = [Contains('object_type', object_types)]

        where_clauses, parameters, dummy = parse_clause(clause)

        sql_statement = 'SELECT COUNT(*) FROM (SELECT object_type, object_id FROM snapshots'

        sql_statement += ' WHERE ' + ' AND '.join(where_clauses)

        sql_statement += ' GROUP BY object_type, object_id) AS s'

        cur.execute(sql_statement, parameters)

        count = cur.fetchone()[0]

        conn.commit()

        cur.close()

        return count

{% extends "wcs/backoffice/base.html" %}

{% load i18n %}

{% block appbar-title %}{% trans "All changes" context 'studio' %}{% endblock %}

{% block content %}

<ul class="objects-list single-links">

  {% for obj in objects %}

  <li>

    <a href="{{ obj.get_admin_url }}">

      {{ obj.name }}

      <span class="extra-info">{{ obj.snapshot_timestamp }}</span>

      <span class="badge">{{ obj.verbose_name }}</span>

    </a>

  </li>

  {% endfor %}

</ul>

{{ pagination_links|safe }}

{% endblock %}

      {% if show_all_changes %}

        <p><a class="all-changes pk-button" href="all-changes/">{% trans "See all changes" %}</a></p>

      {% endif %}