use hyper::{Body, Response};
use tera::Context;

use crate::controller::utils;
use crate::controller::wallet::Wallet;
use crate::db;
use crate::templates;

pub async fn get(wallet: &Wallet) -> Response<Body> {
    let categories = db::categories::list(&wallet.pool).await;
    let payments = db::payments::list_for_stats(&wallet.pool).await;
    let incomes = db::incomes::total_each_month(&wallet.pool).await;

    let mut context = Context::new();
    context.insert("header", &templates::Header::Statistics);
    context.insert("connected_user", &wallet.user);
    context.insert(
        "json_categories",
        &serde_json::to_string(&categories).unwrap(),
    );
    context.insert("json_payments", &serde_json::to_string(&payments).unwrap());
    context.insert("json_incomes", &serde_json::to_string(&incomes).unwrap());

    utils::template(
        &wallet.assets,
        &wallet.templates,
        "statistics.html",
        context,
    )
}