一个使用flask+bootstrap为框架开发的一个小型的学习网站，功能有待完善

from collections import defaultdict, OrderedDict from datetime import datetime, timedelta from flask import Blueprint, render_template, jsonify, session, request from pyecharts.charts import Bar, Line, Pie, Scatter, Geo, Timeline from pyecharts import options as opts from pyecharts.globals import ChartType, ThemeType from pyecharts.options import InitOpts from main import inject_article_type, inject_tools_type from model.article import Article from model.chatroom import Message from model.comment import Comment from model.favorite import Favorite from model.tb_follow import Follow from model.tools import Tools from model.user_shezhi import Shezhi from model.users import Users py_echarts = Blueprint('py_echarts', __name__) from flask import Flask, render_template # 获取文章类型和对应数量的字典 def get_article_type_counts(): article = Article() # 创建Article类的实例 article_types = inject_article_type()['article_type'] type_counts = {} # 遍历所有文章类型 for type_key, type_name in article_types.items(): # 调用count_by_type函数获取每种类型的数量 count = article.count_by_type(type_key) # 将类型和数量添加到字典中 type_counts[type_name] = count return type_counts def pie_rosetype_admin() -> Pie: type_counts = get_article_type_counts() # 获取文章类型和对应数量的字典 labels = list(type_counts.keys()) # 获取标签（文章类型名称） values = list(type_counts.values()) # 获取值（对应数量） c = ( Pie() .add( "", list(zip(labels, values)), radius=["30%", "70%"], center=["50%", "50%"], rosetype="area", ) ) return c @py_echarts.route("/py_echarts/pie-article-admin") def get_pie_chart_admin(): c = pie_rosetype_admin() return c.dump_options_with_quotes() # 用户的文章条形图 @py_echarts.route("/py_echarts/bar-article-user", methods=["POST", "GET"]) def get_bar_chart_user(): userid = request.form.get("userid") article = Article() favorite = Favorite() comment = Comment() favorite_count = favorite.query_my_favorite_count(userid) favorited_count = favorite.query_my_article_favorited_count(userid) article_count = article.get_count_user_except_drafted(userid) drafted_count = article.get_count_user_drafted(user_id=userid) comment_count = comment.query_comments_count_by_userid(userid) commented_count = comment.query_comments_count_by_articleid(userid) read_count = article.get_readcount_by_user(userid) recommend_count = article.query_recommend_count_by_user(userid) hide_count = article.query_hide_count_by_user(userid) # 设置条形图的标签和值 bar = ( Bar() .add_xaxis( ["收藏数", "被收藏数", "文章数", "草稿数", "评论数", "被评论数", "阅读数", "推荐数", "隐藏数"]) # x轴标签 .add_yaxis("用户文章信息", [favorite_count, favorited_count, article_count, drafted_count, comment_count, commented_count, read_count, recommend_count, hide_count] , itemstyle_opts=opts.ItemStyleOpts(color="#749f83")) # y轴值，对应上面的标签 ) return bar.dump_options_with_quotes() # 用户的关注条形图 @py_echarts.route("/py_echarts/bar-followed-user", methods=["POST", "GET"]) def get_bar_followed_user(): userid = request.form.get("userid") follow = Follow() follow_count = follow.get_follow_by_userid_count(userid) followed_count = follow.get_followed_user_count(userid) mutal_follow_count = follow.get_mutal_follow_count(userid) # 设置条形图的标签和值 bar = ( Bar() .add_xaxis( ["关注用户数量", "被关注数量", "互相关注数量"]) # x轴标签 .add_yaxis("用户文章信息", [follow_count, followed_count, mutal_follow_count] , itemstyle_opts=opts.ItemStyleOpts(color="#008000")) # y轴值，对应上面的标签 ) return bar.dump_options_with_quotes() # 用户的交流条形图 @py_echarts.route("/py_echarts/bar-communicate-user", methods=["POST", "GET"]) def get_bar_communicate_user(): userid = request.form.get("userid") message = Message() message_duo_count = message.get_messagesduo_user_count(userid) message_one_count = message.get_messagesone_user_count(userid) sixin_count = message.get_sixin_user_count(userid) # 设置条形图的标签和值 bar = ( Bar() .add_xaxis( ["公共聊天数量", "一对一聊天数量", "私信数量"]) # x轴标签 .add_yaxis("用户交流信息", [message_duo_count, message_one_count, sixin_count] , itemstyle_opts=opts.ItemStyleOpts(color="#FF0000")) # y轴值，对应上面的标签 ) return bar.dump_options_with_quotes() # 网站的交流条形图 @py_echarts.route("/py_echarts/bar-communicate-admin", methods=["POST", "GET"]) def get_bar_communicate_admin(): message = Message() message_duo_count = message.get_messagesduo_all_count() message_one_count = message.get_messagesone_all_count() message_zong_count = message.get_messages_all_count() # 设置条形图的标签和值 bar = ( Bar() .add_xaxis( ["公共聊天数量", "一对一聊天数量", "信息总量"]) # x轴标签 .add_yaxis("网站交流信息", [message_duo_count, message_one_count, message_zong_count] , itemstyle_opts=opts.ItemStyleOpts(color="#FF0000")) # y轴值，对应上面的标签 ) return bar.dump_options_with_quotes() # 网站的文章条形图 @py_echarts.route("/py_echarts/bar-article-admin") def get_bar_chart_admin(): article = Article() favorite = Favorite() comment = Comment() article_count = article.get_count_all_except_drafted() drafted_count = article.get_count_all_drafted() favorited_count = favorite.query_all_favorited_count() # read_count = article.get_readcount_by_all() hide_count = article.query_hide_count_by_all() recommend_count = article.query_recommend_count_by_all() comment_count = comment.query_comments_count_by_all() # 设置条形图的标签和值 bar = ( Bar() .add_xaxis( ["文章总量", "草稿总量", "被收藏文章总量", "被隐藏文章总量", "被推荐文章总量", "评论总量"]) # x轴标签 .add_yaxis("用户文章信息", [article_count, drafted_count, favorited_count, hide_count, recommend_count, comment_count] , itemstyle_opts=opts.ItemStyleOpts(color="#749f83")) # y轴值，对应上面的标签 ) return bar.dump_options_with_quotes() # 用户的文章饼图 @py_echarts.route("/py_echarts/pie-article-user", methods=['POST', "GET"]) def get_pie_chart_user(): userid = request.form.get("userid") article = Article() # 创建Article类的实例 article_types = inject_article_type()['article_type'] type_counts = {} # 遍历所有文章类型 for type_key, type_name in article_types.items(): # 调用count_by_type_user函数获取每种类型的数量 count = article.count_by_type_user(type_key, userid) # 将类型和数量添加到字典中 type_counts[type_name] = count labels = list(type_counts.keys()) # 获取标签（文章类型名称） values = list(type_counts.values()) # 获取值（对应数量） c = ( Pie() .add( "", list(zip(labels, values)), radius=["30%", "70%"], center=["50%", "50%"], rosetype="area", ) ) return c.dump_options_with_quotes() # 用户的工�