🎓 Smart Placement Management System

A full-featured placement management backend built with Spring Boot, Hibernate, and MySQL.

---

✨ Features

Feature	Details
Student Profile Management	CRUD, skills, branch, CGPA, backlogs, 10th/12th
Company Eligibility Checking	Auto-checks CGPA, backlogs, branch, skills, percentages
Resume Verification	PDF upload + admin verify/reject flow
Placement Statistics	Placed %, avg/max/min CTC, branch breakdown, industry breakdown
Interview Scheduling	Multi-round, online/offline, auto-reminders
Email Notifications	Application, status updates, interview, placement congrats
JWT Auth	Roles: STUDENT, TPO, ADMIN
Bonus Feature	Students see exactly which companies they're eligible for and WHY

---

🏗️ Project Structure

src/main/java/com/placement/
├── PlacementApplication.java
├── config/
│   ├── SecurityConfig.java        # Spring Security + JWT
│   ├── JwtUtils.java
│   └── JwtAuthFilter.java
├── controller/
│   ├── AuthController.java        # /api/v1/auth
│   ├── StudentController.java     # /api/v1/students
│   ├── CompanyController.java     # /api/v1/companies
│   ├── ApplicationController.java # /api/v1/applications
│   ├── InterviewController.java   # /api/v1/interviews
│   └── StatsController.java       # /api/v1/stats
├── service/
│   ├── EligibilityService.java    # ⭐ Core bonus feature logic
│   ├── StudentService.java
│   ├── CompanyService.java
│   ├── ApplicationService.java
│   ├── InterviewService.java
│   ├── EmailService.java
│   └── StatsService.java
├── model/
│   ├── User.java
│   ├── Student.java
│   ├── Company.java
│   ├── Application.java
│   └── Interview.java
├── repository/
│   ├── UserRepository.java
│   ├── StudentRepository.java
│   ├── CompanyRepository.java
│   ├── ApplicationRepository.java
│   └── InterviewRepository.java
├── dto/
│   ├── AuthDTO.java
│   ├── StudentDTO.java            # Includes EligibilityResult
│   ├── CompanyDTO.java
│   └── PlacementStatsDTO.java
├── exception/
│   ├── ResourceNotFoundException.java
│   ├── DuplicateResourceException.java
│   └── GlobalExceptionHandler.java
└── util/
    └── DataSeeder.java            # Seeds sample data on first run

---

🚀 Quick Start

Prerequisites

• Java 17+
• Maven 3.8+
• MySQL 8+

1. Create Database

CREATE DATABASE placement_db;

2. Configure application.properties

spring.datasource.url=jdbc:mysql://localhost:3306/placement_db
spring.datasource.username=YOUR_MYSQL_USER
spring.datasource.password=YOUR_MYSQL_PASSWORD

spring.mail.username=YOUR_GMAIL
spring.mail.password=YOUR_APP_PASSWORD   # Gmail App Password (not your login password)

3. Run

mvn spring-boot:run

The app starts at http://localhost:8080 Swagger UI: http://localhost:8080/swagger-ui.html

4. First Login (seeded by DataSeeder)

username: admin
password: Admin@123

---

📡 API Reference

🔐 Auth

Method	Endpoint	Description
POST	/api/v1/auth/register	Register user
POST	/api/v1/auth/login	Login → get JWT

👩‍🎓 Students

Method	Endpoint	Access	Description
POST	/api/v1/students	ADMIN/TPO	Create student profile
GET	/api/v1/students	ADMIN/TPO	List all students
GET	/api/v1/students/{id}	All	Get student by ID
GET	/api/v1/students/roll/{rollNo}	All	Get by roll number
GET	/api/v1/students/branch/{branch}	All	Get by branch
PUT	/api/v1/students/{id}	All	Update profile
DELETE	/api/v1/students/{id}	ADMIN/TPO	Delete student
POST	/api/v1/students/{id}/resume	All	Upload PDF resume
PATCH	/api/v1/students/{id}/resume/verify	ADMIN/TPO	Verify resume
GET	/api/v1/students/unverified-resumes	ADMIN/TPO	Unverified resumes
PATCH	/api/v1/students/{id}/place	ADMIN/TPO	Mark as placed
GET	/api/v1/students/{id}/eligible-companies	All	⭐ All companies with eligibility
GET	/api/v1/students/{id}/eligible-companies/only	All	⭐ Only eligible companies

🏢 Companies

Method	Endpoint	Access	Description
POST	/api/v1/companies	ADMIN/TPO	Add company drive
GET	/api/v1/companies	All	List all companies
GET	/api/v1/companies/{id}	All	Get company details
GET	/api/v1/companies/status/{status}	All	Filter by status
PUT	/api/v1/companies/{id}	ADMIN/TPO	Update company
DELETE	/api/v1/companies/{id}	ADMIN	Delete company
GET	/api/v1/companies/{id}/eligible-students	ADMIN/TPO	Students eligible for this drive

📋 Applications

Method	Endpoint	Description
POST	/api/v1/applications	Apply to a company
GET	/api/v1/applications/student/{id}	Student's applications
GET	/api/v1/applications/company/{id}	Applications for a company
PATCH	/api/v1/applications/{id}/status	Update status
PATCH	/api/v1/applications/{id}/withdraw	Withdraw application

Application status flow:

APPLIED → SHORTLISTED → APTITUDE_TEST → GROUP_DISCUSSION
       → TECHNICAL_ROUND → HR_ROUND → OFFER_RECEIVED / REJECTED

📅 Interviews

Method	Endpoint	Description
POST	/api/v1/interviews	Schedule interview
PUT	/api/v1/interviews/{id}	Update / add feedback
GET	/api/v1/interviews/student/{id}	Student's interviews
GET	/api/v1/interviews/company/{id}	Company's interviews
GET	/api/v1/interviews/today	Today's interviews

📊 Statistics

Method	Endpoint	Description
GET	/api/v1/stats	Full placement dashboard stats

---

⭐ Bonus Feature – Eligibility Engine

The eligibility engine at EligibilityService checks 7 criteria per student-company pair:

1. CGPA          → Must meet minCgpa
2. Active Backlogs → Must be ≤ maxBacklogs
3. Historical Backlogs → If company disallows, totalBacklogs must be 0
4. Branch        → Must be in eligibleBranches list
5. Skills        → Missing skills flagged (advisory, doesn't block eligibility)
6. 10th %        → Must meet minTenthPercentage
7. 12th %        → Must meet minTwelfthPercentage
8. Placement Status → Already placed students are excluded

Sample Response

[
  {
    "companyId": 1,
    "companyName": "TechCorp Solutions",
    "jobRole": "Software Development Engineer",
    "ctcOffered": 12.0,
    "eligible": true,
    "reasons": [
      "✓ CGPA 8.50 meets requirement of 7.50",
      "✓ Active backlogs (0) within limit (0)",
      "✓ Branch 'CSE' is eligible",
      "✓ All required skills present",
      "✓ 10th 90% meets requirement",
      "✓ 12th 85% meets requirement"
    ],
    "missingSkills": []
  },
  {
    "companyId": 2,
    "companyName": "DataAI Inc",
    "jobRole": "Data Science Analyst",
    "ctcOffered": 15.0,
    "eligible": false,
    "reasons": [
      "CGPA 8.50 is below required 9.00"
    ],
    "missingSkills": ["Statistics"]
  }
]

---

📧 Email Notifications

Emails are sent asynchronously for:

• ✅ Application submitted
• 🔄 Application status changed
• 📅 Interview scheduled / rescheduled
• ⏰ Interview reminder (24h before – auto-scheduled)
• ✓ Resume verified
• 🎉 Placement congratulations

Configure Gmail: generate an App Password at https://myaccount.google.com/apppasswords

---

🗄️ Database Schema (Auto-created by Hibernate)

users              → id, username, email, password, enabled
user_roles         → user_id, role

students           → id, roll_number, first_name, last_name, email, branch,
                     cgpa, backlog_count, total_backlogs, resume_url,
                     resume_verified, placement_status, placed_company, ctc_offered ...
student_skills     → student_id, skill

companies          → id, name, industry, job_role, ctc_offered, min_cgpa,
                     max_backlogs, drive_status, drive_date ...
company_required_skills  → company_id, skill
company_eligible_branches → company_id, branch

applications       → id, student_id, company_id, status, remarks, applied_at
interviews         → id, student_id, company_id, interview_type, round_number,
                     scheduled_at, mode, status, feedback, score, email_sent

---

🧪 Running Tests

mvn test

Tests use H2 in-memory database — no MySQL required.

---

🔒 Security

• JWT-based stateless auth
• Role-based access: ROLE_STUDENT, ROLE_TPO, ROLE_ADMIN
• Passwords BCrypt-hashed
• Swagger UI open (disable in production)

---

🛠️ Tech Stack

Layer	Technology
Framework	Spring Boot 3.2
ORM	Hibernate / Spring Data JPA
Database	MySQL 8
Security	Spring Security + JWT
Email	Spring Mail (SMTP)
Docs	SpringDoc OpenAPI (Swagger UI)
Build	Maven
Java	17