INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-29 ','08:07:49');
DELETE FROM tm_berlian WHERE kode_barang='TFG-XIXF-55-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFG-XIXF-55-0','TFG-XIXF-55-0','00031175','RD','84','0.410','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFG-XIXF-55-0','00031175','RD','84','0.410','420','172.2')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFG-XIXF-55-0','TFG-XIXF-55-0','00031175','RD','1','0.075','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFG-XIXF-55-0','00031175','RD','1','0.075','450','33.75')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFG-XIXF-55-0','TFG-XIXF-55-0','00031175','RD','6','0.325','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFG-XIXF-55-0','00031175','RD','6','0.325','450','146.25')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('TFG-XIXF-55-0','00031175','00031175','GELANG TFG-21044','GELANG TFG-21044','','','14642500','14642500',' 0','0','kasir','2025-08-29 08:10:26');
UPDATE tm_barang SET nama_barang='GELANG TFG-21044' ,nama_atribut='' ,kode_intern='TFG-21044 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='G201 1224',total_usd_ext='IDR 75 500 000',total_usd='352.2' WHERE kode_barang='TFG-XIXF-55-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFG-YAXC-4-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFG-YAXC-4-0','TFG-YAXC-4-0','00033184','RD','13','0.505','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFG-YAXC-4-0','00033184','RD','13','0.505','420','212.1')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('TFG-YAXC-4-0','00033184','00033184','GELANG TFG-21052 ','GELANG TFG-21052','','','11907000','11907000',' 0','0','kasir','2025-08-29 08:12:23');
UPDATE tm_barang SET nama_barang='GELANG TFG-21052' ,nama_atribut='' ,kode_intern='TFG-21052 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='0125',total_usd_ext='IDB 54 000 000',total_usd='212.1' WHERE kode_barang='TFG-YAXC-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDG-XJXD-6-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDG-XJXD-6-0','BDG-XJXD-6-0','00031613','RD','1','0.050','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDG-XJXD-6-0','00031613','RD','1','0.050','450','22.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDG-XJXD-6-0','BDG-XJXD-6-0','00031613','RD','2','0.055','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDG-XJXD-6-0','00031613','RD','2','0.055','400','22')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDG-XJXD-6-0','BDG-XJXD-6-0','00031613','RD','41','0.180','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDG-XJXD-6-0','00031613','RD','41','0.180','400','72')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDG-XJXD-6-0','00031613','00031613','GELANG BDG-00003 ','GELANG BDG-00003','','','7542500','7542500',' 0','0','kasir','2025-08-29 08:13:49');
UPDATE tm_barang SET nama_barang='GELANG BDG-00003' ,nama_atribut='' ,kode_intern='BDG-00003 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='IDR 37 000 000',total_usd='116.5' WHERE kode_barang='BDG-XJXD-6-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-08-29 ','08:16:25');
DELETE FROM tm_berlian WHERE kode_barang='TFG-XIXF-55-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFG-XIXF-55-0','TFG-XIXF-55-0','00031175','RD','6','0.325','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFG-XIXF-55-0','00031175','RD','6','0.325','450','146.25')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFG-XIXF-55-0','TFG-XIXF-55-0','00031175','RD','1','0.075','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFG-XIXF-55-0','00031175','RD','1','0.075','450','33.75')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFG-XIXF-55-0','TFG-XIXF-55-0','00031175','RD','84','0.410','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFG-XIXF-55-0','00031175','RD','84','0.410','420','172.2')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('TFG-XIXF-55-0','00031175','00031175','GELANG TFG-21044','GELANG TFG-21044','','','14642500','14642500',' 0','0','spv','2025-08-29 08:17:07');
UPDATE tm_barang SET nama_barang='GELANG TFG-21044' ,nama_atribut='' ,kode_intern='TFG-21044 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='G201 0825',total_usd_ext='IDR 75 500 000',total_usd='352.2' WHERE kode_barang='TFG-XIXF-55-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFG-YAXC-4-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFG-YAXC-4-0','TFG-YAXC-4-0','00033184','RD','13','0.505','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFG-YAXC-4-0','00033184','RD','13','0.505','420','212.1')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('TFG-YAXC-4-0','00033184','00033184','GELANG TFG-21052','GELANG TFG-21052','','','11907000','11907000',' 0','0','spv','2025-08-29 08:17:40');
UPDATE tm_barang SET nama_barang='GELANG TFG-21052' ,nama_atribut='' ,kode_intern='TFG-21052 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='0825',total_usd_ext='IDB 54 000 000',total_usd='212.1' WHERE kode_barang='TFG-YAXC-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDG-XJXD-6-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDG-XJXD-6-0','BDG-XJXD-6-0','00031613','RD','41','0.180','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDG-XJXD-6-0','00031613','RD','41','0.180','400','72')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDG-XJXD-6-0','BDG-XJXD-6-0','00031613','RD','2','0.055','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDG-XJXD-6-0','00031613','RD','2','0.055','400','22')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDG-XJXD-6-0','BDG-XJXD-6-0','00031613','RD','1','0.050','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDG-XJXD-6-0','00031613','RD','1','0.050','450','22.5')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDG-XJXD-6-0','00031613','00031613','GELANG BDG-00003','GELANG BDG-00003','','','7542500','7542500',' 0','0','spv','2025-08-29 08:18:09');
UPDATE tm_barang SET nama_barang='GELANG BDG-00003' ,nama_atribut='' ,kode_intern='BDG-00003 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='0825',total_usd_ext='IDR 37 000 000',total_usd='116.5' WHERE kode_barang='BDG-XJXD-6-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-29 ','09:55:23');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-29 ','10:26:48');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-29 ','13:21:38');
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6285000',harga_beli ='6285000' WHERE kode_barcode='00017312' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5675500',harga_beli ='5675500' WHERE kode_barcode='00017383' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6225500',harga_beli ='6225500' WHERE kode_barcode='00017542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4205000',harga_beli ='4205000' WHERE kode_barcode='00017624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6745500',harga_beli ='6745500' WHERE kode_barcode='00017626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6611500',harga_beli ='6611500' WHERE kode_barcode='00017628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5349000',harga_beli ='5349000' WHERE kode_barcode='00017636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3774000',harga_beli ='3774000' WHERE kode_barcode='00017662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4561500',harga_beli ='4561500' WHERE kode_barcode='00017663' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8899500',harga_beli ='8899500' WHERE kode_barcode='00017681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8766000',harga_beli ='8766000' WHERE kode_barcode='00017697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4145500',harga_beli ='4145500' WHERE kode_barcode='00017698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4279000',harga_beli ='4279000' WHERE kode_barcode='00017717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2184500',harga_beli ='2184500' WHERE kode_barcode='00017759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2154500',harga_beli ='2154500' WHERE kode_barcode='00017760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='9078000',harga_beli ='9078000' WHERE kode_barcode='00017900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='35092500',harga_beli ='35092500' WHERE kode_barcode='00017913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3046000',harga_beli ='3046000' WHERE kode_barcode='00017959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5943000',harga_beli ='5943000' WHERE kode_barcode='00017982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='9003500',harga_beli ='9003500' WHERE kode_barcode='00018019' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6202500',harga_beli ='6202500' WHERE kode_barcode='00018036' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4591000',harga_beli ='4591000' WHERE kode_barcode='00018073' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='13758000',harga_beli ='13758000' WHERE kode_barcode='00018112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5022000',harga_beli ='5022000' WHERE kode_barcode='00018284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5081500',harga_beli ='5081500' WHERE kode_barcode='00018285' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4086000',harga_beli ='4086000' WHERE kode_barcode='00018302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2021000',harga_beli ='2021000' WHERE kode_barcode='00018312' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1991000',harga_beli ='1991000' WHERE kode_barcode='00018337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6611500',harga_beli ='6611500' WHERE kode_barcode='00018371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6953500',harga_beli ='6953500' WHERE kode_barcode='00018463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='9672000',harga_beli ='9672000' WHERE kode_barcode='00018491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3937500',harga_beli ='3937500' WHERE kode_barcode='00018517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4294000',harga_beli ='4294000' WHERE kode_barcode='00018519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5338000',harga_beli ='5338000' WHERE kode_barcode='00018718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3016000',harga_beli ='3016000' WHERE kode_barcode='00018891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3595500',harga_beli ='3595500' WHERE kode_barcode='00018924' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2823000',harga_beli ='2823000' WHERE kode_barcode='00018925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3551000',harga_beli ='3551000' WHERE kode_barcode='00018927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2986500',harga_beli ='2986500' WHERE kode_barcode='00018937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3031000',harga_beli ='3031000' WHERE kode_barcode='00019018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7369500',harga_beli ='7369500' WHERE kode_barcode='00019120' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2778500',harga_beli ='2778500' WHERE kode_barcode='00019123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2897500',harga_beli ='2897500' WHERE kode_barcode='00019148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3670000',harga_beli ='3670000' WHERE kode_barcode='00019153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5170500',harga_beli ='5170500' WHERE kode_barcode='00019234' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3907500',harga_beli ='3907500' WHERE kode_barcode='00019236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5185500',harga_beli ='5185500' WHERE kode_barcode='00019283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6389000',harga_beli ='6389000' WHERE kode_barcode='00019360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3254000',harga_beli ='3254000' WHERE kode_barcode='00019451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3774000',harga_beli ='3774000' WHERE kode_barcode='00019510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4903000',harga_beli ='4903000' WHERE kode_barcode='00019562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4650500',harga_beli ='4650500' WHERE kode_barcode='00019563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4442500',harga_beli ='4442500' WHERE kode_barcode='00019564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6032000',harga_beli ='6032000' WHERE kode_barcode='00019652' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4710000',harga_beli ='4710000' WHERE kode_barcode='00019655' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3283500',harga_beli ='3283500' WHERE kode_barcode='00019656' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6983000',harga_beli ='6983000' WHERE kode_barcode='00019742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2957000',harga_beli ='2957000' WHERE kode_barcode='00019840' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4249500',harga_beli ='4249500' WHERE kode_barcode='00019911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4502000',harga_beli ='4502000' WHERE kode_barcode='00020018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5289500',harga_beli ='5289500' WHERE kode_barcode='00020068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4992000',harga_beli ='4992000' WHERE kode_barcode='00020069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5155500',harga_beli ='5155500' WHERE kode_barcode='00020070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4725000',harga_beli ='4725000' WHERE kode_barcode='00020071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5646000',harga_beli ='5646000' WHERE kode_barcode='00020074' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4962500',harga_beli ='4962500' WHERE kode_barcode='00020075' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5111000',harga_beli ='5111000' WHERE kode_barcode='00020076' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4086000',harga_beli ='4086000' WHERE kode_barcode='00020077' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4903000',harga_beli ='4903000' WHERE kode_barcode='00020080' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7027500',harga_beli ='7027500' WHERE kode_barcode='00020156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4814000',harga_beli ='4814000' WHERE kode_barcode='00020166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5883500',harga_beli ='5883500' WHERE kode_barcode='00020168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8008000',harga_beli ='8008000' WHERE kode_barcode='00020174' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4264000',harga_beli ='4264000' WHERE kode_barcode='00020179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4353500',harga_beli ='4353500' WHERE kode_barcode='00020186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7310000',harga_beli ='7310000' WHERE kode_barcode='00020190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5898500',harga_beli ='5898500' WHERE kode_barcode='00020191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4323500',harga_beli ='4323500' WHERE kode_barcode='00020200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='34207000',harga_beli ='34207000' WHERE kode_barcode='00020223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5185500',harga_beli ='5185500' WHERE kode_barcode='00020244' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4725000',harga_beli ='4725000' WHERE kode_barcode='00020259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5155500',harga_beli ='5155500' WHERE kode_barcode='00020365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3536000',harga_beli ='3536000' WHERE kode_barcode='00020492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4219500',harga_beli ='4219500' WHERE kode_barcode='00020616' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3893000',harga_beli ='3893000' WHERE kode_barcode='00020834' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3982000',harga_beli ='3982000' WHERE kode_barcode='00020846' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5705500',harga_beli ='5705500' WHERE kode_barcode='00021113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6433500',harga_beli ='6433500' WHERE kode_barcode='00021253' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4695000',harga_beli ='4695000' WHERE kode_barcode='00021254' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4517000',harga_beli ='4517000' WHERE kode_barcode='00021280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6641500',harga_beli ='6641500' WHERE kode_barcode='00021405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3853500',harga_beli ='3853500' WHERE kode_barcode='00021475' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3101500',harga_beli ='3101500' WHERE kode_barcode='00021503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='17855500',harga_beli ='17855500' WHERE kode_barcode='00021505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='9886500',harga_beli ='9886500' WHERE kode_barcode='00021506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7105000',harga_beli ='7105000' WHERE kode_barcode='00021585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2857000',harga_beli ='2857000' WHERE kode_barcode='00021609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8176000',harga_beli ='8176000' WHERE kode_barcode='00021630' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6090000',harga_beli ='6090000' WHERE kode_barcode='00021635' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4561500',harga_beli ='4561500' WHERE kode_barcode='00021755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6240000',harga_beli ='6240000' WHERE kode_barcode='00021756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4843500',harga_beli ='4843500' WHERE kode_barcode='00021758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6433500',harga_beli ='6433500' WHERE kode_barcode='00021759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3997000',harga_beli ='3997000' WHERE kode_barcode='00021781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6983000',harga_beli ='6983000' WHERE kode_barcode='00021782' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5779500',harga_beli ='5779500' WHERE kode_barcode='00021783' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='11559000',harga_beli ='11559000' WHERE kode_barcode='00021815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8261000',harga_beli ='8261000' WHERE kode_barcode='00021835' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='9137500',harga_beli ='9137500' WHERE kode_barcode='00021844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3026500',harga_beli ='3026500' WHERE kode_barcode='00021867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3026500',harga_beli ='3026500' WHERE kode_barcode='00021876' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3533500',harga_beli ='3533500' WHERE kode_barcode='00021878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='10831000',harga_beli ='10831000' WHERE kode_barcode='00021882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8261000',harga_beli ='8261000' WHERE kode_barcode='00021905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2615000',harga_beli ='2615000' WHERE kode_barcode='00021950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3625500',harga_beli ='3625500' WHERE kode_barcode='00021976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4413000',harga_beli ='4413000' WHERE kode_barcode='00021977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4086000',harga_beli ='4086000' WHERE kode_barcode='00021979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3878000',harga_beli ='3878000' WHERE kode_barcode='00021980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4933000',harga_beli ='4933000' WHERE kode_barcode='00022044' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4323500',harga_beli ='4323500' WHERE kode_barcode='00022045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5571500',harga_beli ='5571500' WHERE kode_barcode='00022046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3982000',harga_beli ='3982000' WHERE kode_barcode='00022071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4561500',harga_beli ='4561500' WHERE kode_barcode='00022114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5557000',harga_beli ='5557000' WHERE kode_barcode='00022140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4309000',harga_beli ='4309000' WHERE kode_barcode='00022141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4071000',harga_beli ='4071000' WHERE kode_barcode='00022142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4026500',harga_beli ='4026500' WHERE kode_barcode='00022143' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7726000',harga_beli ='7726000' WHERE kode_barcode='00022144' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5150000',harga_beli ='5150000' WHERE kode_barcode='00022173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6747500',harga_beli ='6747500' WHERE kode_barcode='00022174' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7368000',harga_beli ='7368000' WHERE kode_barcode='00022176' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5338000',harga_beli ='5338000' WHERE kode_barcode='00022180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5300500',harga_beli ='5300500' WHERE kode_barcode='00022227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7592000',harga_beli ='7592000' WHERE kode_barcode='00022322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='9924000',harga_beli ='9924000' WHERE kode_barcode='00022356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5453000',harga_beli ='5453000' WHERE kode_barcode='00022433' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5319500',harga_beli ='5319500' WHERE kode_barcode='00022442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3744000',harga_beli ='3744000' WHERE kode_barcode='00022450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4026500',harga_beli ='4026500' WHERE kode_barcode='00022468' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6077000',harga_beli ='6077000' WHERE kode_barcode='00022517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='13833500',harga_beli ='13833500' WHERE kode_barcode='00022649' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8038000',harga_beli ='8038000' WHERE kode_barcode='00022659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4266500',harga_beli ='4266500' WHERE kode_barcode='00022758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5357000',harga_beli ='5357000' WHERE kode_barcode='00022759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3922500',harga_beli ='3922500' WHERE kode_barcode='00022763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5733000',harga_beli ='5733000' WHERE kode_barcode='00022765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8627000',harga_beli ='8627000' WHERE kode_barcode='00022774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7932000',harga_beli ='7932000' WHERE kode_barcode='00022806' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5244000',harga_beli ='5244000' WHERE kode_barcode='00022808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7048500',harga_beli ='7048500' WHERE kode_barcode='00022809' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3759000',harga_beli ='3759000' WHERE kode_barcode='00022822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6710000',harga_beli ='6710000' WHERE kode_barcode='00022867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5225500',harga_beli ='5225500' WHERE kode_barcode='00022883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2808000',harga_beli ='2808000' WHERE kode_barcode='00022912' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4011500',harga_beli ='4011500' WHERE kode_barcode='00022950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5378500',harga_beli ='5378500' WHERE kode_barcode='00023060' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6804000',harga_beli ='6804000' WHERE kode_barcode='00023123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3744000',harga_beli ='3744000' WHERE kode_barcode='00023126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7042500',harga_beli ='7042500' WHERE kode_barcode='00023146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4814000',harga_beli ='4814000' WHERE kode_barcode='00023437' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5808000',harga_beli ='5808000' WHERE kode_barcode='00023488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8067500',harga_beli ='8067500' WHERE kode_barcode='00023490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='32965500',harga_beli ='32965500' WHERE kode_barcode='00023493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='16870000',harga_beli ='16870000' WHERE kode_barcode='00023537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3343000',harga_beli ='3343000' WHERE kode_barcode='00023549' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4427500',harga_beli ='4427500' WHERE kode_barcode='00023563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5467500',harga_beli ='5467500' WHERE kode_barcode='00023572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5274500',harga_beli ='5274500' WHERE kode_barcode='00023573' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7533000',harga_beli ='7533000' WHERE kode_barcode='00023585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2897500',harga_beli ='2897500' WHERE kode_barcode='00023590' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4775500',harga_beli ='4775500' WHERE kode_barcode='00023593' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4720000',harga_beli ='4720000' WHERE kode_barcode='00023594' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4683500',harga_beli ='4683500' WHERE kode_barcode='00023595' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5215000',harga_beli ='5215000' WHERE kode_barcode='00023596' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7485500',harga_beli ='7485500' WHERE kode_barcode='00023600' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7449000',harga_beli ='7449000' WHERE kode_barcode='00023602' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5328500',harga_beli ='5328500' WHERE kode_barcode='00023604' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5789500',harga_beli ='5789500' WHERE kode_barcode='00023605' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='9458500',harga_beli ='9458500' WHERE kode_barcode='00023606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6176500',harga_beli ='6176500' WHERE kode_barcode='00023607' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7522500',harga_beli ='7522500' WHERE kode_barcode='00023608' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5347000',harga_beli ='5347000' WHERE kode_barcode='00023609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8370500',harga_beli ='8370500' WHERE kode_barcode='00023611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7817500',harga_beli ='7817500' WHERE kode_barcode='00023612' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6232000',harga_beli ='6232000' WHERE kode_barcode='00023613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7836000',harga_beli ='7836000' WHERE kode_barcode='00023614' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4738500',harga_beli ='4738500' WHERE kode_barcode='00023617' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4041500',harga_beli ='4041500' WHERE kode_barcode='00023622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3687500',harga_beli ='3687500' WHERE kode_barcode='00023623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='10043500',harga_beli ='10043500' WHERE kode_barcode='00023626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5081500',harga_beli ='5081500' WHERE kode_barcode='00023629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2258500',harga_beli ='2258500' WHERE kode_barcode='00023632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2986500',harga_beli ='2986500' WHERE kode_barcode='00023666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1709000',harga_beli ='1709000' WHERE kode_barcode='00023679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3937500',harga_beli ='3937500' WHERE kode_barcode='00023691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5378500',harga_beli ='5378500' WHERE kode_barcode='00023692' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6374000',harga_beli ='6374000' WHERE kode_barcode='00023693' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6374000',harga_beli ='6374000' WHERE kode_barcode='00023697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='13275000',harga_beli ='13275000' WHERE kode_barcode='00023704' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7250500',harga_beli ='7250500' WHERE kode_barcode='00023760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8997500',harga_beli ='8997500' WHERE kode_barcode='00023815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3105500',harga_beli ='3105500' WHERE kode_barcode='00023830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8246000',harga_beli ='8246000' WHERE kode_barcode='00023843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3319000',harga_beli ='3319000' WHERE kode_barcode='00023848' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4383000',harga_beli ='4383000' WHERE kode_barcode='00023857' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4814000',harga_beli ='4814000' WHERE kode_barcode='00023907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4665500',harga_beli ='4665500' WHERE kode_barcode='00023913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4056000',harga_beli ='4056000' WHERE kode_barcode='00023917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4554000',harga_beli ='4554000' WHERE kode_barcode='00023920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4754500',harga_beli ='4754500' WHERE kode_barcode='00023934' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2303000',harga_beli ='2303000' WHERE kode_barcode='00023964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5898500',harga_beli ='5898500' WHERE kode_barcode='00023965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6527000',harga_beli ='6527000' WHERE kode_barcode='00023979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3997000',harga_beli ='3997000' WHERE kode_barcode='00023985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6745500',harga_beli ='6745500' WHERE kode_barcode='00023991' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4992000',harga_beli ='4992000' WHERE kode_barcode='00023997' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5453000',harga_beli ='5453000' WHERE kode_barcode='00023998' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5245000',harga_beli ='5245000' WHERE kode_barcode='00024000' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4264000',harga_beli ='4264000' WHERE kode_barcode='00024001' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6938500',harga_beli ='6938500' WHERE kode_barcode='00024004' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3997000',harga_beli ='3997000' WHERE kode_barcode='00024013' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6379500',harga_beli ='6379500' WHERE kode_barcode='00024038' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3893000',harga_beli ='3893000' WHERE kode_barcode='00024062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5601500',harga_beli ='5601500' WHERE kode_barcode='00024069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2422000',harga_beli ='2422000' WHERE kode_barcode='00024077' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4279000',harga_beli ='4279000' WHERE kode_barcode='00024080' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3016000',harga_beli ='3016000' WHERE kode_barcode='00024082' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3967000',harga_beli ='3967000' WHERE kode_barcode='00024085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3863000',harga_beli ='3863000' WHERE kode_barcode='00024086' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3153000',harga_beli ='3153000' WHERE kode_barcode='00024095' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5720000',harga_beli ='5720000' WHERE kode_barcode='00024096' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5170500',harga_beli ='5170500' WHERE kode_barcode='00024104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5958000',harga_beli ='5958000' WHERE kode_barcode='00024148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4606000',harga_beli ='4606000' WHERE kode_barcode='00024186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4531500',harga_beli ='4531500' WHERE kode_barcode='00024189' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8543000',harga_beli ='8543000' WHERE kode_barcode='00024193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3298500',harga_beli ='3298500' WHERE kode_barcode='00024194' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4650500',harga_beli ='4650500' WHERE kode_barcode='00024363' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5349000',harga_beli ='5349000' WHERE kode_barcode='00025284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5705500',harga_beli ='5705500' WHERE kode_barcode='00025286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='10831000',harga_beli ='10831000' WHERE kode_barcode='00025510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='13787500',harga_beli ='13787500' WHERE kode_barcode='00026215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='11818500',harga_beli ='11818500' WHERE kode_barcode='00026302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6195500',harga_beli ='6195500' WHERE kode_barcode='00026725' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3774000',harga_beli ='3774000' WHERE kode_barcode='00026882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4130500',harga_beli ='4130500' WHERE kode_barcode='00026884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6374000',harga_beli ='6374000' WHERE kode_barcode='00026894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2362500',harga_beli ='2362500' WHERE kode_barcode='00026926' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4219500',harga_beli ='4219500' WHERE kode_barcode='00026927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7310000',harga_beli ='7310000' WHERE kode_barcode='00026952' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4086000',harga_beli ='4086000' WHERE kode_barcode='00027033' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8186500',harga_beli ='8186500' WHERE kode_barcode='00027034' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4279000',harga_beli ='4279000' WHERE kode_barcode='00027038' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3967000',harga_beli ='3967000' WHERE kode_barcode='00027050' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3803500',harga_beli ='3803500' WHERE kode_barcode='00027104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2645000',harga_beli ='2645000' WHERE kode_barcode='00027149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='12896000',harga_beli ='12896000' WHERE kode_barcode='00027177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3462000',harga_beli ='3462000' WHERE kode_barcode='00027229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4606000',harga_beli ='4606000' WHERE kode_barcode='00027333' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3907500',harga_beli ='3907500' WHERE kode_barcode='00027334' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3337500',harga_beli ='3337500' WHERE kode_barcode='00027480' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='9687000',harga_beli ='9687000' WHERE kode_barcode='00027482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4011500',harga_beli ='4011500' WHERE kode_barcode='00027619' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4923000',harga_beli ='4923000' WHERE kode_barcode='00027620' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6047500',harga_beli ='6047500' WHERE kode_barcode='00027730' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4903000',harga_beli ='4903000' WHERE kode_barcode='00027759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1575000',harga_beli ='1575000' WHERE kode_barcode='00027795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4635500',harga_beli ='4635500' WHERE kode_barcode='00027901' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6106500',harga_beli ='6106500' WHERE kode_barcode='00027945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4941500',harga_beli ='4941500' WHERE kode_barcode='00028046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6240000',harga_beli ='6240000' WHERE kode_barcode='00028061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3714500',harga_beli ='3714500' WHERE kode_barcode='00028107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8974000',harga_beli ='8974000' WHERE kode_barcode='00028220' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8868500',harga_beli ='8868500' WHERE kode_barcode='00028368' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6047500',harga_beli ='6047500' WHERE kode_barcode='00028381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8112000',harga_beli ='8112000' WHERE kode_barcode='00028442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2692000',harga_beli ='2692000' WHERE kode_barcode='00028566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5824000',harga_beli ='5824000' WHERE kode_barcode='00028582' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4918000',harga_beli ='4918000' WHERE kode_barcode='00028682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4115500',harga_beli ='4115500' WHERE kode_barcode='00028692' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6951000',harga_beli ='6951000' WHERE kode_barcode='00028772' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3833500',harga_beli ='3833500' WHERE kode_barcode='00029136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3245000',harga_beli ='3245000' WHERE kode_barcode='00029506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7518000',harga_beli ='7518000' WHERE kode_barcode='00029526' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4056500',harga_beli ='4056500' WHERE kode_barcode='00029662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='9661500',harga_beli ='9661500' WHERE kode_barcode='00030349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3551000',harga_beli ='3551000' WHERE kode_barcode='00030671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5457500',harga_beli ='5457500' WHERE kode_barcode='00030672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4609500',harga_beli ='4609500' WHERE kode_barcode='00030674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2729000',harga_beli ='2729000' WHERE kode_barcode='00030709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2802500',harga_beli ='2802500' WHERE kode_barcode='00030711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2766000',harga_beli ='2766000' WHERE kode_barcode='00030712' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2710500',harga_beli ='2710500' WHERE kode_barcode='00030714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3319000',harga_beli ='3319000' WHERE kode_barcode='00030716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3227000',harga_beli ='3227000' WHERE kode_barcode='00030719' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3005500',harga_beli ='3005500' WHERE kode_barcode='00030721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4738500',harga_beli ='4738500' WHERE kode_barcode='00030821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3491500',harga_beli ='3491500' WHERE kode_barcode='00030827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1560500',harga_beli ='1560500' WHERE kode_barcode='00031061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1545500',harga_beli ='1545500' WHERE kode_barcode='00031062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1486000',harga_beli ='1486000' WHERE kode_barcode='00031064' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2481500',harga_beli ='2481500' WHERE kode_barcode='00031066' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3729500',harga_beli ='3729500' WHERE kode_barcode='00031068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2986500',harga_beli ='2986500' WHERE kode_barcode='00031069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2734000',harga_beli ='2734000' WHERE kode_barcode='00031070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2704000',harga_beli ='2704000' WHERE kode_barcode='00031071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='12302000',harga_beli ='12302000' WHERE kode_barcode='00031073' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2286500',harga_beli ='2286500' WHERE kode_barcode='00031074' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4472000',harga_beli ='4472000' WHERE kode_barcode='00031112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6255000',harga_beli ='6255000' WHERE kode_barcode='00031113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4725000',harga_beli ='4725000' WHERE kode_barcode='00031114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2645000',harga_beli ='2645000' WHERE kode_barcode='00031115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2377500',harga_beli ='2377500' WHERE kode_barcode='00031116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6471500',harga_beli ='6471500' WHERE kode_barcode='00031117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='15986500',harga_beli ='15986500' WHERE kode_barcode='00031126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='14783000',harga_beli ='14783000' WHERE kode_barcode='00031175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5141000',harga_beli ='5141000' WHERE kode_barcode='00031182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5715500',harga_beli ='5715500' WHERE kode_barcode='00031184' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2942000',harga_beli ='2942000' WHERE kode_barcode='00031185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5070500',harga_beli ='5070500' WHERE kode_barcode='00031187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='9274000',harga_beli ='9274000' WHERE kode_barcode='00031190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4370000',harga_beli ='4370000' WHERE kode_barcode='00031191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='25627500',harga_beli ='25627500' WHERE kode_barcode='00031203' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='13551500',harga_beli ='13551500' WHERE kode_barcode='00031204' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4487000',harga_beli ='4487000' WHERE kode_barcode='00031267' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3863000',harga_beli ='3863000' WHERE kode_barcode='00031268' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5839000',harga_beli ='5839000' WHERE kode_barcode='00031269' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5720000',harga_beli ='5720000' WHERE kode_barcode='00031270' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3387500',harga_beli ='3387500' WHERE kode_barcode='00031272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3907500',harga_beli ='3907500' WHERE kode_barcode='00031274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4175000',harga_beli ='4175000' WHERE kode_barcode='00031276' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5096000',harga_beli ='5096000' WHERE kode_barcode='00031277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3818500',harga_beli ='3818500' WHERE kode_barcode='00031278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3863000',harga_beli ='3863000' WHERE kode_barcode='00031279' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3610500',harga_beli ='3610500' WHERE kode_barcode='00031280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4903000',harga_beli ='4903000' WHERE kode_barcode='00031282' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4829000',harga_beli ='4829000' WHERE kode_barcode='00031283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5111000',harga_beli ='5111000' WHERE kode_barcode='00031284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3477000',harga_beli ='3477000' WHERE kode_barcode='00031285' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2422000',harga_beli ='2422000' WHERE kode_barcode='00031286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2674500',harga_beli ='2674500' WHERE kode_barcode='00031287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4918000',harga_beli ='4918000' WHERE kode_barcode='00031332' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4918000',harga_beli ='4918000' WHERE kode_barcode='00031333' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5527000',harga_beli ='5527000' WHERE kode_barcode='00031335' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2942000',harga_beli ='2942000' WHERE kode_barcode='00031337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4413000',harga_beli ='4413000' WHERE kode_barcode='00031382' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4071000',harga_beli ='4071000' WHERE kode_barcode='00031383' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3150000',harga_beli ='3150000' WHERE kode_barcode='00031385' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3135000',harga_beli ='3135000' WHERE kode_barcode='00031386' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2080500',harga_beli ='2080500' WHERE kode_barcode='00031387' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5200000',harga_beli ='5200000' WHERE kode_barcode='00031390' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3774000',harga_beli ='3774000' WHERE kode_barcode='00031391' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2437000',harga_beli ='2437000' WHERE kode_barcode='00031392' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3907500',harga_beli ='3907500' WHERE kode_barcode='00031393' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3729500',harga_beli ='3729500' WHERE kode_barcode='00031394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5393500',harga_beli ='5393500' WHERE kode_barcode='00031396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4472000',harga_beli ='4472000' WHERE kode_barcode='00031397' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4933000',harga_beli ='4933000' WHERE kode_barcode='00031399' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5467500',harga_beli ='5467500' WHERE kode_barcode='00031400' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6329500',harga_beli ='6329500' WHERE kode_barcode='00031401' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4843500',harga_beli ='4843500' WHERE kode_barcode='00031402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3551000',harga_beli ='3551000' WHERE kode_barcode='00031404' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3907500',harga_beli ='3907500' WHERE kode_barcode='00031406' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3893000',harga_beli ='3893000' WHERE kode_barcode='00031407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3224000',harga_beli ='3224000' WHERE kode_barcode='00031408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4947500',harga_beli ='4947500' WHERE kode_barcode='00031409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4531500',harga_beli ='4531500' WHERE kode_barcode='00031410' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5527000',harga_beli ='5527000' WHERE kode_barcode='00031411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4026500',harga_beli ='4026500' WHERE kode_barcode='00031413' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2659500',harga_beli ='2659500' WHERE kode_barcode='00031414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5824000',harga_beli ='5824000' WHERE kode_barcode='00031415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3982000',harga_beli ='3982000' WHERE kode_barcode='00031416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3952000',harga_beli ='3952000' WHERE kode_barcode='00031453' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5839000',harga_beli ='5839000' WHERE kode_barcode='00031454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4427500',harga_beli ='4427500' WHERE kode_barcode='00031455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6121500',harga_beli ='6121500' WHERE kode_barcode='00031457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6745500',harga_beli ='6745500' WHERE kode_barcode='00031459' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5319000',harga_beli ='5319000' WHERE kode_barcode='00031461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2021000',harga_beli ='2021000' WHERE kode_barcode='00031477' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6453000',harga_beli ='6453000' WHERE kode_barcode='00031492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5144000',harga_beli ='5144000' WHERE kode_barcode='00031493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4145500',harga_beli ='4145500' WHERE kode_barcode='00031494' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3269000',harga_beli ='3269000' WHERE kode_barcode='00031495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3729500',harga_beli ='3729500' WHERE kode_barcode='00031496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5051500',harga_beli ='5051500' WHERE kode_barcode='00031498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4888000',harga_beli ='4888000' WHERE kode_barcode='00031502' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6077000',harga_beli ='6077000' WHERE kode_barcode='00031503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4873500',harga_beli ='4873500' WHERE kode_barcode='00031504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3685000',harga_beli ='3685000' WHERE kode_barcode='00031514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5467500',harga_beli ='5467500' WHERE kode_barcode='00031515' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4812500',harga_beli ='4812500' WHERE kode_barcode='00031516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3282000',harga_beli ='3282000' WHERE kode_barcode='00031517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1291000',harga_beli ='1291000' WHERE kode_barcode='00031518' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5218000',harga_beli ='5218000' WHERE kode_barcode='00031521' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4572500',harga_beli ='4572500' WHERE kode_barcode='00031522' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6932500',harga_beli ='6932500' WHERE kode_barcode='00031523' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2229000',harga_beli ='2229000' WHERE kode_barcode='00031533' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2214000',harga_beli ='2214000' WHERE kode_barcode='00031534' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='10970500',harga_beli ='10970500' WHERE kode_barcode='00031558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3632500',harga_beli ='3632500' WHERE kode_barcode='00031563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1291000',harga_beli ='1291000' WHERE kode_barcode='00031564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4701500',harga_beli ='4701500' WHERE kode_barcode='00031565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4075000',harga_beli ='4075000' WHERE kode_barcode='00031566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3061000',harga_beli ='3061000' WHERE kode_barcode='00031568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4725000',harga_beli ='4725000' WHERE kode_barcode='00031584' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2882500',harga_beli ='2882500' WHERE kode_barcode='00031585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5568000',harga_beli ='5568000' WHERE kode_barcode='00031588' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2466500',harga_beli ='2466500' WHERE kode_barcode='00031590' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3046000',harga_beli ='3046000' WHERE kode_barcode='00031591' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4635500',harga_beli ='4635500' WHERE kode_barcode='00031595' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2655000',harga_beli ='2655000' WHERE kode_barcode='00031599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2434000',harga_beli ='2434000' WHERE kode_barcode='00031600' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7615000',harga_beli ='7615000' WHERE kode_barcode='00031613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6849500',harga_beli ='6849500' WHERE kode_barcode='00031616' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1709000',harga_beli ='1709000' WHERE kode_barcode='00031618' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4056500',harga_beli ='4056500' WHERE kode_barcode='00031619' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2719000',harga_beli ='2719000' WHERE kode_barcode='00031624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2763500',harga_beli ='2763500' WHERE kode_barcode='00031633' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2823000',harga_beli ='2823000' WHERE kode_barcode='00031634' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='12980000',harga_beli ='12980000' WHERE kode_barcode='00031636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2231000',harga_beli ='2231000' WHERE kode_barcode='00031637' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3803500',harga_beli ='3803500' WHERE kode_barcode='00031658' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5752500',harga_beli ='5752500' WHERE kode_barcode='00031747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1471000',harga_beli ='1471000' WHERE kode_barcode='00031749' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4769500',harga_beli ='4769500' WHERE kode_barcode='00031754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='12406000',harga_beli ='12406000' WHERE kode_barcode='00031755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2496500',harga_beli ='2496500' WHERE kode_barcode='00031756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1327500',harga_beli ='1327500' WHERE kode_barcode='00031757' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5089000',harga_beli ='5089000' WHERE kode_barcode='00031818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4130500',harga_beli ='4130500' WHERE kode_barcode='00031819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4296000',harga_beli ='4296000' WHERE kode_barcode='00031820' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6453000',harga_beli ='6453000' WHERE kode_barcode='00031821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2347500',harga_beli ='2347500' WHERE kode_barcode='00031823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5863000',harga_beli ='5863000' WHERE kode_barcode='00031824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5200000',harga_beli ='5200000' WHERE kode_barcode='00031825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2882500',harga_beli ='2882500' WHERE kode_barcode='00031826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1881000',harga_beli ='1881000' WHERE kode_barcode='00031829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2808000',harga_beli ='2808000' WHERE kode_barcode='00031855' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3179500',harga_beli ='3179500' WHERE kode_barcode='00031856' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4831000',harga_beli ='4831000' WHERE kode_barcode='00031857' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7541000',harga_beli ='7541000' WHERE kode_barcode='00031895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5482500',harga_beli ='5482500' WHERE kode_barcode='00031896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5304000',harga_beli ='5304000' WHERE kode_barcode='00031897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4517000',harga_beli ='4517000' WHERE kode_barcode='00031905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5051500',harga_beli ='5051500' WHERE kode_barcode='00031911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3298500',harga_beli ='3298500' WHERE kode_barcode='00031913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='15927000',harga_beli ='15927000' WHERE kode_barcode='00031914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2303000',harga_beli ='2303000' WHERE kode_barcode='00031968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='12658500',harga_beli ='12658500' WHERE kode_barcode='00031969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3417500',harga_beli ='3417500' WHERE kode_barcode='00032093' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4843500',harga_beli ='4843500' WHERE kode_barcode='00032094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6909000',harga_beli ='6909000' WHERE kode_barcode='00032182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1382000',harga_beli ='1382000' WHERE kode_barcode='00032197' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1961500',harga_beli ='1961500' WHERE kode_barcode='00032198' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1872500',harga_beli ='1872500' WHERE kode_barcode='00032209' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1530500',harga_beli ='1530500' WHERE kode_barcode='00032211' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2763500',harga_beli ='2763500' WHERE kode_barcode='00032213' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1605000',harga_beli ='1605000' WHERE kode_barcode='00032215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='18348500',harga_beli ='18348500' WHERE kode_barcode='00032356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='12584000',harga_beli ='12584000' WHERE kode_barcode='00032357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1976500',harga_beli ='1976500' WHERE kode_barcode='00032358' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3670000',harga_beli ='3670000' WHERE kode_barcode='00032360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2659500',harga_beli ='2659500' WHERE kode_barcode='00032361' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3269000',harga_beli ='3269000' WHERE kode_barcode='00032362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3343000',harga_beli ='3343000' WHERE kode_barcode='00032364' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1560500',harga_beli ='1560500' WHERE kode_barcode='00032365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4546500',harga_beli ='4546500' WHERE kode_barcode='00032370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1709000',harga_beli ='1709000' WHERE kode_barcode='00032371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2273500',harga_beli ='2273500' WHERE kode_barcode='00032372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4115500',harga_beli ='4115500' WHERE kode_barcode='00032373' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='12212500',harga_beli ='12212500' WHERE kode_barcode='00032375' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2858000',harga_beli ='2858000' WHERE kode_barcode='00032376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1649500',harga_beli ='1649500' WHERE kode_barcode='00032377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2511000',harga_beli ='2511000' WHERE kode_barcode='00032379' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7384000',harga_beli ='7384000' WHERE kode_barcode='00032381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2258500',harga_beli ='2258500' WHERE kode_barcode='00032479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4992000',harga_beli ='4992000' WHERE kode_barcode='00032498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5883500',harga_beli ='5883500' WHERE kode_barcode='00032499' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8439000',harga_beli ='8439000' WHERE kode_barcode='00032501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4536000',harga_beli ='4536000' WHERE kode_barcode='00032504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='10306500',harga_beli ='10306500' WHERE kode_barcode='00032505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4720000',harga_beli ='4720000' WHERE kode_barcode='00032507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5752500',harga_beli ='5752500' WHERE kode_barcode='00032509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5347000',harga_beli ='5347000' WHERE kode_barcode='00032513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3269000',harga_beli ='3269000' WHERE kode_barcode='00032522' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='21958500',harga_beli ='21958500' WHERE kode_barcode='00032523' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3373000',harga_beli ='3373000' WHERE kode_barcode='00032602' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2704000',harga_beli ='2704000' WHERE kode_barcode='00032648' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8543000',harga_beli ='8543000' WHERE kode_barcode='00032649' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5789500',harga_beli ='5789500' WHERE kode_barcode='00032667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1530500',harga_beli ='1530500' WHERE kode_barcode='00032668' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7057500',harga_beli ='7057500' WHERE kode_barcode='00032670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='12021000',harga_beli ='12021000' WHERE kode_barcode='00033184' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4992000',harga_beli ='4992000' WHERE kode_barcode='00033220' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4101000',harga_beli ='4101000' WHERE kode_barcode='00033261' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1931500',harga_beli ='1931500' WHERE kode_barcode='00033262' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1976500',harga_beli ='1976500' WHERE kode_barcode='00033263' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1813000',harga_beli ='1813000' WHERE kode_barcode='00033264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5752500',harga_beli ='5752500' WHERE kode_barcode='00033289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1649500',harga_beli ='1649500' WHERE kode_barcode='00033347' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='16283500',harga_beli ='16283500' WHERE kode_barcode='00033485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3714500',harga_beli ='3714500' WHERE kode_barcode='00033537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2927000',harga_beli ='2927000' WHERE kode_barcode='00034068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2645000',harga_beli ='2645000' WHERE kode_barcode='00034069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3581000',harga_beli ='3581000' WHERE kode_barcode='00034070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3417500',harga_beli ='3417500' WHERE kode_barcode='00034071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2422000',harga_beli ='2422000' WHERE kode_barcode='00034073' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2541000',harga_beli ='2541000' WHERE kode_barcode='00034075' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1382000',harga_beli ='1382000' WHERE kode_barcode='00034076' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2645000',harga_beli ='2645000' WHERE kode_barcode='00034080' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3789000',harga_beli ='3789000' WHERE kode_barcode='00034142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5467500',harga_beli ='5467500' WHERE kode_barcode='00034164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2882500',harga_beli ='2882500' WHERE kode_barcode='00034166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2823000',harga_beli ='2823000' WHERE kode_barcode='00034167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='17249500',harga_beli ='17249500' WHERE kode_barcode='00034249' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='11283500',harga_beli ='11283500' WHERE kode_barcode='00034319' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2229000',harga_beli ='2229000' WHERE kode_barcode='00034338' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2823000',harga_beli ='2823000' WHERE kode_barcode='00034340' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2229000',harga_beli ='2229000' WHERE kode_barcode='00034343' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3967000',harga_beli ='3967000' WHERE kode_barcode='00034347' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2333000',harga_beli ='2333000' WHERE kode_barcode='00034348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4041500',harga_beli ='4041500' WHERE kode_barcode='00034349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1694000',harga_beli ='1694000' WHERE kode_barcode='00034350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1634500',harga_beli ='1634500' WHERE kode_barcode='00034351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6136000',harga_beli ='6136000' WHERE kode_barcode='00034354' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2288500',harga_beli ='2288500' WHERE kode_barcode='00034355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3759000',harga_beli ='3759000' WHERE kode_barcode='00034356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3328000',harga_beli ='3328000' WHERE kode_barcode='00034357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2021000',harga_beli ='2021000' WHERE kode_barcode='00034365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1649500',harga_beli ='1649500' WHERE kode_barcode='00034368' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1515500',harga_beli ='1515500' WHERE kode_barcode='00034369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1649500',harga_beli ='1649500' WHERE kode_barcode='00034370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1753500',harga_beli ='1753500' WHERE kode_barcode='00034371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3224000',harga_beli ='3224000' WHERE kode_barcode='00034372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2347500',harga_beli ='2347500' WHERE kode_barcode='00034373' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2318000',harga_beli ='2318000' WHERE kode_barcode='00034374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6923500',harga_beli ='6923500' WHERE kode_barcode='00034381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8959000',harga_beli ='8959000' WHERE kode_barcode='00034490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3208500',harga_beli ='3208500' WHERE kode_barcode='00034661' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4499000',harga_beli ='4499000' WHERE kode_barcode='00034679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1501000',harga_beli ='1501000' WHERE kode_barcode='00034780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1768500',harga_beli ='1768500' WHERE kode_barcode='00034781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2932000',harga_beli ='2932000' WHERE kode_barcode='00035018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2065500',harga_beli ='2065500' WHERE kode_barcode='00035045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5527000',harga_beli ='5527000' WHERE kode_barcode='00035046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2689500',harga_beli ='2689500' WHERE kode_barcode='00035171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8171500',harga_beli ='8171500' WHERE kode_barcode='00035278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7206000',harga_beli ='7206000' WHERE kode_barcode='00035281' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4457500',harga_beli ='4457500' WHERE kode_barcode='00035477' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3283500',harga_beli ='3283500' WHERE kode_barcode='00035519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='11707500',harga_beli ='11707500' WHERE kode_barcode='00035544' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='847000',harga_beli ='847000' WHERE kode_barcode='00035951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='862000',harga_beli ='862000' WHERE kode_barcode='00036006' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7817500',harga_beli ='7817500' WHERE kode_barcode='00036172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='683500',harga_beli ='683500' WHERE kode_barcode='00036243' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='669000',harga_beli ='669000' WHERE kode_barcode='00036244' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='624500',harga_beli ='624500' WHERE kode_barcode='00036245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1486000',harga_beli ='1486000' WHERE kode_barcode='00036432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2169500',harga_beli ='2169500' WHERE kode_barcode='00036433' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2377500',harga_beli ='2377500' WHERE kode_barcode='00036686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3417500',harga_beli ='3417500' WHERE kode_barcode='00036809' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3818500',harga_beli ='3818500' WHERE kode_barcode='00036823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4502000',harga_beli ='4502000' WHERE kode_barcode='00036824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3506500',harga_beli ='3506500' WHERE kode_barcode='00036825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3833500',harga_beli ='3833500' WHERE kode_barcode='00036826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3417500',harga_beli ='3417500' WHERE kode_barcode='00036827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1931500',harga_beli ='1931500' WHERE kode_barcode='00036828' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3417500',harga_beli ='3417500' WHERE kode_barcode='00036830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3417500',harga_beli ='3417500' WHERE kode_barcode='00036831' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3165000',harga_beli ='3165000' WHERE kode_barcode='00036832' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1604500',harga_beli ='1604500' WHERE kode_barcode='00036947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3373000',harga_beli ='3373000' WHERE kode_barcode='00036992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1486000',harga_beli ='1486000' WHERE kode_barcode='00036993' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='669000',harga_beli ='669000' WHERE kode_barcode='00036994' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='15174000',harga_beli ='15174000' WHERE kode_barcode='00037054' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3105500',harga_beli ='3105500' WHERE kode_barcode='00037325' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4472000',harga_beli ='4472000' WHERE kode_barcode='00037332' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4858500',harga_beli ='4858500' WHERE kode_barcode='00037825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2659500',harga_beli ='2659500' WHERE kode_barcode='00037907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3134500',harga_beli ='3134500' WHERE kode_barcode='00038024' LIMIT 1;
UPDATE tm_barang_titip SET harga_skrg ='1790000',harga_jual='3343000',harga_beli ='3343000' WHERE kode_barcode='00021123' LIMIT 1;
UPDATE tm_barang_titip SET harga_skrg ='1790000',harga_jual='7838000',harga_beli ='7838000' WHERE kode_barcode='00023133' LIMIT 1;
UPDATE tm_barang_titip SET harga_skrg ='1790000',harga_jual='4011500',harga_beli ='4011500' WHERE kode_barcode='00027940' LIMIT 1;
UPDATE tm_group SET harga='1790000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','1790000','kasir','2025-08-29 13:21:53');
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1719500',harga_beli ='1719500' WHERE kode_barcode='00019918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1735000',harga_beli ='1735000' WHERE kode_barcode='00019926' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1826000',harga_beli ='1826000' WHERE kode_barcode='00019929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1826000',harga_beli ='1826000' WHERE kode_barcode='00019933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2763500',harga_beli ='2763500' WHERE kode_barcode='00023343' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5584000',harga_beli ='5584000' WHERE kode_barcode='00024887' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5721000',harga_beli ='5721000' WHERE kode_barcode='00024889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4641000',harga_beli ='4641000' WHERE kode_barcode='00024890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4610500',harga_beli ='4610500' WHERE kode_barcode='00024891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4610500',harga_beli ='4610500' WHERE kode_barcode='00024892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4595000',harga_beli ='4595000' WHERE kode_barcode='00024893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4595000',harga_beli ='4595000' WHERE kode_barcode='00024895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4625500',harga_beli ='4625500' WHERE kode_barcode='00024896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4610500',harga_beli ='4610500' WHERE kode_barcode='00024897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4549500',harga_beli ='4549500' WHERE kode_barcode='00024898' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4564500',harga_beli ='4564500' WHERE kode_barcode='00024899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4625500',harga_beli ='4625500' WHERE kode_barcode='00024900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4610500',harga_beli ='4610500' WHERE kode_barcode='00024901' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4610500',harga_beli ='4610500' WHERE kode_barcode='00024902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4580000',harga_beli ='4580000' WHERE kode_barcode='00024903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4595000',harga_beli ='4595000' WHERE kode_barcode='00024904' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4595000',harga_beli ='4595000' WHERE kode_barcode='00024905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3256500',harga_beli ='3256500' WHERE kode_barcode='00024909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3347500',harga_beli ='3347500' WHERE kode_barcode='00024912' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3271500',harga_beli ='3271500' WHERE kode_barcode='00024919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3271500',harga_beli ='3271500' WHERE kode_barcode='00024920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3317000',harga_beli ='3317000' WHERE kode_barcode='00024922' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3256500',harga_beli ='3256500' WHERE kode_barcode='00024923' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='13275000',harga_beli ='13275000' WHERE kode_barcode='00025675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='13862000',harga_beli ='13862000' WHERE kode_barcode='00025676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='14274500',harga_beli ='14274500' WHERE kode_barcode='00025677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='12235500',harga_beli ='12235500' WHERE kode_barcode='00025678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='12402500',harga_beli ='12402500' WHERE kode_barcode='00025679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='21306500',harga_beli ='21306500' WHERE kode_barcode='00025682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='13194500',harga_beli ='13194500' WHERE kode_barcode='00025683' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='15565000',harga_beli ='15565000' WHERE kode_barcode='00025684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6858000',harga_beli ='6858000' WHERE kode_barcode='00025687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='13008500',harga_beli ='13008500' WHERE kode_barcode='00025697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5017500',harga_beli ='5017500' WHERE kode_barcode='00025699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8568500',harga_beli ='8568500' WHERE kode_barcode='00025701' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8552000',harga_beli ='8552000' WHERE kode_barcode='00025702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2851000',harga_beli ='2851000' WHERE kode_barcode='00025706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3160500',harga_beli ='3160500' WHERE kode_barcode='00025711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3372000',harga_beli ='3372000' WHERE kode_barcode='00025714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='10034500',harga_beli ='10034500' WHERE kode_barcode='00025716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5050000',harga_beli ='5050000' WHERE kode_barcode='00025717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3649000',harga_beli ='3649000' WHERE kode_barcode='00025718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4528500',harga_beli ='4528500' WHERE kode_barcode='00025723' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2997500',harga_beli ='2997500' WHERE kode_barcode='00025724' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1205500',harga_beli ='1205500' WHERE kode_barcode='00025726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1189500',harga_beli ='1189500' WHERE kode_barcode='00025727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3878000',harga_beli ='3878000' WHERE kode_barcode='00025730' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2772500',harga_beli ='2772500' WHERE kode_barcode='00025734' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5108000',harga_beli ='5108000' WHERE kode_barcode='00025735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2694500',harga_beli ='2694500' WHERE kode_barcode='00025737' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1620000',harga_beli ='1620000' WHERE kode_barcode='00025739' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7824500',harga_beli ='7824500' WHERE kode_barcode='00025740' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3909000',harga_beli ='3909000' WHERE kode_barcode='00025742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4734500',harga_beli ='4734500' WHERE kode_barcode='00025743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3940000',harga_beli ='3940000' WHERE kode_barcode='00025744' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2056000',harga_beli ='2056000' WHERE kode_barcode='00025745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='14881500',harga_beli ='14881500' WHERE kode_barcode='00025747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='37531000',harga_beli ='37531000' WHERE kode_barcode='00025795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='16642000',harga_beli ='16642000' WHERE kode_barcode='00025796' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='34698500',harga_beli ='34698500' WHERE kode_barcode='00025797' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='12426500',harga_beli ='12426500' WHERE kode_barcode='00025798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='15199000',harga_beli ='15199000' WHERE kode_barcode='00025799' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='12108000',harga_beli ='12108000' WHERE kode_barcode='00025800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4519000',harga_beli ='4519000' WHERE kode_barcode='00025877' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4397500',harga_beli ='4397500' WHERE kode_barcode='00025880' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3256500',harga_beli ='3256500' WHERE kode_barcode='00025882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3819000',harga_beli ='3819000' WHERE kode_barcode='00025883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4049500',harga_beli ='4049500' WHERE kode_barcode='00025888' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='21382000',harga_beli ='21382000' WHERE kode_barcode='00025892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='9631500',harga_beli ='9631500' WHERE kode_barcode='00025893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7729500',harga_beli ='7729500' WHERE kode_barcode='00025894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='9814000',harga_beli ='9814000' WHERE kode_barcode='00025896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3670000',harga_beli ='3670000' WHERE kode_barcode='00026055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3417500',harga_beli ='3417500' WHERE kode_barcode='00026056' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2555500',harga_beli ='2555500' WHERE kode_barcode='00026058' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3343000',harga_beli ='3343000' WHERE kode_barcode='00026059' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2897500',harga_beli ='2897500' WHERE kode_barcode='00026060' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4321500',harga_beli ='4321500' WHERE kode_barcode='00026061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3013000',harga_beli ='3013000' WHERE kode_barcode='00026062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2891000',harga_beli ='2891000' WHERE kode_barcode='00026064' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2860500',harga_beli ='2860500' WHERE kode_barcode='00026065' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2267500',harga_beli ='2267500' WHERE kode_barcode='00026070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2252000',harga_beli ='2252000' WHERE kode_barcode='00026071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3925500',harga_beli ='3925500' WHERE kode_barcode='00026072' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5949500',harga_beli ='5949500' WHERE kode_barcode='00026078' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='9083500',harga_beli ='9083500' WHERE kode_barcode='00026079' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3180000',harga_beli ='3180000' WHERE kode_barcode='00026080' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1765000',harga_beli ='1765000' WHERE kode_barcode='00026081' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3819000',harga_beli ='3819000' WHERE kode_barcode='00026082' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2897000',harga_beli ='2897000' WHERE kode_barcode='00026085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='11944000',harga_beli ='11944000' WHERE kode_barcode='00026086' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='10772500',harga_beli ='10772500' WHERE kode_barcode='00026087' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='43348000',harga_beli ='43348000' WHERE kode_barcode='00026090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='45432500',harga_beli ='45432500' WHERE kode_barcode='00026091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8673000',harga_beli ='8673000' WHERE kode_barcode='00026093' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='16676000',harga_beli ='16676000' WHERE kode_barcode='00026095' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='13617500',harga_beli ='13617500' WHERE kode_barcode='00026096' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='9540000',harga_beli ='9540000' WHERE kode_barcode='00026097' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3804000',harga_beli ='3804000' WHERE kode_barcode='00026099' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4580000',harga_beli ='4580000' WHERE kode_barcode='00026101' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2842500',harga_beli ='2842500' WHERE kode_barcode='00026104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4256500',harga_beli ='4256500' WHERE kode_barcode='00026105' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2842500',harga_beli ='2842500' WHERE kode_barcode='00026106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2927500',harga_beli ='2927500' WHERE kode_barcode='00026107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3813000',harga_beli ='3813000' WHERE kode_barcode='00026108' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2814500',harga_beli ='2814500' WHERE kode_barcode='00026109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2618500',harga_beli ='2618500' WHERE kode_barcode='00026110' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2857000',harga_beli ='2857000' WHERE kode_barcode='00026111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3749500',harga_beli ='3749500' WHERE kode_barcode='00026112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4299000',harga_beli ='4299000' WHERE kode_barcode='00026113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4214500',harga_beli ='4214500' WHERE kode_barcode='00026114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2828500',harga_beli ='2828500' WHERE kode_barcode='00026115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3114000',harga_beli ='3114000' WHERE kode_barcode='00026117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3155500',harga_beli ='3155500' WHERE kode_barcode='00026118' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2485500',harga_beli ='2485500' WHERE kode_barcode='00026119' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2122500',harga_beli ='2122500' WHERE kode_barcode='00026120' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2136500',harga_beli ='2136500' WHERE kode_barcode='00026121' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='38882500',harga_beli ='38882500' WHERE kode_barcode='00026125' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6081000',harga_beli ='6081000' WHERE kode_barcode='00026126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4929000',harga_beli ='4929000' WHERE kode_barcode='00026127' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5683000',harga_beli ='5683000' WHERE kode_barcode='00026132' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7399000',harga_beli ='7399000' WHERE kode_barcode='00026140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4033500',harga_beli ='4033500' WHERE kode_barcode='00026141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4049500',harga_beli ='4049500' WHERE kode_barcode='00026142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3134500',harga_beli ='3134500' WHERE kode_barcode='00026145' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1948000',harga_beli ='1948000' WHERE kode_barcode='00026146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4049500',harga_beli ='4049500' WHERE kode_barcode='00026147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7518000',harga_beli ='7518000' WHERE kode_barcode='00026152' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4901000',harga_beli ='4901000' WHERE kode_barcode='00026154' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='10169500',harga_beli ='10169500' WHERE kode_barcode='00026469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5544500',harga_beli ='5544500' WHERE kode_barcode='00026471' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2694500',harga_beli ='2694500' WHERE kode_barcode='00026472' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2943500',harga_beli ='2943500' WHERE kode_barcode='00026475' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='19731500',harga_beli ='19731500' WHERE kode_barcode='00026480' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='20821500',harga_beli ='20821500' WHERE kode_barcode='00026481' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7226000',harga_beli ='7226000' WHERE kode_barcode='00026484' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3052500',harga_beli ='3052500' WHERE kode_barcode='00026485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3239500',harga_beli ='3239500' WHERE kode_barcode='00026486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3208500',harga_beli ='3208500' WHERE kode_barcode='00026487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4750000',harga_beli ='4750000' WHERE kode_barcode='00026525' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5575500',harga_beli ='5575500' WHERE kode_barcode='00026526' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2694500',harga_beli ='2694500' WHERE kode_barcode='00026527' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3146000',harga_beli ='3146000' WHERE kode_barcode='00026529' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2663500',harga_beli ='2663500' WHERE kode_barcode='00026534' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='10356500',harga_beli ='10356500' WHERE kode_barcode='00026537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6977000',harga_beli ='6977000' WHERE kode_barcode='00026538' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='11773500',harga_beli ='11773500' WHERE kode_barcode='00026553' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7288500',harga_beli ='7288500' WHERE kode_barcode='00026557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6183000',harga_beli ='6183000' WHERE kode_barcode='00026558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='11275000',harga_beli ='11275000' WHERE kode_barcode='00026560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3146000',harga_beli ='3146000' WHERE kode_barcode='00026561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3177000',harga_beli ='3177000' WHERE kode_barcode='00026563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6208000',harga_beli ='6208000' WHERE kode_barcode='00026653' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1704500',harga_beli ='1704500' WHERE kode_barcode='00026654' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2541000',harga_beli ='2541000' WHERE kode_barcode='00026655' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2617500',harga_beli ='2617500' WHERE kode_barcode='00026656' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3013000',harga_beli ='3013000' WHERE kode_barcode='00026658' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1735000',harga_beli ='1735000' WHERE kode_barcode='00026659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3545500',harga_beli ='3545500' WHERE kode_barcode='00026660' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1993500',harga_beli ='1993500' WHERE kode_barcode='00026661' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2495500',harga_beli ='2495500' WHERE kode_barcode='00026662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3286500',harga_beli ='3286500' WHERE kode_barcode='00026665' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3895500',harga_beli ='3895500' WHERE kode_barcode='00026666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3150000',harga_beli ='3150000' WHERE kode_barcode='00026668' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3462000',harga_beli ='3462000' WHERE kode_barcode='00026669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7191000',harga_beli ='7191000' WHERE kode_barcode='00026671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2986500',harga_beli ='2986500' WHERE kode_barcode='00026672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2749000',harga_beli ='2749000' WHERE kode_barcode='00026677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4323500',harga_beli ='4323500' WHERE kode_barcode='00026678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3956000',harga_beli ='3956000' WHERE kode_barcode='00026679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2100000',harga_beli ='2100000' WHERE kode_barcode='00026680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3606000',harga_beli ='3606000' WHERE kode_barcode='00026681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2526000',harga_beli ='2526000' WHERE kode_barcode='00026683' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2237000',harga_beli ='2237000' WHERE kode_barcode='00026684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2434500',harga_beli ='2434500' WHERE kode_barcode='00026686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3302000',harga_beli ='3302000' WHERE kode_barcode='00026689' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1826000',harga_beli ='1826000' WHERE kode_barcode='00026690' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3591000',harga_beli ='3591000' WHERE kode_barcode='00026691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7425000',harga_beli ='7425000' WHERE kode_barcode='00026693' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4260500',harga_beli ='4260500' WHERE kode_barcode='00026697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3347500',harga_beli ='3347500' WHERE kode_barcode='00026699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3119500',harga_beli ='3119500' WHERE kode_barcode='00026702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4017000',harga_beli ='4017000' WHERE kode_barcode='00026708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3180000',harga_beli ='3180000' WHERE kode_barcode='00026709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3606000',harga_beli ='3606000' WHERE kode_barcode='00026710' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2130500',harga_beli ='2130500' WHERE kode_barcode='00026711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3270500',harga_beli ='3270500' WHERE kode_barcode='00027627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='9515500',harga_beli ='9515500' WHERE kode_barcode='00027630' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='11758000',harga_beli ='11758000' WHERE kode_barcode='00027632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='10823500',harga_beli ='10823500' WHERE kode_barcode='00027633' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='17566500',harga_beli ='17566500' WHERE kode_barcode='00027635' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='18984000',harga_beli ='18984000' WHERE kode_barcode='00027636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='11446500',harga_beli ='11446500' WHERE kode_barcode='00027638' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7195000',harga_beli ='7195000' WHERE kode_barcode='00027643' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8207000',harga_beli ='8207000' WHERE kode_barcode='00027645' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='10901500',harga_beli ='10901500' WHERE kode_barcode='00027646' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8565500',harga_beli ='8565500' WHERE kode_barcode='00027647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5918000',harga_beli ='5918000' WHERE kode_barcode='00027649' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4828000',harga_beli ='4828000' WHERE kode_barcode='00027650' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='13704500',harga_beli ='13704500' WHERE kode_barcode='00027652' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='16741500',harga_beli ='16741500' WHERE kode_barcode='00027654' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5755500',harga_beli ='5755500' WHERE kode_barcode='00027657' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2599500',harga_beli ='2599500' WHERE kode_barcode='00027659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3781000',harga_beli ='3781000' WHERE kode_barcode='00027662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4159000',harga_beli ='4159000' WHERE kode_barcode='00027663' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4237500',harga_beli ='4237500' WHERE kode_barcode='00027664' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2986500',harga_beli ='2986500' WHERE kode_barcode='00027667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8882500',harga_beli ='8882500' WHERE kode_barcode='00027668' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4372000',harga_beli ='4372000' WHERE kode_barcode='00027669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='12100000',harga_beli ='12100000' WHERE kode_barcode='00027671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='12638500',harga_beli ='12638500' WHERE kode_barcode='00027672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6930500',harga_beli ='6930500' WHERE kode_barcode='00027678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3971500',harga_beli ='3971500' WHERE kode_barcode='00027680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='9877500',harga_beli ='9877500' WHERE kode_barcode='00027681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4062500',harga_beli ='4062500' WHERE kode_barcode='00027682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2343500',harga_beli ='2343500' WHERE kode_barcode='00027687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3043000',harga_beli ='3043000' WHERE kode_barcode='00027688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='11932500',harga_beli ='11932500' WHERE kode_barcode='00027690' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='10626500',harga_beli ='10626500' WHERE kode_barcode='00027691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='11263500',harga_beli ='11263500' WHERE kode_barcode='00027692' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='14083500',harga_beli ='14083500' WHERE kode_barcode='00027694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2803500',harga_beli ='2803500' WHERE kode_barcode='00029700' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5813000',harga_beli ='5813000' WHERE kode_barcode='00029701' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4584000',harga_beli ='4584000' WHERE kode_barcode='00029702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='10097500',harga_beli ='10097500' WHERE kode_barcode='00029703' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3954000',harga_beli ='3954000' WHERE kode_barcode='00029704' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='11704000',harga_beli ='11704000' WHERE kode_barcode='00029705' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7025500',harga_beli ='7025500' WHERE kode_barcode='00029706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7676500',harga_beli ='7676500' WHERE kode_barcode='00030416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='29837000',harga_beli ='29837000' WHERE kode_barcode='00030724' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5051500',harga_beli ='5051500' WHERE kode_barcode='00030727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4398000',harga_beli ='4398000' WHERE kode_barcode='00030730' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='20401000',harga_beli ='20401000' WHERE kode_barcode='00030732' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='10169500',harga_beli ='10169500' WHERE kode_barcode='00030733' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7563500',harga_beli ='7563500' WHERE kode_barcode='00030735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='17286500',harga_beli ='17286500' WHERE kode_barcode='00030741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8752500',harga_beli ='8752500' WHERE kode_barcode='00030742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='10652000',harga_beli ='10652000' WHERE kode_barcode='00030744' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2358500',harga_beli ='2358500' WHERE kode_barcode='00030753' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2800000',harga_beli ='2800000' WHERE kode_barcode='00030754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7408000',harga_beli ='7408000' WHERE kode_barcode='00030755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6541000',harga_beli ='6541000' WHERE kode_barcode='00030758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6899000',harga_beli ='6899000' WHERE kode_barcode='00030760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2429500',harga_beli ='2429500' WHERE kode_barcode='00030761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2492000',harga_beli ='2492000' WHERE kode_barcode='00030763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='15012500',harga_beli ='15012500' WHERE kode_barcode='00030764' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4298500',harga_beli ='4298500' WHERE kode_barcode='00030766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4080500',harga_beli ='4080500' WHERE kode_barcode='00030767' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4360500',harga_beli ='4360500' WHERE kode_barcode='00030768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4298500',harga_beli ='4298500' WHERE kode_barcode='00030769' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='16975000',harga_beli ='16975000' WHERE kode_barcode='00030773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='39727000',harga_beli ='39727000' WHERE kode_barcode='00030774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1750000',harga_beli ='1750000' WHERE kode_barcode='00030784' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3849500',harga_beli ='3849500' WHERE kode_barcode='00030785' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3423500',harga_beli ='3423500' WHERE kode_barcode='00030786' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2876000',harga_beli ='2876000' WHERE kode_barcode='00030787' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5289500',harga_beli ='5289500' WHERE kode_barcode='00031468' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5601500',harga_beli ='5601500' WHERE kode_barcode='00031469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6603500',harga_beli ='6603500' WHERE kode_barcode='00031682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2876000',harga_beli ='2876000' WHERE kode_barcode='00031684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1263000',harga_beli ='1263000' WHERE kode_barcode='00031685' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1293500',harga_beli ='1293500' WHERE kode_barcode='00031686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1385000',harga_beli ='1385000' WHERE kode_barcode='00031687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='6177500',harga_beli ='6177500' WHERE kode_barcode='00031690' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2639500',harga_beli ='2639500' WHERE kode_barcode='00032055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1224500',harga_beli ='1224500' WHERE kode_barcode='00033190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3836500',harga_beli ='3836500' WHERE kode_barcode='00033455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1441500',harga_beli ='1441500' WHERE kode_barcode='00033501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5051500',harga_beli ='5051500' WHERE kode_barcode='00033504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1605000',harga_beli ='1605000' WHERE kode_barcode='00033505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='10340500',harga_beli ='10340500' WHERE kode_barcode='00033508' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1768500',harga_beli ='1768500' WHERE kode_barcode='00033509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1738500',harga_beli ='1738500' WHERE kode_barcode='00033510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='10514000',harga_beli ='10514000' WHERE kode_barcode='00033511' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='10757500',harga_beli ='10757500' WHERE kode_barcode='00033512' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='15976000',harga_beli ='15976000' WHERE kode_barcode='00033513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='12461500',harga_beli ='12461500' WHERE kode_barcode='00033516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8916500',harga_beli ='8916500' WHERE kode_barcode='00033517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4047500',harga_beli ='4047500' WHERE kode_barcode='00033518' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1769000',harga_beli ='1769000' WHERE kode_barcode='00033881' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4368000',harga_beli ='4368000' WHERE kode_barcode='00034640' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4888000',harga_beli ='4888000' WHERE kode_barcode='00034760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5185500',harga_beli ='5185500' WHERE kode_barcode='00034761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3833500',harga_beli ='3833500' WHERE kode_barcode='00034762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3625500',harga_beli ='3625500' WHERE kode_barcode='00034763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4858500',harga_beli ='4858500' WHERE kode_barcode='00034766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3417500',harga_beli ='3417500' WHERE kode_barcode='00034768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2229000',harga_beli ='2229000' WHERE kode_barcode='00034769' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3759000',harga_beli ='3759000' WHERE kode_barcode='00034771' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3803500',harga_beli ='3803500' WHERE kode_barcode='00034776' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2912000',harga_beli ='2912000' WHERE kode_barcode='00034779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2125000',harga_beli ='2125000' WHERE kode_barcode='00035830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2282500',harga_beli ='2282500' WHERE kode_barcode='00035831' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='19690500',harga_beli ='19690500' WHERE kode_barcode='00035985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='19690500',harga_beli ='19690500' WHERE kode_barcode='00035986' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='19690500',harga_beli ='19690500' WHERE kode_barcode='00035987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='19690500',harga_beli ='19690500' WHERE kode_barcode='00035988' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4502000',harga_beli ='4502000' WHERE kode_barcode='00036170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4279000',harga_beli ='4279000' WHERE kode_barcode='00036357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2392500',harga_beli ='2392500' WHERE kode_barcode='00036358' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2229000',harga_beli ='2229000' WHERE kode_barcode='00036359' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2184500',harga_beli ='2184500' WHERE kode_barcode='00036360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3818500',harga_beli ='3818500' WHERE kode_barcode='00036412' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3714500',harga_beli ='3714500' WHERE kode_barcode='00036413' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2437000',harga_beli ='2437000' WHERE kode_barcode='00036415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2422000',harga_beli ='2422000' WHERE kode_barcode='00036416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3625500',harga_beli ='3625500' WHERE kode_barcode='00036621' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4041500',harga_beli ='4041500' WHERE kode_barcode='00036622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3506500',harga_beli ='3506500' WHERE kode_barcode='00036623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3729500',harga_beli ='3729500' WHERE kode_barcode='00036624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3462000',harga_beli ='3462000' WHERE kode_barcode='00036625' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3298500',harga_beli ='3298500' WHERE kode_barcode='00036626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4011500',harga_beli ='4011500' WHERE kode_barcode='00036627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3551000',harga_beli ='3551000' WHERE kode_barcode='00036628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3997000',harga_beli ='3997000' WHERE kode_barcode='00036629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3179500',harga_beli ='3179500' WHERE kode_barcode='00036630' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2059000',harga_beli ='2059000' WHERE kode_barcode='00036700' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2059000',harga_beli ='2059000' WHERE kode_barcode='00036701' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2059000',harga_beli ='2059000' WHERE kode_barcode='00036702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2059000',harga_beli ='2059000' WHERE kode_barcode='00036703' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2059000',harga_beli ='2059000' WHERE kode_barcode='00036704' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2059000',harga_beli ='2059000' WHERE kode_barcode='00036705' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2059000',harga_beli ='2059000' WHERE kode_barcode='00036706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2059000',harga_beli ='2059000' WHERE kode_barcode='00036707' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2059000',harga_beli ='2059000' WHERE kode_barcode='00036708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4732000',harga_beli ='4732000' WHERE kode_barcode='00036763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4671500',harga_beli ='4671500' WHERE kode_barcode='00036764' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4641000',harga_beli ='4641000' WHERE kode_barcode='00036765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4625500',harga_beli ='4625500' WHERE kode_barcode='00036766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4534500',harga_beli ='4534500' WHERE kode_barcode='00036767' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3134500',harga_beli ='3134500' WHERE kode_barcode='00036770' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1991000',harga_beli ='1991000' WHERE kode_barcode='00036790' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1887000',harga_beli ='1887000' WHERE kode_barcode='00036791' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2481500',harga_beli ='2481500' WHERE kode_barcode='00036806' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2749000',harga_beli ='2749000' WHERE kode_barcode='00036808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2006000',harga_beli ='2006000' WHERE kode_barcode='00036842' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2050500',harga_beli ='2050500' WHERE kode_barcode='00036843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2139500',harga_beli ='2139500' WHERE kode_barcode='00036844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3358000',harga_beli ='3358000' WHERE kode_barcode='00036848' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2065500',harga_beli ='2065500' WHERE kode_barcode='00036849' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2749000',harga_beli ='2749000' WHERE kode_barcode='00036850' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3343000',harga_beli ='3343000' WHERE kode_barcode='00036851' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2912000',harga_beli ='2912000' WHERE kode_barcode='00036852' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3283500',harga_beli ='3283500' WHERE kode_barcode='00036853' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2823000',harga_beli ='2823000' WHERE kode_barcode='00036855' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2347500',harga_beli ='2347500' WHERE kode_barcode='00036856' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='10696500',harga_beli ='10696500' WHERE kode_barcode='00036906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='13222000',harga_beli ='13222000' WHERE kode_barcode='00036907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='7790500',harga_beli ='7790500' WHERE kode_barcode='00036908' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5051500',harga_beli ='5051500' WHERE kode_barcode='00036909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='11168000',harga_beli ='11168000' WHERE kode_barcode='00036910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8049000',harga_beli ='8049000' WHERE kode_barcode='00036911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8094500',harga_beli ='8094500' WHERE kode_barcode='00036912' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5554000',harga_beli ='5554000' WHERE kode_barcode='00036913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='13663500',harga_beli ='13663500' WHERE kode_barcode='00036914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='10818000',harga_beli ='10818000' WHERE kode_barcode='00036915' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='8977000',harga_beli ='8977000' WHERE kode_barcode='00036916' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='15261000',harga_beli ='15261000' WHERE kode_barcode='00036918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3283500',harga_beli ='3283500' WHERE kode_barcode='00037019' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4918000',harga_beli ='4918000' WHERE kode_barcode='00037245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4413000',harga_beli ='4413000' WHERE kode_barcode='00037246' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3194500',harga_beli ='3194500' WHERE kode_barcode='00037247' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2838000',harga_beli ='2838000' WHERE kode_barcode='00037248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2422000',harga_beli ='2422000' WHERE kode_barcode='00037249' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3536000',harga_beli ='3536000' WHERE kode_barcode='00037250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3789000',harga_beli ='3789000' WHERE kode_barcode='00037252' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2867500',harga_beli ='2867500' WHERE kode_barcode='00037253' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5289500',harga_beli ='5289500' WHERE kode_barcode='00037256' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2125000',harga_beli ='2125000' WHERE kode_barcode='00037267' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='1827500',harga_beli ='1827500' WHERE kode_barcode='00037268' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4502000',harga_beli ='4502000' WHERE kode_barcode='00037269' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3803500',harga_beli ='3803500' WHERE kode_barcode='00037270' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2347500',harga_beli ='2347500' WHERE kode_barcode='00037271' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3952000',harga_beli ='3952000' WHERE kode_barcode='00037272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='4056000',harga_beli ='4056000' WHERE kode_barcode='00037273' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3818500',harga_beli ='3818500' WHERE kode_barcode='00037274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2897500',harga_beli ='2897500' WHERE kode_barcode='00037275' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3714500',harga_beli ='3714500' WHERE kode_barcode='00037276' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2778500',harga_beli ='2778500' WHERE kode_barcode='00037278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3551000',harga_beli ='3551000' WHERE kode_barcode='00037279' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2288500',harga_beli ='2288500' WHERE kode_barcode='00037280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3818500',harga_beli ='3818500' WHERE kode_barcode='00037281' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3982000',harga_beli ='3982000' WHERE kode_barcode='00037283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='2853000',harga_beli ='2853000' WHERE kode_barcode='00037284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3120000',harga_beli ='3120000' WHERE kode_barcode='00037285' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='5334000',harga_beli ='5334000' WHERE kode_barcode='00037288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3685000',harga_beli ='3685000' WHERE kode_barcode='00037289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3848000',harga_beli ='3848000' WHERE kode_barcode='00037813' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='3952000',harga_beli ='3952000' WHERE kode_barcode='00037814' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='19690500',harga_beli ='19690500' WHERE kode_barcode='00038310' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='19690500',harga_beli ='19690500' WHERE kode_barcode='00038311' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1790000',harga_jual='19690500',harga_beli ='19690500' WHERE kode_barcode='00038312' LIMIT 1;
UPDATE tm_group SET harga='1790000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','1790000','kasir','2025-08-29 13:22:16');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-29 ','13:40:40');
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,potong_rp,keterangan) VALUES ('FJ-250829-0001','kasir','1',' 850K-12-00','TOKO','MMPER','PMM-YFBX-58-0','CINCIN SILVER 925 ','','2.110','1','100.00','49000','0','0','16500','850000','0','0','0','850000','NIS','00036499','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-08-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-58-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.110',berat_jual_asli=berat_jual_asli+'2.110',stock_jual='1',berat_akhir=berat_akhir-'2.110',berat_akhir_asli=berat_akhir_asli-'2.110',stock_akhir='0' WHERE tanggal='2025-08-29' AND kode_barang='PMM-YFBX-58-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-250829-0001','2025-08-29','2.110','2025-08-29','13:41:54','PLG0006036','850000','850000','0','850000','0','kasir','2025-08-29 13:41:54','FJ-250829-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-08-29','FJ-250829-0001','2025-08-29','13:41:54','NIS','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250829-0003','2025-08-29','2025-08-29 13:41:54','PENJUALAN : FJ-250829-0001','.','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250829-0004','D','2025-08-29','13:41:54','TBC','PENJUALAN','FJ-250829-0001','15972444764','850000','15973294764','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-250829-0001' 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,potong_rp,keterangan) VALUES ('FJ-250829-0002','kasir','1',' 700K-155-0','TOKO','MMPER','PMM-YFBX-79-0','CINCIN SILVER 925 ','','3.010','1','100.00','70000','0','0','16500','700000','0','0','0','700000','NAD','00036520','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-08-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-79-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.010',berat_jual_asli=berat_jual_asli+'3.010',stock_jual='1',berat_akhir=berat_akhir-'3.010',berat_akhir_asli=berat_akhir_asli-'3.010',stock_akhir='0' WHERE tanggal='2025-08-29' AND kode_barang='PMM-YFBX-79-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-250829-0002','2025-08-29','3.010','2025-08-29','13:42:28','PLG0006037','700000','700000','0','700000','0','kasir','2025-08-29 13:42:28','FJ-250829-0002','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-08-29','FJ-250829-0002','2025-08-29','13:42:28','NAD','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250829-0004','2025-08-29','2025-08-29 13:42:28','PENJUALAN : FJ-250829-0002','.','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250829-0005','D','2025-08-29','13:42:28','TBC','PENJUALAN','FJ-250829-0002','15973294764','700000','15973994764','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='700000' WHERE no_faktur_jual='FJ-250829-0002' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-29 ','14:04:57');
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-01025';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-01025';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-01025';
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-250829-0002','K','2025-08-29','15:35:00','kasir','PESANAN BATAL','DP-01025','36600','0','36600');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-29 ','16:12:03');
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-20250829-0001','1','PBDG-YHBI-1-0','1','2.380','2.380','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YHBI-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YHBI-1-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YHBI-1-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-08-29 16:12:15' WHERE kode_barang='PBDG-YHBI-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YHBI-1-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-08-29 16:12:15','TOKO','BIPPER','PBDG','PBDG-YHBI-1-0','1','2.380','2.380','1','2.380','2.380','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YHBI-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-1-0';
UPDATE tt_beli_detail SET tgl_terima='2025-08-29' WHERE no_faktur_beli='';
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-20250829-0001','1','PBDG-YHBI-2-0','1','2.330','2.330','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YHBI-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YHBI-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YHBI-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-08-29 16:12:15' WHERE kode_barang='PBDG-YHBI-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YHBI-2-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-08-29 16:12:15','TOKO','BIPPER','PBDG','PBDG-YHBI-2-0','1','2.330','2.330','1','2.330','2.330','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YHBI-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-2-0';
UPDATE tt_beli_detail SET tgl_terima='2025-08-29' WHERE no_faktur_beli='';
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-20250829-0001','1','PBDG-YHBI-3-0','1','2.300','2.300','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YHBI-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YHBI-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YHBI-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-08-29 16:12:15' WHERE kode_barang='PBDG-YHBI-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YHBI-3-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-08-29 16:12:15','TOKO','BIPPER','PBDG','PBDG-YHBI-3-0','1','2.300','2.300','1','2.300','2.300','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YHBI-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-3-0';
UPDATE tt_beli_detail SET tgl_terima='2025-08-29' WHERE no_faktur_beli='';
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-20250829-0001','1','PBDG-YHBI-4-0','1','2.270','2.270','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YHBI-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YHBI-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YHBI-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-08-29 16:12:15' WHERE kode_barang='PBDG-YHBI-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YHBI-4-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-08-29 16:12:15','TOKO','BIPPER','PBDG','PBDG-YHBI-4-0','1','2.270','2.270','1','2.270','2.270','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YHBI-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-4-0';
UPDATE tt_beli_detail SET tgl_terima='2025-08-29' WHERE no_faktur_beli='';
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-20250829-0001','1','PBDG-YHBI-5-0','1','2.320','2.320','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YHBI-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YHBI-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YHBI-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-08-29 16:12:15' WHERE kode_barang='PBDG-YHBI-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YHBI-5-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-08-29 16:12:15','TOKO','BIPPER','PBDG','PBDG-YHBI-5-0','1','2.320','2.320','1','2.320','2.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YHBI-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-5-0';
UPDATE tt_beli_detail SET tgl_terima='2025-08-29' WHERE no_faktur_beli='';
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-20250829-0001','1','PBDG-YHBI-6-0','1','2.410','2.410','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YHBI-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YHBI-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YHBI-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-08-29 16:12:15' WHERE kode_barang='PBDG-YHBI-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YHBI-6-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-08-29 16:12:15','TOKO','BIPPER','PBDG','PBDG-YHBI-6-0','1','2.410','2.410','1','2.410','2.410','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YHBI-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-6-0';
UPDATE tt_beli_detail SET tgl_terima='2025-08-29' WHERE no_faktur_beli='';
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-20250829-0001','1','PBDG-YHBI-7-0','1','2.410','2.410','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YHBI-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YHBI-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YHBI-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-08-29 16:12:15' WHERE kode_barang='PBDG-YHBI-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YHBI-7-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-08-29 16:12:15','TOKO','BIPPER','PBDG','PBDG-YHBI-7-0','1','2.410','2.410','1','2.410','2.410','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YHBI-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-7-0';
UPDATE tt_beli_detail SET tgl_terima='2025-08-29' WHERE no_faktur_beli='';
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-20250829-0001','1','PBDG-YHBI-8-0','1','2.380','2.380','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YHBI-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YHBI-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YHBI-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-08-29 16:12:15' WHERE kode_barang='PBDG-YHBI-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YHBI-8-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-08-29 16:12:15','TOKO','BIPPER','PBDG','PBDG-YHBI-8-0','1','2.380','2.380','1','2.380','2.380','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YHBI-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-8-0';
UPDATE tt_beli_detail SET tgl_terima='2025-08-29' WHERE no_faktur_beli='';
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-20250829-0001','1','PBDG-YHBI-9-0','1','2.390','2.390','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YHBI-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YHBI-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YHBI-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-08-29 16:12:15' WHERE kode_barang='PBDG-YHBI-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YHBI-9-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-08-29 16:12:15','TOKO','BIPPER','PBDG','PBDG-YHBI-9-0','1','2.390','2.390','1','2.390','2.390','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YHBI-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-9-0';
UPDATE tt_beli_detail SET tgl_terima='2025-08-29' WHERE no_faktur_beli='';
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-20250829-0001','1','PBDG-YHBI-10-0','1','2.380','2.380','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YHBI-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YHBI-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YHBI-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-08-29 16:12:15' WHERE kode_barang='PBDG-YHBI-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YHBI-10-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-08-29 16:12:15','TOKO','BIPPER','PBDG','PBDG-YHBI-10-0','1','2.380','2.380','1','2.380','2.380','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YHBI-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-10-0';
UPDATE tt_beli_detail SET tgl_terima='2025-08-29' WHERE no_faktur_beli='';
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-20250829-0001','1','PBDG-YHBI-11-0','1','2.450','2.450','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YHBI-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YHBI-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YHBI-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-08-29 16:12:15' WHERE kode_barang='PBDG-YHBI-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YHBI-11-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-08-29 16:12:15','TOKO','BIPPER','PBDG','PBDG-YHBI-11-0','1','2.450','2.450','1','2.450','2.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YHBI-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-11-0';
UPDATE tt_beli_detail SET tgl_terima='2025-08-29' WHERE no_faktur_beli='';
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-20250829-0001','1','PBDG-YHBI-12-0','1','2.450','2.450','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YHBI-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YHBI-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YHBI-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-08-29 16:12:15' WHERE kode_barang='PBDG-YHBI-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YHBI-12-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-08-29 16:12:15','TOKO','BIPPER','PBDG','PBDG-YHBI-12-0','1','2.450','2.450','1','2.450','2.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YHBI-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YHBI-12-0';
UPDATE tt_beli_detail SET tgl_terima='2025-08-29' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250829-0001','2025-08-29','16:12','28.470','kasir','2025-08-29 16:12:14');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-29 ','16:35:42');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250829-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250829-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250829-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250829-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250829-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250829-0002';
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,potong_rp,keterangan) VALUES ('FJ-250829-0003','kasir','1',' 700K-15-00','TOKO','BIPPER','PMM-YFBX-104-0','CINCIN SILVER 925 ','','2.300','1','100.00','53000','0','0','16500','700000','0','0','0','700000','SUL','00036545','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-08-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-104-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.300',berat_jual_asli=berat_jual_asli+'2.300',stock_jual='1',berat_akhir=berat_akhir-'2.300',berat_akhir_asli=berat_akhir_asli-'2.300',stock_akhir='0' WHERE tanggal='2025-08-29' AND kode_barang='PMM-YFBX-104-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-250829-0003','2025-08-29','2.300','2025-08-29','19:20:36','PLG0006038','700000','700000','0','700000','0','kasir','2025-08-29 19:20:36','FJ-250829-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-08-29','FJ-250829-0003','2025-08-29','19:20:36','SUL','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250829-0005','2025-08-29','2025-08-29 19:20:36','PENJUALAN : FJ-250829-0003','.','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250829-0006','D','2025-08-29','19:20:36','TBC','PENJUALAN','FJ-250829-0003','15973994764','700000','15974694764','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='700000' WHERE no_faktur_jual='FJ-250829-0003' 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,potong_rp,keterangan) VALUES ('FJ-250829-0004','kasir',' 1',' BDCM700K-5','TOKO','BIPCMP','BDCM-YFAG-10-0','BANDUNG CINCIN EMAS ','','1.470','1','83.00','2513000','0','0','16500','3146100','0','0','0','3146100','SUL','00036360','BDCM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-08-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-YFAG-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.470',berat_jual_asli=berat_jual_asli+'1.470',stock_jual='1',berat_akhir=berat_akhir-'1.470',berat_akhir_asli=berat_akhir_asli-'1.470',stock_akhir='0' WHERE tanggal='2025-08-29' AND kode_barang='BDCM-YFAG-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCMP' 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,no_persekot,dp_pesanan) VALUES ('FJ-250829-0004','2025-08-29','1.470','2025-08-29','19:20:36','PLG0006039','3146100','3146100','0','3146100','0','kasir','2025-08-29 19:20:36','FJ-250829-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-08-29','FJ-250829-0004','2025-08-29','19:20:36','SUL','3146100','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250829-0006','2025-08-29','2025-08-29 19:20:36','PENJUALAN : FJ-250829-0004','.','TBC','3146100','3146100','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250829-0007','D','2025-08-29','19:20:36','TBC','PENJUALAN','FJ-250829-0004','15974694764','3146100','15977840864','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3846100' WHERE no_faktur_jual='FJ-250829-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250829-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250829-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250829-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250829-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250829-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250829-0004';
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,potong_rp,keterangan) VALUES ('FJ-250829-0005','kasir','1',' BDC-00042 ','TOKO','BIPCBR','BDC-YGXD-48-0','CINCIN BDC-00042 ','','0.450','1','83.00','1763000','863500','52','16500','2925000','0','0','0','2925000','SUL','00036994','BDC','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-08-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDC-YGXD-48-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2025-08-29' AND kode_barang='BDC-YGXD-48-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCBR' 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,no_persekot,dp_pesanan) VALUES ('FJ-250829-0005','2025-08-29','0.450','2025-08-29','19:30:57','PLG0006040','2925000','2925000','0','2925000','0','kasir','2025-08-29 19:30:57','FJ-250829-0005','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-08-29','FJ-250829-0005','2025-08-29','19:30:57','SUL','2925000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250829-0007','2025-08-29','2025-08-29 19:30:57','PENJUALAN : FJ-250829-0005','.','TBC','2925000','2925000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250829-0008','D','2025-08-29','19:30:57','TBC','PENJUALAN BERLIAN','FJ-250829-0005','15977840864','2925000','15980765864','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2925000' WHERE no_faktur_jual='FJ-250829-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250829-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250829-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250829-0005';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-29 ','19:54:32');
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,potong_rp,keterangan) VALUES ('FJ-250829-0006','kasir','1',' 700K-19-14','TOKO','BIPPER','PBDG-YFCX-13-0','CINCIN SILVER 925 ','','4.740','1','100.00','110000','0','0','16500','700000','0','0','0','700000','SUL','00036814','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-08-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YFCX-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.740',berat_jual_asli=berat_jual_asli+'4.740',stock_jual='1',berat_akhir=berat_akhir-'4.740',berat_akhir_asli=berat_akhir_asli-'4.740',stock_akhir='0' WHERE tanggal='2025-08-29' AND kode_barang='PBDG-YFCX-13-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-250829-0006','2025-08-29','4.740','2025-08-29','19:59:23','PLG0006041','700000','700000','0','700000','0','kasir','2025-08-29 19:59:22','FJ-250829-0006','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-08-29','FJ-250829-0006','2025-08-29','19:59:23','SUL','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250829-0008','2025-08-29','2025-08-29 19:59:22','PENJUALAN : FJ-250829-0006','.','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250829-0009','D','2025-08-29','19:59:23','TBC','PENJUALAN','FJ-250829-0006','15980765864','700000','15981465864','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='700000' WHERE no_faktur_jual='FJ-250829-0006' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-08-29 ','20:00:27');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250829-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250829-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250829-0006';