我正在尝试显示属于同一公司的员工列表。 所以例如使用给定的URL localhost / app / company-slug /我想显示一个行列表,其中包含所有三个模型的详细信息:
| first_name | last_name | company-slug | employee_status | employee_type |
有了这个模型,我如何检索这种数据?
class Employee(models.Model): company = models.ForeignKey(Company) class EmployeeProfile(models.Model): employee = models.OneToOneField(Employee) # Base first_name = models.CharField(max_length=31) middle_name = models.CharField(max_length=31, null=True, blank=True) class EmployeeJob(models.Model): employee = models.OneToOneField(Employee) # Employment status employment_status = models.ForeignKey(EmploymentStatus, null=True, blank=True) employment_type = models.ForeignKey(EmploymentType, null=True, blank=True)编辑1:
我不知道模板标签中是否可以连接表。 这是@Shang Wang建议的工作解决方案
{% for employee in employees %} <tr class="table-row clickable" data-href="{% url 'hrm:detail' company.slug employee.pk %}"> <td><strong>A</strong></td> <td>{{ employee.employeeprofile.first_name }} {{ employee.employeeprofile.last_name }}</td> <td>{{ employee.employeejob.employment_status }}</td> <td>{{ employee.employeejob.employment_type }}</td> <td>4</td> </tr> {% endfor %}I'm trying to display a list of employees that are part of the same company. So for example with the given URL localhost/app/company-slug/ I'd like to show a list of rows where there are the details of all three models:
| first_name | last_name | company-slug | employee_status | employee_type |
With this models, how I can retrieve this kind of data?
class Employee(models.Model): company = models.ForeignKey(Company) class EmployeeProfile(models.Model): employee = models.OneToOneField(Employee) # Base first_name = models.CharField(max_length=31) middle_name = models.CharField(max_length=31, null=True, blank=True) class EmployeeJob(models.Model): employee = models.OneToOneField(Employee) # Employment status employment_status = models.ForeignKey(EmploymentStatus, null=True, blank=True) employment_type = models.ForeignKey(EmploymentType, null=True, blank=True)Edit 1:
I didn't know was possible join tables within template tags. This is a working solution suggested by @Shang Wang
{% for employee in employees %} <tr class="table-row clickable" data-href="{% url 'hrm:detail' company.slug employee.pk %}"> <td><strong>A</strong></td> <td>{{ employee.employeeprofile.first_name }} {{ employee.employeeprofile.last_name }}</td> <td>{{ employee.employeejob.employment_status }}</td> <td>{{ employee.employeejob.employment_type }}</td> <td>4</td> </tr> {% endfor %}最满意答案
我假设你已经在当前页面中有了company的对象,让员工变得非常简单:
employees = Employee.objects.filter(company=company) for employee in employees: print employee.employeeprofile.first_name print employee.employeeprofile.last_name print employee.employeejob.employment_status print employee.employeejob.employee_type关于OneToOneField的 Django文档。
I assume you already had an object for company in current page, getting the employees is really easy:
employees = Employee.objects.filter(company=company) for employee in employees: print employee.employeeprofile.first_name print employee.employeeprofile.last_name print employee.employeejob.employment_status print employee.employeejob.employee_typeDjango doc about OneToOneField.
更多推荐
发布评论