如何通过单模型类在单个视图中展示多表数据并分Div显示？

Hey there! I’ll walk you through how to solve both of your requirements—assuming you’re working with Django (since you mentioned model classes and views; if you’re using another framework, let me know and I can adjust the examples!). Let’s dive in:

You don’t need to create a single "super model" that covers multiple database tables. Instead, the cleanest approach is to encapsulate multiple model data in a view-layer class (a "view model") or directly pass multiple querysets to your template. Here are two common scenarios:

Scenario 1: Custom View Model Class (for unified logic) #

If you need to add shared processing logic across multiple models, create a plain Python class (not a Django Model) to wrap your data and methods. For example, if you have Product and Category models:

# myapp/view_models.py
class ProductCategoryViewModel:
    def __init__(self):
        self.products = Product.objects.all()
        self.categories = Category.objects.all()
    
    def get_featured_products(self):
        # Custom logic: Filter featured products
        return self.products.filter(is_featured=True).order_by('-created_at')

Then use this class in your view to pass data to the template:

# myapp/views.py
from django.views.generic import TemplateView
from .view_models import ProductCategoryViewModel

class MultiModelView(TemplateView):
    template_name = 'multi_model.html'
    
    def get_context_data(self, **kwargs):
        context = super().get_context_data(**kwargs)
        # Instantiate the view model and add to context
        context['view_model'] = ProductCategoryViewModel()
        return context

In your template, you can call the view model’s methods and access its data:

<!-- templates/multi_model.html -->
<h2>Featured Products</h2>
{% for product in view_model.get_featured_products %}
    <div class="product-item">
        {{ product.name }} - ${{ product.price }}
    </div>
{% endfor %}

<h2>All Categories</h2>
{% for category in view_model.categories %}
    <div class="category-item">{{ category.name }}</div>
{% endfor %}

Scenario 2: Directly Pass Multiple Querysets (simple use cases) #

If you don’t need extra logic, just pass individual querysets directly to the template context—this is the most straightforward approach:

# myapp/views.py
from django.views.generic import TemplateView
from .models import Product, Category, Order

class SimpleMultiModelView(TemplateView):
    template_name = 'simple_multi.html'
    
    def get_context_data(self, **kwargs):
        context = super().get_context_data(**kwargs)
        # Add data from multiple tables to context
        context['products'] = Product.objects.all()
        context['categories'] = Category.objects.filter(is_active=True)
        context['user_orders'] = Order.objects.filter(user=self.request.user)
        return context

Then reference each variable directly in your template.

This builds on the first requirement—you just need to structure your template to render each dataset in a separate <div>. Here’s a complete example:

Step 1: Prepare Data in Your View #

First, fetch data from multiple tables and add them to the context:

# myapp/views.py
from django.views.generic import TemplateView
from .models import Product, Category, Order

class MultiDivView(TemplateView):
    template_name = 'multi_div.html'
    
    def get_context_data(self, **kwargs):
        context = super().get_context_data(**kwargs)
        # Fetch targeted data from different tables
        context['latest_products'] = Product.objects.order_by('-created_at')[:5]
        context['popular_categories'] = Category.objects.filter(is_popular=True)
        context['recent_orders'] = Order.objects.filter(user=self.request.user).order_by('-order_date')[:3]
        return context

Step 2: Render Each Dataset in a Separate Div #

In your template, create distinct <div> containers for each dataset:

<!-- templates/multi_div.html -->
<!-- Div 1: Latest Products -->
<div class="latest-products">
    <h3>Latest Products</h3>
    {% for product in latest_products %}
        <div class="product-card">
            <h4>{{ product.name }}</h4>
            <p>Price: ${{ product.price }}</p>
        </div>
    {% empty %}
        <p>No new products available.</p>
    {% endfor %}
</div>

<!-- Div 2: Popular Categories -->
<div class="popular-categories">
    <h3>Popular Categories</h3>
    {% for category in popular_categories %}
        <span class="category-tag">{{ category.name }}</span>
    {% empty %}
        <p>No popular categories right now.</p>
    {% endfor %}
</div>

<!-- Div 3: Recent Orders -->
<div class="recent-orders">
    <h3>Your Recent Orders</h3>
    {% for order in recent_orders %}
        <div class="order-item">
            <p>Order #{{ order.id }} | {{ order.order_date|date:"M d, Y" }}</p>
            <p>Total: ${{ order.total_amount }}</p>
        </div>
    {% empty %}
        <p>You haven't placed any orders yet.</p>
    {% endfor %}
</div>

Quick Tips: #

• Optimize Queries: If you’re fetching related data (e.g., products with their categories), use select_related or prefetch_related to avoid the N+1 query problem.
• Function-Based Views: If you’re using function-based views instead of class-based, the logic is similar—just pass your querysets/view model via the render() function’s context argument.

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