라조스튜디오 견적서

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_168":169,"_170":171},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_61":137,"_16":-7,"_138":-5,"_17":139,"_140":141,"_28":142,"_21":143,"_23":144,"_145":-5,"_146":-5,"_147":-5,"_148":36,"_149":150,"_151":34,"_152":-5,"_153":-5,"_154":155},"routes/_app.x.$handle.$name._index",{"_11":12,"_13":14,"_15":-7,"_16":-7,"_17":18,"_19":20,"_21":22,"_23":24,"_25":-7,"_26":-5,"_27":-5,"_28":29,"_30":-5,"_31":-5,"_32":-5,"_33":34,"_35":36,"_37":34},"handle","lazostudio","name","lazo-estimate-api","branchName","version","project",{"_39":78,"_13":14,"_50":79,"_80":-5,"_81":36,"_82":83,"_84":83,"_85":86,"_87":-5,"_88":89,"_90":-5,"_91":36,"_92":-5,"_93":-5,"_94":67,"_95":96,"_97":98,"_99":100,"_101":102,"_103":-5,"_104":105,"_106":105,"_107":108,"_109":108,"_110":108,"_111":105,"_112":105,"_113":114,"_115":116,"_117":118,"_119":36},"tags",[],"counts",{"_66":67,"_68":69,"_70":67,"_71":72,"_73":74},"contents",[63],"readme","upstream","pull","files",[38],"preview","ahead","behind","showHomeCustomizationHint",true,"showHTTPPreviewSettingsHint",false,"hasHTTPFiles",{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":34,"_50":51,"_16":52,"_53":54,"_55":56,"_57":36,"_58":-5,"_59":60,"_61":62},"id","b0b83598-0eb8-46dc-a593-df793a325880","main.ts","fileId","4053541a-7482-11f1-b815-1607ee4eb77e","parentId","branchId","2bbb04ed-2aa2-4b9c-b4ba-f7bffe3e7ee8","branchVersion",4,"latest","createdAt",["D",1782829039843],3,"fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { Hono } from \"npm:hono\";\n\nconst SECRET = Deno.env.get(\"LAZO_SECRET\") || \"lazo2026\";\n\n// DB 초기화\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS estimate_requests (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n client TEXT NOT NULL,\n date TEXT NOT NULL,\n items TEXT NOT NULL,\n status TEXT DEFAULT 'pending',\n created_at TEXT DEFAULT (datetime('now')),\n completed_at TEXT\n )\n`);\n\nconst app = new Hono();\n\n// 인증 체크\nfunction checkAuth(c: any): boolean {\n const token = c.req.query(\"token\") || c.req.header(\"x-token\");\n return token === SECRET;\n}\n\n// 모바일 폼 (GET /)\napp.get(\"/\", (c) => {\n return c.html(FORM_HTML);\n});\n\n// 견적 요청 제출 (POST /request) - 인증 불필요\napp.post(\"/request\", async (c) => {\n const body = await c.req.json();\n const { client, date, items } = body;\n if (!client || !items) {\n return c.json({ error: \"거래처명과 항목을 입력하세요.\" }, 400);\n }\n await sqlite.execute(\n \"INSERT INTO estimate_requests (client, date, items) VALUES (?, ?, ?)\",\n [client, date || new Date().toLocaleDateString(\"ko-KR\"), items]\n );\n return c.json({ success: true });\n});\n\n// 대기 중 요청 조회 (GET /pending) - 인증 필요\napp.get(\"/pending\", async (c) => {\n if (!checkAuth(c)) return c.json({ error: \"Unauthorized\" }, 401);\n const result = await sqlite.execute(\n \"SELECT id, client, date, items, created_at FROM estimate_requests WHERE status = 'pending' ORDER BY created_at ASC\"\n );\n return c.json(result.rows);\n});\n\n// 완료 처리 (PUT /complete/:id) - 인증 필요\napp.put(\"/complete/:id\", async (c) => {\n if (!checkAuth(c)) return c.json({ error: \"Unauthorized\" }, 401);\n const id = c.req.param(\"id\");\n await sqlite.execute(\n \"UPDATE estimate_requests SET status = 'done', completed_at = datetime('now') WHERE id = ?\",\n [id]\n );\n return c.json({ success: true });\n});\n\n// 전체 목록 (GET /all) - 인증 필요\napp.get(\"/all\", async (c) => {\n if (!checkAuth(c)) return c.json({ error: \"Unauthorized\" }, 401);\n const result = await sqlite.execute(\n \"SELECT * FROM estimate_requests ORDER BY created_at DESC LIMIT 100\"\n );\n return c.json(result.rows);\n});\n\nexport default app.fetch;\n\nconst FORM_HTML = `\n\n\n \n \n 라조스튜디오 견적서\n \n\n\n \n\n

거래처 정보

\n 거래처명\n \n

\n 날짜\n \n

\n\n

항목

\n \n

\n\n \n

\n\n

✅

요청 완료

견적서 요청이 접수되었습니다.
잠시 후 iCloud에서 확인하세요.

\n \n

\n\n \n\n`;\n","deleted","label","children",[],"path",[41],{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":34,"_50":64,"_16":52,"_53":54,"_55":56,"_57":36,"_58":-5,"_61":65},["D",1782829039843],[41],"pulls",0,"branches",1,"forks","envVars",{"_75":67,"_77":67},"connections",{"_75":67,"_76":67},"count","unfilledCount","emptyCount","e8c1da0c-6fad-4399-b237-50ede9fdcc0d",["D",1782823819796],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","라조스튜디오 견적서 PDF 생성 API","imageUrl","userId","75db912a-ccf2-4669-bca4-ab7d2864d9f5","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019f1887-273b-7099-aca5-6098c26d89fd","tursoName","e8c1da0c6fad4399b23750ede9fdcc0d","tursoHostname","e8c1da0c6fad4399b23750ede9fdcc0d-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789607492128],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_136":132},"org",{"_11":12,"_129":130,"_131":132,"_88":89,"_133":134,"_135":36},"branch",{"_16":48,"_13":120,"_39":46,"_121":78,"_122":-5,"_123":-5,"_124":-5,"_125":-5,"_126":-5,"_127":14,"_128":12},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","LAZO STUDIO","avatar","https://lh3.googleusercontent.com/a/ACg8ocIkSz-7L_ZRurCsVrNnYcrpK6pzJ_kU6YOVBQbXU1-EFzgi5YNv=s96-c","tier","free","canRestrictVals","profileImageUrl","","adoptOrgId",{"_39":78,"_13":14,"_50":163,"_80":-5,"_81":36,"_82":83,"_84":83,"_85":86,"_87":-5,"_88":89,"_90":-5,"_91":36,"_92":-5,"_93":-5,"_94":67,"_95":96,"_97":98,"_99":100,"_101":164,"_103":-5,"_104":105,"_106":105,"_107":108,"_109":108,"_110":108,"_111":105,"_112":105,"_113":165,"_115":166,"_117":167,"_119":36},"tree",[160],[160],{"_66":67,"_68":69,"_70":67,"_71":158,"_73":159},[156],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":34,"_50":64,"_16":52,"_53":54,"_55":56,"_57":36,"_58":-5,"_61":157},[41],{"_75":67,"_77":67},{"_75":67,"_76":67},{"_39":40,"_13":41,"_42":43,"_44":-5,"_45":46,"_47":48,"_49":34,"_50":51,"_16":52,"_53":54,"_55":56,"_57":36,"_58":-5,"_59":161,"_61":162},[],[41],["D",1782823819796],["D",1789607492128],{"_11":12,"_136":132},{"_11":12,"_129":130,"_131":132,"_88":89,"_133":134,"_135":36},{"_16":48,"_13":120,"_39":46,"_121":78,"_122":-5,"_123":-5,"_124":-5,"_125":-5,"_126":-5,"_127":14,"_128":12},"ctx",{"_113":-5,"_153":201,"_202":203,"_204":205,"_206":36,"_207":36,"_208":36,"_209":34,"_210":-5,"_211":-7,"_212":-7,"_213":67,"_214":36,"_215":36,"_216":-5,"_217":36,"_218":36,"_219":36,"_220":-5},"ENV",{"_172":173,"_174":175,"_176":120,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e8c4b7030cb7600e4eb0736b15f422c8b8bd130f","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"]