e18c7c2d87
System Settings: - Add SystemSettings.vue with Zabbix integration, SMTP/email config, SAML SSO settings - Add Setting model with key-value storage and typed values - Add settings API with caching Audit Logging: - Add AuditLog model tracking user, IP, action, entity changes - Add comprehensive audit logging to all CRUD operations: - Machines, Computers, Equipment, Network devices, VLANs, Subnets - Printers, USB devices (including checkout/checkin) - Applications, Settings, Users/Roles - Track old/new values for all field changes - Mask sensitive values (passwords, tokens) in logs User Management: - Add UsersList.vue with full user CRUD - Add Role management with granular permissions - Add 41 predefined permissions across 10 categories - Add users API with roles and permissions endpoints Reports: - Add TonerReport.vue for printer supply monitoring Dark Mode Fixes: - Fix map position section in PCForm, PrinterForm - Fix alert-warning in KnowledgeBaseDetail - All components now use CSS variables for theming CLI Commands: - Add flask seed permissions - Add flask seed settings Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
74 lines
2.8 KiB
Python
74 lines
2.8 KiB
Python
"""System settings model for key-value configuration storage."""
|
|
|
|
from datetime import datetime
|
|
from shopdb.extensions import db
|
|
|
|
|
|
class Setting(db.Model):
|
|
"""
|
|
Key-value store for system settings.
|
|
|
|
Settings can be managed via the admin UI and are cached
|
|
for performance.
|
|
"""
|
|
__tablename__ = 'settings'
|
|
|
|
settingid = db.Column(db.Integer, primary_key=True, autoincrement=True)
|
|
key = db.Column(db.String(100), unique=True, nullable=False, index=True)
|
|
value = db.Column(db.Text, nullable=True)
|
|
valuetype = db.Column(db.String(20), default='string') # string, boolean, integer, json
|
|
category = db.Column(db.String(50), default='general') # For grouping in UI
|
|
description = db.Column(db.String(255), nullable=True)
|
|
createddate = db.Column(db.DateTime, default=datetime.utcnow)
|
|
modifieddate = db.Column(db.DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
|
|
|
|
def to_dict(self):
|
|
return {
|
|
'settingid': self.settingid,
|
|
'key': self.key,
|
|
'value': self.get_typed_value(),
|
|
'valuetype': self.valuetype,
|
|
'category': self.category,
|
|
'description': self.description,
|
|
'createddate': self.createddate.isoformat() + 'Z' if self.createddate else None,
|
|
'modifieddate': self.modifieddate.isoformat() + 'Z' if self.modifieddate else None,
|
|
}
|
|
|
|
def get_typed_value(self):
|
|
"""Return value converted to its proper type."""
|
|
if self.value is None:
|
|
return None
|
|
if self.valuetype == 'boolean':
|
|
return self.value.lower() in ('true', '1', 'yes')
|
|
if self.valuetype == 'integer':
|
|
try:
|
|
return int(self.value)
|
|
except (ValueError, TypeError):
|
|
return 0
|
|
return self.value
|
|
|
|
@classmethod
|
|
def get(cls, key: str, default=None):
|
|
"""Get a setting value by key."""
|
|
setting = cls.query.filter_by(key=key).first()
|
|
if setting:
|
|
return setting.get_typed_value()
|
|
return default
|
|
|
|
@classmethod
|
|
def set(cls, key: str, value, valuetype: str = 'string', category: str = 'general', description: str = None):
|
|
"""Set a setting value, creating if it doesn't exist."""
|
|
setting = cls.query.filter_by(key=key).first()
|
|
if not setting:
|
|
setting = cls(key=key, valuetype=valuetype, category=category, description=description)
|
|
db.session.add(setting)
|
|
|
|
# Convert value to string for storage
|
|
if isinstance(value, bool):
|
|
setting.value = 'true' if value else 'false'
|
|
else:
|
|
setting.value = str(value) if value is not None else None
|
|
|
|
db.session.commit()
|
|
return setting
|