-- DEPLOY PRODUKSI 2026-10-15 (1/2): kembalikan 19 kuitansi penerimaan yang terhapus
-- salah pada minggu reset 8-14 Sep 2026. Sudah diverifikasi di DB trace:
-- cocok BKU sampai rupiah + tidak ada duplikat aktif. Idempoten (aman diulang).
-- BACKUP DATABASE DULU sebelum menjalankan.
START TRANSACTION;
UPDATE transaksi SET deleted_at = NULL WHERE id IN
  (4308,1497,446,1505,1509,42,93,423,428,436,440,443,486,1495,1496,1498,1499,1506,1507);
UPDATE detail_transaksi SET deleted_at = NULL WHERE id IN
  (8384407,233086,34794,233094,233098,48,100,34770,34775,34784,34788,34791,34835,233084,233085,233087,233088,233095,233096);
-- Verifikasi: harus 0 baris (tidak ada sisa terhapus dari 19 ini)
SELECT COUNT(*) AS sisa_terhapus FROM transaksi WHERE id IN
  (4308,1497,446,1505,1509,42,93,423,428,436,440,443,486,1495,1496,1498,1499,1506,1507)
  AND deleted_at IS NOT NULL;
COMMIT;