select public.spHPY_Get_Inq_Data_Rekap_Penghasilan_Karyawan('ref1586946831595','B31599A36A0035958433F91D9A79F260','2020-04-15','120000','A.nik, A.nmkry, A.kdjabatan, A.nmjabatan, A.kdbank1, A.kdlokasikerja, A.nmlokasikerja, A.nmbank1, A.jenispembayaran, COALESCE(SUM(CASE WHEN regexp_replace(TRIM(c.name), ' ', '_') = 'Gaji' THEN ROUND(b.total_nilai_akhir) END), 0) AS Gaji, COALESCE(SUM(CASE WHEN regexp_replace(TRIM(c.name), ' ', '_') = 'THR' THEN ROUND(b.total_nilai_akhir) END), 0) AS THR, A.tottunjmenambahthp, A.thp, A.thpbulanlalu ',' A.nik,  A.nmkry,  A.kdjabatan,  A.nmjabatan,  A.kdbank1,  A.kdlokasikerja,  A.nmlokasikerja,  A.nmbank1,  A.jenispembayaran,  A.tottunjmenambahthp,  A.thp,  A.thpbulanlalu ',' A.nik,  A.nmkry,  A.kdjabatan,  A.nmjabatan,  A.kdbank1,  A.kdlokasikerja,  A.nmlokasikerja,  A.nmbank1,  A.jenispembayaran,  A.tottunjmenambahthp,  A.thp,  A.thpbulanlalu ','201912','201912','('Gajian', 'Tunjangan', 'Thr', 'TunjanganAbsensi', 'Bonus')',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null)