[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_321":322,"_323":324},"routes/_app.x.$handle.$name",{"_98":97,"_31":44,"_107":88,"_26":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":24,"_122":123,"_124":57,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":30,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":24},"version",19,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","backend/index.ts","latestPath","fileId","f4a2db4a-7e71-11f1-af93-1607ee4eb77e","name","index.ts","fileType","http","content","import { Hono } from \"npm:hono\";\nimport { blob } from \"https://esm.town/v/std/blob\";\nimport { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport * as db from \"./database/queries.ts\";\nimport type { ScanResult } from \"../shared/types.ts\";\n\nawait runMigrations();\n\nconst app = new Hono();\n\n// ---------- Frontend ----------\napp.get(\"/\", (c) => serveFile(\"/frontend/index.html\"));\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\napp.get(\"/shared/**/*\", (c) => serveFile(c.req.path));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// ---------- Scan: resolve code เป็น item หรือ location ----------\napp.get(\"/api/scan/:code\", async (c) => {\n const code = decodeURIComponent(c.req.param(\"code\")).trim();\n const item = await db.getItemByCode(code);\n if (item) return c.json({ type: \"item\", item } satisfies ScanResult);\n const location = await db.getLocationByCode(code);\n if (location) {\n const items = await db.itemsAtLocation(location.id);\n return c.json({ type: \"location\", location, items } satisfies ScanResult);\n }\n return c.json({ type: \"not_found\", code } satisfies ScanResult);\n});\n\n// ---------- Items ----------\napp.get(\"/api/items\", async (c) => c.json(await db.searchItems(c.req.query(\"q\") ?? \"\")));\n\napp.post(\"/api/items\", async (c) => {\n const body = await c.req.json();\n if (!body.name?.trim()) return c.json({ error: \"ต้องระบุชื่อของ\" }, 400);\n try {\n return c.json(await db.createItem(body), 201);\n } catch (e) {\n return c.json({ error: String(e.message ?? e) }, 400);\n }\n});\n\napp.get(\"/api/items/:code\", async (c) => {\n const item = await db.getItemByCode(c.req.param(\"code\"));\n if (!item) return c.json({ error: \"ไม่พบของ\" }, 404);\n const history = await db.itemHistory(item.id);\n return c.json({ ...item, history });\n});\n\napp.put(\"/api/items/:code\", async (c) => {\n try {\n const item = await db.updateItem(c.req.param(\"code\"), await c.req.json());\n if (!item) return c.json({ error: \"ไม่พบของ\" }, 404);\n return c.json(item);\n } catch (e) {\n return c.json({ error: String(e.message ?? e) }, 400);\n }\n});\n\napp.delete(\"/api/items/:code\", async (c) => {\n const ok = await db.deleteItem(c.req.param(\"code\"));\n return ok ? c.json({ ok: true }) : c.json({ error: \"ไม่พบของ\" }, 404);\n});\n\napp.post(\"/api/items/:code/checkout\", async (c) => {\n const { actor, note } = await c.req.json();\n if (!actor?.trim()) return c.json({ error: \"ต้องระบุชื่อผู้ยืม\" }, 400);\n const item = await db.checkoutItem(c.req.param(\"code\"), actor, note);\n if (!item) return c.json({ error: \"ไม่พบของ\" }, 404);\n return c.json(item);\n});\n\napp.post(\"/api/items/:code/checkin\", async (c) => {\n const { actor, note } = await c.req.json().catch(() => ({}));\n const item = await db.checkinItem(c.req.param(\"code\"), actor, note);\n if (!item) return c.json({ error: \"ไม่พบของ\" }, 404);\n return c.json(item);\n});\n\n// ---------- Locations ----------\napp.get(\"/api/locations\", async (c) => c.json(await db.listLocations()));\n\napp.post(\"/api/locations\", async (c) => {\n const body = await c.req.json();\n if (!body.code?.trim() || !body.name?.trim()) {\n return c.json({ error: \"ต้องระบุรหัสและชื่อตำแหน่ง\" }, 400);\n }\n const exists = await db.getLocationByCode(body.code.trim());\n if (exists) return c.json({ error: `รหัส ${body.code} มีอยู่แล้ว` }, 400);\n return c.json(await db.createLocation({ ...body, code: body.code.trim() }), 201);\n});\n\napp.get(\"/api/locations/:code\", async (c) => {\n const loc = await db.getLocationByCode(c.req.param(\"code\"));\n if (!loc) return c.json({ error: \"ไม่พบตำแหน่ง\" }, 404);\n const items = await db.itemsAtLocation(loc.id);\n return c.json({ ...loc, items });\n});\n\napp.put(\"/api/locations/:code\", async (c) => {\n const loc = await db.updateLocation(c.req.param(\"code\"), await c.req.json());\n if (!loc) return c.json({ error: \"ไม่พบตำแหน่ง\" }, 404);\n return c.json(loc);\n});\n\napp.delete(\"/api/locations/:code\", async (c) => {\n const ok = await db.deleteLocation(c.req.param(\"code\"));\n return ok ? c.json({ ok: true }) : c.json({ error: \"ไม่พบตำแหน่ง\" }, 404);\n});\n\n// ---------- Photos (Blob storage) ----------\napp.post(\"/api/photos\", async (c) => {\n const { data } = await c.req.json(); // data URL: \"data:image/jpeg;base64,...\"\n if (!data?.startsWith(\"data:image/\")) return c.json({ error: \"รูปไม่ถูกต้อง\" }, 400);\n const [meta, b64] = data.split(\",\");\n const mime = meta.slice(5, meta.indexOf(\";\"));\n const bytes = Uint8Array.from(atob(b64), (ch) => ch.charCodeAt(0));\n const key = `inv-photo-${Date.now()}-${Math.random().toString(36).slice(2, 8)}`;\n await blob.set(key, bytes, { contentType: mime } as any);\n return c.json({ key }, 201);\n});\n\napp.get(\"/api/photos/:key\", async (c) => {\n const res = await blob.get(c.req.param(\"key\"));\n if (!res) return c.text(\"not found\", 404);\n const buf = await res.arrayBuffer();\n return new Response(buf, {\n headers: { \"Content-Type\": \"image/jpeg\", \"Cache-Control\": \"public, max-age=31536000\" },\n });\n});\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","createdAt",["D",1783916332535],"branchVersion","branchId","af448eeb-7922-4aaa-a659-aa42ee57401b","id","55ec7efc-0177-4dc8-a624-bde4fe9ba584","smart_inventory",["D",1783916173471],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","ระบบจัดเก็บอุปกรณ์ให้ตรงตำแหน่ง","imageUrl","e7e09ecc-b296-440b-aa22-8451cadfb468","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f353a-2c6c-715b-8e24-ae36d53494a6","tursoName","55ec7efc01774dc8a624bde4fe9ba584","tursoHostname","55ec7efc01774dc8a624bde4fe9ba584-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789524079207],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":54,"_103":104,"_105":24},"branch",{"_13":87,"_31":88,"_42":41,"_89":43,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":44,"_96":97},"isOwned",63,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","thammanoonkarawan","handle","displayName","Thammanoon Karawan","avatar","https://lh3.googleusercontent.com/a/ACg8ocK86-3oUj6Tei8TnGq-HiPlZ0zGWZAeiMJT5jfdKonvUFy-PdD-=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":316,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":30,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":317,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":318,"_82":319,"_84":320,"_86":24},"tree",[164,169,181],"files",[164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182],"counts",{"_154":61,"_155":151,"_156":61,"_157":158,"_159":160},"contents",[129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":148,"_31":149,"_29":150,"_135":-5,"_40":41,"_39":151,"_137":57,"_37":152,"_13":61,"_33":139,"_35":-5,"_23":24,"_140":-5,"_26":153},{"_42":142,"_31":143,"_29":144,"_135":-5,"_40":41,"_39":145,"_137":57,"_37":146,"_13":61,"_33":139,"_35":-5,"_23":24,"_140":-5,"_26":147},{"_42":132,"_31":133,"_29":134,"_135":-5,"_40":41,"_39":136,"_137":57,"_37":138,"_13":61,"_33":139,"_35":-5,"_23":24,"_140":-5,"_26":141},"dad23590-dcc3-4845-b80f-64401da2913a","shared","9ef2db96-7e71-11f1-8e71-1607ee4eb77e","parentId",2,"latest",["D",1783916188808],"directory","label",[133],"eb4df453-8942-45b0-bccb-0a5d2e4c0642","frontend","9f337386-7e71-11f1-ab9b-1607ee4eb77e",3,["D",1783916189244],[143],"ab06c930-73b2-4a0c-b439-de76dce04bdf","backend","9eb48a4e-7e71-11f1-9a86-1607ee4eb77e",1,["D",1783916188403],[149],"pulls","branches","forks","envVars",{"_161":61,"_163":61},"connections",{"_161":61,"_162":61},"count","unfilledCount","emptyCount",{"_42":148,"_31":149,"_29":150,"_135":-5,"_40":41,"_39":151,"_137":57,"_37":313,"_13":61,"_33":139,"_35":-5,"_23":24,"_140":-5,"_190":314,"_26":315},{"_42":308,"_31":299,"_29":293,"_135":150,"_40":41,"_39":309,"_137":57,"_37":310,"_13":61,"_33":139,"_35":-5,"_23":24,"_140":-5,"_190":311,"_26":312},{"_42":300,"_31":301,"_29":302,"_135":293,"_40":41,"_39":303,"_137":24,"_37":304,"_13":61,"_33":188,"_35":305,"_23":24,"_140":-5,"_190":306,"_26":307},{"_42":290,"_31":291,"_29":292,"_135":293,"_40":41,"_39":294,"_137":24,"_37":295,"_13":61,"_33":188,"_35":296,"_23":24,"_140":-5,"_190":297,"_26":298},{"_42":286,"_31":32,"_29":30,"_135":150,"_40":41,"_39":14,"_137":24,"_37":287,"_13":61,"_33":34,"_35":36,"_23":24,"_140":-5,"_190":288,"_26":289},{"_42":142,"_31":143,"_29":144,"_135":-5,"_40":41,"_39":145,"_137":57,"_37":283,"_13":61,"_33":139,"_35":-5,"_23":24,"_140":-5,"_190":284,"_26":285},{"_42":278,"_31":221,"_29":215,"_135":144,"_40":41,"_39":279,"_137":57,"_37":280,"_13":61,"_33":139,"_35":-5,"_23":24,"_140":-5,"_190":281,"_26":282},{"_42":270,"_31":271,"_29":272,"_135":215,"_40":41,"_39":273,"_137":24,"_37":274,"_13":61,"_33":188,"_35":275,"_23":24,"_140":-5,"_190":276,"_26":277},{"_42":262,"_31":263,"_29":264,"_135":215,"_40":41,"_39":265,"_137":24,"_37":266,"_13":61,"_33":188,"_35":267,"_23":24,"_140":-5,"_190":268,"_26":269},{"_42":254,"_31":255,"_29":256,"_135":215,"_40":41,"_39":257,"_137":24,"_37":258,"_13":61,"_33":188,"_35":259,"_23":24,"_140":-5,"_190":260,"_26":261},{"_42":246,"_31":247,"_29":248,"_135":215,"_40":41,"_39":249,"_137":24,"_37":250,"_13":61,"_33":188,"_35":251,"_23":24,"_140":-5,"_190":252,"_26":253},{"_42":238,"_31":239,"_29":240,"_135":215,"_40":41,"_39":241,"_137":24,"_37":242,"_13":61,"_33":188,"_35":243,"_23":24,"_140":-5,"_190":244,"_26":245},{"_42":230,"_31":231,"_29":232,"_135":215,"_40":41,"_39":233,"_137":24,"_37":234,"_13":61,"_33":188,"_35":235,"_23":24,"_140":-5,"_190":236,"_26":237},{"_42":222,"_31":223,"_29":224,"_135":215,"_40":41,"_39":225,"_137":24,"_37":226,"_13":61,"_33":188,"_35":227,"_23":24,"_140":-5,"_190":228,"_26":229},{"_42":212,"_31":213,"_29":214,"_135":215,"_40":41,"_39":216,"_137":24,"_37":217,"_13":61,"_33":188,"_35":218,"_23":24,"_140":-5,"_190":219,"_26":220},{"_42":204,"_31":205,"_29":206,"_135":144,"_40":41,"_39":207,"_137":24,"_37":208,"_13":61,"_33":20,"_35":209,"_23":24,"_140":-5,"_190":210,"_26":211},{"_42":196,"_31":197,"_29":198,"_135":144,"_40":41,"_39":199,"_137":57,"_37":200,"_13":61,"_33":188,"_35":201,"_23":24,"_140":-5,"_190":202,"_26":203},{"_42":132,"_31":133,"_29":134,"_135":-5,"_40":41,"_39":136,"_137":57,"_37":193,"_13":61,"_33":139,"_35":-5,"_23":24,"_140":-5,"_190":194,"_26":195},{"_42":183,"_31":184,"_29":185,"_135":134,"_40":41,"_39":186,"_137":24,"_37":187,"_13":61,"_33":188,"_35":189,"_23":24,"_140":-5,"_190":191,"_26":192},"505dd58b-3527-4587-a027-e49f31e64161","types.ts","a42f6de0-7e71-11f1-9478-1607ee4eb77e",6,["D",1783916197608],"script","export interface Location {\n id: number;\n code: string;\n name: string;\n note: string | null;\n photo_key: string | null;\n created_at: string;\n item_count?: number;\n}\n\nexport interface Item {\n id: number;\n code: string;\n name: string;\n category: string | null;\n note: string | null;\n photo_key: string | null;\n home_location_id: number | null;\n status: \"stored\" | \"borrowed\";\n borrowed_by: string | null;\n created_at: string;\n // joined fields\n location_code?: string | null;\n location_name?: string | null;\n}\n\nexport interface Movement {\n id: number;\n item_id: number;\n action: \"register\" | \"checkout\" | \"checkin\" | \"move\";\n actor: string | null;\n note: string | null;\n created_at: string;\n}\n\nexport type ScanResult =\n | { type: \"item\"; item: Item }\n | { type: \"location\"; location: Location; items: Item[] }\n | { type: \"not_found\"; code: string };\n","children",[],[133,184],["D",1783916188808],[182],[133],"87211446-cda4-425a-a0fe-e3cc1009765a","index.tsx","b58986f2-7e71-11f1-a52f-1607ee4eb77e",10,["D",1783916226714],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\ncreateRoot(document.getElementById(\"root\")!).render();\n",[],[143,197],"4584ad33-5b3e-4335-ab21-6c779b0515a2","index.html","b4bf696c-7e71-11f1-948b-1607ee4eb77e",9,["D",1783916225374],"\n\n\n \n \n Smart Inventory — ระบบจัดเก็บอุปกรณ์\n \n \n \n\n\n

\n \n\n\n",[],[143,205],"f1845c5d-3f49-45b6-8de5-15c468309f25","lib.tsx","c026e3a2-7e71-11f1-95f4-1607ee4eb77e","a10b3cc0-7e71-11f1-b3f0-1607ee4eb77e",12,["D",1783916244523],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Item } from \"../../shared/types.ts\";\n\nexport async function api(path: string, opts?: RequestInit): Promise {\n const res = await fetch(path, {\n headers: { \"Content-Type\": \"application/json\" },\n ...opts,\n });\n const data = await res.json();\n if (!res.ok) throw new Error(data.error ?? `HTTP ${res.status}`);\n return data;\n}\n\n/** ย่อรูปเป็น JPEG data URL (max 1024px) แล้วอัปโหลด → คืน photo key */\nexport async function uploadPhoto(file: File): Promise {\n const dataUrl = await new Promise((resolve, reject) => {\n const img = new Image();\n img.onload = () => {\n const scale = Math.min(1, 1024 / Math.max(img.width, img.height));\n const canvas = document.createElement(\"canvas\");\n canvas.width = Math.round(img.width * scale);\n canvas.height = Math.round(img.height * scale);\n canvas.getContext(\"2d\")!.drawImage(img, 0, 0, canvas.width, canvas.height);\n resolve(canvas.toDataURL(\"image/jpeg\", 0.8));\n };\n img.onerror = reject;\n img.src = URL.createObjectURL(file);\n });\n const { key } = await api<{ key: string }>(\"/api/photos\", {\n method: \"POST\",\n body: JSON.stringify({ data: dataUrl }),\n });\n return key;\n}\n\nexport function PhotoInput(props: { photoKey: string | null; onChange: (key: string | null) => void }) {\n const [busy, setBusy] = useState(false);\n return (\n

\n {props.photoKey && (\n

\n )}\n \n {busy ? \"กำลังอัปโหลด...\" : props.photoKey ? \"เปลี่ยนรูป\" : \"📸 เพิ่มรูป\"}\n {\n const file = e.target.files?.[0];\n if (!file) return;\n setBusy(true);\n try {\n props.onChange(await uploadPhoto(file));\n } catch (err) {\n alert(`อัปโหลดรูปไม่สำเร็จ: ${err}`);\n } finally {\n setBusy(false);\n }\n }}\n />\n \n {props.photoKey && (\n \n )}\n

\n );\n}\n\nexport function StatusBadge({ item }: { item: Item }) {\n return item.status === \"borrowed\" ? (\n \n ถูกยืมโดย {item.borrowed_by}\n \n ) : (\n อยู่ที่เก็บ\n );\n}\n\nexport function ItemCard(props: { item: Item; onClick?: () => void; children?: any }) {\n const { item } = props;\n return (\n \n {item.photo_key ? (\n

\n ) : (\n

📦

\n )}\n

\n {item.code}\n \n

{item.name}

\n 📍 {item.location_code ? `${item.location_code} — ${item.location_name}` : \"ยังไม่กำหนดตำแหน่ง\"}\n

\n {props.children}\n \n );\n}\n",[],[143,221,213],"components","28702952-d7e8-438b-bd92-d0a57f227cf3","SearchTab.tsx","c3e6005e-7e71-11f1-9ad9-1607ee4eb77e",13,["D",1783916250816],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Item } from \"../../shared/types.ts\";\nimport { api, ItemCard } from \"./lib.tsx\";\nimport { ItemDetail } from \"./ItemDetail.tsx\";\n\nexport function SearchTab() {\n const [q, setQ] = useState(\"\");\n const [items, setItems] = useState([]);\n const [loading, setLoading] = useState(false);\n const [selected, setSelected] = useState(null);\n\n useEffect(() => {\n const t = setTimeout(async () => {\n setLoading(true);\n try {\n setItems(await api(`/api/items?q=${encodeURIComponent(q)}`));\n } finally {\n setLoading(false);\n }\n }, 300);\n return () => clearTimeout(t);\n }, [q]);\n\n if (selected) {\n return setSelected(null)} onChanged={() => setQ(q + \"\")} />;\n }\n\n return (\n

\n setQ(e.target.value)}\n placeholder=\"🔍 พิมพ์ชื่อของ / รหัส / หมวดหมู่ เช่น ประแจ, T-0042\"\n className=\"w-full px-4 py-3 rounded-lg border shadow-sm text-lg\"\n />\n {loading &&

กำลังค้นหา...

}\n {!loading && items.length === 0 && (\n

\n {q ? `ไม่พบ \"${q}\"` : \"ยังไม่มีของในระบบ — ไปที่แท็บ 📦 ของ เพื่อเพิ่ม\"}\n

\n )}\n {items.map((item) => (\n setSelected(item.code)} />\n ))}\n

\n );\n}\n",[],[143,221,223],"8c6db944-27fb-4067-994e-0b9835909b95","ScanTab.tsx","cad6e3ce-7e71-11f1-8935-1607ee4eb77e",14,["D",1783916262460],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useRef, useState } from \"https://esm.sh/react@18.2.0\";\nimport type { ScanResult } from \"../../shared/types.ts\";\nimport { api, ItemCard } from \"./lib.tsx\";\nimport { ItemDetail } from \"./ItemDetail.tsx\";\n\nexport function ScanTab() {\n const [result, setResult] = useState(null);\n const [manual, setManual] = useState(\"\");\n const [scanning, setScanning] = useState(false);\n const [detail, setDetail] = useState(null);\n const scannerRef = useRef(null);\n\n const resolve = async (code: string) => {\n setResult(await api(`/api/scan/${encodeURIComponent(code.trim())}`));\n };\n\n const startScan = async () => {\n setScanning(true);\n setResult(null);\n try {\n const { Html5Qrcode } = await import(\"https://esm.sh/html5-qrcode@2.3.8\");\n const scanner = new Html5Qrcode(\"qr-reader\");\n scannerRef.current = scanner;\n await scanner.start(\n { facingMode: \"environment\" },\n { fps: 10, qrbox: { width: 220, height: 220 } },\n async (text: string) => {\n await stopScan();\n await resolve(text);\n },\n () => {},\n );\n } catch (e) {\n alert(`เปิดกล้องไม่ได้: ${e}\\nลองพิมพ์รหัสด้วยมือแทน`);\n setScanning(false);\n }\n };\n\n const stopScan = async () => {\n try {\n await scannerRef.current?.stop();\n scannerRef.current?.clear();\n } catch {}\n scannerRef.current = null;\n setScanning(false);\n };\n\n useEffect(() => () => { stopScan(); }, []);\n\n if (detail) {\n return setDetail(null)} />;\n }\n\n return (\n

\n {!scanning ? (\n \n 📷 เปิดกล้องสแกน QR\n \n ) : (\n \n )}\n

\n {\n e.preventDefault();\n if (manual.trim()) resolve(manual);\n }}\n >\n setManual(e.target.value)}\n placeholder=\"หรือพิมพ์รหัส เช่น T-0001, A-01-2\"\n className=\"flex-1 px-3 py-2 border rounded-lg\"\n />\n \n \n

\n\n {result?.type === \"item\" && (\n

\n ✅ พบของ! เก็บที่: \n {result.item.location_code\n ? `${result.item.location_code} — ${result.item.location_name}`\n : \"ยังไม่กำหนดตำแหน่ง\"}\n \n

\n setDetail(result.item.code)} />\n

\n )}\n\n {result?.type === \"location\" && (\n

\n 🗄️ ตำแหน่ง {result.location.code} — {result.location.name}{\" \"}\n มีของ {result.items.length} ชิ้น\n

\n {result.items.map((item) => (\n setDetail(item.code)} />\n ))}\n

\n )}\n\n {result?.type === \"not_found\" && (\n

\n ❌ ไม่พบรหัส \"{result.code}\" ในระบบ\n

\n )}\n

\n );\n}\n",[],[143,221,231],"b0dc28e9-ebb0-4cc4-a059-1ae0fbd5e783","LocationsTab.tsx","d773dee8-7e71-11f1-8792-1607ee4eb77e",16,["D",1783916283610],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Location } from \"../../shared/types.ts\";\nimport { api, PhotoInput } from \"./lib.tsx\";\n\nconst EMPTY = { code: \"\", name: \"\", note: \"\", photo_key: null as string | null };\n\nexport function LocationsTab() {\n const [locations, setLocations] = useState([]);\n const [adding, setAdding] = useState(false);\n const [form, setForm] = useState(EMPTY);\n const [saving, setSaving] = useState(false);\n\n const load = () => api(\"/api/locations\").then(setLocations);\n useEffect(() => { load(); }, []);\n\n return (\n

\n setAdding(!adding)}\n className=\"w-full bg-blue-600 text-white py-3 rounded-lg font-medium\"\n >\n {adding ? \"✖ ยกเลิก\" : \"➕ เพิ่มตำแหน่งเก็บ\"}\n \n\n {adding && (\n {\n e.preventDefault();\n setSaving(true);\n try {\n await api(\"/api/locations\", { method: \"POST\", body: JSON.stringify(form) });\n setForm(EMPTY);\n setAdding(false);\n await load();\n } catch (err) {\n alert(String(err));\n } finally {\n setSaving(false);\n }\n }}\n >\n setForm({ ...form, code: e.target.value.toUpperCase() })}\n placeholder=\"รหัสตำแหน่ง * เช่น A-01-2 (ชั้น A แถว 01 ช่อง 2)\"\n />\n setForm({ ...form, name: e.target.value })}\n placeholder=\"ชื่อ * เช่น ตู้เครื่องมือ ชั้นบน ช่องซ้าย\"\n />\n setForm({ ...form, note: e.target.value })}\n placeholder=\"หมายเหตุ\"\n />\n setForm({ ...form, photo_key: k })} />\n \n \n )}\n\n

ทั้งหมด {locations.length} ตำแหน่ง

\n {locations.map((loc) => (\n

\n {loc.photo_key ? (\n

\n ) : (\n

🗄️

\n )}\n

{loc.code}

{loc.name}

{loc.item_count ?? 0} ชิ้น{loc.note ? ` · ${loc.note}` : \"\"}

\n {\n if (confirm(`ลบตำแหน่ง ${loc.code}? ของในตำแหน่งนี้จะกลายเป็น \"ไม่กำหนดตำแหน่ง\"`)) {\n await api(`/api/locations/${loc.code}`, { method: \"DELETE\" });\n await load();\n }\n }}\n >\n 🗑️\n \n

\n ))}\n

\n );\n}\n",[],[143,221,239],"f6b3d88a-d339-4e25-9ff0-3b60001238f6","LabelsTab.tsx","df0261a2-7e71-11f1-b6f0-1607ee4eb77e",17,["D",1783916296297],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Item, Location } from \"../../shared/types.ts\";\nimport { api } from \"./lib.tsx\";\n\ninterface Label {\n code: string;\n title: string;\n kind: \"item\" | \"location\";\n}\n\nexport function LabelsTab() {\n const [items, setItems] = useState([]);\n const [locations, setLocations] = useState([]);\n const [selected, setSelected] = useState>(new Set());\n const [qrs, setQrs] = useState>({});\n\n useEffect(() => {\n api(\"/api/items\").then(setItems);\n api(\"/api/locations\").then(setLocations);\n }, []);\n\n const labels: Label[] = [\n ...locations.map((l) => ({ code: l.code, title: l.name, kind: \"location\" as const })),\n ...items.map((i) => ({ code: i.code, title: i.name, kind: \"item\" as const })),\n ];\n const chosen = labels.filter((l) => selected.has(l.code));\n\n // สร้าง QR data URL สำหรับป้ายที่เลือก\n useEffect(() => {\n (async () => {\n const missing = chosen.filter((l) => !qrs[l.code]);\n if (missing.length === 0) return;\n const QRCode = (await import(\"https://esm.sh/qrcode@1.5.3\")).default;\n const next: Record = {};\n for (const l of missing) {\n next[l.code] = await QRCode.toDataURL(l.code, { width: 256, margin: 1 });\n }\n setQrs((prev) => ({ ...prev, ...next }));\n })();\n }, [selected, items, locations]);\n\n const toggle = (code: string) => {\n const next = new Set(selected);\n next.has(code) ? next.delete(code) : next.add(code);\n setSelected(next);\n };\n\n const selectAll = (kind: \"item\" | \"location\") => {\n const next = new Set(selected);\n labels.filter((l) => l.kind === kind).forEach((l) => next.add(l.code));\n setSelected(next);\n };\n\n return (\n

\n \n \n \n window.print()}\n disabled={chosen.length === 0}\n className=\"bg-blue-600 text-white px-4 py-1.5 rounded text-sm font-medium disabled:opacity-40 ml-auto\"\n >\n 🖨️ พิมพ์ ({chosen.length})\n \n

\n {labels.map((l) => (\n \n toggle(l.code)} />\n {l.kind === \"location\" ? \"🗄️\" : \"📦\"}\n {l.code}\n {l.title}\n \n ))}\n {labels.length === 0 &&

ยังไม่มีข้อมูล

}\n

\n 💡 พิมพ์ลงกระดาษสติกเกอร์ A4 แล้วตัดติดของ/ชั้นวาง — ป้ายละ ~4×4 ซม.\n

\n\n {/* พื้นที่พิมพ์ */}\n

\n {chosen.map((l) => (\n

\n {qrs[l.code] &&

}\n

{l.code}

{l.title}

\n ))}\n

\n );\n}\n",[],[143,221,247],"2437425e-fbe9-47c4-b445-bae234289dae","ItemsTab.tsx","d10f3476-7e71-11f1-b904-1607ee4eb77e",15,["D",1783916272867],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Item, Location } from \"../../shared/types.ts\";\nimport { api, ItemCard, PhotoInput } from \"./lib.tsx\";\nimport { ItemDetail } from \"./ItemDetail.tsx\";\n\nconst EMPTY = { name: \"\", category: \"\", note: \"\", photo_key: null as string | null, home_location_code: \"\" };\n\nexport function ItemsTab() {\n const [items, setItems] = useState([]);\n const [locations, setLocations] = useState([]);\n const [adding, setAdding] = useState(false);\n const [form, setForm] = useState(EMPTY);\n const [detail, setDetail] = useState(null);\n const [saving, setSaving] = useState(false);\n\n const load = () => api(\"/api/items\").then(setItems);\n useEffect(() => {\n load();\n api(\"/api/locations\").then(setLocations);\n }, []);\n\n if (detail) {\n return { setDetail(null); load(); }} />;\n }\n\n return (\n

\n setAdding(!adding)}\n className=\"w-full bg-blue-600 text-white py-3 rounded-lg font-medium\"\n >\n {adding ? \"✖ ยกเลิก\" : \"➕ ลงทะเบียนของใหม่\"}\n \n\n {adding && (\n {\n e.preventDefault();\n setSaving(true);\n try {\n const item = await api(\"/api/items\", { method: \"POST\", body: JSON.stringify(form) });\n alert(`ลงทะเบียนแล้ว: ${item.code} ${item.name}\\nอย่าลืมพิมพ์ป้าย QR ที่แท็บ 🏷️`);\n setForm(EMPTY);\n setAdding(false);\n await load();\n } catch (err) {\n alert(String(err));\n } finally {\n setSaving(false);\n }\n }}\n >\n setForm({ ...form, name: e.target.value })}\n placeholder=\"ชื่อของ * เช่น ประแจเลื่อน 10 นิ้ว\"\n />\n setForm({ ...form, category: e.target.value })}\n placeholder=\"หมวดหมู่ เช่น เครื่องมือช่าง\"\n />\n setForm({ ...form, home_location_code: e.target.value })}\n >\n \n {locations.map((l) => (\n \n ))}\n \n setForm({ ...form, note: e.target.value })}\n placeholder=\"หมายเหตุ\"\n />\n setForm({ ...form, photo_key: k })} />\n \n \n )}\n\n

ทั้งหมด {items.length} ชิ้น

\n {items.map((item) => (\n setDetail(item.code)} />\n ))}\n

\n );\n}\n",[],[143,221,255],"d944a69f-b465-4b46-b0fb-c6b344b3bc09","ItemDetail.tsx","e925598c-7e71-11f1-8bce-1607ee4eb77e",18,["D",1783916313302],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Item, Location, Movement } from \"../../shared/types.ts\";\nimport { api, PhotoInput, StatusBadge } from \"./lib.tsx\";\n\nconst ACTION_LABEL: Record = {\n register: \"🆕 ลงทะเบียน\",\n checkout: \"📤 ยืมออก\",\n checkin: \"📥 คืนแล้ว\",\n move: \"🔀 ย้ายตำแหน่ง\",\n};\n\nexport function ItemDetail(props: { code: string; onBack: () => void; onChanged?: () => void }) {\n const [item, setItem] = useState<(Item & { history: Movement[] }) | null>(null);\n const [locations, setLocations] = useState([]);\n const [editing, setEditing] = useState(false);\n const [form, setForm] = useState({});\n const [error, setError] = useState(\"\");\n\n const load = async () => {\n const it = await api(`/api/items/${props.code}`);\n setItem(it);\n setForm({\n name: it.name,\n category: it.category ?? \"\",\n note: it.note ?? \"\",\n photo_key: it.photo_key,\n home_location_code: it.location_code ?? \"\",\n });\n };\n\n useEffect(() => {\n load().catch((e) => setError(String(e)));\n api(\"/api/locations\").then(setLocations);\n }, [props.code]);\n\n if (error) return

{error}

;\n if (!item) return

กำลังโหลด...

;\n\n const doAction = async (fn: () => Promise) => {\n try {\n await fn();\n await load();\n props.onChanged?.();\n } catch (e) {\n alert(String(e));\n }\n };\n\n return (\n

\n \n\n

\n {item.photo_key ? (\n

\n ) : (\n

📦

\n )}\n

{item.code}

{item.name}

\n {item.category &&

หมวด: {item.category}

}\n \n

\n\n

\n 📍 ตำแหน่งเก็บ:{\" \"}\n {item.location_code ? `${item.location_code} — ${item.location_name}` : \"ยังไม่กำหนด\"}\n

\n {item.note &&

📝 {item.note}

}\n\n

\n {item.status === \"stored\" ? (\n {\n const actor = prompt(\"ชื่อผู้ยืม:\");\n if (actor?.trim()) {\n doAction(() =>\n api(`/api/items/${item.code}/checkout`, {\n method: \"POST\",\n body: JSON.stringify({ actor: actor.trim() }),\n })\n );\n }\n }}\n >\n 📤 ยืมออก\n \n ) : (\n doAction(() => api(`/api/items/${item.code}/checkin`, { method: \"POST\", body: \"{}\" }))}\n >\n 📥 คืนของ\n \n )}\n setEditing(!editing)}\n >\n ✏️ แก้ไข\n \n {\n if (confirm(`ลบ ${item.code} ${item.name}?`)) {\n doAction(async () => {\n await api(`/api/items/${item.code}`, { method: \"DELETE\" });\n props.onBack();\n });\n }\n }}\n >\n 🗑️ ลบ\n \n

\n\n {editing && (\n {\n e.preventDefault();\n doAction(async () => {\n await api(`/api/items/${item.code}`, { method: \"PUT\", body: JSON.stringify(form) });\n setEditing(false);\n });\n }}\n >\n setForm({ ...form, name: e.target.value })}\n placeholder=\"ชื่อของ\"\n />\n setForm({ ...form, category: e.target.value })}\n placeholder=\"หมวดหมู่\"\n />\n setForm({ ...form, home_location_code: e.target.value })}\n >\n \n {locations.map((l) => (\n \n ))}\n \n setForm({ ...form, note: e.target.value })}\n placeholder=\"หมายเหตุ\"\n />\n setForm({ ...form, photo_key: k })} />\n \n \n )}\n

\n\n

📜 ประวัติ

\n {item.history.map((m) => (\n

\n \n {ACTION_LABEL[m.action] ?? m.action}\n {m.actor ? ` · ${m.actor}` : \"\"}\n {m.note ? ` · ${m.note}` : \"\"}\n \n {m.created_at}\n

\n ))}\n

\n );\n}\n",[],[143,221,263],"b7cfa950-0a2a-49ec-b517-22699bcce222","App.tsx","b940d016-7e71-11f1-9619-1607ee4eb77e",11,["D",1783916232938],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport { SearchTab } from \"./SearchTab.tsx\";\nimport { ScanTab } from \"./ScanTab.tsx\";\nimport { ItemsTab } from \"./ItemsTab.tsx\";\nimport { LocationsTab } from \"./LocationsTab.tsx\";\nimport { LabelsTab } from \"./LabelsTab.tsx\";\n\nconst TABS = [\n { id: \"search\", label: \"🔍 ค้นหา\" },\n { id: \"scan\", label: \"📷 สแกน\" },\n { id: \"items\", label: \"📦 ของ\" },\n { id: \"locations\", label: \"🗄️ ตำแหน่ง\" },\n { id: \"labels\", label: \"🏷️ ป้าย QR\" },\n] as const;\n\ntype TabId = typeof TABS[number][\"id\"];\n\nexport function App() {\n const [tab, setTab] = useState(\"search\");\n\n return (\n

📦 Smart Inventory

\n ระบบจัดเก็บอุปกรณ์ให้ตรงตำแหน่ง ·{\" \"}\n view source\n

\n\n

\n {tab === \"search\" && }\n {tab === \"scan\" && }\n {tab === \"items\" && }\n {tab === \"locations\" && }\n {tab === \"labels\" && }\n

\n\n \n

\n );\n}\n",[],[143,221,271],"4b31604f-c40a-4f3d-affd-1f04f7a0c8bd",5,["D",1783916192316],[171,172,173,174,175,176,177,178],[143,221],["D",1783916189244],[170,179,180],[143],"d234c130-530c-4263-a67e-2321a28c1056",["D",1783916332535],[],[149,32],"884b2f32-342d-4c89-b584-138e790eb8b0","queries.ts","b2e950b2-7e71-11f1-ad53-1607ee4eb77e","a0cd421c-7e71-11f1-8e71-1607ee4eb77e",8,["D",1783916222310],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport type { Item, Location, Movement } from \"../../shared/types.ts\";\n\nconst ITEM_SELECT = `\n SELECT i.*, l.code AS location_code, l.name AS location_name\n FROM items i LEFT JOIN locations l ON i.home_location_id = l.id\n`;\n\n// ---------- Locations ----------\n\nexport async function listLocations(): Promise {\n const r = await sqlite.execute(`\n SELECT l.*, (SELECT COUNT(*) FROM items i WHERE i.home_location_id = l.id) AS item_count\n FROM locations l ORDER BY l.code\n `);\n return r.rows as unknown as Location[];\n}\n\nexport async function getLocationByCode(code: string): Promise {\n const r = await sqlite.execute({\n sql: \"SELECT * FROM locations WHERE code = ? COLLATE NOCASE\",\n args: [code],\n });\n return (r.rows[0] as unknown as Location) ?? null;\n}\n\nexport async function createLocation(\n data: { code: string; name: string; note?: string; photo_key?: string },\n): Promise {\n await sqlite.execute({\n sql: \"INSERT INTO locations (code, name, note, photo_key) VALUES (?, ?, ?, ?)\",\n args: [data.code, data.name, data.note ?? null, data.photo_key ?? null],\n });\n return (await getLocationByCode(data.code))!;\n}\n\nexport async function updateLocation(\n code: string,\n data: { name?: string; note?: string; photo_key?: string },\n): Promise {\n const loc = await getLocationByCode(code);\n if (!loc) return null;\n await sqlite.execute({\n sql: \"UPDATE locations SET name = ?, note = ?, photo_key = ? WHERE id = ?\",\n args: [\n data.name ?? loc.name,\n data.note !== undefined ? data.note : loc.note,\n data.photo_key !== undefined ? data.photo_key : loc.photo_key,\n loc.id,\n ],\n });\n return await getLocationByCode(code);\n}\n\nexport async function deleteLocation(code: string): Promise {\n const loc = await getLocationByCode(code);\n if (!loc) return false;\n await sqlite.batch([\n { sql: \"UPDATE items SET home_location_id = NULL WHERE home_location_id = ?\", args: [loc.id] },\n { sql: \"DELETE FROM locations WHERE id = ?\", args: [loc.id] },\n ]);\n return true;\n}\n\nexport async function itemsAtLocation(locationId: number): Promise {\n const r = await sqlite.execute({\n sql: `${ITEM_SELECT} WHERE i.home_location_id = ? ORDER BY i.code`,\n args: [locationId],\n });\n return r.rows as unknown as Item[];\n}\n\n// ---------- Items ----------\n\nexport async function searchItems(q: string): Promise {\n if (!q.trim()) {\n const r = await sqlite.execute(`${ITEM_SELECT} ORDER BY i.code LIMIT 200`);\n return r.rows as unknown as Item[];\n }\n const like = `%${q.trim()}%`;\n const r = await sqlite.execute({\n sql: `${ITEM_SELECT}\n WHERE i.name LIKE ? OR i.code LIKE ? OR i.category LIKE ? OR i.note LIKE ?\n ORDER BY i.code LIMIT 200`,\n args: [like, like, like, like],\n });\n return r.rows as unknown as Item[];\n}\n\nexport async function getItemByCode(code: string): Promise {\n const r = await sqlite.execute({\n sql: `${ITEM_SELECT} WHERE i.code = ? COLLATE NOCASE`,\n args: [code],\n });\n return (r.rows[0] as unknown as Item) ?? null;\n}\n\nasync function nextItemCode(): Promise {\n const r = await sqlite.execute(\n \"SELECT code FROM items WHERE code LIKE 'T-%' ORDER BY CAST(SUBSTR(code, 3) AS INTEGER) DESC LIMIT 1\",\n );\n const last = r.rows[0]?.code as string | undefined;\n const n = last ? parseInt(last.slice(2), 10) + 1 : 1;\n return `T-${String(n).padStart(4, \"0\")}`;\n}\n\nexport async function createItem(data: {\n name: string;\n category?: string;\n note?: string;\n photo_key?: string;\n home_location_code?: string;\n actor?: string;\n}): Promise {\n const code = await nextItemCode();\n let homeId: number | null = null;\n if (data.home_location_code) {\n const loc = await getLocationByCode(data.home_location_code);\n if (!loc) throw new Error(`ไม่พบตำแหน่ง ${data.home_location_code}`);\n homeId = loc.id;\n }\n await sqlite.execute({\n sql: `INSERT INTO items (code, name, category, note, photo_key, home_location_id)\n VALUES (?, ?, ?, ?, ?, ?)`,\n args: [code, data.name, data.category ?? null, data.note ?? null, data.photo_key ?? null, homeId],\n });\n const item = (await getItemByCode(code))!;\n await addMovement(item.id, \"register\", data.actor, `ลงทะเบียน${homeId ? ` ที่ ${data.home_location_code}` : \"\"}`);\n return item;\n}\n\nexport async function updateItem(code: string, data: {\n name?: string;\n category?: string;\n note?: string;\n photo_key?: string;\n home_location_code?: string | null;\n actor?: string;\n}): Promise {\n const item = await getItemByCode(code);\n if (!item) return null;\n let homeId = item.home_location_id;\n if (data.home_location_code !== undefined) {\n if (data.home_location_code === null || data.home_location_code === \"\") {\n homeId = null;\n } else {\n const loc = await getLocationByCode(data.home_location_code);\n if (!loc) throw new Error(`ไม่พบตำแหน่ง ${data.home_location_code}`);\n homeId = loc.id;\n }\n if (homeId !== item.home_location_id) {\n await addMovement(item.id, \"move\", data.actor, `ย้ายไป ${data.home_location_code ?? \"(ไม่ระบุ)\"}`);\n }\n }\n await sqlite.execute({\n sql: `UPDATE items SET name = ?, category = ?, note = ?, photo_key = ?, home_location_id = ? WHERE id = ?`,\n args: [\n data.name ?? item.name,\n data.category !== undefined ? data.category : item.category,\n data.note !== undefined ? data.note : item.note,\n data.photo_key !== undefined ? data.photo_key : item.photo_key,\n homeId,\n item.id,\n ],\n });\n return await getItemByCode(code);\n}\n\nexport async function deleteItem(code: string): Promise {\n const item = await getItemByCode(code);\n if (!item) return false;\n await sqlite.batch([\n { sql: \"DELETE FROM movements WHERE item_id = ?\", args: [item.id] },\n { sql: \"DELETE FROM items WHERE id = ?\", args: [item.id] },\n ]);\n return true;\n}\n\n// ---------- Checkout / Checkin ----------\n\nexport async function checkoutItem(code: string, actor: string, note?: string): Promise {\n const item = await getItemByCode(code);\n if (!item) return null;\n await sqlite.execute({\n sql: \"UPDATE items SET status = 'borrowed', borrowed_by = ? WHERE id = ?\",\n args: [actor, item.id],\n });\n await addMovement(item.id, \"checkout\", actor, note);\n return await getItemByCode(code);\n}\n\nexport async function checkinItem(code: string, actor?: string, note?: string): Promise {\n const item = await getItemByCode(code);\n if (!item) return null;\n await sqlite.execute({\n sql: \"UPDATE items SET status = 'stored', borrowed_by = NULL WHERE id = ?\",\n args: [item.id],\n });\n await addMovement(item.id, \"checkin\", actor, note);\n return await getItemByCode(code);\n}\n\n// ---------- Movements ----------\n\nexport async function addMovement(itemId: number, action: string, actor?: string | null, note?: string | null) {\n await sqlite.execute({\n sql: \"INSERT INTO movements (item_id, action, actor, note) VALUES (?, ?, ?, ?)\",\n args: [itemId, action, actor ?? null, note ?? null],\n });\n}\n\nexport async function itemHistory(itemId: number): Promise {\n const r = await sqlite.execute({\n sql: \"SELECT * FROM movements WHERE item_id = ? ORDER BY id DESC LIMIT 50\",\n args: [itemId],\n });\n return r.rows as unknown as Movement[];\n}\n",[],[149,299,291],"database","a812b8e1-14d6-416d-bb4b-9753c429a7aa","migrations.ts","a700582c-7e71-11f1-91b2-1607ee4eb77e",7,["D",1783916202328],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function runMigrations() {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS locations (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n code TEXT NOT NULL UNIQUE,\n name TEXT NOT NULL,\n note TEXT,\n photo_key TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS items (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n code TEXT NOT NULL UNIQUE,\n name TEXT NOT NULL,\n category TEXT,\n note TEXT,\n photo_key TEXT,\n home_location_id INTEGER REFERENCES locations(id),\n status TEXT NOT NULL DEFAULT 'stored',\n borrowed_by TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE TABLE IF NOT EXISTS movements (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n item_id INTEGER NOT NULL REFERENCES items(id),\n action TEXT NOT NULL,\n actor TEXT,\n note TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n `CREATE INDEX IF NOT EXISTS idx_items_name ON items(name)`,\n `CREATE INDEX IF NOT EXISTS idx_items_home ON items(home_location_id)`,\n `CREATE INDEX IF NOT EXISTS idx_movements_item ON movements(item_id)`,\n ]);\n}\n",[],[149,299,301],"d9cfb2c4-abed-4a62-a966-6b21e805c1f9",4,["D",1783916191928],[166,167],[149,299],["D",1783916188403],[165,168],[149],["D",1783916173471],["D",1789524079207],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":54,"_103":104,"_105":24},{"_13":87,"_31":88,"_42":41,"_89":43,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":44,"_96":97},"ctx",{"_80":-5,"_126":354,"_355":356,"_357":358,"_359":24,"_360":24,"_361":24,"_362":57,"_363":-5,"_364":-7,"_365":-7,"_366":61,"_367":24,"_368":24,"_369":-5,"_370":24,"_371":24,"_372":24,"_373":-5},"ENV",{"_325":326,"_327":328,"_329":88,"_330":331,"_332":333,"_334":335,"_336":337,"_338":339,"_340":341,"_342":343,"_344":345,"_346":347,"_348":349,"_350":351,"_352":353},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v19