Python get_datatables_recordsの例

コード例 #1

ファイル: student.py プロジェクト: 343829084/student_django

def get_students_list(request):
    students = Student.objects.all().reverse()

    columnIndexNameMap = {
        0: 'id',
        1: 'user',
        2: 'realname',
        3: 'sex',
        4: 'theclass',
    }

    columnNameIndexMap = dict([[v, k] for k, v in columnIndexNameMap.items()])

    updatefilter = {
        1: 'user__username',
        4: 'theclass__classid',
    }

    extrafilters = {'sex': SEX_CHOICES}

    updateitems = {
        1: 'user_id',
        4: 'theclass_id',
    }
    try:
        aaData, sEcho, iTotalRecords, iTotalDisplayRecords, sColumns = get_datatables_records(
            request, students, columnIndexNameMap, None, extrafilters, False,
            updatefilter, updateitems)
    except Exception, e:
        traceback.print_stack()
        aaData, sEcho, iTotalRecords, iTotalDisplayRecords, sColumns = [], 1, 0, 0, ','.join(
            columnIndexNameMap.values())

コード例 #2

ファイル: comperformance.py プロジェクト: 343829084/djang_new_student

def ajaxcomperformance_setup(request):
    comperformances = Comperformance.objects.all().order_by('term')

    columnIndexNameMap = {
        0: 'id',
        1: 'term',
        2: 'moral',
        3: 'behaviorup',
        4: 'physical',
        5: 'excellent',
        6: 'good',
        7: 'ordinary',
        8: 'development',
        9: 'behavior',
    }

    try:
        aaData, sEcho, iTotalRecords, iTotalDisplayRecords, sColumns = get_datatables_records(
            request, comperformances, columnIndexNameMap, None, {}, False, {},
            {})
    except Exception, e:
        traceback.print_stack()
        traceback.print_exc()
        print e
        aaData, sEcho, iTotalRecords, iTotalDisplayRecords, sColumns = [], 1, 0, 0, ','.join(
            columnIndexNameMap.values())

コード例 #3

ファイル: myclass.py プロジェクト: 343829084/djang_new_student

def get_classes_list(request):
    classes = Class.objects.all().reverse()

    columnIndexNameMap = {
        0: 'id',
        1: 'classid',
        2: 'classname',
    }

    try:
        aaData, sEcho, iTotalRecords, iTotalDisplayRecords, sColumns = get_datatables_records(
            request, classes, columnIndexNameMap, None, {}, False, {}, {})
    except Exception, e:
        traceback.print_stack()
        aaData, sEcho, iTotalRecords, iTotalDisplayRecords, sColumns = [], 1, 0, 0, ','.join(
            columnIndexNameMap.values())

コード例 #4

ファイル: assessment.py プロジェクト: 343829084/djang_new_student

def get_assessments_list(request):
    assessments = Assessment.objects.all().reverse()

    columnIndexNameMap = {
        0:'id',
        1:'term',
        2:'begindate',
        3:'enddate',
        4:'excellent',
        5:'good',
        6:'ordinary',
    }

    try:
        aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = get_datatables_records(request, assessments, columnIndexNameMap,None,{},False,{},{})
    except Exception,e:
        traceback.print_stack()
        aaData,sEcho,iTotalRecords,iTotalDisplayRecords,sColumns = [],1,0,0,','.join(columnIndexNameMap.values())