// ═══════════════════════════════════════════════════════════════ // inventory-invoices.jsx — reading and matching vendor invoices (Inventory Step 6) // ═══════════════════════════════════════════════════════════════ // // WHAT THIS IS (in plain English): // Its own "Invoices" tab in the Stock Room, with two independent flows: // // Supplies invoices — matched against one specific Purchase Order. Pick // the PO (or let it auto-detect from the invoice), upload or paste the // invoice, and each line comes back as matched, price doesn't match the // PO, billed in different packaging than ordered (the dollar totals // agree even though the per-unit numbers don't), billed but not on the // PO, or on the PO but not billed yet. // // Lens (IOL) invoices — matched against what was actually dispensed to a // patient, mostly by serial number. Catches a lens billed but never // implanted, billed at the wrong price, or — the STAAR case — billed // after it was shipped back as a return. (That last check only finds // something once Step 7 builds real lens-return tracking; it is wired up // now so nothing else needs to change when that lands.) // // Reading the file: a PDF's text layer is read right in the browser with // the pdf.js reader already loaded for the app (window.loadPdfWithTimeout, // set up in index.html) — no scanning/OCR, and nothing new added to the // server's dependencies. A CSV works the same way via Papa Parse (already // vendored). Anything else — or a PDF that turns out to be a scanned // image with no text layer — falls back to pasting the invoice text by // hand. Every line that gets read is shown for a person to check (and fix, // if the general-purpose reader misread something) before anything is // matched. The actual reading and matching logic lives on the server // (invoices.js) so the same logic is used and tested the same way // regardless of how the text got there. // // Nothing here is ever silent: a price that doesn't match is only updated // in the catalog when someone clicks "Update catalog price" on that exact // line. Every completed reconciliation is logged to the `invoices` drawer // (dated, who did it, what matched) so there is a real record, and a // reconciled PO gets a small badge next to its status. // ═══════════════════════════════════════════════════════════════ // ─── Turning a file into plain text ──────────────────────────── async function invExtractPdfText(file) { const buf = await file.arrayBuffer(); const pdf = await window.loadPdfWithTimeout(buf, 20000); let text = ''; for (let p = 1; p <= pdf.numPages; p++) { const page = await pdf.getPage(p); const content = await page.getTextContent(); const rowsByY = {}; content.items.forEach((it) => { const y = Math.round(it.transform[5]); (rowsByY[y] = rowsByY[y] || []).push({ x: it.transform[4], s: it.str }); }); Object.keys(rowsByY).map(Number).sort((a, b) => b - a).forEach((y) => { const line = rowsByY[y].sort((a, b) => a.x - b.x).map((o) => o.s).join(' ').replace(/\s+/g, ' ').trim(); if (line) text += line + '\n'; }); } if (!text.trim()) throw new Error("Couldn't find any text in that PDF — it may be a scanned image. Paste the invoice text instead."); return text; } function invExtractCsvText(file) { return new Promise((resolve, reject) => { if (!window.Papa) { reject(new Error('The CSV reader is not available — reload the page and try again.')); return; } window.Papa.parse(file, { complete: (res) => resolve((res.data || []).map((r) => (Array.isArray(r) ? r.join(' ') : String(r))).join('\n')), error: (err) => reject(new Error(err.message || 'Could not read that CSV file.')), }); }); } async function invReadInvoiceFile(file) { const name = (file.name || '').toLowerCase(); if (name.endsWith('.pdf')) return invExtractPdfText(file); if (name.endsWith('.csv')) return invExtractCsvText(file); throw new Error('Use a PDF or CSV file, or paste the invoice text instead.'); } // ─── Upload + paste widget (shared by both sections) ──────────── function InvInvoiceInput({ onText, busy, setBusy }) { const fileRef = invUseRef(null); const [paste, setPaste] = invUseState(''); const [pasteOpen, setPasteOpen] = invUseState(false); const [err, setErr] = invUseState(''); const handleFile = async (file) => { setErr(''); setBusy(true); try { const text = await invReadInvoiceFile(file); await onText(text, file.name); } catch (e) { setErr(e.message); } setBusy(false); }; return (
{ const f = e.target.files[0]; e.target.value = ''; if (f) handleFile(f); }} /> {busy && Reading…}
{pasteOpen && (