ดัดแปลงจากคลัง CUSTOM-EHP-REPORT-AI-CUSTOM- รายงานประชากรในเขตพื้นที่(แบบสำรวจ1,3) แยกอายุ แยกหมู่ แยกเพศ

ชื่อรายงาน ปลายทาง demo-103 แนวนอน

SQL (Master) — ใช้ :date1 :date2 สำหรับช่วงวันที่
SELECT p.age_y, COUNT(CASE WHEN p.sex = 1 AND v.village_moo = '1' THEN 1 END) AS men_moo1, COUNT(CASE WHEN p.sex = 2 AND v.village_moo = '1' THEN 1 END) AS women_moo1, COUNT(CASE WHEN p.sex = 1 AND v.village_moo = '2' THEN 1 END) AS men_moo2, COUNT(CASE WHEN p.sex = 2 AND v.village_moo = '2' THEN 1 END) AS women_moo2, COUNT(CASE WHEN p.sex = 1 AND v.village_moo = '3' THEN 1 END) AS men_moo3, COUNT(CASE WHEN p.sex = 2 AND v.village_moo = '3' THEN 1 END) AS women_moo3, COUNT(CASE WHEN p.sex = 1 AND v.village_moo = '4' THEN 1 END) AS men_moo4, COUNT(CASE WHEN p.sex = 2 AND v.village_moo = '4' THEN 1 END) AS women_moo4, COUNT(CASE WHEN p.sex = 1 AND v.village_moo = '5' THEN 1 END) AS men_moo5, COUNT(CASE WHEN p.sex = 2 AND v.village_moo = '5' THEN 1 END) AS women_moo5, COUNT(CASE WHEN p.sex = 1 AND v.village_moo = '6' THEN 1 END) AS men_moo6, COUNT(CASE WHEN p.sex = 2 AND v.village_moo = '6' THEN 1 END) AS women_moo6, COUNT(CASE WHEN p.sex = 1 AND v.village_moo = '7' THEN 1 END) AS men_moo7, COUNT(CASE WHEN p.sex = 2 AND v.village_moo = '7' THEN 1 END) AS women_moo7, COUNT(CASE WHEN p.sex = 1 AND v.village_moo = '8' THEN 1 END) AS men_moo8, COUNT(CASE WHEN p.sex = 2 AND v.village_moo = '8' THEN 1 END) AS women_moo8, COUNT(CASE WHEN p.sex = 1 AND v.village_moo = '9' THEN 1 END) AS men_moo9, COUNT(CASE WHEN p.sex = 2 AND v.village_moo = '9' THEN 1 END) AS women_moo9, COUNT(CASE WHEN p.sex = 1 AND v.village_moo = '10' THEN 1 END) AS men_moo10, COUNT(CASE WHEN p.sex = 2 AND v.village_moo = '10' THEN 1 END) AS women_moo10 FROM person p INNER JOIN village v ON p.village_id = v.village_id WHERE p.death <> 'Y' AND p.house_regist_type_id IN (1, 3) AND v.village_moo IN ('1', '2', '3', '4', '5', '6', '7', '8', '9', '10') GROUP BY p.age_y ORDER BY p.age_y;

SQL หัวรายงาน — ต้องมีคอลัมน์ hospital_name (เว้นว่าง = ใช้ค่าเดิมของระบบ)

แยกกลุ่มตาม field

ดูตัวอย่างหน้ารายงาน ตรวจ + ตารางข้อมูล Deploy กำลังทำงาน…