7 <script src="https://cdn.twind.style" crossorigin></script>
8 <script src="https://esm.town/v/std/catch"></script>
9 <link rel="icon" href="data:image/svg+xml,<svg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 100 100'><text y='.9em' font-size='90'>₿</text></svg>">
10 <style>
11 body {
6 <title>Bobby's website</title>
7 <link rel="stylesheet" href="/frontend/style.css">
8 <link rel="icon" href="/frontend/favicon.svg" type="image/svg+xml">
9 </head>
10 <body>
4import { Header } from "./components.tsx";
5import hemolog from "./frames/hemolog.tsx";
6import generateImageFromHtml from "./generateImageFromHtml.ts";
7
8export default async function(req: Request) {
9 const url = new URL(req.url);
10 const isImageRequest = url.searchParams.get("generate") === "image";
11 const isListRequest = url.searchParams.get("generate") === "list";
12 const frameId = url.searchParams.get("frame");
69 }
70
71 // get ?&generate=image&frame=S0mth1ingKrAzy
72 if (frameId && !frame_list.includes(frameId)) {
73 const html = renderToString(
85 const generateUrl = frames[frameId as keyof typeof frames];
86
87 // get ?&generate=image&frame=weather
88 if (isImageRequest) {
89 const width = 800;
90 const height = 480;
91
92 const imageResponse = await generateImageFromHtml(generateUrl, width, height);
93 return new Response(imageResponse.body, {
94 status: imageResponse.status,
95 headers: {
96 "Content-Type": "image/png",
97 },
98 });
16 date: string;
17 doc: string;
18 image: string;
19 tags: string;
20 title: string;
42 this.field("book");
43 this.field("author_id");
44 this.field("image");
45 this.metadataWhitelist = ["position"];
46
54 book: searchData[i].book,
55 author_id: searchData[i].author_id,
56 image: searchData[i].image,
57 });
58 }
104 tags: item.tags,
105 date: item.date,
106 image: item.image,
107 backlinks: item.backlinks,
108 category: extractPostCategory(item),
152 (page.backlinks?.length > 0 ? `- Backlinks: ${page.backlinks.join(", ")}` : null),
153 (page.book ? `- Book: ${page.book}` : null),
154 (page.image ? `- Image: ${page.image}` : null),
155 (page.score ? `- Relevancy Score: ${page.score.toFixed(3)}` : null),
156 ].filter((a) => a !== null).join("\n");
337 backlinks: post.backlinks,
338 date: post.date,
339 image: post.image,
340 score: 1
341 }));
11 // Iterate through each one and delete it's blob
12 for (const row of res.rows) {
13 // blob.delete("pondiverse_image" + row.id);
14 }
15
52 // for (let creation of response.rows) {
53 // creation.url = `https://pondiverse.val.run/get-creation?id=${creation.id}`;
54 // creation.image = `https://pondiverse.val.run/get-creation-image?id=${creation.id}`;
55 // }
56
73 const downloadQRCode = async (table: Table) => {
74 try {
75 const response = await fetch(`/api/tables/${table.id}/qr/image`);
76 if (response.ok) {
77 const blob = await response.blob();
114});
115
116// Generate QR code image for table (returns actual image)
117tables.get("/:id/qr/image", async (c) => {
118 try {
119 const id = parseInt(c.req.param("id"));
131 const qrCodeUrl = `https://api.qrserver.com/v1/create-qr-code/?size=300x300&data=${encodeURIComponent(orderUrl)}`;
132
133 // Fetch the QR code image and return it
134 const response = await fetch(qrCodeUrl);
135 const imageBuffer = await response.arrayBuffer();
136
137 return new Response(imageBuffer, {
138 headers: {
139 'Content-Type': 'image/png',
140 'Content-Disposition': `attachment; filename="table-${table.number}-qr.png"`
141 }
142 });
143 } catch (error) {
144 console.error("Error generating QR code image:", error);
145 return c.json({ error: "Failed to generate QR code image" }, 500);
146 }
147});
17 category: row.category,
18 available: Boolean(row.available),
19 image_url: row.image_url || undefined
20 }));
21}
36 category: row.category,
37 available: Boolean(row.available),
38 image_url: row.image_url || undefined
39 };
40}
42export async function createMenuItem(item: CreateMenuItemRequest): Promise<MenuItem> {
43 const result = await sqlite.execute(`
44 INSERT INTO ${TABLES.MENU_ITEMS} (name, description, price, category, available, image_url)
45 VALUES (?, ?, ?, ?, ?, ?)
46 `, [item.name, item.description, item.price, item.category, item.available ?? true, item.image_url || null]);
47
48 const newItem = await getMenuItemById(result.lastInsertRowid);
60 if (updates.category !== undefined) { fields.push('category = ?'); values.push(updates.category); }
61 if (updates.available !== undefined) { fields.push('available = ?'); values.push(updates.available); }
62 if (updates.image_url !== undefined) { fields.push('image_url = ?'); values.push(updates.image_url); }
63
64 if (fields.length === 0) return getMenuItemById(id);
21 category TEXT NOT NULL,
22 available BOOLEAN DEFAULT 1,
23 image_url TEXT,
24 created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
25 updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
8 category: string;
9 available: boolean;
10 image_url?: string;
11}
12
67 category: string;
68 available?: boolean;
69 image_url?: string;
70}
71
