EMIS

saat ini report data ustad untuk tahun ajaran baru (17) tidak ada datanya, tolong cek etl untuk mengenerate data ini apakah berjalan atau tidak

tabel 'pp_institution_statistic_histories'

select `m_cities`.`id` as `city_id`, `m_cities`.`city` as `city_name`, 
SUM(COALESCE(pis.gtk_total, 0)) as total_ustadz, 
SUM(COALESCE(pis.dosen_total, 0)) as dosen_total, 
SUM(COALESCE(pis.non_dosen_total, 0)) as non_dosen_total, 
SUM(COALESCE(pis.gtk_total, 0)) + SUM(COALESCE(pis.dosen_total, 0)) + SUM(COALESCE(pis.non_dosen_total, 0)) as total 
from `m_cities` 
left join `pp_institution_statistic_histories` as `pis` on `m_cities`.`id` = `pis`.`city_id` 
where `pis`.`academic_year_id` = 17 and `pis`.`province_id` = 76 
group by `m_cities`.`id` order by `m_cities`.`city` asc