INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251005-0001','1','A1E-YJXD-155-0','1','0.480','0.480','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YJXD-155-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YJXD-155-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2025-10-05 16:36:17' WHERE kode_barang='A1E-YJXD-155-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YJXD-155-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-05 16:36:17','TOKO','SMBK-A','A1E','A1E-YJXD-155-0','1','0.480','0.480','1','0.480','0.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-YJXD-155-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YJXD-155-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251005-0001','1','A1E-YJXD-156-0','1','0.500','0.500','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YJXD-156-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YJXD-156-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2025-10-05 16:36:17' WHERE kode_barang='A1E-YJXD-156-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YJXD-156-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-05 16:36:17','TOKO','SMBK-A','A1E','A1E-YJXD-156-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-YJXD-156-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YJXD-156-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251005-0001','2025-10-05','16:36','0.980','irgosa','2025-10-05 16:36:16');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251005-0001','1','B1E-YJXD-79-0','1','0.670','0.670','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-YJXD-79-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-YJXD-79-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2025-10-05 16:36:32' WHERE kode_barang='B1E-YJXD-79-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-YJXD-79-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-05 16:36:32','TOKO','SMBK-B','B1E','B1E-YJXD-79-0','1','0.670','0.670','1','0.670','0.670','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-YJXD-79-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-YJXD-79-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251005-0001','1','B1H-YJXD-82-0','1','0.260','0.260','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1H-YJXD-82-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1H-YJXD-82-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2025-10-05 16:36:32' WHERE kode_barang='B1H-YJXD-82-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1H-YJXD-82-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-05 16:36:32','TOKO','SMBK-B','B1H','B1H-YJXD-82-0','1','0.260','0.260','1','0.260','0.260','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1H' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1H' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MH' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MH' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1H-YJXD-82-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1H-YJXD-82-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251005-0001','1','B1H-YJXD-83-0','1','0.280','0.280','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1H-YJXD-83-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1H-YJXD-83-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2025-10-05 16:36:32' WHERE kode_barang='B1H-YJXD-83-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1H-YJXD-83-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-05 16:36:32','TOKO','SMBK-B','B1H','B1H-YJXD-83-0','1','0.280','0.280','1','0.280','0.280','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1H' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1H' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MH' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MH' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1H-YJXD-83-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1H-YJXD-83-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251005-0001','1','B0C-YJXD-147-0','1','0.550','0.550','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B0C-YJXD-147-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B0C-YJXD-147-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2025-10-05 16:36:32' WHERE kode_barang='B0C-YJXD-147-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B0C-YJXD-147-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-05 16:36:32','TOKO','SMBK-B','B0C','B0C-YJXD-147-0','1','0.550','0.550','1','0.550','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='B0C' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B0C' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MC' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MC' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B0C-YJXD-147-0';
DELETE FROM tm_barang_export WHERE kode_barang='B0C-YJXD-147-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251005-0001','1','B0C-YJXD-154-0','1','0.530','0.530','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B0C-YJXD-154-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B0C-YJXD-154-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2025-10-05 16:36:32' WHERE kode_barang='B0C-YJXD-154-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B0C-YJXD-154-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-05 16:36:32','TOKO','SMBK-B','B0C','B0C-YJXD-154-0','1','0.530','0.530','1','0.530','0.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='B0C' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B0C' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MC' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MC' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B0C-YJXD-154-0';
DELETE FROM tm_barang_export WHERE kode_barang='B0C-YJXD-154-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251005-0001','2025-10-05','16:36','2.290','irgosa','2025-10-05 16:36:32');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251005-0001','1','D1G-YIAE-107-0','1','0.320','0.320','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1G-YIAE-107-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1G-YIAE-107-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2025-10-05 16:36:47' WHERE kode_barang='D1G-YIAE-107-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1G-YIAE-107-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-05 16:36:47','TOKO','SMBK-D','D1G','D1G-YIAE-107-0','1','0.320','0.320','1','0.320','0.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1G-YIAE-107-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1G-YIAE-107-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251005-0001','1','D1F-YJXD-143-0','1','0.870','0.870','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-YJXD-143-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-YJXD-143-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2025-10-05 16:36:47' WHERE kode_barang='D1F-YJXD-143-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-YJXD-143-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-05 16:36:47','TOKO','SMBK-D','D1F','D1F-YJXD-143-0','1','0.870','0.870','1','0.870','0.870','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-YJXD-143-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-YJXD-143-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251005-0001','2025-10-05','16:36','1.190','irgosa','2025-10-05 16:36:47');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251005-0001','1','E2E-YIBB-75-0','1','0.650','0.650','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YIBB-75-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YIBB-75-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-10-05 16:37:00' WHERE kode_barang='E2E-YIBB-75-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YIBB-75-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-05 16:37:00','TOKO','SMBK-E','E2E','E2E-YIBB-75-0','1','0.650','0.650','1','0.650','0.650','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-YIBB-75-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YIBB-75-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251005-0001','1','E2E-YIBB-94-0','1','0.550','0.550','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YIBB-94-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YIBB-94-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-10-05 16:37:00' WHERE kode_barang='E2E-YIBB-94-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YIBB-94-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-05 16:37:00','TOKO','SMBK-E','E2E','E2E-YIBB-94-0','1','0.550','0.550','1','0.550','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-YIBB-94-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YIBB-94-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251005-0001','1','E2E-YIBI-194-0','1','0.500','0.500','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YIBI-194-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YIBI-194-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-10-05 16:37:00' WHERE kode_barang='E2E-YIBI-194-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YIBI-194-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-05 16:37:00','TOKO','SMBK-E','E2E','E2E-YIBI-194-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-YIBI-194-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YIBI-194-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251005-0001','1','E2D-YJXD-48-0','1','2.000','2.000','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YJXD-48-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YJXD-48-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-10-05 16:37:00' WHERE kode_barang='E2D-YJXD-48-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YJXD-48-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-05 16:37:00','TOKO','SMBK-E','E2D','E2D-YJXD-48-0','1','2.000','2.000','1','2.000','2.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-YJXD-48-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YJXD-48-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251005-0001','1','E2E-YJXD-56-0','1','0.550','0.550','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YJXD-56-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YJXD-56-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-10-05 16:37:00' WHERE kode_barang='E2E-YJXD-56-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YJXD-56-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-05 16:37:00','TOKO','SMBK-E','E2E','E2E-YJXD-56-0','1','0.550','0.550','1','0.550','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-YJXD-56-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YJXD-56-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251005-0001','1','E2E-YJXD-58-0','1','0.550','0.550','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YJXD-58-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YJXD-58-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-10-05 16:37:00' WHERE kode_barang='E2E-YJXD-58-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YJXD-58-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-05 16:37:00','TOKO','SMBK-E','E2E','E2E-YJXD-58-0','1','0.550','0.550','1','0.550','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-YJXD-58-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YJXD-58-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251005-0001','2025-10-05','16:36','4.800','irgosa','2025-10-05 16:37:00');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251005-0001','1','F4I-XAAB-98-0','1','4.710','4.710','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F4I-XAAB-98-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F4I-XAAB-98-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2025-10-05 16:37:14' WHERE kode_barang='F4I-XAAB-98-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F4I-XAAB-98-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-05 16:37:14','TOKO','SMBK-F','F4I','F4I-XAAB-98-0','1','4.710','4.710','1','4.710','4.710','100.00');
DELETE FROM tm_dept WHERE kode_dept='F4I' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F4I' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MI' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MI' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F4I-XAAB-98-0';
DELETE FROM tm_barang_export WHERE kode_barang='F4I-XAAB-98-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251005-0001','2025-10-05','16:37','4.710','irgosa','2025-10-05 16:37:14');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251005-0001','1','A1E-XHAG-21-T','1','0.670','TOKO','BK-A');
DELETE FROM tm_barang_export WHERE kode_barang='A1E-XHAG-21-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='A1E-XHAG-21-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='ME' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='ME' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-A';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-A';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='A1E-XHAG-21-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.670',berat_out_asli='0.670', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.670',berat_akhir_asli =berat_akhir_asli-'0.670' WHERE kode_barang='A1E-XHAG-21-T' 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-251005-0001','2025-10-05','2025-10-05','16:43','0.670','irgosa','251005');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251005-0002','1','F3E-YCBX-55-T','1','2.150','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YCBX-55-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-YCBX-55-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='ME' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='ME' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-F';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-F';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='F3E-YCBX-55-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.150',berat_out_asli='2.150', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.150',berat_akhir_asli =berat_akhir_asli-'2.150' WHERE kode_barang='F3E-YCBX-55-T' 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-251005-0002','2025-10-05','2025-10-05','16:43','2.150','irgosa','251005');