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-20260305-0001','1','E2D-YEXA-118-0','1','0.970','0.970','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YEXA-118-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YEXA-118-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-05 07:43:22' WHERE kode_barang='E2D-YEXA-118-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YEXA-118-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 ('2026-03-05 07:43:22','TOKO','PM-E','E2D','E2D-YEXA-118-0','1','0.970','0.970','1','0.970','0.970','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-YEXA-118-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YEXA-118-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-20260305-0001','1','E1D-ZCXB-165-0','1','0.670','0.670','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZCXB-165-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZCXB-165-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-05 07:43:22' WHERE kode_barang='E1D-ZCXB-165-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZCXB-165-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 ('2026-03-05 07:43:22','TOKO','PM-E','E1D','E1D-ZCXB-165-0','1','0.670','0.670','1','0.670','0.670','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' 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='E1D-ZCXB-165-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZCXB-165-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260305-0001','2026-03-05','07:43','1.640','admpindah','2026-03-05 07:43:21');
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-20260305-0001','1','F1E-ZBBE-61-0','1','1.510','1.510','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZBBE-61-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZBBE-61-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-03-05 07:43:38' WHERE kode_barang='F1E-ZBBE-61-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZBBE-61-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 ('2026-03-05 07:43:38','TOKO','PM-F','F1E','F1E-ZBBE-61-0','1','1.510','1.510','1','1.510','1.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' 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='F1E-ZBBE-61-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZBBE-61-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260305-0001','2026-03-05','07:43','1.510','admpindah','2026-03-05 07:43:37');
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0002953' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0002941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0002939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0002936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0002933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0002942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0002950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0002947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0002945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0002944' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0002931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0002930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4216000',harga_beli ='4216000' WHERE kode_barcode='T0002720' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='12840000',harga_beli ='12840000' WHERE kode_barcode='T0002458' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10700000',harga_beli ='10700000' WHERE kode_barcode='T0002457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10700000',harga_beli ='10700000' WHERE kode_barcode='T0002456' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0002454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0002451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='12754500',harga_beli ='12754500' WHERE kode_barcode='T0002721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10657500',harga_beli ='10657500' WHERE kode_barcode='T0002722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0002929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0002927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0002450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10700000',harga_beli ='10700000' WHERE kode_barcode='T0002978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10700000',harga_beli ='10700000' WHERE kode_barcode='T0002977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10700000',harga_beli ='10700000' WHERE kode_barcode='T0002976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10700000',harga_beli ='10700000' WHERE kode_barcode='T0002975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0002963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0002962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0002961' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0002960' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0002959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0002964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0002965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0002971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0002970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0002969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0002968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0002967' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0002966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0002954' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0002392' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0002390' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0002389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0002394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0002402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0002382' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0002369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0002367' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0002366' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0002370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0002371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0002380' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0002378' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0002377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0002376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0002374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0002372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0002360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='21400000',harga_beli ='21400000' WHERE kode_barcode='T0002449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0002435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10700000',harga_beli ='10700000' WHERE kode_barcode='T0002432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10700000',harga_beli ='10700000' WHERE kode_barcode='T0002430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10700000',harga_beli ='10700000' WHERE kode_barcode='T0002448' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10700000',harga_beli ='10700000' WHERE kode_barcode='T0002447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0002446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0002445' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0002427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0002409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0002408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0002407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0002415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0002425' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0002421' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0002420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003607' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0003609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0003610' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0003611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0003622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0003623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003641' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003643' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003645' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0003647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0003648' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0003657' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0003670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0003672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0003673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0003674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0003676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0003677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0003678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003574' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1006000',harga_beli ='1006000' WHERE kode_barcode='T0003412' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003994' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0004018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0004015' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0004014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0004012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0003885' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0003886' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0003887' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0003888' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0003889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0003890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0003891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0003892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0003893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0003894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0003896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0003897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0003899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003904' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003916' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003922' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0003932' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0003933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0003935' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0003936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0003937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0003939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0003940' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0003941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0003942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0003943' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0003944' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0003946' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0003947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0003948' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0003949' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0003950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0004083' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0004084' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0004149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0004150' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0004153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0004158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0004161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0004162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0004165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10700000',harga_beli ='10700000' WHERE kode_barcode='T0004167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10700000',harga_beli ='10700000' WHERE kode_barcode='T0004168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='12840000',harga_beli ='12840000' WHERE kode_barcode='T0004170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='12840000',harga_beli ='12840000' WHERE kode_barcode='T0004171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='12840000',harga_beli ='12840000' WHERE kode_barcode='T0004172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='17120000',harga_beli ='17120000' WHERE kode_barcode='T0004175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='21400000',harga_beli ='21400000' WHERE kode_barcode='T0004177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='14980000',harga_beli ='14980000' WHERE kode_barcode='T0004185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0004191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10700000',harga_beli ='10700000' WHERE kode_barcode='T0004195' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10700000',harga_beli ='10700000' WHERE kode_barcode='T0004196' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='14980000',harga_beli ='14980000' WHERE kode_barcode='T0004199' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='14980000',harga_beli ='14980000' WHERE kode_barcode='T0004200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2247000',harga_beli ='2247000' WHERE kode_barcode='T0009250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0029917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0027569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0027570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0027572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10700000',harga_beli ='10700000' WHERE kode_barcode='T0027624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10700000',harga_beli ='10700000' WHERE kode_barcode='T0027626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='12883000',harga_beli ='12883000' WHERE kode_barcode='T0029878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2097500',harga_beli ='2097500' WHERE kode_barcode='T0032972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8496000',harga_beli ='8496000' WHERE kode_barcode='T0032971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0032970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0032968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2161500',harga_beli ='2161500' WHERE kode_barcode='T0032966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2097500',harga_beli ='2097500' WHERE kode_barcode='T0032965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0032964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0032974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0032975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4194500',harga_beli ='4194500' WHERE kode_barcode='T0032963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1134500',harga_beli ='1134500' WHERE kode_barcode='T0033067' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0033058' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8496000',harga_beli ='8496000' WHERE kode_barcode='T0034745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6377500',harga_beli ='6377500' WHERE kode_barcode='T0034750' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='17120000',harga_beli ='17120000' WHERE kode_barcode='T0034746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0035992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0035990' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0035989' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0035987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0035986' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0035985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0035984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0035983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0036163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='11984000',harga_beli ='11984000' WHERE kode_barcode='T0036779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3103000',harga_beli ='3103000' WHERE kode_barcode='T0042513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6463000',harga_beli ='6463000' WHERE kode_barcode='T0043865' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0043877' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0043873' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6463000',harga_beli ='6463000' WHERE kode_barcode='T0043872' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10700000',harga_beli ='10700000' WHERE kode_barcode='T0043871' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4323000',harga_beli ='4323000' WHERE kode_barcode='T0043870' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0043869' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0043867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0043864' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10700000',harga_beli ='10700000' WHERE kode_barcode='T0043859' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1113000',harga_beli ='1113000' WHERE kode_barcode='T0044183' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0044191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0044193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0044178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4173000',harga_beli ='4173000' WHERE kode_barcode='T0044177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6334500',harga_beli ='6334500' WHERE kode_barcode='T0044176' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0044175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0044173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0044172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3317000',harga_beli ='3317000' WHERE kode_barcode='T0044171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0044170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0044168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2076000',harga_beli ='2076000' WHERE kode_barcode='T0048348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0048349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0048350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3231500',harga_beli ='3231500' WHERE kode_barcode='T0048351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0048352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0048353' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4194500',harga_beli ='4194500' WHERE kode_barcode='T0048355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0048356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2033000',harga_beli ='2033000' WHERE kode_barcode='T0048357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0041546' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6313000',harga_beli ='6313000' WHERE kode_barcode='T0052773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0052781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2097500',harga_beli ='2097500' WHERE kode_barcode='T0052780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0052779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2161500',harga_beli ='2161500' WHERE kode_barcode='T0052778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4323000',harga_beli ='4323000' WHERE kode_barcode='T0052777' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4237500',harga_beli ='4237500' WHERE kode_barcode='T0052776' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10529000',harga_beli ='10529000' WHERE kode_barcode='T0052775' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0052774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0052771' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3959000',harga_beli ='3959000' WHERE kode_barcode='T0052770' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8453000',harga_beli ='8453000' WHERE kode_barcode='T0052769' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6334500',harga_beli ='6334500' WHERE kode_barcode='T0052768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='21421500',harga_beli ='21421500' WHERE kode_barcode='T0052766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='21421500',harga_beli ='21421500' WHERE kode_barcode='T0052765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0052835' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0056350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0056351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0056352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0056355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0056356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1027500',harga_beli ='1027500' WHERE kode_barcode='T0056800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4301500',harga_beli ='4301500' WHERE kode_barcode='T0056817' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10700000',harga_beli ='10700000' WHERE kode_barcode='T0056818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10700000',harga_beli ='10700000' WHERE kode_barcode='T0056819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4194500',harga_beli ='4194500' WHERE kode_barcode='T0056820' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0056821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10743000',harga_beli ='10743000' WHERE kode_barcode='T0056822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8517500',harga_beli ='8517500' WHERE kode_barcode='T0056823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8517500',harga_beli ='8517500' WHERE kode_barcode='T0056824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4301500',harga_beli ='4301500' WHERE kode_barcode='T0056825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3103000',harga_beli ='3103000' WHERE kode_barcode='T0056826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0056827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2097500',harga_beli ='2097500' WHERE kode_barcode='T0056828' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2097500',harga_beli ='2097500' WHERE kode_barcode='T0056829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0069555' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0069556' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0069569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0069557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0069558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0069559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0069560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4280000',harga_beli ='4280000' WHERE kode_barcode='T0069561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0069562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0069563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3210000',harga_beli ='3210000' WHERE kode_barcode='T0069564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='8560000',harga_beli ='8560000' WHERE kode_barcode='T0069565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='10743000',harga_beli ='10743000' WHERE kode_barcode='T0069566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6420000',harga_beli ='6420000' WHERE kode_barcode='T0069567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6463000',harga_beli ='6463000' WHERE kode_barcode='T0069568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1070000',harga_beli ='1070000' WHERE kode_barcode='T0074543' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='984500',harga_beli ='984500' WHERE kode_barcode='T0074544' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='1027500',harga_beli ='1027500' WHERE kode_barcode='T0074545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='984500',harga_beli ='984500' WHERE kode_barcode='T0074546' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='3467000',harga_beli ='3467000' WHERE kode_barcode='T0074549' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='6762500',harga_beli ='6762500' WHERE kode_barcode='T0074550' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2033000',harga_beli ='2033000' WHERE kode_barcode='T0076225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2140000',harga_beli ='2140000' WHERE kode_barcode='T0076226' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2183000',harga_beli ='2183000' WHERE kode_barcode='T0076227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='2097500',harga_beli ='2097500' WHERE kode_barcode='T0076230' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2140000',harga_jual='4366000',harga_beli ='4366000' WHERE kode_barcode='T0076231' LIMIT 1;
UPDATE tm_group SET harga='2140000' WHERE kode_group = 'TA' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TA','2140000','input','2026-03-05 08:16:49');
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2320500',harga_beli ='2320500' WHERE kode_barcode='T0072610' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2829000',harga_beli ='2829000' WHERE kode_barcode='T0075742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2276500',harga_beli ='2276500' WHERE kode_barcode='T0074492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2298500',harga_beli ='2298500' WHERE kode_barcode='T0074491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2718500',harga_beli ='2718500' WHERE kode_barcode='T0073765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='3492000',harga_beli ='3492000' WHERE kode_barcode='T0073759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='1834500',harga_beli ='1834500' WHERE kode_barcode='T0073760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='3006000',harga_beli ='3006000' WHERE kode_barcode='T0072972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2320500',harga_beli ='2320500' WHERE kode_barcode='T0072612' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2873000',harga_beli ='2873000' WHERE kode_barcode='T0075743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2608000',harga_beli ='2608000' WHERE kode_barcode='T0072609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2166000',harga_beli ='2166000' WHERE kode_barcode='T0071651' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2939500',harga_beli ='2939500' WHERE kode_barcode='T0071528' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='4486500',harga_beli ='4486500' WHERE kode_barcode='T0071248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='4332000',harga_beli ='4332000' WHERE kode_barcode='T0070765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='3138500',harga_beli ='3138500' WHERE kode_barcode='T0070512' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2785000',harga_beli ='2785000' WHERE kode_barcode='T0070510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='1945000',harga_beli ='1945000' WHERE kode_barcode='T0070508' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='3094000',harga_beli ='3094000' WHERE kode_barcode='T0075759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='3271000',harga_beli ='3271000' WHERE kode_barcode='T0076236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='3602500',harga_beli ='3602500' WHERE kode_barcode='T0076235' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2343000',harga_beli ='2343000' WHERE kode_barcode='T0076234' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2387000',harga_beli ='2387000' WHERE kode_barcode='T0076229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='4376000',harga_beli ='4376000' WHERE kode_barcode='T0075766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='4420000',harga_beli ='4420000' WHERE kode_barcode='T0075763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='3271000',harga_beli ='3271000' WHERE kode_barcode='T0075762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='3691000',harga_beli ='3691000' WHERE kode_barcode='T0075761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2122000',harga_beli ='2122000' WHERE kode_barcode='T0070505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2387000',harga_beli ='2387000' WHERE kode_barcode='T0075758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2011500',harga_beli ='2011500' WHERE kode_barcode='T0075757' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='3735000',harga_beli ='3735000' WHERE kode_barcode='T0075756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='3094000',harga_beli ='3094000' WHERE kode_barcode='T0075751' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2895500',harga_beli ='2895500' WHERE kode_barcode='T0075747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='3160500',harga_beli ='3160500' WHERE kode_barcode='T0075746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2320500',harga_beli ='2320500' WHERE kode_barcode='T0075745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2674500',harga_beli ='2674500' WHERE kode_barcode='T0072982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='5260000',harga_beli ='5260000' WHERE kode_barcode='T0062997' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2564000',harga_beli ='2564000' WHERE kode_barcode='T0063000' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2166000',harga_beli ='2166000' WHERE kode_barcode='T0063003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2099500',harga_beli ='2099500' WHERE kode_barcode='T0063006' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='5083000',harga_beli ='5083000' WHERE kode_barcode='T0072978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='5304000',harga_beli ='5304000' WHERE kode_barcode='T0062985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2210000',harga_beli ='2210000' WHERE kode_barcode='T0072986' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2939500',harga_beli ='2939500' WHERE kode_barcode='T0072985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='3912000',harga_beli ='3912000' WHERE kode_barcode='T0062995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2785000',harga_beli ='2785000' WHERE kode_barcode='T0072979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='4530500',harga_beli ='4530500' WHERE kode_barcode='T0063014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='4155000',harga_beli ='4155000' WHERE kode_barcode='T0063013' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2873000',harga_beli ='2873000' WHERE kode_barcode='T0062984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='3558500',harga_beli ='3558500' WHERE kode_barcode='T0062972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2762500',harga_beli ='2762500' WHERE kode_barcode='T0072983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='6961500',harga_beli ='6961500' WHERE kode_barcode='T0063011' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='5370500',harga_beli ='5370500' WHERE kode_barcode='T0063012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='1613500',harga_beli ='1613500' WHERE kode_barcode='T0068921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2762500',harga_beli ='2762500' WHERE kode_barcode='T0070504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='9967500',harga_beli ='9967500' WHERE kode_barcode='T0070501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='6365000',harga_beli ='6365000' WHERE kode_barcode='T0070500' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='3779500',harga_beli ='3779500' WHERE kode_barcode='T0070497' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2873000',harga_beli ='2873000' WHERE kode_barcode='T0070496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2343000',harga_beli ='2343000' WHERE kode_barcode='T0070491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='3050000',harga_beli ='3050000' WHERE kode_barcode='T0070157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='3204500',harga_beli ='3204500' WHERE kode_barcode='T0070156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2564000',harga_beli ='2564000' WHERE kode_barcode='T0062981' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2762500',harga_beli ='2762500' WHERE kode_barcode='T0065465' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='3867500',harga_beli ='3867500' WHERE kode_barcode='T0065464' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='4155000',harga_beli ='4155000' WHERE kode_barcode='T0065463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='4354000',harga_beli ='4354000' WHERE kode_barcode='T0065461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='4420000',harga_beli ='4420000' WHERE kode_barcode='T0065459' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2099500',harga_beli ='2099500' WHERE kode_barcode='T0065456' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2210000',harga_jual='2210000',harga_beli ='2210000' WHERE kode_barcode='T0062992' LIMIT 1;
UPDATE tm_group SET harga='2210000' WHERE kode_group = 'TD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TD','2210000','input','2026-03-05 08:17:28');
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1739500',harga_beli ='1739500' WHERE kode_barcode='T0040093' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2899000',harga_beli ='2899000' WHERE kode_barcode='T0027959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3523500',harga_beli ='3523500' WHERE kode_barcode='T0027952' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1672500',harga_beli ='1672500' WHERE kode_barcode='T0027928' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2185500',harga_beli ='2185500' WHERE kode_barcode='T0025243' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3791000',harga_beli ='3791000' WHERE kode_barcode='T0029887' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2966000',harga_beli ='2966000' WHERE kode_barcode='T0003111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5731500',harga_beli ='5731500' WHERE kode_barcode='T0003107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='8251000',harga_beli ='8251000' WHERE kode_barcode='T0002687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4393500',harga_beli ='4393500' WHERE kode_barcode='T0003195' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5575000',harga_beli ='5575000' WHERE kode_barcode='T0003210' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2297000',harga_beli ='2297000' WHERE kode_barcode='T0050962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4192500',harga_beli ='4192500' WHERE kode_barcode='T0003563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3613000',harga_beli ='3613000' WHERE kode_barcode='T0003573' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2118500',harga_beli ='2118500' WHERE kode_barcode='T0029925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3345000',harga_beli ='3345000' WHERE kode_barcode='T0003159' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4817000',harga_beli ='4817000' WHERE kode_barcode='T0003161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3167000',harga_beli ='3167000' WHERE kode_barcode='T0003162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4259500',harga_beli ='4259500' WHERE kode_barcode='T0003163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1628000',harga_beli ='1628000' WHERE kode_barcode='T0003165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1048500',harga_beli ='1048500' WHERE kode_barcode='T0003168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2899000',harga_beli ='2899000' WHERE kode_barcode='T0003169' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2564500',harga_beli ='2564500' WHERE kode_barcode='T0003142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3055500',harga_beli ='3055500' WHERE kode_barcode='T0003146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4371000',harga_beli ='4371000' WHERE kode_barcode='T0003396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2118500',harga_beli ='2118500' WHERE kode_barcode='T0003411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2118500',harga_beli ='2118500' WHERE kode_barcode='T0003414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1115000',harga_beli ='1115000' WHERE kode_barcode='T0003415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2498000',harga_beli ='2498000' WHERE kode_barcode='T0003417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='7604500',harga_beli ='7604500' WHERE kode_barcode='T0003419' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3256000',harga_beli ='3256000' WHERE kode_barcode='T0003433' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='8028000',harga_beli ='8028000' WHERE kode_barcode='T0003434' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3167000',harga_beli ='3167000' WHERE kode_barcode='T0003440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6244000',harga_beli ='6244000' WHERE kode_barcode='T0003449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4505000',harga_beli ='4505000' WHERE kode_barcode='T0003453' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4148000',harga_beli ='4148000' WHERE kode_barcode='T0003460' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4014000',harga_beli ='4014000' WHERE kode_barcode='T0003461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4148000',harga_beli ='4148000' WHERE kode_barcode='T0003466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='17907000',harga_beli ='17907000' WHERE kode_barcode='T0072990' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3635000',harga_beli ='3635000' WHERE kode_barcode='T0003481' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3256000',harga_beli ='3256000' WHERE kode_barcode='T0003482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3390000',harga_beli ='3390000' WHERE kode_barcode='T0003594' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4794500',harga_beli ='4794500' WHERE kode_barcode='T0003587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='15632500',harga_beli ='15632500' WHERE kode_barcode='T0003370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2052000',harga_beli ='2052000' WHERE kode_barcode='T0004087' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4170500',harga_beli ='4170500' WHERE kode_barcode='T0004022' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='9366000',harga_beli ='9366000' WHERE kode_barcode='T0072989' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3167000',harga_beli ='3167000' WHERE kode_barcode='T0004055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2052000',harga_beli ='2052000' WHERE kode_barcode='T0004356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2007000',harga_beli ='2007000' WHERE kode_barcode='T0004351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3077500',harga_beli ='3077500' WHERE kode_barcode='T0006172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2163500',harga_beli ='2163500' WHERE kode_barcode='T0006175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2341500',harga_beli ='2341500' WHERE kode_barcode='T0006198' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6355500',harga_beli ='6355500' WHERE kode_barcode='T0006197' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3456500',harga_beli ='3456500' WHERE kode_barcode='T0006193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4683000',harga_beli ='4683000' WHERE kode_barcode='T0006190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4036500',harga_beli ='4036500' WHERE kode_barcode='T0006414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4505000',harga_beli ='4505000' WHERE kode_barcode='T0001870' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1160000',harga_beli ='1160000' WHERE kode_barcode='T0008962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1271500',harga_beli ='1271500' WHERE kode_barcode='T0008964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='10994000',harga_beli ='10994000' WHERE kode_barcode='T0072987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4237000',harga_beli ='4237000' WHERE kode_barcode='T0009202' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2921500',harga_beli ='2921500' WHERE kode_barcode='T0009209' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1851000',harga_beli ='1851000' WHERE kode_barcode='T0009232' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3479000',harga_beli ='3479000' WHERE kode_barcode='T0009460' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2676000',harga_beli ='2676000' WHERE kode_barcode='T0010055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3256000',harga_beli ='3256000' WHERE kode_barcode='T0010054' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1293500',harga_beli ='1293500' WHERE kode_barcode='T0014657' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1383000',harga_beli ='1383000' WHERE kode_barcode='T0014659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1383000',harga_beli ='1383000' WHERE kode_barcode='T0014661' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3256000',harga_beli ='3256000' WHERE kode_barcode='T0014715' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2743000',harga_beli ='2743000' WHERE kode_barcode='T0017794' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2364000',harga_beli ='2364000' WHERE kode_barcode='T0017795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='8206500',harga_beli ='8206500' WHERE kode_barcode='T0019180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4861500',harga_beli ='4861500' WHERE kode_barcode='T0019181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3523500',harga_beli ='3523500' WHERE kode_barcode='T0006407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2520000',harga_beli ='2520000' WHERE kode_barcode='T0013667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1895500',harga_beli ='1895500' WHERE kode_barcode='T0020102' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3947500',harga_beli ='3947500' WHERE kode_barcode='T0022491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3278500',harga_beli ='3278500' WHERE kode_barcode='T0022487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3233500',harga_beli ='3233500' WHERE kode_barcode='T0022713' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6132500',harga_beli ='6132500' WHERE kode_barcode='T0023419' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='7247500',harga_beli ='7247500' WHERE kode_barcode='T0023410' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4125500',harga_beli ='4125500' WHERE kode_barcode='T0026794' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2185500',harga_beli ='2185500' WHERE kode_barcode='T0026793' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4036500',harga_beli ='4036500' WHERE kode_barcode='T0026789' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='18063000',harga_beli ='18063000' WHERE kode_barcode='T0027384' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='8719500',harga_beli ='8719500' WHERE kode_barcode='T0027889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='44377000',harga_beli ='44377000' WHERE kode_barcode='T0027884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2631500',harga_beli ='2631500' WHERE kode_barcode='T0029673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2453000',harga_beli ='2453000' WHERE kode_barcode='T0029674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2520000',harga_beli ='2520000' WHERE kode_barcode='T0028822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2899000',harga_beli ='2899000' WHERE kode_barcode='T0031899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4371000',harga_beli ='4371000' WHERE kode_barcode='T0032995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2721000',harga_beli ='2721000' WHERE kode_barcode='T0032983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2007000',harga_beli ='2007000' WHERE kode_barcode='T0033052' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='9031500',harga_beli ='9031500' WHERE kode_barcode='T0033032' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3702000',harga_beli ='3702000' WHERE kode_barcode='T0033506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5530500',harga_beli ='5530500' WHERE kode_barcode='T0033486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1561000',harga_beli ='1561000' WHERE kode_barcode='T0033647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3501500',harga_beli ='3501500' WHERE kode_barcode='T0033728' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1918000',harga_beli ='1918000' WHERE kode_barcode='T0034346' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4125500',harga_beli ='4125500' WHERE kode_barcode='T0034362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3925000',harga_beli ='3925000' WHERE kode_barcode='T0034760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2297000',harga_beli ='2297000' WHERE kode_barcode='T0034754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='11038500',harga_beli ='11038500' WHERE kode_barcode='T0034743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='12533000',harga_beli ='12533000' WHERE kode_barcode='T0034735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1449500',harga_beli ='1449500' WHERE kode_barcode='T0035004' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1449500',harga_beli ='1449500' WHERE kode_barcode='T0035014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1293500',harga_beli ='1293500' WHERE kode_barcode='T0035012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1405000',harga_beli ='1405000' WHERE kode_barcode='T0035010' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1449500',harga_beli ='1449500' WHERE kode_barcode='T0035005' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3836000',harga_beli ='3836000' WHERE kode_barcode='T0035430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2832500',harga_beli ='2832500' WHERE kode_barcode='T0035420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1962500',harga_beli ='1962500' WHERE kode_barcode='T0036248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3456500',harga_beli ='3456500' WHERE kode_barcode='T0036259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6088000',harga_beli ='6088000' WHERE kode_barcode='T0037728' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3479000',harga_beli ='3479000' WHERE kode_barcode='T0037995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2275000',harga_beli ='2275000' WHERE kode_barcode='T0038795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3902500',harga_beli ='3902500' WHERE kode_barcode='T0038788' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1338000',harga_beli ='1338000' WHERE kode_barcode='T0039318' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2966000',harga_beli ='2966000' WHERE kode_barcode='T0039315' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3456500',harga_beli ='3456500' WHERE kode_barcode='T0039621' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4304000',harga_beli ='4304000' WHERE kode_barcode='T0040098' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2341500',harga_beli ='2341500' WHERE kode_barcode='T0040647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6021000',harga_beli ='6021000' WHERE kode_barcode='T0040632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='8496500',harga_beli ='8496500' WHERE kode_barcode='T0040639' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2364000',harga_beli ='2364000' WHERE kode_barcode='T0040631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='8742000',harga_beli ='8742000' WHERE kode_barcode='T0041178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3501500',harga_beli ='3501500' WHERE kode_barcode='T0041170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3300500',harga_beli ='3300500' WHERE kode_barcode='T0041152' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5798000',harga_beli ='5798000' WHERE kode_barcode='T0041163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4170500',harga_beli ='4170500' WHERE kode_barcode='T0041154' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='18130000',harga_beli ='18130000' WHERE kode_barcode='T0041179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='8251000',harga_beli ='8251000' WHERE kode_barcode='T0041183' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='8875500',harga_beli ='8875500' WHERE kode_barcode='T0041182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4906000',harga_beli ='4906000' WHERE kode_barcode='T0041651' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2163500',harga_beli ='2163500' WHERE kode_barcode='T0041676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='8764000',harga_beli ='8764000' WHERE kode_barcode='T0041681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1472000',harga_beli ='1472000' WHERE kode_barcode='T0042067' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1449500',harga_beli ='1449500' WHERE kode_barcode='T0042068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1516500',harga_beli ='1516500' WHERE kode_barcode='T0042069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4237000',harga_beli ='4237000' WHERE kode_barcode='T0042203' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5486000',harga_beli ='5486000' WHERE kode_barcode='T0042202' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4861500',harga_beli ='4861500' WHERE kode_barcode='T0042199' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5843000',harga_beli ='5843000' WHERE kode_barcode='T0042197' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2498000',harga_beli ='2498000' WHERE kode_barcode='T0042196' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6489500',harga_beli ='6489500' WHERE kode_barcode='T0042192' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2854500',harga_beli ='2854500' WHERE kode_barcode='T0042191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1829000',harga_beli ='1829000' WHERE kode_barcode='T0042186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2386500',harga_beli ='2386500' WHERE kode_barcode='T0042185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='15387000',harga_beli ='15387000' WHERE kode_barcode='T0042180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='15097500',harga_beli ='15097500' WHERE kode_barcode='T0042179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4348500',harga_beli ='4348500' WHERE kode_barcode='T0042177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='11172500',harga_beli ='11172500' WHERE kode_barcode='T0067270' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4348500',harga_beli ='4348500' WHERE kode_barcode='T0042541' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1895500',harga_beli ='1895500' WHERE kode_barcode='T0042537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2275000',harga_beli ='2275000' WHERE kode_barcode='T0042542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6244000',harga_beli ='6244000' WHERE kode_barcode='T0042530' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3969500',harga_beli ='3969500' WHERE kode_barcode='T0042524' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3523500',harga_beli ='3523500' WHERE kode_barcode='T0042514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2899000',harga_beli ='2899000' WHERE kode_barcode='T0042830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='22144000',harga_beli ='22144000' WHERE kode_barcode='T0067271' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2787500',harga_beli ='2787500' WHERE kode_barcode='T0043098' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3590500',harga_beli ='3590500' WHERE kode_barcode='T0043121' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6355500',harga_beli ='6355500' WHERE kode_barcode='T0043107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6712500',harga_beli ='6712500' WHERE kode_barcode='T0043147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6355500',harga_beli ='6355500' WHERE kode_barcode='T0043150' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3791000',harga_beli ='3791000' WHERE kode_barcode='T0043628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5620000',harga_beli ='5620000' WHERE kode_barcode='T0043629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='7024500',harga_beli ='7024500' WHERE kode_barcode='T0043721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6868500',harga_beli ='6868500' WHERE kode_barcode='T0044041' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3568000',harga_beli ='3568000' WHERE kode_barcode='T0044045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='7537500',harga_beli ='7537500' WHERE kode_barcode='T0044034' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='9321500',harga_beli ='9321500' WHERE kode_barcode='T0072988' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2252500',harga_beli ='2252500' WHERE kode_barcode='T0044166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2230000',harga_beli ='2230000' WHERE kode_barcode='T0044165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2185500',harga_beli ='2185500' WHERE kode_barcode='T0044164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='8139500',harga_beli ='8139500' WHERE kode_barcode='T0044286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3479000',harga_beli ='3479000' WHERE kode_barcode='T0044278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6467000',harga_beli ='6467000' WHERE kode_barcode='T0044276' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4683000',harga_beli ='4683000' WHERE kode_barcode='T0044274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='11484500',harga_beli ='11484500' WHERE kode_barcode='T0044545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5196000',harga_beli ='5196000' WHERE kode_barcode='T0044564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1449500',harga_beli ='1449500' WHERE kode_barcode='T0045115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2364000',harga_beli ='2364000' WHERE kode_barcode='T0045117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1628000',harga_beli ='1628000' WHERE kode_barcode='T0045127' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3925000',harga_beli ='3925000' WHERE kode_barcode='T0045348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2854500',harga_beli ='2854500' WHERE kode_barcode='T0045354' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2498000',harga_beli ='2498000' WHERE kode_barcode='T0045355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3233500',harga_beli ='3233500' WHERE kode_barcode='T0045362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6935500',harga_beli ='6935500' WHERE kode_barcode='T0045384' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4928500',harga_beli ='4928500' WHERE kode_barcode='T0045378' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2854500',harga_beli ='2854500' WHERE kode_barcode='T0045367' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2899000',harga_beli ='2899000' WHERE kode_barcode='T0045366' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4973000',harga_beli ='4973000' WHERE kode_barcode='T0044947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5575000',harga_beli ='5575000' WHERE kode_barcode='T0045389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1806500',harga_beli ='1806500' WHERE kode_barcode='T0046053' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4616500',harga_beli ='4616500' WHERE kode_barcode='T0046088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3836000',harga_beli ='3836000' WHERE kode_barcode='T0046089' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5909500',harga_beli ='5909500' WHERE kode_barcode='T0046090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1672500',harga_beli ='1672500' WHERE kode_barcode='T0046370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2252500',harga_beli ='2252500' WHERE kode_barcode='T0047393' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4973000',harga_beli ='4973000' WHERE kode_barcode='T0047396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1449500',harga_beli ='1449500' WHERE kode_barcode='T0047398' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6043500',harga_beli ='6043500' WHERE kode_barcode='T0047416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5642000',harga_beli ='5642000' WHERE kode_barcode='T0047427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2564500',harga_beli ='2564500' WHERE kode_barcode='T0047423' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3367500',harga_beli ='3367500' WHERE kode_barcode='T0047418' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5508500',harga_beli ='5508500' WHERE kode_barcode='T0047417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4728000',harga_beli ='4728000' WHERE kode_barcode='T0047414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4482500',harga_beli ='4482500' WHERE kode_barcode='T0047409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5352000',harga_beli ='5352000' WHERE kode_barcode='T0047408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='15298000',harga_beli ='15298000' WHERE kode_barcode='T0047429' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5843000',harga_beli ='5843000' WHERE kode_barcode='T0047434' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6578500',harga_beli ='6578500' WHERE kode_barcode='T0047436' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2341500',harga_beli ='2341500' WHERE kode_barcode='T0048345' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2230000',harga_beli ='2230000' WHERE kode_barcode='T0048740' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2118500',harga_beli ='2118500' WHERE kode_barcode='T0048741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='959000',harga_beli ='959000' WHERE kode_barcode='T0048987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2587000',harga_beli ='2587000' WHERE kode_barcode='T0048992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1160000',harga_beli ='1160000' WHERE kode_barcode='T0049666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5062500',harga_beli ='5062500' WHERE kode_barcode='T0049688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4571500',harga_beli ='4571500' WHERE kode_barcode='T0049690' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1628000',harga_beli ='1628000' WHERE kode_barcode='T0049701' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1739500',harga_beli ='1739500' WHERE kode_barcode='T0049702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4571500',harga_beli ='4571500' WHERE kode_barcode='T0049674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4638500',harga_beli ='4638500' WHERE kode_barcode='T0049677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2118500',harga_beli ='2118500' WHERE kode_barcode='T0049682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4571500',harga_beli ='4571500' WHERE kode_barcode='T0049684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3947500',harga_beli ='3947500' WHERE kode_barcode='T0049686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='11061000',harga_beli ='11061000' WHERE kode_barcode='T0049707' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='9700500',harga_beli ='9700500' WHERE kode_barcode='T0049711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1293500',harga_beli ='1293500' WHERE kode_barcode='T0049951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4616500',harga_beli ='4616500' WHERE kode_barcode='T0050016' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='20984500',harga_beli ='20984500' WHERE kode_barcode='T0050021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2141000',harga_beli ='2141000' WHERE kode_barcode='T0050453' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3568000',harga_beli ='3568000' WHERE kode_barcode='T0050454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3278500',harga_beli ='3278500' WHERE kode_barcode='T0050457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2587000',harga_beli ='2587000' WHERE kode_barcode='T0050487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1895500',harga_beli ='1895500' WHERE kode_barcode='T0050486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3456500',harga_beli ='3456500' WHERE kode_barcode='T0050484' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4393500',harga_beli ='4393500' WHERE kode_barcode='T0050483' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3902500',harga_beli ='3902500' WHERE kode_barcode='T0050482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4616500',harga_beli ='4616500' WHERE kode_barcode='T0050479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2564500',harga_beli ='2564500' WHERE kode_barcode='T0050478' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2230000',harga_beli ='2230000' WHERE kode_barcode='T0050469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2341500',harga_beli ='2341500' WHERE kode_barcode='T0050491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6935500',harga_beli ='6935500' WHERE kode_barcode='T0050492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2498000',harga_beli ='2498000' WHERE kode_barcode='T0050822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3925000',harga_beli ='3925000' WHERE kode_barcode='T0050826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3702000',harga_beli ='3702000' WHERE kode_barcode='T0051688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1516500',harga_beli ='1516500' WHERE kode_barcode='T0051691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2341500',harga_beli ='2341500' WHERE kode_barcode='T0051693' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3010500',harga_beli ='3010500' WHERE kode_barcode='T0051694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3702000',harga_beli ='3702000' WHERE kode_barcode='T0051704' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3010500',harga_beli ='3010500' WHERE kode_barcode='T0051705' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1338000',harga_beli ='1338000' WHERE kode_barcode='T0051708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3902500',harga_beli ='3902500' WHERE kode_barcode='T0051739' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5240500',harga_beli ='5240500' WHERE kode_barcode='T0051735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2520000',harga_beli ='2520000' WHERE kode_barcode='T0051738' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4460000',harga_beli ='4460000' WHERE kode_barcode='T0051741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2475500',harga_beli ='2475500' WHERE kode_barcode='T0051742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3122000',harga_beli ='3122000' WHERE kode_barcode='T0051743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2185500',harga_beli ='2185500' WHERE kode_barcode='T0051745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3278500',harga_beli ='3278500' WHERE kode_barcode='T0051746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4505000',harga_beli ='4505000' WHERE kode_barcode='T0051747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4148000',harga_beli ='4148000' WHERE kode_barcode='T0051719' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='7181000',harga_beli ='7181000' WHERE kode_barcode='T0051710' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='11730000',harga_beli ='11730000' WHERE kode_barcode='T0051712' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4906000',harga_beli ='4906000' WHERE kode_barcode='T0051714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5263000',harga_beli ='5263000' WHERE kode_barcode='T0051716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='26916500',harga_beli ='26916500' WHERE kode_barcode='T0051757' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='20627500',harga_beli ='20627500' WHERE kode_barcode='T0051759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5954500',harga_beli ='5954500' WHERE kode_barcode='T0051760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6467000',harga_beli ='6467000' WHERE kode_barcode='T0051764' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4571500',harga_beli ='4571500' WHERE kode_barcode='T0052826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2854500',harga_beli ='2854500' WHERE kode_barcode='T0052834' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='18286000',harga_beli ='18286000' WHERE kode_barcode='T0052836' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='22345000',harga_beli ='22345000' WHERE kode_barcode='T0052839' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='11306500',harga_beli ='11306500' WHERE kode_barcode='T0052841' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='7805000',harga_beli ='7805000' WHERE kode_barcode='T0052843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4594000',harga_beli ='4594000' WHERE kode_barcode='T0052914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2297000',harga_beli ='2297000' WHERE kode_barcode='T0052917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2074000',harga_beli ='2074000' WHERE kode_barcode='T0052918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1160000',harga_beli ='1160000' WHERE kode_barcode='T0052920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1449500',harga_beli ='1449500' WHERE kode_barcode='T0052922' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5798000',harga_beli ='5798000' WHERE kode_barcode='T0052937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3367500',harga_beli ='3367500' WHERE kode_barcode='T0052935' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='7693500',harga_beli ='7693500' WHERE kode_barcode='T0052925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3456500',harga_beli ='3456500' WHERE kode_barcode='T0052943' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='22411500',harga_beli ='22411500' WHERE kode_barcode='T0052947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='9500000',harga_beli ='9500000' WHERE kode_barcode='T0052950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='7359000',harga_beli ='7359000' WHERE kode_barcode='T0052951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='7627000',harga_beli ='7627000' WHERE kode_barcode='T0052952' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1784000',harga_beli ='1784000' WHERE kode_barcode='T0054111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1784000',harga_beli ='1784000' WHERE kode_barcode='T0054112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='44868000',harga_beli ='44868000' WHERE kode_barcode='T0054235' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1695000',harga_beli ='1695000' WHERE kode_barcode='T0054302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2118500',harga_beli ='2118500' WHERE kode_barcode='T0054303' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1516500',harga_beli ='1516500' WHERE kode_barcode='T0054306' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2475500',harga_beli ='2475500' WHERE kode_barcode='T0054305' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2721000',harga_beli ='2721000' WHERE kode_barcode='T0054307' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4750000',harga_beli ='4750000' WHERE kode_barcode='T0054341' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4505000',harga_beli ='4505000' WHERE kode_barcode='T0054340' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3189000',harga_beli ='3189000' WHERE kode_barcode='T0054339' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='19289500',harga_beli ='19289500' WHERE kode_barcode='T0054337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2386500',harga_beli ='2386500' WHERE kode_barcode='T0054335' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4683000',harga_beli ='4683000' WHERE kode_barcode='T0054332' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3367500',harga_beli ='3367500' WHERE kode_barcode='T0054327' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3122000',harga_beli ='3122000' WHERE kode_barcode='T0054322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4348500',harga_beli ='4348500' WHERE kode_barcode='T0054320' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6266500',harga_beli ='6266500' WHERE kode_barcode='T0054318' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='8697000',harga_beli ='8697000' WHERE kode_barcode='T0054359' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6534000',harga_beli ='6534000' WHERE kode_barcode='T0054357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2475500',harga_beli ='2475500' WHERE kode_barcode='T0056273' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1226500',harga_beli ='1226500' WHERE kode_barcode='T0056279' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3902500',harga_beli ='3902500' WHERE kode_barcode='T0056286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4571500',harga_beli ='4571500' WHERE kode_barcode='T0056288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2453000',harga_beli ='2453000' WHERE kode_barcode='T0056289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3791000',harga_beli ='3791000' WHERE kode_barcode='T0056291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2921500',harga_beli ='2921500' WHERE kode_barcode='T0056292' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2475500',harga_beli ='2475500' WHERE kode_barcode='T0056293' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2676000',harga_beli ='2676000' WHERE kode_barcode='T0056294' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4616500',harga_beli ='4616500' WHERE kode_barcode='T0056296' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='11150000',harga_beli ='11150000' WHERE kode_barcode='T0056298' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='44221000',harga_beli ='44221000' WHERE kode_barcode='T0056306' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1226500',harga_beli ='1226500' WHERE kode_barcode='T0056710' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5575000',harga_beli ='5575000' WHERE kode_barcode='T0056722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='44823000',harga_beli ='44823000' WHERE kode_barcode='T0056723' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2341500',harga_beli ='2341500' WHERE kode_barcode='T0056726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4081000',harga_beli ='4081000' WHERE kode_barcode='T0056729' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='9254500',harga_beli ='9254500' WHERE kode_barcode='T0056734' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2364000',harga_beli ='2364000' WHERE kode_barcode='T0057085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3412000',harga_beli ='3412000' WHERE kode_barcode='T0057087' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4750000',harga_beli ='4750000' WHERE kode_barcode='T0057088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4125500',harga_beli ='4125500' WHERE kode_barcode='T0057099' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3300500',harga_beli ='3300500' WHERE kode_barcode='T0057100' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1895500',harga_beli ='1895500' WHERE kode_barcode='T0057101' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3233500',harga_beli ='3233500' WHERE kode_barcode='T0057121' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5709000',harga_beli ='5709000' WHERE kode_barcode='T0057123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1672500',harga_beli ='1672500' WHERE kode_barcode='T0057125' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3010500',harga_beli ='3010500' WHERE kode_barcode='T0057133' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3590500',harga_beli ='3590500' WHERE kode_barcode='T0057136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4415500',harga_beli ='4415500' WHERE kode_barcode='T0057112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1115000',harga_beli ='1115000' WHERE kode_barcode='T0057106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1494500',harga_beli ='1494500' WHERE kode_barcode='T0057107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2609500',harga_beli ='2609500' WHERE kode_barcode='T0057108' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4460000',harga_beli ='4460000' WHERE kode_barcode='T0057103' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6378000',harga_beli ='6378000' WHERE kode_barcode='T0057147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2564500',harga_beli ='2564500' WHERE kode_barcode='T0057146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='11261500',harga_beli ='11261500' WHERE kode_barcode='T0057141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2364000',harga_beli ='2364000' WHERE kode_barcode='T0058798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1383000',harga_beli ='1383000' WHERE kode_barcode='T0071231' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3501500',harga_beli ='3501500' WHERE kode_barcode='T0059276' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2074000',harga_beli ='2074000' WHERE kode_barcode='T0059333' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2408500',harga_beli ='2408500' WHERE kode_barcode='T0059334' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5486000',harga_beli ='5486000' WHERE kode_barcode='T0059337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2386500',harga_beli ='2386500' WHERE kode_barcode='T0059376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2052000',harga_beli ='2052000' WHERE kode_barcode='T0059495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2498000',harga_beli ='2498000' WHERE kode_barcode='T0059500' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5909500',harga_beli ='5909500' WHERE kode_barcode='T0059520' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3902500',harga_beli ='3902500' WHERE kode_barcode='T0059519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2453000',harga_beli ='2453000' WHERE kode_barcode='T0059517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4125500',harga_beli ='4125500' WHERE kode_barcode='T0059507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4036500',harga_beli ='4036500' WHERE kode_barcode='T0059506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3791000',harga_beli ='3791000' WHERE kode_barcode='T0059505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6355500',harga_beli ='6355500' WHERE kode_barcode='T0059503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5753500',harga_beli ='5753500' WHERE kode_barcode='T0059502' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6088000',harga_beli ='6088000' WHERE kode_barcode='T0059527' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1338000',harga_beli ='1338000' WHERE kode_barcode='T0071232' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6645500',harga_beli ='6645500' WHERE kode_barcode='T0063029' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6378000',harga_beli ='6378000' WHERE kode_barcode='T0063030' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='11551500',harga_beli ='11551500' WHERE kode_barcode='T0063031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='8095000',harga_beli ='8095000' WHERE kode_barcode='T0063022' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6690000',harga_beli ='6690000' WHERE kode_barcode='T0071236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3300500',harga_beli ='3300500' WHERE kode_barcode='T0071237' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4571500',harga_beli ='4571500' WHERE kode_barcode='T0064224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4683000',harga_beli ='4683000' WHERE kode_barcode='T0064225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='7827500',harga_beli ='7827500' WHERE kode_barcode='T0064227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='8630500',harga_beli ='8630500' WHERE kode_barcode='T0065472' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='7537500',harga_beli ='7537500' WHERE kode_barcode='T0065473' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2341500',harga_beli ='2341500' WHERE kode_barcode='T0066779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2185500',harga_beli ='2185500' WHERE kode_barcode='T0068753' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1182000',harga_beli ='1182000' WHERE kode_barcode='T0068752' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='11195000',harga_beli ='11195000' WHERE kode_barcode='T0068740' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4393500',harga_beli ='4393500' WHERE kode_barcode='T0068741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4460000',harga_beli ='4460000' WHERE kode_barcode='T0068739' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3390000',harga_beli ='3390000' WHERE kode_barcode='T0068948' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1338000',harga_beli ='1338000' WHERE kode_barcode='T0069499' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1405000',harga_beli ='1405000' WHERE kode_barcode='T0069500' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1137500',harga_beli ='1137500' WHERE kode_barcode='T0069501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='2386500',harga_beli ='2386500' WHERE kode_barcode='T0069934' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4438000',harga_beli ='4438000' WHERE kode_barcode='T0069936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1271500',harga_beli ='1271500' WHERE kode_barcode='T0070509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='22813000',harga_beli ='22813000' WHERE kode_barcode='T0070514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5798000',harga_beli ='5798000' WHERE kode_barcode='T0070515' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='8675000',harga_beli ='8675000' WHERE kode_barcode='T0071525' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='5553000',harga_beli ='5553000' WHERE kode_barcode='T0071526' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6891000',harga_beli ='6891000' WHERE kode_barcode='T0071529' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='11373000',harga_beli ='11373000' WHERE kode_barcode='T0072100' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1249000',harga_beli ='1249000' WHERE kode_barcode='T0072977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6779500',harga_beli ='6779500' WHERE kode_barcode='T0072634' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1003500',harga_beli ='1003500' WHERE kode_barcode='T0072975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1226500',harga_beli ='1226500' WHERE kode_barcode='T0072976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='9210000',harga_beli ='9210000' WHERE kode_barcode='T0074493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1271500',harga_beli ='1271500' WHERE kode_barcode='T0074484' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='11284000',harga_beli ='11284000' WHERE kode_barcode='T0070143' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1137500',harga_beli ='1137500' WHERE kode_barcode='T0075753' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1115000',harga_beli ='1115000' WHERE kode_barcode='T0075754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1539000',harga_beli ='1539000' WHERE kode_barcode='T0075755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='11707500',harga_beli ='11707500' WHERE kode_barcode='T0075767' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6846500',harga_beli ='6846500' WHERE kode_barcode='T0075768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='26448000',harga_beli ='26448000' WHERE kode_barcode='T0075769' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='3367500',harga_beli ='3367500' WHERE kode_barcode='T0075778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4482500',harga_beli ='4482500' WHERE kode_barcode='T0075775' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='4482500',harga_beli ='4482500' WHERE kode_barcode='T0075776' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='6801500',harga_beli ='6801500' WHERE kode_barcode='T0075777' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='12845000',harga_beli ='12845000' WHERE kode_barcode='T0076238' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='22300000',harga_beli ='22300000' WHERE kode_barcode='T0076239' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='17840000',harga_beli ='17840000' WHERE kode_barcode='T0076240' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2230000',harga_jual='1226500',harga_beli ='1226500' WHERE kode_barcode='T0072896' LIMIT 1;
UPDATE tm_group SET harga='2230000' WHERE kode_group = 'TE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TE','2230000','input','2026-03-05 08:17:50');
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5985000',harga_beli ='5985000' WHERE kode_barcode='T0027903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1057500',harga_beli ='1057500' WHERE kode_barcode='T0027962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4567500',harga_beli ='4567500' WHERE kode_barcode='T0025250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5625000',harga_beli ='5625000' WHERE kode_barcode='T0025240' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6862500',harga_beli ='6862500' WHERE kode_barcode='T0002681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6682500',harga_beli ='6682500' WHERE kode_barcode='T0002680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4950000',harga_beli ='4950000' WHERE kode_barcode='T0002702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6907500',harga_beli ='6907500' WHERE kode_barcode='T0002545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6075000',harga_beli ='6075000' WHERE kode_barcode='T0003215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5580000',harga_beli ='5580000' WHERE kode_barcode='T0003578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2812500',harga_beli ='2812500' WHERE kode_barcode='T0029910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3735000',harga_beli ='3735000' WHERE kode_barcode='T0003883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11160000',harga_beli ='11160000' WHERE kode_barcode='T0006181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7267500',harga_beli ='7267500' WHERE kode_barcode='T0009249' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1350000',harga_beli ='1350000' WHERE kode_barcode='T0062967' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4050000',harga_beli ='4050000' WHERE kode_barcode='T0027964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2700000',harga_beli ='2700000' WHERE kode_barcode='T0029909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='33682500',harga_beli ='33682500' WHERE kode_barcode='T0014667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='15322500',harga_beli ='15322500' WHERE kode_barcode='T0014724' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9247500',harga_beli ='9247500' WHERE kode_barcode='T0001396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4972500',harga_beli ='4972500' WHERE kode_barcode='T0021505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1800000',harga_beli ='1800000' WHERE kode_barcode='T0022496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1147500',harga_beli ='1147500' WHERE kode_barcode='T0022495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6232500',harga_beli ='6232500' WHERE kode_barcode='T0022928' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4747500',harga_beli ='4747500' WHERE kode_barcode='T0023426' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9675000',harga_beli ='9675000' WHERE kode_barcode='T0023442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3217500',harga_beli ='3217500' WHERE kode_barcode='T0001914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1125000',harga_beli ='1125000' WHERE kode_barcode='T0026797' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4725000',harga_beli ='4725000' WHERE kode_barcode='T0026857' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6817500',harga_beli ='6817500' WHERE kode_barcode='T0026861' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1462500',harga_beli ='1462500' WHERE kode_barcode='T0029908' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='33750000',harga_beli ='33750000' WHERE kode_barcode='T0029659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4770000',harga_beli ='4770000' WHERE kode_barcode='T0029880' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4770000',harga_beli ='4770000' WHERE kode_barcode='T0031224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='18157500',harga_beli ='18157500' WHERE kode_barcode='T0002012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='17775000',harga_beli ='17775000' WHERE kode_barcode='T0023388' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11497500',harga_beli ='11497500' WHERE kode_barcode='T0032844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3285000',harga_beli ='3285000' WHERE kode_barcode='T0032978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6997500',harga_beli ='6997500' WHERE kode_barcode='T0033642' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6210500',harga_beli ='6210500' WHERE kode_barcode='T0034358' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4387500',harga_beli ='4387500' WHERE kode_barcode='T0034369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8842500',harga_beli ='8842500' WHERE kode_barcode='T0034371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3397500',harga_beli ='3397500' WHERE kode_barcode='T0034372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1687500',harga_beli ='1687500' WHERE kode_barcode='T0034762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='22072500',harga_beli ='22072500' WHERE kode_barcode='T0036272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1282500',harga_beli ='1282500' WHERE kode_barcode='T0036773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1912500',harga_beli ='1912500' WHERE kode_barcode='T0036774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='16087500',harga_beli ='16087500' WHERE kode_barcode='T0037438' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1170000',harga_beli ='1170000' WHERE kode_barcode='T0037911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2250000',harga_beli ='2250000' WHERE kode_barcode='T0038821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1957500',harga_beli ='1957500' WHERE kode_barcode='T0038822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2182500',harga_beli ='2182500' WHERE kode_barcode='T0038823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5107500',harga_beli ='5107500' WHERE kode_barcode='T0038800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1057500',harga_beli ='1057500' WHERE kode_barcode='T0038825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='21960000',harga_beli ='21960000' WHERE kode_barcode='T0038814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4657500',harga_beli ='4657500' WHERE kode_barcode='T0039187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='15930000',harga_beli ='15930000' WHERE kode_barcode='T0040117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11475000',harga_beli ='11475000' WHERE kode_barcode='T0040118' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5850000',harga_beli ='5850000' WHERE kode_barcode='T0040624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6322500',harga_beli ='6322500' WHERE kode_barcode='T0040627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7020000',harga_beli ='7020000' WHERE kode_barcode='T0040626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9022500',harga_beli ='9022500' WHERE kode_barcode='T0040623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4837500',harga_beli ='4837500' WHERE kode_barcode='T0041161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3285000',harga_beli ='3285000' WHERE kode_barcode='T0041674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4680000',harga_beli ='4680000' WHERE kode_barcode='T0041675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='22837500',harga_beli ='22837500' WHERE kode_barcode='T0041931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1170000',harga_beli ='1170000' WHERE kode_barcode='T0042204' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3397500',harga_beli ='3397500' WHERE kode_barcode='T0042533' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1350000',harga_beli ='1350000' WHERE kode_barcode='T0043133' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6615000',harga_beli ='6615000' WHERE kode_barcode='T0043381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1305000',harga_beli ='1305000' WHERE kode_barcode='T0044092' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2475000',harga_beli ='2475000' WHERE kode_barcode='T0044157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1462500',harga_beli ='1462500' WHERE kode_barcode='T0044158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1147500',harga_beli ='1147500' WHERE kode_barcode='T0044160' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='5850000',harga_beli ='5850000' WHERE kode_barcode='T0045278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11520000',harga_beli ='11520000' WHERE kode_barcode='T0045290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1237500',harga_beli ='1237500' WHERE kode_barcode='T0045374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1125000',harga_beli ='1125000' WHERE kode_barcode='T0045369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4455000',harga_beli ='4455000' WHERE kode_barcode='T0046373' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2115000',harga_beli ='2115000' WHERE kode_barcode='T0072991' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1237500',harga_beli ='1237500' WHERE kode_barcode='T0047406' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6862500',harga_beli ='6862500' WHERE kode_barcode='T0047431' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7875000',harga_beli ='7875000' WHERE kode_barcode='T0047440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3037500',harga_beli ='3037500' WHERE kode_barcode='T0048974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2857500',harga_beli ='2857500' WHERE kode_barcode='T0049662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1462500',harga_beli ='1462500' WHERE kode_barcode='T0049706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6637500',harga_beli ='6637500' WHERE kode_barcode='T0049721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4567500',harga_beli ='4567500' WHERE kode_barcode='T0050466' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9225000',harga_beli ='9225000' WHERE kode_barcode='T0050927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4837500',harga_beli ='4837500' WHERE kode_barcode='T0051696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1147500',harga_beli ='1147500' WHERE kode_barcode='T0051697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4725000',harga_beli ='4725000' WHERE kode_barcode='T0051699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1305000',harga_beli ='1305000' WHERE kode_barcode='T0051709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6097500',harga_beli ='6097500' WHERE kode_barcode='T0051773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2070000',harga_beli ='2070000' WHERE kode_barcode='T0052760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1507500',harga_beli ='1507500' WHERE kode_barcode='T0052761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1417500',harga_beli ='1417500' WHERE kode_barcode='T0052762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1642500',harga_beli ='1642500' WHERE kode_barcode='T0052763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='10462500',harga_beli ='10462500' WHERE kode_barcode='T0052782' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='11317500',harga_beli ='11317500' WHERE kode_barcode='T0052845' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='3037500',harga_beli ='3037500' WHERE kode_barcode='T0052910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2272500',harga_beli ='2272500' WHERE kode_barcode='T0052919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4837500',harga_beli ='4837500' WHERE kode_barcode='T0054370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='7875000',harga_beli ='7875000' WHERE kode_barcode='T0054371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2475000',harga_beli ='2475000' WHERE kode_barcode='T0056709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4185000',harga_beli ='4185000' WHERE kode_barcode='T0056728' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2362500',harga_beli ='2362500' WHERE kode_barcode='T0056814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1867500',harga_beli ='1867500' WHERE kode_barcode='T0056815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='9112500',harga_beli ='9112500' WHERE kode_barcode='T0056834' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='8842500',harga_beli ='8842500' WHERE kode_barcode='T0057159' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='4590000',harga_beli ='4590000' WHERE kode_barcode='T0071234' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1170000',harga_beli ='1170000' WHERE kode_barcode='T0071230' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1642500',harga_beli ='1642500' WHERE kode_barcode='T0059377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='22387500',harga_beli ='22387500' WHERE kode_barcode='T0059529' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1125000',harga_beli ='1125000' WHERE kode_barcode='T0062988' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='13342500',harga_beli ='13342500' WHERE kode_barcode='T0063020' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1237500',harga_beli ='1237500' WHERE kode_barcode='T0066579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='6615000',harga_beli ='6615000' WHERE kode_barcode='T0072099' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1125000',harga_beli ='1125000' WHERE kode_barcode='T0072974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2047500',harga_beli ='2047500' WHERE kode_barcode='T0073762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1575000',harga_beli ='1575000' WHERE kode_barcode='T0073763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1237500',harga_beli ='1237500' WHERE kode_barcode='T0074548' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='675000',harga_beli ='675000' WHERE kode_barcode='T0075749' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='2137500',harga_beli ='2137500' WHERE kode_barcode='T0076228' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2250000',harga_jual='1687500',harga_beli ='1687500' WHERE kode_barcode='T0076232' LIMIT 1;
UPDATE tm_group SET harga='2250000' WHERE kode_group = 'TF' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TF','2250000','input','2026-03-05 08:18:07');
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='11486500',harga_beli ='11486500' WHERE kode_barcode='T0063024' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1589000',harga_beli ='1589000' WHERE kode_barcode='T0045109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7105500',harga_beli ='7105500' WHERE kode_barcode='T0053759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1544000',harga_beli ='1544000' WHERE kode_barcode='T0047446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5448000',harga_beli ='5448000' WHERE kode_barcode='T0048975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8898500',harga_beli ='8898500' WHERE kode_barcode='T0049718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8104000',harga_beli ='8104000' WHERE kode_barcode='T0050025' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7060000',harga_beli ='7060000' WHERE kode_barcode='T0050028' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6606000',harga_beli ='6606000' WHERE kode_barcode='T0050029' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='2883000',harga_beli ='2883000' WHERE kode_barcode='T0051751' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9262000',harga_beli ='9262000' WHERE kode_barcode='T0051771' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='11078000',harga_beli ='11078000' WHERE kode_barcode='T0057162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7446000',harga_beli ='7446000' WHERE kode_barcode='T0059521' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='1135000',harga_beli ='1135000' WHERE kode_barcode='T0060275' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='953500',harga_beli ='953500' WHERE kode_barcode='T0045111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4676500',harga_beli ='4676500' WHERE kode_barcode='T0063019' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5811500',harga_beli ='5811500' WHERE kode_barcode='T0066778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3405000',harga_beli ='3405000' WHERE kode_barcode='T0069580' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3360000',harga_beli ='3360000' WHERE kode_barcode='T0069582' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3246500',harga_beli ='3246500' WHERE kode_barcode='T0069583' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='3360000',harga_beli ='3360000' WHERE kode_barcode='T0069584' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4608500',harga_beli ='4608500' WHERE kode_barcode='T0070517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='9216500',harga_beli ='9216500' WHERE kode_barcode='T0065449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6833000',harga_beli ='6833000' WHERE kode_barcode='T0072632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='590500',harga_beli ='590500' WHERE kode_barcode='T0072971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='681000',harga_beli ='681000' WHERE kode_barcode='T0075787' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='681000',harga_beli ='681000' WHERE kode_barcode='T0075788' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='13802000',harga_beli ='13802000' WHERE kode_barcode='T0033028' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4653500',harga_beli ='4653500' WHERE kode_barcode='T0026463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='817500',harga_beli ='817500' WHERE kode_barcode='T0062982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6946500',harga_beli ='6946500' WHERE kode_barcode='T0001778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5834000',harga_beli ='5834000' WHERE kode_barcode='T0009257' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5334500',harga_beli ='5334500' WHERE kode_barcode='T0012680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6492500',harga_beli ='6492500' WHERE kode_barcode='T0027564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='10669000',harga_beli ='10669000' WHERE kode_barcode='T0029906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7377500',harga_beli ='7377500' WHERE kode_barcode='T0031228' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7877000',harga_beli ='7877000' WHERE kode_barcode='T0031229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4812500',harga_beli ='4812500' WHERE kode_barcode='T0031706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='15890000',harga_beli ='15890000' WHERE kode_barcode='T0033026' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='6855500',harga_beli ='6855500' WHERE kode_barcode='T0033040' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='5607000',harga_beli ='5607000' WHERE kode_barcode='T0033038' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='17933000',harga_beli ='17933000' WHERE kode_barcode='T0002535' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='18387000',harga_beli ='18387000' WHERE kode_barcode='T0033027' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='11622500',harga_beli ='11622500' WHERE kode_barcode='T0033650' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4722000',harga_beli ='4722000' WHERE kode_barcode='T0033858' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='27036000',harga_beli ='27036000' WHERE kode_barcode='T0001409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='953500',harga_beli ='953500' WHERE kode_barcode='T0029798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='18046500',harga_beli ='18046500' WHERE kode_barcode='T0035449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4880500',harga_beli ='4880500' WHERE kode_barcode='T0037440' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='22745500',harga_beli ='22745500' WHERE kode_barcode='T0038811' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='8512500',harga_beli ='8512500' WHERE kode_barcode='T0039636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='11373000',harga_beli ='11373000' WHERE kode_barcode='T0039646' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='7173500',harga_beli ='7173500' WHERE kode_barcode='T0040120' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2270000',harga_jual='4540000',harga_beli ='4540000' WHERE kode_barcode='T0043700' LIMIT 1;
UPDATE tm_group SET harga='2270000' WHERE kode_group = 'TG' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TG','2270000','input','2026-03-05 08:18:51');
UPDATE tm_group SET harga='2290000' WHERE kode_group = 'TH' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TH','2290000','input','2026-03-05 08:19:15');
UPDATE tm_group SET harga='2310000' WHERE kode_group = 'TI' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TI','2310000','input','2026-03-05 08:19:24');
UPDATE tm_group SET harga='2330000' WHERE kode_group = 'TJ' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TJ','2330000','input','2026-03-05 08:19:31');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326051036311','input','1',' MEA1E X HW','TOKO','PM-A','A1E-ZBXC-187-0','AT X ITALY SLEP VAR HW 8K ','','0.650','1','100.00','799000','0','0','15000','800000','0','0','0','800000','SIN','00387866','A1E','0','0','-','0','1240000');
UPDATE tm_barang SET tgl_last_jual='2026-03-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZBXC-187-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2026-03-05' AND kode_barang='A1E-ZBXC-187-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326051036311','2026-03-05','0.650','2026-03-05','10:36:31','PLG0027440','800000','800000','0','800000','800000','input','2026-03-05 10:36:31','F32605103631');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-05','F326051036311','2026-03-05','10:36:31','SIN','800000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260305-0002','D','2026-03-05','10:36:31','input','PENJUALAN','F326051036311','2734622000','800000','2735422000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='800000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326051036311' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326051036312','input',' 1',' MEE1 CM 12','TOKO','PM-E','E1E-ZAAC-269-0','CC MODEL HATI VAR CM 12 8K ','','0.750','1','100.00','922000','0','0','15000','923000','0','0','0','923000','SIN','00385176','E1E','0','0','-','0','1240000');
UPDATE tm_barang SET tgl_last_jual='2026-03-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZAAC-269-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-03-05' AND kode_barang='E1E-ZAAC-269-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326051036312','2026-03-05','0.750','2026-03-05','10:36:31','PLG0027441','923000','923000','0','923000','923000','input','2026-03-05 10:36:31','F32605103631');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-05','F326051036312','2026-03-05','10:36:31','SIN','923000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260305-0003','D','2026-03-05','10:36:31','input','PENJUALAN','F326051036312','2735422000','923000','2736345000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='923000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326051036312' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326051044571','input','1',' MEA1E X BW','TOKO','PM-A','A1E-ZBBE-145-0','AT X ITALY SLEP VAR BW 8K ','','0.520','1','100.00','640000','0','0','15000','640000','0','0','0','640000','LIS','00391291','A1E','0','0','-','0','1240000');
UPDATE tm_barang SET tgl_last_jual='2026-03-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZBBE-145-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-03-05' AND kode_barang='A1E-ZBBE-145-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326051044571','2026-03-05','0.520','2026-03-05','10:44:58','PLG0027442','640000','640000','0','640000','640000','input','2026-03-05 10:44:57','F32605104457');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-05','F326051044571','2026-03-05','10:44:58','LIS','640000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260305-0004','D','2026-03-05','10:44:58','input','PENJUALAN','F326051044571','2736345000','640000','2736985000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326051058001','input','1',' MFA1F X UB','TOKO','PM-A','A1F-WIXF-220-0','AT X HUGGIES ARESO VAR UB ','','1.270','1','100.00','1587000','0','0','15000','1588000','0','0','0','1588000','SIN','00252713','A1F','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-03-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-WIXF-220-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.270',berat_jual_asli=berat_jual_asli+'1.270',stock_jual='1',berat_akhir=berat_akhir-'1.270',berat_akhir_asli=berat_akhir_asli-'1.270',stock_akhir='0' WHERE tanggal='2026-03-05' AND kode_barang='A1F-WIXF-220-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326051058001','2026-03-05','1.270','2026-03-05','10:58:00','PLG0027443','1588000','1588000','0','1588000','1588000','input','2026-03-05 10:58:00','F32605105800');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-05','F326051058001','2026-03-05','10:58:00','SIN','1588000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260305-0005','D','2026-03-05','10:58:00','input','PENJUALAN','F326051058001','2736985000','1588000','2738573000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326051058311','input','1',' MEB1 LG ','TOKO','PM-B','B1E-ZACX-218-0','GW TOGE MODEL BUNNY VAR LG 8K ','','0.520','1','100.00','640000','0','0','15000','640000','0','0','0','640000','FIT','00387519','B1E','0','0','-','0','1240000');
UPDATE tm_barang SET tgl_last_jual='2026-03-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZACX-218-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-03-05' AND kode_barang='B1E-ZACX-218-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326051058311','2026-03-05','0.520','2026-03-05','10:58:31','PLG0027444','640000','640000','0','640000','640000','input','2026-03-05 10:58:31','F32605105831');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-05','F326051058311','2026-03-05','10:58:31','FIT','640000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260305-0006','D','2026-03-05','10:58:31','input','PENJUALAN','F326051058311','2738573000','640000','2739213000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00018358','X-00018358','KL SANTA ANAK MODEL BONEKA CAT VAR UB 8K','GR','---','H1E','BELI','BELI001','1970000','2026-03-05','2.510','1','kasir','2026-03-05 12:46:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00018358','X-00018358');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260305-0001','F325151045401','FIT','1','BELI','BELI001','H1E', 'X-00018358', 'KL SANTA ANAK MODEL BONEKA CAT VAR UB 8K','2.540','2.510','100.00','2145000','1970000','784861','1240000','1','1970000','1970000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.510',berat_beli_asli=berat_beli_asli+'2.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.510',berat_akhir_asli=berat_akhir_asli+'2.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260305-0001','2026-03-05','2026-03-05','12:46:33','FIT','---','2.510','1970000','1970000','1970000','1970000','1970000','kasir','2026-03-05 12:46:33','FB-260305-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260305-0001','KIARA','KISMANTORO','','','','kasir','2026-03-05 12:46:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-05' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260305-0007','K','2026-03-05','12:46:33','kasir','PEMBELIAN UMUM','FB-260305-0001','2739213000','1970000','2737243000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00018359','X-00018359','GL ANAK TRIXIE SERUT BONEKA CATVAR UB 8K','GR','---','F3E','BELI','BELI001','1745000','2026-03-05','1.530','1','kasir','2026-03-05 12:46:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00018359','X-00018359');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260305-0002','F326251221201','FIT','2','BELI','BELI001','F3E', 'X-00018359', 'GL ANAK TRIXIE SERUT BONEKA CATVAR UB 8K','1.530','1.530','100.00','1898000','1745000','1140523','1240000','1','1745000','1745000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.530',berat_beli_asli=berat_beli_asli+'1.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.530',berat_akhir_asli=berat_akhir_asli+'1.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260305-0002','2026-03-05','2026-03-05','12:46:33','FIT','---','1.530','1745000','1745000','1745000','1745000','1745000','kasir','2026-03-05 12:46:33','FB-260305-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260305-0002','KIARA','GADUNGAN KISMANTORO','','','','kasir','2026-03-05 12:46:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-05' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260305-0008','K','2026-03-05','12:46:33','kasir','PEMBELIAN UMUM','FB-260305-0002','2737243000','1745000','2735498000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00018360','X-00018360','CC MODEL C CM 14 8K','GR','---','E1D','BELI','BELI001','822000','2026-03-05','1.060','1','kasir','2026-03-05 12:47:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00018360','X-00018360');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260305-0003','F325090853532','SIN','1','BELI','BELI001','E1D', 'X-00018360', 'CC MODEL C CM 14 8K','1.060','1.060','100.00','875000','822000','775472','1220000','1','822000','822000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.060',berat_beli_asli=berat_beli_asli+'1.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.060',berat_akhir_asli=berat_akhir_asli+'1.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260305-0003','2026-03-05','2026-03-05','12:47:33','SIN','---','1.060','822000','822000','822000','822000','822000','kasir','2026-03-05 12:47:33','FB-260305-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260305-0003','LILIK','TENGKLIK BULUKERTO','','','','kasir','2026-03-05 12:47:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-05' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260305-0009','K','2026-03-05','12:47:33','kasir','PEMBELIAN UMUM','FB-260305-0003','2735498000','822000','2734676000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00018361','X-00018361','AT KLIP MODEL BONEKA CAT MATA VAR LG 8K','GR','---','A1D','BELI','BELI001','752000','2026-03-05','1.030','1','kasir','2026-03-05 12:48:15');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00018361','X-00018361');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260305-0004','F325071140281','LIS','1','BELI','BELI001','A1D', 'X-00018361', 'AT KLIP MODEL BONEKA CAT MATA VAR LG 8K','1.030','1.030','100.00','800000','752000','730097','1220000','1','752000','752000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.030',berat_beli_asli=berat_beli_asli+'1.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.030',berat_akhir_asli=berat_akhir_asli+'1.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260305-0004','2026-03-05','2026-03-05','12:48:14','LIS','---','1.030','752000','752000','752000','752000','752000','kasir','2026-03-05 12:48:15','FB-260305-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260305-0004','AUDREY','SAYUTAN PARANG','','','','kasir','2026-03-05 12:48:15');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-05' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260305-0010','K','2026-03-05','12:48:14','kasir','PEMBELIAN UMUM','FB-260305-0004','2734676000','752000','2733924000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00018362','X-00018362','GL TIFF SLEP VAR SERUT LG 8K','GR','---','F3E','BELI','BELI001','1170000','2026-03-05','1.220','1','kasir','2026-03-05 12:48:34');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00018362','X-00018362');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260305-0005','F325281216001','LIS','1','BELI','BELI001','F3E', 'X-00018362', 'GL TIFF SLEP VAR SERUT LG 8K','1.220','1.220','100.00','1245000','1170000','959016','1240000','1','1170000','1170000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.220',berat_beli_asli=berat_beli_asli+'1.220',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.220',berat_akhir_asli=berat_akhir_asli+'1.220',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260305-0005','2026-03-05','2026-03-05','12:48:33','LIS','---','1.220','1170000','1170000','1170000','1170000','1170000','kasir','2026-03-05 12:48:34','FB-260305-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260305-0005','MELVINA','NGUNENG PUHPELEM','','','','kasir','2026-03-05 12:48:34');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-05' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260305-0011','K','2026-03-05','12:48:33','kasir','PEMBELIAN UMUM','FB-260305-0005','2733924000','1170000','2732754000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326051249341','kasir','1',' MDE1 X PM ','TOKO','PM-E','E1D-ZCXB-152-0','CC X MODEL SLEP PM 14 8K ','','1.030','1','100.00','1246000','0','0','15000','1245000','0','0','0','1245000','SIN','00391575','E1D','0','0','-','1','1220000');
UPDATE tm_barang SET tgl_last_jual='2026-03-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCXB-152-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-03-05' AND kode_barang='E1D-ZCXB-152-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326051249341','2026-03-05','1.030','2026-03-05','12:49:35','PLG0027445','1245000','1245000','0','1245000','1245000','kasir','2026-03-05 12:49:34','F32605124934');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-05','F326051249341','2026-03-05','12:49:35','SIN','1245000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260305-0012','D','2026-03-05','12:49:35','kasir','PENJUALAN','F326051249341','2732754000','1245000','2733999000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00018363','X-00018363','GL X PIPA ANAK BONEKA CAT MATA VAR LG D40 8K','GR','---','F2E','BELI','BELI001','1500000','2026-03-05','1.970','1','kasir','2026-03-05 12:53:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00018363','X-00018363');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260305-0006','F325130208241','FIT','1','BELI','BELI001','F2E', 'X-00018363', 'GL X PIPA ANAK BONEKA CAT MATA VAR LG D40 8K','1.970','1.970','100.00','1605000','1500000','761421','1240000','1','1500000','1500000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.970',berat_beli_asli=berat_beli_asli+'1.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.970',berat_akhir_asli=berat_akhir_asli+'1.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260305-0006','2026-03-05','2026-03-05','12:53:22','FIT','---','1.970','1500000','1500000','1500000','1500000','1500000','kasir','2026-03-05 12:53:23','FB-260305-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260305-0006','ERLITA','JATISRONO','','','','kasir','2026-03-05 12:53:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-05' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260305-0013','K','2026-03-05','12:53:22','kasir','PEMBELIAN UMUM','FB-260305-0006','2733999000','1500000','2732499000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326050244131','input','1',' MDE2 X LG ','TOKO','PM-E','E2D-ZCXB-31-0','CC X MODEL MATA LG 12 8K ','','0.810','1','100.00','980000','0','0','15000','980000','0','0','0','980000','FIT','00391454','E2D','0','0','-','0','1220000');
UPDATE tm_barang SET tgl_last_jual='2026-03-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCXB-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.810',berat_jual_asli=berat_jual_asli+'0.810',stock_jual='1',berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810',stock_akhir='0' WHERE tanggal='2026-03-05' AND kode_barang='E2D-ZCXB-31-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326050244131','2026-03-05','0.810','2026-03-05','14:44:13','PLG0027446','980000','980000','0','980000','980000','input','2026-03-05 14:44:13','F32605024413');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-05','F326050244131','2026-03-05','14:44:13','FIT','980000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260305-0014','D','2026-03-05','14:44:13','input','PENJUALAN','F326050244131','2732499000','980000','2733479000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260305-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260305-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260305-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260305-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260305-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260305-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260305-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260305-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260305-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260305-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260305-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260305-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050244131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050244131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050244131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051036311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051036311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051036311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051036312' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051036312' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051036312';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051044571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051044571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051044571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051058001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051058001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051058001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051058311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051058311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051058311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051249341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051249341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051249341';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-06','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-03';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-05';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-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='2026-03-05' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-05';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-05';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-05';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-05';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-06' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-05' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260306-0001','D','2026-03-06','15:19:03','SYSTEM','SALDO AWAL','SALDO AWAL','0','2733479000','2733479000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260306-0001','D','2026-03-06','15:19:03','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260306-0001','D','2026-03-06','15:19:03','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260306-0001','D','2026-03-06','15:19:03','BCA','SALDO AWAL','SALDO AWAL','0','707186000','707186000');
UPDATE tp_system SET tgl_system='2026-03-06';
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-20260306-0001','1','E2D-ZBAD-252-0','1','0.850','0.850','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZBAD-252-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZBAD-252-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-06 16:35:34' WHERE kode_barang='E2D-ZBAD-252-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZBAD-252-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 ('2026-03-06 16:35:34','TOKO','PM-E','E2D','E2D-ZBAD-252-0','1','0.850','0.850','1','0.850','0.850','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-ZBAD-252-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZBAD-252-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-20260306-0001','1','E1D-ZBBE-79-0','1','1.150','1.150','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZBBE-79-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZBBE-79-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-06 16:35:34' WHERE kode_barang='E1D-ZBBE-79-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZBBE-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 ('2026-03-06 16:35:34','TOKO','PM-E','E1D','E1D-ZBBE-79-0','1','1.150','1.150','1','1.150','1.150','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' 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='E1D-ZBBE-79-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZBBE-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-20260306-0001','1','E1E-ZCXB-187-0','1','0.520','0.520','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZCXB-187-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZCXB-187-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-06 16:35:34' WHERE kode_barang='E1E-ZCXB-187-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZCXB-187-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 ('2026-03-06 16:35:34','TOKO','PM-E','E1E','E1E-ZCXB-187-0','1','0.520','0.520','1','0.520','0.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZCXB-187-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZCXB-187-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-20260306-0001','1','E2D-ZCXE-125-0','1','1.350','1.350','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZCXE-125-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZCXE-125-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-06 16:35:34' WHERE kode_barang='E2D-ZCXE-125-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZCXE-125-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 ('2026-03-06 16:35:34','TOKO','PM-E','E2D','E2D-ZCXE-125-0','1','1.350','1.350','1','1.350','1.350','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-ZCXE-125-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZCXE-125-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-20260306-0001','1','E2D-ZCXE-126-0','1','1.460','1.460','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZCXE-126-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZCXE-126-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-06 16:35:34' WHERE kode_barang='E2D-ZCXE-126-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZCXE-126-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 ('2026-03-06 16:35:34','TOKO','PM-E','E2D','E2D-ZCXE-126-0','1','1.460','1.460','1','1.460','1.460','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-ZCXE-126-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZCXE-126-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-20260306-0001','1','E2D-ZCXE-127-0','1','0.830','0.830','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZCXE-127-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZCXE-127-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-06 16:35:35' WHERE kode_barang='E2D-ZCXE-127-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZCXE-127-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 ('2026-03-06 16:35:35','TOKO','PM-E','E2D','E2D-ZCXE-127-0','1','0.830','0.830','1','0.830','0.830','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-ZCXE-127-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZCXE-127-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-20260306-0001','1','E1D-ZCXE-128-0','1','1.170','1.170','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZCXE-128-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZCXE-128-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-06 16:35:35' WHERE kode_barang='E1D-ZCXE-128-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZCXE-128-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 ('2026-03-06 16:35:35','TOKO','PM-E','E1D','E1D-ZCXE-128-0','1','1.170','1.170','1','1.170','1.170','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' 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='E1D-ZCXE-128-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZCXE-128-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-20260306-0001','1','E1D-ZCXE-129-0','1','1.180','1.180','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZCXE-129-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZCXE-129-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-06 16:35:35' WHERE kode_barang='E1D-ZCXE-129-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZCXE-129-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 ('2026-03-06 16:35:35','TOKO','PM-E','E1D','E1D-ZCXE-129-0','1','1.180','1.180','1','1.180','1.180','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' 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='E1D-ZCXE-129-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZCXE-129-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-20260306-0001','1','E1D-ZCXE-130-0','1','1.150','1.150','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZCXE-130-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZCXE-130-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-06 16:35:35' WHERE kode_barang='E1D-ZCXE-130-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZCXE-130-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 ('2026-03-06 16:35:35','TOKO','PM-E','E1D','E1D-ZCXE-130-0','1','1.150','1.150','1','1.150','1.150','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' 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='E1D-ZCXE-130-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZCXE-130-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-20260306-0001','1','E1D-ZCXE-131-0','1','1.210','1.210','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZCXE-131-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZCXE-131-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-06 16:35:35' WHERE kode_barang='E1D-ZCXE-131-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZCXE-131-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 ('2026-03-06 16:35:35','TOKO','PM-E','E1D','E1D-ZCXE-131-0','1','1.210','1.210','1','1.210','1.210','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' 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='E1D-ZCXE-131-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZCXE-131-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-20260306-0001','1','E1E-ZCXE-132-0','1','0.530','0.530','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZCXE-132-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZCXE-132-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-06 16:35:35' WHERE kode_barang='E1E-ZCXE-132-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZCXE-132-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 ('2026-03-06 16:35:35','TOKO','PM-E','E1E','E1E-ZCXE-132-0','1','0.530','0.530','1','0.530','0.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZCXE-132-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZCXE-132-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-20260306-0001','1','E1E-ZCXE-133-0','1','0.550','0.550','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZCXE-133-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZCXE-133-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-06 16:35:35' WHERE kode_barang='E1E-ZCXE-133-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZCXE-133-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 ('2026-03-06 16:35:35','TOKO','PM-E','E1E','E1E-ZCXE-133-0','1','0.550','0.550','1','0.550','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZCXE-133-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZCXE-133-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-20260306-0001','1','E1E-ZCXE-134-0','1','0.720','0.720','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZCXE-134-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZCXE-134-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-06 16:35:35' WHERE kode_barang='E1E-ZCXE-134-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZCXE-134-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 ('2026-03-06 16:35:35','TOKO','PM-E','E1E','E1E-ZCXE-134-0','1','0.720','0.720','1','0.720','0.720','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZCXE-134-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZCXE-134-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-20260306-0001','1','E1E-ZCXE-135-0','1','0.810','0.810','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZCXE-135-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZCXE-135-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-06 16:35:35' WHERE kode_barang='E1E-ZCXE-135-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZCXE-135-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 ('2026-03-06 16:35:35','TOKO','PM-E','E1E','E1E-ZCXE-135-0','1','0.810','0.810','1','0.810','0.810','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZCXE-135-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZCXE-135-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-20260306-0001','1','E1G-ZCXE-136-0','1','0.310','0.310','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1G-ZCXE-136-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1G-ZCXE-136-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-06 16:35:35' WHERE kode_barang='E1G-ZCXE-136-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1G-ZCXE-136-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 ('2026-03-06 16:35:35','TOKO','PM-E','E1G','E1G-ZCXE-136-0','1','0.310','0.310','1','0.310','0.310','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1G' 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='E1G-ZCXE-136-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1G-ZCXE-136-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-20260306-0001','1','E1G-ZCXE-137-0','1','0.320','0.320','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1G-ZCXE-137-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1G-ZCXE-137-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-06 16:35:35' WHERE kode_barang='E1G-ZCXE-137-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1G-ZCXE-137-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 ('2026-03-06 16:35:35','TOKO','PM-E','E1G','E1G-ZCXE-137-0','1','0.320','0.320','1','0.320','0.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1G' 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='E1G-ZCXE-137-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1G-ZCXE-137-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-20260306-0001','1','E1G-ZCXE-138-0','1','0.360','0.360','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1G-ZCXE-138-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1G-ZCXE-138-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-06 16:35:35' WHERE kode_barang='E1G-ZCXE-138-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1G-ZCXE-138-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 ('2026-03-06 16:35:35','TOKO','PM-E','E1G','E1G-ZCXE-138-0','1','0.360','0.360','1','0.360','0.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1G' 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='E1G-ZCXE-138-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1G-ZCXE-138-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-20260306-0001','1','E1G-ZCXE-139-0','1','0.350','0.350','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1G-ZCXE-139-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1G-ZCXE-139-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-06 16:35:35' WHERE kode_barang='E1G-ZCXE-139-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1G-ZCXE-139-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 ('2026-03-06 16:35:35','TOKO','PM-E','E1G','E1G-ZCXE-139-0','1','0.350','0.350','1','0.350','0.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1G' 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='E1G-ZCXE-139-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1G-ZCXE-139-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-20260306-0001','1','E1G-ZCXE-140-0','1','0.350','0.350','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1G-ZCXE-140-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1G-ZCXE-140-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-03-06 16:35:35' WHERE kode_barang='E1G-ZCXE-140-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1G-ZCXE-140-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 ('2026-03-06 16:35:35','TOKO','PM-E','E1G','E1G-ZCXE-140-0','1','0.350','0.350','1','0.350','0.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1G' 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='E1G-ZCXE-140-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1G-ZCXE-140-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260306-0001','2026-03-06','16:35','15.170','admpindah','2026-03-05 16:35:34');
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-20260306-0001','1','F3E-ZCXE-149-0','1','1.610','1.610','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZCXE-149-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZCXE-149-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-03-06 16:36:02' WHERE kode_barang='F3E-ZCXE-149-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZCXE-149-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 ('2026-03-06 16:36:02','TOKO','PM-F','F3E','F3E-ZCXE-149-0','1','1.610','1.610','1','1.610','1.610','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' 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='F3E-ZCXE-149-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZCXE-149-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-20260306-0001','1','F3E-ZCXE-150-0','1','3.040','3.040','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZCXE-150-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZCXE-150-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-03-06 16:36:02' WHERE kode_barang='F3E-ZCXE-150-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZCXE-150-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 ('2026-03-06 16:36:02','TOKO','PM-F','F3E','F3E-ZCXE-150-0','1','3.040','3.040','1','3.040','3.040','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' 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='F3E-ZCXE-150-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZCXE-150-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-20260306-0001','1','F3E-ZCXE-151-0','1','1.530','1.530','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZCXE-151-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZCXE-151-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-03-06 16:36:02' WHERE kode_barang='F3E-ZCXE-151-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZCXE-151-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 ('2026-03-06 16:36:02','TOKO','PM-F','F3E','F3E-ZCXE-151-0','1','1.530','1.530','1','1.530','1.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' 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='F3E-ZCXE-151-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZCXE-151-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-20260306-0001','1','F3E-ZCXE-152-0','1','5.650','5.650','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZCXE-152-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZCXE-152-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-03-06 16:36:02' WHERE kode_barang='F3E-ZCXE-152-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZCXE-152-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 ('2026-03-06 16:36:02','TOKO','PM-F','F3E','F3E-ZCXE-152-0','1','5.650','5.650','1','5.650','5.650','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' 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='F3E-ZCXE-152-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZCXE-152-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-20260306-0001','1','F3E-ZCXE-153-0','1','7.170','7.170','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZCXE-153-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZCXE-153-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-03-06 16:36:02' WHERE kode_barang='F3E-ZCXE-153-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZCXE-153-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 ('2026-03-06 16:36:02','TOKO','PM-F','F3E','F3E-ZCXE-153-0','1','7.170','7.170','1','7.170','7.170','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' 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='F3E-ZCXE-153-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZCXE-153-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-20260306-0001','1','F2E-ZCXE-154-0','1','2.270','2.270','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-ZCXE-154-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-ZCXE-154-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-03-06 16:36:02' WHERE kode_barang='F2E-ZCXE-154-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-ZCXE-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 ('2026-03-06 16:36:02','TOKO','PM-F','F2E','F2E-ZCXE-154-0','1','2.270','2.270','1','2.270','2.270','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' 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='F2E-ZCXE-154-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-ZCXE-154-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260306-0001','2026-03-06','16:35','21.270','admpindah','2026-03-05 16:36:01');