# -*- coding: utf-8 -*-
from io import BytesIO
import base64
import collections
import json
from django.shortcuts import render
import re
import matplotlib.pyplot as plt
import matplotlib.pyplot as plt1
import matplotlib.pyplot as plt2
import matplotlib.pyplot as plt3
from account.models import Profile
from competition.models import BankInfo, CompetitionKindInfo, CompetitionQAInfo,ChoiceInfo

from utils.decorators import check_copstatus, check_login
from utils.errors import (BankInfoNotFound, CompetitionNotFound,
                          ProfileNotFound, QuestionLogNotFound,

                          QuestionNotSufficient)
from utils.redis.rpageconfig import get_pageconfig, get_form_regex
from utils.redis.rprofile import get_enter_userinfo
from utils.redis.rrank import get_rank, get_rank_data

import datetime

def home(request):
    """
    比赛首页首页视图
    :param request: 请求对象
    :return: 渲染视图: user_info: 用户信息; kind_info: 比赛信息;is_show_userinfo: 是否展示用户信息表单;user_info_has_entered: 是否已经录入表单;
             userinfo_fields: 表单字段;option_fields: 表单字段中呈现为下拉框的字段;
    """
    uid = request.GET.get('uid', '')  # 获取uid
    kind_id = request.GET.get('kind_id', '')  # 获取kind_id
    created = request.GET.get('created', '0')  # 获取标志位，以后会用到
    try:  # 获取比赛数据
        kind_info = CompetitionKindInfo.objects.get(kind_id=kind_id)
    except CompetitionKindInfo.DoesNotExist:  # 不存在渲染错误视图
        return render(request, 'err.html', CompetitionNotFound)
    try:  # 获取题库数据
        bank_info = BankInfo.objects.get(bank_id=kind_info.bank_id)
    except BankInfo.DoesNotExist:  # 不存在渲染错误视图
        return render(request, 'err.html', BankInfoNotFound)
    try:  # 获取用户数据
        profile = Profile.objects.get(uid=uid)
    except Profile.DoesNotExist:  # 不存在渲染错误视图
        return render(request, 'err.html', ProfileNotFound)
    if kind_info.question_num > bank_info.total_question_num:  # 比赛出题数量是否小于题库总大小
        return render(request, 'err.html', QuestionNotSufficient)
    show_info = get_pageconfig(kind_info.app_id).get('show_info', {})  # 从redis获取页面配置信息
    is_show_userinfo = show_info.get('is_show_userinfo', False)  # 页面配置信息，用来控制答题前是否展示一张表单
    form_fields = collections.OrderedDict()  # 生成一个有序的用来保存表单字段的字典
    form_regexes = []  # 生成一个空的正则表达式列表
    if is_show_userinfo:
        userinfo_fields = show_info.get('userinfo_fields', '').split('#')  # 从页面配置中获取userinfo_fields
        for i in userinfo_fields:  # 将页面配置的每个正则表达式取出来放入正则表达式列表
            form_regexes.append(get_form_regex(i))
        userinfo_field_names = show_info.get('userinfo_field_names', '').split('#')
        for i in range(len(userinfo_fields)):  # 将每个表单字段信息保存到有序的表单字段字典中
            form_fields.update({userinfo_fields[i]: userinfo_field_names[i]})
    return render(request, 'competition/index.html', {  # 渲染页面
        'user_info': profile.data,
        'kind_info': kind_info.data,
        'bank_info': bank_info.data,
        'is_show_userinfo': 'true' if is_show_userinfo else 'false',
        'userinfo_has_enterd': 'true' if get_enter_userinfo(kind_id, uid) else 'false',
        'userinfo_fields': json.dumps(form_fields) if form_fields else '{}',
        'option_fields': json.dumps(show_info.get('option_fields', '')),
        'field_regexes': form_regexes,
        'created': created
    })


def games(request, s):
    """
    获取所有比赛接口
    :param request: 请求对象
    :param s: 请求关键字
    :return: 返回该请求关键字对应的所有比赛类别
    """

    if s == 'hot':
        # 筛选条件: 完成时间大于当前时间;根据参与人数降序排序;根据创建时间降序排序;筛选10个
        kinds = CompetitionKindInfo.objects.filter(
            cop_finishat__gt=datetime.datetime.now(tz=datetime.timezone.utc),
        ).order_by('-total_partin_num').order_by('-created_at')[:10]

    elif s == 'tech':
        kinds = CompetitionKindInfo.objects.filter(
            kind_type=CompetitionKindInfo.IT_ISSUE,
            cop_finishat__gt=datetime.datetime.now(tz=datetime.timezone.utc)
        ).order_by('-total_partin_num').order_by('-created_at')

    elif s == 'edu':
        kinds = CompetitionKindInfo.objects.filter(
            kind_type=CompetitionKindInfo.EDUCATION,
            cop_finishat__gt=datetime.datetime.now(tz=datetime.timezone.utc)
        ).order_by('-total_partin_num').order_by('-created_at')

    elif s == 'culture':
        kinds = CompetitionKindInfo.objects.filter(
            kind_type=CompetitionKindInfo.CULTURE,
            cop_finishat__gt=datetime.datetime.now(tz=datetime.timezone.utc)
        ).order_by('-total_partin_num').order_by('-created_at')

    elif s == 'sport':
        kinds = CompetitionKindInfo.objects.filter(
            kind_type=CompetitionKindInfo.SPORT,
            cop_finishat__gt=datetime.datetime.now(tz=datetime.timezone.utc)
        ).order_by('-total_partin_num').order_by('-created_at')

    elif s == 'general':
        kinds = CompetitionKindInfo.objects.filter(
            kind_type=CompetitionKindInfo.GENERAL,
            cop_finishat__gt=datetime.datetime.now(tz=datetime.timezone.utc)
        ).order_by('-total_partin_num').order_by('-created_at')

    elif s == 'interview':
        kinds = CompetitionKindInfo.objects.filter(
            kind_type=CompetitionKindInfo.INTERVIEW,
            cop_finishat__gt=datetime.datetime.now(tz=datetime.timezone.utc)
        ).order_by('-total_partin_num').order_by('-created_at')
    
    else:
        kinds = None
    return render(request, 'competition/games.html', {
        'kinds': kinds,
    })

@check_login
@check_copstatus
def game(request):
    """
    返回比赛题目信息的视图
    :param request: 请求对象
    :return: 渲染视图: user_info: 用户信息;kind_id: 比赛唯一标识;kind_name: 比赛名称;cop_finishat: 比赛结束时间;rule_text: 大赛规则;
    """

    uid = request.GET.get('uid', '')  # 获取uid
    kind_id = request.GET.get('kind_id', '')  # 获取kind_id
    try:  # 获取比赛信息
        kind_info = CompetitionKindInfo.objects.get(kind_id=kind_id)
    except CompetitionKindInfo.DoesNotExist:  # 未获取到渲染错误视图
        return render(request, 'err.html', CompetitionNotFound)
    try:  # 获取题库信息
        bank_info = BankInfo.objects.get(bank_id=kind_info.bank_id)
    except BankInfo.DoesNotExist:  # 未获取到，渲染错误视图
        return render(request, 'err.html', BankInfoNotFound)
    try:  # 获取用户信息
        profile = Profile.objects.get(uid=uid)
    except Profile.DoesNotExist: # 未获取到，渲染错误视图
        return render(request, 'err.html', ProfileNotFound)
    if kind_info.question_num > bank_info.total_question_num: # 检查题库大小
        return render(request, 'err.html', QuestionNotSufficient)
    pageconfig = get_pageconfig(kind_info.app_id)  # 获取页面配置信息
    return render(request, 'competition/game.html', {  # 渲染视图信息
        'user_info': profile.data,
        'kind_id': kind_info.kind_id,
        'kind_name': kind_info.kind_name,
        'cop_finishat': kind_info.cop_finishat,
        'period_time': kind_info.period_time,
        'rule_text': pageconfig.get('text_info', {}).get('rule_text', '')
    })

@check_login
def result(request):
    """
    比赛结果和排行榜的视图
    :param request: 请求对象
    :return: 渲染视图: qa_info: 答题记录数据;user_info: 用户信息数据;kind_info: 比赛信息数据;rank: 该用户当前比赛排名
    """
    a=0
    c=0
    uid = request.GET.get('uid', '')
    kind_id = request.GET.get('kind_id', '')
    qa_id = request.GET.get('qa_id', '')
    try:
        qa_info1= CompetitionQAInfo.objects.filter(kind_id=kind_id)
              
    except Profile.DoesNotExist:
          return render(request, 'err.html', ProfileNotFound)
    try:
        profile = Profile.objects.get(uid=uid)
    except Profile.DoesNotExist:
        return render(request, 'err.html', ProfileNotFound)

    try:
        kind_info = CompetitionKindInfo.objects.get(kind_id=kind_id)
    except CompetitionKindInfo.DoesNotExist:
        return render(request, 'err.html', CompetitionNotFound)

    try:
        qa_info = CompetitionQAInfo.objects.get(qa_id=qa_id, uid=uid)
    except CompetitionQAInfo.DoesNotExist:
        return render(request, 'err.html', QuestionLogNotFound)
    for i in qa_info1:
      a=a+i.pingjunnandu*i.score/2
      c=c+1
    a=a/c
    d= qa_info.score-a
    c=abs (d)
    return render(request, 'competition/result.html', {
        'qa_info': qa_info.detail,
        'user_info': profile.data,
        'kind_info': kind_info.data,
        'rank': get_rank(kind_id, uid),
        'd':c
    })


@check_login
def rank(request):
    """
    排行榜数据视图
    :param request: 请求对象
    :return: 渲染视图: user_info: 用户信息;kind_info: 比赛信息; rank: 所有比赛排名;
    """

    uid = request.GET.get('uid', '')
    kind_id = request.GET.get('kind_id', '')
   
    try:
        profile = Profile.objects.get(uid=uid)
    except Profile.DoesNotExist:
        return render(request, 'err.html', ProfileNotFound)
  
    try:
        kind_info = CompetitionKindInfo.objects.get(kind_id=kind_id)
    except CompetitionKindInfo.DoesNotExist:
        return render(request, 'err.html', CompetitionNotFound)

    ranks, rank_data = get_rank_data(kind_id)
    for i in range(len(rank_data)):
        rank_data[i].update({'rank': i + 1})
        rank_data[i]['time'] = rank_data[i]['time'] / 1000.000

    return render(request, 'competition/rank.html', {
        'user_info': profile.data,
        'kind_info': kind_info.data,
        'rank': rank_data
    }
    )
   
@check_login
def yuce(request):
    """
    联系我们视图
    :param request: 请求对象
    :return: 渲染视图: user_info: 用户信息
    """
    
    uid = request.GET.get('uid', '')
    kind_id = request.GET.get('kind_id', '')
    a=0
    d=0
    c=0
    try:
        profile = Profile.objects.get(uid=uid)
    except Profile.DoesNotExist:
        return render(request, 'err.html', ProfileNotFound)
    try:
              qa_info= CompetitionQAInfo.objects.filter(kind_id=kind_id)
              
    except Profile.DoesNotExist:
          return render(request, 'err.html', ProfileNotFound)

    try:  # 获取比赛信息
        kind_info = CompetitionKindInfo.objects.get(kind_id=kind_id)
    except CompetitionKindInfo.DoesNotExist:  # 未获取到渲染错误视图
        return render(request, 'err.html', CompetitionNotFound)
    try:
         tikunandu_info= ChoiceInfo.objects.filter(bank_id=kind_info.bank_id)
              
    except Profile.DoesNotExist:
          return render(request, 'err.html', ProfileNotFound)
    for j in reversed(  tikunandu_info):
        if c==4:
            break
        else:
         d=d+j.nandu
         c=c+1
    d=d/c
    c=0
    for i in reversed(qa_info):
      if c==4:
        break
      else:
         a=a+i.pingjunnandu*i.score/d
         c=c+1
    if c==0:
       a=0
    else:  a=a/c
    t=0
    for j in qa_info:
        t=t+1
    return render(request, 'competition/yuce.html', {
    'user_info': profile.data,
    'kind_info': kind_info.data,
    'qa_info': qa_info,
    'a':a,
    'c':c,
    't':t,
    
    })
@check_login
def xiaoguo(request):
    """
    联系我们视图
    :param request: 请求对象
    :return: 渲染视图: user_info: 用户信息
    """    
    a=0 
    uid = request.GET.get('uid', '')
    kind_id = request.GET.get('kind_id', '')  # 获取kind_id
    try:  # 获取比赛信息
        kind_info = CompetitionKindInfo.objects.get(kind_id=kind_id)
    except CompetitionKindInfo.DoesNotExist:  # 未获取到渲染错误视图
        return render(request, 'err.html', CompetitionNotFound)
    try:
        profile = Profile.objects.get(uid=uid)
    except Profile.DoesNotExist:
        return render(request, 'err.html', ProfileNotFound)
    try:
            qa_info= CompetitionQAInfo.objects.filter()           
    except Profile.DoesNotExist:
          return render(request, 'err.html', ProfileNotFound)
  
 
    E=[]
    plt.switch_backend('agg') 
    plt.rcParams['font.sans-serif']=['Microsoft YaHei']  #显示中文标签,处理中文乱码问题
    plt.rcParams['axes.unicode_minus']=False  #坐标轴负号的处理
    s=0
    for i in reversed(qa_info):
        if a==5:
            break
        else:
         E.append(i.score)
         a=a+1
    for i in reversed(qa_info):
        if i.score>s:
         s=i.score
    
    w=[]
    c=[]
    A=0
    B=0
    C=0
    D=0
    F=0
    for i in qa_info:
        
            u=list (map(str,i.wrong_list)) 
            u=''.join(u)
            w=w+(re.findall("\d+",u))
    for i in w:
         nan= ChoiceInfo.objects.get(bank_id=kind_info.bank_id ,id=i)
         nan.nandu=int(nan.nandu)
         if nan.nandu==1:
            A=A+1
         if nan.nandu==2:
            B=B+1
         if nan.nandu==3:
            C=C+1
         if nan.nandu==4:
            D=D+1
         if nan.nandu==5:
            F=F+1

    
    labels = ['难度一','难度二','难度三','难度四','难度五']
   
    data=[A,B,C,D,F]
   
    plt.bar(labels,data)
    plt.title('所错题目难度分布')
    buffer = BytesIO()
    plt.savefig(buffer)
    plot_data = buffer.getvalue()
    # 将matplotlib图片转换为HTML
    imb = base64.b64encode(plot_data)  # 对plot_data进行编码
    ims = imb.decode()
    imd = "data:image/png;base64," + ims
    Y=[]
    m=0
   
    for i in reversed( qa_info):
        if m==5:
            break
        Y.append(i.score*0.7+i.pingjunnandu*20*0.3)
        m=m+1
    plt1.switch_backend('agg') 
    plt1.rcParams['font.sans-serif']=['Microsoft YaHei']  #显示中文标签,处理中文乱码问题
    #plt1.rcParams['axesy.unicode_minus']=False  #坐标轴负号的处理
    plt1.plot(Y)
   
    plt1.title('近五次真实反映成绩分析')
    plt1.xlabel("次数")
    plt1.ylabel("分数*0.7+试题平均难度*0.3")
    buffer = BytesIO()
    plt1.savefig(buffer)
    plot_data = buffer.getvalue()
    # 将matplotlib图片转换为HTML
    imb1 = base64.b64encode(plot_data)  # 对plot_data进行编码
    ims1 = imb1.decode()
    imd1 = "data:image/png;base64," + ims1
    plt2.switch_backend('agg') 
    plt2.rcParams['font.sans-serif']=['Microsoft YaHei']  #显示中文标签,处理中文乱码问题
    #plt1.rcParams['axesy.unicode_minus']=False  #坐标轴负号的处理
    a=0
    b=0
    for i in  reversed( qa_info):
       if m==5:
        break
       a=a+(i.correct_num)
       b=b+(i.incorrect_num)
       m=m+1
       l=[a,b]
    plt2.pie(l)
    plt2.title('近五次正确率')
    
 
    buffer = BytesIO()
    plt2.savefig(buffer)
    plot_data = buffer.getvalue()
    # 将matplotlib图片转换为HTML
    imb2 = base64.b64encode(plot_data)  # 对plot_data进行编码
    ims2 = imb2.decode()
    imd2 = "data:image/png;base64," + ims2
    plt3.switch_backend('agg') 
    plt3.rcParams['font.sans-serif']=['Microsoft YaHei']  #显示中文标签,处理中文乱码问题
    #plt1.rcParams['axesy.unicode_minus']=False  #坐标轴负号的处理
    a=0
    b=0
    for i in  reversed( qa_info):
       if m==1:
        break
       a=a+(i.correct_num)
       b=b+(i.incorrect_num)
       m=m+1
       l=[a,b]
    plt3.pie(l)
    plt3.title('最近一次正确率')
   
    buffer = BytesIO()
    plt3.savefig(buffer)
    plot_data = buffer.getvalue()
    # 将matplotlib图片转换为HTML
    imb3 = base64.b64encode(plot_data)  # 对plot_data进行编码
    ims3= imb3.decode()
    imd3 = "data:image/png;base64," + ims3

    return render(request, 'competition/xiaoguo.html', {
    'user_info': profile.data,
    'qa_info': qa_info,
    'kind_info': kind_info,
     's':s,
    'E':E,
    'w':c,
    'img':imd,
    'img1':imd1,
    'img2':imd2,
     'img3':imd3

  
  
    })
@check_login
def search(request):
    """
    搜索查询视图
    :param request: 请求对象
    :return: 渲染视图: user_info: 用户信息;result:查询结果比赛信息集合;key: 查询结果的关键字,是根据比赛名称查询还是根据赞助商关键字查询的结果
    """

    uid = request.GET.get('uid', '')
    keyword = request.GET.get('keyword', '')

    try:
        profile = Profile.objects.get(uid=uid)
    except Profile.DoesNotExist:
        render(request, 'err.html', ProfileNotFound)

    keyword = keyword.strip(' ')

    kinds = CompetitionKindInfo.objects.filter(kind_name__contains=keyword)
    key = 'kind'

    if not kinds:
        kinds = CompetitionKindInfo.objects.filter(sponsor_name__contains=keyword)
        key = 'sponsor'

    return render(request, 'competition/search.html', {
        'result': kinds,
        'key': key or ''
    })


@check_login
def contact(request):
    """
    联系我们视图
    :param request: 请求对象
    :return: 渲染视图: user_info: 用户信息
    """

    uid = request.GET.get('uid', '')
    try:
        profile = Profile.objects.get(uid=uid)
    except Profile.DoesNotExist:
        return render(request, 'err.html', ProfileNotFound)

    return render(request, 'web/contact_us.html', {'user_info': profile.data})


def donate(request):
    """
        捐助视图
        :param request: 请求对象
        :return: 渲染视图: user_info: 用户信息
    """

    uid = request.GET.get('uid', '')
    try:
        profile = Profile.objects.get(uid=uid)
    except Profile.DoesNotExist:
        profile = None

    return render(request, 'web/donate.html', {'user_info': profile.data if profile else None})