Task #150
Updated by Varsha N 6 days ago
Module: Admin → Specialization Report
Develop a Specialization Report in the Admin Module to view patient investigation results categorized based on doctor specialization. The report should retrieve data by integrating patient details, doctor information, specialization, and investigation parameter results.
The report listing should contain the following columns:
Patient ID
Patient Name
Doctor Name
Specialization
Parameter Name
Result Value
Implement filter options at the top of the report screen with:
From Date – To Date
Specialization dropdown
Doctor dropdown
Patient ID search field
The system should dynamically load report data according to selected filters without page reload. Proper database joins must be implemented between patient, doctor, specialization, and investigation result tables to ensure accurate data retrieval. Add pagination and sorting support for better performance and usability in the admin panel. Ensure the API response structure supports future export options such as Excel or PDF reports.
Sir,
Docdesk
Ann Maria chechi kk
Results save cheyynda table.
TABLE:
Specialisation_parameter_result
------------------------------
id (PK)
hospital_id (FK )
Specialization_id (FK)
visit_id (FK)
parameter_id (FK)
Parameter_name
result_value
created_at DATETIME
updated_at DATETIME