\n \n \n \n \n \n \n\n",[],[165,167],"ecef1eca-316c-11f0-95c3-569c3dd06744",["D",1747300434974],"# Frontend\n\nThis directory contains the client-side code for the AI-based resume screening system.\n\n## Files\n\n- `index.html` - Main HTML template\n- `index.tsx` - Frontend entry point\n- `components/` - React components\n - `App.tsx` - Main application component\n - `ResumeUpload.tsx` - Resume upload component\n - `JobForm.tsx` - Job requirements input form\n - `Results.tsx` - Results display component\n\n## Technologies\n\n- React 18.2.0\n- TailwindCSS (via CDN)\n- TypeScript\n\n## Features\n\n- Resume text upload and parsing\n- Job requirement definition\n- Candidate scoring and ranking\n- Detailed result analysis\n- AI-generated feedback",[],[165,74],"98c2ff4c-316c-11f0-aa4d-569c3dd06744",["D",1747300293755],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"react\";\nimport type { Resume } from \"../../shared/types\";\n\ninterface ResumeUploadProps {\n onUpload: (resumeText: string) => Promise;\n resumes: Resume[];\n}\n\nconst ResumeUpload: React.FC = ({ onUpload, resumes }) => {\n const [resumeText, setResumeText] = useState(\"\");\n const [showExisting, setShowExisting] = useState(false);\n const [selectedResume, setSelectedResume] = useState(null);\n\n const handleSubmit = (e: React.FormEvent) => {\n e.preventDefault();\n if (resumeText.trim()) {\n onUpload(resumeText);\n }\n };\n\n const handleViewResume = (resume: Resume) => {\n setSelectedResume(resume);\n };\n\n const handleCloseModal = () => {\n setSelectedResume(null);\n };\n\n return (\n

Upload Resume

\n \n \n \n {resumes.length > 0 && (\n

Existing Resumes

\n setShowExisting(!showExisting)}\n className=\"text-blue-600 hover:text-blue-800\"\n >\n {showExisting ? \"Hide\" : \"Show\"} ({resumes.length})\n \n

\n \n {showExisting && (\n

\n \n \n \n \n \n \n \n \n \n \n \n {resumes.map((resume) => (\n \n \n \n \n \n \n \n ))}\n \n

\n Name\n	\n Email\n	\n Score\n	\n Date\n	\n Actions\n
\n \n {resume.candidateName}\n \n	\n {resume.email} \n	\n {resume.score ? (\n = 70 \n ? \"bg-green-100 text-green-800\" \n : resume.score >= 50 \n ? \"bg-yellow-100 text-yellow-800\" \n : \"bg-red-100 text-red-800\"\n }`}>\n {resume.score.toFixed(1)}\n \n ) : (\n Not scored\n )}\n	\n \n {new Date(resume.createdAt).toLocaleDateString()}\n \n	\n handleViewResume(resume)}\n className=\"text-blue-600 hover:text-blue-900\"\n >\n View\n \n

\n )}\n

\n )}\n \n {/* Resume View Modal */}\n {selectedResume && (\n

\n {selectedResume.candidateName}\n

\n \n ✕\n \n

\n \n

\n Email: {selectedResume.email}\n

\n {selectedResume.phone && (\n

\n Phone: {selectedResume.phone}\n

\n )}\n

\n \n {selectedResume.parsedData && (\n

Skills

\n {selectedResume.parsedData.skills.map((skill, index) => (\n \n {skill}\n \n ))}\n

\n \n {selectedResume.parsedData.summary && (\n

Summary

{selectedResume.parsedData.summary}

\n )}\n \n {selectedResume.parsedData.experience.length > 0 && (\n

Experience

\n {selectedResume.parsedData.experience.map((exp, index) => (\n

{exp.title}

\n \n {exp.startDate} - {exp.endDate || \"Present\"}\n \n

{exp.company}

{exp.description}

\n ))}\n

\n )}\n \n {selectedResume.parsedData.education.length > 0 && (\n

Education

\n {selectedResume.parsedData.education.map((edu, index) => (\n

{edu.institution}

\n {edu.graduationDate && (\n \n {edu.graduationDate}\n \n )}\n

\n {edu.degree}{edu.field ? ` in ${edu.field}` : \"\"}\n

\n ))}\n

\n )}\n

\n )}\n \n

Raw Resume Text

\n                {selectedResume.resumeText}\n

\n \n

\n \n Close\n \n

\n )}\n \n {/* Sample Resume */}\n

Sample Resume

\n You can use this sample resume to test the system:\n

\n setResumeText(sampleResume)}\n className=\"text-blue-600 hover:text-blue-800 mb-2\"\n >\n Load Sample Resume\n \n

{sampleResume.substring(0, 300)}...

\n );\n};\n\n// Sample resume for testing\nconst sampleResume = `JOHN SMITH\nSoftware Engineer\njohn.smith@example.com | (555) 123-4567 | linkedin.com/in/johnsmith\n\nSUMMARY\nExperienced software engineer with 5+ years of experience in full-stack development, specializing in React, Node.js, and cloud technologies. Passionate about building scalable applications and implementing machine learning solutions.\n\nSKILLS\nProgramming Languages: JavaScript, TypeScript, Python, Java\nFrontend: React, Redux, HTML5, CSS3, Tailwind CSS\nBackend: Node.js, Express, Django, Spring Boot\nDatabases: MongoDB, PostgreSQL, MySQL\nCloud & DevOps: AWS, Docker, Kubernetes, CI/CD\nMachine Learning: TensorFlow, scikit-learn, NLP\nTools: Git, JIRA, Figma\n\nEXPERIENCE\nSenior Software Engineer\nTechCorp Inc. | Jan 2021 - Present\n- Led the development of a customer-facing dashboard using React and TypeScript, improving user engagement by 35%\n- Implemented CI/CD pipelines using GitHub Actions, reducing deployment time by 60%\n- Designed and built RESTful APIs using Node.js and Express, handling 1M+ daily requests\n- Mentored junior developers and conducted code reviews to ensure code quality\n\nSoftware Engineer\nDataSystems LLC | Mar 2018 - Dec 2020\n- Developed microservices architecture using Node.js and Docker, improving system scalability\n- Created data visualization components with D3.js for real-time analytics dashboard\n- Implemented authentication system using JWT and OAuth2.0\n- Optimized database queries, reducing response time by 40%\n\nJunior Developer\nWebSolutions Co. | Jun 2016 - Feb 2018\n- Built responsive web applications using React and Redux\n- Collaborated with UX designers to implement user interface components\n- Participated in agile development process with bi-weekly sprints\n- Fixed bugs and implemented new features for existing applications\n\nEDUCATION\nMaster of Science in Computer Science\nStanford University | 2016\n- Specialization in Artificial Intelligence\n- GPA: 3.8/4.0\n\nBachelor of Science in Computer Engineering\nUniversity of California, Berkeley | 2014\n- Minor in Mathematics\n- Dean's List: 2012-2014\n\nPROJECTS\nAI-Powered Task Manager\n- Developed a task management application with natural language processing capabilities\n- Used React for frontend, Node.js for backend, and MongoDB for database\n- Implemented ML algorithms to categorize and prioritize tasks automatically\n\nE-commerce Platform\n- Built a full-stack e-commerce platform with product recommendation system\n- Utilized React, Express, and PostgreSQL with Sequelize ORM\n- Implemented payment processing with Stripe API\n\nCERTIFICATIONS\n- AWS Certified Solutions Architect\n- MongoDB Certified Developer\n- Google Cloud Professional Data Engineer`;\n\nexport default ResumeUpload;",[],[165,192,201],"dda588aa-316c-11f0-93c3-569c3dd06744",["D",1747300409322],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"react\";\nimport type { Resume, JobRequirement, ScoringResult } from \"../../shared/types\";\n\ninterface ResultsProps {\n results: (ScoringResult & { feedback?: string })[];\n resumes: Resume[];\n selectedJob: JobRequirement | null;\n onGetFeedback: (resumeId: number, jobId: number) => Promise;\n}\n\nconst Results: React.FC = ({ \n results, \n resumes, \n selectedJob,\n onGetFeedback\n}) => {\n const [selectedResult, setSelectedResult] = useState<(ScoringResult & { feedback?: string }) | null>(null);\n const [isLoading, setIsLoading] = useState(false);\n\n const handleViewResult = (result: ScoringResult & { feedback?: string }) => {\n setSelectedResult(result);\n };\n\n const handleCloseModal = () => {\n setSelectedResult(null);\n };\n\n const handleGetFeedback = async (resumeId: number) => {\n if (!selectedJob?.id) return;\n \n setIsLoading(true);\n await onGetFeedback(resumeId, selectedJob.id);\n setIsLoading(false);\n \n // Update the selected result with the new feedback\n const updatedResult = results.find(r => r.resumeId === resumeId);\n if (updatedResult) {\n setSelectedResult(updatedResult);\n }\n };\n\n // Get the resume object for a given result\n const getResumeForResult = (result: ScoringResult): Resume | undefined => {\n return resumes.find(r => r.id === result.resumeId);\n };\n\n return (\n

Screening Results

\n \n {selectedJob && (\n

Selected Job: {selectedJob.title}

\n Required Skills:\n {selectedJob.requiredSkills.map((skill, index) => (\n \n {skill}\n \n ))}\n

\n {selectedJob.preferredSkills.length > 0 && (\n

\n Preferred Skills:\n {selectedJob.preferredSkills.map((skill, index) => (\n \n {skill}\n \n ))}\n

\n )}\n

\n )}\n \n {results.length > 0 ? (\n

\n \n \n \n \n \n \n \n \n \n \n \n {results.map((result, index) => (\n \n \n \n \n \n \n \n ))}\n \n

\n Rank\n	\n Candidate\n	\n Score\n	\n Skill Match\n	\n Actions\n
\n \n #{index + 1}\n \n	\n \n {result.candidateName}\n \n	\n = 70 \n ? \"bg-green-100 text-green-800\" \n : result.score >= 50 \n ? \"bg-yellow-100 text-yellow-800\" \n : \"bg-red-100 text-red-800\"\n }`}>\n {result.score.toFixed(1)}\n \n	\n \n {result.skillMatches.matched.length} matched / {\n result.skillMatches.matched.length + result.skillMatches.missing.length\n } required\n \n	\n handleViewResult(result)}\n className=\"text-blue-600 hover:text-blue-900\"\n >\n View Details\n \n

\n ) : (\n

\n {selectedJob \n ? \"No results yet. Score resumes against the selected job to see results here.\"\n : \"No job selected. Please select or create a job first.\"}\n

\n )}\n \n {/* Result Details Modal */}\n {selectedResult && (\n

\n {selectedResult.candidateName}\n

\n \n ✕\n \n

\n \n

\n {selectedResult.score.toFixed(1)}\n

= 70 \n ? \"bg-green-500\" \n : selectedResult.score >= 50 \n ? \"bg-yellow-500\" \n : \"bg-red-500\"\n }`}\n style={{ width: `${selectedResult.score}%` }}\n >

\n \n

Skills Match

\n {Math.round(selectedResult.skillMatches.matched.length / \n (selectedResult.skillMatches.matched.length + \n selectedResult.skillMatches.missing.length) * 100)}%\n

Experience Relevance

\n {Math.round(selectedResult.experienceRelevance * 100)}%\n

Education Relevance

\n {Math.round(selectedResult.educationRelevance * 100)}%\n

\n \n

Skills Analysis

\n \n

Matched Skills

\n {selectedResult.skillMatches.matched.length > 0 ? (\n selectedResult.skillMatches.matched.map((skill, index) => (\n \n {skill}\n \n ))\n ) : (\n No matched skills\n )}\n

\n \n

Missing Required Skills

\n {selectedResult.skillMatches.missing.length > 0 ? (\n selectedResult.skillMatches.missing.map((skill, index) => (\n \n {skill}\n \n ))\n ) : (\n No missing skills\n )}\n

\n \n {selectedResult.highlights && selectedResult.highlights.length > 0 && (\n

Key Highlights

{highlight}

\n )}\n \n {/* AI Feedback Section */}\n

AI Feedback

\n {!selectedResult.feedback && selectedJob && (\n handleGetFeedback(selectedResult.resumeId)}\n className=\"text-blue-600 hover:text-blue-800 text-sm flex items-center\"\n disabled={isLoading}\n >\n {isLoading ? (\n <>\n \n Generating...\n \n ) : (\n \"Generate Feedback\"\n )}\n \n )}\n

\n \n {selectedResult.feedback ? (\n

{selectedResult.feedback}

\n ) : (\n

\n {isLoading \n ? \"Generating personalized feedback...\" \n : \"Click 'Generate Feedback' to get AI-powered insights for this candidate.\"}\n

\n )}\n

\n \n {/* Resume Details */}\n {getResumeForResult(selectedResult)?.parsedData && (\n

Resume Details

\n \n

\n {getResumeForResult(selectedResult)?.parsedData?.summary && (\n

Summary

\n {getResumeForResult(selectedResult)?.parsedData?.summary}\n

\n )}\n \n

Skills

\n {getResumeForResult(selectedResult)?.parsedData?.skills.map((skill, index) => (\n s.toLowerCase() === skill.toLowerCase() ||\n skill.toLowerCase().includes(s.toLowerCase()) ||\n s.toLowerCase().includes(skill.toLowerCase())\n )\n ? \"skill-matched\"\n : \"bg-gray-100 text-gray-800\"\n }`}\n >\n {skill}\n \n ))}\n

\n \n {getResumeForResult(selectedResult)?.parsedData?.experience.length > 0 && (\n

Experience

\n {getResumeForResult(selectedResult)?.parsedData?.experience.slice(0, 2).map((exp, index) => (\n

\n {exp.title}\n \n {exp.startDate} - {exp.endDate || \"Present\"}\n \n

{exp.company}

\n ))}\n {(getResumeForResult(selectedResult)?.parsedData?.experience.length || 0) > 2 && (\n

\n +{(getResumeForResult(selectedResult)?.parsedData?.experience.length || 0) - 2} more experiences\n

\n )}\n

\n )}\n \n {getResumeForResult(selectedResult)?.parsedData?.education.length > 0 && (\n

Education

\n {getResumeForResult(selectedResult)?.parsedData?.education.map((edu, index) => (\n

\n {edu.degree}\n {edu.field && in {edu.field}}\n from {edu.institution}\n

\n ))}\n

\n )}\n

\n )}\n \n

\n \n Close\n \n

\n )}\n

\n );\n};\n\nexport default Results;",[],[165,192,219],"b91ada80-316c-11f0-a16f-569c3dd06744",["D",1747300348014],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"react\";\nimport type { JobRequirement } from \"../../shared/types\";\n\ninterface JobFormProps {\n onSubmit: (job: Omit) => Promise;\n jobs: JobRequirement[];\n onScoreResumes: (jobId: number) => Promise;\n}\n\nconst JobForm: React.FC = ({ onSubmit, jobs, onScoreResumes }) => {\n const [title, setTitle] = useState(\"\");\n const [description, setDescription] = useState(\"\");\n const [requiredSkills, setRequiredSkills] = useState(\"\");\n const [preferredSkills, setPreferredSkills] = useState(\"\");\n const [minimumExperience, setMinimumExperience] = useState(\"\");\n const [showExisting, setShowExisting] = useState(false);\n const [selectedJob, setSelectedJob] = useState(null);\n\n const handleSubmit = (e: React.FormEvent) => {\n e.preventDefault();\n \n // Convert skills strings to arrays\n const requiredSkillsArray = requiredSkills\n .split(\",\")\n .map(skill => skill.trim())\n .filter(skill => skill.length > 0);\n \n const preferredSkillsArray = preferredSkills\n .split(\",\")\n .map(skill => skill.trim())\n .filter(skill => skill.length > 0);\n \n // Convert minimum experience to number\n const minExp = minimumExperience ? parseInt(minimumExperience, 10) : undefined;\n \n onSubmit({\n title,\n description,\n requiredSkills: requiredSkillsArray,\n preferredSkills: preferredSkillsArray,\n minimumExperience: minExp\n });\n };\n\n const handleViewJob = (job: JobRequirement) => {\n setSelectedJob(job);\n };\n\n const handleCloseModal = () => {\n setSelectedJob(null);\n };\n\n const handleUseJob = (job: JobRequirement) => {\n setTitle(job.title);\n setDescription(job.description);\n setRequiredSkills(job.requiredSkills.join(\", \"));\n setPreferredSkills(job.preferredSkills.join(\", \"));\n setMinimumExperience(job.minimumExperience?.toString() || \"\");\n setSelectedJob(null);\n setShowExisting(false);\n };\n\n const handleScoreWithJob = (jobId: number) => {\n onScoreResumes(jobId);\n };\n\n return (\n

Job Requirements

\n \n

\n \n Job Title\n \n setTitle(e.target.value)}\n placeholder=\"e.g., Senior Software Engineer\"\n required\n />\n

\n \n

\n \n Job Description\n \n setDescription(e.target.value)}\n placeholder=\"Describe the job responsibilities and requirements...\"\n required\n />\n

\n \n

\n \n Required Skills (comma-separated)\n \n setRequiredSkills(e.target.value)}\n placeholder=\"e.g., JavaScript, React, Node.js\"\n required\n />\n

\n \n

\n \n Preferred Skills (comma-separated)\n \n setPreferredSkills(e.target.value)}\n placeholder=\"e.g., TypeScript, AWS, Docker\"\n />\n

\n \n

\n \n Minimum Experience (years)\n \n setMinimumExperience(e.target.value)}\n placeholder=\"e.g., 3\"\n min=\"0\"\n />\n

\n \n

\n \n Save Job Requirements\n \n

\n \n {jobs.length > 0 && (\n

Existing Job Requirements

\n setShowExisting(!showExisting)}\n className=\"text-blue-600 hover:text-blue-800\"\n >\n {showExisting ? \"Hide\" : \"Show\"} ({jobs.length})\n \n

\n \n {showExisting && (\n

\n \n \n \n \n \n \n \n \n \n \n \n {jobs.map((job) => (\n \n \n \n \n \n \n \n ))}\n \n

\n Title\n	\n Required Skills\n	\n Min. Experience\n	\n Date\n	\n Actions\n
\n \n {job.title}\n \n	\n \n {job.requiredSkills.slice(0, 3).map((skill, index) => (\n \n {skill}\n \n ))}\n {job.requiredSkills.length > 3 && (\n \n +{job.requiredSkills.length - 3} more\n \n )}\n \n	\n \n {job.minimumExperience ? `${job.minimumExperience} years` : \"Not specified\"}\n \n	\n \n {new Date(job.createdAt).toLocaleDateString()}\n \n	\n handleViewJob(job)}\n className=\"text-blue-600 hover:text-blue-900 mr-3\"\n >\n View\n \n handleScoreWithJob(job.id!)}\n className=\"text-green-600 hover:text-green-900\"\n >\n Score Resumes\n \n

\n )}\n

\n )}\n \n {/* Job View Modal */}\n {selectedJob && (\n

\n {selectedJob.title}\n

\n \n ✕\n \n

\n \n

Description

{selectedJob.description}

\n \n

Required Skills

\n {selectedJob.requiredSkills.map((skill, index) => (\n \n {skill}\n \n ))}\n

\n \n {selectedJob.preferredSkills.length > 0 && (\n

Preferred Skills

\n {selectedJob.preferredSkills.map((skill, index) => (\n \n {skill}\n \n ))}\n

\n )}\n \n

Minimum Experience

\n {selectedJob.minimumExperience \n ? `${selectedJob.minimumExperience} years` \n : \"Not specified\"}\n

\n \n

\n handleUseJob(selectedJob)}\n className=\"bg-blue-600 text-white px-4 py-2 rounded-md hover:bg-blue-700\"\n >\n Use This Job\n \n handleScoreWithJob(selectedJob.id!)}\n className=\"bg-green-600 text-white px-4 py-2 rounded-md hover:bg-green-700\"\n >\n Score Resumes\n \n \n Close\n \n

\n )}\n \n {/* Sample Job */}\n

Sample Job Requirements

\n You can use these sample job requirements to test the system:\n

\n {\n setTitle(sampleJobs[0].title);\n setDescription(sampleJobs[0].description);\n setRequiredSkills(sampleJobs[0].requiredSkills.join(\", \"));\n setPreferredSkills(sampleJobs[0].preferredSkills.join(\", \"));\n setMinimumExperience(sampleJobs[0].minimumExperience?.toString() || \"\");\n }}\n className=\"text-blue-600 hover:text-blue-800 mb-2\"\n >\n Load Software Engineer Job\n \n {\n setTitle(sampleJobs[1].title);\n setDescription(sampleJobs[1].description);\n setRequiredSkills(sampleJobs[1].requiredSkills.join(\", \"));\n setPreferredSkills(sampleJobs[1].preferredSkills.join(\", \"));\n setMinimumExperience(sampleJobs[1].minimumExperience?.toString() || \"\");\n }}\n className=\"text-blue-600 hover:text-blue-800 mb-2\"\n >\n Load Data Scientist Job\n \n

\n );\n};\n\n// Sample job requirements for testing\nconst sampleJobs = [\n {\n title: \"Senior Software Engineer\",\n description: `We are looking for a Senior Software Engineer to join our team and help build scalable web applications. The ideal candidate has strong experience with modern JavaScript frameworks and cloud technologies.\n\nResponsibilities:\n- Design and implement new features for our web applications\n- Write clean, maintainable, and efficient code\n- Collaborate with cross-functional teams to define and implement new features\n- Troubleshoot and fix bugs in existing applications\n- Mentor junior developers and conduct code reviews`,\n requiredSkills: [\"JavaScript\", \"React\", \"Node.js\", \"REST API\"],\n preferredSkills: [\"TypeScript\", \"AWS\", \"Docker\", \"GraphQL\", \"CI/CD\"],\n minimumExperience: 3\n },\n {\n title: \"Data Scientist\",\n description: `We are seeking a talented Data Scientist to help us extract insights from our data and build machine learning models. The ideal candidate has strong statistical knowledge and programming skills.\n\nResponsibilities:\n- Analyze large datasets to extract actionable insights\n- Develop and implement machine learning models\n- Create data visualizations to communicate findings\n- Collaborate with engineering teams to implement models in production\n- Stay up-to-date with the latest research and technologies in the field`,\n requiredSkills: [\"Python\", \"Machine Learning\", \"SQL\", \"Data Analysis\"],\n preferredSkills: [\"TensorFlow\", \"PyTorch\", \"NLP\", \"Big Data\", \"Cloud Computing\"],\n minimumExperience: 2\n }\n];\n\nexport default JobForm;",[],[165,192,210],"7c06adcc-316c-11f0-ad29-569c3dd06744",["D",1747300245545],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"react\";\nimport ResumeUpload from \"./ResumeUpload\";\nimport JobForm from \"./JobForm\";\nimport Results from \"./Results\";\nimport { type Resume, type JobRequirement, type ScoringResult } from \"../../shared/types\";\n\n// Get project info if available\ndeclare global {\n interface Window {\n __PROJECT_INFO__?: {\n username: string;\n name: string;\n url: string;\n };\n }\n}\n\nconst App: React.FC = () => {\n const [activeTab, setActiveTab] = useState<\"upload\" | \"jobs\" | \"results\">(\"upload\");\n const [resumes, setResumes] = useState([]);\n const [jobs, setJobs] = useState([]);\n const [selectedJob, setSelectedJob] = useState(null);\n const [scoringResults, setScoringResults] = useState<(ScoringResult & { feedback?: string })[]>([]);\n const [isLoading, setIsLoading] = useState(false);\n const [error, setError] = useState(null);\n\n // Fetch resumes and jobs on initial load\n React.useEffect(() => {\n fetchResumes();\n fetchJobs();\n }, []);\n\n // Fetch all resumes\n const fetchResumes = async () => {\n try {\n const response = await fetch(\"/api/resumes\");\n const data = await response.json();\n \n if (data.success) {\n setResumes(data.data);\n } else {\n setError(data.error || \"Failed to fetch resumes\");\n }\n } catch (error) {\n console.error(\"Error fetching resumes:\", error);\n setError(\"Failed to fetch resumes\");\n }\n };\n\n // Fetch all jobs\n const fetchJobs = async () => {\n try {\n const response = await fetch(\"/api/jobs\");\n const data = await response.json();\n \n if (data.success) {\n setJobs(data.data);\n } else {\n setError(data.error || \"Failed to fetch jobs\");\n }\n } catch (error) {\n console.error(\"Error fetching jobs:\", error);\n setError(\"Failed to fetch jobs\");\n }\n };\n\n // Handle resume upload\n const handleResumeUpload = async (resumeText: string) => {\n setIsLoading(true);\n setError(null);\n \n try {\n const response = await fetch(\"/api/resumes\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ resumeText }),\n });\n \n const data = await response.json();\n \n if (data.success) {\n // Refresh resumes list\n await fetchResumes();\n setActiveTab(\"results\");\n } else {\n setError(data.error || \"Failed to upload resume\");\n }\n } catch (error) {\n console.error(\"Error uploading resume:\", error);\n setError(\"Failed to upload resume\");\n } finally {\n setIsLoading(false);\n }\n };\n\n // Handle job creation\n const handleJobCreate = async (job: Omit) => {\n setIsLoading(true);\n setError(null);\n \n try {\n const response = await fetch(\"/api/jobs\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(job),\n });\n \n const data = await response.json();\n \n if (data.success) {\n // Refresh jobs list\n await fetchJobs();\n setSelectedJob(data.data);\n setActiveTab(\"results\");\n } else {\n setError(data.error || \"Failed to create job\");\n }\n } catch (error) {\n console.error(\"Error creating job:\", error);\n setError(\"Failed to create job\");\n } finally {\n setIsLoading(false);\n }\n };\n\n // Handle resume scoring\n const handleScoreResumes = async (jobId: number) => {\n if (resumes.length === 0) {\n setError(\"No resumes available to score\");\n return;\n }\n \n setIsLoading(true);\n setError(null);\n \n try {\n // Get the selected job\n const job = jobs.find(j => j.id === jobId);\n if (!job) {\n setError(\"Selected job not found\");\n setIsLoading(false);\n return;\n }\n \n setSelectedJob(job);\n \n // Get resume IDs\n const resumeIds = resumes.map(r => r.id!);\n \n // Score resumes\n const response = await fetch(\"/api/score/batch\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ resumeIds, jobId }),\n });\n \n const data = await response.json();\n \n if (data.success) {\n setScoringResults(data.data);\n setActiveTab(\"results\");\n } else {\n setError(data.error || \"Failed to score resumes\");\n }\n } catch (error) {\n console.error(\"Error scoring resumes:\", error);\n setError(\"Failed to score resumes\");\n } finally {\n setIsLoading(false);\n }\n };\n\n // Handle individual resume scoring and feedback\n const handleGetFeedback = async (resumeId: number, jobId: number) => {\n setIsLoading(true);\n setError(null);\n \n try {\n const response = await fetch(\"/api/score\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ resumeId, jobId }),\n });\n \n const data = await response.json();\n \n if (data.success) {\n // Update the scoring results with feedback\n setScoringResults(prevResults => {\n const updatedResults = [...prevResults];\n const index = updatedResults.findIndex(r => r.resumeId === resumeId);\n \n if (index !== -1) {\n updatedResults[index] = {\n ...updatedResults[index],\n feedback: data.data.feedback\n };\n } else {\n updatedResults.push(data.data);\n }\n \n return updatedResults;\n });\n } else {\n setError(data.error || \"Failed to get feedback\");\n }\n } catch (error) {\n console.error(\"Error getting feedback:\", error);\n setError(\"Failed to get feedback\");\n } finally {\n setIsLoading(false);\n }\n };\n\n return (\n

\n {/* Header */}\n

AI Resume Screening System

\n Upload resumes, define job requirements, and let AI match the best candidates\n

\n \n {/* View Source Link */}\n {window.__PROJECT_INFO__ && (\n \n View Source on Val Town\n \n )}\n

\n \n {/* Navigation Tabs */}\n

\n setActiveTab(\"upload\")}\n >\n Upload Resume\n \n setActiveTab(\"jobs\")}\n >\n Job Requirements\n \n setActiveTab(\"results\")}\n >\n Results\n \n

\n \n {/* Error Message */}\n {error && (\n

{error}

\n )}\n \n {/* Loading Indicator */}\n {isLoading && (\n

\n \n

Processing...

\n )}\n \n {/* Content */}\n

\n {activeTab === \"upload\" && (\n \n )}\n \n {activeTab === \"jobs\" && (\n \n )}\n \n {activeTab === \"results\" && (\n \n )}\n

\n );\n};\n\nexport default App;",[],[165,192,190],"7c06d87e-316c-11f0-ad29-569c3dd06744",["D",1747300245545],[359,360,361,362],[165,192],["D",1747300202212],[358,363,364,365],[165],"45887e1a-316c-11f0-bc4b-569c3dd06744",["D",1747300154122],"import { OpenAI } from \"https://esm.town/v/std/openai\";\nimport type { Resume, JobRequirement, ScoringResult, ParsedResumeData } from \"../shared/types\";\nimport { calculateSimilarity } from \"../shared/utils\";\n\nconst openai = new OpenAI();\n\n/**\n * Scores a resume against job requirements\n */\nexport function scoreResume(resume: Resume, jobRequirement: JobRequirement): ScoringResult {\n if (!resume.parsedData) {\n throw new Error(\"Resume must be parsed before scoring\");\n }\n\n const { parsedData } = resume;\n const { requiredSkills, preferredSkills, minimumExperience } = jobRequirement;\n \n // Calculate skill match score\n const skillMatches = calculateSkillMatches(parsedData.skills, requiredSkills, preferredSkills);\n \n // Calculate experience relevance\n const experienceRelevance = calculateExperienceRelevance(\n parsedData.experience, \n jobRequirement.title, \n jobRequirement.description\n );\n \n // Calculate education relevance\n const educationRelevance = calculateEducationRelevance(parsedData.education);\n \n // Calculate overall score (weighted average)\n const skillWeight = 0.5;\n const experienceWeight = 0.35;\n const educationWeight = 0.15;\n \n const overallScore = (\n skillMatches.score * skillWeight +\n experienceRelevance * experienceWeight +\n educationRelevance * educationWeight\n ) * 100; // Convert to percentage\n \n return {\n resumeId: resume.id!,\n candidateName: resume.candidateName,\n score: Math.round(overallScore * 10) / 10, // Round to 1 decimal place\n skillMatches: {\n matched: skillMatches.matched,\n missing: skillMatches.missing\n },\n experienceRelevance,\n educationRelevance,\n highlights: parsedData.highlights || []\n };\n}\n\n/**\n * Calculates skill matches between resume skills and job requirements\n */\nfunction calculateSkillMatches(\n candidateSkills: string[],\n requiredSkills: string[],\n preferredSkills: string[]\n) {\n const normalizedCandidateSkills = candidateSkills.map(s => s.toLowerCase());\n const normalizedRequiredSkills = requiredSkills.map(s => s.toLowerCase());\n const normalizedPreferredSkills = preferredSkills.map(s => s.toLowerCase());\n \n // Find matching skills\n const matchedRequired = normalizedRequiredSkills.filter(skill => \n normalizedCandidateSkills.some(candidateSkill => \n candidateSkill.includes(skill) || skill.includes(candidateSkill)\n )\n );\n \n const matchedPreferred = normalizedPreferredSkills.filter(skill => \n normalizedCandidateSkills.some(candidateSkill => \n candidateSkill.includes(skill) || skill.includes(candidateSkill)\n )\n );\n \n // Calculate score\n const requiredWeight = 0.7;\n const preferredWeight = 0.3;\n \n const requiredScore = requiredSkills.length > 0 \n ? (matchedRequired.length / requiredSkills.length) * requiredWeight \n : 0;\n \n const preferredScore = preferredSkills.length > 0 \n ? (matchedPreferred.length / preferredSkills.length) * preferredWeight \n : 0;\n \n const totalScore = requiredScore + preferredScore;\n \n // Find missing required skills\n const missingRequired = normalizedRequiredSkills.filter(skill => \n !normalizedCandidateSkills.some(candidateSkill => \n candidateSkill.includes(skill) || skill.includes(candidateSkill)\n )\n );\n \n return {\n matched: [...new Set([...matchedRequired, ...matchedPreferred])],\n missing: missingRequired,\n score: totalScore\n };\n}\n\n/**\n * Calculates experience relevance based on job title and description\n */\nfunction calculateExperienceRelevance(\n experiences: { company: string; title: string; description: string }[],\n jobTitle: string,\n jobDescription: string\n): number {\n if (experiences.length === 0) {\n return 0;\n }\n \n // Calculate relevance for each experience\n const relevanceScores = experiences.map(exp => {\n const titleSimilarity = calculateSimilarity(exp.title, jobTitle);\n const descriptionSimilarity = calculateSimilarity(exp.description, jobDescription);\n \n // Weight title similarity more heavily\n return titleSimilarity * 0.6 + descriptionSimilarity * 0.4;\n });\n \n // Use the highest relevance score (most relevant experience)\n return Math.max(...relevanceScores);\n}\n\n/**\n * Calculates education relevance (simplified)\n */\nfunction calculateEducationRelevance(\n education: { institution: string; degree: string; field?: string }[]\n): number {\n if (education.length === 0) {\n return 0;\n }\n \n // Simple scoring based on degree level\n const degreeScores = education.map(edu => {\n const degree = edu.degree.toLowerCase();\n \n if (degree.includes(\"phd\") || degree.includes(\"doctorate\")) {\n return 1.0;\n } else if (degree.includes(\"master\") || degree.includes(\"mba\")) {\n return 0.8;\n } else if (degree.includes(\"bachelor\") || degree.includes(\"bs\") || degree.includes(\"ba\")) {\n return 0.6;\n } else if (degree.includes(\"associate\") || degree.includes(\"certificate\")) {\n return 0.4;\n } else {\n return 0.2;\n }\n });\n \n // Use the highest education score\n return Math.max(...degreeScores);\n}\n\n/**\n * Uses AI to generate personalized feedback for a candidate\n */\nexport async function generateCandidateFeedback(\n resume: Resume,\n jobRequirement: JobRequirement,\n scoringResult: ScoringResult\n): Promise {\n try {\n const prompt = `\n You are an AI-powered resume screening assistant. Generate constructive feedback for a candidate\n based on their resume and the job requirements. Be professional, helpful, and specific.\n \n Job Title: ${jobRequirement.title}\n Job Description: ${jobRequirement.description}\n \n Required Skills: ${jobRequirement.requiredSkills.join(\", \")}\n Preferred Skills: ${jobRequirement.preferredSkills.join(\", \")}\n \n Candidate's Skills: ${resume.parsedData?.skills.join(\", \") || \"None listed\"}\n \n Matching Skills: ${scoringResult.skillMatches.matched.join(\", \") || \"None\"}\n Missing Required Skills: ${scoringResult.skillMatches.missing.join(\", \") || \"None\"}\n \n Overall Score: ${scoringResult.score}/100\n \n Provide specific feedback on:\n 1. Strengths of the candidate's profile\n 2. Areas for improvement\n 3. Suggestions for how they could better position themselves for this role\n \n Keep the feedback concise (maximum 250 words) and constructive.\n `;\n\n const completion = await openai.chat.completions.create({\n messages: [{ role: \"user\", content: prompt }],\n model: \"gpt-4o-mini\",\n max_tokens: 500,\n temperature: 0.7,\n });\n\n return completion.choices[0]?.message?.content || \n \"Unable to generate feedback at this time.\";\n } catch (error) {\n console.error(\"Error generating feedback:\", error);\n return \"Unable to generate feedback at this time.\";\n }\n}",[],[122,142],"34aa2616-316c-11f0-bdd8-569c3dd06744",["D",1747300125822],"import { OpenAI } from \"https://esm.town/v/std/openai\";\nimport type { ParsedResumeData } from \"../shared/types\";\n\nconst openai = new OpenAI();\n\n/**\n * Parses resume text using OpenAI to extract structured information\n */\nexport async function parseResume(resumeText: string): Promise {\n try {\n const prompt = `\n Extract the following information from this resume:\n 1. Skills (as a list of individual skills)\n 2. Work experience (including company, title, dates, and description)\n 3. Education (including institution, degree, field, and graduation date)\n 4. A brief professional summary\n 5. Key highlights or achievements\n\n Format the response as a valid JSON object with the following structure:\n {\n \"skills\": [\"skill1\", \"skill2\", ...],\n \"experience\": [\n {\n \"company\": \"Company Name\",\n \"title\": \"Job Title\",\n \"startDate\": \"YYYY-MM\",\n \"endDate\": \"YYYY-MM or Present\",\n \"description\": \"Job description\",\n \"highlights\": [\"achievement1\", \"achievement2\", ...]\n },\n ...\n ],\n \"education\": [\n {\n \"institution\": \"University Name\",\n \"degree\": \"Degree Type\",\n \"field\": \"Field of Study\",\n \"graduationDate\": \"YYYY-MM\"\n },\n ...\n ],\n \"summary\": \"Professional summary\",\n \"highlights\": [\"highlight1\", \"highlight2\", ...]\n }\n\n Resume:\n ${resumeText}\n `;\n\n const completion = await openai.chat.completions.create({\n messages: [{ role: \"user\", content: prompt }],\n model: \"gpt-4o-mini\",\n response_format: { type: \"json_object\" },\n temperature: 0.2,\n });\n\n const content = completion.choices[0]?.message?.content;\n if (!content) {\n throw new Error(\"Failed to get a response from OpenAI\");\n }\n\n // Parse the JSON response\n const parsedData = JSON.parse(content) as ParsedResumeData;\n \n // Validate and ensure the structure is correct\n return {\n skills: Array.isArray(parsedData.skills) ? parsedData.skills : [],\n experience: Array.isArray(parsedData.experience) ? parsedData.experience : [],\n education: Array.isArray(parsedData.education) ? parsedData.education : [],\n summary: parsedData.summary || \"\",\n highlights: Array.isArray(parsedData.highlights) ? parsedData.highlights : []\n };\n } catch (error) {\n console.error(\"Error parsing resume:\", error);\n // Return a minimal valid structure if parsing fails\n return {\n skills: [],\n experience: [],\n education: []\n };\n }\n}\n\n/**\n * Extracts contact information from resume text\n */\nexport async function extractContactInfo(resumeText: string): Promise<{ name: string; email: string; phone?: string }> {\n try {\n const prompt = `\n Extract only the following contact information from this resume:\n 1. Full name\n 2. Email address\n 3. Phone number (if available)\n\n Format the response as a valid JSON object with the following structure:\n {\n \"name\": \"Full Name\",\n \"email\": \"email@example.com\",\n \"phone\": \"phone number or null if not found\"\n }\n\n Resume:\n ${resumeText.substring(0, 1000)} // Only use the beginning of the resume for contact info\n `;\n\n const completion = await openai.chat.completions.create({\n messages: [{ role: \"user\", content: prompt }],\n model: \"gpt-4o-mini\",\n response_format: { type: \"json_object\" },\n temperature: 0.2,\n });\n\n const content = completion.choices[0]?.message?.content;\n if (!content) {\n throw new Error(\"Failed to get a response from OpenAI\");\n }\n\n // Parse the JSON response\n const contactInfo = JSON.parse(content);\n \n return {\n name: contactInfo.name || \"Unknown\",\n email: contactInfo.email || \"unknown@example.com\",\n phone: contactInfo.phone !== \"null\" ? contactInfo.phone : undefined\n };\n } catch (error) {\n console.error(\"Error extracting contact info:\", error);\n return {\n name: \"Unknown\",\n email: \"unknown@example.com\"\n };\n }\n}",[],[122,133],"e0b94b26-316c-11f0-8374-569c3dd06744",["D",1747300414487],"import { Hono } from \"https://esm.sh/hono@3.11.12\";\nimport { cors } from \"https://esm.sh/hono@3.11.12/cors\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { parseProject } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { \n initDatabase, \n saveResume, \n getResume, \n getAllResumes,\n updateResumeScore,\n updateParsedData,\n saveJobRequirement,\n getJobRequirement,\n getAllJobRequirements\n} from \"./database.ts\";\nimport { parseResume, extractContactInfo } from \"./parser.ts\";\nimport { scoreResume, generateCandidateFeedback } from \"./scorer.ts\";\nimport type { Resume, JobRequirement, ScoringResult } from \"../shared/types\";\n\n// Initialize the Hono app\nconst app = new Hono();\n\n// Enable CORS\napp.use(\"/*\", cors());\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n console.error(\"Error:\", err);\n throw err;\n});\n\n// Initialize database on startup\ninitDatabase().catch(console.error);\n\n// Get project info for view source links\nconst projectInfo = parseProject(import.meta.url);\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 the main HTML page with project info\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject project info for view source link\n const projectData = {\n username: projectInfo.username,\n name: projectInfo.name,\n url: projectInfo.links.self.project\n };\n \n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n});\n\n// API Routes\n\n// Resume endpoints\napp.post(\"/api/resumes\", async c => {\n try {\n const body = await c.req.json();\n const { resumeText } = body;\n \n if (!resumeText) {\n return c.json({ success: false, error: \"Resume text is required\" }, 400);\n }\n \n // Extract contact information\n const contactInfo = await extractContactInfo(resumeText);\n \n // Create resume object\n const resume: Resume = {\n candidateName: contactInfo.name,\n email: contactInfo.email,\n phone: contactInfo.phone,\n resumeText,\n createdAt: new Date().toISOString()\n };\n \n // Save resume to database\n const id = await saveResume(resume);\n \n // Parse resume asynchronously\n parseResume(resumeText).then(async parsedData => {\n await updateParsedData(id, parsedData);\n }).catch(console.error);\n \n return c.json({ \n success: true, \n data: { id, ...resume } \n });\n } catch (error) {\n console.error(\"Error creating resume:\", error);\n return c.json({ success: false, error: \"Failed to process resume\" }, 500);\n }\n});\n\napp.get(\"/api/resumes\", async c => {\n try {\n const resumes = await getAllResumes();\n return c.json({ success: true, data: resumes });\n } catch (error) {\n console.error(\"Error fetching resumes:\", error);\n return c.json({ success: false, error: \"Failed to fetch resumes\" }, 500);\n }\n});\n\napp.get(\"/api/resumes/:id\", async c => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ success: false, error: \"Invalid resume ID\" }, 400);\n }\n \n const resume = await getResume(id);\n if (!resume) {\n return c.json({ success: false, error: \"Resume not found\" }, 404);\n }\n \n return c.json({ success: true, data: resume });\n } catch (error) {\n console.error(\"Error fetching resume:\", error);\n return c.json({ success: false, error: \"Failed to fetch resume\" }, 500);\n }\n});\n\n// Job requirement endpoints\napp.post(\"/api/jobs\", async c => {\n try {\n const body = await c.req.json();\n const { title, description, requiredSkills, preferredSkills, minimumExperience } = body;\n \n if (!title || !description || !requiredSkills) {\n return c.json({ \n success: false, \n error: \"Title, description, and required skills are required\" \n }, 400);\n }\n \n const jobRequirement: JobRequirement = {\n title,\n description,\n requiredSkills: Array.isArray(requiredSkills) ? requiredSkills : [],\n preferredSkills: Array.isArray(preferredSkills) ? preferredSkills : [],\n minimumExperience,\n createdAt: new Date().toISOString()\n };\n \n const id = await saveJobRequirement(jobRequirement);\n \n return c.json({ \n success: true, \n data: { id, ...jobRequirement } \n });\n } catch (error) {\n console.error(\"Error creating job requirement:\", error);\n return c.json({ success: false, error: \"Failed to create job requirement\" }, 500);\n }\n});\n\napp.get(\"/api/jobs\", async c => {\n try {\n const jobs = await getAllJobRequirements();\n return c.json({ success: true, data: jobs });\n } catch (error) {\n console.error(\"Error fetching job requirements:\", error);\n return c.json({ success: false, error: \"Failed to fetch job requirements\" }, 500);\n }\n});\n\napp.get(\"/api/jobs/:id\", async c => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ success: false, error: \"Invalid job ID\" }, 400);\n }\n \n const job = await getJobRequirement(id);\n if (!job) {\n return c.json({ success: false, error: \"Job requirement not found\" }, 404);\n }\n \n return c.json({ success: true, data: job });\n } catch (error) {\n console.error(\"Error fetching job requirement:\", error);\n return c.json({ success: false, error: \"Failed to fetch job requirement\" }, 500);\n }\n});\n\n// Scoring endpoint\napp.post(\"/api/score\", async c => {\n try {\n const body = await c.req.json();\n const { resumeId, jobId } = body;\n \n if (!resumeId || !jobId) {\n return c.json({ success: false, error: \"Resume ID and Job ID are required\" }, 400);\n }\n \n const resume = await getResume(resumeId);\n const job = await getJobRequirement(jobId);\n \n if (!resume) {\n return c.json({ success: false, error: \"Resume not found\" }, 404);\n }\n \n if (!job) {\n return c.json({ success: false, error: \"Job requirement not found\" }, 404);\n }\n \n // If resume hasn't been parsed yet, parse it now\n if (!resume.parsedData) {\n const parsedData = await parseResume(resume.resumeText);\n await updateParsedData(resumeId, parsedData);\n resume.parsedData = parsedData;\n }\n \n // Score the resume\n const scoringResult = scoreResume(resume, job);\n \n // Update the resume score in the database\n await updateResumeScore(resumeId, scoringResult.score);\n \n // Generate feedback\n const feedback = await generateCandidateFeedback(resume, job, scoringResult);\n \n return c.json({ \n success: true, \n data: { \n ...scoringResult,\n feedback\n } \n });\n } catch (error) {\n console.error(\"Error scoring resume:\", error);\n return c.json({ success: false, error: \"Failed to score resume\" }, 500);\n }\n});\n\n// Batch scoring endpoint\napp.post(\"/api/score/batch\", async c => {\n try {\n const body = await c.req.json();\n const { resumeIds, jobId } = body;\n \n if (!resumeIds || !jobId || !Array.isArray(resumeIds)) {\n return c.json({ \n success: false, \n error: \"Resume IDs array and Job ID are required\" \n }, 400);\n }\n \n const job = await getJobRequirement(jobId);\n if (!job) {\n return c.json({ success: false, error: \"Job requirement not found\" }, 404);\n }\n \n const results: ScoringResult[] = [];\n \n // Process each resume\n for (const resumeId of resumeIds) {\n const resume = await getResume(resumeId);\n if (!resume) {\n console.warn(`Resume ${resumeId} not found, skipping`);\n continue;\n }\n \n // If resume hasn't been parsed yet, parse it now\n if (!resume.parsedData) {\n const parsedData = await parseResume(resume.resumeText);\n await updateParsedData(resumeId, parsedData);\n resume.parsedData = parsedData;\n }\n \n // Score the resume\n const scoringResult = scoreResume(resume, job);\n \n // Update the resume score in the database\n await updateResumeScore(resumeId, scoringResult.score);\n \n results.push(scoringResult);\n }\n \n // Sort results by score (descending)\n results.sort((a, b) => b.score - a.score);\n \n return c.json({ success: true, data: results });\n } catch (error) {\n console.error(\"Error batch scoring resumes:\", error);\n return c.json({ success: false, error: \"Failed to score resumes\" }, 500);\n }\n});\n\n// Export the Hono app\nexport default app.fetch;",[],[122,151],"2ab17ede-316c-11f0-9caa-569c3dd06744",["D",1747300109087],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { Resume, JobRequirement, ParsedResumeData } from \"../shared/types\";\n\n// Table names - use versioning for schema changes\nconst RESUMES_TABLE = \"resume_screening_resumes_v1\";\nconst JOB_REQUIREMENTS_TABLE = \"resume_screening_jobs_v1\";\n\n// Initialize database tables\nexport async function initDatabase() {\n // Create resumes table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${RESUMES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n candidateName TEXT NOT NULL,\n email TEXT NOT NULL,\n phone TEXT,\n resumeText TEXT NOT NULL,\n parsedData TEXT,\n score REAL,\n createdAt TEXT NOT NULL\n )\n `);\n\n // Create job requirements table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${JOB_REQUIREMENTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT NOT NULL,\n requiredSkills TEXT NOT NULL,\n preferredSkills TEXT NOT NULL,\n minimumExperience INTEGER,\n createdAt TEXT NOT NULL\n )\n `);\n}\n\n// Resume operations\nexport async function saveResume(resume: Resume): Promise {\n const { candidateName, email, phone, resumeText, parsedData, score, createdAt } = resume;\n \n const result = await sqlite.execute(\n `INSERT INTO ${RESUMES_TABLE} \n (candidateName, email, phone, resumeText, parsedData, score, createdAt) \n VALUES (?, ?, ?, ?, ?, ?, ?)\n RETURNING id`,\n [\n candidateName,\n email,\n phone || null,\n resumeText,\n parsedData ? JSON.stringify(parsedData) : null,\n score || null,\n createdAt\n ]\n );\n \n return result.rows[0].id as number;\n}\n\nexport async function getResume(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${RESUMES_TABLE} WHERE id = ?`,\n [id]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n const row = result.rows[0];\n return {\n id: row.id,\n candidateName: row.candidateName,\n email: row.email,\n phone: row.phone,\n resumeText: row.resumeText,\n parsedData: row.parsedData ? JSON.parse(row.parsedData) : undefined,\n score: row.score,\n createdAt: row.createdAt\n };\n}\n\nexport async function getAllResumes(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${RESUMES_TABLE} ORDER BY createdAt DESC`);\n \n return result.rows.map(row => ({\n id: row.id,\n candidateName: row.candidateName,\n email: row.email,\n phone: row.phone,\n resumeText: row.resumeText,\n parsedData: row.parsedData ? JSON.parse(row.parsedData) : undefined,\n score: row.score,\n createdAt: row.createdAt\n }));\n}\n\nexport async function updateResumeScore(id: number, score: number): Promise {\n await sqlite.execute(\n `UPDATE ${RESUMES_TABLE} SET score = ? WHERE id = ?`,\n [score, id]\n );\n}\n\nexport async function updateParsedData(id: number, parsedData: ParsedResumeData): Promise {\n await sqlite.execute(\n `UPDATE ${RESUMES_TABLE} SET parsedData = ? WHERE id = ?`,\n [JSON.stringify(parsedData), id]\n );\n}\n\n// Job requirement operations\nexport async function saveJobRequirement(job: JobRequirement): Promise {\n const { title, description, requiredSkills, preferredSkills, minimumExperience, createdAt } = job;\n \n const result = await sqlite.execute(\n `INSERT INTO ${JOB_REQUIREMENTS_TABLE} \n (title, description, requiredSkills, preferredSkills, minimumExperience, createdAt) \n VALUES (?, ?, ?, ?, ?, ?)\n RETURNING id`,\n [\n title,\n description,\n JSON.stringify(requiredSkills),\n JSON.stringify(preferredSkills),\n minimumExperience || null,\n createdAt\n ]\n );\n \n return result.rows[0].id as number;\n}\n\nexport async function getJobRequirement(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${JOB_REQUIREMENTS_TABLE} WHERE id = ?`,\n [id]\n );\n \n if (result.rows.length === 0) {\n return null;\n }\n \n const row = result.rows[0];\n return {\n id: row.id,\n title: row.title,\n description: row.description,\n requiredSkills: JSON.parse(row.requiredSkills),\n preferredSkills: JSON.parse(row.preferredSkills),\n minimumExperience: row.minimumExperience,\n createdAt: row.createdAt\n };\n}\n\nexport async function getAllJobRequirements(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${JOB_REQUIREMENTS_TABLE} ORDER BY createdAt DESC`);\n \n return result.rows.map(row => ({\n id: row.id,\n title: row.title,\n description: row.description,\n requiredSkills: JSON.parse(row.requiredSkills),\n preferredSkills: JSON.parse(row.preferredSkills),\n minimumExperience: row.minimumExperience,\n createdAt: row.createdAt\n }));\n}",[],[122,124],"e8dd6e7c-316c-11f0-b42a-569c3dd06744",["D",1747300428146],"# Backend\n\nThis directory contains the server-side code for the AI-based resume screening system.\n\n## Files\n\n- `index.ts` - Main API entry point with Hono framework (HTTP trigger)\n- `database.ts` - SQLite database operations for storing resumes and job requirements\n- `parser.ts` - Resume parsing logic using OpenAI's GPT models\n- `scorer.ts` - Candidate scoring algorithms and feedback generation\n\n## API Endpoints\n\n### Resumes\n\n- `POST /api/resumes` - Upload a new resume\n- `GET /api/resumes` - Get all resumes\n- `GET /api/resumes/:id` - Get a specific resume by ID\n\n### Job Requirements\n\n- `POST /api/jobs` - Create a new job requirement\n- `GET /api/jobs` - Get all job requirements\n- `GET /api/jobs/:id` - Get a specific job requirement by ID\n\n### Scoring\n\n- `POST /api/score` - Score a single resume against a job requirement\n- `POST /api/score/batch` - Score multiple resumes against a job requirement\n\n## Database Schema\n\nThe system uses SQLite with the following tables:\n\n- `resume_screening_resumes_v1` - Stores resume data\n- `resume_screening_jobs_v1` - Stores job requirement data",[],[122,74],["D",1747300109087],[352,353,354,355,356],[122],["D",1747300035655],{"_11":12,"_298":79},{"_11":12,"_294":-5,"_78":79,"_25":77,"_295":296,"_297":24},{"_49":246,"_13":16,"_43":46,"_286":252,"_287":-5,"_288":-5,"_289":-5,"_290":-5,"_291":-5,"_292":14,"_293":12},"ctx",{"_61":-5,"_318":500,"_501":502,"_503":504,"_505":24,"_506":24,"_507":24,"_508":263,"_509":-5,"_510":-7,"_511":-7,"_512":20,"_513":24,"_514":24,"_515":-5,"_516":24,"_517":24,"_518":24,"_519":-5},"ENV",{"_471":472,"_473":474,"_475":16,"_476":477,"_478":479,"_480":481,"_482":483,"_484":485,"_486":487,"_488":489,"_490":491,"_492":493,"_494":495,"_496":497,"_498":499},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","c73f21da490985bff19c279eb0e09db24d688e4f","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