Sub module #2562
Updated by Thara S Pillai about 2 years ago
Develop a database function (version 1) get_db_ana ()
inputs: {"from_date":"", "to_date":"", "user_id":"", "district_id":", "fhc_id":"", "date_range": ""}
and returning a json with {"total_no_patients": "", "total_image_captured": "", "no_fhcs": "", "dist_pat_dis":[{"dis_id": "", "dis_pat_per": "" }]}.
The first version of the database function need to filter data based on from_date, to_date
Tables to refer:
FROM dctc.patient_registration pr
LEFT JOIN dctc.patient_fundus_imges_api pat_api
ON pr.glob_patient_reg_id = pat_api.glob_patient_reg_id