Employee Portal & Admin Management System
Budget: ₹1,500 – ₹12,500 INR
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
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