import json

from ennstatus.donate.functions import all_csv_to_dict, year_sum, month_sum

@data_page.route('/year')

def yeardata():

    data = all_csv_to_dict()

    data = year_sum(data)

    datalist = []

    for key, values in data.items():

        datalist.append({"key": key, "value": float(values)})

    datalist.sort(key=lambda x: x["key"])

    return json.dumps(datalist)

@data_page.route('/month')

def monthdata():

    data = all_csv_to_dict()

    data = month_sum(data)

    data_list = []

    for key, values in data.items():

        data_list.append({"key": key, "value": float(values)})

    data_list.sort(key=lambda x: x["key"])

    return json.dumps(data_list)

import statistics

from collections import defaultdict

from babel.numbers import parse_decimal

def load_csv_file(file):

    with open(file, encoding='utf-8', newline='') as csvfile:

        csvreader = csv.reader(csvfile, delimiter=',')

        rows = list(csvreader)

    return rows

    for row in load_csv_file(path):

        yield row

def get_all_csv():

    for file in os.listdir('donations'):

        path = os.path.join('donations', file)

        yield load_csv_file(path)

def get_all_rows():

    for csvfile in get_all_csv():

        for row in csvfile:

            yield row

def all_csv_to_dict():

    data = defaultdict(set)

    for row in get_all_rows():

        data[row[0]].add(parse_decimal(row[2], locale='de'))

    return data

def data_to_year(data):

    year_data = defaultdict(set)

    for date, values in data.items():

        year = date.split('-')[0]

        for value in values:

            year_data[year].add(value)

    return year_data

def data_to_month(data):

    month_data = defaultdict(set)

    for date, values in data.items():

        month = date.rsplit('-', maxsplit=1)[0]

        for value in values:

            month_data[month].add(value)

    return month_data

def year_sum(data):

    year_data = data_to_year(data)

    for year, values in year_data.items():

        year_data[year] = sum(values)

    return year_data

def month_sum(data):

    month_data = data_to_month(data)

    for month, values in month_data.items():

        month_data[month] = sum(values)

    return month_data

def get_all_years_mean(data):

    mean = set()

    year_data = year_sum(data)

    for year, values in year_data.items():

        mean.add(values)

    return statistics.mean(mean)

def get_months_mean(data):

    mean = set()

    month_data = month_sum(data)

    for year, values in month_data.items():

        mean.add(values)

    return statistics.mean(mean)

def get_best_year(data):

    year_data = year_sum(data)

    return max(year_data.items(), key=lambda x: x[1])

def get_best_month(data):

    month_data = month_sum(data)

    return max(month_data.items(), key=lambda x: x[1])

def get_highest_donation():

    data = all_csv_to_dict()

    for date, values in data.items():

        data[date] = max(values)

    return max(

        sorted(

            data.items(),

            key=lambda x: x[0],

            reverse=True

        ),

        key=lambda x: x[1]

    )

def get_median_donation():

    data = all_csv_to_dict()

    donations = []

    for value in data.values():

        donations.extend(value)

    return statistics.median(donations)

def get_mode_donation():

    data = all_csv_to_dict()

    donations = []

    for value in data.values():

        donations.extend(value)

    return statistics.mode(donations)

import json

from ennstatus.donate.functions import (load_csv,

                                        get_choices,

                                        all_csv_to_dict,

                                        get_all_years_mean,

                                        get_months_mean,

                                        get_best_year,

                                        get_best_month,

                                        get_highest_donation,

                                        get_median_donation,

                                        get_mode_donation,

                                        )

@donate_page.route('/statistics')

def statistics():

    data = all_csv_to_dict()

    all_years_mean = format_decimal(

        get_all_years_mean(data),

        locale='de'

    )

    month_mean = format_decimal(

        get_months_mean(data),

        locale='de'

    )

    best_year = get_best_year(data)

    best_year = (best_year[0], format_decimal(best_year[1], locale='de'))

    best_month = get_best_month(data)

    best_month = (best_month[0], format_decimal(best_month[1], locale='de'))

    highest_donation = get_highest_donation()

    highest_donation = (highest_donation[0], format_decimal(highest_donation[1], locale='de'))

    median_donation = format_decimal(

        get_median_donation(),

        locale='de'

    )

    mode_donation = format_decimal(

        get_mode_donation(),

        locale='de'

    )

    dates = [name for name in get_choices()]

    dates.sort()

    last_default_date = dates[-1]

    first_default_date = dates[-12]

    return render_template('donate/statistics.html',

                           all_years_mean=all_years_mean,

                           month_mean=month_mean,

                           best_year=best_year,

                           best_month=best_month,

                           highest_donation=highest_donation,

                           median_donation=median_donation,

                           mode_donation=mode_donation,

                           dates=dates,

                           first_default_date=first_default_date,

                           last_default_date=last_default_date

                           )

	d3.select('svg').remove();

            <li class="divider"></li>

            <li><a href="{{ url_for('donate.statistics') }}">Donation statistics</a></li>

            <select class="form-control input-sm" id="monthfirstdate" name="monthfirstdate">

            <select class="form-control input-sm" id="monthlastdate" name="monthlastdate">