from langchain_core.tools import tool

from app.db.database import SessionLocal
from app.db.models import Destination, Package


def _fmt_package(p: Package) -> str:
    return (
        f"{p.title} - {p.destination_name}, {p.duration_days} days | ₹{p.price:,}/person | "
        f"category: {p.category} | rating: {p.rating} | inclusions: {p.inclusions} | id: {p.id}"
    )


def _package_artifact(p: Package) -> dict:
    return {
        "id": p.id,
        "title": p.title,
        "destination": p.destination_name,
        "duration_days": p.duration_days,
        "price": p.price,
        "category": p.category,
        "rating": p.rating,
    }


def make_tourism_tools(tenant_id: str) -> list:
    @tool(response_format="content_and_artifact")
    def search_packages(
        destination: str = "",
        category: str = "",
        max_price: int = 0,
        max_duration_days: int = 0,
    ) -> tuple[str, list[dict] | None]:
        """Search holiday packages by destination name, category (honeymoon/family/adventure/pilgrimage),
        maximum price per person in INR, and/or maximum duration in days. Leave a field as "" or 0 to not filter on it."""
        db = SessionLocal()
        try:
            q = db.query(Package).filter(Package.tenant_id == tenant_id)
            if destination:
                q = q.filter(Package.destination_name.ilike(f"%{destination}%"))
            if category:
                q = q.filter(Package.category.ilike(f"%{category}%"))
            if max_price > 0:
                q = q.filter(Package.price <= max_price)
            if max_duration_days > 0:
                q = q.filter(Package.duration_days <= max_duration_days)
            pkgs = q.all()
        finally:
            db.close()
        if not pkgs:
            return "NO_MATCH", None
        content = "\n".join(_fmt_package(p) for p in pkgs)
        return content, [_package_artifact(p) for p in pkgs]

    @tool
    def get_package_details(package_title_or_id: str) -> str:
        """Get full details (inclusions, price, duration, rating) for a specific holiday package by its title or id."""
        db = SessionLocal()
        try:
            like = f"%{package_title_or_id}%"
            p = db.query(Package).filter(
                Package.tenant_id == tenant_id,
                (Package.title.ilike(like)) | (Package.id == package_title_or_id),
            ).first()
        finally:
            db.close()
        if not p:
            return "NO_MATCH"
        return (
            f"{p.title} to {p.destination_name}: {p.duration_days} days, ₹{p.price:,}/person, "
            f"category: {p.category}, inclusions: {p.inclusions}, rating: {p.rating}."
        )

    @tool
    def list_destinations() -> str:
        """List all destinations offered, with region and the best time to visit each."""
        db = SessionLocal()
        try:
            dests = db.query(Destination).filter(Destination.tenant_id == tenant_id).all()
        finally:
            db.close()
        if not dests:
            return "NO_MATCH"
        return "\n".join(f"{d.name} ({d.region}) - best time: {d.best_time_to_visit}. {d.description}" for d in dests)

    return [search_packages, get_package_details, list_destinations]
