[2026-01-03 08:20:02] ======== START PROCESS ========
[2026-01-03 08:20:02] Last deptrans_id: 670970
[2026-01-03 08:20:02] Query: SELECT
    TRIM(deposito.NO_REKENING) AS no_rekening
    ,TRIM(deposito.NO_ALTERNATIF) AS no_bilyet
    ,deposito.JKW AS jangka_waktu
    ,deposito.SUKU_BUNGA AS suku_bunga
    ,deposito.BUNGA_BERBUNGA AS flag_bunga_masuk_pokok
    ,deposito.TGL_REGISTRASI AS tanggal_registrasi
    ,deposito.TGL_MULAI AS tanggal_pembukaan
    ,deposito.TGL_JT AS tanggal_jatuh_tempo
    ,kodejenisdeposito.KODE_JENIS_DEPOSITO AS kode_jenis_deposito
    ,kodejenisdeposito.DESKRIPSI_JENIS_DEPOSITO AS jenis_deposito
    ,deposito.JML_DEPOSITO AS nominal_deposito
    ,CASE
        WHEN deptrans.KUITANSI LIKE '%ARO%' THEN deposito.JML_DEPOSITO
        ELSE 0
    END AS nominal_outstanding
    ,TRIM(deposito.STATUS_BUNGA) AS status_bunga
    ,TRIM(deposito.qq) AS qq
    ,TRIM(deposito.and_or) AS and_or
    ,TRIM(deposito.nasabah_qq) AS nasabah_qq
    ,TRIM(deposito.NO_REK_TABUNGAN) AS no_rekening_tabungan
    ,CASE
        WHEN deposito.STATUS_AKTIF = '1' THEN 'Baru'
        WHEN deposito.STATUS_AKTIF = '2' THEN 'Aktif'
        WHEN deposito.STATUS_AKTIF = '3' THEN 'Tutup'
        ELSE 'Invalid'
    END AS status_aktif
    ,TRIM(kodegroup1deposito.KODE_GROUP1) AS kode_marketing_deposito
    ,TRIM(kodegroup1deposito.DESKRIPSI_GROUP1) AS nama_marketing_deposito
    ,TRIM(kodegroup2deposito.DESKRIPSI_GROUP2) AS kode_group2
    ,TRIM(kodegroup3deposito.DESKRIPSI_GROUP3) AS kode_group3
    ,TRIM(kodegroup4_deposito.DESKRIPSI_GROUP4) AS kode_group4
    ,TRIM(kodegroup5deposito.DESKRIPSI_GROUP5) AS kode_group5

    ,TRIM(nasabah.NASABAH_ID) AS cif
    ,nasabah.TGL_BUKA AS tanggal_registrasi_cif
    ,TRIM(nasabah.NAMA_NASABAH) AS nama_nasabah
	,CASE
		WHEN nasabah.JENIS_NASABAH='1' THEN 'Individu'
		ELSE 'Non Invidividu'
	END AS jenis_nasabah
    ,TRIM(nasabah.ALAMAT_DOMISILI) AS alamat
    ,TRIM(nasabah.KOTA) AS kota
    ,TRIM(nasabah.NO_HP) AS no_handphone
    ,TRIM(nasabah.EMAIL) AS email
    ,TRIM(nasabah.no_id) AS nik
    ,nasabah.tgllahir AS tanggal_lahir
    ,TRIM(kodegroup1_nasabah.DESKRIPSI_GROUP1) AS agama

    ,deptrans.DEPTRANS_ID AS deptrans_id
    ,TRIM(deptrans.NO_REKENING) AS deptrans_no_rekening
    ,deptrans.TGL_TRANS AS deptrans_tgl_trans
    ,TRIM(deptrans.MY_KODE_TRANS) AS deptrans_my_kode_trans
    ,TRIM(kodetransdeposito.KODE_TRANS) AS deptrans_kode_trans
    ,CASE
        WHEN deptrans.KUITANSI LIKE '%ARO%' THEN  deptrans.KUITANSI
        ELSE TRIM(kodetransdeposito.DESKRIPSI_TRANS)
    END AS deptrans_deskripsi_trans
    ,deptrans.SALDO_TRANS AS deptrans_saldo_trans
    ,TRIM(deptrans.KUITANSI) AS deptrans_kuitansi
FROM deptrans
JOIN deposito ON deptrans.NO_REKENING = deposito.NO_REKENING
JOIN nasabah ON deposito.NASABAH_ID = nasabah.nasabah_id
LEFT JOIN kodetransdeposito ON deptrans.KODE_TRANS = kodetransdeposito.KODE_TRANS
LEFT JOIN kodegroup1deposito ON deposito.KODE_GROUP1 = kodegroup1deposito.KODE_GROUP1
LEFT JOIN kodegroup2deposito ON deposito.KODE_GROUP2 = kodegroup2deposito.KODE_GROUP2
LEFT JOIN kodegroup3deposito ON deposito.KODE_GROUP3 = kodegroup3deposito.KODE_GROUP3
LEFT JOIN kodegroup4_deposito ON deposito.KODE_GROUP4 = kodegroup4_deposito.KODE_GROUP4
LEFT JOIN kodegroup5deposito ON deposito.KODE_GROUP5 = kodegroup5deposito.KODE_GROUP5
LEFT JOIN kodegroup1_nasabah ON nasabah.NASABAH_GROUP1 = kodegroup1_nasabah.NASABAH_GROUP1
LEFT JOIN kodejenisdeposito ON deposito.JENIS_DEPOSITO = kodejenisdeposito.KODE_JENIS_DEPOSITO
WHERE deptrans.DEPTRANS_ID > 670970 AND deptrans.MY_KODE_TRANS NOT IN ('500')
AND (deptrans.KODE_TRANS IN ('01','08','03','09') OR deptrans.KUITANSI LIKE '%ARO%')
ORDER BY deptrans.DEPTRANS_ID
;


[2026-01-03 08:20:02] Total Rows query.sql : 34
[2026-01-03 08:20:02] HTTP Status Code: 200
[2026-01-03 08:20:02] Response: [{"success":true}]
[2026-01-03 08:20:02] Deptrans ID: 670997 telah diproses
[2026-01-03 08:20:03] HTTP Status Code: 200
[2026-01-03 08:20:03] Response: [{"success":true}]
[2026-01-03 08:20:03] Deptrans ID: 671001 telah diproses
[2026-01-03 08:20:03] HTTP Status Code: 200
[2026-01-03 08:20:03] Response: [{"success":true}]
[2026-01-03 08:20:04] Deptrans ID: 671018 telah diproses
[2026-01-03 08:20:04] HTTP Status Code: 200
[2026-01-03 08:20:04] Response: [{"success":true}]
[2026-01-03 08:20:04] Deptrans ID: 671034 telah diproses
[2026-01-03 08:20:05] HTTP Status Code: 200
[2026-01-03 08:20:05] Response: [{"success":true}]
[2026-01-03 08:20:05] Deptrans ID: 671040 telah diproses
[2026-01-03 08:20:05] HTTP Status Code: 200
[2026-01-03 08:20:05] Response: [{"success":true}]
[2026-01-03 08:20:05] Deptrans ID: 671046 telah diproses
[2026-01-03 08:20:06] HTTP Status Code: 200
[2026-01-03 08:20:06] Response: [{"success":true}]
[2026-01-03 08:20:06] Deptrans ID: 671050 telah diproses
[2026-01-03 08:20:06] HTTP Status Code: 200
[2026-01-03 08:20:06] Response: [{"success":true}]
[2026-01-03 08:20:06] Deptrans ID: 671054 telah diproses
[2026-01-03 08:20:07] HTTP Status Code: 200
[2026-01-03 08:20:07] Response: [{"success":true}]
[2026-01-03 08:20:07] Deptrans ID: 671070 telah diproses
[2026-01-03 08:20:08] HTTP Status Code: 200
[2026-01-03 08:20:08] Response: [{"success":true}]
[2026-01-03 08:20:08] Deptrans ID: 671076 telah diproses
[2026-01-03 08:20:09] HTTP Status Code: 200
[2026-01-03 08:20:09] Response: [{"success":true}]
[2026-01-03 08:20:09] Deptrans ID: 671088 telah diproses
[2026-01-03 08:20:09] HTTP Status Code: 200
[2026-01-03 08:20:09] Response: [{"success":true}]
[2026-01-03 08:20:09] Deptrans ID: 671102 telah diproses
[2026-01-03 08:20:10] HTTP Status Code: 200
[2026-01-03 08:20:10] Response: [{"success":true}]
[2026-01-03 08:20:10] Deptrans ID: 671122 telah diproses
[2026-01-03 08:20:10] HTTP Status Code: 200
[2026-01-03 08:20:10] Response: [{"success":true}]
[2026-01-03 08:20:10] Deptrans ID: 671132 telah diproses
[2026-01-03 08:20:11] HTTP Status Code: 200
[2026-01-03 08:20:11] Response: [{"success":true}]
[2026-01-03 08:20:11] Deptrans ID: 671152 telah diproses
[2026-01-03 08:20:11] HTTP Status Code: 200
[2026-01-03 08:20:11] Response: [{"success":true}]
[2026-01-03 08:20:11] Deptrans ID: 671158 telah diproses
[2026-01-03 08:20:12] HTTP Status Code: 200
[2026-01-03 08:20:12] Response: [{"success":true}]
[2026-01-03 08:20:12] Deptrans ID: 671162 telah diproses
[2026-01-03 08:20:12] HTTP Status Code: 200
[2026-01-03 08:20:12] Response: [{"success":true}]
[2026-01-03 08:20:13] Deptrans ID: 671176 telah diproses
[2026-01-03 08:20:13] HTTP Status Code: 200
[2026-01-03 08:20:13] Response: [{"success":true}]
[2026-01-03 08:20:13] Deptrans ID: 671192 telah diproses
[2026-01-03 08:20:14] HTTP Status Code: 200
[2026-01-03 08:20:14] Response: [{"success":true}]
[2026-01-03 08:20:14] Deptrans ID: 671200 telah diproses
[2026-01-03 08:20:14] HTTP Status Code: 200
[2026-01-03 08:20:14] Response: [{"success":true}]
[2026-01-03 08:20:14] Deptrans ID: 671207 telah diproses
[2026-01-03 08:20:15] HTTP Status Code: 200
[2026-01-03 08:20:15] Response: [{"success":true}]
[2026-01-03 08:20:15] Deptrans ID: 671223 telah diproses
[2026-01-03 08:20:15] HTTP Status Code: 200
[2026-01-03 08:20:15] Response: [{"success":true}]
[2026-01-03 08:20:15] Deptrans ID: 671247 telah diproses
[2026-01-03 08:20:16] HTTP Status Code: 200
[2026-01-03 08:20:16] Response: [{"success":true}]
[2026-01-03 08:20:16] Deptrans ID: 671251 telah diproses
[2026-01-03 08:20:16] HTTP Status Code: 200
[2026-01-03 08:20:16] Response: [{"success":true}]
[2026-01-03 08:20:16] Deptrans ID: 671255 telah diproses
[2026-01-03 08:20:17] HTTP Status Code: 200
[2026-01-03 08:20:17] Response: [{"success":true}]
[2026-01-03 08:20:17] Deptrans ID: 671267 telah diproses
[2026-01-03 08:20:17] HTTP Status Code: 200
[2026-01-03 08:20:17] Response: [{"success":true}]
[2026-01-03 08:20:17] Deptrans ID: 671279 telah diproses
[2026-01-03 08:20:18] HTTP Status Code: 200
[2026-01-03 08:20:18] Response: [{"success":true}]
[2026-01-03 08:20:18] Deptrans ID: 671293 telah diproses
[2026-01-03 08:20:19] HTTP Status Code: 200
[2026-01-03 08:20:19] Response: [{"success":true}]
[2026-01-03 08:20:19] Deptrans ID: 671297 telah diproses
[2026-01-03 08:20:19] HTTP Status Code: 200
[2026-01-03 08:20:19] Response: [{"success":true}]
[2026-01-03 08:20:19] Deptrans ID: 671303 telah diproses
[2026-01-03 08:20:20] HTTP Status Code: 200
[2026-01-03 08:20:20] Response: [{"success":true}]
[2026-01-03 08:20:20] Deptrans ID: 671307 telah diproses
[2026-01-03 08:20:20] HTTP Status Code: 200
[2026-01-03 08:20:20] Response: [{"success":true}]
[2026-01-03 08:20:20] Deptrans ID: 671311 telah diproses
[2026-01-03 08:20:21] HTTP Status Code: 200
[2026-01-03 08:20:21] Response: [{"success":true}]
[2026-01-03 08:20:21] Deptrans ID: 671315 telah diproses
[2026-01-03 08:20:21] HTTP Status Code: 200
[2026-01-03 08:20:21] Response: [{"success":true}]
[2026-01-03 08:20:21] Deptrans ID: 671329 telah diproses
[2026-01-03 08:20:21] Total Processed Row: 34 | Last deptrans_id: 671329
[2026-01-03 08:20:21] ========  END PROCESS  ========