X-Git-Url: https://git.mdrn.pl/wolnelektury.git/blobdiff_plain/3c1ae530b8e124a1451574e2bf8e2b2bf673c3b8..4faaa8414a1038804df9999a094c8dfe4c5f513f:/src/reporting/views.py diff --git a/src/reporting/views.py b/src/reporting/views.py index 963440cd8..553371efe 100644 --- a/src/reporting/views.py +++ b/src/reporting/views.py @@ -1,16 +1,14 @@ -# -*- coding: utf-8 -*- -# This file is part of Wolnelektury, licensed under GNU Affero GPLv3 or later. -# Copyright © Fundacja Nowoczesna Polska. See NOTICE for more information. +# This file is part of Wolne Lektury, licensed under GNU Affero GPLv3 or later. +# Copyright © Fundacja Wolne Lektury. See NOTICE for more information. # import os.path from datetime import date from django.conf import settings from django.contrib.admin.views.decorators import staff_member_required from django.db.models import Count -from django.shortcuts import render_to_response -from django.template import RequestContext +from django.shortcuts import render -from catalogue.models import Book, BookMedia +from catalogue.models import Book, BookMedia, Tag from reporting.utils import render_to_pdf, render_to_csv, generated_file_view @@ -26,14 +24,50 @@ def stats_page(request): else: mt['deprecated'] = '-' - licenses = set( - (b.extra_info.get('license'), b.extra_info.get('license_description')) - for b in Book.objects.all().iterator() if b.extra_info.get('license')) + licenses = set() + for b in Book.objects.all().iterator(): + extra_info = b.get_extra_info_json() + if extra_info.get('license'): + licenses.add((extra_info.get('license'), extra_info.get('license_description'))) - return render_to_response('reporting/main.html', { + etags = [] + all_books = Book.objects.all() + all_books_count = all_books.count() + noparent_books = Book.objects.filter(children=None) + noparent_books_count = noparent_books.count() + for field in Book._meta.fields: + if not getattr(field, 'with_etag', None): continue + etag = field.get_current_etag() + d = { + 'field': field.name, + 'etag': etag, + } + if field.for_parents: + books = all_books + n_books = all_books_count + else: + books = noparent_books + n_books = noparent_books_count + tags = books.values_list(field.etag_field.name).order_by( + '-' + field.etag_field.name).distinct().annotate(c=Count('*')) + d['tags'] = [ + { + 'tag': t[0], + 'count': t[1], + 'perc': round(100 * t[1] / n_books, 2) + } + for t in tags + ] + etags.append(d) + + unused_tags = Tag.objects.exclude(category='set').filter(items=None, book=None) + + return render(request, 'reporting/main.html', { 'media_types': media_types, 'licenses': licenses, - }, context_instance=RequestContext(request)) + 'etags': etags, + 'unused_tags': unused_tags, + }) @generated_file_view('reports/katalog.pdf', 'application/pdf',