INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-11-06 ','08:11:52');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-06','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-06';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-05';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-05';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-11-05' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-05';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-05';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-05';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-05';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-11-06' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-05' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-11-06';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-11-06 ','10:09:35');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-11-06 ','12:03:07');
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('MDKL-YKXE-86-0','00026798','00026798','KL ITALY ST 42CM KKT PER SHB ','KL ITALY 42CM KKT PER SHB','','','2226500','2226500',' 0','0','adminpusat','2025-11-06 12:13:12');
UPDATE tm_barang SET nama_barang='KL ITALY 42CM KKT PER SHB' ,nama_atribut='' ,kode_intern=' ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MDKL-YKXE-86-0' LIMIT 1;
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','1','MDGL-YKXE-1-0','1','2.320','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-1-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.320',berat_out_asli='2.310', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.320',berat_akhir_asli =berat_akhir_asli-'2.310' WHERE kode_barang='MDGL-YKXE-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-251106-0001','2','MDGL-YKXE-2-0','1','2.350','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-2-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.350',berat_out_asli='2.340', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.350',berat_akhir_asli =berat_akhir_asli-'2.340' WHERE kode_barang='MDGL-YKXE-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-251106-0001','3','MDGL-YKXE-3-0','1','2.210','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-3-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-3-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-YKXE-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-251106-0001','4','MDGL-YKXE-4-0','1','4.050','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-4-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.050',berat_out_asli='4.040', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.050',berat_akhir_asli =berat_akhir_asli-'4.040' WHERE kode_barang='MDGL-YKXE-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-251106-0001','5','MDGL-YKXE-5-0','1','4.050','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-5-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.050',berat_out_asli='4.040', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.050',berat_akhir_asli =berat_akhir_asli-'4.040' WHERE kode_barang='MDGL-YKXE-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-251106-0001','6','MDGL-YKXE-6-0','1','8.870','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-6-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='8.870',berat_out_asli='8.860', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'8.870',berat_akhir_asli =berat_akhir_asli-'8.860' WHERE kode_barang='MDGL-YKXE-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-251106-0001','7','MDGL-YKXE-7-0','1','7.860','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-7-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='7.860',berat_out_asli='7.850', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'7.860',berat_akhir_asli =berat_akhir_asli-'7.850' WHERE kode_barang='MDGL-YKXE-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-251106-0001','8','MDGL-YKXE-8-0','1','4.240','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-8-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.240',berat_out_asli='4.230', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.240',berat_akhir_asli =berat_akhir_asli-'4.230' WHERE kode_barang='MDGL-YKXE-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-251106-0001','9','MDGL-YKXE-9-0','1','6.750','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-9-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='6.750',berat_out_asli='6.740', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'6.750',berat_akhir_asli =berat_akhir_asli-'6.740' WHERE kode_barang='MDGL-YKXE-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-251106-0001','10','MDGL-YKXE-10-0','1','9.710','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-10-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='9.710',berat_out_asli='9.700', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'9.710',berat_akhir_asli =berat_akhir_asli-'9.700' WHERE kode_barang='MDGL-YKXE-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-251106-0001','11','MDGL-YKXE-11-0','1','12.060','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-11-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='12.060',berat_out_asli='12.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'12.060',berat_akhir_asli =berat_akhir_asli-'12.050' WHERE kode_barang='MDGL-YKXE-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-251106-0001','12','MDGL-YKXE-12-0','1','8.490','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-12-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='8.490',berat_out_asli='8.480', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'8.490',berat_akhir_asli =berat_akhir_asli-'8.480' WHERE kode_barang='MDGL-YKXE-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-251106-0001','13','MDGL-YKXE-13-0','1','3.220','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-13-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.220',berat_out_asli='3.210', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.220',berat_akhir_asli =berat_akhir_asli-'3.210' WHERE kode_barang='MDGL-YKXE-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-251106-0001','14','MDGL-YKXE-14-0','1','4.330','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-14-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-14-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-YKXE-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-251106-0001','15','MDGL-YKXE-15-0','1','5.200','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-15-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-15-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.200',berat_out_asli='5.190', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.200',berat_akhir_asli =berat_akhir_asli-'5.190' WHERE kode_barang='MDGL-YKXE-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-251106-0001','16','MDGL-YKXE-16-0','1','5.270','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-16-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-16-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.270',berat_out_asli='5.260', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.270',berat_akhir_asli =berat_akhir_asli-'5.260' WHERE kode_barang='MDGL-YKXE-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-251106-0001','17','MDGL-YKXE-17-0','1','5.260','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-17-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-17-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.260',berat_out_asli='5.250', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.260',berat_akhir_asli =berat_akhir_asli-'5.250' WHERE kode_barang='MDGL-YKXE-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-251106-0001','18','MDGL-YKXE-18-0','1','5.070','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-18-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-18-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.070',berat_out_asli='5.060', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.070',berat_akhir_asli =berat_akhir_asli-'5.060' WHERE kode_barang='MDGL-YKXE-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-251106-0001','19','MDGL-YKXE-19-0','1','5.070','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-19-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.070',berat_out_asli='5.060', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.070',berat_akhir_asli =berat_akhir_asli-'5.060' WHERE kode_barang='MDGL-YKXE-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-251106-0001','20','MDGL-YKXE-20-0','1','4.060','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-20-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.060',berat_out_asli='4.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.060',berat_akhir_asli =berat_akhir_asli-'4.050' WHERE kode_barang='MDGL-YKXE-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-251106-0001','21','MDGL-YKXE-21-0','1','9.790','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-21-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='9.790',berat_out_asli='9.780', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'9.790',berat_akhir_asli =berat_akhir_asli-'9.780' WHERE kode_barang='MDGL-YKXE-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-251106-0001','22','MDGL-YKXE-22-0','1','9.980','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-22-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-22-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='9.980',berat_out_asli='9.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'9.980',berat_akhir_asli =berat_akhir_asli-'9.970' WHERE kode_barang='MDGL-YKXE-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-251106-0001','23','MDGL-YKXE-23-0','1','5.170','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-23-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-23-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.170',berat_out_asli='5.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.170',berat_akhir_asli =berat_akhir_asli-'5.160' WHERE kode_barang='MDGL-YKXE-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-251106-0001','24','MDGL-YKXE-24-0','1','9.940','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-24-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-24-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='9.940',berat_out_asli='9.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'9.940',berat_akhir_asli =berat_akhir_asli-'9.930' WHERE kode_barang='MDGL-YKXE-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-251106-0001','25','MDGL-YKXE-25-0','1','9.760','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-25-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-25-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='9.760',berat_out_asli='9.750', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'9.760',berat_akhir_asli =berat_akhir_asli-'9.750' WHERE kode_barang='MDGL-YKXE-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-251106-0001','26','MDGL-YKXE-26-0','1','13.230','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-26-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-26-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='13.230',berat_out_asli='13.220', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'13.230',berat_akhir_asli =berat_akhir_asli-'13.220' WHERE kode_barang='MDGL-YKXE-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-251106-0001','27','MDGL-YKXE-27-0','1','16.330','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-27-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-27-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='16.330',berat_out_asli='16.320', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'16.330',berat_akhir_asli =berat_akhir_asli-'16.320' WHERE kode_barang='MDGL-YKXE-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-251106-0001','28','MDGL-YKXE-28-0','1','12.620','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-28-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-28-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='12.620',berat_out_asli='12.610', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'12.620',berat_akhir_asli =berat_akhir_asli-'12.610' WHERE kode_barang='MDGL-YKXE-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-251106-0001','29','MDGL-YKXE-29-0','1','14.810','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-29-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-29-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='14.810',berat_out_asli='14.800', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'14.810',berat_akhir_asli =berat_akhir_asli-'14.800' WHERE kode_barang='MDGL-YKXE-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-251106-0001','30','MDGL-YKXE-30-0','1','2.590','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-30-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-30-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.590',berat_out_asli='2.580', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.590',berat_akhir_asli =berat_akhir_asli-'2.580' WHERE kode_barang='MDGL-YKXE-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-251106-0001','31','MDGL-YKXE-31-0','1','2.100','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-31-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-31-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.100',berat_out_asli='2.090', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.100',berat_akhir_asli =berat_akhir_asli-'2.090' WHERE kode_barang='MDGL-YKXE-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-251106-0001','32','MDGL-YKXE-32-0','1','3.300','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-32-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-32-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.300',berat_out_asli='3.290', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.300',berat_akhir_asli =berat_akhir_asli-'3.290' WHERE kode_barang='MDGL-YKXE-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-251106-0001','33','MDGL-YKXE-33-0','1','3.170','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-33-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-33-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.170',berat_out_asli='3.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.170',berat_akhir_asli =berat_akhir_asli-'3.160' WHERE kode_barang='MDGL-YKXE-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-251106-0001','34','MDGL-YKXE-34-0','1','2.930','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-34-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-34-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-YKXE-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-251106-0001','35','MDGL-YKXE-35-0','1','2.930','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-35-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-35-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-YKXE-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-251106-0001','36','MDGL-YKXE-36-0','1','2.840','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-36-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-36-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.840',berat_out_asli='2.830', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.840',berat_akhir_asli =berat_akhir_asli-'2.830' WHERE kode_barang='MDGL-YKXE-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-251106-0001','37','MDGL-YKXE-37-0','1','5.830','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-37-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-37-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.830',berat_out_asli='5.820', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.830',berat_akhir_asli =berat_akhir_asli-'5.820' WHERE kode_barang='MDGL-YKXE-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-251106-0001','38','MDGL-YKXE-38-0','1','4.270','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-38-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-38-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.270',berat_out_asli='4.260', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.270',berat_akhir_asli =berat_akhir_asli-'4.260' WHERE kode_barang='MDGL-YKXE-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-251106-0001','39','MDGL-YKXE-39-0','1','5.150','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-39-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-39-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.150',berat_out_asli='5.140', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.150',berat_akhir_asli =berat_akhir_asli-'5.140' WHERE kode_barang='MDGL-YKXE-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-251106-0001','40','MDGL-YKXE-40-0','1','0.950','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-40-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-40-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.950',berat_out_asli='0.940', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.950',berat_akhir_asli =berat_akhir_asli-'0.940' WHERE kode_barang='MDGL-YKXE-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-251106-0001','41','MDGL-YKXE-41-0','1','3.940','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-41-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-41-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.940',berat_out_asli='3.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.940',berat_akhir_asli =berat_akhir_asli-'3.930' WHERE kode_barang='MDGL-YKXE-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-251106-0001','42','MDGL-YKXE-42-0','1','3.380','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-42-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-42-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.380',berat_out_asli='3.370', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.380',berat_akhir_asli =berat_akhir_asli-'3.370' WHERE kode_barang='MDGL-YKXE-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-251106-0001','43','MDGL-YKXE-43-0','1','3.580','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-43-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-43-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.580',berat_out_asli='3.570', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.580',berat_akhir_asli =berat_akhir_asli-'3.570' WHERE kode_barang='MDGL-YKXE-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-251106-0001','44','MDGL-YKXE-44-0','1','3.810','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-44-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-44-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.810',berat_out_asli='3.800', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.810',berat_akhir_asli =berat_akhir_asli-'3.800' WHERE kode_barang='MDGL-YKXE-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-251106-0001','45','MDGL-YKXE-45-0','1','3.710','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-45-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-45-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.710',berat_out_asli='3.700', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.710',berat_akhir_asli =berat_akhir_asli-'3.700' WHERE kode_barang='MDGL-YKXE-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-251106-0001','46','MDGL-YKXE-46-0','1','3.460','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-46-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-46-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.460',berat_out_asli='3.450', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.460',berat_akhir_asli =berat_akhir_asli-'3.450' WHERE kode_barang='MDGL-YKXE-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-251106-0001','47','MDGL-YKXE-47-0','1','3.790','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-47-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-47-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.790',berat_out_asli='3.780', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.790',berat_akhir_asli =berat_akhir_asli-'3.780' WHERE kode_barang='MDGL-YKXE-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-251106-0001','48','MDGL-YKXE-48-0','1','4.930','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-48-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-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-YKXE-48-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.930',berat_out_asli='4.920', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.930',berat_akhir_asli =berat_akhir_asli-'4.920' WHERE kode_barang='MDGL-YKXE-48-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','49','MDGL-YKXE-49-0','1','3.830','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-49-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-49-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-YKXE-49-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.830',berat_out_asli='3.820', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.830',berat_akhir_asli =berat_akhir_asli-'3.820' WHERE kode_barang='MDGL-YKXE-49-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','50','MDGL-YKXE-50-0','1','5.180','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-50-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-50-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-YKXE-50-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.180',berat_out_asli='5.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.180',berat_akhir_asli =berat_akhir_asli-'5.170' WHERE kode_barang='MDGL-YKXE-50-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','51','MDGL-YKXE-51-0','1','3.030','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-51-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-51-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-YKXE-51-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.030',berat_out_asli='3.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.030',berat_akhir_asli =berat_akhir_asli-'3.020' WHERE kode_barang='MDGL-YKXE-51-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','52','MDGL-YKXE-52-0','1','3.520','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-52-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-52-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-YKXE-52-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.520',berat_out_asli='3.510', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.520',berat_akhir_asli =berat_akhir_asli-'3.510' WHERE kode_barang='MDGL-YKXE-52-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','53','MDGL-YKXE-53-0','1','3.470','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-53-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-53-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-YKXE-53-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.470',berat_out_asli='3.460', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.470',berat_akhir_asli =berat_akhir_asli-'3.460' WHERE kode_barang='MDGL-YKXE-53-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','54','MDGL-YKXE-54-0','1','3.690','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-54-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-54-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-YKXE-54-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.690',berat_out_asli='3.680', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.690',berat_akhir_asli =berat_akhir_asli-'3.680' WHERE kode_barang='MDGL-YKXE-54-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','55','MDGL-YKXE-55-0','1','2.970','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-55-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-55-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-YKXE-55-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.970',berat_out_asli='2.960', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.970',berat_akhir_asli =berat_akhir_asli-'2.960' WHERE kode_barang='MDGL-YKXE-55-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','56','MDGL-YKXE-56-0','1','2.370','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-56-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-56-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-YKXE-56-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-YKXE-56-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','57','MDGL-YKXE-57-0','1','2.400','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-57-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-57-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-YKXE-57-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-YKXE-57-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','58','MDGL-YKXE-58-0','1','2.750','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-58-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-58-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-YKXE-58-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-YKXE-58-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','59','MDGL-YKXE-59-0','1','5.050','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-59-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-59-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-YKXE-59-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.050',berat_out_asli='5.040', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.050',berat_akhir_asli =berat_akhir_asli-'5.040' WHERE kode_barang='MDGL-YKXE-59-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','60','MDGL-YKXE-60-0','1','3.720','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-60-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-60-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-YKXE-60-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.720',berat_out_asli='3.710', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.720',berat_akhir_asli =berat_akhir_asli-'3.710' WHERE kode_barang='MDGL-YKXE-60-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','61','MDGL-YKXE-61-0','1','4.420','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-61-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-61-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-YKXE-61-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.420',berat_out_asli='4.410', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.420',berat_akhir_asli =berat_akhir_asli-'4.410' WHERE kode_barang='MDGL-YKXE-61-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','62','MDGL-YKXE-62-0','1','3.880','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-62-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-62-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-YKXE-62-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.880',berat_out_asli='3.870', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.880',berat_akhir_asli =berat_akhir_asli-'3.870' WHERE kode_barang='MDGL-YKXE-62-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','63','MDGL-YKXE-63-0','1','4.010','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-63-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-63-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-YKXE-63-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.010',berat_out_asli='4.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.010',berat_akhir_asli =berat_akhir_asli-'4.000' WHERE kode_barang='MDGL-YKXE-63-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','64','MDGL-YKXE-64-0','1','3.540','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-64-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-64-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-YKXE-64-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.540',berat_out_asli='3.530', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.540',berat_akhir_asli =berat_akhir_asli-'3.530' WHERE kode_barang='MDGL-YKXE-64-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','65','MDGL-YKXE-65-0','1','7.240','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-65-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-65-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-YKXE-65-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='7.240',berat_out_asli='7.230', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'7.240',berat_akhir_asli =berat_akhir_asli-'7.230' WHERE kode_barang='MDGL-YKXE-65-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','66','MDGL-YKXE-66-0','1','5.140','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-66-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-66-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-YKXE-66-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-YKXE-66-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','67','MDGL-YKXE-67-0','1','5.840','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-67-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-67-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-YKXE-67-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.840',berat_out_asli='5.830', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.840',berat_akhir_asli =berat_akhir_asli-'5.830' WHERE kode_barang='MDGL-YKXE-67-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','68','MDGL-YKXE-68-0','1','6.190','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-68-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-68-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-YKXE-68-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='6.190',berat_out_asli='6.180', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'6.190',berat_akhir_asli =berat_akhir_asli-'6.180' WHERE kode_barang='MDGL-YKXE-68-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','69','MDGL-YKXE-69-0','1','6.860','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-69-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-69-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-YKXE-69-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='6.860',berat_out_asli='6.850', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'6.860',berat_akhir_asli =berat_akhir_asli-'6.850' WHERE kode_barang='MDGL-YKXE-69-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','70','MDGL-YKXE-70-0','1','2.850','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-70-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-70-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-YKXE-70-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.850',berat_out_asli='2.840', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.850',berat_akhir_asli =berat_akhir_asli-'2.840' WHERE kode_barang='MDGL-YKXE-70-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','71','MDGL-YKXE-71-0','1','7.980','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-71-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-71-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-YKXE-71-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='7.980',berat_out_asli='7.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'7.980',berat_akhir_asli =berat_akhir_asli-'7.970' WHERE kode_barang='MDGL-YKXE-71-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','72','MDGL-YKXE-72-0','1','9.210','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-72-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-72-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-YKXE-72-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='9.210',berat_out_asli='9.200', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'9.210',berat_akhir_asli =berat_akhir_asli-'9.200' WHERE kode_barang='MDGL-YKXE-72-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','73','MDGL-YKXE-73-0','1','7.740','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-73-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-73-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-YKXE-73-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='7.740',berat_out_asli='7.730', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'7.740',berat_akhir_asli =berat_akhir_asli-'7.730' WHERE kode_barang='MDGL-YKXE-73-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','74','MDGL-YKXE-74-0','1','9.300','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-74-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-74-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-YKXE-74-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='9.300',berat_out_asli='9.290', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'9.300',berat_akhir_asli =berat_akhir_asli-'9.290' WHERE kode_barang='MDGL-YKXE-74-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','75','MDGL-YKXE-75-0','1','6.250','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-75-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-75-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-YKXE-75-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='6.250',berat_out_asli='6.240', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'6.250',berat_akhir_asli =berat_akhir_asli-'6.240' WHERE kode_barang='MDGL-YKXE-75-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','76','MDGL-YKXE-76-0','1','11.100','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-76-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-76-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-YKXE-76-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='11.100',berat_out_asli='11.090', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'11.100',berat_akhir_asli =berat_akhir_asli-'11.090' WHERE kode_barang='MDGL-YKXE-76-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','77','MDGL-YKXE-77-0','1','7.510','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-77-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-77-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-YKXE-77-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='7.510',berat_out_asli='7.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'7.510',berat_akhir_asli =berat_akhir_asli-'7.500' WHERE kode_barang='MDGL-YKXE-77-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','78','MDGL-YKXE-78-0','1','19.040','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-78-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-78-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-YKXE-78-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='19.040',berat_out_asli='19.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'19.040',berat_akhir_asli =berat_akhir_asli-'19.030' WHERE kode_barang='MDGL-YKXE-78-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','79','MDGL-YKXE-79-0','1','24.140','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-79-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-79-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-YKXE-79-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='24.140',berat_out_asli='24.130', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'24.140',berat_akhir_asli =berat_akhir_asli-'24.130' WHERE kode_barang='MDGL-YKXE-79-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','80','MDGL-YKXE-80-0','1','24.270','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-80-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-80-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-YKXE-80-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='24.270',berat_out_asli='24.260', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'24.270',berat_akhir_asli =berat_akhir_asli-'24.260' WHERE kode_barang='MDGL-YKXE-80-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0001','81','MDGL-YKXE-81-0','1','26.630','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKXE-81-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKXE-81-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-YKXE-81-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='26.630',berat_out_asli='26.620', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'26.630',berat_akhir_asli =berat_akhir_asli-'26.620' WHERE kode_barang='MDGL-YKXE-81-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-251106-0001','2025-11-06','2025-11-06','12:58','26.630','adminpusat','251106');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','1','MDKL-YKXE-82-0','1','3.100','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-82-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-82-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-82-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='MDKL-YKXE-82-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','2','MDKL-YKXE-83-0','1','3.100','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-83-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-83-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-83-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='MDKL-YKXE-83-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','3','MDKL-YKXE-84-0','1','1.960','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-84-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-84-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-84-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.960',berat_out_asli='1.950', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.960',berat_akhir_asli =berat_akhir_asli-'1.950' WHERE kode_barang='MDKL-YKXE-84-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','4','MDKL-YKXE-85-0','1','3.060','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-85-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-85-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-85-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.060',berat_out_asli='3.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.060',berat_akhir_asli =berat_akhir_asli-'3.050' WHERE kode_barang='MDKL-YKXE-85-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','5','MDKL-YKXE-86-0','1','2.260','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-86-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-86-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-86-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.260',berat_out_asli='2.250', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.260',berat_akhir_asli =berat_akhir_asli-'2.250' WHERE kode_barang='MDKL-YKXE-86-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','6','MDKL-YKXE-87-0','1','2.060','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-87-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-87-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-87-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='MDKL-YKXE-87-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','7','MDKL-YKXE-88-0','1','2.280','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-88-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-88-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-88-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.280',berat_out_asli='2.270', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.280',berat_akhir_asli =berat_akhir_asli-'2.270' WHERE kode_barang='MDKL-YKXE-88-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','8','MDKL-YKXE-89-0','1','9.290','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-89-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-89-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-89-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='9.290',berat_out_asli='9.280', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'9.290',berat_akhir_asli =berat_akhir_asli-'9.280' WHERE kode_barang='MDKL-YKXE-89-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','9','MDKL-YKXE-90-0','1','1.020','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-90-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-90-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-90-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.020',berat_out_asli='1.010', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.020',berat_akhir_asli =berat_akhir_asli-'1.010' WHERE kode_barang='MDKL-YKXE-90-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','10','MDKL-YKXE-91-0','1','2.760','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-91-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-91-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-91-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='MDKL-YKXE-91-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','11','MDKL-YKXE-92-0','1','3.090','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-92-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-92-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-92-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.090',berat_out_asli='3.080', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.090',berat_akhir_asli =berat_akhir_asli-'3.080' WHERE kode_barang='MDKL-YKXE-92-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','12','MDKL-YKXE-93-0','1','3.330','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-93-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-93-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-93-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.330',berat_out_asli='3.320', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.330',berat_akhir_asli =berat_akhir_asli-'3.320' WHERE kode_barang='MDKL-YKXE-93-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','13','MDKL-YKXE-94-0','1','3.450','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-94-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-94-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-94-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.450',berat_out_asli='3.440', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.450',berat_akhir_asli =berat_akhir_asli-'3.440' WHERE kode_barang='MDKL-YKXE-94-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','14','MDKL-YKXE-95-0','1','4.870','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-95-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-95-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-95-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.870',berat_out_asli='4.860', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.870',berat_akhir_asli =berat_akhir_asli-'4.860' WHERE kode_barang='MDKL-YKXE-95-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','15','MDKL-YKXE-96-0','1','4.940','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-96-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-96-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-96-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.940',berat_out_asli='4.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.940',berat_akhir_asli =berat_akhir_asli-'4.930' WHERE kode_barang='MDKL-YKXE-96-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','16','MDKL-YKXE-97-0','1','7.550','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-97-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-97-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-97-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='7.550',berat_out_asli='7.540', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'7.550',berat_akhir_asli =berat_akhir_asli-'7.540' WHERE kode_barang='MDKL-YKXE-97-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','17','MDKL-YKXE-98-0','1','3.100','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-98-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-98-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-98-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='MDKL-YKXE-98-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','18','MDKL-YKXE-99-0','1','9.950','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-99-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-99-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-99-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='9.950',berat_out_asli='9.940', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'9.950',berat_akhir_asli =berat_akhir_asli-'9.940' WHERE kode_barang='MDKL-YKXE-99-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','19','MDKL-YKXE-100-0','1','15.560','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-100-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-100-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-100-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='15.560',berat_out_asli='15.550', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'15.560',berat_akhir_asli =berat_akhir_asli-'15.550' WHERE kode_barang='MDKL-YKXE-100-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','20','MDKL-YKXE-101-0','1','9.020','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-101-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-101-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-101-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='9.020',berat_out_asli='9.010', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'9.020',berat_akhir_asli =berat_akhir_asli-'9.010' WHERE kode_barang='MDKL-YKXE-101-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','21','MDKL-YKXE-102-0','1','9.700','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-102-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-102-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-102-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='9.700',berat_out_asli='9.690', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'9.700',berat_akhir_asli =berat_akhir_asli-'9.690' WHERE kode_barang='MDKL-YKXE-102-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','22','MDKL-YKXE-103-0','1','10.170','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-103-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-103-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-103-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='10.170',berat_out_asli='10.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'10.170',berat_akhir_asli =berat_akhir_asli-'10.160' WHERE kode_barang='MDKL-YKXE-103-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','23','MDKL-YKXE-104-0','1','5.160','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-104-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-104-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-104-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.160',berat_out_asli='5.150', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.160',berat_akhir_asli =berat_akhir_asli-'5.150' WHERE kode_barang='MDKL-YKXE-104-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','24','MDKL-YKXE-105-0','1','3.400','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-105-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-105-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-105-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.400',berat_out_asli='3.390', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.400',berat_akhir_asli =berat_akhir_asli-'3.390' WHERE kode_barang='MDKL-YKXE-105-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','25','MDKL-YKXE-106-0','1','2.180','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-106-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-106-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-106-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.180',berat_out_asli='2.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.180',berat_akhir_asli =berat_akhir_asli-'2.170' WHERE kode_barang='MDKL-YKXE-106-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','26','MDKL-YKXE-107-0','1','3.550','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-107-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-107-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-107-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.550',berat_out_asli='3.540', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.550',berat_akhir_asli =berat_akhir_asli-'3.540' WHERE kode_barang='MDKL-YKXE-107-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','27','MDKL-YKXE-108-0','1','3.520','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-108-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-108-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-108-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.520',berat_out_asli='3.510', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.520',berat_akhir_asli =berat_akhir_asli-'3.510' WHERE kode_barang='MDKL-YKXE-108-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','28','MDKL-YKXE-109-0','1','2.810','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-109-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-109-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-109-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.810',berat_out_asli='2.800', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.810',berat_akhir_asli =berat_akhir_asli-'2.800' WHERE kode_barang='MDKL-YKXE-109-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','29','MDKL-YKXE-110-0','1','2.760','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-110-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-110-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-110-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='MDKL-YKXE-110-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','30','MDKL-YKXE-111-0','1','3.130','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-111-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-111-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-111-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.130',berat_out_asli='3.120', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.130',berat_akhir_asli =berat_akhir_asli-'3.120' WHERE kode_barang='MDKL-YKXE-111-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','31','MDKL-YKXE-112-0','1','3.110','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-112-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-112-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-112-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='MDKL-YKXE-112-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0002','32','MDKL-YKXE-113-0','1','2.900','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKXE-113-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKXE-113-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='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKXE-113-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.900',berat_out_asli='2.890', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.900',berat_akhir_asli =berat_akhir_asli-'2.890' WHERE kode_barang='MDKL-YKXE-113-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-251106-0002','2025-11-06','2025-11-06','12:58','2.900','adminpusat','251106');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','1','MDLT-YKXE-114-0','1','0.850','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-114-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-114-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-114-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.850',berat_out_asli='0.840', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.850',berat_akhir_asli =berat_akhir_asli-'0.840' WHERE kode_barang='MDLT-YKXE-114-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','2','MDLT-YKXE-115-0','1','0.850','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-115-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-115-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-115-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.850',berat_out_asli='0.840', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.850',berat_akhir_asli =berat_akhir_asli-'0.840' WHERE kode_barang='MDLT-YKXE-115-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','3','MDLT-YKXE-116-0','1','0.960','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-116-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-116-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-116-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.960',berat_out_asli='0.950', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.960',berat_akhir_asli =berat_akhir_asli-'0.950' WHERE kode_barang='MDLT-YKXE-116-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','4','MDLT-YKXE-117-0','1','0.960','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-117-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-117-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-117-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.960',berat_out_asli='0.950', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.960',berat_akhir_asli =berat_akhir_asli-'0.950' WHERE kode_barang='MDLT-YKXE-117-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','5','MDLT-YKXE-118-0','1','0.980','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-118-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-118-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-118-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.980',berat_out_asli='0.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.980',berat_akhir_asli =berat_akhir_asli-'0.970' WHERE kode_barang='MDLT-YKXE-118-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','6','MDLT-YKXE-119-0','1','1.000','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-119-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-119-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-119-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.000',berat_out_asli='0.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.000',berat_akhir_asli =berat_akhir_asli-'0.990' WHERE kode_barang='MDLT-YKXE-119-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','7','MDLT-YKXE-120-0','1','0.950','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-120-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-120-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-120-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.950',berat_out_asli='0.940', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.950',berat_akhir_asli =berat_akhir_asli-'0.940' WHERE kode_barang='MDLT-YKXE-120-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','8','MDLT-YKXE-121-0','1','0.860','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-121-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-121-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-121-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.860',berat_out_asli='0.850', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.860',berat_akhir_asli =berat_akhir_asli-'0.850' WHERE kode_barang='MDLT-YKXE-121-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','9','MDLT-YKXE-122-0','1','0.920','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-122-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-122-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-122-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.920',berat_out_asli='0.910', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.920',berat_akhir_asli =berat_akhir_asli-'0.910' WHERE kode_barang='MDLT-YKXE-122-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','10','MDLT-YKXE-123-0','1','0.880','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-123-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-123-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-123-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.880',berat_out_asli='0.870', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.880',berat_akhir_asli =berat_akhir_asli-'0.870' WHERE kode_barang='MDLT-YKXE-123-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','11','MDLT-YKXE-124-0','1','0.900','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-124-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-124-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-124-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.900',berat_out_asli='0.890', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.900',berat_akhir_asli =berat_akhir_asli-'0.890' WHERE kode_barang='MDLT-YKXE-124-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','12','MDLT-YKXE-125-0','1','1.020','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-125-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-125-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-125-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.020',berat_out_asli='1.010', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.020',berat_akhir_asli =berat_akhir_asli-'1.010' WHERE kode_barang='MDLT-YKXE-125-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','13','MDLT-YKXE-126-0','1','0.980','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-126-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-126-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-126-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.980',berat_out_asli='0.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.980',berat_akhir_asli =berat_akhir_asli-'0.970' WHERE kode_barang='MDLT-YKXE-126-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','14','MDLT-YKXE-127-0','1','0.940','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-127-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-127-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-127-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.940',berat_out_asli='0.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.940',berat_akhir_asli =berat_akhir_asli-'0.930' WHERE kode_barang='MDLT-YKXE-127-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','15','MDLT-YKXE-128-0','1','0.940','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-128-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-128-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-128-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.940',berat_out_asli='0.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.940',berat_akhir_asli =berat_akhir_asli-'0.930' WHERE kode_barang='MDLT-YKXE-128-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','16','MDLT-YKXE-129-0','1','0.920','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-129-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-129-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-129-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.920',berat_out_asli='0.910', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.920',berat_akhir_asli =berat_akhir_asli-'0.910' WHERE kode_barang='MDLT-YKXE-129-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','17','MDLT-YKXE-130-0','1','0.930','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-130-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-130-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-130-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.930',berat_out_asli='0.920', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.930',berat_akhir_asli =berat_akhir_asli-'0.920' WHERE kode_barang='MDLT-YKXE-130-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','18','MDLT-YKXE-131-0','1','0.910','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-131-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-131-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-131-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.910',berat_out_asli='0.900', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.910',berat_akhir_asli =berat_akhir_asli-'0.900' WHERE kode_barang='MDLT-YKXE-131-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','19','MDLT-YKXE-132-0','1','1.000','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-132-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-132-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-132-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.000',berat_out_asli='0.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.000',berat_akhir_asli =berat_akhir_asli-'0.990' WHERE kode_barang='MDLT-YKXE-132-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','20','MDLT-YKXE-133-0','1','1.000','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-133-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-133-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-133-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.000',berat_out_asli='0.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.000',berat_akhir_asli =berat_akhir_asli-'0.990' WHERE kode_barang='MDLT-YKXE-133-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','21','MDLT-YKXE-134-0','1','1.200','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-134-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-134-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-134-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.200',berat_out_asli='1.190', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.200',berat_akhir_asli =berat_akhir_asli-'1.190' WHERE kode_barang='MDLT-YKXE-134-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','22','MDLT-YKXE-135-0','1','0.810','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-135-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-135-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-135-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.810',berat_out_asli='0.800', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.810',berat_akhir_asli =berat_akhir_asli-'0.800' WHERE kode_barang='MDLT-YKXE-135-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','23','MDLT-YKXE-136-0','1','1.080','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-136-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-136-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-136-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.080',berat_out_asli='1.070', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.080',berat_akhir_asli =berat_akhir_asli-'1.070' WHERE kode_barang='MDLT-YKXE-136-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','24','MDLT-YKXE-137-0','1','1.080','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-137-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-137-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-137-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.080',berat_out_asli='1.070', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.080',berat_akhir_asli =berat_akhir_asli-'1.070' WHERE kode_barang='MDLT-YKXE-137-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','25','MDLT-YKXE-138-0','1','0.860','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-138-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-138-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-138-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.860',berat_out_asli='0.850', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.860',berat_akhir_asli =berat_akhir_asli-'0.850' WHERE kode_barang='MDLT-YKXE-138-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','26','MDLT-YKXE-139-0','1','0.880','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-139-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-139-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-139-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.880',berat_out_asli='0.870', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.880',berat_akhir_asli =berat_akhir_asli-'0.870' WHERE kode_barang='MDLT-YKXE-139-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','27','MDLT-YKXE-140-0','1','1.040','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-140-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-140-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-140-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.040',berat_out_asli='1.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.040',berat_akhir_asli =berat_akhir_asli-'1.030' WHERE kode_barang='MDLT-YKXE-140-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','28','MDLT-YKXE-141-0','1','1.010','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-141-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-141-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-141-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.010',berat_out_asli='1.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.010',berat_akhir_asli =berat_akhir_asli-'1.000' WHERE kode_barang='MDLT-YKXE-141-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','29','MDLT-YKXE-142-0','1','0.870','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-142-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-142-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-142-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.870',berat_out_asli='0.860', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.870',berat_akhir_asli =berat_akhir_asli-'0.860' WHERE kode_barang='MDLT-YKXE-142-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','30','MDLT-YKXE-143-0','1','0.860','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-143-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-143-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-143-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.860',berat_out_asli='0.850', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.860',berat_akhir_asli =berat_akhir_asli-'0.850' WHERE kode_barang='MDLT-YKXE-143-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','31','MDLT-YKXE-144-0','1','0.890','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-144-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-144-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-144-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.890',berat_out_asli='0.880', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.890',berat_akhir_asli =berat_akhir_asli-'0.880' WHERE kode_barang='MDLT-YKXE-144-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','32','MDLT-YKXE-145-0','1','0.860','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-145-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-145-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-145-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.860',berat_out_asli='0.850', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.860',berat_akhir_asli =berat_akhir_asli-'0.850' WHERE kode_barang='MDLT-YKXE-145-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','33','MDLT-YKXE-146-0','1','0.850','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-146-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-146-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-146-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.850',berat_out_asli='0.840', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.850',berat_akhir_asli =berat_akhir_asli-'0.840' WHERE kode_barang='MDLT-YKXE-146-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','34','MDLT-YKXE-147-0','1','1.100','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-147-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-147-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-147-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.100',berat_out_asli='1.090', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.100',berat_akhir_asli =berat_akhir_asli-'1.090' WHERE kode_barang='MDLT-YKXE-147-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','35','MDLT-YKXE-148-0','1','1.140','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-148-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-148-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-148-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.140',berat_out_asli='1.130', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.140',berat_akhir_asli =berat_akhir_asli-'1.130' WHERE kode_barang='MDLT-YKXE-148-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','36','MDLT-YKXE-149-0','1','1.480','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-149-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-149-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-149-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.480',berat_out_asli='1.470', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.480',berat_akhir_asli =berat_akhir_asli-'1.470' WHERE kode_barang='MDLT-YKXE-149-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','37','MDLT-YKXE-150-0','1','0.580','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-150-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-150-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-150-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.580',berat_out_asli='0.570', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.580',berat_akhir_asli =berat_akhir_asli-'0.570' WHERE kode_barang='MDLT-YKXE-150-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','38','MDLT-YKXE-151-0','1','1.400','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-151-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-151-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-151-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.400',berat_out_asli='1.390', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.400',berat_akhir_asli =berat_akhir_asli-'1.390' WHERE kode_barang='MDLT-YKXE-151-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','39','MDLT-YKXE-152-0','1','1.690','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-152-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-152-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-152-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.690',berat_out_asli='1.680', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.690',berat_akhir_asli =berat_akhir_asli-'1.680' WHERE kode_barang='MDLT-YKXE-152-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','40','MDLT-YKXE-153-0','1','1.700','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-153-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-153-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-153-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.700',berat_out_asli='1.690', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.700',berat_akhir_asli =berat_akhir_asli-'1.690' WHERE kode_barang='MDLT-YKXE-153-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','41','MDLT-YKXE-154-0','1','1.460','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-154-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-154-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-154-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.460',berat_out_asli='1.450', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.460',berat_akhir_asli =berat_akhir_asli-'1.450' WHERE kode_barang='MDLT-YKXE-154-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251106-0003','42','MDLT-YKXE-155-0','1','1.730','TOKO','BLTMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-YKXE-155-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDLT-YKXE-155-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BLTMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BLTMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDLT-YKXE-155-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.730',berat_out_asli='1.720', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.730',berat_akhir_asli =berat_akhir_asli-'1.720' WHERE kode_barang='MDLT-YKXE-155-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-251106-0003','2025-11-06','2025-11-06','12:59','1.730','adminpusat','251106');