Форум сайта python.su
Имеем модель
class NewTicket(models.Model): Operator = models.CharField(max_length=50,verbose_name='Оператор') DateW = models.DateTimeField(auto_now_add=True,blank=True,verbose_name='Дата создания') Lic = models.IntegerField(max_length=5,verbose_name='Лицевой счет',blank=True) Adress = models.CharField(max_length=50,verbose_name='Адрес') Telefon = models.CharField(max_length=20,verbose_name='Телефон',blank=True) Problem = models.CharField(max_length=200,verbose_name='Описание проблемы') Arhiwes = models.BooleanField(default=False)
def Showtable(request): Zaiavki = NewTicket.objects.filter(Arhiwes__icontains=0).order_by('-DateW') // Главная таблица Colish = NewTicket.objects.filter(Arhiwes__icontains=0).__len__() Countec = NewTicket.objects.values('Lic').annotate(count=Count('id')).filter(Arhiwes=True)//Таблица повторяющихся лицевых счетов return direct_to_template(request,'1maintable.html',{'Zaiavki':Zaiavki,'Colish':Colish,'Countec':Countec})
{% for opera in Zaiavki %} <tr> <td>{{ opera.Operator }}</td> <td ALIGN="center">{{ opera.DateW|date:"j D b" }}</td> <td ALIGN="center">{{ opera.DateW|date:"f" }}</td> <td ALIGN="center">{{ opera.Lic }}</td> <td ALIGN="center">{{ opera.Adress }}</td> <td ALIGN="center">{{ opera.Telefon }}</td> <td ALIGN="right">{{ opera.Problem }}</td> {% for inside in Countec %} {% if opera.Lic == inside.Lic %} <td>{{ inside.count }}</td> {% else %} <td>0</td> {% endif %} {% endfor %}
Отредактировано Jeck290 (Янв. 28, 2013 19:50:23)
Офлайн