from django.shortcuts import redirect, render
from django.views.generic import TemplateView
from visitors.models.researchSupervision import ResearchSupervision
from django.views.generic import  ListView
from django.core import serializers
'''
class ResearchSupervisionListView(ListView):
    model = ResearchSupervision
    ordering = ('name', )
    context_object_name = 'researchSupervision'
    template_name = 'research-supervision.html'

    def get_queryset(self, **kwargs):
        
        queryset = ResearchSupervision.objects.filter()
        phdAwarded = ResearchSupervision.objects.filter(group_type=1).filter(process_type=1).count()
        phdSubmitted = ResearchSupervision.objects.filter(group_type=1).filter(process_type=2).count()
        phdInProgress = ResearchSupervision.objects.filter(group_type=1).filter(process_type=3).count()
        mtechAwarded = ResearchSupervision.objects.filter(group_type=2).filter(process_type=1).count()
        mtechSubmitted = ResearchSupervision.objects.filter(group_type=2).filter(process_type=2).count()
        mtechInProgress = ResearchSupervision.objects.filter(group_type=2).filter(process_type=3).count()

        qs_json = serializers.serialize('json', queryset)
        return queryset
        '''

def home(request):
    researchSupervision = ResearchSupervision.objects.filter().order_by('-year_end')
    phdAwarded = ResearchSupervision.objects.filter(group_type=1).filter(process_type=1).count()
    phdInProgress = ResearchSupervision.objects.filter(group_type=1).filter(process_type=2).count()
    phdSubmitted = ResearchSupervision.objects.filter(group_type=1).filter(process_type=3).count()
    mtechAwarded = ResearchSupervision.objects.filter(group_type=2).filter(process_type=1).count()
    mtechInProgress = ResearchSupervision.objects.filter(group_type=2).filter(process_type=2).count()
    mtechSubmitted = ResearchSupervision.objects.filter(group_type=2).filter(process_type=3).count()

    context = {'researchSupervision' : researchSupervision, 'phdAwarded' : phdAwarded, 'phdSubmitted':phdSubmitted, 
    'phdInProgress':phdInProgress, 'mtechAwarded':mtechAwarded,'mtechSubmitted':mtechSubmitted,
    'mtechInProgress':mtechInProgress}
    return render(request, 'research-supervision.html', context=context)