[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_215":216,"_217":218},"routes/_app.x.$handle.$name",{"_97":96,"_32":45,"_106":87,"_27":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":25,"_121":122,"_123":59,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",8,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","file_pipeline.ts","latestPath","fileId","33b205c4-af6c-11f1-973f-1607ee4eb77e","name","fileType","script","content","// IMPERIAL Core — Alexander Romaskevich / RomaskevicH. Internal prototype, not a client delivery.\nimport {getDocumentProxy} from \"npm:unpdf@1.8.1\";\nimport ExcelJS from \"npm:exceljs@4.4.0\";\nimport {buildQuote,type CatalogueRow,type PriceRow} from \"./core.ts\";\nexport const FORMAT=\"IMPERIAL RFQ DEMO V1\",COLUMNS=\"CODE | QUANTITY | UNIT | DESCRIPTION\";\nexport type SourceRow={page:number;line:number;raw:string};\nconst HEADER_SET=new Set([FORMAT,COLUMNS]);\nexport async function hashBytes(bytes:Uint8Array){return [...new Uint8Array(await crypto.subtle.digest(\"SHA-256\",bytes))].map(x=>x.toString(16).padStart(2,\"0\")).join(\"\");}\nexport async function readPdfRows(bytes:Uint8Array){\n if(bytes.byteLength>2*1024*1024||bytes.byteLength<5)throw Error(\"PDF_SIZE_LIMIT\");\n if(new TextDecoder().decode(bytes.slice(0,5))!==\"%PDF-\")throw Error(\"PDF_REQUIRED\");\n const pdf=await getDocumentProxy(bytes.slice(),{isEvalSupported:false,disableFontFace:true,useSystemFonts:false});\n const rows:SourceRow[]=[];let characters=0;\n try{\n if(pdf.numPages>5)throw Error(\"PDF_PAGE_LIMIT\");\n for(let p=1;p<=pdf.numPages;p++){\n const page=await pdf.getPage(p),content=await page.getTextContent();\n if(content.items.length>10000)throw Error(\"PDF_ITEM_LIMIT\");\n let current=\"\",lastY:number|null=null,line=0;\n const flush=()=>{if(current.trim()){rows.push({page:p,line:++line,raw:current.trim()});current=\"\";}};\n for(const item of content.items as any[]){\n if(typeof item.str!==\"string\")continue;\n characters+=item.str.length;if(characters>20000)throw Error(\"PDF_TEXT_LIMIT\");\n const y=Number(item.transform?.[5]??0);\n if(lastY!==null&&Math.abs(y-lastY)>2)flush();\n current+=(current&&!current.endsWith(\" \")?\" \":\"\")+item.str;lastY=y;\n if(item.hasEOL)flush();\n }\n flush();if(line===0)rows.push({page:p,line:0,raw:\"[NO_EXTRACTABLE_TEXT_PAGE]\"});\n }\n return {rows,pages:pdf.numPages,pdf_sha256:await hashBytes(bytes)};\n }finally{await pdf.destroy();}\n}\nexport function parseRows(rows:SourceRow[]){\n if(!rows.length||rows[0].raw!==FORMAT)throw Error(\"UNSUPPORTED_LAYOUT_OR_SCANNED_PDF\");\n const lines:any[]=[],issues:any[]=[];\n for(const source of rows){\n if(HEADER_SET.has(source.raw))continue;\n const parts=source.raw.split(\"|\").map(v=>v.trim());\n if(parts.length!==4||!/^[A-Za-z0-9_.-]{1,64}$/.test(parts[0])||!/^[A-Za-z0-9_/-]{1,16}$/.test(parts[2])){\n issues.push({...source,status:\"REVIEW\",reason:\"UNPARSED_SOURCE_ROW\"});continue;\n }\n if(!/^[1-9][0-9]{0,8}$/.test(parts[1])){\n issues.push({...source,status:\"REVIEW\",reason:\"INVALID_QUANTITY\"});continue;\n }\n lines.push({code:parts[0],quantity:Number(parts[1]),unit:parts[2],description:parts[3],source});\n }\n if(lines.length+issues.length===0)issues.push({page:1,line:0,raw:\"\",status:\"REVIEW\",reason:\"NO_LINE_ITEMS\"});\n if(lines.length+issues.length>250)throw Error(\"RFQ_ROW_LIMIT\");\n return {lines,issues};\n}\nexport function validateSources(catalogue:CatalogueRow[],prices:PriceRow[]){\n if(!Array.isArray(catalogue)||!Array.isArray(prices)||catalogue.length>500||prices.length>500)throw Error(\"CATALOGUE_SIZE_LIMIT\");\n const text=(v:any,n:number)=>typeof v===\"string\"&&v.trim().length>0&&v.length<=n;\n for(const r of catalogue)if(!r||!text(r.code,64)||!text(r.unit,16)||!text(r.description,500))throw Error(\"INVALID_CATALOGUE_ROW\");\n for(const r of prices)if(!r||!text(r.code,64)||!text(r.unit,16)||typeof r.amountMinor!==\"bigint\"||r.amountMinor<0n||r.amountMinor>999999999999999n||!text(r.priceListVersion,100)||typeof r.currency!==\"string\"||!/^[A-Z]{3}$/.test(r.currency))throw Error(\"INVALID_APPROVED_PRICE\");\n}\nexport function quoteParsed(parsed:ReturnType,catalogue:CatalogueRow[],prices:PriceRow[]){\n validateSources(catalogue,prices);\n const base=buildQuote(parsed.lines,catalogue,prices);\n const issues=[...parsed.issues];\n const results=base.results.map((r:any)=>({...r,source:parsed.lines[r.index].source,description:parsed.lines[r.index].description,requestedQuantity:parsed.lines[r.index].quantity,requestedUnit:parsed.lines[r.index].unit}));\n if(new Set(results.filter(r=>r.status===\"MATCHED\").map(r=>r.currency)).size>1)issues.push({page:0,line:0,raw:\"\",status:\"REVIEW\",reason:\"MIXED_CURRENCIES_NO_CONVERSION\"});\n const reviewRequired=base.reviewRequired||issues.length>0;\n return {...base,truth:\"PROTOTYPE_DRAFT_NOT_CLIENT_ACCEPTED\",results,issues,reviewRequired,totalMinor:reviewRequired?null:base.totalMinor};\n}\nexport async function writeWorkbook(quote:ReturnType,source:{pdf_sha256:string;pages:number}){\n const wb=new ExcelJS.Workbook();wb.creator=\"Alexander Romaskevich / RomaskevicH\";wb.title=\"RFQ quotation draft — review required\";\n const rows=wb.addWorksheet(\"Quote Draft\"),review=wb.addWorksheet(\"Review\"),meta=wb.addWorksheet(\"Evidence\");\n rows.addRow([\"Page\",\"Source line\",\"Source text\",\"Code\",\"Description from RFQ\",\"Quantity\",\"Unit\",\"Match status\",\"Reason\",\"Line amount minor units (exact text)\",\"Currency\",\"Approved price list version\"]);\n for(const r of quote.results as any[])rows.addRow([r.source.page,r.source.line,r.source.raw,r.code,r.description,r.requestedQuantity,r.requestedUnit,r.status,r.reason??\"\",r.amountMinor??\"\",r.currency??\"\",r.priceListVersion??\"\"]);\n review.addRow([\"Page\",\"Source line\",\"Source text\",\"Reason\"]);\n for(const r of quote.results as any[])if(r.status===\"REVIEW\")review.addRow([r.source.page,r.source.line,r.source.raw,r.reason]);\n for(const r of quote.issues)review.addRow([r.page,r.line,r.raw,r.reason]);\n meta.addRows([\n [\"Status\",\"INTERNAL PROTOTYPE / NOT CLIENT ACCEPTED\"],\n [\"PDF SHA-256\",source.pdf_sha256],[\"PDF pages\",source.pages],\n [\"Layout\",FORMAT],[\"Review required\",quote.reviewRequired?\"YES\":\"NO\"],\n [\"Grand total minor units (exact text)\",quote.totalMinor??\"WITHHELD\"],\n [\"Currency\",quote.currency??\"UNRESOLVED\"],[\"Money representation\",\"Integer minor units as text; no assumed decimal precision, tax or FX\"],\n [\"Matching\",\"Exact normalized code and unit; no fuzzy confidence or product substitution\"],\n [\"Approval boundary\",\"Supplied price rows are inputs, not proof of buyer authorization. Final delivery requires agreed scope and independent QA.\"]\n ]);\n for(const sheet of [rows,review,meta]){\n sheet.getRow(1).font={bold:true};sheet.views=[{state:\"frozen\",ySplit:1}];\n sheet.columns.forEach((col:any,i:number)=>{col.width=i===2?60:26;});\n sheet.eachRow(row=>row.eachCell(cell=>{if(typeof cell.value===\"string\")cell.numFmt=\"@\";}));\n }\n // Strings remain string cells, never Excel formula objects. No executable formulas or external links.\n return new Uint8Array(await wb.xlsx.writeBuffer());\n}\nexport async function processPdfQuote(bytes:Uint8Array,catalogue:CatalogueRow[],prices:PriceRow[]){\n validateSources(catalogue,prices);\n const extracted=await readPdfRows(bytes),parsed=parseRows(extracted.rows),quote=quoteParsed(parsed,catalogue,prices);\n const xlsx=await writeWorkbook(quote,extracted);\n return {quote,xlsx,evidence:{pdf_sha256:extracted.pdf_sha256,xlsx_sha256:await hashBytes(xlsx),pages:extracted.pages,format:FORMAT,client_delivery_ready:false}};\n}\n","// IMPERIAL Core — Alexander Romaskevich / RomaskevicH. Internal prototype, not a client delivery.\nimport {getDocumentProxy} from \"npm:unpdf@1.8.1\";\nimport ExcelJS from \"npm:exceljs@4.4.0/dist/exceljs.min.js\";\nimport {buildQuote,type CatalogueRow,type PriceRow} from \"./core.ts\";\nexport const FORMAT=\"IMPERIAL RFQ DEMO V1\",COLUMNS=\"CODE | QUANTITY | UNIT | DESCRIPTION\";\nexport type SourceRow={page:number;line:number;raw:string};\nconst HEADER_SET=new Set([FORMAT,COLUMNS]);\nexport async function hashBytes(bytes:Uint8Array){return [...new Uint8Array(await crypto.subtle.digest(\"SHA-256\",bytes))].map(x=>x.toString(16).padStart(2,\"0\")).join(\"\");}\nexport async function readPdfRows(bytes:Uint8Array){\n if(bytes.byteLength>2*1024*1024||bytes.byteLength<5)throw Error(\"PDF_SIZE_LIMIT\");\n if(new TextDecoder().decode(bytes.slice(0,5))!==\"%PDF-\")throw Error(\"PDF_REQUIRED\");\n const pdf=await getDocumentProxy(bytes.slice(),{isEvalSupported:false,disableFontFace:true,useSystemFonts:false});\n const rows:SourceRow[]=[];let characters=0;\n try{\n if(pdf.numPages>5)throw Error(\"PDF_PAGE_LIMIT\");\n for(let p=1;p<=pdf.numPages;p++){\n const page=await pdf.getPage(p),content=await page.getTextContent();\n if(content.items.length>10000)throw Error(\"PDF_ITEM_LIMIT\");\n let current=\"\",lastY:number|null=null,line=0;\n const flush=()=>{if(current.trim()){rows.push({page:p,line:++line,raw:current.trim()});current=\"\";}};\n for(const item of content.items as any[]){\n if(typeof item.str!==\"string\")continue;\n characters+=item.str.length;if(characters>20000)throw Error(\"PDF_TEXT_LIMIT\");\n const y=Number(item.transform?.[5]??0);\n if(lastY!==null&&Math.abs(y-lastY)>2)flush();\n current+=(current&&!current.endsWith(\" \")?\" \":\"\")+item.str;lastY=y;\n if(item.hasEOL)flush();\n }\n flush();if(line===0)rows.push({page:p,line:0,raw:\"[NO_EXTRACTABLE_TEXT_PAGE]\"});\n }\n return {rows,pages:pdf.numPages,pdf_sha256:await hashBytes(bytes)};\n }finally{await pdf.destroy();}\n}\nexport function parseRows(rows:SourceRow[]){\n if(!rows.length||rows[0].raw!==FORMAT)throw Error(\"UNSUPPORTED_LAYOUT_OR_SCANNED_PDF\");\n const lines:any[]=[],issues:any[]=[];\n for(const source of rows){\n if(HEADER_SET.has(source.raw))continue;\n const parts=source.raw.split(\"|\").map(v=>v.trim());\n if(parts.length!==4||!/^[A-Za-z0-9_.-]{1,64}$/.test(parts[0])||!/^[A-Za-z0-9_/-]{1,16}$/.test(parts[2])){\n issues.push({...source,status:\"REVIEW\",reason:\"UNPARSED_SOURCE_ROW\"});continue;\n }\n if(!/^[1-9][0-9]{0,8}$/.test(parts[1])){\n issues.push({...source,status:\"REVIEW\",reason:\"INVALID_QUANTITY\"});continue;\n }\n lines.push({code:parts[0],quantity:Number(parts[1]),unit:parts[2],description:parts[3],source});\n }\n if(lines.length+issues.length===0)issues.push({page:1,line:0,raw:\"\",status:\"REVIEW\",reason:\"NO_LINE_ITEMS\"});\n if(lines.length+issues.length>250)throw Error(\"RFQ_ROW_LIMIT\");\n return {lines,issues};\n}\nexport function validateSources(catalogue:CatalogueRow[],prices:PriceRow[]){\n if(!Array.isArray(catalogue)||!Array.isArray(prices)||catalogue.length>500||prices.length>500)throw Error(\"CATALOGUE_SIZE_LIMIT\");\n const text=(v:any,n:number)=>typeof v===\"string\"&&v.trim().length>0&&v.length<=n;\n for(const r of catalogue)if(!r||!text(r.code,64)||!text(r.unit,16)||!text(r.description,500))throw Error(\"INVALID_CATALOGUE_ROW\");\n for(const r of prices)if(!r||!text(r.code,64)||!text(r.unit,16)||typeof r.amountMinor!==\"bigint\"||r.amountMinor<0n||r.amountMinor>999999999999999n||!text(r.priceListVersion,100)||typeof r.currency!==\"string\"||!/^[A-Z]{3}$/.test(r.currency))throw Error(\"INVALID_APPROVED_PRICE\");\n}\nexport function quoteParsed(parsed:ReturnType,catalogue:CatalogueRow[],prices:PriceRow[]){\n validateSources(catalogue,prices);\n const base=buildQuote(parsed.lines,catalogue,prices);\n const issues=[...parsed.issues];\n const results=base.results.map((r:any)=>({...r,source:parsed.lines[r.index].source,description:parsed.lines[r.index].description,requestedQuantity:parsed.lines[r.index].quantity,requestedUnit:parsed.lines[r.index].unit}));\n if(new Set(results.filter(r=>r.status===\"MATCHED\").map(r=>r.currency)).size>1)issues.push({page:0,line:0,raw:\"\",status:\"REVIEW\",reason:\"MIXED_CURRENCIES_NO_CONVERSION\"});\n const reviewRequired=base.reviewRequired||issues.length>0;\n return {...base,truth:\"PROTOTYPE_DRAFT_NOT_CLIENT_ACCEPTED\",results,issues,reviewRequired,totalMinor:reviewRequired?null:base.totalMinor};\n}\nexport async function writeWorkbook(quote:ReturnType,source:{pdf_sha256:string;pages:number}){\n const wb=new ExcelJS.Workbook();wb.creator=\"Alexander Romaskevich / RomaskevicH\";wb.title=\"RFQ quotation draft — review required\";\n const rows=wb.addWorksheet(\"Quote Draft\"),review=wb.addWorksheet(\"Review\"),meta=wb.addWorksheet(\"Evidence\");\n rows.addRow([\"Page\",\"Source line\",\"Source text\",\"Code\",\"Description from RFQ\",\"Quantity\",\"Unit\",\"Match status\",\"Reason\",\"Line amount minor units (exact text)\",\"Currency\",\"Approved price list version\"]);\n for(const r of quote.results as any[])rows.addRow([r.source.page,r.source.line,r.source.raw,r.code,r.description,r.requestedQuantity,r.requestedUnit,r.status,r.reason??\"\",r.amountMinor??\"\",r.currency??\"\",r.priceListVersion??\"\"]);\n review.addRow([\"Page\",\"Source line\",\"Source text\",\"Reason\"]);\n for(const r of quote.results as any[])if(r.status===\"REVIEW\")review.addRow([r.source.page,r.source.line,r.source.raw,r.reason]);\n for(const r of quote.issues)review.addRow([r.page,r.line,r.raw,r.reason]);\n meta.addRows([\n [\"Status\",\"INTERNAL PROTOTYPE / NOT CLIENT ACCEPTED\"],\n [\"PDF SHA-256\",source.pdf_sha256],[\"PDF pages\",source.pages],\n [\"Layout\",FORMAT],[\"Review required\",quote.reviewRequired?\"YES\":\"NO\"],\n [\"Grand total minor units (exact text)\",quote.totalMinor??\"WITHHELD\"],\n [\"Currency\",quote.currency??\"UNRESOLVED\"],[\"Money representation\",\"Integer minor units as text; no assumed decimal precision, tax or FX\"],\n [\"Matching\",\"Exact normalized code and unit; no fuzzy confidence or product substitution\"],\n [\"Approval boundary\",\"Supplied price rows are inputs, not proof of buyer authorization. Final delivery requires agreed scope and independent QA.\"]\n ]);\n for(const sheet of [rows,review,meta]){\n sheet.getRow(1).font={bold:true};sheet.views=[{state:\"frozen\",ySplit:1}];\n sheet.columns.forEach((col:any,i:number)=>{col.width=i===2?60:26;});\n sheet.eachRow(row=>row.eachCell(cell=>{if(typeof cell.value===\"string\")cell.numFmt=\"@\";}));\n }\n // Strings remain string cells, never Excel formula objects. No executable formulas or external links.\n return new Uint8Array(await wb.xlsx.writeBuffer());\n}\nexport async function processPdfQuote(bytes:Uint8Array,catalogue:CatalogueRow[],prices:PriceRow[]){\n validateSources(catalogue,prices);\n const extracted=await readPdfRows(bytes),parsed=parseRows(extracted.rows),quote=quoteParsed(parsed,catalogue,prices);\n const xlsx=await writeWorkbook(quote,extracted);\n return {quote,xlsx,evidence:{pdf_sha256:extracted.pdf_sha256,xlsx_sha256:await hashBytes(xlsx),pages:extracted.pages,format:FORMAT,client_delivery_ready:false}};\n}\n","createdAt",["D",1789318933419],"branchVersion","branchId","449e6448-184a-4c95-b56e-5b393436d247","id","7b9523fe-5ae3-42e1-89ab-1f22eb74f8bf","imperial-rfq-quote-demo",["D",1789075806931],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Synthetic RFQ-to-quote proof for paid-test qualification","imageUrl","fe39b163-4b50-466e-82d1-8bd01133e4b6","pinnedFileId","cb5ad9c4-ad5e-11f1-ab8b-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a03585-eb44-758d-92a4-77db1a9a243c","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_105":101},"org",{"_97":96,"_98":99,"_100":101,"_18":55,"_102":103,"_104":25},"branch",{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"isOwned",18,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","oromaskevic23","handle","displayName","Олександр Ромаскевич","avatar","https://lh3.googleusercontent.com/a/ACg8ocIo1MJ3hDjpQrinMIRok3d2YY1vpHgehs8m2u1_vc7pmFovRGI=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":211,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":212,"_81":213,"_83":214,"_85":25},"tree",[186,187,188,189,190,191],"files",[186,187,188,189,190,191],"counts",{"_176":63,"_177":155,"_178":63,"_179":180,"_181":182},"contents",[128,129,130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":169,"_32":170,"_30":171,"_137":-5,"_41":42,"_40":172,"_139":59,"_38":173,"_13":63,"_33":34,"_35":174,"_24":25,"_142":-5,"_27":175},{"_43":166,"_32":28,"_30":31,"_137":-5,"_41":42,"_40":14,"_139":25,"_38":167,"_13":155,"_33":34,"_35":37,"_24":25,"_142":-5,"_27":168},{"_43":159,"_32":160,"_30":161,"_137":-5,"_41":42,"_40":162,"_139":25,"_38":163,"_13":63,"_33":34,"_35":164,"_24":25,"_142":-5,"_27":165},{"_43":151,"_32":152,"_30":57,"_137":-5,"_41":42,"_40":153,"_139":25,"_38":154,"_13":155,"_33":156,"_35":157,"_24":25,"_142":-5,"_27":158},{"_43":144,"_32":145,"_30":146,"_137":-5,"_41":42,"_40":147,"_139":25,"_38":148,"_13":63,"_33":34,"_35":149,"_24":25,"_142":-5,"_27":150},{"_43":134,"_32":135,"_30":136,"_137":-5,"_41":42,"_40":138,"_139":59,"_38":140,"_13":63,"_33":34,"_35":141,"_24":25,"_142":-5,"_27":143},"33f445d2-033b-485a-b3cd-fd181b5bce2f","test.ts","d6f6fbaa-ad5e-11f1-b313-1607ee4eb77e","parentId",3,"latest",["D",1789075827010],"import { buildQuote, sample } from './core.ts';\n\nconst assert = (condition: unknown, message: string) => { if (!condition) throw new Error(message); };\n\nconst result = buildQuote(sample.lines, sample.catalogue, sample.prices);\nassert(result.truth === 'SYNTHETIC_DEMO_NOT_CLIENT_DELIVERY', 'truth boundary');\nassert(result.results.length === 3, 'preserve all RFQ rows');\nassert(result.results[0].status === 'MATCHED', 'exact code+unit match');\nassert((result.results[0] as any).amountMinor === '3750', 'approved price arithmetic');\nassert(result.results[1].status === 'REVIEW' && (result.results[1] as any).reason === 'UNKNOWN_CODE', 'unknown code review');\nassert(result.results[2].status === 'REVIEW' && (result.results[2] as any).reason === 'UNIT_MISMATCH', 'unit mismatch review');\nassert(result.reviewRequired === true, 'review gate');\nassert(result.totalMinor === null, 'withhold total while exceptions exist');\n\nconst clean = buildQuote(\n [{ code: 'SW-01', quantity: 2, unit: 'EA' }],\n sample.catalogue,\n sample.prices\n);\nassert(clean.reviewRequired === false, 'clean quote no review');\nassert(clean.totalMinor === '2500', 'clean exact total');\n\nconsole.log(JSON.stringify({ status: 'PASS', checks: 10, result, clean }, null, 2));\n","label",[135],"d261d9d4-9ad3-48a4-a23e-20f07ddbe2ef","synthetic_pdf.ts","34278344-af6c-11f1-9fe8-1607ee4eb77e",6,["D",1789301469121],"import {PDFDocument,StandardFonts} from \"npm:pdf-lib@1.17.1\";\nimport {FORMAT,COLUMNS} from \"./file_pipeline.ts\";\nexport const DEMO_ROWS=[\"SW-01 | 3 | EA | Synthetic switch\",\"CB-99 | 2 | EA | Unknown synthetic item\",\"LN-10 | 4 | BOX | Synthetic unit mismatch\"];\nexport async function makePdf(rows:string[]=DEMO_ROWS,pages=1,withHeaders=true){\n const pdf=await PDFDocument.create(),font=await pdf.embedFont(StandardFonts.Helvetica);\n pdf.setTitle(\"Synthetic RFQ fixture — not a client document\");pdf.setAuthor(\"Alexander Romaskevich / RomaskevicH\");\n for(let p=0;p {\n const url = new URL(req.url);\n if (url.pathname === '/api/demo') {\n return new Response(JSON.stringify({\n name: 'IMPERIAL RFQ-to-Quote Synthetic Proof',\n truth: 'SYNTHETIC_DEMO_NOT_CLIENT_DELIVERY',\n tested: true,\n checks_passed: 10,\n scope: 'Exact catalogue and approved-price matching with explicit human-review exceptions',\n result: proof,\n exclusions: ['OCR/scanned PDFs','ERP integration','automatic email','dashboard','silent product substitution']\n }, null, 2), { headers: { 'content-type': 'application/json; charset=utf-8' } });\n }\n\n const html = `IMPERIAL RFQ-to-Quote Synthetic Proof

IMPERIAL RFQ-to-Quote Synthetic Proof

Truth boundary: synthetic evaluation demo — not a client delivery and not an electrical-parts production deployment.

Runtime verification: 10/10 checks PASS on Val Town.

What this proves

Exact normalized product-code and unit matching; prices sourced only from an approved versioned price list; unknown codes, unit mismatches and ambiguous/missing prices are routed to human review; a complete quotation total is withheld while exceptions remain.

Current demo result

${JSON.stringify(proof, null, 2)}

Paid-test boundary

A real paid test would add one agreed text-based PDF layout, extraction into the agreed line-item schema, catalogue/price lookup, Excel quotation draft, review sheet, workflow/source, test notes and one revision against written acceptance criteria.

Excluded unless separately scoped: OCR/scans, catalogue cleansing, ERP, automatic email, dashboards, tax/currency rules, additional layouts and production hosting.

Machine-readable demo evidence

`;\n return new Response(html, { headers: { 'content-type': 'text/html; charset=utf-8' } });\n}\n",[152],"baaf4f93-d5cb-4044-98ce-3558442b949e","file_pipeline_test.ts","cfad161c-af94-11f1-9634-1607ee4eb77e",7,["D",1789318909440],"import ExcelJS from \"npm:exceljs@4.4.0\";\nimport {sample} from \"./core.ts\";\nimport {processPdfQuote,readPdfRows,parseRows,quoteParsed,FORMAT,COLUMNS} from \"./file_pipeline.ts\";\nimport {makePdf} from \"./synthetic_pdf.ts\";\nconst checks:string[]=[];\nfunction check(name:string,ok:unknown){if(!ok)throw Error(\"FAIL:\"+name);checks.push(name);}\nasync function rejects(name:string,fn:()=>any){let rejected=false;try{await fn();}catch{rejected=true;}check(name,rejected);}\nconst pdf=await makePdf(),run=await processPdfQuote(pdf,sample.catalogue,sample.prices);\ncheck(\"actual_pdf_extracted\",run.evidence.pages===1&&run.quote.results.length===3);\ncheck(\"exact_price_arithmetic\",run.quote.results[0].amountMinor===\"3750\");\ncheck(\"unknown_code_review\",run.quote.results[1].reason===\"UNKNOWN_CODE\");\ncheck(\"unit_mismatch_review\",run.quote.results[2].reason===\"UNIT_MISMATCH\");\ncheck(\"review_blocks_total\",run.quote.reviewRequired&&run.quote.totalMinor===null);\ncheck(\"hashes_bound\",run.evidence.pdf_sha256.length===64&&run.evidence.xlsx_sha256.length===64);\nconst wb=new ExcelJS.Workbook();await wb.xlsx.load(run.xlsx);\ncheck(\"real_xlsx_readable\",wb.worksheets.length===3);\ncheck(\"all_rows_exported\",wb.getWorksheet(\"Quote Draft\")!.rowCount===4);\ncheck(\"review_sheet_two_exceptions\",wb.getWorksheet(\"Review\")!.rowCount===3);\ncheck(\"money_exact_text\",wb.getWorksheet(\"Quote Draft\")!.getCell(\"J2\").value===\"3750\");\ncheck(\"withheld_total_exported\",wb.getWorksheet(\"Evidence\")!.getCell(\"B6\").value===\"WITHHELD\");\nconst clean=await processPdfQuote(await makePdf([\"SW-01 | 2 | EA | Clean synthetic item\"]),sample.catalogue,sample.prices);\ncheck(\"clean_total_exact\",clean.quote.totalMinor===\"2500\"&&!clean.quote.reviewRequired);\nconst malformed=await processPdfQuote(await makePdf([\"SW-01 | 1.5 | EA | Fraction not in agreed format\",\"unparsed content\",\"SW-01 | 2 | EA | Good row\"]),sample.catalogue,sample.prices);\ncheck(\"unparsed_rows_retained\",malformed.quote.issues.length===2&&malformed.quote.results.length===1);\ncheck(\"unparsed_rows_block_total\",malformed.quote.totalMinor===null);\nconst duplicate=quoteParsed(parseRows([{page:1,line:1,raw:FORMAT},{page:1,line:2,raw:\"SW-01 | 1 | EA | item\"}]),[...sample.catalogue,sample.catalogue[0]],sample.prices);\ncheck(\"duplicate_catalogue_review\",duplicate.results[0].reason===\"AMBIGUOUS_CATALOGUE_CODE\");\nconst mixed=await processPdfQuote(await makePdf([\"SW-01 | 1 | EA | USD item\",\"LN-10 | 1 | EA | EUR item\"]),sample.catalogue,[sample.prices[0],{...sample.prices[1],currency:\"EUR\"}]);\ncheck(\"mixed_currency_review\",mixed.quote.reviewRequired&&mixed.quote.totalMinor===null&&mixed.quote.issues.some(x=>x.reason===\"MIXED_CURRENCIES_NO_CONVERSION\"));\nawait rejects(\"negative_price_rejected\",()=>processPdfQuote(pdf,sample.catalogue,[{...sample.prices[0],amountMinor:-1n}]));\nawait rejects(\"empty_price_version_rejected\",()=>processPdfQuote(pdf,sample.catalogue,[{...sample.prices[0],priceListVersion:\"\"}]));\nawait rejects(\"non_pdf_rejected\",()=>readPdfRows(new TextEncoder().encode(\"not a PDF\")));\nawait rejects(\"oversize_pdf_rejected\",()=>readPdfRows(new Uint8Array(2*1024*1024+1)));\nawait rejects(\"unsupported_layout_rejected\",()=>processPdfQuote(makePdf as any,sample.catalogue,sample.prices));\nawait rejects(\"unrecognized_document_header\",async()=>processPdfQuote(await makePdf([\"Different document\"],1,false),sample.catalogue,sample.prices));\nawait rejects(\"page_limit\",async()=>readPdfRows(await makePdf([],6)));\nconst blank=await processPdfQuote(await makePdf([]),sample.catalogue,sample.prices);\ncheck(\"empty_line_items_block_total\",blank.quote.reviewRequired&&blank.quote.totalMinor===null);\nconst formula=await processPdfQuote(await makePdf(['SW-01 | 1 | EA | =HYPERLINK(\"https://example.invalid\",\"x\")']),sample.catalogue,sample.prices);\nconst safeWb=new ExcelJS.Workbook();await safeWb.xlsx.load(formula.xlsx);\ncheck(\"formula_injection_remains_text\",typeof safeWb.getWorksheet(\"Quote Draft\")!.getCell(\"E2\").value===\"string\"&&safeWb.getWorksheet(\"Quote Draft\")!.getCell(\"E2\").formula===undefined);\ncheck(\"input_bytes_not_detached\",pdf.byteLength>0);\nconsole.log(JSON.stringify({status:\"PASS\",checks:checks.length,tests:checks,fixture:\"SYNTHETIC_NOT_CLIENT_DATA\",sample_evidence:run.evidence,output_bytes:run.xlsx.byteLength,client_delivery:false}));\n",[160],"3c36add0-77ef-474a-81e5-9d2d38b22e18",["D",1789318933419],[28],"9b56d96a-32a8-4c0a-8667-3d1e4444b8f5","core.ts","d334b7aa-ad5e-11f1-a787-1607ee4eb77e",2,["D",1789075820703],"export type RfqLine = { code: string; description?: string; quantity: number; unit: string };\nexport type CatalogueRow = { code: string; description: string; unit: string };\nexport type PriceRow = { code: string; unit: string; amountMinor: bigint; currency: string; priceListVersion: string };\n\nconst norm = (s: string) => s.trim().toUpperCase();\n\nexport function buildQuote(lines: RfqLine[], catalogue: CatalogueRow[], prices: PriceRow[]) {\n const results = lines.map((line, index) => {\n const code = norm(line.code);\n const unit = norm(line.unit);\n const cat = catalogue.filter(c => norm(c.code) === code);\n if (cat.length === 0) return { index, code, status: 'REVIEW', reason: 'UNKNOWN_CODE' };\n if (cat.length > 1) return { index, code, status: 'REVIEW', reason: 'AMBIGUOUS_CATALOGUE_CODE' };\n if (norm(cat[0].unit) !== unit) return { index, code, status: 'REVIEW', reason: 'UNIT_MISMATCH' };\n const price = prices.filter(p => norm(p.code) === code && norm(p.unit) === unit);\n if (price.length !== 1) return { index, code, status: 'REVIEW', reason: price.length === 0 ? 'MISSING_APPROVED_PRICE' : 'AMBIGUOUS_APPROVED_PRICE' };\n if (!Number.isInteger(line.quantity) || line.quantity <= 0) return { index, code, status: 'REVIEW', reason: 'INVALID_QUANTITY' };\n return {\n index, code, status: 'MATCHED', quantity: line.quantity, unit,\n amountMinor: (BigInt(line.quantity) * price[0].amountMinor).toString(),\n currency: price[0].currency,\n priceListVersion: price[0].priceListVersion\n };\n });\n const reviewRequired = results.some(r => r.status === 'REVIEW');\n const currencies = [...new Set(results.filter(r => r.status === 'MATCHED').map((r: any) => r.currency))];\n const totalMinor = reviewRequired || currencies.length !== 1 ? null : results.reduce((sum, r: any) => sum + BigInt(r.amountMinor ?? '0'), 0n).toString();\n return { truth: 'SYNTHETIC_DEMO_NOT_CLIENT_DELIVERY', results, reviewRequired, totalMinor, currency: currencies.length === 1 ? currencies[0] : null };\n}\n\nexport const sample = {\n lines: [\n { code: 'SW-01', description: 'Switch', quantity: 3, unit: 'EA' },\n { code: 'CB-99', description: 'Unknown breaker', quantity: 2, unit: 'EA' },\n { code: 'LN-10', description: 'Lamp', quantity: 4, unit: 'BOX' }\n ],\n catalogue: [\n { code: 'SW-01', description: 'Synthetic switch', unit: 'EA' },\n { code: 'LN-10', description: 'Synthetic lamp', unit: 'EA' }\n ],\n prices: [\n { code: 'SW-01', unit: 'EA', amountMinor: 1250n, currency: 'USD', priceListVersion: 'SYNTHETIC-2026-09' },\n { code: 'LN-10', unit: 'EA', amountMinor: 500n, currency: 'USD', priceListVersion: 'SYNTHETIC-2026-09' }\n ]\n};\n",[170],"pulls","branches","forks","envVars",{"_183":63,"_185":63},"connections",{"_183":63,"_184":63},"count","unfilledCount","emptyCount",{"_43":169,"_32":170,"_30":171,"_137":-5,"_41":42,"_40":172,"_139":59,"_38":208,"_13":63,"_33":34,"_35":174,"_24":25,"_142":-5,"_193":209,"_27":210},{"_43":166,"_32":28,"_30":31,"_137":-5,"_41":42,"_40":14,"_139":25,"_38":205,"_13":155,"_33":34,"_35":37,"_24":25,"_142":-5,"_193":206,"_27":207},{"_43":159,"_32":160,"_30":161,"_137":-5,"_41":42,"_40":162,"_139":25,"_38":202,"_13":63,"_33":34,"_35":164,"_24":25,"_142":-5,"_193":203,"_27":204},{"_43":151,"_32":152,"_30":57,"_137":-5,"_41":42,"_40":153,"_139":25,"_38":199,"_13":155,"_33":156,"_35":157,"_24":25,"_142":-5,"_193":200,"_27":201},{"_43":144,"_32":145,"_30":146,"_137":-5,"_41":42,"_40":147,"_139":25,"_38":196,"_13":63,"_33":34,"_35":149,"_24":25,"_142":-5,"_193":197,"_27":198},{"_43":134,"_32":135,"_30":136,"_137":-5,"_41":42,"_40":138,"_139":59,"_38":192,"_13":63,"_33":34,"_35":141,"_24":25,"_142":-5,"_193":194,"_27":195},["D",1789075827010],"children",[],[135],["D",1789301469121],[],[145],["D",1789075845950],[],[152],["D",1789318909440],[],[160],["D",1789318933419],[],[28],["D",1789075820703],[],[170],["D",1789075806931],{"_97":96,"_105":101},{"_97":96,"_98":99,"_100":101,"_18":55,"_102":103,"_104":25},{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"ctx",{"_79":-5,"_125":248,"_249":250,"_251":252,"_253":25,"_254":25,"_255":25,"_256":59,"_257":-5,"_258":-7,"_259":-7,"_260":63,"_261":25,"_262":25,"_263":-5,"_264":25,"_265":25,"_266":25,"_267":-5},"ENV",{"_219":220,"_221":222,"_223":87,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v8