🚀 Sit Tracker & Job Board

\n \n

Sit Tracking 🕰️

Total Sit Time: {Math.floor(totalSitTime / 3600)} hours {Math.floor((totalSitTime % 3600) / 60)} mins

\n {!isCurrentlySitting ? (\n \n ) : (\n \n )}\n

\n {alertTime > 0 && (\n

⏰ Time to Stand Up and Walk Around! ⏰

\n )}\n

\n \n

Post a Job 💼

\n setNewJob({...newJob, title: e.target.value})}\n required \n />\n setNewJob({...newJob, company: e.target.value})}\n required \n />\n

setNewJob({...newJob, description: e.target.value})}\n            required \n          />\n          <button type=\"submit\">Post Job</button>\n        </form>\n\n        <div className=\"job-list\">\n          <h2>Current Job Postings 📋</h2>\n          {jobs.map((job, index) => (\n            <div key={index} className=\"job-card\">\n              <h3>{job.title} @ {job.company}</h3>\n              <p>{job.description}</p>\n            </div>\n          ))}\n        </div>\n      </div>\n\n      <div className=\"chat-section\">\n        <h2>Community Chat 💬</h2>\n        <div className=\"message-list\">\n          {messages.map((msg, index) => (\n            <div key={index} className=\"message\">\n              <strong>{msg.username || 'Anonymous'}</strong>: {msg.content}\n            </div>\n          ))}\n        </div>\n        <form onSubmit={submitMessage}>\n          <input \n            type=\"text\" \n            placeholder=\"Send a message\" \n            value={newMessage}\n            onChange={(e) => setNewMessage(e.target.value)}\n            required \n          />\n          <button type=\"submit\">Send</button>\n        </form>\n      </div>\n      <a \n        href={import.meta.url.replace(\"esm.town\", \"val.town\")} \n        target=\"_top\" \n        style={{color: '#888', textDecoration: 'none', fontSize: '0.8em'}}\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 = \"sitTrackerApp\";\n  const SCHEMA_VERSION = 4;\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      timestamp 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      username TEXT,\n      content TEXT NOT NULL,\n      timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n    )\n  `);\n\n  // Create sit tracking table\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_sit_tracking_${SCHEMA_VERSION} (\n      id INTEGER PRIMARY KEY AUTOINCREMENT,\n      start_time INTEGER NOT NULL,\n      end_time INTEGER,\n      duration INTEGER,\n      timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n    )\n  `);\n\n  // Handle different routes\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 timestamp DESC \n        LIMIT 20\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 timestamp DESC \n        LIMIT 50\n      `);\n      return new Response(JSON.stringify(messages.rows), {\n        headers: { 'Content-Type': 'application/json' }\n      });\n    }\n\n    if (url.pathname === '/sit-data') {\n      const sitData = await sqlite.execute(`\n        SELECT SUM(duration) as totalSitTime \n        FROM ${KEY}_sit_tracking_${SCHEMA_VERSION}\n      `);\n      return new Response(JSON.stringify({ \n        totalSitTime: sitData.rows[0]?.totalSitTime || 0 \n      }), {\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} \n        (title, company, description) VALUES (?, ?, ?)\n      `, [body.title, body.company, 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} \n        (content, username) VALUES (?, ?)\n      `, [body.content, 'Anonymous']);\n      return new Response('Message sent', { status: 200 });\n    }\n\n    if (url.pathname === '/start-sitting') {\n      await sqlite.execute(`\n        INSERT INTO ${KEY}_sit_tracking_${SCHEMA_VERSION} \n        (start_time) VALUES (?)\n      `, [body.startTime]);\n      return new Response('Sitting started', { status: 200 });\n    }\n\n    if (url.pathname === '/stop-sitting') {\n      await sqlite.execute(`\n        UPDATE ${KEY}_sit_tracking_${SCHEMA_VERSION} \n        SET end_time = ?, duration = ? \n        WHERE start_time = ?\n      `, [body.endTime, body.duration, body.startTime]);\n      return new Response('Sitting stopped', { status: 200 });\n    }\n  }\n\n  return new Response(`\n    <html>\n      <head>\n        <title>Sit Tracker & Job Board</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  line-height: 1.6;\n  margin: 0;\n  padding: 20px;\n  background-color: #f4f4f4;\n}\n.container {\n  max-width: 800px;\n  margin: 0 auto;\n  background: white;\n  padding: 20px;\n  border-radius: 8px;\n  box-shadow: 0 2px 5px rgba(0,0,0,0.1);\n}\n.sit-tracking {\n  background-color: #e6f3ff;\n  padding: 15px;\n  border-radius: 8px;\n  margin-bottom: 20px;\n}\n.sit-stats {\n  display: flex;\n  justify-content: space-between;\n  align-items: center;\n}\n.alert {\n  background-color: #ffdddd;\n  color: red;\n  padding: 10px;\n  text-align: center;\n  border-radius: 4px;\n  margin-top: 10px;\n}\nform {\n  display: flex;\n  flex-direction: column;\n  gap: 10px;\n  margin-bottom: 20px;\n}\ninput, textarea {\n  padding: 10px;\n  border: 1px solid #ddd;\n  border-radius: 4px;\n}\nbutton {\n  background-color: #4CAF50;\n  color: white;\n  border: none;\n  padding: 10px;\n  border-radius: 4px;\n  cursor: pointer;\n}\n.job-card, .message {\n  background-color: #f9f9f9;\n  border-left: 4px solid #4CAF50;\n  padding: 10px;\n  margin-bottom: 10px;\n}\n.chat-section .message-list {\n  max-height: 300px;\n  overflow-y: auto;\n}\n`;","deleted","label","children",[],[152],"files",[150],"counts",{"_172":32,"_173":119,"_174":32,"_175":32},"pulls","branches","forks","envVars","contents",[178],{"_102":151,"_95":152,"_153":114,"_154":-5,"_155":138,"_156":119,"_157":116,"_104":179,"_99":32,"_159":160,"_161":162,"_163":22,"_164":-5,"_98":180},["D",1739787183977],[152],"file","upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name._index",{"_93":94,"_95":96,"_97":-7,"_99":-7,"_100":190,"_176":195,"_198":-7,"_199":-5,"_200":-5,"_168":201,"_205":206},{"_102":103,"_95":96,"_104":191,"_106":-5,"_107":22,"_108":109,"_110":-5,"_111":-5,"_14":112,"_113":114,"_115":116,"_117":-5,"_118":119,"_16":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":192,"_133":193,"_136":194,"_147":22},["D",1746140185263],{"_93":94,"_131":132},{"_93":94,"_135":132},{"_99":119,"_95":43,"_102":138,"_139":103,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":96,"_146":94},[196],{"_102":151,"_95":152,"_153":114,"_154":-5,"_155":138,"_156":119,"_157":116,"_104":179,"_99":32,"_159":160,"_161":162,"_163":22,"_164":-5,"_98":197},[152],"readme","upstream","pull",[202],{"_102":151,"_95":152,"_153":114,"_154":-5,"_155":138,"_156":119,"_157":116,"_104":158,"_99":32,"_159":160,"_161":162,"_163":22,"_164":-5,"_165":203,"_98":204},[],[152],"previews",[202],"actionData","errors"]
</article></body></html>

olivas20000

sitTrackerApp