BMP Web App

Enhance the Transfer History API (/api/finance/transfer-history) to support filtering so transfer records can be retrieved based on selected criteria. This is required for proper handling of filtered finance history data from the frontend.

The API should support relevant filters such as date range and other applicable transfer-level filters if needed.

🔗 API:

GET /api/finance/transfer-history

🎯 Scope of Work:
Add backend filter handling in transfer history API
Support filtering transfer records based on request query params
Return filtered transfer history data in consistent response structure
Ensure filters work correctly with pagination, if already implemented
🛠️ Tasks:
Add query param support in /api/finance/transfer-history
Implement date range filter (start_date, end_date)
Add optional status filter if required
Add optional transfer type filter if required
Apply filters at query/database level
Validate filter values and formats
Keep response structure unchanged
Handle empty filtered result gracefully
Ensure compatibility with existing pagination/sorting
Test API with single and combined filters
📥 Suggested Query Params:
start_date
end_date
status (optional)
type (optional, if applicable)
page (if already exists)
limit (if already exists)
📤 Example Request:
GET /api/finance/transfer-history?start_date=2024-05-10&end_date=2024-09-30&status=completed
✅ Acceptance Criteria:
Transfer history API supports date range filtering
Filtered data is returned correctly based on query params
Invalid filter inputs return proper validation error
Empty result returns success response with empty array
Existing API behavior remains unchanged when no filters are provided
Pagination and sorting continue to work correctly with filters
⚠️ Edge Cases:
start_date greater than end_date
Invalid date format
No records found for selected filter
Unsupported status/type passed
Combined filters returning no results