Smart Inventory — ระบบจัดเก็บอุปกรณ์

\n \n\n\n",[],[144,192],"4b31604f-c40a-4f3d-affd-1f04f7a0c8bd","components","a10b3cc0-7e71-11f1-b3f0-1607ee4eb77e",5,["D",1783916192316],[],[144,200],["D",1783916189244],[170,171,172],[144],"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",[],[150,218,210],"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",[],[150,218,220],"d9cfb2c4-abed-4a62-a966-6b21e805c1f9",4,["D",1783916191928],[167,168],[150,218],["D",1783916188403],[166],[150],["D",1783916173471],["D",1789524079207],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":54,"_104":105,"_106":24},{"_13":88,"_31":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"ctx",{"_81":-5,"_127":273,"_274":275,"_276":277,"_278":24,"_279":24,"_280":24,"_281":58,"_282":-5,"_283":-7,"_284":-7,"_285":62,"_286":24,"_287":24,"_288":-5,"_289":24,"_290":24,"_291":24,"_292":-5},"ENV",{"_244":245,"_246":247,"_248":89,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264,"_265":266,"_267":268,"_269":270,"_271":272},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v10