\n setSearchTerm(e.target.value)}\n className=\"search-input\"\n />\n setFilters(prev => ({...prev, category: e.target.value}))}\n >\n \n \n \n \n \n setFilters(prev => ({...prev, toolType: e.target.value}))}\n >\n \n \n \n \n \n setFilters(prev => ({...prev, minRating: parseInt(e.target.value)}))}\n >\n \n \n \n \n \n

\n {filteredTools.map((tool) => (\n

{tool.name}

{tool.description}

\n 🏷️ {tool.category}\n 💻 {tool.toolType}\n ⭐ {tool.rating}/5\n

\n \n Visit 🌐\n \n \n

\n ))}\n

\n );\n}\n\nfunction App() {\n const [refreshTools, setRefreshTools] = useState(0);\n\n const handleToolAdded = () => {\n setRefreshTools(prev => prev + 1);\n };\n\n return (\n

🔍 Arthur Source File

Catalog of Useful Tools and Websites

\n \n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n // Retrieve environment variables from Val Town's environment\n const SHEET_ID = Deno.env.get('VITE_GOOGLE_SHEET_ID') || '';\n const API_KEY = Deno.env.get('VITE_GOOGLE_SHEETS_API_KEY') || '';\n\n const url = new URL(request.url);\n\n // Google Sheets API endpoint\n const SHEETS_API_BASE = `https://sheets.googleapis.com/v4/spreadsheets/${SHEET_ID}/values`;\n\n // Validate environment variables\n if (!SHEET_ID || !API_KEY) {\n return new Response(JSON.stringify({ \n error: 'Google Sheets configuration is missing' \n }), {\n status: 500,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n if (request.method === 'POST' && url.pathname === '/add-tool') {\n const toolData = await request.json();\n \n try {\n const response = await fetch(\n `${SHEETS_API_BASE}/Sheet1!A:J?key=${API_KEY}`, \n {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json'\n },\n body: JSON.stringify({\n values: [Object.values(toolData)]\n })\n }\n );\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { 'Content-Type': 'application/json' }\n });\n } catch (error) {\n return new Response(JSON.stringify({ error: error.message }), {\n status: 500,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n }\n\n if (request.method === 'GET' && url.pathname === '/get-tools') {\n try {\n const response = await fetch(\n `${SHEETS_API_BASE}/Sheet1!A:J?key=${API_KEY}`\n );\n const data = await response.json();\n \n // Convert rows to objects, skipping header row\n const tools = data.values.slice(1).map((row, index) => ({\n id: index,\n name: row[0],\n link: row[1],\n description: row[2],\n rating: row[3],\n notes: row[4],\n category: row[5],\n toolType: row[6],\n dateAdded: row[7],\n userComment: row[8],\n userEmail: row[9]\n }));\n\n return new Response(JSON.stringify(tools), {\n headers: { 'Content-Type': 'application/json' }\n });\n } catch (error) {\n return new Response(JSON.stringify({ error: error.message }), {\n status: 500,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n }\n\n if (request.method === 'DELETE' && url.pathname.startsWith('/delete-tool/')) {\n // Note: Actual deletion would require more complex Google Sheets API interaction\n return new Response(JSON.stringify({ success: true }), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n // Main page render\n return new Response(`\n \n \n Arthur Source File\n \n \n \n \n \n

\n \n \n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\n });\n}\n\nconst css = `\n/* CSS remains unchanged from previous version */\n`;","deleted","label",[99],"permalink","https://www.val.town/x/pastoreekahk96/jobPostChatApp/code/main.tsx","extension","actionData","errors"]

🔧 Add New Tool

{tool.name}