Bug #34817
Updated by Dendy Dwi 21 days ago
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'
<pre>
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
</pre>