Django Admin中实现公寓与配套设施的多选复选框关联

方案一：修改模型使用Django原生多对多关联（推荐） #

你的问题核心是Apartment模型没有直接关联Commodities的字段，导致filter_horizontal无法识别。通过给Apartment添加ManyToManyField并指定自定义中间表，就能让Django自动处理关联逻辑，同时兼容现有中间表结构：

1. 更新Apartment模型

class Apartment(models.Model):
    address = models.ForeignKey(Address, verbose_name=_('Apartment Address'), on_delete=models.CASCADE)
    floor = models.IntegerField(verbose_name=_('Floor'), null=True, blank=True)
    apartment = models.CharField(verbose_name=_('Apartment'), null=True, blank=True, max_length=10)
    # 添加多对多关联，指定现有中间表
    commodities = models.ManyToManyField(Commodities, through='ApartmentCommodities', verbose_name=_('配套设施'))

    def __str__(self):
        return self.address.__str__() + \
               (' ' + _('Entrance') + ' ' + self.address.entrance if self.address.entrance else '') + \
               (' ' + _('Floor') + ' ' + str(self.floor) if self.floor else '') + \
               (' ' + _('Apartment') + ' ' + self.apartment if self.apartment else '')

2. 配置ApartmentAdmin
   现在可以直接使用filter_horizontal（左右选择框样式），或者强制用复选框列表：

from django.contrib import admin
from .models import Apartment
from django.forms import CheckboxSelectMultiple

class ApartmentAdmin(admin.ModelAdmin):
    # 方式1：使用左右选择框（Django默认多对多样式）
    filter_horizontal = ('commodities',)

    # 方式2：直接展示复选框列表
    # def formfield_for_manytomany(self, db_field, request, **kwargs):
    #     if db_field.name == 'commodities':
    #         kwargs['widget'] = CheckboxSelectMultiple
    #     return super().formfield_for_manytomany(db_field, request, **kwargs)

admin.site.register(Apartment, ApartmentAdmin)

方案二：不修改模型，自定义表单实现 #

如果不想改动现有模型结构（比如中间表后续要添加额外字段），可以通过自定义表单手动处理关联逻辑：

1. 创建自定义表单

from django import forms
from .models import Apartment, Commodities, ApartmentCommodities

class ApartmentForm(forms.ModelForm):
    # 定义多选复选框字段
    commodities = forms.ModelMultipleChoiceField(
        queryset=Commodities.objects.all(),
        widget=forms.CheckboxSelectMultiple,
        required=False,
        label=_('配套设施')
    )

    class Meta:
        model = Apartment
        fields = ['address', 'floor', 'apartment', 'commodities']

    def __init__(self, *args, **kwargs):
        super().__init__(*args, **kwargs)
        # 编辑时自动选中已关联的配套设施
        if self.instance.pk:
            selected_ids = self.instance.apartmentcommodities_set.values_list('commodity__pk', flat=True)
            self.initial['commodities'] = selected_ids

    def save(self, commit=True):
        # 保存公寓实例
        apartment = super().save(commit=commit)
        if commit:
            # 清空旧关联
            ApartmentCommodities.objects.filter(apartment=apartment).delete()
            # 添加新关联
            for commodity in self.cleaned_data['commodities']:
                ApartmentCommodities.objects.create(apartment=apartment, commodity=commodity)
        return apartment

2. 在Admin中绑定自定义表单

from django.contrib import admin
from .models import Apartment
from .forms import ApartmentForm

class ApartmentAdmin(admin.ModelAdmin):
    form = ApartmentForm
    fields = ['address', 'floor', 'apartment', 'commodities']

admin.site.register(Apartment, ApartmentAdmin)

内容的提问来源于stack exchange，提问作者ufk