[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_343":344,"_345":346},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_17":18,"_41":-7,"_153":-5,"_19":154,"_155":156,"_157":158,"_159":160,"_161":162,"_21":163,"_164":-5,"_165":-5,"_166":24,"_167":168,"_169":112,"_170":-5,"_171":-5,"_172":173},"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":26,"_27":28,"_29":24,"_30":-5},"handle","logan1","name","corvette","branchName","main","path","cron/digest.ts","project",{"_35":99,"_13":14,"_39":100,"_101":-5,"_102":24,"_103":104,"_105":104,"_106":107,"_108":-5,"_30":72,"_109":110,"_111":112,"_113":-5,"_114":-5,"_115":26,"_43":44,"_116":117,"_118":119,"_120":121,"_122":-5,"_123":124,"_125":124,"_126":127,"_128":127,"_129":127,"_130":124,"_131":124,"_56":132,"_133":134,"_135":136,"_137":24},"file",{"_66":67,"_13":68,"_69":70,"_71":24,"_98":-5},"isDirectory",false,"page",0,"history",[31,32,33,34],"hasNext","userId",{"_35":90,"_37":38,"_39":91,"_41":92,"_43":44,"_45":93,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":55,"_56":94,"_21":95,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":96},{"_35":83,"_37":38,"_39":84,"_41":85,"_43":44,"_45":75,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":55,"_56":86,"_21":87,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":88},{"_35":75,"_37":38,"_39":76,"_41":77,"_43":44,"_45":78,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":55,"_56":79,"_21":80,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":81},{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":55,"_56":57,"_21":58,"_59":-5,"_60":-5,"_61":-5,"_62":-5,"_63":64},"id","db614163-92f2-469e-931f-ff4581fb960d","branchId","86e98f95-71bb-401c-ac30-44ee51ed36fc","createdAt",["D",1789312780959],"version",11,"orgId","01a09786-a61b-74b5-8910-af3116d3de5c","parentId","bbf7ea28-7d48-47e6-91e5-ae4c22e03068","incomingCommitId","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","mcp","clientLabel","Claude Code (plugin:valtown:valtown)","user",{"_35":72,"_43":44,"_11":12,"_73":74},{"_66":67,"_13":68,"_69":70,"_71":24},"pull","merge","revert","multiple","commits",[65],{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":55,"_56":57,"_21":58,"_59":-5,"_60":-5,"_61":-5},"fileId","8a8cd03a-af86-11f1-b110-1607ee4eb77e","digest.ts","fileType","interval","deleted","87445237-7d14-45c7-b3a2-72e031f10ec1","avatar","https://lh3.googleusercontent.com/a/ACg8ocIFxddfJftSiTFZN49YShT3nY7q8GOQ7dXYM2vJ6XkajnQMGA=s96-c","bae04aca-9165-4e46-bf7a-e26cd84c9a4a",["D",1789345080188],60,"d5722ea5-cf0e-4ed9-945e-fdcbfb85b6e6",{"_35":72,"_43":44,"_11":12,"_73":74},{"_66":67,"_13":68,"_69":70,"_71":24},[82],{"_35":75,"_37":38,"_39":76,"_41":77,"_43":44,"_45":78,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":55,"_56":79,"_21":80,"_59":-5,"_60":-5,"_61":-5},"f97592a2-8f85-4dd9-98df-c1ea163bd08f",["D",1789345266243],61,{"_35":72,"_43":44,"_11":12,"_73":74},{"_66":67,"_13":68,"_69":70,"_71":24},[89],{"_35":83,"_37":38,"_39":84,"_41":85,"_43":44,"_45":75,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":55,"_56":86,"_21":87,"_59":-5,"_60":-5,"_61":-5},"b486b401-d4a3-47a5-82f4-a132425fadad",["D",1789472824547],77,"30b5dfbe-c61e-4a81-a930-fa0992ef3bf3",{"_35":72,"_43":44,"_11":12,"_73":74},{"_66":67,"_13":68,"_69":70,"_71":24},[97],{"_35":90,"_37":38,"_39":91,"_41":92,"_43":44,"_45":93,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_54":55,"_56":94,"_21":95,"_59":-5,"_60":-5,"_61":-5},"deletedAtVersion","00cc23ab-c212-43f5-a7c5-1ba797ecaa18",["D",1789312547277],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","C4/C5 Corvette search pipeline (CL, forums, auctions, comps)","imageUrl","pinnedFileId","2b16e0f0-af8b-11f1-8152-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","tursoName","00cc23abc21243f5a7c51ba797ecaa18","tursoHostname","00cc23abc21243f5a7c51ba797ecaa18-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789486866837],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_11":12,"_152":74},"org",{"_11":12,"_147":148,"_73":74,"_30":72,"_149":150,"_151":24},"branch",{"_41":138,"_13":16,"_35":38,"_139":99,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":14,"_146":12},"isOwned",79,"projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Logan","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":99,"_13":14,"_39":338,"_101":-5,"_102":24,"_103":104,"_105":104,"_106":107,"_108":-5,"_30":72,"_109":110,"_111":112,"_113":-5,"_114":-5,"_115":26,"_43":44,"_116":117,"_118":119,"_120":339,"_122":-5,"_123":124,"_125":124,"_126":127,"_128":127,"_129":127,"_130":124,"_131":124,"_56":340,"_133":341,"_135":342,"_137":24},"tree",[197,202,207,209,213],"files",[197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213],"counts",{"_185":26,"_186":187,"_188":26,"_189":190,"_191":192},"contents",[],{"_35":174,"_13":68,"_66":67,"_45":175,"_37":38,"_176":92,"_177":112,"_39":178,"_41":179,"_69":70,"_180":181,"_71":24,"_182":-5,"_17":183},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},"9a28d761-cfb4-4b16-87af-db351ad947bf","1b0a73f2-af86-11f1-b58b-1607ee4eb77e","branchVersion","latest",["D",1789472824547],3,"content","// Daily digest email (cron). Schedule as `0 12,13 * * *` (UTC) - the handler only sends when it is 8 AM in\r\n// America/New_York, so EDT/EST both land at 8:00 ET. Pass force=true (admin ?job=digest) to send regardless.\r\n// Sections: NEW 24H, HOT (score >= 9), NEGOTIATION TARGETS (STALE/MOTIVATED with price trail),\r\n// AUCTION COMPS THIS WEEK, SOURCES health line, PIPELINE 24h.\r\nimport { email } from \"https://esm.town/v/std/email\";\r\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\r\nimport { ensureSchema, logPoll, rowToListing, allIn, fmtMiles, fmtUsd, PUSH_THRESHOLD } from \"../lib/core.ts\";\r\nimport { etHour, fmtTrail } from \"../lib/enrich.ts\";\r\n\r\nconst fmt = (r: any) => {\r\n const l = rowToListing(r);\r\n const car = `${l.year ?? \"?\"} ${l.gen !== \"unknown\" ? l.gen : \"\"}${l.trim ? \" \" + l.trim : \"\"} ${l.trans} ${l.body !== \"unknown\" ? l.body : \"\"}`.replace(/\\s+/g, \" \").trim();\r\n const flags = l.flags.filter((f) => !/^(STRETCH|FAR)$/.test(f)).join(\", \");\r\n return `[${String(l.score).padStart(2)}] ${fmtUsd(l.price).padStart(8)} (all-in ${fmtUsd(l.allin)}) ${fmtMiles(l.miles).padStart(5)} mi ${car} ${l.seller} ${l.drive != null ? l.drive + \" drive mi\" : \"dist ?\"}${l.band !== \"core\" ? \" \" + l.band.toUpperCase() : \"\"} ${l.title}${l.vin ? \" \" + l.vin : \" NO VIN\"}${flags ? \" [\" + flags + \"]\" : \"\"}\\n ${l.loc ? l.loc + \" \" : \"\"}${l.url}`;\r\n};\r\n\r\nexport async function sendDigest(force = false) {\r\n await ensureSchema();\r\n if (!force && etHour(new Date()) !== 8) { console.log(\"digest: not 8 AM ET, skipping\"); return { skipped: true }; }\r\n const since = new Date(Date.now() - 24 * 3600 * 1000).toISOString().slice(0, 10);\r\n const newRows = await sqlite.execute({ sql: `select * from listings where first_seen >= ? order by status='dead', score desc, price asc`, args: [since] });\r\n const hot = await sqlite.execute(`select * from listings where score >= ${PUSH_THRESHOLD} and status <> 'dead' and last_seen >= date('now','-14 day') order by score desc, first_seen desc limit 20`);\r\n const nego = await sqlite.execute(`select *, cast(julianday('now') - julianday(coalesce(posted_at, first_seen)) as integer) age_days from listings\r\n where score >= 6 and status <> 'dead' and last_seen >= date('now','-14 day') and (motivated = 1 or drops > 0 or reposts > 0 or julianday('now') - julianday(coalesce(posted_at, first_seen)) >= 25)\r\n order by motivated desc, drops desc, reposts desc, age_days desc limit 15`);\r\n const trailFor = async (rowid: number) => { const t = await sqlite.execute({ sql: `select price from price_history where rowid_pk=? order by id`, args: [rowid] }); return fmtTrail((t.rows as any[]).map((x) => x.price == null ? null : Number(x.price))); };\r\n const comps = await sqlite.execute(`select * from comps where sold_price is not null and sold_date between date('now','-7 day') and date('now') order by sold_date desc, year desc limit 25`); // sold this week only (Mecum also lists future lots)\r\n const upcoming = await sqlite.execute(`select count(*) n, min(sold_date) first from comps where sold_price is null and sold_date > date('now') and year between 1992 and 2004`);\r\n const compStats = await sqlite.execute(`select gen, trans, count(*) n, round(avg(sold_price)) avg, min(sold_price) lo, max(sold_price) hi from comps where sold_date >= date('now','-180 day') and sold_price is not null group by gen, trans order by gen, trans`);\r\n // expansion-plan fix 19: from Nov 1 anchor on the Oct-Dec cohort (base C4 automatics hammer 20-35% lower Oct-Dec than January)\r\n const cohort = await sqlite.execute(`select gen, trans, count(*) n, round(avg(sold_price)) avg from comps where sold_price is not null and cast(strftime('%m', sold_date) as integer) in (10,11,12) and year between 1992 and 2004 group by gen, trans order by gen, trans`);\r\n const season = await sqlite.execute(`select week, active, in_band, p25_c4_auto, med_c4_auto, p25_c5_auto, med_c5_auto, drops_share, firm_share, storage_share, cl300, cl350 from season_log order by week desc limit 5`);\r\n const health = await sqlite.execute(`select source, fail_count, last_ok, last_run from source_state order by fail_count desc, source`);\r\n const inProgress = await sqlite.execute(`select * from listings where status in ('contacted','ppi','offer') order by score desc`);\r\n const gone = await sqlite.execute(`select * from listings where (missed >= 3 or gone_at is not null) and status not in ('dead','new') order by gone_at desc, missed desc limit 10`);\r\n const goneNew = await sqlite.execute(`select id, year, gen, trans, price, source, gone_at, flags, url from listings where gone_at >= date('now','-1 day') and status = 'dead' order by score desc limit 15`);\r\n const counts = await sqlite.execute(`select count(*) total, sum(first_seen >= date('now','-1 day')) new24, sum(score>=${PUSH_THRESHOLD} and status<>'dead') hot, sum(status='dead') dead, sum(vin is not null) with_vin, sum(pushed) pushed from listings`);\r\n const polls = await sqlite.execute(`select job, count(*) n, sum(ok) ok, sum(inserted) ins, sum(pushed) pushed, max(ts) last from poll_log where ts >= datetime('now','-1 day') group by job order by job`);\r\n const anomalies = await sqlite.execute(`select * from listings where anomaly = 1 and status <> 'dead' and last_seen >= date('now','-14 day') order by score desc limit 10`);\r\n\r\n const c: any = counts.rows[0] || {};\r\n const lines: string[] = [];\r\n lines.push(`CORVETTE DIGEST - ${new Date().toLocaleDateString(\"en-US\", { timeZone: \"America/New_York\", weekday: \"short\", month: \"short\", day: \"numeric\" })}`);\r\n const hs = health.rows as any[]; const failing = hs.filter((r) => Number(r.fail_count) >= 1); const stuck = hs.filter((r) => Number(r.fail_count) >= 3);\r\n lines.push(`Tracked ${c.total ?? 0} | new 24h ${c.new24 ?? 0} | score>=${PUSH_THRESHOLD} ${c.hot ?? 0} | with VIN ${c.with_vin ?? 0} | dead ${c.dead ?? 0} | pushed ${c.pushed ?? 0}`);\r\n lines.push(`Sources: ${hs.length - failing.length} ok / ${failing.length} failing${stuck.length ? ` - 3+ consecutive failures: ${stuck.map((r) => r.source).join(\", \")}` : \"\"}`);\r\n lines.push(\"\");\r\n lines.push(`NEW IN LAST 24H (${newRows.rows.length})`);\r\n lines.push(newRows.rows.length ? (newRows.rows as any[]).map((r) => (r.status === \"dead\" ? \" DEAD \" : \"\") + fmt(r)).join(\"\\n\") : \" none\");\r\n lines.push(\"\");\r\n lines.push(`HOT - ACTIVE SCORE >= ${PUSH_THRESHOLD} (${hot.rows.length})`);\r\n lines.push(hot.rows.length ? (hot.rows as any[]).map(fmt).join(\"\\n\") : \" none\");\r\n if (inProgress.rows.length) { lines.push(\"\"); lines.push(\"IN PROGRESS\"); lines.push((inProgress.rows as any[]).map((r) => ` ${r.status.toUpperCase()} ${fmt(r)}`).join(\"\\n\")); }\r\n if (gone.rows.length) { lines.push(\"\"); lines.push(\"IN-PROGRESS LISTINGS NO LONGER APPEARING (follow up: 'if it falls through')\"); lines.push((gone.rows as any[]).map((r) => ` ${r.id} - ${r.status}, ${r.gone_at ? \"gone \" + r.gone_at + \" (\" + (String(r.flags || \"\").split(\"|\").find((f: string) => f.startsWith(\"GONE\")) || \"GONE\") + \")\" : \"missed \" + r.missed + \" polls\"} - ${r.url}`).join(\"\\n\")); }\r\n if (goneNew.rows.length) { lines.push(\"\"); lines.push(`GONE IN LAST 24H (${goneNew.rows.length}) - removed from the tracker`); lines.push((goneNew.rows as any[]).map((r) => ` ${r.year ?? \"?\"} ${r.gen} ${r.trans} ${r.price != null ? \"$\" + Number(r.price).toLocaleString(\"en-US\") : \"$?\"} ${r.source} - ${(String(r.flags || \"\").split(\"|\").find((f: string) => f.startsWith(\"GONE\")) || \"gone\").toLowerCase()}`).join(\"\\n\")); }\r\n if (nego.rows.length) {\r\n lines.push(\"\"); lines.push(\"NEGOTIATION TARGETS - MOTIVATED first, then price drops, then 25+ days (anchor on comps; offer curve minus 8-12%)\");\r\n const out: string[] = [];\r\n for (const r of nego.rows as any[]) out.push(` [${String(r.score).padStart(2)}] ${fmtUsd(r.price)} ${r.age_days}d${r.posted_at ? \"\" : \" (since first seen)\"}${r.motivated ? \" MOTIVATED\" : \"\"}${Number(r.reposts) > 0 ? \" REPOST x\" + r.reposts : \"\"}${Number(r.drops) > 0 ? \" \" + await trailFor(Number(r.rowid_pk)) : \"\"} ${r.year} ${r.gen} ${r.trans} ${fmtMiles(r.miles)} mi ${r.seller}\\n ${r.url}`);\r\n lines.push(out.join(\"\\n\"));\r\n }\r\n if (anomalies.rows.length) { lines.push(\"\"); lines.push(\"PRICE ANOMALIES (< 75% of the rolling P25 for the year band x trans - scam gate before contact)\"); lines.push((anomalies.rows as any[]).map(fmt).join(\"\\n\")); }\r\n lines.push(\"\"); lines.push(`AUCTION COMPS THIS WEEK (${comps.rows.length})`);\r\n lines.push(comps.rows.length ? (comps.rows as any[]).map((k) => ` ${k.sold_date || \"?\"} ${fmtUsd(k.sold_price).padStart(8)} ${k.year} ${k.gen || \"\"} ${k.trans || \"\"} ${fmtMiles(k.miles)} mi ${String(k.title || \"\").slice(0, 60)} ${k.source}\\n ${k.url}`).join(\"\\n\") : \" none yet\");\r\n if (compStats.rows.length) lines.push(\" 180-day comps: \" + (compStats.rows as any[]).map((s) => `${s.gen} ${s.trans} n=${s.n} avg ${fmtUsd(s.avg)} (${fmtUsd(s.lo)}-${fmtUsd(s.hi)})`).join(\" | \"));\r\n { const u: any = upcoming.rows[0] || {}; if (Number(u.n)) lines.push(` Upcoming Mecum 1992-2004 lots: ${u.n} (first ${u.first}) - comps only, never bids`); }\r\n if (cohort.rows.length) lines.push(\" Oct-Dec cohort (the trough; anchor here from Nov 1): \" + (cohort.rows as any[]).map((s) => `${s.gen} ${s.trans} n=${s.n} avg ${fmtUsd(s.avg)}`).join(\" | \"));\r\n if (season.rows.length) { const w: any = season.rows[0]; const prev: any = season.rows[Math.min(4, season.rows.length - 1)]; lines.push(` Season log ${w.week}: active ${w.active} (in band ${w.in_band}) | C4 auto P25 ${fmtUsd(w.p25_c4_auto)} med ${fmtUsd(w.med_c4_auto)} | C5 auto P25 ${fmtUsd(w.p25_c5_auto)} med ${fmtUsd(w.med_c5_auto)} | drops ${w.drops_share} firm ${w.firm_share} storage ${w.storage_share} | CL density 300/350 mi ${w.cl300}/${w.cl350}${prev && prev.week !== w.week ? ` (vs ${prev.week}: C4 auto P25 ${fmtUsd(prev.p25_c4_auto)}, CL350 ${prev.cl350})` : \"\"}`); }\r\n lines.push(\"\"); lines.push(\"PIPELINE (24h)\");\r\n lines.push(polls.rows.length ? (polls.rows as any[]).map((p) => ` ${p.job}: ${p.ok}/${p.n} ok, ${p.ins} inserted, ${p.pushed} pushed, last ${String(p.last).slice(0, 16)}Z`).join(\"\\n\") : \" no polls logged - check cron schedules\");\r\n lines.push(\"\"); lines.push(\"Rules: PPI by an independent shop before any money. Title in the seller's name, VIN plate photo, no deposits to hold, no wire/Zelle. Notary at transfer.\");\r\n\r\n const text = lines.join(\"\\n\");\r\n const subject = `Corvette digest: ${newRows.rows.length} new, ${hot.rows.length} hot, ${comps.rows.length} comps`;\r\n await email({ subject, text });\r\n await logPoll(\"digest\", true, { fetched: newRows.rows.length }, subject);\r\n console.log(\"digest sent:\", subject);\r\n return { sent: true, subject, text };\r\n}\r\n\r\nexport default async function () { return await sendDigest(false); }\r\n","label",[184,68],"cron","pulls","branches",1,"forks","envVars",{"_193":195,"_196":26},"connections",{"_193":26,"_194":26},"count","unfilledCount",5,"emptyCount",{"_35":334,"_13":310,"_66":303,"_45":-5,"_37":38,"_176":179,"_177":112,"_39":335,"_41":26,"_69":253,"_180":-5,"_71":24,"_182":-5,"_219":336,"_17":337},{"_35":326,"_13":327,"_66":328,"_45":303,"_37":38,"_176":329,"_177":112,"_39":330,"_41":239,"_69":306,"_180":331,"_71":24,"_182":-5,"_219":332,"_17":333},{"_35":318,"_13":319,"_66":320,"_45":303,"_37":38,"_176":321,"_177":112,"_39":322,"_41":239,"_69":306,"_180":323,"_71":24,"_182":-5,"_219":324,"_17":325},{"_35":311,"_13":312,"_66":110,"_45":303,"_37":38,"_176":313,"_177":112,"_39":314,"_41":26,"_69":306,"_180":315,"_71":24,"_182":-5,"_219":316,"_17":317},{"_35":300,"_13":301,"_66":302,"_45":303,"_37":38,"_176":304,"_177":112,"_39":305,"_41":179,"_69":306,"_180":307,"_71":24,"_182":-5,"_219":308,"_17":309},{"_35":296,"_13":184,"_66":175,"_45":-5,"_37":38,"_176":275,"_177":112,"_39":297,"_41":26,"_69":253,"_180":-5,"_71":24,"_182":-5,"_219":298,"_17":299},{"_35":288,"_13":289,"_66":290,"_45":175,"_37":38,"_176":291,"_177":112,"_39":292,"_41":195,"_69":70,"_180":293,"_71":24,"_182":-5,"_219":294,"_17":295},{"_35":174,"_13":68,"_66":67,"_45":175,"_37":38,"_176":92,"_177":112,"_39":285,"_41":179,"_69":70,"_180":181,"_71":24,"_182":-5,"_219":286,"_17":287},{"_35":279,"_13":235,"_66":280,"_45":175,"_37":38,"_176":138,"_177":112,"_39":281,"_41":275,"_69":70,"_180":282,"_71":24,"_182":-5,"_219":283,"_17":284},{"_35":271,"_13":223,"_66":272,"_45":175,"_37":38,"_176":273,"_177":112,"_39":274,"_41":275,"_69":70,"_180":276,"_71":24,"_182":-5,"_219":277,"_17":278},{"_35":266,"_13":262,"_66":259,"_45":-5,"_37":38,"_176":267,"_177":112,"_39":268,"_41":26,"_69":253,"_180":-5,"_71":24,"_182":-5,"_219":269,"_17":270},{"_35":256,"_13":257,"_66":258,"_45":259,"_37":38,"_176":260,"_177":112,"_39":261,"_41":26,"_69":262,"_180":263,"_71":24,"_182":-5,"_219":264,"_17":265},{"_35":251,"_13":233,"_66":225,"_45":-5,"_37":38,"_176":239,"_177":112,"_39":252,"_41":26,"_69":253,"_180":-5,"_71":24,"_182":-5,"_219":254,"_17":255},{"_35":243,"_13":244,"_66":245,"_45":225,"_37":38,"_176":246,"_177":112,"_39":247,"_41":195,"_69":229,"_180":248,"_71":24,"_182":-5,"_219":249,"_17":250},{"_35":234,"_13":235,"_66":236,"_45":225,"_37":38,"_176":237,"_177":112,"_39":238,"_41":239,"_69":229,"_180":240,"_71":24,"_182":-5,"_219":241,"_17":242},{"_35":222,"_13":223,"_66":224,"_45":225,"_37":38,"_176":226,"_177":112,"_39":227,"_41":228,"_69":229,"_180":230,"_71":24,"_182":-5,"_219":231,"_17":232},{"_35":214,"_13":215,"_66":216,"_45":-5,"_37":38,"_176":187,"_177":112,"_39":217,"_41":26,"_69":21,"_180":218,"_71":24,"_182":-5,"_219":220,"_17":221},"00ad9da4-0577-4814-8519-02511a2d4430","README.md","ff70c39e-af85-11f1-9411-1607ee4eb77e",["D",1789312547547],"# corvette\n\nC4 (1994-96) / C5 (1997-2004) Corvette search pipeline for 16105. Forked from logan1/housing. See lib/core.ts.\n","children",[],[215],"6ee78f10-cbd9-4ac8-b0e0-b14c1c7f3465","sources.ts","30edcbe2-af86-11f1-9d05-1607ee4eb77e","16dfa00e-af86-11f1-9559-1607ee4eb77e",68,["D",1789422556949],15,"script","// Multi-source registry + one parser per platform. Pure functions (text -> hits) so they are unit-testable against\n// scripts/fixtures/*. The cron (cron/sources.ts) does the fetching, rotation, dedupe and upsert. Adding a source =\n// one REGISTRY entry (+ a parser if the platform is new). Per-source gotchas live in valtown/SOURCES.md; verified\n// evidence for every entry is in ../source-inventory.md / .json.\nimport { decodeEntities, stripTags, inferYear, inferTrans, inferBody, inferTitle, inferMiles, inferPrice, inferTrim, findVin, parsePrice, parseMiles, genFor, YEAR_MIN, YEAR_MAX, type Trans, type Body, type Title, type Seller } from \"./core.ts\";\n\nexport type Kind = \"listing\" | \"comp\";\nexport interface Hit {\n extId: string; url: string; title: string; text: string;\n year?: number | null; price?: number | null; miles?: number | null; vin?: string | null;\n trans?: Trans; body?: Body; titleStatus?: Title; seller?: Seller; loc?: string; lat?: number | null; lon?: number | null;\n posted?: string | number | null; auctionDate?: string | null; note?: string; dist?: number | null; // dist = source-reported distance when no coordinates\n soldPrice?: number | null; soldDate?: string | null; // comps\n}\nexport interface ParseResult { hits: Hit[]; more?: boolean }\nexport type Parser = (text: string, ctx: { url: string }) => ParseResult;\nexport interface Source {\n key: string; parser: keyof typeof PARSERS; urls: string[]; every: number; seller: Seller; kind?: Kind;\n push?: boolean; pushMin?: number; enabled?: boolean; headers?: Record; accept?: \"html\" | \"json\" | \"xml\";\n pageUrl?: (base: string, n: number) => string; maxPages?: number; spacingMs?: number; group?: string; full?: boolean; // full = complete inventory (missed logic)\n method?: \"GET\" | \"POST\"; body?: (url: string) => string; // POST APIs (Mecum Algolia)\n}\n\nconst clean = (s: string) => decodeEntities(s).replace(/\\s+/g, \" \").trim();\nconst pipeText = (html: string) => decodeEntities(html.replace(//g, \"\").replace(/|/gi, \"\").replace(/<[^>]+>/g, \" | \")).replace(/\\s+/g, \" \").replace(/(\\s*\\|\\s*)+/g, \" | \").trim();\nexport const CORVETTE_RE = /corvette|\\bvette\\b/i;\nconst yearOk = (y: number | null | undefined) => y != null && y >= YEAR_MIN && y <= YEAR_MAX;\n// fill the structured fields a listing hit lacks from its text (parsers pass what the page gives, this does the rest)\nexport function enrichHit(h: Hit): Hit {\n const t = `${h.title} \\n ${h.text}`;\n return {\n ...h, year: h.year ?? inferYear(t), price: h.price ?? inferPrice(t), miles: h.miles ?? inferMiles(t), vin: h.vin ?? findVin(t),\n trans: h.trans ?? inferTrans(t), body: h.body ?? inferBody(t), titleStatus: h.titleStatus ?? inferTitle(t),\n };\n}\n\n// ---------- RSS / Atom (vBulletin external.php?type=RSS2&forumids=N, XenForo index.rss, Reddit new.rss, Hemmings) ----------\nexport const rss: Parser = (xml, ctx) => {\n const hits: Hit[] = [];\n const items = xml.includes(\"\") || xml.includes(\"]/).slice(1) : xml.split(\"\").slice(1);\n for (const it of items) {\n const g = (re: RegExp) => (it.match(re) || [])[1];\n const title = clean(stripTags((g(/]*>([\\s\\S]*?)<\\/title>/) || \"\").replace(/^$/g, \"\")));\n const link = g(/]*href=\"([^\"]+)\"/) || clean(g(/([\\s\\S]*?)<\\/link>/) || \"\");\n const id = clean(g(/([\\s\\S]*?)<\\/id>/) || g(/]*>([\\s\\S]*?)<\\/guid>/) || link);\n const body = stripTags((g(/([\\s\\S]*?)<\\/content:encoded>/) || g(/]*>([\\s\\S]*?)<\\/content>/) || g(/([\\s\\S]*?)<\\/description>/) || \"\").replace(//g, \"\"));\n const date = g(/([\\s\\S]*?)<\\/pubDate>/) || g(/([\\s\\S]*?)<\\/published>/) || g(/([\\s\\S]*?)<\\/updated>/) || g(/([\\s\\S]*?)<\\/dc:date>/) || \"\";\n if (!link) continue;\n if (date && Number.isFinite(Date.parse(date)) && Date.now() - Date.parse(date) > 90 * 86400000) continue; // XenForo index.rss includes years-old stickies/archived threads\n const text = `${title} \\n ${body}`;\n if (!CORVETTE_RE.test(text) && !/\\bc[45]\\b/i.test(title)) continue;\n if (/reddit\\.com/.test(ctx.url) && !/\\bfor sale\\b|\\bfs\\b|\\bselling\\b|\\bwts\\b|\\$\\s?\\d/i.test(text)) continue; // r/Corvette is mostly discussion; keep only sale posts\n if (/\\bwtb\\b|\\bwanted\\b|\\biso\\b|looking for|\\bparts?\\b.*for sale|\\bwheels?\\b|\\btires?\\b|\\bseats?\\b|\\bhood\\b|\\bexhaust\\b/i.test(title) && !/\\b(19\\d\\d|200\\d)\\b[^|]*\\b(corvette|vette)\\b/i.test(title)) continue;\n const h = enrichHit({ extId: id, url: link, title, text: text.slice(0, 5000), posted: date || null, note: `${ctx.url.replace(/^https?:\\/\\/(www\\.)?/, \"\").split(\"/\")[0]}: ${title.slice(0, 80)}` });\n if (!yearOk(h.year)) continue;\n hits.push(h);\n }\n return { hits };\n};\n\n// ---------- vBulletin forum thread list (CorvetteForum) - fallback when the RSS is blocked ----------\nexport const vbulletin: Parser = (html, ctx) => {\n const hits: Hit[] = [];\n for (const m of html.matchAll(/id=\"td_threadtitle_(\\d+)\"[^>]*title=\"([^\"]*)\"[\\s\\S]*?]*>([\\s\\S]*?)<\\/a>/g)) {\n const [, id, preview, url, t] = m;\n const title = clean(stripTags(t)); const text = `${title} \\n ${clean(preview)}`;\n if (/sticky/i.test(html.slice(Math.max(0, m.index! - 400), m.index!)) && /how to|rules|read (this|first)/i.test(title)) continue;\n if (!CORVETTE_RE.test(text) && !/\\bc[45]\\b/i.test(title)) continue;\n if (/\\bwtb\\b|\\bwanted\\b|\\biso\\b|\\bsold\\b/i.test(title)) continue;\n const h = enrichHit({ extId: id, url, title, text, note: `${ctx.url.replace(/^https?:\\/\\/(www\\.)?/, \"\").split(\"/\")[0]}: ${title.slice(0, 80)}` });\n if (!yearOk(h.year)) continue;\n hits.push(h);\n }\n return { hits };\n};\n\n// ---------- Bring a Trailer model pages: `var auctionsCompletedInitialData = {...}` (24 most recent completed) -> comps ----------\nexport const bat: Parser = (html, ctx) => {\n const hits: Hit[] = [];\n const i = html.indexOf(\"var auctionsCompletedInitialData = \"); if (i < 0) return { hits };\n const j = html.indexOf(\"/* ]]> */\", i); const raw = html.slice(i + \"var auctionsCompletedInitialData = \".length, j > 0 ? j : undefined).trim().replace(/;\\s*$/, \"\");\n let d: any; try { d = JSON.parse(raw); } catch { return { hits }; }\n for (const it of d.items || []) {\n const sold = /Sold for/i.test(String(it.sold_text || \"\"));\n const title = clean(String(it.title || \"\")); const excerpt = clean(stripTags(String(it.excerpt || \"\")));\n const year = inferYear(title); if (!yearOk(year)) continue;\n const miles = (title.match(/\\b(\\d{1,3})k-Mile/i) || [])[1] ? Number((title.match(/\\b(\\d{1,3})k-Mile/i) || [])[1]) * 1000 : inferMiles(`${title} ${excerpt}`);\n const soldDate = it.timestamp_end ? new Date(Number(it.timestamp_end) * 1000).toISOString().slice(0, 10) : null;\n hits.push({ extId: String(it.id), url: String(it.url), title, text: `${title} \\n ${excerpt}`, year, miles, price: null,\n trans: /6-speed|six-speed|manual/i.test(`${title} ${excerpt}`) ? \"manual\" : /automatic|four-speed auto|4l60/i.test(`${title} ${excerpt}`) ? \"auto\" : \"unknown\",\n body: inferBody(title), soldPrice: sold ? Number(it.current_bid) || null : null, soldDate, note: sold ? String(it.sold_text).replace(/<[^>]+>/g, \"\").trim() : `reserve not met - bid to $${it.current_bid}` });\n }\n return { hits };\n};\n\n// ---------- Cars & Bids past auctions (server-rendered cards or __NEXT_DATA__) -> comps ----------\nexport const carsandbids: Parser = (html, ctx) => {\n const hits: Hit[] = [];\n const nd = html.match(/\r\n\r\n\r\n`;\r\n\r\nexport default async function (req: Request): Promise {\r\n if (req.method !== \"GET\") return json({ error: \"GET only\" }, 405);\r\n if (!checkToken(req)) return new Response(\"unauthorized: open the tracker link that includes ?token=\", { status: 401 });\r\n return new Response(HTML, { headers: { \"content-type\": \"text/html; charset=utf-8\", \"cache-control\": \"no-store\", \"x-robots-tag\": \"noindex\" } });\r\n}\r\n",[],[310,301],"api","cd618113-b94e-4d68-bdbc-3d77cca4c359","feed.ts",13,["D",1789314768331],"// corvette-feed: JSON feed of tracked listings (GET). The tracker page pulls this on open.\n// Token via X-Corvette-Token header or ?token=. Returns a bare JSON array of\n// { id, vin, year, gen, model, trim, trans, body, miles, price, allin, title, seller, loc, dist, stretch, url, src, note, fs, lv, status, missed, score, flags }.\n//\n// ?days=N window on last_seen (default 60)\n// ?v=2 adds price_trail, age_days, posted_at, drops, motivated, anomaly, lat, lon, gone_at, auction_date, decode, decode_mismatch, pushed\n// ?alive=1 exclude dead rows (default includes them - they carry price context and show greyed in the tracker)\n// ?stats=1 stats object instead of the array\n// ?comps=1 the comps table (auction results) instead of listings\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { ensureSchema, activeListings, checkToken, json, CORS, PUSH_THRESHOLD } from \"../lib/core.ts\";\n\nexport default async function (req: Request): Promise {\n if (req.method === \"OPTIONS\") return new Response(null, { status: 204, headers: CORS });\n if (req.method !== \"GET\") return json({ error: \"GET only\" }, 405);\n if (!checkToken(req)) return json({ error: \"unauthorized\" }, 401);\n await ensureSchema();\n const url = new URL(req.url);\n if (url.searchParams.get(\"stats\")) {\n const bySrc = await sqlite.execute(`select source, count(*) n, sum(status='dead') dead, max(last_seen) last from listings group by source`);\n const byGen = await sqlite.execute(`select gen, trans, count(*) n, round(avg(price)) avg_price, min(price) min_price from listings where status<>'dead' group by gen, trans`);\n const recent = await sqlite.execute(`select ts, job, ok, fetched, inserted, updated, pushed, substr(detail,1,300) detail from poll_log order by id desc limit 15`);\n const total = await sqlite.execute(`select count(*) n, sum(score>=${PUSH_THRESHOLD}) hot, sum(pushed) pushed, sum(status='dead') dead, sum(vin is not null) with_vin from listings`);\n const comps = await sqlite.execute(`select source, count(*) n, min(sold_date) oldest, max(sold_date) newest from comps group by source`);\n return json({ total: total.rows[0], bySource: bySrc.rows, byGenTrans: byGen.rows, comps: comps.rows, recentPolls: recent.rows });\n }\n if (url.searchParams.get(\"comps\")) {\n const r = await sqlite.execute(`select source, external_id, year, gen, trans, body, miles, sold_price, sold_date, url, title, vin from comps order by sold_date desc limit 500`);\n return json(r.rows, 200, { \"cache-control\": \"no-store\" });\n }\n const days = Math.min(365, Math.max(1, Number(url.searchParams.get(\"days\") || 60)));\n const list = await activeListings(days, Number(url.searchParams.get(\"v\") || 1), !url.searchParams.get(\"alive\"));\n return json(list, 200, { \"cache-control\": \"no-store\" });\n}\n",[],[310,312],"33dae6bd-7997-40cb-81a3-ce8f73eb5f97","admin.ts","411cebc4-af8b-11f1-871a-1607ee4eb77e",76,["D",1789472822843],"// corvette-admin: token-checked maintenance endpoint for validation and manual runs.\n// GET ?job=craigslist | sources | enrich | digest run a job now (digest sends immediately)\n// ?job=sources&only= ?job=sources&force=1 one source / ignore the `every` interval\n// ?job=enrich[&force=1][&step=queue|decode|recalls|geocode|price]\n// ?job=rescore recompute score/flags for every active row (after a rule change)\n// GET ?sql=select ... read-only query (SELECT only)\n// GET ?testpush=1 send a full test Discord embed\n// GET ?pushpending=1 push every active score>=threshold row never alerted (webhook was down)\n// POST { id, status[, gone: true|reason] } set a listing's status (new|contacted|ppi|offer|dead); gone -> gone_at + GONE flag\n// GET ?job=enrich&step=verify[&force=1] re-fetch listing URLs now and mark gone ones (force: 30 rows, ignore the 12 h cadence)\n// POST { delete: { id? | rowid? | source? | url_like? | before? } }\n// POST { comps: [...] } load auction comps pulled locally (scripts/pull_comps.ts)\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { ensureSchema, checkToken, json, CORS, STATUS, pushDiscord, actionLinks, rowToPush, pushThresholdFor, score, flagsFor, decorateNotes, ageDays, conditionPoints, genFor } from \"../lib/core.ts\";\nimport craigslist from \"../cron/craigslist.ts\";\nimport sources from \"../cron/sources.ts\";\nimport enrich, { markGone } from \"../cron/enrich.ts\";\nimport { sendDigest } from \"../cron/digest.ts\";\n\nexport default async function (req: Request): Promise {\n if (req.method === \"OPTIONS\") return new Response(null, { status: 204, headers: CORS });\n if (!checkToken(req)) return json({ error: \"unauthorized\" }, 401);\n await ensureSchema();\n const url = new URL(req.url);\n\n if (req.method === \"POST\") {\n const b = await req.json().catch(() => ({}));\n if (b.delete && typeof b.delete === \"object\") {\n const w: string[] = []; const a: any[] = [];\n if (b.delete.id != null) { w.push(\"id=?\"); a.push(b.delete.id); }\n if (b.delete.rowid != null) { w.push(\"rowid_pk=?\"); a.push(Number(b.delete.rowid)); }\n if (b.delete.source) { w.push(\"source=?\"); a.push(b.delete.source); }\n if (b.delete.url_like) { w.push(\"url like ?\"); a.push(b.delete.url_like); }\n if (b.delete.before) { w.push(\"first_seen k.source && k.external_id && k.url);\n let inserted = 0;\n for (const k of rows) {\n const ex = await sqlite.execute({ sql: `select 1 from comps where source=? and external_id=?`, args: [String(k.source), String(k.external_id)] });\n await sqlite.execute({ sql: `insert into comps (source, external_id, year, gen, trans, body, miles, sold_price, sold_date, url, title, vin, added) values (?,?,?,?,?,?,?,?,?,?,?,?,date('now'))\n on conflict(source, external_id) do update set sold_price=coalesce(excluded.sold_price, comps.sold_price), sold_date=coalesce(excluded.sold_date, comps.sold_date), miles=coalesce(excluded.miles, comps.miles), trans=case when excluded.trans<>'unknown' then excluded.trans else comps.trans end`,\n args: [String(k.source), String(k.external_id), k.year ?? null, k.gen || genFor(k.year ?? null), k.trans || \"unknown\", k.body || \"unknown\", k.miles ?? null, k.sold_price ?? null, k.sold_date ?? null, String(k.url), String(k.title || \"\").slice(0, 200), k.vin || null] });\n if (!ex.rows.length) inserted++;\n }\n const n = await sqlite.execute(`select source, count(*) n from comps group by source`);\n return json({ ok: true, received: rows.length, inserted, totals: n.rows });\n }\n if (!b.id || !STATUS.includes(b.status)) return json({ error: `need id and status in ${STATUS.join(\"|\")}` }, 400);\n if (b.gone) { // tracker \"Gone\" button (Facebook rows the verify step cannot fetch): dead + gone_at + GONE flag in one call\n const cur = await sqlite.execute({ sql: `select rowid_pk, status, flags, notes from listings where id=?`, args: [b.id] });\n const row: any = cur.rows[0]; if (!row) return json({ error: \"no such id\" }, 404);\n await markGone(Number(row.rowid_pk), String(b.gone === true ? \"marked in tracker\" : b.gone).slice(0, 40), row);\n if (b.status !== \"dead\") await sqlite.execute({ sql: `update listings set status=? where id=?`, args: [b.status, b.id] });\n return json({ ok: true, gone: true });\n }\n const r = await sqlite.execute({ sql: `update listings set status=?, gone_at=case when ?='dead' then gone_at else null end where id=?`, args: [b.status, b.status, b.id] }); // reviving a row clears gone_at\n return json({ ok: true, rowsAffected: r.rowsAffected });\n }\n\n const job = url.searchParams.get(\"job\");\n if (job === \"craigslist\") return json(await craigslist());\n if (job === \"sources\") return json(await sources({ only: url.searchParams.get(\"only\") || undefined, force: !!url.searchParams.get(\"force\") }));\n if (job === \"enrich\") return json(await enrich({ force: !!url.searchParams.get(\"force\"), step: url.searchParams.get(\"step\") || undefined }));\n if (job === \"digest\") return json(await sendDigest(true));\n if (job === \"rescore\") {\n const rows = await sqlite.execute(`select * from listings where last_seen >= date('now','-60 day')`);\n let changed = 0;\n for (const r of rows.rows as any[]) {\n const text = [r.raw, r.notes].filter(Boolean).join(\" \");\n const s = score({ year: r.year == null ? null : Number(r.year), gen: r.gen, trans: r.trans, miles: r.miles == null ? null : Number(r.miles), seller: r.seller, price: r.price == null ? null : Number(r.price), dist: r.dist == null ? null : Number(r.dist), title: r.title, vin: r.vin, conditionPts: conditionPoints(text, r.gen) });\n const keep = String(r.flags || \"\").split(\"|\").filter((f: string) => /^(DEAD |VIN MISMATCH|PRICE ANOMALY|DROP |MOTIVATED)/.test(f));\n const fl = [...keep, ...flagsFor({ vin: r.vin, trim: String(r.trim || \"\"), trans: r.trans, text: String(r.raw || \"\"), dist: r.dist == null ? null : Number(r.dist), ageDays: ageDays(r.posted_at, r.first_seen) })];\n const flags = [...new Set(fl)].join(\"|\");\n if (s !== Number(r.score) || flags !== r.flags) { await sqlite.execute({ sql: `update listings set score=?, flags=?, notes=? where rowid_pk=?`, args: [s, flags, decorateNotes(String(r.notes || \"\"), flags.split(\"|\").filter(Boolean)), r.rowid_pk] }); changed++; }\n }\n return json({ rows: rows.rows.length, changed });\n }\n\n if (url.searchParams.get(\"pushpending\")) {\n const r = await sqlite.execute(`select * from listings where pushed = 0 and status <> 'dead' and last_seen >= date('now','-14 day') and julianday('now') - julianday(coalesce(posted_at, first_seen)) <= 45 order by score desc`);\n const out: any[] = [];\n for (const row of r.rows as any[]) {\n if (Number(row.score) < pushThresholdFor(row.dist == null ? null : Number(row.dist), row.seller)) continue;\n const ok = await pushDiscord(rowToPush(row));\n if (ok) await sqlite.execute({ sql: `update listings set pushed=1 where rowid_pk=?`, args: [row.rowid_pk] });\n out.push({ id: row.id, score: row.score, pushed: ok });\n }\n return json({ pending: out.length, results: out });\n }\n\n if (url.searchParams.get(\"testpush\")) {\n const l = { id: \"1G1YY22G215100001\", rowid: null, vin: \"1G1YY22G215100001\", year: 2001, gen: \"C5\" as const, trim: \"\", trans: \"auto\" as const, body: \"coupe\" as const, miles: 78500, price: 11500, title: \"clean\" as const, seller: \"private\" as const,\n loc: \"Boardman, OH - CL youngstown\", lat: 41.0242, lon: -80.6629, dist: 18, url: \"https://example.com/test-corvette\", source: \"test\", score: 11, flags: [\"MOTIVATED\", \"DROP $500\"], notes: \"Pipeline test; ignore. Service records, column lock recall done.\", trail: [12500, 12000, 11500], ageDays: 12 };\n const ok = await pushDiscord(l);\n return json({ pushed: ok, links: actionLinks(l) });\n }\n\n const sql = url.searchParams.get(\"sql\");\n if (sql) {\n if (!/^\\s*select\\b/i.test(sql)) return json({ error: \"SELECT only\" }, 400);\n const r = await sqlite.execute(sql);\n return json({ columns: r.columns, rows: r.rows });\n }\n return json({ usage: \"?job=craigslist|sources[&only=key][&force=1]|enrich[&step=..]|digest|rescore ?sql=select... ?testpush=1 ?pushpending=1 POST {id,status} POST {delete:{...}}\" });\n}\n",[],[310,319],"4e8a0f88-b47d-4b43-86fa-affd72346a91","add.ts","38cdf558-af8b-11f1-8c3c-1607ee4eb77e",21,["D",1789314991805],"// corvette-add: manual ingestion endpoint (POST). Claude in Chrome and Logan post FB Marketplace / FB group /\n// portal finds here. Shared-secret header X-Corvette-Token (or ?token=).\n//\n// Body (JSON, single object or array <= 50):\n// { url, src, vin?, year?, trans?, body?, miles?, price?, title?, seller?, loc?, lat?, lon?, note?, text?, posted?, external_id?, auction_date? }\n// `text` is the listing body; any field left blank is inferred from it. Returns the upsert result per item\n// (action inserted|updated|merged, id = VIN or \"SRC extId\", score, pushed, dead reason if any).\nimport {\n TRANS, BODY, TITLE, SELLER, ensureSchema, upsertListing, inferYear, inferTrans, inferBody, inferTitle, inferSeller, inferMiles, inferPrice, inferTrim,\n parsePrice, parseMiles, findVin, normalizeVin, validVin, checkToken, json, CORS, YEAR_MIN, YEAR_MAX, type Seller,\n} from \"../lib/core.ts\";\n\nexport default async function (req: Request): Promise {\n if (req.method === \"OPTIONS\") return new Response(null, { status: 204, headers: CORS });\n if (req.method !== \"POST\") return json({ error: \"POST only\" }, 405);\n if (!checkToken(req)) return json({ error: \"unauthorized\" }, 401);\n let body: any;\n try { body = await req.json(); } catch { return json({ error: \"invalid JSON\" }, 400); }\n const items: any[] = Array.isArray(body) ? body : [body];\n if (items.length === 0 || items.length > 50) return json({ error: \"1-50 listings per request\" }, 400);\n await ensureSchema();\n const results: any[] = [];\n for (const it of items) {\n const text = [it.title, it.loc, it.note, it.text].filter(Boolean).join(\" \\n \");\n const url = String(it.url || \"\").trim();\n const src = String(it.src || it.source || \"manual\").toLowerCase().trim();\n if (!url) { results.push({ error: \"need url\", input: it }); continue; }\n const vinIn = it.vin ? normalizeVin(it.vin) : null;\n if (it.vin && !validVin(vinIn)) results.push({ warning: `VIN ${it.vin} failed validation (17 chars, no I/O/Q, check digit); stored without it` });\n const vin = validVin(vinIn) ? vinIn : findVin(text);\n const year = it.year != null && it.year !== \"\" ? Number(it.year) : inferYear(text);\n if (year != null && (year < YEAR_MIN || year > YEAR_MAX)) { results.push({ skipped: `year ${year} outside ${YEAR_MIN}-${YEAR_MAX}`, input: it }); continue; }\n const trans = TRANS.includes(it.trans) ? it.trans : /^a/i.test(String(it.trans || \"\")) ? \"auto\" : /^m/i.test(String(it.trans || \"\")) ? \"manual\" : inferTrans(text);\n const bodyT = BODY.includes(it.body) ? it.body : inferBody(text);\n const title = TITLE.includes(it.title_status || it.title) ? (it.title_status || it.title) : inferTitle(text);\n const sellerDefault: Seller = [\"fb\", \"fbm\", \"facebook\", \"craigslist\", \"forum\", \"manual\", \"sign\"].includes(src) ? \"private\" : [\"autotrader\", \"cars\", \"cargurus\", \"carsforsale\", \"dealer\"].includes(src) ? \"dealer-small\" : \"unknown\";\n const seller = SELLER.includes(it.seller) ? it.seller : inferSeller(text, sellerDefault);\n const miles = it.miles != null && it.miles !== \"\" ? parseMiles(it.miles) : inferMiles(text);\n const price = it.price != null && it.price !== \"\" ? parsePrice(it.price) : inferPrice(text);\n const r = await upsertListing({\n vin, year, trim: inferTrim(String(it.title || it.trim || \"\")), trans, body: bodyT, miles, price, title, seller, loc: String(it.loc || it.location || \"\").trim(),\n lat: it.lat != null ? Number(it.lat) : null, lon: it.lon != null ? Number(it.lon) : null,\n source: src, externalId: it.external_id || it.externalId || (url.match(/(\\d{6,})/) || [])[1] || null, url,\n notes: String(it.note || \"\").trim(), raw: it.text ? String(it.text) : undefined, text, postedAt: it.posted || it.posted_at || null, auctionDate: it.auction_date || null,\n }, { push: true });\n results.push(r);\n }\n return json({ ok: true, results });\n}\n",[],[310,327],"b2a361ad-ea6d-43f1-bc22-2eaa212050a7",["D",1789312590546],[198,199,200,201],[310],["D",1789312547277],["D",1789486866837],{"_11":12,"_152":74},{"_11":12,"_147":148,"_73":74,"_30":72,"_149":150,"_151":24},{"_41":138,"_13":16,"_35":38,"_139":99,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":14,"_146":12},"ctx",{"_56":-5,"_171":376,"_377":378,"_379":380,"_381":24,"_382":24,"_383":24,"_384":112,"_385":-5,"_386":-7,"_387":-7,"_388":26,"_389":24,"_390":24,"_391":-5,"_392":24,"_393":24,"_394":24,"_395":-5},"ENV",{"_347":348,"_349":350,"_351":16,"_352":353,"_354":355,"_356":357,"_358":359,"_360":361,"_362":363,"_364":365,"_366":367,"_368":369,"_370":371,"_372":373,"_374":375},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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"]

History · digest.ts