INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-12 ','08:31:41');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-12','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-12';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-11';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-11';
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='2026-02-11' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-11';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-11';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-11';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-11';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202601 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
UPDATE tt_barang_saldo SET tanggal= '2026-02-12' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-11' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-02-12';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-12 ','09:56:34');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','1','MDGL-ZBAA-1-0','1','2.750','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-1-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-1-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-ZBAA-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.750',berat_out_asli='2.740', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.750',berat_akhir_asli =berat_akhir_asli-'2.740' WHERE kode_barang='MDGL-ZBAA-1-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','2','MDGL-ZBAA-2-0','1','2.030','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-2-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-2-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-ZBAA-2-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='MDGL-ZBAA-2-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','3','MDGL-ZBAA-3-0','1','2.270','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-3-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-3-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-ZBAA-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.270',berat_out_asli='2.260', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.270',berat_akhir_asli =berat_akhir_asli-'2.260' WHERE kode_barang='MDGL-ZBAA-3-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','4','MDGL-ZBAA-4-0','1','2.210','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-4-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-4-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-ZBAA-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.210',berat_out_asli='2.200', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.210',berat_akhir_asli =berat_akhir_asli-'2.200' WHERE kode_barang='MDGL-ZBAA-4-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','5','MDGL-ZBAA-5-0','1','2.370','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-5-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-5-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-ZBAA-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.370',berat_out_asli='2.360', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.370',berat_akhir_asli =berat_akhir_asli-'2.360' WHERE kode_barang='MDGL-ZBAA-5-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','6','MDGL-ZBAA-6-0','1','2.400','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-6-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-6-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-ZBAA-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.400',berat_out_asli='2.390', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.400',berat_akhir_asli =berat_akhir_asli-'2.390' WHERE kode_barang='MDGL-ZBAA-6-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','7','MDGL-ZBAA-7-0','1','2.760','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-7-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-7-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-ZBAA-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.760',berat_out_asli='2.750', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.760',berat_akhir_asli =berat_akhir_asli-'2.750' WHERE kode_barang='MDGL-ZBAA-7-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','8','MDGL-ZBAA-8-0','1','4.400','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-8-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-8-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-ZBAA-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.400',berat_out_asli='4.390', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.400',berat_akhir_asli =berat_akhir_asli-'4.390' WHERE kode_barang='MDGL-ZBAA-8-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','9','MDGL-ZBAA-9-0','1','2.560','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-9-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-9-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-ZBAA-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.560',berat_out_asli='2.550', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.560',berat_akhir_asli =berat_akhir_asli-'2.550' WHERE kode_barang='MDGL-ZBAA-9-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','10','MDGL-ZBAA-10-0','1','5.430','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-10-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-10-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-ZBAA-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.430',berat_out_asli='5.420', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.430',berat_akhir_asli =berat_akhir_asli-'5.420' WHERE kode_barang='MDGL-ZBAA-10-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','11','MDGL-ZBAA-11-0','1','3.110','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-11-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-11-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-ZBAA-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.110',berat_out_asli='3.100', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.110',berat_akhir_asli =berat_akhir_asli-'3.100' WHERE kode_barang='MDGL-ZBAA-11-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','12','MDGL-ZBAA-12-0','1','8.710','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-12-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-12-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-ZBAA-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='8.710',berat_out_asli='8.700', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'8.710',berat_akhir_asli =berat_akhir_asli-'8.700' WHERE kode_barang='MDGL-ZBAA-12-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','13','MDGL-ZBAA-13-0','1','9.850','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-13-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-13-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-ZBAA-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='9.850',berat_out_asli='9.840', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'9.850',berat_akhir_asli =berat_akhir_asli-'9.840' WHERE kode_barang='MDGL-ZBAA-13-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','14','MDGL-ZBAA-14-0','1','8.250','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-14-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-14-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-ZBAA-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='8.250',berat_out_asli='8.240', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'8.250',berat_akhir_asli =berat_akhir_asli-'8.240' WHERE kode_barang='MDGL-ZBAA-14-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','15','MDGL-ZBAA-15-0','1','6.410','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-15-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-15-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-ZBAA-15-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='6.410',berat_out_asli='6.400', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'6.410',berat_akhir_asli =berat_akhir_asli-'6.400' WHERE kode_barang='MDGL-ZBAA-15-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','16','MDGL-ZBAA-16-0','1','2.060','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-16-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-16-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-ZBAA-16-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.060',berat_out_asli='2.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.060',berat_akhir_asli =berat_akhir_asli-'2.050' WHERE kode_barang='MDGL-ZBAA-16-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','17','MDGL-ZBAA-17-0','1','2.580','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-17-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-17-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-ZBAA-17-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.580',berat_out_asli='2.570', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.580',berat_akhir_asli =berat_akhir_asli-'2.570' WHERE kode_barang='MDGL-ZBAA-17-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','18','MDGL-ZBAA-18-0','1','2.680','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-18-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-18-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-ZBAA-18-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.680',berat_out_asli='2.670', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.680',berat_akhir_asli =berat_akhir_asli-'2.670' WHERE kode_barang='MDGL-ZBAA-18-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','19','MDGL-ZBAA-19-0','1','2.270','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-19-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-19-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-ZBAA-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.270',berat_out_asli='2.260', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.270',berat_akhir_asli =berat_akhir_asli-'2.260' WHERE kode_barang='MDGL-ZBAA-19-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','20','MDGL-ZBAA-20-0','1','3.100','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-20-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-20-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-ZBAA-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.100',berat_out_asli='3.090', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.100',berat_akhir_asli =berat_akhir_asli-'3.090' WHERE kode_barang='MDGL-ZBAA-20-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','21','MDGL-ZBAA-21-0','1','2.920','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-21-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-21-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-ZBAA-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.920',berat_out_asli='2.910', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.920',berat_akhir_asli =berat_akhir_asli-'2.910' WHERE kode_barang='MDGL-ZBAA-21-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','22','MDGL-ZBAA-22-0','1','2.930','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-22-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-22-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-ZBAA-22-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.930',berat_out_asli='2.920', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.930',berat_akhir_asli =berat_akhir_asli-'2.920' WHERE kode_barang='MDGL-ZBAA-22-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','23','MDGL-ZBAA-23-0','1','2.460','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-23-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-23-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-ZBAA-23-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.460',berat_out_asli='2.450', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.460',berat_akhir_asli =berat_akhir_asli-'2.450' WHERE kode_barang='MDGL-ZBAA-23-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','24','MDGL-ZBAA-24-0','1','2.460','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-24-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-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-ZBAA-24-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.460',berat_out_asli='2.450', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.460',berat_akhir_asli =berat_akhir_asli-'2.450' WHERE kode_barang='MDGL-ZBAA-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-260212-0001','25','MDGL-ZBAA-25-0','1','2.880','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-25-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-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-ZBAA-25-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.880',berat_out_asli='2.870', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.880',berat_akhir_asli =berat_akhir_asli-'2.870' WHERE kode_barang='MDGL-ZBAA-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-260212-0001','26','MDGL-ZBAA-26-0','1','4.580','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-26-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-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-ZBAA-26-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.580',berat_out_asli='4.570', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.580',berat_akhir_asli =berat_akhir_asli-'4.570' WHERE kode_barang='MDGL-ZBAA-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-260212-0001','27','MDGL-ZBAA-27-0','1','3.440','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-27-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-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-ZBAA-27-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.440',berat_out_asli='3.430', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.440',berat_akhir_asli =berat_akhir_asli-'3.430' WHERE kode_barang='MDGL-ZBAA-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-260212-0001','28','MDGL-ZBAA-28-0','1','3.950','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-28-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-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-ZBAA-28-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.950',berat_out_asli='3.940', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.950',berat_akhir_asli =berat_akhir_asli-'3.940' WHERE kode_barang='MDGL-ZBAA-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-260212-0001','29','MDGL-ZBAA-29-0','1','3.600','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-29-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-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-ZBAA-29-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.600',berat_out_asli='3.590', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.600',berat_akhir_asli =berat_akhir_asli-'3.590' WHERE kode_barang='MDGL-ZBAA-29-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','30','MDGL-ZBAA-30-0','1','3.510','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-30-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-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='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-ZBAA-30-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.510',berat_out_asli='3.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.510',berat_akhir_asli =berat_akhir_asli-'3.500' WHERE kode_barang='MDGL-ZBAA-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-260212-0001','31','MDGL-ZBAA-31-0','1','5.730','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-31-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-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='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-ZBAA-31-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.730',berat_out_asli='5.720', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.730',berat_akhir_asli =berat_akhir_asli-'5.720' WHERE kode_barang='MDGL-ZBAA-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-260212-0001','32','MDGL-ZBAA-32-0','1','5.800','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-32-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-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='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-ZBAA-32-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.800',berat_out_asli='5.790', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.800',berat_akhir_asli =berat_akhir_asli-'5.790' WHERE kode_barang='MDGL-ZBAA-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-260212-0001','33','MDGL-ZBAA-33-0','1','4.330','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-33-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-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='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-ZBAA-33-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.330',berat_out_asli='4.320', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.330',berat_akhir_asli =berat_akhir_asli-'4.320' WHERE kode_barang='MDGL-ZBAA-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-260212-0001','34','MDGL-ZBAA-34-0','1','4.750','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-34-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-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='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-ZBAA-34-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.750',berat_out_asli='4.740', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.750',berat_akhir_asli =berat_akhir_asli-'4.740' WHERE kode_barang='MDGL-ZBAA-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-260212-0001','35','MDGL-ZBAA-35-0','1','4.340','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-35-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-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='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-ZBAA-35-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.340',berat_out_asli='4.330', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.340',berat_akhir_asli =berat_akhir_asli-'4.330' WHERE kode_barang='MDGL-ZBAA-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-260212-0001','36','MDGL-ZBAA-36-0','1','3.800','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-36-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-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='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-ZBAA-36-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.800',berat_out_asli='3.790', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.800',berat_akhir_asli =berat_akhir_asli-'3.790' WHERE kode_barang='MDGL-ZBAA-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-260212-0001','37','MDGL-ZBAA-37-0','1','3.440','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-37-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-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='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-ZBAA-37-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.440',berat_out_asli='3.430', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.440',berat_akhir_asli =berat_akhir_asli-'3.430' WHERE kode_barang='MDGL-ZBAA-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-260212-0001','38','MDGL-ZBAA-38-0','1','5.460','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-38-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-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='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-ZBAA-38-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.460',berat_out_asli='5.450', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.460',berat_akhir_asli =berat_akhir_asli-'5.450' WHERE kode_barang='MDGL-ZBAA-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-260212-0001','39','MDGL-ZBAA-39-0','1','8.740','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-39-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-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='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-ZBAA-39-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='8.740',berat_out_asli='8.730', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'8.740',berat_akhir_asli =berat_akhir_asli-'8.730' WHERE kode_barang='MDGL-ZBAA-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-260212-0001','40','MDGL-ZBAA-40-0','1','5.140','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-40-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-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='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-ZBAA-40-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.140',berat_out_asli='5.130', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.140',berat_akhir_asli =berat_akhir_asli-'5.130' WHERE kode_barang='MDGL-ZBAA-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-260212-0001','41','MDGL-ZBAA-41-0','1','13.770','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-41-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-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='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-ZBAA-41-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='13.770',berat_out_asli='13.760', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'13.770',berat_akhir_asli =berat_akhir_asli-'13.760' WHERE kode_barang='MDGL-ZBAA-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-260212-0001','42','MDGL-ZBAA-42-0','1','10.820','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-42-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-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='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-ZBAA-42-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='10.820',berat_out_asli='10.810', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.820',berat_akhir_asli =berat_akhir_asli-'10.810' WHERE kode_barang='MDGL-ZBAA-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-260212-0001','43','MDGL-ZBAA-43-0','1','10.750','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-43-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-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='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-ZBAA-43-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='10.750',berat_out_asli='10.740', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.750',berat_akhir_asli =berat_akhir_asli-'10.740' WHERE kode_barang='MDGL-ZBAA-43-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','44','MDGL-ZBAA-44-0','1','8.750','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-44-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-44-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-ZBAA-44-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='8.750',berat_out_asli='8.740', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'8.750',berat_akhir_asli =berat_akhir_asli-'8.740' WHERE kode_barang='MDGL-ZBAA-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-260212-0001','45','MDGL-ZBAA-45-0','1','12.780','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-45-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-45-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-ZBAA-45-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='12.780',berat_out_asli='12.770', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'12.780',berat_akhir_asli =berat_akhir_asli-'12.770' WHERE kode_barang='MDGL-ZBAA-45-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260212-0001','46','MDGL-ZBAA-46-0','1','12.530','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-46-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-46-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-ZBAA-46-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='12.530',berat_out_asli='12.520', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'12.530',berat_akhir_asli =berat_akhir_asli-'12.520' WHERE kode_barang='MDGL-ZBAA-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-260212-0001','47','MDGL-ZBAA-47-0','1','18.540','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-47-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-47-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-ZBAA-47-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='18.540',berat_out_asli='18.530', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'18.540',berat_akhir_asli =berat_akhir_asli-'18.530' WHERE kode_barang='MDGL-ZBAA-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-260212-0001','48','MDGL-ZBAA-48-0','1','13.340','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBAA-48-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-ZBAA-48-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-ZBAA-48-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='13.340',berat_out_asli='13.330', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'13.340',berat_akhir_asli =berat_akhir_asli-'13.330' WHERE kode_barang='MDGL-ZBAA-48-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-260212-0001','2026-02-12','2026-02-12','09:57','13.340','adminpusat','260212');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-12 ','09:58:44');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-12 ','10:02:34');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-12 ','10:22:17');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-12 ','10:55:32');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-12 ','12:44:50');
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-ZBAB-1-0','00028065','EX ','CN COR BT MK ','','GR','---','MS','MSCN','TOKO','INPUT1','1406000','2026-02-12','1406000','1.120','100.00','9','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 12:50:32','1.110','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-ZBAB-1-0','00028065');
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 ('2026-02-12','MSCN-ZBAB-1-0','MSCN','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 ('MSCN-ZBAB-2-0','00028066','EX ','CN COR BT MK ','','GR','---','MS','MSCN','TOKO','INPUT1','1556500','2026-02-12','1556500','1.240','100.00','9','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 12:52:38','1.230','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-ZBAB-2-0','00028066');
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 ('2026-02-12','MSCN-ZBAB-2-0','MSCN','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 ('MSGL-ZBAB-3-0','00028067','EX ','GL BABY PLINTIR 1 BEL SHB ','','GR','---','MS','MSGL','TOKO','INPUT1','3025000','2026-02-12','3025000','2.410','100.00','9','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 12:56:20','2.400','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSGL','MSGL-ZBAB-3-0','00028067');
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 ('2026-02-12','MSGL-ZBAB-3-0','MSGL','TOKO','INPUT1','100.00','2.410','2.400','1','2.410','2.400','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-ZBAB-4-0','00028068','EX ','KL MILANO 44CM KKT S SHB ','','GR','---','MS','MSKL','TOKO','INPUT1','3702500','2026-02-12','3702500','2.950','100.00','9','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 13:00:16','2.940','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-ZBAB-4-0','00028068');
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 ('2026-02-12','MSKL-ZBAB-4-0','MSKL','TOKO','INPUT1','100.00','2.950','2.940','1','2.950','2.940','1');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-12 ','13:31:11');
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-260212-0001','1','MSCN-ZBAB-1-0','1','1.120','1.120','TOKO','INPUT1','TOKO','BCNMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMS' WHERE kode_barang='MSCN-ZBAB-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('2026-02-12','TOKO','BCNMS','MSCN','MSCN-ZBAB-1-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='2026-02-12' AND kode_barang='MSCN-ZBAB-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-260212-0001','2','MSCN-ZBAB-2-0','1','1.240','1.240','TOKO','INPUT1','TOKO','BCNMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMS' WHERE kode_barang='MSCN-ZBAB-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('2026-02-12','TOKO','BCNMS','MSCN','MSCN-ZBAB-2-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='2026-02-12' AND kode_barang='MSCN-ZBAB-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-260212-0001','2026-02-12','2026-02-12','13:31','2.36','adminpusat','2026-02-12 13:32:41');
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-260212-0002','1','MSGL-ZBAB-3-0','1','2.410','2.410','TOKO','INPUT1','TOKO','BGLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMS' WHERE kode_barang='MSGL-ZBAB-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('2026-02-12','TOKO','BGLMS','MSGL','MSGL-ZBAB-3-0','100.00','1','2.410','2.400','1','2.410','2.400');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.410',berat_out_asli=berat_out_asli+'2.400',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MSGL-ZBAB-3-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-260212-0002','2026-02-12','2026-02-12','13:32','2.41','adminpusat','2026-02-12 13:33:25');
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-260212-0003','1','MSKL-ZBAB-4-0','1','2.950','2.950','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-ZBAB-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('2026-02-12','TOKO','BKLMS','MSKL','MSKL-ZBAB-4-0','100.00','1','2.950','2.940','1','2.950','2.940');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.950',berat_out_asli=berat_out_asli+'2.940',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MSKL-ZBAB-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-260212-0003','2026-02-12','2026-02-12','13:33','2.95','adminpusat','2026-02-12 13:34:23');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-12 ','13:58:56');
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 ('MDAT-ZBAB-5-0','00028069','EX ','AT COR KLP TDK BT UBS ','','GR','---','MD','MDAT','TOKO','INPUT1','1782500','2026-02-12','1782500','1.420','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:03:52','1.410','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDAT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDAT','MDAT-ZBAB-5-0','00028069');
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 ('2026-02-12','MDAT-ZBAB-5-0','MDAT','TOKO','INPUT1','100.00','1.420','1.410','1','1.420','1.410','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 ('MDAT-ZBAB-6-0','00028070','EX ','AT JEPSI PLS MK ','','GR','---','MD','MDAT','TOKO','INPUT1','615000','2026-02-12','615000','0.490','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:06:22','0.480','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDAT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDAT','MDAT-ZBAB-6-0','00028070');
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 ('2026-02-12','MDAT-ZBAB-6-0','MDAT','TOKO','INPUT1','100.00','0.490','0.480','1','0.490','0.480','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 ('MDAT-ZBAB-7-0','00028071','EX ','AT COR KLP TDK BT UBS ','','GR','---','MD','MDAT','TOKO','INPUT1','1330500','2026-02-12','1330500','1.060','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:08:56','1.050','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDAT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDAT','MDAT-ZBAB-7-0','00028071');
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 ('2026-02-12','MDAT-ZBAB-7-0','MDAT','TOKO','INPUT1','100.00','1.060','1.050','1','1.060','1.050','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 ('MDAT-ZBAB-8-0','00028072','EX ','AT COR KLP TDK BT SMBR PTH UBS ','','GR','---','MD','MDAT','TOKO','INPUT1','2937000','2026-02-12','2937000','2.340','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:12:47','2.330','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDAT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDAT','MDAT-ZBAB-8-0','00028072');
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 ('2026-02-12','MDAT-ZBAB-8-0','MDAT','TOKO','INPUT1','100.00','2.340','2.330','1','2.340','2.330','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 ('MDCN-ZBAB-9-0','00028073','EX ','CN COR BT MK ','','GR','---','MD','MDCN','TOKO','INPUT1','1029500','2026-02-12','1029500','0.820','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:17:47','0.810','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-9-0','00028073');
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 ('2026-02-12','MDCN-ZBAB-9-0','MDCN','TOKO','INPUT1','100.00','0.820','0.810','1','0.820','0.810','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 ('MDCN-ZBAB-10-0','00028074','EX ','CN COR BT MK ','','GR','---','MD','MDCN','TOKO','INPUT1','1167500','2026-02-12','1167500','0.930','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:18:55','0.920','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-10-0','00028074');
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 ('2026-02-12','MDCN-ZBAB-10-0','MDCN','TOKO','INPUT1','100.00','0.930','0.920','1','0.930','0.920','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 ('MDCN-ZBAB-11-0','00028075','EX ','CN COR BT MK ','','GR','---','MD','MDCN','TOKO','INPUT1','1657000','2026-02-12','1657000','1.320','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:19:43','1.310','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-11-0','00028075');
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 ('2026-02-12','MDCN-ZBAB-11-0','MDCN','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 ('MDCN-ZBAB-12-0','00028076','EX ','CN COR BT MK ','','GR','---','MD','MDCN','TOKO','INPUT1','1657000','2026-02-12','1657000','1.320','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:20:11','1.310','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-12-0','00028076');
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 ('2026-02-12','MDCN-ZBAB-12-0','MDCN','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 ('MDCN-ZBAB-13-0','00028077','EX ','CN COR BT MK ','','GR','---','MD','MDCN','TOKO','INPUT1','2234000','2026-02-12','2234000','1.780','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:21:42','1.770','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-13-0','00028077');
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 ('2026-02-12','MDCN-ZBAB-13-0','MDCN','TOKO','INPUT1','100.00','1.780','1.770','1','1.780','1.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 ('MDCN-ZBAB-14-0','00028078','EX ','CN COR BT MK ','','GR','---','MD','MDCN','TOKO','INPUT1','891500','2026-02-12','891500','0.710','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:22:58','0.700','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-14-0','00028078');
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 ('2026-02-12','MDCN-ZBAB-14-0','MDCN','TOKO','INPUT1','100.00','0.710','0.700','1','0.710','0.700','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 ('MDCN-ZBAB-15-0','00028079','EX ','CN COR BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','2209000','2026-02-12','2209000','1.760','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:24:56','1.750','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-15-0','00028079');
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 ('2026-02-12','MDCN-ZBAB-15-0','MDCN','TOKO','INPUT1','100.00','1.760','1.750','1','1.760','1.750','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 ('MDCN-ZBAB-16-0','00028080','EX ','CN COR BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1017000','2026-02-12','1017000','0.810','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:25:49','0.800','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-16-0','00028080');
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 ('2026-02-12','MDCN-ZBAB-16-0','MDCN','TOKO','INPUT1','100.00','0.810','0.800','1','0.810','0.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 ('MDCN-ZBAB-17-0','00028081','EX ','CN COR BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','2146500','2026-02-12','2146500','1.710','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:27:43','1.700','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-17-0','00028081');
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 ('2026-02-12','MDCN-ZBAB-17-0','MDCN','TOKO','INPUT1','100.00','1.710','1.700','1','1.710','1.700','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 ('MDCN-ZBAB-18-0','00028082','EX ','CN COR BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1933000','2026-02-12','1933000','1.540','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:29:21','1.530','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-18-0','00028082');
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 ('2026-02-12','MDCN-ZBAB-18-0','MDCN','TOKO','INPUT1','100.00','1.540','1.530','1','1.540','1.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 ('MDCN-ZBAB-19-0','00028083','EX ','CN COR BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1406000','2026-02-12','1406000','1.120','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:30:16','1.110','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-19-0','00028083');
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 ('2026-02-12','MDCN-ZBAB-19-0','MDCN','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 ('MDCN-ZBAB-20-0','00028084','EX ','CN COR BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1970500','2026-02-12','1970500','1.570','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:31:40','1.560','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-20-0','00028084');
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 ('2026-02-12','MDCN-ZBAB-20-0','MDCN','TOKO','INPUT1','100.00','1.570','1.560','1','1.570','1.560','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 ('MDCN-ZBAB-21-0','00028085','EX ','CN COR BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','2661000','2026-02-12','2661000','2.120','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:32:48','2.110','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-21-0','00028085');
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 ('2026-02-12','MDCN-ZBAB-21-0','MDCN','TOKO','INPUT1','100.00','2.120','2.110','1','2.120','2.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 ('MDCN-ZBAB-22-0','00028086','EX ','CN COR BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','2272000','2026-02-12','2272000','1.810','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:33:39','1.800','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-22-0','00028086');
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 ('2026-02-12','MDCN-ZBAB-22-0','MDCN','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 ('MDCN-ZBAB-23-0','00028087','EX ','CN COR BT UBS ','','GR','---','MD','MDCN','TOKO','INPUT1','2535500','2026-02-12','2535500','2.020','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:35:04','2.010','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-23-0','00028087');
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 ('2026-02-12','MDCN-ZBAB-23-0','MDCN','TOKO','INPUT1','100.00','2.020','2.010','1','2.020','2.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 ('MDCN-ZBAB-24-0','00028088','EX ','CN COR EROPA SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','3577000','2026-02-12','3577000','2.850','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:36:23','2.840','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-24-0','00028088');
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 ('2026-02-12','MDCN-ZBAB-24-0','MDCN','TOKO','INPUT1','100.00','2.850','2.840','1','2.850','2.840','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 ('MDCN-ZBAB-25-0','00028089','EX ','CN COR EROPA SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','3025000','2026-02-12','3025000','2.410','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:37:23','2.400','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-25-0','00028089');
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 ('2026-02-12','MDCN-ZBAB-25-0','MDCN','TOKO','INPUT1','100.00','2.410','2.400','1','2.410','2.400','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 ('MDCN-ZBAB-26-0','00028090','EX ','CN COR EROPA SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','6200000','2026-02-12','6200000','4.940','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:38:09','4.930','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-26-0','00028090');
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 ('2026-02-12','MDCN-ZBAB-26-0','MDCN','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 ('MDCN-ZBAB-27-0','00028091','EX ','CN COR EROPA SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','4192000','2026-02-12','4192000','3.340','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:39:03','3.330','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-27-0','00028091');
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 ('2026-02-12','MDCN-ZBAB-27-0','MDCN','TOKO','INPUT1','100.00','3.340','3.330','1','3.340','3.330','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 ('MDCN-ZBAB-28-0','00028092','EX ','CN COR EROPA SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','5120500','2026-02-12','5120500','4.080','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:40:20','4.070','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-28-0','00028092');
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 ('2026-02-12','MDCN-ZBAB-28-0','MDCN','TOKO','INPUT1','100.00','4.080','4.070','1','4.080','4.070','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 ('MDCN-ZBAB-29-0','00028093','EX ','CN SESER MK ','','GR','---','MD','MDCN','TOKO','INPUT1','1945500','2026-02-12','1945500','1.550','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:42:10','1.540','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-29-0','00028093');
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 ('2026-02-12','MDCN-ZBAB-29-0','MDCN','TOKO','INPUT1','100.00','1.550','1.540','1','1.550','1.540','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 ('MDCN-ZBAB-30-0','00028094','EX ','CN PLINTIR SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','3388500','2026-02-12','3388500','2.700','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:44:26','2.690','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-30-0','00028094');
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 ('2026-02-12','MDCN-ZBAB-30-0','MDCN','TOKO','INPUT1','100.00','2.700','2.690','1','2.700','2.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 ('MDCN-ZBAB-31-0','00028095','EX ','CN PLINTIR SUSUN SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','2334500','2026-02-12','2334500','1.860','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:46:22','1.850','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-31-0','00028095');
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 ('2026-02-12','MDCN-ZBAB-31-0','MDCN','TOKO','INPUT1','100.00','1.860','1.850','1','1.860','1.850','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 ('MDCN-ZBAB-32-0','00028096','EX ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1330500','2026-02-12','1330500','1.060','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:48:09','1.050','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-32-0','00028096');
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 ('2026-02-12','MDCN-ZBAB-32-0','MDCN','TOKO','INPUT1','100.00','1.060','1.050','1','1.060','1.050','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 ('MDCN-ZBAB-33-0','00028097','EX ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1832500','2026-02-12','1832500','1.460','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:49:27','1.450','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-33-0','00028097');
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 ('2026-02-12','MDCN-ZBAB-33-0','MDCN','TOKO','INPUT1','100.00','1.460','1.450','1','1.460','1.450','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 ('MDCN-ZBAB-34-0','00028098','EX ','CN COR TDK BT LC2 ','','GR','---','MD','MDCN','TOKO','INPUT1','4443000','2026-02-12','4443000','3.540','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:52:31','3.530','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-34-0','00028098');
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 ('2026-02-12','MDCN-ZBAB-34-0','MDCN','TOKO','INPUT1','100.00','3.540','3.530','1','3.540','3.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 ('MDCN-ZBAB-35-0','00028099','EX ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','2196500','2026-02-12','2196500','1.750','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:54:42','1.740','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-35-0','00028099');
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 ('2026-02-12','MDCN-ZBAB-35-0','MDCN','TOKO','INPUT1','100.00','1.750','1.740','1','1.750','1.740','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 ('MDCN-ZBAB-36-0','00028100','EX ','CN COR DOLLAR LC2 ','','GR','---','MD','MDCN','TOKO','INPUT1','2485000','2026-02-12','2485000','1.980','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 14:57:09','1.970','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZBAB-36-0','00028100');
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 ('2026-02-12','MDCN-ZBAB-36-0','MDCN','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 ('MDGL-ZBAB-37-0','00028101','EX ','GL PIPA BT HWT ','','GR','---','MD','MDGL','TOKO','INPUT1','3790500','2026-02-12','3790500','3.020','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:01:44','3.010','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZBAB-37-0','00028101');
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 ('2026-02-12','MDGL-ZBAB-37-0','MDGL','TOKO','INPUT1','100.00','3.020','3.010','1','3.020','3.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 ('MDGL-ZBAB-38-0','00028102','EX ','GL PIPA BT BTG ','','GR','---','MD','MDGL','TOKO','INPUT1','8496500','2026-02-12','8496500','6.770','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:04:07','6.760','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZBAB-38-0','00028102');
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 ('2026-02-12','MDGL-ZBAB-38-0','MDGL','TOKO','INPUT1','100.00','6.770','6.760','1','6.770','6.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 ('MDGL-ZBAB-39-0','00028103','EX ','GL ITALY ST ANK CAT SRT MN4 14CM KKT PER BLT UBS ','','GR','---','MD','MDGL','TOKO','INPUT1','3175500','2026-02-12','3175500','2.530','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:08:19','2.520','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZBAB-39-0','00028103');
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 ('2026-02-12','MDGL-ZBAB-39-0','MDGL','TOKO','INPUT1','100.00','2.530','2.520','1','2.530','2.520','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 ('MDGL-ZBAB-40-0','00028104','EX ','GL ITALY ST SRT VAR BT 18CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','2309500','2026-02-12','2309500','1.840','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:12:56','1.830','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZBAB-40-0','00028104');
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 ('2026-02-12','MDGL-ZBAB-40-0','MDGL','TOKO','INPUT1','100.00','1.840','1.830','1','1.840','1.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 ('MDGL-ZBAB-41-0','00028105','EX ','GL FANCY SLP SRT MN LM 18CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','1770000','2026-02-12','1770000','1.410','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:16:44','1.400','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZBAB-41-0','00028105');
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 ('2026-02-12','MDGL-ZBAB-41-0','MDGL','TOKO','INPUT1','100.00','1.410','1.400','1','1.410','1.400','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 ('MDGL-ZBAB-42-0','00028106','EX ','GL FANCY VAR 17CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','3175500','2026-02-12','3175500','2.530','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:19:00','2.520','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZBAB-42-0','00028106');
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 ('2026-02-12','MDGL-ZBAB-42-0','MDGL','TOKO','INPUT1','100.00','2.530','2.520','1','2.530','2.520','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 ('MDGL-ZBAB-43-0','00028107','EX ','GL RANG VC SLP VAR BT 16CM KKT PER MK ','','GR','---','MD','MDGL','TOKO','INPUT1','3840500','2026-02-12','3840500','3.060','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:21:45','3.050','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZBAB-43-0','00028107');
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 ('2026-02-12','MDGL-ZBAB-43-0','MDGL','TOKO','INPUT1','100.00','3.060','3.050','1','3.060','3.050','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 ('MDGL-ZBAB-44-0','00028108','EX ','GL CAP HOLO 16CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','6752000','2026-02-12','6752000','5.380','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:24:12','5.370','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZBAB-44-0','00028108');
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 ('2026-02-12','MDGL-ZBAB-44-0','MDGL','TOKO','INPUT1','100.00','5.380','5.370','1','5.380','5.370','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 ('MDGL-ZBAB-45-0','00028109','EX ','GL CAP HOLO 17CM KKT PER MK ','','GR','---','MD','MDGL','TOKO','INPUT1','5045500','2026-02-12','5045500','4.020','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:26:45','4.010','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZBAB-45-0','00028109');
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 ('2026-02-12','MDGL-ZBAB-45-0','MDGL','TOKO','INPUT1','100.00','4.020','4.010','1','4.020','4.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 ('MDGL-ZBAB-46-0','00028110','EX ','GL CAP HOLO 17CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','4907500','2026-02-12','4907500','3.910','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:28:56','3.900','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZBAB-46-0','00028110');
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 ('2026-02-12','MDGL-ZBAB-46-0','MDGL','TOKO','INPUT1','100.00','3.910','3.900','1','3.910','3.900','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 ('MDGW-ZBAB-47-0','00028111','EX ','GW COR BT UBS ','','GR','---','MD','MDGW','TOKO','INPUT1','1192500','2026-02-12','1192500','0.950','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:31:55','0.940','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGW' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGW','MDGW-ZBAB-47-0','00028111');
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 ('2026-02-12','MDGW-ZBAB-47-0','MDGW','TOKO','INPUT1','100.00','0.950','0.940','1','0.950','0.940','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 ('MDKL-ZBAB-48-0','00028112','EX ','KL FANCY ANK CAT 33CM KKT S MK ','','GR','---','MD','MDKL','TOKO','INPUT1','2711000','2026-02-12','2711000','2.160','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:35:11','2.150','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-ZBAB-48-0','00028112');
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 ('2026-02-12','MDKL-ZBAB-48-0','MDKL','TOKO','INPUT1','100.00','2.160','2.150','1','2.160','2.150','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 ('MDKL-ZBAB-49-0','00028113','EX ','KL FANCY VAR BT 42CM KKT S SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','4342500','2026-02-12','4342500','3.460','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:38:37','3.450','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-ZBAB-49-0','00028113');
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 ('2026-02-12','MDKL-ZBAB-49-0','MDKL','TOKO','INPUT1','100.00','3.460','3.450','1','3.460','3.450','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 ('MDKL-ZBAB-50-0','00028114','EX ','KL FANCY VAR BT 42CM KKT S SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','3878000','2026-02-12','3878000','3.090','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:40:29','3.080','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-ZBAB-50-0','00028114');
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 ('2026-02-12','MDKL-ZBAB-50-0','MDKL','TOKO','INPUT1','100.00','3.090','3.080','1','3.090','3.080','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 ('MDKL-ZBAB-51-0','00028115','EX ','KL FANCY POCO 42CM KKT S UBS ','','GR','---','MD','MDKL','TOKO','INPUT1','4669000','2026-02-12','4669000','3.720','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:42:15','3.710','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-ZBAB-51-0','00028115');
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 ('2026-02-12','MDKL-ZBAB-51-0','MDKL','TOKO','INPUT1','100.00','3.720','3.710','1','3.720','3.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 ('MDKL-ZBAB-52-0','00028116','EX ','KL FANCY BL SLP 42CM KKT PER SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','3125000','2026-02-12','3125000','2.490','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:44:00','2.480','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-ZBAB-52-0','00028116');
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 ('2026-02-12','MDKL-ZBAB-52-0','MDKL','TOKO','INPUT1','100.00','2.490','2.480','1','2.490','2.480','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 ('MDKL-ZBAB-53-0','00028117','EX ','KL FANCY VAR DB 42CM KKT S SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','6187500','2026-02-12','6187500','4.930','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:46:09','4.920','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-ZBAB-53-0','00028117');
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 ('2026-02-12','MDKL-ZBAB-53-0','MDKL','TOKO','INPUT1','100.00','4.930','4.920','1','4.930','4.920','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 ('MDKL-ZBAB-54-0','00028118','EX ','KL FANCY VAR DB 42CM KKT PER SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','3602000','2026-02-12','3602000','2.870','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:48:03','2.860','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-ZBAB-54-0','00028118');
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 ('2026-02-12','MDKL-ZBAB-54-0','MDKL','TOKO','INPUT1','100.00','2.870','2.860','1','2.870','2.860','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 ('MDKL-ZBAB-55-0','00028119','EX ','KL ITALY ST BTR BT DSC 42CM KKT PER BLT SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','3715000','2026-02-12','3715000','2.960','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:50:23','2.950','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-ZBAB-55-0','00028119');
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 ('2026-02-12','MDKL-ZBAB-55-0','MDKL','TOKO','INPUT1','100.00','2.960','2.950','1','2.960','2.950','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 ('MDKL-ZBAB-56-0','00028120','EX ','KL ITALY ST CAT HURUF H 42CM KKT PER MK ','','GR','---','MD','MDKL','TOKO','INPUT1','3652500','2026-02-12','3652500','2.910','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:52:24','2.900','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-ZBAB-56-0','00028120');
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 ('2026-02-12','MDKL-ZBAB-56-0','MDKL','TOKO','INPUT1','100.00','2.910','2.900','1','2.910','2.900','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 ('MDLT-ZBAB-57-0','00028121','EX ','LT COR BT SHB ','','GR','---','MD','MDLT','TOKO','INPUT1','991500','2026-02-12','991500','0.790','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:54:23','0.780','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDLT','MDLT-ZBAB-57-0','00028121');
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 ('2026-02-12','MDLT-ZBAB-57-0','MDLT','TOKO','INPUT1','100.00','0.790','0.780','1','0.790','0.780','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 ('MDLT-ZBAB-58-0','00028122','EX ','LT CAP BT SHB ','','GR','---','MD','MDLT','TOKO','INPUT1','1318000','2026-02-12','1318000','1.050','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:55:51','1.040','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDLT','MDLT-ZBAB-58-0','00028122');
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 ('2026-02-12','MDLT-ZBAB-58-0','MDLT','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 ('MDLT-ZBAB-59-0','00028123','EX ','LT COR 3WRN LC2 ','','GR','---','MD','MDLT','TOKO','INPUT1','2736000','2026-02-12','2736000','2.180','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:57:17','2.170','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDLT','MDLT-ZBAB-59-0','00028123');
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 ('2026-02-12','MDLT-ZBAB-59-0','MDLT','TOKO','INPUT1','100.00','2.180','2.170','1','2.180','2.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 ('MDLT-ZBAB-60-0','00028124','EX ','LT SAKURA UBS ','','GR','---','MD','MDLT','TOKO','INPUT1','1657000','2026-02-12','1657000','1.320','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-12 15:58:28','1.310','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDLT','MDLT-ZBAB-60-0','00028124');
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 ('2026-02-12','MDLT-ZBAB-60-0','MDLT','TOKO','INPUT1','100.00','1.320','1.310','1','1.320','1.310','1');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-12 ','16:02:22');
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-260212-0004','1','MDAT-ZBAB-5-0','1','1.420','1.420','TOKO','INPUT1','TOKO','BATMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-ZBAB-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('2026-02-12','TOKO','BATMD','MDAT','MDAT-ZBAB-5-0','100.00','1','1.420','1.410','1','1.420','1.410');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.420',berat_out_asli=berat_out_asli+'1.410',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDAT-ZBAB-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-260212-0004','2','MDAT-ZBAB-6-0','1','0.490','0.490','TOKO','INPUT1','TOKO','BATMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-ZBAB-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('2026-02-12','TOKO','BATMD','MDAT','MDAT-ZBAB-6-0','100.00','1','0.490','0.480','1','0.490','0.480');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.490',berat_out_asli=berat_out_asli+'0.480',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDAT-ZBAB-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-260212-0004','3','MDAT-ZBAB-7-0','1','1.060','1.060','TOKO','INPUT1','TOKO','BATMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-ZBAB-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('2026-02-12','TOKO','BATMD','MDAT','MDAT-ZBAB-7-0','100.00','1','1.060','1.050','1','1.060','1.050');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.060',berat_out_asli=berat_out_asli+'1.050',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDAT-ZBAB-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-260212-0004','4','MDAT-ZBAB-8-0','1','2.340','2.340','TOKO','INPUT1','TOKO','BATMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-ZBAB-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('2026-02-12','TOKO','BATMD','MDAT','MDAT-ZBAB-8-0','100.00','1','2.340','2.330','1','2.340','2.330');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.340',berat_out_asli=berat_out_asli+'2.330',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDAT-ZBAB-8-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-260212-0004','2026-02-12','2026-02-12','16:02','5.31','adminpusat','2026-02-12 16:04:44');
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-260212-0005','1','MDCN-ZBAB-9-0','1','0.820','0.820','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-9-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='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','2','MDCN-ZBAB-10-0','1','0.930','0.930','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-10-0','100.00','1','0.930','0.920','1','0.930','0.920');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.930',berat_out_asli=berat_out_asli+'0.920',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','3','MDCN-ZBAB-11-0','1','1.320','1.320','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-11-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='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','4','MDCN-ZBAB-12-0','1','1.320','1.320','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-12-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='2026-02-12' AND kode_barang='MDCN-ZBAB-12-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-260212-0005','5','MDCN-ZBAB-13-0','1','1.780','1.780','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-13-0','100.00','1','1.780','1.770','1','1.780','1.770');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.780',berat_out_asli=berat_out_asli+'1.770',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','6','MDCN-ZBAB-14-0','1','0.710','0.710','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-14-0','100.00','1','0.710','0.700','1','0.710','0.700');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.710',berat_out_asli=berat_out_asli+'0.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','7','MDCN-ZBAB-15-0','1','1.760','1.760','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-15-0','100.00','1','1.760','1.750','1','1.760','1.750');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.760',berat_out_asli=berat_out_asli+'1.750',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','8','MDCN-ZBAB-16-0','1','0.810','0.810','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-16-0','100.00','1','0.810','0.800','1','0.810','0.800');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.810',berat_out_asli=berat_out_asli+'0.800',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','9','MDCN-ZBAB-17-0','1','1.710','1.710','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-17-0','100.00','1','1.710','1.700','1','1.710','1.700');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.710',berat_out_asli=berat_out_asli+'1.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','10','MDCN-ZBAB-18-0','1','1.540','1.540','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-18-0','100.00','1','1.540','1.530','1','1.540','1.530');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.540',berat_out_asli=berat_out_asli+'1.530',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','11','MDCN-ZBAB-19-0','1','1.120','1.120','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-19-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='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','12','MDCN-ZBAB-20-0','1','1.570','1.570','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-20-0','100.00','1','1.570','1.560','1','1.570','1.560');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.570',berat_out_asli=berat_out_asli+'1.560',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','13','MDCN-ZBAB-21-0','1','2.120','2.120','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-21-0','100.00','1','2.120','2.110','1','2.120','2.110');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.120',berat_out_asli=berat_out_asli+'2.110',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','14','MDCN-ZBAB-22-0','1','1.810','1.810','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-22-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='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','15','MDCN-ZBAB-23-0','1','2.020','2.020','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-23-0','100.00','1','2.020','2.010','1','2.020','2.010');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.020',berat_out_asli=berat_out_asli+'2.010',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','16','MDCN-ZBAB-24-0','1','2.850','2.850','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-24-0','100.00','1','2.850','2.840','1','2.850','2.840');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.850',berat_out_asli=berat_out_asli+'2.840',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','17','MDCN-ZBAB-25-0','1','2.410','2.410','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-25-0','100.00','1','2.410','2.400','1','2.410','2.400');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.410',berat_out_asli=berat_out_asli+'2.400',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','18','MDCN-ZBAB-26-0','1','4.940','4.940','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-26-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='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','19','MDCN-ZBAB-27-0','1','3.340','3.340','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-27-0','100.00','1','3.340','3.330','1','3.340','3.330');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.340',berat_out_asli=berat_out_asli+'3.330',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','20','MDCN-ZBAB-28-0','1','4.080','4.080','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-28-0','100.00','1','4.080','4.070','1','4.080','4.070');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.080',berat_out_asli=berat_out_asli+'4.070',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDCN-ZBAB-28-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-260212-0005','21','MDCN-ZBAB-29-0','1','1.550','1.550','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-29-0','100.00','1','1.550','1.540','1','1.550','1.540');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.550',berat_out_asli=berat_out_asli+'1.540',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','22','MDCN-ZBAB-30-0','1','2.700','2.700','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-30-0','100.00','1','2.700','2.690','1','2.700','2.690');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.700',berat_out_asli=berat_out_asli+'2.690',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','23','MDCN-ZBAB-31-0','1','1.860','1.860','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-31-0','100.00','1','1.860','1.850','1','1.860','1.850');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.860',berat_out_asli=berat_out_asli+'1.850',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','24','MDCN-ZBAB-32-0','1','1.060','1.060','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-32-0','100.00','1','1.060','1.050','1','1.060','1.050');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.060',berat_out_asli=berat_out_asli+'1.050',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','25','MDCN-ZBAB-33-0','1','1.460','1.460','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-33-0','100.00','1','1.460','1.450','1','1.460','1.450');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.460',berat_out_asli=berat_out_asli+'1.450',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','26','MDCN-ZBAB-34-0','1','3.540','3.540','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-34-0','100.00','1','3.540','3.530','1','3.540','3.530');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.540',berat_out_asli=berat_out_asli+'3.530',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','27','MDCN-ZBAB-35-0','1','1.750','1.750','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-35-0','100.00','1','1.750','1.740','1','1.750','1.740');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.750',berat_out_asli=berat_out_asli+'1.740',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDCN-ZBAB-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-260212-0005','28','MDCN-ZBAB-36-0','1','1.980','1.980','TOKO','INPUT1','TOKO','BCNMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZBAB-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('2026-02-12','TOKO','BCNMD','MDCN','MDCN-ZBAB-36-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='2026-02-12' AND kode_barang='MDCN-ZBAB-36-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-260212-0005','2026-02-12','2026-02-12','16:04','54.86','adminpusat','2026-02-12 16:11:04');
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-260212-0006','1','MDGL-ZBAB-37-0','1','3.020','3.020','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZBAB-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('2026-02-12','TOKO','BGLMD','MDGL','MDGL-ZBAB-37-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='2026-02-12' AND kode_barang='MDGL-ZBAB-37-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-260212-0006','2','MDGL-ZBAB-38-0','1','6.770','6.770','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZBAB-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('2026-02-12','TOKO','BGLMD','MDGL','MDGL-ZBAB-38-0','100.00','1','6.770','6.760','1','6.770','6.760');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'6.770',berat_out_asli=berat_out_asli+'6.760',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDGL-ZBAB-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-260212-0006','3','MDGL-ZBAB-39-0','1','2.530','2.530','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZBAB-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('2026-02-12','TOKO','BGLMD','MDGL','MDGL-ZBAB-39-0','100.00','1','2.530','2.520','1','2.530','2.520');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.530',berat_out_asli=berat_out_asli+'2.520',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDGL-ZBAB-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-260212-0006','4','MDGL-ZBAB-40-0','1','1.840','1.840','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZBAB-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('2026-02-12','TOKO','BGLMD','MDGL','MDGL-ZBAB-40-0','100.00','1','1.840','1.830','1','1.840','1.830');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.840',berat_out_asli=berat_out_asli+'1.830',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDGL-ZBAB-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-260212-0006','5','MDGL-ZBAB-41-0','1','1.410','1.410','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZBAB-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('2026-02-12','TOKO','BGLMD','MDGL','MDGL-ZBAB-41-0','100.00','1','1.410','1.400','1','1.410','1.400');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.410',berat_out_asli=berat_out_asli+'1.400',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDGL-ZBAB-41-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-260212-0006','6','MDGL-ZBAB-42-0','1','2.530','2.530','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZBAB-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('2026-02-12','TOKO','BGLMD','MDGL','MDGL-ZBAB-42-0','100.00','1','2.530','2.520','1','2.530','2.520');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.530',berat_out_asli=berat_out_asli+'2.520',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDGL-ZBAB-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-260212-0006','7','MDGL-ZBAB-43-0','1','3.060','3.060','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZBAB-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('2026-02-12','TOKO','BGLMD','MDGL','MDGL-ZBAB-43-0','100.00','1','3.060','3.050','1','3.060','3.050');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.060',berat_out_asli=berat_out_asli+'3.050',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDGL-ZBAB-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-260212-0006','8','MDGL-ZBAB-44-0','1','5.380','5.380','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZBAB-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('2026-02-12','TOKO','BGLMD','MDGL','MDGL-ZBAB-44-0','100.00','1','5.380','5.370','1','5.380','5.370');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.380',berat_out_asli=berat_out_asli+'5.370',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDGL-ZBAB-44-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-260212-0006','9','MDGL-ZBAB-45-0','1','4.020','4.020','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZBAB-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('2026-02-12','TOKO','BGLMD','MDGL','MDGL-ZBAB-45-0','100.00','1','4.020','4.010','1','4.020','4.010');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.020',berat_out_asli=berat_out_asli+'4.010',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDGL-ZBAB-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-260212-0006','10','MDGL-ZBAB-46-0','1','3.910','3.910','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZBAB-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('2026-02-12','TOKO','BGLMD','MDGL','MDGL-ZBAB-46-0','100.00','1','3.910','3.900','1','3.910','3.900');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.910',berat_out_asli=berat_out_asli+'3.900',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDGL-ZBAB-46-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-260212-0006','2026-02-12','2026-02-12','16:11','34.47','adminpusat','2026-02-12 16:13:23');
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-260212-0007','1','MDGW-ZBAB-47-0','1','0.950','0.950','TOKO','INPUT1','TOKO','BGWMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGWMD' WHERE kode_barang='MDGW-ZBAB-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('2026-02-12','TOKO','BGWMD','MDGW','MDGW-ZBAB-47-0','100.00','1','0.950','0.940','1','0.950','0.940');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.950',berat_out_asli=berat_out_asli+'0.940',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDGW-ZBAB-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-260212-0007','2026-02-12','2026-02-12','16:13','0.95','adminpusat','2026-02-12 16:14:16');
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-260212-0008','1','MDKL-ZBAB-48-0','1','2.160','2.160','TOKO','INPUT1','TOKO','BKLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-ZBAB-48-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('2026-02-12','TOKO','BKLMD','MDKL','MDKL-ZBAB-48-0','100.00','1','2.160','2.150','1','2.160','2.150');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.160',berat_out_asli=berat_out_asli+'2.150',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDKL-ZBAB-48-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-260212-0008','2','MDKL-ZBAB-49-0','1','3.460','3.460','TOKO','INPUT1','TOKO','BKLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-ZBAB-49-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('2026-02-12','TOKO','BKLMD','MDKL','MDKL-ZBAB-49-0','100.00','1','3.460','3.450','1','3.460','3.450');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.460',berat_out_asli=berat_out_asli+'3.450',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDKL-ZBAB-49-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-260212-0008','3','MDKL-ZBAB-50-0','1','3.090','3.090','TOKO','INPUT1','TOKO','BKLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-ZBAB-50-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('2026-02-12','TOKO','BKLMD','MDKL','MDKL-ZBAB-50-0','100.00','1','3.090','3.080','1','3.090','3.080');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.090',berat_out_asli=berat_out_asli+'3.080',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDKL-ZBAB-50-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-260212-0008','4','MDKL-ZBAB-51-0','1','3.720','3.720','TOKO','INPUT1','TOKO','BKLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-ZBAB-51-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('2026-02-12','TOKO','BKLMD','MDKL','MDKL-ZBAB-51-0','100.00','1','3.720','3.710','1','3.720','3.710');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.720',berat_out_asli=berat_out_asli+'3.710',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDKL-ZBAB-51-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-260212-0008','5','MDKL-ZBAB-52-0','1','2.490','2.490','TOKO','INPUT1','TOKO','BKLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-ZBAB-52-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('2026-02-12','TOKO','BKLMD','MDKL','MDKL-ZBAB-52-0','100.00','1','2.490','2.480','1','2.490','2.480');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.490',berat_out_asli=berat_out_asli+'2.480',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDKL-ZBAB-52-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-260212-0008','6','MDKL-ZBAB-53-0','1','4.930','4.930','TOKO','INPUT1','TOKO','BKLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-ZBAB-53-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('2026-02-12','TOKO','BKLMD','MDKL','MDKL-ZBAB-53-0','100.00','1','4.930','4.920','1','4.930','4.920');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.930',berat_out_asli=berat_out_asli+'4.920',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDKL-ZBAB-53-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-260212-0008','7','MDKL-ZBAB-54-0','1','2.870','2.870','TOKO','INPUT1','TOKO','BKLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-ZBAB-54-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('2026-02-12','TOKO','BKLMD','MDKL','MDKL-ZBAB-54-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='2026-02-12' AND kode_barang='MDKL-ZBAB-54-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-260212-0008','8','MDKL-ZBAB-55-0','1','2.960','2.960','TOKO','INPUT1','TOKO','BKLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-ZBAB-55-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('2026-02-12','TOKO','BKLMD','MDKL','MDKL-ZBAB-55-0','100.00','1','2.960','2.950','1','2.960','2.950');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.960',berat_out_asli=berat_out_asli+'2.950',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDKL-ZBAB-55-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-260212-0008','9','MDKL-ZBAB-56-0','1','2.910','2.910','TOKO','INPUT1','TOKO','BKLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-ZBAB-56-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('2026-02-12','TOKO','BKLMD','MDKL','MDKL-ZBAB-56-0','100.00','1','2.910','2.900','1','2.910','2.900');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.910',berat_out_asli=berat_out_asli+'2.900',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDKL-ZBAB-56-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-260212-0008','2026-02-12','2026-02-12','16:14','28.59','adminpusat','2026-02-12 16:16:06');
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-260212-0009','1','MDLT-ZBAB-57-0','1','0.790','0.790','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-ZBAB-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('2026-02-12','TOKO','BLTMD','MDLT','MDLT-ZBAB-57-0','100.00','1','0.790','0.780','1','0.790','0.780');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.790',berat_out_asli=berat_out_asli+'0.780',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDLT-ZBAB-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-260212-0009','2','MDLT-ZBAB-58-0','1','1.050','1.050','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-ZBAB-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('2026-02-12','TOKO','BLTMD','MDLT','MDLT-ZBAB-58-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='2026-02-12' AND kode_barang='MDLT-ZBAB-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-260212-0009','3','MDLT-ZBAB-59-0','1','2.180','2.180','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-ZBAB-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('2026-02-12','TOKO','BLTMD','MDLT','MDLT-ZBAB-59-0','100.00','1','2.180','2.170','1','2.180','2.170');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.180',berat_out_asli=berat_out_asli+'2.170',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-02-12' AND kode_barang='MDLT-ZBAB-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-260212-0009','4','MDLT-ZBAB-60-0','1','1.320','1.320','TOKO','INPUT1','TOKO','BLTMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-ZBAB-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('2026-02-12','TOKO','BLTMD','MDLT','MDLT-ZBAB-60-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='2026-02-12' AND kode_barang='MDLT-ZBAB-60-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-260212-0009','2026-02-12','2026-02-12','16:16','5.34','adminpusat','2026-02-12 16:17:12');