-- ========================================================================
-- REKONSILIASI & CLEARING SUPPLIER HILMI & PA SYARIF DI PRODUCTION
-- Tanggal: 23 Oktober 2026
-- ========================================================================

START TRANSACTION;

-- 1. ASSIGN PRODUK MILKU KE PA SYARIF (SUPPLIER ID = 60)
UPDATE `products` 
SET `supplier_id` = 60 
WHERE `sku` IN ('8998866204514', '8998866202725', '8998866203920')
   OR `id` IN (55, 56, 57);

-- 2. ASSIGN PRODUK BARCODE ASLI TANPA SUPPLIER KE HILMI (SUPPLIER ID = 59)
UPDATE `products` 
SET `supplier_id` = 59 
WHERE (`sku` IN (
    '8998866203258', -- Sedap Cup Baso Bleduk
    '8998866202404', -- Mie sedaap cup korean spicy
    '8995077609749', -- Sukro
    '8888166994393', -- Monde Snack Gold 25g
    '8996001308059', -- Sari Gandum
    '8996001375372', -- Choki Choki
    '8996001354124', -- Bengbeng
    '8996001320051', -- Kopiko Candy
    '8996001321515'  -- Kiss Mint Candy
) OR `id` IN (253, 254, 255, 257, 264, 269, 270, 281, 282))
AND (`supplier_id` IS NULL OR `supplier_id` = 0);

-- 3. CATAT RECORD PEMBAYARAN HILMI 5JT DI SUPPLIER_SETTLEMENTS
INSERT IGNORE INTO `supplier_settlements` (
    `settlement_number`, 
    `supplier_id`, 
    `settlement_type`, 
    `receiving_id`, 
    `amount`, 
    `payment_method`, 
    `payment_date`, 
    `processed_by`, 
    `shift_log_id`, 
    `reference_number`, 
    `status`, 
    `notes`, 
    `created_at`, 
    `updated_at`
) VALUES (
    'SET-202610-00151',
    59,
    'POS_CONSIGNMENT',
    NULL,
    5000000.00,
    'CASH',
    '2026-10-05 12:00:00',
    6,
    NULL,
    'PETTY-CASH-05102026',
    'COMPLETED',
    'Pembayaran termin/DP faktur supplier Hilmi via Petty Cash tgl 5 Okt 2026',
    NOW(),
    NOW()
);

-- 4. CATAT RECORD PENGELUARAN PETTY CASH DI EXPENSES
INSERT INTO `expenses` (
    `user_id`, 
    `expense_category_id`, 
    `amount`, 
    `expense_date`, 
    `description`, 
    `receipt_image_path`, 
    `source_of_fund`, 
    `status`, 
    `approved_by`, 
    `approved_at`, 
    `rejection_reason`, 
    `created_at`, 
    `updated_at`
) SELECT 
    6, 
    1, 
    5000000.00, 
    '2026-10-05', 
    'Pembayaran termin/DP faktur supplier Hilmi (SUP-055) via Petty Cash [SET-202610-00151]', 
    NULL, 
    'PETTY_CASH', 
    'APPROVED', 
    6, 
    '2026-10-05 12:00:00', 
    NULL, 
    NOW(), 
    NOW()
FROM DUAL
WHERE NOT EXISTS (
    SELECT 1 FROM `expenses` 
    WHERE `amount` = 5000000.00 
      AND `expense_date` = '2026-10-05' 
      AND `source_of_fund` = 'PETTY_CASH'
);

-- 5. CATAT RECORD PEMBAYARAN PA SYARIF 2.665JT DI SUPPLIER_SETTLEMENTS
INSERT IGNORE INTO `supplier_settlements` (
    `settlement_number`, 
    `supplier_id`, 
    `settlement_type`, 
    `receiving_id`, 
    `amount`, 
    `payment_method`, 
    `payment_date`, 
    `processed_by`, 
    `shift_log_id`, 
    `reference_number`, 
    `status`, 
    `notes`, 
    `created_at`, 
    `updated_at`
) VALUES (
    'SET-202610-00152',
    60,
    'POS_CONSIGNMENT',
    NULL,
    2665000.00,
    'CASH',
    '2026-08-10 12:00:00',
    6,
    NULL,
    'NOTA-SYARIF-10082026',
    'COMPLETED',
    'Pembayaran termin/DP faktur supplier Retail pa syarif (sesuai nota masuk)',
    NOW(),
    NOW()
);

COMMIT;