0001-backoffice-consider-visibility-in-total-formdata-cou.patch

Frédéric Péters, 21 octobre 2018 15:55

Voir les différences: en ligne côte à côte

Subject: [PATCH] backoffice: consider visibility in total formdata counts
 (#27483)

 wcs/backoffice/management.py |  2 +-
 wcs/sql.py                   | 12 ++++++++----
 2 files changed, 9 insertions(+), 5 deletions(-)

             if using_postgresql:
                 from wcs import sql
                 actionable_counts = sql.get_actionable_counts(user_roles)
                 total_counts = sql.get_total_counts()
                 total_counts = sql.get_total_counts(user_roles)
             def append_form_entry(formdef):
                 if using_postgresql:

         return counts
     @guard_postgres
     def get_total_counts():
     def get_total_counts(user_roles):
         conn, cur = get_connection_and_cursor()
         criterias = [
             Intersects('concerned_roles_array', user_roles),
+        ]
         where_clauses, parameters, func_clause = parse_clause(criterias)
         statement = '''SELECT formdef_id, COUNT(*)
                          FROM wcs_all_forms
                         WHERE status != 'draft'
                      GROUP BY formdef_id'''
         cur.execute(statement)
                         WHERE %s
                      GROUP BY formdef_id''' % ' AND '.join(where_clauses)
         cur.execute(statement, parameters)
         counts = {str(x): y for x, y in cur.fetchall()}
         conn.commit()
         cur.close()
+    -

Produits Entr'ouvert » w.c.s.