Enhancement : Add Progress Status Filter to Attendance Report (Using Existing Status Field)

Description

Enhance the existing Attendance Report by adding a filter for Progress Status using the already stored status field.

No percentage-based calculation should be implemented. The filter must rely directly on the existing progress_status column.

---

steps to reproduce :

Admin : Open the application: http://test.tadreeblms.com/ Login using admin credentials: Username: [testadmin@tadreeblms.com] Password: 123456 Go to reports -> Attendance reports

Requirements

1️⃣ Progress Status Filter

Add dropdown filter:

• Not Started
• In Progress
• Completed

2️⃣ Implementation Details

• Use existing progress_status field from database
• Do not calculate status from progress percentage
• Ensure filter works with existing filters (course, department, date, etc.)
• Maintain pagination

3️⃣ Performance

• Ensure indexed column is used
• Avoid additional joins or calculations
• Keep query optimized

4️⃣ UI Placement

• Add filter inside Advanced Search section
• Maintain consistent UI styling

---

Acceptance Criteria

• Progress Status dropdown visible in filter section
• Filtering works correctly using stored status
• Can combine with other filters
• No performance degradation
• Pagination respects selected filter "