Files

104 lines
3.0 KiB
Python

"""
API Endpunkte für Initialdaten
"""
from flask import Blueprint, jsonify, g, request
from cmbnet.auth import login_required
from cmbnet.db import get_db
from cmbnet.models.accounts import AccountModel
from cmbnet.services.streets_service import StreetsService
from cmbnet.services.groups_service import GroupsService
api_init_bp = Blueprint('api_init', __name__)
@api_init_bp.route('/init/me')
@login_required
def init_me(**kwargs):
account = getattr(g, 'current_account', None)
if not account:
return jsonify({'id': None, 'role': None, 'name': None})
return jsonify({
'id': account['id'],
'role': account['role'],
'name': account['name'],
'tenant_id': account['tenant_id'],
'tenant_code': account['tenant_code']
})
@api_init_bp.route('/init/groups/<int:group_id>/streets')
@login_required
def init_group_streets(group_id, **kwargs):
from cmbnet.services.groups_service import GroupsService
streets = GroupsService.get_streets_for_group(group_id, g.tenant_id)
result = []
for street in streets:
result.append(dict(street))
return jsonify(result)
@api_init_bp.route('/init/accounts')
@login_required
def init_accounts(**kwargs):
"""Liefert alle Accounts für den Tenant (für Senderdarstellung)"""
accounts = AccountModel.get_all_by_tenant(g.tenant_id)
result = []
for account in accounts:
result.append({
'id': account['id'],
'name': account['name'],
'role': account['role']
})
return jsonify(result)
@api_init_bp.route('/init/streets')
@login_required
def init_streets(**kwargs):
"""Liefert alle Straßen für den Initialload"""
streets = StreetsService.get_all_for_init(g.tenant_id)
return jsonify(streets)
@api_init_bp.route('/init/groups')
@login_required
def init_groups(**kwargs):
"""Liefert alle Gruppen für den Initialload (aus Cache)"""
groups_dict = GroupsService.get_all(g.tenant_id)
groups_list = list(groups_dict.values())
return jsonify(groups_list)
@api_init_bp.route('/init/hausnummern')
@login_required
def init_house_number(**kwargs):
"""Liefert die Koordinate einer Hausnummer aus der importierten Tabelle."""
street_name = (request.args.get('street') or '').strip()
house_number = (
request.args.get('house_number')
or request.args.get('number')
or ''
).strip()
if not street_name or not house_number:
return jsonify({'found': False})
row = get_db().execute(
'''SELECT street_name, house_number, longitude, latitude
FROM street_house_numbers
WHERE tenant_id = ? AND street_name = ? AND house_number = ?
LIMIT 1''',
(g.tenant_id, street_name, house_number)
).fetchone()
if not row:
return jsonify({'found': False})
return jsonify({
'found': True,
'street_name': row['street_name'],
'house_number': row['house_number'],
'longitude': row['longitude'],
'latitude': row['latitude']
})