from ..flask_extend import Blueprint
from flask import render_template, request, url_for, redirect

import datetime, decimal
from sqlalchemy import sql, func

from ..model import db, Category, SingleExpense, CatExpense, MonthExpense

from ..forms import ExpenseForm

mod = Blueprint('expenses', __name__)

def expense_form(obj=None):
    form = ExpenseForm(obj=obj)
    form.category.query = Category.query.order_by(Category.name)
    return form

def calc_month_exp(year, month):
    ssum = func.sum(SingleExpense.expense)
    query = SingleExpense.of_month(month, year)

    result = query.group_by(SingleExpense.category_id).\
             values(SingleExpense.category_id, ssum)

    exps = [CatExpense(Category.query.get(c), s, query.filter(SingleExpense.category_id == c)) for c,s in result]

    return MonthExpense(datetime.date(year, month, 1), exps)

@mod.app_template_filter()
def prev_date(exp):
    if exp.date.month == 1:
        return exp.date.replace(year = exp.date.year - 1, month = 12)
    else:
        return exp.date.replace(month = exp.date.month - 1)

@mod.app_template_filter()
def next_date(exp):
    if exp.date.month == 12:
        return exp.date.replace(year = exp.date.year + 1, month = 1)
    else:
        return exp.date.replace(month = exp.date.month + 1)

@mod.app_template_test("last_date")
def is_last(exp):
    return exp.date >= datetime.date.today().replace(day = 1)

@mod.route("/<int(fixed_digits=4):year>/<int(fixed_digits=2):month>")
def show_date(year, month):
    c = calc_month_exp(year, month)
    return render_template("pages/show.jinja", exps = [c])

mod.add_url_rule("/<path:p>", endpoint = "show_date_str", build_only = True)

@mod.route("/")
def show():
    d = datetime.date.today()
            
    first = calc_month_exp(d.year, d.month)
    if d.month == 1:
        second = calc_month_exp(d.year - 1, 12)
    else:
        second = calc_month_exp(d.year, d.month - 1)

    return render_template("pages/show.jinja", exps = [first, second])

@mod.route("/edit/<int:id>", methods=("GET", "POST"))
def edit(id):
    exp = SingleExpense.get(id)
    form = expense_form(exp)

    ret = lambda: render_template("pages/edit.jinja", form=form)

    if request.method == "POST":
        if "deleteB" in request.form:
            db.session.delete(exp)

        elif form.validate(): # change
            form.populate_obj(exp)

        else:
            return ret()

        db.session.commit()
        return redirect(url_for("index"))

    return ret()

@mod.route("/add/", methods=("GET", "POST"))
def add():
    form = expense_form()

    if form.validate_on_submit():
        exp = SingleExpense()

        form.populate_obj(exp)

        db.session.add(exp)
        db.session.commit()

        return redirect(url_for("index"))

    return render_template("pages/add.jinja", form=form)