Post a Job

\n setTitle(e.target.value)}\n required \n />\n setCompany(e.target.value)}\n required \n />\n

setDescription(e.target.value)}\n        required \n      />\n      <button type=\"submit\">Post Job</button>\n    </form>\n  );\n}\n\nfunction JobListings() {\n  const [jobs, setJobs] = useState([]);\n\n  useEffect(() => {\n    async function fetchJobs() {\n      try {\n        const response = await fetch('/get-jobs');\n        const data = await response.json();\n        setJobs(data);\n      } catch (error) {\n        console.error('Error fetching jobs:', error);\n      }\n    }\n    fetchJobs();\n    const interval = setInterval(fetchJobs, 60000); // Refresh every minute\n    return () => clearInterval(interval);\n  }, []);\n\n  return (\n    <div className=\"job-listings\">\n      <h2>Job Postings</h2>\n      {jobs.map((job) => (\n        <div key={job.id} className=\"job-card\">\n          <h3>{job.title}</h3>\n          <p><strong>Company:</strong> {job.company}</p>\n          <p>{job.description}</p>\n        </div>\n      ))}\n    </div>\n  );\n}\n\nfunction ChatRoom() {\n  const [messages, setMessages] = useState([]);\n  const [newMessage, setNewMessage] = useState('');\n\n  useEffect(() => {\n    async function fetchMessages() {\n      try {\n        const response = await fetch('/get-messages');\n        const data = await response.json();\n        setMessages(data);\n      } catch (error) {\n        console.error('Error fetching messages:', error);\n      }\n    }\n    fetchMessages();\n    const interval = setInterval(fetchMessages, 5000); // Refresh every 5 seconds\n    return () => clearInterval(interval);\n  }, []);\n\n  const handleSendMessage = async (e) => {\n    e.preventDefault();\n    try {\n      const response = await fetch('/send-message', {\n        method: 'POST',\n        headers: { 'Content-Type': 'application/json' },\n        body: JSON.stringify({ content: newMessage })\n      });\n      if (response.ok) {\n        setNewMessage('');\n      }\n    } catch (error) {\n      console.error('Error sending message:', error);\n    }\n  };\n\n  return (\n    <div className=\"chat-room\">\n      <h2>Community Chat</h2>\n      <div className=\"message-list\">\n        {messages.map((msg) => (\n          <div key={msg.id} className=\"message\">\n            <strong>{msg.username || 'Anonymous'}</strong>: {msg.content}\n          </div>\n        ))}\n      </div>\n      <form onSubmit={handleSendMessage} className=\"message-form\">\n        <input \n          type=\"text\" \n          value={newMessage}\n          onChange={(e) => setNewMessage(e.target.value)}\n          placeholder=\"Type a message...\"\n          required \n        />\n        <button type=\"submit\">Send</button>\n      </form>\n    </div>\n  );\n}\n\nfunction App() {\n  return (\n    <div className=\"job-chat-app\">\n      <h1>Job Opportunities Platform</h1>\n      <div className=\"app-container\">\n        <div className=\"left-panel\">\n          <JobPostingForm />\n          <JobListings />\n        </div>\n        <div className=\"right-panel\">\n          <ChatRoom />\n        </div>\n      </div>\n      <footer>\n        <a href={import.meta.url.replace(\"esm.town\", \"val.town\")} target=\"_top\">View Source</a>\n      </footer>\n    </div>\n  );\n}\n\nfunction client() {\n  createRoot(document.getElementById(\"root\")).render(<App />);\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise<Response> {\n  const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n  const SCHEMA_VERSION = 3;\n  const KEY = \"JOBPOSTING2\";\n\n  // Create jobs table\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_jobs_${SCHEMA_VERSION} (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      title TEXT NOT NULL,\n      company TEXT NOT NULL,\n      description TEXT NOT NULL,\n      created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n    )\n  `);\n\n  // Create messages table\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_messages_${SCHEMA_VERSION} (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      content TEXT NOT NULL,\n      username TEXT,\n      created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n    )\n  `);\n\n  // Handle job submission\n  if (request.method === 'POST' && new URL(request.url).pathname === '/submit-job') {\n    const { title, company, description } = await request.json();\n    await sqlite.execute(\n      `INSERT INTO ${KEY}_jobs_${SCHEMA_VERSION} (title, company, description) VALUES (?, ?, ?)`,\n      [title, company, description]\n    );\n    return new Response(JSON.stringify({ success: true }), { \n      headers: { 'Content-Type': 'application/json' } \n    });\n  }\n\n  // Handle get jobs\n  if (request.method === 'GET' && new URL(request.url).pathname === '/get-jobs') {\n    const jobs = await sqlite.execute(`\n      SELECT * FROM ${KEY}_jobs_${SCHEMA_VERSION} \n      ORDER BY created_at DESC \n      LIMIT 50\n    `);\n    return new Response(JSON.stringify(jobs.rows), { \n      headers: { 'Content-Type': 'application/json' } \n    });\n  }\n\n  // Handle send message\n  if (request.method === 'POST' && new URL(request.url).pathname === '/send-message') {\n    const { content } = await request.json();\n    await sqlite.execute(\n      `INSERT INTO ${KEY}_messages_${SCHEMA_VERSION} (content, username) VALUES (?, ?)`,\n      [content, 'Anonymous']\n    );\n    return new Response(JSON.stringify({ success: true }), { \n      headers: { 'Content-Type': 'application/json' } \n    });\n  }\n\n  // Handle get messages\n  if (request.method === 'GET' && new URL(request.url).pathname === '/get-messages') {\n    const messages = await sqlite.execute(`\n      SELECT * FROM ${KEY}_messages_${SCHEMA_VERSION} \n      ORDER BY created_at DESC \n      LIMIT 50\n    `);\n    return new Response(JSON.stringify(messages.rows), { \n      headers: { 'Content-Type': 'application/json' } \n    });\n  }\n\n  // Main page render\n  return new Response(`\n    <html>\n      <head>\n        <title>Job Opportunities Platform</title>\n        <style>${css}</style>\n      </head>\n      <body>\n        <div id=\"root\"></div>\n        <script src=\"https://esm.town/v/std/catch\"></script>\n        <script type=\"module\" src=\"${import.meta.url}\"></script>\n      </body>\n    </html>\n  `, {\n    headers: { 'Content-Type': 'text/html' }\n  });\n}\n\nconst css = `\nbody {\n  font-family: Arial, sans-serif;\n  margin: 0;\n  padding: 0;\n  background-color: #f4f4f4;\n}\n\n.job-chat-app {\n  max-width: 1200px;\n  margin: 0 auto;\n  padding: 20px;\n}\n\n.app-container {\n  display: flex;\n  gap: 20px;\n}\n\n.left-panel, .right-panel {\n  flex: 1;\n  background: white;\n  padding: 20px;\n  border-radius: 8px;\n  box-shadow: 0 2px 5px rgba(0,0,0,0.1);\n}\n\n.job-form, .job-listings, .chat-room {\n  margin-bottom: 20px;\n}\n\n.job-form input, .job-form textarea {\n  width: 100%;\n  margin-bottom: 10px;\n  padding: 8px;\n}\n\n.job-card {\n  border: 1px solid #e0e0e0;\n  padding: 10px;\n  margin-bottom: 10px;\n}\n\n.message-list {\n  height: 400px;\n  overflow-y: auto;\n  border: 1px solid #e0e0e0;\n  padding: 10px;\n}\n\n.message {\n  margin-bottom: 5px;\n}\n\nfooter {\n  text-align: center;\n  margin-top: 20px;\n}\n`;","label",[59],"pulls","branches","forks","envVars",{"_158":20,"_160":20},"connections",{"_158":20,"_159":20},"count","unfilledCount","emptyCount",{"_28":143,"_13":59,"_57":58,"_38":-5,"_30":31,"_144":68,"_145":84,"_32":162,"_34":35,"_60":61,"_147":148,"_62":24,"_149":-5,"_163":164,"_120":165},["D",1742852318084],"children",[],[59],["D",1746197951545],{"_11":12,"_119":65},{"_11":12,"_115":-5,"_64":65,"_25":63,"_116":117,"_118":24},{"_34":68,"_13":16,"_28":31,"_107":73,"_108":-5,"_109":-5,"_110":-5,"_111":-5,"_112":-5,"_113":14,"_114":12},"ctx",{"_46":-5,"_139":203,"_204":205,"_206":207,"_208":24,"_209":24,"_210":24,"_211":84,"_212":-5,"_213":-7,"_214":-7,"_215":20,"_216":24,"_217":24,"_218":-5,"_219":24,"_220":24,"_221":24,"_222":-5},"ENV",{"_174":175,"_176":177,"_178":16,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202},"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"]
</article></body></html>

History