"""
This plot presents accumulated totals and departures
of growing degree days, precipitation and stress degree days. Leap days
are not considered for this plot. The light blue area represents the
range of accumulated values based on the climatology for the site. The
climatology is based on the closest nearby long-term climate site.
"""

from datetime import date, datetime, timedelta

import numpy as np
import pandas as pd
from pyiem.database import get_sqlalchemy_conn, sql_helper
from pyiem.exceptions import NoDataFound
from pyiem.plot import figure

PDICT = {
    "all": "Show GDD, Precipitation, and SDD",
    "gdd": "Only plot Growing Degree Days",
    "precip": "Only plot Precipitation",
    "sdd": "Only plot Stress Degree Days",
    "srad": "Only plot Solar Radiation",
}


def get_description():
    """Return a dict describing how to call this plotter"""
    desc = {"description": __doc__, "data": True}
    today = date.today()
    if today.month < 5:
        today = today.replace(year=today.year - 1, month=10, day=1)
    sts = today.replace(month=5, day=1)

    desc["arguments"] = [
        dict(
            type="sid",
            name="station",
            default="AEEI4",
            network="ISUSM",
            label="Select Station",
        ),
        dict(
            type="date",
            name="sdate",
            default=sts.strftime("%Y/%m/%d"),
            label="Start Date (inclusive):",
            min="1893/01/01",
        ),
        dict(
            type="date",
            name="edate",
            default=today.strftime("%Y/%m/%d"),
            label="End Date (inclusive):",
            min="1893/01/01",
        ),
        dict(
            type="int",
            name="base",
            default="50",
            label="Growing Degree Day Base (F)",
        ),
        dict(
            type="int",
            name="ceil",
            default="86",
            label="Growing Degree Day Ceiling (F)",
        ),
        dict(
            type="year",
            name="year2",
            default=1893,
            optional=True,
            label="Compare with year (optional):",
        ),
        dict(
            type="year",
            name="year3",
            default=1893,
            optional=True,
            label="Compare with year (optional)",
        ),
        dict(
            type="year",
            name="year4",
            default=1893,
            optional=True,
            label="Compare with year (optional)",
        ),
        dict(
            type="select",
            name="which",
            default="all",
            options=PDICT,
            label="Which Charts to Show in Plot",
        ),
    ]
    return desc


def plotter(ctx: dict):
    """Go"""
    station = ctx["station"]
    sdate = ctx["sdate"]
    edate = ctx["edate"]
    if sdate > edate:
        sdate, edate = edate, sdate
    year2 = ctx.get("year2", 0)
    year3 = ctx.get("year3", 0)
    year4 = ctx.get("year4", 0)
    wantedyears = [sdate.year, year2, year3, year4]
    yearcolors = ["r", "g", "b", "purple"]
    gddbase = ctx["base"]
    gddceil = ctx["ceil"]
    whichplots = ctx["which"]
    glabel = f"gdd{gddbase}{gddceil}"

    # Make sure we have climo info
    if (
        station not in ctx["_nt"].sts
        or ctx["_nt"].sts[station]["climate_site"] is None
    ):
        raise NoDataFound("Unknown station metadata.")

    # build the climatology
    climosite = ctx["_nt"].sts[station]["climate_site"]
    with get_sqlalchemy_conn("coop") as conn:
        climo = pd.read_sql(
            sql_helper(
                """
            SELECT day, sday, gddxx(:gddbase, :gddceil, high, low) as {glabel},
            sdd86(high, low) as sdd86, precip,
            coalesce(era5land_srad, hrrr_srad) as srad
            from alldata WHERE station = :station and
            year >= 1951 ORDER by day ASC
            """,
                glabel=glabel,
            ),
            conn,
            params={
                "gddbase": gddbase,
                "gddceil": gddceil,
                "station": ctx["_nt"].sts[station]["climate_site"],
            },
            index_col="day",
        )
    if climo.empty:
        raise NoDataFound("Failed to find climatology")
    baseyear = int(climo.index.values[0].year)
    years = (datetime.now().year - baseyear) + 1
    xlen = int((edate - sdate).days) + 1  # In case of leap day
    acc = np.zeros((years, xlen))
    acc[:] = np.nan
    pacc = np.zeros((years, xlen))
    pacc[:] = np.nan
    sacc = np.zeros((years, xlen))
    sacc[:] = np.nan
    radacc = np.zeros((years, xlen))
    radacc[:] = np.nan
    for year in range(baseyear, datetime.now().year + 1):
        sts = sdate.replace(year=year)
        ets = sts + timedelta(days=xlen - 1)
        x = climo.loc[sts:ets, glabel].cumsum()
        if x.empty:
            continue
        acc[(year - baseyear), : len(x.index)] = x.to_numpy()
        x = climo.loc[sts:ets, "precip"].cumsum()
        pacc[(year - baseyear), : len(x.index)] = x.to_numpy()
        x = climo.loc[sts:ets, "sdd86"].cumsum()
        sacc[(year - baseyear), : len(x.index)] = x.to_numpy()
        x = climo.loc[sts:ets, "srad"].cumsum()
        radacc[(year - baseyear), : len(x.index)] = x.to_numpy()

    sday_climo = climo.groupby("sday").mean()
    rows = []
    for i in range(xlen):
        dt = sdate + timedelta(days=i)
        sday = dt.strftime("%m%d")
        rows.append(
            {
                "sday": sday,
                f"c{glabel}": sday_climo.at[sday, glabel],
                f"c{glabel}_acc": np.nanmean(acc[:, i]),
                f"c{glabel}_min_acc": np.nanmin(acc[:, i]),
                f"c{glabel}_max_acc": np.nanmax(acc[:, i]),
                "cprecip": sday_climo.at[sday, "precip"],
                "cprecip_acc": np.nanmean(pacc[:, i]),
                "cprecip_min_acc": np.nanmin(pacc[:, i]),
                "cprecip_max_acc": np.nanmax(pacc[:, i]),
                "csdd86": sday_climo.at[sday, "sdd86"],
                "csdd86_acc": np.nanmean(sacc[:, i]),
                "csdd86_min_acc": np.nanmin(sacc[:, i]),
                "csdd86_max_acc": np.nanmax(sacc[:, i]),
                "csrad": sday_climo.at[sday, "srad"],
                "csrad_acc": np.nanmean(radacc[:, i]),
                "csrad_min_acc": np.nanmin(radacc[:, i]),
                "csrad_max_acc": np.nanmax(radacc[:, i]),
            }
        )
    climo = pd.DataFrame(rows)

    # build the obs
    with get_sqlalchemy_conn("iem") as conn:
        df = pd.read_sql(
            sql_helper(
                """
            SELECT day, to_char(day, 'mmdd') as sday,
            gddxx(:gddbase, :gddceil, max_tmpf, min_tmpf)
                as o{glabel},
            coalesce(pday, 0) as oprecip,
            sdd86(max_tmpf, min_tmpf) as osdd86,
            srad_mj as osrad
            from summary s JOIN stations t on (s.iemid = t.iemid)
            WHERE id = :station and network = :network and
            to_char(day, 'mmdd') != '0229'
            ORDER by day ASC""",
                glabel=glabel,
            ),
            conn,
            params={
                "gddbase": gddbase,
                "gddceil": gddceil,
                "station": station,
                "network": ctx["network"],
            },
            index_col=None,
        )
    # Now we need to join the frames
    df = pd.merge(df, climo, on="sday")
    df = df.sort_values("day", ascending=True)
    df = df.set_index("day")
    df["precip_diff"] = df["oprecip"] - df["cprecip"]
    df[f"{glabel}_diff"] = df[f"o{glabel}"] - df[f"c{glabel}"]

    ab = ctx["_nt"].sts[station]["archive_begin"]
    if ab is None:
        raise NoDataFound("Unknown station metadata.")
    fig = figure(apctx=ctx)
    if whichplots == "all":
        ax1 = fig.add_axes((0.1, 0.7, 0.8, 0.2))
        ax2 = fig.add_axes(
            (0.1, 0.6, 0.8, 0.1), sharex=ax1, facecolor="#EEEEEE"
        )
        ax3 = fig.add_axes((0.1, 0.35, 0.8, 0.2), sharex=ax1)
        ax4 = fig.add_axes((0.1, 0.1, 0.8, 0.2), sharex=ax1)
        title = (
            f"GDD(base={gddbase:.0f},ceil={gddceil:.0f}), Precip, & "
            "SDD(base=86)"
        )
    elif whichplots == "gdd":
        ax1 = fig.add_axes((0.14, 0.31, 0.8, 0.57))
        ax2 = fig.add_axes(
            [0.14, 0.11, 0.8, 0.2], sharex=ax1, facecolor="#EEEEEE"
        )
        title = f"GDD(base={gddbase:.0f},ceil={gddceil:.0f})"
    elif whichplots == "precip":
        ax3 = fig.add_axes((0.1, 0.11, 0.8, 0.75))
        ax1 = ax3
        title = "Precipitation"
    elif whichplots == "srad":
        ax3 = fig.add_axes((0.1, 0.11, 0.8, 0.75))
        ax1 = ax3
        title = "Solar Radiation (MJ/d)"
    else:  # sdd
        ax4 = fig.add_axes((0.1, 0.1, 0.8, 0.8))
        ax1 = ax4
        title = "Stress Degree Days (base=86)"

    ax1.set_title(
        f"Accumulated {title}\n{ctx['_sname']}",
        fontsize=18 if whichplots == "all" else 14,
    )

    for year in wantedyears:
        if year == 0:
            continue
        sts = sdate.replace(year=year)
        ets = sts + timedelta(days=xlen - 1)
        color = yearcolors[wantedyears.index(year)]
        yearlabel = sts.year
        x = df.loc[sts:ets]
        if x.empty:
            continue
        if sts.year != ets.year:
            yearlabel = f"{sts.year}-{ets.year}"
        if whichplots in ["gdd", "all"]:
            ax1.plot(
                range(len(x.index)),
                x[f"o{glabel}"].cumsum().values,
                zorder=6,
                color=color,
                label=f"{yearlabel}",
                lw=2,
            )
        # Get cumulated precip
        p = x["oprecip"].cumsum()
        if whichplots in ["all", "precip"]:
            ax3.plot(
                range(len(p.index)),
                p.values,
                color=color,
                lw=2,
                zorder=6,
                label=f"{yearlabel}",
            )
        p = x["osdd86"].cumsum()
        if whichplots in ["all", "sdd"]:
            ax4.plot(
                range(len(p.index)),
                p.values,
                color=color,
                lw=2,
                zorder=6,
                label=f"{yearlabel}",
            )

        p = x["osrad"].cumsum()
        if whichplots == "srad":
            ax3.plot(
                range(len(p.index)),
                p.values,
                color=color,
                lw=2,
                zorder=6,
                label=f"{yearlabel}",
            )

        # Plot Climatology
        if wantedyears.index(year) == 0:
            x = df.loc[sts:ets, "c" + glabel].cumsum()
            if whichplots in ["all", "gdd"]:
                ax1.plot(
                    range(len(x.index)),
                    x.values,
                    color="k",
                    label="Climatology",
                    lw=2,
                    zorder=5,
                )
            x = df.loc[sts:ets, "cprecip"].cumsum()
            if whichplots in ["all", "precip"]:
                ax3.plot(
                    range(len(x.index)),
                    x.values,
                    color="k",
                    label="Climatology",
                    lw=2,
                    zorder=5,
                )
            x = df.loc[sts:ets, "csdd86"].cumsum()
            if whichplots in ["all", "sdd"]:
                ax4.plot(
                    range(len(x.index)),
                    x.values,
                    color="k",
                    label="Climatology",
                    lw=2,
                    zorder=5,
                )
            x = df.loc[sts:ets, "csrad"].cumsum()
            if whichplots == "srad":
                ax3.plot(
                    range(len(x.index)),
                    x.values,
                    color="k",
                    label="Climatology",
                    lw=2,
                    zorder=5,
                )

        x = df.loc[sts:ets, glabel + "_diff"].cumsum()
        if whichplots in ["all", "gdd"]:
            ax2.plot(
                range(len(x.index)),
                x.values,
                color=color,
                linewidth=2,
                linestyle="--",
            )

    xmin = np.nanmin(acc, 0)
    xmax = np.nanmax(acc, 0)
    if whichplots in ["all", "gdd"]:
        ax1.fill_between(range(len(xmin)), xmin, xmax, color="lightblue")
        ax1.grid(True)
        ax2.grid(True)
    xmin = np.nanmin(pacc, 0)
    xmax = np.nanmax(pacc, 0)
    if whichplots in ["all", "precip"]:
        ax3.fill_between(range(len(xmin)), xmin, xmax, color="lightblue")
        ax3.set_ylabel("Precipitation [inch]")
        ax3.grid(True)
    if whichplots == "srad":
        xmin = np.nanmin(radacc, 0)
        xmax = np.nanmax(radacc, 0)
        ax3.fill_between(range(len(xmin)), xmin, xmax, color="lightblue")
        ax3.set_ylabel("Solar Radiation [MJ/d]")
        ax3.grid(True)
    xmin = np.nanmin(sacc, 0)
    xmax = np.nanmax(sacc, 0)
    if whichplots in ["all", "sdd"]:
        ax4.fill_between(range(len(xmin)), xmin, xmax, color="lightblue")
        ax4.set_ylabel("SDD Base 86 °F")
        ax4.grid(True)

    if whichplots in ["all", "gdd"]:
        ax1.set_ylabel(f"GDD Base {gddbase:.0f} Ceil {gddceil:.0f} °F")

        ax1.text(
            0.5,
            0.9,
            (
                f"{sdate.month}/{sdate.day} - {edate.month}/{edate.day}\n"
                f"Climatology {climosite} {baseyear:.0f}-"
                f"{date.today().year:.0f}"
            ),
            transform=ax1.transAxes,
            ha="center",
            va="center",
        )

        ylim = ax2.get_ylim()
        spread = max([abs(ylim[0]), abs(ylim[1])]) * 1.1
        ax2.set_ylim(0 - spread, spread)
        ax2.text(
            0.0,
            1.0,
            "Accumulated Departure",
            transform=ax2.transAxes,
            bbox=dict(facecolor="white", ec="#EEEEEE", alpha=0.5),
            va="top",
            ha="left",
        )
        ax2.yaxis.tick_right()

    xticks = []
    xticklabels = []
    wanted = [1] if xlen > 31 else [1, 7, 15, 22, 29]
    now = sdate
    i = 0
    while now <= edate:
        if now.day in wanted:
            xticks.append(i)
            xticklabels.append(now.strftime("%-d %b"))
        now += timedelta(days=1)
        i += 1
    if whichplots in ["all", "gdd"]:
        ax2.set_xticks(xticks)
        ax2.set_xticklabels(xticklabels)
        ax1.legend(loc=2, prop={"size": 12})
        # Remove ticks on the top most plot
        for label in ax1.get_xticklabels():
            label.set_visible(False)

        ax1.set_xlim(0, xlen + 1)
    if whichplots in ["all", "precip"]:
        ax3.set_xticks(xticks)
        ax3.set_xticklabels(xticklabels)
        ax3.legend(loc=2, prop={"size": 10})
        ax3.set_xlim(0, xlen + 1)
    if whichplots == "srad":
        ax3.set_xticks(xticks)
        ax3.set_xticklabels(xticklabels)
        ax3.legend(loc=2, prop={"size": 10})
        ax3.set_xlim(0, xlen + 1)
    if whichplots in ["all", "sdd"]:
        ax4.set_xticks(xticks)
        ax4.set_xticklabels(xticklabels)
        ax4.legend(loc=2, prop={"size": 10})
        ax4.set_xlim(0, xlen + 1)

    return fig, df
