- category.factor = '%.2f' % (minimum_factor + (float(category.click_count) / all_tag_clicks_count))
- for tag in [t for t in context['tags'] if t.category]:
- category = annotated_categories[tag.category.id]
- tag.factor = '%.2f' % (minimum_factor + ((float(tag.click_count) / category.click_count) if category.click_count else 0))
-
+ category.cloud_size = get_cloud_size(category.click_count, all_tags_click_count)
+
+ # This wouldn't happen if we were using taggit without generic relations.
+ tags = Tag.objects.raw("""
+ SELECT t.category_id, t.click_count, t.id, t.name, t.slug, count(t.id) AS c
+ FROM questions_tag t
+ LEFT JOIN questions_tagcategory c ON c.id=t.category_id
+ LEFT JOIN questions_tagitem i ON i.tag_id=t.id
+ LEFT JOIN questions_question q ON q.id=i.object_id
+ WHERE q.published
+ GROUP BY t.category_id, t.click_count, t.id, t.name, t.slug, c.slug
+ ORDER BY c.slug, c DESC, t.slug
+ """)
+ uncategorized_tags_click_count = Tag.objects.filter(category=None).aggregate(models.Sum('click_count'))['click_count__sum']
+ for tag in tags:
+ if tag.category:
+ category_click_count = annotated_categories[tag.category.id].click_count
+ else:
+ category_click_count = uncategorized_tags_click_count
+ tag.cloud_size = get_cloud_size(tag.click_count, category_click_count)
+ context['tag_lists'].setdefault(tag.category.id if tag.category else 0, []).append(tag)
+ context['has_uncategorized_tags'] = 0 in context['tag_lists']
+