\n \n \n\n",[],[262,264],"6db636c6-3fb7-11f0-9c1c-76b3cceeab13","JobForm.tsx","6db637de-3fb7-11f0-9c1c-76b3cceeab13","bf232657-ac6a-4bcb-a039-cdb391bf5fa5",11,["D",1748871750065],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from 'https://esm.sh/react@18.2.0';\nimport type { Job, CreateJobRequest, ApiResponse } from '../../shared/types.ts';\n\ninterface JobFormProps {\n onJobCreated: (job: Job) => void;\n}\n\nexport default function JobForm({ onJobCreated }: JobFormProps) {\n const [formData, setFormData] = useState({\n title: '',\n company: '',\n description: '',\n location: '',\n salary: '',\n contact_email: ''\n });\n const [submitting, setSubmitting] = useState(false);\n const [error, setError] = useState(null);\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setSubmitting(true);\n setError(null);\n\n try {\n const response = await fetch('/api/jobs', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json'\n },\n body: JSON.stringify(formData)\n });\n\n const result: ApiResponse = await response.json();\n\n if (result.success && result.data) {\n onJobCreated(result.data);\n // Reset form\n setFormData({\n title: '',\n company: '',\n description: '',\n location: '',\n salary: '',\n contact_email: ''\n });\n } else {\n setError(result.error || 'Failed to create job posting');\n }\n } catch (err) {\n setError('Failed to create job posting');\n } finally {\n setSubmitting(false);\n }\n };\n\n const handleChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({\n ...prev,\n [name]: value\n }));\n };\n\n return (\n \n );\n}",[],[262,280,272],"components","5f793770-3fb7-11f0-a1b8-76b3cceeab13","JobBoard.tsx","5f79382e-3fb7-11f0-a1b8-76b3cceeab13",10,["D",1748871726174],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from 'https://esm.sh/react@18.2.0';\nimport type { Job, ApiResponse } from '../../shared/types.ts';\nimport JobForm from './JobForm.tsx';\n\nexport default function JobBoard() {\n const [jobs, setJobs] = useState([]);\n const [loading, setLoading] = useState(true);\n const [showForm, setShowForm] = useState(false);\n const [error, setError] = useState(null);\n\n const fetchJobs = async () => {\n try {\n setLoading(true);\n const response = await fetch('/api/jobs');\n const result: ApiResponse = await response.json();\n \n if (result.success && result.data) {\n setJobs(result.data);\n setError(null);\n } else {\n setError(result.error || 'Failed to fetch jobs');\n }\n } catch (err) {\n setError('Failed to fetch jobs');\n } finally {\n setLoading(false);\n }\n };\n\n const handleJobCreated = (newJob: Job) => {\n setJobs(prev => [newJob, ...prev]);\n setShowForm(false);\n };\n\n const handleDeleteJob = async (jobId: number) => {\n if (!confirm('Are you sure you want to delete this job posting?')) {\n return;\n }\n\n try {\n const response = await fetch(`/api/jobs/${jobId}`, {\n method: 'DELETE'\n });\n const result: ApiResponse<{ deleted: boolean }> = await response.json();\n \n if (result.success) {\n setJobs(prev => prev.filter(job => job.id !== jobId));\n } else {\n alert(result.error || 'Failed to delete job');\n }\n } catch (err) {\n alert('Failed to delete job');\n }\n };\n\n const formatDate = (dateString: string) => {\n return new Date(dateString).toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'short',\n day: 'numeric'\n });\n };\n\n useEffect(() => {\n fetchJobs();\n }, []);\n\n if (loading) {\n return (\n

Loading jobs...

\n );\n }\n\n return (\n

\n {/* Header */}\n

Job Opportunities

\n {jobs.length} {jobs.length === 1 ? 'job' : 'jobs'} available\n

\n setShowForm(!showForm)}\n className=\"bg-blue-600 text-white px-4 py-2 rounded-md hover:bg-blue-700 transition-colors\"\n >\n {showForm ? '✕ Cancel' : '➕ Post Job'}\n \n

\n\n {/* Error Message */}\n {error && (\n

\n {error}\n

\n )}\n\n {/* Job Form */}\n {showForm && (\n

Post a New Job

\n \n

\n )}\n\n {/* Jobs List */}\n

\n {jobs.length === 0 ? (\n

No jobs posted yet

Be the first to post a job opportunity!

\n ) : (\n jobs.map((job) => (\n

{job.title}

\n at\n {job.company}\n

\n \n

\n \n 📍 {job.location}\n \n \n 💰 {job.salary}\n \n \n 📅 Posted {formatDate(job.created_at)}\n \n

\n \n

{job.description}

\n \n

\n \n 📧 Apply Now\n \n {job.contact_email}\n

\n \n handleDeleteJob(job.id)}\n className=\"text-red-500 hover:text-red-700 p-2 rounded-md hover:bg-red-50 transition-colors\"\n title=\"Delete job posting\"\n >\n 🗑️\n \n

\n ))\n )}\n

\n );\n}",[],[262,280,282],"81878650-3fb7-11f0-a65f-76b3cceeab13","ChatRoom.tsx","81878718-3fb7-11f0-a65f-76b3cceeab13",12,["D",1748871783313],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect, useRef } from 'https://esm.sh/react@18.2.0';\nimport type { ChatMessage, CreateMessageRequest, ApiResponse } from '../../shared/types.ts';\n\nexport default function ChatRoom() {\n const [messages, setMessages] = useState([]);\n const [username, setUsername] = useState('');\n const [message, setMessage] = useState('');\n const [loading, setLoading] = useState(true);\n const [sending, setSending] = useState(false);\n const [error, setError] = useState(null);\n const messagesEndRef = useRef(null);\n\n const scrollToBottom = () => {\n messagesEndRef.current?.scrollIntoView({ behavior: 'smooth' });\n };\n\n const fetchMessages = async () => {\n try {\n setLoading(true);\n const response = await fetch('/api/chat/messages');\n const result: ApiResponse = await response.json();\n \n if (result.success && result.data) {\n setMessages(result.data);\n setError(null);\n } else {\n setError(result.error || 'Failed to fetch messages');\n }\n } catch (err) {\n setError('Failed to fetch messages');\n } finally {\n setLoading(false);\n }\n };\n\n const handleSendMessage = async (e: React.FormEvent) => {\n e.preventDefault();\n \n if (!username.trim() || !message.trim()) {\n return;\n }\n\n setSending(true);\n setError(null);\n\n try {\n const messageData: CreateMessageRequest = {\n username: username.trim(),\n message: message.trim()\n };\n\n const response = await fetch('/api/chat/messages', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json'\n },\n body: JSON.stringify(messageData)\n });\n\n const result: ApiResponse = await response.json();\n\n if (result.success && result.data) {\n setMessages(prev => [...prev, result.data!]);\n setMessage('');\n setTimeout(scrollToBottom, 100);\n } else {\n setError(result.error || 'Failed to send message');\n }\n } catch (err) {\n setError('Failed to send message');\n } finally {\n setSending(false);\n }\n };\n\n const formatTime = (dateString: string) => {\n return new Date(dateString).toLocaleTimeString('en-US', {\n hour: '2-digit',\n minute: '2-digit'\n });\n };\n\n const formatDate = (dateString: string) => {\n const date = new Date(dateString);\n const today = new Date();\n const yesterday = new Date(today);\n yesterday.setDate(yesterday.getDate() - 1);\n\n if (date.toDateString() === today.toDateString()) {\n return 'Today';\n } else if (date.toDateString() === yesterday.toDateString()) {\n return 'Yesterday';\n } else {\n return date.toLocaleDateString('en-US', {\n month: 'short',\n day: 'numeric'\n });\n }\n };\n\n // Group messages by date\n const groupedMessages = messages.reduce((groups, message) => {\n const date = new Date(message.created_at).toDateString();\n if (!groups[date]) {\n groups[date] = [];\n }\n groups[date].push(message);\n return groups;\n }, {} as Record);\n\n useEffect(() => {\n fetchMessages();\n // Poll for new messages every 5 seconds\n const interval = setInterval(fetchMessages, 5000);\n return () => clearInterval(interval);\n }, []);\n\n useEffect(() => {\n scrollToBottom();\n }, [messages]);\n\n if (loading) {\n return (\n

Loading chat...

\n );\n }\n\n return (\n

\n {/* Chat Header */}\n

💬 Public Chat Room

\n Discuss job opportunities and connect with others\n

\n\n {/* Error Message */}\n {error && (\n

\n {error}\n

\n )}\n\n {/* Messages Container */}\n

\n {Object.keys(groupedMessages).length === 0 ? (\n

No messages yet

Be the first to start the conversation!

\n ) : (\n Object.entries(groupedMessages).map(([date, dayMessages]) => (\n

\n {/* Date Separator */}\n

\n {formatDate(dayMessages[0].created_at)}\n

\n \n {/* Messages for this date */}\n {dayMessages.map((msg) => (\n

\n {msg.username.charAt(0).toUpperCase()}\n

\n \n {msg.username}\n \n \n {formatTime(msg.created_at)}\n \n

\n {msg.message}\n

\n ))}\n

\n ))\n )}\n

\n\n {/* Message Input */}\n

\n setUsername(e.target.value)}\n placeholder=\"Your name\"\n maxLength={50}\n className=\"w-32 px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500 focus:border-transparent text-sm\"\n />\n setMessage(e.target.value)}\n placeholder=\"Type your message...\"\n maxLength={500}\n className=\"flex-1 px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500 focus:border-transparent text-sm\"\n />\n \n {sending ? '...' : 'Send'}\n \n

\n Messages refresh automatically every 5 seconds\n {message.length}/500 characters\n

\n );\n}",[],[262,280,290],"4f1abca0-3fb7-11f0-895c-76b3cceeab13","App.tsx","4f1abd86-3fb7-11f0-895c-76b3cceeab13",9,["D",1748871698712],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from 'https://esm.sh/react@18.2.0';\nimport JobBoard from './JobBoard.tsx';\nimport ChatRoom from './ChatRoom.tsx';\n\nexport default function App() {\n const [activeTab, setActiveTab] = useState<'jobs' | 'chat'>('jobs');\n\n return (\n

\n {/* Header */}\n

💼 Job Board & Chat

\n setActiveTab('jobs')}\n className={`px-4 py-2 rounded-md text-sm font-medium transition-colors ${\n activeTab === 'jobs'\n ? 'bg-blue-100 text-blue-700'\n : 'text-gray-500 hover:text-gray-700 hover:bg-gray-100'\n }`}\n >\n 📋 Jobs\n \n setActiveTab('chat')}\n className={`px-4 py-2 rounded-md text-sm font-medium transition-colors ${\n activeTab === 'chat'\n ? 'bg-blue-100 text-blue-700'\n : 'text-gray-500 hover:text-gray-700 hover:bg-gray-100'\n }`}\n >\n 💬 Chat\n \n

\n\n {/* Main Content */}\n

\n {activeTab === 'jobs' ? : }\n

\n );\n}",[],[262,280,298],"4f1ac768-3fb7-11f0-895c-76b3cceeab13",["D",1748871698712],[223,224,225,226],[262,280],"48417090-3fb7-11f0-a6fa-76b3cceeab13",["D",1748871687214],[222,227,228],[262],["D",1748871801112],[],[18,94],"3575d730-3fb7-11f0-8b38-76b3cceeab13","jobs.ts","3575d7e4-3fb7-11f0-8b38-76b3cceeab13",["D",1748871655687],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getAllJobs, createJob, deleteJob } from \"../database/queries.ts\";\nimport type { CreateJobRequest, ApiResponse } from \"../../shared/types.ts\";\n\nconst jobs = new Hono();\n\n// Get all jobs\njobs.get(\"/\", async (c) => {\n try {\n const jobList = await getAllJobs();\n const response: ApiResponse = {\n success: true,\n data: jobList\n };\n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: \"Failed to fetch jobs\"\n };\n return c.json(response, 500);\n }\n});\n\n// Create a new job\njobs.post(\"/\", async (c) => {\n try {\n const jobData: CreateJobRequest = await c.req.json();\n \n // Basic validation\n if (!jobData.title || !jobData.company || !jobData.description || \n !jobData.location || !jobData.salary || !jobData.contact_email) {\n const response: ApiResponse = {\n success: false,\n error: \"All fields are required\"\n };\n return c.json(response, 400);\n }\n\n const newJob = await createJob(jobData);\n const response: ApiResponse = {\n success: true,\n data: newJob\n };\n return c.json(response, 201);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: \"Failed to create job\"\n };\n return c.json(response, 500);\n }\n});\n\n// Delete a job\njobs.delete(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid job ID\"\n };\n return c.json(response, 400);\n }\n\n const deleted = await deleteJob(id);\n if (!deleted) {\n const response: ApiResponse = {\n success: false,\n error: \"Job not found\"\n };\n return c.json(response, 404);\n }\n\n const response: ApiResponse<{ deleted: boolean }> = {\n success: true,\n data: { deleted: true }\n };\n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: \"Failed to delete job\"\n };\n return c.json(response, 500);\n }\n});\n\nexport default jobs;",[],[18,84,317],"3cf0bd2c-3fb7-11f0-a0d7-76b3cceeab13","chat.ts","3cf0bde0-3fb7-11f0-a0d7-76b3cceeab13",6,["D",1748871668240],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getRecentMessages, createMessage } from \"../database/queries.ts\";\nimport type { CreateMessageRequest, ApiResponse } from \"../../shared/types.ts\";\n\nconst chat = new Hono();\n\n// Get recent messages\nchat.get(\"/messages\", async (c) => {\n try {\n const messages = await getRecentMessages();\n const response: ApiResponse = {\n success: true,\n data: messages\n };\n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: \"Failed to fetch messages\"\n };\n return c.json(response, 500);\n }\n});\n\n// Send a new message\nchat.post(\"/messages\", async (c) => {\n try {\n const messageData: CreateMessageRequest = await c.req.json();\n \n // Basic validation\n if (!messageData.username || !messageData.message) {\n const response: ApiResponse = {\n success: false,\n error: \"Username and message are required\"\n };\n return c.json(response, 400);\n }\n\n // Trim and validate message length\n messageData.username = messageData.username.trim();\n messageData.message = messageData.message.trim();\n\n if (messageData.username.length > 50) {\n const response: ApiResponse = {\n success: false,\n error: \"Username must be 50 characters or less\"\n };\n return c.json(response, 400);\n }\n\n if (messageData.message.length > 500) {\n const response: ApiResponse = {\n success: false,\n error: \"Message must be 500 characters or less\"\n };\n return c.json(response, 400);\n }\n\n const newMessage = await createMessage(messageData);\n const response: ApiResponse = {\n success: true,\n data: newMessage\n };\n return c.json(response, 201);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: \"Failed to send message\"\n };\n return c.json(response, 500);\n }\n});\n\nexport default chat;",[],[18,84,324],["D",1748871655687],[218,219],[18,84],"2eca7170-3fb7-11f0-939f-76b3cceeab13","queries.ts","2eca7260-3fb7-11f0-939f-76b3cceeab13",4,["D",1748871644498],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { JOBS_TABLE, CHAT_MESSAGES_TABLE } from \"./migrations.ts\";\nimport type { Job, CreateJobRequest, ChatMessage, CreateMessageRequest } from \"../../shared/types.ts\";\n\n// Job queries\nexport async function getAllJobs(): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${JOBS_TABLE} \n ORDER BY created_at DESC\n `);\n return result.rows as Job[];\n}\n\nexport async function createJob(jobData: CreateJobRequest): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${JOBS_TABLE} (title, company, description, location, salary, contact_email)\n VALUES (?, ?, ?, ?, ?, ?)\n `, [\n jobData.title,\n jobData.company,\n jobData.description,\n jobData.location,\n jobData.salary,\n jobData.contact_email\n ]);\n\n // Get the created job\n const createdJob = await sqlite.execute(`\n SELECT * FROM ${JOBS_TABLE} WHERE id = ?\n `, [result.lastInsertRowId]);\n\n return createdJob.rows[0] as Job;\n}\n\nexport async function deleteJob(id: number): Promise {\n const result = await sqlite.execute(`\n DELETE FROM ${JOBS_TABLE} WHERE id = ?\n `, [id]);\n\n return result.changes > 0;\n}\n\n// Chat queries\nexport async function getRecentMessages(limit: number = 50): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${CHAT_MESSAGES_TABLE} \n ORDER BY created_at DESC \n LIMIT ?\n `, [limit]);\n \n // Reverse to show oldest first\n return (result.rows as ChatMessage[]).reverse();\n}\n\nexport async function createMessage(messageData: CreateMessageRequest): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${CHAT_MESSAGES_TABLE} (username, message)\n VALUES (?, ?)\n `, [messageData.username, messageData.message]);\n\n // Get the created message\n const createdMessage = await sqlite.execute(`\n SELECT * FROM ${CHAT_MESSAGES_TABLE} WHERE id = ?\n `, [result.lastInsertRowId]);\n\n return createdMessage.rows[0] as ChatMessage;\n}",[],[18,68,335],"296dcc4a-3fb7-11f0-8fea-76b3cceeab13","migrations.ts","296dcd08-3fb7-11f0-8fea-76b3cceeab13",["D",1748871635496],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names with version numbers for easy schema updates\nexport const JOBS_TABLE = 'jobs_v1';\nexport const CHAT_MESSAGES_TABLE = 'chat_messages_v1';\n\nexport async function runMigrations() {\n // Create jobs table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${JOBS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n company TEXT NOT NULL,\n description TEXT NOT NULL,\n location TEXT NOT NULL,\n salary TEXT NOT NULL,\n contact_email TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create chat messages table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${CHAT_MESSAGES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n message TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n console.log('Database migrations completed');\n}",[],[18,68,343],["D",1748871635496],[215,216],[18,68],["D",1748871635496],[214,217,220],[18],["D",1748871589821],{"_11":12,"_159":74},{"_11":12,"_155":-5,"_73":74,"_31":72,"_156":157,"_158":30},{"_43":107,"_13":16,"_37":40,"_147":114,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":14,"_154":12},"ctx",{"_56":-5,"_178":392,"_393":394,"_395":396,"_397":30,"_398":30,"_399":30,"_400":24,"_401":-5,"_402":-7,"_403":-7,"_404":26,"_405":30,"_406":30,"_407":-5,"_408":30,"_409":30,"_410":30,"_411":-5},"ENV",{"_363":364,"_365":366,"_367":16,"_368":369,"_370":371,"_372":373,"_374":375,"_376":377,"_378":379,"_380":381,"_382":383,"_384":385,"_386":387,"_388":389,"_390":391},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

History · backend