[2026-01-15 08:20:08] ======== START PROCESS ========
[2026-01-15 08:20:08] Last deptrans_id: 677144
[2026-01-15 08:20:08] 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 > 677144 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-15 08:20:08] Total Rows query.sql : 48
[2026-01-15 08:20:09] HTTP Status Code: 200
[2026-01-15 08:20:09] Response: [{"success":true}]
[2026-01-15 08:20:09] Deptrans ID: 677157 telah diproses
[2026-01-15 08:20:10] HTTP Status Code: 200
[2026-01-15 08:20:10] Response: [{"success":true}]
[2026-01-15 08:20:10] Deptrans ID: 677161 telah diproses
[2026-01-15 08:20:11] HTTP Status Code: 200
[2026-01-15 08:20:11] Response: [{"success":true}]
[2026-01-15 08:20:11] Deptrans ID: 677167 telah diproses
[2026-01-15 08:20:12] HTTP Status Code: 200
[2026-01-15 08:20:12] Response: [{"success":true}]
[2026-01-15 08:20:12] Deptrans ID: 677173 telah diproses
[2026-01-15 08:20:12] HTTP Status Code: 200
[2026-01-15 08:20:12] Response: [{"success":true}]
[2026-01-15 08:20:12] Deptrans ID: 677193 telah diproses
[2026-01-15 08:20:13] HTTP Status Code: 200
[2026-01-15 08:20:13] Response: [{"success":true}]
[2026-01-15 08:20:13] Deptrans ID: 677203 telah diproses
[2026-01-15 08:20:14] HTTP Status Code: 200
[2026-01-15 08:20:14] Response: [{"success":true}]
[2026-01-15 08:20:14] Deptrans ID: 677209 telah diproses
[2026-01-15 08:20:14] HTTP Status Code: 200
[2026-01-15 08:20:14] Response: [{"success":true}]
[2026-01-15 08:20:14] Deptrans ID: 677223 telah diproses
[2026-01-15 08:20:15] HTTP Status Code: 200
[2026-01-15 08:20:15] Response: [{"success":true}]
[2026-01-15 08:20:15] Deptrans ID: 677233 telah diproses
[2026-01-15 08:20:16] HTTP Status Code: 200
[2026-01-15 08:20:16] Response: [{"success":true}]
[2026-01-15 08:20:16] Deptrans ID: 677245 telah diproses
[2026-01-15 08:20:16] HTTP Status Code: 200
[2026-01-15 08:20:16] Response: [{"success":true}]
[2026-01-15 08:20:16] Deptrans ID: 677259 telah diproses
[2026-01-15 08:20:17] HTTP Status Code: 200
[2026-01-15 08:20:17] Response: [{"success":true}]
[2026-01-15 08:20:17] Deptrans ID: 677263 telah diproses
[2026-01-15 08:20:18] HTTP Status Code: 200
[2026-01-15 08:20:18] Response: [{"success":true}]
[2026-01-15 08:20:18] Deptrans ID: 677269 telah diproses
[2026-01-15 08:20:18] HTTP Status Code: 200
[2026-01-15 08:20:18] Response: [{"success":true}]
[2026-01-15 08:20:18] Deptrans ID: 677293 telah diproses
[2026-01-15 08:20:19] HTTP Status Code: 200
[2026-01-15 08:20:19] Response: [{"success":true}]
[2026-01-15 08:20:19] Deptrans ID: 677299 telah diproses
[2026-01-15 08:20:20] HTTP Status Code: 200
[2026-01-15 08:20:20] Response: [{"success":true}]
[2026-01-15 08:20:20] Deptrans ID: 677303 telah diproses
[2026-01-15 08:20:20] HTTP Status Code: 200
[2026-01-15 08:20:20] Response: [{"success":true}]
[2026-01-15 08:20:20] Deptrans ID: 677313 telah diproses
[2026-01-15 08:20:21] HTTP Status Code: 200
[2026-01-15 08:20:21] Response: [{"success":true}]
[2026-01-15 08:20:21] Deptrans ID: 677317 telah diproses
[2026-01-15 08:20:22] HTTP Status Code: 200
[2026-01-15 08:20:22] Response: [{"success":true}]
[2026-01-15 08:20:22] Deptrans ID: 677325 telah diproses
[2026-01-15 08:20:22] HTTP Status Code: 200
[2026-01-15 08:20:22] Response: [{"success":true}]
[2026-01-15 08:20:22] Deptrans ID: 677329 telah diproses
[2026-01-15 08:20:23] HTTP Status Code: 200
[2026-01-15 08:20:23] Response: [{"success":true}]
[2026-01-15 08:20:23] Deptrans ID: 677333 telah diproses
[2026-01-15 08:20:23] HTTP Status Code: 200
[2026-01-15 08:20:23] Response: [{"success":true}]
[2026-01-15 08:20:23] Deptrans ID: 677349 telah diproses
[2026-01-15 08:20:24] HTTP Status Code: 200
[2026-01-15 08:20:24] Response: [{"success":true}]
[2026-01-15 08:20:24] Deptrans ID: 677359 telah diproses
[2026-01-15 08:20:25] HTTP Status Code: 200
[2026-01-15 08:20:25] Response: [{"success":true}]
[2026-01-15 08:20:25] Deptrans ID: 677375 telah diproses
[2026-01-15 08:20:25] HTTP Status Code: 200
[2026-01-15 08:20:25] Response: [{"success":true}]
[2026-01-15 08:20:25] Deptrans ID: 677379 telah diproses
[2026-01-15 08:20:26] HTTP Status Code: 200
[2026-01-15 08:20:26] Response: [{"success":true}]
[2026-01-15 08:20:26] Deptrans ID: 677383 telah diproses
[2026-01-15 08:20:26] HTTP Status Code: 200
[2026-01-15 08:20:26] Response: [{"success":true}]
[2026-01-15 08:20:26] Deptrans ID: 677396 telah diproses
[2026-01-15 08:20:27] HTTP Status Code: 200
[2026-01-15 08:20:27] Response: [{"success":true}]
[2026-01-15 08:20:27] Deptrans ID: 677412 telah diproses
[2026-01-15 08:20:28] HTTP Status Code: 200
[2026-01-15 08:20:28] Response: [{"success":true}]
[2026-01-15 08:20:28] Deptrans ID: 677416 telah diproses
[2026-01-15 08:20:28] HTTP Status Code: 200
[2026-01-15 08:20:28] Response: [{"success":true}]
[2026-01-15 08:20:28] Deptrans ID: 677420 telah diproses
[2026-01-15 08:20:29] HTTP Status Code: 200
[2026-01-15 08:20:29] Response: [{"success":true}]
[2026-01-15 08:20:29] Deptrans ID: 677432 telah diproses
[2026-01-15 08:20:29] HTTP Status Code: 200
[2026-01-15 08:20:29] Response: [{"success":true}]
[2026-01-15 08:20:29] Deptrans ID: 677436 telah diproses
[2026-01-15 08:20:30] HTTP Status Code: 200
[2026-01-15 08:20:30] Response: [{"success":true}]
[2026-01-15 08:20:30] Deptrans ID: 677440 telah diproses
[2026-01-15 08:20:31] HTTP Status Code: 200
[2026-01-15 08:20:31] Response: [{"success":true}]
[2026-01-15 08:20:31] Deptrans ID: 677446 telah diproses
[2026-01-15 08:20:31] HTTP Status Code: 200
[2026-01-15 08:20:31] Response: [{"success":true}]
[2026-01-15 08:20:31] Deptrans ID: 677449 telah diproses
[2026-01-15 08:20:32] HTTP Status Code: 200
[2026-01-15 08:20:32] Response: [{"success":true}]
[2026-01-15 08:20:32] Deptrans ID: 677454 telah diproses
[2026-01-15 08:20:32] HTTP Status Code: 200
[2026-01-15 08:20:32] Response: [{"success":true}]
[2026-01-15 08:20:32] Deptrans ID: 677458 telah diproses
[2026-01-15 08:20:33] HTTP Status Code: 200
[2026-01-15 08:20:33] Response: [{"success":true}]
[2026-01-15 08:20:33] Deptrans ID: 677461 telah diproses
[2026-01-15 08:20:34] HTTP Status Code: 200
[2026-01-15 08:20:34] Response: [{"success":true}]
[2026-01-15 08:20:34] Deptrans ID: 677479 telah diproses
[2026-01-15 08:20:34] HTTP Status Code: 200
[2026-01-15 08:20:34] Response: [{"success":true}]
[2026-01-15 08:20:34] Deptrans ID: 677483 telah diproses
[2026-01-15 08:20:35] HTTP Status Code: 200
[2026-01-15 08:20:35] Response: [{"success":true}]
[2026-01-15 08:20:35] Deptrans ID: 677493 telah diproses
[2026-01-15 08:20:35] HTTP Status Code: 200
[2026-01-15 08:20:35] Response: [{"success":true}]
[2026-01-15 08:20:35] Deptrans ID: 677501 telah diproses
[2026-01-15 08:20:36] HTTP Status Code: 200
[2026-01-15 08:20:36] Response: [{"success":true}]
[2026-01-15 08:20:36] Deptrans ID: 677509 telah diproses
[2026-01-15 08:20:37] HTTP Status Code: 200
[2026-01-15 08:20:37] Response: [{"success":true}]
[2026-01-15 08:20:37] Deptrans ID: 677525 telah diproses
[2026-01-15 08:20:37] HTTP Status Code: 200
[2026-01-15 08:20:37] Response: [{"success":true}]
[2026-01-15 08:20:37] Deptrans ID: 677533 telah diproses
[2026-01-15 08:20:38] HTTP Status Code: 200
[2026-01-15 08:20:38] Response: [{"success":true}]
[2026-01-15 08:20:38] Deptrans ID: 677541 telah diproses
[2026-01-15 08:20:38] HTTP Status Code: 200
[2026-01-15 08:20:38] Response: [{"success":true}]
[2026-01-15 08:20:38] Deptrans ID: 677551 telah diproses
[2026-01-15 08:20:39] HTTP Status Code: 200
[2026-01-15 08:20:39] Response: [{"success":true}]
[2026-01-15 08:20:39] Deptrans ID: 677571 telah diproses
[2026-01-15 08:20:39] Total Processed Row: 48 | Last deptrans_id: 677571
[2026-01-15 08:20:39] ========  END PROCESS  ========