文档建议反馈控制台
首页
学习
活动
专区
圈层
工具
MCP广场
文章/答案/技术大牛
发布
社区首页 >问答首页 >在Django中按分组显示数据

问在Django中按分组显示数据
EN

Stack Overflow用户
提问于 2020-04-03 23:33:09
回答 1查看 108关注 0票数 0

基本上，我一直在这个项目上工作，我被困在根据我的需要在html页面上显示数据。现在所有显示的都是0-4数据，但我不确定如何正确显示它。

对于孩子:我想让它显示用户的孩子。

对于时间线:根据选择的子项，时间线表将显示特定子项中的数据。我希望按年龄范围(列标题)对数据进行分组，然后单击时，它将显示与当前时间线单元格关联的pdf。

我的视图文件：

代码语言：javascript
复制
def timeline(request):
    timeline = Timeline.objects.all()
    return render(request, 'timeline.html', {
        'timeline': timeline
    })

我的模型文件：

代码语言：javascript
复制
HEADER_CHOICES = [
    ('Financial Support', 'Financial Support'),
    ('Educational Support', 'Educational Support'),
    ('Governmental Support', 'Governmental Support '),
    ('Charity Support Groups', 'Charity Support Groups'),
    ('Therapy Support', 'Therapy Support '),
    ('Transport Support', 'Transport Support ')
]
AGE_CHOICES = [
    ('0-4', '0-4'),
    ('4-11', '4-11'),
    ('11-18', '11-18'),
    ('18-25', '18-25')
]

class Timeline(models.Model):
    header = models.CharField(max_length=30, choices=HEADER_CHOICES)
    age = models.CharField(max_length=6, choices=AGE_CHOICES)
    child = models.OneToOneField(Children, on_delete=models.CASCADE)

class Pdf(models.Model):
    pdf = models.FileField(upload_to='timelinepdfs')
    timeline = models.ForeignKey(Timeline, on_delete=models.CASCADE)

我的html页面：

代码语言：javascript
复制
{% extends 'pages/home_page.html' %}
{% block content %}
<style>
    .rightMenu {

        position:relative;
        float:right;
    }
    .right-caret {

        border-bottom: 4px solid transparent;
        border-top: 4px solid transparent;
        border-left: 4px solid #000000;
        display: inline-block;
        height: 0;
        opacity: 1;
        vertical-align: top;
        width: 0;

    }
    .right
    {
        float:right;
    }

    .thead {
        font-size: 28px;
    }
</style>

<div class="span4">
    <h1> Timeline</h1>

    <label for="child">Choose a Child:</label>

    <select id="child">
        {% for tl in timeline %}
            {% for child in tl.child_set.all %} 
                {% if timeline.child.parent == user.id %}
                <option value="{{child.first_name}}">{{ child.first_name }}  {{ child.last_name }}</option>
                {% endif %}
            {% endfor %}
        {% endfor %}


    </select>

    <form action="{% url 'upload' %}">
        <input type="submit" value="Add to timeline" />
    </form>

    <table class="timeline-table">
    <tr>
        <th>0-4</th>
        <th>4-11</th>
        <th>11-18</th>
        <th>18-25</th>
    </tr>
    {% for tl in timeline %}
    <tr>
        {% if "0-4" in tl.age %}
        <td>
            <div class="btn-group"> <a class="btn btn-link dropdown-toggle" data-toggle="dropdown" href="#">
                      <h3>{{ tl.header }}</h3>
                       <span class="right-caret right"></span>
                 </a>

                <ul class="dropdown-menu rightMenu">
                    {% for p in Pdf %}
                    <li>
                        <div class="btn-group"> <a href="{{ p.url }}" style="text-align:center;" class="btn btn-link operationsButtons">
                           Download pdf 
                           </a>
                        </div>
                    </li>
                    {% endfor %}
                </ul>
            </div>
        </td>
        {% endif %}

    </tr>
    {% endfor %}

    </table>
</div>

{% endblock %}

子模型：

代码语言：javascript
复制
class Children(models.Model):
    first_name = models.CharField(max_length=100)
    last_name = models.CharField(max_length=100)
    age = models.CharField(max_length=100)
    diagnosis = models.IntegerField(
        choices= DIAGNOSIS_CHOICES,
    )
    disability = models.CharField(max_length=100)
    parent = models.ForeignKey(User, on_delete=models.CASCADE)
django
django-models
django-views
django-templates
EN

回答 1

Stack Overflow用户

发布于 2020-04-04 01:04:34

设法修好了它。

必须这样做：

视图：

代码语言：javascript
复制
def timeline(request):
    timeline = Timeline.objects.all()
    children = Children.objects.all()
    pdfs = Pdf.objects.all()
    return render(request, 'timeline.html', {
        'timeline': timeline,
        'children' : children,
        'pdfs' :pdfs
    })

页面：

代码语言：javascript
复制
{% extends 'pages/home_page.html' %}
{% block content %}
<style>
    .rightMenu {

        position:relative;
        float:right;
    }
    .right-caret {

        border-bottom: 4px solid transparent;
        border-top: 4px solid transparent;
        border-left: 4px solid #000000;
        display: inline-block;
        height: 0;
        opacity: 1;
        vertical-align: top;
        width: 0;

    }
    .right
    {
        float:right;
    }

    .thead {
        font-size: 28px;
    }
</style>

<div class="span4">
    <h1> Timeline</h1>

    <label for="child">Choose a Child:</label>

    <select id="child">
        {% for cl in children %}
            {% if cl.parent == user %}
                <option value="{{child.first_name}}">{{ cl.first_name }}  {{ cl.last_name }}</option>
            {% endif %}
        {% endfor %}


    </select>

    <form action="{% url 'upload' %}">
        <input type="submit" value="Add to timeline" />
    </form>

    <table class="timeline-table">
    <tr>
        <th>0-4</th>
        <th>4-11</th>
        <th>11-18</th>
        <th>18-25</th>
    </tr>

    <tr>
        {% for tl in timeline %}
        {% if "Financial Support" in tl.header %}
        <td>
            <div class="btn-group"> <a class="btn btn-link dropdown-toggle" data-toggle="dropdown" href="#">
                      <h3>{{ tl.header }}</h3>
                       <span class="right-caret right"></span>
                 </a>

                <ul class="dropdown-menu rightMenu">
                    {% for p in pdf %}
                    <li>
                        <div class="btn-group"> <a href="{{ p.pdf }}" style="text-align:center;" class="btn btn-link operationsButtons">
                           Download pdf 
                           </a>
                        </div>
                    </li>
                    {% endfor %}
                </ul>
            </div>
        </td>
        {% endif %}

        {% endfor %}
    </tr>
    <tr>
        {% for tl in timeline %}
        {% if "Educational Support" in tl.header %}
        <td>
            <div class="btn-group"> <a class="btn btn-link dropdown-toggle" data-toggle="dropdown" href="#">
                      <h3>{{ tl.header }}</h3>
                       <span class="right-caret right"></span>
                 </a>

                <ul class="dropdown-menu rightMenu">
                    {% for p in pdf %}
                    <li>
                        <div class="btn-group"> <a href="{{ p.pdf }}" style="text-align:center;" class="btn btn-link operationsButtons">
                           Download pdf 
                           </a>
                        </div>
                    </li>
                    {% endfor %}
                </ul>
            </div>
        </td>
        {% endif %}

        {% endfor %}
    </tr> 
    <tr>
        {% for tl in timeline %}
        {% if "Governmental Support" in tl.header %}
        <td>
            <div class="btn-group"> <a class="btn btn-link dropdown-toggle" data-toggle="dropdown" href="#">
                      <h3>{{ tl.header }}</h3>
                       <span class="right-caret right"></span>
                 </a>

                <ul class="dropdown-menu rightMenu">
                    {% for p in pdf %}
                    <li>
                        <div class="btn-group"> <a href="{{ p.pdf }}" style="text-align:center;" class="btn btn-link operationsButtons">
                           Download pdf 
                           </a>
                        </div>
                    </li>
                    {% endfor %}
                </ul>
            </div>
        </td>
        {% endif %}

        {% endfor %}
    </tr> 
    <tr>
        {% for tl in timeline %}
        {% if "Charity Support Groups" in tl.header %}
        <td>
            <div class="btn-group"> <a class="btn btn-link dropdown-toggle" data-toggle="dropdown" href="#">
                      <h3>{{ tl.header }}</h3>
                       <span class="right-caret right"></span>
                 </a>

                <ul class="dropdown-menu rightMenu">
                    {% for p in pdf %}
                    <li>
                        <div class="btn-group"> <a href="{{ p.pdf }}" style="text-align:center;" class="btn btn-link operationsButtons">
                           Download pdf 
                           </a>
                        </div>
                    </li>
                    {% endfor %}
                </ul>
            </div>
        </td>
        {% endif %}

        {% endfor %}
    </tr> 
    <tr>
        {% for tl in timeline %}
        {% if "Therapy Support" in tl.header %}
        <td>
            <div class="btn-group"> <a class="btn btn-link dropdown-toggle" data-toggle="dropdown" href="#">
                      <h3>{{ tl.header }}</h3>
                       <span class="right-caret right"></span>
                 </a>

                <ul class="dropdown-menu rightMenu">
                    {% for p in pdf %}
                    <li>
                        <div class="btn-group"> <a href="{{ p.pdf }}" style="text-align:center;" class="btn btn-link operationsButtons">
                           Download pdf 
                           </a>
                        </div>
                    </li>
                    {% endfor %}
                </ul>
            </div>
        </td>
        {% endif %}

        {% endfor %}
    </tr> 
    <tr>
        {% for tl in timeline %}
        {% if "Transport Support" in tl.header %}
        <td>
            <div class="btn-group"> <a class="btn btn-link dropdown-toggle" data-toggle="dropdown" href="#">
                      <h3>{{ tl.header }}</h3>
                       <span class="right-caret right"></span>
                 </a>

                <ul class="dropdown-menu rightMenu">
                    {% for p in pdf %}
                    <li>
                        <div class="btn-group"> <a href="{{ p.pdf }}" style="text-align:center;" class="btn btn-link operationsButtons">
                           Download pdf 
                           </a>
                        </div>
                    </li>
                    {% endfor %}
                </ul>
            </div>
        </td>
        {% endif %}

        {% endfor %}
    </tr> 


    </table>
</div>

{% endblock %}

有没有更快的方法呢？

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：

https://stackoverflow.com/questions/61015324

复制
相关文章

相似问题

领券

腾讯云开发者

扫码关注腾讯云开发者

扫码关注腾讯云开发者

领取腾讯云代金券

热门产品

热门推荐

更多推荐

Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有 

深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 粤公网安备44030502008569号

腾讯云计算（北京）有限责任公司 京ICP证150476号 |  京ICP备11018762号

问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档