"""Settings - Application configuration."""
from flask import Blueprint, render_template, request, jsonify
import sqlite3
import sys
import os
sys.path.insert(0, os.path.dirname(os.path.dirname(__file__)))
from core import get_db, roles_required, audit_event, __version__

bp = Blueprint('settings', __name__)


@bp.route('/settings')
@roles_required('admin')
def index():
    """Settings page."""
    conn = get_db()
    
    # Get all settings
    rows = conn.execute("SELECT key, value FROM settings").fetchall()
    settings = {row['key']: row['value'] for row in rows}
    
    conn.close()
    
    return render_template('settings.html', settings=settings, version=__version__)


@bp.route('/api/settings')
@roles_required('admin')
def api_get_settings():
    """Get all settings."""
    conn = get_db()
    rows = conn.execute("SELECT key, value FROM settings").fetchall()
    settings = {row['key']: row['value'] for row in rows}
    conn.close()
    
    return jsonify(settings)


@bp.route('/api/settings', methods=['POST'])
@roles_required('admin')
def api_update_settings():
    """Update settings."""
    data = request.get_json(silent=True) or {}
    allowed = {'company_name', 'currency_symbol'}
    if not data or any(key not in allowed for key in data):
        return jsonify(error='Unknown setting.'), 400
    if any(not isinstance(value, str) or len(value) > 100 for value in data.values()):
        return jsonify(error='Invalid setting value.'), 400
    if 'currency_symbol' in data and data['currency_symbol'] not in ('$', '€', '£'):
        return jsonify(error='Unsupported currency symbol.'), 400
    
    conn = get_db()
    cursor = conn.cursor()
    
    for key, value in data.items():
        cursor.execute("INSERT OR REPLACE INTO settings (key, value) VALUES (?, ?)", 
                      (key, str(value)))
    
    audit_event('configuration.updated', 'configuration', 'general', 'keys=' + ','.join(sorted(data)), conn)
    conn.commit()
    conn.close()
    
    return jsonify({'message': 'Settings updated'})


@bp.route('/api/settings/reset', methods=['POST'])
@roles_required('admin')
def api_reset_settings():
    """Reset all settings to defaults."""
    conn = get_db()
    conn.execute("DELETE FROM settings")
    audit_event('configuration.reset', 'configuration', 'general', 'all keys removed', conn)
    conn.commit()
    conn.close()
    
    return jsonify({'message': 'Settings reset'})
