VetsLab

Task #108

Updated by Varsha N 16 days ago

MODULE: Test Results (Based on Selected Tests in Registration) 

 Navigation: Login → Sidebar → Test Results 
 🎯 TASK OBJECTIVE: 
 Develop Test Results module where: 
	 • 	 User searches a registration 
	 • 	 System automatically loads the tests selected during registration 
	 • 	 Parameters are fetched based on selected tests 
	 • 	 Result entry is dynamic 
	 • 	 Results saved per parameter 
	 • 	 No manual test selection in this module 

 🧠 IMPORTANT LOGIC CHANGE 

 In registration table: 
 lab_test (JSON) 
 Example: 
 [1, 3] 
 Means: 
	 • 	 Test ID 1 (CBC) 
	 • 	 Test ID 3 (LFT) 

 So Test Results page must: 
	 1. 	 Read lab_test 
	 2. 	 Fetch parameters for each test 
	 3. 	 Render grouped result sections 

 PART 1 — FRONTEND IMPLEMENTATION 

 ✅ 1. Sidebar Menu 

 Add menu: Test Results 

 ✅ 2. Search Registration Section 

 Search by: 
	 • 	 Patient ID 
	 • 	 Date 
	 • 	 Owner Name 
         • 	 Mobile number  

 Display listing: 
 | Patient ID | Patient Name | Tests | Date | Action | 
 Action: 
 Enter Results 

 ✅ 3. After Clicking “Enter Results” 

 Show patient details (Read Only): 
	 • 	 Patient ID 
	 • 	 Patient Name 
	 • 	 Owner Name 
	 • 	 Species 
	 • 	 Breed 
	 • 	 Registration Date 

 ✅ 4. Load Selected Tests Automatically 
 From registration: 
 lab_test = [1, 3] 

 System must: 
	 • 	 Loop through each test_id 
	 • 	 Fetch test name 
	 • 	 Fetch parameters for each test 

 ✅ 5. Dynamic Result Entry UI 
 Results must be grouped by Test. 

 Example UI: 
 🔹 CBC 

 Parameter 	 Input 
 HB 	         [ Decimal Input ] 
 WBC 	         [ Number Input ] 
 COLOR 	         [ Dropdown ] 

 🔹 LFT 

 Parameter 	 Input 
 SGPT 	         [ Decimal Input ] 
 Bilirubin 	 [ Decimal Input ] 


 🎨 Rendering Rules 

 Parameter Type 	 UI 
 INTEGER 	         Number input 
 DOUBLE 	         Decimal input 
 VARCHAR 	         Text input 
 SELECT 	         Dropdown 
 CHECKBOX 	 Multi select 
 OPTION 	         Radio button 

 ✅ 6. Save Button 

 On click: 
	 • 	 Collect results for all tests 
	 • 	 Send structured payload 

 ⚙ PART 2 — BACKEND IMPLEMENTATION 

 ✅ 1. Table: test_result 

 id                   PK 
 patient_id           FK 
 enterprise_id        FK 
 registration_id      FK 
 test_id              FK 
 parameter_id         FK 
 parameter_name       FK 
 test_value           result_value         TEXT  
 added_date           DATE-TIME 

 ✅ 2. API — Get Registration 
 GET /api/registration/{id} 
 Return: 
	 • 	 Registration details 
	 • 	 lab_test JSON 


 ✅ 3. API — Get Parameters for Multiple Tests 
 GET /api/tests/{registration_id}/parameters/ 
 Backend Logic: 
	 • 	 Read registration.lab_test 
	 • 	 Fetch all parameters for those tests 
	 • 	 Return grouped response 

 Example response: 

 { 
   "tests": [ 
     { 
       "test_id": 1, 
       "test_name": "CBC", 
       "parameters": [...] 
     }, 
     { 
       "test_id": 3, 
       "test_name": "LFT", 
       "parameters": [...] 
     } 
   ] 
 } 

 ⸻ 

 ✅ 4. Save Results API 

 POST /api/test-results/ 

 Payload Example: 

 { 
   "registration_id": 101, 
   "results": [ 
     { 
       "test_id": 1, 
       "parameter_id": "HB", 
       "value": 13.5 
     }, 
     { 
       "test_id": 3, 
       "parameter_id": "SGPT", 
       "value": 45 
     } 
   ] 
 } 


 Backend Processing 

 ✔ Validate registration exists 
 ✔ Validate test belongs to registration 
 ✔ Validate parameter belongs to test 
 ✔ Validate value type 
 ✔ Store enterprise_id 

 ⸻ 

 🔐 VALIDATION RULES 

 Same as Parameter module: 
 Type 	        Rule 
 INTEGER 	        Whole number only 
 DOUBLE 	        Decimal allowed 
 VARCHAR 	        Text 
 SELECT 	        Must match one option 
 CHECKBOX         All values must match options 
 OPTION 	        Only one allowed 


 🔄 SYSTEM FLOW 

 Registration created 
 → Tests selected and stored in lab_test 
 → User opens Test Results 
 → Select registration 
 → System loads tests automatically 
 → Render dynamic parameter UI 
 → Save results 

 ✅ COMPLETION CRITERIA 

 ✔ No manual test selection 
 ✔ Multiple tests handled 
 ✔ Dynamic UI grouped by test 
 ✔ Validation enforced 
 ✔ Results saved correctly 
 ✔ Enterprise filtering working 

Back