Employee Portal & Admin Management System

Employee Portal Project – Detailed Description 1. Project Overview The Bharatiya Care Employee Portal is a web-based system where employees can: Mark their daily attendance Add customers in the field Track target-based daily and monthly earnings The admin portal will allow: Employee management Providing customer details to employees Viewing daily/monthly reports and employee earnings 2. User Roles & Responsibilities A. Admin Login/Logout – Admin credentials access Employee Management – Create, Edit, Delete employees Customer Assignment – Assign customers or areas to employees Reports & Analytics – View daily/monthly reports: Number of customers added per employee Total earnings / commission B. Employee Login/Logout – Employee ID and password Attendance – Record login and logout time Customer Addition – Add customers in the field: Name, Mobile, Address, Plan, Card Number Earnings / Targets – System calculates daily/monthly earnings automatically 3. Database Design Tables & Columns 1) Employees Table id – Primary Key name – Employee Name emp_id – Unique Employee ID password – Employee login password 2) Attendance Table id – Primary Key emp_id – Employee ID (FK) date – Attendance date login_time – Login time logout_time – Logout time 3) Customers Table id – Primary Key name – Customer Name mobile – Mobile Number address – Customer Address card_number – Bharatiya Care Card Number plan – Plan Name added_by – Employee ID who added the customer added_date – Date the customer was added 4) Targets / Payment Rules Table (Optional) Define number of customers and corresponding payment / commission 4. Workflow (Step by Step) Admin Workflow Admin logs into the portal Views employee list and adds new employees Assigns customer lists or areas to employees Checks reports for daily/monthly performance: Number of customers added by each employee Daily/monthly earnings Employee Workflow Employee logs into the portal Marks attendance (login) Goes to the field and adds customers: Form fields: Name, Mobile, Address, Card Number, Plan System records Employee ID, customer details, and date Daily/monthly earnings calculated automatically Employee logs out, logout time recorded 5. Business Logic / Rules Attendance required to add customers Commission / payment based on customers added: 50 customers → ₹15 per customer 100 customers → ₹25 per customer 200 customers → ₹10,000 per month Admin can edit targets or commission rules Employees can only view their own customers and earnings 6. Features & Pages Admin Panel Login page Dashboard (summary of employees, customers, earnings) Employee Management (Add/Edit/Delete) Customer Assignment Reports & Export Employee Panel Login page Attendance Page (Login / Logout) Add Customer Page Earnings / Target Page 7. Tech Stack Suggestion Frontend: HTML, CSS, JavaScript, Bootstrap (for responsive UI) Backend: PHP Database: MySQL Optional: Ajax / jQuery for smoother user experience 8. Deliverables Admin login + dashboard Employee login + dashboard Attendance tracking Customer addition form Daily / Monthly earnings calculation Database schema ready Reports for Admin

Project ID: 39749102