Know which Business Central deals have a warm contact

**Objective:** For open Business Central opportunities (optionally for salesperson `{salesperson-code}`), show each contact's Drip engagement so sales knows who is warm, cold or unreachable by email. Use Business Central company `{bc-company}` if given.

**Step 1: Read open opportunities**

Call `business-central-get-opportunity` with `closed` set to false, and `salesperson-code` set to `{salesperson-code}` if given. Keep `opportunity-number`, `description`, `contact-number`, `contact-name`, `contact-company-name`, `estimated-value`, `estimated-closing-date`, `salesperson-code`.

**Step 2: Get each contact's email**

For each distinct `contact-number`, call `business-central-get-contact` with `contact-number` set to it and keep its `email`.

**Step 3: Carry the email into Drip**

For each email, call `drip-get-subscriber` with `email` set to it, then `drip-get-campaign-subscriber` with the same `email`.

**Step 4: Report**

A table sorted by `estimated-closing-date`: opportunity, contact, company, estimated value, closing date, Drip status, lead score, active campaigns. Mark each row Warm (active, lead score 50 or more), Cold (active, below 50), Unsubscribed, Not in Drip, or No email. Finish with the total estimated value in each group.

**Rules & Guidelines:**

* Tools whose names start with drip are on the drip server; tools whose names start with business-central are on the business-central server. Pass `{bc-company}` only to business-central tools.
* This prompt is read-only. Do NOT call `business-central-update-opportunity`, `drip-add-subscriber`, `drip-add-subscriber-to-campaign` or `drip-start-subscriber-workflow`.

**Validation:**

* If there are no open opportunities, say so and stop.
* If an opportunity has no contact number, show it under No email.
* Compare emails case-insensitively and ignoring surrounding spaces.