// Information — Scope 2 (fees) + Scope 3 (W-9 secure document), Draft 3.
// Fees support per-IC custom overrides; both display states are shown via the
// view toggle (in production the schedule resolves automatically from the IC's account).
//
// NOTE: custom override amounts below are SAMPLE values to demonstrate the
// "custom rate" display state — replace with real per-IC data when available.
// Offline seed / fallback. In production the "Default schedule" base rates load
// from the proxied Fee Schedule sheet (src=fees, columns: Service | Description |
// Unit | Base Rate); this array is the seed shown until live rows arrive and the
// fallback if the source is unconfigured/unreachable. The `custom` amounts here
// are SAMPLE per-IC override values — that "My rates" path is a separate build.
const FEE_SCHEDULE = [
{ id: "overnight", icon: "moon", name: "Overnight Service Fee", desc: "Applied when an assignment requires an overnight stay away from your home base.", unit: "per night", std: "$185", custom: "$160" },
{ id: "flight", icon: "plane", name: "Flight Booking Fee", desc: "Per-ticket service fee for air travel booked through the RDB crew travel desk.", unit: "per ticket", std: "$45", custom: "$30" },
];
// Map a Fee Schedule sheet (row 1 headers, row 2 down) to the FeeRow shape.
// Service → name, Description → desc, Unit → unit, Base Rate → std (the dollar
// amount). The sheet carries base rates only; icon + the sample `custom` override
// are matched back from the seed by service name (the "My rates" path is untouched).
function buildFees(text) {
const slug = s => (s || "").toLowerCase().replace(/[^a-z0-9]+/g, "-").replace(/^-|-$/g, "");
const { rows } = rdbParseSheetObjects(text);
return rows
.map(r => {
const name = (r["Service"] || "").trim();
if (!name) return null;
const seed = FEE_SCHEDULE.find(s => s.name.toLowerCase() === name.toLowerCase());
const rate = (r["Base Rate"] || "").trim();
const std = rate ? (rate[0] === "$" ? rate : "$" + rate) : (seed ? seed.std : "");
return {
id: seed ? seed.id : slug(name) || name,
icon: seed ? seed.icon : "dollar-sign",
name,
desc: (r["Description"] || "").trim() || (seed ? seed.desc : ""),
unit: (r["Unit"] || "").trim() || (seed ? seed.unit : ""),
std,
custom: seed ? seed.custom : null,
};
})
.filter(Boolean);
}
// "Default schedule" base rates — live from the proxied sheet, seeded by FEE_SCHEDULE.
function useFees() {
return useSheet(apiUrl("fees"), FEE_SCHEDULE, buildFees);
}
function FeeRow({ f, custom }) {
const overridden = custom && f.custom && f.custom !== f.std;
return (