DoH Dashboard กรมอนามัย

ร้อยละของเด็กอายุ 0-5 ปี มีภาวะเตี้ย ระดับเขตสุขภาพ

Template
ปีงบประมาณ
สถานการณ์รายพื้นที่ ไตรมาส 4

-------------------------------------------------------------------

array(82) { ["id"]=> string(2) "61" ["year"]=> string(4) "2019" ["kpi_template_id"]=> string(2) "61" ["sql_query"]=> string(1476) "SELECT IF(X.areacode!="TOTAL",areaname,"รวมทั้งหมด")as areaname_new, X.* FROM(SELECT IFNULL(Z.region_code,"TOTAL")as areacode,Z.region_name as areaname, MAX(K.date_com) AS report_date, SUM(K.targetq1+K.targetq2+K.targetq3+K.targetq4) as target, SUM(K.resultq1+K.resultq2+K.resultq3+K.resultq4) as result, ROUND( SUM(IFNULL(K.resultq1+K.resultq2+K.resultq3+K.resultq4,0))/SUM(IFNULL(K.targetq1+K.targetq2+K.targetq3+K.targetq4,0))*100,2 ) as total_ratio, ROUND( SUM(IFNULL(K.resultq1+K.resultq2+K.resultq3+K.resultq4,0))/SUM(IFNULL(K.targetq1+K.targetq2+K.targetq3+K.targetq4,0))*100,2 ) as chart_value, SUM(K.targetq1) as targetq1, SUM(K.targetq2) as targetq2, SUM(K.targetq3) as targetq3, SUM(K.targetq4) as targetq4, SUM(K.resultq1) as resultq1, SUM(K.resultq2) as resultq2, SUM(K.resultq3) as resultq3, SUM(K.resultq4) as resultq4, ROUND( SUM(IFNULL(K.resultq1,0))/SUM(IFNULL(K.targetq1,0))*100,2 ) as ratioq1, ROUND( SUM(IFNULL(K.resultq2,0))/SUM(IFNULL(K.targetq2,0))*100,2 ) as ratioq2, ROUND( SUM(IFNULL(K.resultq3,0))/SUM(IFNULL(K.targetq3,0))*100,2 ) as ratioq3, ROUND( SUM(IFNULL(K.resultq4,0))/SUM(IFNULL(K.targetq4,0))*100,2 ) as ratioq4 FROM s_low_risk05 K INNER JOIN cchangwat C ON C.changwatcode=LEFT(K.areacode,2) INNER JOIN cregion Z ON Z.region_code=C.regioncode WHERE K.id = '764b2e63b0ca3754f85e7b8b2cc5e9f9' AND K.b_year = :queryYear GROUP BY Z.region_code WITH ROLLUP) X " ["sql_query_province"]=> string(1456) "SELECT IF(X.areacode!="TOTAL",areaname,"รวมทั้งหมด")as areaname_new, X.* FROM (SELECT IFNULL(C.changwatcode,"TOTAL") as areacode,C.changwatname as areaname, MAX(K.date_com) AS report_date, SUM(K.targetq1+K.targetq2+K.targetq3+K.targetq4) as target, SUM(K.resultq1+K.resultq2+K.resultq3+K.resultq4) as result, ROUND( SUM(IFNULL(K.resultq1+K.resultq2+K.resultq3+K.resultq4,0))/SUM(IFNULL(K.targetq1+K.targetq2+K.targetq3+K.targetq4,0))*100,2 ) as total_ratio, ROUND( SUM(IFNULL(K.resultq1+K.resultq2+K.resultq3+K.resultq4,0))/SUM(IFNULL(K.targetq1+K.targetq2+K.targetq3+K.targetq4,0))*100,2 ) as chart_value, SUM(K.targetq1) as targetq1, SUM(K.targetq2) as targetq2, SUM(K.targetq3) as targetq3, SUM(K.targetq4) as targetq4, SUM(K.resultq1) as resultq1, SUM(K.resultq2) as resultq2, SUM(K.resultq3) as resultq3, SUM(K.resultq4) as resultq4, ROUND( SUM(IFNULL(K.resultq1,0))/SUM(IFNULL(K.targetq1,0))*100,2 ) as ratioq1, ROUND( SUM(IFNULL(K.resultq2,0))/SUM(IFNULL(K.targetq2,0))*100,2 ) as ratioq2, ROUND( SUM(IFNULL(K.resultq3,0))/SUM(IFNULL(K.targetq3,0))*100,2 ) as ratioq3, ROUND( SUM(IFNULL(K.resultq4,0))/SUM(IFNULL(K.targetq4,0))*100,2 ) as ratioq4 FROM s_low_risk05 K INNER JOIN cchangwat C ON C.changwatcode=LEFT(K.areacode,2) WHERE K.id = '764b2e63b0ca3754f85e7b8b2cc5e9f9' AND K.b_year = :queryYear AND C.regioncode = :region GROUP BY C.changwatcode WITH ROLLUP) X" ["sql_query_ampur"]=> string(1547) "SELECT IF(X.areacode!="TOTAL",areaname,"รวมทั้งหมด")as areaname_new, X.* FROM (SELECT IFNULL(concat(C.changwatcode,A.ampurcode),"TOTAL") as areacode,A.ampurname as areaname, MAX(K.date_com) AS report_date, SUM(K.targetq1+K.targetq2+K.targetq3+K.targetq4) as target, SUM(K.resultq1+K.resultq2+K.resultq3+K.resultq4) as result, ROUND( SUM(IFNULL(K.resultq1+K.resultq2+K.resultq3+K.resultq4,0))/SUM(IFNULL(K.targetq1+K.targetq2+K.targetq3+K.targetq4,0))*100,2 ) as total_ratio, ROUND( SUM(IFNULL(K.resultq1+K.resultq2+K.resultq3+K.resultq4,0))/SUM(IFNULL(K.targetq1+K.targetq2+K.targetq3+K.targetq4,0))*100,2 ) as chart_value, SUM(K.targetq1) as targetq1, SUM(K.targetq2) as targetq2, SUM(K.targetq3) as targetq3, SUM(K.targetq4) as targetq4, SUM(K.resultq1) as resultq1, SUM(K.resultq2) as resultq2, SUM(K.resultq3) as resultq3, SUM(K.resultq4) as resultq4, ROUND( SUM(IFNULL(K.resultq1,0))/SUM(IFNULL(K.targetq1,0))*100,2 ) as ratioq1, ROUND( SUM(IFNULL(K.resultq2,0))/SUM(IFNULL(K.targetq2,0))*100,2 ) as ratioq2, ROUND( SUM(IFNULL(K.resultq3,0))/SUM(IFNULL(K.targetq3,0))*100,2 ) as ratioq3, ROUND( SUM(IFNULL(K.resultq4,0))/SUM(IFNULL(K.targetq4,0))*100,2 ) as ratioq4 FROM s_low_risk05 K INNER JOIN campur A ON A.ampurcodefull=LEFT(K.areacode,4) INNER JOIN cchangwat C ON C.changwatcode=A.changwatcode WHERE K.id = '764b2e63b0ca3754f85e7b8b2cc5e9f9' AND K.b_year = :queryYear AND C.changwatcode = :changwat AND flag_status=0 GROUP BY A.ampurcode WITH ROLLUP) X" ["sql_query_tambon"]=> string(1462) "SELECT IF(X.areacode!="TOTAL",areaname,"รวมทั้งหมด")as areaname_new, X.* FROM (SELECT IFNULL(concat(C.tamboncodefull),"TOTAL") as areacode, C.tambonname as areaname, MAX(K.date_com) AS report_date, SUM(K.targetq1+K.targetq2+K.targetq3+K.targetq4) as target, SUM(K.resultq1+K.resultq2+K.resultq3+K.resultq4) as result, ROUND( SUM(IFNULL(K.resultq1+K.resultq2+K.resultq3+K.resultq4,0))/SUM(IFNULL(K.targetq1+K.targetq2+K.targetq3+K.targetq4,0))*100,2 ) as total_ratio, ROUND( SUM(IFNULL(K.resultq1+K.resultq2+K.resultq3+K.resultq4,0))/SUM(IFNULL(K.targetq1+K.targetq2+K.targetq3+K.targetq4,0))*100,2 ) as chart_value, SUM(K.targetq1) as targetq1, SUM(K.targetq2) as targetq2, SUM(K.targetq3) as targetq3, SUM(K.targetq4) as targetq4, SUM(K.resultq1) as resultq1, SUM(K.resultq2) as resultq2, SUM(K.resultq3) as resultq3, SUM(K.resultq4) as resultq4, ROUND( SUM(IFNULL(K.resultq1,0))/SUM(IFNULL(K.targetq1,0))*100,2 ) as ratioq1, ROUND( SUM(IFNULL(K.resultq2,0))/SUM(IFNULL(K.targetq2,0))*100,2 ) as ratioq2, ROUND( SUM(IFNULL(K.resultq3,0))/SUM(IFNULL(K.targetq3,0))*100,2 ) as ratioq3, ROUND( SUM(IFNULL(K.resultq4,0))/SUM(IFNULL(K.targetq4,0))*100,2 ) as ratioq4 FROM s_low_risk05 K INNER JOIN ctambon C ON C.tamboncodefull=LEFT(K.areacode,6) WHERE K.id = '764b2e63b0ca3754f85e7b8b2cc5e9f9' AND K.b_year = :queryYear AND C.ampurcode = :ampur GROUP BY C.tamboncodefull WITH ROLLUP) X" ["sql_query_trend"]=> string(428) "SELECT K.b_year, ROUND(SUM(IFNULL(K.resultq1+K.resultq2+K.resultq3+K.resultq4,0))/SUM(IFNULL(K.targetq1+K.targetq2+K.targetq3+K.targetq4,0))*100,2 ) as total_ratio FROM s_low_risk05 K INNER JOIN cchangwat C ON C.changwatcode=LEFT(K.areacode,2) INNER JOIN cregion Z ON Z.region_code=C.regioncode WHERE K.id = '764b2e63b0ca3754f85e7b8b2cc5e9f9' AND K.b_year BETWEEN :queryYearPrev and :queryYear group by K.b_year " ["sql_query_trend_province"]=> string(458) "SELECT K.b_year, ROUND(SUM(IFNULL(K.resultq1+K.resultq2+K.resultq3+K.resultq4,0))/SUM(IFNULL(K.targetq1+K.targetq2+K.targetq3+K.targetq4,0))*100,2 ) as total_ratio FROM s_low_risk05 K INNER JOIN cchangwat C ON C.changwatcode=LEFT(K.areacode,2) INNER JOIN cregion Z ON Z.region_code=C.regioncode WHERE K.id = '764b2e63b0ca3754f85e7b8b2cc5e9f9' AND K.b_year BETWEEN :queryYearPrev and :queryYear AND C.regioncode = :region group by K.b_year " ["sql_query_trend_ampur"]=> string(462) "SELECT K.b_year, ROUND(SUM(IFNULL(K.resultq1+K.resultq2+K.resultq3+K.resultq4,0))/SUM(IFNULL(K.targetq1+K.targetq2+K.targetq3+K.targetq4,0))*100,2 ) as total_ratio FROM s_low_risk05 K INNER JOIN cchangwat C ON C.changwatcode=LEFT(K.areacode,2) INNER JOIN cregion Z ON Z.region_code=C.regioncode WHERE K.id = '764b2e63b0ca3754f85e7b8b2cc5e9f9' AND K.b_year BETWEEN :queryYearPrev and :queryYear AND C.changwatcode = :changwat group by K.b_year " ["sql_query_trend_tambon"]=> string(401) "SELECT K.b_year, ROUND(SUM(IFNULL(K.resultq1+K.resultq2+K.resultq3+K.resultq4,0))/SUM(IFNULL(K.targetq1+K.targetq2+K.targetq3+K.targetq4,0))*100,2 ) as total_ratio FROM s_low_risk05 K INNER JOIN ctambon C ON C.tamboncodefull=LEFT(K.areacode,6) WHERE K.id = '764b2e63b0ca3754f85e7b8b2cc5e9f9' AND K.b_year BETWEEN :queryYearPrev and :queryYear AND C.ampurcode = :ampur group by K.b_year " ["api_id"]=> string(32) "764b2e63b0ca3754f85e7b8b2cc5e9f9" ["api_table"]=> string(12) "s_low_risk05" ["api_model_name"]=> string(56) "frontend\modules\kpis\modules\hdc\models\kpis\SLowRisk05" ["group_id"]=> string(1) "0" ["status"]=> string(1) "1" ["approve"]=> string(1) "1" ["created_at"]=> string(10) "1489922804" ["updated_at"]=> string(10) "1489922804" ["created_by"]=> string(3) "775" ["updated_by"]=> string(3) "775" ["kpi_code"]=> string(3) "061" ["kpi_name"]=> string(96) "ร้อยละของเด็กอายุ 0-5 ปี มีภาวะเตี้ย" ["kpi_order"]=> string(2) "61" ["parent_kpi_id"]=> NULL ["owner_cluster"]=> string(1) "1" ["evaluated_org"]=> NULL ["definition"]=> NULL ["category_id"]=> NULL ["strategic_set_id"]=> NULL ["type_id"]=> NULL ["fiscal_year_id"]=> string(4) "2561" ["objective"]=> NULL ["target_group"]=> NULL ["data_collection_method"]=> NULL ["data_source_description"]=> NULL ["data_element_1"]=> NULL ["data_element_2"]=> NULL ["data_formula"]=> NULL ["baseline_data"]=> NULL ["evaluation_period"]=> NULL ["processing_method"]=> NULL ["supported_document"]=> NULL ["contact_information"]=> NULL ["data_recorded_by"]=> NULL ["data_processed_by"]=> NULL ["managed_by_org"]=> NULL ["managed_by_user"]=> string(3) "775" ["template_attachment"]=> NULL ["kpi_type"]=> string(3) "HDC" ["kpi_goal_id"]=> NULL ["baseurl_template_attachment"]=> string(12) "/kpitemplate" ["kpi_template_name"]=> string(96) "ร้อยละของเด็กอายุ 0-5 ปี มีภาวะเตี้ย" ["kpi_system_routing"]=> string(16) "/dashboard/low05" ["cluster_id"]=> string(1) "1" ["is_ministry_data"]=> string(1) "0" ["is_inspection_data"]=> string(1) "0" ["is_standard_data"]=> string(1) "0" ["is_department_data"]=> string(1) "0" ["is_pa_data"]=> string(1) "0" ["is_surveillance_data"]=> string(1) "1" ["is_other_data"]=> string(1) "0" ["kpi_number"]=> NULL ["sort_number"]=> NULL ["kpi_unit"]=> string(18) "ร้อยละ" ["target_condition"]=> string(2) "<=" ["target_value"]=> string(5) "10.00" ["target_gauge_max_scale"]=> string(3) "100" ["result_value_orig"]=> NULL ["result_value"]=> NULL ["result_rate_scale"]=> string(6) "100.00" ["result_level_orig"]=> NULL ["result_level"]=> NULL ["pin_to_dashboard"]=> string(1) "0" ["pin_to_startpage"]=> string(1) "1" ["kpi_warning_status"]=> string(1) "0" ["kpi_resource"]=> string(3) "HDC" ["kpi_datasource"]=> string(143) "ที่มา : DoH Dashboard กรมอนามัย (ข้อมูลจาก HDC กระทรวงสาธารณสุข) " ["kpi_note"]=> NULL ["kpi_status"]=> string(1) "1" ["created_ip"]=> NULL ["updated_ip"]=> NULL } 'kpi'=>

-------------------------------------------------------------------

'targetValue'=>10, array(10) { [0]=> array(2) { [0]=> string(4) "2557" [1]=> float(0) } [1]=> array(2) { [0]=> string(4) "2557" [1]=> float(0) } [2]=> array(2) { [0]=> string(4) "2558" [1]=> float(0) } [3]=> array(2) { [0]=> string(4) "2558" [1]=> float(0) } [4]=> array(2) { [0]=> string(4) "2559" [1]=> float(0) } [5]=> array(2) { [0]=> string(4) "2559" [1]=> float(0) } [6]=> array(2) { [0]=> string(4) "2560" [1]=> float(0) } [7]=> array(2) { [0]=> string(4) "2560" [1]=> float(0) } [8]=> array(2) { [0]=> string(4) "2561" [1]=> float(0) } [9]=> array(2) { [0]=> string(4) "2561" [1]=> float(0) } } 'trendData'=>

-------------------------------------------------------------------

ตารางข้อมูลรายพื้นที่
  พื้นที่ ไตรมาส 1 ไตรมาส 2 ไตรมาส 3 ไตรมาส 4
B A ร้อยละ B A ร้อยละ B A ร้อยละ B A ร้อยละ
ที่มา: DoH Dashboard กรมอนามัย (ข้อมูลจาก HDC กระทรวงสาธารณสุข)
 เขต 1243,56032,01513.14235,03132,37413.77234,96232,10713.66259,29238,61514.89
 เขต 2145,23115,35010.57146,42715,91810.87143,19614,35210.02149,60016,98111.35
 เขต 3131,51110,9188.30123,50410,7638.71124,74210,5538.46132,14512,3129.32
 เขต 4179,46613,9177.75166,48813,5388.13168,33212,7517.57179,24615,6988.76
 เขต 5282,16622,0117.80255,29421,5418.44269,15420,7267.70274,74024,5918.95
 เขต 6265,13819,9047.51240,89319,0567.91248,23019,8688.00268,27526,1709.75
 เขต 7261,30024,5739.40254,39424,3739.58255,73922,6338.85267,29426,5969.95
 เขต 8278,57128,85910.36278,36729,24410.51267,89627,90010.41279,36933,52112.00
 เขต 9345,03325,2177.31313,39924,4757.81331,00126,2077.92325,17531,7689.77
 เขต 10229,91424,09810.48211,38523,68011.20214,30822,12710.32203,66021,30410.46
 เขต 11216,24121,70110.04212,84721,1579.94207,05718,4138.89214,91522,33110.39
 เขต 12310,16835,26111.37294,73932,11110.89290,14230,67310.57299,97034,41411.47
 สสม.15795.73172126.98000.002200.00
 รวมทั้งหมด2,888,456273,8339.482,732,940268,2429.822,754,759258,3109.382,853,703304,30110.66
หมายเหตุ:
B หมายถึง จ่านวนเด็กอายุ 0-5 ปีที่ชั่งน้่าหนักและวัดส่วนสูงทั้งหมด
A หมายถึง จ่านวนเด็กอายุ 0-5 ปีสูงดีสมส่วน

วันที่ประมวลผล: 1 มกราคม 2562