Project

General

Profile

Actions
Copy link

Activity #2565

closed

Module #2559: Dashboard - Analytics

Sub module #2560: Development for Level 0 (State level default)

Sub module #2562: Development of database functions

Develop a database function for fetching data for Level 0 dashboard view

Added by Thara S Pillai about 2 years ago. Updated about 2 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Shameera S L
Target version:
Version 3.0
Start date:
05/20/2024
Due date:
05/21/2024
% Done:

100%

Estimated time:
Planned Due Date:

Description

Inputs:
"{
""daterange"": ""Last-7-days OR Last-30-days"",
""cust_from_date"": """",
""cust_end_date"": """",
""district_id"": """",
""fhc_id"": """",
""login_user_id"": """"
}"
Output
"{
""p1_total_no_patients"": """",
""p2_total_image_captured"": """",
""p3_fhcs"": [{""district_id"": """", ""no_fhcs"": """", ""no_fhcs_naya_active"": """"}],
""p3_district_fhcs"": [{""district_id"": """", ""district_name"": """", ""fhc_id"": """", ""fhc_name"": """", ""is_naya_active"": """"}],
""p4_dist_pat"":{""total_no_patients"": """", ""dist_pat"": [{""district_id"": """", ""district_name"": """", ""no_patients"": """", ""district_pat_per"": """"}]},
""p5_dist_imag"":{""total_no_images"": """", ""dist_imag"": [{""district_id"": """", ""district_name"": """", ""no_images"": """", ""district_imag_per"": """"}]},
""p6_grad_perfparam"": {""sensitivity"": """", ""specificity"": """", ""tp"": """", ""tn"": """", ""fp"": """", ""fn"": """"},
""p7_dr_perfparam"": {""sensitivity"": """", ""specificity"": """", ""tp"": """", ""tn"": """", ""fp"": """", ""fn"": """"},
""p8_state_consult_l0"":{""tot_patients"": """", ""x_range_mode"": ""DforDate_MforMonth_YforYear"", ""plot_values"": [{""date"": ""When x_range_mode is D"", ""month_no"": ""When x_range_mode is M"", ""month_name"": ""When x_range_mode is M"", ""month_year"": ""When x_range_mode is M, year of month"", ""year"": ""When x_range_mode is Y"", ""y_pat_count"": """"}]},
""p9_state_grad_l0"":{""tot_images"": """", ""x_range_mode"": ""DforDate_MforMonth_YforYear"", ""plot_values"": [{""date"": ""When x_range_mode is D"", ""month_no"": ""When x_range_mode is M"", ""month_name"": ""When x_range_mode is M"", ""month_year"": ""When x_range_mode is M, year of month"", ""month_name_year"": """", ""year"": ""When x_range_mode is Y"", ""y_img_count_man_good"": """", ""y_img_count_ai_good"": """", ""y_img_count_man_bad"": """", ""y_img_count_ai_bad"": """"}]},
""p10_state_dr_l0"":{""tot_images"": """", ""x_range_mode"": ""DforDate_MforMonth_YforYear"", ""plot_values"": [{""date"": ""When x_range_mode is D"", ""month_no"": ""When x_range_mode is M"", ""month_name"": ""When x_range_mode is M"", ""month_year"": ""When x_range_mode is M, year of month"", ""month_name_year"": """", ""year"": ""When x_range_mode is Y"", ""y_img_count_man_dr"": """", ""y_img_count_ai_dr"": """"}]}
}
"

Actions
Copy link

Also available in: Atom PDF