See BigCommerce orders and Salesforce pipeline for a customer

**Objective:** Give a single view of how much `{customer-email}` has bought in BigCommerce and what is open for them in Salesforce, looking back `{lookback-days}` days for orders (default 365).

**Step 1: Orders in BigCommerce**

Call `bigcommerce-get-customer` (BigCommerce server) with `email` set to `{customer-email}`. If it matches nothing or more than one customer, report that and stop. Then call `bigcommerce-get-order` with `customer-id` set to the customer `id` and `date-created.from` set to the start of the lookback window.

**Step 2: Account and pipeline in Salesforce**

Call `salesforce-get-contact` (Salesforce server) with `email` set to `{customer-email}`. Take its `account-id` and call `salesforce-get-opportunity` with `account-id` and `closed` set to false, then `salesforce-get-case` with `account-id` and `closed` set to false. If no contact exists, report the customer as absent from Salesforce and skip this step.

**Step 3: Report**

Report: order count, sum of `total-including-tax` by `currency-code`, last order date, count of refunded orders (`refunded-amount` above zero); then open opportunities (name, stage, amount, close date) and open cases (case number, subject, priority, status). End with two sentences on what the combined picture suggests.

**Rules & Guidelines:**

* `bigcommerce-get-customer` and `bigcommerce-get-order` are on the BigCommerce server; `salesforce-get-contact`, `salesforce-get-opportunity` and `salesforce-get-case` are on the Salesforce server.
* Read-only. Do not call `salesforce-add-opportunity`, `salesforce-add-case`, `salesforce-update-opportunity`, `salesforce-update-case` or any BigCommerce add, update or delete tool.
* Never add amounts that are in different currencies together.

**Validation:**

* If there are no orders, say so rather than reporting zeros as a result.
* If the contact has no account, report orders only and say the Salesforce side could not be linked.