Django在views.py中创建表

2024-09-27 00:15:15 发布

您现在位置:Python中文网/ 问答频道 /正文

我的views.py中有这段代码,要创建一些表,如何删除平均值下的ID而不影响学生姓名旁边的ID

students = StudentSubjectGrade.objects.filter(
    grading_Period=period).filter(
    Subjects=subject).order_by(
    'Students_Enrollment_Records', 'Grading_Categories','id'
).values('id', 'Students_Enrollment_Records__Students_Enrollment_Records__Student_Users__Firstname',
         'Students_Enrollment_Records__Students_Enrollment_Records__Student_Users__Lastname',
         'Students_Enrollment_Records__Students_Enrollment_Records__Student_Users__Middle_Initial',
         'Grading_Categories',
         'Average', 'Grading_Categories__PercentageWeight')

Categories = list(cate.values_list('id', flat=True).order_by('id'))

table = []
student_name = None
table_row = None
columns = len(Categories) + 1

table_header = ['Student Names']

table_header.extend(list(cate.values('CategoryName', 'PercentageWeight')))


table.append(table_header)

for student in students:
    if not student['Students_Enrollment_Records__Students_Enrollment_Records__Student_Users__Lastname'] + ' ' + \
           student[
               'Students_Enrollment_Records__Students_Enrollment_Records__Student_Users__Firstname'] == student_name:
        if not table_row is None:
            table.append(table_row)

        table_row = [None for d in range(columns)]

        student_name = student[
                           'Students_Enrollment_Records__Students_Enrollment_Records__Student_Users__Lastname'] + ' ' + \
                       student['Students_Enrollment_Records__Students_Enrollment_Records__Student_Users__Firstname']
        table_row[0] = student_name

        id = student['id']
        table_row.append(id)

    table_row[Categories.index(student['Grading_Categories']) + 1] = student['Average'] * student[
        'Grading_Categories__PercentageWeight'] / 100

table.append(table_row)

这是结果,

enter image description here

如何删除Average标题下的额外ID

这是我的html

{% for row in table|slice:"1:" %}
    <tr class="tr2update">
        <td><input type="text" value="{{ row.4 }}" name="studentname">{{ row.0 }}</td>
         <td class="tdupdate" hidden><input type="text" hidden></td>
        {% for c in row|slice:"1:" %}
            <td><input type="text" id="oldgrade" class="oldgrade" name="gradeupdate" value="{{c|floatformat:'2'}}" readonly></td>
        {% endfor %}
        <td data-id='row' id="ans"><input type='number' class='averages' step="any" name="average" readonly/></td>
    </tr>
 {% endfor %}

请帮帮我,这个问题已经快一个星期了,直到现在我还没有解决它


Tags: namenoneidtableusersstudenttdrow

热门问题