Django复合体QuerySet ManyToManyField和其他ManyToManyField

Question

对不起，这个标题，我不知道如何正确命名它。在获取与其他ManyToManyField相关的查询集时，我遇到了问题。所以看起来是这样的，有一个模型公司有ManyToManyField和Person模型，而Person模型有位置，因为它背后的逻辑是:1公司可以有很多人，1人可以有很少的职位，并且可以被少数公司雇用(我认为这是很明显的)。我用这种方式得到公司人员的查询

​

{% for team in brand.team.all %}
<p>{{ team.first_name }} {{ team.last_name }}</p>

<img class="img-thumbnail" src="/media/{{ team.photo }}">
<p>{{ team.position }} </p>
<p>{{ team.about }} </p>
{% endfor %}

​

我得到了我想要的，把这个和模板比较如下

​

但是我没有得到个人的位置，只有company.Position.None和我不知道如何得到这个职位。从文档到目前为止，我知道它适用于单个ManyToManyField，但我找不到类似于我的案例的例子，我也不知道该如何获得(人的职位)

下面是我的档案

models.py

​

from django.db import models
...

TYPES = (
        ('Startup', 'Startup'),
        ... )

CITIES = (
         ('Warszawa', 'Warszawa'),
         ... )

STACK = (
        ('PHP', 'PHP'),
        ... )

STUDENTS = (
		('No', 'No'),
		('Yes', 'Yes')
	)
STACK_ICONS = (
        ('/static/icons/stack/php.png', 'PHP'),
        ('/static/icons/stack/javascript.png', 'JavaScript'),
        ...
    )

POSITIONS = (
        ('CEO', 'Chief Executive Officer'),
        ('CTO', 'Chief Technology Officer'),
        ...
    )

# object position with relationship many to many to person

class Position(models.Model):
    position = models.CharField(max_length=50, choices=POSITIONS)

    def __str__(self):
        return self.position

# object person relation many to one (many persons to one company)

class Person(models.Model):
    first_name = models.CharField(max_length=50)
    last_name = models.CharField(max_length=50)
    about = models.TextField(max_length=500, default=None)
    position = models.ManyToManyField('Position')
    photo = models.ImageField(blank=True, null=True, default=None)

    def __str__(self):
        return "%s %s" % (self.first_name, self.last_name)

# object company

class Company(models.Model):
    # field person with relation many to one (many persons to 1 company)
    team = models.ManyToManyField('Person')
    name = models.CharField(max_length=100, blank=False)
    technologies = models.ManyToManyField('Stack')
    website = models.TextField(max_length=150, blank=True, null=True, validators=[URLValidator()])
    ...

    def save(self, *args, **kwargs):
        self.slug = slugify(self.name)
        super(Company, self).save(*args, **kwargs)

    def publish(self):
        self.published_date = timezone.now()
        self.save()
        
    def __str__(self):
        return self.name

# object stack relation manytomany with Company

class Stack(models.Model):
    name = models.CharField(max_length=30, choices=STACK)
    icon = models.CharField(max_length=80, choices=STACK_ICONS)

    def __str__(self):
        return self.name

​

views.py

​

from django.shortcuts import render, get_object_or_404, redirect
...

def brands(request, slug):
    brand = get_object_or_404(Company, slug=slug)
    return render(request, 'company/comp_view.html', {'brand': brand})

def stacks(request):
    stack = get_object_or_404(Stack)
    return render(request, 'company/comp_view.html', {'stack': stack})

def positions(request):
    position = get_object_or_404(Position)
    return render(request, 'company/comp_view.html', {'position': position})

...

​

comp_view.html

​

{% extends 'company/base.html' %}

    <div class="col col-md-1"></div>
    <div class="col col-md-5 card-section">
        <div class="team ">
            <div class="card-title">
                <span>Team</span>
            </div>
            <div class="row text-center">
                <div class="col col-md-4">
                    {% for team in brand.team.all %}
                    <p>{{ team.first_name }} {{ team.last_name }}</p>                        
                    <img class="img-thumbnail" src="/media/{{ team.photo }}">
                    <p>{{ team.position }}</p>
                    <p>{{ team.about }} </p>
                </div>
                {% endfor %}
            </div>
        </div>

{% endblock %}

​

Answer 1

没有“单一ManyToManyField”这样的东西。您有一个m2m关系，您需要像对团队成员一样迭代它。

{% for position in team.position.all %}
  {{ position.name }}
{% endfor %}