50 lines
2.7 KiB
Python
50 lines
2.7 KiB
Python
"""Validated, paginated access decision queries (no configuration mutations)."""
|
|
from zoneinfo import ZoneInfo
|
|
|
|
from rest_framework import serializers
|
|
|
|
|
|
class DecisionQuery(serializers.Serializer):
|
|
page = serializers.IntegerField(min_value=1, default=1)
|
|
page_size = serializers.IntegerField(min_value=1, max_value=100, default=20)
|
|
start_time = serializers.DateTimeField(required=False, default_timezone=ZoneInfo('Asia/Shanghai'))
|
|
end_time = serializers.DateTimeField(required=False, default_timezone=ZoneInfo('Asia/Shanghai'))
|
|
result = serializers.ChoiceField(choices=['allowed', 'denied'], required=False, allow_blank=True)
|
|
ip = serializers.CharField(required=False, allow_blank=True, max_length=128)
|
|
device_type = serializers.ChoiceField(
|
|
choices=['桌面端', '移动终端', '平板', '服务器', '未知'], required=False, allow_blank=True)
|
|
reason = serializers.CharField(required=False, allow_blank=True, max_length=200)
|
|
denied = serializers.BooleanField(required=False)
|
|
|
|
def validate(self, data):
|
|
if data.get('start_time') and data.get('end_time') and data['start_time'] > data['end_time']:
|
|
raise serializers.ValidationError({'end_time': '结束时间不能早于开始时间'})
|
|
return data
|
|
|
|
|
|
def list_decisions(params):
|
|
from system_manage.models.log_management import Log
|
|
|
|
serializer = DecisionQuery(data=params)
|
|
serializer.is_valid(raise_exception=True)
|
|
filters = serializer.validated_data
|
|
query = Log.objects.filter(menu='接入控制', operate__in=['允许访问', '拒绝访问'])
|
|
outcome = filters.get('result') or ('denied' if filters.get('denied') else '')
|
|
if outcome:
|
|
query = query.filter(status=403 if outcome == 'denied' else 200)
|
|
for key, lookup in [('start_time', 'create_time__gte'), ('end_time', 'create_time__lte'),
|
|
('ip', 'ip_address__icontains'), ('device_type', 'details__device_type'),
|
|
('reason', 'details__reason__icontains')]:
|
|
if filters.get(key):
|
|
query = query.filter(**{lookup: filters[key]})
|
|
total = query.count()
|
|
size = filters['page_size']
|
|
page = min(filters['page'], max(1, (total + size - 1) // size))
|
|
rows = query.order_by('-create_time', '-id')[(page - 1) * size:page * size]
|
|
return {'total': total, 'current': page, 'page_size': size, 'records': [
|
|
{'id': str(item.id), 'time': item.create_time, 'status': item.status,
|
|
'ip': item.ip_address, 'target': (item.operation_object or {}).get('target'),
|
|
'device_type': (item.details or {}).get('device_type', '未知'),
|
|
'reason': (item.details or {}).get('reason', '')}
|
|
for item in rows]}
|