[2026-01-01 00:16:18] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 00:16:18] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 00:16:18] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 00:16:18] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 00:16:18] [INFO] Salary data retrieved | Context: {"count":0} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 00:16:18] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 00:16:23] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 00:16:23] [INFO] Get salary data | Context: {"bulan":12,"tahun":2026} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 00:16:23] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2026
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 00:16:23] [INFO] Salary data retrieved | Context: {"count":0} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 00:16:29] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 00:16:29] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 00:16:29] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 00:16:29] [INFO] Salary data retrieved | Context: {"count":7} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 00:16:45] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 00:16:45] [INFO] Get salary data | Context: {"bulan":1,"tahun":2025} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 00:16:45] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2025
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 00:16:45] [INFO] Salary data retrieved | Context: {"count":0} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 00:16:47] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 00:16:47] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 00:16:47] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 00:16:47] [INFO] Salary data retrieved | Context: {"count":0} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 02:33:23] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 02:33:23] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 02:33:23] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 02:33:23] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '16'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 02:33:23] [INFO] Salary data retrieved | Context: {"count":0} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 01:01:49] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 01:01:49] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:01:49] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 01:01:49] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 01:01:49] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:01:49] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:01:49] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:01:49] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:01:49] [INFO] Salary data retrieved | Context: {"count":0} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 01:01:49] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 01:01:49] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 08:01:49] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 01:02:06] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 01:02:06] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:06] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 01:02:06] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 01:02:06] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 08:02:06] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 01:02:06] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 01:02:06] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:02:06] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:02:06] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:02:06] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:02:06] [INFO] Salary data retrieved | Context: {"count":0} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 01:02:09] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 01:02:09] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 08:02:09] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 08:02:09] [INFO] Get salary data | Context: {"bulan":12,"tahun":2026} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 08:02:09] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2026
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 08:02:09] [INFO] Salary data retrieved | Context: {"count":0} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 01:02:11] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 01:02:11] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 08:02:11] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 08:02:11] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 08:02:11] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 08:02:11] [INFO] Salary data retrieved | Context: {"count":7} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 01:02:19] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 01:02:19] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:19] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:19] [INFO] Calculate salary request | Context: {"ajax_action":"calculate_salary","bulan":"12","tahun":"2025"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:19] [INFO] Calculating salary | Context: {"bulan":12,"tahun":2025,"perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:19] [INFO] Transaction started | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:19] [INFO] Config loaded | Context: {"pool":14000000,"fee":120000} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:19] [SQL] 
            SELECT SUM(total_nilai) as grand_total
            FROM (
                SELECT 
                    a.user_id,
                    SUM(CASE 
                        WHEN a.durasi_kerja_menit >= 480 THEN 1 
                        WHEN a.durasi_kerja_menit > 0 THEN 0.5 
                        WHEN a.jam_keluar IS NULL AND a.jam_masuk IS NOT NULL THEN 0.5 
                        ELSE 0 
                    END) as total_nilai
                FROM absensi a
                INNER JOIN users u ON a.user_id = u.id
                WHERE MONTH(a.tanggal) = ? 
                AND YEAR(a.tanggal) = ?
                AND u.perusahaan_id = ?
                AND u.role != 'admin'
                GROUP BY a.user_id
            ) as totals
         | Context: [12,2025,"1"] | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:19] [INFO] Total nilai absensi calculated | Context: {"total":134} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:19] [SQL] 
            SELECT 
                u.id as user_id,
                u.nama_lengkap,
                SUM(CASE 
                    WHEN a.durasi_kerja_menit >= 480 THEN 1 
                    WHEN a.durasi_kerja_menit > 0 THEN 0.5 
                    WHEN a.jam_keluar IS NULL AND a.jam_masuk IS NOT NULL THEN 0.5 
                    ELSE 0 
                END) as total_nilai
            FROM users u
            INNER JOIN absensi a ON u.id = a.user_id
            WHERE MONTH(a.tanggal) = ? 
            AND YEAR(a.tanggal) = ?
            AND u.perusahaan_id = ?
            AND u.role != 'admin'
            GROUP BY u.id, u.nama_lengkap
            HAVING total_nilai > 0
         | Context: [12,2025,"1"] | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:19] [INFO] Processing user | Context: {"user_id":10,"nama":"Nanda DBN","nilai":26} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:19] [INFO] Fee pemasangan calculated | Context: {"user_id":10,"utama":5,"pembantu":4,"total_fee":520000} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:19] [INFO] Salary calculated | Context: {"user_id":10,"gaji_pokok":2716417.9104477614,"fee_total":520000,"potongan":0,"keterangan_potongan":"","gaji_total":3236417.9104477614} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:19] [INFO] Type definition | Context: {"definition":"iiiiddddddiisdddsd","length":18} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:19] [ERROR] Exception: The number of elements in the type definition string must match the number of bind variables | Context: {"file":"\/home\/moxe6138\/public_html\/kas_dbn\/menu\/penggajian.php","line":415,"trace":"#0 \/home\/moxe6138\/public_html\/kas_dbn\/menu\/penggajian.php(415): mysqli_stmt->bind_param()\n#1 {main}"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 01:02:25] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 01:02:25] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:25] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:25] [INFO] Calculate salary request | Context: {"ajax_action":"calculate_salary","bulan":"12","tahun":"2025"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:25] [INFO] Calculating salary | Context: {"bulan":12,"tahun":2025,"perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:25] [INFO] Transaction started | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:25] [INFO] Config loaded | Context: {"pool":14000000,"fee":120000} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:25] [SQL] 
            SELECT SUM(total_nilai) as grand_total
            FROM (
                SELECT 
                    a.user_id,
                    SUM(CASE 
                        WHEN a.durasi_kerja_menit >= 480 THEN 1 
                        WHEN a.durasi_kerja_menit > 0 THEN 0.5 
                        WHEN a.jam_keluar IS NULL AND a.jam_masuk IS NOT NULL THEN 0.5 
                        ELSE 0 
                    END) as total_nilai
                FROM absensi a
                INNER JOIN users u ON a.user_id = u.id
                WHERE MONTH(a.tanggal) = ? 
                AND YEAR(a.tanggal) = ?
                AND u.perusahaan_id = ?
                AND u.role != 'admin'
                GROUP BY a.user_id
            ) as totals
         | Context: [12,2025,"1"] | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:25] [INFO] Total nilai absensi calculated | Context: {"total":134} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:25] [SQL] 
            SELECT 
                u.id as user_id,
                u.nama_lengkap,
                SUM(CASE 
                    WHEN a.durasi_kerja_menit >= 480 THEN 1 
                    WHEN a.durasi_kerja_menit > 0 THEN 0.5 
                    WHEN a.jam_keluar IS NULL AND a.jam_masuk IS NOT NULL THEN 0.5 
                    ELSE 0 
                END) as total_nilai
            FROM users u
            INNER JOIN absensi a ON u.id = a.user_id
            WHERE MONTH(a.tanggal) = ? 
            AND YEAR(a.tanggal) = ?
            AND u.perusahaan_id = ?
            AND u.role != 'admin'
            GROUP BY u.id, u.nama_lengkap
            HAVING total_nilai > 0
         | Context: [12,2025,"1"] | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:25] [INFO] Processing user | Context: {"user_id":10,"nama":"Nanda DBN","nilai":26} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:25] [INFO] Fee pemasangan calculated | Context: {"user_id":10,"utama":5,"pembantu":4,"total_fee":520000} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:25] [INFO] Salary calculated | Context: {"user_id":10,"gaji_pokok":2716417.9104477614,"fee_total":520000,"potongan":0,"keterangan_potongan":"","gaji_total":3236417.9104477614} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:25] [INFO] Type definition | Context: {"definition":"iiiiddddddiisdddsd","length":18} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:25] [ERROR] Exception: The number of elements in the type definition string must match the number of bind variables | Context: {"file":"\/home\/moxe6138\/public_html\/kas_dbn\/menu\/penggajian.php","line":415,"trace":"#0 \/home\/moxe6138\/public_html\/kas_dbn\/menu\/penggajian.php(415): mysqli_stmt->bind_param()\n#1 {main}"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 01:02:41] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 01:02:41] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:41] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:41] [INFO] Update potongan request | Context: {"ajax_action":"update_potongan","user_id":"24","bulan":"12","tahun":"2025","nominal_potongan":"","keterangan":""} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:41] [INFO] Inserting/updating potongan_gaji | Context: {"perusahaan_id":"1","user_id":24,"bulan":12,"tahun":2025,"nominal":0,"keterangan":"","created_by":"2"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:41] [INFO] Potongan_gaji saved successfully | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:41] [INFO] Updating log_penggajian | Context: {"perusahaan_id":"1","user_id":24,"bulan":12,"tahun":2025} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:41] [INFO] Log_penggajian updated | Context: {"affected_rows":1} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:02:41] [INFO] Potongan updated successfully | Context: {"user_id":24,"nominal":0,"affected_rows":1} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 01:02:41] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 01:02:41] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 08:02:41] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 08:02:41] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 08:02:41] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 08:02:41] [INFO] Salary data retrieved | Context: {"count":7} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 01:31:30] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 01:31:30] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:31:30] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 01:31:30] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 01:31:30] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:31:30] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:31:30] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:31:30] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:31:30] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 01:31:37] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 01:31:37] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 08:31:37] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 08:31:37] [INFO] Get salary data | Context: {"bulan":1,"tahun":2025} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 08:31:37] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2025 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 08:31:37] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 01:31:38] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2024
[2026-01-01 01:31:38] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2024
[2026-01-01 08:31:38] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2024
[2026-01-01 08:31:38] [INFO] Get salary data | Context: {"bulan":1,"tahun":2024} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2024
[2026-01-01 08:31:38] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2024 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2024
[2026-01-01 08:31:38] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2024
[2026-01-01 01:31:40] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 01:31:40] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:31:40] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:31:40] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:31:40] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:31:40] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 01:31:41] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=2&tahun=2026
[2026-01-01 01:31:41] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=2&tahun=2026
[2026-01-01 08:31:41] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=2&tahun=2026
[2026-01-01 08:31:41] [INFO] Get salary data | Context: {"bulan":2,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=2&tahun=2026
[2026-01-01 08:31:41] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 2 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=2&tahun=2026
[2026-01-01 08:31:41] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=2&tahun=2026
[2026-01-01 01:31:43] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 01:31:43] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:31:43] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:31:43] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:31:43] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:31:43] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 01:49:08] [INFO] === Penggajian Page Loaded === | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 01:49:08] [INFO] User not logged in, redirecting to login | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 01:49:19] [INFO] === Penggajian Page Loaded === | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 01:49:19] [INFO] User logged in | Context: {"user_id":"10","role":"user","perusahaan_id":"1"} | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:49:19] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 01:49:19] [INFO] === Penggajian Page Loaded === | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 01:49:19] [INFO] User logged in | Context: {"user_id":"10","role":"user","perusahaan_id":"1"} | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:49:19] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:49:19] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:49:19] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '10'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:49:19] [INFO] Salary data retrieved | Context: {"count":0} | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 01:49:26] [INFO] === Penggajian Page Loaded === | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 01:49:26] [INFO] User logged in | Context: {"user_id":"10","role":"user","perusahaan_id":"1"} | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 08:49:26] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 08:49:26] [INFO] Get salary data | Context: {"bulan":12,"tahun":2026} | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 08:49:26] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2026 AND lp.user_id = '10'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 08:49:26] [INFO] Salary data retrieved | Context: {"count":0} | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 01:49:29] [INFO] === Penggajian Page Loaded === | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 01:49:29] [INFO] User logged in | Context: {"user_id":"10","role":"user","perusahaan_id":"1"} | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 08:49:29] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 08:49:29] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 08:49:29] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025 AND lp.user_id = '10'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 08:49:29] [INFO] Salary data retrieved | Context: {"count":1} | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 01:50:48] [INFO] === Penggajian Page Loaded === | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=11&tahun=2025
[2026-01-01 01:50:48] [INFO] User logged in | Context: {"user_id":"10","role":"user","perusahaan_id":"1"} | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=11&tahun=2025
[2026-01-01 08:50:48] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=11&tahun=2025
[2026-01-01 08:50:48] [INFO] Get salary data | Context: {"bulan":11,"tahun":2025} | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=11&tahun=2025
[2026-01-01 08:50:48] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 11 AND lp.tahun = 2025 AND lp.user_id = '10'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=11&tahun=2025
[2026-01-01 08:50:48] [INFO] Salary data retrieved | Context: {"count":0} | User: 10 (Nanda DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=11&tahun=2025
[2026-01-01 02:52:37] [INFO] === Penggajian Page Loaded === | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 02:52:37] [INFO] User not logged in, redirecting to login | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 02:53:11] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 02:53:11] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 09:53:11] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 02:53:11] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 02:53:11] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 09:53:11] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 09:53:11] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 09:53:11] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 09:53:11] [INFO] Salary data retrieved | Context: {"count":0} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 02:53:11] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 02:53:11] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 09:53:11] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 02:53:14] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 02:53:14] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 09:53:14] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 09:53:14] [INFO] Get salary data | Context: {"bulan":12,"tahun":2026} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 09:53:14] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2026
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 09:53:14] [INFO] Salary data retrieved | Context: {"count":0} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 02:53:17] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 02:53:17] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 09:53:17] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 09:53:17] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 09:53:17] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 09:53:17] [INFO] Salary data retrieved | Context: {"count":7} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 03:19:39] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 03:19:39] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 10:19:39] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 03:19:39] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 03:19:39] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 10:19:39] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 03:19:39] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 03:19:39] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 10:19:39] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 10:19:39] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 10:19:39] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 10:19:39] [INFO] Salary data retrieved | Context: {"count":0} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:03:00] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:03:00] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 11:03:00] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:03:01] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:03:01] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:03:01] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:03:01] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:03:01] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:03:01] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:08:28] [INFO] === Penggajian Page Loaded === | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:08:28] [INFO] User logged in | Context: {"user_id":"16","role":"user","perusahaan_id":"1"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 11:08:28] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:08:28] [INFO] === Penggajian Page Loaded === | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:08:28] [INFO] User logged in | Context: {"user_id":"16","role":"user","perusahaan_id":"1"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:08:28] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:08:28] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:08:28] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '16'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:08:28] [INFO] Salary data retrieved | Context: {"count":0} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:08:39] [INFO] === Penggajian Page Loaded === | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 04:08:39] [INFO] User logged in | Context: {"user_id":"16","role":"user","perusahaan_id":"1"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 11:08:39] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 11:08:39] [INFO] Get salary data | Context: {"bulan":1,"tahun":2025} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 11:08:39] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2025 AND lp.user_id = '16'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 11:08:39] [INFO] Salary data retrieved | Context: {"count":0} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 04:08:42] [INFO] === Penggajian Page Loaded === | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 04:08:42] [INFO] User logged in | Context: {"user_id":"16","role":"user","perusahaan_id":"1"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 11:08:42] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 11:08:42] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 11:08:42] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025 AND lp.user_id = '16'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 11:08:42] [INFO] Salary data retrieved | Context: {"count":1} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 04:09:22] [INFO] === Penggajian Page Loaded === | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:09:22] [INFO] User not logged in, redirecting to login | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:09:31] [INFO] === Penggajian Page Loaded === | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:09:31] [INFO] User logged in | Context: {"user_id":"22","role":"user","perusahaan_id":"1"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 11:09:31] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:09:31] [INFO] === Penggajian Page Loaded === | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:09:31] [INFO] User logged in | Context: {"user_id":"22","role":"user","perusahaan_id":"1"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:09:31] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:09:31] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:09:31] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '22'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:09:31] [INFO] Salary data retrieved | Context: {"count":0} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:09:42] [INFO] === Penggajian Page Loaded === | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 04:09:42] [INFO] User logged in | Context: {"user_id":"22","role":"user","perusahaan_id":"1"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 11:09:42] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 11:09:42] [INFO] Get salary data | Context: {"bulan":1,"tahun":2025} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 11:09:42] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2025 AND lp.user_id = '22'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 11:09:42] [INFO] Salary data retrieved | Context: {"count":0} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 04:09:44] [INFO] === Penggajian Page Loaded === | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 04:09:44] [INFO] User logged in | Context: {"user_id":"22","role":"user","perusahaan_id":"1"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 11:09:44] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 11:09:44] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 11:09:44] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025 AND lp.user_id = '22'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 11:09:44] [INFO] Salary data retrieved | Context: {"count":1} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 04:12:27] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:12:27] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 11:12:27] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:12:27] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:12:27] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:12:27] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:12:27] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:12:27] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:12:27] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:12:29] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 04:12:29] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 11:12:29] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 11:12:29] [INFO] Get salary data | Context: {"bulan":12,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 11:12:29] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 11:12:29] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 04:12:31] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 04:12:31] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 11:12:31] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 11:12:31] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 11:12:31] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 11:12:31] [INFO] Salary data retrieved | Context: {"count":1} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 04:13:18] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:13:18] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 11:13:18] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:13:18] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:13:18] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:13:18] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:13:18] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:13:18] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:13:18] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:13:38] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:13:38] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 11:13:38] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:13:38] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:13:38] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:13:38] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:13:38] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:13:38] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:13:38] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:17:08] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:17:08] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 11:17:08] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:17:09] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:17:09] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:17:09] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:17:09] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:17:09] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:17:09] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:22:20] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:22:20] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 11:22:20] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:22:20] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:22:20] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:22:20] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:22:20] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:22:20] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:22:20] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:22:53] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:22:53] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 11:22:53] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:22:54] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:22:54] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:22:54] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:22:54] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:22:54] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:22:54] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:38:16] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:38:16] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 11:38:16] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:38:16] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:38:16] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:38:16] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:38:16] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:38:16] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:38:16] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:38:18] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 04:38:18] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 11:38:18] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 11:38:18] [INFO] Get salary data | Context: {"bulan":12,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 11:38:18] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 11:38:18] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 04:38:20] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 04:38:20] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 11:38:20] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 11:38:20] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 11:38:20] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 11:38:20] [INFO] Salary data retrieved | Context: {"count":1} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 04:39:10] [INFO] === Penggajian Page Loaded === | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:39:10] [INFO] User logged in | Context: {"user_id":"16","role":"user","perusahaan_id":"1"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 11:39:10] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 04:39:10] [INFO] === Penggajian Page Loaded === | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:39:10] [INFO] User logged in | Context: {"user_id":"16","role":"user","perusahaan_id":"1"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:39:10] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:39:10] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:39:10] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '16'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 11:39:10] [INFO] Salary data retrieved | Context: {"count":0} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 04:39:13] [INFO] === Penggajian Page Loaded === | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 04:39:13] [INFO] User logged in | Context: {"user_id":"16","role":"user","perusahaan_id":"1"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 11:39:13] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 11:39:13] [INFO] Get salary data | Context: {"bulan":12,"tahun":2026} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 11:39:13] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2026 AND lp.user_id = '16'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 11:39:13] [INFO] Salary data retrieved | Context: {"count":0} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 04:39:15] [INFO] === Penggajian Page Loaded === | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 04:39:15] [INFO] User logged in | Context: {"user_id":"16","role":"user","perusahaan_id":"1"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 11:39:15] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 11:39:15] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 11:39:15] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025 AND lp.user_id = '16'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 11:39:15] [INFO] Salary data retrieved | Context: {"count":1} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 05:03:42] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 05:03:42] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 12:03:42] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 05:03:42] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 05:03:42] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:03:42] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:03:42] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:03:42] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:03:42] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 05:13:13] [INFO] === Penggajian Page Loaded === | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 05:13:13] [INFO] User logged in | Context: {"user_id":"1","role":"admin","perusahaan_id":"1"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 12:13:13] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 05:13:13] [INFO] === Penggajian Page Loaded === | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 05:13:13] [INFO] User logged in | Context: {"user_id":"1","role":"admin","perusahaan_id":"1"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:13:13] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:13:13] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:13:13] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:13:13] [INFO] Salary data retrieved | Context: {"count":0} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 05:13:13] [INFO] === Penggajian Page Loaded === | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 05:13:13] [INFO] User logged in | Context: {"user_id":"1","role":"admin","perusahaan_id":"1"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 12:13:13] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 05:13:33] [INFO] === Penggajian Page Loaded === | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_previous_admin_salary&admin_user_id=1
[2026-01-01 05:13:33] [INFO] User logged in | Context: {"user_id":"1","role":"admin","perusahaan_id":"1"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_previous_admin_salary&admin_user_id=1
[2026-01-01 12:13:33] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_previous_admin_salary&admin_user_id=1
[2026-01-01 05:13:49] [INFO] === Penggajian Page Loaded === | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 05:13:49] [INFO] User logged in | Context: {"user_id":"22","role":"user","perusahaan_id":"1"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 12:13:49] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 05:13:49] [INFO] === Penggajian Page Loaded === | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 05:13:49] [INFO] User logged in | Context: {"user_id":"22","role":"user","perusahaan_id":"1"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:13:49] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:13:49] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:13:49] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '22'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:13:49] [INFO] Salary data retrieved | Context: {"count":0} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 05:13:53] [INFO] === Penggajian Page Loaded === | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 05:13:53] [INFO] User logged in | Context: {"user_id":"22","role":"user","perusahaan_id":"1"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:13:53] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:13:53] [INFO] Get salary data | Context: {"bulan":12,"tahun":2026} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:13:53] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2026 AND lp.user_id = '22'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:13:53] [INFO] Salary data retrieved | Context: {"count":0} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 05:14:01] [INFO] === Penggajian Page Loaded === | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 05:14:01] [INFO] User logged in | Context: {"user_id":"22","role":"user","perusahaan_id":"1"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:14:01] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:14:01] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:14:01] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025 AND lp.user_id = '22'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:14:01] [INFO] Salary data retrieved | Context: {"count":1} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 05:14:01] [INFO] === Penggajian Page Loaded === | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 05:14:01] [INFO] User logged in | Context: {"user_id":"1","role":"admin","perusahaan_id":"1"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 12:14:01] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 05:14:01] [INFO] === Penggajian Page Loaded === | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 05:14:01] [INFO] User logged in | Context: {"user_id":"1","role":"admin","perusahaan_id":"1"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:14:01] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:14:01] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:14:01] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:14:01] [INFO] Salary data retrieved | Context: {"count":1} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 05:15:03] [INFO] === Penggajian Page Loaded === | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 05:15:03] [INFO] User logged in | Context: {"user_id":"1","role":"admin","perusahaan_id":"1"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:15:03] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:15:03] [INFO] Get salary data | Context: {"bulan":12,"tahun":2026} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:15:03] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2026
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:15:03] [INFO] Salary data retrieved | Context: {"count":0} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 05:15:13] [INFO] === Penggajian Page Loaded === | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 05:15:13] [INFO] User logged in | Context: {"user_id":"1","role":"admin","perusahaan_id":"1"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:15:13] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:15:13] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:15:13] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:15:13] [INFO] Salary data retrieved | Context: {"count":1} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 05:15:18] [INFO] === Penggajian Page Loaded === | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 05:15:18] [INFO] User logged in | Context: {"user_id":"1","role":"admin","perusahaan_id":"1"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:15:18] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:15:18] [INFO] Get salary data | Context: {"bulan":12,"tahun":2026} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:15:18] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2026
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:15:18] [INFO] Salary data retrieved | Context: {"count":0} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 05:15:20] [INFO] === Penggajian Page Loaded === | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 05:15:20] [INFO] User logged in | Context: {"user_id":"1","role":"admin","perusahaan_id":"1"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:15:20] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:15:20] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:15:20] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:15:20] [INFO] Salary data retrieved | Context: {"count":7} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 05:16:08] [INFO] === Penggajian Page Loaded === | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 05:16:08] [INFO] User logged in | Context: {"user_id":"1","role":"admin","perusahaan_id":"1"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:16:08] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:16:08] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:16:08] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:16:08] [INFO] Salary data retrieved | Context: {"count":1} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 05:16:08] [INFO] === Penggajian Page Loaded === | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 05:16:08] [INFO] User logged in | Context: {"user_id":"1","role":"admin","perusahaan_id":"1"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 12:16:08] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 12:16:08] [INFO] Get salary data | Context: {"bulan":1,"tahun":2025} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 12:16:08] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2025
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 12:16:08] [INFO] Salary data retrieved | Context: {"count":0} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 05:16:48] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 05:16:48] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 12:16:48] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 05:16:48] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 05:16:48] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:16:48] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:16:48] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:16:48] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:16:48] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 05:16:52] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 05:16:52] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:16:52] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:16:52] [INFO] Get salary data | Context: {"bulan":12,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:16:52] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:16:52] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 05:16:54] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 05:16:54] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:16:54] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:16:54] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:16:54] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:16:54] [INFO] Salary data retrieved | Context: {"count":1} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 05:19:25] [INFO] === Penggajian Page Loaded === | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 05:19:25] [INFO] User logged in | Context: {"user_id":"1","role":"admin","perusahaan_id":"1"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 12:19:25] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 05:19:25] [INFO] === Penggajian Page Loaded === | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 05:19:25] [INFO] User logged in | Context: {"user_id":"1","role":"admin","perusahaan_id":"1"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:19:25] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:19:25] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:19:25] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:19:25] [INFO] Salary data retrieved | Context: {"count":1} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 05:19:25] [INFO] === Penggajian Page Loaded === | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 05:19:25] [INFO] User logged in | Context: {"user_id":"1","role":"admin","perusahaan_id":"1"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 12:19:25] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 05:20:10] [INFO] === Penggajian Page Loaded === | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 05:20:10] [INFO] User logged in | Context: {"user_id":"1","role":"admin","perusahaan_id":"1"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:20:10] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:20:10] [INFO] Get salary data | Context: {"bulan":12,"tahun":2026} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:20:10] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2026
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:20:10] [INFO] Salary data retrieved | Context: {"count":0} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 05:20:13] [INFO] === Penggajian Page Loaded === | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 05:20:13] [INFO] User logged in | Context: {"user_id":"1","role":"admin","perusahaan_id":"1"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:20:13] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:20:13] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:20:13] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:20:13] [INFO] Salary data retrieved | Context: {"count":7} | User: 1 (Shofia DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 05:25:44] [INFO] === Penggajian Page Loaded === | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 05:25:44] [INFO] User logged in | Context: {"user_id":"22","role":"user","perusahaan_id":"1"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 12:25:44] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 05:25:45] [INFO] === Penggajian Page Loaded === | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 05:25:45] [INFO] User logged in | Context: {"user_id":"22","role":"user","perusahaan_id":"1"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:25:45] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:25:45] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:25:45] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '22'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:25:45] [INFO] Salary data retrieved | Context: {"count":0} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 05:25:50] [INFO] === Penggajian Page Loaded === | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 05:25:50] [INFO] User logged in | Context: {"user_id":"22","role":"user","perusahaan_id":"1"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:25:50] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:25:50] [INFO] Get salary data | Context: {"bulan":12,"tahun":2026} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:25:50] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2026 AND lp.user_id = '22'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:25:50] [INFO] Salary data retrieved | Context: {"count":0} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 05:25:53] [INFO] === Penggajian Page Loaded === | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 05:25:53] [INFO] User logged in | Context: {"user_id":"22","role":"user","perusahaan_id":"1"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:25:53] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:25:53] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:25:53] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025 AND lp.user_id = '22'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:25:53] [INFO] Salary data retrieved | Context: {"count":1} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 05:29:32] [INFO] === Penggajian Page Loaded === | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 05:29:32] [INFO] User logged in | Context: {"user_id":"16","role":"user","perusahaan_id":"1"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 12:29:32] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 05:29:33] [INFO] === Penggajian Page Loaded === | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 05:29:33] [INFO] User logged in | Context: {"user_id":"16","role":"user","perusahaan_id":"1"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:29:33] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:29:33] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:29:33] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '16'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:29:33] [INFO] Salary data retrieved | Context: {"count":0} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 06:13:10] [INFO] === Penggajian Page Loaded === | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 06:13:10] [INFO] User logged in | Context: {"user_id":"12","role":"user","perusahaan_id":"1"} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 13:13:10] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 06:13:10] [INFO] === Penggajian Page Loaded === | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 06:13:10] [INFO] User logged in | Context: {"user_id":"12","role":"user","perusahaan_id":"1"} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 13:13:10] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 13:13:10] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 13:13:10] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '12'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 13:13:10] [INFO] Salary data retrieved | Context: {"count":0} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 06:13:26] [INFO] === Penggajian Page Loaded === | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 06:13:26] [INFO] User logged in | Context: {"user_id":"12","role":"user","perusahaan_id":"1"} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 13:13:26] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 13:13:26] [INFO] Get salary data | Context: {"bulan":1,"tahun":2025} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 13:13:26] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2025 AND lp.user_id = '12'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 13:13:26] [INFO] Salary data retrieved | Context: {"count":0} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 06:13:28] [INFO] === Penggajian Page Loaded === | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 06:13:28] [INFO] User logged in | Context: {"user_id":"12","role":"user","perusahaan_id":"1"} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 13:13:28] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 13:13:28] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 13:13:28] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025 AND lp.user_id = '12'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 13:13:28] [INFO] Salary data retrieved | Context: {"count":1} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 07:06:10] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 07:06:10] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 14:06:10] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 07:06:10] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 07:06:10] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 14:06:10] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 07:06:10] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 07:06:10] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 14:06:10] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 14:06:10] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 14:06:10] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 14:06:10] [INFO] Salary data retrieved | Context: {"count":1} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 07:06:49] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_previous_admin_salary&admin_user_id=1
[2026-01-01 07:06:49] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_previous_admin_salary&admin_user_id=1
[2026-01-01 14:06:49] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_previous_admin_salary&admin_user_id=1
[2026-01-01 07:07:29] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 07:07:29] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 14:07:29] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 14:07:29] [INFO] Get salary data | Context: {"bulan":12,"tahun":2026} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 14:07:29] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2026
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 14:07:29] [INFO] Salary data retrieved | Context: {"count":0} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 07:07:30] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 07:07:30] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 14:07:30] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 14:07:30] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 14:07:30] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 14:07:30] [INFO] Salary data retrieved | Context: {"count":7} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 08:19:12] [INFO] === Penggajian Page Loaded === | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:19:12] [INFO] User logged in | Context: {"user_id":"22","role":"user","perusahaan_id":"1"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 15:19:12] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 08:19:12] [INFO] === Penggajian Page Loaded === | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 08:19:12] [INFO] User logged in | Context: {"user_id":"22","role":"user","perusahaan_id":"1"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 15:19:12] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 15:19:12] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 15:19:12] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '22'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 15:19:12] [INFO] Salary data retrieved | Context: {"count":0} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 09:09:27] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 09:09:27] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 16:09:27] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 09:09:28] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 09:09:28] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 16:09:28] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 16:09:28] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 16:09:28] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 16:09:28] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 09:09:31] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 09:09:31] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 16:09:31] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 16:09:31] [INFO] Get salary data | Context: {"bulan":12,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 16:09:31] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 16:09:31] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 09:09:33] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 09:09:33] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 16:09:33] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 16:09:33] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 16:09:33] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 16:09:33] [INFO] Salary data retrieved | Context: {"count":1} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 09:31:59] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 09:31:59] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 16:31:59] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 09:31:59] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 09:31:59] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 16:31:59] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 16:31:59] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 16:31:59] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 16:31:59] [INFO] Salary data retrieved | Context: {"count":1} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 09:31:59] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 09:31:59] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 16:31:59] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 09:35:58] [INFO] === Penggajian Page Loaded === | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 09:35:58] [INFO] User logged in | Context: {"user_id":"16","role":"user","perusahaan_id":"1"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 16:35:58] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 09:35:58] [INFO] === Penggajian Page Loaded === | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 09:35:58] [INFO] User logged in | Context: {"user_id":"16","role":"user","perusahaan_id":"1"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 16:35:58] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 16:35:58] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 16:35:58] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '16'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 16:35:58] [INFO] Salary data retrieved | Context: {"count":0} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 09:42:46] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 09:42:46] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 16:42:46] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 09:42:46] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 09:42:46] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 16:42:46] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 16:42:46] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 16:42:46] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 16:42:46] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 09:54:18] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 09:54:18] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 16:54:18] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 09:54:18] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 09:54:18] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 16:54:18] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 16:54:18] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 16:54:18] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 16:54:18] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 09:54:22] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 09:54:22] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 16:54:22] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 16:54:22] [INFO] Get salary data | Context: {"bulan":12,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 16:54:22] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 16:54:22] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 09:54:24] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 09:54:24] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 16:54:24] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 16:54:24] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 16:54:24] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 16:54:24] [INFO] Salary data retrieved | Context: {"count":1} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 10:32:22] [INFO] === Penggajian Page Loaded === | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 10:32:22] [INFO] User logged in | Context: {"user_id":"16","role":"user","perusahaan_id":"1"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 17:32:22] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 10:32:22] [INFO] === Penggajian Page Loaded === | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 10:32:22] [INFO] User logged in | Context: {"user_id":"16","role":"user","perusahaan_id":"1"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 17:32:22] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 17:32:22] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 17:32:22] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '16'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 17:32:22] [INFO] Salary data retrieved | Context: {"count":0} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 10:50:59] [INFO] === Penggajian Page Loaded === | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 10:50:59] [INFO] User logged in | Context: {"user_id":"16","role":"user","perusahaan_id":"1"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 17:50:59] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 10:50:59] [INFO] === Penggajian Page Loaded === | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 10:50:59] [INFO] User logged in | Context: {"user_id":"16","role":"user","perusahaan_id":"1"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 17:50:59] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 17:50:59] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 17:50:59] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '16'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 17:50:59] [INFO] Salary data retrieved | Context: {"count":0} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 10:59:04] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 10:59:04] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 17:59:04] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 10:59:04] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 10:59:04] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 17:59:04] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 17:59:04] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 17:59:04] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 17:59:04] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 10:59:08] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 10:59:08] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 17:59:08] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 17:59:08] [INFO] Get salary data | Context: {"bulan":12,"tahun":2026} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 17:59:08] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2026 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 17:59:08] [INFO] Salary data retrieved | Context: {"count":0} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 10:59:11] [INFO] === Penggajian Page Loaded === | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 10:59:11] [INFO] User logged in | Context: {"user_id":"11","role":"user","perusahaan_id":"1"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 17:59:11] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 17:59:11] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 17:59:11] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025 AND lp.user_id = '11'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 17:59:11] [INFO] Salary data retrieved | Context: {"count":1} | User: 11 (Dedi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:02:40] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 12:02:40] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 19:02:40] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 12:02:40] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:02:40] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 19:02:40] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 19:02:40] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 19:02:40] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 19:02:40] [INFO] Salary data retrieved | Context: {"count":1} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:02:40] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 12:02:40] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 19:02:40] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_admin_list
[2026-01-01 12:08:17] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:08:17] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 19:08:17] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 19:08:17] [INFO] Get salary data | Context: {"bulan":12,"tahun":2026} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 19:08:17] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2026
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 19:08:17] [INFO] Salary data retrieved | Context: {"count":0} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 12:08:18] [INFO] === Penggajian Page Loaded === | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:08:18] [INFO] User logged in | Context: {"user_id":"2","role":"admin","perusahaan_id":"1"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 19:08:18] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 19:08:18] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 19:08:18] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 19:08:18] [INFO] Salary data retrieved | Context: {"count":7} | User: 2 (Sulihar) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:09:14] [INFO] === Penggajian Page Loaded === | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 12:09:14] [INFO] User logged in | Context: {"user_id":"22","role":"user","perusahaan_id":"1"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 19:09:14] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 12:09:14] [INFO] === Penggajian Page Loaded === | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:09:14] [INFO] User logged in | Context: {"user_id":"22","role":"user","perusahaan_id":"1"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 19:09:14] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 19:09:14] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 19:09:14] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '22'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 19:09:14] [INFO] Salary data retrieved | Context: {"count":0} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 12:09:17] [INFO] === Penggajian Page Loaded === | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 12:09:17] [INFO] User logged in | Context: {"user_id":"22","role":"user","perusahaan_id":"1"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 19:09:17] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 19:09:17] [INFO] Get salary data | Context: {"bulan":1,"tahun":2025} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 19:09:17] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2025 AND lp.user_id = '22'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 19:09:17] [INFO] Salary data retrieved | Context: {"count":0} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2025
[2026-01-01 12:09:19] [INFO] === Penggajian Page Loaded === | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 12:09:19] [INFO] User logged in | Context: {"user_id":"22","role":"user","perusahaan_id":"1"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 19:09:19] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 19:09:19] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 19:09:19] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025 AND lp.user_id = '22'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 19:09:19] [INFO] Salary data retrieved | Context: {"count":1} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 13:03:04] [INFO] === Penggajian Page Loaded === | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 13:03:04] [INFO] User logged in | Context: {"user_id":"12","role":"user","perusahaan_id":"1"} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 20:03:04] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 13:03:04] [INFO] === Penggajian Page Loaded === | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 13:03:04] [INFO] User logged in | Context: {"user_id":"12","role":"user","perusahaan_id":"1"} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 20:03:04] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 20:03:04] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 20:03:04] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '12'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 20:03:04] [INFO] Salary data retrieved | Context: {"count":0} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 13:03:07] [INFO] === Penggajian Page Loaded === | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 13:03:07] [INFO] User logged in | Context: {"user_id":"12","role":"user","perusahaan_id":"1"} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 20:03:07] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 20:03:07] [INFO] Get salary data | Context: {"bulan":12,"tahun":2026} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 20:03:07] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2026 AND lp.user_id = '12'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 20:03:07] [INFO] Salary data retrieved | Context: {"count":0} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 13:03:09] [INFO] === Penggajian Page Loaded === | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 13:03:09] [INFO] User logged in | Context: {"user_id":"12","role":"user","perusahaan_id":"1"} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 20:03:09] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 20:03:09] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 20:03:09] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025 AND lp.user_id = '12'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 20:03:09] [INFO] Salary data retrieved | Context: {"count":1} | User: 12 (Dwi DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 14:00:00] [INFO] === Penggajian Page Loaded === | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 14:00:00] [INFO] User logged in | Context: {"user_id":"16","role":"user","perusahaan_id":"1"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 21:00:00] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 14:00:00] [INFO] === Penggajian Page Loaded === | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 14:00:00] [INFO] User logged in | Context: {"user_id":"16","role":"user","perusahaan_id":"1"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 21:00:00] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 21:00:00] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 21:00:00] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '16'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 21:00:00] [INFO] Salary data retrieved | Context: {"count":0} | User: 16 (Fandik DBN) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 15:04:57] [INFO] === Penggajian Page Loaded === | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 15:04:57] [INFO] User logged in | Context: {"user_id":"22","role":"user","perusahaan_id":"1"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 22:04:57] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php
[2026-01-01 15:04:58] [INFO] === Penggajian Page Loaded === | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 15:04:58] [INFO] User logged in | Context: {"user_id":"22","role":"user","perusahaan_id":"1"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 22:04:58] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 22:04:58] [INFO] Get salary data | Context: {"bulan":1,"tahun":2026} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 22:04:58] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 1 AND lp.tahun = 2026 AND lp.user_id = '22'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 22:04:58] [INFO] Salary data retrieved | Context: {"count":0} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=1&tahun=2026
[2026-01-01 15:05:01] [INFO] === Penggajian Page Loaded === | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 15:05:01] [INFO] User logged in | Context: {"user_id":"22","role":"user","perusahaan_id":"1"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 22:05:01] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 22:05:01] [INFO] Get salary data | Context: {"bulan":12,"tahun":2026} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 22:05:01] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2026 AND lp.user_id = '22'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 22:05:01] [INFO] Salary data retrieved | Context: {"count":0} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2026
[2026-01-01 15:05:03] [INFO] === Penggajian Page Loaded === | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 15:05:03] [INFO] User logged in | Context: {"user_id":"22","role":"user","perusahaan_id":"1"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 22:05:03] [INFO] Current period | Context: {"month":"1","year":"2026"} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 22:05:03] [INFO] Get salary data | Context: {"bulan":12,"tahun":2025} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 22:05:03] [SQL] 
        SELECT 
            lp.*,
            u.nama_lengkap,
            u.email,
            u.role,
            finalizer.nama_lengkap as finalized_by_name
        FROM log_penggajian lp
        INNER JOIN users u ON lp.user_id = u.id
        LEFT JOIN users finalizer ON lp.finalized_by = finalizer.id
        WHERE lp.perusahaan_id = '1' AND lp.bulan = 12 AND lp.tahun = 2025 AND lp.user_id = '22'
        ORDER BY u.role DESC, u.nama_lengkap ASC
     | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025
[2026-01-01 22:05:03] [INFO] Salary data retrieved | Context: {"count":1} | User: 22 (Singgih) | URI: /kas_dbn/menu/penggajian.php?ajax_action=get_salary_data&bulan=12&tahun=2025