Files
2026-11-06 10:26:13 +01:00

29 lines
777 B
Python

"""
Straßenverwaltung
"""
from flask import Blueprint, render_template, g
from cmbnet.auth import role_required
from cmbnet.db import get_db
admin_strassen_bp = Blueprint('admin_strassen', __name__)
@admin_strassen_bp.route('/strassen')
@role_required('Administrator')
def strassen(**kwargs):
"""Straßenverwaltung"""
db = get_db()
strassen = db.execute(
'SELECT * FROM streets WHERE tenant_id = ? ORDER BY name, zusatz',
(g.tenant_id,)
).fetchall()
house_number_count = db.execute(
'SELECT COUNT(*) FROM street_house_numbers WHERE tenant_id = ?',
(g.tenant_id,)
).fetchone()[0]
return render_template(
'admin/strassen.html',
strassen=strassen,
house_number_count=house_number_count
)