INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-01-09 ','08:56:54');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-01-09 ','10:15:44');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-01-09 ','10:55:37');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-01-09 ','14:41:33');
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8398500',harga_beli ='8398500' WHERE kode_barcode='00017312' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7584500',harga_beli ='7584500' WHERE kode_barcode='00017383' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8319000',harga_beli ='8319000' WHERE kode_barcode='00017542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5619000',harga_beli ='5619000' WHERE kode_barcode='00017624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9014000',harga_beli ='9014000' WHERE kode_barcode='00017626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8835000',harga_beli ='8835000' WHERE kode_barcode='00017628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7147500',harga_beli ='7147500' WHERE kode_barcode='00017636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5043000',harga_beli ='5043000' WHERE kode_barcode='00017662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6095500',harga_beli ='6095500' WHERE kode_barcode='00017663' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11892500',harga_beli ='11892500' WHERE kode_barcode='00017681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11714000',harga_beli ='11714000' WHERE kode_barcode='00017697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5539500',harga_beli ='5539500' WHERE kode_barcode='00017698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5718000',harga_beli ='5718000' WHERE kode_barcode='00017717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2919000',harga_beli ='2919000' WHERE kode_barcode='00017759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2879000',harga_beli ='2879000' WHERE kode_barcode='00017760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='12131000',harga_beli ='12131000' WHERE kode_barcode='00017900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='46894500',harga_beli ='46894500' WHERE kode_barcode='00017913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4070500',harga_beli ='4070500' WHERE kode_barcode='00017959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7941500',harga_beli ='7941500' WHERE kode_barcode='00017982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='12031500',harga_beli ='12031500' WHERE kode_barcode='00018019' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8288500',harga_beli ='8288500' WHERE kode_barcode='00018036' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6135000',harga_beli ='6135000' WHERE kode_barcode='00018073' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='18384500',harga_beli ='18384500' WHERE kode_barcode='00018112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6711000',harga_beli ='6711000' WHERE kode_barcode='00018284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6790000',harga_beli ='6790000' WHERE kode_barcode='00018285' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5460000',harga_beli ='5460000' WHERE kode_barcode='00018302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2700500',harga_beli ='2700500' WHERE kode_barcode='00018312' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2660500',harga_beli ='2660500' WHERE kode_barcode='00018337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8835000',harga_beli ='8835000' WHERE kode_barcode='00018371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9292000',harga_beli ='9292000' WHERE kode_barcode='00018463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='12925000',harga_beli ='12925000' WHERE kode_barcode='00018491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5261500',harga_beli ='5261500' WHERE kode_barcode='00018517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5738000',harga_beli ='5738000' WHERE kode_barcode='00018519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7133000',harga_beli ='7133000' WHERE kode_barcode='00018718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4030500',harga_beli ='4030500' WHERE kode_barcode='00018891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4805000',harga_beli ='4805000' WHERE kode_barcode='00018924' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3772500',harga_beli ='3772500' WHERE kode_barcode='00018925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3991000',harga_beli ='3991000' WHERE kode_barcode='00018937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4050500',harga_beli ='4050500' WHERE kode_barcode='00019018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9847500',harga_beli ='9847500' WHERE kode_barcode='00019120' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3713000',harga_beli ='3713000' WHERE kode_barcode='00019123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3871500',harga_beli ='3871500' WHERE kode_barcode='00019148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4904000',harga_beli ='4904000' WHERE kode_barcode='00019153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6909500',harga_beli ='6909500' WHERE kode_barcode='00019234' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5222000',harga_beli ='5222000' WHERE kode_barcode='00019236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6929000',harga_beli ='6929000' WHERE kode_barcode='00019283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8537500',harga_beli ='8537500' WHERE kode_barcode='00019360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4348000',harga_beli ='4348000' WHERE kode_barcode='00019451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5043000',harga_beli ='5043000' WHERE kode_barcode='00019510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6552000',harga_beli ='6552000' WHERE kode_barcode='00019562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6214500',harga_beli ='6214500' WHERE kode_barcode='00019563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5936500',harga_beli ='5936500' WHERE kode_barcode='00019564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8061000',harga_beli ='8061000' WHERE kode_barcode='00019652' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6294000',harga_beli ='6294000' WHERE kode_barcode='00019655' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4388000',harga_beli ='4388000' WHERE kode_barcode='00019656' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9331500',harga_beli ='9331500' WHERE kode_barcode='00019742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3951000',harga_beli ='3951000' WHERE kode_barcode='00019840' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5678500',harga_beli ='5678500' WHERE kode_barcode='00019911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6016000',harga_beli ='6016000' WHERE kode_barcode='00020018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7068000',harga_beli ='7068000' WHERE kode_barcode='00020068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6671000',harga_beli ='6671000' WHERE kode_barcode='00020069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6889500',harga_beli ='6889500' WHERE kode_barcode='00020070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6313500',harga_beli ='6313500' WHERE kode_barcode='00020071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7544500',harga_beli ='7544500' WHERE kode_barcode='00020074' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6631500',harga_beli ='6631500' WHERE kode_barcode='00020075' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6830000',harga_beli ='6830000' WHERE kode_barcode='00020076' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5460000',harga_beli ='5460000' WHERE kode_barcode='00020077' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6552000',harga_beli ='6552000' WHERE kode_barcode='00020080' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6433000',harga_beli ='6433000' WHERE kode_barcode='00020166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7862500',harga_beli ='7862500' WHERE kode_barcode='00020168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10701500',harga_beli ='10701500' WHERE kode_barcode='00020174' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5698500',harga_beli ='5698500' WHERE kode_barcode='00020179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5817500',harga_beli ='5817500' WHERE kode_barcode='00020186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9768000',harga_beli ='9768000' WHERE kode_barcode='00020190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7882000',harga_beli ='7882000' WHERE kode_barcode='00020191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5777500',harga_beli ='5777500' WHERE kode_barcode='00020200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='45711500',harga_beli ='45711500' WHERE kode_barcode='00020223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6313500',harga_beli ='6313500' WHERE kode_barcode='00020259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6889500',harga_beli ='6889500' WHERE kode_barcode='00020365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4725500',harga_beli ='4725500' WHERE kode_barcode='00020492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5638500',harga_beli ='5638500' WHERE kode_barcode='00020616' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5202000',harga_beli ='5202000' WHERE kode_barcode='00020834' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5321000',harga_beli ='5321000' WHERE kode_barcode='00020846' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7624000',harga_beli ='7624000' WHERE kode_barcode='00021113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8597000',harga_beli ='8597000' WHERE kode_barcode='00021253' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6274000',harga_beli ='6274000' WHERE kode_barcode='00021254' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6036000',harga_beli ='6036000' WHERE kode_barcode='00021280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8875000',harga_beli ='8875000' WHERE kode_barcode='00021405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5149000',harga_beli ='5149000' WHERE kode_barcode='00021475' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4144500',harga_beli ='4144500' WHERE kode_barcode='00021503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='23860500',harga_beli ='23860500' WHERE kode_barcode='00021505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='13211500',harga_beli ='13211500' WHERE kode_barcode='00021506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9494000',harga_beli ='9494000' WHERE kode_barcode='00021585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3818000',harga_beli ='3818000' WHERE kode_barcode='00021609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10925500',harga_beli ='10925500' WHERE kode_barcode='00021630' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8138000',harga_beli ='8138000' WHERE kode_barcode='00021635' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6095500',harga_beli ='6095500' WHERE kode_barcode='00021755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8339000',harga_beli ='8339000' WHERE kode_barcode='00021756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6472500',harga_beli ='6472500' WHERE kode_barcode='00021758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8597000',harga_beli ='8597000' WHERE kode_barcode='00021759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5341000',harga_beli ='5341000' WHERE kode_barcode='00021781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9331500',harga_beli ='9331500' WHERE kode_barcode='00021782' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7723500',harga_beli ='7723500' WHERE kode_barcode='00021783' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='15446500',harga_beli ='15446500' WHERE kode_barcode='00021815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11039000',harga_beli ='11039000' WHERE kode_barcode='00021835' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='12210000',harga_beli ='12210000' WHERE kode_barcode='00021844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4044000',harga_beli ='4044000' WHERE kode_barcode='00021867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4044000',harga_beli ='4044000' WHERE kode_barcode='00021876' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4722000',harga_beli ='4722000' WHERE kode_barcode='00021878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='14473500',harga_beli ='14473500' WHERE kode_barcode='00021882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11039000',harga_beli ='11039000' WHERE kode_barcode='00021905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3494500',harga_beli ='3494500' WHERE kode_barcode='00021950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4844500',harga_beli ='4844500' WHERE kode_barcode='00021976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5897000',harga_beli ='5897000' WHERE kode_barcode='00021977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5460000',harga_beli ='5460000' WHERE kode_barcode='00021979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5182000',harga_beli ='5182000' WHERE kode_barcode='00021980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6591500',harga_beli ='6591500' WHERE kode_barcode='00022044' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5777500',harga_beli ='5777500' WHERE kode_barcode='00022045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7445500',harga_beli ='7445500' WHERE kode_barcode='00022046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5321000',harga_beli ='5321000' WHERE kode_barcode='00022071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6095500',harga_beli ='6095500' WHERE kode_barcode='00022114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7425500',harga_beli ='7425500' WHERE kode_barcode='00022140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5758000',harga_beli ='5758000' WHERE kode_barcode='00022141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5440000',harga_beli ='5440000' WHERE kode_barcode='00022142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5380500',harga_beli ='5380500' WHERE kode_barcode='00022143' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10324000',harga_beli ='10324000' WHERE kode_barcode='00022144' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6882000',harga_beli ='6882000' WHERE kode_barcode='00022173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9017000',harga_beli ='9017000' WHERE kode_barcode='00022174' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9845500',harga_beli ='9845500' WHERE kode_barcode='00022176' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7133000',harga_beli ='7133000' WHERE kode_barcode='00022180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7083000',harga_beli ='7083000' WHERE kode_barcode='00022227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10145500',harga_beli ='10145500' WHERE kode_barcode='00022322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='13261500',harga_beli ='13261500' WHERE kode_barcode='00022356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7286500',harga_beli ='7286500' WHERE kode_barcode='00022433' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7108000',harga_beli ='7108000' WHERE kode_barcode='00022442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5003500',harga_beli ='5003500' WHERE kode_barcode='00022450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5380500',harga_beli ='5380500' WHERE kode_barcode='00022468' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8120500',harga_beli ='8120500' WHERE kode_barcode='00022517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='18485500',harga_beli ='18485500' WHERE kode_barcode='00022649' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10741000',harga_beli ='10741000' WHERE kode_barcode='00022659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5701500',harga_beli ='5701500' WHERE kode_barcode='00022758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7158500',harga_beli ='7158500' WHERE kode_barcode='00022759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7660500',harga_beli ='7660500' WHERE kode_barcode='00022765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11528500',harga_beli ='11528500' WHERE kode_barcode='00022774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10599000',harga_beli ='10599000' WHERE kode_barcode='00022806' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7007500',harga_beli ='7007500' WHERE kode_barcode='00022808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9418500',harga_beli ='9418500' WHERE kode_barcode='00022809' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5023500',harga_beli ='5023500' WHERE kode_barcode='00022822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8966500',harga_beli ='8966500' WHERE kode_barcode='00022867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6982500',harga_beli ='6982500' WHERE kode_barcode='00022883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3752500',harga_beli ='3752500' WHERE kode_barcode='00022912' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5360500',harga_beli ='5360500' WHERE kode_barcode='00022950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7187500',harga_beli ='7187500' WHERE kode_barcode='00023060' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9092500',harga_beli ='9092500' WHERE kode_barcode='00023123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5003500',harga_beli ='5003500' WHERE kode_barcode='00023126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9411000',harga_beli ='9411000' WHERE kode_barcode='00023146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6433000',harga_beli ='6433000' WHERE kode_barcode='00023437' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7761000',harga_beli ='7761000' WHERE kode_barcode='00023488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10781000',harga_beli ='10781000' WHERE kode_barcode='00023490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='44052500',harga_beli ='44052500' WHERE kode_barcode='00023493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='22543500',harga_beli ='22543500' WHERE kode_barcode='00023537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4467500',harga_beli ='4467500' WHERE kode_barcode='00023549' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5916500',harga_beli ='5916500' WHERE kode_barcode='00023563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7306500',harga_beli ='7306500' WHERE kode_barcode='00023572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10066000',harga_beli ='10066000' WHERE kode_barcode='00023585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3871500',harga_beli ='3871500' WHERE kode_barcode='00023590' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6381500',harga_beli ='6381500' WHERE kode_barcode='00023593' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6307500',harga_beli ='6307500' WHERE kode_barcode='00023594' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6258000',harga_beli ='6258000' WHERE kode_barcode='00023595' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6969000',harga_beli ='6969000' WHERE kode_barcode='00023596' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10003000',harga_beli ='10003000' WHERE kode_barcode='00023600' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9954000',harga_beli ='9954000' WHERE kode_barcode='00023602' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7120500',harga_beli ='7120500' WHERE kode_barcode='00023604' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7736500',harga_beli ='7736500' WHERE kode_barcode='00023605' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='12639500',harga_beli ='12639500' WHERE kode_barcode='00023606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8254000',harga_beli ='8254000' WHERE kode_barcode='00023607' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10052500',harga_beli ='10052500' WHERE kode_barcode='00023608' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7145000',harga_beli ='7145000' WHERE kode_barcode='00023609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11185500',harga_beli ='11185500' WHERE kode_barcode='00023611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10446500',harga_beli ='10446500' WHERE kode_barcode='00023612' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8328000',harga_beli ='8328000' WHERE kode_barcode='00023613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10471500',harga_beli ='10471500' WHERE kode_barcode='00023614' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6332000',harga_beli ='6332000' WHERE kode_barcode='00023617' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5400500',harga_beli ='5400500' WHERE kode_barcode='00023622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4928000',harga_beli ='4928000' WHERE kode_barcode='00023623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='13421500',harga_beli ='13421500' WHERE kode_barcode='00023626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6790000',harga_beli ='6790000' WHERE kode_barcode='00023629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3018000',harga_beli ='3018000' WHERE kode_barcode='00023632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3991000',harga_beli ='3991000' WHERE kode_barcode='00023666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2283500',harga_beli ='2283500' WHERE kode_barcode='00023679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5261500',harga_beli ='5261500' WHERE kode_barcode='00023691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7187500',harga_beli ='7187500' WHERE kode_barcode='00023692' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8517500',harga_beli ='8517500' WHERE kode_barcode='00023693' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8517500',harga_beli ='8517500' WHERE kode_barcode='00023697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='17739500',harga_beli ='17739500' WHERE kode_barcode='00023704' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9689000',harga_beli ='9689000' WHERE kode_barcode='00023760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='12023500',harga_beli ='12023500' WHERE kode_barcode='00023815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4149500',harga_beli ='4149500' WHERE kode_barcode='00023830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11019000',harga_beli ='11019000' WHERE kode_barcode='00023843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4435000',harga_beli ='4435000' WHERE kode_barcode='00023848' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5857000',harga_beli ='5857000' WHERE kode_barcode='00023857' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6433000',harga_beli ='6433000' WHERE kode_barcode='00023907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6234500',harga_beli ='6234500' WHERE kode_barcode='00023913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5420500',harga_beli ='5420500' WHERE kode_barcode='00023917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6086000',harga_beli ='6086000' WHERE kode_barcode='00023920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6353500',harga_beli ='6353500' WHERE kode_barcode='00023934' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3077500',harga_beli ='3077500' WHERE kode_barcode='00023964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7882000',harga_beli ='7882000' WHERE kode_barcode='00023965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8722000',harga_beli ='8722000' WHERE kode_barcode='00023979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5341000',harga_beli ='5341000' WHERE kode_barcode='00023985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9014000',harga_beli ='9014000' WHERE kode_barcode='00023991' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6671000',harga_beli ='6671000' WHERE kode_barcode='00023997' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7286500',harga_beli ='7286500' WHERE kode_barcode='00023998' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7008500',harga_beli ='7008500' WHERE kode_barcode='00024000' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9272000',harga_beli ='9272000' WHERE kode_barcode='00024004' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5341000',harga_beli ='5341000' WHERE kode_barcode='00024013' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8525000',harga_beli ='8525000' WHERE kode_barcode='00024038' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5202000',harga_beli ='5202000' WHERE kode_barcode='00024062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7485000',harga_beli ='7485000' WHERE kode_barcode='00024069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3236500',harga_beli ='3236500' WHERE kode_barcode='00024077' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4030500',harga_beli ='4030500' WHERE kode_barcode='00024082' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5301000',harga_beli ='5301000' WHERE kode_barcode='00024085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5162000',harga_beli ='5162000' WHERE kode_barcode='00024086' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4213500',harga_beli ='4213500' WHERE kode_barcode='00024095' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7644000',harga_beli ='7644000' WHERE kode_barcode='00024096' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6909500',harga_beli ='6909500' WHERE kode_barcode='00024104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7961500',harga_beli ='7961500' WHERE kode_barcode='00024148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6155000',harga_beli ='6155000' WHERE kode_barcode='00024186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6055500',harga_beli ='6055500' WHERE kode_barcode='00024189' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11416000',harga_beli ='11416000' WHERE kode_barcode='00024193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4408000',harga_beli ='4408000' WHERE kode_barcode='00024194' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6214500',harga_beli ='6214500' WHERE kode_barcode='00024363' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7147500',harga_beli ='7147500' WHERE kode_barcode='00025284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7624000',harga_beli ='7624000' WHERE kode_barcode='00025286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='14473500',harga_beli ='14473500' WHERE kode_barcode='00025510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='18424500',harga_beli ='18424500' WHERE kode_barcode='00026215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='15793000',harga_beli ='15793000' WHERE kode_barcode='00026302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8279000',harga_beli ='8279000' WHERE kode_barcode='00026725' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5043000',harga_beli ='5043000' WHERE kode_barcode='00026882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5519500',harga_beli ='5519500' WHERE kode_barcode='00026884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3157000',harga_beli ='3157000' WHERE kode_barcode='00026926' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5638500',harga_beli ='5638500' WHERE kode_barcode='00026927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9768000',harga_beli ='9768000' WHERE kode_barcode='00026952' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5460000',harga_beli ='5460000' WHERE kode_barcode='00027033' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10939500',harga_beli ='10939500' WHERE kode_barcode='00027034' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5718000',harga_beli ='5718000' WHERE kode_barcode='00027038' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5301000',harga_beli ='5301000' WHERE kode_barcode='00027050' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5083000',harga_beli ='5083000' WHERE kode_barcode='00027104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3534000',harga_beli ='3534000' WHERE kode_barcode='00027149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='17233000',harga_beli ='17233000' WHERE kode_barcode='00027177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4626000',harga_beli ='4626000' WHERE kode_barcode='00027229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5222000',harga_beli ='5222000' WHERE kode_barcode='00027334' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4459500',harga_beli ='4459500' WHERE kode_barcode='00027480' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='12945000',harga_beli ='12945000' WHERE kode_barcode='00027482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2105000',harga_beli ='2105000' WHERE kode_barcode='00027795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8160000',harga_beli ='8160000' WHERE kode_barcode='00027945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6603000',harga_beli ='6603000' WHERE kode_barcode='00028046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8339000',harga_beli ='8339000' WHERE kode_barcode='00028061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4963500',harga_beli ='4963500' WHERE kode_barcode='00028107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11992000',harga_beli ='11992000' WHERE kode_barcode='00028220' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11851000',harga_beli ='11851000' WHERE kode_barcode='00028368' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8081500',harga_beli ='8081500' WHERE kode_barcode='00028381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10840500',harga_beli ='10840500' WHERE kode_barcode='00028442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3597500',harga_beli ='3597500' WHERE kode_barcode='00028566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7783000',harga_beli ='7783000' WHERE kode_barcode='00028582' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6572000',harga_beli ='6572000' WHERE kode_barcode='00028682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5499500',harga_beli ='5499500' WHERE kode_barcode='00028692' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9288500',harga_beli ='9288500' WHERE kode_barcode='00028772' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5122500',harga_beli ='5122500' WHERE kode_barcode='00029136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4336500',harga_beli ='4336500' WHERE kode_barcode='00029506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10046000',harga_beli ='10046000' WHERE kode_barcode='00029526' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5420500',harga_beli ='5420500' WHERE kode_barcode='00029662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='12910500',harga_beli ='12910500' WHERE kode_barcode='00030349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4745500',harga_beli ='4745500' WHERE kode_barcode='00030671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7293000',harga_beli ='7293000' WHERE kode_barcode='00030672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6159500',harga_beli ='6159500' WHERE kode_barcode='00030674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3646500',harga_beli ='3646500' WHERE kode_barcode='00030709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3696000',harga_beli ='3696000' WHERE kode_barcode='00030712' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3622000',harga_beli ='3622000' WHERE kode_barcode='00030714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4435000',harga_beli ='4435000' WHERE kode_barcode='00030716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4312000',harga_beli ='4312000' WHERE kode_barcode='00030719' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4016000',harga_beli ='4016000' WHERE kode_barcode='00030721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6332000',harga_beli ='6332000' WHERE kode_barcode='00030821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4666000',harga_beli ='4666000' WHERE kode_barcode='00030827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2085000',harga_beli ='2085000' WHERE kode_barcode='00031061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2065000',harga_beli ='2065000' WHERE kode_barcode='00031062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1985500',harga_beli ='1985500' WHERE kode_barcode='00031064' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3316000',harga_beli ='3316000' WHERE kode_barcode='00031066' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3991000',harga_beli ='3991000' WHERE kode_barcode='00031069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3653500',harga_beli ='3653500' WHERE kode_barcode='00031070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3613500',harga_beli ='3613500' WHERE kode_barcode='00031071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3055500',harga_beli ='3055500' WHERE kode_barcode='00031074' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5976000',harga_beli ='5976000' WHERE kode_barcode='00031112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8358500',harga_beli ='8358500' WHERE kode_barcode='00031113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6313500',harga_beli ='6313500' WHERE kode_barcode='00031114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3534000',harga_beli ='3534000' WHERE kode_barcode='00031115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3177000',harga_beli ='3177000' WHERE kode_barcode='00031116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8648000',harga_beli ='8648000' WHERE kode_barcode='00031117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='21362500',harga_beli ='21362500' WHERE kode_barcode='00031126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='19754500',harga_beli ='19754500' WHERE kode_barcode='00031175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6869500',harga_beli ='6869500' WHERE kode_barcode='00031182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7638000',harga_beli ='7638000' WHERE kode_barcode='00031184' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6775500',harga_beli ='6775500' WHERE kode_barcode='00031187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='12393000',harga_beli ='12393000' WHERE kode_barcode='00031190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5839500',harga_beli ='5839500' WHERE kode_barcode='00031191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='34246500',harga_beli ='34246500' WHERE kode_barcode='00031203' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='18109000',harga_beli ='18109000' WHERE kode_barcode='00031204' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5996000',harga_beli ='5996000' WHERE kode_barcode='00031267' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5162000',harga_beli ='5162000' WHERE kode_barcode='00031268' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7802500',harga_beli ='7802500' WHERE kode_barcode='00031269' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7644000',harga_beli ='7644000' WHERE kode_barcode='00031270' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4527000',harga_beli ='4527000' WHERE kode_barcode='00031272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5222000',harga_beli ='5222000' WHERE kode_barcode='00031274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5579000',harga_beli ='5579000' WHERE kode_barcode='00031276' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6810000',harga_beli ='6810000' WHERE kode_barcode='00031277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5102500',harga_beli ='5102500' WHERE kode_barcode='00031278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5162000',harga_beli ='5162000' WHERE kode_barcode='00031279' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4824500',harga_beli ='4824500' WHERE kode_barcode='00031280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6552000',harga_beli ='6552000' WHERE kode_barcode='00031282' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6452500',harga_beli ='6452500' WHERE kode_barcode='00031283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6830000',harga_beli ='6830000' WHERE kode_barcode='00031284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4646000',harga_beli ='4646000' WHERE kode_barcode='00031285' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3236500',harga_beli ='3236500' WHERE kode_barcode='00031286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3574000',harga_beli ='3574000' WHERE kode_barcode='00031287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6572000',harga_beli ='6572000' WHERE kode_barcode='00031332' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6572000',harga_beli ='6572000' WHERE kode_barcode='00031333' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7386000',harga_beli ='7386000' WHERE kode_barcode='00031335' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3931500',harga_beli ='3931500' WHERE kode_barcode='00031337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5897000',harga_beli ='5897000' WHERE kode_barcode='00031382' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5440000',harga_beli ='5440000' WHERE kode_barcode='00031383' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4209000',harga_beli ='4209000' WHERE kode_barcode='00031385' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4189500',harga_beli ='4189500' WHERE kode_barcode='00031386' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2780000',harga_beli ='2780000' WHERE kode_barcode='00031387' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6949000',harga_beli ='6949000' WHERE kode_barcode='00031390' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5043000',harga_beli ='5043000' WHERE kode_barcode='00031391' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3256500',harga_beli ='3256500' WHERE kode_barcode='00031392' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4983500',harga_beli ='4983500' WHERE kode_barcode='00031394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7207000',harga_beli ='7207000' WHERE kode_barcode='00031396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5976000',harga_beli ='5976000' WHERE kode_barcode='00031397' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6591500',harga_beli ='6591500' WHERE kode_barcode='00031399' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7306500',harga_beli ='7306500' WHERE kode_barcode='00031400' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8458000',harga_beli ='8458000' WHERE kode_barcode='00031401' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6472500',harga_beli ='6472500' WHERE kode_barcode='00031402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4745500',harga_beli ='4745500' WHERE kode_barcode='00031404' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5222000',harga_beli ='5222000' WHERE kode_barcode='00031406' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5202000',harga_beli ='5202000' WHERE kode_barcode='00031407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6611500',harga_beli ='6611500' WHERE kode_barcode='00031409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6055500',harga_beli ='6055500' WHERE kode_barcode='00031410' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7386000',harga_beli ='7386000' WHERE kode_barcode='00031411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5380500',harga_beli ='5380500' WHERE kode_barcode='00031413' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3554000',harga_beli ='3554000' WHERE kode_barcode='00031414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7783000',harga_beli ='7783000' WHERE kode_barcode='00031415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5321000',harga_beli ='5321000' WHERE kode_barcode='00031416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7802500',harga_beli ='7802500' WHERE kode_barcode='00031454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5916500',harga_beli ='5916500' WHERE kode_barcode='00031455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8180000',harga_beli ='8180000' WHERE kode_barcode='00031457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9014000',harga_beli ='9014000' WHERE kode_barcode='00031459' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7108000',harga_beli ='7108000' WHERE kode_barcode='00031461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8623500',harga_beli ='8623500' WHERE kode_barcode='00031492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6874000',harga_beli ='6874000' WHERE kode_barcode='00031493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5539500',harga_beli ='5539500' WHERE kode_barcode='00031494' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4368000',harga_beli ='4368000' WHERE kode_barcode='00031495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4983500',harga_beli ='4983500' WHERE kode_barcode='00031496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6750500',harga_beli ='6750500' WHERE kode_barcode='00031498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6532000',harga_beli ='6532000' WHERE kode_barcode='00031502' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8120500',harga_beli ='8120500' WHERE kode_barcode='00031503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6512500',harga_beli ='6512500' WHERE kode_barcode='00031504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4924000',harga_beli ='4924000' WHERE kode_barcode='00031514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7306500',harga_beli ='7306500' WHERE kode_barcode='00031515' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6430500',harga_beli ='6430500' WHERE kode_barcode='00031516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4386000',harga_beli ='4386000' WHERE kode_barcode='00031517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1725000',harga_beli ='1725000' WHERE kode_barcode='00031518' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6972500',harga_beli ='6972500' WHERE kode_barcode='00031521' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6110500',harga_beli ='6110500' WHERE kode_barcode='00031522' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9264000',harga_beli ='9264000' WHERE kode_barcode='00031523' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2978500',harga_beli ='2978500' WHERE kode_barcode='00031533' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2958500',harga_beli ='2958500' WHERE kode_barcode='00031534' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='14659500',harga_beli ='14659500' WHERE kode_barcode='00031558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4854000',harga_beli ='4854000' WHERE kode_barcode='00031563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1725000',harga_beli ='1725000' WHERE kode_barcode='00031564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6283000',harga_beli ='6283000' WHERE kode_barcode='00031565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5445000',harga_beli ='5445000' WHERE kode_barcode='00031566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4090000',harga_beli ='4090000' WHERE kode_barcode='00031568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6313500',harga_beli ='6313500' WHERE kode_barcode='00031584' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3852000',harga_beli ='3852000' WHERE kode_barcode='00031585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7441000',harga_beli ='7441000' WHERE kode_barcode='00031588' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3296000',harga_beli ='3296000' WHERE kode_barcode='00031590' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4070500',harga_beli ='4070500' WHERE kode_barcode='00031591' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6194500',harga_beli ='6194500' WHERE kode_barcode='00031595' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3548000',harga_beli ='3548000' WHERE kode_barcode='00031599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3252500',harga_beli ='3252500' WHERE kode_barcode='00031600' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10175500',harga_beli ='10175500' WHERE kode_barcode='00031613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9153000',harga_beli ='9153000' WHERE kode_barcode='00031616' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2283500',harga_beli ='2283500' WHERE kode_barcode='00031618' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5420500',harga_beli ='5420500' WHERE kode_barcode='00031619' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3693000',harga_beli ='3693000' WHERE kode_barcode='00031633' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3772500',harga_beli ='3772500' WHERE kode_barcode='00031634' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='17345000',harga_beli ='17345000' WHERE kode_barcode='00031636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2981500',harga_beli ='2981500' WHERE kode_barcode='00031637' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5083000',harga_beli ='5083000' WHERE kode_barcode='00031658' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7687000',harga_beli ='7687000' WHERE kode_barcode='00031747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6373500',harga_beli ='6373500' WHERE kode_barcode='00031754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='16578000',harga_beli ='16578000' WHERE kode_barcode='00031755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3335500',harga_beli ='3335500' WHERE kode_barcode='00031756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6800500',harga_beli ='6800500' WHERE kode_barcode='00031818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5519500',harga_beli ='5519500' WHERE kode_barcode='00031819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5741000',harga_beli ='5741000' WHERE kode_barcode='00031820' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8623500',harga_beli ='8623500' WHERE kode_barcode='00031821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3137000',harga_beli ='3137000' WHERE kode_barcode='00031823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7835000',harga_beli ='7835000' WHERE kode_barcode='00031824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6949000',harga_beli ='6949000' WHERE kode_barcode='00031825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3852000',harga_beli ='3852000' WHERE kode_barcode='00031826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2513500',harga_beli ='2513500' WHERE kode_barcode='00031829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3752500',harga_beli ='3752500' WHERE kode_barcode='00031855' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4249000',harga_beli ='4249000' WHERE kode_barcode='00031856' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6455500',harga_beli ='6455500' WHERE kode_barcode='00031857' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10077000',harga_beli ='10077000' WHERE kode_barcode='00031895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7326500',harga_beli ='7326500' WHERE kode_barcode='00031896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7088000',harga_beli ='7088000' WHERE kode_barcode='00031897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6036000',harga_beli ='6036000' WHERE kode_barcode='00031905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6750500',harga_beli ='6750500' WHERE kode_barcode='00031911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4408000',harga_beli ='4408000' WHERE kode_barcode='00031913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='21283500',harga_beli ='21283500' WHERE kode_barcode='00031914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3077500',harga_beli ='3077500' WHERE kode_barcode='00031968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='16915500',harga_beli ='16915500' WHERE kode_barcode='00031969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4566500',harga_beli ='4566500' WHERE kode_barcode='00032093' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6472500',harga_beli ='6472500' WHERE kode_barcode='00032094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2621000',harga_beli ='2621000' WHERE kode_barcode='00032198' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2502000',harga_beli ='2502000' WHERE kode_barcode='00032209' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2045000',harga_beli ='2045000' WHERE kode_barcode='00032211' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3693000',harga_beli ='3693000' WHERE kode_barcode='00032213' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2144500',harga_beli ='2144500' WHERE kode_barcode='00032215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='24519500',harga_beli ='24519500' WHERE kode_barcode='00032356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='16816500',harga_beli ='16816500' WHERE kode_barcode='00032357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2641000',harga_beli ='2641000' WHERE kode_barcode='00032358' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4904000',harga_beli ='4904000' WHERE kode_barcode='00032360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3554000',harga_beli ='3554000' WHERE kode_barcode='00032361' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4368000',harga_beli ='4368000' WHERE kode_barcode='00032362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4467500',harga_beli ='4467500' WHERE kode_barcode='00032364' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2085000',harga_beli ='2085000' WHERE kode_barcode='00032365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6075500',harga_beli ='6075500' WHERE kode_barcode='00032370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3038000',harga_beli ='3038000' WHERE kode_barcode='00032372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='16320000',harga_beli ='16320000' WHERE kode_barcode='00032375' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3819000',harga_beli ='3819000' WHERE kode_barcode='00032376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2204000',harga_beli ='2204000' WHERE kode_barcode='00032377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3355500',harga_beli ='3355500' WHERE kode_barcode='00032379' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9867500',harga_beli ='9867500' WHERE kode_barcode='00032381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3018000',harga_beli ='3018000' WHERE kode_barcode='00032479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6671000',harga_beli ='6671000' WHERE kode_barcode='00032498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7862500',harga_beli ='7862500' WHERE kode_barcode='00032499' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11277000',harga_beli ='11277000' WHERE kode_barcode='00032501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6061000',harga_beli ='6061000' WHERE kode_barcode='00032504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='13772500',harga_beli ='13772500' WHERE kode_barcode='00032505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6307500',harga_beli ='6307500' WHERE kode_barcode='00032507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7687000',harga_beli ='7687000' WHERE kode_barcode='00032509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7145000',harga_beli ='7145000' WHERE kode_barcode='00032513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='29343500',harga_beli ='29343500' WHERE kode_barcode='00032523' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4507000',harga_beli ='4507000' WHERE kode_barcode='00032602' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11416000',harga_beli ='11416000' WHERE kode_barcode='00032649' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7736500',harga_beli ='7736500' WHERE kode_barcode='00032667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2045000',harga_beli ='2045000' WHERE kode_barcode='00032668' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9430500',harga_beli ='9430500' WHERE kode_barcode='00032670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='16064000',harga_beli ='16064000' WHERE kode_barcode='00033184' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6671000',harga_beli ='6671000' WHERE kode_barcode='00033220' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5480000',harga_beli ='5480000' WHERE kode_barcode='00033261' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2581000',harga_beli ='2581000' WHERE kode_barcode='00033262' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2422500',harga_beli ='2422500' WHERE kode_barcode='00033264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7687000',harga_beli ='7687000' WHERE kode_barcode='00033289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='21760000',harga_beli ='21760000' WHERE kode_barcode='00033485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4963500',harga_beli ='4963500' WHERE kode_barcode='00033537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3911500',harga_beli ='3911500' WHERE kode_barcode='00034068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3534000',harga_beli ='3534000' WHERE kode_barcode='00034069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4785000',harga_beli ='4785000' WHERE kode_barcode='00034070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4566500',harga_beli ='4566500' WHERE kode_barcode='00034071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3236500',harga_beli ='3236500' WHERE kode_barcode='00034073' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3395000',harga_beli ='3395000' WHERE kode_barcode='00034075' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1846500',harga_beli ='1846500' WHERE kode_barcode='00034076' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3534000',harga_beli ='3534000' WHERE kode_barcode='00034080' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5063000',harga_beli ='5063000' WHERE kode_barcode='00034142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7306500',harga_beli ='7306500' WHERE kode_barcode='00034164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3852000',harga_beli ='3852000' WHERE kode_barcode='00034166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3772500',harga_beli ='3772500' WHERE kode_barcode='00034167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='23050500',harga_beli ='23050500' WHERE kode_barcode='00034249' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2978500',harga_beli ='2978500' WHERE kode_barcode='00034338' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5301000',harga_beli ='5301000' WHERE kode_barcode='00034347' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3117500',harga_beli ='3117500' WHERE kode_barcode='00034348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5400500',harga_beli ='5400500' WHERE kode_barcode='00034349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2184000',harga_beli ='2184000' WHERE kode_barcode='00034351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8200000',harga_beli ='8200000' WHERE kode_barcode='00034354' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3057500',harga_beli ='3057500' WHERE kode_barcode='00034355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5023000',harga_beli ='5023000' WHERE kode_barcode='00034356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4447500',harga_beli ='4447500' WHERE kode_barcode='00034357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2700500',harga_beli ='2700500' WHERE kode_barcode='00034365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2204000',harga_beli ='2204000' WHERE kode_barcode='00034368' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2025500',harga_beli ='2025500' WHERE kode_barcode='00034369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2204000',harga_beli ='2204000' WHERE kode_barcode='00034370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2343000',harga_beli ='2343000' WHERE kode_barcode='00034371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4308500',harga_beli ='4308500' WHERE kode_barcode='00034372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3137000',harga_beli ='3137000' WHERE kode_barcode='00034373' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3097500',harga_beli ='3097500' WHERE kode_barcode='00034374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9252000',harga_beli ='9252000' WHERE kode_barcode='00034381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11972000',harga_beli ='11972000' WHERE kode_barcode='00034490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4287000',harga_beli ='4287000' WHERE kode_barcode='00034661' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2005500',harga_beli ='2005500' WHERE kode_barcode='00034780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2363000',harga_beli ='2363000' WHERE kode_barcode='00034781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3917500',harga_beli ='3917500' WHERE kode_barcode='00035018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2760000',harga_beli ='2760000' WHERE kode_barcode='00035045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7386000',harga_beli ='7386000' WHERE kode_barcode='00035046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3594000',harga_beli ='3594000' WHERE kode_barcode='00035171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10920000',harga_beli ='10920000' WHERE kode_barcode='00035278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5956500',harga_beli ='5956500' WHERE kode_barcode='00035477' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4388000',harga_beli ='4388000' WHERE kode_barcode='00035519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1132000',harga_beli ='1132000' WHERE kode_barcode='00035951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1152000',harga_beli ='1152000' WHERE kode_barcode='00036006' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10446500',harga_beli ='10446500' WHERE kode_barcode='00036172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='913500',harga_beli ='913500' WHERE kode_barcode='00036243' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='893500',harga_beli ='893500' WHERE kode_barcode='00036244' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='834000',harga_beli ='834000' WHERE kode_barcode='00036245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1985500',harga_beli ='1985500' WHERE kode_barcode='00036432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3177000',harga_beli ='3177000' WHERE kode_barcode='00036686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5102500',harga_beli ='5102500' WHERE kode_barcode='00036823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6016000',harga_beli ='6016000' WHERE kode_barcode='00036824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4685500',harga_beli ='4685500' WHERE kode_barcode='00036825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5122500',harga_beli ='5122500' WHERE kode_barcode='00036826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4566500',harga_beli ='4566500' WHERE kode_barcode='00036827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2581000',harga_beli ='2581000' WHERE kode_barcode='00036828' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4566500',harga_beli ='4566500' WHERE kode_barcode='00036830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4566500',harga_beli ='4566500' WHERE kode_barcode='00036831' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4229000',harga_beli ='4229000' WHERE kode_barcode='00036832' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2143500',harga_beli ='2143500' WHERE kode_barcode='00036947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4507000',harga_beli ='4507000' WHERE kode_barcode='00036992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1985500',harga_beli ='1985500' WHERE kode_barcode='00036993' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4149500',harga_beli ='4149500' WHERE kode_barcode='00037325' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5976000',harga_beli ='5976000' WHERE kode_barcode='00037332' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6492500',harga_beli ='6492500' WHERE kode_barcode='00037825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3554000',harga_beli ='3554000' WHERE kode_barcode='00037907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4188500',harga_beli ='4188500' WHERE kode_barcode='00038024' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5440000',harga_beli ='5440000' WHERE kode_barcode='00038455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2919000',harga_beli ='2919000' WHERE kode_barcode='00038672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2780000',harga_beli ='2780000' WHERE kode_barcode='00038674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6530500',harga_beli ='6530500' WHERE kode_barcode='00038720' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3852000',harga_beli ='3852000' WHERE kode_barcode='00038823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5102500',harga_beli ='5102500' WHERE kode_barcode='00038843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3572500',harga_beli ='3572500' WHERE kode_barcode='00038862' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5077500',harga_beli ='5077500' WHERE kode_barcode='00039058' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3395000',harga_beli ='3395000' WHERE kode_barcode='00039178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3216500',harga_beli ='3216500' WHERE kode_barcode='00039179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2601000',harga_beli ='2601000' WHERE kode_barcode='00039180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2065000',harga_beli ='2065000' WHERE kode_barcode='00039181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2283500',harga_beli ='2283500' WHERE kode_barcode='00039182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6075500',harga_beli ='6075500' WHERE kode_barcode='00039192' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5460000',harga_beli ='5460000' WHERE kode_barcode='00039193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3375500',harga_beli ='3375500' WHERE kode_barcode='00039194' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11661000',harga_beli ='11661000' WHERE kode_barcode='00039381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3891500',harga_beli ='3891500' WHERE kode_barcode='00039405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7696500',harga_beli ='7696500' WHERE kode_barcode='00040395' LIMIT 1;
UPDATE tm_group SET harga='2392000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2392000','kasir','2026-01-09 16:00:52');
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2318000',harga_beli ='2318000' WHERE kode_barcode='00019926' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2440000',harga_beli ='2440000' WHERE kode_barcode='00019929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2440000',harga_beli ='2440000' WHERE kode_barcode='00019933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7462000',harga_beli ='7462000' WHERE kode_barcode='00024887' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7645000',harga_beli ='7645000' WHERE kode_barcode='00024889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6201500',harga_beli ='6201500' WHERE kode_barcode='00024890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6161000',harga_beli ='6161000' WHERE kode_barcode='00024891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6161000',harga_beli ='6161000' WHERE kode_barcode='00024892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6140500',harga_beli ='6140500' WHERE kode_barcode='00024893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6140500',harga_beli ='6140500' WHERE kode_barcode='00024895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6181000',harga_beli ='6181000' WHERE kode_barcode='00024896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6161000',harga_beli ='6161000' WHERE kode_barcode='00024897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6079500',harga_beli ='6079500' WHERE kode_barcode='00024898' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6100000',harga_beli ='6100000' WHERE kode_barcode='00024899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6181000',harga_beli ='6181000' WHERE kode_barcode='00024900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6161000',harga_beli ='6161000' WHERE kode_barcode='00024901' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6161000',harga_beli ='6161000' WHERE kode_barcode='00024902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6120000',harga_beli ='6120000' WHERE kode_barcode='00024903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6140500',harga_beli ='6140500' WHERE kode_barcode='00024904' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6140500',harga_beli ='6140500' WHERE kode_barcode='00024905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4351500',harga_beli ='4351500' WHERE kode_barcode='00024909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4473500',harga_beli ='4473500' WHERE kode_barcode='00024912' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4371500',harga_beli ='4371500' WHERE kode_barcode='00024919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4371500',harga_beli ='4371500' WHERE kode_barcode='00024920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4432500',harga_beli ='4432500' WHERE kode_barcode='00024922' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4351500',harga_beli ='4351500' WHERE kode_barcode='00024923' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='17739500',harga_beli ='17739500' WHERE kode_barcode='00025675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='18524000',harga_beli ='18524000' WHERE kode_barcode='00025676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='19075000',harga_beli ='19075000' WHERE kode_barcode='00025677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='16573000',harga_beli ='16573000' WHERE kode_barcode='00025679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='28472000',harga_beli ='28472000' WHERE kode_barcode='00025682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='17631500',harga_beli ='17631500' WHERE kode_barcode='00025683' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='20800000',harga_beli ='20800000' WHERE kode_barcode='00025684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9164500',harga_beli ='9164500' WHERE kode_barcode='00025687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='17383500',harga_beli ='17383500' WHERE kode_barcode='00025697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6704500',harga_beli ='6704500' WHERE kode_barcode='00025699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11450000',harga_beli ='11450000' WHERE kode_barcode='00025701' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11428000',harga_beli ='11428000' WHERE kode_barcode='00025702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3809500',harga_beli ='3809500' WHERE kode_barcode='00025706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4223000',harga_beli ='4223000' WHERE kode_barcode='00025711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4506000',harga_beli ='4506000' WHERE kode_barcode='00025714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='13409000',harga_beli ='13409000' WHERE kode_barcode='00025716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6748000',harga_beli ='6748000' WHERE kode_barcode='00025717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4876000',harga_beli ='4876000' WHERE kode_barcode='00025718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6051500',harga_beli ='6051500' WHERE kode_barcode='00025723' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4005500',harga_beli ='4005500' WHERE kode_barcode='00025724' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1611000',harga_beli ='1611000' WHERE kode_barcode='00025726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1589500',harga_beli ='1589500' WHERE kode_barcode='00025727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5182000',harga_beli ='5182000' WHERE kode_barcode='00025730' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6826000',harga_beli ='6826000' WHERE kode_barcode='00025735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3600500',harga_beli ='3600500' WHERE kode_barcode='00025737' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2164500',harga_beli ='2164500' WHERE kode_barcode='00025739' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10455500',harga_beli ='10455500' WHERE kode_barcode='00025740' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5223500',harga_beli ='5223500' WHERE kode_barcode='00025742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6326500',harga_beli ='6326500' WHERE kode_barcode='00025743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='19886500',harga_beli ='19886500' WHERE kode_barcode='00025747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='50153000',harga_beli ='50153000' WHERE kode_barcode='00025795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='22238500',harga_beli ='22238500' WHERE kode_barcode='00025796' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='46368000',harga_beli ='46368000' WHERE kode_barcode='00025797' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='16605500',harga_beli ='16605500' WHERE kode_barcode='00025798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='20310500',harga_beli ='20310500' WHERE kode_barcode='00025799' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='16180000',harga_beli ='16180000' WHERE kode_barcode='00025800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6039000',harga_beli ='6039000' WHERE kode_barcode='00025877' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5876000',harga_beli ='5876000' WHERE kode_barcode='00025880' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4351500',harga_beli ='4351500' WHERE kode_barcode='00025882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5103500',harga_beli ='5103500' WHERE kode_barcode='00025883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5411000',harga_beli ='5411000' WHERE kode_barcode='00025888' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='28573000',harga_beli ='28573000' WHERE kode_barcode='00025892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='12870500',harga_beli ='12870500' WHERE kode_barcode='00025893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10329000',harga_beli ='10329000' WHERE kode_barcode='00025894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='13114500',harga_beli ='13114500' WHERE kode_barcode='00025896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4904000',harga_beli ='4904000' WHERE kode_barcode='00026055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4566500',harga_beli ='4566500' WHERE kode_barcode='00026056' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3415000',harga_beli ='3415000' WHERE kode_barcode='00026058' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4467500',harga_beli ='4467500' WHERE kode_barcode='00026059' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3871500',harga_beli ='3871500' WHERE kode_barcode='00026060' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5774500',harga_beli ='5774500' WHERE kode_barcode='00026061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4026000',harga_beli ='4026000' WHERE kode_barcode='00026062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3863500',harga_beli ='3863500' WHERE kode_barcode='00026064' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3822500',harga_beli ='3822500' WHERE kode_barcode='00026065' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3029500',harga_beli ='3029500' WHERE kode_barcode='00026070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3009500',harga_beli ='3009500' WHERE kode_barcode='00026071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5246000',harga_beli ='5246000' WHERE kode_barcode='00026072' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7950000',harga_beli ='7950000' WHERE kode_barcode='00026078' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='12138500',harga_beli ='12138500' WHERE kode_barcode='00026079' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2359000',harga_beli ='2359000' WHERE kode_barcode='00026081' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5103500',harga_beli ='5103500' WHERE kode_barcode='00026082' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3871000',harga_beli ='3871000' WHERE kode_barcode='00026085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='15961000',harga_beli ='15961000' WHERE kode_barcode='00026086' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='14395500',harga_beli ='14395500' WHERE kode_barcode='00026087' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='57926000',harga_beli ='57926000' WHERE kode_barcode='00026090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='60711500',harga_beli ='60711500' WHERE kode_barcode='00026091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11589500',harga_beli ='11589500' WHERE kode_barcode='00026093' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='22284000',harga_beli ='22284000' WHERE kode_barcode='00026095' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='18197500',harga_beli ='18197500' WHERE kode_barcode='00026096' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='12748500',harga_beli ='12748500' WHERE kode_barcode='00026097' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5083000',harga_beli ='5083000' WHERE kode_barcode='00026099' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3798500',harga_beli ='3798500' WHERE kode_barcode='00026104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5688000',harga_beli ='5688000' WHERE kode_barcode='00026105' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3798500',harga_beli ='3798500' WHERE kode_barcode='00026106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3912000',harga_beli ='3912000' WHERE kode_barcode='00026107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5095000',harga_beli ='5095000' WHERE kode_barcode='00026108' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3760500',harga_beli ='3760500' WHERE kode_barcode='00026109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3499000',harga_beli ='3499000' WHERE kode_barcode='00026110' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3817500',harga_beli ='3817500' WHERE kode_barcode='00026111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5010500',harga_beli ='5010500' WHERE kode_barcode='00026112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5745000',harga_beli ='5745000' WHERE kode_barcode='00026113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3779500',harga_beli ='3779500' WHERE kode_barcode='00026115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4161000',harga_beli ='4161000' WHERE kode_barcode='00026117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4217000',harga_beli ='4217000' WHERE kode_barcode='00026118' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3321500',harga_beli ='3321500' WHERE kode_barcode='00026119' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2836000',harga_beli ='2836000' WHERE kode_barcode='00026120' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2855000',harga_beli ='2855000' WHERE kode_barcode='00026121' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='51959000',harga_beli ='51959000' WHERE kode_barcode='00026125' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8126000',harga_beli ='8126000' WHERE kode_barcode='00026126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6586500',harga_beli ='6586500' WHERE kode_barcode='00026127' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7594000',harga_beli ='7594000' WHERE kode_barcode='00026132' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9887500',harga_beli ='9887500' WHERE kode_barcode='00026140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5390000',harga_beli ='5390000' WHERE kode_barcode='00026141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5411000',harga_beli ='5411000' WHERE kode_barcode='00026142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4188500',harga_beli ='4188500' WHERE kode_barcode='00026145' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2603000',harga_beli ='2603000' WHERE kode_barcode='00026146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5411000',harga_beli ='5411000' WHERE kode_barcode='00026147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10046500',harga_beli ='10046500' WHERE kode_barcode='00026152' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='13589500',harga_beli ='13589500' WHERE kode_barcode='00026469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7409000',harga_beli ='7409000' WHERE kode_barcode='00026471' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3600500',harga_beli ='3600500' WHERE kode_barcode='00026472' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3933500',harga_beli ='3933500' WHERE kode_barcode='00026475' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='26367000',harga_beli ='26367000' WHERE kode_barcode='00026480' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='27824000',harga_beli ='27824000' WHERE kode_barcode='00026481' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9656500',harga_beli ='9656500' WHERE kode_barcode='00026484' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4079000',harga_beli ='4079000' WHERE kode_barcode='00026485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4329000',harga_beli ='4329000' WHERE kode_barcode='00026486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4287000',harga_beli ='4287000' WHERE kode_barcode='00026487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6347500',harga_beli ='6347500' WHERE kode_barcode='00026525' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7450500',harga_beli ='7450500' WHERE kode_barcode='00026526' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3600500',harga_beli ='3600500' WHERE kode_barcode='00026527' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4204000',harga_beli ='4204000' WHERE kode_barcode='00026529' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3559000',harga_beli ='3559000' WHERE kode_barcode='00026534' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='13839000',harga_beli ='13839000' WHERE kode_barcode='00026537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9323500',harga_beli ='9323500' WHERE kode_barcode='00026538' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='15733000',harga_beli ='15733000' WHERE kode_barcode='00026553' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9739500',harga_beli ='9739500' WHERE kode_barcode='00026557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='15067000',harga_beli ='15067000' WHERE kode_barcode='00026560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4204000',harga_beli ='4204000' WHERE kode_barcode='00026561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4245500',harga_beli ='4245500' WHERE kode_barcode='00026563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8295500',harga_beli ='8295500' WHERE kode_barcode='00026653' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2277500',harga_beli ='2277500' WHERE kode_barcode='00026654' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3395500',harga_beli ='3395500' WHERE kode_barcode='00026655' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3497500',harga_beli ='3497500' WHERE kode_barcode='00026656' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4026000',harga_beli ='4026000' WHERE kode_barcode='00026658' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2318000',harga_beli ='2318000' WHERE kode_barcode='00026659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4737500',harga_beli ='4737500' WHERE kode_barcode='00026660' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3334500',harga_beli ='3334500' WHERE kode_barcode='00026662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4392000',harga_beli ='4392000' WHERE kode_barcode='00026665' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5205500',harga_beli ='5205500' WHERE kode_barcode='00026666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4209000',harga_beli ='4209000' WHERE kode_barcode='00026668' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4626000',harga_beli ='4626000' WHERE kode_barcode='00026669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9609500',harga_beli ='9609500' WHERE kode_barcode='00026671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3991000',harga_beli ='3991000' WHERE kode_barcode='00026672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3673000',harga_beli ='3673000' WHERE kode_barcode='00026677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5777500',harga_beli ='5777500' WHERE kode_barcode='00026678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5286500',harga_beli ='5286500' WHERE kode_barcode='00026679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2806000',harga_beli ='2806000' WHERE kode_barcode='00026680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4819000',harga_beli ='4819000' WHERE kode_barcode='00026681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3375500',harga_beli ='3375500' WHERE kode_barcode='00026683' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2989000',harga_beli ='2989000' WHERE kode_barcode='00026684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3253500',harga_beli ='3253500' WHERE kode_barcode='00026686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4798500',harga_beli ='4798500' WHERE kode_barcode='00026691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9922500',harga_beli ='9922500' WHERE kode_barcode='00026693' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5693000',harga_beli ='5693000' WHERE kode_barcode='00026697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4473500',harga_beli ='4473500' WHERE kode_barcode='00026699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4168500',harga_beli ='4168500' WHERE kode_barcode='00026702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5368000',harga_beli ='5368000' WHERE kode_barcode='00026708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4249500',harga_beli ='4249500' WHERE kode_barcode='00026709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4819000',harga_beli ='4819000' WHERE kode_barcode='00026710' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2847000',harga_beli ='2847000' WHERE kode_barcode='00026711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4370500',harga_beli ='4370500' WHERE kode_barcode='00027627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='12715500',harga_beli ='12715500' WHERE kode_barcode='00027630' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='15712000',harga_beli ='15712000' WHERE kode_barcode='00027632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='23474500',harga_beli ='23474500' WHERE kode_barcode='00027635' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='25368000',harga_beli ='25368000' WHERE kode_barcode='00027636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='15296000',harga_beli ='15296000' WHERE kode_barcode='00027638' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9614500',harga_beli ='9614500' WHERE kode_barcode='00027643' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10967500',harga_beli ='10967500' WHERE kode_barcode='00027645' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='14567500',harga_beli ='14567500' WHERE kode_barcode='00027646' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11446000',harga_beli ='11446000' WHERE kode_barcode='00027647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7908000',harga_beli ='7908000' WHERE kode_barcode='00027649' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6451500',harga_beli ='6451500' WHERE kode_barcode='00027650' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='18313500',harga_beli ='18313500' WHERE kode_barcode='00027652' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='22371500',harga_beli ='22371500' WHERE kode_barcode='00027654' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7691500',harga_beli ='7691500' WHERE kode_barcode='00027657' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3473500',harga_beli ='3473500' WHERE kode_barcode='00027659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5557500',harga_beli ='5557500' WHERE kode_barcode='00027663' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5662500',harga_beli ='5662500' WHERE kode_barcode='00027664' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3991000',harga_beli ='3991000' WHERE kode_barcode='00027667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11870000',harga_beli ='11870000' WHERE kode_barcode='00027668' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5842500',harga_beli ='5842500' WHERE kode_barcode='00027669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='16169000',harga_beli ='16169000' WHERE kode_barcode='00027671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='16889000',harga_beli ='16889000' WHERE kode_barcode='00027672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9261000',harga_beli ='9261000' WHERE kode_barcode='00027678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5307000',harga_beli ='5307000' WHERE kode_barcode='00027680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='13199500',harga_beli ='13199500' WHERE kode_barcode='00027681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5429000',harga_beli ='5429000' WHERE kode_barcode='00027682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3131500',harga_beli ='3131500' WHERE kode_barcode='00027687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4066500',harga_beli ='4066500' WHERE kode_barcode='00027688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='14200000',harga_beli ='14200000' WHERE kode_barcode='00027691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='18819500',harga_beli ='18819500' WHERE kode_barcode='00027694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3746000',harga_beli ='3746000' WHERE kode_barcode='00029700' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7767500',harga_beli ='7767500' WHERE kode_barcode='00029701' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6125500',harga_beli ='6125500' WHERE kode_barcode='00029702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='13493000',harga_beli ='13493000' WHERE kode_barcode='00029703' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5283500',harga_beli ='5283500' WHERE kode_barcode='00029704' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='15640000',harga_beli ='15640000' WHERE kode_barcode='00029705' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9388500',harga_beli ='9388500' WHERE kode_barcode='00029706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10258000',harga_beli ='10258000' WHERE kode_barcode='00030416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='39871500',harga_beli ='39871500' WHERE kode_barcode='00030724' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6750500',harga_beli ='6750500' WHERE kode_barcode='00030727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='27262000',harga_beli ='27262000' WHERE kode_barcode='00030732' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='13589500',harga_beli ='13589500' WHERE kode_barcode='00030733' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10107000',harga_beli ='10107000' WHERE kode_barcode='00030735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='23100000',harga_beli ='23100000' WHERE kode_barcode='00030741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11695500',harga_beli ='11695500' WHERE kode_barcode='00030742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='14234500',harga_beli ='14234500' WHERE kode_barcode='00030744' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3151500',harga_beli ='3151500' WHERE kode_barcode='00030753' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3741500',harga_beli ='3741500' WHERE kode_barcode='00030754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9899500',harga_beli ='9899500' WHERE kode_barcode='00030755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8740500',harga_beli ='8740500' WHERE kode_barcode='00030758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9219500',harga_beli ='9219500' WHERE kode_barcode='00030760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3246500',harga_beli ='3246500' WHERE kode_barcode='00030761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3330000',harga_beli ='3330000' WHERE kode_barcode='00030763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5744000',harga_beli ='5744000' WHERE kode_barcode='00030766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5452500',harga_beli ='5452500' WHERE kode_barcode='00030767' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5827000',harga_beli ='5827000' WHERE kode_barcode='00030768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5744000',harga_beli ='5744000' WHERE kode_barcode='00030769' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='22683500',harga_beli ='22683500' WHERE kode_barcode='00030773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='53087500',harga_beli ='53087500' WHERE kode_barcode='00030774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5144500',harga_beli ='5144500' WHERE kode_barcode='00030785' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4575000',harga_beli ='4575000' WHERE kode_barcode='00030786' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3843000',harga_beli ='3843000' WHERE kode_barcode='00030787' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7485000',harga_beli ='7485000' WHERE kode_barcode='00031469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8824500',harga_beli ='8824500' WHERE kode_barcode='00031682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3843000',harga_beli ='3843000' WHERE kode_barcode='00031684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1728500',harga_beli ='1728500' WHERE kode_barcode='00031686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1850500',harga_beli ='1850500' WHERE kode_barcode='00031687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8255000',harga_beli ='8255000' WHERE kode_barcode='00031690' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3527000',harga_beli ='3527000' WHERE kode_barcode='00032055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1636500',harga_beli ='1636500' WHERE kode_barcode='00033190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5127000',harga_beli ='5127000' WHERE kode_barcode='00033455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6750500',harga_beli ='6750500' WHERE kode_barcode='00033504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2144500',harga_beli ='2144500' WHERE kode_barcode='00033505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2363000',harga_beli ='2363000' WHERE kode_barcode='00033509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2323000',harga_beli ='2323000' WHERE kode_barcode='00033510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='14049500',harga_beli ='14049500' WHERE kode_barcode='00033511' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='14375000',harga_beli ='14375000' WHERE kode_barcode='00033512' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='21349000',harga_beli ='21349000' WHERE kode_barcode='00033513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='16652000',harga_beli ='16652000' WHERE kode_barcode='00033516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11915000',harga_beli ='11915000' WHERE kode_barcode='00033517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5408500',harga_beli ='5408500' WHERE kode_barcode='00033518' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2363500',harga_beli ='2363500' WHERE kode_barcode='00033881' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6532000',harga_beli ='6532000' WHERE kode_barcode='00034760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6929000',harga_beli ='6929000' WHERE kode_barcode='00034761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5122500',harga_beli ='5122500' WHERE kode_barcode='00034762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4844500',harga_beli ='4844500' WHERE kode_barcode='00034763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4566500',harga_beli ='4566500' WHERE kode_barcode='00034768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2978500',harga_beli ='2978500' WHERE kode_barcode='00034769' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5083000',harga_beli ='5083000' WHERE kode_barcode='00034776' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2839500',harga_beli ='2839500' WHERE kode_barcode='00035830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3050000',harga_beli ='3050000' WHERE kode_barcode='00035831' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6016000',harga_beli ='6016000' WHERE kode_barcode='00036170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5718000',harga_beli ='5718000' WHERE kode_barcode='00036357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2978500',harga_beli ='2978500' WHERE kode_barcode='00036359' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5102500',harga_beli ='5102500' WHERE kode_barcode='00036412' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3236500',harga_beli ='3236500' WHERE kode_barcode='00036416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4844500',harga_beli ='4844500' WHERE kode_barcode='00036621' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4685500',harga_beli ='4685500' WHERE kode_barcode='00036623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4983500',harga_beli ='4983500' WHERE kode_barcode='00036624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4408000',harga_beli ='4408000' WHERE kode_barcode='00036626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5360500',harga_beli ='5360500' WHERE kode_barcode='00036627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4745500',harga_beli ='4745500' WHERE kode_barcode='00036628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5341000',harga_beli ='5341000' WHERE kode_barcode='00036629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6323500',harga_beli ='6323500' WHERE kode_barcode='00036763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6242000',harga_beli ='6242000' WHERE kode_barcode='00036764' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6201500',harga_beli ='6201500' WHERE kode_barcode='00036765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6181000',harga_beli ='6181000' WHERE kode_barcode='00036766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6059000',harga_beli ='6059000' WHERE kode_barcode='00036767' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2660500',harga_beli ='2660500' WHERE kode_barcode='00036790' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3316000',harga_beli ='3316000' WHERE kode_barcode='00036806' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3673000',harga_beli ='3673000' WHERE kode_barcode='00036808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2859000',harga_beli ='2859000' WHERE kode_barcode='00036844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4487000',harga_beli ='4487000' WHERE kode_barcode='00036848' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3673000',harga_beli ='3673000' WHERE kode_barcode='00036850' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3891500',harga_beli ='3891500' WHERE kode_barcode='00036852' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4388000',harga_beli ='4388000' WHERE kode_barcode='00036853' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3772500',harga_beli ='3772500' WHERE kode_barcode='00036855' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='14293500',harga_beli ='14293500' WHERE kode_barcode='00036906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='17669000',harga_beli ='17669000' WHERE kode_barcode='00036907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10410500',harga_beli ='10410500' WHERE kode_barcode='00036908' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6750500',harga_beli ='6750500' WHERE kode_barcode='00036909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10817000',harga_beli ='10817000' WHERE kode_barcode='00036912' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7421500',harga_beli ='7421500' WHERE kode_barcode='00036913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='18258500',harga_beli ='18258500' WHERE kode_barcode='00036914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='14456500',harga_beli ='14456500' WHERE kode_barcode='00036915' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11996000',harga_beli ='11996000' WHERE kode_barcode='00036916' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='20393500',harga_beli ='20393500' WHERE kode_barcode='00036918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4388000',harga_beli ='4388000' WHERE kode_barcode='00037019' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6572000',harga_beli ='6572000' WHERE kode_barcode='00037245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5897000',harga_beli ='5897000' WHERE kode_barcode='00037246' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4725500',harga_beli ='4725500' WHERE kode_barcode='00037250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5063000',harga_beli ='5063000' WHERE kode_barcode='00037252' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6016000',harga_beli ='6016000' WHERE kode_barcode='00037269' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5281500',harga_beli ='5281500' WHERE kode_barcode='00037272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5420500',harga_beli ='5420500' WHERE kode_barcode='00037273' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5102500',harga_beli ='5102500' WHERE kode_barcode='00037274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3713000',harga_beli ='3713000' WHERE kode_barcode='00037278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3057500',harga_beli ='3057500' WHERE kode_barcode='00037280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5102500',harga_beli ='5102500' WHERE kode_barcode='00037281' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5321000',harga_beli ='5321000' WHERE kode_barcode='00037283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3812000',harga_beli ='3812000' WHERE kode_barcode='00037284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7127500',harga_beli ='7127500' WHERE kode_barcode='00037288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4924000',harga_beli ='4924000' WHERE kode_barcode='00037289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5142500',harga_beli ='5142500' WHERE kode_barcode='00037813' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4266500',harga_beli ='4266500' WHERE kode_barcode='00038371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4266500',harga_beli ='4266500' WHERE kode_barcode='00038372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4245500',harga_beli ='4245500' WHERE kode_barcode='00038373' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4287000',harga_beli ='4287000' WHERE kode_barcode='00038375' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3621500',harga_beli ='3621500' WHERE kode_barcode='00038376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3621500',harga_beli ='3621500' WHERE kode_barcode='00038377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7450500',harga_beli ='7450500' WHERE kode_barcode='00038378' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9677000',harga_beli ='9677000' WHERE kode_barcode='00038380' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='13152500',harga_beli ='13152500' WHERE kode_barcode='00038381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7076000',harga_beli ='7076000' WHERE kode_barcode='00038382' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3475500',harga_beli ='3475500' WHERE kode_barcode='00038383' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8948500',harga_beli ='8948500' WHERE kode_barcode='00038385' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9177500',harga_beli ='9177500' WHERE kode_barcode='00038386' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9219500',harga_beli ='9219500' WHERE kode_barcode='00038387' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3014000',harga_beli ='3014000' WHERE kode_barcode='00038388' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3054500',harga_beli ='3054500' WHERE kode_barcode='00038389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3295500',harga_beli ='3295500' WHERE kode_barcode='00038390' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3376000',harga_beli ='3376000' WHERE kode_barcode='00038391' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3275500',harga_beli ='3275500' WHERE kode_barcode='00038393' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3335500',harga_beli ='3335500' WHERE kode_barcode='00038394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1788500',harga_beli ='1788500' WHERE kode_barcode='00038396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1748500',harga_beli ='1748500' WHERE kode_barcode='00038397' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2250500',harga_beli ='2250500' WHERE kode_barcode='00038399' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2552000',harga_beli ='2552000' WHERE kode_barcode='00038400' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2612500',harga_beli ='2612500' WHERE kode_barcode='00038401' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2110000',harga_beli ='2110000' WHERE kode_barcode='00038402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2130000',harga_beli ='2130000' WHERE kode_barcode='00038403' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2713000',harga_beli ='2713000' WHERE kode_barcode='00038404' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1728500',harga_beli ='1728500' WHERE kode_barcode='00038405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2471500',harga_beli ='2471500' WHERE kode_barcode='00038407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2471500',harga_beli ='2471500' WHERE kode_barcode='00038408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2451500',harga_beli ='2451500' WHERE kode_barcode='00038409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2190500',harga_beli ='2190500' WHERE kode_barcode='00038411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4662000',harga_beli ='4662000' WHERE kode_barcode='00038419' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4662000',harga_beli ='4662000' WHERE kode_barcode='00038420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4762500',harga_beli ='4762500' WHERE kode_barcode='00038421' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4662000',harga_beli ='4662000' WHERE kode_barcode='00038422' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4400500',harga_beli ='4400500' WHERE kode_barcode='00038423' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5807000',harga_beli ='5807000' WHERE kode_barcode='00038424' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6169000',harga_beli ='6169000' WHERE kode_barcode='00038425' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4883000',harga_beli ='4883000' WHERE kode_barcode='00038427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4581500',harga_beli ='4581500' WHERE kode_barcode='00038428' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4360500',harga_beli ='4360500' WHERE kode_barcode='00038429' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4883000',harga_beli ='4883000' WHERE kode_barcode='00038430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4360500',harga_beli ='4360500' WHERE kode_barcode='00038431' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='12036000',harga_beli ='12036000' WHERE kode_barcode='00038433' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='12096000',harga_beli ='12096000' WHERE kode_barcode='00038434' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10146000',harga_beli ='10146000' WHERE kode_barcode='00038435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10390000',harga_beli ='10390000' WHERE kode_barcode='00038436' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2440000',harga_beli ='2440000' WHERE kode_barcode='00038437' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2481000',harga_beli ='2481000' WHERE kode_barcode='00038438' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2501000',harga_beli ='2501000' WHERE kode_barcode='00038439' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6954000',harga_beli ='6954000' WHERE kode_barcode='00038441' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2399500',harga_beli ='2399500' WHERE kode_barcode='00038442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2847000',harga_beli ='2847000' WHERE kode_barcode='00038444' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7970500',harga_beli ='7970500' WHERE kode_barcode='00038446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7828000',harga_beli ='7828000' WHERE kode_barcode='00038447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8580500',harga_beli ='8580500' WHERE kode_barcode='00038449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7970500',harga_beli ='7970500' WHERE kode_barcode='00038451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='13561500',harga_beli ='13561500' WHERE kode_barcode='00038452' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='13216000',harga_beli ='13216000' WHERE kode_barcode='00038453' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='16733500',harga_beli ='16733500' WHERE kode_barcode='00038454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4601500',harga_beli ='4601500' WHERE kode_barcode='00038534' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4179500',harga_beli ='4179500' WHERE kode_barcode='00038535' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1909000',harga_beli ='1909000' WHERE kode_barcode='00038536' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2431500',harga_beli ='2431500' WHERE kode_barcode='00038537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2572000',harga_beli ='2572000' WHERE kode_barcode='00038538' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3456000',harga_beli ='3456000' WHERE kode_barcode='00038540' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5345000',harga_beli ='5345000' WHERE kode_barcode='00038541' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1808500',harga_beli ='1808500' WHERE kode_barcode='00038543' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1808500',harga_beli ='1808500' WHERE kode_barcode='00038545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2009500',harga_beli ='2009500' WHERE kode_barcode='00038547' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1949500',harga_beli ='1949500' WHERE kode_barcode='00038548' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3757500',harga_beli ='3757500' WHERE kode_barcode='00038550' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3878000',harga_beli ='3878000' WHERE kode_barcode='00038551' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4360500',harga_beli ='4360500' WHERE kode_barcode='00038552' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5835500',harga_beli ='5835500' WHERE kode_barcode='00038553' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5571000',harga_beli ='5571000' WHERE kode_barcode='00038554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2826500',harga_beli ='2826500' WHERE kode_barcode='00038555' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='22813000',harga_beli ='22813000' WHERE kode_barcode='00038556' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4100000',harga_beli ='4100000' WHERE kode_barcode='00038557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9656500',harga_beli ='9656500' WHERE kode_barcode='00038559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2955500',harga_beli ='2955500' WHERE kode_barcode='00038561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1228000',harga_beli ='1228000' WHERE kode_barcode='00038564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1228000',harga_beli ='1228000' WHERE kode_barcode='00038565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1228000',harga_beli ='1228000' WHERE kode_barcode='00038566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6368500',harga_beli ='6368500' WHERE kode_barcode='00038567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4287000',harga_beli ='4287000' WHERE kode_barcode='00038568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6222500',harga_beli ='6222500' WHERE kode_barcode='00038569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4308000',harga_beli ='4308000' WHERE kode_barcode='00038570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4266500',harga_beli ='4266500' WHERE kode_barcode='00038571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11383500',harga_beli ='11383500' WHERE kode_barcode='00038573' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10655000',harga_beli ='10655000' WHERE kode_barcode='00038575' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2332500',harga_beli ='2332500' WHERE kode_barcode='00038772' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='13156000',harga_beli ='13156000' WHERE kode_barcode='00038875' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='123188000',harga_beli ='123188000' WHERE kode_barcode='00038877' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='47593500',harga_beli ='47593500' WHERE kode_barcode='00038891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='44339500',harga_beli ='44339500' WHERE kode_barcode='00038892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='38671000',harga_beli ='38671000' WHERE kode_barcode='00038893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4672500',harga_beli ='4672500' WHERE kode_barcode='00038894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5854000',harga_beli ='5854000' WHERE kode_barcode='00038895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11453000',harga_beli ='11453000' WHERE kode_barcode='00038896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7846500',harga_beli ='7846500' WHERE kode_barcode='00038897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3533000',harga_beli ='3533000' WHERE kode_barcode='00038898' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10289500',harga_beli ='10289500' WHERE kode_barcode='00038899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8017500',harga_beli ='8017500' WHERE kode_barcode='00038900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5508500',harga_beli ='5508500' WHERE kode_barcode='00038901' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3527000',harga_beli ='3527000' WHERE kode_barcode='00038902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8981000',harga_beli ='8981000' WHERE kode_barcode='00038903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5145000',harga_beli ='5145000' WHERE kode_barcode='00038904' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='12326000',harga_beli ='12326000' WHERE kode_barcode='00038905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='14198000',harga_beli ='14198000' WHERE kode_barcode='00038906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7890000',harga_beli ='7890000' WHERE kode_barcode='00038907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10653500',harga_beli ='10653500' WHERE kode_barcode='00038908' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5472000',harga_beli ='5472000' WHERE kode_barcode='00038923' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='27814500',harga_beli ='27814500' WHERE kode_barcode='00038924' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='22106000',harga_beli ='22106000' WHERE kode_barcode='00038925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2359000',harga_beli ='2359000' WHERE kode_barcode='00038950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5821500',harga_beli ='5821500' WHERE kode_barcode='00038951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='15486000',harga_beli ='15486000' WHERE kode_barcode='00039103' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3863500',harga_beli ='3863500' WHERE kode_barcode='00039104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5140500',harga_beli ='5140500' WHERE kode_barcode='00039105' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='18022000',harga_beli ='18022000' WHERE kode_barcode='00039107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3829500',harga_beli ='3829500' WHERE kode_barcode='00039109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3559000',harga_beli ='3559000' WHERE kode_barcode='00039110' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4349500',harga_beli ='4349500' WHERE kode_barcode='00039111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6659500',harga_beli ='6659500' WHERE kode_barcode='00039113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4666000',harga_beli ='4666000' WHERE kode_barcode='00039163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3951000',harga_beli ='3951000' WHERE kode_barcode='00039164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3057500',harga_beli ='3057500' WHERE kode_barcode='00039165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4090000',harga_beli ='4090000' WHERE kode_barcode='00039166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3574000',harga_beli ='3574000' WHERE kode_barcode='00039168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3335500',harga_beli ='3335500' WHERE kode_barcode='00039169' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3077500',harga_beli ='3077500' WHERE kode_barcode='00039170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3018000',harga_beli ='3018000' WHERE kode_barcode='00039171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='25287500',harga_beli ='25287500' WHERE kode_barcode='00039222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='12905000',harga_beli ='12905000' WHERE kode_barcode='00039223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5054000',harga_beli ='5054000' WHERE kode_barcode='00039224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4545000',harga_beli ='4545000' WHERE kode_barcode='00039225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3295000',harga_beli ='3295000' WHERE kode_barcode='00039226' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7676500',harga_beli ='7676500' WHERE kode_barcode='00039227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10962500',harga_beli ='10962500' WHERE kode_barcode='00039228' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7363000',harga_beli ='7363000' WHERE kode_barcode='00039229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7235500',harga_beli ='7235500' WHERE kode_barcode='00039230' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6617500',harga_beli ='6617500' WHERE kode_barcode='00039231' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5090500',harga_beli ='5090500' WHERE kode_barcode='00039233' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3218000',harga_beli ='3218000' WHERE kode_barcode='00039235' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4144000',harga_beli ='4144000' WHERE kode_barcode='00039236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2395000',harga_beli ='2395000' WHERE kode_barcode='00039237' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2361000',harga_beli ='2361000' WHERE kode_barcode='00039238' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5321000',harga_beli ='5321000' WHERE kode_barcode='00039278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5472000',harga_beli ='5472000' WHERE kode_barcode='00039444' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2751000',harga_beli ='2751000' WHERE kode_barcode='00039547' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2751000',harga_beli ='2751000' WHERE kode_barcode='00039549' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2751000',harga_beli ='2751000' WHERE kode_barcode='00039551' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2751000',harga_beli ='2751000' WHERE kode_barcode='00039552' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2800000',harga_beli ='2800000' WHERE kode_barcode='00039558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7035500',harga_beli ='7035500' WHERE kode_barcode='00039795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4127000',harga_beli ='4127000' WHERE kode_barcode='00040124' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1279000',harga_beli ='1279000' WHERE kode_barcode='00040125' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1318000',harga_beli ='1318000' WHERE kode_barcode='00040126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1279000',harga_beli ='1279000' WHERE kode_barcode='00040127' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1376000',harga_beli ='1376000' WHERE kode_barcode='00040128' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1647000',harga_beli ='1647000' WHERE kode_barcode='00040129' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1240500',harga_beli ='1240500' WHERE kode_barcode='00040130' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1318000',harga_beli ='1318000' WHERE kode_barcode='00040131' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1763500',harga_beli ='1763500' WHERE kode_barcode='00040133' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2170500',harga_beli ='2170500' WHERE kode_barcode='00040134' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2538500',harga_beli ='2538500' WHERE kode_barcode='00040135' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2538500',harga_beli ='2538500' WHERE kode_barcode='00040136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2403000',harga_beli ='2403000' WHERE kode_barcode='00040137' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2364000',harga_beli ='2364000' WHERE kode_barcode='00040138' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2306000',harga_beli ='2306000' WHERE kode_barcode='00040139' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1783000',harga_beli ='1783000' WHERE kode_barcode='00040140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2577000',harga_beli ='2577000' WHERE kode_barcode='00040142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2519000',harga_beli ='2519000' WHERE kode_barcode='00040143' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2015500',harga_beli ='2015500' WHERE kode_barcode='00040144' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3139000',harga_beli ='3139000' WHERE kode_barcode='00040145' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2325500',harga_beli ='2325500' WHERE kode_barcode='00040146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3139000',harga_beli ='3139000' WHERE kode_barcode='00040147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2906500',harga_beli ='2906500' WHERE kode_barcode='00040148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2499500',harga_beli ='2499500' WHERE kode_barcode='00040149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2480500',harga_beli ='2480500' WHERE kode_barcode='00040150' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1163000',harga_beli ='1163000' WHERE kode_barcode='00040151' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1531000',harga_beli ='1531000' WHERE kode_barcode='00040152' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1163000',harga_beli ='1163000' WHERE kode_barcode='00040153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1143500',harga_beli ='1143500' WHERE kode_barcode='00040154' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1531000',harga_beli ='1531000' WHERE kode_barcode='00040155' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2170500',harga_beli ='2170500' WHERE kode_barcode='00040156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1240500',harga_beli ='1240500' WHERE kode_barcode='00040157' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2131500',harga_beli ='2131500' WHERE kode_barcode='00040158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2596500',harga_beli ='2596500' WHERE kode_barcode='00040159' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1976500',harga_beli ='1976500' WHERE kode_barcode='00040160' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1666500',harga_beli ='1666500' WHERE kode_barcode='00040161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1744000',harga_beli ='1744000' WHERE kode_barcode='00040162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1414500',harga_beli ='1414500' WHERE kode_barcode='00040163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4728000',harga_beli ='4728000' WHERE kode_barcode='00040164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9436000',harga_beli ='9436000' WHERE kode_barcode='00040165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5483500',harga_beli ='5483500' WHERE kode_barcode='00040166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9533000',harga_beli ='9533000' WHERE kode_barcode='00040167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4708500',harga_beli ='4708500' WHERE kode_barcode='00040168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5968000',harga_beli ='5968000' WHERE kode_barcode='00040169' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6626500',harga_beli ='6626500' WHERE kode_barcode='00040170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8506000',harga_beli ='8506000' WHERE kode_barcode='00040171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='12865500',harga_beli ='12865500' WHERE kode_barcode='00040172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5871000',harga_beli ='5871000' WHERE kode_barcode='00040173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6045500',harga_beli ='6045500' WHERE kode_barcode='00040174' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6026000',harga_beli ='6026000' WHERE kode_barcode='00040176' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4069000',harga_beli ='4069000' WHERE kode_barcode='00040177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5968000',harga_beli ='5968000' WHERE kode_barcode='00040178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5348000',harga_beli ='5348000' WHERE kode_barcode='00040179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1996000',harga_beli ='1996000' WHERE kode_barcode='00040180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6375000',harga_beli ='6375000' WHERE kode_barcode='00040181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11318000',harga_beli ='11318000' WHERE kode_barcode='00040182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7022000',harga_beli ='7022000' WHERE kode_barcode='00040183' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7375500',harga_beli ='7375500' WHERE kode_barcode='00040184' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7277000',harga_beli ='7277000' WHERE kode_barcode='00040185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8218500',harga_beli ='8218500' WHERE kode_barcode='00040186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3550500',harga_beli ='3550500' WHERE kode_barcode='00040187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3629000',harga_beli ='3629000' WHERE kode_barcode='00040188' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8258000',harga_beli ='8258000' WHERE kode_barcode='00040189' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='22635500',harga_beli ='22635500' WHERE kode_barcode='00040190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3864500',harga_beli ='3864500' WHERE kode_barcode='00040193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11004000',harga_beli ='11004000' WHERE kode_barcode='00040194' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6453500',harga_beli ='6453500' WHERE kode_barcode='00040195' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5061000',harga_beli ='5061000' WHERE kode_barcode='00040196' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10945000',harga_beli ='10945000' WHERE kode_barcode='00040197' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7905000',harga_beli ='7905000' WHERE kode_barcode='00040198' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5884500',harga_beli ='5884500' WHERE kode_barcode='00040199' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3982000',harga_beli ='3982000' WHERE kode_barcode='00040200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3884000',harga_beli ='3884000' WHERE kode_barcode='00040201' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3864500',harga_beli ='3864500' WHERE kode_barcode='00040202' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5727500',harga_beli ='5727500' WHERE kode_barcode='00040203' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3982000',harga_beli ='3982000' WHERE kode_barcode='00040204' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4041000',harga_beli ='4041000' WHERE kode_barcode='00040205' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4060500',harga_beli ='4060500' WHERE kode_barcode='00040206' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4099500',harga_beli ='4099500' WHERE kode_barcode='00040207' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4041000',harga_beli ='4041000' WHERE kode_barcode='00040208' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4158500',harga_beli ='4158500' WHERE kode_barcode='00040209' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1727500',harga_beli ='1727500' WHERE kode_barcode='00040210' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1668000',harga_beli ='1668000' WHERE kode_barcode='00040211' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1191500',harga_beli ='1191500' WHERE kode_barcode='00040212' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1152000',harga_beli ='1152000' WHERE kode_barcode='00040213' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='1152000',harga_beli ='1152000' WHERE kode_barcode='00040214' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2581000',harga_beli ='2581000' WHERE kode_barcode='00040215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10820500',harga_beli ='10820500' WHERE kode_barcode='00040216' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='11138000',harga_beli ='11138000' WHERE kode_barcode='00040217' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4765000',harga_beli ='4765000' WHERE kode_barcode='00040218' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3931500',harga_beli ='3931500' WHERE kode_barcode='00040219' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5579000',harga_beli ='5579000' WHERE kode_barcode='00040220' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2733000',harga_beli ='2733000' WHERE kode_barcode='00040222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2813500',harga_beli ='2813500' WHERE kode_barcode='00040223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2110000',harga_beli ='2110000' WHERE kode_barcode='00040224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7635500',harga_beli ='7635500' WHERE kode_barcode='00040225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2793000',harga_beli ='2793000' WHERE kode_barcode='00040226' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7856500',harga_beli ='7856500' WHERE kode_barcode='00040227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6369500',harga_beli ='6369500' WHERE kode_barcode='00040229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5084000',harga_beli ='5084000' WHERE kode_barcode='00040230' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5224500',harga_beli ='5224500' WHERE kode_barcode='00040231' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3637000',harga_beli ='3637000' WHERE kode_barcode='00040232' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6992500',harga_beli ='6992500' WHERE kode_barcode='00040233' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6289500',harga_beli ='6289500' WHERE kode_barcode='00040234' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5887500',harga_beli ='5887500' WHERE kode_barcode='00040235' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5586000',harga_beli ='5586000' WHERE kode_barcode='00040236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4099000',harga_beli ='4099000' WHERE kode_barcode='00040237' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5666500',harga_beli ='5666500' WHERE kode_barcode='00040238' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5927500',harga_beli ='5927500' WHERE kode_barcode='00040239' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4059000',harga_beli ='4059000' WHERE kode_barcode='00040240' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3958500',harga_beli ='3958500' WHERE kode_barcode='00040241' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5887500',harga_beli ='5887500' WHERE kode_barcode='00040242' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4762500',harga_beli ='4762500' WHERE kode_barcode='00040243' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='13703500',harga_beli ='13703500' WHERE kode_barcode='00040244' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5988000',harga_beli ='5988000' WHERE kode_barcode='00040245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='10368000',harga_beli ='10368000' WHERE kode_barcode='00040246' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6008000',harga_beli ='6008000' WHERE kode_barcode='00040247' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='8017500',harga_beli ='8017500' WHERE kode_barcode='00040248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4320000',harga_beli ='4320000' WHERE kode_barcode='00040249' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7896500',harga_beli ='7896500' WHERE kode_barcode='00040250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7716000',harga_beli ='7716000' WHERE kode_barcode='00040252' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4360500',harga_beli ='4360500' WHERE kode_barcode='00040253' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='12839500',harga_beli ='12839500' WHERE kode_barcode='00040254' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='12658500',harga_beli ='12658500' WHERE kode_barcode='00040255' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4220000',harga_beli ='4220000' WHERE kode_barcode='00040256' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5787000',harga_beli ='5787000' WHERE kode_barcode='00040258' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3556500',harga_beli ='3556500' WHERE kode_barcode='00040259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3958500',harga_beli ='3958500' WHERE kode_barcode='00040261' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6068500',harga_beli ='6068500' WHERE kode_barcode='00040262' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3958500',harga_beli ='3958500' WHERE kode_barcode='00040263' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='6048000',harga_beli ='6048000' WHERE kode_barcode='00040264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3878000',harga_beli ='3878000' WHERE kode_barcode='00040265' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4400500',harga_beli ='4400500' WHERE kode_barcode='00040266' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4441000',harga_beli ='4441000' WHERE kode_barcode='00040267' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4079000',harga_beli ='4079000' WHERE kode_barcode='00040270' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7529500',harga_beli ='7529500' WHERE kode_barcode='00040271' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='7077000',harga_beli ='7077000' WHERE kode_barcode='00040272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='25735000',harga_beli ='25735000' WHERE kode_barcode='00040273' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5225500',harga_beli ='5225500' WHERE kode_barcode='00040274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='2945500',harga_beli ='2945500' WHERE kode_barcode='00040347' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9093000',harga_beli ='9093000' WHERE kode_barcode='00040368' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5222000',harga_beli ='5222000' WHERE kode_barcode='00040369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5023000',harga_beli ='5023000' WHERE kode_barcode='00040370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4149500',harga_beli ='4149500' WHERE kode_barcode='00040371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3911500',harga_beli ='3911500' WHERE kode_barcode='00040372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3613500',harga_beli ='3613500' WHERE kode_barcode='00040373' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='25116000',harga_beli ='25116000' WHERE kode_barcode='00040584' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='9508000',harga_beli ='9508000' WHERE kode_barcode='00040608' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='13156000',harga_beli ='13156000' WHERE kode_barcode='00040615' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3057500',harga_beli ='3057500' WHERE kode_barcode='00040622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3316000',harga_beli ='3316000' WHERE kode_barcode='00040623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4130000',harga_beli ='4130000' WHERE kode_barcode='00040624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4209000',harga_beli ='4209000' WHERE kode_barcode='00040625' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4666000',harga_beli ='4666000' WHERE kode_barcode='00040626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4090000',harga_beli ='4090000' WHERE kode_barcode='00040628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4904000',harga_beli ='4904000' WHERE kode_barcode='00040629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='3514500',harga_beli ='3514500' WHERE kode_barcode='00040630' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='4130000',harga_beli ='4130000' WHERE kode_barcode='00040688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='5341000',harga_beli ='5341000' WHERE kode_barcode='00040689' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='13156000',harga_beli ='13156000' WHERE kode_barcode='00040698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2392000',harga_jual='13156000',harga_beli ='13156000' WHERE kode_barcode='00040700' LIMIT 1;
UPDATE tm_group SET harga='2392000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2392000','kasir','2026-01-09 16:01:11');
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-260109-0001','kasir','1',' 850K-13-00','TOKO','MMPER','PMM-YGXD-33-0','CINCIN SILVER 925 ','','2.240','1','100.00','52000','0','0','16800','850000','0','0','0','850000','NIS','00036979','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YGXD-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.240',berat_jual_asli=berat_jual_asli+'2.240',stock_jual='1',berat_akhir=berat_akhir-'2.240',berat_akhir_asli=berat_akhir_asli-'2.240',stock_akhir='0' WHERE tanggal='2026-01-09' AND kode_barang='PMM-YGXD-33-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-260109-0001','2026-01-09','2.240','2026-01-09','17:45:07','PLG0008738','850000','850000','0','850000','0','kasir','2026-01-09 17:45:07','FJ-260109-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('2026-01-09','FJ-260109-0001','2026-01-09','17:45:07','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-260109-0001','2026-01-09','2026-01-09 17:45:07','PENJUALAN : FJ-260109-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-260109-0002','D','2026-01-09','17:45:07','TBC','PENJUALAN','FJ-260109-0001','19281109514','850000','19281959514','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-260109-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-260109-0002','kasir','1',' 700K-17-71','TOKO','MMPER','PMM-ZAXG-3-0','CINCIN SILVER 925 ','','4.710','1','100.00','289000','0','0','16800','700000','0','0','0','700000','GEISYA','00040766','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZAXG-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.710',berat_jual_asli=berat_jual_asli+'4.710',stock_jual='1',berat_akhir=berat_akhir-'4.710',berat_akhir_asli=berat_akhir_asli-'4.710',stock_akhir='0' WHERE tanggal='2026-01-09' AND kode_barang='PMM-ZAXG-3-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-260109-0002','2026-01-09','4.710','2026-01-09','17:46:13','PLG0008739','700000','700000','0','700000','0','kasir','2026-01-09 17:46:12','FJ-260109-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('2026-01-09','FJ-260109-0002','2026-01-09','17:46:13','GEISYA','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-260109-0002','2026-01-09','2026-01-09 17:46:12','PENJUALAN : FJ-260109-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-260109-0003','D','2026-01-09','17:46:13','TBC','PENJUALAN','FJ-260109-0002','19281959514','700000','19282659514','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-260109-0002' 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-260109-0003','kasir','1',' 700K-20-70','TOKO','MMPER','PMM-YLBE-13-0','CINCIN SILVER 925 ','','2.720','1','100.00','167000','0','0','16800','700000','0','0','0','700000','NIS','00040697','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YLBE-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.720',berat_jual_asli=berat_jual_asli+'2.720',stock_jual='1',berat_akhir=berat_akhir-'2.720',berat_akhir_asli=berat_akhir_asli-'2.720',stock_akhir='0' WHERE tanggal='2026-01-09' AND kode_barang='PMM-YLBE-13-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-260109-0003','2026-01-09','2.720','2026-01-09','17:48:00','PLG0008740','700000','700000','0','700000','0','kasir','2026-01-09 17:48:00','FJ-260109-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('2026-01-09','FJ-260109-0003','2026-01-09','17:48:00','NIS','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-260109-0003','2026-01-09','2026-01-09 17:48:00','PENJUALAN : FJ-260109-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-260109-0004','D','2026-01-09','17:48:00','TBC','PENJUALAN','FJ-260109-0003','19282659514','700000','19283359514','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-260109-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260109-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260109-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260109-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260109-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260109-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260109-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260109-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260109-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260109-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-01-09 ','17:59:29');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01577','HELMI','1','PLD','WEDDING RING','','','3.000','','10.00','1','2365000','300000','0','750000','1650000','zirkon 23butir','size 18 grf Deny 13.02.26','krum putih seperti contoh','230000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260109-0004','2026-01-09','2026-01-09 18:12:20','PESANAN : DP-01577','.','TBC','940000','940000');
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-260109-0005','D','2026-01-09','18:12:20','TBC','PESANAN','DP-01577','19283359514','940000','19284299514','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01577','2026-01-09','2026-01-09','18:12:20','PLG0008741','HELMI','2026-01-23','kasir','2026-01-09 18:12:20','3.000','0','0','0','940000','0','750000','1880000','1880000','940000');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01578','HELMI','1','PLD','WEDDING RING','','','3.500','','10.00','1','2365000','300000','0','750000','1800000','size 18 permata request 1butir','grf Hilda 13.02.26','krum putih spt contoh','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260109-0005','2026-01-09','2026-01-09 18:18:49','PESANAN : DP-01578','.','TBC','900000','900000');
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-260109-0006','D','2026-01-09','18:18:49','TBC','PESANAN','DP-01578','19284299514','900000','19285199514','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01578','2026-01-09','2026-01-09','18:18:49','PLG0008742','HELMI','2026-02-05','kasir','2026-01-09 18:18:49','3.500','0','0','0','900000','0','750000','1800000','1800000','900000');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01579','GEISYA','1','PER','CINCIN NIKAH','','','1.000','','925.00','1','60000','0','950000','0','950000','size 21 pakai mata','krum putih','grf ayos yeni 8 2 26','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260109-0006','2026-01-09','2026-01-09 18:19:09','PESANAN : DP-01579','.','TBC','950000','950000');
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-260109-0007','D','2026-01-09','18:19:09','TBC','PESANAN','DP-01579','19285199514','950000','19286149514','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01579','2026-01-09','2026-01-09','18:19:09','PLG0008743','GEISYA','2026-01-25','kasir','2026-01-09 18:19:09','1.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01668','NIS','1','2PCS','CEWE RESIZE KE 11 GRF AMAR DAN CWO RESIZE KE 19 GRF TITIK KRUM KOMBINASI ROSEGOLD','6.950','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01668','2026-01-09','2026-01-09','18:21:06','PLG0008744','kasir','2026-01-10','kasir','2026-01-09 18:21:06','6.950','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-01-09 ','18:21:30');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01669','NIS','1','1 PCS','RESIZE KE 21 GRF YENI AYOS 8 2 26','2.720','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01669','2026-01-09','2026-01-09','18:35:06','PLG0008745','kasir','2026-01-10','kasir','2026-01-09 18:35:06','2.720','0','0','0','0','0','0','0','0');
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-260109-0004','kasir','1',' 700K-21-21','TOKO','BIPPER','PBDG-YLBD-15-0','CINCIN SILVER 925 ','','2.110','1','100.00','130000','0','0','16800','700000','0','0','0','700000','NITA','00040679','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YLBD-15-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='2026-01-09' AND kode_barang='PBDG-YLBD-15-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-260109-0004','2026-01-09','2.110','2026-01-09','19:23:21','PLG0008746','700000','700000','0','700000','0','kasir','2026-01-09 19:23:20','FJ-260109-0004','','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('2026-01-09','FJ-260109-0004','2026-01-09','19:23:21','NITA','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-260109-0007','2026-01-09','2026-01-09 19:23:20','PENJUALAN : FJ-260109-0004','.','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-260109-0008','D','2026-01-09','19:23:21','TBC','PENJUALAN','FJ-260109-0004','19286149514','700000','19286849514','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-260109-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260109-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260109-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260109-0004';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01670','SULIS','1','CC PREAK','FONT VLADIMIR PUTIH DOF SEMPROT','2.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01670','2026-01-09','2026-01-09','19:28:10','PLG0008747','kasir','2026-01-19','kasir','2026-01-09 19:28:10','2.000','0','0','0','0','0','0','0','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01671','HELMI','1','1 SILVER','SZ 15 PUTIH GLOSY FONT VLADIMIR','1.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01671','2026-01-09','2026-01-09','19:29:41','PLG0008748','kasir','2026-01-19','kasir','2026-01-09 19:29:41','1.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-01-09 ','19:30:04');
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-260109-0005','kasir','1',' DP-01521BI','TOKO','BIPPSN','PSPRT-YLCX-7-0','CINCIN PERAK ','','2.690','1','100.00','165000','0','0','16800','700000','0','0','0','700000','HELMI','00040717','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YLCX-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.690',berat_jual_asli=berat_jual_asli+'2.690',stock_jual='1',berat_akhir=berat_akhir-'2.690',berat_akhir_asli=berat_akhir_asli-'2.690',stock_akhir='0' WHERE tanggal='2026-01-09' AND kode_barang='PSPRT-YLCX-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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-260109-0005','2026-01-09','2.690','2026-01-09','19:37:11','PLG0008749','700000','700000','0','700000','0','kasir','2026-01-09 19:37:10','FJ-260109-0005','DP-01521','700000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-09','FJ-260109-0005','2026-01-09','19:37:11','HELMI','700000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260109-0005' 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-260109-0006','kasir',' 1',' DP-01520BI','TOKO','BIPPSN','PSPRT-YLBC-1-0','CINCIN PERAK ','','2.010','1','100.00','124000','0','0','16800','950000','0','0','0','950000','HELMI','00040662','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-01-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YLBC-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.010',berat_jual_asli=berat_jual_asli+'2.010',stock_jual='1',berat_akhir=berat_akhir-'2.010',berat_akhir_asli=berat_akhir_asli-'2.010',stock_akhir='0' WHERE tanggal='2026-01-09' AND kode_barang='PSPRT-YLBC-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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-260109-0006','2026-01-09','2.010','2026-01-09','19:37:11','PLG0008750','950000','950000','0','950000','0','kasir','2026-01-09 19:37:10','FJ-260109-0005','DP-01520','950000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-09','FJ-260109-0006','2026-01-09','19:37:11','HELMI','950000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260109-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260109-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260109-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260109-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260109-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260109-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260109-0006';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-10','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-10';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-09';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-09';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-01-09' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-09';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-09';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-09';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-09';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202600 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
UPDATE tt_barang_saldo SET tanggal= '2026-01-10' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-09' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260110-0001','D','2026-01-10','20:05:00','TBC','SALDO AWAL','SALDO AWAL','0','19286849514','19286849514');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260110-0001','D','2026-01-10','20:05:00','BCD','SALDO AWAL','SALDO AWAL','0','1348483500','1348483500');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260110-0001','D','2026-01-10','20:05:00','BCK','SALDO AWAL','SALDO AWAL','0','1940208000','1940208000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260110-0001','D','2026-01-10','20:05:00','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260110-0001','D','2026-01-10','20:05:00','KET','SALDO AWAL','SALDO AWAL','0','135063000','135063000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260110-0001','D','2026-01-10','20:05:00','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260110-0001','D','2026-01-10','20:05:00','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260110-0001','D','2026-01-10','20:05:00','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260110-0001','D','2026-01-10','20:05:00','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260110-0001','D','2026-01-10','20:05:00','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260110-0001','D','2026-01-10','20:05:00','SHO','SALDO AWAL','SALDO AWAL','0','142865650','142865650');
UPDATE tp_system SET tgl_system='2026-01-10';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-01-09 ','20:30:41');