| 12345678910111213141516171819 |
- """One authorized projection for list results and dashboard aggregates."""
- from sqlalchemy import text
- from .jinja_templates import templates
- def read_invoices(db, username, clauses=(), values=None):
- query = templates.env.get_template('forderungen/liste/queries/forderungen_liste.sql').render()
- if clauses:
- query = query.replace('AND 1 = 1', 'AND 1 = 1 AND ' + ' AND '.join(clauses))
- result = db.execute(text(query).execution_options(query_name='forderungen/liste/queries/forderungen_liste.sql'), dict(values or {}, auth_username=username))
- columns = list(result.keys())
- tenant, number = columns.index('Client_DB'), columns.index('Beleg_Nr')
- seen, rows = set(), []
- for row in result.fetchall():
- identity = (str(row[tenant]), str(row[number]))
- if identity not in seen:
- rows.append(row)
- seen.add(identity)
- return columns, rows
|