\n \n\n",[18,66],"3bafd5e0-3fb4-11f0-b34a-76b3cceeab13",["D",1748870377639],[18,90],"pulls","branches",1,"forks","envVars",{"_192":26,"_194":26},"connections",{"_192":26,"_193":26},"count","unfilledCount","emptyCount",{"_35":363,"_13":317,"_64":310,"_45":-5,"_37":38,"_164":359,"_165":24,"_39":364,"_41":26,"_67":91,"_167":-5,"_68":30,"_168":-5,"_222":365,"_17":366},{"_35":358,"_13":349,"_64":343,"_45":310,"_37":38,"_164":359,"_165":24,"_39":360,"_41":26,"_67":91,"_167":-5,"_68":30,"_168":-5,"_222":361,"_17":362},{"_35":350,"_13":351,"_64":352,"_45":343,"_37":38,"_164":353,"_165":24,"_39":354,"_41":186,"_67":81,"_167":355,"_68":30,"_168":-5,"_222":356,"_17":357},{"_35":340,"_13":341,"_64":342,"_45":343,"_37":38,"_164":344,"_165":24,"_39":345,"_41":186,"_67":81,"_167":346,"_68":30,"_168":-5,"_222":347,"_17":348},{"_35":336,"_13":327,"_64":321,"_45":310,"_37":38,"_164":322,"_165":24,"_39":337,"_41":26,"_67":91,"_167":-5,"_68":30,"_168":-5,"_222":338,"_17":339},{"_35":328,"_13":329,"_64":330,"_45":321,"_37":38,"_164":331,"_165":24,"_39":332,"_41":26,"_67":81,"_167":333,"_68":30,"_168":-5,"_222":334,"_17":335},{"_35":318,"_13":319,"_64":320,"_45":321,"_37":38,"_164":322,"_165":24,"_39":323,"_41":26,"_67":81,"_167":324,"_68":30,"_168":-5,"_222":325,"_17":326},{"_35":308,"_13":309,"_64":104,"_45":310,"_37":38,"_164":311,"_165":24,"_39":312,"_41":236,"_67":313,"_167":314,"_68":30,"_168":-5,"_222":315,"_17":316},{"_35":163,"_13":18,"_64":92,"_45":-5,"_37":38,"_164":42,"_165":24,"_39":305,"_41":26,"_67":91,"_167":-5,"_68":30,"_168":-5,"_222":306,"_17":307},{"_35":181,"_13":90,"_64":89,"_45":92,"_37":38,"_164":84,"_165":24,"_39":302,"_41":26,"_67":91,"_167":-5,"_68":30,"_168":-5,"_222":303,"_17":304},{"_35":294,"_13":295,"_64":296,"_45":89,"_37":38,"_164":297,"_165":24,"_39":298,"_41":186,"_67":81,"_167":299,"_68":30,"_168":-5,"_222":300,"_17":301},{"_35":286,"_13":287,"_64":288,"_45":89,"_37":38,"_164":289,"_165":24,"_39":290,"_41":26,"_67":81,"_167":291,"_68":30,"_168":-5,"_222":292,"_17":293},{"_35":278,"_13":279,"_64":280,"_45":89,"_37":38,"_164":281,"_165":24,"_39":282,"_41":26,"_67":81,"_167":283,"_68":30,"_168":-5,"_222":284,"_17":285},{"_35":270,"_13":271,"_64":272,"_45":89,"_37":38,"_164":273,"_165":24,"_39":274,"_41":26,"_67":81,"_167":275,"_68":30,"_168":-5,"_222":276,"_17":277},{"_35":262,"_13":263,"_64":264,"_45":89,"_37":38,"_164":265,"_165":24,"_39":266,"_41":26,"_67":81,"_167":267,"_68":30,"_168":-5,"_222":268,"_17":269},{"_35":254,"_13":255,"_64":256,"_45":89,"_37":38,"_164":257,"_165":24,"_39":258,"_41":26,"_67":81,"_167":259,"_68":30,"_168":-5,"_222":260,"_17":261},{"_35":246,"_13":247,"_64":248,"_45":89,"_37":38,"_164":249,"_165":24,"_39":250,"_41":26,"_67":81,"_167":251,"_68":30,"_168":-5,"_222":252,"_17":253},{"_35":177,"_13":66,"_64":65,"_45":92,"_37":38,"_164":42,"_165":24,"_39":243,"_41":26,"_67":21,"_167":179,"_68":30,"_168":-5,"_222":244,"_17":245},{"_35":173,"_13":80,"_64":79,"_45":92,"_37":38,"_164":74,"_165":24,"_39":240,"_41":26,"_67":81,"_167":175,"_68":30,"_168":-5,"_222":241,"_17":242},{"_35":235,"_13":234,"_64":228,"_45":-5,"_37":38,"_164":236,"_165":24,"_39":237,"_41":26,"_67":91,"_167":-5,"_68":30,"_168":-5,"_222":238,"_17":239},{"_35":225,"_13":226,"_64":227,"_45":228,"_37":38,"_164":229,"_165":24,"_39":230,"_41":186,"_67":81,"_167":231,"_68":30,"_168":-5,"_222":232,"_17":233},{"_35":217,"_13":218,"_64":219,"_45":-5,"_37":38,"_164":128,"_165":24,"_39":220,"_41":186,"_67":21,"_167":221,"_68":30,"_168":-5,"_222":223,"_17":224},"b4ebb63e-3fb6-11f0-89cd-76b3cceeab13","README.md","1e6d8798-3fb4-11f0-a2f9-76b3cceeab13",["D",1748871440034],"# Neighborhood Skill Exchange Platform\n\nA comprehensive platform for neighbors to create profiles, list their skills, and connect with each other for mutual help and support.\n\n## Features\n\n### User Profiles\n- Create detailed user profiles with bio, location, and contact information\n- Manage multiple skills per user\n- Organize skills by categories (Home & Garden, Technology, Cooking, etc.)\n- Toggle skills active/inactive status\n- View all neighbor profiles and their offerings\n\n### Skill Management\n- Add skills as either \"offers\" (things you can help with) or \"requests\" (things you need help with)\n- Categorize skills for better organization\n- Add descriptions to provide more context\n- Filter profiles by skill type (offers vs requests)\n\n### Legacy Support\n- Maintains backward compatibility with simple skill submissions\n- Quick submit option for one-off skill sharing\n\n## Project Structure\n\n- `backend/` - Hono API server with SQLite database\n - `routes/profiles.ts` - User profile and skill management endpoints\n - `routes/submissions.ts` - Legacy submission endpoints\n - `database/` - Database migrations and queries\n- `frontend/` - React frontend with profile management\n - `components/ProfileManager.tsx` - Profile creation and skill management\n - `components/ProfilesList.tsx` - Display all neighbor profiles\n - `components/ProfileForm.tsx` - Profile creation/editing form\n - `components/SkillForm.tsx` - Add new skills to profile\n- `shared/` - Shared types and utilities\n\n## API Endpoints\n\n### Profile Management\n- `POST /api/profiles` - Create or update user profile\n- `GET /api/profiles` - Get all user profiles\n- `GET /api/profiles/:userName` - Get specific user profile\n- `GET /api/profiles/:userName/skills` - Get user's skills\n\n### Skill Management\n- `POST /api/skills` - Add skill to user profile\n- `GET /api/skills` - Get all skills (with optional type filter)\n- `PATCH /api/skills/:skillId/toggle` - Toggle skill active status\n\n### Legacy Endpoints\n- `POST /api/submissions` - Create new submission\n- `GET /api/submissions` - Get all submissions\n\n## Usage\n\n### Creating a Profile\n1. Go to the \"User Profiles\" tab\n2. Enter your username and click \"Load Profile\"\n3. Click \"Create Profile\" if you don't have one\n4. Fill in your information (email, location, bio)\n5. Submit to create your profile\n\n### Adding Skills\n1. After creating a profile, use the \"Add New Skill\" form\n2. Enter skill name and select a category\n3. Choose whether you're offering help or requesting help\n4. Add a description for more context\n5. Submit to add the skill to your profile\n\n### Managing Your Skills\n- View all your skills in the \"Your Skills\" section\n- Toggle skills active/inactive as needed\n- Skills marked as inactive won't appear in the public listings\n\n### Browsing Neighbors\n- View all neighbor profiles in the right panel\n- Filter by \"Offers\" to see what help is available\n- Filter by \"Requests\" to see who needs help\n- Contact neighbors directly via their email if provided\n\n## Skill Categories\n\n- Home & Garden\n- Technology\n- Cooking & Food\n- Transportation\n- Childcare\n- Pet Care\n- Tutoring & Education\n- Arts & Crafts\n- Music & Entertainment\n- Health & Fitness\n- Business & Professional\n- Other","children",[],[218],"325a2782-3fb6-11f0-b1e2-76b3cceeab13","types.ts","20d59516-3fb4-11f0-9103-76b3cceeab13","fea8f9e5-33f1-4448-b5bc-d8ede9a97d99",13,["D",1748871220970],"export interface UserProfile {\n id?: number;\n userName: string;\n email?: string;\n bio?: string;\n location?: string;\n createdAt?: string;\n updatedAt?: string;\n}\n\nexport interface Skill {\n id?: number;\n userId: number;\n skillName: string;\n description?: string;\n category?: string;\n type: 'offer' | 'request';\n isActive: boolean;\n createdAt?: string;\n}\n\nexport interface CreateProfileRequest {\n userName: string;\n email?: string;\n bio?: string;\n location?: string;\n}\n\nexport interface CreateSkillRequest {\n userName: string;\n skillName: string;\n description?: string;\n category?: string;\n type: 'offer' | 'request';\n}\n\n// Legacy types for backward compatibility\nexport interface Submission {\n id?: number;\n userName: string;\n skill: string;\n type: 'offer' | 'request';\n createdAt?: string;\n}\n\nexport interface CreateSubmissionRequest {\n userName: string;\n skill: string;\n type: 'offer' | 'request';\n}",[],[234,226],"shared","20d59f52-3fb4-11f0-9103-76b3cceeab13",2,["D",1748870332585],[215],[234],["D",1748870368489],[],[18,80],["D",1748870363795],[],[18,66],"4db53d0c-3fb4-11f0-bc33-76b3cceeab13","SubmissionsList.tsx","4db53dac-3fb4-11f0-bc33-76b3cceeab13",11,["D",1748870407877],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { Submission } from \"../../shared/types.ts\";\n\ninterface SubmissionsListProps {\n submissions: Submission[];\n loading: boolean;\n}\n\nexport default function SubmissionsList({ submissions, loading }: SubmissionsListProps) {\n if (loading) {\n return (\n

\n Recent Submissions\n

Loading submissions...

\n );\n }\n\n return (\n

\n Recent Submissions\n

\n \n {submissions.length === 0 ? (\n

No submissions yet. Be the first to share your skill!

\n ) : (\n

\n {submissions.map((submission) => (\n \n

\n \n {submission.userName}\n \n \n {submission.type === 'offer' ? '💡 Offering' : '🙋 Requesting'}\n \n

\n {submission.skill}\n

\n {submission.createdAt && (\n

\n {new Date(submission.createdAt).toLocaleDateString()}\n

\n )}\n

\n ))}\n

\n )}\n \n );\n}",[],[18,90,247],"45c095ba-3fb4-11f0-8e1d-76b3cceeab13","SubmissionForm.tsx","45c09682-3fb4-11f0-8e1d-76b3cceeab13",10,["D",1748870394533],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { Submission, CreateSubmissionRequest } from \"../../shared/types.ts\";\n\ninterface SubmissionFormProps {\n onSubmissionCreated: (submission: Submission) => void;\n}\n\nexport default function SubmissionForm({ onSubmissionCreated }: SubmissionFormProps) {\n const [formData, setFormData] = useState({\n userName: \"\",\n skill: \"\",\n type: \"offer\"\n });\n const [isSubmitting, setIsSubmitting] = useState(false);\n const [error, setError] = useState(\"\");\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setError(\"\");\n setIsSubmitting(true);\n\n try {\n const response = await fetch(\"/api/submissions\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(formData),\n });\n\n if (response.ok) {\n const newSubmission = await response.json();\n onSubmissionCreated(newSubmission);\n setFormData({ userName: \"\", skill: \"\", type: \"offer\" });\n } else {\n const errorData = await response.json();\n setError(errorData.error || \"Failed to submit\");\n }\n } catch (error) {\n setError(\"Network error occurred\");\n } finally {\n setIsSubmitting(false);\n }\n };\n\n const handleInputChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({ ...prev, [name]: value }));\n };\n\n return (\n

\n Add Your Skill\n

\n \n

\n );\n}",[],[18,90,255],"733b706c-3fb6-11f0-a9a0-76b3cceeab13","SkillForm.tsx","733b7120-3fb6-11f0-a9a0-76b3cceeab13",19,["D",1748871329827],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { Skill, CreateSkillRequest } from \"../../shared/types.ts\";\n\ninterface SkillFormProps {\n userName: string;\n onSkillAdded: (skill: Skill) => void;\n}\n\nconst SKILL_CATEGORIES = [\n \"Home & Garden\",\n \"Technology\",\n \"Cooking & Food\",\n \"Transportation\",\n \"Childcare\",\n \"Pet Care\",\n \"Tutoring & Education\",\n \"Arts & Crafts\",\n \"Music & Entertainment\",\n \"Health & Fitness\",\n \"Business & Professional\",\n \"Other\"\n];\n\nexport default function SkillForm({ userName, onSkillAdded }: SkillFormProps) {\n const [formData, setFormData] = useState({\n userName,\n skillName: \"\",\n description: \"\",\n category: \"\",\n type: \"offer\",\n });\n const [isSubmitting, setIsSubmitting] = useState(false);\n const [error, setError] = useState(\"\");\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setIsSubmitting(true);\n setError(\"\");\n\n try {\n const response = await fetch(\"/api/skills\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(formData),\n });\n\n if (response.ok) {\n const skill = await response.json();\n onSkillAdded(skill);\n \n // Reset form\n setFormData({\n userName,\n skillName: \"\",\n description: \"\",\n category: \"\",\n type: \"offer\",\n });\n } else {\n const errorData = await response.json();\n setError(errorData.error || \"Failed to add skill\");\n }\n } catch (err) {\n setError(\"Network error occurred\");\n } finally {\n setIsSubmitting(false);\n }\n };\n\n const handleChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({\n ...prev,\n [name]: value,\n }));\n };\n\n return (\n

Add New Skill

\n \n {error && (\n

\n {error}\n

\n )}\n\n

\n );\n}",[],[18,90,263],"8696893a-3fb6-11f0-9c02-76b3cceeab13","ProfilesList.tsx","869689ee-3fb6-11f0-9c02-76b3cceeab13",20,["D",1748871362299],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { UserProfile, Skill } from \"../../shared/types.ts\";\n\ninterface ProfilesListProps {\n refreshTrigger?: number;\n}\n\ninterface ProfileWithSkills extends UserProfile {\n skills: (Skill & { userName: string })[];\n}\n\nexport default function ProfilesList({ refreshTrigger }: ProfilesListProps) {\n const [profiles, setProfiles] = useState([]);\n const [loading, setLoading] = useState(true);\n const [filter, setFilter] = useState<'all' | 'offer' | 'request'>('all');\n\n const fetchProfilesAndSkills = async () => {\n try {\n setLoading(true);\n \n // Fetch all profiles and skills in parallel\n const [profilesResponse, skillsResponse] = await Promise.all([\n fetch(\"/api/profiles\"),\n fetch(\"/api/skills\")\n ]);\n\n if (profilesResponse.ok && skillsResponse.ok) {\n const profilesData = await profilesResponse.json();\n const skillsData = await skillsResponse.json();\n\n // Group skills by user\n const skillsByUser = skillsData.reduce((acc: Record, skill: Skill & { userName: string }) => {\n if (!acc[skill.userName]) {\n acc[skill.userName] = [];\n }\n acc[skill.userName].push(skill);\n return acc;\n }, {});\n\n // Combine profiles with their skills\n const profilesWithSkills = profilesData.map((profile: UserProfile) => ({\n ...profile,\n skills: skillsByUser[profile.userName] || []\n }));\n\n setProfiles(profilesWithSkills);\n }\n } catch (error) {\n console.error(\"Error fetching profiles and skills:\", error);\n } finally {\n setLoading(false);\n }\n };\n\n useEffect(() => {\n fetchProfilesAndSkills();\n }, [refreshTrigger]);\n\n const filteredProfiles = profiles.filter(profile => {\n if (filter === 'all') return profile.skills.length > 0;\n return profile.skills.some(skill => skill.type === filter);\n });\n\n if (loading) {\n return (\n

\n );\n }\n\n return (\n

\n Neighbor Profiles ({filteredProfiles.length})\n

\n \n

\n setFilter('all')}\n className={`px-3 py-1 rounded-full text-sm font-medium ${\n filter === 'all' \n ? 'bg-gray-800 text-white' \n : 'bg-gray-200 text-gray-700 hover:bg-gray-300'\n }`}\n >\n All\n \n setFilter('offer')}\n className={`px-3 py-1 rounded-full text-sm font-medium ${\n filter === 'offer' \n ? 'bg-green-600 text-white' \n : 'bg-green-100 text-green-700 hover:bg-green-200'\n }`}\n >\n 🤝 Offers\n \n setFilter('request')}\n className={`px-3 py-1 rounded-full text-sm font-medium ${\n filter === 'request' \n ? 'bg-blue-600 text-white' \n : 'bg-blue-100 text-blue-700 hover:bg-blue-200'\n }`}\n >\n 🙋 Requests\n \n

\n\n {filteredProfiles.length === 0 ? (\n

No profiles found

Be the first to create a profile and add your skills!

\n ) : (\n

\n {filteredProfiles.map((profile) => (\n

\n {profile.userName}\n

\n {profile.location && (\n

📍 {profile.location}

\n )}\n

\n {profile.email && (\n \n ✉️ Contact\n \n )}\n

\n\n {profile.bio && (\n

{profile.bio}

\n )}\n\n

\n {profile.skills\n .filter(skill => filter === 'all' || skill.type === filter)\n .map((skill) => (\n \n \n {skill.type === 'offer' ? '🤝' : '🙋'} {skill.skillName}\n \n {skill.category && (\n \n ({skill.category})\n \n )}\n {skill.description && (\n

\n {skill.description}\n

\n )}\n

\n ))}\n

\n\n

\n Member since {new Date(profile.createdAt!).toLocaleDateString()}\n

\n ))}\n

\n )}\n \n );\n}",[],[18,90,271],"9b0ae71c-3fb6-11f0-861e-76b3cceeab13","ProfileManager.tsx","9b0ae7ee-3fb6-11f0-861e-76b3cceeab13",21,["D",1748871396620],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport ProfileForm from \"./ProfileForm.tsx\";\nimport SkillForm from \"./SkillForm.tsx\";\nimport type { UserProfile, Skill } from \"../../shared/types.ts\";\n\ninterface ProfileManagerProps {\n onProfileUpdate: () => void;\n}\n\nexport default function ProfileManager({ onProfileUpdate }: ProfileManagerProps) {\n const [currentUser, setCurrentUser] = useState(\"\");\n const [userProfile, setUserProfile] = useState(null);\n const [userSkills, setUserSkills] = useState([]);\n const [showProfileForm, setShowProfileForm] = useState(false);\n const [loading, setLoading] = useState(false);\n\n const fetchUserData = async (userName: string) => {\n if (!userName.trim()) return;\n \n setLoading(true);\n try {\n // Fetch profile and skills in parallel\n const [profileResponse, skillsResponse] = await Promise.all([\n fetch(`/api/profiles/${userName}`),\n fetch(`/api/profiles/${userName}/skills`)\n ]);\n\n if (profileResponse.ok) {\n const profile = await profileResponse.json();\n setUserProfile(profile);\n } else {\n setUserProfile(null);\n }\n\n if (skillsResponse.ok) {\n const skills = await skillsResponse.json();\n setUserSkills(skills);\n } else {\n setUserSkills([]);\n }\n } catch (error) {\n console.error(\"Error fetching user data:\", error);\n setUserProfile(null);\n setUserSkills([]);\n } finally {\n setLoading(false);\n }\n };\n\n const handleUserNameSubmit = (e: React.FormEvent) => {\n e.preventDefault();\n if (currentUser.trim()) {\n fetchUserData(currentUser.trim());\n }\n };\n\n const handleProfileCreated = (profile: UserProfile) => {\n setUserProfile(profile);\n setShowProfileForm(false);\n onProfileUpdate();\n };\n\n const handleSkillAdded = (skill: Skill) => {\n setUserSkills(prev => [skill, ...prev]);\n onProfileUpdate();\n };\n\n const toggleSkillStatus = async (skillId: number, isActive: boolean) => {\n try {\n const response = await fetch(`/api/skills/${skillId}/toggle`, {\n method: \"PATCH\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ isActive }),\n });\n\n if (response.ok) {\n setUserSkills(prev => \n prev.map(skill => \n skill.id === skillId ? { ...skill, isActive } : skill\n )\n );\n onProfileUpdate();\n }\n } catch (error) {\n console.error(\"Error toggling skill status:\", error);\n }\n };\n\n return (\n

\n {/* User Selection */}\n

Manage Your Profile

\n \n

\n\n {/* Profile Management */}\n {currentUser && (\n <>\n {/* Profile Section */}\n

Profile Information

\n setShowProfileForm(!showProfileForm)}\n className=\"bg-gray-600 text-white px-4 py-2 rounded-md hover:bg-gray-700 text-sm\"\n >\n {userProfile ? \"Edit Profile\" : \"Create Profile\"}\n \n

\n\n {userProfile && !showProfileForm ? (\n

Username: {userProfile.userName}

\n {userProfile.email &&

Email: {userProfile.email}

}\n {userProfile.location &&

Location: {userProfile.location}

}\n {userProfile.bio &&

Bio: {userProfile.bio}

}\n

\n Created: {new Date(userProfile.createdAt!).toLocaleDateString()}\n

\n ) : showProfileForm ? (\n \n ) : (\n

No profile found. Create one to get started!

\n )}\n

\n\n {/* Skills Management */}\n {userProfile && (\n <>\n \n\n {/* User's Skills List */}\n

\n Your Skills ({userSkills.length})\n

\n\n {userSkills.length === 0 ? (\n

No skills added yet. Add your first skill above!

\n ) : (\n

\n {userSkills.map((skill) => (\n \n

\n \n {skill.type === 'offer' ? '🤝 Offering' : '🙋 Requesting'}\n \n {skill.category && (\n \n {skill.category}\n \n )}\n

{skill.skillName}

\n {skill.description && (\n

{skill.description}

\n )}\n

\n Added: {new Date(skill.createdAt!).toLocaleDateString()}\n

\n \n toggleSkillStatus(skill.id!, !skill.isActive)}\n className={`ml-4 px-3 py-1 rounded text-sm font-medium ${\n skill.isActive\n ? 'bg-red-100 text-red-700 hover:bg-red-200'\n : 'bg-green-100 text-green-700 hover:bg-green-200'\n }`}\n >\n {skill.isActive ? 'Deactivate' : 'Activate'}\n \n

\n ))}\n

\n )}\n

\n \n )}\n \n )}\n \n );\n}",[],[18,90,279],"65caf394-3fb6-11f0-a44c-76b3cceeab13","ProfileForm.tsx","65caf45c-3fb6-11f0-a44c-76b3cceeab13",18,["D",1748871307281],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { UserProfile, CreateProfileRequest } from \"../../shared/types.ts\";\n\ninterface ProfileFormProps {\n onProfileCreated: (profile: UserProfile) => void;\n existingProfile?: UserProfile | null;\n}\n\nexport default function ProfileForm({ onProfileCreated, existingProfile }: ProfileFormProps) {\n const [formData, setFormData] = useState({\n userName: existingProfile?.userName || \"\",\n email: existingProfile?.email || \"\",\n bio: existingProfile?.bio || \"\",\n location: existingProfile?.location || \"\",\n });\n const [isSubmitting, setIsSubmitting] = useState(false);\n const [error, setError] = useState(\"\");\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setIsSubmitting(true);\n setError(\"\");\n\n try {\n const response = await fetch(\"/api/profiles\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(formData),\n });\n\n if (response.ok) {\n const profile = await response.json();\n onProfileCreated(profile);\n \n // Only reset form if creating new profile\n if (!existingProfile) {\n setFormData({\n userName: \"\",\n email: \"\",\n bio: \"\",\n location: \"\",\n });\n }\n } else {\n const errorData = await response.json();\n setError(errorData.error || \"Failed to save profile\");\n }\n } catch (err) {\n setError(\"Network error occurred\");\n } finally {\n setIsSubmitting(false);\n }\n };\n\n const handleChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({\n ...prev,\n [name]: value,\n }));\n };\n\n return (\n

\n {existingProfile ? \"Update Profile\" : \"Create Profile\"}\n

\n \n {error && (\n

\n {error}\n

\n )}\n\n

\n );\n}",[],[18,90,287],"a8bd1272-3fb6-11f0-8b22-76b3cceeab13","App.tsx","3bafcf1e-3fb4-11f0-b34a-76b3cceeab13",22,["D",1748871419596],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport SubmissionForm from \"./SubmissionForm.tsx\";\nimport SubmissionsList from \"./SubmissionsList.tsx\";\nimport ProfileManager from \"./ProfileManager.tsx\";\nimport ProfilesList from \"./ProfilesList.tsx\";\nimport type { Submission } from \"../../shared/types.ts\";\n\nexport default function App() {\n const [submissions, setSubmissions] = useState([]);\n const [loading, setLoading] = useState(true);\n const [activeTab, setActiveTab] = useState<'profiles' | 'legacy'>('profiles');\n const [refreshTrigger, setRefreshTrigger] = useState(0);\n\n const fetchSubmissions = async () => {\n try {\n const response = await fetch(\"/api/submissions\");\n if (response.ok) {\n const data = await response.json();\n setSubmissions(data);\n }\n } catch (error) {\n console.error(\"Error fetching submissions:\", error);\n } finally {\n setLoading(false);\n }\n };\n\n useEffect(() => {\n fetchSubmissions();\n }, []);\n\n const handleSubmissionCreated = (newSubmission: Submission) => {\n setSubmissions(prev => [newSubmission, ...prev]);\n };\n\n const handleProfileUpdate = () => {\n setRefreshTrigger(prev => prev + 1);\n };\n\n return (\n

\n 🏘️ Neighborhood Skill Exchange\n

\n Connect with neighbors to share skills and help each other\n

\n\n {/* Tab Navigation */}\n

\n setActiveTab('profiles')}\n className={`px-6 py-2 rounded-md font-medium transition-colors ${\n activeTab === 'profiles'\n ? 'bg-white text-blue-600 shadow-sm'\n : 'text-gray-600 hover:text-gray-800'\n }`}\n >\n 👥 User Profiles\n \n setActiveTab('legacy')}\n className={`px-6 py-2 rounded-md font-medium transition-colors ${\n activeTab === 'legacy'\n ? 'bg-white text-blue-600 shadow-sm'\n : 'text-gray-600 hover:text-gray-800'\n }`}\n >\n 📝 Quick Submit\n \n

\n\n {activeTab === 'profiles' ? (\n

\n \n

\n ) : (\n

\n \n

\n )}\n

\n );\n}",[],[18,90,295],["D",1748870377639],[205,206,207,208,209,210,211],[18,90],["D",1748870363795],[204,212,213],[18],"5938a162-3fb6-11f0-9427-76b3cceeab13","index.ts","9ff999fb-9a43-4cca-ae31-aa092077a53c",17,["D",1748871286183],"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { createTables } from \"./database/migrations.ts\";\nimport submissionsRouter from \"./routes/submissions.ts\";\nimport profilesRouter from \"./routes/profiles.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database\nawait createTables();\n\n// API routes\napp.route(\"/api/submissions\", submissionsRouter);\napp.route(\"/api\", profilesRouter);\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve main page\napp.get(\"/\", async (c) => {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\nexport default app.fetch;",[],[317,309],"backend","2c178e3e-3fb4-11f0-89cd-76b3cceeab13","submissions.ts","2c179000-3fb4-11f0-89cd-76b3cceeab13","36fbd25c-53cf-47ae-b59a-61818f9edbef",5,["D",1748870351480],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { createSubmission, getAllSubmissions } from \"../database/queries.ts\";\nimport type { CreateSubmissionRequest } from \"../../shared/types.ts\";\n\nconst app = new Hono();\n\n// Get all submissions\napp.get(\"/\", async (c) => {\n try {\n const submissions = await getAllSubmissions();\n return c.json(submissions);\n } catch (error) {\n console.error(\"Error fetching submissions:\", error);\n return c.json({ error: \"Failed to fetch submissions\" }, 500);\n }\n});\n\n// Create new submission\napp.post(\"/\", async (c) => {\n try {\n const body = await c.req.json() as CreateSubmissionRequest;\n \n // Validate required fields\n if (!body.userName || !body.skill || !body.type) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n \n if (body.type !== 'offer' && body.type !== 'request') {\n return c.json({ error: \"Type must be 'offer' or 'request'\" }, 400);\n }\n \n const submission = await createSubmission(body);\n return c.json(submission, 201);\n } catch (error) {\n console.error(\"Error creating submission:\", error);\n return c.json({ error: \"Failed to create submission\" }, 500);\n }\n});\n\nexport default app;",[],[317,327,319],"routes","50a0eadc-3fb6-11f0-96a3-76b3cceeab13","profiles.ts","50a0eb90-3fb6-11f0-96a3-76b3cceeab13",16,["D",1748871271774],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n createOrUpdateProfile, \n getUserProfile, \n getAllProfiles,\n addSkillToProfile,\n getUserSkills,\n getAllSkills,\n getSkillsByType,\n toggleSkillStatus\n} from \"../database/queries.ts\";\nimport type { CreateProfileRequest, CreateSkillRequest } from \"../../shared/types.ts\";\n\nconst app = new Hono();\n\n// Profile routes\napp.post(\"/profiles\", async (c) => {\n try {\n const data: CreateProfileRequest = await c.req.json();\n \n if (!data.userName?.trim()) {\n return c.json({ error: \"Username is required\" }, 400);\n }\n\n const profile = await createOrUpdateProfile(data);\n return c.json(profile);\n } catch (error) {\n console.error(\"Error creating/updating profile:\", error);\n return c.json({ error: \"Failed to create/update profile\" }, 500);\n }\n});\n\napp.get(\"/profiles/:userName\", async (c) => {\n try {\n const userName = c.req.param(\"userName\");\n const profile = await getUserProfile(userName);\n \n if (!profile) {\n return c.json({ error: \"Profile not found\" }, 404);\n }\n \n return c.json(profile);\n } catch (error) {\n console.error(\"Error fetching profile:\", error);\n return c.json({ error: \"Failed to fetch profile\" }, 500);\n }\n});\n\napp.get(\"/profiles\", async (c) => {\n try {\n const profiles = await getAllProfiles();\n return c.json(profiles);\n } catch (error) {\n console.error(\"Error fetching profiles:\", error);\n return c.json({ error: \"Failed to fetch profiles\" }, 500);\n }\n});\n\n// Skill routes\napp.post(\"/skills\", async (c) => {\n try {\n const data: CreateSkillRequest = await c.req.json();\n \n if (!data.userName?.trim() || !data.skillName?.trim()) {\n return c.json({ error: \"Username and skill name are required\" }, 400);\n }\n\n const skill = await addSkillToProfile(data);\n return c.json(skill);\n } catch (error) {\n console.error(\"Error adding skill:\", error);\n return c.json({ error: \"Failed to add skill\" }, 500);\n }\n});\n\napp.get(\"/skills\", async (c) => {\n try {\n const type = c.req.query(\"type\") as 'offer' | 'request' | undefined;\n \n if (type && !['offer', 'request'].includes(type)) {\n return c.json({ error: \"Invalid type parameter\" }, 400);\n }\n\n const skills = type ? await getSkillsByType(type) : await getAllSkills();\n return c.json(skills);\n } catch (error) {\n console.error(\"Error fetching skills:\", error);\n return c.json({ error: \"Failed to fetch skills\" }, 500);\n }\n});\n\napp.get(\"/profiles/:userName/skills\", async (c) => {\n try {\n const userName = c.req.param(\"userName\");\n const skills = await getUserSkills(userName);\n return c.json(skills);\n } catch (error) {\n console.error(\"Error fetching user skills:\", error);\n return c.json({ error: \"Failed to fetch user skills\" }, 500);\n }\n});\n\napp.patch(\"/skills/:skillId/toggle\", async (c) => {\n try {\n const skillId = parseInt(c.req.param(\"skillId\"));\n const { isActive } = await c.req.json();\n \n if (isNaN(skillId)) {\n return c.json({ error: \"Invalid skill ID\" }, 400);\n }\n\n await toggleSkillStatus(skillId, isActive);\n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error toggling skill status:\", error);\n return c.json({ error: \"Failed to toggle skill status\" }, 500);\n }\n});\n\nexport default app;",[],[317,327,329],"2c1799f6-3fb4-11f0-89cd-76b3cceeab13",["D",1748870351480],[200,201],[317,327],"470079c0-3fb6-11f0-8f9c-76b3cceeab13","queries.ts","27536d14-3fb4-11f0-899e-76b3cceeab13","eb87c3dd-108a-4423-8f53-b6674d5c7dc4",15,["D",1748871255620],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { USERS_TABLE, SKILLS_TABLE, LEGACY_TABLE } from \"./migrations.ts\";\nimport type { \n UserProfile, \n Skill, \n CreateProfileRequest, \n CreateSkillRequest,\n Submission, \n CreateSubmissionRequest \n} from \"../../shared/types.ts\";\n\n// User Profile Functions\nexport async function createOrUpdateProfile(data: CreateProfileRequest): Promise {\n // Try to update existing profile first\n const existingUser = await getUserProfile(data.userName);\n \n if (existingUser) {\n const result = await sqlite.execute(\n `UPDATE ${USERS_TABLE} \n SET email = ?, bio = ?, location = ?, updatedAt = CURRENT_TIMESTAMP \n WHERE userName = ? \n RETURNING *`,\n [data.email || null, data.bio || null, data.location || null, data.userName]\n );\n return result.rows[0] as UserProfile;\n } else {\n const result = await sqlite.execute(\n `INSERT INTO ${USERS_TABLE} (userName, email, bio, location) \n VALUES (?, ?, ?, ?) \n RETURNING *`,\n [data.userName, data.email || null, data.bio || null, data.location || null]\n );\n return result.rows[0] as UserProfile;\n }\n}\n\nexport async function getUserProfile(userName: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${USERS_TABLE} WHERE userName = ?`,\n [userName]\n );\n \n return result.rows.length > 0 ? result.rows[0] as UserProfile : null;\n}\n\nexport async function getAllProfiles(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${USERS_TABLE} ORDER BY createdAt DESC`\n );\n \n return result.rows as UserProfile[];\n}\n\n// Skill Functions\nexport async function addSkillToProfile(data: CreateSkillRequest): Promise {\n // Get or create user profile\n let user = await getUserProfile(data.userName);\n if (!user) {\n user = await createOrUpdateProfile({ userName: data.userName });\n }\n\n const result = await sqlite.execute(\n `INSERT INTO ${SKILLS_TABLE} (userId, skillName, description, category, type) \n VALUES (?, ?, ?, ?, ?) \n RETURNING *`,\n [user.id, data.skillName, data.description || null, data.category || null, data.type]\n );\n \n return result.rows[0] as Skill;\n}\n\nexport async function getUserSkills(userName: string): Promise {\n const result = await sqlite.execute(\n `SELECT s.* FROM ${SKILLS_TABLE} s \n JOIN ${USERS_TABLE} u ON s.userId = u.id \n WHERE u.userName = ? AND s.isActive = 1 \n ORDER BY s.createdAt DESC`,\n [userName]\n );\n \n return result.rows as Skill[];\n}\n\nexport async function getAllSkills(): Promise<(Skill & { userName: string })[]> {\n const result = await sqlite.execute(\n `SELECT s.*, u.userName FROM ${SKILLS_TABLE} s \n JOIN ${USERS_TABLE} u ON s.userId = u.id \n WHERE s.isActive = 1 \n ORDER BY s.createdAt DESC`\n );\n \n return result.rows as (Skill & { userName: string })[];\n}\n\nexport async function getSkillsByType(type: 'offer' | 'request'): Promise<(Skill & { userName: string })[]> {\n const result = await sqlite.execute(\n `SELECT s.*, u.userName FROM ${SKILLS_TABLE} s \n JOIN ${USERS_TABLE} u ON s.userId = u.id \n WHERE s.type = ? AND s.isActive = 1 \n ORDER BY s.createdAt DESC`,\n [type]\n );\n \n return result.rows as (Skill & { userName: string })[];\n}\n\nexport async function toggleSkillStatus(skillId: number, isActive: boolean): Promise {\n await sqlite.execute(\n `UPDATE ${SKILLS_TABLE} SET isActive = ? WHERE id = ?`,\n [isActive ? 1 : 0, skillId]\n );\n}\n\n// Legacy Functions (for backward compatibility)\nexport async function createSubmission(data: CreateSubmissionRequest): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${LEGACY_TABLE} (userName, skill, type) VALUES (?, ?, ?) RETURNING *`,\n [data.userName, data.skill, data.type]\n );\n \n return result.rows[0] as Submission;\n}\n\nexport async function getAllSubmissions(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${LEGACY_TABLE} ORDER BY createdAt DESC`\n );\n \n return result.rows as Submission[];\n}",[],[317,349,341],"database","398595fa-3fb6-11f0-8a23-76b3cceeab13","migrations.ts","2424fbda-3fb4-11f0-8c9f-76b3cceeab13",14,["D",1748871233001],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst USERS_TABLE = 'user_profiles';\nconst SKILLS_TABLE = 'user_skills';\nconst LEGACY_TABLE = 'skill_submissions';\n\nexport async function createTables() {\n // Create user profiles table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${USERS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n userName TEXT UNIQUE NOT NULL,\n email TEXT,\n bio TEXT,\n location TEXT,\n createdAt DATETIME DEFAULT CURRENT_TIMESTAMP,\n updatedAt DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Create user skills table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${SKILLS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n userId INTEGER NOT NULL,\n skillName TEXT NOT NULL,\n description TEXT,\n category TEXT,\n type TEXT NOT NULL CHECK (type IN ('offer', 'request')),\n isActive BOOLEAN DEFAULT 1,\n createdAt DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (userId) REFERENCES ${USERS_TABLE}(id) ON DELETE CASCADE\n )`);\n\n // Keep legacy table for backward compatibility\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${LEGACY_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n userName TEXT NOT NULL,\n skill TEXT NOT NULL,\n type TEXT NOT NULL CHECK (type IN ('offer', 'request')),\n createdAt DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Create indexes for better performance\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_skills_user ON ${SKILLS_TABLE}(userId)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_skills_type ON ${SKILLS_TABLE}(type)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_skills_active ON ${SKILLS_TABLE}(isActive)`);\n}\n\nexport { USERS_TABLE, SKILLS_TABLE, LEGACY_TABLE };",[],[317,349,351],"242504ae-3fb4-11f0-8c9f-76b3cceeab13",3,["D",1748870338148],[197,198],[317,349],"24250224-3fb4-11f0-8c9f-76b3cceeab13",["D",1748870338148],[196,199,202],[317],["D",1748870290080],{"_11":12,"_141":71},{"_11":12,"_137":-5,"_70":71,"_31":69,"_138":139,"_140":30},{"_41":128,"_13":16,"_35":38,"_129":94,"_130":-5,"_131":-5,"_132":-5,"_133":-5,"_134":-5,"_135":14,"_136":12},"ctx",{"_54":-5,"_160":404,"_405":406,"_407":408,"_409":30,"_410":30,"_411":30,"_412":24,"_413":-5,"_414":-7,"_415":-7,"_416":26,"_417":30,"_418":30,"_419":-5,"_420":30,"_421":30,"_422":30,"_423":-5},"ENV",{"_375":376,"_377":378,"_379":16,"_380":381,"_382":383,"_384":385,"_386":387,"_388":389,"_390":391,"_392":393,"_394":395,"_396":397,"_398":399,"_400":401,"_402":403},"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"]

History · frontend