\n <div className=\"chart\">{[0, 0, 0, 0, 0].map((v, i) => <div className=\"bar\" key={i}><b>—</b><span><i style={{ height: v + \"%\" }} /><em style={{ height: v + \"%\" }} /></span><small>{[\"MON\", \"TUE\", \"WED\", \"THU\", \"FRI\"][i]}</small></div>)}</div>\n </article>\n <JobCostForecast actualCost={props.rows.reduce((s, r) => s + r.totalCost, 0)} settings={props.forecast} setSettings={props.setForecast} />\n </section>\n\n <CostCodeTable rows={props.rows} production={props.production} setProduction={props.setProduction} consolidated={props.consolidateCodes} setConsolidated={props.setConsolidateCodes} />\n </>\n );\n}\n\n// ---------- Jobs Manager ----------\n// The \"Edit\" action swaps to a full-page inline editor (no overlay, backdrop,\n// body scroll lock, or nested scrolling container). The browser's regular page\n// scrollbar scrolls through every field.\nfunction JobsManager({ user, jobs, activeJob, onCreate, onUpdate, onDeleteConfirm }: {\n user: User; jobs: Job[]; activeJob: Job | null; onCreate: (name: string) => void;\n onUpdate: (id: number, fields: Record<string, string>) => Promise<boolean>; onDeleteConfirm: () => void;\n}) {\n const [name, setName] = useState(\"\");\n const [editing, setEditing] = useState<Job | null>(null);\n const [form, setForm] = useState<Record<string, string>>({});\n const [saving, setSaving] = useState(false);\n const fields: [string, string][] = [\n [\"name\", \"Job name\"], [\"job_number\", \"Job #\"], [\"status\", \"Status\"], [\"superintendent\", \"Superintendent\"],\n [\"project_manager\", \"Project manager\"], [\"foreman\", \"Foreman\"], [\"location\", \"Location\"],\n [\"jurisdiction\", \"Jurisdiction\"], [\"general_contractor\", \"General contractor\"],\n [\"prevailing_wage\", \"Prevailing wage\"], [\"permit_number\", \"Permit #\"], [\"schedule_group\", \"Schedule group\"],\n ];\n\n useEffect(() => {\n if (!editing) return;\n const f: Record<string, string> = {};\n for (const [k] of fields) f[k] = String((editing as any)[k] ?? \"\");\n setForm(f);\n setSaving(false);\n }, [editing]);\n\n async function handleSave(e: React.FormEvent) {\n e.preventDefault();\n if (!editing) return;\n setSaving(true);\n try {\n const ok = await onUpdate(editing.id, form);\n if (ok) setEditing(null); // back to the job list; the status line confirms\n } finally {\n setSaving(false);\n }\n }\n\n if (editing) {\n return (\n <section className=\"panel jobs-panel job-editor\">\n <div className=\"view-head\">\n <div><p>EDIT PROJECT</p><h3>Edit — {editing.name}</h3></div>\n </div>\n <form className=\"job-editor-form\" onSubmit={handleSave}>\n <div className=\"job-editor-toolbar top\">\n <span className=\"job-editor-meta\">Editing <b>{editing.name}</b> — changes apply to this job only.</span>\n <button type=\"button\" onClick={() => setEditing(null)} disabled={saving}>Cancel</button>\n <button className=\"gold\" type=\"submit\" disabled={saving}>{saving ? \"Saving…\" : \"Save Changes\"}</button>\n </div>\n <div className=\"form-grid job-editor-grid\">\n {fields.map(([k, label]) => (\n <label className={k === \"name\" ? \"wide\" : \"\"} key={k}>\n {label.toUpperCase()}\n <input value={form[k] ?? \"\"} onChange={(e) => setForm({ ...form, [k]: e.target.value })} />\n </label>\n ))}\n </div>\n <div className=\"job-editor-toolbar bottom\">\n <span className=\"job-editor-meta\"> </span>\n <button type=\"button\" onClick={() => setEditing(null)} disabled={saving}>Cancel</button>\n <button className=\"gold\" type=\"submit\" disabled={saving}>{saving ? \"Saving…\" : \"Save Changes\"}</button>\n </div>\n </form>\n </section>\n );\n }\n\n return (\n <section className=\"panel jobs-panel\">\n <div className=\"view-head\"><div><p>JOBS & SETTINGS</p><h3>Manage utility-schedule jobs</h3></div><span className=\"source-pill\">{jobs.length} JOB{jobs.length === 1 ? \"\" : \"S\"}</span></div>\n\n <div className=\"create-job-inline\"><input placeholder=\"New job name\" value={name} onChange={(e) => setName(e.target.value)} /><button className=\"gold\" onClick={() => { if (name.trim()) { onCreate(name.trim()); setName(\"\"); } }}>＋ Create job</button></div>\n\n <div className=\"job-list\">\n {jobs.length === 0 && <div className=\"empty-state compact\"><b>No jobs yet</b><span>Create a job to begin. Tables are intentionally empty in this staging phase.</span></div>}\n {jobs.map((j) => (\n <div className={`job-list-row ${j.id === activeJob?.id ? \"active\" : \"\"}`} key={j.id}>\n <span><b>{j.name}</b><small>{j.job_number ? `${j.job_number} · ` : \"\"}{j.source === \"monday\" ? \"Monday.com\" : \"Manual\"} · created manually</small></span>\n <span className=\"job-list-actions\">\n <button onClick={() => setEditing(j)}>Edit</button>\n {user.role === \"admin\" && <button className=\"danger-ghost\" onClick={onDeleteConfirm}>Delete</button>}\n </span>\n </div>\n ))}\n </div>\n </section>\n );\n}\n\n// ---------- Daily production ----------\nfunction DailyProduction({ entries, rates, onAddEntry, onAdd }: { entries: Entry[]; rates: LaborRates; onAddEntry: (e: Entry) => void; onAdd: () => void }) {\n const [open, setOpen] = useState(false);\n const [form, setForm] = useState({ activity: \"\", unit: \"LF\", qty: \"\", laborHours: \"\", operatorHours: \"\", foremanHours: \"\", equipment: \"001 2013 Ram Truck 3500 ST\", equipmentHours: \"\" });\n const [equipmentRates, setEquipmentRates] = useState<EquipmentRate[]>([]);\n useEffect(() => { api(\"/api/equipment-rates\").then((d) => setEquipmentRates(d.rates ?? [])).catch(() => {}); }, []);\n const selected = equipmentRates.find((x) => x.label === form.equipment) ?? equipmentRates[0];\n const equipmentCost = (selected?.rate ?? 0) * Number(form.equipmentHours);\n const laborCost = Number(form.laborHours) * rates.labor + Number(form.operatorHours) * rates.operator + Number(form.foremanHours) * rates.foreman;\n function save(e: React.FormEvent) {\n e.preventDefault();\n onAddEntry({ id: Date.now(), activity: form.activity, unit: form.unit, qty: +form.qty || 0, hours: Number(form.laborHours) + Number(form.operatorHours) + Number(form.foremanHours), labor: laborCost, equipment: equipmentCost });\n setForm({ activity: \"\", unit: \"LF\", qty: \"\", laborHours: \"\", operatorHours: \"\", foremanHours: \"\", equipment: equipmentRates[0]?.label ?? \"\", equipmentHours: \"\" });\n setOpen(false);\n }\n return (\n <section className=\"panel daily-view\">\n <div className=\"view-head\"><div><p>FIELD ENTRIES</p><h3>Production and cost log</h3></div><button className=\"gold\" onClick={() => setOpen(true)}>＋ New entry</button></div>\n <div className=\"daily-row daily-head\"><span>ACTIVITY</span><span>QUANTITY</span><span>HOURS</span><span>LABOR</span><span>EQUIPMENT</span><span>TOTAL</span></div>\n {entries.length ? entries.map((e) => (\n <div className=\"daily-row\" key={e.id}><span><b>{e.activity}</b></span><span>{e.qty ? `${e.qty.toLocaleString()} ${e.unit}` : \"Imported total\"}</span><span>{e.hours.toFixed(2)}</span><span>{money(e.labor, 2)}</span><span>{money(e.equipment, 2)}</span><span><b>{money(e.labor + e.equipment, 2)}</b></span></div>\n )) : <div className=\"empty-state\"><b>No production entries yet</b><span>Add a field entry or upload the job’s Excel time sheet.</span></div>}\n\n {open && (\n <div className=\"backdrop\" onMouseDown={() => setOpen(false)}>\n <form onSubmit={save} onMouseDown={(e) => e.stopPropagation()}>\n <div className=\"form-head\"><div><p>DAILY FIELD ENTRY</p><h2>Add production & cost</h2></div><button type=\"button\" onClick={() => setOpen(false)}>×</button></div>\n <div className=\"form-grid\">\n <label className=\"wide\">ACTIVITY<input value={form.activity} onChange={(e) => setForm({ ...form, activity: e.target.value })} /></label>\n <label>QUANTITY<input type=\"number\" value={form.qty} onChange={(e) => setForm({ ...form, qty: e.target.value })} /></label>\n <label>UNIT<select value={form.unit} onChange={(e) => setForm({ ...form, unit: e.target.value })}>{UNITS.map((u) => <option key={u}>{u}</option>)}</select></label>\n <label>LABOR HOURS · {money(rates.labor, 2)}/HR<input type=\"number\" step=\".25\" value={form.laborHours} onChange={(e) => setForm({ ...form, laborHours: e.target.value })} /></label>\n <label>OPERATOR HOURS · {money(rates.operator, 2)}/HR<input type=\"number\" step=\".25\" value={form.operatorHours} onChange={(e) => setForm({ ...form, operatorHours: e.target.value })} /></label>\n <label>FOREMAN HOURS · {money(rates.foreman, 2)}/HR<input type=\"number\" step=\".25\" value={form.foremanHours} onChange={(e) => setForm({ ...form, foremanHours: e.target.value })} /></label>\n <label className=\"wide\">EQUIPMENT<select value={form.equipment} onChange={(e) => setForm({ ...form, equipment: e.target.value })}>{equipmentRates.map((x) => <option key={x.label}>{x.label}</option>)}</select></label>\n <label>EQUIPMENT HOURS<input type=\"number\" step=\".25\" value={form.equipmentHours} onChange={(e) => setForm({ ...form, equipmentHours: e.target.value })} /></label>\n <label>HOURLY RATE<input value={money(selected?.rate ?? 0, 2) + \" / hr\"} readOnly /></label>\n </div>\n <div className=\"equipment-calc\"><span><small>EQUIPMENT COST</small><b>{money(equipmentCost, 2)}</b></span><em>{form.equipmentHours || 0} hrs × {money(selected?.rate ?? 0, 2)}/hr</em></div>\n <div className=\"calculated\"><span>CALCULATED TOTAL COST / UNIT</span><b>{money((laborCost + equipmentCost) / Math.max(1, +form.qty), 2)} / {form.unit}</b></div>\n <div className=\"actions\"><button type=\"button\" onClick={() => setOpen(false)}>Cancel</button><button className=\"gold\">Save daily production</button></div>\n </form>\n </div>\n )}\n </section>\n );\n}\n\n// ---------- Labor rates ----------\nfunction LaborRateSettings({ job, rates, setRates, status, onSave }: { job: Job | null; rates: LaborRates; setRates: (v: LaborRates) => void; status: string; onSave: (e: React.FormEvent) => void }) {\n return (\n <section className=\"labor-settings\">\n <article className=\"panel rate-settings-card\">\n <div className=\"settings-head\"><div><p>JOB-SPECIFIC LABOR RATES</p><h3>Hourly rate schedule</h3></div><span className=\"save-status\">● {status || \"Ready\"}</span></div>\n <label className=\"settings-job\">JOB<input readOnly value={job?.name ?? \"Select a job\"} /></label>\n <form onSubmit={onSave}>\n <div className=\"rate-input-grid\">\n <RateInput label=\"Labor\" value={rates.labor} onChange={(v) => setRates({ ...rates, labor: v })} />\n <RateInput label=\"Operator\" value={rates.operator} onChange={(v) => setRates({ ...rates, operator: v })} />\n <RateInput label=\"Foreman\" value={rates.foreman} onChange={(v) => setRates({ ...rates, foreman: v })} />\n </div>\n <div className=\"rate-actions\"><span>These rates apply only to <b>{job?.name ?? \"this job\"}</b> and update new production entries immediately.</span><button type=\"button\" onClick={() => setRates(DEFAULT_RATES)}>Use standard rates</button><button className=\"gold\">Save job rates</button></div>\n </form>\n </article>\n <article className=\"panel prevailing-card\"><i>PW</i><div><p>PREVAILING WAGE READY</p><h3>Different job, different rates.</h3><span>Choose a job above, enter its required wage rates, and save. Your standard-rate jobs remain unchanged.</span></div></article>\n </section>\n );\n}\nfunction RateInput({ label, value, onChange }: { label: string; value: number; onChange: (v: number) => void }) {\n return <label><span>{label}<small>HOURLY RATE</small></span><div><i>$</i><input type=\"number\" min=\"0\" max=\"500\" step=\".01\" value={value} onChange={(e) => onChange(Number(e.target.value))} /><em>/ hr</em></div></label>;\n}\n\n// ---------- Equipment ----------\nfunction OperationsUsageView({ usage, days, phases, showPhases, setShowPhases }: { usage: EquipmentUsage[]; days: CrewDay[]; phases: PhaseUsage[]; showPhases: boolean; setShowPhases: (v: boolean) => void }) {\n const hasData = usage.length > 0 || days.length > 0;\n return <>\n <section className=\"phase-controls\"><div><p>JOB UTILIZATION VIEW</p><b>{showPhases ? \"Equipment and crew by phase code\" : \"Equipment and crew totals\"}</b></div><button disabled={!hasData} onClick={() => setShowPhases(!showPhases)}>{showPhases ? \"← Show job totals\" : \"View by phase code →\"}</button></section>\n {showPhases ? <PhaseCodeUsagePanel phases={phases} /> : <section className=\"operations-grid\"><EquipmentUsagePanel usage={usage} /><CrewSizePanel days={days} /></section>}\n </>;\n}\nfunction EquipmentUsagePanel({ usage }: { usage: EquipmentUsage[] }) {\n const top = usage.slice(0, 5); const max = top[0]?.hours || 1;\n return <article className=\"panel usage-panel\"><div className=\"view-head\"><div><p>TIMESHEET EQUIPMENT</p><h3>Most-used equipment</h3></div>{usage.length > 0 && <span className=\"source-pill\">RANKED BY HOURS</span>}</div>\n {top.length ? <div className=\"usage-list\">{top.map((item, i) => <div className=\"usage-row\" key={item.name}><i>{i + 1}</i><span><b>{item.name}</b><small>{item.entries} time {item.entries === 1 ? \"entry\" : \"entries\"}{item.cost > 0 ? ` · ${money(item.cost, 2)} cost` : \" · rate not matched\"}</small><em><u style={{ width: `${Math.max(6, item.hours / max * 100)}%` }} /></em></span><strong>{item.hours.toFixed(1)}<small> hrs</small></strong></div>)}</div> : <div className=\"empty-state compact\"><b>No equipment usage yet</b><span>Upload the job’s labor and equipment Excel file to rank equipment by hours.</span></div>}\n </article>;\n}\nfunction CrewSizePanel({ days }: { days: CrewDay[] }) {\n const average = days.length ? days.reduce((sum, d) => sum + d.size, 0) / days.length : 0;\n const peak = days.reduce((m, d) => Math.max(m, d.size), 0);\n const recent = days.slice(-5).reverse();\n return <article className=\"panel crew-panel\"><div className=\"view-head\"><div><p>TIMESHEET CREW</p><h3>Crew size by workday</h3></div>{days.length > 0 && <span className=\"source-pill\">UNIQUE EMPLOYEES</span>}</div>\n {days.length ? <><div className=\"crew-summary\"><span><small>AVERAGE CREW</small><b>{average.toFixed(1)}</b></span><span><small>PEAK CREW</small><b>{peak}</b></span><span><small>WORKDAYS</small><b>{days.length}</b></span></div><div className=\"crew-days\">{recent.map((day) => <div key={day.date}><span><b>{new Date(day.date + \"T12:00:00\").toLocaleDateString(\"en-US\", { month: \"short\", day: \"numeric\" })}</b><small>{day.hours.toFixed(1)} total labor hrs</small></span><strong>{day.size}<small> people</small></strong></div>)}</div></> : <div className=\"empty-state compact\"><b>No crew data yet</b><span>Crew size will calculate from unique employee IDs for each workday.</span></div>}\n </article>;\n}\nfunction PhaseCodeUsagePanel({ phases }: { phases: PhaseUsage[] }) {\n const [expanded, setExpanded] = useState(\"\");\n return <section className=\"panel phase-usage\"><div className=\"view-head\"><div><p>PHASE CODE UTILIZATION</p><h3>Equipment and crew by phase</h3></div><span className=\"source-pill\">CLICK A PHASE TO EXPAND</span></div>\n {phases.length ? <div className=\"phase-table\"><div className=\"phase-row phase-head\"><span>PHASE CODE</span><span>MOST-USED EQUIPMENT</span><span>EQUIPMENT HOURS</span><span>AVG. CREW</span><span>PEAK CREW</span><span>WORKDAYS</span></div>\n {phases.map((phase) => { const average = phase.days.length ? phase.days.reduce((s, d) => s + d.size, 0) / phase.days.length : 0; const peak = phase.days.reduce((m, d) => Math.max(m, d.size), 0); const top = phase.equipment[0]; const isOpen = expanded === phase.phaseCode; const maxHours = top?.hours || 1;\n return <div className={`phase-group${isOpen ? \" open\" : \"\"}`} key={phase.phaseCode}><button type=\"button\" className=\"phase-row phase-click\" aria-expanded={isOpen} onClick={() => setExpanded(isOpen ? \"\" : phase.phaseCode)}><span className=\"phase-name\"><i>{isOpen ? \"−\" : \"+\"}</i><b>{phase.phaseCode}</b></span><span>{top ? <><b>{top.name}</b><small>{phase.equipment.length} equipment {phase.equipment.length === 1 ? \"unit\" : \"units\"} used</small></> : <em>No equipment assigned</em>}</span><span><b>{phase.equipment.reduce((s, i) => s + i.hours, 0).toFixed(1)}</b><small>hours</small></span><span><b>{average.toFixed(1)}</b><small>people</small></span><span><b>{peak}</b><small>people</small></span><span><b>{phase.days.length}</b><small>days</small></span></button>\n {isOpen && <div className=\"phase-detail\"><div className=\"phase-equipment-detail\"><div className=\"detail-title\"><p>ALL EQUIPMENT USED</p><b>{phase.equipment.length} units ranked by hours</b></div>{phase.equipment.length ? <div className=\"usage-list\">{phase.equipment.map((item, index) => <div className=\"usage-row\" key={item.name}><i>{index + 1}</i><span><b>{item.name}</b><small>{item.entries} time {item.entries === 1 ? \"entry\" : \"entries\"}{item.cost > 0 ? ` · ${money(item.cost, 2)} matched cost` : \" · rate not matched\"}</small><em><u style={{ width: `${Math.max(6, item.hours / maxHours * 100)}%` }} /></em></span><strong>{item.hours.toFixed(1)}<small> hrs</small></strong></div>)}</div> : <div className=\"detail-empty\">No equipment assigned to this phase.</div>}</div><div className=\"phase-crew-detail\"><div className=\"detail-title\"><p>CREW BY WORKDAY</p><b>Unique employees per day</b></div><div className=\"crew-summary\"><span><small>AVERAGE CREW</small><b>{average.toFixed(1)}</b></span><span><small>PEAK CREW</small><b>{peak}</b></span><span><small>WORKDAYS</small><b>{phase.days.length}</b></span></div><div className=\"crew-days detail-days\">{phase.days.slice().reverse().map((day) => <div key={day.date}><span><b>{new Date(day.date + \"T12:00:00\").toLocaleDateString(\"en-US\", { month: \"short\", day: \"numeric\", year: \"numeric\" })}</b><small>{day.hours.toFixed(1)} total labor hrs</small></span><strong>{day.size}<small> people</small></strong></div>)}</div></div></div>}\n </div>; })}\n </div> : <div className=\"empty-state compact\"><b>No phase-code usage yet</b><span>Upload a BusyBusy time sheet to build the phase-code breakdown.</span></div>}\n </section>;\n}\nfunction EquipmentMovesPanel({ moves }: { moves: EquipmentMove[] }) {\n const totalHours = moves.reduce((s, m) => s + m.hours, 0);\n const totalCost = moves.reduce((s, m) => s + m.cost, 0);\n const review = moves.filter((m) => m.needsReview).length;\n return <section className=\"panel equipment-moves\"><div className=\"view-head\"><div><p>MOBILIZATION PHASE CODE · 1101</p><h3>Equipment moves</h3></div>{moves.length > 0 && <span className=\"source-pill\">{moves.length} {moves.length === 1 ? \"MOVE\" : \"MOVES\"}</span>}</div>\n {moves.length ? <><div className=\"move-summary\"><span><small>EQUIPMENT MOVES</small><b>{moves.length}</b></span><span><small>MOVE HOURS</small><b>{totalHours.toFixed(1)}</b></span><span><small>TOTAL MOVE COST</small><b>{money(totalCost, 2)}</b></span><span className={review ? \"review\" : \"\"}><small>NEEDS REVIEW</small><b>{review}</b></span></div>\n <div className=\"move-table\"><div className=\"move-row move-head\"><span>DATE</span><span>EQUIPMENT MOVED</span><span>HAULING EQUIPMENT / DRIVER</span><span>HOURS</span><span>COST</span></div>\n {moves.map((move) => <div className=\"move-row\" key={move.id}><span>{move.date ? new Date(move.date + \"T12:00:00\").toLocaleDateString(\"en-US\", { month: \"short\", day: \"numeric\", year: \"numeric\" }) : \"Date unavailable\"}</span><span><b>{move.movedEquipment}</b><small>{move.description}</small></span><span><b>{move.haulingEquipment}</b><small>{move.driver}</small></span><span><b>{move.hours.toFixed(1)}</b><small>hours</small></span><span><b>{money(move.cost, 2)}</b><small>{money(move.laborCost, 2)} labor + {move.haulingCost > 0 ? `${money(move.haulingCost, 2)} truck` : \"truck rate missing\"}</small>{move.needsReview && <em>Review match</em>}</span></div>)}\n </div></> : <div className=\"empty-state compact\"><b>No equipment moves found yet</b><span>Upload a BusyBusy time sheet. Mobilization entries that name the transported machine in the description will appear here.</span></div>}\n </section>;\n}\nfunction RateBook({ search, setSearch, rates }: { search: string; setSearch: (v: string) => void; rates: EquipmentRate[] }) {\n return <section className=\"panel rate-book\"><div className=\"rate-tools\"><div><p>IMPORTED EQUIPMENT RATES</p><h3>{rates.length} equipment records</h3></div><input placeholder=\"Search unit, make, or model…\" value={search} onChange={(e) => setSearch(e.target.value)} /></div>\n <div className=\"rate-header\"><span>EQUIPMENT ID & DESCRIPTION</span><span>HOURLY RATE</span></div>\n <div className=\"rate-list\">{rates.map((x) => <div className=\"rate-row\" key={x.label}><span><i>⚙</i><b>{x.label}</b></span><strong>{money(x.rate, 2)}<small>/ hr</small></strong></div>)}</div>\n </section>;\n}\n\n// ---------- Cost code + unit cost ----------\nfunction fourDigitCode(value: string) { return value.match(/^\\s*(\\d{4})/)?.[1] ?? value.split(\" - \")[0]; }\nfunction consolidatedRows(rows: CostRow[]) {\n const grouped = new Map<string, CostRow>();\n for (const row of rows) {\n const code = fourDigitCode(row.costCode); const prior = grouped.get(code);\n if (!prior) { grouped.set(code, { ...row, costCode: `${code} - Consolidated` }); continue; }\n prior.laborHours += row.laborHours; prior.operatorHours += row.operatorHours; prior.foremanHours += row.foremanHours;\n prior.equipmentHours += row.equipmentHours; prior.laborCost += row.laborCost; prior.equipmentCost += row.equipmentCost; prior.totalCost += row.totalCost;\n }\n return [...grouped.values()].sort((a, b) => a.costCode.localeCompare(b.costCode));\n}\nfunction CostCodeTable({ rows, production, setProduction, consolidated, setConsolidated }: {\n rows: CostRow[]; production: Record<string, ProductionValue>; setProduction: (v: Record<string, ProductionValue>) => void;\n consolidated: boolean; setConsolidated: (v: boolean) => void;\n}) {\n const displayedRows = consolidated ? consolidatedRows(rows) : rows;\n const totalLabor = rows.reduce((a, r) => a + r.laborCost, 0);\n const totalEquipment = rows.reduce((a, r) => a + r.equipmentCost, 0);\n return <section className=\"panel cost-code-panel\">\n <div className=\"cost-code-title\"><div><p>BUSYBUSY ACTUAL COSTS</p><h3>{consolidated ? \"Cost consolidated by 4-digit code\" : \"Cost by code + manual production\"}</h3><button type=\"button\" className={consolidated ? \"consolidate-button active\" : \"consolidate-button\"} onClick={() => setConsolidated(!consolidated)}>{consolidated ? \"✓ Consolidated · Show detail\" : \"Consolidate by 4-digit code\"}</button></div><div><span><small>LABOR</small><b>{money(totalLabor, 2)}</b></span><span><small>EQUIPMENT</small><b>{money(totalEquipment, 2)}</b></span><span className=\"total\"><small>TOTAL ACTUAL COST</small><b>{money(totalLabor + totalEquipment, 2)}</b></span></div></div>\n <div className=\"cost-code-scroll\"><div className=\"cost-code-row cost-code-head\"><span>COST CODE</span><span>LABOR COST</span><span>EQUIPMENT COST</span><span>TOTAL COST</span><span>PRODUCTION</span><span>ACTUAL / TARGET</span></div>\n {displayedRows.length === 0 && <div className=\"empty-state compact\"><b>No actual costs yet</b><span>Upload a BusyBusy Excel time sheet to populate cost codes.</span></div>}\n {displayedRows.map((r) => { const code = consolidated ? fourDigitCode(r.costCode) : r.costCode; const exact = production[code]; const matched = Object.entries(production).find(([k]) => k.startsWith(r.costCode.split(\" - \")[0] + \" - \"))?.[1]; const children = consolidated ? Object.entries(production).filter(([key, value]) => fourDigitCode(key) === code && Number(value.qty) > 0).map(([, value]) => value) : []; const units = [...new Set(children.map((value) => value.unit))]; const rolled = children.length && units.length === 1 ? { qty: String(children.reduce((s, v) => s + Number(v.qty), 0)), unit: units[0], note: \"Rolled up from detailed production\" } : undefined; const p = exact ?? rolled ?? matched ?? { qty: \"\", unit: \"LF\" }; const qty = Number(p.qty); const cpU = qty ? r.totalCost / qty : 0;\n return <div className=\"cost-code-row\" key={r.costCode}><span><b>{r.costCode}</b><small>{r.laborHours + r.operatorHours + r.foremanHours} labor hrs · {r.equipmentHours} equipment hrs{consolidated ? \" · grouped by first 4 digits\" : \"\"}</small></span><span>{money(r.laborCost, 2)}</span><span>{money(r.equipmentCost, 2)}</span><span><b>{money(r.totalCost, 2)}</b></span><span className=\"production-input\"><input type=\"number\" min=\"0\" step=\".01\" placeholder=\"Enter qty\" value={p.qty} onChange={(e) => setProduction({ ...production, [code]: { ...p, qty: e.target.value } })} /><select value={p.unit} onChange={(e) => setProduction({ ...production, [code]: { ...p, unit: e.target.value } })}>{UNITS.map((u) => <option key={u}>{u}</option>)}</select>{p.note && <small className=\"scope-note\">{p.note}</small>}</span><span className={qty ? \"unit-cost\" : \"pending-unit\"}>{qty ? <><b>{money(cpU, 2)} <small>/ {p.unit}</small></b>{p.targetCost && <small>Target {money(p.targetCost, 2)} / {p.unit}</small>}</> : <em>Awaiting production</em>}</span></div>;\n })}\n </div>\n </section>;\n}\nfunction UnitCostView({ rows, production, setProduction, consolidateCodes, setConsolidateCodes }: {\n rows: CostRow[]; production: Record<string, ProductionValue>; setProduction: (v: Record<string, ProductionValue>) => void; consolidateCodes: boolean; setConsolidateCodes: (v: boolean) => void;\n}) {\n const measured = rows.filter((r) => { const p = production[r.costCode] ?? Object.entries(production).find(([k]) => k.startsWith(r.costCode.split(\" - \")[0] + \" - \"))?.[1]; return Number(p?.qty) > 0; });\n return <><section className=\"unit-summary\"><article><p>MEASURED COST CODES</p><h2>{measured.length}</h2><span>with installed production</span></article><article><p>AWAITING QUANTITY</p><h2>{rows.length - measured.length}</h2><span>cost codes need LF or EA</span></article><article><p>VISTA TARGETS</p><h2>{Object.values(production).filter((p) => p.targetCost).length}</h2><span>target unit costs loaded</span></article></section>\n <CostCodeTable rows={rows} production={production} setProduction={setProduction} consolidated={consolidateCodes} setConsolidated={setConsolidateCodes} />\n </>;\n}\n\n// ---------- Forecast / reports ----------\nfunction JobCostForecast({ actualCost, settings, setSettings }: { actualCost: number; settings: Forecast; setSettings: (v: Forecast) => void }) {\n const budget = Number(settings.budget), completion = Math.min(100, Math.max(0, Number(settings.completion)));\n const ready = budget > 0 && completion > 0;\n const budgetUsed = budget > 0 ? actualCost / budget * 100 : 0;\n const projected = ready ? actualCost / (completion / 100) : 0;\n const variance = ready ? budget - projected : 0;\n const variancePercent = ready ? Math.abs(variance) / budget * 100 : 0;\n const state = !ready ? \"setup\" : variance >= 0 ? \"on-track\" : variancePercent <= 5 ? \"watch\" : \"over\";\n const label = state === \"setup\" ? \"ADD BUDGET + PROGRESS\" : state === \"on-track\" ? \"ON TRACK\" : state === \"watch\" ? \"WATCH\" : \"PROJECTED OVER BUDGET\";\n return <article className={`panel forecast-card ${state}`}><div className=\"forecast-head\"><div><p>JOB COST FORECAST</p><h3>Budget health + projected finish</h3></div><span>{label}</span></div>\n <div className=\"forecast-inputs\"><label><small>COST BUDGET</small><div><i>$</i><input type=\"number\" min=\"0\" step=\"100\" placeholder=\"Enter budget\" value={settings.budget} onChange={(e) => setSettings({ ...settings, budget: e.target.value })} /></div></label><label><small>ESTIMATED JOB COMPLETION</small><div><input type=\"number\" min=\"0\" max=\"100\" step=\"1\" placeholder=\"0\" value={settings.completion} onChange={(e) => setSettings({ ...settings, completion: e.target.value })} /><i>%</i></div></label></div>\n <div className=\"forecast-bars\"><div><span><small>JOB COMPLETION</small><b>{completion.toFixed(0)}%</b></span><i><em style={{ width: `${completion}%` }} /></i></div><div><span><small>BUDGET SPENT</small><b>{budget > 0 ? `${budgetUsed.toFixed(0)}%` : \"—\"}</b></span><i><em className={budgetUsed > 100 ? \"over\" : undefined} style={{ width: `${Math.min(100, budgetUsed)}%` }} /></i></div></div>\n {ready ? <div className=\"forecast-result\"><span><small>ACTUAL COST TO DATE</small><b>{money(actualCost, 2)}</b></span><span><small>PROJECTED FINAL COST</small><b>{money(projected, 2)}</b></span><span className={variance >= 0 ? \"positive\" : \"negative\"}><small>PROJECTED VARIANCE</small><b>{variance >= 0 ? `${money(variance, 2)} under` : `${money(Math.abs(variance), 2)} over`}</b><em>{variancePercent.toFixed(1)}% of budget</em></span></div> : <div className=\"forecast-empty\"><b>Enter the job’s cost budget and estimated completion.</b><span>The forecast will compare how much work is complete against how much budget has been spent.</span></div>}\n </article>;\n}\nfunction ReportsView({ job, totals, total, rows, production }: { job: Job | null; totals: { hours: number; labor: number; equipment: number }; total: number; rows: CostRow[]; production: Record<string, ProductionValue> }) {\n const ranked = rows.filter((r) => r.totalCost > 0).slice().sort((a, b) => b.totalCost - a.totalCost).slice(0, 5);\n return <section className=\"report-view\">\n <article className=\"panel report-cover\"><p>EXECUTIVE PRODUCTION REPORT</p><h2>{job?.name ?? \"No job selected\"}</h2><span>Current imported labor, equipment, and installed-unit cost summary</span>\n <div className=\"report-kpis\"><div><small>TOTAL COST</small><b>{money(total, 2)}</b></div><div><small>LABOR HOURS</small><b>{totals.hours.toFixed(1)}</b></div><div><small>LABOR COST</small><b>{money(totals.labor, 2)}</b></div><div><small>EQUIPMENT COST</small><b>{money(totals.equipment, 2)}</b></div></div>\n </article>\n <article className=\"panel report-rank\"><div className=\"view-head\"><div><p>TOP COST CODES</p><h3>Largest actual costs</h3></div></div>\n {ranked.map((r, i) => { const p = production[r.costCode]; const qty = Number(p?.qty); return <div className=\"rank-row\" key={r.costCode}><i>{i + 1}</i><span><b>{r.costCode}</b><small>{qty ? `${money(r.totalCost / qty, 2)} / ${p.unit}` : \"Production quantity not entered\"}</small></span><strong>{money(r.totalCost, 2)}</strong></div>; })}\n {ranked.length === 0 && <div className=\"empty-state compact\"><b>No cost data yet</b><span>Upload a BusyBusy time sheet to populate the report.</span></div>}\n <div className=\"report-print\"><button className=\"gold\" onClick={() => window.print()}>⇩ Print / save PDF</button></div>\n </article>\n </section>;\n}\n\nfunction Title({ title, onClick }: { title: string; onClick: () => void }) {\n return <div className=\"title\"><div><h3>{title}</h3></div><button type=\"button\" onClick={onClick}>View details →</button></div>;\n}\nfunction Kpi({ icon, label, value, note, accent = false }: { icon: string; label: string; value: string; note: string; accent?: boolean }) {\n return <article className={accent ? \"accent\" : \"\"}><i>{icon}</i><p>{label}</p><h2>{value}</h2><span>{note}</span></article>;\n}\n\n// ---------- Migration checklist ----------\nfunction MigrationChecklist({ user }: { user: User }) {\n const items: { label: string; done: boolean; detail: string }[] = [\n { label: \"Database migrations\", done: true, detail: \"users, sessions, approved emails, jobs, job labor rates, job data, Monday snapshots, uploaded-file metadata.\" },\n { label: \"Email login + secure sessions\", done: true, detail: \"HTTP-only, Secure, SameSite session cookies; PBKDF2-hashed passwords.\" },\n { label: \"Approved-email allowlist + roles\", done: true, detail: \"admin / user roles enforced on all data APIs.\" },\n { label: \"First-run admin setup\", done: true, detail: \"Owner configures the initial admin before any data loads.\" },\n { label: \"Job creation, selection, editing, deletion\", done: true, detail: \"Admin-managed job CRUD persisted to scoped SQLite.\" },\n { label: \"Per-job labor / operator / foreman rates\", done: true, detail: \"Saved per job with standard defaults.\" },\n { label: \"Vista TXT target import\", done: true, detail: \"Browser-side parsing; targets saved in the job's production map.\" },\n { label: \"BusyBusy Excel labor & equipment import\", done: true, detail: \"SheetJS in the browser; original file stored to scoped Blob Storage.\" },\n { label: \"Cost-code consolidation by first 4 digits\", done: true, detail: \"1201.2 + 1201.3 → 1201; toggle shown in the cost-code table.\" },\n { label: \"Equipment usage, crew size, phase-code views\", done: true, detail: \"Most-used equipment, crew-by-day, expandable phase-code breakdown.\" },\n { label: \"Equipment-move tracking (phase 1101)\", done: true, detail: \"Driver labor + hauling truck cost, no charge for the transported machine.\" },\n { label: \"Manual production + cost-per-unit\", done: true, detail: \"Enter quantities per cost code; actual/target unit-cost compare.\" },\n { label: \"Reports & print/PDF view\", done: true, detail: \"Executive report cover + top cost codes; print stylesheet.\" },\n { label: \"Permanent job-based storage\", done: true, detail: \"Job data in scoped SQLite; original files in scoped Blob Storage, associated by job.\" },\n { label: \"Monday.com connection\", done: true, detail: \"Integrated & reachable (board discovery, column mapping, Completed filter, item-id upsert, snapshots, Refresh button).\" },\n { label: \"Monday.com live sync\", done: false, detail: \"Awaiting a valid MONDAY_TOKEN — the currently configured token is rejected by Monday (401), so no jobs have been imported yet.\" },\n ];\n const doneCount = items.filter((i) => i.done).length;\n return <section className=\"panel migration-panel\">\n <div className=\"view-head\"><div><p>MIGRATION CHECKLIST</p><h3>Val Town staging — {doneCount}/{items.length} complete</h3></div><span className=\"source-pill\">AUTHENTICATED · {user.role.toUpperCase()}</span></div>\n <div className=\"migration-list\">{items.map((item) => <div className={`migration-row ${item.done ? \"done\" : \"\"}`} key={item.label}><i>{item.done ? \"✓\" : \"○\"}</i><span><b>{item.label}</b><small>{item.detail}</small></span></div>)}</div>\n <div className=\"migration-note\"><b>Remaining for Monday.com:</b> replace <code>MONDAY_TOKEN</code> with a valid token, then click <b>Refresh</b> to import the Utility Schedule. The full equipment-rate tail re-import may also be needed for production matching.</div>\n </section>;\n}\n","label",[306,82],"frontend","pulls","branches",1,"forks","envVars",{"_315":317,"_318":26},"connections",{"_315":26,"_316":26},"count","unfilledCount",3,"emptyCount",{"_49":422,"_13":306,"_80":297,"_59":-5,"_51":52,"_298":399,"_299":236,"_53":423,"_55":26,"_83":391,"_302":-5,"_85":24,"_304":-5,"_338":424,"_17":425},{"_49":296,"_13":82,"_80":81,"_59":297,"_51":52,"_298":217,"_299":236,"_53":419,"_55":301,"_83":84,"_302":303,"_85":24,"_304":-5,"_338":420,"_17":421},{"_49":411,"_13":412,"_80":413,"_59":297,"_51":52,"_298":414,"_299":236,"_53":415,"_55":26,"_83":84,"_302":416,"_85":24,"_304":-5,"_338":417,"_17":418},{"_49":403,"_13":404,"_80":405,"_59":297,"_51":52,"_298":406,"_299":236,"_53":407,"_55":26,"_83":84,"_302":408,"_85":24,"_304":-5,"_338":409,"_17":410},{"_49":394,"_13":395,"_80":396,"_59":297,"_51":52,"_298":397,"_299":236,"_53":398,"_55":399,"_83":21,"_302":400,"_85":24,"_304":-5,"_338":401,"_17":402},{"_49":387,"_13":388,"_80":389,"_59":-5,"_51":52,"_298":301,"_299":236,"_53":390,"_55":26,"_83":391,"_302":-5,"_85":24,"_304":-5,"_338":392,"_17":393},{"_49":379,"_13":380,"_80":381,"_59":-5,"_51":52,"_298":382,"_299":236,"_53":383,"_55":317,"_83":21,"_302":384,"_85":24,"_304":-5,"_338":385,"_17":386},{"_49":372,"_13":373,"_80":374,"_59":-5,"_51":52,"_298":317,"_299":236,"_53":375,"_55":26,"_83":84,"_302":376,"_85":24,"_304":-5,"_338":377,"_17":378},{"_49":364,"_13":365,"_80":366,"_59":-5,"_51":52,"_298":367,"_299":236,"_53":368,"_55":317,"_83":84,"_302":369,"_85":24,"_304":-5,"_338":370,"_17":371},{"_49":357,"_13":358,"_80":359,"_59":-5,"_51":52,"_298":351,"_299":236,"_53":360,"_55":26,"_83":84,"_302":361,"_85":24,"_304":-5,"_338":362,"_17":363},{"_49":347,"_13":348,"_80":234,"_59":-5,"_51":52,"_298":349,"_299":236,"_53":350,"_55":351,"_83":352,"_302":353,"_85":24,"_304":354,"_338":355,"_17":356},{"_49":341,"_13":342,"_80":343,"_59":-5,"_51":52,"_298":309,"_299":236,"_53":344,"_55":26,"_83":84,"_302":88,"_85":24,"_304":-5,"_338":345,"_17":346},{"_49":332,"_13":333,"_80":334,"_59":-5,"_51":52,"_298":335,"_299":236,"_53":336,"_55":309,"_83":84,"_302":337,"_85":24,"_304":-5,"_338":339,"_17":340},"0fc916f7-c58e-4779-aaa9-6a7100895d32","monday.ts","3c282dc8-a814-11f1-ac25-1607ee4eb77e",44,["D",1788494111282],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n/**\n * Monday.com Utility Schedule integration (server-side).\n *\n * The MONDAY_TOKEN is read ONLY from the environment and is never returned,\n * logged, or exposed to the browser. All error messages are generic — they\n * never include the token.\n */\n\nconst MONDAY_API = \"https://api.monday.com/v2\";\nconst MONDAY_API_VERSION = \"2023-10\";\nconst UTILITY_RE = /utility\\s*schedule/i;\n\nexport interface MondayColumn {\n id: string;\n title: string;\n type: string;\n}\nexport interface MondayGroup {\n id: string;\n title: string;\n}\nexport interface BoardMeta {\n id: string;\n name: string;\n groups: MondayGroup[];\n columns: MondayColumn[];\n}\nexport interface SyncResult {\n ok: boolean;\n error?: string;\n added: number;\n updated: number;\n ignoredCompleted: number;\n totalItems: number;\n jobs: { id: number; name: string }[];\n}\n\n/** Run a Monday GraphQL query. Never surfaces the token in any error. */\nasync function mondayGraphQL(token: string, query: string, variables: Record<string, unknown> = {}) {\n const res = await fetch(MONDAY_API, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": `Bearer ${token}`,\n \"API-Version\": MONDAY_API_VERSION,\n },\n body: JSON.stringify({ query, variables }),\n });\n if (!res.ok) {\n throw new Error(\"Unable to reach Monday.com. Check that the board access is configured.\");\n }\n const body = await res.json();\n if (body.errors && body.errors.length) {\n const msg = String(body.errors[0]?.message ?? \"Monday.com request failed\");\n if (/authentication|authorization|invalid.*token|unauthorized/i.test(msg)) {\n throw new Error(\"Monday.com authentication failed. The connection token is invalid or expired.\");\n }\n throw new Error(\"Monday.com returned an error for this request.\");\n }\n return body.data;\n}\n\n/** Accessible boards the token can read (read-only). */\nexport async function listBoards(token: string): Promise<{ id: string; name: string }[]> {\n const data = await mondayGraphQL(token, `query { boards(limit: 100) { id name } }`);\n return (data?.boards ?? []) as { id: string; name: string }[];\n}\n\n/** Discover the Utility Schedule board id by name. */\nexport async function discoverUtilityBoardId(token: string): Promise<{ boardId: string | null; name: string | null; error?: string }> {\n const explicit = Deno.env.get(\"MONDAY_BOARD_ID\");\n if (explicit && /^\\d+$/.test(explicit)) {\n return { boardId: explicit, name: null };\n }\n try {\n const boards = await listBoards(token);\n const match = boards.find((b) => UTILITY_RE.test(b.name));\n if (match) return { boardId: match.id, name: match.name };\n return { boardId: null, name: null, error: \"No Utility Schedule board was found for this account.\" };\n } catch (err) {\n return { boardId: null, name: null, error: err instanceof Error ? err.message : \"Unable to read Monday.com.\" };\n }\n}\n\n/** Fetch board groups and columns (the metadata used for validation/mapping). */\nexport async function fetchBoardMeta(token: string, boardId: string): Promise<{ meta: BoardMeta | null; error?: string }> {\n const query = `query BoardMeta($boardId: ID!) {\n boards(ids: [$boardId]) {\n id name\n groups { id title }\n columns { id title type }\n }\n }`;\n try {\n const data = await mondayGraphQL(token, query, { boardId });\n const board = data?.boards?.[0];\n if (!board) return { meta: null, error: \"The configured Monday board could not be found.\" };\n const meta: BoardMeta = {\n id: board.id,\n name: board.name,\n groups: board.groups ?? [],\n columns: board.columns ?? [],\n };\n return { meta };\n } catch (err) {\n return { meta: null, error: err instanceof Error ? err.message : \"Unable to read Monday board metadata.\" };\n }\n}\n\n/** Normalise a group title for the Completed. filter. */\nfunction normalized(title: string): string {\n return title.trim().toLowerCase().replace(/\\.+$/, \"\").trim();\n}\nconst isCompletedGroup = (title: string): boolean => normalized(title) === \"completed\";\n\n/** Map Monday columns to job fields by matching their titles. */\ntype FieldKey =\n | \"job_number\" | \"status\" | \"superintendent\" | \"project_manager\" | \"estimator\"\n | \"location\" | \"jurisdiction\" | \"general_contractor\" | \"foreman\"\n | \"prevailing_wage\" | \"permit_number\";\n\nconst RULES: [FieldKey, RegExp][] = [\n [\"job_number\", /job\\s*#|job\\s*numb|job\\s*id|jobno/i],\n [\"status\", /^\\s*status\\s*$/i],\n [\"superintendent\", /superintend/i],\n [\"project_manager\", /project\\s*manager|^project$|^pm\\b/i],\n [\"estimator\", /estimator/i],\n [\"location\", /location|site\\s*address|city/i],\n [\"jurisdiction\", /jurisdiction/i],\n [\"general_contractor\", /general\\s*contractor|^gc\\b|contractor/i],\n [\"foreman\", /foreman/i],\n [\"prevailing_wage\", /prevailing|prev\\s*wage/i],\n [\"permit_number\", /permit/i],\n];\n\nfunction buildFieldMap(columns: MondayColumn[]): Record<FieldKey, string | null> {\n const map = {} as Record<FieldKey, string | null>;\n for (const key of Object.keys(RULES) as FieldKey[]) map[key] = null;\n // Assign each column to the first matching field (longest group first).\n const used = new Set<FieldKey>();\n const ordered = [...columns].sort((a, b) => b.title.length - a.title.length);\n for (const col of ordered) {\n for (const [key, re] of RULES) {\n if (!used.has(key) && re.test(col.title)) {\n map[key] = col.id;\n used.add(key);\n break;\n }\n }\n }\n return map;\n}\n\nfunction colText(values: { column: { id: string }; text?: string | null }[], columnId: string | null): string {\n if (!columnId) return \"\";\n const v = values.find((x) => x.column?.id === columnId);\n if (!v) return \"\";\n const t = String(v.text ?? \"\").trim();\n if (t === \"{}\" || t === \"[]\" || t === \"false\") return \"\";\n return t;\n}\n\n/**\n * Import the Utility Schedule board. This is the write operation — callers\n * that only want to validate the connection should use fetchBoardMeta instead.\n */\nexport async function syncUtilitySchedule(token: string): Promise<SyncResult> {\n const empty: SyncResult = { ok: false, added: 0, updated: 0, ignoredCompleted: 0, totalItems: 0, jobs: [] };\n\n const discovered = await discoverUtilityBoardId(token);\n if (discovered.error || !discovered.boardId) {\n return { ...empty, error: discovered.error ?? \"No Utility Schedule board is configured.\" };\n }\n\n const query = `query BoardItems($boardId: ID!) {\n boards(ids: [$boardId]) {\n id name\n columns { id title }\n items_page(limit: 500) {\n cursor\n items {\n id name url\n group { id title }\n column_values { column { id } text }\n }\n }\n }\n }`;\n\n let data;\n try {\n data = await mondayGraphQL(token, query, { boardId: discovered.boardId });\n } catch (err) {\n return { ...empty, error: err instanceof Error ? err.message : \"Unable to load the Utility Schedule board.\" };\n }\n const board = data?.boards?.[0];\n const items = board?.items_page?.items ?? [];\n const columns: MondayColumn[] = board?.columns ?? [];\n const fieldMap = buildFieldMap(columns);\n\n let added = 0;\n let updated = 0;\n let ignoredCompleted = 0;\n const jobs: { id: number; name: string }[] = [];\n\n for (const item of items) {\n const groupTitle = String(item.group?.title ?? \"\").trim();\n if (isCompletedGroup(groupTitle)) {\n ignoredCompleted += 1;\n continue;\n }\n const itemId = String(item.id);\n const values = item.column_values ?? [];\n const text = (col: string | null) => colText(values, col);\n const fields: Record<string, string> = {\n name: String(item.name ?? \"\").trim() || \"Untitled Utility Job\",\n job_number: text(fieldMap.job_number),\n status: text(fieldMap.status),\n superintendent: text(fieldMap.superintendent),\n project_manager: text(fieldMap.project_manager),\n estimator: text(fieldMap.estimator),\n location: text(fieldMap.location),\n jurisdiction: text(fieldMap.jurisdiction),\n general_contractor: text(fieldMap.general_contractor),\n foreman: text(fieldMap.foreman),\n prevailing_wage: text(fieldMap.prevailing_wage),\n permit_number: text(fieldMap.permit_number),\n schedule_group: groupTitle,\n monday_url: String(item.url ?? \"\").trim(),\n };\n\n // Look for an existing synced job by its permanent Monday item id.\n const existing = await sqlite.execute(\n `SELECT id FROM jobs WHERE monday_item_id = ? AND source = 'monday'`,\n [itemId],\n );\n if (existing.rows.length > 0) {\n const jobId = Number((existing.rows[0] as { id: number }).id);\n const cols = Object.keys(fields).map((k) => `${k} = ?`).join(\", \");\n const args = Object.values(fields).concat([jobId]);\n await sqlite.execute(`UPDATE jobs SET ${cols} WHERE id = ?`, args);\n jobs.push({ id: jobId, name: fields.name });\n updated += 1;\n } else {\n // Insert a new Monday-sourced job. Never overwrites manual jobs.\n const result = await sqlite.execute(\n `INSERT INTO jobs (name, source, monday_item_id, job_number, status, superintendent,\n project_manager, estimator, location, jurisdiction, general_contractor, foreman,\n prevailing_wage, permit_number, schedule_group, monday_url)\n VALUES (?, 'monday', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n fields.name, itemId, fields.job_number, fields.status, fields.superintendent,\n fields.project_manager, fields.estimator, fields.location, fields.jurisdiction,\n fields.general_contractor, fields.foreman, fields.prevailing_wage, fields.permit_number,\n fields.schedule_group, fields.monday_url,\n ],\n );\n jobs.push({ id: Number(result.lastInsertRowid), name: fields.name });\n added += 1;\n }\n }\n\n return { ok: true, added, updated, ignoredCompleted, totalItems: items.length, jobs };\n}\n\n/** Record a refresh snapshot into monday_snapshots. */\nexport async function recordSnapshot(summary: Omit<SyncResult, \"ok\">, tokenConfigured: boolean): Promise<void> {\n await sqlite.execute(\n `INSERT INTO monday_snapshots (jobs_json) VALUES (?)`,\n [JSON.stringify({ ...summary, tokenConfigured, source: \"monday\" })],\n );\n}\n\n/** Most recent refresh info for display. */\nexport async function lastRefresh(): Promise<{ fetchedAt: string | null; summary: Record<string, unknown> | null }> {\n const rows = await sqlite.execute(`SELECT fetched_at, jobs_json FROM monday_snapshots ORDER BY id DESC LIMIT 1`);\n if (rows.rows.length === 0) return { fetchedAt: null, summary: null };\n const row = rows.rows[0] as { fetched_at: string; jobs_json: string };\n let summary: Record<string, unknown> | null = null;\n try { summary = JSON.parse(row.jobs_json); } catch { summary = null; }\n return { fetchedAt: row.fetched_at, summary };\n}\n/** Expose which board column title maps to each job field (for metadata display). */\nexport function resolveColumnMapping(columns: MondayColumn[]): Record<string, string> {\n const map = buildFieldMap(columns);\n const out: Record<string, string> = {};\n for (const key of Object.keys(map) as FieldKey[]) {\n const id = map[key];\n const col = columns.find((c) => c.id === id);\n out[key] = col ? col.title : \"\";\n }\n return out;\n}\n","children",[],[333],"0ba39e2b-78ae-4125-8280-9482a4fdad83","main.ts","c4e2e564-a7af-11f1-b820-1607ee4eb77e",["D",1788450878935],[],[342],"24eddea0-7cc7-49fa-b1b1-f282eba6dccb","index.ts",46,["D",1788494129082],4,"http","import { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport type { Context, Next } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { ready } from \"./db.ts\";\nimport {\n hashPassword,\n verifyPassword,\n createSession,\n sessionCookieHeader,\n clearCookieHeader,\n getSessionUser,\n requireAuth,\n requireAdmin,\n} from \"./auth.ts\";\nimport type { User } from \"./auth.ts\";\nimport { equipmentRates } from \"./equipmentRates.ts\";\nimport {\n discoverUtilityBoardId,\n fetchBoardMeta,\n resolveColumnMapping,\n syncUtilitySchedule,\n recordSnapshot,\n lastRefresh,\n} from \"./monday.ts\";\nimport { Root } from \"./frontend/root.tsx\";\n\nawait ready;\n\nconst app = new Hono();\n\nfunction getU(c: Context): User {\n return c.get<User>(\"user\");\n}\n\nconst authed = (c: Context, next: Next) => requireAuth(c, next);\nconst admin = (c: Context, next: Next) => requireAdmin(c, next);\n\nconst DEFAULT_RATES = { labor: 45, operator: 55, foreman: 65 };\nconst MAX_FILE_BYTES = 25 * 1024 * 1024; // 25 MB\n\nconst ALLOWED_EXT: Record<string, \"vista-target\" | \"timesheet\"> = {\n \".txt\": \"vista-target\",\n \".text\": \"vista-target\",\n \".xlsx\": \"timesheet\",\n \".xls\": \"timesheet\",\n};\n\nfunction jobSelect(fields: string[]): string {\n return fields.map((f) => `j.${f}`).join(\", \");\n}\n\n// ---- Frontend ----\napp.get(\"/\", (c) => c.html(Root()));\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// ---- Auth + bootstrap (Phase 1, unchanged) ----\napp.get(\"/api/bootstrap\", async (c) => {\n const rows = await sqlite.execute(`SELECT COUNT(*) AS n FROM users`);\n const userCount = Number((rows.rows[0] as { n: number }).n);\n if (userCount === 0) return c.json({ state: \"setup\" });\n const user = await getSessionUser(c.req.raw);\n if (user) return c.json({ state: \"authed\", user });\n return c.json({ state: \"login\" });\n});\n\napp.post(\"/api/setup\", async (c) => {\n const rows = await sqlite.execute(`SELECT COUNT(*) AS n FROM users`);\n if (Number((rows.rows[0] as { n: number }).n) > 0) {\n return c.json({ error: \"Setup already complete. Sign in instead.\" }, 400);\n }\n const body = await c.req.json().catch(() => ({}));\n const email = String(body.email ?? \"\").trim().toLowerCase();\n const password = String(body.password ?? \"\");\n if (!/^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/.test(email)) {\n return c.json({ error: \"A valid email is required.\" }, 400);\n }\n if (password.length < 8) {\n return c.json({ error: \"Password must be at least 8 characters.\" }, 400);\n }\n const { salt, hash } = await hashPassword(password);\n await sqlite.batch([\n { sql: `INSERT INTO approved_emails (email, role) VALUES (?, 'admin')`, args: [email] },\n { sql: `INSERT INTO users (email, role, password_salt, password_hash) VALUES (?, 'admin', ?, ?)`, args: [email, salt, hash] },\n ]);\n return c.json({ ok: true });\n});\n\napp.post(\"/api/login\", async (c) => {\n const body = await c.req.json().catch(() => ({}));\n const email = String(body.email ?? \"\").trim().toLowerCase();\n const password = String(body.password ?? \"\");\n const rows = await sqlite.execute(\n `SELECT id, email, role, password_salt, password_hash FROM users WHERE lower(email) = ?`,\n [email],\n );\n if (rows.rows.length === 0) return c.json({ error: \"Invalid email or password.\" }, 401);\n const row = rows.rows[0] as {\n id: number; email: string; role: string; password_salt: string | null; password_hash: string | null;\n };\n if (!row.password_salt || !row.password_hash) return c.json({ error: \"This user has no password set.\" }, 401);\n const ok = await verifyPassword(password, row.password_salt, row.password_hash);\n if (!ok) return c.json({ error: \"Invalid email or password.\" }, 401);\n const { token, expiresAt } = await createSession(Number(row.id));\n c.header(\"Set-Cookie\", sessionCookieHeader(token, expiresAt));\n return c.json({ user: { id: Number(row.id), email: row.email, role: row.role } });\n});\n\napp.post(\"/api/logout\", async (c) => {\n c.header(\"Set-Cookie\", clearCookieHeader);\n return c.json({ ok: true });\n});\n\n/**\n * Administrator password recovery.\n *\n * Security rules:\n * - The recovery code is read ONLY from the ADMIN_RECOVERY_CODE env var;\n * it is never hardcoded, displayed, or logged.\n * - Requires the existing administrator email + the recovery code + the new\n * password entered twice.\n * - The new password is hashed with the same PBKDF2 system as normal sign-in.\n * - On success, all existing sessions for that administrator are invalidated\n * so any open session must sign in again.\n */\napp.post(\"/api/recover\", async (c) => {\n const expectedCode = Deno.env.get(\"ADMIN_RECOVERY_CODE\");\n const body = await c.req.json().catch(() => ({}));\n const email = String(body.email ?? \"\").trim().toLowerCase();\n const code = String(body.code ?? \"\");\n const password = String(body.password ?? \"\");\n const confirm = String(body.confirm ?? \"\");\n\n if (!expectedCode) {\n return c.json({ error: \"Password recovery is not configured. Contact the administrator.\" }, 500);\n }\n\n // Generic failures — never reveal whether the email or the code was wrong.\n const fail = () => c.json({ error: \"Unable to reset the password. Check your email and recovery code, then try again.\" }, 401);\n\n if (!email || password.length < 8 || password !== confirm) {\n return c.json({ error: \"Enter your administrator email, a new password of at least 8 characters, and confirm it.\" }, 400);\n }\n\n // Timing-safe comparison of the recovery code.\n const a = new Uint8Array(new TextEncoder().encode(code));\n const b = new Uint8Array(new TextEncoder().encode(expectedCode));\n let diff = a.length === b.length ? 0 : 1;\n const len = Math.max(a.length, b.length);\n for (let i = 0; i < len; i++) {\n const av = i < a.length ? a[i] : 0;\n const bv = i < b.length ? b[i] : 0;\n diff |= av ^ bv;\n }\n if (diff !== 0) return fail();\n\n const rows = await sqlite.execute(\n `SELECT id FROM users WHERE lower(email) = ? AND role = 'admin'`,\n [email],\n );\n if (rows.rows.length === 0) return fail();\n const userId = Number((rows.rows[0] as { id: number }).id);\n\n const { salt, hash } = await hashPassword(password);\n await sqlite.batch([\n {\n sql: `UPDATE users SET password_salt = ?, password_hash = ? WHERE id = ?`,\n args: [salt, hash, userId],\n },\n // Invalidate every session for this administrator.\n { sql: `DELETE FROM sessions WHERE user_id = ?`, args: [userId] },\n ]);\n\n return c.json({ ok: true });\n});\n\n// ---- Jobs CRUD ----\n\nasync function getJobRow(id: number) {\n const rows = await sqlite.execute(\n `SELECT id, name, source, job_number, status, superintendent, project_manager,\n estimator, location, jurisdiction, general_contractor, foreman,\n prevailing_wage, permit_number, schedule_group, monday_url\n FROM jobs WHERE id = ?`,\n [id],\n );\n return rows.rows[0] ?? null;\n}\n\napp.get(\"/api/jobs\", authed, async (c) => {\n const rows = await sqlite.execute(\n `SELECT id, name, source, job_number, status, superintendent, project_manager,\n estimator, location, jurisdiction, general_contractor, foreman,\n prevailing_wage, permit_number, schedule_group, monday_url, created_at\n FROM jobs ORDER BY name`,\n );\n return c.json({ jobs: rows.rows });\n});\n\napp.post(\"/api/jobs\", authed, admin, async (c) => {\n const body = await c.req.json().catch(() => ({}));\n const name = String(body.name ?? \"\").trim();\n if (!name) return c.json({ error: \"Job name is required.\" }, 400);\n const me = getU(c);\n const result = await sqlite.execute(\n `INSERT INTO jobs (name, source, created_by) VALUES (?, 'manual', ?)`,\n [name, me.id],\n );\n const id = Number(result.lastInsertRowid);\n await sqlite.execute(\n `INSERT OR IGNORE INTO job_labor_rates (job_id, labor, operator, foreman, updated_at)\n VALUES (?, ?, ?, ?, datetime('now'))`,\n [id, DEFAULT_RATES.labor, DEFAULT_RATES.operator, DEFAULT_RATES.foreman],\n );\n const row = await getJobRow(id);\n return c.json({ job: row }, 201);\n});\n\napp.put(\"/api/jobs/:id\", authed, admin, async (c) => {\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.json().catch(() => ({}));\n const allowed = [\"name\", \"job_number\", \"status\", \"superintendent\", \"project_manager\", \"estimator\",\n \"location\", \"jurisdiction\", \"general_contractor\", \"foreman\", \"prevailing_wage\", \"permit_number\",\n \"schedule_group\", \"monday_url\"];\n for (const key of allowed) {\n if (body[key] !== undefined) {\n await sqlite.execute(`UPDATE jobs SET ${key} = ? WHERE id = ?`, [String(body[key]), id]);\n }\n }\n const row = await getJobRow(id);\n if (!row) return c.json({ error: \"Job not found.\" }, 404);\n return c.json({ job: row });\n});\n\napp.delete(\"/api/jobs/:id\", authed, admin, async (c) => {\n const id = Number(c.req.param(\"id\"));\n // Delete blobs first, then the cascading rows.\n const files = await sqlite.execute(`SELECT blob_key FROM job_files WHERE job_id = ?`, [id]);\n for (const f of files.rows) {\n try { await blob.delete(f.blob_key as string); } catch { /* ignore */ }\n }\n await sqlite.execute(`DELETE FROM job_files WHERE job_id = ?`, [id]);\n await sqlite.execute(`DELETE FROM jobs WHERE id = ?`, [id]);\n return c.json({ ok: true });\n});\n\n// ---- Per-job labor rates ----\n\napp.get(\"/api/jobs/:id/rates\", authed, async (c) => {\n const id = Number(c.req.param(\"id\"));\n const rows = await sqlite.execute(\n `SELECT labor, operator, foreman FROM job_labor_rates WHERE job_id = ?`,\n [id],\n );\n if (rows.rows.length === 0) return c.json({ rates: { ...DEFAULT_RATES }, isDefault: true });\n return c.json({ rates: rows.rows[0], isDefault: false });\n});\n\napp.put(\"/api/jobs/:id/rates\", authed, async (c) => {\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.json().catch(() => ({}));\n const labor = Number(body.labor ?? DEFAULT_RATES.labor);\n const operator = Number(body.operator ?? DEFAULT_RATES.operator);\n const foreman = Number(body.foreman ?? DEFAULT_RATES.foreman);\n await sqlite.execute(\n `INSERT INTO job_labor_rates (job_id, labor, operator, foreman, updated_at)\n VALUES (?, ?, ?, ?, datetime('now'))\n ON CONFLICT(job_id) DO UPDATE SET labor = excluded.labor, operator = excluded.operator,\n foreman = excluded.foreman, updated_at = datetime('now')`,\n [id, labor, operator, foreman],\n );\n return c.json({ rates: { labor, operator, foreman }, isDefault: false });\n});\n\n// ---- Job data (autosave) ----\n\nconst emptyJobData = {\n entries: [],\n production: {},\n actualRows: [],\n equipmentUsage: [],\n crewDays: [],\n phaseUsage: [],\n equipmentMoves: [],\n forecast: { budget: \"\", completion: \"\" },\n};\n\napp.get(\"/api/jobs/:id/data\", authed, async (c) => {\n const id = Number(c.req.param(\"id\"));\n const rows = await sqlite.execute(`SELECT data FROM job_data WHERE job_id = ?`, [id]);\n if (rows.rows.length === 0) return c.json({ data: emptyJobData });\n try {\n return c.json({ data: JSON.parse(rows.rows[0].data as string) });\n } catch {\n return c.json({ data: emptyJobData });\n }\n});\n\napp.put(\"/api/jobs/:id/data\", authed, async (c) => {\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.json().catch(() => ({}));\n const data = body.data ?? {};\n await sqlite.execute(\n `INSERT INTO job_data (job_id, data, updated_at) VALUES (?, ?, datetime('now'))\n ON CONFLICT(job_id) DO UPDATE SET data = excluded.data, updated_at = datetime('now')`,\n [id, JSON.stringify(data)],\n );\n return c.json({ ok: true });\n});\n\n// ---- File uploads (Vista target TXT / BusyBusy Excel) ----\n\nasync function storeFileParts(formData: FormData, jobId: number, user: User) {\n const saved: { filename: string; kind: string; size: number }[] = [];\n const errors: string[] = [];\n\n for (const [key, value] of formData.entries()) {\n if (!(value instanceof File)) continue;\n const file = value as File;\n const name = file.name ?? key;\n const ext = name.slice(name.lastIndexOf(\".\")).toLowerCase();\n const kind = ALLOWED_EXT[ext];\n if (!kind) {\n errors.push(`\"${name}\" is not an accepted file type. Use .txt for Vista targets or .xlsx/.xls for BusyBusy time sheets.`);\n continue;\n }\n if (file.size > MAX_FILE_BYTES) {\n errors.push(`\"${name}\" exceeds the 25 MB upload limit.`);\n continue;\n }\n const nonce = `${Date.now()}-${Math.random().toString(36).slice(2, 8)}`;\n const blobKey = `jobs/${jobId}/${kind}/${nonce}-${name}`;\n const bytes = new Uint8Array(await file.arrayBuffer());\n await blob.set(blobKey, bytes);\n await sqlite.execute(\n `INSERT INTO job_files (job_id, kind, filename, content_type, size, blob_key, uploaded_by, uploaded_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, datetime('now'))`,\n [jobId, kind, name, file.type || \"application/octet-stream\", file.size, blobKey, user.id],\n );\n saved.push({ filename: name, kind, size: file.size });\n }\n return { saved, errors };\n}\n\napp.post(\"/api/jobs/:id/files\", authed, async (c) => {\n const jobId = Number(c.req.param(\"id\"));\n const me = getU(c);\n const formData = await c.req.formData().catch(() => null);\n if (!formData) return c.json({ error: \"Invalid upload.\" }, 400);\n const { saved, errors } = await storeFileParts(formData, jobId, me);\n if (saved.length === 0) {\n return c.json({ error: errors.join(\" \") || \"No files uploaded.\" }, 400);\n }\n return c.json({ ok: true, saved, warnings: errors });\n});\n\napp.get(\"/api/jobs/:id/files\", authed, async (c) => {\n const id = Number(c.req.param(\"id\"));\n const rows = await sqlite.execute(\n `SELECT id, kind, filename, content_type, size, uploaded_at FROM job_files WHERE job_id = ? ORDER BY uploaded_at DESC`,\n [id],\n );\n return c.json({ files: rows.rows });\n});\n\n// ---- Equipment rates ----\napp.get(\"/api/equipment-rates\", authed, async (c) => {\n return c.json({ rates: equipmentRates, count: equipmentRates.length });\n});\n\n// ---- Monday.com (Utility Schedule) ----\nfunction mondayToken(): string | null {\n return Deno.env.get(\"MONDAY_TOKEN\") || null;\n}\n\n/** Connection status. Performs a lightweight, read-only check against Monday. */\napp.get(\"/api/monday-connection\", authed, async (c) => {\n const token = mondayToken();\n const last = await lastRefresh();\n if (!token) {\n return c.json({\n connected: false,\n configured: false,\n message: \"Monday.com not configured\",\n lastRefresh: last,\n });\n }\n const found = await discoverUtilityBoardId(token);\n if (found.error || !found.boardId) {\n // Safe, generic — never reveals credentials.\n return c.json({ connected: false, configured: true, message: found.error ?? \"No Utility Schedule board found\", lastRefresh: last });\n }\n return c.json({\n connected: true,\n configured: true,\n boardId: found.boardId,\n boardName: found.name ?? \"Utility Schedule\",\n message: `Connected · Utility Schedule board ${found.boardId}`,\n lastRefresh: last,\n });\n});\n\n/** Read-only board metadata (board id, name, groups, columns, field mapping). */\napp.get(\"/api/monday-board\", authed, async (c) => {\n const token = mondayToken();\n if (!token) return c.json({ error: \"Monday.com is not configured.\" }, 400);\n const found = await discoverUtilityBoardId(token);\n if (found.error || !found.boardId) {\n return c.json({ error: found.error ?? \"No Utility Schedule board found.\" }, 400);\n }\n const { meta, error } = await fetchBoardMeta(token, found.boardId);\n if (error || !meta) {\n return c.json({ error: error ?? \"Unable to read board metadata.\" }, 400);\n }\n return c.json({\n boardId: meta.id,\n boardName: meta.name,\n groups: meta.groups,\n columns: meta.columns,\n mapping: resolveColumnMapping(meta.columns),\n });\n});\n\n/** Functional Refresh: run the Utility Schedule import and store a snapshot. */\napp.post(\"/api/monday-refresh\", authed, admin, async (c) => {\n const token = mondayToken();\n if (!token) {\n return c.json({ ok: false, error: \"Monday.com is not configured. Add MONDAY_TOKEN first.\" }, 400);\n }\n const result = await syncUtilitySchedule(token);\n const summary = {\n error: result.error ?? null,\n added: result.added,\n updated: result.updated,\n ignoredCompleted: result.ignoredCompleted,\n totalItems: result.totalItems,\n jobs: result.jobs,\n };\n await recordSnapshot(summary, true);\n if (!result.ok) {\n return c.json({ ok: false, error: result.error ?? \"Unable to refresh Monday.com\" }, 400);\n }\n return c.json({ ok: true, ...summary, lastRefresh: new Date().toISOString() });\n});\n\n// ---- Migration status ----\napp.get(\"/api/migration-status\", authed, async (c) => {\n const users = (await sqlite.execute(`SELECT COUNT(*) AS n FROM users`)).rows[0] as { n: number };\n const jobs = (await sqlite.execute(`SELECT COUNT(*) AS n FROM jobs`)).rows[0] as { n: number };\n const mondayToken = Deno.env.get(\"MONDAY_TOKEN\");\n const last = await lastRefresh();\n return c.json({\n users: Number(users.n),\n jobs: Number(jobs.n),\n mondayTokenConfigured: Boolean(mondayToken),\n mondayConnected: Boolean(mondayToken) && Boolean(last.summary),\n lastRefresh: last,\n });\n});\n\n// Admin: manage approved users.\napp.get(\"/api/admin/users\", authed, admin, async (c) => {\n const approved = await sqlite.execute(\n `SELECT id, email, role, created_at FROM approved_emails ORDER BY email`,\n );\n return c.json({ approved: approved.rows });\n});\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","ndx-command-center",[],[348],"e0a3d028-1a1e-42fb-930b-28f93ae6d0ca","equipmentRates.ts","b7729c34-a7d3-11f1-8201-1607ee4eb77e",["D",1788466317861],"export type EquipmentRate = { label: string; rate: number };\n\n/**\n * Hourly operating rates imported from Rates by Equipment.pdf (08/14/26).\n *\n * NOTE: The migration source captured most of this list but was truncated at\n * entry \"5103\". The remaining plate-compactor / small-tool entries should be\n * reconciled from the original PDF before production use. This staging copy\n * carries the entries present in the source.\n */\nexport const equipmentRates: EquipmentRate[] = [\n { label: \"001 2013 Ram Truck 3500 ST\", rate: 100.00 },\n { label: \"002 2014 A Double Cab SR/SRS\", rate: 100.00 },\n { label: \"003 2003 F250 Super Duty\", rate: 100.00 },\n { label: \"004 2016 Ram 2500 Laramie\", rate: 100.00 },\n { label: \"005 2017 Ram 3500 Laramie\", rate: 100.00 },\n { label: \"006 2008 F250 Super Duty\", rate: 100.00 },\n { label: \"007 2021 Ram 3500 Laramie\", rate: 100.00 },\n { label: \"008 2015 F350 Super Duty\", rate: 100.00 },\n { label: \"009 2022 F150 Supercrew\", rate: 100.00 },\n { label: \"010 2022 F150 Supercrew\", rate: 100.00 },\n { label: \"011 2022 F350 Super Duty\", rate: 100.00 },\n { label: \"012 2019 Silverado C2500 Heavy Duty\", rate: 100.00 },\n { label: \"013 2013 Silverado C3500\", rate: 100.00 },\n { label: \"014 2015 F450 Super Duty\", rate: 100.00 },\n { label: \"015 2016 F350 Super Duty\", rate: 100.00 },\n { label: \"016 2015 F450 Super Duty\", rate: 100.00 },\n { label: \"018 2021 F350 Super Duty\", rate: 100.00 },\n { label: \"019 2021 F350 Super Duty\", rate: 100.00 },\n { label: \"020 2011 Ram 2500\", rate: 100.00 },\n { label: \"021 2022 F450 Super Duty\", rate: 100.00 },\n { label: \"022 2023 F150 Supercrew\", rate: 100.00 },\n { label: \"023 2023 F150 Supercrew\", rate: 100.00 },\n { label: \"024 2023 F150 Supercrew\", rate: 100.00 },\n { label: \"025 2022 F350 Super Duty\", rate: 100.00 },\n { label: \"026 2023 F150 Supercrew\", rate: 100.00 },\n { label: \"027 2025 F-150 STX\", rate: 100.00 },\n { label: \"028 2026 F-150 Crew Cab\", rate: 100.00 },\n { label: \"029 2026 Ford F150\", rate: 100.00 },\n { label: \"203 Case 580N Backhoe\", rate: 70.03 },\n { label: \"204 Case 580SN T4 Backhoe\", rate: 70.03 },\n { label: \"205 Case 580 SN T4 Backhoe\", rate: 70.03 },\n { label: \"206 Case 580SN T4B Backhoe\", rate: 70.03 },\n { label: \"207 JD 320 P-Tier Backhoe\", rate: 70.03 },\n { label: \"208 Case 570N-EP Backhoe\", rate: 70.03 },\n { label: \"301 CAT 322 BL Trackhoe W/ Hammer\", rate: 103.49 },\n { label: \"303 Case CX36B Excavator\", rate: 44.57 },\n { label: \"305 KOM PC 78US-8 Mini Excavator\", rate: 57.89 },\n { label: \"306 KOM PC210LC-11 Excavator\", rate: 103.49 },\n { label: \"307 CAT 303.5 E2 Mini Ex\", rate: 44.57 },\n { label: \"308 CAT 308-07 T Midi Excavator\", rate: 57.89 },\n { label: \"309 CAT 320-07 Excavator\", rate: 103.49 },\n { label: \"310 CAT 308-07 Mini Excavator\", rate: 57.89 },\n { label: \"311 CAT 303.5-07 Mini Excavator\", rate: 44.57 },\n { label: \"312 CAT 308-07 Midi Ex\", rate: 57.89 },\n { label: \"313 CAT 303.5-07 Mini Ex\", rate: 44.57 },\n { label: \"314 CAT 349FL Excavator\", rate: 210.00 },\n { label: \"315 CAT320GC Excavator\", rate: 103.49 },\n { label: \"316 KOM PC78US-11 Excavator\", rate: 57.89 },\n { label: \"317 CAT 303.5-07OR Mini Ex\", rate: 44.57 },\n { label: \"318 CAT 308-07CR Midi Excavator\", rate: 57.89 },\n { label: \"4001 2022 Peterbilt 579 Water Truck\", rate: 48.67 },\n { label: \"4002 2022 Peterbilt 579 Water Truck\", rate: 48.67 },\n { label: \"4003 2021 Peterbilt 579 Water Truck\", rate: 48.67 },\n { label: \"4005 2021 Peterbilt 579 4x2 Water Truck\", rate: 48.67 },\n { label: \"4006 2012 Kenworth T370 Water Truck\", rate: 61.48 },\n { label: \"4007 2012 Kenworth T370 Water Truck\", rate: 61.48 },\n { label: \"4008 1999 Sterling Water Truck\", rate: 48.67 },\n { label: \"4009 2006 Peterbilt 378 Convention Water Truck\", rate: 61.48 },\n { label: \"4010 1997 Water Truck (2000G)\", rate: 48.67 },\n { label: \"4011 2004 Water Pull 615 (6000G)\", rate: 157.80 },\n { label: \"4012 2019 Freightliner Water Truck (2000G)\", rate: 61.48 },\n { label: \"4013 2023 Freightliner Water Truck (2000G)\", rate: 48.67 },\n { label: \"4014 2023 Water Wagon 613CII\", rate: 157.80 },\n { label: \"4015 1993 International Water Truck\", rate: 61.48 },\n { label: \"4016 1992 Peterbilt Water Truck\", rate: 61.48 },\n { label: \"4017 1996 Peterbilt Water Truck\", rate: 61.48 },\n { label: \"4018 1998 Water Truck\", rate: 48.67 },\n { label: \"402 CAT 966F Loader\", rate: 172.14 },\n { label: \"404 CAT 938K Loader\", rate: 85.05 },\n { label: \"405 KOM WA320 Loader\", rate: 85.05 },\n { label: \"406 KOM WA380 Loader\", rate: 123.98 },\n { label: \"407 CAT 950M Loader\", rate: 123.98 },\n { label: \"408 CAT 950M Loader (New)\", rate: 123.98 },\n { label: \"409 CAT 950M Loader\", rate: 123.98 },\n { label: \"410 CAT 950M Loader\", rate: 123.98 },\n { label: \"4100 2021 Peterbilt 337 Fuel Truck\", rate: 0.00 },\n { label: \"4101 2026 Peterbilt 537 Fuel Truck\", rate: 0.00 },\n { label: \"4102 2021 Peterbilt 348 8x4 Dump Truck\", rate: 157.99 },\n { label: \"4103 1995 International Dump Truck\", rate: 157.99 },\n { label: \"4104 2022 Peterbilt 579 Dump Truck\", rate: 157.99 },\n { label: \"4105 2021 Peterbilt 579 4x2 Dump Truck\", rate: 157.99 },\n { label: \"4106 Peterbilt 389\", rate: 157.99 },\n { label: \"4107 International ProStar 6x4 Day Cab Truck\", rate: 157.99 },\n { label: \"4108 Peterbilt 378 Convention\", rate: 157.99 },\n { label: \"411 KOM WA320-8 Loader\", rate: 85.05 },\n { label: \"412 CAT 950-14 Loader\", rate: 123.98 },\n { label: \"413 JD 644 P-Tier Loader\", rate: 123.98 },\n { label: \"414 CAT 950M Loader\", rate: 123.98 },\n { label: \"504 Case SR175 Skidsteer\", rate: 44.57 },\n { label: \"507 Case SR210 Skidsteer (New)\", rate: 44.57 },\n { label: \"508 Case SR210B T4 Skidsteer\", rate: 44.57 },\n { label: \"509 Case SR210B T4 Skidsteer\", rate: 44.57 },\n { label: \"510 Case SR210B T4 Skidsteer\", rate: 44.57 },\n { label: \"5100 Plate Compactors\", rate: 0.00 },\n { label: \"5101 Multiquip Plate Wacker\", rate: 0.00 },\n { label: \"5102 Sakai Wacker Rammer\", rate: 0.00 },\n // The source file truncated here. The remaining entries (from ~5103 onward,\n // small tools / saws / trailers / generators) should be re-imported from\n // \"Rates by Equipment.pdf\" before production use.\n];\n",[],[358],"4279df9a-abcc-4886-b6df-1fa7c331db23","db.ts","9d68b710-a7d3-11f1-bea0-1607ee4eb77e",39,["D",1788493995081],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n/**\n * Database migrations for the Production Command Center.\n *\n * The migration has its own DB tables for users, sessions, approved emails,\n * jobs, job labor rates, job data, Monday snapshots, and uploaded-file metadata.\n * All statements use CREATE TABLE IF NOT EXISTS / ALTER guard so the setup is\n * idempotent across restarts.\n */\n\nconst migrations: { name: string; sql: string[] }[] = [\n {\n name: \"0001_initial_auth_and_jobs\",\n sql: [\n `CREATE TABLE IF NOT EXISTS users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT NOT NULL UNIQUE,\n role TEXT NOT NULL DEFAULT 'user' CHECK (role IN ('admin','user')),\n password_salt TEXT,\n password_hash TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS sessions (\n id TEXT PRIMARY KEY,\n user_id INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE,\n token_hash TEXT NOT NULL UNIQUE,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n expires_at TEXT NOT NULL\n )`,\n `CREATE INDEX IF NOT EXISTS idx_sessions_user ON sessions(user_id)`,\n `CREATE TABLE IF NOT EXISTS approved_emails (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT NOT NULL UNIQUE,\n role TEXT NOT NULL DEFAULT 'user' CHECK (role IN ('admin','user')),\n created_by INTEGER REFERENCES users(id),\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS jobs (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n source TEXT,\n job_number TEXT,\n status TEXT,\n superintendent TEXT,\n project_manager TEXT,\n estimator TEXT,\n location TEXT,\n jurisdiction TEXT,\n general_contractor TEXT,\n foreman TEXT,\n prevailing_wage TEXT,\n permit_number TEXT,\n schedule_group TEXT,\n monday_url TEXT,\n created_by INTEGER REFERENCES users(id),\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS job_labor_rates (\n job_id INTEGER PRIMARY KEY REFERENCES jobs(id) ON DELETE CASCADE,\n labor REAL,\n operator REAL,\n foreman REAL,\n updated_at TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS job_data (\n job_id INTEGER PRIMARY KEY REFERENCES jobs(id) ON DELETE CASCADE,\n data TEXT,\n updated_at TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS monday_snapshots (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n fetched_at TEXT NOT NULL DEFAULT (datetime('now')),\n jobs_json TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS job_files (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n job_id INTEGER REFERENCES jobs(id) ON DELETE CASCADE,\n kind TEXT NOT NULL,\n filename TEXT NOT NULL,\n content_type TEXT,\n size INTEGER,\n blob_key TEXT NOT NULL,\n uploaded_by INTEGER REFERENCES users(id),\n uploaded_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS settings (\n key TEXT PRIMARY KEY,\n value TEXT\n )`,\n ],\n },\n {\n name: \"0002_jobs_created_by\",\n sql: [\n // 0001 ran before created_by was added to the jobs CREATE TABLE, so add it\n // via ALTER TABLE now. Idempotent across restarts via try/catch.\n `ALTER TABLE jobs ADD COLUMN created_by INTEGER REFERENCES users(id)`,\n ],\n },\n {\n name: \"0003_jobs_monday_item_id\",\n sql: [\n // Permanent Monday item id used to upsert synced Utility Schedule jobs\n // so refreshes update existing jobs instead of duplicating. Manual jobs\n // keep this NULL and are never matched.\n `ALTER TABLE jobs ADD COLUMN monday_item_id TEXT`,\n `CREATE UNIQUE INDEX IF NOT EXISTS idx_jobs_monday_item_id ON jobs(monday_item_id) WHERE monday_item_id IS NOT NULL`,\n ],\n },\n];\n\nconst applied = new Set<string>();\n\nexport async function migrate(): Promise<void> {\n // Track applied migrations.\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS _migrations (\n name TEXT PRIMARY KEY,\n applied_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n );\n\n for (const migration of migrations) {\n const row = await sqlite.execute(\n `SELECT name FROM _migrations WHERE name = ?`,\n [migration.name],\n );\n if (row.rows.length > 0) {\n applied.add(migration.name);\n continue;\n }\n await sqlite.batch(\n migration.sql.map((sql) => ({ sql })),\n );\n await sqlite.execute(\n `INSERT INTO _migrations (name) VALUES (?)`,\n [migration.name],\n );\n applied.add(migration.name);\n }\n}\n\n/** Runs migrations once at import time (idempotent). */\nexport const ready = migrate();\n",[],[365],"345b0511-440e-4372-8675-5a014e9ef1c1","auth.ts","ace8cfc2-a7d3-11f1-8230-1607ee4eb77e",["D",1788466300593],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport type { Context, Next } from \"npm:hono\";\n\nexport interface User {\n id: number;\n email: string;\n role: \"admin\" | \"user\";\n}\n\nexport const SESSION_COOKIE = \"pcc_session\";\nconst SESSION_DAYS = 30;\n\nconst encoder = new TextEncoder();\n\nfunction bufToHex(buf: ArrayBuffer): string {\n return [...new Uint8Array(buf)].map((b) => b.toString(16).padStart(2, \"0\")).join(\"\");\n}\n\nfunction hexToBuf(hex: string): Uint8Array {\n const out = new Uint8Array(hex.length / 2);\n for (let i = 0; i < out.length; i++) out[i] = parseInt(hex.slice(i * 2, i * 2 + 2), 16);\n return out;\n}\n\nasync function randomHex(bytes: number): Promise<string> {\n const buf = crypto.getRandomValues(new Uint8Array(bytes));\n return bufToHex(buf.buffer);\n}\n\n/** PBKDF2-SHA256 password hashing with a per-user random salt. */\nexport async function hashPassword(password: string): Promise<{ salt: string; hash: string }> {\n const salt = await randomHex(16);\n const keyMaterial = await crypto.subtle.importKey(\n \"raw\",\n encoder.encode(password),\n \"PBKDF2\",\n false,\n [\"deriveBits\"],\n );\n const bits = await crypto.subtle.deriveBits(\n { name: \"PBKDF2\", salt: hexToBuf(salt), iterations: 120_000, hash: \"SHA-256\" },\n keyMaterial,\n 256,\n );\n return { salt, hash: bufToHex(bits) };\n}\n\nexport async function verifyPassword(password: string, salt: string, hash: string): Promise<boolean> {\n try {\n const keyMaterial = await crypto.subtle.importKey(\n \"raw\",\n encoder.encode(password),\n \"PBKDF2\",\n false,\n [\"deriveBits\"],\n );\n const bits = await crypto.subtle.deriveBits(\n { name: \"PBKDF2\", salt: hexToBuf(salt), iterations: 120_000, hash: \"SHA-256\" },\n keyMaterial,\n 256,\n );\n return bufToHex(bits) === hash;\n } catch {\n return false;\n }\n}\n\n/** Create a session for a user; returns the raw token to set as the cookie. */\nexport async function createSession(userId: number): Promise<{ token: string; expiresAt: string }> {\n const id = await randomHex(16);\n const token = await randomHex(32);\n const tokenHash = bufToHex((await crypto.subtle.digest(\"SHA-256\", encoder.encode(token))).buffer);\n const expiresAt = new Date(Date.now() + SESSION_DAYS * 24 * 60 * 60 * 1000).toISOString();\n await sqlite.execute(\n `INSERT INTO sessions (id, user_id, token_hash, expires_at) VALUES (?, ?, ?, ?)`,\n [id, userId, tokenHash, expiresAt],\n );\n return { token, expiresAt };\n}\n\nexport function sessionCookieHeader(token: string, expiresAt: string): string {\n return `${SESSION_COOKIE}=${token}; HttpOnly; Secure; SameSite=Lax; Path=/; Expires=${new Date(expiresAt).toUTCString()}`;\n}\n\nexport const clearCookieHeader = `${SESSION_COOKIE}=; HttpOnly; Secure; SameSite=Lax; Path=/; Max-Age=0`;\n\n/** Resolve the current user from the request's cookie, or null. */\nexport async function getSessionUser(req: Request): Promise<User | null> {\n const cookie = req.headers.get(\"cookie\") ?? \"\";\n const match = cookie.split(\";\").map((s) => s.trim()).find((c) => c.startsWith(`${SESSION_COOKIE}=`));\n if (!match) return null;\n const token = match.slice(SESSION_COOKIE.length + 1);\n if (!token) return null;\n const tokenHash = bufToHex((await crypto.subtle.digest(\"SHA-256\", encoder.encode(token))).buffer);\n const rows = await sqlite.execute(\n `SELECT s.expires_at AS exp, u.id AS id, u.email AS email, u.role AS role\n FROM sessions s JOIN users u ON u.id = s.user_id\n WHERE s.token_hash = ?`,\n [tokenHash],\n );\n if (rows.rows.length === 0) return null;\n const row = rows.rows[0] as { exp: string; id: number; email: string; role: string };\n if (new Date(row.exp).getTime() < Date.now()) return null;\n return { id: Number(row.id), email: row.email, role: row.role as \"admin\" | \"user\" };\n}\n\n/** Hono middleware: require a logged-in user, else 401 JSON (for /api/*). */\nexport async function requireAuth(c: Context, next: Next) {\n const user = await getSessionUser(c.req.raw);\n if (!user) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n c.set(\"user\", user);\n await next();\n}\n\n/** Hono middleware: require admin role. */\nexport async function requireAdmin(c: Context, next: Next) {\n const user = c.get<User>(\"user\");\n if (!user || user.role !== \"admin\") {\n return c.json({ error: \"Forbidden\" }, 403);\n }\n await next();\n}\n",[],[373],"4f82b0d8-071a-4e4d-8656-17781af9fd82","README.md","27d70b36-a7d4-11f1-942c-1607ee4eb77e",57,["D",1788494272823],"# Production Command Center — Val Town migration\n\nA Val Town-native rebuild of the NDX Production Command Center. Cloudflare\nNext.js/Vinext has been replaced with **Hono** (routes) + a client-side **React**\nfrontend. **Cloudflare D1** → this val's scoped SQLite. **Cloudflare R2** → this\nval's scoped Blob Storage.\n\n> **Phase status: Phase 2 — non-Monday dashboard features complete.**\n> Auth, roles, the full dashboard (jobs, rates, Vista/BusyBusy imports, cost\n> consolidation, equipment/crew/phase views, equipment moves, reports), and\n> permanent job storage are implemented and tested. Monday.com remains\n> disconnected. No production job data is loaded.\n\n## Try it\n\n- [Launch the app](url:index.ts)\n- [View source](url:/source)\n- [Add `MONDAY_TOKEN`](https://www.val.town/x/wnewton/production-command-center/environment-variables?key=MONDAY_TOKEN)\n\nSign in with the existing administrator account. Every dashboard page and data\nAPI requires authentication.\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|GET /| Hono[\"index.ts (Hono server)\"]\n Hono -->|serves| Root[\"frontend/root.tsx (HTML shell)\"]\n Root -->|loads| Entry[\"frontend/index.tsx\"]\n Entry -->|renders| App[\"frontend/App.tsx (auth + dashboard)\"]\n App -->|\"fetch /api/*\"| Hono\n Hono -->|SQLite| DB[\"project-scoped SQLite (std/sqlite/main.ts)\"]\n Hono -->|Blob| Blob[\"scoped Blob Storage (original uploads)\"]\n Hono -->|secrets| Env[\"Deno.env MONDAY_TOKEN (server-only)\"]\n```\n\n## Files\n\n```\nindex.ts ← Hono HTTP entrypoint (auth + jobs + data + files + rates)\ndb.ts ← SQLite migrations (users, sessions, jobs, rates, data, Monday, files)\nauth.ts ← PBKDF2 hashing, HTTP-only session cookies, role middleware\nequipmentRates.ts ← Equipment rate book (source of hourly operating rates)\nfrontend/\n root.tsx ← HTML shell (stamps immutable asset URLs)\n index.tsx ← React entrypoint\n App.tsx ← Auth + jobs, rates, imports, cost/equipment/report views\n styles.css ← NDX black/white/red interface\n```\n\n## Auth model\n\n- **Email + password** login (PBKDF2-SHA256 hashed, per-user salt).\n- **HTTP-only, Secure, SameSite=Lax** session cookie (`pcc_session`), token hashed in DB, 30-day expiry.\n- **Approved-email allowlist** (`approved_emails`) with `admin` / `user` roles. Admins manage jobs; both may view/enter data.\n- Every data API requires auth (`requireAuth`); job create/edit/delete also requires `requireAdmin`.\n\n## Administrator password recovery\n\nA \"Forgot password?\" link on the sign-in screen opens a recovery form. To reset an\nadministrator password you need the administrator email, the recovery code, and a\nnew password entered twice.\n\n- The recovery code is read **only** from the `ADMIN_RECOVERY_CODE` environment\n variable — it is never hardcoded, displayed, or logged.\n- The new password is hashed with the same PBKDF2 system used for sign-in.\n- On success all of that administrator's sessions are invalidated (signed out).\n- The email + code combination is validated with a timing-safe comparison and\n failures return a generic message (no user-enumeration).\n- No default password or hardcoded secret is used.\n\n👉 Add `ADMIN_RECOVERY_CODE` here: https://www.val.town/x/wnewton/production-command-center/environment-variables?key=ADMIN_RECOVERY_CODE\n\n## Phase 2 — implemented & tested\n\n- **Jobs** — create, select (top bar), edit, delete (cascades data, rates, files, blobs).\n- **Per-job labor / operator / foreman rates** — saved per job with standard defaults.\n- **Vista TXT target import** — browser-side CSV parsing, targets stored in the job's production map, original saved to Blob.\n- **BusyBusy Excel import** — SheetJS in the browser; actual costs per cost code, equipment usage, crew size, phase-code breakdown, equipment moves. Original saved to Blob.\n- **Cost-code consolidation** — first-4-digit grouping (1201.2 + 1201.3 → 1201), toggle in the cost-code table.\n- **Equipment usage / crew size / phase-code views** — most-used equipment, crew-by-workday, expandable per-phase detail.\n- **Equipment moves (phase 1101)** — equipment moved, move hours, driver labor cost, hauling truck cost, total; no charge for the transported machine.\n- **Manual production + cost per unit** — enter quantities per cost code; actual vs. Vista target unit cost.\n- **Reports + print/PDF** — executive report cover, top cost codes, print stylesheet.\n- **Permanent storage** — job data in SQLite, original uploads in Blob Storage keyed by job.\n\n**Monday.com: disconnected.** The Utility Schedule import is deferred to Phase 3.\n\n## Monday.com (Utility Schedule)\n\n- Server-side integration in `monday.ts` using `Deno.env.get(\"MONDAY_TOKEN\")`. The\n token is **never** returned, logged, or sent to the browser.\n- **Board discovery** by name (or `MONDAY_BOARD_ID` env), **column mapping** from\n the board's own metadata, imports only Utility Schedule items, and **ignores\n every item in a group whose normalized name is \"Completed\" / \"Completed.\"**.\n- Each synced job stores a **permanent `monday_item_id`** (migration `0003`,\n unique index), so refreshes **update** existing jobs instead of duplicating.\n Manually created jobs are never touched.\n- The **Refresh** button is functional (admin only): `POST /api/monday-refresh`\n imports, writes a snapshot to `monday_snapshots`, and returns\n added / updated / completed-ignored / last-refresh. Errors are generic and\n never reveal credentials.\n- Status is surfaced in the monday strip and the Migration checklist.\n\n**Status:** the connection/error path is verified reachable and safe. The\ncurrently configured `MONDAY_TOKEN` is rejected by Monday (HTTP 401 — invalid or\nexpired), so **no jobs have been imported yet**. To complete the live sync,\nreplace the token with a valid Monday personal API token and click **Refresh**.\n\n## Remaining\n\n- Replace `MONDAY_TOKEN` with a **valid** token, then click **Refresh** to import\n the Utility Schedule (the write/import path is implemented but not yet\n executed against live data).\n- Optionally re-import the tail of the equipment-rate PDF (the migration source\n was truncated at entry `5103`, so `equipmentRates.ts` carries 96 records; some\n small-tool entries may be missing).\n\n## Secrets\n\nThe val injects its own API token; no `valtown` env var is needed. The credentials\nused are `MONDAY_TOKEN` (server-only) and `ADMIN_RECOVERY_CODE`.\n\n👉 Add `MONDAY_TOKEN` here: https://www.val.town/x/wnewton/production-command-center/environment-variables?key=MONDAY_TOKEN\n\n## Safety\n\n- Monday.com token (when added) stays server-side only.\n- All reads/writes/uploads are authenticated; uploaded file type + size validated.\n- Parameterized SQL throughout.\n- The live hosted Command Center is untouched.\n",[],[380],"b4ddd245-b24d-43c0-84da-9e5509f17f07","scripts","3602a262-390e-4ee8-b50a-14fa58db107b",["D",1788472667790],"directory",[],[388],"5f318513-99bb-4966-bea1-83b29d80c23b","styles.css","ff077a2e-a7d3-11f1-92c0-1607ee4eb77e",51,["D",1788494190784],5,"/* Production Command Center — NDX black/white/red interface */\n:root{--navy:#090909;--red:#d71920;--ink:#111;--muted:#707070;--line:#dedede;--paper:#f3f3f3;--shadow:0 10px 30px rgba(0,0,0,.075)}\n*{box-sizing:border-box}\nhtml{background:var(--paper)}\nbody{margin:0;background:radial-gradient(circle at 92% 4%,rgba(196,18,48,.07),transparent 25%),radial-gradient(circle at 42% 96%,rgba(0,0,0,.035),transparent 32%),var(--paper);color:var(--ink);font-family:\"Manrope\",Arial,sans-serif;-webkit-font-smoothing:antialiased}\nbutton{border:1px solid #d7dfe2;background:#fff;border-radius:6px;padding:10px 14px;margin-left:7px;font-size:10px;font-weight:800;color:#455660;cursor:pointer}\n.gold{background:var(--red);border-color:var(--red);color:#fff}\n.shell{min-height:100vh;display:block}\n.shell aside{position:fixed;inset:0 auto 0 0;z-index:30;width:258px;padding:24px 16px 20px;background:linear-gradient(165deg,#141414 0%,#090909 58%,#000 100%);box-shadow:12px 0 40px rgba(0,0,0,.14)}\n.shell aside:after{content:\"\";position:absolute;inset:0;pointer-events:none;background:radial-gradient(circle at 12% 0,rgba(196,18,48,.3),transparent 28%),radial-gradient(circle at 100% 92%,rgba(196,18,48,.12),transparent 34%)}\n.brand,nav,.job,.user{position:relative;z-index:1}\n.brand{display:flex;gap:13px;align-items:center;padding:2px 7px 24px;border-bottom:1px solid rgba(255,255,255,.11)}\n.brand>i{width:50px;height:50px;border:1px solid rgba(255,255,255,.2);border-radius:15px;background:linear-gradient(145deg,#d81d3d,#aa0e28);box-shadow:0 10px 24px rgba(196,18,48,.3);display:grid;place-items:center;font:800 17px \"Manrope\";letter-spacing:-.08em;color:#fff;font-style:normal}\n.brand>i span{font-size:13px}\n.brand b{font-size:14px;letter-spacing:-.02em;color:#fff}\n.brand small{margin-top:5px;color:#a9a9a9;font:500 8px \"DM Mono\";letter-spacing:.11em}\n.brand span,.user span{display:flex;flex-direction:column}\n.shell nav{display:flex;flex-direction:column;gap:5px;margin-top:22px}\n.shell nav button{position:relative;display:flex;align-items:center;gap:12px;min-height:47px;padding:0 12px;border:0;border-radius:12px;color:#b7b7b7;background:transparent;font-size:11px;font-weight:600;transition:170ms ease;margin-left:0;width:100%;text-align:left}\n.shell nav button:hover{color:#fff;background:rgba(255,255,255,.06);transform:translateX(2px)}\n.shell nav button>span{display:grid;place-items:center;width:28px;height:28px;border-radius:9px;color:#9c9c9c;background:rgba(255,255,255,.055);font-size:13px}\n.shell nav button.active{color:#fff;background:rgba(255,255,255,.1);box-shadow:0 8px 22px rgba(0,0,0,.1)}\n.shell nav button.active:before{content:\"\";position:absolute;left:0;width:3px;height:22px;border-radius:0 4px 4px 0;background:#e31b3d}\n.shell nav button.active>span{color:#fff;background:rgba(196,18,48,.72)}\n.job{margin-top:auto;border:0;border-top:1px solid rgba(255,255,255,.11);border-radius:0;padding:19px 10px 0!important;background:transparent!important;display:flex;flex-direction:column;gap:7px}\n.job small{color:#b8b8b8;font:500 8px \"DM Mono\";letter-spacing:.07em}\n.job b{font-size:11px;color:#fff}\n.job em{color:#ddd;font:500 9px \"DM Mono\";font-style:normal}\n.user{border-top:0;margin-top:18px;padding:0 10px;display:flex;gap:9px;align-items:center}\n.user>i{width:34px;height:34px;border-radius:11px;background:linear-gradient(145deg,#d91b3b,#b40e2a);display:grid;place-items:center;color:#fff;font-style:normal;font-size:10px;font-weight:bold}\n.user b{font-size:10px;color:#fff}\n.user small{font-size:8px;color:#a9a9a9}\n.shell main{width:calc(100% - 258px);max-width:none;min-height:100vh;margin-left:258px;padding:0 34px 66px}\n.shell main>header{position:sticky;top:0;z-index:20;min-height:92px;margin:0 -34px 30px;padding:17px 34px;align-items:center;display:flex;justify-content:space-between;background:rgba(255,255,255,.9);border-bottom:1px solid rgba(220,220,220,.92);box-shadow:0 8px 30px rgba(0,0,0,.04);backdrop-filter:blur(22px) saturate(1.2)}\nheader p{font-size:8px;letter-spacing:1.7px;font-weight:800;color:#8a979e;margin:0 0 7px}\nheader h1{font:700 clamp(25px,2.3vw,35px) \"Manrope\";line-height:1;letter-spacing:-.05em;margin:0 0 6px}\nheader span{font-size:11px;color:var(--muted)}\n.header-actions{display:flex;align-items:center;gap:10px}\nheader button{min-height:42px;margin:0;border-radius:11px;padding:0 17px;font-size:10px;transition:170ms ease}\nheader button:hover{transform:translateY(-2px);box-shadow:0 9px 20px rgba(0,0,0,.14)}\nheader .gold{background:linear-gradient(145deg,#d91b3b,#b40e2a)!important;box-shadow:0 5px 14px rgba(196,18,48,.22)}\nheader .logout{background:#fff;color:#111;border-color:#dedede}\n.top-job-picker{display:grid;gap:3px;min-width:235px;padding:7px 12px;border:1px solid #dbe3de;border-radius:11px;background:rgba(255,255,255,.82)}\n.top-job-picker small{color:#707070;font:500 8px \"DM Mono\";letter-spacing:.1em}\n.top-job-picker select{border:0;outline:0;background:transparent;color:#111;font-size:11px;font-weight:600}\n.status-line{background:#fff;border:1px solid var(--line);border-left:4px solid var(--red);border-radius:10px;padding:11px 15px;margin-bottom:15px;font-size:10px;font-weight:700;color:#b51218}\n.panel,.kpis article{background:rgba(255,255,255,.92);border:1px solid rgba(220,220,220,.95);border-radius:17px;box-shadow:var(--shadow);backdrop-filter:blur(10px)}\n.panel{padding:21px;margin-bottom:18px;overflow:hidden}\n.kpis{display:grid;grid-template-columns:repeat(4,1fr);gap:15px;margin:15px 0}\n.kpis article{min-height:145px;padding:21px 22px;border-top:3px solid #111;transition:180ms ease}\n.kpis article>i{display:grid;place-items:center;width:27px;height:27px;background:#f7e7e7;color:var(--red);border-radius:6px;font-style:normal;font-weight:bold}\n.kpis article p{margin-top:15px;font-size:8px;letter-spacing:1.5px;font-weight:800;color:#8a979e}\n.kpis h2{font:500 28px \"DM Mono\";margin:0 0 6px}\n.kpis span{font-size:8px;color:#84929a}\n.kpis .accent{border-top:3px solid var(--red)}\n.import-strip{display:flex;align-items:center;gap:9px;background:linear-gradient(145deg,#1a1a1a,#050505);color:#fff;border-left:5px solid var(--red);border-radius:22px;padding:13px 15px;margin-top:15px;box-shadow:0 18px 44px rgba(0,0,0,.18)}\n.import-strip>div{margin-right:auto}\n.import-strip p{color:#e1484d;margin-bottom:4px;font-size:8px;font-weight:800;letter-spacing:1.7px}\n.import-strip b{font-size:11px}\n.import-strip button{min-height:42px;border-radius:11px;border-color:#444;background:#222;color:#fff}\n.empty-state{padding:50px 20px;display:flex;flex-direction:column;align-items:center;gap:8px;color:#7b868c;text-align:center}\n.empty-state b{font:700 18px Georgia;color:#111}\n.empty-state span{font-size:10px;max-width:520px;line-height:1.5}\n.view-head{display:flex;justify-content:space-between;align-items:center;border-bottom:1px solid #e4e7e8;padding-bottom:16px}\n.view-head p{margin-bottom:4px;color:var(--red);font-size:8px;font-weight:800;letter-spacing:1.5px}\n.view-head h3{font:700 20px \"Manrope\";margin:0}\n.source-pill{padding:6px 9px;border-radius:20px;background:#f6e7ea;color:#b5122c;font:600 7px \"DM Mono\";letter-spacing:.08em}\n/* Migration checklist */\n.migration-panel{padding:22px!important}\n.migration-list{display:flex;flex-direction:column;margin-top:8px}\n.migration-row{display:flex;align-items:center;gap:14px;min-height:58px;padding:12px 6px;border-top:1px solid #ececec}\n.migration-row>i{flex:0 0 26px;width:26px;height:26px;display:grid;place-items:center;border-radius:9px;font-style:normal;background:#eee;color:#999;font:600 12px \"DM Mono\"}\n.migration-row.done>i{background:#111;color:#fff}\n.migration-row>span{display:flex;flex-direction:column;gap:3px}\n.migration-row b{font-size:11px}\n.migration-row small{font-size:9px;color:#7a7a7a;line-height:1.4}\n.migration-note{margin-top:16px;padding:13px 15px;border-left:4px solid var(--red);background:#f8eeee;border-radius:10px;font-size:10px;line-height:1.5;color:#7a5a5c}\n.migration-note code{background:#fff;border:1px solid #e2ccce;padding:2px 6px;border-radius:5px;color:#b51218}\n/* Auth screens */\n.auth-shell{min-height:100vh;display:grid;place-items:center;padding:20px}\n.auth-card{width:min(440px,100%);background:rgba(255,255,255,.95);border:1px solid rgba(220,220,220,.95);border-radius:20px;box-shadow:var(--shadow);padding:34px;display:flex;flex-direction:column}\n.brand-mark{width:58px;height:58px;border-radius:16px;background:linear-gradient(145deg,#d81d3d,#aa0e28);box-shadow:0 10px 24px rgba(196,18,48,.3);display:grid;place-items:center;font:800 20px \"Manrope\";letter-spacing:-.08em;color:#fff}\n.brand-mark span{font-size:15px}\n.auth-kicker{margin-top:24px;color:var(--red);font-size:9px;font-weight:800;letter-spacing:2px}\n.auth-card h1{font:700 26px \"Manrope\";letter-spacing:-.02em;margin:6px 0 8px}\n.auth-sub{font-size:11px;line-height:1.55;color:#707070;margin:0 0 18px}\n.auth-card label{display:flex;flex-direction:column;gap:6px;margin-bottom:14px;font-size:8px;font-weight:800;letter-spacing:1px;color:#777}\n.auth-card input{border:1px solid #d8dfe2;border-radius:10px;padding:12px 13px;font-size:12px}\n.auth-card .gold{min-height:46px;border-radius:11px;margin:6px 0 0;font-size:12px}\n.auth-status{font-size:11px;color:#b51218;background:#f8eeee;border-radius:8px;padding:9px 11px;margin:0 0 10px}\n.auth-loading{color:#777;font-size:11px;margin-top:20px}\n.backdrop{position:fixed;inset:0;background:rgba(8,8,8,.74);display:flex;align-items:flex-start;justify-content:center;overflow-y:auto;overscroll-behavior:contain;padding:20px;z-index:100;backdrop-filter:blur(5px)}\n.backdrop form{width:min(550px,100%);display:flex;flex-direction:column;max-height:calc(100vh - 40px);overflow:hidden;margin:auto;background:#fff;padding:23px;border-radius:17px;box-shadow:0 30px 90px rgba(0,0,0,.32)}\n/* Modal shell: pin the header and the Save/Cancel actions; only the field body scrolls */\n.backdrop form>.form-head{flex:0 0 auto}\n.backdrop form>.actions{flex:0 0 auto}\n.backdrop form>.form-grid{flex:1 1 auto;min-height:0;overflow-y:auto}\n.form-head{display:flex;justify-content:space-between;margin:-23px -23px 20px;padding:19px 24px;color:#fff;background:#111;border-radius:17px 17px 0 0}\n.form-head p{color:#e15469}\n.form-head h2{font:700 23px \"Manrope\";margin:0}\n.form-head button{border:0;font-size:22px;color:#fff;background:transparent}\n.create-job-form>label{display:flex;flex-direction:column;gap:7px;margin-top:20px;font-size:8px;font-weight:bold;letter-spacing:1px;color:#777}\n.create-job-form>label input{border:1px solid #d8e0e3;border-radius:6px;padding:12px;font-size:12px}\n.job-help{font-size:9px;line-height:1.5;margin-top:12px;color:#888}\n.actions{display:flex;justify-content:flex-end;margin-top:17px}\n@media(max-width:1100px){.shell aside{width:82px}.shell main{width:calc(100% - 82px);margin-left:82px}.brand span,.job,.user span{display:none}.brand>i{width:48px}.shell nav button{font-size:0;padding:0 10px}.top-job-picker{min-width:180px}}\n@media(max-width:760px){.shell aside{position:static;width:100%;height:68px;min-height:0;padding:9px 14px}.shell aside nav,.job,.user{display:none}.brand{border:0;padding:0}.shell main{width:100%;margin:0;padding:0 15px 45px}.shell main>header{position:static;margin:0 -15px 20px;padding:16px}.kpis{grid-template-columns:1fr 1fr}}\n/* Print */\n@media print{aside,.header-actions,.import-strip,.logout{display:none!important}.shell main{margin:0;width:100%;padding:0}.panel{box-shadow:none;border:1px solid #ddd}}\n\n/* ===== Phase 2 components ===== */\n/* Monday status strip */\n.monday-strip{display:flex;align-items:center;gap:12px;background:#fff;border:1px solid var(--line);border-left:5px solid #999;border-radius:14px;padding:12px 16px;margin-bottom:16px;box-shadow:var(--shadow)}\n.monday-strip>div{display:flex;flex-direction:column;gap:3px;margin-right:auto}\n.monday-strip p{color:#8a979e;margin:0;font-size:8px;font-weight:800;letter-spacing:1.5px}\n.monday-strip b{font-size:12px}\n.monday-strip span{font-size:10px;color:#7a848a}\n.monday-strip.not-connected{border-left-color:#b0b0b0}\n.monday-strip.not-connected b{color:#8a8a8a}\n.monday-strip button{min-height:36px;border-radius:10px;background:#f0f0f0;color:#999;cursor:not-allowed}\n/* Filters */\n.filters{height:56px;background:#fff;border:1px solid var(--line);border-radius:12px;padding:11px 16px;display:flex;align-items:center;gap:28px;margin-top:14px;box-shadow:var(--shadow)}\n.filters label{font-size:7px;font-weight:bold;color:#87959d;display:flex;flex-direction:column;gap:5px}\n.filters select{border:0;background:#fff;font-size:10px;font-weight:bold}\n.filters>span{margin-left:auto;font-size:9px;color:#b51218}\n/* Jobs manager */\n.jobs-panel{padding:22px!important}\n.create-job-inline{display:flex;gap:10px;margin:16px 0}\n.create-job-inline input{flex:1;border:1px solid #d8e0e3;border-radius:10px;padding:12px;font-size:12px}\n.create-job-inline button{margin:0}\n.job-list{display:flex;flex-direction:column}\n.job-list-row{display:flex;align-items:center;justify-content:space-between;gap:12px;min-height:58px;padding:12px 14px;border-top:1px solid #ececec}\n.job-list-row.active{background:#f8f2f2;border-left:3px solid var(--red)}\n.job-list-row>span:first-child{display:flex;flex-direction:column;gap:4px}\n.job-list-row b{font-size:12px}\n.job-list-row small{font-size:9px;color:#7a848a}\n.job-list-actions{display:flex;gap:6px}\n.job-list-actions button{margin:0;min-height:32px;border-radius:8px}\n.danger-ghost{color:#b51218;border-color:#e2ccce;background:#fff}\n.danger{background:#b51218;border-color:#b51218;color:#fff}\n.wide-form{width:min(640px,100%)!important}\n/* Labor rates */\n.labor-settings{display:grid;grid-template-columns:1.5fr .7fr;gap:14px}\n.rate-settings-card{padding:24px!important}\n.settings-head{display:flex;align-items:flex-start;justify-content:space-between;border-bottom:1px solid #e4e7e8;padding-bottom:17px}\n.settings-head h3,.prevailing-card h3{font:700 21px \"Manrope\";margin:0}\n.save-status{font-size:9px;color:#d71920;background:#f8e8e8;padding:6px 9px;border-radius:14px}\n.settings-job{display:flex;flex-direction:column;gap:6px;margin:19px 0;font-size:8px;letter-spacing:1px;font-weight:bold;color:#777}\n.settings-job input{width:100%;border:1px solid #d8dfe2;border-radius:7px;padding:12px;background:#f5f5f5;font-size:11px;font-weight:bold}\n.rate-input-grid{display:grid;grid-template-columns:repeat(3,1fr);gap:12px}\n.rate-input-grid>label{border:1px solid #dedede;border-radius:8px;padding:15px}\n.rate-input-grid>label>span{display:flex;justify-content:space-between;font-size:11px;font-weight:bold}\n.rate-input-grid small{font-size:7px;color:#888}\n.rate-input-grid label>div{display:flex;align-items:center;margin-top:12px}\n.rate-input-grid i{font:700 20px Georgia;color:#d71920;font-style:normal}\n.rate-input-grid input{width:100%;border:0;border-bottom:2px solid #111;padding:5px;font:700 25px Georgia;outline:none}\n.rate-input-grid em{font-size:9px;color:#777;font-style:normal;white-space:nowrap}\n.rate-actions{display:flex;align-items:center;justify-content:flex-end;margin-top:20px;padding-top:16px;border-top:1px solid #e4e7e8}\n.rate-actions>span{margin-right:auto;max-width:45%;font-size:9px;line-height:1.5;color:#76848b}\n.prevailing-card{background:#111!important;color:#fff!important;display:flex;gap:16px;align-items:flex-start}\n.prevailing-card>i{width:42px;height:42px;border:1px solid #d71920;color:#fff;background:#d71920;display:grid;place-items:center;border-radius:7px;font-style:normal;font-weight:bold}\n.prevailing-card p{color:#e33b40}\n.prevailing-card span{font-size:10px;line-height:1.6;color:#bfc3c5;display:block;margin-top:12px}\n/* Daily */\n.daily-view{padding:22px!important}\n.daily-row{display:grid;grid-template-columns:2fr .8fr .7fr .9fr .9fr .9fr;align-items:center;min-height:58px;border-bottom:1px solid #eceff0;font-size:9px}\n.daily-head{min-height:34px;font-size:7px;font-weight:bold;letter-spacing:.7px;color:#7b868c}\n.form-grid{display:grid;grid-template-columns:1fr 1fr;gap:13px;margin:18px 0}\n.form-grid label{display:flex;flex-direction:column;gap:6px;font-size:7px;font-weight:bold;color:#7d8b93}\n.form-grid .wide{grid-column:1/-1}\n.form-grid input,.form-grid select{border:1px solid #d8e0e3;border-radius:6px;padding:10px}\n.equipment-calc{border:1px solid #dedede;border-radius:7px;padding:11px 13px;margin-bottom:10px;display:flex;align-items:center;justify-content:space-between;background:#fafafa}\n.equipment-calc span{display:flex;flex-direction:column}\n.equipment-calc small{font-size:7px;letter-spacing:1px;color:#777}\n.equipment-calc b{font:700 19px Georgia;margin-top:3px}\n.equipment-calc em{font-style:normal;font-size:9px;color:#777}\n.calculated{background:#f8eeee;border-left:4px solid var(--red);padding:12px;display:flex;justify-content:space-between;border-radius:11px}\n.calculated span{font-size:7px}\n.calculated b{font:700 16px Georgia;color:#b51218}\n/* Operations usage */\n.operations-grid{display:grid;grid-template-columns:1.15fr .85fr;gap:15px;margin-bottom:15px}\n.operations-grid>.panel{margin:0}\n.usage-list{margin-top:14px}\n.usage-row{display:grid;grid-template-columns:28px 1fr auto;gap:11px;align-items:center;padding:11px 0;border-top:1px solid #ececec}\n.usage-row>i{width:26px;height:26px;display:grid;place-items:center;border-radius:8px;background:#111;color:#fff;font:600 9px \"DM Mono\";font-style:normal}\n.usage-row>span{min-width:0;display:flex;flex-direction:column;gap:4px}\n.usage-row b{overflow:hidden;text-overflow:ellipsis;white-space:nowrap;font-size:10px}\n.usage-row small{color:#7a7a7a;font-size:8px}\n.usage-row em{display:block;width:100%;height:4px;border-radius:4px;background:#ececec}\n.usage-row em u{display:block;height:100%;border-radius:4px;background:#c41230;text-decoration:none}\n.usage-row>strong{min-width:62px;text-align:right;font:600 16px \"DM Mono\"}\n.usage-row>strong small{font-size:8px}\n.crew-summary{display:grid;grid-template-columns:repeat(3,1fr);gap:8px;margin:15px 0}\n.crew-summary>span{display:flex;flex-direction:column;gap:5px;padding:12px;border-radius:11px;background:#111;color:#fff}\n.crew-summary small{font:500 7px \"DM Mono\";color:#aaa;letter-spacing:.08em}\n.crew-summary b{font:600 23px \"DM Mono\"}\n.crew-days>div{display:flex;align-items:center;justify-content:space-between;padding:10px 2px;border-top:1px solid #ececec}\n.crew-days span{display:flex;flex-direction:column;gap:3px}\n.crew-days b{font-size:10px}\n.crew-days small{font-size:8px;color:#7a7a7a}\n.crew-days strong{font:600 15px \"DM Mono\"}\n.crew-days strong small{font:500 8px \"Manrope\"}\n.empty-state.compact{min-height:150px}\n/* Phase controls + phase usage */\n.phase-controls{display:flex;align-items:center;justify-content:space-between;min-height:64px;margin:0 0 12px;padding:11px 14px;border:1px solid #dedede;border-radius:15px;background:#fff;box-shadow:0 8px 24px rgba(0,0,0,.05)}\n.phase-controls p{margin-bottom:4px}\n.phase-controls b{font-size:11px}\n.phase-controls button{min-height:38px;border-color:#111;background:#111;color:#fff}\n.phase-controls button:disabled{opacity:.35;cursor:not-allowed}\n.phase-usage{padding:0!important;margin-bottom:15px!important}\n.phase-usage>.view-head{padding:20px 20px 14px}\n.phase-table{overflow:auto}\n.phase-row{display:grid;grid-template-columns:minmax(180px,1.4fr) minmax(220px,1.5fr) 120px 90px 90px 85px;align-items:center;min-width:900px;min-height:62px;padding:0 20px;border-top:1px solid #ececec}\n.phase-row>span{display:flex;flex-direction:column;gap:4px;padding-right:12px;font-size:10px;text-align:left}\n.phase-row small{color:#7a7a7a;font-size:8px}\n.phase-row em{color:#888;font-size:9px;font-style:normal}\n.phase-row>span:nth-child(n+3) b{font:600 14px \"DM Mono\"}\n.phase-head{min-height:34px;background:#111;color:#fff;border:0}\n.phase-head>span{font:600 7px \"DM Mono\";letter-spacing:.08em}\n.phase-group:nth-child(odd)>.phase-click{background:#fafafa}\n.phase-click{width:100%;margin:0;border:0;border-top:1px solid #ececec;border-radius:0;background:#fff;color:#111}\n.phase-click:hover{background:#f5f5f5}\n.phase-group.open>.phase-click{background:#f8eaed;box-shadow:inset 4px 0 #c41230}\n.phase-name{flex-direction:row!important;align-items:center;gap:10px!important}\n.phase-name i{display:grid;place-items:center;flex:0 0 25px;width:25px;height:25px;border-radius:7px;background:#111;color:#fff;font:500 15px \"DM Mono\";font-style:normal}\n.phase-detail{display:grid;grid-template-columns:1.15fr .85fr;gap:22px;min-width:900px;padding:20px 28px 25px 54px;border-top:1px solid #e2c9ce;border-bottom:1px solid #dedede;background:linear-gradient(135deg,#fff 0%,#faf7f8 100%);box-shadow:inset 4px 0 #c41230}\n.detail-title{padding-bottom:10px;border-bottom:1px solid #e5e5e5}\n.detail-title p{margin-bottom:4px;color:#c41230}\n.detail-title>b{font-size:11px}\n.phase-detail .usage-list{margin-top:3px}\n.phase-detail .crew-summary{margin-top:12px}\n.detail-days{max-height:250px;overflow:auto;padding-right:6px}\n.detail-empty{padding:28px 0;color:#777;font-size:10px}\n/* Equipment moves */\n.equipment-moves{padding:0!important}\n.equipment-moves>.view-head{padding:20px 21px 14px}\n.move-summary{display:grid;grid-template-columns:repeat(4,minmax(0,1fr));gap:9px;padding:0 21px 18px}\n.move-summary>span{display:flex;flex-direction:column;gap:5px;padding:12px 14px;border-radius:11px;background:#111;color:#fff}\n.move-summary small{color:#aaa;font:500 7px \"DM Mono\";letter-spacing:.08em}\n.move-summary b{font:600 18px \"DM Mono\"}\n.move-summary .review{background:#fff0d3;color:#946000}\n.move-summary .review small{color:#946000}\n.move-table{overflow:auto}\n.move-row{display:grid;grid-template-columns:115px minmax(210px,1.2fr) minmax(230px,1.4fr) 85px minmax(180px,1fr);align-items:center;min-width:900px;min-height:67px;padding:0 21px;border-top:1px solid #ececec}\n.move-row>span{display:flex;flex-direction:column;gap:4px;padding-right:12px;font-size:10px}\n.move-row b{font-size:10px}\n.move-row small{color:#777;font-size:8px}\n.move-row>span:nth-child(4)>b,.move-row>span:nth-child(5)>b{font:600 14px \"DM Mono\"}\n.move-row em{align-self:flex-start;margin-top:2px;padding:3px 6px;border-radius:10px;background:#fff0d3;color:#946000;font:600 7px \"DM Mono\";font-style:normal}\n.move-head{min-height:34px;background:#111;color:#fff}\n.move-head>span{font:600 7px \"DM Mono\";letter-spacing:.08em}\n.move-row:nth-child(odd):not(.move-head){background:#fafafa}\n/* Rate book */\n.rate-book{padding:0!important;overflow:hidden}\n.rate-tools{display:flex;align-items:center;justify-content:space-between;padding:19px}\n.rate-tools h3{font:700 20px \"Manrope\";margin:0}\n.rate-tools input{width:min(320px,45%);border:1px solid #d8dfe2;border-radius:7px;padding:11px 13px;font-size:11px}\n.rate-header,.rate-row{display:grid;grid-template-columns:1fr 150px;align-items:center}\n.rate-header{padding:10px 19px;background:#111;color:#fff;font-size:7px;letter-spacing:1.2px;font-weight:bold}\n.rate-list{max-height:640px;overflow:auto}\n.rate-row{min-height:48px;padding:0 19px;border-bottom:1px solid #eceff0}\n.rate-row>span{display:flex;align-items:center;gap:10px;font-size:10px}\n.rate-row>span i{width:25px;height:25px;border-radius:5px;background:#f8e7e7;color:#d71920;display:grid;place-items:center;font-style:normal}\n.rate-row strong{font:700 14px Georgia;color:#111}\n.rate-row strong small{font:normal 8px Arial;color:#7b858b;margin-left:3px}\n/* Cost code table */\n.cost-code-panel{padding:0!important;overflow:hidden}\n.cost-code-title{display:flex;justify-content:space-between;align-items:center;padding:18px}\n.cost-code-title h3{font:700 18px \"Manrope\";margin:0}\n.cost-code-title>div:last-child{display:flex;gap:20px}\n.cost-code-title>div:last-child span{display:flex;flex-direction:column}\n.cost-code-title small{font-size:7px;color:#838d92;letter-spacing:.7px}\n.cost-code-title b{font:700 15px Georgia;margin-top:3px}\n.cost-code-title .total{border-left:2px solid #d71920;padding-left:18px}\n.cost-code-scroll{max-height:630px;overflow:auto}\n.cost-code-row{display:grid;grid-template-columns:2.2fr .8fr .9fr .9fr 1.25fr 1fr;align-items:center;gap:10px;min-height:60px;padding:8px 18px;border-top:1px solid #eceff0;font-size:9px}\n.cost-code-head{min-height:32px;background:#111;color:#fff;font-size:7px;letter-spacing:.8px;font-weight:bold}\n.cost-code-row>span:first-child{display:flex;flex-direction:column;gap:4px}\n.cost-code-row>span:first-child small{color:#7e8a91}\n.production-input{display:flex!important;flex-direction:row!important;gap:5px;flex-wrap:wrap}\n.production-input input{width:75px;border:1px solid #d7dfe2;border-radius:5px;padding:7px;font-size:9px}\n.production-input select{border:1px solid #d7dfe2;border-radius:5px;background:#fff;padding:7px;font-size:9px}\n.production-input .scope-note{width:100%;font-size:7px;color:#8b969c;margin-top:1px}\n.unit-cost{display:flex;flex-direction:column;color:#b51218}\n.unit-cost b{font:700 14px Georgia}\n.pending-unit em{font-style:normal;color:#929ca1}\n.cost-code-row:nth-child(even):not(.cost-code-head){background:#fafafa}\n.consolidate-button{min-height:34px;margin:12px 0 0;padding:0 12px;border-color:#111;border-radius:9px;background:#fff;color:#111}\n.consolidate-button.active{border-color:#c41230;background:#c41230;color:#fff}\n/* Unit cost summary */\n.unit-summary{display:grid;grid-template-columns:repeat(3,1fr);gap:13px;margin-bottom:13px}\n.unit-summary article{background:#111;color:#fff;border-top:3px solid #d71920;border-radius:8px;padding:18px}\n.unit-summary h2{font:700 28px Georgia;margin:0 0 5px}\n.unit-summary span{font-size:9px;color:#aaa}\n/* Split + chart + forecast */\n.split{display:grid;grid-template-columns:1.2fr 1fr;gap:13px;margin-bottom:13px}\n.title{display:flex;justify-content:space-between}\n.title h3{font:700 17px \"Manrope\";margin:0}\n.title button{border:0;padding:0;color:#d71920;background:transparent}\n.chart{height:190px;border-bottom:1px solid #dfe5e7;margin-top:14px;display:flex;justify-content:space-around;align-items:flex-end;background:repeating-linear-gradient(to bottom,#fff 0,#fff 45px,#edf1f2 46px)}\n.bar{width:16%;height:100%;display:flex;flex-direction:column;justify-content:flex-end;align-items:center}\n.bar>b{font-size:7px}\n.bar>span{height:135px;display:flex;align-items:flex-end;gap:3px}\n.bar>span i,.bar>span em{display:block;width:12px;border-radius:2px 2px 0 0}\n.bar>span i{background:#d71920}\n.bar>span em{background:#78a0ad}\n.bar>small{font-size:7px;color:#8d999f;margin:7px 0 -20px}\n.forecast-card{padding:21px 22px!important}\n.forecast-card.on-track{border-top:4px solid #18824b}\n.forecast-card.watch{border-top:4px solid #d68a00}\n.forecast-card.over{border-top:4px solid #c41230}\n.forecast-head{display:flex;align-items:flex-start;justify-content:space-between;gap:12px}\n.forecast-head h3{margin:0;font-size:17px}\n.forecast-head>span{padding:6px 9px;border-radius:20px;background:#ededed;color:#555;font:600 7px \"DM Mono\";letter-spacing:.06em;white-space:nowrap}\n.forecast-card.on-track .forecast-head>span{background:#e4f3eb;color:#126c3e}\n.forecast-card.watch .forecast-head>span{background:#fff0d3;color:#946000}\n.forecast-card.over .forecast-head>span{background:#f8e2e6;color:#a40f29}\n.forecast-inputs{display:grid;grid-template-columns:1fr 1fr;gap:9px;margin-top:14px}\n.forecast-inputs label{padding:10px 11px;border:1px solid #dedede;border-radius:11px;background:#fafafa}\n.forecast-inputs small,.forecast-result small,.forecast-bars small{display:block;color:#777;font:500 7px \"DM Mono\";letter-spacing:.06em}\n.forecast-inputs label>div{display:flex;align-items:center;margin-top:5px}\n.forecast-inputs i{color:#777;font:500 12px \"DM Mono\";font-style:normal}\n.forecast-inputs input{width:100%;border:0;outline:0;background:transparent;font:600 15px \"DM Mono\"}\n.forecast-bars{display:grid;grid-template-columns:1fr 1fr;gap:10px;margin-top:13px}\n.forecast-bars>div>span{display:flex;align-items:center;justify-content:space-between}\n.forecast-bars b{font:600 11px \"DM Mono\"}\n.forecast-bars>div>i{display:block;height:6px;margin-top:6px;border-radius:8px;background:#e8e8e8}\n.forecast-bars em{display:block;height:100%;border-radius:8px;background:#111}\n.forecast-bars em.over{background:#c41230}\n.forecast-result{display:grid;grid-template-columns:1fr 1fr 1.2fr;gap:8px;margin-top:14px;padding-top:12px;border-top:1px solid #e5e5e5}\n.forecast-result>span{display:flex;flex-direction:column;gap:4px}\n.forecast-result b{font:600 12px \"DM Mono\"}\n.forecast-result em{font-size:7px;color:#777;font-style:normal}\n.forecast-result .positive b{color:#126c3e}\n.forecast-result .negative b{color:#b10f2a}\n.forecast-empty{display:flex;flex-direction:column;gap:4px;margin-top:14px;padding:12px;border-radius:11px;background:#f3f3f3}\n.forecast-empty b{font-size:9px}\n.forecast-empty span{font-size:8px;line-height:1.45;color:#777}\n/* Reports */\n.report-view{display:grid;grid-template-columns:1.15fr .85fr;gap:14px}\n.report-cover{background:#111!important;color:#fff!important;border-left:5px solid #d71920!important;padding:28px!important}\n.report-cover h2{font:700 31px Georgia;margin:0 0 8px}\n.report-cover>span{font-size:10px;color:#aaa}\n.report-kpis{display:grid;grid-template-columns:1fr 1fr;gap:10px;margin-top:32px}\n.report-kpis>div{border:1px solid #373737;border-radius:7px;padding:16px;display:flex;flex-direction:column;gap:6px}\n.report-kpis small{font-size:7px;color:#aaa;letter-spacing:1px}\n.report-kpis b{font:700 20px Georgia}\n.report-rank{padding:22px!important}\n.rank-row{display:grid;grid-template-columns:30px 1fr auto;align-items:center;gap:10px;padding:13px 0;border-bottom:1px solid #eceff0}\n.rank-row i{width:24px;height:24px;background:#d71920;color:#fff;border-radius:50%;display:grid;place-items:center;font-style:normal;font-size:8px;font-weight:bold}\n.rank-row span{display:flex;flex-direction:column;gap:4px}\n.rank-row b{font-size:9px}\n.rank-row small{font-size:8px;color:#88949a}\n.rank-row strong{font:700 13px Georgia}\n.report-print{margin-top:18px;display:flex;justify-content:flex-end}\n.report-print button{margin:0}\n@media(max-width:900px){.report-view{grid-template-columns:1fr}.unit-summary{grid-template-columns:1fr}.labor-settings{grid-template-columns:1fr}.rate-input-grid{grid-template-columns:1fr}.operations-grid{grid-template-columns:1fr}.split{grid-template-columns:1fr}.cost-code-panel{overflow:auto}.cost-code-scroll{min-width:900px}.cost-code-title{min-width:900px}}\n@media(max-width:700px){.phase-detail{grid-template-columns:1fr}.rate-tools input{width:60%}.rate-header,.rate-row{grid-template-columns:1fr 95px}}\n@media print{aside,.header-actions,.import-strip,.logout,.monday-strip,.phase-controls,.report-print{display:none!important}.shell main{margin:0;width:100%;padding:0}.report-view{grid-template-columns:1fr 1fr}.panel{box-shadow:none;border:1px solid #ddd}}\n/* Forgot password link on the login / recovery cards */\n.auth-forgot{margin:14px 0 0;text-align:center}\n.auth-forgot .linklike{background:none;border:0;margin:0;padding:0;color:#b51218;font-size:11px;font-weight:700;cursor:pointer;text-decoration:underline}\n.auth-forgot .linklike:hover{color:#8f0e15}\n.auth-forgot .linklike:disabled{color:#aaa;cursor:not-allowed;text-decoration:none}\n/* Inline job editor — full-page section inside Jobs & Settings (replaces the old Edit modal) */\n.job-editor{padding:22px!important}\n.job-editor .view-head{margin-bottom:6px}\n.job-editor-form{max-width:860px}\n.job-editor-toolbar{display:flex;align-items:center;gap:8px;padding:14px 0}\n.job-editor-toolbar.top{border-bottom:1px solid #ececec;margin-bottom:8px}\n.job-editor-toolbar.bottom{border-top:1px solid #ececec;margin-top:8px}\n.job-editor-toolbar button{margin:0;min-height:40px;padding:0 18px;border-radius:10px}\n.job-editor-meta{flex:1;font-size:9px;color:#7a848a;text-align:left}\n.job-editor .form-grid{margin:18px 0}\n.job-editor label{display:flex;flex-direction:column;gap:6px;font-size:7px;font-weight:bold;color:#7d8b93}\n.job-editor .wide{grid-column:1/-1}\n.job-editor input{border:1px solid #d8e0e3;border-radius:10px;padding:11px 12px;font-size:12px}\n/* Monday refresh note / error + enabled refresh button */\n.monday-strip>div>span.monday-note{color:#126c3e}\n.monday-strip>div>span.monday-error{color:#b51218;font-weight:700}\n.monday-strip:not(.not-connected)>button{border-color:#111;background:#111;color:#fff;cursor:pointer;margin-left:0}\n.monday-strip:not(.not-connected)>button:hover{background:#292929}\n.monday-strip button:disabled{background:#f0f0f0;color:#999;cursor:not-allowed}\n",[],[306,395],"de051783-ca3e-431f-9e6c-dbdc3e98605a","root.tsx","bcd5b7d8-a7d3-11f1-893b-1607ee4eb77e",6,["D",1788466327307],"/** @jsxImportSource npm:hono@4/jsx */\nimport { raw } from \"npm:hono@4/html\";\nimport { immutableFileUrl } from \"https://esm.town/v/std/utils/index.ts\";\n\nexport function Root() {\n return (\n <>\n {raw(\"<!DOCTYPE html>\")}\n <html lang=\"en\">\n <head>\n <meta charSet=\"UTF-8\" />\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />\n <title>NDX Command Center

\n <div className=\"chart\">{[0, 0, 0, 0, 0].map((v, i) => <div className=\"bar\" key={i}><b>—</b><span><i style={{ height: v + \"%\" }} /><em style={{ height: v + \"%\" }} /></span><small>{[\"MON\", \"TUE\", \"WED\", \"THU\", \"FRI\"][i]}</small></div>)}</div>\n </article>\n <JobCostForecast actualCost={props.rows.reduce((s, r) => s + r.totalCost, 0)} settings={props.forecast} setSettings={props.setForecast} />\n </section>\n\n <CostCodeTable rows={props.rows} production={props.production} setProduction={props.setProduction} consolidated={props.consolidateCodes} setConsolidated={props.setConsolidateCodes} />\n </>\n );\n}\n\n// ---------- Jobs Manager ----------\n// The \"Edit\" action swaps to a full-page inline editor (no overlay, backdrop,\n// body scroll lock, or nested scrolling container). The browser's regular page\n// scrollbar scrolls through every field.\nfunction JobsManager({ user, jobs, activeJob, onCreate, onUpdate, onDeleteConfirm }: {\n user: User; jobs: Job[]; activeJob: Job | null; onCreate: (name: string) => void;\n onUpdate: (id: number, fields: Record<string, string>) => Promise<boolean>; onDeleteConfirm: () => void;\n}) {\n const [name, setName] = useState(\"\");\n const [editing, setEditing] = useState<Job | null>(null);\n const [form, setForm] = useState<Record<string, string>>({});\n const [saving, setSaving] = useState(false);\n const fields: [string, string][] = [\n [\"name\", \"Job name\"], [\"job_number\", \"Job #\"], [\"status\", \"Status\"], [\"superintendent\", \"Superintendent\"],\n [\"project_manager\", \"Project manager\"], [\"foreman\", \"Foreman\"], [\"location\", \"Location\"],\n [\"jurisdiction\", \"Jurisdiction\"], [\"general_contractor\", \"General contractor\"],\n [\"prevailing_wage\", \"Prevailing wage\"], [\"permit_number\", \"Permit #\"], [\"schedule_group\", \"Schedule group\"],\n ];\n\n useEffect(() => {\n if (!editing) return;\n const f: Record<string, string> = {};\n for (const [k] of fields) f[k] = String((editing as any)[k] ?? \"\");\n setForm(f);\n setSaving(false);\n }, [editing]);\n\n async function handleSave(e: React.FormEvent) {\n e.preventDefault();\n if (!editing) return;\n setSaving(true);\n try {\n const ok = await onUpdate(editing.id, form);\n if (ok) setEditing(null); // back to the job list; the status line confirms\n } finally {\n setSaving(false);\n }\n }\n\n if (editing) {\n return (\n <section className=\"panel jobs-panel job-editor\">\n <div className=\"view-head\">\n <div><p>EDIT PROJECT</p><h3>Edit — {editing.name}</h3></div>\n </div>\n <form className=\"job-editor-form\" onSubmit={handleSave}>\n <div className=\"job-editor-toolbar top\">\n <span className=\"job-editor-meta\">Editing <b>{editing.name}</b> — changes apply to this job only.</span>\n <button type=\"button\" onClick={() => setEditing(null)} disabled={saving}>Cancel</button>\n <button className=\"gold\" type=\"submit\" disabled={saving}>{saving ? \"Saving…\" : \"Save Changes\"}</button>\n </div>\n <div className=\"form-grid job-editor-grid\">\n {fields.map(([k, label]) => (\n <label className={k === \"name\" ? \"wide\" : \"\"} key={k}>\n {label.toUpperCase()}\n <input value={form[k] ?? \"\"} onChange={(e) => setForm({ ...form, [k]: e.target.value })} />\n </label>\n ))}\n </div>\n <div className=\"job-editor-toolbar bottom\">\n <span className=\"job-editor-meta\"> </span>\n <button type=\"button\" onClick={() => setEditing(null)} disabled={saving}>Cancel</button>\n <button className=\"gold\" type=\"submit\" disabled={saving}>{saving ? \"Saving…\" : \"Save Changes\"}</button>\n </div>\n </form>\n </section>\n );\n }\n\n return (\n <section className=\"panel jobs-panel\">\n <div className=\"view-head\"><div><p>JOBS & SETTINGS</p><h3>Manage utility-schedule jobs</h3></div><span className=\"source-pill\">{jobs.length} JOB{jobs.length === 1 ? \"\" : \"S\"}</span></div>\n\n <div className=\"create-job-inline\"><input placeholder=\"New job name\" value={name} onChange={(e) => setName(e.target.value)} /><button className=\"gold\" onClick={() => { if (name.trim()) { onCreate(name.trim()); setName(\"\"); } }}>＋ Create job</button></div>\n\n <div className=\"job-list\">\n {jobs.length === 0 && <div className=\"empty-state compact\"><b>No jobs yet</b><span>Create a job to begin. Tables are intentionally empty in this staging phase.</span></div>}\n {jobs.map((j) => (\n <div className={`job-list-row ${j.id === activeJob?.id ? \"active\" : \"\"}`} key={j.id}>\n <span><b>{j.name}</b><small>{j.job_number ? `${j.job_number} · ` : \"\"}{j.source === \"monday\" ? \"Monday.com\" : \"Manual\"} · created manually</small></span>\n <span className=\"job-list-actions\">\n <button onClick={() => setEditing(j)}>Edit</button>\n {user.role === \"admin\" && <button className=\"danger-ghost\" onClick={onDeleteConfirm}>Delete</button>}\n </span>\n </div>\n ))}\n </div>\n </section>\n );\n}\n\n// ---------- Daily production ----------\nfunction DailyProduction({ entries, rates, onAddEntry, onAdd }: { entries: Entry[]; rates: LaborRates; onAddEntry: (e: Entry) => void; onAdd: () => void }) {\n const [open, setOpen] = useState(false);\n const [form, setForm] = useState({ activity: \"\", unit: \"LF\", qty: \"\", laborHours: \"\", operatorHours: \"\", foremanHours: \"\", equipment: \"001 2013 Ram Truck 3500 ST\", equipmentHours: \"\" });\n const [equipmentRates, setEquipmentRates] = useState<EquipmentRate[]>([]);\n useEffect(() => { api(\"/api/equipment-rates\").then((d) => setEquipmentRates(d.rates ?? [])).catch(() => {}); }, []);\n const selected = equipmentRates.find((x) => x.label === form.equipment) ?? equipmentRates[0];\n const equipmentCost = (selected?.rate ?? 0) * Number(form.equipmentHours);\n const laborCost = Number(form.laborHours) * rates.labor + Number(form.operatorHours) * rates.operator + Number(form.foremanHours) * rates.foreman;\n function save(e: React.FormEvent) {\n e.preventDefault();\n onAddEntry({ id: Date.now(), activity: form.activity, unit: form.unit, qty: +form.qty || 0, hours: Number(form.laborHours) + Number(form.operatorHours) + Number(form.foremanHours), labor: laborCost, equipment: equipmentCost });\n setForm({ activity: \"\", unit: \"LF\", qty: \"\", laborHours: \"\", operatorHours: \"\", foremanHours: \"\", equipment: equipmentRates[0]?.label ?? \"\", equipmentHours: \"\" });\n setOpen(false);\n }\n return (\n <section className=\"panel daily-view\">\n <div className=\"view-head\"><div><p>FIELD ENTRIES</p><h3>Production and cost log</h3></div><button className=\"gold\" onClick={() => setOpen(true)}>＋ New entry</button></div>\n <div className=\"daily-row daily-head\"><span>ACTIVITY</span><span>QUANTITY</span><span>HOURS</span><span>LABOR</span><span>EQUIPMENT</span><span>TOTAL</span></div>\n {entries.length ? entries.map((e) => (\n <div className=\"daily-row\" key={e.id}><span><b>{e.activity}</b></span><span>{e.qty ? `${e.qty.toLocaleString()} ${e.unit}` : \"Imported total\"}</span><span>{e.hours.toFixed(2)}</span><span>{money(e.labor, 2)}</span><span>{money(e.equipment, 2)}</span><span><b>{money(e.labor + e.equipment, 2)}</b></span></div>\n )) : <div className=\"empty-state\"><b>No production entries yet</b><span>Add a field entry or upload the job’s Excel time sheet.</span></div>}\n\n {open && (\n <div className=\"backdrop\" onMouseDown={() => setOpen(false)}>\n <form onSubmit={save} onMouseDown={(e) => e.stopPropagation()}>\n <div className=\"form-head\"><div><p>DAILY FIELD ENTRY</p><h2>Add production & cost</h2></div><button type=\"button\" onClick={() => setOpen(false)}>×</button></div>\n <div className=\"form-grid\">\n <label className=\"wide\">ACTIVITY<input value={form.activity} onChange={(e) => setForm({ ...form, activity: e.target.value })} /></label>\n <label>QUANTITY<input type=\"number\" value={form.qty} onChange={(e) => setForm({ ...form, qty: e.target.value })} /></label>\n <label>UNIT<select value={form.unit} onChange={(e) => setForm({ ...form, unit: e.target.value })}>{UNITS.map((u) => <option key={u}>{u}</option>)}</select></label>\n <label>LABOR HOURS · {money(rates.labor, 2)}/HR<input type=\"number\" step=\".25\" value={form.laborHours} onChange={(e) => setForm({ ...form, laborHours: e.target.value })} /></label>\n <label>OPERATOR HOURS · {money(rates.operator, 2)}/HR<input type=\"number\" step=\".25\" value={form.operatorHours} onChange={(e) => setForm({ ...form, operatorHours: e.target.value })} /></label>\n <label>FOREMAN HOURS · {money(rates.foreman, 2)}/HR<input type=\"number\" step=\".25\" value={form.foremanHours} onChange={(e) => setForm({ ...form, foremanHours: e.target.value })} /></label>\n <label className=\"wide\">EQUIPMENT<select value={form.equipment} onChange={(e) => setForm({ ...form, equipment: e.target.value })}>{equipmentRates.map((x) => <option key={x.label}>{x.label}</option>)}</select></label>\n <label>EQUIPMENT HOURS<input type=\"number\" step=\".25\" value={form.equipmentHours} onChange={(e) => setForm({ ...form, equipmentHours: e.target.value })} /></label>\n <label>HOURLY RATE<input value={money(selected?.rate ?? 0, 2) + \" / hr\"} readOnly /></label>\n </div>\n <div className=\"equipment-calc\"><span><small>EQUIPMENT COST</small><b>{money(equipmentCost, 2)}</b></span><em>{form.equipmentHours || 0} hrs × {money(selected?.rate ?? 0, 2)}/hr</em></div>\n <div className=\"calculated\"><span>CALCULATED TOTAL COST / UNIT</span><b>{money((laborCost + equipmentCost) / Math.max(1, +form.qty), 2)} / {form.unit}</b></div>\n <div className=\"actions\"><button type=\"button\" onClick={() => setOpen(false)}>Cancel</button><button className=\"gold\">Save daily production</button></div>\n </form>\n </div>\n )}\n </section>\n );\n}\n\n// ---------- Labor rates ----------\nfunction LaborRateSettings({ job, rates, setRates, status, onSave }: { job: Job | null; rates: LaborRates; setRates: (v: LaborRates) => void; status: string; onSave: (e: React.FormEvent) => void }) {\n return (\n <section className=\"labor-settings\">\n <article className=\"panel rate-settings-card\">\n <div className=\"settings-head\"><div><p>JOB-SPECIFIC LABOR RATES</p><h3>Hourly rate schedule</h3></div><span className=\"save-status\">● {status || \"Ready\"}</span></div>\n <label className=\"settings-job\">JOB<input readOnly value={job?.name ?? \"Select a job\"} /></label>\n <form onSubmit={onSave}>\n <div className=\"rate-input-grid\">\n <RateInput label=\"Labor\" value={rates.labor} onChange={(v) => setRates({ ...rates, labor: v })} />\n <RateInput label=\"Operator\" value={rates.operator} onChange={(v) => setRates({ ...rates, operator: v })} />\n <RateInput label=\"Foreman\" value={rates.foreman} onChange={(v) => setRates({ ...rates, foreman: v })} />\n </div>\n <div className=\"rate-actions\"><span>These rates apply only to <b>{job?.name ?? \"this job\"}</b> and update new production entries immediately.</span><button type=\"button\" onClick={() => setRates(DEFAULT_RATES)}>Use standard rates</button><button className=\"gold\">Save job rates</button></div>\n </form>\n </article>\n <article className=\"panel prevailing-card\"><i>PW</i><div><p>PREVAILING WAGE READY</p><h3>Different job, different rates.</h3><span>Choose a job above, enter its required wage rates, and save. Your standard-rate jobs remain unchanged.</span></div></article>\n </section>\n );\n}\nfunction RateInput({ label, value, onChange }: { label: string; value: number; onChange: (v: number) => void }) {\n return <label><span>{label}<small>HOURLY RATE</small></span><div><i>$</i><input type=\"number\" min=\"0\" max=\"500\" step=\".01\" value={value} onChange={(e) => onChange(Number(e.target.value))} /><em>/ hr</em></div></label>;\n}\n\n// ---------- Equipment ----------\nfunction OperationsUsageView({ usage, days, phases, showPhases, setShowPhases }: { usage: EquipmentUsage[]; days: CrewDay[]; phases: PhaseUsage[]; showPhases: boolean; setShowPhases: (v: boolean) => void }) {\n const hasData = usage.length > 0 || days.length > 0;\n return <>\n <section className=\"phase-controls\"><div><p>JOB UTILIZATION VIEW</p><b>{showPhases ? \"Equipment and crew by phase code\" : \"Equipment and crew totals\"}</b></div><button disabled={!hasData} onClick={() => setShowPhases(!showPhases)}>{showPhases ? \"← Show job totals\" : \"View by phase code →\"}</button></section>\n {showPhases ? <PhaseCodeUsagePanel phases={phases} /> : <section className=\"operations-grid\"><EquipmentUsagePanel usage={usage} /><CrewSizePanel days={days} /></section>}\n </>;\n}\nfunction EquipmentUsagePanel({ usage }: { usage: EquipmentUsage[] }) {\n const top = usage.slice(0, 5); const max = top[0]?.hours || 1;\n return <article className=\"panel usage-panel\"><div className=\"view-head\"><div><p>TIMESHEET EQUIPMENT</p><h3>Most-used equipment</h3></div>{usage.length > 0 && <span className=\"source-pill\">RANKED BY HOURS</span>}</div>\n {top.length ? <div className=\"usage-list\">{top.map((item, i) => <div className=\"usage-row\" key={item.name}><i>{i + 1}</i><span><b>{item.name}</b><small>{item.entries} time {item.entries === 1 ? \"entry\" : \"entries\"}{item.cost > 0 ? ` · ${money(item.cost, 2)} cost` : \" · rate not matched\"}</small><em><u style={{ width: `${Math.max(6, item.hours / max * 100)}%` }} /></em></span><strong>{item.hours.toFixed(1)}<small> hrs</small></strong></div>)}</div> : <div className=\"empty-state compact\"><b>No equipment usage yet</b><span>Upload the job’s labor and equipment Excel file to rank equipment by hours.</span></div>}\n </article>;\n}\nfunction CrewSizePanel({ days }: { days: CrewDay[] }) {\n const average = days.length ? days.reduce((sum, d) => sum + d.size, 0) / days.length : 0;\n const peak = days.reduce((m, d) => Math.max(m, d.size), 0);\n const recent = days.slice(-5).reverse();\n return <article className=\"panel crew-panel\"><div className=\"view-head\"><div><p>TIMESHEET CREW</p><h3>Crew size by workday</h3></div>{days.length > 0 && <span className=\"source-pill\">UNIQUE EMPLOYEES</span>}</div>\n {days.length ? <><div className=\"crew-summary\"><span><small>AVERAGE CREW</small><b>{average.toFixed(1)}</b></span><span><small>PEAK CREW</small><b>{peak}</b></span><span><small>WORKDAYS</small><b>{days.length}</b></span></div><div className=\"crew-days\">{recent.map((day) => <div key={day.date}><span><b>{new Date(day.date + \"T12:00:00\").toLocaleDateString(\"en-US\", { month: \"short\", day: \"numeric\" })}</b><small>{day.hours.toFixed(1)} total labor hrs</small></span><strong>{day.size}<small> people</small></strong></div>)}</div></> : <div className=\"empty-state compact\"><b>No crew data yet</b><span>Crew size will calculate from unique employee IDs for each workday.</span></div>}\n </article>;\n}\nfunction PhaseCodeUsagePanel({ phases }: { phases: PhaseUsage[] }) {\n const [expanded, setExpanded] = useState(\"\");\n return <section className=\"panel phase-usage\"><div className=\"view-head\"><div><p>PHASE CODE UTILIZATION</p><h3>Equipment and crew by phase</h3></div><span className=\"source-pill\">CLICK A PHASE TO EXPAND</span></div>\n {phases.length ? <div className=\"phase-table\"><div className=\"phase-row phase-head\"><span>PHASE CODE</span><span>MOST-USED EQUIPMENT</span><span>EQUIPMENT HOURS</span><span>AVG. CREW</span><span>PEAK CREW</span><span>WORKDAYS</span></div>\n {phases.map((phase) => { const average = phase.days.length ? phase.days.reduce((s, d) => s + d.size, 0) / phase.days.length : 0; const peak = phase.days.reduce((m, d) => Math.max(m, d.size), 0); const top = phase.equipment[0]; const isOpen = expanded === phase.phaseCode; const maxHours = top?.hours || 1;\n return <div className={`phase-group${isOpen ? \" open\" : \"\"}`} key={phase.phaseCode}><button type=\"button\" className=\"phase-row phase-click\" aria-expanded={isOpen} onClick={() => setExpanded(isOpen ? \"\" : phase.phaseCode)}><span className=\"phase-name\"><i>{isOpen ? \"−\" : \"+\"}</i><b>{phase.phaseCode}</b></span><span>{top ? <><b>{top.name}</b><small>{phase.equipment.length} equipment {phase.equipment.length === 1 ? \"unit\" : \"units\"} used</small></> : <em>No equipment assigned</em>}</span><span><b>{phase.equipment.reduce((s, i) => s + i.hours, 0).toFixed(1)}</b><small>hours</small></span><span><b>{average.toFixed(1)}</b><small>people</small></span><span><b>{peak}</b><small>people</small></span><span><b>{phase.days.length}</b><small>days</small></span></button>\n {isOpen && <div className=\"phase-detail\"><div className=\"phase-equipment-detail\"><div className=\"detail-title\"><p>ALL EQUIPMENT USED</p><b>{phase.equipment.length} units ranked by hours</b></div>{phase.equipment.length ? <div className=\"usage-list\">{phase.equipment.map((item, index) => <div className=\"usage-row\" key={item.name}><i>{index + 1}</i><span><b>{item.name}</b><small>{item.entries} time {item.entries === 1 ? \"entry\" : \"entries\"}{item.cost > 0 ? ` · ${money(item.cost, 2)} matched cost` : \" · rate not matched\"}</small><em><u style={{ width: `${Math.max(6, item.hours / maxHours * 100)}%` }} /></em></span><strong>{item.hours.toFixed(1)}<small> hrs</small></strong></div>)}</div> : <div className=\"detail-empty\">No equipment assigned to this phase.</div>}</div><div className=\"phase-crew-detail\"><div className=\"detail-title\"><p>CREW BY WORKDAY</p><b>Unique employees per day</b></div><div className=\"crew-summary\"><span><small>AVERAGE CREW</small><b>{average.toFixed(1)}</b></span><span><small>PEAK CREW</small><b>{peak}</b></span><span><small>WORKDAYS</small><b>{phase.days.length}</b></span></div><div className=\"crew-days detail-days\">{phase.days.slice().reverse().map((day) => <div key={day.date}><span><b>{new Date(day.date + \"T12:00:00\").toLocaleDateString(\"en-US\", { month: \"short\", day: \"numeric\", year: \"numeric\" })}</b><small>{day.hours.toFixed(1)} total labor hrs</small></span><strong>{day.size}<small> people</small></strong></div>)}</div></div></div>}\n </div>; })}\n </div> : <div className=\"empty-state compact\"><b>No phase-code usage yet</b><span>Upload a BusyBusy time sheet to build the phase-code breakdown.</span></div>}\n </section>;\n}\nfunction EquipmentMovesPanel({ moves }: { moves: EquipmentMove[] }) {\n const totalHours = moves.reduce((s, m) => s + m.hours, 0);\n const totalCost = moves.reduce((s, m) => s + m.cost, 0);\n const review = moves.filter((m) => m.needsReview).length;\n return <section className=\"panel equipment-moves\"><div className=\"view-head\"><div><p>MOBILIZATION PHASE CODE · 1101</p><h3>Equipment moves</h3></div>{moves.length > 0 && <span className=\"source-pill\">{moves.length} {moves.length === 1 ? \"MOVE\" : \"MOVES\"}</span>}</div>\n {moves.length ? <><div className=\"move-summary\"><span><small>EQUIPMENT MOVES</small><b>{moves.length}</b></span><span><small>MOVE HOURS</small><b>{totalHours.toFixed(1)}</b></span><span><small>TOTAL MOVE COST</small><b>{money(totalCost, 2)}</b></span><span className={review ? \"review\" : \"\"}><small>NEEDS REVIEW</small><b>{review}</b></span></div>\n <div className=\"move-table\"><div className=\"move-row move-head\"><span>DATE</span><span>EQUIPMENT MOVED</span><span>HAULING EQUIPMENT / DRIVER</span><span>HOURS</span><span>COST</span></div>\n {moves.map((move) => <div className=\"move-row\" key={move.id}><span>{move.date ? new Date(move.date + \"T12:00:00\").toLocaleDateString(\"en-US\", { month: \"short\", day: \"numeric\", year: \"numeric\" }) : \"Date unavailable\"}</span><span><b>{move.movedEquipment}</b><small>{move.description}</small></span><span><b>{move.haulingEquipment}</b><small>{move.driver}</small></span><span><b>{move.hours.toFixed(1)}</b><small>hours</small></span><span><b>{money(move.cost, 2)}</b><small>{money(move.laborCost, 2)} labor + {move.haulingCost > 0 ? `${money(move.haulingCost, 2)} truck` : \"truck rate missing\"}</small>{move.needsReview && <em>Review match</em>}</span></div>)}\n </div></> : <div className=\"empty-state compact\"><b>No equipment moves found yet</b><span>Upload a BusyBusy time sheet. Mobilization entries that name the transported machine in the description will appear here.</span></div>}\n </section>;\n}\nfunction RateBook({ search, setSearch, rates }: { search: string; setSearch: (v: string) => void; rates: EquipmentRate[] }) {\n return <section className=\"panel rate-book\"><div className=\"rate-tools\"><div><p>IMPORTED EQUIPMENT RATES</p><h3>{rates.length} equipment records</h3></div><input placeholder=\"Search unit, make, or model…\" value={search} onChange={(e) => setSearch(e.target.value)} /></div>\n <div className=\"rate-header\"><span>EQUIPMENT ID & DESCRIPTION</span><span>HOURLY RATE</span></div>\n <div className=\"rate-list\">{rates.map((x) => <div className=\"rate-row\" key={x.label}><span><i>⚙</i><b>{x.label}</b></span><strong>{money(x.rate, 2)}<small>/ hr</small></strong></div>)}</div>\n </section>;\n}\n\n// ---------- Cost code + unit cost ----------\nfunction fourDigitCode(value: string) { return value.match(/^\\s*(\\d{4})/)?.[1] ?? value.split(\" - \")[0]; }\nfunction consolidatedRows(rows: CostRow[]) {\n const grouped = new Map<string, CostRow>();\n for (const row of rows) {\n const code = fourDigitCode(row.costCode); const prior = grouped.get(code);\n if (!prior) { grouped.set(code, { ...row, costCode: `${code} - Consolidated` }); continue; }\n prior.laborHours += row.laborHours; prior.operatorHours += row.operatorHours; prior.foremanHours += row.foremanHours;\n prior.equipmentHours += row.equipmentHours; prior.laborCost += row.laborCost; prior.equipmentCost += row.equipmentCost; prior.totalCost += row.totalCost;\n }\n return [...grouped.values()].sort((a, b) => a.costCode.localeCompare(b.costCode));\n}\nfunction CostCodeTable({ rows, production, setProduction, consolidated, setConsolidated }: {\n rows: CostRow[]; production: Record<string, ProductionValue>; setProduction: (v: Record<string, ProductionValue>) => void;\n consolidated: boolean; setConsolidated: (v: boolean) => void;\n}) {\n const displayedRows = consolidated ? consolidatedRows(rows) : rows;\n const totalLabor = rows.reduce((a, r) => a + r.laborCost, 0);\n const totalEquipment = rows.reduce((a, r) => a + r.equipmentCost, 0);\n return <section className=\"panel cost-code-panel\">\n <div className=\"cost-code-title\"><div><p>BUSYBUSY ACTUAL COSTS</p><h3>{consolidated ? \"Cost consolidated by 4-digit code\" : \"Cost by code + manual production\"}</h3><button type=\"button\" className={consolidated ? \"consolidate-button active\" : \"consolidate-button\"} onClick={() => setConsolidated(!consolidated)}>{consolidated ? \"✓ Consolidated · Show detail\" : \"Consolidate by 4-digit code\"}</button></div><div><span><small>LABOR</small><b>{money(totalLabor, 2)}</b></span><span><small>EQUIPMENT</small><b>{money(totalEquipment, 2)}</b></span><span className=\"total\"><small>TOTAL ACTUAL COST</small><b>{money(totalLabor + totalEquipment, 2)}</b></span></div></div>\n <div className=\"cost-code-scroll\"><div className=\"cost-code-row cost-code-head\"><span>COST CODE</span><span>LABOR COST</span><span>EQUIPMENT COST</span><span>TOTAL COST</span><span>PRODUCTION</span><span>ACTUAL / TARGET</span></div>\n {displayedRows.length === 0 && <div className=\"empty-state compact\"><b>No actual costs yet</b><span>Upload a BusyBusy Excel time sheet to populate cost codes.</span></div>}\n {displayedRows.map((r) => { const code = consolidated ? fourDigitCode(r.costCode) : r.costCode; const exact = production[code]; const matched = Object.entries(production).find(([k]) => k.startsWith(r.costCode.split(\" - \")[0] + \" - \"))?.[1]; const children = consolidated ? Object.entries(production).filter(([key, value]) => fourDigitCode(key) === code && Number(value.qty) > 0).map(([, value]) => value) : []; const units = [...new Set(children.map((value) => value.unit))]; const rolled = children.length && units.length === 1 ? { qty: String(children.reduce((s, v) => s + Number(v.qty), 0)), unit: units[0], note: \"Rolled up from detailed production\" } : undefined; const p = exact ?? rolled ?? matched ?? { qty: \"\", unit: \"LF\" }; const qty = Number(p.qty); const cpU = qty ? r.totalCost / qty : 0;\n return <div className=\"cost-code-row\" key={r.costCode}><span><b>{r.costCode}</b><small>{r.laborHours + r.operatorHours + r.foremanHours} labor hrs · {r.equipmentHours} equipment hrs{consolidated ? \" · grouped by first 4 digits\" : \"\"}</small></span><span>{money(r.laborCost, 2)}</span><span>{money(r.equipmentCost, 2)}</span><span><b>{money(r.totalCost, 2)}</b></span><span className=\"production-input\"><input type=\"number\" min=\"0\" step=\".01\" placeholder=\"Enter qty\" value={p.qty} onChange={(e) => setProduction({ ...production, [code]: { ...p, qty: e.target.value } })} /><select value={p.unit} onChange={(e) => setProduction({ ...production, [code]: { ...p, unit: e.target.value } })}>{UNITS.map((u) => <option key={u}>{u}</option>)}</select>{p.note && <small className=\"scope-note\">{p.note}</small>}</span><span className={qty ? \"unit-cost\" : \"pending-unit\"}>{qty ? <><b>{money(cpU, 2)} <small>/ {p.unit}</small></b>{p.targetCost && <small>Target {money(p.targetCost, 2)} / {p.unit}</small>}</> : <em>Awaiting production</em>}</span></div>;\n })}\n </div>\n </section>;\n}\nfunction UnitCostView({ rows, production, setProduction, consolidateCodes, setConsolidateCodes }: {\n rows: CostRow[]; production: Record<string, ProductionValue>; setProduction: (v: Record<string, ProductionValue>) => void; consolidateCodes: boolean; setConsolidateCodes: (v: boolean) => void;\n}) {\n const measured = rows.filter((r) => { const p = production[r.costCode] ?? Object.entries(production).find(([k]) => k.startsWith(r.costCode.split(\" - \")[0] + \" - \"))?.[1]; return Number(p?.qty) > 0; });\n return <><section className=\"unit-summary\"><article><p>MEASURED COST CODES</p><h2>{measured.length}</h2><span>with installed production</span></article><article><p>AWAITING QUANTITY</p><h2>{rows.length - measured.length}</h2><span>cost codes need LF or EA</span></article><article><p>VISTA TARGETS</p><h2>{Object.values(production).filter((p) => p.targetCost).length}</h2><span>target unit costs loaded</span></article></section>\n <CostCodeTable rows={rows} production={production} setProduction={setProduction} consolidated={consolidateCodes} setConsolidated={setConsolidateCodes} />\n </>;\n}\n\n// ---------- Forecast / reports ----------\nfunction JobCostForecast({ actualCost, settings, setSettings }: { actualCost: number; settings: Forecast; setSettings: (v: Forecast) => void }) {\n const budget = Number(settings.budget), completion = Math.min(100, Math.max(0, Number(settings.completion)));\n const ready = budget > 0 && completion > 0;\n const budgetUsed = budget > 0 ? actualCost / budget * 100 : 0;\n const projected = ready ? actualCost / (completion / 100) : 0;\n const variance = ready ? budget - projected : 0;\n const variancePercent = ready ? Math.abs(variance) / budget * 100 : 0;\n const state = !ready ? \"setup\" : variance >= 0 ? \"on-track\" : variancePercent <= 5 ? \"watch\" : \"over\";\n const label = state === \"setup\" ? \"ADD BUDGET + PROGRESS\" : state === \"on-track\" ? \"ON TRACK\" : state === \"watch\" ? \"WATCH\" : \"PROJECTED OVER BUDGET\";\n return <article className={`panel forecast-card ${state}`}><div className=\"forecast-head\"><div><p>JOB COST FORECAST</p><h3>Budget health + projected finish</h3></div><span>{label}</span></div>\n <div className=\"forecast-inputs\"><label><small>COST BUDGET</small><div><i>$</i><input type=\"number\" min=\"0\" step=\"100\" placeholder=\"Enter budget\" value={settings.budget} onChange={(e) => setSettings({ ...settings, budget: e.target.value })} /></div></label><label><small>ESTIMATED JOB COMPLETION</small><div><input type=\"number\" min=\"0\" max=\"100\" step=\"1\" placeholder=\"0\" value={settings.completion} onChange={(e) => setSettings({ ...settings, completion: e.target.value })} /><i>%</i></div></label></div>\n <div className=\"forecast-bars\"><div><span><small>JOB COMPLETION</small><b>{completion.toFixed(0)}%</b></span><i><em style={{ width: `${completion}%` }} /></i></div><div><span><small>BUDGET SPENT</small><b>{budget > 0 ? `${budgetUsed.toFixed(0)}%` : \"—\"}</b></span><i><em className={budgetUsed > 100 ? \"over\" : undefined} style={{ width: `${Math.min(100, budgetUsed)}%` }} /></i></div></div>\n {ready ? <div className=\"forecast-result\"><span><small>ACTUAL COST TO DATE</small><b>{money(actualCost, 2)}</b></span><span><small>PROJECTED FINAL COST</small><b>{money(projected, 2)}</b></span><span className={variance >= 0 ? \"positive\" : \"negative\"}><small>PROJECTED VARIANCE</small><b>{variance >= 0 ? `${money(variance, 2)} under` : `${money(Math.abs(variance), 2)} over`}</b><em>{variancePercent.toFixed(1)}% of budget</em></span></div> : <div className=\"forecast-empty\"><b>Enter the job’s cost budget and estimated completion.</b><span>The forecast will compare how much work is complete against how much budget has been spent.</span></div>}\n </article>;\n}\nfunction ReportsView({ job, totals, total, rows, production }: { job: Job | null; totals: { hours: number; labor: number; equipment: number }; total: number; rows: CostRow[]; production: Record<string, ProductionValue> }) {\n const ranked = rows.filter((r) => r.totalCost > 0).slice().sort((a, b) => b.totalCost - a.totalCost).slice(0, 5);\n return <section className=\"report-view\">\n <article className=\"panel report-cover\"><p>EXECUTIVE PRODUCTION REPORT</p><h2>{job?.name ?? \"No job selected\"}</h2><span>Current imported labor, equipment, and installed-unit cost summary</span>\n <div className=\"report-kpis\"><div><small>TOTAL COST</small><b>{money(total, 2)}</b></div><div><small>LABOR HOURS</small><b>{totals.hours.toFixed(1)}</b></div><div><small>LABOR COST</small><b>{money(totals.labor, 2)}</b></div><div><small>EQUIPMENT COST</small><b>{money(totals.equipment, 2)}</b></div></div>\n </article>\n <article className=\"panel report-rank\"><div className=\"view-head\"><div><p>TOP COST CODES</p><h3>Largest actual costs</h3></div></div>\n {ranked.map((r, i) => { const p = production[r.costCode]; const qty = Number(p?.qty); return <div className=\"rank-row\" key={r.costCode}><i>{i + 1}</i><span><b>{r.costCode}</b><small>{qty ? `${money(r.totalCost / qty, 2)} / ${p.unit}` : \"Production quantity not entered\"}</small></span><strong>{money(r.totalCost, 2)}</strong></div>; })}\n {ranked.length === 0 && <div className=\"empty-state compact\"><b>No cost data yet</b><span>Upload a BusyBusy time sheet to populate the report.</span></div>}\n <div className=\"report-print\"><button className=\"gold\" onClick={() => window.print()}>⇩ Print / save PDF</button></div>\n </article>\n </section>;\n}\n\nfunction Title({ title, onClick }: { title: string; onClick: () => void }) {\n return <div className=\"title\"><div><h3>{title}</h3></div><button type=\"button\" onClick={onClick}>View details →</button></div>;\n}\nfunction Kpi({ icon, label, value, note, accent = false }: { icon: string; label: string; value: string; note: string; accent?: boolean }) {\n return <article className={accent ? \"accent\" : \"\"}><i>{icon}</i><p>{label}</p><h2>{value}</h2><span>{note}</span></article>;\n}\n\n// ---------- Migration checklist ----------\nfunction MigrationChecklist({ user }: { user: User }) {\n const items: { label: string; done: boolean; detail: string }[] = [\n { label: \"Database migrations\", done: true, detail: \"users, sessions, approved emails, jobs, job labor rates, job data, Monday snapshots, uploaded-file metadata.\" },\n { label: \"Email login + secure sessions\", done: true, detail: \"HTTP-only, Secure, SameSite session cookies; PBKDF2-hashed passwords.\" },\n { label: \"Approved-email allowlist + roles\", done: true, detail: \"admin / user roles enforced on all data APIs.\" },\n { label: \"First-run admin setup\", done: true, detail: \"Owner configures the initial admin before any data loads.\" },\n { label: \"Job creation, selection, editing, deletion\", done: true, detail: \"Admin-managed job CRUD persisted to scoped SQLite.\" },\n { label: \"Per-job labor / operator / foreman rates\", done: true, detail: \"Saved per job with standard defaults.\" },\n { label: \"Vista TXT target import\", done: true, detail: \"Browser-side parsing; targets saved in the job's production map.\" },\n { label: \"BusyBusy Excel labor & equipment import\", done: true, detail: \"SheetJS in the browser; original file stored to scoped Blob Storage.\" },\n { label: \"Cost-code consolidation by first 4 digits\", done: true, detail: \"1201.2 + 1201.3 → 1201; toggle shown in the cost-code table.\" },\n { label: \"Equipment usage, crew size, phase-code views\", done: true, detail: \"Most-used equipment, crew-by-day, expandable phase-code breakdown.\" },\n { label: \"Equipment-move tracking (phase 1101)\", done: true, detail: \"Driver labor + hauling truck cost, no charge for the transported machine.\" },\n { label: \"Manual production + cost-per-unit\", done: true, detail: \"Enter quantities per cost code; actual/target unit-cost compare.\" },\n { label: \"Reports & print/PDF view\", done: true, detail: \"Executive report cover + top cost codes; print stylesheet.\" },\n { label: \"Permanent job-based storage\", done: true, detail: \"Job data in scoped SQLite; original files in scoped Blob Storage, associated by job.\" },\n { label: \"Monday.com connection\", done: true, detail: \"Integrated & reachable (board discovery, column mapping, Completed filter, item-id upsert, snapshots, Refresh button).\" },\n { label: \"Monday.com live sync\", done: false, detail: \"Awaiting a valid MONDAY_TOKEN — the currently configured token is rejected by Monday (401), so no jobs have been imported yet.\" },\n ];\n const doneCount = items.filter((i) => i.done).length;\n return <section className=\"panel migration-panel\">\n <div className=\"view-head\"><div><p>MIGRATION CHECKLIST</p><h3>Val Town staging — {doneCount}/{items.length} complete</h3></div><span className=\"source-pill\">AUTHENTICATED · {user.role.toUpperCase()}</span></div>\n <div className=\"migration-list\">{items.map((item) => <div className={`migration-row ${item.done ? \"done\" : \"\"}`} key={item.label}><i>{item.done ? \"✓\" : \"○\"}</i><span><b>{item.label}</b><small>{item.detail}</small></span></div>)}</div>\n <div className=\"migration-note\"><b>Remaining for Monday.com:</b> replace <code>MONDAY_TOKEN</code> with a valid token, then click <b>Refresh</b> to import the Utility Schedule. The full equipment-rate tail re-import may also be needed for production matching.</div>\n </section>;\n}\n","label",[306,82],"frontend","pulls","branches",1,"forks","envVars",{"_315":317,"_318":26},"connections",{"_315":26,"_316":26},"count","unfilledCount",3,"emptyCount",{"_49":422,"_13":306,"_80":297,"_59":-5,"_51":52,"_298":399,"_299":236,"_53":423,"_55":26,"_83":391,"_302":-5,"_85":24,"_304":-5,"_338":424,"_17":425},{"_49":296,"_13":82,"_80":81,"_59":297,"_51":52,"_298":217,"_299":236,"_53":419,"_55":301,"_83":84,"_302":303,"_85":24,"_304":-5,"_338":420,"_17":421},{"_49":411,"_13":412,"_80":413,"_59":297,"_51":52,"_298":414,"_299":236,"_53":415,"_55":26,"_83":84,"_302":416,"_85":24,"_304":-5,"_338":417,"_17":418},{"_49":403,"_13":404,"_80":405,"_59":297,"_51":52,"_298":406,"_299":236,"_53":407,"_55":26,"_83":84,"_302":408,"_85":24,"_304":-5,"_338":409,"_17":410},{"_49":394,"_13":395,"_80":396,"_59":297,"_51":52,"_298":397,"_299":236,"_53":398,"_55":399,"_83":21,"_302":400,"_85":24,"_304":-5,"_338":401,"_17":402},{"_49":387,"_13":388,"_80":389,"_59":-5,"_51":52,"_298":301,"_299":236,"_53":390,"_55":26,"_83":391,"_302":-5,"_85":24,"_304":-5,"_338":392,"_17":393},{"_49":379,"_13":380,"_80":381,"_59":-5,"_51":52,"_298":382,"_299":236,"_53":383,"_55":317,"_83":21,"_302":384,"_85":24,"_304":-5,"_338":385,"_17":386},{"_49":372,"_13":373,"_80":374,"_59":-5,"_51":52,"_298":317,"_299":236,"_53":375,"_55":26,"_83":84,"_302":376,"_85":24,"_304":-5,"_338":377,"_17":378},{"_49":364,"_13":365,"_80":366,"_59":-5,"_51":52,"_298":367,"_299":236,"_53":368,"_55":317,"_83":84,"_302":369,"_85":24,"_304":-5,"_338":370,"_17":371},{"_49":357,"_13":358,"_80":359,"_59":-5,"_51":52,"_298":351,"_299":236,"_53":360,"_55":26,"_83":84,"_302":361,"_85":24,"_304":-5,"_338":362,"_17":363},{"_49":347,"_13":348,"_80":234,"_59":-5,"_51":52,"_298":349,"_299":236,"_53":350,"_55":351,"_83":352,"_302":353,"_85":24,"_304":354,"_338":355,"_17":356},{"_49":341,"_13":342,"_80":343,"_59":-5,"_51":52,"_298":309,"_299":236,"_53":344,"_55":26,"_83":84,"_302":88,"_85":24,"_304":-5,"_338":345,"_17":346},{"_49":332,"_13":333,"_80":334,"_59":-5,"_51":52,"_298":335,"_299":236,"_53":336,"_55":309,"_83":84,"_302":337,"_85":24,"_304":-5,"_338":339,"_17":340},"0fc916f7-c58e-4779-aaa9-6a7100895d32","monday.ts","3c282dc8-a814-11f1-ac25-1607ee4eb77e",44,["D",1788494111282],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n/**\n * Monday.com Utility Schedule integration (server-side).\n *\n * The MONDAY_TOKEN is read ONLY from the environment and is never returned,\n * logged, or exposed to the browser. All error messages are generic — they\n * never include the token.\n */\n\nconst MONDAY_API = \"https://api.monday.com/v2\";\nconst MONDAY_API_VERSION = \"2023-10\";\nconst UTILITY_RE = /utility\\s*schedule/i;\n\nexport interface MondayColumn {\n id: string;\n title: string;\n type: string;\n}\nexport interface MondayGroup {\n id: string;\n title: string;\n}\nexport interface BoardMeta {\n id: string;\n name: string;\n groups: MondayGroup[];\n columns: MondayColumn[];\n}\nexport interface SyncResult {\n ok: boolean;\n error?: string;\n added: number;\n updated: number;\n ignoredCompleted: number;\n totalItems: number;\n jobs: { id: number; name: string }[];\n}\n\n/** Run a Monday GraphQL query. Never surfaces the token in any error. */\nasync function mondayGraphQL(token: string, query: string, variables: Record<string, unknown> = {}) {\n const res = await fetch(MONDAY_API, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": `Bearer ${token}`,\n \"API-Version\": MONDAY_API_VERSION,\n },\n body: JSON.stringify({ query, variables }),\n });\n if (!res.ok) {\n throw new Error(\"Unable to reach Monday.com. Check that the board access is configured.\");\n }\n const body = await res.json();\n if (body.errors && body.errors.length) {\n const msg = String(body.errors[0]?.message ?? \"Monday.com request failed\");\n if (/authentication|authorization|invalid.*token|unauthorized/i.test(msg)) {\n throw new Error(\"Monday.com authentication failed. The connection token is invalid or expired.\");\n }\n throw new Error(\"Monday.com returned an error for this request.\");\n }\n return body.data;\n}\n\n/** Accessible boards the token can read (read-only). */\nexport async function listBoards(token: string): Promise<{ id: string; name: string }[]> {\n const data = await mondayGraphQL(token, `query { boards(limit: 100) { id name } }`);\n return (data?.boards ?? []) as { id: string; name: string }[];\n}\n\n/** Discover the Utility Schedule board id by name. */\nexport async function discoverUtilityBoardId(token: string): Promise<{ boardId: string | null; name: string | null; error?: string }> {\n const explicit = Deno.env.get(\"MONDAY_BOARD_ID\");\n if (explicit && /^\\d+$/.test(explicit)) {\n return { boardId: explicit, name: null };\n }\n try {\n const boards = await listBoards(token);\n const match = boards.find((b) => UTILITY_RE.test(b.name));\n if (match) return { boardId: match.id, name: match.name };\n return { boardId: null, name: null, error: \"No Utility Schedule board was found for this account.\" };\n } catch (err) {\n return { boardId: null, name: null, error: err instanceof Error ? err.message : \"Unable to read Monday.com.\" };\n }\n}\n\n/** Fetch board groups and columns (the metadata used for validation/mapping). */\nexport async function fetchBoardMeta(token: string, boardId: string): Promise<{ meta: BoardMeta | null; error?: string }> {\n const query = `query BoardMeta($boardId: ID!) {\n boards(ids: [$boardId]) {\n id name\n groups { id title }\n columns { id title type }\n }\n }`;\n try {\n const data = await mondayGraphQL(token, query, { boardId });\n const board = data?.boards?.[0];\n if (!board) return { meta: null, error: \"The configured Monday board could not be found.\" };\n const meta: BoardMeta = {\n id: board.id,\n name: board.name,\n groups: board.groups ?? [],\n columns: board.columns ?? [],\n };\n return { meta };\n } catch (err) {\n return { meta: null, error: err instanceof Error ? err.message : \"Unable to read Monday board metadata.\" };\n }\n}\n\n/** Normalise a group title for the Completed. filter. */\nfunction normalized(title: string): string {\n return title.trim().toLowerCase().replace(/\\.+$/, \"\").trim();\n}\nconst isCompletedGroup = (title: string): boolean => normalized(title) === \"completed\";\n\n/** Map Monday columns to job fields by matching their titles. */\ntype FieldKey =\n | \"job_number\" | \"status\" | \"superintendent\" | \"project_manager\" | \"estimator\"\n | \"location\" | \"jurisdiction\" | \"general_contractor\" | \"foreman\"\n | \"prevailing_wage\" | \"permit_number\";\n\nconst RULES: [FieldKey, RegExp][] = [\n [\"job_number\", /job\\s*#|job\\s*numb|job\\s*id|jobno/i],\n [\"status\", /^\\s*status\\s*$/i],\n [\"superintendent\", /superintend/i],\n [\"project_manager\", /project\\s*manager|^project$|^pm\\b/i],\n [\"estimator\", /estimator/i],\n [\"location\", /location|site\\s*address|city/i],\n [\"jurisdiction\", /jurisdiction/i],\n [\"general_contractor\", /general\\s*contractor|^gc\\b|contractor/i],\n [\"foreman\", /foreman/i],\n [\"prevailing_wage\", /prevailing|prev\\s*wage/i],\n [\"permit_number\", /permit/i],\n];\n\nfunction buildFieldMap(columns: MondayColumn[]): Record<FieldKey, string | null> {\n const map = {} as Record<FieldKey, string | null>;\n for (const key of Object.keys(RULES) as FieldKey[]) map[key] = null;\n // Assign each column to the first matching field (longest group first).\n const used = new Set<FieldKey>();\n const ordered = [...columns].sort((a, b) => b.title.length - a.title.length);\n for (const col of ordered) {\n for (const [key, re] of RULES) {\n if (!used.has(key) && re.test(col.title)) {\n map[key] = col.id;\n used.add(key);\n break;\n }\n }\n }\n return map;\n}\n\nfunction colText(values: { column: { id: string }; text?: string | null }[], columnId: string | null): string {\n if (!columnId) return \"\";\n const v = values.find((x) => x.column?.id === columnId);\n if (!v) return \"\";\n const t = String(v.text ?? \"\").trim();\n if (t === \"{}\" || t === \"[]\" || t === \"false\") return \"\";\n return t;\n}\n\n/**\n * Import the Utility Schedule board. This is the write operation — callers\n * that only want to validate the connection should use fetchBoardMeta instead.\n */\nexport async function syncUtilitySchedule(token: string): Promise<SyncResult> {\n const empty: SyncResult = { ok: false, added: 0, updated: 0, ignoredCompleted: 0, totalItems: 0, jobs: [] };\n\n const discovered = await discoverUtilityBoardId(token);\n if (discovered.error || !discovered.boardId) {\n return { ...empty, error: discovered.error ?? \"No Utility Schedule board is configured.\" };\n }\n\n const query = `query BoardItems($boardId: ID!) {\n boards(ids: [$boardId]) {\n id name\n columns { id title }\n items_page(limit: 500) {\n cursor\n items {\n id name url\n group { id title }\n column_values { column { id } text }\n }\n }\n }\n }`;\n\n let data;\n try {\n data = await mondayGraphQL(token, query, { boardId: discovered.boardId });\n } catch (err) {\n return { ...empty, error: err instanceof Error ? err.message : \"Unable to load the Utility Schedule board.\" };\n }\n const board = data?.boards?.[0];\n const items = board?.items_page?.items ?? [];\n const columns: MondayColumn[] = board?.columns ?? [];\n const fieldMap = buildFieldMap(columns);\n\n let added = 0;\n let updated = 0;\n let ignoredCompleted = 0;\n const jobs: { id: number; name: string }[] = [];\n\n for (const item of items) {\n const groupTitle = String(item.group?.title ?? \"\").trim();\n if (isCompletedGroup(groupTitle)) {\n ignoredCompleted += 1;\n continue;\n }\n const itemId = String(item.id);\n const values = item.column_values ?? [];\n const text = (col: string | null) => colText(values, col);\n const fields: Record<string, string> = {\n name: String(item.name ?? \"\").trim() || \"Untitled Utility Job\",\n job_number: text(fieldMap.job_number),\n status: text(fieldMap.status),\n superintendent: text(fieldMap.superintendent),\n project_manager: text(fieldMap.project_manager),\n estimator: text(fieldMap.estimator),\n location: text(fieldMap.location),\n jurisdiction: text(fieldMap.jurisdiction),\n general_contractor: text(fieldMap.general_contractor),\n foreman: text(fieldMap.foreman),\n prevailing_wage: text(fieldMap.prevailing_wage),\n permit_number: text(fieldMap.permit_number),\n schedule_group: groupTitle,\n monday_url: String(item.url ?? \"\").trim(),\n };\n\n // Look for an existing synced job by its permanent Monday item id.\n const existing = await sqlite.execute(\n `SELECT id FROM jobs WHERE monday_item_id = ? AND source = 'monday'`,\n [itemId],\n );\n if (existing.rows.length > 0) {\n const jobId = Number((existing.rows[0] as { id: number }).id);\n const cols = Object.keys(fields).map((k) => `${k} = ?`).join(\", \");\n const args = Object.values(fields).concat([jobId]);\n await sqlite.execute(`UPDATE jobs SET ${cols} WHERE id = ?`, args);\n jobs.push({ id: jobId, name: fields.name });\n updated += 1;\n } else {\n // Insert a new Monday-sourced job. Never overwrites manual jobs.\n const result = await sqlite.execute(\n `INSERT INTO jobs (name, source, monday_item_id, job_number, status, superintendent,\n project_manager, estimator, location, jurisdiction, general_contractor, foreman,\n prevailing_wage, permit_number, schedule_group, monday_url)\n VALUES (?, 'monday', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n fields.name, itemId, fields.job_number, fields.status, fields.superintendent,\n fields.project_manager, fields.estimator, fields.location, fields.jurisdiction,\n fields.general_contractor, fields.foreman, fields.prevailing_wage, fields.permit_number,\n fields.schedule_group, fields.monday_url,\n ],\n );\n jobs.push({ id: Number(result.lastInsertRowid), name: fields.name });\n added += 1;\n }\n }\n\n return { ok: true, added, updated, ignoredCompleted, totalItems: items.length, jobs };\n}\n\n/** Record a refresh snapshot into monday_snapshots. */\nexport async function recordSnapshot(summary: Omit<SyncResult, \"ok\">, tokenConfigured: boolean): Promise<void> {\n await sqlite.execute(\n `INSERT INTO monday_snapshots (jobs_json) VALUES (?)`,\n [JSON.stringify({ ...summary, tokenConfigured, source: \"monday\" })],\n );\n}\n\n/** Most recent refresh info for display. */\nexport async function lastRefresh(): Promise<{ fetchedAt: string | null; summary: Record<string, unknown> | null }> {\n const rows = await sqlite.execute(`SELECT fetched_at, jobs_json FROM monday_snapshots ORDER BY id DESC LIMIT 1`);\n if (rows.rows.length === 0) return { fetchedAt: null, summary: null };\n const row = rows.rows[0] as { fetched_at: string; jobs_json: string };\n let summary: Record<string, unknown> | null = null;\n try { summary = JSON.parse(row.jobs_json); } catch { summary = null; }\n return { fetchedAt: row.fetched_at, summary };\n}\n/** Expose which board column title maps to each job field (for metadata display). */\nexport function resolveColumnMapping(columns: MondayColumn[]): Record<string, string> {\n const map = buildFieldMap(columns);\n const out: Record<string, string> = {};\n for (const key of Object.keys(map) as FieldKey[]) {\n const id = map[key];\n const col = columns.find((c) => c.id === id);\n out[key] = col ? col.title : \"\";\n }\n return out;\n}\n","children",[],[333],"0ba39e2b-78ae-4125-8280-9482a4fdad83","main.ts","c4e2e564-a7af-11f1-b820-1607ee4eb77e",["D",1788450878935],[],[342],"24eddea0-7cc7-49fa-b1b1-f282eba6dccb","index.ts",46,["D",1788494129082],4,"http","import { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport type { Context, Next } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { ready } from \"./db.ts\";\nimport {\n hashPassword,\n verifyPassword,\n createSession,\n sessionCookieHeader,\n clearCookieHeader,\n getSessionUser,\n requireAuth,\n requireAdmin,\n} from \"./auth.ts\";\nimport type { User } from \"./auth.ts\";\nimport { equipmentRates } from \"./equipmentRates.ts\";\nimport {\n discoverUtilityBoardId,\n fetchBoardMeta,\n resolveColumnMapping,\n syncUtilitySchedule,\n recordSnapshot,\n lastRefresh,\n} from \"./monday.ts\";\nimport { Root } from \"./frontend/root.tsx\";\n\nawait ready;\n\nconst app = new Hono();\n\nfunction getU(c: Context): User {\n return c.get<User>(\"user\");\n}\n\nconst authed = (c: Context, next: Next) => requireAuth(c, next);\nconst admin = (c: Context, next: Next) => requireAdmin(c, next);\n\nconst DEFAULT_RATES = { labor: 45, operator: 55, foreman: 65 };\nconst MAX_FILE_BYTES = 25 * 1024 * 1024; // 25 MB\n\nconst ALLOWED_EXT: Record<string, \"vista-target\" | \"timesheet\"> = {\n \".txt\": \"vista-target\",\n \".text\": \"vista-target\",\n \".xlsx\": \"timesheet\",\n \".xls\": \"timesheet\",\n};\n\nfunction jobSelect(fields: string[]): string {\n return fields.map((f) => `j.${f}`).join(\", \");\n}\n\n// ---- Frontend ----\napp.get(\"/\", (c) => c.html(Root()));\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// ---- Auth + bootstrap (Phase 1, unchanged) ----\napp.get(\"/api/bootstrap\", async (c) => {\n const rows = await sqlite.execute(`SELECT COUNT(*) AS n FROM users`);\n const userCount = Number((rows.rows[0] as { n: number }).n);\n if (userCount === 0) return c.json({ state: \"setup\" });\n const user = await getSessionUser(c.req.raw);\n if (user) return c.json({ state: \"authed\", user });\n return c.json({ state: \"login\" });\n});\n\napp.post(\"/api/setup\", async (c) => {\n const rows = await sqlite.execute(`SELECT COUNT(*) AS n FROM users`);\n if (Number((rows.rows[0] as { n: number }).n) > 0) {\n return c.json({ error: \"Setup already complete. Sign in instead.\" }, 400);\n }\n const body = await c.req.json().catch(() => ({}));\n const email = String(body.email ?? \"\").trim().toLowerCase();\n const password = String(body.password ?? \"\");\n if (!/^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/.test(email)) {\n return c.json({ error: \"A valid email is required.\" }, 400);\n }\n if (password.length < 8) {\n return c.json({ error: \"Password must be at least 8 characters.\" }, 400);\n }\n const { salt, hash } = await hashPassword(password);\n await sqlite.batch([\n { sql: `INSERT INTO approved_emails (email, role) VALUES (?, 'admin')`, args: [email] },\n { sql: `INSERT INTO users (email, role, password_salt, password_hash) VALUES (?, 'admin', ?, ?)`, args: [email, salt, hash] },\n ]);\n return c.json({ ok: true });\n});\n\napp.post(\"/api/login\", async (c) => {\n const body = await c.req.json().catch(() => ({}));\n const email = String(body.email ?? \"\").trim().toLowerCase();\n const password = String(body.password ?? \"\");\n const rows = await sqlite.execute(\n `SELECT id, email, role, password_salt, password_hash FROM users WHERE lower(email) = ?`,\n [email],\n );\n if (rows.rows.length === 0) return c.json({ error: \"Invalid email or password.\" }, 401);\n const row = rows.rows[0] as {\n id: number; email: string; role: string; password_salt: string | null; password_hash: string | null;\n };\n if (!row.password_salt || !row.password_hash) return c.json({ error: \"This user has no password set.\" }, 401);\n const ok = await verifyPassword(password, row.password_salt, row.password_hash);\n if (!ok) return c.json({ error: \"Invalid email or password.\" }, 401);\n const { token, expiresAt } = await createSession(Number(row.id));\n c.header(\"Set-Cookie\", sessionCookieHeader(token, expiresAt));\n return c.json({ user: { id: Number(row.id), email: row.email, role: row.role } });\n});\n\napp.post(\"/api/logout\", async (c) => {\n c.header(\"Set-Cookie\", clearCookieHeader);\n return c.json({ ok: true });\n});\n\n/**\n * Administrator password recovery.\n *\n * Security rules:\n * - The recovery code is read ONLY from the ADMIN_RECOVERY_CODE env var;\n * it is never hardcoded, displayed, or logged.\n * - Requires the existing administrator email + the recovery code + the new\n * password entered twice.\n * - The new password is hashed with the same PBKDF2 system as normal sign-in.\n * - On success, all existing sessions for that administrator are invalidated\n * so any open session must sign in again.\n */\napp.post(\"/api/recover\", async (c) => {\n const expectedCode = Deno.env.get(\"ADMIN_RECOVERY_CODE\");\n const body = await c.req.json().catch(() => ({}));\n const email = String(body.email ?? \"\").trim().toLowerCase();\n const code = String(body.code ?? \"\");\n const password = String(body.password ?? \"\");\n const confirm = String(body.confirm ?? \"\");\n\n if (!expectedCode) {\n return c.json({ error: \"Password recovery is not configured. Contact the administrator.\" }, 500);\n }\n\n // Generic failures — never reveal whether the email or the code was wrong.\n const fail = () => c.json({ error: \"Unable to reset the password. Check your email and recovery code, then try again.\" }, 401);\n\n if (!email || password.length < 8 || password !== confirm) {\n return c.json({ error: \"Enter your administrator email, a new password of at least 8 characters, and confirm it.\" }, 400);\n }\n\n // Timing-safe comparison of the recovery code.\n const a = new Uint8Array(new TextEncoder().encode(code));\n const b = new Uint8Array(new TextEncoder().encode(expectedCode));\n let diff = a.length === b.length ? 0 : 1;\n const len = Math.max(a.length, b.length);\n for (let i = 0; i < len; i++) {\n const av = i < a.length ? a[i] : 0;\n const bv = i < b.length ? b[i] : 0;\n diff |= av ^ bv;\n }\n if (diff !== 0) return fail();\n\n const rows = await sqlite.execute(\n `SELECT id FROM users WHERE lower(email) = ? AND role = 'admin'`,\n [email],\n );\n if (rows.rows.length === 0) return fail();\n const userId = Number((rows.rows[0] as { id: number }).id);\n\n const { salt, hash } = await hashPassword(password);\n await sqlite.batch([\n {\n sql: `UPDATE users SET password_salt = ?, password_hash = ? WHERE id = ?`,\n args: [salt, hash, userId],\n },\n // Invalidate every session for this administrator.\n { sql: `DELETE FROM sessions WHERE user_id = ?`, args: [userId] },\n ]);\n\n return c.json({ ok: true });\n});\n\n// ---- Jobs CRUD ----\n\nasync function getJobRow(id: number) {\n const rows = await sqlite.execute(\n `SELECT id, name, source, job_number, status, superintendent, project_manager,\n estimator, location, jurisdiction, general_contractor, foreman,\n prevailing_wage, permit_number, schedule_group, monday_url\n FROM jobs WHERE id = ?`,\n [id],\n );\n return rows.rows[0] ?? null;\n}\n\napp.get(\"/api/jobs\", authed, async (c) => {\n const rows = await sqlite.execute(\n `SELECT id, name, source, job_number, status, superintendent, project_manager,\n estimator, location, jurisdiction, general_contractor, foreman,\n prevailing_wage, permit_number, schedule_group, monday_url, created_at\n FROM jobs ORDER BY name`,\n );\n return c.json({ jobs: rows.rows });\n});\n\napp.post(\"/api/jobs\", authed, admin, async (c) => {\n const body = await c.req.json().catch(() => ({}));\n const name = String(body.name ?? \"\").trim();\n if (!name) return c.json({ error: \"Job name is required.\" }, 400);\n const me = getU(c);\n const result = await sqlite.execute(\n `INSERT INTO jobs (name, source, created_by) VALUES (?, 'manual', ?)`,\n [name, me.id],\n );\n const id = Number(result.lastInsertRowid);\n await sqlite.execute(\n `INSERT OR IGNORE INTO job_labor_rates (job_id, labor, operator, foreman, updated_at)\n VALUES (?, ?, ?, ?, datetime('now'))`,\n [id, DEFAULT_RATES.labor, DEFAULT_RATES.operator, DEFAULT_RATES.foreman],\n );\n const row = await getJobRow(id);\n return c.json({ job: row }, 201);\n});\n\napp.put(\"/api/jobs/:id\", authed, admin, async (c) => {\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.json().catch(() => ({}));\n const allowed = [\"name\", \"job_number\", \"status\", \"superintendent\", \"project_manager\", \"estimator\",\n \"location\", \"jurisdiction\", \"general_contractor\", \"foreman\", \"prevailing_wage\", \"permit_number\",\n \"schedule_group\", \"monday_url\"];\n for (const key of allowed) {\n if (body[key] !== undefined) {\n await sqlite.execute(`UPDATE jobs SET ${key} = ? WHERE id = ?`, [String(body[key]), id]);\n }\n }\n const row = await getJobRow(id);\n if (!row) return c.json({ error: \"Job not found.\" }, 404);\n return c.json({ job: row });\n});\n\napp.delete(\"/api/jobs/:id\", authed, admin, async (c) => {\n const id = Number(c.req.param(\"id\"));\n // Delete blobs first, then the cascading rows.\n const files = await sqlite.execute(`SELECT blob_key FROM job_files WHERE job_id = ?`, [id]);\n for (const f of files.rows) {\n try { await blob.delete(f.blob_key as string); } catch { /* ignore */ }\n }\n await sqlite.execute(`DELETE FROM job_files WHERE job_id = ?`, [id]);\n await sqlite.execute(`DELETE FROM jobs WHERE id = ?`, [id]);\n return c.json({ ok: true });\n});\n\n// ---- Per-job labor rates ----\n\napp.get(\"/api/jobs/:id/rates\", authed, async (c) => {\n const id = Number(c.req.param(\"id\"));\n const rows = await sqlite.execute(\n `SELECT labor, operator, foreman FROM job_labor_rates WHERE job_id = ?`,\n [id],\n );\n if (rows.rows.length === 0) return c.json({ rates: { ...DEFAULT_RATES }, isDefault: true });\n return c.json({ rates: rows.rows[0], isDefault: false });\n});\n\napp.put(\"/api/jobs/:id/rates\", authed, async (c) => {\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.json().catch(() => ({}));\n const labor = Number(body.labor ?? DEFAULT_RATES.labor);\n const operator = Number(body.operator ?? DEFAULT_RATES.operator);\n const foreman = Number(body.foreman ?? DEFAULT_RATES.foreman);\n await sqlite.execute(\n `INSERT INTO job_labor_rates (job_id, labor, operator, foreman, updated_at)\n VALUES (?, ?, ?, ?, datetime('now'))\n ON CONFLICT(job_id) DO UPDATE SET labor = excluded.labor, operator = excluded.operator,\n foreman = excluded.foreman, updated_at = datetime('now')`,\n [id, labor, operator, foreman],\n );\n return c.json({ rates: { labor, operator, foreman }, isDefault: false });\n});\n\n// ---- Job data (autosave) ----\n\nconst emptyJobData = {\n entries: [],\n production: {},\n actualRows: [],\n equipmentUsage: [],\n crewDays: [],\n phaseUsage: [],\n equipmentMoves: [],\n forecast: { budget: \"\", completion: \"\" },\n};\n\napp.get(\"/api/jobs/:id/data\", authed, async (c) => {\n const id = Number(c.req.param(\"id\"));\n const rows = await sqlite.execute(`SELECT data FROM job_data WHERE job_id = ?`, [id]);\n if (rows.rows.length === 0) return c.json({ data: emptyJobData });\n try {\n return c.json({ data: JSON.parse(rows.rows[0].data as string) });\n } catch {\n return c.json({ data: emptyJobData });\n }\n});\n\napp.put(\"/api/jobs/:id/data\", authed, async (c) => {\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.json().catch(() => ({}));\n const data = body.data ?? {};\n await sqlite.execute(\n `INSERT INTO job_data (job_id, data, updated_at) VALUES (?, ?, datetime('now'))\n ON CONFLICT(job_id) DO UPDATE SET data = excluded.data, updated_at = datetime('now')`,\n [id, JSON.stringify(data)],\n );\n return c.json({ ok: true });\n});\n\n// ---- File uploads (Vista target TXT / BusyBusy Excel) ----\n\nasync function storeFileParts(formData: FormData, jobId: number, user: User) {\n const saved: { filename: string; kind: string; size: number }[] = [];\n const errors: string[] = [];\n\n for (const [key, value] of formData.entries()) {\n if (!(value instanceof File)) continue;\n const file = value as File;\n const name = file.name ?? key;\n const ext = name.slice(name.lastIndexOf(\".\")).toLowerCase();\n const kind = ALLOWED_EXT[ext];\n if (!kind) {\n errors.push(`\"${name}\" is not an accepted file type. Use .txt for Vista targets or .xlsx/.xls for BusyBusy time sheets.`);\n continue;\n }\n if (file.size > MAX_FILE_BYTES) {\n errors.push(`\"${name}\" exceeds the 25 MB upload limit.`);\n continue;\n }\n const nonce = `${Date.now()}-${Math.random().toString(36).slice(2, 8)}`;\n const blobKey = `jobs/${jobId}/${kind}/${nonce}-${name}`;\n const bytes = new Uint8Array(await file.arrayBuffer());\n await blob.set(blobKey, bytes);\n await sqlite.execute(\n `INSERT INTO job_files (job_id, kind, filename, content_type, size, blob_key, uploaded_by, uploaded_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, datetime('now'))`,\n [jobId, kind, name, file.type || \"application/octet-stream\", file.size, blobKey, user.id],\n );\n saved.push({ filename: name, kind, size: file.size });\n }\n return { saved, errors };\n}\n\napp.post(\"/api/jobs/:id/files\", authed, async (c) => {\n const jobId = Number(c.req.param(\"id\"));\n const me = getU(c);\n const formData = await c.req.formData().catch(() => null);\n if (!formData) return c.json({ error: \"Invalid upload.\" }, 400);\n const { saved, errors } = await storeFileParts(formData, jobId, me);\n if (saved.length === 0) {\n return c.json({ error: errors.join(\" \") || \"No files uploaded.\" }, 400);\n }\n return c.json({ ok: true, saved, warnings: errors });\n});\n\napp.get(\"/api/jobs/:id/files\", authed, async (c) => {\n const id = Number(c.req.param(\"id\"));\n const rows = await sqlite.execute(\n `SELECT id, kind, filename, content_type, size, uploaded_at FROM job_files WHERE job_id = ? ORDER BY uploaded_at DESC`,\n [id],\n );\n return c.json({ files: rows.rows });\n});\n\n// ---- Equipment rates ----\napp.get(\"/api/equipment-rates\", authed, async (c) => {\n return c.json({ rates: equipmentRates, count: equipmentRates.length });\n});\n\n// ---- Monday.com (Utility Schedule) ----\nfunction mondayToken(): string | null {\n return Deno.env.get(\"MONDAY_TOKEN\") || null;\n}\n\n/** Connection status. Performs a lightweight, read-only check against Monday. */\napp.get(\"/api/monday-connection\", authed, async (c) => {\n const token = mondayToken();\n const last = await lastRefresh();\n if (!token) {\n return c.json({\n connected: false,\n configured: false,\n message: \"Monday.com not configured\",\n lastRefresh: last,\n });\n }\n const found = await discoverUtilityBoardId(token);\n if (found.error || !found.boardId) {\n // Safe, generic — never reveals credentials.\n return c.json({ connected: false, configured: true, message: found.error ?? \"No Utility Schedule board found\", lastRefresh: last });\n }\n return c.json({\n connected: true,\n configured: true,\n boardId: found.boardId,\n boardName: found.name ?? \"Utility Schedule\",\n message: `Connected · Utility Schedule board ${found.boardId}`,\n lastRefresh: last,\n });\n});\n\n/** Read-only board metadata (board id, name, groups, columns, field mapping). */\napp.get(\"/api/monday-board\", authed, async (c) => {\n const token = mondayToken();\n if (!token) return c.json({ error: \"Monday.com is not configured.\" }, 400);\n const found = await discoverUtilityBoardId(token);\n if (found.error || !found.boardId) {\n return c.json({ error: found.error ?? \"No Utility Schedule board found.\" }, 400);\n }\n const { meta, error } = await fetchBoardMeta(token, found.boardId);\n if (error || !meta) {\n return c.json({ error: error ?? \"Unable to read board metadata.\" }, 400);\n }\n return c.json({\n boardId: meta.id,\n boardName: meta.name,\n groups: meta.groups,\n columns: meta.columns,\n mapping: resolveColumnMapping(meta.columns),\n });\n});\n\n/** Functional Refresh: run the Utility Schedule import and store a snapshot. */\napp.post(\"/api/monday-refresh\", authed, admin, async (c) => {\n const token = mondayToken();\n if (!token) {\n return c.json({ ok: false, error: \"Monday.com is not configured. Add MONDAY_TOKEN first.\" }, 400);\n }\n const result = await syncUtilitySchedule(token);\n const summary = {\n error: result.error ?? null,\n added: result.added,\n updated: result.updated,\n ignoredCompleted: result.ignoredCompleted,\n totalItems: result.totalItems,\n jobs: result.jobs,\n };\n await recordSnapshot(summary, true);\n if (!result.ok) {\n return c.json({ ok: false, error: result.error ?? \"Unable to refresh Monday.com\" }, 400);\n }\n return c.json({ ok: true, ...summary, lastRefresh: new Date().toISOString() });\n});\n\n// ---- Migration status ----\napp.get(\"/api/migration-status\", authed, async (c) => {\n const users = (await sqlite.execute(`SELECT COUNT(*) AS n FROM users`)).rows[0] as { n: number };\n const jobs = (await sqlite.execute(`SELECT COUNT(*) AS n FROM jobs`)).rows[0] as { n: number };\n const mondayToken = Deno.env.get(\"MONDAY_TOKEN\");\n const last = await lastRefresh();\n return c.json({\n users: Number(users.n),\n jobs: Number(jobs.n),\n mondayTokenConfigured: Boolean(mondayToken),\n mondayConnected: Boolean(mondayToken) && Boolean(last.summary),\n lastRefresh: last,\n });\n});\n\n// Admin: manage approved users.\napp.get(\"/api/admin/users\", authed, admin, async (c) => {\n const approved = await sqlite.execute(\n `SELECT id, email, role, created_at FROM approved_emails ORDER BY email`,\n );\n return c.json({ approved: approved.rows });\n});\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","ndx-command-center",[],[348],"e0a3d028-1a1e-42fb-930b-28f93ae6d0ca","equipmentRates.ts","b7729c34-a7d3-11f1-8201-1607ee4eb77e",["D",1788466317861],"export type EquipmentRate = { label: string; rate: number };\n\n/**\n * Hourly operating rates imported from Rates by Equipment.pdf (08/14/26).\n *\n * NOTE: The migration source captured most of this list but was truncated at\n * entry \"5103\". The remaining plate-compactor / small-tool entries should be\n * reconciled from the original PDF before production use. This staging copy\n * carries the entries present in the source.\n */\nexport const equipmentRates: EquipmentRate[] = [\n { label: \"001 2013 Ram Truck 3500 ST\", rate: 100.00 },\n { label: \"002 2014 A Double Cab SR/SRS\", rate: 100.00 },\n { label: \"003 2003 F250 Super Duty\", rate: 100.00 },\n { label: \"004 2016 Ram 2500 Laramie\", rate: 100.00 },\n { label: \"005 2017 Ram 3500 Laramie\", rate: 100.00 },\n { label: \"006 2008 F250 Super Duty\", rate: 100.00 },\n { label: \"007 2021 Ram 3500 Laramie\", rate: 100.00 },\n { label: \"008 2015 F350 Super Duty\", rate: 100.00 },\n { label: \"009 2022 F150 Supercrew\", rate: 100.00 },\n { label: \"010 2022 F150 Supercrew\", rate: 100.00 },\n { label: \"011 2022 F350 Super Duty\", rate: 100.00 },\n { label: \"012 2019 Silverado C2500 Heavy Duty\", rate: 100.00 },\n { label: \"013 2013 Silverado C3500\", rate: 100.00 },\n { label: \"014 2015 F450 Super Duty\", rate: 100.00 },\n { label: \"015 2016 F350 Super Duty\", rate: 100.00 },\n { label: \"016 2015 F450 Super Duty\", rate: 100.00 },\n { label: \"018 2021 F350 Super Duty\", rate: 100.00 },\n { label: \"019 2021 F350 Super Duty\", rate: 100.00 },\n { label: \"020 2011 Ram 2500\", rate: 100.00 },\n { label: \"021 2022 F450 Super Duty\", rate: 100.00 },\n { label: \"022 2023 F150 Supercrew\", rate: 100.00 },\n { label: \"023 2023 F150 Supercrew\", rate: 100.00 },\n { label: \"024 2023 F150 Supercrew\", rate: 100.00 },\n { label: \"025 2022 F350 Super Duty\", rate: 100.00 },\n { label: \"026 2023 F150 Supercrew\", rate: 100.00 },\n { label: \"027 2025 F-150 STX\", rate: 100.00 },\n { label: \"028 2026 F-150 Crew Cab\", rate: 100.00 },\n { label: \"029 2026 Ford F150\", rate: 100.00 },\n { label: \"203 Case 580N Backhoe\", rate: 70.03 },\n { label: \"204 Case 580SN T4 Backhoe\", rate: 70.03 },\n { label: \"205 Case 580 SN T4 Backhoe\", rate: 70.03 },\n { label: \"206 Case 580SN T4B Backhoe\", rate: 70.03 },\n { label: \"207 JD 320 P-Tier Backhoe\", rate: 70.03 },\n { label: \"208 Case 570N-EP Backhoe\", rate: 70.03 },\n { label: \"301 CAT 322 BL Trackhoe W/ Hammer\", rate: 103.49 },\n { label: \"303 Case CX36B Excavator\", rate: 44.57 },\n { label: \"305 KOM PC 78US-8 Mini Excavator\", rate: 57.89 },\n { label: \"306 KOM PC210LC-11 Excavator\", rate: 103.49 },\n { label: \"307 CAT 303.5 E2 Mini Ex\", rate: 44.57 },\n { label: \"308 CAT 308-07 T Midi Excavator\", rate: 57.89 },\n { label: \"309 CAT 320-07 Excavator\", rate: 103.49 },\n { label: \"310 CAT 308-07 Mini Excavator\", rate: 57.89 },\n { label: \"311 CAT 303.5-07 Mini Excavator\", rate: 44.57 },\n { label: \"312 CAT 308-07 Midi Ex\", rate: 57.89 },\n { label: \"313 CAT 303.5-07 Mini Ex\", rate: 44.57 },\n { label: \"314 CAT 349FL Excavator\", rate: 210.00 },\n { label: \"315 CAT320GC Excavator\", rate: 103.49 },\n { label: \"316 KOM PC78US-11 Excavator\", rate: 57.89 },\n { label: \"317 CAT 303.5-07OR Mini Ex\", rate: 44.57 },\n { label: \"318 CAT 308-07CR Midi Excavator\", rate: 57.89 },\n { label: \"4001 2022 Peterbilt 579 Water Truck\", rate: 48.67 },\n { label: \"4002 2022 Peterbilt 579 Water Truck\", rate: 48.67 },\n { label: \"4003 2021 Peterbilt 579 Water Truck\", rate: 48.67 },\n { label: \"4005 2021 Peterbilt 579 4x2 Water Truck\", rate: 48.67 },\n { label: \"4006 2012 Kenworth T370 Water Truck\", rate: 61.48 },\n { label: \"4007 2012 Kenworth T370 Water Truck\", rate: 61.48 },\n { label: \"4008 1999 Sterling Water Truck\", rate: 48.67 },\n { label: \"4009 2006 Peterbilt 378 Convention Water Truck\", rate: 61.48 },\n { label: \"4010 1997 Water Truck (2000G)\", rate: 48.67 },\n { label: \"4011 2004 Water Pull 615 (6000G)\", rate: 157.80 },\n { label: \"4012 2019 Freightliner Water Truck (2000G)\", rate: 61.48 },\n { label: \"4013 2023 Freightliner Water Truck (2000G)\", rate: 48.67 },\n { label: \"4014 2023 Water Wagon 613CII\", rate: 157.80 },\n { label: \"4015 1993 International Water Truck\", rate: 61.48 },\n { label: \"4016 1992 Peterbilt Water Truck\", rate: 61.48 },\n { label: \"4017 1996 Peterbilt Water Truck\", rate: 61.48 },\n { label: \"4018 1998 Water Truck\", rate: 48.67 },\n { label: \"402 CAT 966F Loader\", rate: 172.14 },\n { label: \"404 CAT 938K Loader\", rate: 85.05 },\n { label: \"405 KOM WA320 Loader\", rate: 85.05 },\n { label: \"406 KOM WA380 Loader\", rate: 123.98 },\n { label: \"407 CAT 950M Loader\", rate: 123.98 },\n { label: \"408 CAT 950M Loader (New)\", rate: 123.98 },\n { label: \"409 CAT 950M Loader\", rate: 123.98 },\n { label: \"410 CAT 950M Loader\", rate: 123.98 },\n { label: \"4100 2021 Peterbilt 337 Fuel Truck\", rate: 0.00 },\n { label: \"4101 2026 Peterbilt 537 Fuel Truck\", rate: 0.00 },\n { label: \"4102 2021 Peterbilt 348 8x4 Dump Truck\", rate: 157.99 },\n { label: \"4103 1995 International Dump Truck\", rate: 157.99 },\n { label: \"4104 2022 Peterbilt 579 Dump Truck\", rate: 157.99 },\n { label: \"4105 2021 Peterbilt 579 4x2 Dump Truck\", rate: 157.99 },\n { label: \"4106 Peterbilt 389\", rate: 157.99 },\n { label: \"4107 International ProStar 6x4 Day Cab Truck\", rate: 157.99 },\n { label: \"4108 Peterbilt 378 Convention\", rate: 157.99 },\n { label: \"411 KOM WA320-8 Loader\", rate: 85.05 },\n { label: \"412 CAT 950-14 Loader\", rate: 123.98 },\n { label: \"413 JD 644 P-Tier Loader\", rate: 123.98 },\n { label: \"414 CAT 950M Loader\", rate: 123.98 },\n { label: \"504 Case SR175 Skidsteer\", rate: 44.57 },\n { label: \"507 Case SR210 Skidsteer (New)\", rate: 44.57 },\n { label: \"508 Case SR210B T4 Skidsteer\", rate: 44.57 },\n { label: \"509 Case SR210B T4 Skidsteer\", rate: 44.57 },\n { label: \"510 Case SR210B T4 Skidsteer\", rate: 44.57 },\n { label: \"5100 Plate Compactors\", rate: 0.00 },\n { label: \"5101 Multiquip Plate Wacker\", rate: 0.00 },\n { label: \"5102 Sakai Wacker Rammer\", rate: 0.00 },\n // The source file truncated here. The remaining entries (from ~5103 onward,\n // small tools / saws / trailers / generators) should be re-imported from\n // \"Rates by Equipment.pdf\" before production use.\n];\n",[],[358],"4279df9a-abcc-4886-b6df-1fa7c331db23","db.ts","9d68b710-a7d3-11f1-bea0-1607ee4eb77e",39,["D",1788493995081],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n/**\n * Database migrations for the Production Command Center.\n *\n * The migration has its own DB tables for users, sessions, approved emails,\n * jobs, job labor rates, job data, Monday snapshots, and uploaded-file metadata.\n * All statements use CREATE TABLE IF NOT EXISTS / ALTER guard so the setup is\n * idempotent across restarts.\n */\n\nconst migrations: { name: string; sql: string[] }[] = [\n {\n name: \"0001_initial_auth_and_jobs\",\n sql: [\n `CREATE TABLE IF NOT EXISTS users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT NOT NULL UNIQUE,\n role TEXT NOT NULL DEFAULT 'user' CHECK (role IN ('admin','user')),\n password_salt TEXT,\n password_hash TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS sessions (\n id TEXT PRIMARY KEY,\n user_id INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE,\n token_hash TEXT NOT NULL UNIQUE,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n expires_at TEXT NOT NULL\n )`,\n `CREATE INDEX IF NOT EXISTS idx_sessions_user ON sessions(user_id)`,\n `CREATE TABLE IF NOT EXISTS approved_emails (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT NOT NULL UNIQUE,\n role TEXT NOT NULL DEFAULT 'user' CHECK (role IN ('admin','user')),\n created_by INTEGER REFERENCES users(id),\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS jobs (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n source TEXT,\n job_number TEXT,\n status TEXT,\n superintendent TEXT,\n project_manager TEXT,\n estimator TEXT,\n location TEXT,\n jurisdiction TEXT,\n general_contractor TEXT,\n foreman TEXT,\n prevailing_wage TEXT,\n permit_number TEXT,\n schedule_group TEXT,\n monday_url TEXT,\n created_by INTEGER REFERENCES users(id),\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS job_labor_rates (\n job_id INTEGER PRIMARY KEY REFERENCES jobs(id) ON DELETE CASCADE,\n labor REAL,\n operator REAL,\n foreman REAL,\n updated_at TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS job_data (\n job_id INTEGER PRIMARY KEY REFERENCES jobs(id) ON DELETE CASCADE,\n data TEXT,\n updated_at TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS monday_snapshots (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n fetched_at TEXT NOT NULL DEFAULT (datetime('now')),\n jobs_json TEXT\n )`,\n `CREATE TABLE IF NOT EXISTS job_files (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n job_id INTEGER REFERENCES jobs(id) ON DELETE CASCADE,\n kind TEXT NOT NULL,\n filename TEXT NOT NULL,\n content_type TEXT,\n size INTEGER,\n blob_key TEXT NOT NULL,\n uploaded_by INTEGER REFERENCES users(id),\n uploaded_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS settings (\n key TEXT PRIMARY KEY,\n value TEXT\n )`,\n ],\n },\n {\n name: \"0002_jobs_created_by\",\n sql: [\n // 0001 ran before created_by was added to the jobs CREATE TABLE, so add it\n // via ALTER TABLE now. Idempotent across restarts via try/catch.\n `ALTER TABLE jobs ADD COLUMN created_by INTEGER REFERENCES users(id)`,\n ],\n },\n {\n name: \"0003_jobs_monday_item_id\",\n sql: [\n // Permanent Monday item id used to upsert synced Utility Schedule jobs\n // so refreshes update existing jobs instead of duplicating. Manual jobs\n // keep this NULL and are never matched.\n `ALTER TABLE jobs ADD COLUMN monday_item_id TEXT`,\n `CREATE UNIQUE INDEX IF NOT EXISTS idx_jobs_monday_item_id ON jobs(monday_item_id) WHERE monday_item_id IS NOT NULL`,\n ],\n },\n];\n\nconst applied = new Set<string>();\n\nexport async function migrate(): Promise<void> {\n // Track applied migrations.\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS _migrations (\n name TEXT PRIMARY KEY,\n applied_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n );\n\n for (const migration of migrations) {\n const row = await sqlite.execute(\n `SELECT name FROM _migrations WHERE name = ?`,\n [migration.name],\n );\n if (row.rows.length > 0) {\n applied.add(migration.name);\n continue;\n }\n await sqlite.batch(\n migration.sql.map((sql) => ({ sql })),\n );\n await sqlite.execute(\n `INSERT INTO _migrations (name) VALUES (?)`,\n [migration.name],\n );\n applied.add(migration.name);\n }\n}\n\n/** Runs migrations once at import time (idempotent). */\nexport const ready = migrate();\n",[],[365],"345b0511-440e-4372-8675-5a014e9ef1c1","auth.ts","ace8cfc2-a7d3-11f1-8230-1607ee4eb77e",["D",1788466300593],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport type { Context, Next } from \"npm:hono\";\n\nexport interface User {\n id: number;\n email: string;\n role: \"admin\" | \"user\";\n}\n\nexport const SESSION_COOKIE = \"pcc_session\";\nconst SESSION_DAYS = 30;\n\nconst encoder = new TextEncoder();\n\nfunction bufToHex(buf: ArrayBuffer): string {\n return [...new Uint8Array(buf)].map((b) => b.toString(16).padStart(2, \"0\")).join(\"\");\n}\n\nfunction hexToBuf(hex: string): Uint8Array {\n const out = new Uint8Array(hex.length / 2);\n for (let i = 0; i < out.length; i++) out[i] = parseInt(hex.slice(i * 2, i * 2 + 2), 16);\n return out;\n}\n\nasync function randomHex(bytes: number): Promise<string> {\n const buf = crypto.getRandomValues(new Uint8Array(bytes));\n return bufToHex(buf.buffer);\n}\n\n/** PBKDF2-SHA256 password hashing with a per-user random salt. */\nexport async function hashPassword(password: string): Promise<{ salt: string; hash: string }> {\n const salt = await randomHex(16);\n const keyMaterial = await crypto.subtle.importKey(\n \"raw\",\n encoder.encode(password),\n \"PBKDF2\",\n false,\n [\"deriveBits\"],\n );\n const bits = await crypto.subtle.deriveBits(\n { name: \"PBKDF2\", salt: hexToBuf(salt), iterations: 120_000, hash: \"SHA-256\" },\n keyMaterial,\n 256,\n );\n return { salt, hash: bufToHex(bits) };\n}\n\nexport async function verifyPassword(password: string, salt: string, hash: string): Promise<boolean> {\n try {\n const keyMaterial = await crypto.subtle.importKey(\n \"raw\",\n encoder.encode(password),\n \"PBKDF2\",\n false,\n [\"deriveBits\"],\n );\n const bits = await crypto.subtle.deriveBits(\n { name: \"PBKDF2\", salt: hexToBuf(salt), iterations: 120_000, hash: \"SHA-256\" },\n keyMaterial,\n 256,\n );\n return bufToHex(bits) === hash;\n } catch {\n return false;\n }\n}\n\n/** Create a session for a user; returns the raw token to set as the cookie. */\nexport async function createSession(userId: number): Promise<{ token: string; expiresAt: string }> {\n const id = await randomHex(16);\n const token = await randomHex(32);\n const tokenHash = bufToHex((await crypto.subtle.digest(\"SHA-256\", encoder.encode(token))).buffer);\n const expiresAt = new Date(Date.now() + SESSION_DAYS * 24 * 60 * 60 * 1000).toISOString();\n await sqlite.execute(\n `INSERT INTO sessions (id, user_id, token_hash, expires_at) VALUES (?, ?, ?, ?)`,\n [id, userId, tokenHash, expiresAt],\n );\n return { token, expiresAt };\n}\n\nexport function sessionCookieHeader(token: string, expiresAt: string): string {\n return `${SESSION_COOKIE}=${token}; HttpOnly; Secure; SameSite=Lax; Path=/; Expires=${new Date(expiresAt).toUTCString()}`;\n}\n\nexport const clearCookieHeader = `${SESSION_COOKIE}=; HttpOnly; Secure; SameSite=Lax; Path=/; Max-Age=0`;\n\n/** Resolve the current user from the request's cookie, or null. */\nexport async function getSessionUser(req: Request): Promise<User | null> {\n const cookie = req.headers.get(\"cookie\") ?? \"\";\n const match = cookie.split(\";\").map((s) => s.trim()).find((c) => c.startsWith(`${SESSION_COOKIE}=`));\n if (!match) return null;\n const token = match.slice(SESSION_COOKIE.length + 1);\n if (!token) return null;\n const tokenHash = bufToHex((await crypto.subtle.digest(\"SHA-256\", encoder.encode(token))).buffer);\n const rows = await sqlite.execute(\n `SELECT s.expires_at AS exp, u.id AS id, u.email AS email, u.role AS role\n FROM sessions s JOIN users u ON u.id = s.user_id\n WHERE s.token_hash = ?`,\n [tokenHash],\n );\n if (rows.rows.length === 0) return null;\n const row = rows.rows[0] as { exp: string; id: number; email: string; role: string };\n if (new Date(row.exp).getTime() < Date.now()) return null;\n return { id: Number(row.id), email: row.email, role: row.role as \"admin\" | \"user\" };\n}\n\n/** Hono middleware: require a logged-in user, else 401 JSON (for /api/*). */\nexport async function requireAuth(c: Context, next: Next) {\n const user = await getSessionUser(c.req.raw);\n if (!user) {\n return c.json({ error: \"Not authenticated\" }, 401);\n }\n c.set(\"user\", user);\n await next();\n}\n\n/** Hono middleware: require admin role. */\nexport async function requireAdmin(c: Context, next: Next) {\n const user = c.get<User>(\"user\");\n if (!user || user.role !== \"admin\") {\n return c.json({ error: \"Forbidden\" }, 403);\n }\n await next();\n}\n",[],[373],"4f82b0d8-071a-4e4d-8656-17781af9fd82","README.md","27d70b36-a7d4-11f1-942c-1607ee4eb77e",57,["D",1788494272823],"# Production Command Center — Val Town migration\n\nA Val Town-native rebuild of the NDX Production Command Center. Cloudflare\nNext.js/Vinext has been replaced with **Hono** (routes) + a client-side **React**\nfrontend. **Cloudflare D1** → this val's scoped SQLite. **Cloudflare R2** → this\nval's scoped Blob Storage.\n\n> **Phase status: Phase 2 — non-Monday dashboard features complete.**\n> Auth, roles, the full dashboard (jobs, rates, Vista/BusyBusy imports, cost\n> consolidation, equipment/crew/phase views, equipment moves, reports), and\n> permanent job storage are implemented and tested. Monday.com remains\n> disconnected. No production job data is loaded.\n\n## Try it\n\n- [Launch the app](url:index.ts)\n- [View source](url:/source)\n- [Add `MONDAY_TOKEN`](https://www.val.town/x/wnewton/production-command-center/environment-variables?key=MONDAY_TOKEN)\n\nSign in with the existing administrator account. Every dashboard page and data\nAPI requires authentication.\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|GET /| Hono[\"index.ts (Hono server)\"]\n Hono -->|serves| Root[\"frontend/root.tsx (HTML shell)\"]\n Root -->|loads| Entry[\"frontend/index.tsx\"]\n Entry -->|renders| App[\"frontend/App.tsx (auth + dashboard)\"]\n App -->|\"fetch /api/*\"| Hono\n Hono -->|SQLite| DB[\"project-scoped SQLite (std/sqlite/main.ts)\"]\n Hono -->|Blob| Blob[\"scoped Blob Storage (original uploads)\"]\n Hono -->|secrets| Env[\"Deno.env MONDAY_TOKEN (server-only)\"]\n```\n\n## Files\n\n```\nindex.ts ← Hono HTTP entrypoint (auth + jobs + data + files + rates)\ndb.ts ← SQLite migrations (users, sessions, jobs, rates, data, Monday, files)\nauth.ts ← PBKDF2 hashing, HTTP-only session cookies, role middleware\nequipmentRates.ts ← Equipment rate book (source of hourly operating rates)\nfrontend/\n root.tsx ← HTML shell (stamps immutable asset URLs)\n index.tsx ← React entrypoint\n App.tsx ← Auth + jobs, rates, imports, cost/equipment/report views\n styles.css ← NDX black/white/red interface\n```\n\n## Auth model\n\n- **Email + password** login (PBKDF2-SHA256 hashed, per-user salt).\n- **HTTP-only, Secure, SameSite=Lax** session cookie (`pcc_session`), token hashed in DB, 30-day expiry.\n- **Approved-email allowlist** (`approved_emails`) with `admin` / `user` roles. Admins manage jobs; both may view/enter data.\n- Every data API requires auth (`requireAuth`); job create/edit/delete also requires `requireAdmin`.\n\n## Administrator password recovery\n\nA \"Forgot password?\" link on the sign-in screen opens a recovery form. To reset an\nadministrator password you need the administrator email, the recovery code, and a\nnew password entered twice.\n\n- The recovery code is read **only** from the `ADMIN_RECOVERY_CODE` environment\n variable — it is never hardcoded, displayed, or logged.\n- The new password is hashed with the same PBKDF2 system used for sign-in.\n- On success all of that administrator's sessions are invalidated (signed out).\n- The email + code combination is validated with a timing-safe comparison and\n failures return a generic message (no user-enumeration).\n- No default password or hardcoded secret is used.\n\n👉 Add `ADMIN_RECOVERY_CODE` here: https://www.val.town/x/wnewton/production-command-center/environment-variables?key=ADMIN_RECOVERY_CODE\n\n## Phase 2 — implemented & tested\n\n- **Jobs** — create, select (top bar), edit, delete (cascades data, rates, files, blobs).\n- **Per-job labor / operator / foreman rates** — saved per job with standard defaults.\n- **Vista TXT target import** — browser-side CSV parsing, targets stored in the job's production map, original saved to Blob.\n- **BusyBusy Excel import** — SheetJS in the browser; actual costs per cost code, equipment usage, crew size, phase-code breakdown, equipment moves. Original saved to Blob.\n- **Cost-code consolidation** — first-4-digit grouping (1201.2 + 1201.3 → 1201), toggle in the cost-code table.\n- **Equipment usage / crew size / phase-code views** — most-used equipment, crew-by-workday, expandable per-phase detail.\n- **Equipment moves (phase 1101)** — equipment moved, move hours, driver labor cost, hauling truck cost, total; no charge for the transported machine.\n- **Manual production + cost per unit** — enter quantities per cost code; actual vs. Vista target unit cost.\n- **Reports + print/PDF** — executive report cover, top cost codes, print stylesheet.\n- **Permanent storage** — job data in SQLite, original uploads in Blob Storage keyed by job.\n\n**Monday.com: disconnected.** The Utility Schedule import is deferred to Phase 3.\n\n## Monday.com (Utility Schedule)\n\n- Server-side integration in `monday.ts` using `Deno.env.get(\"MONDAY_TOKEN\")`. The\n token is **never** returned, logged, or sent to the browser.\n- **Board discovery** by name (or `MONDAY_BOARD_ID` env), **column mapping** from\n the board's own metadata, imports only Utility Schedule items, and **ignores\n every item in a group whose normalized name is \"Completed\" / \"Completed.\"**.\n- Each synced job stores a **permanent `monday_item_id`** (migration `0003`,\n unique index), so refreshes **update** existing jobs instead of duplicating.\n Manually created jobs are never touched.\n- The **Refresh** button is functional (admin only): `POST /api/monday-refresh`\n imports, writes a snapshot to `monday_snapshots`, and returns\n added / updated / completed-ignored / last-refresh. Errors are generic and\n never reveal credentials.\n- Status is surfaced in the monday strip and the Migration checklist.\n\n**Status:** the connection/error path is verified reachable and safe. The\ncurrently configured `MONDAY_TOKEN` is rejected by Monday (HTTP 401 — invalid or\nexpired), so **no jobs have been imported yet**. To complete the live sync,\nreplace the token with a valid Monday personal API token and click **Refresh**.\n\n## Remaining\n\n- Replace `MONDAY_TOKEN` with a **valid** token, then click **Refresh** to import\n the Utility Schedule (the write/import path is implemented but not yet\n executed against live data).\n- Optionally re-import the tail of the equipment-rate PDF (the migration source\n was truncated at entry `5103`, so `equipmentRates.ts` carries 96 records; some\n small-tool entries may be missing).\n\n## Secrets\n\nThe val injects its own API token; no `valtown` env var is needed. The credentials\nused are `MONDAY_TOKEN` (server-only) and `ADMIN_RECOVERY_CODE`.\n\n👉 Add `MONDAY_TOKEN` here: https://www.val.town/x/wnewton/production-command-center/environment-variables?key=MONDAY_TOKEN\n\n## Safety\n\n- Monday.com token (when added) stays server-side only.\n- All reads/writes/uploads are authenticated; uploaded file type + size validated.\n- Parameterized SQL throughout.\n- The live hosted Command Center is untouched.\n",[],[380],"b4ddd245-b24d-43c0-84da-9e5509f17f07","scripts","3602a262-390e-4ee8-b50a-14fa58db107b",["D",1788472667790],"directory",[],[388],"5f318513-99bb-4966-bea1-83b29d80c23b","styles.css","ff077a2e-a7d3-11f1-92c0-1607ee4eb77e",51,["D",1788494190784],5,"/* Production Command Center — NDX black/white/red interface */\n:root{--navy:#090909;--red:#d71920;--ink:#111;--muted:#707070;--line:#dedede;--paper:#f3f3f3;--shadow:0 10px 30px rgba(0,0,0,.075)}\n*{box-sizing:border-box}\nhtml{background:var(--paper)}\nbody{margin:0;background:radial-gradient(circle at 92% 4%,rgba(196,18,48,.07),transparent 25%),radial-gradient(circle at 42% 96%,rgba(0,0,0,.035),transparent 32%),var(--paper);color:var(--ink);font-family:\"Manrope\",Arial,sans-serif;-webkit-font-smoothing:antialiased}\nbutton{border:1px solid #d7dfe2;background:#fff;border-radius:6px;padding:10px 14px;margin-left:7px;font-size:10px;font-weight:800;color:#455660;cursor:pointer}\n.gold{background:var(--red);border-color:var(--red);color:#fff}\n.shell{min-height:100vh;display:block}\n.shell aside{position:fixed;inset:0 auto 0 0;z-index:30;width:258px;padding:24px 16px 20px;background:linear-gradient(165deg,#141414 0%,#090909 58%,#000 100%);box-shadow:12px 0 40px rgba(0,0,0,.14)}\n.shell aside:after{content:\"\";position:absolute;inset:0;pointer-events:none;background:radial-gradient(circle at 12% 0,rgba(196,18,48,.3),transparent 28%),radial-gradient(circle at 100% 92%,rgba(196,18,48,.12),transparent 34%)}\n.brand,nav,.job,.user{position:relative;z-index:1}\n.brand{display:flex;gap:13px;align-items:center;padding:2px 7px 24px;border-bottom:1px solid rgba(255,255,255,.11)}\n.brand>i{width:50px;height:50px;border:1px solid rgba(255,255,255,.2);border-radius:15px;background:linear-gradient(145deg,#d81d3d,#aa0e28);box-shadow:0 10px 24px rgba(196,18,48,.3);display:grid;place-items:center;font:800 17px \"Manrope\";letter-spacing:-.08em;color:#fff;font-style:normal}\n.brand>i span{font-size:13px}\n.brand b{font-size:14px;letter-spacing:-.02em;color:#fff}\n.brand small{margin-top:5px;color:#a9a9a9;font:500 8px \"DM Mono\";letter-spacing:.11em}\n.brand span,.user span{display:flex;flex-direction:column}\n.shell nav{display:flex;flex-direction:column;gap:5px;margin-top:22px}\n.shell nav button{position:relative;display:flex;align-items:center;gap:12px;min-height:47px;padding:0 12px;border:0;border-radius:12px;color:#b7b7b7;background:transparent;font-size:11px;font-weight:600;transition:170ms ease;margin-left:0;width:100%;text-align:left}\n.shell nav button:hover{color:#fff;background:rgba(255,255,255,.06);transform:translateX(2px)}\n.shell nav button>span{display:grid;place-items:center;width:28px;height:28px;border-radius:9px;color:#9c9c9c;background:rgba(255,255,255,.055);font-size:13px}\n.shell nav button.active{color:#fff;background:rgba(255,255,255,.1);box-shadow:0 8px 22px rgba(0,0,0,.1)}\n.shell nav button.active:before{content:\"\";position:absolute;left:0;width:3px;height:22px;border-radius:0 4px 4px 0;background:#e31b3d}\n.shell nav button.active>span{color:#fff;background:rgba(196,18,48,.72)}\n.job{margin-top:auto;border:0;border-top:1px solid rgba(255,255,255,.11);border-radius:0;padding:19px 10px 0!important;background:transparent!important;display:flex;flex-direction:column;gap:7px}\n.job small{color:#b8b8b8;font:500 8px \"DM Mono\";letter-spacing:.07em}\n.job b{font-size:11px;color:#fff}\n.job em{color:#ddd;font:500 9px \"DM Mono\";font-style:normal}\n.user{border-top:0;margin-top:18px;padding:0 10px;display:flex;gap:9px;align-items:center}\n.user>i{width:34px;height:34px;border-radius:11px;background:linear-gradient(145deg,#d91b3b,#b40e2a);display:grid;place-items:center;color:#fff;font-style:normal;font-size:10px;font-weight:bold}\n.user b{font-size:10px;color:#fff}\n.user small{font-size:8px;color:#a9a9a9}\n.shell main{width:calc(100% - 258px);max-width:none;min-height:100vh;margin-left:258px;padding:0 34px 66px}\n.shell main>header{position:sticky;top:0;z-index:20;min-height:92px;margin:0 -34px 30px;padding:17px 34px;align-items:center;display:flex;justify-content:space-between;background:rgba(255,255,255,.9);border-bottom:1px solid rgba(220,220,220,.92);box-shadow:0 8px 30px rgba(0,0,0,.04);backdrop-filter:blur(22px) saturate(1.2)}\nheader p{font-size:8px;letter-spacing:1.7px;font-weight:800;color:#8a979e;margin:0 0 7px}\nheader h1{font:700 clamp(25px,2.3vw,35px) \"Manrope\";line-height:1;letter-spacing:-.05em;margin:0 0 6px}\nheader span{font-size:11px;color:var(--muted)}\n.header-actions{display:flex;align-items:center;gap:10px}\nheader button{min-height:42px;margin:0;border-radius:11px;padding:0 17px;font-size:10px;transition:170ms ease}\nheader button:hover{transform:translateY(-2px);box-shadow:0 9px 20px rgba(0,0,0,.14)}\nheader .gold{background:linear-gradient(145deg,#d91b3b,#b40e2a)!important;box-shadow:0 5px 14px rgba(196,18,48,.22)}\nheader .logout{background:#fff;color:#111;border-color:#dedede}\n.top-job-picker{display:grid;gap:3px;min-width:235px;padding:7px 12px;border:1px solid #dbe3de;border-radius:11px;background:rgba(255,255,255,.82)}\n.top-job-picker small{color:#707070;font:500 8px \"DM Mono\";letter-spacing:.1em}\n.top-job-picker select{border:0;outline:0;background:transparent;color:#111;font-size:11px;font-weight:600}\n.status-line{background:#fff;border:1px solid var(--line);border-left:4px solid var(--red);border-radius:10px;padding:11px 15px;margin-bottom:15px;font-size:10px;font-weight:700;color:#b51218}\n.panel,.kpis article{background:rgba(255,255,255,.92);border:1px solid rgba(220,220,220,.95);border-radius:17px;box-shadow:var(--shadow);backdrop-filter:blur(10px)}\n.panel{padding:21px;margin-bottom:18px;overflow:hidden}\n.kpis{display:grid;grid-template-columns:repeat(4,1fr);gap:15px;margin:15px 0}\n.kpis article{min-height:145px;padding:21px 22px;border-top:3px solid #111;transition:180ms ease}\n.kpis article>i{display:grid;place-items:center;width:27px;height:27px;background:#f7e7e7;color:var(--red);border-radius:6px;font-style:normal;font-weight:bold}\n.kpis article p{margin-top:15px;font-size:8px;letter-spacing:1.5px;font-weight:800;color:#8a979e}\n.kpis h2{font:500 28px \"DM Mono\";margin:0 0 6px}\n.kpis span{font-size:8px;color:#84929a}\n.kpis .accent{border-top:3px solid var(--red)}\n.import-strip{display:flex;align-items:center;gap:9px;background:linear-gradient(145deg,#1a1a1a,#050505);color:#fff;border-left:5px solid var(--red);border-radius:22px;padding:13px 15px;margin-top:15px;box-shadow:0 18px 44px rgba(0,0,0,.18)}\n.import-strip>div{margin-right:auto}\n.import-strip p{color:#e1484d;margin-bottom:4px;font-size:8px;font-weight:800;letter-spacing:1.7px}\n.import-strip b{font-size:11px}\n.import-strip button{min-height:42px;border-radius:11px;border-color:#444;background:#222;color:#fff}\n.empty-state{padding:50px 20px;display:flex;flex-direction:column;align-items:center;gap:8px;color:#7b868c;text-align:center}\n.empty-state b{font:700 18px Georgia;color:#111}\n.empty-state span{font-size:10px;max-width:520px;line-height:1.5}\n.view-head{display:flex;justify-content:space-between;align-items:center;border-bottom:1px solid #e4e7e8;padding-bottom:16px}\n.view-head p{margin-bottom:4px;color:var(--red);font-size:8px;font-weight:800;letter-spacing:1.5px}\n.view-head h3{font:700 20px \"Manrope\";margin:0}\n.source-pill{padding:6px 9px;border-radius:20px;background:#f6e7ea;color:#b5122c;font:600 7px \"DM Mono\";letter-spacing:.08em}\n/* Migration checklist */\n.migration-panel{padding:22px!important}\n.migration-list{display:flex;flex-direction:column;margin-top:8px}\n.migration-row{display:flex;align-items:center;gap:14px;min-height:58px;padding:12px 6px;border-top:1px solid #ececec}\n.migration-row>i{flex:0 0 26px;width:26px;height:26px;display:grid;place-items:center;border-radius:9px;font-style:normal;background:#eee;color:#999;font:600 12px \"DM Mono\"}\n.migration-row.done>i{background:#111;color:#fff}\n.migration-row>span{display:flex;flex-direction:column;gap:3px}\n.migration-row b{font-size:11px}\n.migration-row small{font-size:9px;color:#7a7a7a;line-height:1.4}\n.migration-note{margin-top:16px;padding:13px 15px;border-left:4px solid var(--red);background:#f8eeee;border-radius:10px;font-size:10px;line-height:1.5;color:#7a5a5c}\n.migration-note code{background:#fff;border:1px solid #e2ccce;padding:2px 6px;border-radius:5px;color:#b51218}\n/* Auth screens */\n.auth-shell{min-height:100vh;display:grid;place-items:center;padding:20px}\n.auth-card{width:min(440px,100%);background:rgba(255,255,255,.95);border:1px solid rgba(220,220,220,.95);border-radius:20px;box-shadow:var(--shadow);padding:34px;display:flex;flex-direction:column}\n.brand-mark{width:58px;height:58px;border-radius:16px;background:linear-gradient(145deg,#d81d3d,#aa0e28);box-shadow:0 10px 24px rgba(196,18,48,.3);display:grid;place-items:center;font:800 20px \"Manrope\";letter-spacing:-.08em;color:#fff}\n.brand-mark span{font-size:15px}\n.auth-kicker{margin-top:24px;color:var(--red);font-size:9px;font-weight:800;letter-spacing:2px}\n.auth-card h1{font:700 26px \"Manrope\";letter-spacing:-.02em;margin:6px 0 8px}\n.auth-sub{font-size:11px;line-height:1.55;color:#707070;margin:0 0 18px}\n.auth-card label{display:flex;flex-direction:column;gap:6px;margin-bottom:14px;font-size:8px;font-weight:800;letter-spacing:1px;color:#777}\n.auth-card input{border:1px solid #d8dfe2;border-radius:10px;padding:12px 13px;font-size:12px}\n.auth-card .gold{min-height:46px;border-radius:11px;margin:6px 0 0;font-size:12px}\n.auth-status{font-size:11px;color:#b51218;background:#f8eeee;border-radius:8px;padding:9px 11px;margin:0 0 10px}\n.auth-loading{color:#777;font-size:11px;margin-top:20px}\n.backdrop{position:fixed;inset:0;background:rgba(8,8,8,.74);display:flex;align-items:flex-start;justify-content:center;overflow-y:auto;overscroll-behavior:contain;padding:20px;z-index:100;backdrop-filter:blur(5px)}\n.backdrop form{width:min(550px,100%);display:flex;flex-direction:column;max-height:calc(100vh - 40px);overflow:hidden;margin:auto;background:#fff;padding:23px;border-radius:17px;box-shadow:0 30px 90px rgba(0,0,0,.32)}\n/* Modal shell: pin the header and the Save/Cancel actions; only the field body scrolls */\n.backdrop form>.form-head{flex:0 0 auto}\n.backdrop form>.actions{flex:0 0 auto}\n.backdrop form>.form-grid{flex:1 1 auto;min-height:0;overflow-y:auto}\n.form-head{display:flex;justify-content:space-between;margin:-23px -23px 20px;padding:19px 24px;color:#fff;background:#111;border-radius:17px 17px 0 0}\n.form-head p{color:#e15469}\n.form-head h2{font:700 23px \"Manrope\";margin:0}\n.form-head button{border:0;font-size:22px;color:#fff;background:transparent}\n.create-job-form>label{display:flex;flex-direction:column;gap:7px;margin-top:20px;font-size:8px;font-weight:bold;letter-spacing:1px;color:#777}\n.create-job-form>label input{border:1px solid #d8e0e3;border-radius:6px;padding:12px;font-size:12px}\n.job-help{font-size:9px;line-height:1.5;margin-top:12px;color:#888}\n.actions{display:flex;justify-content:flex-end;margin-top:17px}\n@media(max-width:1100px){.shell aside{width:82px}.shell main{width:calc(100% - 82px);margin-left:82px}.brand span,.job,.user span{display:none}.brand>i{width:48px}.shell nav button{font-size:0;padding:0 10px}.top-job-picker{min-width:180px}}\n@media(max-width:760px){.shell aside{position:static;width:100%;height:68px;min-height:0;padding:9px 14px}.shell aside nav,.job,.user{display:none}.brand{border:0;padding:0}.shell main{width:100%;margin:0;padding:0 15px 45px}.shell main>header{position:static;margin:0 -15px 20px;padding:16px}.kpis{grid-template-columns:1fr 1fr}}\n/* Print */\n@media print{aside,.header-actions,.import-strip,.logout{display:none!important}.shell main{margin:0;width:100%;padding:0}.panel{box-shadow:none;border:1px solid #ddd}}\n\n/* ===== Phase 2 components ===== */\n/* Monday status strip */\n.monday-strip{display:flex;align-items:center;gap:12px;background:#fff;border:1px solid var(--line);border-left:5px solid #999;border-radius:14px;padding:12px 16px;margin-bottom:16px;box-shadow:var(--shadow)}\n.monday-strip>div{display:flex;flex-direction:column;gap:3px;margin-right:auto}\n.monday-strip p{color:#8a979e;margin:0;font-size:8px;font-weight:800;letter-spacing:1.5px}\n.monday-strip b{font-size:12px}\n.monday-strip span{font-size:10px;color:#7a848a}\n.monday-strip.not-connected{border-left-color:#b0b0b0}\n.monday-strip.not-connected b{color:#8a8a8a}\n.monday-strip button{min-height:36px;border-radius:10px;background:#f0f0f0;color:#999;cursor:not-allowed}\n/* Filters */\n.filters{height:56px;background:#fff;border:1px solid var(--line);border-radius:12px;padding:11px 16px;display:flex;align-items:center;gap:28px;margin-top:14px;box-shadow:var(--shadow)}\n.filters label{font-size:7px;font-weight:bold;color:#87959d;display:flex;flex-direction:column;gap:5px}\n.filters select{border:0;background:#fff;font-size:10px;font-weight:bold}\n.filters>span{margin-left:auto;font-size:9px;color:#b51218}\n/* Jobs manager */\n.jobs-panel{padding:22px!important}\n.create-job-inline{display:flex;gap:10px;margin:16px 0}\n.create-job-inline input{flex:1;border:1px solid #d8e0e3;border-radius:10px;padding:12px;font-size:12px}\n.create-job-inline button{margin:0}\n.job-list{display:flex;flex-direction:column}\n.job-list-row{display:flex;align-items:center;justify-content:space-between;gap:12px;min-height:58px;padding:12px 14px;border-top:1px solid #ececec}\n.job-list-row.active{background:#f8f2f2;border-left:3px solid var(--red)}\n.job-list-row>span:first-child{display:flex;flex-direction:column;gap:4px}\n.job-list-row b{font-size:12px}\n.job-list-row small{font-size:9px;color:#7a848a}\n.job-list-actions{display:flex;gap:6px}\n.job-list-actions button{margin:0;min-height:32px;border-radius:8px}\n.danger-ghost{color:#b51218;border-color:#e2ccce;background:#fff}\n.danger{background:#b51218;border-color:#b51218;color:#fff}\n.wide-form{width:min(640px,100%)!important}\n/* Labor rates */\n.labor-settings{display:grid;grid-template-columns:1.5fr .7fr;gap:14px}\n.rate-settings-card{padding:24px!important}\n.settings-head{display:flex;align-items:flex-start;justify-content:space-between;border-bottom:1px solid #e4e7e8;padding-bottom:17px}\n.settings-head h3,.prevailing-card h3{font:700 21px \"Manrope\";margin:0}\n.save-status{font-size:9px;color:#d71920;background:#f8e8e8;padding:6px 9px;border-radius:14px}\n.settings-job{display:flex;flex-direction:column;gap:6px;margin:19px 0;font-size:8px;letter-spacing:1px;font-weight:bold;color:#777}\n.settings-job input{width:100%;border:1px solid #d8dfe2;border-radius:7px;padding:12px;background:#f5f5f5;font-size:11px;font-weight:bold}\n.rate-input-grid{display:grid;grid-template-columns:repeat(3,1fr);gap:12px}\n.rate-input-grid>label{border:1px solid #dedede;border-radius:8px;padding:15px}\n.rate-input-grid>label>span{display:flex;justify-content:space-between;font-size:11px;font-weight:bold}\n.rate-input-grid small{font-size:7px;color:#888}\n.rate-input-grid label>div{display:flex;align-items:center;margin-top:12px}\n.rate-input-grid i{font:700 20px Georgia;color:#d71920;font-style:normal}\n.rate-input-grid input{width:100%;border:0;border-bottom:2px solid #111;padding:5px;font:700 25px Georgia;outline:none}\n.rate-input-grid em{font-size:9px;color:#777;font-style:normal;white-space:nowrap}\n.rate-actions{display:flex;align-items:center;justify-content:flex-end;margin-top:20px;padding-top:16px;border-top:1px solid #e4e7e8}\n.rate-actions>span{margin-right:auto;max-width:45%;font-size:9px;line-height:1.5;color:#76848b}\n.prevailing-card{background:#111!important;color:#fff!important;display:flex;gap:16px;align-items:flex-start}\n.prevailing-card>i{width:42px;height:42px;border:1px solid #d71920;color:#fff;background:#d71920;display:grid;place-items:center;border-radius:7px;font-style:normal;font-weight:bold}\n.prevailing-card p{color:#e33b40}\n.prevailing-card span{font-size:10px;line-height:1.6;color:#bfc3c5;display:block;margin-top:12px}\n/* Daily */\n.daily-view{padding:22px!important}\n.daily-row{display:grid;grid-template-columns:2fr .8fr .7fr .9fr .9fr .9fr;align-items:center;min-height:58px;border-bottom:1px solid #eceff0;font-size:9px}\n.daily-head{min-height:34px;font-size:7px;font-weight:bold;letter-spacing:.7px;color:#7b868c}\n.form-grid{display:grid;grid-template-columns:1fr 1fr;gap:13px;margin:18px 0}\n.form-grid label{display:flex;flex-direction:column;gap:6px;font-size:7px;font-weight:bold;color:#7d8b93}\n.form-grid .wide{grid-column:1/-1}\n.form-grid input,.form-grid select{border:1px solid #d8e0e3;border-radius:6px;padding:10px}\n.equipment-calc{border:1px solid #dedede;border-radius:7px;padding:11px 13px;margin-bottom:10px;display:flex;align-items:center;justify-content:space-between;background:#fafafa}\n.equipment-calc span{display:flex;flex-direction:column}\n.equipment-calc small{font-size:7px;letter-spacing:1px;color:#777}\n.equipment-calc b{font:700 19px Georgia;margin-top:3px}\n.equipment-calc em{font-style:normal;font-size:9px;color:#777}\n.calculated{background:#f8eeee;border-left:4px solid var(--red);padding:12px;display:flex;justify-content:space-between;border-radius:11px}\n.calculated span{font-size:7px}\n.calculated b{font:700 16px Georgia;color:#b51218}\n/* Operations usage */\n.operations-grid{display:grid;grid-template-columns:1.15fr .85fr;gap:15px;margin-bottom:15px}\n.operations-grid>.panel{margin:0}\n.usage-list{margin-top:14px}\n.usage-row{display:grid;grid-template-columns:28px 1fr auto;gap:11px;align-items:center;padding:11px 0;border-top:1px solid #ececec}\n.usage-row>i{width:26px;height:26px;display:grid;place-items:center;border-radius:8px;background:#111;color:#fff;font:600 9px \"DM Mono\";font-style:normal}\n.usage-row>span{min-width:0;display:flex;flex-direction:column;gap:4px}\n.usage-row b{overflow:hidden;text-overflow:ellipsis;white-space:nowrap;font-size:10px}\n.usage-row small{color:#7a7a7a;font-size:8px}\n.usage-row em{display:block;width:100%;height:4px;border-radius:4px;background:#ececec}\n.usage-row em u{display:block;height:100%;border-radius:4px;background:#c41230;text-decoration:none}\n.usage-row>strong{min-width:62px;text-align:right;font:600 16px \"DM Mono\"}\n.usage-row>strong small{font-size:8px}\n.crew-summary{display:grid;grid-template-columns:repeat(3,1fr);gap:8px;margin:15px 0}\n.crew-summary>span{display:flex;flex-direction:column;gap:5px;padding:12px;border-radius:11px;background:#111;color:#fff}\n.crew-summary small{font:500 7px \"DM Mono\";color:#aaa;letter-spacing:.08em}\n.crew-summary b{font:600 23px \"DM Mono\"}\n.crew-days>div{display:flex;align-items:center;justify-content:space-between;padding:10px 2px;border-top:1px solid #ececec}\n.crew-days span{display:flex;flex-direction:column;gap:3px}\n.crew-days b{font-size:10px}\n.crew-days small{font-size:8px;color:#7a7a7a}\n.crew-days strong{font:600 15px \"DM Mono\"}\n.crew-days strong small{font:500 8px \"Manrope\"}\n.empty-state.compact{min-height:150px}\n/* Phase controls + phase usage */\n.phase-controls{display:flex;align-items:center;justify-content:space-between;min-height:64px;margin:0 0 12px;padding:11px 14px;border:1px solid #dedede;border-radius:15px;background:#fff;box-shadow:0 8px 24px rgba(0,0,0,.05)}\n.phase-controls p{margin-bottom:4px}\n.phase-controls b{font-size:11px}\n.phase-controls button{min-height:38px;border-color:#111;background:#111;color:#fff}\n.phase-controls button:disabled{opacity:.35;cursor:not-allowed}\n.phase-usage{padding:0!important;margin-bottom:15px!important}\n.phase-usage>.view-head{padding:20px 20px 14px}\n.phase-table{overflow:auto}\n.phase-row{display:grid;grid-template-columns:minmax(180px,1.4fr) minmax(220px,1.5fr) 120px 90px 90px 85px;align-items:center;min-width:900px;min-height:62px;padding:0 20px;border-top:1px solid #ececec}\n.phase-row>span{display:flex;flex-direction:column;gap:4px;padding-right:12px;font-size:10px;text-align:left}\n.phase-row small{color:#7a7a7a;font-size:8px}\n.phase-row em{color:#888;font-size:9px;font-style:normal}\n.phase-row>span:nth-child(n+3) b{font:600 14px \"DM Mono\"}\n.phase-head{min-height:34px;background:#111;color:#fff;border:0}\n.phase-head>span{font:600 7px \"DM Mono\";letter-spacing:.08em}\n.phase-group:nth-child(odd)>.phase-click{background:#fafafa}\n.phase-click{width:100%;margin:0;border:0;border-top:1px solid #ececec;border-radius:0;background:#fff;color:#111}\n.phase-click:hover{background:#f5f5f5}\n.phase-group.open>.phase-click{background:#f8eaed;box-shadow:inset 4px 0 #c41230}\n.phase-name{flex-direction:row!important;align-items:center;gap:10px!important}\n.phase-name i{display:grid;place-items:center;flex:0 0 25px;width:25px;height:25px;border-radius:7px;background:#111;color:#fff;font:500 15px \"DM Mono\";font-style:normal}\n.phase-detail{display:grid;grid-template-columns:1.15fr .85fr;gap:22px;min-width:900px;padding:20px 28px 25px 54px;border-top:1px solid #e2c9ce;border-bottom:1px solid #dedede;background:linear-gradient(135deg,#fff 0%,#faf7f8 100%);box-shadow:inset 4px 0 #c41230}\n.detail-title{padding-bottom:10px;border-bottom:1px solid #e5e5e5}\n.detail-title p{margin-bottom:4px;color:#c41230}\n.detail-title>b{font-size:11px}\n.phase-detail .usage-list{margin-top:3px}\n.phase-detail .crew-summary{margin-top:12px}\n.detail-days{max-height:250px;overflow:auto;padding-right:6px}\n.detail-empty{padding:28px 0;color:#777;font-size:10px}\n/* Equipment moves */\n.equipment-moves{padding:0!important}\n.equipment-moves>.view-head{padding:20px 21px 14px}\n.move-summary{display:grid;grid-template-columns:repeat(4,minmax(0,1fr));gap:9px;padding:0 21px 18px}\n.move-summary>span{display:flex;flex-direction:column;gap:5px;padding:12px 14px;border-radius:11px;background:#111;color:#fff}\n.move-summary small{color:#aaa;font:500 7px \"DM Mono\";letter-spacing:.08em}\n.move-summary b{font:600 18px \"DM Mono\"}\n.move-summary .review{background:#fff0d3;color:#946000}\n.move-summary .review small{color:#946000}\n.move-table{overflow:auto}\n.move-row{display:grid;grid-template-columns:115px minmax(210px,1.2fr) minmax(230px,1.4fr) 85px minmax(180px,1fr);align-items:center;min-width:900px;min-height:67px;padding:0 21px;border-top:1px solid #ececec}\n.move-row>span{display:flex;flex-direction:column;gap:4px;padding-right:12px;font-size:10px}\n.move-row b{font-size:10px}\n.move-row small{color:#777;font-size:8px}\n.move-row>span:nth-child(4)>b,.move-row>span:nth-child(5)>b{font:600 14px \"DM Mono\"}\n.move-row em{align-self:flex-start;margin-top:2px;padding:3px 6px;border-radius:10px;background:#fff0d3;color:#946000;font:600 7px \"DM Mono\";font-style:normal}\n.move-head{min-height:34px;background:#111;color:#fff}\n.move-head>span{font:600 7px \"DM Mono\";letter-spacing:.08em}\n.move-row:nth-child(odd):not(.move-head){background:#fafafa}\n/* Rate book */\n.rate-book{padding:0!important;overflow:hidden}\n.rate-tools{display:flex;align-items:center;justify-content:space-between;padding:19px}\n.rate-tools h3{font:700 20px \"Manrope\";margin:0}\n.rate-tools input{width:min(320px,45%);border:1px solid #d8dfe2;border-radius:7px;padding:11px 13px;font-size:11px}\n.rate-header,.rate-row{display:grid;grid-template-columns:1fr 150px;align-items:center}\n.rate-header{padding:10px 19px;background:#111;color:#fff;font-size:7px;letter-spacing:1.2px;font-weight:bold}\n.rate-list{max-height:640px;overflow:auto}\n.rate-row{min-height:48px;padding:0 19px;border-bottom:1px solid #eceff0}\n.rate-row>span{display:flex;align-items:center;gap:10px;font-size:10px}\n.rate-row>span i{width:25px;height:25px;border-radius:5px;background:#f8e7e7;color:#d71920;display:grid;place-items:center;font-style:normal}\n.rate-row strong{font:700 14px Georgia;color:#111}\n.rate-row strong small{font:normal 8px Arial;color:#7b858b;margin-left:3px}\n/* Cost code table */\n.cost-code-panel{padding:0!important;overflow:hidden}\n.cost-code-title{display:flex;justify-content:space-between;align-items:center;padding:18px}\n.cost-code-title h3{font:700 18px \"Manrope\";margin:0}\n.cost-code-title>div:last-child{display:flex;gap:20px}\n.cost-code-title>div:last-child span{display:flex;flex-direction:column}\n.cost-code-title small{font-size:7px;color:#838d92;letter-spacing:.7px}\n.cost-code-title b{font:700 15px Georgia;margin-top:3px}\n.cost-code-title .total{border-left:2px solid #d71920;padding-left:18px}\n.cost-code-scroll{max-height:630px;overflow:auto}\n.cost-code-row{display:grid;grid-template-columns:2.2fr .8fr .9fr .9fr 1.25fr 1fr;align-items:center;gap:10px;min-height:60px;padding:8px 18px;border-top:1px solid #eceff0;font-size:9px}\n.cost-code-head{min-height:32px;background:#111;color:#fff;font-size:7px;letter-spacing:.8px;font-weight:bold}\n.cost-code-row>span:first-child{display:flex;flex-direction:column;gap:4px}\n.cost-code-row>span:first-child small{color:#7e8a91}\n.production-input{display:flex!important;flex-direction:row!important;gap:5px;flex-wrap:wrap}\n.production-input input{width:75px;border:1px solid #d7dfe2;border-radius:5px;padding:7px;font-size:9px}\n.production-input select{border:1px solid #d7dfe2;border-radius:5px;background:#fff;padding:7px;font-size:9px}\n.production-input .scope-note{width:100%;font-size:7px;color:#8b969c;margin-top:1px}\n.unit-cost{display:flex;flex-direction:column;color:#b51218}\n.unit-cost b{font:700 14px Georgia}\n.pending-unit em{font-style:normal;color:#929ca1}\n.cost-code-row:nth-child(even):not(.cost-code-head){background:#fafafa}\n.consolidate-button{min-height:34px;margin:12px 0 0;padding:0 12px;border-color:#111;border-radius:9px;background:#fff;color:#111}\n.consolidate-button.active{border-color:#c41230;background:#c41230;color:#fff}\n/* Unit cost summary */\n.unit-summary{display:grid;grid-template-columns:repeat(3,1fr);gap:13px;margin-bottom:13px}\n.unit-summary article{background:#111;color:#fff;border-top:3px solid #d71920;border-radius:8px;padding:18px}\n.unit-summary h2{font:700 28px Georgia;margin:0 0 5px}\n.unit-summary span{font-size:9px;color:#aaa}\n/* Split + chart + forecast */\n.split{display:grid;grid-template-columns:1.2fr 1fr;gap:13px;margin-bottom:13px}\n.title{display:flex;justify-content:space-between}\n.title h3{font:700 17px \"Manrope\";margin:0}\n.title button{border:0;padding:0;color:#d71920;background:transparent}\n.chart{height:190px;border-bottom:1px solid #dfe5e7;margin-top:14px;display:flex;justify-content:space-around;align-items:flex-end;background:repeating-linear-gradient(to bottom,#fff 0,#fff 45px,#edf1f2 46px)}\n.bar{width:16%;height:100%;display:flex;flex-direction:column;justify-content:flex-end;align-items:center}\n.bar>b{font-size:7px}\n.bar>span{height:135px;display:flex;align-items:flex-end;gap:3px}\n.bar>span i,.bar>span em{display:block;width:12px;border-radius:2px 2px 0 0}\n.bar>span i{background:#d71920}\n.bar>span em{background:#78a0ad}\n.bar>small{font-size:7px;color:#8d999f;margin:7px 0 -20px}\n.forecast-card{padding:21px 22px!important}\n.forecast-card.on-track{border-top:4px solid #18824b}\n.forecast-card.watch{border-top:4px solid #d68a00}\n.forecast-card.over{border-top:4px solid #c41230}\n.forecast-head{display:flex;align-items:flex-start;justify-content:space-between;gap:12px}\n.forecast-head h3{margin:0;font-size:17px}\n.forecast-head>span{padding:6px 9px;border-radius:20px;background:#ededed;color:#555;font:600 7px \"DM Mono\";letter-spacing:.06em;white-space:nowrap}\n.forecast-card.on-track .forecast-head>span{background:#e4f3eb;color:#126c3e}\n.forecast-card.watch .forecast-head>span{background:#fff0d3;color:#946000}\n.forecast-card.over .forecast-head>span{background:#f8e2e6;color:#a40f29}\n.forecast-inputs{display:grid;grid-template-columns:1fr 1fr;gap:9px;margin-top:14px}\n.forecast-inputs label{padding:10px 11px;border:1px solid #dedede;border-radius:11px;background:#fafafa}\n.forecast-inputs small,.forecast-result small,.forecast-bars small{display:block;color:#777;font:500 7px \"DM Mono\";letter-spacing:.06em}\n.forecast-inputs label>div{display:flex;align-items:center;margin-top:5px}\n.forecast-inputs i{color:#777;font:500 12px \"DM Mono\";font-style:normal}\n.forecast-inputs input{width:100%;border:0;outline:0;background:transparent;font:600 15px \"DM Mono\"}\n.forecast-bars{display:grid;grid-template-columns:1fr 1fr;gap:10px;margin-top:13px}\n.forecast-bars>div>span{display:flex;align-items:center;justify-content:space-between}\n.forecast-bars b{font:600 11px \"DM Mono\"}\n.forecast-bars>div>i{display:block;height:6px;margin-top:6px;border-radius:8px;background:#e8e8e8}\n.forecast-bars em{display:block;height:100%;border-radius:8px;background:#111}\n.forecast-bars em.over{background:#c41230}\n.forecast-result{display:grid;grid-template-columns:1fr 1fr 1.2fr;gap:8px;margin-top:14px;padding-top:12px;border-top:1px solid #e5e5e5}\n.forecast-result>span{display:flex;flex-direction:column;gap:4px}\n.forecast-result b{font:600 12px \"DM Mono\"}\n.forecast-result em{font-size:7px;color:#777;font-style:normal}\n.forecast-result .positive b{color:#126c3e}\n.forecast-result .negative b{color:#b10f2a}\n.forecast-empty{display:flex;flex-direction:column;gap:4px;margin-top:14px;padding:12px;border-radius:11px;background:#f3f3f3}\n.forecast-empty b{font-size:9px}\n.forecast-empty span{font-size:8px;line-height:1.45;color:#777}\n/* Reports */\n.report-view{display:grid;grid-template-columns:1.15fr .85fr;gap:14px}\n.report-cover{background:#111!important;color:#fff!important;border-left:5px solid #d71920!important;padding:28px!important}\n.report-cover h2{font:700 31px Georgia;margin:0 0 8px}\n.report-cover>span{font-size:10px;color:#aaa}\n.report-kpis{display:grid;grid-template-columns:1fr 1fr;gap:10px;margin-top:32px}\n.report-kpis>div{border:1px solid #373737;border-radius:7px;padding:16px;display:flex;flex-direction:column;gap:6px}\n.report-kpis small{font-size:7px;color:#aaa;letter-spacing:1px}\n.report-kpis b{font:700 20px Georgia}\n.report-rank{padding:22px!important}\n.rank-row{display:grid;grid-template-columns:30px 1fr auto;align-items:center;gap:10px;padding:13px 0;border-bottom:1px solid #eceff0}\n.rank-row i{width:24px;height:24px;background:#d71920;color:#fff;border-radius:50%;display:grid;place-items:center;font-style:normal;font-size:8px;font-weight:bold}\n.rank-row span{display:flex;flex-direction:column;gap:4px}\n.rank-row b{font-size:9px}\n.rank-row small{font-size:8px;color:#88949a}\n.rank-row strong{font:700 13px Georgia}\n.report-print{margin-top:18px;display:flex;justify-content:flex-end}\n.report-print button{margin:0}\n@media(max-width:900px){.report-view{grid-template-columns:1fr}.unit-summary{grid-template-columns:1fr}.labor-settings{grid-template-columns:1fr}.rate-input-grid{grid-template-columns:1fr}.operations-grid{grid-template-columns:1fr}.split{grid-template-columns:1fr}.cost-code-panel{overflow:auto}.cost-code-scroll{min-width:900px}.cost-code-title{min-width:900px}}\n@media(max-width:700px){.phase-detail{grid-template-columns:1fr}.rate-tools input{width:60%}.rate-header,.rate-row{grid-template-columns:1fr 95px}}\n@media print{aside,.header-actions,.import-strip,.logout,.monday-strip,.phase-controls,.report-print{display:none!important}.shell main{margin:0;width:100%;padding:0}.report-view{grid-template-columns:1fr 1fr}.panel{box-shadow:none;border:1px solid #ddd}}\n/* Forgot password link on the login / recovery cards */\n.auth-forgot{margin:14px 0 0;text-align:center}\n.auth-forgot .linklike{background:none;border:0;margin:0;padding:0;color:#b51218;font-size:11px;font-weight:700;cursor:pointer;text-decoration:underline}\n.auth-forgot .linklike:hover{color:#8f0e15}\n.auth-forgot .linklike:disabled{color:#aaa;cursor:not-allowed;text-decoration:none}\n/* Inline job editor — full-page section inside Jobs & Settings (replaces the old Edit modal) */\n.job-editor{padding:22px!important}\n.job-editor .view-head{margin-bottom:6px}\n.job-editor-form{max-width:860px}\n.job-editor-toolbar{display:flex;align-items:center;gap:8px;padding:14px 0}\n.job-editor-toolbar.top{border-bottom:1px solid #ececec;margin-bottom:8px}\n.job-editor-toolbar.bottom{border-top:1px solid #ececec;margin-top:8px}\n.job-editor-toolbar button{margin:0;min-height:40px;padding:0 18px;border-radius:10px}\n.job-editor-meta{flex:1;font-size:9px;color:#7a848a;text-align:left}\n.job-editor .form-grid{margin:18px 0}\n.job-editor label{display:flex;flex-direction:column;gap:6px;font-size:7px;font-weight:bold;color:#7d8b93}\n.job-editor .wide{grid-column:1/-1}\n.job-editor input{border:1px solid #d8e0e3;border-radius:10px;padding:11px 12px;font-size:12px}\n/* Monday refresh note / error + enabled refresh button */\n.monday-strip>div>span.monday-note{color:#126c3e}\n.monday-strip>div>span.monday-error{color:#b51218;font-weight:700}\n.monday-strip:not(.not-connected)>button{border-color:#111;background:#111;color:#fff;cursor:pointer;margin-left:0}\n.monday-strip:not(.not-connected)>button:hover{background:#292929}\n.monday-strip button:disabled{background:#f0f0f0;color:#999;cursor:not-allowed}\n",[],[306,395],"de051783-ca3e-431f-9e6c-dbdc3e98605a","root.tsx","bcd5b7d8-a7d3-11f1-893b-1607ee4eb77e",6,["D",1788466327307],"/** @jsxImportSource npm:hono@4/jsx */\nimport { raw } from \"npm:hono@4/html\";\nimport { immutableFileUrl } from \"https://esm.town/v/std/utils/index.ts\";\n\nexport function Root() {\n return (\n <>\n {raw(\"<!DOCTYPE html>\")}\n <html lang=\"en\">\n <head>\n <meta charSet=\"UTF-8\" />\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />\n <title>NDX Command Center — Production Control\n \n \n \n \n \n \n \n

Configure the command center

Sign in

Password updated

Reset your password

{sectionCopy[section][0]}

Delete \"{activeJob.name}\"?

History · App.tsx