2023-08-29 22:58: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, 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-29 22:58:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 22:59: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, 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-29 22:59:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:00: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, 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-29 23:00:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:01: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, 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-29 23:01:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:02: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, 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-29 23:02:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:03: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, 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-29 23:03:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:04: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, 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-29 23:04:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:05: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, 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-29 23:05:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:06: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, 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-29 23:06:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:07: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, 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-29 23:07:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:08: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, 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-29 23:08:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:09: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, 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-29 23:09:02 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:10: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, 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-29 23:10:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:11: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, 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-29 23:11:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:12: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, 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-29 23:12:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:13: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, 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-29 23:13:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:14: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, 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-29 23:14:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:15: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, 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-29 23:15:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:16: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, 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-29 23:16:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:17: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, 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-29 23:17:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:18: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, 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-29 23:18:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:19: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, 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-29 23:19:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:20: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, 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-29 23:20:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:21: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, 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-29 23:21:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:22: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, 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-29 23:22:02 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:23: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, 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-29 23:23:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:24: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, 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-29 23:24:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:25: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, 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-29 23:25:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:26: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, 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-29 23:26:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:27: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, 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-29 23:27:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:28: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, 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-29 23:28:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:29: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, 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-29 23:29:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:30: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, 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-29 23:30:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:31: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, 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-29 23:31:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:32: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, 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-29 23:32:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:33: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, 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-29 23:33:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:34: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, 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-29 23:34:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:35: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, 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-29 23:35:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:36: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, 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-29 23:36:02 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:37: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, 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-29 23:37:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:38: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, 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-29 23:38:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23: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, 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-29 23:39:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:40: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, 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-29 23:40:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:41: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, 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-29 23:41:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:42: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, 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-29 23:42:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:43: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, 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-29 23:43:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:44: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, 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-29 23:44:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:45: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, 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-29 23:45:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:46: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, 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-29 23:46:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:47: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, 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-29 23:47:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:48: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, 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-29 23:48:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:49: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, 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-29 23:49:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:50: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, 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-29 23:50:02 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:51: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, 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-29 23:51:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:52: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, 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-29 23:52:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23: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, 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-29 23:53:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:54: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, 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-29 23:54:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:55: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, 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-29 23:55:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:56: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, 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-29 23:56:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:57: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, 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-29 23:57:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:58: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, 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-29 23:58:01 - DEBUG --> Generate Invoice is empty 
2023-08-29 23:59: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, 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-29 23:59:01 - DEBUG --> Generate Invoice is empty