问题描述

感谢大家一直在这里分享您的知识。

我在 Django 中计算对象时遇到问题。我目前正在学习和研究基本的人力资源系统，并且已经建立了我的观点、模型等。我计划有一个界面，我可以打印出基于性别的员工人数。我目前设置的一个是在我创建新员工时增加男性和女性的人数。请问我该如何纠正这个异常？

视图.py

from django.contrib.auth.decorators import login_required
from django.contrib.auth.models import User
from django.shortcuts import render
from django_tables2 import RequestConfig
from django_tables2.export import TableExport

from .models import Employee
from .models import EmployeeFilter
from .tables import EmployeeTable

@login_required()
def employees(request):
    filter = EmployeeFilter(request.GET, queryset=Employee.objects.all())
    table = EmployeeTable(filter.qs)
    RequestConfig(request, paginate={"per_page": 15}).configure(table)
    count = Employee.objects.all().count()
    male_count = Employee.objects.filter(gender__contains='Male').count()
    female_count = Employee.objects.filter(gender__contains='Female').count()
    user_count = User.objects.all().count()

    export_format = request.GET.get("_export", None)

    if TableExport.is_valid_format(export_format):
        exporter = TableExport(export_format, table)
        return exporter.response("table.{}".format("csv", "xlsx"))

    return render(request, "employees/employees.html", {
        "table": table,
        "filter": filter,
        "count": count,
        "male_count": male_count,
        "female_count": female_count,
        "user_count": user_count,
    })

模板.html

{% extends "employees/base.html" %}
{% load render_table from django_tables2 %}
{% load django_tables2 %}
{% load querystring from django_tables2 %}
{% block content %}
<!--Data overview-->
    <div class="container data overview">
        <div class="row">
            <div class="col-md-3">
                <div class="container-fluid bg-warning data-ov-container">
                    <div class="row">
                        <div class="col-8">
                            <h6 class="data-heading font-weight-bold">Total Employees</h6>
                            <p class="data-text ">{{ count }}</p>
                        </div>

                        <div class="col-4">
                            <i class="fas fa-users data-icon"></i>
                        </div>
                    </div>
                </div>
            </div>

            <div class="col-md-3">
                <div class="container-fluid bg-dark data-ov-container">
                    <div class="row">
                        <div class="col-9">
                            <h6 class="data-heading text-white font-weight-bold">Male Employees</h6>
                            <p class="data-text text-white">{{ male_count }}</p>
                        </div>

                        <div class="col-3">
                            <i class="fas fa-male data-icon text-white"></i>
                        </div>
                    </div>
                </div>
            </div>

            <div class="col-md-3">
                <div class="container-fluid bg-danger data-ov-container">
                    <div class="row">
                        <div class="col-9">
                            <h6 class="data-heading text-white font-weight-bold">Female Employees</h6>
                            <p class="data-text text-white">{{ female_count }}</p>
                        </div>

                        <div class="col-3">
                            <i class="fas fa-female data-icon text-white"></i>
                        </div>
                    </div>
                </div>
            </div>

            <div class="col-md-3">
                <div class="container-fluid bg-secondary data-ov-container">
                    <div class="row">
                        <div class="col-8">
                            <h6 class="data-heading text-white font-weight-bold">Active Users</h6>
                            <p class="data-text text-white">{{ user_count }}</p>
                        </div>

                        <div class="col-4">
                            <i class="fas fa-users-cog data-icon text-white"></i>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!--Employees data-->
    <div class="filter-container container-fluid">
        <div class="row">
            <div class="col-md-9">
                <!--filter form-->
                <form action="" class="form form-inline employee-filter-form" method="get">
                    <legend class="mb-2">Filter employee records</legend>
                    {{ form.non_field_errors }}
                    <div class="fieldWrapper">
                        {{ filter.form.first_name.errors }}
                        {{ filter.form.first_name }}
                    </div>
                    <div class="fieldWrapper">
                        {{ filter.form.last_name.errors }}
                        {{ filter.form.last_name }}
                    </div>
                    <button aria-expanded="false" aria-haspopup="true"
                            class="ml-2 btn btn-danger filter-btn" type="submit">
                        Filter
                    </button>
                </form>
            </div>

            <div class="col-md-3 download-btn-col">
                <button aria-expanded="false" aria-haspopup="true"
                        class="mr-3 btn btn-success" type="submit">
                    <i class="fas fa-upload"></i> Import
                </button>
                <div class="btn-group download-btn">
                    <button aria-expanded="false" aria-haspopup="true"
                            class="btn btn-warning dropdown-toggle"
                            data-toggle="dropdown" type="button">
                        <i class="fas fa-file-export"></i> Export
                    </button>
                    <div class="dropdown-menu">
                        <a class="dropdown-item" href="{% querystring '_export'='csv' %}">csv</a>
                        <a class="dropdown-item" href="{% querystring '_export'='xlsx' %}">xlsx</a>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <!-- data rendered here -->
    {% render_table table 'django_tables2/bootstrap.html' %}
    <!-- data rendered here -->
    {% endblock content %}

模型.py

...
GENDER_CHOICES = (
    ('FEMALE', 'Female'),
    ('MALE', 'Male'),
    ("DWTS" "Don't want to say"),
)
...
@python_2_unicode_compatible
class Employee(models.Model):
    # basic information of employee
    first_name = models.CharField(_('first name'), max_length=40)
    last_name = models.CharField(_('last name'), max_length=40)
    emp_photo = models.ImageField(_('passport'))
    date_of_birth = models.DateField(_('birthday'))
    gender = models.CharField(_('gender'), max_length=15, choices=GENDER_CHOICES, default=['MALE', 'Male'])
    house_address = models.CharField(_('house address'), max_length=100)
    city_of_residence = models.CharField(_('city'), max_length=100)
    state_of_residence = models.CharField(_('state'), max_length=100, choices=NIGERIAN_STATE_CHOICES)
    country_of_residence = models.CharField(_('country'), max_length=100, choices=COUNTRY_CHOICES,
                                            default=[156, 'Nigeria'])
    state_of_origin = models.CharField(_('state of origin'), max_length=100, choices=NIGERIAN_STATE_CHOICES)

    class Meta:
        verbose_name = _('Employee')
        verbose_name_plural = _('Employees')

    def __str__(self):
        return "{} {}".format(self.first_name, self.last_name)

@python_2_unicode_compatible
class EmployeeFilter(django_filters.FilterSet):
    first_name = django_filters.CharFilter(lookup_expr='iexact', widget=TextInput(
        attrs={'placeholder': 'First name', 'class': 'input_search'}))
    last_name = django_filters.CharFilter(lookup_expr='iexact',
                                          widget=TextInput(attrs={'placeholder': 'Last name', 'class': 'input_search'}))

    class Meta:
        model = Employee
        fields = ["first_name", "last_name", ]

标签： djangopython-3.xcount

django - 如何在django中计算对象

问题描述

视图.py

模型.py

解决方案

推荐阅读