Employee Value Recognition

\n {!isAdmin\n ? (\n <>\n

\n \n \n {!isAdminMode && (\n <>\n

\n setEmployeeSearch(e.target.value)}\n />\n \n

\n \n \n \n \n \n )}\n \n \n

\n \n \n )\n : (\n

Analytics

\n \n

\n {analytics && (\n <>\n

Most Value Award Given: {analytics.mostValueAward}

Member with Most Awards: {analytics.topMember}

Total Votes: {analytics.totalVotes}

Votes This Month: {analytics.votesThisMonth}

Value Awards Distribution

{valueAward}: {count}

Top 5 Nominated Employees

\n {nominatedEmployee}: {count}\n

Monthly Analytics

\n {analytics.monthlyAnalytics.map((\n { month, count, topValue, topEmployee },\n ) => (\n

{month}

Total High Fives: {count}

Top Value: {topValue}

Top Employee: {topEmployee}

\n ))}\n \n

\n \n \n )}\n

\n )}\n\n

Lori Systems

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\n\nif (typeof document !== \"undefined\") client();\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const SCHEMA_VERSION = 2;\n const KEY = \"ValueAward\";\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_highfives_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n voterEmail TEXT NOT NULL,\n voterName TEXT NOT NULL,\n nominatedEmployee TEXT NOT NULL,\n valueAward TEXT NOT NULL,\n achievement TEXT NOT NULL,\n awardDate DATE NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n const url = new URL(request.url);\n if (url.pathname === \"/api/highfives\" && request.method === \"POST\") {\n const highFive = await request.json();\n await sqlite.execute(\n `\n INSERT INTO ${KEY}_highfives_${SCHEMA_VERSION} \n (voterEmail, voterName, nominatedEmployee, valueAward, achievement, awardDate)\n VALUES (?, ?, ?, ?, ?, ?)\n `,\n [\n highFive.voterEmail,\n highFive.voterName,\n highFive.nominatedEmployee,\n highFive.valueAward,\n highFive.achievement,\n highFive.awardDate,\n ],\n );\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } else if (url.pathname === \"/api/highfives\" && request.method === \"GET\") {\n const result = await sqlite.execute(\n `SELECT * FROM ${KEY}_highfives_${SCHEMA_VERSION} ORDER BY timestamp DESC LIMIT 10`,\n );\n return new Response(JSON.stringify(result.rows), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } else if (url.pathname === \"/api/analytics\" && request.method === \"GET\") {\n const mostValueAward = await sqlite.execute(`\n SELECT valueAward, COUNT(*) as count\n FROM ${KEY}_highfives_${SCHEMA_VERSION}\n GROUP BY valueAward\n ORDER BY count DESC\n LIMIT 1\n `);\n const topMember = await sqlite.execute(`\n SELECT nominatedEmployee, COUNT(*) as count\n FROM ${KEY}_highfives_${SCHEMA_VERSION}\n GROUP BY nominatedEmployee\n ORDER BY count DESC\n LIMIT 1\n `);\n const totalVotes = await sqlite.execute(\n `SELECT COUNT(*) as count FROM ${KEY}_highfives_${SCHEMA_VERSION}`,\n );\n const votesThisMonth = await sqlite.execute(`\n SELECT COUNT(*) as count\n FROM ${KEY}_highfives_${SCHEMA_VERSION}\n WHERE strftime('%Y-%m', awardDate) = strftime('%Y-%m', 'now')\n `);\n const valueAwardsDistribution = await sqlite.execute(`\n SELECT valueAward, COUNT(*) as count\n FROM ${KEY}_highfives_${SCHEMA_VERSION}\n GROUP BY valueAward\n ORDER BY count DESC\n `);\n const topNominatedEmployees = await sqlite.execute(`\n SELECT nominatedEmployee, COUNT(*) as count\n FROM ${KEY}_highfives_${SCHEMA_VERSION}\n GROUP BY nominatedEmployee\n ORDER BY count DESC\n LIMIT 5\n `);\n const monthlyAnalytics = await sqlite.execute(`\n SELECT \n strftime('%Y-%m', awardDate) as month,\n COUNT(*) as count,\n (SELECT valueAward FROM ${KEY}_highfives_${SCHEMA_VERSION} h2 \n WHERE strftime('%Y-%m', h2.awardDate) = strftime('%Y-%m', h1.awardDate) \n GROUP BY valueAward ORDER BY COUNT(*) DESC LIMIT 1) as topValue,\n (SELECT nominatedEmployee FROM ${KEY}_highfives_${SCHEMA_VERSION} h2 \n WHERE strftime('%Y-%m', h2.awardDate) = strftime('%Y-%m', h1.awardDate) \n GROUP BY nominatedEmployee ORDER BY COUNT(*) DESC LIMIT 1) as topEmployee\n FROM ${KEY}_highfives_${SCHEMA_VERSION} h1\n GROUP BY strftime('%Y-%m', awardDate)\n ORDER BY month DESC\n LIMIT 12\n `);\n const analytics = {\n mostValueAward: mostValueAward.rows[0]?.valueAward,\n topMember: topMember.rows[0]?.nominatedEmployee,\n totalVotes: totalVotes.rows[0]?.count,\n votesThisMonth: votesThisMonth.rows[0]?.count,\n valueAwardsDistribution: valueAwardsDistribution.rows,\n topNominatedEmployees: topNominatedEmployees.rows,\n monthlyAnalytics: monthlyAnalytics.rows,\n };\n return new Response(JSON.stringify(analytics), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } else if (url.pathname === \"/api/download-csv\" && request.method === \"GET\") {\n const result = await sqlite.execute(\n `SELECT * FROM ${KEY}_highfives_${SCHEMA_VERSION} ORDER BY timestamp DESC`,\n );\n const csvContent = [\n [\n \"ID\",\n \"Voter Email\",\n \"Voter Name\",\n \"Nominated Employee\",\n \"Value Award\",\n \"Achievement\",\n \"Award Date\",\n \"Timestamp\",\n ],\n ...result.rows.map((row) => [\n row.id,\n row.voterEmail,\n row.voterName,\n row.nominatedEmployee,\n row.valueAward,\n row.achievement,\n row.awardDate,\n row.timestamp,\n ]),\n ].map((row) => row.map((cell) => `\"${cell}\"`).join(\",\")).join(\"\\n\");\n\n return new Response(csvContent, {\n headers: {\n \"Content-Type\": \"text/csv\",\n \"Content-Disposition\": \"attachment; filename=high_fives.csv\",\n },\n });\n } else if (\n url.pathname === \"/api/delete-analytics\" && request.method === \"POST\"\n ) {\n await sqlite.execute(`DELETE FROM ${KEY}_highfives_${SCHEMA_VERSION}`);\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n const fullUrl = `https://${request.headers.get(\"host\")}${\n request.url.substring(request.url.indexOf(\"/\", 8))\n }`;\n\n return new Response(\n `\n \n \n \n \n \n \n \n \n Employee Value Recognition\n \n \n \n

\n \n \n \n \n `,\n {\n headers: {\n \"content-type\": \"text/html\",\n },\n },\n );\n}\n\nconst css = `\nbody {\n margin: 0;\n font-family: system-ui, sans-serif;\n background-image: url('https://maxm-imggenurl.web.val.run/A truck carrying a container with its lights on, moving on a highway at night');\n background-size: cover;\n background-position: center;\n background-attachment: fixed;\n color: white;\n min-height: 100vh;\n}\n\n.app {\n max-width: 800px;\n margin: 0 auto;\n padding: 20px;\n background-color: rgba(0, 0, 0, 0.5);\n border-radius: 10px;\n box-shadow: 0 0 10px rgba(0, 0, 0, 0.5);\n}\n\nh1 {\n text-align: center;\n color: #ffffff;\n text-shadow: 2px 2px 4px rgba(0, 0, 0, 0.5);\n}\n\nform {\n display: flex;\n flex-direction: column;\n gap: 10px;\n}\n\ninput, select, textarea {\n padding: 10px;\n border-radius: 5px;\n border: none;\n background-color: rgba(255, 255, 255, 0.3);\n color: white;\n}\n\ninput::placeholder, select::placeholder, textarea::placeholder {\n color: rgba(255, 255, 255, 0.7);\n}\n\n.employee-select {\n display: flex;\n flex-direction: column;\n gap: 5px;\n}\n\n.employee-select input {\n margin-bottom: 5px;\n}\n\nselect {\n appearance: none;\n -webkit-appearance: none;\n -moz-appearance: none;\n background-image: url(\"data:image/svg+xml;utf8,\");\n background-repeat: no-repeat;\n background-position-x: 98%;\n background-position-y: 50%;\n padding-right: 30px;\n}\n\nselect option {\n background-color: #333;\n color: white;\n}\n\nbutton {\n padding: 10px;\n background-color: #4CAF50;\n color: white;\n border: none;\n border-radius: 5px;\n cursor: pointer;\n transition: background-color 0.3s ease;\n}\n\nbutton:hover {\n background-color: #45a049;\n}\n\n.analytics {\n margin-top: 20px;\n padding: 20px;\n background-color: rgba(255, 255, 255, 0.1);\n border-radius: 5px;\n}\n\n.analytics-header {\n display: flex;\n justify-content: space-between;\n align-items: center;\n margin-bottom: 20px;\n}\n\n.delete-button {\n background-color: #f44336;\n}\n\n.delete-button:hover {\n background-color: #d32f2f;\n}\n\n.logo {\n text-align: center;\n font-size: 24px;\n font-weight: bold;\n margin-top: 20px;\n color: #ffffff;\n text-shadow: 2px 2px 4px rgba(0, 0, 0, 0.5);\n}\n\n.admin-input:-webkit-autofill,\n.admin-input:-webkit-autofill:hover,\n.admin-input:-webkit-autofill:focus,\n.admin-input:-webkit-autofill:active {\n -webkit-box-shadow: 0 0 0 30px rgba(255, 255, 255, 0.3) inset !important;\n -webkit-text-fill-color: white !important;\n}\n\n.button-spacer {\n height: 10px;\n}\n`;","deleted","label",[99],"permalink","https://www.val.town/x/Bernard_Lori/ValueAward/code/main.tsx","extension","actionData","errors"]