//Insert Items
INSERT INTO items (sku, name, category, unit, description, is_active)
SELECT 
    kode_barang,
    nama_barang,
    kategori_barang,
    satuan,
    catatan,
    CASE 
        WHEN non_aktif = 'TRUE' OR non_aktif = '1' THEN 0 
        ELSE 1 
    END
FROM staging_inventory_raw
WHERE kode_barang IS NOT NULL
GROUP BY kode_barang;

//Insert barcode
INSERT INTO item_barcodes (item_id, barcode, type, is_primary)
SELECT 
    i.id,
    s.upc_barcode,
    'CODE128',
    1
FROM staging_inventory_raw s
JOIN items i ON i.sku = s.kode_barang
WHERE s.upc_barcode IS NOT NULL AND s.upc_barcode <> '';

//location
INSERT INTO locations (code, name, type)
SELECT DISTINCT 
    TRIM(gudang_saldo_awal),
    TRIM(gudang_saldo_awal),
    'WAREHOUSE'
FROM staging_inventory_raw
WHERE gudang_saldo_awal IS NOT NULL AND gudang_saldo_awal <> '';

//Insert Inventory Awal
INSERT INTO inventories (item_id, location_id, quantity)
SELECT 
    i.id,
    l.id,
    CAST(s.kuantitas_saldo_awal AS DECIMAL(18,4))
FROM staging_inventory_raw s
JOIN items i ON i.sku = s.kode_barang
JOIN locations l ON l.code = s.gudang_saldo_awal
WHERE s.kuantitas_saldo_awal IS NOT NULL;








//Check Duplicate sku
SELECT kode_barang, COUNT(*)
FROM staging_inventory_raw
GROUP BY kode_barang
HAVING COUNT(*) > 1;


kode_barang
COUNT(*)
01NB258OBNT
2
01VLVB20FTF
2
02E10LDPEPL
2
02FLBEEFR1101
2
02FLOWBEEHVB18
2
03J32HDPENF
2
03NZNSM24PL
2
04T10LDPEPL
2
09JTYACH044
2
11LDP05MMNT
5
11LDP08MMNF
4
11LDP16MMKN
3
11LDP16MMNF
5
11LDP20MMNF
3
12LF3X20MCH
3
21A1612PENF
5
21A2034PENF
3
21ADAP5BTNT
4
21ADAPJATPL
2
21ATAPE12NF
2
21D3434PEPL
2
22E16G12MNF
2
22E16LDPENF
4
22E2034MENF
4
22E20LDPENF
4



//Check Barcode kosong
SELECT * 
FROM staging_inventory_raw
WHERE upc_barcode IS NULL OR upc_barcode = '';

 Menampilkan baris 0 - 24 (total 2408, Pencarian dilakukan dalam 0.0007 detik.)

 //CheckItem tanpa unit
 SELECT * 
FROM staging_inventory_raw
WHERE satuan IS NULL OR satuan = '';

 Menampilkan baris 0 - 89 (total 90, Pencarian dilakukan dalam 0.0037 detik.)
SELECT * FROM staging_inventory_raw WHERE satuan IS NULL OR satuan = '';