2023-08-27 16:14:54 - DEBUG --> [ ISS2308131000003 ] 
2023-08-27 16:14:54 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' and a.unique_id = 'ISS2308131000003'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:17:03 - DEBUG --> [ 'No parameters found.' ] 
2023-08-27 16:17:32 - DEBUG --> [ BYR00000007 ] 
2023-08-27 16:17:32 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:17:33 - DEBUG --> [ 'Conversion failed.' ] 
2023-08-27 16:20:23 - DEBUG --> [ BYR00000007 ] 
2023-08-27 16:20:23 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:20:24 - DEBUG --> [ 'Conversion failed.' ] 
2023-08-27 16:22:07 - DEBUG --> [ BYR00000007 ] 
2023-08-27 16:22:07 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:22:08 - DEBUG --> [ 'Conversion failed.' ] 
2023-08-27 16:23:14 - DEBUG --> [ BYR00000007 ] 
2023-08-27 16:23:14 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:23:14 - DEBUG --> [ 'Conversion failed.' ] 
2023-08-27 16:24:02 - DEBUG --> [ BYR00000007 ] 
2023-08-27 16:24:02 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:24:02 - DEBUG --> [ 'Conversion failed.' ] 
2023-08-27 16:24:27 - DEBUG --> [ BYR00000007 ] 
2023-08-27 16:24:27 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:24:27 - DEBUG --> [ 'Conversion failed.' ] 
2023-08-27 16:33:49 - DEBUG --> [ BYR00000007 ] 
2023-08-27 16:33:49 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:33:49 - DEBUG --> [ 'No parameters found.' ] 
2023-08-27 16:33:56 - DEBUG --> [ BYR00000007 ] 
2023-08-27 16:33:56 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:33:56 - DEBUG --> [ 'No parameters found.' ] 
2023-08-27 16:34:28 - DEBUG --> [ BYR00000007 ] 
2023-08-27 16:34:28 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:34:28 - DEBUG --> [ 'No parameters found.' ] 
2023-08-27 16:35:16 - DEBUG --> [ BYR00000007 ] 
2023-08-27 16:35:16 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:36:40 - DEBUG --> [ BYR00000007 ] 
2023-08-27 16:36:40 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:37:36 - DEBUG --> [ BYR00000007 ] 
2023-08-27 16:37:36 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:37:58 - DEBUG --> [ BYR00000007 ] 
2023-08-27 16:37:58 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:39:01 - DEBUG --> [ BYR00000007 ] 
2023-08-27 16:39:01 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:44:32 - DEBUG --> [ BYR00000007 ] 
2023-08-27 16:44:32 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:44:32 - DEBUG --> [ 'Conversion failed.' ] 
2023-08-27 16:44:51 - DEBUG --> [ 'No parameters found.' ] 
2023-08-27 16:44:53 - DEBUG --> [ 'No parameters found.' ] 
2023-08-27 16:46:11 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:46:11 - DEBUG --> [ 'Conversion failed.' ] 
2023-08-27 16:46:39 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:46:42 - DEBUG --> [ UPDATE pembayaran SET kwitansi_generate = 'true' WHERE unique_id='BYR00000007' ] 
2023-08-27 16:47:28 - DEBUG --> [ BYR00000007 ] 
2023-08-27 16:47:28 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:47:29 - DEBUG --> [ 'Conversion failed.' ] 
2023-08-27 16:50:04 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' 
    --and c.unique_id = ''
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:50:05 - DEBUG --> [ 'Conversion failed.' ] 
2023-08-27 16:51:17 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' 
    --and c.unique_id = ''
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:51:18 - DEBUG --> [ UPDATE pembayaran SET kwitansi_generate = 'true' WHERE unique_id='BYR00000004' ] 
2023-08-27 16:52:15 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' 
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:52:17 - DEBUG --> [ UPDATE pembayaran SET kwitansi_generate = 'true' WHERE unique_id='' ] 
2023-08-27 16:53:01 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' 
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:53:03 - DEBUG --> [ UPDATE pembayaran SET kwitansi_generate = 'true' WHERE unique_id='BYR00000007' ] 
2023-08-27 16:53:04 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' 
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:53:06 - DEBUG --> [ UPDATE pembayaran SET kwitansi_generate = 'true' WHERE unique_id='BYR00000004' ] 
2023-08-27 16:54:13 - DEBUG --> [ 'No parameters found.' ] 
2023-08-27 16:54:47 - DEBUG --> [ BYR00000007 ] 
2023-08-27 16:54:47 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' 
    and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:54:48 - DEBUG --> [ 'Conversion failed.' ] 
2023-08-27 16:55:07 - DEBUG --> [ BYR00000007 ] 
2023-08-27 16:55:07 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' 
    and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:55:07 - DEBUG --> [ 'Conversion failed.' ] 
2023-08-27 16:55:53 - DEBUG --> [ BYR00000007 ] 
2023-08-27 16:55:53 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' 
    and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 16:55:54 - DEBUG --> [ 'Conversion failed.' ] 
2023-08-27 22:45:08 - DEBUG --> [ 'No parameters found.' ] 
2023-08-27 22:45:20 - DEBUG --> [ BYR00000007 ] 
2023-08-27 22:45:20 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' 
    and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 22:46:35 - DEBUG --> [ BYR00000007 ] 
2023-08-27 22:46:35 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, c.nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' 
    and c.unique_id = 'BYR00000007'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 23:11:22 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, TO_CHAR(c.tgl_jatuh_tempo, 'Month YYYY') AS bulan_tahun_jatuh_tempo, COALESCE(c.nominal, d.harga) AS nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false' 
    -- and c.unique_id = ''
    order BY c.created_at DESC limit 1 ] 
2023-08-27 23:11:24 - DEBUG --> [ UPDATE pembayaran SET kwitansi_generate = 'true' WHERE unique_id='BYR00000007' ] 
2023-08-27 23:15:56 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, TO_CHAR(c.tgl_jatuh_tempo, 'Month YYYY') AS bulan_tahun_jatuh_tempo, COALESCE(c.nominal, d.harga) AS nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan, 0 AS discount, 0 AS pajak,0 AS biaya_admin, 0 AS kode_unik, COALESCE(c.nominal, d.harga) AS total FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 23:15:58 - DEBUG --> [ UPDATE pembayaran SET kwitansi_generate = 'true' WHERE unique_id='BYR00000007' ] 
2023-08-27 23:16:00 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, TO_CHAR(c.tgl_jatuh_tempo, 'Month YYYY') AS bulan_tahun_jatuh_tempo, COALESCE(c.nominal, d.harga) AS nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan, 0 AS discount, 0 AS pajak,0 AS biaya_admin, 0 AS kode_unik, COALESCE(c.nominal, d.harga) AS total FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 23:16:02 - DEBUG --> [ UPDATE pembayaran SET kwitansi_generate = 'true' WHERE unique_id='BYR00000004' ] 
2023-08-27 23:16:03 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, TO_CHAR(c.tgl_jatuh_tempo, 'Month YYYY') AS bulan_tahun_jatuh_tempo, COALESCE(c.nominal, d.harga) AS nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan, 0 AS discount, 0 AS pajak,0 AS biaya_admin, 0 AS kode_unik, COALESCE(c.nominal, d.harga) AS total FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 23:16:05 - DEBUG --> [ UPDATE pembayaran SET kwitansi_generate = 'true' WHERE unique_id='' ] 
2023-08-27 23:17:24 - DEBUG --> [ SELECT a.unique_id no_pelanggan, a.nama nama, a.alamat, a.nomor_wa, e.email, a.nomor_hp, b.unique_id id_pemasangan, b.status status_pemasangan, b.keterangan keterangan_pemasangan, c.unique_id no_tagihan, TO_CHAR(c.tgl_bayar, 'DD Month YYYY') tgl_bayar, TO_CHAR(c.tgl_jatuh_tempo, 'DD Month YYYY') tgl_jatuh_tempo, TO_CHAR(c.tgl_jatuh_tempo, 'Month YYYY') AS bulan_tahun_jatuh_tempo, COALESCE(c.nominal, d.harga) AS nominal, CASE WHEN c.status_bayar = 'terbayar' THEN 'Lunas' ELSE 'Belum Lunas' END AS status_bayar, c.payment_method, c.keterangan keterangan_bayar, d.nama layanan, 0 AS discount, 0 AS pajak,0 AS biaya_admin, 0 AS kode_unik, COALESCE(c.nominal, d.harga) AS total FROM pelanggan a
    JOIN pemasangan b ON a.id = b.pelanggan_id
    JOIN pembayaran c ON b.id = c.pemasangan_id
    JOIN layanan d ON b.layanan_id = d.id
    JOIN users e ON a.user_id = e.id
    WHERE c.status_bayar = 'terbayar' AND c.kwitansi_generate = 'false'
    order BY c.created_at DESC limit 1 ] 
2023-08-27 23:17:24 - DEBUG --> Generate Invoice is empty