207 stockQuantity?: number;
208 specifications?: any[];
209 images?: string[];
210 datasheetUrl?: string;
211 featured?: boolean;
213 const result = await sqlite.execute(
214 `INSERT INTO products (name, description, short_description, price, category_id, sku,
215 stock_quantity, specifications, images, datasheet_url, featured)
216 VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING *`,
217 [
224 productData.stockQuantity || 0,
225 JSON.stringify(productData.specifications || []),
226 JSON.stringify(productData.images || []),
227 productData.datasheetUrl,
228 productData.featured ? 1 : 0
245 .map(key => {
246 const value = updates[key as keyof Product];
247 if (key === 'specifications' || key === 'images') {
248 return JSON.stringify(value);
249 }
284 stockQuantity: row.stock_quantity,
285 specifications: row.specifications ? JSON.parse(row.specifications) : [],
286 images: row.images ? JSON.parse(row.images) : [],
287 datasheetUrl: row.datasheet_url,
288 isActive: Boolean(row.is_active),
467 private static async getOrderItems(orderId: number): Promise<OrderItem[]> {
468 const result = await sqlite.execute(
469 `SELECT oi.*, p.name, p.sku, p.images
470 FROM order_items oi
471 LEFT JOIN products p ON oi.product_id = p.id
482 name: row.name,
483 sku: row.sku,
484 images: row.images ? JSON.parse(row.images) : []
485 } as any,
486 quantity: row.quantity,
556 useCases: row.use_cases ? JSON.parse(row.use_cases) : [],
557 features: row.features ? JSON.parse(row.features) : [],
558 imageUrl: row.image_url,
559 isActive: Boolean(row.is_active),
560 featured: Boolean(row.featured),
56 stock_quantity INTEGER DEFAULT 0,
57 specifications TEXT, -- JSON string
58 images TEXT, -- JSON array of image URLs
59 datasheet_url TEXT,
60 is_active BOOLEAN DEFAULT 1,
119 use_cases TEXT, -- JSON array
120 features TEXT, -- JSON array
121 image_url TEXT,
122 is_active BOOLEAN DEFAULT 1,
123 featured BOOLEAN DEFAULT 0,
181 content TEXT,
182 author_id INTEGER NOT NULL,
183 featured_image TEXT,
184 tags TEXT, -- JSON array
185 is_published BOOLEAN DEFAULT 0,
351 { name: 'IP Rating', value: 'IP67' }
352 ]),
353 images: JSON.stringify(['/images/products/esp-001-1.jpg', '/images/products/esp-001-2.jpg']),
354 featured: true
355 },
369 { name: 'Operating Temp', value: '-20°C to +60°C', unit: '°C' }
370 ]),
371 images: JSON.stringify(['/images/products/igh-002-1.jpg']),
372 featured: true
373 },
387 { name: 'Size', value: '85x54x17mm', unit: 'mm' }
388 ]),
389 images: JSON.stringify(['/images/products/gat-003-1.jpg']),
390 featured: false
391 }
394 for (const product of products) {
395 await sqlite.execute(
396 `INSERT INTO products (name, short_description, description, price, category_id, sku, stock_quantity, specifications, images, featured)
397 VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,
398 [product.name, product.shortDescription, product.description, product.price,
399 product.categoryId, product.sku, product.stockQuantity, product.specifications, product.images, product.featured]
400 );
401 }
24 stockQuantity: number;
25 specifications: ProductSpecification[];
26 images: string[];
27 datasheetUrl?: string;
28 isActive: boolean;
123 useCases: string[];
124 features: string[];
125 imageUrl?: string;
126 isActive: boolean;
127 featured: boolean;
182 authorId: number;
183 author?: User;
184 featuredImage?: string;
185 tags: string[];
186 isPublished: boolean;
17- **Database**: SQLite (Val Town hosted)
18- **Authentication**: JWT with role-based access
19- **Storage**: Val Town Blob storage for images/files
20- **Email**: Val Town email service
21- **Payments**: Stripe integration
31 feedSource: string;
32 lastFetched: string;
33 imageUrl?: string;
34}
35
135
136/**
137 * Extract image URL from RSS/Atom item using various common fields
138 * @param {Object} item - RSS or Atom item object
139 * @returns {string|undefined} Image URL if found
140 */
141function extractImageUrl(item) {
142 // Try enclosure
143 const enclosure = item.enclosure;
145 enclosure &&
146 typeof enclosure['@_type'] === 'string' &&
147 enclosure['@_type'].startsWith('image/')
148 ) {
149 return enclosure['@_url'];
155 mediaContent &&
156 typeof mediaContent['@_type'] === 'string' &&
157 mediaContent['@_type'].startsWith('image/')
158 ) {
159 return mediaContent['@_url'];
209 published: item.pubDate || item['dc:date'] || '',
210 description: item.description || item['content:encoded'] || '',
211 imageUrl: extractImageUrl(item),
212 });
213 }
228 item.content ||
229 '',
230 imageUrl: extractImageUrl(item),
231 });
232 }
256 feedSource: feed.url,
257 lastFetched: fetchedAt,
258 imageUrl: apiEntry.imageUrl || undefined,
259 };
260}
9 <meta charset="UTF-8">
10 <meta name="viewport" content="width=device-width, initial-scale=1.0">
11 <link rel="icon" href="data:image/gif;base64,R0lGODlhAQABAAAAADs=">
12 <title>Embed Viewer</title>
13 <link rel="stylesheet" href="/styles.css">
62function js() {
63 /*
64const ALLOW = 'accelerometer,ambient-light-sensor,autoplay,battery,camera,clipboard-write,display-capture,document-domain,encrypted-media,fullscreen,geolocation,gyroscope,layout-animations,legacy-image-formats,magnetometer,microphone,midi,navigation-override,oversized-images,payment,picture-in-picture,publickey-credentials-get,sync-script,sync-xhr,usb,screen-wake-lock,web-share,unoptimized-images,unsized-media,xr-spatial-tracking,layout-animations,oversized-images,sync-script,sync-xhr,unoptimized-images,unsized-media,';
65const SANDBOX = 'allow-downloads,allow-forms,allow-modals,allow-orientation-lock,allow-pointer-lock,allow-popups,allow-popups-to-escape-sandbox,allow-presentation,allow-same-origin,allow-scripts,allow-storage-access-by-user-activation Experimental,allow-top-navigation-to-custom-protocols';
66// sandbox-not-allowd: allow-top-navigation,allow-top-navigation-by-user-activation
46| `.js`, `.mjs` | `application/javascript` |
47| `.json` | `application/json` |
48| `.png` | `image/png` |
49| `.jpg`, `.jpeg` | `image/jpeg` |
50| `.svg` | `image/svg+xml` |
51| `.txt` | `text/plain` |
52| `.pdf` | `application/pdf` |
24 borderWindowOuter: `inset -1px -1px ${colors.windowFrame}, inset 1px 1px ${colors.buttonFace}`,
25 minimizeIcon:
26 "data:image/svg+xml;charset=utf-8,%3Csvg width='6' height='2' viewBox='0 0 6 2' fill='none' xmlns='http://www.w3.org/2000/svg'%3E %3Crect width='6' height='2' fill='black'/%3E %3C/svg%3E",
27 maximizeIcon:
28 "data:image/svg+xml;charset=utf-8,%3Csvg width='9' height='8' viewBox='0 0 9 8' fill='none' xmlns='http://www.w3.org/2000/svg'%3E %3Cpath fill-rule='evenodd' clip-rule='evenodd' d='M0 2V7V8H1H8H9V7V2V0H8H1H0V2ZM8 7V2H1V7H8Z' fill='black'/%3E %3C/svg%3E",
29 closeIcon:
30 "data:image/svg+xml;charset=utf-8,%3Csvg width='8' height='7' viewBox='0 0 8 7' fill='none' xmlns='http://www.w3.org/2000/svg'%3E %3Cpath fill-rule='evenodd' clip-rule='evenodd' d='M0 0H1H2V1H3V2H4H5V1H6V0H7H8V1H7V2H6V3H5V4H6V5H7V6H8V7H7H6V6H5V5H4H3V6H2V7H1H0V6H1V5H2V4H3V3H2V2H1V1H0V0Z' fill='black'/%3E %3C/svg%3E",
31 elementSpacing: 8,
32};
124 <TitleBarControl
125 style={{
126 backgroundImage: `url(${tokens.minimizeIcon})`,
127 backgroundRepeat: "no-repeat",
128 // // Only a single value is supported
141 <TitleBarControl
142 style={{
143 backgroundImage: `url(${tokens.maximizeIcon})`,
144 backgroundRepeat: "no-repeat",
145 // backgroundPosition: "top 2px left 3x",
157 marginLeft={2}
158 style={{
159 backgroundImage: `url(${tokens.closeIcon})`,
160 backgroundRepeat: "no-repeat",
161 // backgroundPosition: "top 3px left 4px",
287
288 return c.body(svg, 200, {
289 "Content-Type": "image/svg+xml",
290 });
291});
141 CARS: '/api/cars',
142 CAR_DETAIL: (id: number) => `/api/cars/${id}`,
143 CAR_IMAGES: (id: number) => `/api/cars/${id}/images`,
144 CAR_SEARCH: '/api/cars/search',
145 CAR_SUGGESTIONS: '/api/cars/suggestions',
215 MODAL_ANIMATION_DURATION: 200,
216 INFINITE_SCROLL_THRESHOLD: 100,
217 IMAGE_LAZY_LOAD_THRESHOLD: 50
218} as const;
39}
40
41export interface CarImage {
42 id: number;
43 carId: number;
44 imageUrl: string;
45 altText: string;
46 isPrimary: boolean;
48}
49
50export interface CarWithImages extends Car {
51 images: CarImage[];
52}
53
