在Django表中显示数据,其中数据在行和列之间具有相似之处

发布于 2025-02-07 05:44:11 字数 1945 浏览 3 评论 0原文

目前,我正在处理时间表项目,在数据库中保存的时间表列表,我想在表格中打印它们,在表格中应根据行(Days)和列(时间段)将时间表放在正确的位置。 我试图安排时间表,如下如下: 当前有效的时间表安排图片的外观

所使用的视图如下

def lecturerTimeTable(request):
lecname=Lecturer.objects.get(user=request.user.id)
context={
    'schedule': TeachingTimetable.objects.filter(lecturer=lecname).order_by('meet_time'),#get lecturer
    'program': Program.objects.all(),
    'days': MeetingTime.objects.all().values('day').distinct(), #day
    'slots': MeetingTime.objects.all().values('time').distinct(),#timeslot
    'url_name':'class',#for active link
    'lecturer':lecname,
    'StarterPage':'Class-Timetable'# for head 
}
return render(request,'users/class_timetable.html',context)

所示

 <table class="table table-striped table-bordered table-hover">
    <thead>
    <tr>
        <th colspan="8"><center>{{lecturer}}</center</th>
    </tr>
        <tr>
            <th></th>
            {% for time in slots  %}
                <th class="time">{{time.time}}</th>{% comment %} timeslot from 07:00-09:00 to 17:00-21:00 {% endcomment %}
                {% endfor %}
          
            </tr>
      </thead>
    <tbody>
{% for day in days %}
<tr>
    <th>{{day.day}} </th>
        {% for lesson in schedule %}
            {% if lesson.meet_day == day.day%}
            {% if lesson.meet_time == '13:00 - 15:00' %} 

            <td>{{lesson.course}} <br> 
                {{lesson.lecturer}}<br>
                {{lesson.venue}}<br>
                {{lesson.meet_day}} {{lesson.meet_time}}</td>
            
                {% comment %} {% endif %} {% endcomment %}
        {% endif %}
    {% endfor %}
</tr>
{% endfor %}

。感谢我很快就会得到帮助!

谢谢

Currently i'm dealing with timetable project, have a list of schedule saved in database and i want to print them in a table where a schedule should be placed on a right place based on row(days) and columns (timeslots).
i have tried to arrange schedule and it appear as follows:
appearance of current tried schedule arrangement picture

The view used is as follows

def lecturerTimeTable(request):
lecname=Lecturer.objects.get(user=request.user.id)
context={
    'schedule': TeachingTimetable.objects.filter(lecturer=lecname).order_by('meet_time'),#get lecturer
    'program': Program.objects.all(),
    'days': MeetingTime.objects.all().values('day').distinct(), #day
    'slots': MeetingTime.objects.all().values('time').distinct(),#timeslot
    'url_name':'class',#for active link
    'lecturer':lecname,
    'StarterPage':'Class-Timetable'# for head 
}
return render(request,'users/class_timetable.html',context)

The template table is as follows

 <table class="table table-striped table-bordered table-hover">
    <thead>
    <tr>
        <th colspan="8"><center>{{lecturer}}</center</th>
    </tr>
        <tr>
            <th></th>
            {% for time in slots  %}
                <th class="time">{{time.time}}</th>{% comment %} timeslot from 07:00-09:00 to 17:00-21:00 {% endcomment %}
                {% endfor %}
          
            </tr>
      </thead>
    <tbody>
{% for day in days %}
<tr>
    <th>{{day.day}} </th>
        {% for lesson in schedule %}
            {% if lesson.meet_day == day.day%}
            {% if lesson.meet_time == '13:00 - 15:00' %} 

            <td>{{lesson.course}} <br> 
                {{lesson.lecturer}}<br>
                {{lesson.venue}}<br>
                {{lesson.meet_day}} {{lesson.meet_time}}</td>
            
                {% comment %} {% endif %} {% endcomment %}
        {% endif %}
    {% endfor %}
</tr>
{% endfor %}

So i appreciate i will get help soon!

Thanks

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。
列表为空,暂无数据
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文