No images uploaded yet

';\n }\n } else {\n throw new Error(result.message || 'Error loading images');\n }\n } catch (error) {\n console.error('Error loading images:', error);\n uploadStatusElement.textContent = `Error: ${error.message}`;\n uploadStatusElement.className = 'mt-2 text-sm text-red-500';\n throw error; // Re-throw to see the full error\n }\n }\n \n // Render images using Uploadcare's File Uploader UI\n function renderUploadcareGallery(images) {\n console.log('Rendering Uploadcare gallery with images:', images);\n \n // Get the container element\n const galleryContainer = document.getElementById('uploadcare-gallery');\n \n if (!galleryContainer) {\n console.error('ERROR: Gallery container element not found!');\n return;\n }\n \n // Clear the container\n galleryContainer.innerHTML = '';\n \n // Create a container for the File Uploader UI\n const fileUploaderContainer = document.createElement('div');\n fileUploaderContainer.className = 'uploadcare--file-uploader-ui';\n galleryContainer.appendChild(fileUploaderContainer);\n \n // Create the file list\n const fileList = document.createElement('div');\n fileList.className = 'uploadcare--file-list';\n fileUploaderContainer.appendChild(fileList);\n \n // Add each image to the file list\n images.forEach(image => {\n // Create the file item\n const fileItem = document.createElement('div');\n fileItem.className = 'uploadcare--file';\n fileItem.dataset.fileId = image.id;\n \n // Create the file info\n const fileInfo = document.createElement('div');\n fileInfo.className = 'uploadcare--file__info';\n \n // Create the file preview\n const filePreview = document.createElement('div');\n filePreview.className = 'uploadcare--file__preview';\n const previewImg = document.createElement('img');\n previewImg.src = `${image.cdnUrl}-/preview/76x76/-/setfill/ffffff/-/format/jpeg/-/progressive/yes/`;\n previewImg.alt = 'Preview';\n filePreview.appendChild(previewImg);\n \n // Create the file name\n const fileName = document.createElement('div');\n fileName.className = 'uploadcare--file__name';\n fileName.textContent = image.originalName || image.id;\n \n // Create the file size\n const fileSize = document.createElement('div');\n fileSize.className = 'uploadcare--file__size';\n fileSize.textContent = image.size ? formatFileSize(image.size) : 'Uploaded';\n \n // Create the file actions\n const fileActions = document.createElement('div');\n fileActions.className = 'uploadcare--file__actions';\n \n // Create the view button\n const viewButton = document.createElement('button');\n viewButton.className = 'uploadcare--button uploadcare--button_icon uploadcare--button_muted';\n viewButton.type = 'button';\n viewButton.title = 'View image';\n viewButton.innerHTML = '';\n viewButton.addEventListener('click', () => {\n window.open(image.cdnUrl, '_blank');\n });\n \n // Create the remove button\n const removeButton = document.createElement('button');\n removeButton.className = 'uploadcare--button uploadcare--button_icon uploadcare--button_muted uploadcare--file__remove';\n removeButton.type = 'button';\n removeButton.title = 'Delete image';\n removeButton.innerHTML = '';\n removeButton.addEventListener('click', () => {\n if (confirm('Are you sure you want to delete this image?')) {\n deleteImage(image.id);\n }\n });\n \n // Assemble the file item\n fileActions.appendChild(viewButton);\n fileActions.appendChild(removeButton);\n fileInfo.appendChild(filePreview);\n fileInfo.appendChild(fileName);\n fileInfo.appendChild(fileSize);\n fileItem.appendChild(fileInfo);\n fileItem.appendChild(fileActions);\n fileList.appendChild(fileItem);\n });\n \n // Add SVG icons for Uploadcare UI\n if (!document.getElementById('uploadcare--icons')) {\n const icons = document.createElement('div');\n icons.id = 'uploadcare--icons';\n icons.style.display = 'none';\n icons.innerHTML = `\n \n `;\n document.body.appendChild(icons);\n }\n }\n \n // Delete an image using Uploadcare's API\n async function deleteImage(imageId) {\n try {\n console.log(`Deleting image: ${imageId}`);\n \n // Show loading state in the gallery\n const galleryContainer = document.getElementById('uploadcare-gallery');\n if (galleryContainer) {\n galleryContainer.style.opacity = '0.7';\n }\n \n const response = await fetch('/image', {\n method: 'DELETE',\n headers: {\n 'Content-Type': 'application/json'\n },\n body: JSON.stringify({\n imageId,\n submissionId\n })\n });\n \n console.log(`Delete response status: ${response.status} ${response.statusText}`);\n \n let result;\n try {\n result = await response.json();\n console.log('Delete response:', result);\n } catch (parseError) {\n console.error('Error parsing delete response:', parseError);\n const errorText = await response.text();\n console.error('Raw response:', errorText);\n throw new Error(`Server returned invalid JSON: ${errorText}`);\n }\n \n if (response.ok && result.success) {\n // Refresh the gallery after deletion\n loadImages();\n } else {\n // Check for database schema errors\n const errorMessage = result.message || 'Failed to delete image';\n console.error('Delete error:', errorMessage);\n \n if (errorMessage.includes('no column named') || \n errorMessage.includes('table') || \n errorMessage.includes('schema')) {\n \n alert(`Database schema error. Please refresh the page and try again.`);\n \n } else {\n alert(errorMessage);\n }\n }\n } catch (error) {\n console.error('Error deleting image:', error);\n alert(`An error occurred while deleting the image: ${error.message}`);\n } finally {\n // Reset gallery opacity\n const galleryContainer = document.getElementById('uploadcare-gallery');\n if (galleryContainer) {\n galleryContainer.style.opacity = '1';\n }\n }\n }\n \n // Handle form submission\n form.addEventListener('submit', async (e) => {\n e.preventDefault();\n \n // Disable the submit button and show loading state\n submitButton.disabled = true;\n submitButton.innerText = 'Saving...';\n \n // Hide any previous messages\n successMessage.classList.add('hidden');\n errorMessage.classList.add('hidden');\n \n try {\n const formData = new FormData(form);\n const formDataObj = {};\n \n // Convert FormData to object\n for (const [key, value] of formData.entries()) {\n if (key !== 'submissionId' && value) {\n formDataObj[key] = value;\n }\n }\n \n // Add the ID to the form data\n formDataObj.id = submissionId;\n \n // Include the Uploadcare file ID if available\n const uploadcareWidget = uploadcare.Widget('#uploadcareFile');\n const file = uploadcareWidget.value();\n \n if (file) {\n try {\n // Get the UUID from the file\n file.done(fileInfo => {\n if (fileInfo && fileInfo.uuid) {\n formDataObj.uploadcareUuid = fileInfo.uuid;\n console.log(`Added file ID to form data: ${fileInfo.uuid}`);\n }\n });\n } catch (e) {\n console.error('Error getting file UUID:', e);\n }\n }\n \n const response = await fetch(`/update`, {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json'\n },\n body: JSON.stringify(formDataObj)\n });\n \n const result = await response.json();\n \n if (response.ok && result.success) {\n // Show success message\n successMessage.classList.remove('hidden');\n \n // Scroll to success message\n successMessage.scrollIntoView({ behavior: 'smooth', block: 'center' });\n \n // Hide success message after 3 seconds\n setTimeout(() => {\n successMessage.classList.add('hidden');\n }, 3000);\n } else {\n // Show error message\n errorMessage.textContent = result.message || 'An error occurred. Please try again.';\n errorMessage.classList.remove('hidden');\n }\n } catch (error) {\n console.error('Error submitting form:', error);\n errorMessage.textContent = 'An error occurred. Please try again.';\n errorMessage.classList.remove('hidden');\n } finally {\n // Re-enable the submit button\n submitButton.disabled = false;\n submitButton.innerText = 'Save Information';\n }\n });\n \n // Format file size in human-readable format\n function formatFileSize(bytes) {\n if (bytes === 0) return '0 Bytes';\n \n const k = 1024;\n const sizes = ['Bytes', 'KB', 'MB', 'GB'];\n const i = Math.floor(Math.log(bytes) / Math.log(k));\n \n return parseFloat((bytes / Math.pow(k, i)).toFixed(2)) + ' ' + sizes[i];\n }\n \n // Initialize\n initUploadcare();\n});",[],[258,281,287],{"_106":296,"_97":297,"_150":298,"_152":282,"_153":139,"_154":299,"_156":27,"_108":300,"_102":182,"_158":172,"_160":301,"_161":27,"_162":-5,"_163":302,"_100":303},"ecb7cad2-2ae2-11f0-8933-569c3dd06744","landing.js","76e98f00-2adf-11f0-ad9d-569c3dd06744",72,["D",1746581457082],"document.addEventListener('DOMContentLoaded', () => {\n // Main submission form\n const form = document.getElementById('submissionForm');\n const submitButton = document.getElementById('submitButton');\n const successMessage = document.getElementById('successMessage');\n const errorMessage = document.getElementById('errorMessage');\n \n // Magic link form\n const magicLinkForm = document.getElementById('magicLinkForm');\n const magicLinkButton = document.getElementById('magicLinkButton');\n const magicLinkSuccessMessage = document.getElementById('magicLinkSuccessMessage');\n const magicLinkErrorMessage = document.getElementById('magicLinkErrorMessage');\n \n // Handle main form submission\n form.addEventListener('submit', async (e) => {\n e.preventDefault();\n \n // Disable the submit button and show loading state\n submitButton.disabled = true;\n submitButton.innerText = 'Submitting...';\n \n // Hide any previous messages\n successMessage.classList.add('hidden');\n errorMessage.classList.add('hidden');\n \n try {\n const formData = new FormData(form);\n \n const response = await fetch('/submit', {\n method: 'POST',\n body: formData\n });\n \n const result = await response.json();\n \n if (response.ok && result.success) {\n // Show success message\n form.reset();\n successMessage.classList.remove('hidden');\n \n // Scroll to the success message\n successMessage.scrollIntoView({ behavior: 'smooth', block: 'center' });\n } else {\n // Show error message\n errorMessage.textContent = result.message || 'An error occurred. Please try again.';\n errorMessage.classList.remove('hidden');\n }\n } catch (error) {\n console.error('Error submitting form:', error);\n errorMessage.textContent = 'An error occurred. Please try again.';\n errorMessage.classList.remove('hidden');\n } finally {\n // Re-enable the submit button\n submitButton.disabled = false;\n submitButton.innerText = 'Submit';\n }\n });\n \n // Handle magic link form submission\n magicLinkForm.addEventListener('submit', async (e) => {\n e.preventDefault();\n \n // Disable the button and show loading state\n magicLinkButton.disabled = true;\n magicLinkButton.innerText = 'Sending...';\n \n // Hide any previous messages\n magicLinkSuccessMessage.classList.add('hidden');\n magicLinkErrorMessage.classList.add('hidden');\n \n try {\n const email = document.getElementById('existingEmail').value;\n \n const response = await fetch('/request-magic-link', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json'\n },\n body: JSON.stringify({ email })\n });\n \n const result = await response.json();\n \n // Always show success message even if email doesn't exist (for security)\n magicLinkForm.reset();\n magicLinkSuccessMessage.classList.remove('hidden');\n \n } catch (error) {\n console.error('Error requesting magic link:', error);\n magicLinkErrorMessage.textContent = 'An error occurred. Please try again.';\n magicLinkErrorMessage.classList.remove('hidden');\n } finally {\n // Re-enable the button\n magicLinkButton.disabled = false;\n magicLinkButton.innerText = 'Send Magic Link';\n }\n });\n});",[],[258,281,297],{"_106":305,"_97":306,"_150":307,"_152":282,"_153":139,"_154":308,"_156":120,"_108":309,"_102":33,"_158":172,"_160":310,"_161":27,"_162":-5,"_163":311,"_100":312},"0352f3f6-2b6b-11f0-8d5e-569c3dd06744","uploadcare-helper.js","0352f4aa-2b6b-11f0-8d5e-569c3dd06744",202,["D",1746639906566],"/**\n * Uploadcare Helper Functions\n * \n * This file contains helper functions for working with Uploadcare\n * in a way that avoids group creation issues.\n */\n\n/**\n * Initialize single file uploaders\n * @param {Array} uploaderIds - Array of uploader element IDs\n * @param {Function} onFileUploaded - Callback function when a file is uploaded\n */\nfunction initSingleFileUploaders(uploaderIds, onFileUploaded) {\n if (typeof uploadcare === 'undefined') {\n console.error('ERROR: Uploadcare library is not loaded!');\n return;\n }\n \n uploaderIds.forEach(id => {\n const widget = uploadcare.Widget(`#${id}`);\n \n widget.onChange(function(file) {\n if (!file) return;\n \n // Handle file upload\n file.progress(info => {\n console.log(`Upload progress for ${id}:`, Math.round(info.progress * 100) + '%');\n });\n \n file.done(fileInfo => {\n console.log(`Upload completed for ${id}:`, fileInfo);\n \n // Call the callback with the file info\n if (typeof onFileUploaded === 'function') {\n onFileUploaded(fileInfo);\n }\n });\n \n file.fail(error => {\n console.error(`Upload failed for ${id}:`, error);\n });\n });\n });\n}\n\n/**\n * Get all uploaded file UUIDs from multiple single uploaders\n * @param {Array} uploaderIds - Array of uploader element IDs\n * @returns {Promise} - Promise resolving to array of file UUIDs\n */\nfunction getUploadedFileUUIDs(uploaderIds) {\n return new Promise((resolve) => {\n const fileUUIDs = [];\n let processedCount = 0;\n \n // If no uploaders, resolve with empty array\n if (!uploaderIds || uploaderIds.length === 0) {\n resolve([]);\n return;\n }\n \n uploaderIds.forEach(id => {\n const widget = uploadcare.Widget(`#${id}`);\n const file = widget.value();\n \n if (file) {\n file.done(fileInfo => {\n if (fileInfo && fileInfo.uuid) {\n fileUUIDs.push(fileInfo.uuid);\n }\n \n processedCount++;\n if (processedCount === uploaderIds.length) {\n resolve(fileUUIDs);\n }\n }).fail(() => {\n processedCount++;\n if (processedCount === uploaderIds.length) {\n resolve(fileUUIDs);\n }\n });\n } else {\n processedCount++;\n if (processedCount === uploaderIds.length) {\n resolve(fileUUIDs);\n }\n }\n });\n });\n}\n\n/**\n * Clear all single file uploaders\n * @param {Array} uploaderIds - Array of uploader element IDs\n */\nfunction clearUploaders(uploaderIds) {\n uploaderIds.forEach(id => {\n const widget = uploadcare.Widget(`#${id}`);\n widget.value(null);\n });\n}\n\n/**\n * Create a preview gallery from individual file UUIDs\n * @param {Array} fileUUIDs - Array of Uploadcare file UUIDs\n * @param {string} containerId - ID of container element for the gallery\n * @param {Function} onDelete - Optional callback when delete button is clicked\n */\nfunction createFileGallery(fileUUIDs, containerId, onDelete) {\n const container = document.getElementById(containerId);\n if (!container) return;\n \n // Clear the container\n container.innerHTML = '';\n \n if (!fileUUIDs || fileUUIDs.length === 0) {\n container.innerHTML = '

No images uploaded yet

';\n return;\n }\n \n // Create gallery grid\n const gallery = document.createElement('div');\n gallery.className = 'grid grid-cols-2 md:grid-cols-4 gap-4';\n container.appendChild(gallery);\n \n // Add each image to the gallery\n fileUUIDs.forEach(uuid => {\n const cdnUrl = `https://ucarecdn.com/${uuid}/`;\n \n const item = document.createElement('div');\n item.className = 'relative bg-white rounded-lg shadow-sm overflow-hidden';\n item.dataset.uuid = uuid;\n \n // Image preview\n const img = document.createElement('img');\n img.src = `${cdnUrl}-/preview/300x300/-/format/auto/-/quality/smart/`;\n img.alt = 'Image preview';\n img.className = 'w-full h-32 object-cover';\n \n // Image actions\n const actions = document.createElement('div');\n actions.className = 'p-2 flex justify-between items-center';\n \n // View button\n const viewBtn = document.createElement('a');\n viewBtn.href = cdnUrl;\n viewBtn.target = '_blank';\n viewBtn.className = 'text-blue-500 hover:text-blue-700 text-sm';\n viewBtn.textContent = 'View';\n \n // Delete button\n const deleteBtn = document.createElement('button');\n deleteBtn.type = 'button';\n deleteBtn.className = 'text-red-500 hover:text-red-700 text-sm';\n deleteBtn.textContent = 'Delete';\n deleteBtn.onclick = () => {\n if (typeof onDelete === 'function') {\n onDelete(uuid, item);\n }\n };\n \n // Assemble the item\n actions.appendChild(viewBtn);\n actions.appendChild(deleteBtn);\n item.appendChild(img);\n item.appendChild(actions);\n gallery.appendChild(item);\n });\n}",[],[258,281,306],[258,281],{"_106":315,"_97":316,"_150":317,"_152":259,"_153":139,"_154":318,"_156":27,"_108":319,"_102":182,"_158":320,"_160":321,"_161":27,"_162":-5,"_163":322,"_100":323},"2323a22a-2b6b-11f0-885d-569c3dd06744","single-file-demo.html","207ec70c-2b6b-11f0-aeb9-569c3dd06744",205,["D",1746639959936],"http","\n\n\n \n \n Uploadcare Single File Demo\n \n \n \n \n \n \n \n \n \n \n\n\n

Uploadcare Single File Demo

Solution 1: Using individual file uploaders to avoid group issues

\n \n \n

Upload Images

\n \n

\n This demo uses multiple single file uploaders instead of one multi-file uploader.\n Each uploader will give you an individual file UUID, avoiding the group issue.\n

\n \n

\n Image 1\n \n

\n \n

\n Image 2\n \n

\n \n \n

Results

\n \n

Upload images to see results...

\n \n

Implementation Code

\n \n

// HTML\n<input \n  type=\"hidden\" \n  role=\"uploadcare-uploader\"\n  data-images-only=\"true\"\n  data-multiple=\"false\"\n  id=\"singleUploader1\"\n/>\n\n// JavaScript\nconst widget = uploadcare.Widget('#singleUploader1');\n\nwidget.onChange(function(file) {\n  if (file) {\n    file.done(function(fileInfo) {\n      console.log('File UUID:', fileInfo.uuid);\n      console.log('CDN URL:', fileInfo.cdnUrl);\n      \n      // This is always an individual file, never a group\n      saveImageToDatabase(fileInfo.uuid);\n    });\n  }\n});

\n \n \n\n",[],[258,316],{"_106":325,"_97":326,"_150":327,"_152":259,"_153":139,"_154":328,"_156":27,"_108":329,"_102":182,"_158":320,"_160":330,"_161":27,"_162":-5,"_163":331,"_100":332},"0a6f8bdc-2b6a-11f0-ad07-569c3dd06744","uploadcare-demo.html","0816b45a-2b6a-11f0-a816-569c3dd06744",192,["D",1746639488996],"\n\n\n \n \n Uploadcare Individual Files Demo\n \n \n \n\n\n

Uploadcare Individual Files Demo

\n \n

Upload Images

\n \n

Problem: Group Uploads

\n When using the default multi-file widget, Uploadcare creates a \"group\" with a UUID like \n cb08730c-9c8b-46bb-a79e-9ab0f228939e~1.\n This can cause issues when you need to work with individual files.\n

\n \n

\n Multi-file upload (creates groups):\n \n

\n \n

Solution 1: Individual File Uploads

\n Use separate widgets for each file upload to get individual file UUIDs.\n

\n \n

\n Image 1:\n \n

\n Image 2:\n \n

\n Image 3:\n \n

\n \n

Solution 2: Process Group Files Individually

\n If you need to use the multi-file uploader, you can extract individual files from the group.\n

\n \n

\n Multi-file upload (with individual file handling):\n \n

\n \n

Results

\n \n

Group Upload Result

Upload files to see results...

\n \n

Individual Files Result

Upload files to see results...

\n \n

Smart Group Handling Result

Upload files to see results...

\n \n

\n\n \n\n",[],[258,326],{"_106":334,"_97":335,"_150":336,"_152":259,"_153":139,"_154":103,"_156":27,"_108":337,"_102":182,"_158":320,"_160":338,"_161":27,"_162":-5,"_163":339,"_100":340},"bd844726-2b6f-11f0-b084-569c3dd06744","uploadcare-fix.ts","bb2a4192-2b6f-11f0-a30d-569c3dd06744",["D",1746641936924],"export default function handler(req: Request): Response {\n const html = `\n\n\n \n \n Uploadcare Group Fix\n \n \n \n\n\n

Uploadcare Group Fix

A solution for handling Uploadcare group uploads properly

\n \n

The Problem

\n \n

\n When using Uploadcare's multi-file uploader, files are grouped together with a UUID like:\n cb08730c-9c8b-46bb-a79e-9ab0f228939e~1\n

\n \n

\n To access individual files, you need to use the /nth/0/ syntax,\n which can be cumbersome and doesn't give you direct access to individual file UUIDs.\n

\n \n

Solution 1: Single File Uploads

\n \n

\n Use individual file uploaders to get separate file UUIDs:\n

\n \n

Upload a file to see the result...

\n \n

Solution 2: Extract from Group

\n \n

\n Use the multi-file uploader but extract individual file UUIDs:\n

\n \n

Upload files to see the result...

\n \n

Extracted Files

\n \n

Upload files using Solution 2 to see extracted files...

\n \n

Implementation Guide

\n \n

JavaScript Code

\n \n

// Extract individual files from a group\nuploadcareWidget.onChange(function(file) {\n  if (file) {\n    file.done(function(fileInfo) {\n      if (fileInfo.isGroup) {\n        // Load the group info to get individual files\n        fileInfo.files().done(function(files) {\n          files.forEach(file => {\n            console.log('Individual file UUID:', file.uuid);\n            console.log('Individual file URL:', file.cdnUrl);\n            \n            // Use these individual files instead of the group\n            saveImageToDatabase(file.uuid);\n          });\n        });\n      } else {\n        // Handle single file upload\n        console.log('Single file UUID:', fileInfo.uuid);\n        saveImageToDatabase(fileInfo.uuid);\n      }\n    });\n  }\n});

\n \n

Backend API Example

\n \n

// Register individual files instead of groups\napp.post(\"/register-image\", async (c) => {\n  const { uploadcareUuid, submissionId } = await c.req.json();\n  \n  // Check if this is a group UUID (contains ~)\n  if (uploadcareUuid.includes('~')) {\n    // Get group info and extract individual files\n    const groupInfo = await getGroupInfo(uploadcareUuid);\n    \n    // Register each file individually\n    const registeredFiles = [];\n    for (const file of groupInfo.files) {\n      const result = await registerSingleFile(file.uuid, submissionId);\n      registeredFiles.push(result);\n    }\n    \n    return c.json({ success: true, files: registeredFiles });\n  } else {\n    // Register single file\n    const result = await registerSingleFile(uploadcareUuid, submissionId);\n    return c.json({ success: true, file: result });\n  }\n});

\n\n \n\n`;\n\n return new Response(html, {\n headers: {\n \"Content-Type\": \"text/html\",\n },\n });\n}",[],[258,335],[258],{"_106":343,"_97":344,"_150":345,"_152":-5,"_153":139,"_154":155,"_156":120,"_108":346,"_102":33,"_158":159,"_160":-5,"_161":27,"_162":-5,"_163":347,"_100":394},"76e9e766-2adf-11f0-ad9d-569c3dd06744","services","ed368a55-a55d-4883-a46c-b3a7d7aa58c6",["D",1746579970933],[348,357,365,375,384],{"_106":349,"_97":350,"_150":351,"_152":345,"_153":139,"_154":352,"_156":27,"_108":353,"_102":182,"_158":172,"_160":354,"_161":27,"_162":-5,"_163":355,"_100":356},"16f9048c-2ae3-11f0-b62d-569c3dd06744","databaseService.ts","76e99356-2adf-11f0-ad9d-569c3dd06744",75,["D",1746581527976],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { Submission, UpdateSubmissionDto } from \"../models/submission.ts\";\n\n// Table name - change this when modifying schema\nconst SUBMISSIONS_TABLE = 'laura_mepson_submissions_v1';\n\n/**\n * Set up the database tables\n */\nexport async function setupDatabase(): Promise {\n try {\n // Create submissions table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${SUBMISSIONS_TABLE} (\n id TEXT PRIMARY KEY,\n company_name TEXT NOT NULL,\n email TEXT NOT NULL,\n created_at TEXT NOT NULL,\n additional_fields TEXT\n )`);\n \n console.log(\"Database setup complete\");\n } catch (error) {\n console.error(\"Error setting up database:\", error);\n throw error;\n }\n}\n\n/**\n * Save a new submission\n */\nexport async function saveSubmission(id: string, companyName: string, email: string): Promise> {\n try {\n const createdAt = new Date().toISOString();\n \n await sqlite.execute(\n `INSERT INTO ${SUBMISSIONS_TABLE} (id, company_name, email, created_at, additional_fields)\n VALUES (?, ?, ?, ?, ?)`,\n [id, companyName, email, createdAt, \"{}\"]\n );\n \n return { id, companyName, email, createdAt };\n } catch (error) {\n console.error(\"Error saving submission:\", error);\n throw error;\n }\n}\n\n/**\n * Get a submission by ID\n */\nexport async function getSubmission(id: string): Promise {\n try {\n const result = await sqlite.execute(\n `SELECT id, company_name, email, created_at, additional_fields \n FROM ${SUBMISSIONS_TABLE} \n WHERE id = ?`,\n [id]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n const row = result.rows[0];\n let additionalFields = {};\n \n try {\n additionalFields = JSON.parse(row.additional_fields || \"{}\");\n } catch (e) {\n console.error(\"Error parsing additional fields:\", e);\n }\n \n return {\n id: row.id,\n companyName: row.company_name,\n email: row.email,\n createdAt: row.created_at,\n additionalFields\n };\n } catch (error) {\n console.error(\"Error getting submission:\", error);\n throw error;\n }\n}\n\n/**\n * Find a submission by email\n */\nexport async function findSubmissionByEmail(email: string): Promise {\n try {\n const result = await sqlite.execute(\n `SELECT id, company_name, email, created_at, additional_fields \n FROM ${SUBMISSIONS_TABLE} \n WHERE email = ?\n ORDER BY created_at DESC\n LIMIT 1`,\n [email]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n const row = result.rows[0];\n let additionalFields = {};\n \n try {\n additionalFields = JSON.parse(row.additional_fields || \"{}\");\n } catch (e) {\n console.error(\"Error parsing additional fields:\", e);\n }\n \n return {\n id: row.id,\n companyName: row.company_name,\n email: row.email,\n createdAt: row.created_at,\n additionalFields\n };\n } catch (error) {\n console.error(\"Error finding submission by email:\", error);\n return null;\n }\n}\n\n/**\n * Update a submission with additional fields\n */\nexport async function updateSubmission(id: string, additionalFields: Record): Promise {\n try {\n // First get the existing submission\n const submission = await getSubmission(id);\n \n if (!submission) {\n throw new Error(\"Submission not found\");\n }\n \n // Merge existing additional fields with new ones\n const updatedFields = {\n ...submission.additionalFields,\n ...additionalFields\n };\n \n // Update the database\n await sqlite.execute(\n `UPDATE ${SUBMISSIONS_TABLE} \n SET additional_fields = ? \n WHERE id = ?`,\n [JSON.stringify(updatedFields), id]\n );\n \n return {\n ...submission,\n additionalFields: updatedFields\n };\n } catch (error) {\n console.error(\"Error updating submission:\", error);\n throw error;\n }\n}",[],[344,350],{"_106":358,"_97":359,"_150":360,"_152":345,"_153":139,"_154":155,"_156":27,"_108":361,"_102":33,"_158":172,"_160":362,"_161":27,"_162":-5,"_163":363,"_100":364},"76e996ee-2adf-11f0-ad9d-569c3dd06744","emailService.ts","76e99770-2adf-11f0-ad9d-569c3dd06744",["D",1746579970933],"import { email } from \"https://esm.town/v/std/email\";\n\nconst baseUrl = `https://devto.val.run`;\n\n/**\n * Send confirmation email with link to continue\n */\nexport async function sendConfirmationEmail(\n toEmail: string,\n companyName: string,\n uniqueId: string,\n): Promise {\n // For Val Town HTTP vals, we need to use query parameters instead of path parameters\n const continueUrl = `${baseUrl}?action=continue&id=${uniqueId}`;\n\n const subject = `LauraMepson: Continue Your Submission`;\n\n const text = `\nHello from LauraMepson!\n\nThank you for submitting your company information for ${companyName}.\n\nTo add more details to your submission, please click the link below:\n${continueUrl}\n\nThis link is unique to your submission and will allow you to add additional information.\n\nThank you,\nLauraMepson Team\n `;\n\n const html = `\n\n\n\n \n LauraMepson: Continue Your Submission\n\n\n

Hello from LauraMepson!

\n \n

Thank you for submitting your company information for ${companyName}.

\n \n

To add more details to your submission, please click the button below:

\n \n

\n Continue Your Submission\n

\n \n

This link is unique to your submission and will allow you to add additional information.

\n \n

If the button doesn't work, you can copy and paste this URL into your browser:

${continueUrl}

\n \n

Thank you,
LauraMepson Team

\n\n\n `;\n\n try {\n await email({\n to: toEmail,\n subject,\n text,\n html,\n });\n\n console.log(`Confirmation email sent to ${toEmail}`);\n return true;\n } catch (error) {\n console.error(\"Error sending confirmation email:\", error);\n throw error;\n }\n}",[],[344,359],{"_106":366,"_97":367,"_150":368,"_152":345,"_153":139,"_154":369,"_156":27,"_108":370,"_102":371,"_158":172,"_160":372,"_161":27,"_162":-5,"_163":373,"_100":374},"cfcaaaa4-2b67-11f0-9a88-569c3dd06744","imageService.ts","76e99a90-2adf-11f0-ad9d-569c3dd06744",183,["D",1746638531615],15,"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { ImageMetadata, UploadcareFile, UploadcareGroup } from \"../models/image.ts\";\nimport { getFileInfo, deleteFile, getGroupInfo, storeGroup } from \"./uploadcareService.ts\";\n\n// Table name for Uploadcare files\nconst UPLOADCARE_FILES_TABLE = 'uploadcare_files_v1';\n\n/**\n * Set up the Uploadcare files table\n */\nexport async function setupImagesTable(): Promise {\n try {\n console.log(`Setting up Uploadcare files table: ${UPLOADCARE_FILES_TABLE}`);\n \n // Create the new simplified table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${UPLOADCARE_FILES_TABLE} (\n file_id TEXT PRIMARY KEY,\n submission_id TEXT NOT NULL,\n created_at TEXT NOT NULL,\n is_group BOOLEAN DEFAULT 0\n )`);\n \n // Create index for faster lookups by submission\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_submission_id ON ${UPLOADCARE_FILES_TABLE} (submission_id)`);\n \n console.log(\"Uploadcare files table setup complete\");\n \n // Check if we need to migrate data from old tables\n await migrateFromOldTables();\n } catch (error) {\n console.error(\"Error setting up Uploadcare files table:\", error);\n throw error;\n }\n}\n\n/**\n * Migrate data from old tables to the new simplified table\n */\nasync function migrateFromOldTables(): Promise {\n try {\n // Check if old tables exist\n const oldTablesExist = await Promise.all([\n checkTableExists('laura_mepson_images_v1'),\n checkTableExists('laura_mepson_images_v2')\n ]);\n \n const oldTableV1Exists = oldTablesExist[0];\n const oldTableV2Exists = oldTablesExist[1];\n \n if (!oldTableV1Exists && !oldTableV2Exists) {\n console.log('No old tables found, no migration needed');\n return;\n }\n \n // Check if we've already migrated data\n const newTableCount = await sqlite.execute(\n `SELECT COUNT(*) as count FROM ${UPLOADCARE_FILES_TABLE}`\n );\n \n if (newTableCount.rows[0].count > 0) {\n console.log(`New table already has ${newTableCount.rows[0].count} records, skipping migration`);\n return;\n }\n \n // Migrate from v2 table if it exists\n if (oldTableV2Exists) {\n console.log('Migrating data from laura_mepson_images_v2');\n \n const oldData = await sqlite.execute(\n `SELECT id, submission_id, uploaded_at, group_id FROM laura_mepson_images_v2`\n );\n \n if (oldData.rows.length > 0) {\n console.log(`Found ${oldData.rows.length} records to migrate from v2 table`);\n \n for (const row of oldData.rows) {\n try {\n // Check if this file is already in the new table\n const exists = await sqlite.execute(\n `SELECT file_id FROM ${UPLOADCARE_FILES_TABLE} WHERE file_id = ?`,\n [row.id]\n );\n \n if (exists.rows.length === 0) {\n // Insert into new table\n await sqlite.execute(\n `INSERT INTO ${UPLOADCARE_FILES_TABLE} (file_id, submission_id, created_at, is_group) \n VALUES (?, ?, ?, ?)`,\n [\n row.id,\n row.submission_id,\n row.uploaded_at || new Date().toISOString(),\n row.group_id ? 1 : 0\n ]\n );\n }\n } catch (error) {\n console.error(`Error migrating record ${row.id}:`, error);\n // Continue with next record\n }\n }\n \n console.log('Migration from v2 table completed');\n } else {\n console.log('No data found in v2 table');\n }\n }\n \n // Migrate from v1 table if it exists and we haven't already migrated from v2\n if (oldTableV1Exists && !oldTableV2Exists) {\n console.log('Migrating data from laura_mepson_images_v1');\n \n const oldData = await sqlite.execute(\n `SELECT id, submission_id, uploaded_at FROM laura_mepson_images_v1`\n );\n \n if (oldData.rows.length > 0) {\n console.log(`Found ${oldData.rows.length} records to migrate from v1 table`);\n \n for (const row of oldData.rows) {\n try {\n // Check if this file is already in the new table\n const exists = await sqlite.execute(\n `SELECT file_id FROM ${UPLOADCARE_FILES_TABLE} WHERE file_id = ?`,\n [row.id]\n );\n \n if (exists.rows.length === 0) {\n // Insert into new table\n await sqlite.execute(\n `INSERT INTO ${UPLOADCARE_FILES_TABLE} (file_id, submission_id, created_at, is_group) \n VALUES (?, ?, ?, ?)`,\n [\n row.id,\n row.submission_id,\n row.uploaded_at || new Date().toISOString(),\n 0 // Not a group in v1 table\n ]\n );\n }\n } catch (error) {\n console.error(`Error migrating record ${row.id}:`, error);\n // Continue with next record\n }\n }\n \n console.log('Migration from v1 table completed');\n } else {\n console.log('No data found in v1 table');\n }\n }\n \n console.log('Migration from old tables completed');\n } catch (error) {\n console.error('Error during migration:', error);\n // Continue even if migration fails\n }\n}\n\n/**\n * Check if a table exists in the database\n */\nasync function checkTableExists(tableName: string): Promise {\n try {\n const result = await sqlite.execute(\n `SELECT name FROM sqlite_master WHERE type='table' AND name=?`,\n [tableName]\n );\n \n return result.rows.length > 0;\n } catch (error) {\n console.error(`Error checking if table ${tableName} exists:`, error);\n return false;\n }\n}\n\n/**\n * Link an Uploadcare file to a submission\n */\nexport async function linkUploadcareFile(\n fileId: string,\n submissionId: string,\n isGroup: boolean = false\n): Promise {\n try {\n console.log(`Linking Uploadcare file: ${fileId} to submission: ${submissionId}`);\n \n // Check if this file is already linked\n const existing = await sqlite.execute(\n `SELECT file_id FROM ${UPLOADCARE_FILES_TABLE} WHERE file_id = ?`,\n [fileId]\n );\n \n if (existing.rows.length > 0) {\n console.log(`File ${fileId} is already linked, updating submission_id`);\n \n // Update the existing record\n await sqlite.execute(\n `UPDATE ${UPLOADCARE_FILES_TABLE} SET \n submission_id = ?, \n is_group = ?\n WHERE file_id = ?`,\n [submissionId, isGroup ? 1 : 0, fileId]\n );\n } else {\n // Insert a new record\n await sqlite.execute(\n `INSERT INTO ${UPLOADCARE_FILES_TABLE} (file_id, submission_id, created_at, is_group) \n VALUES (?, ?, ?, ?)`,\n [fileId, submissionId, new Date().toISOString(), isGroup ? 1 : 0]\n );\n }\n \n return true;\n } catch (error) {\n console.error(`Error linking Uploadcare file ${fileId}:`, error);\n return false;\n }\n}\n\n/**\n * Unlink an Uploadcare file from a submission\n */\nexport async function unlinkUploadcareFile(\n fileId: string,\n submissionId: string\n): Promise {\n try {\n console.log(`Unlinking Uploadcare file: ${fileId} from submission: ${submissionId}`);\n \n // Verify the file belongs to this submission\n const existing = await sqlite.execute(\n `SELECT file_id FROM ${UPLOADCARE_FILES_TABLE} \n WHERE file_id = ? AND submission_id = ?`,\n [fileId, submissionId]\n );\n \n if (existing.rows.length === 0) {\n console.log(`File ${fileId} is not linked to submission ${submissionId}`);\n return false;\n }\n \n // Delete the record\n await sqlite.execute(\n `DELETE FROM ${UPLOADCARE_FILES_TABLE} WHERE file_id = ?`,\n [fileId]\n );\n \n return true;\n } catch (error) {\n console.error(`Error unlinking Uploadcare file ${fileId}:`, error);\n return false;\n }\n}\n\n/**\n * Get all Uploadcare files for a submission\n */\nexport async function getSubmissionFiles(submissionId: string): Promise {\n try {\n console.log(`Getting Uploadcare files for submission: ${submissionId}`);\n \n const result = await sqlite.execute(\n `SELECT file_id, is_group FROM ${UPLOADCARE_FILES_TABLE}\n WHERE submission_id = ?\n ORDER BY created_at DESC`,\n [submissionId]\n );\n \n // Process the results to handle groups\n const fileIds: string[] = [];\n \n for (const row of result.rows) {\n const fileId = row.file_id;\n const isGroup = row.is_group === 1;\n \n if (isGroup) {\n try {\n // For groups, we need to get the individual files\n console.log(`Expanding group: ${fileId}`);\n const groupInfo = await getGroupInfo(fileId);\n \n if (groupInfo && groupInfo.files) {\n // Add each file in the group\n for (let i = 0; i < groupInfo.files.length; i++) {\n const file = groupInfo.files[i];\n fileIds.push(file.uuid);\n }\n } else {\n // If we can't get group info, just add the group ID\n fileIds.push(fileId);\n }\n } catch (groupError) {\n console.error(`Error expanding group ${fileId}:`, groupError);\n // If there's an error, just add the group ID\n fileIds.push(fileId);\n }\n } else {\n // For individual files, just add the file ID\n fileIds.push(fileId);\n }\n }\n \n return fileIds;\n } catch (error) {\n console.error(`Error getting Uploadcare files for submission ${submissionId}:`, error);\n return [];\n }\n}\n\n/**\n * Get image metadata from database\n */\nexport async function getImageMetadata(imageId: string): Promise {\n try {\n console.log(`Getting image metadata for: ${imageId}`);\n \n // Try the new table first\n let result = await sqlite.execute(\n `SELECT id, original_name, content_type, size, uploaded_at, submission_id, cdn_url, group_id\n FROM ${IMAGES_TABLE}\n WHERE id = ?`,\n [imageId]\n );\n \n // If not found in the new table, try the old table if it exists\n if (result.rows.length === 0) {\n console.log(`Image not found in ${IMAGES_TABLE}, checking old table`);\n \n try {\n const oldTableExists = await checkTableExists('laura_mepson_images_v1');\n \n if (oldTableExists) {\n // Try to get from old table\n result = await sqlite.execute(\n `SELECT id, original_name, content_type, size, uploaded_at, submission_id, cdn_url, NULL as group_id\n FROM laura_mepson_images_v1\n WHERE id = ?`,\n [imageId]\n );\n \n // If found in old table, migrate this record to the new table\n if (result.rows.length > 0) {\n console.log(`Found image in old table, migrating to new table: ${imageId}`);\n \n const row = result.rows[0];\n \n // Insert into new table\n await sqlite.execute(\n `INSERT OR IGNORE INTO ${IMAGES_TABLE} (\n id, original_name, content_type, size, uploaded_at, submission_id, cdn_url, group_id\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n row.id,\n row.original_name,\n row.content_type,\n row.size,\n row.uploaded_at,\n row.submission_id,\n row.cdn_url,\n null // group_id is null for migrated records\n ]\n );\n }\n }\n } catch (oldTableError) {\n console.error(`Error checking old table: ${oldTableError.message}`);\n // Continue with the function even if old table check fails\n }\n }\n \n if (result.rows.length === 0) {\n console.log(`Image not found in any table: ${imageId}`);\n return null;\n }\n \n const row = result.rows[0];\n console.log(`Found image metadata: ${imageId}`, row);\n \n return {\n id: row.id,\n originalName: row.original_name,\n contentType: row.content_type,\n size: row.size,\n uploadedAt: row.uploaded_at,\n submissionId: row.submission_id,\n cdnUrl: row.cdn_url,\n groupId: row.group_id\n };\n } catch (error) {\n console.error(`Error getting image metadata for ${imageId}:`, error);\n return null;\n }\n}\n\n/**\n * List all images for a submission\n */\nexport async function listSubmissionImages(submissionId: string): Promise {\n try {\n console.log(`Listing images for submission: ${submissionId}`);\n \n // Get images from the new table\n const result = await sqlite.execute(\n `SELECT id, original_name, content_type, size, uploaded_at, submission_id, cdn_url, group_id\n FROM ${IMAGES_TABLE}\n WHERE submission_id = ?\n ORDER BY uploaded_at DESC`,\n [submissionId]\n );\n \n // Check if we need to look in the old table too\n let oldTableImages: any[] = [];\n try {\n const oldTableExists = await checkTableExists('laura_mepson_images_v1');\n \n if (oldTableExists) {\n console.log(`Checking old table for submission: ${submissionId}`);\n \n const oldResult = await sqlite.execute(\n `SELECT id, original_name, content_type, size, uploaded_at, submission_id, cdn_url\n FROM laura_mepson_images_v1\n WHERE submission_id = ?\n ORDER BY uploaded_at DESC`,\n [submissionId]\n );\n \n if (oldResult.rows.length > 0) {\n console.log(`Found ${oldResult.rows.length} images in old table for submission: ${submissionId}`);\n \n // Migrate these records to the new table\n for (const row of oldResult.rows) {\n try {\n // Check if this image is already in the new table\n const exists = await sqlite.execute(\n `SELECT id FROM ${IMAGES_TABLE} WHERE id = ?`,\n [row.id]\n );\n \n if (exists.rows.length === 0) {\n console.log(`Migrating image from old table to new table: ${row.id}`);\n \n // Insert into new table\n await sqlite.execute(\n `INSERT INTO ${IMAGES_TABLE} (\n id, original_name, content_type, size, uploaded_at, submission_id, cdn_url, group_id\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n row.id,\n row.original_name,\n row.content_type,\n row.size,\n row.uploaded_at,\n row.submission_id,\n row.cdn_url,\n null // group_id is null for migrated records\n ]\n );\n }\n } catch (migrationError) {\n console.error(`Error migrating image ${row.id}:`, migrationError);\n // Continue with the next image even if this one fails\n }\n }\n \n // Add these to our result set if they're not already there\n for (const row of oldResult.rows) {\n // Check if this ID is already in our result set\n const exists = result.rows.some(r => r.id === row.id);\n \n if (!exists) {\n oldTableImages.push({\n id: row.id,\n original_name: row.original_name,\n content_type: row.content_type,\n size: row.size,\n uploaded_at: row.uploaded_at,\n submission_id: row.submission_id,\n cdn_url: row.cdn_url,\n group_id: null\n });\n }\n }\n }\n }\n } catch (oldTableError) {\n console.error(`Error checking old table: ${oldTableError.message}`);\n // Continue with the function even if old table check fails\n }\n \n // Combine results from both tables\n const allRows = [...result.rows, ...oldTableImages];\n \n // Sort by uploaded_at in descending order\n allRows.sort((a, b) => {\n return new Date(b.uploaded_at).getTime() - new Date(a.uploaded_at).getTime();\n });\n \n console.log(`Found ${allRows.length} total images for submission: ${submissionId}`);\n \n return allRows.map(row => ({\n id: row.id,\n originalName: row.original_name,\n contentType: row.content_type,\n size: row.size,\n uploadedAt: row.uploaded_at,\n submissionId: row.submission_id,\n cdnUrl: row.cdn_url,\n groupId: row.group_id\n }));\n } catch (error) {\n console.error(`Error listing submission images for ${submissionId}:`, error);\n return [];\n }\n}\n\n/**\n * Delete image metadata from database and the file from Uploadcare\n */\nexport async function deleteImage(imageId: string): Promise {\n try {\n console.log(`Deleting image: ${imageId}`);\n \n // First get the image metadata to ensure it exists\n const imageMetadata = await getImageMetadata(imageId);\n \n if (!imageMetadata) {\n console.error(`Image not found in database: ${imageId}`);\n return false;\n }\n \n // Try to delete from Uploadcare\n let uploadcareDeleteSuccess = false;\n try {\n console.log(`Deleting image from Uploadcare: ${imageId}`);\n uploadcareDeleteSuccess = await deleteFile(imageId);\n \n if (!uploadcareDeleteSuccess) {\n console.warn(`Failed to delete image from Uploadcare: ${imageId}`);\n // Continue with database deletion even if Uploadcare deletion fails\n } else {\n console.log(`Successfully deleted image from Uploadcare: ${imageId}`);\n }\n } catch (uploadcareError) {\n console.error(`Error deleting image from Uploadcare: ${imageId}`, uploadcareError);\n // Continue with database deletion even if Uploadcare deletion fails\n }\n \n // Then delete from our database\n try {\n console.log(`Deleting image from database: ${imageId}`);\n await sqlite.execute(\n `DELETE FROM ${IMAGES_TABLE} WHERE id = ?`,\n [imageId]\n );\n console.log(`Successfully deleted image from database: ${imageId}`);\n return true;\n } catch (dbError) {\n console.error(`Database error deleting image ${imageId}:`, dbError);\n return false;\n }\n } catch (error) {\n console.error(`Error deleting image ${imageId}:`, error);\n return false;\n }\n}\n\n/**\n * Register an Uploadcare file in our system\n */\nexport async function registerUploadcareFile(\n uploadcareUuid: string,\n submissionId: string,\n groupId?: string\n): Promise {\n try {\n console.log(`Registering Uploadcare file: ${uploadcareUuid} for submission: ${submissionId}`);\n \n // Get file info from Uploadcare\n let fileInfo;\n try {\n console.log(`Fetching file info from Uploadcare for UUID: ${uploadcareUuid}`);\n fileInfo = await getFileInfo(uploadcareUuid);\n console.log('Successfully retrieved file info from Uploadcare:', fileInfo);\n } catch (fileInfoError) {\n console.error(`Error getting file info from Uploadcare for ${uploadcareUuid}:`, fileInfoError);\n \n // Try to extract more details from the error\n let errorDetails = '';\n if (fileInfoError instanceof Error) {\n errorDetails = fileInfoError.message;\n console.error(`Error message: ${errorDetails}`);\n console.error(`Error stack: ${fileInfoError.stack}`);\n }\n \n // Check if we should create a fallback or throw\n if (errorDetails.includes('404') || errorDetails.includes('not found')) {\n console.error(`File not found on Uploadcare, UUID may be invalid: ${uploadcareUuid}`);\n throw new Error(`File not found on Uploadcare: ${uploadcareUuid}`);\n }\n \n if (errorDetails.includes('401') || errorDetails.includes('unauthorized')) {\n console.error(`Authentication failed with Uploadcare. Check your API keys.`);\n throw new Error(`Authentication failed with Uploadcare. Check your API keys.`);\n }\n \n // Create a minimal file info object if we can't get it from Uploadcare\n console.log('Creating fallback file info object');\n fileInfo = {\n uuid: uploadcareUuid,\n originalFilename: 'unknown-filename.jpg',\n mimeType: 'image/jpeg',\n size: 0,\n isImage: true,\n uploadedAt: new Date().toISOString(),\n url: '',\n originalUrl: '',\n cdnUrl: `https://ucarecdn.com/${uploadcareUuid}/`\n };\n }\n \n // Save metadata to our database\n try {\n console.log('Saving image metadata to database');\n const metadata = await saveImageMetadata(fileInfo, submissionId, groupId);\n console.log('Successfully saved image metadata:', metadata);\n return metadata;\n } catch (dbError) {\n console.error(`Database error saving image metadata: ${dbError.message}`, dbError);\n if (dbError.message.includes('UNIQUE constraint failed')) {\n console.log('This appears to be a duplicate image entry');\n throw new Error('This image has already been registered');\n }\n throw dbError;\n }\n } catch (error) {\n console.error(`Error registering Uploadcare file ${uploadcareUuid}:`, error);\n throw error; // Re-throw to allow proper error handling upstream\n }\n}\n\n/**\n * Register an Uploadcare file group in our system\n */\nexport async function registerUploadcareGroup(\n groupId: string,\n submissionId: string\n): Promise {\n try {\n console.log(`Registering Uploadcare group: ${groupId} for submission: ${submissionId}`);\n \n // Get group info from Uploadcare\n const groupInfo = await getGroupInfo(groupId);\n \n // Store the group permanently\n await storeGroup(groupId);\n \n // Register each file in the group\n const registeredFiles: ImageMetadata[] = [];\n \n for (const file of groupInfo.files) {\n const metadata = await registerUploadcareFile(file.uuid, submissionId, groupId);\n if (metadata) {\n registeredFiles.push(metadata);\n }\n }\n \n return registeredFiles;\n } catch (error) {\n console.error(`Error registering Uploadcare group ${groupId}:`, error);\n return [];\n }\n}",[],[344,367],{"_106":376,"_97":377,"_150":378,"_152":345,"_153":139,"_154":379,"_156":27,"_108":380,"_102":33,"_158":172,"_160":381,"_161":27,"_162":-5,"_163":382,"_100":383},"697c9298-2b4f-11f0-a8e2-569c3dd06744","templateService.ts","697c937e-2b4f-11f0-a8e2-569c3dd06744",90,["D",1746628052058],"import { readFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n\n/**\n * Service for handling HTML templates\n */\n\n/**\n * Render a template with the given data\n * @param templatePath Path to the template file\n * @param data Object containing key-value pairs to replace in the template\n * @param importMetaUrl import.meta.url from the calling file\n */\nexport async function renderTemplate(\n templatePath: string, \n data: Record, \n importMetaUrl: string\n): Promise {\n try {\n // Read the template file\n let html = await readFile(templatePath, importMetaUrl);\n \n // Replace all placeholders with their values\n for (const [key, value] of Object.entries(data)) {\n const placeholder = `{{${key}}}`;\n // Use a global regex to replace all occurrences\n const regex = new RegExp(placeholder, 'g');\n html = html.replace(regex, value);\n }\n \n return html;\n } catch (error) {\n console.error(`Error rendering template ${templatePath}:`, error);\n throw error;\n }\n}",[],[344,377],{"_106":385,"_97":386,"_150":387,"_152":345,"_153":139,"_154":388,"_156":120,"_108":389,"_102":390,"_158":172,"_160":391,"_161":27,"_162":-5,"_163":392,"_100":393},"334ad646-2b5c-11f0-bc36-569c3dd06744","uploadcareService.ts","76e9a9a4-2adf-11f0-ad9d-569c3dd06744",147,["D",1746633544590],14,"/**\n * Uploadcare integration service\n * Simplified to leverage more Uploadcare built-in features\n */\n\n// Public key for Uploadcare\nexport const UPLOADCARE_PUBLIC_KEY = '1759805aecfaf0cc68cc';\n\n// Secret key is stored in environment variables\nconst UPLOADCARE_SECRET_KEY = Deno.env.get('UPLOADCARE_SECRET_KEY');\n\n// Uploadcare API endpoints\nconst UPLOADCARE_API_BASE = 'https://api.uploadcare.com';\nconst UPLOADCARE_CDN_BASE = 'https://ucarecdn.com';\n\n// Initialize keys and ensure they're available\nlet keysInitialized = false;\n\n/**\n * Ensure keys are initialized\n */\nexport function ensureKeysInitialized(): boolean {\n if (!keysInitialized) {\n console.log('Initializing Uploadcare keys');\n console.log(`Public key: ${UPLOADCARE_PUBLIC_KEY}`);\n \n if (!UPLOADCARE_SECRET_KEY) {\n console.warn('UPLOADCARE_SECRET_KEY environment variable is not set');\n } else {\n console.log('Secret key is set (value hidden)');\n }\n \n keysInitialized = true;\n }\n return keysInitialized;\n}\n\n/**\n * Get comprehensive Uploadcare widget configuration\n * This configuration is now primarily handled via data attributes in HTML\n * @param customOptions - Optional custom configuration options\n */\nexport function getUploadcareConfig(customOptions = {}) {\n ensureKeysInitialized();\n \n // Default configuration with best practices from Uploadcare docs\n const defaultConfig = {\n // Core settings\n publicKey: UPLOADCARE_PUBLIC_KEY,\n \n // UI settings\n tabs: 'file camera url facebook gdrive gphotos dropbox instagram',\n previewStep: true,\n clearable: true,\n \n // Image settings\n imageShrink: '2048x2048',\n \n // Upload settings\n multipleMax: 10,\n \n // Image editing features\n crop: 'free,1:1,3:2,4:3,16:9',\n imagesOnly: true,\n \n // Integration settings\n integration: 'LauraMepson-Portal',\n \n // Effects\n effects: ['crop', 'enhance', 'sharp', 'grayscale'],\n };\n \n // Merge default config with custom options\n return { ...defaultConfig, ...customOptions };\n}\n\n/**\n * Create authentication headers for Uploadcare REST API\n */\nexport function getUploadcareAuthHeaders(): HeadersInit {\n ensureKeysInitialized();\n \n // Current date in RFC2822 format\n const date = new Date().toUTCString();\n \n // Check if secret key is available\n if (!UPLOADCARE_SECRET_KEY) {\n console.error('UPLOADCARE_SECRET_KEY is missing! Authentication will fail.');\n }\n \n const headers = {\n 'Date': date,\n 'Authorization': `Uploadcare.Simple ${UPLOADCARE_PUBLIC_KEY}:${UPLOADCARE_SECRET_KEY || 'missing-secret-key'}`,\n 'Accept': 'application/vnd.uploadcare-v0.7+json',\n 'Content-Type': 'application/json'\n };\n \n return headers;\n}\n\n/**\n * Get file info from Uploadcare\n * Uses Uploadcare's REST API to get detailed file information\n */\nexport async function getFileInfo(fileId: string): Promise {\n try {\n ensureKeysInitialized();\n \n console.log(`Fetching file info from Uploadcare for file ID: ${fileId}`);\n console.log(`Using API URL: ${UPLOADCARE_API_BASE}/files/${fileId}/`);\n \n // Check if we have a secret key\n if (!UPLOADCARE_SECRET_KEY) {\n console.error('UPLOADCARE_SECRET_KEY is not set. Authentication will fail.');\n throw new Error('Uploadcare secret key is not configured');\n }\n \n const headers = getUploadcareAuthHeaders();\n console.log('Request headers:', {\n Date: headers['Date'],\n Accept: headers['Accept'],\n 'Content-Type': headers['Content-Type'],\n // Don't log the full Authorization header for security\n Authorization: headers['Authorization'] ? 'Set (value hidden)' : 'Not set'\n });\n \n // Make the API request\n let response;\n try {\n response = await fetch(`${UPLOADCARE_API_BASE}/files/${fileId}/`, {\n headers: headers\n });\n \n console.log(`Uploadcare API response status: ${response.status} ${response.statusText}`);\n } catch (fetchError) {\n console.error('Network error fetching from Uploadcare API:', fetchError);\n throw new Error(`Network error: ${fetchError.message}`);\n }\n \n // Handle non-OK responses\n if (!response.ok) {\n let errorText;\n try {\n errorText = await response.text();\n } catch (e) {\n errorText = 'Could not read error response';\n }\n \n console.error(`Uploadcare API error: ${response.status} ${response.statusText} - ${errorText}`);\n \n // Provide more specific error messages based on status code\n if (response.status === 401) {\n throw new Error('Authentication failed: Invalid Uploadcare API credentials');\n } else if (response.status === 404) {\n throw new Error(`File not found: ${fileId}`);\n } else if (response.status === 429) {\n throw new Error('Rate limit exceeded: Too many requests to Uploadcare API');\n } else {\n throw new Error(`Failed to get file info: ${response.status} ${response.statusText} - ${errorText}`);\n }\n }\n \n // Parse the response\n let data;\n try {\n data = await response.json();\n console.log('Uploadcare file info response:', data);\n } catch (parseError) {\n console.error('Error parsing Uploadcare API response:', parseError);\n throw new Error('Invalid response from Uploadcare API');\n }\n \n // Validate the response data\n if (!data || !data.uuid) {\n console.error('Invalid or missing data in Uploadcare response:', data);\n throw new Error('Invalid data received from Uploadcare API');\n }\n \n // Return the processed data\n return {\n uuid: data.uuid,\n originalFilename: data.original_filename || 'unknown',\n mimeType: data.mime_type || 'application/octet-stream',\n size: data.size || 0,\n isImage: data.is_image || false,\n imageInfo: data.image_info,\n uploadedAt: data.datetime_uploaded || new Date().toISOString(),\n url: data.url || '',\n originalUrl: data.original_file_url || '',\n cdnUrl: data.cdn_url || `${UPLOADCARE_CDN_BASE}/${fileId}/`,\n // Include the raw data for access to all Uploadcare properties\n raw: data\n };\n } catch (error) {\n console.error(`Error in getFileInfo for ${fileId}:`, error);\n throw error;\n }\n}\n\n/**\n * Delete file from Uploadcare\n */\nexport async function deleteFile(fileId: string): Promise {\n try {\n const response = await fetch(`${UPLOADCARE_API_BASE}/files/${fileId}/storage/`, {\n method: 'DELETE',\n headers: getUploadcareAuthHeaders()\n });\n \n if (!response.ok) {\n throw new Error(`Failed to delete file: ${response.status} ${response.statusText}`);\n }\n \n return true;\n } catch (error) {\n console.error('Error deleting file from Uploadcare:', error);\n return false;\n }\n}\n\n/**\n * Store file permanently on Uploadcare\n * By default, files are stored temporarily and may be deleted after 24 hours\n */\nexport async function storeFile(fileId: string): Promise {\n try {\n const response = await fetch(`${UPLOADCARE_API_BASE}/files/${fileId}/storage/`, {\n method: 'PUT',\n headers: getUploadcareAuthHeaders()\n });\n \n if (!response.ok) {\n throw new Error(`Failed to store file: ${response.status} ${response.statusText}`);\n }\n \n return true;\n } catch (error) {\n console.error('Error storing file on Uploadcare:', error);\n return false;\n }\n}\n\n/**\n * List files from Uploadcare\n * @param limit - Maximum number of files to return (default: 100)\n * @param stored - Filter by storage status (true = stored, false = not stored)\n */\nexport async function listFiles(limit = 100, stored?: boolean): Promise {\n try {\n let url = `${UPLOADCARE_API_BASE}/files/?limit=${limit}`;\n \n if (stored !== undefined) {\n url += `&stored=${stored ? 'true' : 'false'}`;\n }\n \n const response = await fetch(url, {\n headers: getUploadcareAuthHeaders()\n });\n \n if (!response.ok) {\n throw new Error(`Failed to list files: ${response.status} ${response.statusText}`);\n }\n \n const data = await response.json();\n return data.results || [];\n } catch (error) {\n console.error('Error listing files from Uploadcare:', error);\n return [];\n }\n}\n\n/**\n * Generate a CDN URL with transformations\n * Note: Uploadcare's JavaScript library provides built-in methods for this,\n * but this function is kept for server-side URL generation\n * @param fileId - Uploadcare file UUID\n * @param options - Transformation options\n */\nexport function generateCdnUrl(fileId: string, options: {\n resize?: string; // e.g., \"300x200\"\n crop?: string; // e.g., \"300x200/center\"\n quality?: number; // 1-100\n format?: string; // jpeg, png, webp, etc.\n effect?: string; // grayscale, flip, mirror, enhance, sharp\n progressive?: boolean;\n preview?: boolean;\n} = {}): string {\n const transformations: string[] = [];\n \n // Add transformations in the correct order\n if (options.resize) transformations.push(`-/resize/${options.resize}/`);\n if (options.crop) transformations.push(`-/crop/${options.crop}/`);\n if (options.quality) transformations.push(`-/quality/${options.quality}/`);\n if (options.effect) {\n const effects = options.effect.split(',');\n for (const effect of effects) {\n transformations.push(`-/${effect}/`);\n }\n }\n if (options.progressive) transformations.push('-/progressive/yes/');\n if (options.preview) transformations.push('-/preview/');\n if (options.format) transformations.push(`-/format/${options.format}/`);\n \n // Construct the final URL\n return `${UPLOADCARE_CDN_BASE}/${fileId}/${transformations.join('')}`;\n}\n\n/**\n * Get image dimensions and other metadata\n * This is a convenience function that extracts image dimensions from file info\n */\nexport async function getImageDimensions(fileId: string): Promise<{width: number, height: number} | null> {\n try {\n const fileInfo = await getFileInfo(fileId);\n \n if (fileInfo.isImage && fileInfo.imageInfo) {\n return {\n width: fileInfo.imageInfo.width,\n height: fileInfo.imageInfo.height\n };\n }\n \n return null;\n } catch (error) {\n console.error('Error getting image dimensions:', error);\n return null;\n }\n}\n\n/**\n * Get file group info from Uploadcare\n * @param groupId - Uploadcare group UUID\n */\nexport async function getGroupInfo(groupId: string): Promise {\n try {\n ensureKeysInitialized();\n \n const response = await fetch(`${UPLOADCARE_API_BASE}/groups/${groupId}/`, {\n headers: getUploadcareAuthHeaders()\n });\n \n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Failed to get group info: ${response.status} ${response.statusText} - ${errorText}`);\n }\n \n // Return the raw response to maintain all Uploadcare data\n return await response.json();\n } catch (error) {\n console.error('Error getting group info from Uploadcare:', error);\n throw error;\n }\n}\n\n/**\n * Store a file group permanently on Uploadcare\n */\nexport async function storeGroup(groupId: string): Promise {\n try {\n const response = await fetch(`${UPLOADCARE_API_BASE}/groups/${groupId}/storage/`, {\n method: 'PUT',\n headers: getUploadcareAuthHeaders()\n });\n \n if (!response.ok) {\n throw new Error(`Failed to store group: ${response.status} ${response.statusText}`);\n }\n \n return true;\n } catch (error) {\n console.error('Error storing group on Uploadcare:', error);\n return false;\n }\n}\n\n/**\n * Create a new file group from individual files\n * @param fileIds - Array of file UUIDs to include in the group\n */\nexport async function createGroup(fileIds: string[]): Promise {\n try {\n const response = await fetch(`${UPLOADCARE_API_BASE}/groups/`, {\n method: 'POST',\n headers: getUploadcareAuthHeaders(),\n body: JSON.stringify({\n files: fileIds.map(id => ({ uuid: id }))\n })\n });\n \n if (!response.ok) {\n throw new Error(`Failed to create group: ${response.status} ${response.statusText}`);\n }\n \n const data = await response.json();\n return data.id || null;\n } catch (error) {\n console.error('Error creating group on Uploadcare:', error);\n return null;\n }\n}",[],[344,386],[344],{"_106":396,"_97":397,"_150":398,"_152":-5,"_153":139,"_154":155,"_156":120,"_108":399,"_102":33,"_158":159,"_160":-5,"_161":27,"_162":-5,"_163":400,"_100":419},"76e9e93c-2adf-11f0-ad9d-569c3dd06744","utils","61f60706-523c-4a44-8813-8acd53f13546",["D",1746579970933],[401,410],{"_106":402,"_97":403,"_150":404,"_152":398,"_153":139,"_154":405,"_156":120,"_108":406,"_102":182,"_158":172,"_160":407,"_161":27,"_162":-5,"_163":408,"_100":409},"c7ee0e52-2b49-11f0-ac5c-569c3dd06744","helpers.ts","76e9be4e-2adf-11f0-ad9d-569c3dd06744",76,["D",1746625633522],"/**\n * Generate a cryptographically secure random string\n * @param length The length of the random string to generate\n */\nfunction generateSecureRandomString(length: number): string {\n const characters = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789';\n let result = '';\n \n // Create an array of random values\n const randomValues = new Uint8Array(length);\n \n // Fill with cryptographically secure random values if available\n if (typeof crypto !== 'undefined' && crypto.getRandomValues) {\n crypto.getRandomValues(randomValues);\n } else {\n // Fallback to Math.random() if crypto is not available\n for (let i = 0; i < length; i++) {\n randomValues[i] = Math.floor(Math.random() * 256);\n }\n }\n \n // Convert random values to characters\n for (let i = 0; i < length; i++) {\n result += characters.charAt(randomValues[i] % characters.length);\n }\n \n return result;\n}\n\n/**\n * Generate a unique ID for submissions\n * Creates a longer, more secure token to prevent brute force attacks\n */\nexport function generateUniqueId(): string {\n // Generate a secure random string (32 characters)\n const randomPart1 = generateSecureRandomString(16);\n const randomPart2 = generateSecureRandomString(16);\n \n // Add a timestamp component for uniqueness (in base36)\n const timestampPart = Date.now().toString(36);\n \n // Add a counter component to ensure uniqueness even if called in the same millisecond\n const counterPart = Math.floor(Math.random() * 10000).toString(36).padStart(4, '0');\n \n // Combine all parts with separators\n return `${timestampPart}-${randomPart1}-${counterPart}-${randomPart2}`;\n}\n\n/**\n * Format file size for display\n */\nexport function formatFileSize(bytes: number): string {\n if (bytes < 1024) return bytes + ' bytes';\n else if (bytes < 1048576) return (bytes / 1024).toFixed(1) + ' KB';\n else return (bytes / 1048576).toFixed(1) + ' MB';\n}",[],[397,403],{"_106":411,"_97":412,"_150":413,"_152":398,"_153":139,"_154":414,"_156":27,"_108":415,"_102":33,"_158":172,"_160":416,"_161":27,"_162":-5,"_163":417,"_100":418},"7d9e49d8-2b4f-11f0-93cc-569c3dd06744","responseUtils.ts","7d9e4a8c-2b4f-11f0-93cc-569c3dd06744",93,["D",1746628085834],"import { Context } from \"https://esm.sh/hono@3.12.6\";\n\n/**\n * Standard API response format\n */\nexport interface ApiResponse {\n success: boolean;\n message: string;\n data?: T;\n}\n\n/**\n * Create a success response\n */\nexport function successResponse(\n c: Context, \n message: string, \n data?: T, \n status = 200\n): Response {\n const response: ApiResponse = {\n success: true,\n message\n };\n \n if (data !== undefined) {\n response.data = data;\n }\n \n return c.json(response, status);\n}\n\n/**\n * Create an error response\n */\nexport function errorResponse(\n c: Context, \n message: string, \n status = 400,\n error?: Error\n): Response {\n // Log the error if provided\n if (error) {\n console.error(`Error (${status}): ${message}`, error);\n }\n \n return c.json({\n success: false,\n message\n }, status);\n}\n\n/**\n * Create a not found response\n */\nexport function notFoundResponse(\n c: Context, \n message = \"Resource not found\"\n): Response {\n return errorResponse(c, message, 404);\n}\n\n/**\n * Create a server error response\n */\nexport function serverErrorResponse(\n c: Context, \n error: Error,\n message = \"An internal server error occurred\"\n): Response {\n return errorResponse(c, message, 500, error);\n}",[],[397,412],[397],{"_106":421,"_97":422,"_150":423,"_152":-5,"_153":139,"_154":155,"_156":120,"_108":424,"_102":33,"_158":159,"_160":-5,"_161":27,"_162":-5,"_163":425,"_100":445},"76e9eae0-2adf-11f0-ad9d-569c3dd06744","views","3e3c76da-6b4b-412e-8890-2e14946c4ade",["D",1746579970933],[426,436],{"_106":427,"_97":428,"_150":429,"_152":423,"_153":139,"_154":430,"_156":27,"_108":431,"_102":432,"_158":274,"_160":433,"_161":27,"_162":-5,"_163":434,"_100":435},"ab10c0cc-2b6c-11f0-9b1f-569c3dd06744","continue.html","cbd14f54-2b4c-11f0-ab93-569c3dd06744",210,["D",1746640617486],21,"\n\n\n \n \n Ad Portal - LauraMepson\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\n\n

LauraMepson

Ad Portal

\n \n \n

\n 👤\n

Account Information

\n \n

\n Company: {{COMPANY_NAME}}
\n Email: {{EMAIL}}
\n Your Unique Link: https://{{HOST}}/?action=continue&id={{ID}}\n

\n Save this link to access your ad portal later.\n

\n \n

\n \n \n \n

\n 🏢\n

Image Gallery

\n \n

Upload images to use in your ads. These images will be available to select when creating new ads.

\n \n \n

\n \n

\n \n \n

\n \n

\n \n \n

Your Images

\n \n \n

\n 0 images\n

\n \n \n

\n 📢\n

Ad Creation

\n \n

Create and manage your ads. Select images from your gallery to use in your ads.

\n \n \n

Ad creation tools coming soon!

You'll be able to create ads and select images from your gallery.

\n \n \n

\n \n

\n Your information has been saved successfully!\n

\n \n

\n \n \n\n \n \n\n",[],[422,428],{"_106":437,"_97":438,"_150":439,"_152":423,"_153":139,"_154":440,"_156":27,"_108":441,"_102":182,"_158":274,"_160":442,"_161":27,"_162":-5,"_163":443,"_100":444},"e223eb6e-2ae2-11f0-b1df-569c3dd06744","landing.html","76e9d794-2adf-11f0-ad9d-569c3dd06744",71,["D",1746581439334],"\n\n\n \n \n LauraMepson\n \n \n \n\n\n

LauraMepson

\n \n \n \n \n \n

Already have an account?

\n \n \n

\n If your email exists in our system, you'll receive a magic link shortly.\n

\n \n

\n \n \n

\n \n

Submission Successful!

Thank you for your submission! We've sent a confirmation email with your unique access link.

Please check your inbox and save the link for future access to your submission.

\n \n \n

\n \n \n\n \n\n",[],[422,438],[422],{"_106":447,"_97":448,"_150":449,"_152":-5,"_153":139,"_154":450,"_156":27,"_108":451,"_102":452,"_158":274,"_160":453,"_161":27,"_162":-5,"_163":454,"_100":455},"aecf5124-2b6c-11f0-ae2e-569c3dd06744","README.md","c72e72ce-2aa2-11f0-ab66-569c3dd06744",211,["D",1746640623765],9,"# LauraMepson Landing Page\n\nA landing page application that collects company information and allows users to add additional details through email links.\n\n## Features\n\n- Simple landing page with LauraMepson branding\n- Form to collect company name and email\n- SQLite database storage for submissions\n- Email functionality to send users a unique link\n- Continuation page for adding more information\n- Image upload and storage using Uploadcare\n\n## Uploadcare Group Fix\n\nThis project includes solutions for handling Uploadcare image uploads, specifically addressing the issue where multi-file uploads create groups instead of individual files.\n\n### The Problem\n\nWhen using Uploadcare's multi-file uploader, files are grouped together with a UUID like:\n`cb08730c-9c8b-46bb-a79e-9ab0f228939e~1`\n\nTo access individual files, you need to use the `/nth/0/` syntax, which can be cumbersome and doesn't give you direct access to individual file UUIDs.\n\n### Solutions\n\nTwo solutions are provided:\n\n1. **Use Single File Uploaders**: Configure Uploadcare widgets to upload one file at a time\n2. **Extract Individual Files from Groups**: Use the multi-file uploader but extract individual file UUIDs\n\n### Demo Pages\n\n- `/public/uploadcare-demo.html` - A comprehensive demo showing both problems and solutions\n- `/public/uploadcare-fix.html` - A focused solution with implementation guide\n- `/public/single-file-demo.html` - A demo of the single file uploader solution\n\n### Implementation\n\nThe single file uploader solution has been implemented in the main application:\n\n1. Changed `UPLOADCARE_MULTIPLE` to `false` in the global configuration\n2. Implemented a clean UI with a single uploader and \"Add Another Image\" button\n3. Updated the JavaScript to handle individual file uploads\n4. Added a helper script (`/public/js/uploadcare-helper.js`) with utility functions\n\n## Project Structure\n\n```\n├── api/ # API route handlers\n│ ├── images.ts # Image-related API endpoints\n│ ├── submissions.ts # Submission-related API endpoints\n│ └── index.ts # API routes configuration\n├── controllers/ # Request handling logic\n│ ├── imageController.ts # Image upload/retrieval logic\n│ └── submissionController.ts # Submission handling logic\n├── models/ # Data models and types\n│ ├── image.ts # Image-related types\n│ └── submission.ts # Submission-related types\n├── services/ # Business logic\n│ ├── imageService.ts # Image metadata operations\n│ ├── uploadcareService.ts # Uploadcare integration\n│ ├── databaseService.ts # Database operations\n│ ├── emailService.ts # Email sending functionality\n│ └── templateService.ts # HTML template rendering\n├── utils/ # Utility functions\n│ ├── helpers.ts # Helper functions\n│ └── responseUtils.ts # Standardized API responses\n├── views/ # HTML templates\n│ ├── landing.html # Main landing page\n│ └── continue.html # Continuation page\n├── public/ # Static assets and client-side JS\n│ ├── css/ # Stylesheets\n│ │ └── styles.css # Common styles\n│ └── js/ # Client-side JavaScript\n│ ├── landing.js # Landing page script\n│ └── continue.js # Continuation page script\n└── index.ts # Main entry point\n```\n\n## Database Schema\n\nThe application uses a SQLite database with the following schemas:\n\n### Submissions Table\n\n```sql\nCREATE TABLE IF NOT EXISTS laura_mepson_submissions_v1 (\n id TEXT PRIMARY KEY,\n company_name TEXT NOT NULL,\n email TEXT NOT NULL,\n created_at TEXT NOT NULL,\n additional_fields TEXT\n)\n```\n\n### Images Table\n\n```sql\nCREATE TABLE IF NOT EXISTS laura_mepson_images_v1 (\n id TEXT PRIMARY KEY,\n original_name TEXT NOT NULL,\n content_type TEXT NOT NULL,\n size INTEGER NOT NULL,\n uploaded_at TEXT NOT NULL,\n submission_id TEXT NOT NULL,\n cdn_url TEXT NOT NULL\n)\n```\n\n## User Flow\n\n1. User visits the landing page\n2. User submits company name and email\n3. Data is saved to SQLite database\n4. User receives an email with a unique link\n5. User can click the link to add more information\n6. Additional information is saved to the database\n7. User can upload and manage images related to their submission\n\n## URL Structure\n\n- Main landing page: `https://[username].web.val.run`\n- Continuation page: `https://[username].web.val.run?action=continue&id=[unique_id]`\n\n## Image Storage\n\nImages are stored using Uploadcare:\n- Uploadcare handles file uploads, storage, and CDN delivery\n- Uploadcare's built-in image preview and cropping tools are used\n- Image metadata is stored in our SQLite database\n- Users can upload, view, and delete images\n- Images are associated with a specific submission\n\n## Environment Variables\n\n- `UPLOADCARE_SECRET_KEY`: Secret key for Uploadcare API authentication\n\n## Development Notes\n\n- When modifying the database schema, create a new table with a new version number\n- Email templates are defined in `emailService.ts`\n- The unique ID generation is handled in `utils/helpers.ts`\n- Val Town HTTP vals use query parameters instead of path parameters for routing\n\n## Database Schema\n\nThe application uses a SQLite database with the following schema:\n\n```sql\nCREATE TABLE IF NOT EXISTS laura_mepson_submissions_v1 (\n id TEXT PRIMARY KEY,\n company_name TEXT NOT NULL,\n email TEXT NOT NULL,\n created_at TEXT NOT NULL,\n additional_fields TEXT\n)\n```\n\n## User Flow\n\n1. User visits the landing page\n2. User submits company name and email\n3. Data is saved to SQLite database\n4. User receives an email with a unique link\n5. User can click the link to add more information\n6. Additional information is saved to the database\n7. User can upload and manage images related to their submission\n\n## URL Structure\n\n- Main landing page: `https://[username].web.val.run`\n- Continuation page: `https://[username].web.val.run?action=continue&id=[unique_id]`\n\n## Image Storage\n\nImages are stored using Val Town's blob storage:\n- Images are stored with a unique ID\n- Metadata is stored alongside each image\n- Users can upload, view, and delete images\n- Images are associated with a specific submission\n\n## Development Notes\n\n- When modifying the database schema, create a new table with a new version number\n- Email templates are defined in `email.ts`\n- The unique ID generation is handled in `utils.ts`\n- Val Town HTTP vals use query parameters instead of path parameters for routing",[],[448],{"_106":457,"_97":178,"_150":118,"_152":-5,"_153":139,"_154":155,"_156":27,"_108":458,"_102":390,"_158":320,"_160":459,"_161":27,"_162":96,"_163":460,"_100":461},"76ea2244-2adf-11f0-ad9d-569c3dd06744",["D",1746579970933],"import { Hono } from \"https://esm.sh/hono@3.12.6\";\nimport { serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport apiRouter from \"./api/index.ts\";\nimport { setupDatabase } from \"./services/databaseService.ts\";\nimport { setupImagesTable } from \"./services/imageService.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n console.error(err);\n throw err;\n});\n\n// Initialize database and image storage\napp.use(\"*\", async (c, next) => {\n try {\n await setupDatabase();\n await setupImagesTable();\n } catch (error) {\n console.error(\"Error initializing storage:\", error);\n }\n return next();\n});\n\n// Serve static files\napp.get(\"/public/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Mount the API router\napp.route(\"/\", apiRouter);\n\n// This is the entry point for HTTP vals\nexport default app.fetch;",[],[178],"files",[147,165,176,186,195,205,211,221,232,238,247,256,262,268,279,285,295,304,314,324,333,342,348,357,365,375,384,395,401,410,420,426,436,446,456],"counts",{"_466":33,"_467":171,"_468":33,"_469":33},"pulls","branches","forks","envVars","contents",[],{"_106":334,"_97":335,"_150":336,"_152":259,"_153":139,"_154":103,"_156":27,"_108":473,"_102":182,"_158":320,"_160":338,"_161":27,"_162":-5,"_100":474},["D",1746641936924],[258,335],"upstream","screenshots",{"_478":479,"_480":481},"thumbnail","https://screenshots.valtown.net/screenshot.png?width=1024&height=768&version=273&url=https%3A%2F%2Fdevto--9829a20a2aa211f08816569c3dd06744.web.val.run","preview","https://screenshots.valtown.net/screenshot.png?width=1920&height=1080&version=273&url=https%3A%2F%2Fdevto--9829a20a2aa211f08816569c3dd06744.web.val.run","emptyEnvVars","isNew","routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_95":96,"_97":98,"_99":43,"_102":103,"_100":101,"_104":486,"_145":490,"_462":596,"_274":597,"_470":599,"_475":-5,"_600":27,"_601":-5},{"_106":107,"_97":98,"_108":487,"_110":-5,"_111":27,"_112":113,"_114":-5,"_115":-5,"_12":116,"_117":118,"_119":120,"_121":122,"_123":33,"_124":125,"_126":125,"_127":128,"_129":128,"_130":128,"_131":125,"_132":27,"_21":488,"_136":489},["D",1746553245576],{"_95":96,"_134":135},{"_102":138,"_97":43,"_106":139,"_140":107,"_141":-5,"_142":-5,"_143":-5,"_144":-5},[491,506,515,524,554,572,581,590,593],{"_106":148,"_97":149,"_150":151,"_152":-5,"_153":139,"_154":155,"_156":120,"_108":157,"_102":33,"_158":159,"_160":-5,"_161":27,"_162":-5,"_163":492,"_100":505},[493,496,499,502],{"_106":166,"_97":167,"_150":168,"_152":151,"_153":139,"_154":169,"_156":27,"_108":170,"_102":171,"_158":172,"_160":173,"_161":27,"_162":-5,"_163":494,"_100":495},[],[149,167],{"_106":177,"_97":178,"_150":179,"_152":151,"_153":139,"_154":180,"_156":27,"_108":181,"_102":182,"_158":172,"_160":183,"_161":27,"_162":-5,"_163":497,"_100":498},[],[149,178],{"_106":187,"_97":188,"_150":189,"_152":151,"_153":139,"_154":190,"_156":27,"_108":191,"_102":182,"_158":172,"_160":192,"_161":27,"_162":-5,"_163":500,"_100":501},[],[149,188],{"_106":196,"_97":197,"_150":198,"_152":151,"_153":139,"_154":199,"_156":120,"_108":200,"_102":33,"_158":172,"_160":201,"_161":27,"_162":-5,"_163":503,"_100":504},[],[149,197],[149],{"_106":206,"_97":207,"_150":208,"_152":-5,"_153":139,"_154":155,"_156":120,"_108":209,"_102":33,"_158":159,"_160":-5,"_161":27,"_162":-5,"_163":507,"_100":514},[508,511],{"_106":212,"_97":213,"_150":214,"_152":208,"_153":139,"_154":215,"_156":27,"_108":216,"_102":217,"_158":172,"_160":218,"_161":27,"_162":-5,"_163":509,"_100":510},[],[207,213],{"_106":222,"_97":223,"_150":224,"_152":208,"_153":139,"_154":225,"_156":27,"_108":226,"_102":227,"_158":172,"_160":228,"_161":27,"_162":-5,"_163":512,"_100":513},[],[207,223],[207],{"_106":233,"_97":234,"_150":235,"_152":-5,"_153":139,"_154":155,"_156":120,"_108":236,"_102":33,"_158":159,"_160":-5,"_161":27,"_162":-5,"_163":516,"_100":523},[517,520],{"_106":239,"_97":240,"_150":241,"_152":235,"_153":139,"_154":242,"_156":120,"_108":243,"_102":182,"_158":172,"_160":244,"_161":27,"_162":-5,"_163":518,"_100":519},[],[234,240],{"_106":248,"_97":249,"_150":250,"_152":235,"_153":139,"_154":155,"_156":120,"_108":251,"_102":33,"_158":172,"_160":252,"_161":27,"_162":-5,"_163":521,"_100":522},[],[234,249],[234],{"_106":257,"_97":258,"_150":259,"_152":-5,"_153":139,"_154":155,"_156":120,"_108":260,"_102":33,"_158":159,"_160":-5,"_161":27,"_162":-5,"_163":525,"_100":553},[526,532,544,547,550],{"_106":263,"_97":264,"_150":265,"_152":259,"_153":139,"_154":155,"_156":120,"_108":266,"_102":33,"_158":159,"_160":-5,"_161":27,"_162":-5,"_163":527,"_100":531},[528],{"_106":269,"_97":270,"_150":271,"_152":265,"_153":139,"_154":272,"_156":120,"_108":273,"_102":171,"_158":274,"_160":275,"_161":27,"_162":-5,"_163":529,"_100":530},[],[258,264,270],[258,264],{"_106":280,"_97":281,"_150":282,"_152":259,"_153":139,"_154":155,"_156":120,"_108":283,"_102":33,"_158":159,"_160":-5,"_161":27,"_162":-5,"_163":533,"_100":543},[534,537,540],{"_106":286,"_97":287,"_150":288,"_152":282,"_153":139,"_154":289,"_156":27,"_108":290,"_102":291,"_158":172,"_160":292,"_161":27,"_162":-5,"_163":535,"_100":536},[],[258,281,287],{"_106":296,"_97":297,"_150":298,"_152":282,"_153":139,"_154":299,"_156":27,"_108":300,"_102":182,"_158":172,"_160":301,"_161":27,"_162":-5,"_163":538,"_100":539},[],[258,281,297],{"_106":305,"_97":306,"_150":307,"_152":282,"_153":139,"_154":308,"_156":120,"_108":309,"_102":33,"_158":172,"_160":310,"_161":27,"_162":-5,"_163":541,"_100":542},[],[258,281,306],[258,281],{"_106":315,"_97":316,"_150":317,"_152":259,"_153":139,"_154":318,"_156":27,"_108":319,"_102":182,"_158":320,"_160":321,"_161":27,"_162":-5,"_163":545,"_100":546},[],[258,316],{"_106":325,"_97":326,"_150":327,"_152":259,"_153":139,"_154":328,"_156":27,"_108":329,"_102":182,"_158":320,"_160":330,"_161":27,"_162":-5,"_163":548,"_100":549},[],[258,326],{"_106":334,"_97":335,"_150":336,"_152":259,"_153":139,"_154":103,"_156":27,"_108":337,"_102":182,"_158":320,"_160":338,"_161":27,"_162":-5,"_163":551,"_100":552},[],[258,335],[258],{"_106":343,"_97":344,"_150":345,"_152":-5,"_153":139,"_154":155,"_156":120,"_108":346,"_102":33,"_158":159,"_160":-5,"_161":27,"_162":-5,"_163":555,"_100":571},[556,559,562,565,568],{"_106":349,"_97":350,"_150":351,"_152":345,"_153":139,"_154":352,"_156":27,"_108":353,"_102":182,"_158":172,"_160":354,"_161":27,"_162":-5,"_163":557,"_100":558},[],[344,350],{"_106":358,"_97":359,"_150":360,"_152":345,"_153":139,"_154":155,"_156":27,"_108":361,"_102":33,"_158":172,"_160":362,"_161":27,"_162":-5,"_163":560,"_100":561},[],[344,359],{"_106":366,"_97":367,"_150":368,"_152":345,"_153":139,"_154":369,"_156":27,"_108":370,"_102":371,"_158":172,"_160":372,"_161":27,"_162":-5,"_163":563,"_100":564},[],[344,367],{"_106":376,"_97":377,"_150":378,"_152":345,"_153":139,"_154":379,"_156":27,"_108":380,"_102":33,"_158":172,"_160":381,"_161":27,"_162":-5,"_163":566,"_100":567},[],[344,377],{"_106":385,"_97":386,"_150":387,"_152":345,"_153":139,"_154":388,"_156":120,"_108":389,"_102":390,"_158":172,"_160":391,"_161":27,"_162":-5,"_163":569,"_100":570},[],[344,386],[344],{"_106":396,"_97":397,"_150":398,"_152":-5,"_153":139,"_154":155,"_156":120,"_108":399,"_102":33,"_158":159,"_160":-5,"_161":27,"_162":-5,"_163":573,"_100":580},[574,577],{"_106":402,"_97":403,"_150":404,"_152":398,"_153":139,"_154":405,"_156":120,"_108":406,"_102":182,"_158":172,"_160":407,"_161":27,"_162":-5,"_163":575,"_100":576},[],[397,403],{"_106":411,"_97":412,"_150":413,"_152":398,"_153":139,"_154":414,"_156":27,"_108":415,"_102":33,"_158":172,"_160":416,"_161":27,"_162":-5,"_163":578,"_100":579},[],[397,412],[397],{"_106":421,"_97":422,"_150":423,"_152":-5,"_153":139,"_154":155,"_156":120,"_108":424,"_102":33,"_158":159,"_160":-5,"_161":27,"_162":-5,"_163":582,"_100":589},[583,586],{"_106":427,"_97":428,"_150":429,"_152":423,"_153":139,"_154":430,"_156":27,"_108":431,"_102":432,"_158":274,"_160":433,"_161":27,"_162":-5,"_163":584,"_100":585},[],[422,428],{"_106":437,"_97":438,"_150":439,"_152":423,"_153":139,"_154":440,"_156":27,"_108":441,"_102":182,"_158":274,"_160":442,"_161":27,"_162":-5,"_163":587,"_100":588},[],[422,438],[422],{"_106":447,"_97":448,"_150":449,"_152":-5,"_153":139,"_154":450,"_156":27,"_108":451,"_102":452,"_158":274,"_160":453,"_161":27,"_162":-5,"_163":591,"_100":592},[],[448],{"_106":457,"_97":178,"_150":118,"_152":-5,"_153":139,"_154":155,"_156":27,"_108":458,"_102":390,"_158":320,"_160":459,"_161":27,"_162":96,"_163":594,"_100":595},[],[178],[491,493,496,499,502,506,508,511,515,517,520,524,526,528,532,534,537,540,544,547,550,554,556,559,562,565,568,572,574,577,581,583,586,590,593],{"_106":334,"_97":335,"_150":336,"_152":259,"_153":139,"_154":103,"_156":27,"_108":473,"_102":182,"_158":320,"_160":338,"_161":27,"_162":-5,"_100":598},[258,335],[],"showCompareCallout","pull","routes/_app","actionData","errors"]

Uploadcare Single File Demo

Upload Images

Results

Implementation Code

Uploadcare Individual Files Demo

Upload Images

Problem: Group Uploads

Solution 1: Individual File Uploads

Solution 2: Process Group Files Individually

Results

Group Upload Result

Individual Files Result

Smart Group Handling Result

Uploadcare Group Fix

The Problem

Solution 1: Single File Uploads

Solution 2: Extract from Group

Extracted Files

Implementation Guide

JavaScript Code

Backend API Example

Hello from LauraMepson!

LauraMepson

Ad Portal

Account Information

Company Information

Image Gallery

Your Images

Ad Creation

LauraMepson

Already have an account?

Submission Successful!