-- ========================================================================
-- REKONSILIASI & PEMBERSIHAN PAYROLL SEPTEMBER 2026 DI PRODUCTION
-- Menyelaraskan 100% database production dengan baseline bersih di local
-- ========================================================================

START TRANSACTION;

-- 1. HAPUS LOAN PAYMENTS SEPTEMBER DI PRODUCTION
-- Menghapus seluruh entri angsuran September (ID >= 255) yang terdobel eksekusi
DELETE FROM `loan_payments` WHERE `id` >= 255;

-- 2. RESTORE SISA POKOK (REMAINING_AMOUNT) 17 PINJAMAN BERJALAN
UPDATE `loans` SET `remaining_amount` = 10981550.00, `status` = 'ACTIVE' WHERE `id` = 41;
UPDATE `loans` SET `remaining_amount` = 9036950.00, `status` = 'ACTIVE' WHERE `id` = 42;
UPDATE `loans` SET `remaining_amount` = 6769050.00, `status` = 'ACTIVE' WHERE `id` = 43;
UPDATE `loans` SET `remaining_amount` = 1050831.00, `status` = 'ACTIVE' WHERE `id` = 46;
UPDATE `loans` SET `remaining_amount` = 4439998.00, `status` = 'ACTIVE' WHERE `id` = 47;
UPDATE `loans` SET `remaining_amount` = 4598359.00, `status` = 'ACTIVE' WHERE `id` = 48;
UPDATE `loans` SET `remaining_amount` = 150000.00, `status` = 'ACTIVE' WHERE `id` = 62;
UPDATE `loans` SET `remaining_amount` = 12007500.00, `status` = 'ACTIVE' WHERE `id` = 63;
UPDATE `loans` SET `remaining_amount` = 10294900.00, `status` = 'ACTIVE' WHERE `id` = 64;
UPDATE `loans` SET `remaining_amount` = 10132500.00, `status` = 'ACTIVE' WHERE `id` = 65;
UPDATE `loans` SET `remaining_amount` = 12007500.00, `status` = 'ACTIVE' WHERE `id` = 66;
UPDATE `loans` SET `remaining_amount` = 333334.00, `status` = 'ACTIVE' WHERE `id` = 67;
UPDATE `loans` SET `remaining_amount` = 7763334.00, `status` = 'ACTIVE' WHERE `id` = 68;
UPDATE `loans` SET `remaining_amount` = 9190000.00, `status` = 'ACTIVE' WHERE `id` = 69;
UPDATE `loans` SET `remaining_amount` = 9190000.00, `status` = 'ACTIVE' WHERE `id` = 70;
UPDATE `loans` SET `remaining_amount` = 9190000.00, `status` = 'ACTIVE' WHERE `id` = 71;
UPDATE `loans` SET `remaining_amount` = 18495000.00, `status` = 'ACTIVE' WHERE `id` = 72;

-- 3. RESTORE SISA POKOK & CATATAN 29 PINJAMAN BMT ITQAN SEPTEMBER
UPDATE `loans` SET `remaining_amount` = 984999.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-22 dari 24' WHERE `loan_number` = 'LN-BMT-2026-001';
UPDATE `loans` SET `remaining_amount` = 3820002.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-19 dari 24' WHERE `loan_number` = 'LN-BMT-2026-002';
UPDATE `loans` SET `remaining_amount` = 6397650.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-16 dari 24' WHERE `loan_number` = 'LN-BMT-2026-003';
UPDATE `loans` SET `remaining_amount` = 14590008.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-1 dari 18' WHERE `loan_number` = 'LN-BMT-2026-004';
UPDATE `loans` SET `remaining_amount` = 13545000.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-11 dari 24' WHERE `loan_number` = 'LN-BMT-2026-005';
UPDATE `loans` SET `remaining_amount` = 33793200.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-4 dari 24' WHERE `loan_number` = 'LN-BMT-2026-006';
UPDATE `loans` SET `remaining_amount` = 13545000.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-11 dari 24' WHERE `loan_number` = 'LN-BMT-2026-007';
UPDATE `loans` SET `remaining_amount` = 9406800.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-11 dari 18' WHERE `loan_number` = 'LN-BMT-2026-008';
UPDATE `loans` SET `remaining_amount` = 9159996.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-1 dari 12' WHERE `loan_number` = 'LN-BMT-2026-009';
UPDATE `loans` SET `remaining_amount` = 1602501.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-10 dari 12' WHERE `loan_number` = 'LN-BMT-2026-010';
UPDATE `loans` SET `remaining_amount` = 8070003.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-7 dari 15' WHERE `loan_number` = 'LN-BMT-2026-011';
UPDATE `loans` SET `remaining_amount` = 11758500.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-9 dari 18' WHERE `loan_number` = 'LN-BMT-2026-012';
UPDATE `loans` SET `remaining_amount` = 2983332.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-9 dari 12' WHERE `loan_number` = 'LN-BMT-2026-013';
UPDATE `loans` SET `remaining_amount` = 12934350.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-8 dari 18' WHERE `loan_number` = 'LN-BMT-2026-014';
UPDATE `loans` SET `remaining_amount` = 21901950.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-8 dari 24' WHERE `loan_number` = 'LN-BMT-2026-015';
UPDATE `loans` SET `remaining_amount` = 17227650.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-8 dari 18' WHERE `loan_number` = 'LN-BMT-2026-016';
UPDATE `loans` SET `remaining_amount` = 3205002.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-7 dari 12' WHERE `loan_number` = 'LN-BMT-2026-017';
UPDATE `loans` SET `remaining_amount` = 7478331.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-6 dari 12' WHERE `loan_number` = 'LN-BMT-2026-018';
UPDATE `loans` SET `remaining_amount` = 20317500.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-4 dari 24' WHERE `loan_number` = 'LN-BMT-2026-019';
UPDATE `loans` SET `remaining_amount` = 18305700.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-4 dari 24' WHERE `loan_number` = 'LN-BMT-2026-020';
UPDATE `loans` SET `remaining_amount` = 14332500.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-4 dari 12' WHERE `loan_number` = 'LN-BMT-2026-021';
UPDATE `loans` SET `remaining_amount` = 20317500.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-4 dari 24' WHERE `loan_number` = 'LN-BMT-2026-022';
UPDATE `loans` SET `remaining_amount` = 10883330.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-3 dari 12' WHERE `loan_number` = 'LN-BMT-2026-023';
UPDATE `loans` SET `remaining_amount` = 13770000.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-2 dari 18' WHERE `loan_number` = 'LN-BMT-2026-024';
UPDATE `loans` SET `remaining_amount` = 13770000.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-2 dari 18' WHERE `loan_number` = 'LN-BMT-2026-025';
UPDATE `loans` SET `remaining_amount` = 13770000.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-2 dari 18' WHERE `loan_number` = 'LN-BMT-2026-026';
UPDATE `loans` SET `remaining_amount` = 28595000.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-2 dari 20' WHERE `loan_number` = 'LN-BMT-2026-027';
UPDATE `loans` SET `remaining_amount` = 14590800.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-1 dari 18' WHERE `loan_number` = 'LN-BMT-2026-028';
UPDATE `loans` SET `remaining_amount` = 24120000.00, `status` = 'ACTIVE', `notes` = 'Angsuran ke-1 dari 24' WHERE `loan_number` = 'LN-BMT-2026-029';

-- 4. REASSIGN DATA DARI 5 USER DUPLIKAT KE USER ASLI & HAPUS AKUN DUPLIKAT
UPDATE `loans` SET `member_id` = 61 WHERE `member_id` = 162;
UPDATE `loans` SET `member_id` = 136 WHERE `member_id` = 163;
UPDATE `loans` SET `member_id` = 106 WHERE `member_id` = 164;
UPDATE `loans` SET `member_id` = 54 WHERE `member_id` = 165;
UPDATE `loans` SET `member_id` = 107 WHERE `member_id` = 166;
UPDATE `journal_entries` SET `member_id` = 61 WHERE `member_id` = 162;
UPDATE `journal_entries` SET `member_id` = 136 WHERE `member_id` = 163;
UPDATE `journal_entries` SET `member_id` = 106 WHERE `member_id` = 164;
UPDATE `journal_entries` SET `member_id` = 54 WHERE `member_id` = 165;
UPDATE `journal_entries` SET `member_id` = 107 WHERE `member_id` = 166;
DELETE FROM `users` WHERE `id` IN (162, 163, 164, 165, 166);

-- 5. BERSIHKAN JURNAL & ENTRI JURNAL DUPLIKAT PAYROLL SEPTEMBER (ID 6175 - 6668)
-- Menghapus 494 jurnal semu yang mendebit Kas Toko (1.1.01) sebesar Rp 154.166.263,00 akibat eksekusi ganda di prod
DELETE FROM `journal_entries` WHERE `journal_id` BETWEEN 6175 AND 6668;
DELETE FROM `journals` WHERE `id` BETWEEN 6175 AND 6668;

-- 6. BERSIHKAN TRANSAKSI SIMPANAN DUPLIKAT SEPTEMBER
DELETE FROM `simpanan_transactions` WHERE `description` LIKE '%Payroll 2026-09%';

-- 7. BERSIHKAN BATCH PAYROLL SEPTEMBER LAMA (BATCH ID 9 / PROCESSED)
DELETE FROM `payroll_batch_item_loans` WHERE `payroll_batch_item_id` IN (SELECT `id` FROM `payroll_batch_items` WHERE `payroll_batch_id` IN (SELECT `id` FROM `payroll_batches` WHERE `month_period` = '2026-09'));
DELETE FROM `payroll_batch_items` WHERE `payroll_batch_id` IN (SELECT `id` FROM `payroll_batches` WHERE `month_period` = '2026-09');
DELETE FROM `payroll_batches` WHERE `month_period` = '2026-09';

-- 8. BUAT BATCH PAYROLL SEPTEMBER 2026 BARU STATUS DRAFT (RP 32.859.922,00)
INSERT INTO `payroll_batches` (`month_period`, `total_amount`, `status`, `processed_by`, `processed_at`, `created_at`, `updated_at`) VALUES ('2026-09', 32859922.00, 'DRAFT', NULL, NULL, NOW(), NOW());
SET @batch_id = LAST_INSERT_ID();

INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 10, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 11, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 12, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 14, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 15, 0.00, 50000.00, 0.00, 0.00, 666667.00, 716667.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-002' LIMIT 1), 666667.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 17, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 18, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 19, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 21, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 22, 0.00, 50000.00, 0.00, 0.00, 1098333.00, 1148333.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-018' LIMIT 1), 1098333.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 23, 0.00, 50000.00, 0.00, 0.00, 775833.00, 825833.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-013' LIMIT 1), 775833.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 24, 0.00, 50000.00, 0.00, 0.00, 997500.00, 1047500.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-007' LIMIT 1), 997500.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 25, 0.00, 50000.00, 0.00, 0.00, 997500.00, 1047500.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-019' LIMIT 1), 997500.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 26, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 27, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 28, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 29, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 30, 0.00, 50000.00, 0.00, 0.00, 1490834.00, 1540834.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-010' LIMIT 1), 564167.00, NOW(), NOW());
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-011' LIMIT 1), 926667.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 31, 0.00, 50000.00, 0.00, 0.00, 901700.00, 951700.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-020' LIMIT 1), 901700.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 32, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 33, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 36, 0.00, 50000.00, 0.00, 0.00, 1318350.00, 1368350.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-015' LIMIT 1), 1318350.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 37, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 40, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 41, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 42, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 43, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 44, 0.00, 50000.00, 0.00, 333333.00, 1999183.00, 2382516.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, 67, 333333.00, NOW(), NOW());
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-008' LIMIT 1), 1205850.00, NOW(), NOW());
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-009' LIMIT 1), 793333.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 45, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 46, 0.00, 50000.00, 0.00, 0.00, 1205850.00, 1255850.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-014' LIMIT 1), 1205850.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 47, 0.00, 50000.00, 0.00, 0.00, 564167.00, 614167.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-017' LIMIT 1), 564167.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 48, 0.00, 50000.00, 0.00, 0.00, 1205850.00, 1255850.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-012' LIMIT 1), 1205850.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 49, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 52, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 53, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 54, 0.00, 50000.00, 0.00, 0.00, 1622500.00, 1672500.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-021' LIMIT 1), 1622500.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 55, 0.00, 50000.00, 0.00, 0.00, 840556.00, 890556.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-004' LIMIT 1), 840556.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 57, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 58, 0.00, 50000.00, 150000.00, 0.00, 0.00, 200000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 60, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 61, 0.00, 50000.00, 0.00, 0.00, 358333.00, 408333.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-001' LIMIT 1), 358333.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 62, 0.00, 50000.00, 0.00, 0.00, 997500.00, 1047500.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-022' LIMIT 1), 997500.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 63, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 66, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 68, 0.00, 50000.00, 0.00, 0.00, 1535000.00, 1585000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-027' LIMIT 1), 1535000.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 69, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 70, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 72, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 73, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 76, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 77, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 79, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 80, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 81, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 82, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 85, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 87, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 88, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 89, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 90, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 91, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 92, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 93, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 94, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 97, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 98, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 99, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 102, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 103, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 104, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 105, 0.00, 50000.00, 100000.00, 0.00, 0.00, 150000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 106, 0.00, 50000.00, 0.00, 0.00, 1596150.00, 1646150.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-016' LIMIT 1), 1596150.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 107, 0.00, 50000.00, 0.00, 0.00, 840600.00, 890600.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-028' LIMIT 1), 840600.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 108, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 109, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 111, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 113, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 114, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 115, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 116, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 117, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 119, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 121, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 122, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 123, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 124, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 125, 0.00, 50000.00, 0.00, 0.00, 1118333.00, 1168333.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-023' LIMIT 1), 1118333.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 126, 0.00, 50000.00, 200000.00, 0.00, 0.00, 250000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 127, 0.00, 50000.00, 100000.00, 0.00, 0.00, 150000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 128, 0.00, 50000.00, 0.00, 0.00, 1035000.00, 1085000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-029' LIMIT 1), 1035000.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 129, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 130, 0.00, 50000.00, 0.00, 0.00, 840000.00, 890000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-024' LIMIT 1), 840000.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 131, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 134, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 135, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 136, 0.00, 50000.00, 0.00, 150000.00, 740850.00, 940850.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, 62, 150000.00, NOW(), NOW());
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-003' LIMIT 1), 740850.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 138, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 139, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 140, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 142, 0.00, 50000.00, 0.00, 0.00, 840000.00, 890000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-026' LIMIT 1), 840000.00, NOW(), NOW());
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 143, 0.00, 50000.00, 50000.00, 0.00, 0.00, 100000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 144, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 153, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 156, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 157, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 158, 0.00, 50000.00, 0.00, 0.00, 0.00, 50000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_items` (`payroll_batch_id`, `member_id`, `simpanan_pokok_amount`, `simpanan_wajib_amount`, `simpanan_sukarela_amount`, `total_internal_loan`, `total_external_loan`, `total_amount`, `created_at`, `updated_at`) VALUES (@batch_id, 159, 0.00, 50000.00, 0.00, 0.00, 840000.00, 890000.00, NOW(), NOW());
SET @item_id = LAST_INSERT_ID();
INSERT INTO `payroll_batch_item_loans` (`payroll_batch_item_id`, `loan_id`, `amount`, `created_at`, `updated_at`) VALUES (@item_id, (SELECT `id` FROM `loans` WHERE `loan_number` = 'LN-BMT-2026-025' LIMIT 1), 840000.00, NOW(), NOW());

-- 7. RESET SIMPANAN WAJIB BILLS SEPTEMBER 2026 (STATUS UNPAID)
DELETE FROM `simpanan_wajib_bills` WHERE `month_period` = '2026-09';
INSERT INTO `simpanan_wajib_bills` (`member_id`, `month_period`, `amount`, `status`, `created_at`, `updated_at`) SELECT `member_id`, '2026-09', `simpanan_wajib_amount`, 'UNPAID', NOW(), NOW() FROM `payroll_batch_items` WHERE `payroll_batch_id` = @batch_id;

COMMIT;