File size: 10,156 Bytes
9e15897 85f794d 9e15897 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 | import { useEffect, useRef, useState } from "react";
import type { KeyboardEvent } from "react";
import { API_V1, CREDENTIALS } from "../../apiContract";
import { ModeIcon, useOverlayLayer } from "../../customer-grid/seam";
import type { DashboardFigure, OperatorDashboardAdapter } from "./AdsOverview";
import "../../styles/sdlc81/operator-hourly.css";
export interface HourlyCampaign {
ad_type: string; connection_id: string; profile_id: string; campaign_id: string; campaign: string;
}
interface Hour {
date: string; hour: number; spend: number | null; clicks: number | null; orders: number | null;
sales: number | null; acos: number | null; observed: boolean; reason: string | null;
}
interface Report {
state: "ready" | "partial" | "empty" | "unavailable" | "unsupported";
reason: string | null; timezone: string | null; currency: string | null; source_table: string;
rows: Hour[]; totals: Record<string, number | null>;
validation: { ok: boolean; days: { date: string; ok: boolean; hourly_spend: number | null;
daily_spend: number | null; reasons: string[] }[] };
}
type Load = { phase: "loading" } | { phase: "error"; denied: boolean }
| { phase: "ready"; report: Report };
const COLUMNS = [["spend", "Spend"], ["clicks", "Clicks"], ["orders", "Orders"], ["acos", "ACoS"]] as const;
const GROUPS = COLUMNS.map(([id, label]) => ({ id, label, figures: [id] }));
const format = (value: number | null, metric = "spend") => value === null ? "Unavailable"
: value.toLocaleString(undefined, { maximumFractionDigits: metric === "orders" || metric === "clicks" ? 0 : 2 })
+ (metric === "acos" ? "%" : "");
const words = (value: unknown) => typeof value === "string" ? value : "";
const record = (value: unknown): Record<string, unknown> => value && typeof value === "object" && !Array.isArray(value)
? value as Record<string, unknown> : {};
const metric = (value: unknown) => value === null || typeof value === "number" && Number.isFinite(value);
function parse(value: unknown, campaign: HourlyCampaign, day: string): Report {
const body = record(value), validation = record(body.validation);
if (body.campaign_id !== campaign.campaign_id || body.ad_type !== "sp" || body.connection_id !== campaign.connection_id
|| body.profile_id !== campaign.profile_id || body.start !== day || body.end !== day
|| !["ready", "partial", "empty", "unavailable", "unsupported"].includes(words(body.state))
|| !Array.isArray(body.rows) || body.rows.length !== 24 || typeof validation.ok !== "boolean"
|| !Array.isArray(validation.days) || validation.days.length !== 1
|| !body.rows.every((value, index) => {
const row = record(value);
return row.date === day && row.hour === index && typeof row.observed === "boolean"
&& (row.reason === null || typeof row.reason === "string")
&& ["spend", "clicks", "orders", "sales", "acos"].every((key) => metric(row[key]));
}) || !COLUMNS.every(([key]) => metric(record(body.totals)[key]))
|| !validation.days.every((value) => {
const row = record(value);
return row.date === day && typeof row.ok === "boolean" && metric(row.hourly_spend) && metric(row.daily_spend)
&& Array.isArray(row.reasons) && row.reasons.every((reason) => typeof reason === "string");
})) throw new Error("Hourly report unavailable");
return body as unknown as Report;
}
function HourGrid({ rows }: { rows: Hour[] }) {
const ref = useRef<HTMLTableElement>(null);
const [selected, setSelected] = useState(-1);
const navigate = (event: KeyboardEvent<HTMLTableElement>) => {
const cells = Array.from(ref.current?.querySelectorAll<HTMLTableCellElement>("tbody td") ?? []);
const target = event.target as HTMLTableCellElement;
const index = cells.indexOf(target);
const jump = { ArrowDown: 5, ArrowUp: -5, ArrowRight: 1, ArrowLeft: -1 }[event.key];
if (jump !== undefined || event.key === "Home" || event.key === "End") {
event.preventDefault();
const next = cells[event.key === "Home" ? 0 : event.key === "End" ? cells.length - 1
: Math.max(0, Math.min(cells.length - 1, index < 0 ? 0 : index + jump!))];
next?.focus(); next?.scrollIntoView({ block: "nearest", inline: "nearest" });
} else if (event.key === " " || event.key === "Enter") {
event.preventDefault(); setSelected(Number(target.closest("tr")?.dataset.hour ?? -1));
}
};
return <section className="ao-grid-shell ao-hour-grid" data-surface="operator-hourly-grid">
<div className="ao-grid-toolbar"><span className="ao-grid-view"><ModeIcon mode="grid" />Grid view</span></div>
<div className="ao-grid-viewport"><table ref={ref} role="grid" tabIndex={0} onKeyDown={navigate}
className="ao-table" aria-label="Hourly performance grid">
<thead><tr><th scope="col">Hour</th>{COLUMNS.map(([key, label]) =>
<th key={key} scope="col" className="is-num">{label}</th>)}</tr></thead>
<tbody>{rows.map((row) => <tr key={row.hour} data-hour={row.hour} className="ao-row"
aria-selected={selected === row.hour} title={row.reason || undefined}>
<td tabIndex={-1}>{String(row.hour).padStart(2, "0")}:00{row.reason && <small>{row.reason}</small>}</td>
{COLUMNS.map(([key]) => <td key={key} tabIndex={-1} className="is-num" data-metric={key}>{format(row[key], key)}</td>)}
</tr>)}</tbody>
</table></div>
<div className="ao-grid-footer">24 local-hour slots</div>
</section>;
}
export default function ByHour({ appId, campaign, start, end, adapter, onClose }: {
appId: string; campaign: HourlyCampaign; start: string; end: string;
adapter: OperatorDashboardAdapter | null; onClose: () => void;
}) {
const [day, setDay] = useState(end), [attempt, setAttempt] = useState(0);
const [load, setLoad] = useState<Load>({ phase: "loading" });
const panel = useRef<HTMLElement | null>(null);
useOverlayLayer({ panelRef: panel, onDismiss: onClose, dismissOnOutside: false, trapFocus: true, restoreFocus: true });
useEffect(() => {
const controller = new AbortController();
const timer = window.setTimeout(() => controller.abort(), 20000);
let active = true;
setLoad({ phase: "loading" });
const params = new URLSearchParams({ app: appId, campaign_id: campaign.campaign_id, ad_type: campaign.ad_type,
connection_id: campaign.connection_id, profile_id: campaign.profile_id, start: day, end: day });
void fetch(`${API_V1}/app-kinds/amazon_operator/by-hour?${params}`, { credentials: CREDENTIALS, signal: controller.signal })
.then(async (response) => {
if (!response.ok) throw Object.assign(new Error("Hourly report unavailable"),
{ denied: [401, 403, 404].includes(response.status) });
const report = parse(await response.json(), campaign, day);
if (active) setLoad({ phase: "ready", report });
}).catch((error: unknown) => {
if (active) setLoad({ phase: "error", denied: record(error).denied === true });
}).finally(() => window.clearTimeout(timer));
return () => { active = false; controller.abort(); window.clearTimeout(timer); };
}, [appId, campaign, day, attempt]);
const report = load.phase === "ready" ? load.report : null;
const Dashboard = adapter?.AppDashboard;
const figures: DashboardFigure[] = report ? COLUMNS.map(([id, label]) => ({ id, label,
value: report.validation.ok ? report.totals[id] : null, unit: id === "acos" ? "%" : id === "spend" ? report.currency || "" : "",
source_table: report.source_table, validated: report.validation.ok,
reason: report.validation.ok ? null : "Hourly coverage or daily spend needs review",
series: report.validation.ok ? report.rows.map((row) => ({ date: `${row.date}T${String(row.hour).padStart(2, "0")}:00:00`,
value: row[id] })) : [] })) : [];
return <aside ref={panel} role="dialog" aria-modal="true" aria-label="Campaign by hour"
className="ao-drawer ao-hourly" data-surface="operator-hourly">
<div className="ao-drawer-head"><h2 className="ao-drawer-title">By hour</h2>
<button type="button" className="ao-button is-quiet" onClick={onClose}>Close</button></div>
<p className="ao-hourly-campaign" title={campaign.campaign || campaign.campaign_id}>{campaign.campaign || campaign.campaign_id}</p>
<label className="ao-field ao-hourly-day"><span>Day</span><input className="ao-select" type="date" value={day}
min={start} max={end} onChange={(event) => { if (event.target.value >= start && event.target.value <= end) setDay(event.target.value); }} /></label>
{load.phase === "loading" ? <div className="ao-dashboard-loading"><span className="lp-spin lp-spin--lg"
role="status" aria-label="Loading hourly report" /></div>
: load.phase === "error" ? <div className="ao-dashboard-notice" role="status">
<span>{load.denied ? "No permission to view hourly data" : "Hourly report could not be loaded"}</span>
{!load.denied && <button type="button" className="ao-button" onClick={() => setAttempt((value) => value + 1)}>Retry</button>}</div>
: report && <>
<p className="ao-hourly-scope">{report.timezone || "Profile timezone unavailable"} 路 {report.currency || "Currency unavailable"} 路 14 day attribution</p>
{report.reason && <p className="ao-dashboard-notice" role="status">{report.reason}</p>}
{report.validation.days.map((check) => <div key={check.date} className="ao-hourly-check" data-valid={check.ok}
data-surface="operator-hourly-validation" role="status">
<span>{check.date}: Hourly spend {format(check.hourly_spend)} 路 Daily spend {format(check.daily_spend)}</span>
{check.ok ? <span>Within 2%</span> : check.reasons.map((reason) => <span key={reason}>{reason}</span>)}
</div>)}
{report.state !== "empty" && report.state !== "unsupported" && <>
{Dashboard ? <Dashboard figures={figures} comparison={[]} groups={GROUPS} start={day} end={day} comparisonLabel="" />
: <p role="status">Charts unavailable</p>}
<HourGrid key={day} rows={report.rows} />
</>}
</>}
</aside>;
}
|