Vfrdtyky

I'm Trying to perform a query that uses annotation. But the problem is I need to annotate for 2 values without having the item showed 2 times in my template .. here are the files for a better understanding.

Those are the models I use:

class Daily(models.Model):

        date = models.DateTimeField(auto_now=True)

        text = models.CharField(max_length=80)  #

        maden = models.IntegerField(default=0)  #

        maden_from_type = models.ForeignKey(Type, on_delete=CASCADE, blank=True, null=True)

        maden_from_cat = models.ForeignKey(Category, on_delete=CASCADE, blank=True, null=True)

        da2en = models.IntegerField(default=0)  

        da2en_from_type = models.ForeignKey(Type, on_delete=CASCADE, related_name='da2en_from_type', blank=True, null=True)

        da2en_from_cat = models.ForeignKey(Category, on_delete=CASCADE, related_name='da2en_from_cat', blank=True,

                                           null=True)

        farm = models.ForeignKey(Farm, on_delete=CASCADE)  

        is_invoice = models.BooleanField(default=False)  



class Type(models.Model):

    type_name = models.CharField(max_length=80)



    def __str__(self):

        return self.type_name





class Category(models.Model):

    category_name = models.CharField(max_length=80)

    type = models.ForeignKey(Type, on_delete=CASCADE)



    def __str__(self):

        return self.category_name

And that is how I tried to execute the annotate in the views:

def mezan(request):

    all_daily = Daily.objects.values('da2en_from_cat__category_name', 'maden_from_cat__category_name').annotate(

        all_maden=Sum('maden',distinct=True)).annotate(

        all_da2en=Sum('da2en',distinct=True))

    context = {

        'all_daily': all_daily,

    }

    return render(request, 'mezan.html', context)

Finally, when I try to view it in my HTML templates, it duplicates the item if it has value in both annotated fields.

 {% for item in all_daily %}

  <tr>

      <td>{{item.da2en_from_cat__category_name}}</td>

      <td>{{item.all_da2en}}</td>

      <td">{{item.all_maden}}</td>

  </tr>

 {% endfor %}

I need to show it once with the 2 values being displayed. But it is being shown twice with one value for each

Image for the result