Contact person: Web-Based Training Tracker Development

Phone:Show

Email:Show

Location: Gurugram, India

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"1. Login (Employee Entry Point)
Employee scans QR code of their department or directly opens the portal link.
Portal asks: “Enter Employee Code”.
Backend (getEmployeeDetails) checks MasterData.
If found → shows Welcome message + opens main dashboard.
If not found → shows “Employee not found” with debug info.
2. Main Dashboard (Tabs)
After login, employees see 3 tabs:
(A) Attendance Tab
Shows today’s planned sessions for their hospital/department.
Employee selects:
Session (pre-fetched from training_calendar).
Time slot (drop-down).
Date is auto-picked from system (employees cannot select past/future).
On submit:
Record is appended into training_data with timestamp.
If they try to mark for wrong date → blocked unless Corp L&D overrides.
Confirmation shown: ✅ “Attendance submitted for [Name]”.
(B) Passport Tab
Fetches all past trainings from training_data for that employee.
Displays in a table:
Date
Topic
Trainer
Duration / Time Slot
Button: Download Passport (generates CSV from Drive, gives link).
(C) Calendar Tab
Displays sessions from training_calendar.
Employee (normal role): View only.
Department Champion: Can add/edit sessions for their own department.
Corp L&D: Can add/edit sessions for all units.
3. Roles & Permissions
Defined in [login to view URL]:
Employee
Login
Mark attendance
View passport
View calendar
DeptChampion
Above + Add/Edit calendar for their department
Cannot edit past sessions
Unit L&D
Above + Add/Delete employees in their unit
Generate monthly reports for their unit
Corp L&D
Full authority across all units
Add/Edit employee master
Update past attendance
Cancel/postpone sessions
Generate reports across all hospitals
4. Data Storage (Google Sheets Tabs)
1. MasterData
emp_code | emp_name | department | designation | doj | hospital_id | role | status
2. training_calendar
session_id | hospital_id | department | topic | trainer | planned_date | planned_time | duration | session_type | status | created_by
3. training_data
timestamp | emp_code | emp_name | department | designation | doj | hospital_id | session_id | topic | trainer | attendance_time | time_slot
5. Reporting
Employee Passport: Downloadable CSV for individual.
Unit Report: Unit L&D can generate monthly CSV for their hospital.
Corporate Report: Corp L&D can generate consolidated monthly CSV across hospitals.
6. Special Cases (Business Rules)
Employees cannot mark attendance for past/future dates.
Only Corp L&D can update attendance retroactively.
Calendar changes:
Dept Champion can update their dept’s schedule.
Corp L&D can update for all units (including in case trainer is absent).
Cancelled sessions stay in calendar but are flagged Cancelled.
Example Flow (Employee marking attendance)
1. Employee opens portal → enters code → Welcome.
2. Portal shows today’s sessions for their hospital & dept.
3. Employee picks session + time slot → clicks Submit.
4. System:
Validates date = today.
Saves in training_data.
Confirms success.
5. Employee clicks Passport tab → sees full history.
6. Option to download CSV.
Example Flow (Corp L&D adding a session)
[login to view URL] logs in with role = CorpLD.
2. Goes to Calendar tab.
3. Sees “Add Session” form.
4. Fills details → submits.
5. Record appended in training_calendar.
6. Session becomes visible for employees of that hospital/dept.
In short:
Employees → attendance + passport + calendar view.
Dept Champions → manage calendar for their dept.
Unit L&D → manage employees + reporting for their hospital.
Corp L&D → everything across all units." (client-provided description)