Set Your Username

\n \n

Your username will be visible in the chat room

\n );\n }\n\n function renderJobs() {\n return (\n

\n setJobSearch(e.target.value)}\n className=\"job-search-input\"\n />\n \n

\n setNewJobTitle(e.target.value)}\n required\n className=\"job-title-input\"\n />\n

setNewJobDescription(e.target.value)}\n            required\n            className=\"job-description-input\"\n          />\n          <button \n            type=\"submit\" \n            disabled={isLoading}\n            className=\"job-post-btn\"\n          >\n            {isLoading ? \"Posting...\" : \"Post Job\"}\n          </button>\n        </form>\n        {error && <div className=\"error-message\">{error}</div>}\n        <div className=\"job-listings\">\n          {filteredJobs.length === 0 ? (\n            <div className=\"no-jobs-message\">No jobs found</div>\n          ) : (\n            filteredJobs.map((job, index) => (\n              <div key={index} className=\"job-card\">\n                <h3 className=\"job-card-title\">{job.title}</h3>\n                <p className=\"job-card-description\">{job.description}</p>\n                <div className=\"job-card-footer\">\n                  <span className=\"job-card-date\">\n                    Posted: {new Date(job.created_at).toLocaleDateString()}\n                  </span>\n                </div>\n              </div>\n            ))\n          )}\n        </div>\n      </div>\n    );\n  }\n\n  function renderChat() {\n    return (\n      <div className=\"chat-container\">\n        <div className=\"chat-header\">\n          <h2>Public Chat Room \n            {username && <span className=\"username-display\"> (Logged in as: {username})</span>}\n          </h2>\n        </div>\n        <div className=\"message-list\">\n          {messages.map((msg, index) => (\n            <div \n              key={index} \n              className={`message-bubble ${msg.username === username ? 'message-sent' : 'message-received'}`}\n            >\n              <div \n                className=\"message-avatar\" \n                style={generateAvatar(msg.username)}\n              >\n                {msg.username[0].toUpperCase()}\n              </div>\n              <div className=\"message-content\">\n                <div className=\"message-username\">{msg.username}</div>\n                <div className=\"message-text\">{msg.content}</div>\n              </div>\n            </div>\n          ))}\n        </div>\n        {error && <div className=\"error-message\">{error}</div>}\n        <form onSubmit={submitMessage} className=\"chat-input-form\">\n          <input \n            placeholder=\"Type a message\" \n            value={newMessage}\n            onChange={(e) => setNewMessage(e.target.value)}\n            disabled={!username || isLoading}\n            className=\"chat-input\"\n          />\n          <button \n            type=\"submit\" \n            disabled={!username || isLoading}\n            className=\"chat-send-btn\"\n            onClick={() => {\n              if (!username) setShowUsernameModal(true);\n            }}\n          >\n            {isLoading ? \"Sending...\" : \"Send\"}\n          </button>\n        </form>\n        {!username && (\n          <div className=\"username-prompt\">\n            <button \n              onClick={() => setShowUsernameModal(true)}\n              className=\"set-username-btn\"\n            >\n              Set Username to Chat\n            </button>\n          </div>\n        )}\n      </div>\n    );\n  }\n\n  return (\n    <div className=\"app-container\">\n      {renderUsernameModal()}\n      <div className=\"app-tabs\">\n        <button \n          onClick={() => setActiveTab(\"jobs\")}\n          className={`tab-btn ${activeTab === 'jobs' ? 'active' : ''}`}\n        >\n          Job Opportunities\n        </button>\n        <button \n          onClick={() => setActiveTab(\"chat\")}\n          className={`tab-btn ${activeTab === 'chat' ? 'active' : ''}`}\n        >\n          Community Chat\n        </button>\n      </div>\n      {activeTab === \"jobs\" ? renderJobs() : renderChat()}\n      <a \n        href={import.meta.url.replace(\"esm.town\", \"val.town\")} \n        target=\"_top\" \n        className=\"source-link\"\n      >\n        View Source\n      </a>\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 KEY = new URL(import.meta.url).pathname.split(\"/\").at(-1);\n  const SCHEMA_VERSION = 6;\n\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      description TEXT NOT NULL,\n      created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n    )\n  `);\n\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_messages_${SCHEMA_VERSION} (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      username TEXT NOT NULL,\n      content TEXT NOT NULL,\n      created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n    )\n  `);\n\n  if (request.method === \"GET\") {\n    const url = new URL(request.url);\n    \n    if (url.pathname === \"/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    if (url.pathname === \"/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\n  if (request.method === \"POST\") {\n    const body = await request.json();\n    const url = new URL(request.url);\n\n    if (url.pathname === \"/jobs\") {\n      await sqlite.execute(`\n        INSERT INTO ${KEY}_jobs_${SCHEMA_VERSION} (title, description) \n        VALUES (?, ?)\n      `, [body.title, body.description]);\n      return new Response(\"Job posted\", { status: 200 });\n    }\n\n    if (url.pathname === \"/messages\") {\n      await sqlite.execute(`\n        INSERT INTO ${KEY}_messages_${SCHEMA_VERSION} (username, content) \n        VALUES (?, ?)\n      `, [body.username, body.content]);\n      return new Response(\"Message sent\", { status: 200 });\n    }\n  }\n\n  return new Response(`\n    <html>\n      <head>\n        <title>Data Science Job Board & Chat</title>\n        <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\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 = `\n:root {\n  --primary-color: #3498db;\n  --secondary-color: #2ecc71;\n  --background-color: #f7f9fc;\n  --text-color: #2c3e50;\n  --card-background: white;\n  --border-radius: 12px;\n}\n\n* {\n  box-sizing: border-box;\n  margin: 0;\n  padding: 0;\n  transition: all 0.3s ease;\n}\n\nbody {\n  font-family: 'Inter', -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen, Ubuntu, Cantarell, 'Open Sans', 'Helvetica Neue', sans-serif;\n  background-color: var(--background-color);\n  color: var(--text-color);\n  line-height: 1.6;\n}\n\n.app-container {\n  max-width: 800px;\n  margin: 0 auto;\n  padding: 20px;\n}\n\n.app-tabs {\n  display: flex;\n  margin-bottom: 20px;\n  background-color: white;\n  border-radius: var(--border-radius);\n  box-shadow: 0 4px 6px rgba(0,0,0,0.1);\n}\n\n.tab-btn {\n  flex: 1;\n  padding: 12px 20px;\n  border: none;\n  background-color: transparent;\n  color: var(--text-color);\n  font-weight: 600;\n  cursor: pointer;\n  transition: all 0.3s ease;\n}\n\n.tab-btn.active {\n  background-color: var(--primary-color);\n  color: white;\n}\n\n.tab-btn:hover {\n  background-color: rgba(52, 152, 219, 0.1);\n}\n\n.job-post-form {\n  background-color: var(--card-background);\n  border-radius: var(--border-radius);\n  padding: 20px;\n  margin-bottom: 20px;\n  box-shadow: 0 4px 6px rgba(0,0,0,0.1);\n}\n\n.job-title-input, .job-description-input {\n  width: 100%;\n  padding: 12px;\n  margin-bottom: 15px;\n  border: 1px solid #e0e0e0;\n  border-radius: 8px;\n  font-size: 16px;\n}\n\n.job-post-btn {\n  width: 100%;\n  padding: 12px;\n  background-color: var(--secondary-color);\n  color: white;\n  border: none;\n  border-radius: 8px;\n  font-weight: 600;\n  cursor: pointer;\n}\n\n.job-post-btn:disabled {\n  background-color: #b0b0b0;\n  cursor: not-allowed;\n}\n\n.job-listings {\n  display: grid;\n  grid-template-columns: repeat(auto-fill, minmax(250px, 1fr));\n  gap: 15px;\n}\n\n.job-card {\n  background-color: var(--card-background);\n  border-radius: var(--border-radius);\n  padding: 20px;\n  box-shadow: 0 4px 6px rgba(0,0,0,0.1);\n  transition: transform 0.3s ease;\n}\n\n.job-card:hover {\n  transform: translateY(-5px);\n}\n\n.job-card-title {\n  color: var(--primary-color);\n  margin-bottom: 10px;\n}\n\n.job-card-description {\n  color: var(--text-color);\n  margin-bottom: 15px;\n}\n\n.job-card-footer {\n  display: flex;\n  justify-content: space-between;\n  align-items: center;\n  font-size: 0.8em;\n  color: #7f8c8d;\n}\n\n.message-list {\n  max-height: 400px;\n  overflow-y: auto;\n  display: flex;\n  flex-direction: column;\n  gap: 10px;\n  padding: 15px;\n  background-color: white;\n  border-radius: var(--border-radius);\n}\n\n.message-bubble {\n  display: flex;\n  align-items: flex-start;\n  gap: 10px;\n}\n\n.message-avatar {\n  display: flex;\n  align-items: center;\n  justify-content: center;\n  width: 40px;\n  height: 40px;\n  border-radius: 50%;\n  font-weight: bold;\n}\n\n.message-content {\n  background-color: #f1f2f6;\n  padding: 10px 15px;\n  border-radius: 12px;\n  max-width: 70%;\n}\n\n.message-username {\n  font-weight: 600;\n  margin-bottom: 5px;\n  font-size: 0.9em;\n}\n\n.message-text {\n  word-wrap: break-word;\n}\n\n.chat-input-form {\n  display: flex;\n  gap: 10px;\n  margin-top: 15px;\n}\n\n.chat-input {\n  flex-grow: 1;\n  padding: 12px;\n  border: 1px solid #e0e0e0;\n  border-radius: 8px;\n}\n\n.chat-send-btn {\n  padding: 12px 20px;\n  background-color: var(--primary-color);\n  color: white;\n  border: none;\n  border-radius: 8px;\n  cursor: pointer;\n}\n\n.username-modal-overlay {\n  position: fixed;\n  top: 0;\n  left: 0;\n  width: 100%;\n  height: 100%;\n  background: rgba(0,0,0,0.5);\n  display: flex;\n  justify-content: center;\n  align-items: center;\n  z-index: 1000;\n}\n\n.username-modal {\n  background: white;\n  padding: 30px;\n  border-radius: var(--border-radius);\n  width: 400px;\n  text-align: center;\n  box-shadow: 0 10px 25px rgba(0,0,0,0.1);\n}\n\n.username-input {\n  width: 100%;\n  padding: 12px;\n  margin-bottom: 15px;\n  border: 1px solid #e0e0e0;\n  border-radius: 8px;\n}\n\n.username-submit-btn {\n  background-color: var(--primary-color);\n  color: white;\n  border: none;\n  padding: 12px 20px;\n  border-radius: 8px;\n  cursor: pointer;\n}\n\n.source-link {\n  display: block;\n  text-align: center;\n  margin-top: 20px;\n  color: #7f8c8d;\n  text-decoration: none;\n}\n\n@media (max-width: 600px) {\n  .app-container {\n    padding: 10px;\n  }\n\n  .job-listings {\n    grid-template-columns: 1fr;\n  }\n\n  .chat-input-form {\n    flex-direction: column;\n  }\n\n  .chat-send-btn {\n    width: 100%;\n  }\n}\n`;","createdAt",["D",1740589008773],"version",3,"currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount",1,"commentCount","prCount","mergedPr",{"_129":130,"_131":132},"handle","FortiBYOD","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ydEN0VEh5R1RLU3VpU1hXV3Z1UXBGeGdPOFkifQ","forkedVal","interval","slug","FortiBYOD/SQL_Developer","description","@jsxImportSource https://esm.sh/react@18.2.0","versions",[141,144,147,150],{"_117":118,"_142":-5,"_115":143,"_112":110},"prId",["D",1740589008773],{"_117":90,"_142":-5,"_115":145,"_112":146},["D",1740588919676],"76172fb4-f462-11ef-8d8e-569c3dd06744",{"_117":124,"_142":-5,"_115":148,"_112":149},["D",1740588849812],"4c72855a-f462-11ef-85ef-569c3dd06744",{"_117":31,"_142":-5,"_115":151,"_112":152},["D",1740588500513],"7c40ac18-f461-11ef-8224-569c3dd06744","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.pulls._index",{"_95":96,"_94":160,"_129":130,"_137":138,"_98":99,"_172":31,"_173":31,"_50":51,"_174":175},{"_98":99,"_95":96,"_100":101,"_102":-5,"_103":-5,"_104":105,"_106":-5,"_107":108,"_109":110,"_111":26,"_112":110,"_113":114,"_115":161,"_117":118,"_119":26,"_120":31,"_121":31,"_122":31,"_123":124,"_125":31,"_126":31,"_127":-5,"_20":162,"_133":-5,"_134":-7,"_135":136,"_137":138,"_139":163},["D",1740589008773],{"_129":130,"_131":132},[164,166,168,170],{"_117":118,"_142":-5,"_115":165,"_112":110},["D",1740589008773],{"_117":90,"_142":-5,"_115":167,"_112":146},["D",1740588919676],{"_117":124,"_142":-5,"_115":169,"_112":149},["D",1740588849812],{"_117":31,"_142":-5,"_115":171,"_112":152},["D",1740588500513],"page","count","prs",[],"routes/_app","actionData","errors"]
</article></body></html>