DOCDESK

Task: Investigation-wise Report (Admin Module)
Task Objective:
Implement an Investigation-wise Report in the Admin module to show how many times each investigation has been ordered within a selected time period.
This report helps the admin analyze test usage patterns within the hospital.

⚠️ No new database tables or columns should be added.
All data must be derived from existing tables.

Navigation:
Admin Login → Reports → Investigation-wise Report

Report Details,Fields to Display:
Serial Number
Investigation Name
Category (if available)
Total Count (number of times ordered)

Summary Section:
Total unique investigations
Total investigations ordered

Filters:
Today
Monthly
Yearly
From Date – To Date (custom range)
Doctor
(Filter based on consultation date)

Features to Implement:
Load report based on selected time filter
Group investigations using GROUP BY investigation_id
Count total occurrences using COUNT()
Display data in tabular format
Show summary totals below the table
Pagination support
Read-only report

Validations & Rules:
From Date must not be greater than To Date
Date range required for custom filter
Only completed consultations included
Admin can view only their hospital’s data
Disable report button during API call

Completion Criteria:
Investigation counts accurate
All filters working correctly
Hospital data isolation maintained
No schema changes