Got it 👍 — here’s the entire thing as one single copy-ready block, with no markdown boxes, no code fences — just plain text for you to copy straight into your Replit agent in one go:

⸻

Please edit the file cli/manager_cli.py and add a new Typer command called tcard. Follow the same style and Supabase client pattern already used in this file (for example, whatever the list_due, recent_msgs, or appts commands do to talk to Supabase).

The command should be callable from the Replit Shell as:
python cli/manager_cli.py tcard –agreement-number 0000440141796331

Use a Typer option:
agreement_number: str = typer.Option(…, “–agreement-number”)

Purpose: This command should display a T-Card summary for one customer agreement, combining summary, appointments, and recent messages in a clean console output format.

Data Sources:

1️⃣ Summary – from v_tcard_summary
Filter by agreement_number
Select these fields:
	•	customer_name
	•	registration
	•	model
	•	asset_type
	•	end_date
	•	monthly_payment
	•	true_equity
	•	equity_flag
	•	next_followup_at
	•	last_lost_reason_label
If no row is found, print “No record found for that agreement number.” and exit.

2️⃣ Appointments – from v_tcard_appointments
Filter by agreement_number
Order by created_at desc
Show for each row:
	•	preferred_date
	•	preferred_time
	•	status
	•	reminder_channel
	•	thanks_needed
If none found, print “No appointments found.”

3️⃣ Messages – from v_tcard_contact_timeline
Filter by agreement_number
Order by happened_at desc
Limit to last 10–20 messages
Show:
	•	happened_at
	•	direction (render as → for outbound, ← for inbound)
	•	first ~100 chars of message_text (replace newlines with spaces, handle nulls)

Output Format (console text):

Summary section:
📇 T-CARD SUMMARY
──────────────────────────────
Customer:      Jonathan Jordan
Vehicle:       Q5 DIESEL ESTATE (FY72UBT)
Asset Type:    N
Agreement End: 2026-10-15
Payment:       £435.99
Equity:        £1500.00 [green]
Next Follow-Up:2025-12-03 18:53
Lost Reason:   Monthly payment too high

If any fields are NULL, show — instead of crashing.

Appointments section:
📅 APPOINTMENTS
Date        Time    Status    Reminder  Thanks
2025-11-07  10:30   new       whatsapp  False

Recent Messages section:
💬 RECENT MESSAGES
10-Nov 12:30 → Hi Jonathan, it’s Lia from the Loyalty Team at Lincoln Audi. Just a quick reminder about your visit…
06-Nov 20:24 ← 12 Nov at 2pm

Truncate message text to roughly 100 characters and replace newlines with spaces.

Implementation Details:
Use the same Supabase client or Postgres connector already in use in your CLI. Handle database connections cleanly and close them after execution. Wrap logic in a function called tcard_view(). Register it with @app.command(“tcard”). Keep all existing CLI commands intact.

Once implemented:
After saving the file, open the Replit Shell and run:
python cli/manager_cli.py tcard –agreement-number 0000440141796331

Then return the console output so I can review the layout.

(end of prompt)

⸻

✅ Copy everything from “Please edit the file…” down to “(end of prompt)” — that’s one clean block your Replit agent will take in a single paste.