INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-12-02 ','08:10:02');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-02','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-01';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-01';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-01';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-12-01' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-01';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-01';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-01';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-01';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
UPDATE tt_barang_saldo SET tanggal= '2025-12-02' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-01' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-12-02';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-12-02 ','10:21:26');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0001','1','MDGL-YLXA-24-0','1','1.080','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YLXA-24-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YLXA-24-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BGLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BGLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDGL-YLXA-24-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.080',berat_out_asli='1.070', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.080',berat_akhir_asli =berat_akhir_asli-'1.070' WHERE kode_barang='MDGL-YLXA-24-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0001','2','MDGL-YLXA-25-0','1','1.080','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YLXA-25-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YLXA-25-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BGLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BGLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDGL-YLXA-25-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.080',berat_out_asli='1.070', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.080',berat_akhir_asli =berat_akhir_asli-'1.070' WHERE kode_barang='MDGL-YLXA-25-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0001','3','MDGL-YLXA-26-0','1','1.410','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YLXA-26-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YLXA-26-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BGLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BGLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDGL-YLXA-26-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.410',berat_out_asli='1.400', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.410',berat_akhir_asli =berat_akhir_asli-'1.400' WHERE kode_barang='MDGL-YLXA-26-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0001','4','MDGL-YLXA-27-0','1','1.410','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YLXA-27-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YLXA-27-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BGLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BGLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDGL-YLXA-27-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.410',berat_out_asli='1.400', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.410',berat_akhir_asli =berat_akhir_asli-'1.400' WHERE kode_barang='MDGL-YLXA-27-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0001','5','MDGL-YLXA-28-0','1','3.630','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YLXA-28-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YLXA-28-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BGLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BGLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDGL-YLXA-28-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.630',berat_out_asli='3.620', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.630',berat_akhir_asli =berat_akhir_asli-'3.620' WHERE kode_barang='MDGL-YLXA-28-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0001','6','MDGL-YLXA-29-0','1','3.680','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YLXA-29-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YLXA-29-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BGLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BGLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDGL-YLXA-29-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.680',berat_out_asli='3.670', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.680',berat_akhir_asli =berat_akhir_asli-'3.670' WHERE kode_barang='MDGL-YLXA-29-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-251202-0001','2025-12-02','2025-12-02','10:21','3.680','adminpusat','251202');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0002','1','MTAT-YLXA-44-0','1','1.580','TOKO','BKATMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-YLXA-44-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTAT-YLXA-44-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTAT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKATMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKATMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTAT-YLXA-44-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.580',berat_out_asli='1.570', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.580',berat_akhir_asli =berat_akhir_asli-'1.570' WHERE kode_barang='MTAT-YLXA-44-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0002','2','MTAT-YLXA-45-0','1','1.570','TOKO','BKATMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-YLXA-45-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTAT-YLXA-45-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTAT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKATMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKATMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTAT-YLXA-45-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.570',berat_out_asli='1.560', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.570',berat_akhir_asli =berat_akhir_asli-'1.560' WHERE kode_barang='MTAT-YLXA-45-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-251202-0002','2025-12-02','2025-12-02','10:21','1.570','adminpusat','251202');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0003','1','MTGL-YLXA-46-0','1','1.410','TOKO','BKGLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXA-46-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-YLXA-46-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-YLXA-46-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.410',berat_out_asli='1.400', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.410',berat_akhir_asli =berat_akhir_asli-'1.400' WHERE kode_barang='MTGL-YLXA-46-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0003','2','MTGL-YLXA-47-0','1','1.400','TOKO','BKGLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXA-47-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-YLXA-47-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-YLXA-47-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.400',berat_out_asli='1.390', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.400',berat_akhir_asli =berat_akhir_asli-'1.390' WHERE kode_barang='MTGL-YLXA-47-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0003','3','MTGL-YLXA-48-0','1','1.920','TOKO','BKGLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXA-48-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-YLXA-48-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-YLXA-48-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.920',berat_out_asli='1.910', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.920',berat_akhir_asli =berat_akhir_asli-'1.910' WHERE kode_barang='MTGL-YLXA-48-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0003','4','MTGL-YLXA-49-0','1','1.880','TOKO','BKGLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXA-49-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-YLXA-49-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-YLXA-49-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.880',berat_out_asli='1.870', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.880',berat_akhir_asli =berat_akhir_asli-'1.870' WHERE kode_barang='MTGL-YLXA-49-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0003','5','MTGL-YLXA-50-0','1','2.310','TOKO','BKGLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXA-50-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-YLXA-50-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-YLXA-50-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.310',berat_out_asli='2.300', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.310',berat_akhir_asli =berat_akhir_asli-'2.300' WHERE kode_barang='MTGL-YLXA-50-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0003','6','MTGL-YLXA-51-0','1','2.310','TOKO','BKGLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXA-51-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-YLXA-51-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-YLXA-51-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.310',berat_out_asli='2.300', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.310',berat_akhir_asli =berat_akhir_asli-'2.300' WHERE kode_barang='MTGL-YLXA-51-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0003','7','MTGL-YLXA-52-0','1','3.040','TOKO','BKGLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXA-52-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-YLXA-52-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-YLXA-52-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.040',berat_out_asli='3.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.040',berat_akhir_asli =berat_akhir_asli-'3.030' WHERE kode_barang='MTGL-YLXA-52-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0003','8','MTGL-YLXA-53-0','1','3.130','TOKO','BKGLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXA-53-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-YLXA-53-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-YLXA-53-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.130',berat_out_asli='3.120', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.130',berat_akhir_asli =berat_akhir_asli-'3.120' WHERE kode_barang='MTGL-YLXA-53-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0003','9','MTGL-YLXA-54-0','1','3.280','TOKO','BKGLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXA-54-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-YLXA-54-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-YLXA-54-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.280',berat_out_asli='3.270', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.280',berat_akhir_asli =berat_akhir_asli-'3.270' WHERE kode_barang='MTGL-YLXA-54-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0003','10','MTGL-YLXA-55-0','1','3.300','TOKO','BKGLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXA-55-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-YLXA-55-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-YLXA-55-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.300',berat_out_asli='3.290', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.300',berat_akhir_asli =berat_akhir_asli-'3.290' WHERE kode_barang='MTGL-YLXA-55-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0003','11','MTGL-YLXA-56-0','1','5.180','TOKO','BKGLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-YLXA-56-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTGL-YLXA-56-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKGLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKGLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTGL-YLXA-56-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.180',berat_out_asli='5.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.180',berat_akhir_asli =berat_akhir_asli-'5.170' WHERE kode_barang='MTGL-YLXA-56-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-251202-0003','2025-12-02','2025-12-02','10:22','5.180','adminpusat','251202');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0004','1','MDLT-YLXA-30-0','1','1.000','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YLXA-30-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YLXA-30-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YLXA-30-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.000',berat_out_asli='0.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.000',berat_akhir_asli =berat_akhir_asli-'0.990' WHERE kode_barang='MDLT-YLXA-30-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0004','2','MDLT-YLXA-31-0','1','1.010','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YLXA-31-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YLXA-31-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YLXA-31-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.010',berat_out_asli='1.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.010',berat_akhir_asli =berat_akhir_asli-'1.000' WHERE kode_barang='MDLT-YLXA-31-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0004','3','MDLT-YLXA-32-0','1','1.000','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YLXA-32-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YLXA-32-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YLXA-32-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.000',berat_out_asli='0.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.000',berat_akhir_asli =berat_akhir_asli-'0.990' WHERE kode_barang='MDLT-YLXA-32-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0004','4','MDLT-YLXA-33-0','1','1.600','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YLXA-33-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YLXA-33-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YLXA-33-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.600',berat_out_asli='1.590', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.600',berat_akhir_asli =berat_akhir_asli-'1.590' WHERE kode_barang='MDLT-YLXA-33-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0004','5','MDLT-YLXA-34-0','1','1.600','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YLXA-34-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YLXA-34-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YLXA-34-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.600',berat_out_asli='1.590', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.600',berat_akhir_asli =berat_akhir_asli-'1.590' WHERE kode_barang='MDLT-YLXA-34-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0004','6','MDLT-YLXA-35-0','1','1.610','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YLXA-35-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YLXA-35-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YLXA-35-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.610',berat_out_asli='1.600', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.610',berat_akhir_asli =berat_akhir_asli-'1.600' WHERE kode_barang='MDLT-YLXA-35-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0004','7','MDLT-YLXA-36-0','1','1.970','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YLXA-36-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YLXA-36-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YLXA-36-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.970',berat_out_asli='1.960', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.970',berat_akhir_asli =berat_akhir_asli-'1.960' WHERE kode_barang='MDLT-YLXA-36-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0004','8','MDLT-YLXA-37-0','1','2.030','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YLXA-37-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YLXA-37-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YLXA-37-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.030',berat_out_asli='2.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.030',berat_akhir_asli =berat_akhir_asli-'2.020' WHERE kode_barang='MDLT-YLXA-37-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0004','9','MDLT-YLXA-38-0','1','1.050','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YLXA-38-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YLXA-38-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YLXA-38-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.050',berat_out_asli='1.040', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.050',berat_akhir_asli =berat_akhir_asli-'1.040' WHERE kode_barang='MDLT-YLXA-38-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0004','10','MDLT-YLXA-39-0','1','1.040','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YLXA-39-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YLXA-39-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YLXA-39-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.040',berat_out_asli='1.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.040',berat_akhir_asli =berat_akhir_asli-'1.030' WHERE kode_barang='MDLT-YLXA-39-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0004','11','MDLT-YLXA-40-0','1','1.260','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YLXA-40-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YLXA-40-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YLXA-40-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.260',berat_out_asli='1.250', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.260',berat_akhir_asli =berat_akhir_asli-'1.250' WHERE kode_barang='MDLT-YLXA-40-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0004','12','MDLT-YLXA-41-0','1','1.260','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YLXA-41-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YLXA-41-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YLXA-41-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.260',berat_out_asli='1.250', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.260',berat_akhir_asli =berat_akhir_asli-'1.250' WHERE kode_barang='MDLT-YLXA-41-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0004','13','MDLT-YLXA-42-0','1','0.970','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YLXA-42-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YLXA-42-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YLXA-42-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.970',berat_out_asli='0.960', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.970',berat_akhir_asli =berat_akhir_asli-'0.960' WHERE kode_barang='MDLT-YLXA-42-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251202-0004','14','MDLT-YLXA-43-0','1','0.910','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YLXA-43-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YLXA-43-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YLXA-43-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.910',berat_out_asli='0.900', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.910',berat_akhir_asli =berat_akhir_asli-'0.900' WHERE kode_barang='MDLT-YLXA-43-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-251202-0004','2025-12-02','2025-12-02','10:22','0.910','adminpusat','251202');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-12-02 ','13:09:35');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0001','1','MDAT-YLXA-57-0','1','0.520','0.520','TOKO','INPUT1','TOKO','BATMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-YLXA-57-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BATMD','MDAT','MDAT-YLXA-57-0','100.00','1','0.520','0.510','1','0.520','0.510');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.520',berat_out_asli=berat_out_asli+'0.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDAT-YLXA-57-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0001','2','MDAT-YLXA-58-0','1','0.480','0.480','TOKO','INPUT1','TOKO','BATMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-YLXA-58-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BATMD','MDAT','MDAT-YLXA-58-0','100.00','1','0.480','0.470','1','0.480','0.470');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.480',berat_out_asli=berat_out_asli+'0.470',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDAT-YLXA-58-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0001','3','MDAT-YLXA-59-0','1','1.000','1.000','TOKO','INPUT1','TOKO','BATMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-YLXA-59-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BATMD','MDAT','MDAT-YLXA-59-0','100.00','1','1.000','0.990','1','1.000','0.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.000',berat_out_asli=berat_out_asli+'0.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDAT-YLXA-59-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0001','4','MDAT-YLXA-60-0','1','0.980','0.980','TOKO','INPUT1','TOKO','BATMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-YLXA-60-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BATMD','MDAT','MDAT-YLXA-60-0','100.00','1','0.980','0.970','1','0.980','0.970');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.980',berat_out_asli=berat_out_asli+'0.970',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDAT-YLXA-60-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0001','5','MDAT-YLXA-61-0','1','0.970','0.970','TOKO','INPUT1','TOKO','BATMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-YLXA-61-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BATMD','MDAT','MDAT-YLXA-61-0','100.00','1','0.970','0.960','1','0.970','0.960');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.970',berat_out_asli=berat_out_asli+'0.960',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDAT-YLXA-61-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0001','6','MDAT-YLXA-62-0','1','1.270','1.270','TOKO','INPUT1','TOKO','BATMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-YLXA-62-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BATMD','MDAT','MDAT-YLXA-62-0','100.00','1','1.270','1.260','1','1.270','1.260');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.270',berat_out_asli=berat_out_asli+'1.260',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDAT-YLXA-62-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0001','7','MDAT-YLXA-63-0','1','1.310','1.310','TOKO','INPUT1','TOKO','BATMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-YLXA-63-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BATMD','MDAT','MDAT-YLXA-63-0','100.00','1','1.310','1.300','1','1.310','1.300');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.310',berat_out_asli=berat_out_asli+'1.300',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDAT-YLXA-63-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0001','8','MDAT-YLXA-64-0','1','0.820','0.820','TOKO','INPUT1','TOKO','BATMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-YLXA-64-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BATMD','MDAT','MDAT-YLXA-64-0','100.00','1','0.820','0.810','1','0.820','0.810');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.820',berat_out_asli=berat_out_asli+'0.810',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDAT-YLXA-64-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251202-0001','2025-12-02','2025-12-02','13:11','7.35','adminpusat','2025-12-02 13:11:49');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0002','1','MDCN-YLXA-65-0','1','0.920','0.920','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YLXA-65-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BCNMD','MDCN','MDCN-YLXA-65-0','100.00','1','0.920','0.910','1','0.920','0.910');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.920',berat_out_asli=berat_out_asli+'0.910',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDCN-YLXA-65-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0002','2','MDCN-YLXA-66-0','1','0.660','0.660','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YLXA-66-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BCNMD','MDCN','MDCN-YLXA-66-0','100.00','1','0.660','0.650','1','0.660','0.650');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.660',berat_out_asli=berat_out_asli+'0.650',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDCN-YLXA-66-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0002','3','MDCN-YLXA-67-0','1','1.520','1.520','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YLXA-67-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BCNMD','MDCN','MDCN-YLXA-67-0','100.00','1','1.520','1.510','1','1.520','1.510');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.520',berat_out_asli=berat_out_asli+'1.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDCN-YLXA-67-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0002','4','MDCN-YLXA-68-0','1','2.870','2.870','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YLXA-68-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BCNMD','MDCN','MDCN-YLXA-68-0','100.00','1','2.870','2.860','1','2.870','2.860');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.870',berat_out_asli=berat_out_asli+'2.860',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDCN-YLXA-68-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0002','5','MDCN-YLXA-69-0','1','1.880','1.880','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-YLXA-69-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BCNMD','MDCN','MDCN-YLXA-69-0','100.00','1','1.880','1.870','1','1.880','1.870');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.880',berat_out_asli=berat_out_asli+'1.870',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDCN-YLXA-69-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251202-0002','2025-12-02','2025-12-02','13:11','7.85','adminpusat','2025-12-02 13:12:48');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0003','1','MDGL-YLXA-70-0','1','4.800','4.800','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YLXA-70-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BGLMD','MDGL','MDGL-YLXA-70-0','100.00','1','4.800','4.790','1','4.800','4.790');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.800',berat_out_asli=berat_out_asli+'4.790',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDGL-YLXA-70-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0003','2','MDGL-YLXA-71-0','1','3.580','3.580','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YLXA-71-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BGLMD','MDGL','MDGL-YLXA-71-0','100.00','1','3.580','3.570','1','3.580','3.570');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.580',berat_out_asli=berat_out_asli+'3.570',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDGL-YLXA-71-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0003','3','MDGL-YLXA-72-0','1','5.600','5.600','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YLXA-72-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BGLMD','MDGL','MDGL-YLXA-72-0','100.00','1','5.600','5.590','1','5.600','5.590');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.600',berat_out_asli=berat_out_asli+'5.590',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDGL-YLXA-72-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0003','4','MDGL-YLXA-73-0','1','13.900','13.900','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YLXA-73-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BGLMD','MDGL','MDGL-YLXA-73-0','100.00','1','13.900','13.890','1','13.900','13.890');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'13.900',berat_out_asli=berat_out_asli+'13.890',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDGL-YLXA-73-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251202-0003','2025-12-02','2025-12-02','13:12','27.88','adminpusat','2025-12-02 13:13:56');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0004','1','MDKL-YLXA-74-0','1','1.730','1.730','TOKO','INPUT1','TOKO','BKLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-YLXA-74-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKLMD','MDKL','MDKL-YLXA-74-0','100.00','1','1.730','1.720','1','1.730','1.720');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.730',berat_out_asli=berat_out_asli+'1.720',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDKL-YLXA-74-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0004','2','MDKL-YLXA-75-0','1','1.960','1.960','TOKO','INPUT1','TOKO','BKLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-YLXA-75-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKLMD','MDKL','MDKL-YLXA-75-0','100.00','1','1.960','1.950','1','1.960','1.950');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.960',berat_out_asli=berat_out_asli+'1.950',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDKL-YLXA-75-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0004','3','MDKL-YLXA-76-0','1','3.020','3.020','TOKO','INPUT1','TOKO','BKLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-YLXA-76-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKLMD','MDKL','MDKL-YLXA-76-0','100.00','1','3.020','3.010','1','3.020','3.010');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.020',berat_out_asli=berat_out_asli+'3.010',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDKL-YLXA-76-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251202-0004','2025-12-02','2025-12-02','13:14','6.71','adminpusat','2025-12-02 13:14:55');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0005','1','MDLT-YLXA-77-0','1','1.270','1.270','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-YLXA-77-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BLTMD','MDLT','MDLT-YLXA-77-0','100.00','1','1.270','1.260','1','1.270','1.260');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.270',berat_out_asli=berat_out_asli+'1.260',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDLT-YLXA-77-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0005','2','MDLT-YLXA-78-0','1','1.200','1.200','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-YLXA-78-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BLTMD','MDLT','MDLT-YLXA-78-0','100.00','1','1.200','1.190','1','1.200','1.190');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.200',berat_out_asli=berat_out_asli+'1.190',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDLT-YLXA-78-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0005','3','MDLT-YLXA-79-0','1','1.510','1.510','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-YLXA-79-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BLTMD','MDLT','MDLT-YLXA-79-0','100.00','1','1.510','1.500','1','1.510','1.500');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.510',berat_out_asli=berat_out_asli+'1.500',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDLT-YLXA-79-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0005','4','MDLT-YLXA-80-0','1','2.230','2.230','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-YLXA-80-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BLTMD','MDLT','MDLT-YLXA-80-0','100.00','1','2.230','2.220','1','2.230','2.220');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.230',berat_out_asli=berat_out_asli+'2.220',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MDLT-YLXA-80-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251202-0005','2025-12-02','2025-12-02','13:15','6.21','adminpusat','2025-12-02 13:15:53');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-12-02 ','13:32:06');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MSCN-YLXB-1-0','00026956','EX ','CN COR BT SHB ','','GR','---','MS','MSCN','TOKO','INPUT1','853000','2025-12-02','853000','0.840','100.00','9','0','1015000.00','1','0.045', 'adminpusat','2025-12-02 13:36:42','0.830','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSCN','MSCN-YLXB-1-0','00026956');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MSCN-YLXB-1-0','MSCN','TOKO','INPUT1','100.00','0.840','0.830','1','0.840','0.830','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MSCN-YLXB-2-0','00026957','EX ','CN COR BT SHB ','','GR','---','MS','MSCN','TOKO','INPUT1','1502500','2025-12-02','1502500','1.480','100.00','9','0','1015000.00','1','0.045', 'adminpusat','2025-12-02 13:37:41','1.470','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSCN','MSCN-YLXB-2-0','00026957');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MSCN-YLXB-2-0','MSCN','TOKO','INPUT1','100.00','1.480','1.470','1','1.480','1.470','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MSKL-YLXB-3-0','00026958','EX ','KL ITALY ST 42CM KKT PER BLT SHB ','','GR','---','MS','MSKL','TOKO','INPUT1','3045000','2025-12-02','3045000','3.000','100.00','9','0','1015000.00','1','0.045', 'adminpusat','2025-12-02 13:39:13','2.990','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-YLXB-3-0','00026958');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MSKL-YLXB-3-0','MSKL','TOKO','INPUT1','100.00','3.000','2.990','1','3.000','2.990','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MSKL-YLXB-4-0','00026959','EX ','KL MILANO PJG 62CM KKT S SHB ','','GR','---','MS','MSKL','TOKO','INPUT1','7278000','2025-12-02','7278000','7.170','100.00','9','0','1015000.00','1','0.045', 'adminpusat','2025-12-02 13:40:30','7.160','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-YLXB-4-0','00026959');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MSKL-YLXB-4-0','MSKL','TOKO','INPUT1','100.00','7.170','7.160','1','7.170','7.160','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0006','1','MSCN-YLXB-1-0','1','0.840','0.840','TOKO','INPUT1','TOKO','BCNMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMS' WHERE kode_barang='MSCN-YLXB-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BCNMS','MSCN','MSCN-YLXB-1-0','100.00','1','0.840','0.830','1','0.840','0.830');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.840',berat_out_asli=berat_out_asli+'0.830',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MSCN-YLXB-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0006','2','MSCN-YLXB-2-0','1','1.480','1.480','TOKO','INPUT1','TOKO','BCNMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMS' WHERE kode_barang='MSCN-YLXB-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BCNMS','MSCN','MSCN-YLXB-2-0','100.00','1','1.480','1.470','1','1.480','1.470');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.480',berat_out_asli=berat_out_asli+'1.470',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MSCN-YLXB-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251202-0006','2025-12-02','2025-12-02','13:54','2.32','adminpusat','2025-12-02 13:54:18');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0007','1','MSKL-YLXB-3-0','1','3.000','3.000','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-YLXB-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKLMS','MSKL','MSKL-YLXB-3-0','100.00','1','3.000','2.990','1','3.000','2.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.000',berat_out_asli=berat_out_asli+'2.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MSKL-YLXB-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0007','2','MSKL-YLXB-4-0','1','7.170','7.170','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-YLXB-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKLMS','MSKL','MSKL-YLXB-4-0','100.00','1','7.170','7.160','1','7.170','7.160');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'7.170',berat_out_asli=berat_out_asli+'7.160',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MSKL-YLXB-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251202-0007','2025-12-02','2025-12-02','13:54','10.17','adminpusat','2025-12-02 13:54:59');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTAT-YLXB-5-0','00026960','EX ','AT COR KLP BT SHB ','','GR','---','MT','MTAT','TOKO','INPUT1','3428000','2025-12-02','3428000','1.970','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:07:04','1.960','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTAT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTAT','MTAT-YLXB-5-0','00026960');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTAT-YLXB-5-0','MTAT','TOKO','INPUT1','100.00','1.970','1.960','1','1.970','1.960','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTAT-YLXB-6-0','00026961','EX ','AT COR KLP TDK BT SHB ','','GR','---','MT','MTAT','TOKO','INPUT1','3445500','2025-12-02','3445500','1.980','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:08:22','1.970','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTAT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTAT','MTAT-YLXB-6-0','00026961');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTAT-YLXB-6-0','MTAT','TOKO','INPUT1','100.00','1.980','1.970','1','1.980','1.970','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTAT-YLXB-7-0','00026962','EX ','AT JEPSI DEWI 3 MK ','','GR','---','MT','MTAT','TOKO','INPUT1','1827000','2025-12-02','1827000','1.050','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:11:40','1.040','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTAT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTAT','MTAT-YLXB-7-0','00026962');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTAT-YLXB-7-0','MTAT','TOKO','INPUT1','100.00','1.050','1.040','1','1.050','1.040','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTAT-YLXB-8-0','00026963','EX ','AT JEPIT BRILLIANT SHB ','','GR','---','MT','MTAT','TOKO','INPUT1','1949000','2025-12-02','1949000','1.120','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:12:48','1.110','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTAT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTAT','MTAT-YLXB-8-0','00026963');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTAT-YLXB-8-0','MTAT','TOKO','INPUT1','100.00','1.120','1.110','1','1.120','1.110','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTAT-YLXB-9-0','00026964','EX ','AT KLP KTK BT SHB ','','GR','---','MT','MTAT','TOKO','INPUT1','2349000','2025-12-02','2349000','1.350','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:13:47','1.340','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTAT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTAT','MTAT-YLXB-9-0','00026964');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTAT-YLXB-9-0','MTAT','TOKO','INPUT1','100.00','1.350','1.340','1','1.350','1.340','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTAT-YLXB-10-0','00026965','EX ','AT KLP KTK BT SHB ','','GR','---','MT','MTAT','TOKO','INPUT1','2349000','2025-12-02','2349000','1.350','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:15:08','1.340','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTAT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTAT','MTAT-YLXB-10-0','00026965');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTAT-YLXB-10-0','MTAT','TOKO','INPUT1','100.00','1.350','1.340','1','1.350','1.340','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTAT-YLXB-11-0','00026966','EX ','AT CAP BOLA PSR SHB ','','GR','---','MT','MTAT','TOKO','INPUT1','2714500','2025-12-02','2714500','1.560','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:16:52','1.550','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTAT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTAT','MTAT-YLXB-11-0','00026966');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTAT-YLXB-11-0','MTAT','TOKO','INPUT1','100.00','1.560','1.550','1','1.560','1.550','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTAT-YLXB-12-0','00026967','EX ','AT CAP KAWAT BTR BT SHB ','','GR','---','MT','MTAT','TOKO','INPUT1','3967500','2025-12-02','3967500','2.280','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:18:06','2.270','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTAT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTAT','MTAT-YLXB-12-0','00026967');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTAT-YLXB-12-0','MTAT','TOKO','INPUT1','100.00','2.280','2.270','1','2.280','2.270','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-YLXB-13-0','00026968','EX ','CN ANAK COR TDK BT MK ','','GR','---','MT','MTCN','TOKO','INPUT1','1218000','2025-12-02','1218000','0.700','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:20:54','0.690','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-YLXB-13-0','00026968');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTCN-YLXB-13-0','MTCN','TOKO','INPUT1','100.00','0.700','0.690','1','0.700','0.690','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-YLXB-14-0','00026969','EX ','CN ANAK COR CAT MK ','','GR','---','MT','MTCN','TOKO','INPUT1','1009500','2025-12-02','1009500','0.580','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:22:38','0.570','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-YLXB-14-0','00026969');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTCN-YLXB-14-0','MTCN','TOKO','INPUT1','100.00','0.580','0.570','1','0.580','0.570','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-YLXB-15-0','00026970','EX ','CN PLINTIR SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','5116000','2025-12-02','5116000','2.940','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:23:58','2.930','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-YLXB-15-0','00026970');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTCN-YLXB-15-0','MTCN','TOKO','INPUT1','100.00','2.940','2.930','1','2.940','2.930','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-YLXB-16-0','00026971','EX ','CN CAP DOLLAR SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','1827000','2025-12-02','1827000','1.050','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:24:54','1.040','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-YLXB-16-0','00026971');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTCN-YLXB-16-0','MTCN','TOKO','INPUT1','100.00','1.050','1.040','1','1.050','1.040','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-YLXB-17-0','00026972','EX ','CN COR TDK BT SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','1792500','2025-12-02','1792500','1.030','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:25:47','1.020','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-YLXB-17-0','00026972');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTCN-YLXB-17-0','MTCN','TOKO','INPUT1','100.00','1.030','1.020','1','1.030','1.020','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-YLXB-18-0','00026973','EX ','CN COR TDK BT SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','3149500','2025-12-02','3149500','1.810','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:26:46','1.800','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-YLXB-18-0','00026973');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTCN-YLXB-18-0','MTCN','TOKO','INPUT1','100.00','1.810','1.800','1','1.810','1.800','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-YLXB-19-0','00026974','EX ','CN COR TDK BT SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','5603000','2025-12-02','5603000','3.220','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:27:34','3.210','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-YLXB-19-0','00026974');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTCN-YLXB-19-0','MTCN','TOKO','INPUT1','100.00','3.220','3.210','1','3.220','3.210','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-YLXB-20-0','00026975','EX ','CN COR BT UBS ','','GR','---','MT','MTCN','TOKO','INPUT1','4420000','2025-12-02','4420000','2.540','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:28:38','2.530','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-YLXB-20-0','00026975');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTCN-YLXB-20-0','MTCN','TOKO','INPUT1','100.00','2.540','2.530','1','2.540','2.530','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-YLXB-21-0','00026976','EX ','CN COR BT VC HTM MK ','','GR','---','MT','MTCN','TOKO','INPUT1','2053500','2025-12-02','2053500','1.180','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:29:39','1.170','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-YLXB-21-0','00026976');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTCN-YLXB-21-0','MTCN','TOKO','INPUT1','100.00','1.180','1.170','1','1.180','1.170','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-YLXB-22-0','00026977','EX ','CN COR EROPA SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','6560000','2025-12-02','6560000','3.770','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:30:55','3.760','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-YLXB-22-0','00026977');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTCN-YLXB-22-0','MTCN','TOKO','INPUT1','100.00','3.770','3.760','1','3.770','3.760','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-YLXB-23-0','00026978','EX ','CN COR TDK BT SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','1775000','2025-12-02','1775000','1.020','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:32:18','1.010','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-YLXB-23-0','00026978');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTCN-YLXB-23-0','MTCN','TOKO','INPUT1','100.00','1.020','1.010','1','1.020','1.010','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-YLXB-24-0','00026979','EX ','CN COR TDK BT SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','2158000','2025-12-02','2158000','1.240','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:33:15','1.230','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-YLXB-24-0','00026979');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTCN-YLXB-24-0','MTCN','TOKO','INPUT1','100.00','1.240','1.230','1','1.240','1.230','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-YLXB-25-0','00026980','EX ','CN COR TDK BT SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','1810000','2025-12-02','1810000','1.040','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:34:17','1.030','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-YLXB-25-0','00026980');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTCN-YLXB-25-0','MTCN','TOKO','INPUT1','100.00','1.040','1.030','1','1.040','1.030','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-YLXB-26-0','00026981','EX ','CN COR TDK BT SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','2123000','2025-12-02','2123000','1.220','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:35:38','1.210','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-YLXB-26-0','00026981');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTCN-YLXB-26-0','MTCN','TOKO','INPUT1','100.00','1.220','1.210','1','1.220','1.210','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-YLXB-27-0','00026982','EX ','CN COR TDK BT SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','4628500','2025-12-02','4628500','2.660','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:36:43','2.650','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-YLXB-27-0','00026982');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTCN-YLXB-27-0','MTCN','TOKO','INPUT1','100.00','2.660','2.650','1','2.660','2.650','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTCN-YLXB-28-0','00026983','EX ','CN COR TDK BT SHB ','','GR','---','MT','MTCN','TOKO','INPUT1','3811000','2025-12-02','3811000','2.190','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:37:51','2.180','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTCN','MTCN-YLXB-28-0','00026983');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTCN-YLXB-28-0','MTCN','TOKO','INPUT1','100.00','2.190','2.180','1','2.190','2.180','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGL-YLXB-29-0','00026984','EX ','GL VIGARU ENGKEL MN14 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','5342000','2025-12-02','5342000','3.070','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:41:19','3.060','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXB-29-0','00026984');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTGL-YLXB-29-0','MTGL','TOKO','INPUT1','100.00','3.070','3.060','1','3.070','3.060','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGL-YLXB-30-0','00026985','EX ','GL CASTELI BTR CDY 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','5168000','2025-12-02','5168000','2.970','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:42:29','2.960','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXB-30-0','00026985');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTGL-YLXB-30-0','MTGL','TOKO','INPUT1','100.00','2.970','2.960','1','2.970','2.960','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGL-YLXB-31-0','00026986','EX ','GL VANESA DOLLAR 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','6107500','2025-12-02','6107500','3.510','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:43:46','3.500','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXB-31-0','00026986');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTGL-YLXB-31-0','MTGL','TOKO','INPUT1','100.00','3.510','3.500','1','3.510','3.500','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGL-YLXB-32-0','00026987','EX ','GL VANESA PLAT MN BT 17CM KKT PER MK ','','GR','---','MT','MTGL','TOKO','INPUT1','7778000','2025-12-02','7778000','4.470','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:45:09','4.460','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXB-32-0','00026987');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTGL-YLXB-32-0','MTGL','TOKO','INPUT1','100.00','4.470','4.460','1','4.470','4.460','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGL-YLXB-33-0','00026988','EX ','GL CAP HOLLO 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','11275500','2025-12-02','11275500','6.480','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:46:49','6.470','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXB-33-0','00026988');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTGL-YLXB-33-0','MTGL','TOKO','INPUT1','100.00','6.480','6.470','1','6.480','6.470','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGL-YLXB-34-0','00026989','EX ','GL BANGKOK TMBL SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','5272500','2025-12-02','5272500','3.030','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:47:55','3.020','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXB-34-0','00026989');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTGL-YLXB-34-0','MTGL','TOKO','INPUT1','100.00','3.030','3.020','1','3.030','3.020','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGL-YLXB-35-0','00026990','EX ','GL BANGKOK TMBL SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','5237500','2025-12-02','5237500','3.010','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:48:13','3.000','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXB-35-0','00026990');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTGL-YLXB-35-0','MTGL','TOKO','INPUT1','100.00','3.010','3.000','1','3.010','3.000','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGL-YLXB-36-0','00026991','EX ','GL BANGKOK TMBL SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','8700000','2025-12-02','8700000','5.000','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:48:56','4.990','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXB-36-0','00026991');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTGL-YLXB-36-0','MTGL','TOKO','INPUT1','100.00','5.000','4.990','1','5.000','4.990','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGL-YLXB-37-0','00026992','EX ','GL PIPA BT SMBR PTH BTG ','','GR','---','MT','MTGL','TOKO','INPUT1','15956000','2025-12-02','15956000','9.170','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 14:49:55','9.160','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-YLXB-37-0','00026992');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTGL-YLXB-37-0','MTGL','TOKO','INPUT1','100.00','9.170','9.160','1','9.170','9.160','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGW-YLXB-38-0','00026993','EX ','GW COR BT SHB ','','GR','---','MT','MTGW','TOKO','INPUT1','1357500','2025-12-02','1357500','0.780','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 15:04:41','0.770','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGW' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGW','MTGW-YLXB-38-0','00026993');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTGW-YLXB-38-0','MTGW','TOKO','INPUT1','100.00','0.780','0.770','1','0.780','0.770','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGW-YLXB-39-0','00026994','EX ','GW CAP TDK BT MK ','','GR','---','MT','MTGW','TOKO','INPUT1','1253000','2025-12-02','1253000','0.720','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 15:06:27','0.710','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGW' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGW','MTGW-YLXB-39-0','00026994');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTGW-YLXB-39-0','MTGW','TOKO','INPUT1','100.00','0.720','0.710','1','0.720','0.710','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGW-YLXB-40-0','00026995','EX ','GW CAP BL PSR SHB ','','GR','---','MT','MTGW','TOKO','INPUT1','1601000','2025-12-02','1601000','0.920','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 15:07:33','0.910','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGW' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGW','MTGW-YLXB-40-0','00026995');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTGW-YLXB-40-0','MTGW','TOKO','INPUT1','100.00','0.920','0.910','1','0.920','0.910','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTGW-YLXB-41-0','00026996','EX ','GW COR DB MHL SHB ','','GR','---','MT','MTGW','TOKO','INPUT1','2297000','2025-12-02','2297000','1.320','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 15:08:28','1.310','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTGW' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGW','MTGW-YLXB-41-0','00026996');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTGW-YLXB-41-0','MTGW','TOKO','INPUT1','100.00','1.320','1.310','1','1.320','1.310','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-YLXB-42-0','00026997','EX ','KL FANCY 43CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','8596000','2025-12-02','8596000','4.940','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 15:10:47','4.930','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-YLXB-42-0','00026997');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTKL-YLXB-42-0','MTKL','TOKO','INPUT1','100.00','4.940','4.930','1','4.940','4.930','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-YLXB-43-0','00026998','EX ','KL VANESSA DB 43CM KKT PER SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','7273500','2025-12-02','7273500','4.180','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 15:12:08','4.170','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-YLXB-43-0','00026998');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTKL-YLXB-43-0','MTKL','TOKO','INPUT1','100.00','4.180','4.170','1','4.180','4.170','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-YLXB-44-0','00026999','EX ','KL VANESSA DB PJG 67CM KKT PER SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','29093000','2025-12-02','29093000','16.720','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 15:13:54','16.710','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-YLXB-44-0','00026999');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTKL-YLXB-44-0','MTKL','TOKO','INPUT1','100.00','16.720','16.710','1','16.720','16.710','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-YLXB-45-0','00027000','EX ','LT COR BT SHB ','','GR','---','MT','MTLT','TOKO','INPUT1','2279500','2025-12-02','2279500','1.310','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 15:15:08','1.300','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-YLXB-45-0','00027000');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTLT-YLXB-45-0','MTLT','TOKO','INPUT1','100.00','1.310','1.300','1','1.310','1.300','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-YLXB-46-0','00027001','EX ','LT COR TDK BT SMBR PTH BG3 ','','GR','---','MT','MTLT','TOKO','INPUT1','5742000','2025-12-02','5742000','3.300','100.00','16','0','1740000.00','1','0.045', 'adminpusat','2025-12-02 15:16:06','3.290','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-YLXB-46-0','00027001');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTLT-YLXB-46-0','MTLT','TOKO','INPUT1','100.00','3.300','3.290','1','3.300','3.290','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTLT-YLXB-47-0','00027002','JP EX ','JEPIT BUNGA SHB ','JP','GR','---','MT','MTLT','TOKO','INPUT1','10231500','2025-12-02','10231500','5.880','100.00','16','294000','1740000.00','1','0.045', 'adminpusat','2025-12-02 15:17:50','5.870','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTLT','MTLT-YLXB-47-0','00027002');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-02','MTLT-YLXB-47-0','MTLT','TOKO','INPUT1','100.00','5.880','5.870','1','5.880','5.870','1');
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('MTCN-YLXB-17-0','00026972','00026972','CN COR TDK BT SHB ','CN COR BT SHB','','','1792500','1792500',' 0','0','adminpusat','2025-12-02 15:20:52');
UPDATE tm_barang SET nama_barang='CN COR BT SHB' ,nama_atribut='' ,kode_intern='EX ', kadar_cetak='16.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MTCN-YLXB-17-0' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('MTCN-YLXB-18-0','00026973','00026973','CN COR TDK BT SHB ','CN COR BT SHB','','','3149500','3149500',' 0','0','adminpusat','2025-12-02 15:21:06');
UPDATE tm_barang SET nama_barang='CN COR BT SHB' ,nama_atribut='' ,kode_intern='EX ', kadar_cetak='16.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MTCN-YLXB-18-0' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('MTCN-YLXB-19-0','00026974','00026974','CN COR TDK BT SHB ','CN COR BT SHB','','','5603000','5603000',' 0','0','adminpusat','2025-12-02 15:21:17');
UPDATE tm_barang SET nama_barang='CN COR BT SHB' ,nama_atribut='' ,kode_intern='EX ', kadar_cetak='16.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MTCN-YLXB-19-0' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('MTGL-YLXB-32-0','00026987','00026987','GL VANESA PLAT MN BT 17CM KKT PER MK ','GL VANESSA PLAT MN BT 17CM KKT PER MK','','','7778000','7778000',' 0','0','adminpusat','2025-12-02 15:21:45');
UPDATE tm_barang SET nama_barang='GL VANESSA PLAT MN BT 17CM KKT PER MK' ,nama_atribut='' ,kode_intern='EX ', kadar_cetak='16.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MTGL-YLXB-32-0' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('MTGW-YLXB-38-0','00026993','00026993','GW COR BT SHB ','GW CAP BT SHB','','','1357500','1357500',' 0','0','adminpusat','2025-12-02 15:22:16');
UPDATE tm_barang SET nama_barang='GW CAP BT SHB' ,nama_atribut='' ,kode_intern='EX ', kadar_cetak='16.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MTGW-YLXB-38-0' LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0008','1','MTAT-YLXB-5-0','1','1.970','1.970','TOKO','INPUT1','TOKO','BKATMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKATMT' WHERE kode_barang='MTAT-YLXB-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKATMT','MTAT','MTAT-YLXB-5-0','100.00','1','1.970','1.960','1','1.970','1.960');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.970',berat_out_asli=berat_out_asli+'1.960',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTAT-YLXB-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0008','2','MTAT-YLXB-6-0','1','1.980','1.980','TOKO','INPUT1','TOKO','BKATMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKATMT' WHERE kode_barang='MTAT-YLXB-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKATMT','MTAT','MTAT-YLXB-6-0','100.00','1','1.980','1.970','1','1.980','1.970');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.980',berat_out_asli=berat_out_asli+'1.970',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTAT-YLXB-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0008','3','MTAT-YLXB-7-0','1','1.050','1.050','TOKO','INPUT1','TOKO','BKATMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKATMT' WHERE kode_barang='MTAT-YLXB-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKATMT','MTAT','MTAT-YLXB-7-0','100.00','1','1.050','1.040','1','1.050','1.040');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.050',berat_out_asli=berat_out_asli+'1.040',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTAT-YLXB-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0008','4','MTAT-YLXB-8-0','1','1.120','1.120','TOKO','INPUT1','TOKO','BKATMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKATMT' WHERE kode_barang='MTAT-YLXB-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKATMT','MTAT','MTAT-YLXB-8-0','100.00','1','1.120','1.110','1','1.120','1.110');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.120',berat_out_asli=berat_out_asli+'1.110',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTAT-YLXB-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0008','5','MTAT-YLXB-9-0','1','1.350','1.350','TOKO','INPUT1','TOKO','BKATMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKATMT' WHERE kode_barang='MTAT-YLXB-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKATMT','MTAT','MTAT-YLXB-9-0','100.00','1','1.350','1.340','1','1.350','1.340');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.350',berat_out_asli=berat_out_asli+'1.340',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTAT-YLXB-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0008','6','MTAT-YLXB-10-0','1','1.350','1.350','TOKO','INPUT1','TOKO','BKATMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKATMT' WHERE kode_barang='MTAT-YLXB-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKATMT','MTAT','MTAT-YLXB-10-0','100.00','1','1.350','1.340','1','1.350','1.340');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.350',berat_out_asli=berat_out_asli+'1.340',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTAT-YLXB-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0008','7','MTAT-YLXB-11-0','1','1.560','1.560','TOKO','INPUT1','TOKO','BKATMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKATMT' WHERE kode_barang='MTAT-YLXB-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKATMT','MTAT','MTAT-YLXB-11-0','100.00','1','1.560','1.550','1','1.560','1.550');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.560',berat_out_asli=berat_out_asli+'1.550',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTAT-YLXB-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0008','8','MTAT-YLXB-12-0','1','2.280','2.280','TOKO','INPUT1','TOKO','BKATMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKATMT' WHERE kode_barang='MTAT-YLXB-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKATMT','MTAT','MTAT-YLXB-12-0','100.00','1','2.280','2.270','1','2.280','2.270');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.280',berat_out_asli=berat_out_asli+'2.270',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTAT-YLXB-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251202-0008','2025-12-02','2025-12-02','16:20','12.66','adminpusat','2025-12-02 16:21:14');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0009','1','MTCN-YLXB-13-0','1','0.700','0.700','TOKO','INPUT1','TOKO','BKCNMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-YLXB-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKCNMT','MTCN','MTCN-YLXB-13-0','100.00','1','0.700','0.690','1','0.700','0.690');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.700',berat_out_asli=berat_out_asli+'0.690',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTCN-YLXB-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0009','2','MTCN-YLXB-14-0','1','0.580','0.580','TOKO','INPUT1','TOKO','BKCNMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-YLXB-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKCNMT','MTCN','MTCN-YLXB-14-0','100.00','1','0.580','0.570','1','0.580','0.570');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.580',berat_out_asli=berat_out_asli+'0.570',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTCN-YLXB-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0009','3','MTCN-YLXB-15-0','1','2.940','2.940','TOKO','INPUT1','TOKO','BKCNMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-YLXB-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKCNMT','MTCN','MTCN-YLXB-15-0','100.00','1','2.940','2.930','1','2.940','2.930');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.940',berat_out_asli=berat_out_asli+'2.930',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTCN-YLXB-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0009','4','MTCN-YLXB-16-0','1','1.050','1.050','TOKO','INPUT1','TOKO','BKCNMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-YLXB-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKCNMT','MTCN','MTCN-YLXB-16-0','100.00','1','1.050','1.040','1','1.050','1.040');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.050',berat_out_asli=berat_out_asli+'1.040',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTCN-YLXB-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0009','5','MTCN-YLXB-17-0','1','1.030','1.030','TOKO','INPUT1','TOKO','BKCNMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-YLXB-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKCNMT','MTCN','MTCN-YLXB-17-0','100.00','1','1.030','1.020','1','1.030','1.020');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.030',berat_out_asli=berat_out_asli+'1.020',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTCN-YLXB-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0009','6','MTCN-YLXB-18-0','1','1.810','1.810','TOKO','INPUT1','TOKO','BKCNMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-YLXB-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKCNMT','MTCN','MTCN-YLXB-18-0','100.00','1','1.810','1.800','1','1.810','1.800');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.810',berat_out_asli=berat_out_asli+'1.800',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTCN-YLXB-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0009','7','MTCN-YLXB-19-0','1','3.220','3.220','TOKO','INPUT1','TOKO','BKCNMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-YLXB-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKCNMT','MTCN','MTCN-YLXB-19-0','100.00','1','3.220','3.210','1','3.220','3.210');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.220',berat_out_asli=berat_out_asli+'3.210',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTCN-YLXB-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0009','8','MTCN-YLXB-20-0','1','2.540','2.540','TOKO','INPUT1','TOKO','BKCNMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-YLXB-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKCNMT','MTCN','MTCN-YLXB-20-0','100.00','1','2.540','2.530','1','2.540','2.530');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.540',berat_out_asli=berat_out_asli+'2.530',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTCN-YLXB-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0009','9','MTCN-YLXB-21-0','1','1.180','1.180','TOKO','INPUT1','TOKO','BKCNMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-YLXB-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKCNMT','MTCN','MTCN-YLXB-21-0','100.00','1','1.180','1.170','1','1.180','1.170');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.180',berat_out_asli=berat_out_asli+'1.170',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTCN-YLXB-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0009','10','MTCN-YLXB-22-0','1','3.770','3.770','TOKO','INPUT1','TOKO','BKCNMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-YLXB-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKCNMT','MTCN','MTCN-YLXB-22-0','100.00','1','3.770','3.760','1','3.770','3.760');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.770',berat_out_asli=berat_out_asli+'3.760',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTCN-YLXB-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0009','11','MTCN-YLXB-23-0','1','1.020','1.020','TOKO','INPUT1','TOKO','BKCNMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-YLXB-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKCNMT','MTCN','MTCN-YLXB-23-0','100.00','1','1.020','1.010','1','1.020','1.010');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.020',berat_out_asli=berat_out_asli+'1.010',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTCN-YLXB-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0009','12','MTCN-YLXB-24-0','1','1.240','1.240','TOKO','INPUT1','TOKO','BKCNMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-YLXB-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKCNMT','MTCN','MTCN-YLXB-24-0','100.00','1','1.240','1.230','1','1.240','1.230');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.240',berat_out_asli=berat_out_asli+'1.230',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTCN-YLXB-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0009','13','MTCN-YLXB-25-0','1','1.040','1.040','TOKO','INPUT1','TOKO','BKCNMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-YLXB-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKCNMT','MTCN','MTCN-YLXB-25-0','100.00','1','1.040','1.030','1','1.040','1.030');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.040',berat_out_asli=berat_out_asli+'1.030',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTCN-YLXB-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0009','14','MTCN-YLXB-26-0','1','1.220','1.220','TOKO','INPUT1','TOKO','BKCNMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-YLXB-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKCNMT','MTCN','MTCN-YLXB-26-0','100.00','1','1.220','1.210','1','1.220','1.210');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.220',berat_out_asli=berat_out_asli+'1.210',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTCN-YLXB-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0009','15','MTCN-YLXB-27-0','1','2.660','2.660','TOKO','INPUT1','TOKO','BKCNMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-YLXB-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKCNMT','MTCN','MTCN-YLXB-27-0','100.00','1','2.660','2.650','1','2.660','2.650');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.660',berat_out_asli=berat_out_asli+'2.650',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTCN-YLXB-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0009','16','MTCN-YLXB-28-0','1','2.190','2.190','TOKO','INPUT1','TOKO','BKCNMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKCNMT' WHERE kode_barang='MTCN-YLXB-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKCNMT','MTCN','MTCN-YLXB-28-0','100.00','1','2.190','2.180','1','2.190','2.180');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.190',berat_out_asli=berat_out_asli+'2.180',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTCN-YLXB-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251202-0009','2025-12-02','2025-12-02','16:21','28.19','adminpusat','2025-12-02 16:22:43');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0010','1','MTGL-YLXB-29-0','1','3.070','3.070','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXB-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKGLMT','MTGL','MTGL-YLXB-29-0','100.00','1','3.070','3.060','1','3.070','3.060');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.070',berat_out_asli=berat_out_asli+'3.060',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTGL-YLXB-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0010','2','MTGL-YLXB-30-0','1','2.970','2.970','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXB-30-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKGLMT','MTGL','MTGL-YLXB-30-0','100.00','1','2.970','2.960','1','2.970','2.960');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.970',berat_out_asli=berat_out_asli+'2.960',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTGL-YLXB-30-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0010','3','MTGL-YLXB-31-0','1','3.510','3.510','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXB-31-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKGLMT','MTGL','MTGL-YLXB-31-0','100.00','1','3.510','3.500','1','3.510','3.500');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.510',berat_out_asli=berat_out_asli+'3.500',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTGL-YLXB-31-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0010','4','MTGL-YLXB-32-0','1','4.470','4.470','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXB-32-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKGLMT','MTGL','MTGL-YLXB-32-0','100.00','1','4.470','4.460','1','4.470','4.460');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.470',berat_out_asli=berat_out_asli+'4.460',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTGL-YLXB-32-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0010','5','MTGL-YLXB-33-0','1','6.480','6.480','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXB-33-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKGLMT','MTGL','MTGL-YLXB-33-0','100.00','1','6.480','6.470','1','6.480','6.470');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'6.480',berat_out_asli=berat_out_asli+'6.470',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTGL-YLXB-33-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0010','6','MTGL-YLXB-34-0','1','3.030','3.030','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXB-34-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKGLMT','MTGL','MTGL-YLXB-34-0','100.00','1','3.030','3.020','1','3.030','3.020');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.030',berat_out_asli=berat_out_asli+'3.020',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTGL-YLXB-34-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0010','7','MTGL-YLXB-35-0','1','3.010','3.010','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXB-35-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKGLMT','MTGL','MTGL-YLXB-35-0','100.00','1','3.010','3.000','1','3.010','3.000');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.010',berat_out_asli=berat_out_asli+'3.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTGL-YLXB-35-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0010','8','MTGL-YLXB-36-0','1','5.000','5.000','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXB-36-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKGLMT','MTGL','MTGL-YLXB-36-0','100.00','1','5.000','4.990','1','5.000','4.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.000',berat_out_asli=berat_out_asli+'4.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTGL-YLXB-36-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0010','9','MTGL-YLXB-37-0','1','9.170','9.170','TOKO','INPUT1','TOKO','BKGLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-YLXB-37-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKGLMT','MTGL','MTGL-YLXB-37-0','100.00','1','9.170','9.160','1','9.170','9.160');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'9.170',berat_out_asli=berat_out_asli+'9.160',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTGL-YLXB-37-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251202-0010','2025-12-02','2025-12-02','16:22','40.71','adminpusat','2025-12-02 16:23:51');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0011','1','MTGW-YLXB-38-0','1','0.780','0.780','TOKO','INPUT1','TOKO','BKGWMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGWMT' WHERE kode_barang='MTGW-YLXB-38-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKGWMT','MTGW','MTGW-YLXB-38-0','100.00','1','0.780','0.770','1','0.780','0.770');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.780',berat_out_asli=berat_out_asli+'0.770',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTGW-YLXB-38-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0011','2','MTGW-YLXB-39-0','1','0.720','0.720','TOKO','INPUT1','TOKO','BKGWMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGWMT' WHERE kode_barang='MTGW-YLXB-39-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKGWMT','MTGW','MTGW-YLXB-39-0','100.00','1','0.720','0.710','1','0.720','0.710');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.720',berat_out_asli=berat_out_asli+'0.710',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTGW-YLXB-39-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0011','3','MTGW-YLXB-40-0','1','0.920','0.920','TOKO','INPUT1','TOKO','BKGWMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGWMT' WHERE kode_barang='MTGW-YLXB-40-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKGWMT','MTGW','MTGW-YLXB-40-0','100.00','1','0.920','0.910','1','0.920','0.910');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.920',berat_out_asli=berat_out_asli+'0.910',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTGW-YLXB-40-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0011','4','MTGW-YLXB-41-0','1','1.320','1.320','TOKO','INPUT1','TOKO','BKGWMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGWMT' WHERE kode_barang='MTGW-YLXB-41-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKGWMT','MTGW','MTGW-YLXB-41-0','100.00','1','1.320','1.310','1','1.320','1.310');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.320',berat_out_asli=berat_out_asli+'1.310',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTGW-YLXB-41-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251202-0011','2025-12-02','2025-12-02','16:24','3.74','adminpusat','2025-12-02 16:24:40');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0012','1','MTKL-YLXB-42-0','1','4.940','4.940','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-YLXB-42-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKKLMT','MTKL','MTKL-YLXB-42-0','100.00','1','4.940','4.930','1','4.940','4.930');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.940',berat_out_asli=berat_out_asli+'4.930',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTKL-YLXB-42-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0012','2','MTKL-YLXB-43-0','1','4.180','4.180','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-YLXB-43-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKKLMT','MTKL','MTKL-YLXB-43-0','100.00','1','4.180','4.170','1','4.180','4.170');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.180',berat_out_asli=berat_out_asli+'4.170',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTKL-YLXB-43-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0012','3','MTKL-YLXB-44-0','1','16.720','16.720','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-YLXB-44-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKKLMT','MTKL','MTKL-YLXB-44-0','100.00','1','16.720','16.710','1','16.720','16.710');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'16.720',berat_out_asli=berat_out_asli+'16.710',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTKL-YLXB-44-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251202-0012','2025-12-02','2025-12-02','16:24','25.84','adminpusat','2025-12-02 16:25:27');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0013','1','MTLT-YLXB-45-0','1','1.310','1.310','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-YLXB-45-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKLTMT','MTLT','MTLT-YLXB-45-0','100.00','1','1.310','1.300','1','1.310','1.300');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.310',berat_out_asli=berat_out_asli+'1.300',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTLT-YLXB-45-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0013','2','MTLT-YLXB-46-0','1','3.300','3.300','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-YLXB-46-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKLTMT','MTLT','MTLT-YLXB-46-0','100.00','1','3.300','3.290','1','3.300','3.290');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.300',berat_out_asli=berat_out_asli+'3.290',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTLT-YLXB-46-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251202-0013','3','MTLT-YLXB-47-0','1','5.880','5.880','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-YLXB-47-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-02','TOKO','BKLTMT','MTLT','MTLT-YLXB-47-0','100.00','1','5.880','5.870','1','5.880','5.870');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.880',berat_out_asli=berat_out_asli+'5.870',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-02' AND kode_barang='MTLT-YLXB-47-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251202-0013','2025-12-02','2025-12-02','16:25','10.49','adminpusat','2025-12-02 16:26:07');