TMP_Sitko

query event v_leveling_kk
 INSERT INTO tb_leveling_kk
            (
                        id,
                        nama_fasyankes,
                        id_provinsi,
                        kd_provinsi,
                        id_kotkab,
                        kd_kabupaten,
                        `level 1`,
                        `level 2`,
                        `level 3`,
                        `level`
            )
SELECT t.id,
       t.nama_fasyankes,
       t.id_provinsi,
       t.kd_provinsi,
       t.id_kotkab,
       t.kd_kabupaten,
       t.`level 1`,
       t.`level 2`,
       t.`level 3`,
       t.`level`
FROM   v_leveling_kk t
ON duplicate KEYUPDATE id=t.id,
       nama_fasyankes=t.nama_fasyankes,
       id_provinsi=t.id_provinsi,
       kd_provinsi=t.kd_provinsi,
       id_kotkab=t.id_kotkab,
       `level 1`=t.`level 1`,
       `level 2`=t.`level 2`,
       `level 3`=t.`level 3`,
       `level`=t.`level`
________________________________________________________________________
v_leveling_kk
select `a`.`id` AS `id`,`a`.`nama_fasyankes` AS `nama_fasyankes`,`a`.`id_provinsi` AS `id_provinsi`,`a`.`kd_provinsi` AS `kd_provinsi`,`a`.`id_kotkab` AS `id_kotkab`,`a`.`kd_kabupaten` AS `kd_kabupaten`,`b`.`perencanaan` + `b`.`k3_pengelola_kk` + `b`.`k3_sop` + `b`.`k3_apd` + `b`.`k3_peta_risiko` + `b`.`k3_jalur` + `b`.`k3_sedia_apar` + `c`.`pembentukan_ukk` + `d`.`pendataan_kerja` + `e`.`peta_wilayah` AS `level 1`,`b`.`perencanaan` + `b`.`k3_pengelola_kk` + `b`.`k3_sop` + `b`.`k3_apd` + `b`.`k3_peta_risiko` + `b`.`k3_jalur` + `b`.`k3_sedia_apar` + `c`.`pembentukan_ukk` + `d`.`pendataan_kerja` + `e`.`peta_wilayah` + `b`.`k3_simulasi_apar` + `b`.`imunisasi` + `b`.`deteksi_ptm` + `f`.`pelayanan_pak` + `c`.`pembinaan_ukk` + `d`.`pembinaan_kerja` AS `level 2`,`b`.`perencanaan` + `b`.`k3_pengelola_kk` + `b`.`k3_sop` + `b`.`k3_apd` + `b`.`k3_peta_risiko` + `b`.`k3_jalur` + `b`.`k3_sedia_apar` + `b`.`layanan_pak` + `c`.`pembentukan_ukk` + `d`.`pendataan_kerja` + `e`.`peta_wilayah` + `b`.`k3_simulasi_apar` + `b`.`imunisasi` + `b`.`deteksi_ptm` + `f`.`pelayanan_pak` + `c`.`pembinaan_ukk` + `d`.`pembinaan_kerja` + `b`.`jabfung_pkk` AS `level 3`,case when `b`.`perencanaan` + `b`.`k3_pengelola_kk` + `b`.`k3_sop` + `b`.`k3_apd` + `b`.`k3_peta_risiko` + `b`.`k3_jalur` + `b`.`k3_sedia_apar` + `c`.`pembentukan_ukk` + `d`.`pendataan_kerja` + `e`.`peta_wilayah` + `b`.`k3_simulasi_apar` + `b`.`imunisasi` + `b`.`deteksi_ptm` + `f`.`pelayanan_pak` + `c`.`pembinaan_ukk` + `d`.`pembinaan_kerja` + `b`.`jabfung_pkk` = 17 then 'LEVEL 3' when `b`.`perencanaan` + `b`.`k3_pengelola_kk` + `b`.`k3_sop` + `b`.`k3_apd` + `b`.`k3_peta_risiko` + `b`.`k3_jalur` + `b`.`k3_sedia_apar` + `c`.`pembentukan_ukk` + `d`.`pendataan_kerja` + `e`.`peta_wilayah` + `b`.`k3_simulasi_apar` + `b`.`imunisasi` + `b`.`deteksi_ptm` + `f`.`pelayanan_pak` + `c`.`pembinaan_ukk` + `d`.`pembinaan_kerja` = 16 then 'LEVEL 2' when `b`.`perencanaan` + `b`.`k3_pengelola_kk` + `b`.`k3_sop` + `b`.`k3_apd` + `b`.`k3_peta_risiko` + `b`.`k3_jalur` + `b`.`k3_sedia_apar` + `c`.`pembentukan_ukk` + `d`.`pendataan_kerja` + `e`.`peta_wilayah` = 10 then 'LEVEL 1' else 'BELUM MEMENUHI' end AS `Level` from (((((`puskesmasses` `a` left join `v_pkm_kerja_internal` `b` on(`b`.`puskesmas_id` = `a`.`id`)) left join `v_u_k_k_s` `c` on(`c`.`puskesmas_id` = `a`.`id`)) left join `v_pkm_pembinaan_kerja` `d` on(`d`.`puskesmas_id` = `a`.`id`)) left join `v_pkm_profile` `e` on(`e`.`puskesmas_id` = `a`.`id`)) left join `v_pelayanan_pak` `f` on(`f`.`puskesmas_id` = `a`.`id`)) group by `a`.`id`