MIS Reports Part1

6 files changed, 419 insertions, 62 deletions

diff --git a/gnowsys-ndf/gnowsys_ndf/ndf/templates/ndf/mis_list.html b/gnowsys-ndf/gnowsys_ndf/ndf/templates/ndf/mis_list.html
index e54e717..bdc109d 100644
--- a/gnowsys-ndf/gnowsys_ndf/ndf/templates/ndf/mis_list.html
+++ b/gnowsys-ndf/gnowsys_ndf/ndf/templates/ndf/mis_list.html
@@ -114,6 +114,9 @@
 
 {% block body_content %} 
   {% if title == "MIS" %}
+  <div>
+    <a href="{% url 'mis:get_mis_reports' group_id %}">REPORTS</a>
+ </div>
 
   <div class="row">
     <div class="small-12 small-centered columns">
diff --git a/gnowsys-ndf/gnowsys_ndf/ndf/urls/ajax-urls.py b/gnowsys-ndf/gnowsys_ndf/ndf/urls/ajax-urls.py
index 2ef79d6..5c84522 100644
--- a/gnowsys-ndf/gnowsys_ndf/ndf/urls/ajax-urls.py
+++ b/gnowsys-ndf/gnowsys_ndf/ndf/urls/ajax-urls.py
@@ -43,6 +43,7 @@ urlpatterns = patterns('gnowsys_ndf.ndf.views.ajax_views',
 
                        # Ajax-urls required for MIS --------------------------------
                        
+    url(r'^get_universities/', 'get_universities', name='get_universities'),
     url(r'^get_students_for_batches/', 'get_students_for_batches', name='get_students_for_batches'),
     url(r'^get_anncourses_allstudents/', 'get_anncourses_allstudents', name='get_anncourses_allstudents'),
     url(r'^get_courses/', 'get_courses', name='get_courses'),
diff --git a/gnowsys-ndf/gnowsys_ndf/ndf/urls/mis.py b/gnowsys-ndf/gnowsys_ndf/ndf/urls/mis.py
index 18c7976..c7f8837 100644
--- a/gnowsys-ndf/gnowsys_ndf/ndf/urls/mis.py
+++ b/gnowsys-ndf/gnowsys_ndf/ndf/urls/mis.py
@@ -2,6 +2,8 @@ from django.conf.urls import patterns, url
 
 urlpatterns = patterns('gnowsys_ndf.ndf.views.mis',
   url(r'^[/]$', 'mis_detail', name='mis'),
+  url(r'^/reports/$', 'get_mis_reports', name='get_mis_reports'),
+  # url(r'^/reports/data$', 'get_paged_reports_data', name='get_paged_reports_data'),
   url(r'^/(?P<app_id>[\w-]+)$', 'mis_detail', name='mis_list'),  # MIS app landing
   url(r'^/(?P<app_id>[\w-]+)/(?P<app_set_id>[\w-]+)$', 'mis_detail', name='mis_app_detail'),  # mis_app_detail
   url(r'^/(?P<app_id>[\w-]+)/(?P<app_set_id>[\w-]+)/enroll/(?P<app_set_instance_id>[\w-]+)$', 'mis_enroll', name='mis_enroll'),  # Person enrollment in Courses link
diff --git a/gnowsys-ndf/gnowsys_ndf/ndf/views/ajax_views.py b/gnowsys-ndf/gnowsys_ndf/ndf/views/ajax_views.py
index 98a1e73..f37a8ec 100644
--- a/gnowsys-ndf/gnowsys_ndf/ndf/views/ajax_views.py
+++ b/gnowsys-ndf/gnowsys_ndf/ndf/views/ajax_views.py
@@ -3028,6 +3028,7 @@ def get_students_assignments(request, group_id):
     print "\n StudentDataGetError: " + str(e)
     raise Http404(e)
 
+@login_required
 @get_execution_time
 def get_districts(request, group_id):
   """
@@ -3084,6 +3085,8 @@ def get_districts(request, group_id):
     error_message = "\n DistrictFetchError: " + str(e) + "!!!"
     return HttpResponse(json.dumps({'message': error_message}))
 
+
+@login_required
 @get_execution_time
 def get_affiliated_colleges(request, group_id):
   """
@@ -3111,25 +3114,29 @@ def get_affiliated_colleges(request, group_id):
       university_id = request.GET.get("university_id", "")
       req_university = None
       req_affiliated_colleges = None
-
+      colg_gst = node_collection.one({'_type': "GSystemType", 'name': "College"})
       # Check whether any field has missing value or not
       if university_id == "":
         error_message = "AffiliatedCollegeFindError: Invalid data (No university selected)!!!"
         raise Exception(error_message)
 
-      # Type-cast fetched field(s) into their appropriate type
-      university_id = ObjectId(university_id)
+      if university_id == "ALL":
+        req_affiliated_colleges = node_collection.find({'member_of': colg_gst._id}, {'name': 1}).sort('name', 1)
 
-      # Fetch required university
-      req_university = node_collection.one({'_id': university_id})
+      else:
+        # Type-cast fetched field(s) into their appropriate type
+        university_id = ObjectId(university_id)
 
-      if not req_university:
-        error_message = "AffiliatedCollegeFindError: No university exists with given ObjectId("+university_id+")!!!"
-        raise Exception(error_message)
+        # Fetch required university
+        req_university = node_collection.one({'_id': university_id})
+
+        if not req_university:
+          error_message = "AffiliatedCollegeFindError: No university exists with given ObjectId("+university_id+")!!!"
+          raise Exception(error_message)
 
-      for each in req_university["relation_set"]:
-        if u"affiliated_college" in each.keys():
-          req_affiliated_colleges = node_collection.find({'_id': {'$in': each[u"affiliated_college"]}}, {'name': 1}).sort('name', 1)
+        for each in req_university["relation_set"]:
+          if u"affiliated_college" in each.keys():
+            req_affiliated_colleges = node_collection.find({'_id': {'$in': each[u"affiliated_college"]}}, {'name': 1}).sort('name', 1)
       
       req_affiliated_colleges_list = []
       for each in req_affiliated_colleges:
@@ -5470,3 +5477,67 @@ def get_batches_with_acourse(request, group_id):
   except Exception as e:
     error_message = "\n BatchFetchError: " + str(e) + "!!!"
     return HttpResponse(json.dumps({'message': error_message}))
+
+
+@login_required
+@get_execution_time
+def get_universities(request, group_id):
+    """
+    This view fetches Universities belonging to given state.
+
+    Arguments:
+    group_id - ObjectId of the currently selected group
+    state_id - ObjectId of the currently selected state`
+
+    Returns:
+    A dictionary consisting of following key:-
+    universities - a list variable consisting of two elements i.e.,
+                first-element: University's ObjectId,
+                second-element:University's name
+    message - a string variable giving the error-message
+    """
+
+    try:
+        if request.is_ajax() and request.method == "GET":
+            state_id = request.GET.get("state_id", "")
+
+            # universities -- [first-element: subject (University's ObjectId),
+            # second-element: manipulated-name-value (University's name)]
+            universities = []
+            univ_gst = node_collection.one({'_type': "GSystemType", 'name': "University"})
+            mis_admin_grp = node_collection.one({'_type': "Group", 'name': "MIS_admin"})
+
+            if state_id == "ALL":
+                # Fetching all universities belonging to given state in sorted order by name
+                university_cur = node_collection.find(
+                    {
+                        'member_of': univ_gst._id,
+                        'group_set': mis_admin_grp._id,
+                    }).sort('name', 1)
+
+            else:
+                # Fetching all universities belonging to given state in sorted order by name
+                university_cur = node_collection.find(
+                    {
+                        'member_of': univ_gst._id,
+                        'group_set': mis_admin_grp._id,
+                        'relation_set.organization_belongs_to_state': ObjectId(state_id)
+                    }).sort('name', 1)
+
+            if university_cur.count():
+                for d in university_cur:
+                    universities.append([str(d._id), d.name])
+
+            else:
+                error_message = "No University found for the selected State"
+                raise Exception(error_message)
+
+            return HttpResponse(json.dumps(universities))
+
+        else:
+            error_message = " UniversityFetchError: Either not an ajax call or not a GET request!!!"
+            return HttpResponse(json.dumps({'message': " UniversityFetchError - Something went wrong in ajax call !!! \n\n Please contact system administrator."}))
+
+    except Exception as e:
+        error_message = str(e)
+        return HttpResponse(json.dumps({'message': error_message}))
diff --git a/gnowsys-ndf/gnowsys_ndf/ndf/views/methods.py b/gnowsys-ndf/gnowsys_ndf/ndf/views/methods.py
index 08db095..a77e04d 100644
--- a/gnowsys-ndf/gnowsys_ndf/ndf/views/methods.py
+++ b/gnowsys-ndf/gnowsys_ndf/ndf/views/methods.py
@@ -605,7 +605,7 @@ def get_node_common_fields(request, node, group_id, node_type, coll_set=None):
     else:
         name = request.POST.get('name', '').strip()
         content_org = request.POST.get('content_org')
-        tags = request.POST.get('tags')
+        tags = request.POST.get('tags','')
         # print "tags: --------- ", tags
 
     language = request.POST.get('lan')
diff --git a/gnowsys-ndf/gnowsys_ndf/ndf/views/mis.py b/gnowsys-ndf/gnowsys_ndf/ndf/views/mis.py
index 47d6192..4d68d8a 100644
--- a/gnowsys-ndf/gnowsys_ndf/ndf/views/mis.py
+++ b/gnowsys-ndf/gnowsys_ndf/ndf/views/mis.py
@@ -7,28 +7,30 @@ import datetime
 ''' -- imports from installed packages -- '''
 from django.http import HttpResponseRedirect
 from django.http import HttpResponse
-from django.shortcuts import render_to_response #, render  uncomment when to use
+from django.shortcuts import render_to_response  # , render  uncomment when to use
 from django.template import RequestContext
 from django.template.defaultfilters import slugify
 from django.core.urlresolvers import reverse
-
 from django.contrib.auth.models import User
 from django.contrib.auth.decorators import login_required
+# from mongokit import paginator
 
 try:
     from bson import ObjectId
 except ImportError:  # old pymongo
     from pymongo.objectid import ObjectId
-
 ''' -- imports from application folders/files -- '''
 from gnowsys_ndf.ndf.org2any import org2html
+from gnowsys_ndf.ndf.models import NodeJSONEncoder
 from gnowsys_ndf.ndf.models import node_collection, triple_collection
 from gnowsys_ndf.ndf.views.organization import *
 from gnowsys_ndf.ndf.views.course import *
 from gnowsys_ndf.ndf.views.person import *
 from gnowsys_ndf.ndf.views.enrollment import *
+from gnowsys_ndf.ndf.views.methods import get_group_name_id, cast_to_data_type
 from gnowsys_ndf.ndf.views.methods import get_execution_time
 
+
 @login_required
 @get_execution_time
 def mis_detail(request, group_id, app_id=None, app_set_id=None, app_set_instance_id=None, app_name=None):
@@ -37,18 +39,18 @@ def mis_detail(request, group_id, app_id=None, app_set_id=None, app_set_instance
     """
 
     auth = None
-    if ObjectId.is_valid(group_id) is False :
-      group_ins = node_collection.one({'_type': "Group","name": group_id})
-      auth = node_collection.one({'_type': 'Author', 'name': unicode(request.user.username) })
-      if group_ins:
-        group_id = str(group_ins._id)
-      else :
-        auth = node_collection.one({'_type': 'Author', 'name': unicode(request.user.username) })
-        if auth :
-          group_id = str(auth._id)
-    else :
-      pass
-
+    # if ObjectId.is_valid(group_id) is False :
+    #   group_ins = node_collection.one({'_type': "Group","name": group_id})
+    #   auth = node_collection.one({'_type': 'Author', 'name': unicode(request.user.username) })
+    #   if group_ins:
+    #     group_id = str(group_ins._id)
+    #   else :
+    #     auth = node_collection.one({'_type': 'Author', 'name': unicode(request.user.username) })
+    #     if auth :
+    #       group_id = str(auth._id)
+    # else :
+    #   pass
+    group_name, group_id = get_group_name_id(group_id)
     app = None
     if app_id is None:
       app = node_collection.one({'_type': "GSystemType", 'name': app_name})
@@ -57,12 +59,12 @@ def mis_detail(request, group_id, app_id=None, app_set_id=None, app_set_instance
     else:
       app = node_collection.one({'_id': ObjectId(app_id)})
 
-    app_name = app.name 
+    app_name = app.name
 
-    app_collection_set = [] 
+    app_collection_set = []
     atlist = []
     rtlist = []
-    
+
     app_set = ""
     nodes = ""
     # nodes_dict = ""
@@ -213,15 +215,16 @@ def mis_detail(request, group_id, app_id=None, app_set_id=None, app_set_instance
         system.get_neighbourhood(systemtype._id)
 
         # array of dict for events ---------------------
-                
-        if system.has_key('organiser_of_event') and len(system.organiser_of_event): # gives list of events
+
+        # if system.has_key('organiser_of_event') and len(system.organiser_of_event): # gives list of events
+        if 'organiser_of_event' in system and len(system.organiser_of_event): # gives list of events
 
             for event in system.organiser_of_event:
                 event.get_neighbourhood(event.member_of)
-                
+
                 tempdict = {}
                 tempdict['title'] = event.name
-                
+
                 if event.start_time:# and len(event.start_time) == 16:
                     # print "\n start_time: ", event.start_time, " -- ", event.start_time.strftime('%m/%d/%Y %H:%M')
                     # dt = datetime.datetime.strptime(event.start_time , '%m/%d/%Y %H:%M')
@@ -235,7 +238,8 @@ def mis_detail(request, group_id, app_id=None, app_set_id=None, app_set_instance
                 tempdict['id'] = str(event._id)
                 events_arr.append(tempdict)
 
-        elif system.has_key('event_organised_by'): # gives list of colleges/host of events
+        # elif system.has_key('event_organised_by'): # gives list of colleges/host of events
+        elif 'event_organised_by' in system:  # gives list of colleges/host of events
 
             for host in system.event_organised_by:
                 host.get_neighbourhood(host.member_of)
@@ -335,17 +339,18 @@ def mis_create_edit(request, group_id, app_id, app_set_id=None, app_set_instance
     create new instance of app_set of apps view for custom GAPPS
     """
     auth = None
-    if ObjectId.is_valid(group_id) is False :
-      group_ins = node_collection.one({'_type': "Group","name": group_id})
-      auth = node_collection.one({'_type': 'Author', 'name': unicode(request.user.username) })
-      if group_ins:
-        group_id = str(group_ins._id)
-      else :
-        auth = node_collection.one({'_type': 'Author', 'name': unicode(request.user.username) })
-        if auth :
-          group_id = str(auth._id)
-    else :
-      pass
+    group_name, group_id = get_group_name_id(group_id)
+    # if ObjectId.is_valid(group_id) is False :
+    #   group_ins = node_collection.one({'_type': "Group","name": group_id})
+    #   auth = node_collection.one({'_type': 'Author', 'name': unicode(request.user.username) })
+    #   if group_ins:
+    #     group_id = str(group_ins._id)
+    #   else :
+    #     auth = node_collection.one({'_type': 'Author', 'name': unicode(request.user.username) })
+    #     if auth :
+    #       group_id = str(auth._id)
+    # else :
+    #   pass
 
     app = None
     if app_id is None:
@@ -355,10 +360,10 @@ def mis_create_edit(request, group_id, app_id, app_set_id=None, app_set_instance
     else:
       app = node_collection.one({'_id': ObjectId(app_id)})
 
-    app_name = app.name 
+    app_name = app.name
 
     # app_name = "mis"
-    app_collection_set = [] 
+    app_collection_set = []
     # app = node_collection.find_one({"_id":ObjectId(app_id)})
     app_set = ""
     app_set_instance_name = ""
@@ -483,7 +488,6 @@ def mis_create_edit(request, group_id, app_id, app_set_id=None, app_set_instance
         app_set_instance_name = system.name
         title =  system.name+"-"+"edit"
 
-        
     if request.method=="POST": # post methods
         tags = request.POST.get("tags","")
         content_org = unicode(request.POST.get("content_org",""))
@@ -498,7 +502,7 @@ def mis_create_edit(request, group_id, app_id, app_set_id=None, app_set_instance
         for eachrtset in systemtype_relationtype_set:
             if request.POST.get(eachrtset["type_id"],""):
                 request_rt_dict[eachrtset["type_id"]] = request.POST.get(eachrtset["type_id"],"")
-        
+
         if File == 'True':
             if file1:
                 f = save_file(file1, name, request.user.id, group_id, content_org, tags)
@@ -512,22 +516,22 @@ def mis_create_edit(request, group_id, app_id, app_set_id=None, app_set_instance
                 newgsystem = node_collection.collection.File()
         else:
             newgsystem = node_collection.collection.GSystem()
-        if app_set_instance_id :
+        if app_set_instance_id:
             newgsystem = node_collection.find_one({"_id": ObjectId(app_set_instance_id)})
 
         newgsystem.name = name
-        newgsystem.member_of=[ObjectId(app_set_id)]
-        
-        if not app_set_instance_id :
+        newgsystem.member_of = [ObjectId(app_set_id)]
+
+        if not app_set_instance_id:
             newgsystem.created_by = request.user.id
-        
+
         newgsystem.modified_by = request.user.id
         newgsystem.status = u"PUBLISHED"
 
         newgsystem.group_set.append(ObjectId(group_id))
 
         if tags:
-             newgsystem.tags = tags.split(",")
+            newgsystem.tags = tags.split(",")
 
         if content_org:
             usrname = request.user.username
@@ -548,7 +552,7 @@ def mis_create_edit(request, group_id, app_id, app_set_id=None, app_set_instance
 
         # check if user_group_location exist in proper format then add it into newgsystem
         if user_last_visited_location:
-    
+
             user_last_visited_location = list(ast.literal_eval(user_last_visited_location))
 
             author = node_collection.one({'_type': "GSystemType", 'name': "Author"})
@@ -560,8 +564,8 @@ def mis_create_edit(request, group_id, app_id, app_set_id=None, app_set_instance
 
         newgsystem.save()
 
-        if not app_set_instance_id :
-            for key,value in request_at_dict.items():
+        if not app_set_instance_id:
+            for key, value in request_at_dict.items():
                 attributetype_key = node_collection.find_one({"_id":ObjectId(key)})
                 ga_node = create_gattribute(newgsystem._id, attributetype_key, value)
                 # newattribute = triple_collection.collection.GAttribute()
@@ -569,7 +573,7 @@ def mis_create_edit(request, group_id, app_id, app_set_id=None, app_set_instance
                 # newattribute.attribute_type = attributetype_key
                 # newattribute.object_value = value
                 # newattribute.save()
-            for key,value in request_rt_dict.items():
+            for key, value in request_rt_dict.items():
                 if key:
                     relationtype_key = node_collection.find_one({"_id": ObjectId(key)})
                 if value:
@@ -589,8 +593,8 @@ def mis_create_edit(request, group_id, app_id, app_set_id=None, app_set_instance
                     attribute_instance.object_value = request.POST.get(each["database_id"],"")
                     # attribute_instance.save()
                     ga_node = create_gattribute(attribute_instance.subject, attribute_instance.attribute_type, attribute_instance.object_value)
-                else :
-                    if request.POST.get(each["type_id"],""):
+                else:
+                    if request.POST.get(each["type_id"], ""):
                         attributetype_key = node_collection.find_one({"_id":ObjectId(each["type_id"])})
                         # newattribute = triple_collection.collection.GAttribute()
                         # newattribute.subject = newgsystem._id
@@ -657,3 +661,279 @@ def mis_enroll(request, group_id, app_id, app_set_id=None, app_set_instance_id=N
                                         # 'nodes':nodes, 
                                         })
     return render_to_response(template, variable)
+
+
+@login_required
+@get_execution_time
+def get_mis_reports(request, group_id, **kwargs):
+    title = "Reports"
+    group_name, group_id = get_group_name_id(group_id)
+    states = []
+    selected_filters = 0
+    # states -- [first-element: subject (State's ObjectId),
+    #            second-element: manipulated-name-value (State's name)]
+    query = {}
+    response_dict = {}
+
+    state_gst = node_collection.one({'_type': "GSystemType", 'name': "State"})
+    mis_admin_grp = node_collection.one({'_type': "Group", 'name': "MIS_admin"})
+    state_cur = node_collection.find({'member_of': state_gst._id,
+                                      'group_set': mis_admin_grp._id},{'name':1,'_id':1})
+
+    if request.is_ajax() and request.method == "POST":
+        state_id = university_id = college_id = None
+        end_date = start_date = None
+        gst_node = state_node = univ_node = college_node = None
+        univ_ids = []
+        return_data_set = []
+        rec = None
+        colg_cur = None
+        data_dict = request.POST.get("data_set", "")
+        gst_name = request.POST.get("gst_name", "")
+        print "\n\n gst_name-------",gst_name
+        if gst_name == "Event":
+            gst_name = "Classroom Session"
+            print "\n\n gst_name+++++",gst_name
+        ac_year = request.POST.get("academic_year", "")
+        if ac_year:
+            if ac_year != "ALL":
+                academic_year = ac_year
+                date_gte = datetime.datetime.strptime("1/1/" + academic_year, "%d/%m/%Y")
+                date_lte = datetime.datetime.strptime("31/12/" + academic_year, "%d/%m/%Y")
+                query.update({'attribute_set.registration_date': {'$gte': date_gte, '$lte': date_lte}})
+
+        gst_node = node_collection.one({'_type': 'GSystemType', 'name': unicode(gst_name)})
+        # print "gst_node", gst_node.name
+        query.update({'member_of': gst_node._id})
+        data_dict = json.loads(data_dict)
+        univ_gst = node_collection.one({'_type': "GSystemType", 'name': "University"})
+        colg_gst = node_collection.one({'_type': "GSystemType", 'name': "College"})
+        if "state" in data_dict:
+            if data_dict["state"]:
+                state_id = data_dict['state']
+                if state_id != "ALL":
+                    state_node = node_collection.one({'_id': ObjectId(state_id)})
+        if "university" in data_dict:
+            if data_dict["university"]:
+                university_id = data_dict['university']
+                if university_id != "ALL":
+                    univ_node = node_collection.one({'_id': ObjectId(university_id)})
+        if "college" in data_dict:
+            if data_dict["college"]:
+                college_id = data_dict['college']
+                if college_id != "ALL":
+                    college_node = node_collection.one({'_id': ObjectId(college_id)})
+        if "start_date" in data_dict:
+            start_date = data_dict['start_date']
+        if "end_date" in data_dict:
+            end_date = data_dict['end_date']
+
+        if start_date and end_date:
+
+            start_date = datetime.datetime.strptime(start_date,"%d/%m/%Y")
+            end_date = datetime.datetime.strptime(end_date,"%d/%m/%Y")
+            print "\n\n"
+            print "\n\n",type(start_date)
+            print "\n\n",end_date
+            query.update({'attribute_set.start_time': {'$gte': start_date}})
+            query.update({'attribute_set.end_time': {'$lte': end_date}})
+            print "\n\n query",query
+        if state_id and not university_id and not college_id:
+            selected_filters = 1
+        elif state_id and university_id and not college_id:
+            selected_filters = 2
+        elif state_id and university_id and college_id:
+            selected_filters = 3
+
+        # print "\nselected_filters\n", selected_filters
+        if selected_filters == 1:
+            if state_id == "ALL":
+                state_id_list = []
+                for each in state_cur:
+                    state_id_list.append(each._id)
+                if gst_node.name == "Student":
+                    query.update({'relation_set.person_belongs_to_state': {'$in':state_id_list}})
+                university_cur = node_collection.find({'member_of': univ_gst._id,
+                      'relation_set.organization_belongs_to_state': {'$in':state_id_list},
+                      'group_set': mis_admin_grp._id})
+            else:
+                if gst_node.name == "Student":
+                    query.update({'relation_set.person_belongs_to_state': ObjectId(state_id)})
+
+                university_cur = node_collection.find({'member_of': univ_gst._id,
+                  'relation_set.organization_belongs_to_state': ObjectId(state_id),
+                  'group_set': mis_admin_grp._id})
+
+            for each in university_cur:
+                univ_ids.append(each._id)
+            colg_cur = node_collection.find({'member_of': colg_gst._id,
+                        'relation_set.college_affiliated_to': {'$in': univ_ids},
+                        'group_set': mis_admin_grp._id})
+
+        elif selected_filters == 2:
+            if state_id == "ALL":
+                state_id_list = []
+                for each in state_cur:
+                    state_id_list.append(each._id)
+                if gst_node.name == "Student":
+                    query.update({'relation_set.person_belongs_to_state': {'$in':state_id_list}})
+                university_cur = node_collection.find({'member_of': univ_gst._id,
+                      'relation_set.organization_belongs_to_state': {'$in':state_id_list},
+                      'group_set': mis_admin_grp._id})
+            else:
+                if gst_node.name == "Student":
+                    query.update({'relation_set.person_belongs_to_state': ObjectId(state_id)})
+
+                university_cur = node_collection.find({'member_of': univ_gst._id,
+                  'relation_set.organization_belongs_to_state': ObjectId(state_id),
+                  'group_set': mis_admin_grp._id})
+
+            if university_id == "ALL":
+                univ_id_list = []
+                for each in university_cur:
+                    univ_id_list.append(each._id)
+                if gst_node.name == "Student":
+                    query.update({'relation_set.student_belongs_to_university': {'$in': univ_id_list}})
+                colg_cur = node_collection.find({'member_of': colg_gst._id,
+                  'relation_set.college_affiliated_to': {'$in': univ_id_list},
+                  'group_set': mis_admin_grp._id})
+            else:
+                if gst_node.name == "Student":
+                    query.update({'relation_set.student_belongs_to_university': ObjectId(university_id)})
+
+                colg_cur = node_collection.find({'member_of': colg_gst._id,
+                  'relation_set.college_affiliated_to': ObjectId(university_id),
+                  'group_set': mis_admin_grp._id})
+
+        elif selected_filters == 3:
+            if state_id == "ALL":
+                state_id_list = []
+                for each in state_cur:
+                    state_id_list.append(each._id)
+                if gst_node.name == "Student":
+                    query.update({'relation_set.person_belongs_to_state': {'$in': state_id_list}})
+                university_cur = node_collection.find({
+                      'member_of': univ_gst._id,
+                      'relation_set.organization_belongs_to_state': {'$in': state_id_list},
+                      'group_set': mis_admin_grp._id})
+            else:
+                if gst_node.name == "Student":
+                    query.update({'relation_set.person_belongs_to_state': ObjectId(state_id)})
+
+                university_cur = node_collection.find({'member_of': univ_gst._id,
+                  'relation_set.organization_belongs_to_state': ObjectId(state_id),
+                  'group_set': mis_admin_grp._id})
+
+            if university_id == "ALL":
+                univ_id_list = []
+                for each in university_cur:
+                    univ_id_list.append(each._id)
+                # query.update({'relation_set.person_belongs_to_state': {'$in':state_id_list}})
+                if gst_node.name == "Student":
+                    query.update({'relation_set.student_belongs_to_university': {'$in': univ_id_list}})
+                colg_cur = node_collection.find({'member_of': colg_gst._id,
+                      'relation_set.college_affiliated_to': {'$in': univ_id_list},
+                      'group_set': mis_admin_grp._id})
+            else:
+                # query.update({'relation_set.person_belongs_to_state': ObjectId(state_id)})
+                if gst_node.name == "Student":
+                    query.update({'relation_set.student_belongs_to_university': ObjectId(university_id)})
+
+                colg_cur = node_collection.find({'member_of': colg_gst._id,
+                  'relation_set.college_affiliated_to': ObjectId(university_id),
+                  'group_set': mis_admin_grp._id})
+
+            colg_id_list = []
+            if college_node:
+                colg_cur = node_collection.find({'_id': ObjectId(college_id)})
+            for each in colg_cur:
+                colg_id_list.append(each._id)
+            colg_cur.rewind()
+        # print "\n gst_name", gst_node.name
+        if colg_cur:
+            for each in colg_cur:
+                if gst_node.name == "Student":
+                    query.update({'relation_set.student_belongs_to_college': each._id})
+
+                print "\n\n colg name",each.name
+                if each.relation_set:
+                    for each_rel in each.relation_set:
+                        if gst_node.name == "Classroom Session":
+                            if each_rel and "has_group" in each_rel:
+                                colg_group_node_id = each_rel["has_group"][0]
+                                query.update({'group_set': ObjectId(colg_group_node_id)})
+                        if each_rel and "college_affiliated_to" in each_rel:
+                            univname = each_rel["college_affiliated_to"]
+                        if each_rel and "organization_belongs_to_state" in each_rel:
+                            statename = each_rel["organization_belongs_to_state"]
+                            # print "\n\n statename", statename
+                rec = node_collection.collection.aggregate([
+                                          {
+                                            '$match': query
+                                          },
+                                          {'$group':
+                                            {
+                                              '_id': {'State': statename,
+                                              'University': univname,
+                                              'College': each.name,
+                                              },
+                                              'total_students': {'$sum': 1}
+                                            }
+                                          }
+                ])
+
+                resultset = rec['result']
+                if resultset:
+                    for each in resultset:
+                        if each["_id"]:
+                            if each['_id']['State']:
+                                # each["state"] = each['_id']['State']
+                                state_node = node_collection.one({'_id': ObjectId(each['_id']['State'][0])})
+                                each["state"] = state_node.name
+                            if each['_id']['University']:
+                                univ_node = node_collection.one({'_id': ObjectId(each['_id']['University'][0])})
+                                each["university"] = univ_node.name
+                            if each['_id']['College']:
+                                each["college"] = each['_id']['College']
+                            del each['_id']
+                            try:
+                                print each['total_students']
+                            except:
+                                del each['total_students']
+
+                        return_data_set.append(each)
+                # print "\n return_data_set", return_data_set
+            column_headers = [
+                        ("state", "State"),
+                        ("university", "University"),
+                        ("college", "College"),
+            ]
+
+            if gst_node.name == "Student":
+                column_headers.append(('total_students',"Total Students"))
+            elif gst_node.name == "Classroom Session":
+                column_headers.append(('total_students',"Total Events"))
+
+            response_dict["column_headers"] = column_headers
+            response_dict["success"] = True
+            response_dict["return_data_set"] = return_data_set
+
+        return HttpResponse(json.dumps(response_dict, cls=NodeJSONEncoder))
+
+    else:
+
+        # Fetching all states belonging to given state in sorted order by name
+        if state_cur.count():
+            for d in state_cur:
+                states.append([str(d._id), str(d.name)])
+
+        return render_to_response("ndf/mis_report.html",
+                                {'title': title,
+                                'group_id': group_id,
+                                'groupid': group_id,
+                                'states_list': json.dumps(states)
+                                },
+                                context_instance=RequestContext(request)
+                                )
+
+