TIQ-Test-Backend / escalation_tool.py
Shakeel401's picture
Update escalation_tool.py
a2d40ff verified
Raw History Blame Contribute Delete
8.94 kB
# ==============================
# IMPORTS
# ==============================
from agents import function_tool, SQLiteSession
from contextvars import ContextVar
from supabase import create_client
from runtime_context import get_thread_id, set_customer_ai_enabled_for_phone
import os
import re
from dotenv import load_dotenv
# ==============================
# LOAD ENV
# ==============================
load_dotenv()
SUPABASE_URL = os.getenv("SUPABASE_URL")
SUPABASE_KEY = os.getenv("SUPABASE_KEY")
supabase = create_client(SUPABASE_URL, SUPABASE_KEY)
_escalation_capture: ContextVar[dict | None] = ContextVar(
"escalation_capture", default=None
)
def begin_escalation_capture():
"""Track a successful internal escalation during one agent run."""
return _escalation_capture.set({"saved": False})
def finish_escalation_capture(token) -> bool:
capture = _escalation_capture.get() or {}
_escalation_capture.reset(token)
return bool(capture.get("saved"))
def _mark_escalation_saved() -> None:
capture = _escalation_capture.get()
if capture is not None:
capture["saved"] = True
# ==============================
# SESSION
# ==============================
def get_session(thread_id: str):
db_path = os.path.join(os.path.dirname(__file__), "conversations.db")
return SQLiteSession(thread_id, db_path)
# ==============================
# FORMAT CHAT HISTORY
# ==============================
def format_chat_history(items):
formatted = []
for item in items:
try:
if not isinstance(item, dict):
continue
role = item.get("role")
if role not in ["user", "assistant"]:
continue
content = item.get("content", "")
text = ""
if isinstance(content, list):
for c in content:
if isinstance(c, dict) and "text" in c:
text += c["text"] + " "
else:
text = str(content)
text = text.strip()
if text:
formatted.append(f"{role.upper()}: {text}")
except Exception:
continue
return "\n".join(formatted)
# ============================================================
# HELPER → GET CUSTOMER + CONVERSATION
# ============================================================
def get_customer_and_conversation(phone: str):
# get customer
customer = supabase.table("customers").select("*").eq("phone", phone).limit(1).execute()
if not customer.data:
new_customer = supabase.table("customers").insert({"phone": phone}).execute()
customer_id = new_customer.data[0]["id"]
else:
customer_id = customer.data[0]["id"]
# get conversation
conv = supabase.table("conversations") \
.select("*") \
.eq("thread_id", phone) \
.limit(1) \
.execute()
if not conv.data:
new_conv = supabase.table("conversations").insert({
"customer_id": customer_id,
"thread_id": phone,
"phone": phone,
"status": "active"
}).execute()
conversation_id = new_conv.data[0]["id"]
else:
conversation_id = conv.data[0]["id"]
return customer_id, conversation_id
# ============================================================
# ESCALATION TOOL
# ============================================================
@function_tool
async def escalate_to_admin_tool(
user_name: str,
email: str,
summary: str,
last_user_message: str,
priority: str,
topics: str,
short_note: str
) -> str:
"""
Escalates conversation to human support.
priority MUST be one of:
low | medium | high | urgent
topics should be a short topic/category for dashboard.
Example: "pricing", "appointment", "delivery issue", "customer complaint"
short_note should be a short dashboard note about this customer.
Example: "Customer asked about pricing and wants human follow-up."
"""
try:
print("\nESCALATION TRIGGERED")
# ==============================
# VALIDATE PRIORITY
# ==============================
allowed_priorities = ["low", "medium", "high", "urgent"]
if priority not in allowed_priorities:
priority = "medium"
normalized_name = (user_name or "").strip()
normalized_email = (email or "").strip()
has_name = normalized_name.casefold() not in {"", "unknown", "not provided", "n/a", "none"}
has_email = bool(re.fullmatch(r"[^@\s]+@[^@\s]+\.[^@\s]+", normalized_email))
# Normal handoffs need usable contact details. Urgent issues bypass this
# guard so a safety-related request is never delayed.
if priority != "urgent" and (not has_name or not has_email):
customer_request = (
"Please send your full name and email address so we can review this."
if not has_name and not has_email
else (
"Please send your full name so we can review this."
if not has_name
else "Please send your email address so we can review this."
)
)
return (
"ESCALATION CONTACT DETAILS REQUIRED. Do not escalate yet and do not "
"return [NEEDS_HUMAN_REPLY]. CUSTOMER RESPONSE MUST BE EXACTLY: "
f"{customer_request}"
)
# ==============================
# THREAD ID = PHONE
# ==============================
phone = get_thread_id() or "unknown"
thread_id = phone
print("Phone:", phone, "Priority:", priority)
# ==============================
# GET CUSTOMER + CONVERSATION IDS
# ==============================
customer_id, conversation_id = get_customer_and_conversation(phone)
# ==============================
# LOAD CHAT HISTORY
# ==============================
session = get_session(thread_id)
messages = await session.get_items()
messages = messages[-20:]
chat_history = format_chat_history(messages)
if last_user_message:
chat_history += f"\nUSER: {last_user_message}"
# ==============================
# HUMAN FINAL MESSAGE
# ==============================
final_ai_message = (
"Got it, let me double check this for you.\n"
"I’m passing this to my team and we’ll get back to you shortly."
)
# Keep the audit trail customer-facing only. The internal handoff itself
# must not be stored as a fake assistant SMS.
# ==============================
# SAFE FALLBACK VALUES
# ==============================
user_name = user_name or "Unknown"
email = email or "Not provided"
topics = topics or "General"
short_note = short_note or summary or "Customer needs human follow-up."
summary = summary or short_note
# ==============================
# UPDATE CUSTOMER INFO
# ==============================
supabase.table("customers").update({
"name": user_name,
"email": email,
"topics": topics,
"short_note": short_note,
"updated_at": "now()"
}).eq("id", customer_id).execute()
# ==============================
# INSERT ESCALATION
# ==============================
supabase.table("escalations").insert({
"customer_id": customer_id,
"conversation_id": conversation_id,
"name": user_name,
"email": email,
"phone": phone,
"summary": summary,
"chat_history": chat_history,
"status": "pending",
"priority": priority,
"updated_at": "now()"
}).execute()
# ==============================
# UPDATE CONVERSATION STATUS
# ==============================
supabase.table("conversations").update({
"status": "escalated",
"priority": priority,
"is_escalated": True,
"ai_enabled": False,
"updated_at": "now()"
}).eq("id", conversation_id).execute()
set_customer_ai_enabled_for_phone(phone, False)
print("Escalation saved with priority:", priority)
_mark_escalation_saved()
return "[NEEDS_HUMAN_REPLY]"
except Exception as e:
print("ESCALATION ERROR:", str(e))
return "[NEEDS_HUMAN_REPLY]"