[2025-10-17 01:39:54] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 01:39:54] [INFO] POST Data: {"pekerjaan_id":"","action":"create","jenis_pekerjaan":"Pengecekan Kabel","klien_id":"","detail_pekerjaan":"Pembenahan Redaman Arah Balongpanggang","prioritas":"tinggi","deadline":"2025-10-17T17:38","checkpoints":["Redaman dibawah -12","Hasil otdr tidak ada loss diatas -1"],"assign_user_id":"10"}
[2025-10-17 01:39:54] [INFO] User ID: 2, Role: admin
[2025-10-17 01:39:54] [INFO] Perusahaan ID: 1
[2025-10-17 01:39:54] [INFO] Action: create
[2025-10-17 01:39:54] [INFO] === CREATE PEKERJAAN START ===
[2025-10-17 01:39:54] [INFO] Jenis: Pengecekan Kabel, Detail: Pembenahan Redaman Arah Balongpanggang, Prioritas: tinggi
[2025-10-17 01:39:54] [INFO] Checkpoints raw: ["Redaman dibawah -12","Hasil otdr tidak ada loss diatas -1"]
[2025-10-17 01:39:54] [INFO] Checkpoints filtered: ["Redaman dibawah -12","Hasil otdr tidak ada loss diatas -1"]
[2025-10-17 01:39:54] [INFO] Kode Pekerjaan: PKJ-20251017-59F8FE
[2025-10-17 01:39:54] [INFO] Transaction started
[2025-10-17 01:39:54] [INFO] SQL Insert Pekerjaan: INSERT INTO pekerjaan (
                    kode_pekerjaan, jenis_pekerjaan, klien_id, detail_pekerjaan, 
                    perusahaan_id, created_by, status, prioritas, deadline
                ) V...
[2025-10-17 01:39:54] [INFO] Pekerjaan inserted with ID: 8
[2025-10-17 01:39:54] [INFO] Inserting checkpoint 1: Redaman dibawah -12
[2025-10-17 01:39:54] [INFO] Inserting checkpoint 2: Hasil otdr tidak ada loss diatas -1
[2025-10-17 01:39:54] [INFO] Total 2 checkpoints inserted
[2025-10-17 01:39:54] [INFO] Creating assignment to user: 10
[2025-10-17 01:39:54] [INFO] Transaction committed successfully
[2025-10-17 01:39:54] [INFO] === CREATE PEKERJAAN SUCCESS ===
[2025-10-17 01:39:54] [INFO] === HANDLER END ===
[2025-10-17 01:40:20] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 01:40:20] [INFO] POST Data: {"action":"get_detail","id":"8"}
[2025-10-17 01:40:20] [INFO] User ID: 2, Role: admin
[2025-10-17 01:40:20] [INFO] Perusahaan ID: 1
[2025-10-17 01:40:20] [INFO] Action: get_detail
[2025-10-17 01:40:20] [INFO] === GET PEKERJAAN DETAIL ===
[2025-10-17 01:40:20] [INFO] Pekerjaan ID: 8
[2025-10-17 01:40:20] [INFO] Detail retrieved successfully
[2025-10-17 01:40:20] [INFO] === HANDLER END ===
[2025-10-17 01:40:32] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 01:40:32] [INFO] POST Data: {"pekerjaan_id":"8","action":"update","jenis_pekerjaan":"Pengecekan Kabel","klien_id":"","detail_pekerjaan":"Pembenahan Redaman Arah Balongpanggang","prioritas":"sedang","deadline":"2025-10-17T17:38","checkpoints":["Redaman dibawah -12","Hasil otdr tidak ada loss diatas -1"],"assign_user_id":"10"}
[2025-10-17 01:40:32] [INFO] User ID: 2, Role: admin
[2025-10-17 01:40:32] [INFO] Perusahaan ID: 1
[2025-10-17 01:40:32] [INFO] Action: update
[2025-10-17 01:40:32] [INFO] === UPDATE PEKERJAAN START ===
[2025-10-17 01:40:32] [INFO] Pekerjaan ID: 8
[2025-10-17 01:40:32] [INFO] Transaction started
[2025-10-17 01:40:32] [INFO] Updating pekerjaan
[2025-10-17 01:40:32] [INFO] Old checkpoints deleted
[2025-10-17 01:40:32] [INFO] New checkpoints inserted
[2025-10-17 01:40:32] [INFO] Transaction committed
[2025-10-17 01:40:32] [INFO] === UPDATE PEKERJAAN SUCCESS ===
[2025-10-17 01:40:32] [INFO] === HANDLER END ===
[2025-10-17 01:42:35] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 01:42:35] [INFO] POST Data: {"pekerjaan_id":"","action":"create","jenis_pekerjaan":"Pembenahan WiFi","klien_id":"109","detail_pekerjaan":"Pembenahan","prioritas":"sedang","deadline":"","checkpoints":["Modem sudah hijau semua","Redaman ok"],"assign_user_id":"11"}
[2025-10-17 01:42:35] [INFO] User ID: 2, Role: admin
[2025-10-17 01:42:35] [INFO] Perusahaan ID: 1
[2025-10-17 01:42:35] [INFO] Action: create
[2025-10-17 01:42:35] [INFO] === CREATE PEKERJAAN START ===
[2025-10-17 01:42:35] [INFO] Jenis: Pembenahan WiFi, Detail: Pembenahan, Prioritas: sedang
[2025-10-17 01:42:35] [INFO] Checkpoints raw: ["Modem sudah hijau semua","Redaman ok"]
[2025-10-17 01:42:35] [INFO] Checkpoints filtered: ["Modem sudah hijau semua","Redaman ok"]
[2025-10-17 01:42:35] [INFO] Kode Pekerjaan: PKJ-20251017-32E917
[2025-10-17 01:42:35] [INFO] Transaction started
[2025-10-17 01:42:35] [INFO] SQL Insert Pekerjaan: INSERT INTO pekerjaan (
                    kode_pekerjaan, jenis_pekerjaan, klien_id, detail_pekerjaan, 
                    perusahaan_id, created_by, status, prioritas, deadline
                ) V...
[2025-10-17 01:42:35] [INFO] Pekerjaan inserted with ID: 9
[2025-10-17 01:42:35] [INFO] Inserting checkpoint 1: Modem sudah hijau semua
[2025-10-17 01:42:35] [INFO] Inserting checkpoint 2: Redaman ok
[2025-10-17 01:42:35] [INFO] Total 2 checkpoints inserted
[2025-10-17 01:42:35] [INFO] Creating assignment to user: 11
[2025-10-17 01:42:35] [INFO] Transaction committed successfully
[2025-10-17 01:42:35] [INFO] === CREATE PEKERJAAN SUCCESS ===
[2025-10-17 01:42:35] [INFO] === HANDLER END ===
[2025-10-17 01:43:43] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 01:43:43] [INFO] POST Data: {"pekerjaan_id":"","action":"create","jenis_pekerjaan":"Pembenahan WiFi","klien_id":"95","detail_pekerjaan":"Pembenahan","prioritas":"sedang","deadline":"","checkpoints":["Modem sudah hijau semua","Redaman dibawah -25"],"assign_user_id":""}
[2025-10-17 01:43:43] [INFO] User ID: 2, Role: admin
[2025-10-17 01:43:43] [INFO] Perusahaan ID: 1
[2025-10-17 01:43:43] [INFO] Action: create
[2025-10-17 01:43:43] [INFO] === CREATE PEKERJAAN START ===
[2025-10-17 01:43:43] [INFO] Jenis: Pembenahan WiFi, Detail: Pembenahan, Prioritas: sedang
[2025-10-17 01:43:43] [INFO] Checkpoints raw: ["Modem sudah hijau semua","Redaman dibawah -25"]
[2025-10-17 01:43:43] [INFO] Checkpoints filtered: ["Modem sudah hijau semua","Redaman dibawah -25"]
[2025-10-17 01:43:43] [INFO] Kode Pekerjaan: PKJ-20251017-3F5616
[2025-10-17 01:43:43] [INFO] Transaction started
[2025-10-17 01:43:43] [INFO] SQL Insert Pekerjaan: INSERT INTO pekerjaan (
                    kode_pekerjaan, jenis_pekerjaan, klien_id, detail_pekerjaan, 
                    perusahaan_id, created_by, status, prioritas, deadline
                ) V...
[2025-10-17 01:43:43] [INFO] Pekerjaan inserted with ID: 10
[2025-10-17 01:43:43] [INFO] Inserting checkpoint 1: Modem sudah hijau semua
[2025-10-17 01:43:43] [INFO] Inserting checkpoint 2: Redaman dibawah -25
[2025-10-17 01:43:43] [INFO] Total 2 checkpoints inserted
[2025-10-17 01:43:43] [INFO] Transaction committed successfully
[2025-10-17 01:43:43] [INFO] === CREATE PEKERJAAN SUCCESS ===
[2025-10-17 01:43:43] [INFO] === HANDLER END ===
[2025-10-17 01:45:39] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 01:45:39] [INFO] POST Data: {"pekerjaan_id":"","action":"create","jenis_pekerjaan":"Pembenahan WiFi","klien_id":"1138","detail_pekerjaan":"Pembenahan","prioritas":"sedang","deadline":"","checkpoints":["Modem sudah hijau semua","Redaman dibawah -25"],"assign_user_id":"12"}
[2025-10-17 01:45:39] [INFO] User ID: 2, Role: admin
[2025-10-17 01:45:39] [INFO] Perusahaan ID: 1
[2025-10-17 01:45:39] [INFO] Action: create
[2025-10-17 01:45:39] [INFO] === CREATE PEKERJAAN START ===
[2025-10-17 01:45:39] [INFO] Jenis: Pembenahan WiFi, Detail: Pembenahan, Prioritas: sedang
[2025-10-17 01:45:39] [INFO] Checkpoints raw: ["Modem sudah hijau semua","Redaman dibawah -25"]
[2025-10-17 01:45:39] [INFO] Checkpoints filtered: ["Modem sudah hijau semua","Redaman dibawah -25"]
[2025-10-17 01:45:39] [INFO] Kode Pekerjaan: PKJ-20251017-B50331
[2025-10-17 01:45:39] [INFO] Transaction started
[2025-10-17 01:45:39] [INFO] SQL Insert Pekerjaan: INSERT INTO pekerjaan (
                    kode_pekerjaan, jenis_pekerjaan, klien_id, detail_pekerjaan, 
                    perusahaan_id, created_by, status, prioritas, deadline
                ) V...
[2025-10-17 01:45:39] [INFO] Pekerjaan inserted with ID: 11
[2025-10-17 01:45:39] [INFO] Inserting checkpoint 1: Modem sudah hijau semua
[2025-10-17 01:45:39] [INFO] Inserting checkpoint 2: Redaman dibawah -25
[2025-10-17 01:45:39] [INFO] Total 2 checkpoints inserted
[2025-10-17 01:45:39] [INFO] Creating assignment to user: 12
[2025-10-17 01:45:39] [INFO] Transaction committed successfully
[2025-10-17 01:45:39] [INFO] === CREATE PEKERJAAN SUCCESS ===
[2025-10-17 01:45:39] [INFO] === HANDLER END ===
[2025-10-17 01:47:00] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 01:47:00] [INFO] POST Data: {"pekerjaan_id":"","action":"create","jenis_pekerjaan":"Pembenahan WiFi","klien_id":"1251","detail_pekerjaan":"Pembenahan","prioritas":"sedang","deadline":"","checkpoints":["Modem sudah hijau semua","Redaman dibawah -25"],"assign_user_id":"12"}
[2025-10-17 01:47:00] [INFO] User ID: 2, Role: admin
[2025-10-17 01:47:00] [INFO] Perusahaan ID: 1
[2025-10-17 01:47:00] [INFO] Action: create
[2025-10-17 01:47:00] [INFO] === CREATE PEKERJAAN START ===
[2025-10-17 01:47:00] [INFO] Jenis: Pembenahan WiFi, Detail: Pembenahan, Prioritas: sedang
[2025-10-17 01:47:00] [INFO] Checkpoints raw: ["Modem sudah hijau semua","Redaman dibawah -25"]
[2025-10-17 01:47:00] [INFO] Checkpoints filtered: ["Modem sudah hijau semua","Redaman dibawah -25"]
[2025-10-17 01:47:00] [INFO] Kode Pekerjaan: PKJ-20251017-4F2CEB
[2025-10-17 01:47:00] [INFO] Transaction started
[2025-10-17 01:47:00] [INFO] SQL Insert Pekerjaan: INSERT INTO pekerjaan (
                    kode_pekerjaan, jenis_pekerjaan, klien_id, detail_pekerjaan, 
                    perusahaan_id, created_by, status, prioritas, deadline
                ) V...
[2025-10-17 01:47:00] [INFO] Pekerjaan inserted with ID: 12
[2025-10-17 01:47:00] [INFO] Inserting checkpoint 1: Modem sudah hijau semua
[2025-10-17 01:47:00] [INFO] Inserting checkpoint 2: Redaman dibawah -25
[2025-10-17 01:47:00] [INFO] Total 2 checkpoints inserted
[2025-10-17 01:47:00] [INFO] Creating assignment to user: 12
[2025-10-17 01:47:00] [INFO] Transaction committed successfully
[2025-10-17 01:47:00] [INFO] === CREATE PEKERJAAN SUCCESS ===
[2025-10-17 01:47:00] [INFO] === HANDLER END ===
[2025-10-17 01:47:21] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 01:47:21] [INFO] POST Data: {"action":"update_checkpoint","pekerjaan_id":"8","checkpoint_id":"24","is_checked":"1","catatan":""}
[2025-10-17 01:47:21] [INFO] User ID: 10, Role: user
[2025-10-17 01:47:21] [INFO] Perusahaan ID: 1
[2025-10-17 01:47:21] [INFO] Action: update_checkpoint
[2025-10-17 01:47:21] [INFO] === UPDATE CHECKPOINT ===
[2025-10-17 01:47:21] [INFO] Checkpoint updated successfully
[2025-10-17 01:47:21] [INFO] === HANDLER END ===
[2025-10-17 01:47:23] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 01:47:23] [INFO] POST Data: {"action":"update_checkpoint","pekerjaan_id":"8","checkpoint_id":"24","is_checked":"0","catatan":""}
[2025-10-17 01:47:23] [INFO] User ID: 10, Role: user
[2025-10-17 01:47:23] [INFO] Perusahaan ID: 1
[2025-10-17 01:47:23] [INFO] Action: update_checkpoint
[2025-10-17 01:47:23] [INFO] === UPDATE CHECKPOINT ===
[2025-10-17 01:47:23] [INFO] Checkpoint updated successfully
[2025-10-17 01:47:23] [INFO] === HANDLER END ===
[2025-10-17 02:08:35] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 02:08:35] [INFO] POST Data: {"action":"update_checkpoint","pekerjaan_id":"12","checkpoint_id":"32","is_checked":"1","catatan":""}
[2025-10-17 02:08:35] [INFO] User ID: 12, Role: user
[2025-10-17 02:08:35] [INFO] Perusahaan ID: 1
[2025-10-17 02:08:35] [INFO] Action: update_checkpoint
[2025-10-17 02:08:35] [INFO] === UPDATE CHECKPOINT ===
[2025-10-17 02:08:35] [INFO] Checkpoint updated successfully
[2025-10-17 02:08:35] [INFO] === HANDLER END ===
[2025-10-17 02:08:36] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 02:08:36] [INFO] POST Data: {"action":"update_checkpoint","pekerjaan_id":"12","checkpoint_id":"32","is_checked":"0","catatan":""}
[2025-10-17 02:08:36] [INFO] User ID: 12, Role: user
[2025-10-17 02:08:36] [INFO] Perusahaan ID: 1
[2025-10-17 02:08:36] [INFO] Action: update_checkpoint
[2025-10-17 02:08:36] [INFO] === UPDATE CHECKPOINT ===
[2025-10-17 02:08:36] [INFO] Checkpoint updated successfully
[2025-10-17 02:08:36] [INFO] === HANDLER END ===
[2025-10-17 02:22:02] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 02:22:02] [INFO] POST Data: {"action":"update_checkpoint","pekerjaan_id":"11","checkpoint_id":"30","is_checked":"1","catatan":""}
[2025-10-17 02:22:02] [INFO] User ID: 12, Role: user
[2025-10-17 02:22:02] [INFO] Perusahaan ID: 1
[2025-10-17 02:22:02] [INFO] Action: update_checkpoint
[2025-10-17 02:22:02] [INFO] === UPDATE CHECKPOINT ===
[2025-10-17 02:22:02] [INFO] Checkpoint updated successfully
[2025-10-17 02:22:02] [INFO] === HANDLER END ===
[2025-10-17 02:22:38] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 02:22:38] [INFO] POST Data: {"action":"mulai_pekerjaan","id":"11"}
[2025-10-17 02:22:38] [INFO] User ID: 12, Role: user
[2025-10-17 02:22:38] [INFO] Perusahaan ID: 1
[2025-10-17 02:22:38] [INFO] Action: mulai_pekerjaan
[2025-10-17 02:22:38] [INFO] === MULAI PEKERJAAN ===
[2025-10-17 02:22:38] [INFO] Pekerjaan started successfully
[2025-10-17 02:22:38] [INFO] === HANDLER END ===
[2025-10-17 02:23:08] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 02:23:08] [INFO] POST Data: {"action":"selesai_pekerjaan","pekerjaan_id":"11"}
[2025-10-17 02:23:08] [INFO] User ID: 12, Role: user
[2025-10-17 02:23:08] [INFO] Perusahaan ID: 1
[2025-10-17 02:23:08] [INFO] Action: selesai_pekerjaan
[2025-10-17 02:23:08] [INFO] === SELESAI PEKERJAAN ===
[2025-10-17 02:23:08] [INFO] === HANDLER END ===
[2025-10-17 02:23:29] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 02:23:29] [INFO] POST Data: {"note_type":"info","catatan":"Ganti modem","action":"tambah_catatan","pekerjaan_id":"11"}
[2025-10-17 02:23:29] [INFO] User ID: 12, Role: user
[2025-10-17 02:23:29] [INFO] Perusahaan ID: 1
[2025-10-17 02:23:29] [INFO] Action: tambah_catatan
[2025-10-17 02:23:29] [INFO] === TAMBAH CATATAN ===
[2025-10-17 02:23:29] [INFO] Catatan added successfully
[2025-10-17 02:23:29] [INFO] === HANDLER END ===
[2025-10-17 02:23:29] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 02:23:29] [INFO] POST Data: {"note_type":"info","catatan":"Ganti modem","action":"tambah_catatan","pekerjaan_id":"11"}
[2025-10-17 02:23:29] [INFO] User ID: 12, Role: user
[2025-10-17 02:23:29] [INFO] Perusahaan ID: 1
[2025-10-17 02:23:29] [INFO] Action: tambah_catatan
[2025-10-17 02:23:29] [INFO] === TAMBAH CATATAN ===
[2025-10-17 02:23:29] [INFO] Catatan added successfully
[2025-10-17 02:23:29] [INFO] === HANDLER END ===
[2025-10-17 02:23:34] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 02:23:34] [INFO] POST Data: {"action":"selesai_pekerjaan","pekerjaan_id":"11"}
[2025-10-17 02:23:34] [INFO] User ID: 12, Role: user
[2025-10-17 02:23:34] [INFO] Perusahaan ID: 1
[2025-10-17 02:23:34] [INFO] Action: selesai_pekerjaan
[2025-10-17 02:23:34] [INFO] === SELESAI PEKERJAAN ===
[2025-10-17 02:23:34] [INFO] === HANDLER END ===
[2025-10-17 02:23:58] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 02:23:58] [INFO] POST Data: {"action":"selesai_pekerjaan","pekerjaan_id":"11"}
[2025-10-17 02:23:58] [INFO] User ID: 12, Role: user
[2025-10-17 02:23:58] [INFO] Perusahaan ID: 1
[2025-10-17 02:23:58] [INFO] Action: selesai_pekerjaan
[2025-10-17 02:23:58] [INFO] === SELESAI PEKERJAAN ===
[2025-10-17 02:23:58] [INFO] === HANDLER END ===
[2025-10-17 02:24:24] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 02:24:24] [INFO] POST Data: {"action":"selesai_pekerjaan","pekerjaan_id":"11"}
[2025-10-17 02:24:24] [INFO] User ID: 12, Role: user
[2025-10-17 02:24:24] [INFO] Perusahaan ID: 1
[2025-10-17 02:24:24] [INFO] Action: selesai_pekerjaan
[2025-10-17 02:24:24] [INFO] === SELESAI PEKERJAAN ===
[2025-10-17 02:24:24] [INFO] === HANDLER END ===
[2025-10-17 02:25:00] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 02:25:00] [INFO] POST Data: {"action":"update_checkpoint","pekerjaan_id":"11","checkpoint_id":"30","is_checked":"0","catatan":""}
[2025-10-17 02:25:00] [INFO] User ID: 12, Role: user
[2025-10-17 02:25:00] [INFO] Perusahaan ID: 1
[2025-10-17 02:25:00] [INFO] Action: update_checkpoint
[2025-10-17 02:25:00] [INFO] === UPDATE CHECKPOINT ===
[2025-10-17 02:25:00] [INFO] Checkpoint updated successfully
[2025-10-17 02:25:00] [INFO] === HANDLER END ===
[2025-10-17 02:25:01] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 02:25:01] [INFO] POST Data: {"action":"update_checkpoint","pekerjaan_id":"11","checkpoint_id":"30","is_checked":"1","catatan":""}
[2025-10-17 02:25:01] [INFO] User ID: 12, Role: user
[2025-10-17 02:25:01] [INFO] Perusahaan ID: 1
[2025-10-17 02:25:01] [INFO] Action: update_checkpoint
[2025-10-17 02:25:01] [INFO] === UPDATE CHECKPOINT ===
[2025-10-17 02:25:01] [INFO] Checkpoint updated successfully
[2025-10-17 02:25:01] [INFO] === HANDLER END ===
[2025-10-17 02:25:14] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 02:25:14] [INFO] POST Data: {"action":"selesai_pekerjaan","pekerjaan_id":"11"}
[2025-10-17 02:25:14] [INFO] User ID: 12, Role: user
[2025-10-17 02:25:14] [INFO] Perusahaan ID: 1
[2025-10-17 02:25:14] [INFO] Action: selesai_pekerjaan
[2025-10-17 02:25:14] [INFO] === SELESAI PEKERJAAN ===
[2025-10-17 02:25:14] [INFO] === HANDLER END ===
[2025-10-17 02:25:49] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 02:25:49] [INFO] POST Data: {"action":"selesai_pekerjaan","pekerjaan_id":"11"}
[2025-10-17 02:25:49] [INFO] User ID: 12, Role: user
[2025-10-17 02:25:49] [INFO] Perusahaan ID: 1
[2025-10-17 02:25:49] [INFO] Action: selesai_pekerjaan
[2025-10-17 02:25:49] [INFO] === SELESAI PEKERJAAN ===
[2025-10-17 02:25:49] [INFO] === HANDLER END ===
[2025-10-17 02:41:43] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 02:41:43] [INFO] POST Data: {"action":"get_detail","id":"10"}
[2025-10-17 02:41:43] [INFO] User ID: 2, Role: admin
[2025-10-17 02:41:43] [INFO] Perusahaan ID: 1
[2025-10-17 02:41:43] [INFO] Action: get_detail
[2025-10-17 02:41:43] [INFO] === GET PEKERJAAN DETAIL ===
[2025-10-17 02:41:43] [INFO] Pekerjaan ID: 10
[2025-10-17 02:41:43] [INFO] Detail retrieved successfully
[2025-10-17 02:41:43] [INFO] === HANDLER END ===
[2025-10-17 02:42:55] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 02:42:55] [INFO] POST Data: {"action":"get_detail","id":"10"}
[2025-10-17 02:42:55] [INFO] User ID: 2, Role: admin
[2025-10-17 02:42:55] [INFO] Perusahaan ID: 1
[2025-10-17 02:42:55] [INFO] Action: get_detail
[2025-10-17 02:42:55] [INFO] === GET PEKERJAAN DETAIL ===
[2025-10-17 02:42:55] [INFO] Pekerjaan ID: 10
[2025-10-17 02:42:55] [INFO] Detail retrieved successfully
[2025-10-17 02:42:55] [INFO] === HANDLER END ===
[2025-10-17 02:43:53] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 02:43:53] [INFO] POST Data: {"action":"get_detail","id":"10"}
[2025-10-17 02:43:53] [INFO] User ID: 2, Role: admin
[2025-10-17 02:43:53] [INFO] Perusahaan ID: 1
[2025-10-17 02:43:53] [INFO] Action: get_detail
[2025-10-17 02:43:53] [INFO] === GET PEKERJAAN DETAIL ===
[2025-10-17 02:43:53] [INFO] Pekerjaan ID: 10
[2025-10-17 02:43:53] [INFO] Detail retrieved successfully
[2025-10-17 02:43:53] [INFO] === HANDLER END ===
[2025-10-17 03:22:30] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 03:22:30] [INFO] POST Data: {"action":"mulai_pekerjaan","id":"9"}
[2025-10-17 03:22:30] [INFO] User ID: 11, Role: user
[2025-10-17 03:22:30] [INFO] Perusahaan ID: 1
[2025-10-17 03:22:30] [INFO] Action: mulai_pekerjaan
[2025-10-17 03:22:30] [INFO] === MULAI PEKERJAAN ===
[2025-10-17 03:22:30] [INFO] Pekerjaan started successfully
[2025-10-17 03:22:30] [INFO] === HANDLER END ===
[2025-10-17 03:55:01] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 03:55:01] [INFO] POST Data: {"action":"update_checkpoint","pekerjaan_id":"9","checkpoint_id":"26","is_checked":"1","catatan":""}
[2025-10-17 03:55:01] [INFO] User ID: 11, Role: user
[2025-10-17 03:55:01] [INFO] Perusahaan ID: 1
[2025-10-17 03:55:01] [INFO] Action: update_checkpoint
[2025-10-17 03:55:01] [INFO] === UPDATE CHECKPOINT ===
[2025-10-17 03:55:01] [INFO] Checkpoint updated successfully
[2025-10-17 03:55:01] [INFO] === HANDLER END ===
[2025-10-17 03:58:07] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 03:58:07] [INFO] POST Data: {"action":"update_checkpoint","pekerjaan_id":"12","checkpoint_id":"32","is_checked":"1","catatan":""}
[2025-10-17 03:58:07] [INFO] User ID: 12, Role: user
[2025-10-17 03:58:07] [INFO] Perusahaan ID: 1
[2025-10-17 03:58:07] [INFO] Action: update_checkpoint
[2025-10-17 03:58:07] [INFO] === UPDATE CHECKPOINT ===
[2025-10-17 03:58:07] [INFO] Checkpoint updated successfully
[2025-10-17 03:58:07] [INFO] === HANDLER END ===
[2025-10-17 03:58:07] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 03:58:07] [INFO] POST Data: {"action":"update_checkpoint","pekerjaan_id":"12","checkpoint_id":"32","is_checked":"1","catatan":""}
[2025-10-17 03:58:07] [INFO] User ID: 12, Role: user
[2025-10-17 03:58:07] [INFO] Perusahaan ID: 1
[2025-10-17 03:58:07] [INFO] Action: update_checkpoint
[2025-10-17 03:58:07] [INFO] === UPDATE CHECKPOINT ===
[2025-10-17 03:58:07] [INFO] Checkpoint updated successfully
[2025-10-17 03:58:07] [INFO] === HANDLER END ===
[2025-10-17 03:58:20] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 03:58:20] [INFO] POST Data: {"note_type":"info","catatan":"Redaman naik","action":"tambah_catatan","pekerjaan_id":"12"}
[2025-10-17 03:58:20] [INFO] User ID: 12, Role: user
[2025-10-17 03:58:20] [INFO] Perusahaan ID: 1
[2025-10-17 03:58:20] [INFO] Action: tambah_catatan
[2025-10-17 03:58:20] [INFO] === TAMBAH CATATAN ===
[2025-10-17 03:58:20] [INFO] Catatan added successfully
[2025-10-17 03:58:20] [INFO] === HANDLER END ===
[2025-10-17 03:58:25] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 03:58:25] [INFO] POST Data: {"action":"mulai_pekerjaan","id":"12"}
[2025-10-17 03:58:25] [INFO] User ID: 12, Role: user
[2025-10-17 03:58:25] [INFO] Perusahaan ID: 1
[2025-10-17 03:58:25] [INFO] Action: mulai_pekerjaan
[2025-10-17 03:58:25] [INFO] === MULAI PEKERJAAN ===
[2025-10-17 03:58:25] [INFO] Pekerjaan started successfully
[2025-10-17 03:58:25] [INFO] === HANDLER END ===
[2025-10-17 03:58:30] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 03:58:30] [INFO] POST Data: {"action":"selesai_pekerjaan","pekerjaan_id":"12"}
[2025-10-17 03:58:30] [INFO] User ID: 12, Role: user
[2025-10-17 03:58:30] [INFO] Perusahaan ID: 1
[2025-10-17 03:58:30] [INFO] Action: selesai_pekerjaan
[2025-10-17 03:58:30] [INFO] === SELESAI PEKERJAAN ===
[2025-10-17 03:58:30] [INFO] === HANDLER END ===
[2025-10-17 04:43:37] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 04:43:37] [INFO] POST Data: {"invite_user_id":"11","action":"invite_rekan","pekerjaan_id":"8"}
[2025-10-17 04:43:37] [INFO] User ID: 10, Role: user
[2025-10-17 04:43:37] [INFO] Perusahaan ID: 1
[2025-10-17 04:43:37] [INFO] Action: invite_rekan
[2025-10-17 04:43:37] [INFO] === INVITE REKAN ===
[2025-10-17 04:43:37] [INFO] Invite rekan success
[2025-10-17 04:43:37] [INFO] === HANDLER END ===
[2025-10-17 04:43:47] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 04:43:47] [INFO] POST Data: {"invite_user_id":"12","action":"invite_rekan","pekerjaan_id":"8"}
[2025-10-17 04:43:47] [INFO] User ID: 10, Role: user
[2025-10-17 04:43:47] [INFO] Perusahaan ID: 1
[2025-10-17 04:43:47] [INFO] Action: invite_rekan
[2025-10-17 04:43:47] [INFO] === INVITE REKAN ===
[2025-10-17 04:43:47] [INFO] Invite rekan success
[2025-10-17 04:43:47] [INFO] === HANDLER END ===
[2025-10-17 07:12:46] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 07:12:46] [INFO] POST Data: {"action":"get_detail","id":"10"}
[2025-10-17 07:12:46] [INFO] User ID: 2, Role: admin
[2025-10-17 07:12:46] [INFO] Perusahaan ID: 1
[2025-10-17 07:12:46] [INFO] Action: get_detail
[2025-10-17 07:12:46] [INFO] === GET PEKERJAAN DETAIL ===
[2025-10-17 07:12:46] [INFO] Pekerjaan ID: 10
[2025-10-17 07:12:46] [INFO] Detail retrieved successfully
[2025-10-17 07:12:46] [INFO] === HANDLER END ===
[2025-10-17 07:12:53] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 07:12:53] [INFO] POST Data: {"action":"get_detail","id":"10"}
[2025-10-17 07:12:53] [INFO] User ID: 2, Role: admin
[2025-10-17 07:12:53] [INFO] Perusahaan ID: 1
[2025-10-17 07:12:53] [INFO] Action: get_detail
[2025-10-17 07:12:53] [INFO] === GET PEKERJAAN DETAIL ===
[2025-10-17 07:12:53] [INFO] Pekerjaan ID: 10
[2025-10-17 07:12:53] [INFO] Detail retrieved successfully
[2025-10-17 07:12:53] [INFO] === HANDLER END ===
[2025-10-17 07:13:04] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 07:13:04] [INFO] POST Data: {"action":"update","pekerjaan_id":"10","jenis_pekerjaan":"Pembenahan WiFi","klien_id":"95","detail_pekerjaan":"Pembenahan","prioritas":"sedang","deadline":"","assign_user_id":"","checkpoints":["Modem sudah hijau semua","Redaman dibawah -25"]}
[2025-10-17 07:13:04] [INFO] User ID: 2, Role: admin
[2025-10-17 07:13:04] [INFO] Perusahaan ID: 1
[2025-10-17 07:13:04] [INFO] Action: update
[2025-10-17 07:13:04] [INFO] === UPDATE PEKERJAAN START ===
[2025-10-17 07:13:04] [INFO] Pekerjaan ID: 10
[2025-10-17 07:13:04] [INFO] Transaction started
[2025-10-17 07:13:04] [INFO] Updating pekerjaan
[2025-10-17 07:13:04] [INFO] Old checkpoints deleted
[2025-10-17 07:13:04] [INFO] New checkpoints inserted
[2025-10-17 07:13:04] [INFO] Assignment removed
[2025-10-17 07:13:04] [INFO] Transaction committed
[2025-10-17 07:13:04] [INFO] === UPDATE PEKERJAAN SUCCESS ===
[2025-10-17 07:13:04] [INFO] === HANDLER END ===
[2025-10-17 07:13:38] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 07:13:38] [INFO] POST Data: {"action":"create","pekerjaan_id":"","jenis_pekerjaan":"Pembenahan WiFi","klien_id":"622","detail_pekerjaan":"test","prioritas":"sedang","deadline":"","assign_user_id":"","checkpoints":["test saja","test kedua"]}
[2025-10-17 07:13:38] [INFO] User ID: 2, Role: admin
[2025-10-17 07:13:38] [INFO] Perusahaan ID: 1
[2025-10-17 07:13:38] [INFO] Action: create
[2025-10-17 07:13:38] [INFO] === CREATE PEKERJAAN START ===
[2025-10-17 07:13:38] [INFO] Jenis: Pembenahan WiFi, Detail: test, Prioritas: sedang
[2025-10-17 07:13:38] [INFO] Checkpoints raw: ["test saja","test kedua"]
[2025-10-17 07:13:38] [INFO] Checkpoints filtered: ["test saja","test kedua"]
[2025-10-17 07:13:38] [INFO] Kode Pekerjaan: PKJ-20251017-6360EB
[2025-10-17 07:13:38] [INFO] Transaction started
[2025-10-17 07:13:38] [INFO] SQL Insert Pekerjaan: INSERT INTO pekerjaan (
                    kode_pekerjaan, jenis_pekerjaan, klien_id, detail_pekerjaan, 
                    perusahaan_id, created_by, status, prioritas, deadline
                ) V...
[2025-10-17 07:13:38] [INFO] Pekerjaan inserted with ID: 13
[2025-10-17 07:13:38] [INFO] Inserting checkpoint 1: test saja
[2025-10-17 07:13:38] [INFO] Inserting checkpoint 2: test kedua
[2025-10-17 07:13:38] [INFO] Total 2 checkpoints inserted
[2025-10-17 07:13:38] [INFO] Transaction committed successfully
[2025-10-17 07:13:38] [INFO] === CREATE PEKERJAAN SUCCESS ===
[2025-10-17 07:13:38] [INFO] === HANDLER END ===
[2025-10-17 07:13:48] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 07:13:48] [INFO] POST Data: {"action":"delete","id":"13"}
[2025-10-17 07:13:48] [INFO] User ID: 2, Role: admin
[2025-10-17 07:13:48] [INFO] Perusahaan ID: 1
[2025-10-17 07:13:48] [INFO] Action: delete
[2025-10-17 07:13:48] [INFO] === DELETE PEKERJAAN START ===
[2025-10-17 07:13:48] [INFO] Pekerjaan ID: 13
[2025-10-17 07:13:48] [INFO] Pekerjaan deleted successfully
[2025-10-17 07:13:48] [INFO] === HANDLER END ===
[2025-10-17 07:18:01] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 07:18:01] [INFO] POST Data: {"action":"create","pekerjaan_id":"","jenis_pekerjaan":"Pembenahan WiFi","klien_id":"1367","detail_pekerjaan":"test","prioritas":"sedang","deadline":"","assign_user_id":"","checkpoints":["test 1","test 2","test 3"]}
[2025-10-17 07:18:01] [INFO] User ID: 2, Role: admin
[2025-10-17 07:18:01] [INFO] Perusahaan ID: 1
[2025-10-17 07:18:01] [INFO] Action: create
[2025-10-17 07:18:01] [INFO] === CREATE PEKERJAAN START ===
[2025-10-17 07:18:01] [INFO] Jenis: Pembenahan WiFi, Detail: test, Prioritas: sedang
[2025-10-17 07:18:01] [INFO] Checkpoints raw: ["test 1","test 2","test 3"]
[2025-10-17 07:18:01] [INFO] Checkpoints after cleaning and removing duplicates: ["test 1","test 2","test 3"]
[2025-10-17 07:18:01] [INFO] Kode Pekerjaan: PKJ-20251017-936CA7
[2025-10-17 07:18:01] [INFO] Transaction started
[2025-10-17 07:18:01] [INFO] SQL Insert Pekerjaan: INSERT INTO pekerjaan (
                    kode_pekerjaan, jenis_pekerjaan, klien_id, detail_pekerjaan, 
                    perusahaan_id, created_by, status, prioritas, deadline, created_at
       ...
[2025-10-17 07:18:01] [INFO] Pekerjaan inserted with ID: 14
[2025-10-17 07:18:01] [INFO] Inserting checkpoint 1: test 1
[2025-10-17 07:18:01] [INFO] Inserting checkpoint 2: test 2
[2025-10-17 07:18:01] [INFO] Inserting checkpoint 3: test 3
[2025-10-17 07:18:01] [INFO] Total 3 unique checkpoints inserted
[2025-10-17 07:18:01] [INFO] Transaction committed successfully
[2025-10-17 07:18:01] [INFO] === CREATE PEKERJAAN SUCCESS ===
[2025-10-17 07:18:01] [INFO] === HANDLER END ===
[2025-10-17 07:18:11] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 07:18:11] [INFO] POST Data: {"action":"get_detail","id":"14"}
[2025-10-17 07:18:11] [INFO] User ID: 2, Role: admin
[2025-10-17 07:18:11] [INFO] Perusahaan ID: 1
[2025-10-17 07:18:11] [INFO] Action: get_detail
[2025-10-17 07:18:11] [INFO] === GET PEKERJAAN DETAIL ===
[2025-10-17 07:18:11] [INFO] Pekerjaan ID: 14
[2025-10-17 07:18:11] [INFO] Detail retrieved successfully with 3 checkpoints
[2025-10-17 07:18:11] [INFO] === HANDLER END ===
[2025-10-17 07:18:20] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 07:18:20] [INFO] POST Data: {"action":"update","pekerjaan_id":"14","jenis_pekerjaan":"Pembenahan WiFi","klien_id":"1367","detail_pekerjaan":"test","prioritas":"sedang","deadline":"","assign_user_id":"","checkpoints":["test 1","test 2","test 3","test 4","test 5"]}
[2025-10-17 07:18:20] [INFO] User ID: 2, Role: admin
[2025-10-17 07:18:20] [INFO] Perusahaan ID: 1
[2025-10-17 07:18:20] [INFO] Action: update
[2025-10-17 07:18:20] [INFO] === UPDATE PEKERJAAN START ===
[2025-10-17 07:18:20] [INFO] Pekerjaan ID: 14
[2025-10-17 07:18:20] [INFO] Checkpoints after cleaning: ["test 1","test 2","test 3","test 4","test 5"]
[2025-10-17 07:18:20] [INFO] Transaction started
[2025-10-17 07:18:20] [INFO] Updating pekerjaan
[2025-10-17 07:18:20] [INFO] Old checkpoints deleted
[2025-10-17 07:18:20] [INFO] Inserted 5 unique checkpoints
[2025-10-17 07:18:20] [INFO] Assignment removed, status set to tersedia
[2025-10-17 07:18:20] [INFO] Transaction committed
[2025-10-17 07:18:20] [INFO] === UPDATE PEKERJAAN SUCCESS ===
[2025-10-17 07:18:20] [INFO] === HANDLER END ===
[2025-10-17 08:56:38] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 08:56:38] [INFO] POST Data: {"action":"update_checkpoint","pekerjaan_id":"8","checkpoint_id":"24","is_checked":"1","catatan":"mentok di -14"}
[2025-10-17 08:56:38] [INFO] User ID: 10, Role: user
[2025-10-17 08:56:38] [INFO] Perusahaan ID: 1
[2025-10-17 08:56:38] [INFO] Action: update_checkpoint
[2025-10-17 08:56:38] [INFO] === UPDATE CHECKPOINT ===
[2025-10-17 08:56:38] [INFO] Pekerjaan: 8, Checkpoint: 24, Checked: 1
[2025-10-17 08:56:38] [INFO] Checkpoint updated successfully
[2025-10-17 08:56:38] [INFO] === HANDLER END ===
[2025-10-17 08:57:26] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 08:57:26] [INFO] POST Data: {"action":"ambil_pekerjaan","id":"10"}
[2025-10-17 08:57:26] [INFO] User ID: 11, Role: user
[2025-10-17 08:57:26] [INFO] Perusahaan ID: 1
[2025-10-17 08:57:26] [INFO] Action: ambil_pekerjaan
[2025-10-17 08:57:26] [INFO] === AMBIL PEKERJAAN START ===
[2025-10-17 08:57:26] [INFO] Pekerjaan ID: 10
[2025-10-17 08:57:26] [INFO] Transaction started
[2025-10-17 08:57:26] [INFO] Pekerjaan ambil success by user: 11
[2025-10-17 08:57:26] [INFO] === HANDLER END ===
[2025-10-17 08:57:36] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 08:57:36] [INFO] POST Data: {"action":"update_checkpoint","pekerjaan_id":"10","checkpoint_id":"34","is_checked":"1","catatan":""}
[2025-10-17 08:57:36] [INFO] User ID: 11, Role: user
[2025-10-17 08:57:36] [INFO] Perusahaan ID: 1
[2025-10-17 08:57:36] [INFO] Action: update_checkpoint
[2025-10-17 08:57:36] [INFO] === UPDATE CHECKPOINT ===
[2025-10-17 08:57:36] [INFO] Pekerjaan: 10, Checkpoint: 34, Checked: 1
[2025-10-17 08:57:36] [INFO] Checkpoint updated successfully
[2025-10-17 08:57:36] [INFO] === HANDLER END ===
[2025-10-17 08:57:44] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 08:57:44] [INFO] POST Data: {"action":"mulai_pekerjaan","id":"10"}
[2025-10-17 08:57:44] [INFO] User ID: 11, Role: user
[2025-10-17 08:57:44] [INFO] Perusahaan ID: 1
[2025-10-17 08:57:44] [INFO] Action: mulai_pekerjaan
[2025-10-17 08:57:44] [INFO] === MULAI PEKERJAAN ===
[2025-10-17 08:57:44] [ERROR] Failed to start: Unknown column 'updated_at' in 'SET'
[2025-10-17 08:57:44] [INFO] === HANDLER END ===
[2025-10-17 09:22:08] [INFO] === PEKERJAAN HANDLER ACCESSED ===
[2025-10-17 09:22:08] [INFO] POST Data: {"action":"mulai_pekerjaan","id":"10"}
[2025-10-17 09:22:08] [INFO] User ID: 11, Role: user
[2025-10-17 09:22:08] [INFO] Perusahaan ID: 1
[2025-10-17 09:22:08] [INFO] Action: mulai_pekerjaan
[2025-10-17 09:22:08] [INFO] === MULAI PEKERJAAN ===
[2025-10-17 09:22:08] [ERROR] Failed to start: Unknown column 'updated_at' in 'SET'
[2025-10-17 09:22:08] [INFO] === HANDLER END ===