INSERT INTO `simpanan_transactions` (`id`, `memberId`, `relatedMemberId`, `type`, `billingMonth`, `transactionType`, `amount`, `paidAmount`, `balanceAfter`, `notes`, `buktiPath`, `processedBy`, `status`, `transferReference`, `isRead`, `billStatus`, `approvedBy`, `approvedAt`, `rejectionReason`, `created_at`, `updated_at`) VALUES
(19724, 375, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 3050000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19725, 450, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 350000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19726, 493, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 600000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19727, 451, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 300000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19728, 452, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 350000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19729, 453, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 350000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19730, 454, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 350000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19731, 455, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 350000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19732, 456, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 350000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19733, 457, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 500000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19734, 482, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 850000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19735, 430, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 1150000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19736, 403, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 2450000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19737, 495, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 650000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19738, 460, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 650000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19739, 384, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 2900000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19740, 503, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 350000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19741, 461, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 350000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19742, 462, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 350000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19743, 496, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 650000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19744, 391, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 3050000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19745, 400, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 2400000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19746, 497, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 650000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19747, 422, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 1250000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19748, 420, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 1400000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19749, 465, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 350000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19750, 428, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 1200000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19751, 489, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 1050000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19752, 489, NULL, 'SUKARELA', '2026-04', 'SETOR', 200000.00, 0.00, 3000000.00, 'Setoran Payroll (Sukarela) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19753, 466, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 550000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19754, 467, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 350000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19755, 468, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 1100000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19756, 468, NULL, 'SUKARELA', '2026-04', 'SETOR', 750000.00, 0.00, 5170000.00, 'Setoran Payroll (Sukarela) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19757, 398, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 2550000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19758, 488, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 700000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19759, 381, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 3000000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19760, 501, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 300000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19761, 421, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 1400000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19762, 470, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 350000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19763, 471, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 350000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19764, 472, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 350000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19765, 490, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 1050000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19766, 490, NULL, 'SUKARELA', '2026-04', 'SETOR', 100000.00, 0.00, 2200000.00, 'Setoran Payroll (Sukarela) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19767, 500, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 500000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19768, 513, NULL, 'SUKARELA', '2026-04', 'SETOR', 100000.00, 0.00, 2100000.00, 'Setoran Payroll (Sukarela) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19769, 382, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 3000000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19770, 388, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 2750000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19771, 474, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 350000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19772, 380, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 3050000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19773, 476, NULL, 'WAJIB', '2026-04', 'SETOR', 50000.00, 0.00, 650000.00, 'Setoran Payroll (Simwa Koperasi) - April 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-04-29 02:00:00', NULL, '2026-04-29 02:00:00', '2026-04-29 02:00:00'),
(19774, 523, NULL, 'POKOK', NULL, 'SETOR', 200000.00, 0.00, 200000.00, 'Simpanan pokok awal', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', NULL, NULL, NULL, '2026-05-25 09:31:25', '2026-05-25 09:31:25'),
(19775, 523, NULL, 'WAJIB', NULL, 'SETOR', 50000.00, 0.00, 50000.00, 'Simpanan wajib awal', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', NULL, NULL, NULL, '2026-05-25 09:31:25', '2026-05-25 09:31:25'),
(19776, 524, NULL, 'POKOK', NULL, 'SETOR', 200000.00, 0.00, 200000.00, 'Simpanan pokok awal', NULL, 1032, 'APPROVED', NULL, 1, 'DRAFT', NULL, NULL, NULL, '2026-06-03 06:29:42', '2026-06-03 06:29:42'),
(19777, 524, NULL, 'WAJIB', NULL, 'SETOR', 50000.00, 0.00, 50000.00, 'Simpanan wajib awal', NULL, 1032, 'APPROVED', NULL, 1, 'DRAFT', NULL, NULL, NULL, '2026-06-03 06:29:42', '2026-06-03 06:29:42'),
(19778, 399, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 2650000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19779, 396, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 2600000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19780, 407, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 2200000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19781, 510, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 650000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19782, 410, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1850000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19783, 386, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 2850000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19784, 411, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1800000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19785, 409, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1900000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19786, 390, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 2750000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19787, 412, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1850000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19788, 485, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 500000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19789, 491, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 700000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19790, 393, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 2750000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19791, 385, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 2900000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19792, 449, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 700000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19793, 424, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1300000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19794, 377, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 3050000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19795, 494, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 750000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19796, 487, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 500000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19797, 378, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 3200000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19798, 387, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 2800000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19799, 498, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 450000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19800, 469, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 250000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19801, 499, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1050000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19802, 431, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1100000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19803, 418, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1550000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19804, 392, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 2750000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19805, 415, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1850000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19806, 395, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 2600000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19807, 373, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 3100000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19808, 432, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19809, 389, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 2800000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19810, 404, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 2450000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19811, 433, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19812, 426, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1300000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19813, 435, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19814, 436, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19815, 394, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 2700000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19816, 439, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19817, 440, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19818, 477, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 800000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19819, 429, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1200000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19820, 486, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 650000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19821, 423, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1350000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19822, 484, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 950000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19823, 514, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 250000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19824, 502, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19825, 478, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 900000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19826, 405, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 2450000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19827, 408, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1500000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19828, 443, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 550000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19829, 444, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19830, 406, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 2450000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19831, 522, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 100000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19832, 522, NULL, 'SUKARELA', '2026-05', 'SETOR', 50000.00, 0.00, 50000.00, 'Setoran Payroll (Sukarela) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19833, 374, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 3150000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19834, 445, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19835, 416, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1800000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19836, 479, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 900000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19837, 480, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 900000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19838, 446, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19839, 492, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 650000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19840, 448, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19841, 375, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 3100000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19842, 450, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19843, 493, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 650000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19844, 451, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 350000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19845, 452, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19846, 453, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19847, 454, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19848, 455, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19849, 456, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19850, 457, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 550000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19851, 482, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 900000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19852, 430, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1200000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19853, 403, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 2500000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19854, 495, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 700000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19855, 460, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 700000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19856, 384, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 2950000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19857, 503, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19858, 461, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19859, 462, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19860, 496, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 700000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19861, 417, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1250000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19862, 391, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 3100000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19863, 400, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 2450000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19864, 425, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1300000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19865, 497, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 700000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19866, 422, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1300000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19867, 420, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1450000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19868, 465, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19869, 428, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1250000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19870, 489, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1100000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19871, 489, NULL, 'SUKARELA', '2026-05', 'SETOR', 200000.00, 0.00, 3200000.00, 'Setoran Payroll (Sukarela) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19872, 466, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 600000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19873, 467, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19874, 468, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1150000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19875, 468, NULL, 'SUKARELA', '2026-05', 'SETOR', 750000.00, 0.00, 5920000.00, 'Setoran Payroll (Sukarela) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19876, 398, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 2600000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19877, 488, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 750000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19878, 381, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 3050000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19879, 501, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 350000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19880, 421, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1450000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19881, 470, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19882, 471, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19883, 472, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19884, 490, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 1100000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19885, 490, NULL, 'SUKARELA', '2026-05', 'SETOR', 100000.00, 0.00, 2300000.00, 'Setoran Payroll (Sukarela) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19886, 500, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 550000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19887, 524, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 100000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19888, 513, NULL, 'SUKARELA', '2026-05', 'SETOR', 100000.00, 0.00, 2200000.00, 'Setoran Payroll (Sukarela) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19889, 382, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 3050000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19890, 388, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 2800000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19891, 474, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 400000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19892, 380, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 3100000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19893, 476, NULL, 'WAJIB', '2026-05', 'SETOR', 50000.00, 0.00, 700000.00, 'Setoran Payroll (Simwa Koperasi) - Mei 2026', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', 8, '2026-05-29 02:00:00', NULL, '2026-05-29 02:00:00', '2026-05-29 02:00:00'),
(19895, 525, NULL, 'WAJIB', NULL, 'SETOR', 50000.00, 0.00, 50000.00, 'Simpanan wajib awal', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', NULL, NULL, NULL, '2026-06-25 05:05:21', '2026-06-25 05:05:21'),
(19896, 525, NULL, 'SUKARELA', NULL, 'SETOR', 10000.00, 0.00, 10000.00, 'Simpanan sukarela awal', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', NULL, NULL, NULL, '2026-06-25 05:05:21', '2026-06-25 05:05:21'),
(19897, 525, NULL, 'POKOK', '2026-07', 'SETOR', 50000.00, 0.00, 0.00, 'Cicilan Simpanan Pokok Ke-2 dari 4', NULL, 8, 'APPROVED', NULL, 1, 'APPROVED', NULL, NULL, NULL, '2026-06-25 05:05:21', '2026-06-25 05:05:21'),
(19898, 525, NULL, 'POKOK', '2026-08', 'SETOR', 50000.00, 0.00, 0.00, 'Cicilan Simpanan Pokok Ke-3 dari 4', NULL, 8, 'APPROVED', NULL, 1, 'APPROVED', NULL, NULL, NULL, '2026-06-25 05:05:21', '2026-06-25 05:05:21'),
(19899, 525, NULL, 'POKOK', '2026-09', 'SETOR', 50000.00, 0.00, 0.00, 'Cicilan Simpanan Pokok Ke-4 dari 4', NULL, 8, 'APPROVED', NULL, 1, 'APPROVED', NULL, NULL, NULL, '2026-06-25 05:05:21', '2026-06-25 05:05:21'),
(19901, 526, NULL, 'WAJIB', NULL, 'SETOR', 50000.00, 0.00, 50000.00, 'Simpanan wajib awal', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', NULL, NULL, NULL, '2026-06-25 05:08:02', '2026-06-25 05:08:02'),
(19902, 526, NULL, 'SUKARELA', NULL, 'SETOR', 10000.00, 0.00, 10000.00, 'Simpanan sukarela awal', NULL, 8, 'APPROVED', NULL, 1, 'DRAFT', NULL, NULL, NULL, '2026-06-25 05:08:02', '2026-06-25 05:08:02'),
(19903, 526, NULL, 'POKOK', '2026-07', 'SETOR', 50000.00, 0.00, 0.00, 'Cicilan Simpanan Pokok Ke-2 dari 4', NULL, 8, 'APPROVED', NULL, 1, 'APPROVED', NULL, NULL, NULL, '2026-06-25 05:08:02', '2026-06-25 05:08:02'),
(19904, 526, NULL, 'POKOK', '2026-08', 'SETOR', 50000.00, 0.00, 0.00, 'Cicilan Simpanan Pokok Ke-3 dari 4', NULL, 8, 'APPROVED', NULL, 1, 'APPROVED', NULL, NULL, NULL, '2026-06-25 05:08:02', '2026-06-25 05:08:02'),
(19905, 526, NULL, 'POKOK', '2026-09', 'SETOR', 50000.00, 0.00, 0.00, 'Cicilan Simpanan Pokok Ke-4 dari 4', NULL, 8, 'APPROVED', NULL, 1, 'APPROVED', NULL, NULL, NULL, '2026-06-25 05:08:02', '2026-06-25 05:08:02'),
(19906, 525, NULL, 'POKOK', '2026-06', 'SETOR', 50000.00, 0.00, 0.00, 'Cicilan Simpanan Pokok Ke-1 dari 4', NULL, 8, 'APPROVED', NULL, 1, 'APPROVED', NULL, NULL, NULL, '2026-06-25 06:15:30', '2026-06-25 06:15:30'),
(19907, 526, NULL, 'POKOK', '2026-06', 'SETOR', 50000.00, 0.00, 0.00, 'Cicilan Simpanan Pokok Ke-1 dari 4', NULL, 8, 'APPROVED', NULL, 1, 'APPROVED', NULL, NULL, NULL, '2026-06-25 06:15:30', '2026-06-25 06:15:30');

-- --------------------------------------------------------

--
-- Table structure for table `stock_movements`
--

CREATE TABLE `stock_movements` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `productId` bigint(20) UNSIGNED NOT NULL,
  `movementType` enum('PURCHASE_IN','CONSIGNMENT_IN','CONSIGNMENT_RETURN','SALE_OUT','RETURN_IN','RETURN_OUT','EXPIRED_OUT','ADJUSTMENT','TRANSFER_IN','TRANSFER_OUT','RESTOCK') NOT NULL,
  `quantity` int(11) NOT NULL,
  `referenceType` enum('PURCHASE','CONSIGNMENT_BATCH','SALE','ADJUSTMENT','EXPIRY','STOCK_REQUEST') DEFAULT NULL,
  `referenceId` varchar(255) DEFAULT NULL,
  `unitCost` decimal(15,2) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `occurredAt` timestamp NOT NULL DEFAULT current_timestamp(),
  `isProduction` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stock_movements`
--

INSERT INTO `stock_movements` (`id`, `productId`, `movementType`, `quantity`, `referenceType`, `referenceId`, `unitCost`, `note`, `occurredAt`, `isProduction`, `created_at`, `updated_at`) VALUES
(26, 319, 'RESTOCK', 20, NULL, NULL, NULL, 'Initial Stock', '2026-04-30 05:25:19', 1, '2026-04-30 05:25:19', '2026-04-30 05:25:19'),
(27, 63, 'CONSIGNMENT_IN', 98, 'CONSIGNMENT_BATCH', '1', NULL, 'Setor stok manual supplier Namina risol (BCH-0001)', '2026-04-28 17:00:00', 1, '2026-04-30 07:09:32', '2026-04-30 07:09:32'),
(28, 38, 'CONSIGNMENT_IN', 17, 'CONSIGNMENT_BATCH', '2', NULL, 'Setor stok manual supplier Dapur umah silahetot (BCH-0002)', '2026-04-28 17:00:00', 1, '2026-04-30 08:00:46', '2026-04-30 08:00:46'),
(29, 39, 'CONSIGNMENT_IN', 17, 'CONSIGNMENT_BATCH', '2', NULL, 'Setor stok manual supplier Dapur umah silahetot (BCH-0002)', '2026-04-28 17:00:00', 1, '2026-04-30 08:00:46', '2026-04-30 08:00:46'),
(30, 37, 'CONSIGNMENT_IN', 16, 'CONSIGNMENT_BATCH', '2', NULL, 'Setor stok manual supplier Dapur umah silahetot (BCH-0002)', '2026-04-28 17:00:00', 1, '2026-04-30 08:00:46', '2026-04-30 08:00:46'),
(31, 36, 'CONSIGNMENT_IN', 16, 'CONSIGNMENT_BATCH', '2', NULL, 'Setor stok manual supplier Dapur umah silahetot (BCH-0002)', '2026-04-28 17:00:00', 1, '2026-04-30 08:00:46', '2026-04-30 08:00:46'),
(32, 38, 'SALE_OUT', -17, 'CONSIGNMENT_BATCH', '2', NULL, 'Penjualan manual supplier (BCH-0002)', '2026-04-29 08:17:00', 1, '2026-04-30 08:17:00', '2026-04-30 08:17:00'),
(33, 39, 'SALE_OUT', -17, 'CONSIGNMENT_BATCH', '2', NULL, 'Penjualan manual supplier (BCH-0002)', '2026-04-29 08:17:00', 1, '2026-04-30 08:17:00', '2026-04-30 08:17:00'),
(34, 37, 'SALE_OUT', -16, 'CONSIGNMENT_BATCH', '2', NULL, 'Penjualan manual supplier (BCH-0002)', '2026-04-29 08:17:00', 1, '2026-04-30 08:17:00', '2026-04-30 08:17:00'),
(35, 36, 'SALE_OUT', -16, 'CONSIGNMENT_BATCH', '2', NULL, 'Penjualan manual supplier (BCH-0002)', '2026-04-29 08:17:00', 1, '2026-04-30 08:17:00', '2026-04-30 08:17:00'),
(38, 67, 'CONSIGNMENT_IN', 50, 'CONSIGNMENT_BATCH', '4', NULL, 'Setor stok manual supplier snack kering (BCH-0004)', '2026-04-28 17:00:00', 1, '2026-04-30 08:24:33', '2026-04-30 08:24:33'),
(39, 67, 'SALE_OUT', -50, 'CONSIGNMENT_BATCH', '4', NULL, 'Penjualan manual supplier (BCH-0004)', '2026-04-29 08:24:56', 1, '2026-04-30 08:24:56', '2026-04-30 08:24:56');

-- --------------------------------------------------------

--
-- Table structure for table `supplier_notifications`
--

CREATE TABLE `supplier_notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `supplierId` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `actionUrl` varchar(255) DEFAULT NULL,
  `isRead` tinyint(1) NOT NULL DEFAULT 0,
  `readAt` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `supplier_payouts`
--

CREATE TABLE `supplier_payouts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `payoutCode` varchar(255) NOT NULL,
  `supplierId` bigint(20) UNSIGNED NOT NULL,
  `userId` bigint(20) UNSIGNED NOT NULL,
  `payoutDate` date NOT NULL,
  `grossDueAmount` decimal(15,2) NOT NULL DEFAULT 0.00,
  `paidAmount` decimal(15,2) NOT NULL DEFAULT 0.00,
  `outstandingAfter` decimal(15,2) NOT NULL DEFAULT 0.00,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `supplier_payouts`
--

INSERT INTO `supplier_payouts` (`id`, `payoutCode`, `supplierId`, `userId`, `payoutDate`, `grossDueAmount`, `paidAmount`, `outstandingAfter`, `note`, `created_at`, `updated_at`) VALUES
(1, 'PAY-000001', 6, 8, '2026-04-29', 330000.00, 330000.00, 0.00, NULL, '2026-04-30 08:17:00', '2026-04-30 08:17:00');

-- --------------------------------------------------------

--
-- Table structure for table `supplier_payout_allocations`
--

CREATE TABLE `supplier_payout_allocations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `supplierPayoutId` bigint(20) UNSIGNED NOT NULL,
  `batchId` bigint(20) UNSIGNED NOT NULL,
  `consignmentItemId` bigint(20) UNSIGNED NOT NULL,
  `allocatedAmount` decimal(15,2) NOT NULL DEFAULT 0.00,
  `allocatedQtyEquivalent` decimal(12,4) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `transaction_items`
--

CREATE TABLE `transaction_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `transactionId` bigint(20) UNSIGNED NOT NULL,
  `productId` bigint(20) UNSIGNED NOT NULL,
  `quantity` int(11) NOT NULL,
  `unitPrice` decimal(15,2) NOT NULL,
  `totalPrice` decimal(15,2) NOT NULL,
  `cogsPerUnit` decimal(15,2) DEFAULT NULL,
  `totalCogs` decimal(15,2) DEFAULT NULL,
  `grossProfit` decimal(15,2) DEFAULT NULL,
  `isProduction` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `work_logs`
--

CREATE TABLE `work_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `userId` bigint(20) UNSIGNED NOT NULL,
  `developerName` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `startTime` time DEFAULT NULL,
  `endTime` time DEFAULT NULL,
  `hoursWorked` decimal(5,2) NOT NULL,
  `description` text NOT NULL,
  `hourlyRate` decimal(10,2) NOT NULL DEFAULT 6000.00,
  `totalAmount` decimal(12,2) NOT NULL,
  `status` enum('PENDING','APPROVED','REJECTED','PAID') NOT NULL DEFAULT 'PENDING',
  `approvedBy` bigint(20) UNSIGNED DEFAULT NULL,
  `approvedAt` timestamp NULL DEFAULT NULL,
  `paidAt` timestamp NULL DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `work_logs`
--

INSERT INTO `work_logs` (`id`, `userId`, `developerName`, `date`, `startTime`, `endTime`, `hoursWorked`, `description`, `hourlyRate`, `totalAmount`, `status`, `approvedBy`, `approvedAt`, `paidAt`, `notes`, `created_at`, `updated_at`) VALUES
(275, 8, 'AEGNER BILLIK', '2025-12-01', '18:00:00', '00:00:00', 6.00, 'Refactoring Kode Controller', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(276, 8, 'AEGNER BILLIK', '2025-12-02', '18:00:00', '00:00:00', 6.00, 'Penyesuaian Timezone & Konfigurasi Dasar', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(277, 8, 'AEGNER BILLIK', '2025-12-03', '18:00:00', '00:00:00', 6.00, 'User Management & Tracking Owner Transaksi', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(278, 8, 'AEGNER BILLIK', '2025-12-04', '18:00:00', '00:00:00', 6.00, 'Sistem Upload Bukti Transaksi', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(279, 8, 'AEGNER BILLIK', '2025-12-05', '18:00:00', '00:00:00', 6.00, 'Routing & Menu Admin untuk Anggota', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(280, 8, 'AEGNER BILLIK', '2025-12-06', '18:00:00', '00:00:00', 6.00, 'Sistem Auto-Debit Simpanan Wajib', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(281, 8, 'AEGNER BILLIK', '2025-12-07', '18:00:00', '00:00:00', 6.00, 'History Debit Bulanan & Detail', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(282, 8, 'AEGNER BILLIK', '2025-12-08', '18:00:00', '00:00:00', 6.00, 'Manajemen Produk & Inventaris', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(283, 8, 'AEGNER BILLIK', '2025-12-09', '18:00:00', '00:00:00', 6.00, 'Fondasi Manajemen Anggota (Model & Migrasi)', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(284, 8, 'AEGNER BILLIK', '2025-12-10', '18:00:00', '00:00:00', 6.00, 'Widget Profitabilitas pada Dashboard', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(285, 8, 'AEGNER BILLIK', '2025-12-11', '18:00:00', '00:00:00', 6.00, 'Testing & Debugging Fitur Baru', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(286, 8, 'AEGNER BILLIK', '2025-12-12', '18:00:00', '00:00:00', 6.00, 'Fitur Skip Check-in untuk Kasir', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(287, 8, 'AEGNER BILLIK', '2025-12-13', '18:00:00', '00:00:00', 6.00, 'Update Desain Halaman Login Responsif', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(288, 8, 'AEGNER BILLIK', '2025-12-14', '18:00:00', '00:00:00', 6.00, 'Implementasi Core System POS (Point of Sales)', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(289, 8, 'AEGNER BILLIK', '2025-12-15', '18:00:00', '00:00:00', 6.00, 'Popup Detail Riwayat Transaksi', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(290, 8, 'AEGNER BILLIK', '2025-12-16', '18:00:00', '00:00:00', 6.00, 'Integrasi UI Template ke Sistem', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(291, 8, 'AEGNER BILLIK', '2025-12-17', '18:00:00', '00:00:00', 6.00, 'Fitur Transaksi & Detail Penjualan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(292, 8, 'AEGNER BILLIK', '2025-12-18', '18:00:00', '00:00:00', 6.00, 'Fitur Import Anggota via Excel', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(293, 8, 'AEGNER BILLIK', '2025-12-19', '18:00:00', '00:00:00', 6.00, 'Approval Workflow Auto-Debit', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(294, 8, 'AEGNER BILLIK', '2025-12-20', '18:00:00', '00:00:00', 6.00, 'Desain Dashboard & Login Page', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(295, 8, 'AEGNER BILLIK', '2025-12-21', '18:00:00', '00:00:00', 6.00, 'Inisialisasi Project Laravel & Filament', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(296, 8, 'AEGNER BILLIK', '2025-12-22', '18:00:00', '00:00:00', 6.00, 'Halaman Manajemen Simpanan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(297, 8, 'AEGNER BILLIK', '2025-12-23', '18:00:00', '00:00:00', 6.00, 'Tooltip Hover untuk Dropdown Filter', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:40:56', '2026-01-12 15:40:56'),
(298, 8, 'AEGNER BILLIK', '2025-11-01', '18:00:00', '00:00:00', 6.00, 'Setup Env & Review Project', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(299, 8, 'AEGNER BILLIK', '2025-11-02', '18:00:00', '00:00:00', 6.00, 'Riset & Desain UI Tablet', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(300, 8, 'AEGNER BILLIK', '2025-11-03', '18:00:00', '00:00:00', 6.00, 'Impl. UI Tablet & Monitoring', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(301, 8, 'AEGNER BILLIK', '2025-11-04', '18:00:00', '00:00:00', 6.00, 'Desain Sistem Konsinyasi', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(302, 8, 'AEGNER BILLIK', '2025-11-05', '18:00:00', '00:00:00', 6.00, 'Impl. Settlement Konsinyasi', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(303, 8, 'AEGNER BILLIK', '2025-11-06', '18:00:00', '00:00:00', 6.00, 'Testing Settlement & Config', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(304, 8, 'AEGNER BILLIK', '2025-11-07', '18:00:00', '00:00:00', 6.00, 'Finalisasi Fitur & Merge Main', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(305, 8, 'AEGNER BILLIK', '2025-11-08', '18:00:00', '00:00:00', 6.00, 'Integrasi Akuntansi & Return', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(306, 8, 'AEGNER BILLIK', '2025-11-09', '18:00:00', '00:00:00', 6.00, 'Code Review & Integration Test', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(307, 8, 'AEGNER BILLIK', '2025-11-10', '18:00:00', '00:00:00', 6.00, 'Dev. Return Sisa Konsinyasi', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(308, 8, 'AEGNER BILLIK', '2025-11-11', '18:00:00', '00:00:00', 6.00, 'Finalisasi Return & History Modal', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(309, 8, 'AEGNER BILLIK', '2025-11-12', '18:00:00', '00:00:00', 6.00, 'Dev. Supplier & Stock Adj.', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(310, 8, 'AEGNER BILLIK', '2025-11-13', '18:00:00', '00:00:00', 6.00, 'Impl. Stock Adj. & UX', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(311, 8, 'AEGNER BILLIK', '2025-11-14', '18:00:00', '00:00:00', 6.00, 'Integrasi Auth, Security & Supplier', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(312, 8, 'AEGNER BILLIK', '2025-11-15', '18:00:00', '00:00:00', 6.00, 'Testing Supplier & Bugfix', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(313, 8, 'AEGNER BILLIK', '2025-11-16', '18:00:00', '00:00:00', 6.00, 'Dokumentasi & Tech Review', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(314, 8, 'AEGNER BILLIK', '2025-11-17', '18:00:00', '00:00:00', 6.00, 'Refinement UI/UX Supplier', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(315, 8, 'AEGNER BILLIK', '2025-11-18', '18:00:00', '00:00:00', 6.00, 'Dev. Evaluasi Supplier & UAT', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(316, 8, 'AEGNER BILLIK', '2025-11-19', '18:00:00', '00:00:00', 6.00, 'Impl. Rating & Evaluasi', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(317, 8, 'AEGNER BILLIK', '2025-11-20', '18:00:00', '00:00:00', 6.00, 'Testing Evaluasi Supplier', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(318, 8, 'AEGNER BILLIK', '2025-11-21', '18:00:00', '00:00:00', 6.00, 'Setup Environment UAT', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(319, 8, 'AEGNER BILLIK', '2025-11-22', '18:00:00', '00:00:00', 6.00, 'Integration Test & Final Check', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(320, 8, 'AEGNER BILLIK', '2025-11-23', '18:00:00', '00:00:00', 6.00, 'Final Review & Dokumentasi', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:03', '2026-01-12 15:41:03'),
(321, 8, 'M. REYVAN PURNAMA', '2025-12-01', '18:00:00', '00:00:00', 6.00, 'Halaman Manajemen Simpanan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(322, 8, 'M. REYVAN PURNAMA', '2025-12-02', '18:00:00', '00:00:00', 6.00, 'Fitur Import Anggota via Excel', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(323, 8, 'M. REYVAN PURNAMA', '2025-12-03', '18:00:00', '00:00:00', 6.00, 'Implementasi Core System POS (Point of Sales)', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(324, 8, 'M. REYVAN PURNAMA', '2025-12-04', '18:00:00', '00:00:00', 6.00, 'Fitur Registrasi Supplier', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(325, 8, 'M. REYVAN PURNAMA', '2025-12-05', '18:00:00', '00:00:00', 6.00, 'Fitur Skip Check-in untuk Kasir', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(326, 8, 'M. REYVAN PURNAMA', '2025-12-06', '18:00:00', '00:00:00', 6.00, 'Form Edit Data Anggota', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(327, 8, 'M. REYVAN PURNAMA', '2025-12-07', '18:00:00', '00:00:00', 6.00, 'Desain Dashboard & Login Page', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(328, 8, 'M. REYVAN PURNAMA', '2025-12-08', '18:00:00', '00:00:00', 6.00, 'Fitur Transaksi & Detail Penjualan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(329, 8, 'M. REYVAN PURNAMA', '2025-12-09', '18:00:00', '00:00:00', 6.00, 'Dokumentasi Teknis & API', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(330, 8, 'M. REYVAN PURNAMA', '2025-12-10', '18:00:00', '00:00:00', 6.00, 'Optimasi Tampilan Quick Stats', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(331, 8, 'M. REYVAN PURNAMA', '2025-12-11', '18:00:00', '00:00:00', 6.00, 'Perbaikan Skema Database & Foreign Keys', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(332, 8, 'M. REYVAN PURNAMA', '2025-12-12', '18:00:00', '00:00:00', 6.00, 'Optimasi Query Database', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(333, 8, 'M. REYVAN PURNAMA', '2025-12-13', '18:00:00', '00:00:00', 6.00, 'Form Tambah Anggota dengan Wizard', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(334, 8, 'M. REYVAN PURNAMA', '2025-12-14', '18:00:00', '00:00:00', 6.00, 'Approval Workflow Auto-Debit', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(335, 8, 'M. REYVAN PURNAMA', '2025-12-15', '18:00:00', '00:00:00', 6.00, 'Manajemen Shift Kasir (Check-in/out)', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(336, 8, 'M. REYVAN PURNAMA', '2025-12-16', '18:00:00', '00:00:00', 6.00, 'Sistem Auto-Debit Simpanan Wajib', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(337, 8, 'M. REYVAN PURNAMA', '2025-12-17', '18:00:00', '00:00:00', 6.00, 'Widget Profitabilitas pada Dashboard', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(338, 8, 'M. REYVAN PURNAMA', '2025-12-18', '18:00:00', '00:00:00', 6.00, 'Manajemen Produk & Inventaris', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(339, 8, 'M. REYVAN PURNAMA', '2025-12-19', '18:00:00', '00:00:00', 6.00, 'Perbaikan Logika Tanggal Laporan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(340, 8, 'M. REYVAN PURNAMA', '2025-12-20', '18:00:00', '00:00:00', 6.00, 'Inisialisasi Project Laravel & Filament', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(341, 8, 'M. REYVAN PURNAMA', '2025-12-21', '18:00:00', '00:00:00', 6.00, 'Sistem Upload Bukti Transaksi', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(342, 8, 'M. REYVAN PURNAMA', '2025-12-22', '18:00:00', '00:00:00', 6.00, 'Setup Environment Production', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(343, 8, 'M. REYVAN PURNAMA', '2025-12-23', '18:00:00', '00:00:00', 6.00, 'Mempelajari Simpan Pinjam & Konsep Dasar', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:08', '2026-01-12 15:41:08'),
(344, 8, 'M. REYVAN PURNAMA', '2025-11-01', '18:00:00', '00:00:00', 6.00, 'Setup Env & Review Fitur Keuangan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(345, 8, 'M. REYVAN PURNAMA', '2025-11-02', '18:00:00', '00:00:00', 6.00, 'Desain DB Neraca & Konsinyasi', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(346, 8, 'M. REYVAN PURNAMA', '2025-11-03', '18:00:00', '00:00:00', 6.00, 'Prep Modul Keuangan & Komponen', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(347, 8, 'M. REYVAN PURNAMA', '2025-11-04', '18:00:00', '00:00:00', 6.00, 'Impl. API Neraca & DB Akuntansi', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(348, 8, 'M. REYVAN PURNAMA', '2025-11-05', '18:00:00', '00:00:00', 6.00, 'Logika Neraca & Tracking Aset', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(349, 8, 'M. REYVAN PURNAMA', '2025-11-06', '18:00:00', '00:00:00', 6.00, 'Tracking Liabilitas & Ekuitas', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(350, 8, 'M. REYVAN PURNAMA', '2025-11-07', '18:00:00', '00:00:00', 6.00, 'Finalisasi Neraca & Produk Titipan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(351, 8, 'M. REYVAN PURNAMA', '2025-11-08', '18:00:00', '00:00:00', 6.00, 'Akuntansi Konsinyasi & Integrasi POS', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(352, 8, 'M. REYVAN PURNAMA', '2025-11-09', '18:00:00', '00:00:00', 6.00, 'Import Anggota & History Simpanan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(353, 8, 'M. REYVAN PURNAMA', '2025-11-10', '18:00:00', '00:00:00', 6.00, 'Manajemen Anggota & Integrasi Neraca', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(354, 8, 'M. REYVAN PURNAMA', '2025-11-11', '18:00:00', '00:00:00', 6.00, 'Refactor Form & UI Anggota', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(355, 8, 'M. REYVAN PURNAMA', '2025-11-12', '18:00:00', '00:00:00', 6.00, 'Fitur Setor & Tarik Simpanan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(356, 8, 'M. REYVAN PURNAMA', '2025-11-13', '18:00:00', '00:00:00', 6.00, 'Migrasi Next.js 15 & Update API', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(357, 8, 'M. REYVAN PURNAMA', '2025-11-14', '18:00:00', '00:00:00', 6.00, 'Integrasi Keuangan & Saldo', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(358, 8, 'M. REYVAN PURNAMA', '2025-11-15', '18:00:00', '00:00:00', 6.00, 'Optimasi Transaksi & Expense', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(359, 8, 'M. REYVAN PURNAMA', '2025-11-16', '18:00:00', '00:00:00', 6.00, 'Dev. Dashboard & KPI Metrics', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(360, 8, 'M. REYVAN PURNAMA', '2025-11-17', '18:00:00', '00:00:00', 6.00, 'Chart Cash Flow & Enhancements', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(361, 8, 'M. REYVAN PURNAMA', '2025-11-18', '18:00:00', '00:00:00', 6.00, 'Fix Bug Kritis Perhitungan Simpanan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(362, 8, 'M. REYVAN PURNAMA', '2025-11-19', '18:00:00', '00:00:00', 6.00, 'Tracking Konsinyasi & Tooltips', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(363, 8, 'M. REYVAN PURNAMA', '2025-11-20', '18:00:00', '00:00:00', 6.00, 'Polish UI/UX & Styling', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(364, 8, 'M. REYVAN PURNAMA', '2025-11-21', '18:00:00', '00:00:00', 6.00, 'Detail API & Debugging Sistem', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(365, 8, 'M. REYVAN PURNAMA', '2025-11-22', '18:00:00', '00:00:00', 6.00, 'Testing, QA & Optimasi Performa', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(366, 8, 'M. REYVAN PURNAMA', '2025-11-23', '18:00:00', '00:00:00', 6.00, 'Dokumentasi & Code Cleanup', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-01-12 15:41:14', '2026-01-12 15:41:14'),
(367, 8, 'AEGNER BILLIK', '2026-01-01', '18:00:00', '00:00:00', 6.00, 'Implementasi sistem supplier consignment dan approval produk', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(368, 8, 'AEGNER BILLIK', '2026-01-02', '18:00:00', '00:00:00', 6.00, 'Pengembangan kasir history serta ringkasan performa kasir', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(369, 8, 'AEGNER BILLIK', '2026-01-03', '18:00:00', '00:00:00', 6.00, 'Perapihan kategori produk melalui modal pada halaman inventaris', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(370, 8, 'AEGNER BILLIK', '2026-01-04', '18:00:00', '00:00:00', 6.00, 'Perbaikan dashboard chart agar lebih informatif', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(371, 8, 'AEGNER BILLIK', '2026-01-05', '18:00:00', '00:00:00', 6.00, 'Implementasi loyalty member minimarket dan auto create', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(372, 8, 'AEGNER BILLIK', '2026-01-06', '18:00:00', '00:00:00', 6.00, 'Refactor laporan keuangan untuk pemisahan sumber pinjaman', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(373, 8, 'AEGNER BILLIK', '2026-01-07', '18:00:00', '00:00:00', 6.00, 'Perbaikan typo dan duplikasi kode pada laporan bulanan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(374, 8, 'AEGNER BILLIK', '2026-01-08', '18:00:00', '00:00:00', 6.00, 'Penguatan alur create member agar tidak membingungkan user', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(375, 8, 'AEGNER BILLIK', '2026-01-09', '18:00:00', '00:00:00', 6.00, 'Update status member suspend activate sesuai enum database', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(376, 8, 'AEGNER BILLIK', '2026-01-10', '18:00:00', '00:00:00', 6.00, 'Penyelarasan struktur data BMT ITQAN pada laporan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(377, 8, 'AEGNER BILLIK', '2026-01-11', '18:00:00', '00:00:00', 6.00, 'Implementasi sistem supplier consignment dan approval produk', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(378, 8, 'AEGNER BILLIK', '2026-01-12', '18:00:00', '00:00:00', 6.00, 'Pengembangan kasir history serta ringkasan performa kasir', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(379, 8, 'AEGNER BILLIK', '2026-01-13', '18:00:00', '00:00:00', 6.00, 'Perapihan kategori produk melalui modal pada halaman inventaris', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(380, 8, 'AEGNER BILLIK', '2026-01-14', '18:00:00', '00:00:00', 6.00, 'Perbaikan dashboard chart agar lebih informatif', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(381, 8, 'AEGNER BILLIK', '2026-01-15', '18:00:00', '00:00:00', 6.00, 'Implementasi loyalty member minimarket dan auto create', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(382, 8, 'AEGNER BILLIK', '2026-01-16', '18:00:00', '00:00:00', 6.00, 'Refactor laporan keuangan untuk pemisahan sumber pinjaman', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(383, 8, 'AEGNER BILLIK', '2026-01-17', '18:00:00', '00:00:00', 6.00, 'Perbaikan typo dan duplikasi kode pada laporan bulanan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(384, 8, 'AEGNER BILLIK', '2026-01-18', '18:00:00', '00:00:00', 6.00, 'Penguatan alur create member agar tidak membingungkan user', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(385, 8, 'AEGNER BILLIK', '2026-01-19', '18:00:00', '00:00:00', 6.00, 'Update status member suspend activate sesuai enum database', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(386, 8, 'AEGNER BILLIK', '2026-01-20', '18:00:00', '00:00:00', 6.00, 'Penyelarasan struktur data BMT ITQAN pada laporan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(387, 8, 'AEGNER BILLIK', '2026-01-21', '18:00:00', '00:00:00', 6.00, 'Implementasi sistem supplier consignment dan approval produk', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(388, 8, 'AEGNER BILLIK', '2026-01-22', '18:00:00', '00:00:00', 6.00, 'Pengembangan kasir history serta ringkasan performa kasir', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(389, 8, 'AEGNER BILLIK', '2026-01-23', '18:00:00', '00:00:00', 6.00, 'Perapihan kategori produk melalui modal pada halaman inventaris', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(390, 8, 'AEGNER BILLIK', '2026-01-24', '18:00:00', '00:00:00', 6.00, 'Perbaikan dashboard chart agar lebih informatif', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(391, 8, 'AEGNER BILLIK', '2026-01-25', '18:00:00', '00:00:00', 6.00, 'Implementasi loyalty member minimarket dan auto create', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:34:38', '2026-04-25 07:34:38'),
(392, 8, 'AEGNER BILLIK', '2026-02-01', '18:00:00', '00:00:00', 6.00, 'Peningkatan format PDF laporan keuangan bulanan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(393, 8, 'AEGNER BILLIK', '2026-02-02', '18:00:00', '00:00:00', 6.00, 'Perbaikan urutan member pada laporan berdasarkan pinjaman', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(394, 8, 'AEGNER BILLIK', '2026-02-03', '18:00:00', '00:00:00', 6.00, 'Penyesuaian kolom simpanan wajib pinjaman dan sukarela', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(395, 8, 'AEGNER BILLIK', '2026-02-04', '18:00:00', '00:00:00', 6.00, 'Implementasi form supplier untuk pembuatan akun otomatis', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(396, 8, 'AEGNER BILLIK', '2026-02-05', '18:00:00', '00:00:00', 6.00, 'Debugging workflow approval supplier dan validasi input', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(397, 8, 'AEGNER BILLIK', '2026-02-06', '18:00:00', '00:00:00', 6.00, 'Perbaikan integrasi route setelah merge branch', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(398, 8, 'AEGNER BILLIK', '2026-02-07', '18:00:00', '00:00:00', 6.00, 'Code cleanup pasca merge untuk stabilisasi modul admin', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(399, 8, 'AEGNER BILLIK', '2026-02-08', '18:00:00', '00:00:00', 6.00, 'Pengujian laporan payroll dan output PDF', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(400, 8, 'AEGNER BILLIK', '2026-02-09', '18:00:00', '00:00:00', 6.00, 'Refinement UX halaman laporan untuk readability', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(401, 8, 'AEGNER BILLIK', '2026-02-10', '18:00:00', '00:00:00', 6.00, 'Verifikasi data transaksi terhadap laporan keuangan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(402, 8, 'AEGNER BILLIK', '2026-02-11', '18:00:00', '00:00:00', 6.00, 'Peningkatan format PDF laporan keuangan bulanan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(403, 8, 'AEGNER BILLIK', '2026-02-12', '18:00:00', '00:00:00', 6.00, 'Perbaikan urutan member pada laporan berdasarkan pinjaman', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(404, 8, 'AEGNER BILLIK', '2026-02-13', '18:00:00', '00:00:00', 6.00, 'Penyesuaian kolom simpanan wajib pinjaman dan sukarela', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(405, 8, 'AEGNER BILLIK', '2026-02-14', '18:00:00', '00:00:00', 6.00, 'Implementasi form supplier untuk pembuatan akun otomatis', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(406, 8, 'AEGNER BILLIK', '2026-02-15', '18:00:00', '00:00:00', 6.00, 'Debugging workflow approval supplier dan validasi input', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(407, 8, 'AEGNER BILLIK', '2026-02-16', '18:00:00', '00:00:00', 6.00, 'Perbaikan integrasi route setelah merge branch', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(408, 8, 'AEGNER BILLIK', '2026-02-17', '18:00:00', '00:00:00', 6.00, 'Code cleanup pasca merge untuk stabilisasi modul admin', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(409, 8, 'AEGNER BILLIK', '2026-02-18', '18:00:00', '00:00:00', 6.00, 'Pengujian laporan payroll dan output PDF', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(410, 8, 'AEGNER BILLIK', '2026-02-19', '18:00:00', '00:00:00', 6.00, 'Refinement UX halaman laporan untuk readability', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(411, 8, 'AEGNER BILLIK', '2026-02-20', '18:00:00', '00:00:00', 6.00, 'Verifikasi data transaksi terhadap laporan keuangan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(412, 8, 'AEGNER BILLIK', '2026-02-21', '18:00:00', '00:00:00', 6.00, 'Peningkatan format PDF laporan keuangan bulanan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(413, 8, 'AEGNER BILLIK', '2026-02-22', '18:00:00', '00:00:00', 6.00, 'Perbaikan urutan member pada laporan berdasarkan pinjaman', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(414, 8, 'AEGNER BILLIK', '2026-02-23', '18:00:00', '00:00:00', 6.00, 'Penyesuaian kolom simpanan wajib pinjaman dan sukarela', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(415, 8, 'AEGNER BILLIK', '2026-02-24', '18:00:00', '00:00:00', 6.00, 'Implementasi form supplier untuk pembuatan akun otomatis', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(416, 8, 'AEGNER BILLIK', '2026-02-25', '18:00:00', '00:00:00', 6.00, 'Debugging workflow approval supplier dan validasi input', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:09', '2026-04-25 07:35:09'),
(417, 8, 'AEGNER BILLIK', '2026-03-01', '18:00:00', '00:00:00', 6.00, 'Support implementasi export PDF daftar tanda tangan anggota', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(418, 8, 'AEGNER BILLIK', '2026-03-02', '18:00:00', '00:00:00', 6.00, 'Sinkronisasi menu admin members dengan kebutuhan operasional', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(419, 8, 'AEGNER BILLIK', '2026-03-03', '18:00:00', '00:00:00', 6.00, 'Perbaikan akses role pada route payroll developer', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(420, 8, 'AEGNER BILLIK', '2026-03-04', '18:00:00', '00:00:00', 6.00, 'Validasi data member retail agar terhitung di export', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(421, 8, 'AEGNER BILLIK', '2026-03-05', '18:00:00', '00:00:00', 6.00, 'Refinement komponen sidebar dan navigasi developer', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(422, 8, 'AEGNER BILLIK', '2026-03-06', '18:00:00', '00:00:00', 6.00, 'Uji regresi alur import export pada modul work logs', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(423, 8, 'AEGNER BILLIK', '2026-03-07', '18:00:00', '00:00:00', 6.00, 'Perbaikan style dan konsistensi komponen admin', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(424, 8, 'AEGNER BILLIK', '2026-03-08', '18:00:00', '00:00:00', 6.00, 'Review mapping data anggota untuk kebutuhan laporan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(425, 8, 'AEGNER BILLIK', '2026-03-09', '18:00:00', '00:00:00', 6.00, 'Pembersihan issue kecil pasca deployment update Maret', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(426, 8, 'AEGNER BILLIK', '2026-03-10', '18:00:00', '00:00:00', 6.00, 'Koordinasi final testing fitur payroll dan member', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(427, 8, 'AEGNER BILLIK', '2026-03-11', '18:00:00', '00:00:00', 6.00, 'Support implementasi export PDF daftar tanda tangan anggota', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(428, 8, 'AEGNER BILLIK', '2026-03-12', '18:00:00', '00:00:00', 6.00, 'Sinkronisasi menu admin members dengan kebutuhan operasional', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(429, 8, 'AEGNER BILLIK', '2026-03-13', '18:00:00', '00:00:00', 6.00, 'Perbaikan akses role pada route payroll developer', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(430, 8, 'AEGNER BILLIK', '2026-03-14', '18:00:00', '00:00:00', 6.00, 'Validasi data member retail agar terhitung di export', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(431, 8, 'AEGNER BILLIK', '2026-03-15', '18:00:00', '00:00:00', 6.00, 'Refinement komponen sidebar dan navigasi developer', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(432, 8, 'AEGNER BILLIK', '2026-03-16', '18:00:00', '00:00:00', 6.00, 'Uji regresi alur import export pada modul work logs', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(433, 8, 'AEGNER BILLIK', '2026-03-17', '18:00:00', '00:00:00', 6.00, 'Perbaikan style dan konsistensi komponen admin', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(434, 8, 'AEGNER BILLIK', '2026-03-18', '18:00:00', '00:00:00', 6.00, 'Review mapping data anggota untuk kebutuhan laporan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(435, 8, 'AEGNER BILLIK', '2026-03-19', '18:00:00', '00:00:00', 6.00, 'Pembersihan issue kecil pasca deployment update Maret', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(436, 8, 'AEGNER BILLIK', '2026-03-20', '18:00:00', '00:00:00', 6.00, 'Koordinasi final testing fitur payroll dan member', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(437, 8, 'AEGNER BILLIK', '2026-03-21', '18:00:00', '00:00:00', 6.00, 'Support implementasi export PDF daftar tanda tangan anggota', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(438, 8, 'AEGNER BILLIK', '2026-03-22', '18:00:00', '00:00:00', 6.00, 'Sinkronisasi menu admin members dengan kebutuhan operasional', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(439, 8, 'AEGNER BILLIK', '2026-03-23', '18:00:00', '00:00:00', 6.00, 'Perbaikan akses role pada route payroll developer', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(440, 8, 'AEGNER BILLIK', '2026-03-24', '18:00:00', '00:00:00', 6.00, 'Validasi data member retail agar terhitung di export', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(441, 8, 'AEGNER BILLIK', '2026-03-25', '18:00:00', '00:00:00', 6.00, 'Refinement komponen sidebar dan navigasi developer', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:21', '2026-04-25 07:35:21'),
(442, 8, 'M. REYVAN PURNAMA', '2026-01-01', '18:00:00', '00:00:00', 6.00, 'Pengembangan Simwa Audit Tool dan rekonsiliasi data', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:45', '2026-04-25 07:35:45'),
(443, 8, 'M. REYVAN PURNAMA', '2026-01-02', '18:00:00', '00:00:00', 6.00, 'Refactor profile member dan konsistensi konfigurasi simpanan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:45', '2026-04-25 07:35:45'),
(444, 8, 'M. REYVAN PURNAMA', '2026-01-03', '18:00:00', '00:00:00', 6.00, 'Perbaikan validasi input rupiah pada form financial', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:45', '2026-04-25 07:35:45'),
(445, 8, 'M. REYVAN PURNAMA', '2026-01-04', '18:00:00', '00:00:00', 6.00, 'Debugging modal profile dan peningkatan responsivitas mobile', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:46', '2026-04-25 07:35:46'),
(446, 8, 'M. REYVAN PURNAMA', '2026-01-05', '18:00:00', '00:00:00', 6.00, 'Sinkronisasi logika payroll snapshot dengan laporan bulanan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:46', '2026-04-25 07:35:46'),
(447, 8, 'M. REYVAN PURNAMA', '2026-01-06', '18:00:00', '00:00:00', 6.00, 'Integrasi data retail portal dengan member profile', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:46', '2026-04-25 07:35:46'),
(448, 8, 'M. REYVAN PURNAMA', '2026-01-07', '18:00:00', '00:00:00', 6.00, 'Perbaikan bug transfer status dan history pada member dashboard', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:46', '2026-04-25 07:35:46'),
(449, 8, 'M. REYVAN PURNAMA', '2026-01-08', '18:00:00', '00:00:00', 6.00, 'Code review dan penyesuaian query untuk akurasi audit', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:46', '2026-04-25 07:35:46'),
(450, 8, 'M. REYVAN PURNAMA', '2026-01-09', '18:00:00', '00:00:00', 6.00, 'Penyempurnaan dokumentasi teknis modul simpanan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:46', '2026-04-25 07:35:46'),
(451, 8, 'M. REYVAN PURNAMA', '2026-01-10', '18:00:00', '00:00:00', 6.00, 'Pengujian end to end alur audit dan koreksi edge case', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:46', '2026-04-25 07:35:46'),
(452, 8, 'M. REYVAN PURNAMA', '2026-01-11', '18:00:00', '00:00:00', 6.00, 'Pengembangan Simwa Audit Tool dan rekonsiliasi data', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:46', '2026-04-25 07:35:46'),
(453, 8, 'M. REYVAN PURNAMA', '2026-01-12', '18:00:00', '00:00:00', 6.00, 'Refactor profile member dan konsistensi konfigurasi simpanan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:46', '2026-04-25 07:35:46'),
(454, 8, 'M. REYVAN PURNAMA', '2026-01-13', '18:00:00', '00:00:00', 6.00, 'Perbaikan validasi input rupiah pada form financial', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:46', '2026-04-25 07:35:46'),
(455, 8, 'M. REYVAN PURNAMA', '2026-01-14', '18:00:00', '00:00:00', 6.00, 'Debugging modal profile dan peningkatan responsivitas mobile', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:46', '2026-04-25 07:35:46'),
(456, 8, 'M. REYVAN PURNAMA', '2026-01-15', '18:00:00', '00:00:00', 6.00, 'Sinkronisasi logika payroll snapshot dengan laporan bulanan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:46', '2026-04-25 07:35:46'),
(457, 8, 'M. REYVAN PURNAMA', '2026-01-16', '18:00:00', '00:00:00', 6.00, 'Integrasi data retail portal dengan member profile', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:46', '2026-04-25 07:35:46'),
(458, 8, 'M. REYVAN PURNAMA', '2026-01-17', '18:00:00', '00:00:00', 6.00, 'Perbaikan bug transfer status dan history pada member dashboard', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:46', '2026-04-25 07:35:46'),
(459, 8, 'M. REYVAN PURNAMA', '2026-01-18', '18:00:00', '00:00:00', 6.00, 'Code review dan penyesuaian query untuk akurasi audit', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:46', '2026-04-25 07:35:46'),
(460, 8, 'M. REYVAN PURNAMA', '2026-01-19', '18:00:00', '00:00:00', 6.00, 'Penyempurnaan dokumentasi teknis modul simpanan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:46', '2026-04-25 07:35:46'),
(461, 8, 'M. REYVAN PURNAMA', '2026-01-20', '18:00:00', '00:00:00', 6.00, 'Pengujian end to end alur audit dan koreksi edge case', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:46', '2026-04-25 07:35:46'),
(462, 8, 'M. REYVAN PURNAMA', '2026-01-21', '18:00:00', '00:00:00', 6.00, 'Pengembangan Simwa Audit Tool dan rekonsiliasi data', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:46', '2026-04-25 07:35:46'),
(463, 8, 'M. REYVAN PURNAMA', '2026-01-22', '18:00:00', '00:00:00', 6.00, 'Refactor profile member dan konsistensi konfigurasi simpanan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:46', '2026-04-25 07:35:46'),
(464, 8, 'M. REYVAN PURNAMA', '2026-01-23', '18:00:00', '00:00:00', 6.00, 'Perbaikan validasi input rupiah pada form financial', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:46', '2026-04-25 07:35:46'),
(465, 8, 'M. REYVAN PURNAMA', '2026-01-24', '18:00:00', '00:00:00', 6.00, 'Debugging modal profile dan peningkatan responsivitas mobile', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:46', '2026-04-25 07:35:46'),
(466, 8, 'M. REYVAN PURNAMA', '2026-01-25', '18:00:00', '00:00:00', 6.00, 'Sinkronisasi logika payroll snapshot dengan laporan bulanan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:35:46', '2026-04-25 07:35:46'),
(467, 8, 'M. REYVAN PURNAMA', '2026-02-01', '18:00:00', '00:00:00', 6.00, 'Pengembangan fitur payroll execution dan approval workflow', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(468, 8, 'M. REYVAN PURNAMA', '2026-02-02', '18:00:00', '00:00:00', 6.00, 'Implementasi halaman pinjaman member dan peningkatan UX', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(469, 8, 'M. REYVAN PURNAMA', '2026-02-03', '18:00:00', '00:00:00', 6.00, 'Perbaikan logic mapping nama pada tabel rekonsiliasi', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(470, 8, 'M. REYVAN PURNAMA', '2026-02-04', '18:00:00', '00:00:00', 6.00, 'Enhancement import CSV detail row untuk audit bank dan simwa', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(471, 8, 'M. REYVAN PURNAMA', '2026-02-05', '18:00:00', '00:00:00', 6.00, 'Debugging split nominal Simpok Simwa dan Sukarela', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(472, 8, 'M. REYVAN PURNAMA', '2026-02-06', '18:00:00', '00:00:00', 6.00, 'Perbaikan race condition pada proses rebuild history', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(473, 8, 'M. REYVAN PURNAMA', '2026-02-07', '18:00:00', '00:00:00', 6.00, 'Penyempurnaan filtering laporan agar tidak stale', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(474, 8, 'M. REYVAN PURNAMA', '2026-02-08', '18:00:00', '00:00:00', 6.00, 'Refactor komponen laporan keuangan bulanan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(475, 8, 'M. REYVAN PURNAMA', '2026-02-09', '18:00:00', '00:00:00', 6.00, 'Uji regresi fitur audit dan payroll snapshot', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(476, 8, 'M. REYVAN PURNAMA', '2026-02-10', '18:00:00', '00:00:00', 6.00, 'Finalisasi perbaikan query dan stabilisasi modul member', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(477, 8, 'M. REYVAN PURNAMA', '2026-02-11', '18:00:00', '00:00:00', 6.00, 'Pengembangan fitur payroll execution dan approval workflow', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(478, 8, 'M. REYVAN PURNAMA', '2026-02-12', '18:00:00', '00:00:00', 6.00, 'Implementasi halaman pinjaman member dan peningkatan UX', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(479, 8, 'M. REYVAN PURNAMA', '2026-02-13', '18:00:00', '00:00:00', 6.00, 'Perbaikan logic mapping nama pada tabel rekonsiliasi', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(480, 8, 'M. REYVAN PURNAMA', '2026-02-14', '18:00:00', '00:00:00', 6.00, 'Enhancement import CSV detail row untuk audit bank dan simwa', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(481, 8, 'M. REYVAN PURNAMA', '2026-02-15', '18:00:00', '00:00:00', 6.00, 'Debugging split nominal Simpok Simwa dan Sukarela', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(482, 8, 'M. REYVAN PURNAMA', '2026-02-16', '18:00:00', '00:00:00', 6.00, 'Perbaikan race condition pada proses rebuild history', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(483, 8, 'M. REYVAN PURNAMA', '2026-02-17', '18:00:00', '00:00:00', 6.00, 'Penyempurnaan filtering laporan agar tidak stale', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(484, 8, 'M. REYVAN PURNAMA', '2026-02-18', '18:00:00', '00:00:00', 6.00, 'Refactor komponen laporan keuangan bulanan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(485, 8, 'M. REYVAN PURNAMA', '2026-02-19', '18:00:00', '00:00:00', 6.00, 'Uji regresi fitur audit dan payroll snapshot', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(486, 8, 'M. REYVAN PURNAMA', '2026-02-20', '18:00:00', '00:00:00', 6.00, 'Finalisasi perbaikan query dan stabilisasi modul member', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(487, 8, 'M. REYVAN PURNAMA', '2026-02-21', '18:00:00', '00:00:00', 6.00, 'Pengembangan fitur payroll execution dan approval workflow', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(488, 8, 'M. REYVAN PURNAMA', '2026-02-22', '18:00:00', '00:00:00', 6.00, 'Implementasi halaman pinjaman member dan peningkatan UX', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(489, 8, 'M. REYVAN PURNAMA', '2026-02-23', '18:00:00', '00:00:00', 6.00, 'Perbaikan logic mapping nama pada tabel rekonsiliasi', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(490, 8, 'M. REYVAN PURNAMA', '2026-02-24', '18:00:00', '00:00:00', 6.00, 'Enhancement import CSV detail row untuk audit bank dan simwa', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(491, 8, 'M. REYVAN PURNAMA', '2026-02-25', '18:00:00', '00:00:00', 6.00, 'Debugging split nominal Simpok Simwa dan Sukarela', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:07', '2026-04-25 07:36:07'),
(492, 8, 'M. REYVAN PURNAMA', '2026-03-01', '18:00:00', '00:00:00', 6.00, 'Pengembangan fitur tanda tangan paket lebaran anggota', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(493, 8, 'M. REYVAN PURNAMA', '2026-03-02', '18:00:00', '00:00:00', 6.00, 'Penyesuaian filter export agar mencakup member retail aktif', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(494, 8, 'M. REYVAN PURNAMA', '2026-03-03', '18:00:00', '00:00:00', 6.00, 'Perapihan layout PDF dan metadata laporan tanda tangan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(495, 8, 'M. REYVAN PURNAMA', '2026-03-04', '18:00:00', '00:00:00', 6.00, 'Implementasi monitoring kasir dan performa transaksi', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(496, 8, 'M. REYVAN PURNAMA', '2026-03-05', '18:00:00', '00:00:00', 6.00, 'Perbaikan konsistensi data supplier dan settlement', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(497, 8, 'M. REYVAN PURNAMA', '2026-03-06', '18:00:00', '00:00:00', 6.00, 'Enhancement flow supply chain kasir dan riwayat shift', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(498, 8, 'M. REYVAN PURNAMA', '2026-03-07', '18:00:00', '00:00:00', 6.00, 'Optimasi locking stok pada proses transaksi POS', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(499, 8, 'M. REYVAN PURNAMA', '2026-03-08', '18:00:00', '00:00:00', 6.00, 'Refactor dashboard chart dan sinkronisasi financial data', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(500, 8, 'M. REYVAN PURNAMA', '2026-03-09', '18:00:00', '00:00:00', 6.00, 'Bugfix null safety pada alur supplier kasir', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(501, 8, 'M. REYVAN PURNAMA', '2026-03-10', '18:00:00', '00:00:00', 6.00, 'Uji integrasi fitur admin members dan payroll developer', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12');
INSERT INTO `work_logs` (`id`, `userId`, `developerName`, `date`, `startTime`, `endTime`, `hoursWorked`, `description`, `hourlyRate`, `totalAmount`, `status`, `approvedBy`, `approvedAt`, `paidAt`, `notes`, `created_at`, `updated_at`) VALUES
(502, 8, 'M. REYVAN PURNAMA', '2026-03-11', '18:00:00', '00:00:00', 6.00, 'Pengembangan fitur tanda tangan paket lebaran anggota', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(503, 8, 'M. REYVAN PURNAMA', '2026-03-12', '18:00:00', '00:00:00', 6.00, 'Penyesuaian filter export agar mencakup member retail aktif', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(504, 8, 'M. REYVAN PURNAMA', '2026-03-13', '18:00:00', '00:00:00', 6.00, 'Perapihan layout PDF dan metadata laporan tanda tangan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(505, 8, 'M. REYVAN PURNAMA', '2026-03-14', '18:00:00', '00:00:00', 6.00, 'Implementasi monitoring kasir dan performa transaksi', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(506, 8, 'M. REYVAN PURNAMA', '2026-03-15', '18:00:00', '00:00:00', 6.00, 'Perbaikan konsistensi data supplier dan settlement', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(507, 8, 'M. REYVAN PURNAMA', '2026-03-16', '18:00:00', '00:00:00', 6.00, 'Enhancement flow supply chain kasir dan riwayat shift', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(508, 8, 'M. REYVAN PURNAMA', '2026-03-17', '18:00:00', '00:00:00', 6.00, 'Optimasi locking stok pada proses transaksi POS', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(509, 8, 'M. REYVAN PURNAMA', '2026-03-18', '18:00:00', '00:00:00', 6.00, 'Refactor dashboard chart dan sinkronisasi financial data', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(510, 8, 'M. REYVAN PURNAMA', '2026-03-19', '18:00:00', '00:00:00', 6.00, 'Bugfix null safety pada alur supplier kasir', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(511, 8, 'M. REYVAN PURNAMA', '2026-03-20', '18:00:00', '00:00:00', 6.00, 'Uji integrasi fitur admin members dan payroll developer', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(512, 8, 'M. REYVAN PURNAMA', '2026-03-21', '18:00:00', '00:00:00', 6.00, 'Pengembangan fitur tanda tangan paket lebaran anggota', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(513, 8, 'M. REYVAN PURNAMA', '2026-03-22', '18:00:00', '00:00:00', 6.00, 'Penyesuaian filter export agar mencakup member retail aktif', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(514, 8, 'M. REYVAN PURNAMA', '2026-03-23', '18:00:00', '00:00:00', 6.00, 'Perapihan layout PDF dan metadata laporan tanda tangan', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(515, 8, 'M. REYVAN PURNAMA', '2026-03-24', '18:00:00', '00:00:00', 6.00, 'Implementasi monitoring kasir dan performa transaksi', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12'),
(516, 8, 'M. REYVAN PURNAMA', '2026-03-25', '18:00:00', '00:00:00', 6.00, 'Perbaikan konsistensi data supplier dan settlement', 6000.00, 36000.00, 'PENDING', NULL, NULL, NULL, NULL, '2026-04-25 07:36:12', '2026-04-25 07:36:12');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `activity_logs`
--
ALTER TABLE `activity_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `activity_logs_loggable_type_loggable_id_index` (`loggable_type`,`loggable_id`),
  ADD KEY `activity_logs_user_id_created_at_index` (`user_id`,`created_at`),
  ADD KEY `activity_logs_module_action_index` (`module`,`action`);

--
-- Indexes for table `audit_bank_category_rules`
--
ALTER TABLE `audit_bank_category_rules`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `audit_bank_category_rules_pattern_unique` (`pattern`),
  ADD KEY `audit_bank_category_rules_is_active_priority_index` (`is_active`,`priority`);

--
-- Indexes for table `audit_bank_imports`
--
ALTER TABLE `audit_bank_imports`
  ADD PRIMARY KEY (`id`),
  ADD KEY `audit_bank_imports_period_index` (`period`),
  ADD KEY `audit_bank_imports_transaction_date_index` (`transaction_date`),
  ADD KEY `audit_bank_imports_detected_type_detected_category_index` (`detected_type`,`detected_category`),
  ADD KEY `audit_bank_imports_is_synced_index` (`is_synced`),
  ADD KEY `audit_bank_imports_is_reviewed_index` (`is_reviewed`);

--
-- Indexes for table `audit_simwa_imports`
--
ALTER TABLE `audit_simwa_imports`
  ADD PRIMARY KEY (`id`),
  ADD KEY `audit_simwa_imports_matched_member_id_foreign` (`matched_member_id`),
  ADD KEY `audit_simwa_imports_filename_index` (`filename`),
  ADD KEY `audit_simwa_imports_period_index` (`period`);

--
-- Indexes for table `audit_simwa_name_mappings`
--
ALTER TABLE `audit_simwa_name_mappings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `audit_simwa_name_mappings_raw_name_unique` (`raw_name`),
  ADD KEY `audit_simwa_name_mappings_member_id_foreign` (`member_id`);

--
-- Indexes for table `bank_transactions`
--
ALTER TABLE `bank_transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `bank_transactions_transaction_date_index` (`transaction_date`),
  ADD KEY `bank_transactions_type_category_index` (`type`,`category`),
  ADD KEY `bank_transactions_period_index` (`period`);

--
-- Indexes for table `cashier_shifts`
--
ALTER TABLE `cashier_shifts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cashier_shifts_user_id_status_index` (`user_id`,`status`),
  ADD KEY `cashier_shifts_check_in_at_index` (`check_in_at`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `categories_name_unique` (`name`),
  ADD KEY `categories_isactive_index` (`isActive`),
  ADD KEY `categories_order_index` (`order`);

--
-- Indexes for table `consignment_batches`
--
ALTER TABLE `consignment_batches`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `consignment_batches_batchcode_unique` (`batchCode`),
  ADD KEY `consignment_batches_supplierid_foreign` (`supplierId`);

--
-- Indexes for table `consignment_items`
--
ALTER TABLE `consignment_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `consignment_items_batchid_foreign` (`batchId`),
  ADD KEY `consignment_items_productid_foreign` (`productId`);

--
-- Indexes for table `consignment_item_counts`
--
ALTER TABLE `consignment_item_counts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `consignment_item_counts_batchid_foreign` (`batchId`),
  ADD KEY `consignment_item_counts_productid_foreign` (`productId`),
  ADD KEY `consignment_item_counts_userid_foreign` (`userId`),
  ADD KEY `consignment_item_counts_supplierid_countedat_index` (`supplierId`,`countedAt`),
  ADD KEY `consignment_item_counts_consignmentitemid_countedat_index` (`consignmentItemId`,`countedAt`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `financial_report_snapshots`
--
ALTER TABLE `financial_report_snapshots`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `financial_report_snapshots_month_year_unique` (`month`,`year`),
  ADD KEY `financial_report_snapshots_executed_by_foreign` (`executed_by`);

--
-- Indexes for table `financial_transactions`
--
ALTER TABLE `financial_transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `financial_transactions_type_transactiondate_index` (`type`,`transactionDate`),
  ADD KEY `financial_transactions_userid_index` (`userId`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `job_batches`
--
ALTER TABLE `job_batches`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `loans`
--
ALTER TABLE `loans`
  ADD PRIMARY KEY (`id`),
  ADD KEY `loans_member_id_status_index` (`member_id`,`status`),
  ADD KEY `loans_status_index` (`status`);

--
-- Indexes for table `loan_payments`
--
ALTER TABLE `loan_payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `loan_payments_loanid_index` (`loanId`),
  ADD KEY `loan_payments_paymentdate_index` (`paymentDate`);

--
-- Indexes for table `members`
--
ALTER TABLE `members`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `members_userid_unique` (`userId`),
  ADD UNIQUE KEY `members_nomoranggota_unique` (`nomorAnggota`),
  ADD UNIQUE KEY `members_email_unique` (`email`),
  ADD KEY `members_status_joindate_index` (`status`,`joinDate`),
  ADD KEY `members_nomoranggota_index` (`nomorAnggota`),
  ADD KEY `members_tier_index` (`tier`),
  ADD KEY `members_unitkerja_index` (`unitKerja`);

--
-- Indexes for table `member_points_histories`
--
ALTER TABLE `member_points_histories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `member_points_histories_transaction_id_foreign` (`transactionId`),
  ADD KEY `member_points_histories_member_id_created_at_index` (`memberId`,`created_at`),
  ADD KEY `member_points_histories_type_index` (`type`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `products_sku_unique` (`sku`),
  ADD KEY `products_categoryid_isactive_index` (`categoryId`,`isActive`),
  ADD KEY `products_supplierid_status_index` (`supplierId`,`status`),
  ADD KEY `products_name_index` (`name`),
  ADD KEY `products_stock_index` (`stock`);

--
-- Indexes for table `rat_manual_entries`
--
ALTER TABLE `rat_manual_entries`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `rat_manual_entries_unique` (`table_key`,`row_key`,`field_key`,`year`),
  ADD KEY `rat_manual_entries_table_key_year_index` (`table_key`,`year`);

--
-- Indexes for table `restock_requests`
--
ALTER TABLE `restock_requests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `restock_requests_requestedby_foreign` (`requestedBy`),
  ADD KEY `restock_requests_supplierid_status_index` (`supplierId`,`status`),
  ADD KEY `restock_requests_productid_status_index` (`productId`,`status`);

--
-- Indexes for table `savings`
--
ALTER TABLE `savings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `savings_member_id_date_index` (`memberId`,`date`),
  ADD KEY `savings_type_index` (`type`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `simpanan_payments`
--
ALTER TABLE `simpanan_payments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `simpanan_payments_receiptnumber_unique` (`receiptNumber`),
  ADD KEY `simpanan_payments_billid_foreign` (`billId`),
  ADD KEY `simpanan_payments_memberid_foreign` (`memberId`),
  ADD KEY `simpanan_payments_processedby_foreign` (`processedBy`),
  ADD KEY `simpanan_payments_paymentdate_index` (`paymentDate`),
  ADD KEY `simpanan_payments_receiptnumber_index` (`receiptNumber`);

--
-- Indexes for table `simpanan_transactions`
--
ALTER TABLE `simpanan_transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `simpanan_transactions_processedby_foreign` (`processedBy`),
  ADD KEY `simpanan_transactions_approvedby_foreign` (`approvedBy`),
  ADD KEY `simpanan_transactions_memberid_type_index` (`memberId`,`type`),
  ADD KEY `simpanan_transactions_memberid_created_at_index` (`memberId`,`created_at`),
  ADD KEY `simpanan_transactions_status_index` (`status`),
  ADD KEY `simpanan_transactions_billingmonth_index` (`billingMonth`),
  ADD KEY `simpanan_transactions_billstatus_index` (`billStatus`),
  ADD KEY `simpanan_transactions_relatedmemberid_foreign` (`relatedMemberId`),
  ADD KEY `simpanan_transactions_transferreference_index` (`transferReference`);

--
-- Indexes for table `stock_movements`
--
ALTER TABLE `stock_movements`
  ADD PRIMARY KEY (`id`),
  ADD KEY `stock_movements_product_id_occurredat_index` (`productId`,`occurredAt`),
  ADD KEY `stock_movements_referencetype_referenceid_index` (`referenceType`,`referenceId`),
  ADD KEY `stock_movements_isproduction_index` (`isProduction`);

--
-- Indexes for table `supplier_notifications`
--
ALTER TABLE `supplier_notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `supplier_notifications_supplierid_foreign` (`supplierId`);

--
-- Indexes for table `supplier_payouts`
--
ALTER TABLE `supplier_payouts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `supplier_payouts_payoutcode_unique` (`payoutCode`),
  ADD KEY `supplier_payouts_userid_foreign` (`userId`),
  ADD KEY `supplier_payouts_supplierid_payoutdate_index` (`supplierId`,`payoutDate`);

--
-- Indexes for table `supplier_payout_allocations`
--
ALTER TABLE `supplier_payout_allocations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `supplier_payout_allocations_supplierpayoutid_foreign` (`supplierPayoutId`),
  ADD KEY `supplier_payout_allocations_consignmentitemid_index` (`consignmentItemId`),
  ADD KEY `supplier_payout_allocations_batchid_index` (`batchId`);

--
-- Indexes for table `transaction_items`
--
ALTER TABLE `transaction_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `transaction_items_transactionid_index` (`transactionId`),
  ADD KEY `transaction_items_productid_index` (`productId`),
  ADD KEY `transaction_items_isproduction_index` (`isProduction`);

--
-- Indexes for table `work_logs`
--
ALTER TABLE `work_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `work_logs_approvedby_foreign` (`approvedBy`),
  ADD KEY `work_logs_userid_date_index` (`userId`,`date`),
  ADD KEY `work_logs_userid_status_index` (`userId`,`status`),
  ADD KEY `work_logs_status_index` (`status`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activity_logs`
--
ALTER TABLE `activity_logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=506;

--
-- AUTO_INCREMENT for table `audit_bank_category_rules`
--
ALTER TABLE `audit_bank_category_rules`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `audit_bank_imports`
--
ALTER TABLE `audit_bank_imports`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17382;

--
-- AUTO_INCREMENT for table `audit_simwa_imports`
--
ALTER TABLE `audit_simwa_imports`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37884;

--
-- AUTO_INCREMENT for table `audit_simwa_name_mappings`
--
ALTER TABLE `audit_simwa_name_mappings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1182;

--
-- AUTO_INCREMENT for table `bank_transactions`
--
ALTER TABLE `bank_transactions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cashier_shifts`
--
ALTER TABLE `cashier_shifts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `consignment_batches`
--
ALTER TABLE `consignment_batches`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `consignment_items`
--
ALTER TABLE `consignment_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `consignment_item_counts`
--
ALTER TABLE `consignment_item_counts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `financial_report_snapshots`
--
ALTER TABLE `financial_report_snapshots`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `financial_transactions`
--
ALTER TABLE `financial_transactions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=182;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `loans`
--
ALTER TABLE `loans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;

--
-- AUTO_INCREMENT for table `loan_payments`
--
ALTER TABLE `loan_payments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=156;

--
-- AUTO_INCREMENT for table `members`
--
ALTER TABLE `members`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=527;

--
-- AUTO_INCREMENT for table `member_points_histories`
--
ALTER TABLE `member_points_histories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=341;

--
-- AUTO_INCREMENT for table `rat_manual_entries`
--
ALTER TABLE `rat_manual_entries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `restock_requests`
--
ALTER TABLE `restock_requests`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `savings`
--
ALTER TABLE `savings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `simpanan_payments`
--
ALTER TABLE `simpanan_payments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `simpanan_transactions`
--
ALTER TABLE `simpanan_transactions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19908;

--
-- AUTO_INCREMENT for table `stock_movements`
--
ALTER TABLE `stock_movements`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT for table `supplier_notifications`
--
ALTER TABLE `supplier_notifications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `supplier_payouts`
--
ALTER TABLE `supplier_payouts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `supplier_payout_allocations`
--
ALTER TABLE `supplier_payout_allocations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `transaction_items`
--
ALTER TABLE `transaction_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `work_logs`
--
ALTER TABLE `work_logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=517;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `activity_logs`
--
ALTER TABLE `activity_logs`
  ADD CONSTRAINT `activity_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `audit_simwa_imports`
--
ALTER TABLE `audit_simwa_imports`
  ADD CONSTRAINT `audit_simwa_imports_matched_member_id_foreign` FOREIGN KEY (`matched_member_id`) REFERENCES `members` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `audit_simwa_name_mappings`
--
ALTER TABLE `audit_simwa_name_mappings`
  ADD CONSTRAINT `audit_simwa_name_mappings_member_id_foreign` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `cashier_shifts`
--
ALTER TABLE `cashier_shifts`
  ADD CONSTRAINT `cashier_shifts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `consignment_batches`
--
ALTER TABLE `consignment_batches`
  ADD CONSTRAINT `consignment_batches_supplierid_foreign` FOREIGN KEY (`supplierId`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `consignment_items`
--
ALTER TABLE `consignment_items`
  ADD CONSTRAINT `consignment_items_batchid_foreign` FOREIGN KEY (`batchId`) REFERENCES `consignment_batches` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `consignment_items_productid_foreign` FOREIGN KEY (`productId`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `consignment_item_counts`
--
ALTER TABLE `consignment_item_counts`
  ADD CONSTRAINT `consignment_item_counts_batchid_foreign` FOREIGN KEY (`batchId`) REFERENCES `consignment_batches` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `consignment_item_counts_consignmentitemid_foreign` FOREIGN KEY (`consignmentItemId`) REFERENCES `consignment_items` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `consignment_item_counts_productid_foreign` FOREIGN KEY (`productId`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `consignment_item_counts_supplierid_foreign` FOREIGN KEY (`supplierId`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `consignment_item_counts_userid_foreign` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `financial_report_snapshots`
--
ALTER TABLE `financial_report_snapshots`
  ADD CONSTRAINT `financial_report_snapshots_executed_by_foreign` FOREIGN KEY (`executed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `financial_transactions`
--
ALTER TABLE `financial_transactions`
  ADD CONSTRAINT `financial_transactions_userid_foreign` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `loans`
--
ALTER TABLE `loans`
  ADD CONSTRAINT `loans_member_id_foreign` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `loan_payments`
--
ALTER TABLE `loan_payments`
  ADD CONSTRAINT `loan_payments_loanid_foreign` FOREIGN KEY (`loanId`) REFERENCES `loans` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `members`
--
ALTER TABLE `members`
  ADD CONSTRAINT `members_userid_foreign` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `member_points_histories`
--
ALTER TABLE `member_points_histories`
  ADD CONSTRAINT `member_points_histories_member_id_foreign` FOREIGN KEY (`memberId`) REFERENCES `members` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `member_points_histories_transaction_id_foreign` FOREIGN KEY (`transactionId`) REFERENCES `transactions` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_categoryid_foreign` FOREIGN KEY (`categoryId`) REFERENCES `categories` (`id`),
  ADD CONSTRAINT `products_supplierid_foreign` FOREIGN KEY (`supplierId`) REFERENCES `suppliers` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `restock_requests`
--
ALTER TABLE `restock_requests`
  ADD CONSTRAINT `restock_requests_productid_foreign` FOREIGN KEY (`productId`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `restock_requests_requestedby_foreign` FOREIGN KEY (`requestedBy`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `restock_requests_supplierid_foreign` FOREIGN KEY (`supplierId`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `savings`
--
ALTER TABLE `savings`
  ADD CONSTRAINT `savings_member_id_foreign` FOREIGN KEY (`memberId`) REFERENCES `members` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `simpanan_payments`
--
ALTER TABLE `simpanan_payments`
  ADD CONSTRAINT `simpanan_payments_billid_foreign` FOREIGN KEY (`billId`) REFERENCES `simpanan_transactions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `simpanan_payments_memberid_foreign` FOREIGN KEY (`memberId`) REFERENCES `members` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `simpanan_payments_processedby_foreign` FOREIGN KEY (`processedBy`) REFERENCES `users` (`id`);

--
-- Constraints for table `simpanan_transactions`
--
ALTER TABLE `simpanan_transactions`
  ADD CONSTRAINT `simpanan_transactions_relatedmemberid_foreign` FOREIGN KEY (`relatedMemberId`) REFERENCES `members` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `stock_movements`
--
ALTER TABLE `stock_movements`
  ADD CONSTRAINT `stock_movements_product_id_foreign` FOREIGN KEY (`productId`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `supplier_notifications`
--
ALTER TABLE `supplier_notifications`
  ADD CONSTRAINT `supplier_notifications_supplierid_foreign` FOREIGN KEY (`supplierId`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `supplier_payouts`
--
ALTER TABLE `supplier_payouts`
  ADD CONSTRAINT `supplier_payouts_supplierid_foreign` FOREIGN KEY (`supplierId`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `supplier_payouts_userid_foreign` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `supplier_payout_allocations`
--
ALTER TABLE `supplier_payout_allocations`
  ADD CONSTRAINT `supplier_payout_allocations_batchid_foreign` FOREIGN KEY (`batchId`) REFERENCES `consignment_batches` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `supplier_payout_allocations_consignmentitemid_foreign` FOREIGN KEY (`consignmentItemId`) REFERENCES `consignment_items` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `supplier_payout_allocations_supplierpayoutid_foreign` FOREIGN KEY (`supplierPayoutId`) REFERENCES `supplier_payouts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `transaction_items`
--
ALTER TABLE `transaction_items`
  ADD CONSTRAINT `transaction_items_productid_foreign` FOREIGN KEY (`productId`) REFERENCES `products` (`id`),
  ADD CONSTRAINT `transaction_items_transactionid_foreign` FOREIGN KEY (`transactionId`) REFERENCES `transactions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `work_logs`
--
ALTER TABLE `work_logs`
  ADD CONSTRAINT `work_logs_approvedby_foreign` FOREIGN KEY (`approvedBy`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `work_logs_userid_foreign` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

