라조스튜디오 견적서

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_158":159,"_160":161},"routes/_app.x.$handle.$name",{"_97":96,"_32":45,"_106":87,"_27":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":25,"_121":122,"_123":124,"_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",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_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":25},"version",4,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","4053541a-7482-11f1-b815-1607ee4eb77e","name","fileType","http","content","import { PDFDocument, rgb } from \"npm:pdf-lib@1.17.1\";\nimport fontkit from \"npm:@pdf-lib/fontkit@1.1.1\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\n// ─── 타입 ───────────────────────────────────────────────\ninterface Item { name: string; price: number; qty?: number }\ninterface EstimateInput { client: string; date?: string; items: Item[] }\n\n// ─── 상수 ───────────────────────────────────────────────\nconst W = 595.28, H = 841.89, M = 45;\nconst CW = W - M * 2;\nconst BLACK = rgb(0, 0, 0);\nconst DGRAY = rgb(0.35, 0.35, 0.35);\nconst LGRAY = rgb(0.78, 0.78, 0.78);\n\nconst UPLOAD_SECRET = Deno.env.get(\"UPLOAD_SECRET\") ?? \"lazo2026\";\n\n// ─── 유틸 ───────────────────────────────────────────────\nconst fmt = (n: number) => n.toLocaleString(\"ko-KR\");\nconst today = () => { const d = new Date(); return `${d.getFullYear()}. ${d.getMonth()+1}. ${d.getDate()}.`; };\n\n// ─── PDF 생성 ─────────────────────────────────────────────\nasync function buildPDF(input: EstimateInput): Promise {\n const doc = await PDFDocument.create();\n doc.registerFontkit(fontkit);\n\n const [rB, rM, rL, rLogo] = await Promise.all([\n blob.get(\"lazo-font-bold\").then(r => r.arrayBuffer()),\n blob.get(\"lazo-font-medium\").then(r => r.arrayBuffer()),\n blob.get(\"lazo-font-light\").then(r => r.arrayBuffer()),\n blob.get(\"lazo-logo\").then(r => r.arrayBuffer()).catch(() => null),\n ]);\n\n const fBold = await doc.embedFont(new Uint8Array(rB));\n const fMed = await doc.embedFont(new Uint8Array(rM));\n const fLight = await doc.embedFont(new Uint8Array(rL));\n\n const page = doc.addPage([W, H]);\n\n const tx = (text: string, x: number, yTop: number, font = fMed, size = 10, color = BLACK) =>\n page.drawText(text, { x: M + x, y: H - yTop - size, font, size, color });\n\n const line = (x1: number, y1: number, x2: number, y2: number, t = 0.5, color = LGRAY) =>\n page.drawLine({ start: { x: M+x1, y: H-y1 }, end: { x: M+x2, y: H-y2 }, thickness: t, color });\n\n let y = M + 5;\n\n // 로고\n if (rLogo) {\n const img = await doc.embedPng(new Uint8Array(rLogo));\n const s = img.scale(0.13);\n page.drawImage(img, { x: W - M - s.width, y: H - y - s.height, ...s });\n }\n\n // 헤더\n tx(\"Estimate.\", 0, y, fBold, 30);\n y += 55;\n line(0, y, CW, y, 1, rgb(0.15, 0.15, 0.15));\n y += 18;\n\n // 3단: Provider / Date / Client\n const c1 = 0, c2 = CW * 0.38, c3 = CW * 0.62;\n tx(\"Provider info.\", c1, y, fLight, 8, DGRAY);\n tx(\"Date.\", c2, y, fLight, 8, DGRAY);\n tx(\"Client info.\", c3, y, fLight, 8, DGRAY);\n y += 14;\n\n const date = input.date ?? today();\n tx(\"LAZO STUDIO. 라조스튜디오.\", c1, y, fBold, 11);\n tx(date, c2, y, fMed, 11);\n tx(input.client, c3, y, fBold, 11);\n y += 18;\n\n tx(\"286.04.01708\", c1, y, fMed, 10); y += 14;\n tx(\"010.5544.1784\", c1, y, fMed, 10); y += 14;\n tx(\"김태윤\", c1, y, fMed, 10);\n\n // Total (오른쪽)\n const items = input.items.map(it => ({ ...it, qty: it.qty ?? 1 }));\n const subtotal = items.reduce((s, it) => s + it.price * it.qty, 0);\n const vat = Math.floor(subtotal * 0.1);\n const total = subtotal + vat;\n\n const tyBase = M + 78;\n page.drawText(\"Total (Vat포함)\", { x: M + c3, y: H - tyBase, font: fLight, size: 8, color: DGRAY });\n page.drawText(fmt(total) + \" 원\", { x: M + c3, y: H - tyBase - 20, font: fBold, size: 14, color: BLACK });\n\n y += 24;\n line(0, y, CW, y, 1, rgb(0.15, 0.15, 0.15));\n y += 22;\n\n // 테이블 헤더\n const tc = [0, CW*0.38, CW*0.63, CW*0.73, CW*0.83];\n [\"Contents.\", \"Each price\", \"Qty\", \"Unit\", \"Sum\"].forEach((h, i) => tx(h, tc[i], y, fBold, 10));\n y += 16;\n line(0, y, CW, y, 0.5);\n\n // 아이템\n for (let i = 0; i < 4; i++) {\n y += 9;\n const it = items[i];\n if (it) {\n tx(it.name, tc[0], y, fMed, 10);\n tx(fmt(it.price), tc[1], y, fMed, 10);\n tx(String(it.qty), tc[2], y, fMed, 10);\n tx(\"회\", tc[3], y, fMed, 10);\n tx(fmt(it.price*it.qty), tc[4], y, fMed, 10);\n }\n y += 20;\n line(0, y, CW, y, 0.3);\n }\n\n y += 15;\n line(0, y, CW, y, 0.8);\n y += 20;\n\n // 요약\n const sx = CW*0.68, sv = CW*0.83;\n [[\"Sub total\", fmt(subtotal)], [\"Discount\", \"0\"], [\"Carculate\", fmt(subtotal)],\n [\"V.a.t\", fmt(vat)], [\"Total\", fmt(total)]].forEach(([l, v]) => {\n tx(l, sx, y, fMed, 10); tx(v, sv, y, fMed, 10); y += 20;\n });\n\n y += 10;\n line(0, y, CW, y, 0.8);\n y += 22;\n\n // 비고\n [\"컨텐츠별 세부항목은 뒷면에 자세하게 나와있습니다.\",\n \"본 견적서는 가견적서이며 추후 협의를 통해 가격조정 가능성이 있습니다.\", \"\",\n \"세금계산서는 입금 전 청구발행합니다.\",\n \"지급시기와 방식에 대한 별도 협의가 필요한 경우 추가적인 수정을 진행할 수 있습니다.\",\n \"본 견적서는 추후 계약서의 후면에 부착, 그 내용을 증빙합니다.\",\n \"견적 외 사항이 추가 시 수정견적으로 재발급합니다.\",\n ].forEach(l => { if (l) { tx(l, 0, y, fLight, 8, DGRAY); y += 13; } else y += 6; });\n\n return doc.save();\n}\n\n// ─── 라우터 ──────────────────────────────────────────────\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const { method, pathname } = { method: req.method, pathname: url.pathname };\n\n // 헬스체크\n if (method === \"GET\" && pathname === \"/\") {\n return Response.json({ ok: true, service: \"lazo-estimate-api\" });\n }\n\n // 폰트·로고 업로드 (base64 JSON)\n if (method === \"POST\" && pathname === \"/admin/upload-b64\") {\n if (req.headers.get(\"X-Secret\") !== UPLOAD_SECRET)\n return Response.json({ error: \"Unauthorized\" }, { status: 401 });\n const { key, data } = await req.json();\n if (!key || !data) return Response.json({ error: \"key and data required\" }, { status: 400 });\n const binary = Uint8Array.from(atob(data), c => c.charCodeAt(0));\n await blob.set(key, binary);\n return Response.json({ ok: true, key, size: binary.byteLength });\n }\n\n // 폰트·로고 업로드 (binary)\n if (method === \"POST\" && pathname === \"/admin/upload\") {\n if (req.headers.get(\"X-Secret\") !== UPLOAD_SECRET)\n return Response.json({ error: \"Unauthorized\" }, { status: 401 });\n const key = req.headers.get(\"X-Key\");\n if (!key) return Response.json({ error: \"X-Key missing\" }, { status: 400 });\n const body = await req.arrayBuffer();\n await blob.set(key, body);\n return Response.json({ ok: true, key, size: body.byteLength });\n }\n\n // PDF 생성\n if (method === \"POST\" && pathname === \"/estimate\") {\n let input: EstimateInput;\n try { input = await req.json(); }\n catch { return Response.json({ error: \"Invalid JSON\" }, { status: 400 }); }\n if (!input.client || !input.items?.length)\n return Response.json({ error: \"client and items are required\" }, { status: 400 });\n\n const pdfBytes = await buildPDF(input);\n const filename = `2026 라조스튜디오 견적서_${input.client}.pdf`;\n\n // 임시 저장 → 링크 반환\n const key = `dl-${Date.now()}`;\n await blob.set(key, pdfBytes);\n\n return Response.json({ ok: true, filename, url: `${url.origin}/download/${key}` });\n }\n\n // 다운로드\n if (method === \"GET\" && pathname.startsWith(\"/download/\")) {\n const key = pathname.replace(\"/download/\", \"\");\n try {\n const bytes = await (await blob.get(key)).arrayBuffer();\n return new Response(bytes, { headers: {\n \"Content-Type\": \"application/pdf\",\n \"Content-Disposition\": `inline`,\n }});\n } catch { return Response.json({ error: \"Not found\" }, { status: 404 }); }\n }\n\n return Response.json({ error: \"Not found\" }, { status: 404 });\n}\n","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","createdAt",["D",1782829039843],"branchVersion","branchId","2bbb04ed-2aa2-4b9c-b4ba-f7bffe3e7ee8","id","e8c1da0c-6fad-4399-b237-50ede9fdcc0d","lazo-estimate-api",["D",1782823819796],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","라조스튜디오 견적서 PDF 생성 API","imageUrl","75db912a-ccf2-4669-bca4-ab7d2864d9f5","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019f1887-273b-7099-aca5-6098c26d89fd","tursoName","e8c1da0c6fad4399b23750ede9fdcc0d","tursoHostname","e8c1da0c6fad4399b23750ede9fdcc0d-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789694443644],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_105":101},"org",{"_97":96,"_98":99,"_100":101,"_18":55,"_102":103,"_104":25},"branch",{"_13":14,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","lazostudio","handle","displayName","LAZO STUDIO","avatar","https://lh3.googleusercontent.com/a/ACg8ocIkSz-7L_ZRurCsVrNnYcrpK6pzJ_kU6YOVBQbXU1-EFzgi5YNv=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":153,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":154,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":155,"_82":156,"_84":157,"_86":25},"tree",[148],"files",[148],"counts",{"_137":61,"_138":139,"_140":61,"_141":142,"_143":144},"contents",[129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":124,"_38":133,"_13":134,"_33":34,"_35":37,"_24":25,"_135":-5,"_27":136},"b0b83598-0eb8-46dc-a593-df793a325880","parentId","latest",["D",1782829039843],3,"label",[28],"pulls","branches",1,"forks","envVars",{"_145":61,"_147":61},"connections",{"_145":61,"_146":61},"count","unfilledCount","emptyCount",{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":124,"_38":149,"_13":134,"_33":34,"_35":37,"_24":25,"_135":-5,"_150":151,"_27":152},["D",1782829039843],"children",[],[28],["D",1782823819796],["D",1789694443644],{"_97":96,"_105":101},{"_97":96,"_98":99,"_100":101,"_18":55,"_102":103,"_104":25},{"_13":14,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"ctx",{"_80":-5,"_126":191,"_192":193,"_194":195,"_196":25,"_197":25,"_198":25,"_199":124,"_200":-5,"_201":-7,"_202":-7,"_203":61,"_204":25,"_205":25,"_206":-5,"_207":25,"_208":25,"_209":25,"_210":-5},"ENV",{"_162":163,"_164":165,"_166":87,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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 · v4