import json

from django.http import JsonResponse
from django.shortcuts import render, HttpResponse
from django.db.models import Count
from pyecharts.charts import Funnel, Pie, Bar
import pyecharts.options as opts

from comment.models import Comment
from article.models import *


# Create your views here.

def chart_view(request):
    return render(request, "data_analysis/data_view.html")


# 分析评论最多的文章
def most_comment_article(request):
    comment_count = Article.objects.annotate(comment_count=Count("band_object")).order_by('-comment_count')[0:5]
    comment_count = [[article.title, article.comment_count] for article in comment_count]
    c = (
        Funnel()
        .add(
            series_name="",
            data_pair=comment_count,
            gap=2,
            label_opts=opts.LabelOpts(
                is_show=True,
                position="inside",
                formatter="{c}",
                font_size=18
            ),
            tooltip_opts=opts.TooltipOpts(trigger="item", formatter="{b} : {c}"),
        )
        .set_global_opts(
            legend_opts=opts.LegendOpts(pos_top="92%", orient="horizontal"),
            title_opts=opts.TitleOpts(
                title="文章评论数量排行榜",
                pos_left="center",  # 标题的位置
                pos_top="0px",
                title_textstyle_opts=opts.TextStyleOpts(
                    font_size=32,  # 大小
                    font_weight="bold",  # 加粗与否
                    font_family="Arial",  # 字体：Arial、Times New Roman、FangSong、KaiTi
                    font_style="normal",  # 斜体、下划线、正常  italic
                ),
            )
        )
        .set_series_opts(

        )
        .dump_options_with_quotes()
    )
    return JsonResponse(json.loads(c))


# 分析各个分类的文章数目
def cate_articles_per(request):
    cate_articles = Category.objects.annotate(cate_articles=Count("article_category")).order_by("-cate_articles")
    cate_articles = [[cate.name, cate.cate_articles] for cate in cate_articles]
    c = (
        Pie()
        .add(
            "",
            cate_articles,
            label_opts=opts.LabelOpts(
                is_show=True,
                # position="inside",
                formatter="{b}:{c}",
                font_size=18
            ),
        )
        .set_global_opts(
            legend_opts=opts.LegendOpts(pos_top="92%", orient="horizontal"),
            title_opts=opts.TitleOpts(
                title="文章分类数量占比",
                pos_left="center",  # 标题的位置
                pos_top="0px",
                title_textstyle_opts=opts.TextStyleOpts(
                    font_size=32,  # 大小
                    font_weight="bold",  # 加粗与否
                    font_family="Arial",  # 字体：Arial、Times New Roman、FangSong、KaiTi
                    font_style="normal",  # 斜体、下划线、正常  italic
                ),
            )
        )
        .dump_options_with_quotes()
    )
    return JsonResponse(json.loads(c))


# 分析各个标签的文章数目
def article_views_rank(request):
    article_views = Article.objects.order_by("-article_views")[:5]
    article_title_list = [article.title for article in article_views]
    article_views_list = [article.article_views for article in article_views]
    c = (
        Bar()
        .add_xaxis(article_title_list)
        .add_yaxis("", article_views_list)
        .reversal_axis()
        .set_series_opts(label_opts=opts.LabelOpts(position="right"))
        .set_global_opts(
            yaxis_opts=opts.AxisOpts(is_inverse=True),
            legend_opts=opts.LegendOpts(is_show=True),
            title_opts=opts.TitleOpts(
                title="文章浏览量排行榜",
                pos_left="center",  # 标题的位置
                pos_top="0px",
                title_textstyle_opts=opts.TextStyleOpts(
                    font_size=32,  # 大小
                    font_weight="bold",  # 加粗与否
                    font_family="Arial",  # 字体：Arial、Times New Roman、FangSong、KaiTi
                    font_style="normal",  # 斜体、下划线、正常  italic
                ),
            )
        )
        .dump_options_with_quotes()
    )
    return JsonResponse(json.loads(c))