from rest_framework.views import APIView
from rest_framework.response import Response
from rest_framework import status
from django.db.models import Count, Sum
from django.utils import timezone
from .models import EmailRecord, EmailAgent, EmailCampaign, EmailType
from .serializers import (EmailRecordSerializer, EmailAgentSerializer,
                           EmailCampaignSerializer, EmailTypeSerializer)


class EmailDashboardView(APIView):
    def get(self, request):
        today = timezone.now().date()
        total = EmailRecord.objects.using('email_db').count()
        today_count = EmailRecord.objects.using('email_db').filter(created_2__date=today).count()
        total_refund = EmailRecord.objects.using('email_db').aggregate(s=Sum('refund'))['s'] or 0
        today_refund = EmailRecord.objects.using('email_db').filter(created_2__date=today).aggregate(s=Sum('refund'))['s'] or 0
        agents_count = EmailAgent.objects.using('email_db').count()
        campaigns_count = EmailCampaign.objects.using('email_db').count()

        top_agents = list(
            EmailRecord.objects.using('email_db')
            .values('agent_name')
            .annotate(total=Count('id'))
            .order_by('-total')[:5]
        )
        top_campaigns = list(
            EmailRecord.objects.using('email_db')
            .values('campaign')
            .annotate(total=Count('id'))
            .order_by('-total')[:5]
        )
        latest = EmailRecordSerializer(
            EmailRecord.objects.using('email_db').order_by('-id')[:10], many=True
        ).data

        return Response({
            'total': total,
            'today_count': today_count,
            'total_refund': float(total_refund),
            'today_refund': float(today_refund),
            'agents_count': agents_count,
            'campaigns_count': campaigns_count,
            'top_agents': top_agents,
            'top_campaigns': top_campaigns,
            'latest': latest,
        })


class EmailRecordListView(APIView):
    def get(self, request):
        qs = EmailRecord.objects.using('email_db')
        date_from = request.query_params.get('date_from')
        date_to = request.query_params.get('date_to')
        agent = request.query_params.get('agent')
        campaign = request.query_params.get('campaign')
        search = request.query_params.get('search')

        if date_from:
            qs = qs.filter(created_2__date__gte=date_from)
        if date_to:
            qs = qs.filter(created_2__date__lte=date_to)
        if agent:
            qs = qs.filter(agent_name=agent)
        if campaign:
            qs = qs.filter(campaign=campaign)
        if search:
            qs = qs.filter(order_number__icontains=search)

        summary = qs.aggregate(total=Count('id'), refund=Sum('refund'))
        by_agent = list(qs.values('agent_name').annotate(total=Count('id'), refund_total=Sum('refund')).order_by('-total'))
        by_campaign = list(qs.values('campaign').annotate(total=Count('id'), refund_total=Sum('refund')).order_by('-total'))
        records = EmailRecordSerializer(qs.order_by('-id')[:100], many=True).data

        return Response({
            'summary': {
                'total': summary['total'] or 0,
                'refund': float(summary['refund'] or 0),
            },
            'by_agent': by_agent,
            'by_campaign': by_campaign,
            'records': records,
        })

    def post(self, request):
        import datetime
        data = request.data.copy()
        data['created_1'] = datetime.datetime.now().strftime('%Y-%m-%d %I:%M:%S %p')
        serializer = EmailRecordSerializer(data=data)
        if serializer.is_valid():
            record = EmailRecord(**{k: v for k, v in serializer.validated_data.items()})
            record.save(using='email_db')
            return Response(EmailRecordSerializer(record).data, status=status.HTTP_201_CREATED)
        return Response(serializer.errors, status=status.HTTP_400_BAD_REQUEST)


class EmailAgentListView(APIView):
    def get(self, request):
        search = request.query_params.get('search', '')
        qs = EmailAgent.objects.using('email_db').order_by('agent_name')
        if search:
            qs = qs.filter(agent_name__icontains=search)
        return Response(EmailAgentSerializer(qs, many=True).data)

    def post(self, request):
        name = request.data.get('agent_name', '').strip()
        if not name:
            return Response({'error': 'agent_name required'}, status=400)
        agent = EmailAgent(agent_name=name)
        agent.save(using='email_db')
        return Response(EmailAgentSerializer(agent).data, status=201)


class EmailAgentDetailView(APIView):
    def delete(self, request, pk):
        try:
            agent = EmailAgent.objects.using('email_db').get(agent_id=pk)
            agent.delete(using='email_db')
            return Response(status=status.HTTP_204_NO_CONTENT)
        except EmailAgent.DoesNotExist:
            return Response({'error': 'Not found'}, status=404)


class EmailCampaignListView(APIView):
    def get(self, request):
        qs = EmailCampaign.objects.using('email_db').order_by('camp_name')
        return Response(EmailCampaignSerializer(qs, many=True).data)

    def post(self, request):
        name = request.data.get('camp_name', '').strip()
        if not name:
            return Response({'error': 'camp_name required'}, status=400)
        camp = EmailCampaign(camp_name=name)
        camp.save(using='email_db')
        return Response(EmailCampaignSerializer(camp).data, status=201)


class EmailCampaignDetailView(APIView):
    def delete(self, request, pk):
        try:
            camp = EmailCampaign.objects.using('email_db').get(id=pk)
            camp.delete(using='email_db')
            return Response(status=status.HTTP_204_NO_CONTENT)
        except EmailCampaign.DoesNotExist:
            return Response({'error': 'Not found'}, status=404)


class EmailTypeListView(APIView):
    def get(self, request):
        qs = EmailType.objects.using('email_db').order_by('type_name')
        return Response(EmailTypeSerializer(qs, many=True).data)
