mars-employee

byKushmitha L

Build a complete Employee Management Web Application using the following requirements. 🔹 Tech Stack: - Frontend: HTML, CSS, JavaScript (or React.js if advanced) - Backend: PHP (use XAMPP server) - Database: MySQL (preferred) or Supabase / NoSQL (optional) - Use APIs wherever required - Use GitHub for version control 🔹 Core Features: 1. Admin Panel: - View total employees report - Export reports to Excel or Google Sheets - View individual employee reports - Calculate salary based on working hours - Track employee working period 2. Employee Dashboard: - Display number of projects - Show ongoing projects - Track number of leads used - Show positive leads - Show junk leads - Allow employee to submit daily report (EOD update) 3. Attendance & Salary Logic: - Monthly working days = 29 + 2 - Full Day = if working hours ≥ 8 hours - Half Day = if working hours ≥ 4 hours - If working hours < 4 → consider as Holiday - Every Monday should be automatically marked as week off - Salary should be calculated based on total working hours 4. Leave Management: - Create a leave approval page - Employees can request leave - Admin can approve/reject leave 🔹 Backend Requirements: - Create REST APIs using PHP - Handle CRUD operations (Create, Read, Update, Delete) - Secure login system for Admin and Employees - Use MySQL database with proper schema 🔹 Database Tables: - Employees (id, name, email, password) - Attendance (id, emp_id, date, hours) - Projects (id, emp_id, total_projects, ongoing_projects, leads_used, positive_leads, junk_leads) - Leaves (id, emp_id, from_date, to_date, status) 🔹 Additional Features: - Authentication (Login & Logout) - Responsive UI design - Dashboard with summary cards - Error handling and validations - Clean and modular code 🔹 Deployment Setup: - Use XAMPP (Apache + MySQL + PHP) - Project should run on localhost - Provide clear folder structure 🔹 Output Required: - Full source code (frontend + backend) - Database schema (SQL file) - Instructions to run the project - Optional: React version of frontend 🔹 Bonus (if possible): - Export reports to Excel - Use Chart.js for analytics dashboard - Clean UI design