mars-employee
Kushmitha LBuild 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
Comments (0)
Sign in to leave a comment
System Requirements
mars-employee System Requirements Document
Introduction
The "mars-employee" project is an Employee Management Web Application designed to streamline and automate the management of employee data, attendance, salary calculations, and leave management. This document outlines the system requirements for the development and deployment of the application.
System Overview
The mars-employee application will provide a comprehensive solution for managing employee-related tasks within an organization. It includes features for both administrators and employees, ensuring efficient data handling, reporting, and user interaction. The application will be built using a robust tech stack, ensuring scalability and ease of maintenance.
Functional Requirements
- As an Admin, I should be able to view total employees report.
- As an Admin, I should be able to export reports to Excel or Google Sheets.
- As an Admin, I should be able to view individual employee reports.
- As an Admin, I should be able to calculate salary based on working hours.
- As an Admin, I should be able to track employee working periods.
- As an Employee, I should be able to view the number of projects.
- As an Employee, I should be able to see ongoing projects.
- As an Employee, I should be able to track the number of leads used.
- As an Employee, I should be able to see positive leads.
- As an Employee, I should be able to see junk leads.
- As an Employee, I should be able to submit a daily report (EOD update).
- As an Admin, I should be able to manage attendance and salary logic.
- As an Admin, I should be able to create a leave approval page.
- As an Employee, I should be able to request leave.
- As an Admin, I should be able to approve or reject leave requests.
User Personas
- Admin: Responsible for managing employee data, reports, and leave approvals.
- Employee: Can view personal project details, submit reports, and request leaves.
Visuals Colors and Theme
- primary: #2A9D8F (Teal)
- primary_light: #A8DADC (Light Teal)
- secondary: #E63946 (Crimson)
- accent: #F4A261 (Orange)
- highlight: #E9C46A (Gold)
- bg: #F1FAEE (Off White)
- surface: rgba(233, 233, 233, 0.8)
- text: #264653 (Dark Blue)
- text_muted: #6D6875 (Muted Gray)
- border: rgba(38, 70, 83, 0.2)
Signature Design Concept
The mars-employee application will feature an interactive galaxy map on the homepage, where each star represents a feature or section of the application. Users can click on stars to open task cards, drag to rotate the cluster, and hover to highlight connections. This concept will be brought to life using @react-three/fiber and @react-three/drei for 3D interactions, providing a unique and engaging user experience.
Interaction Model & Motion Direction
The landing page will utilize a "parallax" interaction model, creating a layered depth effect as users scroll. Decorative elements will move at different speeds, enhancing the storytelling aspect of the application. Internal pages will maintain a "static" interaction model for clarity and ease of use.
Non-Functional Requirements
- The system should be responsive and accessible on various devices.
- Ensure data security and privacy for all user information.
- Maintain high performance and quick load times.
Tech Stack
- Frontend: HTML, CSS, JavaScript (React.js optional)
- Backend: PHP (XAMPP server)
- Database: MySQL (preferred), Supabase/NoSQL (optional)
- Version Control: GitHub
Assumptions and Constraints
- The application will be deployed on a local server using XAMPP.
- The system will handle a moderate number of concurrent users.
- The application will be developed with scalability in mind for future enhancements.
Glossary
- EOD: End of Day
- CRUD: Create, Read, Update, Delete
- REST API: Representational State Transfer Application Programming Interface
This document provides a comprehensive overview of the requirements and design for the mars-employee project, ensuring a clear path forward for development and deployment.
EmpowerYourWorkforce
AI-drivenemployeemanagementthatstreamlinesattendance,salary,reporting,andleaveapprovals—allinoneplatform.
Interactive Galaxy Map
Explore the mars-employee Universe
Each star represents a core feature of the platform. Click to discover, drag to explore, hover to reveal connections.
Drag to rotate · Click a star to explore · Hover for connections
Everything You Need to Manage Your Team
From real-time analytics to automated payroll, mars-employee puts powerful workforce tools at your fingertips.
Real-Time Reports
View total employee reports instantly, export to Excel or Google Sheets, and drill into individual performance data.
Salary Automation
Calculate salaries based on working hours and attendance automatically. No more manual spreadsheets or payroll errors.
Attendance Tracking
Track employee working periods with precision. Monitor check-ins, working hours, and overtime in one dashboard.
Leave Management
Employees request leave, admins approve or reject with a single click. Full visibility into team availability.
EOD Updates
Employees submit daily end-of-day reports covering projects, leads used, positive leads, and junk leads.
Employee Hub
A central directory for all employee data — projects, ongoing work, lead tracking, and performance at a glance.
Built for Admins
Complete control over employee data, reports, and payroll. Every tool an administrator needs to manage the workforce efficiently — from attendance tracking to leave approvals.
- View Total Employees ReportAccess a comprehensive overview of your entire workforce in one dashboard.
- Export to Excel & Google SheetsOne-click export of any report to spreadsheet formats for offline analysis.
- Individual Employee ReportsDrill down into detailed performance and activity data per employee.
- Salary Calculation by HoursAutomated payroll based on tracked working hours and attendance records.
- Attendance TrackingMonitor check-ins, working periods, and overtime across the organization.
- Leave ApprovalsReview, approve, or reject leave requests with a streamlined workflow.
Workforce insights at your fingertips
Real-time visibility into attendance, salary, and employee performance — all from a single command center.
Empowering Employees
Everything you need to stay productive, track your work, and manage your time — all from a single, intuitive dashboard.
- View ProjectsAccess a clear overview of all assigned projects and their current status.
- Track Ongoing ProjectsMonitor real-time progress on active projects with milestones and deadlines.
- Monitor Positive LeadsKeep tabs on promising leads and conversion opportunities in one place.
- Identify Junk LeadsQuickly filter and flag unqualified leads to focus on what matters.
- Submit Daily EOD ReportsLog end-of-day updates with a streamlined submission workflow.
- Request & Track LeaveSubmit leave requests and follow approval status in real time.
Get Started in Minutes
Five simple steps to transform how you manage your workforce with mars-employee.
Sign Up
Create your admin account in under a minute with just your email and organization name.
Access Dashboard
Get instant access to your centralized dashboard with employee metrics and reports.
Configure Settings
Set up attendance rules, salary logic, leave policies, and reporting preferences.
Invite Team
Add employees to the platform so they can track projects, leads, and submit EOD reports.
Go Live
Start managing attendance, salaries, and leave approvals — all from one place.
Trusted by Teams Everywhere
mars-employee delivers measurable results for employee management, attendance tracking, and workforce analytics.
Ready to Transform Your Workforce?
Join organizations that trust mars-employee to streamline attendance, automate salary calculations, manage leave approvals, and empower every team member with real-time insights.
Frequently Asked Questions
Everything you need to know about mars-employee. Can't find your answer? Reach out to our team.
No comments yet. Be the first!