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 `suppliers`
--

CREATE TABLE `suppliers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(255) NOT NULL,
  `ownerName` varchar(255) NOT NULL,
  `businessName` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `description` text DEFAULT NULL,
  `productCategory` varchar(255) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `bankName` varchar(255) DEFAULT NULL,
  `bankAccountNumber` varchar(255) DEFAULT NULL,
  `bankAccountHolderName` varchar(255) DEFAULT NULL,
  `registrationFee` decimal(10,2) NOT NULL DEFAULT 25000.00,
  `registrationPaymentProof` varchar(255) DEFAULT NULL,
  `registrationPaymentStatus` enum('UNPAID','PENDING_VERIFICATION','VERIFIED','REJECTED') NOT NULL DEFAULT 'UNPAID',
  `registrationPaymentVerifiedAt` timestamp NULL DEFAULT NULL,
  `registrationPaymentVerifiedBy` bigint(20) UNSIGNED DEFAULT NULL,
  `monthlyFee` decimal(15,2) NOT NULL DEFAULT 25000.00,
  `preferredPaymentMethod` enum('CASH','TRANSFER','CREDIT') NOT NULL DEFAULT 'TRANSFER',
  `paymentTerms` varchar(255) DEFAULT NULL,
  `isPaymentActive` tinyint(1) NOT NULL DEFAULT 0,
  `paymentStatus` enum('UNPAID','PARTIAL','PAID','PAID_PENDING_APPROVAL','PAID_APPROVED','PAID_REJECTED') NOT NULL DEFAULT 'UNPAID',
  `lastPaymentDate` timestamp NULL DEFAULT NULL,
  `nextPaymentDue` timestamp NULL DEFAULT NULL,
  `paymentGraceDays` int(11) NOT NULL DEFAULT 7,
  `isSuspendedForPayment` tinyint(1) NOT NULL DEFAULT 0,
  `suspendedAt` timestamp NULL DEFAULT NULL,
  `suspensionReason` text DEFAULT NULL,
  `maxActiveProducts` int(11) NOT NULL DEFAULT 10,
  `currentActiveProducts` int(11) NOT NULL DEFAULT 0,
  `status` enum('PENDING','PENDING_REVIEW','APPROVED_PENDING_PAYMENT','PAID_PENDING_APPROVAL','ACTIVE','REJECTED','SUSPENDED') NOT NULL DEFAULT 'PENDING',
  `approvedAt` timestamp NULL DEFAULT NULL,
  `approvedById` bigint(20) UNSIGNED DEFAULT NULL,
  `rejectedReason` text DEFAULT NULL,
  `productQualityScore` tinyint(4) DEFAULT NULL,
  `productPriceScore` tinyint(4) DEFAULT NULL,
  `productPackagingScore` tinyint(4) DEFAULT NULL,
  `productAverageScore` decimal(3,2) DEFAULT NULL,
  `evaluationNotes` text DEFAULT NULL,
  `evaluatedBy` bigint(20) UNSIGNED DEFAULT NULL,
  `evaluatedAt` timestamp NULL DEFAULT NULL,
  `isActive` tinyint(1) NOT NULL DEFAULT 1,
  `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 `suppliers`
--

INSERT INTO `suppliers` (`id`, `code`, `ownerName`, `businessName`, `phone`, `email`, `address`, `description`, `productCategory`, `password`, `bankName`, `bankAccountNumber`, `bankAccountHolderName`, `registrationFee`, `registrationPaymentProof`, `registrationPaymentStatus`, `registrationPaymentVerifiedAt`, `registrationPaymentVerifiedBy`, `monthlyFee`, `preferredPaymentMethod`, `paymentTerms`, `isPaymentActive`, `paymentStatus`, `lastPaymentDate`, `nextPaymentDue`, `paymentGraceDays`, `isSuspendedForPayment`, `suspendedAt`, `suspensionReason`, `maxActiveProducts`, `currentActiveProducts`, `status`, `approvedAt`, `approvedById`, `rejectedReason`, `productQualityScore`, `productPriceScore`, `productPackagingScore`, `productAverageScore`, `evaluationNotes`, `evaluatedBy`, `evaluatedAt`, `isActive`, `note`, `created_at`, `updated_at`) VALUES
(4, 'SUP-20260413-002', 'Aura Nadhiya', 'Cireng rara', '085179871633', 'auranadhiya16@gmail.com', 'jl.Maleo No 22 komplek PEPABRI RT 03/ RW 011 Kab.Bandung', NULL, 'Makanan', '$2y$12$3slOzAMFts0MW3PEK7La2O83DzUpu2EMAXRakFBMKtE5VdKLei5ue', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-13 14:21:02', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 1, 1, 'ACTIVE', '2026-04-13 14:21:02', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-13 14:21:02', '2026-04-29 04:17:46'),
(5, 'SUP-20260413-003', 'Danu', 'Cireng isi', '08879028888', 'Adanugraha4@gmail.com', 'Jl.cipondoh girang RT 5 RW 12 no29 belakang sd sukahati,cinunuk,cileunyi,bandung,jawa barat', NULL, 'Makanan', '$2y$12$CHPQdGY89znpkxSY9Qljf.NDo2CCOUTdnOpnvyzso.0knI4axne8S', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-13 14:23:22', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 1, 1, 'ACTIVE', '2026-04-13 14:23:22', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-13 14:23:23', '2026-04-29 04:17:21'),
(6, 'SUP-20260413-004', 'Ikbal Saputra', 'Dapur umah silahetot', '089656085254', 'Ikbalsaputra439@gmail.com', 'Jl.paledang RT 01 RW 015 ujungberung pasanggrahan', NULL, 'Makanan', '$2y$12$/3TLQLX1nSvEUuYA3oKIMejn/6w9/IIKBpvatFvUrjPbuBO4/22aO', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-13 14:25:03', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 2, 4, 'ACTIVE', '2026-04-13 14:25:03', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-13 14:25:04', '2026-04-29 04:17:13'),
(8, 'SUP-20260413-006', 'Irfan rachmawan', 'RCC', '0882000544809', 'Irfanrachmawan88@gmail.com', 'Kp.Sukamulya RT.02/RW.07 Desa Panenjoan Kecamatan Cicalengka Kabupaten Bandung Jawa Barat', NULL, 'Makanan', '$2y$12$sPy8qvh1ITAGIJueeEyPD.cTrcvuO7OkclFwAyZrHH17qwEpz9DVe', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-13 14:29:30', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 3, 3, 'ACTIVE', '2026-04-13 14:29:30', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-13 14:29:31', '2026-04-29 04:15:36'),
(9, 'SUP-20260413-007', 'Imam nugraha', 'Olahan araci', '08996963349', 'Imamnugrahae2@gmail.com', 'Kp Sukamulya RT 02 RW 07 DS panenjoan Kel panenjoan kec Cicalengka', NULL, 'Makanan', '$2y$12$i5kkzscLezzU4hJe.7/p2uGQ6oSxwG5Yn7awbcuKAsXagaEVzaB3G', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-13 14:31:24', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 2, 2, 'ACTIVE', '2026-04-13 14:31:24', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-13 14:31:24', '2026-04-29 04:15:12'),
(10, 'SUP-20260413-008', 'Nilam meylani', 'Potacio bliss', '088226896445', 'nilammeylln@gmail.com', 'Jl. Melati I RT/RW 002/012 Kel. Cipadung Kidul, Kec. Panyileukan, Kota Bandung', NULL, 'Makanan', '$2y$12$TJ/M7xTUKlHbtn19Q6PwEOKEGylHWEGrUqPN1mWzp4t1G9U14uyNK', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-13 14:33:06', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 1, 1, 'ACTIVE', '2026-04-13 14:33:06', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-13 14:33:07', '2026-04-29 04:14:50'),
(11, 'SUP-20260413-009', 'Zulfah rahil', 'Mochi bunbun', '087802560283', 'rahilzulfah@gmail.com', 'jln banteng kecil no 11A,  kel turangga ,kec lengkong ,kota bandung', NULL, 'Makanan', '$2y$12$.WGJQymfhvtX/bGvqidxGO48PQVFV8pT2rN1ZeYYKs3ibIszMfIUW', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-13 14:34:19', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 1, 1, 'ACTIVE', '2026-04-13 14:34:19', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-13 14:34:19', '2026-04-29 04:14:05'),
(12, 'SUP-20260413-010', 'pangeran', 'Dapur pangeran', '085782058206', 'Hm26061988@gmail.com', 'Jl. Panjunan GG.babakan asih dalam blok tempe \nRT 06 RW 01\nRumah Ibu Nunung Dangdut', NULL, 'Makanan', '$2y$12$xsfGyPeL7WkDqQ2laU7Ek.8m1v/PACISGTTenrQaHoM/kK7Hu3uWm', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-13 14:35:42', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 1, 1, 'ACTIVE', '2026-04-13 14:35:42', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-13 14:35:42', '2026-04-29 04:13:58'),
(14, 'SUP-20260413-012', 'Ririn tri riyanti', 'rinsfood', '081646905730', 'Rinsfood29@gmail.com', 'Griya Cempaka Arum blok J2 no 123 RT 02 RW 04 Kel Rancanumpang Kec Gedebage Bandung 40294', NULL, 'Makanan', '$2y$12$5xElBIzHDEhEzKEMTK/fgOW9gCI0OPpOmdFdnfFzaxR9yesthcKdy', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-13 14:37:51', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 2, 2, 'ACTIVE', '2026-04-13 14:37:51', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-13 14:37:52', '2026-04-29 04:12:25'),
(15, 'SUP-20260413-013', 'Siti saidah', 'omecrispy', '08886241847', 'sitidianrana@gmail.com', 'Jl. Mekar jati RT 4/RW 5, pasir biru kec.cibiru', NULL, 'Makanan', '$2y$12$b4GtCe5i65.9J/CetI746OVzljEVC81VAQCme0cG.UBt5PTcBhCcO', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-13 14:38:40', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 1, 1, 'ACTIVE', '2026-04-13 14:38:40', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-13 14:38:41', '2026-04-29 04:13:36'),
(16, 'SUP-20260413-014', 'Rausyan fikr', 'Namina risol', '087822611696', 'Rausyanfikr09@gmail.com', 'komplek permata biru, blok AH no 226', NULL, 'Makanan', '$2y$12$ujUG6Qs6RJoXRQP0Dnvdh.PXJariQL2OYU.blDLna3vOM9eNzf3uC', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-13 14:39:42', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 1, 1, 'ACTIVE', '2026-04-13 14:39:42', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-13 14:39:43', '2026-04-29 04:13:29'),
(17, 'SUP-20260414-001', 'Trisanian Nurul Janah', 'Dine_bite pangsit wonton', '0895327442695', 'Trisania145@gmail.com', 'Jl. Makam Caringin No. 106 RT 08 RW 02, Kec. Babakan Ciparay, Kel. Margahayu Utara, Kota Bandung, Jawa Barat, 40224', NULL, 'Makanan', '$2y$12$FHKZhk/Xq55E9IiincTxL.RzEj/1XqTTohIYxBmyZnpllVZKg2qhu', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-14 01:43:58', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 2, 2, 'ACTIVE', '2026-04-14 01:43:58', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-14 01:43:58', '2026-04-29 04:17:39'),
(18, 'SUP-20260414-002', 'Raka Tasadila', 'D’risolles', '081228438392', 'Rakatasadila02@gmail.com', 'Jl. Pandanwangi gang H. Iyo No.52, Cibiru Wetan, Kec. Cileunyi, Kabupaten Bandung, Jawa Barat 40625', NULL, 'Makanan', '$2y$12$HCIE6eYpqfPDKXwgb8rAw.z7XzeWaJmJXsr1wfXoyc409adTvFFkW', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-14 01:45:24', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 1, 1, 'ACTIVE', '2026-04-14 01:45:24', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-14 01:45:24', '2026-04-29 04:16:02'),
(19, 'SUP-20260414-003', 'Haryy Santana', 'Prita snack', '081320207164', 'okharrysantanapr@gmail.com', 'Komplek manglayangsari RT 004 RW 013 kel. Palasari, Kec.Cibiru, kota Bandung 40615', NULL, 'Makanan', '$2y$12$CIJ3nmWB3nnZdUL1XrEnZuUUacxG2O36fVkJx5iKd4qfwZfBfPDFW', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-14 01:46:42', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 2, 2, 'ACTIVE', '2026-04-14 01:46:42', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-14 01:46:42', '2026-04-29 04:15:54'),
(20, 'SUP-20260414-004', 'Nada salma s', 'Karoket ayam', '085710249203', 'Nadasalsal02@gmail.com', 'Jl. Stasiun No 8 Rt3/Rw6 Rancaekek Wetan, Kab.Bandung', NULL, 'Makanan', '$2y$12$Z/xq80ajRGvEUE1j3ry39OXgY49IcW6COihFZ3mHiF8ATr85DPUgm', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-14 01:47:54', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 1, 1, 'ACTIVE', '2026-04-14 01:47:54', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-14 01:47:55', '2026-04-28 06:38:58'),
(21, 'SUP-20260414-005', 'rikki', 'Gorengan ceria', '081321039709', 'Rikkiyusup@gmail.com', 'jl. atletik IV No. 31 Arcamanik Bandung 40293', NULL, 'Makanan', '$2y$12$70gqg9B/7LgbHMBYOLGBY.KujmZS5c7Tboo5/maxjXlLGfTgwmCk.', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-14 01:48:54', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 2, 1, 'ACTIVE', '2026-04-14 01:48:54', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-14 01:48:54', '2026-04-29 04:14:42'),
(22, 'SUP-20260414-006', 'Muhammad fikri', 'gorengan', '085156607817', 'Mfikrimaulana18@gmail.com', 'Kp.sukamulya desa.panenjoan kec.cicalengka kab.bandung', NULL, 'Makanan', '$2y$12$o6DR0qrFfxjThmmqkf9sIuum2m8WKWKnQCSEgmSWwJqjvwtpfvQQe', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-14 01:49:55', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 2, 2, 'ACTIVE', '2026-04-14 01:49:55', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-14 01:49:55', '2026-04-29 04:14:34'),
(23, 'SUP-20260414-007', 'Fachry muhammad', 'cesefood', '082318946343', 'Fachrymuhammad827@gmail.com', 'Provinsi Jawa Barat,kabupaten Sumedang,kecamatan cimanggung,dusun pedes,RT/RW 003/006', NULL, 'Makanan', '$2y$12$HGgoe75gDIT2HGqtS9/DDuW6KML/kIKl01oJ87Wov1VY5zm5G2qli', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-14 01:51:17', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 1, 1, 'ACTIVE', '2026-04-14 01:51:17', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-14 01:51:17', '2026-04-29 04:13:48'),
(24, 'SUP-20260414-008', 'Tati hartati', 'Mahira waffle', '081573334482', 'Mrs.hartatitati77@gmail.com', 'Komp.permata biru blok  F no.5', NULL, 'Makanan', '$2y$12$GWvrIg07HlN/RHpdxiTymOllutzXMk0tRbO9P6M4cZee7nkFTNjQq', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-14 01:52:53', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 1, 1, 'ACTIVE', '2026-04-14 01:52:53', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-14 01:52:54', '2026-04-29 04:13:22'),
(25, 'SUP-20260414-009', 'Rahma budi', 'Nasi cokot by amaa', '085860795346', 'robanibudirahma@gmail.com', 'Puteraco gading permai a4 no 1 Cangkuang Rancaekek', NULL, 'Makanan', '$2y$12$LocUXs0gF2bl967grBaEa.arsfJjupBn/TJZijjTsXA2vO.wyb7mW', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-14 01:54:00', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 2, 1, 'ACTIVE', '2026-04-14 01:54:00', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-14 01:54:01', '2026-04-29 04:13:15'),
(26, 'SUP-20260414-010', 'Roni Rahayu', 'Grilled rice micel', '089519011729', 'Ronirahayu55@gmail.com', 'Jalan Cipasir Gang Pancasila, RT.3/RW.9, Desa Linggar, Rancaekek (Warung mang adang), KAB. BANDUNG, RANCAEKEK, JAWA BARAT, ID, 40394', NULL, 'Makanan', '$2y$12$2l4XQbrCuhya/C9NR/NYXe/vwtT2nOcNp60uGclA4M/8YKo8.WGni', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-14 02:02:27', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 1, 1, 'ACTIVE', '2026-04-14 02:02:27', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-14 02:02:28', '2026-04-29 04:14:18'),
(27, 'SUP-20260414-011', 'herti aprianti', 'Yakult', '0895358173700', 'hertiapriantii@gmail.com', 'jln cirengot gg sukamulya', NULL, 'Minuman', '$2y$12$jV.Eo2CaH9iMXnKBRrf2remSCKakWThaseffNcaej7fDzu11J/ynu', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-14 02:21:08', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 50, 3, 'ACTIVE', '2026-04-14 02:21:08', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-14 02:21:08', '2026-04-29 04:12:03'),
(28, 'SUP-20260424-001', 'citra', 'seungah.id', '081559796112', 'citrarosida06@gmail.com', 'RT 03 RW 12 kampung liowarungguede desa cibiru wetan kec cileunyi', NULL, 'Makanan', '$2y$12$nod/wG75yCdpr3h0KGWSz.0weeJvu9dEj2RN1ApPDx1M5GiNYH29y', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-24 04:26:20', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 4, 4, 'ACTIVE', '2026-04-24 04:26:20', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-24 04:26:20', '2026-04-29 03:06:04'),
(29, 'SUP-20260424-002', 'ajeng ummu kulsum', 'dapoer ahh', '081772895559', 'ajeng121095@gmail.com', 'jl babakan irigasi remaja 7 RT 03 RW 07 kel.babakan tarogong kec.bojongloa kaler kota bandung kode pos 40232', NULL, 'Makanan', '$2y$12$0J2krGE0tUDrAkKtzhaWleQB.D1JnNJBYBhFs/Fbb87xdF5YYqp.6', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-24 04:30:00', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 3, 3, 'ACTIVE', '2026-04-24 04:30:00', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-24 04:30:00', '2026-04-29 04:16:33'),
(30, 'SUP-20260424-003', 'irfan', 'cemilan', '081395729172', 'ifanrife@yahoo.id', 'jl.jatinangor sumedang', NULL, 'Snack', '$2y$12$i5wcOSrvn1Ar/6fd6r5DO.QKuT.KUCgHkxoXgPYe/gVkOy5UjLs2u', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-24 04:34:26', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 5, 1, 'ACTIVE', '2026-04-24 04:34:26', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-24 04:34:26', '2026-04-29 04:13:07'),
(31, 'SUP-20260424-004', 'lia yulianti', 'snack kering', '085236925197', 'liayulianti313354@gmail.com', 'komplel pasir pogor blok RK no9', NULL, NULL, '$2y$12$wTLxaYEtXwmj/baD9/7E7uc6xo3fYb/8XECQDP4/a/bdpBKnK3pOy', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-24 04:37:41', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 4, 1, 'ACTIVE', '2026-04-24 04:37:41', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-24 04:37:41', '2026-04-29 04:12:57'),
(32, 'SUP-20260424-005', 'zaky', '3 jiwa', '085320406502', 'ilhamzaky2301@gmail.com', 'komplek al awwabin jl walini kec.rancaekek kab bandung', NULL, 'Snack', '$2y$12$B6shwYWHOKWwqdS7Pp61Zu7ngtkaIKnuW8nR2uXoTcKj1oL.sDRsW', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-24 04:39:47', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 2, 1, 'ACTIVE', '2026-04-24 04:39:47', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-24 04:39:47', '2026-04-29 04:12:50'),
(33, 'SUP-20260424-006', 'agus', 'coca cola', '082118233052', 'anggiagustiana92@gmail.com', 'jl rumah sakit no 131', NULL, 'Minuman', '$2y$12$Ux/9GQhAg2Hc5Zbeq1cRfeDOn2zt9Y.CmdIrdaoeHvHRMnxUAksC.', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-24 04:41:42', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 5, 3, 'ACTIVE', '2026-04-24 04:41:42', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-24 04:41:42', '2026-04-29 04:12:42'),
(34, 'SUP-20260424-007', 'rafa putra', 'kerupuk', '085703394562', 'rafaputraa200@gmail.com', 'cibiru hilir 01/03 cileunyi bandung', NULL, 'Snack', '$2y$12$3I79FSYsy92xGQ1jMtfbYeqJ8uCBlyuDUX5qKcwrm6M5YOlsqQQB2', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-24 04:46:21', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 5, 1, 'ACTIVE', '2026-04-24 04:46:21', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-24 04:46:21', '2026-04-29 03:07:43'),
(35, 'SUP-20260424-008', 'sidik sudirman', 'makanan ringan', '0881022415245', 'sudirmansidik67@gmail.com', 'kp. sangkan kec,samarang garut', NULL, NULL, '$2y$12$yuCgo3loBOcfaztjzl53Heuk66C4KCUdRPK9H47lhSToCvMARfwbS', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-24 04:48:25', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 2, 0, 'ACTIVE', '2026-04-24 04:48:25', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-24 04:48:25', '2026-04-24 04:48:25'),
(36, 'SUP-20260424-009', 'putri ananda', 'putri', '08138143951', 'nurrohmanputriananda@gmail.com', 'komplek bumi panyileukan', NULL, 'Snack', '$2y$12$Zb.kCOEM9xNG9jkOEDUHa.C80BQNN8UVmdHSlpKTkk1M68zKd7uuu', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-24 04:50:15', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 2, 1, 'ACTIVE', '2026-04-24 04:50:15', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-24 04:50:16', '2026-04-29 03:07:32'),
(37, 'SUP-20260424-010', 'yulia', 'umkm', '081221045443', 'yulianurannisa@gmail.com', 'cikajang garut', NULL, 'Snack', '$2y$12$ksh7wdgtH4yu/iIbbLq1E.PylwfNPM2lXKyxF.VcGWTEyAEDOw/x6', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-24 04:51:27', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 4, 1, 'ACTIVE', '2026-04-24 04:51:27', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-24 04:51:27', '2026-04-29 03:07:23'),
(38, 'SUP-20260424-011', 'dian mardiana daud', 'pikdas ma acah', '08996831731', 'dianmardianad17@gmail.com', 'kp.girimulya no56 RT 01/01 desa karyawangi kec parongpong kab.bandung barat', NULL, 'Snack', '$2y$12$Cm0BTV1yQwGV6jeENPeP9.iU7xlCuINDfGl.cuLizAFpAcgQakrDC', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-24 04:53:42', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 2, 1, 'ACTIVE', '2026-04-24 04:53:42', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-24 04:53:43', '2026-04-29 03:07:13'),
(39, 'SUP-20260424-012', 'nabila rianti', 'PIC sari roti', '081133342938', 'nabilagraninta@yahoo.com', 'jl. soekarno hatta no447', NULL, 'Makanan', '$2y$12$0iVHp7WJMJXkK7g4WGUyw.19RP4CfhYCFVaJh0wn8vsfa/X7yexke', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-24 04:55:25', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 50, 0, 'ACTIVE', '2026-04-24 04:55:25', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-24 04:55:25', '2026-04-24 04:55:25'),
(40, 'SUP-20260428-001', 'H. Evan agustianto', 'PT. Muawanah Al ma\'soem', '08112141227', 'marketingamdkalmasoem@gmail.com', 'Jl.raya cikalang no.168, cimekar,kec.cileunyi kab.bandung.jawa barat 40393', NULL, 'Minuman', '$2y$12$9kS7dRE3Bf6zaK4sYdPTLO1YBqLtzPQZ4nAM41axG3AKrKj9rsy.G', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-28 01:08:34', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 2, 1, 'ACTIVE', '2026-04-28 01:08:34', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-28 01:08:35', '2026-04-29 03:06:24'),
(41, 'SUP-20260428-002', 'Mochandryr', 'Customer produk ', '082320711614', 'jajang@gmail.com', 'Jl.cipadung no 32 Bandung', NULL, 'Minuman', '$2y$12$.OTbWPUZtXz4s8epFm4xYOy7q7WRNi52QK0w.9GlODMA9tutAqRLK', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-28 01:11:08', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 10, 2, 'ACTIVE', '2026-04-28 01:11:08', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-28 01:11:08', '2026-04-29 03:05:29'),
(42, 'SUP-20260428-003', 'Rendy mayora', 'Mayora', '087729290303', 'Cnsgbg.bom@ptcns.co.id', 'Jl.soekarno Hatta no845', NULL, 'Minuman', '$2y$12$JwAz8F4RVMZOllsB91zweu/NLRZU6NmCiopbeeaWEoQ2eoPBH7DKi', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-28 01:12:23', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 10, 5, 'ACTIVE', '2026-04-28 01:12:23', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-28 01:12:23', '2026-04-29 03:05:08'),
(43, 'SUP-20260428-004', ' Aries ramdan', 'Kuliner', '085220448666', 'Ariesborisqumaira@gmail.com', 'Komplek griya bandung indah blok G 15 no 13', NULL, 'Snack', '$2y$12$oea1JaqdHUd8SeEMTYgaO.oUTklvrsBxgXpM88aGzLqoWdWACmhfS', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-28 01:14:13', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 3, 1, 'ACTIVE', '2026-04-28 01:14:13', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-28 01:14:14', '2026-04-29 03:06:13'),
(44, 'SUP-20260428-005', 'Makmuri', 'Kedai oishii', '081322630527', 'muray.klanis76@gmail.com', 'Bumi harapan blok cc9 no 41 rt 03 rw 11 Cibiru Cileunyi kab bandung 40626', NULL, 'Makanan', '$2y$12$fUflgJLa.FFWyaEiKtfZK.8bTDWDjQgEcf3fUVraxcLcmtKnicwBC', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-28 11:32:02', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 3, 1, 'ACTIVE', '2026-04-28 11:32:02', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-28 11:32:02', '2026-04-29 02:59:03'),
(45, 'SUP-20260428-006', 'PT Yamazaki Indonesia ', 'Distribution and retail ', '081132214819', 'Sisma.darajattiani@yamazakimyroti.co.id', 'Jl. Raya Bandung -garut km 20.9 no 89', NULL, 'Makanan', '$2y$12$L/yuyL1X/vfpAsgpYaOhMeHKkzt2w.DPw1lwpv72UQI8rFCTNKdUy', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-28 11:44:57', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 50, 0, 'ACTIVE', '2026-04-28 11:44:57', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-28 11:44:57', '2026-04-28 11:44:57'),
(46, 'SUP-20260430-001', 'Siti khabibah', 'Cemilan mbak siti', '082121009837', 'sitikosmetik5@gmail.com', 'jln.sumbersari RT/RW:03/08 , desa Cisaranten kulon, kecamatan Arcamanik kota bandung ', NULL, 'Snack', '$2y$12$bWqRLYTpQ8aeVLYzpAXlLuviWTxexioReQ63CCMftd55XIGNP/zIe', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-04-30 05:40:55', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 2, 5, 'ACTIVE', '2026-04-30 05:40:55', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-04-30 05:40:55', '2026-04-30 05:46:18'),
(47, 'SUP-20260501-001', 'Mila diinilhaque Al khasa', 'Aneka cookies ', '08972509549', 'milalkansa76@gmail.com', 'Jl.bojong pulus rt4 rw7 desa Bojong loa Rancaekek ', NULL, 'Snack', '$2y$12$ZgXHG5j18OMrKqhE6Y0F1.jRlLWI.132GoJLVUf9GGeVe2AfSn8Tq', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-05-01 06:32:23', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 5, 4, 'ACTIVE', '2026-05-01 06:32:23', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-05-01 06:32:24', '2026-05-04 05:06:48'),
(48, 'SUP-20260501-002', 'Ridwan', 'Baso cilok kalcer', '085759175013', 'Ridwansahid1111@gmail.com', 'jl. Kopo bihbul No 17 gg, aki.H.sanusi', NULL, 'Snack', '$2y$12$DMZOh1MXQFImkSvk.SRD8.Yq8u8w3V9E3Mf27usEDsLQpzQnMIoQm', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-05-01 06:35:06', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 2, 1, 'ACTIVE', '2026-05-01 06:35:06', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-05-01 06:35:06', '2026-05-04 05:06:54'),
(49, 'SUP-20260518-001', 'japlun yadi', 'puja cireng', '087764332997', 'japlunyadi@gmail.com', 'paledang rt02 rw15 pasanggrahan', NULL, 'Snack', '$2y$12$v6Lv8YtBRtLo6IeDCRhBCOX9.ijC1uWw8Ml8YgLjLLVjaBnByP78C', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-05-18 01:35:06', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 3, 1, 'ACTIVE', '2026-05-18 01:35:06', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-05-18 01:35:06', '2026-05-21 09:07:18'),
(50, 'SUP-20260518-002', 'Robbi Alloh', 'roti puncak rasa', '082119673837', 'rotibandung11subang@gmail.com', 'UIN 1 Cipadung Bandung', NULL, 'Snack', '$2y$12$2TR9jHio4x.kKAdFxga6P.P60FkNYkGD.MNgzP11wfo/fRGAtDgRO', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-05-18 01:36:46', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 4, 2, 'ACTIVE', '2026-05-18 01:36:46', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-05-18 01:36:46', '2026-05-21 09:07:31'),
(51, 'SUP-20260521-001', 'PT. Artaboga cemerlang', 'supplier minuman', '0895327905118', 'ded7ps@gmail.com', 'Jl. Soekarno-Hatta No.709, Jatisari, RT.RW, ec, Kec. Buahbatu, Kota Bandung, Jawa Barat 40255', NULL, NULL, '$2y$12$Jxdoc4Z3s68E1faoguO0LOv8WyCRDkCbJ8KcPiEntPMRWMaB06aMK', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-05-21 08:54:51', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 10, 6, 'ACTIVE', '2026-05-21 08:54:51', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-05-21 08:54:51', '2026-05-21 09:08:07'),
(52, 'SUP-20260521-002', 'annisa', 'spinacia chips', '081320369615', 'spinaciachips@gmail.com', 'baleendah, Kab. Bandung', NULL, NULL, '$2y$12$/kvUQH85leUXoc4nnlVamuhpEydAO4esxctA9FF6V6sg2J/8w5Phm', NULL, NULL, NULL, 0.00, NULL, 'VERIFIED', '2026-05-21 08:56:13', 1032, 25000.00, 'TRANSFER', NULL, 1, 'UNPAID', NULL, NULL, 7, 0, NULL, NULL, 2, 2, 'ACTIVE', '2026-05-21 08:56:13', 1032, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2026-05-21 08:56:14', '2026-05-21 09:08:23');

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

--
-- 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 `transactions`
--

CREATE TABLE `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoiceNumber` varchar(255) NOT NULL,
  `checkoutToken` varchar(64) DEFAULT NULL,
  `memberId` bigint(20) UNSIGNED DEFAULT NULL,
  `userId` bigint(20) UNSIGNED DEFAULT NULL,
  `cashierShiftId` bigint(20) UNSIGNED DEFAULT NULL,
  `type` enum('SALE','PURCHASE','RETURN','INCOME','EXPENSE') NOT NULL,
  `totalAmount` decimal(15,2) NOT NULL,
  `paymentMethod` enum('CASH','TRANSFER','CREDIT','SUKARELA') NOT NULL DEFAULT 'CASH',
  `status` enum('PENDING','COMPLETED','CANCELLED') NOT NULL DEFAULT 'COMPLETED',
  `note` text DEFAULT NULL,
  `date` 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;

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

--
-- 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 `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `role` enum('SUPER_ADMIN','ADMIN','KASIR','SUPPLIER','USER','DEVELOPER','MEMBER') NOT NULL DEFAULT 'USER',
  `isActive` tinyint(1) NOT NULL DEFAULT 1,
  `lastLoginAt` timestamp NULL DEFAULT NULL,
  `mustChangePassword` tinyint(1) NOT NULL DEFAULT 1,
  `passwordChangedAt` timestamp NULL DEFAULT NULL,
  `remember_token` varchar(100) 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 `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `isActive`, `lastLoginAt`, `mustChangePassword`, `passwordChangedAt`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', 'superadmin@test.com', NULL, '$2y$12$77QmfXlEH/GkMH5Q03ZvguxkAb9VEcv3cOGlXfj2rqHEFGBDGHLom', 'SUPER_ADMIN', 1, '2026-01-12 14:52:42', 1, NULL, NULL, '2025-11-29 04:58:15', '2026-01-12 14:52:42'),
(2, 'Admin', 'admin@test.com', NULL, '$2y$12$Ni9RSTBfBCd1Q15Ig68fLuZJc8uNO6kyO203cXq5zxlcPK6UtoNS.', 'ADMIN', 1, '2026-04-29 04:08:31', 1, NULL, NULL, '2025-11-29 04:58:15', '2026-04-29 04:08:31'),
(3, 'Kasir', 'kasir@test.com', NULL, '$2y$12$bxeCKYt1Ud8pW3AXQKBqEePyEvI9Zg8JDXWmjdd1sbj7L./kIC.t6', 'KASIR', 1, '2026-04-17 10:54:31', 1, NULL, NULL, '2025-11-29 04:58:15', '2026-04-17 10:54:31'),
(4, 'Developer', 'developer@test.com', NULL, '$2y$12$xWOWDJf/8Ertdkj20eBWDuEBuYBfaDeAo1BOsW6B4IfJvYKBJZ6SS', 'DEVELOPER', 1, '2026-01-12 14:53:04', 1, NULL, NULL, '2025-11-29 04:58:15', '2026-01-12 14:53:04'),
(7, 'Ridlo Abdillah', 'ridloabdillah@bermadaniumbandung.id', NULL, '$2y$12$DDS.NF3bYsXtx7oO8UswqOMnrItreGQxiMao/nTHQr0HIpLf8on76', 'SUPER_ADMIN', 1, '2026-06-17 04:21:33', 1, NULL, NULL, '2025-11-29 23:43:11', '2026-06-17 04:21:33'),
(8, 'Developer', 'bermadani@dev.com', NULL, '$2y$12$kVW8NJUX6EW2ZVgzDPYususPd6CUK6PEEa/rnuB29TxQoGDOByYlW', 'DEVELOPER', 1, '2026-07-10 10:58:39', 1, NULL, NULL, '2025-11-29 23:43:11', '2026-07-10 10:58:39'),
(10, 'Muhammad Alwi Almaliki', 'Alwie268@gmail.com', NULL, '$2y$12$jgZ97dE0XU5vsrFYjDrYZ.bNebnIdKTCk6mGkb5Gv6hm1YedQjRY6', 'ADMIN', 1, '2026-03-08 14:12:09', 1, NULL, NULL, '2025-12-01 07:19:23', '2026-03-08 14:12:09'),
(12, 'Admin Koperasi', 'admin@koperasi.com', NULL, '$2y$12$/z5ZKOIMuDMgGA88JDflROq6ZAhvqrqRdHbLF7noYR14QYbvTQXOy', 'ADMIN', 1, '2026-02-01 13:18:51', 1, NULL, NULL, '2025-12-08 10:47:33', '2026-02-01 13:18:51'),
(13, 'Super Admin', 'superadmin@koperasi.com', NULL, '$2y$12$EuHmRy5XF3F03s72B399NeNMjoXFTMJ9hOArwWVb.pMIsOdkUBl9m', 'SUPER_ADMIN', 1, NULL, 1, NULL, NULL, '2025-12-08 10:47:33', '2025-12-08 10:47:33'),
(880, 'ACEP MUHAROM T SYAMSUDIN', '21000001@bermadani.id', NULL, '$2y$12$nE49JBxLGwQ.rSFrcfFv..5C61E9QVkGvspplJ/ENXJuFqQc0DX7.', 'MEMBER', 1, '2026-02-05 14:11:48', 1, NULL, NULL, '2025-12-13 07:57:05', '2026-02-05 14:11:48'),
(881, 'IA KURNIA', '21000002@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:05', '2026-01-06 10:57:22'),
(882, 'IVONNE AYESHA', '21000003@bermadani.id', NULL, '$2y$12$VFrV6arp3xP8CRUfAkBkmuIegJ5uQ1tXpE.bValN4H1/I/CKgDs6S', 'MEMBER', 1, '2026-02-05 14:13:02', 1, NULL, NULL, '2025-12-13 07:57:06', '2026-02-05 14:13:02'),
(883, 'MOCHAMAD NAFILA DZKWAN MUQAFILLAH', '21000004@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:06', '2026-01-06 10:57:22'),
(884, 'MOHAMAD HILAL NUMAN', '21000005@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:06', '2026-01-06 10:57:22'),
(885, 'NENNY KENCANAWATI', '21000006@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:07', '2026-01-06 10:57:22'),
(886, 'SETIADIN', '21000007@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:07', '2026-01-06 10:57:22'),
(887, 'YUDI HARYADI', '21000008@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:07', '2026-01-06 10:57:22'),
(888, 'SUGIARTININGSIH', '21000009@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:08', '2026-01-06 10:57:22'),
(889, 'WASIFAH HANIM', '21000010@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:08', '2026-01-06 10:57:22'),
(890, 'DWI MUKTI WIBOWO', '21000011@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:08', '2026-01-06 10:57:22'),
(891, 'NURLAELA HAMIDAH', '21000012@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:08', '2026-01-06 10:57:22'),
(892, 'INDRA SASANGKA', '21000013@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:09', '2026-01-06 10:57:22'),
(893, 'ANANG SURYANA', '21000014@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:09', '2026-01-06 10:57:22'),
(894, 'ROCHMAN ADIMIHARJA', '21000015@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:09', '2026-01-06 10:57:22'),
(895, 'YADI KOSWARA', '21000016@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:10', '2026-01-06 10:57:22'),
(896, 'AGUS ANDRIYANA', '21000017@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:10', '2026-01-06 10:57:22'),
(897, 'DEDEN', '21000018@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:10', '2026-01-06 10:57:22'),
(898, 'RIDLO ABDILLAH', '21000019@bermadani.id', NULL, '$2y$12$8f5vrUCQFLlIMb.RyEhR0ubRIsK2O4gUETUXZUCMnVltXFwINygS2', 'MEMBER', 1, '2026-02-01 14:11:44', 1, NULL, NULL, '2025-12-13 07:57:11', '2026-02-01 14:11:44'),
(899, 'YUSUP SOPYAN', '21000020@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:11', '2026-01-06 10:57:22'),
(900, 'IMAM NUGRAHA', '21000021@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:11', '2026-01-06 10:57:22'),
(901, 'DEA SITI NURAENI', '21000022@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:11', '2026-01-06 10:57:22'),
(902, 'ACE SOMANTRI', '21000023@bermadani.id', NULL, '$2y$12$GoYeV.hPCFP2VZYcSD3DrO2FX3HT73r6V3qu4Ezxji.c0Z0LY2sk2', 'MEMBER', 1, '2026-02-28 06:37:42', 1, NULL, NULL, '2025-12-13 07:57:12', '2026-02-28 06:37:42'),
(903, 'AGUS IRMAYANTO', '21000024@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:12', '2026-01-06 10:57:22'),
(904, 'RIVAI WIRASURYA', '21000025@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:12', '2026-01-06 10:57:22'),
(905, 'SRI KURNIA FEBRIYANTI', '21000026@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:13', '2026-01-06 10:57:22'),
(906, 'ABIN SUARSA', '21000027@bermadani.id', NULL, '$2y$12$TqMcorEcQf4YTdYOi6kLz.o5ZBo.Y/JW/c28Lp0m98OfUca1Zo.p6', 'MEMBER', 1, '2026-03-22 10:22:23', 1, NULL, NULL, '2025-12-13 07:57:13', '2026-03-22 10:22:23'),
(907, 'RIKKI MAULANA YUSUP', '21000028@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:13', '2026-01-06 10:57:22'),
(908, 'KARSAM', '22000001@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:14', '2026-01-06 10:57:22'),
(909, 'MELA MEIDA S', '22000002@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:14', '2026-01-06 10:57:22'),
(910, 'MUHTADIN', '22000003@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:14', '2026-01-06 10:57:22'),
(911, 'AHMAD DIPONEGORO', '22000004@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:14', '2026-01-06 10:57:22'),
(912, 'HENDAR RIYADI', '22000005@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:15', '2026-01-06 10:57:22'),
(913, 'HERRY SUHARDIYANTO', '22000006@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:15', '2026-01-06 10:57:22'),
(914, 'AGUS SANDI PAMUNGKAS', '22000007@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:15', '2026-01-06 10:57:22'),
(915, 'HENDRA MAULANA', '22000008@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:16', '2026-01-06 10:57:22'),
(916, 'ASEP INDRA SUGIRI', '22000009@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:16', '2026-01-06 10:57:22'),
(917, 'ALDI WALUYA PUTRA', '23000001@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:16', '2026-01-06 10:57:22'),
(918, 'ARLY YANUAR AKBAR', '23000002@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:17', '2026-01-06 10:57:22'),
(919, 'DENI SAEPUL', '23000003@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:17', '2026-01-06 10:57:22'),
(920, 'MUTIARA HAYANDANI', '23000004@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:17', '2026-01-06 10:57:22'),
(921, 'RHIZA VILANI', '23000005@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:17', '2026-01-06 10:57:22'),
(922, 'YUTI YUNIARTI', '23000006@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:18', '2026-01-06 10:57:22'),
(923, 'IIP SYARIP HIDAYATULLOH', '23000007@bermadani.id', NULL, '$2y$12$NIgv5BoaeuS21NHsY5aZDennPT6lQ0ei22uNGXuTBxfEliUjOhX8G', 'MEMBER', 1, '2026-01-29 13:21:43', 1, NULL, NULL, '2025-12-13 07:57:18', '2026-01-29 13:21:43'),
(924, 'RAMADITYA RAHARDIAN', '23000008@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:18', '2026-01-06 10:57:22'),
(925, 'YAYAN HERYAWAN', '23000009@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:19', '2026-01-06 10:57:22'),
(926, 'ADI ROSADI', '23000010@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:19', '2026-01-06 10:57:22'),
(927, 'SITI KODARIAH', '23000011@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:19', '2026-01-06 10:57:22'),
(928, 'SUPARJIMAN', '23000012@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:19', '2026-01-06 10:57:22'),
(929, 'SARIPUDIN', '23000013@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:20', '2026-01-06 10:57:22'),
(930, 'FEMI FAUZIAH', '23000014@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:20', '2026-01-06 10:57:22'),
(931, 'METI MEDIYASTUTI SOFYAN', '23000015@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:20', '2026-01-06 10:57:22'),
(932, 'RIZAN FEBRIAN', '23000016@bermadani.id', NULL, '$2y$12$/Olax5jlH7kg1xZ1einOOefSdw/X6bQofnS6ltLJDjlc4vrUdVodO', 'MEMBER', 1, '2026-02-05 16:02:15', 1, NULL, NULL, '2025-12-13 07:57:21', '2026-02-05 16:02:15'),
(933, 'BUDI SADARMAN', '24000001@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:21', '2026-01-06 10:57:22'),
(934, 'HILMAN DJUWAENI', '24000002@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:21', '2026-01-06 10:57:22'),
(935, 'SITI SINTA SINTIA', '24000003@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:22', '2026-01-06 10:57:22'),
(936, 'ENI KUSUMAWATI', '24000004@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:22', '2026-01-06 10:57:22'),
(937, 'MUHAMMAD DINAR ABDUL MALIK', '24000005@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:22', '2026-01-06 10:57:22'),
(938, 'WIDHI NETRANING PERTIWI', '24000006@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:22', '2026-01-06 10:57:22'),
(939, 'AFIF MUHAMMAD', '24000007@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:23', '2026-01-06 10:57:22'),
(940, 'ARIF NURRAKHMAN', '24000008@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:23', '2026-01-06 10:57:22'),
(941, 'AZHAR MUHAMMAD AKBAR', '24000009@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:23', '2026-01-06 10:57:22'),
(942, 'CECEP TAUFIKURROHMAN', '24000010@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:23', '2026-01-06 10:57:22'),
(943, 'DADANG MULYANA', '24000011@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:24', '2026-01-06 10:57:22'),
(944, 'DEDEN ABDUL WAHID', '24000012@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:24', '2026-01-06 10:57:22'),
(945, 'DIAN KUSUMAWATI', '24000013@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:24', '2026-01-06 10:57:22'),
(946, 'DIANA FARID', '24000014@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:25', '2026-01-06 10:57:22'),
(947, 'DITA HANDAYANI', '24000015@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:25', '2026-01-06 10:57:22'),
(948, 'ESTY FAATINISA', '24000016@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:25', '2026-01-06 10:57:22'),
(949, 'FIKFIK TAUFIK', '24000017@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:25', '2026-01-06 10:57:22'),
(950, 'HENI MULYASARI', '24000018@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:26', '2026-01-06 10:57:22'),
(951, 'HERNAWATI', '24000019@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:26', '2026-01-06 10:57:22'),
(952, 'IIM IBROHIM', '24000020@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:26', '2026-01-06 10:57:22'),
(953, 'IMAS KURNIASIH', '24000021@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:26', '2026-01-06 10:57:22'),
(954, 'INDRA BUDI JAYA', '24000022@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:27', '2026-01-06 10:57:22'),
(955, 'IRAWATI', '24000023@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:27', '2026-01-06 10:57:22'),
(956, 'ISYA SITI AISYATUL MBZ', '24000024@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:27', '2026-01-06 10:57:22'),
(957, 'KELIK NURSETIYO WIDIYANTO', '24000025@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:28', '2026-01-06 10:57:22'),
(958, 'LILIS LISMARINA', '24000026@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:28', '2026-01-06 10:57:22'),
(959, 'LINA MARLINA SUSANA', '24000027@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:28', '2026-01-06 10:57:22'),
(960, 'MIFTAHUL HUDA', '24000028@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:28', '2026-01-06 10:57:22'),
(961, 'MOCHAMAD FADLANI SALAM', '24000029@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:29', '2026-01-06 10:57:22'),
(962, 'MOCHAMAD FAIZAL ALMAUDUDI AZIZ DACHLAN', '24000030@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:29', '2026-01-06 10:57:22'),
(963, 'MOHAMMAD FAHMI AMRULLAH', '24000031@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:29', '2026-01-06 10:57:22'),
(964, 'MOLLY MUSTIKASARI', '24000032@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:30', '2026-01-06 10:57:22'),
(965, 'MUHAMMAD HUSNI ABDULAH PAKARTI', '24000033@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:30', '2026-01-06 10:57:22'),
(966, 'MUKHLISHAH', '24000034@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:30', '2026-01-06 10:57:22'),
(967, 'NUR ALIM', '24000035@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:30', '2026-01-06 10:57:22'),
(968, 'RAHMAT ALAMSYAH', '24000036@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:31', '2026-01-06 10:57:22'),
(969, 'RAHMAT FADHLI', '24000037@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:31', '2026-01-06 10:57:22'),
(970, 'RIFKY MUHAMMAD IHSAN', '24000038@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:31', '2026-01-06 10:57:22'),
(971, 'RIZKA SAPUTRI', '24000039@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:32', '2026-01-06 10:57:22'),
(972, 'SITI MARLINDA', '24000040@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:32', '2026-01-06 10:57:22'),
(973, 'SITTI CHADIDJAH', '24000041@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:32', '2026-01-06 10:57:22'),
(974, 'SOPAAT RAHMAT SELAMET', '24000042@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:32', '2026-01-06 10:57:22'),
(975, 'SOPHA HAFITRIANI', '24000043@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:33', '2026-01-06 10:57:22'),
(976, 'SUPALA', '24000044@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:33', '2026-01-06 10:57:22'),
(977, 'SYARIF SYAHIDIN', '24000045@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:33', '2026-01-06 10:57:22'),
(978, 'TATY SETIATY', '24000046@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:33', '2026-01-06 10:57:22'),
(979, 'TAUFIK MAULANA', '24000047@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:34', '2026-01-06 10:57:22'),
(980, 'YENNY YUANITA', '24000048@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:34', '2026-01-06 10:57:22'),
(981, 'YUDI DARYADI', '24000049@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:34', '2026-01-06 10:57:22'),
(982, 'YUDISTIA TEGUH ALI FIKRI', '24000050@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:35', '2026-01-06 10:57:22'),
(983, 'YULIA NUR ANNISA', '24000051@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:35', '2026-01-06 10:57:22'),
(984, 'EKA PRASETIA ROSIDIN', '24000052@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:35', '2026-01-06 10:57:22'),
(985, 'HANI HUMAERIYAH', '24000053@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:35', '2026-01-06 10:57:22'),
(986, 'IMAM SHOLEHUDIN', '24000054@bermadani.id', NULL, '$2y$12$Xy70nFAztRSeHwHrxhyX0.oPszs7p2nYR77LlKJX3pDpk2QveNr/.', 'MEMBER', 1, '2026-04-22 09:06:28', 1, NULL, NULL, '2025-12-13 07:57:36', '2026-04-22 09:06:28'),
(987, 'IMAN HARJONO', '24000055@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:36', '2026-01-06 10:57:22'),
(988, 'LIA YULIA', '24000056@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:36', '2026-01-06 10:57:22'),
(989, 'MUHAMAD SUHARTONO MIHARJO', '24000057@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:36', '2026-01-06 10:57:22'),
(990, 'FAUZIYAH ASTRID', '24000058@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:37', '2026-01-06 10:57:22'),
(991, 'FIQHI MUBAROK', '24000059@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:37', '2026-01-06 10:57:22'),
(992, 'ELMA MUTIARA', '24000060@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:37', '2026-01-06 10:57:22'),
(993, 'FACHRY MUHAMMAD', '24000061@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:38', '2026-01-06 10:57:22'),
(994, 'NENG NURHASANAH', '24000062@bermadani.id', NULL, '$2y$12$rcRjB4DC.e7Zpe47cG91hOaxFJV89PS77Bkf3/PG53/VmIdez5FMW', 'MEMBER', 1, '2026-04-29 06:05:05', 1, NULL, NULL, '2025-12-13 07:57:38', '2026-04-29 06:05:05'),
(995, 'SUBAGIO JOKO SUPRAPTO', '24000063@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:38', '2026-01-06 10:57:22'),
(996, 'SITI SOLIHAT', '24000064@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:38', '2026-01-06 10:57:22'),
(997, 'TITA', '24000065@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:39', '2026-01-06 10:57:22'),
(998, 'IMAM MUTTAQIEN', '25000001@bermadani.id', NULL, '$2y$12$iuNDKGvauZAbzQWxEJmPP.UGm/vBnV1R9PMXa22Vm9GydYzpk2h1C', 'MEMBER', 1, '2026-01-29 13:19:49', 1, NULL, NULL, '2025-12-13 07:57:39', '2026-01-29 13:19:49'),
(999, 'IPAN HAMDANI', '25000002@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:39', '2026-01-06 10:57:22'),
(1000, 'KURNIAWAN', '25000003@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:39', '2026-01-06 10:57:22'),
(1001, 'MUHAMMAD FIKRI MAULANA', '25000004@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:40', '2026-01-06 10:57:22'),
(1002, 'NAHLA SAYYIDAH HAWA', '25000005@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:40', '2026-01-06 10:57:22'),
(1003, 'RAJIMAN', '25000006@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:40', '2026-01-06 10:57:22'),
(1004, 'RONI RAHAYU', '25000007@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:41', '2026-01-06 10:57:22'),
(1005, 'RONI SOMANTRI', '25000008@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:41', '2026-01-06 10:57:22'),
(1006, 'Syarif H', '25000009@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:41', '2026-01-06 10:57:22'),
(1007, 'TONY', '25000010@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:41', '2026-01-06 10:57:22'),
(1008, 'SUKRI RAMADHAN', '25000011@bermadani.id', NULL, '$2y$12$S3HOXPziU7DJ9sU9WoHICODm9gluacoN/.Sp0gceALA/v82efkm9e', 'MEMBER', 1, '2026-07-03 17:21:39', 1, NULL, NULL, '2025-12-13 07:57:42', '2026-07-03 17:21:39'),
(1009, 'HADI MUHAMMAD RIZAL', '25000012@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:42', '2026-01-06 10:57:22'),
(1010, 'PUTRI ANANDA NU ROHMAN', '25000013@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-12-13 07:57:42', '2026-01-06 10:57:22'),
(1011, 'Faisal Amien Prawira', 'faisalamien10@gmail.com', NULL, '$2y$12$h5CewoIMRxaPu0JsZaW22.1qyGTssbzs3OTSRDGlSnhSt.AfcufFK', 'ADMIN', 1, '2026-06-03 13:02:59', 1, NULL, NULL, '2026-01-13 11:39:28', '2026-06-03 13:02:59'),
(1021, 'AHMAD SOBAR', '25000014@bermadani.id', NULL, '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'MEMBER', 1, NULL, 1, NULL, NULL, '2025-01-16 03:00:00', '2025-01-16 03:00:00'),
(1023, 'Tira Setyani', '0895349833526@bermadani.id', NULL, '$2y$12$Vh3b2DMDyTIB4XkBv3bZ9OKeGsgqnOdiybf1NUCRZn02d0zM31Uu.', 'MEMBER', 1, '2026-02-13 10:45:01', 1, NULL, NULL, '2026-01-26 19:06:30', '2026-02-13 10:45:01'),
(1024, 'Faisal Amien Prawira', '26000002@bermadani.id', NULL, '$2y$12$6zulSvT6YEj4ZaiNfWxJkum7Ob52Lsfp5f5GykllpBl09Aw3J9nhi', 'MEMBER', 1, '2026-01-29 12:53:05', 1, NULL, NULL, '2026-01-26 22:02:40', '2026-01-29 12:53:05'),
(1025, 'Yusup Supriatna', '26000003@bermadani.id', NULL, '$2y$12$MxXRiX8Qopog5qwoGxt2fOpJF74d6dLa6ok6GYmfgTgTznL6gu8tC', 'MEMBER', 1, NULL, 1, NULL, NULL, '2026-02-03 13:38:38', '2026-02-03 13:38:38'),
(1026, 'Hendra Gungun', '26000004@bermadani.id', NULL, '$2y$12$T1Qhq8LhjEx3gy1FAIkii.8GlJ18KJispuFMCCsCb1dvKmPd0Vddy', 'MEMBER', 1, NULL, 1, NULL, NULL, '2026-02-03 13:43:22', '2026-02-03 13:43:22'),
(1027, 'Radziman', '26000005@bermadani.id', NULL, '$2y$12$Na3Oit/lI/yCfN.t.M8/fegNyCHzeqvJkNklUM00FX0B1.AMUCgMW', 'MEMBER', 1, NULL, 1, NULL, NULL, '2026-02-05 13:49:47', '2026-02-05 13:49:47'),
(1028, 'Mutiara Imansari', '26000006@bermadani.id', NULL, '$2y$12$iHDDzUdRihGrQ4TTNhJS4uPiuRhbWoyK25Z4l6F53btXzXtMgnOCC', 'MEMBER', 1, NULL, 1, NULL, NULL, '2026-02-05 13:52:22', '2026-02-05 13:52:22'),
(1029, 'Rahmat Kurnia', '26000007@bermadani.id', NULL, '$2y$12$EiBqWQbCdFmXlhkP5IS72u1K/3cOS2KAg.M1e75qbeRM4vrM2ciiu', 'MEMBER', 1, NULL, 1, NULL, NULL, '2026-02-05 13:57:13', '2026-02-05 13:57:13'),
(1030, 'Rifqi Firmansyah', '26000008@bermadani.id', NULL, '$2y$12$G.RGoJC6J5wo7DPko/gG7e1jclhy2MD.nVLyyjv/cJ.wjV41WJVau', 'MEMBER', 1, NULL, 1, NULL, NULL, '2026-02-05 14:01:07', '2026-02-05 14:01:07'),
(1032, 'suhail fariz', 'suhailalfariz08@gmail.com', NULL, '$2y$12$VvEZLq8.KOA8K5pRdmCv7e8/EUaLHqOdQDWJ96qSTzi7wuqCIxYYS', 'ADMIN', 1, '2026-07-09 15:29:50', 1, NULL, NULL, '2026-04-07 07:41:19', '2026-07-09 15:29:50'),
(1033, 'Hanif Mujaddid Al Adzkiya', '26000009@bermadani.id', NULL, '$2y$12$aSbxFrFguGz8evsOyYf7GuxqwwYic5YURy4hVlM5QTSLsibNM5CVW', 'MEMBER', 1, NULL, 1, NULL, NULL, '2026-04-28 04:20:44', '2026-04-28 04:23:13'),
(1034, 'Hanif Mujaddid Al Adzkiya', '26000010@bermadani.id', NULL, '$2y$12$Jhp6hSjEWAw3mb57gMR0d.hC/fHDfZASB7WTLtTj.p6dkOE/sl/Ra', 'MEMBER', 1, NULL, 1, NULL, NULL, '2026-04-28 04:26:05', '2026-04-28 04:26:05'),
(1035, 'Muhamaf Fillah Alifan', 'fillahalifan0@gmail.com', NULL, '$2y$12$m2vbp6/oqZUN6rwg.HVf/utQv1JS5Rxxl6Eto4Wc0y3Ylzt.1ebCC', 'ADMIN', 1, '2026-05-25 11:34:11', 1, NULL, NULL, '2026-05-15 10:54:53', '2026-05-25 11:34:11'),
(1036, 'hanif geboy', '26000011@bermadani.id', NULL, '$2y$12$NVlMXcdADtLtJBkQ5alnDu5MH.QQMS3w3aKTmFmfAyl9atuv.oIp6', 'MEMBER', 1, NULL, 1, NULL, NULL, '2026-05-25 09:31:25', '2026-05-25 09:31:25'),
(1037, 'Tira Octaviani', '26000012@bermadani.id', NULL, '$2y$12$Y7gbSni1gjI6v8r7/qicTO0dXDK.uOpkxnyc6lASzlxQvsLA2aZxS', 'MEMBER', 1, NULL, 1, NULL, NULL, '2026-06-03 06:29:42', '2026-06-03 06:29:42'),
(1038, 'Firman Katon', '26000013@bermadani.id', NULL, '$2y$12$QzXFNJRCvpPebHuwEL5jPutuPxTHwIR5bLOiK.SZUnTNHfcfc0O42', 'MEMBER', 1, NULL, 1, NULL, NULL, '2026-06-25 05:05:21', '2026-06-25 05:05:21'),
(1039, 'Jesika Sheril Alimansyah', '26000014@bermadani.id', NULL, '$2y$12$Zhoo8ktqbYLkP00H6uAp4.2IzjD3svWOtAJ/gYm3x7uzKqrs5hJYO', 'MEMBER', 1, NULL, 1, NULL, NULL, '2026-06-25 05:08:02', '2026-06-25 05:08:02');

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

--
-- 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 `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`);

--
-- 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_minimarket`
--
ALTER TABLE `member_minimarket`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `member_minimarket_membernumber_unique` (`memberNumber`),
  ADD UNIQUE KEY `member_minimarket_cardnumber_unique` (`cardNumber`),
  ADD KEY `member_minimarket_userid_foreign` (`userId`),
  ADD KEY `member_minimarket_registeredby_foreign` (`registeredBy`);

--
-- 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 `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- 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 `suppliers`
--
ALTER TABLE `suppliers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `suppliers_code_unique` (`code`),
  ADD UNIQUE KEY `suppliers_email_unique` (`email`),
  ADD KEY `suppliers_status_is_active_index` (`status`,`isActive`),
  ADD KEY `suppliers_email_index` (`email`),
  ADD KEY `suppliers_approvedbyid_index` (`approvedById`);

--
-- 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 `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `transactions_invoicenumber_unique` (`invoiceNumber`),
  ADD UNIQUE KEY `transactions_checkouttoken_unique` (`checkoutToken`),
  ADD KEY `transactions_memberid_date_index` (`memberId`,`date`),
  ADD KEY `transactions_status_index` (`status`),
  ADD KEY `transactions_date_index` (`date`),
  ADD KEY `transactions_paymentmethod_index` (`paymentMethod`),
  ADD KEY `transactions_isproduction_index` (`isProduction`),
  ADD KEY `transactions_userid_foreign` (`userId`),
  ADD KEY `transactions_cashiershiftid_foreign` (`cashierShiftId`);

--
-- 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 `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`),
  ADD KEY `users_role_index` (`role`),
  ADD KEY `users_isactive_role_index` (`isActive`,`role`);

--
-- 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_minimarket`
--
ALTER TABLE `member_minimarket`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- 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 `suppliers`
--
ALTER TABLE `suppliers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;

--
-- 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 `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- 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 `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1040;

--
-- 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_minimarket`
--
ALTER TABLE `member_minimarket`
  ADD CONSTRAINT `member_minimarket_registeredby_foreign` FOREIGN KEY (`registeredBy`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `member_minimarket_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 `transactions`
--
ALTER TABLE `transactions`
  ADD CONSTRAINT `transactions_cashiershiftid_foreign` FOREIGN KEY (`cashierShiftId`) REFERENCES `cashier_shifts` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `transactions_memberid_foreign` FOREIGN KEY (`memberId`) REFERENCES `members` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `transactions_userid_foreign` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- 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;

