在Django表中显示数据,其中数据在行和列之间具有相似之处
目前,我正在处理时间表项目,在数据库中保存的时间表列表,我想在表格中打印它们,在表格中应根据行(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 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论