);
};
/* ══════════════ RC36 (sec36): the empty state + the 'Payroll employees' import (CSV / Excel → POST /api/payroll/employees/import) ══════════════ */
const PtEmpty = ({ pr, onImport }) => (
{pr.status === "loading" &&
Loading the employee list…
}
{pr.status === "denied" &&
Payroll is kept for the office only. Admin / F&I, the Office Manager and Accounting can see the employees here. Ask the office.
}
{pr.status === "error" &&
⚠ {pr.error || "The employee list could not be loaded."}
}
{pr.status === "ok" &&
No employees loaded
The W-2 / 941 amounts come from the employee list. Load it from your payroll company's year-end report: fill in the template (one row per employee) and press Import employees. The Social Security numbers are stored encrypted on the server; this screen only ever shows their last 4 digits.
);
const PT_HEAD = { id: ["employee id", "employee #", "employee no", "employee number", "emp id", "emp #", "emp no", "id"], ssn: ["ssn", "social security number", "social security #", "social security no", "ss #", "ss number", "ssn #"],
first: ["first", "first name", "firstname", "given name"], mid: ["mid", "middle", "middle name", "mi", "middle initial"], last: ["last", "last name", "lastname", "surname", "family name"],
name: ["name", "full name", "employee name", "employee"], addr: ["address", "street", "street address", "addr", "home address", "address 1"], city: ["city"], state: ["state", "st"],
zip: ["zip", "zip code", "zipcode", "postal", "postal code"], title: ["title", "job title", "position", "job"], ftpt: ["ft/pt", "ftpt", "full/part time", "full or part", "ft pt", "status"],
box1: ["box 1", "box1", "box 1 wages", "wages", "wages tips other comp", "wages tips other compensation", "box 1 wages tips other comp"],
fit: ["box 2", "box2", "fit", "federal income tax withheld", "federal tax withheld", "box 2 federal tax withheld", "box 2 federal income tax withheld", "federal withholding"],
ssWages: ["box 3", "box3", "ss wages", "social security wages", "box 3 social security wages"], ssWH: ["box 4", "box4", "ss wh", "ss withheld", "social security tax withheld", "box 4 social security tax withheld"],
medWages: ["box 5", "box5", "medicare wages", "medicare wages and tips", "med wages", "box 5 medicare wages", "box 5 medicare wages and tips"], medWH: ["box 6", "box6", "medicare wh", "medicare tax withheld", "med wh", "box 6 medicare tax withheld"],
stateWages: ["box 16", "box16", "state wages", "state wages tips etc", "box 16 state wages"], stateWH: ["box 17", "box17", "state wh", "state income tax", "state tax withheld", "box 17 state income tax"] };
const ptNorm = (h) => String(h || "").toLowerCase().replace(/[^a-z0-9/# ]/g, " ").replace(/\s+/g, " ").trim();
const ptSsnOk = (v) => { const d = String(v || "").replace(/[\s-]/g, ""); return /^\d{9}$/.test(d) && !/^(000|666|9)/.test(d) && d.slice(3, 5) !== "00" && d.slice(5) !== "0000"; };
const ptMapRows = (rows) => {
const headers = rows.length ? Object.keys(rows[0]) : [];
const map = {};
headers.forEach((h) => { const n = ptNorm(h); const f = Object.keys(PT_HEAD).find((k) => PT_HEAD[k].indexOf(n) !== -1); if (f && !map[f]) map[f] = h; });
const out = [], problems = [];
rows.forEach((r, i) => {
const o = {}; Object.keys(map).forEach((f) => { const v = r[map[f]]; o[f] = v === undefined || v === null ? "" : String(v).trim(); });
if (!Object.values(o).some((v) => v)) return;
const why = !o.id ? "no employee id" : !ptSsnOk(o.ssn) ? "the SSN is not a valid 9-digit number" : !(o.last || o.name) ? "no name" : null;
if (why) problems.push({ row: i + 2, why });
out.push(o);
});
return { map, headers, rows: out, problems };
};
const PtImportDialog = ({ year, onClose, onDone }) => {
const [y, setY] = React.useState(String(year || new Date().getFullYear() - 1));
const [file, setFile] = React.useState(null);
const [plan, setPlan] = React.useState(null);
const [err, setErr] = React.useState("");
const [busy, setBusy] = React.useState(false);
const [result, setResult] = React.useState(null);
const [imports, setImports] = React.useState([]);
const keyRef = React.useRef("pe-" + Date.now().toString(36) + "-" + Math.random().toString(36).slice(2, 10));
const loadImports = async () => { const r = await ptApi("/payroll/employees/imports"); if (r.ok) setImports(r.data.imports || []); };
React.useEffect(() => { loadImports(); }, []);
const pick = async (f) => {
setErr(""); setPlan(null); setResult(null); setFile(f || null); if (!f) return;
try {
const I = window.JBImporters; if (!I) throw new Error("The file reader is not loaded on this page.");
let rows;
if (/\.(xlsx|xls)$/i.test(f.name)) { const wb = await I.parseExcel(f); const names = Object.keys(wb); const nm = names.find((n) => /payroll|employee|w-?2/i.test(n)) || names[0]; rows = nm ? wb[nm] : []; }
else rows = I.parseCSVText(await new Promise((res, rej) => { const r = new FileReader(); r.onload = () => res(String(r.result)); r.onerror = rej; r.readAsText(f); }));
const p = ptMapRows(rows || []);
if (!p.map.id || !p.map.ssn) throw new Error("This file has no 'Employee ID' and 'SSN' columns. Use the template's column names (Download the template).");
setPlan(p);
} catch (e) { setErr(e.message || String(e)); }
};
const go = async () => {
if (!plan || busy) return;
if (!/^\d{4}$/.test(y)) { setErr("Type the tax year (for example 2025)."); return; }
setBusy(true); setErr("");
const r = await ptApi("/payroll/employees/import", "POST", { year: Number(y), rows: plan.rows }, { "Idempotency-Key": keyRef.current });
setBusy(false);
if (!r.ok) { setErr(r.error); if (r.data && r.data.rejected) setResult({ counts: null, rejected: r.data.rejected }); return; }
setResult(r.data); loadImports();
};
const undo = async (runId) => {
if (!window.confirm("Undo this import? Every employee goes back to how it was before it (employees it added are removed).")) return;
const r = await ptApi("/payroll/employees/undo", "POST", { runId });
window.k2bToast && window.k2bToast(r.ok ? `Import undone: ${r.data.removed} removed, ${r.data.restored} put back.` : r.error, r.ok ? "ok" : "warn", 5000);
loadImports(); if (r.ok) onDone && onDone();
};
const lastUndoable = imports.find((x) => !x.undone);
const box = { position: "fixed", inset: 0, background: "rgba(0,0,0,.35)", display: "flex", alignItems: "center", justifyContent: "center", zIndex: 9000, padding: 12 };
return (
{ if (e.target === e.currentTarget) onClose(); }}>
Import payroll employees
One row per employee with the year's W-2 amounts (boxes 1-6, 16, 17). The same employee ID again updates that employee. SSNs are stored encrypted; this screen never shows them. Template (CSV)
pick(e.target.files && e.target.files[0])} />
{plan && !result &&
{plan.rows.length} employee row(s) in {file && file.name}{plan.problems.length ? — {plan.problems.length} with a problem (they are not imported): : — no problems found.}
{plan.problems.length > 0 &&