def deplist (request):
    try:
        querySet = ComplaintDepartment.objects.all()

        columnIndexNameMap = { 0: 'code',
                               1: 'name'}

        x = get_datatables_records (request, querySet, columnIndexNameMap, 'department_datatable.html')
    except:
        import traceback
        traceback.print_exc ()
    return x
def blist (request):
    try:
        querySet = Block.objects.all ()

        columnIndexNameMap = { 0: 'code',
                               1: 'name',
                               2 : 'lattd',
                               3 : 'longd'}

        x = get_datatables_records (request, querySet, columnIndexNameMap, 'block_datatable.html')
    except:
        import traceback
        traceback.print_exc ()
    return x
def csolist(request):
    try:
        querySet = CmhUser.objects.filter (user__approle__role = UserRoles.CSO)

        columnIndexNameMap = { 0: 'id',
                               1: 'get_role_name',
                               2: 'phone_number',
                               3: 'id'}

        x = get_datatables_records (request, querySet, columnIndexNameMap, 'cso_datatable.html')
    except:
        import traceback
        traceback.print_exc ()
    return x
def clist (request):
    try:
        querySet = ComplaintType.objects.all()


        columnIndexNameMap = { 0: 'department__code',
                               1: 'code',
                               2: 'summary',
                               3: 'cclass'}

        x = get_datatables_records (request, querySet, columnIndexNameMap, 'comp_datatable.html')
    except:
        import traceback
        traceback.print_exc ()
    return x
def villist (request):
    try:
        querySet = Village.objects.all ()

        columnIndexNameMap = { 0: 'grampanchayat__block__code',
                               1: 'grampanchayat__block__name',
                               2: 'grampanchayat__code',
                               3: 'grampanchayat__name',
                               4: 'code',
                               5: 'name',
                               6: 'lattd',
                               7: 'longd'}

        x = get_datatables_records (request, querySet, columnIndexNameMap, 'villist_datatable.html')
    except:
        import traceback
        traceback.print_exc ()
    return x
def officialist(request):
    try:
        query = (Q (user__approle__role = UserRoles.OFFICIAL) |
                 Q (user__approle__role = UserRoles.DELEGATE))

        querySet = CmhUser.objects.filter (query)

        columnIndexNameMap = { 0: 'user__first_name',
                               1: 'get_role_name',
                               2: 'phone_number',
                               3: 'department__name',
                               4: 'supervisor_names',
                               5: 'id'}

        x = get_datatables_records (request, querySet, columnIndexNameMap, 'officials_datatable.html')
    except:
        import traceback
        traceback.print_exc ()
    return x