Das deutsche Python-Forum

Code: Alles auswählen

from django.db import models

class Produkt(models.Model):
    name = models.CharField(max_length=30)
    beschreibung = models.TextField()

    class Meta:
        verbose_name = "Produkt"
        verbose_name_plural = "Produkte"

    def __unicode__(self):
    	return self.name

class Anbieter(models.Model):
    name = models.CharField(max_length=30)

    class Meta:
        verbose_name = "Anbieter"
        verbose_name_plural = "Anbieter" 

    def __unicode__(self):
        return self.name

class Marke(models.Model):
    name = models.CharField(max_length=30)

    class Meta: 
        verbose_name = "Marke"
        verbose_name_plural = "Marken"

    def __unicode__(self):
        return self.name

class Angebot(models.Model):
    produkt = models.ForeignKey(Produkt)
    anbieter = models.ForeignKey(Anbieter)
    marke = models.ForeignKey(Marke)
    preis = models.DecimalField(max_digits=5, decimal_places=2)

    class Meta:
        verbose_name = "Angebot" 
        verbose_name_plural = "Angebote"

    def __unicode__(self):
        return unicode(self.produkt)

Code: Alles auswählen

{% extends "base.html" %}

{% block titel %}{{ block.super }} - Index{% endblock %}
{% block inhalt %}
	{% if object_list %}
		<table style="text-align: center;">
			<tr>
				<th>Produkt</th>
				{% for object in object_list %}
				<th>{{ object.anbieter }}</th>
				{% endfor %}
			</tr>
			{% for object in object_list %}
			<tr>
				<td>{{ object.produkt }}</td>
			{% for object in object_list %}
				<td>{{ object.preis }} €</td>
			{% endfor %}
			</tr>
			{% endfor %}
		</table>
	{% endif %}
{% endblock %}

Code: Alles auswählen

info_dict = {
    'queryset': Angebot.objects.all(),
}


urlpatterns = patterns('',
    url(r'^index/$', 'django.views.generic.list_detail.object_list', 
        dict(info_dict, template_name='preisvergleich/index.html')),    
)

Code: Alles auswählen

{% regroup object_list by produkt as produkt_list %}

<table style="text-align: center;">
			<tr>
				<th>Produkt</th>
				{% for object in object_list %}
				<th>{{ object.anbieter }}</th>
				{% endfor %}
			</tr>

{% for produkt in produkt_list %}
<tr>
	<td>{{ produkt.grouper }}</td>
        {% for item in produkt.list %}
        <td>{{ item.preis }}</td>
        {% endfor %}
    </tr>
{% endfor %}
</table>