Django Admin面板技术问询：同分类条目排序实现及特定字段匹配条目批量修改可行性

Alright, let's tackle your two questions step by step—first fixing the category-specific sorting with django-admin-sortable2, then setting up bulk updates in the Django Admin.

1. Fixing Category-Specific Sorting #

Your current Ordering model sorts all items globally, which doesn't match your requirement of sorting items within the same category. Here's how to adjust it:

Update the Ordering Model #

We need to group sorting by the Item's category, add a unique constraint to avoid duplicate orders in a category, and modify the reorder method to handle each category separately:

class Ordering(models.Model):
    item = models.OneToOneField("Item", on_delete=models.CASCADE)
    main_order = models.PositiveIntegerField(default=0, blank=False, null=False)

    class Meta:
        # First sort by category, then by main_order
        ordering = ("item__category", "main_order")
        # Ensure no duplicate order values within the same category
        constraints = [
            models.UniqueConstraint(
                fields=["item__category", "main_order"],
                name="unique_order_per_category"
            )
        ]

    def __str__(self):
        return self.item.title

    def reorder(self):
        # Get all unique categories from Items
        unique_categories = Item.objects.values_list("category", flat=True).distinct()
        
        for category in unique_categories:
            # Fetch all Ordering entries for this category, ordered by current main_order
            category_orderings = Ordering.objects.filter(
                item__category=category
            ).order_by("main_order")
            
            # Reset order numbers starting from 1
            for idx, ordering_obj in enumerate(category_orderings, 1):
                ordering_obj.main_order = idx
            
            # Bulk update to avoid multiple DB hits
            Ordering.objects.bulk_update(category_orderings, fields=["main_order"])

    def save(self, *args, **kwargs):
        super().save(*args, **kwargs)
        self.reorder()

Configure Django Admin for Sortable2 #

To let users sort items per category in the Admin, use SortableAdminMixin and add a category filter so users can isolate items from a single category before sorting:

from django.contrib import admin
from adminsortable2.admin import SortableAdminMixin
from .models import Ordering, Item

class OrderingAdmin(SortableAdminMixin, admin.ModelAdmin):
    list_display = ("item", "main_order", "get_category")
    list_filter = ("item__category",)

    # Helper method to display the item's category in the list
    def get_category(self, obj):
        return obj.item.category
    get_category.short_description = "Category"

    def get_queryset(self, request):
        # Ensure the list is ordered by category first, then sort order
        return super().get_queryset(request).order_by("item__category", "main_order")

admin.site.register(Ordering, OrderingAdmin)

Now users can:

• Use the category filter to show only items from a specific category
• Drag and drop items to reorder them within that category
• The reorder method will automatically reset the order numbers for that category only

2. Bulk Editing Items with the Same Specific Field Value (e.g., Category) #

Yes, you can absolutely do this in Django Admin—here are two straightforward methods:

Method 1: Use Django's Built-in Bulk Actions #

Add a custom bulk action to your ItemAdmin class. Users can first filter items by category, select the ones they want, and run the action:

from django.contrib import admin
from .models import Item

class ItemAdmin(admin.ModelAdmin):
    list_display = ("title", "category", "your_field_to_update")
    list_filter = ("category",)
    # Register your custom bulk action
    actions = ["bulk_update_target_field"]

    def bulk_update_target_field(self, request, queryset):
        # Example: Set a specific field to a new value for all selected items
        # For dynamic input, you can add a custom form (see note below)
        updated_count = queryset.update(your_field_to_update="new_desired_value")
        self.message_user(request, f"Successfully updated {updated_count} items!")
    
    # Set a user-friendly name for the action
    bulk_update_target_field.short_description = "Bulk update 'your_field_to_update' for selected items"

admin.site.register(Item, ItemAdmin)

Pro Tip: If you need users to input the new value dynamically (instead of hardcoding it), you can build a custom form for the bulk action to collect input before applying changes.

Method 2: Batch Update All Items in a Category #

If you want to update every item in a category without selecting them one by one:

1. Go to the Item list page
2. Use the category filter to show only items from your target category
3. Select all items using the top checkbox in the list header
4. Run your custom bulk action from the dropdown menu

This works because the bulk action will only apply to the filtered subset of items.

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