renderers.py

from db import _query_leaderboard, _query_pickle_profiles, get_recent_reviews_df


def _score_bar(val):
    pct   = int((float(val) / 10) * 100)
    color = "var(--score-good)" if float(val) >= 7 else "var(--score-warn)" if float(val) >= 4 else "var(--score-bad)"
    return (
        f'<span style="display:inline-flex;align-items:center;gap:6px;">'
        f'<span style="background:var(--score-track);border-radius:4px;height:6px;width:50px;'
        f'display:inline-block;vertical-align:middle;">'
        f'<span style="background:{color};border-radius:4px;height:6px;width:{pct}%;display:block;"></span>'
        f'</span><span style="font-weight:700;color:{color};min-width:18px;font-size:0.85rem;">{val}</span>'
        f'</span>'
    )


def _buy_badge(pct):
    pct    = int(pct) if pct is not None else 0
    state  = "good" if pct >= 70 else "warn" if pct >= 40 else "bad"
    return f'<span class="buy-pct buy-pct-{state}">{pct}%</span>'


_LB_EMPTY = """
<div class="lb-empty">
    <div style="font-size:4rem;margin-bottom:12px;">🥒</div>
    <h3 style="margin:0 0 8px;font-size:1.2rem;color:var(--text);font-weight:700;">No pickles ranked yet!</h3>
    <p style="margin:0;color:var(--muted);font-size:0.95rem;">Be the first to rate a pickle and claim the top spot. 🏆</p>
</div>
"""


def get_leaderboard_html(sort_by="⭐ Overall"):
    df = _query_leaderboard(sort_by)
    if df.empty:
        return _LB_EMPTY

    medals     = {1: "🥇", 2: "🥈", 3: "🥉"}
    row_classes = {1: "rank-gold", 2: "rank-silver", 3: "rank-bronze"}

    rows_html = ""
    for _, row in df.iterrows():
        rank    = int(row["rank"])
        medal   = medals.get(rank, f'<span style="color:var(--muted);font-weight:700;font-size:0.85rem;">{rank}</span>')
        row_cls = row_classes.get(rank, "")
        n       = int(row["review_count"])
        buy_pct = int(row.get("buy_again_pct", 0) or 0)

        rows_html += f"""
        <tr class="lb-row {row_cls}">
            <td class="lb-rank">{medal}</td>
            <td class="lb-name"><span class="pickle-pill">{row['pickle_name']}</span></td>
            <td class="lb-brand lb-col-md">{row['brand']}</td>
            <td class="lb-score">{_score_bar(row['avg_overall'])}</td>
            <td class="lb-score lb-col-lg">{_score_bar(row['avg_crunch'])}</td>
            <td class="lb-score lb-col-lg">{_score_bar(row['avg_sour'])}</td>
            <td class="lb-score lb-col-lg">{_score_bar(row['avg_garlic'])}</td>
            <td>{_buy_badge(buy_pct)}</td>
            <td class="lb-col-md"><span class="review-badge">{n} {"review" if n == 1 else "reviews"}</span></td>
        </tr>
        """

    return f"""
    <div class="lb-wrapper">
        <table class="lb-table">
            <thead>
                <tr>
                    <th>#</th><th>🥒 Pickle</th>
                    <th class="lb-col-md">Brand</th>
                    <th>⭐ Overall</th>
                    <th class="lb-col-lg">🔊 Crunch</th>
                    <th class="lb-col-lg">😬 Sour</th>
                    <th class="lb-col-lg">🧄 Garlic</th>
                    <th>🛒 Buy?</th>
                    <th class="lb-col-md">Reviews</th>
                </tr>
            </thead>
            <tbody>{rows_html}</tbody>
        </table>
    </div>
    """


def search_pickles(name_query="", brand_query=""):
    name_q  = (name_query  or "").strip()
    brand_q = (brand_query or "").strip()

    if not name_q and not brand_q:
        return """
        <div class="lb-empty">
            <div style="font-size:3rem;margin-bottom:12px;">🔍</div>
            <p style="margin:0;color:var(--muted);font-size:0.95rem;">Type a pickle name or brand above to search.</p>
        </div>
        """

    df = _query_pickle_profiles(name_filter=name_q, brand_filter=brand_q)

    if df.empty:
        return """
        <div class="lb-empty">
            <div style="font-size:3rem;margin-bottom:12px;">🤷</div>
            <p style="margin:0;color:var(--muted);font-size:0.95rem;">No pickles matched. Try a different name or brand.</p>
        </div>
        """

    count     = len(df)
    rows_html = ""
    for _, row in df.iterrows():
        n       = int(row["review_count"])
        buy_pct = int(row.get("buy_again_pct", 0) or 0)
        rows_html += f"""
        <tr class="lb-row">
            <td class="lb-name"><span class="pickle-pill">{row['pickle_name']}</span></td>
            <td class="lb-brand lb-col-md">{row['brand']}</td>
            <td class="lb-score">{_score_bar(row['avg_overall'])}</td>
            <td class="lb-score lb-col-lg">{_score_bar(row['avg_crunch'])}</td>
            <td class="lb-score lb-col-lg">{_score_bar(row['avg_sour'])}</td>
            <td class="lb-score lb-col-lg">{_score_bar(row['avg_garlic'])}</td>
            <td>{_buy_badge(buy_pct)}</td>
            <td class="lb-col-md"><span class="review-badge">{n} {"review" if n == 1 else "reviews"}</span></td>
        </tr>
        """

    return f"""
    <p style="font-size:0.82rem;color:var(--muted);margin:0 0 10px;font-weight:600;
              text-transform:uppercase;letter-spacing:0.8px;">{count} result{"s" if count != 1 else ""}</p>
    <div class="lb-wrapper">
        <table class="lb-table">
            <thead>
                <tr>
                    <th>🥒 Pickle</th>
                    <th class="lb-col-md">Brand</th>
                    <th>⭐ Overall</th>
                    <th class="lb-col-lg">🔊 Crunch</th>
                    <th class="lb-col-lg">😬 Sour</th>
                    <th class="lb-col-lg">🧄 Garlic</th>
                    <th>🛒 Buy?</th>
                    <th class="lb-col-md">Reviews</th>
                </tr>
            </thead>
            <tbody>{rows_html}</tbody>
        </table>
    </div>
    """


def get_recent_html():
    df = get_recent_reviews_df()
    if df.empty:
        return """
        <div class="lb-empty" style="border-style:dashed;">
            <div style="font-size:3rem;margin-bottom:12px;">🥒</div>
            <p style="margin:0;color:var(--muted);font-size:0.95rem;">No reviews yet — go rate some pickles!</p>
        </div>
        """

    cards = ""
    for _, r in df.iterrows():
        brand_clean = str(r["brand"]).strip()
        brand_html  = (
            f'<span class="review-brand">· {brand_clean}</span>'
            if brand_clean and brand_clean not in ("", "—") else ""
        )
        body_html = (
            f'<p class="review-body">"{r["review_text"]}"</p>'
            if str(r.get("review_text", "")).strip() else ""
        )
        spicy     = int(r.get("spiciness", 5) or 5)
        buy_val   = int(r.get("buy_again", 1) or 1)
        buy_badge = (
            '<span class="buy-badge buy-yes">🛒 Buy Again</span>'
            if buy_val else
            '<span class="buy-badge buy-no">👎 Pass</span>'
        )

        cards += f"""
        <div class="review-card">
            <div class="review-card-header">
                <div>
                    <span class="review-pickle-name">{r['pickle_name']}</span>
                    {brand_html}
                </div>
                <span class="review-date">{r['date']}</span>
            </div>
            <div class="review-scores">
                <span class="score-chip">⭐ {r['overall']}</span>
                <span class="score-chip">🔊 {r['crunchiness']}</span>
                <span class="score-chip">😬 {r['sourness']}</span>
                <span class="score-chip">🧄 {r['garlic']}</span>
                <span class="score-chip">🌶️ {spicy}</span>
                {buy_badge}
            </div>
            {body_html}
        </div>
        """

    return f'<div class="reviews-grid">{cards}</div>'


def get_analytics_html():
    total, total_pickles, highest, most_rev, avg_crunch, avg_sour, avg_garlic, buy_pct = (
        __import__("db").get_analytics()
    )

    if total == 0:
        return """
        <div class="lb-empty">
            <div style="font-size:4rem;margin-bottom:12px;">📊</div>
            <h3 style="margin:0 0 8px;font-size:1.2rem;color:var(--text);font-weight:700;">No data yet!</h3>
            <p style="margin:0;color:var(--muted);font-size:0.95rem;">Submit some pickle reviews to see analytics here.</p>
        </div>
        """

    buy_color  = "var(--positive-text)" if buy_pct >= 70 else "var(--warning-text)" if buy_pct >= 40 else "var(--danger-text)"

    def _card(icon, value, label, color="var(--stat-value)"):
        return (
            f'<div class="stat-card">'
            f'<div class="stat-icon">{icon}</div>'
            f'<div class="stat-value" style="color:{color};">{value}</div>'
            f'<div class="stat-label">{label}</div>'
            f'</div>'
        )

    cards = (
        _card("📝", total,            "Total Reviews")
        + _card("🥒", total_pickles,  "Unique Pickles")
        + _card("🏆", highest,        "Highest Rated")
        + _card("🌟", most_rev,       "Most Reviewed")
        + _card("🔊", f"{avg_crunch}/10", "Avg Crunchiness")
        + _card("😬", f"{avg_sour}/10",   "Avg Sourness")
        + _card("🧄", f"{avg_garlic}/10", "Avg Garlic")
        + _card("🛒", f"{int(buy_pct)}%", "Buy Again", buy_color)
    )

    return f'<div class="stat-grid">{cards}</div>'